log flys-backend/doc/schema/postgresql-spatial.sql @ 5530:7f8d6b49afad

age author description
Thu, 28 Mar 2013 15:56:24 +0100 Andre Heinecke Cosmetic scheme change. Qualify the unknown name of sectie and sobek
Thu, 28 Mar 2013 15:31:34 +0100 Andre Heinecke Add not null and default for hydr_boundary classifiers
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.
Thu, 27 Sep 2012 07:24:07 +0000 Ingo Weinzierl Modified the schema for DGMs; added converter for CSV to SQL for DGM information.
Mon, 24 Sep 2012 10:02:36 +0000 Ingo Weinzierl Adapted postgresql spatial schema and fixed a bug in the geo importer.
Mon, 24 Sep 2012 09:13:29 +0000 Ingo Weinzierl Adapted PostgreSQL spatial schema.
Wed, 07 Mar 2012 20:27:20 +0000 Ingo Weinzierl Adapted the PostgreSQL schema for floodmaps.
Tue, 06 Mar 2012 11:54:41 +0000 Ingo Weinzierl Improved the db schema for storing existing floodmaps.
Thu, 05 Jan 2012 15:00:21 +0000 Sascha L. Teichmann backend: Fixed spatial table hws.
Thu, 10 Nov 2011 13:35:31 +0000 Ingo Weinzierl Adapted 'lines' relation and made lines queryable for a given river.
Wed, 09 Nov 2011 16:01:16 +0000 Ingo Weinzierl Added model for 'hws' relation and synced postgis with oracle spatial schema.
Mon, 24 Oct 2011 12:33:05 +0000 Bjoern Schilberg Adjusted geometry type for floodplain and hws in AddGeometryColumn.
Fri, 23 Sep 2011 11:15:20 +0000 Bjoern Schilberg Added missing schemas.
Fri, 23 Sep 2011 10:42:25 +0000 Bjoern Schilberg Harmonized oracle and postgresql spatial schema.
Tue, 13 Sep 2011 10:34:44 +0000 Hans Plum Removed all tables for different datasets at HYdrologie/Hydr.Grenzen/Linien/*
Tue, 13 Sep 2011 08:02:38 +0000 Hans Plum Removed table boundarypolys because of wrong placed dataset
Mon, 12 Sep 2011 13:20:05 +0000 Bjoern Schilberg Postgresql spatial scheme extended.
Fri, 02 Sep 2011 13:49:46 +0000 Ingo Weinzierl Replaced SERIALs with SEQUENCES in PostgreSQL spatial schema.
Thu, 01 Sep 2011 10:03:58 +0000 Hans Plum Hint for unifying table names: dgm -> dem
Thu, 01 Sep 2011 09:38:05 +0000 Hans Plum Added mappings to existing data in file system (based on river Saar); added TODOs for missing tables/mappings
Wed, 31 Aug 2011 08:50:20 +0000 Ingo Weinzierl Added relation and hibernate classes for floodplains (german 'Talaue').
Wed, 31 Aug 2011 07:46:59 +0000 Ingo Weinzierl Added relation and hibernate classes for DGMs.
Thu, 18 Aug 2011 15:03:20 +0000 Ingo Weinzierl Introduced support for FLYS spatial data.

http://dive4elements.wald.intevation.org