Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Database for PostGIS 2.0 or higher must be established
  2. Select the SOSI/Inspire UML model (acc. ISO 19109) one will establish a database for (the database itself must be created in advance with PostGIS 2.0 template and the extension uuid-ossp if uuid is chosen as datatype for primary key)
  3. Select Extensions -> GISTools for UML -> PostGIS -> Create Database ...
  4. Fill in the dialog with link to database and enter new database schema. One can choose to use SOSI names or UML/GML names in the database.
  5. Press Generate and the database is established (schemafile/script will be placed in a directory “postgis” at the same location as the EA (.eap) project file)
  6. If one chooses to validate the model, the "System Output" window will list all the rules/tests that run and any errors and warnings that are relevant to the PostGIS creation will be listed. See the list of validation rules with tests that are being run.
  7. Test the database with, for example, QGIS
  8. Set up mappings to GML or SOSI Syntax with Deegree mapping, FME mapping or Geoserver mapping.



 

Mapping rules

Tables

Classes (which are not abstract) with stereotype featuretype, type or none will become separate tables. In addition, datatypes which are a part of one-many or many-many relationships will also become a table (i.e. they will not be flattened). Inheritance is resolved by adding all inherited elements to subtypes. Classes must be in the same package under applicationSchema.

...