units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
149 rows where AGNCY_LEV = 2 and DES_TP = 4 sorted by ACRES
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- San Diego, City of 9
- Mountains Recreation and Conservation Authority 6
- Watsonville, City of 5
- Glendora, City of 5
- Redlands, City of 5
- Burbank, City of 5
- Chico, City of 5
- Los Angeles, City of 4
- San Diego, County of 3
- Carlsbad, City of 3
- Palo Alto, City of 3
- La Verne, City of 3
- Roseville, City of 3
- Claremont, City of 2
- Santa Cruz, City of 2
- Santa Barbara, City of 2
- Glendale, City of 2
- Fullerton, City of 2
- Rolling Hills Estates, City of 2
- Rancho Palos Verdes, City of 2
- Gilroy, City of 2
- Sacramento, City of 2
- Arcata, City of 2
- Sebastopol, City of 2
- Oakdale, City of 1
- Lancaster, City of 1
- San Luis Obispo, City of 1
- Santee, City of 1
- Encinitas, City of 1
- Newport Beach, City of 1
- …
MNG_AG_TYP 4
ACCESS_TYP 3
- Open Access 111
- Restricted Access 11
- No Public Access 7
DES_TP 1
- Local Conservation Area · 129 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4403 | 4403 | 4402 | {"type": "Polygon", "coordinates": [[[-118.1767, 34.11279], [-118.17599, 34.11302], [-118.17547, 34.11312], [-118.17442, 34.11313], [-118.17402, 34.11239], [-118.17362, 34.11232], [-118.17296, 34.1125], [-118.17256, 34.11271], [-118.1719, 34.11287], [-118.17138, 34.11306], [-118.17094, 34.11312], [-118.17185, 34.11253], [-118.17329, 34.11216], [-118.17381, 34.1121], [-118.17437, 34.1121], [-118.17495, 34.11218], [-118.17521, 34.11223], [-118.17555, 34.11231], [-118.17606, 34.11249], [-118.17656, 34.11271], [-118.1767, 34.11279]]]} | Open Access 1 | 46070 | Arroyo Woodland and Wildlife Nature Park | 29413 | 1340 | South Pasadena, City of 309 | City 2 | City Agency 2 | http://www.ci.south-pasadena.ca.us/ | City 2 | 1340 | South Pasadena, City of 306 | City 2 | City Agency 2 | http://www.ci.south-pasadena.ca.us/ | Los Angeles 6 | 6.649 | Arroyo Woodland and Wildlife Nature Park | 0 | Local Conservation Area 4 | 2 |
6989 | 6989 | 6988 | {"type": "Polygon", "coordinates": [[[-118.33737, 33.77887], [-118.33716, 33.77986], [-118.3364, 33.78049], [-118.33571, 33.78009], [-118.33622, 33.77894], [-118.33246, 33.7784], [-118.33242, 33.77815], [-118.3333, 33.77828], [-118.33367, 33.77836], [-118.33369, 33.77834], [-118.33737, 33.77887]]]} | Open Access 1 | 5913 | Linden H. Chandler Preserve - RHE | 21290 | 1283 | Rolling Hills Estates, City of 270 | City 2 | City Agency 2 | http://www.ci.rolling-hills-estates.ca.us/index.aspx?page=109 | City 2 | 1283 | Rolling Hills Estates, City of 265 | City 2 | City Agency 2 | Los Angeles 6 | 6.976 | Linden H. Chandler Preserve - RHE | 0 | Local Conservation Area 4 | 2 | |
8077 | 8077 | 8076 | {"type": "Polygon", "coordinates": [[[-117.83152, 33.67279], [-117.83133, 33.67315], [-117.83052, 33.67296], [-117.83016, 33.67265], [-117.82986, 33.67252], [-117.82273, 33.67034], [-117.823, 33.6703], [-117.82332, 33.6703], [-117.82367, 33.67033], [-117.8246, 33.67054], [-117.83152, 33.67279]]]} | Open Access 1 | 12290 | Culverdale Wilderness Park | 17856 | 1148 | Irvine, City of 271 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | Orange 3 | 7.092 | Culverdale Wilderness Park | 0 | Local Conservation Area 4 | 2 | |
3082 | 3082 | 3081 | {"type": "Polygon", "coordinates": [[[-121.50672, 38.66802], [-121.50672, 38.66802], [-121.50395, 38.66804], [-121.50412, 38.66774], [-121.50423, 38.66746], [-121.5043, 38.66714], [-121.50431, 38.66685], [-121.50529, 38.66685], [-121.50671, 38.66684], [-121.50672, 38.66802]]]} | Open Access 1 | 21265 | North Natomas Park Nature Area | 22833 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 7.099 | North Natomas Park Nature Area | 0 | Local Conservation Area 4 | 2 | |
10790 | 10790 | 10789 | {"type": "Polygon", "coordinates": [[[-117.70322, 34.13848], [-117.70177, 34.13847], [-117.70143, 34.13867], [-117.70084, 34.13867], [-117.70084, 34.13733], [-117.70125, 34.13733], [-117.70134, 34.13735], [-117.70158, 34.13732], [-117.70322, 34.13734], [-117.70324, 34.13738], [-117.70324, 34.13835], [-117.70322, 34.13848]]]} | Open Access 1 | 20545 | Blaisdell Preserve | 16152 | 1057 | Claremont, City of 6 | City 2 | City Agency 2 | http://www.ci.claremont.ca.us/ps.leisurerecreation.cfm?ID=1709 | City 2 | 1057 | Claremont, City of 6 | City 2 | City Agency 2 | Los Angeles 6 | 7.299 | Blaisdell Preserve | 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 | |
1011 | 1011 | 1010 | {"type": "Polygon", "coordinates": [[[-117.76393, 34.14161], [-117.76342, 34.1421], [-117.76331, 34.14232], [-117.76331, 34.14243], [-117.76337, 34.14267], [-117.76337, 34.14304], [-117.76345, 34.1432], [-117.76345, 34.14348], [-117.76025, 34.14346], [-117.75906, 34.14347], [-117.75905, 34.14352], [-117.75879, 34.14355], [-117.75874, 34.14353], [-117.75869, 34.14324], [-117.75976, 34.14314], [-117.76228, 34.14231], [-117.76283, 34.14222], [-117.76319, 34.14186], [-117.76344, 34.14188], [-117.7638, 34.14152], [-117.76393, 34.14161]]]} | Open Access 1 | 6791 | Golden Hills Wilderness Park | 19365 | 1162 | La Verne, City of 305 | City 2 | City Agency 2 | http://www.ci.la-verne.ca.us/index.php/residents/parks | City 2 | 1162 | La Verne, City of 301 | City 2 | City Agency 2 | Los Angeles 6 | 9.525 | Golden Hills Wilderness Park | 0 | Local Conservation Area 4 | 2 | |
13707 | 13707 | 13706 | {"type": "MultiPolygon", "coordinates": [[[[-121.77899, 39.72934], [-121.77873, 39.7295], [-121.77861, 39.72949], [-121.77845, 39.72935], [-121.77833, 39.72941], [-121.77802, 39.72945], [-121.77802, 39.72992], [-121.77386, 39.73195], [-121.77333, 39.73185], [-121.77331, 39.73068], [-121.77334, 39.73068], [-121.77335, 39.73104], [-121.774, 39.73102], [-121.774, 39.73091], [-121.77429, 39.73083], [-121.77467, 39.7308], [-121.77522, 39.73068], [-121.77551, 39.73065], [-121.7756, 39.73059], [-121.77563, 39.7305], [-121.77637, 39.7305], [-121.7766, 39.73038], [-121.77672, 39.73037], [-121.77679, 39.73031], [-121.77722, 39.73031], [-121.77722, 39.72916], [-121.77802, 39.72915], [-121.77816, 39.72911], [-121.77822, 39.72906], [-121.77828, 39.72898], [-121.77839, 39.72893], [-121.779, 39.72921], [-121.77902, 39.72924], [-121.77899, 39.72934]]], [[[-121.77943, 39.72965], [-121.77914, 39.72969], [-121.77906, 39.72935], [-121.77909, 39.72928], [-121.77916, 39.72927], [-121.77929, 39.72931], [-121.77934, 39.72935], [-121.77936, 39.72938], [-121.77938, 39.72952], [-121.77943, 39.72965]]], [[[-121.78023, 39.72944], [-121.78012, 39.72956], [-121.77961, 39.72963], [-121.77955, 39.72949], [-121.77953, 39.72935], [-121.77949, 39.72928], [-121.7794, 39.7292], [-121.77925, 39.72915], [-121.77922, 39.72911], [-121.77943, 39.72877], [-121.77961, 39.7286], [-121.77975, 39.72853], [-121.77987, 39.72849], [-121.7802, 39.72843], [-121.78028, 39.7287], [-121.7802, 39.72884], [-121.78021, 39.72903], [-121.78013, 39.72912], [-121.7799, 39.72917], [-121.77988, 39.72918], [-121.78023, 39.72944]]]]} | Open Access 1 | 36082 | Hillview Preserve | 19996 | 1052 | Chico, City of 430 | City 2 | City Agency 2 | http://www.chico.ca.us/general_services_department/park_division/home_page.asp | City 2 | 1052 | Chico, City of 424 | City 2 | City Agency 2 | Butte 42 | 9.976 | Hillview Preserve | 0 | Local Conservation Area 4 | 2 | |
5015 | 5015 | 5014 | {"type": "MultiPolygon", "coordinates": [[[[-119.88652, 34.4241], [-119.8861, 34.42411], [-119.88609, 34.42296], [-119.88565, 34.42295], [-119.88567, 34.42283], [-119.88572, 34.42274], [-119.8858, 34.42267], [-119.88589, 34.42261], [-119.88605, 34.42258], [-119.88616, 34.42258], [-119.88626, 34.4226], [-119.88638, 34.42268], [-119.88649, 34.42281], [-119.88652, 34.42295], [-119.88652, 34.4241]]], [[[-119.88652, 34.42502], [-119.88649, 34.42503], [-119.88649, 34.42521], [-119.88645, 34.42525], [-119.8861, 34.42526], [-119.8861, 34.42433], [-119.88652, 34.42433], [-119.88652, 34.42502]]], [[[-119.88715, 34.42511], [-119.88666, 34.42512], [-119.88665, 34.42294], [-119.88662, 34.4228], [-119.88652, 34.42265], [-119.88663, 34.42258], [-119.88689, 34.42258], [-119.8869, 34.42254], [-119.88657, 34.42253], [-119.88654, 34.42242], [-119.88657, 34.42238], [-119.88661, 34.42236], [-119.8869, 34.42232], [-119.88714, 34.42233], [-119.88715, 34.42511]]], [[[-119.89286, 34.42346], [-119.892, 34.42346], [-119.89157, 34.42348], [-119.89122, 34.42359], [-119.89106, 34.42379], [-119.89004, 34.4238], [-119.89009, 34.42361], [-119.88956, 34.42349], [-119.88954, 34.42356], [-119.88807, 34.42356], [-119.88807, 34.4233], [-119.88953, 34.42329], [-119.89006, 34.42336], [-119.89286, 34.42313], [-119.89286, 34.42346]]]]} | Open Access 1 | 1029 | Sperling Preserve | 25723 | 1121 | Goleta, City of 179 | City 2 | City Agency 2 | http://www.cityofgoleta.org/index.aspx?page=206 | City 2 | 1121 | Goleta, City of 175 | City 2 | City Agency 2 | Santa Barbara 7 | 10.186 | Sperling Preserve | 0 | Local Conservation Area 4 | 2 | |
13794 | 13794 | 13793 | {"type": "Polygon", "coordinates": [[[-122.28173, 38.30282], [-122.28177, 38.30281], [-122.28187, 38.30284], [-122.28199, 38.30295], [-122.28213, 38.30313], [-122.2823, 38.30365], [-122.28241, 38.30419], [-122.2824, 38.30431], [-122.28236, 38.30442], [-122.28231, 38.3047], [-122.28223, 38.305], [-122.28213, 38.30518], [-122.28199, 38.30533], [-122.28194, 38.30541], [-122.2816, 38.30576], [-122.2815, 38.30588], [-122.28044, 38.3068], [-122.28003, 38.30667], [-122.2801, 38.3057], [-122.28032, 38.30569], [-122.28044, 38.30503], [-122.28063, 38.30497], [-122.28081, 38.30483], [-122.28096, 38.30459], [-122.28097, 38.30452], [-122.28111, 38.30437], [-122.28133, 38.30392], [-122.28154, 38.30356], [-122.28157, 38.30317], [-122.28173, 38.30282]]]} | Open Access 1 | 36362 | Oxbow Preserve | 28577 | 1397 | Napa, City of 447 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | Napa 11 | 10.376 | Oxbow Preserve | 0 | Local Conservation Area 4 | 2 | |
964 | 964 | 963 | {"type": "Polygon", "coordinates": [[[-118.37563, 33.82957], [-118.3743, 33.83077], [-118.37429, 33.8313], [-118.37368, 33.83139], [-118.37311, 33.82856], [-118.37351, 33.82804], [-118.37387, 33.82825], [-118.37421, 33.82848], [-118.37563, 33.82957]]]} | Open Access 1 | 6056 | Hopkins Wilderness Park | 20088 | 1270 | Redondo Beach, City of 246 | City 2 | City Agency 2 | http://www.redondo.org | City 2 | 1270 | Redondo Beach, City of 242 | City 2 | City Agency 2 | Los Angeles 6 | 10.984 | Hopkins Wilderness Park | 0 | Local Conservation Area 4 | 2 | |
10422 | 10422 | 10421 | {"type": "Polygon", "coordinates": [[[-122.81981, 38.39889], [-122.81869, 38.39931], [-122.8173, 38.39755], [-122.81649, 38.39755], [-122.81648, 38.39669], [-122.81743, 38.39647], [-122.8176, 38.39628], [-122.818, 38.39615], [-122.818, 38.39613], [-122.81924, 38.39752], [-122.81891, 38.39753], [-122.81981, 38.39889]]]} | No Public Access 3 | 18463 | Laguna de Santa Rosa Wetlands Preserve | 20852 | 1331 | Sebastopol, City of 605 | City 2 | City Agency 2 | http://ci.sebastopol.ca.us/page/city-parks | City 2 | 1331 | Sebastopol, City of 594 | City 2 | City Agency 2 | Sonoma 16 | 11.785 | Laguna de Santa Rosa Wetlands Preserve | 0 | Local Conservation Area 4 | 2 | |
3058 | 3058 | 3057 | {"type": "Polygon", "coordinates": [[[-118.34268, 34.26987], [-118.34212, 34.26999], [-118.34206, 34.26981], [-118.34091, 34.26925], [-118.33938, 34.26836], [-118.33771, 34.26708], [-118.33809, 34.26706], [-118.33825, 34.26717], [-118.33934, 34.26732], [-118.33933, 34.26743], [-118.34229, 34.26782], [-118.34195, 34.26956], [-118.34268, 34.26987]]]} | Open Access 1 | 12696 | Tujunga Ponds Wildlife Sanctuary | 26562 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 12.885 | Tujunga Ponds Wildlife Sanctuary | 0 | Local Conservation Area 4 | 2 | |
7418 | 7418 | 7417 | {"type": "Polygon", "coordinates": [[[-118.25518, 34.24981], [-118.25477, 34.25004], [-118.25479, 34.2503], [-118.25458, 34.25025], [-118.25397, 34.24972], [-118.25322, 34.25049], [-118.25252, 34.25095], [-118.25201, 34.25117], [-118.2518, 34.25157], [-118.25125, 34.25139], [-118.25086, 34.25122], [-118.25062, 34.25126], [-118.25024, 34.25107], [-118.25114, 34.25038], [-118.25163, 34.25013], [-118.25249, 34.24973], [-118.25319, 34.249], [-118.25371, 34.24856], [-118.25395, 34.2483], [-118.25432, 34.24838], [-118.25433, 34.2485], [-118.25438, 34.24862], [-118.25452, 34.24874], [-118.25454, 34.24895], [-118.25447, 34.2491], [-118.25432, 34.24923], [-118.25413, 34.24935], [-118.25413, 34.24936], [-118.25481, 34.24969], [-118.25518, 34.24981]]]} | Open Access 1 | 6856 | Deukmejian Wilderness Park | 4154 | 1119 | Glendale, City of 103 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/city-departments/community-services-parks | City 2 | 1119 | Glendale, City of 100 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/departments/community-services-parks/parks-facilities-historic-sites/deukmejian-wilderness-park | Los Angeles 6 | 13.175 | Deukmejian Wilderness Park | 0 | Local Conservation Area 4 | 2 |
3134 | 3134 | 3133 | {"type": "Polygon", "coordinates": [[[-118.29541, 33.87454], [-118.2952, 33.87454], [-118.29446, 33.87479], [-118.29448, 33.87492], [-118.29473, 33.87513], [-118.29474, 33.87518], [-118.29465, 33.87522], [-118.29361, 33.87523], [-118.29362, 33.87538], [-118.29214, 33.87542], [-118.29212, 33.87485], [-118.29185, 33.87476], [-118.29157, 33.87464], [-118.29117, 33.8744], [-118.29113, 33.87355], [-118.29311, 33.87358], [-118.29312, 33.87379], [-118.29431, 33.87391], [-118.29431, 33.87396], [-118.2945, 33.87411], [-118.29539, 33.87414], [-118.29541, 33.87454]]]} | Restricted Access 2 | 48035 | Gardena Willows Wetland Preserve | 32528 | 1117 | Gardena, City of 297 | City 2 | City Agency 2 | http://www.ci.gardena.ca.us/ | City 2 | 1117 | Gardena, City of 293 | City 2 | City Agency 2 | Los Angeles 6 | 13.513 | Gardena Willows Wetland Preserve | 0 | Local Conservation Area 4 | 2 | |
13899 | 13899 | 13898 | {"type": "Polygon", "coordinates": [[[-121.7736, 36.90511], [-121.77056, 36.90721], [-121.77033, 36.90877], [-121.77033, 36.90885], [-121.7704, 36.90898], [-121.77059, 36.90911], [-121.77068, 36.90926], [-121.7708, 36.90935], [-121.77111, 36.90952], [-121.76947, 36.90947], [-121.76947, 36.90919], [-121.76878, 36.90923], [-121.76876, 36.90919], [-121.76916, 36.90906], [-121.76915, 36.90904], [-121.76899, 36.90903], [-121.76903, 36.90896], [-121.76906, 36.90887], [-121.76904, 36.90873], [-121.76945, 36.90828], [-121.76949, 36.90796], [-121.76968, 36.90783], [-121.76914, 36.90683], [-121.77055, 36.90589], [-121.77139, 36.90613], [-121.77341, 36.90474], [-121.7736, 36.90511]]]} | Open Access 1 | 36509 | Watsonville Slough | 28585 | 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 | 13.721 | Watsonville Slough | 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 | |
10477 | 10477 | 10476 | {"type": "Polygon", "coordinates": [[[-117.00881, 32.57966], [-117.00877, 32.57945], [-117.00873, 32.5794], [-117.00866, 32.57937], [-117.00856, 32.57938], [-117.00848, 32.57945], [-117.00848, 32.57952], [-117.0085, 32.57956], [-117.00862, 32.57962], [-117.00863, 32.57965], [-117.00559, 32.57952], [-117.00558, 32.57773], [-117.0088, 32.57781], [-117.00881, 32.57966]]]} | Open Access 1 | 18561 | Dennery Canyon Vernal Pool Reserve | 18086 | 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 | 14.897 | Dennery Canyon Vernal Pool Reserve | 0 | Local Conservation Area 4 | 2 | |
15638 | 15638 | 15637 | {"type": "Polygon", "coordinates": [[[-117.02536, 33.01762], [-117.0241, 33.01851], [-117.02409, 33.01859], [-117.02226, 33.01869], [-117.02223, 33.01607], [-117.02353, 33.01605], [-117.02405, 33.01608], [-117.02415, 33.01631], [-117.02426, 33.01652], [-117.02438, 33.01672], [-117.02457, 33.01696], [-117.0249, 33.01729], [-117.02514, 33.01748], [-117.02536, 33.01762]]]} | Restricted Access 2 | 45140 | Blue Sky Ecological Reserve | 29221 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 15.494 | Blue Sky ER | 1991 | Local Conservation Area 4 | 2 | |
418 | 418 | 417 | {"type": "MultiPolygon", "coordinates": [[[[-121.7791, 36.92112], [-121.77861, 36.92097], [-121.77814, 36.92117], [-121.77746, 36.9222], [-121.7769, 36.92436], [-121.77687, 36.92456], [-121.77667, 36.92366], [-121.77666, 36.92365], [-121.77613, 36.92561], [-121.77599, 36.92621], [-121.77601, 36.92699], [-121.77567, 36.92723], [-121.77534, 36.92621], [-121.77526, 36.92569], [-121.7753, 36.92516], [-121.77549, 36.92432], [-121.77552, 36.9241], [-121.77553, 36.92388], [-121.776, 36.92394], [-121.77606, 36.92283], [-121.77616, 36.92252], [-121.77623, 36.9219], [-121.77645, 36.92201], [-121.77717, 36.9225], [-121.77833, 36.91963], [-121.7791, 36.92112]]], [[[-121.77899, 36.91916], [-121.77866, 36.91936], [-121.77838, 36.91931], [-121.77842, 36.91897], [-121.77824, 36.91893], [-121.77848, 36.91836], [-121.77891, 36.91869], [-121.77899, 36.91916]]]]} | Open Access 1 | 1666 | Upper Struve Slough | 28147 | 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 | 15.625 | Upper Struve Slough | 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]);