superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where LABEL_NAME = "Calaveras Big Trees SP" and MNG_AGENCY = 47
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15227 | 15227 | 15226 | {"type": "Polygon", "coordinates": [[[-120.32144, 38.272], [-120.31686, 38.27564], [-120.31687, 38.27932], [-120.31701, 38.28297], [-120.31257, 38.28663], [-120.3034, 38.28662], [-120.30165, 38.28732], [-120.30183, 38.28706], [-120.30182, 38.28704], [-120.30121, 38.28721], [-120.30081, 38.28752], [-120.29832, 38.28842], [-120.29788, 38.28957], [-120.29784, 38.28976], [-120.29774, 38.29], [-120.29762, 38.29017], [-120.29745, 38.29033], [-120.29723, 38.29048], [-120.29702, 38.29058], [-120.29675, 38.29066], [-120.29643, 38.2907], [-120.29622, 38.2907], [-120.29562, 38.29064], [-120.29512, 38.29064], [-120.29456, 38.29068], [-120.29397, 38.29077], [-120.28954, 38.29171], [-120.28866, 38.29196], [-120.28745, 38.29235], [-120.28719, 38.29244], [-120.28666, 38.29266], [-120.28646, 38.29228], [-120.28753, 38.29168], [-120.28895, 38.28946], [-120.28864, 38.28924], [-120.28832, 38.28892], [-120.28797, 38.2886], [-120.28784, 38.28672], [-120.2851, 38.28677], [-120.28505, 38.28451], [-120.28508, 38.28315], [-120.28495, 38.28313], [-120.28484, 38.283], [-120.28451, 38.2828], [-120.28441, 38.28258], [-120.28443, 38.28225], [-120.28449, 38.28183], [-120.28472, 38.28068], [-120.28478, 38.28024], [-120.28476, 38.27975], [-120.28468, 38.27921], [-120.28468, 38.27815], [-120.28471, 38.27719], [-120.28475, 38.27697], [-120.28485, 38.27671], [-120.2849, 38.27638], [-120.28492, 38.275], [-120.28487, 38.27474], [-120.28479, 38.2745], [-120.28479, 38.2743], [-120.28488, 38.27404], [-120.28489, 38.27372], [-120.28482, 38.27358], [-120.28459, 38.27338], [-120.28441, 38.27313], [-120.28435, 38.273], [-120.28402, 38.27266], [-120.28382, 38.2725], [-120.28373, 38.27234], [-120.28372, 38.27209], [-120.28307, 38.27209], [-120.28059, 38.27224], [-120.26689, 38.27256], [-120.2658, 38.27258], [-120.26232, 38.27267], [-120.26258, 38.26565], [-120.26267, 38.26203], [-120.24408, 38.26232], [-120.24379, 38.2583], [-120.2352, 38.25849], [-120.2352, 38.26616], [-120.22606, 38.26598], [-120.22144, 38.26587], [-120.22148, 38.26223], [-120.21906, 38.26216], [-120.21595, 38.26212], [-120.212, 38.26203], [-120.21198, 38.26202], [-120.212, 38.26201], [-120.21167, 38.25848], [-120.21358, 38.25844], [-120.2159, 38.25668], [-120.21595, 38.25486], [-120.21826, 38.25307], [-120.2183, 38.25127], [-120.22395, 38.24774], [-120.22621, 38.24777], [-120.23907, 38.23783], [-120.24477, 38.23783], [-120.24484, 38.23695], [-120.24714, 38.23695], [-120.25062, 38.23408], [-120.2633, 38.2341], [-120.26318, 38.23702], [-120.26769, 38.23672], [-120.27216, 38.24001], [-120.27492, 38.24208], [-120.27662, 38.24335], [-120.28107, 38.24674], [-120.28894, 38.24669], [-120.29012, 38.2467], [-120.29005, 38.25035], [-120.29454, 38.25033], [-120.29444, 38.26491], [-120.29438, 38.26854], [-120.29894, 38.26852], [-120.29904, 38.2649], [-120.30792, 38.26476], [-120.30799, 38.26112], [-120.31693, 38.26099], [-120.31683, 38.26463], [-120.32144, 38.26467], [-120.32144, 38.272]]]} | Open Access 1 | Calaveras Big Trees State Park | http://www.parks.ca.gov/?page_id=551 | 1454 | 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 | 6452.729 | Calaveras Big Trees SP | 1931 |
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]);