Re: [mapserver-users] 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 jci...@ulb.ac.be *To:* mapserver-users@lists.osgeo.org mapserver-users@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 a .map file .. ? Thanks, 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 mailto: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. attachment: jcigar.vcf___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] 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@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] 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 -2370 and -3370. 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@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] mapcache
On Thu, Jan 26, 2012 at 19:30, John Callahan john.calla...@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? layerslayer1,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 formatfoobar/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@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] 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=@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.gr...@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 -2370 and -3370. 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@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@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
RE: [mapserver-users] disappearing point features in North America
Hi Jerl Eurueka! +over did it! Thanks, I owe you one. Chris From: jerl.simp...@craniumjuice.com [mailto:jerl.simp...@craniumjuice.com] On Behalf Of forums Sent: 01 February 2012 13:17 To: Chris Green Cc: mapserver-users@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=@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.gr...@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 -2370 and -3370. 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@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@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] 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=wfsrequest=getCapabilitiesversion=1.1.0typename=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=wfsrequest=DescribeFeatureTypeversion=1.1.0typename=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:ExceptionTextXML 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:ExceptionTextXML 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=wfsamp;request=DescribeFeatureTypeamp;version=1.1.0amp;typename=tows:lrtstops;
xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance;
resultType=resultswfs: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:BBOXogc:PropertyNamethe_geom/ogc:PropertyNamegml:Envelope
xmlns:gml=http://www.opengis.net/gml;
srsName=EPSG:2227gml:lowerCorner6040731.6
1878643/gml:lowerCornergml:upperCorner6249288.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
[mapserver-users] 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@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
AW: [mapserver-users] 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: http://gis.ibbeck.de/ginfo/apps/OLExamples/OL210/MapServer_SLD_World/MapServ er_SLD_World.asp?mapservLayers=0 http://gis.ibbeck.de/ginfo/apps/OLExamples/OL210/MapServer_SLD_World/MapSer ver_SLD_World.asp?mapservLayers=0SLDsrcIdx=42 SLDsrcIdx=42 Arnd _ Von: mapserver-users-boun...@lists.osgeo.org [mailto:mapserver-users-boun...@lists.osgeo.org] Im Auftrag von Paul Edwards Gesendet: Dienstag, 31. Januar 2012 20:37 An: mapserver-users@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: http://mapserver.org/ogc/sld.html#named-styles-support 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? http://docs.geoserver.org/stable/en/user/styling/sld-extensions/pointsymbols .html#the-shape-symbols Thanks! Paul ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] 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, warmer...@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@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] Is it possible to combine between openlayers script and mapfile?
Very thanks for your fast answer, Mr. Brent Fraser. I want to create a points using openlayers to describes realtime GPS tracking. But i want to insert the openlayers script into web tempate of the mapfile, can i do that? If it were possible, what the effect when I zoom the map? Thanks for attention your kindness Best regards Gozali From: Brent Fraser bfra...@geoanalytic.com To: Vivaldi Al Barado vivaldi_albar...@yahoo.com Cc: mapserver-users@lists.osgeo.org mapserver-users@lists.osgeo.org Sent: Tuesday, January 31, 2012 11:34 PM Subject: Re: [mapserver-users] Want to create a dynamic GPS Tracking using MapServer Gozali, Due to the dynamic nature of the data, a spatial relational database such as PostGIS would be a good choice for the data storage. The tables would depend on which features are important to you (positions, tracks, etc). Populating the tables from GPS data would likely require some custom coding. There were a couple of sessions at FOSS4G 2007: http://www.foss4g2007.org/presentations/view.php?abstract_id=83 http://www.foss4g2007.org/presentations/view.php?abstract_id=253 Best Regards, Brent Fraser On 1/31/2012 1:37 AM, Vivaldi Al Barado wrote: Hi friends. I plan to create a map that can display the GPS tracking dynamically. For the best choice, what is needed to make GPS tracking dynamically using MapServer? Please guide. Thank you so much for your explanations and your kindness. Best Regards Gozali ___ 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
