Re: [mapserver-users] [EXTERNAL] Re: How to enable GetFeatureInfo in MS4w 3.0.6 ?

2015-06-09 Thread Smith, Michael ERDC-RDE-CRREL-NH
Note DUMP TRUE has not been used since v6.

Now its OWS_ENABLE_REQUEST Requesttype

Mike

-- 
Michael Smith

Remote Sensing/GIS Center
US Army Corps of Engineers



On 6/9/15,  2:26 PM, Jeff McKenna jmcke...@gatewaygeomatics.com wrote:

On 2015-06-09 2:37 PM, Bistrais, Bob wrote:
 I can¹t seem to find the answer to this one.  I have a number of WMS
 layers which I would like to enable GetFeatureInfo.  I am using MS4W
 3.0.6.  I can¹t seem to get the GetFeatureInfo to work.  Can somebody
 point me to a reference?


I always follow the WMS Server document, when I configure a mapfile for
GetFeatureInfo (see the section Configuring for GetFeatureInfo
Requests at http://www.mapserver.org/ogc/wms_server.html).  I check it
often for syntax.

Key points as noted there, are:

  - set your WEB METADATA parameter of wms_feature_info_mime_type
(likely to text/plain)
  - in the LAYER METADATA specify the fields to expose through
gml_include_items
  - set DUMP TRUE inside the layer
  - set CLASS TEMPLATE (likely to something like dummy.html)


If I missed something it's likely inside that document.

-jeff






-- 
Jeff McKenna
MapServer Consulting and Training Services
http://www.gatewaygeomatics.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] [EXTERNAL] Failed to draw Oracle9i layer

2015-06-01 Thread Smith, Michael ERDC-RDE-CRREL-NH
Francisco,

Change your DATA statement to be :  DATA MI_SHAPE FROM CONSEJOSPOPULARES using 
SRID 4326

Eg, remove the = sign.

Mike

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


From: Francisco Salas Rosette 
fsa...@pinar.geocuba.cumailto:fsa...@pinar.geocuba.cu
Date: Monday, June 1, 2015 at 8:08 AM
To: mapserver-users 
mapserver-users@lists.osgeo.orgmailto:mapserver-users@lists.osgeo.org
Subject: [EXTERNAL] [mapserver-users] Failed to draw Oracle9i layer
Resent-From: Michael Smith 
michael.sm...@usace.army.milmailto:michael.sm...@usace.army.mil

Hi,
I am having trouble making one test with loading the Oracle9i layer , using PHP 
Version 5.4.3 and MapServer CGI 6.0.3
The layer definition in my map file is :
LAYER
NAME Consejo_Popular
TYPE POLYGON
STATUS ON
CONNECTIONTYPE oraclespatial
CONNECTION **/*@catastro
DATA MI_SHAPE FROM CONSEJOSPOPULARES using SRID=4326
DUMP TRUE
CLASS
 OUTLINECOLOR  0 0 0
 COLOR 0 128 128
END
  END

I use this “Steps to Enable Oracle 10g or 11g Support in MS4W” , but I test in 
oracle9i

And launch this error message ,

Warning: mapObj::draw(): [MapServer Error]: msDrawMap(): Failed to draw layer 
named 'Consejo_Popular'. in 
C:\ms4w\Apache\htdocs\MsExt\Components\Reference\Server\Reference.php on line 
108

Warning: mapObj::draw(): [MapServer Error]: msOracleSpatialLayerWhichShapes(): 
Error: ORA-29902: error in executing ODCIIndexStart() routine ORA-01722: 
invalid number . Query statement: SELECT rownum, MI_SHAPE FROM 
CONSEJOSPOPULARES WHERE SDO_FILTER( MI_SHAPE, MDSYS.SDO_GEOMETRY(2003, :srid, 
NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),:ordinates ),'querytype=window') = 
'TRUE' . Check your data statement. in 
C:\ms4w\Apache\htdocs\MsExt\Components\Reference\Server\Reference.php on line 
108

How resolve this problems ??

Thanks ,

Francisco Salas



Anuncie sus servicios en ANDARIEGO? aplicaci?n para celulares sobre mapas de 
toda Cuba.
Visite el sitio http://andariego.geocuba.cu o http://www.andariego.cu, 
cont?ctenos por el correo 
andari...@geosi.geocuba.cumailto:andari...@geosi.geocuba.cu o por el tel?fono 
8817400.
Ponga su informaci?n al servicio de todos.




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

Re: [mapserver-users] [EXTERNAL] Re: Mapserver 7+oracle - wfs getFeature with filter on numeric field

2015-05-19 Thread Smith, Michael ERDC-RDE-CRREL-NH
Steve,

Rerun this with DEBUG 3 on the LAYER and the generated SQL will show up in your 
error logs. Then it should show why the generated sql is not valid.

Mike

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

From: steve.tout...@inspq.qc.camailto:steve.tout...@inspq.qc.ca 
steve.tout...@inspq.qc.camailto:steve.tout...@inspq.qc.ca
Date: Tuesday, May 19, 2015 at 9:37 AM
To: Rahkonen Jukka (MML) 
jukka.rahko...@maanmittauslaitos.fimailto:jukka.rahko...@maanmittauslaitos.fi
Cc: MapserverList OSGEO 
mapserver-users@lists.osgeo.orgmailto:mapserver-users@lists.osgeo.org, 
Michael Smith michael.sm...@erdc.dren.milmailto:michael.sm...@erdc.dren.mil
Subject: Re: [mapserver-users] [EXTERNAL] Re: Mapserver 7+oracle - wfs 
getFeature with filter on numeric field

Thank you all for this discussion.
We had different problems in our use case coming from gdal, mapserv, oracle, 
..
I don't know how gdal should manage this comma issue, but I would like to 
clarify our problem with mapserv and see if something must be done.

Resume
- We use MS7.1 with oraclespatial connection
- gml_type = auto, which returns element name=LONG_STAT minOccurs=0 
type=double/
- matchCase =true
- LONG_STAT = -61,8031

The problem is
ogc:PropertyIsEqualTo 
matchCase=trueogc:PropertyNameLONG_STAT/ogc:PropertyNameogc:Literal-61,8031/ogc:Literal/ogc:PropertyIsEqualTo,
 crash with this error
 ows:Exception exceptionCode=NoApplicableCode locator=mapserv
ows:ExceptionTextmsWFSGetFeature(): WFS server error. 
FLTApplyFilterToLayer() failed
msOracleSpatialLayerWhichShapes(): OracleSpatial error. Check your data 
statement and server logs/ows:ExceptionText
  /ows:Exception

But, using LIKE it Works ...Probably because it convert the value as a string
ogc:PropertyIsLike matchCase=true wildCard=* singleChar=. 
escapeChar=!ogc:PropertyNameLONG_STAT/ogc:PropertyNameogc:Literal*-61,8031*/ogc:Literal/ogc:PropertyIsLike

But why ogc:PropertyIsEqualTo is crashing?




Rahkonen Jukka (MML) 
jukka.rahko...@maanmittauslaitos.fimailto:jukka.rahko...@maanmittauslaitos.fi

2015-05-15 10:05


A
steve.tout...@inspq.qc.camailto:steve.tout...@inspq.qc.ca 
steve.tout...@inspq.qc.camailto:steve.tout...@inspq.qc.ca, Smith, Michael 
ERDC-RDE-CRREL-NH 
michael.sm...@erdc.dren.milmailto:michael.sm...@erdc.dren.mil
cc
MapserverList OSGEO 
mapserver-users@lists.osgeo.orgmailto:mapserver-users@lists.osgeo.org
Objet
Re: [mapserver-users] [EXTERNAL] Re: Mapserver 7+oracle - wfs 
getFeature with filter on numeric field









Hi,

I think that the real trouble is that with certain database and client settings 
the numerical data that is stored into Oracle is not interpreted correctly and 
correct place to fix the issue is somewhere very close to Oracle. Not in making 
GML parser to accept commas or to make WFS string comparisons to work correctly 
with numerical data in Oracle.

GDAL had similar troubles for sure with Finnish, Italian and French locales and 
probably with all the other locales using comma as decimal separator as well. 
In practice it meant for me that GDAL truncated decimal numbers “1234,56” at 
comma “1234”. For many years I used some workarounds but after this GDAL fix it 
has not been necessary any more:
http://trac.osgeo.org/gdal/ticket/5709

I suggest to study the patch “'OCI: force NLS_NUMERIC_CHARACTERS to .  (patch 
by giorgiomugnaini, #5709)'” and consider if it could be applied to the native 
Oracle driver in Mapserver. I guess and hope that Mapserver would recognize the 
datatype correctly if the Oracle layer is configured to read Oracle through OGR 
and GDAL 2.0 is in use.

Perhaps setting environment ALTER SESSION SET NLS_NUMERIC_CHARACTERS = '. ' 
locally before starting Mapserver would be enough but I do not know how and 
where to set it.

-Jukka Rahkonen-


Steve.Toutant wrote:

Is there a documentation that says that it is not?
Folks from gdal list also think that it is not supported...I guess you are 
right. But as I said on the gdal list, many countries are using a comma as a 
decimal separatorwhat other people on the planet do?
Anyway the comma is another problem that I try to manage later..

For now, We have an application that generate and launch spatial queries on 
WFS, matchCase=false by default. Before modifying the code I want to understand 
what is going on
It seems,when using numeric value, that matchCase as no impact in PostGIS, but 
it is important in oracle to be set to true

gml_type = auto, returns double in postgis and oracle, so that is fine
A WFS getFeature with the operator PropertyIsEqualTo AND matchCase=false
using this value -64.225
PostGis: it works
Oracle (from mike's test): it fails...matchCase must be set to true

A WFS getFeature with the operator PropertyIsEqualTo AND matchCase=false
using this value -64,225
PotsGis: not tested
Oracle: it fails...matchCase must be set to true

Is there a reason why, with oracle, matchCase should be set to true when

Re: [mapserver-users] [EXTERNAL] Re: Mapserver 7+oracle - wfs getFeature with filter on numeric field

2015-05-19 Thread Smith, Michael ERDC-RDE-CRREL-NH
It looks like whats happening is that’s being converted into 3 Tokens and the 
oracle driver converts it into a number + comma + number.

The tokenizer is not treating that value as a single value.

Mike

From: steve.tout...@inspq.qc.camailto:steve.tout...@inspq.qc.ca 
steve.tout...@inspq.qc.camailto:steve.tout...@inspq.qc.ca
Date: Tuesday, May 19, 2015 at 11:44 AM
To: Michael Smith 
michael.sm...@erdc.dren.milmailto:michael.sm...@erdc.dren.mil
Cc: Rahkonen Jukka (MML) 
jukka.rahko...@maanmittauslaitos.fimailto:jukka.rahko...@maanmittauslaitos.fi,
 MapserverList OSGEO 
mapserver-users@lists.osgeo.orgmailto:mapserver-users@lists.osgeo.org
Subject: Re: [mapserver-users] [EXTERNAL] Re: Mapserver 7+oracle - wfs 
getFeature with filter on numeric field

here is the mapserver log with ogc:PropertyIsEqualTo 
matchCase=trueogc:PropertyNameLONG_STAT/ogc:PropertyNameogc:Literal-61,8031/ogc:Literal/ogc:PropertyIsEqualTo

msOracleSpatialLayerWhichShapes. Using this Sql to retrieve the data: SELECT 
ID, NO_STAT_CLIM, NO_STAT_FADQ, NOM_STAT, LATI_STAT, LONG_STAT, ALTI_STAT, 
D_DEB, D_FIN, TIMB_MAJ, USAG_MAJ, rownum, GEOM_POIN FROM (select * FROM 
SMDVDP_STAT_METE WHERE EXTRACT(YEAR FROM D_DEB) = 2014) WHERE  ( LONG_STAT = 
-61.00,8031.00 )  AND SDO_FILTER( GEOM_POIN, MDSYS.SDO_GEOMETRY(2003, 
:srid, NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),:ordinates 
),'querytype=window') = 'TRUE'


The problem is
WHERE  ( LONG_STAT = -61.00,8031.00 )



Smith, Michael ERDC-RDE-CRREL-NH 
michael.sm...@erdc.dren.milmailto:michael.sm...@erdc.dren.mil

2015-05-19 09:42


A
steve.tout...@inspq.qc.camailto:steve.tout...@inspq.qc.ca 
steve.tout...@inspq.qc.camailto:steve.tout...@inspq.qc.ca, Rahkonen Jukka 
(MML) 
jukka.rahko...@maanmittauslaitos.fimailto:jukka.rahko...@maanmittauslaitos.fi
cc
MapserverList OSGEO 
mapserver-users@lists.osgeo.orgmailto:mapserver-users@lists.osgeo.org
Objet
Re: [mapserver-users] [EXTERNAL] Re: Mapserver 7+oracle - wfs 
getFeature with filter on numeric field









Steve,

Rerun this with DEBUG 3 on the LAYER and the generated SQL will show up in your 
error logs. Then it should show why the generated sql is not valid.

Mike

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

From: steve.tout...@inspq.qc.camailto:steve.tout...@inspq.qc.ca 
steve.tout...@inspq.qc.camailto:steve.tout...@inspq.qc.ca
Date: Tuesday, May 19, 2015 at 9:37 AM
To: Rahkonen Jukka (MML) 
jukka.rahko...@maanmittauslaitos.fimailto:jukka.rahko...@maanmittauslaitos.fi
Cc: MapserverList OSGEO 
mapserver-users@lists.osgeo.orgmailto:mapserver-users@lists.osgeo.org, 
Michael Smith michael.sm...@erdc.dren.milmailto:michael.sm...@erdc.dren.mil
Subject: Re: [mapserver-users] [EXTERNAL] Re: Mapserver 7+oracle - wfs 
getFeature with filter on numeric field

Thank you all for this discussion.
We had different problems in our use case coming from gdal, mapserv, oracle, 
..
I don't know how gdal should manage this comma issue, but I would like to 
clarify our problem with mapserv and see if something must be done.

Resume
- We use MS7.1 with oraclespatial connection
- gml_type = auto, which returns element name=LONG_STAT minOccurs=0 
type=double/
- matchCase =true
- LONG_STAT = -61,8031

The problem is
ogc:PropertyIsEqualTo 
matchCase=trueogc:PropertyNameLONG_STAT/ogc:PropertyNameogc:Literal-61,8031/ogc:Literal/ogc:PropertyIsEqualTo,
 crash with this error
ows:Exception exceptionCode=NoApplicableCode locator=mapserv
   ows:ExceptionTextmsWFSGetFeature(): WFS server error. 
FLTApplyFilterToLayer() failed
msOracleSpatialLayerWhichShapes(): OracleSpatial error. Check your data 
statement and server logs/ows:ExceptionText
 /ows:Exception

But, using LIKE it Works ...Probably because it convert the value as a string
ogc:PropertyIsLike matchCase=true wildCard=* singleChar=. 
escapeChar=!ogc:PropertyNameLONG_STAT/ogc:PropertyNameogc:Literal*-61,8031*/ogc:Literal/ogc:PropertyIsLike

But why ogc:PropertyIsEqualTo is crashing?


Rahkonen Jukka (MML) 
jukka.rahko...@maanmittauslaitos.fimailto:jukka.rahko...@maanmittauslaitos.fi

2015-05-15 10:05

A
steve.tout...@inspq.qc.camailto:steve.tout...@inspq.qc.ca 
steve.tout...@inspq.qc.camailto:steve.tout...@inspq.qc.ca, Smith, Michael 
ERDC-RDE-CRREL-NH 
michael.sm...@erdc.dren.milmailto:michael.sm...@erdc.dren.mil
cc
MapserverList OSGEO 
mapserver-users@lists.osgeo.orgmailto:mapserver-users@lists.osgeo.org
Objet
Re: [mapserver-users] [EXTERNAL] Re: Mapserver 7+oracle - wfs 
getFeature with filter on numeric field











Hi,

I think that the real trouble is that with certain database and client settings 
the numerical data that is stored into Oracle is not interpreted correctly and 
correct place to fix the issue is somewhere very close to Oracle. Not in making 
GML parser to accept commas or to make WFS string comparisons to work correctly 
with numerical data in Oracle.

GDAL had similar troubles for sure with Finnish

Re: [mapserver-users] [EXTERNAL] Re: Mapserver 7+oracle - wfs getFeature with filter on numeric field

2015-05-19 Thread Smith, Michael ERDC-RDE-CRREL-NH
Steve,

Rerun this with DEBUG 3 on the LAYER and the generated SQL will show up in your 
error logs. Then it should show why the generated sql is not valid.

Mike

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

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

Re: [mapserver-users] [EXTERNAL] Re: Mapserver 7+oracle - wfs getFeature with filter on numeric field

2015-05-19 Thread Smith, Michael ERDC-RDE-CRREL-NH
Jukka,

The issue is not only the NLS format, which would govern the output and how the 
sql is interpreted, but there is also the issue of the lexer which is reading 
the xml request. And that would have to change also.

Its also unclear to me if XML / WFS allows other characters as a decimal 
character. I've yet to find any xsd or guide docs that indicate one way or the 
other.

Mike

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


From: Rahkonen Jukka (MML) 
jukka.rahko...@maanmittauslaitos.fimailto:jukka.rahko...@maanmittauslaitos.fi
Date: Tuesday, May 19, 2015 at 5:08 PM
To: Lime, Steve D (MNIT) 
steve.l...@state.mn.usmailto:steve.l...@state.mn.us, 
steve.tout...@inspq.qc.camailto:steve.tout...@inspq.qc.ca 
steve.tout...@inspq.qc.camailto:steve.tout...@inspq.qc.ca, MapserverList 
OSGEO mapserver-users@lists.osgeo.orgmailto:mapserver-users@lists.osgeo.org
Cc: michael.sm...@erdc.dren.mimailto:michael.sm...@erdc.dren.mi 
michael.sm...@erdc.dren.mimailto:michael.sm...@erdc.dren.mi
Subject: Re: [mapserver-users] [EXTERNAL] Re: Mapserver 7+oracle - wfs 
getFeature with filter on numeric field
Resent-From: Michael Smith 
michael.sm...@usace.army.milmailto:michael.sm...@usace.army.mil

Hi,

Without being a programmer I would like to see what would happen if this source 
file

https://github.com/mapserver/mapserver/blob/branch-7-0/maporaclespatial.c

would be edited around line 571-573:
cmd = alter session set NLS_DATE_FORMAT='-mm-dd hh24:mi:ss';

by adding a new block for setting the decimal and thousands separators for 
output

cmd = alter session set NLS_NUMERIC_CHARACTERS='. '”;

I am not sure of the right syntax. This one works with SQL*Plus and set decimal 
points and space for thousands separator. I think that thousands should be 
without separators but the command seems to require two inputs.

-Jukka Rahkonen-




Lähettäjä: 
mapserver-users-boun...@lists.osgeo.orgmailto:mapserver-users-boun...@lists.osgeo.org
 [mailto:mapserver-users-boun...@lists.osgeo.org] Puolesta Lime, Steve D (MNIT)
Lähetetty: 19. toukokuuta 2015 22:12
Vastaanottaja: steve.tout...@inspq.qc.camailto:steve.tout...@inspq.qc.ca; 
MapserverList OSGEO
Kopio: michael.sm...@erdc.dren.mimailto:michael.sm...@erdc.dren.mi
Aihe: Re: [mapserver-users] [EXTERNAL] Re: Mapserver 7+oracle - wfs getFeature 
with filter on numeric field

Is there somewhere in the capabilities response where a user would declare what 
decimal separators are supported?

From:mapserver-users-boun...@lists.osgeo.orgmailto:mapserver-users-boun...@lists.osgeo.org
 [mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of 
steve.tout...@inspq.qc.camailto:steve.tout...@inspq.qc.ca
Sent: Tuesday, May 19, 2015 2:06 PM
To: MapserverList OSGEO
Cc: michael.sm...@erdc.dren.mimailto:michael.sm...@erdc.dren.mi
Subject: Re: [mapserver-users] [EXTERNAL] Re: Mapserver 7+oracle - wfs 
getFeature with filter on numeric field

It seems to be a bug isn't?
Do you want me to open an issue?
Smith, Michael ERDC-RDE-CRREL-NH 
michael.sm...@erdc.dren.milmailto:michael.sm...@erdc.dren.mil

2015-05-19 12:24

A

steve.tout...@inspq.qc.camailto:steve.tout...@inspq.qc.ca 
steve.tout...@inspq.qc.camailto:steve.tout...@inspq.qc.ca

cc

Rahkonen Jukka (MML) 
jukka.rahko...@maanmittauslaitos.fimailto:jukka.rahko...@maanmittauslaitos.fi,
 MapserverList OSGEO 
mapserver-users@lists.osgeo.orgmailto:mapserver-users@lists.osgeo.org

Objet

Re: [mapserver-users] [EXTERNAL] Re: Mapserver 7+oracle - wfs getFeature with 
filter on numeric field







It looks like whats happening is that’s being converted into 3 Tokens and the 
oracle driver converts it into a number + comma + number.

The tokenizer is not treating that value as a single value.

Mike

From: steve.tout...@inspq.qc.camailto:steve.tout...@inspq.qc.ca 
steve.tout...@inspq.qc.camailto:steve.tout...@inspq.qc.ca
Date: Tuesday, May 19, 2015 at 11:44 AM
To: Michael Smith 
michael.sm...@erdc.dren.milmailto:michael.sm...@erdc.dren.mil
Cc: Rahkonen Jukka (MML) 
jukka.rahko...@maanmittauslaitos.fimailto:jukka.rahko...@maanmittauslaitos.fi,
 MapserverList OSGEO 
mapserver-users@lists.osgeo.orgmailto:mapserver-users@lists.osgeo.org
Subject: Re: [mapserver-users] [EXTERNAL] Re: Mapserver 7+oracle - wfs 
getFeature with filter on numeric field

here is the mapserver log with ogc:PropertyIsEqualTo 
matchCase=trueogc:PropertyNameLONG_STAT/ogc:PropertyNameogc:Literal-61,8031/ogc:Literal/ogc:PropertyIsEqualTo

msOracleSpatialLayerWhichShapes. Using this Sql to retrieve the data: SELECT 
ID, NO_STAT_CLIM, NO_STAT_FADQ, NOM_STAT, LATI_STAT, LONG_STAT, ALTI_STAT, 
D_DEB, D_FIN, TIMB_MAJ, USAG_MAJ, rownum, GEOM_POIN FROM (select * FROM 
SMDVDP_STAT_METE WHERE EXTRACT(YEAR FROM D_DEB) = 2014) WHERE  ( LONG_STAT = 
-61.00,8031.00 )  AND SDO_FILTER( GEOM_POIN, MDSYS.SDO_GEOMETRY(2003, 
:srid, NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),:ordinates 
),'querytype=window') = 'TRUE'


The problem is
WHERE  ( LONG_STAT

Re: [mapserver-users] [EXTERNAL] Re: Mapserver 7+oracle - wfs getFeature with filter on numeric field

2015-05-19 Thread Smith, Michael ERDC-RDE-CRREL-NH
It looks like whats happening is that’s being converted into 3 Tokens and the 
oracle driver converts it into a number + comma + number.

The tokenizer is not treating that value as a single value.

Mike
--
Michael Smith
Remote Sensing/GIS Center
US Army Corps of Engineers
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] [EXTERNAL] Re: Mapserver 7+oracle - wfs getFeature with filter on numeric field

2015-05-14 Thread Smith, Michael ERDC-RDE-CRREL-NH
The matchCase triggers a string comparison. matchCase doesn't seem to make 
sense for a number.

That being said, I can look into the specific case of matchCase and a numeric 
comparison and make sire that it isn't used.

Mike

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


From: steve.tout...@inspq.qc.camailto:steve.tout...@inspq.qc.ca 
steve.tout...@inspq.qc.camailto:steve.tout...@inspq.qc.ca
Date: Thursday, May 14, 2015 at 9:28 AM
To: Michael Smith 
michael.sm...@erdc.dren.milmailto:michael.sm...@erdc.dren.mil
Cc: MapserverList OSGEO 
mapserver-users@lists.osgeo.orgmailto:mapserver-users@lists.osgeo.org, 
thomas bonfort thomas.bonf...@gmail.commailto:thomas.bonf...@gmail.com
Subject: Re: [EXTERNAL] Re: [mapserver-users] Mapserver 7+oracle - wfs 
getFeature with filter on numeric field

Is there a documentation that says that it is not?
Folks from gdal list also think that it is not supported...I guess you are 
right. But as I said on the gdal list, many countries are using a comma as a 
decimal separatorwhat other people on the planet do?
Anyway the comma is another problem that I try to manage later..

For now, We have an application that generate and launch spatial queries on 
WFS, matchCase=false by default. Before modifying the code I want to understand 
what is going on
It seems,when using numeric value, that matchCase as no impact in PostGIS, but 
it is important in oracle to be set to true

gml_type = auto, returns double in postgis and oracle, so that is fine
A WFS getFeature with the operator PropertyIsEqualTo AND matchCase=false
using this value -64.225
PostGis: it works
Oracle (from mike's test): it fails...matchCase must be set to true

A WFS getFeature with the operator PropertyIsEqualTo AND matchCase=false
using this value -64,225
PotsGis: not tested
Oracle: it fails...matchCase must be set to true

Is there a reason why, with oracle, matchCase should be set to true when using 
numeric value, or that could be fixed?
Regards
Steve



Smith, Michael ERDC-RDE-CRREL-NH 
michael.sm...@erdc.dren.milmailto:michael.sm...@erdc.dren.mil

2015-05-14 09:17


A
steve.tout...@inspq.qc.camailto:steve.tout...@inspq.qc.ca 
steve.tout...@inspq.qc.camailto:steve.tout...@inspq.qc.ca
cc
MapserverList OSGEO 
mapserver-users@lists.osgeo.orgmailto:mapserver-users@lists.osgeo.org, 
thomas bonfort thomas.bonf...@gmail.commailto:thomas.bonf...@gmail.com
Objet
Re: [EXTERNAL] Re: [mapserver-users] Mapserver 7+oracle - wfs 
getFeature with filter on numeric field









Its not clear to me that commas as the decimal separator is supported in 
XML/GML. I can't find any documentation to indicate that it is. Can you point 
some out to me?

In any event, I didn't test with comma decimal separators.

Mike



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


From: steve.tout...@inspq.qc.camailto:steve.tout...@inspq.qc.ca 
steve.tout...@inspq.qc.camailto:steve.tout...@inspq.qc.ca
Date: Thursday, May 14, 2015 at 8:54 AM
To: Michael Smith 
michael.sm...@erdc.dren.milmailto:michael.sm...@erdc.dren.mil
Cc: MapserverList OSGEO 
mapserver-users@lists.osgeo.orgmailto:mapserver-users@lists.osgeo.org, 
thomas bonfort thomas.bonf...@gmail.commailto:thomas.bonf...@gmail.com
Subject: Re: [EXTERNAL] Re: [mapserver-users] Mapserver 7+oracle - wfs 
getFeature with filter on numeric field

Thanks Mike for having a look at it.
Your decimals are separated by a comma or a dot?


Smith, Michael ERDC-RDE-CRREL-NH 
michael.sm...@erdc.dren.milmailto:michael.sm...@erdc.dren.mil

2015-05-13 18:53

A
steve.tout...@inspq.qc.camailto:steve.tout...@inspq.qc.ca 
steve.tout...@inspq.qc.camailto:steve.tout...@inspq.qc.ca, thomas bonfort 
thomas.bonf...@gmail.commailto:thomas.bonf...@gmail.com
cc
MapserverList OSGEO 
mapserver-users@lists.osgeo.orgmailto:mapserver-users@lists.osgeo.org
Objet
Re: [EXTERNAL] Re: [mapserver-users] Mapserver 7+oracle - wfs 
getFeature with filter on numeric field











Steve,

I tested this out with 7.1 with numeric type fields and it works for me as long 
as I don't use matchCase=false. That seems to kick it in to a string 
comparison. matchCase=true and just PropertyIsEqualTo work fine.

In our metadata we use gml_types   auto when the database knows the types 
and explicit declarations (eg gml_attributename_type   integer) when it 
doesn't work.

The key is that the field type has to report as a numeric type or the backend 
treats it as a string comparison.

Mike

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


From: steve.tout...@inspq.qc.camailto:steve.tout...@inspq.qc.ca 
steve.tout...@inspq.qc.camailto:steve.tout...@inspq.qc.ca
Date: Wednesday, May 13, 2015 at 10:35 AM
To: thomas bonfort thomas.bonf...@gmail.commailto:thomas.bonf...@gmail.com
Cc: MapserverList OSGEO

Re: [mapserver-users] [EXTERNAL] Re: Mapserver 7+oracle - wfs getFeature with filter on numeric field

2015-05-14 Thread Smith, Michael ERDC-RDE-CRREL-NH
Its not clear to me that commas as the decimal separator is supported in 
XML/GML. I can't find any documentation to indicate that it is. Can you point 
some out to me?

In any event, I didn't test with comma decimal separators.

Mike



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


From: steve.tout...@inspq.qc.camailto:steve.tout...@inspq.qc.ca 
steve.tout...@inspq.qc.camailto:steve.tout...@inspq.qc.ca
Date: Thursday, May 14, 2015 at 8:54 AM
To: Michael Smith 
michael.sm...@erdc.dren.milmailto:michael.sm...@erdc.dren.mil
Cc: MapserverList OSGEO 
mapserver-users@lists.osgeo.orgmailto:mapserver-users@lists.osgeo.org, 
thomas bonfort thomas.bonf...@gmail.commailto:thomas.bonf...@gmail.com
Subject: Re: [EXTERNAL] Re: [mapserver-users] Mapserver 7+oracle - wfs 
getFeature with filter on numeric field

Thanks Mike for having a look at it.
Your decimals are separated by a comma or a dot?




Smith, Michael ERDC-RDE-CRREL-NH 
michael.sm...@erdc.dren.milmailto:michael.sm...@erdc.dren.mil

2015-05-13 18:53


A
steve.tout...@inspq.qc.camailto:steve.tout...@inspq.qc.ca 
steve.tout...@inspq.qc.camailto:steve.tout...@inspq.qc.ca, thomas bonfort 
thomas.bonf...@gmail.commailto:thomas.bonf...@gmail.com
cc
MapserverList OSGEO 
mapserver-users@lists.osgeo.orgmailto:mapserver-users@lists.osgeo.org
Objet
Re: [EXTERNAL] Re: [mapserver-users] Mapserver 7+oracle - wfs 
getFeature with filter on numeric field









Steve,

I tested this out with 7.1 with numeric type fields and it works for me as long 
as I don't use matchCase=false. That seems to kick it in to a string 
comparison. matchCase=true and just PropertyIsEqualTo work fine.

In our metadata we use gml_types   auto when the database knows the types 
and explicit declarations (eg gml_attributename_type   integer) when it 
doesn't work.

The key is that the field type has to report as a numeric type or the backend 
treats it as a string comparison.

Mike

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


From: steve.tout...@inspq.qc.camailto:steve.tout...@inspq.qc.ca 
steve.tout...@inspq.qc.camailto:steve.tout...@inspq.qc.ca
Date: Wednesday, May 13, 2015 at 10:35 AM
To: thomas bonfort thomas.bonf...@gmail.commailto:thomas.bonf...@gmail.com
Cc: MapserverList OSGEO 
mapserver-users@lists.osgeo.orgmailto:mapserver-users@lists.osgeo.org
Subject: [EXTERNAL] Re: [mapserver-users] Mapserver 7+oracle - wfs getFeature 
with filter on numeric field
Resent-From: Michael Smith 
michael.sm...@usace.army.milmailto:michael.sm...@usace.army.mil

Precision: we are using MS7.1
Removing matchcase part makes oracle, and postgis, crash.
I have this error:

ows:ExceptionReport 
xmlns:xsi=http://www.w3.org/2001/XMLSchema-instancehttp://www.google.com/url?q=http%3A%2F%2Fwww.w3.org%2F2001%2FXMLSchema-instancesa=Dsntz=1usg=AFQjCNFERp6A_kcvqihMCKJ7EHX8O14vIA
 
xmlns:ows=http://www.opengis.net/owshttp://www.google.com/url?q=http%3A%2F%2Fwww.opengis.net%2Fowssa=Dsntz=1usg=AFQjCNE9_q7eSkcBl4XJimXTw1Zx0EiDow
 version=1.1.0 
language=en-USxsi:schemaLocation=http://www.opengis.net/ows 
/ahttp://www.google.com/url?q=http%3A%2F%2Fwww.opengis.net%2Fowssa=Dsntz=1usg=AFQjCNE9_q7eSkcBl4XJimXTw1Zx0EiDowhttp://schemas.opengis.net/ows/1.0.0/owsExceptionReport.xsdhttp://www.google.com/url?q=http%3A%2F%2Fschemas.opengis.net%2Fows%2F1.0.0%2FowsExceptionReport.xsdsa=Dsntz=1usg=AFQjCNGmnK6iSrh-cSWEtM2VV17uuSbVNA
ows:Exception exceptionCode=NoApplicableCode locator=mapserv
ows:ExceptionText
msWFSGetFeature(): WFS server error. FLTApplyFilterToLayer() failed 
msOracleSpatialLayerWhichShapes(): OracleSpatial error. Check your data 
statement and server logs
/ows:ExceptionText


The problem might be the decimals?
Here is the request
wfs:Query typeName=feature:SMDVDP_STAT_METE srsName=EPSG:32198
ogc:Filter xmlns:ogc=http://www.opengis.net/ogc;
ogc:PropertyIsEqualTo
ogc:PropertyNameLONG_STAT/ogc:PropertyName
ogc:Literal-61,8031/ogc:Literal
/ogc:PropertyIsEqualTo
/ogc:Filter
/wfs:Query
/wfs:GetFeature


thomas bonfort thomas.bonf...@gmail.commailto:thomas.bonf...@gmail.com

2015-05-13 05:40

A
steve.tout...@inspq.qc.camailto:steve.tout...@inspq.qc.ca
cc
MapserverList OSGEO 
mapserver-users@lists.osgeo.orgmailto:mapserver-users@lists.osgeo.org
Objet
Re: [mapserver-users] Mapserver 7+oracle - wfs getFeature with filter 
on numeric field











can you try the same request without the matchCase part and report
back please?

On 12 May 2015 at 18:11,  
steve.tout...@inspq.qc.camailto:steve.tout...@inspq.qc.ca wrote:
 I have a problem using a FILTER in a wfs getFeature request on an oracle DB
 with MS7
 When I launch a getFeature request with a Filter on a numeric field it
 doesn't work,
 ogc:Filter xmlns:ogc=http://www.opengis.net/ogc;ogc:PropertyIsEqualTo
 matchCase=falseogc:PropertyNameLONG_STAT/ogc:PropertyNameogc:Literal-61/ogc:Literal

Re: [mapserver-users] [EXTERNAL] Re: Mapserver 7+oracle - wfs getFeature with filter on numeric field

2015-05-13 Thread Smith, Michael ERDC-RDE-CRREL-NH
Steve,

I tested this out with 7.1 with numeric type fields and it works for me as long 
as I don't use matchCase=false. That seems to kick it in to a string 
comparison. matchCase=true and just PropertyIsEqualTo work fine.

In our metadata we use gml_types   auto when the database knows the types 
and explicit declarations (eg gml_attributename_type   integer) when it 
doesn't work.

The key is that the field type has to report as a numeric type or the backend 
treats it as a string comparison.

Mike

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


From: steve.tout...@inspq.qc.camailto:steve.tout...@inspq.qc.ca 
steve.tout...@inspq.qc.camailto:steve.tout...@inspq.qc.ca
Date: Wednesday, May 13, 2015 at 10:35 AM
To: thomas bonfort thomas.bonf...@gmail.commailto:thomas.bonf...@gmail.com
Cc: MapserverList OSGEO 
mapserver-users@lists.osgeo.orgmailto:mapserver-users@lists.osgeo.org
Subject: [EXTERNAL] Re: [mapserver-users] Mapserver 7+oracle - wfs getFeature 
with filter on numeric field
Resent-From: Michael Smith 
michael.sm...@usace.army.milmailto:michael.sm...@usace.army.mil

Precision: we are using MS7.1
Removing matchcase part makes oracle, and postgis, crash.
I have this error:

ows:ExceptionReport 
xmlns:xsi=http://www.w3.org/2001/XMLSchema-instancehttp://www.google.com/url?q=http%3A%2F%2Fwww.w3.org%2F2001%2FXMLSchema-instancesa=Dsntz=1usg=AFQjCNFERp6A_kcvqihMCKJ7EHX8O14vIA
 
xmlns:ows=http://www.opengis.net/owshttp://www.google.com/url?q=http%3A%2F%2Fwww.opengis.net%2Fowssa=Dsntz=1usg=AFQjCNE9_q7eSkcBl4XJimXTw1Zx0EiDow
 version=1.1.0 
language=en-USxsi:schemaLocation=http://www.opengis.net/ows 
/ahttp://www.google.com/url?q=http%3A%2F%2Fwww.opengis.net%2Fowssa=Dsntz=1usg=AFQjCNE9_q7eSkcBl4XJimXTw1Zx0EiDowhttp://schemas.opengis.net/ows/1.0.0/owsExceptionReport.xsdhttp://www.google.com/url?q=http%3A%2F%2Fschemas.opengis.net%2Fows%2F1.0.0%2FowsExceptionReport.xsdsa=Dsntz=1usg=AFQjCNGmnK6iSrh-cSWEtM2VV17uuSbVNA
ows:Exception exceptionCode=NoApplicableCode locator=mapserv
ows:ExceptionText
msWFSGetFeature(): WFS server error. FLTApplyFilterToLayer() failed 
msOracleSpatialLayerWhichShapes(): OracleSpatial error. Check your data 
statement and server logs
/ows:ExceptionText


The problem might be the decimals?
Here is the request
wfs:Query typeName=feature:SMDVDP_STAT_METE srsName=EPSG:32198
ogc:Filter xmlns:ogc=http://www.opengis.net/ogc;
ogc:PropertyIsEqualTo
ogc:PropertyNameLONG_STAT/ogc:PropertyName
ogc:Literal-61,8031/ogc:Literal
/ogc:PropertyIsEqualTo
/ogc:Filter
/wfs:Query
/wfs:GetFeature




thomas bonfort thomas.bonf...@gmail.commailto:thomas.bonf...@gmail.com

2015-05-13 05:40


A
steve.tout...@inspq.qc.camailto:steve.tout...@inspq.qc.ca
cc
MapserverList OSGEO 
mapserver-users@lists.osgeo.orgmailto:mapserver-users@lists.osgeo.org
Objet
Re: [mapserver-users] Mapserver 7+oracle - wfs getFeature with filter 
on numeric field









can you try the same request without the matchCase part and report
back please?

On 12 May 2015 at 18:11,  
steve.tout...@inspq.qc.camailto:steve.tout...@inspq.qc.ca wrote:
 I have a problem using a FILTER in a wfs getFeature request on an oracle DB
 with MS7
 When I launch a getFeature request with a Filter on a numeric field it
 doesn't work,
 ogc:Filter xmlns:ogc=http://www.opengis.net/ogc;ogc:PropertyIsEqualTo
 matchCase=falseogc:PropertyNameLONG_STAT/ogc:PropertyNameogc:Literal-61/ogc:Literal/ogc:PropertyIsEqualTo/ogc:Filter
 here is the error we get in the browser
 ows:Exception exceptionCode=NoApplicableCode locator=mapserv
ows:ExceptionTextmsWFSGetFeature(): WFS server error.
 FLTApplyFilterToLayer() failed
 msOracleSpatialLayerWhichShapes(): OracleSpatial error. Check your data
 statement and server logs/ows:ExceptionText

 from mapserver logs
 [Tue May 12 11:59:10 2015].177992 msOracleSpatialLayerTranslateFilter.
 String:  ([LONG_STAT] =*-61)

 LONG_STAT is a NUMBER in the DB
 DescribefeatureType returns
   element name=NO_STAT_CLIM minOccurs=0 type=string/
  element name=NO_STAT_FADQ minOccurs=0 type=string/
  element name=NOM_STAT minOccurs=0 type=string/
  element name=LATI_STAT minOccurs=0 type=string/
  element name=LONG_STAT minOccurs=0 type=string/
  element name=ALTI_STAT minOccurs=0 type=string/

 I tried to add gml_types auto in the mapfile, but it still returns
 string as data type
 I tried gml_LONG_STAT_type = Integer in the mapfile, describeFeatureType
 returns element name=LONG_STAT minOccurs=0 type=double/  but I
 still get an error in getFeature

 I'm using CONNECTIONTYPE oraclespatial in the mapfile

 I can provide more information

 Is it a known issue or can I do something about that?

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




Re: [mapserver-users] [EXTERNAL] MS7 wfs

2015-03-12 Thread Smith, Michael ERDC-RDE-CRREL-NH
One side note, you can set

wfs_compute_number_matched false

In the LAYER METADATA section to disable this.

See http://mapserver.org/development/rfc/ms-rfc-105.html for details.



Michael Smith

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





From:  steve.tout...@inspq.qc.ca steve.tout...@inspq.qc.ca
Date:  Thursday, March 12, 2015 at 3:19 PM
To:  mapserver-users@lists.osgeo.org mapserver-users@lists.osgeo.org
Subject:  [EXTERNAL] [mapserver-users] MS7 wfs
Resent-From:  Michael Smith michael.sm...@usace.army.mil


hello 
Using mapserver 7 I make this request to get the number of features in a
WFS layer. it returns
numberOfFeatures=450361
http://localhost/cgi-bin/ms7?version=1.1.0request=getfeatureservice=wfst
ypename=feature:aqreseauresultType=hits
http://localhost/geo/cgi-bin/testwps65?version=1.1.0request=getfeaturese
rvice=wfstypename=feature:aqreseauresultType=hits

this layer is a postgis table on localhost.
This request takes 18 seconds to run with mapserver 7
in postgis select count(*) from  table takes 61ms to run
the same request using a geoserver WFS takes less than 1 second

Is there something that can be done with MS7 to improve performance?
thanks 


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


Re: [mapserver-users] [EXTERNAL] Re: the lines one above other

2015-02-12 Thread Smith, Michael ERDC-RDE-CRREL-NH
This is also not an issue in Oracle.

M

On 2/12/15, 8:55 AM, thomas bonfort thomas.bonf...@gmail.com wrote:

Actually there is an issue opened for this, as the order by inside the
subquery is not guaranteed to be maintained in the outer query:
https://github.com/mapserver/mapserver/issues/5008 . For mssql there
has been a patch applied, for postgis it is not needed yet.

On 12 February 2015 at 08:48, Smith, Michael ERDC-RDE-CRREL-NH
michael.sm...@erdc.dren.mil wrote:
 No, MapServer respects the feature order. Using the ORDER BY with a
 database connection, MapServer will draw features in that order.

 Mike

 --
 Michael Smith

 US Army Corps
 Remote Sensing GIS/Center



 On 2/12/15, 7:52 AM, Eichner, Andreas - SID
 andreas.eich...@sid.sachsen.de wrote:

I'm not sure about this but AFAIK MapServer draws features in the order
they are returned by the query. For Shapefiles there is the sortshp
utility. If you're on a relational database like PostGIS or
OracleSpatial
you can try including the ORDER BY prio within the DATA. But since MS
wraps it into a subquery the database might still return the features
out
of order.

 -Ursprüngliche Nachricht-
 Von: mapserver-users-boun...@lists.osgeo.org [mailto:mapserver-users-
 boun...@lists.osgeo.org] Im Auftrag von Vladimir
 Gesendet: Donnerstag, 12. Februar 2015 12:02
 An: mapserver-users@lists.osgeo.org
 Betreff: [mapserver-users] the lines one above other

 Hello All!



 The task is to show multilevel junction of highway.
 The lines should be at the same layer and has the same style, for
example
 see orange lines on attached pic:
 [img]http://s14.postimg.org/yk40e0nq9/crossroad.jpg[/img]
 Is it possible to draw the lines one above other by an one layer?
 May be some method of Z-index for features in a layer exists?
 Thanks for any guidance to display this kind of crossroads.

 Vladimir
___
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] [EXTERNAL] Re: the lines one above other

2015-02-12 Thread Smith, Michael ERDC-RDE-CRREL-NH
No, MapServer respects the feature order. Using the ORDER BY with a
database connection, MapServer will draw features in that order.

Mike

-- 
Michael Smith

US Army Corps
Remote Sensing GIS/Center



On 2/12/15, 7:52 AM, Eichner, Andreas - SID
andreas.eich...@sid.sachsen.de wrote:

I'm not sure about this but AFAIK MapServer draws features in the order
they are returned by the query. For Shapefiles there is the sortshp
utility. If you're on a relational database like PostGIS or OracleSpatial
you can try including the ORDER BY prio within the DATA. But since MS
wraps it into a subquery the database might still return the features out
of order. 

 -Ursprüngliche Nachricht-
 Von: mapserver-users-boun...@lists.osgeo.org [mailto:mapserver-users-
 boun...@lists.osgeo.org] Im Auftrag von Vladimir
 Gesendet: Donnerstag, 12. Februar 2015 12:02
 An: mapserver-users@lists.osgeo.org
 Betreff: [mapserver-users] the lines one above other
 
 Hello All!
 
 
 
 The task is to show multilevel junction of highway.
 The lines should be at the same layer and has the same style, for
example
 see orange lines on attached pic:
 [img]http://s14.postimg.org/yk40e0nq9/crossroad.jpg[/img]
 Is it possible to draw the lines one above other by an one layer?
 May be some method of Z-index for features in a layer exists?
 Thanks for any guidance to display this kind of crossroads.
 
 Vladimir
___
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] WMS SRS as variable

