Skip to Content
0

Exposing Spatial Data In a Calculation View

Nov 10, 2016 at 03:27 PM

67

avatar image
Former Member

Hi Experts,

I have geospatial data and i would like to expose it in GEOJSON format.To do so i have written a calculation view with the below code and selected "VARCHAR" as data type for geometry column "SHAPE". To expose the data outside i have written a odata service which just seems to work but i am not sure if this is the correct way to do this.

Calc View Code:

SELECT "TOID" AS TOID,

"SHAPE".ST_ASGEOJSON() AS SHAPE, 1 AS COUNTER

FROM "ABC"."xyz_buildings";

I have gone through this video which explains how we do geospatial joins in calc views but its does not speak about exposing the data.

https://www.youtube.com/watch?v=d_Ai7sJDraE&list=PLkzo92owKnVxG2luiBuXD57SYRFhzXhiA∈dex=8

Thanks & Regards

Madhusudan

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers