Solved

Relationship expected error though only one SQL table?

Posted on 2007-12-02
6
1,199 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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
LVL 3

Author Comment

by:randomjames
Comment Utility
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
Comment Utility
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
Comment Utility
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

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

771 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now