2015-02-06 Thread Smith, Michael ERDC-RDE-CRREL-NH
Lars,

A WMS map can support multiple SRS's. Just list all the ones you want in the 
METADATA block. Look at http://mapserver.org/ogc/wms_server.html and 
specifically the Map PROJECTION and wms_srs metadata. From the example, you can 
see that 2 SRS's are supported.


 METADATA
wms_title   WMS Demo Server
wms_onlineresource  http://my.host.com/cgi-bin/mapserv?map=wms.map;
wms_srs EPSG:4269 EPSG:4326
  END

Just keep adding to the list to support more projections.

Mike


From: Schylberg Lars 
lars.schylb...@saabgroup.commailto:lars.schylb...@saabgroup.com
Date: Friday, February 6, 2015 at 10:05 AM
To: mapserver-users@lists.osgeo.orgmailto:mapserver-users@lists.osgeo.org 
mapserver-users@lists.osgeo.orgmailto:mapserver-users@lists.osgeo.org
Subject: [EXTERNAL] [mapserver-users] WMS SRS as variable
Resent-From: Michael Smith 
michael.sm...@usace.army.milmailto:michael.sm...@usace.army.mil

Hello,

I wonder if there is a way to set SRS as a variable in a map file.

I have one map file that uses several other WMS clients that also are mapfiles.
I would like to use the SRS as variable to make the WMS service more flexible.

