<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.6000.16608" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=704351119-04042008><FONT face=Arial color=#0000ff size=2>There
may be greater issues, but your extent line looks wrong.
</FONT></SPAN></DIV>
<DIV><SPAN class=704351119-04042008><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=704351119-04042008><FONT face=Arial color=#0000ff size=2>It
should be: minx miny maxx maxy</FONT></SPAN></DIV>
<DIV><SPAN class=704351119-04042008><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=704351119-04042008><FONT face=Arial color=#0000ff size=2>Yours
looks like miny maxy minx maxx?</FONT></SPAN></DIV>
<DIV><SPAN class=704351119-04042008><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=704351119-04042008><FONT face=Arial color=#0000ff
size=2>David.</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B>
mapserver-users-bounces@lists.osgeo.org
[mailto:mapserver-users-bounces@lists.osgeo.org] <B>On Behalf Of </B>Kamen
Rider<BR><B>Sent:</B> Friday, April 04, 2008 2:03 PM<BR><B>To:</B>
mapserver-users@lists.osgeo.org<BR><B>Subject:</B> [mapserver-users] Problem
with polygons<BR><BR></FONT></DIV>Sorry, but I must insist. I hope someone
could help me.<BR><BR>---------- Forwarded message ----------<BR><SPAN
class=gmail_quote>From: <B class=gmail_sendername>Kamen Rider</B> <<A
href="mailto:kamenriderichigo@gmail.com">kamenriderichigo@gmail.com</A>><BR>Date:
26-mar-2008 9:51<BR>Subject: <BR>To: <A
href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</A><BR><BR></SPAN>
<DIV><FONT face=Arial size=2>Hello,<BR>I need something specific: To draw
polygons (parcels) over a SHP map, and none of the examples I found on the web
worked. </FONT></DIV>
<DIV><FONT face=Arial size=2>Also I have no problems displaying points and I'm
using UTM coordinates.<BR><BR>This is what I did:<BR><BR></FONT></DIV>
<DIV><FONT face=Arial size=2>1.- Compiled MS on Linux (CentOS) and
Install.</FONT></DIV>
<DIV><FONT face=Courier size=2>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<BR><BR></FONT></DIV>
<DIV><FONT face=Arial size=2>2.- Installed MySql.<BR><BR></FONT></DIV>
<DIV><FONT face=Arial size=2>3.- Created a table on MySql to store polygons.
Here is the description. This table is called "prueba"<BR><FONT
face=Courier>+----------+---------+------+-----+---------+-------+<BR>|
Field | Type | Null | Key | Default |
Extra |<BR>+----------+---------+------+-----+---------+-------+<BR>|
NUM | int(11) | YES
| | NULL
| | <BR>|
ID | int(11) | YES
| | NULL
| | <BR>| poligono |
text | YES | |
NULL | |
<BR>+----------+---------+------+-----+---------+-------+<BR></FONT></FONT></DIV>
<DIV><FONT face=Arial size=2>This is what inserted on field
poligono:</FONT></DIV>
<DIV><FONT face=Arial size=2><FONT face=Courier>POLYGON((350000 6270000,350000
6275000,360000 6275000,360000 6270000,350000 6270000))</FONT></FONT></DIV>
<DIV><STRONG></STRONG> </DIV>
<DIV><FONT face=Arial size=2>4.- Then created a OVF file, according to this
example. (aqidata.ovf)</FONT></DIV>
<DIV><FONT face=Arial size=2><A
onclick="return top.js.OpenExtLink(window,event,this)"
href="http://www.dottedeyes.com/web_mapping/blog/2008/02/06/how-to-display-polygons-from-non-spatial-databases/"
target=_blank>http://www.dottedeyes.com/web_mapping/blog/2008/02/06/how-to-display-polygons-from-non-spatial-databases/</A></FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>This is my OVF file :</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2><FONT
face=Courier><OGRVRTDataSource><BR> <OGRVRTLayer
name="aqidata"><BR>
<SrcDataSource>MYSQL:test,user=root,password=xxxxx,host=localhost,port=3306,tables=prueba</SrcDataSource><BR>
<SrcSQL>select NUM, ID, poligono from
prueba</SrcSQL><BR>
<FID>ID</FID><BR>
<GeometryType>wkbPolygon</GeometryType><BR>
<GeometryField encoding="WKT"
field="poligono"/><BR> </OGRVRTLayer><BR></OGRVRTDataSource></FONT><BR></FONT></DIV>
<DIV><FONT face=Arial size=2>Using OGRINFO I Tested the connection, this is
the result:</FONT></DIV>
<DIV><FONT face=Courier size=2></FONT> </DIV>
<DIV><FONT face=Courier size=2>INFO: Open of
`/var/www/cgi-bin/tests/aqidata.ovf'<BR> using
driver `VRT' successful.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2><FONT face=Courier>Layer name:
aqidata<BR>Geometry: Polygon<BR>Feature Count: 1<BR>Layer SRS
WKT:<BR>(unknown)<BR>NUM: Integer (11.0)<BR>ID: Integer (11.0)<BR>poligono:
Binary (0.0)<BR>OGRFeature(aqidata):1<BR> NUM (Integer) = 1<BR> ID
(Integer) = 1<BR> poligono (Binary) =
504F4C59474F4E282833353030303020363237303030302C333530303030203632373530...</FONT></FONT></DIV>
<DIV><FONT face=Courier size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>5.- Then a created a MAP file:</FONT></DIV>
<DIV><FONT face=Courier size=2></FONT> </DIV>
<DIV><FONT face=Courier size=2>MAP<BR> NAME "Testing"<BR> EXTENT
-177773.12 6409691.13 525065 6511086<BR> #IMAGETYPE JPEG<BR>
#IMAGETYPE PNG24<BR> IMAGETYPE PNG<BR> IMAGECOLOR 255 255
255<BR> STATUS ON<BR> SIZE 400 400<BR> FONTSET
"fonts.txt"<BR> SYMBOLSET "symbols.txt"</FONT></DIV>
<DIV> </DIV><FONT size=2></FONT>
<DIV><FONT size=2><BR><FONT face=Courier> WEB<BR>
METADATA<BR> "key1"
"value1"<BR> "key2"
"value2"<BR> "key3"
"value3"<BR> "key4"
"value4"<BR> END<BR> END</FONT></FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV> </DIV>
<DIV><FONT face=Courier size=2> PROJECTION<BR>
"init=epsg:4326"<BR> END</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2><FONT
face=Courier> LAYER<BR> NAME
"POLIGONO"<BR> DEBUG ON<BR> STATUS
DEFAULT<BR> TYPE POLYGON<BR>
PROJECTION<BR>
"init=epsg:4326"<BR> END<BR>
CONNECTIONTYPE OGR<BR> CONNECTION
"aqidata.ovf"<BR> DATA "aqidata"<BR>
CLASS<BR> NAME
"MyClass"<BR>
STYLE<BR>
COLOR 0 0
0<BR>
OUTLINECOLOR 255 0
0<BR>
SIZE 8<BR>
END<BR> END<BR> END<BR>END<BR></FONT></FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2><FONT face=Courier></FONT></FONT> </DIV>
<DIV><FONT face=Arial size=2>It doesn't show anything, just a white rectangle.
Not even an error. </FONT></DIV>
<DIV><FONT face=Arial size=2><FONT face=Courier><FONT face=Arial>But when I
display just points it works fine (using
"PointsFromColumns").</FONT></FONT></FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2><FONT face=Courier><FONT face=Arial>I hope you
could help me.</FONT></FONT></FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2><FONT face=Courier><FONT
face=Arial>Thanks,</FONT></FONT></FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2><FONT face=Courier><FONT face=Arial>Pablo Molina
S.</FONT></FONT></FONT></DIV></BLOCKQUOTE></BODY></HTML>