units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
63 rows where ACCESS_TYP = 2 and AGNCY_TYP = 3 sorted by PARK_URL
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_WEB, MNG_AG_ID, MNG_AG_LEV, YR_EST, GAP_STS
MNG_AGENCY 18
- Sacramento, County of 23
- Los Angeles, County of 11
- Los Angeles - Department of Parks and Recreation, County of 7
- Orange, County of 4
- Santa Cruz, County of 2
- San Luis Obispo, County of 2
- San Diego, County of 2
- Ventura, County of 2
- Monterey, County of 1
- California Department of Fish and Wildlife 1
- Tulare, County of 1
- Placer, County of 1
- Torrance, City of 1
- Fresno, County of 1
- Kern, County of 1
- Humboldt, County of 1
- National Audubon Society 1
- Shasta, County of 1
DES_TP 18
- Local Recreation Area 29
- Local Conservation Area 10
- Local Other or Unknown 6
- Local Park 4
- State Conservation Area 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
MNG_AG_TYP 5
ACCESS_TYP 1
- Restricted Access · 63 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
262 | 262 | 261 | {"type": "MultiPolygon", "coordinates": [[[[-119.51628, 36.5064], [-119.51628, 36.50687], [-119.51596, 36.50697], [-119.5159, 36.50697], [-119.51578, 36.50704], [-119.51571, 36.50706], [-119.51541, 36.50717], [-119.51519, 36.50722], [-119.51504, 36.50729], [-119.5146, 36.50739], [-119.51446, 36.5074], [-119.51416, 36.5074], [-119.51366, 36.50732], [-119.51344, 36.50726], [-119.51285, 36.50704], [-119.51229, 36.5069], [-119.51198, 36.50687], [-119.5116, 36.50688], [-119.51097, 36.50675], [-119.51085, 36.50679], [-119.51073, 36.50687], [-119.51069, 36.50704], [-119.51062, 36.50717], [-119.51053, 36.50724], [-119.51037, 36.50734], [-119.5101, 36.50745], [-119.50998, 36.50746], [-119.50976, 36.5076], [-119.50924, 36.50769], [-119.50894, 36.5078], [-119.50879, 36.50781], [-119.50838, 36.5078], [-119.50839, 36.5066], [-119.50732, 36.50658], [-119.50733, 36.50532], [-119.50718, 36.50531], [-119.50723, 36.50332], [-119.51176, 36.50332], [-119.51176, 36.50188], [-119.51343, 36.50219], [-119.51503, 36.50228], [-119.51505, 36.50638], [-119.51628, 36.5064]]], [[[-119.51651, 36.50754], [-119.5165, 36.50802], [-119.51522, 36.50835], [-119.51522, 36.5079], [-119.5154, 36.50788], [-119.51546, 36.50784], [-119.51651, 36.50754]]]]} | Restricted Access 2 | 733 | Kings River Nature Preserve | 20663 | 330 | Tulare, County of 96 | County 3 | County Agency 3 | http://www.tularecounty.ca.gov/cao/index.cfm/general-services/parks-and-recreation/county-parks/ | County 3 | 330 | Tulare, County of 94 | County 3 | County Agency 3 | Tulare 29 | 86.678 | Kings River Nature Preserve | 0 | Local Conservation Area 4 | 2 | |
1070 | 1070 | 1069 | {"type": "Polygon", "coordinates": [[[-118.12169, 34.18412], [-118.12169, 34.18484], [-118.12109, 34.18492], [-118.12098, 34.18506], [-118.12057, 34.18506], [-118.12058, 34.18579], [-118.11862, 34.1858], [-118.11862, 34.18574], [-118.11762, 34.1841], [-118.11755, 34.18393], [-118.1175, 34.18371], [-118.11747, 34.18334], [-118.11742, 34.18334], [-118.11734, 34.18092], [-118.11782, 34.18092], [-118.11781, 34.18075], [-118.11767, 34.18048], [-118.11767, 34.18009], [-118.11806, 34.18009], [-118.1181, 34.1796], [-118.12141, 34.17957], [-118.12144, 34.18233], [-118.12147, 34.18248], [-118.12158, 34.18276], [-118.12162, 34.18294], [-118.12162, 34.18319], [-118.12154, 34.18358], [-118.12153, 34.18373], [-118.12155, 34.18386], [-118.12159, 34.18403], [-118.12162, 34.18407], [-118.12169, 34.18412]]]} | Restricted Access 2 | 6971 | Altadena Golf Course | 33022 | 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 | 57.739 | Altadena GC | 0 | Local Recreation Area 3 | 4 | |
2202 | 2202 | 2201 | {"type": "Polygon", "coordinates": [[[-118.27588, 33.85284], [-118.2733, 33.85587], [-118.27289, 33.855], [-118.27131, 33.85628], [-118.27096, 33.85622], [-118.27087, 33.85665], [-118.26832, 33.85666], [-118.26831, 33.85663], [-118.26621, 33.85662], [-118.26616, 33.85657], [-118.26515, 33.84858], [-118.26738, 33.84759], [-118.26891, 33.84731], [-118.26947, 33.84787], [-118.26991, 33.84825], [-118.26994, 33.84841], [-118.27012, 33.84858], [-118.2705, 33.84889], [-118.27057, 33.84885], [-118.2725, 33.85028], [-118.2731, 33.85068], [-118.27588, 33.85284]]]} | Restricted Access 2 | 6243 | Victoria Golf Course | 33008 | 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 | 167.229 | Victoria GC | 0 | Local Recreation Area 3 | 4 | |
2734 | 2734 | 2733 | {"type": "Polygon", "coordinates": [[[-121.33438, 38.34361], [-121.33319, 38.34464], [-121.33304, 38.34475], [-121.33156, 38.34376], [-121.32059, 38.34373], [-121.31587, 38.3413], [-121.31593, 38.33691], [-121.31584, 38.33662], [-121.33219, 38.33672], [-121.33217, 38.33698], [-121.33427, 38.34166], [-121.33351, 38.34218], [-121.33376, 38.3427], [-121.33414, 38.34327], [-121.33438, 38.34361]]]} | Restricted Access 2 | 21422 | Cosumnes River Preserve | 17679 | 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 | 286.086 | Cosumnes River Preserve | 0 | Local Conservation Area 4 | 2 | |
2735 | 2735 | 2734 | {"type": "Polygon", "coordinates": [[[-121.37929, 38.26206], [-121.37925, 38.26667], [-121.36993, 38.26662], [-121.36997, 38.26204], [-121.37929, 38.26206]]]} | Restricted Access 2 | 21423 | Cosumnes River Preserve | 17679 | 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 | 102.78 | Cosumnes River Preserve | 0 | Local Conservation Area 4 | 2 | |
2877 | 2877 | 2876 | {"type": "Polygon", "coordinates": [[[-121.2872, 38.42303], [-121.28685, 38.42315], [-121.28643, 38.42337], [-121.28619, 38.42353], [-121.2858, 38.42385], [-121.28542, 38.42359], [-121.28471, 38.42421], [-121.28261, 38.42406], [-121.28154, 38.42496], [-121.28143, 38.42489], [-121.28175, 38.42462], [-121.28187, 38.42447], [-121.28205, 38.42431], [-121.28253, 38.42403], [-121.28272, 38.42397], [-121.28303, 38.42393], [-121.28323, 38.42385], [-121.28393, 38.42367], [-121.28429, 38.4236], [-121.28452, 38.42349], [-121.28487, 38.42338], [-121.28505, 38.42325], [-121.28543, 38.42302], [-121.286, 38.42263], [-121.28628, 38.42252], [-121.28663, 38.42231], [-121.2872, 38.42303]]]} | Restricted Access 2 | 22244 | Preston Hanford | 23996 | 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 | 6.909 | Preston Hanford | None 241 | |||
3118 | 3118 | 3117 | {"type": "Polygon", "coordinates": [[[-121.45011, 38.40646], [-121.45004, 38.40688], [-121.4499, 38.40688], [-121.44976, 38.40685], [-121.44963, 38.40679], [-121.44953, 38.40671], [-121.44945, 38.40661], [-121.44942, 38.40654], [-121.44941, 38.40643], [-121.44944, 38.40612], [-121.44612, 38.40611], [-121.44612, 38.40534], [-121.44083, 38.40532], [-121.44083, 38.405], [-121.44983, 38.40499], [-121.44995, 38.40507], [-121.45002, 38.40514], [-121.4501, 38.40525], [-121.45014, 38.40538], [-121.45014, 38.40551], [-121.45, 38.40639], [-121.45004, 38.40645], [-121.45011, 38.40646]]]} | Restricted Access 2 | 21488 | Laguna Lake Drainage | 20858 | 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 | 15.913 | Laguna Lake Drainage | None 255 | |||
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 | |
3224 | 3224 | 3223 | {"type": "Polygon", "coordinates": [[[-121.45044, 38.37471], [-121.44978, 38.3747], [-121.44966, 38.37342], [-121.45028, 38.37338], [-121.45044, 38.37471]]]} | Restricted Access 2 | 22246 | Hood-Franklin Drainage | 20071 | 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 | 2.025 | Hood-Franklin Drainage | None 266 | |||
4057 | 4057 | 4056 | {"type": "Polygon", "coordinates": [[[-122.40231, 40.58043], [-122.40172, 40.58057], [-122.40131, 40.57969], [-122.40194, 40.57953], [-122.40231, 40.58043]]]} | Restricted Access 2 | 44420 | Magnolia Park | 21676 | 343 | Shasta, County of 717 | County 3 | County Agency 3 | http://www.co.shasta.ca.us/index.aspx | County 3 | 343 | Shasta, County of 700 | County 3 | County Agency 3 | Shasta 27 | 1.399 | Magnolia Park | 0 | Local Park 2 | 4 | |
4372 | 4372 | 4371 | {"type": "Polygon", "coordinates": [[[-118.22505, 33.96758], [-118.22454, 33.96753], [-118.22448, 33.9675], [-118.22431, 33.96734], [-118.22437, 33.96694], [-118.22436, 33.96693], [-118.22415, 33.96711], [-118.22327, 33.96702], [-118.22323, 33.96723], [-118.22254, 33.96715], [-118.22254, 33.96649], [-118.22474, 33.96672], [-118.22469, 33.96704], [-118.22505, 33.96708], [-118.22505, 33.96758]]]} | Restricted Access 2 | 45864 | Walnut Nature Park | 28911 | 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 | 3.587 | Walnut Nature Park | 0 | Local Park 2 | 4 | |
4679 | 4679 | 4678 | {"type": "Polygon", "coordinates": [[[-121.3533, 38.45594], [-121.35327, 38.45595], [-121.35327, 38.45636], [-121.35226, 38.45636], [-121.35227, 38.45624], [-121.3523, 38.45613], [-121.35236, 38.456], [-121.35243, 38.45591], [-121.35251, 38.45582], [-121.35281, 38.45567], [-121.35311, 38.4556], [-121.35318, 38.45561], [-121.35321, 38.45564], [-121.3533, 38.45594]]]} | Restricted Access 2 | 43001 | Unnamed site - Sacramento, County of | 28659 | 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 | 1.452 | 0 | Local Other or Unknown 14 | 4 | ||
4694 | 4694 | 4693 | {"type": "Polygon", "coordinates": [[[-117.90308, 34.64234], [-117.90298, 34.64592], [-117.89442, 34.64592], [-117.89406, 34.64594], [-117.89415, 34.64234], [-117.89864, 34.64232], [-117.90308, 34.64234]]]} | Restricted Access 2 | 45942 | Unnamed site - Los Angeles, County of | 29046 | 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 | 80.519 | 0 | Local Other or Unknown 14 | 4 | ||
4758 | 4758 | 4757 | {"type": "Polygon", "coordinates": [[[-123.96182, 40.47601], [-123.96157, 40.47625], [-123.96067, 40.47662], [-123.95893, 40.478], [-123.95764, 40.47896], [-123.95666, 40.48], [-123.95668, 40.4767], [-123.95728, 40.4765], [-123.95804, 40.47633], [-123.9587, 40.47616], [-123.95966, 40.47599], [-123.96182, 40.47601]]]} | Restricted Access 2 | 46661 | Unnamed site - Humboldt, County of | 29996 | 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 | 19.487 | 0 | Local Other or Unknown 14 | 4 | ||
5764 | 5764 | 5763 | {"type": "Polygon", "coordinates": [[[-118.31393, 33.94717], [-118.31391, 33.94733], [-118.31392, 33.949], [-118.31321, 33.949], [-118.3132, 33.94905], [-118.31299, 33.94906], [-118.31298, 33.949], [-118.31178, 33.94901], [-118.31177, 33.94775], [-118.31161, 33.94728], [-118.3116, 33.94704], [-118.3124, 33.94704], [-118.31241, 33.94717], [-118.3133, 33.94717], [-118.31329, 33.94588], [-118.31393, 33.94588], [-118.31393, 33.94717]]]} | Restricted Access 2 | 6211 | Maggie Hathaway Golf Course | 32489 | 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 | 12.466 | Maggie Hathaway GC | 0 | Local Recreation Area 3 | 4 | |
5855 | 5855 | 5854 | {"type": "Polygon", "coordinates": [[[-118.87212, 34.31513], [-118.86601, 34.31512], [-118.86602, 34.31149], [-118.86145, 34.31148], [-118.85913, 34.30851], [-118.85892, 34.3046], [-118.85829, 34.30065], [-118.86599, 34.30066], [-118.86602, 34.30788], [-118.86833, 34.30788], [-118.87066, 34.30982], [-118.87207, 34.31343], [-118.87212, 34.31513]]]} | Restricted Access 2 | 224 | Rustic Canyon Golf Course | 32984 | 331 | Ventura, County of 202 | County 3 | County Agency 3 | http://www.ventura.org/general-services-agency/parks-department | County 3 | 331 | Ventura, County of 198 | County 3 | County Agency 3 | Ventura 8 | 277.113 | Rustic Canyon GC | 0 | Local Recreation Area 3 | 4 | |
6002 | 6002 | 6001 | {"type": "Polygon", "coordinates": [[[-119.16058, 34.28227], [-119.1606, 34.28232], [-119.16056, 34.28237], [-119.1576, 34.28415], [-119.15733, 34.28384], [-119.15656, 34.2843], [-119.15656, 34.28431], [-119.15682, 34.28462], [-119.15395, 34.28635], [-119.15198, 34.28407], [-119.15254, 34.28373], [-119.15218, 34.28332], [-119.15296, 34.28284], [-119.15581, 34.28113], [-119.15737, 34.28293], [-119.16005, 34.28166], [-119.16058, 34.28227]]]} | Restricted Access 2 | 646 | Saticoy Regional Golf Course | 32989 | 331 | Ventura, County of 202 | County 3 | County Agency 3 | http://www.ventura.org/general-services-agency/parks-department | County 3 | 331 | Ventura, County of 198 | County 3 | County Agency 3 | Ventura 8 | 48.962 | Saticoy Reg. GC | 0 | Local Recreation Area 3 | 4 | |
6086 | 6086 | 6085 | {"type": "MultiPolygon", "coordinates": [[[[-117.00116, 33.01884], [-116.99647, 33.01886], [-116.99635, 33.01507], [-117.00112, 33.01494], [-117.00116, 33.01884]]], [[[-117.01695, 33.01451], [-117.01452, 33.01459], [-117.00983, 33.01471], [-117.00983, 33.01458], [-117.01035, 33.01452], [-117.01054, 33.01217], [-117.01092, 33.01197], [-117.01481, 33.01197], [-117.01603, 33.01335], [-117.01695, 33.01451]]]]} | Restricted Access 2 | 891 | Blue Sky Ecological Reserve | 29220 | 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 | 83.938 | Blue Sky ER | 1991 | Local Conservation Area 4 | 2 | |
7384 | 7384 | 7383 | {"type": "MultiPolygon", "coordinates": [[[[-117.75565, 34.14631], [-117.75553, 34.14714], [-117.75483, 34.1482], [-117.75272, 34.15092], [-117.75047, 34.15094], [-117.75081, 34.15065], [-117.75101, 34.15053], [-117.75273, 34.14962], [-117.75307, 34.1494], [-117.75341, 34.14911], [-117.7536, 34.14891], [-117.75565, 34.14631]]], [[[-117.75567, 34.14565], [-117.75562, 34.14593], [-117.75555, 34.14608], [-117.75543, 34.1463], [-117.75346, 34.14879], [-117.75329, 34.14898], [-117.75306, 34.14919], [-117.75271, 34.14943], [-117.75105, 34.1503], [-117.75068, 34.15053], [-117.75049, 34.15067], [-117.75008, 34.15106], [-117.74901, 34.1523], [-117.74894, 34.15235], [-117.74876, 34.15247], [-117.74856, 34.15255], [-117.74841, 34.1526], [-117.74818, 34.15264], [-117.74703, 34.15265], [-117.74681, 34.15262], [-117.74662, 34.15256], [-117.74658, 34.15137], [-117.74647, 34.14969], [-117.74586, 34.14597], [-117.75013, 34.14351], [-117.75014, 34.14318], [-117.75037, 34.14309], [-117.75042, 34.14294], [-117.75065, 34.14274], [-117.7508, 34.14274], [-117.75097, 34.14262], [-117.75147, 34.14253], [-117.75189, 34.14258], [-117.75194, 34.14258], [-117.75204, 34.14273], [-117.7528, 34.14244], [-117.75279, 34.14352], [-117.75422, 34.14353], [-117.75379, 34.14549], [-117.75567, 34.14565]]], [[[-117.75033, 34.15136], [-117.74915, 34.15243], [-117.74893, 34.15258], [-117.74874, 34.15267], [-117.74861, 34.15271], [-117.74889, 34.1526], [-117.74919, 34.15238], [-117.75024, 34.15115], [-117.75033, 34.15107], [-117.75033, 34.15136]]]]} | Restricted Access 2 | 6781 | Marshall Canyon Golf Course | 32492 | 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 | 157.54 | Marshall Canyon GC | 0 | Local Recreation Area 3 | 4 | |
7496 | 7496 | 7495 | {"type": "Polygon", "coordinates": [[[-118.04347, 34.13092], [-118.04339, 34.13133], [-118.0426, 34.13196], [-118.04287, 34.13232], [-118.04246, 34.13254], [-118.04197, 34.13285], [-118.0416, 34.13314], [-118.04112, 34.13356], [-118.04211, 34.13249], [-118.04222, 34.13228], [-118.04225, 34.13218], [-118.04224, 34.13217], [-118.04223, 34.13217], [-118.03927, 34.13536], [-118.03909, 34.13561], [-118.03898, 34.13586], [-118.0383, 34.1366], [-118.03775, 34.13635], [-118.03681, 34.13613], [-118.03624, 34.13619], [-118.03571, 34.13614], [-118.0349, 34.13614], [-118.03405, 34.13627], [-118.03343, 34.13635], [-118.03292, 34.13634], [-118.03259, 34.13625], [-118.03227, 34.13601], [-118.03198, 34.13576], [-118.03151, 34.13565], [-118.03143, 34.1309], [-118.03583, 34.13086], [-118.04244, 34.13075], [-118.04347, 34.13092]], [[-118.04259, 34.13197], [-118.04251, 34.13188], [-118.04241, 34.13199], [-118.04249, 34.13208], [-118.04259, 34.13197]]]} | Restricted Access 2 | 7018 | Santa Anita Golf Course | 33023 | 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 | 130.957 | Santa Anita GC | 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]);