[mapserver-users] build mapserver 6.2 freetype error
hi, im trying to build mapserver 6.2: i type this: ./configure --with-ogr=/usr/bin/gdal-config --with-gdal=/usr/bin/gdal-config --with-httpd=/usr/sbin/httpd --with-wfsclient --with-wmsclient --enable-debug --with-curl-config=/usr/bin/curl-config --with-proj=/usr/local --with-tiff --with-gd=/usr/share/locale/ --with-jpeg --with-freetype=/usr/lib64/ --with-threads --with-wcs --with-postgis=/usr/local/database/bin/pg_config --with-libiconv=/usr --with-geos=/usr/local/geos-3.3.5/tools/geos-config --with-xml2-config=/usr/bin/xml2-config --with-sos but i have this error about freetype: checking if pkg-config path is provided... checking for pkg-config... /usr/bin/pkg-config checking for freetype-config... no checking for FT_Init_FreeType in -lfreetype... no configure: error: unable to link - reconfigure with correct --with-freetype=dir i checked freetype-2.3.11-14.el6_3.1.x86_64 is already installed Thanks in advance ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] build mapserver 6.2 freetype error
Bonjour, Try installing libfreetype6-dev When you build something you should install something-dev package to install the source. Cordialement, Y. Le mercredi 13 mars 2013 09:35:20 Icadedt a écrit : hi, im trying to build mapserver 6.2: i type this: ./configure --with-ogr=/usr/bin/gdal-config --with-gdal=/usr/bin/gdal-config --with-httpd=/usr/sbin/httpd --with-wfsclient --with-wmsclient --enable-debug --with-curl-config=/usr/bin/curl-config --with-proj=/usr/local --with-tiff --with-gd=/usr/share/locale/ --with-jpeg --with-freetype=/usr/lib64/ --with-threads --with-wcs --with-postgis=/usr/local/database/bin/pg_config --with-libiconv=/usr --with-geos=/usr/local/geos-3.3.5/tools/geos-config --with-xml2-config=/usr/bin/xml2-config --with-sos but i have this error about freetype: checking if pkg-config path is provided... checking for pkg-config... /usr/bin/pkg-config checking for freetype-config... no checking for FT_Init_FreeType in -lfreetype... no configure: error: unable to link - reconfigure with correct --with-freetype=dir i checked freetype-2.3.11-14.el6_3.1.x86_64 is already installed Thanks in advance ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] build mapserver 6.2 freetype error
don't specify the paths for libraries/dependencies that are in default locations, i.e. ./configure --with-ogr --with-gdal --with-wfsclient --with-wmsclient --enable-debug --with-proj --with-gd --with-jpeg --with-freetype --with-threads --with-wcs --with-postgis=/usr/local/database/bin/pg_config --with-geos --with-sos On 13 March 2013 10:35, Icadedt icad...@yahoo.fr wrote: hi, im trying to build mapserver 6.2: i type this: ./configure --with-ogr=/usr/bin/gdal-config --with-gdal=/usr/bin/gdal-config --with-httpd=/usr/sbin/httpd --with-wfsclient --with-wmsclient --enable-debug --with-curl-config=/usr/bin/curl-config --with-proj=/usr/local --with-tiff --with-gd=/usr/share/locale/ --with-jpeg --with-freetype=/usr/lib64/ --with-threads --with-wcs --with-postgis=/usr/local/database/bin/pg_config --with-libiconv=/usr --with-geos=/usr/local/geos-3.3.5/tools/geos-config --with-xml2-config=/usr/bin/xml2-config --with-sos but i have this error about freetype: checking if pkg-config path is provided... checking for pkg-config... /usr/bin/pkg-config checking for freetype-config... no checking for FT_Init_FreeType in -lfreetype... no configure: error: unable to link - reconfigure with correct --with-freetype=dir i checked freetype-2.3.11-14.el6_3.1.x86_64 is already installed Thanks in advance ___ 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
[mapserver-users] postgis layers don't show up
Hi guys, I have one mapfile with conections to postgis layers and one raster. My problem is that the layers from postgis don't show up...If i make the request without the raster i got only white images... I have the debug level in 5 and I got no erros in all logs (including apache)... The permissions of the database are correct because I tried accessing with qgis and it worked fine. I'm also try specified the projection (using srid = 27493) but without sucess... I'm also tried add one of the Iayers of db but from a shape and worked fine... Furthermore, very strange is that when I try to run mapfile with pmapper, I can search for attributes and zoom to the correct areas (despite can't see geometries) ... Anybody have an idea? Thanks SO: Ubuntu server MapServer version 6.0.1 ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] postgis layers don't show up
Hello, Could you post you layer object from your mapfile? Does the log says something about your postgis table? Thanks, Y. Le mercredi 13 mars 2013 11:40:29 Pedro Costa a écrit : Hi guys, I have one mapfile with conections to postgis layers and one raster. My problem is that the layers from postgis don't show up...If i make the request without the raster i got only white images... I have the debug level in 5 and I got no erros in all logs (including apache)... The permissions of the database are correct because I tried accessing with qgis and it worked fine. I'm also try specified the projection (using srid = 27493) but without sucess... I'm also tried add one of the Iayers of db but from a shape and worked fine... Furthermore, very strange is that when I try to run mapfile with pmapper, I can search for attributes and zoom to the correct areas (despite can't see geometries) ... Anybody have an idea? Thanks SO: Ubuntu server MapServer version 6.0.1 ___ 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
Re: [mapserver-users] postgis layers don't show up
Ok, i got some information [1] I can see that mapserver tried get the layersBut no errors, i think... [1] http://pastebin.com/fmnBLWcw Em 13-03-2013 12:53, Yves Jacolin (Free) escreveu: Hello, Could you try to add: DEBUG 5 in the LAYER object. You can find some useful information in the mapserver log and see the request sent by MapServer. Regards, Y. Le mercredi 13 mars 2013 12:26:31 Pedro Costa a écrit : Hi, Yes, sure... No, nothing about the table Thanks LAYER NAME ruas STATUS DEFAULT TYPE LINE CONNECTIONTYPE postgis PROCESSING CLOSE_CONNECTION=DEFER CONNECTION user=pedro password=** dbname=norte host=localhost options='-c client_encoding=LATIN1' DATA the_geom from ruas using unique n_rua using srid=27492 TOLERANCE 3 TOLERANCEUNITS pixels TEMPLATE void PROJECTION init=epsg:27492 END METADATA DESCRIPTION Ruas RESULT_FIELDS n_rua RESULT_HEADERS ID ows_title Ruas END # Metadata CLASS Name 'ruas' COLOR 0 0 0 END # Class END Em 13-03-2013 12:21, Yves Jacolin (Free) escreveu: Hello, Could you post you layer object from your mapfile? Does the log says something about your postgis table? Thanks, Y. Le mercredi 13 mars 2013 11:40:29 Pedro Costa a écrit : Hi guys, I have one mapfile with conections to postgis layers and one raster. My problem is that the layers from postgis don't show up...If i make the request without the raster i got only white images... I have the debug level in 5 and I got no erros in all logs (including apache)... The permissions of the database are correct because I tried accessing with qgis and it worked fine. I'm also try specified the projection (using srid = 27493) but without sucess... I'm also tried add one of the Iayers of db but from a shape and worked fine... Furthermore, very strange is that when I try to run mapfile with pmapper, I can search for attributes and zoom to the correct areas (despite can't see geometries) ... Anybody have an idea? Thanks SO: Ubuntu server MapServer version 6.0.1 ___ 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
Re: [mapserver-users] postgis layers don't show up
On 2013-03-13 8:40 AM, Pedro Costa wrote: Hi guys, I have one mapfile with conections to postgis layers and one raster. My problem is that the layers from postgis don't show up...If i make the request without the raster i got only white images... I have the debug level in 5 and I got no erros in all logs (including apache)... The permissions of the database are correct because I tried accessing with qgis and it worked fine. I'm also try specified the projection (using srid = 27493) but without sucess... I'm also tried add one of the Iayers of db but from a shape and worked fine... Furthermore, very strange is that when I try to run mapfile with pmapper, I can search for attributes and zoom to the correct areas (despite can't see geometries) ... Anybody have an idea? Here is what I do when this happens to me: - copy mapfile into new name - use new named mapfile for testing - remove all layers - execute ogrinfo to the Postgres DB - use the extents returned from ogrinfo from one pg/postgis layer as the EXTENT parameter in your mapfile - remove all projection objects in mapfile - add one layer to the mapfile, for that same ogrinfo/postgis layer (with no projection object) - test with shp2img utility Hope that process helps. Once that works you can start working forward with more layers or debug as you go. -jeff -- Jeff McKenna MapServer Consulting and Training Services http://www.gatewaygeomatics.com/ ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] postgis layers don't show up
Hum, are you sure about your projection or the bbox requested? MapServer send the request to Postgresql but get 0 record. Y. Le mercredi 13 mars 2013 14:50:01 Pedro Costa a écrit : Ok, i got some information [1] I can see that mapserver tried get the layersBut no errors, i think... [1] http://pastebin.com/fmnBLWcw Em 13-03-2013 12:53, Yves Jacolin (Free) escreveu: Hello, Could you try to add: DEBUG 5 in the LAYER object. You can find some useful information in the mapserver log and see the request sent by MapServer. Regards, Y. Le mercredi 13 mars 2013 12:26:31 Pedro Costa a écrit : Hi, Yes, sure... No, nothing about the table Thanks LAYER NAME ruas STATUS DEFAULT TYPE LINE CONNECTIONTYPE postgis PROCESSING CLOSE_CONNECTION=DEFER CONNECTION user=pedro password=** dbname=norte host=localhost options='-c client_encoding=LATIN1' DATA the_geom from ruas using unique n_rua using srid=27492 TOLERANCE 3 TOLERANCEUNITS pixels TEMPLATE void PROJECTION init=epsg:27492 END METADATA DESCRIPTION Ruas RESULT_FIELDS n_rua RESULT_HEADERS ID ows_title Ruas END # Metadata CLASS Name 'ruas' COLOR 0 0 0 END # Class END Em 13-03-2013 12:21, Yves Jacolin (Free) escreveu: Hello, Could you post you layer object from your mapfile? Does the log says something about your postgis table? Thanks, Y. Le mercredi 13 mars 2013 11:40:29 Pedro Costa a écrit : Hi guys, I have one mapfile with conections to postgis layers and one raster. My problem is that the layers from postgis don't show up...If i make the request without the raster i got only white images... I have the debug level in 5 and I got no erros in all logs (including apache)... The permissions of the database are correct because I tried accessing with qgis and it worked fine. I'm also try specified the projection (using srid = 27493) but without sucess... I'm also tried add one of the Iayers of db but from a shape and worked fine... Furthermore, very strange is that when I try to run mapfile with pmapper, I can search for attributes and zoom to the correct areas (despite can't see geometries) ... Anybody have an idea? Thanks SO: Ubuntu server MapServer version 6.0.1 ___ 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
Re: [mapserver-users] postgis layers don't show up
I should be able to get the SQL query that mapserver is sending to postgresql. I would copy and paste is into pgadmin sql window and try it there. Then you can play with the sql to see what is going on. More than likely you have the wrong projection so something else similar. I use this in a lot of my mapfiles as do others so it is not a bug in the code. Also make sure you have not flipped long-lat to lat-long or something like that. -Steve On 3/13/2013 11:20 AM, Yves Jacolin (Free) wrote: Hum, are you sure about your projection or the bbox requested? MapServer send the request to Postgresql but get 0 record. Y. Le mercredi 13 mars 2013 14:50:01 Pedro Costa a écrit : Ok, i got some information [1] I can see that mapserver tried get the layersBut no errors, i think... [1] http://pastebin.com/fmnBLWcw Em 13-03-2013 12:53, Yves Jacolin (Free) escreveu: Hello, Could you try to add: DEBUG 5 in the LAYER object. You can find some useful information in the mapserver log and see the request sent by MapServer. Regards, Y. Le mercredi 13 mars 2013 12:26:31 Pedro Costa a écrit : Hi, Yes, sure... No, nothing about the table Thanks LAYER NAME ruas STATUS DEFAULT TYPE LINE CONNECTIONTYPE postgis PROCESSING CLOSE_CONNECTION=DEFER CONNECTION user=pedro password=** dbname=norte host=localhost options='-c client_encoding=LATIN1' DATA the_geom from ruas using unique n_rua using srid=27492 TOLERANCE 3 TOLERANCEUNITS pixels TEMPLATE void PROJECTION init=epsg:27492 END METADATA DESCRIPTION Ruas RESULT_FIELDS n_rua RESULT_HEADERS ID ows_title Ruas END # Metadata CLASS Name 'ruas' COLOR 0 0 0 END # Class END Em 13-03-2013 12:21, Yves Jacolin (Free) escreveu: Hello, Could you post you layer object from your mapfile? Does the log says something about your postgis table? Thanks, Y. Le mercredi 13 mars 2013 11:40:29 Pedro Costa a écrit : Hi guys, I have one mapfile with conections to postgis layers and one raster. My problem is that the layers from postgis don't show up...If i make the request without the raster i got only white images... I have the debug level in 5 and I got no erros in all logs (including apache)... The permissions of the database are correct because I tried accessing with qgis and it worked fine. I'm also try specified the projection (using srid = 27493) but without sucess... I'm also tried add one of the Iayers of db but from a shape and worked fine... Furthermore, very strange is that when I try to run mapfile with pmapper, I can search for attributes and zoom to the correct areas (despite can't see geometries) ... Anybody have an idea? Thanks SO: Ubuntu server MapServer version 6.0.1 ___ 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 ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] postgis layers don't show up
I think like others that the problem could be in srid definition. Remember that you need to define an srid for the mapfile and an srid for each layer in the mapfile. When using postgis connectiontype I also put using srid=yourPostGisLayerSrid in the DATA sql statement of the layer (mandatory? I don't know, but it works) Hope this helps. Best Regards, Carlo Il 13/03/2013 12:40, Pedro Costa ha scritto: Hi guys, I have one mapfile with conections to postgis layers and one raster. My problem is that the layers from postgis don't show up...If i make the request without the raster i got only white images... I have the debug level in 5 and I got no erros in all logs (including apache)... The permissions of the database are correct because I tried accessing with qgis and it worked fine. I'm also try specified the projection (using srid = 27493) but without sucess... I'm also tried add one of the Iayers of db but from a shape and worked fine... Furthermore, very strange is that when I try to run mapfile with pmapper, I can search for attributes and zoom to the correct areas (despite can't see geometries) ... Anybody have an idea? Thanks SO: Ubuntu server MapServer version 6.0.1 ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users -- Carlo Pelliconi - www.sis-ter.it !* proteggiamo l'ambiente: stampa questa mail solo se necessario *! ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] postgis layers don't show up
Thanks to all. The problem is the query.despite don't give me any error returns 0 features... This happens because the 'where with the polygon' [1]... Anybody knows the origin of that polygon? select encode(ST_AsBinary(ST_Force_2D(the_geom),'NDR'),'hex') as geom,n_rua from ruas where the_geom GeomFromText('POLYGON((88071.2044330519 122184.53,88071.2044330519 124022.08,91531.2955669481 124022.08,91531.2955669481 122184.53,88071.2044330519 122184.53))',27492) Em 13-03-2013 16:54, Carlo Pelliconi escreveu: I think like others that the problem could be in srid definition. Remember that you need to define an srid for the mapfile and an srid for each layer in the mapfile. When using postgis connectiontype I also put using srid=yourPostGisLayerSrid in the DATA sql statement of the layer (mandatory? I don't know, but it works) Hope this helps. Best Regards, Carlo Il 13/03/2013 12:40, Pedro Costa ha scritto: Hi guys, I have one mapfile with conections to postgis layers and one raster. My problem is that the layers from postgis don't show up...If i make the request without the raster i got only white images... I have the debug level in 5 and I got no erros in all logs (including apache)... The permissions of the database are correct because I tried accessing with qgis and it worked fine. I'm also try specified the projection (using srid = 27493) but without sucess... I'm also tried add one of the Iayers of db but from a shape and worked fine... Furthermore, very strange is that when I try to run mapfile with pmapper, I can search for attributes and zoom to the correct areas (despite can't see geometries) ... Anybody have an idea? Thanks SO: Ubuntu server MapServer version 6.0.1 ___ 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
Re: [mapserver-users] postgis layers don't show up
The polygon is the bounding box of the image that you requested. Mapserver only needs the geometries the cross of the map image and this is what the where clause is doing. Why do you thin this is not correct? What does the top of you mapfile look like and what does this LAYER definition look like? -Steve W On 3/13/2013 1:12 PM, Pedro Costa wrote: Thanks to all. The problem is the query.despite don't give me any error returns 0 features... This happens because the 'where with the polygon' [1]... Anybody knows the origin of that polygon? select encode(ST_AsBinary(ST_Force_2D(the_geom),'NDR'),'hex') as geom,n_rua from ruas where the_geom GeomFromText('POLYGON((88071.2044330519 122184.53,88071.2044330519 124022.08,91531.2955669481 124022.08,91531.2955669481 122184.53,88071.2044330519 122184.53))',27492) Em 13-03-2013 16:54, Carlo Pelliconi escreveu: I think like others that the problem could be in srid definition. Remember that you need to define an srid for the mapfile and an srid for each layer in the mapfile. When using postgis connectiontype I also put using srid=yourPostGisLayerSrid in the DATA sql statement of the layer (mandatory? I don't know, but it works) Hope this helps. Best Regards, Carlo Il 13/03/2013 12:40, Pedro Costa ha scritto: Hi guys, I have one mapfile with conections to postgis layers and one raster. My problem is that the layers from postgis don't show up...If i make the request without the raster i got only white images... I have the debug level in 5 and I got no erros in all logs (including apache)... The permissions of the database are correct because I tried accessing with qgis and it worked fine. I'm also try specified the projection (using srid = 27493) but without sucess... I'm also tried add one of the Iayers of db but from a shape and worked fine... Furthermore, very strange is that when I try to run mapfile with pmapper, I can search for attributes and zoom to the correct areas (despite can't see geometries) ... Anybody have an idea? Thanks SO: Ubuntu server MapServer version 6.0.1 ___ 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 ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] postgis layers don't show up
Yes, i confirmed that right now, its the bb but i don't understand the problem because in other server (with the same coordinates) this works fine. i'm also confirmed the extent in qgis and its correct... my mapfile top data: EXTENT 88386.2 122329.41 91216.3 124022.08 UNITS meters SIZE 500 500 SHAPEPATH shape SYMBOLSET ../common/symbols/symbols-pmapper.sym FONTSET ../common/fonts/msfontset.txt RESOLUTION 96 IMAGETYPE png INTERLACE OFF PROJECTION init=epsg:27493 END my layer: LAYER NAME ruas STATUS DEFAULT DEBUG 5 TYPE LINE CONNECTIONTYPE postgis PROCESSING CLOSE_CONNECTION=DEFERl CONNECTION user=pedro password=** dbname=norte host=localhost options='-c client_encoding=LATIN1' DATA the_geom from ruas using unique n_rua using srid=27493 TOLERANCE 3 TOLERANCEUNITS pixels TEMPLATE void PROJECTION init=epsg:27493 END METADATA DESCRIPTION Ruas RESULT_FIELDS id RESULT_HEADERS id ows_title Ruas END # Metadata CLASS Name 'ruas' COLOR 0 0 0 END # Class END Em 13-03-2013 17:14, Stephen Woodbridge escreveu: The polygon is the bounding box of the image that you requested. Mapserver only needs the geometries the cross of the map image and this is what the where clause is doing. Why do you thin this is not correct? What does the top of you mapfile look like and what does this LAYER definition look like? -Steve W On 3/13/2013 1:12 PM, Pedro Costa wrote: Thanks to all. The problem is the query.despite don't give me any error returns 0 features... This happens because the 'where with the polygon' [1]... Anybody knows the origin of that polygon? select encode(ST_AsBinary(ST_Force_2D(the_geom),'NDR'),'hex') as geom,n_rua from ruas where the_geom GeomFromText('POLYGON((88071.2044330519 122184.53,88071.2044330519 124022.08,91531.2955669481 124022.08,91531.2955669481 122184.53,88071.2044330519 122184.53))',27492) Em 13-03-2013 16:54, Carlo Pelliconi escreveu: I think like others that the problem could be in srid definition. Remember that you need to define an srid for the mapfile and an srid for each layer in the mapfile. When using postgis connectiontype I also put using srid=yourPostGisLayerSrid in the DATA sql statement of the layer (mandatory? I don't know, but it works) Hope this helps. Best Regards, Carlo Il 13/03/2013 12:40, Pedro Costa ha scritto: Hi guys, I have one mapfile with conections to postgis layers and one raster. My problem is that the layers from postgis don't show up...If i make the request without the raster i got only white images... I have the debug level in 5 and I got no erros in all logs (including apache)... The permissions of the database are correct because I tried accessing with qgis and it worked fine. I'm also try specified the projection (using srid = 27493) but without sucess... I'm also tried add one of the Iayers of db but from a shape and worked fine... Furthermore, very strange is that when I try to run mapfile with pmapper, I can search for attributes and zoom to the correct areas (despite can't see geometries) ... Anybody have an idea? Thanks SO: Ubuntu server MapServer version 6.0.1 ___ 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 ___ 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
Re: [mapserver-users] postgis layers don't show up
Em 13-03-2013 17:39, Stephen Woodbridge escreveu: So What do you get in pgadmin or psql with: select count(*) from ruas where the_geom GeomFromText('POLYGON((88071.2044330519 122184.53,88071.2044330519 124022.08,91531.2955669481 124022.08,91531.2955669481 122184.53,88071.2044330519 122184.53))',27492); nothing...count = 0... select st_astext(st_extents(st_collect(the_geom))) from ruas; Previously i have compared the result of 'st_extent' with extent in mapfile and its the same Your query with st_collects give me an error (ERROR: aggregate function calls cannot be nested) -Steve On 3/13/2013 1:22 PM, Pedro Costa wrote: Yes, i confirmed that right now, its the bb but i don't understand the problem because in other server (with the same coordinates) this works fine. i'm also confirmed the extent in qgis and its correct... my mapfile top data: EXTENT 88386.2 122329.41 91216.3 124022.08 UNITS meters SIZE 500 500 SHAPEPATH shape SYMBOLSET ../common/symbols/symbols-pmapper.sym FONTSET ../common/fonts/msfontset.txt RESOLUTION 96 IMAGETYPE png INTERLACE OFF PROJECTION init=epsg:27493 END my layer: LAYER NAME ruas STATUS DEFAULT DEBUG 5 TYPE LINE CONNECTIONTYPE postgis PROCESSING CLOSE_CONNECTION=DEFERl CONNECTION user=pedro password=** dbname=norte host=localhost options='-c client_encoding=LATIN1' DATA the_geom from ruas using unique n_rua using srid=27493 TOLERANCE 3 TOLERANCEUNITS pixels TEMPLATE void PROJECTION init=epsg:27493 END METADATA DESCRIPTION Ruas RESULT_FIELDS id RESULT_HEADERS id ows_title Ruas END # Metadata CLASS Name 'ruas' COLOR 0 0 0 END # Class END Em 13-03-2013 17:14, Stephen Woodbridge escreveu: The polygon is the bounding box of the image that you requested. Mapserver only needs the geometries the cross of the map image and this is what the where clause is doing. Why do you thin this is not correct? What does the top of you mapfile look like and what does this LAYER definition look like? -Steve W On 3/13/2013 1:12 PM, Pedro Costa wrote: Thanks to all. The problem is the query.despite don't give me any error returns 0 features... This happens because the 'where with the polygon' [1]... Anybody knows the origin of that polygon? select encode(ST_AsBinary(ST_Force_2D(the_geom),'NDR'),'hex') as geom,n_rua from ruas where the_geom GeomFromText('POLYGON((88071.2044330519 122184.53,88071.2044330519 124022.08,91531.2955669481 124022.08,91531.2955669481 122184.53,88071.2044330519 122184.53))',27492) Em 13-03-2013 16:54, Carlo Pelliconi escreveu: I think like others that the problem could be in srid definition. Remember that you need to define an srid for the mapfile and an srid for each layer in the mapfile. When using postgis connectiontype I also put using srid=yourPostGisLayerSrid in the DATA sql statement of the layer (mandatory? I don't know, but it works) Hope this helps. Best Regards, Carlo Il 13/03/2013 12:40, Pedro Costa ha scritto: Hi guys, I have one mapfile with conections to postgis layers and one raster. My problem is that the layers from postgis don't show up...If i make the request without the raster i got only white images... I have the debug level in 5 and I got no erros in all logs (including apache)... The permissions of the database are correct because I tried accessing with qgis and it worked fine. I'm also try specified the projection (using srid = 27493) but without sucess... I'm also tried add one of the Iayers of db but from a shape and worked fine... Furthermore, very strange is that when I try to run mapfile with pmapper, I can search for attributes and zoom to the correct areas (despite can't see geometries) ... Anybody have an idea? Thanks SO: Ubuntu server MapServer version 6.0.1 ___ 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 ___ 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 ___ 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
Re: [mapserver-users] postgis layers don't show up
On 3/13/2013 1:49 PM, Pedro Costa wrote: Em 13-03-2013 17:39, Stephen Woodbridge escreveu: So What do you get in pgadmin or psql with: select count(*) from ruas where the_geom GeomFromText('POLYGON((88071.2044330519 122184.53,88071.2044330519 124022.08,91531.2955669481 124022.08,91531.2955669481 122184.53,88071.2044330519 122184.53))',27492); nothing...count = 0... This means there is some kind of disconnect between the data in the database and how you have it defined in the mapfile. select st_astext(st_extents(st_collect(the_geom))) from ruas; Previously i have compared the result of 'st_extent' with extent in mapfile and its the same Your query with st_collects give me an error (ERROR: aggregate function calls cannot be nested) Try: select st_astext(st_extents(the_geom)) from ruas; Once you get this you will have the min and max extents of the data in the database and you can compare that to the polygon above and see if it overlaps. -Steve -Steve On 3/13/2013 1:22 PM, Pedro Costa wrote: Yes, i confirmed that right now, its the bb but i don't understand the problem because in other server (with the same coordinates) this works fine. i'm also confirmed the extent in qgis and its correct... my mapfile top data: EXTENT 88386.2 122329.41 91216.3 124022.08 UNITS meters SIZE 500 500 SHAPEPATH shape SYMBOLSET ../common/symbols/symbols-pmapper.sym FONTSET ../common/fonts/msfontset.txt RESOLUTION 96 IMAGETYPE png INTERLACE OFF PROJECTION init=epsg:27493 END my layer: LAYER NAME ruas STATUS DEFAULT DEBUG 5 TYPE LINE CONNECTIONTYPE postgis PROCESSING CLOSE_CONNECTION=DEFERl CONNECTION user=pedro password=** dbname=norte host=localhost options='-c client_encoding=LATIN1' DATA the_geom from ruas using unique n_rua using srid=27493 TOLERANCE 3 TOLERANCEUNITS pixels TEMPLATE void PROJECTION init=epsg:27493 END METADATA DESCRIPTION Ruas RESULT_FIELDS id RESULT_HEADERS id ows_title Ruas END # Metadata CLASS Name 'ruas' COLOR 0 0 0 END # Class END Em 13-03-2013 17:14, Stephen Woodbridge escreveu: The polygon is the bounding box of the image that you requested. Mapserver only needs the geometries the cross of the map image and this is what the where clause is doing. Why do you thin this is not correct? What does the top of you mapfile look like and what does this LAYER definition look like? -Steve W On 3/13/2013 1:12 PM, Pedro Costa wrote: Thanks to all. The problem is the query.despite don't give me any error returns 0 features... This happens because the 'where with the polygon' [1]... Anybody knows the origin of that polygon? select encode(ST_AsBinary(ST_Force_2D(the_geom),'NDR'),'hex') as geom,n_rua from ruas where the_geom GeomFromText('POLYGON((88071.2044330519 122184.53,88071.2044330519 124022.08,91531.2955669481 124022.08,91531.2955669481 122184.53,88071.2044330519 122184.53))',27492) Em 13-03-2013 16:54, Carlo Pelliconi escreveu: I think like others that the problem could be in srid definition. Remember that you need to define an srid for the mapfile and an srid for each layer in the mapfile. When using postgis connectiontype I also put using srid=yourPostGisLayerSrid in the DATA sql statement of the layer (mandatory? I don't know, but it works) Hope this helps. Best Regards, Carlo Il 13/03/2013 12:40, Pedro Costa ha scritto: Hi guys, I have one mapfile with conections to postgis layers and one raster. My problem is that the layers from postgis don't show up...If i make the request without the raster i got only white images... I have the debug level in 5 and I got no erros in all logs (including apache)... The permissions of the database are correct because I tried accessing with qgis and it worked fine. I'm also try specified the projection (using srid = 27493) but without sucess... I'm also tried add one of the Iayers of db but from a shape and worked fine... Furthermore, very strange is that when I try to run mapfile with pmapper, I can search for attributes and zoom to the correct areas (despite can't see geometries) ... Anybody have an idea? Thanks SO: Ubuntu server MapServer version 6.0.1 ___ 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 ___ 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