[mapserver-users] Postgis query

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

[mapserver-users] Postgis query

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, Mapser

[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 ... is there any other possibility, other than mapscript? I guess there is no p

Re: [mapserver-users] Postgis query

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 return

Re: [mapserver-users] Postgis query

<[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. Firs

Re: [mapserver-users] PostGIS query

12 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 ... is ther

Re: [mapserver-users] PostGIS query

unnecessary JOIN Cheers from México IC Carlos Ruiz *From:* Julien Cigar *To:* "mapserver-users@lists.osgeo.org" *Sent:* Tuesday, January 31, 2012 6:38 AM *Subject:* [mapserver-users] PostGIS query Hello, Is ther

Re: [mapserver-users] PostGIS query

ltiple data sources or the super data source of your layers in the .MAP file. IC Carlos Ruiz From: Julien Cigar To: Carlos Ruiz Cc: "mapserver-users@lists.osgeo.org" Sent: Wednesday, February 1, 2012 2:59 AM Subject: Re: [mapserver-users] PostGIS

Re: [mapserver-users] PostGIS query

http://postgis.org/documentation/manual-1.5/ch05.html#id2634590 On Tue, Jan 31, 2012 at 4:38 AM, Julien Cigar 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 "Run-time Subst

[mapserver-users] Postgis query bug?

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 genera

[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 mapfil

[mapserver-users] PostGIS query problem

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?

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 muc

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) wro

Re: [mapserver-users] PostGIS query problem

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

Re: [mapserver-users] PostGIS query problem

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 sh

Re: [mapserver-users] PostGIS query problem

query problem (Jeff McKenna) >4. Sliver when displaying 0°-360° NetCDF data in EPSG:3857 > (Rousseau Lambert2, Louis-Philippe (EC)) >5. Problem with Python MapScript queryByRect (Just van den Broecke) > > > ----

Re: [mapserver-users] PostGIS query problem

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 R