GIS and Remote Sensing Tools, Tips and more ..

One of my client’s requirements was to create and open source geospatial DBMS to hold utilities and city shape files. As looking through the internet, I found PostGIS is an open source software program that adds support for geographic objects to the PostgreSQL object-relational database.  As project reference, I choose PostGIS in Action , as project accomplished successfully I realized  my judgment was excellent. PostGIS in Action is a very comprehensive introduction to PostGIS for developers of all levels of experience. Basically it is split into 3 parts: Part 1- Nice and slow startup with PostGIS. You can skip this section if you have prior knowledge about any kinds of spatial databases and geometry data types. Part 2- Put PostGIS in work. It contains technical details on proximity analysis, geocoding addresses, manipulating polygons and lines, and scaling and rotating geometries as well as efficient queries and how to tune your database and selectio...

In this section, I am showing the 3 basic steps to connect PostGIS database with a widely used open source desktop based gis, QGIS.  Step1: Install PostGIS with Spatial database support extension i.                     If PostgreSQL is already installed è Launch ‘Application stack builder’ from startup menu in windows 7. ii.                   Select the appropriate instance of PGSQL from dropdown list and Click NEXT. iii.                 Expand ‘Categories’ è Expand ‘Spatial Extensions’ è Select appropriate PostGIS version(1.5)  for the already installed PGSQL version(8.4). iv.                     Follow the instructions to inst...