geodatabases

POSTGIS query SQL Calcolo area con funzione ST_Area()

POSTGIS query SQL Calcolo area con funzione ST_Area()

POSTGIS query SQL Calcolo area con funzione ST_Area() SELECT id, provincia, ST_Area(geom)/10000 AS hectares FROM province ORDER BY provincia; SELECT provincia, ROUND(SUM(ST_Area(geom)/1000000)::numeric,0) AS km2 FROM province GROUP BY provincia; SELECT id, provincia, ST_Area(geom)/10000 AS hectares FROM province WHERE provincia=’LI’;

Read More »

Multi-User Geodatabase – Getting Started

Multi-User Geodatabase (IG) – 01 – Getting Started

This will be a series where we discuss Multi-User geodatabase (Enterprise SDE). We will talk about versioning, archiving and more geodatabase concepts and We will write arcobject code to hit the enterprise geodatabase. Same as our old vidoes, this is a By Example approach, We migrate out our Phonatech customer from a file geodatabase to an enterprise geodatabse and upgrade ...

Read More »

POSTGRESQL Creare un vettore puntuale Postgis dal DBmanager

POSTGRESQL Creare un vettore puntuale Postgis dal DBmanager

CREATE TABLE points (id INTEGER, name TEXT); — crea la tabella points com campi id e name ALTER TABLE points ADD COLUMN pt GEOMETRY(Point,0,2); — aggiunge la geometry column sistema riferimento 0 dimensioni 2 INSERT INTO points (id, name, pt) VALUES (1,’Origin’, ST_GeomFromText(‘POINT(0 0)’,0)); INSERT INTO points (id, name, pt) VALUES (2,’First’, ST_GeomFromText(‘POINT(5 0)’,0)); INSERT INTO points (id, name, pt) ...

Read More »

Geodatabase Fundamentals

Geodatabase Fundamentals

This session will help you gain an understanding of the data storage format that Esri uses in the ArcGIS platform, namely the geodatabase, and discuss the benefits of using it in your teaching and research. We will discuss workflows that cover geodatabase creation, data and schema loading, and behaviour rules designed to enforce data integrity. While use cases for incorporating ...

Read More »

Working with a Multi-User Geodatabase

Working with a Multi-User Geodatabase

This video provides participants with an overview of working with multi-user geodatabases in the ArcGIS platform and discusses the benefits of using geodatabases in your teaching and research. We will discuss workflows that will help you create a geodatabase, add users and define privileges through roles, and introductory aspects of versioning and replication workflows. Slide deck: http://ift.tt/2fCAMEy

Read More »

Usare “group by” e “copy to CSV” con PostGIS

Usare “group by” e “copy to CSV” con PostGIS (GIS048)

In questo video tutorial vediamo come raggruppare le geometrie in base ad alcuni campi e successivamente esportarle in CSV per avere una tabella più facilmente gestibile. I comandi principalmente usati sono GROUP BY e COPY funzioni native di Postgres. Nel tutorial viene utilizzato QGis, ma in questo caso è solo per la visualizzazione dei dati. Infatti l’obiettivo è quello di ...

Read More »