topic Oracle Enterprise GeoDatabase Question in ArcGIS Enterprise Questions

Oracle Enterprise GeoDatabase Question

DRae — Wed, 28 Feb 2024 15:24:56 GMT

Hi I am new to the geospatial analysis. In my environment, there is an Oracle Enterprise GeoDatabase setup for the GIS Server, and Portal. I want to learn how to do the spatial analysis with SQL, I want to know where I can get the document for function like ST_Geometry. Thanks

Re: Oracle Enterprise GeoDatabase Question

Bud — Wed, 28 Feb 2024 16:30:00 GMT

Did you try googling st_geometry function?

https://www.google.com/search?q=st_geometry+function

https://desktop.arcgis.com/en/arcmap/latest/manage-data/using-sql-with-gdbs/st-geometry.htm

Re: Oracle Enterprise GeoDatabase Question

MarceloMarques — Wed, 28 Feb 2024 16:29:35 GMT

SQL and enterprise geodatabases—ArcMap | Documentation (arcgis.com)

The ST_Geometry storage type—ArcMap | Documentation (arcgis.com)

SQL functions used with ST_Geometry—ArcMap | Documentation (arcgis.com)

List of SQL functions

Re: Oracle Enterprise GeoDatabase Question

DRae — Wed, 28 Feb 2024 19:50:27 GMT

Is it matter that I am using ArcGIS Pro instead of ArcMap for the ST_Geometry?

Re: Oracle Enterprise GeoDatabase Question

MarceloMarques — Wed, 28 Feb 2024 20:10:59 GMT

@DRae - If you plan to use SQL to access the spatial data stored in the Geodatabase with Esri ST_GEOMETRY Spatial Data Type, then the ArcGIS Client that you use to create or upgrade the ArcSDE Geodatabase Repository "does matter". Why? Because of bug fixes, enhancements, etc.

Note: ArcMap 10.8.x will retire, and customers need to switch to ArcGIS Pro.

ArcMap Life Cycle | Esri Support

The best practice is to keep the ArcGIS Client version and the ArcSDE Geodatabase Repository Version at the same ArcGIS Version to avoid issues.

Read the details in the link below.

Client and geodatabase compatibility—ArcGIS Pro | Documentation

Re: Oracle Enterprise GeoDatabase Question

Bud — Thu, 29 Feb 2024 03:09:42 GMT

I would argue that it doesn't matter. Esri hasn't made any changes to ST_GEOMETRY in years. So, I think the documentation applies to both ArcMap and ArcGIS Pro. And I would be surprised if you're using a version of either that is so old that it doesn't match the docs.

At any rate, here is the ST_GEOMETRY documentation for ArcGIS Pro. As far as I can tell, the content is the same as the ArcMap link.
ArcGIS Pro - Databases and ST_Geometry - See the PDF link at the bottom of that page: https://pro.arcgis.com/en/pro-app/3.0/help/data/databases/pdf/stgeometry_reference.pdf