superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 1, ACRES = "16.238", MNG_AGENCY = 534 and MNG_AG_TYP = 2
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AG_TYP
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10614 | 10614 | 10613 | {"type": "Polygon", "coordinates": [[[-121.42972, 38.46125], [-121.429, 38.46148], [-121.42897, 38.46155], [-121.42882, 38.46155], [-121.42821, 38.46176], [-121.42814, 38.4618], [-121.4281, 38.46184], [-121.42799, 38.46182], [-121.42733, 38.46204], [-121.42728, 38.46212], [-121.42713, 38.46212], [-121.42651, 38.46232], [-121.42642, 38.4624], [-121.42631, 38.46237], [-121.42595, 38.46248], [-121.42563, 38.46283], [-121.4255, 38.46284], [-121.42487, 38.46305], [-121.4248, 38.46312], [-121.42467, 38.4631], [-121.42399, 38.46332], [-121.42392, 38.46318], [-121.42373, 38.46293], [-121.42349, 38.4627], [-121.42382, 38.46247], [-121.4247, 38.46205], [-121.4258, 38.46165], [-121.4262, 38.46143], [-121.42657, 38.46119], [-121.42721, 38.46063], [-121.42734, 38.46039], [-121.42763, 38.46043], [-121.42792, 38.46044], [-121.42807, 38.46043], [-121.42836, 38.46037], [-121.42904, 38.46015], [-121.42911, 38.46015], [-121.42913, 38.46017], [-121.42972, 38.46125]]]} | Open Access 1 | Valley Hi Park | 26790 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 16.238 | Valley Hi Park |
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]);