superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where PARK_URL = "http://www.glendaleca.gov/government/departments/community-services-parks/parks-facilities-historic-sites/glendale-sports-complex-"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12395 | 12395 | 12394 | {"type": "Polygon", "coordinates": [[[-118.21676, 34.18598], [-118.21615, 34.18605], [-118.21606, 34.18604], [-118.21594, 34.18601], [-118.21577, 34.18589], [-118.21569, 34.18587], [-118.21468, 34.18586], [-118.21455, 34.18584], [-118.21422, 34.18577], [-118.21372, 34.18562], [-118.21345, 34.18547], [-118.21323, 34.18524], [-118.21319, 34.18516], [-118.21317, 34.18508], [-118.21317, 34.18484], [-118.21324, 34.18447], [-118.21326, 34.18442], [-118.21334, 34.18433], [-118.21351, 34.18426], [-118.21387, 34.18423], [-118.21418, 34.18423], [-118.21444, 34.18419], [-118.21456, 34.18413], [-118.21467, 34.18401], [-118.21469, 34.18394], [-118.21467, 34.18386], [-118.21453, 34.1837], [-118.21447, 34.18358], [-118.21443, 34.18348], [-118.21444, 34.18333], [-118.21437, 34.18325], [-118.2143, 34.18308], [-118.2144, 34.18281], [-118.21454, 34.18278], [-118.21471, 34.18279], [-118.21479, 34.18276], [-118.21488, 34.18275], [-118.21494, 34.18267], [-118.21506, 34.18245], [-118.21572, 34.18256], [-118.21598, 34.18262], [-118.21675, 34.18296], [-118.21652, 34.18393], [-118.21612, 34.18543], [-118.21618, 34.18581], [-118.21675, 34.18577], [-118.21676, 34.18598]]]} | Open Access 1 | Glendale Sports Complex | http://www.glendaleca.gov/government/departments/community-services-parks/parks-facilities-historic-sites/glendale-sports-complex- | 29383 | 1119 | Glendale, City of 100 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/city-departments/community-services-parks | City 2 | 20.656 | Glendale Sports Complex |
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]);