units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
7 rows where COUNTY = 51 and MNG_AGENCY = 25
This data as json, copyable, CSV (advanced)
Suggested facets: YR_EST
Link | rowid ▼ | id | map | ACCESS_TYP | UNIT_ID | UNIT_NAME | SUID_NMA | AGNCY_ID | AGNCY_NAME | AGNCY_LEV | AGNCY_TYP | AGNCY_WEB | LAYER | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | PARK_URL | COUNTY | ACRES | LABEL_NAME | YR_EST | DES_TP | GAP_STS |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3146 | 3146 | 3145 | {"type": "MultiPolygon", "coordinates": [[[[-119.59583, 38.57678], [-119.59581, 38.58119], [-119.5958, 38.58194], [-119.59564, 38.58174], [-119.59533, 38.58142], [-119.595, 38.58092], [-119.59477, 38.58071], [-119.59399, 38.58033], [-119.59373, 38.58025], [-119.59347, 38.58012], [-119.59267, 38.57962], [-119.59227, 38.5792], [-119.5921, 38.57897], [-119.59194, 38.57871], [-119.59185, 38.57861], [-119.5917, 38.57817], [-119.59165, 38.57793], [-119.59159, 38.57737], [-119.59122, 38.57651], [-119.59583, 38.57678]]], [[[-119.59585, 38.59055], [-119.59576, 38.59048], [-119.5955, 38.59013], [-119.59536, 38.58982], [-119.5953, 38.5896], [-119.5951, 38.58914], [-119.59489, 38.58855], [-119.59481, 38.58787], [-119.59481, 38.58753], [-119.59486, 38.58703], [-119.59482, 38.58624], [-119.59487, 38.58572], [-119.59505, 38.58513], [-119.59543, 38.58417], [-119.59564, 38.5837], [-119.59573, 38.58345], [-119.59574, 38.58324], [-119.59579, 38.58309], [-119.59579, 38.58396], [-119.59585, 38.59055]]], [[[-119.59594, 38.58261], [-119.59594, 38.58261], [-119.59594, 38.58261], [-119.59594, 38.58261], [-119.59594, 38.58261]]]]} | Open Access 1 | 21612 | Slinkard / Little Antelope Wildlife Area | 30505 | 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 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Slinkard-Little-Antelope-WA | Alpine 51 | 47.817 | Slinkard / Little Antelope Wildlife Area | 1979 | State Conservation Area 8 | 2 |
5517 | 5517 | 5516 | {"type": "MultiPolygon", "coordinates": [[[[-119.95634, 38.71971], [-119.95634, 38.72329], [-119.95166, 38.72325], [-119.95168, 38.71982], [-119.95175, 38.71981], [-119.95176, 38.71976], [-119.95627, 38.71969], [-119.95628, 38.71971], [-119.95634, 38.71971]]], [[[-119.96098, 38.70512], [-119.956, 38.70507], [-119.95595, 38.70137], [-119.96086, 38.70139], [-119.96093, 38.70508], [-119.96098, 38.70512]]], [[[-119.96537, 38.68314], [-119.96078, 38.68316], [-119.96075, 38.68315], [-119.96072, 38.67619], [-119.96075, 38.67616], [-119.96075, 38.67577], [-119.96525, 38.67573], [-119.96537, 38.68314]]], [[[-119.98409, 38.70137], [-119.97475, 38.70153], [-119.97477, 38.70426], [-119.97402, 38.7044], [-119.97321, 38.70452], [-119.97231, 38.70459], [-119.97089, 38.7048], [-119.97027, 38.70492], [-119.96945, 38.70491], [-119.96901, 38.70476], [-119.96813, 38.7044], [-119.96786, 38.70425], [-119.9676, 38.70404], [-119.96738, 38.70379], [-119.96725, 38.70359], [-119.96708, 38.70327], [-119.96695, 38.70295], [-119.96687, 38.70217], [-119.96678, 38.70021], [-119.96673, 38.69977], [-119.96657, 38.69949], [-119.96636, 38.69929], [-119.96612, 38.69909], [-119.96605, 38.69839], [-119.966, 38.69814], [-119.96588, 38.69785], [-119.96569, 38.69744], [-119.96549, 38.69717], [-119.96524, 38.69701], [-119.9652, 38.69405], [-119.96079, 38.69407], [-119.96075, 38.6904], [-119.96977, 38.69038], [-119.96975, 38.68689], [-119.97469, 38.68689], [-119.9747, 38.69405], [-119.98407, 38.69397], [-119.98409, 38.70137]]], [[[-119.96575, 38.74152], [-119.961, 38.74152], [-119.96102, 38.7379], [-119.96097, 38.73427], [-119.961, 38.73427], [-119.96102, 38.73424], [-119.96108, 38.73424], [-119.96113, 38.73428], [-119.96569, 38.73427], [-119.96575, 38.74152]]], [[[-119.97452, 38.67576], [-119.96983, 38.67573], [-119.96489, 38.67568], [-119.96485, 38.67263], [-119.97445, 38.67245], [-119.97452, 38.67576]]]]} | Open Access 1 | 22165 | Red Lake Wildlife Area | 30491 | 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 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Red-Lake-WA | Alpine 51 | 861.648 | Red Lake Wildlife Area | 1988 | State Conservation Area 8 | 2 |
10876 | 10876 | 10875 | {"type": "MultiPolygon", "coordinates": [[[[-119.80682, 38.86625], [-119.79722, 38.85963], [-119.8053, 38.85961], [-119.79472, 38.85244], [-119.79749, 38.85241], [-119.7975, 38.84901], [-119.8067, 38.849], [-119.8068, 38.85962], [-119.80682, 38.86625]]], [[[-119.81138, 38.86695], [-119.81131, 38.86934], [-119.80784, 38.86695], [-119.81138, 38.86695], [-119.81138, 38.86695]]], [[[-119.82541, 38.8742], [-119.82076, 38.8742], [-119.82075, 38.86696], [-119.82536, 38.86696], [-119.82541, 38.8742]]]]} | Restricted Access 2 | 20781 | Fay Canyon Wildlife Area | 18856 | 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 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Alpine 51 | 356.586 | Fay Canyon Wildlife Area | 0 | State Conservation Area 8 | 2 | |
10881 | 10881 | 10880 | {"type": "MultiPolygon", "coordinates": [[[[-119.9415, 38.78188], [-119.93669, 38.78193], [-119.9367, 38.78558], [-119.93216, 38.78569], [-119.93225, 38.79296], [-119.93675, 38.79297], [-119.93688, 38.79666], [-119.93223, 38.7967], [-119.93237, 38.80739], [-119.90078, 38.80744], [-119.90069, 38.8021], [-119.90051, 38.79664], [-119.90049, 38.79482], [-119.9005, 38.79293], [-119.9005, 38.78571], [-119.91313, 38.78565], [-119.91284, 38.7781], [-119.90367, 38.77831], [-119.90368, 38.77491], [-119.93212, 38.77478], [-119.93218, 38.77117], [-119.93685, 38.77116], [-119.93687, 38.7748], [-119.94149, 38.77481], [-119.9415, 38.78188]], [[-119.91769, 38.79281], [-119.91765, 38.78919], [-119.91298, 38.78919], [-119.91293, 38.79293], [-119.91768, 38.79293], [-119.91769, 38.79281]], [[-119.92264, 38.78562], [-119.92263, 38.78561], [-119.91768, 38.78554], [-119.91766, 38.78919], [-119.92258, 38.78922], [-119.92264, 38.78562]]], [[[-119.94131, 38.71713], [-119.9391, 38.71751], [-119.93822, 38.71414], [-119.94031, 38.71353], [-119.94131, 38.71713]]], [[[-119.95643, 38.74524], [-119.95181, 38.74522], [-119.95191, 38.75984], [-119.94729, 38.75991], [-119.94725, 38.75254], [-119.94271, 38.75251], [-119.94259, 38.74885], [-119.94725, 38.74883], [-119.9472, 38.74525], [-119.94258, 38.74525], [-119.94254, 38.73835], [-119.94724, 38.73835], [-119.94714, 38.73053], [-119.95093, 38.73053], [-119.95094, 38.73064], [-119.95166, 38.73063], [-119.95171, 38.73432], [-119.95182, 38.73433], [-119.95184, 38.7379], [-119.95638, 38.73789], [-119.95643, 38.74524]]]]} | Open Access 1 | 20780 | Hope Valley Wildlife Area | 30455 | 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 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Hope-Valley-WA | Alpine 51 | 2943.748 | Hope Valley Wildlife Area | 1989 | State Conservation Area 8 | 2 |
10888 | 10888 | 10887 | {"type": "MultiPolygon", "coordinates": [[[[-119.64375, 38.49138], [-119.64329, 38.49875], [-119.63427, 38.49886], [-119.63415, 38.50244], [-119.62983, 38.50247], [-119.61651, 38.50195], [-119.61647, 38.4999], [-119.61634, 38.49523], [-119.62081, 38.49526], [-119.62078, 38.49186], [-119.626, 38.49168], [-119.63002, 38.49166], [-119.63007, 38.48818], [-119.63468, 38.48808], [-119.63456, 38.49155], [-119.64375, 38.49138]]], [[[-119.6757, 38.52703], [-119.6757, 38.53059], [-119.66602, 38.53084], [-119.66597, 38.52729], [-119.67485, 38.52698], [-119.67486, 38.52705], [-119.6757, 38.52703]]]]} | No Public Access 3 | 20783 | Poison Flat Creek | 32269 | 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 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Alpine 51 | 697.661 | Poison Flat Creek | 0 | State Resource Management Area 55 | 3 | |
15605 | 15605 | 15604 | {"type": "Polygon", "coordinates": [[[-119.72836, 38.76932], [-119.72373, 38.76933], [-119.7237, 38.76577], [-119.72821, 38.76567], [-119.72836, 38.76932]]]} | Open Access 1 | 20782 | East Fork Carson River Fishing Access | 32153 | 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 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Alpine 51 | 39.271 | East Fork Carson River FA | 0 | State Recreation Area 39 | 4 | |
16277 | 16277 | 16276 | {"type": "Polygon", "coordinates": [[[-119.66865, 38.66286], [-119.65953, 38.66295], [-119.65059, 38.66299], [-119.64097, 38.66305], [-119.63176, 38.66296], [-119.62739, 38.663], [-119.62274, 38.663], [-119.62279, 38.65938], [-119.63176, 38.65931], [-119.63167, 38.65577], [-119.63616, 38.65566], [-119.63601, 38.65204], [-119.64056, 38.65198], [-119.6498, 38.65179], [-119.6495, 38.64812], [-119.65431, 38.64829], [-119.65412, 38.64097], [-119.65439, 38.64097], [-119.6544, 38.64096], [-119.65419, 38.63732], [-119.65398, 38.63731], [-119.65383, 38.63367], [-119.66704, 38.63358], [-119.66786, 38.64086], [-119.6685, 38.64808], [-119.66862, 38.65551], [-119.66865, 38.66286]]]} | Open Access 1 | 20784 | Heenan Lake Wildlife Area | 30447 | 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 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Heenan-Lake-WA | Alpine 51 | 1655.526 | Heenan Lake Wildlife Area | 1983 | State Conservation Area 8 | 2 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([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([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);