units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
126 rows where AGNCY_TYP = 3 and DES_TP = 3 sorted by UNIT_NAME
This data as json, copyable, CSV (advanced)
MNG_AGENCY 26
- Los Angeles, County of 20
- Santa Barbara, County of 17
- Los Angeles - Department of Parks and Recreation, County of 11
- San Diego, County of 6
- Santa Cruz, County of 5
- Riverside, County of 5
- Sacramento, County of 5
- San Luis Obispo, County of 4
- Monterey, County of 4
- Orange, County of 4
- Ventura, County of 4
- Fresno, County of 3
- Placer, County of 2
- Kern, County of 2
- San Joaquin, County of 2
- Stanislaus, County of 2
- Valley-Wide Recreation and Park District 1
- Lake, County of 1
- Desert Recreation District 1
- Torrance, City of 1
- San Bernardino, County of 1
- Yolo, County of 1
- Humboldt, County of 1
- Siskiyou, County of 1
- Amador, County of 1
- Sutter, County of 1
MNG_AG_TYP 4
ACCESS_TYP 4
DES_TP 1
- Local Recreation Area · 106 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6739 | 6739 | 6738 | {"type": "Polygon", "coordinates": [[[-116.1145, 32.65367], [-116.10581, 32.65366], [-116.10581, 32.64737], [-116.10624, 32.6465], [-116.11446, 32.64653], [-116.1145, 32.65367]]]} | Open Access 1 | 5151 | County Open Space | 29240 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | San Diego 4 | 158.984 | County OS | 0 | Local Recreation Area 3 | 4 | |
16112 | 16112 | 16111 | {"type": "Polygon", "coordinates": [[[-121.93713, 36.48166], [-121.93589, 36.48169], [-121.93565, 36.48218], [-121.93525, 36.48195], [-121.93482, 36.48164], [-121.93419, 36.48187], [-121.93391, 36.48199], [-121.93358, 36.48189], [-121.93342, 36.48203], [-121.93338, 36.48229], [-121.93301, 36.48226], [-121.93275, 36.48226], [-121.93231, 36.48216], [-121.93191, 36.48198], [-121.93176, 36.48178], [-121.93152, 36.48157], [-121.93128, 36.48133], [-121.93093, 36.48159], [-121.93042, 36.48151], [-121.92961, 36.48143], [-121.92935, 36.48143], [-121.929, 36.48119], [-121.92854, 36.48094], [-121.92841, 36.48085], [-121.9281, 36.48118], [-121.92781, 36.48121], [-121.92739, 36.48114], [-121.92715, 36.4812], [-121.92708, 36.48092], [-121.92701, 36.48085], [-121.92674, 36.48095], [-121.92636, 36.48143], [-121.92627, 36.48162], [-121.92607, 36.48167], [-121.92587, 36.48128], [-121.92554, 36.48106], [-121.92515, 36.48102], [-121.92488, 36.48087], [-121.92456, 36.48089], [-121.9244, 36.48062], [-121.92422, 36.48052], [-121.9239, 36.48052], [-121.92367, 36.48066], [-121.92325, 36.48067], [-121.92305, 36.48075], [-121.92282, 36.4806], [-121.92245, 36.48067], [-121.92225, 36.48048], [-121.92171, 36.48029], [-121.92126, 36.48027], [-121.9208, 36.48003], [-121.92055, 36.48], [-121.92003, 36.47982], [-121.91977, 36.47967], [-121.91945, 36.47943], [-121.9191, 36.47929], [-121.91882, 36.47951], [-121.91847, 36.47948], [-121.91822, 36.47935], [-121.91808, 36.47913], [-121.91787, 36.47903], [-121.91757, 36.47903], [-121.91711, 36.4787], [-121.91625, 36.4786], [-121.91605, 36.47854], [-121.92713, 36.47357], [-121.9276, 36.47357], [-121.92774, 36.47311], [-121.9288, 36.47271], [-121.93027, 36.47271], [-121.93103, 36.47268], [-121.93147, 36.47258], [-121.93188, 36.47516], [-121.93333, 36.47501], [-121.93331, 36.47464], [-121.93435, 36.47461], [-121.93547, 36.47413], [-121.93627, 36.47837], [-121.93633, 36.47859], [-121.93644, 36.47889], [-121.9369, 36.47982], [-121.93702, 36.48021], [-121.93711, 36.48089], [-121.93713, 36.48134], [-121.93713, 36.48166]]]} | No Public Access 3 | 16442 | County Open Space | 17714 | 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 | 288.367 | County OS | 0 | Local Recreation Area 3 | 4 | |
3643 | 3643 | 3642 | {"type": "Polygon", "coordinates": [[[-117.05646, 34.07589], [-117.05605, 34.07592], [-117.05567, 34.07597], [-117.05538, 34.07542], [-117.05514, 34.07532], [-117.05489, 34.07538], [-117.05484, 34.07531], [-117.0549, 34.07522], [-117.05473, 34.07516], [-117.05384, 34.07497], [-117.05337, 34.07475], [-117.05234, 34.07447], [-117.0519, 34.0745], [-117.05123, 34.07449], [-117.05063, 34.07436], [-117.04996, 34.0743], [-117.0496, 34.07422], [-117.04925, 34.07419], [-117.04869, 34.0742], [-117.04823, 34.07398], [-117.04784, 34.07399], [-117.04771, 34.06692], [-117.04942, 34.06795], [-117.05016, 34.06761], [-117.05061, 34.06565], [-117.04902, 34.06452], [-117.04766, 34.06428], [-117.04763, 34.06268], [-117.05203, 34.06257], [-117.05221, 34.06978], [-117.05643, 34.06979], [-117.05646, 34.07589]]]} | Open Access 1 | 29520 | Crafton Reservoir | 17750 | 318 | San Bernardino, County of 368 | County 3 | County Agency 3 | http://cms.sbcounty.gov/parks/Home.aspx | County 3 | 318 | San Bernardino, County of 363 | County 3 | County Agency 3 | San Bernardino 22 | 168.476 | Crafton Reservoir | 0 | Local Recreation Area 3 | 4 | |
6278 | 6278 | 6277 | {"type": "Polygon", "coordinates": [[[-117.46707, 33.74589], [-117.46683, 33.74759], [-117.46525, 33.74744], [-117.46517, 33.7471], [-117.46503, 33.74677], [-117.46348, 33.7442], [-117.46334, 33.744], [-117.4632, 33.74382], [-117.4632, 33.74376], [-117.46365, 33.74339], [-117.46373, 33.74335], [-117.46383, 33.74332], [-117.46405, 33.74329], [-117.46541, 33.7433], [-117.46601, 33.74403], [-117.46707, 33.74589]]]} | Open Access 1 | 48881 | Deleo Regional Sports Park | 33602 | 315 | Riverside, County of 169 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | https://rivcoccsd.org/new-page-2 | Riverside 10 | 24.913 | Deleo Reg. Sports Park | 0 | Local Recreation Area 3 | 4 |
15670 | 15670 | 15669 | {"type": "MultiPolygon", "coordinates": [[[[-117.82298, 34.00931], [-117.82283, 34.00935], [-117.82285, 34.00942], [-117.82262, 34.00997], [-117.82239, 34.0103], [-117.8221, 34.01066], [-117.82141, 34.01145], [-117.82045, 34.01247], [-117.81939, 34.01369], [-117.81895, 34.01423], [-117.81792, 34.01559], [-117.81716, 34.0165], [-117.81428, 34.01933], [-117.81308, 34.01781], [-117.81286, 34.0177], [-117.81479, 34.01516], [-117.81665, 34.01383], [-117.81651, 34.01257], [-117.81514, 34.01064], [-117.81561, 34.01027], [-117.81631, 34.00983], [-117.82166, 34.00683], [-117.82172, 34.00683], [-117.82176, 34.00685], [-117.82194, 34.0071], [-117.82233, 34.00774], [-117.82252, 34.00813], [-117.82274, 34.00866], [-117.82298, 34.00931]]], [[[-117.82998, 34.00371], [-117.82917, 34.00439], [-117.82774, 34.00547], [-117.82702, 34.00603], [-117.82699, 34.00606], [-117.82701, 34.00608], [-117.82489, 34.00787], [-117.82467, 34.00809], [-117.82428, 34.00843], [-117.82418, 34.00849], [-117.82414, 34.00859], [-117.82372, 34.00894], [-117.82358, 34.00893], [-117.82338, 34.00909], [-117.82333, 34.00903], [-117.82323, 34.0089], [-117.82265, 34.00767], [-117.82228, 34.00704], [-117.82203, 34.00671], [-117.82201, 34.00664], [-117.82205, 34.00659], [-117.82244, 34.00638], [-117.82264, 34.00625], [-117.82287, 34.00606], [-117.82311, 34.00581], [-117.82333, 34.00548], [-117.82391, 34.0044], [-117.82417, 34.00405], [-117.82451, 34.00371], [-117.82484, 34.00346], [-117.825, 34.00336], [-117.82538, 34.00316], [-117.82579, 34.00299], [-117.8264, 34.00283], [-117.82673, 34.00279], [-117.82725, 34.00277], [-117.82757, 34.00278], [-117.82785, 34.00282], [-117.82993, 34.00368], [-117.82998, 34.00371]]]]} | Restricted Access 2 | 7047 | Diamond Bar Golf Course | 32474 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | Los Angeles 6 | 172.308 | Diamond Bar GC | 0 | Local Recreation Area 3 | 4 | |
15149 | 15149 | 15148 | {"type": "Polygon", "coordinates": [[[-117.22985, 33.12069], [-117.22559, 33.1207], [-117.22559, 33.12034], [-117.22632, 33.12033], [-117.2275, 33.11994], [-117.22846, 33.11978], [-117.22826, 33.11881], [-117.22822, 33.11871], [-117.2277, 33.11842], [-117.22665, 33.11804], [-117.22645, 33.11788], [-117.2261, 33.1179], [-117.22608, 33.1176], [-117.22604, 33.11748], [-117.22594, 33.11732], [-117.22574, 33.11714], [-117.22573, 33.11712], [-117.22574, 33.11708], [-117.22579, 33.11704], [-117.22666, 33.11703], [-117.22668, 33.11773], [-117.22982, 33.11772], [-117.22985, 33.12069]]]} | No Public Access 3 | 45992 | Diamond Trail | 29166 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/content/dam/sdc/dpw/WATERSHED_PROTECTION_PROGRAM/Pacific%20Watersheds.pdf | San Diego 4 | 19.749 | Diamond Trail | 0 | Local Recreation Area 3 | 4 |
13896 | 13896 | 13895 | {"type": "Polygon", "coordinates": [[[-120.4206, 34.85883], [-120.42009, 34.85944], [-120.41983, 34.85913], [-120.41982, 34.85851], [-120.42033, 34.85851], [-120.42033, 34.85866], [-120.4206, 34.85883]]]} | Open Access 1 | 36498 | Domino Open Space | 28582 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/parks03.aspx?id=13428 | Santa Barbara 7 | 1.162 | Domino OS | 0 | Local Recreation Area 3 | 4 |
11136 | 11136 | 11135 | {"type": "MultiPolygon", "coordinates": [[[[-121.44491, 38.68324], [-121.4449, 38.68382], [-121.44336, 38.6838], [-121.444, 38.68323], [-121.44491, 38.68324]]], [[[-121.45109, 38.68402], [-121.45214, 38.68404], [-121.45214, 38.68408], [-121.45181, 38.68474], [-121.45132, 38.68505], [-121.45027, 38.68506], [-121.4494, 38.68518], [-121.44928, 38.68525], [-121.44928, 38.68409], [-121.44991, 38.68405], [-121.44992, 38.68395], [-121.45063, 38.68396], [-121.45064, 38.68403], [-121.45109, 38.68402]]], [[[-121.45527, 38.67304], [-121.45483, 38.67456], [-121.45491, 38.6754], [-121.45515, 38.67609], [-121.45465, 38.67721], [-121.45391, 38.67774], [-121.45352, 38.67832], [-121.45274, 38.67905], [-121.45232, 38.68022], [-121.45233, 38.68024], [-121.45455, 38.68026], [-121.45455, 38.68091], [-121.45328, 38.68091], [-121.45328, 38.68116], [-121.45332, 38.6812], [-121.45328, 38.68125], [-121.45328, 38.6813], [-121.45331, 38.68135], [-121.45336, 38.68139], [-121.45333, 38.68144], [-121.45333, 38.6819], [-121.45336, 38.68195], [-121.45329, 38.68201], [-121.45328, 38.68206], [-121.45329, 38.6821], [-121.45322, 38.68215], [-121.45287, 38.68277], [-121.45279, 38.68291], [-121.45262, 38.68342], [-121.45227, 38.68342], [-121.45228, 38.68335], [-121.45251, 38.68275], [-121.45281, 38.68221], [-121.45299, 38.68181], [-121.45293, 38.68113], [-121.45268, 38.68058], [-121.45232, 38.68024], [-121.4516, 38.68023], [-121.45174, 38.68093], [-121.45168, 38.68135], [-121.45132, 38.68204], [-121.45108, 38.68204], [-121.45108, 38.68374], [-121.45041, 38.68375], [-121.4504, 38.68376], [-121.45019, 38.68376], [-121.44998, 38.68378], [-121.44761, 38.68376], [-121.44761, 38.68412], [-121.44866, 38.68412], [-121.44865, 38.68562], [-121.44847, 38.68573], [-121.44781, 38.68606], [-121.44729, 38.68642], [-121.44728, 38.68062], [-121.44629, 38.68061], [-121.44629, 38.68017], [-121.44592, 38.68016], [-121.44592, 38.68009], [-121.44595, 38.68008], [-121.44598, 38.68001], [-121.44609, 38.68005], [-121.44632, 38.68005], [-121.44661, 38.68009], [-121.44728, 38.67919], [-121.44726, 38.66936], [-121.44761, 38.66934], [-121.45314, 38.66939], [-121.45374, 38.6701], [-121.45224, 38.67009], [-121.45223, 38.6712], [-121.44761, 38.67116], [-121.44761, 38.67527], [-121.44819, 38.67476], [-121.45221, 38.6748], [-121.45222, 38.67302], [-121.45527, 38.67304]]], [[[-121.44427, 38.68613], [-121.44224, 38.68776], [-121.44166, 38.68732], [-121.44115, 38.68772], [-121.44115, 38.68774], [-121.44173, 38.68818], [-121.44147, 38.68838], [-121.44089, 38.68794], [-121.44113, 38.68774], [-121.44113, 38.68772], [-121.43843, 38.68768], [-121.43843, 38.68743], [-121.43847, 38.68742], [-121.43847, 38.68713], [-121.43894, 38.68713], [-121.44088, 38.68632], [-121.44218, 38.68731], [-121.44396, 38.6859], [-121.44427, 38.68613]]], [[[-121.44687, 38.68673], [-121.44621, 38.68862], [-121.44608, 38.68884], [-121.44574, 38.68894], [-121.44458, 38.68912], [-121.4426, 38.68764], [-121.44526, 38.68548], [-121.44687, 38.68673]]], [[[-121.44045, 38.68921], [-121.44021, 38.6894], [-121.43963, 38.68895], [-121.43986, 38.68877], [-121.44045, 38.68921]]], [[[-121.44203, 38.68932], [-121.44163, 38.68953], [-121.44094, 38.68901], [-121.44128, 38.68874], [-121.44203, 38.68932]]], [[[-121.43822, 38.68724], [-121.43822, 38.69228], [-121.43819, 38.69228], [-121.43819, 38.69233], [-121.43722, 38.69239], [-121.43717, 38.69191], [-121.43639, 38.69196], [-121.4364, 38.69218], [-121.43615, 38.69221], [-121.43615, 38.6923], [-121.43591, 38.69238], [-121.43611, 38.69267], [-121.43716, 38.69245], [-121.43743, 38.69241], [-121.43819, 38.69238], [-121.43819, 38.6927], [-121.43768, 38.69278], [-121.4371, 38.69282], [-121.43691, 38.69289], [-121.43672, 38.69293], [-121.4365, 38.69302], [-121.43632, 38.69305], [-121.43569, 38.69313], [-121.43511, 38.69314], [-121.43482, 38.69317], [-121.43449, 38.69327], [-121.43418, 38.69341], [-121.43395, 38.6936], [-121.43372, 38.69382], [-121.43324, 38.69405], [-121.43317, 38.69418], [-121.43302, 38.69425], [-121.43289, 38.69438], [-121.43253, 38.69458], [-121.4325, 38.69478], [-121.43216, 38.69516], [-121.432, 38.69522], [-121.43185, 38.69546], [-121.43168, 38.69615], [-121.43136, 38.69636], [-121.42932, 38.698], [-121.42212, 38.69792], [-121.42285, 38.69762], [-121.42348, 38.69742], [-121.42416, 38.69726], [-121.42508, 38.6971], [-121.42564, 38.69695], [-121.4259, 38.69686], [-121.42623, 38.69671], [-121.42667, 38.69649], [-121.42699, 38.6963], [-121.42728, 38.69608], [-121.42767, 38.69571], [-121.42788, 38.69543], [-121.42809, 38.69523], [-121.42833, 38.69495], [-121.42851, 38.69472], [-121.42865, 38.6945], [-121.42879, 38.69433], [-121.42938, 38.69378], [-121.4297, 38.69341], [-121.42989, 38.69315], [-121.43006, 38.69288], [-121.43025, 38.69248], [-121.43034, 38.69217], [-121.43052, 38.69186], [-121.43072, 38.69145], [-121.4308, 38.69134], [-121.43088, 38.69127], [-121.43103, 38.69119], [-121.43142, 38.69107], [-121.43168, 38.69095], [-121.43221, 38.69094], [-121.43283, 38.69085], [-121.43319, 38.69081], [-121.43345, 38.69053], [-121.43377, 38.69038], [-121.43406, 38.69036], [-121.43432, 38.69027], [-121.43462, 38.69007], [-121.43497, 38.68973], [-121.43525, 38.68936], [-121.43549, 38.68891], [-121.43557, 38.68881], [-121.4357, 38.68869], [-121.4359, 38.68854], [-121.43608, 38.68844], [-121.43635, 38.68825], [-121.43669, 38.68806], [-121.43686, 38.68792], [-121.43705, 38.68782], [-121.43788, 38.68725], [-121.43819, 38.68707], [-121.43819, 38.68724], [-121.43822, 38.68724]]], [[[-121.42895, 38.69816], [-121.42895, 38.69827], [-121.42771, 38.69913], [-121.42726, 38.69934], [-121.4268, 38.69949], [-121.42679, 38.69971], [-121.42472, 38.70032], [-121.42453, 38.70043], [-121.42414, 38.70056], [-121.42307, 38.70106], [-121.42281, 38.70097], [-121.42215, 38.70131], [-121.42194, 38.70135], [-121.42179, 38.70141], [-121.42169, 38.70148], [-121.42149, 38.70167], [-121.42125, 38.7018], [-121.42108, 38.70186], [-121.42032, 38.702], [-121.41984, 38.70217], [-121.41983, 38.70339], [-121.41905, 38.7034], [-121.41902, 38.70361], [-121.41822, 38.70358], [-121.41819, 38.70399], [-121.41799, 38.70411], [-121.41777, 38.70426], [-121.41773, 38.70439], [-121.41772, 38.70452], [-121.41805, 38.70469], [-121.41826, 38.70473], [-121.4171, 38.70473], [-121.41631, 38.70551], [-121.4151, 38.706], [-121.41446, 38.70719], [-121.41448, 38.70789], [-121.41438, 38.70818], [-121.41368, 38.70863], [-121.41304, 38.70897], [-121.41165, 38.70945], [-121.41083, 38.70986], [-121.41083, 38.70947], [-121.41147, 38.70911], [-121.41284, 38.70864], [-121.41402, 38.70801], [-121.41417, 38.70784], [-121.41404, 38.70739], [-121.41435, 38.70663], [-121.41485, 38.70577], [-121.41611, 38.70523], [-121.41661, 38.70474], [-121.41195, 38.70471], [-121.41294, 38.70372], [-121.41291, 38.70359], [-121.41408, 38.7031], [-121.4156, 38.70228], [-121.41718, 38.70182], [-121.41774, 38.70158], [-121.41895, 38.70051], [-121.41982, 38.69953], [-121.41982, 38.69806], [-121.42895, 38.69816]]], [[[-121.40388, 38.71424], [-121.40327, 38.71424], [-121.40325, 38.71411], [-121.40335, 38.71383], [-121.40359, 38.71358], [-121.40377, 38.71331], [-121.40377, 38.71302], [-121.4037, 38.71278], [-121.40377, 38.71253], [-121.40387, 38.71253], [-121.40388, 38.71424]]], [[[-121.41101, 38.72869], [-121.4054, 38.72873], [-121.40539, 38.72888], [-121.39797, 38.7289], [-121.39502, 38.72871], [-121.39502, 38.72751], [-121.39442, 38.72751], [-121.39389, 38.72696], [-121.39389, 38.72684], [-121.3945, 38.72685], [-121.39484, 38.72695], [-121.39505, 38.72695], [-121.39575, 38.72665], [-121.39589, 38.72634], [-121.39601, 38.72632], [-121.39612, 38.72647], [-121.3963, 38.72646], [-121.39638, 38.72613], [-121.39656, 38.72613], [-121.39649, 38.72585], [-121.39652, 38.7257], [-121.3971, 38.72568], [-121.3972, 38.72557], [-121.39721, 38.72534], [-121.3973, 38.72525], [-121.39745, 38.72477], [-121.39758, 38.72469], [-121.39757, 38.72468], [-121.39705, 38.72468], [-121.39831, 38.72412], [-121.39832, 38.72337], [-121.3985, 38.72336], [-121.39858, 38.72253], [-121.39937, 38.72148], [-121.40018, 38.72031], [-121.40032, 38.7188], [-121.40025, 38.71827], [-121.40025, 38.71744], [-121.40099, 38.71584], [-121.401, 38.7145], [-121.40329, 38.71451], [-121.4033, 38.71447], [-121.40513, 38.71447], [-121.40514, 38.71451], [-121.40531, 38.71451], [-121.40532, 38.71624], [-121.40516, 38.71628], [-121.40518, 38.71707], [-121.40524, 38.71729], [-121.4065, 38.72098], [-121.41095, 38.72093], [-121.41101, 38.72869]], [[-121.40537, 38.72714], [-121.40541, 38.72708], [-121.40541, 38.72706], [-121.40302, 38.72705], [-121.40297, 38.72795], [-121.40296, 38.72804], [-121.40285, 38.72832], [-121.40285, 38.72846], [-121.40325, 38.72847], [-121.40367, 38.72853], [-121.40397, 38.72853], [-121.40426, 38.72847], [-121.40453, 38.72837], [-121.40476, 38.72822], [-121.40495, 38.72804], [-121.40508, 38.72783], [-121.40519, 38.72745], [-121.40524, 38.72732], [-121.4053, 38.72727], [-121.40537, 38.72714]], [[-121.40477, 38.72424], [-121.40476, 38.72362], [-121.40396, 38.72365], [-121.40398, 38.72355], [-121.4038, 38.72355], [-121.40389, 38.72287], [-121.404, 38.72287], [-121.40403, 38.72266], [-121.40453, 38.72265], [-121.40454, 38.7224], [-121.40384, 38.72237], [-121.40374, 38.72319], [-121.40333, 38.72316], [-121.40332, 38.72324], [-121.40166, 38.72311], [-121.40133, 38.72506], [-121.40307, 38.72516], [-121.40319, 38.72497], [-121.40336, 38.72478], [-121.40347, 38.72462], [-121.4036, 38.72438], [-121.4036, 38.72424], [-121.40399, 38.72424], [-121.40391, 38.72497], [-121.40519, 38.72504], [-121.40521, 38.72425], [-121.40477, 38.72424]]]]} | Open Access 1 | 21416 | Dry Creek Parkway | 9979 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | http://www.regionalparks.saccounty.net/Parks/RegionalParksDetails/Pages/DryCreekParkway.aspx | Sacramento 41 | 749.749 | Dry Creek Parkway | 0 | Local Recreation Area 3 | 4 |
16496 | 16496 | 16495 | {"type": "MultiPolygon", "coordinates": [[[[-118.25943, 33.9168], [-118.25939, 33.91821], [-118.25786, 33.9182], [-118.25785, 33.91879], [-118.25783, 33.91879], [-118.25779, 33.91871], [-118.2577, 33.91867], [-118.25747, 33.9187], [-118.25637, 33.9187], [-118.25635, 33.91868], [-118.25636, 33.91772], [-118.25639, 33.91758], [-118.2566, 33.91695], [-118.25662, 33.91684], [-118.25663, 33.91652], [-118.25665, 33.9165], [-118.25937, 33.91649], [-118.25942, 33.91654], [-118.25943, 33.9168]]], [[[-118.26507, 33.9181], [-118.26506, 33.92099], [-118.26088, 33.92099], [-118.26086, 33.92364], [-118.25652, 33.92364], [-118.25651, 33.92361], [-118.25612, 33.92361], [-118.25612, 33.92103], [-118.25635, 33.92102], [-118.25636, 33.92093], [-118.25939, 33.92093], [-118.2594, 33.92099], [-118.25955, 33.92099], [-118.25957, 33.91649], [-118.26343, 33.91649], [-118.26343, 33.9181], [-118.26507, 33.9181]]]]} | Open Access 1 | 6229 | Earvin 'Magic' Johnson Recreation Area | 32475 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | Los Angeles 6 | 102.9 | Earvin 'Magic' Johnson Rec. Area | 0 | Local Recreation Area 3 | 4 | |
15668 | 15668 | 15667 | {"type": "MultiPolygon", "coordinates": [[[[-118.0811, 34.16216], [-118.08104, 34.16259], [-118.08093, 34.16271], [-118.08087, 34.16287], [-118.08084, 34.16316], [-118.08097, 34.16318], [-118.08058, 34.16641], [-118.08051, 34.16641], [-118.0805, 34.16649], [-118.0805, 34.16684], [-118.08044, 34.16691], [-118.0803, 34.16711], [-118.08014, 34.16749], [-118.08008, 34.16794], [-118.08006, 34.16839], [-118.07996, 34.16874], [-118.07985, 34.16905], [-118.07963, 34.16951], [-118.07945, 34.1698], [-118.07912, 34.17028], [-118.07902, 34.17045], [-118.07896, 34.17062], [-118.07904, 34.17066], [-118.07896, 34.17081], [-118.07893, 34.17095], [-118.07897, 34.17142], [-118.07725, 34.17059], [-118.07677, 34.17044], [-118.07725, 34.1699], [-118.07797, 34.16832], [-118.0781, 34.16829], [-118.07808, 34.16819], [-118.07808, 34.16794], [-118.07801, 34.16776], [-118.07794, 34.16767], [-118.07787, 34.16761], [-118.07781, 34.16756], [-118.07767, 34.1675], [-118.07801, 34.1668], [-118.07807, 34.16683], [-118.0782, 34.16656], [-118.07814, 34.16654], [-118.07852, 34.16519], [-118.07867, 34.16438], [-118.07856, 34.16431], [-118.07863, 34.16427], [-118.07863, 34.16426], [-118.07839, 34.16409], [-118.07851, 34.16358], [-118.07786, 34.16347], [-118.07837, 34.1619], [-118.07982, 34.16188], [-118.07968, 34.16205], [-118.07962, 34.16215], [-118.07954, 34.16241], [-118.07955, 34.16242], [-118.07972, 34.16239], [-118.07977, 34.16221], [-118.07985, 34.16208], [-118.0799, 34.16202], [-118.08007, 34.16188], [-118.08086, 34.16187], [-118.08089, 34.16189], [-118.08089, 34.16192], [-118.08086, 34.16215], [-118.08107, 34.16211], [-118.0811, 34.16216]]], [[[-118.08637, 34.16367], [-118.08296, 34.16371], [-118.08264, 34.16329], [-118.08239, 34.16307], [-118.0822, 34.16294], [-118.08178, 34.1625], [-118.08176, 34.1625], [-118.08174, 34.16273], [-118.08153, 34.16267], [-118.08143, 34.16259], [-118.08137, 34.16259], [-118.0813, 34.16263], [-118.08122, 34.1626], [-118.0812, 34.16255], [-118.08128, 34.16189], [-118.08133, 34.16186], [-118.08539, 34.16181], [-118.08539, 34.16263], [-118.08619, 34.16263], [-118.08637, 34.16367]]]]} | Restricted Access 2 | 6972 | Eaton Canyon Golf Course | 32483 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | Los Angeles 6 | 72.049 | Eaton Canyon GC | 0 | Local Recreation Area 3 | 4 | |
13747 | 13747 | 13746 | {"type": "Polygon", "coordinates": [[[-118.09628, 34.19339], [-118.09212, 34.19355], [-118.09205, 34.19733], [-118.08544, 34.19732], [-118.08551, 34.19363], [-118.08347, 34.19364], [-118.08339, 34.18984], [-118.0877, 34.1898], [-118.0876, 34.18602], [-118.09189, 34.186], [-118.09199, 34.1893], [-118.09196, 34.18935], [-118.09195, 34.1894], [-118.09196, 34.18945], [-118.09199, 34.18949], [-118.09206, 34.19165], [-118.09415, 34.19159], [-118.09411, 34.18973], [-118.09621, 34.18968], [-118.09628, 34.19339]]]} | Open Access 1 | 46244 | Eaton Canyon Open Space | 29522 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 215.911 | Eaton Canyon OS | 0 | Local Recreation Area 3 | 4 | |
3123 | 3123 | 3122 | {"type": "Polygon", "coordinates": [[[-118.41805, 34.31271], [-118.4166, 34.314], [-118.4166, 34.31401], [-118.41582, 34.3146], [-118.41577, 34.31471], [-118.41592, 34.31502], [-118.41611, 34.31503], [-118.41609, 34.31522], [-118.41572, 34.31521], [-118.41572, 34.31529], [-118.41544, 34.31527], [-118.41495, 34.31527], [-118.4138, 34.31568], [-118.41347, 34.31573], [-118.41317, 34.3157], [-118.411, 34.31509], [-118.41012, 34.31425], [-118.41031, 34.31237], [-118.41054, 34.3115], [-118.41012, 34.31103], [-118.41026, 34.31092], [-118.41148, 34.31205], [-118.41155, 34.31189], [-118.4113, 34.31165], [-118.41147, 34.31141], [-118.412, 34.31043], [-118.41191, 34.30973], [-118.41258, 34.3094], [-118.41299, 34.3091], [-118.41356, 34.30864], [-118.4136, 34.30864], [-118.41634, 34.31122], [-118.41805, 34.31271]]]} | Restricted Access 2 | 48023 | El Cariso Golf Course | 32460 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | Los Angeles 6 | 85.199 | El Cariso GC | 0 | Local Recreation Area 3 | 4 | |
6265 | 6265 | 6264 | {"type": "Polygon", "coordinates": [[[-117.53184, 33.83651], [-117.52781, 33.83658], [-117.52781, 33.83602], [-117.52859, 33.836], [-117.52865, 33.83597], [-117.52865, 33.83594], [-117.52861, 33.83541], [-117.52852, 33.83513], [-117.52837, 33.83487], [-117.52794, 33.83501], [-117.52726, 33.83357], [-117.52752, 33.83343], [-117.5276, 33.83344], [-117.52778, 33.83335], [-117.5278, 33.83328], [-117.52925, 33.83254], [-117.53, 33.83352], [-117.53166, 33.83607], [-117.53184, 33.83651]]]} | Open Access 1 | 48877 | El Cerrito Sports Park | 33598 | 315 | Riverside, County of 169 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | https://www.coronaca.gov/Home/Components/FacilityDirectory/FacilityDirectory/95/580 | Riverside 10 | 26.334 | El Cerrito Sports Park | 0 | Local Recreation Area 3 | 4 |
16433 | 16433 | 16432 | {"type": "Polygon", "coordinates": [[[-120.74154, 35.3331], [-120.73974, 35.33628], [-120.73643, 35.3387], [-120.73575, 35.33844], [-120.73517, 35.33868], [-120.73285, 35.3378], [-120.72967, 35.33978], [-120.72435, 35.34033], [-120.72421, 35.34083], [-120.72439, 35.34155], [-120.72495, 35.34214], [-120.72174, 35.3459], [-120.71513, 35.35322], [-120.71224, 35.35091], [-120.72459, 35.32556], [-120.72558, 35.3253], [-120.72633, 35.32599], [-120.72988, 35.32905], [-120.73035, 35.3294], [-120.73084, 35.32971], [-120.73136, 35.33], [-120.73191, 35.33026], [-120.73247, 35.33048], [-120.73305, 35.33067], [-120.73498, 35.33122], [-120.7373, 35.33191], [-120.73941, 35.33243], [-120.74154, 35.3331]]]} | Restricted Access 2 | 14529 | El Chorro Regional Park and Dairy Creek Golf Course | 33039 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | San Luis Obispo 1 | 684.123 | El Chorro RP and Dairy Creek GC | 0 | Local Recreation Area 3 | 4 | |
9316 | 9316 | 9315 | {"type": "Polygon", "coordinates": [[[-119.82494, 34.44682], [-119.82494, 34.44687], [-119.82461, 34.44687], [-119.82461, 34.4471], [-119.82386, 34.4471], [-119.82385, 34.44677], [-119.82334, 34.44673], [-119.82347, 34.44642], [-119.82408, 34.44613], [-119.82404, 34.44586], [-119.82411, 34.44586], [-119.82415, 34.44614], [-119.82474, 34.44618], [-119.82457, 34.4468], [-119.82494, 34.44682]]]} | Open Access 1 | 15524 | Emerald Terrace Open Space | 18619 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 2.426 | Emerald Terrace OS | 0 | Local Recreation Area 3 | 4 | |
6795 | 6795 | 6794 | {"type": "MultiPolygon", "coordinates": [[[[-117.23538, 33.37666], [-117.23537, 33.37797], [-117.23496, 33.37797], [-117.23496, 33.37696], [-117.23431, 33.37695], [-117.23431, 33.37662], [-117.2353, 33.37661], [-117.23535, 33.37663], [-117.23538, 33.37666]]], [[[-117.23748, 33.37662], [-117.23725, 33.37715], [-117.23745, 33.37724], [-117.23724, 33.37765], [-117.23639, 33.37765], [-117.23639, 33.37853], [-117.23556, 33.37853], [-117.23557, 33.37665], [-117.23562, 33.37661], [-117.23748, 33.37662]]]]} | Open Access 1 | 5294 | Fallbrook Park and Community Center | 18835 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/FallbrookCommunityCenter.html | San Diego 4 | 8.565 | Fallbrook Park and Community Ctr. | 0 | Local Recreation Area 3 | 4 |
16641 | 16641 | 16640 | {"type": "Polygon", "coordinates": [[[-121.16941, 38.69857], [-121.16888, 38.69857], [-121.16885, 38.69983], [-121.16707, 38.69983], [-121.16698, 38.69882], [-121.16667, 38.69756], [-121.16679, 38.69664], [-121.16671, 38.69636], [-121.16673, 38.69612], [-121.16755, 38.69261], [-121.16755, 38.69204], [-121.16816, 38.692], [-121.16938, 38.69204], [-121.16946, 38.69624], [-121.16941, 38.69857]]]} | Open Access 1 | 22260 | Folsom Lake State Recreation Area | 18970 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 42.957 | Folsom Lake SRA | 1956 | Local Recreation Area 3 | 4 | |
3673 | 3673 | 3672 | {"type": "Polygon", "coordinates": [[[-121.764, 38.67997], [-121.76378, 38.68], [-121.76291, 38.68027], [-121.7627, 38.68031], [-121.75975, 38.68029], [-121.75975, 38.67976], [-121.7603, 38.67977], [-121.7603, 38.67979], [-121.76059, 38.67981], [-121.76213, 38.67983], [-121.76214, 38.67974], [-121.76325, 38.67977], [-121.76325, 38.67994], [-121.764, 38.67997]]]} | Open Access 1 | 29720 | Gonzales Park Soccer Field | 19399 | 332 | Yolo, County of 545 | County 3 | County Agency 3 | http://www.yolocounty.org/general-government/general-government-departments/parks | County 3 | 332 | Yolo, County of 538 | County 3 | County Agency 3 | Yolo 33 | 4.348 | Gonzales Park Soccer Field | 0 | Local Recreation Area 3 | 4 | |
12588 | 12588 | 12587 | {"type": "Polygon", "coordinates": [[[-123.99351, 40.88039], [-123.99291, 40.88117], [-123.99172, 40.88062], [-123.99228, 40.87997], [-123.99351, 40.88039]]]} | Open Access 1 | 29310 | Gymkhana Field | 19579 | 348 | Humboldt, County of 552 | County 3 | County Agency 3 | http://co.humboldt.ca.us/portal/living/county_parks/cpdefault.asp | County 3 | 348 | Humboldt, County of 545 | County 3 | County Agency 3 | Humboldt 45 | 2.642 | Gymkhana Field | 0 | Local Recreation Area 3 | 4 | |
9780 | 9780 | 9779 | {"type": "Polygon", "coordinates": [[[-118.63702, 34.45237], [-118.63703, 34.45246], [-118.63701, 34.45251], [-118.63659, 34.45296], [-118.63652, 34.45292], [-118.63652, 34.45288], [-118.63643, 34.45278], [-118.63616, 34.45261], [-118.63605, 34.45258], [-118.63601, 34.45258], [-118.63597, 34.45263], [-118.63589, 34.4526], [-118.63582, 34.45248], [-118.63576, 34.45241], [-118.63541, 34.45209], [-118.63522, 34.45196], [-118.63509, 34.45188], [-118.63491, 34.45173], [-118.63482, 34.45162], [-118.63482, 34.45156], [-118.63492, 34.45143], [-118.63508, 34.45129], [-118.63542, 34.45113], [-118.63578, 34.45131], [-118.63605, 34.45148], [-118.63627, 34.45166], [-118.63652, 34.45162], [-118.63658, 34.45164], [-118.63659, 34.45166], [-118.63663, 34.45196], [-118.63675, 34.45213], [-118.63683, 34.45227], [-118.63697, 34.45233], [-118.63702, 34.45237]]]} | Open Access 1 | 47885 | Hasley Canyon Equestrian Park | 31829 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov/hasley-canyon-equestrian-park/ | Los Angeles 6 | 4.746 | Hasley Canyon Equestrian Park | 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]);