Tuesday, 22 January 2019

arcgis desktop - Connecting to PostGIS database from ArcMap for display and query without ArcSDE?



How can I connect to a PostGIS database from ArcMap using ArcGIS Desktop 9.3 and later?


I would like to be able to perform spatially enabled queries and receive the results back (e.g. spatial and non-spatial joins, filtering etc.) rather than just dumping the contents of a table.


I don't want to use the ArcSDE spatial extensions, I want to use the PostGIS spatial extensions in ArcGIS Desktop.



Answer



If you are using ArcGIS 10.0 or later, then you can directly connect to the PostGIS Data using a Query Layer, there is more information on this available in the help of each version:




To use the PostGIS geometry type, the database administrator must install PostGIS on the PostgreSQL database cluster. PostGIS is a third-party, open source installation. Once installed, the database administrator can use the PostGIS template database to create a database containing the PostGIS geometry type, or configure an existing database to use the PostGIS geometry type.





  • 10.0 (this page may not view correctly in Chrome, so I have used IE to read)


No comments:

Post a Comment

arcpy - Changing output name when exporting data driven pages to JPG?

Is there a way to save the output JPG, changing the output file name to the page name, instead of page number? I mean changing the script fo...