Tags » PostGIS

Using QGIS Cloud as a PostGIS database

This post will demonstrate how to deploy layers created in QGIS Desktop as PostGIS tables in QGIS Cloud. The GI Analyst can access spatial data on the cloud and download for use on desktop GIS. 300 more words

Science

Daily discoveries of a FOSS4G user: 2. PostGIS and its bag of tricks

As I mentioned in the previous post, there were couple handy PostGIS functions I found quite useful after importing prepped data via shp2pgsql tool. They involve working with Spatial Reference of geometries and working with Multi* geometries. 633 more words

PostgreSQL + PostGIS instalacja

W sieci można znaleźć wiele instrukcji istalacji darmowego bazodanowego oprogramowania PostgreSQL oraz jego geoinformacyjnego rozszerzenia PostGIS

poniższy wpis oparłem o instrukcje zawarte w tej książce… 146 more words

GIS

Postgis: Export tables as PNG, GeoTif

How to export postgis raster-based tables into a file in Linux.

Suppose that you have a raster file (originally in GeoTif and it’s loaded into postgis with the cannonic ‘raster2pgsql’. 374 more words

Postgis

Using PostGIS for Hydrologic Modeling (reblog)

The Problem We have to filter out the roads and ditches without removing streams that cross roads or follow them closely. I’m going to use PostGIS to find the intersection of the streams lines data with a buffered roads polygon.

22 more words
FOSS

Filtering Roads from Extracted Streams Data

The Problem

We have to filter out the roads and ditches without removing streams that cross roads or follow them closely. I’m going to use PostGIS to find the intersection of the streams lines data with a buffered roads polygon. 484 more words

Brook Trout

DBSCAN Clustering in PostGIS

The City of Montreal recently began posting some crime records on their open data portal.  For now, they’re only publishing data about break-ins, but it’s nonetheless a good occasion to play around with some of the new clustering features slated to be released in the next version of PostGIS. 772 more words

PostGIS