units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
103 rows where DES_TP = 4 and MNG_AG_TYP = 3 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, MNG_AG_ID, COUNTY, YR_EST
MNG_AGENCY 15
- San Diego, County of 37
- Orange, County of 19
- Los Angeles, County of 15
- Santa Barbara, County of 5
- San Luis Obispo, County of 5
- Riverside, County of 5
- Sacramento, County of 4
- Santa Cruz, County of 3
- Monterey, County of 2
- Placer, County of 2
- San Bernardino, County of 2
- Tulare, County of 1
- Lake, County of 1
- San Joaquin, County of 1
- Napa, County of 1
LAYER 5 ✖
ACCESS_TYP 4
MNG_AG_TYP 1
- County Agency · 103 ✖
DES_TP 1
- Local Conservation Area · 103 ✖
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 | |
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 | |
345 | 345 | 344 | {"type": "Polygon", "coordinates": [[[-119.5898, 34.42352], [-119.58906, 34.42428], [-119.5885, 34.42388], [-119.58922, 34.42315], [-119.5898, 34.42352]]]} | Open Access 1 | 1191 | Summerland Greenwell Preserve | 25961 | 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.774 | Summerland Greenwell Preserve | 0 | Local Conservation Area 4 | 2 | |
9222 | 9222 | 9221 | {"type": "Polygon", "coordinates": [[[-121.74481, 36.84148], [-121.74245, 36.84316], [-121.74184, 36.84299], [-121.74343, 36.84161], [-121.74317, 36.84141], [-121.74385, 36.84096], [-121.74425, 36.84118], [-121.74481, 36.84148]]]} | Open Access 1 | 15341 | Elkhorn Slough | 18570 | 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 | 5.157 | Elkhorn Slough | 0 | Local Conservation Area 4 | 2 | |
10406 | 10406 | 10405 | {"type": "Polygon", "coordinates": [[[-117.88675, 33.63629], [-117.88676, 33.63671], [-117.88656, 33.63756], [-117.88651, 33.63789], [-117.88644, 33.63864], [-117.88628, 33.63944], [-117.88624, 33.64024], [-117.88617, 33.64049], [-117.88615, 33.64054], [-117.88604, 33.64067], [-117.88588, 33.64072], [-117.88507, 33.64081], [-117.88518, 33.64074], [-117.88577, 33.64058], [-117.88601, 33.64014], [-117.88595, 33.63961], [-117.88605, 33.63868], [-117.8862, 33.638], [-117.88625, 33.63711], [-117.88644, 33.63657], [-117.88657, 33.63646], [-117.88649, 33.63611], [-117.88598, 33.63572], [-117.88576, 33.63561], [-117.88532, 33.63466], [-117.88467, 33.63416], [-117.88461, 33.63407], [-117.88479, 33.63397], [-117.88534, 33.63446], [-117.88542, 33.63454], [-117.88552, 33.63478], [-117.88576, 33.63522], [-117.88604, 33.63554], [-117.88649, 33.63592], [-117.88675, 33.63629]]]} | Open Access 1 | 18399 | Upper Newport Bay Nature Preserve | 26732 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 5.179 | Upper Newport Bay Nature Preserve | 0 | Local Conservation Area 4 | 2 | |
10403 | 10403 | 10402 | {"type": "Polygon", "coordinates": [[[-117.87426, 33.65171], [-117.87411, 33.65186], [-117.87368, 33.65165], [-117.87349, 33.65159], [-117.87309, 33.65154], [-117.87287, 33.65155], [-117.87262, 33.6516], [-117.87254, 33.65162], [-117.87253, 33.65194], [-117.87219, 33.65186], [-117.87188, 33.65195], [-117.87143, 33.65239], [-117.87108, 33.65252], [-117.87085, 33.65215], [-117.87074, 33.65219], [-117.8706, 33.65196], [-117.8698, 33.65217], [-117.87, 33.65204], [-117.87103, 33.65164], [-117.87218, 33.65124], [-117.8725, 33.65115], [-117.87249, 33.6511], [-117.87303, 33.65086], [-117.87426, 33.65171]]]} | Open Access 1 | 18396 | Upper Newport Bay Nature Preserve | 26732 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 5.536 | Upper Newport Bay Nature Preserve | 0 | Local Conservation Area 4 | 2 | |
2737 | 2737 | 2736 | {"type": "MultiPolygon", "coordinates": [[[[-117.88993, 33.65132], [-117.88915, 33.65163], [-117.88901, 33.65178], [-117.88892, 33.65213], [-117.88878, 33.6524], [-117.88858, 33.6525], [-117.88842, 33.65252], [-117.88878, 33.65161], [-117.88869, 33.65158], [-117.88957, 33.65102], [-117.88975, 33.65122], [-117.88993, 33.65132]]], [[[-117.89068, 33.65184], [-117.89057, 33.65202], [-117.89045, 33.65216], [-117.88972, 33.6529], [-117.88932, 33.65262], [-117.88889, 33.65246], [-117.88867, 33.65249], [-117.88881, 33.65241], [-117.88895, 33.65214], [-117.88904, 33.65178], [-117.88917, 33.65166], [-117.88993, 33.65135], [-117.88998, 33.65135], [-117.89031, 33.65154], [-117.89043, 33.65169], [-117.89061, 33.65181], [-117.89068, 33.65184]]]]} | Open Access 1 | 18389 | Upper Newport Bay Nature Preserve | 26732 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 5.762 | Upper Newport Bay Nature Preserve | 0 | Local Conservation Area 4 | 2 | |
10404 | 10404 | 10403 | {"type": "Polygon", "coordinates": [[[-117.87074, 33.65219], [-117.87051, 33.65232], [-117.87072, 33.65266], [-117.86908, 33.6533], [-117.86899, 33.65299], [-117.86823, 33.65312], [-117.86746, 33.65307], [-117.86756, 33.65296], [-117.86713, 33.65287], [-117.86698, 33.65266], [-117.86703, 33.65232], [-117.86752, 33.65236], [-117.86794, 33.65237], [-117.86852, 33.65235], [-117.86896, 33.65231], [-117.8698, 33.65217], [-117.87037, 33.65203], [-117.8706, 33.65196], [-117.87074, 33.65219]]]} | Open Access 1 | 18397 | Upper Newport Bay Nature Preserve | 26732 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 7.01 | Upper Newport Bay Nature Preserve | 0 | Local Conservation Area 4 | 2 | |
10407 | 10407 | 10406 | {"type": "Polygon", "coordinates": [[[-117.8934, 33.64575], [-117.89286, 33.64631], [-117.89283, 33.64533], [-117.89242, 33.64479], [-117.89224, 33.64469], [-117.89142, 33.64576], [-117.89221, 33.64468], [-117.892, 33.64456], [-117.89199, 33.64287], [-117.89123, 33.64185], [-117.89134, 33.64175], [-117.89186, 33.64225], [-117.89251, 33.64306], [-117.89296, 33.64373], [-117.89312, 33.64423], [-117.89324, 33.64457], [-117.89335, 33.64553], [-117.8934, 33.64575]]]} | Open Access 1 | 18400 | Upper Newport Bay Nature Preserve | 26732 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 7.201 | Upper Newport Bay Nature Preserve | 0 | Local Conservation Area 4 | 2 | |
14637 | 14637 | 14636 | {"type": "Polygon", "coordinates": [[[-116.90222, 32.84651], [-116.90218, 32.84649], [-116.90213, 32.84651], [-116.9021, 32.84659], [-116.90205, 32.84692], [-116.9019, 32.84712], [-116.89878, 32.84713], [-116.89877, 32.84549], [-116.89944, 32.84553], [-116.90108, 32.84593], [-116.90178, 32.84602], [-116.90196, 32.84615], [-116.9022, 32.84643], [-116.90222, 32.84651]]]} | Open Access 1 | 44871 | Lakeside Linkage Preserve | 20976 | 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/LakesideLinkage.html | San Diego 4 | 11.424 | Lakeside Linkage Preserve | 0 | Local Conservation Area 4 | 2 |
6918 | 6918 | 6917 | {"type": "MultiPolygon", "coordinates": [[[[-117.23536, 33.03391], [-117.23513, 33.03422], [-117.2342, 33.03397], [-117.23474, 33.03348], [-117.23477, 33.03348], [-117.23517, 33.03379], [-117.23536, 33.03391]]], [[[-117.23609, 33.03514], [-117.23555, 33.03678], [-117.23459, 33.03653], [-117.23477, 33.03601], [-117.23609, 33.03514]]], [[[-117.23732, 33.03115], [-117.23555, 33.03272], [-117.23531, 33.03354], [-117.23553, 33.03368], [-117.23569, 33.03369], [-117.23557, 33.03381], [-117.23525, 33.0336], [-117.23497, 33.03337], [-117.23493, 33.03326], [-117.23496, 33.03324], [-117.2351, 33.03295], [-117.23513, 33.03282], [-117.23514, 33.0326], [-117.23511, 33.03241], [-117.23505, 33.03223], [-117.23496, 33.03209], [-117.23577, 33.03136], [-117.23603, 33.03158], [-117.23624, 33.0314], [-117.23625, 33.03135], [-117.23668, 33.03095], [-117.23612, 33.03046], [-117.23629, 33.0303], [-117.23732, 33.03115]]], [[[-117.24184, 33.03031], [-117.24168, 33.03057], [-117.24148, 33.03079], [-117.24127, 33.03094], [-117.24071, 33.03129], [-117.24106, 33.03011], [-117.24184, 33.03031]]], [[[-117.27719, 33.00739], [-117.27719, 33.00739], [-117.27717, 33.00818], [-117.27696, 33.00739], [-117.27719, 33.00739]]], [[[-117.27882, 33.01168], [-117.27819, 33.01179], [-117.27803, 33.01121], [-117.27846, 33.01114], [-117.2784, 33.01123], [-117.2784, 33.01129], [-117.27872, 33.01159], [-117.2788, 33.01158], [-117.27882, 33.01168]]]]} | Open Access 1 | 724 | San Elijo Lagoon Ecological Reserve | 24878 | 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/SanElijo.html | San Diego 4 | 12.338 | San Elijo Lagoon ER | 1983 | Local Conservation Area 4 | 2 |
5324 | 5324 | 5323 | {"type": "Polygon", "coordinates": [[[-117.87081, 33.58987], [-117.87057, 33.5901], [-117.87047, 33.59017], [-117.87031, 33.59023], [-117.87023, 33.59023], [-117.86914, 33.5899], [-117.8688, 33.58974], [-117.8687, 33.58967], [-117.86857, 33.58971], [-117.86853, 33.58978], [-117.86837, 33.58952], [-117.86822, 33.58933], [-117.86799, 33.58913], [-117.86753, 33.58885], [-117.86748, 33.58879], [-117.86752, 33.58844], [-117.86743, 33.58829], [-117.86725, 33.58817], [-117.867, 33.58794], [-117.86685, 33.58788], [-117.86663, 33.58784], [-117.86629, 33.58758], [-117.86584, 33.58715], [-117.86554, 33.58681], [-117.86536, 33.58663], [-117.86504, 33.58617], [-117.86492, 33.58612], [-117.86475, 33.58608], [-117.8645, 33.58597], [-117.86432, 33.58592], [-117.86424, 33.5858], [-117.8642, 33.58564], [-117.86413, 33.58546], [-117.86417, 33.58532], [-117.86436, 33.585], [-117.86442, 33.58494], [-117.86438, 33.58488], [-117.86425, 33.58484], [-117.86379, 33.58483], [-117.86352, 33.58479], [-117.86325, 33.58471], [-117.86307, 33.58461], [-117.86285, 33.58452], [-117.86263, 33.5845], [-117.86238, 33.58444], [-117.86223, 33.58433], [-117.86267, 33.58392], [-117.86275, 33.58396], [-117.86292, 33.58397], [-117.86313, 33.58403], [-117.86336, 33.58412], [-117.86354, 33.58421], [-117.86366, 33.58425], [-117.86406, 33.58429], [-117.86428, 33.5843], [-117.86449, 33.58433], [-117.8647, 33.5844], [-117.8648, 33.58446], [-117.86494, 33.58459], [-117.86504, 33.58473], [-117.86508, 33.58492], [-117.86507, 33.58502], [-117.86504, 33.58511], [-117.865, 33.5852], [-117.86483, 33.58545], [-117.86484, 33.5855], [-117.86498, 33.58556], [-117.86524, 33.58564], [-117.86546, 33.58574], [-117.8656, 33.58589], [-117.86589, 33.58631], [-117.86607, 33.58648], [-117.86635, 33.5868], [-117.86676, 33.58719], [-117.86695, 33.58733], [-117.86715, 33.58739], [-117.86741, 33.58751], [-117.86763, 33.58773], [-117.86765, 33.58773], [-117.86793, 33.58793], [-117.868, 33.58801], [-117.86813, 33.58825], [-117.86817, 33.58834], [-117.86817, 33.58855], [-117.86848, 33.58875], [-117.8687, 33.58896], [-117.86896, 33.58928], [-117.8691, 33.5895], [-117.86932, 33.5896], [-117.86955, 33.58966], [-117.86984, 33.58967], [-117.87045, 33.58972], [-117.87067, 33.58978], [-117.87081, 33.58987]]]} | Unknown Access 4 | 5677 | Newport Beach Marine Life Refuge | 22734 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 16.208 | Newport Beach Marine Life Refuge | 0 | Local Conservation Area 4 | 2 | |
4184 | 4184 | 4183 | {"type": "Polygon", "coordinates": [[[-117.13525, 33.02933], [-117.1352, 33.03273], [-117.1346, 33.03273], [-117.13459, 33.03241], [-117.13336, 33.03194], [-117.13294, 33.0302], [-117.13281, 33.0301], [-117.13258, 33.03004], [-117.1325, 33.02998], [-117.13233, 33.02954], [-117.1323, 33.02934], [-117.13525, 33.02933]]]} | Open Access 1 | 44865 | Greenfield Preserve | 19479 | 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 | San Diego 4 | 17.374 | Greenfield Preserve | 0 | Local Conservation Area 4 | 2 | |
10228 | 10228 | 10227 | {"type": "Polygon", "coordinates": [[[-120.86112, 35.31032], [-120.86111, 35.31276], [-120.86105, 35.31586], [-120.86045, 35.31587], [-120.86045, 35.31573], [-120.86041, 35.31569], [-120.86078, 35.31419], [-120.86095, 35.31265], [-120.85951, 35.31264], [-120.85951, 35.31144], [-120.8592, 35.31143], [-120.85933, 35.31126], [-120.85933, 35.3112], [-120.8593, 35.31114], [-120.8592, 35.3111], [-120.85909, 35.31112], [-120.859, 35.31102], [-120.85674, 35.31101], [-120.85674, 35.31089], [-120.85678, 35.31076], [-120.85674, 35.31066], [-120.85667, 35.31059], [-120.85667, 35.3103], [-120.86112, 35.31032]]]} | Open Access 1 | 17895 | Monarch Grove Natural Area | 22365 | 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 | 17.519 | Monarch Grove Natural Area | 0 | Local Conservation Area 4 | 2 | |
10400 | 10400 | 10399 | {"type": "Polygon", "coordinates": [[[-117.88536, 33.64086], [-117.88519, 33.64097], [-117.88485, 33.64127], [-117.88427, 33.64172], [-117.88345, 33.64241], [-117.88291, 33.64282], [-117.88256, 33.64313], [-117.88233, 33.6434], [-117.88221, 33.64362], [-117.8821, 33.64402], [-117.88208, 33.64435], [-117.88216, 33.64517], [-117.88212, 33.64546], [-117.88197, 33.64574], [-117.88185, 33.64587], [-117.88177, 33.64595], [-117.88137, 33.6462], [-117.8809, 33.64632], [-117.87895, 33.64644], [-117.87853, 33.64644], [-117.87817, 33.64626], [-117.87799, 33.64614], [-117.87779, 33.64607], [-117.87661, 33.6457], [-117.87624, 33.64562], [-117.87588, 33.64556], [-117.87472, 33.64547], [-117.87401, 33.64551], [-117.87283, 33.64533], [-117.87265, 33.64533], [-117.87246, 33.64535], [-117.87244, 33.64534], [-117.87177, 33.64537], [-117.87116, 33.64511], [-117.87158, 33.6452], [-117.87178, 33.64521], [-117.87191, 33.6452], [-117.87256, 33.64508], [-117.87274, 33.64508], [-117.87339, 33.64517], [-117.87432, 33.64536], [-117.87441, 33.64536], [-117.87465, 33.64531], [-117.87484, 33.6453], [-117.87506, 33.64535], [-117.87571, 33.64536], [-117.87589, 33.64537], [-117.87689, 33.64562], [-117.87736, 33.64565], [-117.87757, 33.64569], [-117.87787, 33.64588], [-117.87801, 33.64593], [-117.87842, 33.64602], [-117.87878, 33.64602], [-117.8813, 33.64536], [-117.88168, 33.64514], [-117.88189, 33.64483], [-117.88195, 33.64456], [-117.88204, 33.64288], [-117.88185, 33.64287], [-117.88185, 33.64279], [-117.88204, 33.64279], [-117.88209, 33.64277], [-117.88232, 33.64202], [-117.88236, 33.64196], [-117.88288, 33.64139], [-117.88295, 33.64145], [-117.88319, 33.6413], [-117.88345, 33.64116], [-117.88358, 33.64112], [-117.8842, 33.64098], [-117.88536, 33.64086]]]} | Open Access 1 | 18395 | Upper Newport Bay Nature Preserve | 26732 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 18.576 | Upper Newport Bay Nature Preserve | 0 | Local Conservation Area 4 | 2 | |
10405 | 10405 | 10404 | {"type": "Polygon", "coordinates": [[[-117.8834, 33.65287], [-117.88279, 33.65322], [-117.88239, 33.6535], [-117.88162, 33.65407], [-117.88134, 33.65422], [-117.88214, 33.65355], [-117.88214, 33.65353], [-117.8818, 33.65332], [-117.88142, 33.65315], [-117.88102, 33.65301], [-117.8796, 33.65272], [-117.87919, 33.65258], [-117.87899, 33.65248], [-117.87849, 33.65219], [-117.87799, 33.65203], [-117.87759, 33.65187], [-117.87644, 33.65108], [-117.87585, 33.65094], [-117.87545, 33.65088], [-117.87483, 33.65085], [-117.8742, 33.65087], [-117.87418, 33.65155], [-117.87412, 33.65161], [-117.87303, 33.65086], [-117.87424, 33.65054], [-117.87548, 33.65047], [-117.87553, 33.65046], [-117.87556, 33.65047], [-117.87636, 33.65059], [-117.87714, 33.65077], [-117.87817, 33.65111], [-117.87883, 33.65136], [-117.87933, 33.65162], [-117.87978, 33.65172], [-117.88007, 33.65181], [-117.88053, 33.65186], [-117.8834, 33.65287]]]} | Open Access 1 | 18398 | Upper Newport Bay Nature Preserve | 26732 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 19.731 | Upper Newport Bay Nature Preserve | 0 | Local Conservation Area 4 | 2 | |
9135 | 9135 | 9134 | {"type": "Polygon", "coordinates": [[[-121.8062, 36.9086], [-121.80603, 36.90929], [-121.80576, 36.90997], [-121.80555, 36.91066], [-121.80541, 36.91092], [-121.80506, 36.91124], [-121.8049, 36.9115], [-121.80481, 36.91148], [-121.80472, 36.91147], [-121.80272, 36.91153], [-121.80291, 36.90858], [-121.8062, 36.9086]]]} | Restricted Access 2 | 16765 | Harkins Slough | 28149 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | Santa Cruz 5 | 20.48 | Harkins Slough | 0 | Local Conservation Area 4 | 2 | |
14809 | 14809 | 14808 | {"type": "Polygon", "coordinates": [[[-117.14066, 33.25449], [-117.14028, 33.2546], [-117.14032, 33.2547], [-117.14037, 33.25475], [-117.14057, 33.25543], [-117.1406, 33.25571], [-117.14058, 33.2559], [-117.14028, 33.25665], [-117.14037, 33.25683], [-117.13807, 33.25672], [-117.13802, 33.25307], [-117.13827, 33.25307], [-117.13853, 33.25318], [-117.13868, 33.25322], [-117.13897, 33.25337], [-117.13918, 33.25314], [-117.13955, 33.25349], [-117.14011, 33.25382], [-117.14025, 33.25392], [-117.14035, 33.25403], [-117.14066, 33.25449]]]} | Restricted Access 2 | 45227 | Knollwood Preserve | 31493 | 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 | San Diego 4 | 20.712 | Knollwood Preserve | 0 | Local Conservation Area 4 | 2 | |
10185 | 10185 | 10184 | {"type": "MultiPolygon", "coordinates": [[[[-120.51236, 35.03141], [-120.51151, 35.03142], [-120.50616, 35.0315], [-120.50672, 35.03036], [-120.50677, 35.03033], [-120.50812, 35.0308], [-120.50813, 35.03123], [-120.51014, 35.03122], [-120.5108, 35.03095], [-120.51138, 35.03074], [-120.51225, 35.03007], [-120.51225, 35.02817], [-120.5119, 35.02817], [-120.5119, 35.02787], [-120.51192, 35.02784], [-120.51196, 35.02782], [-120.51235, 35.02782], [-120.51236, 35.03141]]], [[[-120.50742, 35.03009], [-120.50724, 35.03034], [-120.50686, 35.03021], [-120.50683, 35.03017], [-120.50683, 35.03014], [-120.50708, 35.02961], [-120.50714, 35.02943], [-120.50717, 35.0294], [-120.50723, 35.0294], [-120.50741, 35.02947], [-120.50714, 35.02999], [-120.50742, 35.03009]]], [[[-120.50768, 35.02852], [-120.50733, 35.02929], [-120.50726, 35.02926], [-120.50723, 35.02921], [-120.50728, 35.02905], [-120.50756, 35.02853], [-120.50761, 35.0285], [-120.50768, 35.02852]]], [[[-120.51174, 35.02817], [-120.51117, 35.02818], [-120.51117, 35.02918], [-120.5108, 35.02919], [-120.51056, 35.02923], [-120.51033, 35.02932], [-120.51011, 35.02947], [-120.5095, 35.02885], [-120.50923, 35.02904], [-120.50905, 35.02889], [-120.50882, 35.02877], [-120.50771, 35.02838], [-120.50767, 35.02833], [-120.50791, 35.02787], [-120.50797, 35.02784], [-120.50911, 35.02784], [-120.51168, 35.02782], [-120.51172, 35.02784], [-120.51174, 35.02787], [-120.51174, 35.02817]]]]} | Open Access 1 | 17778 | Mesa Meadows Natural Area | 22177 | 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 | 21.08 | Mesa Meadows Natural Area | 0 | Local Conservation Area 4 | 2 | |
4918 | 4918 | 4917 | {"type": "Polygon", "coordinates": [[[-116.70363, 32.61525], [-116.70362, 32.61622], [-116.69898, 32.61612], [-116.69901, 32.6143], [-116.70262, 32.61442], [-116.70298, 32.61427], [-116.70332, 32.61396], [-116.70321, 32.61425], [-116.70363, 32.61525]]]} | No Public Access 3 | 5150 | MSCP Open Space Preserve Land | 22571 | 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 | San Diego 4 | 21.27 | MSCP OSP Land | 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]);