units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where COUNTY = 7, DES_TP = 3, MNG_AGENCY = 7 and UNIT_NAME = "University Circle Open Space"
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
MNG_AGENCY 1
- Santa Barbara, County of · 1 ✖
DES_TP 1
- Local Recreation Area · 1 ✖
ACCESS_TYP 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6333 | 6333 | 6332 | {"type": "MultiPolygon", "coordinates": [[[[-119.81783, 34.44343], [-119.81777, 34.44362], [-119.81759, 34.44372], [-119.81675, 34.44373], [-119.81574, 34.44462], [-119.81576, 34.44491], [-119.81593, 34.4456], [-119.81594, 34.44587], [-119.81525, 34.44586], [-119.81511, 34.44584], [-119.81508, 34.44583], [-119.81506, 34.44578], [-119.81514, 34.44535], [-119.81518, 34.44473], [-119.8152, 34.44462], [-119.81527, 34.44446], [-119.81546, 34.44422], [-119.81556, 34.44403], [-119.81563, 34.4438], [-119.81568, 34.44357], [-119.81735, 34.44366], [-119.81742, 34.44341], [-119.81783, 34.44343]]], [[[-119.81606, 34.4464], [-119.81623, 34.44693], [-119.81622, 34.44703], [-119.81614, 34.44723], [-119.81604, 34.44766], [-119.81591, 34.4481], [-119.8159, 34.44838], [-119.816, 34.44868], [-119.81541, 34.44868], [-119.81543, 34.44863], [-119.81542, 34.44862], [-119.81444, 34.44862], [-119.81443, 34.44848], [-119.81445, 34.44835], [-119.81449, 34.44821], [-119.81456, 34.44809], [-119.81464, 34.44798], [-119.81475, 34.44789], [-119.815, 34.44774], [-119.8151, 34.44766], [-119.81521, 34.44752], [-119.81527, 34.44736], [-119.81529, 34.44719], [-119.81525, 34.44681], [-119.81518, 34.44658], [-119.81504, 34.44629], [-119.81501, 34.44616], [-119.81502, 34.44603], [-119.81506, 34.44601], [-119.81526, 34.44603], [-119.81573, 34.44602], [-119.81573, 34.4463], [-119.816, 34.44635], [-119.81606, 34.4464]]]]} | Open Access 1 | 1578 | University Circle Open Space | 26673 | 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 | 11.722 | University Circle OS | 0 | Local Recreation Area 3 | 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]);