units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
3 rows where ACCESS_TYP = 2, AGNCY_TYP = 1 and YR_EST = 1962
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, SUID_NMA, AGNCY_ID, AGNCY_NAME, LAYER, MNG_AG_ID, MNG_AG_LEV, LABEL_NAME
Link | rowid ▼ | id | map | ACCESS_TYP | UNIT_ID | UNIT_NAME | SUID_NMA | AGNCY_ID | AGNCY_NAME | AGNCY_LEV | AGNCY_TYP | AGNCY_WEB | LAYER | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | PARK_URL | COUNTY | ACRES | LABEL_NAME | YR_EST | DES_TP | GAP_STS |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6676 | 6676 | 6675 | {"type": "Polygon", "coordinates": [[[-117.1779, 33.42839], [-117.1779, 33.43232], [-117.17339, 33.43239], [-117.17327, 33.42847], [-117.1779, 33.42839]]]} | Restricted Access 2 | 5517 | Santa Margarita Ecological Reserve | 33342 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | http://www.blm.gov/wo/st/en.html | US Bureau of Land Management 1 | 221 | San Diego State University 378 | State 5 | State Agency 5 | https://fsp.sdsu.edu/about-us/ | San Diego 4 | 45.762 | Santa Margarita ER | 1962 | State Conservation Area 8 | 2 |
15568 | 15568 | 15567 | {"type": "MultiPolygon", "coordinates": [[[[-117.15855, 33.46486], [-117.15421, 33.46507], [-117.14524, 33.46588], [-117.14538, 33.46928], [-117.14494, 33.46886], [-117.14213, 33.46585], [-117.13783, 33.46151], [-117.1408, 33.46153], [-117.14069, 33.45434], [-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.15396, 33.4616], [-117.1584, 33.46141], [-117.15855, 33.46486]]], [[[-117.20649, 33.43578], [-117.20644, 33.44303], [-117.19756, 33.44297], [-117.1975, 33.44657], [-117.19305, 33.44653], [-117.19309, 33.44294], [-117.18865, 33.44291], [-117.18876, 33.43575], [-117.19321, 33.43576], [-117.19316, 33.43934], [-117.19759, 33.43937], [-117.19765, 33.43577], [-117.20649, 33.43578]]]]} | Restricted Access 2 | 5509 | Santa Margarita Ecological Reserve | 33342 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | http://www.blm.gov/wo/st/en.html | US Bureau of Land Management 1 | 221 | San Diego State University 378 | State 5 | State Agency 5 | https://fsp.sdsu.edu/about-us/ | Riverside 10 | 1078.683 | Santa Margarita ER | 1962 | State Conservation Area 8 | 2 |
15808 | 15808 | 15807 | {"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.28643], [-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.28997], [-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 | 8687 | Delevan National Wildlife Refuge | 18065 | 106 | United States Fish and Wildlife Service 45 | Federal 1 | Federal Agency 1 | http://www.fws.gov/ | US Fish and Wildlife Service 8 | 106 | United States Fish and Wildlife Service 44 | Federal 1 | Federal Agency 1 | Colusa 49 | 5703.965 | Delevan NWR | 1962 | National Wildlife Refuge 105 | 2 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([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([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);