units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 1, AGNCY_LEV = 3, AGNCY_WEB = "http://www.co.sanmateo.ca.us/portal/site/parks/" and DES_TP = 655
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7831 | 7831 | 7830 | {"type": "Polygon", "coordinates": [[[-122.51046, 37.51201], [-122.51023, 37.51234], [-122.50987, 37.51294], [-122.50983, 37.51292], [-122.50706, 37.51697], [-122.50076, 37.5116], [-122.50136, 37.51061], [-122.50087, 37.51021], [-122.50163, 37.50897], [-122.50091, 37.50795], [-122.50104, 37.50785], [-122.50038, 37.50695], [-122.50001, 37.50719], [-122.49898, 37.50631], [-122.49883, 37.50653], [-122.49817, 37.50681], [-122.49557, 37.50574], [-122.4949, 37.50607], [-122.49505, 37.50582], [-122.49492, 37.50576], [-122.4946, 37.5047], [-122.494, 37.5042], [-122.49436, 37.5036], [-122.49452, 37.50365], [-122.49471, 37.50331], [-122.49457, 37.50324], [-122.49472, 37.50299], [-122.49465, 37.50191], [-122.49398, 37.50143], [-122.49432, 37.50124], [-122.49578, 37.50023], [-122.49585, 37.50037], [-122.49593, 37.50051], [-122.49634, 37.50095], [-122.49652, 37.50132], [-122.49654, 37.50142], [-122.49664, 37.50204], [-122.49673, 37.50251], [-122.49673, 37.50345], [-122.4967, 37.5036], [-122.49666, 37.50368], [-122.49674, 37.50378], [-122.49841, 37.50458], [-122.49871, 37.50239], [-122.49742, 37.50097], [-122.4972, 37.49987], [-122.4983, 37.49966], [-122.49979, 37.49844], [-122.49984, 37.49849], [-122.49978, 37.49862], [-122.49996, 37.49876], [-122.50002, 37.49897], [-122.49996, 37.49897], [-122.49914, 37.49951], [-122.49909, 37.4997], [-122.49903, 37.50002], [-122.49892, 37.50017], [-122.49884, 37.50042], [-122.49887, 37.50077], [-122.49902, 37.50115], [-122.49912, 37.50132], [-122.49954, 37.50174], [-122.49966, 37.50174], [-122.49981, 37.50193], [-122.49974, 37.50204], [-122.49974, 37.50223], [-122.49983, 37.50247], [-122.50002, 37.50288], [-122.50028, 37.50332], [-122.50044, 37.50343], [-122.50067, 37.50356], [-122.5011, 37.50398], [-122.50167, 37.50469], [-122.5019, 37.50487], [-122.50202, 37.50501], [-122.50209, 37.50507], [-122.50219, 37.50512], [-122.50229, 37.50513], [-122.50238, 37.50519], [-122.50258, 37.50522], [-122.50271, 37.50536], [-122.5029, 37.50543], [-122.50306, 37.50554], [-122.50325, 37.50562], [-122.50351, 37.50578], [-122.50374, 37.50595], [-122.50383, 37.506], [-122.50403, 37.50606], [-122.50419, 37.50617], [-122.5043, 37.50616], [-122.50462, 37.5062], [-122.50481, 37.50628], [-122.50487, 37.50634], [-122.50492, 37.50641], [-122.50515, 37.5066], [-122.50542, 37.50688], [-122.5056, 37.50697], [-122.50566, 37.50704], [-122.50581, 37.50716], [-122.50591, 37.50731], [-122.50598, 37.50738], [-122.5061, 37.50752], [-122.50625, 37.50776], [-122.50632, 37.50783], [-122.50638, 37.508], [-122.50646, 37.50806], [-122.50657, 37.5082], [-122.50664, 37.50827], [-122.50674, 37.50843], [-122.50687, 37.50857], [-122.507, 37.5088], [-122.50738, 37.50922], [-122.50761, 37.5094], [-122.5077, 37.50956], [-122.5078, 37.50965], [-122.50804, 37.50923], [-122.50827, 37.50949], [-122.5092, 37.51101], [-122.51046, 37.51201]], [[-122.49897, 37.5063], [-122.49912, 37.50606], [-122.49883, 37.50595], [-122.49869, 37.50619], [-122.49897, 37.5063]]]} | Open Access 1 | 9314 | Pillar Point Bluff | 23670 | 324 | San Mateo County Parks and Recreation Dept., County of 28 | County 3 | County Agency - Parks 7 | http://www.co.sanmateo.ca.us/portal/site/parks/ | County 3 | 324 | San Mateo County Parks and Recreation Dept., County of 28 | County 3 | County Agency - Parks 7 | San Mateo 15 | 226.452 | Pillar Point Bluff | None 655 |
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]);