Re: [MapServer-users] Is there a way to make OPACITY depends of SCALE?

[michael . smith . erdc]

Carlos,

Yes, you can use SCALETOKEN. 

https://mapserver.org/mapfile/layer.html

Michael Smith
US Army Corps


> On Mar 30, 2023, at 5:53 AM, Carlos Neves (LREC)  wrote:
> 
> 
> Hi List,
> 
> Is there a way to change OPACITY by scale? The goal is to show  
> Orthophotomaps under risk areas.
> 
> LAYER # Rock Fall Risk Model  
> NAME "rockfall"
> COMPOSITE
> OPACITY 50
> END
> DATA "geotiffs/risk_m.tiff" # GeoTiff RockFall Risk File
> STATUS   default
> TYPE RASTER
> 
> METADATA
>"wms_title" "rockfall"
> END
> TEMPLATE "rockfall_query.html" # Rockfall Query file
> CLASS
> NAME "RockFall Risk"
> EXPRESSION ([pixel] > 0 )
> #MAXSCALEDENOM 1
> #MINSCALEDENOM 2000
> STYLE
> DATARANGE 1 3
> COLORRANGE 255 255 0 255 0 0
> END #STYLE
> END #Class
> 
> 
> END # Rock Fall layer ends here 
> 
> 
> risk map example:
> 
> 
> 
> Best Regards,
> 
> Carlos
> 
> ___
> 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] Failed to download capabilities:Download of capabilities failed: Connection on mapfile with more than 1000 layers

[Michael Smith]

One could do this already without changing mapserver, just at the web server 
config. It would be hard to control in mapserver when you’d want to do this. 

 

Mike

 

 

-- 

Michael Smith

US Army Corps of Engineers

Remote Sensing/GIS Center

 

 

From: MapServer-users  on behalf of 
"Kralidis,Tom (ECCC)" 
Date: Tuesday, December 20, 2022 at 2:33 PM
To: Oskar Ravhed , Rahkonen Jukka 
, Marcin Niemyjski 
, "mapserver-users@lists.osgeo.org" 

Subject: Re: [MapServer-users] Failed to download capabilities:Download of 
capabilities failed: Connection on mapfile with more than 1000 layers

 

Option: we could consider adding a mapfile directive to point to a 
GetCapabilities file (oh disk), which can act as an early out (instead of 
generating Capabilities XML on the fly).  We would want to test how effective 
this would be for larger mapfiles (i.e. reading mapfile vs. rendering 
Capabilities XML).

 

Feel free to open an issue if this could be helpful/is of interest.

 

Thanks

 

..Tom

 

 

 

From: MapServer-users  On Behalf Of 
Oskar Ravhed
Sent: Tuesday, December 20, 2022 10:01
To: Rahkonen Jukka ; Marcin Niemyjski 
; mapserver-users@lists.osgeo.org
Subject: Re: [MapServer-users] Failed to download capabilities:Download of 
capabilities failed: Connection on mapfile with more than 1000 layers

 

You don't often get email from oskar.rav...@t-kartor.com. Learn why this is 
important
Hi it took 40 s  

 

Merry Christmas

On 20/12/2022 15:38, Rahkonen Jukka wrote:

Hi,

 

The time is not a constant (number of layers * x milliseconds). For example, it 
is faster to generate the layer BoundingBox into GetCapabilities if the 
wms_extent metadata is set for the layer 
https://www.mapserver.org/ogc/wms_server.html but how much faster it is depends 
on the data source.

 

I think that instead of 1200 layers you could have just one time enabled layer 
https://www.mapserver.org/ogc/wms_time.html.

 

-Jukka Rahkonen-

 

Lähettäjä: MapServer-users  Puolesta 
Marcin Niemyjski via MapServer-users
Lähetetty: tiistai 20. joulukuuta 2022 16.18
Vastaanottaja: Oskar Ravhed ; 
mapserver-users@lists.osgeo.org
Aihe: Re: [MapServer-users] Failed to download capabilities:Download of 
capabilities failed: Connection on mapfile with more than 1000 layers

 

 

Great advice, thank you Oskar. 

 

Could you tell me how long it takes to load the WMS into qgis or GetCap with 
that many layers?

I am also interested in what purpose you are using the WMS with this amount of 
data. Could you share it? In my case it is daily Sentinel-1 imagery for the 
whole world from the beginning of 2021.

 

Merry Christmas to all,

Marcin 

 

From: MapServer-users  on behalf of 
Oskar Ravhed 
Sent: Tuesday, December 20, 2022 1:08 PM
To: mapserver-users@lists.osgeo.org 
Subject: Re: [MapServer-users] Failed to download capabilities:Download of 
capabilities failed: Connection on mapfile with more than 1000 layers 

 

Hello!

I have 3234 layers in a service and it works fine. also works fine with 
10.000 layers

1 try the getcap in browser
2a if step 1 is success change network timeout in qgis
2b if step 1 does not work change timeouts on server and check mapserver 
log

On 20/12/2022 09:59, Jörg Thomsen (WhereGroup) wrote:
> Hi,
>
> funny, how you type twelve.
>
> 1200 are very much and I guess no one has tried this before.
> So to your question: I would say yes.
>
> I suggest to split it into several services / mapfiles. The 
> capability-xml ist very big I think and most clients will habe 
> problems with it. The usability is bad, the users have to scroll 
> through 1200 Layers, puh. And I don't know whether a getMap with 
> http-get will work (is there a current length-limit in http-get?).
>
>
> Jörg
>
>
>  Am 20.12.22 um 09:42 schrieb Marcin Niemyjski via MapServer-users:
>> Hello,
>>
>> I have a mapfile which constist of 1200 layers. While loading to qgis 
>> error "Failed to download capabilities:Download of capabilities 
>> failed: Connection" is recived.
>>
>> Does this happen becaues of quantitu of layers in mapfile? Is there 
>> any workaround?
>>
>> Best,
>> Marcin
>>
>> ___
>> 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 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] Configuring mapserv with Oracle on Ubuntu 22.04

[Michael Smith]

Silvia,

 

You generally also need to set the ORACLE_HOME env value to your client 
location, eg export ORACLE_HOME=$PREFIX/instantclient. Also make sure you have 
libaio installed as that is needed as well.

 

Mike

 

 

-- 

Michael Smith

US Army Corps of Engineers

Remote Sensing/GIS Center

 

 

From: MapServer-users  on behalf of 
"Silvia Gatti - OSMGP.- via MapServer-users" 
Reply-To: "Silvia Gatti - OSMGP.-" 
Date: Thursday, July 21, 2022 at 1:48 PM
To: Mapserver Mailing List 
Subject: [mapserver-users] Configuring mapserv with Oracle on Ubuntu 22.04

 

I am new for mapserv over Ubuntu 22.04.
I had Oracle Client installed ok, because sqlplus is running

I'm following instructions in 
https://mapserver.org/installation/unix.html?highlight=compiling+over+ubuntu#compiling-on-unix

After fighting several weeks I'm at this point. And I've never got mapserv to 
compile for Oracle.
I had also read 
https://gis.stackexchange.com/questions/328817/mapserver-with-oracle-spatial-on-linux

I 'll apreciate any help
cmake -DCMAKE_INSTALL_PREFIX=/opt/mapserver \
    
-DCMAKE_PREFIX_PATH=/usr/local/pgsql/91:/usr/local:/opt:/usr/share:/usr/lib:/usr/lib/oracle/12.2/client64:/usr/include/oracle/12.2/client64:/usr/lib:/usr/lib64:/usr/share/gdal
 \
    -DWITH_CLIENT_WFS=ON \
    -DWITH_CLIENT_WMS=ON \
    -DWITH_CURL=ON \
    -DWITH_SOS=ON \
    -DWITH_PHP=ON \
    -DWITH_PERL=ON \
    -DWITH_RUBY=ON \
    -DWITH_JAVA=ON \
    -DWITH_CSHARP=ON \
    -DWITH_PYTHON=ON \
    -DWITH_SVGCAIRO=OFF\
    -DWITH_ORACLESPATIAL=ON \
    -DWITH_MSSQL2008=ON \
  -DWITH_PROTOBUFC=OFF \
  -DWITH_HARFBUZZ=OFF \
  -DWITH_FRIBIDI=OFF \
    ../ >../configure.out.txt


-- 
Silvia Gatti
Gestion del Cambio - Gcia. de Sistemas
Obras Sanitarias S.E. Mar del Plata - Batán
Tel. 4992900 Int 521

"Trabajando por un futuro con agua potable para todos"


___ 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] Can MapServer consume ArcGIS Services

[michael . smith . erdc]

Through OGR, yes. 

Michael Smith
US Army Corps

> On Dec 10, 2021, at 4:46 PM, Mark Volz  wrote:
> 
> 
> Hello,
>  
> Can ArcMap consume feature services from ArcGIS Online?
>  
> Thanks!
>  
> Sincerely,
> Mark Volz, GISP
>  
> ___
> 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] Is mode=tile always epsg:3857?

[Michael Smith]

Rich,

 

Looking at mode=tile, yes, it sets it to spherical Mercator

 

https://github.com/MapServer/MapServer/blob/master/maptile.c#L259

 

 

 

From: mapserver-users  on behalf of 
Richard Greenwood 
Date: Saturday, October 24, 2020 at 1:22 PM
To: mapserver 
Subject: [mapserver-users] Is mode=tile always epsg:3857?

 

I'm trying to generate vector tiles in a non epsg:3857 (web mercator) 
projection but it looks to me like mapserver is treating it as 3857 despite 
passing a srs. 

 

My request generated by OpenLayers at the full map extent is:

  
/cgi-bin/mapserv?map=mvt.map=EPSG:3738=tile=0+0+0=ownership=mvt

 

My extents are: 1622000 639000 2308000 1284700

 

My mapserver log looks like:

[Sat Oct 24 11:10:58 2020].947687 msTileSetParams(): tile_metatile_level = 0
[Sat Oct 24 11:10:58 2020].947690 msTileSetExtent(): gmaps coords (x: 0, y: 0, 
z: 0)
[Sat Oct 24 11:10:58 2020].947692 msTileSetExtent(): gmaps metacoords (x: 0, y: 
0, z: 0)
[Sat Oct 24 11:10:58 2020].947695 msTileSetExtent(): base image size (256 x 256)
[Sat Oct 24 11:10:58 2020].947697 msTileSetExtent(): buffered image size (256 x 
256)
[Sat Oct 24 11:10:58 2020].947700 msTileSetExtent (-19959236.823047, 
-19959236.823047) (19959236.823047, 19959236.823047)
 

There's obviously something that I'm not getting...

 

-- 

Richard W. Greenwood, PLS
www.greenwoodmap.com

___ 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] Compiling Mapserver with Oracle Spatial support issue

[Michael Smith]

The sdk part is needed with the instant client. 

Make sure you also have libaoi (ubuntu libaoi1) installed.

Make sure ORACLE_HOME (path to the instant client library) is in the 
LD_LIBRARY_PATH. 

 

Mike

 

 

-- 

Michael Smith

US Army Corps of Engineers

Remote Sensing/GIS Center

 

 

From: mapserver-users  on behalf of 
Steve Lime 
Date: Tuesday, August 25, 2020 at 10:39 AM
To: Marcin Grudzień 
Cc: Mapserver 
Subject: Re: [mapserver-users] Compiling Mapserver with Oracle Spatial support 
issue

 

Hmmm... Does -DWITH_ORACLESPATIAL=ON (so ON vs 1) make a difference? It 
shouldn't... If you do a "ldd mapserv" is the binary linked against the Oracle 
libs?

 

On Wed, Aug 19, 2020 at 12:55 AM Marcin Grudzień  wrote:

Hi,

 

I am new to Mapserver. I am trying to compile MapServer 7.6.1 with Oracle 
Spatial support on Ubuntu 20.04. 

 

I basically follow the instruction on 
https://www.mapserver.org/installation/unix.html#. 

 

To configure my environment I use 

cmake .. -DINSTALL_LIB_DIR:PATH=/usr/lib 
-DCMAKE_PREFIX_PATH="/usr/local;/opt;/usr/lib;/usr/lib/x86_64-linux-gnu;/usr/local/lib;/usr/lib/oracle/11.2/client64/bin;/usr/lib/oracle/11.2/client64/lib"
 -DWITH_CLIENT_WFS=1 -DWITH_CLIENT_WMS=1 -DWITH_CURL=1 -DWITH_SOS=1 
-DWITH_PHP=1 -DWITH_PERL=1 -DWITH_RUBY=0 -DWITH_JAVA=1 -DWITH_CSHARP=0 
-DWITH_PYTHON=1 -DWITH_SVGCAIRO=0 -DWITH_ORACLESPATIAL=1 -DWITH_MSSQL2008=0 
-DWITH_CURL=1 -DWITH_LIBXML2=1 ../ >../configure.out.txt

 

The cmake output shows:

* Summary of configured options for this build
--  * Mandatory components
--   * GDAL: /usr/local/lib/libgdal.so
--   * PROJ: /usr/lib/x86_64-linux-gnu/libproj.so
--   * png: /usr/lib/x86_64-linux-gnu/libpng.so
--   * jpeg: /usr/lib/x86_64-linux-gnu/libjpeg.so
--   * freetype: /usr/lib/x86_64-linux-gnu/libfreetype.so
--  * Optional components
--   * GIF: /usr/lib/x86_64-linux-gnu/libgif.so
--   * MYSQL: disabled
--   * FRIBIDI: /usr/lib/x86_64-linux-gnu/libfribidi.so
--   * HARFBUZZ: /usr/lib/x86_64-linux-gnu/libharfbuzz.so
--   * GIF: /usr/lib/x86_64-linux-gnu/libgif.so
--   * CAIRO: /usr/lib/x86_64-linux-gnu/libcairo.so
--   * SVGCAIRO: disabled
--   * RSVG: disabled
--   * CURL: /usr/lib/x86_64-linux-gnu/libcurl.so
--   * PIXMAN: disabled
--   * LIBXML2: /usr/lib/x86_64-linux-gnu/libxml2.so
--   * POSTGIS: /usr/lib/x86_64-linux-gnu/libpq.so
--   * GEOS: /usr/lib/x86_64-linux-gnu/libgeos_c.so
--   * FastCGI: /usr/lib/x86_64-linux-gnu/libfcgi.so
--   * PROTOBUFC: /usr/local/lib/libprotobuf-c.so
--   * Oracle Spatial: 
/usr/lib/oracle/11.2/client64/lib/libclntsh.so;/usr/lib/oracle/11.2/client64/lib/libocci.so;/usr/lib/oracle/11.2/client64/lib/libnnz11.so
--   * Exempi XMP: disabled
--  * Optional features
--   * WMS SERVER: ENABLED
--   * WFS SERVER: ENABLED
--   * WCS SERVER: ENABLED
--   * SOS SERVER: ENABLED
--   * WMS CLIENT: ENABLED
--   * WFS CLIENT: ENABLED
--   * ICONV: ENABLED
--   * Thread-safety support: disabled
--   * KML output: disabled
--   * Z+M point coordinate support: ENABLED
--   * XML Mapfile support: disabled
--  * Mapscripts
--   * Python: ENABLED
--   * PHP: ENABLED
--   * PHPNG: disabled
--   * PERL: ENABLED
--   * RUBY: disabled
--   * JAVA: ENABLED
--   * C#: disabled
--   * V8 Javascript: disabled
--   * Apache Module (Experimental): disabled
--
-- PROJECT_BINARY_DIR is set to /home/mgrudzien/mapserver-7.6.1/build
-- Will install files to /usr/local
-- Will install libraries to /usr/lib
-- Configuring done
-- Generating done
-- Build files have been written to: /home/mgrudzien/mapserver-7.6.1/build

 

Then I compile and install MapServer. However, when I execute mapserv -v I get

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

 

The Oracle Spatial is not supported. What am I doing wrong?  How this can be 
solved?

 

Best regards,

Marcin

___
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 mailing list
mapserver-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] Query

[Michael Smith]

I have it as a task to push updates to it this weekend. I’ll bring it up to 
date writhe the current MapServer release. 

Michael Smith

> On Nov 15, 2019, at 5:49 PM, Steve Lime  wrote:
> 
> 
> That was setup by one of the MapServer PSC members and can be considered 
> official - it's a little out of date however (MapServer 7.2 I believe).
> 
>> On Fri, Nov 15, 2019 at 8:54 AM Bobby Biran  wrote:
>> Hi MapServer
>>  
>> We can across https://hub.docker.com/u/mapserver in DockerHub and wanted to 
>> confirm if this is an official account from yourselves ?
>>  
>> Regards
>> Bobby
>>  
>>  
>> Unless stated otherwise above:
>> IBM United Kingdom Limited - Registered in England and Wales with number 
>> 741598.
>> Registered office: PO Box 41, North Harbour, Portsmouth, Hampshire PO6 3AU
>> 
>> ___
>> 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 mailing list
mapserver-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] Gallery: running mapserver in docker on kubernetes

[Michael Smith]

You can also use something like goofys which is a fuse provider for s3 which 
provides s3 access while using normal file path access. It’s useful when you 
have to deploy to cloud and non cloud. 

Michael Smith
RSGIS Center 

> On Aug 30, 2019, at 7:31 PM, Jan Hartmann  wrote:
> 
> Impressive, looks like viscurl is a real alternative to local files. Thanks 
> for the information, I'm certainly going to look further on this.
> 
> Jan
> 
>> On 8/30/2019 6:15 PM, Peter Schmitt wrote:
>>> On Fri, Aug 30, 2019 at 9:48 AM Jan Hartmann  wrote:
>>> Thanks Peter, this is really useful. Do you have any real-world benchmarks 
>>> for MapServer that compare regular file access with vsicurl access, using 
>>> optimized Geotifs? I've seen the tests for GDAL at 
>>> https://trac.osgeo.org/gdal/wiki/CloudOptimizedGeoTIFF, but what about 
>>> servering  large map-sets over the web?
>>> 
>> I don't have any sort of formal benchmarks... but I can provide anecdotes 
>> from my experiences. Random access to a 256x256 block of extremely large 
>> COGs served from fast SSD would have maybe 100ms response.  The same COG 
>> accessed with /vsicurl/:  First time the tile is requested about 400ms.  
>> GDAL has a least recently used curl cache.  When a tile is cached, 
>> subsequent requests can be served maybe about 100ms. My cloud provider is 
>> AWS... so access from s3 using MapServer running in a Docker container on an 
>> AWS EC2 instance in the us-east-1 region... and the tile is requested from 
>> my local wireless network in Colorado.
>> 
>> When the data is a COG in s3 and MapServer runs near the cloud storage, 
>> performance is quite good. I've scaled only to dozens of users.  
>> Allegedly s3 can scale to 5,500 requests per second per prefix in s3.  
>> https://docs.aws.amazon.com/AmazonS3/latest/dev/optimizing-performance.html 
>> Presumably it would scale fairly well by adding more MapServer processes.
>>  
> 
> ___
> 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] Antw: Re: MapServer with oracle-spatial on a linuxsystem

[Michael Smith]

Thanks Jeff!

M

On 7/16/19, 1:17 PM, "mapserver-users on behalf of Jeff McKenna" 
 wrote:

I also took the time to update the OracleSpatial docs 
(https://mapserver.org/input/vector/oracle.html).   If you have any 
enhancements please be sure to file your new issue or pull request to 
the "docs" instance at https://github.com/mapserver/docs

thanks!

-jeff




On 2019-07-16 7:24 AM, Kai Behncke wrote:
> Allright, finally I got it.
> 
> 
> I declared:
> export ORACLE_HOME=/usr/lib/oracle/12.2/client64
> export LD_LIBRARY_PATH=${ORACLE_HOME}:/usr/lib
> 
> and in my case I got a problem with the ORACLE_INCLUDE_DIR.
> 
> I changed in the cmake-directory cmake/FindOracle.cmake:
> 
>   if(DEFINED ENV{ORACLE_HOME})
>   27
>   28   set(ORACLE_HOME $ENV{ORACLE_HOME})
>   29   message("ORACLE_HOME=${ORACLE_HOME}")
>   30
>   31   find_path(ORACLE_INCLUDE_DIR
>   32 NAMES oci.h
>   33 PATHS
>   34
>   35 /usr/include/oracle/12.2/client64)
> 
> 
> And I configured mapserver by:
> 
> cmake .. -DCMAKE_BUILD_TYPE='debug' 
> -DCMAKE_INSTALL_PREFIX=/opt/mapserver 
> 
-DCMAKE_PREFIX_PATH=/usr/lib/oracle/12.2/client64:/usr/include/oracle/12.2/client64:
> /usr/lib:/usr/lib64:/usr/share/gdal -DWITH_ORACLESPATIAL=1 
> -DWITH_PROTOBUFC=0 -DWITH_FCGI=0 -DWITH_CURL=1
> 
> and then I got it:
> 
> 
> --   * LIBXML2: /usr/lib64/libxml2.so
> --   * POSTGIS: /usr/lib64/libpq.so
> --   * GEOS: /usr/lib64/libgeos_c.so
> --   * FastCGI: disabled
> --   * PROTOBUFC: disabled
> --   * Oracle Spatial: 
> 
/usr/lib/oracle/12.2/client64/lib/libclntsh.so;/usr/lib/oracle/12.2/client64/lib/libocci.so;/usr/lib/oracle/12.2/client64/lib/libnnz12.so
> --   * Exempi XMP: disabled
> --  * Optional features
> --   * WMS SERVER: ENABLED
> --   * WFS SERVER: ENABLED
> --   * WCS SERVER: ENABLED
> 
> 
> Thank you very much, Kai
> 
> Mit freundlichen Grüßen
> Im Auftrag
> 
> Kai Behncke
> Geoinformation
> Tel.: +49 5451 931-7125
> 
> E-Mail: kai.behn...@ibbenbueren.de 
> 
> Rathaus II
> Roncallistraße 3-5
> 1. Stock, Raum 105
> 49477 Ibbenbüren
> 
> 
 Jeff McKenna  15.07.2019 18:42 >>>
> Oh and I always use the "Basic" package, but I guess "lite" will work as
> Mike said.   -jeff
> 
> 
> 
> On 2019-07-15 1:40 PM, Jeff McKenna wrote:
>  > Further to what Mike said, I usually grab the instant client from this
>  > page (it is often hard to find):
>  > 
> https://www.oracle.com/database/technologies/instant-client/downloads.html
> 
>  >
>  > -jeff
>  >
>  >
>  >
> 
___
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] Antw: Re: MapServer with oracle-spatial on a linuxsystem

