[mapserver-users] Retrieve function values from Postgres

2012-12-11 Thread Heiko Schröter
Hello, is it possible for mapserver to question a function in a postgres geo database ? i.e. this query string inside postgres works: "select * from get_aerosol_data('gas_db', 25.5, '2005-3-2 00:00', '2006-3-5 00:00');" If it is possible how to translate this into mapserver mapfile syntax ?

[mapserver-users] Dynamic 'OnMouseOver' Info generation vom PostGIS/Postgres

2009-04-02 Thread Heiko Schröter
Hello all, we are displaying satellite measurement geolocations with Mapserver and PostGIS/Postgres underneath. I would like to add a feature (similar to the MapServer:ImagMap stuff) that displays some more info about the point on which the mouse is over inside the map. i.e. geolocation, name

[mapserver-users] Layer Object Parameter Substitution from URL using GIS

2009-04-06 Thread Heiko Schröter
Hello, when passing a 'FILTER' parameter to be changed with the URL to use GIS requests, mapserv(5.0.3) fails with: loadLayer(): Unknown identifier. Parsing error near (FILTER):(line 1) The call is: http://localhost/cgi-bin/mapserv?MAP=/MapServer/country98/heiko1.map&; LAYERS=karte,grid,psc&SER

Re: [mapserver-users] Layer Object Parameter Substitution from URLusing GIS

2009-04-07 Thread Heiko Schröter
FILTER 'wert=%myval%' > > It's also easier to secure. > > Steve > > >>> On 4/6/2009 at 4:01 AM, in message > > <200904061101.54781.schro...@iup.physik.uni-bremen.de>, Heiko Schröter > > wrote: > > Hello, > > > > when pa

Re: [mapserver-users] Layer Object Parameter Substitution from URLusing GIS

2009-04-07 Thread Heiko Schröter
be passed for the > variable. Another solution is > to consider using runtime substitution to do something similar. That > works well if the SQL is > pretty much fixed: > > FILTER 'wert=%myval%' > > It's also easier to secure. > > Steve > > >&g

Re: [mapserver-users] Layer Object Parameter Substitution fromURLusing GIS

2009-04-08 Thread Heiko Schröter
#x27;, > }, > { ratio:1, singleTile:true, transitionEffect:'resize', > isBaseLayer:false } > ); > > You can then modify the content of the 'somevar' variable. With code > like: > > myLayer.params.somevar = 'somenewvalue'; > > Thi

Re: [mapserver-users] Layer Object Parameter Substitution fromURLusing GIS

2009-04-08 Thread Heiko Schröter
On Dienstag, 7. April 2009 15:52:10 you wrote: Hello Steve, this seem to fail as well. Funny enough i needed to change the Layernames to uppercase in OpenLayer. But anyway: var kartenstring = "karte,grid,psc"; var somevalue = "FILTER+'orbitnr=4567' "; layer = new OpenLayers

Re: [mapserver-users] Layer Object Parameter Substitution fromURLusing GIS

2009-04-08 Thread Heiko Schröter
Hello Steve, Mapserver fails by just scanning the mapfile. Did fetch the 5.4_rc1 and installed it. But same behaviour as with the 5.4_beta. /usr/lib/cgi-bin/mapserv -v MapServer version 5.4.0-rc1 OUTPUT=GIF OUTPUT=PNG OUTPUT=JPEG OUTPUT=WBMP OUTPUT=SVG SUPPORTS=PROJ SUPPORTS=FREETYPE SUPPORTS=I

[mapserver-users] Use of a Colortable

2009-04-15 Thread Heiko Schröter
Hello,, we are mapping global satellite data with postgis. Is it possible with mapserver to change the color of the symbol according to the value read in from postgis ? Now the color is fixed within the mapfile reading only the geolocations i.e. LAYER CONNECTION "user=bla password=blub dbname

Re: [mapserver-users] Use of a Colortable

2009-04-15 Thread Heiko Schröter
On Mittwoch, 15. April 2009 16:02:23 Jeff McKenna wrote: Hello, yep, i think i got the idea. I've just checked the [color_me] access and this works. Probably the (or my) way to go is to store the color value inside the postgis table as extra column as suggested. The other idea by Espen works t

[mapserver-users] Passing single quoted strings

2009-04-20 Thread Heiko Schröter
Hello, i have to pass single quoted strings from Open Layer through mapserver to a postgis/postgres database. i.e. "filter 'value=1 and datum between '2005-1-1' and '2005-1-3' "; The postgres db expects (afaik) the date in a single quoted string. The problem is that mapserver stops scanning the

Re: [mapserver-users] Passing single quoted strings

2009-04-23 Thread Heiko Schröter
;geocenter from sacura_big" VALIDATION 'filter' "^."# Just for testing END FILTER "orbitnr=0" TYPE POINT SIZEUNITS meters CLASS NAME "sacura_big_class"

Re: [mapserver-users] Passing single quoted strings

