superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
6 rows where ACCESS_TYP = 1, MNG_AGENCY = 96 and YR_EST = 1940
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1326 | 1326 | 1325 | {"type": "Polygon", "coordinates": [[[-122.32824, 37.55981], [-122.32774, 37.55988], [-122.3277, 37.55972], [-122.32775, 37.55963], [-122.32814, 37.55935], [-122.32824, 37.55981]]]} | Open Access 1 | Bay Tree | 15881 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 0.416 | Bay Tree | 1940 | |
2775 | 2775 | 2774 | {"type": "Polygon", "coordinates": [[[-122.32427, 37.56169], [-122.3221, 37.56319], [-122.32082, 37.56202], [-122.32141, 37.56161], [-122.32141, 37.56159], [-122.32012, 37.5604], [-122.32038, 37.56022], [-122.32089, 37.56067], [-122.32219, 37.55977], [-122.32427, 37.56169]]]} | Open Access 1 | Central Park | 17059 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 16.266 | Central Park | 1940 | |
3487 | 3487 | 3486 | {"type": "Polygon", "coordinates": [[[-122.32986, 37.56138], [-122.32912, 37.5622], [-122.32894, 37.56233], [-122.32844, 37.56238], [-122.32831, 37.56247], [-122.32823, 37.56284], [-122.32781, 37.56315], [-122.32743, 37.56319], [-122.32742, 37.56305], [-122.32757, 37.56302], [-122.32772, 37.56297], [-122.32787, 37.56289], [-122.328, 37.56279], [-122.32812, 37.56262], [-122.32821, 37.56237], [-122.32832, 37.56226], [-122.32847, 37.56218], [-122.32876, 37.56213], [-122.32893, 37.56205], [-122.32912, 37.56187], [-122.32922, 37.56173], [-122.32935, 37.56164], [-122.32946, 37.56162], [-122.32953, 37.56158], [-122.32956, 37.56149], [-122.32952, 37.5614], [-122.3297, 37.56137], [-122.32986, 37.56138]]]} | Open Access 1 | DeAnza Historical Area | 17979 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 1.426 | DeAnza Historical Area | 1940 | |
4519 | 4519 | 4518 | {"type": "Polygon", "coordinates": [[[-122.31947, 37.56947], [-122.31859, 37.57008], [-122.31843, 37.56994], [-122.31804, 37.56974], [-122.31787, 37.56968], [-122.31738, 37.56941], [-122.31678, 37.56954], [-122.31768, 37.56892], [-122.318, 37.56921], [-122.31789, 37.56928], [-122.31789, 37.56935], [-122.31827, 37.56968], [-122.31834, 37.56968], [-122.3184, 37.56965], [-122.3187, 37.56992], [-122.31881, 37.56987], [-122.31941, 37.56946], [-122.31947, 37.56947]]]} | Open Access 1 | Gateway | 19234 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 1.457 | Gateway | 1940 | |
4982 | 4982 | 4981 | {"type": "Polygon", "coordinates": [[[-122.31469, 37.55875], [-122.31454, 37.55886], [-122.3145, 37.55887], [-122.31428, 37.55865], [-122.31444, 37.55853], [-122.31448, 37.55852], [-122.31457, 37.55859], [-122.31469, 37.55871], [-122.31469, 37.55875]]]} | Open Access 1 | Hayward Park Square | 19760 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 0.192 | Hayward Park Square | 1940 | |
10225 | 10225 | 10224 | {"type": "Polygon", "coordinates": [[[-122.3097, 37.55093], [-122.30896, 37.55143], [-122.3086, 37.55081], [-122.30869, 37.55073], [-122.30847, 37.5504], [-122.30884, 37.55014], [-122.3097, 37.55093]]]} | Open Access 1 | Trinta | 26544 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 1.876 | Trinta | 1940 |
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]);