log flys-backend/doc/schema/oracle-spatial.sql @ 5352:f1009aa7dcd1

age author description
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 12:16:58 +0100 Tom Gottfried added tables for jetties in spatial schema
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
Tue, 12 Mar 2013 19:43:11 +0100 Tom Gottfried fixed DEM-importer to work with Oracle (made by A. Heinecke)
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
Fri, 08 Mar 2013 13:06:40 +0100 Tom Gottfried Oracle Schema: add missing constraint and allow 7-digit kms
Fri, 01 Mar 2013 20:52:31 +0100 Sascha L. Teichmann Fixed broken insert statements for axis_kinds.
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 11:14:38 +0100 Andre Heinecke Fix oracle-spatial creation script and posgresql drop script dami
Thu, 28 Feb 2013 10:09:31 +0100 Andre Heinecke Fix import of hws_* on Oracle dami
Wed, 27 Feb 2013 19:44:08 +0100 Tom Gottfried sensible constraints for dem-table dami
Wed, 27 Feb 2013 15:26:47 +0100 Tom Gottfried removed unnecessary NOT NULL constraints from dem-table dami
Thu, 21 Feb 2013 12:36:30 +0100 Andre Heinecke Oracle Schema, add overlooked sectie and sobek fields dami
Wed, 20 Feb 2013 10:44:04 +0100 Andre Heinecke Fix some oracle syntax problems and move indicies to _idx.sql 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:58:33 +0100 Andre Heinecke Sync Posgres and Oracle spatial schema dami
Tue, 19 Feb 2013 09:57:57 +0100 Tom Gottfried SCHEMA CHANGE: removed obsolete table 'lines' from spatial schema (now 'hws_lines') 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.
Thu, 30 Aug 2012 09:51:04 +0000 Ingo Weinzierl Added 'path' attribute to each geo relation; adapted the shape importer to set the path for each feature.
Fri, 04 May 2012 06:58:00 +0000 Ingo Weinzierl New shape importers and schema modifications.
Thu, 03 May 2012 14:19:52 +0000 Ingo Weinzierl Added further shape importers and added the option to reproject shapes during the import process.
Thu, 26 Apr 2012 13:01:02 +0000 Ingo Weinzierl Repaired broken oracle spatial schema.
Mon, 19 Mar 2012 06:11:38 +0000 Ingo Weinzierl Adapted the column type of relation 'dem' in oracle-spatial schema.
Fri, 16 Mar 2012 07:23:11 +0000 Ingo Weinzierl Modified the oracle db schema (relation 'floodmaps').
Tue, 06 Mar 2012 11:54:41 +0000 Ingo Weinzierl Improved the db schema for storing existing floodmaps.
Wed, 30 Nov 2011 12:14:41 +0000 Bjoern Schilberg doc/schema/oracle-spatial.sql: Adjust extent of germany to EPSG:31467 (GK3) coordinates.
Wed, 30 Nov 2011 11:23:23 +0000 Bjoern Schilberg doc/schema/oracle-spatial.sql: Adjusted extent to the extent of germany and srs to 31467 in USER_SDO_GEOM_METADATA.

http://dive4elements.wald.intevation.org