units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
207 rows where ACCESS_TYP = 3 and AGNCY_LEV = 2 sorted by UNIT_NAME
This data as json, copyable, CSV (advanced)
Suggested facets: MNG_AG_LEV, COUNTY, YR_EST, GAP_STS
MNG_AGENCY >30
- Los Angeles, City of 36
- Torrance, City of 20
- San Diego, City of 18
- Napa, City of 12
- Escondido, City of 10
- Santa Rosa, City of 9
- Rocklin, City of 8
- Los Angeles - Department of Water and Power, City of 7
- Vallejo, City of 7
- Saint Helena, City of 5
- Petaluma, City of 4
- Vacaville, City of 4
- Long Beach, City of 4
- Rolling Hills, City of 3
- Chico, City of 3
- Roseville, City of 3
- Poway, City of 2
- San Marcos, City of 2
- Rancho Palos Verdes, City of 2
- Palos Verdes Estates, City of 2
- La Verne, City of 2
- Redding, City of 2
- Arcata, City of 2
- Sebastopol, City of 2
- Watsonville, City of 1
- Santee, City of 1
- Glendora, City of 1
- Oceanside, City of 1
- East Bay Regional Park District 1
- San Diego, County of 1
- …
DES_TP >30
- Local Other or Unknown 58
- Local Recreation Area 39
- Local Park 38
- Local Conservation Area 7
- Local Resource Management Area 2
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- …
MNG_AG_TYP 6
ACCESS_TYP 1
- No Public Access · 207 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7534 | 7534 | 7533 | {"type": "Polygon", "coordinates": [[[-118.78014, 34.14754], [-118.78008, 34.14761], [-118.78006, 34.14768], [-118.77994, 34.14767], [-118.77967, 34.14771], [-118.77895, 34.14786], [-118.77864, 34.1479], [-118.77715, 34.14789], [-118.77638, 34.14778], [-118.77611, 34.14778], [-118.77413, 34.14793], [-118.77413, 34.14783], [-118.77432, 34.14788], [-118.77524, 34.14781], [-118.77589, 34.14763], [-118.77771, 34.1475], [-118.77817, 34.14749], [-118.77833, 34.14745], [-118.77934, 34.14745], [-118.78014, 34.14754]]]} | No Public Access 3 | 7112 | Agoura Hills City Parkland | 15288 | 1000 | Agoura Hills, City of 319 | City 2 | City Agency 2 | http://www.ci.agoura-hills.ca.us/government/departments/community-services-parks-recreation/parks-facilities | City 2 | 1000 | Agoura Hills, City of 316 | City 2 | City Agency 2 | Los Angeles 6 | 3.654 | Agoura Hills City Parkland | 0 | Local Park 2 | 4 | |
6300 | 6300 | 6299 | {"type": "Polygon", "coordinates": [[[-122.00948, 38.34308], [-122.00872, 38.34467], [-122.00701, 38.34922], [-122.00683, 38.34903], [-122.00699, 38.34894], [-122.00699, 38.34892], [-122.00674, 38.34867], [-122.00658, 38.34877], [-122.00653, 38.34873], [-122.00669, 38.34811], [-122.00525, 38.34739], [-122.00384, 38.34625], [-122.00365, 38.34649], [-122.00372, 38.3469], [-122.00364, 38.34691], [-122.00347, 38.34659], [-122.00335, 38.3466], [-122.00333, 38.34675], [-122.00313, 38.34708], [-122.00328, 38.34718], [-122.0034, 38.34738], [-122.00345, 38.34758], [-122.00328, 38.34776], [-122.00331, 38.34791], [-122.00325, 38.34817], [-122.00307, 38.34857], [-122.00277, 38.34889], [-122.00279, 38.3491], [-122.00256, 38.34887], [-122.00265, 38.34871], [-122.00284, 38.34855], [-122.00297, 38.34837], [-122.00309, 38.34797], [-122.00303, 38.34764], [-122.00318, 38.34745], [-122.00312, 38.34727], [-122.00301, 38.34719], [-122.00296, 38.34712], [-122.00307, 38.3466], [-122.00299, 38.34644], [-122.00268, 38.34637], [-122.00253, 38.3462], [-122.00226, 38.34601], [-122.00198, 38.34544], [-122.00181, 38.34515], [-122.00175, 38.34498], [-122.00215, 38.34482], [-122.00702, 38.34317], [-122.00825, 38.343], [-122.00928, 38.34317], [-122.00948, 38.34308]]]} | No Public Access 3 | 1417 | Alamo Terrace Open Space | 15323 | 1364 | Vacaville, City of 151 | City 2 | City Agency 2 | http://www.cityofvacaville.com/index.aspx?page=374 | City 2 | 1364 | Vacaville, City of 147 | City 2 | City Agency 2 | Solano 26 | 55.193 | Alamo Terrace OS | 2000 | Local Recreation Area 3 | 4 | |
3737 | 3737 | 3736 | {"type": "Polygon", "coordinates": [[[-122.61292, 38.22825], [-122.61179, 38.22899], [-122.61147, 38.22909], [-122.61106, 38.22932], [-122.61101, 38.22968], [-122.61177, 38.23], [-122.61184, 38.23035], [-122.61151, 38.23186], [-122.60961, 38.23153], [-122.60965, 38.23137], [-122.6092, 38.2308], [-122.6087, 38.23061], [-122.61068, 38.22837], [-122.60854, 38.22718], [-122.60936, 38.22628], [-122.60989, 38.22655], [-122.6104, 38.22678], [-122.61292, 38.22825]]]} | No Public Access 3 | 14099 | Alman | 15392 | 1249 | Petaluma, City of 148 | City 2 | City Agency 2 | http://cityofpetaluma.net/parksnrec/index.html | City 2 | 1249 | Petaluma, City of 144 | City 2 | City Agency 2 | Sonoma 16 | 26.587 | Alman | 1995 | None 313 | ||
6615 | 6615 | 6614 | {"type": "MultiPolygon", "coordinates": [[[[-122.77242, 38.38856], [-122.77237, 38.38856], [-122.77228, 38.38852], [-122.77236, 38.38852], [-122.77242, 38.38856]]], [[[-122.78653, 38.39443], [-122.78225, 38.39597], [-122.77744, 38.39197], [-122.77726, 38.39206], [-122.77695, 38.39211], [-122.77686, 38.39216], [-122.77651, 38.39193], [-122.77658, 38.39187], [-122.77677, 38.39178], [-122.77708, 38.3917], [-122.77709, 38.39169], [-122.77328, 38.38856], [-122.77867, 38.38851], [-122.77897, 38.38833], [-122.77912, 38.38832], [-122.77993, 38.38786], [-122.78653, 38.39443]]], [[[-122.79813, 38.3852], [-122.79796, 38.38596], [-122.7971, 38.38672], [-122.79711, 38.38673], [-122.79756, 38.38673], [-122.79756, 38.38825], [-122.79762, 38.38827], [-122.79761, 38.38881], [-122.7974, 38.38973], [-122.79746, 38.39027], [-122.79521, 38.39118], [-122.79444, 38.39148], [-122.78668, 38.39437], [-122.78491, 38.39263], [-122.78087, 38.38859], [-122.78007, 38.38777], [-122.7815, 38.38698], [-122.78783, 38.38684], [-122.78778, 38.38578], [-122.78764, 38.38578], [-122.78757, 38.38314], [-122.79463, 38.38229], [-122.79484, 38.38244], [-122.79564, 38.38276], [-122.79618, 38.38313], [-122.79632, 38.38369], [-122.79703, 38.38415], [-122.79707, 38.38419], [-122.79708, 38.38423], [-122.79813, 38.3852]]]]} | No Public Access 3 | 4205 | Alpha Farm | 15405 | 1324 | Santa Rosa, City of 30 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | Sonoma 16 | 410.901 | Alpha Farm | None 534 | |||
6548 | 6548 | 6547 | {"type": "Polygon", "coordinates": [[[-122.27836, 38.16698], [-122.27244, 38.16694], [-122.27213, 38.16617], [-122.26881, 38.16606], [-122.26808, 38.16422], [-122.27137, 38.16431], [-122.27832, 38.16431], [-122.27836, 38.16698]]]} | No Public Access 3 | 3636 | American Canyon Property | 15448 | 1005 | American Canyon, City of 434 | City 2 | City Agency 2 | http://cityofamericancanyon.org/city-departments/parks-recreation | City 2 | 1005 | American Canyon, City of 428 | City 2 | City Agency 2 | Napa 11 | 55.469 | American Canyon Property | 0 | Local Other or Unknown 14 | 4 | |
13577 | 13577 | 13576 | {"type": "Polygon", "coordinates": [[[-118.3507, 33.84601], [-118.34892, 33.84601], [-118.34892, 33.84506], [-118.3507, 33.84506], [-118.3507, 33.84601]]]} | No Public Access 3 | 35908 | Amie Sump | 29076 | 1349 | Torrance, City of 292 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | Los Angeles 6 | 4.269 | Amie Sump | None 1174 | |||
11528 | 11528 | 11527 | {"type": "MultiPolygon", "coordinates": [[[[-118.20612, 34.09335], [-118.20612, 34.09367], [-118.20609, 34.09391], [-118.20603, 34.09414], [-118.20585, 34.09457], [-118.20574, 34.09476], [-118.20539, 34.09529], [-118.20514, 34.09529], [-118.20525, 34.09514], [-118.20561, 34.09453], [-118.20574, 34.09423], [-118.20589, 34.09374], [-118.20591, 34.09362], [-118.20585, 34.09312], [-118.20611, 34.09327], [-118.20612, 34.09335]]], [[[-118.21437, 34.0859], [-118.21414, 34.08614], [-118.21334, 34.08653], [-118.21306, 34.08656], [-118.21308, 34.08615], [-118.21331, 34.08615], [-118.21354, 34.08612], [-118.21437, 34.0859]]], [[[-118.21725, 34.08529], [-118.21666, 34.08551], [-118.21583, 34.08575], [-118.21493, 34.08606], [-118.21453, 34.08616], [-118.21514, 34.08556], [-118.21705, 34.08507], [-118.21725, 34.08529]]], [[[-118.21928, 34.08401], [-118.21881, 34.08457], [-118.21873, 34.08448], [-118.21867, 34.08452], [-118.21875, 34.08463], [-118.21872, 34.08466], [-118.21851, 34.08482], [-118.21827, 34.08496], [-118.21744, 34.08522], [-118.21725, 34.08502], [-118.21735, 34.08499], [-118.21739, 34.085], [-118.21866, 34.08447], [-118.21794, 34.08379], [-118.21823, 34.08357], [-118.21895, 34.08425], [-118.21928, 34.08401]]], [[[-118.21932, 34.08461], [-118.21932, 34.08461], [-118.21922, 34.08464], [-118.21929, 34.08457], [-118.21932, 34.08461]]], [[[-118.22153, 34.0833], [-118.22011, 34.0842], [-118.22009, 34.0842], [-118.21967, 34.08445], [-118.21941, 34.08457], [-118.21934, 34.0845], [-118.21976, 34.08399], [-118.22099, 34.0832], [-118.22118, 34.08291], [-118.22153, 34.0833]]], [[[-118.22322, 34.08205], [-118.22301, 34.08223], [-118.22284, 34.08234], [-118.2219, 34.08307], [-118.2217, 34.0832], [-118.22143, 34.08291], [-118.22155, 34.0828], [-118.22226, 34.08224], [-118.22263, 34.08208], [-118.223, 34.08203], [-118.22322, 34.08205]]], [[[-118.22504, 34.08065], [-118.22417, 34.08133], [-118.2239, 34.08122], [-118.22364, 34.08107], [-118.22349, 34.0808], [-118.22324, 34.08066], [-118.22291, 34.08042], [-118.22401, 34.07994], [-118.22406, 34.08001], [-118.22451, 34.07981], [-118.22504, 34.08065]]], [[[-118.22587, 34.08011], [-118.2253, 34.08058], [-118.22499, 34.08008], [-118.22561, 34.07945], [-118.22587, 34.08011]]], [[[-118.226, 34.08102], [-118.22572, 34.08124], [-118.22553, 34.08095], [-118.22581, 34.08073], [-118.226, 34.08102]]], [[[-118.22621, 34.08087], [-118.22604, 34.081], [-118.22584, 34.08069], [-118.22603, 34.08052], [-118.22621, 34.08087]]], [[[-118.22632, 34.08108], [-118.22625, 34.0811], [-118.22606, 34.08118], [-118.22628, 34.081], [-118.22632, 34.08108]]]]} | No Public Access 3 | 29604 | Arroyo Seco | 15626 | 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 | http://lacity.org/ | Los Angeles 6 | 16.466 | Arroyo Seco | None 1029 | ||
3550 | 3550 | 3549 | {"type": "Polygon", "coordinates": [[[-122.79598, 38.68638], [-122.79593, 38.68645], [-122.79587, 38.68663], [-122.79584, 38.68702], [-122.79582, 38.68712], [-122.79577, 38.68724], [-122.79549, 38.68779], [-122.79545, 38.68786], [-122.79501, 38.68816], [-122.79483, 38.68832], [-122.79478, 38.68849], [-122.79478, 38.68903], [-122.79483, 38.68923], [-122.79486, 38.68944], [-122.79482, 38.68962], [-122.79478, 38.68969], [-122.79471, 38.68978], [-122.79457, 38.68984], [-122.79425, 38.68987], [-122.79372, 38.68983], [-122.79362, 38.68984], [-122.79311, 38.68994], [-122.79276, 38.69005], [-122.79265, 38.69012], [-122.79244, 38.6902], [-122.79194, 38.69034], [-122.79182, 38.69038], [-122.79175, 38.69043], [-122.79171, 38.6905], [-122.79168, 38.69063], [-122.79137, 38.69088], [-122.79073, 38.69135], [-122.79069, 38.69141], [-122.79067, 38.69148], [-122.7907, 38.6916], [-122.79102, 38.69195], [-122.79109, 38.69208], [-122.79115, 38.69228], [-122.79115, 38.69241], [-122.79113, 38.69252], [-122.79101, 38.69282], [-122.79094, 38.6929], [-122.79085, 38.69297], [-122.79052, 38.69312], [-122.79023, 38.69322], [-122.79012, 38.69328], [-122.78934, 38.69224], [-122.78925, 38.6893], [-122.78809, 38.68905], [-122.7847, 38.68871], [-122.78467, 38.68598], [-122.79598, 38.68638]]]} | No Public Access 3 | 28288 | Bear Canyon | 15921 | 1324 | Santa Rosa, City of 30 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | Sonoma 16 | 98.229 | Bear Canyon | 0 | Local Recreation Area 3 | 4 | |
9526 | 9526 | 9525 | {"type": "Polygon", "coordinates": [[[-122.49213, 38.55407], [-122.4921, 38.55514], [-122.49007, 38.55516], [-122.49014, 38.55796], [-122.49014, 38.55878], [-122.48984, 38.5588], [-122.48659, 38.56392], [-122.48242, 38.5639], [-122.48233, 38.55908], [-122.48077, 38.55917], [-122.48076, 38.55875], [-122.47996, 38.55875], [-122.47995, 38.55606], [-122.48094, 38.55589], [-122.48093, 38.55317], [-122.48554, 38.55315], [-122.48553, 38.55216], [-122.48468, 38.55149], [-122.48316, 38.5515], [-122.48315, 38.55125], [-122.4831, 38.5512], [-122.48307, 38.55064], [-122.48356, 38.55098], [-122.48489, 38.5514], [-122.48496, 38.55146], [-122.48498, 38.55149], [-122.48552, 38.55192], [-122.48553, 38.55191], [-122.48813, 38.55396], [-122.48848, 38.5542], [-122.48872, 38.55429], [-122.48904, 38.55434], [-122.48961, 38.55429], [-122.49008, 38.55422], [-122.49213, 38.55407]]]} | No Public Access 3 | 15982 | Bell Canyon Reservoir | 15971 | 1290 | Saint Helena, City of 422 | City 2 | City Agency 2 | http://cityofsthelena.org/parks-recreation | City 2 | 1290 | Saint Helena, City of 416 | City 2 | City Agency 2 | Napa 11 | 206.019 | Bell Canyon Reservoir | 0 | Local Recreation Area 3 | 4 | |
6608 | 6608 | 6607 | {"type": "Polygon", "coordinates": [[[-117.03964, 32.5565], [-117.03952, 32.55674], [-117.03854, 32.5569], [-117.03824, 32.55697], [-117.03804, 32.55697], [-117.03763, 32.55706], [-117.03762, 32.55704], [-117.03717, 32.55717], [-117.03738, 32.55766], [-117.03743, 32.55783], [-117.03746, 32.55795], [-117.03747, 32.55822], [-117.03369, 32.55819], [-117.03357, 32.55452], [-117.03776, 32.55454], [-117.03928, 32.55638], [-117.03964, 32.5565]]]} | No Public Access 3 | 4168 | Beyer Community Park | 30224 | 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 | 43.828 | Beyer Community Park | 0 | Local Park 2 | 4 | |
14695 | 14695 | 14694 | {"type": "MultiPolygon", "coordinates": [[[[-121.84325, 39.73187], [-121.84302, 39.73192], [-121.84284, 39.7319], [-121.8422, 39.73193], [-121.84217, 39.73192], [-121.84212, 39.73178], [-121.84229, 39.73181], [-121.84258, 39.7318], [-121.84284, 39.73176], [-121.84292, 39.73172], [-121.8431, 39.73171], [-121.84317, 39.73169], [-121.84325, 39.73187]]], [[[-121.8483, 39.72901], [-121.84825, 39.72906], [-121.84809, 39.72914], [-121.84775, 39.72926], [-121.84745, 39.72934], [-121.84724, 39.72943], [-121.84701, 39.72956], [-121.84693, 39.72964], [-121.84664, 39.73034], [-121.84626, 39.73047], [-121.84533, 39.73053], [-121.8451, 39.73057], [-121.84483, 39.73066], [-121.84461, 39.73079], [-121.84442, 39.73095], [-121.84438, 39.73092], [-121.84423, 39.73115], [-121.84412, 39.73137], [-121.84389, 39.73163], [-121.84382, 39.73172], [-121.84344, 39.73192], [-121.84338, 39.73185], [-121.84331, 39.73187], [-121.84322, 39.73166], [-121.84325, 39.73162], [-121.84348, 39.73146], [-121.84363, 39.73136], [-121.84379, 39.73128], [-121.84391, 39.73119], [-121.84403, 39.73107], [-121.84412, 39.7309], [-121.84423, 39.73057], [-121.84431, 39.73045], [-121.84438, 39.73039], [-121.84469, 39.73023], [-121.84494, 39.73022], [-121.84504, 39.73015], [-121.84512, 39.73011], [-121.8453, 39.73009], [-121.84578, 39.73006], [-121.84608, 39.73008], [-121.84626, 39.73003], [-121.8464, 39.72995], [-121.84652, 39.72982], [-121.84662, 39.72962], [-121.84663, 39.72953], [-121.84673, 39.72936], [-121.8468, 39.72928], [-121.84694, 39.72919], [-121.8472, 39.72907], [-121.84743, 39.72901], [-121.84782, 39.72895], [-121.84786, 39.72891], [-121.84794, 39.72886], [-121.84801, 39.72875], [-121.8483, 39.72901]]], [[[-121.85008, 39.72685], [-121.84992, 39.72697], [-121.84966, 39.72711], [-121.84932, 39.7274], [-121.84909, 39.72756], [-121.84895, 39.72763], [-121.84884, 39.72766], [-121.84868, 39.72775], [-121.8486, 39.72781], [-121.84849, 39.72795], [-121.84844, 39.72805], [-121.84837, 39.72832], [-121.84848, 39.72843], [-121.84856, 39.72859], [-121.8486, 39.72873], [-121.84857, 39.72885], [-121.84847, 39.72892], [-121.848, 39.72838], [-121.84804, 39.72817], [-121.84803, 39.72807], [-121.84809, 39.72795], [-121.84797, 39.72791], [-121.84809, 39.72764], [-121.84834, 39.72746], [-121.84855, 39.72742], [-121.84872, 39.72736], [-121.84919, 39.72713], [-121.84954, 39.72687], [-121.84986, 39.72666], [-121.85008, 39.72685]]], [[[-121.8512, 39.72593], [-121.85116, 39.72596], [-121.85119, 39.72599], [-121.8503, 39.72669], [-121.85018, 39.72659], [-121.8504, 39.72642], [-121.85079, 39.72605], [-121.85108, 39.72583], [-121.8512, 39.72593]]], [[[-121.86328, 39.72721], [-121.86263, 39.72725], [-121.8612, 39.72719], [-121.86002, 39.72711], [-121.85943, 39.72703], [-121.85906, 39.72692], [-121.85858, 39.72666], [-121.85839, 39.7266], [-121.85768, 39.7262], [-121.85723, 39.72585], [-121.85702, 39.7254], [-121.85697, 39.72523], [-121.85686, 39.72523], [-121.8561, 39.72558], [-121.85451, 39.72559], [-121.85403, 39.72573], [-121.85311, 39.72573], [-121.85237, 39.72569], [-121.85169, 39.72575], [-121.85138, 39.72585], [-121.85126, 39.7257], [-121.85142, 39.72564], [-121.85167, 39.72557], [-121.85199, 39.72557], [-121.85202, 39.72548], [-121.85209, 39.72541], [-121.85218, 39.72536], [-121.8523, 39.72534], [-121.85254, 39.72537], [-121.85272, 39.72543], [-121.85293, 39.72553], [-121.85326, 39.72561], [-121.85353, 39.72565], [-121.85371, 39.72566], [-121.85381, 39.72565], [-121.85429, 39.7255], [-121.85471, 39.72544], [-121.85547, 39.7254], [-121.85597, 39.72543], [-121.85597, 39.72537], [-121.85619, 39.72535], [-121.85641, 39.72522], [-121.8565, 39.72518], [-121.85661, 39.72506], [-121.85683, 39.72489], [-121.8569, 39.72487], [-121.85698, 39.72487], [-121.85711, 39.72494], [-121.85721, 39.72502], [-121.85724, 39.72507], [-121.85724, 39.7251], [-121.85727, 39.72514], [-121.85723, 39.72537], [-121.85725, 39.72547], [-121.85729, 39.7256], [-121.85738, 39.72571], [-121.85741, 39.72581], [-121.85746, 39.72584], [-121.85761, 39.72598], [-121.85777, 39.72606], [-121.85814, 39.72618], [-121.8583, 39.72625], [-121.85865, 39.7266], [-121.85876, 39.72669], [-121.85887, 39.72676], [-121.85899, 39.72679], [-121.85929, 39.72684], [-121.85967, 39.72699], [-121.85978, 39.72701], [-121.8607, 39.72698], [-121.86125, 39.72705], [-121.86152, 39.72709], [-121.8623, 39.72711], [-121.86296, 39.72709], [-121.86325, 39.72706], [-121.86328, 39.72721]]], [[[-121.88182, 39.72846], [-121.88181, 39.72884], [-121.88173, 39.72876], [-121.881, 39.72855], [-121.88033, 39.7281], [-121.87939, 39.72783], [-121.87927, 39.72773], [-121.87885, 39.72768], [-121.87833, 39.72773], [-121.87807, 39.72762], [-121.87754, 39.72657], [-121.87719, 39.72646], [-121.87653, 39.72635], [-121.87582, 39.72599], [-121.87462, 39.72552], [-121.87396, 39.72505], [-121.87318, 39.72512], [-121.87248, 39.72505], [-121.87209, 39.72507], [-121.87158, 39.72511], [-121.87086, 39.72494], [-121.87042, 39.72497], [-121.86931, 39.72491], [-121.8688, 39.72496], [-121.86836, 39.72481], [-121.86786, 39.72441], [-121.86763, 39.72442], [-121.86694, 39.72482], [-121.86674, 39.72503], [-121.86566, 39.72545], [-121.86534, 39.7259], [-121.86486, 39.72674], [-121.8647, 39.72681], [-121.86355, 39.72717], [-121.86353, 39.72705], [-121.86366, 39.72704], [-121.86424, 39.72678], [-121.86473, 39.72666], [-121.86483, 39.72657], [-121.86512, 39.72589], [-121.8653, 39.72573], [-121.86558, 39.7253], [-121.86592, 39.72526], [-121.86679, 39.72487], [-121.86725, 39.72445], [-121.86755, 39.72432], [-121.86794, 39.7243], [-121.86842, 39.72471], [-121.86888, 39.72485], [-121.86933, 39.72479], [-121.87007, 39.72482], [-121.87043, 39.72486], [-121.87059, 39.72485], [-121.87108, 39.72475], [-121.8717, 39.72495], [-121.8727, 39.72489], [-121.87293, 39.72492], [-121.87324, 39.72501], [-121.87334, 39.725], [-121.87345, 39.72494], [-121.87383, 39.72484], [-121.87393, 39.72482], [-121.87402, 39.72483], [-121.87417, 39.72495], [-121.87425, 39.72497], [-121.87444, 39.72511], [-121.87462, 39.72521], [-121.87531, 39.72551], [-121.87658, 39.72618], [-121.87676, 39.72623], [-121.877, 39.72624], [-121.87734, 39.72622], [-121.87745, 39.72624], [-121.87752, 39.72628], [-121.87763, 39.7264], [-121.8777, 39.7265], [-121.87776, 39.72665], [-121.8778, 39.72684], [-121.87786, 39.72691], [-121.87798, 39.72694], [-121.87843, 39.72696], [-121.87864, 39.72699], [-121.87871, 39.72704], [-121.87876, 39.72718], [-121.87878, 39.72721], [-121.87892, 39.72736], [-121.87907, 39.72746], [-121.87933, 39.72753], [-121.87953, 39.72761], [-121.87962, 39.72768], [-121.87983, 39.72777], [-121.88016, 39.72782], [-121.8804, 39.72781], [-121.88053, 39.72783], [-121.88074, 39.72795], [-121.88104, 39.72818], [-121.88134, 39.72839], [-121.88165, 39.72846], [-121.88182, 39.72846]]]]} | No Public Access 3 | 45025 | Big Chico Creek Greenway | 28979 | 1052 | Chico, City of 430 | City 2 | City Agency 2 | http://www.chico.ca.us/general_services_department/park_division/home_page.asp | City 2 | 1052 | Chico, City of 424 | City 2 | City Agency 2 | Butte 42 | 23.271 | Big Chico Creek Greenway | 0 | Local Recreation Area 3 | 4 | |
13405 | 13405 | 13404 | {"type": "Polygon", "coordinates": [[[-118.37164, 33.83617], [-118.37117, 33.83684], [-118.36977, 33.83684], [-118.36976, 33.83423], [-118.37087, 33.83423], [-118.37163, 33.8351], [-118.37164, 33.83617]]]} | No Public Access 3 | 35517 | Bishop Montgomery Sump | 29080 | 1349 | Torrance, City of 292 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | Los Angeles 6 | 11.207 | Bishop Montgomery Sump | None 1158 | |||
1582 | 1582 | 1581 | {"type": "Polygon", "coordinates": [[[-117.82912, 34.14946], [-117.82885, 34.14936], [-117.82829, 34.14947], [-117.82773, 34.14985], [-117.82742, 34.15028], [-117.82749, 34.15045], [-117.82786, 34.15061], [-117.82438, 34.15057], [-117.82438, 34.14914], [-117.82357, 34.14912], [-117.82356, 34.15056], [-117.82044, 34.15052], [-117.82046, 34.14695], [-117.82316, 34.14695], [-117.82342, 34.14662], [-117.82369, 34.14649], [-117.82447, 34.14649], [-117.82481, 34.14653], [-117.8251, 34.14658], [-117.82536, 34.1467], [-117.8256, 34.14692], [-117.82593, 34.14718], [-117.82618, 34.14742], [-117.82624, 34.14755], [-117.82616, 34.14804], [-117.8262, 34.14824], [-117.82629, 34.14838], [-117.82642, 34.14844], [-117.82655, 34.14842], [-117.82667, 34.14838], [-117.82701, 34.14807], [-117.82734, 34.14792], [-117.82798, 34.14756], [-117.82833, 34.14752], [-117.82857, 34.14755], [-117.82863, 34.14754], [-117.82857, 34.14739], [-117.82859, 34.14727], [-117.82865, 34.14713], [-117.82884, 34.14698], [-117.82912, 34.14698], [-117.82912, 34.14946]]]} | No Public Access 3 | 12131 | Bluebird Preserve | 32639 | 1120 | Glendora, City of 76 | City 2 | City Agency 2 | http://www.ci.glendora.ca.us/departments-services/parks-recreation-senior-services | City 2 | 1120 | Glendora, City of 74 | City 2 | City Agency 2 | Los Angeles 6 | 68.179 | Bluebird Preserve | 0 | Local Conservation Area 4 | 2 | |
15412 | 15412 | 15411 | {"type": "Polygon", "coordinates": [[[-118.406, 33.79151], [-118.40587, 33.79177], [-118.40576, 33.79194], [-118.40567, 33.79201], [-118.40524, 33.7921], [-118.40517, 33.7922], [-118.40513, 33.7924], [-118.40438, 33.79231], [-118.40443, 33.79216], [-118.4045, 33.79203], [-118.40506, 33.79115], [-118.40519, 33.791], [-118.406, 33.79151]]]} | No Public Access 3 | 46640 | Bluff Cove North | 29976 | 1244 | Palos Verdes Estates, City of 293 | City 2 | City Agency 2 | http://www.pvestates.org/ | City 2 | 1244 | Palos Verdes Estates, City of 289 | City 2 | City Agency 2 | Los Angeles 6 | 3.008 | Bluff Cove North | None 1362 | |||
15410 | 15410 | 15409 | {"type": "Polygon", "coordinates": [[[-118.407, 33.79048], [-118.40696, 33.79057], [-118.40695, 33.79068], [-118.40687, 33.79076], [-118.40686, 33.79084], [-118.40677, 33.79095], [-118.40645, 33.79106], [-118.40624, 33.79121], [-118.40586, 33.79072], [-118.40633, 33.79064], [-118.40657, 33.79056], [-118.40695, 33.79039], [-118.407, 33.79048]]]} | No Public Access 3 | 46637 | Bluff Cove South | 29977 | 1244 | Palos Verdes Estates, City of 293 | City 2 | City Agency 2 | http://www.pvestates.org/ | City 2 | 1244 | Palos Verdes Estates, City of 289 | City 2 | City Agency 2 | Los Angeles 6 | 1.097 | Bluff Cove South | None 1361 | |||
6597 | 6597 | 6596 | {"type": "MultiPolygon", "coordinates": [[[[-122.81587, 38.40123], [-122.81272, 38.40264], [-122.81266, 38.4026], [-122.81259, 38.40252], [-122.81251, 38.40232], [-122.8125, 38.40212], [-122.81253, 38.40196], [-122.81251, 38.40187], [-122.81245, 38.40185], [-122.81236, 38.40191], [-122.81224, 38.40206], [-122.81216, 38.4022], [-122.81215, 38.40227], [-122.8122, 38.40247], [-122.81207, 38.40279], [-122.81206, 38.40286], [-122.8121, 38.40292], [-122.80774, 38.40488], [-122.80551, 38.40586], [-122.80424, 38.40644], [-122.80102, 38.40784], [-122.8008, 38.40792], [-122.80001, 38.40832], [-122.79906, 38.40885], [-122.79838, 38.40919], [-122.79601, 38.41007], [-122.79446, 38.41071], [-122.79431, 38.4105], [-122.7948, 38.41031], [-122.79481, 38.4103], [-122.79469, 38.41013], [-122.79451, 38.41029], [-122.79424, 38.4104], [-122.79317, 38.40885], [-122.79019, 38.40445], [-122.79012, 38.40432], [-122.78868, 38.40221], [-122.7934, 38.40115], [-122.81277, 38.39668], [-122.81331, 38.39672], [-122.81342, 38.39753], [-122.81363, 38.39754], [-122.81382, 38.39773], [-122.81484, 38.39865], [-122.81524, 38.39907], [-122.8155, 38.39927], [-122.8156, 38.39953], [-122.81568, 38.40008], [-122.81565, 38.40089], [-122.81569, 38.40107], [-122.81573, 38.40118], [-122.81584, 38.40118], [-122.81587, 38.40123]], [[-122.79167, 38.40561], [-122.7905, 38.40387], [-122.79017, 38.40335], [-122.79015, 38.40335], [-122.79016, 38.40341], [-122.79022, 38.40352], [-122.79161, 38.40558], [-122.79166, 38.40564], [-122.79167, 38.40561]], [[-122.79449, 38.40986], [-122.7939, 38.40892], [-122.79355, 38.40842], [-122.7932, 38.40791], [-122.79289, 38.40741], [-122.79257, 38.40696], [-122.79309, 38.40795], [-122.79429, 38.41005], [-122.7943, 38.41005], [-122.79449, 38.40986]]], [[[-122.81641, 38.40121], [-122.81554, 38.4016], [-122.81554, 38.40315], [-122.81577, 38.40353], [-122.8131, 38.40439], [-122.80605, 38.40685], [-122.79987, 38.40907], [-122.79972, 38.40883], [-122.80116, 38.40807], [-122.80147, 38.40794], [-122.80163, 38.40819], [-122.80555, 38.4068], [-122.80919, 38.40545], [-122.81179, 38.40453], [-122.81179, 38.40451], [-122.81153, 38.40448], [-122.81074, 38.40427], [-122.81033, 38.40411], [-122.81012, 38.40399], [-122.81108, 38.40358], [-122.81322, 38.40262], [-122.81613, 38.40122], [-122.81641, 38.40121]]]]} | No Public Access 3 | 4034 | Brown Farm | 16443 | 1324 | Santa Rosa, City of 30 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | Sonoma 16 | 468.322 | Brown Farm | None 532 | |||
6730 | 6730 | 6729 | {"type": "Polygon", "coordinates": [[[-122.1629, 37.36432], [-122.16229, 37.3647], [-122.16191, 37.36476], [-122.16185, 37.36454], [-122.16027, 37.36435], [-122.16046, 37.36512], [-122.15953, 37.36527], [-122.15962, 37.36576], [-122.15884, 37.36605], [-122.15821, 37.36623], [-122.15804, 37.36625], [-122.15788, 37.36621], [-122.15731, 37.36594], [-122.15714, 37.36581], [-122.15695, 37.36561], [-122.15689, 37.36552], [-122.15686, 37.36542], [-122.15684, 37.36518], [-122.15681, 37.36505], [-122.15673, 37.3649], [-122.15666, 37.36479], [-122.15564, 37.36365], [-122.15552, 37.36353], [-122.1553, 37.36338], [-122.15454, 37.36294], [-122.15444, 37.36285], [-122.15435, 37.36275], [-122.15391, 37.36215], [-122.1548, 37.36189], [-122.15486, 37.3613], [-122.15455, 37.36088], [-122.15433, 37.36066], [-122.15462, 37.35983], [-122.15468, 37.3598], [-122.15598, 37.36056], [-122.15779, 37.36015], [-122.15749, 37.35841], [-122.1567, 37.35775], [-122.15615, 37.35772], [-122.15574, 37.35834], [-122.15479, 37.35873], [-122.15459, 37.35836], [-122.15412, 37.35852], [-122.15396, 37.35773], [-122.15471, 37.35722], [-122.1545, 37.35675], [-122.15406, 37.3564], [-122.15371, 37.35589], [-122.15195, 37.35513], [-122.15199, 37.35454], [-122.15207, 37.35431], [-122.15222, 37.35412], [-122.15234, 37.35377], [-122.15211, 37.35335], [-122.15238, 37.35351], [-122.15435, 37.35486], [-122.15491, 37.3554], [-122.1555, 37.35525], [-122.15595, 37.35548], [-122.15607, 37.35557], [-122.15665, 37.3561], [-122.15686, 37.35627], [-122.1573, 37.35678], [-122.15757, 37.35701], [-122.15821, 37.35746], [-122.15835, 37.35753], [-122.15881, 37.35765], [-122.15879, 37.35799], [-122.15874, 37.35816], [-122.15869, 37.35844], [-122.15867, 37.35892], [-122.1587, 37.35929], [-122.15866, 37.35963], [-122.15841, 37.36001], [-122.15833, 37.36025], [-122.15816, 37.36059], [-122.15812, 37.36084], [-122.1582, 37.36124], [-122.15844, 37.36166], [-122.15871, 37.36199], [-122.15885, 37.362], [-122.15894, 37.36236], [-122.15932, 37.36231], [-122.15937, 37.36237], [-122.15941, 37.36238], [-122.15954, 37.3627], [-122.16023, 37.36295], [-122.16124, 37.36311], [-122.16158, 37.36318], [-122.16226, 37.36325], [-122.16236, 37.36364], [-122.1629, 37.36432]]]} | No Public Access 3 | 5074 | Byrne Reserve | 16619 | 1187 | Los Altos Hills, Town of 842 | City 2 | City Agency 2 | http://www.losaltoshills.ca.gov/parks-and-recreation/parks-and-recreation | City 2 | 1187 | Los Altos Hills, Town of 819 | City 2 | City Agency 2 | Santa Clara 19 | 100.121 | Byrne Reserve | 1968 | Local Conservation Area 4 | 2 | |
14392 | 14392 | 14391 | {"type": "Polygon", "coordinates": [[[-119.0697, 35.32864], [-119.06838, 35.32934], [-119.06763, 35.3284], [-119.06767, 35.32841], [-119.06768, 35.3284], [-119.06768, 35.32755], [-119.06886, 35.32754], [-119.06911, 35.32757], [-119.06936, 35.32809], [-119.0695, 35.32834], [-119.0697, 35.32864]]]} | No Public Access 3 | 44533 | Castle Park | 16951 | 1019 | Bakersfield, City of 248 | City 2 | City Agency 2 | http://www.bakersfieldcity.us/recreation/ | City 2 | 1019 | Bakersfield, City of 244 | City 2 | City Agency 2 | Kern 36 | 6.243 | Castle Park | 0 | Local Park 2 | 4 | |
4092 | 4092 | 4091 | {"type": "Polygon", "coordinates": [[[-118.518, 34.05167], [-118.51753, 34.05174], [-118.51751, 34.0517], [-118.51798, 34.05163], [-118.518, 34.05167]]]} | No Public Access 3 | 47493 | Chautauqua Blvd Access to Will Rogers State Historic Preserve | 31212 | 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 | 0.053 | Chautauqua Blvd Access to Will Rogers SHPr | None 355 | |||
6952 | 6952 | 6951 | {"type": "MultiPolygon", "coordinates": [[[[-118.36586, 33.74172], [-118.36573, 33.74211], [-118.36423, 33.74199], [-118.36421, 33.74194], [-118.36354, 33.74194], [-118.36342, 33.7416], [-118.36408, 33.74169], [-118.36424, 33.74176], [-118.36433, 33.74168], [-118.36443, 33.74165], [-118.36534, 33.74164], [-118.36536, 33.74158], [-118.36536, 33.74124], [-118.36571, 33.74125], [-118.36574, 33.74162], [-118.36572, 33.74169], [-118.36586, 33.74172]]], [[[-118.36682, 33.74147], [-118.36644, 33.74187], [-118.36637, 33.74183], [-118.36622, 33.7418], [-118.36635, 33.74143], [-118.3663, 33.7412], [-118.36673, 33.74113], [-118.36682, 33.74147]]]]} | No Public Access 3 | 5857 | Cherry Hill Lots | 29428 | 1265 | Rancho Palos Verdes, City of 265 | City 2 | City Agency 2 | http://palosverdes.com/rpv/recreationparks/index.cfm | City 2 | 1265 | Rancho Palos Verdes, City of 283 | City 2 | City Agency 2 | Los Angeles 6 | 3.173 | Cherry Hill Lots | 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]);