[arin-tech-discuss] Official State Abbreviations link?
Aaron Hughes
aaronh at bind.com
Thu Sep 29 11:33:42 EDT 2011
All,
Andy and I have put several versions of the state list together for your implementation pleasure and figured it was appropriate to share with the list. Attached.
Thanks Andy!
Cheers,
Aaron
On Tue, Sep 27, 2011 at 01:15:18PM +0000, Andy Newton wrote:
> Aaron,
>
> In general we try to follow the ISO 3166 codes for countries and regions.
> For mapping states and provinces (regions) to countries in the ARIN region, here is what we use:
>
> -----------------+--------------------------------+--------------+
> STATE_PROV_CODE | STATE_PROV_NAME | COUNTRY_CODE |
> -----------------+--------------------------------+--------------+
> AK | ALASKA | US |
> AS | AMERICAN SAMOA | AS |
> AZ | ARIZONA | US |
> AR | ARKANSAS | US |
> CA | CALIFORNIA | US |
> CO | COLORADO | US |
> CT | CONNECTICUT | US |
> DE | DELAWARE | US |
> DC | DISTRICT OF COLUMBIA | US |
> FM | FEDERATED STATES OF MICRONESIA | FM |
> FL | FLORIDA | US |
> GA | GEORGIA | US |
> GU | GUAM | GU |
> HI | HAWAII | US |
> ID | IDAHO | US |
> IL | ILLINOIS | US |
> IN | INDIANA | US |
> IA | IOWA | US |
> KS | KANSAS | US |
> KY | KENTUCKY | US |
> LA | LOUISIANA | US |
> ME | MAINE | US |
> MH | MARSHALL ISLANDS | MH |
> MD | MARYLAND | US |
> MA | MASSACHUSETTS | US |
> MI | MICHIGAN | US |
> MN | MINNESOTA | US |
> MS | MISSISSIPPI | US |
> MO | MISSOURI | US |
> MT | MONTANA | US |
> NE | NEBRASKA | US |
> NV | NEVADA | US |
> NH | NEW HAMPSHIRE | US |
> NJ | NEW JERSEY | US |
> NM | NEW MEXICO | US |
> NY | NEW YORK | US |
> NC | NORTH CAROLINA | US |
> ND | NORTH DAKOTA | US |
> MP | NORTHERN MARIANA ISLANDS | MP |
> OH | OHIO | US |
> OK | OKLAHOMA | US |
> OR | OREGON | US |
> PW | PALAU | PW |
> PA | PENNSYLVANIA | US |
> PR | PUERTO RICO | PR |
> RI | RHODE ISLAND | US |
> SC | SOUTH CAROLINA | US |
> SD | SOUTH DAKOTA | US |
> TN | TENNESSEE | US |
> TX | TEXAS | US |
> UT | UTAH | US |
> VT | VERMONT | US |
> VI | VIRGIN ISLANDS | VI |
> VA | VIRGINIA | US |
> WA | WASHINGTON | US |
> WV | WEST VIRGINIA | US |
> WI | WISCONSIN | US |
> WY | WYOMING | US |
> AE | ARMED FORCES | US |
> AA | ARMED FORCES AMERICAS | US |
> AP | ARMED FORCES PACIFIC | US |
> AB | ALBERTA | CA |
> BC | BRITISH COLUMBIA | CA |
> MB | MANITOBA | CA |
> NB | NEW BRUNSWICK | CA |
> NL | NEWFOUNDLAND AND LABRADOR | CA |
> NT | NORTHWEST TERRITORIES | CA |
> NS | NOVA SCOTIA | CA |
> NU | NUNAVUT | CA |
> ON | ONTARIO | CA |
> PE | PRINCE EDWARD ISLAND | CA |
> QC | QUEBEC | CA |
> SK | SASKATCHEWAN | CA |
> YT | YUKON | CA |
> AL | ALABAMA | US |
> -----------------+--------------------------------+--------------+
>
>
> And we'll put this into documentation, as you have suggested.
>
> Andy Newton,
> Chief Engineer
>
> On Sep 26, 2011, at 4:19 PM, Aaron Hughes wrote:
>
> > Does ARIN have an officially supported state abbreviations text file link like they do countries? I had an error creating a POC I did not expect and it was due to not enforcing 'CA' vs. California. I was going to parse: https://www.usps.com/send/official-abbreviations.htm but since ARIN has https://www.arin.net/knowledge/rirs/countries.html I was hoping to find a states list.
> >
> > Cheers,
> > Aaron
> >
> >
> > --
> >
> > Aaron Hughes
> > aaronh at bind.com
> > +1-831-824-4161
> > Key fingerprint = AD 67 37 60 7D 73 C5 B7 33 18 3F 36 C3 1C C6 B8
> > http://www.bind.com/
> > _______________________________________________
> > arin-tech-discuss mailing list
> > arin-tech-discuss at arin.net
> > http://lists.arin.net/mailman/listinfo/arin-tech-discuss
--
Aaron Hughes
aaronh at bind.com
+1-831-824-4161
Key fingerprint = AD 67 37 60 7D 73 C5 B7 33 18 3F 36 C3 1C C6 B8
http://www.bind.com/
-------------- next part --------------
"STATE_PROV_CODE","STATE_PROV_NAME","COUNTRY_CODE"
"AK","ALASKA","US"
"AS","AMERICAN SAMOA","AS"
"AZ","ARIZONA","US"
"AR","ARKANSAS","US"
"CA","CALIFORNIA","US"
"CO","COLORADO","US"
"CT","CONNECTICUT","US"
"DE","DELAWARE","US"
"DC","DISTRICT OF COLUMBIA","US"
"FM","FEDERATED STATES OF MICRONESIA","FM"
"FL","FLORIDA","US"
"GA","GEORGIA","US"
"GU","GUAM","GU"
"HI","HAWAII","US"
"ID","IDAHO","US"
"IL","ILLINOIS","US"
"IN","INDIANA","US"
"IA","IOWA","US"
"KS","KANSAS","US"
"KY","KENTUCKY","US"
"LA","LOUISIANA","US"
"ME","MAINE","US"
"MH","MARSHALL ISLANDS","MH"
"MD","MARYLAND","US"
"MA","MASSACHUSETTS","US"
"MI","MICHIGAN","US"
"MN","MINNESOTA","US"
"MS","MISSISSIPPI","US"
"MO","MISSOURI","US"
"MT","MONTANA","US"
"NE","NEBRASKA","US"
"NV","NEVADA","US"
"NH","NEW HAMPSHIRE","US"
"NJ","NEW JERSEY","US"
"NM","NEW MEXICO","US"
"NY","NEW YORK","US"
"NC","NORTH CAROLINA","US"
"ND","NORTH DAKOTA","US"
"MP","NORTHERN MARIANA ISLANDS","MP"
"OH","OHIO","US"
"OK","OKLAHOMA","US"
"OR","OREGON","US"
"PW","PALAU","PW"
"PA","PENNSYLVANIA","US"
"PR","PUERTO RICO","PR"
"RI","RHODE ISLAND","US"
"SC","SOUTH CAROLINA","US"
"SD","SOUTH DAKOTA","US"
"TN","TENNESSEE","US"
"TX","TEXAS","US"
"UT","UTAH","US"
"VT","VERMONT","US"
"VI","VIRGIN ISLANDS","VI"
"VA","VIRGINIA","US"
"WA","WASHINGTON","US"
"WV","WEST VIRGINIA","US"
"WI","WISCONSIN","US"
"WY","WYOMING","US"
"AE","ARMED FORCES","US"
"AA","ARMED FORCES AMERICAS","US"
"AP","ARMED FORCES PACIFIC","US"
"AB","ALBERTA","CA"
"BC","BRITISH COLUMBIA","CA"
"MB","MANITOBA","CA"
"NB","NEW BRUNSWICK","CA"
"NL","NEWFOUNDLAND AND LABRADOR","CA"
"NT","NORTHWEST TERRITORIES","CA"
"NS","NOVA SCOTIA","CA"
"NU","NUNAVUT","CA"
"ON","ONTARIO","CA"
"PE","PRINCE EDWARD ISLAND","CA"
"QC","QUEBEC","CA"
"SK","SASKATCHEWAN","CA"
"YT","YUKON","CA"
"AL","ALABAMA","US"
-------------- next part --------------
<option value="AK">ALASKA - AK</option>
<option value="AS">AMERICAN SAMOA - AS</option>
<option value="AZ">ARIZONA - AZ</option>
<option value="AR">ARKANSAS - AR</option>
<option value="CA">CALIFORNIA - CA</option>
<option value="CO">COLORADO - CO</option>
<option value="CT">CONNECTICUT - CT</option>
<option value="DE">DELAWARE - DE</option>
<option value="DC">DISTRICT OF COLUMBIA - DC</option>
<option value="FM">FEDERATED STATES OF MICRONESIA - FM</option>
<option value="FL">FLORIDA - FL</option>
<option value="GA">GEORGIA - GA</option>
<option value="GU">GUAM - GU</option>
<option value="HI">HAWAII - HI</option>
<option value="ID">IDAHO - ID</option>
<option value="IL">ILLINOIS - IL</option>
<option value="IN">INDIANA - IN</option>
<option value="IA">IOWA - IA</option>
<option value="KS">KANSAS - KS</option>
<option value="KY">KENTUCKY - KY</option>
<option value="LA">LOUISIANA - LA</option>
<option value="ME">MAINE - ME</option>
<option value="MH">MARSHALL ISLANDS - MH</option>
<option value="MD">MARYLAND - MD</option>
<option value="MA">MASSACHUSETTS - MA</option>
<option value="MI">MICHIGAN - MI</option>
<option value="MN">MINNESOTA - MN</option>
<option value="MS">MISSISSIPPI - MS</option>
<option value="MO">MISSOURI - MO</option>
<option value="MT">MONTANA - MT</option>
<option value="NE">NEBRASKA - NE</option>
<option value="NV">NEVADA - NV</option>
<option value="NH">NEW HAMPSHIRE - NH</option>
<option value="NJ">NEW JERSEY - NJ</option>
<option value="NM">NEW MEXICO - NM</option>
<option value="NY">NEW YORK - NY</option>
<option value="NC">NORTH CAROLINA - NC</option>
<option value="ND">NORTH DAKOTA - ND</option>
<option value="MP">NORTHERN MARIANA ISLANDS - MP</option>
<option value="OH">OHIO - OH</option>
<option value="OK">OKLAHOMA - OK</option>
<option value="OR">OREGON - OR</option>
<option value="PW">PALAU - PW</option>
<option value="PA">PENNSYLVANIA - PA</option>
<option value="PR">PUERTO RICO - PR</option>
<option value="RI">RHODE ISLAND - RI</option>
<option value="SC">SOUTH CAROLINA - SC</option>
<option value="SD">SOUTH DAKOTA - SD</option>
<option value="TN">TENNESSEE - TN</option>
<option value="TX">TEXAS - TX</option>
<option value="UT">UTAH - UT</option>
<option value="VT">VERMONT - VT</option>
<option value="VI">VIRGIN ISLANDS - VI</option>
<option value="VA">VIRGINIA - VA</option>
<option value="WA">WASHINGTON - WA</option>
<option value="WV">WEST VIRGINIA - WV</option>
<option value="WI">WISCONSIN - WI</option>
<option value="WY">WYOMING - WY</option>
<option value="AE">ARMED FORCES - AE</option>
<option value="AA">ARMED FORCES AMERICAS - AA</option>
<option value="AP">ARMED FORCES PACIFIC - AP</option>
<option value="AB">ALBERTA - AB</option>
<option value="BC">BRITISH COLUMBIA - BC</option>
<option value="MB">MANITOBA - MB</option>
<option value="NB">NEW BRUNSWICK - NB</option>
<option value="NL">NEWFOUNDLAND AND LABRADOR - NL</option>
<option value="NT">NORTHWEST TERRITORIES - NT</option>
<option value="NS">NOVA SCOTIA - NS</option>
<option value="NU">NUNAVUT - NU</option>
<option value="ON">ONTARIO - ON</option>
<option value="PE">PRINCE EDWARD ISLAND - PE</option>
<option value="QC">QUEBEC - QC</option>
<option value="SK">SASKATCHEWAN - SK</option>
<option value="YT">YUKON - YT</option>
<option value="AL">ALABAMA - AL</option>
-------------- next part --------------
-- INSERTING into STATE_PROV
Insert into STATE_PROV (STATE_PROV_CODE,STATE_PROV_NAME,COUNTRY_CODE) values ('AK','ALASKA','US');
Insert into STATE_PROV (STATE_PROV_CODE,STATE_PROV_NAME,COUNTRY_CODE) values ('AS','AMERICAN SAMOA','AS');
Insert into STATE_PROV (STATE_PROV_CODE,STATE_PROV_NAME,COUNTRY_CODE) values ('AZ','ARIZONA','US');
Insert into STATE_PROV (STATE_PROV_CODE,STATE_PROV_NAME,COUNTRY_CODE) values ('AR','ARKANSAS','US');
Insert into STATE_PROV (STATE_PROV_CODE,STATE_PROV_NAME,COUNTRY_CODE) values ('CA','CALIFORNIA','US');
Insert into STATE_PROV (STATE_PROV_CODE,STATE_PROV_NAME,COUNTRY_CODE) values ('CO','COLORADO','US');
Insert into STATE_PROV (STATE_PROV_CODE,STATE_PROV_NAME,COUNTRY_CODE) values ('CT','CONNECTICUT','US');
Insert into STATE_PROV (STATE_PROV_CODE,STATE_PROV_NAME,COUNTRY_CODE) values ('DE','DELAWARE','US');
Insert into STATE_PROV (STATE_PROV_CODE,STATE_PROV_NAME,COUNTRY_CODE) values ('DC','DISTRICT OF COLUMBIA','US');
Insert into STATE_PROV (STATE_PROV_CODE,STATE_PROV_NAME,COUNTRY_CODE) values ('FM','FEDERATED STATES OF MICRONESIA','FM');
Insert into STATE_PROV (STATE_PROV_CODE,STATE_PROV_NAME,COUNTRY_CODE) values ('FL','FLORIDA','US');
Insert into STATE_PROV (STATE_PROV_CODE,STATE_PROV_NAME,COUNTRY_CODE) values ('GA','GEORGIA','US');
Insert into STATE_PROV (STATE_PROV_CODE,STATE_PROV_NAME,COUNTRY_CODE) values ('GU','GUAM','GU');
Insert into STATE_PROV (STATE_PROV_CODE,STATE_PROV_NAME,COUNTRY_CODE) values ('HI','HAWAII','US');
Insert into STATE_PROV (STATE_PROV_CODE,STATE_PROV_NAME,COUNTRY_CODE) values ('ID','IDAHO','US');
Insert into STATE_PROV (STATE_PROV_CODE,STATE_PROV_NAME,COUNTRY_CODE) values ('IL','ILLINOIS','US');
Insert into STATE_PROV (STATE_PROV_CODE,STATE_PROV_NAME,COUNTRY_CODE) values ('IN','INDIANA','US');
Insert into STATE_PROV (STATE_PROV_CODE,STATE_PROV_NAME,COUNTRY_CODE) values ('IA','IOWA','US');
Insert into STATE_PROV (STATE_PROV_CODE,STATE_PROV_NAME,COUNTRY_CODE) values ('KS','KANSAS','US');
Insert into STATE_PROV (STATE_PROV_CODE,STATE_PROV_NAME,COUNTRY_CODE) values ('KY','KENTUCKY','US');
Insert into STATE_PROV (STATE_PROV_CODE,STATE_PROV_NAME,COUNTRY_CODE) values ('LA','LOUISIANA','US');
Insert into STATE_PROV (STATE_PROV_CODE,STATE_PROV_NAME,COUNTRY_CODE) values ('ME','MAINE','US');
Insert into STATE_PROV (STATE_PROV_CODE,STATE_PROV_NAME,COUNTRY_CODE) values ('MH','MARSHALL ISLANDS','MH');
Insert into STATE_PROV (STATE_PROV_CODE,STATE_PROV_NAME,COUNTRY_CODE) values ('MD','MARYLAND','US');
Insert into STATE_PROV (STATE_PROV_CODE,STATE_PROV_NAME,COUNTRY_CODE) values ('MA','MASSACHUSETTS','US');
Insert into STATE_PROV (STATE_PROV_CODE,STATE_PROV_NAME,COUNTRY_CODE) values ('MI','MICHIGAN','US');
Insert into STATE_PROV (STATE_PROV_CODE,STATE_PROV_NAME,COUNTRY_CODE) values ('MN','MINNESOTA','US');
Insert into STATE_PROV (STATE_PROV_CODE,STATE_PROV_NAME,COUNTRY_CODE) values ('MS','MISSISSIPPI','US');
Insert into STATE_PROV (STATE_PROV_CODE,STATE_PROV_NAME,COUNTRY_CODE) values ('MO','MISSOURI','US');
Insert into STATE_PROV (STATE_PROV_CODE,STATE_PROV_NAME,COUNTRY_CODE) values ('MT','MONTANA','US');
Insert into STATE_PROV (STATE_PROV_CODE,STATE_PROV_NAME,COUNTRY_CODE) values ('NE','NEBRASKA','US');
Insert into STATE_PROV (STATE_PROV_CODE,STATE_PROV_NAME,COUNTRY_CODE) values ('NV','NEVADA','US');
Insert into STATE_PROV (STATE_PROV_CODE,STATE_PROV_NAME,COUNTRY_CODE) values ('NH','NEW HAMPSHIRE','US');
Insert into STATE_PROV (STATE_PROV_CODE,STATE_PROV_NAME,COUNTRY_CODE) values ('NJ','NEW JERSEY','US');
Insert into STATE_PROV (STATE_PROV_CODE,STATE_PROV_NAME,COUNTRY_CODE) values ('NM','NEW MEXICO','US');
Insert into STATE_PROV (STATE_PROV_CODE,STATE_PROV_NAME,COUNTRY_CODE) values ('NY','NEW YORK','US');
Insert into STATE_PROV (STATE_PROV_CODE,STATE_PROV_NAME,COUNTRY_CODE) values ('NC','NORTH CAROLINA','US');
Insert into STATE_PROV (STATE_PROV_CODE,STATE_PROV_NAME,COUNTRY_CODE) values ('ND','NORTH DAKOTA','US');
Insert into STATE_PROV (STATE_PROV_CODE,STATE_PROV_NAME,COUNTRY_CODE) values ('MP','NORTHERN MARIANA ISLANDS','MP');
Insert into STATE_PROV (STATE_PROV_CODE,STATE_PROV_NAME,COUNTRY_CODE) values ('OH','OHIO','US');
Insert into STATE_PROV (STATE_PROV_CODE,STATE_PROV_NAME,COUNTRY_CODE) values ('OK','OKLAHOMA','US');
Insert into STATE_PROV (STATE_PROV_CODE,STATE_PROV_NAME,COUNTRY_CODE) values ('OR','OREGON','US');
Insert into STATE_PROV (STATE_PROV_CODE,STATE_PROV_NAME,COUNTRY_CODE) values ('PW','PALAU','PW');
Insert into STATE_PROV (STATE_PROV_CODE,STATE_PROV_NAME,COUNTRY_CODE) values ('PA','PENNSYLVANIA','US');
Insert into STATE_PROV (STATE_PROV_CODE,STATE_PROV_NAME,COUNTRY_CODE) values ('PR','PUERTO RICO','PR');
Insert into STATE_PROV (STATE_PROV_CODE,STATE_PROV_NAME,COUNTRY_CODE) values ('RI','RHODE ISLAND','US');
Insert into STATE_PROV (STATE_PROV_CODE,STATE_PROV_NAME,COUNTRY_CODE) values ('SC','SOUTH CAROLINA','US');
Insert into STATE_PROV (STATE_PROV_CODE,STATE_PROV_NAME,COUNTRY_CODE) values ('SD','SOUTH DAKOTA','US');
Insert into STATE_PROV (STATE_PROV_CODE,STATE_PROV_NAME,COUNTRY_CODE) values ('TN','TENNESSEE','US');
Insert into STATE_PROV (STATE_PROV_CODE,STATE_PROV_NAME,COUNTRY_CODE) values ('TX','TEXAS','US');
Insert into STATE_PROV (STATE_PROV_CODE,STATE_PROV_NAME,COUNTRY_CODE) values ('UT','UTAH','US');
Insert into STATE_PROV (STATE_PROV_CODE,STATE_PROV_NAME,COUNTRY_CODE) values ('VT','VERMONT','US');
Insert into STATE_PROV (STATE_PROV_CODE,STATE_PROV_NAME,COUNTRY_CODE) values ('VI','VIRGIN ISLANDS','VI');
Insert into STATE_PROV (STATE_PROV_CODE,STATE_PROV_NAME,COUNTRY_CODE) values ('VA','VIRGINIA','US');
Insert into STATE_PROV (STATE_PROV_CODE,STATE_PROV_NAME,COUNTRY_CODE) values ('WA','WASHINGTON','US');
Insert into STATE_PROV (STATE_PROV_CODE,STATE_PROV_NAME,COUNTRY_CODE) values ('WV','WEST VIRGINIA','US');
Insert into STATE_PROV (STATE_PROV_CODE,STATE_PROV_NAME,COUNTRY_CODE) values ('WI','WISCONSIN','US');
Insert into STATE_PROV (STATE_PROV_CODE,STATE_PROV_NAME,COUNTRY_CODE) values ('WY','WYOMING','US');
Insert into STATE_PROV (STATE_PROV_CODE,STATE_PROV_NAME,COUNTRY_CODE) values ('AE','ARMED FORCES','US');
Insert into STATE_PROV (STATE_PROV_CODE,STATE_PROV_NAME,COUNTRY_CODE) values ('AA','ARMED FORCES AMERICAS','US');
Insert into STATE_PROV (STATE_PROV_CODE,STATE_PROV_NAME,COUNTRY_CODE) values ('AP','ARMED FORCES PACIFIC','US');
Insert into STATE_PROV (STATE_PROV_CODE,STATE_PROV_NAME,COUNTRY_CODE) values ('AB','ALBERTA','CA');
Insert into STATE_PROV (STATE_PROV_CODE,STATE_PROV_NAME,COUNTRY_CODE) values ('BC','BRITISH COLUMBIA','CA');
Insert into STATE_PROV (STATE_PROV_CODE,STATE_PROV_NAME,COUNTRY_CODE) values ('MB','MANITOBA','CA');
Insert into STATE_PROV (STATE_PROV_CODE,STATE_PROV_NAME,COUNTRY_CODE) values ('NB','NEW BRUNSWICK','CA');
Insert into STATE_PROV (STATE_PROV_CODE,STATE_PROV_NAME,COUNTRY_CODE) values ('NL','NEWFOUNDLAND AND LABRADOR','CA');
Insert into STATE_PROV (STATE_PROV_CODE,STATE_PROV_NAME,COUNTRY_CODE) values ('NT','NORTHWEST TERRITORIES','CA');
Insert into STATE_PROV (STATE_PROV_CODE,STATE_PROV_NAME,COUNTRY_CODE) values ('NS','NOVA SCOTIA','CA');
Insert into STATE_PROV (STATE_PROV_CODE,STATE_PROV_NAME,COUNTRY_CODE) values ('NU','NUNAVUT','CA');
Insert into STATE_PROV (STATE_PROV_CODE,STATE_PROV_NAME,COUNTRY_CODE) values ('ON','ONTARIO','CA');
Insert into STATE_PROV (STATE_PROV_CODE,STATE_PROV_NAME,COUNTRY_CODE) values ('PE','PRINCE EDWARD ISLAND','CA');
Insert into STATE_PROV (STATE_PROV_CODE,STATE_PROV_NAME,COUNTRY_CODE) values ('QC','QUEBEC','CA');
Insert into STATE_PROV (STATE_PROV_CODE,STATE_PROV_NAME,COUNTRY_CODE) values ('SK','SASKATCHEWAN','CA');
Insert into STATE_PROV (STATE_PROV_CODE,STATE_PROV_NAME,COUNTRY_CODE) values ('YT','YUKON','CA');
Insert into STATE_PROV (STATE_PROV_CODE,STATE_PROV_NAME,COUNTRY_CODE) values ('AL','ALABAMA','US');
-------------- next part --------------
A non-text attachment was scrubbed...
Name: STATE_PROV.xml
Type: application/xml
Size: 13437 bytes
Desc: not available
URL: <https://lists.arin.net/pipermail/arin-tech-discuss/attachments/20110929/2a79884d/attachment.wsdl>
More information about the arin-tech-discuss
mailing list