units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
485 rows where DES_TP = 4 sorted by PARK_URL
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Midpeninsula Regional Open Space District 50
- East Bay Regional Park District 40
- San Diego, County of 35
- Marin County Open Space District 33
- Mountains Recreation and Conservation Authority 21
- Santa Clara Valley Open Space Authority 19
- Orange, County of 18
- Los Angeles, County of 15
- San Diego, City of 9
- Riverside County Habitat Conservation Agency 9
- Sonoma County Agricultural Preservation and Open Space District 8
- Chico, City of 7
- San Luis Obispo, County of 5
- Glendora, City of 5
- Redlands, City of 5
- Burbank, City of 5
- Riverside, County of 5
- Sonoma County Regional Parks Dept., County of 5
- Santa Barbara, County of 4
- Watsonville, City of 4
- Monterey Peninsula Regional Park District 4
- Napa County Regional Park and Open Space District 4
- Marin County Parks Department, County of 4
- Palo Alto, City of 4
- Gilroy, City of 4
- Sacramento, County of 4
- Santa Cruz, County of 3
- Los Angeles, City of 3
- Carlsbad, City of 3
- Riverside County Regional Park and Open Space District 3
- …
MNG_AG_TYP 15
- Recreation/Parks District 171
- City Agency 131
- County Agency 97
- Open Space District 34
- County Agency - Parks 12
- Water District 4
- Transportation Agency 3
- County Agency - Other 2
- Flood District 2
- Port/Harbor District 2
- Joint Powers Authority 2
- Conservation District 2
- Irrigation District 1
- Community Services District 1
- Special District - Other 1
ACCESS_TYP 4
- Open Access 334
- No Public Access 76
- Restricted Access 44
- Unknown Access 11
DES_TP 1
- Local Conservation Area · 465 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1378 | 1378 | 1377 | {"type": "Polygon", "coordinates": [[[-117.77409, 34.77926], [-117.77404, 34.78659], [-117.76531, 34.78638], [-117.76533, 34.77908], [-117.77409, 34.77926]]]} | Open Access 1 | 8395 | Phacelia Wildlife Sanctuary | 23638 | 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 | 160.496 | Phacelia Wildlife Sanctuary | 0 | Local Conservation Area 4 | 2 | |
1409 | 1409 | 1408 | {"type": "Polygon", "coordinates": [[[-122.22844, 38.49945], [-122.2279, 38.50313], [-122.22773, 38.50628], [-122.22303, 38.50615], [-122.22259, 38.50313], [-122.21653, 38.50301], [-122.21525, 38.49979], [-122.21427, 38.50009], [-122.21463, 38.49794], [-122.21505, 38.49581], [-122.2195, 38.49582], [-122.22405, 38.49579], [-122.22333, 38.49946], [-122.22844, 38.49945]]]} | Open Access 1 | 47680 | Berryessa Vista Wilderness Park | 31419 | 2268 | Napa County Regional Park and Open Space District 362 | Special District 4 | Recreation/Parks District 4 | http://napaoutdoors.org/ | Special District 4 | 2268 | Napa County Regional Park and Open Space District 108 | Special District 4 | Recreation/Parks District 4 | Napa 11 | 223.82 | Berryessa Vista Wilderness Park | 0 | Local Conservation Area 4 | 2 | |
1429 | 1429 | 1428 | {"type": "Polygon", "coordinates": [[[-117.00998, 32.57781], [-117.00559, 32.57765], [-117.00559, 32.57912], [-117.00537, 32.57895], [-117.00513, 32.57883], [-117.00486, 32.57878], [-117.0046, 32.57878], [-117.00434, 32.57884], [-117.00415, 32.57892], [-117.00402, 32.579], [-117.00369, 32.57861], [-117.00357, 32.57838], [-117.00352, 32.5782], [-117.0035, 32.57805], [-117.0035, 32.57572], [-117.00456, 32.57575], [-117.00457, 32.57563], [-117.00487, 32.57547], [-117.00504, 32.57543], [-117.00514, 32.57544], [-117.00571, 32.5757], [-117.00584, 32.5757], [-117.00599, 32.57551], [-117.00621, 32.57533], [-117.00643, 32.57533], [-117.00656, 32.57537], [-117.0068, 32.57512], [-117.00705, 32.57482], [-117.00727, 32.57423], [-117.00733, 32.57399], [-117.00696, 32.57363], [-117.00645, 32.57334], [-117.00621, 32.57316], [-117.00602, 32.57284], [-117.00594, 32.57263], [-117.00594, 32.57243], [-117.00626, 32.57237], [-117.00647, 32.57236], [-117.00649, 32.57158], [-117.00647, 32.57157], [-117.00652, 32.57069], [-117.0065, 32.57067], [-117.00652, 32.57059], [-117.00652, 32.57031], [-117.00654, 32.5703], [-117.00654, 32.56915], [-117.00618, 32.56914], [-117.00587, 32.56895], [-117.00586, 32.56882], [-117.00553, 32.56882], [-117.00553, 32.56854], [-117.00572, 32.56854], [-117.00575, 32.56846], [-117.00583, 32.56841], [-117.00749, 32.56842], [-117.00798, 32.56847], [-117.00925, 32.56848], [-117.00925, 32.56886], [-117.00841, 32.56886], [-117.0084, 32.56946], [-117.00888, 32.5703], [-117.00988, 32.5703], [-117.00998, 32.57781]]]} | Restricted Access 2 | 47693 | Dennery Preserve | 31429 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 98.129 | Dennery Preserve | 0 | Local Conservation Area 4 | 2 | |
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 | |
1582 | 1582 | 1581 | {"type": "Polygon", "coordinates": [[[-117.82912, 34.14946], [-117.82885, 34.14936], [-117.82829, 34.14947], [-117.82773, 34.14985], [-117.82742, 34.15028], [-117.82749, 34.15045], [-117.82786, 34.15061], [-117.82438, 34.15057], [-117.82438, 34.14914], [-117.82357, 34.14912], [-117.82356, 34.15056], [-117.82044, 34.15052], [-117.82046, 34.14695], [-117.82316, 34.14695], [-117.82342, 34.14662], [-117.82369, 34.14649], [-117.82447, 34.14649], [-117.82481, 34.14653], [-117.8251, 34.14658], [-117.82536, 34.1467], [-117.8256, 34.14692], [-117.82593, 34.14718], [-117.82618, 34.14742], [-117.82624, 34.14755], [-117.82616, 34.14804], [-117.8262, 34.14824], [-117.82629, 34.14838], [-117.82642, 34.14844], [-117.82655, 34.14842], [-117.82667, 34.14838], [-117.82701, 34.14807], [-117.82734, 34.14792], [-117.82798, 34.14756], [-117.82833, 34.14752], [-117.82857, 34.14755], [-117.82863, 34.14754], [-117.82857, 34.14739], [-117.82859, 34.14727], [-117.82865, 34.14713], [-117.82884, 34.14698], [-117.82912, 34.14698], [-117.82912, 34.14946]]]} | No Public Access 3 | 12131 | Bluebird Preserve | 32639 | 1120 | Glendora, City of 76 | City 2 | City Agency 2 | http://www.ci.glendora.ca.us/departments-services/parks-recreation-senior-services | City 2 | 1120 | Glendora, City of 74 | City 2 | City Agency 2 | Los Angeles 6 | 68.179 | Bluebird Preserve | 0 | Local Conservation Area 4 | 2 | |
1618 | 1618 | 1617 | {"type": "Polygon", "coordinates": [[[-119.74281, 34.40401], [-119.74274, 34.40423], [-119.74231, 34.40436], [-119.7421, 34.40437], [-119.74078, 34.40476], [-119.7407, 34.40454], [-119.74281, 34.40401]]]} | Open Access 1 | 13836 | Douglas Family Reserve | 18242 | 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.079 | Douglas Family Reserve | 0 | Local Conservation Area 4 | 2 | |
1720 | 1720 | 1719 | {"type": "Polygon", "coordinates": [[[-120.83252, 35.33196], [-120.83067, 35.3336], [-120.83044, 35.33382], [-120.82384, 35.33374], [-120.82365, 35.33357], [-120.82366, 35.33193], [-120.83252, 35.33196]]]} | Open Access 1 | 14878 | Elfin Forest Natural Preserve | 18558 | 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 | 35.806 | Elfin Forest Natural Preserve | 0 | Local Conservation Area 4 | 2 | |
1834 | 1834 | 1833 | {"type": "Polygon", "coordinates": [[[-122.29139, 37.56829], [-122.29135, 37.56831], [-122.2913, 37.56829], [-122.29123, 37.56825], [-122.29109, 37.56813], [-122.29095, 37.56795], [-122.29089, 37.56778], [-122.29092, 37.56774], [-122.29111, 37.5678], [-122.29127, 37.56788], [-122.2914, 37.568], [-122.29143, 37.56813], [-122.29141, 37.56827], [-122.29139, 37.56829]]]} | Open Access 1 | 14019 | Marina Lagoon Wildlife Island | 21829 | 1310 | San Mateo, City of 98 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | San Mateo 15 | 0.388 | Marina Lagoon Wildlife Island | 1962 | Local Conservation Area 4 | 2 | |
1857 | 1857 | 1856 | {"type": "Polygon", "coordinates": [[[-119.08916, 35.30331], [-119.0891, 35.30338], [-119.08883, 35.30342], [-119.08844, 35.30351], [-119.08824, 35.30353], [-119.08751, 35.30203], [-119.08796, 35.30189], [-119.08883, 35.30171], [-119.0889, 35.30193], [-119.08916, 35.30331]]]} | Open Access 1 | 15859 | Wilderness Park | 27511 | 1019 | Bakersfield, City of 248 | City 2 | City Agency 2 | http://www.bakersfieldcity.us/recreation/ | City 2 | 1019 | Bakersfield, City of 244 | City 2 | City Agency 2 | Kern 36 | 4.843 | Wilderness Park | 0 | Local Conservation Area 4 | 2 | |
1904 | 1904 | 1903 | {"type": "MultiPolygon", "coordinates": [[[[-121.61887, 36.71254], [-121.61886, 36.71261], [-121.6185, 36.71307], [-121.61816, 36.71343], [-121.6178, 36.71378], [-121.61758, 36.71404], [-121.61734, 36.71441], [-121.61711, 36.71491], [-121.61681, 36.71483], [-121.61679, 36.71478], [-121.61695, 36.71444], [-121.61718, 36.71404], [-121.61734, 36.71384], [-121.61755, 36.7136], [-121.61799, 36.71318], [-121.61822, 36.71293], [-121.61843, 36.71266], [-121.61858, 36.71244], [-121.61862, 36.71242], [-121.61865, 36.71242], [-121.61885, 36.71251], [-121.61887, 36.71254]]], [[[-121.62192, 36.70546], [-121.62192, 36.70572], [-121.6218, 36.70605], [-121.6214, 36.70663], [-121.62144, 36.70691], [-121.62137, 36.70731], [-121.62114, 36.70767], [-121.62112, 36.7092], [-121.62102, 36.70934], [-121.62123, 36.70991], [-121.621, 36.71038], [-121.62096, 36.71057], [-121.62093, 36.71062], [-121.62055, 36.71077], [-121.6202, 36.71094], [-121.61998, 36.71109], [-121.61976, 36.71126], [-121.61957, 36.71144], [-121.6194, 36.71167], [-121.61902, 36.71234], [-121.61894, 36.71236], [-121.61876, 36.71228], [-121.61872, 36.71224], [-121.61872, 36.7122], [-121.61887, 36.71195], [-121.61898, 36.7117], [-121.61906, 36.71143], [-121.61911, 36.71115], [-121.61925, 36.71117], [-121.61939, 36.71099], [-121.61951, 36.71087], [-121.61966, 36.71077], [-121.61984, 36.71069], [-121.61975, 36.71012], [-121.61996, 36.70925], [-121.62083, 36.70759], [-121.62127, 36.70536], [-121.62192, 36.70546]]]]} | Open Access 1 | 16324 | Gabilan Creek Wilderness Sanctuary | 19165 | 1291 | Salinas, City of 56 | City 2 | City Agency 2 | http://www.ci.salinas.ca.us/services/recreation/recreation.cfm | City 2 | 1291 | Salinas, City of 54 | City 2 | City Agency 2 | Monterey 14 | 14.845 | Gabilan Creek Wilderness Sanctuary | 0 | Local Conservation Area 4 | 2 | |
2010 | 2010 | 2009 | {"type": "Polygon", "coordinates": [[[-117.70587, 34.07793], [-117.70543, 34.07964], [-117.70378, 34.07961], [-117.70378, 34.07789], [-117.70587, 34.07793]]]} | Open Access 1 | 15358 | Wilderness Basin Park | 27507 | 1210 | Montclair, City of 55 | City 2 | City Agency 2 | http://www.ci.montclair.ca.us/ | City 2 | 1210 | Montclair, City of 53 | City 2 | City Agency 2 | San Bernardino 22 | 8.148 | Wilderness Basin Park | 0 | Local Conservation Area 4 | 2 | |
2068 | 2068 | 2067 | {"type": "Polygon", "coordinates": [[[-121.93333, 36.50126], [-121.93326, 36.50153], [-121.93266, 36.50142], [-121.93222, 36.50144], [-121.93206, 36.50171], [-121.93202, 36.50193], [-121.93202, 36.50211], [-121.93237, 36.50231], [-121.93186, 36.50242], [-121.93146, 36.50254], [-121.93119, 36.50253], [-121.93114, 36.50254], [-121.93127, 36.50272], [-121.93136, 36.50297], [-121.93161, 36.5032], [-121.93153, 36.50331], [-121.93128, 36.50335], [-121.93096, 36.50323], [-121.93074, 36.50311], [-121.93058, 36.50294], [-121.93043, 36.50283], [-121.93107, 36.50243], [-121.93107, 36.50242], [-121.93099, 36.50237], [-121.93084, 36.50218], [-121.93118, 36.50214], [-121.9312, 36.50217], [-121.9315, 36.50207], [-121.93171, 36.50176], [-121.93173, 36.50144], [-121.93207, 36.50111], [-121.9323, 36.50095], [-121.93268, 36.50063], [-121.93302, 36.50082], [-121.93284, 36.50113], [-121.93333, 36.50126]]]} | Restricted Access 2 | 17207 | Laidlaw-Apte Pine Forest Reserve | 20872 | 2085 | Monterey Peninsula Regional Park District 47 | Special District 4 | Recreation/Parks District 4 | http://www.mprpd.org/ | Special District 4 | 2085 | Monterey Peninsula Regional Park District 46 | Special District 4 | Recreation/Parks District 4 | Monterey 14 | 4.771 | Laidlaw-Apte Pine Forest Reserve | 0 | Local Conservation Area 4 | 2 | |
2234 | 2234 | 2233 | {"type": "Polygon", "coordinates": [[[-122.29825, 38.2744], [-122.29823, 38.27446], [-122.29817, 38.2745], [-122.29809, 38.27452], [-122.29236, 38.27449], [-122.29235, 38.2745], [-122.29237, 38.27463], [-122.28394, 38.27458], [-122.2846, 38.27391], [-122.2848, 38.27382], [-122.28533, 38.27354], [-122.28611, 38.27308], [-122.28657, 38.27278], [-122.28722, 38.27197], [-122.28745, 38.27119], [-122.28741, 38.27072], [-122.28736, 38.27048], [-122.28684, 38.26916], [-122.28654, 38.26744], [-122.29799, 38.26741], [-122.29799, 38.26749], [-122.29805, 38.2675], [-122.29798, 38.26871], [-122.29796, 38.27054], [-122.29799, 38.27137], [-122.29805, 38.27227], [-122.29825, 38.2744]]]} | No Public Access 3 | 16671 | Ghisleta - South Wetlands | 19283 | 311 | Napa, County of 498 | County 3 | County Agency 3 | http://www.napaoutdoors.org/ | County 3 | 311 | Napa, County of 489 | County 3 | County Agency 3 | Napa 11 | 196.863 | Ghisleta - South Wetlands | 0 | Local Conservation Area 4 | 2 | |
2261 | 2261 | 2260 | {"type": "Polygon", "coordinates": [[[-117.16881, 34.01125], [-117.16838, 34.01129], [-117.16782, 34.01144], [-117.16755, 34.01148], [-117.16731, 34.0115], [-117.16648, 34.0115], [-117.16609, 34.01146], [-117.1658, 34.01139], [-117.16548, 34.01128], [-117.16517, 34.01113], [-117.16494, 34.01106], [-117.16469, 34.01101], [-117.16441, 34.011], [-117.16443, 34.00773], [-117.16879, 34.00774], [-117.16881, 34.01125]]]} | Open Access 1 | 18112 | Conservation Area | 9197 | 1269 | Redlands, City of 101 | City 2 | City Agency 2 | http://www.cityofredlands.org/ | City 2 | 1269 | Redlands, City of 99 | City 2 | City Agency 2 | San Bernardino 22 | 40.004 | Conservation Area | 0 | Local Conservation Area 4 | 2 | |
2265 | 2265 | 2264 | {"type": "Polygon", "coordinates": [[[-121.80532, 36.92238], [-121.80509, 36.92259], [-121.80524, 36.92344], [-121.80501, 36.92403], [-121.80178, 36.92397], [-121.80168, 36.92488], [-121.80174, 36.92521], [-121.80015, 36.92537], [-121.7999, 36.92535], [-121.79967, 36.92527], [-121.79939, 36.92508], [-121.79917, 36.92485], [-121.79886, 36.92448], [-121.79865, 36.92435], [-121.79847, 36.92427], [-121.79754, 36.92367], [-121.79741, 36.92355], [-121.79735, 36.9234], [-121.79737, 36.92325], [-121.79743, 36.92324], [-121.79754, 36.92291], [-121.79743, 36.92286], [-121.79796, 36.92185], [-121.79855, 36.9219], [-121.80194, 36.92234], [-121.80196, 36.92219], [-121.80529, 36.92225], [-121.80532, 36.92238]]]} | Restricted Access 2 | 16755 | Harkins Slough | 28150 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | http://cityofwatsonville.org/parks-community-services | City 2 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | Santa Cruz 5 | 43.338 | Harkins Slough | 0 | Local Conservation Area 4 | 2 | |
2440 | 2440 | 2439 | {"type": "Polygon", "coordinates": [[[-118.75343, 34.05089], [-118.75323, 34.05643], [-118.74908, 34.05636], [-118.74917, 34.05088], [-118.75343, 34.05089]]]} | Open Access 1 | 48525 | Dal Molin-Runcie Nature Preserve | 33239 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 58.568 | Dal Molin-Runcie Nature Preserve | 2017 | Local Conservation Area 4 | 2 | |
2575 | 2575 | 2574 | {"type": "Polygon", "coordinates": [[[-121.91887, 36.54314], [-121.919, 36.54364], [-121.91893, 36.54417], [-121.91853, 36.54506], [-121.91817, 36.54548], [-121.91798, 36.54586], [-121.91789, 36.54634], [-121.91787, 36.54657], [-121.91782, 36.54777], [-121.91774, 36.54778], [-121.91773, 36.5487], [-121.91755, 36.5493], [-121.9157, 36.55127], [-121.9157, 36.55129], [-121.91551, 36.55121], [-121.91551, 36.55163], [-121.91517, 36.55138], [-121.91557, 36.54884], [-121.91556, 36.54883], [-121.91544, 36.54883], [-121.91546, 36.54866], [-121.91543, 36.54853], [-121.91562, 36.54853], [-121.91588, 36.54692], [-121.91597, 36.54691], [-121.91612, 36.54698], [-121.91619, 36.54696], [-121.91625, 36.54692], [-121.91627, 36.54686], [-121.91624, 36.54679], [-121.91663, 36.54635], [-121.91676, 36.54577], [-121.91675, 36.54576], [-121.91598, 36.54577], [-121.91609, 36.54512], [-121.91675, 36.54519], [-121.91701, 36.54506], [-121.91718, 36.54492], [-121.91745, 36.54432], [-121.91764, 36.54433], [-121.91786, 36.54412], [-121.91788, 36.54373], [-121.91768, 36.54353], [-121.91708, 36.54319], [-121.9172, 36.54304], [-121.91729, 36.54282], [-121.91737, 36.54269], [-121.91759, 36.54245], [-121.91766, 36.54245], [-121.91887, 36.54314]]]} | Open Access 1 | 17870 | Mission Trail Nature Preserve | 22313 | 1046 | Carmel-by-the-Sea, City of 535 | City 2 | City Agency 2 | http://www.carmelcalifornia.com/ | City 2 | 1046 | Carmel-by-the-Sea, City of 528 | City 2 | City Agency 2 | Monterey 14 | 33.893 | Mission Trail Nature Preserve | 0 | Local Conservation Area 4 | 2 | |
2619 | 2619 | 2618 | {"type": "Polygon", "coordinates": [[[-117.1821, 34.08725], [-117.18128, 34.08703], [-117.18018, 34.08677], [-117.17906, 34.08653], [-117.17808, 34.08635], [-117.17695, 34.08618], [-117.17596, 34.08605], [-117.17374, 34.08583], [-117.17372, 34.08457], [-117.17353, 34.08458], [-117.17353, 34.08585], [-117.1693, 34.08535], [-117.16496, 34.08491], [-117.16496, 34.08457], [-117.16604, 34.08457], [-117.16605, 34.084], [-117.1679, 34.08417], [-117.16813, 34.08397], [-117.16825, 34.08405], [-117.16839, 34.0841], [-117.16853, 34.08413], [-117.1687, 34.08414], [-117.16887, 34.08412], [-117.1693, 34.08401], [-117.1693, 34.08386], [-117.16932, 34.08392], [-117.16935, 34.08396], [-117.16946, 34.084], [-117.16955, 34.08399], [-117.16964, 34.08391], [-117.1697, 34.08389], [-117.17071, 34.08389], [-117.17097, 34.08392], [-117.1712, 34.08397], [-117.17226, 34.08433], [-117.17259, 34.0844], [-117.17288, 34.08442], [-117.17321, 34.08441], [-117.1735, 34.08437], [-117.17464, 34.08411], [-117.175, 34.08405], [-117.17538, 34.08402], [-117.17581, 34.08401], [-117.17649, 34.08404], [-117.17769, 34.08419], [-117.17801, 34.08425], [-117.17801, 34.08454], [-117.17901, 34.08454], [-117.18012, 34.08486], [-117.18019, 34.0847], [-117.18019, 34.08453], [-117.182, 34.08452], [-117.182, 34.08648], [-117.18209, 34.08649], [-117.1821, 34.08725]]]} | Open Access 1 | 17996 | Conservation Area | 9197 | 1269 | Redlands, City of 101 | City 2 | City Agency 2 | http://www.cityofredlands.org/ | City 2 | 1269 | Redlands, City of 99 | City 2 | City Agency 2 | San Bernardino 22 | 69.264 | Conservation Area | 0 | Local Conservation Area 4 | 2 | |
2621 | 2621 | 2620 | {"type": "Polygon", "coordinates": [[[-117.08214, 34.06252], [-117.08207, 34.06611], [-117.0778, 34.06609], [-117.0777, 34.06889], [-117.07683, 34.0689], [-117.07676, 34.06892], [-117.07668, 34.06897], [-117.07663, 34.06904], [-117.07661, 34.0691], [-117.07661, 34.06918], [-117.07669, 34.06943], [-117.0767, 34.06959], [-117.07662, 34.06982], [-117.07647, 34.07007], [-117.07643, 34.07022], [-117.07644, 34.07033], [-117.07663, 34.0708], [-117.07668, 34.07113], [-117.07663, 34.0718], [-117.07657, 34.07206], [-117.07324, 34.07204], [-117.07332, 34.06978], [-117.06898, 34.06982], [-117.06948, 34.06263], [-117.07792, 34.06244], [-117.08214, 34.06252]]]} | Open Access 1 | 18000 | Conservation Area | 9197 | 1269 | Redlands, City of 101 | City 2 | City Agency 2 | http://www.cityofredlands.org/ | City 2 | 1269 | Redlands, City of 99 | City 2 | City Agency 2 | San Bernardino 22 | 212.802 | Conservation Area | 0 | Local Conservation Area 4 | 2 | |
2624 | 2624 | 2623 | {"type": "MultiPolygon", "coordinates": [[[[-117.19854, 34.02575], [-117.19635, 34.02695], [-117.19532, 34.02687], [-117.19497, 34.0266], [-117.19476, 34.02702], [-117.19456, 34.02719], [-117.19447, 34.02762], [-117.19412, 34.028], [-117.19395, 34.0284], [-117.19398, 34.02878], [-117.19341, 34.02895], [-117.19323, 34.02854], [-117.1931, 34.02837], [-117.19298, 34.02835], [-117.19255, 34.0284], [-117.19242, 34.02855], [-117.19233, 34.02856], [-117.19223, 34.02855], [-117.19215, 34.0285], [-117.19214, 34.02841], [-117.1922, 34.02835], [-117.19239, 34.02823], [-117.19225, 34.02803], [-117.19205, 34.02797], [-117.1918, 34.02806], [-117.19133, 34.02801], [-117.19089, 34.02806], [-117.19039, 34.02805], [-117.19009, 34.02783], [-117.18976, 34.02763], [-117.19092, 34.02605], [-117.19091, 34.02579], [-117.18914, 34.0258], [-117.18913, 34.02674], [-117.18877, 34.02664], [-117.18836, 34.02662], [-117.18793, 34.02652], [-117.18733, 34.02627], [-117.18723, 34.02635], [-117.18712, 34.02627], [-117.18747, 34.0258], [-117.18877, 34.02396], [-117.18701, 34.02293], [-117.1865, 34.02323], [-117.18655, 34.02456], [-117.18531, 34.02563], [-117.18535, 34.02332], [-117.18437, 34.02189], [-117.18309, 34.02085], [-117.18206, 34.01949], [-117.18201, 34.01857], [-117.182, 34.01791], [-117.17812, 34.01793], [-117.17832, 34.0177], [-117.17844, 34.01721], [-117.17874, 34.01673], [-117.17894, 34.01615], [-117.17947, 34.01615], [-117.18199, 34.0175], [-117.18198, 34.01578], [-117.1823, 34.01599], [-117.18264, 34.01627], [-117.18289, 34.01652], [-117.18312, 34.01679], [-117.18335, 34.01713], [-117.18415, 34.01856], [-117.18419, 34.01856], [-117.18443, 34.01899], [-117.18474, 34.01942], [-117.185, 34.01971], [-117.18529, 34.01997], [-117.18561, 34.02022], [-117.18806, 34.02188], [-117.18837, 34.02205], [-117.1887, 34.0222], [-117.18904, 34.02232], [-117.18933, 34.0224], [-117.18984, 34.02251], [-117.19116, 34.02267], [-117.19145, 34.02273], [-117.19175, 34.02282], [-117.19221, 34.02301], [-117.19309, 34.02349], [-117.19346, 34.02368], [-117.19386, 34.02384], [-117.19436, 34.02401], [-117.19478, 34.02412], [-117.19522, 34.02421], [-117.19671, 34.0244], [-117.19676, 34.02576], [-117.19854, 34.02575]]], [[[-117.20834, 34.03384], [-117.205, 34.03385], [-117.20447, 34.03258], [-117.20334, 34.03192], [-117.20321, 34.03195], [-117.203, 34.03155], [-117.20231, 34.03087], [-117.20146, 34.03041], [-117.20066, 34.03015], [-117.19976, 34.02997], [-117.19941, 34.03018], [-117.19936, 34.03004], [-117.19839, 34.02994], [-117.1984, 34.03017], [-117.19797, 34.03008], [-117.19747, 34.02964], [-117.19737, 34.02944], [-117.19712, 34.0295], [-117.1966, 34.02953], [-117.19621, 34.02949], [-117.1964, 34.02848], [-117.19655, 34.0283], [-117.19662, 34.02799], [-117.19654, 34.02776], [-117.19657, 34.02749], [-117.19652, 34.02696], [-117.19776, 34.02705], [-117.19932, 34.02855], [-117.20389, 34.02934], [-117.20411, 34.02959], [-117.20425, 34.02988], [-117.20458, 34.03014], [-117.20472, 34.03035], [-117.20498, 34.03066], [-117.20536, 34.03088], [-117.20558, 34.03115], [-117.20567, 34.03139], [-117.20563, 34.0316], [-117.20611, 34.03225], [-117.20645, 34.03245], [-117.20692, 34.03256], [-117.20719, 34.0327], [-117.20772, 34.0329], [-117.20831, 34.03305], [-117.20834, 34.03384]]]]} | Open Access 1 | 18015 | Conservation Area | 9197 | 1269 | Redlands, City of 101 | City 2 | City Agency 2 | http://www.cityofredlands.org/ | City 2 | 1269 | Redlands, City of 99 | City 2 | City Agency 2 | San Bernardino 22 | 214.718 | Conservation Area | 0 | Local Conservation Area 4 | 2 |
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]);