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.
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)
Extract data from:
Spatial database types: PostGIS, Oracle spatial, MySQL, Microsoft SQL Server 2008*, Ingres* and IBM DB2* SOLAP (Spatial OLAP) system: GeoMondrian Geo files (data formats): Shapefile, GML, KML, OGR OGC Web services: Sensor Observation Service (SOS), Catalogue Web Service (CSW)
What is GeoKettle :
GeoKettle is a powerful, metadata-driven Spatial ETL tool dedicated to the integration of different spatial data sources for building and updating geospatial data warehouses. GeoKettle enables the Extraction of data from data sources, the Transformation of data in order to correct errors, make some data cleansing, change the data structure, make them compliant to defined standards, and the Loading of transformed data into a target DataBase Management System (DBMS) in OLTP or OLAP/SOLAP mode, GIS file or Geospatial Web Service.
GeoKettle is a spatially-enabled version of the generic ETL tool Kettle (Pentaho Data Integration). GeoKettle also benefits from Geospatial capabilities from mature, robust and well know Open Source libraries like JTS, GeoTools, deegree, OGR and, via a plugin, Sextante.
i hope it helps you...