units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
78 rows where DES_TP = 14 and MNG_AG_TYP = 13 sorted by AGNCY_ID
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_WEB, MNG_AG_ID, COUNTY, YR_EST
MNG_AGENCY 17
- Yuba County Water Agency 48
- San Lorenzo Valley Water District 9
- Scotts Valley Water District 3
- Santa Clara Valley Water District 3
- Orange County Water District 2
- Ramona Municipal Water District 2
- Marin Municipal Water District 1
- Metropolitan Water District of Southern California 1
- Olivehurst Public Utility District 1
- Soquel Creek Water District 1
- Borrego Water District 1
- Helix Water District 1
- California Reclamation District 2140 1
- Olivenhain Municipal Water District 1
- Coastside County Water District 1
- Marina County Water District 1
- Santa Ynez River Water Conservation District 1
ACCESS_TYP 4
MNG_AG_TYP 1
- Water District · 78 ✖
DES_TP 1
- Local Other or Unknown · 78 ✖
Link | rowid | id | map | ACCESS_TYP | UNIT_ID | UNIT_NAME | SUID_NMA | AGNCY_ID ▼ | AGNCY_NAME | AGNCY_LEV | AGNCY_TYP | AGNCY_WEB | LAYER | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | PARK_URL | COUNTY | ACRES | LABEL_NAME | YR_EST | DES_TP | GAP_STS |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4470 | 4470 | 4469 | {"type": "Polygon", "coordinates": [[[-116.37329, 33.19965], [-116.36458, 33.19964], [-116.36453, 33.19257], [-116.37324, 33.19257], [-116.37329, 33.19965]]]} | Restricted Access 2 | 1194 | Unnamed site - Borrego Water District | 28622 | 2008 | Borrego Water District 764 | Special District 4 | Water District 13 | http://www.borregowd.org/ | Special District 4 | 2008 | Borrego Water District 745 | Special District 4 | Water District 13 | San Diego 4 | 157.534 | 0 | Local Other or Unknown 14 | 4 | ||
7871 | 7871 | 7870 | {"type": "Polygon", "coordinates": [[[-122.39608, 37.51947], [-122.38304, 37.51947], [-122.38303, 37.51405], [-122.38073, 37.51403], [-122.3807, 37.5086], [-122.37849, 37.5086], [-122.37849, 37.50594], [-122.383, 37.50594], [-122.38301, 37.50493], [-122.3869, 37.50493], [-122.38693, 37.51585], [-122.39604, 37.51584], [-122.39608, 37.51947]]]} | No Public Access 3 | 9994 | Coastside County Water District | 17466 | 2022 | Coastside County Water District 882 | Special District 4 | Water District 13 | http://www.coastsidewater.org/ | Special District 4 | 2022 | Coastside County Water District 857 | Special District 4 | Water District 13 | San Mateo 15 | 277.163 | Coastside County Water District | 1930 | Local Other or Unknown 14 | 4 | |
4759 | 4759 | 4758 | {"type": "Polygon", "coordinates": [[[-116.89337, 32.86769], [-116.89335, 32.87083], [-116.89269, 32.87075], [-116.89171, 32.87067], [-116.89084, 32.87071], [-116.88852, 32.8713], [-116.88757, 32.87172], [-116.88715, 32.87197], [-116.88627, 32.87239], [-116.88579, 32.87264], [-116.88517, 32.87306], [-116.88341, 32.87378], [-116.88276, 32.87409], [-116.88211, 32.8745], [-116.88159, 32.87481], [-116.88042, 32.87556], [-116.87951, 32.87611], [-116.87854, 32.87675], [-116.87777, 32.87717], [-116.87882, 32.87389], [-116.88144, 32.87294], [-116.88354, 32.87188], [-116.88375, 32.87177], [-116.88407, 32.87153], [-116.88412, 32.87153], [-116.88423, 32.87144], [-116.88619, 32.86953], [-116.88642, 32.86932], [-116.88665, 32.86914], [-116.88691, 32.86897], [-116.88719, 32.86882], [-116.88743, 32.86871], [-116.88787, 32.86854], [-116.88831, 32.86843], [-116.89254, 32.868], [-116.89295, 32.86788], [-116.89337, 32.86769]]]} | Unknown Access 4 | 46690 | Unnamed site - Helix Water District | 30035 | 2046 | Helix Water District 777 | Special District 4 | Water District 13 | http://www.hwd.com | Special District 4 | 2046 | Helix Water District 757 | Special District 4 | Water District 13 | San Diego 4 | 97.198 | 0 | Local Other or Unknown 14 | 4 | ||
12947 | 12947 | 12946 | {"type": "Polygon", "coordinates": [[[-122.7189, 38.00463], [-122.71194, 38.00951], [-122.71172, 38.00902], [-122.71158, 38.00864], [-122.71153, 38.00846], [-122.7115, 38.00822], [-122.71152, 38.00798], [-122.71149, 38.00747], [-122.71143, 38.00558], [-122.71139, 38.00545], [-122.71134, 38.00537], [-122.71121, 38.00521], [-122.7111, 38.00512], [-122.71096, 38.00504], [-122.70905, 38.00459], [-122.70878, 38.00436], [-122.70898, 38.00222], [-122.70973, 38.00241], [-122.71033, 38.00244], [-122.71077, 38.00238], [-122.71126, 38.00226], [-122.71183, 38.00224], [-122.71202, 38.00226], [-122.7122, 38.00236], [-122.71258, 38.0025], [-122.7131, 38.00264], [-122.71425, 38.00324], [-122.71522, 38.00268], [-122.7189, 38.00463]]]} | Open Access 1 | 44744 | Unnamed site - Marin Municipal Water District | 30015 | 2071 | Marin Municipal Water District 254 | Special District 4 | Water District 13 | http://www.marinwater.org/ | Special District 4 | 2071 | Marin Municipal Water District 250 | Special District 4 | Water District 13 | Marin 23 | 87.659 | 0 | Local Other or Unknown 14 | 4 | ||
8678 | 8678 | 8677 | {"type": "Polygon", "coordinates": [[[-121.81028, 36.69978], [-121.81011, 36.70086], [-121.80621, 36.69923], [-121.80668, 36.69888], [-121.80692, 36.69836], [-121.81028, 36.69978]]]} | Open Access 1 | 13963 | Dunes State Park - Marina County Water District | 18301 | 2073 | Marina County Water District 897 | Special District 4 | Water District 13 | http://www.mcwd.org/ | Special District 4 | 2073 | Marina County Water District 871 | Special District 4 | Water District 13 | Monterey 14 | 10.133 | Dunes SP - Marina County Water District | 0 | Local Other or Unknown 14 | 4 | |
4620 | 4620 | 4619 | {"type": "MultiPolygon", "coordinates": [[[[-117.49797, 34.15236], [-117.49796, 34.15242], [-117.4955, 34.15391], [-117.49542, 34.1537], [-117.49785, 34.15222], [-117.49797, 34.15236]]], [[[-117.50131, 34.1506], [-117.50095, 34.15068], [-117.50075, 34.15075], [-117.50056, 34.15084], [-117.49821, 34.15226], [-117.49812, 34.15225], [-117.498, 34.15212], [-117.50052, 34.1506], [-117.50131, 34.1506]]]]} | Open Access 1 | 36134 | Unnamed site - Metropolitan Water District of Southern California | 28684 | 2078 | Metropolitan Water District of Southern California 413 | Special District 4 | Water District 13 | http://www.mwdh2o.com/ | Special District 4 | 2078 | Metropolitan Water District of Southern California 407 | Special District 4 | Water District 13 | San Bernardino 22 | 3.476 | 0 | Local Other or Unknown 14 | 4 | ||
11248 | 11248 | 11247 | {"type": "Polygon", "coordinates": [[[-121.53769, 38.97852], [-121.5373, 38.97871], [-121.53713, 38.97885], [-121.53694, 38.97905], [-121.5368, 38.97941], [-121.53681, 38.97995], [-121.53646, 38.97822], [-121.53744, 38.97812], [-121.53759, 38.97831], [-121.53769, 38.97852]]]} | Open Access 1 | 21679 | Lot D Park River Oaks South | 21543 | 2101 | Olivehurst Public Utility District 555 | Special District 4 | Water District 13 | http://www.opud.org/ | Special District 4 | 2101 | Olivehurst Public Utility District 548 | Special District 4 | Water District 13 | Yuba 25 | 2.016 | Lot D Park River Oaks South | 0 | Local Other or Unknown 14 | 4 | |
8366 | 8366 | 8365 | {"type": "MultiPolygon", "coordinates": [[[[-117.18387, 33.06916], [-117.18373, 33.06922], [-117.18365, 33.06932], [-117.18344, 33.07003], [-117.18341, 33.07029], [-117.18336, 33.07037], [-117.18326, 33.07043], [-117.18318, 33.07045], [-117.18309, 33.07045], [-117.18301, 33.07043], [-117.18294, 33.07039], [-117.18275, 33.07017], [-117.18254, 33.06981], [-117.1824, 33.06968], [-117.18218, 33.06958], [-117.18192, 33.06954], [-117.18178, 33.06956], [-117.18174, 33.0696], [-117.18151, 33.0701], [-117.18141, 33.07027], [-117.18136, 33.07032], [-117.1812, 33.07042], [-117.1811, 33.07045], [-117.18043, 33.0706], [-117.18028, 33.07002], [-117.18012, 33.0692], [-117.18003, 33.06895], [-117.17992, 33.06872], [-117.17978, 33.06849], [-117.17962, 33.06828], [-117.17868, 33.06726], [-117.17963, 33.06745], [-117.18029, 33.06709], [-117.18124, 33.06728], [-117.18187, 33.06772], [-117.18368, 33.06734], [-117.18365, 33.06748], [-117.18206, 33.06821], [-117.1829, 33.06886], [-117.18303, 33.06925], [-117.18341, 33.06973], [-117.18342, 33.06972], [-117.18351, 33.06935], [-117.18357, 33.06925], [-117.18366, 33.06916], [-117.18377, 33.0691], [-117.18385, 33.0691], [-117.18387, 33.06916]]], [[[-117.19147, 33.06983], [-117.19147, 33.07279], [-117.18792, 33.07272], [-117.18861, 33.07056], [-117.18953, 33.07], [-117.18955, 33.06987], [-117.18959, 33.06977], [-117.18967, 33.06969], [-117.18991, 33.06953], [-117.18996, 33.06945], [-117.18997, 33.06936], [-117.19039, 33.06936], [-117.19051, 33.06954], [-117.19066, 33.06972], [-117.19077, 33.06983], [-117.1909, 33.06989], [-117.19107, 33.06991], [-117.19147, 33.06983]]], [[[-117.19582, 33.06557], [-117.19572, 33.07105], [-117.19575, 33.07289], [-117.19572, 33.07671], [-117.19463, 33.07669], [-117.19462, 33.07288], [-117.19238, 33.07281], [-117.19238, 33.0728], [-117.1925, 33.07226], [-117.19265, 33.0719], [-117.19286, 33.0715], [-117.19317, 33.07106], [-117.19333, 33.07088], [-117.19355, 33.07066], [-117.19383, 33.07071], [-117.1941, 33.07069], [-117.19437, 33.0706], [-117.1946, 33.07045], [-117.19473, 33.07031], [-117.19533, 33.06926], [-117.19312, 33.06831], [-117.19276, 33.06678], [-117.1915, 33.06679], [-117.19016, 33.06706], [-117.19071, 33.06551], [-117.1907, 33.0655], [-117.18733, 33.06546], [-117.18032, 33.06543], [-117.18024, 33.06347], [-117.17941, 33.06231], [-117.17797, 33.0623], [-117.17796, 33.06231], [-117.17798, 33.06244], [-117.17603, 33.06242], [-117.17442, 33.06314], [-117.17441, 33.06186], [-117.17988, 33.06189], [-117.18201, 33.06488], [-117.18723, 33.0649], [-117.18724, 33.06429], [-117.19045, 33.06383], [-117.19209, 33.06309], [-117.19233, 33.0636], [-117.19277, 33.06357], [-117.19333, 33.06389], [-117.1936, 33.0645], [-117.19346, 33.06478], [-117.19502, 33.06533], [-117.19514, 33.06543], [-117.19531, 33.06551], [-117.19539, 33.06553], [-117.19582, 33.06553], [-117.19582, 33.06557]]], [[[-117.20097, 33.07956], [-117.20047, 33.08043], [-117.19958, 33.08044], [-117.20028, 33.08074], [-117.1994, 33.08154], [-117.19938, 33.08409], [-117.19718, 33.08404], [-117.19637, 33.08404], [-117.19471, 33.08541], [-117.19466, 33.08403], [-117.1907, 33.08402], [-117.19073, 33.08041], [-117.19861, 33.08043], [-117.19921, 33.07967], [-117.19883, 33.0795], [-117.19929, 33.07918], [-117.20046, 33.07911], [-117.20097, 33.07956]]]]} | No Public Access 3 | 12964 | Second San Diego Aqueduct | 25278 | 2102 | Olivenhain Municipal Water District 871 | Special District 4 | Water District 13 | http://www.olivenhain.com/ | Special District 4 | 2102 | Olivenhain Municipal Water District 849 | Special District 4 | Water District 13 | San Diego 4 | 253.17 | Second San Diego Aqueduct | 0 | Local Other or Unknown 14 | 4 | |
4487 | 4487 | 4486 | {"type": "Polygon", "coordinates": [[[-117.65095, 33.91007], [-117.65019, 33.91006], [-117.64981, 33.90897], [-117.65009, 33.9089], [-117.65007, 33.90881], [-117.65045, 33.90848], [-117.65044, 33.90828], [-117.64965, 33.9076], [-117.64926, 33.90648], [-117.65093, 33.90642], [-117.65095, 33.91007]]]} | Unknown Access 4 | 4844 | Unnamed site - Orange County Water District | 28653 | 2105 | Orange County Water District 768 | Special District 4 | Water District 13 | http://www.ocwd.com/ | Special District 4 | 2105 | Orange County Water District 749 | Special District 4 | Water District 13 | Riverside 10 | 9.715 | 0 | Local Other or Unknown 14 | 4 | ||
6042 | 6042 | 6041 | {"type": "Polygon", "coordinates": [[[-117.65215, 33.91871], [-117.64965, 33.91869], [-117.64963, 33.91329], [-117.64196, 33.91325], [-117.6368, 33.91461], [-117.63649, 33.91401], [-117.63211, 33.91406], [-117.63198, 33.92449], [-117.61542, 33.92423], [-117.6155, 33.9172], [-117.61201, 33.91687], [-117.61099, 33.91712], [-117.61093, 33.91], [-117.61042, 33.90998], [-117.60852, 33.90661], [-117.60981, 33.90566], [-117.61023, 33.90544], [-117.61403, 33.90399], [-117.61585, 33.90723], [-117.61654, 33.90805], [-117.62002, 33.90681], [-117.61703, 33.90146], [-117.62021, 33.90047], [-117.62321, 33.90627], [-117.62773, 33.90538], [-117.62828, 33.90487], [-117.62877, 33.90524], [-117.62922, 33.90485], [-117.62938, 33.90451], [-117.63377, 33.90252], [-117.63468, 33.90175], [-117.63411, 33.90051], [-117.6344, 33.90024], [-117.63575, 33.89949], [-117.6367, 33.89833], [-117.63715, 33.89744], [-117.63777, 33.89583], [-117.63815, 33.89533], [-117.63787, 33.89465], [-117.63809, 33.89455], [-117.64133, 33.89494], [-117.6414, 33.89486], [-117.64357, 33.89614], [-117.64346, 33.89661], [-117.64359, 33.89693], [-117.64413, 33.89697], [-117.64444, 33.89741], [-117.64431, 33.8977], [-117.64438, 33.89793], [-117.6446, 33.89808], [-117.64367, 33.90155], [-117.64126, 33.90291], [-117.64084, 33.90235], [-117.64034, 33.90266], [-117.64073, 33.90329], [-117.63463, 33.90713], [-117.6359, 33.90998], [-117.64167, 33.90822], [-117.64723, 33.90655], [-117.6477, 33.90653], [-117.64788, 33.90706], [-117.64792, 33.90749], [-117.64857, 33.90928], [-117.64873, 33.90925], [-117.65215, 33.91871]]]} | Open Access 1 | 47356 | Prado Flood Control Basin | 31073 | 2105 | Orange County Water District 768 | Special District 4 | Water District 13 | http://www.ocwd.com/ | Special District 4 | 2105 | Orange County Water District 749 | Special District 4 | Water District 13 | Riverside 10 | 1464.541 | Prado Flood Control Basin | 0 | Local Other or Unknown 14 | 4 | |
14807 | 14807 | 14806 | {"type": "Polygon", "coordinates": [[[-116.93609, 33.0511], [-116.92755, 33.05108], [-116.92754, 33.04241], [-116.93205, 33.04305], [-116.93259, 33.04035], [-116.92753, 33.03962], [-116.92753, 33.03643], [-116.93601, 33.03655], [-116.93601, 33.04036], [-116.93609, 33.0511]]]} | Unknown Access 4 | 45223 | Ramona Municipal Water District | 24117 | 2116 | Ramona Municipal Water District 872 | Special District 4 | Water District 13 | http://www.rmwd.org/ | Special District 4 | 2116 | Ramona Municipal Water District 850 | Special District 4 | Water District 13 | San Diego 4 | 283.724 | Ramona Municipal Water District | 0 | Local Other or Unknown 14 | 4 | |
14808 | 14808 | 14807 | {"type": "Polygon", "coordinates": [[[-117.00394, 33.01294], [-117.00388, 33.01486], [-117.00029, 33.01496], [-117.00055, 33.01283], [-117.00251, 33.0123], [-117.00285, 33.01294], [-117.00394, 33.01294]]]} | Unknown Access 4 | 45224 | Ramona Municipal Water District | 24117 | 2116 | Ramona Municipal Water District 872 | Special District 4 | Water District 13 | http://www.rmwd.org/ | Special District 4 | 2116 | Ramona Municipal Water District 850 | Special District 4 | Water District 13 | San Diego 4 | 19.711 | Ramona Municipal Water District | 0 | Local Other or Unknown 14 | 4 | |
5970 | 5970 | 5969 | {"type": "MultiPolygon", "coordinates": [[[[-121.99687, 37.31807], [-121.99678, 37.31822], [-121.99642, 37.31835], [-121.99611, 37.31865], [-121.99601, 37.31872], [-121.99588, 37.31878], [-121.99556, 37.31886], [-121.99556, 37.31875], [-121.99594, 37.31858], [-121.99612, 37.31844], [-121.99622, 37.31829], [-121.99632, 37.31819], [-121.99663, 37.31802], [-121.99666, 37.31798], [-121.99663, 37.31789], [-121.99659, 37.31785], [-121.99643, 37.3178], [-121.99638, 37.31774], [-121.99632, 37.31768], [-121.99625, 37.31755], [-121.99623, 37.31728], [-121.9962, 37.31716], [-121.99612, 37.31705], [-121.99605, 37.31692], [-121.99602, 37.31681], [-121.99602, 37.31669], [-121.99596, 37.31648], [-121.99588, 37.31636], [-121.99583, 37.31604], [-121.99587, 37.31571], [-121.99592, 37.31548], [-121.99598, 37.31533], [-121.99607, 37.31523], [-121.99612, 37.3151], [-121.99614, 37.31487], [-121.99614, 37.31461], [-121.99619, 37.31451], [-121.99629, 37.31436], [-121.99646, 37.31417], [-121.99651, 37.31406], [-121.99652, 37.31393], [-121.99648, 37.31368], [-121.99643, 37.31354], [-121.99639, 37.31349], [-121.99635, 37.31335], [-121.99644, 37.31279], [-121.99641, 37.31262], [-121.99635, 37.31252], [-121.996, 37.31216], [-121.99612, 37.31216], [-121.99644, 37.31233], [-121.99651, 37.31254], [-121.99653, 37.31314], [-121.99661, 37.31352], [-121.99667, 37.31372], [-121.99672, 37.31414], [-121.99647, 37.31443], [-121.99636, 37.31451], [-121.99624, 37.31491], [-121.99624, 37.31506], [-121.99614, 37.3152], [-121.99606, 37.31536], [-121.99604, 37.31552], [-121.99599, 37.31568], [-121.99607, 37.316], [-121.99609, 37.31655], [-121.99643, 37.31717], [-121.99645, 37.31758], [-121.99679, 37.31778], [-121.99687, 37.31807]]], [[[-122.00337, 37.29303], [-122.00317, 37.29332], [-122.00281, 37.29389], [-122.0028, 37.29395], [-122.00282, 37.29422], [-122.00274, 37.29439], [-122.00254, 37.29474], [-122.00216, 37.29501], [-122.00201, 37.29509], [-122.0012, 37.29591], [-122.00102, 37.29636], [-122.00084, 37.2967], [-122.00028, 37.29698], [-121.99946, 37.29707], [-121.99951, 37.29722], [-121.99928, 37.29726], [-121.99905, 37.29734], [-121.9984, 37.29763], [-121.99809, 37.29789], [-121.99805, 37.29804], [-121.99813, 37.29822], [-121.99822, 37.29835], [-121.99829, 37.29841], [-121.99833, 37.29858], [-121.99833, 37.29874], [-121.99826, 37.2989], [-121.99812, 37.2994], [-121.99813, 37.29959], [-121.99821, 37.30009], [-121.99824, 37.30039], [-121.99806, 37.30077], [-121.99782, 37.30105], [-121.99741, 37.30129], [-121.99732, 37.30136], [-121.99723, 37.30147], [-121.99698, 37.30196], [-121.99678, 37.30246], [-121.99666, 37.30287], [-121.99658, 37.30323], [-121.99653, 37.30367], [-121.99652, 37.30411], [-121.99655, 37.3045], [-121.99691, 37.30659], [-121.99698, 37.30734], [-121.99693, 37.30809], [-121.99668, 37.30965], [-121.99663, 37.30983], [-121.99605, 37.30986], [-121.99605, 37.30959], [-121.99647, 37.30747], [-121.99638, 37.30649], [-121.99626, 37.30583], [-121.99625, 37.30456], [-121.99622, 37.30433], [-121.99622, 37.30398], [-121.99622, 37.30375], [-121.99626, 37.30328], [-121.99635, 37.30282], [-121.99649, 37.30233], [-121.99668, 37.30185], [-121.99701, 37.3013], [-121.99741, 37.30045], [-121.99757, 37.3], [-121.99763, 37.29967], [-121.99768, 37.29913], [-121.99769, 37.29872], [-121.99768, 37.29831], [-121.99771, 37.2983], [-121.99771, 37.29828], [-121.99769, 37.29827], [-121.99771, 37.29805], [-121.99781, 37.29757], [-121.99838, 37.29718], [-121.99912, 37.29695], [-121.99931, 37.29691], [-121.99996, 37.29683], [-122.00031, 37.29674], [-122.00058, 37.29658], [-122.00076, 37.29637], [-122.00103, 37.29582], [-122.0016, 37.29519], [-122.00175, 37.29504], [-122.00237, 37.29459], [-122.00249, 37.29444], [-122.00256, 37.29425], [-122.00259, 37.29414], [-122.00264, 37.29364], [-122.00276, 37.29335], [-122.00302, 37.29299], [-122.00337, 37.29303]]]]} | Restricted Access 2 | 554 | Saratoga Creek | 25157 | 2143 | Santa Clara Valley Water District 483 | Special District 4 | Water District 13 | http://www.valleywater.org/ | Special District 4 | 2143 | Santa Clara Valley Water District 798 | Special District 4 | Water District 13 | Santa Clara 19 | 22.283 | Saratoga Creek | 1930 | Local Other or Unknown 14 | 4 | |
6332 | 6332 | 6331 | {"type": "MultiPolygon", "coordinates": [[[[-121.79513, 37.31362], [-121.79476, 37.31367], [-121.79477, 37.3137], [-121.79469, 37.31372], [-121.79464, 37.31371], [-121.7946, 37.31372], [-121.79456, 37.31379], [-121.79447, 37.31386], [-121.79431, 37.31361], [-121.7943, 37.31344], [-121.79412, 37.313], [-121.79392, 37.31287], [-121.7937, 37.31288], [-121.79326, 37.31307], [-121.79312, 37.31309], [-121.79279, 37.31299], [-121.79261, 37.31307], [-121.79255, 37.31312], [-121.79245, 37.31317], [-121.79239, 37.31317], [-121.7922, 37.31312], [-121.79212, 37.31295], [-121.79171, 37.31263], [-121.79165, 37.31261], [-121.7913, 37.31252], [-121.79079, 37.31267], [-121.79074, 37.31254], [-121.79032, 37.31187], [-121.7896, 37.31155], [-121.78932, 37.31129], [-121.7891, 37.31138], [-121.78884, 37.31135], [-121.78875, 37.31136], [-121.78864, 37.31135], [-121.78854, 37.31142], [-121.7883, 37.31151], [-121.78815, 37.31155], [-121.78811, 37.31154], [-121.78808, 37.31152], [-121.788, 37.31142], [-121.78758, 37.31103], [-121.78743, 37.31095], [-121.78726, 37.31091], [-121.78717, 37.31087], [-121.78691, 37.31065], [-121.78661, 37.31041], [-121.78648, 37.31036], [-121.78616, 37.31027], [-121.78597, 37.3101], [-121.78579, 37.30986], [-121.78572, 37.30982], [-121.78566, 37.3098], [-121.78549, 37.30979], [-121.78546, 37.30977], [-121.7854, 37.30959], [-121.78523, 37.3095], [-121.78501, 37.30944], [-121.7849, 37.30946], [-121.78464, 37.30953], [-121.78458, 37.30953], [-121.78455, 37.30953], [-121.78452, 37.30943], [-121.78449, 37.3094], [-121.78439, 37.30934], [-121.78428, 37.30933], [-121.78418, 37.30935], [-121.7841, 37.30934], [-121.78403, 37.30934], [-121.78391, 37.30933], [-121.78382, 37.30929], [-121.7837, 37.30922], [-121.78359, 37.30908], [-121.78349, 37.309], [-121.78339, 37.309], [-121.78317, 37.30906], [-121.78306, 37.30906], [-121.78238, 37.3089], [-121.78217, 37.30878], [-121.78198, 37.30865], [-121.78179, 37.30857], [-121.78133, 37.30848], [-121.78132, 37.30834], [-121.78123, 37.30824], [-121.78115, 37.30823], [-121.78111, 37.30824], [-121.78092, 37.30824], [-121.78086, 37.30822], [-121.78069, 37.30812], [-121.78057, 37.30801], [-121.78047, 37.30785], [-121.78044, 37.30759], [-121.78046, 37.30744], [-121.78039, 37.30734], [-121.78033, 37.30729], [-121.78025, 37.30727], [-121.77989, 37.30733], [-121.77981, 37.30733], [-121.77978, 37.30734], [-121.77967, 37.30734], [-121.7796, 37.30727], [-121.77959, 37.30724], [-121.77961, 37.30722], [-121.77961, 37.30719], [-121.7797, 37.3071], [-121.77973, 37.30702], [-121.77951, 37.30661], [-121.77937, 37.30649], [-121.77921, 37.3064], [-121.77913, 37.30632], [-121.77907, 37.30629], [-121.77891, 37.30615], [-121.77889, 37.30612], [-121.77887, 37.30602], [-121.77888, 37.30599], [-121.77899, 37.3059], [-121.77904, 37.30584], [-121.77907, 37.30576], [-121.77905, 37.30567], [-121.7789, 37.30558], [-121.77878, 37.30554], [-121.77855, 37.30551], [-121.77839, 37.30551], [-121.77831, 37.30547], [-121.77831, 37.30544], [-121.77837, 37.30535], [-121.77837, 37.30529], [-121.77834, 37.30523], [-121.77824, 37.30515], [-121.77808, 37.30506], [-121.77794, 37.30501], [-121.77782, 37.30497], [-121.7777, 37.30498], [-121.77761, 37.30494], [-121.77766, 37.30485], [-121.77783, 37.30474], [-121.77789, 37.30466], [-121.77781, 37.30455], [-121.77768, 37.30447], [-121.77761, 37.30431], [-121.7776, 37.30421], [-121.77757, 37.30409], [-121.77753, 37.30405], [-121.77751, 37.30399], [-121.77754, 37.30393], [-121.77757, 37.3039], [-121.77775, 37.30391], [-121.77789, 37.30388], [-121.77789, 37.30386], [-121.77782, 37.30374], [-121.77782, 37.30369], [-121.77798, 37.30364], [-121.77798, 37.30363], [-121.77753, 37.30333], [-121.77738, 37.30328], [-121.77731, 37.30324], [-121.77723, 37.30308], [-121.77723, 37.30304], [-121.77669, 37.30253], [-121.77666, 37.30255], [-121.77657, 37.30257], [-121.7765, 37.30256], [-121.77638, 37.30245], [-121.77622, 37.3024], [-121.77608, 37.30239], [-121.77604, 37.30239], [-121.7759, 37.30246], [-121.77581, 37.30246], [-121.77574, 37.30239], [-121.77573, 37.30233], [-121.77574, 37.30222], [-121.77576, 37.30217], [-121.77574, 37.30213], [-121.7757, 37.30211], [-121.77557, 37.30209], [-121.77538, 37.30215], [-121.77527, 37.30223], [-121.77517, 37.30222], [-121.77501, 37.30216], [-121.77479, 37.30199], [-121.77461, 37.30183], [-121.77459, 37.30174], [-121.77462, 37.30166], [-121.77473, 37.30159], [-121.77499, 37.30148], [-121.77523, 37.30143], [-121.7753, 37.30137], [-121.77533, 37.30132], [-121.77532, 37.30129], [-121.77523, 37.30123], [-121.77515, 37.30123], [-121.77505, 37.30119], [-121.77502, 37.30113], [-121.77491, 37.30099], [-121.77486, 37.30094], [-121.77483, 37.30094], [-121.7748, 37.30091], [-121.77476, 37.30076], [-121.77471, 37.30074], [-121.77453, 37.30052], [-121.77436, 37.30045], [-121.77402, 37.30046], [-121.77392, 37.30043], [-121.77382, 37.30037], [-121.77377, 37.3003], [-121.77375, 37.30021], [-121.77377, 37.30012], [-121.7738, 37.30004], [-121.7738, 37.29995], [-121.77375, 37.2999], [-121.77362, 37.29982], [-121.77352, 37.2998], [-121.77343, 37.29981], [-121.77337, 37.29979], [-121.77333, 37.29972], [-121.7733, 37.29959], [-121.77323, 37.29952], [-121.77306, 37.29943], [-121.77281, 37.29936], [-121.77262, 37.29933], [-121.7724, 37.29933], [-121.77143, 37.29824], [-121.77189, 37.29826], [-121.77206, 37.29815], [-121.77208, 37.29809], [-121.77205, 37.29802], [-121.77255, 37.29797], [-121.77261, 37.29825], [-121.77222, 37.29849], [-121.77222, 37.2985], [-121.77245, 37.29874], [-121.77281, 37.29905], [-121.77299, 37.29908], [-121.77344, 37.29932], [-121.77374, 37.29968], [-121.77401, 37.29991], [-121.77458, 37.30021], [-121.77474, 37.30033], [-121.7754, 37.30097], [-121.77544, 37.30099], [-121.77545, 37.30104], [-121.77545, 37.30126], [-121.77544, 37.30138], [-121.77535, 37.30151], [-121.77525, 37.3016], [-121.77521, 37.30171], [-121.77506, 37.30181], [-121.77513, 37.3019], [-121.77521, 37.30192], [-121.77548, 37.3019], [-121.77575, 37.30195], [-121.77623, 37.30225], [-121.77646, 37.30227], [-121.77656, 37.30224], [-121.77662, 37.3022], [-121.77671, 37.3021], [-121.77693, 37.30202], [-121.77702, 37.30202], [-121.77709, 37.30206], [-121.77715, 37.30215], [-121.77712, 37.30237], [-121.77725, 37.30287], [-121.77784, 37.30328], [-121.7782, 37.30355], [-121.77825, 37.30356], [-121.77806, 37.30403], [-121.77798, 37.30435], [-121.77805, 37.30461], [-121.77807, 37.30488], [-121.77831, 37.30498], [-121.77842, 37.30521], [-121.77923, 37.30568], [-121.77927, 37.30583], [-121.77921, 37.30596], [-121.77926, 37.30619], [-121.77967, 37.30648], [-121.78001, 37.30627], [-121.78016, 37.30623], [-121.78042, 37.30665], [-121.7803, 37.30671], [-121.78061, 37.30724], [-121.78053, 37.30737], [-121.78068, 37.30746], [-121.78072, 37.3076], [-121.78063, 37.30782], [-121.7809, 37.30804], [-121.78107, 37.30816], [-121.78123, 37.30813], [-121.78152, 37.30826], [-121.782, 37.30855], [-121.78226, 37.3086], [-121.78243, 37.30861], [-121.78257, 37.30886], [-121.78363, 37.30898], [-121.78422, 37.30917], [-121.78461, 37.30939], [-121.78526, 37.30929], [-121.78687, 37.31049], [-121.78755, 37.31086], [-121.78775, 37.31104], [-121.78779, 37.31116], [-121.78809, 37.31143], [-121.78864, 37.31114], [-121.78933, 37.31114], [-121.78991, 37.31117], [-121.79097, 37.31167], [-121.79112, 37.31226], [-121.79127, 37.31243], [-121.79175, 37.31255], [-121.79217, 37.31284], [-121.79244, 37.31296], [-121.79312, 37.31288], [-121.79345, 37.3127], [-121.79379, 37.31264], [-121.79406, 37.31267], [-121.79426, 37.31275], [-121.79438, 37.31282], [-121.7945, 37.31294], [-121.79473, 37.31291], [-121.79483, 37.31335], [-121.79509, 37.3135], [-121.79513, 37.31362]]], [[[-121.79481, 37.31439], [-121.7948, 37.31438], [-121.79471, 37.31425], [-121.79459, 37.31405], [-121.79481, 37.31439]]], [[[-121.79613, 37.31524], [-121.79613, 37.31524], [-121.79552, 37.31485], [-121.79588, 37.31504], [-121.79613, 37.31524]]], [[[-121.81151, 37.32935], [-121.81079, 37.33037], [-121.81076, 37.33045], [-121.81054, 37.33075], [-121.81035, 37.33126], [-121.8103, 37.33171], [-121.81034, 37.33223], [-121.81044, 37.33254], [-121.81064, 37.33281], [-121.81066, 37.33285], [-121.80993, 37.3331], [-121.80973, 37.33296], [-121.80954, 37.33262], [-121.80947, 37.33232], [-121.80943, 37.33195], [-121.80941, 37.33192], [-121.80949, 37.3313], [-121.80969, 37.33063], [-121.81024, 37.32976], [-121.81034, 37.32966], [-121.8104, 37.32944], [-121.81038, 37.32932], [-121.81034, 37.32919], [-121.80883, 37.32715], [-121.80873, 37.32712], [-121.80867, 37.32713], [-121.80862, 37.32709], [-121.80852, 37.32708], [-121.8077, 37.32482], [-121.80725, 37.32413], [-121.80355, 37.32011], [-121.80209, 37.3185], [-121.80088, 37.31775], [-121.79936, 37.31738], [-121.79859, 37.31709], [-121.79827, 37.31694], [-121.79787, 37.31671], [-121.79678, 37.3159], [-121.79656, 37.31569], [-121.79666, 37.31563], [-121.79685, 37.3158], [-121.79706, 37.31566], [-121.79718, 37.31568], [-121.79757, 37.31567], [-121.79833, 37.31623], [-121.79881, 37.31647], [-121.79921, 37.31657], [-121.79973, 37.31676], [-121.80033, 37.31684], [-121.80091, 37.31705], [-121.80124, 37.31704], [-121.80168, 37.31721], [-121.80265, 37.31783], [-121.80336, 37.31814], [-121.80365, 37.31844], [-121.80622, 37.32093], [-121.80628, 37.3213], [-121.80715, 37.32227], [-121.80764, 37.32306], [-121.80701, 37.32343], [-121.807, 37.32344], [-121.80917, 37.3257], [-121.80976, 37.32687], [-121.81151, 37.32935]]]]} | Restricted Access 2 | 1501 | Thompson Creek | 26312 | 2143 | Santa Clara Valley Water District 483 | Special District 4 | Water District 13 | http://www.valleywater.org/ | Special District 4 | 2143 | Santa Clara Valley Water District 798 | Special District 4 | Water District 13 | Santa Clara 19 | 75.045 | Thompson Creek | 1930 | Local Other or Unknown 14 | 4 | |
14932 | 14932 | 14931 | {"type": "Polygon", "coordinates": [[[-121.75938, 37.40226], [-121.75072, 37.40644], [-121.74665, 37.40506], [-121.74514, 37.40143], [-121.74087, 37.39735], [-121.74693, 37.39537], [-121.75232, 37.39823], [-121.75202, 37.39839], [-121.75117, 37.39869], [-121.75076, 37.39886], [-121.75052, 37.39905], [-121.74922, 37.39947], [-121.74866, 37.39979], [-121.74921, 37.40099], [-121.7496, 37.4008], [-121.75015, 37.40085], [-121.75079, 37.40043], [-121.75107, 37.40035], [-121.75232, 37.40037], [-121.75349, 37.40049], [-121.75403, 37.40063], [-121.75477, 37.40095], [-121.75528, 37.40133], [-121.75628, 37.40129], [-121.75699, 37.40077], [-121.75938, 37.40226]]]} | Open Access 1 | 45518 | Upper Penitencia Creek Property | 28353 | 2143 | Santa Clara Valley Water District 483 | Special District 4 | Water District 13 | http://www.valleywater.org/ | Special District 4 | 2143 | Santa Clara Valley Water District 798 | Special District 4 | Water District 13 | Santa Clara 19 | 216.953 | Upper Penitencia Creek Property | 0 | Local Other or Unknown 14 | 4 | |
10640 | 10640 | 10639 | {"type": "Polygon", "coordinates": [[[-120.11817, 34.66507], [-120.11816, 34.66546], [-120.11783, 34.66545], [-120.11784, 34.66507], [-120.11817, 34.66507]]]} | Unknown Access 4 | 18982 | Alamo Pintado Creek | 15319 | 2147 | Santa Ynez River Water Conservation District 953 | Special District 4 | Water District 13 | Special District 4 | 2147 | Santa Ynez River Water Conservation District 925 | Special District 4 | Water District 13 | Santa Barbara 7 | 0.321 | Alamo Pintado Creek | 0 | Local Other or Unknown 14 | 4 | ||
3178 | 3178 | 3177 | {"type": "Polygon", "coordinates": [[[-121.93307, 36.98817], [-121.93305, 36.9883], [-121.93244, 36.98822], [-121.93247, 36.98809], [-121.93307, 36.98817]]]} | Open Access 1 | 1913 | Willowbrook Park - Soquel Creek Water District | 27591 | 2157 | Soquel Creek Water District 592 | Special District 4 | Water District 13 | http://www.soquelcreekwater.org/ | Special District 4 | 2157 | Soquel Creek Water District 582 | Special District 4 | Water District 13 | Santa Cruz 5 | 0.197 | Willowbrook Park - Soquel Creek Water District | 0 | Local Other or Unknown 14 | 4 | |
3438 | 3438 | 3437 | {"type": "Polygon", "coordinates": [[[-121.27738, 39.49699], [-121.277, 39.49737], [-121.27617, 39.49697], [-121.2765, 39.49657], [-121.27738, 39.49699]]]} | Unknown Access 4 | 35476 | Yuba County Water Agency 3 | 27818 | 2186 | Yuba County Water Agency 492 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | Yuba 25 | 1.144 | Yuba County Water Agency 3 | 0 | Local Other or Unknown 14 | 4 | |
3457 | 3457 | 3456 | {"type": "Polygon", "coordinates": [[[-121.27854, 39.49693], [-121.27778, 39.49658], [-121.27854, 39.4958], [-121.27851, 39.49654], [-121.27854, 39.49693]]]} | Unknown Access 4 | 35580 | Yuba County Water Agency 47 | 27837 | 2186 | Yuba County Water Agency 492 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | Yuba 25 | 0.973 | Yuba County Water Agency 47 | 0 | Local Other or Unknown 14 | 4 | |
3465 | 3465 | 3464 | {"type": "Polygon", "coordinates": [[[-121.27748, 39.49831], [-121.27736, 39.49848], [-121.27711, 39.49873], [-121.27626, 39.49834], [-121.27659, 39.49789], [-121.27748, 39.49831]]]} | Unknown Access 4 | 35637 | Yuba County Water Agency 14 | 27802 | 2186 | Yuba County Water Agency 492 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | Yuba 25 | 1.259 | Yuba County Water Agency 14 | 0 | Local Other or Unknown 14 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([id]), FOREIGN KEY([MNG_AGENCY]) REFERENCES [MNG_AGENCY]([id]), FOREIGN KEY([MNG_AG_LEV]) REFERENCES [MNG_AG_LEV]([id]), FOREIGN KEY([MNG_AG_TYP]) REFERENCES [MNG_AG_TYP]([id]), FOREIGN KEY([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);