units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 4, LABEL_NAME = "El Mission Creek" and MNG_AGENCY = 7
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4863 | 4863 | 4862 | {"type": "MultiPolygon", "coordinates": [[[[-119.70446, 34.41592], [-119.70424, 34.41613], [-119.70413, 34.41605], [-119.70419, 34.41599], [-119.70419, 34.41598], [-119.70404, 34.41596], [-119.70425, 34.41577], [-119.70446, 34.41592]]], [[[-119.70685, 34.41659], [-119.70669, 34.41678], [-119.7063, 34.4165], [-119.70614, 34.41646], [-119.70575, 34.41648], [-119.70547, 34.41645], [-119.70524, 34.41628], [-119.70536, 34.41617], [-119.70546, 34.41624], [-119.70567, 34.4163], [-119.70578, 34.41631], [-119.70609, 34.4163], [-119.70614, 34.41611], [-119.70651, 34.41638], [-119.70658, 34.4164], [-119.70685, 34.41659]]], [[[-119.70983, 34.41818], [-119.70962, 34.41838], [-119.70935, 34.41819], [-119.70897, 34.41794], [-119.70718, 34.41712], [-119.70694, 34.41694], [-119.70715, 34.41674], [-119.70759, 34.41702], [-119.70878, 34.41758], [-119.70922, 34.41781], [-119.70983, 34.41818]]], [[[-119.71422, 34.42244], [-119.71392, 34.42193], [-119.71369, 34.42125], [-119.71359, 34.42118], [-119.7136, 34.42116], [-119.71335, 34.42103], [-119.71095, 34.41928], [-119.71092, 34.41929], [-119.71027, 34.41881], [-119.71045, 34.41863], [-119.71376, 34.42102], [-119.71375, 34.42104], [-119.71445, 34.42169], [-119.71451, 34.42176], [-119.71457, 34.42188], [-119.71459, 34.422], [-119.71458, 34.42209], [-119.71452, 34.42226], [-119.71422, 34.42244]]], [[[-119.71602, 34.42306], [-119.71596, 34.42311], [-119.71571, 34.42293], [-119.71503, 34.42272], [-119.71492, 34.42281], [-119.71462, 34.42268], [-119.7148, 34.42245], [-119.71508, 34.42266], [-119.71527, 34.42272], [-119.71547, 34.42272], [-119.71565, 34.42277], [-119.71602, 34.42306]]], [[[-119.71871, 34.4248], [-119.71859, 34.42481], [-119.71853, 34.42497], [-119.7185, 34.42501], [-119.7185, 34.42485], [-119.71848, 34.42476], [-119.7184, 34.42456], [-119.71827, 34.42439], [-119.71817, 34.42433], [-119.71797, 34.4243], [-119.71792, 34.42426], [-119.71803, 34.42416], [-119.71837, 34.42443], [-119.71871, 34.4248]]], [[[-119.71973, 34.42579], [-119.71956, 34.42597], [-119.71905, 34.42559], [-119.71906, 34.42556], [-119.71868, 34.42528], [-119.71893, 34.42505], [-119.71881, 34.42495], [-119.71886, 34.42491], [-119.71973, 34.42579]]], [[[-119.72436, 34.42678], [-119.72408, 34.42674], [-119.7239, 34.42666], [-119.72379, 34.42667], [-119.72365, 34.42666], [-119.72345, 34.42659], [-119.72288, 34.42652], [-119.72194, 34.42634], [-119.72175, 34.42632], [-119.72189, 34.42619], [-119.72247, 34.42632], [-119.72345, 34.42645], [-119.7239, 34.42657], [-119.72436, 34.42678]]]]} | Unknown Access 4 | 14691 | El Mission Creek | 18513 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 9.467 | El Mission Creek | 0 | Local Other or Unknown 14 | 4 |
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]);