units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
26 rows where DES_TP = 82 sorted by MNG_AG_ID
This data as json, copyable, CSV (advanced)
Link | rowid | id | map | ACCESS_TYP | UNIT_ID | UNIT_NAME | SUID_NMA | AGNCY_ID | AGNCY_NAME | AGNCY_LEV | AGNCY_TYP | AGNCY_WEB | LAYER | MNG_AG_ID ▼ | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | PARK_URL | COUNTY | ACRES | LABEL_NAME | YR_EST | DES_TP | GAP_STS |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9457 | 9457 | 9456 | {"type": "MultiPolygon", "coordinates": [[[[-119.72944, 34.45213], [-119.72942, 34.45219], [-119.72901, 34.45218], [-119.72857, 34.4527], [-119.72858, 34.45271], [-119.72912, 34.45273], [-119.72883, 34.45333], [-119.72897, 34.45366], [-119.72866, 34.45405], [-119.72831, 34.45457], [-119.72824, 34.45469], [-119.72822, 34.45503], [-119.72818, 34.45524], [-119.72804, 34.45538], [-119.72768, 34.45558], [-119.7276, 34.45564], [-119.72752, 34.45573], [-119.72743, 34.45594], [-119.72732, 34.45647], [-119.72719, 34.45676], [-119.72672, 34.4575], [-119.72602, 34.45853], [-119.72589, 34.45869], [-119.72583, 34.45875], [-119.72567, 34.45885], [-119.7255, 34.45892], [-119.72532, 34.45894], [-119.72514, 34.45893], [-119.72496, 34.45887], [-119.72489, 34.45882], [-119.72483, 34.45875], [-119.72466, 34.4585], [-119.72458, 34.45842], [-119.72447, 34.45835], [-119.72436, 34.4583], [-119.72412, 34.45825], [-119.72343, 34.45832], [-119.72235, 34.45839], [-119.72181, 34.45862], [-119.72159, 34.45739], [-119.72133, 34.45486], [-119.72324, 34.45416], [-119.72325, 34.45395], [-119.72775, 34.45265], [-119.72822, 34.4527], [-119.72821, 34.45247], [-119.72808, 34.45176], [-119.72869, 34.45118], [-119.72944, 34.45213]]], [[[-119.72632, 34.45843], [-119.72606, 34.45898], [-119.72536, 34.45924], [-119.72478, 34.4591], [-119.72397, 34.45854], [-119.72322, 34.45856], [-119.72321, 34.45884], [-119.72314, 34.45884], [-119.72314, 34.45888], [-119.72257, 34.45882], [-119.72188, 34.45884], [-119.72188, 34.45878], [-119.7224, 34.45854], [-119.72251, 34.45852], [-119.72335, 34.45849], [-119.72411, 34.45842], [-119.72428, 34.45845], [-119.72444, 34.45854], [-119.7245, 34.4586], [-119.72466, 34.45885], [-119.72484, 34.459], [-119.72515, 34.4591], [-119.72533, 34.45912], [-119.72546, 34.4591], [-119.72567, 34.45904], [-119.72588, 34.45893], [-119.72605, 34.4588], [-119.72632, 34.45843]]], [[[-119.73094, 34.45454], [-119.73033, 34.4557], [-119.72912, 34.45712], [-119.7276, 34.45752], [-119.72687, 34.4575], [-119.72725, 34.45691], [-119.72737, 34.4567], [-119.72745, 34.45649], [-119.72759, 34.45587], [-119.72767, 34.45574], [-119.72777, 34.45565], [-119.72804, 34.45552], [-119.72818, 34.45542], [-119.72839, 34.45531], [-119.7287, 34.45521], [-119.72882, 34.45538], [-119.72897, 34.45553], [-119.72888, 34.45567], [-119.72908, 34.45568], [-119.72918, 34.45555], [-119.72896, 34.45534], [-119.72861, 34.45471], [-119.72859, 34.45455], [-119.72879, 34.45422], [-119.73094, 34.45454]]]]} | Open Access 1 | 17296 | Lauro Canyon Reservoir | 33318 | 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 | Santa Barbara 7 | 97.858 | Lauro Canyon Reservoir | 0 | Resource Management Area 82 | 3 | |
14887 | 14887 | 14886 | {"type": "MultiPolygon", "coordinates": [[[[-115.84467, 33.44136], [-115.84378, 33.44134], [-115.84249, 33.44141], [-115.84235, 33.43774], [-115.83853, 33.43771], [-115.83832, 33.43152], [-115.8344, 33.43151], [-115.83435, 33.4269], [-115.8523, 33.42677], [-115.85247, 33.42767], [-115.85237, 33.43948], [-115.85237, 33.44124], [-115.86815, 33.44098], [-115.86949, 33.44092], [-115.8695, 33.44116], [-115.87012, 33.44116], [-115.87012, 33.45559], [-115.88728, 33.45568], [-115.8871, 33.46767], [-115.88724, 33.47011], [-115.88471, 33.47014], [-115.88271, 33.46908], [-115.88261, 33.46664], [-115.87832, 33.4667], [-115.87833, 33.46522], [-115.8784, 33.46311], [-115.87517, 33.46304], [-115.86993, 33.4594], [-115.87011, 33.45559], [-115.8638, 33.45578], [-115.85927, 33.45337], [-115.85227, 33.45336], [-115.85221, 33.44921], [-115.85218, 33.44525], [-115.85209, 33.44125], [-115.84467, 33.44136]]], [[[-115.90481, 33.48469], [-115.90028, 33.48473], [-115.89998, 33.48472], [-115.89915, 33.48471], [-115.89558, 33.48097], [-115.89542, 33.47805], [-115.89149, 33.47779], [-115.89145, 33.47414], [-115.88874, 33.47413], [-115.88731, 33.47291], [-115.88727, 33.47025], [-115.90459, 33.47015], [-115.90454, 33.48114], [-115.90481, 33.48469]]]]} | Open Access 1 | 45425 | Salton Sea | 28206 | 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 | Riverside 10 | 1996.182 | Salton Sea | 0 | Resource Management Area 82 | 3 | |
15539 | 15539 | 15538 | {"type": "Polygon", "coordinates": [[[-121.45281, 36.81548], [-121.44951, 36.81827], [-121.45206, 36.82029], [-121.45168, 36.82097], [-121.44825, 36.82238], [-121.44786, 36.82617], [-121.44667, 36.82857], [-121.45008, 36.82903], [-121.44932, 36.83003], [-121.44877, 36.83058], [-121.44768, 36.83141], [-121.44442, 36.83059], [-121.44261, 36.8296], [-121.44256, 36.82816], [-121.4406, 36.82749], [-121.4363, 36.82466], [-121.43536, 36.82021], [-121.43324, 36.81847], [-121.43417, 36.81602], [-121.43598, 36.81561], [-121.43922, 36.81527], [-121.44188, 36.81378], [-121.44228, 36.81358], [-121.44972, 36.81478], [-121.44982, 36.8147], [-121.45066, 36.8154], [-121.45255, 36.81527], [-121.45281, 36.81548]], [[-121.44867, 36.81812], [-121.4488, 36.818], [-121.4488, 36.81777], [-121.44678, 36.81613], [-121.44618, 36.81566], [-121.44504, 36.81584], [-121.44509, 36.81601], [-121.44509, 36.8161], [-121.44517, 36.81636], [-121.44515, 36.81653], [-121.44509, 36.8166], [-121.44485, 36.81675], [-121.44454, 36.81683], [-121.44435, 36.81683], [-121.44423, 36.81677], [-121.44376, 36.81639], [-121.4437, 36.81632], [-121.44361, 36.81629], [-121.44356, 36.8163], [-121.44353, 36.81634], [-121.44351, 36.81652], [-121.44342, 36.81666], [-121.44324, 36.81675], [-121.44303, 36.81678], [-121.44242, 36.81655], [-121.44233, 36.81666], [-121.44235, 36.81682], [-121.44242, 36.81706], [-121.44241, 36.81722], [-121.44226, 36.81734], [-121.44215, 36.81739], [-121.44167, 36.81747], [-121.44133, 36.81742], [-121.44115, 36.81742], [-121.44066, 36.81751], [-121.44039, 36.81766], [-121.44015, 36.81767], [-121.43983, 36.81759], [-121.43977, 36.81754], [-121.43972, 36.81756], [-121.43966, 36.81752], [-121.43964, 36.81741], [-121.4397, 36.81735], [-121.43972, 36.81729], [-121.43982, 36.81713], [-121.43959, 36.81694], [-121.43947, 36.81681], [-121.43939, 36.81667], [-121.43936, 36.81656], [-121.43936, 36.81627], [-121.4392, 36.81615], [-121.43915, 36.81605], [-121.43915, 36.816], [-121.43908, 36.81594], [-121.43896, 36.81591], [-121.43887, 36.81595], [-121.43885, 36.81602], [-121.43891, 36.8161], [-121.43892, 36.81614], [-121.43885, 36.8162], [-121.43885, 36.81625], [-121.43889, 36.81634], [-121.43889, 36.81647], [-121.43886, 36.81653], [-121.43878, 36.8166], [-121.43872, 36.81662], [-121.43863, 36.8166], [-121.43856, 36.81661], [-121.43857, 36.81666], [-121.43854, 36.81673], [-121.43846, 36.81676], [-121.43837, 36.81673], [-121.43814, 36.81682], [-121.43793, 36.81681], [-121.4377, 36.81668], [-121.43765, 36.81655], [-121.43763, 36.81646], [-121.43764, 36.81629], [-121.43746, 36.81642], [-121.43736, 36.81641], [-121.43727, 36.8163], [-121.43716, 36.81628], [-121.43655, 36.81658], [-121.43637, 36.8167], [-121.43628, 36.81672], [-121.43618, 36.81672], [-121.43609, 36.8167], [-121.43598, 36.81666], [-121.43583, 36.81657], [-121.43555, 36.81646], [-121.43518, 36.81661], [-121.43501, 36.81677], [-121.43496, 36.81684], [-121.43499, 36.81693], [-121.435, 36.81714], [-121.43499, 36.81722], [-121.43485, 36.81746], [-121.43457, 36.81777], [-121.43435, 36.81797], [-121.43398, 36.81821], [-121.43385, 36.81834], [-121.43383, 36.81844], [-121.43394, 36.81849], [-121.43409, 36.81845], [-121.43415, 36.81845], [-121.4342, 36.81847], [-121.43423, 36.81853], [-121.4343, 36.81876], [-121.43435, 36.81869], [-121.43439, 36.81852], [-121.43449, 36.81846], [-121.43469, 36.81839], [-121.43501, 36.81833], [-121.43523, 36.81832], [-121.43536, 36.8183], [-121.43546, 36.8183], [-121.43553, 36.81834], [-121.43578, 36.81853], [-121.436, 36.81867], [-121.43613, 36.81874], [-121.4363, 36.81879], [-121.43639, 36.81878], [-121.43646, 36.81871], [-121.43657, 36.81836], [-121.4366, 36.81822], [-121.43669, 36.81818], [-121.43691, 36.81824], [-121.43701, 36.8183], [-121.43767, 36.8188], [-121.43778, 36.81892], [-121.43786, 36.81905], [-121.4379, 36.81919], [-121.43787, 36.81925], [-121.43769, 36.81945], [-121.43736, 36.81956], [-121.43732, 36.81962], [-121.43737, 36.81974], [-121.43745, 36.81986], [-121.43746, 36.82], [-121.43757, 36.82027], [-121.43773, 36.82038], [-121.43841, 36.8204], [-121.43853, 36.82022], [-121.43874, 36.8201], [-121.43897, 36.82], [-121.43915, 36.81998], [-121.43923, 36.81991], [-121.43929, 36.81978], [-121.43944, 36.81963], [-121.43953, 36.81957], [-121.43974, 36.81958], [-121.44037, 36.81974], [-121.4407, 36.8198], [-121.44076, 36.81995], [-121.44096, 36.82018], [-121.44143, 36.82046], [-121.44153, 36.8206], [-121.44153, 36.82073], [-121.44141, 36.82087], [-121.44112, 36.82098], [-121.44082, 36.82111], [-121.44061, 36.82123], [-121.44023, 36.82126], [-121.43986, 36.82141], [-121.4396, 36.82142], [-121.43923, 36.82131], [-121.43894, 36.82128], [-121.43885, 36.82131], [-121.43857, 36.82123], [-121.43772, 36.82093], [-121.43755, 36.82079], [-121.43742, 36.82074], [-121.43726, 36.82076], [-121.43689, 36.821], [-121.43626, 36.82113], [-121.43608, 36.8212], [-121.43609, 36.82128], [-121.43626, 36.82134], [-121.43648, 36.82137], [-121.43663, 36.82147], [-121.43699, 36.82159], [-121.43718, 36.82169], [-121.43722, 36.82184], [-121.4372, 36.82197], [-121.4372, 36.82211], [-121.43735, 36.82211], [-121.43753, 36.82214], [-121.43803, 36.82239], [-121.43814, 36.8225], [-121.43816, 36.82261], [-121.43785, 36.82289], [-121.43772, 36.82312], [-121.43767, 36.82319], [-121.43767, 36.82329], [-121.43776, 36.8234], [-121.43786, 36.82347], [-121.43799, 36.82344], [-121.43812, 36.82337], [-121.43836, 36.82328], [-121.43857, 36.82324], [-121.43864, 36.82324], [-121.4387, 36.82327], [-121.43879, 36.82337], [-121.43902, 36.82371], [-121.43905, 36.82397], [-121.43905, 36.82403], [-121.43908, 36.8241], [-121.43914, 36.82414], [-121.43927, 36.82409], [-121.43966, 36.82409], [-121.43972, 36.82407], [-121.43979, 36.824], [-121.44082, 36.82373], [-121.44091, 36.82373], [-121.44104, 36.82378], [-121.44121, 36.82392], [-121.44146, 36.82409], [-121.44159, 36.82421], [-121.44173, 36.82429], [-121.44185, 36.82428], [-121.44208, 36.82423], [-121.44223, 36.82418], [-121.44235, 36.82413], [-121.44244, 36.82403], [-121.4425, 36.82393], [-121.44259, 36.82393], [-121.44289, 36.82454], [-121.44263, 36.825], [-121.44263, 36.82513], [-121.44265, 36.82519], [-121.44282, 36.82546], [-121.44278, 36.82567], [-121.44256, 36.82588], [-121.44242, 36.82597], [-121.44238, 36.82611], [-121.4425, 36.82615], [-121.44275, 36.8262], [-121.44295, 36.82632], [-121.44295, 36.82639], [-121.44293, 36.82651], [-121.44278, 36.82682], [-121.44266, 36.82702], [-121.44266, 36.82708], [-121.44302, 36.8271], [-121.44443, 36.82707], [-121.44666, 36.82701], [-121.44655, 36.82691], [-121.44656, 36.8267], [-121.4466, 36.82652], [-121.44661, 36.8262], [-121.44652, 36.82611], [-121.44642, 36.82604], [-121.44635, 36.82594], [-121.44615, 36.82549], [-121.44609, 36.82527], [-121.44607, 36.82512], [-121.44611, 36.82499], [-121.44609, 36.82486], [-121.44608, 36.82456], [-121.44612, 36.82449], [-121.44619, 36.82445], [-121.44628, 36.82444], [-121.4466, 36.82445], [-121.44688, 36.82443], [-121.44697, 36.82437], [-121.44699, 36.82425], [-121.44692, 36.82416], [-121.44685, 36.82402], [-121.44679, 36.82378], [-121.44673, 36.82365], [-121.44663, 36.82353], [-121.4466, 36.82343], [-121.44656, 36.82324], [-121.44649, 36.82309], [-121.44637, 36.82298], [-121.44634, 36.82277], [-121.44628, 36.82257], [-121.44614, 36.82242], [-121.44578, 36.82214], [-121.44571, 36.82207], [-121.44565, 36.82199], [-121.44562, 36.8218], [-121.44566, 36.82172], [-121.44571, 36.82155], [-121.44578, 36.82137], [-121.44585, 36.82124], [-121.44598, 36.82103], [-121.44602, 36.82099], [-121.44608, 36.82096], [-121.44631, 36.82091], [-121.44636, 36.82096], [-121.44644, 36.82096], [-121.44672, 36.82106], [-121.44734, 36.82137], [-121.44757, 36.82144], [-121.44782, 36.82142], [-121.44801, 36.82134], [-121.44825, 36.82131], [-121.44842, 36.82118], [-121.44852, 36.82108], [-121.44842, 36.821], [-121.44839, 36.82094], [-121.44837, 36.8208], [-121.4484, 36.82073], [-121.44868, 36.82059], [-121.44876, 36.82057], [-121.44883, 36.82049], [-121.44879, 36.82044], [-121.44847, 36.8202], [-121.44839, 36.82007], [-121.44837, 36.81967], [-121.44833, 36.81947], [-121.44829, 36.81938], [-121.4482, 36.81928], [-121.44819, 36.81921], [-121.44821, 36.819], [-121.44819, 36.81872], [-121.44851, 36.81842], [-121.44867, 36.81824], [-121.44867, 36.81812]]]} | No Public Access 3 | 48968 | San Justo Reservoir | 33666 | 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 | https://www.cosb.us/county-departments/public-works/parks-recreation/regional-parks/san-justo/ | San Benito 38 | 281.271 | San Justo Reservoir | 0 | Resource Management Area 82 | 3 |
6009 | 6009 | 6008 | {"type": "MultiPolygon", "coordinates": [[[[-119.97265, 38.19975], [-119.97151, 38.20038], [-119.97128, 38.20049], [-119.97101, 38.20033], [-119.96999, 38.19966], [-119.97195, 38.19831], [-119.97261, 38.19962], [-119.97265, 38.19975]]], [[[-119.97067, 38.1968], [-119.97053, 38.19699], [-119.97043, 38.19716], [-119.97008, 38.19715], [-119.9701, 38.19687], [-119.97033, 38.19666], [-119.97067, 38.1968]]], [[[-119.97859, 38.19362], [-119.97835, 38.19384], [-119.97793, 38.19336], [-119.97819, 38.19316], [-119.97848, 38.19347], [-119.97859, 38.19362]]], [[[-119.98219, 38.19251], [-119.98193, 38.19258], [-119.98177, 38.19232], [-119.98208, 38.19229], [-119.98219, 38.19251]]], [[[-119.99129, 38.18838], [-119.99118, 38.18838], [-119.99077, 38.18833], [-119.99109, 38.18814], [-119.99129, 38.18838]]], [[[-119.99305, 38.19376], [-119.99224, 38.19413], [-119.99183, 38.1943], [-119.9908, 38.19375], [-119.99119, 38.19336], [-119.99142, 38.1935], [-119.99205, 38.19384], [-119.99252, 38.1938], [-119.99298, 38.19368], [-119.99305, 38.19376]]], [[[-119.99211, 38.19559], [-119.99185, 38.196], [-119.99146, 38.19556], [-119.99154, 38.19545], [-119.99182, 38.19528], [-119.99211, 38.19559]]], [[[-119.99377, 38.19211], [-119.99371, 38.19246], [-119.99368, 38.19301], [-119.9932, 38.19329], [-119.99291, 38.19273], [-119.99262, 38.19233], [-119.99212, 38.19191], [-119.99339, 38.19164], [-119.99377, 38.19211]]], [[[-119.99296, 38.18735], [-119.99283, 38.18746], [-119.99258, 38.18737], [-119.99278, 38.18716], [-119.99296, 38.18735]]], [[[-119.99449, 38.19314], [-119.99442, 38.19328], [-119.99354, 38.1936], [-119.9935, 38.19353], [-119.99372, 38.19343], [-119.99382, 38.19217], [-119.99438, 38.19239], [-119.99443, 38.19248], [-119.99443, 38.19256], [-119.99437, 38.19266], [-119.99435, 38.19282], [-119.99439, 38.19297], [-119.99449, 38.19314]]], [[[-119.99432, 38.19396], [-119.99399, 38.1941], [-119.99383, 38.19414], [-119.99354, 38.19368], [-119.99404, 38.19351], [-119.99432, 38.19396]]], [[[-120.00369, 38.19183], [-119.99976, 38.19184], [-120.00003, 38.19149], [-120.0002, 38.19133], [-120.00044, 38.1911], [-120.00063, 38.19096], [-120.00038, 38.19067], [-119.9998, 38.19113], [-119.99923, 38.19184], [-119.99908, 38.19184], [-119.9987, 38.19211], [-119.99844, 38.19238], [-119.99812, 38.19265], [-119.99795, 38.19277], [-119.99785, 38.19284], [-119.99676, 38.19329], [-119.99651, 38.19329], [-119.99546, 38.19316], [-119.99498, 38.19317], [-119.99478, 38.19315], [-119.99462, 38.19305], [-119.99453, 38.19293], [-119.99451, 38.19287], [-119.9945, 38.19272], [-119.99458, 38.19259], [-119.99471, 38.19249], [-119.99488, 38.19243], [-119.99504, 38.19242], [-119.99524, 38.1926], [-119.99561, 38.19247], [-119.9959, 38.19226], [-119.9959, 38.19225], [-119.99568, 38.19201], [-119.99594, 38.19186], [-119.99594, 38.19184], [-119.99428, 38.19189], [-119.99431, 38.19175], [-119.9943, 38.19174], [-119.99384, 38.19184], [-119.99358, 38.19148], [-119.99354, 38.19133], [-119.99401, 38.19118], [-119.9942, 38.19133], [-119.99422, 38.19133], [-119.99444, 38.18822], [-119.99489, 38.18829], [-119.99461, 38.18789], [-119.99489, 38.18779], [-119.995, 38.18803], [-119.99506, 38.18828], [-119.9952, 38.18821], [-119.99906, 38.1882], [-119.99905, 38.18989], [-119.99951, 38.18988], [-119.99928, 38.18999], [-119.99947, 38.19019], [-119.99966, 38.19022], [-119.9999, 38.19015], [-120.00023, 38.19016], [-120.00072, 38.18995], [-120.00207, 38.18999], [-120.00137, 38.19032], [-120.00066, 38.19053], [-120.00044, 38.19061], [-120.00064, 38.19095], [-120.00089, 38.19086], [-120.00155, 38.19065], [-120.00231, 38.19032], [-120.00276, 38.1901], [-120.0032, 38.18995], [-120.00368, 38.18991], [-120.00369, 38.19183]]], [[[-119.99405, 38.18735], [-119.99405, 38.18735], [-119.99362, 38.18721], [-119.99394, 38.18718], [-119.99401, 38.18725], [-119.99405, 38.18735]]], [[[-119.99908, 38.19356], [-119.99851, 38.19358], [-119.99798, 38.19356], [-119.99787, 38.19321], [-119.99795, 38.19287], [-119.99821, 38.19277], [-119.99831, 38.19301], [-119.99868, 38.1929], [-119.99886, 38.19276], [-119.99859, 38.19249], [-119.99874, 38.19233], [-119.999, 38.19262], [-119.99907, 38.19256], [-119.99908, 38.19356]]], [[[-120.00473, 38.18395], [-120.00422, 38.18422], [-120.00298, 38.18412], [-120.00185, 38.18419], [-120.00096, 38.1843], [-120.00044, 38.18406], [-120.00065, 38.18372], [-120.00166, 38.18357], [-120.00282, 38.18328], [-120.00372, 38.18327], [-120.00473, 38.18395]]], [[[-120.00292, 38.18727], [-120.0027, 38.1875], [-120.00201, 38.18725], [-120.00217, 38.18704], [-120.00292, 38.18727]]], [[[-120.00551, 38.19068], [-120.00404, 38.191], [-120.00404, 38.191], [-120.00406, 38.19069], [-120.0049, 38.19028], [-120.00537, 38.19015], [-120.00551, 38.19068]]], [[[-120.0071, 38.18991], [-120.00691, 38.19008], [-120.00657, 38.19032], [-120.0062, 38.18988], [-120.00559, 38.18985], [-120.00588, 38.18942], [-120.00618, 38.18942], [-120.00679, 38.18923], [-120.00709, 38.18929], [-120.0071, 38.18991]]]]} | Open Access 1 | 651 | Lower Strawberry Lake | 21567 | 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 | Tuolumne 21 | 99.748 | Lower Strawberry Lake | 0 | Resource Management Area 82 | 3 | |
911 | 911 | 910 | {"type": "Polygon", "coordinates": [[[-118.51445, 34.12995], [-118.51442, 34.13004], [-118.51434, 34.1301], [-118.51426, 34.13013], [-118.51414, 34.13012], [-118.51299, 34.12951], [-118.51312, 34.12943], [-118.5133, 34.12937], [-118.51381, 34.12933], [-118.51442, 34.12983], [-118.51445, 34.12991], [-118.51445, 34.12995]]]} | No Public Access 3 | 6367 | Encino Reservoir - Federal | 18670 | 199 | Other Federal 284 | Federal 1 | Federal Agency 1 | Other Federal 13 | 199 | Other Federal 280 | Federal 1 | Federal Agency 1 | Los Angeles 6 | 1.48 | Encino Reservoir - Federal | 0 | Resource Management Area 82 | 3 | ||
9934 | 9934 | 9933 | {"type": "MultiPolygon", "coordinates": [[[[-120.91337, 36.99133], [-120.90983, 36.99135], [-120.90983, 36.99135], [-120.90983, 36.99124], [-120.91018, 36.99107], [-120.91061, 36.99088], [-120.91085, 36.99074], [-120.9129, 36.98907], [-120.91258, 36.98963], [-120.91273, 36.99023], [-120.91337, 36.99112], [-120.91337, 36.99133]]], [[[-120.9107, 36.99063], [-120.91051, 36.99074], [-120.91006, 36.99093], [-120.90984, 36.99104], [-120.90986, 36.99061], [-120.9107, 36.99063]]]]} | Open Access 1 | 17099 | Los Banos Reservoir | 21508 | 199 | Other Federal 284 | Federal 1 | Federal Agency 1 | Other Federal 13 | 199 | Other Federal 280 | Federal 1 | Federal Agency 1 | Merced 37 | 8.468 | Los Banos Reservoir | 0 | Resource Management Area 82 | 3 |
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]);