This tutorial will teach the user how to use a delimited text file containing X,Y coordinate data and turn it into a shapefile for use with GIS software. A delimited text file is an attribute table with each column separated by a defined [ … ]
This advanced PostgreSQL/PostGIS tutorial will provide users with a set of two plpgsql functions: utmzone(geometry) and st_buffer_meters(geometry, double precision). These functions will be helpful for anyone trying to buffer latitude/longitude data using meters or kilometers. These functions have been designed to work with any projection, allowing users to buffer geometry objects using distances specified in meters for all areas of the globe.