قائمة شركات المرافق المائية في California

[
  {
    "name": "Desert Water Agency",
    "address": "12**********",
    "phone": "********4971",
    "email": "sg*****@dw*****",
    "lat": 33.8068962,
    "lng": -116.4917297,
    "url": "ht**********",
    "country": "United States",
    "state": "California",
    "city": "Palm Springs",
    "star_count": 2.6,
    "rating_count": 19,
    "category_name": "Water utility companies,Local government offices"
  },
  {
    "name": "Calaveras County Water District",
    "address": "12**********",
    "phone": "********3543",
    "email": "hrhr@cc******",
    "lat": 38.1807654,
    "lng": -120.6779547,
    "url": "ht**********",
    "country": "United States",
    "state": "California",
    "city": "San Andreas",
    "star_count": 1.9,
    "rating_count": 19,
    "category_name": "Water utility companies,Non-profit organizations"
  },
  {
    "name": "Global Water Instrumentation",
    "address": "11**********",
    "phone": "********8828",
    "email": "in**@YS*****",
    "lat": 38.6176167,
    "lng": -121.253024,
    "url": "ht**********",
    "country": "United States",
    "state": "California",
    "city": "Sacramento",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Water utility companies"
  },
  {
    "name": "Casitas Municipal Water District",
    "address": "10**********",
    "phone": "********2251",
    "email": "cu**********@ca**********",
    "lat": 34.4024357,
    "lng": -119.2998967,
    "url": "ht**********",
    "country": "United States",
    "state": "California",
    "city": "Oxnard",
    "star_count": 2.5,
    "rating_count": 2,
    "category_name": "Water utility companies"
  },
  {
    "name": "Pure Source Water Inc",
    "address": "Sa**********",
    "phone": "********7420",
    "email": "ac******@ps*******",
    "lat": 36.9740596,
    "lng": -122.0307778,
    "url": "ht**********",
    "country": "United States",
    "state": "California",
    "city": "Santa Cruz",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Water utility companies"
  },
  {
    "name": "Santa Margarita Water District",
    "address": "26**********",
    "phone": "********6420",
    "email": "cu**********@sm******",
    "lat": 33.5813257,
    "lng": -117.6328308,
    "url": "ht**********",
    "country": "United States",
    "state": "California",
    "city": "Mission Viejo",
    "star_count": 2.3,
    "rating_count": 31,
    "category_name": "Water utility companies"
  },
  {
    "name": "Montague Water Conservation",
    "address": "12**********",
    "phone": "********3371",
    "email": "mw**@at*****",
    "lat": 41.7279147,
    "lng": -122.5280909,
    "url": "ht**********",
    "country": "United States",
    "state": "California",
    "city": "Montague",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Water utility companies"
  },
  {
    "name": "City of Lakewood Water Resources Department",
    "address": "58**********",
    "phone": "********9771",
    "email": "cu**********@gs*********",
    "lat": 33.842453,
    "lng": -118.1191587,
    "url": "ht**********",
    "country": "United States",
    "state": "California",
    "city": "Los Angeles",
    "star_count": 5,
    "rating_count": 1,
    "category_name": "Water utility companies"
  },
  {
    "name": "Suburban Water Systems",
    "address": "Wh**********",
    "phone": "********8219",
    "email": "su**********@sw******",
    "lat": 33.9716796,
    "lng": -118.0212133,
    "url": "ht**********",
    "country": "United States",
    "state": "California",
    "city": "Los Angeles",
    "star_count": 1.6,
    "rating_count": 7,
    "category_name": "Water utility companies"
  },
  {
    "name": "Hayward Water System",
    "address": "Fo**********",
    "phone": "********4600",
    "email": "in**@ha**********",
    "lat": 37.6708387,
    "lng": -122.0857885,
    "url": "ht**********",
    "country": "United States",
    "state": "California",
    "city": "San Francisco",
    "star_count": 2,
    "rating_count": 12,
    "category_name": "Water utility companies"
  }
]