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
Solved! Go to Solution.
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));
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));