units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
397 rows where ACCESS_TYP = 1 and MNG_AG_TYP = 1 sorted by YR_EST
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2310 | 2310 | 2309 | {"type": "Polygon", "coordinates": [[[-121.92312, 36.5969], [-121.92318, 36.59762], [-121.92312, 36.59806], [-121.923, 36.5986], [-121.92255, 36.59947], [-121.92183, 36.60013], [-121.92095, 36.60074], [-121.91985, 36.60141], [-121.91903, 36.6018], [-121.91822, 36.60194], [-121.91724, 36.60199], [-121.9165, 36.60184], [-121.91586, 36.60158], [-121.91552, 36.60131], [-121.91559, 36.60065], [-121.91543, 36.60044], [-121.91448, 36.59989], [-121.91381, 36.60021], [-121.91357, 36.60054], [-121.91197, 36.60164], [-121.91157, 36.60177], [-121.91126, 36.60175], [-121.92118, 36.59454], [-121.92106, 36.59486], [-121.92103, 36.59512], [-121.92104, 36.59525], [-121.92109, 36.59544], [-121.92121, 36.59564], [-121.92132, 36.59575], [-121.92143, 36.59583], [-121.92312, 36.5969]]]} | Open Access 1 | 16954 | Huckleberry Hill Nature Preserve - Presidio/City | 20132 | 198 | United States Department of Defense 61 | Federal 1 | Federal Agency 1 | http://www.defense.gov/ | US Military/Defense 11 | 198 | United States Department of Defense 504 | Federal 1 | Federal Agency 1 | Monterey 14 | 91.68 | Huckleberry Hill Nature Preserve - Presidio/City | None 193 | |||
3092 | 3092 | 3091 | {"type": "MultiPolygon", "coordinates": [[[[-122.50346, 40.63652], [-122.50346, 40.63912], [-122.50327, 40.63918], [-122.50131, 40.63907], [-122.49859, 40.63901], [-122.49788, 40.63902], [-122.49787, 40.63908], [-122.49371, 40.63742], [-122.49382, 40.63681], [-122.50346, 40.63652]]], [[[-122.52689, 40.65487], [-122.52646, 40.6586], [-122.52177, 40.65854], [-122.52219, 40.65493], [-122.52469, 40.65491], [-122.52521, 40.65444], [-122.5266, 40.65469], [-122.52689, 40.65487]]]]} | Open Access 1 | 25177 | Ash Creek WA | 15647 | 103 | United States Bureau of Reclamation 369 | Federal 1 | Federal Agency 1 | http://www.usbr.gov/ | Other Federal 13 | 103 | United States Bureau of Reclamation 364 | Federal 1 | Federal Agency 1 | Shasta 27 | 87.712 | Ash Creek WA | None 251 | |||
3130 | 3130 | 3129 | {"type": "MultiPolygon", "coordinates": [[[[-120.12091, 37.14841], [-120.1202, 37.1484], [-120.12022, 37.14807], [-120.11991, 37.14744], [-120.11891, 37.14665], [-120.11848, 37.14651], [-120.11311, 37.14264], [-120.11265, 37.14235], [-120.11132, 37.14138], [-120.11132, 37.14127], [-120.11243, 37.14128], [-120.11915, 37.14615], [-120.11933, 37.14643], [-120.12079, 37.1475], [-120.12091, 37.14841]]], [[[-120.12237, 37.15854], [-120.12117, 37.15884], [-120.12026, 37.15686], [-120.12025, 37.15548], [-120.11762, 37.15546], [-120.11901, 37.15433], [-120.12017, 37.1543], [-120.12019, 37.14857], [-120.12097, 37.14857], [-120.12092, 37.15196], [-120.12093, 37.15573], [-120.12146, 37.15765], [-120.12237, 37.15854]]]]} | Open Access 1 | 25781 | Madera Canal | 21650 | 103 | United States Bureau of Reclamation 369 | Federal 1 | Federal Agency 1 | http://www.usbr.gov/ | Other Federal 13 | 103 | United States Bureau of Reclamation 364 | Federal 1 | Federal Agency 1 | Madera 48 | 43.907 | Madera Canal | None 256 | |||
3619 | 3619 | 3618 | {"type": "Polygon", "coordinates": [[[-124.15279, 41.05272], [-124.15266, 41.05284], [-124.15272, 41.05295], [-124.15099, 41.05294], [-124.14977, 41.0522], [-124.14791, 41.0522], [-124.14804, 41.05204], [-124.15015, 41.05077], [-124.15132, 41.05109], [-124.15127, 41.05121], [-124.15209, 41.05174], [-124.15279, 41.05272]]]} | Open Access 1 | 29668 | Coastal Access | 17464 | 104 | United States Coast Guard 511 | Federal 1 | Federal Agency 1 | http://www.uscg.mil/ | Other Federal 13 | 104 | United States Coast Guard 503 | Federal 1 | Federal Agency 1 | Humboldt 45 | 12.649 | Coastal Access | None 302 | |||
3683 | 3683 | 3682 | {"type": "Polygon", "coordinates": [[[-121.5054, 38.33521], [-121.50491, 38.33521], [-121.50369, 38.32789], [-121.50242, 38.32788], [-121.5012, 38.32057], [-121.50296, 38.32058], [-121.5054, 38.33521]]]} | Open Access 1 | 44405 | Sun River Project | 25977 | 103 | United States Bureau of Reclamation 369 | Federal 1 | Federal Agency 1 | http://www.usbr.gov/ | Other Federal 13 | 103 | United States Bureau of Reclamation 364 | Federal 1 | Federal Agency 1 | Sacramento 41 | 39.49 | Sun River Project | None 308 | |||
4155 | 4155 | 4154 | {"type": "Polygon", "coordinates": [[[-120.4371, 39.25133], [-120.43698, 39.25857], [-120.41847, 39.25868], [-120.41863, 39.25142], [-120.42787, 39.25136], [-120.4371, 39.25133]]]} | Open Access 1 | 44724 | Devil's Peak | 14015 | 107 | United States Forest Service 38 | Federal 1 | Federal Agency 1 | http://www.fs.fed.us/ | US Forest Service 7 | 107 | United States Forest Service 37 | Federal 1 | Federal Agency 1 | Placer 35 | 317.682 | Devil's Peak | None 359 | |||
4822 | 4822 | 4821 | {"type": "Polygon", "coordinates": [[[-121.83228, 36.63102], [-121.83235, 36.63119], [-121.83237, 36.63144], [-121.83233, 36.63172], [-121.83214, 36.63209], [-121.83126, 36.63335], [-121.83034, 36.63271], [-121.82997, 36.63238], [-121.83091, 36.63158], [-121.83117, 36.63142], [-121.83217, 36.63099], [-121.83228, 36.63102]]]} | Open Access 1 | 48913 | Unknown park - United States Department of Defense | 33634 | 198 | United States Department of Defense 61 | Federal 1 | Federal Agency 1 | http://www.defense.gov/ | US Military/Defense 11 | 198 | United States Department of Defense 504 | Federal 1 | Federal Agency 1 | Monterey 14 | 7.047 | None 404 | ||||
6000 | 6000 | 5999 | {"type": "MultiPolygon", "coordinates": [[[[-119.90427, 38.00765], [-119.90155, 38.00769], [-119.90426, 38.00764], [-119.90417, 37.99681], [-119.89503, 37.99692], [-119.90419, 37.9968], [-119.9043, 38.00737], [-119.90427, 38.00765]]], [[[-119.89967, 38.00773], [-119.89967, 38.00761], [-119.89962, 38.00049], [-119.89963, 38.00049], [-119.89967, 38.00773]]], [[[-119.91335, 38.00029], [-119.90878, 38.00036], [-119.90882, 38.00455], [-119.90877, 38.00035], [-119.91335, 38.00029]]], [[[-119.91747, 38.00745], [-119.91346, 38.00751], [-119.91346, 38.00751], [-119.91346, 38.00751], [-119.91747, 38.00745]]], [[[-119.91643, 38.00385], [-119.91643, 38.00385], [-119.91388, 38.00389], [-119.91641, 38.00384], [-119.91643, 38.00385]]]]} | Open Access 1 | 647 | Hetch Hetchy Water and Power | 19887 | 107 | United States Forest Service 38 | Federal 1 | Federal Agency 1 | http://www.fs.fed.us/ | US Forest Service 7 | 107 | United States Forest Service 37 | Federal 1 | Federal Agency 1 | Tuolumne 21 | 1.045 | Hetch Hetchy Water and Power | None 483 | |||
6506 | 6506 | 6505 | {"type": "Polygon", "coordinates": [[[-117.3335, 35.30333], [-117.33291, 35.30939], [-117.32491, 35.31041], [-117.32488, 35.30386], [-117.3335, 35.30333]]]} | Open Access 1 | 2426 | US Dept of Interior | 26742 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | http://www.blm.gov/wo/st/en.html | US Bureau of Land Management 1 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | San Bernardino 22 | 130.198 | US Dept of Interior | None 525 | |||
7012 | 7012 | 7011 | {"type": "Polygon", "coordinates": [[[-118.29494, 33.706], [-118.29474, 33.70626], [-118.29296, 33.7054], [-118.29347, 33.70526], [-118.2937, 33.70507], [-118.29383, 33.7049], [-118.29412, 33.70493], [-118.29436, 33.70513], [-118.29437, 33.70542], [-118.29462, 33.70546], [-118.29464, 33.70561], [-118.29494, 33.706]]]} | Open Access 1 | 5950 | Point Fermin Lighthouse | 23849 | 104 | United States Coast Guard 511 | Federal 1 | Federal Agency 1 | http://www.uscg.mil/ | Other Federal 13 | 104 | United States Coast Guard 503 | Federal 1 | Federal Agency 1 | Los Angeles 6 | 2.92 | Point Fermin Lighthouse | None 572 | |||
7293 | 7293 | 7292 | {"type": "MultiPolygon", "coordinates": [[[[-118.01784, 34.03317], [-118.01637, 34.03369], [-118.01597, 34.03343], [-118.01578, 34.03332], [-118.01537, 34.03313], [-118.01494, 34.03296], [-118.01452, 34.03284], [-118.01405, 34.03273], [-118.0137, 34.03268], [-118.01324, 34.03264], [-118.01251, 34.03265], [-118.00974, 34.03282], [-118.00678, 34.03311], [-118.00624, 34.03311], [-118.00493, 34.03305], [-118.00415, 34.03306], [-118.0047, 34.03204], [-118.00526, 34.03207], [-118.00593, 34.03205], [-118.01346, 34.0313], [-118.01347, 34.03152], [-118.014, 34.03159], [-118.01473, 34.03174], [-118.01539, 34.03193], [-118.01594, 34.03213], [-118.01646, 34.03237], [-118.01676, 34.03253], [-118.01784, 34.03317]]], [[[-118.02359, 34.03666], [-118.0233, 34.03661], [-118.02246, 34.03717], [-118.01999, 34.03569], [-118.01964, 34.03556], [-118.019, 34.03519], [-118.01847, 34.03488], [-118.01846, 34.03483], [-118.01676, 34.03384], [-118.01816, 34.03334], [-118.02047, 34.03471], [-118.02066, 34.03491], [-118.02335, 34.0365], [-118.02359, 34.03666]]]]} | Open Access 1 | 6572 | San Jose Creek | 24914 | 100 | United States Army Corps of Engineers 146 | Federal 1 | Federal Agency 1 | http://www.usace.army.mil/ | Other Federal 13 | 100 | United States Army Corps of Engineers 142 | Federal 1 | Federal Agency 1 | http://www.usace.army.mil/ | Los Angeles 6 | 55.286 | San Jose Creek | None 603 | ||
7939 | 7939 | 7938 | {"type": "Polygon", "coordinates": [[[-117.95634, 33.63093], [-117.95288, 33.64311], [-117.95175, 33.64313], [-117.95345, 33.63665], [-117.95199, 33.63459], [-117.95135, 33.63437], [-117.95087, 33.63372], [-117.95103, 33.63333], [-117.94856, 33.63291], [-117.94753, 33.63218], [-117.94809, 33.6321], [-117.94897, 33.63202], [-117.94984, 33.6315], [-117.95035, 33.63024], [-117.95123, 33.6295], [-117.95193, 33.62931], [-117.9528, 33.62956], [-117.95343, 33.62978], [-117.95493, 33.63058], [-117.95634, 33.63093]]]} | Open Access 1 | 10770 | Salt Marsh Restoration | 24811 | 100 | United States Army Corps of Engineers 146 | Federal 1 | Federal Agency 1 | http://www.usace.army.mil/ | Other Federal 13 | 100 | United States Army Corps of Engineers 142 | Federal 1 | Federal Agency 1 | Orange 3 | 101.681 | Salt Marsh Restoration | None 660 | |||
8001 | 8001 | 8000 | {"type": "Polygon", "coordinates": [[[-122.51612, 38.78782], [-122.51607, 38.78848], [-122.51598, 38.78899], [-122.51594, 38.7894], [-122.5158, 38.78991], [-122.51562, 38.79035], [-122.51537, 38.7908], [-122.51516, 38.79114], [-122.51473, 38.79152], [-122.51393, 38.79201], [-122.51347, 38.79227], [-122.51293, 38.79235], [-122.51216, 38.79226], [-122.51186, 38.79219], [-122.51069, 38.79201], [-122.51012, 38.79196], [-122.51012, 38.79106], [-122.50107, 38.79096], [-122.49151, 38.7907], [-122.49123, 38.79432], [-122.48652, 38.7942], [-122.48671, 38.79057], [-122.48194, 38.79044], [-122.48188, 38.79214], [-122.48129, 38.79189], [-122.48107, 38.79177], [-122.48088, 38.79164], [-122.4807, 38.79145], [-122.48046, 38.79125], [-122.48022, 38.7911], [-122.48001, 38.79093], [-122.47977, 38.79071], [-122.47962, 38.79051], [-122.47943, 38.79033], [-122.47741, 38.79023], [-122.47748, 38.7866], [-122.48204, 38.78678], [-122.48216, 38.78314], [-122.49496, 38.77032], [-122.49673, 38.7718], [-122.50565, 38.77269], [-122.50628, 38.77324], [-122.51133, 38.77737], [-122.51504, 38.78693], [-122.51612, 38.78782]]]} | Open Access 1 | 11115 | Department of Defense | 18095 | 100 | United States Army Corps of Engineers 146 | Federal 1 | Federal Agency 1 | http://www.usace.army.mil/ | Other Federal 13 | 100 | United States Army Corps of Engineers 142 | Federal 1 | Federal Agency 1 | Lake 40 | 1307.764 | Department of Defense | None 668 | |||
8114 | 8114 | 8113 | {"type": "MultiPolygon", "coordinates": [[[[-118.49444, 34.16485], [-118.49256, 34.16484], [-118.49252, 34.16479], [-118.49252, 34.16402], [-118.49444, 34.16402], [-118.49444, 34.16485]]], [[[-118.49868, 34.16866], [-118.49868, 34.16878], [-118.49696, 34.16775], [-118.49431, 34.16604], [-118.49381, 34.16578], [-118.4935, 34.16564], [-118.49295, 34.16543], [-118.49252, 34.1653], [-118.49253, 34.16504], [-118.49257, 34.16501], [-118.49601, 34.16502], [-118.49602, 34.16639], [-118.49867, 34.16641], [-118.49868, 34.16866]]]]} | Open Access 1 | 12239 | Sepulveda Garden Center | 25304 | 100 | United States Army Corps of Engineers 146 | Federal 1 | Federal Agency 1 | http://www.usace.army.mil/ | Other Federal 13 | 100 | United States Army Corps of Engineers 142 | Federal 1 | Federal Agency 1 | Los Angeles 6 | 24.1 | Sepulveda Garden Ctr. | None 677 | |||
8369 | 8369 | 8368 | {"type": "MultiPolygon", "coordinates": [[[[-116.0092, 33.42654], [-116.00913, 33.44087], [-115.9918, 33.44094], [-115.9916, 33.45547], [-115.97409, 33.4555], [-115.97389, 33.47011], [-115.99134, 33.4701], [-115.99114, 33.48451], [-115.97371, 33.48456], [-115.97378, 33.49917], [-115.99115, 33.49919], [-115.99146, 33.51068], [-115.97404, 33.51079], [-115.97378, 33.49918], [-115.95644, 33.49917], [-115.9563, 33.5002], [-115.95651, 33.50987], [-115.95652, 33.51085], [-115.93931, 33.51084], [-115.93905, 33.49918], [-115.92182, 33.49937], [-115.92185, 33.48464], [-115.93918, 33.4846], [-115.93924, 33.47014], [-115.92192, 33.47016], [-115.92195, 33.45559], [-115.90464, 33.45563], [-115.90466, 33.44096], [-115.88727, 33.44099], [-115.88723, 33.42704], [-115.9044, 33.42691], [-115.90469, 33.4272], [-115.90467, 33.44096], [-115.92196, 33.44092], [-115.92198, 33.44091], [-115.9221, 33.42682], [-115.92217, 33.42678], [-115.93945, 33.42674], [-115.93938, 33.44093], [-115.95682, 33.44096], [-115.95683, 33.44095], [-115.95693, 33.42693], [-115.95702, 33.42689], [-115.97434, 33.42665], [-115.97441, 33.42673], [-115.97423, 33.44094], [-115.99179, 33.44093], [-115.99202, 33.42654], [-116.0, 33.42649], [-116.00001, 33.42663], [-116.0092, 33.42654]], [[-115.92931, 33.44093], [-115.92197, 33.44093], [-115.92196, 33.45558], [-115.9393, 33.45555], [-115.93937, 33.44094], [-115.92931, 33.44093]], [[-115.95644, 33.48457], [-115.95219, 33.48457], [-115.9523, 33.48127], [-115.95229, 33.48126], [-115.94785, 33.48133], [-115.94782, 33.48458], [-115.93919, 33.4846], [-115.93906, 33.49918], [-115.95643, 33.49916], [-115.95644, 33.48457]], [[-115.95657, 33.47012], [-115.95672, 33.45555], [-115.9393, 33.45555], [-115.93925, 33.47013], [-115.95657, 33.47012]], [[-115.9737, 33.48456], [-115.97388, 33.47012], [-115.95658, 33.47012], [-115.95644, 33.48456], [-115.9737, 33.48456]], [[-115.97423, 33.44095], [-115.97422, 33.44094], [-115.95682, 33.44096], [-115.95672, 33.45554], [-115.9741, 33.45548], [-115.97423, 33.44095]]], [[[-115.89915, 33.48471], [-115.89576, 33.48471], [-115.89558, 33.48097], [-115.89558, 33.48097], [-115.89915, 33.48471]]], [[[-116.07001, 33.51275], [-116.06976, 33.51285], [-116.06933, 33.51281], [-116.06921, 33.51272], [-116.06837, 33.51274], [-116.06779, 33.51297], [-116.06738, 33.51334], [-116.06708, 33.514], [-116.06692, 33.51581], [-116.06645, 33.51597], [-116.06585, 33.51606], [-116.06519, 33.51574], [-116.0638, 33.51462], [-116.06339, 33.5146], [-116.06219, 33.51483], [-116.06118, 33.51482], [-116.06114, 33.51058], [-116.06996, 33.51054], [-116.07001, 33.51275]]]]} | Open Access 1 | 12968 | Salton Sea - Bureau of Rec | 13839 | 103 | United States Bureau of Reclamation 369 | Federal 1 | Federal Agency 1 | http://www.usbr.gov/ | Other Federal 13 | 103 | United States Bureau of Reclamation 364 | Federal 1 | Federal Agency 1 | Riverside 10 | 9406.511 | Salton Sea - Bureau of Rec | None 700 | |||
8382 | 8382 | 8381 | {"type": "MultiPolygon", "coordinates": [[[[-115.9801, 33.42661], [-115.97443, 33.42663], [-115.97442, 33.42664], [-115.97441, 33.42673], [-115.97434, 33.42665], [-115.95702, 33.42689], [-115.95693, 33.42693], [-115.95692, 33.42668], [-115.93946, 33.42674], [-115.92217, 33.42678], [-115.9221, 33.42682], [-115.92209, 33.4268], [-115.92157, 33.4268], [-115.9047, 33.42682], [-115.90469, 33.4272], [-115.9044, 33.42691], [-115.88723, 33.42704], [-115.88723, 33.42687], [-115.8872, 33.42684], [-115.87437, 33.42686], [-115.86954, 33.42685], [-115.86953, 33.4268], [-115.85711, 33.42683], [-115.8523, 33.42677], [-115.83855, 33.42687], [-115.83863, 33.41583], [-115.83444, 33.4159], [-115.83431, 33.4122], [-115.82237, 33.41239], [-115.82216, 33.40829], [-115.805, 33.40829], [-115.8046, 33.40309], [-115.80427, 33.39806], [-115.80417, 33.39805], [-115.79478, 33.39803], [-115.79427, 33.39009], [-115.78673, 33.39007], [-115.78666, 33.38349], [-115.77783, 33.38352], [-115.77784, 33.37563], [-115.7695, 33.37556], [-115.76961, 33.36901], [-115.77388, 33.36893], [-115.77389, 33.36892], [-115.77377, 33.36468], [-115.76965, 33.36466], [-115.76973, 33.35429], [-115.73443, 33.3544], [-115.73443, 33.34813], [-115.73448, 33.34815], [-115.73457, 33.33953], [-115.75236, 33.33955], [-115.75246, 33.32209], [-115.75082, 33.32207], [-115.73575, 33.32203], [-115.73573, 33.32261], [-115.73445, 33.33953], [-115.71712, 33.33982], [-115.71842, 33.32266], [-115.71842, 33.32201], [-115.70109, 33.32203], [-115.69967, 33.3396], [-115.71685, 33.33967], [-115.71677, 33.35435], [-115.69959, 33.3546], [-115.69947, 33.33984], [-115.68235, 33.33986], [-115.68391, 33.32199], [-115.66668, 33.322], [-115.66671, 33.30727], [-115.68387, 33.30725], [-115.68388, 33.30724], [-115.68377, 33.29269], [-115.66664, 33.29271], [-115.66663, 33.27821], [-115.68376, 33.2782], [-115.68377, 33.27819], [-115.68372, 33.26365], [-115.66654, 33.26369], [-115.66655, 33.25004], [-115.66651, 33.24915], [-115.68367, 33.24914], [-115.68375, 33.25004], [-115.68373, 33.26364], [-115.701, 33.2637], [-115.70108, 33.25005], [-115.70102, 33.24916], [-115.70103, 33.24913], [-115.71817, 33.24918], [-115.71823, 33.25005], [-115.71823, 33.26373], [-115.73556, 33.26381], [-115.73558, 33.2638], [-115.73558, 33.25003], [-115.73557, 33.24921], [-115.73559, 33.2492], [-115.7356, 33.24917], [-115.75081, 33.24922], [-115.75249, 33.24929], [-115.75256, 33.25004], [-115.75251, 33.26379], [-115.76992, 33.26536], [-115.76993, 33.26535], [-115.77001, 33.25062], [-115.78727, 33.25067], [-115.78726, 33.26543], [-115.80454, 33.26546], [-115.80455, 33.26545], [-115.80456, 33.25073], [-115.8218, 33.25074], [-115.8218, 33.26548], [-115.83918, 33.2655], [-115.83919, 33.26549], [-115.83917, 33.25073], [-115.85637, 33.25077], [-115.85634, 33.26547], [-115.8392, 33.2655], [-115.83925, 33.28014], [-115.85631, 33.28015], [-115.85623, 33.29485], [-115.8744, 33.29468], [-115.87406, 33.30937], [-115.89231, 33.30941], [-115.89218, 33.29486], [-115.90977, 33.29499], [-115.90982, 33.3022], [-115.9098, 33.30221], [-115.90987, 33.30952], [-115.92741, 33.30958], [-115.92745, 33.32395], [-115.93775, 33.32398], [-115.93888, 33.32469], [-115.93952, 33.32598], [-115.93964, 33.32635], [-115.93994, 33.32682], [-115.94011, 33.32694], [-115.94065, 33.32664], [-115.94254, 33.32529], [-115.94291, 33.32552], [-115.94202, 33.32621], [-115.94144, 33.32669], [-115.94089, 33.32685], [-115.94032, 33.32744], [-115.94032, 33.32802], [-115.94016, 33.32835], [-115.94054, 33.32829], [-115.94087, 33.32813], [-115.94098, 33.32754], [-115.94133, 33.32717], [-115.94234, 33.3265], [-115.94292, 33.32634], [-115.94384, 33.32635], [-115.94417, 33.32651], [-115.94412, 33.32699], [-115.94387, 33.32778], [-115.94291, 33.32804], [-115.94273, 33.32822], [-115.94256, 33.32879], [-115.94227, 33.329], [-115.94183, 33.32895], [-115.94125, 33.32866], [-115.94087, 33.32866], [-115.94062, 33.32877], [-115.94005, 33.32886], [-115.94003, 33.32931], [-115.94215, 33.32951], [-115.94368, 33.33008], [-115.94451, 33.33059], [-115.94493, 33.33105], [-115.94494, 33.33904], [-115.95674, 33.33897], [-115.9588, 33.33993], [-115.95951, 33.34061], [-115.96082, 33.34249], [-115.96208, 33.34588], [-115.96235, 33.34717], [-115.96252, 33.34744], [-115.96261, 33.34751], [-115.96262, 33.35358], [-115.96832, 33.35358], [-115.96893, 33.35413], [-115.96964, 33.3544], [-115.97019, 33.35447], [-115.97076, 33.35442], [-115.97142, 33.35397], [-115.97161, 33.35399], [-115.97166, 33.35459], [-115.97248, 33.35577], [-115.97295, 33.35619], [-115.97325, 33.3563], [-115.97472, 33.35644], [-115.97521, 33.35669], [-115.97622, 33.35777], [-115.97649, 33.35775], [-115.97704, 33.35733], [-115.97764, 33.35729], [-115.9781, 33.35738], [-115.97865, 33.35779], [-115.97952, 33.358], [-115.97987, 33.3582], [-115.97988, 33.36828], [-115.96262, 33.36831], [-115.96261, 33.35359], [-115.94492, 33.35362], [-115.94493, 33.36832], [-115.9626, 33.36832], [-115.96255, 33.38288], [-115.97992, 33.38278], [-115.97998, 33.39751], [-115.96255, 33.39761], [-115.96255, 33.41241], [-115.96256, 33.41242], [-115.98005, 33.41199], [-115.9801, 33.42661]], [[-115.68378, 33.29267], [-115.70106, 33.29273], [-115.70107, 33.27824], [-115.68377, 33.2782], [-115.68378, 33.29267]], [[-115.70108, 33.32203], [-115.70116, 33.30733], [-115.68388, 33.30725], [-115.68392, 33.32199], [-115.70108, 33.32203]], [[-115.71823, 33.26374], [-115.70101, 33.26371], [-115.70108, 33.27823], [-115.71832, 33.27827], [-115.71823, 33.26374]], [[-115.73573, 33.32203], [-115.73574, 33.32202], [-115.73572, 33.30752], [-115.7525, 33.30765], [-115.75252, 33.29293], [-115.75082, 33.29293], [-115.73564, 33.29284], [-115.73563, 33.27832], [-115.71833, 33.27827], [-115.71836, 33.29279], [-115.70106, 33.29274], [-115.70116, 33.30733], [-115.71845, 33.30744], [-115.71843, 33.322], [-115.73573, 33.32203]], [[-115.73563, 33.27831], [-115.75083, 33.27839], [-115.75248, 33.27837], [-115.75251, 33.2638], [-115.73558, 33.26381], [-115.73563, 33.27831]], [[-115.76993, 33.32338], [-115.76994, 33.32337], [-115.76998, 33.30876], [-115.75251, 33.30766], [-115.75247, 33.32209], [-115.76993, 33.32338]], [[-115.7525, 33.27838], [-115.75249, 33.27838], [-115.75252, 33.29292], [-115.76998, 33.29428], [-115.76996, 33.27998], [-115.7525, 33.27838]], [[-115.80397, 33.35408], [-115.80408, 33.33952], [-115.7871, 33.33961], [-115.78723, 33.32344], [-115.76995, 33.32338], [-115.76982, 33.3397], [-115.76973, 33.35342], [-115.76974, 33.35428], [-115.78659, 33.35416], [-115.80397, 33.35408]], [[-115.76997, 33.27997], [-115.78724, 33.28006], [-115.78726, 33.26544], [-115.76993, 33.26536], [-115.76997, 33.27997]], [[-115.78725, 33.30887], [-115.78726, 33.30886], [-115.78725, 33.29442], [-115.76999, 33.29428], [-115.76998, 33.30875], [-115.78725, 33.30887]], [[-115.78676, 33.37472], [-115.78678, 33.37471], [-115.78684, 33.3687], [-115.77808, 33.36886], [-115.77808, 33.36888], [-115.77903, 33.36936], [-115.77997, 33.37002], [-115.78015, 33.37084], [-115.78068, 33.3708], [-115.7812, 33.37082], [-115.78199, 33.37129], [-115.78256, 33.37194], [-115.7841, 33.37243], [-115.78523, 33.37354], [-115.78542, 33.37436], [-115.78631, 33.37446], [-115.78676, 33.37472]], [[-115.79099, 33.38348], [-115.791, 33.38347], [-115.79088, 33.37926], [-115.78672, 33.37925], [-115.78667, 33.38348], [-115.79099, 33.38348]], [[-115.80421, 33.3235], [-115.8043, 33.309], [-115.78726, 33.30887], [-115.78723, 33.32343], [-115.80421, 33.3235]], [[-115.78725, 33.28006], [-115.78724, 33.28007], [-115.78725, 33.29442], [-115.8044, 33.29454], [-115.80452, 33.2801], [-115.78725, 33.28006]], [[-115.80392, 33.38348], [-115.79734, 33.38347], [-115.79733, 33.38348], [-115.79921, 33.38516], [-115.79984, 33.38568], [-115.80013, 33.38599], [-115.80133, 33.38701], [-115.80156, 33.38715], [-115.80282, 33.3883], [-115.80405, 33.38956], [-115.80406, 33.38955], [-115.80392, 33.38348]], [[-115.82122, 33.36848], [-115.8213, 33.35429], [-115.80398, 33.35407], [-115.80395, 33.36857], [-115.82122, 33.36848]], [[-115.82155, 33.32358], [-115.82154, 33.32357], [-115.80422, 33.3235], [-115.8041, 33.33951], [-115.82146, 33.33939], [-115.82155, 33.32358]], [[-115.83908, 33.29477], [-115.83924, 33.28014], [-115.82177, 33.28013], [-115.82174, 33.29467], [-115.8044, 33.29454], [-115.80431, 33.30899], [-115.82162, 33.30907], [-115.82155, 33.32357], [-115.83896, 33.32365], [-115.839, 33.30915], [-115.85614, 33.30924], [-115.85622, 33.29486], [-115.85621, 33.29485], [-115.83908, 33.29477]], [[-115.80452, 33.28009], [-115.80453, 33.2801], [-115.82176, 33.28012], [-115.82179, 33.26548], [-115.80455, 33.26547], [-115.80452, 33.28009]], [[-115.81409, 33.40009], [-115.81411, 33.40008], [-115.8141, 33.40006], [-115.81409, 33.40007], [-115.81409, 33.40009]], [[-115.85645, 33.39822], [-115.85646, 33.39821], [-115.85586, 33.38346], [-115.83857, 33.38348], [-115.83855, 33.36875], [-115.82124, 33.36848], [-115.82121, 33.37503], [-115.82123, 33.38362], [-115.82163, 33.39779], [-115.82237, 33.39779], [-115.82238, 33.39801], [-115.83906, 33.39793], [-115.85645, 33.39822]], [[-115.83898, 33.32365], [-115.83881, 33.3393], [-115.84797, 33.33927], [-115.85604, 33.33922], [-115.8561, 33.3237], [-115.83898, 33.32365]], [[-115.87405, 33.30938], [-115.87404, 33.30937], [-115.85614, 33.30925], [-115.85611, 33.32369], [-115.87393, 33.32376], [-115.87405, 33.30938]], [[-115.86509, 33.40499], [-115.86468, 33.39821], [-115.85646, 33.39822], [-115.85703, 33.41234], [-115.87441, 33.41234], [-115.87442, 33.40541], [-115.86509, 33.40499]], [[-115.87395, 33.32377], [-115.87371, 33.33912], [-115.89243, 33.33909], [-115.89239, 33.32388], [-115.87395, 33.32377]], [[-115.89245, 33.35369], [-115.89243, 33.35368], [-115.87414, 33.35374], [-115.87451, 33.36866], [-115.89245, 33.36836], [-115.89245, 33.35369]], [[-115.89239, 33.32387], [-115.90996, 33.32391], [-115.90986, 33.30953], [-115.89232, 33.30942], [-115.89239, 33.32387]], [[-115.90997, 33.35365], [-115.90996, 33.33911], [-115.89243, 33.3391], [-115.89245, 33.35368], [-115.90997, 33.35365]], [[-115.89246, 33.36837], [-115.89245, 33.36838], [-115.89257, 33.38356], [-115.90995, 33.38314], [-115.90998, 33.36836], [-115.89246, 33.36837]], [[-115.90996, 33.38314], [-115.90995, 33.38315], [-115.90998, 33.39104], [-115.92745, 33.39088], [-115.92746, 33.38307], [-115.90996, 33.38314]], [[-115.90997, 33.32391], [-115.90996, 33.32392], [-115.90997, 33.33911], [-115.92745, 33.33906], [-115.92745, 33.32396], [-115.90997, 33.32391]], [[-115.92746, 33.35362], [-115.92745, 33.35361], [-115.90998, 33.35365], [-115.90999, 33.36836], [-115.92745, 33.36835], [-115.92746, 33.36833], [-115.92746, 33.35362]], [[-115.94491, 33.35361], [-115.94491, 33.33905], [-115.92745, 33.33907], [-115.92745, 33.35361], [-115.94491, 33.35361]], [[-115.94493, 33.36833], [-115.92745, 33.36835], [-115.92747, 33.38307], [-115.94509, 33.38298], [-115.94495, 33.37032], [-115.94495, 33.36834], [-115.94493, 33.36833]], [[-115.96255, 33.38289], [-115.96254, 33.38288], [-115.9451, 33.38299], [-115.9451, 33.39771], [-115.96254, 33.39762], [-115.96255, 33.38289]]], [[[-116.0247, 33.4117], [-116.01556, 33.41177], [-116.01558, 33.40443], [-116.02458, 33.40421], [-116.0247, 33.4117]]]]} | Open Access 1 | 12967 | Salton Sea - Bureau of Rec | 13839 | 103 | United States Bureau of Reclamation 369 | Federal 1 | Federal Agency 1 | http://www.usbr.gov/ | Other Federal 13 | 103 | United States Bureau of Reclamation 364 | Federal 1 | Federal Agency 1 | Imperial 20 | 57001.771 | Salton Sea - Bureau of Rec | None 702 | |||
10080 | 10080 | 10079 | {"type": "MultiPolygon", "coordinates": [[[[-120.15427, 39.14], [-120.15424, 39.14001], [-120.15311, 39.14001], [-120.15316, 39.13982], [-120.15318, 39.13962], [-120.15416, 39.13964], [-120.15427, 39.14]]], [[[-120.16126, 39.1384], [-120.16124, 39.13992], [-120.15447, 39.13998], [-120.15444, 39.13988], [-120.15437, 39.13959], [-120.15525, 39.13957], [-120.15526, 39.13825], [-120.16126, 39.1384]]]]} | Open Access 1 | 49031 | William Kent Campground and Beach | 33731 | 107 | United States Forest Service 38 | Federal 1 | Federal Agency 1 | http://www.fs.fed.us/ | US Forest Service 7 | 107 | United States Forest Service 37 | Federal 1 | Federal Agency 1 | https://www.fs.usda.gov/wps/portal/fsinternet/cs/recarea?ss=110519&navtype=BROWSEBYSUBJECT&cid=FSE_003738&navid=110240000000000&pnavid=110000000000000&position=generalinfo&recid=11818&ttype=recarea&pname=William%20Kent%20Campground | Placer 35 | 24.743 | William Kent Campground and Beach | None 874 | ||
10394 | 10394 | 10393 | {"type": "MultiPolygon", "coordinates": [[[[-117.53635, 34.18242], [-117.53635, 34.18254], [-117.53248, 34.18227], [-117.53248, 34.18202], [-117.53635, 34.18242]]], [[[-117.54058, 34.18647], [-117.53731, 34.18614], [-117.53731, 34.18611], [-117.54058, 34.18645], [-117.54058, 34.18647]]]]} | Open Access 1 | 18373 | Day Canyon Preserve | 17959 | 107 | United States Forest Service 38 | Federal 1 | Federal Agency 1 | http://www.fs.fed.us/ | US Forest Service 7 | 107 | United States Forest Service 37 | Federal 1 | Federal Agency 1 | San Bernardino 22 | 1.963 | Day Canyon Preserve | None 909 | |||
10465 | 10465 | 10464 | {"type": "Polygon", "coordinates": [[[-121.2868, 35.66504], [-121.28659, 35.66537], [-121.28653, 35.66557], [-121.28641, 35.66562], [-121.28627, 35.66566], [-121.28608, 35.66566], [-121.28598, 35.66564], [-121.28545, 35.66589], [-121.28528, 35.66613], [-121.28525, 35.66616], [-121.28524, 35.6662], [-121.28496, 35.66663], [-121.28494, 35.66677], [-121.28478, 35.66705], [-121.2849, 35.66727], [-121.28486, 35.66745], [-121.28467, 35.66781], [-121.28246, 35.66641], [-121.28254, 35.66637], [-121.28266, 35.66618], [-121.28245, 35.66609], [-121.28237, 35.66601], [-121.28235, 35.66591], [-121.28237, 35.66581], [-121.28267, 35.66554], [-121.28277, 35.66526], [-121.28291, 35.66515], [-121.2829, 35.66506], [-121.28281, 35.66497], [-121.28289, 35.66487], [-121.283, 35.66482], [-121.28319, 35.66476], [-121.28334, 35.66459], [-121.28355, 35.66441], [-121.28375, 35.66429], [-121.28392, 35.66423], [-121.28395, 35.66399], [-121.28405, 35.66388], [-121.28429, 35.66384], [-121.2849, 35.66419], [-121.28531, 35.66433], [-121.28566, 35.66448], [-121.28619, 35.66479], [-121.28641, 35.66489], [-121.28662, 35.66487], [-121.28676, 35.66491], [-121.2868, 35.66504]]]} | Open Access 1 | 18535 | Piedras Blancas Point and Lighthouse | 23661 | 104 | United States Coast Guard 511 | Federal 1 | Federal Agency 1 | http://www.uscg.mil/ | Other Federal 13 | 104 | United States Coast Guard 503 | Federal 1 | Federal Agency 1 | San Luis Obispo 1 | 21.949 | Piedras Blancas Point and Lighthouse | None 913 | |||
10526 | 10526 | 10525 | {"type": "Polygon", "coordinates": [[[-121.93939, 36.63427], [-121.93925, 36.63448], [-121.93893, 36.63443], [-121.93857, 36.63442], [-121.9383, 36.63471], [-121.93823, 36.63491], [-121.93832, 36.63519], [-121.93843, 36.63544], [-121.93836, 36.63567], [-121.93801, 36.63588], [-121.93749, 36.63596], [-121.93687, 36.63628], [-121.93675, 36.63644], [-121.93638, 36.63701], [-121.93624, 36.63733], [-121.93594, 36.63748], [-121.93506, 36.63748], [-121.93425, 36.63759], [-121.93376, 36.63761], [-121.93355, 36.63727], [-121.93325, 36.63702], [-121.93256, 36.63703], [-121.93211, 36.63721], [-121.93127, 36.63728], [-121.93076, 36.63723], [-121.93102, 36.63643], [-121.93124, 36.63648], [-121.93163, 36.63664], [-121.93182, 36.63668], [-121.93201, 36.63669], [-121.93246, 36.63663], [-121.93269, 36.63662], [-121.93304, 36.63665], [-121.93333, 36.6367], [-121.93344, 36.63673], [-121.93356, 36.6368], [-121.93384, 36.63703], [-121.93396, 36.63711], [-121.93411, 36.63716], [-121.93425, 36.63719], [-121.9345, 36.63719], [-121.93509, 36.63703], [-121.93568, 36.63698], [-121.93586, 36.63692], [-121.936, 36.63682], [-121.93616, 36.63664], [-121.9365, 36.6361], [-121.9366, 36.63596], [-121.93671, 36.63587], [-121.93707, 36.63567], [-121.93722, 36.63552], [-121.9374, 36.63525], [-121.93766, 36.63493], [-121.93792, 36.63448], [-121.938, 36.63439], [-121.93823, 36.63422], [-121.93834, 36.63409], [-121.9384, 36.63397], [-121.93843, 36.63387], [-121.93843, 36.63377], [-121.93841, 36.63364], [-121.93837, 36.63354], [-121.93829, 36.63342], [-121.93689, 36.63212], [-121.93678, 36.63196], [-121.93676, 36.63184], [-121.93891, 36.63233], [-121.93898, 36.63239], [-121.93913, 36.63257], [-121.93913, 36.63295], [-121.9389, 36.63329], [-121.93882, 36.6336], [-121.93905, 36.63396], [-121.93939, 36.63427]]]} | Open Access 1 | 18721 | Point Pinos - USCG | 23858 | 104 | United States Coast Guard 511 | Federal 1 | Federal Agency 1 | http://www.uscg.mil/ | Other Federal 13 | 104 | United States Coast Guard 503 | Federal 1 | Federal Agency 1 | Monterey 14 | 17.947 | Point Pinos - USCG | None 921 |
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]);