I have tried to do VALIDATION on SRS variable, but that only gives errors.

Thanks /Lars S.

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

Re: [mapserver-users] [EXTERNAL] (no subject)

2015-01-12 Thread Smith, Michael ERDC-RDE-CRREL-NH
Ahmet,

You can use shp2img to test geojson outputformat. Just use the -i switch
to set to your named output format.

Mike



From:  Ahmet Temiz ahmettemi...@gmail.com
Date:  Saturday, January 10, 2015 at  11:58 AM
To:  mapserver-users mapserver-users@lists.osgeo.org
Subject:  [EXTERNAL] [mapserver-users] (no subject)
Resent-From:  Michael Smith michael.sm...@usace.army.mil


hello

I just want to test outputformat geojson ?
Is there any tool like shp2img to test geojson output ?

regards

-- 
Ahmet Temiz
Jeoloji Müh.
Afet ve Acil Durum Yönetimi Başkanlığı
Planlama ve Zarar Azaltma Dairesi Başkanlığı




Ahmet Temiz
Geological Eng.
Information Systems - GIS Group
Disaster and Emergency Management
of Presidency

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

Re: [mapserver-users] [EXTERNAL] Re: How can I read Z coordinates in a shape file ?

2015-01-08 Thread Smith, Michael ERDC-RDE-CRREL-NH
The line in MapServer to show Z_M support is SUPPORTS=POINT_Z_M.

Here's an example that shows WFS output with Z Values:
http://geo.usace.army.mil/cgi-bin/wms/nldwfs?service=wfsversion=1.1.0requ
est=getfeaturetypename=leveesclosurestructurelnmaxfeatures=10outputforma
t=gml3d

Note that this uses a specific outputformat that is an OGR outputformat
with the ows_geomtype in the Layer metadata set to LineString25D.

Mike

-- 
Michael Smith

US Army Corps
Remote Sensing GIS/Center




On 1/8/15, 5:26 AM, Rahkonen Jukka (MML)
jukka.rahko...@maanmittauslaitos.fi wrote:

Hi,

I would first check that your Mapserver is compiled with Z/M coordinate
support which is required by reading the document
http://mapserver.org/output/ogr_output.html . However, I have never
played with 25D/3D geometries with Mapserver and I have no idea how to
check if the Z_M support is compiled in. Perhaps there would be something
about that in the comment line of GetCapabilities which typically shows
something like MapServer version 6.4.0 OUTPUT=GIF OUTPUT=PNG OUTPUT=JPEG
SUPPORTS=PROJ ...

Excerpt from the WFS server manual:

ows/wfs_geomtype

(Optional) Set the geometry type of OGR layers created from this
MapServer LAYER. One of Point, LineString, Polygon, MultiPoint,
MultiLineString, MultiPolygon, GeometryCollection, Geometry, or
None. Most are fairly obvious, but Geometry can be used to represent
a mix of geometry types, and None is sometimes suitable for layers
without geometry. Note that layers which are a mix of polygon and
multipolygon would normally have to be described as Geometry. To
produce 2.5D output append 25D to the geometry type (ie. Polygon25D).
Note that Z values are only carried by MapServer if built with
USE_POINT_Z_M support.

I would guess that it is OK in your case because you must have read the
documentation well before getting as far as you are now.
My next guess is that perhaps   'wfs_getfeature_formatlist' 'OGRGML' does
not remove the default outputformat which is mandated by the WFS standard
and which is GML2 for WFS version 1.0.0. In that case, if you are lucky,
the problem may be solved by asking Mapserver explicitly use your
tailored outputformat by adding OUTPUTFORMAT=OGRGML. If Mapserver
behaves as it should you can check the GetCapabilities document and read
the list of available formats from the ResultFormat section. For example
this server supports only the default GML2
http://demo.mapserver.org/cgi-bin/wfs?SERVICE=WFSVERSION=1.0.0REQUEST=Ge
tCapabilities.

Despite being the last thing on my short list reading carefully the
GetCapabilities document is actually the thing that should always be done
first if there are some troubles with WMS/WFS/WCS services.


-Jukka Rahkonen-




Heyser Sylvain wrote:
 
 Dear Mapserver community,

 I try to read the value of the Z coordinate in an Esri Shape file
without success.

 I want to get the Z values through an url request (WFS) like this :
http://my_server_ip/cgi-bin/mapserv?map=/var/www/data/mapfile.mapSERVICE=
WFSVERSION=1.0.0REQUEST=GetFeatureSRS=EPSG:3163BBOX=458692.315380274,3
94716.36951207,460607.98862158,395413.707691068TYPENAME=Piste

 But I only get output data without Z values.
gml:featureMemberms:Piste fid=Piste.1gml:boundedBygml:Box
srsName=EPSG:3163gml:coordinates459689.471118,394821.251944
459699.341118,394828.476944/gml:coordinates/gml:Box/gml:boundedByms
:msGeometrygml:LineString
srsName=EPSG:3163gml:coordinates459699.341118,394821.251944
459693.717118,394828.476944 459689.471118,394825.098944
/gml:coordinates/gml:LineString/ms:msGeometryms:PISTAER_ID1/ms:PI
STAER_ID/ms:Piste/gml:featureMembergml:featureMember


 The OGRINFO of the data is :
Layer name: PISTAERO_line
Geometry: 3D Line String
Feature Count: 2
Extent: (459349.927521, 394583.151000) - (460037.901778, 395483.896917)
Layer SRS WKT:
(unknown)
PISTAER_ID: Integer (5.0)

I have configure my map file as follow :
MAP
 NAME DACDEV_map
 STATUS ON
 SIZE 900 700
 EXTENT 15 15 65 65
 UNITS METERS
 SHAPEPATH shape
 IMAGECOLOR 255 255 0
 SYMBOLSET symbols-dac.sym
 PROJECTION
 'init=epsg:3163'
 END

 CONFIG 'MS_ERRORFILE' '/var/www/tmp/ms_error.log'

 OUTPUTFORMAT
 NAME OGRGML
 DRIVER OGR/GML
 FORMATOPTION STORAGE=filesystem
 FORMATOPTION FORM=multipart
 FORMATOPTION FILENAME=/var/www/tmp/result.gml
 END

 WEB
 TEMPLATE template.html
 IMAGEPATH /var/www/tmp/
 IMAGEURL /tmp/
 METADATA
 'wms_title'   'DAC_DATA'
 'wms_srs' 'EPSG:3163'
 'wfs_title'   'DEMO'
 'wfs_olineressource' 'http://192.168.10.108/cgi-bin/mapserv?'
 'wfs_srs' 'EPSG:3163'
 'wfs_enable_request'  '*'
 END
 END

LAYER
 NAME Piste
 DEBUG 5
 METADATA
 'wfs_title'   'Piste'
 'wfs_srs' 

Re: [mapserver-users] [EXTERNAL] KML output with blank point

2015-01-08 Thread Smith, Michael ERDC-RDE-CRREL-NH
Dietmar,

Make sure your IMAGEURL is set to a Fully Qualified URL. Otherwise mapserver 
will not set the full URL to your point images.

Mike

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

From: Dietmar Stolz dietmar.st...@freenet.demailto:dietmar.st...@freenet.de
Date: Thursday, January 8, 2015 at 5:40 AM
To: mapserver-users@lists.osgeo.orgmailto:mapserver-users@lists.osgeo.org 
mapserver-users@lists.osgeo.orgmailto:mapserver-users@lists.osgeo.org
Subject: [EXTERNAL] [mapserver-users] KML output with blank point
Resent-From: Michael Smith 
michael.sm...@usace.army.milmailto:michael.sm...@usace.army.mil

Dear list,

I still have a problem with kml output.
My kml output basically works.
Everything works fine with line and polygon type, I get correct kml files.
Point layers works also but mapserver generated blank png's.

The bitmap exist in the right directory with the right size.
The url path in the kml file is right.
I can see the kml point layer in the gis, the points have tooltips and are 
clickable.
The bitmaps have 24 bpp.
Pixmap or vector layer symbols makes no difference.

Debug 5 shows no error and no kml specific information.

MapServer version 6.4.1 on windows 7 64 bit

...
OUTPUTFORMAT
  NAME kml
  DRIVER KML
  MIMETYPE application/vnd.google-earth.kml+xml
  IMAGEMODE RGB
  EXTENSION kml
  FORMATOPTION STORAGE=memory
  FORMATOPTION FORM=simple
 END
...

 LAYER
# DEBUG 5
  NAME point
  TYPE POINT
  DATA kml_test.shp
  METADATA
   ows_title test
   ows_abstract test
   KML_DESCRIPTION test
   KML_NAME_ITEM TEXT
   # wfs_getfeature_formatlist text/csv,gml,geojson,xml,kml
   # KML_OUTPUTASRASTER true
  END
  CLASS
STYLE
 SYMBOL point
 SIZE 36
 COLOR 255 0 0
 OUTLINECOLOR 0 255 0
END
  END
 END
...

SYMBOL
  NAME point
  TYPE ELLIPSE
  POINTS
10 10
  END
  FILLED TRUE
END


KML-Output:

?xml version=1.0 encoding=UTF-8?
kml xmlns=http://www.opengis.net/kml/2.2;http://www.opengis.net/kml/2.2
  Document
Style id=LayerFolder_check
  ListStyle
listItemTypecheck/listItemType
  /ListStyle
/Style
Style id=LayerFolder_checkHideChildren
  ListStyle
listItemTypecheckHideChildren/listItemType
  /ListStyle
/Style
Style id=LayerFolder_checkOffOnly
  ListStyle
listItemTypecheckOffOnly/listItemType
  /ListStyle
/Style
Style id=LayerFolder_radioFolder
  ListStyle
listItemTyperadioFolder/listItemType
  /ListStyle
/Style
nameOsthessenNetz/name
Style id=style_symbol_point_3.6_ffff
  IconStyle
Icon
  hrefhttp://localhost/gistemp/54ae5c24_4474_0.png/href
/Icon
  /IconStyle
/Style
Folder
  namepoint/name
  visibility1/visibility
  styleUrl#LayerFolder_check/styleUrl
  Placemark
namepoint.0/name
styleUrl#style_symbol_point_3.6_ffff/styleUrl
descriptiontest/description
Point
  coordinates
9.73281948,50.58202641
/coordinates
/Point
  /Placemark
/Folder
  /Document
/kml

Any ideas?

Thank you

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

Re: [mapserver-users] [EXTERNAL] KML output with blank point

2015-01-08 Thread Smith, Michael ERDC-RDE-CRREL-NH
Please always reply back to the list so others can benefit.

If all your images are empty, then there is something up with your symbol 
rendering. Do you get valid symbols if you generate an map image without kml 
output?

I've had no problem with vector and bitmap point symbols in KML output. But the 
images rendered to the tmp directory render correctly so that is where your 
problem lies.

Mike

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

From: Dietmar Stolz dietmar.st...@freenet.demailto:dietmar.st...@freenet.de
Date: Thursday, January 8, 2015 at 8:22 AM
To: Michael Smith 
michael.sm...@erdc.dren.milmailto:michael.sm...@erdc.dren.mil
Subject: Re: [EXTERNAL] [mapserver-users] KML output with blank point

Thanks Mike,

IMAGEURL is ok, the paths is already an absolute:


Style id=style_symbol_point_3.6_ffff
  IconStyle
