[mapserver-users] Problem with polygons

[Fawcett, David]

There may be greater issues, but your extent line looks wrong.  
 
It should be: minx miny maxx maxy
 
Yours looks like miny maxy minx maxx?
 
David.

	-----Original Message-----
	From: mapserver-users-bounces at lists.osgeo.org
[mailto:mapserver-users-bounces at lists.osgeo.org] On Behalf Of Kamen
Rider
	Sent: Friday, April 04, 2008 2:03 PM
	To: mapserver-users at lists.osgeo.org
	Subject: [mapserver-users] Problem with polygons
	
	
	Sorry, but I must insist. I hope someone could help me.
	
	---------- Forwarded message ----------
	From: Kamen Rider <kamenriderichigo at gmail.com>
	Date: 26-mar-2008 9:51
	Subject: 
	To: mapserver-users at lists.osgeo.org
	
	
	Hello,
	I need something specific: To draw polygons (parcels) over a SHP
map, and none of the examples I found on the web worked. 
	Also I have no problems displaying points and I'm using UTM
coordinates.
	
	This is what I did:
	
	
	1.- Compiled MS on Linux (CentOS) and Install.
	MapServer version 5.0.0 OUTPUT=GIF OUTPUT=PNG OUTPUT=WBMP
OUTPUT=SVG SUPPORTS=PROJ SUPPORTS=FREETYPE SUPPORTS=WMS_SERVER
SUPPORTS=SOS_SERVER INPUT=EPPL7 INPUT=OGR INPUT=GDAL INPUT=MYGIS
INPUT=SHAPEFILE
	
	
	2.- Installed MySql.
	
	
	3.- Created a table on MySql to store polygons. Here is the
description. This table is called "prueba"
	+----------+---------+------+-----+---------+-------+
	| Field    | Type    | Null | Key | Default | Extra |
	+----------+---------+------+-----+---------+-------+
	| NUM      | int(11) | YES  |     | NULL    |       | 
	| ID       | int(11) | YES  |     | NULL    |       |  
	| poligono | text    | YES  |     | NULL    |       | 
	+----------+---------+------+-----+---------+-------+
	
	This is what inserted on field poligono:
	POLYGON((350000 6270000,350000 6275000,360000 6275000,360000
6270000,350000 6270000))
	 
	4.- Then created a OVF file, according to this example.
(aqidata.ovf)
	
http://www.dottedeyes.com/web_mapping/blog/2008/02/06/how-to-display-pol
ygons-from-non-spatial-databases/
	 
	This is my OVF file :
	 
	<OGRVRTDataSource>
	    <OGRVRTLayer name="aqidata">
	
<SrcDataSource>MYSQL:test,user=root,password=xxxxx,host=localhost,port=3
306,tables=prueba</SrcDataSource>
	        <SrcSQL>select NUM, ID, poligono from prueba</SrcSQL>
	        <FID>ID</FID>
	        <GeometryType>wkbPolygon</GeometryType>
	        <GeometryField encoding="WKT" field="poligono"/>
	 </OGRVRTLayer>
	</OGRVRTDataSource>
	
	Using OGRINFO I Tested the connection, this is the result:
	 
	INFO: Open of `/var/www/cgi-bin/tests/aqidata.ovf'
	      using driver `VRT' successful.
	 
	Layer name: aqidata
	Geometry: Polygon
	Feature Count: 1
	Layer SRS WKT:
	(unknown)
	NUM: Integer (11.0)
	ID: Integer (11.0)
	poligono: Binary (0.0)
	OGRFeature(aqidata):1
	  NUM (Integer) = 1
	  ID (Integer) = 1
	  poligono (Binary) =
504F4C59474F4E282833353030303020363237303030302C333530303030203632373530
...
	 
	 
	5.- Then a created a MAP file:
	 
	MAP
	  NAME "Testing"
	  EXTENT -177773.12 6409691.13 525065 6511086
	  #IMAGETYPE JPEG
	  #IMAGETYPE PNG24
	  IMAGETYPE PNG
	  IMAGECOLOR 255 255 255
	  STATUS ON
	  SIZE 400 400
	  FONTSET "fonts.txt"
	  SYMBOLSET "symbols.txt"
	 
	
	
	  WEB
	    METADATA
	      "key1" "value1"
	      "key2" "value2"
	      "key3" "value3"
	      "key4" "value4"
	    END
	  END
	 
	 
	  PROJECTION
	    "init=epsg:4326"
	  END
	 
	 LAYER
	    NAME "POLIGONO"
	    DEBUG ON
	    STATUS DEFAULT
	    TYPE POLYGON
	    PROJECTION
	      "init=epsg:4326"
	    END
	    CONNECTIONTYPE OGR
	    CONNECTION "aqidata.ovf"
	 DATA "aqidata"
	    CLASS
	       NAME "MyClass"
	           STYLE
	               COLOR 0 0 0
	               OUTLINECOLOR 255 0 0
	               SIZE 8
	           END
	    END
	  END
	END
	
	 
	 
	It doesn't show anything, just a white rectangle. Not even an
error. 
	But when I display just points it works fine (using
"PointsFromColumns").
	 
	I hope you could help me.
	 
	Thanks,
	 
	Pablo Molina S.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapserver-users/attachments/20080404/fab41092/attachment-0001.html