units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
61 rows where DES_TP = 49 and MNG_AG_LEV = 1 sorted by SUID_NMA
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
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 |
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 |
6482 | 6482 | 6481 | {"type": "Polygon", "coordinates": [[[-117.49208, 34.25165], [-117.49191, 34.25249], [-117.49152, 34.25285], [-117.49137, 34.25324], [-117.49132, 34.25361], [-117.49123, 34.25396], [-117.49105, 34.25424], [-117.49036, 34.25487], [-117.4893, 34.25482], [-117.48921, 34.25572], [-117.48903, 34.25595], [-117.48918, 34.25659], [-117.48857, 34.25675], [-117.48821, 34.25693], [-117.48831, 34.25044], [-117.48889, 34.25065], [-117.48902, 34.25061], [-117.48981, 34.25022], [-117.49014, 34.24998], [-117.49082, 34.249], [-117.49174, 34.24937], [-117.49085, 34.25064], [-117.49156, 34.25086], [-117.49165, 34.25102], [-117.49152, 34.25158], [-117.49208, 34.25165]], [[-117.49013, 34.25218], [-117.48925, 34.25195], [-117.48893, 34.25197], [-117.48878, 34.25203], [-117.48864, 34.25212], [-117.48854, 34.25234], [-117.4886, 34.25252], [-117.48868, 34.25264], [-117.48886, 34.25268], [-117.49103, 34.25281], [-117.49118, 34.2523], [-117.49087, 34.25222], [-117.49059, 34.25219], [-117.49013, 34.25218]], [[-117.49121, 34.25106], [-117.491, 34.25096], [-117.49079, 34.25096], [-117.49009, 34.25081], [-117.48986, 34.25081], [-117.48975, 34.25092], [-117.48964, 34.2511], [-117.48964, 34.25126], [-117.48972, 34.25137], [-117.48993, 34.25146], [-117.49091, 34.25163], [-117.49119, 34.25161], [-117.49123, 34.25158], [-117.49126, 34.25121], [-117.49121, 34.25106]]]} | Open Access 1 | 2304 | Applewhite Campground | 15543 | 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 | 36.645 | Applewhite Campground | 0 | Recreation Management Area 49 | 4 | |
14548 | 14548 | 14547 | {"type": "Polygon", "coordinates": [[[-121.02582, 38.9373], [-121.02254, 38.93856], [-121.02232, 38.93981], [-121.02046, 38.94222], [-121.01715, 38.94306], [-121.01682, 38.93948], [-121.01802, 38.9396], [-121.01942, 38.93915], [-121.02, 38.93743], [-121.02141, 38.93616], [-121.02233, 38.93553], [-121.02281, 38.93501], [-121.0258, 38.93502], [-121.02575, 38.93638], [-121.02582, 38.9373]]]} | Open Access 1 | 47511 | Auburn State Recreation Area | 15701 | 100 | United States Army Corps of Engineers 146 | Federal 1 | Federal Agency 1 | http://www.usace.army.mil/ | Other Federal 13 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | http://www.parks.ca.gov/?page_id=502 | Placer 35 | 76.191 | Auburn SRA | 1966 | Recreation Management Area 49 | 4 |
6010 | 6010 | 6009 | {"type": "Polygon", "coordinates": [[[-118.50547, 34.18013], [-118.50135, 34.18014], [-118.50135, 34.17454], [-118.5013, 34.17234], [-118.50547, 34.17239], [-118.50547, 34.18013]]]} | Open Access 1 | 665 | Balboa Sports Center | 15773 | 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 | 81.108 | Balboa Sports Ctr. | 0 | Recreation Management Area 49 | 4 | |
12084 | 12084 | 12083 | {"type": "Polygon", "coordinates": [[[-117.24699, 34.22787], [-117.24641, 34.2278], [-117.24625, 34.22776], [-117.24604, 34.22767], [-117.24588, 34.22753], [-117.24579, 34.22741], [-117.24574, 34.2273], [-117.24558, 34.22653], [-117.24552, 34.22637], [-117.24544, 34.22621], [-117.24695, 34.22622], [-117.24699, 34.22787]]]} | Open Access 1 | 24892 | Baylis Park Picnic Area | 15888 | 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 | 5.039 | Baylis Park Picnic Area | 0 | Recreation Management Area 49 | 4 | |
5852 | 5852 | 5851 | {"type": "Polygon", "coordinates": [[[-121.90637, 36.35669], [-121.90633, 36.35676], [-121.90633, 36.35686], [-121.90629, 36.35697], [-121.90629, 36.35703], [-121.90621, 36.35721], [-121.90613, 36.35728], [-121.90605, 36.35742], [-121.90597, 36.35746], [-121.90593, 36.35753], [-121.90584, 36.3576], [-121.9058, 36.35767], [-121.90564, 36.35774], [-121.90559, 36.35781], [-121.90551, 36.35785], [-121.90547, 36.35792], [-121.90535, 36.35803], [-121.90526, 36.35817], [-121.90518, 36.35824], [-121.90514, 36.35831], [-121.90498, 36.35845], [-121.90481, 36.35845], [-121.90468, 36.35849], [-121.9045, 36.3585], [-121.90434, 36.35864], [-121.9043, 36.35871], [-121.90422, 36.35875], [-121.90418, 36.35882], [-121.90409, 36.35885], [-121.90397, 36.35896], [-121.90389, 36.35907], [-121.90368, 36.35921], [-121.90351, 36.35935], [-121.90343, 36.35939], [-121.90339, 36.35946], [-121.90322, 36.3596], [-121.90318, 36.35967], [-121.9032, 36.36026], [-121.90325, 36.36033], [-121.90325, 36.3604], [-121.90339, 36.3606], [-121.90361, 36.36087], [-121.90361, 36.36094], [-121.9037, 36.36094], [-121.90409, 36.36107], [-121.90418, 36.36114], [-121.90444, 36.36127], [-121.9047, 36.36147], [-121.90475, 36.36157], [-121.90476, 36.36188], [-121.9046, 36.36202], [-121.90426, 36.36217], [-121.90405, 36.36218], [-121.90388, 36.36225], [-121.90379, 36.36225], [-121.90375, 36.36232], [-121.9035, 36.36247], [-121.90342, 36.36254], [-121.90333, 36.36258], [-121.90325, 36.36271], [-121.90317, 36.36279], [-121.90301, 36.363], [-121.90297, 36.3631], [-121.90284, 36.36324], [-121.90276, 36.36338], [-121.9026, 36.36356], [-121.90235, 36.36391], [-121.90223, 36.36412], [-121.9022, 36.36423], [-121.90221, 36.36478], [-121.90226, 36.36488], [-121.90227, 36.36502], [-121.90245, 36.36529], [-121.90258, 36.36546], [-121.90259, 36.36553], [-121.90268, 36.3657], [-121.9027, 36.36626], [-121.90266, 36.36633], [-121.90266, 36.3664], [-121.90258, 36.36657], [-121.90258, 36.36664], [-121.9025, 36.36678], [-121.90242, 36.36685], [-121.90234, 36.36699], [-121.90236, 36.36741], [-121.9024, 36.36748], [-121.9024, 36.36754], [-121.90245, 36.36761], [-121.90245, 36.36768], [-121.9025, 36.36775], [-121.9025, 36.36782], [-121.90255, 36.36789], [-121.90263, 36.36795], [-121.90272, 36.36809], [-121.90282, 36.36815], [-121.90284, 36.36822], [-121.9031, 36.36862], [-121.90316, 36.36876], [-121.90317, 36.36906], [-121.90316, 36.36923], [-121.9031, 36.36949], [-121.90306, 36.36957], [-121.90304, 36.36975], [-121.903, 36.36982], [-121.90298, 36.3701], [-121.90297, 36.37017], [-121.90299, 36.3704], [-121.90304, 36.37048], [-121.90307, 36.3706], [-121.8997, 36.37056], [-121.89579, 36.3698], [-121.89585, 36.36624], [-121.88699, 36.36665], [-121.88768, 36.35894], [-121.87939, 36.35881], [-121.87942, 36.35196], [-121.87442, 36.352], [-121.87452, 36.34856], [-121.87239, 36.34857], [-121.86962, 36.34855], [-121.86981, 36.34513], [-121.87945, 36.3451], [-121.89703, 36.34523], [-121.8972, 36.34544], [-121.89653, 36.35301], [-121.90369, 36.35314], [-121.90372, 36.35323], [-121.90364, 36.35334], [-121.90343, 36.35336], [-121.90334, 36.35342], [-121.90324, 36.35358], [-121.90323, 36.35373], [-121.90334, 36.35398], [-121.90343, 36.35415], [-121.90343, 36.35423], [-121.90358, 36.35463], [-121.90358, 36.35472], [-121.90371, 36.35495], [-121.90374, 36.35521], [-121.90383, 36.35537], [-121.90416, 36.35584], [-121.90419, 36.35592], [-121.9042, 36.35608], [-121.90424, 36.35616], [-121.9044, 36.35634], [-121.90462, 36.3565], [-121.90471, 36.35652], [-121.90505, 36.3565], [-121.90534, 36.35639], [-121.90546, 36.35637], [-121.90588, 36.3564], [-121.9061, 36.35646], [-121.90634, 36.35656], [-121.90637, 36.35669]]]} | Restricted Access 2 | 186 | Brazil Ranch | 16339 | 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 | Monterey 14 | 1184.534 | Brazil Ranch | 0 | Recreation Management Area 49 | 4 | |
7578 | 7578 | 7577 | {"type": "MultiPolygon", "coordinates": [[[[-118.59486, 34.52118], [-118.5948, 34.52122], [-118.59446, 34.52127], [-118.59421, 34.52144], [-118.59411, 34.52159], [-118.59372, 34.52189], [-118.59042, 34.5219], [-118.59036, 34.51825], [-118.59485, 34.51824], [-118.59486, 34.52118]]], [[[-118.60347, 34.53634], [-118.60339, 34.54007], [-118.59871, 34.54006], [-118.59885, 34.53638], [-118.60347, 34.53634]]]]} | Open Access 1 | 7268 | Castaic Lake State Recreation Area | 16945 | 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 | Los Angeles 6 | 83.172 | Castaic Lake SRA | 1965 | Recreation Management Area 49 | 4 | |
7592 | 7592 | 7591 | {"type": "Polygon", "coordinates": [[[-118.64305, 34.55924], [-118.6334, 34.55921], [-118.63325, 34.55904], [-118.63313, 34.55895], [-118.63308, 34.55888], [-118.63312, 34.55878], [-118.63332, 34.55862], [-118.63334, 34.55856], [-118.63328, 34.55848], [-118.63326, 34.55836], [-118.63331, 34.55816], [-118.63324, 34.55812], [-118.63319, 34.55806], [-118.63306, 34.55804], [-118.63288, 34.55811], [-118.63224, 34.55808], [-118.63175, 34.558], [-118.6316, 34.5579], [-118.63143, 34.5577], [-118.6314, 34.55755], [-118.63145, 34.55735], [-118.63154, 34.55717], [-118.63148, 34.55709], [-118.63126, 34.55701], [-118.63101, 34.55689], [-118.63087, 34.55674], [-118.63086, 34.55667], [-118.63091, 34.55658], [-118.63111, 34.55639], [-118.63166, 34.55604], [-118.63181, 34.55598], [-118.6319, 34.55591], [-118.63195, 34.55586], [-118.63196, 34.55582], [-118.63192, 34.55578], [-118.63184, 34.55575], [-118.63143, 34.5557], [-118.63118, 34.55562], [-118.63107, 34.55556], [-118.63094, 34.55543], [-118.63085, 34.55538], [-118.63068, 34.55546], [-118.63061, 34.55546], [-118.63055, 34.55543], [-118.63052, 34.55538], [-118.63052, 34.55517], [-118.63047, 34.55502], [-118.63047, 34.55488], [-118.63044, 34.5548], [-118.63038, 34.55472], [-118.63016, 34.55454], [-118.63014, 34.55452], [-118.63013, 34.55448], [-118.63015, 34.55445], [-118.63026, 34.55439], [-118.63031, 34.55427], [-118.63031, 34.554], [-118.63035, 34.5539], [-118.63085, 34.55351], [-118.63089, 34.55344], [-118.63088, 34.55341], [-118.63085, 34.55339], [-118.63063, 34.55335], [-118.63048, 34.5533], [-118.63025, 34.55342], [-118.62999, 34.55347], [-118.62998, 34.54746], [-118.63434, 34.54747], [-118.6345, 34.55842], [-118.64304, 34.55841], [-118.64305, 34.55924]]]} | Open Access 1 | 7301 | Castaic Lake State Recreation Area | 16945 | 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 | Los Angeles 6 | 127.866 | Castaic Lake SRA | 1965 | Recreation Management Area 49 | 4 | |
5413 | 5413 | 5412 | {"type": "MultiPolygon", "coordinates": [[[[-118.22858, 33.88759], [-118.22857, 33.88759], [-118.22835, 33.88727], [-118.22846, 33.88739], [-118.22858, 33.88759]]], [[[-118.24226, 33.90419], [-118.24209, 33.90423], [-118.24193, 33.90397], [-118.24191, 33.9036], [-118.24216, 33.90405], [-118.24226, 33.90419]]], [[[-118.24858, 33.91176], [-118.24841, 33.91176], [-118.24735, 33.91049], [-118.24755, 33.9105], [-118.24857, 33.91171], [-118.24858, 33.91176]]]]} | Open Access 1 | 7202 | Compton Creek & Bike Path | 17571 | 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 | 0.849 | Compton Creek & Bike Path | 0 | Recreation Management Area 49 | 4 | |
4053 | 4053 | 4052 | {"type": "Polygon", "coordinates": [[[-120.63426, 37.85934], [-120.63377, 37.86008], [-120.63222, 37.86096], [-120.63246, 37.86129], [-120.63243, 37.86133], [-120.63134, 37.86171], [-120.63, 37.86242], [-120.62992, 37.8625], [-120.6297, 37.8621], [-120.62844, 37.86263], [-120.62838, 37.86143], [-120.62837, 37.86142], [-120.62757, 37.86181], [-120.627, 37.86214], [-120.62667, 37.86238], [-120.62626, 37.86279], [-120.62597, 37.86317], [-120.62588, 37.86306], [-120.62646, 37.86246], [-120.62671, 37.86225], [-120.62838, 37.86135], [-120.62883, 37.86124], [-120.62922, 37.86146], [-120.62971, 37.86134], [-120.63001, 37.86097], [-120.63166, 37.86028], [-120.6323, 37.85981], [-120.63255, 37.85869], [-120.63325, 37.85868], [-120.63426, 37.85934]]]} | Open Access 1 | 44370 | Goodwin Dam Recreation Area | 19404 | 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 | Tuolumne 21 | 18.684 | Goodwin Dam Rec. Area | 0 | Recreation Management Area 49 | 4 | |
465 | 465 | 464 | {"type": "Polygon", "coordinates": [[[-118.48671, 34.16591], [-118.48664, 34.16649], [-118.48663, 34.16717], [-118.48664, 34.16724], [-118.48669, 34.16733], [-118.48656, 34.1675], [-118.48638, 34.16753], [-118.48622, 34.16759], [-118.48616, 34.16766], [-118.48614, 34.16773], [-118.4862, 34.16804], [-118.48623, 34.16809], [-118.48628, 34.16811], [-118.48608, 34.16815], [-118.4861, 34.1681], [-118.48604, 34.16774], [-118.48591, 34.16777], [-118.48581, 34.1677], [-118.48557, 34.16772], [-118.48516, 34.16783], [-118.48494, 34.16787], [-118.48445, 34.16789], [-118.48418, 34.16787], [-118.48385, 34.1678], [-118.48369, 34.16772], [-118.48359, 34.1676], [-118.48357, 34.16755], [-118.48351, 34.1671], [-118.48355, 34.16638], [-118.48357, 34.16623], [-118.48362, 34.16609], [-118.48368, 34.16599], [-118.48374, 34.16594], [-118.48387, 34.1659], [-118.4853, 34.16589], [-118.48633, 34.16583], [-118.48634, 34.16591], [-118.48639, 34.16594], [-118.48671, 34.16591]]]} | Open Access 1 | 1861 | Hjelte Sports Center | 20010 | 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 | 14.721 | Hjelte Sports Ctr. | 0 | Recreation Management Area 49 | 4 | |
16770 | 16770 | 16769 | {"type": "Polygon", "coordinates": [[[-120.73227, 37.78935], [-120.73205, 37.79003], [-120.73166, 37.79035], [-120.73108, 37.7907], [-120.7305, 37.79113], [-120.73019, 37.79132], [-120.7301, 37.79127], [-120.72956, 37.79192], [-120.72909, 37.79271], [-120.72888, 37.79387], [-120.72864, 37.79446], [-120.72771, 37.79518], [-120.72674, 37.79679], [-120.72645, 37.79737], [-120.72624, 37.79731], [-120.72646, 37.79704], [-120.72657, 37.79678], [-120.72669, 37.79637], [-120.72674, 37.79631], [-120.72681, 37.79631], [-120.7269, 37.79627], [-120.72699, 37.79605], [-120.72711, 37.79591], [-120.72719, 37.79568], [-120.72751, 37.79517], [-120.72788, 37.79479], [-120.72808, 37.79468], [-120.72816, 37.79453], [-120.72827, 37.79445], [-120.72845, 37.79439], [-120.72864, 37.79417], [-120.72878, 37.79375], [-120.7288, 37.79336], [-120.7286, 37.79303], [-120.7286, 37.79274], [-120.72882, 37.79248], [-120.7289, 37.79217], [-120.72907, 37.79182], [-120.72931, 37.79148], [-120.72949, 37.79131], [-120.72962, 37.79107], [-120.7298, 37.79097], [-120.73005, 37.79063], [-120.73065, 37.79035], [-120.731, 37.79008], [-120.73128, 37.7895], [-120.73148, 37.78893], [-120.73204, 37.78857], [-120.73209, 37.78884], [-120.73227, 37.78935]]]} | Open Access 1 | 44371 | Honolulu Bar Recreation Area | 20069 | 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 | Stanislaus 2 | 10.135 | Honolulu Bar Rec. Area | 0 | Recreation Management Area 49 | 4 | |
5019 | 5019 | 5018 | {"type": "Polygon", "coordinates": [[[-118.96111, 36.3865], [-118.96105, 36.38679], [-118.96089, 36.38693], [-118.96051, 36.38705], [-118.96024, 36.38705], [-118.96009, 36.38719], [-118.95951, 36.38722], [-118.95919, 36.38717], [-118.95861, 36.38716], [-118.95851, 36.38723], [-118.95855, 36.3876], [-118.9584, 36.38789], [-118.95818, 36.38804], [-118.95796, 36.38808], [-118.95774, 36.38803], [-118.95737, 36.3877], [-118.95673, 36.38669], [-118.95654, 36.38633], [-118.95645, 36.38624], [-118.95629, 36.38619], [-118.95614, 36.38611], [-118.95594, 36.38608], [-118.95579, 36.38601], [-118.95528, 36.38547], [-118.95521, 36.38519], [-118.95514, 36.38504], [-118.95498, 36.38488], [-118.95426, 36.38454], [-118.95352, 36.38435], [-118.95309, 36.38418], [-118.95279, 36.384], [-118.95244, 36.38373], [-118.95229, 36.38363], [-118.95197, 36.38362], [-118.95169, 36.38376], [-118.95139, 36.38386], [-118.95097, 36.38385], [-118.95052, 36.38378], [-118.95041, 36.38374], [-118.95012, 36.38358], [-118.95136, 36.38322], [-118.95213, 36.38318], [-118.95297, 36.38321], [-118.95358, 36.38327], [-118.9544, 36.38345], [-118.95589, 36.38398], [-118.95805, 36.38488], [-118.96087, 36.38617], [-118.96111, 36.3865]]]} | Open Access 1 | 1030 | Horse Creek Recreation Area | 20095 | 199 | Other Federal 284 | Federal 1 | Federal Agency 1 | Other Federal 13 | 199 | Other Federal 280 | Federal 1 | Federal Agency 1 | Tulare 29 | 39.18 | Horse Creek Rec. Area | 0 | Recreation Management Area 49 | 4 | ||
16822 | 16822 | 16821 | {"type": "MultiPolygon", "coordinates": [[[[-120.66805, 37.81989], [-120.66759, 37.81995], [-120.66759, 37.82001], [-120.66614, 37.82019], [-120.66641, 37.82185], [-120.66595, 37.82184], [-120.6652, 37.82204], [-120.66433, 37.82161], [-120.66432, 37.82162], [-120.66432, 37.82178], [-120.66335, 37.82178], [-120.66303, 37.82187], [-120.66274, 37.82182], [-120.66245, 37.82191], [-120.66222, 37.82181], [-120.66199, 37.82185], [-120.66159, 37.82159], [-120.66112, 37.82154], [-120.65996, 37.82186], [-120.65945, 37.82217], [-120.65923, 37.8225], [-120.65845, 37.82289], [-120.65831, 37.82308], [-120.65791, 37.82334], [-120.65775, 37.82362], [-120.65782, 37.82395], [-120.65767, 37.82411], [-120.65711, 37.82439], [-120.65704, 37.82502], [-120.65718, 37.82534], [-120.65723, 37.82594], [-120.6549, 37.82679], [-120.65454, 37.82795], [-120.65418, 37.82888], [-120.65363, 37.83046], [-120.65339, 37.83356], [-120.6531, 37.83332], [-120.65346, 37.83033], [-120.65366, 37.82944], [-120.65425, 37.82817], [-120.65435, 37.82751], [-120.65481, 37.82636], [-120.65538, 37.82553], [-120.65581, 37.82466], [-120.65608, 37.82358], [-120.65619, 37.82324], [-120.65623, 37.82297], [-120.65669, 37.82241], [-120.65718, 37.82219], [-120.65762, 37.82183], [-120.65783, 37.82153], [-120.65799, 37.82135], [-120.65833, 37.82105], [-120.65856, 37.82072], [-120.65879, 37.82054], [-120.65905, 37.82037], [-120.65916, 37.82035], [-120.65934, 37.8204], [-120.65953, 37.8204], [-120.65991, 37.82045], [-120.66022, 37.82044], [-120.66068, 37.82048], [-120.66105, 37.82047], [-120.66131, 37.82044], [-120.66177, 37.82033], [-120.6621, 37.82027], [-120.66247, 37.8203], [-120.66268, 37.82023], [-120.66302, 37.82023], [-120.66322, 37.82017], [-120.6634, 37.82019], [-120.66372, 37.82006], [-120.66398, 37.82002], [-120.66413, 37.82022], [-120.66424, 37.82016], [-120.66416, 37.82001], [-120.66458, 37.81977], [-120.66468, 37.81969], [-120.66482, 37.81945], [-120.66483, 37.81932], [-120.66476, 37.81923], [-120.6647, 37.81911], [-120.66514, 37.81872], [-120.66565, 37.81849], [-120.66592, 37.81841], [-120.66633, 37.81838], [-120.66657, 37.81843], [-120.66662, 37.81852], [-120.66688, 37.81868], [-120.66699, 37.8187], [-120.66723, 37.81869], [-120.66745, 37.81875], [-120.66753, 37.81875], [-120.66805, 37.81989]]], [[[-120.67468, 37.81465], [-120.67467, 37.8149], [-120.67458, 37.81526], [-120.6746, 37.81556], [-120.67447, 37.81573], [-120.67444, 37.81581], [-120.67449, 37.81607], [-120.67443, 37.81623], [-120.67442, 37.81659], [-120.67431, 37.81683], [-120.67426, 37.81703], [-120.674, 37.81737], [-120.67367, 37.81758], [-120.6733, 37.81776], [-120.67267, 37.81793], [-120.67189, 37.81811], [-120.66985, 37.81853], [-120.66957, 37.81862], [-120.66947, 37.81863], [-120.66934, 37.81867], [-120.66907, 37.81866], [-120.66856, 37.81857], [-120.6684, 37.81856], [-120.66804, 37.8186], [-120.66789, 37.8183], [-120.66763, 37.81766], [-120.66759, 37.81745], [-120.6675, 37.81721], [-120.66732, 37.81691], [-120.66726, 37.81684], [-120.66716, 37.81688], [-120.66623, 37.81613], [-120.66649, 37.81593], [-120.66701, 37.81634], [-120.66883, 37.8177], [-120.67106, 37.81738], [-120.67248, 37.81663], [-120.67274, 37.8159], [-120.67291, 37.81476], [-120.67286, 37.81434], [-120.67271, 37.81425], [-120.67233, 37.81425], [-120.67194, 37.81411], [-120.67094, 37.81326], [-120.67132, 37.81323], [-120.6714, 37.81307], [-120.67134, 37.81286], [-120.67127, 37.81275], [-120.6708, 37.81242], [-120.67095, 37.81218], [-120.67146, 37.81216], [-120.67159, 37.81261], [-120.67159, 37.81282], [-120.67174, 37.8131], [-120.67196, 37.81336], [-120.67223, 37.81353], [-120.67244, 37.8136], [-120.67284, 37.81366], [-120.67317, 37.81375], [-120.67338, 37.81387], [-120.67379, 37.81393], [-120.67422, 37.81415], [-120.67468, 37.81465]]], [[[-120.6704, 37.81954], [-120.66998, 37.8197], [-120.66982, 37.81971], [-120.6698, 37.81965], [-120.66928, 37.81971], [-120.66905, 37.8197], [-120.66884, 37.81966], [-120.66855, 37.81952], [-120.66847, 37.81947], [-120.66841, 37.81941], [-120.66811, 37.81876], [-120.66829, 37.81874], [-120.66872, 37.81875], [-120.66921, 37.81882], [-120.6694, 37.81883], [-120.66962, 37.81879], [-120.66991, 37.81869], [-120.6704, 37.81954]]]]} | Open Access 1 | 18347 | Knights Ferry Recreation Area | 20693 | 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 | Stanislaus 2 | 103.247 | Knights Ferry Rec. Area | 0 | Recreation Management Area 49 | 4 | |
6412 | 6412 | 6411 | {"type": "MultiPolygon", "coordinates": [[[[-118.49126, 34.18526], [-118.49096, 34.18527], [-118.48979, 34.1852], [-118.48979, 34.18557], [-118.48918, 34.18558], [-118.48917, 34.18609], [-118.48587, 34.18609], [-118.48586, 34.18521], [-118.48387, 34.1852], [-118.48387, 34.18494], [-118.48458, 34.18493], [-118.48647, 34.18422], [-118.48811, 34.18393], [-118.48813, 34.18462], [-118.49122, 34.18458], [-118.49126, 34.18526]]], [[[-118.50099, 34.18172], [-118.50093, 34.18174], [-118.50079, 34.18175], [-118.50064, 34.18171], [-118.50016, 34.18144], [-118.50004, 34.18139], [-118.49962, 34.18137], [-118.49941, 34.18129], [-118.49856, 34.18058], [-118.49842, 34.18053], [-118.49826, 34.18052], [-118.49761, 34.18051], [-118.49763, 34.18229], [-118.49715, 34.18294], [-118.49679, 34.18321], [-118.49347, 34.18436], [-118.49351, 34.18461], [-118.49351, 34.18487], [-118.49344, 34.18507], [-118.49331, 34.18519], [-118.49305, 34.18528], [-118.49246, 34.18527], [-118.49251, 34.1807], [-118.49249, 34.18068], [-118.4925, 34.17711], [-118.49395, 34.17767], [-118.49604, 34.17826], [-118.50099, 34.18021], [-118.50099, 34.18172]]]]} | Open Access 1 | 3334 | Lake Balboa Park | 20875 | 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 | 110.991 | Lake Balboa Park | 0 | Recreation Management Area 49 | 4 | |
16652 | 16652 | 16651 | {"type": "MultiPolygon", "coordinates": [[[[-121.33461, 39.6131], [-121.31605, 39.61339], [-121.31622, 39.60442], [-121.31812, 39.60418], [-121.31902, 39.60466], [-121.31785, 39.60728], [-121.32003, 39.6088], [-121.32015, 39.61032], [-121.32494, 39.61183], [-121.32956, 39.61096], [-121.3345, 39.60636], [-121.33461, 39.6131]]], [[[-121.38939, 39.57026], [-121.38831, 39.5722], [-121.37386, 39.57152], [-121.37218, 39.57253], [-121.3693, 39.57456], [-121.36005, 39.57437], [-121.35685, 39.57515], [-121.35318, 39.57973], [-121.35293, 39.58002], [-121.35312, 39.57084], [-121.37186, 39.57039], [-121.37613, 39.57039], [-121.38939, 39.57026]]], [[[-121.37239, 39.5835], [-121.36235, 39.5847], [-121.36047, 39.58492], [-121.36112, 39.58351], [-121.36342, 39.5813], [-121.36738, 39.58167], [-121.37228, 39.58081], [-121.37239, 39.5835]]], [[[-121.41255, 39.53317], [-121.40968, 39.53597], [-121.40825, 39.53691], [-121.40698, 39.53824], [-121.40501, 39.53809], [-121.40185, 39.54051], [-121.39557, 39.53793], [-121.39535, 39.53787], [-121.39184, 39.53341], [-121.39125, 39.52643], [-121.39007, 39.52606], [-121.39007, 39.52247], [-121.39661, 39.52252], [-121.40404, 39.52262], [-121.40863, 39.52265], [-121.40863, 39.52551], [-121.40853, 39.53326], [-121.41255, 39.53317]]], [[[-121.41778, 39.53304], [-121.41781, 39.53482], [-121.41774, 39.54104], [-121.41677, 39.54105], [-121.41632, 39.54103], [-121.4152, 39.54094], [-121.41343, 39.5382], [-121.41519, 39.53673], [-121.41499, 39.53311], [-121.41778, 39.53304]]], [[[-121.47715, 39.61377], [-121.47689, 39.61377], [-121.47693, 39.61193], [-121.47658, 39.61142], [-121.4762, 39.61067], [-121.47607, 39.61038], [-121.47584, 39.61007], [-121.4751, 39.6089], [-121.47488, 39.60852], [-121.47431, 39.60848], [-121.47448, 39.60358], [-121.47232, 39.60196], [-121.46978, 39.60278], [-121.46972, 39.60251], [-121.46971, 39.6025], [-121.46794, 39.60314], [-121.46491, 39.60289], [-121.46491, 39.60256], [-121.46773, 39.60252], [-121.46977, 39.60214], [-121.47183, 39.60171], [-121.47316, 39.6022], [-121.4763, 39.60498], [-121.47488, 39.60825], [-121.47714, 39.61191], [-121.47715, 39.61377]]], [[[-121.48148, 39.62159], [-121.48141, 39.62196], [-121.47868, 39.62337], [-121.47636, 39.62164], [-121.47618, 39.62042], [-121.47709, 39.61843], [-121.47516, 39.61686], [-121.47411, 39.61496], [-121.47419, 39.61391], [-121.47445, 39.61391], [-121.47445, 39.61502], [-121.47518, 39.61662], [-121.47733, 39.61814], [-121.47626, 39.62035], [-121.4764, 39.62124], [-121.47908, 39.62289], [-121.48148, 39.62159]]], [[[-121.47666, 39.63437], [-121.47659, 39.6344], [-121.47593, 39.63336], [-121.47664, 39.63437], [-121.47666, 39.63437]]], [[[-121.4788, 39.63005], [-121.47727, 39.63148], [-121.47694, 39.63178], [-121.4787, 39.6299], [-121.4788, 39.63005]]], [[[-121.48367, 39.62027], [-121.48362, 39.62118], [-121.48152, 39.62358], [-121.48145, 39.62362], [-121.48319, 39.62101], [-121.48198, 39.62024], [-121.48212, 39.61968], [-121.48367, 39.62027]]], [[[-121.4956, 39.64608], [-121.48977, 39.64966], [-121.48874, 39.6519], [-121.48775, 39.6542], [-121.48614, 39.65417], [-121.48627, 39.63993], [-121.49088, 39.63996], [-121.4897, 39.63481], [-121.48913, 39.63382], [-121.49006, 39.63534], [-121.49148, 39.64016], [-121.49546, 39.6459], [-121.4956, 39.64608]]], [[[-121.50553, 39.64585], [-121.50555, 39.64725], [-121.5055, 39.65445], [-121.49996, 39.65438], [-121.49971, 39.6538], [-121.49976, 39.65343], [-121.5048, 39.65008], [-121.50553, 39.64585]]], [[[-121.50551, 39.6446], [-121.50551, 39.64436], [-121.50384, 39.64059], [-121.50364, 39.64005], [-121.50545, 39.64006], [-121.50551, 39.6446]]], [[[-121.55677, 39.72776], [-121.54164, 39.73016], [-121.54146, 39.7292], [-121.54144, 39.72695], [-121.54655, 39.7257], [-121.55136, 39.72491], [-121.5514, 39.72398], [-121.55418, 39.72367], [-121.55659, 39.72639], [-121.55677, 39.72776]]], [[[-121.55407, 39.71999], [-121.55049, 39.72214], [-121.55064, 39.72394], [-121.55061, 39.72394], [-121.55048, 39.722], [-121.55151, 39.72139], [-121.55169, 39.71689], [-121.54693, 39.71727], [-121.54728, 39.71236], [-121.5519, 39.71244], [-121.55345, 39.71242], [-121.55339, 39.71505], [-121.55274, 39.71723], [-121.55407, 39.71999]]], [[[-121.57043, 39.70493], [-121.57032, 39.70854], [-121.56567, 39.70854], [-121.5656, 39.7122], [-121.56099, 39.71221], [-121.56084, 39.72711], [-121.56017, 39.72722], [-121.56033, 39.72525], [-121.558, 39.72249], [-121.55754, 39.71731], [-121.55872, 39.71635], [-121.55821, 39.71232], [-121.55816, 39.7116], [-121.56114, 39.71058], [-121.56255, 39.71003], [-121.56395, 39.70842], [-121.5671, 39.70584], [-121.5669, 39.70491], [-121.57043, 39.70493]], [[-121.56098, 39.7122], [-121.56102, 39.7109], [-121.55851, 39.71179], [-121.55849, 39.71226], [-121.56098, 39.7122]]]]} | Open Access 1 | 16331 | Lake Oroville State Recreation Area | 20957 | 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 | Butte 42 | 1861.059 | Lake Oroville SRA | 1967 | Recreation Management Area 49 | 4 | |
10059 | 10059 | 10058 | {"type": "Polygon", "coordinates": [[[-118.49219, 34.16366], [-118.49127, 34.1647], [-118.49126, 34.16484], [-118.48809, 34.16482], [-118.48809, 34.16062], [-118.48813, 34.16046], [-118.48931, 34.16046], [-118.48932, 34.1631], [-118.49219, 34.16311], [-118.49219, 34.16366]]]} | Open Access 1 | 17417 | Libbit Park | 21202 | 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.58 | Libbit Park | 0 | Recreation Management Area 49 | 4 | |
10040 | 10040 | 10039 | {"type": "Polygon", "coordinates": [[[-119.49172, 34.40088], [-119.49129, 34.40263], [-119.49129, 34.40263], [-119.49072, 34.40237], [-119.49092, 34.40127], [-119.49172, 34.40088]]]} | Open Access 1 | 17367 | Lions Park | 21316 | 199 | Other Federal 284 | Federal 1 | Federal Agency 1 | Other Federal 13 | 199 | Other Federal 280 | Federal 1 | Federal Agency 1 | Santa Barbara 7 | 2.41 | Lions 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]);