log flys-backend/doc/schema/postgresql-spatial.sql @ 5305:e60f65540cc2

age author description
2013-03-14 Tom Gottfried fixed spatial schema for hydraulic boundaries
2013-03-14 Tom Gottfried merge
2013-03-14 Tom Gottfried added tables for jetties in spatial schema
2013-03-14 Felix Wolfsteller postgresql-spatial.sql: Fixed table definition.
2013-03-13 Tom Gottfried SCHEMA CHANGE: lookup table for floodmaps and source-field added, Importer adapted to new directory names
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-07 Andre Heinecke SCHEME CHANGE: Hydr.Boundaries are now three dimensional multilinestrings
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 River Axes and HWS_lines are now multiline
2013-02-27 Tom Gottfried sensible constraints for dem-table dami
2013-02-20 Andre Heinecke SCHEMA Change: Make hws_lines a 3d geom dami
2013-02-19 Tom Gottfried SCHEMA CHANGE: removed catchements from schema and geo-importer (obsolete) dami
2013-02-19 Andre Heinecke SCHEMA Remove geom_target and geom_rated_level from hws_lines table dami
2013-02-19 Tom Gottfried SCHEMA CHANGE: removed obsolete table 'lines' from spatial schema (now 'hws_lines') dami
2013-02-19 Tom Gottfried Corrected typo in field name dami
2013-02-15 Andre Heinecke SCHEMA_CHANGE: Add lookup tables for sectie / sobek and boundary_kind dami
2013-02-14 Tom Gottfried SCHEMA CHANGE: added column dem.srid dami
2013-02-14 Tom Gottfried SCHEMA CHANGE: added 'ON DELETE CASCADE' where necessary to delete complete rivers (only in Postgres-Schema so far) dami
2013-02-01 Andre Heinecke SCHEMA CHANGE: extended hydr_boundaries tables dami
2013-01-28 Andre Heinecke SCHEMA Change (psql only) use FLOAT8 for real numbers dami
2013-01-28 Andre Heinecke SCHEMA CHANGES: Add tables for Hochwasserschutzanlagen 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-09-24 Ingo Weinzierl Adapted postgresql spatial schema and fixed a bug in the geo importer.
2012-09-24 Ingo Weinzierl Adapted PostgreSQL spatial schema.
2012-03-07 Ingo Weinzierl Adapted the PostgreSQL schema for floodmaps.
2012-03-06 Ingo Weinzierl Improved the db schema for storing existing floodmaps.
2012-01-05 Sascha L. Teichmann backend: Fixed spatial table hws.
2011-11-10 Ingo Weinzierl Adapted 'lines' relation and made lines queryable for a given river.
2011-11-09 Ingo Weinzierl Added model for 'hws' relation and synced postgis with oracle spatial schema.
2011-10-24 Bjoern Schilberg Adjusted geometry type for floodplain and hws in AddGeometryColumn.
2011-09-23 Bjoern Schilberg Added missing schemas.
2011-09-23 Bjoern Schilberg Harmonized oracle and postgresql spatial schema.
2011-09-13 Hans Plum Removed all tables for different datasets at HYdrologie/Hydr.Grenzen/Linien/*
2011-09-13 Hans Plum Removed table boundarypolys because of wrong placed dataset
2011-09-12 Bjoern Schilberg Postgresql spatial scheme extended.
2011-09-02 Ingo Weinzierl Replaced SERIALs with SEQUENCES in PostgreSQL spatial schema.
2011-09-01 Hans Plum Hint for unifying table names: dgm -> dem
2011-09-01 Hans Plum Added mappings to existing data in file system (based on river Saar); added TODOs for missing tables/mappings
2011-08-31 Ingo Weinzierl Added relation and hibernate classes for floodplains (german 'Talaue').
2011-08-31 Ingo Weinzierl Added relation and hibernate classes for DGMs.
2011-08-18 Ingo Weinzierl Introduced support for FLYS spatial data.

http://dive4elements.wald.intevation.org