Changeset 316 for trunk


Ignore:
Timestamp:
02/13/14 13:15:13 (6 years ago)
Author:
astrid.emde
Message:

festen Code 25832 durch Variable erstetzt alkis_epsg

Location:
trunk/import
Files:
2 edited

Legend:

Unmodified
Added
Removed
  • trunk/import/datenbank_anlegen.sh

    r314 r316  
    127127echo " " 
    128128echo "** Anlegen Post Processing Tabellen (pp_definition.sql)" 
    129 psql $con -U ${DBUSER} -f pp_definition.sql >$MANDANT_HOME/log/pp_definition.log 
     129psql $con -U ${DBUSER} -v alkis_epsg=$EPSG -f pp_definition.sql >$MANDANT_HOME/log/pp_definition.log 
    130130 
    131131echo " " 
  • trunk/import/pp_definition.sql

    r296 r316  
    33 
    44-- 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 
    59 
    610-- Stand  
     
    6569 
    6670-- Gesamtflaeche 
    67 SELECT AddGeometryColumn('pp_gemeinde','the_geom','25832','MULTIPOLYGON',2); 
     71SELECT AddGeometryColumn('pp_gemeinde','the_geom',:alkis_epsg,'MULTIPOLYGON',2); 
    6872CREATE INDEX pp_gemeinde_gidx ON pp_gemeinde USING gist(the_geom); 
    6973 
    7074-- vereinfachte Gesamtflaeche 
    71 SELECT AddGeometryColumn('pp_gemeinde','simple_geom','25832','MULTIPOLYGON',2); 
     75SELECT AddGeometryColumn('pp_gemeinde','simple_geom',:alkis_epsg,'MULTIPOLYGON',2); 
    7276CREATE INDEX pp_gemeinde_sgidx ON pp_gemeinde USING gist(simple_geom); 
    7377 
     
    105109 
    106110-- GesamtflÀche 
    107 SELECT AddGeometryColumn('pp_gemarkung','the_geom','25832','MULTIPOLYGON',2); 
     111SELECT AddGeometryColumn('pp_gemarkung','the_geom',:alkis_epsg,'MULTIPOLYGON',2); 
    108112CREATE INDEX pp_gemarkung_gidx ON pp_gemarkung USING gist(the_geom); 
    109113 
    110114-- vereinfachte GesamtflÀche 
    111 SELECT AddGeometryColumn('pp_gemarkung','simple_geom','25832','MULTIPOLYGON',2); 
     115SELECT AddGeometryColumn('pp_gemarkung','simple_geom',:alkis_epsg,'MULTIPOLYGON',2); 
    112116CREATE INDEX pp_gemarkung_sgidx ON pp_gemarkung USING gist(simple_geom); 
    113117 
     
    138142 
    139143-- GesamtflÀche 
    140 SELECT AddGeometryColumn('pp_flur','the_geom','25832','MULTIPOLYGON',2); 
     144SELECT AddGeometryColumn('pp_flur','the_geom',:alkis_epsg,'MULTIPOLYGON',2); 
    141145CREATE INDEX pp_flur_gidx ON pp_flur USING gist(the_geom); 
    142146 
    143147-- vereinfachte Gesamtflaeche 
    144 SELECT AddGeometryColumn('pp_flur','simple_geom','25832','MULTIPOLYGON',2); 
     148SELECT AddGeometryColumn('pp_flur','simple_geom',:alkis_epsg,'MULTIPOLYGON',2); 
    145149CREATE INDEX pp_flur_sgidx ON pp_flur USING gist(simple_geom); 
    146150 
     
    205209  ); 
    206210 
    207 SELECT AddGeometryColumn('pp_flurstueck_nr','the_geom','25832','POINT',2); 
     211SELECT AddGeometryColumn('pp_flurstueck_nr','the_geom',:alkis_epsg,'POINT',2); 
    208212 
    209213-- Geometrischer Index 
     
    379383) WITH (OIDS=FALSE); 
    380384 
    381 SELECT AddGeometryColumn('pp_strassenname','the_geom','25832','POINT',2); 
     385SELECT AddGeometryColumn('pp_strassenname','the_geom',:alkis_epsg,'POINT',2); 
    382386CREATE INDEX pp_snam_gidx ON pp_strassenname USING gist(the_geom);  
    383387 
Note: See TracChangeset for help on using the changeset viewer.