All Questions
Tagged with postgresql enterprise-geodatabase
92
questions
0
votes
1
answer
58
views
Get "not data owner" error when execute register with geodatabase even I connect with the owner user in ArcGIS Pro
I am using ArcGIS Pro and connecting to a PostgreSQL database. I have enabled the database as Enterprise Geodatabase and it automatically creates a user "sde" for my PostgreSQL database. ...
0
votes
0
answers
55
views
FME - Specify schema name in PostgreSQL database writer (ArcSDE)
I am attempting to transfer data from a file geodatabase into an enterprise geodatabase (PostgreSQL) using FME. By default, the writer copies it into either the "public" schema or the "...
1
vote
0
answers
191
views
Database trigger does not work with ArcGIS featureservice
I have set a database trigger on a featureclass in a (PostgreSQL) geodatabase that calculates one field. This works fine when editing in ArcMap or ArcGIS Pro, but when I insert a new record through a ...
0
votes
0
answers
85
views
PostgreSQL identity/generated columns do not work with Append to Esri Enterprise Geodatabase
I want to set a column as an integer primary key separate from what Esri maintains. This is so it can exist in non-spatial tables and the features retain the key as they exist across other tables.
The ...
2
votes
0
answers
44
views
Is there any PostGIS st_makevalid equivalent for use in Esri's sde.st_geometry?
I am inserting into an Enterprise Geodatabase (Postgres running sde.st_geometry).
I am encountering errors on inserts when a multipolygon has parts with a zero-area.
I know of Desktop's Repair ...
1
vote
0
answers
103
views
Enterprise geodatabase connection feature geometry invisible in ArcGIS Pro
I have a database connection made to my PostgreSQL enterprise geodatabase through ArcGIS Pro. I can not see the geometry of the layer through ArcGIS Pro.
I am connected to the database as a user other ...
0
votes
1
answer
38
views
Unable to Get Lat Lon from PostGIS point table
I am facing issue to get lat/lon from point table. I have two point table with different spatial reference and I am able to get lat/lon from nce_gis_table while I apply same query to another point ...
0
votes
1
answer
429
views
Joining tables with GROUP BY in ArcGIS Pro
I have a layer "Table1" and an attribute table "Table 2" both stored in a PostgreSQL enterprise geodatabase, these 2 data have one field in common for which the cardinality of the ...
1
vote
0
answers
253
views
Create db connection from ArcMap or ArcGIS Pro to a regular non-spatial PostgreSQL database
When I attempt to create a database connection via ArcMap or ArcGIS Pro to a pure tabular PostgreSQL database, I keep getting insufficient permissions error.
I know it is not a permissions issue.
Is ...
0
votes
0
answers
479
views
ora2pg SDO_Geometry to st_geometry
I am trying to migrate my database (Oracle) to postgres using ora2pg (v.23.1).
Unfortunately the script converts our SDO_Geometry datatype into
shape geometry(GEOMETRY,32632)
instead of
shape ...
1
vote
0
answers
42
views
Enable Archiving and Enable Editor Tracking on Oracle SDO
Are enable archiving and enable editor tracking allowed in Oracle database system (SDO)? Since I usually use PostgreSQL, I don't know the features supported by the Oracle database.
0
votes
2
answers
2k
views
Creating feature class on ArcSDE schema with different user
I have created an enterprise geodatabase using ArcCatalog 10.5 on a PostgreSQL database. I have a database admin user named administrator and another user named sde. The geodatabase admin is sde user.
...
1
vote
0
answers
173
views
Error 0x8004159D while loading data from PostGIS to ArcGIS Pro
I successfully connected to the PostgreSQL database, and I can see the tables/data. When I load one of the data (linestring data) it works well. But when I loaded the polygon data it prompted the ...
2
votes
1
answer
220
views
ArcGIS client user connection hanging when connecting to PostgreSQL geodatabase
ArcGIS Catalog and Pro are both hanging when I try to connect as a user that is a member of a role. I think it is related to the SDE schema permissions but I'm not sure.
I have an enterprise ...
1
vote
0
answers
64
views
Updating field from table used as source in network dataset
I have a Feature Dataset that contains a Network Dataset and a Feature Class (as a source of Network Dataset) in enterprise geodatabase (PostgreSQL). The Feature Dataset is versioned because we want ...