Hi @simongreener, I dont have much experience with this specific GML writer, but I do know that the generic GML writer has more settings for the GML version that might result in what you are looking for.

Another option of the generic GML writer is to use the application schema as GML version.

Hope this helps.

Hi @simongreener, if you just need to create XML snippets for each line geometry with a specific format, simple string concatenation could be easier than GML/XML manipulations. e.g.

1. CoordinateSwapper (Swap Type: X <-> Y)
2. CoordinateConcatenator (Coordinate Delimiter: <space>; Coordinate Element Delimiter <space>; Coordinate Element(s) To Include: X, Y; Coordinate Attribute: _coordinates)
3. StringConcatenator:

<LineString xmlns="http://www.opengis.net/gml"><posList>@Value(_coordinates)</posList></LineString>

Another option is to use the SF GML wirter and correct the poslist by removing the Z coordinate and rewriting the GML via a Text writer.

Thanks to itay and takashi for the suggestions.

I have taken a look at other gml datasets available on the web and most have namespace prefixes so the problem is not something that can be solved just in FME.

I have come up with a solution that sees the gml document being ingested into a single row/column of a SQL Server table, and then manipulated by a combination of SQL Server XML and string processing (sadly, I agree that string manipulation of the XML is easier than trying to process with XML manipulations only).

Here is an example of the processing to extract single linestrings (another insert / select is needed for the multiLineStrings)

Thanks to all.

Simon

INSERT INTO eRoad (ObjectId,Street, RoadType,Shape_Length,line)
SELECT f.objectid,f.street,f.roadtype,Shape_Length,
       geography::GeomFromGml ( f.linestring, 4283 ) as line
  FROM (SELECT road.child.value('declare namespace fme="http://www.safe.com/gml/fme"; 
                                 fme:OBJECTIDg1]','int') as objectId,
               road.child.value('declare namespace fme="http://www.safe.com/gml/fme"; 
                                 fme:STREET'1]',  'varchar(100)') as Street,
               road.child.value('declare namespace fme="http://www.safe.com/gml/fme"; 
                                 fme:ROADTYPE<1]','int') as RoadType,
               road.child.value('declare namespace fme="http://www.safe.com/gml/fme"; 
                                 fme:Shape_Length 1]','float') as Shape_Length,
               replace(replace(replace(replace(replace(
                 CAST(road.child.query('declare namespace fme="http://www.safe.com/gml/fme"; 
                                        fme:curveProperty/*')  as varchar(max)),
                 'p1:',''),' 0 ',' '),' 0<','<'),':p1',''),'srsName="EPSG:4283"','')
                 as linestring
          FROM RoadGML a
               CROSS APPLY
               a.gml.nodes('declare namespace fme="http://www.safe.com/gml/fme"; 
                            /fme:FeatureCollection/fme:featureMember/fme:Roads') AS Road(child)
         WHERE a.gml.exist('declare namespace fme="http://www.safe.com/gml/fme";
                            declare namespace gml="http://www.opengis.net/gml";
                            /fme:FeatureCollection/fme:featureMember/fme:Roads/fme:curveProperty')=1
      ) as f
 WHERE len(f.linestring)<>0;