AnsweredAssumed Answered

Postgresql ST_Point problem (Can't see point symbol on map)

Question asked by muglabbcbs on Jun 29, 2017
Latest reply on Jul 2, 2017 by muglabbcbs

i am using Arcgis for Server and Arcgis Portal webmaps with Postgresql db.

Created a Feature Class with ArcCatalog and shared as Feature Service, so i am trying to add data to this Feature Class with a Sql Query.

(Geometry column name "shape")

i made success adding data with these queries;

INSERT INTO sde.data_table (objectid, name, globalid, shape)VALUES (21,'dataname',sde.next_globalid(),sde.ST_Geometry('point (622000 4122000)', 32635));

or

INSERT INTO sde.data_table (objectid, name, globalid, shape)VALUES (21,'dataname',sde.next_globalid(),sde.ST_Geometry('point (622000 4122000)', 32635));

or

INSERT INTO sde.data_table (objectid, name, globalid, shape)VALUES (sde.next_rowid('sde', 'data_table'),'dataname',sde.next_globalid(),sde.ST_Geometry('point (622000 4122000)', 32635));

My problem is;

I can see data with Arcmap's and Webmap created with Portal Attribute Table, but i cannot see point symbol on the map, it is there but no symbol, also i cannot identify with a mouse click. Just like a hidden object.


PostgreSQL 9.4.5 / Arcmap 10.4 / Arcgis For Server / Arcgis Portal

Outcomes