superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
6 rows where MNG_AGENCY = 712
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6931 | 6931 | 6930 | {"type": "Polygon", "coordinates": [[[-121.05633, 39.21384], [-121.05624, 39.2148], [-121.05554, 39.21478], [-121.05558, 39.21505], [-121.05434, 39.21508], [-121.05425, 39.21443], [-121.0543, 39.21412], [-121.05428, 39.21375], [-121.05416, 39.21327], [-121.05422, 39.21324], [-121.05475, 39.21318], [-121.055, 39.21318], [-121.05574, 39.21354], [-121.05609, 39.21357], [-121.05609, 39.21382], [-121.05633, 39.21384]]]} | Open Access 1 | Memorial Park | 22141 | 1673 | Grass Valley, City of 712 | City 2 | City Agency 2 | http://www.cityofgrassvalley.com/departments/parks-and-rec/city-parks | City 2 | 7.581 | Memorial Park | ||
7025 | 7025 | 7024 | {"type": "Polygon", "coordinates": [[[-121.07218, 39.21473], [-121.07195, 39.21477], [-121.07179, 39.21476], [-121.07153, 39.2147], [-121.07127, 39.21456], [-121.07117, 39.21456], [-121.07144, 39.21433], [-121.07113, 39.21408], [-121.07115, 39.21401], [-121.07109, 39.21397], [-121.07095, 39.21396], [-121.07073, 39.21399], [-121.07056, 39.21411], [-121.07051, 39.21404], [-121.07053, 39.21399], [-121.07098, 39.21389], [-121.07206, 39.21396], [-121.07218, 39.21473]]]} | Open Access 1 | Minnie Park | 22268 | 1673 | Grass Valley, City of 712 | City 2 | City Agency 2 | http://www.cityofgrassvalley.com/departments/parks-and-rec/city-parks | City 2 | 1.68 | Minnie 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]);