log flys-backend/doc/schema/postgresql-spatial.sql @ 5510:d4bee6d5c866

age author description
Thu, 28 Mar 2013 12:38:06 +0100 Andre Heinecke Minor scheme change. Update kind names to their UI representation.
Mon, 25 Mar 2013 17:51:33 +0100 Tom Gottfried SCHEMA CHANGE: add table for flood marks and missing DROPs for jetties
Mon, 25 Mar 2013 10:12:42 +0100 Andre Heinecke Rename station to km to be in line with the rest
Fri, 22 Mar 2013 17:30:10 +0100 Andre Heinecke Scheme change: Building table is extended and got a lookup table for kind
Thu, 21 Mar 2013 17:37:41 +0100 Tom Gottfried re-added spatial indices for Oracle that work since importer forces correct dimensions
Thu, 14 Mar 2013 18:04:36 +0100 Tom Gottfried removed unique constraint to allow one dem to be used by several rivers
Thu, 14 Mar 2013 15:32:50 +0100 Tom Gottfried fixed spatial schema for hydraulic boundaries
Thu, 14 Mar 2013 12:30:22 +0100 Tom Gottfried merge
Thu, 14 Mar 2013 12:16:58 +0100 Tom Gottfried added tables for jetties in spatial schema
Thu, 14 Mar 2013 12:24:29 +0100 Felix Wolfsteller postgresql-spatial.sql: Fixed table definition.
Wed, 13 Mar 2013 18:39:28 +0100 Tom Gottfried SCHEMA CHANGE: lookup table for floodmaps and source-field added, Importer adapted to new directory names
Mon, 11 Mar 2013 11:43:44 +0100 Tom Gottfried add lookup tables for floodplain and cross section tracks
Fri, 08 Mar 2013 18:15:48 +0100 Andre Heinecke SCHEME CHANGE: dgm now uses time intervals and ranges
Thu, 07 Mar 2013 10:53:44 +0100 Andre Heinecke SCHEME CHANGE: Hydr.Boundaries are now three dimensional multilinestrings
Fri, 01 Mar 2013 13:28:45 +0100 Tom Gottfried added missing constraints in schema (mostly for Oracle)
Thu, 28 Feb 2013 18:04:19 +0100 Andre Heinecke Add kind_id to river_axes table and add AxisKind object to model
Thu, 28 Feb 2013 12:58:25 +0100 Andre Heinecke River Axes and HWS_lines are now multiline
Wed, 27 Feb 2013 19:44:08 +0100 Tom Gottfried sensible constraints for dem-table dami
Wed, 20 Feb 2013 10:43:00 +0100 Andre Heinecke SCHEMA Change: Make hws_lines a 3d geom dami
Tue, 19 Feb 2013 19:24:36 +0100 Tom Gottfried SCHEMA CHANGE: removed catchements from schema and geo-importer (obsolete) dami
Tue, 19 Feb 2013 14:57:13 +0100 Andre Heinecke SCHEMA Remove geom_target and geom_rated_level from hws_lines table dami
Tue, 19 Feb 2013 09:57:57 +0100 Tom Gottfried SCHEMA CHANGE: removed obsolete table 'lines' from spatial schema (now 'hws_lines') dami
Tue, 19 Feb 2013 09:44:38 +0100 Tom Gottfried Corrected typo in field name dami
Fri, 15 Feb 2013 12:38:25 +0100 Andre Heinecke SCHEMA_CHANGE: Add lookup tables for sectie / sobek and boundary_kind dami
Thu, 14 Feb 2013 17:38:34 +0100 Tom Gottfried SCHEMA CHANGE: added column dem.srid dami
Thu, 14 Feb 2013 17:36:10 +0100 Tom Gottfried SCHEMA CHANGE: added 'ON DELETE CASCADE' where necessary to delete complete rivers (only in Postgres-Schema so far) dami
Fri, 01 Feb 2013 10:41:12 +0100 Andre Heinecke SCHEMA CHANGE: extended hydr_boundaries tables dami
Mon, 28 Jan 2013 18:24:01 +0100 Andre Heinecke SCHEMA Change (psql only) use FLOAT8 for real numbers dami
Mon, 28 Jan 2013 17:42:18 +0100 Andre Heinecke SCHEMA CHANGES: Add tables for Hochwasserschutzanlagen dami
Fri, 28 Sep 2012 08:37:08 +0000 Ingo Weinzierl Adapted the spatial schema for DEMs and the DgmSqlConverter.

http://dive4elements.wald.intevation.org