by BizTron
25. March 2008 15:14
I was looking for a List of US Cities and States. This is what I created in the process. I'm still looking for a List of US Cities grouped by State so I can drop it in a SQL Server Database. Then I can extract export it to XML and post it here.
Here are XML Element and XML Attribute representations of US States.
<?xml version="1.0" encoding="utf-8"?>
<US_States>
<US_State StateID="1" State="Alabama" />
<US_State StateID="2" State="Alaska" />
<US_State StateID="3" State="Arizona" />
<US_State StateID="4" State="Arkansas" />
<US_State StateID="5" State="California" />
<US_State StateID="6" State="Colorado" />
<US_State StateID="7" State="Connecticut" />
<US_State StateID="8" State="Delaware" />
<US_State StateID="9" State="Florida" />
<US_State StateID="10" State="Georgia" />
<US_State StateID="11" State="Hawaii" />
<US_State StateID="12" State="Idaho" />
<US_State StateID="13" State="Illinois" />
<US_State StateID="14" State="Indiana" />
<US_State StateID="15" State="Iowa" />
<US_State StateID="16" State="Kansas" />
<US_State StateID="17" State="Kentucky" />
<US_State StateID="18" State="Louisiana" />
<US_State StateID="19" State="Maine" />
<US_State StateID="20" State="Maryland" />
<US_State StateID="21" State="Massachusetts" />
<US_State StateID="22" State="Michigan" />
<US_State StateID="23" State="Minnesota" />
<US_State StateID="24" State="Mississippi" />
<US_State StateID="25" State="Missouri" />
<US_State StateID="26" State="Montana" />
<US_State StateID="27" State="Nebraska" />
<US_State StateID="28" State="Nevada" />
<US_State StateID="29" State="New Hampshire" />
<US_State StateID="30" State="New Jersey" />
<US_State StateID="31" State="New Mexico" />
<US_State StateID="32" State="New York" />
<US_State StateID="33" State="North Carolina" />
<US_State StateID="34" State="North Dakota" />
<US_State StateID="35" State="Ohio" />
<US_State StateID="36" State="Oklahoma" />
<US_State StateID="37" State="Oregon" />
<US_State StateID="38" State="Pennsylvania" />
<US_State StateID="39" State="Rhode Island" />
<US_State StateID="40" State="South Carolina" />
<US_State StateID="41" State="South Dakota" />
<US_State StateID="42" State="Tennessee" />
<US_State StateID="43" State="Texas" />
<US_State StateID="44" State="Utah" />
<US_State StateID="45" State="Vermont" />
<US_State StateID="46" State="Virginia" />
<US_State StateID="47" State="Washington" />
<US_State StateID="48" State="West Virginia" />
<US_State StateID="49" State="Wisconsin" />
<US_State StateID="50" State="Wyoming" />
</US_States>
More... 
Subscribe