log flys-backend/doc/schema/postgresql-spatial.sql @ 5765:34882dc70543

age author description
2013-04-17 Tom Gottfried Schema change: allow SECTIE and STROVOER (alias SOBEK) to be NULL, rename kinds
2013-04-09 Tom Gottfried Schema change: Allow longer strings in fixpoints.hpgp
2013-03-28 Andre Heinecke Cosmetic scheme change. Qualify the unknown name of sectie and sobek
2013-03-28 Andre Heinecke Add not null and default for hydr_boundary classifiers
2013-03-28 Andre Heinecke Minor scheme change. Update kind names to their UI representation.
2013-03-25 Tom Gottfried SCHEMA CHANGE: add table for flood marks and missing DROPs for jetties
2013-03-25 Andre Heinecke Rename station to km to be in line with the rest
2013-03-22 Andre Heinecke Scheme change: Building table is extended and got a lookup table for kind
2013-03-21 Tom Gottfried re-added spatial indices for Oracle that work since importer forces correct dimensions
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

http://dive4elements.wald.intevation.org