units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
78 rows where ACCESS_TYP = 1, DES_TP = 4 and MNG_AG_TYP = 3 sorted by ACRES
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, DES_TP
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 |
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 | |
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 | |
9246 | 9246 | 9245 | {"type": "MultiPolygon", "coordinates": [[[[-117.81111, 33.6459], [-117.81107, 33.64602], [-117.81103, 33.64621], [-117.81064, 33.6462], [-117.81052, 33.64615], [-117.81043, 33.64602], [-117.81027, 33.64568], [-117.81001, 33.64552], [-117.80971, 33.64503], [-117.80936, 33.64468], [-117.80921, 33.64469], [-117.80885, 33.64485], [-117.80846, 33.64492], [-117.80839, 33.64464], [-117.80841, 33.64457], [-117.8095, 33.64431], [-117.81045, 33.64542], [-117.81111, 33.6459]]], [[[-117.81472, 33.64741], [-117.81478, 33.64752], [-117.81479, 33.6477], [-117.81477, 33.64785], [-117.81472, 33.64795], [-117.81466, 33.64804], [-117.81422, 33.64845], [-117.81412, 33.64845], [-117.81358, 33.64804], [-117.81336, 33.64791], [-117.81288, 33.64769], [-117.81253, 33.64758], [-117.81251, 33.64738], [-117.81244, 33.64706], [-117.81233, 33.64683], [-117.81223, 33.64671], [-117.81212, 33.64662], [-117.81196, 33.64652], [-117.81171, 33.64643], [-117.81146, 33.64624], [-117.8114, 33.64622], [-117.81133, 33.64628], [-117.81121, 33.64631], [-117.81124, 33.64612], [-117.81128, 33.64601], [-117.81129, 33.64598], [-117.81244, 33.64648], [-117.8127, 33.6467], [-117.81279, 33.6468], [-117.81272, 33.64694], [-117.81295, 33.64713], [-117.81292, 33.64717], [-117.81292, 33.64721], [-117.81296, 33.64727], [-117.81374, 33.64777], [-117.81404, 33.64792], [-117.8142, 33.64798], [-117.81437, 33.6477], [-117.81457, 33.64749], [-117.81472, 33.64741]]], [[[-117.81827, 33.64906], [-117.81816, 33.6491], [-117.81824, 33.64925], [-117.81807, 33.64933], [-117.81763, 33.64949], [-117.8176, 33.6494], [-117.81775, 33.64922], [-117.81786, 33.64874], [-117.81782, 33.64854], [-117.81737, 33.64781], [-117.81712, 33.64759], [-117.81698, 33.64754], [-117.81664, 33.64758], [-117.81656, 33.64751], [-117.81638, 33.64728], [-117.81612, 33.64723], [-117.81597, 33.64726], [-117.81584, 33.6474], [-117.81544, 33.64753], [-117.81525, 33.64772], [-117.81501, 33.64771], [-117.815, 33.64757], [-117.81498, 33.64749], [-117.81492, 33.64739], [-117.81581, 33.64705], [-117.81586, 33.647], [-117.81602, 33.64694], [-117.81604, 33.64689], [-117.81604, 33.64686], [-117.81616, 33.64681], [-117.81618, 33.64683], [-117.81654, 33.64694], [-117.81678, 33.64705], [-117.81691, 33.64712], [-117.81684, 33.64722], [-117.81701, 33.64732], [-117.81728, 33.64751], [-117.81748, 33.64769], [-117.8177, 33.64794], [-117.81787, 33.6482], [-117.81827, 33.64906]]], [[[-117.81731, 33.6546], [-117.81657, 33.65442], [-117.81656, 33.65417], [-117.81637, 33.65388], [-117.81631, 33.6537], [-117.81611, 33.65347], [-117.81582, 33.65336], [-117.81599, 33.65304], [-117.81625, 33.65318], [-117.81628, 33.65352], [-117.81711, 33.65346], [-117.81716, 33.65369], [-117.81721, 33.65384], [-117.81738, 33.65413], [-117.81742, 33.65424], [-117.81743, 33.65446], [-117.81737, 33.65456], [-117.81731, 33.6546]]], [[[-117.81824, 33.65269], [-117.81803, 33.65277], [-117.81795, 33.65312], [-117.81797, 33.65314], [-117.81734, 33.65372], [-117.81731, 33.65359], [-117.8173, 33.65346], [-117.81731, 33.65332], [-117.81733, 33.65323], [-117.81746, 33.653], [-117.81802, 33.65247], [-117.81811, 33.65248], [-117.81819, 33.65253], [-117.81822, 33.65259], [-117.81824, 33.65269]]], [[[-117.81816, 33.65479], [-117.81787, 33.65538], [-117.81745, 33.6551], [-117.81748, 33.65484], [-117.81754, 33.65483], [-117.81759, 33.65477], [-117.8176, 33.65473], [-117.81758, 33.65459], [-117.8176, 33.65446], [-117.8176, 33.65428], [-117.81802, 33.65447], [-117.81816, 33.65479]]], [[[-117.81982, 33.65319], [-117.81947, 33.65332], [-117.81934, 33.65341], [-117.8192, 33.65359], [-117.81923, 33.65351], [-117.81924, 33.65332], [-117.81918, 33.65307], [-117.8188, 33.65227], [-117.81874, 33.65221], [-117.81847, 33.65231], [-117.81843, 33.65245], [-117.81834, 33.65242], [-117.81828, 33.65238], [-117.81823, 33.65233], [-117.81822, 33.6523], [-117.81841, 33.65201], [-117.81855, 33.65184], [-117.81871, 33.6517], [-117.81843, 33.65141], [-117.81894, 33.65052], [-117.81858, 33.65026], [-117.81845, 33.65014], [-117.81828, 33.64999], [-117.81804, 33.64971], [-117.81831, 33.64961], [-117.81843, 33.6496], [-117.81861, 33.6498], [-117.81893, 33.65007], [-117.81931, 33.65033], [-117.81964, 33.65048], [-117.81901, 33.65139], [-117.81963, 33.6528], [-117.81982, 33.65319]]]]} | Open Access 1 | 15391 | Turtle Rock Riparian Corridor | 26598 | 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 | 21.639 | Turtle Rock Riparian Corridor | 0 | Local Conservation Area 4 | 2 | |
16300 | 16300 | 16299 | {"type": "Polygon", "coordinates": [[[-121.31549, 38.16334], [-121.31531, 38.16334], [-121.31523, 38.16345], [-121.31476, 38.16386], [-121.3135, 38.16385], [-121.31336, 38.16368], [-121.31335, 38.16359], [-121.31338, 38.16349], [-121.31374, 38.163], [-121.31386, 38.16277], [-121.3141, 38.16245], [-121.31416, 38.16237], [-121.31418, 38.1623], [-121.31417, 38.16211], [-121.31414, 38.16205], [-121.31396, 38.1618], [-121.31384, 38.16167], [-121.31377, 38.16162], [-121.3136, 38.16147], [-121.3133, 38.16128], [-121.31285, 38.16112], [-121.31259, 38.16107], [-121.31208, 38.16107], [-121.31085, 38.16126], [-121.31056, 38.16127], [-121.31033, 38.16126], [-121.31021, 38.16124], [-121.31015, 38.16078], [-121.31019, 38.15968], [-121.31067, 38.15967], [-121.31194, 38.15973], [-121.31208, 38.15969], [-121.31234, 38.15953], [-121.31297, 38.15966], [-121.31414, 38.16067], [-121.31442, 38.16097], [-121.3147, 38.16131], [-121.31514, 38.16195], [-121.31519, 38.16209], [-121.31529, 38.16229], [-121.31549, 38.16293], [-121.31549, 38.16334]]]} | Open Access 1 | 17364 | Woodbridge Wilderness Area Regional Park | 27697 | 322 | San Joaquin, County of 479 | County 3 | County Agency 3 | http://www.sjparks.com/ | County 3 | 322 | San Joaquin, County of 471 | County 3 | County Agency 3 | San Joaquin 39 | 22.347 | Woodbridge Wilderness Area RP | 0 | Local Conservation Area 4 | 2 | |
6830 | 6830 | 6829 | {"type": "Polygon", "coordinates": [[[-117.18338, 33.25274], [-117.18272, 33.25297], [-117.18189, 33.25323], [-117.18125, 33.25339], [-117.18097, 33.25343], [-117.18104, 33.24925], [-117.18302, 33.24925], [-117.18305, 33.2493], [-117.18316, 33.24949], [-117.18322, 33.24967], [-117.1836, 33.25208], [-117.18366, 33.2523], [-117.18378, 33.25255], [-117.18377, 33.25259], [-117.18374, 33.25261], [-117.18338, 33.25274]]]} | Open Access 1 | 5437 | Gopher Canyon Reserve | 19407 | 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 | 23.859 | Gopher Canyon 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 |
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]);