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 YR_EST
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, MNG_AG_ID, MNG_AG_LEV, COUNTY
MNG_AGENCY 28
- Los Angeles, County of 25
- Santa Barbara, County of 18
- Los Angeles - Department of Parks and Recreation, County of 13
- Sacramento, County of 9
- San Diego, County of 7
- Santa Cruz, County of 5
- San Luis Obispo, County of 5
- Monterey, County of 5
- Orange, County of 5
- Riverside, County of 5
- Ventura, County of 4
- Fresno, County of 3
- Kern, County of 3
- Placer, County of 2
- San Joaquin, County of 2
- Stanislaus, County of 2
- Yolo, County of 2
- Valley-Wide Recreation and Park District 1
- Cerritos, City of 1
- Lake, County of 1
- Desert Recreation District 1
- Torrance, City of 1
- Long Beach, City of 1
- San Bernardino, 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 · 126 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
414 | 414 | 413 | {"type": "Polygon", "coordinates": [[[-121.99027, 36.96704], [-121.98919, 36.96912], [-121.98905, 36.9695], [-121.98804, 36.9695], [-121.98722, 36.96943], [-121.98774, 36.96794], [-121.98768, 36.96792], [-121.98777, 36.96788], [-121.98814, 36.96779], [-121.98895, 36.96735], [-121.98913, 36.96739], [-121.99027, 36.96704]]]} | Open Access 1 | 830 | Simpkins Swim Center | 25513 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | Santa Cruz 5 | 9.9 | Simpkins Swim Ctr. | 0 | Local Recreation Area 3 | 4 | |
567 | 567 | 566 | {"type": "Polygon", "coordinates": [[[-116.28545, 33.64926], [-116.27605, 33.6493], [-116.27598, 33.64886], [-116.27585, 33.64695], [-116.27557, 33.64484], [-116.27553, 33.64464], [-116.2754, 33.64431], [-116.27531, 33.64417], [-116.27517, 33.64399], [-116.2749, 33.64373], [-116.27445, 33.64342], [-116.27439, 33.64335], [-116.27436, 33.64326], [-116.27435, 33.64317], [-116.27438, 33.64308], [-116.27467, 33.64262], [-116.27478, 33.64236], [-116.27486, 33.64209], [-116.27489, 33.64208], [-116.27489, 33.64181], [-116.27485, 33.64155], [-116.27478, 33.64134], [-116.27444, 33.6407], [-116.27435, 33.64045], [-116.2741, 33.63907], [-116.27415, 33.63896], [-116.27423, 33.6389], [-116.27463, 33.63883], [-116.27495, 33.63873], [-116.27516, 33.63865], [-116.2755, 33.63848], [-116.2757, 33.63841], [-116.27604, 33.63834], [-116.27679, 33.6383], [-116.27679, 33.63793], [-116.27606, 33.63794], [-116.27575, 33.63799], [-116.27547, 33.63807], [-116.27523, 33.63815], [-116.27487, 33.63832], [-116.27471, 33.63838], [-116.27451, 33.63844], [-116.27408, 33.63852], [-116.27397, 33.63856], [-116.27385, 33.63862], [-116.27376, 33.6387], [-116.27369, 33.6388], [-116.27365, 33.63888], [-116.27322, 33.63867], [-116.273, 33.63852], [-116.27277, 33.63831], [-116.27259, 33.63807], [-116.27246, 33.63778], [-116.27241, 33.63747], [-116.27242, 33.63233], [-116.27236, 33.63209], [-116.27227, 33.63189], [-116.27213, 33.6317], [-116.27194, 33.63152], [-116.27176, 33.6314], [-116.27151, 33.63128], [-116.27134, 33.63123], [-116.27114, 33.6312], [-116.26991, 33.63119], [-116.26969, 33.63117], [-116.26945, 33.63112], [-116.2691, 33.63099], [-116.26892, 33.63089], [-116.26877, 33.63079], [-116.26854, 33.63057], [-116.26836, 33.63031], [-116.26811, 33.63031], [-116.26811, 33.62777], [-116.26796, 33.62763], [-116.26793, 33.62282], [-116.26835, 33.62284], [-116.26846, 33.62308], [-116.26867, 33.62343], [-116.26903, 33.62371], [-116.26946, 33.62391], [-116.27001, 33.62436], [-116.27227, 33.62528], [-116.27348, 33.62589], [-116.27578, 33.62758], [-116.28097, 33.62756], [-116.28101, 33.63121], [-116.28107, 33.64207], [-116.28542, 33.64205], [-116.28545, 33.64926]]]} | Open Access 1 | 3338 | Lake Cahuilla Recreation Area | 9500 | 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 | http://www.rivcoparks.org/parks/lake-cahuilla/lake-cahuilla-recreation-area-home/ | Riverside 10 | 566.48 | Lake Cahuilla Rec. Area | 0 | Local Recreation Area 3 | 4 |
930 | 930 | 929 | {"type": "Polygon", "coordinates": [[[-118.35399, 33.79067], [-118.35035, 33.79268], [-118.35001, 33.7929], [-118.34972, 33.79315], [-118.34952, 33.79335], [-118.34927, 33.7937], [-118.34853, 33.79307], [-118.34875, 33.79282], [-118.34783, 33.79205], [-118.34783, 33.79015], [-118.34362, 33.78659], [-118.34517, 33.78551], [-118.34559, 33.7853], [-118.34583, 33.7852], [-118.34609, 33.78513], [-118.34641, 33.78506], [-118.34996, 33.78455], [-118.35025, 33.78449], [-118.35084, 33.78427], [-118.35136, 33.78464], [-118.35157, 33.78445], [-118.3532, 33.7856], [-118.35399, 33.79067]]]} | No Public Access 3 | 5917 | South Coast Park/Peter Weber Equestrian Center | 29016 | 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 | 141.298 | South Coast Park/Peter Weber Equestrian Ctr. | 0 | Local Recreation Area 3 | 4 | |
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 | |
1479 | 1479 | 1478 | {"type": "Polygon", "coordinates": [[[-121.62993, 36.69624], [-121.62762, 36.69442], [-121.62979, 36.69262], [-121.63183, 36.6944], [-121.63188, 36.69446], [-121.63189, 36.69452], [-121.63188, 36.69459], [-121.63186, 36.69463], [-121.62993, 36.69624]]]} | Open Access 1 | 10118 | Constitution Soccer Complex | 17603 | 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 | 19.339 | Constitution Soccer Complex | 0 | Local Recreation Area 3 | 4 | |
1632 | 1632 | 1631 | {"type": "Polygon", "coordinates": [[[-118.00413, 33.90582], [-118.00266, 33.9058], [-118.00229, 33.90591], [-118.0005, 33.9071], [-118.00033, 33.90729], [-118.00022, 33.90737], [-118.00018, 33.90743], [-117.99885, 33.90986], [-117.99444, 33.90988], [-117.99438, 33.90984], [-117.99434, 33.90424], [-117.99435, 33.90374], [-117.99441, 33.90318], [-117.99449, 33.90284], [-117.99455, 33.9028], [-118.00302, 33.90275], [-118.00303, 33.9028], [-118.00324, 33.90281], [-118.00329, 33.90286], [-118.0033, 33.90333], [-118.00333, 33.90358], [-118.00337, 33.90378], [-118.00343, 33.90396], [-118.00405, 33.90551], [-118.00413, 33.90582]]]} | Restricted Access 2 | 45404 | La Mirada Golf Course | 33111 | 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/wps/portal/dpr/ThingsToDo/Golf/La_Mirada_Golf_Course | Los Angeles 6 | 131.179 | La Mirada 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 | |
2429 | 2429 | 2428 | {"type": "Polygon", "coordinates": [[[-119.73275, 34.45416], [-119.73256, 34.45495], [-119.73033, 34.45569], [-119.73131, 34.45385], [-119.73248, 34.45385], [-119.73275, 34.45416]]]} | Open Access 1 | 17293 | Lauro Canyon Reservoir | 33319 | 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 | 6.232 | Lauro Canyon Reservoir | 0 | Local Recreation Area 3 | 4 | |
2615 | 2615 | 2614 | {"type": "Polygon", "coordinates": [[[-119.80483, 34.42522], [-119.80482, 34.42554], [-119.80247, 34.42582], [-119.8009, 34.42611], [-119.80039, 34.42613], [-119.79935, 34.42613], [-119.79881, 34.42614], [-119.79835, 34.42616], [-119.7981, 34.4262], [-119.79785, 34.42626], [-119.79761, 34.42634], [-119.79738, 34.42644], [-119.79607, 34.42714], [-119.7965, 34.42603], [-119.7965, 34.42592], [-119.79466, 34.42424], [-119.801, 34.42408], [-119.80117, 34.42409], [-119.80132, 34.42412], [-119.80156, 34.4242], [-119.80248, 34.42446], [-119.80249, 34.4255], [-119.80483, 34.42522]]]} | Open Access 1 | 17990 | More Mesa Open Space | 22473 | 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 | 36.882 | More Mesa OS | 0 | Local Recreation Area 3 | 4 | |
2694 | 2694 | 2693 | {"type": "Polygon", "coordinates": [[[-120.62642, 35.1044], [-120.62597, 35.10496], [-120.62525, 35.10457], [-120.6257, 35.10401], [-120.62642, 35.1044]]]} | Open Access 1 | 18257 | Oceano Memorial Campground | 23064 | 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 | 1.456 | Oceano Memorial Campground | 0 | Local Recreation Area 3 | 4 | |
2864 | 2864 | 2863 | {"type": "Polygon", "coordinates": [[[-119.8955, 34.43359], [-119.89489, 34.4336], [-119.89507, 34.4334], [-119.89518, 34.43315], [-119.89502, 34.43276], [-119.89396, 34.43277], [-119.89349, 34.43308], [-119.89327, 34.43291], [-119.89312, 34.43283], [-119.89296, 34.43279], [-119.89279, 34.43277], [-119.89158, 34.43278], [-119.89147, 34.43278], [-119.89124, 34.43274], [-119.89246, 34.43273], [-119.89311, 34.43267], [-119.89548, 34.43263], [-119.8955, 34.43359]]]} | Open Access 1 | 1923 | Winchester I Open Space | 27618 | 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.191 | Winchester I 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 | |
3211 | 3211 | 3210 | {"type": "Polygon", "coordinates": [[[-122.63748, 41.70784], [-122.63684, 41.70871], [-122.63636, 41.70858], [-122.63561, 41.70825], [-122.63577, 41.70803], [-122.63593, 41.70785], [-122.63621, 41.70776], [-122.63657, 41.70768], [-122.63678, 41.70769], [-122.63748, 41.70784]]]} | Open Access 1 | 28144 | Hibbard Field | 19892 | 365 | Siskiyou, County of 596 | County 3 | County Agency 3 | http://www.co.siskiyou.ca.us/ | County 3 | 365 | Siskiyou, County of 586 | County 3 | County Agency 3 | Siskiyou 28 | 2.667 | Hibbard Field | 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 | |
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 | |
3823 | 3823 | 3822 | {"type": "Polygon", "coordinates": [[[-119.79655, 34.42798], [-119.79651, 34.42886], [-119.79611, 34.42884], [-119.79604, 34.4287], [-119.7958, 34.4284], [-119.79655, 34.42798]]]} | Open Access 1 | 35233 | Rhoads Open Space | 28548 | 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 | 1.01 | Rhoads OS | 0 | Local Recreation Area 3 | 4 | |
4220 | 4220 | 4219 | {"type": "Polygon", "coordinates": [[[-119.22967, 34.44042], [-119.22934, 34.44104], [-119.22896, 34.44199], [-119.22891, 34.4424], [-119.2287, 34.44271], [-119.2267, 34.44309], [-119.22634, 34.44335], [-119.22505, 34.44413], [-119.22493, 34.44422], [-119.22486, 34.44385], [-119.22446, 34.44408], [-119.22421, 34.44417], [-119.22364, 34.44429], [-119.22324, 34.44458], [-119.22283, 34.44477], [-119.22248, 34.44279], [-119.22792, 34.44213], [-119.22748, 34.43959], [-119.22936, 34.43921], [-119.22967, 34.44042]]]} | Open Access 1 | 44996 | Soule Recreation Area | 25633 | 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 | 30.851 | Soule Rec. Area | 0 | Local Recreation Area 3 | 4 | |
4892 | 4892 | 4891 | {"type": "MultiPolygon", "coordinates": [[[[-118.15498, 33.83254], [-118.15491, 33.83579], [-118.15381, 33.83579], [-118.15367, 33.83568], [-118.15367, 33.83541], [-118.15336, 33.8354], [-118.15335, 33.83567], [-118.15358, 33.83568], [-118.15378, 33.83584], [-118.15123, 33.83584], [-118.15123, 33.83648], [-118.15303, 33.83854], [-118.15303, 33.83964], [-118.14813, 33.83963], [-118.14827, 33.83948], [-118.14837, 33.83933], [-118.14842, 33.83919], [-118.1485, 33.83886], [-118.15013, 33.83865], [-118.15122, 33.83875], [-118.15122, 33.8381], [-118.1496, 33.83658], [-118.14871, 33.83658], [-118.14676, 33.83715], [-118.14799, 33.83893], [-118.14829, 33.83889], [-118.14823, 33.83915], [-118.14819, 33.83926], [-118.14811, 33.83939], [-118.14799, 33.83951], [-118.14782, 33.83963], [-118.14742, 33.83963], [-118.14397, 33.83644], [-118.14405, 33.83636], [-118.14424, 33.83639], [-118.14429, 33.83617], [-118.14441, 33.83597], [-118.1462, 33.83409], [-118.14639, 33.83392], [-118.14756, 33.833], [-118.14768, 33.83283], [-118.14773, 33.8327], [-118.14775, 33.83255], [-118.14781, 33.83251], [-118.15469, 33.83253], [-118.1547, 33.83254], [-118.15498, 33.83254]]], [[[-118.15984, 33.8286], [-118.15959, 33.8286], [-118.15661, 33.83004], [-118.15469, 33.83035], [-118.15293, 33.83225], [-118.15, 33.83223], [-118.15104, 33.82949], [-118.15192, 33.82897], [-118.1541, 33.82898], [-118.15411, 33.82768], [-118.15982, 33.82769], [-118.15984, 33.8286]]]]} | Restricted Access 2 | 45718 | Lakewood Golf Course | 33113 | 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/wps/portal/dpr/ThingsToDo/Golf/Lakewood_Golf_Course | Los Angeles 6 | 176.286 | Lakewood GC | 0 | Local Recreation Area 3 | 4 |
4893 | 4893 | 4892 | {"type": "Polygon", "coordinates": [[[-118.16594, 33.93752], [-118.16221, 33.93558], [-118.16115, 33.93702], [-118.16153, 33.93723], [-118.16126, 33.93762], [-118.165, 33.9395], [-118.16218, 33.94234], [-118.16209, 33.94232], [-118.15913, 33.94078], [-118.16046, 33.93896], [-118.15653, 33.93691], [-118.15822, 33.93461], [-118.15991, 33.93242], [-118.16013, 33.93217], [-118.16097, 33.93257], [-118.16356, 33.93388], [-118.16407, 33.93321], [-118.16436, 33.9333], [-118.16477, 33.93321], [-118.16508, 33.93298], [-118.16609, 33.93537], [-118.16594, 33.93752]]]} | Restricted Access 2 | 45855 | Los Amigos Golf Course | 32491 | 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/wps/portal/dpr/!ut/p/b0/04_Sj9CPykssy0xPLMnMz0vMAfGjzOLdDAwM3P2dgo0MggwcDTxdQl3MnI3D3ANNDPULsh0VAQpfACU!/ | Los Angeles 6 | 120.886 | Los Amigos GC | 0 | Local Recreation Area 3 | 4 |
4969 | 4969 | 4968 | {"type": "Polygon", "coordinates": [[[-118.52638, 34.34108], [-118.52584, 34.34096], [-118.52536, 34.34088], [-118.52304, 34.34055], [-118.52197, 34.34042], [-118.52208, 34.33992], [-118.523, 34.33996], [-118.5235, 34.33945], [-118.52521, 34.3407], [-118.52551, 34.34042], [-118.52602, 34.34081], [-118.5261, 34.34068], [-118.52638, 34.34073], [-118.52638, 34.34108]]]} | Open Access 1 | 7304 | Michael D Antonovich Open Space | 6049 | 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://www.lamountains.com/parks.asp?parkid=8 | Los Angeles 6 | 6.265 | Michael D Antonovich OS | 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]);