<< Use Microsoft SharedView to demo your Windows Desktop | Tech Valley Code Camp on April 19 >>

XML US States Database

by BizTron 25. March 2008 20: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>

<?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)

ac9e080a-dcc8-4788-b356-66e514475996|0|.0

Tags: state list

XML

Free .NET User Group Event - Markus Egger Presents "The State of .NET"Received this e-mail today, it speaks for itself: I just wanted to let you know that Markus Egge...Add Custom DateTime Format to Blog Posts DateTime Format for Blog Posts for BlogEngine.NET ...or wherever you want to standardize ou...Busy night at the controlsWindows Server 2008 Enterprise in a Virtual Machine, Configuring Microsoft Office SharePoint Server ...