Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

I am documentating my stuff and not sure what is the right way to write this,

"I have installed Postgres and added the shapefile to the Postgres database. This database is then PostGIS enabled" or "spatially enabled".

What is confusing me is that when to use Postgres and when to use PostGIS? Is the Postgres database and PostGIS database the same? Or is it that the database is Postgres and the table is PostGIS?

What are the correct wordings?

share|improve this question
add comment

2 Answers

up vote 5 down vote accepted

The ontology you're looking for goes something like this:

Postgres - (Abbreviation of PostgreSQL) The type of your database (as opposed to MySQL, SQLite, Oracle or whatever).

  • PostGIS - An Extension to PostgreSQL to enable geospatial data storage and querying capabilities. Once this is installed, you might say that the database is "spatially enabled."

This becomes confusing as most users of PostGIS will use the term PostGIS to refer to the database itself (saying "Postgres with PostGIS" is a little cumbersome). So, in answer to your question, I would say something like this:

"I have installed a PostgreSQL Database and the PostGIS extension, and loaded the shapefile into the database."

That said, I would be certain that this is what you actually did. If you don't have PostGIS and you load a shapefile into the database (or you do load it into a PostGIS-enabled database, but do so incorrectly), what's actually in your database could be just about anything.

share|improve this answer
add comment

PostGIS is an extension of the PostgreSQL database, you can't have PostGIS without PostgreSQL. PostGIS is a robust extension, it defines new datatypes, and provides hundreds of functions so that you can make use of your spatial data.

When referring to the specific database you can say it is PostGIS enabled, or if your audience knows your talking about Postgres specifically you can say is is spatially enabled. Other RDBMs have spatial extensions as well, Oracle, MSSQL Server, SQLite, and MySQL all have various spatial capabilities.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.