How to Store Spatial Data or Shape Files into RDBMS(PostgreSQL/POSTGIS)

What is Spatial data?

 
Spatial data is  Also known as Spatial data or geographic information it is the data or information that identifies the geographic location of features and boundaries on Earth, such as natural or constructed features, oceans, and more. Spatial data is usually stored as coordinates and topology, and those are representing as  Point, Line, Polygon, and Raster. Spatial data is often accessed, manipulated, or analyzed using Technology called GIS(Geographic Information Systems )
 

Where Spatial data will store?

 
The Spatial data is commonly storing in different file formats, which we call "Geo-database".
 

What is Shape file?

 
The shape file is coined by ESRI(Environmental System Research Institute).The shape file stores individual data type(Polygon or line or Point). The shape file is a combination of different files (that is from 4 to 5 files combination)
  1. .shp
  2. .shx
  3. .dbf
  4. .xml
  5. .prj

Why Spatial data should store in RDBMS?

 
The shape files are a combination of files, if one file is missed, the shape file will not work. Those are just static files, these files suppose to store in a local disc, single-user access, and the file sometimes can be corrupted or misplaced. So that the data will be lost. The data should store in the database.
 

How to store shape file into the database(RDBMS)?

 
There are different steps involved ... that is 
  1. Install PostrgreSQL (Open source) 
     
    Referred url is
     
    http://pginstaller.projects.postgresql.org/
     
    or
     
    http://askoh.net/misc/visualworks/installPostgreSQL/
     
  2. Install PostGIS 
     
    http://www.gpsfiledepot.com/tutorials/installing-and-setting-up-postgresql-with-postgis/
     
  3. Set Environment variables for shp2pgsql.exe
     
    MyComputer --> Properties --> Advanced --> select Environment Variables 
     
    1.gif
     
    Set Path variable as an above screen.

Convert Shape file to PostgreSQL/POSTGIS

 
2.gif
 

Run SQL Converted SQL file

 
3.gif
  
Run the above  Query 
 
Result of the converted table below screen:- 
 
4.gif
 
We can see the geometry column added in the table on the above screen.