units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where COUNTY = 4, DES_TP = 3 and MNG_AG_ID = 1069
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3419 | 3419 | 3418 | {"type": "Polygon", "coordinates": [[[-117.18086, 32.69355], [-117.18013, 32.69481], [-117.17921, 32.69442], [-117.17996, 32.69317], [-117.18086, 32.69355]], [[-117.18043, 32.6934], [-117.18043, 32.69338], [-117.18037, 32.69337], [-117.17965, 32.69459], [-117.17972, 32.69461], [-117.18043, 32.6934]]]} | Restricted Access 2 | 25118 | Cutler Field | 31610 | 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 | San Diego 4 | 3.436 | Cutler Field | 0 | Local Recreation Area 3 | 4 | |
15675 | 15675 | 15674 | {"type": "Polygon", "coordinates": [[[-117.17324, 32.68306], [-117.17312, 32.6832], [-117.17308, 32.6833], [-117.17296, 32.68347], [-117.17281, 32.68359], [-117.17262, 32.68371], [-117.17251, 32.68387], [-117.17263, 32.68421], [-117.17237, 32.68428], [-117.1722, 32.68427], [-117.17191, 32.6842], [-117.17173, 32.68409], [-117.17158, 32.68394], [-117.1714, 32.68369], [-117.17111, 32.68314], [-117.17032, 32.68188], [-117.16997, 32.68153], [-117.16967, 32.68141], [-117.1694, 32.68136], [-117.16905, 32.68137], [-117.16876, 32.68144], [-117.16857, 32.68156], [-117.16831, 32.68174], [-117.16815, 32.68194], [-117.16809, 32.68217], [-117.16806, 32.6824], [-117.16807, 32.68265], [-117.16806, 32.68299], [-117.16799, 32.68333], [-117.16781, 32.68386], [-117.16782, 32.68414], [-117.16818, 32.68551], [-117.16848, 32.68627], [-117.16921, 32.68776], [-117.1693, 32.68813], [-117.16936, 32.68869], [-117.16947, 32.69001], [-117.16944, 32.69032], [-117.16939, 32.69055], [-117.16924, 32.69095], [-117.16902, 32.69135], [-117.16873, 32.69133], [-117.16859, 32.69128], [-117.1684, 32.69116], [-117.16821, 32.691], [-117.16791, 32.6907], [-117.16765, 32.69047], [-117.167, 32.69001], [-117.16625, 32.68951], [-117.1654, 32.68896], [-117.16433, 32.68832], [-117.16413, 32.6882], [-117.16395, 32.68818], [-117.16375, 32.68809], [-117.16367, 32.68794], [-117.16367, 32.6876], [-117.16362, 32.68675], [-117.16365, 32.68636], [-117.1637, 32.68595], [-117.1638, 32.6856], [-117.16383, 32.68543], [-117.16376, 32.68536], [-117.16377, 32.68528], [-117.16404, 32.68465], [-117.16416, 32.68445], [-117.16432, 32.68424], [-117.16452, 32.68409], [-117.165, 32.68395], [-117.16516, 32.68388], [-117.16524, 32.68378], [-117.16527, 32.68364], [-117.16527, 32.68334], [-117.16531, 32.68286], [-117.16541, 32.68243], [-117.16567, 32.68145], [-117.16584, 32.68066], [-117.1659, 32.68018], [-117.16628, 32.67969], [-117.16647, 32.67956], [-117.16716, 32.67928], [-117.16734, 32.67918], [-117.16765, 32.67893], [-117.16783, 32.67893], [-117.16818, 32.67905], [-117.16837, 32.67918], [-117.16868, 32.67933], [-117.169, 32.67943], [-117.16948, 32.67961], [-117.16996, 32.67982], [-117.17018, 32.67994], [-117.17036, 32.6801], [-117.17057, 32.68033], [-117.17074, 32.6806], [-117.17086, 32.68087], [-117.1709, 32.68106], [-117.17098, 32.68124], [-117.17131, 32.68156], [-117.17157, 32.68191], [-117.17185, 32.68218], [-117.17212, 32.68235], [-117.17244, 32.68242], [-117.17277, 32.68264], [-117.17314, 32.68283], [-117.17323, 32.68294], [-117.17324, 32.68306]]]} | Restricted Access 2 | 12284 | Coronado Golf Course | 33031 | 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.golfcoronado.com/ | San Diego 4 | 126.258 | Coronado GC | 0 | Local Recreation Area 3 | 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]);