units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where AGNCY_ID = 207, DES_TP = 1269, LAYER = 5 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14789 | 14789 | 14788 | {"type": "MultiPolygon", "coordinates": [[[[-121.67671, 38.12353], [-121.67671, 38.12362], [-121.67609, 38.12365], [-121.67519, 38.12376], [-121.67519, 38.12369], [-121.67671, 38.12353]]], [[[-121.677, 38.09464], [-121.67671, 38.12346], [-121.67519, 38.12362], [-121.67519, 38.12311], [-121.67433, 38.1231], [-121.67432, 38.1237], [-121.67391, 38.12375], [-121.673, 38.12391], [-121.67231, 38.12397], [-121.67231, 38.12402], [-121.67244, 38.12403], [-121.67302, 38.12397], [-121.67392, 38.12382], [-121.67427, 38.12377], [-121.67432, 38.12377], [-121.67432, 38.12383], [-121.67284, 38.12405], [-121.6724, 38.12409], [-121.67197, 38.12409], [-121.67153, 38.12404], [-121.67024, 38.12355], [-121.66977, 38.12339], [-121.66934, 38.12331], [-121.66891, 38.12328], [-121.66854, 38.12329], [-121.66785, 38.12343], [-121.667, 38.12357], [-121.66597, 38.12364], [-121.66575, 38.12361], [-121.6656, 38.12356], [-121.66541, 38.12344], [-121.66522, 38.12326], [-121.66503, 38.12304], [-121.66506, 38.11139], [-121.66316, 38.11139], [-121.66311, 38.11771], [-121.66049, 38.1177], [-121.66048, 38.11854], [-121.66035, 38.11879], [-121.66036, 38.11926], [-121.66041, 38.11969], [-121.6604, 38.11983], [-121.66027, 38.11994], [-121.66001, 38.11999], [-121.65989, 38.11998], [-121.65936, 38.11983], [-121.65884, 38.11963], [-121.65762, 38.1191], [-121.6569, 38.11885], [-121.6562, 38.11866], [-121.65537, 38.1185], [-121.65475, 38.11836], [-121.65441, 38.11826], [-121.65412, 38.11815], [-121.65381, 38.11799], [-121.6533, 38.11765], [-121.65302, 38.11751], [-121.65172, 38.11697], [-121.65113, 38.11677], [-121.65071, 38.11675], [-121.6504, 38.11684], [-121.65022, 38.117], [-121.65005, 38.11723], [-121.64993, 38.11752], [-121.64984, 38.11769], [-121.64969, 38.11789], [-121.64948, 38.11808], [-121.64923, 38.11821], [-121.64872, 38.11835], [-121.64812, 38.11839], [-121.64695, 38.11835], [-121.64556, 38.11824], [-121.64368, 38.11824], [-121.64327, 38.11823], [-121.64246, 38.11815], [-121.64156, 38.11802], [-121.64025, 38.11787], [-121.63947, 38.11783], [-121.63802, 38.11772], [-121.63556, 38.11756], [-121.63522, 38.11752], [-121.63439, 38.11738], [-121.63347, 38.11716], [-121.63271, 38.11702], [-121.63209, 38.11692], [-121.63178, 38.11689], [-121.63139, 38.11681], [-121.63053, 38.11667], [-121.63019, 38.11663], [-121.63005, 38.11666], [-121.63, 38.11673], [-121.62991, 38.11671], [-121.63001, 38.11642], [-121.62876, 38.11581], [-121.62876, 38.1155], [-121.62502, 38.11531], [-121.62233, 38.11503], [-121.62029, 38.11435], [-121.61852, 38.1134], [-121.61756, 38.11243], [-121.61647, 38.11238], [-121.61598, 38.11201], [-121.61553, 38.11156], [-121.61533, 38.11131], [-121.61502, 38.11035], [-121.61505, 38.10969], [-121.61497, 38.10904], [-121.61491, 38.10873], [-121.61484, 38.10853], [-121.61481, 38.10834], [-121.6149, 38.10787], [-121.61495, 38.10769], [-121.61496, 38.10721], [-121.61494, 38.10704], [-121.61498, 38.10687], [-121.61508, 38.10668], [-121.61503, 38.10644], [-121.61546, 38.10649], [-121.61835, 38.10649], [-121.61836, 38.10648], [-121.61832, 38.10618], [-121.62086, 38.10615], [-121.62081, 38.10459], [-121.62361, 38.10443], [-121.62435, 38.10436], [-121.62558, 38.10431], [-121.62609, 38.10416], [-121.62649, 38.10413], [-121.62824, 38.10342], [-121.62914, 38.10308], [-121.62969, 38.10279], [-121.63049, 38.10243], [-121.63081, 38.10213], [-121.631, 38.10184], [-121.63131, 38.10158], [-121.63145, 38.10128], [-121.63214, 38.10079], [-121.63278, 38.10028], [-121.63354, 38.09935], [-121.63369, 38.09919], [-121.63382, 38.0989], [-121.63407, 38.09842], [-121.63437, 38.09792], [-121.6347, 38.09761], [-121.63388, 38.09619], [-121.63389, 38.09598], [-121.63393, 38.09581], [-121.63397, 38.09551], [-121.63407, 38.09377], [-121.63421, 38.09327], [-121.63421, 38.0931], [-121.63432, 38.09259], [-121.63439, 38.0924], [-121.63487, 38.09161], [-121.63513, 38.09123], [-121.63551, 38.09075], [-121.63607, 38.09022], [-121.63648, 38.08998], [-121.63675, 38.08988], [-121.63702, 38.08988], [-121.63812, 38.0902], [-121.63936, 38.09051], [-121.63952, 38.09049], [-121.6396, 38.0905], [-121.63995, 38.09059], [-121.64041, 38.09065], [-121.64058, 38.09071], [-121.64078, 38.09071], [-121.6417, 38.09084], [-121.64237, 38.09102], [-121.64314, 38.09126], [-121.64404, 38.09165], [-121.64427, 38.09183], [-121.64453, 38.09193], [-121.64535, 38.0929], [-121.64545, 38.09305], [-121.64559, 38.09331], [-121.6457, 38.09369], [-121.64577, 38.09379], [-121.64587, 38.09387], [-121.64599, 38.09394], [-121.6463, 38.09403], [-121.64717, 38.09405], [-121.64727, 38.09408], [-121.64737, 38.09413], [-121.64775, 38.09452], [-121.64802, 38.09471], [-121.64824, 38.09478], [-121.64877, 38.09489], [-121.64911, 38.09497], [-121.6494, 38.09511], [-121.64967, 38.09528], [-121.64997, 38.09541], [-121.6501, 38.0955], [-121.65063, 38.09577], [-121.65165, 38.09608], [-121.65274, 38.09654], [-121.6535, 38.09683], [-121.65458, 38.0972], [-121.65889, 38.09816], [-121.66023, 38.09837], [-121.66067, 38.0984], [-121.66149, 38.09843], [-121.66186, 38.0984], [-121.66261, 38.09826], [-121.66303, 38.09826], [-121.66336, 38.09831], [-121.66408, 38.09833], [-121.6645, 38.0983], [-121.66543, 38.09829], [-121.66595, 38.09826], [-121.66615, 38.09826], [-121.66631, 38.09825], [-121.66648, 38.09822], [-121.6668, 38.0982], [-121.66708, 38.09813], [-121.66782, 38.09788], [-121.66798, 38.09779], [-121.66818, 38.09767], [-121.66842, 38.09756], [-121.66856, 38.09752], [-121.66871, 38.09752], [-121.66894, 38.09752], [-121.66924, 38.09755], [-121.66953, 38.09753], [-121.67133, 38.09707], [-121.67165, 38.09696], [-121.67234, 38.09666], [-121.67485, 38.09569], [-121.67579, 38.09526], [-121.677, 38.09464]], [[-121.6754, 38.09693], [-121.67557, 38.09706], [-121.67627, 38.09679], [-121.67589, 38.09616], [-121.67439, 38.09672], [-121.67436, 38.09669], [-121.6733, 38.0971], [-121.67361, 38.0976], [-121.6754, 38.09693]], [[-121.65142, 38.11674], [-121.65143, 38.11673], [-121.65144, 38.11598], [-121.65083, 38.11573], [-121.65082, 38.11657], [-121.65099, 38.11659], [-121.65115, 38.11663], [-121.65142, 38.11674]]]]} | No Public Access 3 | 45157 | Twitchel Island | 26625 | 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 | Sacramento 41 | 2965.613 | Twitchel Island | 0 | None 1269 |
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]);