Combining various xml elements into one collection using GML/C#/LINQ

Question

I am attempting to read a GML file in C#. I would like to store all the returned data in one object. So far I have been able to return all the data but in 3 separate objects:

XDocument doc = XDocument.Load(fileName);
XNamespace gml = "http://www.opengis.net/gml";

// Points
var points = doc.Descendants(gml + "Point")
              .Select(e => new
              {
                POSLIST = (string)e.Element(gml + "pos")
              });

// LineString
var lineStrings = doc.Descendants(gml + "LineString")
                  .Select(e => new
                  {
                      POSLIST = (string)e.Element(gml + "posList")
                  });

// Polygon
var polygons = doc.Descendants(gml + "LinearRing")
               .Select(e => new
               {
                   POSLIST = (string)e.Element(gml + "posList")
               });

I would like to instead of creating 3 separate objects, I would like to create one object as follows:

var all = doc.Descendants(gml + "Point")
          doc.Descendants(gml + "LineString")
          doc.Descendants(gml + "LinearRing")....

But need some help. Thanks before hand.

Sample Data:

<gml:Point>
<gml:pos>1 2 3</gml:pos>
</gml:Point>
<gml:LineString>
<gml:posList>1 2 3</gml:posList>
</gml:LineString>
<gml:LinearRing>
<gml:posList>1 2 3</gml:posList>
</gml:LinearRing>

Gilad, I have added sample data. Thanks. – Robert Smith Aug 29 '16 at 19:37 — Robert Smith, Aug 29 '16 at 19:37

score 1 · Accepted Answer · edited Sep 29 '17 at 17:32

1

You can use Concat:

XDocument doc = XDocument.Load(fileName);
XNamespace gml = "http://www.opengis.net/gml";
var all = doc.Descendants(gml + "Point")
             .Concat(doc.Descendants(gml + "LineString"))
             .Concat(doc.Descendants(gml + "LinearRing"));

For getting the values as the inner elements you can do something like this:

XDocument doc = XDocument.Load("data.xml");
XNamespace gml = "http://www.opengis.net/gml";
var all = doc.Descendants(gml + "Point")
             .Select(e => new { Type = e.Name, Value = (string)e.Element(gml + "pos") })
             .Concat(doc.Descendants(gml + "LineString")
                        .Select(e => new { Type = e.Name, Value = (string)e.Element(gml + "posList") }))
             .Concat(doc.Descendants(gml + "LinearRing")
                        .Select(e => new { Type = e.Name, Value = (string)e.Element(gml + "posList") }));

edited Sep 29 '17 at 17:32

Graham

7,431
18
59
84

answered Aug 29 '16 at 19:38

Gilad Green

36,708
7
61
95

@Robert Smith - Check this – Gilad Green Aug 29 '16 at 19:42
Thanks Gilad! How would I select "pos" for points and "posList" for LineString/Polygons as you see in my above example? – Robert Smith Aug 29 '16 at 19:46
@RobertSmith - Does it now do how you need? – Gilad Green Aug 29 '16 at 19:54
It is perfect, even better than perfect since you added the "Type = e.Name" i was going to need! Thank you very much! – Robert Smith Aug 29 '16 at 20:00
@RobertSmith - Also look in the documentation link that I gave you - always a good place to start from :) Upvoting good examples there is also good – Gilad Green Aug 29 '16 at 20:01
@RobertSmith - Glad it helped you – Gilad Green Aug 29 '16 at 20:01
1

Thanks again, I will take a look at the documentation. – Robert Smith Aug 29 '16 at 20:07

Combining various xml elements into one collection using GML/C#/LINQ

1 Answers1