Julien Cigar | 1 Feb 09:59
Picon
Picon
Favicon
Gravatar

Re: PostGIS query

On 01/31/2012 17:05, Carlos Ruiz wrote:
> Julien,

Hi Carlos,

>
> Have you tried with views ? When I need to map complex queries I build a
> view to just handle the where clauses.
>

I usually use a view, but in this case there are a lot of tables 
involved and I would like to avoid dozens of unnecessary JOIN

> Cheers from México
> IC Carlos Ruiz
>
> ------------------------------------------------------------------------
> *From:* Julien Cigar <jcigar <at> ulb.ac.be>
> *To:* "mapserver-users <at> lists.osgeo.org" <mapserver-users <at> lists.osgeo.org>
> *Sent:* Tuesday, January 31, 2012 6:38 AM
> *Subject:* [mapserver-users] PostGIS query
>
> Hello,
>
> Is there a way to (deeply) modify the SQL query in a PostGIS layer?
> I would like to add some JOIN, additional WHERE clauses, etc
> As I'm afraid that "Run-time Substitution" isn't flexible enough for
> this case ... is there any other possibility, other than mapscript?
>
> I guess there is no possibility to define variables, conditions, etc in
(Continue reading)

Nico Alberti | 1 Feb 10:18
Picon

Re: Troubles masking wmf service via mod_rewrite

Il 31/01/2012 16:46, Michael Shishcu ha scritto:
> Oh, Nico, there's a flag you can use for that, [QSA]:

That was easy, once somebody told me how to fix it :-) Thank you so much!

--

-- 
Ciao
Nico

_______________________________________________
mapserver-users mailing list
mapserver-users <at> lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Chris Green | 1 Feb 12:38
Picon

disappearing point features in North America

I have a problem that may be down to OpenLayers or to Mapserver, or (just as likely) to me. Basically I am using OL to request WMS maps from Mapserver, and the map consists of point features with a global spread, typically around 100 points in each map. The points are defined in a table which has lat/lon in decimal degrees, and these are converted to 900913 by Mapserver where my mapfile has an overall projection of epsg: 900913 but the points layer has projection epsg: 4326.

 

The map is defined in OL with extents: -20037508.34, -20037508.34, 20037508.34, 20037508.34 and the mapfile has the same extents applied.

This all works fine when a map is first displayed, all of the points are present on the map. However when I scroll the map left or right there is a ‘dead spot’ where  all the points in North America disappear and then re-appear, either side of the dead spot. Looking with Firebug at the bounding box that OL uses to request the map from Mapserver I can see that the points disappear when the bounding box is between left bounds of about -23700000 and -33700000. Only the points in North America are affected, never those in Europe or Asia.

 

I have been wrestling with this for quite a while, experimenting with extents etc, all without any effect.  Does anyone recognise where my problem may lie, or else have any suggestions how to diagnose what is going on?

 

 

Chris  

 

 

 

 

_______________________________________________
mapserver-users mailing list
mapserver-users <at> lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
thomas bonfort | 1 Feb 12:56
Picon
Gravatar

Re: mapcache