2009-04-23 Thread Heiko Schröter
ed single quotes on a string > with internal single quotes. That would have broken a mapfile too. > Might want to post a summary > solution to your last message to the whole list. > > Steve > > >>> On 4/23/2009 at 8:01 AM, in message > > <200904231501.50805.schro...@

[mapserver-users] Rewarping/Reprojection with GDAL and -wo EXTRA_SOURCE parameter

2013-12-17 Thread Heiko Schröter
Hello all, we need to rewarp epsg:4326 to polar i.e. "+proj=ortho +over +lon_0=0 +lat_0=90 +ellps=WGS84 +datum=WGS84 +units=m +no_defs" for satellite data projection. The problem is that not enough data are read from the source raster image and the map is "cutout" at the poles. gdalwarp can

Re: [mapserver-users] Rewarping/Reprojection with GDAL and -wo EXTRA_SOURCE parameter

2013-12-17 Thread Heiko Schröter
-Ursprüngliche Nachricht- Von: mapserver-users-boun...@lists.osgeo.org [mailto:mapserver-users- boun...@lists.osgeo.org] Im Auftrag von Heiko Schröter Gesendet: Dienstag, 17. Dezember 2013 14:09 An: mapserver-users@lists.osgeo.org Betreff: [mapserver-users] Rewarping/Reprojection with GDAL

Re: [mapserver-users] Rewarping/Reprojection with GDAL and -wo EXTRA_SOURCE parameter

2013-12-17 Thread Heiko Schröter
Am 17.12.2013 17:57, schrieb Eichner, Andreas - SID-NLKM: Can you try if PROCESSING "POLYLINE_NO_CLIP=YES" helps on TYPE LINE layers? -Ursprüngliche Nachricht- Von: Heiko Schröter [mailto:schro...@iup.physik.uni-bremen.de] Gesendet: Dienstag, 17. Dezember 2013 16:46 An: Eichner, A

Re: [mapserver-users] Rewarping/Reprojection with GDAL and -wo EXTRA_SOURCE parameter

2013-12-18 Thread Heiko Schröter
TERVAL 15 MAXINTERVAL 60 MAXSUBDIVIDE 360 END END # Layer END # Ende Map Am 18.12.2013 11:27, schrieb Eichner, Andreas - SID-NLKM: Can you provide a simple test case, probably a MAP file with inline data? I've created some simple test data but I am unable to reproduce the

Re: [mapserver-users] Rewarping/Reprojection with GDAL and -wo EXTRA_SOURCE parameter

2013-12-18 Thread Heiko Schröter
d mapserver and use PROCESSING "FORCE_FULL_EXTENT=YES" In a vector layer . As said, this should be considered a quick fix. A bug should be reported on this as other parts in the code path seem to deal more nicely in such situations. HTH -Ursprüngliche Nachricht- Vo

Re: [mapserver-users] Rewarping/Reprojection with GDAL and -wo EXTRA_SOURCE parameter

2013-12-19 Thread Heiko Schröter
=stro3_21&REQUEST=GETMAP&SERVICE=WMS&SRS=EPSG:0816&STYLES=&TI ME=2006-10-06%2000:00/2006-10-08%2023:59&TODAT=2006-08- 07%2023:59&TRANSPARENT=FALSE&VERSION=1.1.1&WIDTH=600&HEIGHT=600 -- --- D

[mapserver-users] MapServer CGI GDAL Raster reprojection

2009-10-13 Thread Heiko Schröter
ncl.): 0.307s [Tue Oct 13 10:29:35 2009].958856 msFreeMap(): freeing map at 0x1729dc0. -- --- !!! NEUE TELEPHONNUMMER !!! !!! NEW PHONE NUMBER !!! Dipl.-Ing. Heiko Schröter Institute of Environmental Physics (IUP)phone: ++49

Re: [mapserver-users] MapServer CGI GDAL Raster reprojection

2009-10-13 Thread Heiko Schröter
ND > > If you want to get the image through WMS I suppose you should give it your > own EPSG number and add corresponding line to epsg file, just like it has > been done with EPSG:900913. > > -Jukka Rahkonen- > > > Heiko Schröter wrote: > > > > Hi, &g

Re: VS: [mapserver-users] MapServer CGI GDAL Raster reprojection

2009-10-13 Thread Heiko Schröter
t;lat_0=90". > There is no difference in reprojecting raster or vector data. This is a > working example of one orthophoto layer: > METADATA >"wms_title""orthophotos 92-96" >"wms_srs" "EPSG:2393 EPSG:3067 EPSG:4326 EPSG:900913&quo

[mapserver-users] MapServer CGI GdalWarp parameter passing

2009-10-15 Thread Heiko Schröter
Hi, i need to pass parameters for Reprojection via mapservers CGI interface to gdalwarp. Gdalwarp needs the '-wo SOURCE_EXTRA=x' to do the reprojection properly. How can this Parameter beeing passed to gdalwarp ? Tried the PROCESSING='-wo SOURCE...' key, but probably got the syntax wrong or th

Re: [mapserver-users] MapServer CGI GdalWarp parameter passing

