Solved

Relationship expected error though only one SQL table?

Posted on 2007-12-02
6
1,206 Views
Last Modified: 2008-02-01
My fellow Earthicans,

I am attempting to import data from an XML file (trip.xml) into a SQL Server 2005 EE database table (Traffic.dbo.RawTrip).

I created an XML schema file (trip.xsd) posted below.

All elements and attributes are mapped to the same and only table, RawTrip.

When I run standard VBScript to bulk load using SQLXML (SQLXMLBulkload.3.0) I get this error;

<?xml version="1.0"?>
<Result State="FAILED">
 <Error>
  <HResult>0x8000FFFF</HResult>
   <Description>
    <![CDATA[Schema: relationship expected on 'route'.]]>
   </Description>
  <Source>Schema mapping</Source>
  <Type>FATAL</Type>
 </Error>
</Result>

This is my database table;

CREATE TABLE [dbo].[RawTrip](
      [TripTimeStamp] [nvarchar](50) NULL,
      [RouteID] [nvarchar](50) NULL,
      [RouteName] [nvarchar](50) NULL,
      [DirectionID] [nvarchar](50) NULL,
      [DirectionName] [nvarchar](50) NULL,
      [StartID] [nvarchar](50) NULL,
      [StartTitle] [nvarchar](50) NULL,
      [StartSysPos] [nvarchar](50) NULL,
      [StopID] [nvarchar](50) NULL,
      [StopTitle] [nvarchar](50) NULL,
      [StopSysPos] [nvarchar](50) NULL,
      [TripTime] [nvarchar](50) NULL,
      [TripTimeUnits] [nvarchar](50) NULL,
      [CoverageMiles] [nvarchar](50) NULL,
      [CoveragePercent] [nvarchar](50) NULL,
      [AvgSpeed] [nvarchar](50) NULL,
      [AvgSpeedUnits] [nvarchar](50) NULL,
      [Distance] [nvarchar](50) NULL,
      [DistanceUnits] [nvarchar](50) NULL
) ON [PRIMARY]


If all of my fields live in the same table why do I need to define a relationship for element 'route'?

How can I define a parent-child relationship when both fields are in the same table?

I have seen lots of other people have the same issue when I check Google, but no one has a resolution!

I develop reports, I am a total n00b with XML. The project is a personal hobby. I want to collect the data used by the Georgia DOT for their NaviGAtor system which is refreshed every 3 minutes. I want that data in a database so that I can do a little analysis and modeling.

Thanks for any help or suggestions!

-James


<?xml version="1.0" encoding="UTF-8"?>
<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:sql="urn:schemas-microsoft-com:mapping-schema">
 
	<xsd:element name="trip-report" sql:relation="RawTrip">
		<xsd:complexType>
			<xsd:all>
				<xsd:element name="route" >
					<xsd:complexType>
						<xsd:all>
							<xsd:element name="direction">
								<xsd:complexType>
									<xsd:all>
										<xsd:element name="start">
											<xsd:complexType>
												<xsd:all>
													<xsd:element name="stop">
														<xsd:complexType>
															<xsd:all>
																<xsd:element name="distance" sql:field="Distance">
																	<xsd:complexType>
																		<xsd:attribute name="units" sql:field="DistanceUnits" type="xsd:string" />
																	</xsd:complexType>
																</xsd:element>
																<xsd:element name="avg-speed" sql:field="AvgSpeed">
																	<xsd:complexType>
																		<xsd:attribute name="units" sql:field="AvgSpeedUnits" type="xsd:string" />
																	</xsd:complexType>
																</xsd:element>
																<xsd:element name="coverage">
																	<xsd:complexType>
																		<xsd:attribute name="miles" sql:field="CoverageMiles" type="xsd:string" />
																		<xsd:attribute name="pct" sql:field="CoveragePercent" type="xsd:string" />
																	</xsd:complexType>
																</xsd:element>
																<xsd:element name="trip-time" sql:field="TripTime">
																	<xsd:complexType>
																		<xsd:attribute name="units" sql:field="TripTimeUnits" type="xsd:string" />
																	</xsd:complexType>
																</xsd:element>
															</xsd:all>
															<xsd:attribute name="id" sql:field="StopID" type="xsd:string" />
															<xsd:attribute name="title" sql:field="StopTitle" type="xsd:string" />
															<xsd:attribute name="sys-pos" sql:field="StopSysPos" type="xsd:string" />
														</xsd:complexType>
													</xsd:element>
												</xsd:all>
												<xsd:attribute name="id" sql:field="StartID" type="xsd:string" />
												<xsd:attribute name="title" sql:field="StartTitle" type="xsd:string" />
												<xsd:attribute name="sys-pos" sql:field="StartSysPos" type="xsd:string" />
											</xsd:complexType>
										</xsd:element>
									</xsd:all>
									<xsd:attribute name="id" sql:field="DirectionID" type="xsd:string" />
									<xsd:attribute name="name" sql:field="DirectionName" type="xsd:string" />
								</xsd:complexType>
							</xsd:element>
						</xsd:all>
						<xsd:attribute name="id" sql:field="RouteID" type="xsd:string" />
						<xsd:attribute name="name" sql:field="RouteName" type="xsd:string" />
					</xsd:complexType>
				</xsd:element>
			</xsd:all>
			<xsd:attribute name="timestamp" sql:field="TripTimeStamp" type="xsd:string" />
		</xsd:complexType>
	</xsd:element>
</xsd:schema>

Open in new window

0
Comment
Question by:randomjames
  • 3
  • 3
6 Comments
 
LVL 25

Accepted Solution

by:
imitchie earned 500 total points
ID: 20392005
I will hazard a guess that it's due to
sql:relation="RawTrip"
which requires you to set up a particular child element to be the relationship key
0
 
LVL 3

Author Comment

by:randomjames
ID: 20392074
Thanks for the comment imitchie.

I thought I needed sql:relation="RawTrip" to tell the data which table it belongs in.

If I take that out then should I put something else in to point the data to the table where I want it to go?

If I need that then do I just arbitrarily pick a key for a relationship that has only one table?

How do I set a parent-child relationship when there is just one table? {What is the sound of one hand clapping?}

Any idea where there is some good documentation on this? I haven't seen anything that really explains this well (for example, http://msdn2.microsoft.com/en-us/library/aa258648(SQL.80).aspx).
0
 
LVL 25

Expert Comment

by:imitchie
ID: 20392426
The problem is that your pattern:

<xsd:element name="route" >
                                        <xsd:complexType>
                                                <xsd:all>
                                                        <xsd:element name="direction">
                                                                <xsd:complexType>
                                                                        <xsd:all>
Means that direction is a child of route, and so on. So you have in fact about 10 levels of data.
The example from http://itdevcorner.blogspot.com/2007/05/in-my-earlier-post-i-mentioned-about.html
only has a single xsd:sequence of xsd:elements - to signify the elements on the same level (single table)
0
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 
LVL 3

Author Comment

by:randomjames
ID: 20392532
Here is the actual XML file...direction is a child of route, at least in the XML file (right?).

You see in my database table though all the elements and attributes (my fields) are going to the same table, which I believe makes sense...

If I try to take out xsd:all it doesn't open in XML Notepad. If I only take out some, or only leave one xsd:all it doesn't open in XML Notepad.
<?xml version="1.0"?>
<!-- Trip time report from the Georgia DOT's Navigator ITS. -->
<!-- Visit us online at http://georgia-navigator.com/. -->
<!-- Access raw data at http://data.georgia-navigator.com/. -->
<!-- Contact webmaster@georgia-navigator.com for permission to reuse this data. -->
<!-- Copyright (c) 2007 Georgia DOT.  All rights reserved. -->
<!-- note: timestamps are in the Eastern timezone. -->
 
