[mapserver-users] Documentation for Mapcache Time Dimension Support available?
Hello, I am trying, to set up the Time Dimension Support in Mapcache. Is there any detailed informationen except of the RFC Page available?( http://mapserver.org/de/development/rfc/ms-rfc-96.html). Example: How to setup the corresponding sqlight database and so on... The official documentation still tells you, that the Time Dimension Support is not implemented yet. Best regards Stefan ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Mapserver WMS time support with Oracle
Hi,
we had the same issue.
When we call mapserver via cgi, we set the apache environment for oracle like
this:
SetEnv NLS_LANG=German_Germany.UTF8
SetEnv NLS_DATE_FORMAT=-MM-DD HH24:MI:SS
So, we can use a MapServer supported time format.
When we call mapserver via fastcgi, we set the environment for oracle in a
script:
#!/bin/sh
export ORACLE_HOME=(...)/instantclient_11_2
export ORACLE_BASE=(...)/instantclient_11_2
export LD_LIBRARY_PATH=(...)/instantclient_11_2
export TNS_ADMIN=(...)/instantclient_11_2
export NLS_LANG=German_Germany.UTF8
export NLS_DATE_FORMAT=-MM-DD HH24:MI:SS
MAPSERV=(...)/mapserv.fcgi
MS_MAPFILE=(...)/wms_geoportal.map exec ${MAPSERV}
regards,
Stefan
D. Nappo domenico.na...@gmail.com hat am 21. Januar 2014 um 15:18
geschrieben:
...but unfortunately MapServer wms time support doesn't include that format:
http://mapserver.org/it/ogc/wms_time.html
2014/1/21 D. Nappo domenico.na...@gmail.com
mailto:domenico.na...@gmail.com
Many thanks!
It helped: the default date format in our system is DD-Mon-RR and I found
it out with SELECT * FROM nls_database_parameters WHERE parameter LIKE
'%DATE%'
2014/1/20 Umberto Nicoletti umberto.nicole...@gmail.com
mailto:umberto.nicole...@gmail.com
On Mon, Jan 20, 2014 at 2:44 PM, D. Nappo
domenico.na...@gmail.com mailto:domenico.na...@gmail.com
wrote:
Hi there,
I couldn't figure out how to solve this. I have a layer so
configured:
LAYER
NAME layer
TYPE point
CONNECTION conn_string
CONNECTIONTYPE ORACLESPATIAL
TEMPLATE templates/hotspot_template.html
DATA SHAPE FROM (SELECT POINT as SHAPE, ACQ_DATE,
ACQ_TIME, SATELLITE, CONFIDENCE, VERSION, BRIGHT_T31, FRP FROM
gwsprd.HOT_SPOTS_MODIS) using unique OGR_FID
METADATA
wms_title WMS test
wms_srs EPSG:4326
wms_extent-180 -90 180 90
wms_timeextent 2000-01-01/2020-12-31
wms_timeitem acq_date
wms_timedefault 2014-01-01
wms_timeformat -MM-DD
Try with this:
wms_timeformat DD-MM-YY
it is the default format Oracle expects when converting a string to a
date and no format has been explicitly provided.
Hth,
Umberto
wms_enable_request *
END
CLASS
SYMBOL 'circle'
SIZE 2
COLOR255 0 0
END
END
Now, the date column in the oracle table is the acq_date field.
The problem is that Mapserver translates that with a wrong oracle
query (which it works in postgreslq, I guess):
SELECT OGR_FID,rownum, SHAPE FROM
(SELECT OGR_FID, POINT as SHAPE, ACQ_DATE, ACQ_TIME, SATELLITE,
CONFIDENCE, VERSION, BRIGHT_T31, FRP FROM gwsprd.HOT_SPOTS_MODIS)
WHERE acq_date = '2014-01-16'
The query above uses a wrong filter and it gives the error:
ORA-01861: literal does not match format string
How can I tell to Mapserver to use a correct query??? Or do I
missing anyhting???
Something like:
WHERE acq_date = to_date('2014-01-16','-MM-DD')
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
mailto:mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Mapserver WMS time support with Oracle
Hi,
we did it and it worked, but oracle couldn't use the index of the date column.
You would have to create an index of the to_char(date column)-column.
Stefan
Rahkonen Jukka (Tike) jukka.rahko...@mmmtike.fi hat am 21. Januar 2014 um
15:25 geschrieben:
Hi,
Perhaps you can select the time into a format that Mapserver likes in your
DATA by using
to_char?http://docs.oracle.com/cd/B19306_01/server.102/b14200/functions180.htm
-Jukka Rahkonen-
D. Nappo wrote
...but unfortunately MapServer wms time support doesn't include that format:
http://mapserver.org/it/ogc/wms_time.html
2014/1/21 D. Nappo domenico.na...@gmail.com
mailto:domenico.na...@gmail.com
Many thanks!
It helped: the default date format in our system is DD-Mon-RR and I found it
out with SELECT * FROM nls_database_parameters WHERE parameter LIKE '%DATE%'
2014/1/20 Umberto Nicoletti umberto.nicole...@gmail.com
mailto:umberto.nicole...@gmail.com
On Mon, Jan 20, 2014 at 2:44 PM, D. Nappo domenico.na...@gmail.com
mailto:domenico.na...@gmail.com wrote:
Hi there,
I couldn't figure out how to solve this. I have a layer so configured:
LAYER
NAME layer
TYPE point
CONNECTION conn_string
CONNECTIONTYPE ORACLESPATIAL
TEMPLATE templates/hotspot_template.html
DATA SHAPE FROM (SELECT POINT as SHAPE, ACQ_DATE, ACQ_TIME, SATELLITE,
CONFIDENCE, VERSION, BRIGHT_T31, FRP FROM gwsprd.HOT_SPOTS_MODIS) using unique
OGR_FID
METADATA
wms_title WMS test
wms_srs EPSG:4326
wms_extent-180 -90 180 90
wms_timeextent 2000-01-01/2020-12-31
wms_timeitem acq_date
wms_timedefault 2014-01-01
wms_timeformat -MM-DD
Try with this:
wms_timeformat DD-MM-YY
it is the default format Oracle expects when converting a string to a date
and no format has been explicitly provided.
Hth,
Umberto
wms_enable_request *
END
CLASS
SYMBOL 'circle'
SIZE 2
COLOR255 0 0
END
END
Now, the date column in the oracle table is the acq_date field.
The problem is that Mapserver translates that with a wrong oracle query
(which it works in postgreslq, I guess):
SELECT OGR_FID,rownum, SHAPE FROM
(SELECT OGR_FID, POINT as SHAPE, ACQ_DATE, ACQ_TIME, SATELLITE,
CONFIDENCE, VERSION, BRIGHT_T31, FRP FROM gwsprd.HOT_SPOTS_MODIS)
WHERE acq_date = '2014-01-16'
The query above uses a wrong filter and it gives the error:
ORA-01861: literal does not match format string
How can I tell to Mapserver to use a correct query??? Or do I missing
anyhting???
Something like:
WHERE acq_date = to_date('2014-01-16','-MM-DD')
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org mailto:mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] GetFeatureInfo GML
Hi Mark, I show you my layer definition, which works. As I understand, the bold parameters in the metadata section are missing in your mapfile... (...) LAYER NAME odl_einstundenmittel TYPE POINT STATUS ON MINSCALEDENOM 11 METADATA WMS_TITLE blabla WMS_ABSTRACT blabla WMS_ENABLE_REQUEST * INCLUDE ../../include/general/standard_extent_germany_4326.map *GML_INCLUDE_ITEMS name,datum,WERT GML_name_ALIAS Station GML_datum_ALIAS Messende GML_WERT_ALIAS Messwert* END TEMPLATE blank.gml INCLUDE ../../include/general/db_mysql_connect_odl_result.map DATA blöbla TOLERANCE 6 TOLERANCEUNITS pixels INCLUDE ../../include/classes/class_odl_rb_nolabel.map END Regards, Stefan Am 25.03.2013 14:50, schrieb Mark Davidson: Here is my entire map file just in-case I’ve done something stupid. MAP PROJECTION init=epsg:4326 END FONTSET fonts.list NAME TEST STATUS ON SIZE 1000 1000 MAXSIZE 3000 EXTENT -180 -90 180 90 UNITS DD WEB METADATA ows_enable_request * wms_title Testing wms_onlineresource http://localhost/cgi-bin/mapserv?map=test2.map; http://localhost/cgi-bin/mapserv?map=test2.map; wms_srs EPSG:900913 END END SYMBOL NAME circle TYPE ellipse FILLED true POINTS 1 1 END END LAYER NAME test METADATA wms_titleTest Points ##required END TEMPLATE blank.html TOLERANCE 10 TYPE POINT CONNECTIONTYPE postgis CONNECTION DATA position from datatable DEBUG TRUE CLASS STYLE SIZE 10 SYMBOL circle COLOR 255 0 0 END END END END On 25 March 2013 13:42, Kralidis,Tom [Ontario] tom.krali...@ec.gc.ca mailto:tom.krali...@ec.gc.ca wrote: Mark: try (in LAYER) DUMP TRUE? Can you post the layer definition snippet from your mapfile? From: mapserver-users-boun...@lists.osgeo.org mailto:mapserver-users-boun...@lists.osgeo.org [mailto:mapserver-users-boun...@lists.osgeo.org mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Mark Davidson Sent: Monday, March 25, 2013 09:30 To: Stefan Schantz Cc: mapserver-users@lists.osgeo.org mailto:mapserver-users@lists.osgeo.org Subject: Re: [mapserver-users] GetFeatureInfo GML Hi Stefan, Thanks for the suggestion, I've tried that but still getting the same output as before. Any other suggestions? Thanks again, Mark On 25 March 2013 11:41, Stefan Schantz sscha...@bfs.de mailto:sscha...@bfs.de wrote: Hi Mark, I use gml_include_items 'all' Best regards Stefan Am 25.03.2013 11 tel:25.03.2013%2011:44, schrieb Mark Davidson: Hi All, I'm trying to do a GetFeaureInfo on my layer and return it in GML format. The request works fine but I can't seem to get any data to come back apart from the point bounds. ?xml version=1.0 encoding=ISO-8859-1? msGMLOutput xmlns:gml=http://www.opengis.net/gml; xmlns:xlink=http://www.w3.org/1999/xlink; xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance; test_layer gml:nameTest Points/gml:name test_feature gml:boundedBy gml:Box srsName=EPSG:900913 gml:coordinates-269220.293738,6545357.533946 -269220.293738,6545357.533946/gml:coordinates /gml:Box /gml:boundedBy /test_feature test_feature gml:boundedBy gml:Box srsName=EPSG:900913 gml:coordinates-253276.741855,6554416.311795 -253276.741855,6554416.311795/gml:coordinates /gml:Box /gml:boundedBy /test_feature /test_layer /msGMLOutput What I would like to be able to do is get the feature id as what happends with the plain output GetFeatureInfo results: Layer 'test' Feature 326: Feature 327: I've set `gml_include_items` to * and `wms_include_item` to * as well but still not having any luck. Could someone point me in the direction of doing this? Many thanks, Mark ___ mapserver-users mailing list mapserver-users@lists.osgeo.org mailto:mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users ___ mapserver-users mailing list mapserver-users@lists.osgeo.org mailto: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] Memory access error when accessing Oracle database
driver `OCI 'successful. Layer name: IMIS_GEO.TRAPKT_16386 Geometry: 3D Unknown (any) Feature Count: 7 Extent: (8.00, 50.00) - (16.00, 56.00) Layer SRS WKT: GEOGCS [WGS 84, DATUM [World Geodetic System 1984 (EPSG ID 6326), SPHEROID [WGS 84 (EPSG ID 7030), 6378137.0,298.257223563]] PRIMEM [Greenwich, 0.00], UNIT [Decimal Degree, 0.0174532925199433], AUTHORITY [EPSG. See 3D CRS for original information source., 4326]] Geometry Column = GEOM ID: Real (0.0) Trajectory: Real (0.0) STARTING TIME: Date (0.0) HOURS: Real (0.0) OUTPUT HEIGHT: Real (0.0) HEIGHT: Real (0.0) OGRFeature (IMIS_GEO.TRAPKT_16386): 0 ID (Real) = 1 Trajectory (Real) = 1 TIME OUT (Date) = 17/10/2012 HOURS (Real) = 0 OUTPUT HEIGHT (Real) = 632 HEIGHT (Real) = 632 POINT (8.7 50.11667 0) OGRFeature (IMIS_GEO.TRAPKT_16386): 1 ID (Real) = 2 Trajectory (Real) = 1 TIME OUT (Date) = 17/10/2012 HOURS (Real) = 12 OUTPUT HEIGHT (Real) = 632 HEIGHT (Real) = 584 POINT (12.7 56.15 0) OGRFeature (IMIS_GEO.TRAPKT_16386): 2 ID (Real) = 3 Trajectory (Real) = 2 TIME OUT (Date) = 17/10/2012 HOURS (Real) = 0 OUTPUT HEIGHT (Real) = 1632 HEIGHT (Real) = 1632 POINT (8.7 50.11667 0) OGRFeature (IMIS_GEO.TRAPKT_16386): 3 ID (Real) = 4 Trajectory (Real) = 2 TIME OUT (Date) = 17/10/2012 HOURS (Real) = 12 OUTPUT HEIGHT (Real) = 1632 HEIGHT (Real) = 1400 POINT (15.6 54.0 0) OGRFeature (IMIS_GEO.TRAPKT_16386): 4 ID (Real) = 5 Trajectory (Real) = 3 TIME OUT (Date) = 17/10/2012 HOURS (Real) = 0 OUTPUT HEIGHT (Real) = 3132 HEIGHT (Real) = 3132 POINT (8.7 50.11667 0) OGRFeature (IMIS_GEO.TRAPKT_16386): 5 ID (Real) = 6 Trajectory (Real) = 3 TIME OUT (Date) = 17/10/2012 HOURS (Real) = 12 OUTPUT HEIGHT (Real) = 3132 HEIGHT (Real) = 3036 POINT (16.86667 53.7 0) OGRFeature (IMIS_GEO.TRAPKT_16386): 6 ID (Real) = 7 Trajectory (Real) = 4 TIME OUT (Date) = 17/10/2012 HOURS (Real) = 0 OUTPUT HEIGHT (Real) = 5132 HEIGHT (Real) = 5132 POINT (8.7 50.11667 0) May anybody help me? Regards, Stefan -- Mit freundlichen Grüßen Stefan Schantz ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] Limitation of WMS-Time with MySql or Documentation Error?
Hello, I have a very principal question. Is it possible to setup a WMS-Time service with Mapserver, OGR and a MySQL database? I have read the documentation, and the example shows, that it possible with a Postgres database. I have tried it with a MySQL database, and I didn't get it work (at least I think, that it doesn't work as it should). I have heard, that there are some limitations in OGR supporting MySQL, there was nothing concrete. There is a part of the mapfile: LAYER NAME odl_wmst TYPE POINT STATUS ON INCLUDE ../../include/general/debug_layer.map #2 Zeilen DEBUG ON DUMP TRUE TOLERANCE 3 PROCESSING CLOSE_CONNECTION=DEFER CONNECTIONTYPE OGR CONNECTION MYSQL:onmon,host=10.130.63.11,user=user,password=password,port=3306,tables=result_current;locality DATA SELECT value AS wert, end_measure, locality.geom FROM result_current JOIN locality ON result_current.locality_code = locality.locality_code WHERE end_measure = '%time%' METADATA WMS_TITLEODL_WMS-T WMS_ABSTRACTODL_Paragraph2 INCLUDE ../../include/general/standard_extent_germany_4326.map wms_timeextent 2011-10-01/2011-12-31 wms_timeitem end_measure wms_timedefault 2011-12-21 wms_timeformat -MM-DD gml_include_items all END VALIDATION 'time' '^19|20)(([02468][048])|([13579][26]))-02-29))|((20[0-9][0-9])|(19[0-9][0-9]))-0[1-9])|(1[0-2]))-((0[1-9])|(1\d)|(2[0-8])))|0[13578])|(1[02]))-31)|(((0[1,3-9])|(1[0-2]))-(29|30)$' END ... END #LAYER I 've tried it with MapServer 5.6.5 (OGR 1.8), 6.0.1 (OGR 1.7). I don't get any errors. The only thing is, that i get a white picture. But if I remove the parameter wms_timeitem end_measure, it works, though the dokumentation tells, that the parameter wms_timeitem is mandatory. Is my WMS-Time service a really WMS-Time-Service without the wms_timeitem parameter? Has anybody a working WMS-Time service with MySQL? Thank you, Best regards und Merry Christmas! Stefan ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] Encoding problems in GetCapabilities-document with WMS_VERSION 1.3.0
Hi, I am running Mapserver 5.6.5. If I request the GetCapabilities with WMS_VERSION 1.1.1, I get a XML-Document encoding UTF-8 and the German Umlaute like üäö and so on are shown correctly. --- ?xml version='1.0' encoding=UTF-8 standalone=no ? !DOCTYPE WMT_MS_Capabilities SYSTEM http://schemas.opengis.net/wms/1.1.1/WMS_MS_Capabilities.dtd; [ !ELEMENT VendorSpecificCapabilities EMPTY ] !-- end of DOCTYPE declaration -- WMT_MS_Capabilities version=1.1.1 !-- MapServer version 5.6.5 OUTPUT=GIF OUTPUT=PNG OUTPUT=JPEG OUTPUT=WBMP OUTPUT=SVG SUPPORTS=PROJ SUPPORTS=AGG SUPPORTS=FREETYPE SUPPORTS=ICONV SUPPORTS=WMS_SERVER SUPPORTS=WMS_CLIENT SUPPORTS=WFS_SERVER SUPPORTS=WFS_CLIENT SUPPORTS=WCS_SERVER SUPPORTS=SOS_SERVER SUPPORTS=FASTCGI SUPPORTS=THREADS SUPPORTS=GEOS INPUT=TIFF INPUT=POSTGIS INPUT=OGR INPUT=GDAL INPUT=MYGIS INPUT=SHAPEFILE -- Service NameOGC:WMS/Name TitleHintergrundkarten Deutschland/Title AbstractKarte zum ÜÜberblick üüber Deutschland basierend auf DGM250 u.a./Abstract --- But if I change the request to WMS-VERSION 1.3.0 , my browser shows an error xml not well formed and the German Umlaute are not correct. - ?xml version='1.0' encoding=UTF-8 standalone=no ? WMS_Capabilities version=1.3.0 xmlns=http://www.opengis.net/wms; xmlns:sld=http://www.opengis.net/sld; xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance; xmlns:ms=http://mapserver.gis.umn.edu/mapserver; xsi:schemaLocation=http://www.opengis.net/wms http://schemas.opengis.net/wms/1.3.0/capabilities_1_3_0.xsd http://www.opengis.net/sld http://schemas.opengis.net/sld/1.1.0/sld_capabilities.xsd http://mapserver.gis.umn.edu/mapserver http://10.130.63.11/cgi-bin/mapserv?map=/data/mapserver/map/de_vector.mapamp;service=WMSamp;version=1.3.0amp;request=GetSchemaExtension; !-- MapServer version 5.6.5 OUTPUT=GIF OUTPUT=PNG OUTPUT=JPEG OUTPUT=WBMP OUTPUT=SVG SUPPORTS=PROJ SUPPORTS=AGG SUPPORTS=FREETYPE SUPPORTS=ICONV SUPPORTS=WMS_SERVER SUPPORTS=WMS_CLIENT SUPPORTS=WFS_SERVER SUPPORTS=WFS_CLIENT SUPPORTS=WCS_SERVER SUPPORTS=SOS_SERVER SUPPORTS=FASTCGI SUPPORTS=THREADS SUPPORTS=GEOS INPUT=TIFF INPUT=POSTGIS INPUT=OGR INPUT=GDAL INPUT=MYGIS INPUT=SHAPEFILE -- Service NameWMS/Name TitleHintergrundkarten Deutschland/Title AbstractKarte zum ��berblick ��ber Deutschland basierend auf DGM250 u.a./Abstract ... -- Is there anything I can do? Thanks! Best regards from Munich! Stefan ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] OCI-22053: overflow error with CONNECTIONTYPEoraclespatial
Hi Tim, with Georaptor I could draw all the point from the table without any error messages. But if I use the geom-validator, I get an error ORA-13000: dimension number is out of range. After I corrected the dimension number, the error message from the UMN disappeared. Thank you! Stefan Nolte, Tim schrieb: Stefan, Do you have the Georaptor extension installed in SQL Dev? Have you tried to run the verification on all of the geom data in that table? - Tim Timothy J Nolte - tno...@ilpcs.com Network Planning Engineer 4717 Broadmoor Ave, Suite G Kentwood, MI 49512 Office: 616-656-5163 PCS: 616-706-2438 Support: 616-929-0289 Fax: 616-554-6484 -Original Message- From: mapserver-users-boun...@lists.osgeo.org [mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Stefan Schantz Sent: Wednesday, February 03, 2010 7:55 AM To: mapserver-users@lists.osgeo.org Subject: [mapserver-users] OCI-22053: overflow error with CONNECTIONTYPEoraclespatial Hello, I am trying to visualize some points from a oracle database (10.2) : I am using MapServer version 5.2.0 OUTPUT=GIF OUTPUT=PNG OUTPUT=JPEG OUTPUT=WBMP OUTPUT=SVG SUPPORTS=PROJ SUPPORTS=AGG SUPPORTS=FREETYPE SUPPORTS=ICONV SUPPORTS=WMS_SERVER SUPPORTS=WMS_CLIENT SUPPORTS=WFS_SERVER SUPPORTS=WFS_CLIENT SUPPORTS=WCS_SERVER SUPPORTS=GEOS INPUT=EPPL7 INPUT=POSTGIS INPUT=ORACLESPATIAL INPUT=OGR INPUT=GDAL INPUT=SHAPEFILE My layer description is LAYER NAME tra_punkte TYPE POINT STATUS ON DEBUG ON #DUMP TRUE CONNECTIONTYPE oraclespatial CONNECTION ***/***@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=***)(PORT= 1521)))(CONNECT_DATA=(SID=***))) DATA GEOM from (select geom, HOEHE, AUSGANGSHOEHE, ID FROM imis_geo.trapkt_6222 ) USING UNIQUE ID SRID 4326 --- and the following statement is written in the log-file -- [Wed Feb 3 12:54:00 2010].603594 msOracleSpatialLayerWhichShapes. Using this Sql to retrieve the data: SELECT ID, GEOM FROM (select geom, HOEHE, AUSGANGSHOEHE, ID FROM imis_geo.trapkt_6222 ) WHERE SDO_FILTER( GEOM, MDSYS.SDO_GEOMETRY(2003, 4326, NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(-70.5721827,29.3243683,69.9787827,79.1709317) ),'querytype=window') = 'TRUE' [Wed Feb 3 12:54:00 2010].823525 osGetOrdinates(): OracleSpatial error. OCI-22053: overflow error -- But if I try the sql in SQL-Developer, i get the result without any errors? The connection between UMN and oracle database is working fine in several different layers, but not in this one. Is there anything I can do? Best Regards, Stefan ___ 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] OCI-22053: overflow error with CONNECTIONTYPE oraclespatial
Hello, I am trying to visualize some points from a oracle database (10.2) : I am using MapServer version 5.2.0 OUTPUT=GIF OUTPUT=PNG OUTPUT=JPEG OUTPUT=WBMP OUTPUT=SVG SUPPORTS=PROJ SUPPORTS=AGG SUPPORTS=FREETYPE SUPPORTS=ICONV SUPPORTS=WMS_SERVER SUPPORTS=WMS_CLIENT SUPPORTS=WFS_SERVER SUPPORTS=WFS_CLIENT SUPPORTS=WCS_SERVER SUPPORTS=GEOS INPUT=EPPL7 INPUT=POSTGIS INPUT=ORACLESPATIAL INPUT=OGR INPUT=GDAL INPUT=SHAPEFILE My layer description is LAYER NAME tra_punkte TYPE POINT STATUS ON DEBUG ON #DUMP TRUE CONNECTIONTYPE oraclespatial CONNECTION ***/***@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=***)(PORT= 1521)))(CONNECT_DATA=(SID=***))) DATA GEOM from (select geom, HOEHE, AUSGANGSHOEHE, ID FROM imis_geo.trapkt_6222 ) USING UNIQUE ID SRID 4326 --- and the following statement is written in the log-file -- [Wed Feb 3 12:54:00 2010].603594 msOracleSpatialLayerWhichShapes. Using this Sql to retrieve the data: SELECT ID, GEOM FROM (select geom, HOEHE, AUSGANGSHOEHE, ID FROM imis_geo.trapkt_6222 ) WHERE SDO_FILTER( GEOM, MDSYS.SDO_GEOMETRY(2003, 4326, NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(-70.5721827,29.3243683,69.9787827,79.1709317) ),'querytype=window') = 'TRUE' [Wed Feb 3 12:54:00 2010].823525 osGetOrdinates(): OracleSpatial error. OCI-22053: overflow error -- But if I try the sql in SQL-Developer, i get the result without any errors? The connection between UMN and oracle database is working fine in several different layers, but not in this one. Is there anything I can do? Best Regards, Stefan ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] VRT / CSV data sources are not displayed in a layer
Hi Greg, thank you! The issue was the two blanks ahead the coordinates. After I have removed them, the mapserver visualized the csv-file. Nevertheless, I don't understand, why ogr2ogr could read and transform the csv-file, but this is a different issue... Thanks! Stefan greg.lu...@scu.edu.au schrieb: Hi Stefan, I'm not an expert, but I see 2 things that I have found might produce problems: x-utm,y-utm,Wert Try renaiming your fields without hyphens ie xutm,yutm,wert and encoding=PointFromColumns x=xutm y=yutm/ and remove the decimal point and convert to non-scientific number: 742226., 5374978., 0.00E+00 try: 742226, 5374978,0 Does that help any? Thanks, Greg. Greg Luker GIS Lab Manager Southern Cross University Australia 61 2 66203026 ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] VRT / CSV data sources are not displayed in a layer
Hello List, The following layer uses a CSV-file (together with a VRT-File (Virtual Format) ) as datasource . When I try to visualize the layer, nothing is shown (neither the data nor error messages; shp2img shows also nothing) LAYER NAME boden DEBUG on STATUS ON TYPE POINT # DATA /daten/csv/boden/boden # Datenquelle Shapefile CONNECTION /daten/csv/boden.vrt CONNECTIONTYPE OGR PROJECTION init=epsg:25832 END METADATA WMS_TITLEtest WMS_SRS EPSG:25832 WMS_ABSTRACTtest WMS_FEATURE_INFO_MIME_TYPE 'text/html' END CLASS NAME test STYLE SYMBOL circle SIZE 15 COLOR 90 90 90 END END END But if I transform the CSV/VRT-file into a Shapefile via ogr2ogr ogr2ogr -s_srs EPSG:25832 -t_srs EPSG:25832 -f ESRI Shapefile boden boden.vrt the layer displays the data. What is wrong with my VRT/CSV-datasource in the mapfile? Thanks for any idea. Best regards Stefan ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] VRT / CSV data sources are not displayed in a layer
Hello Carlos, my CSV-file ans VRT-file looks like your examples: My CSV is x-utm,y-utm,Wert 742226., 5374978., 0.00E+00 743422., 5375072., 0.00E+00 744620., 5375166., 0.00E+00 ... and my VTR is OGRVRTDataSource OGRVRTLayer name=boden SrcDataSource/daten/csv/boden.csv/SrcDataSource GeometryTypewkbPoint/GeometryType GeometryField encoding=PointFromColumns x=x-utm y=y-utm/ /OGRVRTLayer /OGRVRTDataSource and as I wrote, ogr2ogr could read my vrt/csv data and transform it into a shapefile.. Stefan Carlos Ruiz schrieb: Check that you have your CSV like this: Lat,Lng,House 48.1,0.25,My house 49.2,1.1,My girlfriend's house 47.5,0.75,My mother in law's house And that you have your VTR like this: OGRVRTDataSource OGRVRTLayer name=neighborhood SrcDataSource[FILE]/SrcDataSource GeometryTypewkbPoint/GeometryType LayerSRS[YOUR SRS]/LayerSRS GeometryField encoding=PointFromColumns x=Lng y=Lat/ /OGRVRTLayer /OGRVRTDataSource IC Carlos Ruiz *From:* Stefan Schantz sscha...@bfs.de *To:* mapserver-users@lists.osgeo.org *Sent:* Wed, January 20, 2010 9:32:12 AM *Subject:* [mapserver-users] VRT / CSV data sources are not displayed in a layer Hello List, The following layer uses a CSV-file (together with a VRT-File (Virtual Format) ) as datasource . When I try to visualize the layer, nothing is shown (neither the data nor error messages; shp2img shows also nothing) LAYER NAME boden DEBUG on STATUS ON TYPE POINT # DATA /daten/csv/boden/boden # Datenquelle Shapefile CONNECTION /daten/csv/boden.vrt CONNECTIONTYPE OGR PROJECTION init=epsg:25832 END METADATA WMS_TITLEtest WMS_SRS EPSG:25832 WMS_ABSTRACTtest WMS_FEATURE_INFO_MIME_TYPE 'text/html' END CLASS NAME test STYLE SYMBOL circle SIZE 15 COLOR 90 90 90 END END END But if I transform the CSV/VRT-file into a Shapefile via ogr2ogr ogr2ogr -s_srs EPSG:25832 -t_srs EPSG:25832 -f ESRI Shapefile boden boden.vrt the layer displays the data. What is wrong with my VRT/CSV-datasource in the mapfile? Thanks for any idea. Best regards Stefan ___ mapserver-users mailing list mapserver-users@lists.osgeo.org mailto: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] VRT / CSV data sources are not displayed in a layer
Well, here is the MAP definition, but the same mapfile works with the Shapefile, which I have transformed from the CSV/VRT-files, so I think, that the mapfile shouldn't be the issue. Stefan - MAP NAME rodos_bgefirst STATUS ON EXTENT 458690.8459237 1746161.3670216 6216440.5477323 6216440.5477323 UNITS METERS DEBUG 5 CONFIG MS_ERRORFILE /data/tmp/ms_debug.log SYMBOLSET ../symbols/symbols.sym FONTSET ../fonts/fonts.list SHAPEPATH /daten/rasterkarten/ PROJECTION init=epsg:3035 END OUTPUTFORMAT NAME png DRIVER GD/PNG MIMETYPE image/png EXTENSION PNG IMAGEMODE PC256 TRANSPARENT ON END WEB IMAGEPATH /data/tmp/ IMAGEURL http://10.162.18.107/tmp/; METADATA WMS_ACCESSCONSTRAINTSnone WMS_SRS EPSG:4326 EPSG:32632 EPSG:25832 EPSG:31466 EPSG:31467 EPSG:31468 EPSG:3035 WMS_ONLINERESOURCE http://10.162.18.107/cgi-bin/mapserv?map=/data/umn/bfs/map/rodos_bgefirst_ssh.map; WMS_TITLERODOS Prognose Karte interpoliert WMS_FEATURE_INFO_MIME_TYPEtext/html WMS_ABSTRACTRODOS Prognose Karte END END INCLUDE ../include/legend_rodos.map --- Carlos Ruiz schrieb: Can you show me the MAP definition ? Maybe I can find something there IC Carlos Ruiz *From:* Stefan Schantz sscha...@bfs.de *To:* Carlos Ruiz boolean10...@yahoo.com *Cc:* mapserver-users@lists.osgeo.org *Sent:* Wed, January 20, 2010 12:01:40 PM *Subject:* Re: [mapserver-users] VRT / CSV data sources are not displayed in a layer Hello Carlos, my CSV-file ans VRT-file looks like your examples: My CSV is x-utm,y-utm,Wert 742226., 5374978., 0.00E+00 743422., 5375072., 0.00E+00 744620., 5375166., 0.00E+00 ... and my VTR is OGRVRTDataSource OGRVRTLayer name=boden SrcDataSource/daten/csv/boden.csv/SrcDataSource GeometryTypewkbPoint/GeometryType GeometryField encoding=PointFromColumns x=x-utm y=y-utm/ /OGRVRTLayer /OGRVRTDataSource and as I wrote, ogr2ogr could read my vrt/csv data and transform it into a shapefile.. Stefan Carlos Ruiz schrieb: Check that you have your CSV like this: Lat,Lng,House 48.1,0.25,My house 49.2,1.1,My girlfriend's house 47.5,0.75,My mother in law's house And that you have your VTR like this: OGRVRTDataSource OGRVRTLayer name=neighborhood SrcDataSource[FILE]/SrcDataSource GeometryTypewkbPoint/GeometryType LayerSRS[YOUR SRS]/LayerSRS GeometryField encoding=PointFromColumns x=Lng y=Lat/ /OGRVRTLayer /OGRVRTDataSource IC Carlos Ruiz *From:* Stefan Schantz sscha...@bfs.de mailto:sscha...@bfs.de *To:* mapserver-users@lists.osgeo.org mailto:mapserver-users@lists.osgeo.org *Sent:* Wed, January 20, 2010 9:32:12 AM *Subject:* [mapserver-users] VRT / CSV data sources are not displayed in a layer Hello List, The following layer uses a CSV-file (together with a VRT-File (Virtual Format) ) as datasource . When I try to visualize the layer, nothing is shown (neither the data nor error messages; shp2img shows also nothing) LAYER NAME boden DEBUG on STATUS ON TYPE POINT # DATA /daten/csv/boden/boden # Datenquelle Shapefile CONNECTION /daten/csv/boden.vrt CONNECTIONTYPE OGR PROJECTION init=epsg:25832 END METADATA WMS_TITLEtest WMS_SRS EPSG:25832 WMS_ABSTRACTtest WMS_FEATURE_INFO_MIME_TYPE 'text/html' END CLASS NAME test STYLE SYMBOL circle SIZE 15 COLOR 90 90 90 END END END But if I transform the CSV/VRT-file into a Shapefile via ogr2ogr ogr2ogr -s_srs EPSG:25832 -t_srs EPSG:25832 -f ESRI Shapefile boden boden.vrt the layer displays the data. What is wrong with my VRT/CSV-datasource in the mapfile? Thanks for any idea. Best regards Stefan ___ mapserver-users mailing list mapserver-users@lists.osgeo.org mailto:mapserver-users@lists.osgeo.org mailto:mapserver-users@lists.osgeo.org mailto: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] Query Error in getFeatureRequest on Oracle DB
Hello,
I have a layer that gets its data from an Oracle database. The layer can
be visualized without any problems.
As soon as I send a getFeatureRequest, the following error message appears
msOracleSpatialLayerGetItems (): Query error. Can not retrieve column
list
In the UMN log file are 2 SQLs. The one with the spatial SQL query works
with the
Oracle Developer and I get a result. Why doesn't get my UMN (version
5.2) any data?
Thanks for your support!
Regards
Stefan Schantz
# Ausschnitt Layerdefinition##
LAYER
NAME aero_nukspez_cs137
STATUS ON
DEBUG ON
TYPE POINT
PROJECTION
init=epsg:25832
END
METADATA
...
END
DUMP TRUE
CONNECTIONTYPE oraclespatial
CONNECTION
***/***@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=***)(PORT=
1521)))(CONNECT_DATA=(SID=***)))
PROCESSING CLOSE_CONNECTION=DEFER
DATA GEOM from (SELECT
geom,
P_PROBE.PROBEENTNAHME_BEGINN,
P_PROBE.PROBEENTNAHME_ENDE,
S_MESSGROESSE.BEZEICHNUNG,
to_char(P_MESSWERT.MESSWERT, '0.9') AS WERT,
S_MESS_EINHEIT1.BEZEICHNUNG,
P_MESSWERT.MESSFEHLER,
P_PROBE.MITTELUNGSDAUER,
S_NETZ_BETREIBER.BEZEICHNUNG,
dwd_mess_utm.mst_id AS ID,
P_ENTNAHMEORT.KOORD_X_UTM,
P_ENTNAHMEORT.KOORD_Y_UTM,
((R_VORGANG.OID)-(255297803876564992)),
R_VORGANG.AUSFUEHRUNGSDATUM,
P_MESSUNG.STATUS_1,
P_MESSUNG.STATUS_2,
P_MESSUNG.STATUS_4,
S_STATUS_BMU.BEZEICHNUNG,
P_PROBE.IST_TESTDATENSATZ
FROM
dwd_mess_utm,IMIS.P_ENTNAHMEORT,IMIS.S_MESS_EINHEIT
S_MESS_EINHEIT1,IMIS.S_MESSGROESSE,IMIS.S_STATUS_BMU,IMIS.P_MESSUNG,IMIS.S_NETZ_BETREIBER,IMIS.P_MESSWERT,IGS2.R_VORGANG_MESSUNG_P,IMIS.P_PROBE,IMIS.S_MESS_STELLE
S_MESS_STELLE14,IGS2.R_VORGANG
WHERE
(R_VORGANG_MESSUNG_P.S_OID = R_VORGANG.OID(+)
AND R_VORGANG_MESSUNG_P.T_PROBE_ID(+) = P_MESSUNG.PROBE_ID
AND R_VORGANG_MESSUNG_P.T_MESSUNGS_ID(+) = P_MESSUNG.MESSUNGS_ID
AND p_probe.mst_id = dwd_mess_utm.mst_id
AND P_ENTNAHMEORT.PROBE_ID = P_PROBE.PROBE_ID
AND P_MESSUNG.STATUS_5 = S_STATUS_BMU.STATUS_5
AND S_MESS_STELLE14.NETZBETREIBER_ID =
S_NETZ_BETREIBER.NETZBETREIBER_ID
AND P_MESSUNG.PROBE_ID = P_PROBE.PROBE_ID
AND P_MESSWERT.MESSGROESSE_ID = S_MESSGROESSE.MESSGROESSE_ID
AND P_ENTNAHMEORT.PROBE_ID = P_PROBE.PROBE_ID
AND P_PROBE.MST_ID = S_MESS_STELLE14.MST_ID
AND P_MESSWERT.PROBE_ID = P_MESSUNG.PROBE_ID
AND P_MESSWERT.MESSUNGS_ID = P_MESSUNG.MESSUNGS_ID
AND P_MESSWERT.MEH_ID = S_MESS_EINHEIT1.MEH_ID
AND (P_PROBE.UMW_ID IN ('L31'))
AND (P_MESSWERT.MESSGROESSE_ID IN (373))
AND (P_ENTNAHMEORT.STAAT_ID IN (0))
AND (P_PROBE.DATENBASIS_ID IN (1))
AND (P_PROBE.NETZBETREIBER_ID IN ('W'))
AND P_PROBE.PROBEENTNAHME_BEGINN = TO_DATE('16.12.2009
06:00','DD.MM. HH24:MI')))
USING UNIQUE ID SRID 25832
TEMPLATE ../templates/getFeature_ODL.html
...
###end layer definition###
# MS LOGFILE##
[Fri Dec 18 08:36:05 2009].932804 msOracleSpatialLayerClose. Cleaning
Oracle Cache.
[Fri Dec 18 08:36:05 2009].932814 msOracleSpatialLayerClose. Release the
Oracle Pool.
[Fri Dec 18 08:36:05 2009].932816
msConnPoolRelease(aero_nukspez_cs137,i/***@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=***)(PORT=
1521)))(CONNECT_DATA=(SID=***))),82368a8)
[Fri Dec 18 08:36:05 2009].932981
msConnPoolClose(***/***@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=***)(PORT=
1521)))(CONNECT_DATA=(SID=***))),82368a8)
[Fri Dec 18 08:36:06 2009].470320 msOracleSpatialLayerOpen called with:
GEOM from (SELECT
geom,
P_PROBE.PROBEENTNAHME_BEGINN,
P_PROBE.PROBEENTNAHME_ENDE,
S_MESSGROESSE.BEZEICHNUNG,
to_char(P_MESSWERT.MESSWERT, '0.9') AS WERT,
S_MESS_EINHEIT1.BEZEICHNUNG,
P_MESSWERT.MESSFEHLER,
P_PROBE.MITTELUNGSDAUER,
S_NETZ_BETREIBER.BEZEICHNUNG,
dwd_mess_utm.mst_id AS ID,
P_ENTNAHMEORT.KOORD_X_UTM,
P_ENTNAHMEORT.KOORD_Y_UTM,
((R_VORGANG.OID)-(255297803876564992)),
R_VORGANG.AUSFUEHRUNGSDATUM,
P_MESSUNG.STATUS_1,
P_MESSUNG.STATUS_2,
P_MESSUNG.STATUS_4,
S_STATUS_BMU.BEZEICHNUNG,
P_PROBE.IST_TESTDATENSATZ
FROM
dwd_mess_utm,IMIS.P_ENTNAHMEORT,IMIS.S_MESS_EINHEIT
S_MESS_EINHEIT1,IMIS.S_MESSGROESSE,IMIS.S_STATUS_BMU,IMIS.P_MESSUNG,IMIS.S_NETZ_BETREIBER,IMIS.P_MESSWERT,IGS2.R_VORGANG_MESSUNG_P,IMIS.P_PROBE,IMIS.S_MESS_STELLE
S_MESS_STELLE14,IGS2.R_VORGANG
WHERE
(R_VORGANG_MESSUNG_P.S_OID = R_VORGANG.OID(+)
AND R_VORGANG_MESSUNG_P.T_PROBE_ID(+) = P_MESSUNG.PROBE_ID
AND R_VORGANG_MESSUNG_P.T_MESSUNGS_ID(+) = P_MESSUNG.MESSUNGS_ID
AND p_probe.mst_id = dwd_mess_utm.mst_id
[mapserver-users] JOIN SHP and CSV
Hello, although I 've read several informations (in this user list, mapserver documentation) about joining datas von a csv-file to a shp-file, I still get the error message Content-type: application/vnd.ogc.se_xml msDBFJoinConnect(): Unable to access file. (../../../../daten/vektordaten/utm/studios/europa_sonnenstudio.csv) I 've tried already several things like putting csv-file at the same place as the mapfile, chmod 777 , but I always got the same message. Any ideas? Thanks! My mapfile looks like: LAYER NAME europa TYPE POLYGON STATUS ON DUMP TRUE DATA europa JOIN NAME tab TABLE ../../../../daten/vektordaten/utm/studios/europa_sonnenstudio.csv FROM NAME TO NAME TYPE ONE-TO-ONE END PROJECTION init=epsg:4326 END METADATA WMS_SRS EPSG:25832 EPSG:4326 EPSG:32632 EPSG:31466 EPSG:31467 EPSG:31468 WMS_TITLE Sonnenstudio WMS_ABSTRACT blabla END LABELITEM 'NAME' CLASS ... END # CLASS CLASS .. END # CLASS TEMPLATE ../templates/getFeature_sonnenstudio.html .. The path to the data is /daten/vektordaten/utm/studios/europa_sonnenstudio.csv 303140 -rwxrwxrwx 1 ssh-mgdi 2229 Sep 30 11:27 europa_sonnenstudio.csv path to the mapfile is /data/umn/abc/map/studio.map The information of the csv-data is: ogrinfo europa_sonnenstudio.csv europa_sonnenstudio -summary INFO: Open of `europa_sonnenstudio.csv' using driver `CSV' successful. Layer name: europa_sonnenstudio Geometry: None Feature Count: 54 Layer SRS WKT: (unknown) ID: String (0.0) NAME: String (0.0) TEXT: String (0.0) DATUM: String (0.0) The information of the shp-data is: ogrinfo europa.shp europa -summary INFO: Open of `europa.shp' using driver `ESRI Shapefile' successful. Layer name: europa Geometry: Polygon Feature Count: 54 Extent: (-31.265747, 32.397476) - (69.070320, 81.857368) Layer SRS WKT: (unknown) NAME: String (40.0) Greetings from the Bavarian-Oktoberfest Stefan ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] classification of a raster image is changing
Hello list, I have the following problem with UMNMapserver 5.2: I have interpolated some data with gdal_grid. As the result I got a tiff file with one band. In the next step i classified the raster image in UMN Mapserver like this: (..) CLASS NAME = 12 h EXPRESSION ([pixel] 9 AND [pixel] = 12) STYLE COLOR 65 182 196 END END (..) so far so good But if i view the image in a client like QGIS, the classification (colors) is changing depending on the chosen section (see appendix). What is my mistake? Thanks for helping! Regards Stefan ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] prevent certain output formats
Hello, is it possible to prevent, that the UMN MapServer uses the output format gif? i tried it with the setting of the imagetype, but in the capabilities document, all output formats are available. mapfile: (...) IMAGETYPE aggpng24 OUTPUTFORMAT NAME aggpng24 DRIVER AGG/PNG MIMETYPE image/png IMAGEMODE RGB EXTENSION png END OUTPUTFORMAT NAME jpeg DRIVER GD/JPEG MIMETYPE image/jpeg IMAGEMODE RGB EXTENSION jpg END (...) GetCapabilities document: (...) GetMap Formatimage/png/Format Formatimage/jpeg/Format Formatimage/gif/Format Formatimage/png; mode=24bit/Format Formatimage/vnd.wap.wbmp/Format Formatimage/tiff/Format Formatimage/svg+xml/Format DCPType (...) Thanks for helping! kind regards Stefan ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