[michael . smith . erdc]

Kai,
Check the cmake build log too. You also need the libaio library. 

I also set the following ENV variables
ORACLE_HOME - set to the path to the instantclient location
LD_LIBRARY_PATH - set to the path to the instantclient location

Michael Smith

> On Jul 16, 2019, at 2:59 AM, Kai Behncke  wrote:
> 
> Hi Michael, Hi Jeff,
> 
> First of all thank you very much for your responses.
> 
> Meanwhile I have installed from that page:
> https://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.html
> 
> a) in version 11.2: Instant Client Package - Basic: All files required to run 
> OCI, OCCI, and JDBC-OCI applications
> b) Instant Client Package - SDK: Additional header files and an example 
> makefile for developing Oracle applications with Instant Client
> 
> by "rpm -i".
> 
> But (so far) nevertheless I don`t get mapserver configured with oracle 
> spatial.
> 
> For me it`s not clear with path I have to set. I have (e.g.) tried:
> 
> cmake ..  
> -DCMAKE_PREFIX_PATH=/usr/lib64:/usr/share/gdal:/usr/share/oracle/11.2/client64
>  -DWITH_ORACLESPATIAL=1 -DWITH_HARFBUZZ=0 -DWITH_PROTOBUFC=0 -DWITH_FRIBIDI=0 
> -DWITH_FCGI=0
> 
> 
> ...without success.
> 
> On SUSE SLES 15 I have "oracle-entires" at:
> 
> 
> /usr/share/oracle/11.2/client64
> /usr/lib/oracle/11.2/client64/
> /usr/include/oracle/11.2/client64/
> 
> I there any other step I have to do?
> 
> Thank you very much, Kai
> 
> 
> 
> 
> 
> Mit freundlichen Grüßen
> Im Auftrag
> 
> Kai Behncke
> Geoinformation
> Tel.: +49 5451 931-7125
> 
> E-Mail: kai.behn...@ibbenbueren.de 
> 
> Rathaus II
> Roncallistraße 3-5
> 1. Stock, Raum 105
> 49477 Ibbenbüren
> 
> 
> >>> Michael Smith  15.07.2019 18:19 >>>
> Kai,
>  
> To compile mapserver with oracle support, you need the sdk and the oracle 
> client library. The instant client library and sdk files are fine for this. 
> You do not need a local install of the database or the full client.
>  
> You need Instant Client Package – SDK and the Basic (or Basic Light) Package.
>  
> Mike
>  
>  
> --
> Michael Smith
> Remote Sensing/GIS Center
> US Army Corps of Engineers
>  
>  
> From: mapserver-users  on behalf of 
> Kai Behncke 
> Date: Monday, July 15, 2019 at 11:49 AM
> To: "mapserver-users@lists.osgeo.org" 
> Subject: [mapserver-users] MapServer with oracle-spatial on a linuxsystem
>  
> Dear users,
>  
> on a SUSE System (SLES 15) I try to configure mapserver 7.4. with 
> Oracle-spatial support.
>  
> Important: The Oracle Database is installed on another server.
>  
> I wonder if I need also the oracle-installation on the SLES 15-server or if 
> the oracle client is enough? So far I installed the client at 
> /usr/lib64/oracle/11.2.0.4.0/client/lib/
>  
> I try to configure with:
>  
> cmake .. 
> -DCMAKE_PREFIX_PATH=/usr/lib64:/usr/share/gdal:/usr/lib64/oracle/11.2.0.4.0/client/lib
>  -DWITH_ORACLESPATIAL=1 -DWITH_HARFBUZZ=0 -DWITH_PROTOBUFC=0 -DWITH_FRIBIDI=0
>  
> ...but in the output I always get: CMake Error at CMakeLists.txt:73 
> (message): ORACLESPATIAL library/component/dependency could not be found.
>  
> Does that mean I definetely need an oracle installation?
>  
> Thank you very much, Kai
> Mit freundlichen Grüßen
> Im Auftrag
> Kai Behncke
> Geoinformation
> Tel.: +49 5451 931-7125
> E-Mail: kai.behn...@ibbenbueren.de
> Rathaus II
> Roncallistraße 3-5
> 1. Stock, Raum 105
> 49477 Ibbenbüren
>  
> ___ 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 mailing list
mapserver-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] MapServer with oracle-spatial on a linuxsystem

[Michael Smith]

Kai,

 

To compile mapserver with oracle support, you need the sdk and the oracle 
client library. The instant client library and sdk files are fine for this. You 
do not need a local install of the database or the full client.

 

You need Instant Client Package – SDK and the Basic (or Basic Light) Package.

 

Mike

 

 

--

Michael Smith

Remote Sensing/GIS Center

US Army Corps of Engineers

 

 

From: mapserver-users  on behalf of 
Kai Behncke 
Date: Monday, July 15, 2019 at 11:49 AM
To: "mapserver-users@lists.osgeo.org" 
Subject: [mapserver-users] MapServer with oracle-spatial on a linuxsystem

 

Dear users,

 

on a SUSE System (SLES 15) I try to configure mapserver 7.4. with 
Oracle-spatial support.

 

Important: The Oracle Database is installed on another server.

 

I wonder if I need also the oracle-installation on the SLES 15-server or if the 
oracle client is enough? So far I installed the client at 
/usr/lib64/oracle/11.2.0.4.0/client/lib/

 

I try to configure with:

 

cmake .. 
-DCMAKE_PREFIX_PATH=/usr/lib64:/usr/share/gdal:/usr/lib64/oracle/11.2.0.4.0/client/lib
 -DWITH_ORACLESPATIAL=1 -DWITH_HARFBUZZ=0 -DWITH_PROTOBUFC=0 -DWITH_FRIBIDI=0

 

...but in the output I always get: CMake Error at CMakeLists.txt:73 (message): 
ORACLESPATIAL library/component/dependency could not be found.

 

Does that mean I definetely need an oracle installation?

 

Thank you very much, Kai



Mit freundlichen Grüßen
Im Auftrag

 

Kai Behncke
Geoinformation
Tel.: +49 5451 931-7125

 

E-Mail: kai.behn...@ibbenbueren.de 

 

Rathaus II
Roncallistraße 3-5
1. Stock, Raum 105
49477 Ibbenbüren

 

 

___ 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] MS4W version 4.0.0 released!

[Michael Smith]

Congrats to Gateway Geomatics on a big release!

Mike


-- 
Michael Smith
Remote Sensing/GIS Center
US Army Corps of Engineers


On 3/12/19, 6:48 PM, "mapserver-users on behalf of Jeff McKenna" 
 wrote:

Hello all!

Today is a big day as Gateway Geomatics is truly proud to announce that 
MS4W 4.0.0 is finally available! This is a huge release of changes, as 
every library (over 200 now) has been upgraded and built with a new 
compiler (Visual Studio 2017), and contains many great additions 
overall.  Get it now at https://ms4w.com

Please see MS4W's HISTORY.txt for all of the changes (or the bottom of 
this email for the full list), but here are some of the highlights:

  - PHP7 mapscript support (using the SWIG API)
  - PHP 7.2.16
  - embedded Python 3.7.0
  - running pycsw Catalogue Server
  - expanded ZOO-Project WPS support (all GDAL/OGR services, Python, 
PHP, CSharp, Java)
  - new Matomo Analytics package
  - simple map viewer on the localhost page
  - GDAL 2.4.0
  - MapServer 7.4.0-dev
  - mod_wsgi for Apache
  - Mapbox Vector Tile output through MapServer (demo included)
  - osm2pgsql commandline utility
  - many HTTPS config changes and fixes (including a workaround for a 
show-stopping MapCache issue on some systems)
  - enhancements to the setup.exe installer
  - and many more...

You can see that MS4W-4.0.0 is a full SDI for Windows environments, with 
~40+ working mapfiles and over 1.7GB of files, empowering DevOps and 
organizations worldwide.  Also note that this is a major release for 
MS4W, meaning that some things have changed dramatically (PHPmapscript 
will now use the SWIG API for example), so please follow MS4W's README 
for specific instructions for the many plugins and mapscripts.

When installing, it is very important that (if you are using the .zip) 
your server must have the C++ Redistributable installed on it 
beforehand: execute the local file /ms4w/tmp/vcredist_x86.exe 
(alternatively if you use MS4W's setup.exe installer this is done 
automatically)

As always please provide your requests for enhancements and issues 
through the MS4W tracker (so the feedback is not lost or forgotten): 
https://ms4w.com/trac/  You can also contact me directly for support.

Thank you all for sharing your spatial information with MS4W !!

"MS4W: open doors and as well as windows"


-jeff


-- 
Jeff McKenna
MapServer Consulting and Training Services
https://gatewaygeomatics.com/



Full 4.0 Changelog
--

2019-03-12
   * ms4w version 4.0.0 created. Notable changes are:
  - upgraded PHP to 7.2.16 (trac ticket 194)
  - re-add php_ogr.dll extension (trac ticket 190)
  - upgraded MapServer and MapScript (CSharp, Java, Python, PHP) 
to today's 7.4.0-dev
  - upgraded MapCache to today's 1.7dev
  - handle null MapCache CURL_CA_BUNDLE environment variable 
occuring on some systems (trac ticket 189)
  - include latest mapcache.xml.sample
  - added SSL_CERT_FILE path to setenv.bat
  - set certificates bundle path in php.ini (trac ticket 171)
  - set OPENSSL_CONF path in httpd.conf
  - added osm2pgsql commandline utility, with Visual Studio 2017 
compiler (trac ticket 48)
  - clean unused files from the TinyOWS demo (trac ticket 183)


2019-02-11
   * ms4w version 4.0.0-beta2 created. Notable changes are:
  - upgraded PHP to 7.2.15 (trac ticket 184)
  - upgraded APCu to 5.1.17
  - upgraded MapServer and MapScript (CSharp, Java, Python, PHP) 
to today's 7.4.0-dev
  - moved mapscript plugins into /ms4w/msplugins
  - moved test-cgi-mapscript.py into 
/ms4w/msplugins/mapscript/python
  - use relative paths for MapCache and mod_wsgi Apache modules 
(trac ticket 185)
  - use relative paths for ZOO-Project's main.cfg

2019-02-04
   * ms4w version 4.0.0-beta1 created. Notable changes are:
  - upgraded MapServer and MapScript (CSharp, Java, Python, PHP) 
to 7.4.0-dev with Visual Studio 2017 compiler
  - upgraded PHP to 7.2.14 (trac ticket 67)
  - added Python 3.7.0 into base installation, with Visual 
Studio 2017 compiler (trac ticket 65)
  - added Mapbox Vector Tile (MVT) output for MapServer with 
Visual Studio 2017 compiler (trac ticket 166)
  - added MVT demo, credit to Steve Lime
  - upgraded GDAL to 2.4.0 with Visual Studio 2017 compiler 
(trac ticket 164)
  - upgraded Apache HTTP Server to 2.4.38 with Visual Studio 
2017 compiler (trac ticket 177)
 

Re: [mapserver-users] Does mapserver or mapcache have support for reading arcgis REST services?

[michael . smith . erdc]

Stephen,

GDAL does therefore mapserver does. It’s treated similar to WMS in gdal. See 
https://www.gdal.org/frmt_wms.html

Michael Smith
Remote Sensing/GIS Center
US Army Corps

> On Mar 3, 2019, at 10:09 AM, Stephen Woodbridge 
>  wrote:
> 
> Hi,
> 
> Does mapserver or mapcache have support for reading arcgis REST services? and 
> does anyone have an example?
> Below is an example url that fetches an image from such a sevice.
> 
> Thanks,
>   -Steve W
> 
> https://gis.charttools.noaa.gov/arcgis/rest/services/MCS/ENCOnline/MapServer/exts/Maritime
>  Chart 
> Server/MapServer/export?dpi=96=true=png8_on=false=-8692756.952040665,4011444.4639844387,-8679877.312774628,4018362.015044238={"wkid":102100}=1348,724=image_params={"ECDISParameters":{"version":"1.0","StaticParameters":{"Parameter":[{"name":"AreaSymbolizationType","value":2},{"name":"PointSymbolizationType","value":2}]},"DynamicParameters":{"Parameter":[{"name":"ColorScheme","value":1},{"name":"DisplayDepthUnits","value":1},{"name":"TwoDepthShades","value":1},{"name":"DisplayNOBJNM","value":2},{"name":"HonorScamin","value":2},{"name":"ShallowDepthPattern","value":1},{"name":"ShallowContour","value":2},{"name":"SafetyContour","value":10},{"name":"DeepContour","value":30},{"name":"DisplayCategory","value":"1,2,4"}]}}}=show:0,1,2,3,4,5,6,7
> 
> ---
> This email has been checked for viruses by Avast antivirus software.
> https://www.avast.com/antivirus
> 
> ___
> 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] MapServer 6.4 URL-Problem (Variable-Substitution)

[Michael Smith]

Mike,

 

In version 6 and above, you need to add a validation block for each 
substitution variable. 

 

https://mapserver.org/mapfile/validation.html

 

Mike

 

 

-- 

Michael Smith

Remote Sensing/GIS Center

US Army Corps of Engineers

 

 

From: mapserver-users  on behalf of 
"Elstermann, Mike" 
Date: Friday, September 7, 2018 at 10:16 AM
To: "'mapserver-users@lists.osgeo.org'" 
Subject: [mapserver-users] MapServer 6.4 URL-Problem (Variable-Substitution)

 

My problem in URLs with Variable-Substitution:

 
http://myserver?...='[bez]'='A1' OR '[bez]'='1:500'&… à 
correct Output (Map-Picture)
http://myserver?...=%27%5Bbez%5D%27%3D%27A1%27%20OR%20%27%5Bbez%5D%27%3D%271%3A500%27&…
 à incorrect Output (NO Map-Picture)
Error-Message: msValidateParameter(): Regular expression error. Parameter 
pattern validation failed.
 

In my MapFile:

CLASS

…

EXPRESSION (%druckvorschauclass%)

…

END

 

Using MapServer 6.4 (in 5.x it was OK)

 

Any ideas?

 

THX!

mikeE.

 

___ 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] Is it possible to isolate mapserver on docker?

[Michael Smith]

You can certainly run mapserver via cgi standalone on docker but if you want to 
do php mapscript, you’d need mapserver compiled with php mapscript in the 
docker container. If you do that, you’d probably need a http server inside the 
container but then you would proxy that out to your external http server. 

Michael Smith

> On Jun 30, 2018, at 9:59 AM, Antti J. Lind  wrote:
> 
> Hello list,
> 
> We are currently using php-mapserver-apache on centos7.
> Now there is one wms-server, which is using wms server version 1.3.0 and our 
> mapservers client does not.
> It seems to be quite big change to update our current version 6.2 to 7.2 beta 
> and run it on same host as php-scripts and apache.
> 
> It there some way to isolate mapserver on docker or run it on another host 
> without http-server?
> On docker hub there is only images, which are including http-server with 
> mapserver.
> 
> --
> Antti J. Lind
> BirdLife Finland
> 
> ___
> 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] MapServer on Centos 7

[Michael Smith]

We (US Army Corps as well as the other federal agencies I work with, US Army 
and NGA) use MapServer 7.x on both RHEL 7 and Oracle Enterprise Linux 7 (binary 
compatible with Centos 7) and have no issues. It’s a very stable platform for 
us. We run in STIG-ified Apache 2 web server without issue. You can certainly 
send this to any ISP. 

Note that we compile and deploy on separate on separate boxes so we only have 
the devel packages and compilers on one and then the generated binaries and 
depending libs on a separate box.

Mike


--
Michael Smith
Remote Sensing/GIS Center
US Army Corps of Engineers


-Original Message-
From: mapserver-users <mapserver-users-boun...@lists.osgeo.org> on behalf of 
Mark Jackson <mark.jack...@cerc.co.uk>
Date: Wednesday, April 25, 2018 at  11:05 AM
To: <mapserver-users@lists.osgeo.org>
Subject: [mapserver-users] MapServer on Centos 7

Hi there

We have a managed server with MapServer and Centos. We asked our ISP 
about moving to a new server and they said MapServer "would not work 
well with CentOS7, certainly not without a great deal of 
customisation and it's something we would not recommend. " (I am not 
convinced they know much about MapServer though...)

Does MapServer work well on Centos 7?
Is there a web page that says MapServer works well on Centos 7 - so I 
can send it to the ISP ?

Back in 2011 the same ISP installed MapServer 5.6.6 onto Centos 5 
quite easily, compiling it from source. I don't know exactly why they 
are reluctant to install MapServer on Centos 7 - they have not given 
details. We would be happy to use the most up-to-date MapServer, 7.

I've looked at mapserver.org but can't find anything clear about 
Centos 7 support. I think the most relevant pages are the download 
page http://mapserver.org/uk/download.html and the compiling on Unix 
page http://mapserver.org/installation/unix.html

(I'm reluctant to shift to another ISP because up to now, these guys 
have been excellent. I'd like to convince them that MapServer is fine 
on Centos 7.)

Thanks
Mark



***
Cambridge Environmental Research Consultants Ltd. cannot accept any
responsibility for the accuracy or completeness of this message as 
it has been transmitted over a public network.

This e-mail and any files transmitted with it are private and intended
solely for the use of the individual or entity to whom they are 
addressed. If you are not the intended recipient, this e-mail and any 
accompanying files have been transmitted to you in error.  You may not 
copy, distribute or make any other use of the information contained in 
them.

CERC is a trading name of Cambridge Environmental Research Consultants Ltd,
registered at Cardiff with number 1926883. Registered Office address: 
3 Kings Parade, Cambridge, CB2 1SJ.

___
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] Mapserver 6.4 error compilation

[Michael Smith]

1). No, it's not a problem that those functions aren't found. That’s normal.

2). It looks like you might not have installed the development versions of 
freetype and libjpeg as the errors are that the headers in the include dirs 
aren't being found. Also for Oracle, you should set an env variable to the 
ORACLE_HOME dir, something like:

export ORACLE_HOME=/opt/instantclient
export LD_LIBRARY_PATH=${ORACLE_HOME}:/usr/lib

You'll also need to make sure you've setup the symlinks on the oracle client, 
eg:
  ln -s libclntsh.so.12.1 libclntsh.so
  ln -s libocci.so.12.1 libocci.so

And installed libaio.

Mike

-- 
Michael Smith
Remote Sensing/GIS Center
US Army Corps of Engineers



On 3/26/18, 4:13 AM, "mapserver-users on behalf of DamienZINS" 
<mapserver-users-boun...@lists.osgeo.org on behalf of damien.z...@intitek.fr> 
wrote:

Hi 
 
i want compile maprserver 6.4 on CentOS 7
the command is 
cmake -DCMAKE_INSTALL_PREFIX="/" -DCMAKE_PREFIX_PATH=""

-DINSTALL_LIB_DIR=/gldev/gcidev/install/lib:$gldev/gcidev/install/bin:gldev/gcidev/install/include:/usr:/gldev/gcitest/install/include/freetype2/freetype:/usr/include/
-DCMAKE_VERBOSE_MAKEFILE=ON -DCMAKE_BUILD_TYPE="debug" -DWITH_GEOS=OFF
-DWITH_FCGI=OFF -DWITH_FREETYPE=ON -DWITH_JPEG=ON -DWITH_CLIENT_WMS=OFF
-DWITH_CLIENT_WFS=OFF -DWITH_RSVG=OFF -DWITH_POSTGIS=OFF -DWITH_FRIBIDI=OFF
-DWITH_HARFBUZZ=OFF -DWITH_CAIRO=OFF -DWITH_GEOS=OFF -DWITH_CURL=OFF
-DWITH_SOS=OFF -DWITH_GIF=OFF -DWITH_EXEMPI=OFF -DWITH_ICONV=ON
-DWITH_GDAL=ON -DWITH_OGR=ON -DWITH_ORACLESPATIAL=ON -DWITH_PHP=ON
-DWITH_PROJ=ON >>${LOG_FILE}

