MOSKitt Geo

MOSKitt Geo is a new pluggin that adds spatial support to the MOSKitt database design. It has been possible due the collaboration between the MOSKitt developer team and the geospatial solutions developer team at Prodevelop. This pluggin adds new special primitive data type, Geometry, that can be configured to set spatial data base restrictions.

Geometry Restrictions to the Spatial Data Base:

  • Defined Geometry Types: Unknown Geometry, Point, Line, Polygon, MultiPoint, MultiLine, MultiPolygon, Geometry Collection.
  • Coordinate Dimension: 2-Dimension, 3-Dimension, 4-Dimension.
  • EPSG based Reference System.
  • Spatial Indexes.
  • Coordinate Tolerance. Only Oracle.
  • Coordinate Bounds. Only Oracle.

Moskitt GEO

The main goal is to allow data base managers to generate data base schemas with geometry data. Starting their design from the UML class diagram, executing the new UML Class Diagram to Data Base Diagram Spatial Transformation, until launch the last Transformation depending on the final selected data base with spatial support, where the Database Schema become to a DDL (Data Description Language). This file contains the right SQL queries.

Nowadays MOSKitt GEO adds Oracle 10g Locator support and also PostGIS from PostgreSQL support.

One of the main advantages it is that the reverse engineering process increases the geospatial database support for Oracle 10g Locator and PostgreSQL, by supporting the new Geometry data type, auto detecting possible geometry constraints associated to each column.  

MOSKitt Geo installation needs 1.3.0 MOSKitt version installed first. It can be found on the download section of the MOSKitt site, the next step is to install the new update site following these instructions, with the URL http://download.moskitt.org/moskitt/geo/updates.