Icon
  hrefhttp://localhost/gistemp/54ae5c24_4474_0.png/href
/Icon
  /IconStyle
/Style

I can fetch the icon via browser.
The icon is rendered but the image itself is blank.

Dietmar

Am 08.01.2015 um 13:09 schrieb Smith, Michael ERDC-RDE-CRREL-NH:
Dietmar,

Make sure your IMAGEURL is set to a Fully Qualified URL. Otherwise mapserver 
will not set the full URL to your point images.

Mike

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

From: Dietmar Stolz dietmar.st...@freenet.demailto:dietmar.st...@freenet.de
Date: Thursday, January 8, 2015 at 5:40 AM
To: mapserver-users@lists.osgeo.orgmailto:mapserver-users@lists.osgeo.org 
mapserver-users@lists.osgeo.orgmailto:mapserver-users@lists.osgeo.org
Subject: [EXTERNAL] [mapserver-users] KML output with blank point
Resent-From: Michael Smith 
michael.sm...@usace.army.milmailto:michael.sm...@usace.army.mil

Dear list,

I still have a problem with kml output.
My kml output basically works.
Everything works fine with line and polygon type, I get correct kml files.
Point layers works also but mapserver generated blank png's.

The bitmap exist in the right directory with the right size.
The url path in the kml file is right.
I can see the kml point layer in the gis, the points have tooltips and are 
clickable.
The bitmaps have 24 bpp.
Pixmap or vector layer symbols makes no difference.

Debug 5 shows no error and no kml specific information.

MapServer version 6.4.1 on windows 7 64 bit

...
OUTPUTFORMAT
  NAME kml
  DRIVER KML
  MIMETYPE application/vnd.google-earth.kml+xml
  IMAGEMODE RGB
  EXTENSION kml
  FORMATOPTION STORAGE=memory
  FORMATOPTION FORM=simple
 END
...

 LAYER
# DEBUG 5
  NAME point
  TYPE POINT
  DATA kml_test.shp
  METADATA
   ows_title test
   ows_abstract test
   KML_DESCRIPTION test
   KML_NAME_ITEM TEXT
   # wfs_getfeature_formatlist text/csv,gml,geojson,xml,kml
   # KML_OUTPUTASRASTER true
  END
  CLASS
STYLE
 SYMBOL point
 SIZE 36
 COLOR 255 0 0
 OUTLINECOLOR 0 255 0
END
  END
 END
...

SYMBOL
  NAME point
  TYPE ELLIPSE
  POINTS
10 10
  END
  FILLED TRUE
END


KML-Output:

?xml version=1.0 encoding=UTF-8?
kml xmlns=http://www.opengis.net/kml/2.2;http://www.opengis.net/kml/2.2
  Document
Style id=LayerFolder_check
  ListStyle
listItemTypecheck/listItemType
  /ListStyle
/Style
Style id=LayerFolder_checkHideChildren
  ListStyle
listItemTypecheckHideChildren/listItemType
  /ListStyle
/Style
Style id=LayerFolder_checkOffOnly
  ListStyle
listItemTypecheckOffOnly/listItemType
  /ListStyle
/Style
Style id=LayerFolder_radioFolder
  ListStyle
listItemTyperadioFolder/listItemType
  /ListStyle
/Style
nameOsthessenNetz/name
Style id=style_symbol_point_3.6_ffff
  IconStyle
Icon
  hrefhttp://localhost/gistemp/54ae5c24_4474_0.png/href
/Icon
  /IconStyle
/Style
Folder
  namepoint/name
  visibility1/visibility
  styleUrl#LayerFolder_check/styleUrl
  Placemark
namepoint.0/name
styleUrl#style_symbol_point_3.6_ffff/styleUrl
descriptiontest/description
Point
  coordinates
9.73281948,50.58202641
/coordinates
/Point
  /Placemark
/Folder
  /Document
/kml

Any ideas?

Thank you

Dietmar

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

Re: [mapserver-users] [EXTERNAL] Re: Mapserver as WFS 1.1.0 client

2014-12-23 Thread Smith, Michael ERDC-RDE-CRREL-NH
Lars,

Could you add a gdal layer into mapserver and use gdal to make the wfs
1.1.0 request?

Mike

-- 
Michael Smith

US Army Corps
Remote Sensing GIS/Center



On 12/23/14, 12:15 PM, Lars Fricke lars.fri...@skendata.de wrote:

Well at least now I know.

Thanks for both of your effort.

Cheers and blessed Christmas.

Lars

Based on other input from Daniel Morissette I think it's pretty safe to
say that MapServer only supports WFS layers with versions 0.0.14 and
1.0.0. Sorry... I don't know what it would take to extend things to
1.1.0 though (patches welcome). Steve -Original Message- From:
Lars Fricke [mailto:lars.fri...@skendata.de] Sent: Tuesday, December 23,
2014 10:58 AM To: Lime, Steve D (MNIT); mapserver-users@lists.osgeo.org
Subject: Re: [mapserver-users] Mapserver as WFS 1.1.0 client Hello
Steve, Thank you for your answer. I tried setting to GET and this is
what i got: ows:Exception exceptionCode=NoApplicableCode
locator=mapservows:ExceptionTextmsWFSGetFeature(): WFS server
error. ms_error-code not found msWFSLayerWhichShapes(): WFS connection
error. WFS request produced unexpected output (junk?) for layer
HK./ows:ExceptionText/ows:Exception The message about the wrong
version is not showing up. Maybe I'm doing something wrong? Here's my
layer definition: LAYER NAME HK TYPE Point UNITS METERS CONNECTION
http://localhost:8081/geoserver/wfs?; CONNECTIONTYPE WFS #EXTENT 618740
5962679 1737924 7376186 does not seem to matter STATUS ON METADATA
wfs_version 1.1.0 wfs_title HK wfs_connectiontimeout 60
wfs_typename Data:HK wfs_maxfeatures 500 wfs_request_method
GET gml_include_items all wfs_title HK wfs_srs EPSG:3857
gml_featureid GCOA_ID wfs_enable_request * END # METADATA
PROJECTION init=epsg:3857 END # PROJECTION CLASS NAME Koordinaten
STYLE COLOR 190 87 66 OUTLINECOLOR 255 0 0 SIZE 4 SYMBOL circle_filled
END # STYLE END # CLASS END # LAYER The request is:
http://localhost:8082/wfs?SERVICE=WFSVERSION=1.1.0request=GetFeatureT
YPENAME=HKlocalSRS=EPSG:3857bbox=793732,6570204,793765,6570228
Thank you Cheers Lars Am 22.12.2014 um 16:09 schrieb Lime, Steve D (MNIT):
 Looking at the mapwfslayer.c code it's a little confusing. I see
references to 0.0.14 and 1.0.0 for POST requests and 0.0.14, 1.0.0 and
1.1 for GET requests.  You can try setting:

 wfs_request_method   GET

 In the layer metadata and see if that works for you.

 Steve

 -Original Message-
 From: mapserver-users-boun...@lists.osgeo.org
 [mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Lars
 Fricke
 Sent: Monday, December 22, 2014 12:58 AM
 To: mapserver-users@lists.osgeo.org
 Subject: Re: [mapserver-users] Mapserver as WFS 1.1.0 client

 Hello List,

 can you please give me a quick feedback on which version WFS MapServer
supports as CLIENT (see below)? I can't really find it in the docs.
 Thank you.

 Lars Fricke


 Am 18.12.2014 um 08:29 schrieb Lars Fricke:
 Hello,

 I am trying to access an external WFS with MapServer as client to
 cascade it. I get the following error message:
 msBuildWFSLayerPostRequest(): WFS connection error. MapServer
 supports only WFS 1.0.0 or 0.0.14 (please verify the version metadata
 wfs_version).

 Indeed the external server only sends version 1.1.0 and my mapfile
has:
 ...
 METADATA
 wfs_version1.1.0
 ...

 Now when I search on the net, I find bug reports about WMS 1.1.0 and
 MapServer but no information if I can use it as a 1.1.0 client at all.
 And if so, do I need to use something specific to activate it?

 I'm on a German Ubuntu 14.04 64bit with Apache2 and mapserv -v says:

 MapServer version 6.4.1 OUTPUT=GIF OUTPUT=PNG OUTPUT=JPEG OUTPUT=KML
 SUPPORTS=PROJ SUPPORTS=GD 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
 INPUT=JPEG INPUT=POSTGIS INPUT=OGR INPUT=GDAL INPUT=SHAPEFILE

 Thanks for looking into this.

 Best

 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



___
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: Mapserver as WFS 1.1.0 client

2014-12-23 Thread Smith, Michael ERDC-RDE-CRREL-NH
Lars,

You can create a layer for mapserver that is an OGR layer (part of the
GDAL library). 

LAYER
  ...
  CONNECTIONTYPE OGR
DATA ...
  ...
END


The DATA definition can be a OGR VRT that points to a WFS 1.1.0 layer, See
http://www.gdal.org/drv_wfs.html

Mike

On 12/23/14, 12:32 PM, Lars Fricke lars.fri...@skendata.de wrote:

Hello Michael,

I'm not sure I understand what you mean?

Best

Lars


Am 23.12.2014 um 18:19 schrieb Smith, Michael ERDC-RDE-CRREL-NH:
 Lars,

 Could you add a gdal layer into mapserver and use gdal to make the wfs
 1.1.0 request?

 Mike



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


[mapserver-users] Is there a way to use REMOTE_USER environment variable in RunTime Substitution?

2014-12-20 Thread Smith, Michael ERDC-RDE-CRREL-NH
I'm using apache basic auth to filter results. I have been able to use 
mod_rewrite to create a cookie with the authenticated username and use that in 
runtime subst but it would be much simpler and cleaner to just do it reading 
the environment variable. So far, I haven't found a way to do this in current 
master. Any ideas?

--
Michael Smith
US Army Corps
Remote Sensing GIS/Center
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] [EXTERNAL] Re: Postgres SQL oddity . . .

2014-12-15 Thread Smith, Michael ERDC-RDE-CRREL-NH
Bob,

If you want to keep * in the select, you have to alias the table name and add 
that to the *.

Eg,
DATA the_geom from (

select
distinct on (vname) vname,
st_length(st_transform(the_line, 26993)) as 
feet,
(DATE_PART('day', now() - acqtime) * 24 +
DATE_PART('hour', now() - acqtime) * 60 
+
DATE_PART('minute', now() - acqtime)
) as elapsed_min,  -- Compiled minutes 
since last major move of asset.
L.*
from
Loc l
where
st_length(st_transform(the_line, 26993))  30  
-- GPS error
order by
vname desc

) as subquery using unique vname using 
srid=200068

From: Basques, Bob (CI-StPaul) 
bob.basq...@ci.stpaul.mn.usmailto:bob.basq...@ci.stpaul.mn.us
Date: Monday, December 15, 2014 at 5:07 PM
To: Rahkonen Jukka (Tike) 
jukka.rahko...@mmmtike.fimailto:jukka.rahko...@mmmtike.fi, 
mapserver-users@lists.osgeo.orgmailto:mapserver-users@lists.osgeo.org 
mapserver-users@lists.osgeo.orgmailto:mapserver-users@lists.osgeo.org
Subject: [EXTERNAL] Re: [mapserver-users] Postgres SQL oddity . . .
Resent-From: Michael Smith 
michael.sm...@usace.army.milmailto:michael.sm...@usace.army.mil

Vname is NOT distinct in the data table.

I got the SQL to pass by dropping the “ * “ from the SQL, but ran into a 
different problem, how to run a logical expression against a POSTGRES call, 
looks like it only works with SHP files.  Crap!!

Bobb



From: Rahkonen Jukka (Tike) [mailto:jukka.rahko...@mmmtike.fi]
Sent: Monday, December 15, 2014 4:01 PM
To: Basques, Bob (CI-StPaul); 
mapserver-us...@osgeo.orgmailto:mapserver-us...@osgeo.org
Subject: Re: Postgres SQL oddity . . .


Hi,



If vname is unique in your table, why do you need to do select distinct on it?

I would make a blind guess with an alias name select distinct on (vname) 
vname_distinct



Usually it is not as easy, though



-Jukka Rahkonen-






Basques, Bob wrote:

 I'm trying to display a set of GPS points from a layer in Postrgres . . .

 Getting this error however:

