units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where COUNTY = 26 and MNG_AGENCY = 1
This data as json, copyable, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11150 | 11150 | 11149 | {"type": "MultiPolygon", "coordinates": [[[[-122.03351, 38.48355], [-122.03249, 38.48361], [-122.03239, 38.48183], [-122.03345, 38.48187], [-122.03351, 38.48355]]], [[[-122.03946, 38.48542], [-122.03946, 38.48542], [-122.03322, 38.48545], [-122.03375, 38.48513], [-122.03417, 38.48477], [-122.03567, 38.48442], [-122.03631, 38.48379], [-122.0368, 38.48319], [-122.03723, 38.48287], [-122.03776, 38.48267], [-122.03808, 38.48219], [-122.03806, 38.48191], [-122.03944, 38.48188], [-122.03946, 38.48542]]], [[[-122.10663, 38.46777], [-122.10175, 38.46781], [-122.10178, 38.47137], [-122.09692, 38.47147], [-122.09695, 38.47847], [-122.10158, 38.47849], [-122.10165, 38.48238], [-122.09693, 38.48236], [-122.09689, 38.48559], [-122.0922, 38.4855], [-122.0925, 38.49092], [-122.09232, 38.49093], [-122.093, 38.50397], [-122.09305, 38.50722], [-122.09316, 38.50723], [-122.09324, 38.51097], [-122.0885, 38.51091], [-122.08834, 38.50388], [-122.07867, 38.50369], [-122.07839, 38.48927], [-122.0784, 38.48237], [-122.08233, 38.48242], [-122.08215, 38.47498], [-122.09179, 38.47496], [-122.09194, 38.47178], [-122.08706, 38.47171], [-122.08718, 38.46813], [-122.09221, 38.46813], [-122.09243, 38.4607], [-122.10661, 38.46096], [-122.10663, 38.46777]]], [[[-122.08306, 38.46779], [-122.08304, 38.4715], [-122.07841, 38.47151], [-122.07847, 38.46769], [-122.08306, 38.46779]]], [[[-122.10652, 38.43207], [-122.10612, 38.43946], [-122.09705, 38.43938], [-122.09698, 38.44612], [-122.09207, 38.44611], [-122.09225, 38.4394], [-122.09704, 38.43937], [-122.09694, 38.43196], [-122.10652, 38.43207]]], [[[-122.10648, 38.50743], [-122.10639, 38.50768], [-122.10582, 38.50758], [-122.10313, 38.50754], [-122.10294, 38.50043], [-122.10581, 38.50041], [-122.10572, 38.50064], [-122.10563, 38.50107], [-122.10562, 38.50191], [-122.10559, 38.50201], [-122.10535, 38.50345], [-122.10534, 38.50377], [-122.10536, 38.50404], [-122.10548, 38.50444], [-122.10562, 38.50509], [-122.10551, 38.5054], [-122.10549, 38.50567], [-122.10541, 38.50605], [-122.10548, 38.50623], [-122.1058, 38.50658], [-122.10596, 38.50682], [-122.10605, 38.50687], [-122.10622, 38.50713], [-122.10648, 38.50743]]], [[[-122.10898, 38.48246], [-122.10892, 38.48297], [-122.10882, 38.48345], [-122.10874, 38.48444], [-122.10865, 38.48497], [-122.10853, 38.48536], [-122.10844, 38.48559], [-122.10807, 38.48624], [-122.10791, 38.48639], [-122.10711, 38.48699], [-122.10692, 38.48719], [-122.10667, 38.4875], [-122.10633, 38.48814], [-122.10632, 38.48244], [-122.10898, 38.48246]]], [[[-122.10656, 38.49686], [-122.10655, 38.49628], [-122.10651, 38.4939], [-122.10673, 38.49398], [-122.1069, 38.49406], [-122.10707, 38.4942], [-122.10725, 38.49454], [-122.1073, 38.49486], [-122.1073, 38.49507], [-122.10721, 38.49546], [-122.10695, 38.49617], [-122.10686, 38.49636], [-122.10656, 38.49686]]], [[[-122.11892, 38.46099], [-122.11876, 38.46147], [-122.11852, 38.46199], [-122.11833, 38.46226], [-122.11817, 38.46255], [-122.11782, 38.46309], [-122.11763, 38.46348], [-122.11758, 38.46373], [-122.11743, 38.46414], [-122.11727, 38.46469], [-122.117, 38.4652], [-122.1166, 38.46574], [-122.11648, 38.46594], [-122.1156, 38.46759], [-122.11545, 38.4679], [-122.11533, 38.4682], [-122.11514, 38.46895], [-122.11462, 38.47026], [-122.11443, 38.47101], [-122.11413, 38.47165], [-122.11386, 38.47232], [-122.11363, 38.4733], [-122.11344, 38.47403], [-122.11318, 38.47487], [-122.1131, 38.47508], [-122.11299, 38.47528], [-122.11048, 38.47527], [-122.11038, 38.46479], [-122.11542, 38.4648], [-122.11552, 38.4611], [-122.11892, 38.46099]]], [[[-122.12518, 38.43695], [-122.12516, 38.44], [-122.12472, 38.44], [-122.12472, 38.44], [-122.12518, 38.43695]]]]} | Open Access 1 | 21506 | BLM | 16162 | 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 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | Solano 26 | 2071.269 | BLM | 1899 | National Public Lands 1 | 3 |
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]);