superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 1 and PARK_URL = "https://www.wildlife.ca.gov/Lands/Places-to-Visit/Hill-Slough-WA"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11861 | 11861 | 11860 | {"type": "Polygon", "coordinates": [[[-122.03421, 38.22328], [-122.0336, 38.22638], [-122.03324, 38.22693], [-122.03179, 38.22807], [-122.02833, 38.22973], [-122.02792, 38.23016], [-122.02778, 38.23061], [-122.02817, 38.23149], [-122.02722, 38.23208], [-122.02635, 38.23203], [-122.0252, 38.23264], [-122.0254, 38.23309], [-122.0258, 38.2334], [-122.02695, 38.23327], [-122.02722, 38.23328], [-122.02797, 38.23394], [-122.02886, 38.2349], [-122.02848, 38.23532], [-122.02771, 38.23537], [-122.02755, 38.236], [-122.02773, 38.23633], [-122.02813, 38.23649], [-122.02846, 38.23654], [-122.02871, 38.2364], [-122.02891, 38.23614], [-122.02921, 38.23593], [-122.02937, 38.23588], [-122.02963, 38.23621], [-122.02944, 38.24356], [-122.02038, 38.24359], [-122.02027, 38.24073], [-122.0097, 38.24083], [-122.00942, 38.23767], [-122.00865, 38.23805], [-122.00755, 38.23837], [-122.00675, 38.23792], [-122.00612, 38.23807], [-122.00392, 38.23876], [-122.00373, 38.2387], [-122.00372, 38.23866], [-122.00233, 38.23834], [-122.00203, 38.23825], [-122.00193, 38.23818], [-122.00144, 38.23788], [-121.99985, 38.23696], [-121.99977, 38.23673], [-121.99912, 38.2362], [-121.99422, 38.23663], [-121.99358, 38.23664], [-121.99209, 38.23679], [-121.99137, 38.23617], [-121.98822, 38.23622], [-121.98821, 38.23264], [-121.98819, 38.23247], [-121.98823, 38.22891], [-121.98908, 38.2289], [-121.98915, 38.22438], [-121.98897, 38.22438], [-121.98869, 38.22432], [-121.98841, 38.22412], [-121.98808, 38.22395], [-121.98751, 38.22375], [-121.98734, 38.22377], [-121.9872, 38.22372], [-121.9862, 38.22423], [-121.98442, 38.22425], [-121.97986, 38.22435], [-121.97986, 38.22424], [-121.97972, 38.22423], [-121.97972, 38.22189], [-121.97974, 38.22159], [-121.9865, 38.22179], [-121.98917, 38.2223], [-121.99121, 38.22272], [-121.99689, 38.22416], [-122.00111, 38.22288], [-122.01333, 38.22279], [-122.01342, 38.2231], [-122.01369, 38.22307], [-122.01375, 38.22307], [-122.01381, 38.22319], [-122.01437, 38.2236], [-122.01484, 38.22468], [-122.01482, 38.22522], [-122.01441, 38.22533], [-122.01351, 38.22613], [-122.01239, 38.22584], [-122.01239, 38.2252], [-122.01229, 38.22493], [-122.01057, 38.22487], [-122.01023, 38.22437], [-122.00925, 38.22419], [-122.00899, 38.22379], [-122.00869, 38.22368], [-122.00844, 38.22366], [-122.00776, 38.22394], [-122.00719, 38.22399], [-122.00697, 38.22404], [-122.00677, 38.22424], [-122.00675, 38.22436], [-122.00711, 38.22486], [-122.00782, 38.22474], [-122.00797, 38.22484], [-122.00807, 38.2251], [-122.00788, 38.22534], [-122.00631, 38.22568], [-122.00534, 38.22557], [-122.00516, 38.22557], [-122.00488, 38.2258], [-122.00478, 38.22597], [-122.0071, 38.22588], [-122.00828, 38.22544], [-122.00842, 38.22494], [-122.00809, 38.22454], [-122.00753, 38.22449], [-122.00723, 38.22449], [-122.00716, 38.22431], [-122.00724, 38.22409], [-122.00748, 38.22416], [-122.0077, 38.2242], [-122.0087, 38.22399], [-122.00912, 38.22444], [-122.00997, 38.22475], [-122.01024, 38.2251], [-122.0108, 38.22518], [-122.01083, 38.22499], [-122.01178, 38.22516], [-122.0118, 38.22575], [-122.01195, 38.22603], [-122.01278, 38.22655], [-122.01366, 38.2266], [-122.01482, 38.22553], [-122.01502, 38.22617], [-122.01587, 38.22668], [-122.01638, 38.22685], [-122.01787, 38.22685], [-122.01838, 38.22641], [-122.01834, 38.22603], [-122.01799, 38.22538], [-122.01792, 38.22513], [-122.01791, 38.22424], [-122.01719, 38.22374], [-122.01698, 38.22366], [-122.01698, 38.22353], [-122.01706, 38.22342], [-122.018, 38.2234], [-122.01834, 38.22346], [-122.01854, 38.22353], [-122.01876, 38.2245], [-122.01914, 38.22514], [-122.01987, 38.22542], [-122.0199, 38.22562], [-122.01936, 38.22593], [-122.01861, 38.22695], [-122.01828, 38.228], [-122.01848, 38.22856], [-122.01894, 38.22889], [-122.0199, 38.22894], [-122.02126, 38.22843], [-122.02157, 38.22813], [-122.02132, 38.22674], [-122.02122, 38.22644], [-122.02153, 38.22619], [-122.02263, 38.22678], [-122.02351, 38.22677], [-122.0238, 38.22602], [-122.02253, 38.22491], [-122.02221, 38.2248], [-122.02209, 38.22446], [-122.02263, 38.2228], [-122.02512, 38.22154], [-122.02539, 38.22156], [-122.02535, 38.22172], [-122.02522, 38.22196], [-122.02519, 38.22212], [-122.02526, 38.22251], [-122.02594, 38.223], [-122.027, 38.22212], [-122.02722, 38.2218], [-122.02734, 38.22102], [-122.02723, 38.22059], [-122.02661, 38.22021], [-122.0256, 38.21977], [-122.02533, 38.21959], [-122.02524, 38.2192], [-122.02756, 38.2189], [-122.02789, 38.21924], [-122.02815, 38.21978], [-122.02868, 38.22017], [-122.0294, 38.2205], [-122.02952, 38.22112], [-122.02969, 38.22153], [-122.02961, 38.22165], [-122.02739, 38.2225], [-122.02681, 38.22304], [-122.02682, 38.22349], [-122.02688, 38.22372], [-122.0274, 38.22433], [-122.02847, 38.22462], [-122.02871, 38.225], [-122.03022, 38.22517], [-122.03065, 38.22496], [-122.03108, 38.22489], [-122.0331, 38.22294], [-122.03358, 38.22289], [-122.03405, 38.2229], [-122.03421, 38.22328]]]} | Open Access 1 | Hill Slough Wildlife Area | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Hill-Slough-WA | 30448 | 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 | 1612.099 | Hill Slough Wildlife Area | 1979 |
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]);