List of Pumping equipment and services in San Francisco

[
  {
    "name": "R.F. MacDonald Co.",
    "address": "25**********",
    "phone": "********0110",
    "email": "in**@rf**********",
    "lat": 37.6292523,
    "lng": -122.1150719,
    "url": "ht**********",
    "country": "United States",
    "state": "California",
    "city": "San Francisco",
    "star_count": 5,
    "rating_count": 6,
    "category_name": "Hot water system suppliers,Pump suppliers,Pumping equipment and services,Contractors,Water Pump Suppliers,Heating contractors,Heating equipment suppliers,Industrial engineers,Industrial equipment suppliers,Boiler suppliers"
  },
  {
    "name": "Northwest Pump",
    "address": "44**********",
    "phone": "********7867",
    "email": "cu**********@nw********",
    "lat": 37.5021752,
    "lng": -121.9578673,
    "url": "ht**********",
    "country": "United States",
    "state": "California",
    "city": "San Francisco",
    "star_count": 5,
    "rating_count": 1,
    "category_name": "Pumping equipment and services,Pump suppliers,Air compressor suppliers,Industrial equipment suppliers,Petroleum Products Companies"
  },
  {
    "name": "Pump Repair Services Co",
    "address": "40**********",
    "phone": "********2150",
    "email": "cu**********@pu**********",
    "lat": 37.7086244,
    "lng": -122.4099169,
    "url": "ht**********",
    "country": "United States",
    "state": "California",
    "city": "San Francisco",
    "star_count": 5,
    "rating_count": 1,
    "category_name": "Pumping equipment and services,Pump suppliers,Car repair and maintenances,Car Service Stations,Garages,Auto repair shops"
  },
  {
    "name": "Kashiyama-USA, Inc.",
    "address": "41**********",
    "phone": "********0070",
    "email": "sa***@ka**********",
    "lat": 37.5145328,
    "lng": -121.9817064,
    "url": "ht**********",
    "country": "United States",
    "state": "California",
    "city": "San Francisco",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Manufacturers,Corporate campuses,Pump suppliers,Pumping equipment and services"
  },
  {
    "name": "Signa Mechanical",
    "address": "29**********",
    "phone": "********4462",
    "email": "sa***@si*********",
    "lat": 37.6082928,
    "lng": -122.0812803,
    "url": "ht**********",
    "country": "United States",
    "state": "California",
    "city": "San Francisco",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Pump suppliers,Pumping equipment and services"
  },
  {
    "name": "Allied Fluid Products",
    "address": "53**********",
    "phone": "********3274",
    "email": "",
    "lat": 37.837414,
    "lng": -122.276077,
    "url": "ht**********",
    "country": "United States",
    "state": "California",
    "city": "San Francisco",
    "star_count": 4.3,
    "rating_count": 6,
    "category_name": "Hose suppliers,Pump suppliers,Pumping equipment and services,Gasket Manufacturers,Pipe suppliers"
  },
  {
    "name": "Simonds Machinery Co. Northern California",
    "address": "25**********",
    "phone": "********9900",
    "email": "",
    "lat": 37.648959,
    "lng": -122.3995936,
    "url": "ht**********",
    "country": "United States",
    "state": "California",
    "city": "San Francisco",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Pump suppliers,Pumping equipment and services"
  },
  {
    "name": "Dig Cooperative Inc.",
    "address": "25**********",
    "phone": "********4865",
    "email": "",
    "lat": 37.81836,
    "lng": -122.284279,
    "url": "ht**********",
    "country": "United States",
    "state": "California",
    "city": "San Francisco",
    "star_count": 4.9,
    "rating_count": 8,
    "category_name": "Water Filter Suppliers,General contractors,Ecologists associations,Building designers,Irrigation equipment suppliers,Pumping equipment and services,Pump suppliers,Drainage services,Architectural designers"
  },
  {
    "name": "Pacific Plumbing",
    "address": "95**********",
    "phone": "********0697",
    "email": "",
    "lat": 37.507836,
    "lng": -122.254756,
    "url": "",
    "country": "United States",
    "state": "California",
    "city": "San Francisco",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Pump suppliers,Pumping equipment and services"
  },
  {
    "name": "Rescue Rooter Bay Area",
    "address": "82**********",
    "phone": "********1313",
    "email": "",
    "lat": 37.5966848,
    "lng": -122.3672843,
    "url": "ht**********",
    "country": "United States",
    "state": "California",
    "city": "San Francisco",
    "star_count": 3.7,
    "rating_count": 18,
    "category_name": "Plumbers,Drainage services,Water Testing Laboratories,Pumping equipment and services,Pump suppliers,Water Filter Suppliers,Water testing services,Repair services,Septic system services,Gas installation services,Water purification companies,Water Pump Suppliers"
  }
]