Relationship expected error though only one SQL table?
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</HResu
<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
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</HResu
<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>
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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)
<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)
ASKER
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.
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>SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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
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
ASKER
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).