units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
61 rows where DES_TP = 49 sorted by PARK_URL
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_WEB, LAYER, MNG_AG_ID, PARK_URL
COUNTY 20 ✖
- Los Angeles 28
- Stanislaus 5
- Madera 4
- Ventura 3
- Placer 3
- Fresno 2
- Monterey 2
- San Bernardino 2
- San Diego 1
- Santa Barbara 1
- San Francisco 1
- Sonoma 1
- Tehama 1
- Tuolumne 1
- Marin 1
- Tulare 1
- Nevada 1
- Mariposa 1
- San Joaquin 1
- Butte 1
MNG_AGENCY 8
ACCESS_TYP 4
MNG_AG_TYP 1
DES_TP 1
- Recreation Management Area · 61 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
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 | |
1279 | 1279 | 1278 | {"type": "Polygon", "coordinates": [[[-118.62382, 34.08177], [-118.62381, 34.08535], [-118.61508, 34.08531], [-118.61509, 34.08234], [-118.61513, 34.07806], [-118.62377, 34.0781], [-118.62382, 34.08177]]]} | Open Access 1 | 7224 | Hondo Canyon Open Space | 14227 | 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 | 159.718 | Hondo Canyon OS | 0 | Recreation Management Area 49 | 4 | |
1526 | 1526 | 1525 | {"type": "Polygon", "coordinates": [[[-118.50099, 34.17906], [-118.49854, 34.17803], [-118.49442, 34.17649], [-118.48937, 34.17455], [-118.47912, 34.17066], [-118.48, 34.17022], [-118.48079, 34.16993], [-118.48155, 34.16969], [-118.48232, 34.16949], [-118.48336, 34.16927], [-118.48464, 34.16886], [-118.48587, 34.16861], [-118.48659, 34.16843], [-118.48732, 34.16823], [-118.48784, 34.16822], [-118.48841, 34.16791], [-118.48987, 34.16748], [-118.49042, 34.16735], [-118.49087, 34.16727], [-118.49143, 34.16721], [-118.492, 34.1672], [-118.49256, 34.16722], [-118.49313, 34.16728], [-118.49369, 34.16739], [-118.49412, 34.1675], [-118.49465, 34.16768], [-118.49526, 34.16794], [-118.49583, 34.16825], [-118.49636, 34.16861], [-118.49669, 34.16888], [-118.49692, 34.16909], [-118.49738, 34.16963], [-118.49767, 34.1701], [-118.49815, 34.17079], [-118.49842, 34.17144], [-118.49856, 34.17168], [-118.49871, 34.17186], [-118.49887, 34.17201], [-118.49905, 34.17213], [-118.49927, 34.17223], [-118.49953, 34.17249], [-118.50001, 34.17249], [-118.50089, 34.17236], [-118.50092, 34.17238], [-118.50093, 34.17592], [-118.50098, 34.17593], [-118.50099, 34.17906]]]} | Restricted Access 2 | 12883 | Balboa Golf Course & Encino Golf Course | 33032 | 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 | 320.852 | Balboa GC & Encino GC | 0 | Recreation Management Area 49 | 4 | |
2412 | 2412 | 2411 | {"type": "Polygon", "coordinates": [[[-118.78338, 34.19921], [-118.78174, 34.20842], [-118.76116, 34.21338], [-118.75992, 34.2125], [-118.76116, 34.21246], [-118.76119, 34.19892], [-118.76126, 34.19894], [-118.78338, 34.19921]]]} | Open Access 1 | 17245 | Lang Ranch - Jordan Ranch | 14242 | 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 | 635.319 | Lang Ranch - Jordan Ranch | 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 | |
4135 | 4135 | 4134 | {"type": "Polygon", "coordinates": [[[-122.52305, 38.05524], [-122.52194, 38.05549], [-122.52181, 38.05532], [-122.52157, 38.05523], [-122.52156, 38.0552], [-122.52157, 38.05504], [-122.52156, 38.05494], [-122.52152, 38.05472], [-122.52145, 38.05448], [-122.52158, 38.05436], [-122.52177, 38.05425], [-122.52233, 38.05409], [-122.52305, 38.05524]]]} | Restricted Access 2 | 47183 | United States Coast Guard Park | 30875 | 104 | United States Coast Guard 511 | Federal 1 | Federal Agency 1 | http://www.uscg.mil/ | Other Federal 13 | 104 | United States Coast Guard 503 | Federal 1 | Federal Agency 1 | Marin 23 | 3.383 | United States Coast Guard Park | 0 | Recreation Management Area 49 | 4 | |
4884 | 4884 | 4883 | {"type": "MultiPolygon", "coordinates": [[[[-118.08173, 34.04994], [-118.0805, 34.04993], [-118.07751, 34.04834], [-118.07751, 34.04837], [-118.08049, 34.04996], [-118.08013, 34.04996], [-118.08012, 34.04997], [-118.08074, 34.05031], [-118.08073, 34.05157], [-118.07969, 34.05156], [-118.07753, 34.05168], [-118.07752, 34.05165], [-118.07733, 34.05166], [-118.07732, 34.05169], [-118.07317, 34.05171], [-118.07316, 34.05168], [-118.07307, 34.05168], [-118.07312, 34.04139], [-118.07467, 34.04125], [-118.07526, 34.04117], [-118.07525, 34.04275], [-118.07528, 34.04276], [-118.07529, 34.04116], [-118.07647, 34.04099], [-118.07643, 34.0414], [-118.07572, 34.04156], [-118.07534, 34.04238], [-118.07559, 34.04268], [-118.0763, 34.04268], [-118.07649, 34.04247], [-118.07747, 34.04247], [-118.07748, 34.04209], [-118.07802, 34.04182], [-118.07839, 34.04182], [-118.0791, 34.04225], [-118.07943, 34.04272], [-118.07964, 34.04272], [-118.07965, 34.04362], [-118.08009, 34.04362], [-118.0801, 34.04407], [-118.08087, 34.04407], [-118.08088, 34.04451], [-118.08114, 34.04452], [-118.08114, 34.04512], [-118.0817, 34.04512], [-118.08173, 34.04994]], [[-118.07717, 34.04812], [-118.07728, 34.04818], [-118.0773, 34.04818], [-118.07729, 34.04815], [-118.07602, 34.04748], [-118.07556, 34.04718], [-118.07541, 34.04706], [-118.07513, 34.04677], [-118.07499, 34.04658], [-118.07485, 34.04634], [-118.07471, 34.04603], [-118.07464, 34.04577], [-118.07528, 34.04458], [-118.07528, 34.04449], [-118.07525, 34.04449], [-118.07524, 34.04457], [-118.07434, 34.04628], [-118.07421, 34.04779], [-118.07318, 34.04991], [-118.07318, 34.04997], [-118.0732, 34.04997], [-118.07425, 34.0478], [-118.07437, 34.04628], [-118.07462, 34.04582], [-118.07468, 34.04603], [-118.07475, 34.04621], [-118.0749, 34.0465], [-118.07504, 34.0467], [-118.07538, 34.04707], [-118.07565, 34.04729], [-118.07595, 34.04747], [-118.07717, 34.04812]]], [[[-118.08027, 34.05174], [-118.08023, 34.05182], [-118.07834, 34.05181], [-118.07833, 34.05424], [-118.07813, 34.05438], [-118.07758, 34.05533], [-118.07756, 34.05534], [-118.07753, 34.05542], [-118.07671, 34.05543], [-118.07671, 34.05634], [-118.07648, 34.05719], [-118.0757, 34.05687], [-118.07535, 34.05699], [-118.07486, 34.05751], [-118.07467, 34.05792], [-118.07424, 34.05812], [-118.07362, 34.05794], [-118.07302, 34.05794], [-118.07301, 34.05872], [-118.0719, 34.05755], [-118.07222, 34.05543], [-118.073, 34.05542], [-118.07299, 34.0519], [-118.07318, 34.0519], [-118.07318, 34.05187], [-118.07743, 34.05185], [-118.07965, 34.05174], [-118.08027, 34.05174]]]]} | Restricted Access 2 | 6566 | Whittier Narrows Golf Course | 33010 | 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 | 268.099 | Whittier Narrows GC | 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 | ||
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 | |
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 | |
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 | |
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 | |
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 | |
7058 | 7058 | 7057 | {"type": "Polygon", "coordinates": [[[-118.06181, 34.02017], [-118.06089, 34.02054], [-118.06107, 34.02082], [-118.06117, 34.02082], [-118.06121, 34.02141], [-118.05671, 34.02154], [-118.0577, 34.02122], [-118.05703, 34.01992], [-118.05747, 34.01907], [-118.05897, 34.01802], [-118.06078, 34.01739], [-118.06033, 34.01796], [-118.05961, 34.01857], [-118.0607, 34.02026], [-118.06181, 34.02017]]]} | Restricted Access 2 | 6569 | Pico Rivera Golf Course | 33017 | 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 | 26.31 | Pico Rivera GC | 0 | Recreation Management Area 49 | 4 | |
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 | |
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 | |
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 |
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]);