By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Declare @xml XML = '<?xml version="1.0"?>
<LandXML xmlns="http://www.landxml.org/schema/LandXML-1.1" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.landxml.org/schema/LandXML-1.1 http://www.landxml.org/schema/LandXML-1.1/LandXML-1.1.xsd" date="2007-10-20" time="17:22:09" version="1.1" language="English" readOnly="false">
<Units>
<Imperial areaUnit="squareFoot" linearUnit="foot" volumeUnit="cubicYard" temperatureUnit="fahrenheit" pressureUnit="inchHG" diameterUnit="inch" angularUnit="decimal degrees" directionUnit="decimal degrees"></Imperial>
</Units>
<CoordinateSystem desc="HARN (HPGN) Florida State Planes, East Zone, US Foot" ogcWktCode="PROJCS["FLHP-EF",GEOGCS["LL-HPGN",DATUM["HPGN",SPHEROID["GRS1980",6378137.000,298.25722210]],PRIMEM["Greenwich",0],UNIT["Degree",0.017453292519943295]],PROJECTION["Transverse_Mercator"],PARAMETER["false_easting",656166.667],PARAMETER["false_northing",0.000],PARAMETER["scale_factor",0.999941176471],PARAMETER["central_meridian",-81.00000000000000],PARAMETER["latitude_of_origin",24.33333333333333],UNIT["Foot_US",0.30480060960122]]" horizontalDatum="HPGN" horizontalCoordinateSystemName="FLHP-EF" fileLocation="AutoCAD Map Zone Name"></CoordinateSystem>
<Project name="C:\Documents and Settings\JorgeK\Desktop\CURRENT\UCF\SR-DGN-PROJ\UCF-ARBORETUM\dwg\UCF-ARB-FDGN.dwg"></Project>
<Application name="AutoCAD Civil 3D" desc="Civil 3D" manufacturer="Autodesk, Inc." version="2008" manufacturerURL="www.autodesk.com/civil" timeStamp="2007-10-20T17:22:09"></Application>
<Alignments name="">
<Alignment name="AL-1" length="54.055248541569" staStart="1000." desc="">
<CoordGeom>
<Line dir="332.184029560865" length="8.864727370067">
<Start>1550921.5827274956 592831.84063415369</Start>
<End>1550917.4461515071 592839.68105062458</End>
</Line>
<Spiral length="10." radiusEnd="30." radiusStart="INF" rot="cw" spiType="clothoid" theta="9.549296585514" totalY="0.554454236563" totalX="9.972257921783" tanLong="6.676392709492" tanShort="3.342176984846">
<Start>1550917.4461515071 592839.68105062458</Start>
<PI>1550914.3307244433 592845.58599368203</PI>
<End>1550912.3023774354 592848.24229678721</End>
</Spiral>
<Curve rot="cw" chord="1.295497212228" crvType="arc" delta="2.474409707229" dirEnd="320.160323270288" dirStart="322.634732977518" external="0.006995416978" length="1.295597893068" midOrd="0.006993786163" radius="30.000000000797" tangent="0.6478996485">
<Start>1550912.3023774354 592848.24229678733</Start>
<Center>1550888.4588973736 592830.03547228139</Center>
<End>1550911.494099478 592849.25471951056</End>
<PI>1550911.9091709286 592848.7572361991</PI>
</Curve>
<Spiral length="10." radiusEnd="INF" radiusStart="30." rot="cw" spiType="clothoid" theta="9.549296585514" totalY="0.554454236563" totalX="9.972257921783" tanLong="6.676392709492" tanShort="3.342176984846">
<Start>1550911.494099478 592849.25471951056</Start>
<PI>1550909.3529630154 592851.82097600971</PI>
<End>1550904.2846047955 592856.16677665606</End>
</Spiral>
<Line dir="310.611026682892" length="7.019159649992">
<Start>1550904.2846047955 592856.16677665606</Start>
<End>1550898.9560374692 592860.73569036077</End>
</Line>
<Line dir="300.875832153876" length="16.875763628442">
| AlignmentName | AlignmentLength | AlignmentStartM | SegmentNum | SegmentType | SegmentLength | SegmentStartM | SegmentEndM | RunningTotalLength |
|---|---|---|---|---|---|---|---|---|
| AL-1 | 54.055248541569 | 1000 | 1 | Line | 8.864727370067 | 0 | 0 | 8.864727370067 |
| AL-1 | 54.055248541569 | 1000 | 2 | Spiral | 10 | 0 | 0 | 18.864727370067 |
| AL-1 | 54.055248541569 | 1000 | 3 | Curve | 1.295597893068 | 0 | 0 | 20.160325263135 |
| AL-1 | 54.055248541569 | 1000 | 4 | Spiral | 10 | 0 | 0 | 30.160325263135 |
| AL-1 | 54.055248541569 | 1000 | 5 | Line | 7.019159649992 | 0 | 0 | 37.179484913127 |
| AL-1 | 54.055248541569 | 1000 | 6 | Line | 16.875763628442 | 0 | 0 | 54.055248541569 |
| AL-2 | 103.912591379321 | 8000 | 1 | Line | 21.307738926737 | 0 | 0 | 21.307738926737 |
| AL-2 | 103.912591379321 | 8000 | 2 | Spiral | 10 | 0 | 0 | 31.307738926737 |
| AL-2 | 103.912591379321 | 8000 | 3 | Line | 1.811956496263 | 0 | 0 | 33.119695423 |
| AL-2 | 103.912591379321 | 8000 | 4 | Spiral | 10 | 0 | 0 | 43.119695423 |
| AL-2 | 103.912591379321 | 8000 | 5 | Line | 33.289436906511 | 0 | 0 | 76.409132329511 |
| AL-2 | 103.912591379321 | 8000 | 6 | Line | 3.17722982984 | 0 | 0 | 79.586362159351 |
| AL-2 | 103.912591379321 | 8000 | 7 | Spiral | 10 | 0 | 0 | 89.586362159351 |
| AL-2 | 103.912591379321 | 8000 | 8 | Curve | 0.382671963827 | 0 | 0 | 89.969034123178 |
| AL-2 | 103.912591379321 | 8000 | 9 | Spiral | 10 | 0 | 0 | 99.969034123178 |
| AL-2 | 103.912591379321 | 8000 | 10 | Line | 3.943557256143 | 0 | 0 | 103.912591379321 |