units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
10 rows where ACCESS_TYP = 1, GAP_STS = 3 and MNG_AG_TYP = 2
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1645 | 1645 | 1644 | {"type": "Polygon", "coordinates": [[[-121.27757, 37.98952], [-121.27753, 37.98957], [-121.27653, 37.98983], [-121.2759, 37.98828], [-121.27639, 37.98797], [-121.27641, 37.98792], [-121.27642, 37.98777], [-121.27646, 37.98766], [-121.2765, 37.9876], [-121.2766, 37.98751], [-121.27663, 37.98751], [-121.27678, 37.98768], [-121.2769, 37.98789], [-121.27757, 37.98952]]]} | Open Access 1 | 47779 | Shady Forest | 31579 | 1343 | Stockton, City of 402 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | San Joaquin 39 | 4.969 | Shady Forest | 0 | Local Resource Management Area 83 | 3 | |
12311 | 12311 | 12310 | {"type": "Polygon", "coordinates": [[[-124.06293, 40.8633], [-124.06168, 40.86382], [-124.06167, 40.86462], [-124.05849, 40.86458], [-124.05808, 40.86461], [-124.05816, 40.86823], [-124.05666, 40.86826], [-124.05695, 40.86793], [-124.056, 40.86703], [-124.05661, 40.86662], [-124.05655, 40.86628], [-124.05593, 40.86594], [-124.05562, 40.86552], [-124.05559, 40.8648], [-124.05405, 40.86469], [-124.05273, 40.86514], [-124.05237, 40.86543], [-124.05212, 40.86571], [-124.05251, 40.86676], [-124.05205, 40.86678], [-124.05186, 40.86676], [-124.05124, 40.86658], [-124.0522, 40.8645], [-124.05184, 40.86447], [-124.05103, 40.86453], [-124.05046, 40.86427], [-124.05034, 40.86406], [-124.04936, 40.86388], [-124.04936, 40.86398], [-124.04909, 40.86398], [-124.04906, 40.86381], [-124.0482, 40.86377], [-124.04815, 40.86218], [-124.04621, 40.86218], [-124.0462, 40.86111], [-124.04623, 40.8611], [-124.04619, 40.86003], [-124.04329, 40.86005], [-124.04329, 40.85365], [-124.04388, 40.85362], [-124.04389, 40.85358], [-124.05275, 40.85358], [-124.05275, 40.85386], [-124.05268, 40.85387], [-124.05261, 40.8544], [-124.05296, 40.85444], [-124.05292, 40.85476], [-124.05565, 40.855], [-124.05558, 40.8563], [-124.05483, 40.85629], [-124.0548, 40.8571], [-124.05575, 40.85701], [-124.05572, 40.85733], [-124.05572, 40.85752], [-124.0561, 40.85751], [-124.05611, 40.85765], [-124.05672, 40.85764], [-124.05673, 40.85781], [-124.05783, 40.8578], [-124.05794, 40.86208], [-124.06258, 40.86195], [-124.06259, 40.86217], [-124.06228, 40.8623], [-124.06293, 40.8633]]]} | Open Access 1 | 46883 | Sunny Brae Forest | 30365 | 1432 | Arcata, City of 587 | City 2 | City Agency 2 | http://www.cityofarcata.org/rec | City 2 | 1432 | Arcata, City of 577 | City 2 | City Agency 2 | http://www.cityofarcata.org/190/City-Forests | Humboldt 45 | 342.381 | Sunny Brae Forest | 0 | Local Resource Management Area 83 | 3 |
13180 | 13180 | 13179 | {"type": "Polygon", "coordinates": [[[-124.07492, 40.87037], [-124.07461, 40.87119], [-124.07397, 40.87105], [-124.0737, 40.87112], [-124.07367, 40.87137], [-124.07234, 40.87141], [-124.07235, 40.8723], [-124.07129, 40.87238], [-124.07056, 40.87281], [-124.0682, 40.87301], [-124.06744, 40.87317], [-124.06677, 40.87295], [-124.06378, 40.87317], [-124.06381, 40.87372], [-124.06444, 40.87406], [-124.06534, 40.87462], [-124.06537, 40.87559], [-124.06714, 40.87566], [-124.06821, 40.87656], [-124.06822, 40.87759], [-124.0653, 40.87896], [-124.06241, 40.87839], [-124.06239, 40.8784], [-124.0624, 40.87901], [-124.06237, 40.88], [-124.06555, 40.88184], [-124.06606, 40.88233], [-124.06712, 40.88074], [-124.06768, 40.8814], [-124.06846, 40.88182], [-124.06902, 40.88199], [-124.07094, 40.88148], [-124.07235, 40.88141], [-124.0722, 40.88199], [-124.07224, 40.88215], [-124.07251, 40.88258], [-124.07253, 40.88301], [-124.07212, 40.88302], [-124.0721, 40.88305], [-124.06825, 40.883], [-124.06812, 40.88314], [-124.06791, 40.88307], [-124.06779, 40.88306], [-124.06763, 40.88299], [-124.06229, 40.88293], [-124.0575, 40.88284], [-124.05761, 40.87934], [-124.0432, 40.87927], [-124.04326, 40.8719], [-124.04336, 40.86838], [-124.04635, 40.86837], [-124.05141, 40.86833], [-124.05143, 40.86674], [-124.0518, 40.86688], [-124.05202, 40.86692], [-124.0521, 40.86691], [-124.05214, 40.86695], [-124.05213, 40.86832], [-124.05283, 40.86832], [-124.05285, 40.87227], [-124.05337, 40.87223], [-124.06248, 40.87221], [-124.06249, 40.87019], [-124.06309, 40.86987], [-124.06369, 40.86962], [-124.06409, 40.86941], [-124.06445, 40.86926], [-124.06465, 40.86922], [-124.06486, 40.86915], [-124.06589, 40.86866], [-124.06606, 40.86862], [-124.06629, 40.86862], [-124.06665, 40.86874], [-124.0669, 40.86879], [-124.06714, 40.86879], [-124.06781, 40.86875], [-124.06879, 40.86889], [-124.06915, 40.8689], [-124.06946, 40.86887], [-124.06977, 40.8688], [-124.0709, 40.86834], [-124.07478, 40.86835], [-124.07413, 40.87001], [-124.0745, 40.87028], [-124.07492, 40.87037]]]} | Open Access 1 | 35163 | Arcata Community Forest | 295 | 1432 | Arcata, City of 587 | City 2 | City Agency 2 | http://www.cityofarcata.org/rec | City 2 | 1432 | Arcata, City of 577 | City 2 | City Agency 2 | http://www.cityofarcata.org/departments/environmental-services/city-forests/trail-map | Humboldt 45 | 635.854 | Arcata Community Forest | 0 | Local Resource Management Area 83 | 3 |
14362 | 14362 | 14361 | {"type": "MultiPolygon", "coordinates": [[[[-123.96881, 40.76594], [-123.96843, 40.77321], [-123.96403, 40.77343], [-123.96412, 40.76959], [-123.95934, 40.76956], [-123.95942, 40.76594], [-123.96881, 40.76594]]], [[[-124.02575, 40.80099], [-124.0257, 40.80435], [-124.0238, 40.80431], [-124.02377, 40.80399], [-124.02352, 40.8035], [-124.01846, 40.80341], [-124.01846, 40.80343], [-124.01876, 40.8037], [-124.02005, 40.80424], [-124.01847, 40.8042], [-124.01839, 40.80273], [-124.01563, 40.8027], [-124.01563, 40.79911], [-124.01105, 40.79908], [-124.01102, 40.7955], [-124.00601, 40.79549], [-124.006, 40.7955], [-124.00618, 40.80264], [-124.00165, 40.80259], [-124.00144, 40.79549], [-123.99235, 40.79551], [-123.99251, 40.79172], [-123.98774, 40.79175], [-123.98815, 40.78049], [-123.96805, 40.78043], [-123.96824, 40.77693], [-123.9731, 40.77694], [-123.97319, 40.77324], [-123.98792, 40.77331], [-123.98804, 40.777], [-123.99277, 40.777], [-123.99283, 40.78058], [-124.00117, 40.78074], [-124.00195, 40.78074], [-124.00191, 40.78596], [-124.00542, 40.78861], [-124.00615, 40.78861], [-124.00608, 40.79181], [-124.00847, 40.79184], [-124.01352, 40.79551], [-124.01594, 40.79552], [-124.01841, 40.79731], [-124.01843, 40.79731], [-124.01843, 40.79552], [-124.02091, 40.79553], [-124.02089, 40.79914], [-124.02336, 40.79915], [-124.02336, 40.80097], [-124.02575, 40.80099]]]]} | Open Access 1 | 47021 | Jacoby Creek Forest | 30669 | 1432 | Arcata, City of 587 | City 2 | City Agency 2 | http://www.cityofarcata.org/rec | City 2 | 1432 | Arcata, City of 577 | City 2 | City Agency 2 | Humboldt 45 | 1249.576 | Jacoby Creek Forest | 0 | Local Resource Management Area 83 | 3 | |
15729 | 15729 | 15728 | {"type": "MultiPolygon", "coordinates": [[[[-118.27411, 34.26728], [-118.26543, 34.26717], [-118.26542, 34.26731], [-118.26105, 34.26727], [-118.26104, 34.26578], [-118.26156, 34.26573], [-118.26177, 34.26567], [-118.26196, 34.26554], [-118.2622, 34.2653], [-118.26227, 34.26527], [-118.26261, 34.26521], [-118.26278, 34.26515], [-118.26387, 34.26451], [-118.26404, 34.26444], [-118.26423, 34.26439], [-118.2644, 34.26437], [-118.26471, 34.2644], [-118.26538, 34.2646], [-118.26538, 34.2647], [-118.26551, 34.26471], [-118.26566, 34.26467], [-118.26574, 34.26461], [-118.26586, 34.26443], [-118.26591, 34.26438], [-118.26596, 34.26436], [-118.26623, 34.26429], [-118.26631, 34.26426], [-118.26636, 34.2642], [-118.26638, 34.26412], [-118.26636, 34.26405], [-118.26629, 34.26399], [-118.26621, 34.26397], [-118.26614, 34.26397], [-118.26606, 34.264], [-118.26559, 34.26438], [-118.2655, 34.26439], [-118.26538, 34.26435], [-118.26538, 34.26446], [-118.26545, 34.26449], [-118.26558, 34.2645], [-118.26569, 34.26445], [-118.26564, 34.26453], [-118.26559, 34.26458], [-118.2655, 34.26461], [-118.26538, 34.26459], [-118.26537, 34.26449], [-118.26481, 34.26431], [-118.26462, 34.26427], [-118.26437, 34.26427], [-118.26407, 34.26431], [-118.26391, 34.26437], [-118.26378, 34.26443], [-118.26272, 34.26505], [-118.26254, 34.26511], [-118.26225, 34.26516], [-118.26214, 34.2652], [-118.26202, 34.26529], [-118.26191, 34.26544], [-118.26174, 34.26555], [-118.26154, 34.26562], [-118.26104, 34.26567], [-118.26102, 34.26357], [-118.26535, 34.26361], [-118.26536, 34.26349], [-118.26863, 34.26353], [-118.26871, 34.26544], [-118.26884, 34.26545], [-118.26974, 34.26546], [-118.26974, 34.2647], [-118.26968, 34.26353], [-118.26968, 34.25986], [-118.27407, 34.25988], [-118.27411, 34.26728]], [[-118.26537, 34.26484], [-118.26538, 34.26483], [-118.26538, 34.26473], [-118.2649, 34.26465], [-118.26474, 34.26465], [-118.26458, 34.26468], [-118.26432, 34.26478], [-118.26301, 34.26581], [-118.26292, 34.2659], [-118.26283, 34.26603], [-118.26272, 34.26632], [-118.26268, 34.26639], [-118.26245, 34.26664], [-118.26241, 34.2667], [-118.2624, 34.26678], [-118.26244, 34.26687], [-118.26252, 34.26694], [-118.2626, 34.26697], [-118.26263, 34.26687], [-118.26259, 34.26685], [-118.26255, 34.2668], [-118.26254, 34.26672], [-118.26278, 34.26647], [-118.26288, 34.26627], [-118.26295, 34.26608], [-118.26306, 34.26592], [-118.26435, 34.2649], [-118.26443, 34.26485], [-118.2646, 34.26479], [-118.26479, 34.26476], [-118.26496, 34.26476], [-118.26537, 34.26484]]], [[[-118.26624, 34.26416], [-118.26621, 34.26418], [-118.26594, 34.26425], [-118.26617, 34.26408], [-118.2662, 34.26408], [-118.26624, 34.2641], [-118.26624, 34.26416]]], [[[-118.2728, 34.25874], [-118.2726, 34.25889], [-118.2726, 34.25789], [-118.2728, 34.25775], [-118.2728, 34.25874]]]]} | Open Access 1 | 7119 | Angeles National Forest | 15492 | 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 | http://lacity.org/ | Los Angeles 6 | 155.09 | Angeles NF | 1908 | National Forest 11 | 3 |
16973 | 16973 | 16972 | {"type": "MultiPolygon", "coordinates": [[[[-116.40815, 33.67042], [-116.40786, 33.67036], [-116.40782, 33.67052], [-116.40799, 33.67062], [-116.39102, 33.67062], [-116.391, 33.66342], [-116.39893, 33.66343], [-116.39911, 33.66404], [-116.40094, 33.66486], [-116.40196, 33.66555], [-116.40233, 33.66566], [-116.40387, 33.6657], [-116.4042, 33.66582], [-116.40453, 33.66609], [-116.40497, 33.66685], [-116.4053, 33.66712], [-116.40552, 33.66717], [-116.40528, 33.66757], [-116.40635, 33.66818], [-116.40697, 33.6684], [-116.40765, 33.66936], [-116.40814, 33.66949], [-116.40815, 33.67042]]], [[[-116.40827, 33.72153], [-116.40815, 33.72862], [-116.40669, 33.72863], [-116.40669, 33.72848], [-116.40684, 33.7284], [-116.40655, 33.72811], [-116.40623, 33.7282], [-116.40596, 33.72815], [-116.40582, 33.72814], [-116.40548, 33.72787], [-116.40502, 33.72771], [-116.40502, 33.72751], [-116.40505, 33.72734], [-116.40537, 33.72647], [-116.40619, 33.72641], [-116.4064, 33.7255], [-116.40497, 33.72403], [-116.40463, 33.72346], [-116.40453, 33.72287], [-116.40411, 33.72255], [-116.40389, 33.72245], [-116.40392, 33.72232], [-116.40349, 33.72228], [-116.4033, 33.72239], [-116.40281, 33.72177], [-116.4027, 33.7215], [-116.4029, 33.7215], [-116.40291, 33.72149], [-116.40175, 33.7185], [-116.40156, 33.71853], [-116.40039, 33.71553], [-116.40161, 33.71553], [-116.402, 33.71581], [-116.40276, 33.71609], [-116.40281, 33.71616], [-116.40284, 33.71642], [-116.40297, 33.71668], [-116.40302, 33.71674], [-116.40306, 33.71693], [-116.40319, 33.71696], [-116.40319, 33.717], [-116.40326, 33.71705], [-116.40359, 33.7171], [-116.40379, 33.71717], [-116.4039, 33.71725], [-116.40409, 33.71744], [-116.4044, 33.71793], [-116.40416, 33.71802], [-116.40406, 33.71789], [-116.40398, 33.71792], [-116.40391, 33.71801], [-116.40387, 33.71809], [-116.40386, 33.71821], [-116.40388, 33.71829], [-116.40363, 33.71859], [-116.40435, 33.71968], [-116.40505, 33.72005], [-116.40443, 33.72029], [-116.40465, 33.72151], [-116.40827, 33.72153]]], [[[-116.42543, 33.68504], [-116.4238, 33.68504], [-116.42375, 33.68413], [-116.42366, 33.68321], [-116.42348, 33.68225], [-116.42102, 33.67791], [-116.42092, 33.67739], [-116.41891, 33.67625], [-116.41686, 33.6757], [-116.4163, 33.67524], [-116.41641, 33.67467], [-116.41631, 33.67457], [-116.41632, 33.67446], [-116.41628, 33.67436], [-116.41599, 33.67408], [-116.41578, 33.67406], [-116.41563, 33.67392], [-116.41474, 33.67379], [-116.41409, 33.67414], [-116.41322, 33.67388], [-116.41171, 33.67319], [-116.41164, 33.67302], [-116.41166, 33.6721], [-116.4118, 33.6721], [-116.4119, 33.67207], [-116.41196, 33.672], [-116.41201, 33.67187], [-116.412, 33.67179], [-116.41196, 33.67172], [-116.41186, 33.67163], [-116.41177, 33.67159], [-116.41442, 33.67067], [-116.41673, 33.67067], [-116.41674, 33.67069], [-116.4254, 33.67068], [-116.42543, 33.68504]], [[-116.41672, 33.67293], [-116.41648, 33.6729], [-116.41612, 33.67323], [-116.41612, 33.6734], [-116.41694, 33.67337], [-116.41696, 33.67309], [-116.41677, 33.67294], [-116.41672, 33.67293]]]]} | Open Access 1 | 5785 | Santa Rosa and San Jacinto Mountains National Monument | 8325 | 1240 | Palm Desert, City of 215 | City 2 | City Agency 2 | http://www.cityofpalmdesert.org/Index.aspx?page=174 | City 2 | 1240 | Palm Desert, City of 211 | City 2 | City Agency 2 | Riverside 10 | 562.433 | Santa Rosa and San Jacinto Mtns. NM | 2000 | National Monument or Landmark 80 | 3 | |
16984 | 16984 | 16983 | {"type": "MultiPolygon", "coordinates": [[[[-116.29417, 33.63475], [-116.28536, 33.6349], [-116.28539, 33.63048], [-116.28628, 33.63084], [-116.28641, 33.63086], [-116.28663, 33.63084], [-116.28664, 33.63125], [-116.287, 33.6318], [-116.28734, 33.63194], [-116.28757, 33.63265], [-116.28748, 33.63325], [-116.28763, 33.63324], [-116.28777, 33.63302], [-116.2879, 33.63307], [-116.28798, 33.63302], [-116.28825, 33.6329], [-116.28847, 33.63297], [-116.28858, 33.63282], [-116.28992, 33.63292], [-116.2908, 33.63331], [-116.29086, 33.63325], [-116.29062, 33.6329], [-116.2906, 33.6326], [-116.29091, 33.63264], [-116.29154, 33.63335], [-116.29173, 33.6334], [-116.29174, 33.63339], [-116.2917, 33.63327], [-116.29156, 33.6332], [-116.29145, 33.63265], [-116.29161, 33.63256], [-116.29177, 33.63273], [-116.29182, 33.63295], [-116.29198, 33.6328], [-116.29229, 33.63274], [-116.29303, 33.63303], [-116.29374, 33.63312], [-116.29414, 33.63314], [-116.29417, 33.63475]]], [[[-116.29398, 33.63067], [-116.29318, 33.62999], [-116.2932, 33.62982], [-116.29306, 33.62973], [-116.29256, 33.62926], [-116.29256, 33.62916], [-116.29315, 33.62898], [-116.29324, 33.6286], [-116.29375, 33.62868], [-116.29369, 33.62858], [-116.29344, 33.62838], [-116.29306, 33.62825], [-116.29306, 33.62806], [-116.29324, 33.62779], [-116.29385, 33.62784], [-116.29385, 33.62779], [-116.29358, 33.62755], [-116.29396, 33.62754], [-116.29398, 33.63067]]]]} | Open Access 1 | 5792 | Santa Rosa and San Jacinto Mountains National Monument | 25130 | 1161 | La Quinta, City of 612 | City 2 | City Agency 2 | http://www.la-quinta.org/your-government/community-services/city-parks | City 2 | 1161 | La Quinta, City of 601 | City 2 | City Agency 2 | Riverside 10 | 57.461 | Santa Rosa and San Jacinto Mtns. NM | 2000 | National Monument or Landmark 80 | 3 | |
16987 | 16987 | 16986 | {"type": "MultiPolygon", "coordinates": [[[[-116.45598, 33.64882], [-116.44832, 33.64885], [-116.44301, 33.64885], [-116.44283, 33.64527], [-116.44727, 33.64526], [-116.44728, 33.6416], [-116.45169, 33.6416], [-116.45169, 33.64524], [-116.45597, 33.64524], [-116.45598, 33.64882]]], [[[-116.58839, 33.78979], [-116.58817, 33.7898], [-116.58804, 33.78983], [-116.58789, 33.7899], [-116.58779, 33.79002], [-116.58763, 33.79028], [-116.58752, 33.79034], [-116.58742, 33.7903], [-116.58707, 33.78996], [-116.58697, 33.78967], [-116.58692, 33.78958], [-116.58674, 33.78955], [-116.58663, 33.7896], [-116.58654, 33.78969], [-116.58651, 33.78978], [-116.58644, 33.78988], [-116.58625, 33.78999], [-116.58619, 33.79], [-116.58573, 33.78994], [-116.58553, 33.78985], [-116.58535, 33.78981], [-116.5853, 33.78978], [-116.58524, 33.78972], [-116.58516, 33.78956], [-116.58501, 33.78941], [-116.58483, 33.78928], [-116.58457, 33.78907], [-116.5845, 33.78884], [-116.58445, 33.78879], [-116.58416, 33.7887], [-116.58414, 33.78669], [-116.58837, 33.78667], [-116.58839, 33.78979]]], [[[-116.59685, 33.79389], [-116.59266, 33.79392], [-116.59262, 33.79028], [-116.59684, 33.79025], [-116.59685, 33.79389]]], [[[-116.56323, 33.80153], [-116.55962, 33.80147], [-116.55074, 33.80137], [-116.55057, 33.80085], [-116.55113, 33.80049], [-116.55137, 33.80031], [-116.55159, 33.79937], [-116.55164, 33.79875], [-116.55161, 33.79843], [-116.55161, 33.79837], [-116.55155, 33.79832], [-116.55155, 33.79819], [-116.5516, 33.79775], [-116.55157, 33.79771], [-116.55148, 33.79765], [-116.55125, 33.79764], [-116.55184, 33.79764], [-116.55198, 33.79718], [-116.55157, 33.79687], [-116.55132, 33.79629], [-116.55046, 33.79594], [-116.55005, 33.79555], [-116.54939, 33.79511], [-116.54909, 33.79478], [-116.55181, 33.79478], [-116.55184, 33.79264], [-116.54945, 33.79262], [-116.54897, 33.79248], [-116.5486, 33.79157], [-116.5486, 33.79105], [-116.54789, 33.79103], [-116.54778, 33.79158], [-116.54768, 33.79158], [-116.54769, 33.79061], [-116.54751, 33.7906], [-116.5475, 33.78922], [-116.54744, 33.78921], [-116.54775, 33.78855], [-116.54807, 33.78802], [-116.54815, 33.78745], [-116.54809, 33.78704], [-116.54819, 33.78685], [-116.56316, 33.78691], [-116.56323, 33.80153]]], [[[-116.5631, 33.81604], [-116.56304, 33.82941], [-116.56085, 33.83032], [-116.55565, 33.83032], [-116.55429, 33.83027], [-116.55428, 33.8304], [-116.55352, 33.8304], [-116.55373, 33.83006], [-116.55404, 33.82972], [-116.55405, 33.82962], [-116.55405, 33.82957], [-116.554, 33.8295], [-116.55367, 33.82924], [-116.55362, 33.82908], [-116.5536, 33.82891], [-116.55357, 33.82887], [-116.55353, 33.82882], [-116.55321, 33.82864], [-116.55298, 33.82848], [-116.55284, 33.82824], [-116.55275, 33.82802], [-116.55268, 33.82795], [-116.55261, 33.82792], [-116.55248, 33.82789], [-116.55167, 33.8279], [-116.55101, 33.82809], [-116.5506, 33.82814], [-116.55042, 33.82822], [-116.55079, 33.82852], [-116.55129, 33.82881], [-116.55146, 33.82935], [-116.55175, 33.82934], [-116.55216, 33.82942], [-116.55266, 33.82935], [-116.55285, 33.82943], [-116.55302, 33.8296], [-116.55363, 33.82957], [-116.55366, 33.82993], [-116.55346, 33.8304], [-116.5481, 33.83015], [-116.54807, 33.82561], [-116.54829, 33.82541], [-116.55427, 33.82541], [-116.55424, 33.81778], [-116.55466, 33.81777], [-116.55465, 33.81673], [-116.55501, 33.81672], [-116.55501, 33.81627], [-116.55491, 33.81626], [-116.55491, 33.81593], [-116.5631, 33.81604]]], [[[-116.5806, 33.84508], [-116.56296, 33.84488], [-116.56305, 33.84079], [-116.56314, 33.84063], [-116.56318, 33.84051], [-116.56327, 33.84038], [-116.56332, 33.84017], [-116.56342, 33.83998], [-116.56347, 33.8399], [-116.56353, 33.83987], [-116.56355, 33.83979], [-116.56353, 33.83969], [-116.56354, 33.83957], [-116.56361, 33.83945], [-116.56354, 33.83933], [-116.56351, 33.83923], [-116.56349, 33.83906], [-116.56355, 33.83881], [-116.56362, 33.83863], [-116.56357, 33.83849], [-116.56349, 33.83818], [-116.56351, 33.83804], [-116.56335, 33.83774], [-116.56331, 33.83758], [-116.5633, 33.83714], [-116.56335, 33.83681], [-116.56325, 33.83669], [-116.56461, 33.83668], [-116.56462, 33.83609], [-116.56444, 33.83583], [-116.56442, 33.83572], [-116.56451, 33.83549], [-116.56461, 33.8354], [-116.56478, 33.83534], [-116.56524, 33.8351], [-116.56549, 33.83501], [-116.56584, 33.83492], [-116.56626, 33.83484], [-116.56641, 33.83478], [-116.56658, 33.83466], [-116.56671, 33.83453], [-116.56696, 33.83461], [-116.56705, 33.8346], [-116.56708, 33.83455], [-116.5671, 33.83444], [-116.56715, 33.83437], [-116.56726, 33.83434], [-116.56729, 33.83428], [-116.56731, 33.83419], [-116.56735, 33.83417], [-116.56741, 33.83408], [-116.56738, 33.83393], [-116.56738, 33.83374], [-116.56732, 33.83366], [-116.56661, 33.83309], [-116.56634, 33.83294], [-116.56619, 33.83279], [-116.56616, 33.83268], [-116.56626, 33.83246], [-116.5663, 33.83208], [-116.56648, 33.83162], [-116.56666, 33.83103], [-116.5668, 33.83076], [-116.56675, 33.83045], [-116.57471, 33.83041], [-116.58024, 33.83042], [-116.58025, 33.83067], [-116.58059, 33.83067], [-116.5806, 33.84508]]], [[[-116.59707, 33.85934], [-116.58047, 33.85949], [-116.58043, 33.85485], [-116.58245, 33.85483], [-116.5868, 33.85048], [-116.58694, 33.85047], [-116.58874, 33.85195], [-116.59006, 33.85195], [-116.59174, 33.85027], [-116.59259, 33.84761], [-116.59258, 33.84609], [-116.59307, 33.8461], [-116.59621, 33.84759], [-116.59703, 33.84877], [-116.59707, 33.85934]]], [[[-116.60571, 33.87064], [-116.60136, 33.87069], [-116.60135, 33.86804], [-116.6019, 33.86804], [-116.6019, 33.86712], [-116.60569, 33.86709], [-116.60571, 33.87064]]]]} | Open Access 1 | 5788 | Santa Rosa and San Jacinto Mountains National Monument | 8337 | 1241 | Palm Springs, City of 553 | City 2 | City Agency 2 | http://www.ci.palm-springs.ca.us/index.aspx?page=80 | City 2 | 1241 | Palm Springs, City of 546 | City 2 | City Agency 2 | Riverside 10 | 2097.744 | Santa Rosa and San Jacinto Mtns. NM | 2000 | National Monument or Landmark 80 | 3 | |
16988 | 16988 | 16987 | {"type": "MultiPolygon", "coordinates": [[[[-118.60622, 34.13649], [-118.6062, 34.14086], [-118.60603, 34.14081], [-118.60602, 34.14045], [-118.60406, 34.14047], [-118.60406, 34.13931], [-118.60508, 34.1393], [-118.60509, 34.13835], [-118.60406, 34.13835], [-118.60407, 34.13649], [-118.60622, 34.13649]]], [[[-118.60615, 34.14108], [-118.60605, 34.14107], [-118.60596, 34.14103], [-118.60596, 34.14103], [-118.60615, 34.14108]]], [[[-118.71152, 34.10937], [-118.70916, 34.10902], [-118.7077, 34.11069], [-118.70769, 34.11083], [-118.70668, 34.11082], [-118.70667, 34.10715], [-118.71106, 34.10717], [-118.71101, 34.10405], [-118.7114, 34.10383], [-118.71148, 34.10394], [-118.71167, 34.10448], [-118.71179, 34.10496], [-118.71183, 34.10529], [-118.7118, 34.10569], [-118.71168, 34.10609], [-118.71152, 34.10646], [-118.71139, 34.10693], [-118.71135, 34.10727], [-118.7114, 34.10757], [-118.71151, 34.10801], [-118.71163, 34.10829], [-118.71169, 34.10888], [-118.71152, 34.10937]]]]} | Open Access 1 | 3237 | Santa Monica Mountains National Recreation Area | 25122 | 1040 | Calabasas, City of 313 | City 2 | City Agency 2 | http://www.cityofcalabasas.com/recreation.html | City 2 | 1040 | Calabasas, City of 310 | City 2 | City Agency 2 | http://www.nps.gov/samo/index.htm | Los Angeles 6 | 56.022 | Santa Monica Mtns. NRA | 0 | National Recreation Area 54 | 3 |
16991 | 16991 | 16990 | {"type": "MultiPolygon", "coordinates": [[[[-116.47773, 33.74318], [-116.47769, 33.75611], [-116.47746, 33.75617], [-116.47731, 33.75678], [-116.47668, 33.75743], [-116.47654, 33.75765], [-116.47769, 33.75766], [-116.47768, 33.75939], [-116.47499, 33.76165], [-116.47293, 33.76164], [-116.47262, 33.76235], [-116.47263, 33.76253], [-116.47266, 33.76263], [-116.47272, 33.76274], [-116.47272, 33.76285], [-116.47266, 33.76298], [-116.47254, 33.76307], [-116.47245, 33.7631], [-116.47232, 33.7631], [-116.47218, 33.76307], [-116.47209, 33.763], [-116.472, 33.76286], [-116.47192, 33.76235], [-116.47188, 33.76229], [-116.4718, 33.76222], [-116.47171, 33.76219], [-116.47163, 33.76219], [-116.47152, 33.76223], [-116.47143, 33.76232], [-116.47142, 33.76245], [-116.47148, 33.76254], [-116.47173, 33.76276], [-116.47175, 33.76281], [-116.47175, 33.7629], [-116.47172, 33.76297], [-116.47137, 33.76323], [-116.47064, 33.76344], [-116.47038, 33.76402], [-116.47033, 33.76408], [-116.47025, 33.7641], [-116.47016, 33.76405], [-116.47005, 33.76374], [-116.47, 33.7637], [-116.46995, 33.76369], [-116.46987, 33.76372], [-116.46932, 33.7644], [-116.46774, 33.76437], [-116.46748, 33.76383], [-116.46741, 33.76379], [-116.46732, 33.76376], [-116.46718, 33.76377], [-116.46707, 33.76382], [-116.46703, 33.76388], [-116.46677, 33.76472], [-116.46677, 33.76481], [-116.46682, 33.7649], [-116.46692, 33.76498], [-116.46701, 33.76501], [-116.46797, 33.76511], [-116.46806, 33.76509], [-116.4682, 33.76502], [-116.46837, 33.76486], [-116.46847, 33.76481], [-116.46853, 33.76479], [-116.46869, 33.76479], [-116.46883, 33.76485], [-116.46888, 33.76488], [-116.46895, 33.76498], [-116.46893, 33.76543], [-116.46872, 33.76557], [-116.46837, 33.76548], [-116.46823, 33.76548], [-116.4681, 33.76555], [-116.46804, 33.76564], [-116.46804, 33.76572], [-116.46806, 33.76577], [-116.46815, 33.76585], [-116.46823, 33.76588], [-116.46858, 33.76587], [-116.46868, 33.76588], [-116.46877, 33.76595], [-116.46879, 33.76606], [-116.46873, 33.76615], [-116.46864, 33.76619], [-116.46818, 33.76616], [-116.4679, 33.76644], [-116.46781, 33.76647], [-116.46771, 33.76647], [-116.46758, 33.76642], [-116.46751, 33.76633], [-116.4675, 33.76604], [-116.46748, 33.766], [-116.46743, 33.76594], [-116.46733, 33.7659], [-116.46722, 33.7659], [-116.46714, 33.76592], [-116.46707, 33.76598], [-116.46705, 33.76602], [-116.46692, 33.76643], [-116.46745, 33.7669], [-116.46725, 33.76737], [-116.46729, 33.7679], [-116.46688, 33.76798], [-116.46673, 33.76805], [-116.46668, 33.76811], [-116.46663, 33.7682], [-116.46663, 33.76833], [-116.46668, 33.76842], [-116.46678, 33.76852], [-116.46585, 33.7691], [-116.46571, 33.76915], [-116.46562, 33.76915], [-116.46546, 33.76909], [-116.46538, 33.76901], [-116.46512, 33.76855], [-116.46482, 33.76838], [-116.46406, 33.76692], [-116.46401, 33.76687], [-116.46389, 33.76682], [-116.46381, 33.76682], [-116.46372, 33.76685], [-116.46365, 33.7669], [-116.46361, 33.76696], [-116.46324, 33.76793], [-116.46324, 33.76811], [-116.46333, 33.76831], [-116.4634, 33.76838], [-116.46349, 33.76846], [-116.4637, 33.76856], [-116.46028, 33.76854], [-116.46029, 33.76782], [-116.46185, 33.76782], [-116.46227, 33.76738], [-116.4624, 33.76697], [-116.46243, 33.76691], [-116.46253, 33.76683], [-116.46266, 33.76679], [-116.46337, 33.76674], [-116.46352, 33.76668], [-116.46365, 33.76659], [-116.4637, 33.76652], [-116.46375, 33.76642], [-116.46385, 33.76592], [-116.46426, 33.76558], [-116.46447, 33.76492], [-116.46455, 33.76473], [-116.46469, 33.76464], [-116.46482, 33.7645], [-116.46487, 33.76438], [-116.4649, 33.76428], [-116.46487, 33.76369], [-116.46455, 33.7631], [-116.46376, 33.76273], [-116.46365, 33.76266], [-116.46356, 33.76252], [-116.46354, 33.76246], [-116.46354, 33.7623], [-116.46359, 33.76218], [-116.4638, 33.76188], [-116.46381, 33.76175], [-116.46379, 33.76169], [-116.46373, 33.76162], [-116.46363, 33.76156], [-116.46337, 33.76151], [-116.46325, 33.76146], [-116.46319, 33.76141], [-116.4631, 33.76131], [-116.46305, 33.76118], [-116.46305, 33.76104], [-116.46332, 33.75978], [-116.46336, 33.75967], [-116.46343, 33.75956], [-116.46356, 33.75941], [-116.46407, 33.75905], [-116.46414, 33.75892], [-116.46414, 33.75883], [-116.4641, 33.75873], [-116.46371, 33.75833], [-116.46366, 33.75826], [-116.46361, 33.75811], [-116.46362, 33.75789], [-116.46338, 33.75766], [-116.46034, 33.75767], [-116.46032, 33.74316], [-116.46034, 33.74322], [-116.47772, 33.74322], [-116.47773, 33.74318]], [[-116.46548, 33.7667], [-116.46549, 33.76669], [-116.46545, 33.76493], [-116.46459, 33.76492], [-116.4646, 33.7667], [-116.46548, 33.7667]], [[-116.47653, 33.75767], [-116.47652, 33.75766], [-116.47486, 33.75766], [-116.47484, 33.7578], [-116.47532, 33.75803], [-116.47556, 33.75828], [-116.47556, 33.75855], [-116.47521, 33.75965], [-116.47555, 33.76053], [-116.47559, 33.76059], [-116.47565, 33.76062], [-116.47571, 33.76063], [-116.47578, 33.76061], [-116.47583, 33.76058], [-116.47586, 33.76053], [-116.47611, 33.75981], [-116.47607, 33.75932], [-116.4761, 33.75914], [-116.47618, 33.75897], [-116.47635, 33.75877], [-116.47638, 33.75864], [-116.47637, 33.75857], [-116.47634, 33.75851], [-116.47622, 33.75841], [-116.47609, 33.75837], [-116.47588, 33.75837], [-116.47576, 33.75831], [-116.4757, 33.75822], [-116.47571, 33.75813], [-116.47576, 33.75805], [-116.47587, 33.75799], [-116.47597, 33.75798], [-116.47615, 33.75802], [-116.47624, 33.75801], [-116.47631, 33.75799], [-116.4764, 33.75791], [-116.47653, 33.75767]]], [[[-116.46033, 33.75769], [-116.46031, 33.76137], [-116.45967, 33.76136], [-116.4594, 33.76151], [-116.45945, 33.76134], [-116.45948, 33.76129], [-116.45955, 33.76122], [-116.45982, 33.761], [-116.45986, 33.76095], [-116.45992, 33.76086], [-116.45993, 33.76074], [-116.45992, 33.76069], [-116.45979, 33.76047], [-116.45977, 33.76041], [-116.45978, 33.76023], [-116.45974, 33.76016], [-116.45972, 33.76014], [-116.45972, 33.75968], [-116.45907, 33.75968], [-116.45906, 33.7602], [-116.45964, 33.76022], [-116.45969, 33.76028], [-116.45969, 33.76042], [-116.45983, 33.76071], [-116.45983, 33.76084], [-116.45978, 33.76094], [-116.45973, 33.76099], [-116.45947, 33.76119], [-116.45941, 33.76126], [-116.45937, 33.76132], [-116.45929, 33.76157], [-116.45881, 33.76183], [-116.45805, 33.76228], [-116.45689, 33.76305], [-116.45646, 33.76411], [-116.45621, 33.76429], [-116.45592, 33.76487], [-116.45604, 33.76523], [-116.45589, 33.76574], [-116.45529, 33.76574], [-116.45361, 33.76668], [-116.45361, 33.76744], [-116.45385, 33.76757], [-116.45466, 33.7681], [-116.45591, 33.76952], [-116.45478, 33.7695], [-116.45458, 33.76948], [-116.4531, 33.76921], [-116.45292, 33.76921], [-116.45271, 33.76925], [-116.45157, 33.76905], [-116.45132, 33.76962], [-116.45093, 33.7698], [-116.4505, 33.77022], [-116.44985, 33.77058], [-116.44902, 33.77053], [-116.44885, 33.77129], [-116.44869, 33.77131], [-116.44856, 33.77134], [-116.44841, 33.7714], [-116.44826, 33.77149], [-116.44818, 33.77156], [-116.44807, 33.77168], [-116.44797, 33.77185], [-116.44787, 33.77198], [-116.44771, 33.77211], [-116.44777, 33.77202], [-116.4478, 33.77194], [-116.44781, 33.77158], [-116.44788, 33.77142], [-116.448, 33.77129], [-116.44804, 33.77126], [-116.4482, 33.77118], [-116.44832, 33.77115], [-116.44835, 33.77105], [-116.44692, 33.77066], [-116.44646, 33.76922], [-116.44629, 33.76878], [-116.44707, 33.76846], [-116.44718, 33.76852], [-116.44756, 33.76911], [-116.44915, 33.76842], [-116.44875, 33.76773], [-116.44911, 33.76757], [-116.45082, 33.76739], [-116.45078, 33.76707], [-116.45081, 33.76703], [-116.45074, 33.76686], [-116.45069, 33.76649], [-116.45022, 33.7662], [-116.4484, 33.76641], [-116.44751, 33.76619], [-116.44673, 33.76652], [-116.44637, 33.76594], [-116.44632, 33.76583], [-116.44628, 33.76568], [-116.44625, 33.76547], [-116.44625, 33.76525], [-116.44628, 33.76505], [-116.44624, 33.76501], [-116.44852, 33.76405], [-116.4499, 33.7623], [-116.44989, 33.76216], [-116.44977, 33.76144], [-116.44927, 33.76055], [-116.44859, 33.75994], [-116.44718, 33.76017], [-116.44713, 33.76006], [-116.44631, 33.7602], [-116.4458, 33.75985], [-116.44525, 33.75965], [-116.44501, 33.75957], [-116.44467, 33.75969], [-116.44419, 33.75944], [-116.44414, 33.7594], [-116.44404, 33.75928], [-116.44372, 33.75859], [-116.44293, 33.75858], [-116.44293, 33.75769], [-116.46033, 33.75769]], [[-116.45332, 33.769], [-116.4543, 33.76917], [-116.45443, 33.76864], [-116.4532, 33.76842], [-116.45332, 33.769]]], [[[-116.46027, 33.77149], [-116.46026, 33.77245], [-116.45811, 33.77254], [-116.4581, 33.77241], [-116.44763, 33.77245], [-116.44755, 33.77239], [-116.44757, 33.77232], [-116.44784, 33.77218], [-116.448, 33.77204], [-116.44806, 33.77198], [-116.44819, 33.77176], [-116.44835, 33.77159], [-116.44843, 33.77153], [-116.44861, 33.77145], [-116.44883, 33.77141], [-116.44913, 33.77143], [-116.44955, 33.77156], [-116.44975, 33.7716], [-116.44996, 33.77159], [-116.45011, 33.77157], [-116.45037, 33.77146], [-116.4505, 33.77137], [-116.45065, 33.77122], [-116.451, 33.77072], [-116.45114, 33.77055], [-116.45147, 33.77021], [-116.45172, 33.77], [-116.45261, 33.76941], [-116.45275, 33.76936], [-116.453, 33.76932], [-116.45318, 33.76934], [-116.45456, 33.76959], [-116.45485, 33.76962], [-116.45602, 33.76963], [-116.45635, 33.76959], [-116.45661, 33.7695], [-116.45698, 33.76978], [-116.45704, 33.77035], [-116.45764, 33.77136], [-116.45769, 33.7719], [-116.45777, 33.77201], [-116.45841, 33.77207], [-116.45873, 33.7718], [-116.4597, 33.77182], [-116.46027, 33.77149]]]]} | Open Access 1 | 11569 | Santa Rosa and San Jacinto Mountains National Monument | 8932 | 1264 | Rancho Mirage, City of 594 | City 2 | City Agency 2 | http://www.ranchomirageca.gov/residents/parks-trails/ | City 2 | 1264 | Rancho Mirage, City of 584 | City 2 | City Agency 2 | Riverside 10 | 1207.988 | Santa Rosa and San Jacinto Mtns. NM | 2000 | National Monument or Landmark 80 | 3 |
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]);