Can you check your Postgres logs and see what SQL exactly is being passed to the database server? Steve
From: [email protected] [mailto:[email protected]] On Behalf Of Strunck, Alexander Sent: Wednesday, July 28, 2010 8:51 AM To: '[email protected]' Subject: [mapserver-users] Postgresql join with chart Hello List, i am relativly new to mapfiles and mapserver. I am right now trying to bild an chart layer with my data. if i got only one postgresql table i got pie charts with no problem... LAYER NAME 'Grenzen aller Länder' GROUP 'baselayer' TYPE CHART INCLUDE "postgis.config" DATA "the_geom from (SELECT c.gid, c.area, ST_Centroid(c.the_geom) AS the_geom FROM basemap AS c ) as foo using unique gid using SRID=4326" STATUS on PROCESSING "CHART_TYPE=PIE" METADATA WMS_TITLE 'Grenzen aller Länder' WMS_FEATURE_INFO_MIME_TYPE 'text/html' END #METADATA CLASS NAME 'Grenzen aller Länder' STYLE SIZE [gid] COLOR 0 104 55 # CMYK 100, 25, 90, 0 OUTLINECOLOR 1 1 1 WIDTH 2 END #STYLE END # CLASS CLASS NAME 'Grenzen aller Länder' STYLE SIZE [area] COLOR 49 163 84 # CMYK 81, 0, 76, 0 OUTLINECOLOR 1 1 1 WIDTH 2 END #STYLE END # CLASS END # Layer if i try to make pie charts with a join, i don´t get a map back. LAYER NAME 'Grenzen aller Länder' GROUP 'bicc_baselayer' TYPE CHART INCLUDE "postgis.config" DATA "the_geom from (SELECT c.gid, gmi.milps, gmi.milpr, ST_Centroid(c.the_geom) AS the_geom FROM bicc_basemap AS c LEFT JOIN bpb_m3_thema1_2008_2 AS gmi ON c.iso3_code = gmi.iso3_code) as foo using unique gid using SRID=4326" gid using SRID=4326" STATUS on PROCESSING "CHART_TYPE=PIE" METADATA WMS_TITLE 'Grenzen aller Länder' WMS_FEATURE_INFO_MIME_TYPE 'text/html' END #METADATA CLASS NAME 'Grenzen aller Länder' STYLE SIZE [milps] COLOR 0 104 55 # CMYK 100, 25, 90, 0 OUTLINECOLOR 1 1 1 WIDTH 2 END #STYLE END # CLASS CLASS NAME 'Grenzen aller Länder' STYLE SIZE [milpr] COLOR 49 163 84 # CMYK 81, 0, 76, 0 OUTLINECOLOR 1 1 1 WIDTH 2 END #STYLE END # CLASS END # Layer Can anyone help me?!? Thanks Alex ________________________________ -- Internationales Konversionszentrum Bonn Bonn International Center for Conversion (BICC) GmbH Pfarrer- Byns-Straße 1, 53121 Bonn, GERMANY Tel. / Phone: +49-228-911 96 0, Fax: +49-228-911 96 - 22 Internet: www.bicc.de, E-mail: [email protected] Firmensitz/ Office: Bonn Registergericht/ Registered at: Amtsgericht Bonn, HRB 6717 Geschäftsführer/ Director: Peter Johannes Croll Prokurist/ Authorized Signatory: Michael Dedek Vorsitzender des Aufsichtsrates/ Chairman of the Supervisory Board: Staatssekretär/ Deputy Minister Dr. Michael Stückradt
_______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
