units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where DES_TP = 2, LABEL_NAME = "Tuckers Grove Park" and MNG_AG_TYP = 3
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6302 | 6302 | 6301 | {"type": "MultiPolygon", "coordinates": [[[[-119.77498, 34.46477], [-119.77385, 34.46839], [-119.7732, 34.46839], [-119.7732, 34.46911], [-119.77251, 34.46862], [-119.77253, 34.4683], [-119.77206, 34.46758], [-119.77217, 34.46752], [-119.77276, 34.46791], [-119.77295, 34.46775], [-119.77232, 34.46728], [-119.77183, 34.46712], [-119.77177, 34.46676], [-119.77187, 34.46645], [-119.77169, 34.46605], [-119.77173, 34.46528], [-119.7717, 34.46476], [-119.77498, 34.46477]]], [[[-119.79223, 34.45174], [-119.79173, 34.45211], [-119.79155, 34.45239], [-119.79156, 34.45359], [-119.78801, 34.45358], [-119.78801, 34.45266], [-119.78748, 34.45287], [-119.78717, 34.4529], [-119.78634, 34.45255], [-119.78598, 34.45255], [-119.78535, 34.4528], [-119.78534, 34.45312], [-119.78542, 34.45332], [-119.78467, 34.45356], [-119.78361, 34.45418], [-119.78415, 34.45508], [-119.7842, 34.4555], [-119.78334, 34.45629], [-119.78311, 34.4564], [-119.78266, 34.45669], [-119.78256, 34.45746], [-119.78194, 34.45821], [-119.78088, 34.45805], [-119.78023, 34.45787], [-119.77977, 34.45846], [-119.77982, 34.45869], [-119.77911, 34.4591], [-119.77894, 34.45964], [-119.77866, 34.46029], [-119.77817, 34.46051], [-119.7779, 34.46108], [-119.77607, 34.4611], [-119.77626, 34.46179], [-119.77563, 34.46273], [-119.77529, 34.46339], [-119.77525, 34.46378], [-119.7736, 34.46379], [-119.77361, 34.46204], [-119.77403, 34.46191], [-119.77527, 34.46129], [-119.77528, 34.46109], [-119.77689, 34.46017], [-119.77698, 34.45946], [-119.77737, 34.45886], [-119.77807, 34.45828], [-119.77827, 34.458], [-119.7784, 34.45778], [-119.77877, 34.45691], [-119.77871, 34.45682], [-119.77868, 34.45673], [-119.77881, 34.45668], [-119.77931, 34.45642], [-119.77997, 34.45631], [-119.7799, 34.45591], [-119.78001, 34.45558], [-119.78025, 34.45532], [-119.78111, 34.4551], [-119.78262, 34.45501], [-119.78226, 34.45446], [-119.78221, 34.45401], [-119.78235, 34.45374], [-119.78277, 34.45323], [-119.78296, 34.45324], [-119.7834, 34.45314], [-119.78403, 34.45269], [-119.78538, 34.45218], [-119.78598, 34.45216], [-119.78802, 34.45231], [-119.78803, 34.45225], [-119.78817, 34.4522], [-119.78839, 34.45202], [-119.78885, 34.45196], [-119.78908, 34.45179], [-119.78916, 34.45158], [-119.78939, 34.45148], [-119.78985, 34.45147], [-119.79014, 34.45164], [-119.79023, 34.45147], [-119.79094, 34.45169], [-119.79135, 34.45177], [-119.79223, 34.45174]]]]} | Open Access 1 | 1434 | Tuckers Grove Park | 26558 | 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 | 111.447 | Tuckers Grove Park | 0 | Local Park 2 | 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]);