units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where DES_TP = 8 and UNIT_NAME = "Hope Valley Wildlife Area"
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
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]);