superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
8 rows where PARK_URL = "http://www.cupertino.org/" sorted by MNG_AG_ID
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
MNG_AGENCY 1
ACCESS_TYP 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12316 | 12316 | 12315 | {"type": "Polygon", "coordinates": [[[-122.03079, 37.31841], [-122.03076, 37.31847], [-122.03068, 37.3185], [-122.0299, 37.31849], [-122.02985, 37.31847], [-122.02982, 37.31844], [-122.0298, 37.31836], [-122.02984, 37.31829], [-122.02991, 37.31826], [-122.03071, 37.31826], [-122.03076, 37.31829], [-122.03078, 37.31833], [-122.03079, 37.31841]]]} | Open Access 1 | Sandra James Park | http://www.cupertino.org/ | 30838 | 1076 | Cupertino, City of 191 | City 2 | City Agency 2 | http://www.cupertino.org/index.aspx?page=591 | City 2 | 0.535 | Sandra James Park | |
12999 | 12999 | 12998 | {"type": "Polygon", "coordinates": [[[-122.08884, 37.33641], [-122.08847, 37.33664], [-122.0884, 37.33667], [-122.0882, 37.33644], [-122.08828, 37.33642], [-122.08864, 37.33622], [-122.08884, 37.33641]]]} | Open Access 1 | Little Rancho Park | http://www.cupertino.org/ | 30843 | 1076 | Cupertino, City of 191 | City 2 | City Agency 2 | http://www.cupertino.org/index.aspx?page=591 | City 2 | 0.339 | Little Rancho Park | |
13442 | 13442 | 13441 | {"type": "Polygon", "coordinates": [[[-122.03733, 37.33727], [-122.03733, 37.33744], [-122.03694, 37.33744], [-122.03689, 37.33742], [-122.03689, 37.33658], [-122.03728, 37.33658], [-122.03728, 37.33725], [-122.03733, 37.33727]]]} | Open Access 1 | Franco Park | http://www.cupertino.org/ | 30834 | 1076 | Cupertino, City of 191 | City 2 | City Agency 2 | http://www.cupertino.org/index.aspx?page=591 | City 2 | 0.836 | Franco Park | |
13443 | 13443 | 13442 | {"type": "Polygon", "coordinates": [[[-122.07929, 37.32838], [-122.07873, 37.32863], [-122.07851, 37.32832], [-122.07907, 37.32807], [-122.07929, 37.32838]]]} | Open Access 1 | Canyon Oak Park | http://www.cupertino.org/ | 30835 | 1076 | Cupertino, City of 191 | City 2 | City Agency 2 | http://www.cupertino.org/index.aspx?page=591 | City 2 | 0.555 | Canyon Oak Park | |
13444 | 13444 | 13443 | {"type": "Polygon", "coordinates": [[[-122.06192, 37.32255], [-122.06187, 37.3226], [-122.06186, 37.32269], [-122.06179, 37.3227], [-122.06168, 37.3228], [-122.06157, 37.32277], [-122.06144, 37.32279], [-122.06116, 37.32257], [-122.06078, 37.32239], [-122.06039, 37.32208], [-122.06036, 37.32175], [-122.06041, 37.32112], [-122.06053, 37.32091], [-122.06094, 37.32047], [-122.06101, 37.32033], [-122.06123, 37.32015], [-122.06129, 37.32037], [-122.06127, 37.32086], [-122.06128, 37.32108], [-122.06139, 37.3217], [-122.06147, 37.32172], [-122.06165, 37.32241], [-122.06172, 37.32256], [-122.06177, 37.32259], [-122.06192, 37.32255]]]} | Open Access 1 | Stocklmeir Ranch | http://www.cupertino.org/ | 30836 | 1076 | Cupertino, City of 191 | City 2 | City Agency 2 | http://www.cupertino.org/index.aspx?page=591 | City 2 | 4.904 | Stocklmeir Ranch | |
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]);