units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
18 rows where ACCESS_TYP = 1 and AGNCY_NAME = 105
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY
Link | rowid ▼ | id | map | ACCESS_TYP | UNIT_ID | UNIT_NAME | SUID_NMA | AGNCY_ID | AGNCY_NAME | AGNCY_LEV | AGNCY_TYP | AGNCY_WEB | LAYER | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | PARK_URL | COUNTY | ACRES | LABEL_NAME | YR_EST | DES_TP | GAP_STS |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
258 | 258 | 257 | {"type": "Polygon", "coordinates": [[[-117.18124, 32.68399], [-117.1812, 32.68408], [-117.1811, 32.68417], [-117.18102, 32.68419], [-117.18087, 32.68418], [-117.18077, 32.6841], [-117.18073, 32.68403], [-117.18072, 32.68392], [-117.18074, 32.68387], [-117.18084, 32.68379], [-117.18089, 32.68376], [-117.181, 32.68375], [-117.1811, 32.68378], [-117.18118, 32.68383], [-117.18123, 32.68391], [-117.18124, 32.68399]]]} | Open Access 1 | 857 | Star Park | 25800 | 1069 | Coronado, City of 105 | City 2 | City Agency 2 | http://www.coronado.ca.us/category/subcategory-rec.php | City 2 | 1069 | Coronado, City of 102 | City 2 | City Agency 2 | https://www.coronado.ca.us/cms/one.aspx?portalId=746090&pageId=3815723 | San Diego 4 | 0.451 | Star Park | 0 | Local Park 2 | 4 |
311 | 311 | 310 | {"type": "Polygon", "coordinates": [[[-117.13907, 32.62998], [-117.1378, 32.63027], [-117.13772, 32.6302], [-117.13759, 32.63014], [-117.1378, 32.62997], [-117.13795, 32.62979], [-117.13803, 32.62984], [-117.13815, 32.62984], [-117.13821, 32.62976], [-117.13836, 32.62951], [-117.13848, 32.62923], [-117.13852, 32.62902], [-117.13854, 32.62863], [-117.13851, 32.62838], [-117.13853, 32.62837], [-117.13907, 32.62998]]]} | Open Access 1 | 829 | North Cays Park | 22809 | 1069 | Coronado, City of 105 | City 2 | City Agency 2 | http://www.coronado.ca.us/category/subcategory-rec.php | City 2 | 1069 | Coronado, City of 102 | City 2 | City Agency 2 | https://www.coronado.ca.us/cms/one.aspx?portalId=746090&pageId=3815102 | San Diego 4 | 2.227 | North Cays Park | 0 | Local Park 2 | 4 |
312 | 312 | 311 | {"type": "Polygon", "coordinates": [[[-117.13717, 32.62433], [-117.13715, 32.62435], [-117.13713, 32.62433], [-117.13703, 32.62419], [-117.13688, 32.62404], [-117.13673, 32.62391], [-117.13642, 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 | 832 | Coronado Cays Park | 17645 | 1069 | Coronado, City of 105 | City 2 | City Agency 2 | http://www.coronado.ca.us/category/subcategory-rec.php | City 2 | 1069 | Coronado, City of 102 | City 2 | City Agency 2 | http://www.welcometocoronado.com/coronado-living/coronado-parks/ | San Diego 4 | 16.145 | Coronado Cays Park | 0 | Local Park 2 | 4 |
315 | 315 | 314 | {"type": "Polygon", "coordinates": [[[-117.17162, 32.68965], [-117.17162, 32.68965], [-117.17145, 32.68995], [-117.1713, 32.68952], [-117.17162, 32.68965]]]} | Open Access 1 | 849 | Cronan Park | 17830 | 1069 | Coronado, City of 105 | City 2 | City Agency 2 | http://www.coronado.ca.us/category/subcategory-rec.php | City 2 | 1069 | Coronado, City of 102 | City 2 | City Agency 2 | https://www.coronado.ca.us/cms/one.aspx?portalId=746090&pageId=3814919 | San Diego 4 | 0.154 | Cronan Park | 0 | Local Park 2 | 4 |
316 | 316 | 315 | {"type": "Polygon", "coordinates": [[[-117.18824, 32.6893], [-117.18787, 32.68914], [-117.18805, 32.68882], [-117.18813, 32.68899], [-117.18824, 32.6893]]]} | Open Access 1 | 850 | Bandel Park | 15793 | 1069 | Coronado, City of 105 | City 2 | City Agency 2 | http://www.coronado.ca.us/category/subcategory-rec.php | City 2 | 1069 | Coronado, City of 102 | City 2 | City Agency 2 | https://www.coronado.ca.us/cms/one.aspx?portalId=746090&pageId=3802359 | San Diego 4 | 0.2 | Bandel Park | 0 | Local Park 2 | 4 |
317 | 317 | 316 | {"type": "Polygon", "coordinates": [[[-117.19286, 32.68822], [-117.19257, 32.68877], [-117.19138, 32.68843], [-117.19141, 32.68826], [-117.19088, 32.68812], [-117.19082, 32.68806], [-117.19121, 32.68742], [-117.19286, 32.68822]]]} | Open Access 1 | 851 | Sunset Park | 26052 | 1069 | Coronado, City of 105 | City 2 | City Agency 2 | http://www.coronado.ca.us/category/subcategory-rec.php | City 2 | 1069 | Coronado, City of 102 | City 2 | City Agency 2 | https://www.coronado.ca.us/cms/one.aspx?portalId=746090&pageId=3816985 | San Diego 4 | 3.475 | Sunset Park | 0 | Local Park 2 | 4 |
318 | 318 | 317 | {"type": "Polygon", "coordinates": [[[-117.17334, 32.68705], [-117.17323, 32.68707], [-117.17308, 32.68713], [-117.17292, 32.68722], [-117.1728, 32.68735], [-117.17264, 32.68766], [-117.17258, 32.6877], [-117.17255, 32.6877], [-117.17251, 32.68767], [-117.17245, 32.68716], [-117.17244, 32.68695], [-117.17246, 32.68669], [-117.17308, 32.68693], [-117.17334, 32.68705]]]} | Open Access 1 | 852 | Mathewson Park | 21953 | 1069 | Coronado, City of 105 | City 2 | City Agency 2 | http://www.coronado.ca.us/category/subcategory-rec.php | City 2 | 1069 | Coronado, City of 102 | City 2 | City Agency 2 | https://www.coronado.ca.us/cms/one.aspx?portalId=746090&pageId=3815090 | San Diego 4 | 1.039 | Mathewson Park | 0 | Local Park 2 | 4 |
320 | 320 | 319 | {"type": "Polygon", "coordinates": [[[-117.1711, 32.68433], [-117.171, 32.68442], [-117.17092, 32.68451], [-117.17079, 32.68474], [-117.17049, 32.68419], [-117.1711, 32.68433]]]} | Open Access 1 | 856 | Vetter Park | 27062 | 1069 | Coronado, City of 105 | City 2 | City Agency 2 | http://www.coronado.ca.us/category/subcategory-rec.php | City 2 | 1069 | Coronado, City of 102 | City 2 | City Agency 2 | https://www.coronado.ca.us/cms/one.aspx?portalId=746090&pageId=3817022 | San Diego 4 | 0.348 | Vetter Park | 0 | Local Park 2 | 4 |
322 | 322 | 321 | {"type": "Polygon", "coordinates": [[[-117.16952, 32.68241], [-117.16947, 32.68245], [-117.16938, 32.6825], [-117.16928, 32.6825], [-117.16923, 32.68248], [-117.16918, 32.68243], [-117.16913, 32.68233], [-117.16915, 32.68226], [-117.16919, 32.68222], [-117.16923, 32.68219], [-117.16936, 32.68216], [-117.16941, 32.68217], [-117.16946, 32.6822], [-117.1695, 32.68224], [-117.16953, 32.68233], [-117.16952, 32.68241]]]} | Open Access 1 | 858 | Bay Circle Park | 15871 | 1069 | Coronado, City of 105 | City 2 | City Agency 2 | http://www.coronado.ca.us/category/subcategory-rec.php | City 2 | 1069 | Coronado, City of 102 | City 2 | City Agency 2 | https://www.coronado.ca.us/cms/one.aspx?portalId=746090&pageId=3803130 | San Diego 4 | 0.263 | Bay Circle Park | 0 | Local Park 2 | 4 |
323 | 323 | 322 | {"type": "MultiPolygon", "coordinates": [[[[-117.17709, 32.69019], [-117.17635, 32.69143], [-117.17549, 32.69106], [-117.17621, 32.68983], [-117.17709, 32.69019]]], [[[-117.17838, 32.69073], [-117.17764, 32.69196], [-117.17676, 32.6916], [-117.1775, 32.69036], [-117.17838, 32.69073]]]]} | Open Access 1 | 859 | Spreckels Park | 25735 | 1069 | Coronado, City of 105 | City 2 | City Agency 2 | http://www.coronado.ca.us/category/subcategory-rec.php | City 2 | 1069 | Coronado, City of 102 | City 2 | City Agency 2 | https://www.coronado.ca.us/cms/one.aspx?portalId=746090&pageId=3815654 | San Diego 4 | 6.94 | Spreckels Park | 0 | Local Park 2 | 4 |
795 | 795 | 794 | {"type": "Polygon", "coordinates": [[[-117.194, 32.68587], [-117.19286, 32.68822], [-117.19121, 32.68742], [-117.18933, 32.6866], [-117.1878, 32.6859], [-117.18651, 32.68525], [-117.18315, 32.68347], [-117.18134, 32.68242], [-117.18077, 32.68205], [-117.17992, 32.68109], [-117.17994, 32.68096], [-117.17953, 32.68063], [-117.1795, 32.68048], [-117.17852, 32.67943], [-117.17847, 32.67918], [-117.17835, 32.67906], [-117.17705, 32.67807], [-117.17716, 32.67788], [-117.1774, 32.67761], [-117.17915, 32.6786], [-117.17944, 32.67858], [-117.17981, 32.67865], [-117.17996, 32.67876], [-117.17995, 32.67901], [-117.17997, 32.67914], [-117.1801, 32.67932], [-117.18114, 32.68008], [-117.18325, 32.6813], [-117.18576, 32.68281], [-117.18725, 32.68359], [-117.18844, 32.68415], [-117.18948, 32.68459], [-117.19056, 32.68496], [-117.19281, 32.68559], [-117.194, 32.68587]]]} | Open Access 1 | 5171 | Coronado Municipal Beach | 17648 | 1069 | Coronado, City of 105 | City 2 | City Agency 2 | http://www.coronado.ca.us/category/subcategory-rec.php | City 2 | 1069 | Coronado, City of 102 | City 2 | City Agency 2 | http://www.sandiego.com/beaches/coronado-beach | San Diego 4 | 84.62 | Coronado Municipal Beach | 0 | Local Park 2 | 4 |
4384 | 4384 | 4383 | {"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 | 45960 | Vista Del Barco Park | 29077 | 1069 | Coronado, City of 105 | City 2 | City Agency 2 | http://www.coronado.ca.us/category/subcategory-rec.php | City 2 | 1069 | Coronado, City of 102 | City 2 | City Agency 2 | http://www.welcometocoronado.com/coronado-living/coronado-parks/ | San Diego 4 | 0.128 | Vista Del Barco Park | 0 | Local Park 2 | 4 |
6012 | 6012 | 6011 | {"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 | 814 | Palm Park | 23344 | 1069 | Coronado, City of 105 | City 2 | City Agency 2 | http://www.coronado.ca.us/category/subcategory-rec.php | City 2 | 1069 | Coronado, City of 102 | City 2 | City Agency 2 | http://www.welcometocoronado.com/coronado-living/coronado-parks/ | San Diego 4 | 0.203 | Palm Park | 0 | Local Park 2 | 4 |
6071 | 6071 | 6070 | {"type": "Polygon", "coordinates": [[[-117.17247, 32.69894], [-117.17197, 32.69981], [-117.17153, 32.69964], [-117.17205, 32.69877], [-117.17247, 32.69894]]]} | Open Access 1 | 809 | Centennial Park | 33718 | 1069 | Coronado, City of 105 | City 2 | City Agency 2 | http://www.coronado.ca.us/category/subcategory-rec.php | City 2 | 2133 | San Diego Unified Port District 182 | Special District 4 | Port/Harbor District 14 | https://www.coronado.ca.us/cms/one.aspx?portalId=746090&pageId=3814369 | San Diego 4 | 1.186 | Centennial Park | 0 | Local Park 2 | 4 |
6075 | 6075 | 6074 | {"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 | 821 | Triangle Park | 26530 | 1069 | Coronado, City of 105 | City 2 | City Agency 2 | http://www.coronado.ca.us/category/subcategory-rec.php | City 2 | 1069 | Coronado, City of 102 | City 2 | City Agency 2 | http://www.welcometocoronado.com/coronado-living/coronado-parks/ | San Diego 4 | 0.188 | Triangle Park | 0 | Local Park 2 | 4 |
8134 | 8134 | 8133 | {"type": "Polygon", "coordinates": [[[-117.16972, 32.67545], [-117.16931, 32.67587], [-117.16903, 32.67574], [-117.16873, 32.67547], [-117.16831, 32.67527], [-117.16806, 32.6752], [-117.16822, 32.67506], [-117.16781, 32.67471], [-117.16835, 32.67424], [-117.16972, 32.67545]]]} | Open Access 1 | 12316 | Glorietta Bay Park | 19347 | 1069 | Coronado, City of 105 | City 2 | City Agency 2 | http://www.coronado.ca.us/category/subcategory-rec.php | City 2 | 1069 | Coronado, City of 102 | City 2 | City Agency 2 | https://www.coronado.ca.us/cms/one.aspx?portalId=746090&pageId=3814937 | San Diego 4 | 3.382 | Glorietta Bay Park | 0 | Local Park 2 | 4 |
15134 | 15134 | 15133 | {"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 | 45958 | Harborview Park | 29074 | 1069 | Coronado, City of 105 | City 2 | City Agency 2 | http://www.coronado.ca.us/category/subcategory-rec.php | City 2 | 1069 | Coronado, City of 102 | City 2 | City Agency 2 | http://www.welcometocoronado.com/coronado-living/coronado-parks/ | San Diego 4 | 0.546 | Harborview Park | 0 | Local Park 2 | 4 |
15135 | 15135 | 15134 | {"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.18025, 32.68532], [-117.18027, 32.68536], [-117.18035, 32.68541], [-117.18044, 32.68541], [-117.18045, 32.68542]]]} | Open Access 1 | 45959 | Rotary Park | 29075 | 1069 | Coronado, City of 105 | City 2 | City Agency 2 | http://www.coronado.ca.us/category/subcategory-rec.php | City 2 | 1069 | Coronado, City of 102 | City 2 | City Agency 2 | http://www.welcometocoronado.com/coronado-living/coronado-parks/ | San Diego 4 | 0.224 | Rotary Park | 0 | Local Park 2 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([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([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);