Re: [MapServer-users] Cluster with Oracle Spatial data

[Yankov, Ivan via MapServer-users]

Hello,

I already tested the other oracle connection methods.
The difference with them is that the layer loads "normally" (when I use the 
plugin connection only the metadata part loads),
but no data is being shown.
So with the plugin connection, the data is being read, but the cluster option 
causes the layer not to load apart from the metadata.
With the other connection methods no data is being read.

Regards

-Ursprüngliche Nachricht-
Von: Rahkonen Jukka  
Gesendet: Freitag, 13. Oktober 2023 16:42
An: Yankov, Ivan ; mapserver-users@lists.osgeo.org
Betreff: Re: [MapServer-users] Cluster with Oracle Spatial data

Hi,

Please test if using OGR connectiontype makes any difference.

-Jukka Rahkonen-

-Alkuperäinen viesti-
Lähettäjä: MapServer-users  Puolesta 
Yankov, Ivan via MapServer-users
Lähetetty: perjantai 13. lokakuuta 2023 11.17
Vastaanottaja: mapserver-users@lists.osgeo.org
Aihe: Re: [MapServer-users] Cluster with Oracle Spatial data

Hi,

sure, here is he connection part:

include "../../db_connection/db_os.conf" -> this resolves to: 

CONNECTIONTYPE PLUGIN
PLUGIN "oci"
CONNECTION "OS/***@db_name"

Regards

-Ursprüngliche Nachricht-
Von: MapServer-users  Im Auftrag von 
Rahkonen Jukka via MapServer-users
Gesendet: Donnerstag, 12. Oktober 2023 20:27
An: Holger Schiebold ; mapserver-users@lists.osgeo.org
Betreff: Re: [MapServer-users] Cluster with Oracle Spatial data

Hi,

Could you please mention always when you speak about Oracle Spatial data also 
which connection type you are using:
CONNECTIONTYPE oraclespatial or CONNECTIONTYPE OGR

-Jukka Rahkonen-

-Alkuperäinen viesti-
Lähettäjä: MapServer-users  Puolesta 
Holger Schiebold via MapServer-users
Lähetetty: torstai 12. lokakuuta 2023 16.31
Vastaanottaja: mapserver-users@lists.osgeo.org
Aihe: Re: [MapServer-users] Cluster with Oracle Spatial data

Hi Ivan,

sounds strange. How many features are in your datasource to be clustered? Do 
you see any load on your mapserver machine when you make a request?

Maybe that's a special case with your oracle data. Would you show as your 
mapfile - or the relevant parts?

The cluster option was developed by Tamas Szekeres in 2011 espacially for the 
service i noticed in my last answer. We were involved in the testing and 
maintained the service for a few years and had no special problem with oracle 
data and the cluster option. But it's a long time ago and maybe in newer 
version there is a problem.  Generally i agree with Jeff - this should work 
with every datasource.

Regards Holger



Am 12.10.2023 um 09:02 schrieb Yankov, Ivan via MapServer-users:
> Hi Holger,
>
> thanks for your feedback. All my services use the Oracle Spatial database, so 
> there is no problem with the general connection to the database.
> Its just that the cluster option doesn't work for me when I use Oracle as 
> datasource.
>
> The shape-layer that I described was only for test purposes because I wanted 
> to see if I can get the cluster feature working at all.
> There seemed to be no issues with a shape source. The problem occurs only 
> when I use my default datasource, which in my case is Oracle Spatial.
>
> Regards
> Ivan
___
___
MapServer-users mailing list
MapServer-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [MapServer-users] Cluster with Oracle Spatial data

[Yankov, Ivan via MapServer-users]

Hi,

sure, here is he connection part:

include "../../db_connection/db_os.conf" -> this resolves to: 

CONNECTIONTYPE PLUGIN
PLUGIN "oci"
CONNECTION "OS/***@db_name"

Regards

-Ursprüngliche Nachricht-
Von: MapServer-users  Im Auftrag von 
Rahkonen Jukka via MapServer-users
Gesendet: Donnerstag, 12. Oktober 2023 20:27
An: Holger Schiebold ; mapserver-users@lists.osgeo.org
Betreff: Re: [MapServer-users] Cluster with Oracle Spatial data

Hi,

Could you please mention always when you speak about Oracle Spatial data also 
which connection type you are using:
CONNECTIONTYPE oraclespatial or CONNECTIONTYPE OGR

-Jukka Rahkonen-

-Alkuperäinen viesti-
Lähettäjä: MapServer-users  Puolesta 
Holger Schiebold via MapServer-users
Lähetetty: torstai 12. lokakuuta 2023 16.31
Vastaanottaja: mapserver-users@lists.osgeo.org
Aihe: Re: [MapServer-users] Cluster with Oracle Spatial data

Hi Ivan,

sounds strange. How many features are in your datasource to be clustered? Do 
you see any load on your mapserver machine when you make a request?

Maybe that's a special case with your oracle data. Would you show as your 
mapfile - or the relevant parts?

The cluster option was developed by Tamas Szekeres in 2011 espacially for the 
service i noticed in my last answer. We were involved in the testing and 
maintained the service for a few years and had no special problem with oracle 
data and the cluster option. But it's a long time ago and maybe in newer 
version there is a problem.  Generally i agree with Jeff - this should work 
with every datasource.

Regards Holger



Am 12.10.2023 um 09:02 schrieb Yankov, Ivan via MapServer-users:
> Hi Holger,
>
> thanks for your feedback. All my services use the Oracle Spatial database, so 
> there is no problem with the general connection to the database.
> Its just that the cluster option doesn't work for me when I use Oracle as 
> datasource.
>
> The shape-layer that I described was only for test purposes because I wanted 
> to see if I can get the cluster feature working at all.
> There seemed to be no issues with a shape source. The problem occurs only 
> when I use my default datasource, which in my case is Oracle Spatial.
>
> Regards
> Ivan
___
MapServer-users mailing list
MapServer-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapserver-users
___
MapServer-users mailing list
MapServer-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [MapServer-users] Cluster with Oracle Spatial data

[Yankov, Ivan via MapServer-users]

Hi Jeff,
thanks for your answer. Please let me know if you can find out what the issue 
with the Oracle datasource may be.
Regards,
Ivan

-Ursprüngliche Nachricht-
Von: MapServer-users  Im Auftrag von 
Jeff McKenna via MapServer-users
Gesendet: Dienstag, 10. Oktober 2023 21:12
An: mapserver-users@lists.osgeo.org
Betreff: Re: [MapServer-users] Cluster with Oracle Spatial data

Hi Ivan,

I believe this should work with any database or OGR connection (I think my 
initial tests, for the docs, were with an OGR/KML connection, but I remember 
testing SpatiaLite later as well for cluster).

(I'll see if I can test this with Oracle, but, it may take me a while to setup, 
so someone else might have to jump in & help you here)

-jeff






--
Jeff McKenna
GatewayGeo: Developers of MS4W, & offering MapServer Consulting/Dev co-founder 
of FOSS4G http://gatewaygeo.com/




On 2023-10-10 10:50 a.m., Yankov, Ivan via MapServer-users wrote:
> Hi,
> 
> I have a problem with clustering a point layer (combine multiple 
> features into a single feature based on their relative positions)
> 
> using a point datasource from an Oracle Spatial Database.
> 
> When I test the cluster feature using a point layer in Shape-Format, it 
> works exactly as expected.
> 
> In this case I use “DATA " D:\geodata\point_layer.shp" “ as my 
> datasource and everything works just fine.
> 
> But when I change the datasource to “ CONNECTIONTYPE oraclespatial “ and 
> then use the same point layer
> 
> from the Oracle Spatial Database, then nothing actually happens. I don’t 
> even get some kind of an error message.
> 
> Does anyone know the reason for this behaviour and how can I get the 
> cluster feature to work with an Oracle Spatial datasource?
> 
> Thank you in advance!
> 
> Best Regards


___
MapServer-users mailing list
MapServer-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapserver-users
___
MapServer-users mailing list
MapServer-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [MapServer-users] Cluster with Oracle Spatial data

[Yankov, Ivan via MapServer-users]

Hi Holger,

thanks for your feedback. All my services use the Oracle Spatial database, so 
there is no problem with the general connection to the database.
Its just that the cluster option doesn’t work for me when I use Oracle as 
datasource.

The shape-layer that I described was only for test purposes because I wanted to 
see if I can get the cluster feature working at all.
There seemed to be no issues with a shape source. The problem occurs only when 
I use my default datasource, which in my case is Oracle Spatial.

Regards
Ivan

-Ursprüngliche Nachricht-
Von: MapServer-users  Im Auftrag von 
Holger Schiebold via MapServer-users
Gesendet: Mittwoch, 11. Oktober 2023 10:08
An: mapserver-users@lists.osgeo.org
Betreff: Re: [MapServer-users] Cluster with Oracle Spatial data

Yes, that should not be a problem with oracle spatial and cluster. 
Generally this works. 
(https://via.bund.de/wsv/wadaba/www/wms?REQUEST=GetCapabilities=WMS=1.3.0)
This service works with cluster and oracle spatial data. ( an older service and 
a bit slow - the problem we had with cluster option and some more features was 
primarily the performance) I would test if your oracle features are shown 
without cluster option first. Maybe it's a problem with your oracle connection 
setup first.

regards Holger

Am 10.10.2023 um 21:12 schrieb Jeff McKenna via MapServer-users:
> Hi Ivan,
>
> I believe this should work with any database or OGR connection (I 
> think my initial tests, for the docs, were with an OGR/KML connection, 
> but I remember testing SpatiaLite later as well for cluster).
>
> (I'll see if I can test this with Oracle, but, it may take me a while 
> to setup, so someone else might have to jump in & help you here)
>
> -jeff
>
>
>
>
>
>

mit freundlichen Grüßen

--
Holger Schiebold



codematix GmbH
Felsbachstrasse 5/7
D-07745 Jena
Tel. +49 (3641) 3038-18
www.codematix.de

___
MapServer-users mailing list
MapServer-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapserver-users
___
MapServer-users mailing list
MapServer-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapserver-users

[MapServer-users] Cluster with Oracle Spatial data

[Yankov, Ivan via MapServer-users]

Hi,

I have a problem with clustering a point layer (combine multiple features into 
a single feature based on their relative positions)
using a point datasource from an Oracle Spatial Database.

When I test the cluster feature using a point layer in Shape-Format, it works 
exactly as expected.
In this case I use "DATA " D:\geodata\point_layer.shp" " as my datasource and 
everything works just fine.

But when I change the datasource to " CONNECTIONTYPE oraclespatial " and then 
use the same point layer
from the Oracle Spatial Database, then nothing actually happens. I don't even 
get some kind of an error message.

Does anyone know the reason for this behaviour and how can I get the cluster 
feature to work with an Oracle Spatial datasource?

Thank you in advance!
Best Regards
___
MapServer-users mailing list
MapServer-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] mapserver with kml

[Ivan Ogasawara]

Dear all,

I think the problem is related to this:

https://github.com/mapserver/mapserver/issues/4938

because using this URL works fine:

http://172.17.0.2?map=/maps/dengue-Rio-de-Janeiro.map=map_IMAGETYPE=KML=RIO_DE_JANEIRO

I changed the image width/height ratio and works fine too!

thanks so much!

2017-12-14 18:00 GMT-04:00 Ivan Ogasawara <ivan.ogasaw...@gmail.com>:

> Hi Stephen,
>
> 2017-12-14 15:44 GMT-04:00 Stephen Woodbridge <wood...@swoodbridge.com>:
>
>> The "+" char in the URL is interpreted as a space you have to ecapce this
>> as %2B
>>
>
> You're right, thanks .. but there is the same issue ...
>
>
>> But you should be able to give the OUTPUTFORMAT block an NAME "kml" and
>> give that the appropriate parameters like:
>>
>> EXTENSION "kml"
>> MIMETYPE "application/vnd.google-earth.kml+xml"
>>
>> and whatever other parameters are needed, then request the format "kml"
>>
>
> yes .. this is the kml outputformat that I am using:
>
> OUTPUTFORMAT
>   NAME "kml"
>   DRIVER KML
>   MIMETYPE "application/vnd.google-earth.kml+xml"
>   IMAGEMODE RGBA
>   EXTENSION "kml"
>   FORMATOPTION 'ATTACHMENT=RIO_DE_JANEIRO.kml'
> END
>
>
>
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] mapserver with kml

[Ivan Ogasawara]

Hi Stephen,

2017-12-14 15:44 GMT-04:00 Stephen Woodbridge :

> The "+" char in the URL is interpreted as a space you have to ecapce this
> as %2B
>

You're right, thanks .. but there is the same issue ...


> But you should be able to give the OUTPUTFORMAT block an NAME "kml" and
> give that the appropriate parameters like:
>
> EXTENSION "kml"
> MIMETYPE "application/vnd.google-earth.kml+xml"
>
> and whatever other parameters are needed, then request the format "kml"
>

yes .. this is the kml outputformat that I am using:

OUTPUTFORMAT
  NAME "kml"
  DRIVER KML
  MIMETYPE "application/vnd.google-earth.kml+xml"
  IMAGEMODE RGBA
  EXTENSION "kml"
  FORMATOPTION 'ATTACHMENT=RIO_DE_JANEIRO.kml'
END
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] mapserver with kml

[Ivan Ogasawara]

>
> The name of the format in the GetCapabilities is
>
> application/vnd.google-earth.kml+xml
>
> Use that.
>

yes .. this format is in my GetMap/Format

  application/vnd.google-earth.kml+xml

using this format name in url result this error:

  msWMSLoadGetMapParams(): Image handling error. Unsupported output format
(application/vnd.google-earth.kml xml).

I think I should use the same value defined on OUTPUTFORMAT/NAME

>
> I have never used CRS:84 as CRS and I don't know if it
> really works. You can stay in WMS version 1.1.1 and SRS=EPSG:4326. Verify
> first with image/png that GetMap returns a map.
>
>
> I have no problem with image/png format  (using 1.1.1 or 1.3.0)

> Read
>
> http://www.mapserver.org/optimization/debugging.html,
> <http://www.mapserver.org/optimization/debugging.html> add MS_ERRORFILE
> and DEBUG 5 and see what you get.
>

 These parameter are already defined:

CONFIG 'ON_MISSING_DATA' 'IGNORE'
CONFIG 'PROJ_LIB' './conf/'
CONFIG  "MS_ERRORFILE" "/var/log/mapserver.log"
CONFIG  "CPL_DEBUG" "ON"
CONFIG  "PROJ_DEBUG" "ON"
DEBUG   5

but I couldn't find any important information in the log file (
https://pastebin.com/iP4h0wXx)


this is the proj_lib/conf/ file : https://pastebin.com/AFNKC88Z

My best regards,
Ivan
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] mapserver with kml

[Ivan Ogasawara]

Dear all, thanks :)

Carlo Ruiz,

> http://mapserver.org/input/vector/kml.html

Actually, in my case, the input should be shapefile and the outputs
gtiff,png and kml.

http://mapserver.org/output/kml_output.html



Jukka Rahkonen,

> I used version 1.3.0 so that the response will open into the browser
automatically.

Great! I changed to v 1.3.0 too

this is my new url request:

http://172.17.0.2/?map=/maps/dengue-Rio-de-Janeiro.map=WMS=1.3.0=GetMap=RIO_DE_JANEIRO==CRS:84=-43.7965385309,-23.0828926973,-43.0990394004,-22.7460202858=400=300=kml

> Do you have KML in the list?

yes. Full GetCapabilities xml here: https://pastebin.com/z2myYc5m

> Did you just guess or is there somewhere wrong documentation about
metadata item you have tried # "wms_format" "image/png")

I saw it at some page ... but I think I haven't seen any difference (I
don't remember so well) .. so I commented this option.

> However, you must explicitly add KML into WMS outputformats in the
metadata. It seems that you have played with it because you have this line
commented out:

OK .. I added `wms_getmap_formatlist` parameter. I also added
`wms_formatlist` to metadata layer

I also change SRS=EPSG:4326 to CRS=CRS:84



Seth,

> Ivan's problem looks to be a projection issue only.

I also added crs:84 .. but the result is the same ..

KML by specification uses only a single projection, EPSG:4326 (
http://www.gdal.org/drv_kml.html)

My shapefile is defined as epsg:4326 too

The png output works fine ... maybe something in kml conversion is doing
wrong ...


The log about kml request is here: https://pastebin.com/iP4h0wXx



Ivan Ogasawara

2017-12-14 10:08 GMT-04:00 Rahkonen Jukka (MML) <
jukka.rahko...@maanmittauslaitos.fi>:

> Hi,
>
>
>
> Geoservers have KML output enabled by default so you can have a try with
> clients.  Test-URL
>
> http://demo.geo-solutions.it/geoserver/wms?REQUEST=GetMap;
> SERVICE=WMS=1.1.1=1373=840=
> topp%3Astates=TRUE=application/vnd.
> google-earth.kml+xml=-124.731422,19.49461526802622,-
> 66.969849,54.83308673197378=EPSG:4326=
>
>
>
> WMS 1.3.0 does not say anything about GetMap formats, just that they must
> appear in GetCapabilities, and all formats that appear in GetCapabilities
> must also be usable.
>
>
>
> -Jukka Rahkonen-
>
>
>
> *Lähettäjä:* Seth G [mailto:se...@geographika.co.uk]
> *Lähetetty:* 14. joulukuuta 2017 14:56
> *Vastaanottaja:* Rahkonen Jukka (MML) <jukka.rahko...@maanmittauslaitos.fi>;
> mapserver-users@lists.osgeo.org
>
> *Aihe:* Re: [mapserver-users] mapserver with kml
>
>
>
> Interesting!
>
>
>
> From the WMS spec: "Graphic element formats include Scalable Vector
> Graphics (SVG; MIME type “image/svg+xml”) or Web Computer Graphics Metafile
> (WebCGM; MIME type “image/cgm;Version=4;ProfileId=WebCGM”) formats"
>
>
>
> I wonder how many WMS clients would handle KML as a WMS. As it is XML then
> it would't be accessible from another domain in a web client.
>
>
>
> Ivan's problem looks to be a projection issue only.
>
>
>
> Seth
>
>
>
> --
>
> web:http://geographika.co.uk
>
> twitter: @geographika
>
>
>
>
>
> On Thu, Dec 14, 2017, at 10:42 AM, Rahkonen Jukka (MML) wrote:
>
> Hi Seth,
>
>
>
> KML is considered as an image format and it should work with WMS and with
> mode=map http://mapserver.gis.umn.edu/fr/development/rfc/ms-rfc-58.html
>
>
>
> It seems that KML output has not been developed much since the initial
> implementation.
>
>
>
> -Jukka Rahkonen-
>
>
>
> *Lähettäjä:* mapserver-users [mailto:mapserver-users-
> boun...@lists.osgeo.org <mapserver-users-boun...@lists.osgeo.org>] *Puolesta
> *Seth G
> *Lähetetty:* 14. joulukuuta 2017 10:03
> *Vastaanottaja:* mapserver-users@lists.osgeo.org
> *Aihe:* Re: [mapserver-users] mapserver with kml
>
>
>
> Hi,
>
>
>
> Your output image looks like a projection issue. Google Maps use the
> espg:3857 projection, but your request is asking for SRS=epsg:4326, maybe
> try changing this?
>
> Also are you trying to return KML or display an image using KML as a data
> source? If you are trying to return KML you'd need to use WFS rather than
> WMS which only returns images.
>
>
>
> Seth
>
>
>
> --
>
> web:http://geographika.co.uk
>
> twitter: @geographika
>
>
>
>
>
> On Thu, Dec 14, 2017, at 01:33 AM, Ivan Ogasawara wrote:
>
>
>
> Dear all,
>
>
>
> Anyone knows some tutorial to work with mapserver (wms) and kml?
>
>
>
> I am trying to do it .. but with no success.
>
>
>
> this is the local url used:
>
>
>
> http://172.17.0.2/?map=/maps/dengue-Rio-de-Janei

[mapserver-users] mapserver with kml

[Ivan Ogasawara]

Dear all,

Anyone knows some tutorial to work with mapserver (wms) and kml?

I am trying to do it .. but with no success.

this is the local url used:

http://172.17.0.2/?map=/maps/dengue-Rio-de-Janeiro.map
CE=WMS=1.1.1=GetMap=RIO_DE_JANEIRO&
STYLES==epsg:4326=-43.7965385309,-23.0828926973,-
43.0990394004,-22.7460202858=400=300=
kml.map=WMS=1.1.1=GetMap=RIO_
DE_JANEIRO==epsg:4326=-43.7965385309,-23.
0828926973,-43.0990394004,-22.7460202858=400=300=kml

for image/png works fine (tested with leaflet).

Any tips?

Files:
* mapfiles:
  * https://pastebin.com/4EkahMZi
  * https://pastebin.com/DVSt4mmS
* kml: https://pastebin.com/LYkD4ZDL
* Result: https://user-images.githubusercontent.com/5209757/
33969313-f7029096-e042-11e7-8621-e8235f0bd5ce.png

Thanks!

My best regards,
Ivan
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] OFFSET and RAGECOLOR

[Ivan Ogasawara]

done! I don't know if this is the best way to do that .. but ..

this is my layer config:

```
PROJECTION
 "init=epsg:4326"
   END

   METADATA
 "wms_title" "RIO_DE_JANEIRO"
 "wms_srs" "EPSG:4326 EPSG:3857"
 "wms_include_items" "all"
   END

   COMPOSITE
   OPACITY 70
   END # COMPOSITE

   # PROCESSING "KERNELDENSITY_NORMALIZATION=255"
   # PROCESSING "RANGE_COLORSPACE=HSL"
   CLASSITEM "[pixel]"

   CLASS
 NAME "class_hotcolors"
 EXPRESSION ([pixel] >= 1)

 STYLE
RANGEITEM "style_hotcolors"
COLORRANGE  1 0 0  255 0 0
DATARANGE 1 8549
 END # STYLE

   END # CLASS

   CLASS
 NAME "class_background"
 EXPRESSION ([pixel] == 0)

 STYLE
RANGEITEM "style_background"
COLORRANGE  0 0 0  0 0 0
DATARANGE 0 0
 END # STYLE
   END # CLASS
   END

```

My best regards,
Ivan

