<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Verdana
}
--></style>
</head>
<body class='hmmessage'>
Hi Roshni,<br><br>You are almost there it seems! Try extending the DATA statement such that it states the srid (Spatial Reference System Identifier) explicitly:<br><br> DATA "way from planet_osm_line using unique gid using srid=900913"<br><br>Hope this helps.<br><br>Regards,<br><br>Edward Mac Gillavry<br><br><br>> From: roshni.aruna@gmail.com<br>> To: mapserver-users@lists.osgeo.org<br>> Subject: [mapserver-users] Re: Problem with OpenStreetMap, osm2pgsql, MapServer, OpenLayers and epsg=900913<br>> <br>> <br>> Hi Milo, thanks for your reply.<br>> <br>> I have gone through the link you sent and after doing many tests i decided<br>> to start again from zero without WMS. I downloaded the Frida_tutorial and<br>> implemented it and it works perfectly fine (connecting to postgis and<br>> reading info from the db). <br>> After checking this, i just copy-pasted everything and just changed the info<br>> of the connection and the table from where get the data and again the image<br>> comes blank, so i guess the problem is between the db and the projection.<br>> This is my new map file.<br>> <br>> MAP<br>> IMAGETYPE JPEG<br>> EXTENT 3428000 5787000 3444000 5800000<br>> SIZE 600 600<br>> <br>> IMAGECOLOR 100 100 100<br>> SHAPEPATH "C:/ms4w/apps/palmarouting/data"<br>> SYMBOLSET "C:/ms4w/apps/palmarouting/symbols.sym"<br>> FONTSET "C:/ms4w/apps/palmarouting/fonts/fonts.list"<br>> DEBUG 5<br>> CONFIG "MS_ERRORFILE" "C:\ms4w\apps\palmarouting\ms_error.txt"<br>> <br>> WEB<br>> TEMPLATE "template.html"<br>> #IMAGEPATH "C:/ms4w/Apache/htdocs/tmp/"<br>> IMAGEPATH "C:/ms4w/apps/palmarouting/tmp/"<br>> IMAGEURL "C:/ms4w/apps/palmarouting/tmp/"<br>> <br>> <br>> <br>> END<br>> <br>> PROJECTION<br>> "init=epsg:900913"<br>> END<br>> <br>> <br>> LAYER <br>> NAME "roads"<br>> TYPE LINE<br>> CONNECTION "user=postgres password=postgres dbname=gis host=localhost<br>> port=5432"<br>> CONNECTIONTYPE postgis<br>> DATA "way from planet_osm_line using unique gid"<br>> <br>> STATUS DEFAULT<br>> #LABELITEM 'strname'<br>> CLASSITEM 'highway'<br>> CLASS<br>> EXPRESSION '1'<br>> STYLE<br>> COLOR 255 0 0 <br>> SIZE 6<br>> END <br>> END<br>> CLASS<br>> EXPRESSION '3'<br>> STYLE<br>> COLOR 0 255 0 <br>> END <br>> END<br>> CLASS<br>> EXPRESSION /./<br>> STYLE<br>> COLOR 200 200 200 <br>> END <br>> END<br>> END<br>> <br>> LAYER<br>> NAME "path"<br>> CONNECTION "user=postgres password=postgres dbname=gis host=localhost<br>> port=5432"<br>> CONNECTIONTYPE postgis<br>> STATUS ON<br>> TYPE LINE<br>> <br>> CLASS<br>> NAME "path"<br>> STYLE<br>> SYMBOL 'circle'<br>> COLOR 255 0 0<br>> SIZE 8<br>> END<br>> END<br>> END<br>> END <br>> <br>> <br>> The only difference i can see between the Frida db and mine is that in<br>> Fridadb the srid set in the geometry_columns is set to -1, but in mine its<br>> 900913. I have tried to apply this diff in my map file but with no success<br>> :(<br>> <br>> What can i do??? Thanks a lot!!<br>> -- <br>> View this message in context: http://osgeo-org.1803224.n2.nabble.com/Problem-with-OpenStreetMap-osm2pgsql-MapServer-OpenLayers-and-epsg-900913-tp5022925p5026547.html<br>> Sent from the Mapserver - User mailing list archive at Nabble.com.<br>> _______________________________________________<br>> mapserver-users mailing list<br>> mapserver-users@lists.osgeo.org<br>> http://lists.osgeo.org/mailman/listinfo/mapserver-users<br> </body>
</html>