by Regina Obe

This talk will showcase spatial feats you can do with PostGIS Special focus will be given to features new in PostGIS 2.2 and upcoming PostGIS 2.3.

What we will cover:

Geometry -

• Proximity analysis with improved KNN functionality introduced in PostGIS 2.2
• Geometry dicing for speedier performance in data grouping and proximity analysis,
• Geometry clustering

Geography - Proximity analysis using KNN (new in PostGIS 2.2) Raster - in-database raster coverage making Topology - geometry simplification that maintains connectedness of adjoining geometries Geocoding and Address Standardization - Basic examples using PostGIS Tiger Geocoder, and address standardizer (new in PostGIS 2.2.)

Brief coverage of what's coming in PostGIS 2.3 Discussion of speed improvements, generating random points