superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
252 rows where ACCESS_TYP = 1 and LAYER = 6 sorted by YR_EST
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, MNG_AG_TYP
ACCESS_TYP 1
- Open Access · 252 ✖
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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
424 | 424 | 423 | {"type": "Polygon", "coordinates": [[[-121.24804, 38.63376], [-121.24739, 38.63522], [-121.24697, 38.63508], [-121.24352, 38.63369], [-121.24282, 38.63347], [-121.242, 38.63327], [-121.24122, 38.63298], [-121.24087, 38.6328], [-121.24054, 38.63257], [-121.24015, 38.63234], [-121.23977, 38.63218], [-121.23316, 38.63264], [-121.23297, 38.63186], [-121.22925, 38.63193], [-121.22925, 38.63137], [-121.23982, 38.63078], [-121.24804, 38.63376]]]} | Open Access 1 | American River Access | 32019 | 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 | 59.699 | American River Access | ||
431 | 431 | 430 | {"type": "Polygon", "coordinates": [[[-122.26026, 40.46551], [-122.25995, 40.4661], [-122.25878, 40.46717], [-122.25844, 40.46756], [-122.25829, 40.46797], [-122.25851, 40.46908], [-122.25823, 40.46964], [-122.25693, 40.46679], [-122.257, 40.46675], [-122.25733, 40.4669], [-122.25753, 40.46693], [-122.25755, 40.46692], [-122.25569, 40.46488], [-122.25569, 40.4646], [-122.25488, 40.464], [-122.25532, 40.46233], [-122.25635, 40.46254], [-122.25663, 40.46264], [-122.25701, 40.46333], [-122.25815, 40.46388], [-122.25913, 40.46406], [-122.25986, 40.46436], [-122.26021, 40.46499], [-122.26026, 40.46551]]]} | Open Access 1 | Anderson Fishing Access | 32022 | 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 | 37.55 | Anderson FA | ||
449 | 449 | 448 | {"type": "Polygon", "coordinates": [[[-121.9752, 38.1883], [-121.97501, 38.18844], [-121.97456, 38.18828], [-121.97424, 38.18823], [-121.97403, 38.18826], [-121.97369, 38.18821], [-121.97322, 38.1882], [-121.97279, 38.18816], [-121.9715, 38.18789], [-121.97085, 38.18789], [-121.97038, 38.18761], [-121.97037, 38.18714], [-121.97034, 38.18698], [-121.97037, 38.18681], [-121.97046, 38.18671], [-121.97061, 38.18668], [-121.97351, 38.18742], [-121.97394, 38.18748], [-121.97425, 38.18755], [-121.97444, 38.18772], [-121.97491, 38.18782], [-121.97501, 38.18788], [-121.97501, 38.18814], [-121.9751, 38.18823], [-121.9752, 38.1883]]]} | Open Access 1 | Belden's Landing Fishing Access | 32045 | 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 | 9.739 | Belden's Landing FA | ||
450 | 450 | 449 | {"type": "Polygon", "coordinates": [[[-122.179, 40.39296], [-122.17893, 40.39304], [-122.17881, 40.3933], [-122.17839, 40.39374], [-122.17821, 40.39349], [-122.1782, 40.39301], [-122.17663, 40.39309], [-122.17653, 40.3925], [-122.17678, 40.39242], [-122.177, 40.39239], [-122.17735, 40.39239], [-122.1779, 40.39233], [-122.17853, 40.39231], [-122.17893, 40.39282], [-122.179, 40.39296]]]} | Open Access 1 | Battle Creek Public Access | 32043 | 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 | 4.331 | Battle Creek PA | ||
451 | 451 | 450 | {"type": "Polygon", "coordinates": [[[-122.22395, 40.26271], [-122.2237, 40.26323], [-122.22328, 40.26376], [-122.22186, 40.26304], [-122.22219, 40.26302], [-122.22269, 40.26218], [-122.22395, 40.26271]]]} | Open Access 1 | Bend Bridge Public Access | 32046 | 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.867 | Bend Bridge PA | ||
486 | 486 | 485 | {"type": "Polygon", "coordinates": [[[-124.10364, 40.82505], [-124.10204, 40.8308], [-124.10044, 40.83153], [-124.0966, 40.82984], [-124.08606, 40.82989], [-124.08662, 40.82863], [-124.08662, 40.82862], [-124.08651, 40.82861], [-124.08712, 40.82752], [-124.08783, 40.82593], [-124.08642, 40.82542], [-124.08641, 40.82541], [-124.08628, 40.82535], [-124.08666, 40.82496], [-124.08699, 40.82469], [-124.08887, 40.82328], [-124.08903, 40.82319], [-124.08922, 40.82304], [-124.10364, 40.82505]], [[-124.08767, 40.82431], [-124.08749, 40.82436], [-124.08737, 40.8245], [-124.08721, 40.82478], [-124.08706, 40.82492], [-124.08706, 40.82493], [-124.08714, 40.82496], [-124.08717, 40.82494], [-124.09117, 40.82586], [-124.0918, 40.8249], [-124.09179, 40.82489], [-124.08767, 40.82431]]]} | Open Access 1 | Bracut Tidelands | 32065 | 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 | 222.435 | Bracut Tidelands | ||
488 | 488 | 487 | {"type": "Polygon", "coordinates": [[[-122.3605, 40.5364], [-122.35803, 40.5383], [-122.3578, 40.53844], [-122.35758, 40.53825], [-122.35701, 40.53737], [-122.36041, 40.53623], [-122.3605, 40.5364]]]} | Open Access 1 | Bonnyview Road Fishing Access | 32064 | 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 | 6.223 | Bonnyview Road FA | ||
489 | 489 | 488 | {"type": "MultiPolygon", "coordinates": [[[[-121.68867, 38.1275], [-121.68824, 38.12823], [-121.68816, 38.12841], [-121.68798, 38.1287], [-121.68785, 38.12897], [-121.68754, 38.12941], [-121.68728, 38.1298], [-121.68701, 38.13032], [-121.68702, 38.13034], [-121.68707, 38.13034], [-121.68718, 38.13022], [-121.68731, 38.13013], [-121.68731, 38.13025], [-121.68714, 38.13082], [-121.68674, 38.13286], [-121.68666, 38.13305], [-121.68649, 38.13315], [-121.68632, 38.13314], [-121.68624, 38.1332], [-121.68621, 38.13383], [-121.686, 38.13383], [-121.68599, 38.13345], [-121.686, 38.13318], [-121.68608, 38.13262], [-121.68618, 38.13226], [-121.68662, 38.13085], [-121.68679, 38.13039], [-121.68701, 38.12992], [-121.68765, 38.12883], [-121.68771, 38.12882], [-121.68848, 38.12743], [-121.68867, 38.1275]]], [[[-121.69005, 38.12496], [-121.69001, 38.1252], [-121.68961, 38.12519], [-121.68986, 38.12492], [-121.69005, 38.12496]]]]} | Open Access 1 | Brannan Island Fishing Access | 32066 | 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 | 6.247 | Brannan Island FA | ||
503 | 503 | 502 | {"type": "Polygon", "coordinates": [[[-122.31276, 38.91619], [-122.30056, 38.91633], [-122.30018, 38.91044], [-122.30064, 38.91037], [-122.30093, 38.9103], [-122.30254, 38.90997], [-122.30296, 38.90992], [-122.30356, 38.90991], [-122.30391, 38.90996], [-122.30423, 38.91005], [-122.30598, 38.91071], [-122.30669, 38.91102], [-122.30716, 38.91107], [-122.30751, 38.91104], [-122.30762, 38.91103], [-122.30833, 38.91081], [-122.30869, 38.91064], [-122.30877, 38.91057], [-122.3089, 38.91042], [-122.30904, 38.9103], [-122.30907, 38.91024], [-122.30928, 38.90996], [-122.30929, 38.90987], [-122.3096, 38.90939], [-122.30981, 38.9092], [-122.31013, 38.90898], [-122.31036, 38.90884], [-122.31044, 38.90882], [-122.31061, 38.90873], [-122.31088, 38.90866], [-122.31144, 38.9086], [-122.312, 38.90866], [-122.31239, 38.90877], [-122.31264, 38.90888], [-122.31273, 38.90893], [-122.31276, 38.91619]]]} | Open Access 1 | Cache Creek Public Access | 32077 | 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 | 184.722 | Cache Creek PA | ||
537 | 537 | 536 | {"type": "Polygon", "coordinates": [[[-121.52329, 38.38223], [-121.51986, 38.38421], [-121.51959, 38.38389], [-121.52311, 38.38198], [-121.52329, 38.38223]]]} | Open Access 1 | Clarksburg Fishing Access | 32116 | 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.404 | Clarksburg FA | ||
628 | 628 | 627 | {"type": "Polygon", "coordinates": [[[-122.82083, 40.70392], [-122.82082, 40.70572], [-122.81574, 40.70571], [-122.81575, 40.7039], [-122.82083, 40.70392]]]} | Open Access 1 | Cemetery Hole Fishing Access | 32111 | 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 | 21.266 | Cemetery Hole 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 | ||
673 | 673 | 672 | {"type": "Polygon", "coordinates": [[[-114.722, 33.08954], [-114.70844, 33.08952], [-114.70802, 33.08874], [-114.70769, 33.08819], [-114.70696, 33.08728], [-114.70612, 33.08661], [-114.70461, 33.08633], [-114.7046, 33.08105], [-114.71314, 33.08098], [-114.71309, 33.075], [-114.72176, 33.07503], [-114.722, 33.08954]]]} | Open Access 1 | Colorado River Access | 32132 | 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 | 488.863 | Colorado River Access | ||
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 | ||
815 | 815 | 814 | {"type": "MultiPolygon", "coordinates": [[[[-122.81064, 40.70578], [-122.81004, 40.70593], [-122.80901, 40.70693], [-122.80872, 40.70817], [-122.80814, 40.70853], [-122.80771, 40.70934], [-122.80728, 40.70939], [-122.80691, 40.71639], [-122.80598, 40.71639], [-122.8058, 40.70942], [-122.80587, 40.70899], [-122.80626, 40.70834], [-122.80668, 40.70798], [-122.80707, 40.70772], [-122.8073, 40.70713], [-122.80705, 40.70654], [-122.80737, 40.70648], [-122.8081, 40.70615], [-122.80847, 40.70555], [-122.80892, 40.7056], [-122.81035, 40.70528], [-122.81064, 40.70578]]], [[[-122.81796, 40.71102], [-122.81795, 40.71281], [-122.81715, 40.71313], [-122.81637, 40.71249], [-122.8155, 40.71249], [-122.81448, 40.71101], [-122.81796, 40.71102]]]]} | Open Access 1 | Lewiston Fishing Access | 32202 | 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 | 49.013 | Lewiston FA | ||
844 | 844 | 843 | {"type": "Polygon", "coordinates": [[[-122.00031, 40.43185], [-122.00029, 40.43226], [-121.99983, 40.4321], [-121.99906, 40.43249], [-121.99844, 40.43331], [-121.99657, 40.43358], [-121.99441, 40.43303], [-121.99419, 40.433], [-121.9926, 40.43265], [-121.99119, 40.43195], [-121.99124, 40.42927], [-121.99731, 40.42914], [-121.99734, 40.42833], [-122.00029, 40.42825], [-122.00031, 40.43185]]]} | Open Access 1 | Darrah Springs Fish Hatchery | 32144 | 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 | 85.054 | Darrah Springs Fish Hatchery | ||
848 | 848 | 847 | {"type": "Polygon", "coordinates": [[[-122.80585, 40.71739], [-122.80501, 40.71749], [-122.80433, 40.7175], [-122.80228, 40.7173], [-122.80209, 40.71687], [-122.80259, 40.71646], [-122.80452, 40.71712], [-122.80523, 40.71718], [-122.80585, 40.71739]]]} | Open Access 1 | Deadwood Hole Fishing Access | 32145 | 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 | 4.23 | Deadwood Hole FA | ||
1347 | 1347 | 1346 | {"type": "Polygon", "coordinates": [[[-121.08882, 40.26942], [-121.08854, 40.26983], [-121.08846, 40.27002], [-121.08842, 40.27082], [-121.08796, 40.27059], [-121.08782, 40.27074], [-121.08679, 40.27021], [-121.08692, 40.26987], [-121.08882, 40.26942]]]} | Open Access 1 | Hamilton Branch Fishing Access | 32181 | 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.47 | Hamilton Branch FA | ||
1348 | 1348 | 1347 | {"type": "Polygon", "coordinates": [[[-122.86042, 38.59925], [-122.86034, 38.59981], [-122.86039, 38.60018], [-122.86041, 38.60169], [-122.85992, 38.60156], [-122.85954, 38.60002], [-122.85952, 38.60002], [-122.85941, 38.60012], [-122.85928, 38.59999], [-122.85995, 38.5991], [-122.86042, 38.59925]]]} | Open Access 1 | Healdsburg Fishing Access | 32183 | 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 | 4.182 | Healdsburg FA | ||
1366 | 1366 | 1365 | {"type": "MultiPolygon", "coordinates": [[[[-122.92088, 40.65941], [-122.90654, 40.65933], [-122.90652, 40.65755], [-122.90653, 40.65578], [-122.90892, 40.6558], [-122.90894, 40.65758], [-122.91198, 40.65759], [-122.91302, 40.65654], [-122.9133, 40.65678], [-122.91445, 40.6576], [-122.92086, 40.65764], [-122.92088, 40.65941]]], [[[-122.93008, 40.65443], [-122.93007, 40.65583], [-122.92977, 40.65583], [-122.92978, 40.65452], [-122.93008, 40.65443]]]]} | Open Access 1 | Indian Creek Public Access | 32188 | 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 | 72.728 | Indian Creek PA |
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]);