superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where MNG_AGENCY = 147 and PARK_NAME = "Hidden Valley Openspace"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5116 | 5116 | 5115 | {"type": "MultiPolygon", "coordinates": [[[[-122.01651, 38.36711], [-122.01645, 38.36725], [-122.01642, 38.36746], [-122.01642, 38.36766], [-122.01633, 38.36766], [-122.01565, 38.36754], [-122.01541, 38.36761], [-122.01499, 38.36726], [-122.01446, 38.36699], [-122.0141, 38.36737], [-122.01399, 38.36731], [-122.01433, 38.36691], [-122.01351, 38.36602], [-122.01519, 38.36605], [-122.01524, 38.3661], [-122.01586, 38.36652], [-122.01606, 38.36669], [-122.01629, 38.36692], [-122.01649, 38.36706], [-122.01651, 38.36711]]], [[[-122.01956, 38.36849], [-122.01848, 38.36825], [-122.01801, 38.36812], [-122.0176, 38.36803], [-122.01695, 38.36782], [-122.01665, 38.36768], [-122.01667, 38.36736], [-122.01673, 38.36718], [-122.01705, 38.36721], [-122.01911, 38.36726], [-122.01947, 38.36809], [-122.01942, 38.36815], [-122.01956, 38.36849]]]]} | Open Access 1 | Hidden Valley Openspace | 19916 | 1364 | Vacaville, City of 147 | City 2 | City Agency 2 | http://www.cityofvacaville.com/index.aspx?page=374 | City 2 | 12.169 | Hidden Valley Openspace |
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]);