log flys-backend/doc/schema/oracle-spatial.sql @ 5426:6875a9f02097

age author description
2013-03-25 Tom Gottfried SCHEMA CHANGE: add table for flood marks and missing DROPs for jetties
2013-03-25 Andre Heinecke Add building_kinds to drop script and fix syntax of buildings table
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 Andre Heinecke Switch to 2D for fixpoints and river_axes
2013-03-20 Andre Heinecke Jetties are two dimensional
2013-03-14 Tom Gottfried removed unique constraint to allow one dem to be used by several rivers
2013-03-14 Tom Gottfried added tables for jetties in spatial schema
2013-03-13 Tom Gottfried SCHEMA CHANGE: lookup table for floodmaps and source-field added, Importer adapted to new directory names
2013-03-12 Tom Gottfried fixed DEM-importer to work with Oracle (made by A. Heinecke)
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-08 Tom Gottfried Oracle Schema: add missing constraint and allow 7-digit kms
2013-03-01 Sascha L. Teichmann Fixed broken insert statements for axis_kinds.
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 Fix oracle-spatial creation script and posgresql drop script dami
2013-02-28 Andre Heinecke Fix import of hws_* on Oracle dami
2013-02-27 Tom Gottfried sensible constraints for dem-table dami
2013-02-27 Tom Gottfried removed unnecessary NOT NULL constraints from dem-table dami
2013-02-21 Andre Heinecke Oracle Schema, add overlooked sectie and sobek fields dami
2013-02-20 Andre Heinecke Fix some oracle syntax problems and move indicies to _idx.sql dami
2013-02-19 Tom Gottfried SCHEMA CHANGE: removed catchements from schema and geo-importer (obsolete) dami
2013-02-19 Andre Heinecke Sync Posgres and Oracle spatial schema dami
2013-02-19 Tom Gottfried SCHEMA CHANGE: removed obsolete table 'lines' from spatial schema (now 'hws_lines') dami
2012-09-28 Ingo Weinzierl Adapted the spatial schema for DEMs and the DgmSqlConverter.
2012-09-27 Ingo Weinzierl Modified the schema for DGMs; added converter for CSV to SQL for DGM information.
2012-08-30 Ingo Weinzierl Added 'path' attribute to each geo relation; adapted the shape importer to set the path for each feature.
2012-05-04 Ingo Weinzierl New shape importers and schema modifications.
2012-05-03 Ingo Weinzierl Added further shape importers and added the option to reproject shapes during the import process.
2012-04-26 Ingo Weinzierl Repaired broken oracle spatial schema.
2012-03-19 Ingo Weinzierl Adapted the column type of relation 'dem' in oracle-spatial schema.
2012-03-16 Ingo Weinzierl Modified the oracle db schema (relation 'floodmaps').
2012-03-06 Ingo Weinzierl Improved the db schema for storing existing floodmaps.
2011-11-30 Bjoern Schilberg doc/schema/oracle-spatial.sql: Adjust extent of germany to EPSG:31467 (GK3) coordinates.
2011-11-30 Bjoern Schilberg doc/schema/oracle-spatial.sql: Adjusted extent to the extent of germany and srs to 31467 in USER_SDO_GEOM_METADATA.
2011-11-10 Ingo Weinzierl Adapted 'lines' relation and made lines queryable for a given river.
2011-09-23 Bjoern Schilberg Added missing schemas.
2011-09-23 Bjoern Schilberg Harmonized oracle and postgresql spatial schema.
2011-09-22 Bjoern Schilberg Harmonized Extent for Saar and Mosel. Some cleanups.
2011-09-20 Bjoern Schilberg Generalized oracle spatial schema.
2011-09-14 Bjoern Schilberg Deactivated spatial indexes.
2011-09-14 Bjoern Schilberg Added schema floodplain.
2011-09-14 Bjoern Schilberg Added schema hws.
2011-09-14 Bjoern Schilberg Added schema cross_section_tracks.
2011-09-14 Bjoern Schilberg Added schema river_axes.
2011-09-14 Bjoern Schilberg Added schema fixpoints.
2011-09-14 Bjoern Schilberg Added schema buildings.
2011-09-14 Bjoern Schilberg Fixed table river_axes_km.
2011-09-13 Bjoern Schilberg Initial oracle schema.

http://dive4elements.wald.intevation.org