Hola, Fernando,
I don't know what's really going on but despite if this is a GDAL error or
something else, I suggest you to try the following in the MAP file LAYER
section:
PROCESSING "CLOSE_CONNECTION=DEFER"
Another question: does PostgreSQL server is running in another machine ?
MSc. Carlos
ata in EPSG:3857
> (Rousseau Lambert2, Louis-Philippe (EC))
>5. Problem with Python MapScript queryByRect (Just van den Broecke)
>
>
> ------
>
> Message: 1
> Date: Thu, 25 Jun 2020 17:16:33 -0300
> From
Hi Fernando,
I would try using the shp2img utility at the commandline, and set CONFIG
"CPL_DEBUG" "ON" in your mapfile (see
https://mapserver.org/optimization/debugging.html#step-3-turn-on-cpl-debug-optional)
and then execute:
shp2img -m mymap.map -o ttt.png -all_debug 5
The full query
Hi,
What client are you using?
How long does the query take to complete?
It is likely the client stops waiting for a response.
Seth
--
web:http://geographika.co.uk
twitter: @geographika
On Thu, Jun 25, 2020, at 10:16 PM, Fernando Martins Pimenta wrote:
> Hi,
>
> I am using the query below to
Hi,
I am using the query below to return a hydrograph of a region (using
POSTGIS). This query works perfectly when I use it in pgadmin. With the
mapserver, the connection with the client is lost. It records a query that
shows no errors in SQL, just shows that the connection has lost. Why is
that?
> -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) wro
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
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
http://postgis.org/documentation/manual-1.5/ch05.html#id2634590
On Tue, Jan 31, 2012 at 4:38 AM, Julien Cigar jci...@ulb.ac.be wrote:
Hello,
Is there a way to (deeply) modify the SQL query in a PostGIS layer?
I would like to add some JOIN, additional WHERE clauses, etc
As I'm afraid that
: [mapserver-users] PostGIS query
On 01/31/2012 17:05, Carlos Ruiz wrote:
Julien,
Hi Carlos,
Have you tried with views ? When I need to map complex queries I build a
view to just handle the where clauses.
I usually use a view, but in this case there are a lot of tables
involved and I
of unnecessary JOIN
Cheers from México
IC Carlos Ruiz
*From:* Julien Cigar jci...@ulb.ac.be
*To:* mapserver-users@lists.osgeo.org mapserver-users@lists.osgeo.org
*Sent:* Tuesday, January 31, 2012 6:38 AM
*Subject:* [mapserver-users
Hello,
Is there a way to (deeply) modify the SQL query in a PostGIS layer?
I would like to add some JOIN, additional WHERE clauses, etc
As I'm afraid that Run-time Substitution isn't flexible enough for
this case ... is there any other possibility, other than mapscript?
I guess there is no
@lists.osgeo.org
Sent: Tuesday, January 31, 2012 6:38 AM
Subject: [mapserver-users] PostGIS query
Hello,
Is there a way to (deeply) modify the SQL query in a PostGIS layer?
I would like to add some JOIN, additional WHERE clauses, etc
As I'm afraid that Run-time Substitution isn't flexible enough for this case
Hi,
I can't get an error with teh sql via psql, but only mapserver, so I'll ask
here.
I'm using a mapfile with a DATA statement similar to the ones at:
http://mapserver.org/input/vector/postgis.html
The data statement is below...
The random() field, combined with order by limit is to
Hi All
Many thanks to Paul with regards to enabling statement logging
(extremely useful to help find out what sql is being sent) and thanks
to Carlos for suggesting the joins.. this was the problem which I can
happily say that I have resolved. What an amazing combination of
software really,
If you turn on statement logging in pgsql, you can see what SQL
mapserver is sending to pgsql. That will clarify if there is a way for
you to change your statement to get what you want, or if there's an
error in what mapserver is asking for, or an error in how mapserver is
processing what is
[EMAIL PROTECTED] wrote:
From: mark balman [EMAIL PROTECTED]
Subject: [mapserver-users] Postgis query
To: mapserver-users@lists.osgeo.org
Date: Tuesday, December 2, 2008, 4:37 AM
Hi All
I am trying to output a query from postgis using three tables and it
is not quite working.
First table is a quarter
Hi All
I am trying to output a query from postgis using three tables and it
is not quite working.
First table is a quarter degree grid (spatial table)
Second table is a table with each grid cell id along with many species
id per grid cell
Third table is list of species
My query definition works
18 matches
Mail list logo