Mar 26

XML US States Database

XML No Comments »
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)

Tags:
Comments are closed

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

<<  December 2008  >>
MoTuWeThFrSaSu
24252627282930
1234567
891011121314
15161718192021
22232425262728
2930311234

View posts in large calendar