Aug
11th
SQL: Full Name Lookup for States and Provinces for the US and Canada
Posted in Development by 
Douglas Karr at 7:06 pm
Douglas Karr at 7:06 pm
While working on the Wild Birds Unlimited Mapping project this weekend, I needed to make a table in MySQL that translated the 2-digit country and state abbreviations to a full name. I’m sure this is something that is needed quite a bit, so I’ve put the SQL file up on my server for download.
Download SQL for State and Province Abbreviations for the United States and Canada. You can right-click and save as if you’d like the file locally. I’ve also added an Index on both the country and state ids to improve performance.
Hat tip to Brian who had a nice CSV I was able to work from.
No comments yet.