units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where GAP_STS = 2, MNG_AGENCY = 142 and MNG_AG_TYP = 1
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- Federal Agency · 1 ✖
MNG_AGENCY 1
- United States Army Corps of Engineers · 1 ✖
DES_TP 1
ACCESS_TYP 1
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 660 | 660 | 659 | {"type": "MultiPolygon", "coordinates": [[[[-118.47757, 34.17694], [-118.47653, 34.17753], [-118.47638, 34.17727], [-118.47491, 34.17726], [-118.47488, 34.17866], [-118.47404, 34.17875], [-118.4726, 34.17833], [-118.47255, 34.17833], [-118.47049, 34.17932], [-118.46982, 34.17835], [-118.46942, 34.17769], [-118.46908, 34.17704], [-118.46886, 34.17653], [-118.46876, 34.17623], [-118.46858, 34.17554], [-118.46851, 34.17511], [-118.46844, 34.1746], [-118.46841, 34.17384], [-118.46841, 34.17257], [-118.46879, 34.17257], [-118.46895, 34.17247], [-118.47109, 34.17243], [-118.4711, 34.1725], [-118.47273, 34.1725], [-118.47327, 34.17247], [-118.47381, 34.17242], [-118.47429, 34.17235], [-118.4747, 34.17228], [-118.4754, 34.17212], [-118.47554, 34.17212], [-118.47694, 34.17548], [-118.47723, 34.17608], [-118.47722, 34.17631], [-118.4774, 34.17666], [-118.47757, 34.17694]]], [[[-118.47739, 34.17084], [-118.4769, 34.17105], [-118.47556, 34.17153], [-118.47499, 34.17158], [-118.47358, 34.17183], [-118.47208, 34.17194], [-118.46878, 34.17196], [-118.46878, 34.17102], [-118.46911, 34.17021], [-118.46977, 34.16964], [-118.47092, 34.16895], [-118.4726, 34.16817], [-118.47276, 34.16826], [-118.47323, 34.1681], [-118.47413, 34.16763], [-118.47438, 34.16819], [-118.47571, 34.16965], [-118.47622, 34.1701], [-118.47659, 34.17037], [-118.47706, 34.17067], [-118.47739, 34.17084]]], [[[-118.48363, 34.18069], [-118.48361, 34.18069], [-118.4834, 34.1804], [-118.48315, 34.18014], [-118.47855, 34.17705], [-118.47836, 34.1769], [-118.47815, 34.17669], [-118.47799, 34.17649], [-118.47783, 34.1762], [-118.47595, 34.17177], [-118.47741, 34.17146], [-118.478, 34.17119], [-118.48123, 34.17251], [-118.48092, 34.17304], [-118.48094, 34.17432], [-118.48076, 34.17439], [-118.48075, 34.1744], [-118.48207, 34.1758], [-118.48338, 34.17578], [-118.48342, 34.17774], [-118.48359, 34.17867], [-118.48363, 34.18069]]], [[[-118.50099, 34.18172], [-118.50099, 34.18456], [-118.50095, 34.1855], [-118.50094, 34.18587], [-118.49857, 34.18587], [-118.49856, 34.18608], [-118.49253, 34.18608], [-118.49254, 34.18527], [-118.49305, 34.18528], [-118.49331, 34.18519], [-118.49344, 34.18507], [-118.49351, 34.18486], [-118.49351, 34.18461], [-118.49346, 34.18436], [-118.49679, 34.18321], [-118.49715, 34.18293], [-118.49763, 34.18229], [-118.49761, 34.18051], [-118.49826, 34.18052], [-118.49842, 34.18053], [-118.49856, 34.18058], [-118.49941, 34.18129], [-118.49962, 34.18137], [-118.50004, 34.18139], [-118.50016, 34.18144], [-118.50064, 34.18171], [-118.50079, 34.18175], [-118.50093, 34.18174], [-118.50099, 34.18172]]]]} | Open Access 1 | 3261 | Sepulveda Basin Wildlife Reserve | 13591 | 100 | United States Army Corps of Engineers 146 | Federal 1 | Federal Agency 1 | http://www.usace.army.mil/ | Other Federal 13 | 100 | United States Army Corps of Engineers 142 | Federal 1 | Federal Agency 1 | http://sepulvedabasinwildlife.org/ | Los Angeles 6 | 327.332 | Sepulveda Basin Wildlife Reserve | 0 | Conservation Area 13 | 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]);