units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
80 rows where ACCESS_TYP = 1, AGNCY_TYP = 1 and MNG_AGENCY = 59 sorted by ACRES
This data as json, copyable, CSV (advanced)
DES_TP 7
MNG_AG_TYP 1
MNG_AGENCY 1
- United States National Park Service · 80 ✖
ACCESS_TYP 1
- Open Access · 80 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
537 | 537 | 536 | {"type": "Polygon", "coordinates": [[[-118.93025, 34.14501], [-118.92997, 34.14499], [-118.92993, 34.14464], [-118.92975, 34.14379], [-118.92957, 34.14348], [-118.92948, 34.14328], [-118.92886, 34.14266], [-118.92864, 34.14235], [-118.92848, 34.14201], [-118.9283, 34.14173], [-118.92811, 34.14159], [-118.92784, 34.14148], [-118.9272, 34.14139], [-118.92693, 34.14128], [-118.92682, 34.1412], [-118.92674, 34.14104], [-118.9261, 34.14091], [-118.92611, 34.14077], [-118.92675, 34.14087], [-118.92687, 34.14075], [-118.92704, 34.14075], [-118.92725, 34.14084], [-118.92746, 34.14096], [-118.92768, 34.14103], [-118.92786, 34.14092], [-118.92801, 34.14071], [-118.92812, 34.14063], [-118.92829, 34.14063], [-118.92846, 34.14068], [-118.92868, 34.14092], [-118.92874, 34.14116], [-118.92841, 34.14085], [-118.92825, 34.14077], [-118.92811, 34.1408], [-118.92804, 34.14095], [-118.92794, 34.14107], [-118.92778, 34.14115], [-118.92765, 34.14115], [-118.92743, 34.14108], [-118.92726, 34.141], [-118.92709, 34.1409], [-118.92693, 34.14089], [-118.92688, 34.14102], [-118.92701, 34.14117], [-118.92717, 34.14123], [-118.92802, 34.14142], [-118.92829, 34.14151], [-118.92846, 34.14169], [-118.92862, 34.14194], [-118.92882, 34.14232], [-118.92903, 34.14264], [-118.92965, 34.14322], [-118.92974, 34.14342], [-118.92986, 34.14361], [-118.9301, 34.14436], [-118.93025, 34.14501]]]} | Open Access 1 | 2651 | Canilla Corp. | 14196 | 108 | United States National Park Service 102 | Federal 1 | Federal Agency 1 | http://www.nps.gov/ | National Park Service 12 | 108 | United States National Park Service 59 | Federal 1 | Federal Agency 1 | Ventura 8 | 3.474 | Canilla Corp. | 0 | National Recreation Area 54 | 3 | |
13143 | 13143 | 13142 | {"type": "Polygon", "coordinates": [[[-122.4927, 37.78799], [-122.49205, 37.78796], [-122.49139, 37.78826], [-122.49086, 37.78861], [-122.48984, 37.78946], [-122.48986, 37.78902], [-122.48996, 37.7886], [-122.49008, 37.78858], [-122.49004, 37.78851], [-122.49001, 37.78837], [-122.49005, 37.78836], [-122.49001, 37.78804], [-122.48986, 37.78796], [-122.49, 37.78777], [-122.49017, 37.78759], [-122.49038, 37.78742], [-122.49062, 37.78728], [-122.49091, 37.78716], [-122.49101, 37.78714], [-122.49113, 37.78714], [-122.4912, 37.78709], [-122.49154, 37.78723], [-122.49157, 37.78742], [-122.49166, 37.78741], [-122.49165, 37.78728], [-122.49175, 37.78732], [-122.49177, 37.7878], [-122.49222, 37.78752], [-122.49224, 37.78776], [-122.4927, 37.78799]]]} | Open Access 1 | 35094 | China Beach | 14203 | 108 | United States National Park Service 102 | Federal 1 | Federal Agency 1 | http://www.nps.gov/ | National Park Service 12 | 108 | United States National Park Service 59 | Federal 1 | Federal Agency 1 | http://www.nps.gov/goga/planyourvisit/chinabeach.htm | San Francisco 13 | 6.413 | China Beach | 1972 | National Recreation Area 54 | 3 |
5878 | 5878 | 5877 | {"type": "Polygon", "coordinates": [[[-115.26828, 34.00081], [-115.26823, 34.00115], [-115.26744, 34.00679], [-115.26737, 34.00001], [-115.26828, 34.00081]]]} | Open Access 1 | 4838 | Joshua Tree National Park | 14236 | 108 | United States National Park Service 102 | Federal 1 | Federal Agency 1 | http://www.nps.gov/ | National Park Service 12 | 108 | United States National Park Service 59 | Federal 1 | Federal Agency 1 | http://www.nps.gov/jotr/index.htm | Riverside 10 | 7.775 | Joshua Tree NP | 1994 | National Park 18 | 2 |
15757 | 15757 | 15756 | {"type": "Polygon", "coordinates": [[[-122.13367, 37.99088], [-122.13367, 37.99134], [-122.13229, 37.99153], [-122.13229, 37.99169], [-122.13226, 37.99211], [-122.13226, 37.99236], [-122.13202, 37.9928], [-122.13178, 37.99307], [-122.13112, 37.99314], [-122.13038, 37.99142], [-122.1326, 37.99068], [-122.13367, 37.99088]]]} | Open Access 1 | 17094 | John Muir National Historic Site | 14229 | 108 | United States National Park Service 102 | Federal 1 | Federal Agency 1 | http://www.nps.gov/ | National Park Service 12 | 108 | United States National Park Service 59 | Federal 1 | Federal Agency 1 | http://www.nps.gov/jomu/index.htm | Contra Costa 12 | 9.498 | John Muir NHS | 1993 | Historic or Cultural Area 350 | 4 |
14323 | 14323 | 14322 | {"type": "Polygon", "coordinates": [[[-122.02864, 37.82513], [-122.02856, 37.8276], [-122.02498, 37.82568], [-122.02473, 37.82523], [-122.02864, 37.82513]]]} | Open Access 1 | 44305 | Eugene O'Neill Historic Site | 14214 | 108 | United States National Park Service 102 | Federal 1 | Federal Agency 1 | http://www.nps.gov/ | National Park Service 12 | 108 | United States National Park Service 59 | Federal 1 | Federal Agency 1 | http://www.nps.gov/euon/index.htm | Contra Costa 12 | 12.994 | Eugene O'Neill Historic Site | 0 | Historic or Cultural Area 350 | 4 |
8231 | 8231 | 8230 | {"type": "Polygon", "coordinates": [[[-118.77876, 34.11244], [-118.77774, 34.11333], [-118.77749, 34.11315], [-118.77722, 34.11301], [-118.77658, 34.11278], [-118.77649, 34.11274], [-118.77632, 34.1126], [-118.77602, 34.11226], [-118.77585, 34.11215], [-118.77572, 34.11211], [-118.7755, 34.1121], [-118.77301, 34.1124], [-118.7749, 34.11069], [-118.77876, 34.11244]]]} | Open Access 1 | 12558 | Peter Strauss Ranch | 14262 | 108 | United States National Park Service 102 | Federal 1 | Federal Agency 1 | http://www.nps.gov/ | National Park Service 12 | 108 | United States National Park Service 59 | Federal 1 | Federal Agency 1 | http://www.nps.gov/samo/planyourvisit/straussranch.htm | Los Angeles 6 | 14.272 | Peter Strauss Ranch | 0 | Recreation Management Area 49 | 4 |
14320 | 14320 | 14319 | {"type": "Polygon", "coordinates": [[[-118.71107, 34.10391], [-118.71093, 34.10397], [-118.71061, 34.10414], [-118.71032, 34.10426], [-118.70981, 34.10444], [-118.70927, 34.1046], [-118.70646, 34.10285], [-118.707, 34.10227], [-118.70735, 34.10227], [-118.70735, 34.10256], [-118.70733, 34.10264], [-118.7075, 34.10269], [-118.70754, 34.10261], [-118.70867, 34.10291], [-118.71101, 34.10229], [-118.71099, 34.10357], [-118.71107, 34.10363], [-118.71107, 34.10391]]]} | Open Access 1 | 44376 | King Gillette Ranch | 14239 | 108 | United States National Park Service 102 | Federal 1 | Federal Agency 1 | http://www.nps.gov/ | National Park Service 12 | 108 | United States National Park Service 59 | Federal 1 | Federal Agency 1 | http://www.nps.gov/samo/planyourvisit/kinggilletteranch.htm | Los Angeles 6 | 15.376 | King Gillette Ranch | 0 | Recreation Management Area 49 | 4 |
2009 | 2009 | 2008 | {"type": "Polygon", "coordinates": [[[-122.47305, 37.64408], [-122.47256, 37.64407], [-122.47178, 37.64379], [-122.47151, 37.64332], [-122.47133, 37.64306], [-122.47056, 37.64305], [-122.46994, 37.64271], [-122.46923, 37.64265], [-122.46911, 37.6426], [-122.46794, 37.64159], [-122.47021, 37.64033], [-122.47305, 37.64408]]]} | Open Access 1 | 15356 | Sky Ridge | 14293 | 108 | United States National Park Service 102 | Federal 1 | Federal Agency 1 | http://www.nps.gov/ | National Park Service 12 | 108 | United States National Park Service 59 | Federal 1 | Federal Agency 1 | San Mateo 15 | 16.859 | Sky Ridge | 0 | National Recreation Area 54 | 3 | |
8305 | 8305 | 8304 | {"type": "Polygon", "coordinates": [[[-118.77471, 34.06273], [-118.7747, 34.06488], [-118.77445, 34.06486], [-118.77447, 34.06468], [-118.77443, 34.0646], [-118.77436, 34.06455], [-118.77319, 34.06472], [-118.77312, 34.06476], [-118.77306, 34.06483], [-118.77302, 34.0649], [-118.77301, 34.06505], [-118.77293, 34.06506], [-118.77242, 34.06439], [-118.77233, 34.06435], [-118.77224, 34.06435], [-118.77199, 34.06442], [-118.77192, 34.06441], [-118.77186, 34.06437], [-118.77183, 34.06424], [-118.77177, 34.06418], [-118.77149, 34.06407], [-118.77142, 34.06401], [-118.77141, 34.06391], [-118.77168, 34.06353], [-118.7717, 34.06346], [-118.77171, 34.06334], [-118.77166, 34.0632], [-118.77133, 34.0626], [-118.77132, 34.06224], [-118.7713, 34.06224], [-118.7712, 34.06249], [-118.77144, 34.06331], [-118.77142, 34.06333], [-118.77135, 34.06332], [-118.77109, 34.06287], [-118.77101, 34.06282], [-118.77093, 34.06281], [-118.77087, 34.06283], [-118.77053, 34.06302], [-118.77043, 34.06312], [-118.77033, 34.06328], [-118.77027, 34.06335], [-118.77025, 34.06184], [-118.77242, 34.06182], [-118.77243, 34.06271], [-118.77471, 34.06273]]]} | Open Access 1 | 12728 | Upper Solstice Canyon | 14300 | 108 | United States National Park Service 102 | Federal 1 | Federal Agency 1 | http://www.nps.gov/ | National Park Service 12 | 108 | United States National Park Service 59 | Federal 1 | Federal Agency 1 | http://www.nps.gov/samo/planyourvisit/solsticecanyon.htm | Los Angeles 6 | 20.51 | Upper Solstice Canyon | 0 | National Recreation Area 54 | 3 |
12701 | 12701 | 12700 | {"type": "Polygon", "coordinates": [[[-122.42467, 37.82831], [-122.42422, 37.82828], [-122.42384, 37.82818], [-122.42355, 37.82805], [-122.42275, 37.82756], [-122.42256, 37.82751], [-122.42224, 37.82746], [-122.42212, 37.82741], [-122.42194, 37.82732], [-122.42183, 37.82729], [-122.42169, 37.82729], [-122.42156, 37.82731], [-122.42141, 37.82736], [-122.42135, 37.82737], [-122.42126, 37.82735], [-122.4212, 37.82732], [-122.42088, 37.82706], [-122.42084, 37.82701], [-122.42081, 37.82694], [-122.42086, 37.82678], [-122.42084, 37.82668], [-122.42075, 37.8266], [-122.42058, 37.82653], [-122.42045, 37.82642], [-122.42033, 37.82625], [-122.42029, 37.82608], [-122.42029, 37.82597], [-122.42033, 37.82583], [-122.42044, 37.82568], [-122.42073, 37.82512], [-122.42081, 37.82505], [-122.42094, 37.82498], [-122.42106, 37.82494], [-122.4212, 37.82492], [-122.42138, 37.82493], [-122.42155, 37.82498], [-122.42185, 37.82503], [-122.42215, 37.8251], [-122.42236, 37.82518], [-122.42262, 37.82531], [-122.42295, 37.82551], [-122.42315, 37.82559], [-122.42338, 37.82565], [-122.42351, 37.82566], [-122.42364, 37.82564], [-122.42381, 37.82566], [-122.42397, 37.82572], [-122.42409, 37.82579], [-122.42417, 37.82588], [-122.42425, 37.826], [-122.42427, 37.82611], [-122.42428, 37.82634], [-122.42432, 37.82645], [-122.42439, 37.82654], [-122.42446, 37.82661], [-122.42468, 37.82674], [-122.42496, 37.82702], [-122.42513, 37.82723], [-122.42525, 37.82734], [-122.42543, 37.82747], [-122.4257, 37.82763], [-122.42578, 37.82772], [-122.42582, 37.82782], [-122.42583, 37.82794], [-122.4258, 37.82802], [-122.42574, 37.82812], [-122.42565, 37.8282], [-122.42542, 37.82828], [-122.42517, 37.82832], [-122.42492, 37.82833], [-122.42467, 37.82831]]]} | Open Access 1 | 29702 | Alcatraz Island | 14190 | 108 | United States National Park Service 102 | Federal 1 | Federal Agency 1 | http://www.nps.gov/ | National Park Service 12 | 108 | United States National Park Service 59 | Federal 1 | Federal Agency 1 | http://www.nps.gov/alca/index.htm | San Francisco 13 | 24.914 | Alcatraz Island | 0 | National Recreation Area 54 | 3 |
15721 | 15721 | 15720 | {"type": "Polygon", "coordinates": [[[-122.47755, 37.81063], [-122.47751, 37.81069], [-122.47747, 37.81071], [-122.47736, 37.81067], [-122.47718, 37.81076], [-122.47728, 37.81089], [-122.47728, 37.81105], [-122.47708, 37.81103], [-122.47691, 37.811], [-122.47659, 37.81089], [-122.47656, 37.81089], [-122.47647, 37.81084], [-122.4764, 37.81076], [-122.47624, 37.81042], [-122.47619, 37.81024], [-122.47615, 37.80986], [-122.47605, 37.80964], [-122.47597, 37.80957], [-122.47579, 37.80949], [-122.47554, 37.80939], [-122.47495, 37.80926], [-122.4748, 37.80918], [-122.47406, 37.80911], [-122.47325, 37.8091], [-122.47225, 37.80897], [-122.47181, 37.80887], [-122.47158, 37.80886], [-122.47141, 37.80883], [-122.47154, 37.80864], [-122.47105, 37.80841], [-122.47118, 37.80827], [-122.47107, 37.80803], [-122.47099, 37.80764], [-122.47093, 37.80743], [-122.47086, 37.80724], [-122.47076, 37.80711], [-122.47056, 37.80692], [-122.47019, 37.80666], [-122.47004, 37.80651], [-122.46997, 37.80641], [-122.4699, 37.80627], [-122.46987, 37.80615], [-122.46986, 37.80603], [-122.46998, 37.80603], [-122.47122, 37.80644], [-122.47145, 37.80655], [-122.47201, 37.80689], [-122.47216, 37.80696], [-122.47239, 37.80701], [-122.47263, 37.80701], [-122.47264, 37.8071], [-122.47307, 37.80738], [-122.47343, 37.80768], [-122.47375, 37.80785], [-122.47476, 37.80817], [-122.47492, 37.80818], [-122.47509, 37.80815], [-122.47562, 37.80865], [-122.4763, 37.8082], [-122.47647, 37.80835], [-122.47665, 37.80856], [-122.47677, 37.80871], [-122.47691, 37.80894], [-122.47699, 37.8091], [-122.47704, 37.80951], [-122.47709, 37.80951], [-122.47717, 37.81021], [-122.47721, 37.81025], [-122.47734, 37.81018], [-122.4774, 37.8102], [-122.47743, 37.81055], [-122.47754, 37.81059], [-122.47755, 37.81063]]]} | Open Access 1 | 35093 | Fort Point National Historic Site | 14216 | 108 | United States National Park Service 102 | Federal 1 | Federal Agency 1 | http://www.nps.gov/ | National Park Service 12 | 108 | United States National Park Service 59 | Federal 1 | Federal Agency 1 | http://www.nps.gov/fopo/index.htm | San Francisco 13 | 25.881 | Fort Point NHS | 1910 | Historic or Cultural Area 350 | 4 |
1128 | 1128 | 1127 | {"type": "MultiPolygon", "coordinates": [[[[-118.65001, 34.07927], [-118.64902, 34.07928], [-118.6491, 34.07916], [-118.64914, 34.07903], [-118.64913, 34.07888], [-118.64909, 34.07874], [-118.64901, 34.07862], [-118.64888, 34.07851], [-118.64873, 34.07843], [-118.64854, 34.07839], [-118.64834, 34.07839], [-118.64815, 34.07844], [-118.64681, 34.07901], [-118.64666, 34.07901], [-118.64638, 34.07905], [-118.64564, 34.07927], [-118.64543, 34.07928], [-118.64496, 34.07925], [-118.64461, 34.07919], [-118.64334, 34.07882], [-118.64322, 34.07877], [-118.64307, 34.07863], [-118.64299, 34.07846], [-118.64299, 34.07832], [-118.64303, 34.0782], [-118.64313, 34.07807], [-118.64333, 34.0779], [-118.64352, 34.07783], [-118.64373, 34.07769], [-118.64454, 34.07796], [-118.6449, 34.0779], [-118.64493, 34.0781], [-118.6456, 34.07833], [-118.65, 34.07832], [-118.65001, 34.07927]]], [[[-118.64879, 34.07893], [-118.64876, 34.079], [-118.64867, 34.07908], [-118.64557, 34.08106], [-118.64541, 34.08113], [-118.64518, 34.08114], [-118.64488, 34.08105], [-118.64479, 34.08105], [-118.64464, 34.08108], [-118.64452, 34.08114], [-118.64397, 34.08117], [-118.64382, 34.08117], [-118.64366, 34.08083], [-118.64334, 34.08006], [-118.64335, 34.08001], [-118.64344, 34.08002], [-118.64352, 34.08], [-118.64361, 34.07994], [-118.64367, 34.07987], [-118.6438, 34.0792], [-118.64493, 34.07943], [-118.6452, 34.07946], [-118.64544, 34.07946], [-118.64594, 34.07942], [-118.64631, 34.07935], [-118.64668, 34.07924], [-118.64684, 34.07918], [-118.64743, 34.07918], [-118.64762, 34.07915], [-118.64778, 34.07909], [-118.64793, 34.07901], [-118.64809, 34.07888], [-118.64829, 34.07866], [-118.6484, 34.07862], [-118.64858, 34.07862], [-118.64871, 34.07869], [-118.64877, 34.07878], [-118.64879, 34.07893]]], [[[-118.64799, 34.07869], [-118.64782, 34.07887], [-118.64765, 34.07896], [-118.64747, 34.07901], [-118.64723, 34.07901], [-118.64799, 34.07869]]], [[[-118.64889, 34.07913], [-118.64884, 34.07921], [-118.64877, 34.07927], [-118.64851, 34.0794], [-118.64883, 34.0792], [-118.64889, 34.07913]]]]} | Open Access 1 | 7215 | Hepatic Gulch Open Space | 14226 | 108 | United States National Park Service 102 | Federal 1 | Federal Agency 1 | http://www.nps.gov/ | National Park Service 12 | 108 | United States National Park Service 59 | Federal 1 | Federal Agency 1 | Los Angeles 6 | 29.855 | Hepatic Gulch OS | 0 | Recreation Management Area 49 | 4 | |
1667 | 1667 | 1666 | {"type": "Polygon", "coordinates": [[[-118.80701, 34.07087], [-118.80686, 34.07462], [-118.80435, 34.07459], [-118.80451, 34.07274], [-118.8025, 34.07272], [-118.80266, 34.07087], [-118.80701, 34.07087]]]} | Open Access 1 | 12586 | SMMNRA - Backbone Trail | 14272 | 108 | United States National Park Service 102 | Federal 1 | Federal Agency 1 | http://www.nps.gov/ | National Park Service 12 | 108 | United States National Park Service 59 | Federal 1 | Federal Agency 1 | http://www.nps.gov/samo/planyourvisit/backbonetrail.htm | Los Angeles 6 | 32.43 | SMMNRA - Backbone Trail | 0 | Recreation Management Area 49 | 4 |
13149 | 13149 | 13148 | {"type": "Polygon", "coordinates": [[[-122.42687, 37.8088], [-122.42684, 37.80881], [-122.42683, 37.80906], [-122.4268, 37.8093], [-122.42674, 37.80949], [-122.42667, 37.80967], [-122.42657, 37.80986], [-122.42642, 37.81007], [-122.42629, 37.81021], [-122.42615, 37.81034], [-122.42596, 37.81048], [-122.42576, 37.81058], [-122.42552, 37.81068], [-122.42532, 37.81074], [-122.42511, 37.81078], [-122.4249, 37.8108], [-122.42466, 37.81079], [-122.42446, 37.81075], [-122.42432, 37.81066], [-122.42427, 37.81059], [-122.42427, 37.81054], [-122.4243, 37.81048], [-122.42439, 37.81041], [-122.42449, 37.8104], [-122.4246, 37.81043], [-122.42466, 37.81049], [-122.42469, 37.81059], [-122.42474, 37.81063], [-122.42506, 37.81062], [-122.42535, 37.81056], [-122.42559, 37.81047], [-122.42582, 37.81035], [-122.42604, 37.81019], [-122.4262, 37.81003], [-122.42631, 37.80989], [-122.42649, 37.80957], [-122.42657, 37.80936], [-122.42661, 37.80919], [-122.42663, 37.80901], [-122.42663, 37.80883], [-122.42445, 37.8091], [-122.42439, 37.80887], [-122.42208, 37.80883], [-122.42194, 37.80818], [-122.42192, 37.80817], [-122.42162, 37.80788], [-122.42154, 37.80749], [-122.42086, 37.80757], [-122.4207, 37.80673], [-122.42249, 37.8065], [-122.42259, 37.80647], [-122.42486, 37.80619], [-122.42485, 37.80609], [-122.4257, 37.80598], [-122.4267, 37.80795], [-122.42687, 37.8088]]]} | Open Access 1 | 35096 | Aquatic Park | 14191 | 108 | United States National Park Service 102 | Federal 1 | Federal Agency 1 | http://www.nps.gov/ | National Park Service 12 | 108 | United States National Park Service 59 | Federal 1 | Federal Agency 1 | http://www.nps.gov/safr/planyourvisit/aquaticparkcove.htm | San Francisco 13 | 33.068 | Aquatic Park | 1972 | Recreation Management Area 49 | 4 |
14176 | 14176 | 14175 | {"type": "Polygon", "coordinates": [[[-118.77607, 34.1074], [-118.77188, 34.10743], [-118.77186, 34.10401], [-118.77604, 34.10399], [-118.77607, 34.1074]]]} | Open Access 1 | 43097 | Malibu Creek Properties | 14251 | 108 | United States National Park Service 102 | Federal 1 | Federal Agency 1 | http://www.nps.gov/ | National Park Service 12 | 108 | United States National Park Service 59 | Federal 1 | Federal Agency 1 | Los Angeles 6 | 36.124 | Malibu Creek Properties | 0 | National Recreation Area 54 | 3 | |
6322 | 6322 | 6321 | {"type": "Polygon", "coordinates": [[[-119.0027, 34.08163], [-118.99835, 34.08165], [-118.99821, 34.07797], [-119.00256, 34.07796], [-119.0027, 34.08163]]]} | Open Access 1 | 1851 | Whelan | 14301 | 108 | United States National Park Service 102 | Federal 1 | Federal Agency 1 | http://www.nps.gov/ | National Park Service 12 | 108 | United States National Park Service 59 | Federal 1 | Federal Agency 1 | Ventura 8 | 40.428 | Whelan | 0 | National Recreation Area 54 | 3 | |
15787 | 15787 | 15786 | {"type": "Polygon", "coordinates": [[[-115.48007, 33.74786], [-115.48002, 33.75216], [-115.47996, 33.75675], [-115.47772, 33.7562], [-115.47607, 33.75577], [-115.48007, 33.74786]]]} | Open Access 1 | 4856 | Joshua Tree National Park | 14236 | 108 | United States National Park Service 102 | Federal 1 | Federal Agency 1 | http://www.nps.gov/ | National Park Service 12 | 108 | United States National Park Service 59 | Federal 1 | Federal Agency 1 | http://www.nps.gov/jotr/index.htm | Riverside 10 | 44.117 | Joshua Tree NP | 1994 | National Park 18 | 2 |
13148 | 13148 | 13147 | {"type": "Polygon", "coordinates": [[[-122.48598, 37.7908], [-122.48574, 37.79102], [-122.48541, 37.79147], [-122.48528, 37.79171], [-122.485, 37.79195], [-122.48475, 37.79221], [-122.48454, 37.79252], [-122.48436, 37.79274], [-122.48407, 37.7933], [-122.48386, 37.79365], [-122.48359, 37.79404], [-122.4833, 37.79466], [-122.48352, 37.79473], [-122.48309, 37.79561], [-122.483, 37.7959], [-122.48285, 37.79618], [-122.48267, 37.79681], [-122.48218, 37.79783], [-122.48217, 37.798], [-122.48214, 37.79813], [-122.48209, 37.79823], [-122.48213, 37.79833], [-122.48208, 37.79847], [-122.48204, 37.79851], [-122.48196, 37.79853], [-122.48187, 37.79854], [-122.48183, 37.79857], [-122.48193, 37.79877], [-122.4819, 37.79878], [-122.48179, 37.79869], [-122.48176, 37.79879], [-122.48174, 37.79881], [-122.48173, 37.79885], [-122.4817, 37.79886], [-122.48155, 37.79876], [-122.48155, 37.79879], [-122.48167, 37.79889], [-122.48168, 37.79893], [-122.48162, 37.79895], [-122.48156, 37.79903], [-122.48151, 37.79921], [-122.48138, 37.79937], [-122.48139, 37.79945], [-122.48131, 37.79952], [-122.4812, 37.79956], [-122.4811, 37.79962], [-122.48107, 37.7997], [-122.48106, 37.79982], [-122.48099, 37.79994], [-122.48097, 37.80033], [-122.48076, 37.80044], [-122.48065, 37.80065], [-122.48059, 37.80073], [-122.48038, 37.80109], [-122.4803, 37.80129], [-122.4802, 37.80142], [-122.48018, 37.80156], [-122.48007, 37.80184], [-122.48003, 37.80206], [-122.48004, 37.80223], [-122.4799, 37.8029], [-122.47961, 37.80343], [-122.4795, 37.80357], [-122.47936, 37.80386], [-122.47917, 37.80433], [-122.47915, 37.80448], [-122.47906, 37.80469], [-122.47895, 37.80488], [-122.47881, 37.80529], [-122.47873, 37.80549], [-122.47872, 37.80568], [-122.47869, 37.80596], [-122.47863, 37.80601], [-122.47822, 37.80549], [-122.47987, 37.80125], [-122.48076, 37.79958], [-122.48119, 37.79836], [-122.48155, 37.79679], [-122.48179, 37.79459], [-122.4822, 37.79248], [-122.48288, 37.79043], [-122.48382, 37.78928], [-122.48408, 37.7894], [-122.48426, 37.78941], [-122.48457, 37.78953], [-122.48472, 37.78956], [-122.48481, 37.78967], [-122.48486, 37.78979], [-122.48488, 37.78979], [-122.48489, 37.78973], [-122.485, 37.78985], [-122.48497, 37.78995], [-122.485, 37.79001], [-122.48496, 37.7901], [-122.48495, 37.7902], [-122.48505, 37.79037], [-122.4854, 37.79045], [-122.48598, 37.7908]]]} | Open Access 1 | 35095 | Baker Beach | 14193 | 108 | United States National Park Service 102 | Federal 1 | Federal Agency 1 | http://www.nps.gov/ | National Park Service 12 | 108 | United States National Park Service 59 | Federal 1 | Federal Agency 1 | http://www.nps.gov/prsf/planyourvisit/baker-beach.htm | San Francisco 13 | 48.266 | Baker Beach | 1910 | National Recreation Area 54 | 3 |
8883 | 8883 | 8882 | {"type": "Polygon", "coordinates": [[[-118.78111, 34.11396], [-118.78093, 34.11395], [-118.78079, 34.11396], [-118.77889, 34.11435], [-118.77869, 34.11434], [-118.7785, 34.11428], [-118.77842, 34.11422], [-118.77833, 34.11414], [-118.778, 34.11361], [-118.77788, 34.11347], [-118.77774, 34.11333], [-118.77875, 34.11245], [-118.77875, 34.11243], [-118.7761, 34.11124], [-118.77607, 34.1074], [-118.78036, 34.10736], [-118.78039, 34.11317], [-118.78104, 34.11347], [-118.78111, 34.11396]]]} | Open Access 1 | 14517 | Peter Strauss Ranch | 14262 | 108 | United States National Park Service 102 | Federal 1 | Federal Agency 1 | http://www.nps.gov/ | National Park Service 12 | 108 | United States National Park Service 59 | Federal 1 | Federal Agency 1 | http://www.nps.gov/samo/planyourvisit/straussranch.htm | Los Angeles 6 | 61.91 | Peter Strauss Ranch | 0 | Recreation Management Area 49 | 4 |
7422 | 7422 | 7421 | {"type": "Polygon", "coordinates": [[[-118.38785, 34.12636], [-118.38735, 34.12646], [-118.3872, 34.12645], [-118.38703, 34.12639], [-118.38696, 34.12634], [-118.38625, 34.12553], [-118.38623, 34.12548], [-118.38621, 34.12538], [-118.38608, 34.12528], [-118.38595, 34.12532], [-118.38595, 34.12535], [-118.38592, 34.1254], [-118.38578, 34.12542], [-118.38565, 34.12549], [-118.3851, 34.12621], [-118.38496, 34.12631], [-118.38478, 34.12638], [-118.38434, 34.12643], [-118.38426, 34.12643], [-118.38419, 34.12642], [-118.38413, 34.12638], [-118.38408, 34.12634], [-118.384, 34.12619], [-118.3839, 34.12609], [-118.38377, 34.12603], [-118.38359, 34.12603], [-118.38349, 34.12605], [-118.38337, 34.12613], [-118.38332, 34.12618], [-118.38308, 34.12651], [-118.38298, 34.12659], [-118.38285, 34.12665], [-118.38266, 34.12667], [-118.38149, 34.12656], [-118.38129, 34.12653], [-118.38131, 34.12649], [-118.38131, 34.12642], [-118.38128, 34.12634], [-118.3812, 34.12626], [-118.38096, 34.12612], [-118.38089, 34.12604], [-118.38087, 34.12598], [-118.38119, 34.12546], [-118.38102, 34.125], [-118.38138, 34.12466], [-118.38142, 34.12465], [-118.38142, 34.12462], [-118.38136, 34.12456], [-118.38126, 34.12452], [-118.38043, 34.1245], [-118.38034, 34.12447], [-118.37998, 34.12422], [-118.3798, 34.12415], [-118.37959, 34.12415], [-118.3794, 34.12424], [-118.37936, 34.12422], [-118.3792, 34.12375], [-118.37929, 34.12375], [-118.37942, 34.12372], [-118.37959, 34.12372], [-118.37969, 34.12367], [-118.37984, 34.12367], [-118.37997, 34.1237], [-118.38059, 34.1239], [-118.38067, 34.12389], [-118.38074, 34.12385], [-118.38075, 34.12382], [-118.38075, 34.12376], [-118.38069, 34.1237], [-118.38062, 34.12368], [-118.3805, 34.12373], [-118.3804, 34.12374], [-118.38016, 34.12366], [-118.38007, 34.1231], [-118.38026, 34.12322], [-118.38049, 34.12332], [-118.38071, 34.12335], [-118.38091, 34.12334], [-118.38106, 34.1233], [-118.38119, 34.12325], [-118.38139, 34.1231], [-118.3815, 34.12296], [-118.38154, 34.12286], [-118.38158, 34.1227], [-118.38165, 34.12265], [-118.38179, 34.12264], [-118.38202, 34.12279], [-118.38226, 34.12287], [-118.38248, 34.12289], [-118.38268, 34.12287], [-118.38287, 34.12281], [-118.38309, 34.12269], [-118.38322, 34.12258], [-118.38332, 34.12241], [-118.38339, 34.12238], [-118.38346, 34.12237], [-118.38472, 34.12246], [-118.38491, 34.12246], [-118.38504, 34.12244], [-118.38529, 34.12236], [-118.38552, 34.12221], [-118.38568, 34.12204], [-118.38574, 34.12192], [-118.38579, 34.12178], [-118.38586, 34.12172], [-118.38598, 34.12171], [-118.38629, 34.1218], [-118.38642, 34.12188], [-118.38646, 34.12195], [-118.38679, 34.12306], [-118.38691, 34.12326], [-118.38705, 34.1234], [-118.38729, 34.12354], [-118.38757, 34.12362], [-118.38784, 34.12363], [-118.38785, 34.12597], [-118.38775, 34.12605], [-118.38785, 34.12636]]]} | Open Access 1 | 6860 | Fryman Canyon Park | 14218 | 108 | United States National Park Service 102 | Federal 1 | Federal Agency 1 | http://www.nps.gov/ | National Park Service 12 | 108 | United States National Park Service 59 | Federal 1 | Federal Agency 1 | Los Angeles 6 | 64.912 | Fryman Canyon Park | 0 | Recreation Management Area 49 | 4 |
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]);