ServiceExceptionReport version=1.3.0 
xsi:schemaLocation=http://www.opengis.net/ogc 
http://schemas.opengis.net/wms/1.3.0/exceptions_1_3_0.xsdhttp://www.opengis.net/ogc%20http:/schemas.opengis.net/wms/1.3.0/exceptions_1_3_0.xsdServiceException
msDrawMap(): Image handling error. Failed to draw layer named 'AVL_Plot_00to96'.
msPostGISLayerWhichShapes(): Query error. Error executing query: ERROR:  column 
reference vname is ambiguous
LINE 1: select elapsed_min,vname,encode(ST_AsBinary(ST_Force2D(...

/ServiceException/ServiceExceptionReport

from this Call:

DATA the_geom from (

select
distinct on (vname) vname,
st_length(st_transform(the_line, 26993)) as 
feet,
(DATE_PART('day', now() - acqtime) * 24 +
DATE_PART('hour', now() - acqtime) * 60 
+
DATE_PART('minute', now() - acqtime)
) as elapsed_min,  -- Compiled minutes 
since last major move of asset.
*
from
loc
where
st_length(st_transform(the_line, 26993))  30  
-- GPS error
order by
vname desc

) as subquery using unique vname using 
srid=200068

What I don't understand is how VNAME can be ambiguous when calling only one 
table (loc)??  The SQL works fine in PGADMIN.   Does the using unique vname 
have something to do with the problem, which seems to be required.

Help??

Thanks.

bobb

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

Re: [mapserver-users] [EXTERNAL] no featurecount in cluster

2014-11-12 Thread Smith, Michael ERDC-RDE-CRREL-NH
A recent change to clusters were to replace the colon (:) with a
underscore (_). Use Cluster_FeatureCount as the variable.

This change was made as the colon made it invalid gml.

Mike

On 11/12/14, 10:21 AM, Leehan mathias.cuna...@inrap.fr wrote:

I am experiencing an issue using cluster with mapserver 6.
I am using Cluster: FeatureCount as label in the layer but depending on
the scale, some clusters are empty.
I can't find the reason why.
Look in the center and on bottom left of the image.
Thx

http://osgeo-org.1560.x6.nabble.com/file/n5172621/cluster.png



--
View this message in context:
http://osgeo-org.1560.x6.nabble.com/no-featurecount-in-cluster-tp5172621.h
tml
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] [EXTERNAL] Re: Symbols in KML outout

2014-10-16 Thread Smith, Michael ERDC-RDE-CRREL-NH
You also have to make sure that the IMAGEURL is a full web URL not just a
path.

Mike

On 10/16/14, 8:56 AM, Eichner, Andreas - SID
andreas.eich...@sid.sachsen.de wrote:

Never used it but it seems the KML driver creates PNG images on the fly
and returns them as href. This seems to be independent of the type of
symbol. So you should make sure MS is able to write those images into
/tmp or $MS_TEMPPATH. The (null) indicates that it was unable to do so.

HTH

Von: mapserver-users-boun...@lists.osgeo.org
[mapserver-users-boun...@lists.osgeo.org]quot; im Auftrag von
quot;Peter Hopfgartner [peter.hopfgart...@r3-gis.com]
Gesendet: Donnerstag, 16. Oktober 2014 10:09
An: mapserver-users@lists.osgeo.org
Betreff: Re: [mapserver-users] Symbols in KML outout

Just as a quick fix, I'd propose to drop the href node if no reasonable
value is given. Anything more elaborate can be added later on. Comments?

Peter

On 10/15/2014 11:57 AM, Peter Hopfgartner wrote:
 From http://mapserver.org/output/kml_output.html#id2, it should be
 possible to have icons for sysmbols. The pixmap of the ison should be
 referenced in the href node.
 In my output, the href ode looks like:

 href(null)/href

 Is there anything I missed?

 Regards,

 Peter



--
Peter Hopfgartner
R3 GIS Srl - GmbH
Via Johann Kravogl-Str. 2
I-39012 Meran/Merano (BZ)
web  : www.r3-gis.com
mail : peter.hopfgart...@r3-gis.com
phone: +39 0473 494949
fax  : +39 0473 069902

ATTENZIONE! Le informazioni contenute nella presente e-mail e nei
documenti eventualmente allegati sono confidenziali. La loro diffusione,
distribuzione e/o riproduzione da parte di terzi, senza autorizzazione
del mittente è vietata e può violare il D. Lgs. 196/2003. In caso di
ricezione per errore, Vogliate immediatamente informare il mittente del
messaggio e distruggere la e-mail.

ACHTUNG! Die in dieser Nachricht oder in den beigelegten Dokumenten
beinhalteten Informationen sind streng vertraulich. Ihre Verbreitung
und/oder ihre Wiedergabe durch Dritte ist ohne Erlaubnis des Absenders
verboten und verstößt gegen das Legislativdekret 196/2003. Sollten Sie
diese Mitteilung irrtümlicherweise erhalten haben, bitten wir Sie uns
umgehend zu informieren und anschließend die Mitteilung zu vernichten.

WARNING! This e-mail may contain confidential and/or privileged
information. If you are not the intended recipient (or have received this
e-mail in error) please notify the sender immediately and destroy this
e-mail. Any unauthorised copying, disclosure or distribution of the
material in this e-mail is strictly forbidden and could be against the
law (D. Lgs. 196/2003)

___
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] [EXTERNAL] WFS DescribeFeatureType returns string for all attributes

2014-10-10 Thread Smith, Michael ERDC-RDE-CRREL-NH
Steve,

Does

“gml_types”  “auto

not work for you?

Mike

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

From:  steve.tout...@inspq.qc.camailto:steve.tout...@inspq.qc.ca 
steve.tout...@inspq.qc.camailto:steve.tout...@inspq.qc.ca
Date:  Friday, October 10, 2014 at  12:14 PM
To:  mapserver-users@lists.osgeo.orgmailto:mapserver-users@lists.osgeo.org 
mapserver-users@lists.osgeo.orgmailto:mapserver-users@lists.osgeo.org
Subject:  [EXTERNAL] [mapserver-users] WFS DescribeFeatureType returns string 
for all attributes
Resent-From:  Michael Smith 
michael.sm...@usace.army.milmailto:michael.sm...@usace.army.mil


Hi,
I'm using mapserv 6.4.1 as a wfs server to publish hundreds of layers. Most of 
the Layers are Postgis table or view
DescribeFeatureType on a layer returns string as data type for each 
attributes. This is an issue when we want to flter on WFS layer.

I saw that this issue was discussed years ago
https://github.com/mapserver/docs/issues/65

Before Adding gml_[item name]_type for each non string attributes of every 
layers...Is there a plan to fix this bug?

thank you
Steve



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

Re: [mapserver-users] [EXTERNAL] Leaflet + OpenMap + Mapserver WMS

2014-09-25 Thread Smith, Michael ERDC-RDE-CRREL-NH
Robert,

You need to set a single value in your mapfile projection block and then
set the list of allowed projections in your map web metadata block.

http://mapserver.org/ogc/wms_server.html#setup-a-mapfile-for-your-wms


Basically you need this part

WEB
  ...
METADATA
wms_title   WMS Demo Server
wms_onlineresource  http://my.host.com/cgi-bin/mapserv?map=wms.map;
wms_srs EPSG:3857 EPSG:4269 EPSG:4326
END
END


And note that you should use EPSG:3857 rather than 900913 (if you can).
3857 is the official code, 900913 was a hack added temporary code.

Mike

-- 
Michael Smith

US Army Corps
Remote Sensing GIS/Center



On 9/25/14, 7:28 AM, Burgholzer, Robert (DEQ)
robert.burghol...@deq.virginia.gov wrote:

Running afoul of projections conflict in the setup with the following
error:
msWMSLoadGetMapParams(): WMS server error. Invalid SRS given : SRS must
be valid for all requested layers.

All layers in my Mapfile have an EPSG of 4326, but the base layer of my
map in Leaflet is OpenMap which I understand comes in with the google
projection 900913?

I have done the following:
* I added the def for 900913 to the proj4 epsg file (this def was added
after compiling mapserver but can't imagine that would matter?):
/usr/share/proj/epsg
* Compiled Mapserver with proj4 enabled (--with-proj4)
* Set allowable 900913, 4326, and 4269 in my mapfile projection block
(block shown below)
* Set debug 5 in my mapfile but received no other info about this issue
(like what proj is being requested by Leaflet)


Mapfile excerpts:

PROJECTION
init=epsg:900913
init=epsg:4269
init=epsg:4326
END



Robert  Burgholzer
Surface Water Modeler
Virginia DEQ Office of Surface and Ground Water Supply
804-869-3066

___
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: Clickable label

2014-09-09 Thread Smith, Michael ERDC-RDE-CRREL-NH
I would recommend the UTF Grid approach.

http://mapserver.org/development/rfc/ms-rfc-93.html or


On 9/9/14, 6:35 AM, Basques, Bob (CI-StPaul)
bob.basq...@ci.stpaul.mn.us wrote:

All,

It's probably not the cleanest way to approach it, but maybe a straight
imagemap type approach.   You use the four corners of the label bounding
poly and send as an imagemap or json set or id query.

I think the bounding polys need to somehow be thought of as a ad-hoc data
layer themselves.  Is there a way of sub-selecting feature constructs
(that were originated by mapserver, like centroids are, into a reusable
(on the fly) dataset?

My immediate thoughts were to use a clientside imagemage (which is passe
these days) and that is where the translation occurs for the bounding
boxes, via the imagemap generation.

bobb

From: Lime, Steve D (MNIT)
Sent: Monday, January 20, 2014 9:43 AM
To: Basques, Bob (CI-StPaul); wiltomap; mapserver-users@lists.osgeo.org
Subject: RE: [mapserver-users] Clickable label

That or a UTFGrid. I don't believe that support (in master) handles
labels but maybe it could. In UTFGrid context you wouldn't want to render
characters anyway, only the bounding polygons. However, because the grid
is rendered at a lower resolution than the related map label placement
consistency might be the issue. --Steve

From: Basques, Bob (CI-StPaul)
Sent: Friday, January 10, 2014 6:15 PM
To: Lime, Steve D (MNIT); wiltomap; mapserver-users@lists.osgeo.org
Subject: RE: [mapserver-users] Clickable label

Steve,

I've been thinking on this thread since it started, I wonder, could you
use a imagemap template from Mapserver, but populate it with the Label
bounding polygons?

bobb



From: mapserver-users-boun...@lists.osgeo.org
[mapserver-users-boun...@lists.osgeo.org] on behalf of Lime, Steve D
(MNIT) [steve.l...@state.mn.us]
Sent: Friday, January 10, 2014 4:14 PM
To: wiltomap; mapserver-users@lists.osgeo.org
Subject: Re: [mapserver-users] Clickable label

 This can't be done with stock MapServer. Labels are dynamic by nature
and are the product of a map raw while queries work off the base data.
The bridge between the map and a query is a conversion from pixels to map
coordinates based on map size and extent.

You might be able to pull this off using MapScript. For a query you'd
have to do things in two stages:

  1) Draw the map (in memory) based on the map the user interacted with
(same extent, size and set of layers) so that a label cache is created.
  2) Search the label cache based on the query point and based on that
pull the appropriate feature.

I don't know if step 2 is feasible or not. You used to be able to loop
through it, not sure about now.

There might be other ways using an image where you render text and label
backgrounds using the same color, a color that you could map back to a
feature id. The map would basically contain label polygons in a raster
you could, in turn, query that raster using point and retrieve a feature
id. I have doubts that you could match the first image to the second so
this would be a huge long shot.

Steve

-Original Message-
From: mapserver-users-boun...@lists.osgeo.org
[mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of wiltomap
Sent: Friday, January 10, 2014 2:17 AM
To: mapserver-users@lists.osgeo.org
Subject: [mapserver-users] Clickable label

Hello all,

I have to display labels instead of points on a layer. The labels rely on
an attribute value. I would like to click on the label to make an
attribute windows open up. So far, no problem with mapfile
configuration...

The only thing is that the attribute window opens up when I click right
in the middle of the label. I can use TOLERANCEUNITS and TOLERANCE
parameters in the mapfile to enlarge the clickable area BUT this means
that I can also click next to the label and get the attribute window,
which I don't want to...

My purpose is to get the attribute window whereever I click on the label
(any part of it) and not if I click next to it. Would you think about a
solution to that ?

I enclose a scrennshot of the mapfile I have worked out so far.


Many thanks in advance,

Thomas


http://osgeo-org.1560.x6.nabble.com/file/n5097281/mapfile_label.jpg



--
View this message in context:
http://osgeo-org.1560.x6.nabble.com/Clickable-label-tp5097281.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

___
mapserver-users mailing list
mapserver-users@lists.osgeo.org

Re: [mapserver-users] [EXTERNAL] Re: Postgis Tile Index

2014-08-20 Thread Smith, Michael ERDC-RDE-CRREL-NH
Note that the current Wiki entry is here: 
https://github.com/mapserver/mapserver/wiki/MapServer-TILEINDEXes-with-Database-RASTERS

And when you do get this working, please update this for the other PostGIS 
users.

Mike

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

From: Rahkonen Jukka (Tike) 
jukka.rahko...@mmmtike.fimailto:jukka.rahko...@mmmtike.fi
Date: Wednesday, August 20, 2014 at 6:56 AM
To: Dave Barter dave.bar...@gmail.commailto:dave.bar...@gmail.com, 
mapserver-users@lists.osgeo.orgmailto:mapserver-users@lists.osgeo.org 
mapserver-users@lists.osgeo.orgmailto:mapserver-users@lists.osgeo.org
Subject: [EXTERNAL] Re: [mapserver-users] Postgis Tile Index
Resent-From: Michael Smith 
michael.sm...@usace.army.milmailto:michael.sm...@usace.army.mil

Perhaps it is something like this (from 
http://trac.osgeo.org/gdal/wiki/frmts_wtkraster.html)

“Reading raster data from the database
If you want to use the GDAL WKT Raster driver, you must provide a connection 
string as Dataset's name. The syntax of this connection string is (the quotes 
may be ommitted):
PG:host='host' port:'port' dbname='dbname' user='user' 
password='password' [schema='schema'] [table='raster_table'] 
[where='sql_where'] [mode='working_mode']

I would test first by using the string for one image as  DATA of your raster 
layer before to continue towards TILEINDEX+TILEITEM.

-Jukka Rahkonen-

Dave Barter wrote:

I’ve figured this out,

CREATE MATERIALIZED VIEW mapping_os_opendata_raster.streetview_tileindex AS 
SELECT rid as location, ST_ConvexHull(rast) as shape from 
mapping_os_opendata_raster.streetview



“location needs to be a path to the database/table/raster currently it is just 
returning an ID, but I cannot find any documentation as to how to construct 
this for postgres
So nearly there?


On 20 August 2014 at 11:34:03, Dave Barter 
(dave.bar...@gmail.commailto:dave.bar...@gmail.com) wrote:
Final question. How should my map file look in order to get the raster tile 
from the database not the file system?

LAYER
# CREATE MATERIALIZED VIEW 
mapping_os_opendata_raster.streetview_tileindex AS SELECT rid as location, 
ST_ConvexHull(rast) as shape from mapping_os_opendata_raster.streetview
NAME streetview_tileindex
TYPE polygon
PROJECTION
init=epsg:27700
END
CONNECTIONTYPE postgis
CONNECTION “
DATA shape from (SELECT shape,location FROM 
mapping_os_opendata_raster.streetview_tileindex) AS FOO USING UNIQUE location 
using srid=27700

END

LAYER
#RASTER TILE LAYERS MUST RUN FROM A TILEINDEX
NAME streetview
TYPE RASTER
STATUS ON
TILEINDEX streetview_tileindex
TILEITEM location
OFFSITE 0 0 0
PROJECTION
init=epsg:27700
END
DEBUG 5
EXTENT 0 0 300 100

END

This is not working as the layer street view returns an error:-

msDrawMap(): Image handling error. Failed to draw layer named 'streetview'. 
msDrawRasterLayerLow(): Unable to access file. Corrupt, empty or missing file 
'654016' for layer 'street view’.

I set SHAPEFILE “” at the top of the file, but am unclear as to how the 
streetview layer will retrieve the tile ?



--
Dave Barter

Web: http://www.phased.co.ukhttp://www.phased.co.uk/
Email:d...@phased.co.ukmailto:email%3ad...@phased.co.uk
Twitter:@Citizenfishy
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] [EXTERNAL] WMS GetFeatureInfo and Oracle 3D geometries

2014-06-04 Thread Smith, Michael ERDC-RDE-CRREL-NH
Andrew,

Looks like your metadata key for the geometry type is wrong its not 
ows_geometry, should be   ows_geomtype “LineString25D

Mike

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


From: andrew.pa...@bentley.commailto:andrew.pa...@bentley.com 
andrew.pa...@bentley.commailto:andrew.pa...@bentley.com
Date: Wednesday, June 4, 2014 at 7:26 AM
To: Michael Smith 
michael.sm...@erdc.dren.milmailto:michael.sm...@erdc.dren.mil, 
mapserver-users@lists.osgeo.orgmailto:mapserver-users@lists.osgeo.org 
mapserver-users@lists.osgeo.orgmailto:mapserver-users@lists.osgeo.org
Subject: RE: [EXTERNAL] [mapserver-users] WMS GetFeatureInfo and Oracle 3D 
geometries

Michael,

I wonder if you would be able offer some more advice on this. I have a version 
of mapserver compiled with the POINT_Z_M option.
Despite my best efforts, the geometry always returns in 2D. Do you happen to 
have an example map file entry and GetFeatureInfo call example?
Information from my config given below.

Thanks,
Andrew


mapserv -v
MapServer version 6.4.1 OUTPUT=PNG OUTPUT=JPEG SUPPORTS=PROJ SUPPORTS=AGG 
SUPPORTS=FREETYPE SUPPORTS=WMS_SERVER SUPPORTS=WFS_SERVER SUPPORTS=FASTCGI 
SUPPORTS=POINT_Z_M INPUT=JPEG INPUT=OGR INPUT=GDAL INPUT=SHAPEFILE

My map file includes this output format

  OUTPUTFORMAT
  NAME OGRGML
  DRIVER OGR/GML
  FORMATOPTION STORAGE=filesystem
  FORMATOPTION FORM=multipart
  FORMATOPTION FILENAME=result.gml
  END


Layers include this metadata definition

METADATA
  wms_titleESU
  wfs_titleESU
  wfs_featureidNE_ID
 gml_featureidNE_ID
  wfs_enable_request   *
  wms_enable_request   *
  gml_include_itemsall
  wfs_getfeature_formatlist  OGRGML
  gml_geometries   msGeometry
  gml_msGeometry_type  line
  ows_geometry   LineString25D
  wfs_geometryLineString25D
END


Typical call:-

http://parra5900reml/Mapserver/mapserv.exe?map=nem_highways.mapLAYERS=ESUQUERY_LAYERS=ESUSTYLES=SERVICE=WMSVERSION=1.1.1REQUEST=GetFeatureInfoBBOX=-25660.108682%2C6716795.696074%2C8125.057815%2C6751574.543939FEATURE_COUNT=1HEIGHT=910WIDTH=884FORMAT=image%2FpngINFO_FORMAT=GML.1SRS=EPSG%3A900913X=287Y=24


From: Smith, Michael ERDC-RDE-CRREL-NH [mailto:michael.sm...@erdc.dren.mil]
Sent: 03 April 2014 13:48
To: Andrew Parry; 
mapserver-users@lists.osgeo.orgmailto:mapserver-users@lists.osgeo.org
Subject: Re: [EXTERNAL] [mapserver-users] WMS GetFeatureInfo and Oracle 3D 
geometries

Andrew,

This is possible. You do need to do several things.


  1.  Mapserver needs to be compiled with USE_POINT_Z_M
  2.  You need to use an OGR output format
  3.  You need to define the output as a 2.5D geometry type, eg, if its a point 
then define the ows/wfs_geometry type as Point25D. See 
mapserver.org/output/ogr_output.html for more info
Mike

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

From: andrew.pa...@bentley.commailto:andrew.pa...@bentley.com 
andrew.pa...@bentley.commailto:andrew.pa...@bentley.com
Date: Thursday, April 3, 2014 6:06 AM
To: mapserver-users@lists.osgeo.orgmailto:mapserver-users@lists.osgeo.org 
mapserver-users@lists.osgeo.orgmailto:mapserver-users@lists.osgeo.org
Subject: [EXTERNAL] [mapserver-users] WMS GetFeatureInfo and Oracle 3D 
geometries
Resent-From: Michael Smith 
michael.sm...@usace.army.milmailto:michael.sm...@usace.army.mil

Hi,

I’m looking for a way to have GetFeatureInfo return three dimensions (x,y,z) 
from an Oracle spatial data source.
Right now it is returning 2D as GML. The z value contains a measure that is 
required to determine direction for distance calculations in the client 
(OpenLayers).
Any suggestions welcome.

Regards,
Andrew


Andrew Parry | Software Engineer II
Bentley Systems (UK) Ltd
E-mail:  andrew.pa...@bentley.commailto:gopi.kumarap...@bentley.com | 
www.bentley.comhttp://www.bentley.com/
Bentley Systems (UK) Ltd, 9th Floor, 20 Gracechurch Street, London EC3V 0BG
Registered in England No. 2957722




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

Re: [mapserver-users] [EXTERNAL] WMS GetFeatureInfo and Oracle 3D geometries

2014-04-03 Thread Smith, Michael ERDC-RDE-CRREL-NH
Andrew,

This is possible. You do need to do several things.


  1.  Mapserver needs to be compiled with USE_POINT_Z_M
  2.  You need to use an OGR output format
  3.  You need to define the output as a 2.5D geometry type, eg, if its a point 
then define the ows/wfs_geometry type as Point25D. See 
mapserver.org/output/ogr_output.html for more info

Mike

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

From: andrew.pa...@bentley.commailto:andrew.pa...@bentley.com 
andrew.pa...@bentley.commailto:andrew.pa...@bentley.com
Date: Thursday, April 3, 2014 6:06 AM
To: mapserver-users@lists.osgeo.orgmailto:mapserver-users@lists.osgeo.org 
mapserver-users@lists.osgeo.orgmailto:mapserver-users@lists.osgeo.org
Subject: [EXTERNAL] [mapserver-users] WMS GetFeatureInfo and Oracle 3D 
geometries
Resent-From: Michael Smith 
michael.sm...@usace.army.milmailto:michael.sm...@usace.army.mil

Hi,

I’m looking for a way to have GetFeatureInfo return three dimensions (x,y,z) 
from an Oracle spatial data source.
Right now it is returning 2D as GML. The z value contains a measure that is 
required to determine direction for distance calculations in the client 
(OpenLayers).
Any suggestions welcome.

Regards,
Andrew


Andrew Parry | Software Engineer II
Bentley Systems (UK) Ltd
E-mail:  andrew.pa...@bentley.commailto:gopi.kumarap...@bentley.com | 
www.bentley.comhttp://www.bentley.com/
Bentley Systems (UK) Ltd, 9th Floor, 20 Gracechurch Street, London EC3V 0BG
Registered in England No. 2957722
[cid:118510028E45B84FAB68232766D92809@bentley.com]



attachment: Picture (Device Independent Bitmap) 1.jpg___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] [EXTERNAL] Layer with point from X and Y columns in

2014-03-13 Thread Smith, Michael ERDC-RDE-CRREL-NH
Jakub,

What you have to do is disable the use of the spatial index (since you are 
defining this on the fly, there will be no index).

DATA shape FROM (select MDSYS.SDO_GEOMETRY(2001, NULL, 
MDSYS.SDO_POINT_TYPE(table.x, table.Y, NULL), NULL, NULL) AS shape from table)” 
USING NONE

See http://mapserver.org/input/vector/oracle.html#using-none for details.

Mike

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


From: Jakub Štambachr stamb...@gmail.commailto:stamb...@gmail.com
Date: Thursday, March 13, 2014 at 5:39 AM
To: mapserver-users@lists.osgeo.orgmailto:mapserver-users@lists.osgeo.org 
mapserver-users@lists.osgeo.orgmailto:mapserver-users@lists.osgeo.org
Subject: [EXTERNAL] [mapserver-users] Layer with point from X and Y columns in
Resent-From: Michael Smith 
michael.sm...@usace.army.milmailto:michael.sm...@usace.army.mil

Hi,

I have table in Oracle Database that contains points specified by columns X and 
Y (The table also contains SDO_Geometry column but it’s not always filled with 
data and I’m not at liberty to modify the table).

My question is: Is it possible to specify layers with point using the columns X 
and Y?

So far I have something like this and I need an alternative to replace the DATA

TYPE POINT
CONNECTIONTYPE oraclespatial

CONNECTION isypoo/password@orcl
DATA shape FROM (select table.shape as SHAPE from table)

I tried the following:

DATA shape FROM (select MDSYS.SDO_GEOMETRY(2001, NULL, 
MDSYS.SDO_POINT_TYPE(table.x, table.Y, NULL), NULL, NULL) AS shape from table)

But got the following error:

msDrawMap(): Image handling error. Failed to draw layer named 'mosty'.
msOracleSpatialLayerWhichShapes(): OracleSpatial error. Error: ORA-13226: 
interface not supported without a spatial index

Is there any other way of doing this without modifying the database?

Thank you for your help,

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

Re: [mapserver-users] [EXTERNAL] Re: Shapezip 3D

2014-03-03 Thread Smith, Michael ERDC-RDE-CRREL-NH
The 2.5D output does work correctly with Oracle Spatial (3D) input.

Mike

-- 
Michael Smith

US Army Corps
Remote Sensing GIS/Center



On 3/3/14, 4:20 AM, Guillaume Sueur no-re...@neogeo-online.net wrote:

OK, got it, but actually no need of MapServer to do that. zip is enough
:-)



Le 03/03/2014 10:16, Even Rouault a écrit :
 Selon Guillaume Sueur no-re...@neogeo-online.net:

 Hi Even,

 Thanks for your reply even if it is disappointing. So I guess all the
 http://mapserver.org/fr/output/ogr_output.html stuff about 2.5D/3D is
 just rubbish and the USE_POINT_Z_M compile option is useless.

 Actually no, it is correct. My previous comment was on the input
interface
 of MapServer with OGR, where Z support is not currently available. But
for the
 output part (mapogroutput.c), Z support should work. So you could
likely use a
 3D shapefile (with MapServer native shapefile connection) and output a
