units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,190 rows where DES_TP = 14 sorted by AGNCY_NAME descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_LEV, AGNCY_TYP, LAYER, PARK_URL, YR_EST
MNG_AGENCY >30
- Mountains Recreation and Conservation Authority 152
- Ventura, City of 106
- Butte, County of 52
- Yuba County Water Agency 48
- Roseville, City of 46
- Santa Barbara, County of 39
- Lake, County of 36
- Poway, City of 35
- Irvine, City of 29
- Los Angeles, City of 26
- California City, City of 25
- Encinitas, City of 21
- Orange, County of 21
- Napa, City of 21
- Monterey, County of 18
- Rocklin, City of 17
- Seaside, City of 16
- San Diego, City of 15
- Lompoc, City of 14
- Los Angeles County Flood Control District 13
- Santa Cruz, City of 12
- Santa Barbara Flood Control and Water Conserv. District 12
- Oroville, City of 12
- Los Angeles, County of 11
- Santa Barbara, City of 11
- Mammoth Lakes, Town of 11
- Auburn, City of 11
- Guadalupe, City of 10
- Santa Maria, City of 9
- Escondido, City of 9
- …
MNG_AG_TYP 15
- City Agency 663
- County Agency 214
- Open Space District 155
- Water District 78
- Flood District 32
- Recreation/Parks District 28
- County Agency - Other 6
- Irrigation District 4
- Sanitation District 3
- Community Services District 2
- County Agency - Parks 1
- Special District - Other 1
- Metropolitan Planning Organization 1
- Conservation District 1
- Transportation Agency 1
ACCESS_TYP 4
- Open Access 859
- Unknown Access 204
- No Public Access 96
- Restricted Access 31
MNG_AG_LEV 3 ✖
- City 663
- Special District 306
- County 221
DES_TP 1
- Local Other or Unknown · 1,190 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15325 | 15325 | 15324 | {"type": "Polygon", "coordinates": [[[-117.85818, 34.19361], [-117.85655, 34.19631], [-117.85599, 34.19646], [-117.85577, 34.1973], [-117.85578, 34.19593], [-117.85608, 34.19586], [-117.85744, 34.1936], [-117.85818, 34.19361]]]} | No Public Access 3 | 48970 | Unnamed Site - Pasadena Department of Water and Power | 33667 | 1720 | Pasadena Department of Water and Power 1153 | City 2 | City Agency 2 | https://ww5.cityofpasadena.net/water-and-power/ | City 2 | 1720 | Pasadena Department of Water and Power 1099 | City 2 | City Agency 2 | Los Angeles 6 | 5.621 | 0 | Local Other or Unknown 14 | 4 | ||
14774 | 14774 | 14773 | {"type": "MultiPolygon", "coordinates": [[[[-117.3104, 33.20185], [-117.31053, 33.20215], [-117.31063, 33.20246], [-117.31076, 33.20299], [-117.31074, 33.20304], [-117.31069, 33.20307], [-117.31012, 33.2032], [-117.30901, 33.2034], [-117.308, 33.20353], [-117.30733, 33.20359], [-117.30597, 33.20366], [-117.30496, 33.20366], [-117.30145, 33.20359], [-117.30076, 33.20359], [-117.30007, 33.20361], [-117.29904, 33.20369], [-117.29686, 33.20395], [-117.29686, 33.20297], [-117.30621, 33.20241], [-117.30709, 33.20231], [-117.30775, 33.20222], [-117.31037, 33.2018], [-117.3104, 33.20185]]], [[[-117.31023, 33.20153], [-117.3077, 33.20193], [-117.30618, 33.20213], [-117.29686, 33.2027], [-117.29686, 33.20126], [-117.3063, 33.20135], [-117.31012, 33.20136], [-117.31023, 33.20153]]]]} | Unknown Access 4 | 45152 | North County Transit District Mitigation | 22817 | 2323 | North County Transit District 1046 | Special District 4 | Transportation Agency 32 | http://www.gonctd.com/ | Special District 4 | 2323 | North County Transit District 1006 | Special District 4 | Transportation Agency 34 | San Diego 4 | 69.998 | North County Transit District Mitigation | 0 | Local Other or Unknown 14 | 4 | |
13013 | 13013 | 13012 | {"type": "MultiPolygon", "coordinates": [[[[-121.91526, 38.26143], [-121.91525, 38.26144], [-121.91516, 38.26502], [-121.90682, 38.27189], [-121.89801, 38.2782], [-121.89805, 38.27195], [-121.89805, 38.26472], [-121.87929, 38.26469], [-121.87927, 38.27171], [-121.87387, 38.27167], [-121.87397, 38.27128], [-121.87929, 38.26469], [-121.89614, 38.24998], [-121.89617, 38.24991], [-121.89819, 38.24991], [-121.89826, 38.24289], [-121.91522, 38.24301], [-121.91521, 38.25733], [-121.91525, 38.26116], [-121.91523, 38.26117], [-121.91526, 38.26143]]], [[[-121.91491, 38.27353], [-121.91447, 38.28644], [-121.90677, 38.28644], [-121.89698, 38.28637], [-121.90575, 38.28009], [-121.90633, 38.27971], [-121.91491, 38.27353]]]]} | No Public Access 3 | 31205 | Wilcox Ranch | 27494 | 344 | Solano, County of 1037 | County 3 | County Agency 3 | http://www.co.solano.ca.us/depts/rm/countypark/homepage.asp | County 3 | 344 | Solano, County of 999 | County 3 | County Agency 3 | Solano 26 | 1870.595 | Wilcox Ranch | 0 | Local Other or Unknown 14 | 4 | |
12733 | 12733 | 12732 | {"type": "MultiPolygon", "coordinates": [[[[-122.50606, 38.01702], [-122.50538, 38.01773], [-122.50389, 38.0179], [-122.5039, 38.01851], [-122.4971, 38.01865], [-122.48, 38.02023], [-122.47926, 38.02067], [-122.47925, 38.02058], [-122.47924, 38.02057], [-122.46957, 38.02491], [-122.46829, 38.02814], [-122.46444, 38.03432], [-122.45826, 38.01394], [-122.45798, 38.00928], [-122.45797, 38.00928], [-122.45718, 38.01038], [-122.45356, 37.99846], [-122.46201, 38.00454], [-122.47026, 38.00744], [-122.47894, 38.01033], [-122.48622, 38.01267], [-122.48627, 38.01271], [-122.48923, 38.01368], [-122.49539, 38.01456], [-122.50181, 38.01539], [-122.50328, 38.01578], [-122.50332, 38.0158], [-122.50338, 38.01576], [-122.50344, 38.01707], [-122.50606, 38.01702]]], [[[-122.49754, 38.02919], [-122.49296, 38.02924], [-122.49287, 38.02566], [-122.49743, 38.02564], [-122.49754, 38.02919]]]]} | Open Access 1 | 29763 | Water Lots | 27293 | 353 | Marin, County of 1034 | County 3 | County Agency 3 | http://www.marincounty.org/recreation/parks-in-marin | County 3 | 353 | Marin, County of 996 | County 3 | County Agency 3 | Marin 23 | 1356.794 | Water Lots | 1976 | Local Other or Unknown 14 | 4 | |
13929 | 13929 | 13928 | {"type": "Polygon", "coordinates": [[[-123.04559, 40.72947], [-123.045, 40.72987], [-123.04219, 40.72785], [-123.04232, 40.72778], [-123.0429, 40.72771], [-123.04327, 40.72772], [-123.04361, 40.72778], [-123.04451, 40.7284], [-123.04485, 40.72886], [-123.04559, 40.72947]]]} | Open Access 1 | 36535 | Trinity holding 1 | 26540 | 349 | Trinity, County of 1022 | County 3 | County Agency 3 | http://www.trinitycounty.org/ | County 3 | 349 | Trinity, County of 984 | County 3 | County Agency 3 | Trinity 46 | 6.066 | Trinity holding 1 | 0 | Local Other or Unknown 14 | 4 | |
12249 | 12249 | 12248 | {"type": "MultiPolygon", "coordinates": [[[[-120.4581, 37.66306], [-120.45807, 37.66498], [-120.45808, 37.66542], [-120.45707, 37.66528], [-120.45597, 37.66483], [-120.45469, 37.6645], [-120.45292, 37.66353], [-120.45213, 37.6633], [-120.45095, 37.66331], [-120.44582, 37.66483], [-120.44264, 37.66619], [-120.44239, 37.66704], [-120.4429, 37.66834], [-120.44449, 37.66942], [-120.44499, 37.67024], [-120.44507, 37.6707], [-120.44468, 37.67196], [-120.44451, 37.67195], [-120.44413, 37.67231], [-120.4442, 37.67238], [-120.44432, 37.67247], [-120.44448, 37.67253], [-120.4446, 37.67256], [-120.44456, 37.67299], [-120.44383, 37.67412], [-120.44205, 37.67462], [-120.44139, 37.67412], [-120.44162, 37.67396], [-120.44164, 37.67392], [-120.44164, 37.67374], [-120.44175, 37.67357], [-120.44237, 37.67322], [-120.44307, 37.67272], [-120.44313, 37.67155], [-120.44304, 37.67151], [-120.44276, 37.67145], [-120.44258, 37.67117], [-120.44266, 37.67084], [-120.44264, 37.67077], [-120.44247, 37.67048], [-120.44211, 37.6702], [-120.44208, 37.67012], [-120.44206, 37.66974], [-120.44176, 37.66924], [-120.44155, 37.66915], [-120.44135, 37.66925], [-120.44115, 37.66917], [-120.44061, 37.66888], [-120.44022, 37.66903], [-120.43995, 37.66926], [-120.43956, 37.66936], [-120.43934, 37.66911], [-120.43942, 37.66889], [-120.43942, 37.66882], [-120.43957, 37.66846], [-120.4396, 37.66791], [-120.43965, 37.66758], [-120.43945, 37.66728], [-120.4389, 37.66694], [-120.43818, 37.667], [-120.43768, 37.66672], [-120.44064, 37.66672], [-120.44097, 37.66699], [-120.44097, 37.66722], [-120.44079, 37.66791], [-120.4408, 37.66808], [-120.44211, 37.66906], [-120.44333, 37.67067], [-120.44409, 37.67222], [-120.4441, 37.67221], [-120.44365, 37.67056], [-120.44239, 37.66888], [-120.44115, 37.66795], [-120.4413, 37.667], [-120.4411, 37.66672], [-120.44116, 37.6667], [-120.44105, 37.66585], [-120.44105, 37.66569], [-120.44115, 37.66504], [-120.44114, 37.66479], [-120.44096, 37.66429], [-120.44096, 37.66418], [-120.44127, 37.66392], [-120.4415, 37.66402], [-120.44191, 37.66403], [-120.44322, 37.66379], [-120.44355, 37.66352], [-120.44365, 37.6635], [-120.44613, 37.66348], [-120.44737, 37.66286], [-120.44899, 37.66304], [-120.45008, 37.66282], [-120.45062, 37.66228], [-120.45064, 37.66133], [-120.45102, 37.66105], [-120.45126, 37.66104], [-120.45125, 37.66305], [-120.4581, 37.66306]]], [[[-120.44902, 37.65939], [-120.44899, 37.66234], [-120.4484, 37.66246], [-120.44757, 37.66236], [-120.44763, 37.65939], [-120.44902, 37.65939]]], [[[-120.46249, 37.65702], [-120.46152, 37.6619], [-120.4597, 37.66152], [-120.45905, 37.66151], [-120.45764, 37.66153], [-120.45682, 37.66144], [-120.45634, 37.66131], [-120.45689, 37.66107], [-120.45787, 37.66141], [-120.4592, 37.66132], [-120.45958, 37.66118], [-120.45969, 37.66071], [-120.46021, 37.66014], [-120.46075, 37.65941], [-120.46119, 37.65892], [-120.46133, 37.65826], [-120.46115, 37.65782], [-120.46028, 37.65721], [-120.45968, 37.65721], [-120.45897, 37.65657], [-120.45841, 37.65564], [-120.45827, 37.65464], [-120.45845, 37.65412], [-120.45853, 37.65405], [-120.45959, 37.65373], [-120.45956, 37.65386], [-120.4595, 37.6545], [-120.46249, 37.65702]]]]} | Open Access 1 | 25751 | Turlock Irrigation District | 26581 | 2273 | Turlock Irrigation District 1016 | Special District 4 | Irrigation District 17 | http://www.tid.org/ | Special District 4 | 2273 | Turlock Irrigation District 978 | Special District 4 | Irrigation District 16 | Stanislaus 2 | 152.049 | Turlock Irrigation District | 0 | Local Other or Unknown 14 | 4 | |
12247 | 12247 | 12246 | {"type": "MultiPolygon", "coordinates": [[[[-120.45234, 37.66491], [-120.45126, 37.66492], [-120.4513, 37.66851], [-120.44674, 37.6685], [-120.44673, 37.66851], [-120.44674, 37.67122], [-120.45132, 37.67124], [-120.45137, 37.67588], [-120.44916, 37.67588], [-120.44916, 37.674], [-120.44573, 37.674], [-120.44575, 37.67587], [-120.44458, 37.67586], [-120.44457, 37.67654], [-120.44205, 37.67462], [-120.44382, 37.67412], [-120.44455, 37.67299], [-120.44461, 37.67256], [-120.44475, 37.67257], [-120.4449, 37.67256], [-120.44505, 37.67252], [-120.44514, 37.67246], [-120.44483, 37.67199], [-120.44468, 37.67196], [-120.44507, 37.6707], [-120.44499, 37.67024], [-120.44449, 37.66942], [-120.44291, 37.66834], [-120.44239, 37.66704], [-120.44248, 37.66673], [-120.44261, 37.66672], [-120.44265, 37.66654], [-120.4428, 37.6663], [-120.44314, 37.66621], [-120.4433, 37.66615], [-120.4436, 37.66606], [-120.4438, 37.66594], [-120.44446, 37.66575], [-120.4451, 37.6655], [-120.44525, 37.66542], [-120.4455, 37.66526], [-120.44561, 37.66517], [-120.44655, 37.66479], [-120.44745, 37.66461], [-120.44802, 37.66442], [-120.4486, 37.66415], [-120.4489, 37.66403], [-120.44896, 37.66403], [-120.44897, 37.66546], [-120.44841, 37.66516], [-120.446, 37.66557], [-120.4447, 37.6664], [-120.44362, 37.66685], [-120.4434, 37.66746], [-120.44475, 37.66857], [-120.44489, 37.6691], [-120.44555, 37.66955], [-120.44602, 37.67113], [-120.44528, 37.67163], [-120.44515, 37.67243], [-120.44517, 37.67244], [-120.4453, 37.67229], [-120.44557, 37.6718], [-120.4461, 37.67146], [-120.44637, 37.67123], [-120.44639, 37.67116], [-120.44594, 37.66953], [-120.44588, 37.66942], [-120.4452, 37.66891], [-120.44506, 37.66845], [-120.44381, 37.66745], [-120.44378, 37.66737], [-120.44391, 37.66706], [-120.44474, 37.66674], [-120.44475, 37.66672], [-120.44619, 37.66585], [-120.44834, 37.66548], [-120.44899, 37.66585], [-120.44902, 37.66671], [-120.44904, 37.66672], [-120.44902, 37.66585], [-120.44936, 37.66604], [-120.45033, 37.66568], [-120.45153, 37.66468], [-120.45209, 37.66468], [-120.45234, 37.66491]]], [[[-120.45863, 37.66709], [-120.45837, 37.66745], [-120.45807, 37.66728], [-120.45701, 37.66699], [-120.45657, 37.66648], [-120.45591, 37.66655], [-120.45586, 37.66493], [-120.45287, 37.66491], [-120.4523, 37.66438], [-120.45142, 37.66437], [-120.45017, 37.66539], [-120.44941, 37.66567], [-120.449, 37.66546], [-120.44899, 37.66389], [-120.45094, 37.66331], [-120.45214, 37.6633], [-120.45292, 37.66353], [-120.45469, 37.6645], [-120.45597, 37.66483], [-120.45707, 37.66528], [-120.45808, 37.66542], [-120.45807, 37.66685], [-120.45863, 37.66709]]], [[[-120.4581, 37.66852], [-120.45593, 37.66852], [-120.45592, 37.66685], [-120.45642, 37.6668], [-120.45679, 37.66726], [-120.45787, 37.66754], [-120.45809, 37.66767], [-120.4581, 37.66852]]], [[[-120.46353, 37.67073], [-120.46336, 37.67081], [-120.46178, 37.67083], [-120.46161, 37.67074], [-120.46152, 37.67035], [-120.46215, 37.67035], [-120.46214, 37.67076], [-120.46273, 37.67071], [-120.46274, 37.67073], [-120.46353, 37.67073]]], [[[-120.46732, 37.67226], [-120.46714, 37.6722], [-120.46709, 37.67244], [-120.4668, 37.67265], [-120.46662, 37.67282], [-120.46272, 37.67278], [-120.46272, 37.67151], [-120.46155, 37.67149], [-120.46156, 37.67114], [-120.46174, 37.67122], [-120.46355, 37.67119], [-120.46422, 37.67085], [-120.4647, 37.67087], [-120.46593, 37.67124], [-120.46653, 37.67153], [-120.46679, 37.67169], [-120.46732, 37.67226]]], [[[-120.47223, 37.67317], [-120.4708, 37.6731], [-120.47028, 37.6729], [-120.47027, 37.67258], [-120.47085, 37.67281], [-120.47222, 37.6729], [-120.47223, 37.67317]]], [[[-120.47225, 37.67253], [-120.47103, 37.67244], [-120.4703, 37.67214], [-120.47223, 37.67225], [-120.47225, 37.67253]]], [[[-120.48912, 37.6657], [-120.4889, 37.66599], [-120.48853, 37.66657], [-120.48791, 37.6663], [-120.48855, 37.6654], [-120.48912, 37.6657]]], [[[-120.48983, 37.66609], [-120.48929, 37.66695], [-120.48896, 37.66679], [-120.48931, 37.66621], [-120.48953, 37.66592], [-120.48983, 37.66609]]]]} | Open Access 1 | 25750 | Modesto Irrigation District | 22339 | 2081 | Modesto Irrigation District 1015 | Special District 4 | Irrigation District 17 | http://www.mid.org/ | Special District 4 | 2081 | Modesto Irrigation District 977 | Special District 4 | Irrigation District 16 | Stanislaus 2 | 199.046 | Modesto Irrigation District | 0 | Local Other or Unknown 14 | 4 | |
13771 | 13771 | 13770 | {"type": "Polygon", "coordinates": [[[-124.26652, 40.57397], [-124.26609, 40.57438], [-124.26519, 40.5738], [-124.2651, 40.57372], [-124.26489, 40.57389], [-124.26428, 40.57333], [-124.26398, 40.5731], [-124.2646, 40.57245], [-124.26652, 40.57397]]]} | Open Access 1 | 36312 | Fortuna holding 1 | 19012 | 1434 | Fortuna, City of 1012 | City 2 | City Agency 2 | http://friendlyfortuna.com/index.aspx?nid=95 | City 2 | 1434 | Fortuna, City of 974 | City 2 | City Agency 2 | Humboldt 45 | 4.43 | Fortuna holding 1 | 0 | Local Other or Unknown 14 | 4 | |
13795 | 13795 | 13794 | {"type": "Polygon", "coordinates": [[[-124.14761, 40.57317], [-124.14645, 40.57224], [-124.14644, 40.5716], [-124.14561, 40.57078], [-124.14527, 40.57023], [-124.14525, 40.57021], [-124.1473, 40.57025], [-124.14761, 40.57317]]]} | Open Access 1 | 36363 | Fortuna holding 2 | 19013 | 1434 | Fortuna, City of 1012 | City 2 | City Agency 2 | http://friendlyfortuna.com/index.aspx?nid=95 | City 2 | 1434 | Fortuna, City of 974 | City 2 | City Agency 2 | Humboldt 45 | 7.731 | Fortuna holding 2 | 0 | Local Other or Unknown 14 | 4 | |
12230 | 12230 | 12229 | {"type": "Polygon", "coordinates": [[[-117.25793, 33.63037], [-117.25788, 33.63401], [-117.24921, 33.63405], [-117.24922, 33.63039], [-117.25793, 33.63037]]]} | Unknown Access 4 | 25434 | Rullo Property | 24729 | 2179 | Western Riverside County Regional Conservation Authority 957 | Special District 4 | Open Space District 6 | http://www.wrc-rca.org/ | Special District 4 | 2179 | Western Riverside County Regional Conservation Authority 927 | Special District 4 | Open Space District 6 | Riverside 10 | 80.657 | Rullo Property | 0 | Local Other or Unknown 14 | 4 | |
12231 | 12231 | 12230 | {"type": "MultiPolygon", "coordinates": [[[[-117.01207, 33.89306], [-117.00799, 33.89306], [-117.00392, 33.89308], [-117.0039, 33.88945], [-117.01204, 33.88947], [-117.01207, 33.89306]]], [[[-117.01712, 33.86029], [-117.01212, 33.86432], [-117.01211, 33.86385], [-117.00876, 33.86381], [-117.00888, 33.8632], [-117.00883, 33.86293], [-117.00883, 33.86274], [-117.00884, 33.86255], [-117.00889, 33.86234], [-117.00903, 33.86202], [-117.00962, 33.86102], [-117.00969, 33.8606], [-117.00985, 33.86032], [-117.01712, 33.86029]]], [[[-117.02922, 33.86478], [-117.01849, 33.87513], [-117.01632, 33.87516], [-117.01639, 33.86746], [-117.01212, 33.86747], [-117.01212, 33.86543], [-117.0185, 33.86028], [-117.0225, 33.86027], [-117.02922, 33.86478]]], [[[-117.04925, 33.8737], [-117.03855, 33.87392], [-117.0338, 33.86787], [-117.03376, 33.87467], [-117.02487, 33.87505], [-117.02495, 33.88948], [-117.01632, 33.88948], [-117.01639, 33.88239], [-117.01635, 33.87839], [-117.01978, 33.87511], [-117.02996, 33.86528], [-117.03062, 33.86572], [-117.03126, 33.86602], [-117.0333, 33.8668], [-117.03366, 33.86691], [-117.03409, 33.86698], [-117.03432, 33.86699], [-117.03472, 33.86697], [-117.03495, 33.86694], [-117.03521, 33.86689], [-117.03625, 33.86661], [-117.03763, 33.86615], [-117.03793, 33.86609], [-117.03815, 33.86607], [-117.03847, 33.86609], [-117.03878, 33.86616], [-117.03898, 33.86623], [-117.03927, 33.86639], [-117.04041, 33.86722], [-117.04227, 33.86874], [-117.0427, 33.86904], [-117.04318, 33.8693], [-117.04421, 33.86972], [-117.04453, 33.86988], [-117.04685, 33.87167], [-117.04741, 33.87209], [-117.04768, 33.8723], [-117.04925, 33.8737]]]]} | Restricted Access 2 | 25437 | Wolfskill-Driscoll Properties | 27673 | 2179 | Western Riverside County Regional Conservation Authority 957 | Special District 4 | Open Space District 6 | http://www.wrc-rca.org/ | Special District 4 | 2179 | Western Riverside County Regional Conservation Authority 927 | Special District 4 | Open Space District 6 | Riverside 10 | 1135.825 | Wolfskill-Driscoll Properties | 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 | ||
10350 | 10350 | 10349 | {"type": "Polygon", "coordinates": [[[-122.53356, 38.09886], [-122.5254, 38.1064], [-122.52385, 38.10609], [-122.5231, 38.10599], [-122.52261, 38.10553], [-122.52248, 38.10589], [-122.52024, 38.10565], [-122.51913, 38.10482], [-122.51863, 38.10463], [-122.51506, 38.105], [-122.51432, 38.1048], [-122.51589, 38.10353], [-122.51507, 38.10281], [-122.52095, 38.09844], [-122.52137, 38.09802], [-122.52779, 38.09313], [-122.52815, 38.09311], [-122.52832, 38.09329], [-122.52796, 38.09337], [-122.52795, 38.09338], [-122.53315, 38.0984], [-122.53316, 38.0984], [-122.53354, 38.09796], [-122.53354, 38.09884], [-122.53356, 38.09886]]]} | Restricted Access 2 | 18275 | Novato Sanitation District | 22930 | 2097 | Novato Sanitary District 949 | Special District 4 | Sanitation District 18 | http://www.novatosan.com/ | Special District 4 | 2097 | Novato Sanitary District 921 | Special District 4 | Sanitation District 19 | Marin 23 | 302.997 | Novato Sanitation District | 1925 | Local Other or Unknown 14 | 4 | |
10118 | 10118 | 10117 | {"type": "MultiPolygon", "coordinates": [[[[-122.53534, 38.07672], [-122.53156, 38.07807], [-122.53133, 38.07813], [-122.53036, 38.0783], [-122.52863, 38.07883], [-122.52842, 38.07833], [-122.52729, 38.07791], [-122.52563, 38.07464], [-122.52596, 38.07439], [-122.52574, 38.07374], [-122.5243, 38.07215], [-122.52311, 38.07182], [-122.52237, 38.07141], [-122.5218, 38.07101], [-122.52315, 38.06994], [-122.52495, 38.06973], [-122.52495, 38.06971], [-122.52738, 38.06943], [-122.52761, 38.07048], [-122.52826, 38.07145], [-122.52875, 38.07227], [-122.52886, 38.07233], [-122.52895, 38.07248], [-122.52897, 38.07274], [-122.52924, 38.0732], [-122.52982, 38.07335], [-122.53044, 38.07297], [-122.53091, 38.07302], [-122.53132, 38.07324], [-122.53149, 38.07354], [-122.53148, 38.07382], [-122.53175, 38.0742], [-122.53227, 38.07428], [-122.53262, 38.07445], [-122.53285, 38.07487], [-122.53314, 38.07482], [-122.53391, 38.07456], [-122.53469, 38.07593], [-122.53489, 38.07618], [-122.53514, 38.07644], [-122.53534, 38.07672]]], [[[-122.53462, 38.08549], [-122.53457, 38.08664], [-122.51994, 38.09789], [-122.51972, 38.09772], [-122.51576, 38.10081], [-122.51169, 38.09693], [-122.51111, 38.09776], [-122.50743, 38.09739], [-122.50179, 38.09877], [-122.5016, 38.09898], [-122.50144, 38.09994], [-122.49266, 38.09971], [-122.49517, 38.09326], [-122.49571, 38.09316], [-122.49813, 38.09207], [-122.50068, 38.09055], [-122.50189, 38.08967], [-122.50306, 38.08829], [-122.50434, 38.08636], [-122.50476, 38.08672], [-122.50462, 38.0869], [-122.50547, 38.08821], [-122.5071, 38.09337], [-122.50961, 38.09217], [-122.51401, 38.08952], [-122.51417, 38.09043], [-122.51543, 38.09181], [-122.51569, 38.09196], [-122.5162, 38.09211], [-122.51883, 38.09149], [-122.51989, 38.09089], [-122.5217, 38.08911], [-122.52284, 38.08835], [-122.52335, 38.08812], [-122.52446, 38.08801], [-122.52504, 38.08804], [-122.5258, 38.08817], [-122.52699, 38.08823], [-122.52785, 38.08799], [-122.52841, 38.08753], [-122.52891, 38.08677], [-122.52898, 38.08609], [-122.52863, 38.08491], [-122.52814, 38.08411], [-122.52711, 38.08293], [-122.52684, 38.08204], [-122.5271, 38.08141], [-122.52804, 38.08099], [-122.52999, 38.0817], [-122.53168, 38.08273], [-122.53318, 38.08368], [-122.53412, 38.08444], [-122.53462, 38.08549]]], [[[-122.55951, 38.09996], [-122.55862, 38.10039], [-122.55845, 38.10046], [-122.55726, 38.0999], [-122.5569, 38.09995], [-122.55686, 38.09998], [-122.5528, 38.09898], [-122.55176, 38.09958], [-122.5507, 38.09887], [-122.54961, 38.10549], [-122.54399, 38.10359], [-122.54188, 38.10374], [-122.53904, 38.10259], [-122.53854, 38.10213], [-122.5352, 38.10117], [-122.5351, 38.10123], [-122.53421, 38.10043], [-122.53427, 38.10035], [-122.53466, 38.10075], [-122.53542, 38.10118], [-122.53848, 38.10186], [-122.5397, 38.10179], [-122.54035, 38.10017], [-122.5423, 38.10081], [-122.54299, 38.10036], [-122.54308, 38.10049], [-122.54317, 38.10043], [-122.54344, 38.09978], [-122.54308, 38.09854], [-122.54219, 38.09765], [-122.54108, 38.09662], [-122.54019, 38.09627], [-122.53982, 38.09454], [-122.53834, 38.09349], [-122.53683, 38.09307], [-122.53388, 38.0938], [-122.53231, 38.09484], [-122.53214, 38.09646], [-122.53264, 38.0976], [-122.53368, 38.09778], [-122.53315, 38.09841], [-122.52794, 38.09337], [-122.52831, 38.09329], [-122.52831, 38.09327], [-122.5281, 38.09305], [-122.52858, 38.09268], [-122.5286, 38.09268], [-122.53, 38.09158], [-122.53, 38.09157], [-122.53247, 38.08961], [-122.53254, 38.08966], [-122.53422, 38.08837], [-122.53534, 38.08745], [-122.53546, 38.08781], [-122.53566, 38.08815], [-122.53593, 38.08846], [-122.5361, 38.08859], [-122.53646, 38.08883], [-122.53667, 38.08893], [-122.53722, 38.08914], [-122.53754, 38.0893], [-122.53784, 38.08947], [-122.53812, 38.08967], [-122.54201, 38.09264], [-122.54214, 38.09272], [-122.54228, 38.09278], [-122.54243, 38.09282], [-122.5426, 38.09285], [-122.54276, 38.09285], [-122.54292, 38.09282], [-122.54308, 38.09278], [-122.54365, 38.09254], [-122.54418, 38.09237], [-122.54472, 38.09223], [-122.54588, 38.09203], [-122.54644, 38.09197], [-122.54672, 38.09198], [-122.547, 38.092], [-122.54728, 38.09205], [-122.54755, 38.09212], [-122.5479, 38.09223], [-122.54757, 38.09267], [-122.54778, 38.09278], [-122.54813, 38.09233], [-122.54838, 38.09246], [-122.54862, 38.09261], [-122.54883, 38.09277], [-122.54903, 38.09295], [-122.5492, 38.09314], [-122.54935, 38.09335], [-122.54948, 38.09356], [-122.55018, 38.09494], [-122.55026, 38.09517], [-122.55031, 38.09539], [-122.55036, 38.09576], [-122.55042, 38.09588], [-122.5505, 38.096], [-122.55061, 38.09611], [-122.55074, 38.09619], [-122.55088, 38.09626], [-122.55104, 38.09631], [-122.55121, 38.09633], [-122.55146, 38.09632], [-122.55563, 38.09543], [-122.55597, 38.09584], [-122.55612, 38.09581], [-122.55679, 38.09661], [-122.55677, 38.09667], [-122.55898, 38.09929], [-122.55951, 38.09996]], [[-122.54938, 38.09799], [-122.54938, 38.09798], [-122.54655, 38.09688], [-122.54664, 38.09628], [-122.54662, 38.09627], [-122.54651, 38.09694], [-122.54938, 38.09799]]]]} | Open Access 1 | 17572 | Marin County Flood Control | 6348 | 2072 | Marin Public Works Dept/Flood Control 945 | Special District 4 | Flood District 8 | http://www.marincounty.org/depts/pw/divisions/flood-control | Special District 4 | 2072 | Marin Public Works Dept/Flood Control 917 | Special District 4 | Flood District 9 | Marin 23 | 1294.68 | Marin County Flood Control | 0 | Local Other or Unknown 14 | 4 | |
9853 | 9853 | 9852 | {"type": "MultiPolygon", "coordinates": [[[[-121.88803, 36.96112], [-121.88733, 36.96103], [-121.88667, 36.96038], [-121.88723, 36.95904], [-121.88785, 36.95921], [-121.88767, 36.95954], [-121.88759, 36.96033], [-121.88751, 36.96061], [-121.88803, 36.96112]]], [[[-121.88834, 36.95777], [-121.88826, 36.95785], [-121.88803, 36.95793], [-121.88785, 36.95843], [-121.88779, 36.95806], [-121.88824, 36.95754], [-121.88834, 36.95777]]]]} | Open Access 1 | 16862 | Hidden Beach Park - Aptos Sanitation District | 19903 | 2002 | Aptos Sanitation District 930 | Special District 4 | Sanitation District 18 | http://www.dpw.co.santa-cruz.ca.us/Sanitation.htm | Special District 4 | 2002 | Aptos Sanitation District 903 | Special District 4 | Sanitation District 19 | Santa Cruz 5 | 3.724 | Hidden Beach Park - Aptos Sanitation District | 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 | |
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 | |
8218 | 8218 | 8217 | {"type": "MultiPolygon", "coordinates": [[[[-117.15598, 33.10707], [-117.15561, 33.10724], [-117.15541, 33.10729], [-117.15513, 33.10743], [-117.15484, 33.1075], [-117.15451, 33.10766], [-117.15398, 33.10779], [-117.15382, 33.10784], [-117.15357, 33.10796], [-117.15344, 33.10805], [-117.1534, 33.10809], [-117.15337, 33.10818], [-117.1534, 33.10835], [-117.15356, 33.10863], [-117.15377, 33.10915], [-117.15402, 33.10997], [-117.15394, 33.10991], [-117.15386, 33.10987], [-117.15326, 33.10975], [-117.15296, 33.10964], [-117.15283, 33.11018], [-117.15297, 33.11064], [-117.15345, 33.11053], [-117.15394, 33.11036], [-117.15385, 33.11066], [-117.1538, 33.11078], [-117.15369, 33.11096], [-117.15363, 33.111], [-117.15356, 33.11101], [-117.15302, 33.11098], [-117.15136, 33.11131], [-117.15112, 33.11093], [-117.15102, 33.11072], [-117.151, 33.11064], [-117.151, 33.11048], [-117.15098, 33.11037], [-117.15081, 33.10999], [-117.1507, 33.10967], [-117.1507, 33.10956], [-117.15072, 33.10945], [-117.15071, 33.10937], [-117.15038, 33.10894], [-117.15017, 33.10859], [-117.15012, 33.10852], [-117.15003, 33.10847], [-117.14962, 33.10829], [-117.14952, 33.10827], [-117.14942, 33.10828], [-117.14875, 33.10845], [-117.14855, 33.10847], [-117.14838, 33.10846], [-117.14822, 33.10849], [-117.14822, 33.1055], [-117.14954, 33.10548], [-117.1506, 33.10609], [-117.15282, 33.10654], [-117.15402, 33.10642], [-117.15598, 33.10707]]], [[[-117.16972, 33.11406], [-117.16939, 33.11424], [-117.16912, 33.11452], [-117.16906, 33.11473], [-117.16849, 33.11523], [-117.16743, 33.1153], [-117.16683, 33.11496], [-117.16594, 33.11491], [-117.16555, 33.11498], [-117.16536, 33.11482], [-117.16487, 33.11397], [-117.1649, 33.1136], [-117.1652, 33.11353], [-117.16583, 33.11369], [-117.16658, 33.11343], [-117.16665, 33.11328], [-117.1677, 33.11329], [-117.16765, 33.11374], [-117.16779, 33.11418], [-117.1683, 33.11424], [-117.16868, 33.11397], [-117.16907, 33.11344], [-117.16928, 33.11337], [-117.16945, 33.11372], [-117.16972, 33.11395], [-117.16972, 33.11406]]]]} | No Public Access 3 | 47787 | South Lake Mitigation | 31663 | 2170 | Vallecitos Water District 879 | Special District 4 | Water District 13 | http://www.vwd.org/ | Special District 4 | 1308 | San Marcos, City of 197 | City 2 | City Agency 2 | San Diego 4 | 72.132 | South Lake Mitigation | 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 |
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]);