Changeset 316
- Timestamp:
- 02/13/14 13:15:13 (10 years ago)
- Location:
- trunk/import
- Files:
-
- 2 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/import/datenbank_anlegen.sh
r314 r316 127 127 echo " " 128 128 echo "** Anlegen Post Processing Tabellen (pp_definition.sql)" 129 psql $con -U ${DBUSER} - f pp_definition.sql >$MANDANT_HOME/log/pp_definition.log129 psql $con -U ${DBUSER} -v alkis_epsg=$EPSG -f pp_definition.sql >$MANDANT_HOME/log/pp_definition.log 130 130 131 131 echo " " -
trunk/import/pp_definition.sql
r296 r316 3 3 4 4 -- Post Processing (pp_) Teil 1: Anlegen der Tabellen und Views 5 6 -- ACHTUNG! 7 -- Systemvariable vorher setzen fÃŒr das Koordinatensystem, z.B. 8 -- EPSG=25832 5 9 6 10 -- Stand … … 65 69 66 70 -- Gesamtflaeche 67 SELECT AddGeometryColumn('pp_gemeinde','the_geom', '25832','MULTIPOLYGON',2);71 SELECT AddGeometryColumn('pp_gemeinde','the_geom',:alkis_epsg,'MULTIPOLYGON',2); 68 72 CREATE INDEX pp_gemeinde_gidx ON pp_gemeinde USING gist(the_geom); 69 73 70 74 -- vereinfachte Gesamtflaeche 71 SELECT AddGeometryColumn('pp_gemeinde','simple_geom', '25832','MULTIPOLYGON',2);75 SELECT AddGeometryColumn('pp_gemeinde','simple_geom',:alkis_epsg,'MULTIPOLYGON',2); 72 76 CREATE INDEX pp_gemeinde_sgidx ON pp_gemeinde USING gist(simple_geom); 73 77 … … 105 109 106 110 -- GesamtflÀche 107 SELECT AddGeometryColumn('pp_gemarkung','the_geom', '25832','MULTIPOLYGON',2);111 SELECT AddGeometryColumn('pp_gemarkung','the_geom',:alkis_epsg,'MULTIPOLYGON',2); 108 112 CREATE INDEX pp_gemarkung_gidx ON pp_gemarkung USING gist(the_geom); 109 113 110 114 -- vereinfachte GesamtflÀche 111 SELECT AddGeometryColumn('pp_gemarkung','simple_geom', '25832','MULTIPOLYGON',2);115 SELECT AddGeometryColumn('pp_gemarkung','simple_geom',:alkis_epsg,'MULTIPOLYGON',2); 112 116 CREATE INDEX pp_gemarkung_sgidx ON pp_gemarkung USING gist(simple_geom); 113 117 … … 138 142 139 143 -- GesamtflÀche 140 SELECT AddGeometryColumn('pp_flur','the_geom', '25832','MULTIPOLYGON',2);144 SELECT AddGeometryColumn('pp_flur','the_geom',:alkis_epsg,'MULTIPOLYGON',2); 141 145 CREATE INDEX pp_flur_gidx ON pp_flur USING gist(the_geom); 142 146 143 147 -- vereinfachte Gesamtflaeche 144 SELECT AddGeometryColumn('pp_flur','simple_geom', '25832','MULTIPOLYGON',2);148 SELECT AddGeometryColumn('pp_flur','simple_geom',:alkis_epsg,'MULTIPOLYGON',2); 145 149 CREATE INDEX pp_flur_sgidx ON pp_flur USING gist(simple_geom); 146 150 … … 205 209 ); 206 210 207 SELECT AddGeometryColumn('pp_flurstueck_nr','the_geom', '25832','POINT',2);211 SELECT AddGeometryColumn('pp_flurstueck_nr','the_geom',:alkis_epsg,'POINT',2); 208 212 209 213 -- Geometrischer Index … … 379 383 ) WITH (OIDS=FALSE); 380 384 381 SELECT AddGeometryColumn('pp_strassenname','the_geom', '25832','POINT',2);385 SELECT AddGeometryColumn('pp_strassenname','the_geom',:alkis_epsg,'POINT',2); 382 386 CREATE INDEX pp_snam_gidx ON pp_strassenname USING gist(the_geom); 383 387
Note: See TracChangeset
for help on using the changeset viewer.