Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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


CLARIFICATION:

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.

share|improve this question
add comment

1 Answer

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.

share|improve this answer
    
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
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.