units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
17,068 rows
This data as json, copyable, CSV (advanced)
MNG_AG_TYP >30
- City Agency 10,328
- County Agency 1,199
- Recreation/Parks District 1,156
- State Agency 1,133
- Non Profit - Land Trust 594
- Federal Agency 510
- Open Space District 425
- Water District 237
- County Agency - Parks 234
- Home Owners Association 203
- Community Services District 198
- Non Profit - Conservation 147
- Flood District 105
- Cemetery District 56
- Irrigation District 50
- Non Profit - Other 45
- School District 38
- County Agency - Other 33
- Port/Harbor District 33
- Commercial 15
- Special District - Other 15
- Sanitation District 9
- Joint Powers Authority 9
- Other 6
- Non Profit - Cemetery District 5
- Conservation District 5
- Transportation Agency 5
- Mitigation Bank 4
- Non Profit - Education 3
- Metropolitan Planning Organization 2
- …
MNG_AGENCY >30
- San Diego, City of 496
- Los Angeles, City of 485
- California Department of Fish and Wildlife 439
- California Department of Parks and Recreation 379
- Mountains Recreation and Conservation Authority 349
- San Jose, City of 249
- San Francisco, City and County of 238
- Sacramento, City of 220
- Los Angeles, County of 174
- East Bay Regional Park District 166
- Ventura, City of 151
- Long Beach, City of 148
- Roseville, City of 130
- Oakland, City of 121
- San Diego, County of 121
- United States Bureau of Land Management 120
- Santa Barbara, County of 115
- United States Forest Service 108
- Irvine, City of 101
- Orange, County of 95
- Consumnes Community Services District 94
- United States National Park Service 87
- California State Lands Commission 85
- Modesto, City of 85
- Hayward Area Recreation and Park District 84
- Santa Rosa, City of 81
- United States Fish and Wildlife Service 81
- Stockton, City of 81
- Napa, City of 81
- Fresno, City of 79
- …
DES_TP >30
- Local Park 9,188
- Local Recreation Area 1,967
- Local Other or Unknown 1,183
- Private Conservation 621
- Local Conservation Area 481
- State Conservation Area 378
- Private Recreation or Education 268
- State Park 207
- State Resource Management Area 159
- State Recreation Area 145
- Local Historic or Cultural Area 110
- National Forest 96
- National Wildlife Refuge 75
- National Public Lands 74
- State Other or Unknown 70
- State Historic or Cultural Area 63
- Recreation Management Area 61
- Private Other or Unknown 51
- National Recreation Area 40
- National Monument or Landmark 39
- Resource Management Area 26
- National Park 24
- Local Resource Management Area 24
- Federal Other or Unknown 24
- Conservation Area 13
- Private Agricultural 12
- Wilderness Area 7
- Area of Critical Environmental Concern 7
- Historic or Cultural Area 5
- Private Historic or Cultural 4
- …
ACCESS_TYP 4
- Open Access 14,273
- Restricted Access 1,192
- No Public Access 959
- Unknown Access 382
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
263 | 263 | 262 | {"type": "Polygon", "coordinates": [[[-121.60427, 36.6889], [-121.60339, 36.68923], [-121.60329, 36.68903], [-121.60316, 36.68881], [-121.60301, 36.6886], [-121.60264, 36.68816], [-121.60264, 36.68811], [-121.60325, 36.68776], [-121.60427, 36.6889]]]} | Open Access 1 | 897 | Soberanes Park | 25586 | 1291 | Salinas, City of 56 | City 2 | City Agency 2 | http://www.ci.salinas.ca.us/services/recreation/recreation.cfm | City 2 | 1291 | Salinas, City of 54 | City 2 | City Agency 2 | Monterey 14 | 2.722 | Soberanes Park | 0 | Local Park 2 | 4 | |
264 | 264 | 263 | {"type": "Polygon", "coordinates": [[[-120.19453, 34.61897], [-120.19414, 34.61966], [-120.19316, 34.61923], [-120.19343, 34.61873], [-120.19247, 34.61831], [-120.19265, 34.618], [-120.19309, 34.61817], [-120.1932, 34.61798], [-120.19324, 34.61799], [-120.19314, 34.61819], [-120.19416, 34.61859], [-120.19407, 34.61865], [-120.19405, 34.61869], [-120.19404, 34.61876], [-120.19407, 34.61883], [-120.19415, 34.61888], [-120.19428, 34.61888], [-120.19453, 34.61897]]]} | Open Access 1 | 735 | Buellton Park | 16482 | 1036 | Buellton, City of 88 | City 2 | City Agency 2 | http://www.cityofbuellton.com/Parks&Rec/parks.asp | City 2 | 1036 | Buellton, City of 86 | City 2 | City Agency 2 | Santa Barbara 7 | 3.366 | Buellton Park | 0 | Local Park 2 | 4 | |
265 | 265 | 264 | {"type": "Polygon", "coordinates": [[[-119.28968, 36.52836], [-119.28966, 36.53016], [-119.28768, 36.53012], [-119.28767, 36.52949], [-119.28688, 36.52949], [-119.28687, 36.52833], [-119.28968, 36.52836]]]} | Open Access 1 | 743 | Ledbetter Park | 21129 | 330 | Tulare, County of 96 | County 3 | County Agency 3 | http://www.tularecounty.ca.gov/cao/index.cfm/general-services/parks-and-recreation/county-parks/ | County 3 | 330 | Tulare, County of 94 | County 3 | County Agency 3 | Tulare 29 | 11.05 | Ledbetter Park | 0 | Local Park 2 | 4 | |
266 | 266 | 265 | {"type": "Polygon", "coordinates": [[[-117.28081, 33.05885], [-117.28072, 33.06063], [-117.27954, 33.06063], [-117.27953, 33.06014], [-117.27857, 33.06014], [-117.27858, 33.05993], [-117.27819, 33.05883], [-117.28081, 33.05885]]]} | Open Access 1 | 744 | Quail Gardens Undeveloped Park | 24040 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | San Diego 4 | 9.379 | Quail Gardens Undeveloped Park | 0 | Local Park 2 | 4 | |
267 | 267 | 266 | {"type": "Polygon", "coordinates": [[[-119.02915, 36.43551], [-119.02072, 36.43543], [-119.02065, 36.42818], [-119.02892, 36.42826], [-119.02825, 36.43122], [-119.02828, 36.43212], [-119.02856, 36.43284], [-119.02907, 36.43388], [-119.02921, 36.43451], [-119.02915, 36.43551]]]} | Restricted Access 2 | 907 | Dry Creek Preserve | 18285 | 3076 | Sequoia Riverlands Trust 109 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.sequoiariverlands.org | Non Governmental Organization 10 | 3076 | Sequoia Riverlands Trust 106 | Non Profit 6 | Non Profit - Land Trust 10 | Tulare 29 | 142.711 | Dry Creek Preserve | 2004 | Private Conservation 16 | 2 | |
268 | 268 | 267 | {"type": "Polygon", "coordinates": [[[-119.88625, 36.80929], [-119.88539, 36.8101], [-119.88421, 36.8093], [-119.88556, 36.80929], [-119.88625, 36.80929]]]} | Open Access 1 | 737 | Highway City Park | 19952 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 2.017 | Highway City Park | 0 | Local Park 2 | 4 | |
269 | 269 | 268 | {"type": "Polygon", "coordinates": [[[-120.10404, 37.44406], [-120.10403, 37.44496], [-120.10267, 37.44507], [-120.10278, 37.44409], [-120.10404, 37.44406]]]} | Open Access 1 | 47348 | Catheys Valley Cemetery | 31064 | 307 | Mariposa, County of 110 | County 3 | County Agency 3 | https://www.mariposacounty.org/index.aspx?NID=207 | County 3 | 307 | Mariposa, County of 107 | County 3 | County Agency 3 | Mariposa 31 | 2.97 | Catheys Valley Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | |
270 | 270 | 269 | {"type": "Polygon", "coordinates": [[[-122.25949, 38.27979], [-122.256, 38.27978], [-122.25255, 38.27973], [-122.25149, 38.27969], [-122.24965, 38.27967], [-122.24894, 38.27968], [-122.24877, 38.2797], [-122.24868, 38.27977], [-122.2455, 38.27976], [-122.24092, 38.27987], [-122.23633, 38.27986], [-122.23623, 38.2692], [-122.23162, 38.2692], [-122.23158, 38.26561], [-122.22698, 38.2656], [-122.21778, 38.26577], [-122.21775, 38.25878], [-122.21356, 38.25877], [-122.21355, 38.25427], [-122.21522, 38.25486], [-122.21607, 38.25492], [-122.21668, 38.25515], [-122.21783, 38.25499], [-122.218, 38.25496], [-122.2181, 38.25491], [-122.21855, 38.25484], [-122.21902, 38.25461], [-122.22004, 38.2545], [-122.22463, 38.2543], [-122.22694, 38.2551], [-122.22708, 38.25525], [-122.22793, 38.25583], [-122.23018, 38.25708], [-122.23043, 38.25707], [-122.23061, 38.25715], [-122.23125, 38.25736], [-122.23153, 38.25752], [-122.2318, 38.2578], [-122.23188, 38.25803], [-122.23203, 38.25818], [-122.23214, 38.25825], [-122.23216, 38.25843], [-122.2361, 38.25846], [-122.23622, 38.26562], [-122.24539, 38.26563], [-122.24554, 38.27172], [-122.24785, 38.27207], [-122.24862, 38.27265], [-122.24555, 38.27268], [-122.24554, 38.27217], [-122.24552, 38.27271], [-122.24869, 38.2727], [-122.25123, 38.27447], [-122.25798, 38.27448], [-122.25809, 38.27431], [-122.25844, 38.27448], [-122.25943, 38.27448], [-122.25949, 38.27979]]]} | Open Access 1 | 916 | Skyline Wilderness Park | 835 | 222 | California Bureau of Real Estate 111 | State 5 | State Agency 5 | http://www.bre.ca.gov/ | Other State 5 | 2268 | Napa County Regional Park and Open Space District 108 | Special District 4 | Recreation/Parks District 4 | http://www.skylinepark.org/ | Napa 11 | 1021.072 | Skyline Wilderness Park | 1983 | Local Conservation Area 4 | 2 |
271 | 271 | 270 | {"type": "MultiPolygon", "coordinates": [[[[-121.95373, 36.97272], [-121.95357, 36.973], [-121.95313, 36.97262], [-121.95289, 36.97279], [-121.95277, 36.97267], [-121.95323, 36.97241], [-121.9534, 36.97233], [-121.95349, 36.97232], [-121.95355, 36.97237], [-121.95362, 36.97253], [-121.95373, 36.97272]]], [[[-121.95514, 36.97464], [-121.95484, 36.97468], [-121.95482, 36.97466], [-121.95468, 36.97473], [-121.95455, 36.97457], [-121.95473, 36.97446], [-121.95467, 36.97434], [-121.95418, 36.97457], [-121.95416, 36.97455], [-121.95466, 36.9743], [-121.95458, 36.97412], [-121.95379, 36.97318], [-121.95387, 36.97304], [-121.95418, 36.97332], [-121.95431, 36.97348], [-121.95434, 36.97354], [-121.95474, 36.97406], [-121.95493, 36.97432], [-121.95502, 36.97451], [-121.95505, 36.97451], [-121.95514, 36.97464]]], [[[-121.95491, 36.97485], [-121.95485, 36.9749], [-121.95478, 36.97481], [-121.95487, 36.97475], [-121.95491, 36.97485]]], [[[-121.95588, 36.97452], [-121.9558, 36.97455], [-121.95563, 36.97424], [-121.95526, 36.97383], [-121.9551, 36.97373], [-121.95525, 36.97374], [-121.95532, 36.97379], [-121.95571, 36.97421], [-121.95588, 36.97452]]]]} | Open Access 1 | 917 | Soquel Creek Park | 25621 | 1044 | Capitola, City of 112 | City 2 | City Agency 2 | http://www.cityofcapitola.org/publicworks/page/parks | City 2 | 1044 | Capitola, City of 109 | City 2 | City Agency 2 | Santa Cruz 5 | 2.021 | Soquel Creek Park | 0 | Local Park 2 | 4 | |
272 | 272 | 271 | {"type": "Polygon", "coordinates": [[[-119.30083, 34.27437], [-119.30048, 34.27445], [-119.29837, 34.27477], [-119.29821, 34.27482], [-119.29805, 34.27491], [-119.2979, 34.27501], [-119.29779, 34.27512], [-119.29779, 34.27435], [-119.29933, 34.27392], [-119.30016, 34.27382], [-119.30083, 34.27383], [-119.30083, 34.27437]]]} | Open Access 1 | 742 | Surfer's Point | 30395 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 4.99 | Surfer's Point | None 29 | |||
273 | 273 | 272 | {"type": "Polygon", "coordinates": [[[-117.22664, 33.05068], [-117.22596, 33.05276], [-117.2242, 33.05232], [-117.22397, 33.05269], [-117.22342, 33.05309], [-117.22333, 33.0532], [-117.22327, 33.05335], [-117.22319, 33.05333], [-117.22285, 33.05437], [-117.2217, 33.05409], [-117.22056, 33.05378], [-117.21929, 33.05347], [-117.21921, 33.05335], [-117.2161, 33.05151], [-117.2152, 33.05153], [-117.21517, 33.05106], [-117.21518, 33.05083], [-117.21545, 33.0506], [-117.21594, 33.05075], [-117.21635, 33.05105], [-117.21679, 33.05145], [-117.21732, 33.05162], [-117.21818, 33.05212], [-117.21855, 33.05236], [-117.2191, 33.05245], [-117.21953, 33.05245], [-117.22, 33.05237], [-117.22063, 33.05218], [-117.22118, 33.05198], [-117.22176, 33.05197], [-117.22196, 33.05142], [-117.22206, 33.05144], [-117.22209, 33.05145], [-117.2219, 33.052], [-117.2221, 33.05204], [-117.22236, 33.0522], [-117.22247, 33.05237], [-117.22239, 33.05293], [-117.22239, 33.05312], [-117.22257, 33.05319], [-117.22287, 33.05307], [-117.22318, 33.05292], [-117.22333, 33.05278], [-117.22331, 33.05265], [-117.22347, 33.05211], [-117.22328, 33.0517], [-117.2231, 33.0515], [-117.22291, 33.05106], [-117.22291, 33.05094], [-117.22294, 33.05091], [-117.22296, 33.0508], [-117.22288, 33.05078], [-117.22291, 33.05061], [-117.22294, 33.0506], [-117.22293, 33.05044], [-117.22297, 33.0501], [-117.22301, 33.0501], [-117.22307, 33.05], [-117.22299, 33.04997], [-117.22302, 33.04982], [-117.22309, 33.04984], [-117.22316, 33.04971], [-117.22322, 33.04966], [-117.2235, 33.04936], [-117.22355, 33.04924], [-117.22352, 33.04914], [-117.22363, 33.049], [-117.22362, 33.04898], [-117.22385, 33.04877], [-117.2239, 33.04867], [-117.22389, 33.04866], [-117.22404, 33.04837], [-117.22402, 33.04835], [-117.22407, 33.04826], [-117.22407, 33.04819], [-117.22411, 33.04819], [-117.22416, 33.04806], [-117.2241, 33.04804], [-117.22416, 33.0479], [-117.2241, 33.04783], [-117.22609, 33.04832], [-117.22544, 33.05038], [-117.22664, 33.05068]]]} | Open Access 1 | 745 | Val Sereno Preserve | 26755 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | San Diego 4 | 54.542 | Val Sereno Preserve | 0 | Local Conservation Area 4 | 2 | |
274 | 274 | 273 | {"type": "Polygon", "coordinates": [[[-117.72318, 33.87548], [-117.72312, 33.87587], [-117.7229, 33.87584], [-117.72266, 33.87578], [-117.72254, 33.87582], [-117.72248, 33.87589], [-117.72204, 33.87581], [-117.72218, 33.87558], [-117.72251, 33.87523], [-117.72255, 33.87523], [-117.72297, 33.87543], [-117.72318, 33.87548]]]} | Open Access 1 | 47365 | Vista Lampara Park | 31088 | 1384 | Yorba Linda, City of 64 | City 2 | City Agency 2 | http://www.ci.yorba-linda.ca.us/index.php/city-departments/recreation-community-services | City 2 | 1384 | Yorba Linda, City of 62 | City 2 | City Agency 2 | Orange 3 | 1.193 | Vista Lampara Park | 0 | Local Park 2 | 4 | |
275 | 275 | 274 | {"type": "Polygon", "coordinates": [[[-119.19704, 34.28676], [-119.1969, 34.28706], [-119.19612, 34.28715], [-119.19612, 34.28713], [-119.19635, 34.28707], [-119.19658, 34.28696], [-119.19673, 34.28683], [-119.19685, 34.28668], [-119.19704, 34.28676]]]} | Open Access 1 | 35439 | Ventura holding 73 | 26955 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 0.367 | Ventura holding 73 | 0 | Local Other or Unknown 14 | 4 | |
276 | 276 | 275 | {"type": "Polygon", "coordinates": [[[-119.17054, 34.28047], [-119.17066, 34.2806], [-119.17066, 34.28063], [-119.17064, 34.28066], [-119.16734, 34.28261], [-119.16727, 34.2826], [-119.16717, 34.28249], [-119.16745, 34.28232], [-119.16748, 34.28234], [-119.16892, 34.28149], [-119.16889, 34.28144], [-119.17054, 34.28047]]]} | Open Access 1 | 35440 | Ventura holding 72 | 26954 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 1.844 | Ventura holding 72 | 0 | Local Other or Unknown 14 | 4 | |
277 | 277 | 276 | {"type": "Polygon", "coordinates": [[[-117.5615, 33.93786], [-117.56124, 33.93819], [-117.56111, 33.93847], [-117.56107, 33.93871], [-117.56106, 33.93932], [-117.55877, 33.93932], [-117.55877, 33.93876], [-117.55864, 33.93875], [-117.55864, 33.9379], [-117.55991, 33.93791], [-117.55992, 33.93787], [-117.5615, 33.93786]]]} | Open Access 1 | 47359 | Community Center Park | 31082 | 1395 | Norco, City of 114 | City 2 | City Agency 2 | http://www.norco.ca.us/depts/parks/default.asp | City 2 | 1395 | Norco, City of 111 | City 2 | City Agency 2 | http://www.norco.ca.us/depts/parks/facilities/parks/communitycenter.asp | Riverside 10 | 8.953 | Community Ctr. Park | 0 | Local Recreation Area 3 | 4 |
278 | 278 | 277 | {"type": "Polygon", "coordinates": [[[-120.66515, 35.26662], [-120.66466, 35.26653], [-120.66436, 35.26666], [-120.66427, 35.26653], [-120.66393, 35.26612], [-120.66379, 35.266], [-120.66357, 35.26587], [-120.66337, 35.26579], [-120.66315, 35.26574], [-120.66292, 35.26572], [-120.66252, 35.26572], [-120.66262, 35.26536], [-120.66261, 35.26497], [-120.66004, 35.26496], [-120.66011, 35.26356], [-120.65886, 35.26356], [-120.65883, 35.26352], [-120.65904, 35.26352], [-120.65905, 35.26351], [-120.659, 35.26347], [-120.6588, 35.26341], [-120.65852, 35.26335], [-120.65797, 35.26314], [-120.65777, 35.26304], [-120.65767, 35.26291], [-120.6573, 35.26264], [-120.65721, 35.26255], [-120.65717, 35.2625], [-120.65683, 35.26235], [-120.65661, 35.26231], [-120.6564, 35.26215], [-120.65633, 35.26207], [-120.65617, 35.26197], [-120.65608, 35.26186], [-120.65599, 35.26184], [-120.65583, 35.26163], [-120.65493, 35.26108], [-120.6544, 35.25768], [-120.65583, 35.25766], [-120.65584, 35.2577], [-120.65524, 35.25788], [-120.65526, 35.25821], [-120.65719, 35.26012], [-120.65825, 35.26135], [-120.65927, 35.26221], [-120.66054, 35.2628], [-120.66113, 35.26331], [-120.66475, 35.2634], [-120.66476, 35.26499], [-120.66513, 35.265], [-120.66515, 35.26662]], [[-120.66016, 35.26352], [-120.66016, 35.2635], [-120.66011, 35.26351], [-120.66012, 35.26352], [-120.66016, 35.26352]]]} | Open Access 1 | 946 | South Hills Open Space | 25656 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | San Luis Obispo 1 | 58.628 | South Hills OS | 0 | Local Recreation Area 3 | 4 | |
279 | 279 | 278 | {"type": "Polygon", "coordinates": [[[-118.22958, 34.6528], [-118.22758, 34.6528], [-118.22752, 34.65275], [-118.22746, 34.65017], [-118.22952, 34.65016], [-118.22958, 34.6528]]]} | Open Access 1 | 948 | George Lane Park | 19270 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 13.666 | George Lane Park | 0 | Local Park 2 | 4 | |
280 | 280 | 279 | {"type": "Polygon", "coordinates": [[[-121.85612, 36.61199], [-121.8561, 36.6123], [-121.85602, 36.6123], [-121.85604, 36.61196], [-121.85607, 36.61194], [-121.85612, 36.61199]]]} | Restricted Access 2 | 956 | South Monterey Dunes | 25664 | 1330 | Seaside, City of 115 | City 2 | City Agency 2 | http://www.ci.seaside.ca.us/index.aspx?page=313 | City 2 | 1330 | Seaside, City of 112 | City 2 | City Agency 2 | Monterey 14 | 0.07 | South Monterey Dunes | None 30 | |||
281 | 281 | 280 | {"type": "Polygon", "coordinates": [[[-121.77782, 36.90425], [-121.77774, 36.90416], [-121.77761, 36.90412], [-121.77715, 36.90423], [-121.77705, 36.90428], [-121.77614, 36.9049], [-121.77607, 36.90497], [-121.77603, 36.90505], [-121.77603, 36.90513], [-121.77637, 36.90605], [-121.77639, 36.90628], [-121.77634, 36.9065], [-121.77621, 36.90671], [-121.77602, 36.90687], [-121.77579, 36.90699], [-121.77611, 36.90644], [-121.7747, 36.90471], [-121.77763, 36.90374], [-121.77782, 36.90425]]]} | Open Access 1 | 754 | Seaview Park | 25273 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | http://cityofwatsonville.org/parks-community-services | City 2 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | Santa Cruz 5 | 6.282 | Seaview Park | 0 | Local Park 2 | 4 | |
282 | 282 | 281 | {"type": "Polygon", "coordinates": [[[-117.89382, 33.88608], [-117.89375, 33.8862], [-117.89366, 33.88628], [-117.89357, 33.88634], [-117.89345, 33.88638], [-117.89184, 33.88657], [-117.89171, 33.88659], [-117.89162, 33.88663], [-117.89142, 33.88677], [-117.89085, 33.88747], [-117.89075, 33.88764], [-117.89069, 33.88781], [-117.89029, 33.88783], [-117.89023, 33.8878], [-117.8901, 33.88716], [-117.89051, 33.88706], [-117.89064, 33.88674], [-117.89088, 33.88669], [-117.89106, 33.88662], [-117.89167, 33.88626], [-117.89176, 33.88622], [-117.89298, 33.88609], [-117.89312, 33.88604], [-117.89324, 33.88597], [-117.89338, 33.88584], [-117.89382, 33.88608]]]} | Open Access 1 | 756 | Fullerton Creek Greenbelt | 19143 | 1115 | Fullerton, City of 116 | City 2 | City Agency 2 | http://www.ci.fullerton.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1115 | Fullerton, City of 113 | City 2 | City Agency 2 | Orange 3 | 4.418 | Fullerton Creek Greenbelt | 0 | Local Recreation Area 3 | 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]);