[mapserver-users] Oracle Spatial
I am querying an Oracle Spatial table. I am restricting the query using an attribute in the table (road type). In examining the query sent to Oracle, it seems to query by attribute first, then by spatial envelope. For datasets that only return a few features in the attribute query, this seems fairly efficient. However, for datasets that return many features in the attribute query that lie over a large spatial area, it would seem more efficient to limit by spatial envelope first, then by attributes, especially if the query area is relatively small compared to the spatial extent of the dataset. Can the user be allowed to set the spatial/attribute query order? Example query - attribute query is executed first, then spatial. For small spatial areas, the query might be faster if the spatial filter were executed first. DATA "SHAPE FROM (SELECT SHAPE FROM ROAD_TABLE WHERE DESG IN ('CST','CRD')) USING SRID 8307" Stuart Harlan Senior Information Systems Technologist GIS Web Services Transportation Planning Division Missouri Department of Transportation___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] Re: Postgis itemquery help
Hi niko, first of all try to activate error log file in mapserver: CONFIG "MS_ERRORFILE" "/tmp/mapserver.log" Then I think you should escape some character in your query URL. In example "&qstring=(%5Bcynara%5D%3E1.0)" and not "&qstring=([cynara] > 1.0)". This is a page with some URL Escape Codes: http://www.december.com/html/spec/esccodes.html I think that you will find the solution looking at log file. Best regards, a - Andrea Borruso email: aborr...@tin.it website: http://blog.spaziogis.it my 2.0 life: http://aborruso.spaziogis.it feed: http://feeds2.feedburner.com/Tanto 38° 7' 48" N, 13° 21' 9" E -- View this message in context: http://osgeo-org.1803224.n2.nabble.com/Postgis-itemquery-help-tp6377156p6412379.html Sent from the Mapserver - User mailing list archive at Nabble.com. ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] European Weather Data WMS
For northern Europe you can check: http://openmetoc.met.no/about.html Håvard Tveite On 27/05/11 18:45, Matt Miller wrote: Does anyone know of a source of weather data in WMS format for Europe and parts of North African and the middle east? I am using http://mesonet.agron.iastate.edu/cgi-bin/wms/goes/conus_ir.cgi for the continental US but I am having a hard time finding sources for other parts of the world. Thanks for the help, and I'm sorry if this is a dumb question. Matt Miller ___ 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] European Weather Data WMS
Does anyone know of a source of weather data in WMS format for Europe and parts of North African and the middle east? I am using http://mesonet.agron.iastate.edu/cgi-bin/wms/goes/conus_ir.cgi for the continental US but I am having a hard time finding sources for other parts of the world. Thanks for the help, and I'm sorry if this is a dumb question. Matt Miller ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] mapserver6 (was 5) postgis connection problem
On 05/27/2011 05:28 PM, Stephen Woodbridge wrote: > 1. are you running selinux? try disabling this to see if the problem > goes away That's the trick Grmpf Thanks grmbl grmbl MyFirstRedHat Disabled it with temporarily with: setenforce 0 Thanks!! Richard ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] mapserver6 (was 5) postgis connection problem
On 5/27/2011 11:24 AM, Richard Duivenvoorde wrote: On 05/27/2011 04:36 PM, Carlos Ruiz wrote: I can see a "t" password (5 chars) with Geoserver test and a "***" password (7 chars) with Mapserver test, are you sure that you're using the same password ??? The t is just me hiding a password. And if that was the problem, the command line calls would have failed also? Also, if you're using HBA, you have to do the Geoserver and the Mapserver test in the same machine because the ip address. both database, mapserver and geoserver are all on 1 virtual machine. Richard, The only other things that I can think of that might be going on is that: 1. are you running selinux? try disabling this to see if the problem goes away 2. that the LD_LIBRARY_PATH in apache does not include the libraries that are getting used at the commandline. or that you have multiple copies of the libraries installed, some from rpms and some from what you compiled and different stuff is being used under apache vs the commandline -Steve W ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] mapserver6 (was 5) postgis connection problem
On 05/27/2011 04:36 PM, Carlos Ruiz wrote: > I can see a "t" password (5 chars) with Geoserver test and a > "***" password (7 chars) with Mapserver test, are you sure > that you're using the same password ??? The t is just me hiding a password. And if that was the problem, the command line calls would have failed also? > Also, if you're using HBA, you have to do the Geoserver and the > Mapserver test in the same machine because the ip address. both database, mapserver and geoserver are all on 1 virtual machine. Thanks, Richard ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] Legend and styles
Hi! I've made a map file with a layer that has two styles like so: LAYER GROUP "LayerGroup" NAME"TheLayer" CLASSGROUP "blue" ... CLASS NAME "The blue class" GROUP "blue" STYLE SYMBOL "CIRCLE" SIZE 10 WIDTH 2 COLOR 0 0 255 END END CLASS NAME "The red class" GROUP "red" STYLE SYMBOL "CIRCLE" SIZE 10 WIDTH 2 COLOR 255 0 0 END END END Setting styles=red in a GetMap request will change the color of the circles, but the same does not work with GetLegendGraphic. Please help! Thanks! /Matti -- View this message in context: http://osgeo-org.1803224.n2.nabble.com/Legend-and-styles-tp6411331p6411331.html Sent from the Mapserver - User mailing list archive at Nabble.com. ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] mapserver6 (was 5) postgis connection problem
Richard, Just checking for the most common errors, and taking a look at this fragment of the layer's debug dump: [Thu May 26 23:45:30 2011].568123 msPostGISLayerOpen(): Query error. Database connection failed (could not connect to server: Permission denied Is the server running on host "localhost" and accepting TCP/IP connections on port 5432? could not connect to server: Permission denied Is the server running on host "localhost" and accepting TCP/IP connections on port 5432? Using GeoServer, you have posted this connection string: host=localhost dbname=osm password=t user=geo Using Mapserver, you have posted this other connection string: host=localhost dbname=osm password=*** user=geo You receive a "Database connection failed (could not connect to server: Permission denied)", this means that there's a problem with the connection parameters. I can see a "t" password (5 chars) with Geoserver test and a "***" password (7 chars) with Mapserver test, are you sure that you're using the same password ??? Also, if you're using HBA, you have to do the Geoserver and the Mapserver test in the same machine because the ip address. Cheers from México IC Carlos Ruiz From: Richard Duivenvoorde To: mapserver-users@lists.osgeo.org Sent: Friday, May 27, 2011 4:18 AM Subject: Re: [mapserver-users] mapserver6 (was 5) postgis connection problem Sorry for wrong subject, I'm talking about mapserver6 here. Ok, don't think it is a postgres/postgis problem... Installed geoserver, and that is serving fine Als0 tried mapserv from command line: ./mapserv -nh "QUERY_STRING=map=osmwm.map&mode=map" > /tmp/test11.png also ok mapfile snippet: LAYER NAME test TYPE polygon STATUS default DEBUG 5 CONNECTIONTYPE postgis CONNECTION "host=localhost dbname=osm password=t user=geo" DATA "way28992 from (select * from landuse2) as foo using unique osm_id using srid=28992" FILTER "landuse in ('industrial', 'residential')" METADATA "WMS_TITLE" "test" "WMS_SRS" "EPSG:28992" "OWS_EXTENT" "-26000 296000 293000 634000" END CLASS STYLE COLOR 255 0 0 END STYLE OUTLINECOLOR 0 0 0 WIDTH 3 ANTIALIAS TRUE END END #CLASS END On 05/26/2011 11:58 PM, Richard Duivenvoorde wrote: > Like somebody else in the list I have a strange problem with MS6 on a > fresh RHEL6 machine. Running the same data and mapfile in an older MS works. > Below as much info I could get. > Anybody a clue? > I can recompile or add debug statements if nessecary (will be on irc > tomorrow morning) > > Regards, > > Richard Duivenvoorde > > > I fail to get a postgres connection log somewhere on this machine... > > a new installed RHEL6 machine: > Red Hat Enterprise Linux Server release 6.0 (Santiago) > > running > "PostgreSQL 8.4.8 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) > 4.4.4 20100726 (Red Hat 4.4.4-13), 64-bit" > and > "1.5 USE_GEOS=1 USE_PROJ=1 USE_STATS=1" > > mapserver -v gives > MapServer version 6.0.0 OUTPUT=GIF OUTPUT=PNG OUTPUT=JPEG OUTPUT=KML > SUPPORTS=PROJ SUPPORTS=AGG SUPPORTS=FREETYPE SUPPORTS=ICONV > SUPPORTS=WMS_SERVER SUPPORTS=WMS_CLIENT SUPPORTS=WFS_SERVER > SUPPORTS=WCS_SERVER INPUT=POSTGIS INPUT=OGR INPUT=GDAL INPUT=SHAPEFILE > > I've done a gdal and mapserver compile myself > > A database with OSM data and mapfile with connectionstring like: > CONNECTION "host=localhost dbname=osm password= user=geo" > keeps saying: > Permission denied Is the server running on host "localhost" and > accepting TCP/IP connections on port 5432? ) with connect string > 'host=localhost dbname=osm password=*** user=geo' > > while: > - I can connect with that user/password via psql > - can use shp2img and the same mapfile (generating a map) > - can do > ogrinfo -ro PG:'host=localhost user=geo password=xx dbname=osm' -sql > "select count(*) from mytable" > - even tried trust for all hosts in pg_hba.conf > > setting debug in LAYER at 5 > > -- first part is from wms request (failing connection): > [Thu May 26 23:45:30 2011].566614 msPostGISLayerOpen called: way28992 > from nl_osm_point using unique osm_id using srid=28992 > [Thu May 26 23:45:30 2011].566704 msPostGISLayerOpen: No connection in > pool, creating a fresh one. > [Thu May 26 23:45:30 2011].568103 msPostGISLayerOpen: Connection failure. > [Thu May 26 23:45:30 2011].568123 msPostGISLayerOpen(): Query error. > Database connection failed (could not connect to server: Permission denied > Is the server running on host "localhost" and accepting > TCP/IP connections on port 5432? > could not connect to server: Permission denied > Is the server running on host "localhost" and accepting > TCP/IP connections on port 5432? > ) with connect string 'host=localhost dbname=osm password=*** use
Re: [mapserver-users] mapserver6 (was 5) postgis connection problem
On 05/27/2011 02:32 PM, Stephen Woodbridge wrote: > sudo -u ./mapserv -nh > "QUERY_STRING=map=osmwm.map&mode=map"> /tmp/test11.png Ok thanks for you tip, tried both these version: sudo -u apache ./mapserv -nh QUERY_STRING='map=osmwm.map&mode=map' > /tmp/test20.png sudo su -s /bin/sh apache -c "./mapserv -nh 'QUERY_STRING=map=osmwm.map&mode=map' > /tmp/test19.png" and BOTH are working and generating png's (while looking into 'top' to see if it was indeed the user 'apache' which was running the mapserver-command: it was) Still url below: is NOT: http://46.21.168.170/cgi-bin/mapserv?map=osmwm.map&mode=map Permission problem is the most obvious reason... What is special on running a cgi trying to connect to postgis? It's not trying to write to something is it? As said, I compiled both mapserver and gdal myself, which files need special permissions? Tested with a shapefile layer, that one is working ok Capabilities also: http://46.21.168.170/cgi-bin/mapserv?map=osmwm.map&service=wms&request=getcapabilities Regards, Richard ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] mapserver6 (was 5) postgis connection problem
What happens if you try: sudo -u ./mapserv -nh "QUERY_STRING=map=osmwm.map&mode=map"> /tmp/test11.png This might be a permission problem somewhere. -Steve W On 5/27/2011 5:18 AM, Richard Duivenvoorde wrote: Sorry for wrong subject, I'm talking about mapserver6 here. Ok, don't think it is a postgres/postgis problem... Installed geoserver, and that is serving fine Als0 tried mapserv from command line: ./mapserv -nh "QUERY_STRING=map=osmwm.map&mode=map"> /tmp/test11.png also ok mapfile snippet: LAYER NAME test TYPE polygon STATUS default DEBUG 5 CONNECTIONTYPE postgis CONNECTION "host=localhost dbname=osm password=t user=geo" DATA "way28992 from (select * from landuse2) as foo using unique osm_id using srid=28992" FILTER "landuse in ('industrial', 'residential')" METADATA "WMS_TITLE" "test" "WMS_SRS" "EPSG:28992" "OWS_EXTENT""-26000 296000 293000 634000" END CLASS STYLE COLOR 255 0 0 END STYLE OUTLINECOLOR 0 0 0 WIDTH 3 ANTIALIAS TRUE END END #CLASS END On 05/26/2011 11:58 PM, Richard Duivenvoorde wrote: Like somebody else in the list I have a strange problem with MS6 on a fresh RHEL6 machine. Running the same data and mapfile in an older MS works. Below as much info I could get. Anybody a clue? I can recompile or add debug statements if nessecary (will be on irc tomorrow morning) Regards, Richard Duivenvoorde I fail to get a postgres connection log somewhere on this machine... a new installed RHEL6 machine: Red Hat Enterprise Linux Server release 6.0 (Santiago) running "PostgreSQL 8.4.8 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 4.4.4 20100726 (Red Hat 4.4.4-13), 64-bit" and "1.5 USE_GEOS=1 USE_PROJ=1 USE_STATS=1" mapserver -v gives MapServer version 6.0.0 OUTPUT=GIF OUTPUT=PNG OUTPUT=JPEG OUTPUT=KML SUPPORTS=PROJ SUPPORTS=AGG SUPPORTS=FREETYPE SUPPORTS=ICONV SUPPORTS=WMS_SERVER SUPPORTS=WMS_CLIENT SUPPORTS=WFS_SERVER SUPPORTS=WCS_SERVER INPUT=POSTGIS INPUT=OGR INPUT=GDAL INPUT=SHAPEFILE I've done a gdal and mapserver compile myself A database with OSM data and mapfile with connectionstring like: CONNECTION "host=localhost dbname=osm password= user=geo" keeps saying: Permission denied Is the server running on host "localhost" and accepting TCP/IP connections on port 5432? ) with connect string 'host=localhost dbname=osm password=*** user=geo' while: - I can connect with that user/password via psql - can use shp2img and the same mapfile (generating a map) - can do ogrinfo -ro PG:'host=localhost user=geo password=xx dbname=osm' -sql "select count(*) from mytable" - even tried trust for all hosts in pg_hba.conf setting debug in LAYER at 5 -- first part is from wms request (failing connection): [Thu May 26 23:45:30 2011].566614 msPostGISLayerOpen called: way28992 from nl_osm_point using unique osm_id using srid=28992 [Thu May 26 23:45:30 2011].566704 msPostGISLayerOpen: No connection in pool, creating a fresh one. [Thu May 26 23:45:30 2011].568103 msPostGISLayerOpen: Connection failure. [Thu May 26 23:45:30 2011].568123 msPostGISLayerOpen(): Query error. Database connection failed (could not connect to server: Permission denied Is the server running on host "localhost" and accepting TCP/IP connections on port 5432? could not connect to server: Permission denied Is the server running on host "localhost" and accepting TCP/IP connections on port 5432? ) with connect string 'host=localhost dbname=osm password=*** user=geo' Is the database running? Is it allowing connections? Does the specified user exist? Is the password valid? Is the database on the standard port? [Thu May 26 23:45:30 2011].568138 msDrawMap(): Image handling error. Failed to draw layer named 'plaatsen'. [Thu May 26 23:45:30 2011].568224 msPostGISLayerClose called: way28992 from nl_osm_point using unique osm_id using srid=28992 [Thu May 26 23:45:30 2011].568238 freeLayer(): freeing layer at 0x1c67250. [Thu May 26 23:45:30 2011].568243 msPostGISLayerIsOpen called. [Thu May 26 23:45:30 2011].568251 freeLayer(): freeing layer at 0x1c6a7f0. [Thu May 26 23:45:30 2011].568255 msPostGISLayerIsOpen called. -- This part is from shp2img (connection succesfull): [Thu May 26 23:47:55 2011].3388 msLayerIsVisible(): Skipping layer (plaatsen) because no CLASS in the layer is in-scale for this MAP scale [Thu May 26 23:47:55 2011].3450 msLayerIsVisible(): Skipping layer (plaatsen) because no CLASS in the layer is in-scale for this MAP scale [Thu May 26 23:47:55 2011].3457 msLayerIsVisible(): Skipping layer (plaatsen) because no CLASS in the layer is in-scale for this MAP scale [Thu May 26 23:47:55 2011].3470 msPostGISLayerOpen called: way28992 from (select way28992, z_order, landuse, osm_id, name from nl_osm_polygon order by z_order) as foo using unique osm_id using srid=
Re: [mapserver-users] mapserver6 (was 5) postgis connection problem
Sorry for wrong subject, I'm talking about mapserver6 here. Ok, don't think it is a postgres/postgis problem... Installed geoserver, and that is serving fine Als0 tried mapserv from command line: ./mapserv -nh "QUERY_STRING=map=osmwm.map&mode=map" > /tmp/test11.png also ok mapfile snippet: LAYER NAME test TYPE polygon STATUS default DEBUG 5 CONNECTIONTYPE postgis CONNECTION "host=localhost dbname=osm password=t user=geo" DATA "way28992 from (select * from landuse2) as foo using unique osm_id using srid=28992" FILTER "landuse in ('industrial', 'residential')" METADATA "WMS_TITLE" "test" "WMS_SRS" "EPSG:28992" "OWS_EXTENT""-26000 296000 293000 634000" END CLASS STYLE COLOR 255 0 0 END STYLE OUTLINECOLOR 0 0 0 WIDTH 3 ANTIALIAS TRUE END END #CLASS END On 05/26/2011 11:58 PM, Richard Duivenvoorde wrote: > Like somebody else in the list I have a strange problem with MS6 on a > fresh RHEL6 machine. Running the same data and mapfile in an older MS works. > Below as much info I could get. > Anybody a clue? > I can recompile or add debug statements if nessecary (will be on irc > tomorrow morning) > > Regards, > > Richard Duivenvoorde > > > I fail to get a postgres connection log somewhere on this machine... > > a new installed RHEL6 machine: > Red Hat Enterprise Linux Server release 6.0 (Santiago) > > running > "PostgreSQL 8.4.8 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) > 4.4.4 20100726 (Red Hat 4.4.4-13), 64-bit" > and > "1.5 USE_GEOS=1 USE_PROJ=1 USE_STATS=1" > > mapserver -v gives > MapServer version 6.0.0 OUTPUT=GIF OUTPUT=PNG OUTPUT=JPEG OUTPUT=KML > SUPPORTS=PROJ SUPPORTS=AGG SUPPORTS=FREETYPE SUPPORTS=ICONV > SUPPORTS=WMS_SERVER SUPPORTS=WMS_CLIENT SUPPORTS=WFS_SERVER > SUPPORTS=WCS_SERVER INPUT=POSTGIS INPUT=OGR INPUT=GDAL INPUT=SHAPEFILE > > I've done a gdal and mapserver compile myself > > A database with OSM data and mapfile with connectionstring like: > CONNECTION "host=localhost dbname=osm password= user=geo" > keeps saying: > Permission denied Is the server running on host "localhost" and > accepting TCP/IP connections on port 5432? ) with connect string > 'host=localhost dbname=osm password=*** user=geo' > > while: > - I can connect with that user/password via psql > - can use shp2img and the same mapfile (generating a map) > - can do > ogrinfo -ro PG:'host=localhost user=geo password=xx dbname=osm' -sql > "select count(*) from mytable" > - even tried trust for all hosts in pg_hba.conf > > setting debug in LAYER at 5 > > -- first part is from wms request (failing connection): > [Thu May 26 23:45:30 2011].566614 msPostGISLayerOpen called: way28992 > from nl_osm_point using unique osm_id using srid=28992 > [Thu May 26 23:45:30 2011].566704 msPostGISLayerOpen: No connection in > pool, creating a fresh one. > [Thu May 26 23:45:30 2011].568103 msPostGISLayerOpen: Connection failure. > [Thu May 26 23:45:30 2011].568123 msPostGISLayerOpen(): Query error. > Database connection failed (could not connect to server: Permission denied > Is the server running on host "localhost" and accepting > TCP/IP connections on port 5432? > could not connect to server: Permission denied > Is the server running on host "localhost" and accepting > TCP/IP connections on port 5432? > ) with connect string 'host=localhost dbname=osm password=*** user=geo' > Is the database running? Is it allowing connections? Does the specified > user exist? Is the password valid? Is the database on the standard port? > [Thu May 26 23:45:30 2011].568138 msDrawMap(): Image handling error. > Failed to draw layer named 'plaatsen'. > [Thu May 26 23:45:30 2011].568224 msPostGISLayerClose called: way28992 > from nl_osm_point using unique osm_id using srid=28992 > [Thu May 26 23:45:30 2011].568238 freeLayer(): freeing layer at 0x1c67250. > [Thu May 26 23:45:30 2011].568243 msPostGISLayerIsOpen called. > [Thu May 26 23:45:30 2011].568251 freeLayer(): freeing layer at 0x1c6a7f0. > [Thu May 26 23:45:30 2011].568255 msPostGISLayerIsOpen called. > > -- This part is from shp2img (connection succesfull): > [Thu May 26 23:47:55 2011].3388 msLayerIsVisible(): Skipping layer > (plaatsen) because no CLASS in the layer is in-scale for this MAP scale > [Thu May 26 23:47:55 2011].3450 msLayerIsVisible(): Skipping layer > (plaatsen) because no CLASS in the layer is in-scale for this MAP scale > [Thu May 26 23:47:55 2011].3457 msLayerIsVisible(): Skipping layer > (plaatsen) because no CLASS in the layer is in-scale for this MAP scale > [Thu May 26 23:47:55 2011].3470 msPostGISLayerOpen called: way28992 from > (select way28992, z_order, landuse, osm_id, name from nl_osm_polygon > order by z_order) as foo using unique osm_id using srid=28992 > [Thu May 26 23:47:55 2011].3478 msPostGISLayerOpen: No connection in > p
[mapserver-users] OT: OSGeo Gallery
Dear all, I do not know who manage OSGeo Gallery webpage - http://gallery.osgeo.org/ -, but there are a lot of website that do not seems to me OSGeo related. Probably this page needs a sort of moderation. Best regards, a - Andrea Borruso email: aborr...@tin.it website: http://blog.spaziogis.it my 2.0 life: http://aborruso.spaziogis.it feed: http://feeds2.feedburner.com/Tanto 38° 7' 48" N, 13° 21' 9" E -- View this message in context: http://osgeo-org.1803224.n2.nabble.com/OT-OSGeo-Gallery-tp6410133p6410133.html Sent from the Mapserver - User mailing list archive at Nabble.com. ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users