Databases
StackOverflow2013
Postsdbo
POJSON.NET and arrays using LINQ
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POJSON.NET and arrays using LINQ
    primarykey
    data
    text
    <p>I looked at this <a href="https://stackoverflow.com/questions/401756/parsing-json-using-json-net">Parsing JSON using Json.net</a> question and answer and it's close to what I need. The critical difference Is that I need to parse an array of x,y pairs that form one or more lines per record. Here's an example of my input</p> <pre><code>{ "displayFieldName" : "FACILITYID", "fieldAliases" : { "FACILITYID" : "Facility Identifier", }, "geometryType" : "esriGeometryPolyline", "spatialReference" : { "wkid" : 4326 }, "features" : [ { "attributes" : { "FACILITYID" : "", "OBJECTID" : 1, }, "geometry" : { "paths" : [ [ [-80.3538239379999, 27.386884271], [-80.3538100319999, 27.3868901900001], [-80.3538157239999, 27.3869008510001] ] ] } }, { "attributes" : { "FACILITYID" : "", "OBJECTID" : 2, }, "geometry" : { "paths" : [ [ [-80.3538239379999, 27.386884271], [-80.3538295849999, 27.3868948420001] ] ] } } ] } </code></pre> <p>(Check out <a href="http://sampleserver1.arcgisonline.com/ArcGIS/rest/services/WaterTemplate/WaterDistributionNetwork/MapServer/9/query?outFields=" rel="nofollow noreferrer">http://sampleserver1.arcgisonline.com/ArcGIS/rest/services/WaterTemplate/WaterDistributionNetwork/MapServer/9/query?outFields=</a>*&amp;where=OBJECTID%3C20&amp;f=pjson for the full listing)</p> <p>What I need to do is parse the ["features"]["geometry"]["paths"] arrays in to lines composed of x,y pairs. Here is how I'm getting all of the paths (one per "record" as in the features array):</p> <pre><code>var allPaths = from p in jsonObject["features"].Children()["geometry"] select p["paths"]; </code></pre> <p>That gives me my paths, from which I can then process each point array in turn:</p> <pre><code>foreach (var eachPolylineInPath in allPaths) { IEnumerable&lt;Point&gt; linePoints = from line in eachPolylineInPath.Children() select new Point( (double) line[0], (double) line[1], double.NaN); } </code></pre> <p>That's where I get stuck. I'm trying various casts from JArray and LINQ-y statements but keep getting null results or exceptions to the tune of JProperty child values cannot be accessed.</p> <p>Hopefully someone has already dealt with converting arrays of arrays in JSON.NET using LINQ and can explain the stupid mistake I must be making, or the obvious answer I'm failing to see.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USCommunity
    1. USDylan
    plurals
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POJSON.NET and arrays using LINQ
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POJSON.NET and arrays using LINQ
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POJSON.NET and arrays using LINQ
      1. This table or related slice is empty.
      1. VTUpMod
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload