Re: [mapserver-users] Mapserver/PostGIS map file problem (double quotes in layer 'DATA' element)

2009-05-27 Thread Simon Haddon
Thanks, Now I just need that chest. lol On Wed, 27 May 2009 16:29:54 -0700, Peter Willis wrote: > Hello, > > Darn!, I just sent a [RESOLVED] with the same solution. > (just as I was receiving your email...) > Yes, this is how I managed to to make it work. > > Everything works now. > I guess yo

Re: [mapserver-users] Mapserver/PostGIS map file problem (double quotes in layer 'DATA' element)

2009-05-27 Thread Peter Willis
Hello, Darn!, I just sent a [RESOLVED] with the same solution. (just as I was receiving your email...) Yes, this is how I managed to to make it work. Everything works now. I guess you get the badge for that one. Thanks for your help. Peter Simon Haddon wrote: Have you tried DATA 'the_geom

Re: [mapserver-users] Mapserver/PostGIS map file problem (double quotes in layer 'DATA' element)

2009-05-27 Thread Simon Haddon
Have you tried DATA 'the_geom from (select oid,gid, the_geom, "Area","Perimeter","PixelValue" FROM "global_Land_poly" WHERE "PixelValue"=1 ) AS FOO using SRID=4326' The other options is to change the table name and column names to be lower case or case insensitive. Mixed case table and

Re: [mapserver-users] Mapserver/PostGIS map file problem (double quotes in layer 'DATA' element)

2009-05-27 Thread Peter Willis
I tried that. I get the following error: loadLayer(): Unknown identifier. Parsing error near (Area):(line 30) Mapserver doesn't appear to like the additional formatting. Do I need to recompile with system regex I wonder? Peter Adam Eskreis wrote: You could try regex \"Area\" -Adam On

Re: [mapserver-users] Mapserver/PostGIS map file problem (double quotes in layer 'DATA' element)

2009-05-27 Thread Adam Eskreis
You could try regex \"Area\" -Adam On Wed, May 27, 2009 at 6:48 PM, Peter Willis wrote: > > Hello, > > I am having a problem serving a PostGIS layer via mapserver > as WFS. > > The problem arises from the generation/use of column names > in PostgreSQL that require double quotes. > > ie: > > S

[mapserver-users] Mapserver/PostGIS map file problem (double quotes in layer 'DATA' element)

2009-05-27 Thread Peter Willis
Hello, I am having a problem serving a PostGIS layer via mapserver as WFS. The problem arises from the generation/use of column names in PostgreSQL that require double quotes. ie: SELECT oid,gid, the_geom, "Area","Perimeter","PixelValue" FROM global_Land_poly WHERE "PixelValue"=1; In th