In .log
-- The C compiler identification is GNU 4.8.5
-- The CXX compiler identification is GNU 4.8.5
-- Check for working C compiler: /usr/bin/cc
-- Check for working C compiler: /usr/bin/cc -- works
-- Detecting C compiler ABI info
-- Detecting C compiler ABI info - done
-- Check for working CXX compiler: /usr/bin/c++
-- Check for working CXX compiler: /usr/bin/c++ -- works
-- Detecting CXX compiler ABI info
-- Detecting CXX compiler ABI info - done
-- Looking for strrstr
-*- Looking for strrstr - not found*
-- Looking for strcasecmp
-- Looking for strcasecmp - found
-- Looking for strcasestr
-- Looking for strcasestr - found
-- Looking for strdup
-- Looking for strdup - found
-- Looking for strlcat
*-- Looking for strlcat - not found*
-- Looking for strlcpy
*-- Looking for strlcpy - not found*
-- Looking for strlen
-- Looking for strlen - found
-- Looking for strncasecmp
-- Looking for strncasecmp - found
-- Looking for vsnprintf
-- Looking for vsnprintf - found
-- Looking for lrintf
-- Looking for lrintf - found
-- Looking for lrint
-- Looking for lrint - found
-- Looking for dlfcn.h
-- Looking for dlfcn.h - found
-- Performing Test HAVE_SYNC_FETCH_AND_ADD
-- Performing Test HAVE_SYNC_FETCH_AND_ADD - Success
-- Found ZLIB: /usr/lib64/libz.so (found version "1.2.7")
-- Found PNG: /usr/lib64/libpng.so (found version "1.5.13")
-- Could NOT find JPEG (missing:  JPEG_LIBRARY JPEG_INCLUDE_DIR)
-- Could NOT find Freetype (missing:  FREETYPE_LIBRARY FREETYPE_INCLUDE_DIR)
-- Could NOT find PROJ (missing:  PROJ_LIBRARY PROJ_INCLUDE_DIR)
-- Looking for iconv
-- Looking for iconv - found
-- Found iconv library:
-- Could NOT find ORACLE (missing:  ORACLE_LIBRARY ORACLE_INCLUDE_DIR)
-- Found GDAL: /usr/local/lib/libgdal.so
-- Found LibXml2: /usr/lib64/libxml2.so (found version "2.9.1")
-- * Summary of configured options for this build
--  * Mandatory components
--   * png: /usr/lib64/libpng.so
*--   * jpeg: JPEG_LIBRARY-NOTFOUND*
*--   * freetype: FREETYPE_LIBRARY-NOTFOUND*
--  * Optional components
--   * GDAL: /usr/local/lib/libgdal.so
--   * OGR: /usr/local/lib/libgdal.so
--   * GD: disabled
--   * GIF: disabled
--   * MYSQL: disabled
--   * FRIBIDI: disabled
--   * GIF: disabled
--   * CAIRO: disabled
--   * SVGCAIRO: disabled
--   * RSVG: disabled
--   * CURL: disabled
--   * PROJ: disabled
--   * LIBXML2: /usr/lib64/libxml2.so
--   * POSTGIS: disabled
--   * GEOS: disabled
--   * FastCGI: disabled
--   * Oracle Spatial: disabled
--   * SDE: disabled
--   * Exempi XMP: disabled
--  * Optional features
--   * WMS SERVER: disabled
--   * WFS SERVER: disabled
--   * WCS SERVER: disabled
--   * SOS SERVER: disabled
--   * WMS CLIENT: disabled
--   * WFS CLIENT: disabled
--   * ICONV: ENABLED
--   * Thread-safety support: disabled
--   * KML output: disabled
--   * Z+M point coordinate support: disabled
--   * XML Mapfile support: disabled
--  * Mapscripts
--   * Python: disabled
--   

Re: [mapserver-users] 3D / 2.5D / Coordinates with Z and GEOMETRY Type in WFS

[Michael Smith]

Is it something we should even consider removing as a compile time option? 
Perhaps at an v8 release?

Michael Smith
Remote Sensing/GIS Center
US Army Corps of Engineers

> On Jul 4, 2017, at 4:46 PM, Jeff McKenna <jmcke...@gatewaygeomatics.com> 
> wrote:
> 
> Before this past long weekend I was testing with Windows and getting about a 
> 1% difference; but I didn't report it here because I was using the 
> 'wallclock' time and not CPU time, on Windows.  (that was with Even's 200 map 
> draw test)  I personally feel that the difference is so minimal now that yes, 
> we should enable SUPPORTS=POINT_Z_M for the next MS4W release.
> 
> -jeff
> 
> 
> 
> -- 
> Jeff McKenna
> MapServer Consulting and Training Services
> http://www.gatewaygeomatics.com/
> 
> 
> 
> 
>> On 2017-07-03 4:49 AM, Daniel Hardes wrote:
>> Do we need more testing or could "USE_POINT_Z_M = ON" the default in the 
>> next release?
>>> Even Rouault <even.roua...@spatialys.com> hat am 30. Juni 2017 um 16:40 
>>> geschrieben:
>>> 
>>> On vendredi 30 juin 2017 09:59:30 CEST Daniel Morissette wrote:
>>> 
>>> > On 2017-06-30 9:50 AM, Even Rouault wrote:
>>> 
>>> > > I'm wondering if we shouldn't revisit the decision to have USE_POINT_Z_M
>>> 
>>> > > disabled by default. This is often annoying.
>>> 
>>> > >
>>> 
>>> > > Apparently, adding USE_POINT_Z_M defaulting to OFF was driven by
>>> 
>>> > > performance reasons per
>>> 
>>> > > https://github.com/mapserver/mapserver/issues/1244 . But this was 12
>>> 
>>> > > years ago. Perhaps with recent hardware the performance difference isn't
>>> 
>>> > > that big. The ticket unfortunately doesn't contain a test case to bench
>>> 
>>> > > (likely lots of lines/polygons, or large lines/polygons to render). If
>>> 
>>> > > the perf difference is still there, a more involved change would be
>>> 
>>> > > indeed to move the z and m components into separate arrays.
>>> 
>>> >
>>> 
>>> > #1244 refers to #1224 which is using the gmap demo mapfile... which is a
>>> 
>>> > relatively small dataset, so it should be easy to verify if the issue is
>>> 
>>> > still relevant on more recent hardware using gmap or probably any other
>>> 
>>> > dataset.
>>> 
>>> >
>>> 
>>> > https://github.com/mapserver/mapserver-import/issues/1224
>>> 
>>> OK, I downloaded
>>> 
>>> http://dl.maptools.org/dl/gmap-ms46.tar.gz
>>> 
>>> (not sure if there's a more uptodate version of it).
>>> 
>>> Added the necessary MAP and SYMBOLSET keywords in the mapfile and symbolset 
>>> file.
>>> 
>>> With master, compiled in Release (-O3)
>>> 
>>> and the following Python mapscript bench.py
>>> 
>>> {{{
>>> 
>>> import mapscript
>>> 
>>> for i in range(200):
>>> 
>>> map = mapscript.mapObj('gmap75.map')
>>> 
>>> img1 = map.draw()
>>> 
>>> }}}
>>> 
>>> I ran it 10 times consecutively with each config and took the smallest time 
>>> ("real" figure)
>>> 
>>> With USE_POINT_Z_M=OFF
>>> 
>>> time python bench.py
>>> 
>>> real 0m4.167s
>>> 
>>> user 0m3.964s
>>> 
>>> sys 0m0.200s
>>> 
>>> With USE_POINT_Z_M=ON
>>> 
>>> time python bench.py
>>> 
>>> real 0m4.252s
>>> 
>>> user 0m3.972s
>>> 
>>> sys 0m0.260s
>>> 
>>> So USE_POINT_Z_M=ON is 2% slower than OFF
>>> 
>>> On a recent (~ 1 year old) laptop with a
>>> 
>>> Intel(R) Core(TM) i7-6700HQ CPU @ 2.60GHz
>>> 
>>> Even
>>> 
>>> --
>>> 
>>> Spatialys - Geospatial professional services
>>> 
>>> http://www.spatialys.com
>>> 
> ___
> 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] 3D / 2.5D / Coordinates with Z and GEOMETRY Type in WFS

[Michael Smith]

What os? I know the mapserver docker packages 
(https://hub.docker.com/r/mapserver/mapserver/)  have it but most of the 
windows versions, MS4W, GisInternals, don’t. Don’t know about OSGeo4W. 


Michael Smith
Remote Sensing/GIS Center
US Army Corps of Engineers

> On Jun 30, 2017, at 6:12 AM, Daniel Hardes <har...@3dis.de> wrote:
> 
> Ok. Is there a prebuild version with USE_POINT_Z_M somewhere?
> 
>> Michael Smith <michael.smith.e...@gmail.com> hat am 30. Juni 2017 um 12:02 
>> geschrieben:
>> 
>> Daniel,
>> 
>> There is a section in the OGC WFS Server docs that explains this. Look at 
>> http://mapserver.org/ogc/wfs_server.html#reference-section, specifically the 
>> Layer section. You have to have mapserver compiled with USE_POINT_Z_M 
>> support and you have to set the geometry type to a 2.5D type, eg something 
>> like "ows_geomtype" "Polygon25D"
>> 
>> Michael Smith
>> Remote Sensing/GIS Center
>> US Army Corps of Engineers
>> 
>>> On Jun 30, 2017, at 5:49 AM, Daniel Hardes <har...@3dis.de> wrote:
>>> 
>>> Hello,
>>> 
>>> i have a PostGIS database with point, line and polygon geometries and all 
>>> have a Z-coordinate. 
>>> 
>>> First problem: Is it possible to create a layer in the mapfile without a 
>>> fixes type? i think a layer has to have a Type property but there ist no 
>>> general geometry type.
>>> 
>>> Second problem: All coordinates have only X and Y values but no Z 
>>> value... they have the value in the database. Is it possible zu get the 
>>> Z-coordinate from the WFS?
>>> 
>>> 
>>> 
>>> Greetings Daniel
>>> 
>>> ___
>>> 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] WCS layer parameters from data

[Michael Smith]

Is there a way to set the WCS layer level parameters, such as rangeset_name,
from a data column?

Mike


Michael Smith
US Army Corps
Remote Sensing GIS/Center
michael.sm...@usace.army.mil



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

Re: [mapserver-users] Embed map (detail map) in mapserver output?

[Michael Smith]

Bob,

I use the MapFish print engine for this. It's a nice templating language, PDF 
generation, etc. 

Michael Smith
Remote Sensing/GIS Center
US Army Corps of Engineers

> On Feb 8, 2017, at 5:52 PM, Basques, Bob (CI-StPaul) 
> <bob.basq...@ci.stpaul.mn.us> wrote:
> 
> Hi Steve,
> 
> It’s for compositing for printing.  I want to set up some page templates for 
> a map book where any of the pages can be run off when an update occurs in a 
> particular location in the global map, vs printing the whole book.  
> 
> On a more detailed level, this is starting to get into a print tool, which 
> I’ve been pondering building for online use.  The idea would be to mix and 
> match (stack) different print features on a canvas for eventual printing.  My 
> need right now is for something as an API, but I can see this easily morphing 
> into a user interface.
> 
> I actually already do some of those other items like ,collars and grids with 
> MapServer, they just use different mapfiles for each.  Just trying to figure 
> out the best way to pull it all together.  I think I’ll just hardcode 
> something together right now, and see where I can insert URLS and resource 
> links into the hardcoded pipeline after the fact.  I have a Fire response map 
> that I’m working on right now as a test.  It’s big too, 42”x60”, all in one 
> shot right out of MapServer.  Works really nicely for the basemap already.
> 
> There are a bunch of detail reference maps needed though, which is what I’m 
> working on now. 
> 
> I was pondering things from the point of view that these detail maps are 
> really just another type of Legend (or could be thought of that way)
> 
> bobb
> 
> 
>> On Feb 8, 2017, at 4:39 PM, Stephen Woodbridge <wood...@swoodbridge.com> 
>> wrote:
>> 
>>> On 2/8/2017 5:22 PM, Basques, Bob (CI-StPaul) wrote:
>>> All,
>>> 
>>> Anyone know of a way (trick) to embed a map into a regular map query in
>>> Mapserver?  Something like embedding a legend, but I actaully want to
>>> embed another higher resolution detail map.  Ideally I would be able to
>>> use any of the layers in the main map for the detail as well.
>>> 
>>> Hmm, I wonder if I can make what I want in a LEGEND block?? If an image
>>> in a LEGEND block could be another call to mapserver in place of a
>>> static image . . .   Just a wishlist thing right now.  I can stack
>>> things in another piece of software currently.
>> 
>> Bob,
>> 
>> This sounds like something you might find in a composition tool. There might 
>> be a way to make (trick) mapserver do this, like allowing a image symbol to 
>> be create using a url rather than a file, then placing that on the map, but 
>> mapserver has a great focus on high performance map image rendering. What is 
>> your use case for this?
>> 
>> I think it might be better to think about this problem in terms of creating 
>> a composition tool oriented toward maps that would allow collars, legends, 
>> detailed maps, annotations, grids, etc and be able to output PDFs or images, 
>> or formats compatible with document systems or whatever.
>> 
>> -Steve W
>> 
>> ---
>> This email has been checked for viruses by Avast antivirus software.
>> https://www.avast.com/antivirus
>> 
>> ___
>> mapserver-users mailing list
>> mapserver-users@lists.osgeo.org
>> https://lists.osgeo.org/mailman/listinfo/mapserver-users
> 
> 
> 
> "I think there is a world market for maybe five computers."
> - Thomas Watson (1874-1956), Chairman of IBM, 1943
> 
> 
> 
> ___
> 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] arcgis 10.3 enterprise geodatabase

[Michael Smith]

MapServer does not use any oracle spatial calls, just locator. There is no
extra cost need to use mapserver with Oracle SDO_GEOMETRY data.

Mike

-- 
Michael Smith
Remote Sensing/GIS Center
US Army Corps of Engineers

From:  "Rahkonen Jukka (MML)" <jukka.rahko...@maanmittauslaitos.fi>
Date:  Friday, November 4, 2016 at  12:09 PM
To:  "Wingfield, Nathaniel D" <n...@dcp.ufl.edu>, Michael Smith
<michael.smith.e...@gmail.com>, "Lime, Steve D (MNIT)"
<steve.l...@state.mn.us>, Oscar ^_^ <oscar...@gmail.com>
Cc:  "mapserver-users@lists.osgeo.org" <mapserver-users@lists.osgeo.org>
Subject:  Re: [mapserver-users] arcgis 10.3 enterprise geodatabase

> Hi,
> 
> Are you sure that you would need Spatial? Locator covers nowadays most use
> cases.
> 
> -Jukka Rahkonen-
> 
> Lähettäjä: Wingfield, Nathaniel D <mailto:n...@dcp.ufl.edu>
> Lähetetty: 4.11.2016 18:00
> Vastaanottaja: Michael Smith <mailto:michael.smith.e...@gmail.com> ; Lime,
> Steve D (MNIT) <mailto:steve.l...@state.mn.us> ; Oscar ^_^
> <mailto:oscar...@gmail.com>
> Kopio: mapserver-users@lists.osgeo.org
> Aihe: Re: [mapserver-users] arcgis 10.3 enterprise geodatabase
> 
> That¹s a great approach, but sadly the Oracle Spatial licensing is out of
> reach for us.
>  
> Almost 10 years ago, I used SDO_GEOMETRY with ArcSDE but it was rather buggy
> on the ESRI side. I wonder if their support has improved?
>  
> 
> From: Michael Smith [mailto:michael.smith.e...@gmail.com]
> Sent: Thursday, November 03, 2016 4:08 PM
> To: Lime, Steve D (MNIT) <steve.l...@state.mn.us>; Oscar ^_^
> <oscar...@gmail.com>; Wingfield, Nathaniel D <n...@dcp.ufl.edu>
> Cc: mapserver-users@lists.osgeo.org
> Subject: Re: [mapserver-users] arcgis 10.3 enterprise geodatabase
>  
> 
> The other option, which is what we use, is to store ArcGIS 10.3 enterprise
> data as SDO_GEOMETRY native. We find no performance penalties in ArcGIS and
> performance benefits for non-esri software, such as mapserver.
> 
>  
> 
> Mike
> 
>  
> 
> -- 
> 
> Michael Smith
> 
> Remote Sensing/GIS Center
> 
> US Army Corps of Engineers
> 
>  
> 
> From: mapserver-users <mapserver-users-boun...@lists.osgeo.org
> <mailto:mapserver-users-boun...@lists.osgeo.org> > on behalf of "Lime, Steve D
> (MNIT)" <steve.l...@state.mn.us <mailto:steve.l...@state.mn.us> >
> Date: Thursday, November 3, 2016 at 4:02 PM
> To: Oscar ^_^ <oscar...@gmail.com <mailto:oscar...@gmail.com> >, "Wingfield,
> Nathaniel D" <n...@dcp.ufl.edu <mailto:n...@dcp.ufl.edu> >
> Cc: "mapserver-users@lists.osgeo.org <mailto:mapserver-users@lists.osgeo.org>
> " <mapserver-users@lists.osgeo.org <mailto:mapserver-users@lists.osgeo.org> >
> Subject: Re: [mapserver-users] arcgis 10.3 enterprise geodatabase
> 
>  
>> 
>> If GDAL/OGR can handle the format then you¹re in luck. I¹d check there firstŠ
>>  
>> From: mapserver-users [mailto:mapserver-users-boun...@lists.osgeo.org
>> <mailto:mapserver-users-boun...@lists.osgeo.org> ] On Behalf Of Oscar ^_^
>> Sent: Thursday, November 03, 2016 2:51 PM
>> To: Wingfield, Nathaniel D <n...@dcp.ufl.edu <mailto:n...@dcp.ufl.edu> >
>> Cc: mapserver-users@lists.osgeo.org <mailto:mapserver-users@lists.osgeo.org>
>> Subject: Re: [mapserver-users] arcgis 10.3 enterprise geodatabase
>>  
>> 
>> I've got the same requeriment althought i can use 10.1 or 10.2 but i don't
>> know how to implement these to Mapserver
>> 
>>  
>> 
>> Any suggestion o guide ??
>> 
>>  
>> 
>> 2016-11-01 7:39 GMT-06:00 Wingfield, Nathaniel D <n...@dcp.ufl.edu>:
>>> Can MapServer consume spatial data from an ArcGIS 10.3 enterprise
>>> geodatabase? We are using the default SDE.ST_GEOMETRY type, on Oracle. The
>>> MapServer docs indicate that any support for ESRI enterprise geodatabases is
>>> based on ArcSDE, which was abandoned by ESRI at version 10.3, in favor of
>>> direct connect 
>>> (https://blogs.esri.com/esri/supportcenter/2015/02/11/where-is-the-install-f
>>> or-arcsde-10-3/).
>>> 
>>> We will likely use OpenLayers for a new web-based mapping app, so MapServer
>>> seems like a natural choice (otherwise we will have to use ArcGIS Server).
>>> ___
>>> mapserver-users mailing list
>>> mapserver-users@lists.osgeo.org
>>> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>> 
>> 
>>  
>> -- 
>> 
>> OSCAR
>>  @
>> ^_^
>>  Y
>> ___ mapserver-users mailing list
>> mapserver-users@lists.osgeo.org <mailto:mapserver-users@lists.osgeo.org>
>> 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] arcgis 10.3 enterprise geodatabase

[Michael Smith]

The other option, which is what we use, is to store ArcGIS 10.3 enterprise
data as SDO_GEOMETRY native. We find no performance penalties in ArcGIS and
performance benefits for non-esri software, such as mapserver.

Mike

-- 
Michael Smith
Remote Sensing/GIS Center
US Army Corps of Engineers

From:  mapserver-users <mapserver-users-boun...@lists.osgeo.org> on behalf
of "Lime, Steve D (MNIT)" <steve.l...@state.mn.us>
Date:  Thursday, November 3, 2016 at  4:02 PM
To:  Oscar ^_^ <oscar...@gmail.com>, "Wingfield, Nathaniel D"
<n...@dcp.ufl.edu>
Cc:  "mapserver-users@lists.osgeo.org" <mapserver-users@lists.osgeo.org>
Subject:  Re: [mapserver-users] arcgis 10.3 enterprise geodatabase

> If GDAL/OGR can handle the format then you¹re in luck. I¹d check there firstŠ
>  
> From: mapserver-users [mailto:mapserver-users-boun...@lists.osgeo.org] On
> Behalf Of Oscar ^_^
> Sent: Thursday, November 03, 2016 2:51 PM
> To: Wingfield, Nathaniel D <n...@dcp.ufl.edu>
> Cc: mapserver-users@lists.osgeo.org
> Subject: Re: [mapserver-users] arcgis 10.3 enterprise geodatabase
>  
> 
> I've got the same requeriment althought i can use 10.1 or 10.2 but i don't
> know how to implement these to Mapserver
> 
>  
> 
> Any suggestion o guide ??
> 
>  
> 
> 2016-11-01 7:39 GMT-06:00 Wingfield, Nathaniel D <n...@dcp.ufl.edu>:
>> Can MapServer consume spatial data from an ArcGIS 10.3 enterprise
>> geodatabase? We are using the default SDE.ST_GEOMETRY type, on Oracle. The
>> MapServer docs indicate that any support for ESRI enterprise geodatabases is
>> based on ArcSDE, which was abandoned by ESRI at version 10.3, in favor of
>> direct connect 
>> (https://blogs.esri.com/esri/supportcenter/2015/02/11/where-is-the-install-fo
>> r-arcsde-10-3/).
>> 
>> We will likely use OpenLayers for a new web-based mapping app, so MapServer
>> seems like a natural choice (otherwise we will have to use ArcGIS Server).
>> ___
>> mapserver-users mailing list
>> mapserver-users@lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/mapserver-users
> 
> 
>  
> -- 
> 
> OSCAR
>  @
> ^_^
>  Y
> ___ 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] zipped shapefile

