superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
394 rows where MNG_AGENCY = 25 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: PARK_NAME, PARK_URL, LABEL_NAME
ACCESS_TYP 3
- Open Access 252
- No Public Access 75
- Restricted Access 67
MNG_AG_TYP 1
- State Agency 394
MNG_AGENCY 1
- California Department of Fish and Wildlife · 394 ✖
LAYER 1 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13252 | 13252 | 13251 | {"type": "Polygon", "coordinates": [[[-122.01238, 36.97053], [-122.01187, 36.97081], [-122.01185, 36.97079], [-122.01191, 36.97056], [-122.01223, 36.97036], [-122.01238, 36.97053]]]} | No Public Access 3 | South Branciforte | 32313 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 0.251 | South Branciforte | ||
13336 | 13336 | 13335 | {"type": "Polygon", "coordinates": [[[-122.27607, 38.12156], [-122.27576, 38.12178], [-122.2757, 38.12104], [-122.27592, 38.12097], [-122.27607, 38.12156]]]} | Open Access 1 | Vallejo Fishing Pier | 32344 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 0.461 | Vallejo Fishing Pier | ||
6665 | 6665 | 6664 | {"type": "Polygon", "coordinates": [[[-122.64262, 37.8994], [-122.64213, 37.8998], [-122.64167, 37.8996], [-122.64213, 37.89912], [-122.64242, 37.8992], [-122.64262, 37.8994]]]} | No Public Access 3 | Stinson Beach | 32319 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 0.832 | Stinson Beach | ||
1129 | 1129 | 1128 | {"type": "Polygon", "coordinates": [[[-121.94459, 36.97664], [-121.94396, 36.97675], [-121.94326, 36.97677], [-121.94325, 36.9766], [-121.94341, 36.97632], [-121.94317, 36.97587], [-121.94331, 36.97591], [-121.94353, 36.97635], [-121.9438, 36.97644], [-121.94437, 36.97649], [-121.94459, 36.97664]]]} | No Public Access 3 | Escalona Gulch | 32161 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 1.022 | Escalona Gulch | ||
1324 | 1324 | 1323 | {"type": "Polygon", "coordinates": [[[-122.31307, 41.2763], [-122.31264, 41.2763], [-122.31266, 41.2752], [-122.31307, 41.2752], [-122.31307, 41.2763]]]} | No Public Access 3 | Lower Box Canyon | 32208 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 1.06 | Lower Box Canyon | ||
6402 | 6402 | 6401 | {"type": "Polygon", "coordinates": [[[-122.43108, 41.43777], [-122.43089, 41.43822], [-122.4304, 41.43783], [-122.43008, 41.43741], [-122.43055, 41.43722], [-122.43108, 41.43777]]]} | Open Access 1 | Shasta River Fishing Access | 32306 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 1.086 | Shasta River FA | ||
801 | 801 | 800 | {"type": "Polygon", "coordinates": [[[-122.01675, 39.96925], [-122.01628, 39.96961], [-122.0158, 39.96979], [-122.01445, 39.96984], [-122.01447, 39.9697], [-122.01532, 39.96964], [-122.01591, 39.96951], [-122.0165, 39.96916], [-122.01675, 39.96925]]]} | Open Access 1 | Deer Creek Fishing Access | 32147 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 1.1 | Deer Creek FA | ||
4327 | 4327 | 4326 | {"type": "Polygon", "coordinates": [[[-122.4138, 38.46446], [-122.41344, 38.465], [-122.41272, 38.46514], [-122.41239, 38.46481], [-122.41285, 38.46468], [-122.41297, 38.46463], [-122.41332, 38.46455], [-122.41347, 38.4645], [-122.41361, 38.46442], [-122.41379, 38.46439], [-122.4138, 38.46446]]]} | Open Access 1 | Rutherford Crossroad | 32278 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 1.213 | Rutherford Crossroad | ||
14341 | 14341 | 14340 | {"type": "Polygon", "coordinates": [[[-124.09931, 40.49321], [-124.09822, 40.4937], [-124.09816, 40.49283], [-124.09855, 40.49302], [-124.09884, 40.49286], [-124.09931, 40.49321]]]} | Open Access 1 | Unnamed site - California Department of Fish and Wildlife | 30559 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 1.271 | |||
4330 | 4330 | 4329 | {"type": "Polygon", "coordinates": [[[-122.27644, 41.23646], [-122.27565, 41.23673], [-122.27558, 41.23593], [-122.27633, 41.2358], [-122.27644, 41.23646]]]} | Open Access 1 | Sacramento River -- Prospect Ave. Fishing Access | 32282 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 1.338 | Sacramento River -- Prospect Ave. FA | ||
13235 | 13235 | 13234 | {"type": "Polygon", "coordinates": [[[-121.44057, 41.00434], [-121.44008, 41.00444], [-121.44004, 41.00437], [-121.43945, 41.00437], [-121.43934, 41.00404], [-121.43939, 41.00396], [-121.44023, 41.00367], [-121.44032, 41.00373], [-121.44038, 41.00381], [-121.44057, 41.00434]]]} | Open Access 1 | Fall River Mills Ecological Reserve | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Fall-River-Mills-ER | 32163 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 1.448 | Fall River Mills ER | 1998 |
13232 | 13232 | 13231 | {"type": "Polygon", "coordinates": [[[-124.10173, 40.49177], [-124.09991, 40.49269], [-124.09979, 40.49248], [-124.1004, 40.49204], [-124.10081, 40.4918], [-124.1015, 40.49158], [-124.10173, 40.49177]]]} | Open Access 1 | Eel River -- Rio Dell Fishing Access | 32156 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 1.524 | Eel River -- Rio Dell FA | ||
2905 | 2905 | 2904 | {"type": "Polygon", "coordinates": [[[-117.69973, 33.97316], [-117.6997, 33.97405], [-117.6991, 33.97403], [-117.6991, 33.97334], [-117.69894, 33.97306], [-117.69971, 33.97306], [-117.69971, 33.97315], [-117.69973, 33.97316]]]} | Restricted Access 2 | Chino Fish & Wildlife Base | 17207 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 1.585 | Chino Fish & Wildlife Base | ||
14554 | 14554 | 14553 | {"type": "MultiPolygon", "coordinates": [[[[-123.79827, 39.42684], [-123.79795, 39.427], [-123.79736, 39.42734], [-123.79715, 39.42712], [-123.79702, 39.42701], [-123.79711, 39.42678], [-123.79719, 39.42651], [-123.7975, 39.4264], [-123.79826, 39.42676], [-123.79827, 39.42684]]], [[[-123.79844, 39.4263], [-123.7984, 39.42647], [-123.79767, 39.42638], [-123.79763, 39.42621], [-123.79802, 39.4263], [-123.79844, 39.4263]]]]} | Open Access 1 | Noyo River Fishing Access | 32248 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 1.819 | Noyo River FA | ||
13178 | 13178 | 13177 | {"type": "Polygon", "coordinates": [[[-122.91431, 39.14814], [-122.91237, 39.1479], [-122.91249, 39.14739], [-122.91343, 39.14744], [-122.91384, 39.14771], [-122.91431, 39.14814]]]} | Open Access 1 | Bridge Arbor Fishing Access | 32067 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 1.997 | Bridge Arbor FA | ||
13256 | 13256 | 13255 | {"type": "Polygon", "coordinates": [[[-121.72405, 38.8023], [-121.723, 38.802], [-121.72279, 38.80192], [-121.72263, 38.80183], [-121.72246, 38.80166], [-121.72346, 38.80108], [-121.72358, 38.8014], [-121.72365, 38.80151], [-121.72405, 38.8023]]]} | Open Access 1 | Knights Landing Fishing Access | 32198 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 2.104 | Knights Landing FA | ||
8802 | 8802 | 8801 | {"type": "Polygon", "coordinates": [[[-122.76295, 38.34753], [-122.76209, 38.34714], [-122.76092, 38.34616], [-122.76059, 38.34615], [-122.76022, 38.34574], [-122.76118, 38.34575], [-122.76295, 38.34753]]]} | Restricted Access 2 | Theiller Sebastopol Meadowfoam Ecological Reserve | 26298 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 2.51 | Theiller Sebastopol Meadowfoam ER | ||
4329 | 4329 | 4328 | {"type": "Polygon", "coordinates": [[[-124.14878, 41.8907], [-124.14743, 41.89072], [-124.14735, 41.89019], [-124.14668, 41.89019], [-124.14664, 41.88979], [-124.14778, 41.88975], [-124.14829, 41.89017], [-124.14878, 41.8907]]]} | Open Access 1 | Smith River Fishing Access | 32311 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 2.709 | Smith River FA | ||
1534 | 1534 | 1533 | {"type": "Polygon", "coordinates": [[[-124.25267, 41.78246], [-124.25248, 41.78431], [-124.25191, 41.78429], [-124.25189, 41.78253], [-124.25267, 41.78246]]]} | Open Access 1 | North Beach Fishing Access | 32245 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 2.775 | North Beach FA | ||
634 | 634 | 633 | {"type": "Polygon", "coordinates": [[[-121.66948, 38.16979], [-121.66941, 38.16983], [-121.66936, 38.16994], [-121.66935, 38.17035], [-121.66932, 38.17042], [-121.66873, 38.17075], [-121.66858, 38.17088], [-121.66823, 38.17112], [-121.66788, 38.17132], [-121.66746, 38.17165], [-121.66698, 38.17205], [-121.66674, 38.17196], [-121.66754, 38.1713], [-121.66837, 38.17043], [-121.66914, 38.16955], [-121.66948, 38.16979]]]} | Open Access 1 | Cliff House Fishing Access | 32119 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 3.203 | Cliff House FA |
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]);