units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where AGNCY_TYP = 5, DES_TP = 1126 and MNG_AG_TYP = 5
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12996 | 12996 | 12995 | {"type": "MultiPolygon", "coordinates": [[[[-121.92127, 38.19194], [-121.91854, 38.19374], [-121.91574, 38.19573], [-121.91574, 38.19664], [-121.91476, 38.1968], [-121.91375, 38.19641], [-121.91365, 38.19636], [-121.91357, 38.19628], [-121.91352, 38.19618], [-121.91352, 38.1961], [-121.9135, 38.19605], [-121.91345, 38.19603], [-121.91339, 38.19604], [-121.91318, 38.19589], [-121.91285, 38.19572], [-121.91274, 38.19562], [-121.91261, 38.19545], [-121.91254, 38.19541], [-121.91244, 38.19538], [-121.91237, 38.19529], [-121.91236, 38.19521], [-121.91262, 38.19436], [-121.91269, 38.19393], [-121.91283, 38.1934], [-121.91277, 38.19313], [-121.91264, 38.19288], [-121.91249, 38.19275], [-121.91235, 38.19267], [-121.91215, 38.19261], [-121.91198, 38.19258], [-121.91182, 38.19258], [-121.91167, 38.1926], [-121.91152, 38.19265], [-121.9114, 38.19272], [-121.91113, 38.19277], [-121.91057, 38.19283], [-121.91038, 38.19287], [-121.91021, 38.19288], [-121.91001, 38.19287], [-121.90983, 38.19283], [-121.90945, 38.19267], [-121.90921, 38.19259], [-121.90913, 38.19246], [-121.90911, 38.1923], [-121.90913, 38.19218], [-121.90923, 38.19194], [-121.90929, 38.19169], [-121.90923, 38.19129], [-121.90916, 38.1911], [-121.90913, 38.1909], [-121.90898, 38.19057], [-121.90887, 38.19036], [-121.90862, 38.19011], [-121.90843, 38.18997], [-121.90826, 38.18987], [-121.90783, 38.18971], [-121.90753, 38.18957], [-121.90715, 38.18945], [-121.90686, 38.18933], [-121.90651, 38.18917], [-121.90618, 38.18898], [-121.9053, 38.18834], [-121.90461, 38.18782], [-121.9044, 38.18768], [-121.90423, 38.18754], [-121.90409, 38.18738], [-121.90357, 38.18672], [-121.9034, 38.18643], [-121.90328, 38.18618], [-121.90293, 38.18561], [-121.90286, 38.18538], [-121.90281, 38.18511], [-121.9028, 38.1849], [-121.90285, 38.1847], [-121.90296, 38.1845], [-121.90302, 38.18445], [-121.90313, 38.18439], [-121.90317, 38.18434], [-121.90541, 38.18435], [-121.91198, 38.18678], [-121.91309, 38.18661], [-121.91614, 38.18718], [-121.91727, 38.18776], [-121.91876, 38.18968], [-121.91938, 38.18917], [-121.92018, 38.19017], [-121.92127, 38.19194]]], [[[-121.91674, 38.17797], [-121.91647, 38.1782], [-121.91596, 38.17847], [-121.91566, 38.17866], [-121.9156, 38.17868], [-121.91494, 38.17906], [-121.91421, 38.17945], [-121.91394, 38.17962], [-121.91371, 38.17973], [-121.91332, 38.17998], [-121.91255, 38.1804], [-121.91192, 38.18088], [-121.91185, 38.18096], [-121.9118, 38.18111], [-121.91181, 38.18119], [-121.91184, 38.1813], [-121.91181, 38.18139], [-121.91175, 38.18146], [-121.91161, 38.18155], [-121.91119, 38.18165], [-121.91078, 38.1817], [-121.91023, 38.18172], [-121.90978, 38.1817], [-121.90965, 38.18169], [-121.90949, 38.18165], [-121.90922, 38.18153], [-121.90895, 38.18135], [-121.90875, 38.18124], [-121.90846, 38.18105], [-121.90793, 38.18073], [-121.90767, 38.18052], [-121.90717, 38.18027], [-121.90678, 38.18026], [-121.9064, 38.1802], [-121.906, 38.18024], [-121.9059, 38.18001], [-121.90607, 38.17992], [-121.90618, 38.1794], [-121.9068, 38.17901], [-121.90781, 38.17827], [-121.90792, 38.17805], [-121.90834, 38.178], [-121.90865, 38.17804], [-121.90901, 38.17793], [-121.91056, 38.17653], [-121.91138, 38.17601], [-121.91228, 38.17572], [-121.91309, 38.17558], [-121.91395, 38.17566], [-121.91467, 38.1759], [-121.9154, 38.17617], [-121.91569, 38.17635], [-121.91656, 38.17754], [-121.91674, 38.17797]]]]} | Open Access 1 | 46936 | Suisun Marsh | 30555 | 207 | California Department of Water Resources 477 | State 5 | State Agency 5 | http://www.water.ca.gov/ | Other State 5 | 207 | California Department of Water Resources 470 | State 5 | State Agency 5 | http://www.water.ca.gov/suisun/ | Solano 26 | 333.295 | Suisun Marsh | None 1126 |
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]);