3D
 shapezip.


 Thanks for your investigations

 Best regards

 Guillaume


 Le 01/03/2014 12:53, Even Rouault a écrit :
 Le vendredi 28 février 2014 17:29:15, Guillaume Sueur a écrit :
 Hi list,

 I'm trying to generate a 3D shapefile with OGR SHAPEZIP format. I'm
 using MapServer 6.5 compiled with USE_POINT_Z_M options.
 mapserv -v gives :
 MapServer version 6.5-dev OUTPUT=PNG OUTPUT=JPEG SUPPORTS=PROJ
 SUPPORTS=AGG SUPPORTS=FREETYPE SUPPORTS=CAIRO SUPPORTS=ICONV
 SUPPORTS=WMS_SERVER SUPPORTS=WMS_CLIENT SUPPORTS=WFS_SERVER
 SUPPORTS=WFS_CLIENT SUPPORTS=WCS_SERVER SUPPORTS=SOS_SERVER
 SUPPORTS=GEOS SUPPORTS=POINT_Z_M INPUT=JPEG INPUT=POSTGIS INPUT=OGR
 INPUT=GDAL INPUT=SHAPEFILE

 My data are stored in Postgis 2.1. They are 3D. I've added the
 ows_geomtype  MultiPolygon25D metadata to my layer.

 What I get is a 3D shapefile, but all the Z values are set to 0.

 Lookking at the request made by MapServer to Postgis, I see the geom
is
 requested with Force2D function :
 encode(ST_AsBinary(ST_Force2D(the_geom),'NDR'),'hex') as geom

 Is this a bug or is there some more settings I didn't set properly ?

 Guillaume,

 there's no support yet for parsing 3D geometries in mappostgis.c
 (mentionned
 in comments of https://github.com/mapserver/mapserver/pull/4803 ). I
 wouldn't
 expect adding support for it to be that difficult.

 As a workaround, I would have suggested that you could use the OGR
 PostgreSQL
 driver, but looking at mapogr.cpp, I also see that the Z support of
OGR
 isn't
 used. G

 Even






___
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 and excessive NFS traffic

2014-02-20 Thread Smith, Michael ERDC-RDE-CRREL-NH
On linux, 

exportfs -f

run on the server will often refresh a lost nfs connection.

Mike

-- 
Michael Smith

US Army Corps
Remote Sensing GIS/Center



On 2/20/14, 2:18 PM, Stephen Woodbridge wood...@swoodbridge.com wrote:

On 2/20/2014 1:56 PM, Travis Kirstine wrote:
 We are running mapcache in a cluster with each tile/ webserver mounted
 to a shared cache.  Periodically (~once a month) the NFS mount will lock
 and the load average on the web servers will skyrocket.

 Has anyone encountered something similar?

Its been a few years but I have have found that it is better to use
samba mounts for this kind of application because they are more or less
stateless and they will recover a connection if a server drops out and
comes back or even just times out on an access. I wasn't using mapcache
but I did have a server farm with multiple systems all cross mounting a
distributed cache and NFS required numerous reboots. All those issues
went away using samba mounts.

-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] [EXTERNAL] support of PostGIS PointZ

2013-12-13 Thread Smith, Michael ERDC-RDE-CRREL-NH
Tom,

You can do it with OGR Output formats. For example

http://geo.usace.army.mil/cgi-bin/wms/nldwfs?service=wfsversion=1.1.0requ
est=getfeaturetypename=leveesclosurestructurelnmaxfeatures=10outputforma
t=gml3d


You need to create an OGR outputformat (GML) which specifies the 25D
geometry type, for example ows_geomtype²  ³Geometry25D². MapServer also
needs to be compiled with USE_POINT_Z_M. See
http://mapserver.org/output/ogr_output.html#layer-metadata for the
ows_geomtype.

Mike

-- 
Michael Smith

US Army Corps
Remote Sensing GIS/Center



On 12/13/13, 1:11 PM, Kralidis,Tom [Ontario] tom.krali...@ec.gc.ca
wrote:

Hi: we are using MapServer 6.4.0 and our (PostgreSQL 8.4/PostGIS 2.0)
database models use the PointZ geometry type (we store x/y/z for our
observations).

How can we make the z values visible when doing WFS 1.1.0 output?
Currently for, say, GML3 output, MapServer returns 2d coordinates.

Cheers

..Tom
___
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] GeoJSON as WFS output format without template

2013-11-13 Thread Smith, Michael ERDC-RDE-CRREL-NH
Peter,

You can use OGR outputformats. Add something like this to your mapfile

OUTPUTFORMAT
  NAME geojson
  DRIVER OGR/GEOJSON
  MIMETYPE application/json; subtype=geojson
  FORMATOPTION STORAGE=stream
  FORMATOPTION FORM=SIMPLE
END

Add to your LAYER or MAP METADATA, wfs_getfeature_formatlist” geojson

And then in your WFS call add outputformat=geojson.

This will return geojson directly in the browser, if you need it to download, 
you can change the FORMATOPTION to FORM=ZIP

See http://mapserver.org/output/ogr_output.html for more detail.

Mike

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

From: Peter Hopfgartner 
peter.hopfgart...@r3-gis.commailto:peter.hopfgart...@r3-gis.com
Date: Wednesday, November 13, 2013 at 6:15 AM
To: users mapserver 
mapserver-users@lists.osgeo.orgmailto:mapserver-users@lists.osgeo.org
Subject: [EXTERNAL] [mapserver-users] GeoJSON as WFS output format without 
template
Resent-From: Michael Smith 
michael.sm...@usace.army.milmailto:michael.sm...@usace.army.mil

Hi list!

I wanted to have GeoJSON as an output format. Now, if I got the documentation 
right ( http://mapserver.org/it/development/rfc/ms-rfc-62.html, 
http://mapserver.org/it/development/rfc/ms-rfc-36.html), I should prepare a 
template for each layer I'd like to serve as GeoJSON.
Is this right or is there a way that MapServer guesses a reasonable format 
directly from the data, as it does for GML?
Indeed, http://mapserver.org/it/output/template_output.html says There are 
other, simpler, ways to output some of these formats using MapServer.
Does this simpler way exist for GeoJSON, too?

Regards,

Peter



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

Re: [mapserver-users] [EXTERNAL] Questions about Mapcache and Openlayers

2013-11-01 Thread Smith, Michael ERDC-RDE-CRREL-NH
James,

The mapcache demo page makes an external call to the OpenLayers site to
load the javascript library (http://www.openlayers.org/api/OpenLayers.js).
Are you on a network that has external access? If not, that would be your
problem. If you do, take a look in something like the Web Developer tools
in Firebug and see if the call to Openlayers.org is going through.

Mike

-- 
Michael Smith

US Army Corps
Remote Sensing GIS/Center



On 11/1/13, 3:42 PM, Evans, James R Civ USAF ACC 84 RADES/SCZE
james.ev...@hill.af.mil wrote:

Hi,
I've installed the latest MS4W-Dev package that comes with MapCache.  I
have it working somewhat, but the demo app doesn't work.  I see the
first page that lists the services, but when I click on any of them, I
get an empty box on the screen and there is a browser error that says
'openlayers' is undefined.  I have a couple of different wms clients on
this box that can hit the mapcache and retrieve images, but the demo
won't run.  Any suggestions on how to fix that?
Thanks,
James

___
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] Any thoughts on combining 3 regional maps into one?

2013-10-02 Thread Smith, Michael ERDC-RDE-CRREL-NH
Steve,

You can also do some kind of preprocessing. Generate your mapfile from a
script. The Scribe syntax may be quite useful for you
(http://www.mapgears.com/en/blog/archive/2013-03-12-scribe  and
https://github.com/solutionsmapgears/Scribe). Then just run the scribe
python script and you can regenerate your mapfiles from the multiple ones
and use things like variables.

Mike

-- 
Michael Smith

US Army Corps
Remote Sensing GIS/Center



On 10/2/13 11:52 AM, Stephen Woodbridge wood...@swoodbridge.com wrote:

Hi all,

I have 3 regional mapfiles for US, Canada and Mexico and I want to
create a single North America map. Since the data comes from separate
vendors and they refresh on different cycles, I'm trying to figure out
the best way to structure this in a mapfile. I also need to maintain
each region as a separate mapfile. (I'm ignoring issues like data
alignment over borders.)

The reginal mapfile data is structure like:

.../us/data/shapefiles
.../us/us.map
.../mx/data/shapefiles
.../mx/mx.map
.../ca/data/shapefiles
.../ca/ca.map

The shapepath for each mapfile is set to the local data directory. What
I would like to avoid is having to change all the paths in the mapfiles
to accomodate a change like:

.../na/us/data/
.../na/mx/data/
.../na/ca/data/
.../na/na.map

It would be cool if I can change the shapepath in the middle of the
mapfile so layers beyond the change would use the new shapepath, but I
suspect that will not work.

So it looks like my options are:

1. rewrite all the mapfile data pathes as I combine them into one new
mapfile and maintain two copies, regional and na versions.

2. maybe create a new mapfile that loads each of the regions as a WMS
client and overlays the adjacent regions. This will get served via
mapcache so that might add some options for tile assembly.

3. other ideas

Thanks,
   -Steve
___
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] Canot get around: WMS server error. Invalid layer(s) given in the LAYERS parameter.r

2013-10-01 Thread Smith, Michael ERDC-RDE-CRREL-NH
Paul,

What is your WMS Request? And what does your GetCapabilities look like? 
MapServer might have renamed (added _1) to your TestMap layer name because your 
map is named TestMap. Layer names are also case sensitive.

Mike

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

From: paul.she...@bentley.commailto:paul.she...@bentley.com 
paul.she...@bentley.commailto:paul.she...@bentley.com
Date: Tuesday, October 1, 2013 12:57 PM
To: mapserver-users@lists.osgeo.orgmailto:mapserver-users@lists.osgeo.org 
mapserver-users@lists.osgeo.orgmailto:mapserver-users@lists.osgeo.org
Subject: [EXTERNAL] [mapserver-users] Canot get around: WMS server error. 
Invalid layer(s) given in the LAYERS parameter.r
Resent-From: Michael Smith 
michael.sm...@usace.army.milmailto:michael.sm...@usace.army.mil

I installed MS4W a few days ago to put together a small proof-of-concept. I've 
been through the tutorial, which I got to work with a little tweaking. When I 
attempt to use an Oracle spatial table, I get a MS server error: Invalid 
layers(s)... error - which gives me no indication where I am going wrong.
Can anyone spot a problem here? I am running out of hair to pull out.
I have the Oracle client installed on my local machine and am attempting to 
draw a map from a spatial table on a local vm, on which I have Oracle Spatial 
running (10g).
I tried OGRINFO using the Oracle login credentials and table name - with 
immediate success.
mapserv -v shows that ORACLESPATIAL is a valid option
GetCapabiltiies contains no warnings
The map file is very simple - I have tried at least one hundred variations.
The data table has a SRID (though I have other tables with SRIDs and tables 
without). I've included the SRID in wms_srs and I have excluded it. I am 
beginning to believe the problem lies elsewhere - but have no idea what 
approach to use to find it, other than stabbing in the dark.
The map file contents are:
MAP
NAME Map1
SIZE 600 400
WEB
IMAGEPATH /tmp/ms_tmp/
TEMPLATE ..\Templates\TEMPLATE2.HTML
METADATA
wms_enable_request  *
wms_titleTestMap
   wms_srs  EPSG:2205
END
END

LAYER
NAME TestMap
TYPE LINE
STATUS ON
UNITS METERS
CONNECTIONTYPE ORACLESPATIAL
CONNECTION test_user/test_user@LOCALVM1
DATA SHAPE FROM (SELECT SHAPE FROM XNA_ROUTES)
METADATA
wms_enable_request  *
wms_nameTestMap
wms_titleTestMapTitle
  wms_srs  EPSG:4326
wms_format   image/gif
END
END #LAYER
END #MAP

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

Re: [mapserver-users] [EXTERNAL] Scribe UI for Windows?

2013-09-22 Thread Smith, Michael ERDC-RDE-CRREL-NH
Jukka,

Its a web app. 

Mike

-- 
Michael Smith

US Army Corps
Remote Sensing GIS/Center



On 9/21/13 10:56 PM, Rahkonen Jukka jukka.rahko...@mmmtike.fi wrote:

Hi,

Does such a thing exist?

-Jukka Rahkonen-

___
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 access using CONNECTIONTYPE PLUGIN

2013-07-30 Thread Smith, Michael ERDC-RDE-CRREL-NH
I recommend using the EZConnect syntax

User/pass@host:port/service_name

Or if port is 1521 then just

User/pass@host/service_name




On 7/30/13 9:24 AM, Jeff McKenna jmcke...@gatewaygeomatics.com wrote:

For MS4W, I use the following syntax:

#Direct through OracleSpatial

  CONNECTIONTYPE oraclespatial
  CONNECTION jeff/pass@SID

#Through OGR

  CONNECTIONTYPE OGR
  CONNECTION OCI:jeff/pass@SID

In your shoes I would be likely be trying to connect to your Oracle data
through an ogrinfo call, and then using that exact syntax in my mapfile
for testing.

http://www.maptools.org/ms4w/index.phtml?page=README_INSTALL.html#oracle-1
0g-11g

-jeff


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



On 2013-07-30 4:07 AM, nelly.how...@kivbf.de wrote:
 Hi,
 
  
 
 I try to access an oracle DB using following entry in mapfile:
 
  
 
 CONNECTIONTYPE PLUGIN
 
 PLUGIN msplugin_oracle.dll
 
 CONNECTION localhost,port:1521,DBname,user,password
 
 DATA GEOM FROM WSG USING SRID 31467
 
  
 
 I installed Oracle 11g locally on Windows 2008 R2 64 bit system and can
 connect to it via Net Manager or SQL Developer.
 
 I use a compiled mapserver  release MSVC2010 Win 64 downloaded from
 http://www.gisinternals.com/sdk/, which works fine with file based
geodata.
 
  
 
 Now I get an error message ORA-01005 (null password given; logon
 denied), but I set password correctly.
 
  
 
 Has anybody an idea, what I am making wrong? Has connection string using
 oracle another syntax?
 
  
 
 Thanks in advance
 
 Nelly
 
___
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] Defining Field Types in WFS

2013-07-12 Thread Smith, Michael ERDC-RDE-CRREL-NH
Robert,

Real hasn't worked for me, it may be a doc bug.

Try Double and Integer. This is what I'm using on Mapserver 6.

  gml_file_size_type integer
  gml_id_type integer
  gml_x_type  double
  gml_y_type  double

Mike

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


From: Burgholzer, Robert (DEQ) 
robert.burghol...@deq.virginia.govmailto:robert.burghol...@deq.virginia.gov
Date: Friday, July 12, 2013 10:44 AM
To: mapserver-users@lists.osgeo.orgmailto:mapserver-users@lists.osgeo.org 
mapserver-users@lists.osgeo.orgmailto:mapserver-users@lists.osgeo.org
Subject: [mapserver-users] Defining Field Types in WFS
Resent-From: Michael Smith 
michael.sm...@usace.army.milmailto:michael.sm...@usace.army.mil

We are having trouble with our WFS service, trying to define data field types 
as Numeric.  Our mapserver version is 5.6.3.  Currently, our field types all 
come out as String when viewed in ArcGIS, and when we try to set the field to a 
Real type, using the syntax shown in Ex 1 the service breaks, Ex 2 shows the 
working layer, and Ex 3 shows the full, working layer definition.

Any help would be most appreciated,
r.b.


Ex 1 - BREAKS the Service:

   METADATA
  wfs_titleWater Supply Plan System Information Test ## REQUIRED
  wfs_srs   EPSG:4326 ## REQUIRED
  gml_featureid system_nid ## REQUIRED
  gml_include_items all  ## Optional (serves all attributes for layer)
  wfs_enable_request *
 wfs_version 1.0.0
  gml_current_mgy_type Real
   END


Ex 2 - WORKS but gives all type String

   METADATA
  wfs_titleWater Supply Plan System Information Test ## REQUIRED
  wfs_srs   EPSG:4326 ## REQUIRED
  gml_featureid system_nid ## REQUIRED
  gml_include_items all  ## Optional (serves all attributes for layer)
  wfs_enable_request *
 wfs_version 1.0.0
   END

Ex 3 - FULL Layer definitions:

LAYER
   NAME wsp_system_info_test
   METADATA
  wfs_titleWater Supply Plan System Information Test ## REQUIRED
  wfs_srs   EPSG:4326 ## REQUIRED
  gml_featureid system_nid ## REQUIRED
  gml_include_items all  ## Optional (serves all attributes for layer)
  wfs_enable_request *
 wfs_version 1.0.0
  gml_current_mgy_type Real
   END
   #GROUP vwuds_max
   CONNECTIONTYPE postgis
   CONNECTION host=deq3.bse.vt.edu user=wsp_ro password=314159 
dbname=drupal715
   TYPE POINT
   STATUS DEFAULT
  DUMP TRUE
   DEBUG ON
   DATA the_geom FROM (select * from wsp_system_locations ) AS foo USING 
UNIQUE system_nid
   #FILTER leapyear  true
   TEMPLATE drought.html
   #MINSCALE 1000
   #MAXSCALE 5
   CLASS
  SYMBOL 'circle'
  SIZE 11
  NAME precip_nml
  COLOR 245 245 245
  BACKGROUNDCOLOR 245 245 245
  OUTLINECOLOR 0 0 0
   END
   TOLERANCE 10
   PROJECTION
   # EPSG SRID = 4326
 init=epsg:4326
   END
END

Robert  Burgholzer
Surface Water Modeler
Virginia DEQ Office of Surface and Ground Water Supply
804-869-3066

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


Re: [mapserver-users] DEM color ramps

2013-06-17 Thread Smith, Michael ERDC-RDE-CRREL-NH
Mark,

What I used is the following

gdaldem hillshade ${filename}.tif ${filename}_hs.tif -z 5 -az 90
gdaladdo -r average ${filename}_hs.tif 2 4 8 16 32
gdaldem color-relief ${filename}.tif colorramp.txt ${filename}_cr.tif -co
compress=jpeg -co PHOTOMETRIC=YCBCR -co tiled=yes
gdaladdo -r average ${filename}_cr.tif 2 4 8 16 32 --config
COMPRESS_OVERVIEW JPEG --config PHOTOMETRIC_OVERVIEW YCBCR --config
INTERLEAVE_OVERVIEW PIXEL

Then created tileindexes of the hs and cr files. I then set the opacity of
my CR layer at 70%

And my colorramp.txt file looks like this

5000 245  244  242
4500 224  222  216
4000 202  195  184
3500 186  174  154
3000 172  154  124
2500 170  135  83
2000 185  152  90
1500 195  167  107
1000 202  185  130
900 211  202  157
800 222  214  163
700 232  225  182
600 239  235  192
500 225  228  181
400 209  215  171
300 189  204  150
200 168  198  143
100 148  191  139
0 172  208  165
-20 167 223 210
nv 0 0 0 0 

Mike

-- 
Michael Smith

Remote Sensing/GIS Center
US Army Corps of Engineers







On 6/17/13  12:33 PM, Mark Volz markv...@co.lyon.mn.us wrote:

Hi,

I would like to add a color ramp to my elevation (DEM) layer.  If anyone
has any .map files or tips for creating a DEM color ramp please let me
know.

Thanks

Mark Volz, GISP
GIS Specialist

___
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] How Filter items only if provided parameter

2013-02-23 Thread Smith, Michael ERDC-RDE-CRREL-NH
Andrea,

What I do is set the default_idvalue to 1=1 and change the filter to
FILTER %idvalue%. Then the cgi value is something like idvalue=id=1

Your valididation regex becomes more complex though.

Mike

-- 
Michael Smith

US Army Corps
Remote Sensing GIS/Center



On 2/23/13 7:15 AM, Andrea Peri aperi2...@gmail.com wrote:

