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

muygunol — Fri, 30 Jun 2017 05:57:46 GMT

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));

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

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

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

muygunol — Mon, 03 Jul 2017 06:18:37 GMT

Hi. my problem solved. I choose the right Srid then symbols showed on the web map.

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)', 300001));

topic Postgresql ST_Point problem (Can't see point symbol on map) in Geodatabase Questions

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

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