Mercurial > lada > lada-server
diff 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 |
line wrap: on
line diff
--- a/db_schema/stammdaten_schema.sql Mon Dec 05 12:20:10 2016 +0100 +++ b/db_schema/stammdaten_schema.sql Mon Dec 05 12:28:59 2016 +0100 @@ -169,6 +169,7 @@ gem_id character varying(8) NOT NULL REFERENCES verwaltungseinheit, shape public.geometry(MultiPolygon, 4326) ); +CREATE INDEX verwaltungsgrenze_sp_idx ON verwaltungsgrenze USING gist (shape); CREATE TABLE netz_betreiber ( id character varying(2) PRIMARY KEY,