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,that we call as "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 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 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 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 database(RDBMS) ?

There are different steps involved ... that is 

1. Install PostrgreSQL (Open source) 
   
   Referred url are 
   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 
   
   
   
   Set Path variable as above screen.

Convert Shape file to PostgreSQL/POSTGIS :-

Run Sql Converted SQL file

  

Run the above  Query 

Result of the converted table below screen  :- 

We can see the geometry column added in the table in above screen.