superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where LABEL_NAME = "Plaisted Creek ER" and MNG_AG_TYP = 5
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14444 | 14444 | 14443 | {"type": "Polygon", "coordinates": [[[-116.92472, 33.30781], [-116.9243, 33.30807], [-116.92002, 33.31102], [-116.91534, 33.31417], [-116.90798, 33.31919], [-116.9001, 33.31615], [-116.90138, 33.31462], [-116.90169, 33.31428], [-116.90255, 33.31327], [-116.90259, 33.31326], [-116.91226, 33.30202], [-116.91288, 33.3024], [-116.9132, 33.30251], [-116.91339, 33.30251], [-116.91357, 33.30246], [-116.9137, 33.3024], [-116.91383, 33.30228], [-116.91391, 33.30216], [-116.91394, 33.30203], [-116.91395, 33.30125], [-116.9139, 33.30096], [-116.91366, 33.30042], [-116.91412, 33.29992], [-116.91452, 33.30019], [-116.91469, 33.30037], [-116.91483, 33.30054], [-116.91525, 33.30125], [-116.91538, 33.3014], [-116.91555, 33.3015], [-116.9157, 33.30152], [-116.9158, 33.30151], [-116.91599, 33.30144], [-116.91708, 33.3031], [-116.91724, 33.30377], [-116.91759, 33.30506], [-116.91361, 33.30706], [-116.91334, 33.3069], [-116.91329, 33.30691], [-116.91257, 33.30685], [-116.91224, 33.30687], [-116.91212, 33.30722], [-116.91202, 33.30831], [-116.91242, 33.30841], [-116.91292, 33.30861], [-116.9133, 33.30875], [-116.91369, 33.30885], [-116.91378, 33.30859], [-116.91457, 33.30831], [-116.91452, 33.30776], [-116.91454, 33.30775], [-116.91491, 33.30756], [-116.91525, 33.30744], [-116.91529, 33.30745], [-116.91544, 33.30741], [-116.91602, 33.30748], [-116.9163, 33.30723], [-116.91691, 33.30711], [-116.91724, 33.30707], [-116.91734, 33.30676], [-116.91757, 33.30649], [-116.91777, 33.30639], [-116.91768, 33.30626], [-116.91788, 33.30613], [-116.91827, 33.30753], [-116.92101, 33.30709], [-116.92362, 33.30718], [-116.92413, 33.30746], [-116.92472, 33.30781]], [[-116.91622, 33.30369], [-116.91648, 33.30389], [-116.91698, 33.30386], [-116.91676, 33.30355], [-116.91606, 33.30315], [-116.9151, 33.30326], [-116.91509, 33.30331], [-116.91454, 33.30336], [-116.91429, 33.30327], [-116.91332, 33.30301], [-116.913, 33.3028], [-116.91253, 33.30273], [-116.91272, 33.30309], [-116.91295, 33.30328], [-116.91303, 33.30345], [-116.91315, 33.304], [-116.91341, 33.30416], [-116.91438, 33.30421], [-116.91487, 33.3042], [-116.91539, 33.3041], [-116.91542, 33.3038], [-116.91602, 33.30367], [-116.91622, 33.30369]]]} | Restricted Access 2 | Plaisted Creek Ecological Reserve | 23767 | 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 | 463.66 | Plaisted Creek ER |
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]);