> Hi Folks! > Im struggling with a weird problem > Here the scenario: > Linux, HostGis 10 buildup, Mapserver 4.6, Postgres 8. up > address to try out http://200.32.100.173 > from the Hostgis menu, the PostGres JOIN failed option. > > from the map file > MAP # Abrir mapa > # > DEBUG ON > NAME MapaDinamico > STATUS ON > SIZE 604 604 > > EXTENT 1688948.00 3785439.00 5996706.00 7725558.00 > > UNITS METERS > DATAPATTERN "/var/www/mapdata/" > SHAPEPATH "/var/www/mapdata/tiles/" > FONTSET "/var/www/mapdata/fonts.inc" > IMAGECOLOR 255 255 255 > IMAGETYPE GIF > > OUTPUTFORMAT > NAME GIF > DRIVER "GD/GIF" > FORMATOPTION "INTERLACE=ON" > MIMETYPE "image/gif" > IMAGEMODE PC256 > END > > # web interface definition > > WEB > # the template for browsing mode > TEMPLATE "/var/www/htdocs/example/main.html" > IMAGEPATH "/var/www/mapdata/www/temp/" > IMAGEURL "/temp/" > LOG Mapserverlog.txt > END > > LEGEND > KEYSIZE 18 12 > LABEL > TYPE truetype > FONT Vera > SIZE 7 > COLOR 0 0 0 > END > STATUS ON > END > > PROJECTION > "init=epsg:22193" > END > .... > > the layer that works ... > > #****************************************************************** > #************** PostGresSQL Radios Rurales FAJA 3 ***************** > #****************************************************************** > > LAYER > CONNECTIONTYPE postgis > NAME "delpostgis-gisdata-sql" > CONNECTION "user=myuser password=mypassword dbname=mydb > host=localhost" > DATA "the_geom FROM paisradp" > STATUS OFF > TYPE POLYGON > MAXSCALE 25000000 > MINSCALE 100 > PROJECTION > "init=epsg:22193" > END > CLASS > STYLE > RANGEITEM "symbol" > DATARANGE 1 6 > COLORRANGE 255 255 178 189 0 38 > END > END > END > > > #****************************************************************** > #**************FIN PostGresSQL Radios Rurales FAJA 3 ************** > #****************************************************************** > > the layer that dont work ... > > #****************************************************************** > #************** PostGresSQL Pob Total Radios Rurales FAJA 3 ******* > #****************************************************************** > > LAYER > CONNECTIONTYPE postgis > NAME "delpostgis-mapas-mymap-sql" > CONNECTION "user=myuser password=mypassword dbname=mydb > host=localhost" > DATA "SELECT a.the_geom, a.gid, a.tpp_t, a.idcompuesto FROM > (SELECT p.idcompuesto, p.tpp_t, m.* > FROM prov01 m LEFT JOIN > poblacion_provincia p > ON p.idcompuesto = m.prov > WHERE p.idcompuesto <> '02') > AS algo a > USING UNIQUE gid > USING SRID=22193" > > STATUS OFF > TYPE POLYGON > PROJECTION > "init=epsg:22193" > END > CLASS > STYLE > RANGEITEM "algo.tpp_t" > DATARANGE 99356 13708902 #1 40000 > COLORRANGE 255 255 178 189 0 38 > OUTLINECOLOR 0 0 0 > #COLOR 200 200 200 > END > END > END > > > #****************************************************************** > #**************FIN PostGresSQL Pob Tot Radios Rurales FAJA 3 ****** > #****************************************************************** > > end # end of layer > > the log from MapServer > > Mon May 22 15:29:37 2006, > 9930, > 172.26.68.166, > MapaDinamico, > 4, > 1434001.464365 3784641.243572 6251652.535635 7726355.756428, > -1.000000 -1.000000, > delpostgis-mapas-mymap-sql pais_prov , > normal execution > > ¿¿¿ but the map does not show up ??? > > May some one give me a hand with this, please !!! > > Thanks in advance > > Juan Carlos Fuchs. > >