2017-12-07 15:56 GMT-04:00 Ivan Ogasawara <ivan.ogasaw...@gmail.com>:

> Sorry .. actually is OFFSITE
>
> OFFSITE [r] [g] [b] | [hexadecimal string]
>
> Sets the color index to treat as transparent for raster layers.
>
>-
>
>r, g and b shall be integers [0..255]. To specify black pixels, the
>following is used:
>
>OFFSITE 0 0 0
>
>
> As in the mapfile sent.
>
>
> 2017-12-07 15:52 GMT-04:00 Ivan Ogasawara <ivan.ogasaw...@gmail.com>:
>
>> I guess I misunderstood the offset parameter (actually before I added the
>> colorrange parameter, offset was disabled).
>>
>> but after I've added the colorrange parameter, the background is not
>> transparent anymore ...
>>
>> 2017-12-07 15:41 GMT-04:00 Ivan Ogasawara <ivan.ogasaw...@gmail.com>:
>>
>>> Hi Jukka,
>>>
>>>
>>> these are my map files, raster file and the image output.
>>>
>>>
>>> my best,
>>>
>>> Ivan
>>>
>>>
>>> 2017-12-07 2:36 GMT-04:00 Rahkonen Jukka (MML) <
>>> jukka.rahko...@maanmittauslaitos.fi>:
>>>
>>>> Hi,
>>>>
>>>> It is impossible to help you with so little details. Show us a
>>>> corresponding part of your mapfile and a small sample of data that can be
>>>> user for re-producing the error would be appreciated.
>>>>
>>>> -Jukka Rahkonen-
>>>> --
>>>> Lähettäjä: Ivan Ogasawara <ivan.ogasaw...@gmail.com>
>>>> Lähetetty: ‎7.‎12.‎2017 4:28
>>>> Vastaanottaja: mapserver-users@lists.osgeo.org
>>>> Aihe: [mapserver-users] OFFSET and RAGECOLOR
>>>>
>>>> Dear all,
>>>>
>>>> when I use style colorrange the offset directive doesn't work.
>>>>
>>>> my mapserver install configurations is:
>>>>
>>>> ```
>>>> MapServer version 7.0.4 OUTPUT=PNG OUTPUT=JPEG OUTPUT=KML SUPPORTS=PROJ
>>>> SUPPORTS=AGG SUPPORTS=FREETYPE SUPPORTS=CAIRO SUPPORTS=SVG_SYMBOLS
>>>> SUPPORTS=RSVG SUPPORTS=ICONV SUP
>>>> PORTS=FRIBIDI SUPPORTS=WMS_SERVER SUPPORTS=WMS_CLIENT
>>>> SUPPORTS=WFS_SERVER SUPPORTS=WFS_CLIENT SUPPORTS=WCS_SERVER
>>>> SUPPORTS=SOS_SERVER SUPPORTS=FASTCGI SUPPORTS=THREADS SUP
>>>> PORTS=GEOS INPUT=JPEG INPUT=POSTGIS INPUT=OGR INPUT=GDAL INPUT=SHAPEFILE
>>>> ```
>>>>
>>>> any idea to resolve this problem?
>>>>
>>>> my best regards,
>>>> Ivan
>>>>
>>>
>>>
>>
>
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] OFFSET and RAGECOLOR

[Ivan Ogasawara]

Sorry .. actually is OFFSITE

OFFSITE [r] [g] [b] | [hexadecimal string]

Sets the color index to treat as transparent for raster layers.

   -

   r, g and b shall be integers [0..255]. To specify black pixels, the
   following is used:

   OFFSITE 0 0 0


As in the mapfile sent.


2017-12-07 15:52 GMT-04:00 Ivan Ogasawara <ivan.ogasaw...@gmail.com>:

> I guess I misunderstood the offset parameter (actually before I added the
> colorrange parameter, offset was disabled).
>
> but after I've added the colorrange parameter, the background is not
> transparent anymore ...
>
> 2017-12-07 15:41 GMT-04:00 Ivan Ogasawara <ivan.ogasaw...@gmail.com>:
>
>> Hi Jukka,
>>
>>
>> these are my map files, raster file and the image output.
>>
>>
>> my best,
>>
>> Ivan
>>
>>
>> 2017-12-07 2:36 GMT-04:00 Rahkonen Jukka (MML) <
>> jukka.rahko...@maanmittauslaitos.fi>:
>>
>>> Hi,
>>>
>>> It is impossible to help you with so little details. Show us a
>>> corresponding part of your mapfile and a small sample of data that can be
>>> user for re-producing the error would be appreciated.
>>>
>>> -Jukka Rahkonen-
>>> --
>>> Lähettäjä: Ivan Ogasawara <ivan.ogasaw...@gmail.com>
>>> Lähetetty: ‎7.‎12.‎2017 4:28
>>> Vastaanottaja: mapserver-users@lists.osgeo.org
>>> Aihe: [mapserver-users] OFFSET and RAGECOLOR
>>>
>>> Dear all,
>>>
>>> when I use style colorrange the offset directive doesn't work.
>>>
>>> my mapserver install configurations is:
>>>
>>> ```
>>> MapServer version 7.0.4 OUTPUT=PNG OUTPUT=JPEG OUTPUT=KML SUPPORTS=PROJ
>>> SUPPORTS=AGG SUPPORTS=FREETYPE SUPPORTS=CAIRO SUPPORTS=SVG_SYMBOLS
>>> SUPPORTS=RSVG SUPPORTS=ICONV SUP
>>> PORTS=FRIBIDI SUPPORTS=WMS_SERVER SUPPORTS=WMS_CLIENT
>>> SUPPORTS=WFS_SERVER SUPPORTS=WFS_CLIENT SUPPORTS=WCS_SERVER
>>> SUPPORTS=SOS_SERVER SUPPORTS=FASTCGI SUPPORTS=THREADS SUP
>>> PORTS=GEOS INPUT=JPEG INPUT=POSTGIS INPUT=OGR INPUT=GDAL INPUT=SHAPEFILE
>>> ```
>>>
>>> any idea to resolve this problem?
>>>
>>> my best regards,
>>> Ivan
>>>
>>
>>
>
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] OFFSET and RAGECOLOR

[Ivan Ogasawara]

I guess I misunderstood the offset parameter (actually before I added the
colorrange parameter, offset was disabled).

but after I've added the colorrange parameter, the background is not
transparent anymore ...

2017-12-07 15:41 GMT-04:00 Ivan Ogasawara <ivan.ogasaw...@gmail.com>:

> Hi Jukka,
>
>
> these are my map files, raster file and the image output.
>
>
> my best,
>
> Ivan
>
>
> 2017-12-07 2:36 GMT-04:00 Rahkonen Jukka (MML) <jukka.rahkonen@
> maanmittauslaitos.fi>:
>
>> Hi,
>>
>> It is impossible to help you with so little details. Show us a
>> corresponding part of your mapfile and a small sample of data that can be
>> user for re-producing the error would be appreciated.
>>
>> -Jukka Rahkonen-
>> --
>> Lähettäjä: Ivan Ogasawara <ivan.ogasaw...@gmail.com>
>> Lähetetty: ‎7.‎12.‎2017 4:28
>> Vastaanottaja: mapserver-users@lists.osgeo.org
>> Aihe: [mapserver-users] OFFSET and RAGECOLOR
>>
>> Dear all,
>>
>> when I use style colorrange the offset directive doesn't work.
>>
>> my mapserver install configurations is:
>>
>> ```
>> MapServer version 7.0.4 OUTPUT=PNG OUTPUT=JPEG OUTPUT=KML SUPPORTS=PROJ
>> SUPPORTS=AGG SUPPORTS=FREETYPE SUPPORTS=CAIRO SUPPORTS=SVG_SYMBOLS
>> SUPPORTS=RSVG SUPPORTS=ICONV SUP
>> PORTS=FRIBIDI SUPPORTS=WMS_SERVER SUPPORTS=WMS_CLIENT SUPPORTS=WFS_SERVER
>> SUPPORTS=WFS_CLIENT SUPPORTS=WCS_SERVER SUPPORTS=SOS_SERVER
>> SUPPORTS=FASTCGI SUPPORTS=THREADS SUP
>> PORTS=GEOS INPUT=JPEG INPUT=POSTGIS INPUT=OGR INPUT=GDAL INPUT=SHAPEFILE
>> ```
>>
>> any idea to resolve this problem?
>>
>> my best regards,
>> Ivan
>>
>
>
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] OFFSET and RAGECOLOR

[Ivan Ogasawara]

Hi Jukka,


these are my map files, raster file and the image output.


my best,

Ivan


2017-12-07 2:36 GMT-04:00 Rahkonen Jukka (MML) <
jukka.rahko...@maanmittauslaitos.fi>:

> Hi,
>
> It is impossible to help you with so little details. Show us a
> corresponding part of your mapfile and a small sample of data that can be
> user for re-producing the error would be appreciated.
>
> -Jukka Rahkonen-
> --
> Lähettäjä: Ivan Ogasawara <ivan.ogasaw...@gmail.com>
> Lähetetty: ‎7.‎12.‎2017 4:28
> Vastaanottaja: mapserver-users@lists.osgeo.org
> Aihe: [mapserver-users] OFFSET and RAGECOLOR
>
> Dear all,
>
> when I use style colorrange the offset directive doesn't work.
>
> my mapserver install configurations is:
>
> ```
> MapServer version 7.0.4 OUTPUT=PNG OUTPUT=JPEG OUTPUT=KML SUPPORTS=PROJ
> SUPPORTS=AGG SUPPORTS=FREETYPE SUPPORTS=CAIRO SUPPORTS=SVG_SYMBOLS
> SUPPORTS=RSVG SUPPORTS=ICONV SUP
> PORTS=FRIBIDI SUPPORTS=WMS_SERVER SUPPORTS=WMS_CLIENT SUPPORTS=WFS_SERVER
> SUPPORTS=WFS_CLIENT SUPPORTS=WCS_SERVER SUPPORTS=SOS_SERVER
> SUPPORTS=FASTCGI SUPPORTS=THREADS SUP
> PORTS=GEOS INPUT=JPEG INPUT=POSTGIS INPUT=OGR INPUT=GDAL INPUT=SHAPEFILE
> ```
>
> any idea to resolve this problem?
>
> my best regards,
> Ivan
>


NDVI.map
Description: Binary data


3304557.map
Description: Binary data
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] OFFSET and RAGECOLOR

[Ivan Ogasawara]

Dear all,

when I use style colorrange the offset directive doesn't work.

my mapserver install configurations is:

```
MapServer version 7.0.4 OUTPUT=PNG OUTPUT=JPEG OUTPUT=KML SUPPORTS=PROJ
SUPPORTS=AGG SUPPORTS=FREETYPE SUPPORTS=CAIRO SUPPORTS=SVG_SYMBOLS
SUPPORTS=RSVG SUPPORTS=ICONV SUP
PORTS=FRIBIDI SUPPORTS=WMS_SERVER SUPPORTS=WMS_CLIENT SUPPORTS=WFS_SERVER
SUPPORTS=WFS_CLIENT SUPPORTS=WCS_SERVER SUPPORTS=SOS_SERVER
SUPPORTS=FASTCGI SUPPORTS=THREADS SUP
PORTS=GEOS INPUT=JPEG INPUT=POSTGIS INPUT=OGR INPUT=GDAL INPUT=SHAPEFILE
```

any idea to resolve this problem?

my best regards,
Ivan
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] MapFile viewer

[Ivan Mincik]

On 12/14/2012 02:32 PM, Jeff McKenna wrote:
 Ivan, I want to make sure users can find this viewer; would you be
 willing to edit the MapServer Wiki
 (https://github.com/mapserver/mapserver/wiki) and add a Mapfile
 Viewers page there, with your project as a first example?  (note that
 you could include screengrabs or anything you want on that new page)


Done. https://github.com/mapserver/mapserver/wiki/MapFile-viewers

I will call it as 'Mapfile developer script' to not get confused with
built-in MapServer viewer.

More testing is welcomed.

-- 
Ivan Mincik
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] MapFile viewer

[Ivan Mincik]

On 12/14/2012 10:20 AM, Thomas Gratier wrote:
 Hello,
 
 What is the advantage compare to OpenLayers built-in viewer (since 6.x
 version) e.g http://mapserver.org/trunk/fr/openlayers.html ?


I do not use that viewer, but it could be one of these:

1. Works for MapServer  6.0

2. Doesn't require web server running on Your machine. It creates its
own WSGI server which is more like development environments should look
like (Django dev server).

3. I am not sure how viewer in MapServer deals with errors in mapfile.
In my case it prints usable error message to console which is key
feature for debugging.

4. Possibilities to override CONNECTION setting - in production we use
variables substitution ('user=%MYUSER% password=%MYPASSWORD%
dbname=%MYDBNAME% host=%MYHOST%'). In development I can send there my
user credentials.

5. Possibility to override some other parameters line EXTENT. It creates
possibility to work with many projects with the same base mapfile. I
will add other overriding options.


6. Or maybe No advantage at all


-- 
Ivan Mincik
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] MapFile viewer

[Ivan Mincik]

Thanks for people testing and reporting issues on GitHub.
As I said, I used this tool for my purposes, so it could rise bugs when
tested in different environments. I have no problem with fixing issues,
adding legend support ... .

I would be very interested what do You think in general about this kind
of approach ? Is it worth to continue in work ?


-- 
Ivan Mincik
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] MapFile viewer

[Ivan Minčík]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

I have fixed two issues reported on GitHub (thanks @tbonfort).


- -- 
Ivan Mincik, ivan.min...@gmail.com
If replying in mailing-list please add me to Cc.
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.12 (GNU/Linux)

iQEcBAEBAgAGBQJQyy5yAAoJEPfdLsR5UpoeVEoIAJd18PZug/0LEm2si2mcsPwr
KK/Dd75FuMl7rwrNRQJ/9VLYUUpPvpCTnOq6/5TykRYuttPa3DTXgw4PSUJAy8qC
5IGklrqNgyIikM+MQn0zkshu4n0QHSU2ajuOqvgW9kaCce+ys2C55DIQ4Lb53e7H
TDca/dqzttkA7LGxtYVvkkcTgfiOqv3mZK6eLF0JivtA2CxVpWWkRjz1h8Zj4eRG
eqnIpFrczVRSpUEMJtDj1UywMLWIx3aZdsjHs5Bb//VMlXce3XA8PF3eR+/6EyKo
Ni1VgBlxcdrH1+RAOx2zNeAPpPH1VGyJdeczXaM4v1yCkVDnabvhmM3CdXFecNY=
=F6W9
-END PGP SIGNATURE-
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] MapFile viewer

[Ivan Minčík]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

I have made some improvements. Mostly visible adding legend to map.
Now I can declare current features ready for initial version release.

More testing is needed.


- -- 
Ivan Mincik, ivan.min...@gmail.com
If replying in mailing-list please add me to Cc.
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.12 (GNU/Linux)

iQEcBAEBAgAGBQJQy7pfAAoJEPfdLsR5UpoeoykH/3sDNWqF9W0A42FNxrdPfrJU
6sxxupj4QjuiR2o08UH6aAWc4PORS06gPshaKEw77pVG1RW4vhe4m06QpAzRsIiR
mpavkyUFdaLxbYG+zL8QPUAvsvRUnoaGikF/vGKbFUFiP3A77H+rN957hoEoznkh
/5JJ6UjjC3vdDkoEB4PQTiwWgdjPZYzJ1x+Dq04++73UDg5OC99nXYHGd+vm/VOe
bgfk/XMqY1mvddFjZXyWxDC+ZMf/sOplSbmaYQ5FexLhSkyNajBcYD/qv2WmGRy5
5Sn2luarkZp1uTgFWlFvN+XGT9y5YwGgM0r8CYZeiXBdqA2WQWx2a7xA1YxvuZY=
=bxGp
-END PGP SIGNATURE-
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] MapFile viewer

[Ivan Minčík]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Hi all,
If anybody interested, I have published my simple web based mapfile
viewer tool, which I use to develop and visualize MapServer layers.

Mapfile viewer is a Python script which starts standalone WSGI server
which provides OpenLayers-based map viewer containing layers from
given mapfile.

You can download it from here: https://github.com/imincik/mapfile-viewer

Any patches welcomed.

- -- 
Ivan Mincik, ivan.min...@gmail.com
If replying in mailing-list please add me to Cc.
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.12 (GNU/Linux)

iQEcBAEBAgAGBQJQykLqAAoJEPfdLsR5Upoez7cIAJiQE1pxklQHYVqS6YOLTcyv
8Vf/XxwJ61Foe1rGKj5eFJiicFWZX3+btwL2MQ2+q/+ujhFUj+uEsBDmHFa3TlKm
S1P2QDteks7eX7V8BIstGrCOJ2jd5n17j5/4WsRJOzDHfKrqRyNx9NCHyTQnE97s
iL4vz8zvcWhP/kKXACoAH5RL7C5m9MmVuKWByMhZa/ppNALeQtZcMOTn0DW+N1LP
K0oCCw9B88/LkqXZQTnfrRKHMKkktlwxSRNfqSbjC4TREhUunnJd1r4yJghkPgeb
BQoxQSPNIgi5epr9rFXxs6nBMhXPkBvtTaPAEKQzmM+M/QBdkxcqxq6TWbQQ/6I=
=3Xfc
-END PGP SIGNATURE-
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] Mapfile verification tool

[Ivan Mincik]

On 05/15/2012 03:56 PM, Lime, Steve D (DNR) wrote:
 Other than using shp2img or one of the other command-line executables I'm 
 afraid there isn't a validator.
 

What about writing some trivial mapscript script which will loop over
all layers in mapfile. If some syntax error would be found some
exception will be raised ?


-- 
Ivan Mincik
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] Mapfile verification tool

[Ivan Mincik]

 I don't think this will work because the mapfile is read all at once and
 parsed into an internal data structure. You can't access it in mapscript
 until the parser has read it and the parser will error out on any errors.

Understand, but i mean only valid/invalid output from test script. If
some error will raised - mapfile is invalid, with no other information
where otherwise mapfile is OK.


-- 
Ivan Mincik
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] Mapfile verification tool

[Ivan Mincik]

I mean something like this:

import sys
import mapscript

try:
m = mapscript.mapObj(sys.argv[1])
print 'VALID (%s layers found)' % m.numlayers

except:
print 'INVALID'


I did some tests and it seems working. Even it outputs detailed parsing
error message (for example: loadProjection(): Unknown identifier.
Parsing error near (METADATA):(line 100))
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] GetLegendGraphic request using mapscript.OWSRequest()

[Ivan Mincik]

Hi,
is it possible to run GetLegendGraphic request using mapscript.OWSRequest() ?

I use following code:
wms = mapscript.mapObj(mapfile)
req = mapscript.OWSRequest()
for k,v in qs.items():
req.setParameter(k, v)
wms.loadOWSParameters(req)
wms.draw()
but it seems, that it always performs GetMap request.

Parameters are:
  LAYER polygon
  SERVICE WMS
  FORMAT image/png
  REQUEST GetLegendGraphic
  VERSION 1.1.1

MapServer version 6.0.1

Thanks, Ivan
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] Offline Map caching options for Quantum GIS

[Ivan Cardenas]

Hello, 

We need to place a mapping application in an area with limited and sometimes no 
internet access.

Is there a convenient way to cache map tiles and/or city names for a region for 
Quantum GIS for subsequent use in a stand alone (no network) mode?

Many thanks in advance!

Ivan Cardenas
Technical Director
Kestrel Technology Group
iv...@kestrel-tech.com
281 242 6349 main
713 899 1415 mobile
281 491 0379 fax___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] Why is LAYERS parameter required in GetFeatureInfo

[Ivan Mincik]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Hi,
I would like to ask, why is the LAYERS parameter required in
GetFeatureInfo request.
Looking to WMS specification, it is not mentioned in this type of
request. Neither in Mapserver doc I can't find any relevant info.

Tested on Mapserver 5.6.6. Without LAYERS parameter I get:
msWMSLoadGetMapParams(): WMS server error. Invalid layer(s) given in the
LAYERS parameter.

Thanks

- -- 
Ivan Mincik, Gista s.r.o.
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.9 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEARECAAYFAk3CdIsACgkQVqso/9cUsCydZgCgzE3uoIfl3AknEvoVEEuxgHFU
1twAniaRmixQ200mbLDlcJe3367RWIgo
=Xy55
-END PGP SIGNATURE-
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] Why is LAYERS parameter required in GetFeatureInfo

[Ivan Mincik]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

On 05/05/2011 11:59 AM, Bart van den Eijnden wrote:
 The WMS spec does say it is required:
 
 7.3.3.4   map_request_copy
 map request copy is not a name/value pair like the other parameters. 
 Instead, most of the GetMap request parameters that generated the original 
 map are repeated. Two are omitted because GetFeatureInfo provides its own 
 values: VERSION and REQUEST. The remainder of the GetMap request shall be 
 embedded contiguously in the GetFeatureInfo request.

Thanks a lot Bart, I missed that.


- -- 
Ivan Mincik, Gista s.r.o.
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.9 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEARECAAYFAk3CgakACgkQVqso/9cUsCyxrACgnw8SAw0g/vOoEEbh5aEL4CYp
xKgAn0GpBX6twUNQcFJhr1bM8SJ7F8jN
=Ucut
-END PGP SIGNATURE-
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] Offnet conversion tool

[Ivan Cardenas]

Folks,

We are looking for an offline tool that can be purchased and run with no 
internet connectivity for converting .csv's into time animated presentations in 
Google Earth.

We have been using the web-based converter at the following address for the 
conversion of excel data into CSV.  https://www.earthpoint.us/ExcelToKml.aspx

This tool converts spreadsheets very effectively into a KML that can also model 
differing node sizes, colors, temporal data, etc.  Does anyone know of a PC 
(not internet) based tool that can perform all of the above  functionalities 
for csv to kml conversions?

Thanks!

Ivan Cardenas
Technical Director
Kestrel Technology Group
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] Looking for mobile WebMapping-Applications

[Ivan Mincik]

On Thu, Feb 17, 2011 at 3:21 PM, Kai Behncke kai-behn...@gmx.de wrote:
 Dear users,

 for a dissertation and an article I´m looking for mobile 
 WebMapping-applications
 (means: WebMapping/WebGIS-Applications that work ob mobile handheld devices 
 (e.g. PDAs, Smartphones)).

 Does anyone know such an application and send me the link please?


