Ignore:
Timestamp:
11/25/16 11:01:12 (7 years ago)
Author:
frank.jaeger
Message:

kleine Korrekturen an den Buchauskunft

File:
1 edited

Legend:

Unmodified
Added
Removed
  • trunk/info/info/alkisn/alkishaus.php

    r373 r375  
    5252h.v bbauw, u.v AS bfunk, z.v AS zustandv, d.v AS bdach, a.v AS dgaus, o.v AS oflv, 
    5353round(st_area(g.wkb_geometry)::numeric,2) AS gebflae FROM ax_gebaeude g  
    54 LEFT JOIN alkis_wertearten h ON cast(g.bauweise AS character varying)=h.k AND h.element='ax_gebaeude' and h.bezeichnung='bauweise' 
    55 LEFT JOIN alkis_wertearten u ON cast(g.gebaeudefunktion AS character varying)=u.k AND u.element='ax_gebaeude' and u.bezeichnung='gebaeudefunktion' 
     54LEFT JOIN alkis_wertearten h ON cast(g.bauweise AS character varying)=h.k AND h.element='ax_gebaeude' AND h.bezeichnung='bauweise' 
     55LEFT JOIN alkis_wertearten u ON cast(g.gebaeudefunktion AS character varying)=u.k AND u.element='ax_gebaeude' AND u.bezeichnung='gebaeudefunktion' 
    5656LEFT JOIN alkis_wertearten z ON cast(g.zustand AS character varying)=z.k AND z.element='ax_gebaeude' AND z.bezeichnung='zustand' 
    5757LEFT JOIN alkis_wertearten d ON cast(g.dachform AS character varying)=d.k AND d.element='ax_gebaeude' AND d.bezeichnung='dachform' 
Note: See TracChangeset for help on using the changeset viewer.