units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
89 rows where MNG_AGENCY = 59, MNG_AG_LEV = 1 and MNG_AG_TYP = 1 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_WEB, COUNTY, YR_EST, GAP_STS
DES_TP 8
ACCESS_TYP 3
MNG_AG_TYP 1
- Federal Agency · 89 ✖
MNG_AGENCY 1
- United States National Park Service · 89 ✖
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 | |
8555 | 8555 | 8554 | {"type": "Polygon", "coordinates": [[[-121.48002, 41.95003], [-121.47898, 41.95093], [-121.47693, 41.95089], [-121.47853, 41.9496], [-121.47944, 41.94972], [-121.48002, 41.95003]]]} | Restricted Access 2 | 48508 | Tule Lake National Monument | 33219 | 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 | Siskiyou 28 | 5.363 | Tule Lake NM | 1942 | National Monument or Landmark 80 | 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 |
4765 | 4765 | 4764 | {"type": "Polygon", "coordinates": [[[-118.64125, 34.08303], [-118.64124, 34.08543], [-118.6369, 34.08542], [-118.6382, 34.08423], [-118.63902, 34.08386], [-118.63915, 34.08375], [-118.6392, 34.08385], [-118.63947, 34.08386], [-118.63997, 34.08356], [-118.64125, 34.08303]]]} | Restricted Access 2 | 46840 | Unnamed site - National Park Service | 31224 | 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 | 15.693 | 0 | Federal Other or Unknown 87 | 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 | |
7269 | 7269 | 7268 | {"type": "Polygon", "coordinates": [[[-118.70012, 34.09988], [-118.69791, 34.09987], [-118.69791, 34.09626], [-118.69892, 34.09625], [-118.7001, 34.0973], [-118.70012, 34.09988]]]} | Restricted Access 2 | 6493 | Diamond X Ranch | 29655 | 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 | 18.578 | Diamond X Ranch | 0 | Recreation Management Area 49 | 4 | |
939 | 939 | 938 | {"type": "Polygon", "coordinates": [[[-118.69354, 34.09988], [-118.69132, 34.09987], [-118.6913, 34.09626], [-118.69353, 34.09626], [-118.69354, 34.09988]]]} | Unknown Access 4 | 6492 | Triffon Open Space | 29659 | 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 | 20.369 | Triffon OS | 0 | Recreation Management Area 49 | 4 | |
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 |
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]);