pixelcooker

Database View is one cool things about database management in DBMS. Using database view, you can deliver so many options of data publishing without messing up your database and messing up your tables structure. Database View is a common features that almost every database platform could have that features, includes here is spatial database (PostGIS, Oracle Spatial, or Enterprise Geodatabase).  If we talks about database view in Enterprise Geodatabase, it has all the features of enterprise geodatabase feature class. Database view in Enterprise Geodatabase is also directly linked with its parent tables. So any modification or updating in parent tables will also reflected in the database view. The database view itself is read only and only support reading/view.  Database View as I already told actually is one of the DBMS features regardless what kind of DBMS are used. If we see it in Enterprise Geodatabase Point of View, Database View when it is just created or imported, is not c...

 After few days crawling the GIS Stackexchange and many hours of reading ESRI ArcGIS Help Documents, finally I can manage to integrate ArcSDE Enterprise Geodatabase and PostGIS to be working together on a single PostgreSQL database. This configuration will enables you to use most of the cool features of Enterprise Geodatabase as well as PostGIS. For example, I can do Multiuser Editing Sessions using ArcGIS and QGIS at same time, I can enable Editor Tracking feature from Enterprise Geodatabase, perform versioning or archiving, but I also can connect my geospatial data to BI software like Tableau in Live Settings (not extracted). The latter is very important for me because up until this article writing, Tableau has not supported Enterprise Geodatabase Connection thru database connection. They only provide it thru API Services Connection (OGC WFS or ArcGIS Map Services).  Here are the steps that I compiled after many hours of trial and errors 1. copy st_geometry from.dll C:\Progr...