<trip-report timestamp="2007-11-25T00:10:01">
  <route id="166" name="SR 166">
    <direction id="West" name="West">
      <start id="3" title="I-75/85." sys-pos="10063.16">
        <stop id="2" title="Stanton Rd." sys-pos="10060.70">
          <distance units="miles">2.46</distance>
          <avg-speed units="mph">62</avg-speed>
          <coverage miles="2.79" pct="113" />
          <trip-time units="min">2</trip-time>
        </stop>
        <stop id="1" title="I-285" sys-pos="10057.45">
          <distance units="miles">5.71</distance>
          <avg-speed units="mph">63</avg-speed>
          <coverage miles="6.01" pct="105" />
          <trip-time units="min">5</trip-time>
        </stop>
      </start>
      <start id="2" title="Stanton Rd." sys-pos="10060.70">
        <stop id="1" title="I-285" sys-pos="10057.45">
          <distance units="miles">3.25</distance>
          <avg-speed units="mph">63</avg-speed>
          <coverage miles="3.52" pct="108" />
          <trip-time units="min">3</trip-time>
        </stop>
      </start>
      <start id="1" title="I-285" sys-pos="10057.45"></start>
    </direction>
    <direction id="East" name="East">
      <start id="1" title="I-285" sys-pos="10057.45">
        <stop id="2" title="Stanton Rd." sys-pos="10060.70">
          <distance units="miles">3.25</distance>
          <avg-speed units="mph">63</avg-speed>
          <coverage miles="3.52" pct="108" />
          <trip-time units="min">3</trip-time>
        </stop>
        <stop id="3" title="I-75/85." sys-pos="10063.16">
          <distance units="miles">5.71</distance>
          <avg-speed units="mph">62</avg-speed>
          <coverage miles="6.01" pct="105" />
          <trip-time units="min">5</trip-time>
        </stop>
      </start>
      <start id="2" title="Stanton Rd." sys-pos="10060.70">
        <stop id="3" title="I-75/85." sys-pos="10063.16">
          <distance units="miles">2.46</distance>
          <avg-speed units="mph">61</avg-speed>
          <coverage miles="2.79" pct="113" />
          <trip-time units="min">2</trip-time>
        </stop>
      </start>
      <start id="3" title="I-75/85." sys-pos="10063.16"></start>
    </direction>
  </route>
  <route id="85" name="I-85">
    <direction id="South" name="South">
      <start id="8" title="SR-316" sys-pos="10271.00">
        <stop id="7" title="Indian Trail Rd." sys-pos="10266.39">
          <distance units="miles">4.61</distance>
          <avg-speed units="mph">67</avg-speed>
          <coverage miles="4.26" pct="92" />
          <trip-time units="min">4</trip-time>
        </stop>
        <stop id="6" title="I-285 (northside)" sys-pos="10261.40">
          <distance units="miles">9.60</distance>
          <avg-speed units="mph">66</avg-speed>
          <coverage miles="9.75" pct="102" />
          <trip-time units="min">9</trip-time>
        </stop>
        <stop id="5" title="Clairmont Rd." sys-pos="10256.55">
          <distance units="miles">14.45</distance>
          <avg-speed units="mph">66</avg-speed>
          <coverage miles="14.95" pct="103" />
          <trip-time units="min">13</trip-time>
        </stop>
        <stop id="4" title="Brookwood Interchange" sys-pos="10250.63">
          <distance units="miles">20.37</distance>
          <avg-speed units="mph">67</avg-speed>
          <coverage miles="20.86" pct="102" />
          <trip-time units="min">18</trip-time>
        </stop>
        <stop id="3" title="I-20" sys-pos="10246.57">
          <distance units="miles">24.43</distance>
          <avg-speed units="mph">67</avg-speed>
          <coverage miles="24.66" pct="101" />
          <trip-time units="min">22</trip-time>
        </stop>
        <stop id="2" title="SR 166 / Langford Pky." sys-pos="10243.05">
          <distance units="miles">27.95</distance>
          <avg-speed units="mph">68</avg-speed>
          <coverage miles="28.08" pct="100" />
          <trip-time units="min">25</trip-time>
        </stop>
        <stop id="1" title="Camp Creek / Airport" sys-pos="10237.95">
          <distance units="miles">33.05</distance>
          <avg-speed units="mph">67</avg-speed>
          <coverage miles="33.04" pct="100" />
          <trip-time units="min">30</trip-time>
        </stop>
      </start>
      <start id="7" title="Indian Trail Rd." sys-pos="10266.39">
        <stop id="6" title="I-285 (northside)" sys-pos="10261.40">
          <distance units="miles">4.99</distance>
          <avg-speed units="mph">65</avg-speed>
          <coverage miles="5.49" pct="110" />
          <trip-time units="min">5</trip-time>
        </stop>
        <stop id="5" title="Clairmont Rd." sys-pos="10256.55">
          <distance units="miles">9.84</distance>
          <avg-speed units="mph">66</avg-speed>
          <coverage miles="10.69" pct="109" />
          <trip-time units="min">9</trip-time>
        </stop>
        <stop id="4" title="Brookwood Interchange" sys-pos="10250.63">
          <distance units="miles">15.76</distance>
          <avg-speed units="mph">67</avg-speed>
          <coverage miles="16.6" pct="105" />
          <trip-time units="min">14</trip-time>
        </stop>
        <stop id="3" title="I-20" sys-pos="10246.57">
          <distance units="miles">19.82</distance>
          <avg-speed units="mph">67</avg-speed>
          <coverage miles="20.4" pct="103" />
          <trip-time units="min">18</trip-time>
        </stop>
        <stop id="2" title="SR 166 / Langford Pky." sys-pos="10243.05">
          <distance units="miles">23.34</distance>
          <avg-speed units="mph">68</avg-speed>
          <coverage miles="23.82" pct="102" />
          <trip-time units="min">21</trip-time>
        </stop>
        <stop id="1" title="Camp Creek / Airport" sys-pos="10237.95">
          <distance units="miles">28.44</distance>
          <avg-speed units="mph">67</avg-speed>
          <coverage miles="28.78" pct="101" />
          <trip-time units="min">26</trip-time>
        </stop>
      </start>
      <start id="6" title="I-285 (northside)" sys-pos="10261.40">
        <stop id="5" title="Clairmont Rd." sys-pos="10256.55">
          <distance units="miles">4.85</distance>
          <avg-speed units="mph">66</avg-speed>
          <coverage miles="5.2" pct="107" />
          <trip-time units="min">4</trip-time>
        </stop>
        <stop id="4" title="Brookwood Interchange" sys-pos="10250.63">
          <distance units="miles">10.77</distance>
          <avg-speed units="mph">68</avg-speed>
          <coverage miles="11.11" pct="103" />
          <trip-time units="min">9</trip-time>
        </stop>
        <stop id="3" title="I-20" sys-pos="10246.57">
          <distance units="miles">14.83</distance>
          <avg-speed units="mph">68</avg-speed>
          <coverage miles="14.91" pct="101" />
          <trip-time units="min">13</trip-time>
        </stop>
        <stop id="2" title="SR 166 / Langford Pky." sys-pos="10243.05">
          <distance units="miles">18.35</distance>
          <avg-speed units="mph">68</avg-speed>
          <coverage miles="18.33" pct="100" />
          <trip-time units="min">16</trip-time>
        </stop>
        <stop id="1" title="Camp Creek / Airport" sys-pos="10237.95">
          <distance units="miles">23.45</distance>
          <avg-speed units="mph">68</avg-speed>
          <coverage miles="23.29" pct="99" />
          <trip-time units="min">21</trip-time>
        </stop>
      </start>
      <start id="5" title="Clairmont Rd." sys-pos="10256.55">
        <stop id="4" title="Brookwood Interchange" sys-pos="10250.63">
          <distance units="miles">5.92</distance>
          <avg-speed units="mph">70</avg-speed>
          <coverage miles="5.91" pct="100" />
          <trip-time units="min">5</trip-time>
        </stop>
        <stop id="3" title="I-20" sys-pos="10246.57">
          <distance units="miles">9.98</distance>
          <avg-speed units="mph">68</avg-speed>
          <coverage miles="9.71" pct="97" />
          <trip-time units="min">9</trip-time>
        </stop>
        <stop id="2" title="SR 166 / Langford Pky." sys-pos="10243.05">
          <distance units="miles">13.50</distance>
          <avg-speed units="mph">69</avg-speed>
          <coverage miles="13.13" pct="97" />
          <trip-time units="min">12</trip-time>
        </stop>
        <stop id="1" title="Camp Creek / Airport" sys-pos="10237.95">
          <distance units="miles">18.60</distance>
          <avg-speed units="mph">68</avg-speed>
          <coverage miles="18.09" pct="97" />
          <trip-time units="min">17</trip-time>
        </stop>
      </start>
      <start id="4" title="Brookwood Interchange" sys-pos="10250.63">
        <stop id="3" title="I-20" sys-pos="10246.57">
          <distance units="miles">4.06</distance>
          <avg-speed units="mph">65</avg-speed>
          <coverage miles="3.8" pct="94" />
          <trip-time units="min">4</trip-time>
        </stop>
        <stop id="2" title="SR 166 / Langford Pky." sys-pos="10243.05">
          <distance units="miles">7.58</distance>
          <avg-speed units="mph">69</avg-speed>
          <coverage miles="7.22" pct="95" />
          <trip-time units="min">7</trip-time>
        </stop>
        <stop id="1" title="Camp Creek / Airport" sys-pos="10237.95">
          <distance units="miles">12.68</distance>
          <avg-speed units="mph">67</avg-speed>
          <coverage miles="12.18" pct="96" />
          <trip-time units="min">12</trip-time>
        </stop>
      </start>
      <start id="3" title="I-20" sys-pos="10246.57">
        <stop id="2" title="SR 166 / Langford Pky." sys-pos="10243.05">
          <distance units="miles">3.52</distance>
          <avg-speed units="mph">72</avg-speed>
          <coverage miles="3.42" pct="97" />
          <trip-time units="min">3</trip-time>
        </stop>
        <stop id="1" title="Camp Creek / Airport" sys-pos="10237.95">
          <distance units="miles">8.62</distance>
          <avg-speed units="mph">67</avg-speed>
          <coverage miles="8.38" pct="97" />
          <trip-time units="min">8</trip-time>
        </stop>
      </start>
      <start id="2" title="SR 166 / Langford Pky." sys-pos="10243.05">
        <stop id="1" title="Camp Creek / Airport" sys-pos="10237.95">
          <distance units="miles">5.10</distance>
          <avg-speed units="mph">64</avg-speed>
          <coverage miles="4.96" pct="97" />
          <trip-time units="min">5</trip-time>
        </stop>
      </start>
      <start id="1" title="Camp Creek / Airport" sys-pos="10237.95"></start>
    </direction>
    <direction id="North" name="North">
      <start id="1" title="Camp Creek / Airport" sys-pos="10237.95">
        <stop id="2" title="SR 166 / Langford Pky." sys-pos="10243.05">
          <distance units="miles">5.10</distance>
          <avg-speed units="mph">71</avg-speed>
          <coverage miles="4.59" pct="90" />
          <trip-time units="min">4</trip-time>
        </stop>
        <stop id="3" title="I-20" sys-pos="10246.57">
          <distance units="miles">8.62</distance>
          <avg-speed units="mph">68</avg-speed>
          <coverage miles="7.99" pct="93" />
          <trip-time units="min">7</trip-time>
        </stop>
        <stop id="4" title="Brookwood Interchange" sys-pos="10250.63">
          <distance units="miles">12.68</distance>
          <avg-speed units="mph">67</avg-speed>
          <coverage miles="11.61" pct="92" />
        </stop>
        <stop id="5" title="Clairmont Rd." sys-pos="10256.55">
          <distance units="miles">18.60</distance>
          <avg-speed units="mph">66</avg-speed>
          <coverage miles="17.58" pct="95" />
        </stop>
        <stop id="6" title="I-285 (northside)" sys-pos="10261.40">
          <distance units="miles">23.45</distance>
          <avg-speed units="mph">65</avg-speed>
          <coverage miles="22.49" pct="96" />
        </stop>
        <stop id="7" title="Indian Trail Rd." sys-pos="10266.39">
          <distance units="miles">28.44</distance>
          <avg-speed units="mph">64</avg-speed>
          <coverage miles="27.94" pct="98" />
        </stop>
        <stop id="8" title="SR-316" sys-pos="10271.00">
          <distance units="miles">33.05</distance>
          <avg-speed units="mph">63</avg-speed>
          <coverage miles="31.56" pct="95" />
        </stop>
      </start>
      <start id="2" title="SR 166 / Langford Pky." sys-pos="10243.05">
        <stop id="3" title="I-20" sys-pos="10246.57">
          <distance units="miles">3.52</distance>
          <avg-speed units="mph">64</avg-speed>
          <coverage miles="3.4" pct="97" />
          <trip-time units="min">3</trip-time>
        </stop>
        <stop id="4" title="Brookwood Interchange" sys-pos="10250.63">
          <distance units="miles">7.58</distance>
          <avg-speed units="mph">64</avg-speed>
          <coverage miles="7.02" pct="93" />
        </stop>
        <stop id="5" title="Clairmont Rd." sys-pos="10256.55">
          <distance units="miles">13.50</distance>
          <avg-speed units="mph">64</avg-speed>
          <coverage miles="12.99" pct="96" />
        </stop>
        <stop id="6" title="I-285 (northside)" sys-pos="10261.40">
          <distance units="miles">18.35</distance>
          <avg-speed units="mph">63</avg-speed>
          <coverage miles="17.9" pct="98" />
        </stop>
        <stop id="7" title="Indian Trail Rd." sys-pos="10266.39">
          <distance units="miles">23.34</distance>
          <avg-speed units="mph">62</avg-speed>
          <coverage miles="23.35" pct="100" />
        </stop>
        <stop id="8" title="SR-316" sys-pos="10271.00">
          <distance units="miles">27.95</distance>
          <avg-speed units="mph">62</avg-speed>
          <coverage miles="26.97" pct="96" />
        </stop>
      </start>
      <start id="3" title="I-20" sys-pos="10246.57">
        <stop id="4" title="Brookwood Interchange" sys-pos="10250.63">
          <distance units="miles">4.06</distance>
          <avg-speed units="mph">64</avg-speed>
          <coverage miles="3.62" pct="89" />
        </stop>
        <stop id="5" title="Clairmont Rd." sys-pos="10256.55">
          <distance units="miles">9.98</distance>
          <avg-speed units="mph">64</avg-speed>
          <coverage miles="9.59" pct="96" />
        </stop>
        <stop id="6" title="I-285 (northside)" sys-pos="10261.40">
          <distance units="miles">14.83</distance>
          <avg-speed units="mph">63</avg-speed>
          <coverage miles="14.5" pct="98" />
        </stop>
        <stop id="7" title="Indian Trail Rd." sys-pos="10266.39">
          <distance units="miles">19.82</distance>
          <avg-speed units="mph">62</avg-speed>
          <coverage miles="19.95" pct="101" />
        </stop>
        <stop id="8" title="SR-316" sys-pos="10271.00">
          <distance units="miles">24.43</distance>
          <avg-speed units="mph">62</avg-speed>
          <coverage miles="23.57" pct="96" />
        </stop>
      </start>
      <start id="4" title="Brookwood Interchange" sys-pos="10250.63">
        <stop id="5" title="Clairmont Rd." sys-pos="10256.55">
          <distance units="miles">5.92</distance>
          <avg-speed units="mph">65</avg-speed>
          <coverage miles="5.97" pct="101" />
          <trip-time units="min">5</trip-time>
        </stop>
        <stop id="6" title="I-285 (northside)" sys-pos="10261.40">
          <distance units="miles">10.77</distance>
          <avg-speed units="mph">63</avg-speed>
          <coverage miles="10.88" pct="101" />
          <trip-time units="min">10</trip-time>
        </stop>
        <stop id="7" title="Indian Trail Rd." sys-pos="10266.39">
          <distance units="miles">15.76</distance>
          <avg-speed units="mph">61</avg-speed>
          <coverage miles="16.33" pct="104" />
          <trip-time units="min">15</trip-time>
        </stop>
        <stop id="8" title="SR-316" sys-pos="10271.00">
          <distance units="miles">20.37</distance>
          <avg-speed units="mph">62</avg-speed>
          <coverage miles="19.95" pct="98" />
        </stop>
      </start>
      <start id="5" title="Clairmont Rd." sys-pos="10256.55">
        <stop id="6" title="I-285 (northside)" sys-pos="10261.40">
          <distance units="miles">4.85</distance>
          <avg-speed units="mph">61</avg-speed>
          <coverage miles="4.91" pct="101" />
          <trip-time units="min">5</trip-time>
        </stop>
        <stop id="7" title="Indian Trail Rd." sys-pos="10266.39">
          <distance units="miles">9.84</distance>
          <avg-speed units="mph">59</avg-speed>
          <coverage miles="10.36" pct="105" />
          <trip-time units="min">10</trip-time>
        </stop>
        <stop id="8" title="SR-316" sys-pos="10271.00">
          <distance units="miles">14.45</distance>
          <avg-speed units="mph">60</avg-speed>
          <coverage miles="13.98" pct="97" />
        </stop>
      </start>
      <start id="6" title="I-285 (northside)" sys-pos="10261.40">
        <stop id="7" title="Indian Trail Rd." sys-pos="10266.39">
          <distance units="miles">4.99</distance>
          <avg-speed units="mph">58</avg-speed>
          <coverage miles="5.45" pct="109" />
          <trip-time units="min">5</trip-time>
        </stop>
        <stop id="8" title="SR-316" sys-pos="10271.00">
          <distance units="miles">9.60</distance>
          <avg-speed units="mph">60</avg-speed>
          <coverage miles="9.07" pct="94" />
        </stop>
      </start>
      <start id="7" title="Indian Trail Rd." sys-pos="10266.39">
        <stop id="8" title="SR-316" sys-pos="10271.00">
          <distance units="miles">4.61</distance>
          <avg-speed units="mph">63</avg-speed>
          <coverage miles="3.62" pct="79" />
        </stop>
      </start>
      <start id="8" title="SR-316" sys-pos="10271.00"></start>
    </direction>
  </route>
  <route id="75" name="I-75">
    <direction id="South" name="South">
      <start id="11" title="Wade Green Rd." sys-pos="10273.11">
        <stop id="10" title="Hwy. 5" sys-pos="10266.97">
          <distance units="miles">6.14</distance>
          <avg-speed units="mph">68</avg-speed>
          <coverage miles="4.17" pct="68" />
        </stop>
        <stop id="9" title="I-285 (northside)" sys-pos="10258.96">
          <distance units="miles">14.15</distance>
          <avg-speed units="mph">68</avg-speed>
          <coverage miles="12.23" pct="86" />
        </stop>
        <stop id="8" title="W. Paces Ferry Rd." sys-pos="10255.42">
          <distance units="miles">17.69</distance>
          <avg-speed units="mph">68</avg-speed>
          <coverage miles="15.81" pct="89" />
        </stop>
        <stop id="7" title="Brookwood Interchange" sys-pos="10250.42">
          <distance units="miles">22.69</distance>
          <avg-speed units="mph">68</avg-speed>
          <coverage miles="20.34" pct="90" />
        </stop>
        <stop id="6" title="I-20" sys-pos="10246.57">
          <distance units="miles">26.54</distance>
          <avg-speed units="mph">68</avg-speed>
          <coverage miles="24.14" pct="91" />
        </stop>
        <stop id="5" title="SR 166 / Langford Pky." sys-pos="10242.38">
          <distance units="miles">30.73</distance>
          <avg-speed units="mph">68</avg-speed>
          <coverage miles="28.53" pct="93" />
        </stop>
        <stop id="4" title="I-285 (southside)" sys-pos="10238.49">
          <distance units="miles">34.62</distance>
          <avg-speed units="mph">67</avg-speed>
          <coverage miles="32.29" pct="93" />
        </stop>
        <stop id="3" title="US 41 / Tara Blvd." sys-pos="10234.86">
          <distance units="miles">38.25</distance>
          <avg-speed units="mph">67</avg-speed>
          <coverage miles="35.82" pct="94" />
        </stop>
        <stop id="2" title="SR 54 / Jonesboro Rd." sys-pos="10232.65">
          <distance units="miles">40.46</distance>
          <avg-speed units="mph">66</avg-speed>
          <coverage miles="37.34" pct="92" />
        </stop>
        <stop id="1" title="Hudson Bridge / Eagles Landing" sys-pos="10224.55">
          <distance units="miles">48.56</distance>
          <avg-speed units="mph">67</avg-speed>
          <coverage miles="44.86" pct="92" />
        </stop>
      </start>
      <start id="10" title="Hwy. 5" sys-pos="10266.97">
        <stop id="9" title="I-285 (northside)" sys-pos="10258.96">
          <distance units="miles">8.01</distance>
          <avg-speed units="mph">68</avg-speed>
          <coverage miles="8.06" pct="101" />
          <trip-time units="min">7</trip-time>
        </stop>
        <stop id="8" title="W. Paces Ferry Rd." sys-pos="10255.42">
          <distance units="miles">11.55</distance>
          <avg-speed units="mph">67</avg-speed>
          <coverage miles="11.64" pct="101" />
          <trip-time units="min">10</trip-time>
        </stop>
        <stop id="7" title="Brookwood Interchange" sys-pos="10250.42">
          <distance units="miles">16.55</distance>
          <avg-speed units="mph">69</avg-speed>
          <coverage miles="16.17" pct="98" />
          <trip-time units="min">14</trip-time>
        </stop>
        <stop id="6" title="I-20" sys-pos="10246.57">
          <distance units="miles">20.40</distance>
          <avg-speed units="mph">68</avg-speed>
          <coverage miles="19.97" pct="98" />
          <trip-time units="min">18</trip-time>
        </stop>
        <stop id="5" title="SR 166 / Langford Pky." sys-pos="10242.38">
          <distance units="miles">24.59</distance>
          <avg-speed units="mph">68</avg-speed>
          <coverage miles="24.36" pct="99" />
          <trip-time units="min">22</trip-time>
        </stop>
        <stop id="4" title="I-285 (southside)" sys-pos="10238.49">
          <distance units="miles">28.48</distance>
          <avg-speed units="mph">67</avg-speed>
          <coverage miles="28.12" pct="99" />
          <trip-time units="min">26</trip-time>
        </stop>
        <stop id="3" title="US 41 / Tara Blvd." sys-pos="10234.86">
          <distance units="miles">32.11</distance>
          <avg-speed units="mph">66</avg-speed>
          <coverage miles="31.65" pct="99" />
          <trip-time units="min">30</trip-time>
        </stop>
        <stop id="2" title="SR 54 / Jonesboro Rd." sys-pos="10232.65">
          <distance units="miles">34.32</distance>
          <avg-speed units="mph">66</avg-speed>
          <coverage miles="33.17" pct="97" />
        </stop>
        <stop id="1" title="Hudson Bridge / Eagles Landing" sys-pos="10224.55">
          <distance units="miles">42.42</distance>
          <avg-speed units="mph">67</avg-speed>
          <coverage miles="40.69" pct="96" />
        </stop>
      </start>
      <start id="9" title="I-285 (northside)" sys-pos="10258.96">
        <stop id="8" title="W. Paces Ferry Rd." sys-pos="10255.42">
          <distance units="miles">3.54</distance>
          <avg-speed units="mph">65</avg-speed>
          <coverage miles="3.58" pct="101" />
          <trip-time units="min">3</trip-time>
        </stop>
        <stop id="7" title="Brookwood Interchange" sys-pos="10250.42">
          <distance units="miles">8.54</distance>
          <avg-speed units="mph">69</avg-speed>
          <coverage miles="8.11" pct="95" />
          <trip-time units="min">7</trip-time>
        </stop>
        <stop id="6" title="I-20" sys-pos="10246.57">
          <distance units="miles">12.39</distance>
          <avg-speed units="mph">68</avg-speed>
          <coverage miles="11.91" pct="96" />
          <trip-time units="min">11</trip-time>
        </stop>
        <stop id="5" title="SR 166 / Langford Pky." sys-pos="10242.38">
          <distance units="miles">16.58</distance>
          <avg-speed units="mph">68</avg-speed>
          <coverage miles="16.3" pct="98" />
          <trip-time units="min">15</trip-time>
        </stop>
        <stop id="4" title="I-285 (southside)" sys-pos="10238.49">
          <distance units="miles">20.47</distance>
          <avg-speed units="mph">67</avg-speed>
          <coverage miles="20.06" pct="98" />
          <trip-time units="min">19</trip-time>
        </stop>
        <stop id="3" title="US 41 / Tara Blvd." sys-pos="10234.86">
          <distance units="miles">24.10</distance>
          <avg-speed units="mph">66</avg-speed>
          <coverage miles="23.59" pct="98" />
          <trip-time units="min">23</trip-time>
        </stop>
        <stop id="2" title="SR 54 / Jonesboro Rd." sys-pos="10232.65">
          <distance units="miles">26.31</distance>
          <avg-speed units="mph">66</avg-speed>
          <coverage miles="25.11" pct="95" />
        </stop>
        <stop id="1" title="Hudson Bridge / Eagles Landing" sys-pos="10224.55">
          <distance units="miles">34.41</distance>
          <avg-speed units="mph">66</avg-speed>
          <coverage miles="32.63" pct="95" />
        </stop>
      </start>
      <start id="8" title="W. Paces Ferry Rd." sys-pos="10255.42">
        <stop id="7" title="Brookwood Interchange" sys-pos="10250.42">
          <distance units="miles">5.00</distance>
          <avg-speed units="mph">72</avg-speed>
          <coverage miles="4.53" pct="91" />
          <trip-time units="min">4</trip-time>
        </stop>
        <stop id="6" title="I-20" sys-pos="10246.57">
          <distance units="miles">8.85</distance>
          <avg-speed units="mph">69</avg-speed>
          <coverage miles="8.33" pct="94" />
          <trip-time units="min">8</trip-time>
        </stop>
        <stop id="5" title="SR 166 / Langford Pky." sys-pos="10242.38">
          <distance units="miles">13.04</distance>
          <avg-speed units="mph">69</avg-speed>
          <coverage miles="12.72" pct="98" />
          <trip-time units="min">12</trip-time>
        </stop>
        <stop id="4" title="I-285 (southside)" sys-pos="10238.49">
          <distance units="miles">16.93</distance>
          <avg-speed units="mph">67</avg-speed>
          <coverage miles="16.48" pct="97" />
          <trip-time units="min">16</trip-time>
        </stop>
        <stop id="3" title="US 41 / Tara Blvd." sys-pos="10234.86">
          <distance units="miles">20.56</distance>
          <avg-speed units="mph">66</avg-speed>
          <coverage miles="20.01" pct="97" />
          <trip-time units="min">20</trip-time>
        </stop>
        <stop id="2" title="SR 54 / Jonesboro Rd." sys-pos="10232.65">
          <distance units="miles">22.77</distance>
          <avg-speed units="mph">66</avg-speed>
          <coverage miles="21.53" pct="95" />
        </stop>
        <stop id="1" title="Hudson Bridge / Eagles Landing" sys-pos="10224.55">
          <distance units="miles">30.87</distance>
          <avg-speed units="mph">66</avg-speed>
          <coverage miles="29.05" pct="94" />
        </stop>
      </start>
      <start id="7" title="Brookwood Interchange" sys-pos="10250.42">
        <stop id="6" title="I-20" sys-pos="10246.57">
          <distance units="miles">3.85</distance>
          <avg-speed units="mph">65</avg-speed>
          <coverage miles="3.8" pct="99" />
          <trip-time units="min">4</trip-time>
        </stop>
        <stop id="5" title="SR 166 / Langford Pky." sys-pos="10242.38">
          <distance units="miles">8.04</distance>
          <avg-speed units="mph">68</avg-speed>
          <coverage miles="8.19" pct="102" />
          <trip-time units="min">8</trip-time>
        </stop>
        <stop id="4" title="I-285 (southside)" sys-pos="10238.49">
          <distance units="miles">11.93</distance>
          <avg-speed units="mph">65</avg-speed>
          <coverage miles="11.95" pct="100" />
          <trip-time units="min">12</trip-time>
        </stop>
        <stop id="3" title="US 41 / Tara Blvd." sys-pos="10234.86">
          <distance units="miles">15.56</distance>
          <avg-speed units="mph">64</avg-speed>
          <coverage miles="15.48" pct="99" />
          <trip-time units="min">16</trip-time>
        </stop>
        <stop id="2" title="SR 54 / Jonesboro Rd." sys-pos="10232.65">
          <distance units="miles">17.77</distance>
          <avg-speed units="mph">64</avg-speed>
          <coverage miles="17" pct="96" />
        </stop>
        <stop id="1" title="Hudson Bridge / Eagles Landing" sys-pos="10224.55">
          <distance units="miles">25.87</distance>
          <avg-speed units="mph">65</avg-speed>
          <coverage miles="24.52" pct="95" />
        </stop>
      </start>
      <start id="6" title="I-20" sys-pos="10246.57">
        <stop id="5" title="SR 166 / Langford Pky." sys-pos="10242.38">
          <distance units="miles">4.19</distance>
          <avg-speed units="mph">70</avg-speed>
          <coverage miles="4.39" pct="105" />
          <trip-time units="min">4</trip-time>
        </stop>
        <stop id="4" title="I-285 (southside)" sys-pos="10238.49">
          <distance units="miles">8.08</distance>
          <avg-speed units="mph">65</avg-speed>
          <coverage miles="8.15" pct="101" />
          <trip-time units="min">8</trip-time>
        </stop>
        <stop id="3" title="US 41 / Tara Blvd." sys-pos="10234.86">
          <distance units="miles">11.71</distance>
          <avg-speed units="mph">64</avg-speed>
          <coverage miles="11.68" pct="100" />
          <trip-time units="min">12</trip-time>
        </stop>
        <stop id="2" title="SR 54 / Jonesboro Rd." sys-pos="10232.65">
          <distance units="miles">13.92</distance>
          <avg-speed units="mph">64</avg-speed>
          <coverage miles="13.2" pct="95" />
        </stop>
        <stop id="1" title="Hudson Bridge / Eagles Landing" sys-pos="10224.55">
          <distance units="miles">22.02</distance>
          <avg-speed units="mph">65</avg-speed>
          <coverage miles="20.72" pct="94" />
        </stop>
      </start>
      <start id="5" title="SR 166 / Langford Pky." sys-pos="10242.38">
        <stop id="4" title="I-285 (southside)" sys-pos="10238.49">
          <distance units="miles">3.89</distance>
          <avg-speed units="mph">59</avg-speed>
          <coverage miles="3.76" pct="97" />
          <trip-time units="min">4</trip-time>
        </stop>
        <stop id="3" title="US 41 / Tara Blvd." sys-pos="10234.86">
          <distance units="miles">7.52</distance>
          <avg-speed units="mph">60</avg-speed>
          <coverage miles="7.29" pct="97" />
          <trip-time units="min">8</trip-time>
        </stop>
        <stop id="2" title="SR 54 / Jonesboro Rd." sys-pos="10232.65">
          <distance units="miles">9.73</distance>
          <avg-speed units="mph">60</avg-speed>
          <coverage miles="8.81" pct="91" />
        </stop>
        <stop id="1" title="Hudson Bridge / Eagles Landing" sys-pos="10224.55">
          <distance units="miles">17.83</distance>
          <avg-speed units="mph">64</avg-speed>
          <coverage miles="16.33" pct="92" />
        </stop>
      </start>
      <start id="4" title="I-285 (southside)" sys-pos="10238.49">
        <stop id="3" title="US 41 / Tara Blvd." sys-pos="10234.86">
          <distance units="miles">3.63</distance>
          <avg-speed units="mph">60</avg-speed>
          <coverage miles="3.53" pct="97" />
          <trip-time units="min">4</trip-time>
        </stop>
        <stop id="2" title="SR 54 / Jonesboro Rd." sys-pos="10232.65">
          <distance units="miles">5.84</distance>
          <avg-speed units="mph">61</avg-speed>
          <coverage miles="5.05" pct="86" />
        </stop>
        <stop id="1" title="Hudson Bridge / Eagles Landing" sys-pos="10224.55">
          <distance units="miles">13.94</distance>
          <avg-speed units="mph">65</avg-speed>
          <coverage miles="12.57" pct="90" />
        </stop>
      </start>
      <start id="3" title="US 41 / Tara Blvd." sys-pos="10234.86">
        <stop id="2" title="SR 54 / Jonesboro Rd." sys-pos="10232.65">
          <distance units="miles">2.21</distance>
          <avg-speed units="mph">64</avg-speed>
          <coverage miles="1.52" pct="69" />
        </stop>
        <stop id="1" title="Hudson Bridge / Eagles Landing" sys-pos="10224.55">
          <distance units="miles">10.31</distance>
          <avg-speed units="mph">67</avg-speed>
          <coverage miles="9.04" pct="88" />
        </stop>
      </start>
      <start id="2" title="SR 54 / Jonesboro Rd." sys-pos="10232.65">
        <stop id="1" title="Hudson Bridge / Eagles Landing" sys-pos="10224.55">
          <distance units="miles">8.10</distance>
          <avg-speed units="mph">68</avg-speed>
          <coverage miles="7.52" pct="93" />
          <trip-time units="min">7</trip-time>
        </stop>
      </start>
      <start id="1" title="Hudson Bridge / Eagles Landing" sys-pos="10224.55"></start>
    </direction>
    <direction id="North" name="North">
      <start id="1" title="Hudson Bridge / Eagles Landing" sys-pos="10224.55">
        <stop id="2" title="SR 54 / Jonesboro Rd." sys-pos="10232.65">
          <distance units="miles">8.10</distance>
          <avg-speed units="mph">70</avg-speed>
          <coverage miles="7.51" pct="93" />
          <trip-time units="min">7</trip-time>
        </stop>
        <stop id="3" title="US 41 / Tara Blvd." sys-pos="10234.86">
          <distance units="miles">10.31</distance>
          <avg-speed units="mph">70</avg-speed>
          <coverage miles="9.03" pct="88" />
        </stop>
        <stop id="4" title="I-285 (southside)" sys-pos="10238.49">
          <distance units="miles">13.94</distance>
          <avg-speed units="mph">67</avg-speed>
          <coverage miles="12.66" pct="91" />
        </stop>
        <stop id="5" title="SR 166 / Langford Pky." sys-pos="10242.38">
          <distance units="miles">17.83</distance>
          <avg-speed units="mph">66</avg-speed>
          <coverage miles="16.6" pct="93" />
        </stop>
        <stop id="6" title="I-20" sys-pos="10246.57">
          <distance units="miles">22.02</distance>
          <avg-speed units="mph">66</avg-speed>
          <coverage miles="20.47" pct="93" />
        </stop>
        <stop id="7" title="Brookwood Interchange" sys-pos="10250.42">
          <distance units="miles">25.87</distance>
          <avg-speed units="mph">65</avg-speed>
          <coverage miles="24.31" pct="94" />
        </stop>
        <stop id="8" title="W. Paces Ferry Rd." sys-pos="10255.42">
          <distance units="miles">30.87</distance>
          <avg-speed units="mph">64</avg-speed>
          <coverage miles="29.12" pct="94" />
        </stop>
        <stop id="9" title="I-285 (northside)" sys-pos="10258.96">
          <distance units="miles">34.41</distance>
          <avg-speed units="mph">64</avg-speed>
          <coverage miles="32.76" pct="95" />
        </stop>
        <stop id="10" title="Hwy. 5" sys-pos="10266.97">
          <distance units="miles">42.42</distance>
          <avg-speed units="mph">66</avg-speed>
          <coverage miles="40.74" pct="96" />
        </stop>
        <stop id="11" title="Wade Green Rd." sys-pos="10273.11">
          <distance units="miles">48.56</distance>
          <avg-speed units="mph">66</avg-speed>
          <coverage miles="46.49" pct="96" />
        </stop>
      </start>
      <start id="2" title="SR 54 / Jonesboro Rd." sys-pos="10232.65">
        <stop id="3" title="US 41 / Tara Blvd." sys-pos="10234.86">
          <distance units="miles">2.21</distance>
          <avg-speed units="mph">69</avg-speed>
          <coverage miles="1.52" pct="69" />
        </stop>
        <stop id="4" title="I-285 (southside)" sys-pos="10238.49">
          <distance units="miles">5.84</distance>
          <avg-speed units="mph">62</avg-speed>
          <coverage miles="5.15" pct="88" />
        </stop>
        <stop id="5" title="SR 166 / Langford Pky." sys-pos="10242.38">
          <distance units="miles">9.73</distance>
          <avg-speed units="mph">63</avg-speed>
          <coverage miles="9.09" pct="93" />
        </stop>
        <stop id="6" title="I-20" sys-pos="10246.57">
          <distance units="miles">13.92</distance>
          <avg-speed units="mph">63</avg-speed>
          <coverage miles="12.96" pct="93" />
        </stop>
        <stop id="7" title="Brookwood Interchange" sys-pos="10250.42">
          <distance units="miles">17.77</distance>
          <avg-speed units="mph">63</avg-speed>
          <coverage miles="16.8" pct="95" />
        </stop>
        <stop id="8" title="W. Paces Ferry Rd." sys-pos="10255.42">
          <distance units="miles">22.77</distance>
          <avg-speed units="mph">62</avg-speed>
          <coverage miles="21.61" pct="95" />
        </stop>
        <stop id="9" title="I-285 (northside)" sys-pos="10258.96">
          <distance units="miles">26.31</distance>
          <avg-speed units="mph">63</avg-speed>
          <coverage miles="25.25" pct="96" />
        </stop>
        <stop id="10" title="Hwy. 5" sys-pos="10266.97">
          <distance units="miles">34.32</distance>
          <avg-speed units="mph">65</avg-speed>
          <coverage miles="33.23" pct="97" />
        </stop>
        <stop id="11" title="Wade Green Rd." sys-pos="10273.11">
          <distance units="miles">40.46</distance>
          <avg-speed units="mph">65</avg-speed>
          <coverage miles="38.98" pct="96" />
        </stop>
      </start>
      <start id="3" title="US 41 / Tara Blvd." sys-pos="10234.86">
        <stop id="4" title="I-285 (southside)" sys-pos="10238.49">
          <distance units="miles">3.63</distance>
          <avg-speed units="mph">59</avg-speed>
          <coverage miles="3.63" pct="100" />
          <trip-time units="min">4</trip-time>
        </stop>
        <stop id="5" title="SR 166 / Langford Pky." sys-pos="10242.38">
          <distance units="miles">7.52</distance>
          <avg-speed units="mph">62</avg-speed>
          <coverage miles="7.57" pct="101" />
          <trip-time units="min">8</trip-time>
        </stop>
        <stop id="6" title="I-20" sys-pos="10246.57">
          <distance units="miles">11.71</distance>
          <avg-speed units="mph">63</avg-speed>
          <coverage miles="11.44" pct="98" />
          <trip-time units="min">12</trip-time>
        </stop>
        <stop id="7" title="Brookwood Interchange" sys-pos="10250.42">
          <distance units="miles">15.56</distance>
          <avg-speed units="mph">63</avg-speed>
          <coverage miles="15.28" pct="98" />
          <trip-time units="min">16</trip-time>
        </stop>
        <stop id="8" title="W. Paces Ferry Rd." sys-pos="10255.42">
          <distance units="miles">20.56</distance>
          <avg-speed units="mph">61</avg-speed>
          <coverage miles="20.09" pct="98" />
          <trip-time units="min">21</trip-time>
        </stop>
        <stop id="9" title="I-285 (northside)" sys-pos="10258.96">
          <distance units="miles">24.10</distance>
          <avg-speed units="mph">62</avg-speed>
          <coverage miles="23.73" pct="98" />
          <trip-time units="min">24</trip-time>
        </stop>
        <stop id="10" title="Hwy. 5" sys-pos="10266.97">
          <distance units="miles">32.11</distance>
          <avg-speed units="mph">65</avg-speed>
          <coverage miles="31.71" pct="99" />
          <trip-time units="min">31</trip-time>
        </stop>
        <stop id="11" title="Wade Green Rd." sys-pos="10273.11">
          <distance units="miles">38.25</distance>
          <avg-speed units="mph">65</avg-speed>
          <coverage miles="37.46" pct="98" />
          <trip-time units="min">37</trip-time>
        </stop>
      </start>
      <start id="4" title="I-285 (southside)" sys-pos="10238.49">
        <stop id="5" title="SR 166 / Langford Pky." sys-pos="10242.38">
          <distance units="miles">3.89</distance>
          <avg-speed units="mph">63</avg-speed>
          <coverage miles="3.94" pct="101" />
          <trip-time units="min">4</trip-time>
        </stop>
        <stop id="6" title="I-20" sys-pos="10246.57">
          <distance units="miles">8.08</distance>
          <avg-speed units="mph">64</avg-speed>
          <coverage miles="7.81" pct="97" />
          <trip-time units="min">8</trip-time>
        </stop>
        <stop id="7" title="Brookwood Interchange" sys-pos="10250.42">
          <distance units="miles">11.93</distance>
          <avg-speed units="mph">64</avg-speed>
          <coverage miles="11.65" pct="98" />
          <trip-time units="min">12</trip-time>
        </stop>
        <stop id="8" title="W. Paces Ferry Rd." sys-pos="10255.42">
          <distance units="miles">16.93</distance>
          <avg-speed units="mph">62</avg-speed>
          <coverage miles="16.46" pct="97" />
          <trip-time units="min">17</trip-time>
        </stop>
        <stop id="9" title="I-285 (northside)" sys-pos="10258.96">
          <distance units="miles">20.47</distance>
          <avg-speed units="mph">63</avg-speed>
          <coverage miles="20.1" pct="98" />
          <trip-time units="min">20</trip-time>
        </stop>
        <stop id="10" title="Hwy. 5" sys-pos="10266.97">
          <distance units="miles">28.48</distance>
          <avg-speed units="mph">65</avg-speed>
          <coverage miles="28.08" pct="99" />
          <trip-time units="min">27</trip-time>
        </stop>
        <stop id="11" title="Wade Green Rd." sys-pos="10273.11">
          <distance units="miles">34.62</distance>
          <avg-speed units="mph">65</avg-speed>
          <coverage miles="33.83" pct="98" />
          <trip-time units="min">33</trip-time>
        </stop>
      </start>
      <start id="5" title="SR 166 / Langford Pky." sys-pos="10242.38">
        <stop id="6" title="I-20" sys-pos="10246.57">
          <distance units="miles">4.19</distance>
          <avg-speed units="mph">64</avg-speed>
          <coverage miles="4.16" pct="99" />
          <trip-time units="min">4</trip-time>
        </stop>
        <stop id="7" title="Brookwood Interchange" sys-pos="10250.42">
          <distance units="miles">8.04</distance>
          <avg-speed units="mph">64</avg-speed>
          <coverage miles="8" pct="100" />
          <trip-time units="min">8</trip-time>
        </stop>
        <stop id="8" title="W. Paces Ferry Rd." sys-pos="10255.42">
          <distance units="miles">13.04</distance>
          <avg-speed units="mph">61</avg-speed>
          <coverage miles="12.81" pct="98" />
          <trip-time units="min">13</trip-time>
        </stop>
        <stop id="9" title="I-285 (northside)" sys-pos="10258.96">
          <distance units="miles">16.58</distance>
          <avg-speed units="mph">62</avg-speed>
          <coverage miles="16.45" pct="99" />
          <trip-time units="min">16</trip-time>
        </stop>
        <stop id="10" title="Hwy. 5" sys-pos="10266.97">
          <distance units="miles">24.59</distance>
          <avg-speed units="mph">65</avg-speed>
          <coverage miles="24.43" pct="99" />
          <trip-time units="min">23</trip-time>
        </stop>
        <stop id="11" title="Wade Green Rd." sys-pos="10273.11">
          <distance units="miles">30.73</distance>
          <avg-speed units="mph">65</avg-speed>
          <coverage miles="30.18" pct="98" />
          <trip-time units="min">29</trip-time>
        </stop>
      </start>
      <start id="6" title="I-20" sys-pos="10246.57">
        <stop id="7" title="Brookwood Interchange" sys-pos="10250.42">
          <distance units="miles">3.85</distance>
          <avg-speed units="mph">63</avg-speed>
          <coverage miles="3.84" pct="100" />
          <trip-time units="min">4</trip-time>
        </stop>
        <stop id="8" title="W. Paces Ferry Rd." sys-pos="10255.42">
          <distance units="miles">8.85</distance>
          <avg-speed units="mph">59</avg-speed>
          <coverage miles="8.65" pct="98" />
          <trip-time units="min">9</trip-time>
        </stop>
        <stop id="9" title="I-285 (northside)" sys-pos="10258.96">
          <distance units="miles">12.39</distance>
          <avg-speed units="mph">62</avg-speed>
          <coverage miles="12.29" pct="99" />
          <trip-time units="min">12</trip-time>
        </stop>
        <stop id="10" title="Hwy. 5" sys-pos="10266.97">
          <distance units="miles">20.40</distance>
          <avg-speed units="mph">66</avg-speed>
          <coverage miles="20.27" pct="99" />
          <trip-time units="min">19</trip-time>
        </stop>
        <stop id="11" title="Wade Green Rd." sys-pos="10273.11">
          <distance units="miles">26.54</distance>
          <avg-speed units="mph">66</avg-speed>
          <coverage miles="26.02" pct="98" />
          <trip-time units="min">25</trip-time>
        </stop>
      </start>
      <start id="7" title="Brookwood Interchange" sys-pos="10250.42">
        <stop id="8" title="W. Paces Ferry Rd." sys-pos="10255.42">
          <distance units="miles">5.00</distance>
          <avg-speed units="mph">56</avg-speed>
          <coverage miles="4.81" pct="96" />
          <trip-time units="min">5</trip-time>
        </stop>
        <stop id="9" title="I-285 (northside)" sys-pos="10258.96">
          <distance units="miles">8.54</distance>
          <avg-speed units="mph">61</avg-speed>
          <coverage miles="8.45" pct="99" />
          <trip-time units="min">8</trip-time>
        </stop>
        <stop id="10" title="Hwy. 5" sys-pos="10266.97">
          <distance units="miles">16.55</distance>
          <avg-speed units="mph">66</avg-speed>
          <coverage miles="16.43" pct="99" />
          <trip-time units="min">15</trip-time>
        </stop>
        <stop id="11" title="Wade Green Rd." sys-pos="10273.11">
          <distance units="miles">22.69</distance>
          <avg-speed units="mph">66</avg-speed>
          <coverage miles="22.18" pct="98" />
          <trip-time units="min">21</trip-time>
        </stop>
      </start>
      <start id="8" title="W. Paces Ferry Rd." sys-pos="10255.42">
        <stop id="9" title="I-285 (northside)" sys-pos="10258.96">
          <distance units="miles">3.54</distance>
          <avg-speed units="mph">68</avg-speed>
          <coverage miles="3.64" pct="103" />
          <trip-time units="min">3</trip-time>
        </stop>
        <stop id="10" title="Hwy. 5" sys-pos="10266.97">
          <distance units="miles">11.55</distance>
          <avg-speed units="mph">70</avg-speed>
          <coverage miles="11.62" pct="101" />
          <trip-time units="min">10</trip-time>
        </stop>
        <stop id="11" title="Wade Green Rd." sys-pos="10273.11">
          <distance units="miles">17.69</distance>
          <avg-speed units="mph">69</avg-speed>
          <coverage miles="17.37" pct="98" />
          <trip-time units="min">16</trip-time>
        </stop>
      </start>
      <start id="9" title="I-285 (northside)" sys-pos="10258.96">
        <stop id="10" title="Hwy. 5" sys-pos="10266.97">
          <distance units="miles">8.01</distance>
          <avg-speed units="mph">72</avg-speed>
          <coverage miles="7.98" pct="100" />
          <trip-time units="min">7</trip-time>
        </stop>
        <stop id="11" title="Wade Green Rd." sys-pos="10273.11">
          <distance units="miles">14.15</distance>
          <avg-speed units="mph">69</avg-speed>
          <coverage miles="13.73" pct="97" />
          <trip-time units="min">13</trip-time>
        </stop>
      </start>
      <start id="10" title="Hwy. 5" sys-pos="10266.97">
        <stop id="11" title="Wade Green Rd." sys-pos="10273.11">
          <distance units="miles">6.14</distance>
          <avg-speed units="mph">65</avg-speed>
          <coverage miles="5.75" pct="94" />
          <trip-time units="min">6</trip-time>
        </stop>
      </start>
      <start id="11" title="Wade Green Rd." sys-pos="10273.11"></start>
    </direction>
  </route>
  <route id="141" name="SR 141">
    <direction id="South" name="South">
      <start id="2" title="Jimmy Carter Blvd" sys-pos="10018.58">
        <stop id="1" title="I-285" sys-pos="10015.20">
          <distance units="miles">3.38</distance>
          <avg-speed units="mph">55</avg-speed>
          <coverage miles="3.92" pct="116" />
          <trip-time units="min">4</trip-time>
        </stop>
      </start>
      <start id="1" title="I-285" sys-pos="10015.20"></start>
    </direction>
    <direction id="North" name="North">
      <start id="1" title="I-285" sys-pos="10015.20">
        <stop id="2" title="Jimmy Carter Blvd" sys-pos="10018.58">
          <distance units="miles">3.38</distance>
          <avg-speed units="mph">61</avg-speed>
          <coverage miles="3.92" pct="116" />
          <trip-time units="min">3</trip-time>
        </stop>
      </start>
      <start id="2" title="Jimmy Carter Blvd" sys-pos="10018.58"></start>
    </direction>
  </route>
  <route id="400" name="GA 400">
    <direction id="South" name="South">
      <start id="6" title="SR-120 / Old Milton Pky." sys-pos="10272.68">
        <stop id="5" title="Mansell Rd." sys-pos="10269.48">
          <distance units="miles">3.20</distance>
          <avg-speed units="mph"></avg-speed>
          <coverage miles="0" pct="0" />
        </stop>
        <stop id="4" title="Northridge Rd." sys-pos="10265.12">
          <distance units="miles">7.56</distance>
          <avg-speed units="mph">68</avg-speed>
          <coverage miles="3.7" pct="49" />
        </stop>
        <stop id="3" title="I-285" sys-pos="10260.00">
          <distance units="miles">12.68</distance>
          <avg-speed units="mph">64</avg-speed>
          <coverage miles="8.75" pct="69" />
        </stop>
        <stop id="2" title="Lenox Rd." sys-pos="10256.87">
          <distance units="miles">15.81</distance>
          <avg-speed units="mph">64</avg-speed>
          <coverage miles="9.18" pct="58" />
        </stop>
        <stop id="1" title="I-85" sys-pos="10254.07">
          <distance units="miles">18.61</distance>
          <avg-speed units="mph">64</avg-speed>
          <coverage miles="9.18" pct="49" />
        </stop>
      </start>
      <start id="5" title="Mansell Rd." sys-pos="10269.48">
        <stop id="4" title="Northridge Rd." sys-pos="10265.12">
          <distance units="miles">4.36</distance>
          <avg-speed units="mph">68</avg-speed>
          <coverage miles="3.7" pct="85" />
        </stop>
        <stop id="3" title="I-285" sys-pos="10260.00">
          <distance units="miles">9.48</distance>
          <avg-speed units="mph">64</avg-speed>
          <coverage miles="8.75" pct="92" />
        </stop>
        <stop id="2" title="Lenox Rd." sys-pos="10256.87">
          <distance units="miles">12.61</distance>
          <avg-speed units="mph">64</avg-speed>
          <coverage miles="9.18" pct="73" />
        </stop>
        <stop id="1" title="I-85" sys-pos="10254.07">
          <distance units="miles">15.41</distance>
          <avg-speed units="mph">64</avg-speed>
          <coverage miles="9.18" pct="60" />
        </stop>
      </start>
      <start id="4" title="Northridge Rd." sys-pos="10265.12">
        <stop id="3" title="I-285" sys-pos="10260.00">
          <distance units="miles">5.12</distance>
          <avg-speed units="mph">61</avg-speed>
          <coverage miles="5.05" pct="99" />
          <trip-time units="min">5</trip-time>
        </stop>
        <stop id="2" title="Lenox Rd." sys-pos="10256.87">
          <distance units="miles">8.25</distance>
          <avg-speed units="mph">61</avg-speed>
          <coverage miles="5.48" pct="66" />
        </stop>
        <stop id="1" title="I-85" sys-pos="10254.07">
          <distance units="miles">11.05</distance>
          <avg-speed units="mph">61</avg-speed>
          <coverage miles="5.48" pct="50" />
        </stop>
      </start>
      <start id="3" title="I-285" sys-pos="10260.00">
        <stop id="2" title="Lenox Rd." sys-pos="10256.87">
          <distance units="miles">3.13</distance>
          <avg-speed units="mph">62</avg-speed>
          <coverage miles="0.43" pct="14" />
        </stop>
        <stop id="1" title="I-85" sys-pos="10254.07">
          <distance units="miles">5.93</distance>
          <avg-speed units="mph">62</avg-speed>
          <coverage miles="0.43" pct="7" />
        </stop>
      </start>
      <start id="2" title="Lenox Rd." sys-pos="10256.87">
        <stop id="1" title="I-85" sys-pos="10254.07">
          <distance units="miles">2.80</distance>
          <avg-speed units="mph"></avg-speed>
          <coverage miles="0" pct="0" />
        </stop>
      </start>
      <start id="1" title="I-85" sys-pos="10254.07"></start>
    </direction>
    <direction id="North" name="North">
      <start id="1" title="I-85" sys-pos="10254.07">
        <stop id="2" title="Lenox Rd." sys-pos="10256.87">
          <distance units="miles">2.80</distance>
          <avg-speed units="mph"></avg-speed>
          <coverage miles="0" pct="0" />
        </stop>
        <stop id="3" title="I-285" sys-pos="10260.00">
          <distance units="miles">5.93</distance>
          <avg-speed units="mph"></avg-speed>
          <coverage miles="0" pct="0" />
        </stop>
        <stop id="4" title="Northridge Rd." sys-pos="10265.12">
          <distance units="miles">11.05</distance>
          <avg-speed units="mph">61</avg-speed>
          <coverage miles="4.11" pct="37" />
        </stop>
        <stop id="5" title="Mansell Rd." sys-pos="10269.48">
          <distance units="miles">15.41</distance>
          <avg-speed units="mph">61</avg-speed>
          <coverage miles="4.11" pct="27" />
        </stop>
        <stop id="6" title="SR-120 / Old Milton Pky." sys-pos="10272.68">
          <distance units="miles">18.61</distance>
          <avg-speed units="mph">61</avg-speed>
          <coverage miles="4.11" pct="22" />
        </stop>
      </start>
      <start id="2" title="Lenox Rd." sys-pos="10256.87">
        <stop id="3" title="I-285" sys-pos="10260.00">
          <distance units="miles">3.13</distance>
          <avg-speed units="mph"></avg-speed>
          <coverage miles="0" pct="0" />
        </stop>
        <stop id="4" title="Northridge Rd." sys-pos="10265.12">
          <distance units="miles">8.25</distance>
          <avg-speed units="mph">61</avg-speed>
          <coverage miles="4.11" pct="50" />
        </stop>
        <stop id="5" title="Mansell Rd." sys-pos="10269.48">
          <distance units="miles">12.61</distance>
          <avg-speed units="mph">61</avg-speed>
          <coverage miles="4.11" pct="33" />
        </stop>
        <stop id="6" title="SR-120 / Old Milton Pky." sys-pos="10272.68">
          <distance units="miles">15.81</distance>
          <avg-speed units="mph">61</avg-speed>
          <coverage miles="4.11" pct="26" />
        </stop>
      </start>
      <start id="3" title="I-285" sys-pos="10260.00">
        <stop id="4" title="Northridge Rd." sys-pos="10265.12">
          <distance units="miles">5.12</distance>
          <avg-speed units="mph">61</avg-speed>
          <coverage miles="4.11" pct="80" />
        </stop>
        <stop id="5" title="Mansell Rd." sys-pos="10269.48">
          <distance units="miles">9.48</distance>
          <avg-speed units="mph">61</avg-speed>
          <coverage miles="4.11" pct="43" />
        </stop>
        <stop id="6" title="SR-120 / Old Milton Pky." sys-pos="10272.68">
          <distance units="miles">12.68</distance>
          <avg-speed units="mph">61</avg-speed>
          <coverage miles="4.11" pct="32" />
        </stop>
      </start>
      <start id="4" title="Northridge Rd." sys-pos="10265.12">
        <stop id="5" title="Mansell Rd." sys-pos="10269.48">
          <distance units="miles">4.36</distance>
          <avg-speed units="mph"></avg-speed>
          <coverage miles="0" pct="0" />
        </stop>
        <stop id="6" title="SR-120 / Old Milton Pky." sys-pos="10272.68">
          <distance units="miles">7.56</distance>
          <avg-speed units="mph"></avg-speed>
          <coverage miles="0" pct="0" />
        </stop>
      </start>
      <start id="5" title="Mansell Rd." sys-pos="10269.48">
        <stop id="6" title="SR-120 / Old Milton Pky." sys-pos="10272.68">
          <distance units="miles">3.20</distance>
          <avg-speed units="mph"></avg-speed>
          <coverage miles="0" pct="0" />
        </stop>
      </start>
      <start id="6" title="SR-120 / Old Milton Pky." sys-pos="10272.68"></start>
    </direction>
  </route>
  <route id="475" name="I-475">
    <direction id="South" name="South">
      <start id="4" title="I-75 (northside)" sys-pos="10015.23">
        <stop id="3" title="Zebulon Rd." sys-pos="10009.60">
          <distance units="miles">5.63</distance>
          <avg-speed units="mph">61</avg-speed>
          <coverage miles="12.46" pct="221" />
          <trip-time units="min">6</trip-time>
        </stop>
        <stop id="2" title="Eisenhower Pky." sys-pos="10003.99">
          <distance units="miles">11.24</distance>
          <avg-speed units="mph">64</avg-speed>
          <coverage miles="19.21" pct="171" />
          <trip-time units="min">11</trip-time>
        </stop>
        <stop id="1" title="I-75 (southside)" sys-pos="10000.79">
          <distance units="miles">14.44</distance>
          <avg-speed units="mph">64</avg-speed>
          <coverage miles="19.21" pct="133" />
        </stop>
      </start>
      <start id="3" title="Zebulon Rd." sys-pos="10009.60">
        <stop id="2" title="Eisenhower Pky." sys-pos="10003.99">
          <distance units="miles">5.61</distance>
          <avg-speed units="mph">70</avg-speed>
          <coverage miles="6.75" pct="120" />
          <trip-time units="min">5</trip-time>
        </stop>
        <stop id="1" title="I-75 (southside)" sys-pos="10000.79">
          <distance units="miles">8.81</distance>
          <avg-speed units="mph">70</avg-speed>
          <coverage miles="6.75" pct="77" />
        </stop>
      </start>
      <start id="2" title="Eisenhower Pky." sys-pos="10003.99">
        <stop id="1" title="I-75 (southside)" sys-pos="10000.79">
          <distance units="miles">3.20</distance>
          <avg-speed units="mph"></avg-speed>
          <coverage miles="0" pct="0" />
        </stop>
      </start>
      <start id="1" title="I-75 (southside)" sys-pos="10000.79"></start>
    </direction>
    <direction id="North" name="North">
      <start id="1" title="I-75 (southside)" sys-pos="10000.79">
        <stop id="2" title="Eisenhower Pky." sys-pos="10003.99">
          <distance units="miles">3.20</distance>
          <avg-speed units="mph">69</avg-speed>
          <coverage miles="3.36" pct="105" />
          <trip-time units="min">3</trip-time>
        </stop>
        <stop id="3" title="Zebulon Rd." sys-pos="10009.60">
          <distance units="miles">8.81</distance>
          <avg-speed units="mph">66</avg-speed>
          <coverage miles="9.13" pct="104" />
          <trip-time units="min">8</trip-time>
        </stop>
        <stop id="4" title="I-75 (northside)" sys-pos="10015.23">
          <distance units="miles">14.44</distance>
          <avg-speed units="mph">67</avg-speed>
          <coverage miles="14.27" pct="99" />
          <trip-time units="min">13</trip-time>
        </stop>
      </start>
      <start id="2" title="Eisenhower Pky." sys-pos="10003.99">
        <stop id="3" title="Zebulon Rd." sys-pos="10009.60">
          <distance units="miles">5.61</distance>
          <avg-speed units="mph">64</avg-speed>
          <coverage miles="5.77" pct="103" />
          <trip-time units="min">5</trip-time>
        </stop>
        <stop id="4" title="I-75 (northside)" sys-pos="10015.23">
          <distance units="miles">11.24</distance>
          <avg-speed units="mph">66</avg-speed>
          <coverage miles="10.91" pct="97" />
          <trip-time units="min">10</trip-time>
        </stop>
      </start>
      <start id="3" title="Zebulon Rd." sys-pos="10009.60">
        <stop id="4" title="I-75 (northside)" sys-pos="10015.23">
          <distance units="miles">5.63</distance>
          <avg-speed units="mph">69</avg-speed>
          <coverage miles="5.14" pct="91" />
          <trip-time units="min">5</trip-time>
        </stop>
      </start>
      <start id="4" title="I-75 (northside)" sys-pos="10015.23"></start>
    </direction>
  </route>
  <route id="285" name="I-285">
    <direction id="Clockwise" name="Clockwise">
      <start id="1" title="I-75 (northside)" sys-pos="30020.35">
        <stop id="2" title="Riverside Dr." sys-pos="30024.10">
          <distance units="miles">3.75</distance>
          <avg-speed units="mph">70</avg-speed>
          <coverage miles="3.69" pct="98" />
          <trip-time units="min">3</trip-time>
        </stop>
        <stop id="3" title="Ga-400" sys-pos="30027.00">
          <distance units="miles">6.65</distance>
          <avg-speed units="mph">68</avg-speed>
          <coverage miles="6.53" pct="98" />
          <trip-time units="min">6</trip-time>
        </stop>
        <stop id="4" title="Peachtree industrial Blvd." sys-pos="30031.38">
          <distance units="miles">11.03</distance>
          <avg-speed units="mph">64</avg-speed>
          <coverage miles="11.14" pct="101" />
          <trip-time units="min">10</trip-time>
        </stop>
        <stop id="5" title="I-85 (northside)" sys-pos="30033.60">
          <distance units="miles">13.25</distance>
          <avg-speed units="mph">64</avg-speed>
          <coverage miles="12.99" pct="98" />
        </stop>
        <stop id="6" title="LaVista Rd." sys-pos="30036.87">
          <distance units="miles">16.52</distance>
          <avg-speed units="mph">64</avg-speed>
          <coverage miles="15.76" pct="95" />
        </stop>
        <stop id="7" title="Stone Mtn. Fwy." sys-pos="30038.98">
          <distance units="miles">18.63</distance>
          <avg-speed units="mph">64</avg-speed>
          <coverage miles="17.97" pct="96" />
        </stop>
        <stop id="8" title="Memorial Dr." sys-pos="30041.78">
          <distance units="miles">21.43</distance>
          <avg-speed units="mph">64</avg-speed>
          <coverage miles="20.79" pct="97" />
        </stop>
        <stop id="9" title="I-20 (eastside)" sys-pos="30046.47">
          <distance units="miles">26.12</distance>
          <avg-speed units="mph">64</avg-speed>
          <coverage miles="26.81" pct="103" />
        </stop>
      </start>
      <start id="2" title="Riverside Dr." sys-pos="30024.10">
        <stop id="3" title="Ga-400" sys-pos="30027.00">
          <distance units="miles">2.90</distance>
          <avg-speed units="mph">64</avg-speed>
          <coverage miles="2.84" pct="98" />
          <trip-time units="min">3</trip-time>
        </stop>
        <stop id="4" title="Peachtree industrial Blvd." sys-pos="30031.38">
          <distance units="miles">7.28</distance>
          <avg-speed units="mph">60</avg-speed>
          <coverage miles="7.45" pct="102" />
          <trip-time units="min">7</trip-time>
        </stop>
        <stop id="5" title="I-85 (northside)" sys-pos="30033.60">
          <distance units="miles">9.50</distance>
          <avg-speed units="mph">61</avg-speed>
          <coverage miles="9.3" pct="98" />
        </stop>
        <stop id="6" title="LaVista Rd." sys-pos="30036.87">
          <distance units="miles">12.77</distance>
          <avg-speed units="mph">61</avg-speed>
          <coverage miles="12.07" pct="95" />
        </stop>
        <stop id="7" title="Stone Mtn. Fwy." sys-pos="30038.98">
          <distance units="miles">14.88</distance>
          <avg-speed units="mph">62</avg-speed>
          <coverage miles="14.28" pct="96" />
        </stop>
        <stop id="8" title="Memorial Dr." sys-pos="30041.78">
          <distance units="miles">17.68</distance>
          <avg-speed units="mph">62</avg-speed>
          <coverage miles="17.1" pct="97" />
        </stop>
        <stop id="9" title="I-20 (eastside)" sys-pos="30046.47">
          <distance units="miles">22.37</distance>
          <avg-speed units="mph">63</avg-speed>
          <coverage miles="23.12" pct="103" />
        </stop>
      </start>
      <start id="3" title="Ga-400" sys-pos="30027.00">
        <stop id="4" title="Peachtree industrial Blvd." sys-pos="30031.38">
          <distance units="miles">4.38</distance>
          <avg-speed units="mph">59</avg-speed>
          <coverage miles="4.61" pct="105" />
          <trip-time units="min">4</trip-time>
        </stop>
        <stop id="5" title="I-85 (northside)" sys-pos="30033.60">
          <distance units="miles">6.60</distance>
          <avg-speed units="mph">60</avg-speed>
          <coverage miles="6.46" pct="98" />
        </stop>
        <stop id="6" title="LaVista Rd." sys-pos="30036.87">
          <distance units="miles">9.87</distance>
          <avg-speed units="mph">61</avg-speed>
          <coverage miles="9.23" pct="94" />
        </stop>
        <stop id="7" title="Stone Mtn. Fwy." sys-pos="30038.98">
          <distance units="miles">11.98</distance>
          <avg-speed units="mph">61</avg-speed>
          <coverage miles="11.44" pct="95" />
        </stop>
        <stop id="8" title="Memorial Dr." sys-pos="30041.78">
          <distance units="miles">14.78</distance>
          <avg-speed units="mph">62</avg-speed>
          <coverage miles="14.26" pct="96" />
        </stop>
        <stop id="9" title="I-20 (eastside)" sys-pos="30046.47">
          <distance units="miles">19.47</distance>
          <avg-speed units="mph">63</avg-speed>
          <coverage miles="20.28" pct="104" />
        </stop>
      </start>
      <start id="4" title="Peachtree industrial Blvd." sys-pos="30031.38">
        <stop id="5" title="I-85 (northside)" sys-pos="30033.60">
          <distance units="miles">2.22</distance>
          <avg-speed units="mph">64</avg-speed>
          <coverage miles="1.85" pct="83" />
        </stop>
        <stop id="6" title="LaVista Rd." sys-pos="30036.87">
          <distance units="miles">5.49</distance>
          <avg-speed units="mph">63</avg-speed>
          <coverage miles="4.62" pct="84" />
        </stop>
        <stop id="7" title="Stone Mtn. Fwy." sys-pos="30038.98">
          <distance units="miles">7.60</distance>
          <avg-speed units="mph">63</avg-speed>
          <coverage miles="6.83" pct="90" />
        </stop>
        <stop id="8" title="Memorial Dr." sys-pos="30041.78">
          <distance units="miles">10.40</distance>
          <avg-speed units="mph">63</avg-speed>
          <coverage miles="9.65" pct="93" />
        </stop>
        <stop id="9" title="I-20 (eastside)" sys-pos="30046.47">
          <distance units="miles">15.09</distance>
          <avg-speed units="mph">64</avg-speed>
          <coverage miles="15.67" pct="104" />
        </stop>
      </start>
      <start id="5" title="I-85 (northside)" sys-pos="30033.60">
        <stop id="6" title="LaVista Rd." sys-pos="30036.87">
          <distance units="miles">3.27</distance>
          <avg-speed units="mph">62</avg-speed>
          <coverage miles="2.77" pct="85" />
        </stop>
        <stop id="7" title="Stone Mtn. Fwy." sys-pos="30038.98">
          <distance units="miles">5.38</distance>
          <avg-speed units="mph">63</avg-speed>
          <coverage miles="4.98" pct="93" />
        </stop>
        <stop id="8" title="Memorial Dr." sys-pos="30041.78">
          <distance units="miles">8.18</distance>
          <avg-speed units="mph">63</avg-speed>
          <coverage miles="7.8" pct="95" />
        </stop>
        <stop id="9" title="I-20 (eastside)" sys-pos="30046.47">
          <distance units="miles">12.87</distance>
          <avg-speed units="mph">64</avg-speed>
          <coverage miles="13.82" pct="107" />
        </stop>
      </start>
      <start id="6" title="LaVista Rd." sys-pos="30036.87">
        <stop id="7" title="Stone Mtn. Fwy." sys-pos="30038.98">
          <distance units="miles">2.11</distance>
          <avg-speed units="mph">64</avg-speed>
          <coverage miles="2.21" pct="105" />
          <trip-time units="min">2</trip-time>
        </stop>
        <stop id="8" title="Memorial Dr." sys-pos="30041.78">
          <distance units="miles">4.91</distance>
          <avg-speed units="mph">64</avg-speed>
          <coverage miles="5.03" pct="102" />
          <trip-time units="min">5</trip-time>
        </stop>
        <stop id="9" title="I-20 (eastside)" sys-pos="30046.47">
          <distance units="miles">9.60</distance>
          <avg-speed units="mph">64</avg-speed>
          <coverage miles="11.05" pct="115" />
          <trip-time units="min">9</trip-time>
        </stop>
      </start>
      <start id="7" title="Stone Mtn. Fwy." sys-pos="30038.98">
        <stop id="8" title="Memorial Dr." sys-pos="30041.78">
          <distance units="miles">2.80</distance>
          <avg-speed units="mph">64</avg-speed>
          <coverage miles="2.82" pct="101" />
          <trip-time units="min">3</trip-time>
        </stop>
        <stop id="9" title="I-20 (eastside)" sys-pos="30046.47">
          <distance units="miles">7.49</distance>
          <avg-speed units="mph">65</avg-speed>
          <coverage miles="8.84" pct="118" />
          <trip-time units="min">7</trip-time>
        </stop>
      </start>
      <start id="8" title="Memorial Dr." sys-pos="30041.78">
        <stop id="9" title="I-20 (eastside)" sys-pos="30046.47">
          <distance units="miles">4.69</distance>
          <avg-speed units="mph">65</avg-speed>
          <coverage miles="6.02" pct="128" />
          <trip-time units="min">4</trip-time>
        </stop>
      </start>
      <start id="9" title="I-20 (eastside)" sys-pos="30046.47"></start>
    </direction>
    <direction id="Counter-clockwise" name="Counter-clockwise">
      <start id="9" title="I-20 (eastside)" sys-pos="30046.47">
        <stop id="8" title="Memorial Dr." sys-pos="30041.78">
          <distance units="miles">4.69</distance>
          <avg-speed units="mph">65</avg-speed>
          <coverage miles="6.55" pct="140" />
          <trip-time units="min">4</trip-time>
        </stop>
        <stop id="7" title="Stone Mtn. Fwy." sys-pos="30038.98">
          <distance units="miles">7.49</distance>
          <avg-speed units="mph">64</avg-speed>
          <coverage miles="9.83" pct="131" />
          <trip-time units="min">7</trip-time>
        </stop>
        <stop id="6" title="LaVista Rd." sys-pos="30036.87">
          <distance units="miles">9.60</distance>
          <avg-speed units="mph">64</avg-speed>
          <coverage miles="11.04" pct="115" />
        </stop>
        <stop id="5" title="I-85 (northside)" sys-pos="30033.60">
          <distance units="miles">12.87</distance>
          <avg-speed units="mph">64</avg-speed>
          <coverage miles="12.63" pct="98" />
        </stop>
        <stop id="4" title="Peachtree industrial Blvd." sys-pos="30031.38">
          <distance units="miles">15.09</distance>
          <avg-speed units="mph">64</avg-speed>
          <coverage miles="14.96" pct="99" />
        </stop>
        <stop id="3" title="Ga-400" sys-pos="30027.00">
          <distance units="miles">19.47</distance>
          <avg-speed units="mph">62</avg-speed>
          <coverage miles="19.34" pct="99" />
        </stop>
        <stop id="2" title="Riverside Dr." sys-pos="30024.10">
          <distance units="miles">22.37</distance>
          <avg-speed units="mph">63</avg-speed>
          <coverage miles="21.96" pct="98" />
        </stop>
        <stop id="1" title="I-75 (northside)" sys-pos="30020.35">
          <distance units="miles">26.12</distance>
          <avg-speed units="mph">63</avg-speed>
          <coverage miles="25.89" pct="99" />
        </stop>
      </start>
      <start id="8" title="Memorial Dr." sys-pos="30041.78">
        <stop id="7" title="Stone Mtn. Fwy." sys-pos="30038.98">
          <distance units="miles">2.80</distance>
          <avg-speed units="mph">61</avg-speed>
          <coverage miles="3.28" pct="117" />
          <trip-time units="min">3</trip-time>
        </stop>
        <stop id="6" title="LaVista Rd." sys-pos="30036.87">
          <distance units="miles">4.91</distance>
          <avg-speed units="mph">64</avg-speed>
          <coverage miles="4.49" pct="91" />
        </stop>
        <stop id="5" title="I-85 (northside)" sys-pos="30033.60">
          <distance units="miles">8.18</distance>
          <avg-speed units="mph">63</avg-speed>
          <coverage miles="6.08" pct="74" />
        </stop>
        <stop id="4" title="Peachtree industrial Blvd." sys-pos="30031.38">
          <distance units="miles">10.40</distance>
          <avg-speed units="mph">63</avg-speed>
          <coverage miles="8.41" pct="81" />
        </stop>
        <stop id="3" title="Ga-400" sys-pos="30027.00">
          <distance units="miles">14.78</distance>
          <avg-speed units="mph">61</avg-speed>
          <coverage miles="12.79" pct="87" />
        </stop>
        <stop id="2" title="Riverside Dr." sys-pos="30024.10">
          <distance units="miles">17.68</distance>
          <avg-speed units="mph">62</avg-speed>
          <coverage miles="15.41" pct="87" />
        </stop>
        <stop id="1" title="I-75 (northside)" sys-pos="30020.35">
          <distance units="miles">21.43</distance>
          <avg-speed units="mph">63</avg-speed>
          <coverage miles="19.34" pct="90" />
        </stop>
      </start>
      <start id="7" title="Stone Mtn. Fwy." sys-pos="30038.98">
        <stop id="6" title="LaVista Rd." sys-pos="30036.87">
          <distance units="miles">2.11</distance>
          <avg-speed units="mph">72</avg-speed>
          <coverage miles="1.21" pct="57" />
        </stop>
        <stop id="5" title="I-85 (northside)" sys-pos="30033.60">
          <distance units="miles">5.38</distance>
          <avg-speed units="mph">66</avg-speed>
          <coverage miles="2.8" pct="52" />
        </stop>
        <stop id="4" title="Peachtree industrial Blvd." sys-pos="30031.38">
          <distance units="miles">7.60</distance>
          <avg-speed units="mph">64</avg-speed>
          <coverage miles="5.13" pct="68" />
        </stop>
        <stop id="3" title="Ga-400" sys-pos="30027.00">
          <distance units="miles">11.98</distance>
          <avg-speed units="mph">61</avg-speed>
          <coverage miles="9.51" pct="79" />
        </stop>
        <stop id="2" title="Riverside Dr." sys-pos="30024.10">
          <distance units="miles">14.88</distance>
          <avg-speed units="mph">62</avg-speed>
          <coverage miles="12.13" pct="82" />
        </stop>
        <stop id="1" title="I-75 (northside)" sys-pos="30020.35">
          <distance units="miles">18.63</distance>
          <avg-speed units="mph">63</avg-speed>
          <coverage miles="16.06" pct="86" />
        </stop>
      </start>
      <start id="6" title="LaVista Rd." sys-pos="30036.87">
        <stop id="5" title="I-85 (northside)" sys-pos="30033.60">
          <distance units="miles">3.27</distance>
          <avg-speed units="mph">61</avg-speed>
          <coverage miles="1.59" pct="49" />
        </stop>
        <stop id="4" title="Peachtree industrial Blvd." sys-pos="30031.38">
          <distance units="miles">5.49</distance>
          <avg-speed units="mph">62</avg-speed>
          <coverage miles="3.92" pct="71" />
        </stop>
        <stop id="3" title="Ga-400" sys-pos="30027.00">
          <distance units="miles">9.87</distance>
          <avg-speed units="mph">59</avg-speed>
          <coverage miles="8.3" pct="84" />
        </stop>
        <stop id="2" title="Riverside Dr." sys-pos="30024.10">
          <distance units="miles">12.77</distance>
          <avg-speed units="mph">61</avg-speed>
          <coverage miles="10.92" pct="86" />
        </stop>
        <stop id="1" title="I-75 (northside)" sys-pos="30020.35">
          <distance units="miles">16.52</distance>
          <avg-speed units="mph">62</avg-speed>
          <coverage miles="14.85" pct="90" />
        </stop>
      </start>
      <start id="5" title="I-85 (northside)" sys-pos="30033.60">
        <stop id="4" title="Peachtree industrial Blvd." sys-pos="30031.38">
          <distance units="miles">2.22</distance>
          <avg-speed units="mph">63</avg-speed>
          <coverage miles="2.33" pct="105" />
          <trip-time units="min">2</trip-time>
        </stop>
        <stop id="3" title="Ga-400" sys-pos="30027.00">
          <distance units="miles">6.60</distance>
          <avg-speed units="mph">59</avg-speed>
          <coverage miles="6.71" pct="102" />
          <trip-time units="min">7</trip-time>
        </stop>
        <stop id="2" title="Riverside Dr." sys-pos="30024.10">
          <distance units="miles">9.50</distance>
          <avg-speed units="mph">61</avg-speed>
          <coverage miles="9.33" pct="98" />
          <trip-time units="min">10</trip-time>
        </stop>
        <stop id="1" title="I-75 (northside)" sys-pos="30020.35">
          <distance units="miles">13.25</distance>
          <avg-speed units="mph">63</avg-speed>
          <coverage miles="13.26" pct="100" />
          <trip-time units="min">13</trip-time>
        </stop>
      </start>
      <start id="4" title="Peachtree industrial Blvd." sys-pos="30031.38">
        <stop id="3" title="Ga-400" sys-pos="30027.00">
          <distance units="miles">4.38</distance>
          <avg-speed units="mph">57</avg-speed>
          <coverage miles="4.38" pct="100" />
          <trip-time units="min">5</trip-time>
        </stop>
        <stop id="2" title="Riverside Dr." sys-pos="30024.10">
          <distance units="miles">7.28</distance>
          <avg-speed units="mph">60</avg-speed>
          <coverage miles="7" pct="96" />
          <trip-time units="min">8</trip-time>
        </stop>
        <stop id="1" title="I-75 (northside)" sys-pos="30020.35">
          <distance units="miles">11.03</distance>
          <avg-speed units="mph">62</avg-speed>
          <coverage miles="10.93" pct="99" />
          <trip-time units="min">11</trip-time>
        </stop>
      </start>
      <start id="3" title="Ga-400" sys-pos="30027.00">
        <stop id="2" title="Riverside Dr." sys-pos="30024.10">
          <distance units="miles">2.90</distance>
          <avg-speed units="mph">66</avg-speed>
          <coverage miles="2.62" pct="90" />
          <trip-time units="min">3</trip-time>
        </stop>
        <stop id="1" title="I-75 (northside)" sys-pos="30020.35">
          <distance units="miles">6.65</distance>
          <avg-speed units="mph">66</avg-speed>
          <coverage miles="6.55" pct="98" />
          <trip-time units="min">6</trip-time>
        </stop>
      </start>
      <start id="2" title="Riverside Dr." sys-pos="30024.10">
        <stop id="1" title="I-75 (northside)" sys-pos="30020.35">
          <distance units="miles">3.75</distance>
          <avg-speed units="mph">66</avg-speed>
          <coverage miles="3.93" pct="105" />
          <trip-time units="min">3</trip-time>
        </stop>
      </start>
      <start id="1" title="I-75 (northside)" sys-pos="30020.35"></start>
    </direction>
  </route>
  <route id="20" name="I-20">
    <direction id="West" name="West">
      <start id="7" title="Wesley Chapel Rd." sys-pos="20068.84">
        <stop id="6" title="I-285 (eastside)" sys-pos="20067.47">
          <distance units="miles">1.37</distance>
          <avg-speed units="mph">77</avg-speed>
          <coverage miles="1.27" pct="93" />
          <trip-time units="min">1</trip-time>
        </stop>
        <stop id="5" title="Gresham Rd. / Flat Shoals" sys-pos="20063.70">
          <distance units="miles">5.14</distance>
          <avg-speed units="mph">68</avg-speed>
          <coverage miles="5.3" pct="103" />
          <trip-time units="min">4</trip-time>
        </stop>
        <stop id="4" title="Moreland Ave." sys-pos="20059.88">
          <distance units="miles">8.96</distance>
          <avg-speed units="mph">65</avg-speed>
          <coverage miles="8.72" pct="97" />
          <trip-time units="min">8</trip-time>
        </stop>
        <stop id="3" title="I-75/85" sys-pos="20057.47">
          <distance units="miles">11.37</distance>
          <avg-speed units="mph">64</avg-speed>
          <coverage miles="11.46" pct="101" />
          <trip-time units="min">10</trip-time>
        </stop>
        <stop id="2" title="MLK Jr. Dr." sys-pos="20054.03">
          <distance units="miles">14.81</distance>
          <avg-speed units="mph">63</avg-speed>
          <coverage miles="14.41" pct="97" />
        </stop>
        <stop id="1" title="I-285 (westside)" sys-pos="20050.93">
          <distance units="miles">17.91</distance>
          <avg-speed units="mph">63</avg-speed>
          <coverage miles="17.58" pct="98" />
        </stop>
      </start>
      <start id="6" title="I-285 (eastside)" sys-pos="20067.47">
        <stop id="5" title="Gresham Rd. / Flat Shoals" sys-pos="20063.70">
          <distance units="miles">3.77</distance>
          <avg-speed units="mph">66</avg-speed>
          <coverage miles="4.03" pct="107" />
          <trip-time units="min">3</trip-time>
        </stop>
        <stop id="4" title="Moreland Ave." sys-pos="20059.88">
          <distance units="miles">7.59</distance>
          <avg-speed units="mph">63</avg-speed>
          <coverage miles="7.45" pct="98" />
          <trip-time units="min">7</trip-time>
        </stop>
        <stop id="3" title="I-75/85" sys-pos="20057.47">
          <distance units="miles">10.00</distance>
          <avg-speed units="mph">62</avg-speed>
          <coverage miles="10.19" pct="102" />
          <trip-time units="min">9</trip-time>
        </stop>
        <stop id="2" title="MLK Jr. Dr." sys-pos="20054.03">
          <distance units="miles">13.44</distance>
          <avg-speed units="mph">62</avg-speed>
          <coverage miles="13.14" pct="98" />
        </stop>
        <stop id="1" title="I-285 (westside)" sys-pos="20050.93">
          <distance units="miles">16.54</distance>
          <avg-speed units="mph">62</avg-speed>
          <coverage miles="16.31" pct="99" />
        </stop>
      </start>
      <start id="5" title="Gresham Rd. / Flat Shoals" sys-pos="20063.70">
        <stop id="4" title="Moreland Ave." sys-pos="20059.88">
          <distance units="miles">3.82</distance>
          <avg-speed units="mph">61</avg-speed>
          <coverage miles="3.42" pct="90" />
          <trip-time units="min">4</trip-time>
        </stop>
        <stop id="3" title="I-75/85" sys-pos="20057.47">
          <distance units="miles">6.23</distance>
          <avg-speed units="mph">60</avg-speed>
          <coverage miles="6.16" pct="99" />
          <trip-time units="min">6</trip-time>
        </stop>
        <stop id="2" title="MLK Jr. Dr." sys-pos="20054.03">
          <distance units="miles">9.67</distance>
          <avg-speed units="mph">61</avg-speed>
          <coverage miles="9.11" pct="94" />
        </stop>
        <stop id="1" title="I-285 (westside)" sys-pos="20050.93">
          <distance units="miles">12.77</distance>
          <avg-speed units="mph">61</avg-speed>
          <coverage miles="12.28" pct="96" />
        </stop>
      </start>
      <start id="4" title="Moreland Ave." sys-pos="20059.88">
        <stop id="3" title="I-75/85" sys-pos="20057.47">
          <distance units="miles">2.41</distance>
          <avg-speed units="mph">60</avg-speed>
          <coverage miles="2.74" pct="114" />
          <trip-time units="min">2</trip-time>
        </stop>
        <stop id="2" title="MLK Jr. Dr." sys-pos="20054.03">
          <distance units="miles">5.85</distance>
          <avg-speed units="mph">60</avg-speed>
          <coverage miles="5.69" pct="97" />
        </stop>
        <stop id="1" title="I-285 (westside)" sys-pos="20050.93">
          <distance units="miles">8.95</distance>
          <avg-speed units="mph">61</avg-speed>
          <coverage miles="8.86" pct="99" />
        </stop>
      </start>
      <start id="3" title="I-75/85" sys-pos="20057.47">
        <stop id="2" title="MLK Jr. Dr." sys-pos="20054.03">
          <distance units="miles">3.44</distance>
          <avg-speed units="mph">61</avg-speed>
          <coverage miles="2.95" pct="86" />
        </stop>
        <stop id="1" title="I-285 (westside)" sys-pos="20050.93">
          <distance units="miles">6.54</distance>
          <avg-speed units="mph">61</avg-speed>
          <coverage miles="6.12" pct="94" />
        </stop>
      </start>
      <start id="2" title="MLK Jr. Dr." sys-pos="20054.03">
        <stop id="1" title="I-285 (westside)" sys-pos="20050.93">
          <distance units="miles">3.10</distance>
          <avg-speed units="mph">62</avg-speed>
          <coverage miles="3.17" pct="102" />
          <trip-time units="min">3</trip-time>
        </stop>
      </start>
      <start id="1" title="I-285 (westside)" sys-pos="20050.93"></start>
    </direction>
    <direction id="East" name="East">
      <start id="1" title="I-285 (westside)" sys-pos="20050.93">
        <stop id="2" title="MLK Jr. Dr." sys-pos="20054.03">
          <distance units="miles">3.10</distance>
          <avg-speed units="mph">63</avg-speed>
          <coverage miles="3.11" pct="100" />
          <trip-time units="min">3</trip-time>
        </stop>
        <stop id="3" title="I-75/85" sys-pos="20057.47">
          <distance units="miles">6.54</distance>
          <avg-speed units="mph">65</avg-speed>
          <coverage miles="6.37" pct="97" />
          <trip-time units="min">6</trip-time>
        </stop>
        <stop id="4" title="Moreland Ave." sys-pos="20059.88">
          <distance units="miles">8.95</distance>
          <avg-speed units="mph">65</avg-speed>
          <coverage miles="8.98" pct="100" />
          <trip-time units="min">8</trip-time>
        </stop>
        <stop id="5" title="Gresham Rd. / Flat Shoals" sys-pos="20063.70">
          <distance units="miles">12.77</distance>
          <avg-speed units="mph">65</avg-speed>
          <coverage miles="12.51" pct="98" />
          <trip-time units="min">12</trip-time>
        </stop>
        <stop id="6" title="I-285 (eastside)" sys-pos="20067.47">
          <distance units="miles">16.54</distance>
          <avg-speed units="mph">64</avg-speed>
          <coverage miles="16.48" pct="100" />
          <trip-time units="min">16</trip-time>
        </stop>
        <stop id="7" title="Wesley Chapel Rd." sys-pos="20068.84">
          <distance units="miles">17.91</distance>
          <avg-speed units="mph">65</avg-speed>
          <coverage miles="17.77" pct="99" />
          <trip-time units="min">17</trip-time>
        </stop>
      </start>
      <start id="2" title="MLK Jr. Dr." sys-pos="20054.03">
        <stop id="3" title="I-75/85" sys-pos="20057.47">
          <distance units="miles">3.44</distance>
          <avg-speed units="mph">67</avg-speed>
          <coverage miles="3.26" pct="95" />
          <trip-time units="min">3</trip-time>
        </stop>
        <stop id="4" title="Moreland Ave." sys-pos="20059.88">
          <distance units="miles">5.85</distance>
          <avg-speed units="mph">66</avg-speed>
          <coverage miles="5.87" pct="100" />
          <trip-time units="min">5</trip-time>
        </stop>
        <stop id="5" title="Gresham Rd. / Flat Shoals" sys-pos="20063.70">
          <distance units="miles">9.67</distance>
          <avg-speed units="mph">66</avg-speed>
          <coverage miles="9.4" pct="97" />
          <trip-time units="min">9</trip-time>
        </stop>
        <stop id="6" title="I-285 (eastside)" sys-pos="20067.47">
          <distance units="miles">13.44</distance>
          <avg-speed units="mph">64</avg-speed>
          <coverage miles="13.37" pct="99" />
          <trip-time units="min">13</trip-time>
        </stop>
        <stop id="7" title="Wesley Chapel Rd." sys-pos="20068.84">
          <distance units="miles">14.81</distance>
          <avg-speed units="mph">65</avg-speed>
          <coverage miles="14.66" pct="99" />
          <trip-time units="min">14</trip-time>
        </stop>
      </start>
      <start id="3" title="I-75/85" sys-pos="20057.47">
        <stop id="4" title="Moreland Ave." sys-pos="20059.88">
          <distance units="miles">2.41</distance>
          <avg-speed units="mph">65</avg-speed>
          <coverage miles="2.61" pct="108" />
          <trip-time units="min">2</trip-time>
        </stop>
        <stop id="5" title="Gresham Rd. / Flat Shoals" sys-pos="20063.70">
          <distance units="miles">6.23</distance>
          <avg-speed units="mph">65</avg-speed>
          <coverage miles="6.14" pct="99" />
          <trip-time units="min">6</trip-time>
        </stop>
        <stop id="6" title="I-285 (eastside)" sys-pos="20067.47">
          <distance units="miles">10.00</distance>
          <avg-speed units="mph">64</avg-speed>
          <coverage miles="10.11" pct="101" />
          <trip-time units="min">10</trip-time>
        </stop>
        <stop id="7" title="Wesley Chapel Rd." sys-pos="20068.84">
          <distance units="miles">11.37</distance>
          <avg-speed units="mph">65</avg-speed>
          <coverage miles="11.4" pct="100" />
          <trip-time units="min">11</trip-time>
        </stop>
      </start>
      <start id="4" title="Moreland Ave." sys-pos="20059.88">
        <stop id="5" title="Gresham Rd. / Flat Shoals" sys-pos="20063.70">
          <distance units="miles">3.82</distance>
          <avg-speed units="mph">65</avg-speed>
          <coverage miles="3.53" pct="92" />
          <trip-time units="min">4</trip-time>
        </stop>
        <stop id="6" title="I-285 (eastside)" sys-pos="20067.47">
          <distance units="miles">7.59</distance>
          <avg-speed units="mph">63</avg-speed>
          <coverage miles="7.5" pct="99" />
          <trip-time units="min">8</trip-time>
        </stop>
        <stop id="7" title="Wesley Chapel Rd." sys-pos="20068.84">
          <distance units="miles">8.96</distance>
          <avg-speed units="mph">65</avg-speed>
          <coverage miles="8.79" pct="98" />
          <trip-time units="min">9</trip-time>
        </stop>
      </start>
      <start id="5" title="Gresham Rd. / Flat Shoals" sys-pos="20063.70">
        <stop id="6" title="I-285 (eastside)" sys-pos="20067.47">
          <distance units="miles">3.77</distance>
          <avg-speed units="mph">61</avg-speed>
          <coverage miles="3.97" pct="105" />
          <trip-time units="min">4</trip-time>
        </stop>
        <stop id="7" title="Wesley Chapel Rd." sys-pos="20068.84">
          <distance units="miles">5.14</distance>
          <avg-speed units="mph">65</avg-speed>
          <coverage miles="5.26" pct="102" />
          <trip-time units="min">5</trip-time>
        </stop>
      </start>
      <start id="6" title="I-285 (eastside)" sys-pos="20067.47">
        <stop id="7" title="Wesley Chapel Rd." sys-pos="20068.84">
          <distance units="miles">1.37</distance>
          <avg-speed units="mph">76</avg-speed>
          <coverage miles="1.29" pct="94" />
          <trip-time units="min">1</trip-time>
        </stop>
      </start>
      <start id="7" title="Wesley Chapel Rd." sys-pos="20068.84"></start>
    </direction>
  </route>
