[mapserver-users] getting value non-geometry column from postgis db
I want retrive data from postgis layer. When I look the examples, I see mapserver layer renders geometry column like DATA the_geom FROM roads . What if I intend to get ID value with geo column of the same table. DATA the_geom FROM roads what if DATA the_geom,ID FROM roads ?? regards -- Ahmet Temiz Jeo. Müh. Afet İşleri Gen. Md.lüğü Deprem Ar. D. Ahmet Temiz Geo. Eng. General Dir. of Disaster Affairs -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] Add Content to the Legend
Hi there, I would like to add information about the Units of the selected variable into the legend. When using vector data, this wasn't really the problem. I kind of faked empty classes to insert that information. But now, I wonder how to achieve this when using TIF images. As the TIF is already color coded and regrouped into a couple of classes, using faked CLASS values, results in the display of zero pixels - nothing is being displayed. Is there another way to slip in some information into the legend? Or is the HTML legend the only alternative? Thanks for any hints, Stef ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] confused about pulling data from postgis
hello I am confused about pulling data from postgis layer. In addition to wkb_geometry, I also want to get ogc_fid using querybypoint. I am using this line in my map file. I am getting wkb_geometry but not ogc_fid DATA wkb_geometry FROM (select ogc_fid,wkb_geometry,cat from sheydene2) as foo using unique ogc_fid using SRID=32768 what should I change in my map file to get ogc_fid ? regards -- Ahmet Temiz Jeo. Müh. Afet İşleri Gen. Md.lüğü Deprem Ar. D. Ahmet Temiz Geo. Eng. General Dir. of Disaster Affairs -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] confused about pulling data from postgis
On Mon, Jul 21, orkun wrote: In addition to wkb_geometry, I also want to get ogc_fid using querybypoint. I am using this line in my map file. I am getting wkb_geometry but not ogc_fid DATA wkb_geometry FROM (select ogc_fid,wkb_geometry,cat from sheydene2) as foo using unique ogc_fid using SRID=32768 what should I change in my map file to get ogc_fid ? DATA wkb_geometry, ogc_fid FROM (select ogc_fid,wkb_geometry,cat from sheydene2) as foo using unique ogc_fid using SRID=32768 \\kristian -- ... et nemo ex vobis interrogat me: »Quo vadis?« ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] queryByPoint + PostGIS layers + USING statement
Hi there, it seems that it's mandatory for postgis layers to use the USING statement in the query. My layer parameters look a bit like this: DATA 'the_geom FROM ( SELECT FROM xxx LEFT JOIN WHERE xxx) AS foo USING UNIQUE uid USING srid=4326) ' But nevertheless, mapserver doesn't like it... Can anyone give me a hint what is wrong with that? Thanks for any advice, Stef ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] queryByPoint + PostGIS layers + USING statement
On Mon, Jul 21, Stefan Schwarzer wrote: My layer parameters look a bit like this: DATA 'the_geom FROM ( SELECT FROM xxx LEFT JOIN WHERE xxx) AS foo USING UNIQUE uid USING srid=4326) ' You have an extra ) at the end. But nevertheless, mapserver doesn't like it... If removing the superfluous ) doesn't solve your problem, you will need to elaborate on what doesn't like it means. Does it give an error message? \\kristian -- ... et nemo ex vobis interrogat me: »Quo vadis?« ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Typo error in documentation page
Hi, Does it the right list to inform a possible error in a documentation page or there is an other way? Thanks, Y. Le Sunday 13 July 2008 11:20:12 Yves Jacolin, vous avez écrit : Hi, Working on a french article to present new features for the next release of MS, I found a typo error on the documentation of the WCS 1.1.0: SERVICE=WCSVERSION=1.0.0REQUEST=GetCapabilities should be SERVICE=WCSVERSION=1.1.0REQUEST=GetCapabilities ---^ in 4.1 GetCapabilities section (http://mapserver.gis.umn.edu/docs/howto/wcs_server/#wcs-1-1-0-issues) Regards, Y. -- Donner la liberté aux individus ne suffit pas, il faut aussi leur donner du pouvoir, de la puissance d'agir. M Gauchet Give freedom to people is not enough, we also have to give them the power to use this freedom, to act. M Gauchet --- Yves Jacolin http://yjacolin.gloobe.org http://www.gloobe.org -- Yves Jacolin --- http://softlibre.gloobe.org ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Typo error in documentation page
On 21-Jul-08, at 9:25 AM, Jacolin Yves wrote: Hi, Does it the right list to inform a possible error in a documentation page or there is an other way? Thanks, Y. For documentation errors please file a ticket in Trac (http://trac.osgeo.org/mapserver/ ) and select the MapServer Documentation component when you file the ticket. thanks. --- Jeff McKenna FOSS4G 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] Typo error in documentation page
Le Monday 21 July 2008 15:51:55 Jeff McKenna, vous avez écrit : On 21-Jul-08, at 9:25 AM, Jacolin Yves wrote: Hi, Does it the right list to inform a possible error in a documentation page or there is an other way? Thanks, Y. For documentation errors please file a ticket in Trac (http://trac.osgeo.org/mapserver/ ) and select the MapServer Documentation component when you file the ticket. thanks. --- Jeff McKenna FOSS4G 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 here is the bug in trac: http://trac.osgeo.org/mapserver/ticket/2709 Thanks, Y. -- Yves Jacolin --- http://softlibre.gloobe.org ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] cannot get data from postgis by querybypoint
Do you set the TEMPLATE item within that LAYER ? Because queries doesn't work if you don't have set it. A template is an HTML file wich allows you to format the result of the queries you made. IC Carlos Ruiz --- On Sun, 7/20/08, orkun [EMAIL PROTECTED] wrote: From: orkun [EMAIL PROTECTED] Subject: [mapserver-users] cannot get data from postgis by querybypoint To: mapserver mapserver-users@lists.osgeo.org Date: Sunday, July 20, 2008, 5:31 AM hello My postgis layer creates map properly. I think it means database runs normally and any errors are not seen postgre's log file. I have adjusted tcp listening to all. But, I cannot get data from it by querybypoint, although I followed same procedure to shape file layer from which I can get data by querybypoint. what might the reason be ? any hint ? regards -- Ahmet Temiz Jeo. Müh. Afet İşleri Gen. Md.lüğü Deprem Ar. D. Ahmet Temiz Geo. Eng. General Dir. of Disaster Affairs -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. ___ 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] queryByPoint + PostGIS layers + USING statement
If you want to retrieve geometry with a specify projection, i suggest you to set it inside the postgres geometry_columns table, to simplify the query in the map file. When you upload some shape file to the database via shp2pgsql utility, you can specify the SRID of the projection, if not, SRID sets to -1. If you're an expert user, you can alter the values of the geometry_columns table. IC Carlos Ruiz --- On Mon, 7/21/08, Stefan Schwarzer [EMAIL PROTECTED] wrote: From: Stefan Schwarzer [EMAIL PROTECTED] Subject: [mapserver-users] queryByPoint + PostGIS layers + USING statement To: mapserver-users@lists.osgeo.org Date: Monday, July 21, 2008, 8:00 AM Hi there, it seems that it's mandatory for postgis layers to use the USING statement in the query. My layer parameters look a bit like this: DATA 'the_geom FROM ( SELECT FROM xxx LEFT JOIN WHERE xxx) AS foo USING UNIQUE uid USING srid=4326) ' But nevertheless, mapserver doesn't like it... Can anyone give me a hint what is wrong with that? Thanks for any advice, Stef ___ 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] MapServer Version 5.2.0 Source Released
As far as I know there isn't such a switch. If you could produce the patch we could take a look though. Steve On 7/17/2008 at 7:54 AM, in message [EMAIL PROTECTED], Nolte, Tim [EMAIL PROTECTED] wrote: Is there a built-in facility to turn off anti-aliasing for certain layers when using AGG in this build? I had a patch given to me by someone else on the list that worked with MS 5.0, that patch doesn't work on this build. Thanks. - Tim Timothy J Nolte - [EMAIL PROTECTED] Network Planning Engineer iPCS Wireless, Inc. 4717 Broadmoor Ave, Suite G Kentwood, MI 49512 Office: 616-656-5163 PCS:616-706-2438 Fax:616-554-6484 Web: www.ipcswirelessinc.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Steve Lime Sent: Wednesday, July 16, 2008 9:52 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; mapserver-users@lists.osgeo.org Subject: [mapserver-users] MapServer Version 5.2.0 Source Released Hi all: The MapServer PSC is proud to announce the release of MapServer version 5.2. The source code is available for download at: http://mapserver.gis.umn.edu/download/current Binary distributions will follow shortly. This is a significant release and users are encouraged to upgrade if possible. Nearly 200 tickets were closed as part of this effort. Major feature additions include: * MS RFC 36: Simplified Template Support for Query Output * MS RFC 37: Spatial Reference Improvements and Additions * MS RFC 38: Native Microsoft SQL Server 2008 Support * MS RFC 41: WCS 1.1.x Support * MS RFC 42: Support for Cookie Forwarding * MS RFC 43: Direct Tile Generation for Google Maps API Full RFC text can be found at: http://mapserver.gis.umn.edu/development/rfc Notable enhancements include: * performance enhancements for large shapefile handling * performance enhancements for AGG rendering (an order of magnitude faster in some cases) * fuzzy label outlines for AGG * style-level opacity for AGG * quantization and palette support for PNGs and RGBA modes * SOS 1.0.0 support * WFS 1.1.0 support * proxy and http authentication support for cascaded WMS requests * pre-clip label point computation (helps in tile generation) * extent (e.g. shpext, mapext) template tag attribute handling The full 5.2.0 change log can be found at: http://trac.osgeo.org/mapserver/browser/tags/rel-5-2-0/mapserv er/HISTORY.TXT I would like to thank all the folks that worked hard on this release, your efforts are greatly appreciated! Steve ___ 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] MapServer Version 5.2.0 Source Released
Yes, that patch won't apply on 5.2 as there have been substantial changes in that code. You'll have to manually merge it (the logic is the same). The function you're looking for is msDrawLineSymbolAGG -- thomas On Mon, Jul 21, 2008 at 5:26 PM, Steve Lime [EMAIL PROTECTED] wrote: As far as I know there isn't such a switch. If you could produce the patch we could take a look though. Steve On 7/17/2008 at 7:54 AM, in message [EMAIL PROTECTED], Nolte, Tim [EMAIL PROTECTED] wrote: Is there a built-in facility to turn off anti-aliasing for certain layers when using AGG in this build? I had a patch given to me by someone else on the list that worked with MS 5.0, that patch doesn't work on this build. Thanks. - Tim Timothy J Nolte - [EMAIL PROTECTED] Network Planning Engineer iPCS Wireless, Inc. 4717 Broadmoor Ave, Suite G Kentwood, MI 49512 Office: 616-656-5163 PCS:616-706-2438 Fax:616-554-6484 Web: www.ipcswirelessinc.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Steve Lime Sent: Wednesday, July 16, 2008 9:52 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; mapserver-users@lists.osgeo.org Subject: [mapserver-users] MapServer Version 5.2.0 Source Released Hi all: The MapServer PSC is proud to announce the release of MapServer version 5.2. The source code is available for download at: http://mapserver.gis.umn.edu/download/current Binary distributions will follow shortly. This is a significant release and users are encouraged to upgrade if possible. Nearly 200 tickets were closed as part of this effort. Major feature additions include: * MS RFC 36: Simplified Template Support for Query Output * MS RFC 37: Spatial Reference Improvements and Additions * MS RFC 38: Native Microsoft SQL Server 2008 Support * MS RFC 41: WCS 1.1.x Support * MS RFC 42: Support for Cookie Forwarding * MS RFC 43: Direct Tile Generation for Google Maps API Full RFC text can be found at: http://mapserver.gis.umn.edu/development/rfc Notable enhancements include: * performance enhancements for large shapefile handling * performance enhancements for AGG rendering (an order of magnitude faster in some cases) * fuzzy label outlines for AGG * style-level opacity for AGG * quantization and palette support for PNGs and RGBA modes * SOS 1.0.0 support * WFS 1.1.0 support * proxy and http authentication support for cascaded WMS requests * pre-clip label point computation (helps in tile generation) * extent (e.g. shpext, mapext) template tag attribute handling The full 5.2.0 change log can be found at: http://trac.osgeo.org/mapserver/browser/tags/rel-5-2-0/mapserv er/HISTORY.TXT I would like to thank all the folks that worked hard on this release, your efforts are greatly appreciated! Steve ___ 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] v5.0.0 - CLASSITEM has double quote in fieldvalue
While I'm glad it works (the regex should execute faster too) the other expression should have worked as well. Can you share the data you were using for some testing? Steve On 7/18/2008 at 8:16 AM, in message [EMAIL PROTECTED], Mike Saunt [EMAIL PROTECTED] wrote: Alexandre Excellent - that works! FYI - This is why I believe that Open Source can easily prevail even when people put down the 'many eyes see more bugs' notion. In another life I worked with / as a partner for a proprietary company (now you can buy franking machines from the same parent company wink wink nudge nudge) and you'd never get this response so quickly and also having 'had it from the horses mouth a.k.a. Developers' that there is an issue and this is the best way around it. Thanks so much Alexandre Kind regards Mike 2008/7/18 Alexandre Dube [EMAIL PROTECTED]: I've been told by developers that there seems to be a bug when using in the expression parser... You should use a regular expression instead like the following : EXPRESSION /^Lane Closure$|^Multi-Way Signals$|^Road Closure$|^Stop\/Go Boards$|^Two-Way Signals$/ See at : http://mapserver.gis.umn.edu/docs/howto/msexpressions Mike Saunt wrote: thanks Alexandre but unfortunately it didn't work Do you know if there is a way of forcing MapServer to read out the literal string i.e. sort of like escaping it? in .NET you can say @stringvariable and it will ignore quotes inside etc? Cheers Mike 2008/7/18 Alexandre Dube [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] : Hi Mike, I'm not sure about that, but try eq instead of = EXPRESSION ('[TRAFFIC_TYPE]' eq 'Lane Closure' OR ... Best Regards, Alexandre Mike Saunt wrote: Hi All I've got a MapFile that used to work fine in v4.10 but now fails in v5.0 Basically the CLASSITEM field has double quote in field value and this is then returning an error - msEvalExpression: Expression parser error. Failed to parse expression The CLASS EXPRESSION looks like this CLASSITEM 'TRAFFIC_TYPE' CLASS EXPRESSION ('[TRAFFIC_TYPE]' = 'Lane Closure' OR '[TRAFFIC_TYPE]' = 'Multi-Way Signals' OR '[TRAFFIC_TYPE]' = 'Road Closure' OR '[TRAFFIC_TYPE]' = 'Stop/Go Boards' OR '[TRAFFIC_TYPE]' = 'Two-Way Signals') STYLE # Severe (RED) SYMBOL 'triangle' SIZE 9 COLOR 255 0 0 OUTLINECOLOR 0 0 0 END END I've tried double quote vs. single quotes in the map file but to no avail Anyone any thoughts? Kind regards Mike ___ mapserver-users mailing list mapserver-users@lists.osgeo.org mailto:mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users --Alexandre Dubé Mapgears www.mapgears.com http://www.mapgears.com ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users -- Alexandre Dubé Mapgears www.mapgears.com ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] v5.0.0 - CLASSITEM has double quote in fieldvalue
Steve is right, I had only guessed that there might be a bug based on the problem description, but we've been unable to reproduce the issue that you report. I meant to reply on Friday asking for a testcase to reproduce but I forgot. Daniel Steve Lime wrote: While I'm glad it works (the regex should execute faster too) the other expression should have worked as well. Can you share the data you were using for some testing? Steve On 7/18/2008 at 8:16 AM, in message [EMAIL PROTECTED], Mike Saunt [EMAIL PROTECTED] wrote: Alexandre Excellent - that works! FYI - This is why I believe that Open Source can easily prevail even when people put down the 'many eyes see more bugs' notion. In another life I worked with / as a partner for a proprietary company (now you can buy franking machines from the same parent company wink wink nudge nudge) and you'd never get this response so quickly and also having 'had it from the horses mouth a.k.a. Developers' that there is an issue and this is the best way around it. Thanks so much Alexandre Kind regards Mike 2008/7/18 Alexandre Dube [EMAIL PROTECTED]: I've been told by developers that there seems to be a bug when using in the expression parser... You should use a regular expression instead like the following : EXPRESSION /^Lane Closure$|^Multi-Way Signals$|^Road Closure$|^Stop\/Go Boards$|^Two-Way Signals$/ See at : http://mapserver.gis.umn.edu/docs/howto/msexpressions Mike Saunt wrote: thanks Alexandre but unfortunately it didn't work Do you know if there is a way of forcing MapServer to read out the literal string i.e. sort of like escaping it? in .NET you can say @stringvariable and it will ignore quotes inside etc? Cheers Mike 2008/7/18 Alexandre Dube [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] : Hi Mike, I'm not sure about that, but try eq instead of = EXPRESSION ('[TRAFFIC_TYPE]' eq 'Lane Closure' OR ... Best Regards, Alexandre Mike Saunt wrote: Hi All I've got a MapFile that used to work fine in v4.10 but now fails in v5.0 Basically the CLASSITEM field has double quote in field value and this is then returning an error - msEvalExpression: Expression parser error. Failed to parse expression The CLASS EXPRESSION looks like this CLASSITEM 'TRAFFIC_TYPE' CLASS EXPRESSION ('[TRAFFIC_TYPE]' = 'Lane Closure' OR '[TRAFFIC_TYPE]' = 'Multi-Way Signals' OR '[TRAFFIC_TYPE]' = 'Road Closure' OR '[TRAFFIC_TYPE]' = 'Stop/Go Boards' OR '[TRAFFIC_TYPE]' = 'Two-Way Signals') STYLE # Severe (RED) SYMBOL 'triangle' SIZE 9 COLOR 255 0 0 OUTLINECOLOR 0 0 0 END END I've tried double quote vs. single quotes in the map file but to no avail Anyone any thoughts? Kind regards Mike ___ mapserver-users mailing list mapserver-users@lists.osgeo.org mailto:mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users --Alexandre Dubé Mapgears www.mapgears.com http://www.mapgears.com ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users -- Alexandre Dubé Mapgears www.mapgears.com ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users -- Daniel Morissette http://www.mapgears.com/ ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] Failed to transform feature 760
I got this error while running ogr2ogr from a Win 32 command prompt. The .dbf files completed successfully but the .shp file is empty when opened. Any ideas? Exact command: ogr2ogr -s_srs EPSG:2875 -t_srs EPSG:4326 -overwrite -f ESRI Shapefile shape_4326.shp shape.shp Thanks, Robert ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] Query all layers with blank qlayer?
Hi everyone, I'm running into trouble when I try to use ItemQuery and ItemNQuery with a blank qlayer. Does the 5.0 release still support querying all layers in this way? If not, what's the current method? I haven't been able to find anything aside from Bill Kropla's text and the online list of CGI controls, which states: If (qlayer) not specified then all layers are searched in turn. However, if I leave qlayer blank in my input form, or enter it in the url with no value, I get the following: mapserv(): Web application error. Query layer not set or references an invalid layer. I do have some layers which are displayed but not queryable (no templates defined), do all layers have to be queryable before this method will work? Thanks! -Gabe Emerson ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users