We are doing some GIS software for Android. See [1]. It is GNU GPL
with source code  here [2]

[1] - http://gista.sk/index.php/ukazky-a-navody/obrazky
[2] - https://github.com/gista/GisplanDroid

Ivan

Ivan
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] Need to replace Google Maps API on webservice - Help!

[Ivan Cardenas]

Hello All,

If anyone can provide a dedicated effort over the next week, to create a 
mapserver that can serve opensource or purchased imagery via a Google Maps API 
or anothe viewer that can take KML feeds, on a standalone, no network system, 
please let me know right away please.  Email or mobile below is best.

Many Thanks,

Sincerely,


Ivan Cardenas
Technical Director
Kestrel Technology Group
iv...@kestrel-tech.commailto:iv...@kestrel-tech.com
281 242 6349 main
713 899 1415 mobile
281 491 0379 fax



CONFIDENTIALITY NOTICE
This electronic mail transmission is confidential, may be privileged and should 
be read or retained only by the intended recipient. If you have received this 
transmission in error, please immediately notify the sender and delete it from 
your system.
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] [Oracle] Geo raster with oracle spatial

[Ivan Lucena]

Yes, see example at FOSS4GIS 2010 Benchmark:

http://wiki.osgeo.org/wiki/Benchmarking_2010#MapServer

  ---Original Message---
  From: Guillaume BARTHE guillaume.bar...@c-s.fr
  To: mapserver-users@lists.osgeo.org
  Subject: [mapserver-users] [Oracle] Geo raster with oracle spatial
  Sent: Jan 18 '11 05:06
  
  Hi,
  
  Is it possible to interface mapserver and geo raster stored in oracle
  spatial database ?
  
  Thank you.
  
  Guillaume
  
  --
  
  
  [LINK: www.c-s.fr]GUILLAUME BARTHE
  Ingnieur d'tude sur KHEPER
  
  CS SYSTEGRAVE;MES D\'INFORMATION - DIVISION ESPACE  RENSEIGNEMENT
  Dpartement Information Gographique  Image
  Parc de la Grande Plaine - 5, Rue Brindejonc des Moulinais - BP 15872
  31506 Toulouse Cedex 05 - FRANCE
  Tel : +33 561 17 63 70
  Email : [LINK: mailto:guillaume.bar...@c-s.fr] guillaume.bar...@c-s.fr
  
  
  ___
  mapserver-users mailing list
  [LINK: compose.php?to=mapserver-users@lists.osgeo.org]
  mapserver-users@lists.osgeo.org
  [LINK: http://lists.osgeo.org/mailman/listinfo/mapserver-users]
  http://lists.osgeo.org/mailman/listinfo/mapserver-users
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] [Oracle] Geo raster with oracle spatial

[Ivan Lucena]

Guilaume,

A world of advise. The current georaster driver in GDAL 1.8 is not optimized 
for random access, so the good performance your see on the benchmark was 
obtained with a prototype available at:

http://trac.osgeo.org/gdal/browser/sandbox/ilucena/georaster

If you happens to be dealing with georaster smaller than 1Gb you might not fell 
the different between the two versions. I hope we can have those version 
integrated soon.

Regards,

Ivan


  ---Original Message---
  From: Guillaume BARTHE guillaume.bar...@c-s.fr
  To: mapserver-users@lists.osgeo.org
  Subject: Re: [mapserver-users] [Oracle] Geo raster with oracle spatial
  Sent: Jan 18 '11 07:20
  
  Thank you
  
  Guillaume
  
  
  Ivan Lucena a crit :
  
  Yes, see example at FOSS4GIS 2010 Benchmark:  [LINK:
  http://wiki.osgeo.org/wiki/Benchmarking_2010]
  http://wiki.osgeo.org/wiki/Benchmarking_2010#MapServer
  
  ---Original Message---  From: Guillaume BARTHE [LINK:
  mailto:guillaume.bar...@c-s.fr] guillaume.bar...@c-s.fr  To: [LINK:
  mailto:mapserver-users@lists.osgeo.org] mapserver-users@lists.osgeo.org
  Subject: [mapserver-users] [Oracle] Geo raster with oracle spatial  Sent:
  Jan 18 '11 05:06Hi,Is it possible to interface mapserver and geo
  raster stored in oracle  spatial database ?Thank you.Guillaume
  --  [LINK: [LINK: http://www.c-s.fr] www.c-s.fr]  GUILLAUME 
 BARTHE
  Ingnieur d'tude sur KHEPERCS SYSTEGRAVE;MES D\'INFORMATION - DIVISION
  ESPACE  RENSEIGNEMENT  Dpartement Information Gographique  Image  Parc de
  la Grande Plaine - 5, Rue Brindejonc des Moulinais - BP 15872  31506
  Toulouse Cedex 05 - FRANCE  Tel : +33 561 17 63 70  Email : [LINK: [LINK:
  mailto:guillaume.bar...@c-s.fr] mailto:guillaume.bar...@c-s.fr] [LINK:
  mailto:guillaume.bar...@c-s.fr] guillaume.bar...@c-s.fr
    ___
  mapserver-users mailing list  [LINK: [LINK:
  mailto:compose.php?to=mapserver-users@lists.osgeo.org]
  compose.php?to=mapserver-users@lists.osgeo.org]  [LINK:
  mailto:mapserver-users@lists.osgeo.org] mapserver-users@lists.osgeo.org
  [LINK: [LINK: http://lists.osgeo.org/mailman/listinfo/mapserver-users]
  http://lists.osgeo.org/mailman/listinfo/mapserver-users]  [LINK:
  http://lists.osgeo.org/mailman/listinfo/mapserver-users]
  http://lists.osgeo.org/mailman/listinfo/mapserver-users
  
  
  
  ___
  mapserver-users mailing list
  [LINK: compose.php?to=mapserver-users@lists.osgeo.org]
  mapserver-users@lists.osgeo.org
  [LINK: http://lists.osgeo.org/mailman/listinfo/mapserver-users]
  http://lists.osgeo.org/mailman/listinfo/mapserver-users
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] Is --with-experimental-png still experimental ?

[Ivan Mincik]

Hi,
I am using compile option  --with-experimental-png for some 2 Years
on all production machines to produce nice quantized PNG images. I
would like to ask, if this option should be still marked as
experimental ?


My setting:
1. Debian Lenny
2. Mapserver 5.2 - 5.6
3. Mapfile

   IMAGETYPE 'AGG_PNG'
   OUTPUTFORMAT
   NAME 'AGG_PNG'
   DRIVER 'AGG/PNG'
   MIMETYPE 'image/png'
   IMAGEMODE RGBA
   FORMATOPTION 'QUANTIZE_FORCE=ON'
   FORMATOPTION 'QUANTIZE_DITHER=OFF'
   FORMATOPTION 'QUANTIZE_COLORS=256'
   FORMATOPTION 'INTERLACE=OFF'
   EXTENSION 'png'
   END

Thanks,
Ivan
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] Is --with-experimental-png still experimental ?

[Ivan Mincik]

On Mon, Jan 17, 2011 at 1:09 PM, thomas bonfort
thomas.bonf...@gmail.com wrote:
 Ivan,
 for the 5.x branches, it will stay like that.
 for the 6.0 and subsequent releases, the flag is removed and the
 functionality is native.

Thanks a lot for answer.

Ivan
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] Typo on Mapserver homepage

[Ivan Mincik]

Hi,
there is a typo in Announcements paragraph (version 5.6.5). MapServer
5.6.3 has been released  should be MapServer 5.6.5 has been
released ...

Ivan
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] White lines when reprojecting aerial photo

[Ivan Mincik]

 Also, this will slow it down but in the raster layer

 PROCESSING RESAMPLE=BICUBIC rather than default NEAREST is effective
 especially for hi-rez data.

Thanks a lot Mark, I totally forgot on resampling methods. I have
tried BICUBIC which doesn't work, but BILINEAR is working fine.

Ivan
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] White lines when reprojecting aerial photo

[Ivan Mincik]

Hi,
we are trying to provide aerial photo images in multiple projections
using on-the-fly reprojection in JPEG format. When reprojecting layer
from our country's local projection to Google Mercator, thin white
lines appearing through the whole image (see
http://gista.sk/home/ivo/dl/white_lines.jpeg).

We are using 'AGG/JPEG' driver, Mapserver 5.2 with following
outputformat configuration:

      RESOLUTION 72
      OUTPUTFORMAT
               NAME 'AGG_JPEG'
               DRIVER 'AGG/JPEG'
               MIMETYPE 'image/jpeg'
               IMAGEMODE RGB
               FORMATOPTION 'QUALITY=85'
               EXTENSION 'jpg'
       END

Any idea what I can improve to get these white lines out ?

Thanks,
Ivan
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] PNG Optimization

[Ivan Mincik]

2010/12/10 Cédric MOULLET cedric.moul...@gmail.com:
 Hi,
 We are using MapServer to generate tiles and the following ouptut format is
 used:

 OUTPUTFORMAT
  NAME pnga
  MIMETYPE image/pnga
  DRIVER AGG/PNG
  EXTENSION png
  IMAGEMODE RGBA
  TRANSPARENT TRUE
  FORMATOPTION INTERLACE=OFF
 END

 We observe that the size of the tiles can be reduced by a at least factor 2
 if we use a tool like optipng.
 Is it possible to configure MapServer in order to optimize the file output
 (and for example use optipng)  ? Or do you see another way to optimize the
 image (I'd like to do that on the MapServer side in order to avoid a
 postprocessing) ?
 Thanks in advance for any hints.
 Cédric

Hi Cedric,
when You compile Your Mapserver with –with-experimental-png option
You can have very nice quantized PNG images, which can be much more
smaller. We are using this option for all our projects for few years
now.

Configuration example:

IMAGETYPE 'AGG_PNG'
OUTPUTFORMAT
NAME 'AGG_PNG'
DRIVER 'AGG/PNG'
MIMETYPE 'image/png'
IMAGEMODE RGBA
FORMATOPTION 'QUANTIZE_FORCE=ON'
FORMATOPTION 'QUANTIZE_DITHER=OFF'
FORMATOPTION 'QUANTIZE_COLORS=256'
FORMATOPTION 'INTERLACE=OFF'
EXTENSION 'png'
END

More here: http://mapserver.org/mapfile/outputformat.html

Ivan
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] Mapserver + OCI error while loading shared libraries from Apache ?

[Ivan Lucena]

Sebastian,

  ---Original Message---
  From: Sebastian E. Ovide sebastian.ov...@gmail.com
  To: mapserver-users@lists.osgeo.org
  Subject: [mapserver-users] Mapserver + OCI error while loading shared 
 libraries from Apache ?
  Sent: Nov 18 '10 11:54
  
  Hi All,
  
  
  everything is working find from shell. I register the Oracle libraries with
  ldconfig, I have even created a cgi that set the LD_LIBRARY_PATH
  
  
  [...@mapserver-fc14 cgi-bin]$ cat test.sh
  #!/bin/sh
  export ORACLE_HOME=/home/gis/libs/instantclient_11_2/
  export LD_LIBRARY_PATH=/home/gis/libs/instantclient_11_2/
  /var/www/cgi-bin/mapserv $*
  
  
  and still getting 
  
  
  [Thu Nov 18 16:50:06 2010] [error] [client 10.0.1.50]
  /var/www/cgi-bin/mapserv: error while loading shared libraries:
  libclntsh.so.11.1: cannot open shared object file: No such file or
  directory

Does that message means that the error occurs during the process of loading 
libclntsh.so.11.1 and therefor that library was found but that library is 
trying to load another one that is not on the path?

  [Thu Nov 18 16:50:06 2010] [error] [client 10.0.1.50] Premature end of
  script headers: test.sh
  
  
  any ideas ?
  
  
  note: this problem is on a Fedora 14--
  Sebastian E. Ovide
  
  
  
  ___
  mapserver-users mailing list
  [LINK: compose.php?to=mapserver-us...@lists.osgeo.org]
  mapserver-users@lists.osgeo.org
  [LINK: http://lists.osgeo.org/mailman/listinfo/mapserver-users]
  http://lists.osgeo.org/mailman/listinfo/mapserver-users
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] mapserver.org down ?

[Ivan Mincik]

 Could not get 'http://mapserver.org/'. Is it down ?

--
Ivan

___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] mapserver.org down ?

[Ivan Mincik]

 On 10/18/2010 01:04 PM, christopher.schm...@nokia.com wrote:

On Oct 18, 2010, at 5:23 AM, ext Ivan Mincik wrote:


Could not get 'http://mapserver.org/'. Is it down ?

The MapServer site was temporarily unavailable. I've
resolved the situation, and the website appears to be
working again.

Best Regards,
Christopher Schmidt


Thanks.

--
Ivan Mincik, Gista s.r.o.

___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] Shell-script to compile MapServer in a user directory tree

[Ivan Mincik]

On Fri, Oct 8, 2010 at 8:56 PM, Jan Hartmann j.l.h.hartm...@uva.nl wrote:
 Hi all,

 The last few months I have been working in a Cloud environment with lots of
 virtual machines, all with MapServer, PostGIS and PL/R. I couldn't work with
 binaries, since different sites needed different configurations. It's not
 difficult to compile MapServer once you have done it a few times, but it
 becomes boring if you need to do it dozens of times. So I made a
 shell-script that on the one hand compiles the whole MapServer-PostGIS-PLR
 suite with one command, but leaves the possibility to adapt every
 configuration parameter. Everything is done at the user level: no super user
 rights are needed, no system files are changed, and the whole installation
 takes place within a single directory tree. Multiple installations can
 coexist on the same computer.  You can find it, together with instructions,
 at:

 http://mapserver.sara.nl/Install

 I tried out four different configurations on dozens of virtual machines,
 installed from standard distribution DVD's: Debian, Fedora, Suse and the
 OSGEO Live CD (Xubuntu) , so I'm reasonably sure it works on fresh, modern
 installation. Older and much-used systems could give trouble, although I
 don't expect many problems there either. Let me know if this is useful for
 you and how it could be  ameliorated.

Jan, thanks for sharing this nice idea.

Ivan
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] logging GDAL queries

[Ivan Lucena]

Hi Sebastian,

Did you fix the problem with the pyramid levels?

Do you see any improved where the performance was poor before?

Thanks for your valuable test. I appreciate.

Regards,

Ivan 
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] logging GDAL queries

[Ivan Lucena]

Sebastian,

   the performance has not improved. Why should it ? the extra pyramid
  levels contains 46x66, 23x33, 11x16, 5x8, 2x4, 1x2 but the problems
  that I am having are for 95162x135711, 47581x67855, 23790x33927,
  11895x16963... that are low pyramid levels... (ie: high zoom=low pyramid
  level)...

If you are still having problem with MapViewer I suggest you to post your log 
at [http://forums.oracle.com/forums/forum.jspa?forumID=727]. Any improvement on 
MapServer+GeoRaster through GDAL would take a little bit of time to adapt the 
initial ETL design.

Regards,

Ivan

___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] logging GDAL queries

[Lucena, Ivan]

Sebastian,

I have this little piece of code in Python that shows how 18 levels of pyramids 
would look like:

rows = 271423
cols = 190325
bxs = 256
bys = 256
t = 0
for i in range(0,18,1):
c = int( round( cols / 2 ** i ) )
r = int( round( rows / 2 ** i ) )
if ( c = ( bxs / 2 ) ) and ( r = ( bys / 2 ) ):
w = c
h = r
else:
w = bxs
h = bys
bc = int( max(1, c / w ) )
br = int( max(1, r / h ) )
t += bc * br
print i, c, r, bc, br, t

And here is the output:

0 190325 271423 743 1060 787580
1 95162 135711 371 530 984210
2 47581 67855 185 265 1033235
3 23790 33927 92 132 1045379
4 11895 16963 46 66 1048415
5 5947 8481 23 33 1049174
6 2973 4240 11 16 1049350
7 1486 2120 5 8 1049390
8 743 1060 2 4 1049398
9 371 530 1 2 1049400
10 185 265 1 1 1049401
11 92 132 1 1 1049402
** What you don't have: **
12 46 66 1 1 1049403
13 23 33 1 1 1049404
14 11 16 1 1 1049405
15 5 8 1 1 1049406
16 2 4 1 1 1049407
17 1 2 1 1 1049408

Where:

i  = level
c  = size of the level in columns
r  = size of the level in rows
bc = number of blocks per column
br = number of blocks per row
t  = total number of blocks

You said that “it performs very well at zoom level under 12” and performs poorly with zoom level 
between 13 and 17.


The problem is that you don't have those levels built into your GeoRaster 
object.

So, before doing any change to the system settings, could you please try to increase the number of 
pyramids to 17?


Building the pyramids is a internal process on the server. Even if you use gdaladdo, that will just 
call a function from the GeoRaster PL/SQL extension.


It wouldn't take as long as before because it will add up to the existing 
levels.

The PL/SQL call should looks like that:

declare
  gr sdo_georaster;
begin
  select georaster into gr from fluvd04q200pj where id = 1 for update;
  sdo_geor.generatePyramid(gr, 'rlevel=17 resampling=NN');
  update fluvd04q200pj set georaster = gr where id = 1;
  commit;
end;
/

And the gdaladdo command should look like that:

gdaladdo georaster:geoserver,geoserver,MFPRODUK_11G,fluvd04q200pj,georaster,id=1 2 4 8 16 32 64 128 
256 512 1024 2048 4096 8192 16384 32768 65536


Best regards,

Ivan


Sebastian E. Ovide wrote:

Ivan,



Yes!

and

No!

That query creates a *cursor* to go through the whole raster,
meaning, all the rows on the RasterDataTable that satisfy that query
in the order stipulated by it.

It does require a some memory but it looks like you got it. 



mmm... that makes me little bit nervous... I am testing it with a small 
map. Its is only UK with 5mx5m pixel Just wondering how this 
approach would scale to larger maps... US is 40 times bigger than UK... 
and they have more accurated maps and more than a single layer 
Just wondering how many manual configuration I'll be forced to do 
(Oracle created Spatial extention exactly for this reason... so the 
developer do not to think about handling blobs for him self anymore... 
reducing costs and risks)
 



By the way, how long does it take to produce a geotiff file? Have
loaded that image on QuantumGIS using the oracle_raster plugin? Hoes
does it perform?


it is not possible to create a TIFF as it would be too big (max size is 
4GB)... and UK would be arounf 16GB (300MB in Oracle as I'm using deflate)


I am testing Oracle MapViewer on the same table and it HAS the same 
problem The strange thing is that using MapBuilder (Oracle software 
to prepare the maps to use with MapViewer) the maps are displayed very 
fast at ANY zoom level !... therefore there is a way to do it fast (as 
MapBuilder does...)
 



I was expecting to find in the logs some query that reads a
subset of the whole image (just the tile/metatile that MapServer
is serving) for example using SDO_GEOR.getRasterSubset..


That would be very slow. The GDAL driver access the BLOB directly.

 
not sure about that... well I guess that at least it releases some work 
from the Oracle server...  Anyway, as I have a spatial index, why don't 
just query only the right blobs?



I have more questions:

Are you using Mapserver FastCGI with a recent version?


nop... I have not tried that yet... I'll try on Monday... I have tried 
as cgi and recently as mod_python.
 


If you do, them the process will remains in memory, the GDALDataset
associated with that GeoRaster will be keet, the *cursor* you remain
alive and all the zooms and pans are going to work faster. Like for
QGIS. Unless, of course, Mapserver is feeling the need to re-project
or produce a new overview tiles on the fly. Can you see that on the log?

Regards,

Ivan


regards


--
Sebastian E. Ovide





___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] logging GDAL queries

[Lucena, Ivan]

Sebastian,

Sebastian E. Ovide wrote:

Hi Ivan,



Because of that, to access your GeoRaster object, the GDAL driver is
requesting a very large array of BLOB (100 approximately). T


I do not know how apServer/GDAL works, but I cannot understand this query: 



[Fri Aug 13 13:53:00 2010] [error] [client 10.0.1.40] SELECT RASTERBLOCK
[Fri Aug 13 13:53:00 2010] [error] [client 10.0.1.40] FROM   
RDT_FLUVD04Q200PJ
[Fri Aug 13 13:53:00 2010] [error] [client 10.0.1.40] WHERE  RASTERID = 
:1 AND
[Fri Aug 13 13:53:00 2010] [error] [client 10.0.1.40]
PYRAMIDLEVEL = :3

[Fri Aug 13 13:53:00 2010] [error] [client 10.0.1.40] ORDER BY
[Fri Aug 13 13:53:00 2010] [error] [client 10.0.1.40]
BANDBLOCKNUMBER ASC,
[Fri Aug 13 13:53:00 2010] [error] [client 10.0.1.40]
ROWBLOCKNUMBER ASC,
[Fri Aug 13 13:53:00 2010] [error] [client 10.0.1.40]
COLUMNBLOCKNUMBER ASC


It looks like  MapServer/GDAL is trying to read the whole pyramid level 
X of the table RDT_FLUVD04Q200PJ ? 


Am I right ?

at level 0 it would read the whole raster 



Yes!

and

No!

That query creates a *cursor* to go through the whole raster, meaning, all the rows on the 
RasterDataTable that satisfy that query in the order stipulated by it.


It does require a some memory but it looks like you got it. Right? I assuming that because you said 
that gdal_translate loaded those 51 Gb in 5 minutes.


By the way, how long does it take to produce a geotiff file? Have loaded that image on QuantumGIS 
using the oracle_raster plugin? Hoes does it perform?


I was expecting to find in the logs some query that reads a subset of 
the whole image (just the tile/metatile that MapServer is serving) for 
example using SDO_GEOR.getRasterSubset.. 


That would be very slow. The GDAL driver access the BLOB directly.

I have more questions:

Are you using Mapserver FastCGI with a recent version?

If you do, them the process will remains in memory, the GDALDataset associated with that GeoRaster 
will be keet, the *cursor* you remain alive and all the zooms and pans are going to work faster. 
Like for QGIS. Unless, of course, Mapserver is feeling the need to re-project or produce a new 
overview tiles on the fly. Can you see that on the log?


