Re: [mapserver-users] WFS Filter Encoding and resulting DB-queries
Hello Assefa, Yewondwossen Assefa yass...@dmsolutions.ca, [20110223 - 22:52:33] On 23/02/2011 8:06 AM, Stephan Holl wrote: Hello Assefa, Yewondwossen Assefayass...@dmsolutions.ca, [20110223 - 07:26:34] Hi Stephan, On 22/02/2011 3:44 AM, Stephan Holl wrote: Hello list, while playing with MapServer WFS Filter Encoding capabilities I found some strange things when it comes to form the DB-queries (the requested layer is PostGIS-driven). It seems that there will always be a full table-scan and later on the FE will be applied. Is this done by design? Filters that do include spatial filters end up using the mapserver experssions. 'Simple' filters should end be using traslated into the layer's filter expression and end up being used by postgis as part of the data selection. What does the filter encoding looks like? It is not a spatial-filter we use currently. It is an attribute-based IsLike-Filter like seen here[1], but we use it with POST. So adding a BBOX-related filter as another AND-filter will result in optimized SQL-Query with only the subset fetched from the database? If so, this seems worth to document though. The filter you sent as example should use the layer's filter element and that should be used when retrieving the data at the postgis level. When the layer is in debug mode, MapServer 5.6.x logs in this case shows something like (which indicates that the filter is used at the postgis level) ... msPostGISLayerWhichShapes query: select and ( (NAME like 'Syd%' escape '!') ) ... Don't you get similar logs? Wait, I have to recheck with my collegue if he can provide more Information and probably logfiles. I do not have them handy right now. Thanks for your clarification though. Best Stephan -- Stephan Holl stephan.h...@intevation.de | Tel.: +49 (0)541-33 508 3663 Intevation GmbH, Neuer Graben 17, 49074 OS | AG Osnabrück - HR B 18998 Geschäftsführer: Frank Koormann, Bernhard Reiter, Dr. Jan-Oliver Wagner signature.asc Description: PGP signature ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Status of Java MapScript?
Hello Umberto, Stephan Holl stephan.h...@intevation.de, [20110223 - 14:09:04] Hello Umberto, Umberto Nicoletti umberto.nicole...@gmail.com, [20110222 - 20:22:59] Hi Stephan, I'm the mantainer of java mapscript and while I have not been working on it for quite some time, I am stil successfully using it in a couple of projects (one is a fairly complex webgis). OK, thanks for your input. It seems I have to play a little bit with it and see how I can live with that. I am pariculary intersting in saving a mapfile with the save()-method. How is the status with this? Are there any mapfile-keywords accessable (and writeable) to a mapfile using mapscript? Are there known limitations? TIA Stephan On Tue, Feb 22, 2011 at 9:51 AM, Stephan Holl stephan.h...@intevation.dewrote: Hello list, is anybody able to share the current status of Java Mapscript? Browsing the net mostly brings up PHP mapscript, C# or python mapscript status. I would love to hear some user-feedback from happy (and of course unhappy) Java mapscript-users. :-) TIA Stephan -- Stephan Holl stephan.h...@intevation.de | Tel.: +49 (0)541-33 508 3663 Intevation GmbH, Neuer Graben 17, 49074 OS | AG Osnabrück - HR B 18998 Geschäftsführer: Frank Koormann, Bernhard Reiter, Dr. Jan-Oliver Wagner ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users Viele Grüße Stephan -- Stephan Holl stephan.h...@intevation.de | Tel.: +49 (0)541-33 508 3663 Intevation GmbH, Neuer Graben 17, 49074 OS | AG Osnabrück - HR B 18998 Geschäftsführer: Frank Koormann, Bernhard Reiter, Dr. Jan-Oliver Wagner signature.asc Description: PGP signature ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Status of Java MapScript?
On Thu, Feb 24, 2011 at 10:57 AM, Stephan Holl stephan.h...@intevation.dewrote: Hello Umberto, Stephan Holl stephan.h...@intevation.de, [20110223 - 14:09:04] Hello Umberto, Umberto Nicoletti umberto.nicole...@gmail.com, [20110222 - 20:22:59] Hi Stephan, I'm the mantainer of java mapscript and while I have not been working on it for quite some time, I am stil successfully using it in a couple of projects (one is a fairly complex webgis). OK, thanks for your input. It seems I have to play a little bit with it and see how I can live with that. I am pariculary intersting in saving a mapfile with the save()-method. How is the status with this? Are there any mapfile-keywords accessable (and writeable) to a mapfile using mapscript? Are there known limitations? Sorry, can't help you, that is a specific area that I have never used. Umberto TIA Stephan On Tue, Feb 22, 2011 at 9:51 AM, Stephan Holl stephan.h...@intevation.dewrote: Hello list, is anybody able to share the current status of Java Mapscript? Browsing the net mostly brings up PHP mapscript, C# or python mapscript status. I would love to hear some user-feedback from happy (and of course unhappy) Java mapscript-users. :-) TIA Stephan -- Stephan Holl stephan.h...@intevation.de | Tel.: +49 (0)541-33 508 3663 Intevation GmbH, Neuer Graben 17, 49074 OS | AG Osnabrück - HR B 18998 Geschäftsführer: Frank Koormann, Bernhard Reiter, Dr. Jan-Oliver Wagner ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users Viele Grüße Stephan -- Stephan Holl stephan.h...@intevation.de | Tel.: +49 (0)541-33 508 3663 Intevation GmbH, Neuer Graben 17, 49074 OS | AG Osnabrück - HR B 18998 Geschäftsführer: Frank Koormann, Bernhard Reiter, Dr. Jan-Oliver Wagner ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Status of Java MapScript?
Stephan, I consider the save option is working equally well for all bindings. The bulk of the code is implemented in the common mapserver code (mapfile.c) which is not language specific. Best regards, Tamas 2011/2/24 Stephan Holl stephan.h...@intevation.de Hello Umberto, Stephan Holl stephan.h...@intevation.de, [20110223 - 14:09:04] Hello Umberto, Umberto Nicoletti umberto.nicole...@gmail.com, [20110222 - 20:22:59] Hi Stephan, I'm the mantainer of java mapscript and while I have not been working on it for quite some time, I am stil successfully using it in a couple of projects (one is a fairly complex webgis). OK, thanks for your input. It seems I have to play a little bit with it and see how I can live with that. I am pariculary intersting in saving a mapfile with the save()-method. How is the status with this? Are there any mapfile-keywords accessable (and writeable) to a mapfile using mapscript? Are there known limitations? TIA Stephan On Tue, Feb 22, 2011 at 9:51 AM, Stephan Holl stephan.h...@intevation.dewrote: Hello list, is anybody able to share the current status of Java Mapscript? Browsing the net mostly brings up PHP mapscript, C# or python mapscript status. I would love to hear some user-feedback from happy (and of course unhappy) Java mapscript-users. :-) TIA Stephan -- Stephan Holl stephan.h...@intevation.de | Tel.: +49 (0)541-33 508 3663 Intevation GmbH, Neuer Graben 17, 49074 OS | AG Osnabrück - HR B 18998 Geschäftsführer: Frank Koormann, Bernhard Reiter, Dr. Jan-Oliver Wagner ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users Viele Grüße Stephan -- Stephan Holl stephan.h...@intevation.de | Tel.: +49 (0)541-33 508 3663 Intevation GmbH, Neuer Graben 17, 49074 OS | AG Osnabrück - HR B 18998 Geschäftsführer: Frank Koormann, Bernhard Reiter, Dr. Jan-Oliver Wagner ___ 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] Spherical Mercator Projection Problem
Sergey, If your data is in epsg:4326 and you want to publish the data as epsg:3785, you will need to projection blocks to your layers. Something like: PROJECTION init=epsg:4326 END The Projection block in the MAP section defines your output projection. Because your data is not in the same projection, you will need to define a projection block in each layer section. Those projection blocks define the 'input' projection. They tell MapServer what projection the data exists in. This allows MapServer (with proj4 support) to re-project your data to the output projection. David. From: mapserver-users-boun...@lists.osgeo.org [mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Sergey Kraev Sent: Wednesday, February 23, 2011 5:01 AM To: mapserver-users@lists.osgeo.org Subject: [mapserver-users] Spherical Mercator Projection Problem Hi, I'm running MS4W v3.0 (including MapServer 5.6.5) on Windows. My data source are PostGIS multipolygon countries' borders. I have successfully got MapServer to render the world map in WGS84 projection using these settings: Request: http://127.0.0.1:8080/cgi-bin/mapserv.exe?map=world.mapmode=mapmapsize=256+256mapext=-180+-90+180+90 world.map: MAP EXTENT -180 -90 180 90 #EXTENT -20037508 -20037508 20037508 20037508 SIZE 256 256 IMAGECOLOR 153 179 204 FONTSETc:\MS4W\fonts\fonts.list RESOLUTION96 MAXSIZE5000 PROJECTION init=epsg:4326 #init=epsg:3785 END ... layers don't have PROJECTION sections I would like MapServer to render the same data into a Web (spherical) Mercator projected map (epsg:3785), but I don't know how to modify my request and mapfile in order to get the correct map. With the following settings I just receive a picture without any polygons. \ms4w\proj\nad\epsg: ... 3785 +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 +no_defs ... Request (only mapext is different): http://127.0.0.1:8080/cgi-bin/mapserv.exe?map=world.mapmode=mapmapsize=256+256mapext=-20037508+-20037508+20037508+20037508http://127.0.0.1:8080/cgi-bin/mapserv.exe?map=world.mapmode=mapmapsize=256+256mapext=-180+-90+180+90 world.map (only EXTENT and PROJECTION are different): MAP #EXTENT-180 -90 180 90 EXTENT -20037508 -20037508 20037508 20037508 SIZE 256 256 IMAGECOLOR 153 179 204 FONTSETc:\MS4W\fonts\fonts.list RESOLUTION96 MAXSIZE5000 PROJECTION #init=epsg:4326 init=epsg:3785 END ... layers don't have PROJECTION sections I'm assuming that -20037508 -20037508 20037508 20037508 is correct extent for the whole world map, since Google uses that and they also have Mercator projection. Thanks for your help. Sergey ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
RE: [mapserver-users] TEMPLATE generation completion (NOT!)
All, More info: Is there possibly a limit to how large a point list can be in POLYGON imagemap, either in MapServer output, or as a standard for imagemaps? This dataset that I'm working with has some really intricate polygons with lot's of vertices. I just zoomed in on a couple of areas very tight, only displaying three features. and even at this scale, the number of vertices is huge for two of the polygons. I only see maybe 10-15 vertices on screen, but there are many other offscreen as well. As far as I understand how the imagemaping process works (and is bared out by the output I'm seeing), is that the imagemap grabs the vertices of the polygons, even those off screen and displays the feature in it's entirety even though it's not displayed completely inside of the current query BBOX. Is there a way to clip the imagemap output to the current BBOX request size, this would essentially truncate the polygons at the edges of the view, which would reduce the number of overall vertices dramatically. Thanks bobb --- All, Ok, this problem has returned, and on the same layer. I've traced everything around even through our weird file repository, I've made sure everything is synced on the backend file servers and the files are all replicated as they should be, with the proper permissions. I cannot get this particular layer to output the closing tag in the imagemap. any other ideas on what to check? bobb -- Steve, Ok, I have no idea what happened, but fixing the name of the footer file (back to what it was) fixed the call, it now pops out with the FOOTER content. Must have been some weird permission error, but wouldn't that throw an error just like breaking the name? Looks like it fixed itself as a result of editing the name . . . . Thanks, I think, (I'm going to leave it alone for a while while it's working . . . . ;c) I still wonder what went on there though. I should mention too that this is updating via WEBDAV, I always forget this part because I use it day in and day out and it's always there as a folder. Also, all the configuration files reside inside of SVN. Anyway, those are the funky configuration elements I was talking about earlier. Thanks again, though really, this one was driving me over the edge . . . . bobb ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
RE: [mapserver-users] TEMPLATE generation completion (NOT!)
All, Still more info . . . I think I may have found the problem. Some of these polygons have holes in them. I know I've seen threads before about polygons with holes in them and such. Could this be where the problems are originating? Thanks bobb --- All, More info: Is there possibly a limit to how large a point list can be in POLYGON imagemap, either in MapServer output, or as a standard for imagemaps? This dataset that I'm working with has some really intricate polygons with lot's of vertices. I just zoomed in on a couple of areas very tight, only displaying three features. and even at this scale, the number of vertices is huge for two of the polygons. I only see maybe 10-15 vertices on screen, but there are many other offscreen as well. As far as I understand how the imagemaping process works (and is bared out by the output I'm seeing), is that the imagemap grabs the vertices of the polygons, even those off screen and displays the feature in it's entirety even though it's not displayed completely inside of the current query BBOX. Is there a way to clip the imagemap output to the current BBOX request size, this would essentially truncate the polygons at the edges of the view, which would reduce the number of overall vertices dramatically. Thanks bobb --- All, Ok, this problem has returned, and on the same layer. I've traced everything around even through our weird file repository, I've made sure everything is synced on the backend file servers and the files are all replicated as they should be, with the proper permissions. I cannot get this particular layer to output the closing tag in the imagemap. any other ideas on what to check? bobb -- Steve, Ok, I have no idea what happened, but fixing the name of the footer file (back to what it was) fixed the call, it now pops out with the FOOTER content. Must have been some weird permission error, but wouldn't that throw an error just like breaking the name? Looks like it fixed itself as a result of editing the name . . . . Thanks, I think, (I'm going to leave it alone for a while while it's working . . . . ;c) I still wonder what went on there though. I should mention too that this is updating via WEBDAV, I always forget this part because I use it day in and day out and it's always there as a folder. Also, all the configuration files reside inside of SVN. Anyway, those are the funky configuration elements I was talking about earlier. Thanks again, though really, this one was driving me over the edge . . . . bobb ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Spherical Mercator Projection Problem
Hi, Indeed. Also note that EPSG:900913 is the same as EPSG:3785 and EPSG:3857. These three are the Spherical Mercator projection, which is the right one to use for overlays on Google Maps. Jean-François Gigand 2011/2/24 Fawcett, David (MPCA) david.fawc...@state.mn.us: Sergey, If your data is in epsg:4326 and you want to publish the data as epsg:3785, you will need to projection blocks to your layers. Something like: PROJECTION init=epsg:4326 END The Projection block in the MAP section defines your output projection. Because your data is not in the same projection, you will need to define a projection block in each layer section. Those projection blocks define the ‘input’ projection. They tell MapServer what projection the data exists in. This allows MapServer (with proj4 support) to re-project your data to the output projection. David. From: mapserver-users-boun...@lists.osgeo.org [mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Sergey Kraev Sent: Wednesday, February 23, 2011 5:01 AM To: mapserver-users@lists.osgeo.org Subject: [mapserver-users] Spherical Mercator Projection Problem Hi, I’m running MS4W v3.0 (including MapServer 5.6.5) on Windows. My data source are PostGIS multipolygon countries’ borders. I have successfully got MapServer to render the world map in WGS84 projection using these settings: Request: http://127.0.0.1:8080/cgi-bin/mapserv.exe?map=world.mapmode=mapmapsize=256+256mapext=-180+-90+180+90 world.map: MAP EXTENT -180 -90 180 90 #EXTENT -20037508 -20037508 20037508 20037508 SIZE 256 256 IMAGECOLOR 153 179 204 FONTSET c:\MS4W\fonts\fonts.list RESOLUTION 96 MAXSIZE 5000 PROJECTION init=epsg:4326 #init=epsg:3785 END … layers don’t have PROJECTION sections I would like MapServer to render the same data into a “Web (spherical) Mercator” projected map (epsg:3785), but I don't know how to modify my request and mapfile in order to get the correct map. With the following settings I just receive a picture without any polygons. \ms4w\proj\nad\epsg: … 3785 +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 +no_defs … Request (only mapext is different): http://127.0.0.1:8080/cgi-bin/mapserv.exe?map=world.mapmode=mapmapsize=256+256mapext=-20037508+-20037508+20037508+20037508 world.map (only EXTENT and PROJECTION are different): MAP #EXTENT -180 -90 180 90 EXTENT -20037508 -20037508 20037508 20037508 SIZE 256 256 IMAGECOLOR 153 179 204 FONTSET c:\MS4W\fonts\fonts.list RESOLUTION 96 MAXSIZE 5000 PROJECTION #init=epsg:4326 init=epsg:3785 END … layers don’t have PROJECTION sections I’m assuming that -20037508 -20037508 20037508 20037508 is correct extent for the whole world map, since Google uses that and they also have Mercator projection. Thanks for your help. Sergey ___ 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] Font sizing question
I'm migrating a layer from an older mapserver(v4.8.1) to my v4.10 installation. The layer uses an ESRI font set for wind barbs. On the older installation, the symbols are much darker. I've tried tweaking a couple of settings in the new mapfile but nothing really seems to make a difference. The color config is 0 0 0, however on the map they look grey. I tried applying an OUTLINECOLOR of 0 0 0, however that was too extreme making the barb almost block like. Here is a snippet of a CLASS: CLASS EXPRESSION ((([m_value] * 2.2369362921) = 5) AND (([m_value] * 2.2369362921) 10)) TEXT 'ã' LABEL ANGLE [d_label_theta] FORCE TRUE TYPE TRUETYPE FONT 'weather' ANTIALIAS TRUE COLOR 0 0 0 #OUTLINECOLOR 0 0 0 POSITION CC OFFSET 2 -6 BUFFER 0 PARTIALS TRUE SIZE 25 END STYLE END END I appreciate any help/hints Dan -- View this message in context: http://osgeo-org.1803224.n2.nabble.com/Font-sizing-question-tp6061930p6061930.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] Sponsorship for OSGeo Montreal Code Sprint 2011
Dear MapServer users, OSGeo's Montreal Code Sprint 2011 is going to take place on March 14-18, 2011. A group of over 20 OSGeo project developers and contributors will meet in Montreal for 4 days of work on their respective projects... for the advancement of the software that you use everyday. So far, 22 devs/contributors have signed up to participate, including 12 who plan to work on MapServer. If your organization uses MapServer then you might want to let your boss know (or take note if you're the boss) that we are looking for sponsors ($750 each) to support food and fun for the sprinters as they work hard and play hard for four productive days. Each $750 sponsorship will be put towards lunch and dinner costs for the sprinters, and potentially bringing in sprinters who might otherwise be unable to attend. Ideally we'd need another 2 or 3 sponsors to meet our current budget objectives, and if we have a surplus then it will either be returned to OSGeo, or used for a future code sprint. All the details about the sprint, including our current budget are available in the wiki at http://wiki.osgeo.org/wiki/Montreal_Code_Sprint_2011 If you are interested in sponsoring then please contact me directly off-list. Finally, I'd like to thank our first round of sponsors: - LizardTech - http://www.lizardtech.com/ - Azavea - http://www.azavea.com/ - qPublic - http://qpublic.net/ - Farallon Geographics - http://fargeo.com/ And also big thanks to the Communauté Métropolitaine de Montréal (CMM) for hosting us in their wonderful conference room. I hope to be able to announce a few more sponsors in the next couple of days. :-) Daniel P.S. There is also still a bit of room for more sprinters. The only requirement is that you be knowledgeable and willing to get your hands dirty doing some work for one of the projects that is represented. If you are interested in participating then to help us with planning please list your name in the wiki, join the tosprint list to receive the latest updates, and book your hotel ASAP since our room block is about to expire. All that info is in the wiki. -- Daniel Morissette http://www.mapgears.com/ ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] Trouble with WFS GetFeature: get same feature returned multiple times
Hi, I didn't had problems with UMN Mapserver for a very long time. I really love the product, and now I really need help. I set up a WFS Server, accessing a PostGIS point table. I use OpenLayers to visualise the WFS layer, and use the cluster strategy to group close points to a large cluster point. Now to the problem: I want to retrieve the feature data from a cluster point. I already have the IDs of the features of the cluster. Now I send a GetFeature request to the Mapserver to get all attribute information for the features, i.e. ID=231 and ID=273: http://[...]/cgi-bin/stations?request=getfeatureservice=WFSversion=1.0.0typename=DTISOUTPUTFORMAT=gml3featureid=DTIS.231,DTIS.273 The response of this request contains the feature 231 twice in the response. If I add another ID to the request, I get the feature 231 three times returned: [...] gml:featureMember ms:DTIS gml:id=DTIS.231 gml:boundedBy[...]/gml:boundedBy ms:msGeometry gml:Point srsName=EPSG:4326 gml:pos174.081500 -34.949500/gml:pos /gml:Point /ms:msGeometry ms:id231/ms:id /ms:DTIS /gml:featureMember gml:featureMember ms:DTIS gml:id=DTIS.231 [...] /gml:featureMember /ms:msFeatureCollection As soon as I export the table from PostgreSQL into a shapefile, update the mapfile to use the shapefile and run the same query, I get the correct response. I also tracked the SQL query, which is sent to Postgres, and the query is correct. PostgreSQL returns the correct rows. I use MapServer V5.4.1, which is not a very newer version, but I am constraint by the Debian packages. Is this an user error (I am not smart enough)? Or a bug? If so, has this bug been resolved in a later version? Any help is really appreciated. Thanks, Rainer Rainer Spittel | Head of Development SilverStripe http://silverstripe.com Phone: +64 4 978 7330 Mobile: +64 21 1390370 Skype: fb3rasp ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users