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 the map
You could try regex
\Area\
-Adam
On Wed, May 27, 2009 at 6:48 PM, Peter Willis pet...@borstad.com 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:
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
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 column
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
Thanks, Now I just need that chest. lol
On Wed, 27 May 2009 16:29:54 -0700, Peter Willis pet...@borstad.com
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.