Regards,

Ivan

___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] logging GDAL queries

[Lucena, Ivan]

Sebastian,

Sebastian E. Ovide wrote:

Hi All

I am using MapServer + GDAL to render GeoRasters and I am having very 
poor performance reading GeoRasters at a high zoom level... over 13... 
it would take even 20 seconds per tile...


Did you generate pyramids?



Is it possible to log the GDAL queries that MapServer is doing?  (and 
the SQL queries that GDAL is doing ?)


thanks

--
Sebastian E. Ovide






___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users


___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] logging GDAL queries

[Lucena, Ivan]

Interesting.
Can you post your gdalinfo report with -mdd oracle option?
What are the versions your are running (GDAL,Oracle)?
Older version of the driver used to run a new query every time you change 
levels.
Sebastian E. Ovide wrote:
yep I did... and the weir thing is that generating the images from far 
away zoom under 12... it performs very well... not sure why it doesn't 
in the levels 13-17  for that reason I was trying to find the SQL 
queries


On Fri, Aug 13, 2010 at 12:01 PM, Lucena, Ivan ivan.luc...@pmldnet.com 
mailto:ivan.luc...@pmldnet.com wrote:


Sebastian,


Sebastian E. Ovide wrote:

Hi All

I am using MapServer + GDAL to render GeoRasters and I am having
very poor performance reading GeoRasters at a high zoom level...
over 13... it would take even 20 seconds per tile...


Did you generate pyramids?


Is it possible to log the GDAL queries that MapServer is doing?
 (and the SQL queries that GDAL is doing ?)

thanks

-- 
Sebastian E. Ovide








___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
mailto:mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users





--
Sebastian E. Ovide






___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] logging GDAL queries

[Ivan Lucena]

Sebastian,

You are using a very small block size, maybe because you are also using ArcGIS 
products and they only support Oracle GeoRaster with 256x256 blocking. Is that 
right?

Because of that, to access your GeoRaster object, the GDAL driver is requesting 
a very large array of BLOB (100 approximately). That can make your sever 
such-up memory from the machine where it is running and it is probably using 
virtual memory (disk) what is really slow. It also uses some memory on the 
client side just to hold the array too but if you are running everything 
(Mapserver,Oracle) on the same machine that will adds up.

We are aware of that problem but it would be very helpful if you could file a 
bug report on GDAL's trac [http://trac.osgeo.org/gdal/] Thanks. 

Just as curiosity. Did you loaded that image with gdal_translate? How long it 
took and long does it takes to generate pyramids? Ha, you forgot to say what 
version of Oracle you are using.

Best regards,

Ivan



  ---Original Message---
  From: Sebastian E. Ovide sebastian.ov...@gmail.com
  To: Lucena, Ivan ivan.luc...@pmldnet.com
  Cc: mapserver-users@lists.osgeo.org
  Subject: Re: [mapserver-users] logging GDAL queries
  Sent: Aug 13 '10 06:44
  
  sure...
  
  
  se...@seanspc:~/mapserver/mapserver-5.6.5$ gdalinfo --version
  GDAL 1.7.2, released 2010/04/23
  
  se...@seanspc:~/mapserver/mapserver-5.6.5$ gdalinfo
  georaster:geoserver,geoserver,MFPRODUK_11G,fluvd04q200pj,georaster,id=1
  -mdd oracle
  Driver: GeoRaster/Oracle Spatial GeoRaster
  Files: none associated
  Size is 190325, 271423
  Coordinate System is:
  PROJCS[Popular Visualisation CRS / Mercator (deprecated),
      GEOGCS[Popular Visualisation CRS,
      DATUM[Popular_Visualisation_Datum,
      SPHEROID[Popular Visualisation Sphere,6378137,0,
      AUTHORITY[EPSG,7059]],
      TOWGS84[0,0,0,0,0,0,0],
      AUTHORITY[EPSG,6055]],
      PRIMEM[Greenwich,0,
      AUTHORITY[EPSG,8901]],
      UNIT[degree,0.01745329251994328,
      AUTHORITY[EPSG,9122]],
      AUTHORITY[EPSG,4055]],
      UNIT[metre,1,
      AUTHORITY[EPSG,9001]],
      PROJECTION[Mercator_1SP],
      PARAMETER[central_meridian,0],
      PARAMETER[scale_factor,1],
      PARAMETER[false_easting,0],
      PARAMETER[false_northing,0],
      EXTENSION[PROJ4,+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0
  +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgri...@null +wktext 
  +no_defs],
      AUTHORITY[EPSG,3785],
      AXIS[X,EAST],
      AXIS[Y,NORTH]]
  Origin = (-703633.464883987908252,7805920.616936270147562)
  Pixel Size = (4.999,-5.000)
  Metadata (oracle):
    TABLE_NAME=fluvd04q200pj
    COLUMN_NAME=georaster
    RDT_TABLE_NAME=RDT_FLUVD04Q200PJ
    RASTER_ID=62
    METADATA=georasterMetadata xmlns=[LINK:
  http://xmlns.oracle.com/spatial/georaster]
  http://xmlns.oracle.com/spatial/georaster;
    objectInfo
      rasterType20001/rasterType
      isBlankfalse/isBlank
      defaultRed1/defaultRed
      defaultGreen1/defaultGreen
      defaultBlue1/defaultBlue
    /objectInfo
    rasterInfo
      cellRepresentationUNDEFINED/cellRepresentation
      cellDepth8BIT_U/cellDepth
      NODATA255/NODATA
      totalDimensions2/totalDimensions
      dimensionSize type=ROW
    size271423/size
      /dimensionSize
      dimensionSize type=COLUMN
    size190325/size
      /dimensionSize
      ULTCoordinate
    row0/row
    column0/column
      /ULTCoordinate
      blocking
    typeREGULAR/type
    totalRowBlocks1061/totalRowBlocks
    totalColumnBlocks744/totalColumnBlocks
    rowBlockSize256/rowBlockSize
    columnBlockSize256/columnBlockSize
      /blocking
      interleavingBIP/interleaving
      pyramid
    typeDECREASE/type
    resamplingNN/resampling
    maxLevel11/maxLevel
      /pyramid
      compression
    typeDEFLATE/type
      /compression
    /rasterInfo
    spatialReferenceInfo
      isReferencedtrue/isReferenced
      isRectifiedtrue/isRectified
      SRID3785/SRID
      spatialResolution dimensionType=X
    resolution5/resolution
      /spatialResolution
      spatialResolution dimensionType=Y
    resolution5/resolution
      /spatialResolution
      modelCoordinateLocationCENTER/modelCoordinateLocation
      modelTypeFunctionalFitting/modelType
      polynomialModel rowOff=0 columnOff=0 xOff=0 yOff=0 zOff=0
  rowScale=1 columnScale=1 xScale=1 yScale=1 zScale=1
    pPolynomial pType=1 nVars=2 order=1 nCoefficients=3
      polynomialCoefficients1561183.623387254 0
  -0.2/polynomialCoefficients
    /pPolynomial
    qPolynomial pType=1 nVars=0 order=0 nCoefficients=1
      polynomialCoefficients1/polynomialCoefficients
    /qPolynomial
    rPolynomial pType=1 nVars=2 order=1 nCoefficients=3
      polynomialCoefficients140726.1929767976 0.2
  0/polynomialCoefficients
    /rPolynomial
    sPolynomial pType=1 nVars=0

Re: [mapserver-users] Re: logging GDAL queries

[Ivan Lucena]

Interesting.

Why does it need to perform two requires for the same level?

I believe that mapserver is doing that. It is running GDALOpen() twice on the 
same raster/level.

In fact it should run that query just once, at the first GDALOpen(), like 
QuantumGIS does. So for each zoom level it goes through the cursor (array of 
BLOB) built by that query. But don't be scary of that. It is not loading any 
raster block in memory at that time.

But I understand that by the nature of Mapserver and that GDAL expectation is 
file reader, that is how it works. It opens and close files several times. 

Good thing is that at least while GDAL is in memory we can reuse the database 
connection. It might be part of the solution.

Regards,

Ivan



  ---Original Message---
  From: Sebastian E. Ovide sebastian.ov...@gmail.com
  To: Sumit Sharma sumit...@hotmail.com
  Cc: mapserver-users@lists.osgeo.org
  Subject: Re: [mapserver-users] Re: logging GDAL queries
  Sent: Aug 13 '10 07:58
  
  Sumit,
  
  The size of the pyramid image at each level is determined by the  original
  image size and the pyramid level, according to the following  formulas:
  
  r(n) = (int)(r(0) / 2^n)
  c(n) = (int)(c(0) / 2^n)
  
  
  there are strange queries been executed
  
  for example, at ANY zoom level I can see this one: (see level 3 !)
  
  [Fri Aug 13 13:53:00 2010] [error] [client 10.0.1.40] GDAL:
  
 GDALOpen(georaster:geoserver,geoserver,MFPRODUK_11G,fluvd04q200pj,georaster,id=1,
  this=0x2986210) succeeds as GeoRaster.
  [Fri Aug 13 13:53:00 2010] [error] [client 10.0.1.40] PL/SQL:
  [Fri Aug 13 13:53:00 2010] [error] [client 10.0.1.40] SELECT RASTERBLOCK
  [Fri Aug 13 13:53:00 2010] [error] [client 10.0.1.40] FROM  
  RDT_FLUVD04Q200PJ
  [Fri Aug 13 13:53:00 2010] [error] [client 10.0.1.40] WHERE  RASTERID = :1
  AND
  [Fri Aug 13 13:53:00 2010] [error] [client 10.0.1.40]   
  PYRAMIDLEVEL = :3
  [Fri Aug 13 13:53:00 2010] [error] [client 10.0.1.40] ORDER BY
  [Fri Aug 13 13:53:00 2010] [error] [client 10.0.1.40]   
  BANDBLOCKNUMBER ASC,
  [Fri Aug 13 13:53:00 2010] [error] [client 10.0.1.40]   
  ROWBLOCKNUMBER ASC,
  [Fri Aug 13 13:53:00 2010] [error] [client 10.0.1.40]   
  COLUMNBLOCKNUMBER ASC
  [Fri Aug 13 13:53:00 2010] [error] [client 10.0.1.40]
  [Fri Aug 13 13:53:00 2010] [error] [client 10.0.1.40] GDAL:
  
 GDALOpen(georaster:geoserver,geoserver,MFPRODUK_11G,fluvd04q200pj,georaster,id=1,
  this=0x18be210) succeeds as GeoRaster.
  [Fri Aug 13 13:53:00 2010] [error] [client 10.0.1.40] PL/SQL:
  [Fri Aug 13 13:53:00 2010] [error] [client 10.0.1.40] SELECT RASTERBLOCK
  [Fri Aug 13 13:53:00 2010] [error] [client 10.0.1.40] FROM  
  RDT_FLUVD04Q200PJ
  [Fri Aug 13 13:53:00 2010] [error] [client 10.0.1.40] WHERE  RASTERID = :1
  AND
  [Fri Aug 13 13:53:00 2010] [error] [client 10.0.1.40]   
  PYRAMIDLEVEL = :3
  [Fri Aug 13 13:53:00 2010] [error] [client 10.0.1.40] ORDER BY
  [Fri Aug 13 13:53:00 2010] [error] [client 10.0.1.40]   
  BANDBLOCKNUMBER ASC,
  [Fri Aug 13 13:53:00 2010] [error] [client 10.0.1.40]   
  ROWBLOCKNUMBER ASC,
  [Fri Aug 13 13:53:00 2010] [error] [client 10.0.1.40]   
  COLUMNBLOCKNUMBER ASC
  [Fri Aug 13 13:53:00 2010] [error] [client 10.0.1.40]
  
  
  why ?
  
  
  On Fri, Aug 13, 2010 at 12:56 PM, Sumit Sharma [LINK:
  mailto:sumit...@hotmail.com] sumit...@hotmail.com wrote:
  
  I think there are 11 pyramid levels. could that be a problem? I am not an
  expert in GeoRaster, is it possible to create internal tiles in GeoRaster?
  if yes then, it may help you enhancing the performance
  --
  View this message in context: [LINK:
  
 http://osgeo-org.1803224.n2.nabble.com/logging-GDAL-queries-tp5419225p5419742.html]
  
 http://osgeo-org.1803224.n2.nabble.com/logging-GDAL-queries-tp5419225p5419742.html
  Sent from the Mapserver - User mailing list archive at Nabble.com.
  
  ___
  mapserver-users mailing list
  [LINK: mailto:mapserver-us...@lists.osgeo.org]
  mapserver-users@lists.osgeo.org
  
  
  [LINK: http://lists.osgeo.org/mailman/listinfo/mapserver-users]
  http://lists.osgeo.org/mailman/listinfo/mapserver-users
  
  
  --
  Sebastian E. Ovide
  
  
  
  ___
  mapserver-users mailing list
  [LINK: compose.php?to=mapserver-us...@lists.osgeo.org]
  mapserver-users@lists.osgeo.org
  [LINK: http://lists.osgeo.org/mailman/listinfo/mapserver-users]
  http://lists.osgeo.org/mailman/listinfo/mapserver-users
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] logging GDAL queries

[Ivan Lucena]

Sebastian,

  ---Original Message---
  From: Sebastian E. Ovide sebastian.ov...@gmail.com
  To: Ivan Lucena ivan.luc...@pmldnet.com
  Cc: mapserver-users@lists.osgeo.org
  Subject: Re: [mapserver-users] logging GDAL queries
  Sent: Aug 13 '10 09:27
  
  On Fri, Aug 13, 2010 at 1:59 PM, Ivan Lucena [LINK:
  mailto:ivan.luc...@pmldnet.com] ivan.luc...@pmldnet.com wrote:
  Sebastian,
  
  You are using a very small block size, maybe because you are also using
  ArcGIS products and they only support Oracle GeoRaster with 256x256
  blocking. Is that right?
  
  
  nop... I guess that 256x256 if the default gdal_translate block size ?

That is the default on GDAL/GeoRaster driver but you can change it using -co 
BLOCKXSIZE and -co BLOCKYSIZE.

But that would require you to load the image again (and generate Pyramids 
again...)

   
  Because of that, to access your GeoRaster object, the GDAL driver is
  requesting a very large array of BLOB (100 approximately). That can
  make your sever such-up memory from the machine where it is running and it
  is probably using virtual memory (disk) what is really slow.
  
  do you mean where MapServer is running ?
  
  top - 14:41:31 up 7 days,  6:20, 10 users,  load average: 2.81, 1.92,
  1.20
  Tasks: 340 total,   2 running, 338 sleeping,   0 stopped,   0 zombie
  Cpu(s): 11.8%us, 10.4%sy,  7.7%ni, 62.1%id,  0.0%wa,  0.0%hi, 
  8.0%si,  0.0%st
  Mem:  12331240k total,  5992136k used,  6339104k free,   189416k
  buffers
  Swap:  9084716k total,   703708k used,  8381008k free,  1481992k
  cached
  
    PID USER  PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+ 
  COMMAND
  24850 www-data  20   0  533m 330m  18m R   14  2.7   0:00.94
  mapserv
  24852 www-data  20   0  532m 329m  18m S   19  2.7   0:01.22
  mapserv
  24849 www-data  20   0  529m 326m  18m S   16  2.7   0:01.00
  mapserv
  24851 www-data  20   0  517m 314m  18m S   13  2.6   0:00.96
  mapserv
  24853 www-data  20   0  499m 296m  18m S    8  2.5   0:00.75
  mapserv
  24854 www-data  20   0  470m 267m  18m S    5  2.2   0:00.53
  mapserv

Yeah. I am sorry. I called Mapserver a client :)

It is a Oracle client in that case. You probably have another nice machine 
running Oracle.

That is not the problem.

  
     It also uses some memory on the client side just to hold the array too
  but if you are running everything (Mapserver,Oracle) on the same machine
  that will adds up.
  
  
  Oracle is running on another Machine... and is very likely that it is the
  bottle neck...

Maybe not but I believe you have tools on Enterprise Manager to show the volume 
and speed of traffic.

  
  
  We are aware of that problem but it would be very helpful if you could
  file a bug report on GDAL's trac [[LINK: http://trac.osgeo.org/gdal/]
  http://trac.osgeo.org/gdal/] Thanks.
  
  
  I guess that the problem is that MapServer triys to read the whole map
  instead of reading only tile  is that correct ?
      Just as curiosity. Did you loaded that image with gdal_translate? How
  long it took and long does it takes to generate pyramids? Ha, you forgot to
  say what version of Oracle you are using.
  
  
  I loaded it with gdal in around 5 minutes... the pyramid (all levels) has
  been created overnight

You original file was 51 Gb and it was loaded in 5 minutes !
 
See, forget all about network traffic. That is just great.

Note that it doesn't matter if you generate pyramids on PL/SQL or gdaladdo, the 
GDAL driver will call the same PL/SQL statement that you would write yourself.

So I believe that the problem is that Mapserver need to call GDALOpen() several 
times on that GeoRaster and that makes the GDAL driver to run the 
main-big-query several times. That needs to be addressed some how.

Regards,

Ivan





___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] logging GDAL queries

[Ivan Lucena]

Sebastian,

You said:

 yep I did... and the weir thing is that generating the images from far
 away zoom under 12... it performs very well... not sure why it doesn't
 in the levels 13-17  for that reason I was trying to find the SQL
 queries 

But your GeoRaster Pyramid level is maxLevel11/maxLevel 

By the size of you image you should have 20 level.

Can you run sdo_geor.generatePyramid() again changing only the number of 
levels, keeping the same method. That should run faster, keeping the existing 
pyramid levels. 

Please let me know how it works now.

Regards,

Ivan

  ---Original Message---
  From: Ivan Lucena ivan.luc...@pmldnet.com
  To: Sebastian E. Ovide sebastian.ov...@gmail.com
  Cc: mapserver-users@lists.osgeo.org
  Subject: Re: [mapserver-users] logging GDAL queries
  Sent: Aug 13 '10 11:16
  
  Sebastian,
  
    ---Original Message---
    From: Sebastian E. Ovide sebastian.ov...@gmail.com
    To: Ivan Lucena ivan.luc...@pmldnet.com
    Cc: mapserver-users@lists.osgeo.org
    Subject: Re: [mapserver-users] logging GDAL queries
    Sent: Aug 13 '10 09:27
    
    On Fri, Aug 13, 2010 at 1:59 PM, Ivan Lucena [LINK:
    mailto:ivan.luc...@pmldnet.com] ivan.luc...@pmldnet.com wrote:
    Sebastian,
    
    You are using a very small block size, maybe because you are also using
    ArcGIS products and they only support Oracle GeoRaster with 256x256
    blocking. Is that right?
    
    
    nop... I guess that 256x256 if the default gdal_translate block size ?
  
  That is the default on GDAL/GeoRaster driver but you can change it using -co 
 BLOCKXSIZE and -co BLOCKYSIZE.
  
  But that would require you to load the image again (and generate Pyramids 
 again...)
  
     
    Because of that, to access your GeoRaster object, the GDAL driver is
    requesting a very large array of BLOB (100 approximately). That can
    make your sever such-up memory from the machine where it is running and it
    is probably using virtual memory (disk) what is really slow.
    
    do you mean where MapServer is running ?
    
    top - 14:41:31 up 7 days,  6:20, 10 users,  load average: 2.81, 1.92,
    1.20
    Tasks: 340 total,   2 running, 338 sleeping,   0 stopped,   0 zombie
    Cpu(s): 11.8%us, 10.4%sy,  7.7%ni, 62.1%id,  0.0%wa,  0.0%hi, 
    8.0%si,  0.0%st
    Mem:  12331240k total,  5992136k used,  6339104k free,   189416k
    buffers
    Swap:  9084716k total,   703708k used,  8381008k free,  1481992k
    cached
    
      PID USER  PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+ 
    COMMAND
    24850 www-data  20   0  533m 330m  18m R   14  2.7   0:00.94
    mapserv
    24852 www-data  20   0  532m 329m  18m S   19  2.7   0:01.22
    mapserv
    24849 www-data  20   0  529m 326m  18m S   16  2.7   0:01.00
    mapserv
    24851 www-data  20   0  517m 314m  18m S   13  2.6   0:00.96
    mapserv
    24853 www-data  20   0  499m 296m  18m S    8  2.5   0:00.75
    mapserv
    24854 www-data  20   0  470m 267m  18m S    5  2.2   0:00.53
    mapserv
  
  Yeah. I am sorry. I called Mapserver a client :)
  
  It is a Oracle client in that case. You probably have another nice machine 
 running Oracle.
  
  That is not the problem.
  
    
   It also uses some memory on the client side just to hold the array too
    but if you are running everything (Mapserver,Oracle) on the same machine
    that will adds up.
    
    
    Oracle is running on another Machine... and is very likely that it is the
    bottle neck...
  
  Maybe not but I believe you have tools on Enterprise Manager to show the 
 volume and speed of traffic.
  
    
    
    We are aware of that problem but it would be very helpful if you could
    file a bug report on GDAL's trac [[LINK: http://trac.osgeo.org/gdal/]
    http://trac.osgeo.org/gdal/] Thanks.
    
    
    I guess that the problem is that MapServer triys to read the whole map
    instead of reading only tile  is that correct ?
    Just as curiosity. Did you loaded that image with gdal_translate? How
    long it took and long does it takes to generate pyramids? Ha, you forgot 
 to
    say what version of Oracle you are using.
    
    
    I loaded it with gdal in around 5 minutes... the pyramid (all levels) has
    been created overnight
  
  You original file was 51 Gb and it was loaded in 5 minutes !
  
  See, forget all about network traffic. That is just great.
  
  Note that it doesn't matter if you generate pyramids on PL/SQL or gdaladdo, 
 the GDAL driver will call the same PL/SQL statement that you would write 
 yourself.
  
  So I believe that the problem is that Mapserver need to call GDALOpen() 
 several times on that GeoRaster and that makes the GDAL driver to run the 
 main-big-query several times. That needs to be addressed some how.
  
  Regards,
  
  Ivan
  
  
  
  
  
  ___
  mapserver-users mailing list
  mapserver-users@lists.osgeo.org
  http://lists.osgeo.org/mailman/listinfo

Re: [mapserver-users] Mapserver 5.6.3 on Linux 64 bits

[Ivan Mincik]