Hi,

I need to set a layer to allow to retrieve in the response all the
elements available in the layer, and when the request has a specific
parameter it should apply a filter to limit the show to only the
filtered geometries.

To do this until now I have set this configuration:

LAYER
   ...
DATA geometry from table using unique gid srid=25832
FILTER PK_FIELD like '%idvalue%' 
VALIDATION
  'idvalue' '^[a-zA-Z0-9\-_]+$'
END
   ...
   METADATA
  'default_idvalue' '%'

This configuration work pretty well when the PK is a string field.
Infact is the request has no the idvalue parameter it show all the
records , thx to the default_idvalue  % definitioni,
instead if the request has a parameter as example
..idvalue=xxx1

It show only the specific item having PK_FIELD=xxx1

Now I have the same need for a layer where the PK is numeric.

With this layer the solution described seem don't work, infact the
'default_idvalue' '%'

is not working with a numeric field.

There same other solution to have the same result?

I need to show all the records and apply the filter only when there is
a specific parameter in the request.

Thx,

-- 
-
Andrea Peri
. . . . . . . . .
qwerty àèìòù
-
___
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] Direct Connect to ESRI data

2013-01-15 Thread Smith, Michael ERDC-RDE-CRREL-NH
Bob,

How is the data stored in SQL Server? Is it in SQL Server native format? If so, 
then see http://mapserver.org/input/vector/mssql.html. If its SDEBINARY or some 
other SDE format, then your only solution is going through SDE so that means 
deploying an SDE server.

Mike

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

From: Bistrais, Bob bob.bistr...@maine.govmailto:bob.bistr...@maine.gov
Date: Tue, 15 Jan 2013 18:57:27 +
To: mapserver-users@lists.osgeo.orgmailto:mapserver-users@lists.osgeo.org 
mapserver-users@lists.osgeo.orgmailto:mapserver-users@lists.osgeo.org
Subject: [mapserver-users] Direct Connect to ESRI data
Resent-From: Michael Smith 
michael.sm...@usace.army.milmailto:michael.sm...@usace.army.mil

Some time ago, we phased out our Oracle/SDE storage for our ESRI data.  We now 
have that data stored in a SQL Server Direct Connect environment.  In the past, 
I was able to connect MapServer to SDE.  I have not been able to figure out how 
to do this in the new environment.  Can anyone lend a few suggestions?

___ mapserver-users mailing list 
mapserver-users@lists.osgeo.orgmailto: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] Projection takes less time than no projection ?

2012-12-04 Thread Smith, Michael ERDC-RDE-CRREL-NH
Clément,

There is an optimized route for reprojection from 4326 - 3857 in MapServer 
(see http://lists.osgeo.org/pipermail/mapserver-dev/2012-February/011956.html) 
so it can be very fast. I can't see how if could be faster than no projection. 
Perhaps the 10% is just within the margin of error? Or did you do the test 
1000's of times and average the results? That might be what it takes to really 
see a difference.

Mike

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

From: Clément MONIER 
clement.mon...@v-trafic.commailto:clement.mon...@v-trafic.com
Date: Tuesday, December 4, 2012 7:23 AM
To: mapserver-users@lists.osgeo.orgmailto:mapserver-users@lists.osgeo.org 
mapserver-users@lists.osgeo.orgmailto:mapserver-users@lists.osgeo.org
Subject: [mapserver-users] Projection takes less time than no projection ?
Resent-From: Michael Smith 
michael.sm...@usace.army.milmailto:michael.sm...@usace.army.mil

Hi All,

I’m using MapServer to generate tiles to overlay on a GoogleMaps base layer.
My data files are WGS84 shapefiles.

So my current mapfile was looking like :

MAP
…
PROJECTION init=epsg:3785 END
…
LAYER
…
PROJECTION init=epsg:4326 END
…
END
…
END

I was wondering about improving response time by disabling on-the-fly 
projection.
So I did pre-project my shp into spherical Mercator first.
And my new mapfile now looks like :

MAP
…
PROJECTIONproj=merca=6378137b=6378137lat_ts=0.0
lon_0=0.0x_0=0.0y_0=0k=1.0units=mnadgrids=@null 
   no_defs END
…
LAYER
…
END
…
END

I do get the same  tiles.
But when asking a single tile using both mapfile, I noticed that the response 
time was higher (about +10%) when the second mapfile was used !

Do you have any idea about what’s going on ?

Thanks   Regards

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


Re: [mapserver-users] [gdal-dev] Gdaltindex with -t_srs and Mapserver

2012-09-27 Thread Smith, Michael ERDC-RDE-CRREL-NH
This is a new feature I can champion. I will try to allocate some
development dollars behind this as this is something we at USACE would
find useful.

Mike

-- 
Michael Smith

US Army Corps
Remote Sensing GIS/Center



On 9/27/12 10:06 AM, Daniel Morissette dmorisse...@mapgears.com wrote:

I think mixed projection raster tileindex is a cool idea, but it should
probably be kept separate from RFC 37 (even if both need to happen at
the same time).

Now, as for any new feature request, you just need to find a champion
with time/interest/funding to make it happen.  :)

Daniel


On 12-09-27 9:36 AM, Rahkonen Jukka wrote:
 Hi,

 This is an intentional cross-posting and the main message is to support
implementing RFC 37
 http://mapserver.org/development/rfc/ms-rfc-37.html
 and enlarge it to support mixed-projection raster tileindex layers, if
possible.

 -Jukka Rahkonen-

 Vastaanottaja: 'gdal-...@lists.osgeo.org'
 Aihe: Re: [gdal-dev] Gdaltindex with -t_srs and Mapserver

 Hi,

 I did not meant to underestimate this little but extremely useful
improvement. However, you made me hungry: if you can see so simply the
image footprints, why not also the images?  I am already publishing in
our WMS also the tileindex  shapefiles so people can see the image
boundaries and make GetFeatureInfo queries from the image metadata that
we have added to the shapefile as a few extra fields. In order to make
it works we have reprojected images from their original projection zones
into one common zone.  Now I wonder if it could be possible to make
Mapserver to support tileindex layers containing source images with
mixed projections. As a non-programmer I have a strong belief that if I
can say what I want, someone can program it.

 I believe that Mapserver already gets the correct image list from the
mixed-projection shapefile.   I guess also that Mapserver does not read
image metadata from the geotiff image files for getting the projection
but it relies on the LAYER level PROJECTION setting. In my simple test
case with two images, one in EPSG:2393 and another in EPSG:2392 this
means that Mapserver thinks that images are 1000 kilometers apart and
sharing the EPSG:2393 system that I used in the PROJECTION block.

 Perhaps there could be an optional setting for LAYER level PROJECTION,
both for individual images and tileindex layers, something like
init:internal_metadata.  It would mean that Mapserver would do first a
query in a same manner than gdalinfo and ogrinfo for reading the native
projection of the dataset.

 Ok, once written this long I started to think about using PROJECTION
AUTO and then I found this three-year-old RFC
http://mapserver.org/development/rfc/ms-rfc-37.html

 +1 for implementing it.

 By the way, woudn't it be nice if desktop GIS like QGIS would show you
also your Landsat archive images and not only the footprints in some
pretty automatic way, let's say, after ticking a check box and setting
the maximum scale denominator value?

 -Jukka Rahkonen-





 -Alkuperäinen viesti-
 Lähettäjä: Etienne Tourigny [mailto:etourigny@gmail.com]
 Lähetetty: 27. syyskuuta 2012 15:27
 Vastaanottaja: Rahkonen Jukka
 Kopio: gdal-...@lists.osgeo.org
 Aihe: Re: [gdal-dev] Gdaltindex with -t_srs and Mapserver

 Jukka,

 nice that you noticed this new feature I added - was about to
 advertise it here!

 The goal of adding this feature was not to make it available in
 mapserver, but for using in desktop applications as a reference for
 multiple files with different projections (e.g. landsat archives).

 cheers
 Etienne

 On Thu, Sep 27, 2012 at 6:07 AM, Jukka Rahkonen
 jukka.rahko...@mmmtike.fi wrote:
 Hi,

 I had a try with gdaltindex and the new -t_srs option that is
 discussed in http://trac.osgeo.org/gdal/ticket/4773. It seems to be
 as Even was thinking in the very beginning and Mapserver does not
 work with tileindex which is containing reprojected bounding boxes.
 Images with BBOX in the native projection are shown but not the
 others. This line
 appears into Mapserver log:
 msDrawRasterLayerGDAL(): Error in overlap calculation.

 It might indeed be good to emit a warning about Mapserver
 incompability. It would be very nice if Mapserver supports this kind
 of
 tileindeces.

 -Jukka Rahkonen-

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



-- 
Daniel Morissette
http://www.mapgears.com/
Provider of Professional MapServer Support since 2000

___
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

Re: [mapserver-users] some questions regarding getFeatureInfo, SLD, PostGIS

2012-09-21 Thread Smith, Michael ERDC-RDE-CRREL-NH
At the SQL level, you can do some fancy work with CASE and setting some
default values

The CASE function allows you to set all kind of logical comparisons. You
can do conditional joins that way, setting the join condition to a non
matching value when you don't want the join, etc. SQL is more powerful
than any template language.

Mike



On 9/21/12 7:07 AM, Julien Cigar jci...@ulb.ac.be wrote:

On 09/21/2012 12:50, Rahkonen Jukka wrote:
 Hi,

Hello,

 So you have tried to define variables %SEX% and %BOD_ID%, used them
inside your DATA and then fired  WMS GetMaps by
addingSEX=your_valueBOD_ID=your_id? Does in not work or why it is not
powerful enough?

It is not powerful enough because it doesn't allow you to make simple
logical tests (if defined/equals/...), the run-time substitution is a
simple replace %FOO% by the value of FOO= from the query string.

It doesn't allow you to do something like: if FOO is defined or equal
to xxx, then add JOIN foo f ON f.id = bar.foo_id, select additional
columns, and add a WHERE foo.id = ... at a certain place in the DATA
string.

I guess mapscript should be used in this case, but it would be really
interesting to have this simple template language (or another solution)
without having to involve mapscript.

Julien

 -Jukka Rahkonen-


 Julien Cigar wrote:

 Hello,

 I'm using Mapserver 6.0.1 with the following PostGIS layer:
 http://pastie.org/private/84042k84vmljbontls5xvq

 The user has the possibility to select quite a lot of filters, which
implies that
 the SQL query should, in theory ,be generated dynamically.
 As this is not possible with Mapserver (run-time substitution with HTTP
 parameters and VALIDATION ... END isn't powerful enough is my case),
I'm
 dynamically generating an SLD
 (http://pastie.org/private/p66ml3uvqwcnphuuvera) to filter items and it
 works very well.

 Some questions:

 - Why does Mapserver doesn't have a very lightweight template language
(or
 something similar) to dynamically build a string following given
parameters? It
 could be really useful to avoid unnecessary JOIN, etc.
 For example something like:
 http://pastie.org/private/bojm3pi1dwrv18m2tvq (this is just an
example, but
 the idea is there)

 - I noticed in the PostgreSQL logs that sometimes Mapserver adds an
 additional condition to the WHERE clause when SLD is used. For example
with
 the followingogc:Filter  in my SLD:
 #
 ogc:Filter
 ogc:PropertyIsEqualTo
 ogc:PropertyNamebasis_of_record_id/ogc:PropertyName
 ogc:Literal1/ogc:Literal
 /ogc:PropertyIsEqualTo
 /ogc:Filter
 #

 Mapserver adds an additional and (( (basis_of_record_id= 1) )):

 (...) AS q where geom  GeomFromText('POLYGON((-3.6860351557368
 -9.81732918571448,-3.6860351557368 9.81732918571447,47.6860351496117
 9.81732918571447,47.6860351496117 -9.81732918571448,-3.6860351557368
 -9.81732918571448))',4326) and (( (basis_of_record_id= 1) ))

 which is not bad as less rows have to be post-processed by the SLD
engine.

 However, as soon as I add an additionalogc:or  (orogc:and) as:
 #
 ogc:or
 ogc:PropertyIsEqualTo
 ogc:PropertyNamebasis_of_record_id/ogc:PropertyName
 ogc:Literal1/ogc:Literal
 /ogc:PropertyIsEqualTo
 ogc:PropertyIsEqualTo
 ogc:PropertyNamebasis_of_record_id/ogc:PropertyName
 ogc:Literal2/ogc:Literal
 /ogc:PropertyIsEqualTo
 /ogc:or
 #

 Mapserver doesn't add this additional AND/OR clause (and ((
 (basis_of_record_id= 1) OR (basis_of_record_id = 2) )) in this
case).. Why
 ?

 - Is it normal that my SLD is totally ignored when I'm using
 REQUEST=GetFeatureInfo? Is the SLD only processed with
 REQUEST=GetMap?
 If this is the case, what's the typical alternative way of doing it?
 Should I go through WFS .. ?

 In advance, thank you for your answers :) Julien

 --
 No trees were killed in the creation of this message.
 However, many electrons were terribly inconvenienced.
 ___
 mapserver-users mailing list
 mapserver-users@lists.osgeo.org
 http://lists.osgeo.org/mailman/listinfo/mapserver-users


-- 
No trees were killed in the creation of this message.
However, many electrons were terribly inconvenienced.


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


Re: [mapserver-users] some questions regarding getFeatureInfo, SLD, PostGIS

2012-09-21 Thread Smith, Michael ERDC-RDE-CRREL-NH
I think that¹s correct for ansi syntax

Mike

On 9/21/12 8:13 AM, Julien Cigar jci...@ulb.ac.be wrote:

On 09/21/2012 13:24, Smith, Michael ERDC-RDE-CRREL-NH wrote:
 At the SQL level, you can do some fancy work with CASE and setting some
 default values

 The CASE function allows you to set all kind of logical comparisons. You
 can do conditional joins that way, setting the join condition to a non
 matching value when you don't want the join, etc. SQL is more powerful
 than any template language.

 Mike

ok I was wrong, you meant JOIN foo ON (CASE ... ) I guess .. ?



 On 9/21/12 7:07 AM, Julien Cigarjci...@ulb.ac.be  wrote:

 On 09/21/2012 12:50, Rahkonen Jukka wrote:
 Hi,
 Hello,

 So you have tried to define variables %SEX% and %BOD_ID%, used them
 inside your DATA and then fired  WMS GetMaps by
 addingSEX=your_valueBOD_ID=your_id? Does in not work or why it is
not
 powerful enough?
 It is not powerful enough because it doesn't allow you to make simple
 logical tests (if defined/equals/...), the run-time substitution is a
 simple replace %FOO% by the value of FOO= from the query string.

 It doesn't allow you to do something like: if FOO is defined or equal
 to xxx, then add JOIN foo f ON f.id = bar.foo_id, select additional
 columns, and add a WHERE foo.id = ... at a certain place in the DATA
 string.

 I guess mapscript should be used in this case, but it would be really
 interesting to have this simple template language (or another solution)
 without having to involve mapscript.

 Julien

 -Jukka Rahkonen-


 Julien Cigar wrote:

 Hello,

 I'm using Mapserver 6.0.1 with the following PostGIS layer:
 http://pastie.org/private/84042k84vmljbontls5xvq

 The user has the possibility to select quite a lot of filters, which
 implies that
 the SQL query should, in theory ,be generated dynamically.
 As this is not possible with Mapserver (run-time substitution with
HTTP
 parameters and VALIDATION ... END isn't powerful enough is my case),
 I'm
 dynamically generating an SLD
 (http://pastie.org/private/p66ml3uvqwcnphuuvera) to filter items and
it
 works very well.

 Some questions:

 - Why does Mapserver doesn't have a very lightweight template
language
 (or
 something similar) to dynamically build a string following given
 parameters? It
 could be really useful to avoid unnecessary JOIN, etc.
 For example something like:
 http://pastie.org/private/bojm3pi1dwrv18m2tvq (this is just an
 example, but
 the idea is there)

 - I noticed in the PostgreSQL logs that sometimes Mapserver adds an
 additional condition to the WHERE clause when SLD is used. For
example
 with
 the followingogc:Filter   in my SLD:
 #
 ogc:Filter
 ogc:PropertyIsEqualTo
 ogc:PropertyNamebasis_of_record_id/ogc:PropertyName
 ogc:Literal1/ogc:Literal
 /ogc:PropertyIsEqualTo
 /ogc:Filter
 #

 Mapserver adds an additional and (( (basis_of_record_id= 1) )):

 (...) AS q where geom   GeomFromText('POLYGON((-3.6860351557368
 -9.81732918571448,-3.6860351557368 9.81732918571447,47.6860351496117
 9.81732918571447,47.6860351496117 -9.81732918571448,-3.6860351557368
 -9.81732918571448))',4326) and (( (basis_of_record_id= 1) ))

 which is not bad as less rows have to be post-processed by the SLD
 engine.

 However, as soon as I add an additionalogc:or   (orogc:and) as:
 #
 ogc:or
 ogc:PropertyIsEqualTo
 ogc:PropertyNamebasis_of_record_id/ogc:PropertyName
 ogc:Literal1/ogc:Literal
 /ogc:PropertyIsEqualTo
 ogc:PropertyIsEqualTo
 ogc:PropertyNamebasis_of_record_id/ogc:PropertyName
 ogc:Literal2/ogc:Literal
 /ogc:PropertyIsEqualTo
 /ogc:or
 #

 Mapserver doesn't add this additional AND/OR clause (and ((
 (basis_of_record_id= 1) OR (basis_of_record_id = 2) )) in this
 case).. Why
 ?

 - Is it normal that my SLD is totally ignored when I'm using
 REQUEST=GetFeatureInfo? Is the SLD only processed with
 REQUEST=GetMap?
 If this is the case, what's the typical alternative way of doing it?
 Should I go through WFS .. ?

 In advance, thank you for your answers :) Julien

 --
 No trees were killed in the creation of this message.
 However, many electrons were terribly inconvenienced.
 ___
 mapserver-users mailing list
 mapserver-users@lists.osgeo.org
 http://lists.osgeo.org/mailman/listinfo/mapserver-users

 -- 
 No trees were killed in the creation of this message.
 However, many electrons were terribly inconvenienced.



-- 
No trees were killed in the creation of this message.
However, many electrons were terribly inconvenienced.


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


Re: [mapserver-users] oraclespatial connection

2012-08-20 Thread Smith, Michael ERDC-RDE-CRREL-NH
Michele,

Try with

   DATA SHAPE FROM PSITDATA.COMUNI USING SRID 32633

The VERSION 10g part doesn't need to be used anymore.

Mike

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

From: Michele De Santis tap...@virgilio.itmailto:tap...@virgilio.it
Reply-To: Michele De Santis tap...@virgilio.itmailto:tap...@virgilio.it
Date: Mon, 20 Aug 2012 17:37:33 +0200
To: mapserver-users@lists.osgeo.orgmailto:mapserver-users@lists.osgeo.org
Subject: [mapserver-users] oraclespatial connection
Resent-From: Michael Smith 
michael.sm...@usace.army.milmailto:michael.sm...@usace.army.mil

 Hi,

I'm using MS4W with connection to Oraclespatial. I followed the istructions on

http://www.maptools.org/ms4w/index.phtml?page=README_INSTALL.html#oracle-10g-11g

to enable Oracle 10g support and mapserv -v returns a string that contains 
INPUT=ORACLESPATIAL

In mapfile I have a Layer:

