units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
236 rows where MNG_AG_TYP = 7 sorted by ACRES
This data as json, copyable, CSV (advanced)
DES_TP >30
- Local Park 137
- Local Recreation Area 34
- Local Conservation Area 12
- Local Resource Management Area 5
- Local Other or Unknown 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
- None 1
- …
MNG_AGENCY 7
- Los Angeles - Department of Parks and Recreation, County of 58
- Santa Clara County Parks and Recreation Dept., County of 53
- Sonoma County Regional Parks Dept., County of 48
- Marin County Parks Department, County of 28
- San Mateo County Parks and Recreation Dept., County of 22
- Del Norte County Parks, County of 6
- Yolo County Parks, County of 1
ACCESS_TYP 4
- Open Access 186
- No Public Access 18
- Restricted Access 11
- Unknown Access 1
MNG_AG_TYP 1
- County Agency - Parks · 216 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12459 | 12459 | 12458 | {"type": "Polygon", "coordinates": [[[-122.93948, 38.35579], [-122.93861, 38.35592], [-122.93857, 38.35592], [-122.93856, 38.35587], [-122.93847, 38.35577], [-122.93853, 38.35573], [-122.93849, 38.35551], [-122.93858, 38.35544], [-122.93913, 38.35514], [-122.93922, 38.35551], [-122.93948, 38.35579]]]} | Restricted Access 2 | 28220 | Watson School/ Wayside Park | 31655 | 328 | Sonoma County Regional Parks Dept., County of 193 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | Sonoma 16 | 1.062 | Watson School/ Wayside Park | 0 | Local Park 2 | 4 | |
12577 | 12577 | 12576 | {"type": "Polygon", "coordinates": [[[-122.51392, 37.87414], [-122.51376, 37.87421], [-122.51357, 37.87426], [-122.51337, 37.87427], [-122.51323, 37.87425], [-122.51309, 37.8742], [-122.51297, 37.87413], [-122.51288, 37.87403], [-122.51283, 37.87395], [-122.51347, 37.87356], [-122.51369, 37.87376], [-122.51369, 37.87378], [-122.51392, 37.87414]]]} | Open Access 1 | 29137 | Rocky Graham Park | 24540 | 306 | Marin County Parks Department, County of 154 | County 3 | County Agency - Parks 7 | http://www.marincountyparks.org/depts/pk | County 3 | 306 | Marin County Parks Department, County of 150 | County 3 | County Agency - Parks 7 | Marin 23 | 1.113 | Rocky Graham Park | 0 | Local Park 2 | 4 | |
6329 | 6329 | 6328 | {"type": "Polygon", "coordinates": [[[-122.68693, 37.90647], [-122.68631, 37.90679], [-122.68619, 37.90667], [-122.68607, 37.90645], [-122.68603, 37.90634], [-122.68601, 37.90621], [-122.68605, 37.90594], [-122.68612, 37.90585], [-122.68623, 37.90589], [-122.68637, 37.90596], [-122.68663, 37.90614], [-122.68674, 37.90624], [-122.68693, 37.90647]]]} | Open Access 1 | 1648 | Bolinas Park | 30877 | 306 | Marin County Parks Department, County of 154 | County 3 | County Agency - Parks 7 | http://www.marincountyparks.org/depts/pk | County 3 | 306 | Marin County Parks Department, County of 150 | County 3 | County Agency - Parks 7 | Marin 23 | 1.195 | Bolinas Park | 0 | Local Park 2 | 4 | |
14917 | 14917 | 14916 | {"type": "Polygon", "coordinates": [[[-124.15565, 41.74626], [-124.15565, 41.74659], [-124.15543, 41.7466], [-124.15543, 41.74692], [-124.15471, 41.74692], [-124.15467, 41.74626], [-124.15565, 41.74626]]]} | Open Access 1 | 45487 | Bertsch Tract Park | 28317 | 347 | Del Norte County Parks, County of 672 | County 3 | County Agency - Parks 7 | http://www.dnco.org/ | County 3 | 347 | Del Norte County Parks, County of 661 | County 3 | County Agency - Parks 7 | Del Norte 50 | 1.281 | Bertsch Tract Park | 0 | Local Park 2 | 4 | |
14525 | 14525 | 14524 | {"type": "Polygon", "coordinates": [[[-122.57028, 38.00565], [-122.57023, 38.00585], [-122.57009, 38.00592], [-122.57018, 38.00616], [-122.57005, 38.00647], [-122.56991, 38.00659], [-122.5698, 38.00673], [-122.5697, 38.00695], [-122.56969, 38.00718], [-122.56964, 38.00742], [-122.56977, 38.0076], [-122.56977, 38.00771], [-122.56965, 38.00773], [-122.56934, 38.00762], [-122.56925, 38.00756], [-122.56921, 38.00748], [-122.56915, 38.00728], [-122.56908, 38.00722], [-122.56887, 38.00718], [-122.56872, 38.00718], [-122.56849, 38.00724], [-122.56849, 38.00723], [-122.56862, 38.00716], [-122.56884, 38.00709], [-122.56884, 38.00708], [-122.56882, 38.00704], [-122.56889, 38.00704], [-122.56915, 38.0071], [-122.56927, 38.00717], [-122.56931, 38.00724], [-122.56937, 38.00743], [-122.56939, 38.00747], [-122.56944, 38.00751], [-122.5695, 38.00753], [-122.56947, 38.00746], [-122.56947, 38.00739], [-122.56952, 38.00717], [-122.56952, 38.00699], [-122.56954, 38.00686], [-122.56964, 38.00667], [-122.56977, 38.0065], [-122.56989, 38.0064], [-122.57, 38.00615], [-122.56988, 38.00586], [-122.57028, 38.00565]]]} | Open Access 1 | 47190 | Mission Pass Path | 30882 | 306 | Marin County Parks Department, County of 154 | County 3 | County Agency - Parks 7 | http://www.marincountyparks.org/depts/pk | County 3 | 306 | Marin County Parks Department, County of 150 | County 3 | County Agency - Parks 7 | Marin 23 | 1.357 | Mission Pass Path | 0 | Local Recreation Area 3 | 4 | |
9571 | 9571 | 9570 | {"type": "Polygon", "coordinates": [[[-122.52552, 38.01157], [-122.52518, 38.01194], [-122.5243, 38.01226], [-122.52403, 38.01202], [-122.52394, 38.01186], [-122.52379, 38.01175], [-122.52359, 38.01165], [-122.52362, 38.01157], [-122.52384, 38.01164], [-122.52431, 38.0117], [-122.52484, 38.01171], [-122.52507, 38.01169], [-122.52552, 38.01157]]]} | Open Access 1 | 16103 | Castro Park | 16961 | 306 | Marin County Parks Department, County of 154 | County 3 | County Agency - Parks 7 | http://www.marincountyparks.org/depts/pk | County 3 | 306 | Marin County Parks Department, County of 150 | County 3 | County Agency - Parks 7 | Marin 23 | 1.427 | Castro Park | 0 | Local Park 2 | 4 | |
3251 | 3251 | 3250 | {"type": "Polygon", "coordinates": [[[-118.29179, 33.95328], [-118.2918, 33.95365], [-118.29183, 33.9538], [-118.29183, 33.9539], [-118.29183, 33.95646], [-118.29181, 33.95682], [-118.29178, 33.957], [-118.29171, 33.95701], [-118.29167, 33.95699], [-118.29163, 33.95683], [-118.29164, 33.95301], [-118.29179, 33.95328]]]} | Open Access 1 | 48155 | Vermont Median | 32692 | 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 | http://parks.lacounty.gov/vermont-median/ | Los Angeles 6 | 1.804 | Vermont Median | None 267 | ||
11447 | 11447 | 11446 | {"type": "Polygon", "coordinates": [[[-117.92427, 33.98937], [-117.92229, 33.98922], [-117.92235, 33.98879], [-117.92237, 33.98878], [-117.9235, 33.98886], [-117.92365, 33.98889], [-117.92386, 33.98897], [-117.92404, 33.98909], [-117.92417, 33.98922], [-117.92427, 33.98937]]]} | Open Access 1 | 48140 | Albatross Road Rest Area | 32670 | 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 | http://parks.lacounty.gov/albatross-road-rest-area/ | Los Angeles 6 | 1.94 | Albatross Road Rest Area | None 1016 | ||
3971 | 3971 | 3970 | {"type": "Polygon", "coordinates": [[[-121.68844, 36.99391], [-121.68834, 36.99433], [-121.68829, 36.99445], [-121.6881, 36.99477], [-121.68806, 36.99491], [-121.68805, 36.99504], [-121.68808, 36.99518], [-121.68824, 36.99549], [-121.68824, 36.99564], [-121.68821, 36.99576], [-121.68799, 36.99607], [-121.68785, 36.99624], [-121.68778, 36.99632], [-121.68747, 36.99652], [-121.68723, 36.99676], [-121.68792, 36.99542], [-121.68787, 36.99477], [-121.68815, 36.99388], [-121.68844, 36.99391]]]} | Open Access 1 | 38002 | Mount Madonna County Park | 29287 | 1118 | Gilroy, City of 407 | City 2 | City Agency 2 | http://www.cityofgilroy.org/cityofgilroy/community/parks/default.aspx | City 2 | 326 | Santa Clara County Parks and Recreation Dept., County of 465 | County 3 | County Agency - Parks 7 | https://www.sccgov.org/sites/parks/parkfinder/Pages/MtMadonna.aspx | Santa Clara 19 | 1.998 | Mount Madonna County Park | 0 | Local Park 2 | 4 |
9605 | 9605 | 9604 | {"type": "Polygon", "coordinates": [[[-122.49053, 38.30297], [-122.49039, 38.30284], [-122.49011, 38.30262], [-122.48963, 38.30238], [-122.48939, 38.30214], [-122.48932, 38.30204], [-122.4892, 38.30194], [-122.4891, 38.30188], [-122.48889, 38.30184], [-122.48857, 38.30189], [-122.48751, 38.30222], [-122.48744, 38.30222], [-122.48741, 38.3022], [-122.48739, 38.30215], [-122.48778, 38.30202], [-122.48781, 38.30207], [-122.4896, 38.3014], [-122.48976, 38.30169], [-122.48999, 38.30208], [-122.49019, 38.30247], [-122.49053, 38.30297]]]} | Open Access 1 | 16158 | Ernie Smith Community Park | 18699 | 328 | Sonoma County Regional Parks Dept., County of 193 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | Sonoma 16 | 2.099 | Ernie Smith Community Park | 0 | Local Park 2 | 4 | |
3807 | 3807 | 3806 | {"type": "Polygon", "coordinates": [[[-122.056, 37.23144], [-122.05442, 37.23139], [-122.05437, 37.23056], [-122.0559, 37.23113], [-122.056, 37.23144]]]} | No Public Access 3 | 35126 | Sanborn County Park | 32833 | 326 | Santa Clara County Parks and Recreation Dept., County of 472 | County 3 | County Agency - Parks 7 | http://www.sccgov.org/sites/parks/Pages/Welcome-to-Santa-Clara-County-Parks.aspx | County 3 | 326 | Santa Clara County Parks and Recreation Dept., County of 465 | County 3 | County Agency - Parks 7 | Santa Clara 19 | 2.136 | Sanborn County Park | 0 | Local Park 2 | 4 | |
436 | 436 | 435 | {"type": "MultiPolygon", "coordinates": [[[[-122.50735, 38.11473], [-122.50721, 38.11477], [-122.50708, 38.11492], [-122.50687, 38.11486], [-122.50673, 38.11475], [-122.50645, 38.11496], [-122.50608, 38.11467], [-122.50597, 38.11454], [-122.5062, 38.11444], [-122.50605, 38.11434], [-122.50643, 38.1142], [-122.50655, 38.11334], [-122.50673, 38.11403], [-122.50667, 38.11408], [-122.50674, 38.11407], [-122.50688, 38.11442], [-122.5068, 38.1145], [-122.50682, 38.11454], [-122.50703, 38.11464], [-122.50716, 38.11469], [-122.50735, 38.11473]]], [[[-122.50745, 38.11324], [-122.50722, 38.11345], [-122.50723, 38.11346], [-122.50737, 38.11346], [-122.50737, 38.11352], [-122.50703, 38.11382], [-122.50688, 38.11383], [-122.50682, 38.11385], [-122.50685, 38.11358], [-122.50677, 38.11331], [-122.50745, 38.11324]]]]} | Open Access 1 | 840 | Black Point Boat Launch | 16137 | 306 | Marin County Parks Department, County of 154 | County 3 | County Agency - Parks 7 | http://www.marincountyparks.org/depts/pk | County 3 | 306 | Marin County Parks Department, County of 150 | County 3 | County Agency - Parks 7 | Marin 23 | 2.255 | Black Point Boat Launch | None 45 | |||
14521 | 14521 | 14520 | {"type": "Polygon", "coordinates": [[[-122.54025, 38.03365], [-122.53987, 38.03375], [-122.53969, 38.03377], [-122.53924, 38.03375], [-122.53916, 38.03379], [-122.53855, 38.03417], [-122.53781, 38.03479], [-122.53764, 38.03494], [-122.53753, 38.03506], [-122.53742, 38.03526], [-122.53729, 38.03577], [-122.5373, 38.03598], [-122.5373, 38.03615], [-122.53713, 38.03656], [-122.5371, 38.03673], [-122.53706, 38.0376], [-122.53714, 38.03825], [-122.53741, 38.03953], [-122.5375, 38.03985], [-122.53751, 38.0401], [-122.53743, 38.04065], [-122.53725, 38.04116], [-122.53702, 38.04159], [-122.53662, 38.04223], [-122.53568, 38.04355], [-122.53555, 38.04389], [-122.53512, 38.04463], [-122.53338, 38.04702], [-122.53332, 38.04711], [-122.53324, 38.04736], [-122.53317, 38.04747], [-122.53298, 38.04762], [-122.53288, 38.0478], [-122.53288, 38.04783], [-122.53293, 38.04788], [-122.53349, 38.04817], [-122.53363, 38.04816], [-122.53357, 38.04824], [-122.53352, 38.04825], [-122.53347, 38.04824], [-122.53347, 38.04821], [-122.5329, 38.04791], [-122.53282, 38.04783], [-122.53283, 38.04779], [-122.53294, 38.04759], [-122.53313, 38.04745], [-122.53319, 38.04734], [-122.53327, 38.0471], [-122.53333, 38.047], [-122.53508, 38.04461], [-122.5355, 38.04387], [-122.53563, 38.04353], [-122.53657, 38.04222], [-122.53697, 38.04158], [-122.5372, 38.04115], [-122.53737, 38.04065], [-122.53745, 38.0401], [-122.53745, 38.03992], [-122.53742, 38.03976], [-122.53736, 38.03955], [-122.53708, 38.03827], [-122.53701, 38.0376], [-122.53701, 38.03728], [-122.53705, 38.03682], [-122.53705, 38.03674], [-122.53708, 38.03655], [-122.53725, 38.03615], [-122.53725, 38.03598], [-122.53723, 38.03577], [-122.53737, 38.03525], [-122.53744, 38.03511], [-122.5376, 38.03492], [-122.53895, 38.03378], [-122.53909, 38.03372], [-122.53927, 38.03369], [-122.53929, 38.03372], [-122.53969, 38.03373], [-122.53994, 38.03369], [-122.54018, 38.03362], [-122.54025, 38.03365]]]} | Open Access 1 | 47182 | Pacheco Path | 30874 | 306 | Marin County Parks Department, County of 154 | County 3 | County Agency - Parks 7 | http://www.marincountyparks.org/depts/pk | County 3 | 306 | Marin County Parks Department, County of 150 | County 3 | County Agency - Parks 7 | Marin 23 | 2.279 | Pacheco Path | 0 | Local Recreation Area 3 | 4 | |
14523 | 14523 | 14522 | {"type": "Polygon", "coordinates": [[[-122.53548, 37.9535], [-122.53505, 37.95382], [-122.53417, 37.95393], [-122.53356, 37.95388], [-122.53324, 37.9538], [-122.5334, 37.95316], [-122.53492, 37.95354], [-122.53548, 37.9535]]]} | Open Access 1 | 47187 | Greenbrae Redwoods County Park | 30879 | 306 | Marin County Parks Department, County of 154 | County 3 | County Agency - Parks 7 | http://www.marincountyparks.org/depts/pk | County 3 | 306 | Marin County Parks Department, County of 150 | County 3 | County Agency - Parks 7 | Marin 23 | 2.343 | Greenbrae Redwoods County Park | 0 | Local Park 2 | 4 | |
14415 | 14415 | 14414 | {"type": "Polygon", "coordinates": [[[-122.69822, 38.00712], [-122.69764, 38.00738], [-122.69766, 38.00745], [-122.69675, 38.00778], [-122.69618, 38.00677], [-122.69672, 38.00671], [-122.69698, 38.00672], [-122.69724, 38.00658], [-122.69734, 38.00703], [-122.6977, 38.00711], [-122.6981, 38.00699], [-122.69811, 38.00705], [-122.69822, 38.00712]]]} | Open Access 1 | 47188 | Lagunitas Village Mini-Park | 30880 | 306 | Marin County Parks Department, County of 154 | County 3 | County Agency - Parks 7 | http://www.marincountyparks.org/depts/pk | County 3 | 306 | Marin County Parks Department, County of 150 | County 3 | County Agency - Parks 7 | Marin 23 | 2.695 | Lagunitas Village Mini-Park | 0 | Local Park 2 | 4 | |
14531 | 14531 | 14530 | {"type": "Polygon", "coordinates": [[[-122.52652, 37.87708], [-122.52628, 37.87758], [-122.52614, 37.87781], [-122.52606, 37.87788], [-122.52594, 37.87794], [-122.52584, 37.87793], [-122.52544, 37.87771], [-122.525, 37.87763], [-122.52478, 37.87769], [-122.5243, 37.87785], [-122.52414, 37.87787], [-122.52404, 37.87789], [-122.52378, 37.87805], [-122.52371, 37.87811], [-122.52362, 37.87824], [-122.52358, 37.87837], [-122.5236, 37.87853], [-122.5236, 37.87872], [-122.52357, 37.87889], [-122.5235, 37.87909], [-122.52339, 37.87925], [-122.52324, 37.87942], [-122.52355, 37.87957], [-122.52351, 37.87964], [-122.52329, 37.87952], [-122.52317, 37.87948], [-122.52315, 37.87958], [-122.52307, 37.87969], [-122.52284, 37.87971], [-122.52206, 37.88056], [-122.52193, 37.88066], [-122.5211, 37.88119], [-122.52, 37.88186], [-122.5199, 37.88191], [-122.51964, 37.88199], [-122.51908, 37.88231], [-122.51901, 37.88266], [-122.51887, 37.88256], [-122.51894, 37.88244], [-122.51895, 37.88233], [-122.51917, 37.88215], [-122.5212, 37.88106], [-122.52189, 37.88062], [-122.522, 37.88052], [-122.5228, 37.87966], [-122.52288, 37.87964], [-122.52302, 37.87964], [-122.52308, 37.87957], [-122.52307, 37.87954], [-122.52285, 37.87949], [-122.52289, 37.87943], [-122.52317, 37.87926], [-122.52336, 37.87909], [-122.52349, 37.87876], [-122.52351, 37.87863], [-122.52349, 37.87846], [-122.52338, 37.87825], [-122.52343, 37.87815], [-122.52349, 37.87808], [-122.52352, 37.87808], [-122.52379, 37.87783], [-122.52394, 37.87774], [-122.52433, 37.87777], [-122.52458, 37.87772], [-122.52487, 37.87761], [-122.52494, 37.8776], [-122.52546, 37.87767], [-122.52584, 37.87761], [-122.5261, 37.87748], [-122.52634, 37.87725], [-122.52647, 37.87704], [-122.52652, 37.87708]]]} | Open Access 1 | 47198 | Charles F. McGlashan Pathway | 30897 | 306 | Marin County Parks Department, County of 154 | County 3 | County Agency - Parks 7 | http://www.marincountyparks.org/depts/pk | County 3 | 306 | Marin County Parks Department, County of 150 | County 3 | County Agency - Parks 7 | Marin 23 | 2.726 | Charles F. McGlashan Pathway | None 1237 | |||
15073 | 15073 | 15072 | {"type": "Polygon", "coordinates": [[[-118.18749, 33.88301], [-118.18743, 33.88376], [-118.18718, 33.88544], [-118.18669, 33.88544], [-118.18708, 33.88292], [-118.18749, 33.88301]]]} | Open Access 1 | 45852 | 72nd Street Equestrian Park | 32687 | 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 | http://parks.lacounty.gov/72nd-street-equestrian-park/ | Los Angeles 6 | 2.957 | 72nd Street Equestrian Park | 0 | Local Recreation Area 3 | 4 |
9981 | 9981 | 9980 | {"type": "Polygon", "coordinates": [[[-122.54867, 38.41193], [-122.54776, 38.4126], [-122.54691, 38.41186], [-122.54758, 38.41137], [-122.54782, 38.41122], [-122.54824, 38.41153], [-122.54867, 38.41193]]]} | Open Access 1 | 17178 | Kenwood Plaza Park | 20624 | 328 | Sonoma County Regional Parks Dept., County of 193 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | Sonoma 16 | 2.982 | Kenwood Plaza Park | 1951 | Local Park 2 | 4 | |
509 | 509 | 508 | {"type": "Polygon", "coordinates": [[[-123.01254, 38.82071], [-123.01186, 38.82152], [-123.01112, 38.82235], [-123.01076, 38.82218], [-123.0119, 38.82141], [-123.01148, 38.82068], [-123.01202, 38.81948], [-123.01254, 38.82071]]]} | Open Access 1 | 1700 | Cloverdale River Park | 17444 | 328 | Sonoma County Regional Parks Dept., County of 193 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | Sonoma 16 | 3.11 | Cloverdale River Park | 0 | Local Park 2 | 4 | |
12117 | 12117 | 12116 | {"type": "Polygon", "coordinates": [[[-117.99458, 34.12298], [-117.99417, 34.12402], [-117.9937, 34.1239], [-117.99361, 34.12392], [-117.99355, 34.12398], [-117.99303, 34.12384], [-117.99314, 34.12361], [-117.99327, 34.12338], [-117.99379, 34.12268], [-117.99452, 34.12288], [-117.99452, 34.12294], [-117.99458, 34.12298]]]} | Open Access 1 | 25055 | Pamela County Park | 32487 | 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 | 3.221 | Pamela County Park | 0 | Local Park 2 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([id]), FOREIGN KEY([MNG_AGENCY]) REFERENCES [MNG_AGENCY]([id]), FOREIGN KEY([MNG_AG_LEV]) REFERENCES [MNG_AG_LEV]([id]), FOREIGN KEY([MNG_AG_TYP]) REFERENCES [MNG_AG_TYP]([id]), FOREIGN KEY([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);