units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,440 rows where DES_TP = 3 and MNG_AG_TYP = 2 sorted by AGNCY_LEV descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_TYP, LAYER
MNG_AGENCY >30
- San Diego, City of 211
- Los Angeles, City of 116
- San Francisco, City and County of 80
- San Luis Obispo, City of 26
- Long Beach, City of 25
- Glendale, City of 24
- Davis, City of 23
- Santa Clarita, City of 18
- Sacramento, City of 18
- San Jose, City of 17
- Vacaville, City of 17
- Oakland, City of 16
- Thousand Oaks, City of 16
- Fullerton, City of 15
- Santa Cruz, City of 14
- San Bernardino, City of 14
- San Marcos, City of 14
- Tiburon, Town of 13
- Carlsbad, City of 12
- Poway, City of 12
- Mission Viejo, City of 11
- Fresno, City of 10
- Oceanside, City of 10
- Riverside, City of 9
- Irvine, City of 9
- Roseville, City of 9
- Santa Barbara, City of 8
- South San Francisco, City of 8
- Escondido, City of 8
- Chico, City of 8
- …
ACCESS_TYP 4
- Open Access 1,226
- Restricted Access 168
- No Public Access 40
- Unknown Access 6
MNG_AG_TYP 1
- City Agency · 1,440 ✖
DES_TP 1
- Local Recreation Area · 1,440 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3526 | 3526 | 3525 | {"type": "Polygon", "coordinates": [[[-118.11099, 33.9097], [-118.1104, 33.90972], [-118.10973, 33.90773], [-118.11031, 33.90763], [-118.11099, 33.9097]]]} | Open Access 1 | 20596 | H. Byrum Zinn Community Park and Trail | 29571 | 6073 | Southern California Edison 655 | Private 7 | Utility 21 | https://www.sce.com | Private 14 | 1024 | Bellflower, City of 443 | City 2 | City Agency 2 | Los Angeles 6 | 3.096 | H. Byrum Zinn Community Park and Trail | 0 | Local Recreation Area 3 | 4 | |
4801 | 4801 | 4800 | {"type": "Polygon", "coordinates": [[[-121.13503, 36.22044], [-121.13428, 36.22083], [-121.13391, 36.22026], [-121.13345, 36.21979], [-121.13422, 36.2194], [-121.13503, 36.22044]]]} | Open Access 1 | 48509 | CreekBridge Soccer Park | 33221 | 7029 | KB Home Coastal Inc 785 | Private 7 | Commercial 20 | https://www.kbhome.com/ | Private 14 | 1152 | King City, City of 473 | City 2 | City Agency 2 | Monterey 14 | 2.614 | CreekBridge Soccer Park | 0 | Local Recreation Area 3 | 4 | |
13544 | 13544 | 13543 | {"type": "Polygon", "coordinates": [[[-117.63464, 33.44433], [-117.63368, 33.44513], [-117.63359, 33.44529], [-117.63357, 33.44527], [-117.63343, 33.44529], [-117.63333, 33.44533], [-117.63317, 33.44552], [-117.63307, 33.44557], [-117.63301, 33.44552], [-117.63294, 33.44537], [-117.63296, 33.44526], [-117.63278, 33.44448], [-117.63247, 33.44421], [-117.63228, 33.44418], [-117.63214, 33.44405], [-117.63214, 33.444], [-117.63222, 33.44385], [-117.63236, 33.44332], [-117.6324, 33.44296], [-117.63253, 33.44286], [-117.63261, 33.44289], [-117.63314, 33.4433], [-117.63313, 33.44335], [-117.63427, 33.4443], [-117.63438, 33.44434], [-117.63448, 33.44433], [-117.63456, 33.44428], [-117.63464, 33.44433]]]} | Open Access 1 | 48827 | Jim Johnson Memorial Sports Park | 33546 | 6132 | Marblehead Development Partners LLC 1045 | Private 7 | Home Owners Association 16 | Private 14 | 1296 | San Clemente, City of 350 | City 2 | City Agency 2 | https://www.san-clemente.org/Home/Components/FacilityDirectory/FacilityDirectory/187/2783 | Orange 3 | 7.375 | Jim Johnson Memorial Sports Park | 0 | Local Recreation Area 3 | 4 | |
16223 | 16223 | 16222 | {"type": "Polygon", "coordinates": [[[-117.02305, 32.58558], [-117.01876, 32.58555], [-117.01875, 32.58376], [-117.0148, 32.58373], [-117.01465, 32.58363], [-117.01447, 32.58354], [-117.01433, 32.57606], [-117.02242, 32.57628], [-117.0226, 32.57717], [-117.02239, 32.57718], [-117.02228, 32.57717], [-117.02221, 32.57699], [-117.02213, 32.57694], [-117.02176, 32.5769], [-117.02167, 32.57671], [-117.02153, 32.5766], [-117.02143, 32.57654], [-117.02118, 32.57659], [-117.02096, 32.57669], [-117.02085, 32.57684], [-117.02075, 32.57687], [-117.02063, 32.57685], [-117.02049, 32.57678], [-117.02041, 32.57685], [-117.02001, 32.57685], [-117.01955, 32.57696], [-117.01934, 32.57699], [-117.01923, 32.57693], [-117.01911, 32.57693], [-117.01877, 32.57699], [-117.01863, 32.57698], [-117.01838, 32.57678], [-117.01823, 32.57676], [-117.01815, 32.57677], [-117.01807, 32.57664], [-117.01786, 32.57655], [-117.01771, 32.57645], [-117.01764, 32.57652], [-117.01738, 32.57666], [-117.01729, 32.57688], [-117.01729, 32.57695], [-117.01734, 32.57704], [-117.01734, 32.57712], [-117.01724, 32.57724], [-117.01741, 32.57755], [-117.01742, 32.57766], [-117.01757, 32.57781], [-117.01759, 32.5779], [-117.01753, 32.57802], [-117.01754, 32.57808], [-117.01758, 32.57815], [-117.01753, 32.5783], [-117.01751, 32.57859], [-117.01752, 32.57881], [-117.01758, 32.579], [-117.01765, 32.57912], [-117.01759, 32.57929], [-117.0176, 32.57938], [-117.01768, 32.57961], [-117.01774, 32.57987], [-117.01776, 32.58027], [-117.01773, 32.58054], [-117.01774, 32.5806], [-117.01785, 32.58072], [-117.01788, 32.58097], [-117.01792, 32.58102], [-117.01836, 32.58133], [-117.01845, 32.58134], [-117.01871, 32.58129], [-117.01878, 32.58128], [-117.01886, 32.58129], [-117.01895, 32.58138], [-117.019, 32.58147], [-117.01903, 32.58159], [-117.01898, 32.58167], [-117.01891, 32.58169], [-117.01868, 32.58167], [-117.01861, 32.5817], [-117.01852, 32.58188], [-117.01845, 32.58196], [-117.0184, 32.58238], [-117.01849, 32.58265], [-117.01846, 32.58281], [-117.0184, 32.58286], [-117.01873, 32.58324], [-117.0189, 32.58348], [-117.01924, 32.58413], [-117.01932, 32.58433], [-117.01953, 32.58434], [-117.01997, 32.58424], [-117.02013, 32.58427], [-117.02021, 32.58425], [-117.02029, 32.58418], [-117.02055, 32.58382], [-117.02049, 32.58355], [-117.02039, 32.58323], [-117.02075, 32.58311], [-117.02081, 32.58306], [-117.02092, 32.58288], [-117.02094, 32.58281], [-117.02117, 32.58292], [-117.02149, 32.58274], [-117.0214, 32.58198], [-117.0211, 32.58161], [-117.02126, 32.58163], [-117.02136, 32.58158], [-117.02176, 32.58159], [-117.02191, 32.58155], [-117.0221, 32.58145], [-117.02217, 32.58145], [-117.02223, 32.58147], [-117.02224, 32.58151], [-117.0222, 32.58163], [-117.02222, 32.58164], [-117.02267, 32.5816], [-117.023, 32.58154], [-117.02305, 32.58379], [-117.02305, 32.58558]]]} | Open Access 1 | 44861 | Hidden Trails Open Space | 31665 | 6075 | Western Pacific Housing 1167 | Private 7 | Commercial 20 | Private 14 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 106.609 | Hidden Trails OS | 0 | Local Recreation Area 3 | 4 | ||
16909 | 16909 | 16908 | {"type": "Polygon", "coordinates": [[[-118.77815, 34.14346], [-118.77784, 34.14376], [-118.77784, 34.14381], [-118.77752, 34.14415], [-118.77741, 34.14423], [-118.77726, 34.14428], [-118.77716, 34.14429], [-118.77696, 34.14427], [-118.77668, 34.14417], [-118.77653, 34.1441], [-118.7765, 34.14407], [-118.77656, 34.14399], [-118.77656, 34.14391], [-118.7765, 34.14383], [-118.7764, 34.1438], [-118.77667, 34.14384], [-118.7767, 34.14377], [-118.77664, 34.14368], [-118.77673, 34.14333], [-118.77709, 34.14327], [-118.77735, 34.14256], [-118.77759, 34.14262], [-118.77779, 34.14302], [-118.77815, 34.14346]]]} | Open Access 1 | 46240 | Agoura Hills Recreation and Event Center | 29519 | 3364 | Joni and Friends 1181 | Non Profit 6 | Non Profit - Other 22 | http://www.joniandfriends.org/ | Non Governmental Organization 10 | 1000 | Agoura Hills, City of 316 | City 2 | City Agency 2 | http://www.ci.agoura-hills.ca.us/government/departments/community-services-parks-recreation/parks-facilities/agoura-hills-recreation-center | Los Angeles 6 | 3.899 | Agoura Hills Rec. and Event Ctr. | 0 | Local Recreation Area 3 | 4 |
4160 | 4160 | 4159 | {"type": "Polygon", "coordinates": [[[-120.88662, 35.44856], [-120.88637, 35.45027], [-120.88645, 35.45032], [-120.88642, 35.4505], [-120.88586, 35.45105], [-120.88586, 35.45146], [-120.88525, 35.45142], [-120.88432, 35.45064], [-120.88407, 35.45064], [-120.88393, 35.45085], [-120.88399, 35.45208], [-120.88455, 35.45256], [-120.88418, 35.45304], [-120.88415, 35.45371], [-120.8839, 35.45439], [-120.88401, 35.45467], [-120.88424, 35.45492], [-120.88421, 35.45504], [-120.88376, 35.45517], [-120.88362, 35.45533], [-120.8834, 35.45535], [-120.88331, 35.45503], [-120.88303, 35.45467], [-120.88301, 35.45368], [-120.88275, 35.45334], [-120.88275, 35.45295], [-120.88194, 35.45233], [-120.88186, 35.45206], [-120.88152, 35.45174], [-120.88105, 35.4519], [-120.88038, 35.45242], [-120.87968, 35.45347], [-120.8799, 35.45437], [-120.87906, 35.45428], [-120.87895, 35.45419], [-120.87878, 35.45309], [-120.87901, 35.45229], [-120.8792, 35.45201], [-120.87923, 35.45156], [-120.87886, 35.45137], [-120.87705, 35.45132], [-120.87688, 35.45142], [-120.87671, 35.45221], [-120.87649, 35.45251], [-120.87599, 35.4526], [-120.87548, 35.45263], [-120.87517, 35.45288], [-120.87456, 35.45298], [-120.87445, 35.45309], [-120.87433, 35.45364], [-120.87372, 35.45389], [-120.87347, 35.4538], [-120.87299, 35.45394], [-120.8728, 35.45449], [-120.87207, 35.45554], [-120.87193, 35.45584], [-120.87196, 35.45686], [-120.87224, 35.45712], [-120.87232, 35.45737], [-120.8721, 35.45788], [-120.87235, 35.45902], [-120.87246, 35.45911], [-120.87235, 35.45989], [-120.87221, 35.46014], [-120.8721, 35.46064], [-120.87196, 35.4608], [-120.87199, 35.46101], [-120.87249, 35.46145], [-120.8728, 35.46193], [-120.87275, 35.46245], [-120.87213, 35.46328], [-120.87213, 35.46352], [-120.87255, 35.46362], [-120.87263, 35.46371], [-120.87263, 35.46422], [-120.87247, 35.46431], [-120.8718, 35.46419], [-120.87138, 35.4638], [-120.87124, 35.46378], [-120.8704, 35.46435], [-120.87003, 35.46447], [-120.86979, 35.46441], [-120.86964, 35.46413], [-120.86987, 35.46408], [-120.87003, 35.46392], [-120.87006, 35.46374], [-120.86975, 35.4636], [-120.86953, 35.46305], [-120.86969, 35.46262], [-120.8695, 35.46245], [-120.86955, 35.46099], [-120.87, 35.46051], [-120.87003, 35.45989], [-120.86905, 35.459], [-120.86894, 35.45849], [-120.86849, 35.45829], [-120.86804, 35.45776], [-120.86782, 35.45758], [-120.86734, 35.45756], [-120.86703, 35.45772], [-120.86684, 35.45771], [-120.86687, 35.45751], [-120.86698, 35.45737], [-120.86748, 35.45714], [-120.86776, 35.45671], [-120.86785, 35.45618], [-120.8681, 35.45584], [-120.86874, 35.45584], [-120.86899, 35.45561], [-120.86924, 35.4549], [-120.86924, 35.45431], [-120.86905, 35.4541], [-120.86905, 35.45373], [-120.86924, 35.45339], [-120.86941, 35.45215], [-120.86997, 35.45099], [-120.87061, 35.45085], [-120.87114, 35.45041], [-120.87226, 35.4489], [-120.87237, 35.44762], [-120.87251, 35.44739], [-120.87324, 35.44691], [-120.87374, 35.44675], [-120.87486, 35.44663], [-120.87562, 35.44682], [-120.87599, 35.44713], [-120.87683, 35.44766], [-120.87803, 35.44766], [-120.8787, 35.44789], [-120.87918, 35.44787], [-120.87965, 35.44771], [-120.88021, 35.44775], [-120.88192, 35.44819], [-120.8827, 35.44819], [-120.88343, 35.44796], [-120.88662, 35.44856]]]} | Restricted Access 2 | 44743 | Whale Rock Reservoir | 27446 | 207 | California Department of Water Resources 477 | State 5 | State Agency 5 | http://www.water.ca.gov/ | Other State 5 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | San Luis Obispo 1 | 282.826 | Whale Rock Reservoir | 0 | Local Recreation Area 3 | 4 | |
6410 | 6410 | 6409 | {"type": "MultiPolygon", "coordinates": [[[[-120.85781, 35.47038], [-120.8576, 35.47052], [-120.85741, 35.47067], [-120.85723, 35.47086], [-120.8571, 35.47104], [-120.85699, 35.47122], [-120.85691, 35.47142], [-120.85681, 35.47178], [-120.85678, 35.47199], [-120.85565, 35.47199], [-120.85497, 35.47201], [-120.85379, 35.47197], [-120.8534, 35.47197], [-120.85344, 35.47036], [-120.85781, 35.47038]]], [[[-120.86826, 35.4694], [-120.86824, 35.47331], [-120.85682, 35.47326], [-120.85741, 35.47321], [-120.85761, 35.47316], [-120.85778, 35.47306], [-120.85828, 35.47261], [-120.85842, 35.47254], [-120.85857, 35.4725], [-120.85953, 35.47248], [-120.86111, 35.47272], [-120.86124, 35.47273], [-120.86386, 35.47235], [-120.86401, 35.47228], [-120.86412, 35.4722], [-120.86534, 35.47097], [-120.86548, 35.47086], [-120.86571, 35.47079], [-120.86695, 35.4706], [-120.8672, 35.47052], [-120.86744, 35.47039], [-120.86758, 35.47029], [-120.86772, 35.47015], [-120.86816, 35.46951], [-120.86826, 35.4694]]], [[[-120.88945, 35.45158], [-120.88818, 35.45144], [-120.88838, 35.45703], [-120.88624, 35.45705], [-120.88624, 35.4588], [-120.88128, 35.45883], [-120.87823, 35.46], [-120.87683, 35.45728], [-120.87511, 35.45676], [-120.87526, 35.46117], [-120.8775, 35.46112], [-120.87771, 35.46723], [-120.87532, 35.46729], [-120.87531, 35.4673], [-120.87557, 35.47469], [-120.87588, 35.47622], [-120.87722, 35.47508], [-120.87721, 35.47908], [-120.8759, 35.47975], [-120.87565, 35.47989], [-120.87539, 35.47989], [-120.87537, 35.47973], [-120.87514, 35.47898], [-120.87509, 35.47819], [-120.87504, 35.47807], [-120.87487, 35.47783], [-120.87482, 35.47768], [-120.87482, 35.47754], [-120.87491, 35.47734], [-120.87494, 35.47718], [-120.87493, 35.47704], [-120.87487, 35.47688], [-120.87474, 35.47671], [-120.87457, 35.47659], [-120.87438, 35.47654], [-120.87411, 35.47653], [-120.87405, 35.47651], [-120.874, 35.47647], [-120.87384, 35.47606], [-120.87366, 35.47572], [-120.87348, 35.47545], [-120.8729, 35.47469], [-120.87233, 35.47337], [-120.87221, 35.47316], [-120.87208, 35.47299], [-120.87195, 35.47286], [-120.87108, 35.47216], [-120.87052, 35.47141], [-120.87047, 35.47132], [-120.87046, 35.47124], [-120.87035, 35.46989], [-120.8703, 35.46968], [-120.87019, 35.46948], [-120.87003, 35.46929], [-120.86978, 35.46912], [-120.86953, 35.46901], [-120.86934, 35.46897], [-120.86918, 35.46895], [-120.86892, 35.46896], [-120.86862, 35.46902], [-120.86835, 35.46914], [-120.86819, 35.46926], [-120.86805, 35.4694], [-120.86762, 35.47002], [-120.86752, 35.47013], [-120.86733, 35.47029], [-120.8671, 35.47041], [-120.86682, 35.47049], [-120.86564, 35.47066], [-120.86539, 35.47075], [-120.86521, 35.47088], [-120.86402, 35.47209], [-120.86392, 35.47217], [-120.86379, 35.47222], [-120.86123, 35.47259], [-120.86113, 35.47259], [-120.85956, 35.47235], [-120.85857, 35.47236], [-120.85837, 35.47241], [-120.85818, 35.4725], [-120.85766, 35.47296], [-120.85755, 35.47303], [-120.85738, 35.47308], [-120.85686, 35.47312], [-120.85691, 35.47285], [-120.85694, 35.47257], [-120.85694, 35.47207], [-120.85696, 35.4719], [-120.85707, 35.47146], [-120.85718, 35.47122], [-120.85734, 35.47097], [-120.85759, 35.47071], [-120.85783, 35.47054], [-120.85806, 35.47042], [-120.85832, 35.47032], [-120.85864, 35.47026], [-120.8589, 35.47024], [-120.85915, 35.47025], [-120.86032, 35.47052], [-120.86065, 35.47058], [-120.86112, 35.4706], [-120.86141, 35.47058], [-120.86171, 35.47054], [-120.86194, 35.47047], [-120.86212, 35.47039], [-120.86231, 35.47027], [-120.86245, 35.47014], [-120.86254, 35.47002], [-120.86269, 35.46954], [-120.86271, 35.46939], [-120.86271, 35.46928], [-120.86268, 35.46913], [-120.86264, 35.469], [-120.86251, 35.46881], [-120.86227, 35.46857], [-120.86216, 35.46842], [-120.86209, 35.46828], [-120.86204, 35.46809], [-120.86203, 35.46792], [-120.86206, 35.46778], [-120.86233, 35.46702], [-120.86237, 35.46683], [-120.86238, 35.4667], [-120.86236, 35.46654], [-120.86228, 35.46627], [-120.86219, 35.46612], [-120.8621, 35.466], [-120.85959, 35.46311], [-120.85948, 35.46296], [-120.85933, 35.46265], [-120.85926, 35.46246], [-120.85924, 35.46231], [-120.85923, 35.46197], [-120.85927, 35.46173], [-120.86041, 35.45914], [-120.86057, 35.45894], [-120.8615, 35.45803], [-120.86159, 35.4579], [-120.86191, 35.45736], [-120.86203, 35.45721], [-120.86221, 35.45707], [-120.86294, 35.45662], [-120.86308, 35.45652], [-120.86421, 35.45532], [-120.86577, 35.45403], [-120.86593, 35.45386], [-120.86605, 35.4537], [-120.86614, 35.4535], [-120.86668, 35.45126], [-120.86676, 35.45107], [-120.86688, 35.45089], [-120.86819, 35.44942], [-120.86849, 35.44915], [-120.8689, 35.4489], [-120.86862, 35.44885], [-120.86915, 35.44846], [-120.86948, 35.44897], [-120.86973, 35.449], [-120.87005, 35.44868], [-120.87066, 35.44904], [-120.8713, 35.44837], [-120.87072, 35.448], [-120.87483, 35.44385], [-120.87733, 35.44296], [-120.87844, 35.44296], [-120.88138, 35.44564], [-120.88726, 35.44384], [-120.88744, 35.44401], [-120.88666, 35.44476], [-120.88671, 35.44593], [-120.88675, 35.44609], [-120.88685, 35.44609], [-120.88701, 35.44604], [-120.88715, 35.44596], [-120.88727, 35.44585], [-120.88734, 35.4457], [-120.88738, 35.44549], [-120.88738, 35.44535], [-120.88743, 35.44522], [-120.88749, 35.44511], [-120.88773, 35.44489], [-120.8882, 35.44523], [-120.88945, 35.45158]], [[-120.88637, 35.45027], [-120.88661, 35.44856], [-120.88343, 35.44796], [-120.8827, 35.44819], [-120.88192, 35.44819], [-120.88021, 35.44775], [-120.87965, 35.44771], [-120.87918, 35.44787], [-120.8787, 35.44789], [-120.87803, 35.44766], [-120.87683, 35.44766], [-120.87599, 35.44713], [-120.87562, 35.44682], [-120.87486, 35.44663], [-120.87374, 35.44675], [-120.87324, 35.44691], [-120.87251, 35.44739], [-120.87237, 35.44762], [-120.87226, 35.4489], [-120.87114, 35.45041], [-120.87061, 35.45085], [-120.86997, 35.45099], [-120.86941, 35.45215], [-120.86924, 35.45339], [-120.86905, 35.45373], [-120.86905, 35.4541], [-120.86924, 35.4543], [-120.86924, 35.4549], [-120.86899, 35.45561], [-120.86874, 35.45584], [-120.86809, 35.45584], [-120.86785, 35.45618], [-120.86776, 35.45671], [-120.86748, 35.45714], [-120.86698, 35.45737], [-120.86687, 35.45751], [-120.86684, 35.4577], [-120.86685, 35.45772], [-120.86703, 35.45772], [-120.86734, 35.45756], [-120.86782, 35.45758], [-120.86804, 35.45776], [-120.86849, 35.45829], [-120.86894, 35.45849], [-120.86905, 35.459], [-120.87003, 35.45989], [-120.87, 35.46051], [-120.86955, 35.46099], [-120.8695, 35.46245], [-120.86969, 35.46261], [-120.86953, 35.46305], [-120.86975, 35.4636], [-120.87006, 35.46374], [-120.87003, 35.46392], [-120.86987, 35.46408], [-120.86965, 35.46413], [-120.86979, 35.46441], [-120.87003, 35.46447], [-120.87039, 35.46435], [-120.87124, 35.46378], [-120.87137, 35.4638], [-120.8718, 35.46419], [-120.87247, 35.46431], [-120.87263, 35.46421], [-120.87263, 35.46371], [-120.87255, 35.46362], [-120.87213, 35.46353], [-120.87213, 35.46328], [-120.87275, 35.46245], [-120.8728, 35.46193], [-120.87249, 35.46145], [-120.87199, 35.46101], [-120.87196, 35.4608], [-120.8721, 35.46064], [-120.87221, 35.46014], [-120.87235, 35.45989], [-120.87246, 35.45911], [-120.87235, 35.45902], [-120.8721, 35.45787], [-120.87232, 35.45737], [-120.87224, 35.45712], [-120.87196, 35.45687], [-120.87193, 35.45584], [-120.87207, 35.45554], [-120.8728, 35.45449], [-120.87299, 35.45394], [-120.87347, 35.4538], [-120.87372, 35.45389], [-120.87433, 35.45364], [-120.87445, 35.45309], [-120.87456, 35.45298], [-120.87517, 35.45288], [-120.87548, 35.45263], [-120.87599, 35.4526], [-120.87649, 35.45251], [-120.87671, 35.45221], [-120.87688, 35.45141], [-120.87705, 35.45132], [-120.87887, 35.45137], [-120.87923, 35.45155], [-120.8792, 35.45201], [-120.87901, 35.45229], [-120.87878, 35.45309], [-120.87895, 35.45419], [-120.87906, 35.45428], [-120.87989, 35.45436], [-120.87968, 35.45347], [-120.88038, 35.45242], [-120.88105, 35.4519], [-120.88152, 35.45174], [-120.88186, 35.45206], [-120.88195, 35.45233], [-120.88275, 35.45295], [-120.88275, 35.45334], [-120.88301, 35.45368], [-120.88303, 35.45467], [-120.88331, 35.45503], [-120.8834, 35.45535], [-120.88362, 35.45533], [-120.88376, 35.45517], [-120.88421, 35.45503], [-120.88423, 35.45492], [-120.88401, 35.45467], [-120.8839, 35.4544], [-120.88415, 35.45371], [-120.88418, 35.45304], [-120.88454, 35.45256], [-120.88399, 35.45208], [-120.88393, 35.45085], [-120.88407, 35.45064], [-120.88432, 35.45064], [-120.88525, 35.45142], [-120.88585, 35.45146], [-120.88586, 35.45105], [-120.88642, 35.4505], [-120.88645, 35.45032], [-120.88637, 35.45027]]], [[[-120.86618, 35.45263], [-120.86596, 35.4535], [-120.8659, 35.45364], [-120.86578, 35.4538], [-120.86565, 35.45393], [-120.8641, 35.45522], [-120.86296, 35.45642], [-120.86284, 35.45652], [-120.86209, 35.45697], [-120.86188, 35.45714], [-120.86175, 35.45731], [-120.86143, 35.45786], [-120.86135, 35.45797], [-120.86044, 35.45885], [-120.86029, 35.45902], [-120.8602, 35.45918], [-120.85971, 35.4603], [-120.85972, 35.45707], [-120.86166, 35.45708], [-120.86208, 35.45655], [-120.86321, 35.45569], [-120.86444, 35.45449], [-120.86519, 35.45416], [-120.86614, 35.45262], [-120.86618, 35.45263]]], [[[-120.87522, 35.47989], [-120.87432, 35.4799], [-120.87421, 35.47782], [-120.87294, 35.47949], [-120.87296, 35.47504], [-120.87333, 35.47552], [-120.87351, 35.47578], [-120.87365, 35.47605], [-120.87383, 35.47648], [-120.87387, 35.47656], [-120.87396, 35.47663], [-120.87406, 35.47666], [-120.87436, 35.47667], [-120.87447, 35.4767], [-120.8746, 35.47679], [-120.87472, 35.47695], [-120.87476, 35.47707], [-120.87477, 35.47718], [-120.87474, 35.47731], [-120.87466, 35.47752], [-120.87465, 35.47772], [-120.87471, 35.47786], [-120.8749, 35.47815], [-120.87493, 35.47823], [-120.87497, 35.47898], [-120.8752, 35.47976], [-120.87522, 35.47989]]], [[[-120.88888, 35.44363], [-120.8874, 35.44494], [-120.8872, 35.44475], [-120.88722, 35.44433], [-120.88762, 35.44398], [-120.88832, 35.4437], [-120.8887, 35.44344], [-120.88888, 35.44363]]]]} | Restricted Access 2 | 1848 | Whale Rock Reservoir | 27446 | 207 | California Department of Water Resources 477 | State 5 | State Agency 5 | http://www.water.ca.gov/ | Other State 5 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | San Luis Obispo 1 | 1098.807 | Whale Rock Reservoir | 0 | Local Recreation Area 3 | 4 | |
1709 | 1709 | 1708 | {"type": "Polygon", "coordinates": [[[-117.75671, 34.13628], [-117.7567, 34.1363], [-117.75036, 34.13633], [-117.75034, 34.13665], [-117.75035, 34.13666], [-117.75656, 34.13663], [-117.75559, 34.13883], [-117.75547, 34.13901], [-117.75533, 34.13918], [-117.75515, 34.13932], [-117.75367, 34.14035], [-117.75356, 34.14041], [-117.75326, 34.14053], [-117.75215, 34.14084], [-117.75214, 34.14092], [-117.75193, 34.14107], [-117.75169, 34.1413], [-117.75165, 34.14129], [-117.75133, 34.14113], [-117.75127, 34.14107], [-117.75121, 34.14102], [-117.7511, 34.141], [-117.7511, 34.14067], [-117.75024, 34.14008], [-117.75024, 34.13986], [-117.74992, 34.13986], [-117.74843, 34.13883], [-117.74818, 34.13785], [-117.7485, 34.13662], [-117.75064, 34.13454], [-117.75064, 34.13451], [-117.75208, 34.13314], [-117.75433, 34.13264], [-117.75616, 34.13503], [-117.75671, 34.13628]]]} | No Public Access 3 | 12846 | Live Oak Reservoir | 21375 | 2078 | Metropolitan Water District of Southern California 413 | Special District 4 | Water District 13 | http://www.mwdh2o.com/ | Special District 4 | 1162 | La Verne, City of 301 | City 2 | City Agency 2 | Los Angeles 6 | 112.516 | Live Oak Reservoir | 0 | Local Recreation Area 3 | 4 | |
2099 | 2099 | 2098 | {"type": "Polygon", "coordinates": [[[-121.94503, 37.73765], [-121.94369, 37.73818], [-121.94322, 37.73744], [-121.94227, 37.7378], [-121.94234, 37.73798], [-121.94192, 37.73811], [-121.94168, 37.73772], [-121.94145, 37.73739], [-121.94426, 37.7363], [-121.9444, 37.73653], [-121.94433, 37.7366], [-121.94433, 37.73668], [-121.94438, 37.73674], [-121.94449, 37.73676], [-121.94503, 37.73765]]]} | Restricted Access 2 | 47569 | Pine Valley Middle School Parks and Community Gym | 31294 | 2309 | San Ramon Valley Unified School District 478 | Special District 4 | School District 14 | http://www.srvusd.net/ | Special District 4 | 1313 | San Ramon, City of 68 | City 2 | City Agency 2 | Contra Costa 12 | 8.075 | Pine Valley Middle School Parks and Community Gym | 0 | Local Recreation Area 3 | 4 | |
2710 | 2710 | 2709 | {"type": "Polygon", "coordinates": [[[-118.17189, 33.79348], [-118.17189, 33.79369], [-118.17147, 33.79396], [-118.17068, 33.79345], [-118.17083, 33.79329], [-118.17083, 33.79327], [-118.16931, 33.79229], [-118.16929, 33.79021], [-118.17188, 33.79021], [-118.17189, 33.79321], [-118.17163, 33.79322], [-118.17163, 33.79347], [-118.17189, 33.79348]]]} | Open Access 1 | 6683 | Chittick Field | 29942 | 2272 | Los Angeles County Flood Control District 287 | Special District 4 | Flood District 8 | http://dpw.lacounty.gov/lacfcd/ | Special District 4 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 19.452 | Chittick Field | 2014 | Local Recreation Area 3 | 4 | |
2890 | 2890 | 2889 | {"type": "Polygon", "coordinates": [[[-121.39678, 36.84126], [-121.39678, 36.84159], [-121.39616, 36.84157], [-121.39614, 36.84183], [-121.39515, 36.8418], [-121.39507, 36.842], [-121.39507, 36.84215], [-121.39527, 36.84217], [-121.39527, 36.84247], [-121.39543, 36.84248], [-121.39542, 36.84336], [-121.39404, 36.84334], [-121.39252, 36.84106], [-121.39624, 36.84113], [-121.39633, 36.8412], [-121.39644, 36.84126], [-121.39678, 36.84126]]]} | Restricted Access 2 | 18924 | Rancho San Justo Sports Complex | 32730 | 2425 | Hollister School District 561 | Special District 4 | School District 14 | https://www.hesd.org/ | Special District 4 | 1138 | Hollister, City of 196 | City 2 | City Agency 2 | San Benito 38 | 13.179 | Rancho San Justo Sports Complex | 0 | Local Recreation Area 3 | 4 | |
4411 | 4411 | 4410 | {"type": "Polygon", "coordinates": [[[-118.35352, 34.18058], [-118.3535, 34.18106], [-118.35346, 34.18107], [-118.35306, 34.18107], [-118.35307, 34.18057], [-118.35352, 34.18058]]]} | Restricted Access 2 | 46266 | Maple Street Playground | 31626 | 2391 | Burbank Unified School District 759 | Special District 4 | School District 14 | http://www.burbankusd.org/ | Special District 4 | 1038 | Burbank, City of 135 | City 2 | City Agency 2 | http://www.burbankca.gov/departments/parks-and-recreation/parks-facilities/maple-street-playground | Los Angeles 6 | 0.55 | Maple Street Playground | 0 | Local Recreation Area 3 | 4 |
5739 | 5739 | 5738 | {"type": "Polygon", "coordinates": [[[-117.86368, 33.71492], [-117.86366, 33.71591], [-117.86257, 33.71591], [-117.86257, 33.715], [-117.86248, 33.71499], [-117.86248, 33.71487], [-117.86359, 33.71488], [-117.86359, 33.71492], [-117.86368, 33.71492]]]} | Restricted Access 2 | 47437 | Monroe Elementary School Field | 31153 | 2308 | Santa Ana Unified School District 816 | Special District 4 | School District 14 | http://www.sausd.us/site/default.aspx?PageID=1 | Special District 4 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | Orange 3 | 2.918 | Monroe Elementary School Field | 0 | Local Recreation Area 3 | 4 | |
5740 | 5740 | 5739 | {"type": "Polygon", "coordinates": [[[-117.90815, 33.749], [-117.90761, 33.74987], [-117.90711, 33.75063], [-117.9066, 33.75137], [-117.9061, 33.75206], [-117.90563, 33.75177], [-117.9056, 33.75179], [-117.90382, 33.75069], [-117.90435, 33.74984], [-117.90502, 33.75014], [-117.90503, 33.75021], [-117.90483, 33.75055], [-117.90576, 33.75095], [-117.90624, 33.75015], [-117.90651, 33.75028], [-117.90653, 33.75028], [-117.90651, 33.74904], [-117.90667, 33.74904], [-117.90668, 33.74906], [-117.90714, 33.74906], [-117.90715, 33.74901], [-117.90815, 33.749]]]} | Restricted Access 2 | 47438 | Spurgeon Intermediate School Field | 31154 | 2308 | Santa Ana Unified School District 816 | Special District 4 | School District 14 | http://www.sausd.us/site/default.aspx?PageID=1 | Special District 4 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | Orange 3 | 12.376 | Spurgeon Intermediate School Field | 0 | Local Recreation Area 3 | 4 | |
6317 | 6317 | 6316 | {"type": "Polygon", "coordinates": [[[-117.28211, 34.15967], [-117.28207, 34.15968], [-117.28207, 34.16048], [-117.28042, 34.16048], [-117.28041, 34.16006], [-117.28015, 34.16006], [-117.28015, 34.15949], [-117.28008, 34.15948], [-117.28007, 34.15884], [-117.2821, 34.15884], [-117.28211, 34.15967]]]} | Restricted Access 2 | 47434 | Golden Valley School Field | 31151 | 2314 | San Bernardino City Unified School District 832 | Special District 4 | School District 14 | http://www.sbcusd.k12.ca.us/ | Special District 4 | 1293 | San Bernardino, City of 163 | City 2 | City Agency 2 | San Bernardino 22 | 7.872 | Golden Valley School Field | 0 | Local Recreation Area 3 | 4 | |
6328 | 6328 | 6327 | {"type": "Polygon", "coordinates": [[[-117.89836, 33.72183], [-117.8983, 33.72317], [-117.89797, 33.72315], [-117.89796, 33.72316], [-117.89797, 33.72355], [-117.89832, 33.72355], [-117.89835, 33.72428], [-117.8943, 33.72425], [-117.8943, 33.72338], [-117.89435, 33.72295], [-117.89452, 33.72237], [-117.89471, 33.72195], [-117.89481, 33.72179], [-117.89488, 33.72177], [-117.89525, 33.72176], [-117.89683, 33.72176], [-117.897, 33.72177], [-117.89752, 33.72184], [-117.89836, 33.72183]]]} | Restricted Access 2 | 47436 | Valley High School Field | 31152 | 2308 | Santa Ana Unified School District 816 | Special District 4 | School District 14 | http://www.sausd.us/site/default.aspx?PageID=1 | Special District 4 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | Orange 3 | 24.28 | Valley High School Field | 0 | Local Recreation Area 3 | 4 | |
6335 | 6335 | 6334 | {"type": "Polygon", "coordinates": [[[-117.91058, 33.72179], [-117.91047, 33.72176], [-117.91041, 33.72186], [-117.91048, 33.72189], [-117.91044, 33.72198], [-117.91045, 33.722], [-117.91032, 33.72232], [-117.91024, 33.72234], [-117.91017, 33.72238], [-117.91007, 33.72251], [-117.90997, 33.7225], [-117.90995, 33.72254], [-117.90986, 33.72251], [-117.90986, 33.72247], [-117.90977, 33.72248], [-117.9096, 33.72254], [-117.90953, 33.72264], [-117.90952, 33.72269], [-117.9094, 33.72266], [-117.90937, 33.72271], [-117.90927, 33.7227], [-117.90916, 33.72291], [-117.90914, 33.72327], [-117.90867, 33.72327], [-117.90855, 33.72329], [-117.90838, 33.72335], [-117.90792, 33.72336], [-117.90848, 33.72176], [-117.90871, 33.72179], [-117.90924, 33.72182], [-117.90951, 33.72176], [-117.90978, 33.72154], [-117.90996, 33.72132], [-117.91058, 33.72179]]]} | Restricted Access 2 | 47439 | Hector G. Godinez High School Field | 31155 | 2308 | Santa Ana Unified School District 816 | Special District 4 | School District 14 | http://www.sausd.us/site/default.aspx?PageID=1 | Special District 4 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | Orange 3 | 6.664 | Hector G. Godinez High School Field | 0 | Local Recreation Area 3 | 4 | |
6341 | 6341 | 6340 | {"type": "Polygon", "coordinates": [[[-117.84173, 33.89423], [-117.83972, 33.89424], [-117.83966, 33.89199], [-117.8408, 33.89197], [-117.84079, 33.89285], [-117.84024, 33.89286], [-117.84024, 33.89331], [-117.84092, 33.89332], [-117.84092, 33.89378], [-117.84123, 33.89378], [-117.84122, 33.89348], [-117.84171, 33.89348], [-117.84173, 33.89423]]]} | Restricted Access 2 | 47441 | Rose Drive Elementary School Recreational Facilities | 31157 | 2410 | Placentia-Yorba Linda Unified School District 833 | Special District 4 | School District 14 | http://www.pylusd.org/ | Special District 4 | 1384 | Yorba Linda, City of 62 | City 2 | City Agency 2 | Orange 3 | 7.295 | Rose Drive Elementary School Recreational Facilities | 0 | Local Recreation Area 3 | 4 | |
7251 | 7251 | 7250 | {"type": "Polygon", "coordinates": [[[-121.92994, 37.74522], [-121.92625, 37.74667], [-121.92569, 37.74579], [-121.92458, 37.74623], [-121.92512, 37.74711], [-121.92071, 37.74637], [-121.92092, 37.7457], [-121.92094, 37.7455], [-121.92092, 37.74535], [-121.921, 37.74482], [-121.9211, 37.7447], [-121.9213, 37.74459], [-121.92141, 37.74449], [-121.92146, 37.7444], [-121.92148, 37.74426], [-121.92136, 37.74378], [-121.92055, 37.74282], [-121.9205, 37.74268], [-121.92049, 37.74258], [-121.92053, 37.7422], [-121.92061, 37.74194], [-121.92088, 37.74171], [-121.9209, 37.74166], [-121.92086, 37.74144], [-121.921, 37.74106], [-121.92102, 37.74085], [-121.92096, 37.74024], [-121.92146, 37.73929], [-121.92181, 37.73883], [-121.92232, 37.73901], [-121.92245, 37.73928], [-121.92249, 37.73962], [-121.92256, 37.73977], [-121.92257, 37.73977], [-121.92276, 37.73954], [-121.92277, 37.73957], [-121.92258, 37.73982], [-121.9226, 37.73986], [-121.92258, 37.74002], [-121.9226, 37.74014], [-121.9227, 37.7404], [-121.92283, 37.74054], [-121.92298, 37.74068], [-121.92344, 37.74066], [-121.92396, 37.74073], [-121.92441, 37.74073], [-121.9246, 37.74075], [-121.9248, 37.74079], [-121.92491, 37.74089], [-121.92502, 37.74095], [-121.92519, 37.74109], [-121.92534, 37.74126], [-121.92543, 37.74145], [-121.92548, 37.74167], [-121.92547, 37.74189], [-121.92553, 37.74205], [-121.92563, 37.74213], [-121.92575, 37.74238], [-121.9259, 37.74263], [-121.92617, 37.74292], [-121.92625, 37.74304], [-121.92638, 37.74333], [-121.92669, 37.74351], [-121.92698, 37.74389], [-121.92725, 37.74414], [-121.92715, 37.74428], [-121.92706, 37.74444], [-121.92692, 37.74464], [-121.92691, 37.74469], [-121.92692, 37.74481], [-121.92801, 37.74475], [-121.92843, 37.74481], [-121.92869, 37.74482], [-121.92892, 37.74479], [-121.9294, 37.74467], [-121.92994, 37.74522]]]} | Open Access 1 | 48920 | Dougherty Valley Ridge Trail | 33643 | 2300 | Geologic Hazard Abatement District (San Ramon) 853 | Special District 4 | Special District - Other 26 | http://www.sanramon.ca.gov/engr/ghad.html | Special District 4 | 1313 | San Ramon, City of 68 | City 2 | City Agency 2 | http://www.sanramon.ca.gov/our_city/departments_and_divisions/parks_community_services/trails_open_space/dougherty_valley_ridge_trail | Contra Costa 12 | 89.586 | Dougherty Valley Ridge Trail | 0 | Local Recreation Area 3 | 4 |
7255 | 7255 | 7254 | {"type": "Polygon", "coordinates": [[[-121.92427, 37.74849], [-121.92332, 37.74921], [-121.92193, 37.74844], [-121.91908, 37.7461], [-121.92388, 37.7469], [-121.92427, 37.74849]]]} | Open Access 1 | 48922 | Dougherty Valley Ridge Trail | 33643 | 2031 | East Bay Municipal Utility District 433 | Special District 4 | Water District 13 | http://www.ebmud.com/ | Special District 4 | 1313 | San Ramon, City of 68 | City 2 | City Agency 2 | http://www.sanramon.ca.gov/our_city/departments_and_divisions/parks_community_services/trails_open_space/dougherty_valley_ridge_trail | Contra Costa 12 | 17.382 | Dougherty Valley Ridge Trail | 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]);