PostGIS adds support for generating GeoJSON objects directly from database records with ST_AsGeoJSON.
Guide to building up a tile server and map client from scratch with PostGIS and PostgreSQL.
How do you handle PostGIS and PostgreSQL updates? This guide provides step-by-step instructions for safely upgrading your PostGIS installations to the latest versions using the packages provided by the community.
Many location aware applications need to find things are people that are close to a specific location. The KNN-GiST functionality of PostgreSQL helps developers to create high performance queries to quickly find neighbors, with applications in mapping and proximity searches.
Introduction to Spatial Analytics with PostgreSQL, PostGIS, PL/R and R Programming Language. Example use of R Analytic functions in PostgreSQL and PostGIS.
Introduction to Spatial Analytics with PostgreSQL, PostGIS, PL/R and R Programming Language. Demonstration of preprocessing of Geospatial data using PostGIS.
Introduction to Spatial Analytics with PostgreSQL, PostGIS, PL/R and R. First in series of posts introduces PL/R and provides background for sample analysis.