superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 1, MNG_AGENCY = 25, MNG_AG_TYP = 5 and PARK_NAME = "Fay Slough Wildlife Area"
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- State Agency · 1 ✖
MNG_AGENCY 1
- California Department of Fish and Wildlife · 1 ✖
ACCESS_TYP 1
- Open Access · 1 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15306 | 15306 | 15305 | {"type": "Polygon", "coordinates": [[[-124.11708, 40.80784], [-124.09956, 40.81682], [-124.09653, 40.8184], [-124.0955, 40.81743], [-124.09354, 40.81521], [-124.0932, 40.81535], [-124.09356, 40.81475], [-124.09582, 40.81365], [-124.09584, 40.81339], [-124.09724, 40.81337], [-124.09729, 40.81002], [-124.09537, 40.81], [-124.09552, 40.80899], [-124.09564, 40.80845], [-124.09577, 40.8069], [-124.09584, 40.80646], [-124.09583, 40.80637], [-124.09585, 40.80596], [-124.09574, 40.80448], [-124.09611, 40.8044], [-124.09612, 40.80433], [-124.09576, 40.80427], [-124.09595, 40.80368], [-124.0955, 40.80273], [-124.09514, 40.80259], [-124.09307, 40.80259], [-124.0927, 40.8026], [-124.09269, 40.80218], [-124.09315, 40.801], [-124.09433, 40.80023], [-124.09564, 40.8007], [-124.09652, 40.80127], [-124.0967, 40.80158], [-124.09636, 40.80211], [-124.09636, 40.80212], [-124.09649, 40.80212], [-124.09674, 40.80176], [-124.09704, 40.8016], [-124.09809, 40.80135], [-124.09837, 40.80148], [-124.09869, 40.80213], [-124.0993, 40.80286], [-124.10006, 40.80336], [-124.10069, 40.80328], [-124.10104, 40.80276], [-124.10147, 40.80165], [-124.10212, 40.80114], [-124.1034, 40.80121], [-124.1053, 40.80187], [-124.10555, 40.80225], [-124.10587, 40.80306], [-124.10646, 40.80359], [-124.10688, 40.80357], [-124.10711, 40.80321], [-124.10784, 40.80178], [-124.11074, 40.80411], [-124.11708, 40.80784]], [[-124.09901, 40.80976], [-124.09881, 40.80976], [-124.09862, 40.81004], [-124.09894, 40.81021], [-124.10023, 40.81045], [-124.10063, 40.80978], [-124.09901, 40.80976]]]} | Open Access 1 | Fay Slough Wildlife Area | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Fay-Slough-WA | 30438 | 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 | 502.754 | Fay Slough Wildlife Area | 1988 |
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]);