Mercurial > lada > lada-server
comparison db_schema/stammdaten_schema.sql @ 1209:df75a467d55a
Add spatial index to speed up OrtFactory.findVerwaltungseinheit().
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Mon, 05 Dec 2016 12:28:59 +0100 |
| parents | 9dda1237c756 |
| children | 6f206d8eab7e |
comparison
equal
deleted
inserted
replaced
| 1208:9dda1237c756 | 1209:df75a467d55a |
|---|---|
| 167 CREATE TABLE verwaltungsgrenze ( | 167 CREATE TABLE verwaltungsgrenze ( |
| 168 id serial PRIMARY KEY, | 168 id serial PRIMARY KEY, |
| 169 gem_id character varying(8) NOT NULL REFERENCES verwaltungseinheit, | 169 gem_id character varying(8) NOT NULL REFERENCES verwaltungseinheit, |
| 170 shape public.geometry(MultiPolygon, 4326) | 170 shape public.geometry(MultiPolygon, 4326) |
| 171 ); | 171 ); |
| 172 CREATE INDEX verwaltungsgrenze_sp_idx ON verwaltungsgrenze USING gist (shape); | |
| 172 | 173 |
| 173 CREATE TABLE netz_betreiber ( | 174 CREATE TABLE netz_betreiber ( |
| 174 id character varying(2) PRIMARY KEY, | 175 id character varying(2) PRIMARY KEY, |
| 175 netzbetreiber character varying(50), | 176 netzbetreiber character varying(50), |
| 176 idf_netzbetreiber character varying(1), | 177 idf_netzbetreiber character varying(1), |