Moskitt Geo is a new plugging 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. This plugging 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.

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 postGRE SQL support.

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

Do you want to know more about Moskitt? here.

Moskitt Geo installation needs 1.3.0 Moskitt version installed first. It can be founded on the download Moskitt site, the next step it is install the new update site following the instructions with the URL http://download.moskitt.org/moskitt/geo/updates.