[Michael Smith]

You need to include the name of the shapefile in the DATA statement, eg
DATA "/vsizip/myzipfile.zip/shapefile.shp"

Mike

----
Michael Smith

US Army Corps
Remote Sensing GIS/Center
michael.sm...@usace.army.mil




-Original Message-
From: mapserver-users <mapserver-users-boun...@lists.osgeo.org> on behalf
of Jeff McKenna <jmcke...@gatewaygeomatics.com>
Date: Wednesday, June 22, 2016 at 6:46 PM
To: <mapserver-users@lists.osgeo.org>
Subject: Re: [mapserver-users] zipped shapefile

>I'm also unable to get this to work.  I agree that it should (with the
>layer specified in the "DATA" statement), but I can't seem to get
>MapServer 7.0.1 to draw a map.  The error message is quite generic:
>
>   OGROpen(/vsizip/test.zip)
>   msOGRFileOpen(): OGR error. Open failed for OGR connection in layer
>'test'.  File not found or unsupported format.
>
>
>I believe you have found a nice enhancement.  I think you should file
>this in the issue tracker: https://github.com/mapserver/mapserver/issues
>
>
>-jeff
>
>
>
>-- 
>Jeff McKenna
>MapServer Consulting and Training Services
>http://www.gatewaygeomatics.com/
>
>
>
>
>On 2016-06-22 5:57 PM, lagrange123 wrote:
>> Hi,
>>
>> I have a bunch of shapefiles in zip format for disk space reasons. And I
>> want to be able to server their contents with mapserver. Is this
>>possible?
>>
>> I was thinking that I could use CONNECTIONTYPE OGR. And then, since
>>gdal/ogr
>> can read a zipped data source (per
>> https://trac.osgeo.org/gdal/wiki/UserDocs/ReadInZip), this would enable
>> mapserver to serve such a data source. However, I am not having much
>>luck,
>> and I don't know if this is even supported in mapserver.
>>
>> My layer definition is:
>>
>> LAYER
>>  NAME "my_shapefile"
>>  CONNECTIONTYPE OGR
>>  CONNECTION "/vsizip/path/to/file.zip"
>>  TYPE POLYGON
>>  STATUS ON
>> END
>>
>>
>>
>
>
>___
>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] Oracle Layer: how to set context prior to fetching the data

[Michael Smith]

Martin,

How I've done this in the past is use a plsql function that sets the
context and call that function in the query (and just have the function
return a dummy value that you don't use).

Mike

-- 
Michael Smith

Remote Sensing/GIS Center
US Army Corps of Engineers



On 3/24/16,  5:59 AM, "mapserver-users on behalf of Martin Icking"
<mapserver-users-boun...@lists.osgeo.org on behalf of
martin.ick...@bentley.com> wrote:

>One of the Oracle based sources we are publishing is using Oracle context
>variables to enable Oracle's fine grained access control.
>So we are in the need to set these context variables (e.g. current
>username)
>prior to doing the select defined by MapServer's DATA statement. In other
>applications we do that by calling a set_context (...) stored procedure
>prior to any data requests.
>Is there any possibility in MapServer to send a pre-request statement to
>the
>database? A current work-around is to set the context at logon time but
>that
>means that we need a new logon for every request that needs a different
>user
>context, not optimal for websites with many users. We'd prefer to have a
>single logon that can be re-used for all requests.
>If there is currently no way to handle this in MapServer we'd like to
>extend
>the Oracle layer's capabilities. Any suggestion by the MS developers on
>where we should place the needed extension in the mapfile (e.g. adding an
>additional keyword at the USING part of the data statement or using new
>layer metadata)?
>Any interest in generalizing this approach?
>
>Tx
>Martin
>
>
>
>--
>View this message in context:
>http://osgeo-org.1560.x6.nabble.com/Oracle-Layer-how-to-set-context-prior-
>to-fetching-the-data-tp5258155.html
>Sent from the Mapserver - User mailing list archive at Nabble.com.
>___
>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] Get current year in a CLASS EXPRESSION (mapfile)

[Michael Smith]

Well, the other option would be a regex on your date field. The specifics
on that will depend on what the default format is for your date field so
its much more fragile. If someone changes your date default, your regex
will no longer work properly.

Mike


Michael Smith

US Army Corps
Remote Sensing GIS/Center
michael.sm...@usace.army.mil




-Original Message-
From: mapserver-users <mapserver-users-boun...@lists.osgeo.org> on behalf
of wiltomap <wilt...@gmail.com>
Date: Wednesday, March 23, 2016 at 6:55 AM
To: <mapserver-users@lists.osgeo.org>
Subject: Re: [mapserver-users] Get current year in a CLASS EXPRESSION
(mapfile)

>Thanks Michael! Of course, I had thought about creating a view or
>manipulating the DATA parameter. The fact is that I can't do both because
>the layer related to the mapfile is used for online data editing, and the
>framework used for the website reclaims exactly identical columns inside
>tables and views used for such operations. I can't add a new column in the
>table because it won't be an existing field in the online form. This is
>complex to explain and I have no other choice than dealing with the
>existing
>website I haven't build myself.
>
>So, my question remains. Is there a way to achieve that within EXPRESSION
>parameter?
>
>
>
>--
>View this message in context:
>http://osgeo-org.1560.x6.nabble.com/Get-current-year-in-a-CLASS-EXPRESSION
>-mapfile-tp5257968p5257982.html
>Sent from the Mapserver - User mailing list archive at Nabble.com.
>___
>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] Get current year in a CLASS EXPRESSION (mapfile)

[Michael Smith]

Rather than adding a new column, you can create either a view or just
alter your select to add a year column derived from your date. Something
like

DATA "GEOMCOL from (SELECT a.*, to_char(datinter,'') as YEAR from
mytable) using unique gid using srid=4326"

And then just use the YEAR column in your EXPRESSION.

Mike

----
Michael Smith

US Army Corps
Remote Sensing GIS/Center
michael.sm...@usace.army.mil




-Original Message-
From: mapserver-users <mapserver-users-boun...@lists.osgeo.org> on behalf
of wiltomap <wilt...@gmail.com>
Date: Wednesday, March 23, 2016 at 6:17 AM
To: <mapserver-users@lists.osgeo.org>
Subject: [mapserver-users] Get current year in a CLASS EXPRESSION (mapfile)

>I have a mapfile defining a layer which is about leaks fixes on a drinking
>water network.
>
>I would like to write an EXPRESSION (inside a CLASS) to select all current
>year operations. I rely upon a PostgreSQL/PostGIS table which is storing
>leaks fixes dates in a DATE type field named "datinter" (format is
>YYY-MM-DD). For certain reasons I won't explain here (depending on the
>website general infrastructure), I can't add columns to the table to
>display
>year from the datinter column. I need to do it into the EXPRESSION
>parameter
>of my mapfile.
>
>I have tried things like this :
>
>CLASS
>  NAME "2016"
>  EXPRESSION ("[datinter]" > "2016-01-01")
>  ...
>END
>
>This kind of expression does filter some of the table rows but mixes
>different years... I don't understand what selection is made. Any idea on
>how to write the expression to achieve what I need?
>
>Thanks in advance!
>
>
>
>
>
>--
>View this message in context:
>http://osgeo-org.1560.x6.nabble.com/Get-current-year-in-a-CLASS-EXPRESSION
>-mapfile-tp5257968.html
>Sent from the Mapserver - User mailing list archive at Nabble.com.
>___
>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] Runtime variable Substitution Filter

[Michael Smith]

You can set a default value for your layer when no value is set. What I do is 
set it to something like 1=1 and then all values will display. 
http://mapserver.org/cgi/runsub.html#default-values-if-not-provided-in-the-url



Michael Smith
Remote Sensing/GIS Center
US Army Corps of Engineers

> On Mar 10, 2016, at 8:36 PM, milad nidal <miladnidal2...@gmail.com> wrote:
> 
> Hi,
> I'm using Runtime variable Substitution (FILTER "nom in ( %municipalitylist% 
> )") to chose one municipality from a list and it is going good. But how I can 
> visualize all the municipalities in the layer? Is-it possible to ignore the 
> filter?  
> 
> 
> Thanks
> ___
> 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] Using a attribute substring for labeling

[Michael Smith]

Lars,

I've looked through my mapfiles and it looks like I have always
accomplished this with sql manipulation. Not using mapserver string
functions.

However, Steve Lime or Jeff McKenna might know an innovative way of using
tostring() that I don't. They are very good with that kind of thing.


Michael Smith

US Army Corps
Remote Sensing GIS/Center
michael.sm...@usace.army.mil




-Original Message-
From: mapserver-users <mapserver-users-boun...@lists.osgeo.org> on behalf
of lars lingner <gislars+l...@gmail.com>
Date: Monday, February 29, 2016 at 2:02 PM
To: <mapserver-users@lists.osgeo.org>
Subject: [mapserver-users] Using a attribute substring for labeling

>Hello,
>
>while using a ShapeFile, created with gdaltindex, as data source for a
>layer I'd like to use a substring of the location attribute for labeling.
>
>I could (and probably will) preprocess the ShapeFile to add the label
>text as additional attribute. But I wanted to try this step within
>MapServer first.
>
>My current example contains a path and file name. The file name has a 4
>digit number in it I would like to use as label. To make it more
>complicated, the substring has various positions within the whole string.
>Maybe there is a way with tostring() which accepts sprintf formatting,
>but I couldn't figure out the correct syntax yet.
>
>With a database layer of course I would be able to use SQL to extract a
>substring and pass it as additional attribute, but not with a ShapeFile.
>
>Is there a way to extract a substring from an attribute value and use it
>as label? It would be nice to have a function available to use in
>EXPRESSION or TEXT parameter.
>
>Thank you in advance for any hints.
>
>Lars
>___
>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] Rendering VMAP1 & VMAP2 in VPF Format

[Michael Smith]

You don't have to convert it (although it may bring you performance to do
so). If your GDAL contains the OGDI driver, you can read it natively
(http://www.gdal.org/drv_ogdi.html)

Mike



From:  mapserver-users  on behalf
of "Francis, Mike" 
Date:  Friday, January 29, 2016 at 8:55 AM
To:  "'mapserver-users@lists.osgeo.org'" 
Subject:  [mapserver-users] Rendering VMAP1 & VMAP2 in VPF Format

> Good Morning,
>  
> What is the easiest way to load Vector Maps (VMAP1 & VMAP2) into map server.
> From what I have read vector maps need to be converted into a shape file and
> then a layer needs to be defined for that shape file.  I have created a script
> that takes set of VPF files and creates a point, line, area, and text shape
> file.  From that point I am able to create a layer that is able to render
> lines and points. I have not been able to get areas and text vector data to
> display anything.   Does a layer require a special property to render area and
> text?  Is there an easier way to render VPF data?
>  
> Thanks,
>  
> Mike Francis 
> ___ 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] [EXTERNAL] [mapserver-dev] Problem with filter in Oracle

[Michael Smith]

Always reply back to the list, others can assist also.

You need to set the DEBUG 3 at the layer level in your mapfile and then the
actual queries sent to Oracle will be displayed in the log file (as well as
any spatial bind values). Then you can run those queries outside of
mapserver and verify whether you are getting the rows of data you expect or
not.

Mike


Michael Smith
US Army Corps
Remote Sensing GIS/Center
michael.sm...@usace.army.mil


From:  Björn Danielsson <bjorn.daniels...@falubo.se>
Date:  Friday, January 15, 2016 at 2:40 AM
To:  Michael Smith <michael.smith.e...@gmail.com>
Subject:  Re: [EXTERNAL] [mapserver-dev] Problem with filter in Oracle

> Hi Michael and thanks for your quick response.
>  
> I did 3 runs with debuglevel 3 and the outcome from the debugger does not say
> me much.
>  
>   DEBUG  3
>   CONFIG "MS_ERRORFILE" "/ms4w/tmp/ms_error.txt"
>  
> I also activated the 'debugger' in my php scripts that writes a lot, among
> other things the database calls, to a file.
>  
> The three runs and the resulting debug files are called A,B and C. From
> mapserver debug 'ms_error_A.txt', and from php debug 'php_debug_A.log'. Look
> for 'filter = ' in the php debug files.
>  
> A, B and C refer to the examples in my original mail.
>  
> Run A shows the example:
>  $filter = "([ID]='".$sessid."')";
> with the layers 'AVD' and 'X' where 'AVD' works fine and 'X' does not.
>  
> Run B and C is from the same php script with different contents in filter.
> Look for layers 'AVD' and 'AVD-L'. Actually the same table and column. Layer
> 'AVD' shows polygons and layer 'AVD-L' the polygons' outlines.
> Run C works and run B does not.
> The column SKIFTE in run B is surrounded by parenthesis because it may be like
> (SKIFTE='A' OR SKIFTE='C' OR ...) because mapserver obviously no longer
> supports the 'in'-statement. I have tried without parenthesis but that did not
> change anything.
>  
> I can't see any pattern in this.
>  
> Björn Danielsson
>> -Original Message-
>> From: Michael Smith <michael.smith.e...@gmail.com>
>> To: Björn Danielsson <bjorn.daniels...@falubo.se>,
>> "mapserver-...@lists.osgeo.org" <mapserver-...@lists.osgeo.org>
>> Date: Thu, 14 Jan 2016 09:35:31 -0500
>> Subject: Re: [EXTERNAL] [mapserver-dev] Problem with filter in Oracle
>>  
>> Björn,
>>  
>> Can you turn on DEBUG level 3 and show what queries are being generated?
>>  
>> That will help isolate whats going on with the queries to the backend.
>>  
>> Mike
>>  
>> -- 
>> Michael Smith
>> Remote Sensing/GIS Center
>> US Army Corps of Engineers
>> From:  mapserver-dev < mapserver-dev-boun...@lists.osgeo.org
>> <mailto:mapserver-dev-boun...@lists.osgeo.org> > on behalf of Björn
>> Danielsson < bjorn.daniels...@falubo.se <mailto:bjorn.daniels...@falubo.se> >
>> Date:  Thursday, January 14, 2016 at 4:30 AM
>> To:  "mapserver-...@lists.osgeo.org " < mapserver-...@lists.osgeo.org
>> <mailto:mapserver-...@lists.osgeo.org> >
>> Subject:  [EXTERNAL] [mapserver-dev] Problem with filter in Oracle
>> Resent-From:  Michael Smith <michael.sm...@usace.army.mil >
>>  
>>> Hi,
>>>  
>>> I have been using ms4w for quite some time and have discovered problems with
>>> Oracle when using php_mapscript. I posted this problem at ms4w's support and
>>> was adviced to turn to you.
>>>  
>>> I am supporting a gis-system on the web that is heavily database dependent,
>>> and can run on either postgres or oracle according to the costumer's
>>> request. So there are two sets of php-scripts that are identical apart from
>>> the database calls.
>>>  
>>> Thera are no problems with postgres.
>>>  
>>> With Oracle there is a funny problem with filter.
>>> Look at this:
>>>   
>>> foreach($aLayersIdx as $layerIndex) {
>>>   $oLayerK = $oMapK->getLayer($layerIndex);
>>> if ($bDebug) {
>>>   fwrite($f,"layer: ".$oLayerK->name."\r\n");
>>> }
>>>   if ($oLayerK->name == "AVD" && $avd == "") {
>>> $oLayerK->set("status",MS_OFF);
>>> continue;
>>>   }
>>>   $filter = "";
>>>   switch ($oLayerK->name) {
>>> case "AVD" :
>>>   $filter = "([ORGID]='".$orgid."' AND [FV]='".$fv."' AND
>>> [BEV]='".$bev."' AND [SKIFTE]='".

Re: [mapserver-users] WMS Layer provided by MapSever rendering incorrectly in ol3.

[Michael Smith]

Neelesh,

You need to set your map projection to match your basemap. You need to set
it to spherical mercator.

 PROJECTION
"init=epsg:3857"
  END

Mike

----
Michael Smith
US Army Corps
Remote Sensing GIS/Center
michael.sm...@usace.army.mil

From:  mapserver-users <mapserver-users-boun...@lists.osgeo.org> on behalf
of Neelesh Nirmal <neelesh.ii...@gmail.com>
Date:  Tuesday, November 17, 2015 at 5:37 AM
To:  <mapserver-users@lists.osgeo.org>
Subject:  [mapserver-users] WMS Layer provided by MapSever rendering
incorrectly in ol3.

> I have created a map using OpenLayers3 which contains two layers. First layer
> is Open Street Map Layer and the second one is WMS layer provided by the Map
> Server.
> Problem-When i'm rendering first layer it is rendering properly no issue. but
> when i'm rendering the second layer(provide by map server) it renders
> incorrectly means it does not fit to its container and it is out of sync with
> the first layer in terms of location. See this snapshot
> <http://i.stack.imgur.com/Ac8xR.png>  of the maps for more clarification. In
> the snapshot top layer is wms layer provided by map server.
>  <http://i.stack.imgur.com/Ac8xR.png>
> 
> 
> 
> Also when i'm zooming or moving the map then both layers work correctly but
> after a delay of few seconds the second layer(wms layer from map server) again
> switches back to its initial position(Position that is shown in above attached
> snapshot).
> 
> 
> This is the code that i'm using to consume wms service.
> 
> var layer = new ol.layer.Image({
> source: new ol.source.ImageWMS({
>   url: 'http://localhost:19090/rasters/world/wms',
>   params: {
>'LAYERS': 'world',
>'mode': 'map',
>   },
>   serverType: 'mapserver'
>  })});
> 
> 
> This <http://pastebin.com/AWWWyBLE>  is my map file.
> 
>  MAP
>   NAME   "world"
>   CONFIG "MS_ERRORFILE"
> "/home/neelesh/Projects/georbis/data/logs/mapservice_errors.log"
>   CONFIG "PROJ_LIB"
> "/home/neelesh/Projects/georbis/deps/proj.4-master/share/proj"
>   CONFIG "ON_MISSING_DATA" "LOG"
>   DEBUG 5
>   EXTENT -180.000 -90.000 180.000 90.000
>   SHAPEPATH "/home/neelesh/Projects/georbis/data/service_data/data/wms"
>   IMAGECOLOR 255 255 255
>   SIZE 1350 675
> 
>   WEB
> METADATA
>   "wms_title" "Georbis WMS Server"
>   "wms_author" "VizExperts"
>   "wms_onlineresource" "http://192.168.1.36:19090/rasters/world/wms?;
>   "wms_enable_request" "*"
>   "wms_srs" "epsg:4326"
>   "wms_feature_info_mime_type" "text/html"
>   "wms_format" "image/jpg"
> END
>   END
> 
>   PROJECTION
> "init=epsg:4326"
>   END
> 
>   LAYER
> NAME world
> TYPE RASTER
> DATA "world.tif"
> METADATA
>   "wms_title" "BlueWorld Map"
>   "wms_srs" "epsg:4326"
>   "wms_server_version" "1.1.1"
> END
> PROJECTION
>   "init=epsg:4326"
> END
>   END
> END
> 
> I tried ol.view.fit method to fit the layer to its container but the value of
> layer.getExtent() for the layer is undefined.
> Also layers are rendering perfectly in QGIS and when i'm using the same layer
> from geoserver instead of mapserver again it is working fine.
> This 
> <http://stackoverflow.com/questions/33539777/wms-layer-provide-by-map-sever-re
> ndering-incorrectly-in-ol3>  is link to my stackoverflow post.
> Pleas help me to find out what is wrong. is there any problem with wms request
> format or the map file?
> ___ 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] Render PostGIS points as raster layer

[Michael Smith]

Would the simplest way be to just create a view and use that?

Michael Smith
Remote Sensing/GIS Center
US Army Corps of Engineers

> On Sep 16, 2015, at 8:36 AM, Adam Ryan <adamdr...@gmail.com> wrote:
> 
> I have over 100 million rows in a PG table with geom type Point, srid=4326.  
> The points represent timestamped centroids of raster cells.  The data comes 
> from sparse hourly 1km US grids; Only the cells with data, which is less than 
> 1%, but still a lot of points.  The PG table allows for a wealth of 
> spatial-temporal queries, but I want to render as a raster because it is 
> raster data after all.  Currently I use ST_Expand to approximate a grid cell 
> as a polygon:
> 
> LAYER
> ...
> TYPE POLYGON
> CONNECTIONTYPE POSTGIS 
> CONNECTION [host, port, etc...]
> DATA "geom FROM (SELECT id, ST_Expand( geom, 0.005 ) as geom from 
> [query]) as foo using unique id using srid=4326"
> ...
> 
> This works, sorta.  In my classifications I set the style COLOR and 
> OUTLINECOLOR the same, but the overlapping 'cell' outlines never look as good 
> as output from a raster.
> 
> So I want to use a mapserver layer type RASTER.  I can create a raster in PG 
> by using ST_AsRaster, but I can't see how to pass it to mapserver: 
> 
> LAYER
> ...
> TYPE RASTER
> DATA "PG:host=[host] port=5432 dbname=[dbname] where=' where?
> 
> The DATA (connection string) here takes a table name and a where but I really 
> need it to take an SQL string that returns the correct type.
> 
> Is there a way to do this?  Would a GDAL virtual raster be able to accomplish 
> this?  I've never worked with them.
> 
> Thanks for the all the progress over the years,
> Adam
> ___
> 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] CSV from Mapscript results