</trip-report>

Open in new window

0
 
LVL 25

Assisted Solution

by:imitchie
imitchie earned 500 total points
ID: 20392666
well, you can see that the Start has multiple stops, hence the parent-child inference. What you really need is a XML-Transform to take place before you attempt to import the data.  I see that you have stop attributes as well as stop child nodes, so you really need to transform that to make it suitable for import.
0
 
LVL 3

Author Comment

by:randomjames
ID: 20398366
I managed to get what I needed using a different approach. I used XPath in OPENXML instead of an XSD and an XSLT with SQLXMLBulkLoad and ended up getting what I need. Fortunately none of the files I'll be using are very large so I don't need  to do a bulk load.

This lays out my data in a nice, clean table format. I posted what ended up working for anyone else that might have a similar issue.

Thanks for the help imitchie
BEGIN
 
SET NOCOUNT ON
 
DECLARE @XMLText NVARCHAR(MAX), @hDoc int
 
CREATE TABLE #FileLines
(
	RowID INTEGER IDENTITY,
	LineData NVARCHAR(255)
)
 
INSERT #FileLines EXEC MASTER.DBO.xp_cmdshell 'TYPE C:\traffic_data\xml\trip.xml'
 
SELECT
@XMLText = CASE RowID
	WHEN 1 THEN ISNULL(RTRIM(LineData), '')
	ELSE @XMLText + ISNULL(RTRIM(LineData), '')
	END
