units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
61 rows where DES_TP = 49 sorted by SUID_NMA descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, LAYER, MNG_AG_ID, PARK_URL, COUNTY, YR_EST
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
16750 | 16750 | 16749 | {"type": "Polygon", "coordinates": [[[-120.80656, 37.78696], [-120.80405, 37.78649], [-120.80405, 37.78871], [-120.80384, 37.78865], [-120.80383, 37.78687], [-120.80275, 37.78665], [-120.80274, 37.78629], [-120.80111, 37.7865], [-120.79955, 37.78698], [-120.79955, 37.78605], [-120.79971, 37.78594], [-120.80213, 37.78523], [-120.80283, 37.78506], [-120.80399, 37.78493], [-120.80505, 37.78492], [-120.8056, 37.78499], [-120.80612, 37.78511], [-120.80655, 37.7853], [-120.80656, 37.78696]]]} | Open Access 1 | 48840 | Valley Oak Recreation Area | 33560 | 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 | https://stanislausriver.com/parks/valley-oak-recration-area/ | Stanislaus 2 | 24.963 | Valley Oak Rec. Area | 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 | |
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 | |
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 | |
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 | |
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 | |
16180 | 16180 | 16179 | {"type": "MultiPolygon", "coordinates": [[[[-117.97757, 34.12178], [-117.9774, 34.12192], [-117.9774, 34.12228], [-117.97719, 34.12242], [-117.9761, 34.12331], [-117.97597, 34.12347], [-117.97592, 34.12364], [-117.97592, 34.12496], [-117.97572, 34.12497], [-117.97572, 34.12361], [-117.97575, 34.12354], [-117.97573, 34.12353], [-117.97033, 34.12796], [-117.96982, 34.1286], [-117.96965, 34.12872], [-117.96884, 34.12872], [-117.96882, 34.13217], [-117.96572, 34.13217], [-117.96003, 34.1322], [-117.96003, 34.13218], [-117.95996, 34.13218], [-117.96081, 34.1308], [-117.9616, 34.12962], [-117.96161, 34.12952], [-117.96156, 34.12944], [-117.96209, 34.12877], [-117.96263, 34.12815], [-117.96318, 34.1276], [-117.96388, 34.12695], [-117.96407, 34.12708], [-117.96439, 34.12694], [-117.96447, 34.12642], [-117.96487, 34.12604], [-117.96506, 34.12602], [-117.96533, 34.12589], [-117.96635, 34.12499], [-117.96642, 34.12485], [-117.9666, 34.1247], [-117.96674, 34.12462], [-117.96994, 34.12141], [-117.97081, 34.12057], [-117.97169, 34.1198], [-117.9724, 34.11927], [-117.97292, 34.11891], [-117.97492, 34.11765], [-117.97707, 34.11638], [-117.97706, 34.1163], [-117.97756, 34.11602], [-117.97757, 34.12178]]], [[[-117.97438, 34.11716], [-117.9726, 34.11814], [-117.9704, 34.11989], [-117.9693, 34.12103], [-117.96627, 34.12393], [-117.96607, 34.12416], [-117.96466, 34.1255], [-117.96411, 34.12566], [-117.96337, 34.12638], [-117.9635, 34.12667], [-117.96095, 34.12911], [-117.96088, 34.12909], [-117.96081, 34.12909], [-117.96069, 34.12915], [-117.95848, 34.13159], [-117.95825, 34.1318], [-117.958, 34.13199], [-117.95766, 34.13221], [-117.95635, 34.13223], [-117.95357, 34.12911], [-117.94874, 34.13115], [-117.94872, 34.13114], [-117.94869, 34.13117], [-117.94872, 34.13114], [-117.95015, 34.13], [-117.95053, 34.12906], [-117.95066, 34.12822], [-117.95091, 34.12769], [-117.95132, 34.12694], [-117.95196, 34.12641], [-117.9525, 34.12614], [-117.95266, 34.1252], [-117.95313, 34.12443], [-117.95388, 34.12367], [-117.95497, 34.12298], [-117.95542, 34.12235], [-117.95639, 34.12138], [-117.95755, 34.12058], [-117.95858, 34.11969], [-117.95943, 34.11891], [-117.9599, 34.11834], [-117.95999, 34.10704], [-117.96089, 34.10702], [-117.9612, 34.10704], [-117.96166, 34.10709], [-117.96227, 34.10722], [-117.96281, 34.10741], [-117.96315, 34.10756], [-117.96341, 34.1077], [-117.96384, 34.10799], [-117.96462, 34.10857], [-117.96743, 34.11078], [-117.96841, 34.11146], [-117.97068, 34.11327], [-117.97102, 34.11352], [-117.97138, 34.11376], [-117.97188, 34.11404], [-117.97216, 34.11418], [-117.97288, 34.1153], [-117.97296, 34.11554], [-117.9731, 34.11575], [-117.97327, 34.11607], [-117.97332, 34.11632], [-117.97332, 34.11662], [-117.97328, 34.1169], [-117.97438, 34.11716]]], [[[-117.95056, 34.13285], [-117.95008, 34.13335], [-117.94879, 34.13434], [-117.94783, 34.1352], [-117.94707, 34.13546], [-117.94578, 34.13636], [-117.94447, 34.13772], [-117.94261, 34.1365], [-117.94298, 34.13616], [-117.94331, 34.13575], [-117.94405, 34.13496], [-117.94468, 34.13451], [-117.9457, 34.13373], [-117.94647, 34.1332], [-117.94681, 34.1329], [-117.94725, 34.13264], [-117.9477, 34.13231], [-117.94819, 34.13192], [-117.95011, 34.13262], [-117.95024, 34.13273], [-117.95056, 34.13285]]]]} | No Public Access 3 | 48161 | Santa Fe Dam Open Space | 32700 | 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 | 950.067 | Santa Fe Dam OS | 0 | Recreation Management Area 49 | 4 | |
15677 | 15677 | 15676 | {"type": "MultiPolygon", "coordinates": [[[[-117.10566, 32.79376], [-117.10471, 32.79491], [-117.10095, 32.79737], [-117.09926, 32.79946], [-117.09919, 32.80154], [-117.09938, 32.80248], [-117.10023, 32.80247], [-117.10057, 32.80525], [-117.09796, 32.8068], [-117.09627, 32.80827], [-117.09628, 32.80812], [-117.09632, 32.80799], [-117.0964, 32.80786], [-117.09665, 32.8076], [-117.09673, 32.80748], [-117.09679, 32.80731], [-117.09688, 32.80696], [-117.09698, 32.80677], [-117.09716, 32.80655], [-117.0972, 32.80644], [-117.09722, 32.80635], [-117.09721, 32.8062], [-117.09717, 32.80608], [-117.09689, 32.8056], [-117.09685, 32.80547], [-117.09686, 32.80531], [-117.09697, 32.8051], [-117.09705, 32.80484], [-117.097, 32.8045], [-117.097, 32.80439], [-117.09705, 32.80422], [-117.09705, 32.80407], [-117.097, 32.80394], [-117.09683, 32.80359], [-117.0968, 32.80341], [-117.09682, 32.80323], [-117.09692, 32.80297], [-117.09692, 32.80282], [-117.09688, 32.80262], [-117.09684, 32.8025], [-117.09599, 32.80251], [-117.09513, 32.8006], [-117.09522, 32.79697], [-117.09603, 32.7952], [-117.10024, 32.79307], [-117.10151, 32.79253], [-117.10383, 32.79159], [-117.10383, 32.7909], [-117.10444, 32.79089], [-117.10491, 32.79081], [-117.10498, 32.79113], [-117.10499, 32.79133], [-117.1049, 32.79146], [-117.10488, 32.79161], [-117.10515, 32.79234], [-117.10517, 32.79254], [-117.10517, 32.79275], [-117.10513, 32.79294], [-117.10508, 32.7931], [-117.105, 32.79328], [-117.10502, 32.79346], [-117.10508, 32.7935], [-117.10522, 32.79349], [-117.10566, 32.79376]]], [[[-117.09604, 32.80847], [-117.09592, 32.80858], [-117.09529, 32.80942], [-117.09358, 32.81096], [-117.09346, 32.8143], [-117.09266, 32.81502], [-117.09264, 32.81504], [-117.09251, 32.81505], [-117.0881, 32.8155], [-117.08204, 32.8097], [-117.08135, 32.80787], [-117.08322, 32.8068], [-117.0853, 32.80616], [-117.09164, 32.80733], [-117.09602, 32.80672], [-117.09604, 32.80847]]]]} | Restricted Access 2 | 12871 | Admiral Baker Golf Course | 31857 | 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 | https://www.golfnow.com/courses/1027561-admiral-baker-golf-course-north-course-details | San Diego 4 | 409.719 | Admiral Baker GC | 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 | |
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 | |
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 | |
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 |
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 | |
16806 | 16806 | 16805 | {"type": "Polygon", "coordinates": [[[-119.29135, 36.90366], [-119.29138, 36.90381], [-119.29133, 36.904], [-119.29126, 36.90411], [-119.29101, 36.904], [-119.29089, 36.90383], [-119.29093, 36.90363], [-119.29103, 36.90354], [-119.29125, 36.90356], [-119.29135, 36.90366]]]} | Open Access 1 | 15864 | Trimmer Recreation Area | 26537 | 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 | Fresno 9 | 0.497 | Trimmer Rec. Area | 0 | Recreation Management Area 49 | 4 | |
16798 | 16798 | 16797 | {"type": "MultiPolygon", "coordinates": [[[[-118.49219, 34.16583], [-118.49217, 34.1668], [-118.49164, 34.16682], [-118.49103, 34.16686], [-118.49066, 34.16691], [-118.49007, 34.16703], [-118.48628, 34.16811], [-118.48623, 34.16809], [-118.4862, 34.16804], [-118.48614, 34.16773], [-118.48616, 34.16765], [-118.48621, 34.16759], [-118.48638, 34.16753], [-118.48656, 34.1675], [-118.48669, 34.16734], [-118.48664, 34.16724], [-118.48663, 34.16717], [-118.48664, 34.16649], [-118.48671, 34.16592], [-118.48644, 34.16594], [-118.48637, 34.16594], [-118.48633, 34.16589], [-118.48632, 34.16583], [-118.4853, 34.16589], [-118.48387, 34.1659], [-118.48378, 34.16592], [-118.48371, 34.16596], [-118.48365, 34.16602], [-118.48359, 34.16616], [-118.48355, 34.16637], [-118.48352, 34.16718], [-118.48357, 34.16755], [-118.48365, 34.16769], [-118.48379, 34.16778], [-118.48396, 34.16783], [-118.48418, 34.16787], [-118.48445, 34.16789], [-118.48478, 34.16788], [-118.48505, 34.16786], [-118.48527, 34.16781], [-118.48549, 34.16774], [-118.48577, 34.16769], [-118.48585, 34.16771], [-118.48591, 34.16777], [-118.48604, 34.16774], [-118.4861, 34.1681], [-118.48608, 34.16815], [-118.48539, 34.16831], [-118.48454, 34.16848], [-118.48317, 34.16855], [-118.48234, 34.16871], [-118.48153, 34.16892], [-118.48072, 34.16915], [-118.48011, 34.16937], [-118.47824, 34.17007], [-118.47799, 34.17019], [-118.47748, 34.16991], [-118.47723, 34.16974], [-118.47676, 34.16938], [-118.47625, 34.16888], [-118.47519, 34.16772], [-118.4749, 34.16752], [-118.47417, 34.16695], [-118.4749, 34.16646], [-118.47541, 34.16617], [-118.47584, 34.16604], [-118.48633, 34.16574], [-118.48745, 34.16569], [-118.48875, 34.16555], [-118.49012, 34.16556], [-118.49219, 34.16583]]], [[[-118.48345, 34.17516], [-118.48337, 34.17517], [-118.48338, 34.17578], [-118.48207, 34.1758], [-118.48074, 34.17439], [-118.48094, 34.17431], [-118.48092, 34.17304], [-118.48123, 34.17251], [-118.48342, 34.17341], [-118.48345, 34.17516]]], [[[-118.51496, 34.18034], [-118.51415, 34.18043], [-118.51364, 34.18056], [-118.51326, 34.18068], [-118.51287, 34.18086], [-118.51212, 34.18131], [-118.51167, 34.18168], [-118.51126, 34.1821], [-118.51093, 34.18251], [-118.51087, 34.1825], [-118.50958, 34.18423], [-118.50958, 34.18425], [-118.50964, 34.18428], [-118.50942, 34.18455], [-118.50917, 34.18481], [-118.50875, 34.18514], [-118.50841, 34.18537], [-118.508, 34.18558], [-118.50769, 34.18572], [-118.5074, 34.18582], [-118.50694, 34.18594], [-118.50663, 34.186], [-118.50616, 34.18606], [-118.50576, 34.18607], [-118.50519, 34.18607], [-118.50518, 34.18587], [-118.50404, 34.18587], [-118.50401, 34.18446], [-118.50136, 34.18445], [-118.50135, 34.18014], [-118.50547, 34.18013], [-118.50548, 34.18034], [-118.51496, 34.18034]]], [[[-118.50984, 34.18648], [-118.50519, 34.18649], [-118.50519, 34.18635], [-118.50602, 34.18634], [-118.50661, 34.18629], [-118.50695, 34.18623], [-118.50727, 34.18615], [-118.50783, 34.18597], [-118.50836, 34.18573], [-118.50863, 34.18558], [-118.50895, 34.18537], [-118.5094, 34.185], [-118.50967, 34.18473], [-118.50984, 34.18454], [-118.50984, 34.18648]]], [[[-118.51833, 34.18299], [-118.51832, 34.1848], [-118.51673, 34.1848], [-118.51624, 34.18478], [-118.51541, 34.1847], [-118.5146, 34.18456], [-118.51381, 34.18436], [-118.51319, 34.18416], [-118.51243, 34.18387], [-118.51089, 34.18323], [-118.51127, 34.1827], [-118.51122, 34.18266], [-118.51129, 34.18255], [-118.51146, 34.18232], [-118.51168, 34.18206], [-118.51205, 34.18171], [-118.5124, 34.18145], [-118.51259, 34.18133], [-118.51313, 34.18104], [-118.51357, 34.18087], [-118.51379, 34.1808], [-118.51441, 34.18066], [-118.51472, 34.18062], [-118.51512, 34.18059], [-118.51581, 34.18059], [-118.51581, 34.18299], [-118.51833, 34.18299]]], [[[-118.51832, 34.18549], [-118.51832, 34.18643], [-118.5183, 34.18646], [-118.51826, 34.18648], [-118.51093, 34.18648], [-118.51091, 34.18402], [-118.51208, 34.18449], [-118.51303, 34.18485], [-118.5137, 34.18506], [-118.51448, 34.18524], [-118.51496, 34.18533], [-118.51558, 34.18542], [-118.51618, 34.18547], [-118.5169, 34.18549], [-118.51832, 34.18549]]]]} | Open Access 1 | 12215 | Sepulveda Basin Recreation Area | 25302 | 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 | 317.265 | Sepulveda Basin Rec. Area | 0 | Recreation Management Area 49 | 4 | |
9903 | 9903 | 9902 | {"type": "Polygon", "coordinates": [[[-120.7739, 37.7927], [-120.77322, 37.79285], [-120.77164, 37.79236], [-120.76957, 37.7921], [-120.76865, 37.79188], [-120.76749, 37.79128], [-120.76755, 37.79123], [-120.76755, 37.79122], [-120.76728, 37.79108], [-120.76722, 37.79113], [-120.767, 37.79101], [-120.76646, 37.79083], [-120.76346, 37.79052], [-120.76278, 37.79031], [-120.7628, 37.79023], [-120.7623, 37.79007], [-120.76196, 37.78989], [-120.76187, 37.78981], [-120.7618, 37.78973], [-120.76168, 37.78963], [-120.76164, 37.78954], [-120.76156, 37.78946], [-120.76149, 37.78928], [-120.76187, 37.78901], [-120.76279, 37.78841], [-120.76306, 37.7888], [-120.76333, 37.78906], [-120.76406, 37.78952], [-120.76436, 37.78977], [-120.76462, 37.79011], [-120.76495, 37.7903], [-120.76532, 37.79038], [-120.76563, 37.79056], [-120.76598, 37.79061], [-120.7663, 37.79063], [-120.76685, 37.79076], [-120.76706, 37.79086], [-120.76727, 37.79091], [-120.76769, 37.79094], [-120.76799, 37.79105], [-120.76824, 37.79119], [-120.76868, 37.79131], [-120.76899, 37.79142], [-120.76932, 37.79152], [-120.76973, 37.79158], [-120.77008, 37.79175], [-120.77082, 37.79188], [-120.77112, 37.79192], [-120.77182, 37.79208], [-120.77211, 37.79209], [-120.77259, 37.7922], [-120.77319, 37.79236], [-120.77374, 37.79233], [-120.7739, 37.7927]]]} | Open Access 1 | 18350 | Orange Blossom Recreation Area | 23150 | 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 | 17.472 | Orange Blossom Rec. Area | 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 | |
9818 | 9818 | 9817 | {"type": "MultiPolygon", "coordinates": [[[[-119.67173, 37.03046], [-119.67173, 37.043], [-119.65891, 37.04324], [-119.65829, 37.04351], [-119.65813, 37.04336], [-119.65793, 37.04313], [-119.65825, 37.04299], [-119.65856, 37.04298], [-119.65876, 37.04266], [-119.65914, 37.04249], [-119.65969, 37.04226], [-119.66001, 37.0421], [-119.6604, 37.04206], [-119.66063, 37.04211], [-119.66095, 37.04197], [-119.66144, 37.04168], [-119.66156, 37.04143], [-119.66131, 37.04131], [-119.66182, 37.04102], [-119.66201, 37.04083], [-119.66225, 37.04054], [-119.66278, 37.04037], [-119.66268, 37.04011], [-119.66268, 37.03977], [-119.6625, 37.03905], [-119.66259, 37.03877], [-119.66257, 37.03823], [-119.66238, 37.03776], [-119.66259, 37.03758], [-119.66261, 37.03713], [-119.66226, 37.03705], [-119.66206, 37.03679], [-119.66177, 37.03637], [-119.66176, 37.03587], [-119.66208, 37.03571], [-119.66237, 37.03538], [-119.66237, 37.03512], [-119.66211, 37.03502], [-119.66181, 37.03461], [-119.66167, 37.03404], [-119.66165, 37.03346], [-119.66176, 37.03277], [-119.66182, 37.03227], [-119.66171, 37.03205], [-119.66178, 37.03204], [-119.66219, 37.03164], [-119.66239, 37.03184], [-119.66269, 37.03224], [-119.66292, 37.03228], [-119.66294, 37.03164], [-119.66301, 37.03111], [-119.66288, 37.03067], [-119.66281, 37.03056], [-119.66284, 37.03038], [-119.67173, 37.03046]]], [[[-119.70792, 37.01064], [-119.70493, 37.01065], [-119.70481, 37.01054], [-119.70439, 37.00982], [-119.70437, 37.00959], [-119.70468, 37.00947], [-119.70476, 37.00933], [-119.70483, 37.00926], [-119.70474, 37.00916], [-119.70472, 37.00866], [-119.70463, 37.0083], [-119.70464, 37.00816], [-119.7047, 37.00807], [-119.70468, 37.00765], [-119.70472, 37.00748], [-119.70473, 37.00756], [-119.70474, 37.00757], [-119.70505, 37.00706], [-119.70635, 37.00643], [-119.70715, 37.00587], [-119.70758, 37.00492], [-119.70762, 37.00437], [-119.70748, 37.00415], [-119.70761, 37.00403], [-119.70781, 37.00394], [-119.70563, 37.00164], [-119.70603, 37.00085], [-119.70613, 37.00078], [-119.70755, 37.00119], [-119.7083, 37.00226], [-119.70855, 37.00343], [-119.70816, 37.00498], [-119.70777, 37.00603], [-119.70795, 37.00654], [-119.70792, 37.01064]]]]} | Open Access 1 | 16758 | 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 | Madera 48 | 353.212 | Millerton Lake SRA | 1957 | 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 |
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]);