superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
23 rows where MNG_AGENCY = 413 sorted by rowid descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3118 | 3118 | 3117 | {"type": "Polygon", "coordinates": [[[-122.02209, 37.39289], [-122.02121, 37.39553], [-122.02121, 37.39564], [-122.02125, 37.39572], [-122.02114, 37.39605], [-122.01914, 37.39562], [-122.01931, 37.3955], [-122.01936, 37.39537], [-122.0193, 37.39526], [-122.01933, 37.39513], [-122.01922, 37.39508], [-122.01936, 37.39468], [-122.02007, 37.39483], [-122.02037, 37.39391], [-122.02043, 37.3939], [-122.02073, 37.39298], [-122.02072, 37.39296], [-122.02023, 37.39286], [-122.02009, 37.39284], [-122.02004, 37.39286], [-122.01987, 37.39279], [-122.01983, 37.39272], [-122.01984, 37.39261], [-122.01991, 37.39243], [-122.02209, 37.39289]]]} | Open Access 1 | Columbia Park | 17546 | 1345 | Sunnyvale, City of 413 | City 2 | City Agency 2 | http://sunnyvale.ca.gov/Departments/CommunityServices/Parks.aspx | City 2 | 12.735 | Columbia Park | 1985 | |
2977 | 2977 | 2976 | {"type": "Polygon", "coordinates": [[[-122.03923, 37.37111], [-122.03922, 37.37115], [-122.03918, 37.37118], [-122.03881, 37.37126], [-122.03784, 37.37171], [-122.03757, 37.37178], [-122.03729, 37.3718], [-122.0371, 37.37179], [-122.0364, 37.37164], [-122.03635, 37.37161], [-122.03635, 37.37158], [-122.03678, 37.37032], [-122.03682, 37.37029], [-122.03687, 37.37028], [-122.0375, 37.37042], [-122.03739, 37.37074], [-122.03752, 37.37084], [-122.03833, 37.37101], [-122.03847, 37.37091], [-122.03849, 37.37077], [-122.03847, 37.37063], [-122.03889, 37.37071], [-122.03904, 37.37077], [-122.03911, 37.37084], [-122.03916, 37.37091], [-122.03923, 37.37111]]]} | Open Access 1 | Civic Center Park | 17365 | 1345 | Sunnyvale, City of 413 | City 2 | City Agency 2 | http://sunnyvale.ca.gov/Departments/CommunityServices/Parks.aspx | City 2 | 5.837 | Civic Ctr. Park | 1961 | |
2202 | 2202 | 2201 | {"type": "Polygon", "coordinates": [[[-122.02106, 37.36325], [-122.02073, 37.36357], [-122.02061, 37.36384], [-122.02016, 37.36515], [-122.01939, 37.36508], [-122.01942, 37.36502], [-122.01941, 37.36495], [-122.01936, 37.3649], [-122.01929, 37.36489], [-122.01996, 37.36297], [-122.02056, 37.36311], [-122.02057, 37.36314], [-122.02106, 37.36325]]]} | Open Access 1 | Braly Park | 16327 | 1345 | Sunnyvale, City of 413 | City 2 | City Agency 2 | http://sunnyvale.ca.gov/Departments/CommunityServices/Parks.aspx | City 2 | 4.773 | Braly Park | 1965 |
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]);