{"id":480,"date":"2017-07-09T10:21:16","date_gmt":"2017-07-09T14:21:16","guid":{"rendered":"http:\/\/brian.digitalmaddox.com\/blog\/?p=480"},"modified":"2017-07-09T10:21:16","modified_gmt":"2017-07-09T14:21:16","slug":"another-fixed-gnis-dataset","status":"publish","type":"post","link":"https:\/\/brian.digitalmaddox.com\/blog\/?p=480","title":{"rendered":"Another Fixed GNIS Dataset"},"content":{"rendered":"

When I went to import the latest GNIS dataset into my local PostGIS database, I found that it contains the same issues I’ve been reporting for the past few years.\u00a0\u00a0 You can find my fixed version of the dataset here<\/a>.<\/p>\n

As a disclaimer, while I used to work there, I no longer have any association with the US Geological Survey or the Board of Geographic Names.<\/p>\n

For those interested, here is the list of problems I found and fixed:<\/p>\n

ID 45605: Duplicate entry for Parker Canyon, AZ. The coordinates are in Sonora, Mexico.\r\nID 45606: Duplicate entry for San Antonio Canyon, AZ. The coordinates are in Sonora, Mexico.\r\nID 45608: Duplicate entry for Silver Creek, AZ. The coordinates are in Sonora, Mexico.\r\nID 45610: Duplicate entry for Sycamore Canyon, AZ. The coordinates are in Sonora, Mexico.\r\nID 567773: Duplicate entry for Hovey Hill, ME. The coordinates are in New Brunswick, Canada.\r\nID 581558: Duplicate entry for Saint John River, ME. The coordinates are in New Brunswick, Canada.\r\nID 768593: Duplicate entry for Bear Gulch, MT.  The coordinates are in Alberta, Canada.\r\nID 774267: Duplicate entry for Miners Coulee, MT.  The coordinates are in Alberta, Canada.\r\nID 774784: Duplicate entry for North Fork Milk River, MT.  The coordinates are in Alberta, Canada.\r\nID 775339: Duplicate entry for Police Creek, MT.  The coordinates are in Alberta, Canada.\r\nID 776125: Duplicate entry for Saint Mary River, MT.  The coordinates are in Alberta, Canada.\r\nID 778142: Duplicate entry for Waterton River, MT.  The coordinates are in Alberta, Canada.\r\nID 778545: Duplicate entry for Willow Creek, MT.  The coordinates are in Alberta, Canada.\r\nID 798995: Duplicate entry for Lee Creek, MT.  The coordinates are in Alberta, Canada.\r\nID 790166: Duplicate entry for Screw Creek, MT.  The coordinates are in British Columbia, Canada.\r\nID 793276: Duplicate entry for Wigwam River, MT.  The coordinates are in British Columbia, Canada.\r\nID 1504446: Duplicate entry for Depot Creek, WA.  The coordinates are in British Columbia, Canada.\r\nID 1515954: Duplicate entry for Arnold Slough, WA.  The coordinates are in British Columbia, Canada.\r\nID 1515973: Duplicate entry for Ashnola River, WA.  The coordinates are in British Columbia, Canada.\r\nID 1516047: Duplicate entry for Baker Creek, WA.  The coordinates are in British Columbia, Canada.\r\nID 1517465: Duplicate entry for Castle Creek, WA.  The coordinates are in British Columbia, Canada.\r\nID 1517496: Duplicate entry for Cathedral Fork, WA.  The coordinates are in British Columbia, Canada.\r\nID 1517707: Duplicate entry for Chilliwack River, WA.  The coordinates are in British Columbia, Canada.\r\nID 1517762: Duplicate entry for Chuchuwanteen Creek, WA.  The coordinates are in British Columbia, Canada.\r\nID 1519414: Duplicate entry for Ewart Creek, WA. The coordinates are in British Columbia, Canada.\r\nID 1520446: Duplicate entry for Haig Creek, WA. The coordinates are in British Columbia, Canada.\r\nID 1520654: Duplicate entry for Heather Creek, WA. The coordinates are in British Columbia, Canada.\r\nID 1521214: Duplicate entry for International Creek, WA. The coordinates are in British Columbia, Canada.\r\nID 1523541: Duplicate entry for Myers Creek, WA. The coordinates are in British Columbia, Canada.\r\nID 1523731: Duplicate entry for North Creek, WA. The coordinates are in British Columbia, Canada.\r\nID 1524131: Duplicate entry for Pack Creek, WA. The coordinates are in British Columbia, Canada.\r\nID 1524235: Duplicate entry for Pass Creek, WA. The coordinates are in British Columbia, Canada.\r\nID 1524303: Duplicate entry for Peeve Creek, WA. The coordinates are in British Columbia, Canada.\r\nID 1525297: Duplicate entry for Russian Creek, WA. The coordinates are in British Columbia, Canada.\r\nID 1525320: Duplicate entry for Saar Creek, WA. The coordinates are in British Columbia, Canada.\r\nID 1527272: Duplicate entry for Togo Creek, WA. The coordinates are in British Columbia, Canada.\r\nID 1529904: Duplicate entry for McCoy Creek, WA. The coordinates are in British Columbia, Canada.\r\nID 1529905: Duplicate entry for Liumchen Creek, WA. The coordinates are in British Columbia, Canada.\r\nID 942345: Duplicate entry for Allen Brook, NY. The coordinates are in Quebec, Canada.\r\nID 949668: Duplicate entry for English River, NY. The coordinates are in Quebec, Canada.\r\nID 959094: Duplicate entry for Oak Creek, NY. The coordinates are in Quebec, Canada.\r\nID 967898: Duplicate entry for Trout River, NY. The coordinates are in Quebec, Canada.\r\nID 975764: Duplicate entry for Richelieu River, VT. The coordinates are in Quebec, Canada.\r\nID 1458184: Duplicate entry for Leavit Brook, VT. The coordinates are in Quebec, Canada.\r\nID 1458967: Duplicate entry for Pike River, VT. The coordinates are in Quebec, Canada.\r\nID 1028583: Duplicate entry for Cypress Creek, ND. The coordinates are in Manitoba, Canada.\r\nID 1035871: Duplicate entry for Mowbray Creek, ND. The coordinates are in Manitoba, Canada.\r\nID 1035887: Duplicate entry for Gimby Creek, ND. The coordinates are in Manitoba, Canada.\r\nID 1035890: Duplicate entry for Red River of the North, ND. The coordinates are in Manitoba, Canada.\r\nID 1035895: Duplicate entry for Wakopa Creek, ND. The coordinates are in Manitoba, Canada.\r\nID 1930555: Duplicate entry for Red River of the North, ND. The coordinates are in Manitoba, Canada.\r\nID 1035882: Duplicate entry for East Branch Short Creek, ND. The coordinates are in Saskatchewan, Canada.\r\nID 1782010: Duplicate entry for Manitoulin Basin, MI. The coordinates are in Ontario, Canada<\/pre>\n","protected":false},"excerpt":{"rendered":"
When I went to import the latest GNIS dataset into my local PostGIS database, I found that it contains the same issues I’ve been reporting for the past few years.\u00a0\u00a0 You can find my fixed version of the dataset here. … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"class_list":["post-480","post","type-post","status-publish","format-standard","hentry","category-gis"],"_links":{"self":[{"href":"https:\/\/brian.digitalmaddox.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/480","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/brian.digitalmaddox.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/brian.digitalmaddox.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/brian.digitalmaddox.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/brian.digitalmaddox.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=480"}],"version-history":[{"count":1,"href":"https:\/\/brian.digitalmaddox.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/480\/revisions"}],"predecessor-version":[{"id":481,"href":"https:\/\/brian.digitalmaddox.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/480\/revisions\/481"}],"wp:attachment":[{"href":"https:\/\/brian.digitalmaddox.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=480"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/brian.digitalmaddox.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=480"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/brian.digitalmaddox.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=480"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}