Category: GIS

gis.stackexchange.com/questions/8409/postgis-feature-compare-function

 -- return the id and geometry from the updated table if the attributes -- or -- geometry have changed or it's a new feature.
select t2.id, t2.geom from t1, t2 where     ( t1.id = t2.id and row(t1.att1, t1.att2, t1.geom)       != row(t2.att1, t2.att2, t2.geom))     or     t2.id not in (select id from t1) 

smime.p7s

gis.stackexchange.com/questions/134066/how-to-find-if-polygon-has-a-hole-using-field-calculator-in-arcgis

gis.stackexchange.com/questions/8409/postgis-feature-compare-function

 -- return the id and geometry from the updated table if the attributes -- or -- geometry have changed or it's a new feature.
select t2.id, t2.geom from t1, t2 where    ( t1.id = t2.id and row(t1.att1, t1.att2, t1.geom)      != row(t2.att1, t2.att2, t2.geom))    or    t2.id not in (select id from t1) 

blogs.esri.com/esri/arcgis/2014/04/14/support-for-ogc-geopackages-in-arcgis/
geonet.esri.com/thread/120022
desktop.arcgis.com/de/arcmap/10.3/manage-data/databases/sqlite-and-arcgis.htm
www.gdal.org/drv_geopackage.html smime.p7s

geoportal.bayern.de/geodatenonline/seiten/wfs_gaz smime.p7s