Mercurial > dive4elements > river

annotate flys-backend/doc/schema/oracle-drop-spatial.sql @ 4798:39885bdfc6fc

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Added calculation of the "Umhuellende" to calculation of "W fuer ungleichwertige Abfluesse". This is done by figuring out the WST columns that imfold the data and then do simple "gleichwertige" calculations from the start of the interval. This is too much because only the Qs are needed for the "Umhuellende".
author Sascha L. Teichmann <teichmann@intevation.de>
date Sun, 13 Jan 2013 16:18:28 +0100
parents 998f1a7dcfde
children 96d330bc40d0
rev   line source
2862
998f1a7dcfde New shape importers and schema modifications.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2861
diff changeset
1 DROP TRIGGER river_axes_trigger;
2854
89b097c8ebd7 Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
2 DROP TABLE river_axes;
89b097c8ebd7 Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
3 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'RIVER_AXES';
89b097c8ebd7 Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
4 DROP SEQUENCE RIVER_AXES_ID_SEQ;
89b097c8ebd7 Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
5
2862
998f1a7dcfde New shape importers and schema modifications.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2861
diff changeset
6 DROP TRIGGER river_axes_km_trigger;
2854
89b097c8ebd7 Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
7 DROP TABLE river_axes_km;
89b097c8ebd7 Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
8 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'RIVER_AXES_KM';
89b097c8ebd7 Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
9 DROP SEQUENCE RIVER_AXES_KM_ID_SEQ;
89b097c8ebd7 Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
10
2862
998f1a7dcfde New shape importers and schema modifications.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2861
diff changeset
11 DROP TRIGGER cross_section_tracks_trigger;
2854
89b097c8ebd7 Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
12 DROP TABLE cross_section_tracks;
89b097c8ebd7 Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
13 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'CROSS_SECTION_TRACKS';
89b097c8ebd7 Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
14 DROP SEQUENCE CROSS_SECTION_TRACKS_ID_SEQ;
89b097c8ebd7 Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
15
2862
998f1a7dcfde New shape importers and schema modifications.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2861
diff changeset
16 DROP TRIGGER lines_trigger;
2854
89b097c8ebd7 Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
17 DROP TABLE lines;
89b097c8ebd7 Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
18 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'LINES';
89b097c8ebd7 Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
19 DROP SEQUENCE LINES_ID_SEQ;
89b097c8ebd7 Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
20
2862
998f1a7dcfde New shape importers and schema modifications.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2861
diff changeset
21 DROP TRIGGER buildings_trigger;
2854
89b097c8ebd7 Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
22 DROP TABLE buildings;
89b097c8ebd7 Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
23 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'BUILDINGS';
89b097c8ebd7 Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
24 DROP SEQUENCE BUILDINGS_ID_SEQ;
89b097c8ebd7 Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
25
2862
998f1a7dcfde New shape importers and schema modifications.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2861
diff changeset
26 DROP TRIGGER fixpoints_trigger;
2854
89b097c8ebd7 Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
27 DROP TABLE fixpoints;
89b097c8ebd7 Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
28 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'FIXPOINTS';
89b097c8ebd7 Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
29 DROP SEQUENCE FIXPOINTS_ID_SEQ;
89b097c8ebd7 Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
30
2862
998f1a7dcfde New shape importers and schema modifications.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2861
diff changeset
31 DROP TRIGGER floodplain_trigger;
2854
89b097c8ebd7 Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
32 DROP TABLE floodplain;
89b097c8ebd7 Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
33 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'FLOODPLAIN';
89b097c8ebd7 Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
34 DROP SEQUENCE FLOODPLAIN_ID_SEQ;
89b097c8ebd7 Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
35
2862
998f1a7dcfde New shape importers and schema modifications.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2861
diff changeset
36 DROP TRIGGER dem_trigger;
2854
89b097c8ebd7 Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
37 DROP TABLE dem;
89b097c8ebd7 Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
38 DROP SEQUENCE DEM_ID_SEQ;
89b097c8ebd7 Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
39
2862
998f1a7dcfde New shape importers and schema modifications.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2861
diff changeset
40 DROP TRIGGER catchment_trigger;
2854
89b097c8ebd7 Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
41 DROP TABLE catchment;
89b097c8ebd7 Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
42 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'CATCHMENT';
89b097c8ebd7 Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
43 DROP SEQUENCE CATCHMENT_ID_SEQ;
89b097c8ebd7 Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
44
2862
998f1a7dcfde New shape importers and schema modifications.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2861
diff changeset
45 DROP TRIGGER hws_trigger;
2854
89b097c8ebd7 Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
46 DROP TABLE hws;
89b097c8ebd7 Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
47 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'HWS';
89b097c8ebd7 Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
48 DROP SEQUENCE HWS_ID_SEQ;
89b097c8ebd7 Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
49
2862
998f1a7dcfde New shape importers and schema modifications.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2861
diff changeset
50 DROP TRIGGER floodmaps_trigger;
2854
89b097c8ebd7 Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
51 DROP TABLE floodmaps;
89b097c8ebd7 Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
52 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'FLOODMAPS';
89b097c8ebd7 Added an SQL file to drop the spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
53 DROP SEQUENCE FLOODMAPS_ID_SEQ;
2861
b0132e1b9719 Added further shape importers and added the option to reproject shapes during the import process.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2854
diff changeset
54
2862
998f1a7dcfde New shape importers and schema modifications.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2861
diff changeset
55 DROP TRIGGER hydr_boundaries_trigger;
2861
b0132e1b9719 Added further shape importers and added the option to reproject shapes during the import process.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2854
diff changeset
56 DROP TABLE hydr_boundaries;
2862
998f1a7dcfde New shape importers and schema modifications.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2861
diff changeset
57 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'HYDR_BOUNDARIES';
2861
b0132e1b9719 Added further shape importers and added the option to reproject shapes during the import process.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2854
diff changeset
58 DROP SEQUENCE HYDR_BOUNDARIES_ID_SEQ;
b0132e1b9719 Added further shape importers and added the option to reproject shapes during the import process.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2854
diff changeset
59
2862
998f1a7dcfde New shape importers and schema modifications.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2861
diff changeset
60 DROP TRIGGER hydr_boundaries_poly_trigger;
2861
b0132e1b9719 Added further shape importers and added the option to reproject shapes during the import process.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2854
diff changeset
61 DROP TABLE hydr_boundaries_poly;
2862
998f1a7dcfde New shape importers and schema modifications.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2861
diff changeset
62 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'HYDR_BOUNDARIES_POLY';
2861
b0132e1b9719 Added further shape importers and added the option to reproject shapes during the import process.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2854
diff changeset
63 DROP SEQUENCE HYDR_BOUNDARIES_POLY_ID_SEQ;
2862
998f1a7dcfde New shape importers and schema modifications.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2861
diff changeset
64
998f1a7dcfde New shape importers and schema modifications.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2861
diff changeset
65 DROP TRIGGER gauge_location_trigger;
998f1a7dcfde New shape importers and schema modifications.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2861
diff changeset
66 DROP TABLE gauge_location;
998f1a7dcfde New shape importers and schema modifications.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2861
diff changeset
67 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'GAUGE_LOCATION';
998f1a7dcfde New shape importers and schema modifications.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2861
diff changeset
68 DROP SEQUENCE GAUGE_LOCATION_ID_SEQ;
http://dive4elements.wald.intevation.org