topic Display SQL Geography in ESRI JS in ArcGIS JavaScript Maps SDK Questions

Display SQL Geography in ESRI JS

AlexeiB — Tue, 29 Nov 2016 04:35:38 GMT

Hello,

How do I display SQL Geography in ESRI JS?

My API returns a geography I inserted into SQL from a tutorial I found.

"Shape": { "Geography": { "CoordinateSystemId": 4326, "WellKnownText": "POLYGON ((-122.358 47.653, -122.348 47.649, -122.348 47.658, -122.358 47.658, -122.358 47.653))", "WellKnownBinary": null } }

I can write a parser for this and get it to show but it seems like it's a lot of work. I was wondering if anyone has done this before and has any tips?

Thanks,

Re: Display SQL Geography in ESRI JS

FC_Basson — Tue, 29 Nov 2016 05:47:01 GMT

According to the API documentation (Polygon | API Reference | ArcGIS API for JavaScript 3.18 | Polygon | API Reference | ArcGIS API for JavaScript 4.1 ) there does not seem to be a way of constructing a polygon directly from the SQL WKT. Parse and plot - should be easy enough.

Re: Display SQL Geography in ESRI JS

BenFousek — Tue, 29 Nov 2016 17:06:13 GMT

Check out GitHub - Esri/Terraformer: A geographic toolkit for dealing with geometry, geography, formats, and building geo database… You'll need the WKT Parser module as well. A single AMD module with just the methods you need can be built with Browserify

Re: Display SQL Geography in ESRI JS

AlexeiB — Mon, 05 Dec 2016 05:39:34 GMT

Thanks everyone. I ended up writing a simple parser for the geometry and it looks like it's working.