[Michael Smith]

Another option would be to use the csv ogr driver and set the outputformat

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


Mike


Michael Smith

US Army Corps
Remote Sensing GIS/Center
michael.sm...@usace.army.mil




-Original Message-
From: <mapserver-users-boun...@lists.osgeo.org> on behalf of Matej Mailing
<mail...@tam.si>
Date: Tuesday, September 8, 2015 at 8:03 PM
To: "Lime, Steve D (MNIT)" <steve.l...@state.mn.us>
Cc: "mapserver-users@lists.osgeo.org" <mapserver-users@lists.osgeo.org>
Subject: Re: [mapserver-users] CSV from Mapscript results

>Thanks, Steve.
>
>It looks I will choose the 2nd option as well. What I don't like with
>this "direct" approach though is not using already existing Mapfile
>with DATA, CONNECTION and everything set - basically it creates
>another point where this data needs to be set and changed for example
>when changing access rights, moving data to new server etc., it
>increases complexity.
>
>As far as I have checked, there is no for example getData() method to
>get the DATA variable, set in the Mapfile. (Perhaps the reason is that
>since there is no set, there is no get method as well :-))
>However, in this case this would be useful or perhaps I am just
>thinking in the wrong direction? :-)
>
>Thanks,
>Matej
>
>
>2015-09-08 18:07 GMT+02:00 Lime, Steve D (MNIT) <steve.l...@state.mn.us>:
>> You have two options:
>>
>>   1 - use query templates to render the result as CSV
>>   2 - use whatever tool your programming language gives you and just
>>loop through the results and dump to CSV
>>
>> Personally since you're using MapScript I'd opt for 2 for a couple of
>>reasons: you have total control that way and for larger result sets it's
>>likely to be more performant since the whole CSV file wouldn't need to
>>be constructed in memory like templates would.
>>
>> Steve
>>
>> -Original Message-
>> From: mapserver-users-boun...@lists.osgeo.org
>>[mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Matej
>>Mailing
>> Sent: Tuesday, September 08, 2015 5:30 AM
>> To: mapserver-users@lists.osgeo.org
>> Subject: [mapserver-users] CSV from Mapscript results
>>
>> Hi,
>>
>> what would be the best way to create a CSV from Mapscript query results?
>>
>> Thanks,
>> Matej
>> ___
>> 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 mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] Mapserver support on Sun Solaris sparc platform

[michael . smith . erdc]

Satpal,

I have compiled MapServer on Solaris Sparc. The main thing you'll need is the 
gcc compilers for Solaris Sparc. The other main issue with Solaris Sparc was 
getting some dependencies to compile. I had a lot of difficulty with libkml for 
GDAL as a component of MapServer and never did get that component to build. So 
as long as your dependency needs are modest, you definitely can compile and use 
MapServer on Solaris Sparc. But not very many people use Sparc so getting help 
when there is a problem is difficult. 

Michael Smith
Remote Sensing/GIS Center
US Army Corps of Engineers

 On Aug 10, 2015, at 5:56 AM, satpal bhandari satpal82bhand...@gmail.com 
 wrote:
 
 Hi All,
 
  
 
 We are planning to use “mapserver” on Sun Solaris sparc (Solaris version 10 
 and 11).
 
 As per Mapserver web page (http://mapserver.org/), it is support on all major 
 platform (Windows, Linux, Mac OS X).
 
 But did mentions Sun Solaris sparc platform.
 
  
 
 If mapserver is supported on Sun Solaris sparc platform, Please share the 
 steps for installing the mapserver on Sun Solaris sparc platform.
 
  
 
 Thanks and regards
 
 Satpal
 
 +919582398818
 
 
 ___
 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] [EXTERNAL] Re: ogc:PropertyIsEqualTo behaves like PropertyIsLike with oracle

[michael . smith . erdc]

  That's correct for postgis (I think) but not oracle. Unless you are only seeing the log for the postgis instance. From: steve.tout...@inspq.qc.caSent: Wednesday, July 22, 2015 1:59 PMTo: Michael SmithCc: mapserver-users@lists.osgeo.orgSubject: Re: [EXTERNAL] Re: [mapserver-users] ogc:PropertyIsEqualTo behaves like PropertyIsLike with oracleGood idea we use POST, but I tried using
GET and I still get FLTLayerApplyPlainFilterToLayer(): ("[NOM_STAT]"
=*"Anto") in the log (with postgis and oracle)






Michael
Smith michael.smith.e...@gmail.com 
2015-07-22 12:02




A
"steve.tout...@inspq.qc.ca"
steve.tout...@inspq.qc.ca


cc



Objet
Re:
[EXTERNAL] Re: [mapserver-users] ogc:PropertyIsEqualTo behaves like PropertyIsLike
with oracle










Only other thing I can think of are you doing a GET or
POST? I'm doing GET. 

Michael Smith
Remote Sensing/GIS Center
US Army Corps of Engineers

On Jul 22, 2015, at 11:42 AM, steve.tout...@inspq.qc.ca
wrote:

12C 





Michael
Smith michael.smith.e...@gmail.com

2015-07-22 11:36






A
"steve.tout...@inspq.qc.ca"
steve.tout...@inspq.qc.ca



cc
"mapserver-users@lists.osgeo.org"
mapserver-users@lists.osgeo.org



Objet
Re:
[EXTERNAL] Re: [mapserver-users] ogc:PropertyIsEqualTo behaves like PropertyIsLike
with oracle












What version of Oracle? Not that we have any version dependencies in the
regexp code. 

I'm running 11.2 and 12.1. 

Michael Smith 
Remote Sensing/GIS Center 
US Army Corps of Engineers 

On Jul 22, 2015, at 11:30 AM, steve.tout...@inspq.qc.ca
wrote:

oracle and postgis are on 2 differents servers physically on 2 cities,
both has a mapserver installation made by 2 different person. One is on
debian, and other on fedora 
There are using ms7 since other new wfs improvement made in MS7 are used...






Michael
Smith michael.smith.e...@gmail.com

2015-07-22 11:22






A
"steve.tout...@inspq.qc.ca"
steve.tout...@inspq.qc.ca



cc
"mapserver-users@lists.osgeo.org"
mapserver-users@lists.osgeo.org



Objet
Re:
[EXTERNAL] Re: [mapserver-users] ogc:PropertyIsEqualTo behaves like PropertyIsLike
with oracle














Could you be hitting an old installed version?

Michael Smith 
Remote Sensing/GIS Center 
US Army Corps of Engineers 

On Jul 22, 2015, at 11:14 AM, steve.tout...@inspq.qc.ca
wrote:

We are on linux as well. 
Ms7+ postgis.. it doesn't translate the query to regex, I have the same
query than with Oracle... ("[NOM_STAT]" =*"Anto")



Well...I'm more confused now...It doesn't make sens that our MS doesn't
generate the same request... 
Can it be an installation problem, an option is missing when compiling?





Michael
Smith michael.smith.e...@gmail.com

2015-07-22 09:55






A
"steve.tout...@inspq.qc.ca"
steve.tout...@inspq.qc.ca



cc
"mapserver-users@lists.osgeo.org"
mapserver-users@lists.osgeo.org



Objet
Re:
[EXTERNAL] Re: [mapserver-users] ogc:PropertyIsEqualTo behaves like PropertyIsLike
with oracle
















Just tried with latest master (sha f13cd8825e117b09663bb325a03854c27e9cdd39)
and got correct REGEXP_LIKE sql. Was using rel-7-0-0-beta1 before. Both
same. 

I'm running on Linux although can't see how that would change the sql being
generated. 

 
Michael Smith 
US Army Corps 
Remote Sensing GIS/Center 
michael.sm...@usace.army.mil



From: mapserver-users-boun...@lists.osgeo.org
on behalf of "steve.tout...@inspq.qc.ca"
steve.tout...@inspq.qc.ca
Date: Wednesday, July 22, 2015 at 9:44 AM
To: "steve.tout...@inspq.qc.ca"
steve.tout...@inspq.qc.ca
Cc: "mapserver-users@lists.osgeo.org"
mapserver-users@lists.osgeo.org,
"mapserver-users-boun...@lists.osgeo.org"
mapserver-users-boun...@lists.osgeo.org
Subject: [EXTERNAL] Re: [mapserver-users] ogc:PropertyIsEqualTo behaves
like PropertyIsLike with oracle
Resent-From: Michael Smith michael.sm...@usace.army.mil


using MapServer version
7.0.0-beta1 



steve.tout...@inspq.qc.ca@lists.osgeo.org
Envoyé par : mapserver-users-boun...@lists.osgeo.org

2015-07-22 09:43






A
Michael
Smith michael.smith.e...@gmail.com



cc
mapserver-users@lists.osgeo.org



Objet
Re:
[mapserver-users] ogc:PropertyIsEqualTo behaves like PropertyIsLike with
oracle


















CONNECTIONTYPE oraclespatial
DATA "GEOM_POIN fr

Re: [mapserver-users] [EXTERNAL] Re: ogc:PropertyIsEqualTo behaves like PropertyIsLike with oracle

[Michael Smith]

Could you be hitting an old installed version?

