units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
48 rows where AGNCY_TYP = 13 and DES_TP = 2 sorted by LABEL_NAME
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_WEB, MNG_AG_ID, MNG_AG_LEV, COUNTY, YR_EST
MNG_AGENCY 19
- Olivehurst Public Utility District 15
- Santa Clara County Parks and Recreation Dept., County of 5
- Heber Public Utility District 4
- Tahoe City Public Utilities District 4
- Santa Clarita, City of 2
- Burney Co Water District 2
- North Tahoe Public Utilities District 2
- Helix Water District 2
- Santa Clara Valley Water District 2
- Rosemead, City of 1
- Sonoma County Regional Parks Dept., County of 1
- San Marcos, City of 1
- Calabasas, City of 1
- Metropolitan Water District of Southern California 1
- Desert Hot Springs, City of 1
- Tehachapi Valley Recreation and Parks District 1
- Ramona Municipal Water District 1
- Malaga County Water District 1
- Padre Dam Municipal Water District 1
MNG_AG_TYP 4
ACCESS_TYP 3
DES_TP 1
- Local Park · 48 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12352 | 12352 | 12351 | {"type": "MultiPolygon", "coordinates": [[[[-121.89775, 37.33349], [-121.8975, 37.33361], [-121.8974, 37.33308], [-121.89744, 37.33307], [-121.89775, 37.33349]]], [[[-121.89812, 37.33398], [-121.89762, 37.33422], [-121.89752, 37.33373], [-121.89783, 37.33359], [-121.89812, 37.33398]]], [[[-121.90026, 37.3341], [-121.89891, 37.33473], [-121.89762, 37.33298], [-121.89903, 37.33231], [-121.89928, 37.33223], [-121.90012, 37.33219], [-121.90026, 37.3341]]], [[[-121.89873, 37.33481], [-121.89853, 37.33491], [-121.89838, 37.33472], [-121.89818, 37.33481], [-121.89813, 37.33476], [-121.89775, 37.33492], [-121.89764, 37.33433], [-121.89819, 37.33408], [-121.89873, 37.33481]]]]} | Restricted Access 2 | 26060 | Arena Green | 15579 | 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 | 12.575 | Arena Green | 0 | Local Park 2 | 4 | |
11187 | 11187 | 11186 | {"type": "Polygon", "coordinates": [[[-121.54665, 38.98364], [-121.54635, 38.98387], [-121.54615, 38.98424], [-121.54615, 38.98439], [-121.54578, 38.9844], [-121.54495, 38.98436], [-121.54495, 38.98314], [-121.54499, 38.98309], [-121.54563, 38.98298], [-121.54589, 38.9829], [-121.54594, 38.98291], [-121.54631, 38.98334], [-121.54665, 38.98364]]]} | Open Access 1 | 21680 | Bear River Park | 28703 | 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 | 4.469 | Bear River Park | 0 | Local Park 2 | 4 | |
10860 | 10860 | 10859 | {"type": "Polygon", "coordinates": [[[-118.55086, 34.42777], [-118.55071, 34.42814], [-118.55003, 34.42806], [-118.54982, 34.42802], [-118.54982, 34.428], [-118.54977, 34.42799], [-118.54976, 34.42802], [-118.54855, 34.42796], [-118.54655, 34.42794], [-118.54585, 34.42615], [-118.54604, 34.42614], [-118.54672, 34.42619], [-118.54707, 34.42614], [-118.54709, 34.42619], [-118.54768, 34.42609], [-118.54894, 34.42607], [-118.54869, 34.42636], [-118.55086, 34.42777]]]} | Open Access 1 | 20658 | Bridgeport Park | 16380 | 2078 | Metropolitan Water District of Southern California 413 | Special District 4 | Water District 13 | http://www.mwdh2o.com/ | Special District 4 | 1319 | Santa Clarita, City of 322 | City 2 | City Agency 2 | Los Angeles 6 | 16.763 | Bridgeport Park | 0 | Local Park 2 | 4 | |
4254 | 4254 | 4253 | {"type": "Polygon", "coordinates": [[[-118.54882, 35.10774], [-118.54759, 35.10772], [-118.54761, 35.10932], [-118.54171, 35.10939], [-118.53673, 35.10941], [-118.53685, 35.10216], [-118.53715, 35.10216], [-118.53733, 35.10211], [-118.53737, 35.10207], [-118.54645, 35.102], [-118.54871, 35.10379], [-118.54882, 35.10774]]]} | Open Access 1 | 14364 | Brite Lake Park | 3488 | 2345 | Tehachapi-Cummings County Water District 499 | Special District 4 | Water District 13 | http://tccwd.com/ | Special District 4 | 2164 | Tehachapi Valley Recreation and Parks District 723 | Special District 4 | Recreation/Parks District 4 | http://www.tvrpd.org/parks-facilities/brite-lake.html | Kern 36 | 209.835 | Brite Lake Park | 0 | Local Park 2 | 4 |
3292 | 3292 | 3291 | {"type": "Polygon", "coordinates": [[[-121.6748, 40.88058], [-121.67428, 40.88107], [-121.67355, 40.88056], [-121.67413, 40.8801], [-121.6748, 40.88058]]]} | Open Access 1 | 48725 | Burney Civic Park | 33449 | 2434 | Burney Co Water District 614 | Special District 4 | Water District 13 | https://www.burneywater.org/ | Special District 4 | 2434 | Burney Co Water District 603 | Special District 4 | Water District 13 | Shasta 27 | 1.411 | Burney Civic Park | 0 | Local Park 2 | 4 | |
15200 | 15200 | 15199 | {"type": "Polygon", "coordinates": [[[-118.70299, 34.13344], [-118.70263, 34.13507], [-118.70242, 34.13504], [-118.70246, 34.13481], [-118.70253, 34.13472], [-118.70254, 34.1346], [-118.70246, 34.13445], [-118.70233, 34.13449], [-118.70199, 34.13442], [-118.70197, 34.13438], [-118.70198, 34.1343], [-118.70207, 34.13416], [-118.70211, 34.13395], [-118.70221, 34.13372], [-118.70237, 34.13352], [-118.70261, 34.13343], [-118.70299, 34.13344]]]} | Open Access 1 | 46078 | Calabasas Bark Park | 29419 | 2059 | Las Virgenes Municipal Water District 398 | Special District 4 | Water District 13 | http://www.lvmwd.com/ | Special District 4 | 1040 | Calabasas, City of 310 | City 2 | City Agency 2 | http://www.cityofcalabasas.com/recreation/barkpark.html | Los Angeles 6 | 2.209 | Calabasas Bark Park | 0 | Local Park 2 | 4 |
11922 | 11922 | 11921 | {"type": "Polygon", "coordinates": [[[-118.52735, 34.42936], [-118.52648, 34.4312], [-118.52377, 34.4344], [-118.52375, 34.4344], [-118.52373, 34.43438], [-118.52366, 34.4344], [-118.52366, 34.43443], [-118.52356, 34.43446], [-118.52356, 34.43443], [-118.52349, 34.43445], [-118.52292, 34.43464], [-118.52289, 34.43469], [-118.51956, 34.43606], [-118.51934, 34.43614], [-118.51921, 34.4362], [-118.51911, 34.43628], [-118.51872, 34.4365], [-118.51866, 34.43641], [-118.51824, 34.43627], [-118.51752, 34.43616], [-118.51675, 34.43564], [-118.51612, 34.43492], [-118.51601, 34.43454], [-118.51599, 34.43359], [-118.51617, 34.43263], [-118.51638, 34.43244], [-118.51689, 34.43217], [-118.51741, 34.43224], [-118.5181, 34.43224], [-118.51831, 34.43207], [-118.51831, 34.43205], [-118.51798, 34.43182], [-118.51716, 34.43158], [-118.51793, 34.43112], [-118.51839, 34.43118], [-118.51902, 34.43111], [-118.51991, 34.43113], [-118.52057, 34.43153], [-118.521, 34.43155], [-118.52124, 34.43111], [-118.52235, 34.4297], [-118.52232, 34.42936], [-118.52204, 34.42904], [-118.52188, 34.42879], [-118.52198, 34.42861], [-118.52249, 34.42859], [-118.52301, 34.42894], [-118.52339, 34.42892], [-118.52384, 34.42887], [-118.52422, 34.42833], [-118.52466, 34.42818], [-118.52512, 34.42828], [-118.5253, 34.42868], [-118.52648, 34.42868], [-118.52735, 34.42936]]]} | Open Access 1 | 24527 | Central Park | 5954 | 2340 | Castaic Lake Water Agency 1002 | Special District 4 | Water District 13 | http://clwa.org/ | Special District 4 | 1319 | Santa Clarita, City of 322 | City 2 | City Agency 2 | http://www.santa-clarita.com/index.aspx?page=409 | Los Angeles 6 | 122.849 | Central Park | 0 | Local Park 2 | 4 |
3149 | 3149 | 3148 | {"type": "Polygon", "coordinates": [[[-121.55129, 39.10154], [-121.55129, 39.10208], [-121.55128, 39.10252], [-121.55114, 39.1024], [-121.55101, 39.10223], [-121.55098, 39.10215], [-121.55097, 39.10202], [-121.55102, 39.10186], [-121.5512, 39.1015], [-121.55129, 39.10154]]]} | Open Access 1 | 21674 | Chestnut Park | 17183 | 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 | 0.52 | Chestnut Park | 0 | Local Park 2 | 4 | |
14930 | 14930 | 14929 | {"type": "Polygon", "coordinates": [[[-120.14308, 39.16907], [-120.14254, 39.16948], [-120.14177, 39.17015], [-120.1403, 39.17133], [-120.14004, 39.17112], [-120.14008, 39.17111], [-120.14018, 39.17102], [-120.14023, 39.17089], [-120.14024, 39.17067], [-120.14032, 39.1705], [-120.14044, 39.17038], [-120.1406, 39.17007], [-120.14074, 39.16998], [-120.14119, 39.16984], [-120.14143, 39.16975], [-120.14154, 39.16966], [-120.14166, 39.16946], [-120.14176, 39.16907], [-120.14308, 39.16907]]]} | Open Access 1 | 45515 | Commons Beach | 28348 | 2260 | Tahoe City Public Utilities District 993 | Special District 4 | Water District 13 | http://www.tahoecitypud.com/parksrec.shtml | Special District 4 | 2260 | Tahoe City Public Utilities District 658 | Special District 4 | Water District 13 | http://www.tahoecitypud.com/parksrec/4e3_commons_beach.shtml | Placer 35 | 4.738 | Commons Beach | 0 | Local Park 2 | 4 |
7403 | 7403 | 7402 | {"type": "Polygon", "coordinates": [[[-115.52333, 32.73492], [-115.52289, 32.73493], [-115.5229, 32.73582], [-115.52163, 32.73582], [-115.52163, 32.73574], [-115.52196, 32.73573], [-115.52195, 32.73434], [-115.52214, 32.73435], [-115.52233, 32.7344], [-115.52265, 32.73459], [-115.52333, 32.73458], [-115.52333, 32.73492]]]} | Open Access 1 | 48439 | Edward "Jiggs" Johnson Park | 33143 | 2278 | Heber Public Utility District 661 | Special District 4 | Water District 13 | http://heber.ca.gov/index.php | Special District 4 | 2278 | Heber Public Utility District 648 | Special District 4 | Water District 13 | http://www.heber.ca.gov/content/edward-jiggs-johnson-park | Imperial 20 | 3.734 | Edward "Jiggs" Johnson Park | 0 | Local Park 2 | 4 |
12961 | 12961 | 12960 | {"type": "Polygon", "coordinates": [[[-115.54303, 32.74155], [-115.54223, 32.74155], [-115.54222, 32.73903], [-115.54219, 32.73886], [-115.54205, 32.73852], [-115.54202, 32.73835], [-115.54235, 32.73834], [-115.54235, 32.73805], [-115.54297, 32.73805], [-115.54303, 32.74155]]]} | Open Access 1 | 30425 | Estancia Park | 18721 | 2278 | Heber Public Utility District 661 | Special District 4 | Water District 13 | http://heber.ca.gov/index.php | Special District 4 | 2278 | Heber Public Utility District 648 | Special District 4 | Water District 13 | Imperial 20 | 7.047 | Estancia Park | 0 | Local Park 2 | 4 | |
9840 | 9840 | 9839 | {"type": "MultiPolygon", "coordinates": [[[[-121.89924, 37.3355], [-121.89884, 37.33569], [-121.89868, 37.33547], [-121.89885, 37.33538], [-121.89861, 37.33506], [-121.89884, 37.33495], [-121.89924, 37.3355]]], [[[-121.90042, 37.33596], [-121.8999, 37.33606], [-121.89902, 37.33487], [-121.89968, 37.33457], [-121.89985, 37.33495], [-121.89995, 37.33526], [-121.90009, 37.33556], [-121.90042, 37.33596]]], [[[-121.89948, 37.33581], [-121.89908, 37.336], [-121.89906, 37.33598], [-121.89912, 37.33575], [-121.8991, 37.33573], [-121.89933, 37.33562], [-121.89948, 37.33581]]]]} | Open Access 1 | 16820 | Guadalupe River Park | 11940 | 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 | http://www.sanjoseca.gov/index.aspx?nid=2833 | Santa Clara 19 | 2.779 | Guadalupe River Park | 0 | Local Park 2 | 4 |
5974 | 5974 | 5973 | {"type": "Polygon", "coordinates": [[[-116.99133, 32.78393], [-116.99033, 32.78407], [-116.9903, 32.78611], [-116.9902, 32.78659], [-116.99031, 32.78666], [-116.98969, 32.78726], [-116.98908, 32.7869], [-116.98894, 32.78687], [-116.98882, 32.78688], [-116.98873, 32.78691], [-116.98866, 32.78696], [-116.9883, 32.78737], [-116.98484, 32.78841], [-116.98451, 32.78765], [-116.98457, 32.78745], [-116.98513, 32.78701], [-116.98552, 32.78636], [-116.98551, 32.78634], [-116.98504, 32.78641], [-116.98498, 32.78634], [-116.98558, 32.78624], [-116.98632, 32.78621], [-116.9863, 32.78563], [-116.9861, 32.78543], [-116.98482, 32.78557], [-116.9848, 32.78547], [-116.98471, 32.78547], [-116.98442, 32.78522], [-116.9846, 32.78505], [-116.98456, 32.78493], [-116.98762, 32.78417], [-116.98785, 32.78409], [-116.98887, 32.78392], [-116.99128, 32.78386], [-116.99133, 32.78393]]]} | Open Access 1 | 649 | Harry Griffen Park | 19707 | 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 | http://www.cityoflamesa.com/391/Harry-Griffen-Regional-Park | San Diego 4 | 44.251 | Harry Griffen Park | 0 | Local Park 2 | 4 |
12960 | 12960 | 12959 | {"type": "Polygon", "coordinates": [[[-115.53155, 32.73148], [-115.53126, 32.73148], [-115.53109, 32.73143], [-115.53101, 32.73145], [-115.53086, 32.73122], [-115.53155, 32.73119], [-115.53155, 32.73148]]]} | Open Access 1 | 30424 | Heber Children Park | 19788 | 2278 | Heber Public Utility District 661 | Special District 4 | Water District 13 | http://heber.ca.gov/index.php | Special District 4 | 2278 | Heber Public Utility District 648 | Special District 4 | Water District 13 | Imperial 20 | 0.422 | Heber Children Park | 0 | Local Park 2 | 4 | |
11262 | 11262 | 11261 | {"type": "Polygon", "coordinates": [[[-121.53733, 39.07823], [-121.53719, 39.07869], [-121.537, 39.07865], [-121.53637, 39.07861], [-121.53637, 39.07855], [-121.53649, 39.07851], [-121.53653, 39.07843], [-121.53649, 39.07833], [-121.53646, 39.07831], [-121.53646, 39.07826], [-121.53669, 39.07826], [-121.53692, 39.07823], [-121.53733, 39.07823]]]} | Open Access 1 | 21695 | Johnson Park | 20479 | 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 | 0.76 | Johnson Park | 0 | Local Park 2 | 4 | |
11263 | 11263 | 11262 | {"type": "Polygon", "coordinates": [[[-121.55363, 39.08252], [-121.55312, 39.08256], [-121.55308, 39.08148], [-121.55359, 39.08164], [-121.55363, 39.08252]]]} | Open Access 1 | 21696 | Kartikeya Avenue Park | 20555 | 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 | 1.182 | Kartikeya Avenue Park | 0 | Local Park 2 | 4 | |
14970 | 14970 | 14969 | {"type": "Polygon", "coordinates": [[[-120.15795, 39.13429], [-120.15786, 39.13569], [-120.15552, 39.13559], [-120.15642, 39.13422], [-120.15795, 39.13429]]]} | Open Access 1 | 45583 | Kilner Park | 28409 | 2260 | Tahoe City Public Utilities District 993 | Special District 4 | Water District 13 | http://www.tahoecitypud.com/parksrec.shtml | Special District 4 | 2260 | Tahoe City Public Utilities District 658 | Special District 4 | Water District 13 | https://www.tcpud.org/parks-recreation/facilities-parks-and-rentals/parks/kilner-park | Placer 35 | 6.423 | Kilner Park | 0 | Local Park 2 | 4 |
11876 | 11876 | 11875 | {"type": "Polygon", "coordinates": [[[-120.11571, 39.1806], [-120.11568, 39.18066], [-120.11555, 39.18075], [-120.11512, 39.18076], [-120.11498, 39.18084], [-120.11442, 39.18138], [-120.11424, 39.18139], [-120.11419, 39.1813], [-120.11437, 39.18121], [-120.11442, 39.18108], [-120.11455, 39.18091], [-120.11474, 39.18052], [-120.11432, 39.18023], [-120.11388, 39.17996], [-120.11386, 39.1799], [-120.11374, 39.17984], [-120.11375, 39.17968], [-120.11395, 39.17941], [-120.11435, 39.17916], [-120.11455, 39.17905], [-120.11478, 39.17905], [-120.11469, 39.17913], [-120.11465, 39.1793], [-120.11467, 39.17939], [-120.1146, 39.17983], [-120.11474, 39.18003], [-120.11493, 39.18017], [-120.11517, 39.18021], [-120.11555, 39.18034], [-120.11569, 39.18033], [-120.11571, 39.1806]]]} | Open Access 1 | 24329 | Lake Forest Beach Park | 20886 | 2260 | Tahoe City Public Utilities District 993 | Special District 4 | Water District 13 | http://www.tahoecitypud.com/parksrec.shtml | Special District 4 | 2260 | Tahoe City Public Utilities District 658 | Special District 4 | Water District 13 | Placer 35 | 3.69 | Lake Forest Beach Park | 0 | Local Park 2 | 4 | |
7625 | 7625 | 7624 | {"type": "MultiPolygon", "coordinates": [[[[-116.89597, 32.87039], [-116.89476, 32.87018], [-116.89394, 32.86984], [-116.89368, 32.86962], [-116.89373, 32.86769], [-116.89372, 32.8676], [-116.89368, 32.86751], [-116.89596, 32.8658], [-116.89597, 32.87039]]], [[[-116.8936, 32.86756], [-116.89363, 32.86765], [-116.89364, 32.86772], [-116.89358, 32.86986], [-116.89357, 32.87022], [-116.8935, 32.87096], [-116.89335, 32.87089], [-116.89337, 32.86769], [-116.8936, 32.86756]]], [[[-116.90722, 32.87069], [-116.90714, 32.87081], [-116.90694, 32.87096], [-116.9067, 32.87108], [-116.90642, 32.87116], [-116.90433, 32.87136], [-116.90416, 32.87142], [-116.90402, 32.87153], [-116.90394, 32.87156], [-116.90374, 32.87154], [-116.90353, 32.87154], [-116.9031, 32.87161], [-116.90292, 32.87158], [-116.90311, 32.87154], [-116.90357, 32.87148], [-116.90722, 32.87069]]], [[[-116.9141, 32.87162], [-116.91382, 32.87179], [-116.91141, 32.87297], [-116.91112, 32.87314], [-116.91085, 32.87334], [-116.91053, 32.87314], [-116.90986, 32.87079], [-116.9098, 32.87051], [-116.911, 32.87044], [-116.91101, 32.87046], [-116.91262, 32.87037], [-116.91342, 32.87076], [-116.9141, 32.87162]]], [[[-116.91044, 32.87316], [-116.9095, 32.87297], [-116.90915, 32.8728], [-116.90863, 32.87251], [-116.90752, 32.87279], [-116.907, 32.87282], [-116.90671, 32.87288], [-116.90642, 32.87407], [-116.90624, 32.87408], [-116.90616, 32.87428], [-116.89855, 32.87272], [-116.89856, 32.87268], [-116.89732, 32.87243], [-116.89706, 32.87241], [-116.89353, 32.87168], [-116.89367, 32.87022], [-116.89368, 32.8699], [-116.8939, 32.86992], [-116.89473, 32.87026], [-116.89597, 32.87048], [-116.89598, 32.87065], [-116.89695, 32.87065], [-116.90083, 32.87134], [-116.90228, 32.87168], [-116.90277, 32.87162], [-116.90289, 32.87166], [-116.90308, 32.87169], [-116.90317, 32.87169], [-116.90353, 32.87162], [-116.90398, 32.87164], [-116.90407, 32.8716], [-116.90423, 32.87148], [-116.90434, 32.87144], [-116.9064, 32.87125], [-116.90675, 32.87114], [-116.90701, 32.87102], [-116.90723, 32.87085], [-116.90732, 32.87071], [-116.90868, 32.87084], [-116.90869, 32.87061], [-116.90969, 32.87057], [-116.91044, 32.87316]]], [[[-116.89566, 32.85751], [-116.89342, 32.85751], [-116.89337, 32.86613], [-116.89403, 32.86614], [-116.89453, 32.8666], [-116.89341, 32.86746], [-116.89309, 32.86763], [-116.89281, 32.86773], [-116.89247, 32.86779], [-116.88826, 32.86821], [-116.88772, 32.86836], [-116.8872, 32.86856], [-116.88693, 32.86869], [-116.88665, 32.86886], [-116.88641, 32.86902], [-116.88619, 32.8692], [-116.88407, 32.87126], [-116.88377, 32.8715], [-116.8838, 32.87152], [-116.88366, 32.87162], [-116.88345, 32.87173], [-116.88137, 32.87279], [-116.87889, 32.87367], [-116.87932, 32.87229], [-116.87972, 32.87225], [-116.88025, 32.87202], [-116.88125, 32.87055], [-116.88162, 32.87025], [-116.88244, 32.87025], [-116.88265, 32.86987], [-116.88297, 32.86966], [-116.88326, 32.86961], [-116.88365, 32.86925], [-116.88417, 32.86927], [-116.88457, 32.86898], [-116.8847, 32.86881], [-116.88481, 32.86856], [-116.88521, 32.8681], [-116.88563, 32.86776], [-116.88464, 32.86714], [-116.88375, 32.86786], [-116.88283, 32.86782], [-116.88159, 32.86525], [-116.8793, 32.86382], [-116.87858, 32.86447], [-116.8772, 32.86408], [-116.87506, 32.86273], [-116.87552, 32.86146], [-116.87521, 32.86087], [-116.87619, 32.85707], [-116.88026, 32.85584], [-116.88051, 32.85553], [-116.88632, 32.85219], [-116.88653, 32.85219], [-116.88651, 32.85209], [-116.88706, 32.85177], [-116.88728, 32.85168], [-116.88727, 32.85164], [-116.89303, 32.85161], [-116.89312, 32.85162], [-116.89318, 32.85187], [-116.89321, 32.85207], [-116.89321, 32.85233], [-116.89313, 32.85388], [-116.89316, 32.85389], [-116.89312, 32.85479], [-116.89315, 32.85519], [-116.8933, 32.85562], [-116.89339, 32.85582], [-116.89353, 32.85604], [-116.8935, 32.85607], [-116.89356, 32.85615], [-116.89377, 32.85641], [-116.89406, 32.85669], [-116.89443, 32.85694], [-116.89478, 32.85712], [-116.89509, 32.85723], [-116.89566, 32.8574], [-116.89566, 32.85751]], [[-116.87569, 32.86125], [-116.87566, 32.86122], [-116.87564, 32.86129], [-116.87565, 32.8613], [-116.87569, 32.86125]], [[-116.89257, 32.85521], [-116.89264, 32.85472], [-116.89281, 32.85399], [-116.89287, 32.85387], [-116.89287, 32.85382], [-116.89263, 32.8533], [-116.89246, 32.85282], [-116.89244, 32.85278], [-116.89238, 32.85277], [-116.89219, 32.85284], [-116.89196, 32.85287], [-116.89176, 32.85284], [-116.89158, 32.85278], [-116.89153, 32.85291], [-116.89133, 32.85319], [-116.89125, 32.85326], [-116.89096, 32.85343], [-116.89087, 32.85376], [-116.89061, 32.85412], [-116.89044, 32.85425], [-116.89029, 32.85431], [-116.89012, 32.85433], [-116.88938, 32.8543], [-116.88926, 32.85426], [-116.88916, 32.85419], [-116.88882, 32.85383], [-116.88879, 32.85375], [-116.88878, 32.85331], [-116.88928, 32.85235], [-116.88929, 32.85231], [-116.88927, 32.85227], [-116.88923, 32.85223], [-116.88916, 32.85222], [-116.88885, 32.85227], [-116.88866, 32.85233], [-116.88852, 32.85233], [-116.88841, 32.85229], [-116.88806, 32.85205], [-116.88791, 32.85197], [-116.88772, 32.85193], [-116.8874, 32.8519], [-116.88786, 32.85277], [-116.88822, 32.85433], [-116.88994, 32.85587], [-116.89049, 32.85576], [-116.89165, 32.85541], [-116.89235, 32.85525], [-116.89257, 32.85521]]], [[[-116.87838, 32.87524], [-116.87776, 32.87717], [-116.87721, 32.87745], [-116.87688, 32.87753], [-116.87649, 32.87781], [-116.87572, 32.87826], [-116.87552, 32.8784], [-116.87503, 32.87865], [-116.87451, 32.87887], [-116.87407, 32.87889], [-116.8736, 32.87912], [-116.87321, 32.87926], [-116.87272, 32.8794], [-116.8687, 32.88009], [-116.86809, 32.88028], [-116.8676, 32.88032], [-116.86711, 32.88046], [-116.86657, 32.88055], [-116.86648, 32.88062], [-116.86503, 32.88129], [-116.86441, 32.88154], [-116.86402, 32.88174], [-116.86353, 32.88218], [-116.86295, 32.88257], [-116.86253, 32.88296], [-116.8622, 32.88334], [-116.86116, 32.88209], [-116.86121, 32.8821], [-116.8613, 32.882], [-116.86116, 32.8819], [-116.8627, 32.88022], [-116.86377, 32.87955], [-116.86596, 32.87879], [-116.86809, 32.87822], [-116.86833, 32.87821], [-116.86854, 32.87823], [-116.87011, 32.87865], [-116.87025, 32.87868], [-116.8704, 32.87868], [-116.87161, 32.87855], [-116.87187, 32.8785], [-116.87214, 32.8784], [-116.87436, 32.87714], [-116.87441, 32.87722], [-116.87644, 32.87617], [-116.8765, 32.87622], [-116.87838, 32.87524]]], [[[-116.89333, 32.87218], [-116.89332, 32.87414], [-116.89247, 32.87416], [-116.89256, 32.88587], [-116.88717, 32.88725], [-116.88716, 32.87491], [-116.88715, 32.87491], [-116.8869, 32.87517], [-116.88683, 32.87519], [-116.88694, 32.87509], [-116.88704, 32.87493], [-116.88835, 32.87341], [-116.88883, 32.8729], [-116.8892, 32.87214], [-116.8893, 32.87206], [-116.88935, 32.87197], [-116.8894, 32.87196], [-116.88959, 32.87186], [-116.88964, 32.87185], [-116.8897, 32.87187], [-116.89017, 32.87182], [-116.89155, 32.87191], [-116.89333, 32.87218]]], [[[-116.86247, 32.88343], [-116.85911, 32.88809], [-116.85952, 32.88861], [-116.85953, 32.88893], [-116.85734, 32.89051], [-116.85709, 32.88997], [-116.85714, 32.88955], [-116.85743, 32.88911], [-116.85776, 32.88849], [-116.85854, 32.88762], [-116.8584, 32.88744], [-116.8623, 32.88345], [-116.86247, 32.88343]]]]} | Open Access 1 | 7358 | Lake Jennings Park | 4419 | 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 | http://lakejennings.org/ | San Diego 4 | 1018.243 | Lake Jennings Park | 0 | Local Park 2 | 4 |
11261 | 11261 | 11260 | {"type": "Polygon", "coordinates": [[[-121.55442, 39.07704], [-121.55299, 39.07701], [-121.55298, 39.07619], [-121.55424, 39.07619], [-121.55442, 39.07704]]]} | Open Access 1 | 21694 | Lindhurst Memorial Park | 21298 | 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.661 | Lindhurst Memorial Park | 0 | Local Park 2 | 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]);