List of Pumping equipment and services in San Francisco

[
  {
    "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": "Pump suppliers,Pumping equipment and services,Petroleum Products Companies,Industrial equipment suppliers,Air compressor suppliers"
  },
  {
    "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": "Pumping equipment and services,Pump suppliers,Industrial engineers,Boiler suppliers,Water Pump Suppliers,Hot water system suppliers,Contractors,Heating contractors,Industrial equipment suppliers,Heating equipment suppliers"
  },
  {
    "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": "Pump suppliers,Pumping equipment and services,Manufacturers,Corporate campuses"
  },
  {
    "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": "Garages,Car Service Stations,Car repair and maintenances,Pump suppliers,Pumping equipment and services,Auto repair shops"
  },
  {
    "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": "Pumping equipment and services,Pump suppliers"
  },
  {
    "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": "AES Group, Inc.",
    "address": "43**********",
    "phone": "********9373",
    "email": "",
    "lat": 38.0142632,
    "lng": -122.5399338,
    "url": "ht**********",
    "country": "United States",
    "state": "California",
    "city": "San Francisco",
    "star_count": 5,
    "rating_count": 1,
    "category_name": "Industrial vacuum equipment suppliers,Air compressor repair services,Pumping equipment and services,Pump suppliers,Real Estate Builders & Construction Companies,Laboratory equipment suppliers,Construction companies,Air compressor suppliers"
  },
  {
    "name": "Pumps & Works",
    "address": "17**********",
    "phone": "********2241",
    "email": "",
    "lat": 37.4896083,
    "lng": -122.2098106,
    "url": "ht**********",
    "country": "United States",
    "state": "California",
    "city": "San Francisco",
    "star_count": 5,
    "rating_count": 2,
    "category_name": "Water Pump Suppliers,Pump suppliers,Pumping equipment and services,Plumbers,Swimming pool repair services,Water works"
  },
  {
    "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.8,
    "rating_count": 11,
    "category_name": "Rainwater tank suppliers,Water works,Drainage services,Architectural designers,General contractors,Pump suppliers,Pumping equipment and services,Irrigation equipment suppliers,Water Filter Suppliers,Water Pump Suppliers,Ecologists associations,Building designers,Construction companies,Fire protection consultants,Environmental consultants,Real Estate Builders & Construction Companies"
  }
]