topic Re: How to get geometry data from external database dynamically in ArcGIS Enterprise Questions

How to get geometry data from external database dynamically

EmrahAydemir — Fri, 28 Oct 2022 07:57:04 GMT

Hi, i have a PostgreSQL database. Hundreds of geometry data are added to this database daily, independent of Arcgis. There is a geometry column with Postgis feature. Is there a way to dynamically pass the data here to Arcgis Server? I want to display the data (inserted from NodeJS server) in Arcgis Server Map Server.

Note: i added PostgreSQL Database to Arcgis Server as a data store .

Re: How to get geometry data from external database dynamically

George_Thompson — Fri, 28 Oct 2022 11:18:32 GMT

I think that you would need to create a map / feature service to display that data. I believe that you would also need to publish this from ArcGIS Pro.

Do you have ArcGIS Pro to create a map that you want and then publish from there?

Re: How to get geometry data from external database dynamically

EmrahAydemir — Fri, 28 Oct 2022 11:23:07 GMT

Hello, with arcgis I can move data to arcgis server in few steps. But since hundreds of layers will be added per day, I will not be able to do this every time a layer is added. Isn't there a way to add a map server to Arcgis Server and connect it directly to the external database? Since I am using a Postgis database, I already have a geometry column. It is enough for me to just transfer the data in this table exactly.

Re: How to get geometry data from external database dynamically

George_Thompson — Fri, 28 Oct 2022 11:53:55 GMT

If I understand what you are saying, you would like a way to add all the new "layers" (spatial tables) that are added to the PostgreSQL DB, correct?

If so, I think that you still have to publish the data from ArcGIS Pro. I am not aware of a way to just take a new spatial table added to the DB to just be added to the server as a service without Pro. I would wait to see if any other users may have a way to do this.

Re: How to get geometry data from external database dynamically

EmrahAydemir — Fri, 28 Oct 2022 12:03:12 GMT

Yes that's true. I have a Postgis database with geometric data in it. I want to query these data directly over Map Server. I thought it might be possible via the Data-Store, but I guess I'm wrong. It's like connecting the database directly to the Map Server instead of connecting the database to Arcgis, transferring the layers, and then publishing it to the Map Server.

Re: How to get geometry data from external database dynamically

RamakrishnaBillakanti — Fri, 28 Oct 2022 12:10:11 GMT

Register your datastore in postgress with ArcGIS Server. If ArcGIS Server is not whitelisted on pg hba(or similar) conf file, whitelist it so postgress can accept connections from your ArcGIS Server Host Machine. You should be able to publish it and use it with a map service.

Re: How to get geometry data from external database dynamically

EmrahAydemir — Fri, 28 Oct 2022 12:18:14 GMT

I'm confused at this part. My Postgis database is on an external server. I added my database to the Data-Store. There is a green tick next to it. Does this mean I have successfully added (in terms of whitelisting)?

Re: How to get geometry data from external database dynamically

RamakrishnaBillakanti — Fri, 28 Oct 2022 12:22:30 GMT

Possibly your PG is configured as open to accept any connections. I think you are good to go now. Are you able to see the data when a map service is published.

Re: How to get geometry data from external database dynamically

EmrahAydemir — Fri, 28 Oct 2022 12:29:36 GMT

I don't know what to do next step. After adding the database how do I add it to a Map Server?

Re: How to get geometry data from external database dynamically

RamakrishnaBillakanti — Fri, 28 Oct 2022 12:35:27 GMT

You need to publish the layer/table using ArcMap or ArcGIS Pro depending on your ArcGIS Server Version. Once published you will be able to view the data through map service.

Publish a map service from ArcMap—ArcMap | Documentation (arcgis.com)

Re: How to get geometry data from external database dynamically

George_Thompson — Fri, 28 Oct 2022 12:50:51 GMT

Another potential option would be to bulk publish from that datastore connection; https://enterprise.arcgis.com/en/portal/latest/use/bulk-publish-arcgis-server-feature-layers.htm

Now you must know that this may take a while and could crash the server machine depending on how many layers. It will create a map service and feature service (read-only but can be updated) for every layer in the database. This is the only way I could think of doing it without Pro, but you would not have some of the finer details for publishing.

Re: How to get geometry data from external database dynamically

EmrahAydemir — Fri, 28 Oct 2022 13:07:27 GMT

Unfortunately it didn't work. The steps in the link you posted are the same as I normally do. But every time new data is added I need to republish it via arcmap. I can connect to the database via arcmap. I have added the database manually before. I don't know how to connect it directly to the map server

Re: How to get geometry data from external database dynamically

EmrahAydemir — Fri, 28 Oct 2022 21:00:49 GMT

Just as I was about to go to sleep, this came to my mind: I am adding data to postgis database via nodejs. Is there a way to add layers to Arcgis Server via nodejs instead of trying to connect database directly to Arcgis Server? In this way, while adding a layer to the postgis server, it will also be added to the Arcgis Server.

Re: How to get geometry data from external database dynamically

Scott_Tansley — Sat, 29 Oct 2022 23:27:23 GMT

Cross-referencing to your other discussion for the solution. https://community.esri.com/t5/arcgis-enterprise-questions/how-to-add-new-polygon-to-arcgis-server-from-node/m-p/1226850#M34461