GRASS-QGIS-PostGIS-PostgreSQL

1) Installing&Setting

1.1 Cygwin & GRASS 6.2.3
1.2 FWTools1.3.4
1.3 AVCE00-2.0.0-WIN32
1.4 PostgreSQL-8.2.6 including PostGIS
1.5 Quantum GIS 0.9.1
1.6 ODBC setting
1.7 Expat 2.0.1 (Option)
1.8 Setting New User and Database for PostgreSQL-8.2.6

2) Creating Vector Layers
2.1 Creation of tables of PostgreSQLwith geometry column for PostGIS
2.2 Adding columns to tables of PostgreSQL through PostGIS connection from QGIS

3) Input Data to Vector Layers
3.1 Preparation for Data Editing
3.2 Editing Data
3.3 Editing Geometry

4) Importing/Exporting Vector Layer
4.1 Convert Map Info Tab to Shape file using FWTOOLS
4.2 Import Shape file into PostgreSQL using SPIT Plugin of QGIS and Export PostgreSQL table to a shape file
4.3 Import Shape file into QGIS
4.4 Load table of PostgreSQL created by the imported Shape file on QGIS
4.5 Convert Map Info Tab, ArcInfo Coverage or other vector formats to Shape file
4.6 Import PostGIS layer to GRASS and export GRASS vector map to PostGIS
4.7 Retrieve table of PostgreSQL to Excel using ODBC and PostgreSQL command
4.8 Import Excel worksheet to PostgreSQL

5) Extract Coordinates

6) Attribute Action to Vector Layer

7) Attribute Values of Raster to POINT
7.1 Transform Raster layer to Vector layer (POLYGON) using GRASS.
7.2 Export the transformed Vector layer (POLYGON) to PostgreSQL and POINT data to which the attributes values will be allocated.
7.3 Add column to POINT data to store the attributes values.
7.4 Store the attributes values into the added column using PostGIS function.

8) Import CSV file and add Geometry
8.1 Make a table of PostgreSQL for a POINT data layer
8.2 Add columns using QGIS
8.3 Export CSV file from Excel worksheet
8.4 Import CSV file to PostgreSQL 
8.5 Add geometry using georeferencing information in the same table

9) How to organize files and directories

A1) Make BaseMap 2009

A2) Supported Data formats

E1) Example-1: Kathmandu Valley