Hi, Try this query DATA "the_geom FROM roads"
Or Call all the fields(whatever the fields available in table) in select query. Thank, Venkat. -----Original Message----- From: mapserver-users-boun...@lists.osgeo.org [mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Ben Madin Sent: Wednesday, December 17, 2008 12:18 PM To: mapserver-users@lists.osgeo.org Subject: [mapserver-users] Blank PostGIS Layer G'day all, I am having generally excellent results with MapServer 5.2, but I am having a problem with a postgis layer not displaying, and no suggestion that it shouldn't from the logs. I imported a shapefile : shp2pgsql -s 4326 /Users/19022662/Geodata/healthmapper/LA/roads roads | psql prices in postgres I gave permission for the mapserver user to select from it : grant select on roads to gms_mapserver; My map layer : LAYER STATUS DEFAULT DEBUG 4 NAME "Roads" GROUP "Background" METADATA layer_title "Roads" END CONNECTIONTYPE postgis CONNECTION "host=localhost port=5432 dbname=prices password=badluck user=gms_mapserver" DATA "the_geom FROM ( SELECT gid, the_geom FROM roads ) AS foo USING UNIQUE gid USING SRID=4326" # DATA 'healthmapper/LA/roads' TYPE LINE PROJECTION "init=epsg:4326" END TRANSPARENCY 100 CLASS NAME "ROADS" OUTLINECOLOR 255 255 255 symbol 'dashed' COLOR 255 0 0 END END and I don't get the layer (even with everything else turned off); Other postGIS polygon layers are showing fine. If I load the data directly from the shapefile, it is fine If I connect to the postgis layer from QGIS, it is fine. Here is the dump from the error console [Wed Dec 17 15:44:42 2008].96166 msPOSTGISLayerOpen called datastatement: the_geom FROM ( SELECT gid, the_geom FROM roads ) AS foo USING UNIQUE gid USING SRID=4326 [Wed Dec 17 15:44:42 2008].96664 MSPOSTGISLayerOpen -- shared connection not available. [Wed Dec 17 15:44:42 2008].101270 msConnPoolRegister(Roads,host=localhost port=5432 dbname=prices password=badluck user=gms_mapserver,0x101900400) [Wed Dec 17 15:44:42 2008].101288 msPOSTGISLayerFreeItemInfo called [Wed Dec 17 15:44:42 2008].101314 msPOSTGISLayerWhichShapes called [Wed Dec 17 15:44:42 2008].101328 msPOSTGISLayerParseData: unique column = gid, srid='4326', geom_column_name = the_geom, table_name=( SELECT gid, the_geom FROM roads ) AS foo [Wed Dec 17 15:44:42 2008].101574 query_string_0_6:DECLARE mycursor BINARY CURSOR FOR SELECT asbinary(force_collection(force_2d(the_geom)),'NDR'),gid::text from ( SELECT gid, the_geom FROM roads ) AS foo WHERE the_geom && setSRID('BOX3D(102.054844143416 18.0123207848761,102.992352286832 18.7152227848761)'::BOX3D, 4326 ) [Wed Dec 17 15:44:42 2008].175520 msPOSTGISLayerFreeItemInfo called [Wed Dec 17 15:44:42 2008].175539 msPOSTGISLayerClose datastatement: the_geom FROM ( SELECT gid, the_geom FROM roads ) AS foo USING UNIQUE gid USING SRID=4326 [Wed Dec 17 15:44:42 2008].175543 msPOSTGISLayerClose -- closing query_result [Wed Dec 17 15:44:42 2008].175930 msConnPoolRelease(Roads,host=localhost port=5432 dbname=prices password=badluck user=gms_mapserver,0x101900400) [Wed Dec 17 15:44:42 2008].175940 msConnPoolClose(host=localhost port=5432 dbname=prices password=badluck user=gms_mapserver,0x101900400) [Wed Dec 17 15:44:42 2008].176004 msDrawMap(): Layer 8 (Roads), 0.080s [Wed Dec 17 15:44:42 2008].215812 msDrawMap(): Drawing Label Cache, 0.000s [Wed Dec 17 15:44:42 2008].215824 msDrawMap() total time: 0.121s [Wed Dec 17 15:44:42 2008].227155 msSaveImage() total time: 0.011s [Wed Dec 17 15:44:42 2008].230642 msSaveImage() total time: 0.001s [Wed Dec 17 15:44:42 2008].234008 mapserv request processing time (loadmap not incl.): 0.139s [Wed Dec 17 15:44:42 2008].234016 msFreeMap(): freeing map at 0x10180e200. [Wed Dec 17 15:44:42 2008].234020 msPOSTGISLayerClose datastatement: the_geom FROM ( SELECT gid, the_geom FROM roads ) AS foo USING UNIQUE gid USING SRID=4326 [Wed Dec 17 15:44:42 2008].234023 msPOSTGISLayerClose -- layerinfo is NULL If I copy and paste the query, I get data (I have no way of knowing if it is OK) : | 16899 \001 \007 \000 \000 \000 \001 \000 \000 \000 \001 \005 \000 \000 \000\001\000\000\000\001\002\000\000\000\037\000\000\000\000\000\000@ \023\2...@\000\000\000\300 etc (I just copied some of it) There is no difference between cgi mapserv and shp2img. Any thoughts much appreciated!! cheers Ben -- Ben Madin REMOTE INFORMATION t : +61 8 9192 5455 f : +61 8 9192 5535 m : 0448 887 220 Broome WA 6725 b...@remoteinformation.com.au Out here, it pays to know... _______________________________________________ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users _______________________________________________ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
