Breaking News

geodatabases

Usare PostGIS con QGis: connessione a PostGIS remoto (OSGEO)

Usare PostGIS con QGis: connessione a PostGIS remoto (OSGEO)

OSGEO ci mette in mano PostGIS “ready ti use” con dei dataset di esempio da usare con QGis. Ma tra le righe ci dice anche: ciao sono un server! Se ci sono 2 PC con OSGEO e attaccati alla stessa rete, possiamo collegarci uno al db dell’altro. Detto questo se il PC non è in quella stanza, ma comunque collegato ...

Read More »

Multi-User Geodatabase – Non-Versioned Archiving

Multi-User Geodatabase (IG) – 03 – Non-Versioned Archiving

We talk about archiving, how to enable it on your enterprise geodatabase. How to hit an archived geodatabase and edit it from ArcObjects using the IMultiUserWorkspaceEdit interface. We ran into a small permission problem at the end that I want a solve in a separate mini episode. We did the workaround by connecting as the table owner (SDE).

Read More »

Multi-User Geodatabase – Non-Versioned Geodatabase

Multi-User Geodatabase (IG) – 02 – Non-Versioned Geodatabase

This episode, we will learn about the different types of multiuser geodatabases. Non-Versioned/No Archiving, Non-Versioned/with Archiving, Versioned/No Archiving, Versioned/With Archiving. We briefly discuss long transactions and migrate our Phonatech geodatabase from File to Non-Versioned. We then do necessary changes to our code to connect and consume the new geodatabase.

Read More »

How to perform a Buffer in PostGIS

BUFFER in Postgis ST_Buffer()

This video and associated code shows how to perform a Buffer in PostGIS. ALTER TABLE fiumi ADD COLUMN buffer GEOMETRY(MultiPolygon,3003,2); UPDATE fiumi SET buffer=ST_Multi(ST_Buffer(geom,100)); CREATE TABLE buffer_union AS SELECT ST_Union(buffer)::GEOMETRY(MultiPolygon,3003), ROUND((ST_Area(ST_Union(buffer))/1000)::numeric,2) FROM fiumi; ALTER TABLE fiumi DROP COLUMN buffer;

Read More »