superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
6 rows where ACCESS_TYP = 1 and PARK_URL = "http://www.welcometocoronado.com/coronado-living/coronado-parks/"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3193 | 3193 | 3192 | {"type": "Polygon", "coordinates": [[[-117.13717, 32.62433], [-117.13715, 32.62435], [-117.13713, 32.62433], [-117.13703, 32.62419], [-117.13688, 32.62404], [-117.13674, 32.62391], [-117.13643, 32.62373], [-117.13609, 32.6236], [-117.13591, 32.62356], [-117.1356, 32.62351], [-117.13533, 32.62343], [-117.13501, 32.62326], [-117.13475, 32.6231], [-117.13457, 32.62294], [-117.13442, 32.62273], [-117.13426, 32.62238], [-117.1342, 32.62211], [-117.1342, 32.62197], [-117.13423, 32.62174], [-117.13433, 32.62138], [-117.1344, 32.62125], [-117.1345, 32.6211], [-117.1346, 32.62099], [-117.1348, 32.62081], [-117.13508, 32.62062], [-117.13519, 32.62052], [-117.13531, 32.62039], [-117.13542, 32.62024], [-117.13553, 32.62002], [-117.13562, 32.61977], [-117.13566, 32.6195], [-117.13564, 32.61927], [-117.13641, 32.62209], [-117.13717, 32.62433]]]} | Open Access 1 | Coronado Cays Park | http://www.welcometocoronado.com/coronado-living/coronado-parks/ | 17645 | 1069 | Coronado, City of 102 | City 2 | City Agency 2 | http://www.coronado.ca.us/category/subcategory-rec.php | City 2 | 16.145 | Coronado Cays Park | |
6676 | 6676 | 6675 | {"type": "Polygon", "coordinates": [[[-117.18055, 32.69876], [-117.18036, 32.6991], [-117.18016, 32.69861], [-117.18016, 32.69861], [-117.18055, 32.69876]]]} | Open Access 1 | Palm Park | http://www.welcometocoronado.com/coronado-living/coronado-parks/ | 23344 | 1069 | Coronado, City of 102 | City 2 | City Agency 2 | http://www.coronado.ca.us/category/subcategory-rec.php | City 2 | 0.203 | Palm Park | |
8967 | 8967 | 8966 | {"type": "Polygon", "coordinates": [[[-117.17879, 32.69601], [-117.17842, 32.69585], [-117.1786, 32.69554], [-117.17869, 32.69578], [-117.17879, 32.69601]]]} | Open Access 1 | Triangle Park | http://www.welcometocoronado.com/coronado-living/coronado-parks/ | 26530 | 1069 | Coronado, City of 102 | City 2 | City Agency 2 | http://www.coronado.ca.us/category/subcategory-rec.php | City 2 | 0.188 | Triangle Park | |
12111 | 12111 | 12110 | {"type": "Polygon", "coordinates": [[[-117.17472, 32.69989], [-117.1742, 32.70078], [-117.17404, 32.70073], [-117.17401, 32.70071], [-117.17454, 32.69981], [-117.17472, 32.69989]]]} | Open Access 1 | Harborview Park | http://www.welcometocoronado.com/coronado-living/coronado-parks/ | 29074 | 1069 | Coronado, City of 102 | City 2 | City Agency 2 | http://www.coronado.ca.us/category/subcategory-rec.php | City 2 | 0.545 | Harborview Park | |
12113 | 12113 | 12112 | {"type": "Polygon", "coordinates": [[[-117.18045, 32.68542], [-117.18046, 32.68548], [-117.18044, 32.68553], [-117.18035, 32.68561], [-117.1802, 32.68569], [-117.18014, 32.68567], [-117.18011, 32.68564], [-117.18011, 32.68541], [-117.18013, 32.68536], [-117.18023, 32.68531], [-117.18027, 32.68536], [-117.18035, 32.68541], [-117.18044, 32.68541], [-117.18045, 32.68542]]]} | Open Access 1 | Rotary Park | http://www.welcometocoronado.com/coronado-living/coronado-parks/ | 29075 | 1069 | Coronado, City of 102 | City 2 | City Agency 2 | http://www.coronado.ca.us/category/subcategory-rec.php | City 2 | 0.223 | Rotary Park | |
12115 | 12115 | 12114 | {"type": "Polygon", "coordinates": [[[-117.17555, 32.6822], [-117.17543, 32.68228], [-117.1751, 32.68236], [-117.17534, 32.6821], [-117.17555, 32.6822]]]} | Open Access 1 | Vista Del Barco Park | http://www.welcometocoronado.com/coronado-living/coronado-parks/ | 29077 | 1069 | Coronado, City of 102 | City 2 | City Agency 2 | http://www.coronado.ca.us/category/subcategory-rec.php | City 2 | 0.128 | Vista Del Barco Park |
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]);