Select to view content in your preferred language

ArcGIS Pro V 3.5.1 ST_Geometry version supported

325
7
Jump to solution
3 weeks ago
Labels (3)
RachelMba1
Emerging Contributor

Hello. I am working on installing PostgreSQL and successfully using it on my ArcGIS Pro. I am using ArcGIS Pro version 3.5.1, and I also downloaded the ArcGIS Pro ST_geometry Library (PostgreSQL). The challenge I am encountering is that I do not know the version of ST_Geometry supported by ArcGIS Pro 3.5.1. I will need this information so that I can copy that .dll file to my Postgres V 15.13 file. 

I will appreciate any clues to help. 

 

0 Kudos
3 Solutions

Accepted Solutions
DanPatterson
MVP Esteemed Contributor

Upgrade the ST_Geometry type in a PostgreSQL database—ArcGIS Pro | Documentation

says

Download a new version of the st_geometry library from My Esri.

I don't use it, so you will have to check


... sort of retired...

View solution in original post

George_Thompson
Esri Notable Contributor

Make sure you select the folder that says "15" then the OS of the PostgreSQL instance is installed on (Windows / Linux).

It is not needed if using RDS or similar instance in cloud

--- George T.

View solution in original post

syedinzamam
New Contributor

You're close! For ArcGIS Pro 3.5.1 with PostgreSQL 15.13, the supported ST_Geometry version is 5.0.0. You’ll find the .dll in the DatabaseSupport\PostgreSQL folder inside your ArcGIS Pro install directory — just match it to your Postgres version.

Also, I’ve shared some useful GIS resources (including free tools) here if you're interested:
https://cartogeek.com/free-gis-software/

Hope that helps!

View solution in original post

7 Replies
DanPatterson
MVP Esteemed Contributor

Upgrade the ST_Geometry type in a PostgreSQL database—ArcGIS Pro | Documentation

says

Download a new version of the st_geometry library from My Esri.

I don't use it, so you will have to check


... sort of retired...
George_Thompson
Esri Notable Contributor

Make sure you select the folder that says "15" then the OS of the PostgreSQL instance is installed on (Windows / Linux).

It is not needed if using RDS or similar instance in cloud

--- George T.
syedinzamam
New Contributor

You're close! For ArcGIS Pro 3.5.1 with PostgreSQL 15.13, the supported ST_Geometry version is 5.0.0. You’ll find the .dll in the DatabaseSupport\PostgreSQL folder inside your ArcGIS Pro install directory — just match it to your Postgres version.

Also, I’ve shared some useful GIS resources (including free tools) here if you're interested:
https://cartogeek.com/free-gis-software/

Hope that helps!

RachelMba1
Emerging Contributor

Thank you, everyone. Your clues were so helpful. I completed the installations and was able to create and connect the database in ArcGIS Pro; however, I was unable to create a feature class. I had copied the right PostGIS file and ensured it was installed and operational on Postgres. My question is this: Is it possible to use this database on ArcGIS Pro, being that it is not an Enterprise database?  

I have attached a screenshot of the error messages that appear everytime i try to create a feature class. Suggestions that will help me on this will be deeply appreciated. Thank you.

 

0 Kudos
George_Thompson
Esri Notable Contributor

If you have not enabled the "Enterprise Geodatabase", you do not need to use that GP tool. You can just copy / paste another FC into the database or you can right click the database connection and hit "New" --> "Feature Class" and create it that way.

Make sure that you have PostGIS enabled also.

--- George T.
0 Kudos
RachelMba1
Emerging Contributor

Thank you, @George_Thompson. I did enable PostGIS.  According to the study guide, I am required to create a database first. I want to do this in ArcGIS Pro, but I keep being pointed to creating an Enterprise database, and I do not want to go through that route. I was able to connect to a default database, but I still cannot create a feature class in it. I did the copy and paste of an existing FC, which you suggested, and the same error occured. So the key issue is that the schema called 'postgres' does not exist. the existing schema is 'public'. see screenshot below.

Screenshot (38).png

0 Kudos
George_Thompson
Esri Notable Contributor

Ok, so you create the PostgreSQL database (non-Enterprise GDB) outside of ArcGIS Pro. That can be done in pgadmin.

It looks like you are using the "template" database that is created with the PostGIS install.

You need to create a new database in PostgreSQL. There are MANY different ways to do this.

Here is how I do it in pgadmin: you must be logged in as the admin account (in my case is postgres)

1. Right Click the PostgreSQL instance name --> Create --> Database

2. provide a name and leave the owner as "postgres"

George_Thompson_0-1750847704409.png

On the "Definition" tab, you use the "postgis_35_sample" database as the template. You can also set a tablespace location, if desired.

George_Thompson_1-1750847777073.png

Then hit save.

3. In ArcGIS Pro, make a connection to that new DB and create a new FC, just call it test.

I usually create a database user, using the GP tool in Pro: https://pro.arcgis.com/en/pro-app/latest/tool-reference/data-management/create-database-user.htm, and have that user own the data.

Hope this helps clear up any confusion.

 

--- George T.
0 Kudos