[postgis-users] itemnquery limitation

[Zamil Murji]

I would like to throw my two bits in.

I display a layer in my mapserv application through postgis. If mode=nquery and my bounding box contains less then x number of elements, where x is equal to around 20 (haven't really played with the numbers too much) then everything works fine. If the box contains more then x, mapserv never returns an answer.

Could be related to the the bug tom is experiencing. For the time being, I pulled a shapefile from my postgis layer and am querying that. Speeds are horrendous for displaying it though, so I'm stuck wiht two sources of data (a postgis for display and a shapefile for querying).

Not sure on how to print out the actual query it is running...if you would like more info please email me.

Thanks
Zamil

-----Original Message-----
From: Tom Melhuish [mailto:tmelhuish at webinsightsinc.com]
Sent: Friday, August 08, 2003 5:41 AM
To: PostGIS Users Discussion
Subject: RE: [postgis-users] itemnquery limitation


Dave,

I downloaded CVS 4.0 nightly build and ran it with the same exact results. A
set of 21 items works but 22 doens't. The dates on the Mappostgis.c are:

	Mappostgis.c - version of June 12/2003

I have configured my application using shapefiles and it works fine with
mapserv. Below is the select statement that doesn't work in mapserv but runs
fine in psql:

SELECT
nodeid::text,asbinary(force_collection(force_2d(the_geom)),'NDR'),OID::text
from nodescomb_2003 WHERE (nodeid in
('413.0','430.0','431.0','432.0','433.0','434.0','436.1','450.0','451.0','45
2.0',
'453.0','454.0','455.0','456.0','457.1','457.2','457.3','457.4','458.1','458
.2','459.0','528.0')) and (the_geom && setSRID( 'BOX3D(2001272.875
643833.625,2156198.25
771771.5625)'::BOX3D,find_srid('','nodescomb_2003','the_geom') ))

tom

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net]On Behalf Of Paul
Ramsey
Sent: Thursday, August 07, 2003 5:20 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] itemnquery limitation


You need to pull the 3.6 branch... you might have to ask a developer
what the correct tag is...
P.

Tom Melhuish wrote:

> Dave,
>
> The cvs version now is 4.0. How can I get a copy of the latest cvs 3.6.6
> version? I downloaded CVS 4.0 mappostgis.c and tried to compile with 3.6.6
> but it failed.
>
> tom
>
> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net
> [mailto:postgis-users-bounces at postgis.refractions.net]On Behalf Of David
> Blasby
> Sent: Wednesday, August 06, 2003 4:07 PM
> To: PostGIS Users Discussion
> Subject: Re: [postgis-users] itemnquery limitation
>
>
> Tom Melhuish wrote:
>
>>I'm using 3.6.6 and the error message date is:
>>
>>	Mappostgis.c - version of May 15/2003.
>
>
> Try a more recent version from the mapserver CVS - the latest 3.6.6 is
> June 12/2003.
>
> dave
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users


--
       __
      /
      | Paul Ramsey
      | Refractions Research
      | Email: pramsey at refractions.net
      | Phone: (250) 885-0632
      \_


_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users


_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users