units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
5 rows where ACCESS_TYP = 2, COUNTY = 11 and MNG_AG_TYP = 1
This data as json, copyable, CSV (advanced)
Suggested facets: SUID_NMA, AGNCY_NAME, AGNCY_LEV, AGNCY_WEB, MNG_AG_ID, YR_EST, GAP_STS
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14324 | 14324 | 14323 | {"type": "Polygon", "coordinates": [[[-122.35854, 38.67935], [-122.35842, 38.68289], [-122.35467, 38.68299], [-122.35479, 38.68008], [-122.3509, 38.68006], [-122.35088, 38.6765], [-122.3509, 38.67651], [-122.35493, 38.67653], [-122.35481, 38.67945], [-122.35854, 38.67935]]]} | Restricted Access 2 | 44307 | United States Bureau of Reclamation | 26666 | 103 | United States Bureau of Reclamation 369 | Federal 1 | Federal Agency 1 | http://www.usbr.gov/ | Other Federal 13 | 103 | United States Bureau of Reclamation 364 | Federal 1 | Federal Agency 1 | Napa 11 | 65.157 | United States Bureau of Reclamation | 0 | Federal Other or Unknown 87 | 4 | |
| 14325 | 14325 | 14324 | {"type": "Polygon", "coordinates": [[[-122.34626, 38.66214], [-122.34624, 38.66945], [-122.34626, 38.67298], [-122.34167, 38.67294], [-122.34167, 38.66942], [-122.33709, 38.66935], [-122.3371, 38.66574], [-122.33254, 38.66574], [-122.33258, 38.66221], [-122.34168, 38.66203], [-122.34626, 38.66214]]]} | Restricted Access 2 | 44308 | United States Bureau of Reclamation | 26666 | 103 | United States Bureau of Reclamation 369 | Federal 1 | Federal Agency 1 | http://www.usbr.gov/ | Other Federal 13 | 103 | United States Bureau of Reclamation 364 | Federal 1 | Federal Agency 1 | Napa 11 | 237.315 | United States Bureau of Reclamation | 0 | Federal Other or Unknown 87 | 4 | |
| 14326 | 14326 | 14325 | {"type": "Polygon", "coordinates": [[[-122.39024, 38.70124], [-122.3763, 38.70106], [-122.37657, 38.68983], [-122.38125, 38.69003], [-122.38112, 38.69738], [-122.39016, 38.69755], [-122.39024, 38.70124]]]} | Restricted Access 2 | 44309 | United States Bureau of Reclamation | 26666 | 103 | United States Bureau of Reclamation 369 | Federal 1 | Federal Agency 1 | http://www.usbr.gov/ | Other Federal 13 | 103 | United States Bureau of Reclamation 364 | Federal 1 | Federal Agency 1 | Napa 11 | 206.55 | United States Bureau of Reclamation | 0 | Federal Other or Unknown 87 | 4 | |
| 15834 | 15834 | 15833 | {"type": "Polygon", "coordinates": [[[-122.33934, 38.15573], [-122.33919, 38.15592], [-122.33894, 38.15637], [-122.33875, 38.15679], [-122.33872, 38.15693], [-122.33861, 38.15714], [-122.33856, 38.15758], [-122.33841, 38.15832], [-122.33829, 38.15856], [-122.33809, 38.15884], [-122.33779, 38.1591], [-122.33759, 38.15913], [-122.33741, 38.15909], [-122.33694, 38.15895], [-122.33503, 38.15824], [-122.33482, 38.15813], [-122.33419, 38.15741], [-122.33391, 38.15692], [-122.33396, 38.15657], [-122.33421, 38.15609], [-122.33447, 38.15581], [-122.33474, 38.15559], [-122.33545, 38.15565], [-122.33538, 38.15569], [-122.33539, 38.15571], [-122.33934, 38.15573]]]} | Restricted Access 2 | 35998 | San Pablo Bay National Wildlife Refuge | 24964 | 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 | Napa 11 | 31.587 | San Pablo Bay NWR | 1970 | National Wildlife Refuge 105 | 2 | |
| 15855 | 15855 | 15854 | {"type": "Polygon", "coordinates": [[[-122.40525, 38.15593], [-122.40518, 38.15666], [-122.40508, 38.15728], [-122.40499, 38.15753], [-122.40485, 38.15777], [-122.4046, 38.15805], [-122.40434, 38.15824], [-122.40366, 38.15857], [-122.40302, 38.15881], [-122.40228, 38.159], [-122.40151, 38.15906], [-122.39974, 38.15901], [-122.39583, 38.15898], [-122.39499, 38.159], [-122.39251, 38.15914], [-122.39105, 38.15916], [-122.38851, 38.15912], [-122.38645, 38.15901], [-122.38456, 38.15884], [-122.38322, 38.15866], [-122.38237, 38.15848], [-122.38056, 38.15787], [-122.37873, 38.15751], [-122.37574, 38.15745], [-122.37394, 38.15744], [-122.37281, 38.15745], [-122.37204, 38.15748], [-122.37137, 38.15755], [-122.37074, 38.15771], [-122.36935, 38.15815], [-122.36896, 38.15829], [-122.36834, 38.15854], [-122.36712, 38.1591], [-122.3662, 38.15877], [-122.36573, 38.15817], [-122.36558, 38.15777], [-122.36522, 38.15586], [-122.38279, 38.15589], [-122.40393, 38.15584], [-122.40423, 38.15594], [-122.40525, 38.15593]]]} | Restricted Access 2 | 44496 | San Pablo Bay National Wildlife Refuge | 24964 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 106 | United States Fish and Wildlife Service 44 | Federal 1 | Federal Agency 1 | Napa 11 | 249.551 | San Pablo Bay NWR | 1970 | 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]);