as a cartographer I work with TileMill to visualize geodata. I installed a local PostgreSQL server with PostGIS and osm2pgsql. Everything works fine.

Anyhow, I am new to working with servers and the command line approach. So, in learning the basics of database management, some GUI tool would be of great help. Could I for example safely run the PgAdmin app next to the PostgrSQL installation (http://postgresapp.com/) on my Mac OS X Mavericks?

Any suggestions most welcome.

  • 5
    yes you can use pgadmin and postgres simultaneously. – neogeomat Nov 20 '13 at 10:44
  • Use pgadmin. On many platforms (eg windows) it is even part of the default postgresql install. – johanvdw Nov 20 '13 at 11:14
  • On the Mac it's just a little app to get the server running. And it provides a link to the command line. – jm60 Nov 20 '13 at 11:19
  • 1
    I got pgAdmin running now alongside Postgres. It is a good couple: learning the database structure thru the GUI and practising the commands in the Terminal. – jm60 Nov 20 '13 at 20:09

A great solution is to use QGIS as a GUI for PostGIS.

QGIS is a fully-functional GIS (I prefer to think of it actually as a meta-GIS given that it is built on many GIS packages). It has built-in support to connect to PostGIS and therefore gives you all the tools needed to view, edit and create maps from your data.

  • 1
    I work with QGIS but I was not aware of the PostGIS functions. Thanks for the advice & have a good day. – jm60 Nov 20 '13 at 11:03

OrbisGIS 5.0 is an open source GUI tool specialized at database view/processing. The built-in SQL console editor have syntax highlighting, code completion and sql functions search engine.

In the geocatalog using drag&drop you can transfer shape files to the database.

The table editor has been specifically designed for viewing/editing large database tables.

When choosing for a project workspace folder you can select the default embedded spatial database H2GIS (close to PostGIS) or select a remote PostGIS database to work with.

For the visualization/rendering purpose, the software use the new standard Symbology encoding 2.0 . A plug-in named map-composer is a print composer (image or vectorized pdf) for user-defined layout.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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