superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
252 rows where ACCESS_TYP = 1 and MNG_AGENCY = 25 sorted by AGNCY_WEB
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- State Agency 232
MNG_AGENCY 1
- California Department of Fish and Wildlife · 232 ✖
ACCESS_TYP 1
- Open Access · 232 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
659 | 659 | 658 | {"type": "Polygon", "coordinates": [[[-122.51309, 37.94185], [-122.51233, 37.94165], [-122.5123, 37.94128], [-122.51208, 37.94125], [-122.51177, 37.94123], [-122.51169, 37.94119], [-122.51169, 37.94101], [-122.51168, 37.94095], [-122.51166, 37.94091], [-122.51157, 37.94084], [-122.51147, 37.94082], [-122.51141, 37.94082], [-122.51131, 37.94086], [-122.51124, 37.94093], [-122.51114, 37.94119], [-122.51087, 37.94114], [-122.51089, 37.9414], [-122.50788, 37.94164], [-122.50736, 37.94159], [-122.50735, 37.9416], [-122.50743, 37.94212], [-122.50653, 37.94218], [-122.50612, 37.94214], [-122.50492, 37.94245], [-122.50442, 37.9419], [-122.49822, 37.93785], [-122.49771, 37.9377], [-122.49755, 37.93231], [-122.48844, 37.93247], [-122.48849, 37.93502], [-122.47975, 37.93517], [-122.48032, 37.93167], [-122.47993, 37.92898], [-122.49748, 37.92869], [-122.49757, 37.93231], [-122.49984, 37.93227], [-122.49976, 37.92865], [-122.50158, 37.92862], [-122.50166, 37.92813], [-122.4999, 37.92677], [-122.49976, 37.92573], [-122.49998, 37.92569], [-122.50038, 37.92567], [-122.50082, 37.92572], [-122.50127, 37.92581], [-122.50172, 37.92568], [-122.50214, 37.92545], [-122.5026, 37.92477], [-122.50292, 37.92455], [-122.50322, 37.9245], [-122.50365, 37.92455], [-122.50402, 37.92475], [-122.50465, 37.92518], [-122.50489, 37.92522], [-122.50532, 37.92522], [-122.5058, 37.92533], [-122.50631, 37.92523], [-122.50663, 37.92499], [-122.50678, 37.92501], [-122.50705, 37.92485], [-122.50756, 37.92432], [-122.5082, 37.92432], [-122.50821, 37.92438], [-122.50845, 37.92445], [-122.50853, 37.92451], [-122.50862, 37.92451], [-122.50871, 37.92445], [-122.50872, 37.92433], [-122.50879, 37.92431], [-122.50911, 37.92431], [-122.50936, 37.92435], [-122.50936, 37.92443], [-122.50942, 37.92449], [-122.50953, 37.9245], [-122.50961, 37.92445], [-122.50963, 37.9243], [-122.51036, 37.92429], [-122.51066, 37.92623], [-122.5105, 37.92629], [-122.51062, 37.9269], [-122.51068, 37.92729], [-122.51066, 37.92731], [-122.51068, 37.92739], [-122.5106, 37.92744], [-122.50987, 37.92778], [-122.50954, 37.92788], [-122.50901, 37.92814], [-122.50876, 37.92835], [-122.50865, 37.92853], [-122.50862, 37.92877], [-122.50843, 37.92956], [-122.50839, 37.92998], [-122.50832, 37.93034], [-122.50819, 37.9308], [-122.50798, 37.93199], [-122.50773, 37.93298], [-122.50753, 37.93394], [-122.50733, 37.93514], [-122.50733, 37.93585], [-122.50745, 37.93683], [-122.5122, 37.93636], [-122.5123, 37.93702], [-122.51062, 37.93718], [-122.5106, 37.9372], [-122.51082, 37.9384], [-122.51252, 37.93824], [-122.51309, 37.94185]], [[-122.50446, 37.93582], [-122.50453, 37.93582], [-122.50453, 37.93581], [-122.50437, 37.93562], [-122.50439, 37.93534], [-122.50425, 37.93454], [-122.50398, 37.93421], [-122.50415, 37.93393], [-122.50367, 37.93329], [-122.50374, 37.93288], [-122.50282, 37.93222], [-122.50222, 37.93178], [-122.50214, 37.93164], [-122.50225, 37.93585], [-122.50446, 37.93582]]]} | Open Access 1 | Corte Madera Marsh Ecological Reserve | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Corte-Madera-Marsh-ER | 32135 | 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 | 600.126 | Corte Madera Marsh ER | 1977 |
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 | ||
847 | 847 | 846 | {"type": "Polygon", "coordinates": [[[-122.0661, 40.32073], [-122.06599, 40.33047], [-122.06591, 40.34505], [-122.04796, 40.34476], [-122.04943, 40.344], [-122.05247, 40.34246], [-122.0534, 40.34191], [-122.05477, 40.34091], [-122.05591, 40.33969], [-122.05705, 40.33796], [-122.0661, 40.32073]]]} | Open Access 1 | Dales Lake Ecological Reserve | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Dales-Lake-ER | 32143 | 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 | 381.431 | Dales Lake ER | 1994 |
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 | ||
1087 | 1087 | 1086 | {"type": "Polygon", "coordinates": [[[-122.72154, 38.86716], [-122.71933, 38.86718], [-122.71936, 38.86682], [-122.71935, 38.86664], [-122.7193, 38.86639], [-122.71919, 38.86608], [-122.7188, 38.86524], [-122.7187, 38.86399], [-122.71867, 38.86335], [-122.71873, 38.86325], [-122.72002, 38.86389], [-122.72002, 38.86471], [-122.72031, 38.86555], [-122.72055, 38.86629], [-122.72092, 38.86613], [-122.72154, 38.86716]]]} | Open Access 1 | Loch Lomond Vernal Pool Ecological Reserve | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Loch-Lomond-Vernal-Pool-ER | 32205 | 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 | 12.763 | Loch Lomond Vernal Pool ER | 1993 |
1279 | 1279 | 1278 | {"type": "MultiPolygon", "coordinates": [[[[-119.85959, 34.42431], [-119.85959, 34.42431], [-119.85139, 34.42427], [-119.85215, 34.42266], [-119.8523, 34.42272], [-119.85262, 34.42276], [-119.85358, 34.42308], [-119.85439, 34.42325], [-119.85578, 34.42336], [-119.85624, 34.42347], [-119.85654, 34.42346], [-119.85693, 34.42341], [-119.85731, 34.42333], [-119.85769, 34.42322], [-119.85921, 34.42286], [-119.85947, 34.42256], [-119.85958, 34.42256], [-119.85959, 34.42431]]], [[[-119.86507, 34.42432], [-119.85987, 34.42432], [-119.85988, 34.42258], [-119.86004, 34.42288], [-119.86132, 34.4232], [-119.8618, 34.42336], [-119.86229, 34.42347], [-119.86278, 34.42353], [-119.86409, 34.42364], [-119.86506, 34.42364], [-119.86507, 34.42432]]]]} | Open Access 1 | Goleta Slough Ecological Reserve | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Goleta-Slough-ER | 32170 | 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 | 35.468 | Goleta Slough ER | 1983 |
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 | ||
1365 | 1365 | 1364 | {"type": "Polygon", "coordinates": [[[-122.37678, 38.2076], [-122.3765, 38.20788], [-122.37427, 38.20626], [-122.37478, 38.2058], [-122.37528, 38.20615], [-122.37569, 38.20667], [-122.37625, 38.20725], [-122.3765, 38.20744], [-122.37678, 38.2076]]]} | Open Access 1 | Hudeman Slough Fishing Access | 32186 | 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.392 | Hudeman Slough FA | 1962 | |
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 | ||
1375 | 1375 | 1374 | {"type": "Polygon", "coordinates": [[[-122.54551, 41.88727], [-122.5444, 41.88768], [-122.5435, 41.8885], [-122.54277, 41.88937], [-122.54183, 41.88996], [-122.53879, 41.8915], [-122.53586, 41.89274], [-122.53586, 41.89232], [-122.53761, 41.89143], [-122.53801, 41.89105], [-122.53835, 41.89082], [-122.53863, 41.89065], [-122.53877, 41.89049], [-122.53898, 41.89012], [-122.53919, 41.88994], [-122.53929, 41.88974], [-122.53954, 41.88847], [-122.53961, 41.88826], [-122.54052, 41.887], [-122.54549, 41.88699], [-122.54551, 41.88727]]]} | Open Access 1 | Klamath River Fishing Access | 32196 | 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 | 36.2 | Klamath River FA | ||
1395 | 1395 | 1394 | {"type": "Polygon", "coordinates": [[[-123.9944, 40.85728], [-123.98793, 40.85729], [-123.98823, 40.85355], [-123.99082, 40.85359], [-123.991, 40.85206], [-123.99205, 40.85205], [-123.99208, 40.8536], [-123.99106, 40.85359], [-123.99105, 40.85361], [-123.99158, 40.85448], [-123.99209, 40.85481], [-123.99433, 40.85721], [-123.9944, 40.85728]]]} | Open Access 1 | Mad River Fish Hatchery | 32212 | 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 | 43.311 | Mad River Fish Hatchery | ||
1443 | 1443 | 1442 | {"type": "Polygon", "coordinates": [[[-123.12633, 39.12775], [-123.12199, 39.12765], [-123.12186, 39.12406], [-123.12181, 39.12124], [-123.12251, 39.12168], [-123.12399, 39.12253], [-123.12435, 39.12276], [-123.1246, 39.12316], [-123.12473, 39.12355], [-123.12507, 39.12389], [-123.12597, 39.1242], [-123.12633, 39.12775]]]} | Open Access 1 | Mill Creek | 32219 | 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.861 | Mill Creek | ||
1449 | 1449 | 1448 | {"type": "MultiPolygon", "coordinates": [[[[-120.43877, 39.82145], [-120.43839, 39.82166], [-120.43819, 39.82171], [-120.43785, 39.82188], [-120.43755, 39.82196], [-120.43723, 39.822], [-120.43693, 39.82199], [-120.43662, 39.82194], [-120.43634, 39.82185], [-120.4361, 39.8218], [-120.43575, 39.82164], [-120.43576, 39.82128], [-120.43628, 39.82143], [-120.43663, 39.82149], [-120.43688, 39.82151], [-120.43739, 39.8215], [-120.43786, 39.82143], [-120.43877, 39.82145]]], [[[-120.6211, 39.77924], [-120.61819, 39.77703], [-120.61819, 39.77703], [-120.61893, 39.77692], [-120.61946, 39.77704], [-120.61963, 39.77712], [-120.6201, 39.77762], [-120.62049, 39.77786], [-120.62088, 39.77803], [-120.6211, 39.77924]]], [[[-120.62349, 39.7793], [-120.62163, 39.77937], [-120.62146, 39.77817], [-120.6221, 39.77824], [-120.62266, 39.77847], [-120.62302, 39.7787], [-120.62315, 39.77902], [-120.62349, 39.7793]]]]} | Open Access 1 | Middle Fork Feather River Fishing Access | 32218 | 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 | 11.415 | Middle Fork Feather River FA | ||
1481 | 1481 | 1480 | {"type": "Polygon", "coordinates": [[[-117.26286, 34.48019], [-117.26032, 34.48127], [-117.25982, 34.48047], [-117.25985, 34.47881], [-117.25943, 34.47781], [-117.26087, 34.47739], [-117.26168, 34.47931], [-117.26221, 34.47915], [-117.26286, 34.48019]]]} | Open Access 1 | Mojave River Fish Hatchery | 32227 | 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 | 17.671 | Mojave River Fish Hatchery | ||
1486 | 1486 | 1485 | {"type": "Polygon", "coordinates": [[[-122.3326, 41.30589], [-122.33249, 41.3062], [-122.33207, 41.30637], [-122.33217, 41.30672], [-122.33166, 41.30715], [-122.33116, 41.30803], [-122.33115, 41.30819], [-122.33034, 41.30844], [-122.33029, 41.30956], [-122.33025, 41.30957], [-122.33012, 41.30987], [-122.32975, 41.31021], [-122.32973, 41.31055], [-122.32915, 41.3101], [-122.32887, 41.30992], [-122.32817, 41.30958], [-122.32679, 41.30908], [-122.32659, 41.30891], [-122.32846, 41.30749], [-122.32846, 41.30626], [-122.33044, 41.30579], [-122.33046, 41.30533], [-122.33252, 41.30536], [-122.33252, 41.30566], [-122.3326, 41.30589]]]} | Open Access 1 | Mount Shasta Fish Hatchery | 32233 | 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 | 32.774 | Mount Shasta Fish Hatchery | ||
1487 | 1487 | 1486 | {"type": "Polygon", "coordinates": [[[-118.24726, 36.83321], [-118.24275, 36.83325], [-118.24273, 36.82962], [-118.24642, 36.8296], [-118.24725, 36.8304], [-118.24726, 36.83321]]]} | Open Access 1 | Mount Whitney Facility | 32237 | 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 | 39.2 | Mount Whitney Facility |
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]);