superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
3 rows where MNG_AGENCY = 413 and YR_EST = 1961
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
8568 | 8568 | 8567 | {"type": "Polygon", "coordinates": [[[-122.0081, 37.34408], [-122.00808, 37.34412], [-122.00791, 37.34412], [-122.00786, 37.34408], [-122.00753, 37.34409], [-122.00748, 37.34407], [-122.00744, 37.34403], [-122.0069, 37.34404], [-122.0069, 37.34454], [-122.00687, 37.34456], [-122.00688, 37.34493], [-122.00692, 37.34495], [-122.00693, 37.34533], [-122.006, 37.34538], [-122.00561, 37.34535], [-122.00554, 37.34532], [-122.00553, 37.34529], [-122.00544, 37.34271], [-122.00722, 37.34267], [-122.00723, 37.34298], [-122.0072, 37.34308], [-122.00722, 37.34344], [-122.00808, 37.34344], [-122.0081, 37.34408]]]} | Open Access 1 | Raynor Park | 24208 | 1345 | Sunnyvale, City of 413 | City 2 | City Agency 2 | http://sunnyvale.ca.gov/Departments/CommunityServices/Parks.aspx | City 2 | 11.572 | Raynor Park | 1961 | |
9519 | 9519 | 9518 | {"type": "Polygon", "coordinates": [[[-122.04312, 37.34474], [-122.04168, 37.34475], [-122.04162, 37.34471], [-122.04161, 37.34172], [-122.04311, 37.34172], [-122.04312, 37.34474]]]} | Open Access 1 | Serra Park | 25315 | 1345 | Sunnyvale, City of 413 | City 2 | City Agency 2 | http://sunnyvale.ca.gov/Departments/CommunityServices/Parks.aspx | City 2 | 11.043 | Serra Park | 1961 |
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]);