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
This data as json, copyable, CSV (advanced)
MNG_AGENCY 16
- Yuba County Water Agency 33
- San Lorenzo Valley Water District 7
- 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
- Scotts Valley 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 · 58 ✖
DES_TP 1
- Local Other or Unknown · 58 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3876 | 3876 | 3875 | {"type": "Polygon", "coordinates": [[[-121.28161, 39.49241], [-121.28087, 39.49553], [-121.27866, 39.49811], [-121.27864, 39.49743], [-121.27853, 39.49685], [-121.27851, 39.49655], [-121.27854, 39.4958], [-121.27841, 39.49547], [-121.27838, 39.4953], [-121.27916, 39.49462], [-121.27937, 39.49367], [-121.27955, 39.49218], [-121.27846, 39.49076], [-121.27957, 39.49017], [-121.28161, 39.49241]]]} | Unknown Access 4 | 35684 | Yuba County Water Agency 7 | 27842 | 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 | 30.672 | Yuba County Water Agency 7 | 0 | Local Other or Unknown 14 | 4 | |
3879 | 3879 | 3878 | {"type": "Polygon", "coordinates": [[[-121.19451, 39.33672], [-121.19414, 39.33949], [-121.18597, 39.3391], [-121.18689, 39.33154], [-121.18707, 39.33029], [-121.18718, 39.3303], [-121.18742, 39.3303], [-121.18842, 39.3304], [-121.18881, 39.3304], [-121.18925, 39.33042], [-121.18963, 39.33042], [-121.19002, 39.33044], [-121.19016, 39.33043], [-121.18978, 39.3321], [-121.19067, 39.33218], [-121.19105, 39.33663], [-121.1914, 39.33671], [-121.19169, 39.33661], [-121.19204, 39.33663], [-121.19255, 39.33679], [-121.19303, 39.33702], [-121.19349, 39.33708], [-121.19377, 39.33714], [-121.19405, 39.33696], [-121.19418, 39.33677], [-121.19451, 39.33672]]]} | Unknown Access 4 | 35703 | Yuba County Water Agency 25 | 27814 | 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 | 108.796 | Yuba County Water Agency 25 | 0 | Local Other or Unknown 14 | 4 | |
3883 | 3883 | 3882 | {"type": "Polygon", "coordinates": [[[-121.26021, 39.48175], [-121.26013, 39.48186], [-121.25967, 39.48201], [-121.25908, 39.48231], [-121.25892, 39.48241], [-121.25892, 39.48267], [-121.25836, 39.48299], [-121.25892, 39.48344], [-121.25524, 39.48339], [-121.25431, 39.48275], [-121.25488, 39.48191], [-121.25549, 39.48189], [-121.25594, 39.48185], [-121.25652, 39.48175], [-121.256, 39.48003], [-121.25695, 39.47864], [-121.2589, 39.47905], [-121.25891, 39.48114], [-121.26003, 39.48142], [-121.26014, 39.48149], [-121.2602, 39.48164], [-121.26021, 39.48175]]]} | Unknown Access 4 | 35733 | Yuba County Water Agency 23 | 27812 | 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 | 35.822 | Yuba County Water Agency 23 | 0 | Local Other or Unknown 14 | 4 | |
3884 | 3884 | 3883 | {"type": "Polygon", "coordinates": [[[-121.27856, 39.49702], [-121.27829, 39.49721], [-121.2775, 39.49687], [-121.27778, 39.49658], [-121.27854, 39.49693], [-121.27856, 39.49702]]]} | Unknown Access 4 | 35734 | Yuba County Water Agency 22 | 27811 | 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.771 | Yuba County Water Agency 22 | 0 | Local Other or Unknown 14 | 4 | |
3885 | 3885 | 3884 | {"type": "Polygon", "coordinates": [[[-121.27854, 39.4958], [-121.27825, 39.4961], [-121.27743, 39.49552], [-121.2781, 39.49497], [-121.27831, 39.49492], [-121.27841, 39.49547], [-121.27854, 39.4958]]]} | Unknown Access 4 | 35737 | Yuba County Water Agency 30 | 27819 | 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.61 | Yuba County Water Agency 30 | 0 | Local Other or Unknown 14 | 4 | |
4296 | 4296 | 4295 | {"type": "Polygon", "coordinates": [[[-122.05637, 37.07384], [-122.0561, 37.07397], [-122.056, 37.07404], [-122.05592, 37.07413], [-122.05577, 37.07436], [-122.05552, 37.07423], [-122.05574, 37.07384], [-122.05592, 37.07367], [-122.05637, 37.07384]]]} | Open Access 1 | 45336 | San Lorenzo Valley Water District | 11349 | 2277 | San Lorenzo Valley Water District 598 | Special District 4 | Water District 13 | http://www.slvwd.com/ | Special District 4 | 2277 | San Lorenzo Valley Water District 588 | Special District 4 | Water District 13 | Santa Cruz 5 | 0.582 | San Lorenzo Valley Water District | 0 | Local Other or Unknown 14 | 4 | |
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 | ||
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 | ||
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 | ||
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 | ||
4777 | 4777 | 4776 | {"type": "MultiPolygon", "coordinates": [[[[-121.96433, 39.7002], [-121.95674, 39.70022], [-121.95595, 39.69996], [-121.9525, 39.69944], [-121.95205, 39.69939], [-121.94998, 39.6995], [-121.94872, 39.69951], [-121.94823, 39.69947], [-121.94758, 39.69855], [-121.94715, 39.69818], [-121.94507, 39.69813], [-121.94469, 39.69776], [-121.94423, 39.69735], [-121.9474, 39.69738], [-121.95119, 39.69737], [-121.96395, 39.69723], [-121.96396, 39.69727], [-121.96418, 39.69771], [-121.96414, 39.69802], [-121.96423, 39.69998], [-121.96426, 39.70011], [-121.9643, 39.70015], [-121.9643, 39.70019], [-121.96433, 39.7002]]], [[[-121.98853, 39.73431], [-121.98685, 39.73561], [-121.98613, 39.73628], [-121.98554, 39.73691], [-121.98496, 39.73755], [-121.98343, 39.73544], [-121.98109, 39.73383], [-121.97953, 39.7334], [-121.9777, 39.73315], [-121.97722, 39.7332], [-121.97662, 39.73314], [-121.9738, 39.73168], [-121.97187, 39.73169], [-121.97086, 39.73213], [-121.96714, 39.73021], [-121.96683, 39.72966], [-121.96893, 39.7228], [-121.96913, 39.72267], [-121.96916, 39.72244], [-121.96918, 39.72243], [-121.96919, 39.7224], [-121.96873, 39.72239], [-121.9681, 39.72198], [-121.96751, 39.721], [-121.96705, 39.7203], [-121.96639, 39.71954], [-121.96619, 39.71936], [-121.96549, 39.71886], [-121.96484, 39.71853], [-121.96345, 39.71787], [-121.9625, 39.71753], [-121.96195, 39.71746], [-121.96147, 39.71747], [-121.95959, 39.7177], [-121.95892, 39.71786], [-121.95806, 39.71817], [-121.95717, 39.71856], [-121.95665, 39.71899], [-121.95625, 39.71927], [-121.956, 39.71938], [-121.9557, 39.71924], [-121.95535, 39.71878], [-121.95533, 39.71857], [-121.95535, 39.71834], [-121.95529, 39.71806], [-121.95527, 39.71785], [-121.9552, 39.71763], [-121.95499, 39.71742], [-121.95451, 39.71729], [-121.95413, 39.71726], [-121.95397, 39.71715], [-121.95372, 39.71686], [-121.95321, 39.71645], [-121.95298, 39.7163], [-121.95238, 39.71582], [-121.9523, 39.71557], [-121.95228, 39.7154], [-121.95238, 39.71524], [-121.95257, 39.71518], [-121.95261, 39.71461], [-121.95259, 39.71428], [-121.95242, 39.71366], [-121.95226, 39.71317], [-121.95223, 39.71286], [-121.95504, 39.71284], [-121.95554, 39.71292], [-121.95668, 39.7132], [-121.95693, 39.71323], [-121.95718, 39.71321], [-121.95744, 39.71316], [-121.95895, 39.71283], [-121.95985, 39.71284], [-121.97012, 39.71278], [-121.97016, 39.71283], [-121.97084, 39.71283], [-121.97155, 39.71309], [-121.97705, 39.71513], [-121.97717, 39.71516], [-121.97735, 39.71525], [-121.97741, 39.71532], [-121.98006, 39.71721], [-121.98024, 39.71736], [-121.98033, 39.71746], [-121.98045, 39.71762], [-121.98081, 39.7183], [-121.98087, 39.71835], [-121.98095, 39.71849], [-121.98096, 39.71857], [-121.98247, 39.72141], [-121.98283, 39.72148], [-121.98287, 39.72151], [-121.98577, 39.72817], [-121.98841, 39.7341], [-121.98853, 39.73431]], [[-121.97119, 39.72095], [-121.97118, 39.72094], [-121.9709, 39.72122], [-121.97118, 39.72105], [-121.97119, 39.72095]], [[-121.97124, 39.71932], [-121.97122, 39.71933], [-121.97132, 39.72006], [-121.97135, 39.71989], [-121.97124, 39.71932]]]]} | No Public Access 3 | 47067 | Unnamed Site - California Reclamation District 2140 | 30720 | 2404 | California Reclamation District 2140 779 | Special District 4 | Water District 13 | http://www.rd2140.org/ | Special District 4 | 2404 | California Reclamation District 2140 759 | Special District 4 | Water District 13 | Glenn 55 | 1016.152 | 0 | Local Other or Unknown 14 | 4 | ||
5565 | 5565 | 5564 | {"type": "Polygon", "coordinates": [[[-121.98973, 37.06793], [-121.98885, 37.06898], [-121.98804, 37.06892], [-121.98794, 37.06871], [-121.9882, 37.06787], [-121.98973, 37.06793]]]} | Open Access 1 | 28271 | Scotts Valley Water District | 25214 | 2274 | Scotts Valley Water District 599 | Special District 4 | Water District 13 | http://www.svwd.org/ | Special District 4 | 2274 | Scotts Valley Water District 589 | Special District 4 | Water District 13 | Santa Cruz 5 | 3.237 | Scotts Valley 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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | ||
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 |
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]);