Breaking News

geodatabases

COME Importare raster in Postgis raster2pgsql

COME Importare raster in Postgis raster2pgsql

ECCO lo scripit (tra ” i dati che dovete aggiungere voi) raster2pgsql.exe -s 3003 -C -M -I ‘DIRECTORY IN CUI SI TROVA IL VOSTRO RASTER’ ‘NOME DA ASSEGNARE AL RASTER IMPORTATO(facoltativo)’ | psql -d ‘NOME DATABASE’ -U ‘NOME UTENTE’ -h ‘INDIRIZZO IP’ -p ?PORTA’ nel mio caso : raster2pgsql.exe -s 3003 -C -M -I C:\Users\emili\Desktop\postgis\Dati\Dati\dtm_nord.tif dato1 | psql -d valdera ...

Read More »

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 »