Re: [mapserver-users] PostGIS query errors
> -Original Message-
> From: Andy Colson [mailto:a...@squeakycode.net]
> Sent: 09 November 2016 17:43
> To: Kralidis, Tom (EC); mapserver-users@lists.osgeo.org
> Subject: Re: [mapserver-users] PostGIS query errors
>
> On 11/9/2016 3:30 PM, Kralidis, Tom (EC) wrote:
> > Hi all: using 7.0.2 against a PostgreSQL 9.3/PostGIS 2.2 instance we're
> > getting
> query errors.
> >
> > I've posted a Gist at [1] to help in reporting. Note that this
> > functionality used
> to work in 6.4.x.
> >
> > From the migration guides it doesn't look like much has changed w.r.t.
> > PostGIS syntax in the mapfile. Any idea what could be going on here?
> > It looks like the query that is constructed by mappostgis.c is something
> > like:
> >
> > select
> >
> "stn_nam","avg_wnd_dir_10m_mt58_60","avg_wnd_spd_10m_mt58_60_symb
> ol","
> > air_temp","stn_pres","mslp","dwpt_temp","rel_hum","observation_qa_summ
> >
> ary","observation_qa_problem_summary",encode(ST_AsBinary(ST_Force2D("t
> > he_geom"),'NDR'),'hex') as geom,"data_payload_id" from (select * from
> > data_mart_ca_live order by instance_datetime desc) as subquery where
> > the_geom && ST_GeomFromText('POLYGON((-127.881959628204
> > 63.7547758989546,-127.881959628204 70.5833900726923,-
> 103.751686743445
> > 70.5833900726923,-103.751686743445 63.7547758989546,-
> 127.881959628204
> > 63.7547758989546))',4326) and ()
> >
> > Note the trailing "()". When I remove the "()" and try direct in psql, the
> > query
> works.
> >
> > Any idea what could be going on here?
> >
> > Thanks
> >
> > ..Tom
> >
> > [1]
> > https://gist.github.com/tomkralidis/26cb7214e282c144ba61598116d458e7
> > ___
> > mapserver-users mailing list
> > mapserver-users@lists.osgeo.org
> > http://lists.osgeo.org/mailman/listinfo/mapserver-users
> >
>
> It looks to me, from the code mappostgis.c ~line 2018, in the
> msPostGISBuildSQLWhere function, that you have either a FILTER or
> NATIVE_FILTER being added. I don't see it in the gist you posted though. Is
> it
> applied later some how? I'd bet it's also empty.
>
Indeed, it turns out that Python MapScript was doing a setFilter as part of the
workflow (since changed to setProcessingKey).
Thanks
..Tom
> There is a comment about RFC91 too:
> http://mapserver.org/id/development/rfc/ms-rfc-91.html
>
> any of that apply to you?
>
> -Andy
>
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] PostGIS query errors
On 11/9/2016 3:30 PM, Kralidis, Tom (EC) wrote:
Hi all: using 7.0.2 against a PostgreSQL 9.3/PostGIS 2.2 instance we're getting
query errors.
I've posted a Gist at [1] to help in reporting. Note that this functionality
used to work in 6.4.x.
From the migration guides it doesn't look like much has changed w.r.t. PostGIS
syntax in
the mapfile. Any idea what could be going on here? It looks like the query
that is constructed
by mappostgis.c is something like:
select
"stn_nam","avg_wnd_dir_10m_mt58_60","avg_wnd_spd_10m_mt58_60_symbol","air_temp","stn_pres","mslp","dwpt_temp","rel_hum","observation_qa_summary","observation_qa_problem_summary",encode(ST_AsBinary(ST_Force2D("the_geom"),'NDR'),'hex')
as geom,"data_payload_id" from (select * from data_mart_ca_live order by instance_datetime desc) as subquery where the_geom && ST_GeomFromText('POLYGON((-127.881959628204
63.7547758989546,-127.881959628204 70.5833900726923,-103.751686743445 70.5833900726923,-103.751686743445 63.7547758989546,-127.881959628204 63.7547758989546))',4326) and ()
Note the trailing "()". When I remove the "()" and try direct in psql, the
query works.
Any idea what could be going on here?
Thanks
..Tom
[1] https://gist.github.com/tomkralidis/26cb7214e282c144ba61598116d458e7
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
It looks to me, from the code mappostgis.c ~line 2018, in the
msPostGISBuildSQLWhere function, that you have either a FILTER or
NATIVE_FILTER being added. I don't see it in the gist you posted
though. Is it applied later some how? I'd bet it's also empty.
There is a comment about RFC91 too:
http://mapserver.org/id/development/rfc/ms-rfc-91.html
any of that apply to you?
-Andy
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] PostGIS query errors
Hi all: using 7.0.2 against a PostgreSQL 9.3/PostGIS 2.2 instance we're getting
query errors.
I've posted a Gist at [1] to help in reporting. Note that this functionality
used to work in 6.4.x.
From the migration guides it doesn't look like much has changed w.r.t. PostGIS
syntax in
the mapfile. Any idea what could be going on here? It looks like the query
that is constructed
by mappostgis.c is something like:
select
"stn_nam","avg_wnd_dir_10m_mt58_60","avg_wnd_spd_10m_mt58_60_symbol","air_temp","stn_pres","mslp","dwpt_temp","rel_hum","observation_qa_summary","observation_qa_problem_summary",encode(ST_AsBinary(ST_Force2D("the_geom"),'NDR'),'hex')
as geom,"data_payload_id" from (select * from data_mart_ca_live order by
instance_datetime desc) as subquery where the_geom &&
ST_GeomFromText('POLYGON((-127.881959628204 63.7547758989546,-127.881959628204
70.5833900726923,-103.751686743445 70.5833900726923,-103.751686743445
63.7547758989546,-127.881959628204 63.7547758989546))',4326) and ()
Note the trailing "()". When I remove the "()" and try direct in psql, the
query works.
Any idea what could be going on here?
Thanks
..Tom
[1] https://gist.github.com/tomkralidis/26cb7214e282c144ba61598116d458e7
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