On Mon, Jun 28, 2010 at 4:52 PM, Ricardo Vilella
vilella.rica...@gmail.com wrote:
 Hi I have a simple question, can compile MapServer 5.6.3 on Debian Lenny
 64-bit? Look in the documentation but did not specify if possible.

Yes, no problem. You can also download source package from Debian
Testing and compile to  DEB package.
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] Mapserver's configuration - Support Oracle Spatial

[Ivan Lucena]

Hi Daiane,

Did you check the installation instruction on that page here: 
http://mapserver.org/installation/oracle.html

Once you are done that SDO_GEOMETRY and SDO_GEORASTER should work.

Regards,

Ivan


  ---Original Message---
  From: Daiane Azevedo de Fraga daiane.a.fr...@gmail.com
  To: mapserver-users@lists.osgeo.org
  Subject: [mapserver-users] Mapserver's configuration - Support Oracle Spatial
  Sent: May 04 '10 12:08
  
  Hello!
  
  I installed  the MapServer 5.0.2 (in Debian) with support for Oracle
  Spatial (--with-oraclespatial=$ORACLE_HOME). However, it does not work yet.
  Errors are appearing in the logfile:
  [Tue May  4 11:47:45 2010].697128 msDrawMap(): Image handling error.
  Failed to draw layer named 'mapa_base'.
  [Tue May  4 11:47:45 2010].700221 msOracleSpatialLayerClose():
  OracleSpatial error. OracleSpatial is not supported
  
  ---
  MapServer version 5.0.2 OUTPUT=GIF OUTPUT=PNG OUTPUT=JPEG OUTPUT=WBMP
  OUTPUT=SVG SUPPORTS=PROJ SUPPORTS=FREETYPE SUPPORTS=WMS_SERVER
  SUPPORTS=WMS_CLIENT SUPPORTS=WFS_SERVER SUPPORTS=WCS_SERVER
  SUPPORTS=THREADS SUPPORTS=GEOS INPUT=EPPL7 INPUT=ORACLESPATIAL INPUT=OGR
  INPUT=GDAL INPUT=SHAPEFILE
  ---
  
  It worked on  Windows!
  
  Any idea...?
  
  NOTE: MapServer did not find the files libnnz10.so and libclntsh.so.10.1,
  so I created  symbolic links to files in the folder $ORACLE_HOME/lib. Is
  this a problem?
  
  
  Thanks!
  
  --
  Daiane Fraga
  
  
  
  ___
  mapserver-users mailing list
  [LINK: compose.php?to=mapserver-us...@lists.osgeo.org]
  mapserver-users@lists.osgeo.org
  [LINK: http://lists.osgeo.org/mailman/listinfo/mapserver-users]
  http://lists.osgeo.org/mailman/listinfo/mapserver-users
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] Same name for GROUP and layer NAME ?

[Ivan Mincik]

On Tue, Apr 6, 2010 at 1:25 PM, Cristiano Sumariva sumar...@gmail.com wrote:
 I checked a little more about WMS.
 Layer group stuff is optional.
 That is why you do not see any group info on XML.
 So no problem in using a group name with same name as layer.

 The Layer tag start the description of layers set.
 Not the layers that belong to group like I suposed.

 More details at manual:
 http://mapserver.org/ogc/wms_server.html#reference-section

 2010/4/6 Cristiano Sumariva sumar...@gmail.com

Cristiano, thanks a lot for Your time.
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] Same name for GROUP and layer NAME ?

[Ivan Mincik]

On Thursday 01 April 2010, you wrote:
 I dont see any trouble on it. They are separate attributes.

Yes, they are separate attributes in mapfile, but in WMS URL, we can use layer 
NAME or GROUP in LAYERS= parameter as 
value with the same meaning.  
Also in GetCapabilities XML there is Namemylay/Name nested in another 
Namemylay/Name, so I am not sure if this is valid.

I don't see any error, but something in my mind tells me, that it is not the 
best idea. But, in fact I need this 
behavior to solve some specific task.


Ivan


 2010/4/1 Ivan Mincik ivan.min...@gista.sk

  Hi,
  is it OK to have same layer NAME and GROUP in one mapfile, like in this
  example (mylay) ?
 
  LAYER CONNECTIONTYPE postgis
 STATUS ON
 NAME 'mylay'
 GROUP 'mylay'
 TYPE LINE
 
  LAYER CONNECTIONTYPE postgis
 STATUS ON
 NAME 'mylay2'
 GROUP 'mylay'
 TYPE LINE
 
  In my case (Mapserver 5.2.x) it is working well, but I am not sure if it
  is good practise and also if it is going to
  work in higher versions.


signature.asc
Description: This is a digitally signed message part.
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] Same name for GROUP and layer NAME ?

[Ivan Mincik]

On Thu, Apr 1, 2010 at 3:09 PM, Cristiano Sumariva sumar...@gmail.com wrote:
 Unfortunely I dont use WMS services yet.
 But looks like invalid generated XML if Name is nested inside Name.
 On this case I suggest filling a bug request.

 Since they are separate attributes they should not generate the same XML
 mark.
 The tag should be GroupName or should be Group
 Group tag and
 Namethe group name/Name
 Layer
   Namename ...
 /Layer
 /Group

 or

 Group
   GroupNamethe group name ...
   Namelayer1 ..
   Name layer2
 I relying on XML documents I already parsed since don t used WMS features
 yet again.


This is the snippet from my GetCapabilities. I have GROUP called
'ulicemap' and LAYERS 'ulicemap' and 'ulice_multi'. What do You think
?

Layer
     Nameulicemap/Name
     Titleulicemap/Title
     Abstractulicemap/Abstract
     Layer queryable=1 opaque=0 cascaded=0
       Nameulice_multi/Name
       Titleulice_multi/Title
       SRSEPSG:102067/SRS
       LatLonBoundingBox minx=-64.6562 miny=-68.693
maxx=114.323 maxy=-8.21012 /
       BoundingBox SRS=EPSG:102067
                   minx=-2.5e+07 miny=-2.5e+07 maxx=2.5e+07
maxy=2.5e+07 /
     /Layer
     Layer queryable=1 opaque=0 cascaded=0
       Nameulicemap/Name
       Titleulice/Title
       SRSEPSG:102067/SRS
       LatLonBoundingBox minx=-64.6562 miny=-68.693
maxx=114.323 maxy=-8.21012 /
       BoundingBox SRS=EPSG:102067
                   minx=-2.5e+07 miny=-2.5e+07 maxx=2.5e+07
maxy=2.5e+07 /
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] Same name for GROUP and layer NAME ?

[Ivan Mincik]

Hi,
is it OK to have same layer NAME and GROUP in one mapfile, like in this example 
(mylay) ?

LAYER CONNECTIONTYPE postgis
STATUS ON
NAME 'mylay'
GROUP 'mylay'
TYPE LINE

LAYER CONNECTIONTYPE postgis
STATUS ON
NAME 'mylay2'
GROUP 'mylay'
TYPE LINE

In my case (Mapserver 5.2.x) it is working well, but I am not sure if it is 
good practise and also if it is going to 
work in higher versions.

Thanks
-- 
Ivan 


signature.asc
Description: This is a digitally signed message part.
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] Changing OUTPUTFORMAT via CGI URL

[Ivan Mincik]

Dear Mapserver users,
Is it possible to change OUTPUTFORMAT parameters via CGI URL ?
I have this OUTPUTFORMAT definition:
OUTPUTFORMAT
NAME PNGQ
DRIVER AGG/PNG
MIMETYPE image/png
IMAGEMODE RGBA
FORMATOPTION QUANTIZE_FORCE=ON
FORMATOPTION QUANTIZE_DITHER=OFF
FORMATOPTION QUANTIZE_COLORS=256
FORMATOPTION  INTERLACE=OFF
EXTENSION png
END

and I want to change  FORMATOPTION QUANTIZE_COLORS=256 to FORMATOPTION 
QUANTIZE_COLORS=16.

I have tried all possibilities like 
map.outputformat[PNGQ]=FORMATOPTION+QUANTIZE_COLORS%3d256 and similar.
Can anybody confirm that at least it should be working ?
I am using Mapserver 5.2.2.

Thanks a lot
-- 
Ivan


signature.asc
Description: This is a digitally signed message part.
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] How to add HDF-EOS data layer in MapServer

[Ivan]

Venkat,

I am sorry. Your previous e-mail didn't show the SUBDATASET and then I assumed that you are dealing 
with one unsupported flavor of HDF. But if it showing, great!


If you could use gdal_translate to convert to GeoTIFF you can use the same identification string on 
a DATA parameter.


So, if you ran gdal_translate like that:

{{{
gdal_translate 
HDF5:OMI.he5://HDFEOS/GRIDS/OMI_Column_Amount_O3/Data_Fields/ColumnAmountO3 
output.tif
}}}

Then you should be able to use the same identification on your map file like 
that:

{{{
LAYER
  TYPE RASTER
  DATA 
HDF5:OMI.he5://HDFEOS/GRIDS/OMI_Column_Amount_O3/Data_Fields/ColumnAmountO3
}}}

Some time ago I reported a bug in Mapserver that was preventing those complex GDAL connection string 
to work but I believe its fixed now.


Please, give it a try and let us know if it works or not. And don't forget to mention the GDAL and 
Mapserver version that you are using.


Regards,

Ivan

Venkat Shesu Reddem wrote:

Hi Ivan,

gdalinfo is showing subdataset list also, the previous mail contains
gdalinfo of one of subdataset.  I have used gdal_translate to convert
the following in GeoTIFF image, however i don't have idea about how to
create layer for the given hdf subdataset.

the below is the gdalinfo showing subdataset list:

Driver: HDF5Image/HDF5 Dataset
Files: none associated
Size is 1440, 720
Coordinate System is:
GEOGCS[WGS 84,
DATUM[WGS_1984,
SPHEROID[WGS 84,6378137,298.257223563,
AUTHORITY[EPSG,7030]],
TOWGS84[0,0,0,0,0,0,0],
AUTHORITY[EPSG,6326]],
PRIMEM[Greenwich,0,
AUTHORITY[EPSG,8901]],
UNIT[degree,0.0174532925199433,
AUTHORITY[EPSG,9108]],
AUTHORITY[EPSG,4326]]
Metadata:
  FILE_ATTRIBUTES:OrbitNumber=29703 29704 29705 29706 29707 29708
29709 29710 29711 29712 29713 29714 29715 29716 29717 29718 29719
29720 29721 29722 29723 29724 29725 29726 29727 29728 29729 29730
29731 29732 29733 29734 29735 29736 29737 29738 29739 29740 29741
29742 29743 29744 29745 29746 29747
  FILE_ATTRIBUTES:OrbitPeriod=5933 5934 5933 5934 5933 5934 5933 5934
5933 5934 5933 5933 5934 5933 5934 5933 5934 5933 5934 5933 5934 5933
5934 5933 5934 5933 5934 5933 5934 5933 5934 5933 5933 5934 5934 5933
5934 5933 5933 5934 5933 5934 5933 5934 5933
  FILE_ATTRIBUTES:InstrumentName=OMI
  FILE_ATTRIBUTES:ProcessLevel=3e
  FILE_ATTRIBUTES:GranuleMonth=2
  FILE_ATTRIBUTES:GranuleDay=15
  FILE_ATTRIBUTES:GranuleYear=2010
  FILE_ATTRIBUTES:GranuleDayOfYear=46
  FILE_ATTRIBUTES:TAI93At0zOfGranule=5.40346e+008
  FILE_ATTRIBUTES:PGEVersion=1.0.5.1
  FILE_ATTRIBUTES:StartUTC=2010-02-14T12:15:00.00Z
  FILE_ATTRIBUTES:EndUTC=2010-02-16T11:45:00.00Z
  FILE_ATTRIBUTES:Period=Daily
  OMI Column Amount O3:GCTPProjectionCode=0
  OMI Column Amount O3:Projection=Geographic
  OMI Column Amount O3:GridOrigin=Center
  OMI Column Amount O3:GridSpacing=(0.25,0.25)
  OMI Column Amount O3:GridSpacingUnit=deg
  OMI Column Amount O3:GridSpan=(-180,180,-90,90)
  OMI Column Amount O3:GridSpanUnit=deg
  OMI Column Amount O3:NumberOfLongitudesInGrid=1440
  OMI Column Amount O3:NumberOfLatitudesInGrid=720
  HDFEOS INFORMATION:HDFEOSVersion=HDFEOS_5.1.11
Corner Coordinates:
Upper Left  (0.0,0.0)
Lower Left  (0.0,  720.0)
Upper Right ( 1440.0,0.0)
Lower Right ( 1440.0,  720.0)
Center  (  720.0,  360.0)
Band 1 Block=1440x1 Type=Float32, ColorInterp=Undefined
  Metadata:
