log flys-backend/doc/schema/postgresql-spatial.sql @ 5342:7b119fa1e29f

age author description
2013-03-14 Tom Gottfried removed unique constraint to allow one dem to be used by several rivers
2013-03-14 Tom Gottfried fixed spatial schema for hydraulic boundaries
2013-03-14 Tom Gottfried merge
2013-03-14 Tom Gottfried added tables for jetties in spatial schema
2013-03-14 Felix Wolfsteller postgresql-spatial.sql: Fixed table definition.
2013-03-13 Tom Gottfried SCHEMA CHANGE: lookup table for floodmaps and source-field added, Importer adapted to new directory names
2013-03-11 Tom Gottfried add lookup tables for floodplain and cross section tracks
2013-03-08 Andre Heinecke SCHEME CHANGE: dgm now uses time intervals and ranges
2013-03-07 Andre Heinecke SCHEME CHANGE: Hydr.Boundaries are now three dimensional multilinestrings
2013-03-01 Tom Gottfried added missing constraints in schema (mostly for Oracle)
2013-02-28 Andre Heinecke Add kind_id to river_axes table and add AxisKind object to model
2013-02-28 Andre Heinecke River Axes and HWS_lines are now multiline
2013-02-27 Tom Gottfried sensible constraints for dem-table dami
2013-02-20 Andre Heinecke SCHEMA Change: Make hws_lines a 3d geom dami
2013-02-19 Tom Gottfried SCHEMA CHANGE: removed catchements from schema and geo-importer (obsolete) dami
2013-02-19 Andre Heinecke SCHEMA Remove geom_target and geom_rated_level from hws_lines table dami
2013-02-19 Tom Gottfried SCHEMA CHANGE: removed obsolete table 'lines' from spatial schema (now 'hws_lines') dami
2013-02-19 Tom Gottfried Corrected typo in field name dami
2013-02-15 Andre Heinecke SCHEMA_CHANGE: Add lookup tables for sectie / sobek and boundary_kind dami
2013-02-14 Tom Gottfried SCHEMA CHANGE: added column dem.srid dami
2013-02-14 Tom Gottfried SCHEMA CHANGE: added 'ON DELETE CASCADE' where necessary to delete complete rivers (only in Postgres-Schema so far) dami
2013-02-01 Andre Heinecke SCHEMA CHANGE: extended hydr_boundaries tables dami
2013-01-28 Andre Heinecke SCHEMA Change (psql only) use FLOAT8 for real numbers dami
2013-01-28 Andre Heinecke SCHEMA CHANGES: Add tables for Hochwasserschutzanlagen dami
2012-09-28 Ingo Weinzierl Adapted the spatial schema for DEMs and the DgmSqlConverter.
2012-09-27 Ingo Weinzierl Modified the schema for DGMs; added converter for CSV to SQL for DGM information.
2012-09-24 Ingo Weinzierl Adapted postgresql spatial schema and fixed a bug in the geo importer.
2012-09-24 Ingo Weinzierl Adapted PostgreSQL spatial schema.
2012-03-07 Ingo Weinzierl Adapted the PostgreSQL schema for floodmaps.
2012-03-06 Ingo Weinzierl Improved the db schema for storing existing floodmaps.

http://dive4elements.wald.intevation.org