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_URL = "http://www.parks.ca.gov/?page_id=539"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15250 | 15250 | 15249 | {"type": "Polygon", "coordinates": [[[-122.22428, 37.27253], [-122.21984, 37.27249], [-122.21981, 37.26906], [-122.21531, 37.26902], [-122.21525, 37.26554], [-122.21112, 37.26553], [-122.21099, 37.26607], [-122.21098, 37.26618], [-122.21101, 37.26633], [-122.21123, 37.26679], [-122.21128, 37.26696], [-122.21128, 37.26712], [-122.21122, 37.26731], [-122.2112, 37.26751], [-122.21137, 37.26842], [-122.21132, 37.26985], [-122.21134, 37.26995], [-122.21143, 37.27008], [-122.2116, 37.27019], [-122.21172, 37.27022], [-122.21187, 37.27018], [-122.21193, 37.27014], [-122.21196, 37.27008], [-122.21209, 37.26948], [-122.21214, 37.26935], [-122.21228, 37.26913], [-122.21248, 37.26893], [-122.21255, 37.26886], [-122.21265, 37.26881], [-122.21276, 37.26878], [-122.21287, 37.26877], [-122.21306, 37.2688], [-122.21315, 37.26885], [-122.21321, 37.26892], [-122.21326, 37.26899], [-122.21337, 37.2705], [-122.21336, 37.27072], [-122.21321, 37.27154], [-122.21325, 37.27172], [-122.21357, 37.27247], [-122.21335, 37.27246], [-122.21306, 37.27177], [-122.21301, 37.2716], [-122.21301, 37.27147], [-122.21313, 37.27086], [-122.21315, 37.27057], [-122.21304, 37.26903], [-122.21302, 37.26901], [-122.21294, 37.26895], [-122.21278, 37.26896], [-122.2127, 37.269], [-122.21249, 37.2692], [-122.21238, 37.26935], [-122.21231, 37.26952], [-122.21216, 37.27016], [-122.21206, 37.27029], [-122.21196, 37.27035], [-122.21179, 37.27039], [-122.21167, 37.27039], [-122.21155, 37.27037], [-122.2114, 37.2703], [-122.21131, 37.27024], [-122.21121, 37.27015], [-122.21114, 37.27004], [-122.2111, 37.26992], [-122.21114, 37.26843], [-122.211, 37.26767], [-122.21098, 37.26752], [-122.21099, 37.26735], [-122.21105, 37.26714], [-122.21106, 37.26702], [-122.21102, 37.26685], [-122.21079, 37.26638], [-122.21076, 37.26625], [-122.21076, 37.26608], [-122.21088, 37.26554], [-122.21085, 37.26552], [-122.21085, 37.26498], [-122.21063, 37.26467], [-122.21084, 37.26443], [-122.2108, 37.26126], [-122.21038, 37.26127], [-122.21037, 37.2611], [-122.21023, 37.26095], [-122.21015, 37.26068], [-122.20995, 37.2607], [-122.20944, 37.26065], [-122.20897, 37.26047], [-122.20697, 37.25934], [-122.20731, 37.25919], [-122.20766, 37.25916], [-122.20866, 37.25852], [-122.20866, 37.2585], [-122.1974, 37.2586], [-122.19736, 37.2656], [-122.19714, 37.27232], [-122.19973, 37.27233], [-122.19977, 37.27115], [-122.20205, 37.27183], [-122.20205, 37.27208], [-122.2022, 37.27234], [-122.20618, 37.27235], [-122.20398, 37.27447], [-122.20137, 37.28064], [-122.20152, 37.28339], [-122.19516, 37.28343], [-122.19361, 37.27974], [-122.19282, 37.27974], [-122.19291, 37.27233], [-122.19287, 37.27234], [-122.19278, 37.27974], [-122.18844, 37.27976], [-122.18841, 37.27231], [-122.18844, 37.266], [-122.17941, 37.26552], [-122.17074, 37.2651], [-122.16183, 37.26505], [-122.16184, 37.26152], [-122.17065, 37.26162], [-122.1706, 37.25819], [-122.17933, 37.25843], [-122.17942, 37.25127], [-122.18603, 37.25139], [-122.18614, 37.24764], [-122.1907, 37.24769], [-122.19082, 37.2439], [-122.1978, 37.24392], [-122.2064, 37.24398], [-122.21365, 37.2439], [-122.2143, 37.24428], [-122.2161, 37.24579], [-122.21686, 37.24666], [-122.21835, 37.24741], [-122.22062, 37.24827], [-122.22094, 37.24857], [-122.22105, 37.24886], [-122.22104, 37.24937], [-122.22124, 37.24967], [-122.22243, 37.25047], [-122.22414, 37.25125], [-122.22431, 37.25837], [-122.22428, 37.27253]]]} | Open Access 1 | Portola Redwoods State Park | http://www.parks.ca.gov/?page_id=539 | 1696 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 2718.252 | Portola Redwoods SP | 1945 |
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]);