superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
4 rows where MNG_AGENCY = 25 and YR_EST = 1981
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11996 | 11996 | 11995 | {"type": "MultiPolygon", "coordinates": [[[[-122.10267, 38.50973], [-122.10037, 38.51148], [-122.1, 38.51135], [-122.09932, 38.51107], [-122.09873, 38.5105], [-122.0984, 38.51], [-122.09784, 38.50883], [-122.09753, 38.50861], [-122.09578, 38.50893], [-122.09578, 38.50895], [-122.09614, 38.50947], [-122.09623, 38.51059], [-122.09609, 38.51129], [-122.0959, 38.51188], [-122.09564, 38.51239], [-122.09541, 38.51269], [-122.09496, 38.5127], [-122.09459, 38.51283], [-122.09418, 38.5131], [-122.09331, 38.51359], [-122.09285, 38.51372], [-122.09243, 38.5142], [-122.0922, 38.51474], [-122.09203, 38.51521], [-122.0918, 38.51546], [-122.09134, 38.51566], [-122.09084, 38.51554], [-122.08963, 38.51481], [-122.08921, 38.51451], [-122.08837, 38.51424], [-122.08779, 38.51419], [-122.08643, 38.51413], [-122.08593, 38.51426], [-122.08537, 38.51411], [-122.08326, 38.51436], [-122.08277, 38.51453], [-122.08238, 38.51471], [-122.08107, 38.51454], [-122.08071, 38.51415], [-122.07999, 38.51381], [-122.07942, 38.51371], [-122.0789, 38.51386], [-122.07743, 38.51386], [-122.07655, 38.51368], [-122.07586, 38.51356], [-122.07541, 38.51364], [-122.075, 38.51357], [-122.07471, 38.51099], [-122.06544, 38.51094], [-122.06499, 38.50736], [-122.07446, 38.50721], [-122.07413, 38.50215], [-122.07863, 38.50203], [-122.07869, 38.50369], [-122.08834, 38.50388], [-122.08851, 38.5109], [-122.09323, 38.51097], [-122.09316, 38.50723], [-122.09775, 38.50722], [-122.09774, 38.50434], [-122.09761, 38.50035], [-122.1022, 38.50037], [-122.10256, 38.50754], [-122.10231, 38.50755], [-122.10212, 38.50967], [-122.10266, 38.50963], [-122.10267, 38.50973]]], [[[-122.10014, 38.51218], [-122.09999, 38.51322], [-122.09951, 38.51323], [-122.09905, 38.51307], [-122.09838, 38.51265], [-122.09813, 38.51246], [-122.09768, 38.51244], [-122.09732, 38.51254], [-122.09661, 38.51279], [-122.09598, 38.51283], [-122.09609, 38.51256], [-122.09632, 38.51215], [-122.09654, 38.51162], [-122.09667, 38.51138], [-122.09678, 38.51111], [-122.09684, 38.51091], [-122.09695, 38.51065], [-122.097, 38.51029], [-122.09706, 38.51007], [-122.09709, 38.50984], [-122.09708, 38.50952], [-122.09706, 38.50931], [-122.09745, 38.50942], [-122.09755, 38.50971], [-122.09776, 38.5102], [-122.09832, 38.51083], [-122.09861, 38.51102], [-122.09884, 38.51125], [-122.0992, 38.51156], [-122.09967, 38.51186], [-122.09991, 38.51197], [-122.10014, 38.51218]]]]} | Open Access 1 | Putah Creek Wildlife Area | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Putah-Creek-WA | 30489 | 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 | 661.704 | Putah Creek Wildlife Area | 1981 |
13141 | 13141 | 13140 | {"type": "Polygon", "coordinates": [[[-122.15113, 41.85168], [-122.15106, 41.85529], [-122.14614, 41.85538], [-122.14595, 41.86271], [-122.14102, 41.8629], [-122.14098, 41.86649], [-122.1312, 41.86662], [-122.12193, 41.86649], [-122.12177, 41.87364], [-122.11236, 41.87367], [-122.11229, 41.88098], [-122.11216, 41.88823], [-122.10259, 41.88799], [-122.10249, 41.89157], [-122.1121, 41.89184], [-122.11203, 41.89546], [-122.10243, 41.89525], [-122.07272, 41.89468], [-122.06319, 41.89456], [-122.05376, 41.89449], [-122.03447, 41.88002], [-122.0249, 41.87293], [-122.02489, 41.86576], [-122.02487, 41.86574], [-122.02487, 41.85852], [-122.0249, 41.85127], [-122.03463, 41.85123], [-122.03469, 41.83681], [-122.03472, 41.83318], [-122.04912, 41.83331], [-122.04916, 41.82967], [-122.06367, 41.8296], [-122.0637, 41.82249], [-122.07336, 41.82252], [-122.07338, 41.82615], [-122.08305, 41.8263], [-122.08302, 41.82998], [-122.0927, 41.83001], [-122.09267, 41.83367], [-122.11216, 41.83369], [-122.11206, 41.83733], [-122.1169, 41.83728], [-122.117, 41.84094], [-122.12209, 41.84083], [-122.1222, 41.84442], [-122.12715, 41.84437], [-122.12718, 41.84793], [-122.13202, 41.84793], [-122.13203, 41.8516], [-122.15113, 41.85168]]]} | Open Access 1 | Butte Valley Wildlife Area | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Butte-Valley-WA | 30419 | 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 | 13326.34 | Butte Valley Wildlife Area | 1981 |
15337 | 15337 | 15336 | {"type": "Polygon", "coordinates": [[[-121.6699, 38.75847], [-121.66966, 38.75881], [-121.66913, 38.75884], [-121.66862, 38.75893], [-121.66828, 38.75904], [-121.66762, 38.75929], [-121.66717, 38.75941], [-121.66663, 38.75977], [-121.66617, 38.76013], [-121.66562, 38.76095], [-121.66491, 38.76227], [-121.66442, 38.76366], [-121.66425, 38.76403], [-121.66402, 38.76472], [-121.66387, 38.76479], [-121.66367, 38.76569], [-121.66354, 38.76632], [-121.66356, 38.76676], [-121.66354, 38.76708], [-121.66353, 38.76752], [-121.66345, 38.76773], [-121.66327, 38.76805], [-121.66321, 38.76823], [-121.66308, 38.7685], [-121.66299, 38.76866], [-121.66289, 38.76878], [-121.66262, 38.76896], [-121.66212, 38.76924], [-121.66181, 38.76933], [-121.66163, 38.76936], [-121.66127, 38.76937], [-121.66096, 38.76935], [-121.66005, 38.76914], [-121.65944, 38.76894], [-121.65906, 38.76878], [-121.65884, 38.76864], [-121.65837, 38.76827], [-121.65807, 38.76788], [-121.65789, 38.76751], [-121.65785, 38.76723], [-121.65792, 38.76626], [-121.65785, 38.76594], [-121.65765, 38.76562], [-121.65735, 38.76527], [-121.6567, 38.7649], [-121.65595, 38.76473], [-121.65562, 38.76462], [-121.65528, 38.76447], [-121.65482, 38.76433], [-121.65399, 38.76415], [-121.65318, 38.76411], [-121.65249, 38.76412], [-121.65204, 38.76422], [-121.65175, 38.76426], [-121.65146, 38.76435], [-121.65105, 38.76425], [-121.65059, 38.7643], [-121.65018, 38.76438], [-121.64964, 38.76446], [-121.64916, 38.76455], [-121.64825, 38.76478], [-121.64771, 38.76505], [-121.64739, 38.76518], [-121.6472, 38.76519], [-121.6469, 38.76529], [-121.64663, 38.76533], [-121.64613, 38.76544], [-121.64571, 38.7656], [-121.6454, 38.76571], [-121.64498, 38.76597], [-121.64441, 38.76615], [-121.64376, 38.76628], [-121.64312, 38.76632], [-121.64227, 38.76631], [-121.64175, 38.76634], [-121.6408, 38.76654], [-121.6405, 38.76665], [-121.6402, 38.76674], [-121.63963, 38.76663], [-121.63854, 38.76678], [-121.63745, 38.76691], [-121.63592, 38.76703], [-121.63554, 38.76703], [-121.63484, 38.76708], [-121.63519, 38.76534], [-121.63571, 38.76454], [-121.63577, 38.76431], [-121.63582, 38.76361], [-121.63581, 38.76332], [-121.63578, 38.76295], [-121.63577, 38.76268], [-121.63621, 38.76269], [-121.63623, 38.76267], [-121.63527, 38.74842], [-121.63496, 38.74139], [-121.66022, 38.74151], [-121.66026, 38.74465], [-121.66027, 38.74818], [-121.65923, 38.74819], [-121.65927, 38.75031], [-121.65813, 38.75162], [-121.65774, 38.75351], [-121.65854, 38.75422], [-121.65816, 38.75463], [-121.65802, 38.75499], [-121.65798, 38.75529], [-121.65802, 38.75552], [-121.65804, 38.75589], [-121.65808, 38.75614], [-121.658, 38.75643], [-121.65795, 38.75676], [-121.65798, 38.75709], [-121.65803, 38.75737], [-121.65859, 38.75873], [-121.65875, 38.75923], [-121.65893, 38.75962], [-121.65902, 38.75986], [-121.65955, 38.76093], [-121.65966, 38.76126], [-121.66003, 38.76187], [-121.66027, 38.76198], [-121.66068, 38.76227], [-121.66162, 38.76302], [-121.66219, 38.76267], [-121.66228, 38.76192], [-121.66316, 38.76128], [-121.66353, 38.76093], [-121.66406, 38.76012], [-121.66489, 38.75876], [-121.66542, 38.75906], [-121.66683, 38.75878], [-121.66814, 38.7585], [-121.66873, 38.75845], [-121.6694, 38.75842], [-121.66985, 38.75842], [-121.6699, 38.75847]]]} | Open Access 1 | Fremont Weir Wildlife Area | 30441 | 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 | 1462.646 | Fremont Weir Wildlife Area | 1981 | |
15349 | 15349 | 15348 | {"type": "Polygon", "coordinates": [[[-121.67267, 38.23526], [-121.67199, 38.23538], [-121.67109, 38.23548], [-121.66964, 38.23586], [-121.66748, 38.23658], [-121.66657, 38.23705], [-121.66669, 38.23662], [-121.66671, 38.23622], [-121.66645, 38.23594], [-121.66624, 38.23551], [-121.66629, 38.23528], [-121.66642, 38.23505], [-121.66671, 38.23485], [-121.6682, 38.23457], [-121.66951, 38.23415], [-121.67, 38.2338], [-121.67045, 38.23344], [-121.67149, 38.233], [-121.67267, 38.23526]]]} | Open Access 1 | Miner Slough Wildlife Area | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Miner-Slough-WA | 30473 | 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 | 27.123 | Miner Slough Wildlife Area | 1981 |
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]);