log flys-backend/doc/schema/oracle-spatial.sql @ 5810:dba9e1fa233e

age author description
Mon, 22 Apr 2013 13:00:13 +0200 Tom Gottfried add missing constraints to Oracle Schema (issue426) and some cosmetics
Wed, 17 Apr 2013 19:30:10 +0200 Tom Gottfried Schema change: allow SECTIE and STROVOER (alias SOBEK) to be NULL, rename kinds
Tue, 09 Apr 2013 19:07:20 +0200 Tom Gottfried Schema change: Allow longer strings in fixpoints.hpgp
Fri, 05 Apr 2013 15:42:15 +0200 Tom Gottfried added missing ON DELETE CASCADE to Oracle schema
Wed, 03 Apr 2013 15:31:31 +0200 Andre Heinecke Fix syntax errors in oracle scheme
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 17:01:07 +0100 Andre Heinecke Add building_kinds to drop script and fix syntax of buildings table
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 09:30:46 +0100 Andre Heinecke Switch to 2D for fixpoints and river_axes
Wed, 20 Mar 2013 17:58:45 +0100 Andre Heinecke Jetties are two dimensional
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.
Thu, 10 Nov 2011 13:35:31 +0000 Ingo Weinzierl Adapted 'lines' relation and made lines queryable for a given river.
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.
Thu, 22 Sep 2011 12:10:08 +0000 Bjoern Schilberg Harmonized Extent for Saar and Mosel. Some cleanups.
Tue, 20 Sep 2011 13:21:29 +0000 Bjoern Schilberg Generalized oracle spatial schema.
Wed, 14 Sep 2011 14:49:53 +0000 Bjoern Schilberg Deactivated spatial indexes.
Wed, 14 Sep 2011 10:05:09 +0000 Bjoern Schilberg Added schema floodplain.
Wed, 14 Sep 2011 09:49:18 +0000 Bjoern Schilberg Added schema hws.
Wed, 14 Sep 2011 09:28:20 +0000 Bjoern Schilberg Added schema cross_section_tracks.
Wed, 14 Sep 2011 08:54:07 +0000 Bjoern Schilberg Added schema river_axes.
Wed, 14 Sep 2011 08:07:08 +0000 Bjoern Schilberg Added schema fixpoints.
Wed, 14 Sep 2011 07:20:26 +0000 Bjoern Schilberg Added schema buildings.
Wed, 14 Sep 2011 06:57:28 +0000 Bjoern Schilberg Fixed table river_axes_km.
Tue, 13 Sep 2011 20:06:48 +0000 Bjoern Schilberg Initial oracle schema.

http://dive4elements.wald.intevation.org