LAYER
NAME PSITDATA.COMUNI
TYPE POLYGON
CONNECTIONTYPE oraclespatial
CONNECTION UN/PW@DBSVILPU
DATA SHAPE FROM PSITDATA.COMUNI USING SRID 32633 VERSION 10g
CLASS
STYLE
OUTLINECOLOR 0 0 0
COLOR 0 128 128
END
END
METADATA
  wms_titlePSITDATA.COMUNI
  #wms_srs EPSG:26591
  wms_srs  EPSG:32633
  wms_namePSITDATA.COMUNI
  wms_server_version  1.1.1
  wms_format  image/png
  wms_enable_request *   ##necessary
END
PROJECTION
  init=epsg:32633
END
END


but I have the error:


ORA-06553: PLS-306: wrong number or types of arguments in call to 'SDO_FILTER'
 . Query statement: SELECT OBJECTID_1,rownum, SHAPE FROM PSITDATA.COMUNI WHERE 
SDO_FILTER( SHAPE, MDSYS.SDO_GEOMETRY(2003, :srid, 
NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),:ordinates ),'querytype=window') = 
'TRUE' . Check your data statement.

When I tried the SELECT in SQL*PLUS I had obtained:

SP2-0552: Bind variable ORDINATES not declared

Can you help me with the this error and with mapfile syntax?

Thank you
Michele ___ mapserver-users mailing 
list mapserver-users@lists.osgeo.orgmailto: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] R: Re: oraclespatial connection

2012-08-20 Thread Smith, Michael ERDC-RDE-CRREL-NH
Hmm,

You can't use that statement directly in sqlplus

You could use

SELECT OBJECTID_1,rownum, SHAPE FROM PSITDATA.COMUNI WHERE SDO_FILTER( SHAPE, 
MDSYS.SDO_GEOMETRY(2003, :srid, 
NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),sdo_ordinate_array(minx, miny, maxx, 
maxy) ),'querytype=window') = 'TRUE'

And put in the minx,miny,maxx, maxy values from the debug log to verify its all 
working properly.



From: Michele De Santis tap...@virgilio.itmailto:tap...@virgilio.it
Reply-To: Michele De Santis tap...@virgilio.itmailto:tap...@virgilio.it
Date: Mon, 20 Aug 2012 18:00:53 +0200
To: Michael Smith 
michael.sm...@erdc.dren.milmailto:michael.sm...@erdc.dren.mil, 
mapserver-users@lists.osgeo.orgmailto:mapserver-users@lists.osgeo.org 
mapserver-users@lists.osgeo.orgmailto:mapserver-users@lists.osgeo.org
Subject: R: Re: [mapserver-users] oraclespatial connection

Thank you Michael,

I tried without version but with the same result.

Michele


Messaggio originale
Da: michael.sm...@erdc.dren.milmailto:michael.sm...@erdc.dren.mil
Data: 20-ago-2012 17.53
A: Michele De Santistap...@virgilio.itmailto:tap...@virgilio.it, 
mapserver-users@lists.osgeo.orgmailto:mapserver-users@lists.osgeo.orgmapserver-users@lists.osgeo.orgmailto:mapserver-users@lists.osgeo.org
Ogg: Re: [mapserver-users] oraclespatial connection

Michele,

Try with

   DATA SHAPE FROM PSITDATA.COMUNI USING SRID 32633

The VERSION 10g part doesn't need to be used anymore.

Mike

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

From: Michele De Santis tap...@virgilio.itmailto:tap...@virgilio.it
Reply-To: Michele De Santis tap...@virgilio.itmailto:tap...@virgilio.it
Date: Mon, 20 Aug 2012 17:37:33 +0200
To: mapserver-users@lists.osgeo.orgmailto:mapserver-users@lists.osgeo.org
Subject: [mapserver-users] oraclespatial connection
Resent-From: Michael Smith 
michael.sm...@usace.army.milmailto:michael.sm...@usace.army.mil

 Hi,

I'm using MS4W with connection to Oraclespatial. I followed the istructions on

http://www.maptools.org/ms4w/index.phtml?page=README_INSTALL.html#oracle-10g-11g

to enable Oracle 10g support and mapserv -v returns a string that contains 
INPUT=ORACLESPATIAL

In mapfile I have a Layer:

LAYER
NAME PSITDATA.COMUNI
TYPE POLYGON
CONNECTIONTYPE oraclespatial
CONNECTION UN/PW@DBSVILPU
DATA SHAPE FROM PSITDATA.COMUNI USING SRID 32633 VERSION 10g
CLASS
STYLE
OUTLINECOLOR 0 0 0
COLOR 0 128 128
END
END
METADATA
  wms_titlePSITDATA.COMUNI
  #wms_srs EPSG:26591
  wms_srs  EPSG:32633
  wms_namePSITDATA.COMUNI
  wms_server_version  1.1.1
  wms_format  image/png
  wms_enable_request *   ##necessary
END
PROJECTION
  init=epsg:32633
END
END


but I have the error:


ORA-06553: PLS-306: wrong number or types of arguments in call to 'SDO_FILTER'
 . Query statement: SELECT OBJECTID_1,rownum, SHAPE FROM PSITDATA.COMUNI WHERE 
SDO_FILTER( SHAPE, MDSYS.SDO_GEOMETRY(2003, :srid, 
NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),:ordinates ),'querytype=window') = 
'TRUE' . Check your data statement.

When I tried the SELECT in SQL*PLUS I had obtained:

SP2-0552: Bind variable ORDINATES not declared

Can you help me with the this error and with mapfile syntax?

Thank you
Michele ___ mapserver-users mailing 
list 
mapserver-users@lists.osgeo.orgmailto:mapserver-users@lists.osgeo.orghttp://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] KML generation-partially working

2012-08-15 Thread Smith, Michael ERDC-RDE-CRREL-NH
You said  So I have an image corresponding to this symbol in ms_tmp. Do you 
actually have a valid png image at /ms_tmp/502a9927_2bc4_10.png?

The way KML output works is that the temp symbol images are generated and the 
the kml is written and the kml refers to those images. If the images are, in 
fact, valid, then its a path problem as I suggested earlier and the IMAGEURL is 
not absolute and pointing to your IMAGEPATH directory location. If the there is 
no file in /ms_tmp then its probably more of a permission or space problem. You 
should be able to see exactly whats happening with LAYER and MAP level 
debugging.

See http://mapserver.org/optimization/debugging.html and set the DEBUG level to 
5.

Mike

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

From: Sowmya Tiramdasu 
stiramd...@qcoherent.commailto:stiramd...@qcoherent.com
Date: Wednesday, August 15, 2012 6:48 AM
To: Michael Smith 
michael.sm...@erdc.dren.milmailto:michael.sm...@erdc.dren.mil, 
mapserver-users@lists.osgeo.orgmailto:mapserver-users@lists.osgeo.org 
mapserver-users@lists.osgeo.orgmailto:mapserver-users@lists.osgeo.org
Subject: RE: [mapserver-users] KML generation-partially working

Hi Michael,

  I see your point. But, the images itself are blank. So making the paths 
absolute has no difference. When the output format is png, I get all the layers 
rendered correctly. But when the Output format is set to KML only, the image 
outputs from each layer are coming blank :(.

So any inputs regarding this? Has anyone else ran in to the same situation?

Thanks,
Sowmya.
___
Sowmya Tiramdasu
QCoherent Software
9668 Madison Blvd., Suite 202
Madison, AL 35758
(256) 461-8289 Telephone
(256) 461-8249 Fax
www.geocue.comhttp://www.geocue.com/

From: Smith, Michael ERDC-RDE-CRREL-NH [mailto:michael.sm...@erdc.dren.mil]
Sent: Tuesday, August 14, 2012 4:26 PM
To: Sowmya Tiramdasu; 
mapserver-users@lists.osgeo.orgmailto:mapserver-users@lists.osgeo.org
Subject: Re: [mapserver-users] KML generation-partially working

You probably have to set your WEB / IMAGEURL to an absolute path since 
otherwise the kml references are relative and not picked up.

And please, reply to the list, there are others that can learn and respond that 
way.

Mike

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

From: Sowmya Tiramdasu 
stiramd...@qcoherent.commailto:stiramd...@qcoherent.com
Date: Tuesday, August 14, 2012 3:26 PM
To: Michael Smith 
michael.sm...@erdc.dren.milmailto:michael.sm...@erdc.dren.mil
Subject: RE: [mapserver-users] KML generation-partially working

Hi Michael,

  I looked in to the KML file. It looks fine. But the Images which have been 
generated in the ms_tmp files are blank. There was an image for each layer, 
which came out to be blank and for my layer 'ControlPoints' I gave under class 
-Symbol- Circle. So I have an image corresponding to this symbol in ms_tmp 
which is being used as the styleUrl in the KML. yet I am seeing a cross mark 
for that place mark in the Google earth.

For the layer 'sbet' - it is a line, so there is no image generated at all and 
this layer is being displayed good on the Google earth.

LAYER
NAME ControlPoints #Photogrammetric 
points
DATA Photogrammetric_Point
STATUS   OFF
TYPE POINT
CLASS
STYLE
# Symbol to be 
used (reference)
SYMBOL circle
# Size of the 
symbol in pixels
SIZE 8
COLOR 190 20 190
# Outline 
colour (RGB) - black
OUTLINECOLOR 0 
0 0
END
END
PROJECTION
init=epsg:2246
END
END

KML :

Style id=style_symbol_circle_8.0_ffbe14be
  IconStyle
Icon
  href/ms_tmp/502a9927_2bc4_10.png/href
/Icon
  /IconStyle
/Style
Folder
  nameControlPoints/name
  visibility1/visibility
  styleUrl#LayerFolder_check/styleUrl
  Placemark
nameControlPoints.0/name
styleUrl#style_symbol_circle_8.0_ffbe14be/styleUrl
Point
  coordinates
-84.61444330,38.04278949
/coordinates
/Point
  /Placemark

-Thanks,
Sowmya.
___
Sowmya Tiramdasu
QCoherent

Re: [mapserver-users] KML generation-partially working

2012-08-15 Thread Smith, Michael ERDC-RDE-CRREL-NH
If you have the image properly generating, then is just a matter of your 
mapping the image to the URL used in the KML.

So your IMAGEURL value should return images from the /ms4w/tmp/ms_tmp 
directory. And it should be an absolute URL (eg http://servername/path/to/tmp) 
and you should verify that http://servername/path/to/tmp/502b8cc1_1e28_10.png 
is accessible from your browser. If so, then the KML will be able to access it 
and you should be all set.

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


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


Re: [mapserver-users] KML generation-partially working

2012-08-15 Thread Smith, Michael ERDC-RDE-CRREL-NH
Sorry, I'm getting a little confused. Are you generating ground overlay layers 
(eg one raster output for a number of layers) or actual KML features (eg, 
Placemarks with a geometry and an style marker)?

If you are posting the KML to google maps, then the KML is public. Can you post 
the link to the KML so the list can actually see it and see what might be 
wrong. As for why your lidar layer might be blank, remember that KML output is 
always in epsg:4326. Perhaps you don't have a projection defined for your lidar 
layer and do for others.


Mike

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

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


Re: [mapserver-users] KML generation

2012-08-14 Thread Smith, Michael ERDC-RDE-CRREL-NH
Sowmya,

Looks like you might have a smart-quote there.

Try

OUTPUTFORMAT
NAME kml
DRIVER KML
MIMETYPE application/vnd.google-earth.kml+xml
IMAGEMODE RGB
EXTENSION kml
FORMATOPTION ATTACHMENT=lidar.kml #name of 
kml file returned - This is my line 308
FORMATOPTION maxfeaturestodraw=100
END


Mike

--
Michael Smith
US Army Corps
Remote Sensing GIS/Center
From: Sowmya Tiramdasu 
stiramd...@qcoherent.commailto:stiramd...@qcoherent.com
Date: Tuesday, August 14, 2012 8:47 AM
To: 'Mapserver-users' 
mapserver-users@lists.osgeo.orgmailto:mapserver-users@lists.osgeo.org
Subject: [mapserver-users] KML generation
Resent-From: Michael Smith 
michael.sm...@usace.army.milmailto:michael.sm...@usace.army.mil

Hi,

  I know this would be a very basic question. I tried to look around on the web 
and in the previous lists emails. But, somehow  I could not get a solution. 
Sorry for bothering evryone with this basic question.

  I am trying get a KML output from my mapserver. I was succesfull in getting a 
png output which means all my layers are being rendered correctly. Now I 
modified my mapfile . I removed the IMAGETYPE = png from the MAP Section and 
added the following:

OUTPUTFORMAT
NAME kml
DRIVER KML
MIMETYPE application/vnd.google-earth.kml+xml
IMAGEMODE RGB
EXTENSION kml
FORMATOPTION ’ATTACHMENT=lidar.kml’ #name of 
kml file returned - This is my line 308
FORMATOPTION maxfeaturestodraw=100
END
  Now when I try to query the mapserver in mode=map, I am getting a parsing 
error.

getString(): Symbol definition error. Parsing error near (’):(line 308).

Any help will be greatly appreciated. Thanks in advance!

Sowmya.

___
Sowmya Tiramdasu
QCoherent Software
9668 Madison Blvd., Suite 202
Madison, AL 35758
(256) 461-8289 Telephone
(256) 461-8249 Fax
www.geocue.comhttp://www.geocue.com/

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


Re: [mapserver-users] KML generation-partially working

2012-08-14 Thread Smith, Michael ERDC-RDE-CRREL-NH
You probably have to set your WEB / IMAGEURL to an absolute path since 
otherwise the kml references are relative and not picked up.

And please, reply to the list, there are others that can learn and respond that 
way.

Mike

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

From: Sowmya Tiramdasu 
stiramd...@qcoherent.commailto:stiramd...@qcoherent.com
Date: Tuesday, August 14, 2012 3:26 PM
To: Michael Smith 
michael.sm...@erdc.dren.milmailto:michael.sm...@erdc.dren.mil
Subject: RE: [mapserver-users] KML generation-partially working

Hi Michael,

  I looked in to the KML file. It looks fine. But the Images which have been 
generated in the ms_tmp files are blank. There was an image for each layer, 
which came out to be blank and for my layer 'ControlPoints' I gave under class 
-Symbol- Circle. So I have an image corresponding to this symbol in ms_tmp 
which is being used as the styleUrl in the KML. yet I am seeing a cross mark 
for that place mark in the Google earth.

For the layer 'sbet' - it is a line, so there is no image generated at all and 
this layer is being displayed good on the Google earth.

LAYER
NAME ControlPoints #Photogrammetric 
points
DATA Photogrammetric_Point
STATUS   OFF
TYPE POINT
CLASS
STYLE
# Symbol to be 
used (reference)
SYMBOL circle
# Size of the 
symbol in pixels
SIZE 8
COLOR 190 20 190
# Outline 
colour (RGB) - black
OUTLINECOLOR 0 
0 0
END
END
PROJECTION
init=epsg:2246
END
END

KML :

Style id=style_symbol_circle_8.0_ffbe14be
  IconStyle
Icon
  href/ms_tmp/502a9927_2bc4_10.png/href
/Icon
  /IconStyle
/Style
Folder
  nameControlPoints/name
  visibility1/visibility
  styleUrl#LayerFolder_check/styleUrl
  Placemark
nameControlPoints.0/name
styleUrl#style_symbol_circle_8.0_ffbe14be/styleUrl
Point
  coordinates
-84.61444330,38.04278949
/coordinates
/Point
  /Placemark

-Thanks,
Sowmya.
___
Sowmya Tiramdasu
QCoherent Software
9668 Madison Blvd., Suite 202
Madison, AL 35758
(256) 461-8289 Telephone
(256) 461-8249 Fax
www.geocue.comhttp://www.geocue.com/

From: Smith, Michael ERDC-RDE-CRREL-NH [mailto:michael.sm...@erdc.dren.mil]
Sent: Tuesday, August 14, 2012 10:37 AM
To: Sowmya Tiramdasu
Subject: Re: [mapserver-users] KML generation-partially working

Have you looked inside the KML file?

You can also set a DEBUG value on your layer (and mapfile) and look for 
anything that might be interrupting your KML write.

Mike


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


Re: [mapserver-users] MapServer vs ArcGIS server

2012-07-03 Thread Smith, Michael ERDC-RDE-CRREL-NH
Ya,

MapServer is cgi (or fastcgi). So it doesn't hold data in memory like
ArcGIS Server does. Also, each MapServer session (since its cgi) is
independent of each other so there is no service to go down. As long as
Apache is running, so is MapServer.

I find that MapServer scales much better for large numbers of request and
multiple maps. ArcGIS Server does well with smaller data sets and less
services (due to ram issues). ArcGIS server can be faster to start with,
since you are composing your maps graphically, but I find the MapServer
mapfile editing much (much) faster for repetitive operations. I can script
and copy/paste and (with includes) reuse more styling. With ArcGIS Server,
for anything other that setting basic colors, I find it much slower and
quite tedious.

I find that MapServer works at small or large scale, I run into issues
with ArcGIS server at large scales (lots of data and lots of services).

Then there is the fact that ArcGIS will change on you over time and the
whole architecture can go away and any time. In the time we have been
doing MapServer (coming up on 12 years now), ESRI has gone through 6
different (and incompatible) web mapping engines. Our mapserver stuff
still works. Something to think about when you are in it for the long haul.

Also, when something critical has come up and I need a fix NOW, I have
both made my own code changes and requested fixes from the community and
had responses within hours (sometimes minutes). That is just not possible
with ArcGIS Server. MapServer has a truly impressive community with both
enthusiasts and mature business providing development and support
(MapGears and Gateway Geomatics are two that I am very familiar with and
they are top notch).

We are a government agency and MapServer is production code for us, for
over a decade. And we serve out a lot of data with it.

Mike

-- 
Michael Smith

US Army Corps
Remote Sensing GIS/Center

   

On 7/3/12 8:50 PM, Wang, Ya ya.w...@vta.org wrote:

Hello All,

I am  wondering if any of you have experience with both MapServer and
ArcGIS server. How does MapServer compare with ArcGIS server? Besides the
fact that MapServer is more customizable and more extensible and less
expensive, what other advantages do MapServer have against ArcGIS server?
 


Thanks in advance!

Ya


___
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] accessing different band values in the same layer

2012-06-14 Thread Smith, Michael ERDC-RDE-CRREL-NH
Helen,

It does not appear that you can. Based on the docs

Raster classifications always take place on only one raster band. It
defaults to the first band in the referenced file, but this can be altered
with the BANDS PROCESSING directive. In particular this means that
including even a single CLASS declaration in a raster layer will result in
the raster layer being rendered using the one band classification rules
instead of other rules that might have applied (such as 3 band RGB
rendering).

http://mapserver.org/input/raster.html



You could have multiple layers and do classification on each band by
changing the first value in the PROCESSING BANDS directive.

Mike




On 6/14/12  8:27 AM, Helen San Segundo Navazo hsansegu...@meteo.cat
wrote:

Hi,
I have a raster file with different bands inside it.
when I create my mapfile inside the layer tag I can define the bands I
want to access with  PROCESSING BANDS=4,2,1
When I select 1 band I can access to its data using the EXPRESSION tag:
 CLASS
 NAME 0 - 5
 EXPRESSION ([pixel] = 0 AND [pixel]  5)
 STYLE
 COLOR 80 0 0
 END
 END
But if I select more than one band, how can I do to acces to the
different band values inside the same EXPRESSION tag? is it possible?

The problem is that I have wind information in different bands, in one
band I have speed and in other band I have direction, and I have to draw
the wind symbol depending on both values.
Is possible to acces to the different pixel band values inside the same
EXPRESSION tag?
Thanks,
Helen
___
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