superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
289 rows where MNG_AG_LEV = 1 sorted by ACRES
This data as json, copyable, CSV (advanced)
MNG_AGENCY 9
- United States National Park Service 65
- United States Fish and Wildlife Service 55
- United States Army Corps of Engineers 46
- United States Forest Service 38
- United States Bureau of Land Management 35
- Other Federal 18
- United States Bureau of Reclamation 18
- United States Coast Guard 8
- United States Department of Defense 6
ACCESS_TYP 4
- Open Access 203
- Restricted Access 52
- No Public Access 28
- Unknown Access 6
MNG_AG_TYP 1
- Federal Agency 289
Link | rowid | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES ▼ | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15263 | 15263 | 15262 | {"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 | Trimmer Recreation Area | 26537 | 100 | United States Army Corps of Engineers 142 | Federal 1 | Federal Agency 1 | http://www.usace.army.mil/ | Other Federal 13 | 0.497 | Trimmer Rec. Area | ||
3136 | 3136 | 3135 | {"type": "MultiPolygon", "coordinates": [[[[-118.22858, 33.88759], [-118.22857, 33.88759], [-118.22835, 33.88727], [-118.22846, 33.88739], [-118.22858, 33.88759]]], [[[-118.24226, 33.90419], [-118.24209, 33.90423], [-118.24193, 33.90397], [-118.24191, 33.9036], [-118.24216, 33.90405], [-118.24226, 33.90419]]], [[[-118.24858, 33.91176], [-118.24841, 33.91176], [-118.24735, 33.91049], [-118.24755, 33.9105], [-118.24857, 33.91171], [-118.24858, 33.91176]]]]} | Open Access 1 | Compton Creek & Bike Path | 17571 | 100 | United States Army Corps of Engineers 142 | Federal 1 | Federal Agency 1 | http://www.usace.army.mil/ | Other Federal 13 | 0.849 | Compton Creek & Bike Path | ||
9060 | 9060 | 9059 | {"type": "Polygon", "coordinates": [[[-122.00444, 36.96745], [-122.00388, 36.96749], [-122.00391, 36.96788], [-122.00368, 36.96786], [-122.00366, 36.96704], [-122.004, 36.96702], [-122.00401, 36.96714], [-122.00434, 36.96712], [-122.00444, 36.96745]]]} | Open Access 1 | Twin Lakes - USA | 26615 | 199 | Other Federal 280 | Federal 1 | Federal Agency 1 | Other Federal 13 | 0.9 | Twin Lakes - USA | |||
5093 | 5093 | 5092 | {"type": "MultiPolygon", "coordinates": [[[[-119.90427, 38.00765], [-119.90155, 38.00769], [-119.90426, 38.00763], [-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 | Hetch Hetchy Water and Power | 19887 | 107 | United States Forest Service 37 | Federal 1 | Federal Agency 1 | http://www.fs.fed.us/ | US Forest Service 7 | 1.172 | Hetch Hetchy Water and Power | ||
4027 | 4027 | 4026 | {"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 | Encino Reservoir - Federal | 18670 | 199 | Other Federal 280 | Federal 1 | Federal Agency 1 | Other Federal 13 | 1.48 | Encino Reservoir - Federal | |||
3466 | 3466 | 3465 | {"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 | Day Canyon Preserve | 17959 | 107 | United States Forest Service 37 | Federal 1 | Federal Agency 1 | http://www.fs.fed.us/ | US Forest Service 7 | 1.961 | Day Canyon Preserve | ||
6250 | 6250 | 6249 | {"type": "Polygon", "coordinates": [[[-119.49172, 34.40088], [-119.49129, 34.40263], [-119.49129, 34.40263], [-119.49072, 34.40237], [-119.49092, 34.40127], [-119.49172, 34.40088]]]} | Open Access 1 | Lions Park | 21316 | 199 | Other Federal 280 | Federal 1 | Federal Agency 1 | Other Federal 13 | 2.41 | Lions Park | |||
14677 | 14677 | 14676 | {"type": "MultiPolygon", "coordinates": [[[[-122.3644, 38.14004], [-122.36438, 38.1412], [-122.36339, 38.14077], [-122.36341, 38.13972], [-122.36362, 38.13981], [-122.3644, 38.14004]]], [[[-122.43372, 38.14591], [-122.43337, 38.1458], [-122.43311, 38.14563], [-122.4322, 38.14524], [-122.43246, 38.1453], [-122.43352, 38.14575], [-122.43372, 38.14591]]]]} | Open Access 1 | San Pablo Bay National Wildlife Refuge | 24963 | 106 | United States Fish and Wildlife Service 44 | Federal 1 | Federal Agency 1 | http://www.fws.gov/ | US Fish and Wildlife Service 8 | 2.809 | San Pablo Bay NWR | 1970 | |
8272 | 8272 | 8271 | {"type": "Polygon", "coordinates": [[[-118.29494, 33.706], [-118.29474, 33.70626], [-118.29296, 33.7054], [-118.29347, 33.70526], [-118.2937, 33.70507], [-118.29383, 33.7049], [-118.29412, 33.70493], [-118.29436, 33.70513], [-118.29437, 33.70542], [-118.29462, 33.70546], [-118.29464, 33.70561], [-118.29494, 33.706]]]} | Open Access 1 | Point Fermin Lighthouse | 23849 | 104 | United States Coast Guard 503 | Federal 1 | Federal Agency 1 | http://www.uscg.mil/ | Other Federal 13 | 2.921 | Point Fermin Lighthouse | ||
13463 | 13463 | 13462 | {"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.52176, 38.05425], [-122.52233, 38.05409], [-122.52305, 38.05524]]]} | Restricted Access 2 | United States Coast Guard Park | 30875 | 104 | United States Coast Guard 503 | Federal 1 | Federal Agency 1 | http://www.uscg.mil/ | Other Federal 13 | 3.383 | United States Coast Guard Park | ||
981 | 981 | 980 | {"type": "Polygon", "coordinates": [[[-118.93025, 34.14501], [-118.92997, 34.14499], [-118.92993, 34.14464], [-118.92974, 34.14379], [-118.92957, 34.14348], [-118.92948, 34.14328], [-118.92886, 34.14266], [-118.92864, 34.14235], [-118.92848, 34.14201], [-118.9283, 34.14173], [-118.92811, 34.14159], [-118.92784, 34.14148], [-118.9272, 34.14139], [-118.92693, 34.14128], [-118.92682, 34.1412], [-118.92673, 34.14104], [-118.9261, 34.14091], [-118.92611, 34.14077], [-118.92675, 34.14087], [-118.92687, 34.14075], [-118.92704, 34.14075], [-118.92725, 34.14084], [-118.92746, 34.14096], [-118.92768, 34.14102], [-118.92786, 34.14092], [-118.92801, 34.14071], [-118.92812, 34.14063], [-118.92829, 34.14063], [-118.92846, 34.14068], [-118.92868, 34.14092], [-118.92874, 34.14116], [-118.92841, 34.14085], [-118.92825, 34.14077], [-118.92811, 34.1408], [-118.92804, 34.14095], [-118.92794, 34.14107], [-118.92778, 34.14115], [-118.92765, 34.14115], [-118.92743, 34.14108], [-118.92726, 34.141], [-118.92709, 34.1409], [-118.92693, 34.14089], [-118.92689, 34.14102], [-118.92701, 34.14116], [-118.92717, 34.14123], [-118.92802, 34.14142], [-118.92829, 34.14151], [-118.92846, 34.14169], [-118.92862, 34.14194], [-118.92882, 34.14232], [-118.92903, 34.14264], [-118.92965, 34.14322], [-118.92974, 34.14343], [-118.92986, 34.14361], [-118.9301, 34.14436], [-118.93025, 34.14501]]]} | Open Access 1 | Canilla Corp. | 14196 | 108 | United States National Park Service 59 | Federal 1 | Federal Agency 1 | http://www.nps.gov/ | National Park Service 12 | 3.479 | Canilla Corp. | ||
13223 | 13223 | 13222 | {"type": "Polygon", "coordinates": [[[-124.07864, 40.04562], [-124.07862, 40.04582], [-124.07864, 40.04624], [-124.07861, 40.04664], [-124.07799, 40.04665], [-124.07798, 40.04646], [-124.07763, 40.04638], [-124.07767, 40.04611], [-124.07732, 40.04584], [-124.07662, 40.04552], [-124.07669, 40.04548], [-124.07683, 40.0453], [-124.07689, 40.04525], [-124.07694, 40.04522], [-124.07711, 40.0453], [-124.07735, 40.04533], [-124.0779, 40.04538], [-124.07818, 40.04533], [-124.07837, 40.04536], [-124.07855, 40.04545], [-124.07864, 40.04562]]]} | Open Access 1 | King Range National Conservation Area | http://www.blm.gov/ca/st/en/prog/nlcs/King_Range_NCA/recreation/trails.html | 30563 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | http://www.blm.gov/wo/st/en.html | US Bureau of Land Management 1 | 3.791 | King Range Nat. Conservation Area | |
1330 | 1330 | 1329 | {"type": "Polygon", "coordinates": [[[-117.24699, 34.22787], [-117.24641, 34.2278], [-117.24625, 34.22776], [-117.24605, 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 | Baylis Park Picnic Area | 15888 | 107 | United States Forest Service 37 | Federal 1 | Federal Agency 1 | http://www.fs.fed.us/ | US Forest Service 7 | 5.038 | Baylis Park Picnic Area | ||
13903 | 13903 | 13902 | {"type": "Polygon", "coordinates": [[[-121.48002, 41.95003], [-121.47898, 41.95093], [-121.47693, 41.95089], [-121.47853, 41.9496], [-121.47944, 41.94972], [-121.48002, 41.95003]]]} | Restricted Access 2 | Tule Lake National Monument | 33219 | 108 | United States National Park Service 59 | Federal 1 | Federal Agency 1 | http://www.nps.gov/ | National Park Service 12 | 5.363 | Tule Lake NM | 1942 | |
1292 | 1292 | 1291 | {"type": "Polygon", "coordinates": [[[-122.4927, 37.78799], [-122.49205, 37.78796], [-122.49139, 37.78826], [-122.49086, 37.78861], [-122.48984, 37.78946], [-122.48986, 37.78902], [-122.48996, 37.7886], [-122.49008, 37.78857], [-122.49004, 37.78851], [-122.49001, 37.78837], [-122.49005, 37.78835], [-122.49001, 37.78804], [-122.48986, 37.78796], [-122.49, 37.78777], [-122.49017, 37.78759], [-122.49038, 37.78742], [-122.49062, 37.78728], [-122.49091, 37.78716], [-122.49101, 37.78714], [-122.49113, 37.78714], [-122.4912, 37.78709], [-122.49154, 37.78723], [-122.49157, 37.78741], [-122.49166, 37.7874], [-122.49165, 37.78728], [-122.49175, 37.78732], [-122.49177, 37.78779], [-122.49222, 37.78752], [-122.49224, 37.78776], [-122.4927, 37.78799]]]} | Open Access 1 | China Beach | http://www.nps.gov/goga/planyourvisit/chinabeach.htm | 14203 | 108 | United States National Park Service 59 | Federal 1 | Federal Agency 1 | http://www.nps.gov/ | National Park Service 12 | 6.425 | China Beach | 1972 |
14399 | 14399 | 14398 | {"type": "Polygon", "coordinates": [[[-121.83228, 36.63102], [-121.83235, 36.63119], [-121.83237, 36.63144], [-121.83233, 36.63172], [-121.83214, 36.63209], [-121.83126, 36.63335], [-121.83034, 36.63271], [-121.82997, 36.63238], [-121.83091, 36.63158], [-121.83117, 36.63142], [-121.83217, 36.63099], [-121.83228, 36.63102]]]} | Open Access 1 | Unknown park - United States Department of Defense | 33634 | 198 | United States Department of Defense 504 | Federal 1 | Federal Agency 1 | http://www.defense.gov/ | US Military/Defense 11 | 7.046 | |||
6624 | 6624 | 6623 | {"type": "Polygon", "coordinates": [[[-119.48741, 34.40656], [-119.48735, 34.40708], [-119.48605, 34.40761], [-119.48503, 34.40646], [-119.48517, 34.40627], [-119.48575, 34.40581], [-119.48603, 34.40565], [-119.48683, 34.40595], [-119.48689, 34.40614], [-119.48741, 34.40656]]]} | Open Access 1 | Other Federal 1 | 23249 | 199 | Other Federal 280 | Federal 1 | Federal Agency 1 | Other Federal 13 | 7.121 | Other Federal 1 | |||
5354 | 5354 | 5353 | {"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.91086, 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 | Los Banos Reservoir | 21508 | 199 | Other Federal 280 | Federal 1 | Federal Agency 1 | Other Federal 13 | 8.468 | Los Banos Reservoir | |||
9145 | 9145 | 9144 | {"type": "Polygon", "coordinates": [[[-115.8784, 33.46311], [-115.87833, 33.46522], [-115.87776, 33.46495], [-115.87588, 33.4636], [-115.87517, 33.46304], [-115.8784, 33.46311]]]} | Open Access 1 | Salton Sea State Recreation Area - Federal | 24813 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | http://www.blm.gov/wo/st/en.html | US Bureau of Land Management 1 | 9.253 | Salton Sea SRA - Federal | ||
5240 | 5240 | 5239 | {"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.79128], [-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.79606], [-120.72711, 37.7959], [-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 | Honolulu Bar Recreation Area | 20069 | 100 | United States Army Corps of Engineers 142 | Federal 1 | Federal Agency 1 | http://www.usace.army.mil/ | Other Federal 13 | 10.139 | Honolulu Bar Rec. Area |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);