Does anyone knows if there is a CASE Tool that would be possible for modelling spatial tables? I need to create a model and export it to SQL or a database directly. I´m using PostGIS.
Thanks in advance.
For the moment, there are some problems with type for generated sql.
After not especially for gis database but PostgreSQL in general, see
The first use JDBC, so it keeps PK (Primary Key) and FK (Foreign Key) when reverse engineering, the second use ODBC, so it only retrieves tables structures but no PK or FK. The last one is one of the recent tools and lack reverse engineering (ability to generate visual schema from tables structures)
The 3 previous tools can create database from the schema you create or generate from a pre-existing database, the schema (the second process is usually call reverse engineering)
If your looking for others database case tools, a good list can be found on the LASIG EPFL website http://lasig2.epfl.ch/services/case/case.html (sorry, in french)
Both have support for spatial data types.
Extract data from:
What is GeoKettle :
i hope it helps you...