units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
111 rows where MNG_AGENCY = 37 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: PARK_URL, GAP_STS
DES_TP 12
- National Forest 95
- Recreation Management Area 5
- National Monument or Landmark 2
- Resource Management Area 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
ACCESS_TYP 3
MNG_AG_TYP 1
- Federal Agency 111
MNG_AGENCY 1
- United States Forest Service · 111 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6000 | 6000 | 5999 | {"type": "MultiPolygon", "coordinates": [[[[-119.90427, 38.00765], [-119.90155, 38.00769], [-119.90426, 38.00764], [-119.90417, 37.99681], [-119.89503, 37.99692], [-119.90419, 37.9968], [-119.9043, 38.00737], [-119.90427, 38.00765]]], [[[-119.89967, 38.00773], [-119.89967, 38.00761], [-119.89962, 38.00049], [-119.89963, 38.00049], [-119.89967, 38.00773]]], [[[-119.91335, 38.00029], [-119.90878, 38.00036], [-119.90882, 38.00455], [-119.90877, 38.00035], [-119.91335, 38.00029]]], [[[-119.91747, 38.00745], [-119.91346, 38.00751], [-119.91346, 38.00751], [-119.91346, 38.00751], [-119.91747, 38.00745]]], [[[-119.91643, 38.00385], [-119.91643, 38.00385], [-119.91388, 38.00389], [-119.91641, 38.00384], [-119.91643, 38.00385]]]]} | Open Access 1 | 647 | Hetch Hetchy Water and Power | 19887 | 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 | 1.045 | Hetch Hetchy Water and Power | None 483 | |||
10394 | 10394 | 10393 | {"type": "MultiPolygon", "coordinates": [[[[-117.53635, 34.18242], [-117.53635, 34.18254], [-117.53248, 34.18227], [-117.53248, 34.18202], [-117.53635, 34.18242]]], [[[-117.54058, 34.18647], [-117.53731, 34.18614], [-117.53731, 34.18611], [-117.54058, 34.18645], [-117.54058, 34.18647]]]]} | Open Access 1 | 18373 | Day Canyon Preserve | 17959 | 107 | United States Forest Service 38 | Federal 1 | Federal Agency 1 | http://www.fs.fed.us/ | US Forest Service 7 | 107 | United States Forest Service 37 | Federal 1 | Federal Agency 1 | San Bernardino 22 | 1.963 | Day Canyon Preserve | None 909 | |||
12084 | 12084 | 12083 | {"type": "Polygon", "coordinates": [[[-117.24699, 34.22787], [-117.24641, 34.2278], [-117.24625, 34.22776], [-117.24604, 34.22767], [-117.24588, 34.22753], [-117.24579, 34.22741], [-117.24574, 34.2273], [-117.24558, 34.22653], [-117.24552, 34.22637], [-117.24544, 34.22621], [-117.24695, 34.22622], [-117.24699, 34.22787]]]} | Open Access 1 | 24892 | Baylis Park Picnic Area | 15888 | 107 | United States Forest Service 38 | Federal 1 | Federal Agency 1 | http://www.fs.fed.us/ | US Forest Service 7 | 107 | United States Forest Service 37 | Federal 1 | Federal Agency 1 | San Bernardino 22 | 5.039 | Baylis Park Picnic Area | 0 | Recreation Management Area 49 | 4 | |
12576 | 12576 | 12575 | {"type": "MultiPolygon", "coordinates": [[[[-120.14166, 39.07103], [-120.142, 39.07114], [-120.14231, 39.07128], [-120.14251, 39.07139], [-120.14254, 39.07142], [-120.14254, 39.07146], [-120.14246, 39.07155], [-120.14225, 39.07165], [-120.1419, 39.07188], [-120.14172, 39.07204], [-120.14161, 39.07215], [-120.14158, 39.07214], [-120.14157, 39.07215], [-120.14144, 39.07231], [-120.14147, 39.07234], [-120.14121, 39.07266], [-120.14119, 39.07275], [-120.14109, 39.07291], [-120.14105, 39.07309], [-120.14106, 39.07315], [-120.1411, 39.07322], [-120.14086, 39.07344], [-120.14032, 39.07302], [-120.14054, 39.07292], [-120.14066, 39.07285], [-120.14061, 39.07272], [-120.14076, 39.07254], [-120.14084, 39.07249], [-120.14092, 39.07248], [-120.14123, 39.07219], [-120.14121, 39.07173], [-120.14113, 39.07155], [-120.14118, 39.07148], [-120.14126, 39.07147], [-120.14132, 39.07135], [-120.14145, 39.07134], [-120.14162, 39.07105], [-120.14166, 39.07103]], [[-120.14143, 39.07237], [-120.14143, 39.07235], [-120.14128, 39.07232], [-120.14123, 39.07244], [-120.14134, 39.07247], [-120.14143, 39.07237]]], [[[-120.14324, 39.07035], [-120.14305, 39.07042], [-120.14294, 39.07044], [-120.14274, 39.07016], [-120.14289, 39.07009], [-120.14324, 39.07035]]], [[[-120.14364, 39.06874], [-120.14364, 39.06888], [-120.14306, 39.06888], [-120.14308, 39.06874], [-120.14364, 39.06874]]], [[[-120.14418, 39.06393], [-120.14415, 39.06426], [-120.14388, 39.06426], [-120.14388, 39.06392], [-120.14418, 39.06393]]], [[[-120.14526, 39.06681], [-120.14513, 39.06691], [-120.14435, 39.06656], [-120.14449, 39.06639], [-120.14526, 39.06681]]], [[[-120.14539, 39.06319], [-120.14526, 39.06358], [-120.14456, 39.06347], [-120.14463, 39.06308], [-120.14539, 39.06319]]], [[[-120.14577, 39.06273], [-120.14563, 39.06318], [-120.14527, 39.06305], [-120.14514, 39.06303], [-120.14523, 39.06267], [-120.14481, 39.06267], [-120.14501, 39.06232], [-120.14513, 39.06228], [-120.14531, 39.06246], [-120.14531, 39.06267], [-120.14577, 39.06273]]], [[[-120.14591, 39.07052], [-120.14591, 39.07061], [-120.14586, 39.07065], [-120.14556, 39.07066], [-120.14556, 39.07052], [-120.14591, 39.07052]]], [[[-120.14634, 39.06483], [-120.14605, 39.06518], [-120.14586, 39.06508], [-120.14612, 39.06473], [-120.14634, 39.06483]]], [[[-120.14741, 39.0656], [-120.147, 39.06585], [-120.14673, 39.06562], [-120.14691, 39.06518], [-120.14717, 39.06538], [-120.14741, 39.0656]]], [[[-120.14746, 39.06681], [-120.14693, 39.06702], [-120.14693, 39.06702], [-120.1469, 39.06682], [-120.14713, 39.06673], [-120.14736, 39.06664], [-120.14746, 39.06681]]], [[[-120.14745, 39.06395], [-120.14714, 39.06427], [-120.14695, 39.06417], [-120.14724, 39.06384], [-120.14745, 39.06395]]], [[[-120.14821, 39.06268], [-120.14805, 39.06303], [-120.14796, 39.06297], [-120.14787, 39.06297], [-120.14778, 39.063], [-120.14773, 39.06307], [-120.14714, 39.06296], [-120.14712, 39.06268], [-120.14717, 39.06267], [-120.14718, 39.06232], [-120.14749, 39.06229], [-120.14746, 39.06267], [-120.14773, 39.06268], [-120.14778, 39.0623], [-120.14806, 39.06231], [-120.14803, 39.06267], [-120.14821, 39.06268]]], [[[-120.14794, 39.06181], [-120.14791, 39.06213], [-120.14754, 39.06211], [-120.14735, 39.06212], [-120.14733, 39.062], [-120.14724, 39.06191], [-120.14745, 39.06179], [-120.14794, 39.06181]]], [[[-120.14784, 39.06345], [-120.14757, 39.06333], [-120.14744, 39.06327], [-120.14774, 39.06312], [-120.14779, 39.06316], [-120.14792, 39.06321], [-120.14801, 39.06332], [-120.14799, 39.06337], [-120.14784, 39.06345]]], [[[-120.14855, 39.06475], [-120.14815, 39.06501], [-120.14776, 39.06467], [-120.14813, 39.0644], [-120.14855, 39.06475]]], [[[-120.14858, 39.06107], [-120.14809, 39.06137], [-120.14801, 39.06133], [-120.14807, 39.061], [-120.14847, 39.06091], [-120.14852, 39.061], [-120.14858, 39.06107]]], [[[-120.14941, 39.06476], [-120.14902, 39.06497], [-120.14886, 39.0648], [-120.14885, 39.06477], [-120.14887, 39.06473], [-120.14905, 39.06462], [-120.14922, 39.06454], [-120.14941, 39.06476]]], [[[-120.15031, 39.06794], [-120.15029, 39.06834], [-120.15, 39.06834], [-120.15002, 39.06797], [-120.15009, 39.06794], [-120.15031, 39.06794]]], [[[-120.1516, 39.06614], [-120.15159, 39.06653], [-120.15127, 39.06653], [-120.15141, 39.06613], [-120.1516, 39.06614]]], [[[-120.15202, 39.06574], [-120.15187, 39.0659], [-120.1514, 39.06573], [-120.15155, 39.06558], [-120.15202, 39.06574]]]]} | Open Access 1 | 29109 | USFS | 14186 | 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 | Placer 35 | 11.407 | USFS | 0 | National Forest 11 | 3 | |
10080 | 10080 | 10079 | {"type": "MultiPolygon", "coordinates": [[[[-120.15427, 39.14], [-120.15424, 39.14001], [-120.15311, 39.14001], [-120.15316, 39.13982], [-120.15318, 39.13962], [-120.15416, 39.13964], [-120.15427, 39.14]]], [[[-120.16126, 39.1384], [-120.16124, 39.13992], [-120.15447, 39.13998], [-120.15444, 39.13988], [-120.15437, 39.13959], [-120.15525, 39.13957], [-120.15526, 39.13825], [-120.16126, 39.1384]]]]} | Open Access 1 | 49031 | William Kent Campground and Beach | 33731 | 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/wps/portal/fsinternet/cs/recarea?ss=110519&navtype=BROWSEBYSUBJECT&cid=FSE_003738&navid=110240000000000&pnavid=110000000000000&position=generalinfo&recid=11818&ttype=recarea&pname=William%20Kent%20Campground | Placer 35 | 24.743 | William Kent Campground and Beach | None 874 | ||
9800 | 9800 | 9799 | {"type": "Polygon", "coordinates": [[[-118.85745, 38.19909], [-118.8574, 38.20294], [-118.85195, 38.19906], [-118.85283, 38.19906], [-118.85745, 38.19909]]]} | Open Access 1 | 23013 | Inyo National Forest | 14042 | 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 | http://www.fs.usda.gov/inyo/ | Mono 32 | 25.402 | Inyo NF | 1907 | National Forest 11 | 3 |
6482 | 6482 | 6481 | {"type": "Polygon", "coordinates": [[[-117.49208, 34.25165], [-117.49191, 34.25249], [-117.49152, 34.25285], [-117.49137, 34.25324], [-117.49132, 34.25361], [-117.49123, 34.25396], [-117.49105, 34.25424], [-117.49036, 34.25487], [-117.4893, 34.25482], [-117.48921, 34.25572], [-117.48903, 34.25595], [-117.48918, 34.25659], [-117.48857, 34.25675], [-117.48821, 34.25693], [-117.48831, 34.25044], [-117.48889, 34.25065], [-117.48902, 34.25061], [-117.48981, 34.25022], [-117.49014, 34.24998], [-117.49082, 34.249], [-117.49174, 34.24937], [-117.49085, 34.25064], [-117.49156, 34.25086], [-117.49165, 34.25102], [-117.49152, 34.25158], [-117.49208, 34.25165]], [[-117.49013, 34.25218], [-117.48925, 34.25195], [-117.48893, 34.25197], [-117.48878, 34.25203], [-117.48864, 34.25212], [-117.48854, 34.25234], [-117.4886, 34.25252], [-117.48868, 34.25264], [-117.48886, 34.25268], [-117.49103, 34.25281], [-117.49118, 34.2523], [-117.49087, 34.25222], [-117.49059, 34.25219], [-117.49013, 34.25218]], [[-117.49121, 34.25106], [-117.491, 34.25096], [-117.49079, 34.25096], [-117.49009, 34.25081], [-117.48986, 34.25081], [-117.48975, 34.25092], [-117.48964, 34.2511], [-117.48964, 34.25126], [-117.48972, 34.25137], [-117.48993, 34.25146], [-117.49091, 34.25163], [-117.49119, 34.25161], [-117.49123, 34.25158], [-117.49126, 34.25121], [-117.49121, 34.25106]]]} | Open Access 1 | 2304 | Applewhite Campground | 15543 | 107 | United States Forest Service 38 | Federal 1 | Federal Agency 1 | http://www.fs.fed.us/ | US Forest Service 7 | 107 | United States Forest Service 37 | Federal 1 | Federal Agency 1 | San Bernardino 22 | 36.645 | Applewhite Campground | 0 | Recreation Management Area 49 | 4 | |
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 |
9925 | 9925 | 9924 | {"type": "Polygon", "coordinates": [[[-119.18286, 36.8087], [-119.17407, 36.8089], [-119.17399, 36.80512], [-119.17429, 36.8051], [-119.18262, 36.80491], [-119.18286, 36.8087]]]} | Open Access 1 | 1620 | Sequoia National Forest | 14116 | 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 | http://www.fs.usda.gov/sequoia/ | Fresno 9 | 80.915 | Sequoia NF | 1908 | National Forest 11 | 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 | |
3024 | 3024 | 3023 | {"type": "Polygon", "coordinates": [[[-119.90539, 38.92832], [-119.90539, 38.9285], [-119.90527, 38.92881], [-119.90494, 38.92933], [-119.90485, 38.92959], [-119.90485, 38.93022], [-119.90483, 38.93035], [-119.90475, 38.93057], [-119.90461, 38.9308], [-119.9044, 38.93121], [-119.90436, 38.93147], [-119.90438, 38.93186], [-119.90436, 38.93246], [-119.90443, 38.93267], [-119.90445, 38.93294], [-119.90445, 38.93314], [-119.90442, 38.93342], [-119.89205, 38.92495], [-119.90076, 38.92471], [-119.90076, 38.92469], [-119.9007, 38.92467], [-119.90095, 38.92475], [-119.90115, 38.92479], [-119.90138, 38.92488], [-119.90174, 38.92514], [-119.90183, 38.92525], [-119.90195, 38.92549], [-119.90219, 38.92578], [-119.90233, 38.92589], [-119.90243, 38.92607], [-119.90261, 38.92662], [-119.90277, 38.92696], [-119.90301, 38.92733], [-119.9032, 38.92752], [-119.90341, 38.92766], [-119.90363, 38.92771], [-119.90429, 38.92772], [-119.90464, 38.92778], [-119.90497, 38.92791], [-119.90516, 38.92801], [-119.9053, 38.92818], [-119.90539, 38.92832]]]} | Open Access 1 | 20788 | Lake Tahoe Basin Management Unit | 14047 | 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 | http://www.fs.usda.gov/ltbmu/ | Alpine 51 | 118.851 | Lake Tahoe Basin Management Unit | 0 | National Forest 11 | 3 |
224 | 224 | 223 | {"type": "MultiPolygon", "coordinates": [[[[-120.0847, 38.144], [-120.07547, 38.14412], [-120.0753, 38.14411], [-120.07489, 38.14412], [-120.07422, 38.14417], [-120.07291, 38.14411], [-120.07239, 38.14412], [-120.07139, 38.1442], [-120.07082, 38.14422], [-120.07081, 38.14209], [-120.07076, 38.14051], [-120.07184, 38.14051], [-120.08462, 38.14034], [-120.08467, 38.14206], [-120.0847, 38.144]]], [[[-120.39193, 37.98047], [-120.39193, 37.98053], [-120.39155, 37.98133], [-120.39111, 37.98118], [-120.3906, 37.98072], [-120.39039, 37.98061], [-120.39057, 37.9806], [-120.39087, 37.98056], [-120.39091, 37.98017], [-120.39095, 37.98011], [-120.39193, 37.98047]]]]} | Open Access 1 | 639 | United States Forest Service | 26667 | 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 | 124.293 | United States Forest Service | 0 | National Forest 11 | 3 | |
10021 | 10021 | 10020 | {"type": "Polygon", "coordinates": [[[-119.06718, 36.7047], [-119.06715, 36.70535], [-119.06713, 36.70549], [-119.06715, 36.70627], [-119.06703, 36.70819], [-119.06281, 36.70821], [-119.0628, 36.71161], [-119.05864, 36.71157], [-119.05449, 36.71146], [-119.05447, 36.70794], [-119.05851, 36.70808], [-119.05854, 36.70466], [-119.06718, 36.7047]]]} | Open Access 1 | 1633 | Sequoia National Forest | 14116 | 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 | http://www.fs.usda.gov/sequoia/ | Fresno 9 | 144.418 | Sequoia NF | 1908 | National Forest 11 | 3 |
15769 | 15769 | 15768 | {"type": "Polygon", "coordinates": [[[-119.33248, 38.10812], [-119.32334, 38.10812], [-119.32331, 38.10087], [-119.33244, 38.10087], [-119.33248, 38.10812]]]} | Open Access 1 | 23093 | Humboldt-Toiyabe National Forest | 29310 | 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 | http://www.fs.usda.gov/htnf/ | Mono 32 | 159.456 | Humboldt-Toiyabe NF | 1907 | National Forest 11 | 3 |
4446 | 4446 | 4445 | {"type": "Polygon", "coordinates": [[[-118.34314, 34.39392], [-118.34303, 34.40124], [-118.32543, 34.401], [-118.32549, 34.39781], [-118.33435, 34.39794], [-118.33442, 34.39379], [-118.34314, 34.39392]]]} | Open Access 1 | 48982 | Southern California Edison mitigation | 33677 | 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://cordobacorp.com/projects/southern-california-edison-tehachapi-renewable-transmission-project/ | Los Angeles 6 | 232.391 | Southern California Edison mitigation | 2017 | None 397 | |
15770 | 15770 | 15769 | {"type": "MultiPolygon", "coordinates": [[[[-120.01104, 39.44514], [-120.01104, 39.44524], [-120.01034, 39.44524], [-120.01018, 39.4456], [-120.0096, 39.44741], [-120.00633, 39.44749], [-120.00637, 39.44514], [-120.01104, 39.44514]]], [[[-120.05749, 39.44515], [-120.05745, 39.45098], [-120.05289, 39.45102], [-120.05286, 39.46196], [-120.04828, 39.46199], [-120.04829, 39.44514], [-120.05749, 39.44515]]]]} | Open Access 1 | 23094 | Humboldt-Toiyabe National Forest | 29310 | 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 | http://www.fs.usda.gov/htnf/ | Sierra 58 | 265.611 | Humboldt-Toiyabe NF | 1907 | National Forest 11 | 3 |
9996 | 9996 | 9995 | {"type": "Polygon", "coordinates": [[[-119.2691, 36.85512], [-119.26467, 36.8551], [-119.26457, 36.85161], [-119.26019, 36.85155], [-119.25979, 36.83729], [-119.26428, 36.83726], [-119.26432, 36.84087], [-119.26879, 36.8409], [-119.26906, 36.84804], [-119.2691, 36.85512]]]} | Open Access 1 | 1606 | Sequoia National Forest | 14116 | 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 | http://www.fs.usda.gov/sequoia/ | Fresno 9 | 311.642 | Sequoia NF | 1908 | National Forest 11 | 3 |
4155 | 4155 | 4154 | {"type": "Polygon", "coordinates": [[[-120.4371, 39.25133], [-120.43698, 39.25857], [-120.41847, 39.25868], [-120.41863, 39.25142], [-120.42787, 39.25136], [-120.4371, 39.25133]]]} | Open Access 1 | 44724 | Devil's Peak | 14015 | 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 | Placer 35 | 317.682 | Devil's Peak | None 359 | |||
4898 | 4898 | 4897 | {"type": "MultiPolygon", "coordinates": [[[[-120.50015, 39.81362], [-120.5001, 39.81726], [-120.49416, 39.81724], [-120.48095, 39.81706], [-120.47614, 39.81707], [-120.47619, 39.8135], [-120.48108, 39.81352], [-120.48105, 39.80999], [-120.4954, 39.80992], [-120.49546, 39.8136], [-120.50015, 39.81362]]], [[[-120.49883, 39.80396], [-120.49743, 39.80398], [-120.49743, 39.80424], [-120.49538, 39.80428], [-120.49537, 39.80249], [-120.49752, 39.80247], [-120.49786, 39.80376], [-120.49882, 39.80375], [-120.49883, 39.80396]]]]} | Open Access 1 | 34914 | Plumas National Forest | 14099 | 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 | http://www.fs.usda.gov/plumas/ | Plumas 57 | 334.172 | Plumas NF | 1905 | National Forest 11 | 3 |
14582 | 14582 | 14581 | {"type": "Polygon", "coordinates": [[[-120.39955, 39.38879], [-120.39938, 39.39688], [-120.39889, 39.39699], [-120.39782, 39.39702], [-120.39734, 39.39698], [-120.39628, 39.39675], [-120.39587, 39.39686], [-120.39514, 39.39731], [-120.39491, 39.39736], [-120.3947, 39.39733], [-120.39412, 39.39696], [-120.39381, 39.3969], [-120.39354, 39.39692], [-120.39327, 39.39705], [-120.3928, 39.39763], [-120.39251, 39.39786], [-120.39235, 39.39789], [-120.39163, 39.39779], [-120.39106, 39.39777], [-120.39027, 39.39788], [-120.38932, 39.3982], [-120.3889, 39.39819], [-120.38816, 39.39799], [-120.38773, 39.39802], [-120.38734, 39.39818], [-120.38691, 39.3982], [-120.38651, 39.39831], [-120.3853, 39.39836], [-120.38447, 39.39847], [-120.38328, 39.39834], [-120.38293, 39.39844], [-120.38261, 39.39847], [-120.38219, 39.39841], [-120.38117, 39.39811], [-120.38077, 39.39808], [-120.38095, 39.38866], [-120.38138, 39.38861], [-120.39799, 39.38881], [-120.39955, 39.38879]]]} | Open Access 1 | 44726 | Paradise Valley | 14087 | 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 | Nevada 30 | 397.56 | Paradise Valley | None 1243 |
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]);