units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
162 rows where AGNCY_LEV = 4 and MNG_AG_TYP = 2 sorted by AGNCY_TYP
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_TYP, GAP_STS
MNG_AGENCY >30
- Whittier, City of 18
- San Ramon, City of 17
- Manhattan Beach, City of 8
- Arcadia, City of 7
- Hollister, City of 6
- Fresno, City of 5
- Santa Ana, City of 5
- Los Angeles, City of 5
- Beverly Hills, City of 5
- Palmdale, City of 4
- Sierra Madre, City of 4
- Santa Clarita, City of 4
- Bellflower, City of 4
- Lawndale, City of 4
- San Diego, City of 3
- Carlsbad, City of 3
- San Bernardino, City of 3
- Pasadena, City of 3
- San Gabriel, City of 3
- Santa Maria, City of 2
- Glendora, City of 2
- Lake Elsinore, City of 2
- San Marcos, City of 2
- La Verne, City of 2
- Duarte, City of 2
- Clovis, City of 2
- South El Monte, City of 2
- Culver City, City of 1
- San Francisco, City and County of 1
- Santa Rosa, City of 1
- …
DES_TP 9
- Local Park 116
- Local Recreation Area 35
- Local Conservation Area 5
- Local Other or Unknown 1
- None 1
- None 1
- None 1
- None 1
- None 1
ACCESS_TYP 3
- Restricted Access 117
- Open Access 42
- No Public Access 3
MNG_AG_TYP 1
- City Agency · 162 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1433 | 1433 | 1432 | {"type": "Polygon", "coordinates": [[[-122.17854, 37.34566], [-122.17621, 37.35241], [-122.17291, 37.35273], [-122.17289, 37.35278], [-122.17225, 37.35279], [-122.17206, 37.34613], [-122.17207, 37.34577], [-122.17854, 37.34566]]]} | Open Access 1 | 47698 | Foothills Open Space Preserve | 31434 | 2079 | Midpeninsula Regional Open Space District 366 | Special District 4 | Recreation/Parks District 4 | http://www.openspace.org | Special District 4 | 1243 | Palo Alto, City of 157 | City 2 | City Agency 2 | Santa Clara 19 | 86.854 | Foothills OSP | 1975 | Local Conservation Area 4 | 2 | |
2506 | 2506 | 2505 | {"type": "Polygon", "coordinates": [[[-117.3015, 33.61798], [-117.3012, 33.61831], [-117.29877, 33.61679], [-117.29902, 33.61646], [-117.3015, 33.61798]]]} | Open Access 1 | 48910 | Regency-Heritage Park | 33631 | 2437 | Ortega Trail Recreation and Park District 529 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 1706 | Wildomar, City of 522 | City 2 | City Agency 2 | http://www.cityofwildomar.org/community/parks_trails/parks/regency-heritage_park | Riverside 10 | 3.114 | Regency-Heritage Park | 0 | Local Park 2 | 4 | |
5535 | 5535 | 5534 | {"type": "MultiPolygon", "coordinates": [[[[-122.3301, 41.32969], [-122.32966, 41.32948], [-122.32933, 41.32936], [-122.32896, 41.32924], [-122.32848, 41.32913], [-122.32799, 41.32903], [-122.32579, 41.32872], [-122.32486, 41.32867], [-122.3246, 41.32852], [-122.32434, 41.3284], [-122.3241, 41.32826], [-122.32371, 41.32797], [-122.32348, 41.32775], [-122.32331, 41.32754], [-122.32317, 41.32732], [-122.32306, 41.32707], [-122.3252, 41.32706], [-122.32523, 41.32672], [-122.32796, 41.32671], [-122.32797, 41.32705], [-122.32874, 41.32705], [-122.3293, 41.32805], [-122.32948, 41.32822], [-122.33008, 41.32931], [-122.3301, 41.32969]]], [[[-122.3283, 41.33063], [-122.32523, 41.33061], [-122.32522, 41.32953], [-122.32706, 41.32974], [-122.32743, 41.3298], [-122.32827, 41.32997], [-122.3283, 41.33063]]]]} | Open Access 1 | 25380 | Mount Shasta City Park | 22532 | 2244 | Mt. Shasta Recreation and Park District 628 | Special District 4 | Recreation/Parks District 4 | http://www.msrec.org/ | Special District 4 | 1703 | Mount Shasta, City of 787 | City 2 | City Agency 2 | Siskiyou 28 | 32.645 | Mount Shasta City Park | 0 | Local Park 2 | 4 | |
16853 | 16853 | 16852 | {"type": "Polygon", "coordinates": [[[-122.31005, 37.87748], [-122.30815, 37.87787], [-122.30808, 37.87787], [-122.30785, 37.87763], [-122.30714, 37.87584], [-122.30661, 37.87435], [-122.30873, 37.87383], [-122.31005, 37.87748]]]} | Open Access 1 | 46003 | Tom Bates Regional Sports Complex | 29211 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 1028 | Berkeley, City of 334 | City 2 | City Agency 2 | http://www.ci.berkeley.ca.us/Mayor/Home/Recreation_in_Berkeley.aspx | Alameda 17 | 19.935 | Tom Bates Reg. Sports Complex | 0 | Local Recreation Area 3 | 4 |
7464 | 7464 | 7463 | {"type": "Polygon", "coordinates": [[[-118.1847, 34.14373], [-118.1843, 34.1441], [-118.18411, 34.14425], [-118.18398, 34.14441], [-118.18362, 34.14471], [-118.18336, 34.14452], [-118.18363, 34.14438], [-118.18361, 34.14434], [-118.1838, 34.14425], [-118.1839, 34.14415], [-118.18417, 34.14373], [-118.18417, 34.14368], [-118.18413, 34.14353], [-118.18414, 34.14341], [-118.18415, 34.14338], [-118.18422, 34.14338], [-118.18428, 34.14334], [-118.18431, 34.14328], [-118.18429, 34.14323], [-118.18433, 34.14321], [-118.18471, 34.14364], [-118.18472, 34.14368], [-118.1847, 34.14373]]]} | Open Access 1 | 6961 | Richard Alatorre Park | 31684 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | https://www.laparks.org/park/richard-alatorre | Los Angeles 6 | 1.404 | Richard Alatorre Park | 0 | Local Park 2 | 4 |
15247 | 15247 | 15246 | {"type": "MultiPolygon", "coordinates": [[[[-118.49458, 34.3588], [-118.49075, 34.36144], [-118.48897, 34.36142], [-118.4889, 34.35963], [-118.48493, 34.35958], [-118.48502, 34.35379], [-118.49356, 34.35386], [-118.49458, 34.3588]]], [[[-118.49593, 34.3615], [-118.49593, 34.3615], [-118.49243, 34.36146], [-118.49569, 34.35921], [-118.49573, 34.35941], [-118.49593, 34.3615]]], [[[-118.50276, 34.35978], [-118.50268, 34.36302], [-118.50179, 34.36301], [-118.4977, 34.36262], [-118.49766, 34.36153], [-118.49695, 34.36151], [-118.49677, 34.35971], [-118.50065, 34.35975], [-118.50113, 34.35577], [-118.50123, 34.35577], [-118.50186, 34.35977], [-118.50276, 34.35978]]], [[[-118.50605, 34.35776], [-118.5061, 34.35822], [-118.50589, 34.35954], [-118.50557, 34.36001], [-118.50551, 34.36061], [-118.50407, 34.36097], [-118.50435, 34.35233], [-118.50448, 34.35247], [-118.50466, 34.35309], [-118.50466, 34.35327], [-118.50481, 34.35353], [-118.50561, 34.35585], [-118.50562, 34.35644], [-118.50588, 34.35693], [-118.50596, 34.35778], [-118.50605, 34.35776]]]]} | Open Access 1 | 46278 | Whitney Elsmere Open Space | 29563 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 1319 | Santa Clarita, City of 322 | City 2 | City Agency 2 | Los Angeles 6 | 233.794 | Whitney Elsmere OS | 0 | Local Recreation Area 3 | 4 | |
54 | 54 | 53 | {"type": "Polygon", "coordinates": [[[-119.73175, 36.7591], [-119.73175, 36.75936], [-119.73077, 36.75936], [-119.72949, 36.75856], [-119.72945, 36.75845], [-119.72945, 36.75759], [-119.73145, 36.7576], [-119.73104, 36.75782], [-119.73095, 36.75784], [-119.73086, 36.75791], [-119.73087, 36.75827], [-119.73094, 36.75851], [-119.73101, 36.75863], [-119.73118, 36.75885], [-119.73131, 36.75898], [-119.73139, 36.75904], [-119.73157, 36.75909], [-119.73175, 36.7591]]]} | Open Access 1 | 125 | Carozza Park | 16891 | 2036 | Fresno Metropolitan Flood Control District 29 | Special District 4 | Flood District 8 | http://www.fresnofloodcontrol.org/ | Special District 4 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 6.025 | Carozza Park | 0 | Local Park 2 | 4 | |
65 | 65 | 64 | {"type": "Polygon", "coordinates": [[[-119.79845, 36.71057], [-119.79843, 36.71219], [-119.7971, 36.71219], [-119.79701, 36.71221], [-119.79693, 36.71228], [-119.79644, 36.71228], [-119.79644, 36.71058], [-119.79845, 36.71057]]]} | Open Access 1 | 189 | Carver Park | 16927 | 2036 | Fresno Metropolitan Flood Control District 29 | Special District 4 | Flood District 8 | http://www.fresnofloodcontrol.org/ | Special District 4 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 8.052 | Carver Park | 0 | Local Park 2 | 4 | |
2710 | 2710 | 2709 | {"type": "Polygon", "coordinates": [[[-118.17189, 33.79348], [-118.17189, 33.79369], [-118.17147, 33.79396], [-118.17068, 33.79345], [-118.17083, 33.79329], [-118.17083, 33.79327], [-118.16931, 33.79229], [-118.16929, 33.79021], [-118.17188, 33.79021], [-118.17189, 33.79321], [-118.17163, 33.79322], [-118.17163, 33.79347], [-118.17189, 33.79348]]]} | Open Access 1 | 6683 | Chittick Field | 29942 | 2272 | Los Angeles County Flood Control District 287 | Special District 4 | Flood District 8 | http://dpw.lacounty.gov/lacfcd/ | Special District 4 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 19.452 | Chittick Field | 2014 | Local Recreation Area 3 | 4 | |
3622 | 3622 | 3621 | {"type": "Polygon", "coordinates": [[[-119.79574, 36.86151], [-119.79571, 36.86193], [-119.79566, 36.86217], [-119.79552, 36.86243], [-119.79533, 36.86264], [-119.79448, 36.86334], [-119.79445, 36.86334], [-119.79405, 36.86302], [-119.79425, 36.86289], [-119.79478, 36.86239], [-119.79531, 36.86194], [-119.79547, 36.86178], [-119.79564, 36.86155], [-119.79574, 36.86151]]]} | Open Access 1 | 47312 | Audubon Pocket Park | 31019 | 2036 | Fresno Metropolitan Flood Control District 29 | Special District 4 | Flood District 8 | http://www.fresnofloodcontrol.org/ | Special District 4 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 2.439 | Audubon PP | 0 | Local Park 2 | 4 | |
4425 | 4425 | 4424 | {"type": "MultiPolygon", "coordinates": [[[[-118.10901, 33.88199], [-118.10866, 33.88199], [-118.10866, 33.88024], [-118.109, 33.88024], [-118.10901, 33.88199]]], [[[-118.10903, 33.88235], [-118.109, 33.88308], [-118.10866, 33.88309], [-118.10866, 33.88235], [-118.10903, 33.88235]]], [[[-118.10901, 33.8838], [-118.10866, 33.8838], [-118.10866, 33.88327], [-118.109, 33.88327], [-118.10899, 33.88344], [-118.10901, 33.8838]]], [[[-118.10904, 33.88598], [-118.10883, 33.88598], [-118.10867, 33.88576], [-118.10866, 33.88416], [-118.10901, 33.88416], [-118.10904, 33.88598]]], [[[-118.10902, 33.88748], [-118.10884, 33.88749], [-118.10874, 33.88743], [-118.10869, 33.88737], [-118.10868, 33.88706], [-118.10902, 33.88706], [-118.10902, 33.88748]]]]} | Open Access 1 | 46310 | Caruthers Park North | 29601 | 2272 | Los Angeles County Flood Control District 287 | Special District 4 | Flood District 8 | http://dpw.lacounty.gov/lacfcd/ | Special District 4 | 1024 | Bellflower, City of 443 | City 2 | City Agency 2 | https://www.bellflower.org/home/index.asp?page=132 | Los Angeles 6 | 4.548 | Caruthers Park North | 0 | Local Park 2 | 4 |
5594 | 5594 | 5593 | {"type": "Polygon", "coordinates": [[[-120.42701, 34.97493], [-120.42406, 34.97488], [-120.42406, 34.97395], [-120.42418, 34.97395], [-120.42422, 34.97386], [-120.42662, 34.97474], [-120.42701, 34.97493]]]} | Open Access 1 | 48890 | Jim May Park | 33608 | 2141 | Santa Barbara Flood Control and Water Conserv. District 46 | Special District 4 | Flood District 8 | http://cosb.countyofsb.org/pwd/pwwater.aspx?id=3572 | Special District 4 | 1322 | Santa Maria, City of 35 | City 2 | City Agency 2 | https://www.cityofsantamaria.org/city-government/departments/recreation-and-parks/visit-your-parks/view-park-photos-descriptions#Jim%20May%20Park | Santa Barbara 7 | 4.071 | Jim May Park | 0 | Local Park 2 | 4 |
5602 | 5602 | 5601 | {"type": "Polygon", "coordinates": [[[-119.86893, 36.80535], [-119.86802, 36.80535], [-119.868, 36.8046], [-119.86867, 36.80459], [-119.86867, 36.80473], [-119.86875, 36.80487], [-119.86892, 36.80516], [-119.86893, 36.80535]]]} | Open Access 1 | 1774 | Basin AH1 Dog Park | 15848 | 2036 | Fresno Metropolitan Flood Control District 29 | Special District 4 | Flood District 8 | http://www.fresnofloodcontrol.org/ | Special District 4 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 1.48 | Basin AH1 Dog Park | 0 | Local Park 2 | 4 | |
6372 | 6372 | 6371 | {"type": "Polygon", "coordinates": [[[-119.7115, 36.79474], [-119.71149, 36.79491], [-119.70923, 36.79495], [-119.70923, 36.79464], [-119.70928, 36.79459], [-119.70973, 36.79456], [-119.71014, 36.7945], [-119.71114, 36.79423], [-119.71146, 36.79416], [-119.71146, 36.79424], [-119.71143, 36.79428], [-119.71144, 36.79468], [-119.7115, 36.79474]]]} | Open Access 1 | 1759 | Helm Ranch Community Park | 30988 | 2036 | Fresno Metropolitan Flood Control District 29 | Special District 4 | Flood District 8 | http://www.fresnofloodcontrol.org/ | Special District 4 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | Fresno 9 | 2.786 | Helm Ranch Community Park | 0 | Local Park 2 | 4 | |
7467 | 7467 | 7466 | {"type": "Polygon", "coordinates": [[[-118.06257, 34.17208], [-118.06249, 34.17232], [-118.06241, 34.17236], [-118.06222, 34.17278], [-118.06187, 34.17341], [-118.06142, 34.17342], [-118.06142, 34.17387], [-118.06102, 34.17388], [-118.06072, 34.1736], [-118.06072, 34.17308], [-118.06093, 34.17289], [-118.06093, 34.17229], [-118.0607, 34.17227], [-118.06095, 34.17179], [-118.06095, 34.1716], [-118.06079, 34.17133], [-118.06066, 34.17118], [-118.06022, 34.17079], [-118.06021, 34.17076], [-118.06058, 34.17089], [-118.06185, 34.17088], [-118.06206, 34.171], [-118.06249, 34.17174], [-118.06257, 34.17208]]]} | Open Access 1 | 6977 | Bailey Canyon Wilderness Park | 15758 | 2272 | Los Angeles County Flood Control District 287 | Special District 4 | Flood District 8 | http://dpw.lacounty.gov/lacfcd/ | Special District 4 | 1333 | Sierra Madre, City of 308 | City 2 | City Agency 2 | Los Angeles 6 | 10.125 | Bailey Canyon Wilderness Park | 0 | Local Conservation Area 4 | 2 | |
7471 | 7471 | 7470 | {"type": "Polygon", "coordinates": [[[-118.06342, 34.17933], [-118.05688, 34.17932], [-118.05686, 34.17576], [-118.05766, 34.17576], [-118.05765, 34.17466], [-118.05846, 34.17466], [-118.05839, 34.17505], [-118.05848, 34.17535], [-118.05896, 34.17535], [-118.05898, 34.17516], [-118.06012, 34.1752], [-118.06059, 34.17439], [-118.06059, 34.17422], [-118.06048, 34.17406], [-118.06054, 34.17377], [-118.06073, 34.1736], [-118.06102, 34.17388], [-118.06124, 34.17387], [-118.06141, 34.17387], [-118.06142, 34.17341], [-118.06187, 34.17341], [-118.06166, 34.17408], [-118.06185, 34.17441], [-118.06201, 34.17565], [-118.062, 34.17583], [-118.0634, 34.17583], [-118.06342, 34.17933]]]} | Open Access 1 | 6979 | Bailey Canyon Wilderness | 29957 | 2272 | Los Angeles County Flood Control District 287 | Special District 4 | Flood District 8 | http://dpw.lacounty.gov/lacfcd/ | Special District 4 | 1333 | Sierra Madre, City of 308 | City 2 | City Agency 2 | Los Angeles 6 | 71.132 | Bailey Canyon Wilderness | 0 | Local Conservation Area 4 | 2 | |
12087 | 12087 | 12086 | {"type": "MultiPolygon", "coordinates": [[[[-118.41597, 33.98684], [-118.41682, 33.98637], [-118.4172, 33.9861], [-118.42424, 33.98091], [-118.42423, 33.98089], [-118.42749, 33.97856], [-118.42905, 33.97752], [-118.43012, 33.97684], [-118.43162, 33.97594], [-118.4325, 33.97537], [-118.43253, 33.97541], [-118.43245, 33.97547], [-118.4325, 33.97555], [-118.43243, 33.97558], [-118.4323, 33.9756], [-118.43172, 33.97596], [-118.43135, 33.97616], [-118.43008, 33.97693], [-118.42908, 33.97756], [-118.42733, 33.97874], [-118.42729, 33.97875], [-118.42705, 33.97891], [-118.4252, 33.98023], [-118.42496, 33.98044], [-118.42282, 33.98202], [-118.42282, 33.98203], [-118.42297, 33.98218], [-118.42288, 33.98224], [-118.42275, 33.98209], [-118.42269, 33.98213], [-118.41929, 33.9846], [-118.41722, 33.98613], [-118.41612, 33.98697], [-118.41605, 33.98692], [-118.41584, 33.98705], [-118.41533, 33.98744], [-118.41532, 33.98748], [-118.41257, 33.98955], [-118.4119, 33.98993], [-118.41174, 33.99009], [-118.4118, 33.99018], [-118.41172, 33.9902], [-118.40635, 33.99335], [-118.40617, 33.99349], [-118.40518, 33.99448], [-118.40502, 33.99457], [-118.405, 33.99449], [-118.40512, 33.99441], [-118.40631, 33.99332], [-118.41069, 33.99074], [-118.41186, 33.98988], [-118.41254, 33.98952], [-118.41525, 33.98747], [-118.41575, 33.98698], [-118.41597, 33.98684]]], [[[-118.40476, 33.9948], [-118.40448, 33.99506], [-118.40385, 33.99577], [-118.40371, 33.99594], [-118.403, 33.99677], [-118.40288, 33.99699], [-118.40277, 33.99766], [-118.40238, 33.99838], [-118.40239, 33.99842], [-118.4016, 33.9998], [-118.40152, 33.99976], [-118.40198, 33.99897], [-118.40229, 33.99853], [-118.40229, 33.99852], [-118.40137, 33.99966], [-118.40126, 33.99987], [-118.4012, 33.99986], [-118.40137, 33.99952], [-118.40229, 33.99834], [-118.40271, 33.99759], [-118.40282, 33.99697], [-118.40295, 33.99674], [-118.4036, 33.996], [-118.40378, 33.99575], [-118.40399, 33.99553], [-118.40442, 33.99499], [-118.4045, 33.99491], [-118.40476, 33.9948]]], [[[-118.40076, 34.00143], [-118.40066, 34.00171], [-118.40048, 34.00221], [-118.40042, 34.00218], [-118.40059, 34.00163], [-118.40068, 34.00143], [-118.40076, 34.00143]]], [[[-118.37695, 34.02689], [-118.37693, 34.02697], [-118.37689, 34.02697], [-118.37687, 34.02699], [-118.37674, 34.02699], [-118.37649, 34.02765], [-118.3765, 34.02765], [-118.37664, 34.02745], [-118.3768, 34.02705], [-118.37687, 34.02701], [-118.37669, 34.02745], [-118.37653, 34.0277], [-118.3764, 34.02785], [-118.37638, 34.0279], [-118.37635, 34.02789], [-118.37669, 34.02699], [-118.37625, 34.02698], [-118.37626, 34.02689], [-118.37623, 34.02686], [-118.37627, 34.02684], [-118.37632, 34.02687], [-118.37672, 34.02687], [-118.37681, 34.02654], [-118.37689, 34.02614], [-118.37694, 34.02617], [-118.37688, 34.02654], [-118.37678, 34.02687], [-118.37692, 34.02687], [-118.37692, 34.02688], [-118.37695, 34.02689]]]]} | Open Access 1 | 46847 | Ballona Creek Trail and Bike Path | 30330 | 2272 | Los Angeles County Flood Control District 287 | Special District 4 | Flood District 8 | http://dpw.lacounty.gov/lacfcd/ | Special District 4 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 7.103 | Ballona Creek Trail and Bike Path | 0 | Local Recreation Area 3 | 4 | |
12179 | 12179 | 12178 | {"type": "MultiPolygon", "coordinates": [[[[-118.38534, 34.02767], [-118.38533, 34.02775], [-118.38316, 34.02755], [-118.38313, 34.02751], [-118.38309, 34.0275], [-118.38298, 34.02753], [-118.38198, 34.02744], [-118.38195, 34.02739], [-118.38189, 34.02736], [-118.38182, 34.02738], [-118.38178, 34.02742], [-118.38094, 34.02734], [-118.38089, 34.02732], [-118.38082, 34.02733], [-118.38001, 34.02726], [-118.3797, 34.02726], [-118.37928, 34.02722], [-118.37927, 34.02723], [-118.37835, 34.02715], [-118.37835, 34.0271], [-118.37701, 34.02698], [-118.37683, 34.02711], [-118.37688, 34.02697], [-118.37693, 34.02697], [-118.37696, 34.02687], [-118.37985, 34.02713], [-118.38058, 34.02722], [-118.38187, 34.02732], [-118.38261, 34.02742], [-118.38439, 34.0276], [-118.38534, 34.02767]]], [[[-118.37843, 34.02209], [-118.37823, 34.02223], [-118.37792, 34.02253], [-118.37772, 34.02278], [-118.37754, 34.0231], [-118.37743, 34.02339], [-118.37735, 34.02373], [-118.37719, 34.02459], [-118.37694, 34.02617], [-118.37689, 34.02614], [-118.37706, 34.02505], [-118.37732, 34.02354], [-118.37746, 34.02312], [-118.37759, 34.02288], [-118.37777, 34.02264], [-118.37802, 34.02233], [-118.37831, 34.02207], [-118.37843, 34.02209]]], [[[-118.3894, 34.01753], [-118.38804, 34.01937], [-118.38793, 34.0195], [-118.3877, 34.01973], [-118.38746, 34.01993], [-118.38719, 34.02011], [-118.38689, 34.02028], [-118.38683, 34.02025], [-118.38618, 34.02045], [-118.38437, 34.02073], [-118.38192, 34.02117], [-118.38012, 34.02145], [-118.37941, 34.02159], [-118.37886, 34.02181], [-118.3786, 34.02198], [-118.37848, 34.02196], [-118.37891, 34.02172], [-118.37924, 34.02159], [-118.37958, 34.02149], [-118.37995, 34.02141], [-118.38256, 34.021], [-118.38282, 34.02093], [-118.38381, 34.02079], [-118.38605, 34.02043], [-118.38691, 34.02013], [-118.38744, 34.0198], [-118.38767, 34.01961], [-118.38797, 34.01929], [-118.38927, 34.01747], [-118.3894, 34.01753]]], [[[-118.39626, 34.00748], [-118.39489, 34.00787], [-118.39486, 34.00782], [-118.39472, 34.00783], [-118.39467, 34.00785], [-118.39467, 34.00787], [-118.39449, 34.00792], [-118.39447, 34.00791], [-118.3943, 34.00795], [-118.39392, 34.00807], [-118.39372, 34.00814], [-118.39342, 34.00828], [-118.39314, 34.00844], [-118.39311, 34.00842], [-118.39299, 34.00851], [-118.39295, 34.00854], [-118.39297, 34.00856], [-118.39284, 34.00866], [-118.39282, 34.00865], [-118.39262, 34.00883], [-118.39236, 34.00915], [-118.39222, 34.00938], [-118.39211, 34.00962], [-118.39203, 34.00987], [-118.39197, 34.01026], [-118.39197, 34.01111], [-118.392, 34.01112], [-118.39205, 34.01123], [-118.392, 34.01128], [-118.392, 34.01136], [-118.39205, 34.01142], [-118.39214, 34.01256], [-118.39142, 34.01421], [-118.39072, 34.01513], [-118.39064, 34.01526], [-118.39061, 34.01536], [-118.3904, 34.01569], [-118.39004, 34.0162], [-118.39001, 34.0163], [-118.38976, 34.01679], [-118.38968, 34.01708], [-118.38946, 34.01743], [-118.3893, 34.01735], [-118.39002, 34.01615], [-118.39057, 34.01534], [-118.39061, 34.01523], [-118.39138, 34.01422], [-118.39175, 34.01334], [-118.39194, 34.01259], [-118.39199, 34.01209], [-118.392, 34.01137], [-118.39195, 34.01131], [-118.39197, 34.01112], [-118.39192, 34.01109], [-118.39192, 34.01039], [-118.39193, 34.01012], [-118.39198, 34.00986], [-118.39206, 34.00961], [-118.39218, 34.00936], [-118.39232, 34.00912], [-118.3925, 34.0089], [-118.3928, 34.00861], [-118.39311, 34.00838], [-118.39338, 34.00823], [-118.39386, 34.00805], [-118.39482, 34.00775], [-118.39482, 34.00772], [-118.39611, 34.00728], [-118.39626, 34.00748]]], [[[-118.40046, 34.0022], [-118.39956, 34.00495], [-118.39937, 34.00545], [-118.39916, 34.00583], [-118.39902, 34.00601], [-118.39899, 34.006], [-118.39878, 34.00623], [-118.39844, 34.00653], [-118.39818, 34.0067], [-118.3979, 34.00686], [-118.39739, 34.00708], [-118.39641, 34.00737], [-118.39631, 34.00723], [-118.39746, 34.00699], [-118.39765, 34.00694], [-118.398, 34.00676], [-118.39838, 34.0065], [-118.39877, 34.00616], [-118.39901, 34.00588], [-118.39842, 34.00569], [-118.39834, 34.0057], [-118.39795, 34.00605], [-118.39791, 34.00603], [-118.39823, 34.0057], [-118.39835, 34.00555], [-118.39848, 34.00532], [-118.39858, 34.00535], [-118.39845, 34.00565], [-118.39904, 34.00584], [-118.39907, 34.00582], [-118.39922, 34.00559], [-118.3999, 34.00373], [-118.40042, 34.00218], [-118.40046, 34.0022]]], [[[-118.40141, 34.00002], [-118.40121, 34.00039], [-118.40123, 34.00041], [-118.40094, 34.00091], [-118.40074, 34.00142], [-118.40068, 34.00143], [-118.4012, 33.99986], [-118.40126, 33.99987], [-118.40106, 34.00058], [-118.40138, 34.0], [-118.40141, 34.00002]]], [[[-118.40502, 33.99457], [-118.40495, 33.99462], [-118.40476, 33.9948], [-118.4045, 33.99491], [-118.40491, 33.99456], [-118.405, 33.99449], [-118.40502, 33.99457]]]]} | Open Access 1 | 46848 | Ballona Creek Trail and Bike Path | 30331 | 2272 | Los Angeles County Flood Control District 287 | Special District 4 | Flood District 8 | http://dpw.lacounty.gov/lacfcd/ | Special District 4 | 1075 | Culver City, City of 18 | City 2 | City Agency 2 | Los Angeles 6 | 9.968 | Ballona Creek Trail and Bike Path | 0 | Local Recreation Area 3 | 4 | |
14434 | 14434 | 14433 | {"type": "Polygon", "coordinates": [[[-119.76952, 36.82039], [-119.76941, 36.82058], [-119.76874, 36.82111], [-119.76873, 36.82129], [-119.76932, 36.82178], [-119.76823, 36.82264], [-119.76813, 36.82282], [-119.76773, 36.82282], [-119.76774, 36.8215], [-119.76936, 36.82023], [-119.76952, 36.82039]]]} | Open Access 1 | 47091 | First & Bullard Park | 30752 | 2036 | Fresno Metropolitan Flood Control District 29 | Special District 4 | Flood District 8 | http://www.fresnofloodcontrol.org/ | Special District 4 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 5.08 | First & Bullard Park | 0 | Local Park 2 | 4 | |
14469 | 14469 | 14468 | {"type": "Polygon", "coordinates": [[[-119.74078, 36.76666], [-119.74078, 36.76756], [-119.73882, 36.76755], [-119.73863, 36.76741], [-119.73864, 36.76569], [-119.73984, 36.7657], [-119.73982, 36.76611], [-119.73979, 36.76627], [-119.73981, 36.76632], [-119.73994, 36.76646], [-119.74007, 36.76659], [-119.7402, 36.76665], [-119.74078, 36.76666]]]} | Open Access 1 | 47100 | Basin V Park | 30759 | 2036 | Fresno Metropolitan Flood Control District 29 | Special District 4 | Flood District 8 | http://www.fresnofloodcontrol.org/ | Special District 4 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | http://www.fresnofloodcontrol.org/wp-content/uploads/2015/01/Map-of-parks.pdf | Fresno 9 | 7.59 | Basin V 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]);