<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7651.59">
<TITLE>RE: [UMN_MAPSERVER-USERS] blank image</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<BR>
<P><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">Hi Matt, thanks for the explanation. </FONT></SPAN>
</P>
<P><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">The projection for the output map is in</FONT> <FONT SIZE=2 FACE="Arial">(NZ Mapping Grid</FONT><FONT SIZE=2 FACE="Arial"> =</FONT> <FONT SIZE=2 FACE="Arial">27200)</FONT><FONT SIZE=2 FACE="Arial"> this is set using mapscript - is this correct?</FONT></SPAN>
<BR><SPAN LANG="en-nz"><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">$map = ms_newMapObj("");</FONT></SPAN>
<BR><SPAN LANG="en-nz"><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">$map->setProjection('init=epsg:27200');</FONT></SPAN>
</P>
<P><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">The projection for the layer is not set using mapscript. The layer information comes from a postgis database. When I imported the data into the postgres/postgis database I set the srid. This is validated from describing the parcels table - Is this correct, should I be using mapscript to set the projection in the map file for this layer?</FONT></SPAN></P>
<P><SPAN LANG="en-nz"><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">Check constraints:</FONT></SPAN>
<BR><SPAN LANG="en-nz"><FONT COLOR="#0000FF" SIZE=2 FACE="Arial"> "enforce_dims_the_geom" CHECK (ndims(the_geom) = 2)</FONT></SPAN>
<BR><SPAN LANG="en-nz"><FONT COLOR="#0000FF" SIZE=2 FACE="Arial"> "enforce_geotype_the_geom" CHECK (geometrytype(the_geom) =</FONT></SPAN>
<BR><SPAN LANG="en-nz"><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">'MULTIPOLYGON'::text OR the_geom IS NULL)</FONT></SPAN>
<BR><SPAN LANG="en-nz"><FONT COLOR="#0000FF" SIZE=2 FACE="Arial"> "enforce_srid_the_geom" CHECK (srid(the_geom) = 27200)</FONT></SPAN>
</P>
<P><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">To find the correct extents from the postgis database I used this sql statement - Is this correct</FONT></SPAN>
<BR><SPAN LANG="en-nz"><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">select extent(the_geom) from parcels;</FONT></SPAN>
</P>
<P><SPAN LANG="en-nz"><FONT COLOR="#0000FF" SIZE=2 FACE="Arial"> extent</FONT></SPAN>
<BR><SPAN LANG="en-nz"><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">---------------------------------------------</FONT></SPAN>
<BR><SPAN LANG="en-nz"><FONT COLOR="#0000FF" SIZE=2 FACE="Arial"> BOX(2825539.75 6199758.5,2942387.5 6283728)</FONT></SPAN>
<BR><SPAN LANG="en-nz"><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">(1 row)</FONT></SPAN>
</P>
<P><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">I then set the extent in the map file using mapscript</FONT></SPAN>
<BR><SPAN LANG="en-nz"><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">$map->setExtent(2825539.75, 6199758.5, 2942387.5, 6283728);</FONT></SPAN>
</P>
<P><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">Image was still blank. I think I will set the projection in the layer and see how that goes, any help would be much appreciated. Thanks in advance for the help.</FONT></SPAN></P>
<P><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">bm</FONT></SPAN>
</P>
<BR>
<P><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">-----Original Message-----</FONT></SPAN>
<BR><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">From: UMN MapServer Users List [</FONT></SPAN><A HREF="mailto:MAPSERVER-USERS@LISTS.UMN.EDU"><SPAN LANG="en-nz"><U><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">mailto:MAPSERVER-USERS@LISTS.UMN.EDU</FONT></U></SPAN></A><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">] On Behalf Of Matthew Perry</FONT></SPAN>
<BR><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">Sent: Monday, 10 September 2007 2:44 p.m.</FONT></SPAN>
<BR><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">To: MAPSERVER-USERS@LISTS.UMN.EDU</FONT></SPAN>
<BR><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">Subject: Re: [UMN_MAPSERVER-USERS] blank image</FONT></SPAN>
</P>
<P><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">Terence,</FONT></SPAN>
</P>
<P><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">There are three separate issues:</FONT></SPAN>
</P>
<P><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">1. What projection is your output map in? This is the projection of the overall map, presumably the NZ grid.</FONT></SPAN>
</P>
<P><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">2. What projection is your data in? This is the projection assigned to your layer. If different than #1, it must be assigned and the data will be reprojected on-the-fly.</FONT></SPAN></P>
<P><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">3. What is the extent in the output map projection? Use this to set the map extents. If your output map is in the epsg:27200 projection , then your given extents (-180, -90, 180, 90) are not correct. Those are the geographic coordinates (ie longitudes and latitudes) but you want to specify the extent in the NZ grid.</FONT></SPAN></P>
<BR>
<P><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">- matt</FONT></SPAN>
</P>
<P><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">On 9/9/07, Terence Maru <terence@wairoadc.govt.nz> wrote:</FONT></SPAN>
<BR><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">></FONT></SPAN>
<BR><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">></FONT></SPAN>
<BR><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">></FONT></SPAN>
<BR><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">> Hi all, I have added a projection to the map object (see attached php</FONT></SPAN>
<BR><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">> script). I have also attached the postgis table describe. The</FONT></SPAN>
<BR><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">> postgis describe shows that the table "parcels" has a constraint check</FONT></SPAN>
<BR><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">> on the_geom</FONT></SPAN>
<BR><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">> (column) that the srid is 27200 (NZ Mapping Grid). Does this mean</FONT></SPAN>
<BR><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">> that the database has the correct projection? I have added in the</FONT></SPAN>
<BR><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">> mapscript the line "$map->setProjection('init=epsg:27200');", my</FONT></SPAN>
<BR><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">> understanding is that this sets the correct projection for the map</FONT></SPAN>
<BR><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">> object? Do I need to set the projection for the layer object too? Im</FONT></SPAN>
<BR><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">> still getting a blank image. I thought it might have something to do</FONT></SPAN>
<BR><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">> with the extents if my projections are correct? Still reasearching though. Thanks in advance.</FONT></SPAN>
<BR><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">></FONT></SPAN>
<BR><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">> <postgis-start></FONT></SPAN>
<BR><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">> Indexes:</FONT></SPAN>
<BR><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">> "parcels_pkey" PRIMARY KEY, btree (gid)</FONT></SPAN>
<BR><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">> "gist_index" gist (the_geom)</FONT></SPAN>
<BR><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">> Check constraints:</FONT></SPAN>
<BR><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">> "enforce_dims_the_geom" CHECK (ndims(the_geom) = 2)</FONT></SPAN>
<BR><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">> "enforce_geotype_the_geom" CHECK (geometrytype(the_geom) =</FONT></SPAN>
<BR><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">> 'MULTIPOLYGON'::text OR the_geom IS NULL)</FONT></SPAN>
<BR><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">> "enforce_srid_the_geom" CHECK (srid(the_geom) = 27200)</FONT></SPAN>
<BR><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">> </postgis-end> <php_mapscript-start> $map = ms_newMapObj("");</FONT></SPAN>
<BR><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">> //$map->set("debug", MS_TRUE); $map->setSize(600, 300);</FONT></SPAN>
<BR><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">> $map->setExtent(-180, -90, 180, 90);</FONT></SPAN>
<BR><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">></FONT></SPAN>
<BR><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">> //define path where to creat image</FONT></SPAN>
<BR><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">> $map->web->set("imagepath", "./data/"); $map->web->set("imageurl",</FONT></SPAN>
<BR><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">> "./data/"); $map->web->set("log", "./data/logfile.txt");</FONT></SPAN>
<BR><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">> $map->setProjection('init=epsg:27200');</FONT></SPAN>
<BR><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">></FONT></SPAN>
<BR><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">> //crate parcel layer, associate it withthe map $parcelLayer =</FONT></SPAN>
<BR><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">> ms_newLayerObj($map); $parcelLayer->set("connectiontype", MS_POSTGIS);</FONT></SPAN>
<BR><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">> $parcelLayer->set("name", "parcels layer");</FONT></SPAN>
<BR><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">></FONT></SPAN>
<BR><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">> $connector = "user=user dbname=dbname host=localhost";</FONT></SPAN>
<BR><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">> $parcelLayer->set("connection", $connector);</FONT></SPAN>
<BR><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">></FONT></SPAN>
<BR><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">> $sql = "the_geom from parcels";</FONT></SPAN>
<BR><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">> $parcelLayer->set("data", $sql);</FONT></SPAN>
<BR><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">></FONT></SPAN>
<BR><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">> $parcelLayer->set("status", MS_DEFAULT); $parcelLayer->set("type",</FONT></SPAN>
<BR><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">> MS_LAYER_POLYGON); //$parcelLayer->set("debug", MS_ON);</FONT></SPAN>
<BR><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">></FONT></SPAN>
<BR><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">> $parcelClass = ms_newClassObj($parcelLayer); $parcelClass->set("name",</FONT></SPAN>
<BR><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">> "parcels class");</FONT></SPAN>
<BR><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">></FONT></SPAN>
<BR><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">> $parcelStyle = ms_newStyleObj($parcelClass);</FONT></SPAN>
<BR><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">> $parcelStyle->color->setRGB( 250, 0, 0);</FONT></SPAN>
<BR><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">> $parcelStyle->outlinecolor->setRGB( 255, 255, 255);</FONT></SPAN>
<BR><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">> //$parcelStyle->set("symbol", 7); $parcelStyle->set("symbolname",</FONT></SPAN>
<BR><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">> "circle"); //$parcelStyle->set("size", 6); $parcelStyle->set("size",</FONT></SPAN>
<BR><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">> 10); </php_mapscript-end></FONT></SPAN>
<BR><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">></FONT></SPAN>
<BR><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">> bm</FONT></SPAN>
<BR><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">></FONT></SPAN>
<BR><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">></FONT></SPAN>
<BR><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">></FONT></SPAN>
<BR><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">></FONT></SPAN>
<BR><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">> -----Original Message-----</FONT></SPAN>
<BR><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">> From: UMN MapServer Users List</FONT></SPAN>
<BR><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">> [</FONT></SPAN><A HREF="mailto:MAPSERVER-USERS@LISTS.UMN.EDU"><SPAN LANG="en-nz"><U><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">mailto:MAPSERVER-USERS@LISTS.UMN.EDU</FONT></U></SPAN></A><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">] On Behalf Of Gregor Mosheh</FONT></SPAN>
<BR><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">> Sent: Wednesday, 5 September 2007 12:02 p.m.</FONT></SPAN>
<BR><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">> To: MAPSERVER-USERS@LISTS.UMN.EDU</FONT></SPAN>
<BR><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">> Subject: Re: [UMN_MAPSERVER-USERS] blank image</FONT></SPAN>
<BR><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">></FONT></SPAN>
<BR><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">> Terence Maru wrote:</FONT></SPAN>
<BR><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">> > Hi everyone, I have a problem generating an image from my postgis</FONT></SPAN>
<BR><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">> > database I have attached my php script. No errors are returned</FONT></SPAN>
<BR><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">> > when the script is run, just a blank image is returned. Can anyone</FONT></SPAN>
<BR><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">> > see whats wrong with my script? Cheers</FONT></SPAN>
<BR><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">></FONT></SPAN>
<BR><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">> This exact same question came up two days ago. 90% of the time, the</FONT></SPAN>
<BR><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">> issue is projections. Ensure that all layers and the output map are in</FONT></SPAN>
<BR><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">> the same projection, or else set projection blocks. 90% of the time, that fixes it.</FONT></SPAN>
<BR><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">></FONT></SPAN>
<BR><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">></FONT></SPAN>
<BR><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">> --</FONT></SPAN>
<BR><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">> Gregor Mosheh / Greg Allensworth</FONT></SPAN>
<BR><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">> System Administrator, HostGIS cartographic development & hosting</FONT></SPAN>
<BR><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">> services </FONT></SPAN><A HREF="http://www.HostGIS.com/"><SPAN LANG="en-nz"><U><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">http://www.HostGIS.com/</FONT></U></SPAN></A><SPAN LANG="en-nz"></SPAN>
<BR><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">></FONT></SPAN>
<BR><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">> "Remember that no one cares if you can back up,</FONT></SPAN>
<BR><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">> only if you can restore." - AMANDA</FONT></SPAN>
<BR><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">> ________________________________</FONT></SPAN>
<BR><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">> This e-mail message has been scanned for viruses by McAfee and the</FONT></SPAN>
<BR><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">> content has been cleared by MailMarshal</FONT></SPAN>
<BR><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">> ________________________________</FONT></SPAN>
<BR><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">></FONT></SPAN>
</P>
<BR>
<P><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">--</FONT></SPAN>
<BR><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">Matthew T. Perry</FONT></SPAN>
<BR><SPAN LANG="en-nz"></SPAN><A HREF="http://www.perrygeo.net"><SPAN LANG="en-nz"><U><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">http://www.perrygeo.net</FONT></U></SPAN></A><SPAN LANG="en-nz"></SPAN>
</P>
<P><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">"You never change things by fighting the existing reality.</FONT></SPAN>
<BR><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial">To change something, build a new model that makes the existing model obsolete" - R. Buckminster Fuller</FONT></SPAN>
</P>
<BR>
<FONT face=Arial size=2>
<HR>
This e-mail message has been scanned for viruses by <FONT
color=#ff8000><STRONG><FONT color=#400080>McAfee</FONT> </STRONG></FONT>and the
content has been cleared by <STRONG><FONT color=#400080>MailMarshal</FONT>
</STRONG>
<HR>
</FONT>
</BODY>
</HTML>