Is there anything like MySQL workbench for PostGIS? Something that supports SQL output and geometry types would be nice.


I am trying to implement the Land Administration Domain Model and all I got are the specs ( UML diagrams). I need a tool that can create the models and output code that would create the tables. It needs to support geometry types as the LADM deals with parcels.


You could try GRASS or QGIS., open-source GIS applications. You might be able to get what you want from one of them.

EDIT: I see you're after a data modelling tool with support for spatial data types. I can't see any specific reference with basic google-fu. You may be stuck with building your database model using CREATE TABLE statements and then reverse engineering them into a modelling tool for documentation.

If you have Visio Professional, the database modelling feature of that has a passably good database reverse engineering feature that will work OK with anything that supports an ODBC driver.

Another option might be to get an extensible tool such as Sparx Enterprise Architect and frig the metamodel. However, this might be more work than building your database by hand.

  • Ah no. What I want are tools for designing spatial database schemas. – R.K. Mar 29 '12 at 10:29
  • 1
    @R.K. - you mean a data modelling tool that supports spatial data types? – ConcernedOfTunbridgeWells Mar 29 '12 at 10:33
  • Yup. Preferably one that supports Postgresql/PostGIS as I'll most probably be using that database. Sorry for the ambiguity. Revised the question. – R.K. Mar 29 '12 at 10:35
  • 2
    @R.K. Maybe one of the more upmarket ones like PowerDesigner might do that, but it's quite pricey. – ConcernedOfTunbridgeWells Mar 29 '12 at 10:37

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