nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

SQL RDBMS use with file geodatabases in ArcGIS Pro 3.x

NiColahh

Hello,

Can someone please tell me if PostgreSQL/PostGIS (or any SQL RDMS) can be used on file geodatabases (rather than on SDE databases) with ArcGIS Pro 3.x? I just started a new position and have an ArcGIS Professional Basic license, which doesn't include use of SDE. I'd like to work with my GIS data in a RDMS but have never tried with file geodatabases before.

Thanks,

Nicole

Najděte více příspěvků označených jako

Databases

File geodatabase

Data Design

Accepted answers

VinceAngelo

You can actually load the data without an enterprise geodatabase license, but the Basic license seat makes the process much more difficult (i.e., generate SQL on the fly to execute in the database through a cursor). However, you cannot use geodatabase relationships in PostgreSQL via ArcGIS without an EGDB.

Note that there are no longer any "SDE databases". The RDBMS has managed the data directly since SDE 3.0, and the SDE API was subsumed into enterprise geodatabase methods in ArcObjects (and ArcPy) long ago (and deprecated at 10.2.2, and removed at 10.3).

- V

All comments

MMBR

File Geodatabases are not Enterprise Geodatabases and do not support all the functionality that is only available with Enterprise Geodatabases using RDBMS supported software with ArcGIS.

We setup the Enterprise Geodatabase ArcSDE Repository in a supported RDBMS software like Oracle, SQL Server and PostgreSQL.

Then you can copy your data from the File Geodatabase to the Enterprise Geodatabase.

In order to create Enterprise Geodatabases, you need to have an ArcGIS Server License, even if you do not plan to use ArcGIS Server, the license file has the authorization key to be able to create the Enterprise Geodatabase ArcSDE Repository in a supported RDBMS.

You can use PostgreSQL Enterprise ArcSDE Geodatabase with the Esri ST_GEOMETRY Spatial Type or with the PostGIS Spatial Type to store the data.

ArcGIS 11.2 and ArcGIS Pro 3.2 requirements for PostgreSQL—ArcGIS Enterprise | Documentation for ArcGIS Enterprise

FAQ: What PostgreSQL Database Versions Are Supported by ArcGIS Enterprise and ArcGIS Pro? (esri.com)

I hope this clarifies your question.

For best practices on how to setup the Enterprise PostgreSQL Geodatabase visit my community.esri.com blog below and look for the database guide books and database template scripts for Production Mapping.

Mapping and Charting Solutions (MCS) Enterprise Da... - Esri Community

NiColahh

Thanks for your reply. I do not need all of the functionality of an enterprise geodatabase. We will eventually want to do that in the future, but not right now. Our current licensing doesn't cover SDE yet either. Is it possible to work with file geodatabases in a RDBMS (e.g. PostgreSQL, SQL Server Express, etc.), even if there is limited functionality? No need for version control right now, just table relationships, views, SQL and spatial SQL queries, etc.

MMBR

No, you cannot use File Geodatabase in RDBMS. Those are 2 things that are completely different. You need the ArcSDE license in order to create the Enterprise Geodatabase ArcSDE Repository in a supported RDBMS for ArcGIS, and then load the data from the File Geodatabase into the Enterprise ArcSDE Geodatabase.

George_Thompson

No, a file geodatabase is a not based on any RDBMS and cannot be added into any RDBMS as it is a file based construct that Esri clients can use. I would recommend reviewing this doc for more details: https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/overview/types-of-geodatabases.htm

NiColahh

To clarify, I do not necessarily need to keep the data in the file geodatabase, but I would like to be able to import the file geodatabase into PostgreSQL/PostGIS so that I can then create relationships and query the data in the RDBMS. I've done this before in the past but it's been about 6 years and I'm not sure if anything has changed.

MMBR

@NiColahh - if you want to load the File Geodatabase data into a PostgreSQL PostGIS database without having to use an Enterprise ArcSDE Geodatabase Repository then you will need to use a tool like FME Workbench from Safe Software to be able to load the data, then you can use ArcGIS Pro Query Layers to access the data.

Viewing and Inspecting PostGIS Data – FME Support Center (safe.com)

PostGIS Reader/Writer (safe.com)

VinceAngelo

- V

NiColahh

Thank you, I thought it should be possible, but I know things are always changing. Can you please clarify a little more how loading the data into a RDBMS with a basic license is more difficult?

George_Thompson

Look at this link: https://desktop.arcgis.com/en/arcmap/latest/manage-data/geodatabases/geodatabase-functionality-basic.htm

Pro version (not as robust): https://pro.arcgis.com/en/pro-app/latest/get-started/license-levels.htm

https://pro.arcgis.com/en/pro-app/latest/help/data/databases/databases-and-arcgis.htm

VinceAngelo

It was right there:

(i.e., generate SQL on the fly to execute in the database through a cursor)

I also wrote "much more difficult". If you haven't spent the past six months generating `psql` INSERT statements in a Python DA SearchCursor query, it's still "possible", just a heck of a lot of work. Way more work than dragging and dropping a FGDB feature class into a connection file with a Standard or Advanced seat license (against a properly prepared PG database with a lower-case schema that matches the login and has the correct permissions).

- V

Připojte se ke konverzaci

Přihlášení členové mohou přispívat, sledovat aktualizace a další. Jste tu noví? Zaregistrujte si bezplatný účet.

Rychlé odkazy

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.