superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
23 rows where MNG_AGENCY = 191
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13445 | 13445 | 13444 | {"type": "Polygon", "coordinates": [[[-122.05109, 37.3278], [-122.05067, 37.32805], [-122.05066, 37.32751], [-122.05061, 37.32715], [-122.05071, 37.32712], [-122.05109, 37.3278]]]} | Open Access 1 | Mary Avenue Dog Park | http://www.cupertino.org/ | 30837 | 1076 | Cupertino, City of 191 | City 2 | City Agency 2 | http://www.cupertino.org/index.aspx?page=591 | City 2 | 0.54 | Mary Avenue Dog Park | |
13447 | 13447 | 13446 | {"type": "Polygon", "coordinates": [[[-121.99671, 37.31535], [-121.99657, 37.31569], [-121.99599, 37.31568], [-121.9961, 37.31534], [-121.99671, 37.31535]]]} | Open Access 1 | Sterling Barnhart Park | http://www.cupertino.org/ | 30840 | 1076 | Cupertino, City of 191 | City 2 | City Agency 2 | http://www.cupertino.org/index.aspx?page=591 | City 2 | 0.503 | Sterling Barnhart Park | |
13449 | 13449 | 13448 | {"type": "Polygon", "coordinates": [[[-122.02919, 37.31725], [-122.02787, 37.31727], [-122.02786, 37.3161], [-122.02817, 37.31612], [-122.02868, 37.31622], [-122.02913, 37.31626], [-122.02917, 37.31628], [-122.02918, 37.31631], [-122.02919, 37.31725]]]} | Open Access 1 | Library Field | http://www.cupertino.org/ | 30842 | 1076 | Cupertino, City of 191 | City 2 | City Agency 2 | http://www.cupertino.org/index.aspx?page=591 | City 2 | 3.465 | Library Field |
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]);