PostgreSQL is undoubtedly one of the most popular RDBMS, and although we can enable a PostgreSQL DB as a geodatabase it is not always possible. Therefore, in this session, we will learn how, thanks to Koop, we can enable the data of a PostgreSQL DB as ArcGIS Feature Layers.
00:00 Introduction
00:27 What is Koop?
02:01 How koop-provider-postgre works
03:37 Repository and project setup
05:50 Debugging the provider locally
10:52 Changing the SQL statement
12:21 Running a ST_Intersects operation
13:08 Exploring the code of the UI app
20:51 Nested inner joins example
23:40 Conclusions and closing
#postgres #koop #devsummit
--------------------------------------------------------------------------------------------------------------------------
Follow us on Social Media!
12552
- Tags
-