RadiativeCloudFraction:_FillValue=-1267650600228229400.00
RadiativeCloudFraction:Units=NoUnits
RadiativeCloudFraction:Title=Radiative Cloud Fraction = fc*Ic331/Im331
RadiativeCloudFraction:UniqueFieldDefinition=TOMS-OMI-Shared
RadiativeCloudFraction:ScaleFactor=1
RadiativeCloudFraction:Offset=0
RadiativeCloudFraction:ValidRange=0.00 1.00
RadiativeCloudFraction:MissingValue=-1267650600228229400.00
Driver: HDF5/Hierarchical Data Format Release 5
Files: OMI.he5
Size is 512, 512
Coordinate System is `'
Metadata:
  FILE_ATTRIBUTES:OrbitNumber=29703 29704 29705 29706 29707 29708
29709 29710 29711 29712 29713 29714 29715 29716 29717 29718 29719
29720 29721 29722 29723 29724 29725 29726 29727 29728 29729 29730
29731 29732 29733 29734 29735 29736 29737 29738 29739 29740 29741
29742 29743 29744 29745 29746 29747
  FILE_ATTRIBUTES:OrbitPeriod=5933 5934 5933 5934 5933 5934 5933 5934
5933 5934 5933 5933 5934 5933 5934 5933 5934 5933 5934 5933 5934 5933
5934 5933 5934 5933 5934 5933 5934 5933 5934 5933 5933 5934 5934 5933
5934 5933 5933 5934 5933 5934 5933 5934 5933
  FILE_ATTRIBUTES:InstrumentName=OMI
  FILE_ATTRIBUTES:ProcessLevel=3e
  FILE_ATTRIBUTES:GranuleMonth=2
  FILE_ATTRIBUTES:GranuleDay=15
  FILE_ATTRIBUTES:GranuleYear=2010
  FILE_ATTRIBUTES:GranuleDayOfYear=46
  FILE_ATTRIBUTES:TAI93At0zOfGranule=5.40346e+008
  FILE_ATTRIBUTES:PGEVersion=1.0.5.1
  FILE_ATTRIBUTES:StartUTC=2010-02-14T12:15:00.00Z
  FILE_ATTRIBUTES:EndUTC=2010-02-16T11:45:00.00Z
  FILE_ATTRIBUTES:Period=Daily
  OMI

Re: [mapserver-users] How to add HDF-EOS data layer in MapServer

[Ivan Lucena]

Hi Venkat,

If gdalinfo is not showing the subdataset list, like in you case, it would be 
impossible to identify a dataset as your DATA parameter.

What version is the GDAL that you are using on command line? Is that the same 
that mapserver is using?

Note that there are some flavors of HDF products that are not supported by all 
version of GDAL/HDF.

Regards,

Ivan


  ---Original Message---
  From: Venkat Shesu Reddem venkat.sh...@gmail.com
  To: mapserver-users@lists.osgeo.org
  Subject: [mapserver-users] How to add HDF-EOS data layer in MapServer
  Sent: Feb 26 '10 11:02
  
  Dear All,
  
  I am trying to add HDF-EOS data layer to MapServer application. Can anyone
  help me in defining the syntax of the layer.
  the following is the gdalinfo for the given HDF dataset
  
  Driver: HDF5Image/HDF5 Dataset
  Files: none associated
  Size is 1440, 720
  Coordinate System is:
  GEOGCS[WGS 84,
     DATUM[WGS_1984,
     SPHEROID[WGS 84,6378137,298.257223563,
     AUTHORITY[EPSG,7030]],
     TOWGS84[0,0,0,0,0,0,0],
     AUTHORITY[EPSG,6326]],
     PRIMEM[Greenwich,0,
     AUTHORITY[EPSG,8901]],
     UNIT[degree,0.0174532925199433,
     AUTHORITY[EPSG,9108]],
     AUTHORITY[EPSG,4326]]
  Metadata:
  FILE_ATTRIBUTES:OrbitNumber=29703 29704 29705 29706 29707 29708 29709
  29710 29711 29712 29713 29714 29715 29716 29717 29718 29719 29720 29721
  29722 29723 29724 29725 29726 29727 29728 29729 29730 29731 29732 29733
  29734 29735 29736 29737 29738 29739 29740 29741 29742 29743 29744 29745
  29746 29747
  FILE_ATTRIBUTES:OrbitPeriod=5933 5934 5933 5934 5933 5934 5933 5934 5933
  5934 5933 5933 5934 5933 5934 5933 5934 5933 5934 5933 5934 5933 5934 5933
  5934 5933 5934 5933 5934 5933 5934 5933 5933 5934 5934 5933 5934 5933 5933
  5934 5933 5934 5933 5934 5933
  FILE_ATTRIBUTES:InstrumentName=OMI
  FILE_ATTRIBUTES:ProcessLevel=3e
  FILE_ATTRIBUTES:GranuleMonth=2
  FILE_ATTRIBUTES:GranuleDay=15
  FILE_ATTRIBUTES:GranuleYear=2010
  FILE_ATTRIBUTES:GranuleDayOfYear=46
  FILE_ATTRIBUTES:TAI93At0zOfGranule=5.40346e+008
  FILE_ATTRIBUTES:PGEVersion=1.0.5.1
  FILE_ATTRIBUTES:StartUTC=2010-02-14T12:15:00.00Z
  FILE_ATTRIBUTES:EndUTC=2010-02-16T11:45:00.00Z
  FILE_ATTRIBUTES:Period=Daily
  OMI Column Amount O3:GCTPProjectionCode=0
  OMI Column Amount O3:Projection=Geographic
  OMI Column Amount O3:GridOrigin=Center
  OMI Column Amount O3:GridSpacing=(0.25,0.25)
  OMI Column Amount O3:GridSpacingUnit=deg
  OMI Column Amount O3:GridSpan=(-180,180,-90,90)
  OMI Column Amount O3:GridSpanUnit=deg
  OMI Column Amount O3:NumberOfLongitudesInGrid=1440
  OMI Column Amount O3:NumberOfLatitudesInGrid=720
  HDFEOS INFORMATION:HDFEOSVersion=HDFEOS_5.1.11
  Corner Coordinates:
  Upper Left  (0.0,0.0)
  Lower Left  (0.0,  720.0)
  Upper Right ( 1440.0,0.0)
  Lower Right ( 1440.0,  720.0)
  Center  (  720.0,  360.0)
  Band 1 Block=1440x1 Type=Float32, ColorInterp=Undefined
  Metadata:
  
  RadiativeCloudFraction:_FillValue=-1267650600228229400.00
     RadiativeCloudFraction:Units=NoUnits
     RadiativeCloudFraction:Title=Radiative Cloud Fraction = fc*Ic331/Im331
     RadiativeCloudFraction:UniqueFieldDefinition=TOMS-OMI-Shared
     RadiativeCloudFraction:ScaleFactor=1
     RadiativeCloudFraction:Offset=0
     RadiativeCloudFraction:ValidRange=0.00 1.00
  
  RadiativeCloudFraction:MissingValue=-1267650600228229400.00
  ---
  
  with thanks  regards
  Venkat
  ___
  mapserver-users mailing list
  mapserver-users@lists.osgeo.org
  http://lists.osgeo.org/mailman/listinfo/mapserver-users
  
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] Re: mapserver documentation: unique gid using srid=x ?

[Ivan Mincik]

Hi,
according Mapserver docs: http://mapserver.org/input/vector/postgis.html there 
is different syntax of using USING 
UNIQUE gid USING SRID=x string in DATA  line in similar cases.

In simple case example:
DATA the_geom from the_database USING unique gid using srid=4326

In case of using a SQL subquery example:
DATA the_geom from (select g.gid, g.the_geom, a.attr1, a.attr2 from geotable 
g join attrtable a on g.gid = a.aid) as 
subquery unique gid using srid=4326

When comparing these two examples, second example (SQL subquery example) is 
missing first USING keyword. Shouldn't be 
second example as following:
DATA the_geom from (select g.gid, g.the_geom, a.attr1, a.attr2 from geotable 
g join attrtable a on g.gid = a.aid) as 
subquery USING unique gid using srid=4326

When testing on Mapserver 5.2.x, it seems to be typo in documentation. If I am 
correct, would You please fix it ?

Thanks. Ivan


signature.asc
Description: This is a digitally signed message part.
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] How to render raster data using Oracle Georaster?

[Ivan]

xxj wrote:

Hi folks,

Is Oracle Georaster supported by MapServer?

I am using MapServer5.6.0 and can render vector data using Oracle
successfully. But when I was trying raster data using Oracle database, the
following errors happens.

Errors:

?xml version='1.0' encoding=ISO-8859-1 standalone=no ?
!DOCTYPE ServiceExceptionReport SYSTEM
http://schemas.opengis.net/wms/1.1.1/exception_1_1_1.dtd;
ServiceExceptionReport version=1.1.1
ServiceException
msDrawMap(): Image handling error. Failed to draw layer named
#39;bluemarble#39;.
msDrawRaster(): Unable to access file.
georaster:wz/w...@orclat18,sf_rasters,georaster,georid=101 using full path
georaster:wz/w...@orclat18,sf_rasters,georaster,georid=101
/ServiceException
/ServiceExceptionReport

My layer definition in mapfile is as following:

LAYER
NAME bluemarble
TYPE raster
STATUS ON
#CONNECTIONTYPE oraclespatial
#CONNECTION wz/w...@orclat18
#DATA geor:wz/w...@orclat18,student_rdt_01,id=1 
DATA georaster:wz/w...@orclat18,sf_rasters,georaster,georid=101

#DATA drgncimq1926.tif
#DATA georaster from sf_rasters using srid 8307 
#DATA GEOR:temporary.vrt

CLASS
  EXPRESSION ([pixel] = 0 AND [pixel] = 1000)
  STYLE
COLOR 255 0 0
  END
END
METADATA
  WMS_TITLE bluemarble
  WMS_ABSTRACT bluemarble.
  WMS_SRS EPSG:4326
END
END

I am very sure that GDAL and GeoRaster are compiled into MapServer and well
configured for the belows are the output about them.

Output of mapserv:

[ora...@ts cgi-bin]$ ./mapserv -v
./mapserv: /usr/lib/libxml2.so.2: no version information available (required
by ./mapserv)
MapServer version 5.6.0 OUTPUT=GIF OUTPUT=PNG OUTPUT=WBMP OUTPUT=SVG
SUPPORTS=PROJ SUPPORTS=AGG SUPPORTS=FREETYPE SUPPORTS=ICONV
SUPPORTS=WMS_SERVER SUPPORTS=WMS_CLIENT SUPPORTS=WFS_SERVER
SUPPORTS=WCS_SERVER INPUT=EPPL7 INPUT=ORACLESPATIAL INPUT=OGR INPUT=GDAL
INPUT=SHAPEFILE

Output of gdal_translate:

[ora...@ts cgi-bin]$ gdal_translate |grep Geo
  GTiff: GeoTIFF
  GeoRaster: Oracle Spatial GeoRaster

I have ever tried to confirm that if gdal is OK by executing the command of 
gdal_translate -of gtiff

geor:wz/w...@orclat18,sf_rasters,georaster,georid=101 bluemarble.tiff -outsize
100% 100%
 in the command line. And found it's OK, the expected picture file was
returned.

I am so confused by the errors above now! So I wonder how to render raster
data with Oracle and GDAL on MapServer?

Thanks!



Hi,

I am as confused as you. There was a piece of code in Mapserver that wrongly assume that a raster 
data is always a file. I thought that I reported that problem and that was fixed. See my SVN DIFF 
for details:


{{{
$ svn diff
Index: mapwcs.c
===
--- mapwcs.c(revision 9444)
+++ mapwcs.c(working copy)
@@ -2047,7 +2047,7 @@
 /* TODO: need to set resolution */

 cm-bandcount = GDALGetRasterCount( hDS );
-
+
 if( cm-bandcount == 0 ) {
   msReleaseLock( TLOCK_GDAL );
   msSetError( MS_WCSERR, Raster file %s has no raster bands.  This cannot be used in a 
layer., msWCSGetCoverageMetadata(), layer-data );

Index: mapstring.c
===
--- mapstring.c (revision 9444)
+++ mapstring.c (working copy)
@@ -665,7 +665,7 @@
 if( fp == NULL )
 {
 strcpy( szReturnPath, path );
-return NULL;
+//return NULL;
 }
 else
 fclose( fp );
@@ -692,7 +692,7 @@
 if( fp == NULL )
 {
 strcpy( szReturnPath, path2 );
-return NULL;
+//  return NULL;
 }
 else
 fclose( fp );
}}}


Regards,

Ivan
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] How to render raster data using Oracle Georaster?

[Ivan]

Hi Xxj,

As I wrote before. There are code in Mapserver that wrongly assume that raster DATA is always file 
based. The code is in mapstring.g lines 668 and 695. If you comment out those two lines I believe 
you could make it work.


http://trac.osgeo.org/mapserver/browser/trunk/mapserver/mapstring.c#L668
http://trac.osgeo.org/mapserver/browser/trunk/mapserver/mapstring.c#L695

I would suggest you to file a bug report on that issue.

The thread that you mentioned was about another bug that I detected. Mapsever wasn't using GDAL 
raster overviews at all. Not only GeoRaster. And it makes a big difference when displaying GeoRaster 
to have Pyramids/Overviews properly supported as you can see also with Oracle's Mapviewer.


Best regards,

Ivan

xxj wrote:

Hi,

Please have a look at this thread. 


http://n2.nabble.com/MapServer-Oracle-performance-td3529225.html#a3531606

According to the replies by Ivan-5, it seems that he has ever succeeded in
rendering raster data using Oracle GeoRaster. How did he make it?

I also noticed that you get the same user name in this forum. May I assume
that you are exactly the guy? :)

Regards,

xxj


___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] python mapscript - FORMATOPTION

[Ivan Mincik]

Dear all,
I am trying to set FORMATOPTION QUANTIZE_FORCE=ON option using
python mapscript. I can successfully use this code snippet to write
OUTPUTFORMAT in to my mapfile:

of = mapscript.outputFormatObj(AGG/PNG,PNG_AGGAQ)
of.name = PNG_AGGAQ
of.driver = 'AGG/PNG'
of.imagemode = mapscript.MS_IMAGEMODE_RGBA
of.mimetype = image/png
of.transparent = 1

but
   of.setOption(FORMATOPTION, QUANTIZE_FORCE=ON)
is not creating any result to my mapfile. Is 'setOption' working in
python mapscript ?

Thanks,
Ivan
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] python mapscript - FORMATOPTION

[Ivan Mincik]

On Wed, Oct 14, 2009 at 12:58 AM, Guillaume Sueur
no-re...@neogeo-online.net wrote:
 Hi,

 Just an idea on the fly, because I didn't try it myself, but you could
 maybe try :
 of.setOption(QUANTIZE_FORCE, ON)
 and see what happens...

Thanks a lot Guillaume. It is working, but I am sure, I was also
trying something similar too. :)


 regards

 Guillaume

 Le mardi 13 octobre 2009 à 23:54 +0200, Ivan Mincik a écrit :
 Dear all,
 I am trying to set FORMATOPTION QUANTIZE_FORCE=ON option using
 python mapscript. I can successfully use this code snippet to write
 OUTPUTFORMAT in to my mapfile:

                 of = mapscript.outputFormatObj(AGG/PNG,PNG_AGGAQ)
                 of.name = PNG_AGGAQ
                 of.driver = 'AGG/PNG'
                 of.imagemode = mapscript.MS_IMAGEMODE_RGBA
                 of.mimetype = image/png
                 of.transparent = 1

 but
                of.setOption(FORMATOPTION, QUANTIZE_FORCE=ON)
 is not creating any result to my mapfile. Is 'setOption' working in
 python mapscript ?

 Thanks,
 Ivan
 ___
 mapserver-users mailing list
 mapserver-users@lists.osgeo.org
 http://lists.osgeo.org/mailman/listinfo/mapserver-users



___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] Openning mapserv.exe Would you like to save this file?

[Lucena, Ivan]

___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] Openning mapserv.exe Would you like to save this file?

[Lucena, Ivan]

Sorry for my fat finger mistake. When I run a GetCapabilities request it 
results in the download of mapserv.exe. I 
decided to investigate more before put the question on the list but I clicked 
some wrong short cut key on Chrome. 

  ---Original Message---
  From: Lucena, Ivan ivan.luc...@pmldnet.com
  Subject: [mapserver-users] Openning mapserv.exe Would you like to save this 
 file?
  Sent: Jul 17 '09 08:20
  
  
  ___
  mapserver-users mailing list
  mapserver-users@lists.osgeo.org
  http://lists.osgeo.org/mailman/listinfo/mapserver-users
  
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] 5.x Tutorial on mapserv -v (raster doesn't work)

[Lucena, Ivan]

Hi there,

I am using the MapServer distribution from OSGeo4w and the Totorial 5.x doesn't 
show the map in any raster or WMS examples.

C:\OSGeo4W  mapserv -v
MapServer version 5.2.2 OUTPUT=GIF OUTPUT=PNG OUTPUT=JPEG OUTPUT=WBMP OUTPUT=SWF
 OUTPUT=SVG SUPPORTS=PROJ SUPPORTS=AGG SUPPORTS=FREETYPE SUPPORTS=ICONV SUPPORTS
=FRIBIDI SUPPORTS=WMS_SERVER SUPPORTS=WMS_CLIENT SUPPORTS=WFS_SERVER SUPPORTS=WF
S_CLIENT SUPPORTS=WCS_SERVER SUPPORTS=SOS_SERVER SUPPORTS=FASTCGI SUPPORTS=THREA
DS SUPPORTS=GEOS SUPPORTS=RGBA_PNG INPUT=JPEG INPUT=POSTGIS INPUT=OGR INPUT=GDAL
 INPUT=SHAPEFILE

I download the tutorial.zip by Created by Pericles S. Nacionales Last 
updated: 20071020.

I added that line on C:\OSGeo4W\apache\conf\httpd.conf :

---
# parse MS4W apache conf files
include C:\ms4w/httpd.d/httpd_*.conf
---

The address http://locahost/tutorial; works just fine. Like my Linux machine. 

But examples with raster and WMS doesn't.

http://localhost/tutorial/example1-5.html
http://localhost/tutorial/example1-6.html
http://localhost/tutorial/example1-7.html
http://localhost/tutorial/example1-8.html

The rest of the sections and examples just return this error here:

---
msLoadSymbolSet(): Unknown identifier. First token must be SYMBOLSET, this 
doesn't look like a symbol file. 
---

In C:\OSGeo4W\apache\logs\error.log there is no error message related to that.


Does anyone know what could be wrong?

Thanks in advance,

Ivan










___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] GRIB files - gdal_translate

[Ivan]

Olá Roberto,

The file T126L28.ctl gives up the clue:

--
xdef 161 linear *-150.15* *0.937500*
ydef 98 levels
*-61.246* -60.311
-59.376 -58.441 -57.506 -56.571 -55.636 -54.701 -53.766 -52.831 -51.896 -50.961
-50.026 -49.091 -48.156 -47.221 -46.286 -45.350 -44.415 -43.480 -42.545 -41.610
-40.675 -39.740 -38.805 -37.870 -36.935 -36.000 -35.065 -34.130 -33.195 -32.260
-31.325 -30.389 -29.454 -28.519 -27.584 -26.649 -25.714 -24.779 -23.844 -22.909
-21.974 -21.039 -20.104 -19.169 -18.234 -17.299 -16.364 -15.429 -14.493 -13.558
-12.623 -11.688 -10.753  -9.818  -8.883  -7.948  -7.013  -6.078  -5.143  -4.208
  -3.273  -2.338  -1.403  -0.468   0.468   1.403   2.338   3.273   4.208   
5.143
   6.078   7.013   7.948   8.883   9.818  10.753  11.688  12.623  13.558  
14.493
  15.429  16.364  17.299  18.234  19.169  20.104  21.039  21.974  22.909  
23.844
  24.779  25.714  26.649  27.584  28.519 *29.454*
zdef 7 levels
--

Whatever ydef 98 levels means, it looks like there is one Y ordinate for each 
one of the 98 rows.

So your upper left and lower right values are in fact -150.0 -61.246 0.9375 
29.454.

I create a VRT file based on that:

$ gdal_translate -of VRT T126L28.grb T126L28.vrt -a_ullr -150.0 -61.246 0.9375 
29.454

And I opened it on QGIS and the image looks pretty good to me. See attachment.

Since you don't want to convert the data to other format you can create VRTs 
and use then instead.

 DATA c:/ms4w/data/raster/T126L28.vrt

Does it make sense?

PT_BR: Revisando: Eu interpretei o arquivo .ctl, achei a extensao da imagem e 
criei arquivos vrt
passando estes parametros. Agora quando eu abro o arquivo vrt os dados 
continuam sendo lidos do .grb
mas com a descricao do vrt. Tente fazer o mesmo pra ver se resolve pra voce. 
(eu estudei no INPE :)

Regards,

Ivan







inline: screenshot.png___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] GRIB files - gdal_translate

[Ivan]

Hi there!

There is nothing wrong with your block X and Y size (161x1). It indicates that your data is not 
tiled/blocked, so it is most likely to be read row by row. If the image looks strange is not because 
of that. You have 98 rows in 0.02 degrees, so if it looks like a line, I wouldn't be suprised. Have 
you try to open it in another GDAL based client application, like QGIS for example?


Regards,

Ivan

Roberto Garcia,MSc wrote:

Hi people,

I used gdal_translate in the GRIB file I want to show with mapserver, 
but there still is something wrong. The following is a partial output 
from it:


Driver: GRIB/GRIdded Binary (.grb)
Files: data\raster\T126L28.grb
Size is *161, 98*
Coordinate System is:
.
Origin = (-150.000,-61.2460002)
Pixel Size = (0.938,-0.001836734693878)
Corner Coordinates:
Upper Left  (-150.000, -61.246) (150d 0'0.00W, 61d14'45.60S)
Lower Left  (-150.000, -61.426) (150d 0'0.00W, 61d25'33.60S)
Upper Right (   1.018, -61.246) (  1d 1'4.80E, 61d14'45.60S)
Lower Right (   1.018, -61.426) (  1d 1'4.80E, 61d25'33.60S)
Center  ( -74.491, -61.336) ( 74d29'27.60W, 61d20'9.60S)
Band 1 Block=*161x1* Type=Float64, ColorInterp=Undefined
  Description = 0[-] MSL (Mean sea level)
  Metadata:
GRIB_UNIT=[Pa]
GRIB_COMMENT=Pressure reduced to MSL [Pa]
GRIB_ELEMENT=PRMSL
GRIB_SHORT_NAME=0-MSL
GRIB_REF_TIME=  1242453600 sec UTC
GRIB_VALID_TIME=  1242453600 sec UTC
GRIB_FORECAST_SECONDS=0 sec


As u can see the size according to the its header is 161x98, but all the 
bands are related as 161x1 block. Why does it happen? Another thing I 
noticed is that the dif between upper and lower latitude in the corner 
coordinates is very small (-61.246 to -61.426).


The issue is that, when mapserver renders this layer it only draws a 
straight line below South America, exactly where the whole image should 
start, as my CTL below shows.


dset ^T126L28.grb
title pac/sa/atlan sector: troposphere file
undef 1e+20
dtype grib
index ^T126L28.gmp
xdef 161 linear -150.15 0.937500
ydef 98 levels
-61.246 -60.311
-59.376 -58.441 -57.506 -56.571 -55.636 -54.701 -53.766 -52.831 -51.896 
-50.961
-50.026 -49.091 -48.156 -47.221 -46.286 -45.350 -44.415 -43.480 -42.545 
-41.610
-40.675 -39.740 -38.805 -37.870 -36.935 -36.000 -35.065 -34.130 -33.195 
-32.260
-31.325 -30.389 -29.454 -28.519 -27.584 -26.649 -25.714 -24.779 -23.844 
-22.909
-21.974 -21.039 -20.104 -19.169 -18.234 -17.299 -16.364 -15.429 -14.493 
-13.558
-12.623 -11.688 -10.753  -9.818  -8.883  -7.948  -7.013  -6.078  -5.143  
-4.208
 -3.273  -2.338  -1.403  -0.468   0.468   1.403   2.338   3.273   
4.208   5.143
  6.078   7.013   7.948   8.883   9.818  10.753  11.688  12.623  13.558  
14.493
 15.429  16.364  17.299  18.234  19.169  20.104  21.039  21.974  22.909  
23.844

 24.779  25.714  26.649  27.584  28.519  29.454
zdef 7 levels
1000 925 850 700 500 300 200   === set Z 1 ou 2 ou 3 ... ou 7 (GRADS)
tdef 1 linear 6Z16may2009  6hr
vars 15
psnm  02,102,  0,  0 SEA LEVEL PRESSURE [hPa]
tsfc  0  187,  1,  0,  0 SURFACE TEMPERATURE [K]
prec  0   61,  1,  0,  0 TOTAL PRECIPITATION [Kg/m2/day]
cbnv  0   71,  3,  0,  0 CLOUD COVER [0-1]
role  0  114,  8,  0,  0 OUTGOING LONG WAVE AT TOP [W/m2]
mask  7  137,100 MASK [-/+]
uvel  7   33,100 ZONAL WIND (U) [m/s]
vvel  7   34,100 MERIDIONAL WIND (V) [m/s]
omeg  7   39,100 OMEGA [Pa/s]
fcor  7   35,100 STREAM FUNCTION [m2/s]
potv  7   36,100 VELOCITY POTENTIAL [m2/s]
zgeo  77,100 GEOPOTENTIAL HEIGHT [gpm]
temp  7   11,100 ABSOLUTE TEMPERATURE [K]
umrl  7   52,100 RELATIVE HUMIDITY [no Dim]
umes  7   51,100 SPECIFIC HUMIDITY [kg/kg]
endvars

Can someone help me to find out what is happening?

Tks a lot

Roberto Garcia


Frank Warmerdam wrote:

Roberto Garcia,MSc wrote:

Hi, tks for the answers.

According to my gdainfo output file attached, can anyone tell me what 
element could be a CLASSITEM?


Roberto,

In MapServer you always classify rasters based on the item [pixel] but
you do not need to explicitly state a classitem.

This is a relatively simple example of raster classification.

LAYER
  NAME grid1
  TYPE raster
  STATUS default
  DATA data/float.tif
  CLASS
NAME red
EXPRESSION ([pixel]  -3)
COLOR 255 0 0
  END
  CLASS
NAME green
EXPRESSION ([pixel] = -3 and [pixel]  3)
COLOR 0 255 0
  END
  CLASS
NAME blue
EXPRESSION ([pixel] = 3)
COLOR 0 0 255
  END
END

I can see my grib using Grads but what tool do I use to translate 
individual bands into GeoTIFF?


You can use gdal_translate to extract particular bands from a grib file
as a geotiff (or all the bands).  For instance, the following would
extract band 3 (total precipitation):

gdal_translate -b 3 T126L28.grb total_precip.tif

Converting the data on-the-fly to an image is the right way to work? 


Having MapServer access the grib file on the fly rather than

Re: [mapserver-users] AGG FORMATOPTION PALETTE_FORCE=TRUE - transparent background

[Ivan Mincik]

On Thursday 05 March 2009, you wrote:
 for this to work, you'll *have* to compile mapserver with
 --with-experimental-png.
 (i.e. mapserv -v should ouput SUPPORTS=RGBA_PNG)
I confirm, that after recompiling with --with-experimental-png 8bit 
transparency is working.
Thank You Thomas. 
 
 once this is done, you should supply a palette file with rgba
 quadruplets. In your example, your palette entries are incorrect:
 0,0,0   is a triplet instead of a quadruplet (should be  0,0,0,0)
 
 On a side note,  your 230,230,230,0 isn't usefull, as it corresponds
 to 0,0,0,0 , thus eating up a entry in your generated palette (and
 palette entries in rgba mode are very expensive :) )
 
 --
 Thomas Bonfort
 CampToCamp
 
 On Thu, Mar 5, 2009 at 10:29, Ivan Mincik ivan.min...@gmail.com wrote:
  I am not sure if is it possible to reduce AGG PNG image to 8bit by 
  PALETTE_FORCE=TRUE option and keep transparent background.
  I went through all posts about this issue and it is not clear for me if I 
  still need to compile mapserver with --with-experimental-png switch or it 
  is currently not possible.
 
  I have tested all possible parameters and combinations of RGB or RGBA in  
  OUTPUTFORMAT and palette file with BLACK BACKGROUND as result.
 
  /usr/lib/cgi-bin/mapserv -v
  MapServer version 5.2.1 OUTPUT=GIF OUTPUT=PNG OUTPUT=JPEG OUTPUT=WBMP 
  OUTPUT=SVG SUPPORTS=PROJ SUPPORTS=AGG SUPPORTS=FREETYPE SUPPORTS=ICONV 
  SUPPORTS=WMS_SERVER SUPPORTS=WMS_CLIENT SUPPORTS=WFS_SERVER 
  SUPPORTS=WFS_CLIENT SUPPORTS=WCS_SERVER SUPPORTS=FASTCGI SUPPORTS=THREADS 
  SUPPORTS=GEOS INPUT=EPPL7 INPUT=POSTGIS INPUT=OGR INPUT=GDAL INPUT=SHAPEFILE
 
  I use mapserver as WMS server.
 
  Currently I have this in mapfile:
 
         NTERLACE OFF
         TRANSPARENT TRUE
         IMAGETYPE AGG8
          OUTPUTFORMAT
                 NAME AGG8
                 DRIVER AGG/PNG
                 MIMETYPE image/png
                 EXTENSION png
                 IMAGEMODE RGBA - #(IMAGEMODE RGB is working, nice result 
  without transparent background)
                 FORMATOPTION  INTERLACE=OFF
                 FORMATOPTION PALETTE_FORCE=TRUE
                 FORMATOPTION PALETTE=/s/agg_8bit_pal.txt
         END
 
  And palette file:
 
         0,0,0
         255,255,255,255
         230,230,230,0
         174,17,52,255
         174,17,52,255
         242,221,190,255
 
  Please, can anybody clarify this?
  Thanks
  Ivan
 
 
  ___
  mapserver-users mailing list
  mapserver-users@lists.osgeo.org
  http://lists.osgeo.org/mailman/listinfo/mapserver-users
 
 


___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] Mapserver WMS client without SERVICE parameter

[Ivan Mincik]

Dear users,
We want to use Manifold GIS to connect to UMN Mapserver WMS server. Manifold 
request doesn't contain SERVICE  parameter. (It should be a bug on the 
Manifold side.  It was already submitted. No response since now .)
If mapserver will receive  request without SERVICE parameter, it will process 
it as WFS request. We want WMS response. 
Is there any way how to configure mapserver to return WMS response even if 
SERVICE parameter is not present  ?

Thanks 
Ivan
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] Mapserver WMS client without SERVICE parameter

[Ivan Mincik]

Thanks a lot. I thought  it is a feature :). 
I will upgrade as suggested. 

Ivan

On Tuesday 20 January 2009, you wrote:
 On Tue, Jan 20, 2009 at 05:13:25PM +0100, Ivan Mincik wrote:
  Dear users,
  We want to use Manifold GIS to connect to UMN Mapserver WMS server. 
  Manifold request doesn't contain SERVICE  parameter. (It should be a bug 
  on the Manifold side.  It was already submitted. No response since now .)
 
 Actually, SERVICE=WMS is not required for GetMap requests. This is a bug
 in MapServer that requires it. This was fixed in
 http://trac.osgeo.org/mapserver/ticket/2737, fixed in 2737, and released
 in 5.2.1 , according to the ticket. 
 
 -- Chris
 
  If mapserver will receive  request without SERVICE parameter, it will 
  process it as WFS request. We want WMS response. 
  Is there any way how to configure mapserver to return WMS response even if 
  SERVICE parameter is not present  ?
  
  Thanks 
  Ivan
  ___
  mapserver-users mailing list
  mapserver-users@lists.osgeo.org
  http://lists.osgeo.org/mailman/listinfo/mapserver-users
 


___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] Mapserver legend is never transparent

[Ivan Mincik]

I have a problem that mapserver legend is never transparent even when using 
php-mapscript or querying WMS layer.
Tested at few of mapserver 5.x.x versions.

I have TRANSPARENT ON set in OUTPUTFORMAT.
OS: Debian Etch

Is this only my case ? Thanks.
Ivan
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] Re: GDAL and SDE raster

[Lucena, Ivan]

Ron,

Some raster driver in GDAL are not flie based but RDBMS based but most of the 
softwares based on GDAL did not 
noticed that change. In those case, instead of a file path what you need is a 
identification string but those software 
usually have code to grab the file path, to check if the file really exist, to 
check other files on the same folder and 
that is where it crashes.

What I suggest to Liz is to use a VRT file instead of the identification 
string. As you might know, a VRT file does not 
contain the data but a path to the real data set.

I use that trick to load images direct from the RDBMS server to OpenEv and 
QuantumGIS:

% gdal_translate -of VRT the identification string of your dataset 
temporary.vrt
... check if it works:
% gdalinfo temporary.vrt
... check what is inside it:
% more temporary.vrt
... load it:
% openev temporary.vrt
% qgis
... click on add layer
... select your temporary.vrt

I thought that it would work for mapserve too...

/filepath/temporary.vrt

But Liz tried and said it doesn't. Too bad, I was counting on it. ;(

Regards,

Ivan

  ---Original Message---
  From: Ron Goldman [EMAIL PROTECTED]
  Subject: [mapserver-users] Re: GDAL and SDE raster
  Sent: Nov 04 '08 14:01
  
  I had a similar problem with NetCDF raster. It probably won't help much for 
 SDE
  but make sure you have absolute filepath after the SDE: and not before it.
  
  
  Date: Tue, 4 Nov 2008 08:24:52 -0500
  From: Liz Godwin [EMAIL PROTECTED]
  Subject: Re: [mapserver-users] GDAL and SDE raster
  To: Lucena, Ivan [EMAIL PROTECTED]
  Cc: [EMAIL PROTECTED], mapserver-users@lists.osgeo.org,
  [EMAIL PROTECTED]
  Message-ID:
  [EMAIL PROTECTED]
  Content-Type: text/plain; charset=iso-8859-1
  
  
  Thank you, but that option doesn't appear to work for Raster data types.
  
  
  Liz
  
  
  On Mon, Nov 3, 2008 at 7:40 PM, Lucena, Ivan [EMAIL PROTECTED]wrote:
  
  
I don't have SDE to tell you the truth but I would suggest you to create 
 a
VRT version of your dataset and use the VRT on your map file. [
gdal_translate -of vrt
/filepath/SDE:server,port:5151,sde,user/pass,schema.table,RASTER
replacement.vrt ]
   
    
  ---Original Message---
  From: Liz Godwin [EMAIL PROTECTED]
  Subject: [mapserver-users] GDAL and SDE raster
  Sent: Nov 03 '08 22:19

  Hey folks,

  We've been beating ourselves up over this problem and I'm not sure
  what to try next.

  We can't seem to connect to SDE for a raster using GDAL in mapserver.
  This is happening on Linux.

  snippit from mapfile:
  TYPE RASTER
  DATA SDE:server,port:5151,sde,user,pass,schema.table,RASTER

  when trying to draw a map, i get a seg fault.  When trying a
  getFeatureinfo request, I get this error:

  /filepath/SDE:server,port:5151,sde,user: Image handling error. 
 Unable to
  open file LayerName for layer
  `/filepath/SDE:server,port:5151,sde,user/pass,schema.table,RASTER' 
 does
  not exist in the file system, and is not recognised as a supported
  
