XML US States Database

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>


<?xml version="1.0" encoding="utf-8"?>
<US_States>
    <US_State>
        <StateID>1</StateID>
        <State>Alabama</State>
    </US_State>
    <US_State>
        <StateID>2</StateID>
        <State>Alaska</State>
    </US_State>
    <US_State>
        <StateID>3</StateID>
        <State>Arizona</State>
    </US_State>
    <US_State>
        <StateID>4</StateID>
        <State>Arkansas</State>
    </US_State>
    <US_State>
        <StateID>5</StateID>
        <State>California</State>
    </US_State>
    <US_State>
        <StateID>6</StateID>
        <State>Colorado</State>
    </US_State>
    <US_State>
        <StateID>7</StateID>
        <State>Connecticut</State>
    </US_State>
    <US_State>
        <StateID>8</StateID>
        <State>Delaware</State>
    </US_State>
    <US_State>
        <StateID>9</StateID>
        <State>Florida</State>
    </US_State>
    <US_State>
        <StateID>10</StateID>
        <State>Georgia</State>
    </US_State>
    <US_State>
        <StateID>11</StateID>
        <State>Hawaii</State>
    </US_State>
    <US_State>
        <StateID>12</StateID>
        <State>Idaho</State>
    </US_State>
    <US_State>
        <StateID>13</StateID>
        <State>Illinois</State>
    </US_State>
    <US_State>
        <StateID>14</StateID>
        <State>Indiana</State>
    </US_State>
    <US_State>
        <StateID>15</StateID>
        <State>Iowa</State>
    </US_State>
    <US_State>
        <StateID>16</StateID>
        <State>Kansas</State>
    </US_State>
    <US_State>
        <StateID>17</StateID>
        <State>Kentucky</State>
    </US_State>
    <US_State>
        <StateID>18</StateID>
        <State>Louisiana</State>
    </US_State>
    <US_State>
        <StateID>19</StateID>
        <State>Maine</State>
    </US_State>
    <US_State>
        <StateID>20</StateID>
        <State>Maryland</State>
    </US_State>
    <US_State>
        <StateID>21</StateID>
        <State>Massachusetts</State>
    </US_State>
    <US_State>
        <StateID>22</StateID>
        <State>Michigan</State>
    </US_State>
    <US_State>
        <StateID>23</StateID>
        <State>Minnesota</State>
    </US_State>
    <US_State>
        <StateID>24</StateID>
        <State>Mississippi</State>
    </US_State>
    <US_State>
        <StateID>25</StateID>
        <State>Missouri</State>
    </US_State>
    <US_State>
        <StateID>26</StateID>
        <State>Montana</State>
    </US_State>
    <US_State>
        <StateID>27</StateID>
        <State>Nebraska</State>
    </US_State>
    <US_State>
        <StateID>28</StateID>
        <State>Nevada</State>
    </US_State>
    <US_State>
        <StateID>29</StateID>
        <State>New Hampshire</State>
    </US_State>
    <US_State>
        <StateID>30</StateID>
        <State>New Jersey</State>
    </US_State>
    <US_State>
        <StateID>31</StateID>
        <State>New Mexico</State>
    </US_State>
    <US_State>
        <StateID>32</StateID>
        <State>New York</State>
    </US_State>
    <US_State>
        <StateID>33</StateID>
        <State>North Carolina</State>
    </US_State>
    <US_State>
        <StateID>34</StateID>
        <State>North Dakota</State>
    </US_State>
    <US_State>
        <StateID>35</StateID>
        <State>Ohio</State>
    </US_State>
    <US_State>
        <StateID>36</StateID>
        <State>Oklahoma</State>
    </US_State>
    <US_State>
        <StateID>37</StateID>
        <State>Oregon</State>
    </US_State>
    <US_State>
        <StateID>38</StateID>
        <State>Pennsylvania</State>
    </US_State>
    <US_State>
        <StateID>39</StateID>
        <State>Rhode Island</State>
    </US_State>
    <US_State>
        <StateID>40</StateID>
        <State>South Carolina</State>
    </US_State>
    <US_State>
        <StateID>41</StateID>
        <State>South Dakota</State>
    </US_State>
    <US_State>
        <StateID>42</StateID>
        <State>Tennessee</State>
    </US_State>
    <US_State>
        <StateID>43</StateID>
        <State>Texas</State>
    </US_State>
    <US_State>
        <StateID>44</StateID>
        <State>Utah</State>
    </US_State>
    <US_State>
        <StateID>45</StateID>
        <State>Vermont</State>
    </US_State>
    <US_State>
        <StateID>46</StateID>
        <State>Virginia</State>
    </US_State>
    <US_State>
        <StateID>47</StateID>
        <State>Washington</State>
    </US_State>
    <US_State>
        <StateID>48</StateID>
        <State>West Virginia</State>
    </US_State>
    <US_State>
        <StateID>49</StateID>
        <State>Wisconsin</State>
    </US_State>
    <US_State>
        <StateID>50</StateID>
        <State>Wyoming</State>
    </US_State>
</US_States>

US_States_Attributes.xml (2.19 kb)                                                     US_States_Elements.xml (3.60 kb)

March 26, 2008 05:14 PM by BizTron | Comments (0) | Permalink

Add comment


(Will show your Gravatar icon)

  Country flag

biuquote
  • Comment
  • Preview
Loading



About the Author

BizTron BizTron
(aka Dave Petronis)
"Famous" systems architect and software developer, author, and "future President of the United States." View David Petronis's profile on LinkedIn
E-mail me Send mail

Banner
Compusa (Systemax, Inc.)

Calendar

<<  January 2009  >>
MoTuWeThFrSaSu
2930311234
567891011
12131415161718
19202122232425
2627282930311
2345678

View posts in large calendar