units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
485 rows where DES_TP = 4
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 32
- Mountains Recreation and Conservation Authority 22
- 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
- Burbank, City of 7
- Chico, City of 7
- San Luis Obispo, County of 5
- Glendora, City of 5
- Redlands, City of 5
- Riverside, County of 5
- Sonoma County Regional Parks Dept., County of 5
- Santa Barbara, County of 4
- Watsonville, City of 4
- Los Angeles, City of 4
- Monterey Peninsula Regional Park 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
- Napa County Regional Park and Open Space District 3
- Carlsbad, City of 3
- Riverside County Regional Park and Open Space District 3
- …
MNG_AG_TYP 15
- Recreation/Parks District 169
- City Agency 141
- County Agency 97
- Open Space District 35
- 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 342
- No Public Access 76
- Restricted Access 45
- Unknown Access 11
DES_TP 1
- Local Conservation Area · 474 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
679 | 679 | 678 | {"type": "Polygon", "coordinates": [[[-121.92514, 36.53043], [-121.92439, 36.53053], [-121.92438, 36.5305], [-121.92514, 36.53041], [-121.92514, 36.53043]]]} | Open Access 1 | 3434 | Carmel River Lagoon & Wetlands Natural Preserve | 16874 | 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 | 0.044 | Carmel River Lagoon & Wetlands Natural Preserve | 0 | Local Conservation Area 4 | 2 | |
770 | 770 | 769 | {"type": "MultiPolygon", "coordinates": [[[[-119.5289, 34.39581], [-119.52824, 34.3972], [-119.52811, 34.3971], [-119.52714, 34.39789], [-119.52649, 34.39736], [-119.52855, 34.39567], [-119.5289, 34.39581]]], [[[-119.52817, 34.39735], [-119.52805, 34.39762], [-119.52771, 34.39836], [-119.52732, 34.39804], [-119.52817, 34.39735]]]]} | Restricted Access 2 | 4493 | Carpinteria Salt Marsh Reserve | 16899 | 1047 | Carpinteria, City of 72 | City 2 | City Agency 2 | http://www.carpinteria.ca.us/parks_rec/index.shtml | City 2 | 1047 | Carpinteria, City of 70 | City 2 | City Agency 2 | Santa Barbara 7 | 5.768 | Carpinteria Salt Marsh Reserve | 0 | Local Conservation Area 4 | 2 | |
809 | 809 | 808 | {"type": "Polygon", "coordinates": [[[-118.35743, 33.73927], [-118.35609, 33.74137], [-118.35451, 33.74259], [-118.35482, 33.74403], [-118.35362, 33.74458], [-118.35252, 33.74529], [-118.35063, 33.7436], [-118.34639, 33.74233], [-118.34503, 33.74505], [-118.34344, 33.74433], [-118.33999, 33.7428], [-118.34048, 33.74141], [-118.34104, 33.74039], [-118.34184, 33.73965], [-118.34197, 33.73931], [-118.34325, 33.7401], [-118.34389, 33.74064], [-118.34434, 33.74033], [-118.34435, 33.73955], [-118.34415, 33.73943], [-118.34424, 33.73925], [-118.34391, 33.73909], [-118.3449, 33.73758], [-118.3455, 33.73785], [-118.34744, 33.73774], [-118.34871, 33.73993], [-118.34901, 33.74034], [-118.34923, 33.74059], [-118.34954, 33.74088], [-118.34981, 33.7411], [-118.35018, 33.74134], [-118.3505, 33.74153], [-118.35158, 33.74209], [-118.35168, 33.74196], [-118.35143, 33.74182], [-118.35146, 33.74177], [-118.35156, 33.74182], [-118.35157, 33.74178], [-118.35267, 33.74042], [-118.3527, 33.74039], [-118.35277, 33.74039], [-118.35284, 33.74042], [-118.35293, 33.74027], [-118.35275, 33.7402], [-118.35262, 33.7402], [-118.35329, 33.73935], [-118.35652, 33.74025], [-118.35681, 33.73955], [-118.35743, 33.73927]]]} | Open Access 1 | 5873 | Forrestal Nature Preserve | 29614 | 1265 | Rancho Palos Verdes, City of 265 | City 2 | City Agency 2 | http://palosverdes.com/rpv/recreationparks/index.cfm | City 2 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 158.035 | Forrestal Nature Preserve | 0 | Local Conservation Area 4 | 2 | |
923 | 923 | 922 | {"type": "Polygon", "coordinates": [[[-118.33718, 33.76768], [-118.33635, 33.76814], [-118.33599, 33.76854], [-118.33549, 33.76865], [-118.33479, 33.76891], [-118.33421, 33.76885], [-118.33391, 33.76892], [-118.33374, 33.76913], [-118.33223, 33.76984], [-118.33131, 33.77004], [-118.3307, 33.77005], [-118.33069, 33.76988], [-118.32983, 33.76993], [-118.32914, 33.77014], [-118.32746, 33.77059], [-118.32699, 33.77124], [-118.32727, 33.77181], [-118.3271, 33.77189], [-118.32733, 33.77234], [-118.32698, 33.77247], [-118.32693, 33.77225], [-118.32676, 33.77186], [-118.32654, 33.77151], [-118.32637, 33.77132], [-118.32611, 33.77107], [-118.3259, 33.77091], [-118.32492, 33.77026], [-118.32701, 33.77025], [-118.32756, 33.76972], [-118.32885, 33.7694], [-118.33031, 33.76865], [-118.33101, 33.76955], [-118.33165, 33.76962], [-118.333, 33.76871], [-118.33343, 33.7675], [-118.33564, 33.76652], [-118.33578, 33.76691], [-118.33655, 33.7668], [-118.33718, 33.76768]]]} | Open Access 1 | 5878 | George F Canyon Nature Park and Preserve | 19263 | 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 | 33.273 | George F Canyon Nature Park and 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 | |
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 | |
1048 | 1048 | 1047 | {"type": "Polygon", "coordinates": [[[-118.51707, 34.12476], [-118.51169, 34.12287], [-118.50522, 34.11808], [-118.50208, 34.11085], [-118.50114, 34.10951], [-118.50141, 34.10932], [-118.50238, 34.11073], [-118.5055, 34.11792], [-118.50867, 34.12028], [-118.50994, 34.11967], [-118.51004, 34.12128], [-118.51187, 34.12264], [-118.51704, 34.12445], [-118.51707, 34.12476]]]} | Open Access 1 | 6371 | Westridge-Canyonback Wilderness Park of LA | 27417 | 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 | 20.346 | Westridge-Canyonback Wilderness Park of LA | 0 | Local Conservation Area 4 | 2 | |
1122 | 1122 | 1121 | {"type": "Polygon", "coordinates": [[[-118.29627, 34.19919], [-118.29609, 34.19935], [-118.29614, 34.19953], [-118.29511, 34.19897], [-118.2953, 34.19878], [-118.29525, 34.19874], [-118.29588, 34.19813], [-118.29595, 34.19818], [-118.29627, 34.19919]]]} | Open Access 1 | 7138 | City of Burbank Open Space Mountain Reserve | 744 | 1038 | Burbank, City of 138 | City 2 | City Agency 2 | http://burbankca.gov/departments/park-recreation-and-community-services/parks-facilities | City 2 | 1038 | Burbank, City of 135 | City 2 | City Agency 2 | Los Angeles 6 | 2.037 | City of Burbank OS Mtn. Reserve | 0 | Local Conservation Area 4 | 2 | |
1123 | 1123 | 1122 | {"type": "Polygon", "coordinates": [[[-118.33773, 34.21146], [-118.33771, 34.21259], [-118.33604, 34.21431], [-118.33641, 34.21457], [-118.33522, 34.21539], [-118.33454, 34.21562], [-118.33424, 34.21502], [-118.33435, 34.21492], [-118.33456, 34.21461], [-118.3353, 34.21399], [-118.33455, 34.21358], [-118.33456, 34.21235], [-118.33503, 34.21195], [-118.3351, 34.21143], [-118.33773, 34.21146]]]} | Open Access 1 | 7140 | City of Burbank Open Space Mountain Reserve | 744 | 1038 | Burbank, City of 138 | City 2 | City Agency 2 | http://burbankca.gov/departments/park-recreation-and-community-services/parks-facilities | City 2 | 1038 | Burbank, City of 135 | City 2 | City Agency 2 | Los Angeles 6 | 21.658 | City of Burbank OS Mtn. Reserve | 0 | Local Conservation Area 4 | 2 | |
1137 | 1137 | 1136 | {"type": "MultiPolygon", "coordinates": [[[[-117.02885, 33.34502], [-117.02695, 33.34498], [-117.02614, 33.34414], [-117.02426, 33.34497], [-117.02419, 33.34265], [-117.02878, 33.34259], [-117.02885, 33.34502]]], [[[-117.05093, 33.3583], [-117.04668, 33.35835], [-117.04442, 33.35814], [-117.04443, 33.35429], [-117.04345, 33.35427], [-117.0434, 33.35804], [-117.04323, 33.35802], [-117.04326, 33.35059], [-117.04225, 33.35057], [-117.04224, 33.35058], [-117.04223, 33.35424], [-117.04258, 33.35426], [-117.04258, 33.35796], [-117.04222, 33.35793], [-117.04221, 33.35603], [-117.04114, 33.35604], [-117.0411, 33.35792], [-117.04095, 33.35765], [-117.04058, 33.35758], [-117.03982, 33.35725], [-117.03928, 33.35674], [-117.03849, 33.35579], [-117.03828, 33.35582], [-117.03668, 33.35448], [-117.03357, 33.35447], [-117.03356, 33.35433], [-117.02942, 33.35428], [-117.0292, 33.3542], [-117.02912, 33.35051], [-117.02563, 33.35045], [-117.02562, 33.34983], [-117.0257, 33.34859], [-117.02569, 33.3484], [-117.02565, 33.34824], [-117.02555, 33.34803], [-117.02542, 33.34786], [-117.02435, 33.34678], [-117.02433, 33.34655], [-117.03346, 33.34656], [-117.03331, 33.34315], [-117.04228, 33.34309], [-117.05066, 33.3431], [-117.05068, 33.34591], [-117.0508, 33.35071], [-117.05093, 33.3583]]]]} | Open Access 1 | 7251 | Wilderness Gardens Preserve | 29262 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/WildernessGardens.html | San Diego 4 | 732.625 | Wilderness Gardens Preserve | 0 | Local Conservation Area 4 | 2 |
1139 | 1139 | 1138 | {"type": "Polygon", "coordinates": [[[-122.51189, 37.77681], [-122.51151, 37.77685], [-122.5112, 37.77653], [-122.51112, 37.77641], [-122.51112, 37.77626], [-122.51093, 37.77611], [-122.51078, 37.77588], [-122.51061, 37.77568], [-122.51028, 37.77523], [-122.51108, 37.7752], [-122.51109, 37.77541], [-122.51113, 37.77564], [-122.5112, 37.77588], [-122.51128, 37.77607], [-122.51149, 37.7764], [-122.51189, 37.77681]]]} | Open Access 1 | 6699 | Gr.hwy/balboa Natural Area | 19412 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 1.868 | Gr.hwy/balboa Natural Area | 0 | Local Conservation Area 4 | 2 | |
1168 | 1168 | 1167 | {"type": "Polygon", "coordinates": [[[-117.16158, 33.54542], [-117.16142, 33.54573], [-117.16062, 33.54559], [-117.16033, 33.54532], [-117.16028, 33.54523], [-117.1601, 33.54511], [-117.1595, 33.54457], [-117.15987, 33.54428], [-117.15985, 33.54425], [-117.16006, 33.54409], [-117.16012, 33.54409], [-117.16126, 33.54513], [-117.16158, 33.54536], [-117.16158, 33.54542]]]} | Open Access 1 | 48441 | Vintage Reserve Park | 33146 | 1391 | Murrieta, City of 329 | City 2 | City Agency 2 | http://www.murrieta.org/services/cs/default.asp#.VJnvnF4AHA | City 2 | 1391 | Murrieta, City of 326 | City 2 | City Agency 2 | Riverside 10 | 3.802 | Vintage Reserve Park | 0 | Local Conservation Area 4 | 2 | |
1199 | 1199 | 1198 | {"type": "Polygon", "coordinates": [[[-118.01942, 34.17359], [-118.01845, 34.17534], [-118.01863, 34.17541], [-118.01863, 34.17681], [-118.01873, 34.17724], [-118.01775, 34.17798], [-118.01747, 34.1784], [-118.01738, 34.17903], [-118.01759, 34.17945], [-118.01268, 34.17947], [-118.01265, 34.17226], [-118.01847, 34.17224], [-118.01866, 34.17289], [-118.01942, 34.17359]]]} | Open Access 1 | 6938 | Arcadia Wilderness Park | 15567 | 1009 | Arcadia, City of 303 | City 2 | City Agency 2 | http://www.ci.arcadia.ca.us/home/index.asp?page=1160 | City 2 | 1009 | Arcadia, City of 299 | City 2 | City Agency 2 | http://www.ci.arcadia.ca.us/home/index.asp?page=1160 | Los Angeles 6 | 105.747 | Arcadia Wilderness Park | 0 | Local Conservation Area 4 | 2 |
1238 | 1238 | 1237 | {"type": "Polygon", "coordinates": [[[-117.90357, 34.04177], [-117.90199, 34.04524], [-117.90201, 34.04526], [-117.90197, 34.0453], [-117.9019, 34.04545], [-117.90185, 34.04562], [-117.90185, 34.04576], [-117.90191, 34.04595], [-117.89926, 34.04592], [-117.89933, 34.04073], [-117.90357, 34.04177]]]} | Open Access 1 | 7071 | Galster Wilderness Park | 19180 | 1374 | West Covina, City of 318 | City 2 | City Agency 2 | http://www.westcovina.org/departments/community-recreation-services/park-facility-rentals | City 2 | 1374 | West Covina, City of 315 | City 2 | City Agency 2 | Los Angeles 6 | 40.865 | Galster Wilderness Park | 0 | Local Conservation Area 4 | 2 | |
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 | |
1560 | 1560 | 1559 | {"type": "MultiPolygon", "coordinates": [[[[-116.67869, 33.12778], [-116.67507, 33.1291], [-116.67083, 33.12914], [-116.66826, 33.12896], [-116.66617, 33.12917], [-116.66555, 33.12932], [-116.66459, 33.12981], [-116.66349, 33.13111], [-116.66203, 33.13263], [-116.66257, 33.13857], [-116.65983, 33.1441], [-116.65087, 33.13807], [-116.64428, 33.13531], [-116.64222, 33.13439], [-116.64213, 33.13433], [-116.64207, 33.13431], [-116.64201, 33.13432], [-116.63822, 33.13266], [-116.63537, 33.13001], [-116.62768, 33.12661], [-116.61609, 33.1216], [-116.61608, 33.1216], [-116.6161, 33.12308], [-116.60157, 33.12331], [-116.60159, 33.12309], [-116.60164, 33.12292], [-116.60177, 33.12264], [-116.60204, 33.12221], [-116.60219, 33.12188], [-116.6028, 33.11983], [-116.60294, 33.11942], [-116.61572, 33.10683], [-116.61854, 33.10692], [-116.63257, 33.10687], [-116.63264, 33.10942], [-116.63262, 33.11709], [-116.63264, 33.11777], [-116.63951, 33.11478], [-116.63967, 33.11501], [-116.64538, 33.11233], [-116.64539, 33.11232], [-116.64534, 33.11224], [-116.64807, 33.11104], [-116.65016, 33.11031], [-116.65016, 33.10895], [-116.65283, 33.10895], [-116.65665, 33.10729], [-116.6568, 33.10743], [-116.65693, 33.10752], [-116.65708, 33.1076], [-116.65724, 33.10766], [-116.65756, 33.10773], [-116.65784, 33.10773], [-116.65788, 33.1078], [-116.65812, 33.10777], [-116.65812, 33.10769], [-116.65843, 33.10758], [-116.6587, 33.10742], [-116.65882, 33.10731], [-116.65895, 33.10714], [-116.65905, 33.10696], [-116.65909, 33.1068], [-116.65913, 33.10621], [-116.66452, 33.10387], [-116.66715, 33.10274], [-116.66726, 33.1029], [-116.66744, 33.10304], [-116.66752, 33.10314], [-116.66774, 33.10343], [-116.6679, 33.10373], [-116.66802, 33.10409], [-116.66808, 33.1044], [-116.66808, 33.10477], [-116.66803, 33.10504], [-116.66778, 33.10603], [-116.66776, 33.10634], [-116.66779, 33.10659], [-116.66782, 33.10675], [-116.6679, 33.10696], [-116.66874, 33.10895], [-116.66871, 33.10899], [-116.66882, 33.10921], [-116.66748, 33.10958], [-116.66806, 33.11096], [-116.6704, 33.11028], [-116.67082, 33.11127], [-116.67421, 33.1103], [-116.67598, 33.11473], [-116.67648, 33.11617], [-116.67686, 33.1175], [-116.67738, 33.12013], [-116.67869, 33.12778]]], [[[-116.65874, 33.10638], [-116.65872, 33.10671], [-116.65869, 33.10681], [-116.65863, 33.10695], [-116.65855, 33.10706], [-116.65843, 33.10719], [-116.65831, 33.10728], [-116.65819, 33.10736], [-116.65812, 33.10733], [-116.65786, 33.10737], [-116.65781, 33.10743], [-116.65751, 33.10742], [-116.65733, 33.10737], [-116.65713, 33.1073], [-116.65696, 33.10715], [-116.65874, 33.10638]]], [[[-116.72151, 33.13325], [-116.71595, 33.13859], [-116.70914, 33.13903], [-116.70195, 33.13862], [-116.69711, 33.13219], [-116.69318, 33.12693], [-116.69264, 33.12424], [-116.68438, 33.12422], [-116.6784, 33.12414], [-116.67819, 33.12293], [-116.68439, 33.12295], [-116.70166, 33.12273], [-116.70167, 33.12271], [-116.7084, 33.12261], [-116.70589, 33.11347], [-116.70159, 33.10945], [-116.69487, 33.10266], [-116.69544, 33.10219], [-116.69685, 33.10083], [-116.69907, 33.09843], [-116.69941, 33.09801], [-116.69975, 33.09756], [-116.70055, 33.0964], [-116.70072, 33.09608], [-116.70092, 33.09561], [-116.7011, 33.09529], [-116.7021, 33.09356], [-116.70233, 33.09324], [-116.70258, 33.09301], [-116.70399, 33.09204], [-116.70418, 33.09185], [-116.70443, 33.09149], [-116.70462, 33.09129], [-116.70478, 33.09116], [-116.70551, 33.09069], [-116.70566, 33.09057], [-116.7058, 33.09043], [-116.70592, 33.09025], [-116.70598, 33.09009], [-116.70626, 33.08876], [-116.70719, 33.08867], [-116.70708, 33.10671], [-116.70849, 33.10944], [-116.71004, 33.11173], [-116.71661, 33.12406], [-116.71794, 33.12675], [-116.71988, 33.13024], [-116.72151, 33.13325]]]]} | Open Access 1 | 11729 | Santa Ysabel Preserve | 29255 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/SantaYsabel.html | San Diego 4 | 5407.378 | Santa Ysabel Preserve | 0 | 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 |
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]);