units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
29 rows where DES_TP = 49 and MNG_AGENCY = 142
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
MNG_AGENCY 1
- United States Army Corps of Engineers · 9 ✖
DES_TP 1
- Recreation Management Area · 9 ✖
AGNCY_NAME 1 ✖
ACCESS_TYP 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16719 | 16719 | 16718 | {"type": "Polygon", "coordinates": [[[-120.12822, 39.32738], [-120.12819, 39.33002], [-120.12361, 39.33006], [-120.11408, 39.33045], [-120.11176, 39.33049], [-120.11176, 39.33019], [-120.11203, 39.33018], [-120.11194, 39.3272], [-120.10845, 39.32716], [-120.10845, 39.32454], [-120.10937, 39.32454], [-120.10938, 39.32424], [-120.10962, 39.32422], [-120.10961, 39.31629], [-120.12356, 39.31637], [-120.12366, 39.31637], [-120.12367, 39.31634], [-120.12642, 39.31634], [-120.12691, 39.31915], [-120.12758, 39.32318], [-120.12712, 39.32469], [-120.12558, 39.3264], [-120.12556, 39.32736], [-120.12822, 39.32738]]]} | Open Access 1 | 35056 | Martis Creek Lake Recreation Area | 13574 | 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://www.spk.usace.army.mil/Locations/SacramentoDistrictParks/MartisCreekLake.aspx | Nevada 30 | 565.308 | Martis Creek Lake 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 | |
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 |
16770 | 16770 | 16769 | {"type": "Polygon", "coordinates": [[[-120.73227, 37.78935], [-120.73205, 37.79003], [-120.73166, 37.79035], [-120.73108, 37.7907], [-120.7305, 37.79113], [-120.73019, 37.79132], [-120.7301, 37.79127], [-120.72956, 37.79192], [-120.72909, 37.79271], [-120.72888, 37.79387], [-120.72864, 37.79446], [-120.72771, 37.79518], [-120.72674, 37.79679], [-120.72645, 37.79737], [-120.72624, 37.79731], [-120.72646, 37.79704], [-120.72657, 37.79678], [-120.72669, 37.79637], [-120.72674, 37.79631], [-120.72681, 37.79631], [-120.7269, 37.79627], [-120.72699, 37.79605], [-120.72711, 37.79591], [-120.72719, 37.79568], [-120.72751, 37.79517], [-120.72788, 37.79479], [-120.72808, 37.79468], [-120.72816, 37.79453], [-120.72827, 37.79445], [-120.72845, 37.79439], [-120.72864, 37.79417], [-120.72878, 37.79375], [-120.7288, 37.79336], [-120.7286, 37.79303], [-120.7286, 37.79274], [-120.72882, 37.79248], [-120.7289, 37.79217], [-120.72907, 37.79182], [-120.72931, 37.79148], [-120.72949, 37.79131], [-120.72962, 37.79107], [-120.7298, 37.79097], [-120.73005, 37.79063], [-120.73065, 37.79035], [-120.731, 37.79008], [-120.73128, 37.7895], [-120.73148, 37.78893], [-120.73204, 37.78857], [-120.73209, 37.78884], [-120.73227, 37.78935]]]} | Open Access 1 | 44371 | Honolulu Bar Recreation Area | 20069 | 100 | United States Army Corps of Engineers 146 | Federal 1 | Federal Agency 1 | http://www.usace.army.mil/ | Other Federal 13 | 100 | United States Army Corps of Engineers 142 | Federal 1 | Federal Agency 1 | Stanislaus 2 | 10.135 | Honolulu Bar Rec. Area | 0 | Recreation Management Area 49 | 4 | |
16797 | 16797 | 16796 | {"type": "MultiPolygon", "coordinates": [[[[-118.05402, 34.02209], [-118.0539, 34.02251], [-118.05406, 34.02414], [-118.05374, 34.02676], [-118.05359, 34.02655], [-118.0539, 34.02413], [-118.05374, 34.02249], [-118.05387, 34.02199], [-118.05402, 34.02209]]], [[[-118.06645, 34.02795], [-118.06588, 34.02795], [-118.06548, 34.028], [-118.06433, 34.02827], [-118.06371, 34.0284], [-118.06372, 34.02848], [-118.05616, 34.03013], [-118.0555, 34.02794], [-118.05596, 34.02781], [-118.05777, 34.02462], [-118.06645, 34.02795]]], [[[-118.05596, 34.03018], [-118.05532, 34.03032], [-118.04908, 34.03271], [-118.04849, 34.03306], [-118.04764, 34.03315], [-118.04737, 34.03326], [-118.04657, 34.03331], [-118.04628, 34.0334], [-118.04572, 34.03366], [-118.04549, 34.03408], [-118.04531, 34.03431], [-118.04516, 34.03464], [-118.04512, 34.0346], [-118.04507, 34.03473], [-118.04468, 34.03498], [-118.04479, 34.03512], [-118.04445, 34.03526], [-118.04417, 34.03535], [-118.04378, 34.03546], [-118.04321, 34.03558], [-118.04316, 34.03557], [-118.0429, 34.03562], [-118.03852, 34.03492], [-118.0386, 34.03484], [-118.03851, 34.03482], [-118.03796, 34.03264], [-118.03914, 34.03213], [-118.03928, 34.03149], [-118.03873, 34.03116], [-118.03981, 34.03034], [-118.04001, 34.03024], [-118.04024, 34.02976], [-118.04167, 34.02643], [-118.04147, 34.02622], [-118.03864, 34.0279], [-118.03838, 34.02769], [-118.03849, 34.02753], [-118.03894, 34.02703], [-118.03938, 34.02663], [-118.03979, 34.02633], [-118.05038, 34.01976], [-118.05072, 34.01999], [-118.04752, 34.02329], [-118.04752, 34.0233], [-118.04758, 34.02333], [-118.05079, 34.02002], [-118.05196, 34.02082], [-118.05199, 34.02078], [-118.05203, 34.02081], [-118.05007, 34.02476], [-118.04821, 34.02456], [-118.04737, 34.02485], [-118.04625, 34.02556], [-118.04748, 34.02646], [-118.04699, 34.02759], [-118.04685, 34.02879], [-118.04652, 34.02966], [-118.04532, 34.02934], [-118.0428, 34.02882], [-118.04211, 34.02901], [-118.0421, 34.02902], [-118.04655, 34.03016], [-118.05065, 34.02813], [-118.05026, 34.02844], [-118.05022, 34.02846], [-118.05021, 34.02848], [-118.0521, 34.02755], [-118.05257, 34.02757], [-118.05411, 34.02797], [-118.05442, 34.02787], [-118.05596, 34.03018]], [[-118.05003, 34.0286], [-118.05002, 34.02859], [-118.04657, 34.03031], [-118.04659, 34.03031], [-118.04864, 34.02942], [-118.04928, 34.02908], [-118.04978, 34.02878], [-118.05003, 34.0286]]], [[[-118.04883, 34.03618], [-118.0483, 34.03661], [-118.04785, 34.03623], [-118.04787, 34.03619], [-118.04833, 34.03581], [-118.04836, 34.0358], [-118.04839, 34.03581], [-118.04883, 34.03618]]], [[[-118.05519, 34.03705], [-118.05449, 34.03586], [-118.05315, 34.03639], [-118.05257, 34.03592], [-118.05387, 34.03483], [-118.05397, 34.03483], [-118.05399, 34.03485], [-118.05509, 34.03676], [-118.05516, 34.03694], [-118.05519, 34.03705]]], [[[-118.05386, 34.03454], [-118.05385, 34.03462], [-118.05161, 34.03649], [-118.05028, 34.0376], [-118.05022, 34.03756], [-118.04988, 34.03784], [-118.0498, 34.03785], [-118.04976, 34.03783], [-118.04954, 34.03765], [-118.0498, 34.03744], [-118.04979, 34.03741], [-118.05012, 34.03712], [-118.04982, 34.03688], [-118.04993, 34.03677], [-118.04982, 34.03668], [-118.04971, 34.03678], [-118.04891, 34.03612], [-118.04886, 34.03614], [-118.04833, 34.0357], [-118.04605, 34.03756], [-118.04533, 34.03695], [-118.04538, 34.03615], [-118.04578, 34.03583], [-118.04611, 34.03525], [-118.04734, 34.03428], [-118.04742, 34.0341], [-118.04722, 34.03394], [-118.04916, 34.03282], [-118.05224, 34.03165], [-118.05231, 34.03165], [-118.05235, 34.03167], [-118.05386, 34.03454]]], [[[-118.05498, 34.03783], [-118.05482, 34.03799], [-118.05473, 34.03805], [-118.05413, 34.03839], [-118.05395, 34.03842], [-118.05343, 34.03867], [-118.0521, 34.03917], [-118.05175, 34.03927], [-118.05144, 34.03931], [-118.05118, 34.03931], [-118.05101, 34.03929], [-118.04911, 34.03897], [-118.04907, 34.03896], [-118.04897, 34.03888], [-118.05093, 34.03727], [-118.05194, 34.03903], [-118.05498, 34.03783]]], [[[-118.06772, 34.02863], [-118.06553, 34.03222], [-118.06524, 34.03271], [-118.06504, 34.03309], [-118.06482, 34.03357], [-118.06453, 34.03432], [-118.06426, 34.03531], [-118.0641, 34.03625], [-118.06407, 34.03664], [-118.06404, 34.03717], [-118.06404, 34.0386], [-118.0639, 34.03951], [-118.06379, 34.0401], [-118.06376, 34.04021], [-118.06365, 34.04042], [-118.06347, 34.0406], [-118.06332, 34.0407], [-118.06312, 34.04079], [-118.05983, 34.04081], [-118.05982, 34.04083], [-118.05892, 34.04071], [-118.05711, 34.04035], [-118.05514, 34.03984], [-118.05498, 34.03976], [-118.05484, 34.03966], [-118.0542, 34.03889], [-118.05417, 34.03883], [-118.05416, 34.03875], [-118.05417, 34.0387], [-118.05421, 34.03863], [-118.05425, 34.03859], [-118.05477, 34.03831], [-118.05496, 34.03818], [-118.05508, 34.03808], [-118.05523, 34.03791], [-118.05537, 34.03767], [-118.0555, 34.03762], [-118.05545, 34.03752], [-118.05548, 34.03743], [-118.0555, 34.03727], [-118.05548, 34.03697], [-118.05546, 34.03694], [-118.05544, 34.03695], [-118.05538, 34.03677], [-118.05532, 34.03666], [-118.05381, 34.03402], [-118.05253, 34.03161], [-118.05253, 34.03156], [-118.05257, 34.03152], [-118.05537, 34.03045], [-118.05888, 34.0297], [-118.05938, 34.03127], [-118.06148, 34.03082], [-118.06086, 34.02942], [-118.06066, 34.02931], [-118.06539, 34.02828], [-118.06585, 34.02821], [-118.06632, 34.02821], [-118.06683, 34.02827], [-118.06708, 34.02833], [-118.06737, 34.02843], [-118.0677, 34.02856], [-118.06772, 34.02863]]], [[[-118.07729, 34.03806], [-118.07696, 34.03889], [-118.07675, 34.03909], [-118.07651, 34.03964], [-118.07664, 34.04006], [-118.07629, 34.0402], [-118.07629, 34.04027], [-118.07519, 34.04038], [-118.0752, 34.03728], [-118.07517, 34.03727], [-118.07515, 34.04039], [-118.07475, 34.04043], [-118.07276, 34.04082], [-118.07232, 34.04088], [-118.07158, 34.04094], [-118.07085, 34.04097], [-118.06829, 34.04098], [-118.06704, 34.04086], [-118.0665, 34.04072], [-118.06638, 34.04064], [-118.06581, 34.04024], [-118.06563, 34.04012], [-118.06542, 34.03995], [-118.0648, 34.03936], [-118.06472, 34.03926], [-118.06466, 34.03916], [-118.06459, 34.03893], [-118.06447, 34.0378], [-118.06447, 34.03718], [-118.06451, 34.03656], [-118.06456, 34.03611], [-118.06462, 34.03573], [-118.06474, 34.03516], [-118.0649, 34.0346], [-118.06508, 34.03406], [-118.06531, 34.03353], [-118.06528, 34.03351], [-118.06544, 34.03315], [-118.06578, 34.03252], [-118.06812, 34.02871], [-118.06893, 34.02902], [-118.06893, 34.02904], [-118.07043, 34.02962], [-118.07117, 34.0297], [-118.07111, 34.02989], [-118.07111, 34.03012], [-118.0715, 34.03143], [-118.07255, 34.03267], [-118.07268, 34.03288], [-118.07297, 34.03322], [-118.0733, 34.03372], [-118.07333, 34.03374], [-118.07334, 34.03373], [-118.073, 34.0332], [-118.07272, 34.03287], [-118.07258, 34.03265], [-118.07153, 34.03142], [-118.07114, 34.03012], [-118.07114, 34.0299], [-118.0712, 34.02971], [-118.07206, 34.02981], [-118.07219, 34.02985], [-118.07235, 34.02996], [-118.07241, 34.03002], [-118.07365, 34.03196], [-118.07644, 34.03454], [-118.07616, 34.03475], [-118.07474, 34.03333], [-118.07411, 34.03319], [-118.07334, 34.03296], [-118.07376, 34.03377], [-118.07459, 34.03493], [-118.07519, 34.03549], [-118.07657, 34.03712], [-118.07729, 34.03806]]], [[[-118.06408, 34.05075], [-118.06217, 34.05076], [-118.06217, 34.0503], [-118.06108, 34.05031], [-118.06108, 34.04717], [-118.06064, 34.04717], [-118.06064, 34.04679], [-118.06008, 34.04679], [-118.06008, 34.0453], [-118.0578, 34.0453], [-118.0578, 34.04457], [-118.05678, 34.04457], [-118.05677, 34.04324], [-118.05572, 34.04323], [-118.05571, 34.04183], [-118.05343, 34.04183], [-118.05343, 34.04095], [-118.05319, 34.04094], [-118.05209, 34.04184], [-118.052, 34.04186], [-118.05186, 34.04192], [-118.05192, 34.04185], [-118.05066, 34.04079], [-118.05069, 34.0407], [-118.05147, 34.04051], [-118.0519, 34.04044], [-118.05234, 34.0404], [-118.05288, 34.04039], [-118.0536, 34.04043], [-118.05772, 34.04108], [-118.06079, 34.04163], [-118.06182, 34.04176], [-118.06204, 34.04182], [-118.06231, 34.04195], [-118.06249, 34.04209], [-118.06367, 34.04336], [-118.06383, 34.04359], [-118.06391, 34.04383], [-118.06405, 34.04532], [-118.06408, 34.05075]]], [[[-118.07312, 34.04139], [-118.07307, 34.05168], [-118.07298, 34.05169], [-118.07297, 34.05171], [-118.06882, 34.05172], [-118.0688, 34.05169], [-118.06863, 34.0517], [-118.06862, 34.05172], [-118.06758, 34.05172], [-118.06757, 34.0511], [-118.06694, 34.05109], [-118.06694, 34.05085], [-118.06653, 34.05086], [-118.06654, 34.05154], [-118.06505, 34.05155], [-118.06505, 34.05055], [-118.06452, 34.05055], [-118.0645, 34.04395], [-118.06472, 34.04246], [-118.06478, 34.0423], [-118.06488, 34.04212], [-118.06498, 34.04201], [-118.06524, 34.04187], [-118.06547, 34.04177], [-118.06547, 34.04273], [-118.06564, 34.04274], [-118.06563, 34.04172], [-118.06581, 34.04168], [-118.06595, 34.04166], [-118.06858, 34.04159], [-118.07111, 34.04155], [-118.07199, 34.04149], [-118.07312, 34.04139]]], [[[-118.073, 34.05543], [-118.07224, 34.05542], [-118.07247, 34.05362], [-118.07242, 34.05188], [-118.07299, 34.05187], [-118.073, 34.05543]]], [[[-118.07237, 34.05188], [-118.07241, 34.05362], [-118.0722, 34.05541], [-118.07222, 34.05543], [-118.07195, 34.05724], [-118.07026, 34.05725], [-118.07035, 34.0567], [-118.06988, 34.05362], [-118.06958, 34.0531], [-118.06922, 34.05275], [-118.06882, 34.05275], [-118.06882, 34.05188], [-118.07237, 34.05188]]]]} | Open Access 1 | 6567 | Whittier Narrows Recreation Area | 13602 | 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://www.lamountains.com/parks.asp?parkid=661 | Los Angeles 6 | 1418.873 | Whittier Narrows 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 | |
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 | |
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 | |
16830 | 16830 | 16829 | {"type": "MultiPolygon", "coordinates": [[[[-119.94779, 37.25909], [-119.94775, 37.26382], [-119.94675, 37.26382], [-119.94674, 37.26483], [-119.94503, 37.26985], [-119.94097, 37.27313], [-119.94097, 37.27204], [-119.94087, 37.27203], [-119.94306, 37.26793], [-119.94208, 37.26436], [-119.94209, 37.26357], [-119.94315, 37.26357], [-119.94317, 37.2608], [-119.94466, 37.26018], [-119.94779, 37.25909]]], [[[-119.99489, 37.21396], [-119.99318, 37.2153], [-119.9937, 37.21564], [-119.99236, 37.21649], [-119.99222, 37.21684], [-119.99187, 37.21731], [-119.9913, 37.2177], [-119.99099, 37.21789], [-119.9909, 37.21838], [-119.99253, 37.22083], [-119.9918, 37.22084], [-119.99257, 37.22295], [-119.99243, 37.22356], [-119.99144, 37.22427], [-119.99121, 37.22454], [-119.99103, 37.2248], [-119.9907, 37.22633], [-119.9887, 37.22794], [-119.98861, 37.22798], [-119.9886, 37.23384], [-119.98853, 37.23386], [-119.98854, 37.23482], [-119.98821, 37.23507], [-119.97283, 37.24749], [-119.97278, 37.24744], [-119.97177, 37.24826], [-119.96593, 37.2482], [-119.96589, 37.24454], [-119.96377, 37.24454], [-119.96375, 37.2453], [-119.96138, 37.24534], [-119.96132, 37.24559], [-119.96135, 37.24559], [-119.96128, 37.24649], [-119.95538, 37.24648], [-119.95529, 37.24817], [-119.95206, 37.24814], [-119.95204, 37.24899], [-119.95, 37.24901], [-119.94997, 37.25445], [-119.95105, 37.25449], [-119.95106, 37.25626], [-119.94781, 37.25634], [-119.94779, 37.25891], [-119.94457, 37.26003], [-119.94317, 37.26061], [-119.94319, 37.25893], [-119.94266, 37.25893], [-119.94269, 37.25704], [-119.9432, 37.25704], [-119.94328, 37.24635], [-119.94775, 37.24641], [-119.94769, 37.24539], [-119.95098, 37.24542], [-119.951, 37.24457], [-119.95211, 37.24453], [-119.95216, 37.24259], [-119.95324, 37.24259], [-119.96301, 37.23349], [-119.96293, 37.22461], [-119.96158, 37.22456], [-119.96156, 37.21384], [-119.96165, 37.21383], [-119.96164, 37.20629], [-119.97387, 37.20627], [-119.97391, 37.2043], [-119.97962, 37.20427], [-119.97962, 37.20464], [-119.9803, 37.20465], [-119.98033, 37.20694], [-119.97963, 37.20695], [-119.97963, 37.20901], [-119.97984, 37.20938], [-119.98042, 37.20981], [-119.98113, 37.21004], [-119.98154, 37.21039], [-119.98192, 37.21082], [-119.98235, 37.21166], [-119.98252, 37.21206], [-119.98306, 37.21247], [-119.98353, 37.21254], [-119.98392, 37.21254], [-119.98448, 37.21241], [-119.986, 37.21198], [-119.9863, 37.21232], [-119.9857, 37.21268], [-119.9857, 37.21269], [-119.98621, 37.21304], [-119.98642, 37.21306], [-119.98711, 37.2134], [-119.98813, 37.21293], [-119.98936, 37.21197], [-119.98967, 37.21182], [-119.98995, 37.21178], [-119.99029, 37.21194], [-119.99038, 37.21207], [-119.9904, 37.21208], [-119.99081, 37.21297], [-119.99085, 37.21324], [-119.99118, 37.2137], [-119.99101, 37.21462], [-119.99168, 37.21469], [-119.99219, 37.2148], [-119.99306, 37.21425], [-119.99361, 37.21388], [-119.99396, 37.21354], [-119.99404, 37.21342], [-119.9943, 37.21342], [-119.99484, 37.21368], [-119.99489, 37.21396]], [[-119.95362, 37.24704], [-119.95362, 37.24702], [-119.95303, 37.247], [-119.95301, 37.24705], [-119.95362, 37.24704]]]]} | Open Access 1 | 44416 | Eastman Lake Recreation Area | 13556 | 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://www.spk.usace.army.mil/Locations/SacramentoDistrictParks/EastmanLake.aspx | Madera 48 | 2968.721 | Eastman Lake Rec. Area | 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]);