FROM
	#FileLines
ORDER BY
	RowID ASC
 
DROP TABLE #FileLines
 
EXEC sp_xml_preparedocument @hDoc OUTPUT, @XMLText
 
SELECT 
	*
FROM
	OPENXML(@hDOC, '/trip-report/route/direction/start/stop', 2)
		WITH
		(
			DateTimeStamp DATETIME '../../../../@timestamp',
			RouteID VARCHAR(10) '../../../@id',
			RouteName VARCHAR(10) '../../../@name',
			DirectionID VARCHAR(10) '../../@id',
			DirectionName VARCHAR(15) '../../@name',
			StartID VARCHAR(10) '../@id',
			StartName VARCHAR(10) '../@title',
			StartSysPos VARCHAR(10) '../@sys-pos',
			StopID VARCHAR(10) '@id',
			StopName VARCHAR(10) '@title',
			StopSysPos VARCHAR(10) '@sys-pos',
			Distance VARCHAR(10) 'distance',
			DistanceUnits VARCHAR(10) 'distance/@units',
			AvgSpeed VARCHAR(10) 'avg-speed',
			AvgSpeedUnits VARCHAR(10) 'avg-speed/@units',
			CoverageMiles VARCHAR(10) 'coverage/@miles',
			CoveragePct VARCHAR(10) 'coverage/@pct',
			TripTime VARCHAR(10) 'trip-time',
			TripTimeUnits VARCHAR(10) 'trip-time/@units'
		)
 
EXEC sp_xml_removedocument @hDoc
 
END

Open in new window

0

Featured Post

Active Directory Webinar

We all know we need to protect and secure our privileges, but where to start? Join Experts Exchange and ManageEngine on Tuesday, April 11, 2017 10:00 AM PDT to learn how to track and secure privileged users in Active Directory.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
The Confluence of Individual Knowledge and the Collective Intelligence At this writing (summer 2013) the term API (http://dictionary.reference.com/browse/API?s=t) has made its way into the popular lexicon of the English language.  A few years ago, …
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Viewers will learn how the fundamental information of how to create a table.

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question