On Thu, Jan 26, 2012 at 19:30, John Callahan <john.callahan <at> udel.edu> wrote:
> I'm giving mapcache a try but with no luck.  Well, some luck.  The module
> loads fine and the demo (vmap0, http://127.0.0.1/mapcache/demo/wms) also
> works fine.  I see the tiles being generated on disk.  Great.  However, the
> problem comes in with my own data/services.  A few questions may help me
> determine the problem.
>
> - in the source element, how do you define multiple layers?  Comma separated
> or separate <layers> entries?

<layers>layer1,layer2</layers>

>
> - in the tileset element, can you have multiple grid entries?  It doesn't
> seem like it from reading the documentation but the sample tileset shows
> both the "g" and "WGS84" grids.
which doc part does not show this?
http://www.mapserver.org/trunk/mapcache/config.html#tileset

>
> - for cache type attributes, what are the possible values?  The docs show
> several possibilities (disk, sqllite, memcache) but the sample shows
> type="tiff" which is not listed on the doc page.  Can other file extensions
> be used here?
http://www.mapserver.org/trunk/mapcache/caches.html

>
> - when I define a FORMAT with name and type, how does that get used?  I see
> that is called in the tileset but how does that relate to the image type
> under getmap/params/format?

The format is used when recompressing individual tiles after having
cut a larger metatile. It is also used when combining multiple tiles
into a single image for a getmap request. If you want to force a
specific format to be sent to the source wms server when creating a
tile, you can add a <format>foobar</format> to your source definition
(at the same level as the <layers> parameter). Both formats don't have
to be equivalent, it is actually a good idea to request the images in
png from the source wms server even when using a jpeg format for the
the tileset, as this will avoid a double jpeg compression (once on the
wms server, once on the mapcache server) when storing an individual
tile to the caches.

regards,
thomas

>
>
> The doc page I am referring to is
> at http://www.mapserver.org/trunk/mapcache/config.html.  I'm sure I'll have
> other questions as I work my way through.  Thanks for this awesome addition
> to Mapserver!
>
> - John
>
> ***********************************************
> John Callahan, Research Scientist
> Delaware Geological Survey, University of Delaware
> URL: http://www.dgs.udel.edu
> *************************************************
>
>
> _______________________________________________
> mapserver-users mailing list
> mapserver-users <at> lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>
_______________________________________________
mapserver-users mailing list
mapserver-users <at> lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

forums | 1 Feb 14:16

Re: disappearing point features in North America

Chris:


I had a similar issue, it was suggested to me to add "+over" to my epsg definitions file.

Mine now looks like:
<4326> +proj=longlat +ellps=WGS84 +datum=WGS84 +over +no_defs  <>
<900913> +proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids= <at> null +wktext +over +no_defs <>

That seemed to make a difference, but I also upgraded PROJ4 at the same time.

Jerl

On Wed, Feb 1, 2012 at 5:38 AM, Chris Green <chris.green <at> ibstv.co.uk> wrote:

I have a problem that may be down to OpenLayers or to Mapserver, or (just as likely) to me. Basically I am using OL to request WMS maps from Mapserver, and the map consists of point features with a global spread, typically around 100 points in each map. The points are defined in a table which has lat/lon in decimal degrees, and these are converted to 900913 by Mapserver where my mapfile has an overall projection of epsg: 900913 but the points layer has projection epsg: 4326.

 

The map is defined in OL with extents: -20037508.34, -20037508.34, 20037508.34, 20037508.34 and the mapfile has the same extents applied.

This all works fine when a map is first displayed, all of the points are present on the map. However when I scroll the map left or right there is a ‘dead spot’ where  all the points in North America disappear and then re-appear, either side of the dead spot. Looking with Firebug at the bounding box that OL uses to request the map from Mapserver I can see that the points disappear when the bounding box is between left bounds of about -23700000 and -33700000. Only the points in North America are affected, never those in Europe or Asia.

 

I have been wrestling with this for quite a while, experimenting with extents etc, all without any effect.  Does anyone recognise where my problem may lie, or else have any suggestions how to diagnose what is going on?

 

 

Chris  

 

 

 

 


_______________________________________________
mapserver-users mailing list
mapserver-users <at> lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users




--
A computer without Windows is like chocolate cake without mustard.
_______________________________________________
mapserver-users mailing list
mapserver-users <at> lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
Chris Green | 1 Feb 14:33
Picon

RE: disappearing point features in North America

Hi Jerl

 

Eurueka! “+over” did it!

 

 

Thanks, I owe you one.

 

 

Chris

 

From: jerl.simpson <at> craniumjuice.com [mailto:jerl.simpson <at> craniumjuice.com] On Behalf Of forums
Sent: 01 February 2012 13:17
To: Chris Green
Cc: mapserver-users <at> lists.osgeo.org
Subject: Re: [mapserver-users] disappearing point features in North America

 

Chris:

 

I had a similar issue, it was suggested to me to add "+over" to my epsg definitions file.

 

Mine now looks like:

<4326> +proj=longlat +ellps=WGS84 +datum=WGS84 +over +no_defs  <>

<900913> +proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids= <at> null +wktext +over +no_defs <>

That seemed to make a difference, but I also upgraded PROJ4 at the same time.


Jerl

On Wed, Feb 1, 2012 at 5:38 AM, Chris Green <chris.green <at> ibstv.co.uk> wrote:

I have a problem that may be down to OpenLayers or to Mapserver, or (just as likely) to me. Basically I am using OL to request WMS maps from Mapserver, and the map consists of point features with a global spread, typically around 100 points in each map. The points are defined in a table which has lat/lon in decimal degrees, and these are converted to 900913 by Mapserver where my mapfile has an overall projection of epsg: 900913 but the points layer has projection epsg: 4326.

 

The map is defined in OL with extents: -20037508.34, -20037508.34, 20037508.34, 20037508.34 and the mapfile has the same extents applied.

This all works fine when a map is first displayed, all of the points are present on the map. However when I scroll the map left or right there is a ‘dead spot’ where  all the points in North America disappear and then re-appear, either side of the dead spot. Looking with Firebug at the bounding box that OL uses to request the map from Mapserver I can see that the points disappear when the bounding box is between left bounds of about -23700000 and -33700000. Only the points in North America are affected, never those in Europe or Asia.

 

I have been wrestling with this for quite a while, experimenting with extents etc, all without any effect.  Does anyone recognise where my problem may lie, or else have any suggestions how to diagnose what is going on?

 

 

Chris  

 

 

 

 


_______________________________________________
mapserver-users mailing list
mapserver-users <at> lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users



 

--
A computer without Windows is like chocolate cake without mustard.

_______________________________________________
mapserver-users mailing list
mapserver-users <at> lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
Wang, Ya | 1 Feb 19:33
Favicon

Can't get Tinyows WFS Layer to show in OpenLayer

Dear All,

 

I am a newbie of mapserver and other online mapping technologies. Recently, I have been struggling to load a TinyOWS WFS Layer to an OpenLayers map.  I set up proxy.cgi, which works fine. I checked TinyOWS using command “tinyows –check”, which also seems to be working. The page http://.../cgi-bin/tinyows.exe?service=wfs&request=getCapabilities&version=1.1.0&typename=tows:lrtstops doesn’t return any error either.  I can also load a mapserver WMS layer into the OpenLayers Map with no problem. However, no feature from the WFS layer would show in the OpenLayers map.  Since both the WMS and WFS layers are of the same projection, which is EPSG:2227, I assume that the misspecification of projection is not likely to be the caprice here.   The following is the JavaScript I used and the response returned. Could someone help me find out what I did wrong? Many thanks in advance!

 

OpenLayers.ProxyHost = "/fcgi-bin/proxy.cgi?url=";

function init() {

     map = new OpenLayers.Map('map', {

        projection: new OpenLayers.Projection("EPSG:2227"),

        units: "feet",

        maxResolution: "auto",

        maxExtent: new OpenLayers.Bounds(6103631,1911230,6186389,1976404),

        controls: [

            new OpenLayers.Control.PanZoom()

        ]

    });

    var wms= new OpenLayers.Layer.WMS(

        "parcel",

               "http://.../cgi-bin/mapserv.fcgi?MAP=.../Parcel.map",

        {layers: 'Parcel', format: 'image/jpeg'}

               );

 

    var wfs = new OpenLayers.Layer.Vector("Editable Features", {

        strategies: [new OpenLayers.Strategy.BBOX(), saveStrategy],

        projection: new OpenLayers.Projection("EPSG:2227"),

        protocol: new OpenLayers.Protocol.WFS({

            version: "1.1.0",

            srsName: "urn:ogc:def:crs:EPSG::2227",

            url: "http://.../cgi-bin/tinyows.fcgi",

            featureNS :  "http://roappdev1:8080/",

            featureType: "lrtstops",

            geometryName: "the_geom",

            outputFormat: "text/xml; subtype=gml/3.1.1",

           schema: "http://.../cgi-bin/tinyows.fcgi?service=wfs&request=DescribeFeatureType&version=1.1.0&typename=tows:lrtstops"

        })

    });

 

    map.addLayers([wms, wfs]);

---------------------------------------------------------------------------

<ows:ExceptionReport xmlns="http://www.opengis.net/ows" xmlns:ows="http://www.opengis.net/ows" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.opengis.net/ows http://schemas.opengis.net/ows/1.0.0/owsExceptionReport.xsd" version="1.1.0" language="en">

<ows:Exception exceptionCode="InvalidParameterValue" locator="request">

<ows:ExceptionText>XML request isn't valid</ows:ExceptionText>

</ows:Exception>

</ows:ExceptionReport>

 

 

<?xml version='1.0' encoding='UTF-8'?>

<ows:ExceptionReport

xmlns='http://www.opengis.net/ows'

xmlns:ows='http://www.opengis.net/ows'

xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance'

xsi:schemaLocation='http://www.opengis.net/ows http://schemas.opengis.net/ows/1.0.0/owsExceptionReport.xsd'

version='1.1.0' language='en'>

<ows:Exception exceptionCode='InvalidParameterValue' locator='request'>

  <ows:ExceptionText>XML request isn't valid</ows:ExceptionText>

</ows:Exception>

</ows:ExceptionReport>

 

<wfs:GetFeature xmlns:wfs="http://www.opengis.net/wfs" service="WFS" version="1.1.0" outputFormat="text/xml; subtype=gml/3.1.1" xsi:schemaLocation="http://www.opengis.net/wfs http://schemas.opengis.net/wfs/1.1.0/wfs.xsd http://myserver/ http://myserver/cgi-bin/tinyows.fcgi?service=wfs&amp;request=DescribeFeatureType&amp;version=1.1.0&amp;typename=tows:lrtstops" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" resultType="results"><wfs:Query typeName="feature:lrtstops" srsName="urn:ogc:def:crs:EPSG::2227" xmlns:feature="http://myserver/"><ogc:Filter xmlns:ogc="http://www.opengis.net/ogc"><ogc:BBOX><ogc:PropertyName>the_geom</ogc:PropertyName><gml:Envelope xmlns:gml="http://www.opengis.net/gml" srsName="EPSG:2227"><gml:lowerCorner>6040731.6 1878643</gml:lowerCorner><gml:upperCorner>6249288.4 2008991</gml:upperCorner></gml:Envelope></ogc:BBOX></ogc:Filter></wfs:Query></wfs:GetFeature>

 

Response Headers

Connection

Keep-Alive

Content-Type

application/xml

Date

Wed, 01 Feb 2012 18:04:29 GMT

Keep-Alive

timeout=5, max=66

Proxy-Connection

Keep-Alive

Server

Apache/2.2.16 (Win32) PHP/5.3.3 mod_fcgid/2.3.6

Transfer-Encoding

chunked

Via

....

Request Headers

Accept

text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8

Accept-Charset

ISO-8859-1,utf-8;q=0.7,*;q=0.7

Accept-Encoding

gzip, deflate

Accept-Language

en-us,en;q=0.5

Content-Length

917

Content-Type

application/xml; charset=UTF-8

Cookie

SESSd43c6da11a8841c94fab47ef368714de=576ee6deef9974c049b58c8494e0b122; __utma=116482309.238053724.1327699956.1327699956.1327709334.2; __utmz=116482309.1327699956.1.1.utmcsr=(direct)|utmccn=(direct)|utmcmd=(none)

Host

myhost

Proxy-Connection

keep-alive

Referer

http://myserver/.../tinyows_test.html

User-Agent

Mozilla/5.0 (Windows NT 5.1; rv:5.0) Gecko/20100101 Firefox/5.0

 

 

 

By the way, I am using libxml 2.7.3 and openlayers 2.11.  The following XML information is returned from phpinfo().

xml

XML Support

active

XML Namespace Support

active

libxml2 Version

2.7.3

 

Regards,

 

Ya

_______________________________________________
mapserver-users mailing list
mapserver-users <at> lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
Ian Walberg | 1 Feb 22:03

Mapserver memory leaks

Folks,

We have a mapscript (6.x) application which runs as a process so the php
script does not exit.

What we appear to be seeing (using valgrind) is a surprisingly large
number of memory leaks.

Our next step is to look into each one and try and determine the cause
but they appear to be in multiple places.

Does anyone have any experience of similar conditions?

Many thanks

Ian
_______________________________________________
mapserver-users mailing list
mapserver-users <at> lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Arnd Wippermann | 1 Feb 22:18
Picon

AW: Style a polygon with Horizontal, Vertical, or Diagonal Lines using SLD?

you can define a symbol for the hatch in your mapfile
 
  SYMBOL
    NAME "schraffur"
    TYPE HATCH
  END
and use this in your sld
 
An example how it works:
 
Arnd
Von: mapserver-users-bounces <at> lists.osgeo.org [mailto:mapserver-users-bounces <at> lists.osgeo.org] Im Auftrag von Paul Edwards
Gesendet: Dienstag, 31. Januar 2012 20:37
An: mapserver-users <at> lists.osgeo.org
Betreff: [mapserver-users] Style a polygon with Horizontal, Vertical,or Diagonal Lines using SLD?

Hi All!

I'm wondering if anyone has experience styling maps with horizontal, vertical, or diagonal lines when using MapServer WMS and a custom provided SLD? The documentation states:


"A Fill can be a solid fill or be a Graphic Fill, which is either a well-known Mark symbol (e.g., square, circle, triangle, star, cross, x) or an ExternalGraphic element (e.g., gif, png) available through a URL"


This pretty clearly states that the way to accomplish my goal is by tiling an externally referenced image that has the line oriented the way I want, but then we lose the coloring options. GeoServer has some cool SLD extensions that are outside the spec (see link below) and I was wondering if MapServer had anything similar?


Thanks!
Paul

_______________________________________________
mapserver-users mailing list
mapserver-users <at> lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
Frank Warmerdam | 2 Feb 02:22
Picon
Favicon
Gravatar

Web site downtime

Folks,

The OSGeo ProjectsVM is down while we upgrade the OS (an upgrade
that has encountered some issues).  While this is being resolved the
hosted sites including gdal.org, mapserver.org, grass.org will be down.

  http://wiki.osgeo.org/wiki/ProjectsVM

Downtime could potentially be in the hours or even a day or two.  I won't
announce when things are back but you can always try.  Note that Trac
for bug reporting, and subversion are not down.

Sorry for the inconvenience.  And damn Debian major OS version
in-place upgrades. :-)

Best regards,
--

-- 
---------------------------------------+--------------------------------------
I set the clouds in motion - turn up   | Frank Warmerdam, warmerdam <at> pobox.com
light and sound - activate the windows | http://pobox.com/~warmerdam
and watch the world go round - Rush    | Geospatial Software Developer
_______________________________________________
mapserver-users mailing list
mapserver-users <at> lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users


Gmane