Articles related to GIS from the team that helps B2C companies build and defend revenue with AI.
This post is part of our practical cartography series. Most American geographers will note that - as much as we'd like it to be otherwise - ZIP Codes are not polygons. Rather, they're constantly-changing lines used by the USPS to coordinate delivery in an efficient network. Many of us polygon-happy
I calculated hashes of single-family home addresses in the United States: create table hashtest as ( select house_number_and_street, city, state, digest(upper(house_number_and_street || ',' || city || ',' || state), 'md5') as "md5", digest(upper(house_number_and_street || ',' || city || ','