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,492
- County Agency 1,214
- Recreation/Parks District 1,161
- State Agency 1,140
- Non Profit - Land Trust 601
- Federal Agency 516
- Open Space District 428
- Water District 238
- County Agency - Parks 236
- Home Owners Association 203
- Community Services District 198
- Non Profit - Conservation 148
- Flood District 108
- Cemetery District 62
- Irrigation District 50
- Non Profit - Other 45
- School District 38
- County Agency - Other 35
- 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 523
- Los Angeles, City of 491
- California Department of Fish and Wildlife 443
- California Department of Parks and Recreation 380
- Mountains Recreation and Conservation Authority 351
- San Jose, City of 253
- San Francisco, City and County of 239
- Sacramento, City of 220
- Los Angeles, County of 174
- East Bay Regional Park District 167
- Ventura, City of 151
- Long Beach, City of 148
- Roseville, City of 130
- San Diego, County of 123
- Oakland, City of 122
- United States Bureau of Land Management 120
- Santa Barbara, County of 117
- United States Forest Service 111
- Irvine, City of 101
- Orange, County of 95
- Fresno, City of 94
- Consumnes Community Services District 94
- United States National Park Service 89
- California State Lands Commission 86
- Modesto, City of 85
- Hayward Area Recreation and Park District 84
- Santa Rosa, City of 83
- United States Fish and Wildlife Service 82
- Stockton, City of 81
- Napa, City of 81
- …
DES_TP >30
- Local Park 9,346
- Local Recreation Area 1,984
- Local Other or Unknown 1,190
- Private Conservation 629
- Local Conservation Area 484
- State Conservation Area 381
- Private Recreation or Education 268
- State Park 208
- State Resource Management Area 159
- State Recreation Area 145
- Local Historic or Cultural Area 116
- National Forest 99
- 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
- National Park 26
- Resource Management Area 26
- Local Resource Management Area 24
- Federal Other or Unknown 24
- Conservation Area 14
- 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,473
- Restricted Access 1,201
- No Public Access 968
- Unknown Access 386
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
41 | 41 | 40 | {"type": "Polygon", "coordinates": [[[-117.19344, 32.75165], [-117.19315, 32.75181], [-117.19311, 32.75179], [-117.19296, 32.75158], [-117.1933, 32.75139], [-117.19344, 32.75165]]]} | Open Access 1 | 95 | El Campo Santo Neighborhood Park | 30058 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 0.276 | El Campo Santo Neighborhood Park | 0 | Local Park 2 | 4 | |
42 | 42 | 41 | {"type": "Polygon", "coordinates": [[[-121.8696, 36.54123], [-121.86858, 36.54357], [-121.8688, 36.54399], [-121.86843, 36.54483], [-121.86836, 36.54672], [-121.86702, 36.54676], [-121.86669, 36.54657], [-121.86686, 36.54615], [-121.86861, 36.54212], [-121.86807, 36.5408], [-121.86878, 36.54061], [-121.8696, 36.54123]]]} | Open Access 1 | 97 | Roach Canyon Park | 24474 | 310 | Monterey, County of 23 | County 3 | County Agency 3 | http://www.co.monterey.ca.us/parks/ | County 3 | 310 | Monterey, County of 23 | County 3 | County Agency 3 | Monterey 14 | 15.0 | Roach Canyon Park | 0 | Local Park 2 | 4 | |
43 | 43 | 42 | {"type": "Polygon", "coordinates": [[[-121.15669, 37.46915], [-121.15657, 37.46931], [-121.15657, 37.46937], [-121.15661, 37.46943], [-121.15668, 37.46948], [-121.15648, 37.46951], [-121.15606, 37.46951], [-121.15586, 37.46948], [-121.15657, 37.46901], [-121.15669, 37.46906], [-121.15669, 37.46915]]]} | Open Access 1 | 98 | Castlebrite Park | 16958 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | Stanislaus 2 | 0.519 | Castlebrite Park | 0 | Local Park 2 | 4 | |
44 | 44 | 43 | {"type": "Polygon", "coordinates": [[[-118.35044, 34.13077], [-118.35003, 34.13136], [-118.34933, 34.1306], [-118.3496, 34.13019], [-118.35044, 34.13077]]]} | Open Access 1 | 99 | El Paseo Cahuenga Park | 18526 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 1.546 | El Paseo Cahuenga Park | 0 | Local Park 2 | 4 | |
45 | 45 | 44 | {"type": "Polygon", "coordinates": [[[-121.58017, 38.00647], [-121.57962, 38.00489], [-121.5792, 38.00424], [-121.57866, 38.00373], [-121.578, 38.00325], [-121.5773, 38.00297], [-121.5765, 38.00275], [-121.57532, 38.00267], [-121.57437, 38.00274], [-121.57366, 38.00284], [-121.57299, 38.00288], [-121.57271, 38.00292], [-121.57084, 38.00265], [-121.56985, 38.00228], [-121.56934, 38.002], [-121.56923, 38.00168], [-121.56976, 38.00083], [-121.57043, 38.0001], [-121.57105, 37.99959], [-121.57179, 37.99931], [-121.57271, 37.99929], [-121.57361, 37.99936], [-121.57459, 37.99948], [-121.57536, 37.99977], [-121.57739, 37.99957], [-121.57899, 37.99906], [-121.57922, 37.99895], [-121.57943, 37.99902], [-121.57968, 38.00053], [-121.57966, 38.0016], [-121.57979, 38.0027], [-121.5798, 38.00342], [-121.57997, 38.00413], [-121.58015, 38.00529], [-121.58017, 38.00647]]]} | Open Access 1 | 104 | Rhode Island Wildlife Area | 30492 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Rhode-Island-WA | Contra Costa 12 | 85.271 | Rhode Island Wildlife Area | 2002 | State Conservation Area 8 | 2 |
46 | 46 | 45 | {"type": "Polygon", "coordinates": [[[-117.08226, 32.82508], [-117.08219, 32.82527], [-117.08213, 32.82555], [-117.08203, 32.82574], [-117.08095, 32.8251], [-117.08087, 32.82511], [-117.08059, 32.82491], [-117.08031, 32.82482], [-117.07942, 32.82465], [-117.0796, 32.8244], [-117.08002, 32.82402], [-117.08018, 32.82416], [-117.08058, 32.82439], [-117.08226, 32.82508]]]} | Open Access 1 | 131 | Tierrasanta Open Space | 10608 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 4.081 | Tierrasanta OS | 0 | Local Recreation Area 3 | 4 | |
47 | 47 | 46 | {"type": "MultiPolygon", "coordinates": [[[[-119.70909, 34.44366], [-119.70909, 34.44415], [-119.70862, 34.44493], [-119.70858, 34.44547], [-119.70828, 34.44567], [-119.70821, 34.44594], [-119.70847, 34.44627], [-119.70848, 34.44649], [-119.70851, 34.44659], [-119.70826, 34.44655], [-119.70805, 34.44586], [-119.70711, 34.44467], [-119.70752, 34.44456], [-119.70909, 34.44366]]], [[[-119.71066, 34.44319], [-119.71065, 34.4436], [-119.71, 34.4436], [-119.70999, 34.44352], [-119.71046, 34.44304], [-119.71066, 34.44319]]]]} | Open Access 1 | 134 | Rocky Nook Park | 24543 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp | City 2 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | Santa Barbara 7 | 6.0 | Rocky Nook Park | 0 | Local Park 2 | 4 | |
48 | 48 | 47 | {"type": "Polygon", "coordinates": [[[-121.13139, 37.46901], [-121.13089, 37.46894], [-121.13099, 37.46845], [-121.13139, 37.46901], [-121.13139, 37.46901]]]} | Open Access 1 | 106 | Del Puerto Park | 18048 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | Stanislaus 2 | 0.306 | Del Puerto Park | 0 | Local Park 2 | 4 | |
49 | 49 | 48 | {"type": "Polygon", "coordinates": [[[-117.04877, 32.81115], [-117.04766, 32.81153], [-117.04656, 32.81065], [-117.04633, 32.81056], [-117.04656, 32.80996], [-117.04591, 32.8096], [-117.04518, 32.80917], [-117.0453, 32.80896], [-117.04544, 32.80897], [-117.04612, 32.8091], [-117.04679, 32.80933], [-117.04712, 32.80941], [-117.04749, 32.80943], [-117.04824, 32.80934], [-117.04829, 32.8096], [-117.0481, 32.80978], [-117.04786, 32.81015], [-117.04788, 32.81022], [-117.04852, 32.81057], [-117.04845, 32.81084], [-117.04877, 32.81115]]]} | Open Access 1 | 107 | Tuxedo Neighborhood Park | 30163 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 10.11 | Tuxedo Neighborhood Park | 0 | Local Park 2 | 4 | |
50 | 50 | 49 | {"type": "MultiPolygon", "coordinates": [[[[-117.21301, 33.87552], [-117.21265, 33.8756], [-117.21258, 33.87543], [-117.21246, 33.87526], [-117.2123, 33.87511], [-117.21214, 33.87501], [-117.21187, 33.87491], [-117.21099, 33.87478], [-117.2109, 33.87468], [-117.21098, 33.87391], [-117.21278, 33.87393], [-117.21279, 33.8744], [-117.21285, 33.87488], [-117.21287, 33.87501], [-117.21289, 33.87505], [-117.21301, 33.87552]]], [[[-117.21735, 33.87448], [-117.21724, 33.87454], [-117.21542, 33.87452], [-117.21528, 33.87448], [-117.21519, 33.87448], [-117.21508, 33.87454], [-117.21502, 33.87462], [-117.21502, 33.87471], [-117.21505, 33.87477], [-117.21504, 33.87503], [-117.21332, 33.87502], [-117.21325, 33.87454], [-117.21324, 33.87428], [-117.21325, 33.87393], [-117.21469, 33.87393], [-117.2147, 33.87379], [-117.21734, 33.8738], [-117.21735, 33.87448]]]]} | Open Access 1 | 116 | El Potrero Park | 18530 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | http://www.moreno-valley.ca.us/city_hall/departments/pcs/index-parks.shtml | City 2 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | Riverside 10 | 14.762 | El Potrero Park | 0 | Local Park 2 | 4 | |
51 | 51 | 50 | {"type": "Polygon", "coordinates": [[[-118.674, 34.29348], [-118.67397, 34.29777], [-118.67398, 34.29799], [-118.67395, 34.30795], [-118.67392, 34.32596], [-118.65355, 34.32593], [-118.6368, 34.29182], [-118.63356, 34.27021], [-118.63407, 34.26984], [-118.63486, 34.26943], [-118.63545, 34.26914], [-118.63594, 34.26887], [-118.63651, 34.26874], [-118.63636, 34.2682], [-118.63686, 34.26821], [-118.63699, 34.26795], [-118.63775, 34.2679], [-118.63862, 34.26735], [-118.63882, 34.26705], [-118.64002, 34.26694], [-118.64055, 34.26718], [-118.64124, 34.26707], [-118.64161, 34.26757], [-118.64205, 34.268], [-118.64292, 34.26794], [-118.64321, 34.26815], [-118.64384, 34.26796], [-118.64476, 34.26861], [-118.64486, 34.26885], [-118.64554, 34.26919], [-118.64591, 34.26945], [-118.64587, 34.26972], [-118.64605, 34.26992], [-118.64617, 34.27043], [-118.64649, 34.27042], [-118.64736, 34.27032], [-118.64857, 34.2705], [-118.64975, 34.27054], [-118.65053, 34.27066], [-118.65167, 34.27079], [-118.65135, 34.27117], [-118.65102, 34.27141], [-118.6505, 34.27233], [-118.65068, 34.27264], [-118.651, 34.27288], [-118.65206, 34.27291], [-118.65241, 34.2726], [-118.65269, 34.27253], [-118.65287, 34.27283], [-118.6536, 34.27319], [-118.65554, 34.27312], [-118.65564, 34.27322], [-118.6557, 34.27352], [-118.65552, 34.27365], [-118.65526, 34.27388], [-118.65532, 34.27401], [-118.6557, 34.27417], [-118.65686, 34.2756], [-118.65684, 34.27585], [-118.65692, 34.276], [-118.65743, 34.27643], [-118.65769, 34.27678], [-118.65796, 34.27742], [-118.65835, 34.27777], [-118.65861, 34.2779], [-118.657, 34.2786], [-118.65697, 34.2852], [-118.65552, 34.2852], [-118.65553, 34.28163], [-118.65284, 34.28162], [-118.65281, 34.2889], [-118.65656, 34.28891], [-118.65656, 34.28992], [-118.65968, 34.28993], [-118.65966, 34.29346], [-118.674, 34.29348]], [[-118.65173, 34.28695], [-118.65174, 34.28673], [-118.65148, 34.28674], [-118.65148, 34.28695], [-118.65173, 34.28695]]]} | Open Access 1 | 147 | Rocky Peak Park | 7206 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://lamountains.com/parks.asp?parkid=51 | Ventura 8 | 3570.979 | Rocky Peak Park | 0 | Local Park 2 | 4 |
52 | 52 | 51 | {"type": "Polygon", "coordinates": [[[-117.25242, 32.75012], [-117.25237, 32.75054], [-117.25232, 32.75081], [-117.25179, 32.75049], [-117.25206, 32.75019], [-117.2521, 32.7502], [-117.25219, 32.75008], [-117.25188, 32.74988], [-117.25193, 32.74983], [-117.25242, 32.75012]]]} | Open Access 1 | 46758 | Saratoga Park | 30209 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 0.754 | Saratoga Park | 0 | Local Park 2 | 4 | |
53 | 53 | 52 | {"type": "MultiPolygon", "coordinates": [[[[-122.45586, 37.69383], [-122.45576, 37.69389], [-122.45521, 37.6939], [-122.45477, 37.69419], [-122.45402, 37.69441], [-122.45367, 37.69455], [-122.45335, 37.69472], [-122.4531, 37.69488], [-122.45282, 37.69509], [-122.45259, 37.6953], [-122.45062, 37.69758], [-122.45045, 37.6978], [-122.45032, 37.69802], [-122.4502, 37.69826], [-122.4501, 37.69855], [-122.44974, 37.7004], [-122.44968, 37.70059], [-122.44958, 37.70076], [-122.44942, 37.70096], [-122.44917, 37.70116], [-122.44887, 37.7013], [-122.44853, 37.70139], [-122.44832, 37.70142], [-122.44805, 37.70141], [-122.44783, 37.70138], [-122.4476, 37.70132], [-122.4405, 37.69868], [-122.44023, 37.69856], [-122.44001, 37.69844], [-122.43785, 37.69708], [-122.43755, 37.6969], [-122.43714, 37.69669], [-122.4366, 37.69645], [-122.43458, 37.6957], [-122.43417, 37.69559], [-122.43381, 37.69556], [-122.43338, 37.69559], [-122.433, 37.69569], [-122.43264, 37.69586], [-122.43232, 37.6961], [-122.4321, 37.69637], [-122.432, 37.69654], [-122.43152, 37.69764], [-122.4314, 37.69782], [-122.43127, 37.69795], [-122.43113, 37.69805], [-122.43099, 37.69813], [-122.43082, 37.69819], [-122.43066, 37.69823], [-122.43032, 37.69825], [-122.43011, 37.69822], [-122.42993, 37.69818], [-122.42964, 37.69804], [-122.42667, 37.69595], [-122.42638, 37.69578], [-122.42605, 37.69566], [-122.42623, 37.69516], [-122.42616, 37.69514], [-122.42723, 37.6929], [-122.42704, 37.69252], [-122.42582, 37.69095], [-122.42486, 37.69026], [-122.42158, 37.68768], [-122.42399, 37.68578], [-122.42719, 37.6823], [-122.42696, 37.68121], [-122.42493, 37.68002], [-122.42415, 37.67959], [-122.42201, 37.67888], [-122.41837, 37.67888], [-122.41635, 37.6811], [-122.41619, 37.68108], [-122.41507, 37.68212], [-122.4155, 37.68555], [-122.41335, 37.6853], [-122.41168, 37.68323], [-122.41122, 37.68323], [-122.41065, 37.68155], [-122.40834, 37.68234], [-122.40806, 37.68223], [-122.40805, 37.68026], [-122.40802, 37.68025], [-122.40801, 37.67981], [-122.40799, 37.67554], [-122.39658, 37.67558], [-122.39656, 37.67385], [-122.39121, 37.67317], [-122.39215, 37.6717], [-122.39265, 37.67096], [-122.39304, 37.67044], [-122.39366, 37.66968], [-122.3938, 37.6696], [-122.39456, 37.66882], [-122.39478, 37.66862], [-122.39508, 37.6684], [-122.39561, 37.66807], [-122.39643, 37.66829], [-122.39717, 37.66803], [-122.39743, 37.66802], [-122.39761, 37.66804], [-122.39776, 37.66808], [-122.39782, 37.6672], [-122.39816, 37.66715], [-122.39923, 37.66776], [-122.40004, 37.66786], [-122.40018, 37.66697], [-122.40105, 37.66718], [-122.40144, 37.66677], [-122.40251, 37.66689], [-122.4031, 37.66666], [-122.40329, 37.6665], [-122.4034, 37.66636], [-122.40431, 37.66619], [-122.40375, 37.66712], [-122.40494, 37.66781], [-122.40544, 37.66781], [-122.40546, 37.66803], [-122.40614, 37.66787], [-122.40669, 37.66702], [-122.40759, 37.66724], [-122.40794, 37.66761], [-122.40779, 37.66826], [-122.40779, 37.66921], [-122.40847, 37.67002], [-122.41005, 37.67065], [-122.41048, 37.67036], [-122.41061, 37.66933], [-122.41164, 37.66899], [-122.41198, 37.66968], [-122.41283, 37.66986], [-122.41318, 37.67063], [-122.41267, 37.67171], [-122.41346, 37.67203], [-122.4138, 37.67093], [-122.4142, 37.67095], [-122.41513, 37.6718], [-122.41506, 37.67293], [-122.41608, 37.67277], [-122.41692, 37.67314], [-122.41748, 37.67301], [-122.41826, 37.67323], [-122.41833, 37.67307], [-122.41841, 37.67304], [-122.41885, 37.67333], [-122.41953, 37.6728], [-122.41996, 37.6717], [-122.42085, 37.67177], [-122.42194, 37.67167], [-122.42373, 37.6721], [-122.42629, 37.66877], [-122.42551, 37.66806], [-122.42518, 37.66782], [-122.42558, 37.66747], [-122.42575, 37.66735], [-122.42596, 37.66726], [-122.42616, 37.6672], [-122.42645, 37.66717], [-122.42667, 37.66718], [-122.42685, 37.66721], [-122.42866, 37.66768], [-122.4322, 37.6696], [-122.43247, 37.66984], [-122.43273, 37.67002], [-122.43361, 37.67048], [-122.43368, 37.67055], [-122.43313, 37.67162], [-122.43261, 37.67487], [-122.43875, 37.6776], [-122.44004, 37.67612], [-122.44052, 37.67588], [-122.44308, 37.67729], [-122.44272, 37.67776], [-122.44382, 37.67836], [-122.44346, 37.67936], [-122.4404, 37.68122], [-122.44001, 37.68139], [-122.43976, 37.68136], [-122.43941, 37.68122], [-122.43962, 37.68327], [-122.44108, 37.68336], [-122.44194, 37.68413], [-122.44347, 37.68464], [-122.4437, 37.68483], [-122.44526, 37.68548], [-122.44567, 37.68577], [-122.44554, 37.6869], [-122.44779, 37.68794], [-122.44798, 37.6881], [-122.44987, 37.68981], [-122.45121, 37.69109], [-122.45281, 37.69165], [-122.45276, 37.69171], [-122.45276, 37.69172], [-122.45455, 37.69233], [-122.45462, 37.69227], [-122.45472, 37.69231], [-122.4558, 37.69346], [-122.45586, 37.69383]], [[-122.43817, 37.69045], [-122.43834, 37.69045], [-122.43851, 37.69041], [-122.43901, 37.69011], [-122.43911, 37.69002], [-122.43919, 37.68989], [-122.43923, 37.68973], [-122.43922, 37.68961], [-122.43915, 37.68943], [-122.43914, 37.68932], [-122.43735, 37.68737], [-122.4362, 37.68732], [-122.43493, 37.68573], [-122.43517, 37.68513], [-122.43488, 37.68471], [-122.43347, 37.6853], [-122.43365, 37.68568], [-122.43427, 37.68552], [-122.43454, 37.68578], [-122.43477, 37.68612], [-122.43501, 37.68604], [-122.43508, 37.68614], [-122.4351, 37.68628], [-122.43504, 37.68668], [-122.43505, 37.68677], [-122.43514, 37.68703], [-122.43515, 37.68712], [-122.43515, 37.68726], [-122.43513, 37.68738], [-122.43509, 37.68746], [-122.4346, 37.68763], [-122.43458, 37.68779], [-122.43519, 37.68785], [-122.43538, 37.68796], [-122.43584, 37.68833], [-122.43613, 37.68846], [-122.43617, 37.68908], [-122.4362, 37.68936], [-122.4366, 37.68941], [-122.43714, 37.68913], [-122.43723, 37.6893], [-122.43735, 37.68971], [-122.43745, 37.68988], [-122.4377, 37.69018], [-122.43778, 37.69026], [-122.43798, 37.69038], [-122.43817, 37.69045]]], [[[-122.41242, 37.69178], [-122.41238, 37.6918], [-122.41233, 37.69197], [-122.41228, 37.69201], [-122.41222, 37.69202], [-122.41206, 37.69196], [-122.41198, 37.6919], [-122.41193, 37.69189], [-122.41188, 37.69191], [-122.41157, 37.69178], [-122.41124, 37.69167], [-122.41122, 37.69164], [-122.41114, 37.69161], [-122.41107, 37.69156], [-122.41098, 37.69155], [-122.41072, 37.69146], [-122.41067, 37.69138], [-122.4107, 37.69123], [-122.41068, 37.69105], [-122.41061, 37.69092], [-122.41058, 37.69073], [-122.41031, 37.69054], [-122.41022, 37.69044], [-122.40999, 37.69035], [-122.40975, 37.69028], [-122.40967, 37.69029], [-122.40959, 37.69033], [-122.40954, 37.69032], [-122.40948, 37.69028], [-122.40942, 37.69027], [-122.40913, 37.69043], [-122.40911, 37.69048], [-122.40921, 37.69061], [-122.40921, 37.69065], [-122.40904, 37.69069], [-122.40896, 37.69068], [-122.40869, 37.69078], [-122.40865, 37.69083], [-122.40867, 37.69093], [-122.40865, 37.69095], [-122.40861, 37.69096], [-122.40844, 37.69089], [-122.4084, 37.69089], [-122.40829, 37.69097], [-122.40824, 37.69111], [-122.40822, 37.69113], [-122.40816, 37.69113], [-122.40804, 37.6911], [-122.40797, 37.69111], [-122.40773, 37.69126], [-122.40761, 37.69125], [-122.40755, 37.69129], [-122.40744, 37.69143], [-122.40742, 37.69149], [-122.40743, 37.69163], [-122.40742, 37.69176], [-122.40739, 37.69192], [-122.40739, 37.69229], [-122.40755, 37.69275], [-122.40771, 37.69292], [-122.40784, 37.69312], [-122.40781, 37.69312], [-122.4078, 37.69313], [-122.40794, 37.69318], [-122.40798, 37.69322], [-122.40798, 37.69326], [-122.40794, 37.6933], [-122.40796, 37.69337], [-122.40793, 37.69344], [-122.40794, 37.69351], [-122.40792, 37.69357], [-122.40796, 37.6936], [-122.40795, 37.69365], [-122.40796, 37.69371], [-122.40799, 37.69372], [-122.40801, 37.6938], [-122.40798, 37.69383], [-122.40801, 37.69387], [-122.40802, 37.69392], [-122.40807, 37.69397], [-122.4081, 37.69403], [-122.40815, 37.69405], [-122.40827, 37.69426], [-122.40849, 37.69454], [-122.40847, 37.69457], [-122.40851, 37.69465], [-122.40852, 37.69472], [-122.40838, 37.69483], [-122.40825, 37.69485], [-122.40821, 37.69484], [-122.40818, 37.69479], [-122.40815, 37.69477], [-122.40719, 37.69314], [-122.407, 37.69291], [-122.4067, 37.69265], [-122.40664, 37.69256], [-122.40661, 37.69245], [-122.40661, 37.69234], [-122.4067, 37.69211], [-122.40675, 37.69193], [-122.40683, 37.69101], [-122.40955, 37.68982], [-122.41003, 37.68984], [-122.41023, 37.68982], [-122.41042, 37.68977], [-122.41047, 37.68979], [-122.41059, 37.68992], [-122.41071, 37.69003], [-122.41113, 37.69032], [-122.41132, 37.69047], [-122.41137, 37.69053], [-122.41142, 37.69054], [-122.4115, 37.69062], [-122.41149, 37.69065], [-122.41154, 37.69073], [-122.41164, 37.69076], [-122.41219, 37.69128], [-122.41219, 37.69135], [-122.41226, 37.69139], [-122.41231, 37.69144], [-122.41234, 37.69145], [-122.41237, 37.69151], [-122.41241, 37.69165], [-122.41242, 37.69178]]], [[[-122.40967, 37.69454], [-122.40962, 37.69458], [-122.40869, 37.6957], [-122.40859, 37.69552], [-122.40863, 37.6955], [-122.40872, 37.69539], [-122.4087, 37.69535], [-122.40881, 37.69525], [-122.40889, 37.69514], [-122.40894, 37.69498], [-122.40893, 37.69483], [-122.40889, 37.69476], [-122.4088, 37.69473], [-122.40864, 37.69453], [-122.40866, 37.69449], [-122.40861, 37.69442], [-122.4085, 37.6943], [-122.40845, 37.69429], [-122.40831, 37.69408], [-122.40822, 37.69389], [-122.40825, 37.69385], [-122.4082, 37.69368], [-122.40816, 37.69364], [-122.40816, 37.6936], [-122.4082, 37.69358], [-122.40818, 37.69349], [-122.40821, 37.69349], [-122.40831, 37.69362], [-122.40832, 37.69372], [-122.40837, 37.69383], [-122.40837, 37.69388], [-122.40846, 37.69401], [-122.40854, 37.69408], [-122.40867, 37.69412], [-122.4087, 37.69419], [-122.40875, 37.69423], [-122.40888, 37.69426], [-122.4091, 37.69427], [-122.4092, 37.69432], [-122.40931, 37.69434], [-122.40937, 37.69445], [-122.4094, 37.69448], [-122.40967, 37.69454]]], [[[-122.41013, 37.69429], [-122.4098, 37.69449], [-122.40983, 37.6943], [-122.40981, 37.69427], [-122.40974, 37.69423], [-122.40974, 37.69419], [-122.4098, 37.69413], [-122.40982, 37.69407], [-122.4099, 37.69408], [-122.40995, 37.69412], [-122.41, 37.69412], [-122.41013, 37.69429]]], [[[-122.41885, 37.69444], [-122.41869, 37.69447], [-122.41861, 37.69443], [-122.41832, 37.69437], [-122.4182, 37.69439], [-122.41809, 37.69438], [-122.41794, 37.6944], [-122.41787, 37.69447], [-122.41795, 37.69476], [-122.41793, 37.69484], [-122.41796, 37.6949], [-122.41773, 37.69491], [-122.41144, 37.69348], [-122.41028, 37.6942], [-122.41024, 37.69417], [-122.4102, 37.69417], [-122.41002, 37.69395], [-122.41002, 37.69383], [-122.41004, 37.69382], [-122.41007, 37.69385], [-122.41015, 37.69382], [-122.41024, 37.6937], [-122.41027, 37.69359], [-122.41026, 37.69347], [-122.41024, 37.69343], [-122.4102, 37.69341], [-122.41018, 37.69341], [-122.41018, 37.69338], [-122.41023, 37.69334], [-122.41026, 37.69335], [-122.4103, 37.69335], [-122.41039, 37.69327], [-122.41039, 37.69322], [-122.41033, 37.69319], [-122.41045, 37.69312], [-122.41047, 37.69288], [-122.41044, 37.69284], [-122.41038, 37.69282], [-122.41014, 37.69279], [-122.41013, 37.69271], [-122.41027, 37.6926], [-122.41031, 37.69247], [-122.41038, 37.69248], [-122.41044, 37.69246], [-122.41043, 37.69242], [-122.41048, 37.69238], [-122.41066, 37.69245], [-122.41088, 37.69229], [-122.41089, 37.69226], [-122.41099, 37.69226], [-122.41108, 37.69222], [-122.41111, 37.69218], [-122.41106, 37.69215], [-122.41107, 37.69212], [-122.41128, 37.69211], [-122.4114, 37.69185], [-122.41169, 37.69197], [-122.4117, 37.69199], [-122.41194, 37.6921], [-122.41198, 37.69209], [-122.41205, 37.69214], [-122.41207, 37.69217], [-122.4122, 37.69223], [-122.41224, 37.69224], [-122.41252, 37.69244], [-122.41252, 37.69248], [-122.4126, 37.69255], [-122.41264, 37.69256], [-122.41279, 37.69266], [-122.4128, 37.6927], [-122.41294, 37.69278], [-122.41302, 37.69279], [-122.41335, 37.69294], [-122.4134, 37.69298], [-122.41357, 37.69302], [-122.41365, 37.69301], [-122.41404, 37.69304], [-122.4144, 37.693], [-122.41442, 37.69303], [-122.41451, 37.69302], [-122.41454, 37.69297], [-122.41469, 37.69293], [-122.41497, 37.69291], [-122.41501, 37.69289], [-122.41505, 37.69291], [-122.41525, 37.6929], [-122.4154, 37.69293], [-122.41543, 37.69292], [-122.41563, 37.69294], [-122.41565, 37.69297], [-122.41646, 37.69307], [-122.4171, 37.6932], [-122.41725, 37.69324], [-122.41743, 37.69325], [-122.41744, 37.69326], [-122.41746, 37.69335], [-122.41749, 37.69342], [-122.41766, 37.69364], [-122.41777, 37.69375], [-122.41819, 37.69409], [-122.41818, 37.69411], [-122.41834, 37.69424], [-122.41874, 37.69437], [-122.41885, 37.69444]]], [[[-122.41994, 37.69322], [-122.41988, 37.69325], [-122.41983, 37.69325], [-122.4197, 37.69319], [-122.41968, 37.69312], [-122.41958, 37.69301], [-122.41937, 37.69292], [-122.41935, 37.69287], [-122.41936, 37.69277], [-122.41932, 37.69269], [-122.41913, 37.69258], [-122.41899, 37.69255], [-122.41886, 37.69258], [-122.41879, 37.69249], [-122.41866, 37.69245], [-122.41847, 37.69244], [-122.41833, 37.69246], [-122.41827, 37.69241], [-122.41812, 37.69236], [-122.41803, 37.69234], [-122.41789, 37.69235], [-122.41768, 37.69226], [-122.41745, 37.69226], [-122.41725, 37.69229], [-122.41691, 37.69223], [-122.41675, 37.69227], [-122.41657, 37.69226], [-122.41625, 37.69232], [-122.41609, 37.69229], [-122.41558, 37.69239], [-122.41553, 37.69236], [-122.41542, 37.69234], [-122.41449, 37.69226], [-122.41437, 37.69218], [-122.41426, 37.69212], [-122.41348, 37.69188], [-122.41275, 37.69155], [-122.41271, 37.69154], [-122.41253, 37.69156], [-122.41248, 37.69143], [-122.4124, 37.69131], [-122.41185, 37.69078], [-122.41184, 37.69073], [-122.41179, 37.69069], [-122.41174, 37.69061], [-122.41172, 37.69059], [-122.41165, 37.69059], [-122.41139, 37.69034], [-122.41138, 37.69029], [-122.41131, 37.69024], [-122.41127, 37.69024], [-122.41122, 37.6902], [-122.4113, 37.6901], [-122.4114, 37.69015], [-122.41157, 37.69024], [-122.41193, 37.69051], [-122.41333, 37.69139], [-122.41386, 37.69164], [-122.41439, 37.69182], [-122.41499, 37.69194], [-122.41555, 37.69199], [-122.41602, 37.69198], [-122.41729, 37.69189], [-122.41758, 37.6919], [-122.41784, 37.69195], [-122.41968, 37.6925], [-122.41965, 37.69271], [-122.41968, 37.69289], [-122.41978, 37.69306], [-122.41994, 37.69322]]], [[[-122.41389, 37.69874], [-122.41362, 37.69876], [-122.41335, 37.69881], [-122.4131, 37.69889], [-122.41284, 37.69901], [-122.4127, 37.69939], [-122.41274, 37.69942], [-122.41259, 37.69957], [-122.41246, 37.69972], [-122.41237, 37.69987], [-122.41227, 37.70007], [-122.41195, 37.69998], [-122.41262, 37.69847], [-122.41389, 37.69874]]], [[[-122.41627, 37.69926], [-122.41623, 37.69934], [-122.4159, 37.69925], [-122.41593, 37.69918], [-122.41627, 37.69926]]], [[[-122.41682, 37.69938], [-122.41677, 37.69949], [-122.41645, 37.6994], [-122.41649, 37.69931], [-122.41682, 37.69938]]], [[[-122.42369, 37.69362], [-122.42242, 37.69613], [-122.42153, 37.69584], [-122.42149, 37.69579], [-122.4215, 37.69577], [-122.42149, 37.69561], [-122.42145, 37.69542], [-122.42137, 37.69525], [-122.42126, 37.69508], [-122.42125, 37.69498], [-122.4212, 37.69493], [-122.42111, 37.69488], [-122.42105, 37.69476], [-122.42094, 37.69465], [-122.42073, 37.69472], [-122.42053, 37.69488], [-122.4204, 37.69477], [-122.42052, 37.69469], [-122.42058, 37.69457], [-122.42058, 37.69454], [-122.42055, 37.69452], [-122.42057, 37.69437], [-122.42056, 37.69423], [-122.42061, 37.69421], [-122.42062, 37.69414], [-122.42065, 37.69409], [-122.42065, 37.69402], [-122.42067, 37.69396], [-122.42064, 37.69392], [-122.42079, 37.69368], [-122.42084, 37.69365], [-122.42086, 37.69357], [-122.42085, 37.69353], [-122.42083, 37.69351], [-122.42083, 37.69346], [-122.42091, 37.69343], [-122.42099, 37.69333], [-122.42099, 37.69329], [-122.42157, 37.69302], [-122.42218, 37.69318], [-122.42345, 37.69357], [-122.42369, 37.69362]]], [[[-122.45778, 37.69822], [-122.45713, 37.69848], [-122.4569, 37.69839], [-122.45677, 37.69801], [-122.45665, 37.69791], [-122.45637, 37.69784], [-122.45602, 37.69762], [-122.4559, 37.69761], [-122.45561, 37.69771], [-122.45557, 37.69797], [-122.45505, 37.69801], [-122.4548, 37.69796], [-122.45465, 37.6978], [-122.45431, 37.69775], [-122.45379, 37.69781], [-122.45376, 37.69776], [-122.45348, 37.69775], [-122.45335, 37.6978], [-122.45316, 37.69807], [-122.45278, 37.69819], [-122.45257, 37.69811], [-122.45212, 37.69808], [-122.45203, 37.69815], [-122.45194, 37.69842], [-122.45218, 37.69879], [-122.45226, 37.69903], [-122.45271, 37.69925], [-122.45254, 37.6995], [-122.45215, 37.69983], [-122.45191, 37.70022], [-122.45191, 37.70053], [-122.45209, 37.70081], [-122.45174, 37.70127], [-122.45128, 37.70148], [-122.45101, 37.70173], [-122.45004, 37.70226], [-122.45001, 37.70247], [-122.44971, 37.70269], [-122.44937, 37.70286], [-122.44916, 37.70289], [-122.44886, 37.70286], [-122.44871, 37.70287], [-122.44857, 37.70293], [-122.44844, 37.70306], [-122.44835, 37.70312], [-122.44822, 37.70316], [-122.44809, 37.70317], [-122.44782, 37.70313], [-122.44777, 37.7031], [-122.44773, 37.70304], [-122.44768, 37.703], [-122.44762, 37.70299], [-122.44752, 37.70301], [-122.44746, 37.703], [-122.44718, 37.7029], [-122.44695, 37.70279], [-122.44905, 37.70165], [-122.44905, 37.70163], [-122.44893, 37.70159], [-122.44919, 37.70148], [-122.44943, 37.70134], [-122.44965, 37.70118], [-122.44982, 37.70099], [-122.44997, 37.70075], [-122.45007, 37.7005], [-122.45042, 37.6987], [-122.45048, 37.69848], [-122.45059, 37.69822], [-122.45073, 37.69797], [-122.45091, 37.69773], [-122.45234, 37.69608], [-122.45319, 37.69684], [-122.45485, 37.69643], [-122.456, 37.69525], [-122.45611, 37.69638], [-122.45698, 37.69769], [-122.45778, 37.69822]]]]} | Open Access 1 | 21942 | San Bruno Mountain State and County Park | 29293 | 324 | San Mateo County Parks and Recreation Dept., County of 28 | County 3 | County Agency - Parks 7 | http://www.co.sanmateo.ca.us/portal/site/parks/ | County 3 | 324 | San Mateo County Parks and Recreation Dept., County of 28 | County 3 | County Agency - Parks 7 | https://parks.smcgov.org/san-bruno-mountain-state-county-park | San Mateo 15 | 2072.999 | San Bruno Mtn. State and County Park | 2000 | Local Park 2 | 4 |
54 | 54 | 53 | {"type": "Polygon", "coordinates": [[[-119.73175, 36.7591], [-119.73175, 36.75936], [-119.73077, 36.75936], [-119.72949, 36.75856], [-119.72945, 36.75845], [-119.72945, 36.75759], [-119.73145, 36.7576], [-119.73104, 36.75782], [-119.73095, 36.75784], [-119.73086, 36.75791], [-119.73087, 36.75827], [-119.73094, 36.75851], [-119.73101, 36.75863], [-119.73118, 36.75885], [-119.73131, 36.75898], [-119.73139, 36.75904], [-119.73157, 36.75909], [-119.73175, 36.7591]]]} | Open Access 1 | 125 | Carozza Park | 16891 | 2036 | Fresno Metropolitan Flood Control District 29 | Special District 4 | Flood District 8 | http://www.fresnofloodcontrol.org/ | Special District 4 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 6.025 | Carozza Park | 0 | Local Park 2 | 4 | |
55 | 55 | 54 | {"type": "Polygon", "coordinates": [[[-121.12622, 37.47895], [-121.12464, 37.47968], [-121.12384, 37.47861], [-121.12544, 37.47788], [-121.12622, 37.47895]]]} | Open Access 1 | 128 | Felipe Garza Park | 18867 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | Stanislaus 2 | 5.539 | Felipe Garza Park | 0 | Local Park 2 | 4 | |
56 | 56 | 55 | {"type": "Polygon", "coordinates": [[[-117.06137, 32.79131], [-117.06126, 32.79227], [-117.06098, 32.79279], [-117.06081, 32.79305], [-117.05968, 32.79265], [-117.05975, 32.79246], [-117.05991, 32.79163], [-117.06039, 32.7917], [-117.06047, 32.79131], [-117.06137, 32.79131]]]} | Open Access 1 | 157 | Pasatiempo Park West Open Space | 23492 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 5.178 | Pasatiempo Park West OS | 0 | Local Recreation Area 3 | 4 | |
57 | 57 | 56 | {"type": "Polygon", "coordinates": [[[-117.16831, 32.71264], [-117.16831, 32.71356], [-117.1674, 32.71356], [-117.1674, 32.71264], [-117.16831, 32.71264]]]} | Open Access 1 | 170 | Pantoja Neighborhood Park | 30100 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 2.149 | Pantoja Neighborhood Park | 0 | Local Park 2 | 4 | |
58 | 58 | 57 | {"type": "Polygon", "coordinates": [[[-117.02209, 32.79762], [-117.02195, 32.79979], [-117.02062, 32.79972], [-117.02075, 32.79755], [-117.02202, 32.79758], [-117.02207, 32.7976], [-117.02209, 32.79762]]]} | Open Access 1 | 129 | San Carlos Community Park | 24847 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 7.486 | San Carlos Community Park | 0 | Local Park 2 | 4 | |
59 | 59 | 58 | {"type": "Polygon", "coordinates": [[[-121.1527, 37.47726], [-121.15269, 37.47821], [-121.15093, 37.47821], [-121.15093, 37.47775], [-121.15095, 37.47748], [-121.15165, 37.47732], [-121.15206, 37.47726], [-121.1527, 37.47726]]]} | Open Access 1 | 143 | Goldbar Park | 19357 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | Stanislaus 2 | 3.779 | Goldbar Park | 0 | Local Park 2 | 4 | |
60 | 60 | 59 | {"type": "Polygon", "coordinates": [[[-121.14269, 37.47264], [-121.14187, 37.47299], [-121.14169, 37.47269], [-121.14164, 37.47256], [-121.1416, 37.47241], [-121.14166, 37.47235], [-121.14203, 37.47228], [-121.14236, 37.47215], [-121.14269, 37.47264]]]} | Open Access 1 | 148 | Golden Amber Park | 19358 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | Stanislaus 2 | 1.295 | Golden Amber 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]);