superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where ACCESS_TYP = 2 and YR_EST = 1962
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14536 | 14536 | 14535 | {"type": "MultiPolygon", "coordinates": [[[[-117.20651, 33.43216], [-117.20644, 33.44303], [-117.19757, 33.44297], [-117.1975, 33.44656], [-117.19751, 33.44657], [-117.20642, 33.44665], [-117.20637, 33.45054], [-117.16741, 33.4645], [-117.16732, 33.46177], [-117.16524, 33.46316], [-117.16477, 33.46349], [-117.16432, 33.46385], [-117.1639, 33.46423], [-117.16319, 33.46492], [-117.16317, 33.46482], [-117.16297, 33.46465], [-117.15938, 33.4648], [-117.15931, 33.46482], [-117.15421, 33.46507], [-117.14525, 33.46588], [-117.14538, 33.46928], [-117.14494, 33.46886], [-117.14213, 33.46585], [-117.13783, 33.46151], [-117.1408, 33.46152], [-117.14069, 33.45435], [-117.13656, 33.45432], [-117.13646, 33.45406], [-117.13637, 33.45348], [-117.1363, 33.45254], [-117.13632, 33.44932], [-117.13637, 33.4487], [-117.13646, 33.448], [-117.13653, 33.44776], [-117.13676, 33.44716], [-117.15344, 33.4472], [-117.15378, 33.43266], [-117.15812, 33.43261], [-117.15812, 33.43977], [-117.15813, 33.43978], [-117.16663, 33.43969], [-117.16672, 33.43254], [-117.17132, 33.43242], [-117.17338, 33.43238], [-117.17327, 33.42847], [-117.1779, 33.42839], [-117.1779, 33.43232], [-117.18245, 33.43226], [-117.18253, 33.4283], [-117.19167, 33.42815], [-117.19556, 33.42806], [-117.19537, 33.42845], [-117.19525, 33.42931], [-117.19526, 33.42932], [-117.19685, 33.429], [-117.19721, 33.42851], [-117.19932, 33.42801], [-117.20077, 33.42797], [-117.20291, 33.42795], [-117.20281, 33.43006], [-117.19914, 33.43009], [-117.199, 33.43159], [-117.19592, 33.4316], [-117.19589, 33.43216], [-117.20651, 33.43216]], [[-117.17573, 33.43756], [-117.17571, 33.43677], [-117.17535, 33.43751], [-117.17514, 33.43806], [-117.17463, 33.43969], [-117.17359, 33.44318], [-117.17439, 33.44316], [-117.17551, 33.43984], [-117.17588, 33.43855], [-117.17623, 33.43758], [-117.17573, 33.43756]]], [[[-117.21972, 33.42999], [-117.21971, 33.43008], [-117.21941, 33.43087], [-117.21888, 33.43101], [-117.21852, 33.43096], [-117.21805, 33.43108], [-117.21795, 33.43113], [-117.21774, 33.43153], [-117.21722, 33.43152], [-117.21407, 33.43154], [-117.21414, 33.42781], [-117.21857, 33.4278], [-117.21851, 33.42935], [-117.21925, 33.42978], [-117.21965, 33.42988], [-117.2197, 33.42993], [-117.21972, 33.42999]]]]} | Restricted Access 2 | Santa Margarita Ecological Reserve | https://fsp.sdsu.edu/about-us/ | 33342 | 221 | San Diego State University 378 | State 5 | State Agency 5 | http://www.sdsu.edu/ | Other State 5 | 4355.304 | Santa Margarita ER | 1962 |
14663 | 14663 | 14662 | {"type": "Polygon", "coordinates": [[[-122.11653, 39.34098], [-122.09533, 39.34093], [-122.08578, 39.34102], [-122.08616, 39.33813], [-122.08611, 39.33779], [-122.08588, 39.33731], [-122.08604, 39.33349], [-122.08475, 39.33171], [-122.08471, 39.3316], [-122.08406, 39.32891], [-122.08397, 39.32708], [-122.08355, 39.32382], [-122.0825, 39.3231], [-122.08079, 39.32198], [-122.0804, 39.32094], [-122.07979, 39.31908], [-122.07937, 39.31493], [-122.07927, 39.31462], [-122.07907, 39.31426], [-122.07898, 39.31423], [-122.07813, 39.31351], [-122.07679, 39.31232], [-122.07645, 39.31207], [-122.07629, 39.31183], [-122.0763, 39.30439], [-122.07629, 39.29997], [-122.076, 39.29614], [-122.07555, 39.29044], [-122.07534, 39.28844], [-122.07617, 39.28658], [-122.07916, 39.28642], [-122.07923, 39.27563], [-122.07918, 39.2753], [-122.0879, 39.27529], [-122.10451, 39.27532], [-122.11633, 39.27547], [-122.11633, 39.27931], [-122.11636, 39.28698], [-122.11635, 39.28996], [-122.11649, 39.28997], [-122.11646, 39.29316], [-122.11633, 39.30083], [-122.11619, 39.30437], [-122.11625, 39.30799], [-122.11627, 39.31078], [-122.11628, 39.31434], [-122.11625, 39.31789], [-122.11624, 39.32177], [-122.11628, 39.32689], [-122.11632, 39.32944], [-122.11634, 39.33195], [-122.11633, 39.33368], [-122.11643, 39.3364], [-122.11653, 39.34098]]]} | Restricted Access 2 | Delevan National Wildlife Refuge | 18065 | 106 | United States Fish and Wildlife Service 44 | Federal 1 | Federal Agency 1 | http://www.fws.gov/ | US Fish and Wildlife Service 8 | 5703.988 | Delevan NWR | 1962 |
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]);