Michael Smith
Remote Sensing/GIS Center
US Army Corps of Engineers

 On Jul 22, 2015, at 11:14 AM, steve.tout...@inspq.qc.ca wrote:
 
 We are on linux as well. 
 Ms7+ postgis.. it doesn't translate the query to regex, I have the same query 
 than with Oracle... ([NOM_STAT] =*Anto) 
 
 
 Well...I'm more confused now...It doesn't make sens that our MS doesn't 
 generate the same request... 
 Can it be an installation problem, an option is missing when compiling? 
 
 
 
 Michael Smith michael.smith.e...@gmail.com  
 2015-07-22 09:55
 
 A
 steve.tout...@inspq.qc.ca steve.tout...@inspq.qc.ca
 cc
 mapserver-users@lists.osgeo.org mapserver-users@lists.osgeo.org
 Objet
 Re: [EXTERNAL] Re: [mapserver-users] ogc:PropertyIsEqualTo behaves like 
 PropertyIsLike with oracle
 
 
 
 
 
 
 
 Just tried with latest master (sha f13cd8825e117b09663bb325a03854c27e9cdd39) 
 and got correct REGEXP_LIKE sql. Was using rel-7-0-0-beta1 before. Both same. 
 
 I'm running on Linux although can't see how that would change the sql being 
 generated. 
 
  
 Michael Smith 
 US Army Corps 
 Remote Sensing GIS/Center 
 michael.sm...@usace.army.mil 
 
 
 From: mapserver-users-boun...@lists.osgeo.org on behalf of 
 steve.tout...@inspq.qc.ca steve.tout...@inspq.qc.ca
 Date: Wednesday, July 22, 2015 at 9:44 AM
 To: steve.tout...@inspq.qc.ca steve.tout...@inspq.qc.ca
 Cc: mapserver-users@lists.osgeo.org mapserver-users@lists.osgeo.org, 
 mapserver-users-boun...@lists.osgeo.org 
 mapserver-users-boun...@lists.osgeo.org
 Subject: [EXTERNAL] Re: [mapserver-users] ogc:PropertyIsEqualTo behaves like 
 PropertyIsLike with oracle
 Resent-From: Michael Smith michael.sm...@usace.army.mil 
 
 using MapServer version 7.0.0-beta1
 
 
 
 steve.tout...@inspq.qc.ca@lists.osgeo.org
 Envoyé par : mapserver-users-boun...@lists.osgeo.org
 2015-07-22 09:43
 
 
 A
 Michael Smith michael.smith.e...@gmail.com
 cc
 mapserver-users@lists.osgeo.org
 Objet
 Re: [mapserver-users] ogc:PropertyIsEqualTo behaves like PropertyIsLike with 
 oracle
 
 
 
 
 
 
 
 
 
 CONNECTIONTYPE oraclespatial
 DATA GEOM_POIN from (select * FROM SMDVDP_STAT_METE WHERE EXTRACT(YEAR FROM 
 D_DEB) = 2015) USING SRID 4326
 
 
 Michael Smith michael.smith.e...@gmail.com
 2015-07-22 09:38
 
 
 A
 steve.tout...@inspq.qc.ca
 cc
 mapserver-users@lists.osgeo.org
 Objet
 Re: [mapserver-users] ogc:PropertyIsEqualTo behaves like PropertyIsLike with 
 oracle
 
 
 
 
 
 
 
 
 
 
 
 Same result with 1.1.0 
 
 Are you using an CONNECTIONTYPE oraclespatial or a CONNECTIONTYPE OGR to 
 Oracle?
 
 Mike 
 
  
 Michael Smith 
 US Army Corps 
 Remote Sensing GIS/Center 
 michael.sm...@usace.army.mil 
 
 
 
 From: steve.tout...@inspq.qc.ca
 Date: Wednesday, July 22, 2015 at 9:34 AM
 To: Michael Smith michael.smith.e...@gmail.com
 Cc: mapserver-users@lists.osgeo.org
 Subject: Re: [mapserver-users] ogc:PropertyIsEqualTo behaves like 
 PropertyIsLike with oracle
 
 Michael we are using MS7 master and WFS 1.1.0
 Can you try with this wfs version instead of 2.0 t osee if you get the same 
 results?
 Michael Smith michael.smith.e...@gmail.com
 2015-07-22 09:32
 
 
 A
 steve.tout...@inspq.qc.ca
 cc
 mapserver-users@lists.osgeo.org
 Objet
 Re: [mapserver-users] ogc:PropertyIsEqualTo behaves like PropertyIsLike with 
 oracle
 
 
 
 
 
 
 
 
 
 
 
 
 
 When I do this on my system I get
 
 request: 
 service=WFSversion=2.0.0request=GetFeaturetypeNames=gridws_pointcloudFilter=FilterPropertyIsEqualto%20MatchCase=FALSEPropertyNameFILE_NAME/PropertyNameLiteraltest2.las/Literal/PropertyIsEqualTo/Filter
 
 [Wed Jul 22 09:26:31 2015].885667 got a IEQ comparison
 [Wed Jul 22 09:26:31 2015].885676 closing RE comparison
 [Wed Jul 22 09:26:31 2015].885681 msOracleSpatialLayerWhichShapes was called.
 [Wed Jul 22 09:26:31 2015].885704 msOracleSpatialLayerWhichShapes. Using this 
 Sql to retrieve the data: SELECT COLLECT_ID, COLLECTION, FILE_NAME, 
 DATE_LOADED, PC_ID, X, Y, FILE_SIZE_MB, COLLECTDATE, DOWNLOAD_URL, 
 SENSOR_NAME, rownum, geom WHERE  ( REGEXP_LIKE( FILE_NAME, 'test2.las','i'  ) 
 )  AND SDO_FILTER( geom, MDSYS.SDO_GEOMETRY(2003, :srid, 
 NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),:ordinates ),'querytype=window') = 
 'TRUE'
 
 This shows that its translating the PropertyIsEqualTo with MatchCase false to 
 a regexp_like case insensitive query with no wildcards. Not sure why you 
 wouldn't get the same thing.
 
 Mike
 
 
 Michael Smith
 US Army Corps
 Remote Sensing GIS/Center
 michael.sm...@usace.army.mil
 
 
 From: steve.tout...@inspq.qc.ca
 Date: Wednesday, July 22, 2015 at 9:13 AM
 To: Michael Smith michael.smith.e...@gmail.com
 Cc: mapserver-users@lists.osgeo.org
 Subject: Re: [mapserver-users] ogc:PropertyIsEqualTo behaves like 
 PropertyIsLike with oracle
 
 Thanks for your help, here is the log
 Steve
 ul 22 08:14:09 2015].892715 msOracleSpatialLayerWhichShapes. Bind values: 
 srid:4326 minx:-91.320741 miny:41.948470 maxx:-45.679259 maxy:63.664769
 [Wed Jul 22

Re: [mapserver-users] [EXTERNAL] Re: ogc:PropertyIsEqualTo behaves like PropertyIsLike with oracle

[Michael Smith]

What version of Oracle? Not that we have any version dependencies in the regexp 
code. 

I'm running 11.2 and 12.1. 

Michael Smith
Remote Sensing/GIS Center
US Army Corps of Engineers

 On Jul 22, 2015, at 11:30 AM, steve.tout...@inspq.qc.ca wrote:
 
 oracle and postgis are on 2 differents servers physically on 2 cities, both 
 has a mapserver installation made by 2 different person. One is on debian, 
 and other on fedora 
 There are using ms7 since other new wfs improvement made in MS7 are used...
 
 
 
 Michael Smith michael.smith.e...@gmail.com  
 2015-07-22 11:22
 
 A
 steve.tout...@inspq.qc.ca steve.tout...@inspq.qc.ca
 cc
 mapserver-users@lists.osgeo.org mapserver-users@lists.osgeo.org
 Objet
 Re: [EXTERNAL] Re: [mapserver-users] ogc:PropertyIsEqualTo behaves like 
 PropertyIsLike with oracle
 
 
 
 
 
 
 
 Could you be hitting an old installed version?
 
 Michael Smith 
 Remote Sensing/GIS Center 
 US Army Corps of Engineers 
 
 On Jul 22, 2015, at 11:14 AM, steve.tout...@inspq.qc.ca wrote:
 
 We are on linux as well. 
 Ms7+ postgis.. it doesn't translate the query to regex, I have the same query 
 than with Oracle... ([NOM_STAT] =*Anto) 
 
 
 Well...I'm more confused now...It doesn't make sens that our MS doesn't 
 generate the same request... 
 Can it be an installation problem, an option is missing when compiling?
 
 
 
 Michael Smith michael.smith.e...@gmail.com
 2015-07-22 09:55
 
 
 A
 steve.tout...@inspq.qc.ca steve.tout...@inspq.qc.ca
 cc
 mapserver-users@lists.osgeo.org mapserver-users@lists.osgeo.org
 Objet
 Re: [EXTERNAL] Re: [mapserver-users] ogc:PropertyIsEqualTo behaves like 
 PropertyIsLike with oracle
 
 
 
 
 
 
 
 
 
 Just tried with latest master (sha f13cd8825e117b09663bb325a03854c27e9cdd39) 
 and got correct REGEXP_LIKE sql. Was using rel-7-0-0-beta1 before. Both same. 
 
 I'm running on Linux although can't see how that would change the sql being 
 generated. 
 
  
 Michael Smith 
 US Army Corps 
 Remote Sensing GIS/Center 
 michael.sm...@usace.army.mil 
 
 
 From: mapserver-users-boun...@lists.osgeo.org on behalf of 
 steve.tout...@inspq.qc.ca steve.tout...@inspq.qc.ca
 Date: Wednesday, July 22, 2015 at 9:44 AM
 To: steve.tout...@inspq.qc.ca steve.tout...@inspq.qc.ca
 Cc: mapserver-users@lists.osgeo.org mapserver-users@lists.osgeo.org, 
 mapserver-users-boun...@lists.osgeo.org 
 mapserver-users-boun...@lists.osgeo.org
 Subject: [EXTERNAL] Re: [mapserver-users] ogc:PropertyIsEqualTo behaves like 
 PropertyIsLike with oracle
 Resent-From: Michael Smith michael.sm...@usace.army.mil 
 
 using MapServer version 7.0.0-beta1
 
 
 steve.tout...@inspq.qc.ca@lists.osgeo.org
 Envoyé par : mapserver-users-boun...@lists.osgeo.org
 2015-07-22 09:43
 
 
 A
 Michael Smith michael.smith.e...@gmail.com
 cc
 mapserver-users@lists.osgeo.org
 Objet
 Re: [mapserver-users] ogc:PropertyIsEqualTo behaves like PropertyIsLike with 
 oracle
 
 
 
 
 
 
 
 
 
 
 
 CONNECTIONTYPE oraclespatial
 DATA GEOM_POIN from (select * FROM SMDVDP_STAT_METE WHERE EXTRACT(YEAR FROM 
 D_DEB) = 2015) USING SRID 4326
 Michael Smith michael.smith.e...@gmail.com
 2015-07-22 09:38
 
 
 A
 steve.tout...@inspq.qc.ca
 cc
 mapserver-users@lists.osgeo.org
 Objet
 Re: [mapserver-users] ogc:PropertyIsEqualTo behaves like PropertyIsLike with 
 oracle
 
 
 
 
 
 
 
 
 
 
 
 
 
 Same result with 1.1.0 
 
 Are you using an CONNECTIONTYPE oraclespatial or a CONNECTIONTYPE OGR to 
 Oracle?
 
 Mike 
 
  
 Michael Smith 
 US Army Corps 
 Remote Sensing GIS/Center 
 michael.sm...@usace.army.mil 
 
 
 
 From: steve.tout...@inspq.qc.ca
 Date: Wednesday, July 22, 2015 at 9:34 AM
 To: Michael Smith michael.smith.e...@gmail.com
 Cc: mapserver-users@lists.osgeo.org
 Subject: Re: [mapserver-users] ogc:PropertyIsEqualTo behaves like 
 PropertyIsLike with oracle
 
 Michael we are using MS7 master and WFS 1.1.0
 Can you try with this wfs version instead of 2.0 t osee if you get the same 
 results?
 Michael Smith michael.smith.e...@gmail.com
 2015-07-22 09:32
 
 
 A
 steve.tout...@inspq.qc.ca
 cc
 mapserver-users@lists.osgeo.org
 Objet
 Re: [mapserver-users] ogc:PropertyIsEqualTo behaves like PropertyIsLike with 
 oracle
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 When I do this on my system I get
 
 request: 
 service=WFSversion=2.0.0request=GetFeaturetypeNames=gridws_pointcloudFilter=FilterPropertyIsEqualto%20MatchCase=FALSEPropertyNameFILE_NAME/PropertyNameLiteraltest2.las/Literal/PropertyIsEqualTo/Filter
 
 [Wed Jul 22 09:26:31 2015].885667 got a IEQ comparison
 [Wed Jul 22 09:26:31 2015].885676 closing RE comparison
 [Wed Jul 22 09:26:31 2015].885681 msOracleSpatialLayerWhichShapes was called.
 [Wed Jul 22 09:26:31 2015].885704 msOracleSpatialLayerWhichShapes. Using this 
 Sql to retrieve the data: SELECT COLLECT_ID, COLLECTION, FILE_NAME, 
 DATE_LOADED, PC_ID, X, Y, FILE_SIZE_MB, COLLECTDATE, DOWNLOAD_URL, 
 SENSOR_NAME, rownum, geom WHERE  ( REGEXP_LIKE( FILE_NAME, 'test2.las','i'  ) 
 )  AND SDO_FILTER( geom, MDSYS.SDO_GEOMETRY(2003, :srid

Re: [mapserver-users] [EXTERNAL] Re: ogc:PropertyIsEqualTo behaves like PropertyIsLike with oracle

[Michael Smith]

I don't get the FLTLayerApplyPlainFilterToLayer line.


Michael Smith
US Army Corps
Remote Sensing GIS/Center
michael.sm...@usace.army.mil



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

Re: [mapserver-users] ogc:PropertyIsEqualTo behaves like PropertyIsLike with oracle

[Michael Smith]

When I do this on my system I get

request: 
service=WFSversion=2.0.0request=GetFeaturetypeNames=gridws_pointcloudFil
ter=FilterPropertyIsEqualto%20MatchCase=FALSEPropertyNameFILE_NAME/
PropertyNameLiteraltest2.las/Literal/PropertyIsEqualTo/Filter

[Wed Jul 22 09:26:31 2015].885667 got a IEQ comparison
[Wed Jul 22 09:26:31 2015].885676 closing RE comparison
[Wed Jul 22 09:26:31 2015].885681 msOracleSpatialLayerWhichShapes was
called.
[Wed Jul 22 09:26:31 2015].885704 msOracleSpatialLayerWhichShapes. Using
this Sql to retrieve the data: SELECT COLLECT_ID, COLLECTION, FILE_NAME,
DATE_LOADED, PC_ID, X, Y, FILE_SIZE_MB, COLLECTDATE, DOWNLOAD_URL,
SENSOR_NAME, rownum, geom WHERE  ( REGEXP_LIKE( FILE_NAME, 'test2.las','i'
) )  AND SDO_FILTER( geom, MDSYS.SDO_GEOMETRY(2003, :srid,
NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),:ordinates ),'querytype=window') =
'TRUE'

This shows that its translating the PropertyIsEqualTo with MatchCase false
to a regexp_like case insensitive query with no wildcards. Not sure why you
wouldn't get the same thing.

Mike


Michael Smith
US Army Corps
Remote Sensing GIS/Center
michael.sm...@usace.army.mil


From:  steve.tout...@inspq.qc.ca
Date:  Wednesday, July 22, 2015 at 9:13 AM
To:  Michael Smith michael.smith.e...@gmail.com
Cc:  mapserver-users@lists.osgeo.org
Subject:  Re: [mapserver-users] ogc:PropertyIsEqualTo behaves like
PropertyIsLike with oracle

 Thanks for your help, here is the log
 Steve
  ul 22 08:14:09 2015].892715 msOracleSpatialLayerWhichShapes. Bind values:
 srid:4326 minx:-91.320741 miny:41.948470 maxx:-45.679259 maxy:63.664769
 [Wed Jul 22 08:14:09 2015].894113 msOracleSpatialLayerWhichShapes bind by name
 and object.
 [Wed Jul 22 08:14:09 2015].894134 msOracleSpatialLayerWhichShapes name and
 object now bound.
 [Wed Jul 22 08:14:10 2015].77889 mapserv request processing time (msLoadMap
 not incl.): 0.203s
 [Wed Jul 22 08:14:10 2015].77903 msOracleSpatialLayerClose was called. Layer:
 0x1308650, Layer name: SMDVDP_STAT_METE
 [Wed Jul 22 08:14:10 2015].78084
 msConnPoolRelease(SMDVDP_STAT_METE,USER/*@DATABASE:1521/DEV.fadq.q
 c,0x1481850)
 [Wed Jul 22 08:14:30 2015].200042 CGI Request 38 on process 14430
 [Wed Jul 22 08:14:30 2015].200197 msOracleSpatialLayerOpen called with:
 GEOM_POIN from (select * FROM SMDVDP_STAT_METE WHERE EXTRACT(YEAR FROM D_DEB)
 = 2015) USING SRID 4326 (Layer pointer 0x142bbe0)
 [Wed Jul 22 08:14:30 2015].200215
 msConnPoolRequest(SMDVDP_STAT_METE,USER/*@DATABASE:1521/DEV.fadq.q
 c) - got 0x1481850
 [Wed Jul 22 08:14:30 2015].208656 msOracleSpatialLayerFreeItemInfo was called.
 [Wed Jul 22 08:14:30 2015].208676 msOracleSpatialLayerGetItems was called.
 [Wed Jul 22 08:14:30 2015].209323 msOracleSpatialLayerInitItemInfo was called.
 [Wed Jul 22 08:14:30 2015].209369 msOracleSpatialLayerFreeItemInfo was called.
 [Wed Jul 22 08:14:30 2015].209374 msOracleSpatialLayerClose was called. Layer:
 0x142bbe0, Layer name: SMDVDP_STAT_METE
 [Wed Jul 22 08:14:30 2015].209396
 msConnPoolRelease(SMDVDP_STAT_METE,USER/*@DATABASE:1521/DEV.fadq.q
 c,0x1481850)
 [Wed Jul 22 08:14:30 2015].210875 msOracleSpatialLayerOpen called with:
 GEOM_POIN from (select * FROM SMDVDP_STAT_METE WHERE EXTRACT(YEAR FROM D_DEB)
 = 2015) USING SRID 4326 (Layer pointer 0x142bbe0)
 [Wed Jul 22 08:14:30 2015].210889
 msConnPoolRequest(SMDVDP_STAT_METE,USER/*@DATABASE:1521/DEV.fadq.q
 c) - got 0x1481850
 [Wed Jul 22 08:14:30 2015].218325 msOracleSpatialLayerOpen called with:
 GEOM_POIN from (select * FROM SMDVDP_STAT_METE WHERE EXTRACT(YEAR FROM D_DEB)
 = 2015) USING SRID 4326 (Layer pointer 0x142bbe0)
 [Wed Jul 22 08:14:30 2015].218345 msOracleSpatialLayerFreeItemInfo was called.
 [Wed Jul 22 08:14:30 2015].218354 msOracleSpatialLayerGetItems was called.
 [Wed Jul 22 08:14:30 2015].218946 msOracleSpatialLayerInitItemInfo was called.
 [Wed Jul 22 08:14:30 2015].218980 msOracleSpatialLayerFreeItemInfo was called.
 [Wed Jul 22 08:14:30 2015].218985 msOracleSpatialLayerClose was called. Layer:
 0x142bbe0, Layer name: SMDVDP_STAT_METE
 [Wed Jul 22 08:14:30 2015].219003
 msConnPoolRelease(SMDVDP_STAT_METE,USER/*@DATABASE:1521/DEV.fadq.q
 c,0x1481850)
 [Wed Jul 22 08:14:30 2015].219010 msOracleSpatialLayerOpen called with:
 GEOM_POIN from (select * FROM SMDVDP_STAT_METE WHERE EXTRACT(YEAR FROM D_DEB)
 = 2015) USING SRID 4326 (Layer pointer 0x142bbe0)
 [Wed Jul 22 08:14:30 2015].219018
 msConnPoolRequest(SMDVDP_STAT_METE,USER/*@DATABASE:1521/DEV.fadq.q
 c) - got 0x1481850
 [Wed Jul 22 08:14:30 2015].225298 msOracleSpatialLayerEnablePaging was called.
 [Wed Jul 22 08:14:30 2015].225318 msOracleSpatialLayerFreeItemInfo was called.
 [Wed Jul 22 08:14:30 2015].225328 msOracleSpatialLayerFreeItemInfo was called.
 [Wed Jul 22 08:14:30 2015].225334 msOracleSpatialLayerGetItems was called.
 [Wed Jul 22 08:14:30 2015].225868 msOracleSpatialLayerInitItemInfo was called.
 [Wed Jul 22 08:14:30 2015].225892

Re: [mapserver-users] ogc:PropertyIsEqualTo behaves like PropertyIsLike with oracle

[Michael Smith]

Same result with 1.1.0

Are you using an CONNECTIONTYPE oraclespatial or a CONNECTIONTYPE OGR to
Oracle?

Mike


Michael Smith
US Army Corps
Remote Sensing GIS/Center
michael.sm...@usace.army.mil



From:  steve.tout...@inspq.qc.ca
Date:  Wednesday, July 22, 2015 at 9:34 AM
To:  Michael Smith michael.smith.e...@gmail.com
Cc:  mapserver-users@lists.osgeo.org
Subject:  Re: [mapserver-users] ogc:PropertyIsEqualTo behaves like
PropertyIsLike with oracle

 Michael we are using MS7 master and WFS 1.1.0
 Can you try with this wfs version instead of 2.0 t osee if you get the same
 results?
 
 
 
 
 Michael Smith michael.smith.e...@gmail.com 2015-07-22 09:32
 A
 steve.tout...@inspq.qc.ca
 cc
 mapserver-users@lists.osgeo.org
 Objet
 Re: [mapserver-users] ogc:PropertyIsEqualTo behaves like PropertyIsLike with
 oracle
 
 
 
 
 
 
 When I do this on my system I get
 
 request: 
 service=WFSversion=2.0.0request=GetFeaturetypeNames=gridws_pointcloudFilte
 r=FilterPropertyIsEqualto%20MatchCase=FALSEPropertyNameFILE_NAME/Prop
 ertyNameLiteraltest2.las/Literal/PropertyIsEqualTo/Filter
 
 [Wed Jul 22 09:26:31 2015].885667 got a IEQ comparison
 [Wed Jul 22 09:26:31 2015].885676 closing RE comparison
 [Wed Jul 22 09:26:31 2015].885681 msOracleSpatialLayerWhichShapes was called.
 [Wed Jul 22 09:26:31 2015].885704 msOracleSpatialLayerWhichShapes. Using this
 Sql to retrieve the data: SELECT COLLECT_ID, COLLECTION, FILE_NAME,
 DATE_LOADED, PC_ID, X, Y, FILE_SIZE_MB, COLLECTDATE, DOWNLOAD_URL,
 SENSOR_NAME, rownum, geom WHERE  ( REGEXP_LIKE( FILE_NAME, 'test2.las','i'  )
 )  AND SDO_FILTER( geom, MDSYS.SDO_GEOMETRY(2003, :srid,
 NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),:ordinates ),'querytype=window') =
 'TRUE'
 
 This shows that its translating the PropertyIsEqualTo with MatchCase false to
 a regexp_like case insensitive query with no wildcards. Not sure why you
 wouldn't get the same thing.
 
 Mike
 
 
 Michael Smith
 US Army Corps
 Remote Sensing GIS/Center
 michael.sm...@usace.army.mil
 
 
 From: steve.tout...@inspq.qc.ca mailto:steve.tout...@inspq.qc.ca 
 Date: Wednesday, July 22, 2015 at 9:13 AM
 To: Michael Smith michael.smith.e...@gmail.com
 mailto:michael.smith.e...@gmail.com 
 Cc: mapserver-users@lists.osgeo.org mailto:mapserver-users@lists.osgeo.org
 
 Subject: Re: [mapserver-users] ogc:PropertyIsEqualTo behaves like
 PropertyIsLike with oracle
 
 Thanks for your help, here is the log
 Steve
  ul 22 08:14:09 2015].892715 msOracleSpatialLayerWhichShapes. Bind values:
 srid:4326 minx:-91.320741 miny:41.948470 maxx:-45.679259 maxy:63.664769
 [Wed Jul 22 08:14:09 2015].894113 msOracleSpatialLayerWhichShapes bind by name
 and object.
 [Wed Jul 22 08:14:09 2015].894134 msOracleSpatialLayerWhichShapes name and
 object now bound.
 [Wed Jul 22 08:14:10 2015].77889 mapserv request processing time (msLoadMap
 not incl.): 0.203s
 [Wed Jul 22 08:14:10 2015].77903 msOracleSpatialLayerClose was called. Layer:
 0x1308650, Layer name: SMDVDP_STAT_METE
 [Wed Jul 22 08:14:10 2015].78084
 msConnPoolRelease(SMDVDP_STAT_METE,USER/*@DATABASE:1521/DEV.fadq.q
 c,0x1481850)
 [Wed Jul 22 08:14:30 2015].200042 CGI Request 38 on process 14430
 [Wed Jul 22 08:14:30 2015].200197 msOracleSpatialLayerOpen called with:
 GEOM_POIN from (select * FROM SMDVDP_STAT_METE WHERE EXTRACT(YEAR FROM D_DEB)
 = 2015) USING SRID 4326 (Layer pointer 0x142bbe0)
 [Wed Jul 22 08:14:30 2015].200215
 msConnPoolRequest(SMDVDP_STAT_METE,USER/*@DATABASE:1521/DEV.fadq.q
 c) - got 0x1481850
 [Wed Jul 22 08:14:30 2015].208656 msOracleSpatialLayerFreeItemInfo was called.
 [Wed Jul 22 08:14:30 2015].208676 msOracleSpatialLayerGetItems was called.
 [Wed Jul 22 08:14:30 2015].209323 msOracleSpatialLayerInitItemInfo was called.
 [Wed Jul 22 08:14:30 2015].209369 msOracleSpatialLayerFreeItemInfo was called.
 [Wed Jul 22 08:14:30 2015].209374 msOracleSpatialLayerClose was called. Layer:
 0x142bbe0, Layer name: SMDVDP_STAT_METE
 [Wed Jul 22 08:14:30 2015].209396
 msConnPoolRelease(SMDVDP_STAT_METE,USER/*@DATABASE:1521/DEV.fadq.q
 c,0x1481850)
 [Wed Jul 22 08:14:30 2015].210875 msOracleSpatialLayerOpen called with:
 GEOM_POIN from (select * FROM SMDVDP_STAT_METE WHERE EXTRACT(YEAR FROM D_DEB)
 = 2015) USING SRID 4326 (Layer pointer 0x142bbe0)
 [Wed Jul 22 08:14:30 2015].210889
 msConnPoolRequest(SMDVDP_STAT_METE,USER/*@DATABASE:1521/DEV.fadq.q
 c) - got 0x1481850
 [Wed Jul 22 08:14:30 2015].218325 msOracleSpatialLayerOpen called with:
 GEOM_POIN from (select * FROM SMDVDP_STAT_METE WHERE EXTRACT(YEAR FROM D_DEB)
 = 2015) USING SRID 4326 (Layer pointer 0x142bbe0)
 [Wed Jul 22 08:14:30 2015].218345 msOracleSpatialLayerFreeItemInfo was called.
 [Wed Jul 22 08:14:30 2015].218354 msOracleSpatialLayerGetItems was called.
 [Wed Jul 22 08:14:30 2015].218946 msOracleSpatialLayerInitItemInfo was called.
 [Wed Jul 22 08:14:30 2015].218980 msOracleSpatialLayerFreeItemInfo was called.
 [Wed Jul 22 08:14:30 2015].218985

Re: [mapserver-users] [EXTERNAL] Re: ogc:PropertyIsEqualTo behaves like PropertyIsLike with oracle

[Michael Smith]

Just tried with latest master (sha f13cd8825e117b09663bb325a03854c27e9cdd39)
and got correct REGEXP_LIKE sql. Was using rel-7-0-0-beta1 before. Both
same.

I'm running on Linux although can't see how that would change the sql being
generated.


Michael Smith
US Army Corps
Remote Sensing GIS/Center
michael.sm...@usace.army.mil


From:  mapserver-users-boun...@lists.osgeo.org on behalf of
steve.tout...@inspq.qc.ca steve.tout...@inspq.qc.ca
Date:  Wednesday, July 22, 2015 at 9:44 AM
To:  steve.tout...@inspq.qc.ca steve.tout...@inspq.qc.ca
Cc:  mapserver-users@lists.osgeo.org mapserver-users@lists.osgeo.org,
mapserver-users-boun...@lists.osgeo.org
mapserver-users-boun...@lists.osgeo.org
Subject:  [EXTERNAL] Re: [mapserver-users] ogc:PropertyIsEqualTo behaves
like PropertyIsLike with oracle
Resent-From:  Michael Smith michael.sm...@usace.army.mil

 using MapServer version 7.0.0-beta1
 
 
 
 
 steve.tout...@inspq.qc.ca@lists.osgeo.org
 Envoyé par : mapserver-users-bounces@lists.osgeo.org2015-07-22 09:43
 A
 Michael Smith michael.smith.e...@gmail.com
 cc
 mapserver-users@lists.osgeo.org
 Objet
 Re: [mapserver-users] ogc:PropertyIsEqualTo behaves like PropertyIsLike with
 oracle
 
 
 
 
 
 
 CONNECTIONTYPE oraclespatial
 DATA GEOM_POIN from (select * FROM SMDVDP_STAT_METE WHERE EXTRACT(YEAR FROM
 D_DEB) = 2015) USING SRID 4326
 
 
 
 Michael Smith michael.smith.e...@gmail.com2015-07-22 09:38
 A
 steve.tout...@inspq.qc.ca
 cc
 mapserver-users@lists.osgeo.org
 Objet
 Re: [mapserver-users] ogc:PropertyIsEqualTo behaves like PropertyIsLike with
 oracle
 
 
 
 
 
 
 
 
 Same result with 1.1.0
 
 Are you using an CONNECTIONTYPE oraclespatial or a CONNECTIONTYPE OGR to
 Oracle?
 
 Mike 
 
  
 Michael Smith 
 US Army Corps 
 Remote Sensing GIS/Center
 michael.sm...@usace.army.mil
 
 
 
 From: steve.tout...@inspq.qc.ca mailto:steve.tout...@inspq.qc.ca 
 Date: Wednesday, July 22, 2015 at 9:34 AM
 To: Michael Smith michael.smith.e...@gmail.com
 mailto:michael.smith.e...@gmail.com 
 Cc: mapserver-users@lists.osgeo.org mailto:mapserver-users@lists.osgeo.org
 
 Subject: Re: [mapserver-users] ogc:PropertyIsEqualTo behaves like
 PropertyIsLike with oracle
 
 Michael we are using MS7 master and WFS 1.1.0
 Can you try with this wfs version instead of 2.0 t osee if you get the same
 results?
 
 
 Michael Smith michael.smith.e...@gmail.com
 mailto:michael.smith.e...@gmail.com 2015-07-22 09:32
 A
 steve.tout...@inspq.qc.ca mailto:steve.tout...@inspq.qc.ca 
 cc
 mapserver-users@lists.osgeo.org mailto:mapserver-users@lists.osgeo.org 
 Objet
 Re: [mapserver-users] ogc:PropertyIsEqualTo behaves like PropertyIsLike with
 oracle
 
 
 
 
 
 
 
 
 
 
 When I do this on my system I get
 
 request: 
 service=WFSversion=2.0.0request=GetFeaturetypeNames=gridws_pointcloudFilte
 r=FilterPropertyIsEqualto%20MatchCase=FALSEPropertyNameFILE_NAME/Prop
 ertyNameLiteraltest2.las/Literal/PropertyIsEqualTo/Filter
 
 [Wed Jul 22 09:26:31 2015].885667 got a IEQ comparison
 [Wed Jul 22 09:26:31 2015].885676 closing RE comparison
 [Wed Jul 22 09:26:31 2015].885681 msOracleSpatialLayerWhichShapes was called.
 [Wed Jul 22 09:26:31 2015].885704 msOracleSpatialLayerWhichShapes. Using this
 Sql to retrieve the data: SELECT COLLECT_ID, COLLECTION, FILE_NAME,
 DATE_LOADED, PC_ID, X, Y, FILE_SIZE_MB, COLLECTDATE, DOWNLOAD_URL,
 SENSOR_NAME, rownum, geom WHERE  ( REGEXP_LIKE( FILE_NAME, 'test2.las','i'  )
 )  AND SDO_FILTER( geom, MDSYS.SDO_GEOMETRY(2003, :srid,
 NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),:ordinates ),'querytype=window') =
 'TRUE'
 
 This shows that its translating the PropertyIsEqualTo with MatchCase false to
 a regexp_like case insensitive query with no wildcards. Not sure why you
 wouldn't get the same thing.
 
 Mike
 
 
 Michael Smith
 US Army Corps
 Remote Sensing GIS/Center
 michael.sm...@usace.army.mil mailto:michael.sm...@usace.army.mil
 
 
 From: steve.tout...@inspq.qc.ca mailto:steve.tout...@inspq.qc.ca 
 Date: Wednesday, July 22, 2015 at 9:13 AM
 To: Michael Smith michael.smith.e...@gmail.com
 mailto:michael.smith.e...@gmail.com 
 Cc: mapserver-users@lists.osgeo.org mailto:mapserver-users@lists.osgeo.org
 
 Subject: Re: [mapserver-users] ogc:PropertyIsEqualTo behaves like
 PropertyIsLike with oracle
 
 Thanks for your help, here is the log
 Steve
 ul 22 08:14:09 2015].892715 msOracleSpatialLayerWhichShapes. Bind values:
 srid:4326 minx:-91.320741 miny:41.948470 maxx:-45.679259 maxy:63.664769
 [Wed Jul 22 08:14:09 2015].894113 msOracleSpatialLayerWhichShapes bind by name
 and object.
 [Wed Jul 22 08:14:09 2015].894134 msOracleSpatialLayerWhichShapes name and
 object now bound.
 [Wed Jul 22 08:14:10 2015].77889 mapserv request processing time (msLoadMap
 not incl.): 0.203s
 [Wed Jul 22 08:14:10 2015].77903 msOracleSpatialLayerClose was called. Layer:
 0x1308650, Layer name: SMDVDP_STAT_METE
 [Wed Jul 22 08:14:10 2015].78084
 msConnPoolRelease(SMDVDP_STAT_METE,USER/*@DATABASE:1521/DEV.fadq.q
 c,0x1481850)
 [Wed Jul 22 08

Re: [mapserver-users] ogc:PropertyIsEqualTo behaves like PropertyIsLike with oracle

[Michael Smith]

Steve,

When a case insensitive exact match is used,  the code should use a
regexp_like constructor in Oracle with the case insensitive flag and an
exact pattern.

Can you do DEBUG 3 and show the log?

Mike

-- 
Michael Smith
Remote Sensing/GIS Center
US Army Corps of Engineers

From:  mapserver-users-boun...@lists.osgeo.org on behalf of
steve.tout...@inspq.qc.ca
Date:  Tuesday, July 21, 2015 at  10:07 AM
To:  mapserver-users@lists.osgeo.org
Subject:  [mapserver-users] ogc:PropertyIsEqualTo behaves like
PropertyIsLike with oracle

 Hi,
 Using MS7+oracle, I apply a wfs filter PropertyIsEqualTo on a layer attribute
 (string) with a truncated string, so it should returns 0 features, but it
 returns 1 feature.
 The complete value is Antonin. I apply the filter using Anto
 
 
 MS7+Postgis
 wfs:Query typeName=feature:SMDVDP_STAT_METE srsName=EPSG:3857ogc:Filter
 xmlns:ogc=http://www.opengis.net/ogc http://www.opengis.net/ogc
 ogc:PropertyIsEqualTo
 matchCase=falseogc:PropertyNameNOM_STAT/ogc:PropertyNameogc:LiteralAn
 to/ogc:Literal/ogc:PropertyIsEqualTo/ogc:Filter/wfs:Query
 numberOfFeatures=0 , that is ok.
 Ms log: FLTLayerApplyPlainFilterToLayer():  ([NOM_STAT] =*Anto)
 
 Ms7+Oracle
 wfs:Query typeName=feature:SMDVDP_STAT_METE
 srsName=EPSG:32198ogc:Filter xmlns:ogc=http://www.opengis.net/ogc
 http://www.opengis.net/ogc ogc:PropertyIsEqualTo
 matchCase=falseogc:PropertyNameNOM_STAT/ogc:PropertyNameogc:LiteralAn
 to/ogc:Literal/ogc:PropertyIsEqualTo/ogc:Filter/wfs:Query
 numberOfFeatures=1 , BAD
 Mslog: msOracleSpatialLayerTranslateFilter. String: ([NOM_STAT] =*Anto)
 
 Is the problem MS o oracle? Should I open a Ms bug?
 Regards!
 
 ___ 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] [EXTERNAL] Re: MapCache Time Dimensions Problem

[Michael Smith]

Stephan,

Yes, I've even used the value I have as the Default value which does fetch
things properly. 

I suppose it could be something in the specific branch I'm using. Its the
animation branch from RFC-111
(http://mapserver.org/development/rfc/ms-rfc-111.html) and
(https://github.com/jlarouche/mapcache/tree/animated-gif).

But I tried this also with master to test it non-animated and got the same
error.

Mike

-- 
Michael Smith

Remote Sensing/GIS Center
US Army Corps of Engineers



On 6/10/15,  8:28 AM, Stephan Meißl step...@meissl.name wrote:

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Mike,

strange, did you try a time interval or simply a bigger time e.g. a
whole day like TIME=2014-03-06? Maybe you can narrow it down this way.

cu
Stephan


On 06/10/2015 01:22 PM, Michael Smith wrote:
 Stephan,
 
 Yes I did run directly on the sqlite file and its got an absolute
 path. I get all the responses back I think I should get
 
 eg:
 
 Select 
 
strftime('%Y-%m-%dT%H:%M:%SZ',start_time)||'/'||strftime('%Y-%m-%dT%H:%M:
%S

 
Z',end_time) from time where source_id='earthquakes';
 
 .. 2014-03-03T23:41:21Z/2014-03-03T23:41:21Z
 2014-03-07T23:47:22Z/2014-03-07T23:47:22Z
 2014-03-07T00:53:09Z/2014-03-07T00:53:09Z
 2014-03-06T02:51:31Z/2014-03-06T02:51:31Z ...
 
 
 and it all seems to work with default values. Its only when I try
 to pass a TIME value on the URL that I get an error.
 
 GET 
 
/gridvm1mc/mapcache/?LAYERS=earthquakesSERVICE=WMSVERSION=1.1.1REQUEST
=G

 
etMapSTYLES=SRS=EPSG%3A3857BBOX=-28119042.469324,-9960050.5336716,28119
0
 42.469324,9960050.5336716WIDTH=1437HEIGHT=509 HTTP/1.1 200
 34113 GET 
 
/gridvm1mc/mapcache/?LAYERS=earthquakesSERVICE=WMSVERSION=1.1.1REQUEST
=G

 
etMapSTYLES=SRS=EPSG%3A3857BBOX=-28119042.469324,-9960050.5336716,28119
0
 
42.469324,9960050.5336716WIDTH=1437HEIGHT=509TIME=2014-03-06T02:51:31Z

 
HTTP/1.1 404 244
 
 
 And the error is no matching entry for given TIME dimension TIME
 in tileset earthquakes
 
  Michael Smith
 
 US Army Corps Remote Sensing GIS/Center
 michael.sm...@usace.army.mil
 
 
 
 
 
 -Original Message- From: Stephan Meißl
 step...@meissl.name Date: Tuesday, June 9, 2015 at 4:37 PM To:
 mapserver-users@lists.osgeo.org
 mapserver-users@lists.osgeo.org Subject: [EXTERNAL] Re:
 [mapserver-users] MapCache Time Dimensions Problem Resent-From:
 Michael Smith michael.sm...@usace.army.mil
 
 Hi Mike,
 
 did you try running the query directly in sqlite substituting
 :tileset, :start_timestamp, and :end_timestamp with actual values?
 What schema does your sqlite database have? Is the path to the
 dbfile absolute and readable?
 
 I could send you a working example if you want. Let me know.
 
 cu Stephan
 
 
 On 06/07/2015 01:13 AM, Michael Smith wrote:
 I've created a timedimension tileset in MapCache and created
 the backend sqlite db that has the available times. The
 mapserver backend handles the WMS TIME requests without a
 problem.  And when I query mapcache without a TIME=, I get
 my the default output.
 
 However, if I specify a TIME= parameter to MapCache (as a
 WMS or WMTS request), I get
 
 no matching entry for given TIME dimension TIME in tileset
 earthquakes
 
 I don't know what I need to change to get MapCache to
 recognize the TIME parameter. From the docs on RFC-96
 (http://mapserver.org/development/rfc/ms-rfc-96.html) I don't
 see what else to specify to set MapCache to understand TIME
 requests.
 
 I can see MapCache making the backend requests to generate
 images from the time values in the sqlite DB but only with
 the default specified in the timedimension. It never
 understands new ranges passed with TIME=.
 
 My tileset looks like
 
 tileset name=earthquakes sourceearthquakes/source
 cachesqlite/cache gridGoogleMapsCompatible/grid
 formatPNG/format metatile5 5/metatile
 metabuffer10/metabuffer expires3600/expires
 timedimension type=sqlite default=2014-03-25T12Z 
 dbfile/u02/mapcache/dbtime2.db/dbfile queryselect
 
 
strftime('%Y-%m-%dT%H:%M:%SZ',start)||'/'||strftime('%Y-%m-%dT%H:%M:%S
Z',

 
end)
 from time where source_id=:tileset and
 start_timegt;=datetime(:start_timestamp,'unixepoch') and
 end_timelt;=datetime(:end_timestamp,'unixepoch') order by
 end_time /query /timedimension /tileset

-BEGIN PGP SIGNATURE-
Version: GnuPG v1

iQIcBAEBAgAGBQJVeC17AAoJEKNQXeNWi+qtuwQQAJUF2EFcQw1m7f6OjY4Nkx+e
wy7HrtNdL0NjvFKgzXMRA88o19E4snr+KhelYLicDJY2vp26Dk5ctuuZRfEig+HK
ZUyklvSyfuG7VZPs3/7VYMcHgF+DfkbqZohhDsLXN1ZobEAl1PlxdrZulexTbmG+
O2p81d9p7qBFLgYDPT6WxW43lkLpuPIR1JYc2iT9CeBVvJ33QRF05taVVBkj+5ze
mwJQdRBAT3GcK/cJSgVN1pxvUBkq4C40p84EulAERX7XTkQWnClSFSJBuyON+B3q
KFnCWFxDip7zly2uwYyvJMJdkwLvJbp5UhJ/uYlDd82EODd+D4m1l//wAKsu5ZDZ
f+olnKtkiMHUc2s7OwjwYYTIvYSvA9bwIHDgmAMVCyQLZEk/Wr5Jbgi8sLxid45s
/A9j64nPSj/Ar9Kw9AbX+vyupT2iTiQyigKiA+OBhejX52d+rj6y4mEIS757NLTg
hnBrbry1LoWQjr7/XAmdGahusCF/wp6mmb0YoWFoQI+cuFJ39iIPvWXScIvUkLG9
Qj6iw4wj8WwZ2Fe2V4QbqPs5/kPY+iriZ3hTISaqdlNCP3ZWR4OSd/DcIIf68OEE

Re: [mapserver-users] Accessing ArcSDE on secured site

[michael . smith . erdc]

Eric,

This could be a certificate issue if your server certificate is not a standard 
one. You might need to load the cert to your local cert store. 

You should ruin this with shp2img on the command line and turn up the debugging 
level and see what errors you're actually getting. 

Michael Smith
Remote Sensing/GIS Center
US Army Corps of Engineers

 On Jun 8, 2015, at 4:16 PM, Weisbender, Eric weisb...@wapa.gov wrote:
 
 Hello,
  
 A couple of weeks about I posted the question below and hear anything.  I was 
 wondering if it went through and if anyone had any insight.
  
 I am trying to access ArcSDE with mapserver on a secured site that uses 
 https:// not http.  I keep getting an error saying Server Not Found.  Is this 
 even possible and if so I would welcome any help.  Thanks in advance.
  
 Eric
  
 ___
 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] MapCache Time Dimensions Problem

[Michael Smith]

I've created a timedimension tileset in MapCache and created the backend
sqlite db that has the available times. The mapserver backend handles the
WMS TIME requests without a problem.  And when I query mapcache without a
TIME=, I get my the default output.

However, if I specify a TIME= parameter to MapCache (as a WMS or WMTS
request), I get 

no matching entry for given TIME dimension TIME in tileset earthquakes

I don't know what I need to change to get MapCache to recognize the TIME
parameter. From the docs on RFC-96
(http://mapserver.org/development/rfc/ms-rfc-96.html) I don't see what else
to specify to set MapCache to understand TIME requests.

I can see MapCache making the backend requests to generate images from the
time values in the sqlite DB but only with the default specified in the
timedimension. It never understands new ranges passed with TIME=.

My tileset looks like

tileset name=earthquakes
  sourceearthquakes/source
  cachesqlite/cache
  gridGoogleMapsCompatible/grid
  formatPNG/format
  metatile5 5/metatile
  metabuffer10/metabuffer
  expires3600/expires
  timedimension type=sqlite default=2014-03-25T12Z 
   dbfile/u02/mapcache/dbtime2.db/dbfile
   queryselect
strftime('%Y-%m-%dT%H:%M:%SZ',start)||'/'||strftime('%Y-%m-%dT%H:%M:%SZ',end
) from time
  where source_id=:tileset
and start_timegt;=datetime(:start_timestamp,'unixepoch')
and end_timelt;=datetime(:end_timestamp,'unixepoch')
order by end_time
   /query
 /timedimension
   /tileset


Michael Smith
US Army Corps
Remote Sensing GIS/Center
michael.sm...@usace.army.mil



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

[mapserver-users] MapCache configuration issue

[Michael Smith]

I have MapServer installed and configured to act as a WMS and it is working 
fine. The problem I am having comes when I try to enable MapCache. When I 
uncomment the MapCache line in httpd.conf to enable the module and restart 
Apache it fails with the error 'failed to parse file... unexpected closing tag 
/mapcache.' This seems odd as I have an opening mapcache tag in 
mapcache.xml.

My guess is that I made an error when configuring mapcache.xml for my service. 
Unfortunately, since Apache will not start with MapCache enabled, there is 
nothing in error.log describing what is going on.

I am running MapServer 6.1-dev, from MS4W 3.0.4-dev, on Windows Server 2003 
Service Pack 2. The images being served are JPEG hillshades using the NAD83 UTM 
Zone10N projection. I am not trying to reproject the image. The httpd.conf was 
modified to load the module and points to the location of mapcache.xml and the 
directory where the tiles will be saved is open to all users to read, write, 
and execute.

I have attached the GetCapabilities output for the server and the mapcache.xml 
config file. Did I completely miss something in the documentation when building 
the cache config?

- Michael

?xml version=1.0 encoding=UTF-8?

mapcache
	grid name=UTM_Zone10N
		metadata
			titleNAD83 UTM Zone 10N/title
		/metadata
		!-- Extent is projected bounds for EPSG:26910 from spatialreference.org --
		extent224215.8977 3810589.9220 775784.1023 8548694.5500/extent
		srsEPSG:26910/srs
		unitsm/units
		size512 512/size
		resolutions529.1663809 352.7775873 176.3887936 88.19439682 44.09719841 22.57776559 11.2279 5.61396 2.80698/resolutions
	/grid
	
	source name=hillshade type=wms
		getmap
			params
MAPc:/ms4w/apps/abagwms/hillshade.map/MAP
VERSION1.1.1/VERSION
LAYERShillshade100m,hillshade30m,hillshade10m/LAYERS
SRSEPSG:26910/SRS
!-- BBOX values are from GetCapabilities request for largest image, hillshade10m, in Mapfile --
BBOX399554 3960950 776453 4446280/BBOX
WIDTH512/WIDTH
HEIGHT512/HEIGHT
FORMATimage/png/FORMAT
TRANSPARENCYtrue/TRANSPARENCY
			/params
		/getmap
	
		http
			urlhttp://172.16.1.40/cgi-bin/mapserv.exe?/url
			connection_timeout30/connection_timeout
		/http
	/source
   
	cache name=hillcache type=disk
		baseE:/srvrcache/base
	/cache   
	
	format name=PNG_FAST type=PNG
		compressionfast/compression
	/format
	
	tileset name=hilltile
		!-- Source name from earlier section --
		sourcehillshade/source
		!-- Cache name from earlier section --
		cachehillcache/cache
		!-- Grid name from earlier section --
		gridUTM_Zone10N/grid
		!-- gridg/grid --
		formatPNG/format
		metatile5 5/metatile
		metabuffer10/metabuffer
		expires3600/expires
	/tileset

	service type=wms enabled=true
		full_wmsassemble/full_wms
		resample_modebilinear/resample_mode
		formatPNG/format
		!-- maxsize4096/maxsize --
	/service
	service type=wmts enabled=true/
	service type=tms enabled=true/
	service type=kml enabled=false/
	service type=gmaps enabled=false/
	service type=ve enabled=false/
	service type=demo enabled=true/
	
	default_formatPNG_FASTdefault_format
	errorsreport/errors
	lock_dirC:/ms4w/tmp/ms_tmp/lock_dir

/mapcache?xml version='1.0' encoding=ISO-8859-1 standalone=no ?
!DOCTYPE WMT_MS_Capabilities SYSTEM http://schemas.opengis.net/wms/1.1.1/WMS_MS_Capabilities.dtd;
 [
 !ELEMENT VendorSpecificCapabilities EMPTY
 ]  !-- end of DOCTYPE declaration --

WMT_MS_Capabilities version=1.1.1

!-- MapServer version 6.1-dev (MS4W 3.0.4-dev) OUTPUT=GIF OUTPUT=PNG OUTPUT=JPEG OUTPUT=KML SUPPORTS=PROJ SUPPORTS=AGG SUPPORTS=CAIRO SUPPORTS=FREETYPE SUPPORTS=ICONV SUPPORTS=FRIBIDI SUPPORTS=WMS_SERVER SUPPORTS=WMS_CLIENT SUPPORTS=WFS_SERVER SUPPORTS=WFS_CLIENT SUPPORTS=WCS_SERVER SUPPORTS=SOS_SERVER SUPPORTS=FASTCGI SUPPORTS=THREADS SUPPORTS=GEOS INPUT=JPEG INPUT=POSTGIS INPUT=OGR INPUT=GDAL INPUT=SHAPEFILE --

Service
  NameOGC:WMS/Name
  TitleHillshade/Title
  OnlineResource xmlns:xlink=http://www.w3.org/1999/xlink; xlink:href=http://172.16.1.40/cgi-bin/mapserv.exe?map=c:/ms4w/apps/abagwms/hillshade.mapamp;/
  ContactInformation
  /ContactInformation
/Service

Capability
  Request
GetCapabilities
  Formatapplication/vnd.ogc.wms_xml/Format
  DCPType
HTTP
  GetOnlineResource xmlns:xlink=http://www.w3.org/1999/xlink; xlink:href=http://172.16.1.40/cgi-bin/mapserv.exe?map=c:/ms4w/apps/abagwms/hillshade.mapamp;//Get
  PostOnlineResource xmlns:xlink=http://www.w3.org/1999/xlink; xlink:href=http://172.16.1.40/cgi-bin/mapserv.exe?map=c:/ms4w/apps/abagwms/hillshade.mapamp;//Post
/HTTP
  /DCPType
/GetCapabilities
GetMap
  Formatimage/png/Format
  Formatimage/jpeg/Format
  Formatimage/gif/Format
  Formatimage/png; mode=8bit/Format
  Formatapplication/x-pdf/Format
  Formatimage/svg+xml/Format
  Formatimage/tiff/Format
  Formatapplication/vnd.google-earth.kml+xml/Format
  Formatapplication/vnd.google-earth.kmz/Format
  DCPType
   

Re: [mapserver-users] MapCache configuration issue

[Michael Smith]

Thank you very much Thomas!

I looked at that file a dozen times yesterday and never noticed that. That is 
embarrassing.

- Michael



 thomas bonfort thomas.bonf...@gmail.com 8/10/2012 12:16 PM 
Hi,
you're missing the closing / in default_format = /default_format

--
thomas


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

Re: [mapserver-users] Shptree fails with biggish shapefile

[Michael Smith]

You may also want to limit the depth. In the benchmarking exercise, we saw
shptree creating a qix file with excessive depth. Try limiting the depth to
8 or less.

Mike


-- 
Michael Smith
US Army Corps of Engineers
Remote Sensing/GIS Center
Hanover, NH 




On 10/20/10 8:21 AM, Jeff McKenna jmcke...@gatewaygeomatics.com wrote:

 On 10-10-20 9:07 AM, Rahkonen Jukka wrote:
 Hi,
 I have been trying to create an index with shptree for a rather big
 shapefile. The size of the .shp part is about 1800 KB. Shptree seems to
 run OK, it does not throw any errors and Windows task manager shows a
 steady growing memory usage. Then shptree stops without warnings and
 memory is freed. Unfortunately no .qix file is written on the disk. I
 made a test by selecting a part of the big shapefile into a smaller one
 and for that I could create .qix index normally. Therefore I believe
 that the data is OK and shptree fails because of the big shapefile size.
 Have anyone else experienced the same and if this perhaps something
 worth creating a new ticket on issue tracker?
 I am still playing with GDAL 1.7.0dev, FWTools 2.4.2, released 2009/06/24.
 
 
 Note that large dbf/shp support was recently tweaked during the recent
 WMS Benchmarking exercise
 (http://osgeo-org.1803224.n2.nabble.com/Support-for-large-DBF-SHP-files-td5420
 444.html#a5420444).
   In that case shptree would create a qix file (for a 1.3GB shp) but
 MapServer would not draw it and no errors were thrown; this has since
 been fixed.
 
 -jeff
 

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

Re: [mapserver-users] doubt about mapserver URL: coordinate system

[Michael Smith]

Sebastian,

You can use either mapserver  or wms syntax with openlayers.

The coordinates you see are in the Google Mercator or Spherical Mercator
projection. The google coordinates are the tile references (z=19) and the x
and y should match the center point of your mapext/imgext.

To use mapserver with google mercator you¹d use the projection block at the
mapfile level of

PROJECTION
 proj=merc lon_0=0 k=1 x_0=0 y_0=0 a=6378137 b=6378137
towgs84=0,0,0,0,0,0,0 units=m no_defs
END

Mike


-- 
Michael Smith
US Army Corps of Engineers
Remote Sensing/GIS Center
Hanover, NH 




On 10/7/10 7:42 AM, Sebastian E. Ovide sebastian.ov...@gmail.com wrote:

 you are right. Thanks
 
 On Wed, Oct 6, 2010 at 6:15 PM, Rahkonen Jukka jukka.rahko...@mmmtike.fi
 wrote:
 Hi,
 
 It looks like your application is calling Mapserver with native CGI requests
 and I believe you have defined some special Mapserver layer in your
 application. Try to change it to standard WMS layer.
 
 
 -Jukka Rahkonen-
 
 
 Sebastian E. Ovide wrote:
 
 Lähetetty: ke 6.10.2010 18:06
 Vastaanottaja: mapserver-users@lists.osgeo.org
 Aihe: [mapserver-users] doubt about mapserver URL: coordinate system
 
 Hi List
 
 I'm using OpenLayers + MapServer. With Firebug I see that OpenLayers calls
 MapServer with ULRs like this:
 
 http://mapserver/mapserver?layers=NAFRA_2008_final
 map=/home/gis/conf/mapserver/uk.map
 mode=map
 map_imagetype=png
 mapext=-374388.56527373+7296678.7179959+-374312.12824546+7296755.1550241
 imgext=-374388.56527373+7296678.7179959+-374312.12824546+7296755.1550241
 map_size=256+256
 imgx=128
 imgy=128
 imgxy=256+256
 
 Just trying to understand the coordinate system used by mapext and imgext. (
 it is different from than that used to call Google servers:
 http://mt0.google.com/vt/lyr...@133hl=ensrc=apix=257246y=166679z=19s=G
 )
 
 Is it possible to use a different coordinate system ? say for example the
 same coordinate system specified in the LAYER (in my case epsg:27700)
 
 thanks
 
 --
 Sebastian E. Ovide
 
 
 

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

Re: [mapserver-users] Re: mapserver and i18n

[Michael Smith]

I would do this on the backend. Pass a language variable to your data query

DATA geom from data where lang='%lang%'
LABELITEM %LANG%HIGHWAY

And have one mapfile and just have your translations in PostGis/Oracle/etc.

Mike


-- 
Michael Smith
US Army Corps of Engineers
Remote Sensing/GIS Center
Hanover, NH 





On 10/6/10 1:56 PM, Stephen Woodbridge wood...@swoodbridge.com wrote:

 On 10/6/2010 12:54 PM, Bart van den Eijnden wrote:
 I don't agree with you here Steve.
 
 Also look at the INSPIRE language parameter, it's up to the service
 (View Service, WMS) to translate, not the client. Think of layer
 titles in WMS GetCapabilities.
 
 The way I've been doing it is to duplicate my datasets behind
 Mapserver, but that's not an ideal situation.
 
 Best regards, Bart
 
 
 Hi Bart,
 
 Thanks for this feedback. I will look into that.
 
 While I have implemented multilingual driving directions, but I'm far
 from being very knowledgeable with regards to most of the i18n issues.
 
 So do you have any recommendations or ideas for how mapserver should
 deal with this? Would something like creating an additional mapping
 table for terms solve this problem? Maybe something like the following
 in a mapfile:
 
 TRANSLATIONS
TERM Highway
  en_US.UTF-8 Highway
  en_UK.UTF-8 Autoroute
  ...
END
TERM ...
END
 END
 
 or something along these lines, with the idea the mapserver use this to
 deal with user requests appropriately.
 
 -Steve W
 ___
 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] lighttpd, TNS:could not resolve...

[Michael Smith]

Sebastian,

Instead of using TNS, you could try the EZConnect syntax of
@host:port/service_name. That way you bypass even needing a TNS. Also if
your port is 1521, you can just not include it and use

CONNECTION ³user/p...@hostname/service_name²

Mike


-- 
Michael Smith
US Army Corps of Engineers
Remote Sensing/GIS Center
Hanover, NH 

 


On 10/5/10 7:26 AM, Sebastian E. Ovide sebastian.ov...@gmail.com wrote:

 I've also add a script that prints the variables and TNS_ADMIN is there...
 
 USERNAME=root
 LANG=en_US.UTF-8
 SUDO_GID=1001
 SHELL=/bin/bash
 SUDO_COMMAND=/etc/init.d/lighttpd restart
 ORACLE_HOME=/home/gis/libs/instantclient_11_2/
 SUDO_UID=1001
 TERM=xterm
 PHP_FCGI_CHILDREN=1
 PATH=/sbin:/bin:/usr/sbin:/usr/bin
 PWD=/home/gis/conf
 LOGNAME=root
 USER=root
 HOME=/home/gis
 MAIL=/var/mail/gis
 SUDO_USER=gis
 LS_COLORS=rs=0:di=01;34:ln=01;36:mh=00:pi=40;33:so=01;35:do=01;35:bd=40;33;01:
 cd=40;33;01:or=40;31;01:su=37;41:sg=30;43:ca=30;41:tw=30;42:ow=34;42:st=37;44:
 ex=01;32:*.tar=01;31:*.tgz=01;31:*.arj=01;31:*.taz=01;31:*.lzh=01;31:*.lzma=01
 ;31:*.tlz=01;31:*.txz=01;31:*.zip=01;31:*.z=01;31:*.Z=01;31:*.dz=01;31:*.gz=01
 ;31:*.lz=01;31:*.xz=01;31:*.bz2=01;31:*.bz=01;31:*.tbz=01;31:*.tbz2=01;31:*.tz
 =01;31:*.deb=01;31:*.rpm=01;31:*.jar=01;31:*.rar=01;31:*.ace=01;31:*.zoo=01;31
 :*.cpio=01;31:*.7z=01;31:*.rz=01;31:*.jpg=01;35:*.jpeg=01;35:*.gif=01;35:*.bmp
 =01;35:*.pbm=01;35:*.pgm=01;35:*.ppm=01;35:*.tga=01;35:*.xbm=01;35:*.xpm=01;35
 :*.tif=01;35:*.tiff=01;35:*.png=01;35:*.svg=01;35:*.svgz=01;35:*.mng=01;35:*.p
 cx=01;35:*.mov=01;35:*.mpg=01;35:*.mpeg=01;35:*.m2v=01;35:*.mkv=01;35:*.ogm=01
 ;35:*.mp4=01;35:*.m4v=01;35:*.mp4v=01;35:*.vob=01;35:*.qt=01;35:*.nuv=01;35:*.
 wmv=01;35:*.asf=01;35:*.rm=01;35:*.rmvb=01;35:*.flc=01;35:*.avi=01;35:*.fli=01
 ;35:*.flv=01;35:*.gl=01;35:*.dl=01;35:*.xcf=01;35:*.xwd=01;35:*.yuv=01;35:*.cg
 m=01;35:*.emf=01;35:*.axv=01;35:*.anx=01;35:*.ogv=01;35:*.ogx=01;35:*.aac=00;3
 6:*.au=00;36:*.flac=00;36:*.mid=00;36:*.midi=00;36:*.mka=00;36:*.mp3=00;36:*.m
 pc=00;36:*.ogg=00;36:*.ra=00;36:*.wav=00;36:*.axa=00;36:*.oga=00;36:*.spx=00;3
 6:*.xspf=00;36:
 LD_LIBRARY_PATH=/home/gis/libs/instantclient_11_2/
 TNS_ADMIN=/home/gis/conf/
 
 any other ideas ?
 
 On Thu, Sep 30, 2010 at 3:09 PM, Sebastian E. Ovide
 sebastian.ov...@gmail.com wrote:
 done. (restarted server etc...)
 
 exactly the same problem...
 
 
 
 
 
 On Thu, Sep 30, 2010 at 2:51 PM, Dan Little danlit...@yahoo.com wrote:
 I was starting to suspect MapServer is just no seeing the environment
 variables...
 
 Try this... write a wrapper script mapserv.sh
 
 #!/bin/bash
 
 TNS_ADMIN=/home/gis/conf
 
 /home/gis/bin/mapserv
 
 Then update your script to point to mapserv.sh.
 
 
 
 
 From: Sebastian E. Ovide sebastian.ov...@gmail.com
 To: Dan Little danlit...@yahoo.com
 Cc: Rahkonen Jukka jukka.rahko...@mmmtike.fi;
 mapserver-users@lists.osgeo.org
 Sent: Thu, September 30, 2010 8:01:22 AM
 
 Subject: Re: [mapserver-users] lighttpd, TNS:could not resolve...
 
 on the same machine, with the same data and same tns file it works fine
 with APACHE the problems is only with LIGHTTPD... it looks
 like TNS_ADMIN = /home/gis/conf/ is ignored (in apache I've
 used SetEnv and PassEnv
 
 ???
 
 On Thu, Sep 30, 2010 at 12:22 PM, Dan Little danlit...@yahoo.com wrote:
 Does shp2img work with your Mapfile?
 
 From: Sebastian E. Ovide sebastian.ov...@gmail.com
 To: Rahkonen Jukka jukka.rahko...@mmmtike.fi
 Cc: mapserver-users@lists.osgeo.org
 Sent: Thu, September 30, 2010 4:47:30 AM
 Subject: Re: [mapserver-users] lighttpd, TNS:could not resolve...
 
 the message says: 
 
 ORA-12154: TNS:could not resolve the connect identifier specified in
 unnamed
 
 so... does unnamed mean that gdal didn't get any name for the
 connection ?
 
 
 
 On Thu, Sep 30, 2010 at 9:54 AM, Sebastian E. Ovide
 sebastian.ov...@gmail.com wrote:
 no luck...
 
 renamed servicename to capital.. so now connection name==service name...
 
 same problem... ogrinfo works, mapserver doesn't
 
 
 On Thu, Sep 30, 2010 at 9:37 AM, Rahkonen Jukka
 jukka.rahko...@mmmtike.fi wrote:
Hi,
 
For me, sometimes with some Oracle user name from some computers SQL*Plus
does not understand if I am using the SERVICE_NAME.  It you happen to have
the same situation you should be able to connect with the connection name,
which seems to be MFUATDB for you. 
 
Actually, the error message TNS:could not resolve the connect identifier
specified may mean that you should not use service name but the connect
identifier.  Have a try and tell how it went.
 
 
-Jukka Rahkonen- 


 
 

 Lähettäjä:  mapserver-users-boun...@lists.osgeo.org
[mailto:mapserver-users-boun...@lists.osgeo.org] Puolesta Sebastian E.
Ovide
Lähetetty: 30. syyskuuta 2010 11:15
Vastaanottaja:  Dan Little
Kopio: mapserver-users@lists.osgeo.org
Aihe:  Re: [mapserver-users] lighttpd, TNS:could not resolve...

 
yes. 

 

 
 
g...@mapserver:~$ ls -la /home/gis/conf/tnsnames.ora
 
-rw-r--r-- 1 gis gis 184 2010-09-29 16:19

Re: [mapserver-users] Using mapserver to print a large plotter sized image

[Michael Smith]

Robert,

To increase the maximum size that MapServer will generate, add the MAXSIZE
keyword to you mapfile (in the MAP section)

eg

MAXSIZE 8000


See more here ( http://mapserver.org/mapfile/map.html )

Mike



On 6/1/09  12:47 PM, Robert Hicks rob...@gmail.com wrote:

 Hello all, I am trying to figure out a way I can use Mapserver to print out a
 large image, one that will look good coming off a plotter (probably around 300
 dpi).
 
 There is an open ticket
 (http://mapserver.org/development/rfc/ms-rfc-55.html) for something somewhat
 related but it offers some good advice on what I am trying to do, however the
 maximum size that Mapserver allows you to request is 2048 x 2048, and my
 current viewport is 757 which scales like: 757 (old size) * 300 (new
 resolution that is good for 300 dpi according to ticket) / 72 (old resolution)
 = 3154.1667 which is way to big to request from
 Mapserver.
 
 Does anyone have experience with this? 
 
 Thanks!
 
 
 ___
 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] WMS Layer with secure http url

[Michael Smith]

Alexandre,

What you need is the servers root certificate added to your libcurl certs.
Its failing on validating the servers ssl certificate.

The curl-config should list your cert directory and then you can add your
cert there and it should validate.

Mike


-- 
Michael Smith
RSGIS Center
ERDC - CRREL
US Army Corps of Engineers





On 5/5/09  7:02 PM, Alexandre Dube ad...@mapgears.com wrote:

 Hi list,
 
   I'd like to know if it's possible to have a WMS layer linked to a
 secure http url (https).  Currently, I see this error in log :
 
 === LOG ===
 
 [Tue May  5 18:53:01 2009].853725 msHTTPExecuteRequests(): HTTP request
 error. HTTP: request failed with curl error code 60 (SSL certificate
 problem, verify that the CA cert is OK. Details:
 error:14090086:SSL routines:SSL3_GET_SERVER_CERTIFICATE:certificate
 verify failed) for
 https://foo.com/cgi-bin/mapserv?map=mapLAYERS=LayerREQUEST=GetMapSERVICE=WM
 SFORMAT=image/pngSTYLES=HEIGHT=482VERSION=1.1.1SRS=EPSG:900913WIDTH=732
 BBOX=-7977472.96139656,6196959.95818015,-7973217.53860244,6199762.02619485TRA
 NSPARENT=TRUEEXCEPTIONS=application/vnd.ogc.se_inimage
 [Tue May  5 18:53:01 2009].854421 msDrawWMSLayerLow(): WMS server error.
 WMS GetMap request failed for layer 'Layer' (Status -60: SSL certificate
 problem, verify that the CA cert is OK. Details:
 error:14090086:SSL routines:SSL3_GET_SERVER_CERTIFICATE:certificate
 verify failed).
 
 ===
 
 If I try the url in a browser with cookies/cache emptied, the url ask a
 login/password ( which I know... ) so I guess the WMS layer is refused
 to access the url since it doesn't have the login/password.  Is there a
 way to accomplish this ?
 
 Many thanks,

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

Re: [mapserver-users] WFS layer and https

[Michael Smith]

Brian,

You need the servers certificate in your cURL certificate directory. Where
to put it, I think, depends on your OS. The default in the Unix OS¹s is
/usr/share/ssl/certs.

Mike


-- 
Michael Smith
RSGIS Center
ERDC - CRREL
US Army Corps of Engineers





On 4/9/09  10:09 AM, Fischer, Brian bfisc...@houstoneng.com wrote:

 I¹m trying to use a WFS that is coming from a SSL (https) server.  Is it
 possible to use a WFS from an https connection?  Here is the error I am
 getting.
  
 HTML
 HEADTITLEMapServer Message/TITLE/HEAD
 !-- MapServer version 5.0.2 OUTPUT=GIF OUTPUT=PNG OUTPUT=JPEG OUTPUT=WBMP
 OUTPUT=PDF OUTPUT=SWF OUTPUT=SVG SUPPORTS=PROJ SUPPORTS=AGG SUPPORTS=FREETYPE
 SUPPORTS=WMS_SERVER SUPPORTS=WMS_CLIENT SUPPORTS=WFS_SERVER
 SUPPORTS=WFS_CLIENT SUPPORTS=WCS_SERVER SUPPORTS=SOS_SERVER SUPPORTS=FASTCGI
 SUPPORTS=THREADS SUPPORTS=GEOS INPUT=JPEG INPUT=POSTGIS INPUT=OGR INPUT=GDAL
 INPUT=SHAPEFILE --
 BODY BGCOLOR=#FF
 msDrawMap(): Image handling error. Failed to draw layer named #39;obs#39;.
 msWFSLayerWhichShapes(): WFS connection error. Got HTTP status -60 downloading
 WFS layer obs
 msHTTPExecuteRequests(): HTTP request error. HTTP: request failed with curl
 error code 60 (SSL certificate problem, verify that the CA cert is OK.
 Details:
 error:14090086:SSL routines:SSL3_GET_SERVER_CERTIFICATE:certificate verify
 failed) for 
 https://www.sharedgeo.org/datasets/RRV/maps/noaa/noaa.map?mode=owsamp;amp;RE
 QUEST=GetFeatureamp;VERSION=1.0.0amp;SERVICE=WFSamp;TYPENAME=obsamp;BBOX=3
 46334.183773962,5034450.028,903297.375226037,5434570.553
 /BODY/HTML
  
 Thanks,
 Brian
  
 Brian Fischer, CFM
 GIS Project Manager
 Houston Engineering, Inc. | Leave Nothing to ChanceTM
 6901 East Fish Lake Road, Suite 140
 Maple Grove, MN 55369
 Phone:  763.493.4522 / Fax:  763.493.5572
 Email:  bfisc...@houstoneng.com mailto:bfisc...@houstonengineeringinc.com
 Website: www.houstoneng.com http://www.houstonengineeringinc.com/
  
 
 
 ___
 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] getFeatureInfo() Only Works on One Layer?

[Michael Smith]

Bill,

Try separating the QUERY_LAYERS with a space rather than a comma. MapServer
uses space delimited values (gets changed to + separated in the URL).

Mike


-- 
Michael Smith
RSGIS Center
ERDC - CRREL
US Army Corps of Engineers





On 1/27/09  6:13 PM, Bill Thoen bth...@gisnet.com wrote:

 I originally asked this on the OpenLayers forum, but was told that this
 is really a Maperver question. So I'll try it here.
 
 I've got a WMS layer that has two sub-layers in it and I'm trying to get
 attribute information from them via a getFeatureInfo request, but I can
 only get one of them to respond at a time. I've looked at the docs at
 http://trac.openlayers.org/wiki/GetFeatureInfo and noticed that you can
 specify several layers with the QUERY_LAYERS parameter, but I'm finding
 that only the one listed first is active. Also, it's not clear what
 layer you specify at the root of the request, but it looks like it's
 supposed to be different from the layers you're querying. Anyway, here's
 what I'm trying:
 
 I open and load the combined layer like so:
  base = new OpenLayers.Layer.WMS(
Base,
http://192.168.0.250/cgi-bin/mapserv?map=base.map;,
{ layers: [us_states, us_interstate] }
  );
  map.addLayer(base);
 
 
 And here's the request string I'm sending to MapServer:
 
 var url = base.getFullRequestString({
  REQUEST: GetFeatureInfo,
  EXCEPTIONS: application/vnd.ogc.se_xml,
  FORMAT: 'png',
  BBOX: map.getExtent().toBBOX(),
  X: event.xy.x,
  Y: event.xy.y,
  INFO_FORMAT: 'text/plain',
  QUERY_LAYERS: us_interstate, us_states,
  FEATURE_COUNT: 1,
  WIDTH: map.size.w,
  HEIGHT: map.size.h},
  http://192.168.0.250/cgi-bin/mapserv?map=base.map;);
 OpenLayers.loadURL(url, '', this, setHTML);
 
 Note the QUERY_LAYERS line. As shown here, it responds with interstate
 attributes only when I click on an interstate roadway feature, but I get
 nothing when I click on a state. If I reverse the order of these layers
 in the list, then clicking on a state returns attributes from the
 us_states table only. Even if I click on a spot where features in both
 layers coincide, it returns only the attributes for the layer listed first.
 
 Also, setting the FEATURE_COUNT parameter to something higher than 1 just
 gives me more results from the single that  is working.
 
 So how do I use multiple layers in the QUERY_LAYERS parameter, or do I
 get only one at a time? Also, I just guessed at using the layer called
 'base' for the getFeatureInfo oject, what is supposed to be used here?
 
 TIA,
 - Bill Thoen
 
 
 
 ___
 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] unsubscribe

[Michael Smith]

Please remove me from the email list.  Thanks.

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of rich.fromm
Sent: Wednesday, March 05, 2008 8:47 PM
To: mapserver-users@lists.osgeo.org
Subject: Re: [MAPSERVER-USERS] msProcessProjection(): Projection library
error.



rich.fromm wrote:
 
 
 rich.fromm wrote:
 
 I am in the process of running another test, this using a build of the
 tip of branch-5-0, along with local patches both for bug 2497 and for bug
 2533 (in other words, this patch).
 
 
 It also ran fine (for a 6 hour test under heavy load).  For more details,
 see:
 http://trac.osgeo.org/mapserver/ticket/2533#comment:6
 

I continued running stress tests on the branch-5-0 build.  While I have not
yet seen the projection error again, after 06:24:13 elapsed time, tomcat
again crashed in mapObj.new().  Note that this is very similar to the stack
trace that I had seen previously (see
http://www.nabble.com/msProcessProjection%28%29%3A-Projection-library-error.
-to15815968.html),
but not precisely the same.  The differences might be explained by this
build being from branch-5-0, and the previous runs being from the 5.0.0
release.  Regardless, I once again return to my notion that these are two
separate issues:

_IO_fread (/lib/libc.so.6)
yy_get_next_buffer (maplexer.c:3526)
msyylex (maplexer.c:3357)
loadClass (mapfile.c:2102)
loadLayer (mapfile.c:2577)
loadMapInternal (mapfile.c:4348)
msLoadMap (mapfile.c:4573)
new_mapObj (mapscript/java/mapscript_wrap.c:1612)
Java_edu_umn_gis_mapscript_mapscriptJNI_new_1mapObj
(mapscript/java/mapscript_wrap.c:19783)

-- 
View this message in context:
http://www.nabble.com/msProcessProjection%28%29%3A-Projection-library-error.
-tp15815968p15865401.html
Sent from the Mapserver - User mailing list archive at Nabble.com.

___
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