units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where AGNCY_NAME = 777, COUNTY = 4 and MNG_AG_TYP = 4
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7618 | 7618 | 7617 | {"type": "MultiPolygon", "coordinates": [[[[-116.58828, 32.9905], [-116.58825, 32.99071], [-116.58818, 32.9909], [-116.58801, 32.99116], [-116.5879, 32.99127], [-116.58761, 32.99148], [-116.5874, 32.99157], [-116.58719, 32.99163], [-116.5869, 32.99167], [-116.58665, 32.99166], [-116.58142, 32.99099], [-116.5814, 32.99108], [-116.58108, 32.99104], [-116.58084, 32.991], [-116.58063, 32.99093], [-116.58048, 32.99088], [-116.57988, 32.9906], [-116.57971, 32.99055], [-116.57949, 32.99055], [-116.57933, 32.99059], [-116.57914, 32.99068], [-116.57896, 32.99083], [-116.57867, 32.99102], [-116.57852, 32.99107], [-116.57837, 32.9911], [-116.57793, 32.99107], [-116.57771, 32.99101], [-116.57685, 32.99067], [-116.57675, 32.99065], [-116.57647, 32.99066], [-116.57626, 32.99071], [-116.57605, 32.99081], [-116.57587, 32.99094], [-116.57568, 32.99114], [-116.57548, 32.9913], [-116.57545, 32.99118], [-116.57544, 32.99118], [-116.57368, 32.99185], [-116.57278, 32.99241], [-116.57137, 32.99369], [-116.56793, 32.99529], [-116.56657, 32.99852], [-116.56638, 32.99902], [-116.56548, 33.00118], [-116.56333, 33.00224], [-116.56291, 33.00372], [-116.56374, 33.00577], [-116.56384, 33.00633], [-116.5638, 33.00661], [-116.56173, 33.00851], [-116.56074, 33.01059], [-116.5602, 33.01038], [-116.55982, 33.01017], [-116.55945, 33.00989], [-116.5593, 33.00975], [-116.55914, 33.00956], [-116.55893, 33.00928], [-116.55868, 33.00889], [-116.55871, 33.00846], [-116.55796, 33.00715], [-116.55889, 33.00477], [-116.55844, 33.00404], [-116.55765, 33.00348], [-116.55654, 33.0018], [-116.55354, 33.00214], [-116.5523, 33.00058], [-116.55155, 32.99892], [-116.55205, 32.99793], [-116.55211, 32.99628], [-116.55325, 32.9954], [-116.55471, 32.99537], [-116.5569, 32.99538], [-116.55636, 32.99378], [-116.55535, 32.99255], [-116.55513, 32.99154], [-116.55526, 32.99138], [-116.55652, 32.98959], [-116.55693, 32.98801], [-116.55725, 32.98657], [-116.55803, 32.98589], [-116.5583, 32.9844], [-116.56187, 32.9836], [-116.56188, 32.98227], [-116.56635, 32.98249], [-116.56636, 32.98312], [-116.56747, 32.98414], [-116.56898, 32.98471], [-116.56935, 32.98534], [-116.56921, 32.9856], [-116.56929, 32.9864], [-116.56943, 32.98702], [-116.56962, 32.98713], [-116.57098, 32.98721], [-116.57129, 32.98711], [-116.57157, 32.98694], [-116.57204, 32.98548], [-116.57271, 32.98562], [-116.57335, 32.98626], [-116.57363, 32.98619], [-116.57605, 32.98533], [-116.57692, 32.98421], [-116.57714, 32.98288], [-116.57697, 32.98202], [-116.57662, 32.98137], [-116.57615, 32.9811], [-116.57521, 32.98117], [-116.57385, 32.98191], [-116.57299, 32.98196], [-116.57165, 32.98146], [-116.57102, 32.98066], [-116.5713, 32.98014], [-116.57341, 32.98094], [-116.57566, 32.97928], [-116.57639, 32.978], [-116.57747, 32.97841], [-116.57837, 32.97822], [-116.57879, 32.97782], [-116.57898, 32.97751], [-116.58028, 32.97747], [-116.58088, 32.97794], [-116.58068, 32.97842], [-116.58069, 32.97857], [-116.58058, 32.97883], [-116.58052, 32.97945], [-116.58088, 32.97945], [-116.58105, 32.98054], [-116.58105, 32.98062], [-116.58099, 32.98084], [-116.58069, 32.98145], [-116.58065, 32.9816], [-116.58066, 32.98181], [-116.58076, 32.98207], [-116.58157, 32.98307], [-116.58165, 32.98322], [-116.582, 32.98456], [-116.58201, 32.9848], [-116.58199, 32.98488], [-116.58199, 32.98499], [-116.58201, 32.98513], [-116.58212, 32.9854], [-116.58228, 32.98559], [-116.58245, 32.98572], [-116.58261, 32.9858], [-116.58292, 32.98591], [-116.58308, 32.98605], [-116.58316, 32.98614], [-116.58325, 32.98628], [-116.5833, 32.98658], [-116.58428, 32.98766], [-116.58443, 32.98778], [-116.58457, 32.98785], [-116.58482, 32.98793], [-116.58541, 32.98797], [-116.58564, 32.98803], [-116.58576, 32.98807], [-116.58654, 32.98843], [-116.58647, 32.9885], [-116.58648, 32.98851], [-116.5866, 32.98856], [-116.58682, 32.98869], [-116.58698, 32.98883], [-116.58708, 32.98895], [-116.58734, 32.98907], [-116.58763, 32.98942], [-116.58797, 32.98965], [-116.58814, 32.98999], [-116.58819, 32.99043], [-116.58828, 32.99044], [-116.58828, 32.9905]]], [[[-116.55887, 33.00971], [-116.55857, 33.00969], [-116.55861, 33.00936], [-116.55873, 33.00954], [-116.55887, 33.00971]]], [[[-116.56489, 33.01495], [-116.56489, 33.01495], [-116.56483, 33.02105], [-116.56391, 33.0168], [-116.56255, 33.01679], [-116.5626, 33.01656], [-116.56264, 33.01612], [-116.56264, 33.01583], [-116.56262, 33.01571], [-116.56258, 33.01556], [-116.56251, 33.01542], [-116.56188, 33.01444], [-116.56175, 33.01414], [-116.56132, 33.01258], [-116.56125, 33.01223], [-116.56121, 33.01185], [-116.56121, 33.01153], [-116.56121, 33.01124], [-116.56125, 33.01102], [-116.56158, 33.01114], [-116.564, 33.01328], [-116.56489, 33.01495]]], [[[-116.58571, 32.99196], [-116.58562, 32.99276], [-116.58476, 32.99272], [-116.58486, 32.99176], [-116.58558, 32.99185], [-116.58571, 32.99196]]]]} | Open Access 1 | 47619 | Lake Cuyamaca | 20881 | 2046 | Helix Water District 777 | Special District 4 | Water District 13 | http://www.hwd.com | Special District 4 | 2058 | Lake Cuyamaca Park and Recreation District 853 | Special District 4 | Recreation/Parks District 4 | http://www.lakecuyamaca.org/ | San Diego 4 | 1116.016 | Lake Cuyamaca | None 635 |
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]);