<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 14 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-AU link=blue vlink=purple><div class=WordSection1><p class=MsoNormal>Hi,<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>The export from a file (tested on .gml and .shp) to a table in MSSQL Spatial database does not work properly when the data points use 3 dimensions.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>For instance, I have a file (test02.gml) with 2 LineString: <o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><i> <gml:featureMember><o:p></o:p></i></p><p class=MsoNormal><i> <ogr:test02 fid="F0"><o:p></o:p></i></p><p class=MsoNormal><i> <ogr:geometryProperty><gml:LineString><gml:coordinates>114.82008919027152,-30.533088637478372,200 114.84597389066435,-30.695620477154364,200 115.11987013900723,-30.685988960729119,200 115.10361695503964,-30.554759549435168,200 115.05726528224315,-30.558973337871215,200 114.82008919027152,-30.533088637478372,200</gml:coordinates></gml:LineString></ogr:geometryProperty><o:p></o:p></i></p><p class=MsoNormal><i> </ogr:test02><o:p></o:p></i></p><p class=MsoNormal><i> </gml:featureMember><o:p></o:p></i></p><p class=MsoNormal><i> <gml:featureMember><o:p></o:p></i></p><p class=MsoNormal><i> <ogr:test02 fid="F1"><o:p></o:p></i></p><p class=MsoNormal><i> <ogr:geometryProperty><gml:LineString><gml:coordinates>114.87649177159327,-30.506319349105187,195 114.96677069805884,-30.538409014910489,205</gml:coordinates></gml:LineString></ogr:geometryProperty><o:p></o:p></i></p><p class=MsoNormal><i> </ogr:test02><o:p></o:p></i></p><p class=MsoNormal><i> </gml:featureMember><o:p></o:p></i></p><p class=MsoNormal><i></ogr:FeatureCollection><o:p></o:p></i></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>As shown above the first LineString has a constant elevation (Z component) of 200 and the second LineString as an elevation of 195 and 205. When using ogr2ogr to export the data to a MSSQL Spatial database, the Z components are written in the wrong place in the geometry column.<o:p></o:p></p><p class=MsoNormal>I used the following command line to export to MSSQL:<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><i>ogr2ogr -overwrite -f MSSQLSpatial "MSSQL:server=<my server>;database=Spatial;trusted_connection=yes" "C:\Work\test02.gml" <o:p></o:p></i></p><p class=MsoNormal><i><o:p> </o:p></i></p><p class=MsoNormal>Then I use ogrinfo to dump the content of the table:<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><i>ogrinfo -al "MSSQL:server=mm00786\mm00786;database=Spatial;tables=dbo.test02;trusted_connection=yes"<o:p></o:p></i></p><p class=MsoNormal><i><o:p> </o:p></i></p><p class=MsoNormal><i>Layer name: test02<o:p></o:p></i></p><p class=MsoNormal><i>Geometry: Unknown (any)<o:p></o:p></i></p><p class=MsoNormal><i>Feature Count: 2<o:p></o:p></i></p><p class=MsoNormal><i>Extent: (-30.695620, -30.554760) - (200.000000, 200.000000)<o:p></o:p></i></p><p class=MsoNormal><i>Layer SRS WKT:<o:p></o:p></i></p><p class=MsoNormal><i>(unknown)<o:p></o:p></i></p><p class=MsoNormal><i>FID Column = ogr_fid<o:p></o:p></i></p><p class=MsoNormal><i>Geometry Column = ogr_geometry<o:p></o:p></i></p><p class=MsoNormal><i>OGRFeature(test02):1<o:p></o:p></i></p><p class=MsoNormal><i> LINESTRING (114.82008919027152 -30.533088637478368 114.84597389066435,-30.695620477154364 115.11987013900723 -30.685988960729119,115.10361695503964 -30.554759549435168 115.05726528224316,-30.558973337871212 114.82008919027152 -30.533088637478368,200 200 200,200 200 200)<o:p></o:p></i></p><p class=MsoNormal><i><o:p> </o:p></i></p><p class=MsoNormal><i>OGRFeature(test02):2<o:p></o:p></i></p><p class=MsoNormal><i> LINESTRING (114.87649177159328 -30.506319349105187 114.96677069805884,-30.538409014910489 195.0 205)<o:p></o:p></i></p><p class=MsoNormal><i><o:p> </o:p></i></p><p class=MsoNormal>All the Z components are written at the end of LINESTRING and the comma delimiter is then set at the wrong spot.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Thus importing the results back to GML are obviously wrong. This scenario also happens for Polygons feature type and other input files.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>I’m using GDAL 1.8.0.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Thanks.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p></div></body></html>