superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACRES = "8.396" and MNG_AGENCY = 7
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
131 | 131 | 130 | {"type": "Polygon", "coordinates": [[[-119.81698, 34.44965], [-119.81663, 34.44988], [-119.81647, 34.45003], [-119.8159, 34.45065], [-119.81571, 34.45089], [-119.81557, 34.45112], [-119.81532, 34.45163], [-119.81511, 34.45195], [-119.81492, 34.45216], [-119.81442, 34.45265], [-119.81427, 34.45284], [-119.81423, 34.45285], [-119.81387, 34.45282], [-119.81409, 34.45243], [-119.81396, 34.45237], [-119.81373, 34.45275], [-119.81353, 34.45275], [-119.81477, 34.4516], [-119.81478, 34.45139], [-119.81522, 34.45138], [-119.81532, 34.45128], [-119.81473, 34.45053], [-119.81488, 34.44981], [-119.81506, 34.44943], [-119.81678, 34.44942], [-119.81698, 34.44965]]]} | Open Access 1 | Kellogg Open Space | 20580 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 8.396 | Kellogg OS |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);