topic Re: Can I import a shapefile to Postgres database from ArcGIS Pro? in ArcGIS Pro Questions

Can I import a shapefile to Postgres database from ArcGIS Pro?

IreneAlberty — Wed, 18 Mar 2020 18:19:12 GMT

I want to import a shapefile to my PostGIS Database (Postgres) using ArcGIS Pro, as QGIS does with Database Manager.

Re: Can I import a shapefile to Postgres database from ArcGIS Pro?

George_Thompson — Wed, 18 Mar 2020 19:02:56 GMT

It is a geodatabase or just a DB?

What is the license level of ArcGIS Pro being used (Basic, Standard, Advanced)?

You should be able to add a new feature class to a Postgres DB from ArcGIS Pro.

Re: Can I import a shapefile to Postgres database from ArcGIS Pro?

BruceHarold — Wed, 18 Mar 2020 19:08:09 GMT

First add a spatial type:

https://pro.arcgis.com/en/pro-app/help/data/databases/overview-database-spatial-types.htm#ESRI_SECTION1_A53013704BF74AFA…

Add the ST_Geometry type to a PostgreSQL database—Help | Documentation

Re: Can I import a shapefile to Postgres database from ArcGIS Pro?

IreneAlberty — Wed, 18 Mar 2020 19:50:22 GMT

It's Postgres DB with a PostGIS Extension.

My license level of ArcGIS Pro is Basic.

I've tried to use the tool Feature Class to Geodatabase, with my Postgres DB connection but I got the error "000210 Cannot create output".

Which tool or process do you recommend?

Thanks!

Re: Can I import a shapefile to Postgres database from ArcGIS Pro?

IreneAlberty — Wed, 18 Mar 2020 19:52:56 GMT

My Postgres DB has already the PostGIS extension, is it enough?

thanks!

Re: Can I import a shapefile to Postgres database from ArcGIS Pro?

BruceHarold — Wed, 18 Mar 2020 20:10:40 GMT

Yes

Re: Can I import a shapefile to Postgres database from ArcGIS Pro?

BruceHarold — Wed, 18 Mar 2020 20:10:58 GMT

Please try Feature Class to Feature Class

Re: Can I import a shapefile to Postgres database from ArcGIS Pro?

IreneAlberty — Wed, 18 Mar 2020 20:37:57 GMT

I've tried Feature Class to Feature Class and got this error:

ERROR 000210: Cannot create output C:\Users\GIS_User2\Documents\ArcGIS\Projects\MyProject\psql-prcave-hub-dev.postgres.database.azure.com.sde\vieques

Failed to execute (FeatureClassToFeatureClass).

Re: Can I import a shapefile to Postgres database from ArcGIS Pro?

BruceHarold — Wed, 18 Mar 2020 20:43:23 GMT

I suspect the PostGIS spatial types are not enabled in your database, please see the PostGIS documentation referred to in our help:

PostGIS is a third-party, open source installation. To use the PostGIS geometry or geography type, install PostGIS on the PostgreSQL database cluster. Once installed, either use the PostGIS template database to create a database containing the PostGIS types, or configure an existing database to use the PostGIS types. See PostGIS documentation for information on the installation and configuration of PostGIS.

Re: Can I import a shapefile to Postgres database from ArcGIS Pro?

IreneAlberty — Wed, 18 Mar 2020 21:10:30 GMT

Thanks for your answer.

I've just checked the PostGIS installation and the geometry columns in my database: I have the installation and the spatial types (geometry).

Do you suspect anything else?

Thanks!

Re: Can I import a shapefile to Postgres database from ArcGIS Pro?

BruceHarold — Wed, 18 Mar 2020 21:12:16 GMT

Oh wait a minute, this is up on Azure? That may be different! I certainly haven't tried it.

Re: Can I import a shapefile to Postgres database from ArcGIS Pro?

IreneAlberty — Wed, 18 Mar 2020 21:15:41 GMT

Yes, it is on Azure. Why do you think it may be different?

Re: Can I import a shapefile to Postgres database from ArcGIS Pro?

BruceHarold — Wed, 18 Mar 2020 21:37:10 GMT

Fear of the unknown ;-). It may have a different transport technology for one thing. Basically, the PostGIS spatial types should work when creating simple features without requiring geodatabase functionality, including at the Basic license level. There are very few people in the office now, so to get to the bottom of it please open a support call.

Re: Can I import a shapefile to Postgres database from ArcGIS Pro?

BruceHarold — Wed, 01 Apr 2020 21:02:17 GMT

Irene

I am corrected by a colleague that Pro Basic cannot create datasets in a database:

https://pro.arcgis.com/en/pro-app/help/data/databases/create-new-data-in-a-database.htm