Mercurial > dive4elements > river
comparison flys-backend/doc/schema/postgresql-spatial.sql @ 1237:774dff3ee546
Added relation and hibernate classes for floodplains (german 'Talaue').
flys-backend/trunk@2615 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Ingo Weinzierl <ingo.weinzierl@intevation.de> |
|---|---|
| date | Wed, 31 Aug 2011 08:50:20 +0000 |
| parents | 324cb486db9f |
| children | 35740d675866 |
comparison
equal
deleted
inserted
replaced
| 1236:324cb486db9f | 1237:774dff3ee546 |
|---|---|
| 46 HPGP VARCHAR(2) | 46 HPGP VARCHAR(2) |
| 47 ); | 47 ); |
| 48 SELECT AddGeometryColumn('fixpoints', 'geom', 31466, 'POINT', 2); | 48 SELECT AddGeometryColumn('fixpoints', 'geom', 31466, 'POINT', 2); |
| 49 | 49 |
| 50 | 50 |
| 51 -- Talaue | |
| 52 CREATE TABLE floodplain ( | |
| 53 id SERIAL PRIMARY KEY NOT NULL, | |
| 54 river_id int REFERENCES rivers(id) | |
| 55 ); | |
| 56 SELECT AddGeometryColumn('floodplain', 'geom', 31466, 'MULTIPOLYGON', 2); | |
| 57 | |
| 58 | |
| 51 CREATE TABLE dgm ( | 59 CREATE TABLE dgm ( |
| 52 id SERIAL PRIMARY KEY NOT NULL, | 60 id SERIAL PRIMARY KEY NOT NULL, |
| 53 river_id int REFERENCES rivers(id), | 61 river_id int REFERENCES rivers(id), |
| 54 -- XXX Should we use the ranges table instead? | 62 -- XXX Should we use the ranges table instead? |
| 55 lower NUMERIC, | 63 lower NUMERIC, |