Changeset 281


Ignore:
Timestamp:
04/30/13 15:10:57 (11 years ago)
Author:
astrid.emde
Message:

tabellenname as x angepasst ohne as

File:
1 edited

Legend:

Unmodified
Added
Removed
  • trunk/import/sichten_ORACLE.sql

    r277 r281  
    296296 SELECT DISTINCT art  
    297297   FROM s_allgemeine_texte; 
    298 CREATE OR REPLACE VIEW FLURSTUECKS_MINMAX AS  
    299  SELECT min(st_xmin(ORA_GEOMETRY)) AS r_min,  
    300         min(st_ymin(ORA_GEOMETRY)) AS h_min,  
    301         max(st_xmax(ORA_GEOMETRY)) AS r_max,  
    302         max(st_ymax(ORA_GEOMETRY)) AS h_max 
    303    FROM ax_flurstueck f 
    304    WHERE f.endet IS NULL; 
     298 
     299-- ToDo:  
     300--CREATE OR REPLACE VIEW FLURSTUECKS_MINMAX AS  
     301-- SELECT min(st_xmin(ORA_GEOMETRY)) AS r_min,  
     302--        min(st_ymin(ORA_GEOMETRY)) AS h_min,  
     303--        max(st_xmax(ORA_GEOMETRY)) AS r_max,  
     304--        max(st_ymax(ORA_GEOMETRY)) AS h_max 
     305--   FROM ax_flurstueck f 
     306--   WHERE f.endet IS NULL; 
    305307-- COMMENT ON VIEW FLURSTUECKS_MINMAX IS 'Maximale Ausdehnung von ax_flurstueck fuer EXTENT-Angabe im Mapfile'; 
    306308 
     
    509511AS 
    510512SELECT * 
    511  FROM alkis_beziehungen AS bezalt 
     513 FROM alkis_beziehungen bezalt 
    512514 WHERE EXISTS 
    513515       (SELECT OGR_FID 
    514          FROM alkis_beziehungen AS bezneu 
     516         FROM alkis_beziehungen bezneu 
    515517        WHERE bezalt.beziehung_von = bezneu.beziehung_von 
    516518          AND bezalt.beziehung_zu  = bezneu.beziehung_zu 
     
    528530-- WHERE EXISTS 
    529531--       (SELECT OGR_FID 
    530 --         FROM alkis_beziehungen AS bezneu 
     532--         FROM alkis_beziehungen bezneu 
    531533--        WHERE bezalt.beziehung_von = bezneu.beziehung_von 
    532534--          AND bezalt.beziehung_zu  = bezneu.beziehung_zu 
Note: See TracChangeset for help on using the changeset viewer.