Modify JSON to Combine 2 objects into an Array

Question

Very new to C# here. I have a list of points in a JSON file, where the geometry is stored like:

{
  "displayFieldName" : "",
  "fieldAliases" : {
    "FID" : "FID",
    ...
  },
  "geometryType" : "esriGeometryPoint",
  "spatialReference" : {
    "wkid" : 4326,
    "latestWkid" : 4326
  },
  "fields" : [
    {
      "name" : "FID",
      "type" : "esriFieldTypeOID",
      "alias" : "FID"
    },
    {
      "name" : "LAYER",
      "type" : "esriFieldTypeString",
      "alias" : "LAYER",
      "length" : 21
    },
    ...
  ],
  "features" : [{"attributes":{"FID":0,"LAYER":"Unknown Point Feature",..."geometry":{"x":10.050555968000026048,"y":116.21585196500007}}
..]

And have been trying to reformat the x and y objects into a single array like so:

"geometry": [123.095215893000045,20.11883803400008]

Have been toying around with Newtonsoft.Json with no luck

Any suggestions?

Edit: As suggested in the comments, I updated the abbreviated/general layout of the JSON file... It was an ESRI shapefile exported as JSON. Thanks to Serge's guidance I was able to figure it out. Snippet below:

string json = File.ReadAllText("file.json");
var jsonParsed = JObject.Parse(json);

foreach (var item in JArray.Parse(jsonParsed["features"].ToString()))
{
    var geometry = item["geometry"];      
    jsonParsed["geometry"] = new JArray() { geometry["x"], geometry["y"] };   
}

It's always nicer if the code you provide is valid. That JSON snippet is invalid (it starts with a closing curly bracket and a comma) and, even ignoring that, does represent "a list of geometric points in a JSON file" — Flydog57
– Flydog57, Commented Aug 24, 2022 at 15:42
Can you give a full sample of your JSON, as what you have is just a fragment — Charlieface
– Charlieface, Commented Aug 24, 2022 at 18:39

Serge · Accepted Answer · 2022-08-24 16:00:02Z

3

You have to parse your json at first

  var jsonParsed=JObject.Parse(json);
  var geometry = (JObject)jsonParsed["geometry"];

  jsonParsed["geometry"] = new JArray() { geometry["x"],geometry["y"] };

  json = jsonParsed.ToString();

json

{
  "geometry": [
    123.09521589300005,
    20.11883803400008
  ]
}

edited Aug 24, 2022 at 16:00

answered Aug 24, 2022 at 15:42

Serge

44.4k4 gold badges26 silver badges53 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Modify JSON to Combine 2 objects into an Array

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related