superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
203 rows where ACCESS_TYP = 1 and MNG_AG_LEV = 1 sorted by ACRES
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY
MNG_AG_TYP 1
- Federal Agency 203
ACCESS_TYP 1
- Open Access · 203 ✖
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 | ||
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 | ||
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 | ||
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 | ||
3057 | 3057 | 3056 | {"type": "Polygon", "coordinates": [[[-124.15279, 41.05272], [-124.15267, 41.05284], [-124.15272, 41.05295], [-124.15099, 41.05294], [-124.14977, 41.0522], [-124.14791, 41.0522], [-124.14804, 41.05204], [-124.15015, 41.05077], [-124.15132, 41.05109], [-124.15127, 41.05122], [-124.15209, 41.05174], [-124.15279, 41.05272]]]} | Open Access 1 | Coastal Access | 17464 | 104 | United States Coast Guard 503 | Federal 1 | Federal Agency 1 | http://www.uscg.mil/ | Other Federal 13 | 12.652 | Coastal Access | ||
1296 | 1296 | 1295 | {"type": "Polygon", "coordinates": [[[-122.02864, 37.82513], [-122.02856, 37.8276], [-122.02498, 37.82568], [-122.02473, 37.82523], [-122.02864, 37.82513]]]} | Open Access 1 | Eugene O'Neill Historic Site | http://www.nps.gov/euon/index.htm | 14214 | 108 | United States National Park Service 59 | Federal 1 | Federal Agency 1 | http://www.nps.gov/ | National Park Service 12 | 12.993 | Eugene O'Neill Historic Site | |
15565 | 15565 | 15564 | {"type": "Polygon", "coordinates": [[[-118.48671, 34.16591], [-118.48664, 34.16649], [-118.48663, 34.16717], [-118.48664, 34.16724], [-118.48669, 34.16733], [-118.48656, 34.1675], [-118.48638, 34.16753], [-118.48622, 34.16759], [-118.48616, 34.16765], [-118.48614, 34.16773], [-118.4862, 34.16804], [-118.48623, 34.16808], [-118.48628, 34.16811], [-118.48608, 34.16815], [-118.4861, 34.16809], [-118.48604, 34.16775], [-118.48591, 34.16777], [-118.48581, 34.1677], [-118.48557, 34.16772], [-118.48516, 34.16783], [-118.48494, 34.16787], [-118.48445, 34.16789], [-118.48418, 34.16787], [-118.48385, 34.1678], [-118.48369, 34.16772], [-118.48359, 34.1676], [-118.48357, 34.16755], [-118.48351, 34.1671], [-118.48355, 34.16638], [-118.48357, 34.16623], [-118.48362, 34.16609], [-118.48368, 34.16599], [-118.48374, 34.16594], [-118.48387, 34.1659], [-118.4853, 34.16589], [-118.48633, 34.16583], [-118.48634, 34.16591], [-118.48639, 34.16594], [-118.48671, 34.16591]]]} | Open Access 1 | Hjelte Sports Center | 20010 | 100 | United States Army Corps of Engineers 142 | Federal 1 | Federal Agency 1 | http://www.usace.army.mil/ | Other Federal 13 | 14.723 | Hjelte Sports Ctr. |
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]);