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

622
1
Jump to solution
06-29-2017 10:57 PM
Highlighted
New Contributor II

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

Reply
0 Kudos
1 Solution

Accepted Solutions
Highlighted
New Contributor II

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

View solution in original post

1 Reply
Highlighted
New Contributor II

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

View solution in original post