2009-10-16 Thread Heiko Schröter
> MapServer does not use gdalwarp or it's underlying algorithm. these Frank, hm, probably i got the docs mixed up because of the 'geospatial raster formats' line at GDAL/OGR. Could a clear hint make it into the docs, please ? (Because i've been trying hard to get gdalwarp up and running in th

[mapserver-users] WMS TIME parameter slow

2010-03-10 Thread Heiko Schröter
Hello, using mapserv (5.6.1) with PostGIS (8.3) and accessing ten-thousands of geo locations in the PostGIS db results in very slow speed when using the WMS TIME parameter: (in this example the number is about 4000 datapoints for this day, timing measurements with DEBUG OFF). 1) Very fast usin

Re: [mapserver-users] WMS TIME parameter slow

2010-03-10 Thread Heiko Schröter
ement > loggging in PgSQL and extract the SQL that is being run against the > database. Then you can put that into PgAdmin or psql and get EXPLAIN > ANALYZE results which will tell you why there's a problem, hopefully. > > P. > > On Wed, Mar 10, 2010 at 7:22 AM, Heiko

Re: [mapserver-users] WMS TIME parameter slow

2010-03-11 Thread Heiko Schröter
Am Mittwoch 10 März 2010 16:52:28 schrieb Heiko Schröter: Done what has been suggested. The 'date_trunc' function forces sequential scans instead of using the indexed scans. I've tried and failed: sc_gis=# CREATE INDEX o_v20_y2007_date_trunc ON o_v20_y2007 (date_trunc('day&#

Re: [mapserver-users] WMS TIME parameter slow

2010-03-11 Thread Heiko Schröter
78.2278481012663,134.90506329114 -78.2278481012662,-134.90506329114 -78.2278481012662))',-1) and ((date_trunc('day', datum) >= '2007-12-10' AND date_trunc('day', datum) <= '2007-12-11')); Total runtime: 2329.380 ms (23 rows) >

[mapserver-users] WFS limit time interval to POSTGIS

2010-03-18 Thread Heiko Schröter
Hello, by setting up a WFS server i need to limit the time interval for the requests to the postgis db (Millions of data points inside POSTGIS). The WMS part with time interval requests is working and i'am trying to make these data available through WFS as well. What i can find in the docs is a

Re: [mapserver-users] WMS TIME parameter slow

2010-03-19 Thread Heiko Schröter
he day the SQL being generated by the > > WMS Time module is not great. Make sure to run 'ANALYZE' on your > > database so the planner has the latest stats. > > > > P. > > > > On Thu, Mar 11, 2010 at 5:59 AM, Heiko Schröter > > wrote: > >

Re: [mapserver-users] WFS limit time interval to POSTGIS

2010-03-19 Thread Heiko Schröter
> Hi there, > > There is no explicit support of a TIME parameter in wfs but I believe > It should be possible on a postgis layer to use the FilterEncoding to > limit the request: would something like this work for you: > > Filter=your_time_field2007-01-02your_time_field2007-01-03 > > > regar

[mapserver-users] Dynamically generated Raster images in mapfile

2010-04-08 Thread Heiko Schröter
Hello, i need to create Raster images on the fly and place them on a map generated with Mapserver. The time needed for generating these images is not crucial. An external script is triggered to generate these images. 1) Is it possible to define in a mapfile a "data/image source" coming from a s

Re: [mapserver-users] Dynamically generated Raster images in mapfile

2010-04-09 Thread Heiko Schröter
Am Donnerstag 08 April 2010 14:56:33 schrieb Jörg Thomsen: thanks a lot for the suggestions. I will give the WMS suggestion a first try. > But a WMS is doing what you are asking for: > > create Raster images on the fly > so perhaps you could use your script as WMS and call it with > CONNECTIONTY

Re: [mapserver-users] Dynamically generated Raster images in mapfile

2010-04-12 Thread Heiko Schröter
Am Donnerstag 08 April 2010 14:56:33 schrieb Jörg Thomsen: Any ideas why images via DATA are positioned differently to images recieved via WMS client ? Pointer to source code locations also welcome ... Heiko thanks a lot for the suggestions. I will give the WMS suggestion a first try. > B

[mapserver-users] Scaling and Postioning problems with Mapserver as WMS client (was: Dynamically generated Raster images in mapfile)

2010-04-12 Thread Heiko Schröter
Hello, images are not scaled and positioned correctly when mapserver is working as WMS client. After some grok debugging the symptom bubbled up in mapraster.c. But to my best knwoledge i think the real issue is in mapwmslayer.c where the setup of the picture limits and/or the resampling logic fo

[mapserver-users] WMS Client does not recognize "wms_extent"

2010-04-14 Thread Heiko Schröter
Hello, mapserver seems not to take "wms_extent" into account when receiving raster images via WMS. According to the docs this tag should take precedence over all others. Case 1, SRC Projection = DST Projection : a) Images are displayed correctly when read via DATA statement. msResampleGDALToMap