superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
8 rows where MNG_AGENCY = 585 sorted by map
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2797 | 2797 | 2796 | {"type": "Polygon", "coordinates": [[[-116.44234, 33.82833], [-116.44229, 33.82838], [-116.44163, 33.82837], [-116.44146, 33.82835], [-116.44132, 33.82838], [-116.44093, 33.82838], [-116.44092, 33.82714], [-116.44101, 33.82706], [-116.44228, 33.82706], [-116.44233, 33.8271], [-116.44234, 33.82833]]]} | Open Access 1 | Century Park | 17078 | 1049 | Cathedral City, City of 585 | City 2 | City Agency 2 | http://www.cathedralcity.gov/index.aspx?page=490 | City 2 | 4.677 | Century Park | ||
3564 | 3564 | 3563 | {"type": "Polygon", "coordinates": [[[-116.45144, 33.83402], [-116.44969, 33.83403], [-116.44961, 33.83396], [-116.44961, 33.83067], [-116.44969, 33.83063], [-116.4514, 33.83063], [-116.45144, 33.83402]]]} | Open Access 1 | Dennis Keat Soccer Park | 18090 | 1049 | Cathedral City, City of 585 | City 2 | City Agency 2 | http://www.cathedralcity.gov/index.aspx?page=490 | City 2 | 15.613 | Dennis Keat Soccer Park | ||
8012 | 8012 | 8011 | {"type": "Polygon", "coordinates": [[[-116.45782, 33.80354], [-116.45775, 33.80354], [-116.45774, 33.80353], [-116.45733, 33.80318], [-116.45732, 33.80237], [-116.45718, 33.80209], [-116.45693, 33.80178], [-116.45653, 33.80169], [-116.45577, 33.80168], [-116.45534, 33.80181], [-116.45506, 33.80207], [-116.45499, 33.80207], [-116.45498, 33.80158], [-116.45772, 33.80157], [-116.4578, 33.80164], [-116.45782, 33.80354]]]} | Open Access 1 | Patriot Park | 23512 | 1049 | Cathedral City, City of 585 | City 2 | City Agency 2 | http://www.cathedralcity.gov/index.aspx?page=490 | City 2 | 3.56 | Patriot Park | ||
9481 | 9481 | 9480 | {"type": "Polygon", "coordinates": [[[-116.46035, 33.7813], [-116.45927, 33.78098], [-116.45847, 33.78081], [-116.45846, 33.78064], [-116.45818, 33.78064], [-116.45818, 33.78047], [-116.45842, 33.78046], [-116.45844, 33.78044], [-116.46022, 33.78043], [-116.46023, 33.78105], [-116.46035, 33.78107], [-116.46035, 33.7813]]]} | Open Access 1 | Second Street Park | 25279 | 1049 | Cathedral City, City of 585 | City 2 | City Agency 2 | http://www.cathedralcity.gov/index.aspx?page=490 | City 2 | 2.786 | Second Street Park | ||
378 | 378 | 377 | {"type": "Polygon", "coordinates": [[[-116.46342, 33.80671], [-116.46339, 33.80676], [-116.46334, 33.80677], [-116.46152, 33.80678], [-116.46148, 33.80677], [-116.46145, 33.80674], [-116.46143, 33.80596], [-116.46181, 33.80595], [-116.46182, 33.8055], [-116.46243, 33.80549], [-116.46261, 33.8055], [-116.46303, 33.80549], [-116.46304, 33.80567], [-116.46342, 33.80566], [-116.46342, 33.80671]]]} | Open Access 1 | Ocotillo Park | http://www.cathedralcity.gov/Home/Components/FacilityDirectory/FacilityDirectory/12/1768 | 31989 | 1049 | Cathedral City, City of 585 | City 2 | City Agency 2 | http://www.cathedralcity.gov/index.aspx?page=490 | City 2 | 5.827 | Ocotillo Park | |
10423 | 10423 | 10422 | {"type": "Polygon", "coordinates": [[[-116.46453, 33.78095], [-116.4636, 33.78095], [-116.46359, 33.78045], [-116.46447, 33.78045], [-116.46447, 33.78054], [-116.46453, 33.78067], [-116.46453, 33.78095]]]} | Open Access 1 | Town Square Park | 26492 | 1049 | Cathedral City, City of 585 | City 2 | City Agency 2 | http://www.cathedralcity.gov/index.aspx?page=490 | City 2 | 1.165 | Town Square Park | ||
6911 | 6911 | 6910 | {"type": "Polygon", "coordinates": [[[-116.46672, 33.78273], [-116.46671, 33.7829], [-116.46666, 33.78295], [-116.46641, 33.78294], [-116.46641, 33.78273], [-116.46672, 33.78273]]]} | Open Access 1 | Memorial Park | 22122 | 1049 | Cathedral City, City of 585 | City 2 | City Agency 2 | http://www.cathedralcity.gov/index.aspx?page=490 | City 2 | 0.163 | Memorial Park | ||
7909 | 7909 | 7908 | {"type": "Polygon", "coordinates": [[[-116.46923, 33.83788], [-116.46923, 33.83807], [-116.4692, 33.83828], [-116.46914, 33.83851], [-116.46874, 33.83939], [-116.46869, 33.83942], [-116.46864, 33.83943], [-116.46839, 33.83937], [-116.46793, 33.83928], [-116.46797, 33.83902], [-116.46796, 33.839], [-116.46765, 33.83897], [-116.4676, 33.83924], [-116.46711, 33.83921], [-116.46705, 33.83919], [-116.467, 33.83915], [-116.46698, 33.83908], [-116.46698, 33.8379], [-116.46701, 33.83783], [-116.46706, 33.83779], [-116.46713, 33.83778], [-116.46909, 33.83777], [-116.46919, 33.83781], [-116.46923, 33.83788]]]} | Open Access 1 | Panorama Park | 23391 | 1049 | Cathedral City, City of 585 | City 2 | City Agency 2 | http://www.cathedralcity.gov/index.aspx?page=490 | City 2 | 7.828 | Panorama 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]);