superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where MNG_AG_TYP = 5 and PARK_NAME = "Hope Valley Wildlife Area"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13164 | 13164 | 13163 | {"type": "MultiPolygon", "coordinates": [[[[-119.9415, 38.78188], [-119.9367, 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.79671], [-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.78564], [-119.91284, 38.7781], [-119.90367, 38.77831], [-119.90368, 38.77491], [-119.93211, 38.77478], [-119.93218, 38.77117], [-119.93685, 38.77116], [-119.93688, 38.7748], [-119.94149, 38.77481], [-119.9415, 38.78188]], [[-119.91769, 38.79281], [-119.91765, 38.78919], [-119.91298, 38.7892], [-119.91293, 38.79293], [-119.91767, 38.79293], [-119.91769, 38.79281]], [[-119.92264, 38.78562], [-119.92263, 38.78561], [-119.91768, 38.78555], [-119.91766, 38.78918], [-119.92257, 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.74523], [-119.95191, 38.75984], [-119.94729, 38.75991], [-119.94725, 38.75255], [-119.94271, 38.75251], [-119.94259, 38.74885], [-119.94725, 38.74882], [-119.94719, 38.74525], [-119.94258, 38.74525], [-119.94254, 38.73835], [-119.94724, 38.73834], [-119.94714, 38.73053], [-119.95093, 38.73053], [-119.95095, 38.73064], [-119.95166, 38.73063], [-119.95171, 38.73431], [-119.95182, 38.73433], [-119.95185, 38.7379], [-119.95638, 38.73789], [-119.95643, 38.74524]]]]} | Open Access 1 | Hope Valley Wildlife Area | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Hope-Valley-WA | 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 | 2944.549 | Hope Valley Wildlife Area | 1989 |
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]);