RV: PostGis Join, wont show up map

[Fuchs Juan Carlos]

> 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.
> 
>