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_TYP = 1 sorted by ACRES
This data as json, copyable, CSV (advanced)
MNG_AGENCY 7
ACCESS_TYP 3
MNG_AG_TYP 1
- Federal Agency · 41 ✖
DES_TP 1
- Recreation Management Area · 41 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
10057 | 10057 | 10056 | {"type": "MultiPolygon", "coordinates": [[[[-120.15944, 39.11112], [-120.15898, 39.11163], [-120.15858, 39.11216], [-120.15822, 39.11273], [-120.15808, 39.113], [-120.158, 39.11325], [-120.15795, 39.11346], [-120.15792, 39.11367], [-120.15792, 39.11389], [-120.15794, 39.1141], [-120.15798, 39.11431], [-120.15813, 39.11475], [-120.1579, 39.11475], [-120.15779, 39.11452], [-120.1577, 39.11413], [-120.15768, 39.11388], [-120.15768, 39.11367], [-120.15773, 39.11321], [-120.15776, 39.1131], [-120.1578, 39.113], [-120.15783, 39.11279], [-120.15793, 39.11248], [-120.15795, 39.11229], [-120.15806, 39.11206], [-120.1583, 39.11158], [-120.1586, 39.11111], [-120.15944, 39.11112]]], [[[-120.16538, 39.11475], [-120.16269, 39.11475], [-120.15978, 39.11469], [-120.1595, 39.11469], [-120.15843, 39.11474], [-120.15829, 39.11437], [-120.15822, 39.11406], [-120.1582, 39.11379], [-120.15823, 39.11348], [-120.1583, 39.11322], [-120.1584, 39.11296], [-120.15873, 39.1124], [-120.15878, 39.11236], [-120.15908, 39.11237], [-120.15926, 39.11234], [-120.15943, 39.11227], [-120.15957, 39.11215], [-120.15957, 39.11245], [-120.16153, 39.1125], [-120.16154, 39.11117], [-120.16208, 39.1112], [-120.16538, 39.11475]]]]} | Open Access 1 | 49029 | Kaspian Recreation Area | 33730 | 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 | https://www.fs.usda.gov/Internet/FSE_DOCUMENTS/fseprd632577.pdf | Placer 35 | 39.38 | Kaspian Rec. Area | 0 | Recreation Management Area 49 | 4 |
16732 | 16732 | 16731 | {"type": "Polygon", "coordinates": [[[-121.01374, 37.75437], [-121.01373, 37.7545], [-121.01301, 37.755], [-121.01238, 37.75508], [-121.01166, 37.75503], [-121.01108, 37.75503], [-121.01074, 37.7551], [-121.0102, 37.75528], [-121.01022, 37.75749], [-121.01034, 37.75767], [-121.01005, 37.75774], [-121.01003, 37.75498], [-121.01044, 37.75499], [-121.01078, 37.75439], [-121.0108, 37.75364], [-121.01074, 37.75322], [-121.01058, 37.75288], [-121.01036, 37.75269], [-121.01021, 37.75222], [-121.00956, 37.75208], [-121.00872, 37.75173], [-121.00845, 37.75113], [-121.0084, 37.75073], [-121.00826, 37.75062], [-121.0081, 37.75058], [-121.00782, 37.7506], [-121.00752, 37.75067], [-121.00731, 37.75075], [-121.00726, 37.7507], [-121.00736, 37.75051], [-121.00732, 37.74994], [-121.00762, 37.74926], [-121.00811, 37.74904], [-121.00902, 37.74897], [-121.00982, 37.74905], [-121.01015, 37.74927], [-121.01079, 37.74964], [-121.01155, 37.74982], [-121.01204, 37.74968], [-121.01251, 37.74962], [-121.0127, 37.75005], [-121.01255, 37.75045], [-121.01216, 37.75078], [-121.01147, 37.75101], [-121.01094, 37.75128], [-121.01077, 37.75164], [-121.01095, 37.75201], [-121.01138, 37.75228], [-121.01218, 37.7526], [-121.01235, 37.75306], [-121.01234, 37.7532], [-121.01213, 37.75359], [-121.01232, 37.75404], [-121.01281, 37.75419], [-121.01333, 37.7542], [-121.01374, 37.75437]]]} | Open Access 1 | 36069 | McHenry Recreation Area | 22039 | 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 | San Joaquin 39 | 40.217 | McHenry Rec. Area | 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 |
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 | |
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 |
7009 | 7009 | 7008 | {"type": "MultiPolygon", "coordinates": [[[[-118.69717, 34.09626], [-118.69708, 34.09636], [-118.69685, 34.09655], [-118.69422, 34.09857], [-118.69401, 34.09877], [-118.69383, 34.09898], [-118.69368, 34.09919], [-118.69353, 34.09945], [-118.69353, 34.09626], [-118.69717, 34.09626]]], [[[-118.70229, 34.09625], [-118.7001, 34.09625], [-118.7001, 34.0973], [-118.69892, 34.09625], [-118.69902, 34.09624], [-118.69892, 34.09614], [-118.69887, 34.09599], [-118.69889, 34.0958], [-118.69888, 34.09569], [-118.69891, 34.09558], [-118.69792, 34.09557], [-118.69791, 34.09987], [-118.69364, 34.09988], [-118.69378, 34.09954], [-118.69393, 34.09928], [-118.69405, 34.09911], [-118.69432, 34.09881], [-118.69463, 34.09856], [-118.69719, 34.09659], [-118.69738, 34.0964], [-118.6975, 34.09623], [-118.69761, 34.09596], [-118.69765, 34.09574], [-118.69765, 34.09559], [-118.69762, 34.09544], [-118.69755, 34.09522], [-118.69791, 34.09509], [-118.69791, 34.09264], [-118.70227, 34.09264], [-118.70229, 34.09625]]]]} | Open Access 1 | 6490 | 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 | 77.512 | King Gillette Ranch | 0 | Recreation Management Area 49 | 4 |
16699 | 16699 | 16698 | {"type": "Polygon", "coordinates": [[[-120.88295, 37.77172], [-120.88256, 37.77198], [-120.88179, 37.77203], [-120.88033, 37.77166], [-120.87991, 37.77131], [-120.87976, 37.77136], [-120.87973, 37.77128], [-120.87865, 37.7707], [-120.87693, 37.77072], [-120.87501, 37.7713], [-120.87088, 37.77321], [-120.86954, 37.77366], [-120.86818, 37.77427], [-120.86739, 37.77476], [-120.86714, 37.7757], [-120.8669, 37.77195], [-120.86735, 37.77185], [-120.86749, 37.77197], [-120.86801, 37.77201], [-120.86826, 37.77194], [-120.8684, 37.77181], [-120.86849, 37.77182], [-120.86855, 37.77192], [-120.86865, 37.77192], [-120.86877, 37.77184], [-120.86883, 37.7717], [-120.86878, 37.77144], [-120.86945, 37.77132], [-120.87085, 37.77084], [-120.87131, 37.7705], [-120.8715, 37.77059], [-120.87171, 37.77054], [-120.87272, 37.77023], [-120.87311, 37.7702], [-120.87349, 37.77006], [-120.87407, 37.76978], [-120.87444, 37.76966], [-120.87499, 37.76936], [-120.87556, 37.76908], [-120.87594, 37.76891], [-120.87603, 37.76883], [-120.87606, 37.76874], [-120.87618, 37.76877], [-120.87631, 37.76893], [-120.87689, 37.76888], [-120.87756, 37.76886], [-120.87798, 37.76892], [-120.8785, 37.76891], [-120.87959, 37.76911], [-120.88003, 37.7691], [-120.88132, 37.77008], [-120.88248, 37.77006], [-120.88226, 37.77044], [-120.88174, 37.77064], [-120.88177, 37.77075], [-120.88229, 37.77116], [-120.88283, 37.77155], [-120.88295, 37.77172]]]} | Open Access 1 | 24997 | Oakdale Recreation Area | 23026 | 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 | 79.54 | Oakdale Rec. Area | 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 | |
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 | |
14617 | 14617 | 14616 | {"type": "Polygon", "coordinates": [[[-119.70655, 36.99035], [-119.70559, 36.99222], [-119.70367, 36.99264], [-119.70348, 36.99244], [-119.70288, 36.99243], [-119.70206, 36.99248], [-119.70171, 36.99259], [-119.69931, 36.99252], [-119.69921, 36.99242], [-119.69967, 36.99242], [-119.70001, 36.99241], [-119.70012, 36.98879], [-119.7022, 36.9888], [-119.70293, 36.98757], [-119.70117, 36.98587], [-119.70127, 36.98229], [-119.70155, 36.98153], [-119.7028, 36.98154], [-119.70272, 36.98519], [-119.70466, 36.98704], [-119.705, 36.98694], [-119.70655, 36.99035]]]} | Open Access 1 | 44841 | Millerton Lake State Recreation Area | 22249 | 103 | United States Bureau of Reclamation 369 | Federal 1 | Federal Agency 1 | http://www.usbr.gov/ | Other Federal 13 | 103 | United States Bureau of Reclamation 364 | Federal 1 | Federal Agency 1 | Fresno 9 | 89.743 | Millerton Lake SRA | 1957 | Recreation Management Area 49 | 4 | |
10252 | 10252 | 10251 | {"type": "Polygon", "coordinates": [[[-121.86631, 36.59322], [-121.85952, 36.59448], [-121.85921, 36.5945], [-121.85903, 36.59448], [-121.85883, 36.59442], [-121.85868, 36.59434], [-121.85851, 36.59421], [-121.85843, 36.59412], [-121.85764, 36.59307], [-121.85748, 36.59291], [-121.85732, 36.59282], [-121.85709, 36.59273], [-121.85687, 36.5927], [-121.85665, 36.5927], [-121.85663, 36.59253], [-121.85822, 36.59018], [-121.86078, 36.58966], [-121.86079, 36.58964], [-121.86073, 36.58945], [-121.86357, 36.58887], [-121.86307, 36.58725], [-121.86422, 36.58747], [-121.86449, 36.58758], [-121.86472, 36.58774], [-121.86485, 36.58787], [-121.86495, 36.588], [-121.86501, 36.58812], [-121.86518, 36.58858], [-121.86586, 36.58955], [-121.86628, 36.59047], [-121.86634, 36.59125], [-121.86631, 36.59322]]]} | Restricted Access 2 | 17943 | Monterey Pines Golf Course | 33062 | 198 | United States Department of Defense 61 | Federal 1 | Federal Agency 1 | http://www.defense.gov/ | US Military/Defense 11 | 198 | United States Department of Defense 504 | Federal 1 | Federal Agency 1 | Monterey 14 | 102.653 | Monterey Pines GC | 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 | |
16090 | 16090 | 16089 | {"type": "Polygon", "coordinates": [[[-118.75338, 34.07449], [-118.74918, 34.07468], [-118.74905, 34.06713], [-118.74903, 34.06346], [-118.74927, 34.06345], [-118.74935, 34.06348], [-118.74943, 34.06353], [-118.74951, 34.06364], [-118.74963, 34.06373], [-118.75017, 34.06398], [-118.75031, 34.06401], [-118.75074, 34.06406], [-118.75082, 34.0641], [-118.75083, 34.06419], [-118.75066, 34.06433], [-118.75064, 34.06438], [-118.75064, 34.06447], [-118.75066, 34.06452], [-118.75065, 34.06456], [-118.7505, 34.06477], [-118.75045, 34.06487], [-118.75046, 34.065], [-118.75048, 34.06506], [-118.75051, 34.06511], [-118.75062, 34.0652], [-118.75078, 34.06526], [-118.7509, 34.06526], [-118.75097, 34.06524], [-118.75153, 34.06497], [-118.7516, 34.06497], [-118.75165, 34.065], [-118.7519, 34.06549], [-118.75197, 34.06556], [-118.75207, 34.0656], [-118.75251, 34.06555], [-118.75257, 34.0656], [-118.75272, 34.06593], [-118.75277, 34.06598], [-118.75285, 34.06602], [-118.75296, 34.06602], [-118.75316, 34.06595], [-118.75321, 34.06595], [-118.75324, 34.06794], [-118.75319, 34.06799], [-118.75317, 34.06807], [-118.75319, 34.06813], [-118.75325, 34.06821], [-118.75334, 34.07273], [-118.75328, 34.07283], [-118.75327, 34.07292], [-118.75329, 34.073], [-118.75335, 34.07314], [-118.75338, 34.07449]]]} | Open Access 1 | 12313 | Gage Open Space | 14219 | 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 | 103.318 | Gage OS | 0 | Recreation Management Area 49 | 4 | |
7560 | 7560 | 7559 | {"type": "MultiPolygon", "coordinates": [[[[-117.94229, 34.13664], [-117.9421, 34.13679], [-117.94137, 34.1372], [-117.94117, 34.1373], [-117.94031, 34.13764], [-117.93932, 34.138], [-117.9386, 34.1383], [-117.93794, 34.13857], [-117.93747, 34.13882], [-117.93682, 34.13925], [-117.93592, 34.14006], [-117.93508, 34.1411], [-117.9344, 34.14184], [-117.93412, 34.14179], [-117.93422, 34.14139], [-117.93331, 34.14123], [-117.93347, 34.14106], [-117.93378, 34.14105], [-117.93408, 34.14099], [-117.93435, 34.14088], [-117.93459, 34.14074], [-117.93754, 34.13815], [-117.93754, 34.13814], [-117.93733, 34.13814], [-117.93445, 34.14066], [-117.93433, 34.14074], [-117.93407, 34.14085], [-117.93378, 34.14091], [-117.93358, 34.14092], [-117.93953, 34.13483], [-117.94229, 34.13664]]], [[[-117.93852, 34.14177], [-117.93791, 34.14249], [-117.93468, 34.14189], [-117.93496, 34.1416], [-117.93526, 34.14116], [-117.93852, 34.14177]]], [[[-117.93154, 34.14925], [-117.93138, 34.14956], [-117.93031, 34.15081], [-117.9302, 34.15095], [-117.9302, 34.15097], [-117.9297, 34.15096], [-117.92984, 34.15081], [-117.93154, 34.14925]]], [[[-117.93088, 34.14369], [-117.92715, 34.14751], [-117.92645, 34.15071], [-117.9232, 34.15069], [-117.91761, 34.15518], [-117.9208, 34.15208], [-117.92326, 34.14947], [-117.92813, 34.14533], [-117.93088, 34.14369]]], [[[-117.92495, 34.15451], [-117.92447, 34.15451], [-117.92446, 34.15494], [-117.92389, 34.15495], [-117.92388, 34.15529], [-117.92338, 34.1553], [-117.92337, 34.15562], [-117.92288, 34.15562], [-117.92287, 34.15569], [-117.92271, 34.1557], [-117.92274, 34.15444], [-117.92495, 34.15443], [-117.92495, 34.15451]]], [[[-117.92224, 34.15624], [-117.92053, 34.15798], [-117.92053, 34.15798], [-117.92058, 34.15624], [-117.92224, 34.15624]]], [[[-117.91608, 34.15641], [-117.9142, 34.15792], [-117.90997, 34.16133], [-117.91028, 34.15932], [-117.91033, 34.15929], [-117.91141, 34.15894], [-117.91249, 34.15851], [-117.91372, 34.15792], [-117.91397, 34.15779], [-117.91492, 34.15723], [-117.9156, 34.15678], [-117.91608, 34.15641]]]]} | Open Access 1 | 7258 | Lario Staging Area | 28955 | 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 | http://parks.lacounty.gov/wps/portal/dpr/Parks/Lario_Staging_Area | Los Angeles 6 | 103.71 | Lario Staging 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 | |
9292 | 9292 | 9291 | {"type": "Polygon", "coordinates": [[[-118.48334, 34.18454], [-118.48156, 34.18453], [-118.48146, 34.18002], [-118.47682, 34.18003], [-118.4768, 34.18277], [-118.47502, 34.18278], [-118.47502, 34.1843], [-118.47497, 34.18431], [-118.47497, 34.18582], [-118.4748, 34.18577], [-118.47414, 34.18547], [-118.47379, 34.18465], [-118.47356, 34.18422], [-118.47335, 34.18389], [-118.47311, 34.18357], [-118.47286, 34.18327], [-118.47009, 34.17951], [-118.47255, 34.17833], [-118.47407, 34.17877], [-118.47488, 34.17867], [-118.47491, 34.17728], [-118.47636, 34.17727], [-118.47652, 34.17755], [-118.47764, 34.17695], [-118.47783, 34.17716], [-118.4782, 34.17745], [-118.47851, 34.17758], [-118.48012, 34.17868], [-118.48017, 34.17865], [-118.48195, 34.17984], [-118.48198, 34.17982], [-118.48274, 34.18035], [-118.48301, 34.18063], [-118.48315, 34.1808], [-118.48328, 34.18103], [-118.48335, 34.1812], [-118.48343, 34.18154], [-118.48344, 34.18362], [-118.48335, 34.18389], [-118.48334, 34.18454]]]} | Open Access 1 | 15480 | Woodley Avenue Park | 27729 | 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 | 119.888 | Woodley Avenue Park | 0 | 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 | |
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 | |
11308 | 11308 | 11307 | {"type": "Polygon", "coordinates": [[[-118.49251, 34.18069], [-118.49246, 34.18527], [-118.49127, 34.18528], [-118.49121, 34.18458], [-118.48812, 34.18462], [-118.4881, 34.18393], [-118.48647, 34.18422], [-118.48458, 34.18493], [-118.48387, 34.18494], [-118.48387, 34.18402], [-118.48384, 34.18401], [-118.48384, 34.1836], [-118.48386, 34.18359], [-118.48386, 34.18109], [-118.48382, 34.18108], [-118.48361, 34.18069], [-118.48363, 34.18068], [-118.48359, 34.17867], [-118.48342, 34.17774], [-118.48337, 34.17516], [-118.48345, 34.17515], [-118.48342, 34.17341], [-118.4925, 34.17711], [-118.49249, 34.18067], [-118.49251, 34.18069]]]} | Restricted Access 2 | 22012 | Woodley Lakes Golf Course | 33077 | 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 | 209.251 | Woodley Lakes GC | 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]);