List of Pumping equipment and services in California

[
  {
    "name": "Walnut Creek Vacuum & Electric Motor Service",
    "address": "19**********",
    "phone": "********4582",
    "email": "sa***@wc*******",
    "lat": 37.8973602,
    "lng": -122.067765,
    "url": "ht**********",
    "country": "United States",
    "state": "California",
    "city": "Acalanes Ridge",
    "star_count": 4.1,
    "rating_count": 33,
    "category_name": "Vacuum cleaner stores,Vacuum cleaner repair shops,Pump suppliers,Pumping equipment and services,Water Pump Suppliers,Electric motor repair shops"
  },
  {
    "name": "Cal Aqua",
    "address": "89**********",
    "phone": "********2778",
    "email": "mb******@ca*********",
    "lat": 38.4000363,
    "lng": -121.9547772,
    "url": "ht**********",
    "country": "United States",
    "state": "California",
    "city": "Vacaville",
    "star_count": 3.4,
    "rating_count": 5,
    "category_name": "Pump suppliers,Pumping equipment and services,Water Testing Laboratories,Water softening equipment suppliers,Water works equipment suppliers,Well drilling contractors,Water testing services,Water Pump Suppliers"
  },
  {
    "name": "United Rentals - Fluid Solutions: Pumps, Tanks, Filtration",
    "address": "20**********",
    "phone": "********6933",
    "email": "",
    "lat": 38.6763027,
    "lng": -121.7247219,
    "url": "ht**********",
    "country": "United States",
    "state": "California",
    "city": "Woodland",
    "star_count": 5,
    "rating_count": 2,
    "category_name": "Industrial equipment suppliers,Pipe suppliers,Equipment rental agencies,Water Pump Suppliers,Pumping equipment and services,Pump suppliers,Hose suppliers"
  },
  {
    "name": "PumpCo",
    "address": "67**********",
    "phone": "********1000",
    "email": "cu**********@pu********",
    "lat": 38.201265,
    "lng": -120.6937238,
    "url": "ht**********",
    "country": "United States",
    "state": "California",
    "city": "San Andreas",
    "star_count": 4.6,
    "rating_count": 81,
    "category_name": "Water Testing Laboratories,Pump suppliers,Pumping equipment and services,Pipe suppliers,Well drilling contractors,Water Pump Suppliers,Water Tank Cleaners,Water purification companies,Water works,Water testing services,Water tank cleaning services"
  },
  {
    "name": "Electric Motor Service - Pump & Well Supplies",
    "address": "19**********",
    "phone": "********4582",
    "email": "",
    "lat": 37.8974598,
    "lng": -122.0678094,
    "url": "ht**********",
    "country": "United States",
    "state": "California",
    "city": "Acalanes Ridge",
    "star_count": 5,
    "rating_count": 1,
    "category_name": "Swimming pool repair services,Electric motor repair shops,Water Pump Suppliers,Pumping equipment and services,Pump suppliers,Irrigation equipment suppliers"
  },
  {
    "name": "Oakville Pump Service Inc",
    "address": "23**********",
    "phone": "********2471",
    "email": "sa***@oa**********",
    "lat": 38.2933793,
    "lng": -122.3002127,
    "url": "ht**********",
    "country": "United States",
    "state": "California",
    "city": "Napa",
    "star_count": 4.7,
    "rating_count": 3,
    "category_name": "Pump suppliers,Pumping equipment and services,Water Pump Suppliers,Water Tank Cleaners,Water purification companies,Water works equipment suppliers,Water Filter Suppliers,Water tank cleaning 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": "Pumping equipment and services,Pump suppliers"
  },
  {
    "name": "RJR Products Inc",
    "address": "19**********",
    "phone": "********7557",
    "email": "ro****@rj**********",
    "lat": 37.123007,
    "lng": -121.645182,
    "url": "ht**********",
    "country": "United States",
    "state": "California",
    "city": "Morgan Hill",
    "star_count": 5,
    "rating_count": 1,
    "category_name": "Pumping equipment and services,Pump suppliers,Repair services,Industrial vacuum equipment suppliers"
  },
  {
    "name": "Global Pump Service.",
    "address": "Pa**********",
    "phone": "",
    "email": "",
    "lat": 33.8938306,
    "lng": -118.1724928,
    "url": "ht**********",
    "country": "United States",
    "state": "California",
    "city": "Los Angeles",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Pumping equipment and services,Pump 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 works,Swimming pool repair services,Pump suppliers,Pumping equipment and services,Plumbers,Water Pump Suppliers"
  }
]