PostgreSQL and PostGIS
PostgreSQL
PostgreSQL is a powerful, open source object-relational database system. It has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness. It runs on all major operating systems, including Linux, UNIX (AIX, BSD, HP-UX, SGI IRIX, Mac OS X, Solaris, Tru64), and Windows.
PostGIS
PostGIS adds support for geographic objects to the PostgreSQL object-relational database. In effect, PostGIS "spatially enables" the PostgreSQL server, allowing it to be used as a backend spatial database for geographic information systems (GIS), much like ESRI's SDE or Oracle's Spatial extension. PostGIS follows the OpenGIS "Simple Features Specification for SQL" and has been certified as compliant with the "Types and Functions" profile.
- Login to post comments
Application Documents | Description | Document ID | Posted by | Update | Rating |
---|---|---|---|---|---|
Convert Shapefiles to PostGIS Tables | There is a relatively simple command that comes with PostGIS that allows you to convert ESRI shapefiles into geometry-... | app2009-008 | Ryan Clark | 04/30/2010 - 2:01pm |