dataset
    
  name.
  ... fatal error.
  msRasterQueryByRect()

  Any ideas how I might start to debug this?  I have DEBUG set to 5 in
  
both
    
  the LAYER and MAP object in the map file.

  Thanks!

  Liz

  
  ___
  mapserver-users mailing list
  [LINK: [EMAIL PROTECTED]
[EMAIL PROTECTED]
  [LINK: http://lists.osgeo.org/mailman/listinfo/mapserver-users]
  http://lists.osgeo.org/mailman/listinfo/mapserver-users
  
   
    
  -- next part --
  An HTML attachment was scrubbed...
  URL: 
 http://lists.osgeo.org/pipermail/mapserver-users/attachments/20081104/fee291c7/attachment.html
  
  --
  
  ___
  
  mapserver-users mailing list
  mapserver-users@lists.osgeo.org
  http://lists.osgeo.org/mailman/listinfo/mapserver-users
  
  
  
  ***
  This outgoing email was scanned for viruses and other malicious content by 
 the IT Department of Israel 
Oceanographic  Limnological Research.
  AntiVirus system managed by Eli W. Tel. 972-4-8565267
  IMPORTANT: Do not open attachments from unrecognized senders.
  Never open attached files with extensions: *.pif, *.scr, *.vbs, *.exe.
  
***
___
  mapserver-users mailing list
  mapserver-users@lists.osgeo.org
  http://lists.osgeo.org/mailman/listinfo/mapserver-users
  

___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] GDAL and SDE raster

[Lucena, Ivan]

I don't have SDE to tell you the truth but I would suggest you to create a VRT 
version of your dataset and use the VRT on your map file. [ gdal_translate -of 
vrt /filepath/SDE:server,port:5151,sde,user/pass,schema.table,RASTER 
replacement.vrt ]

  ---Original Message---
  From: Liz Godwin [EMAIL PROTECTED]
  Subject: [mapserver-users] GDAL and SDE raster
  Sent: Nov 03 '08 22:19
  
  Hey folks,
  
  We've been beating ourselves up over this problem and I'm not sure
  what to try next.
  
  We can't seem to connect to SDE for a raster using GDAL in mapserver.
  This is happening on Linux.
  
  snippit from mapfile:
  TYPE RASTER
  DATA SDE:server,port:5151,sde,user,pass,schema.table,RASTER
  
  when trying to draw a map, i get a seg fault.  When trying a
  getFeatureinfo request, I get this error:
  
  /filepath/SDE:server,port:5151,sde,user: Image handling error. Unable to
  open file LayerName for layer
  `/filepath/SDE:server,port:5151,sde,user/pass,schema.table,RASTER' does
  not exist in the file system, and is not recognised as a supported dataset
  name.
  ... fatal error.
  msRasterQueryByRect()
  
  Any ideas how I might start to debug this?  I have DEBUG set to 5 in both
  the LAYER and MAP object in the map file.
  
  Thanks!
  
  Liz
  
  
  ___
  mapserver-users mailing list
  [LINK: [EMAIL PROTECTED]
  mapserver-users@lists.osgeo.org
  [LINK: http://lists.osgeo.org/mailman/listinfo/mapserver-users]
  http://lists.osgeo.org/mailman/listinfo/mapserver-users
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [MAPSERVER-USERS] mapserver MSVC2005 development package available to download (was mssql2008 binary test package available to download)

[Lucena, Ivan]

Paul,

I do it all the time with GDAL makefile projects.

What you need to do is to create a new project in VS selecting the project type 
as make file project that will lead you to a wizard IU where you are going to 
inform now do you want VS to call your makefile for Buil, Rebuild and Clean. 
The next step is to manually add each folder and source code that your want to 
see on the project explorer source code tree. Yes, it is a lot of work if you 
want to browse through the whole thing. See GDAL's makegdal_gen.bat for an 
automatic way of creating the source tree 
[http://trac.osgeo.org/gdal/browser/trunk/gdal/makegdal_gen.bat].

After that it is all the same as in a regular VS project. Breakpoints, 
step-into, step-out, watch windows, etc.

Good luck,

Ivan


  ---Original Message---
  From: BrainDrain [EMAIL PROTECTED]
  Subject: Re: [MAPSERVER-USERS] mapserver MSVC2005 development package
 available to download (was mssql2008 binary test package available to   
 download)
  Sent: Oct 24 '08 07:23
  
  
  That's great! Thanks.
  One question.
  As long as I'm windows developer, spoilt by visual studio:
  how to debug an app using IDE when building performed by makefile? When no
  VS project/solution file available? How you doing this? (tools/methods
  (debug console output? without 'watch window'?)).
  
  Best regards,
  
  Paul
  
  
  Tamas Szekeres wrote:
  
   Here is my daily snapshot including the fast cgi support:
  
   http://vbkto.dyndns.org:1280/tests/release-1400-20081023.zip
  
  
   I've created a development package to compile mapserver from the sources:
  
   http://vbkto.dyndns.org:1280/tests/release-1400-dev.zip
  
   You can use the following steps to compile mapserver.
  
   1. Extract the contents to a directory (for example
   C:\builds\release-1400-dev)
   2. Open Microsoft Visual Studio 2005 Command Prompt
   3.  cd C:\builds\release-1400-dev
   4.  nmake -f makefile.vc ms MS_DIR=mapserver
   BASE_DIR=C:\builds\release-1400-dev
   5.  nmake -f makefile.vc ms-sql2008 MS_DIR=mapserver
   BASE_DIR=C:\builds\release-1400-dev
   5.  nmake -f makefile.vc ms-csharp MS_DIR=mapserver
   BASE_DIR=C:\builds\release-1400-dev
  
  
   This package is based on the development version of gdal and
   mapserver, but you can download the stable version of gdal and
   mapserver sources in the base directory if you require a stable
   version build
   In this case you must specify these directories for MS_DIR and
   GDAL_DIR at the command like, like:
  
   nmake -f makefile.vc gdal GDAL_DIR=gdal-1-5
   BASE_DIR=C:\builds\release-1400-dev
   nmake -f makefile.vc ms MSL_DIR=mapserver-5-2
   BASE_DIR=C:\builds\release-1400-dev
  
  
   If you require a corresponding package for the MSVC2003 based builds
   let me know.
  
   Best regards,
  
   Tamas
  
  
  
   2008/10/20 BrainDrain [EMAIL PROTECTED]:
  
   Thank you very much, Tamas.
   getFeature works fine now.
  
   But can I ask you for one more favour. Could you compile with fastcgi
   support (ideally with all ms4w production release flags) or share 'your
   working buildkit' (this just will be great!, not only for me) because I
   still have problems with compiling ms4w(( but I need sql2008 support
   feature
   as soon as it possible for my work. I would be very appreciate.
  
   Tamas Szekeres wrote:
  
   Folks,
  
   Yes, I've run into the same issue when using the getFeature method
   with the driver. Here is the corresponding ticket I've created:
   http://trac.osgeo.org/mapserver/ticket/2795
  
   Attached the C# test case with this ticket:
   http://trac.osgeo.org/mapserver/attachment/ticket/2795/Program.cs
  
  
   I've fixed this issue in the SVN-trunk and the stable branch, here is
   my daily snapsot of the binaries you can test with:
   http://vbkto.dyndns.org:1280/tests/release-1400-20081018.zip
  
   If you encounter further problems with the driver don't hesitate to
   file a ticket describing the issue.
  
   Just for a note: This driver doesn't make any character encodings with
   the values retieved as plain byte arrays from MSSQL, however your
   default database setting corresponds to the
   1251 codepage, so explicit character conversion may be required in C#,
   like:
  
   byte[] bytes = Encoding.Convert(Encoding.Unicode, Encoding.Default,
   Encoding.Unicode.GetBytes(shape.getValue(k)));
   string str = Encoding.GetEncoding(1251).GetString(bytes);
  
  
   Best regards,
  
   Tamas
  
  
  
   2008/10/17 BrainDrain [EMAIL PROTECTED]:
  
   hmm
  could you provide an example to this
   how can I help If I use mapscript?
  [WebService(Namespace = http://www.wem.volgadmin.ru/wemlib;)]
  [WebServiceBinding(ConformsTo = WsiProfiles.None)]
  [ScriptService]
  public class MapParser : System.Web.Services.WebService
  {
  [WebMethod(EnableSession = true)]
  [ScriptMethod(UseHttpGet = true)]
  public object RequestFeatureAttributes(object mapIndex, object

[mapserver-users] mapmssql2008.c

[Ivan Mincik]

I would like to ask, what is the main reason why new mapmssql2008.c is not 
possible to compile and use on Linux ???
Is it any chance to modify the code to use this PLUGIN in Linux ?
Ivan
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] RE:mapserver + MS SQL

[Ivan Mincik]

 Hi,
 
 First thing that comes into my mind is the good old STATUS ON thing.  LAYER 
 ON in mapfile means that the layer can be requested, but not that it is 
 automatically included in a map.  STATUS DEFAULT includes it automatic.  Try 
 what happens if you use:
  
 shp2img -m test.map -l ku2 -o test.png
 
 Alternatively, change LAYER DEFAULT and use the old command.
 
Thanks for reply, 
still blank picture, with shp2img -m test.map -l ku2 -o test.png also blank. 
BTW: for other data sources layer configuration is 
working.


 -Jukka Rahkonen-
 
 
 -Alkuperäinen viesti-
 Lähettäjä: [EMAIL PROTECTED] puolesta: Ivan Mincik
 Lähetetty: ke 24.9.2008 19:09
 Vastaanottaja: mapserver-users@lists.osgeo.org
 Aihe: [mapserver-users] RE:mapserver + MS SQL
  
 I have started testing OGR ODBC connection from linux to MS SQL on win.
 There is polygon layer at MS SQL.
 
 *** I have configured ovf file:
 
 OGRVRTDataSource
 OGRVRTLayer name=ku2
 SrcDataSourceODBC:test/[EMAIL PROTECTED]/SrcDataSource 
 GeometryTypewkbPolygon/GeometryType 
 LayerSRS/LayerSRS
 GeometryField encoding=wkb field=geom/
 SrcSQLselect geom from ku2/SrcSQL
 /OGRVRTLayer
 /OGRVRTDataSource
 
 *** With ogrinfo -ro -al test.ovf I get:
 
 OGRFeature(ku2):1599
   geom (Binary) = 
 0104BA003EB1148070BF20C15D1DF97FB5C832C11B1727C08FBF20C16F23...
   POINT (0.0 -0.0)
 
 OGRFeature(ku2):1600
   geom (Binary) = 
 0104C801C23023A08D2C19C1BC001400308E32C1C84A35A0372C19C1CF70...
   POINT (0.0 -0.0)
 
 OGRFeature(ku2):1601
   geom (Binary) = 
 0104790538864D009A7818C19A41F1FF68B732C19092B3BF6C7818C10808...
   POINT (0.0 0.0)
 
 
 *** In the mapfile :
 
 LAYER 
 NAME 'ku2'
   DEBUG 5
   TYPE LINE
   CONNECTIONTYPE OGR
   CONNECTION test.ovf
   DATA ku2
   STATUS ON
   PROJECTION
   init=epsg:2065 
   END
   METADATA
   DESCRIPTION   test
   'wms_title' 'test'
   wms_format  image/png
   END
   CLASS
   NAME test
 STYLE
 OUTLINECOLOR  239 110 115
 COLOR 204 204 204
 WIDTH 8
 END
 END
 END
 
 *** shp2img -m test.map -o test.png will run without error, but output image 
 is BLANK.  Any idea ?
 I have tried this with 2 different layers, different coordinate systems.
 
 
 
 
 Hi list,
 At first, I would like to say that I am not a fan in replacing perfect 
 PostGIS database to MS SQL, but I must to adapt to customer's needs.
 I would like to ask if somebody has experience with loading data to 
 mapserver from MS SQL Spatial 2008.
 Now, in 5.2 there is possibility to use new PLUGIN for MS SQL, which is only 
 for Windows 
 Other possibility is to use ODBC connection through OGR which can be working 
 also in Linux.
 
 So my questions are :
 1. Is there any other possibility ?
 2. What is Your experience with performance when using ODBC connection 
 through OGR ? 
 3. What is Your experience with performance when using new PLUGIN for MS SQL 
 in 5.2 ?
 
 Thanks a lot 
 -- 
 
 Ivan 
 
 ___
 mapserver-users mailing list
 mapserver-users@lists.osgeo.org
 http://lists.osgeo.org/mailman/listinfo/mapserver-users
 
 

-- 
Mgr. Ivan Minčík
Gista s.r.o
tel:. 0907 639 570
email: [EMAIL PROTECTED]
http://www.gista.sk, http://demo.gisplan.sk


---

-- 
Mgr. Ivan Minčík
Gista s.r.o
tel:. 0907 639 570
email: [EMAIL PROTECTED]
http://www.gista.sk, http://demo.gisplan.sk
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] RE:mapserver + MS SQL

[Ivan Mincik]

On Wednesday 24 September 2008 18:56, you wrote:
 Hi,
 
  First thing that comes into my mind is the good old STATUS ON thing.  
  LAYER ON in mapfile means that the layer can be requested, but not that it 
  is automatically included in a map.  STATUS DEFAULT includes it automatic. 
   Try what happens if you use:
   
  shp2img -m test.map -l ku2 -o test.png
  
  Alternatively, change LAYER DEFAULT and use the old command.
  
  Thanks for reply, 
  still blank picture, with shp2img -m test.map -l ku2 -o test.png also 
  blank. BTW: for other data sources layer configuration  is 
  working.
 
 
 Pity, it would have been an easy fix but it was not the problem this time. 
 Another common reason for blank image is that map extents do not suit the 
 data extents.  To make things as simple as possible in the beginning, check 
 that your MAP is using the same projection as your LAYER, and that map 
 extents are the same than extents of the data as reported by ogr2org.  If 
 this does not help either I fear I need to give up because I have never used 
 the datasource you are using.
 
 -Jukka Rahkonen-

I was sure that MAPfile EXTENT is matching my data, but I have newer looked at 
ogrinfo's information about extent, because it is running from the screen very 
quickly. :)
That is the problem. But why it is corrupted ?

ogrinfo -ro -al test.ovf
INFO: Open of `test.ovf'
  using driver `VRT' successful.

Layer name: ku2
Geometry: Polygon
Feature Count: 3550
Extent: (0.00, 
-179441753791143469094582348050368606076769230976979143232596333732447718749484086013883159597108285162399003906607672013838798107945428976738835963963233366067456373325182194301163139111338691906684738825653288761055373466181297667973352185310923583498447210294222491698471297629594914501155102277295675539456.00)
 - (0.00, 
175734419613493915284908111527587685566285205239442963467256452943608984986725857350577088162863653468103413582900903009085827916464724144589133044259082766497414963423479118268465870571875835035017193992561074143650124470293091261615552841201430022775661034285205338433980355154804186847502850450881261862912.00)
Layer SRS WKT:
(unknown)




  

___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] mapserver + MS SQL

[Ivan Mincik]

Hi list,
At first, I would like to say that I am not a fan in replacing perfect PostGIS 
database to MS SQL, but I must to adapt to customer's needs.
I would like to ask if somebody has experience with loading data to mapserver 
from MS SQL Spatial 2008.
Now, in 5.2 there is possibility to use new PLUGIN for MS SQL, which is only 
for Windows 
Other possibility is to use ODBC connection through OGR which can be working 
also in Linux.

So my questions are :
1. Is there any other possibility ?
2. What is Your experience with performance when using ODBC connection through 
OGR ? 
3. What is Your experience with performance when using new PLUGIN for MS SQL in 
5.2 ?

Thanks a lot 
-- 

Ivan 

___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [MAPSERVER-USERS] instantclient-basic-win32-11.1.0.6.0 and MS4W 2.2.7

[Lucena, Ivan]

What is Oracle version you have? Is it 11.1.0.6.0? I guess that function 
was deprecated. Take a look at: http://www.gdal.org/ogr/drv_oci.html and
http://download.osgeo.org/gdal/win32/1.5/ that is what you find on the 
OCI zip README.TXT:


OGR 1.5 Oracle Plugin
=

Install
---

Unzip on top of the gdalwin32exe15x package.  It will put the
plugin in gdalwin32-1.5\bin\gdalplugins.

If you don't already have Oracle 10.2 OCI libraries available, you
will need to download the Oracle 10.2 Instant Client (you will need an
OTN login):

http://download-uk.oracle.com/otn/nt/instantclient/instantclient-basiclite-win32-10.2.0.3-20061115.zip

The Oracle DLLs can be placed in gdalwin32-1.5\bin or anywhere else in the
path.

If all this is successful ogrinfo --formats should list the OCI driver.

Good Luck.

Myopic wrote:

Has anyone had problems or tried to get Oracle Spatial to work with MS4W
2.2.7 with
instantclient-basic-win32-11.1.0.6.0?
When I replace the dlls as per the readme..  
http://www.maptools.org/ms4w/index.phtml?page=README_INSTALL.html
http://www.maptools.org/ms4w/index.phtml?page=README_INSTALL.html 
 I get the the following error when I do the ogrinfo --formats command:

The procedure entry point OCICollTRIM could not be located in the dynamic
link library oci.dll

Which oracle client should I be using?
Many thanks!
(I apologize for the double post..)

___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] OSS application to serve file based images

[Lucena, Ivan]

IMHO, I believe that you can replicate the functionalities of those two 
commercial software products by writing your own scripts in whatever OSS 
 solution you choose. Lots of work and know-how is required. While in 
Image Server for example, you just run some wizard-like UIs and get the 
job done much easier. But don't take my word for that, I'm one of the 
experts that believe that you *can* load and server images from a 
database server.

Best regards,
Ivan

Intengu Technologies wrote:

Hello

I understand that most experts are saying it is far better not to load
images in a database but rather to serve them from a file based system.
There are two commercial products that I know of ER Mapper - Image Web
Server and ArcGIS Image Server what OSS products provide comparable
functionalities.  If these are available are there any bench mark studies
done and also I would like to integrate such products with ArcGIS Server.





___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: Fwd: [MAPSERVER-USERS] Fwd: CLOSE_CONNECTION=DEFER - Segmentation fault

[Ivan Mincik]

Here is the report about testing second version of 
ms_postgis_begin_to_connect.diff (03/20/08 18:35:00) in p.mapper with 
PROCESSING CLOSE_CONNECTION=DEFER.

I have started browsing the map, using Obj_queryBy functions, turning on and 
off different layers. Application was working smoothly without any error or 
warning in the log.

THE PROBLEM will occur when I stop working in pmapper for a while and try to 
continue browsing. (in the log it is between 09:41:44 and - 09:46:05 and 
09:50:03 - 09:52:30) . After these pauses I had to restart browser to get 
p.mapper working again, but in 20 percent still application is still 
freezing. 
Same problems can be reproduced every new pmapper session.

Maybe I can try some session configurations in apache or postgres. Any 
advises? 

PostgreSQL log is here: 
http://projects.gpsmapy.sk/logs/ms_postgis_begin_to_connect_version2.log


Dave, thanks a lot for Your work
Ivan 

On Friday 21 March 2008 18:12, you wrote:
 Ivan,

Yes, I updated the patch on the bug report page
 http://trac.osgeo.org/mapserver/ticket/2497 around the time I sent
 those emails yesterday.  Download it, make sure it differs from the
 ms_postgis_fix_trans_state.diff you're currently using, `svn revert
 mappostgis.c`, and try it with the new patch.

Sorry that was not clear.

 Thanks,

 Dave

 On Fri, Mar 21, 2008 at 4:59 AM, Ivan Mincik [EMAIL PROTECTED] wrote:
  On Thursday 20 March 2008 23:46, you wrote:
Ivan,
   
   Try the new version of the patch, just posted.  I had accidentally
removed a necessary query in msPOSTGISLayerGetShape.  My tests which
now include getShape() are working (with or without PROCESSING
CLOSE_CONNECTION=DEFER).
 
   Hi Dave,
   I have allready tried patch ms_postgis_fix_trans_state.diff and I have
  posted the report. Or is there any updated version of
   ms_postgis_fix_trans_state.diff?
 
   I am sure that I have updated php_mapscript.so.
 
   
   For sure I include my report of testing ms_postgis_fix_trans_state.diff:
 
 
   I have applied new patch ms_postgis_fix_trans_state.diff to
  mapserver-5.0.2 sources from debian unstable and recompiled new debian
  package and install.
 
 
   Then I have:
   1. restarted apache
   2. restarted postgresql-8.1
   3. restarted browser (deleted cache)
 
   And started this test with p.mapper 3.2 application:
 
   1. Browsing the map (moving, zooming out, zooming in, adding some more
  layers) 2. Using identify ({map,layer}Obj_queryBy{Point,Rect,etc.}) -
  ERROR: cursor mycursor2 immediately
   3. Browsing the map (moving, zooming out, zooming in)
   4. Using identify ({map,layer}Obj_queryBy{Point,Rect,etc.}) - ERROR:
   cursor mycursor2 immediately
 
 
   Result:
   With this patch it is not possible to do neither a singel object query.
  (with older patch it was possible few times).
   After ERROR:  cursor mycursor2 does not exist it is possible to
  continue browsing the map again and object query fill finish with same
  result as above.
 
 
  {map,layer}Obj_queryBy{Point,Rect,etc.} function is not
   working   also when  #PROCESSING CLOSE_CONNECTION=DEFER is disabled.
   So identify object is not working at all.
 
   log is here:
   http://projects.gpsmapy.sk/logs/ms_postgis_fix_trans_state_patch.log
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: Fwd: [MAPSERVER-USERS] Fwd: CLOSE_CONNECTION=DEFER - Segmentation fault

[Ivan Mincik]

Hi Dave and others,

Here is the report about testing second version of
ms_postgis_begin_to_connect.diff (03/20/08 18:35:00) in p.mapper with
PROCESSING CLOSE_CONNECTION=DEFER.

I have started browsing the map, using Obj_queryBy functions, turning on and
off different layers. Application was working smoothly without any error or
warning in the log.

THE PROBLEM will occur when I stop working in pmapper for a while and try to
continue browsing. (in the log it is between 09:41:44 and - 09:46:05 and
09:50:03 - 09:52:30) . After these pauses I had to restart browser to get
p.mapper working again, but in 20 percent still application is still
freezing.
Same problems can be reproduced every new pmapper session.
I have solved this problem with php session settings so this last problem was 
probably on php/p.mapper site. Now the logs are clear. Tomorrow I will test 
it with more users then one.
Ivan


Maybe I can try some session configurations in apache or postgres. Any
advises?

PostgreSQL log is here:
http://projects.gpsmapy.sk/logs/ms_postgis_begin_to_connect_version2.log


Dave, thanks a lot for Your work
Ivan

On Friday 21 March 2008 18:12, you wrote:
 Ivan,

Yes, I updated the patch on the bug report page
 http://trac.osgeo.org/mapserver/ticket/2497 around the time I sent
 those emails yesterday.  Download it, make sure it differs from the
 ms_postgis_fix_trans_state.diff you're currently using, `svn revert
 mappostgis.c`, and try it with the new patch.

Sorry that was not clear.

 Thanks,

 Dave

 On Fri, Mar 21, 2008 at 4:59 AM, Ivan Mincik [EMAIL PROTECTED] wrote:
  On Thursday 20 March 2008 23:46, you wrote:
Ivan,
   
   Try the new version of the patch, just posted.  I had accidentally
removed a necessary query in msPOSTGISLayerGetShape.  My tests which
now include getShape() are working (with or without PROCESSING
CLOSE_CONNECTION=DEFER).
 
   Hi Dave,
   I have allready tried patch ms_postgis_fix_trans_state.diff and I have
  posted the report. Or is there any updated version of
   ms_postgis_fix_trans_state.diff?
 
   I am sure that I have updated php_mapscript.so.
 
   
   For sure I include my report of testing ms_postgis_fix_trans_state.diff:
 
 
   I have applied new patch ms_postgis_fix_trans_state.diff to
  mapserver-5.0.2 sources from debian unstable and recompiled new debian
  package and install.
 
 
   Then I have:
   1. restarted apache
   2. restarted postgresql-8.1
   3. restarted browser (deleted cache)
 
   And started this test with p.mapper 3.2 application:
 
   1. Browsing the map (moving, zooming out, zooming in, adding some more
  layers) 2. Using identify ({map,layer}Obj_queryBy{Point,Rect,etc.}) -
  ERROR: cursor mycursor2 immediately
   3. Browsing the map (moving, zooming out, zooming in)
   4. Using identify ({map,layer}Obj_queryBy{Point,Rect,etc.}) - ERROR:
   cursor mycursor2 immediately
 
 
   Result:
   With this patch it is not possible to do neither a singel object query.
  (with older patch it was possible few times).
   After ERROR:  cursor mycursor2 does not exist it is possible to
  continue browsing the map again and object query fill finish with same
  result as above.
 
 
  {map,layer}Obj_queryBy{Point,Rect,etc.} function is not
   working   also when  #PROCESSING CLOSE_CONNECTION=DEFER is disabled.
   So identify object is not working at all.
 
   log is here:
   http://projects.gpsmapy.sk/logs/ms_postgis_fix_trans_state_patch.log

---
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: Fwd: [MAPSERVER-USERS] Fwd: CLOSE_CONNECTION=DEFER - Segmentation fault

[Ivan Mincik]

On Thursday 20 March 2008 23:46, you wrote:
 Ivan,

Try the new version of the patch, just posted.  I had accidentally
 removed a necessary query in msPOSTGISLayerGetShape.  My tests which
 now include getShape() are working (with or without PROCESSING
 CLOSE_CONNECTION=DEFER).
Hi Dave,
I have allready tried patch ms_postgis_fix_trans_state.diff and I have posted 
the report. Or is there any updated version of 
ms_postgis_fix_trans_state.diff? 

I am sure that I have updated php_mapscript.so. 


For sure I include my report of testing ms_postgis_fix_trans_state.diff:

I have applied new patch ms_postgis_fix_trans_state.diff to mapserver-5.0.2 
sources from debian unstable and recompiled new debian package and install.

Then I have:
1. restarted apache
2. restarted postgresql-8.1
3. restarted browser (deleted cache)

And started this test with p.mapper 3.2 application:

1. Browsing the map (moving, zooming out, zooming in, adding some more layers)
2. Using identify ({map,layer}Obj_queryBy{Point,Rect,etc.}) - ERROR:  
cursor mycursor2 immediately
3. Browsing the map (moving, zooming out, zooming in)
4. Using identify ({map,layer}Obj_queryBy{Point,Rect,etc.}) - ERROR:  
cursor mycursor2 immediately


Result:
With this patch it is not possible to do neither a singel object query. (with 
older patch it was possible few times). 
After ERROR:  cursor mycursor2 does not exist it is possible to continue 
browsing the map again and object query fill finish with same result as 
above.
 
{map,layer}Obj_queryBy{Point,Rect,etc.} function is not 
working   also when  #PROCESSING CLOSE_CONNECTION=DEFER is disabled.
So identify object is not working at all.
  
log is here: 
http://projects.gpsmapy.sk/logs/ms_postgis_fix_trans_state_patch.log



___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: Fwd: [MAPSERVER-USERS] Fwd: CLOSE_CONNECTION=DEFER - Segmentation fault

[Ivan Mincik]

I have applied new patch ms_postgis_fix_trans_state.diff to mapserver-5.0.2 
sources from debian unstable and recompiled.

Then I have:
1. restarted apache
2. restarted postgresql-8.1
3. restarted browser (deleted cache)

And started this test with p.mapper 3.2 application:

1. Browsing the map (moving, zooming out, zooming in, adding some more layers)
2. Using identify ({map,layer}Obj_queryBy{Point,Rect,etc.}) - ERROR:  
cursor mycursor2 immediately
3. Browsing the map (moving, zooming out, zooming in)
4. Using identify ({map,layer}Obj_queryBy{Point,Rect,etc.}) - ERROR:  
cursor mycursor2 immediately


Result:
With this patch it is not possible to do neither a singel object query. (with 
older patch it was possible few times). 
After ERROR:  cursor mycursor2 does not exist it is possible to continue 
browsing the map again and object query fill finish with same result as 
above.
   
log is here: 
http://projects.gpsmapy.sk/logs/ms_postgis_fix_trans_state_patch.log


Thanks a lot for help 
Ivan


On Wednesday 19 March 2008 23:32, you wrote:
 On Wed, Mar 19, 2008 at 3:19 PM, No Spam [EMAIL PROTECTED] wrote:
  --- Dave Fuhry [EMAIL PROTECTED] wrote:
   I think the correct way to solve the problem would be to first, get
 rid of the ROLLBACK statements in msPOSTGISLayerGetShape.  Then, in
 msPOSTGISLayerClose, call msConPoolRelease() on the connection only
if PQtransactionStatus(layerinfo-conn) == PQTRANS_INTRANS (meaning,
the connection is valid and inside a transaction block).
   
   This would also solve the problem that lots of error blocks in the
 code call PQreset(layerinfo-conn).  That resets the connection but
 does not call begin a new transaction.  So when that connection was
 pulled back out of the pool, DECLARE CURSOR ... statements would
 fail.
 
   Do you have any gut feel for the stability of the current code, and when
  it is or is not a problem?  Does the problem only manifest itself if one
  calls the functions: {map,layer}Obj_queryBy{Point,Rect,etc.} ?
 
   I do need the patch from bug 2497 because it solves other problems that
  I was experiencing.  And I haven't experienced any problems as a result
  of the patch.  Nevertheless, I'm trying to decide if I've just been
  lucky, or if I'm safe as long as I don't call those functions (I don't).
 
   Thanks.
   - Rich

 Rich,

I don't have any insight into the problems you experienced with the
 mapserver process segfaulting.  I haven't seen any obvious reason why
 the older code would have caused that.

 Also Ivan: I've attached a patch which resolves invalid transaction
 state in a more comprehensive manner.  A new local function
 msPOSTGISInitConnection takes the reset / ROLLBACK / BEGIN steps
 necessary to fix an unusable connection.  Calls to PQreset() in the
 current code have been replaced with calls to this function, so that a
 failing query won't put a broken or non-transactional connection back
 into the connection pool.

It is only lightly tested, but if there are no bugs, it should fix
 all of the currently known problems.

 Thanks,

 Dave Fuhry
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [MAPSERVER-USERS] Fwd: CLOSE_CONNECTION=DEFER - Segmentation fault

[Ivan Mincik]

On Tuesday 18 March 2008 02:26, rich.fromm wrote:
 Dave Fuhry wrote:
  Oops, forgot to CC mapserver-users.
 
  -- Forwarded message --
  From: Dave Fuhry [EMAIL PROTECTED]
  Date: Wed, Mar 12, 2008 at 6:33 PM
  Subject: Re: [MAPSERVER-USERS] CLOSE_CONNECTION=DEFER - Segmentation
  fault To: Ivan Mincik [EMAIL PROTECTED]
 
  ...
 
   So essentially, the patch should be modified to remove the ROLLBACKs
   from msPOSTGISLayerGetShape() in a safe way.

 Just to make sure I'm properly interpreting the status of what's getting to
 be a bit of a long thread here...

 You're saying that this patch:
 http://trac.osgeo.org/mapserver/attachment/ticket/2497/ms_postgis_begin_to_
connect.diff from this bug:
 http://trac.osgeo.org/mapserver/ticket/2497
 is not entirely correct and should be modified?
I have applied this patch and it is not properly working when using 
{map,layer}Obj_queryBy{Point,Rect,etc.} functions. This was confirmed by Dave 
Fuhry.

 But this change has not happened yet, I gather?
I don't know about any other patch.


 I assume that if/when there's a new patch, notice will be posted either in
 this mailing list thread or that bug?
Yes. I am looking for the notice here in the mailinglist and to the bug 
thread.

 I ask b/c I build mapserver from source and am currently using that patch,
 and I want to make sure I recompile if that patch changes.
I want to recompile mapserver with the patch which is correctly working with 
{map,layer}Obj_queryBy{Point,Rect,etc.} functions.

So, I think the status of this problem is waiting for the new patch.
Ivan

 Thanks.

 - Rich
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [MAPSERVER-USERS] CLOSE_CONNECTION=DEFER - Segmentation fault

[Ivan Mincik]

Nothing is perfect. There are no problems with applied patch when browsing the 
map. But when I use identify object query from php5-mapscript the problem is 
rising again.

I have in postgresql log:

 2008-03-05 13:19:30 CET WARNING:  there is no transaction in progress
2008-03-05 13:19:30 CET ERROR:  cursor mycursor does not exist
2008-03-05 13:19:31 CET ERROR:  DECLARE CURSOR may only be used in transaction 
blocks
2008-03-05 13:19:31 CET WARNING:  there is no transaction in progress
2008-03-05 13:19:31 CET ERROR:  cursor mycursor does not exist
2008-03-05 13:19:32 CET ERROR:  DECLARE CURSOR may only be used in transaction 
blocks
2008-03-05 13:19:32 CET WARNING:  there is no transaction in progress
2008-03-05 13:19:32 CET ERROR:  cursor mycursor does not exist
2008-03-05 13:19:34 CET ERROR:  DECLARE CURSOR may only be used in transaction 
blocks
2008-03-05 13:19:34 CET WARNING:  there is no transaction in progress
2008-03-05 13:19:34 CET ERROR:  cursor mycursor does not exist
2008-03-05 13:20:10 CET LOG:  could not receive data from client: Connection 
reset by peer
2008-03-05 13:20:10 CET LOG:  unexpected EOF on client connection
2008-03-05 13:20:10 CET LOG:  could not receive data from client: Connection 
reset by peer
2008-03-05 13:20:10 CET LOG:  unexpected EOF on client connection
2008-03-05 13:20:10 CET LOG:  autovacuum: processing database gisplan
2008-03-05 13:20:10 CET LOG:  could not receive data from client: Connection 
reset by peer
2008-03-05 13:20:10 CET LOG:  unexpected EOF on client connection
2008-03-05 13:20:10 CET LOG:  could not receive data from client: Connection 
reset by peer
2008-03-05 13:20:10 CET LOG:  unexpected EOF on client connection
2008-03-05 13:20:10 CET LOG:  could not receive data from client: Connection 
reset by peer
2008-03-05 13:20:10 CET LOG:  unexpected EOF on client connection
2008-03-05 13:20:10 CET LOG:  could not receive data from client: Connection 
reset by peer
2008-03-05 13:20:10 CET LOG:  unexpected EOF on client connection
2008-03-05 13:20:10 CET LOG:  could not receive data from client: Connection 
reset by peer
2008-03-05 13:20:10 CET LOG:  unexpected EOF on client connection
2008-03-05 13:20:10 CET LOG:  could not receive data from client: Connection 
reset by peer
2008-03-05 13:20:10 CET LOG:  unexpected EOF on client connection
2008-03-05 13:20:10 CET LOG:  could not receive data from client: Connection 
reset by peer
2008-03-05 13:20:10 CET LOG:  unexpected EOF on client connection


2008-03-05 13:20:40 CET WARNING:  there is already a transaction in progress
2008-03-05 13:20:40 CET WARNING:  there is already a transaction in progress
2008-03-05 13:20:41 CET WARNING:  there is already a transaction in progress
2008-03-05 13:20:42 CET WARNING:  there is already a transaction in progress
2008-03-05 13:20:43 CET WARNING:  there is already a transaction in progress
2008-03-05 13:20:43 CET WARNING:  there is already a transaction in progress
2008-03-05 13:20:44 CET WARNING:  there is already a transaction in progress
2008-03-05 13:20:44 CET WARNING:  there is already a transaction in progress
2008-03-05 13:20:45 CET WARNING:  there is already a transaction in progress
2008-03-05 13:20:45 CET WARNING:  there is already a transaction in progress
2008-03-05 13:20:45 CET WARNING:  there is already a transaction in progress
2008-03-05 13:20:46 CET WARNING:  there is already a transaction in progress
2008-03-05 13:20:46 CET WARNING:  there is already a transaction in progress
2008-03-05 13:20:46 CET WARNING:  there is already a transaction in progress
2008-03-05 13:20:47 CET WARNING:  there is already a transaction in progress
2008-03-05 13:20:47 CET WARNING:  there is already a transaction in progress
2008-03-05 13:20:48 CET WARNING:  there is already a transaction in progress
2008-03-05 13:20:49 CET WARNING:  there is already a transaction in progress
2008-03-05 13:20:50 CET WARNING:  there is already a transaction in progress
2008-03-05 13:20:50 CET WARNING:  there is already a transaction in progress


ivan


On Monday 03 March 2008 21:53, rich.fromm wrote:
 hrach wrote:
  I use mapserver 4.10.3, postgresql 8.1, Debian Etch.
 
  Is anybody using CLOSE_CONNECTION=DEFER without any problems ?

 I am now using it fine with mapserver 5.0.0 after applying the patch for
 bug 2497:
 http://trac.osgeo.org/mapserver/ticket/2497

 I don't know if 4.10.3 is different enough for that patch to be applicable
 or not.  But if it's not too hard to upgrade, you might want to try a later
 version (e.g. 5.0.2) plus that patch.  Note that the patch may make it into
 the 5.0.3 release (it was originally targetted for 5.2).

 You also might want to take a look at the following related mailing list
 threads:

 http://www.nabble.com/Segmentation-fault---mapserver---postgis-to12653945.h
tml#a12674499
 http://www.nabble.com/postgres-transaction-warnings-to15749333.html

 - Rich
___
mapserver-users mailing list
mapserver-users

Re: [MAPSERVER-USERS] CLOSE_CONNECTION=DEFER - Segmentation fault

[Ivan Mincik]

Thanks, after applying the patch there are no errors in the log.
Ivan

On Monday 03 March 2008 22:52, rich.fromm wrote:
 hrach wrote:
  thanks a lot, I am just compiling Mapserver 5.0.3 and ready to try
  upgrade.

 you probably mean 5.0.2.  afaik, 5.0.3 hasn't been released yet.

 which means you will have to hand patch for bug 2497 if you want to include
 that fix.

 - rich
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [MAPSERVER-USERS] CLOSE_CONNECTION=DEFER - Segmentation fault

[Ivan Mincik]

thanks a lot, I am just compiling Mapserver 5.0.3 and ready to try upgrade.
Ivan


On Monday 03 March 2008 21:53, rich.fromm wrote:
 hrach wrote:
  I use mapserver 4.10.3, postgresql 8.1, Debian Etch.
 
  Is anybody using CLOSE_CONNECTION=DEFER without any problems ?

 I am now using it fine with mapserver 5.0.0 after applying the patch for
 bug 2497:
 http://trac.osgeo.org/mapserver/ticket/2497

 I don't know if 4.10.3 is different enough for that patch to be applicable
 or not.  But if it's not too hard to upgrade, you might want to try a later
 version (e.g. 5.0.2) plus that patch.  Note that the patch may make it into
 the 5.0.3 release (it was originally targetted for 5.2).

 You also might want to take a look at the following related mailing list
 threads:

 http://www.nabble.com/Segmentation-fault---mapserver---postgis-to12653945.h
tml#a12674499
 http://www.nabble.com/postgres-transaction-warnings-to15749333.html

 - Rich
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [MAPSERVER-USERS] CLOSE_CONNECTION=DEFER - Segmentation fault

[Ivan Mincik]

yes 5.0.2 
hm, after some short test there are no errors
thanks a lot 

On Monday 03 March 2008 22:52, rich.fromm wrote:
 hrach wrote:
  thanks a lot, I am just compiling Mapserver 5.0.3 and ready to try
  upgrade.

 you probably mean 5.0.2.  afaik, 5.0.3 hasn't been released yet.

 which means you will have to hand patch for bug 2497 if you want to include
 that fix.

 - rich
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] CLOSE_CONNECTION=DEFER - Segmentation fault

[Ivan Mincik]

Dear users,
I use mapserver 4.10.3, postgresql 8.1, Debian Etch.
When I use CLOSE_CONNECTION=DEFER in postgis layer a get from time to time 
Segmentation fault error. Application is frozen for some time. Tested on 
various postgis versions.

I found something here: http://trac.osgeo.org/mapserver/ticket/1507
but it did not help me.

In my testing mapfile I use 3 postgis layers and  CLOSE_CONNECTION=DEFER has 
significant effect. Time for rendering map is reduced in average from 0.846s 
to 0.583s.

Is anybody using CLOSE_CONNECTION=DEFER without any problems ? 

Thanks 
Ivan
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users