[mapserver-users] postgres fulltext search
We have set up a WFS service connected with postgres loaded up with some
substantial datasets of ~120 million rows. We have run into users wanting to
utilize the filter "PropertyIsLike". The search string and a wildcard
character are specified, and mapserver does a search against postgres,
something like:
WHERE myColumn LIKE "SearchString%"
if the search string was SearchString* and the wildcard set to *. There is
an index on myColumn. The users then tried putting the wildcard at the
beginning of the search string, and this query takes forever as the index on
myColumn no longer matters.
Postgres 8.3 has a full-text search feature (and I believe earlier versions
had this functionality through the use of plugins and/or extensions). The
documentation is here:
http://www.postgresql.org/docs/8.3/static/textsearch.html
Basically, you index columns as before, but feeding it the output of a
ts_vector() function, where the input is the column you are indexing. In
order to search on the column, you need to change the WHERE clause to
something like:
WHERE myColumnNowIndexed @@ ts_query('SearchString')
Is there any way to accomplish this in mapserver? I understand from this
page of ms documentation (http://mapserver.org/input/vector/postgis.html)
that it is possible to substitute the bbox parameter of a search in the DATA
entry of a mapfile. Is it possible to alter the WHERE clause of the search
that deals with attribute matching?
Thanks a lot!
--
View this message in context:
http://osgeo-org.1803224.n2.nabble.com/postgres-fulltext-search-tp5009033p5009033.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
Re: [mapserver-users] Difference in GD vs AGG PNG output -- seams in my shape files.
Thomas, Unfortunately, the patch did not appear to correct my situation, so I am back to adding an outline to the ocean polygons. Mark On 5/4/2010 4:02 AM, thomas bonfort wrote: > see http://trac.osgeo.org/mapserver/ticket/3165 for an explanation and a > patch. > > regards, > thomas > > On Tue, May 4, 2010 at 08:37, Dane Springmeyer wrote: > >> You might try setting a map background color the same as your ocean color >> used for the polygons. >> >> Dane >> >> >> On May 3, 2010, at 2:03 PM, Mark Deneen wrote: >> >> signature.asc Description: OpenPGP digital signature ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] postgres fulltext search
On 5/5/2010 9:14 AM, mattmendick wrote:
We have set up a WFS service connected with postgres loaded up with some
substantial datasets of ~120 million rows. We have run into users wanting to
utilize the filter "PropertyIsLike". The search string and a wildcard
character are specified, and mapserver does a search against postgres,
something like:
WHERE myColumn LIKE "SearchString%"
if the search string was SearchString* and the wildcard set to *. There is
an index on myColumn. The users then tried putting the wildcard at the
beginning of the search string, and this query takes forever as the index on
myColumn no longer matters.
Postgres 8.3 has a full-text search feature (and I believe earlier versions
had this functionality through the use of plugins and/or extensions). The
documentation is here:
http://www.postgresql.org/docs/8.3/static/textsearch.html
Basically, you index columns as before, but feeding it the output of a
ts_vector() function, where the input is the column you are indexing. In
order to search on the column, you need to change the WHERE clause to
something like:
WHERE myColumnNowIndexed @@ ts_query('SearchString')
Is there any way to accomplish this in mapserver? I understand from this
page of ms documentation (http://mapserver.org/input/vector/postgis.html)
that it is possible to substitute the bbox parameter of a search in the DATA
entry of a mapfile. Is it possible to alter the WHERE clause of the search
that deals with attribute matching?
Thanks a lot!
How do you do it now? Do you have something in place using:
> WHERE myColumn LIKE "SearchString%"
I suppose what you're asking is, whats the corresponding variable to !BOX!?
-Andy
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] Re: postgres fulltext search
Correct, that is what I'm asking ultimately. What is the "attributal" equivalent to !BBOX! if it exists? -- View this message in context: http://osgeo-org.1803224.n2.nabble.com/postgres-fulltext-search-tp5009033p5009128.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
Re: [mapserver-users] Re: postgres fulltext search
On 5/5/2010 9:28 AM, mattmendick wrote: Correct, that is what I'm asking ultimately. What is the "attributal" equivalent to !BBOX! if it exists? A quick look into the source (mappostgis.c) , I dont see anything similar. However, when it's building the where clause of the sql, it tacks on the layer->filter.string if it exists. If you are using mapscript, you can dynamically update the layer at runtime to set the filter, per request (I'm doing this). You may also be able to use the CGI request params (which I have not done, but recall seeing in the mailing list before). So the layer might look like: LAYER ... FILTER $MYFILTER$ ... END Huge guess at the syntax there. -Andy ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Custom Projections with WMS Server
Thanks for your responses, As Jukka mentioned it is easy to add custom projections on the server side, however the client side it is application dependent, I was focused on GeoMedia and it looks as though you can create a coordinate system file (e.g. EPSG90091.csf )to recognize custom epsg from the server. Thanks On 4 May 2010 10:34, Rahkonen Jukka wrote: > Hi, > > It must be possible to add projections in a somehow similar way on the > QGis side. QGis seems to come with a very similar proj directory as > Mapserver. However, I do not know exactly how to add projections for > QGis. > > -Jukka- > > Jan Hartmann wrote: > > >> I tried this with QGIS, and it didn't work. AFAICS QGIS only accepts >> well know EPSG numbers. >> >> Jan >> >> On 05/04/10 15:15, Travis Kirstine wrote: >> > Is it possible to configure a wms server with custom >> projections (add >> > a entry in the epsg file and mapfile) and have is available >> to client >> > applications (ArcGIS, GeoMedia, QGIS, etc...)? >> > >> > Regards >> > ___ >> > 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 mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Re: postgres fulltext search
On 5/5/2010 9:28 AM, mattmendick wrote: Correct, that is what I'm asking ultimately. What is the "attributal" equivalent to !BBOX! if it exists? Ok, I think I found the spot in the source where it uses 'PropertyIsLike'. (I'm found it in FLTGetIsLikeComparisonSQLExpression) It's in a totally different spot than the !BOX! stuff. I dont see any way of changing the sql it generates (its pretty hard coded to generate 'like'). So I dont think using the PropertyIsLike property will ever generate anything other than a 'like' or 'ilike' sql. I also dont see any wildcards or variables nearby. Also note that I am 90% unfamiliar with the source... so I could be wrong. -Andy ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Difference in GD vs AGG PNG output -- seams in my shape files.
hmm, that's strange. if you're sure you're hitting the patched mapserver version, can you send me an excerpt of that shapefile for testing? -- thomas On Wed, May 5, 2010 at 16:16, Mark Deneen wrote: > Thomas, > > Unfortunately, the patch did not appear to correct my situation, so I am > back to adding an outline to the ocean polygons. > > Mark > > On 5/4/2010 4:02 AM, thomas bonfort wrote: >> see http://trac.osgeo.org/mapserver/ticket/3165 for an explanation and a >> patch. >> >> regards, >> thomas >> >> On Tue, May 4, 2010 at 08:37, Dane Springmeyer wrote: >> >>> You might try setting a map background color the same as your ocean color >>> used for the polygons. >>> >>> Dane >>> >>> >>> On May 3, 2010, at 2:03 PM, Mark Deneen wrote: >>> >>> > > > ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Difference in GD vs AGG PNG output -- seams in my shape files.
Thomas, I am certain that I am hitting the patched map server, and I will contact you off-list with respect to the shapefile. Mark On 5/5/2010 11:00 AM, thomas bonfort wrote: > hmm, that's strange. if you're sure you're hitting the patched > mapserver version, can you send me an excerpt of that shapefile for > testing? > > -- > thomas > > On Wed, May 5, 2010 at 16:16, Mark Deneen wrote: > >> Thomas, >> >> Unfortunately, the patch did not appear to correct my situation, so I am >> back to adding an outline to the ocean polygons. >> >> Mark >> >> On 5/4/2010 4:02 AM, thomas bonfort wrote: >> >>> see http://trac.osgeo.org/mapserver/ticket/3165 for an explanation and a >>> patch. >>> >>> regards, >>> thomas >>> >>> On Tue, May 4, 2010 at 08:37, Dane Springmeyer wrote: >>> >>> You might try setting a map background color the same as your ocean color used for the polygons. Dane On May 3, 2010, at 2:03 PM, Mark Deneen wrote: >> >> >> signature.asc Description: OpenPGP digital signature ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] wms version 1.3 bbox problems
Hi, I'm currently running ms 5.4.2 and am having difficulties with wms version 1.3. I am using MapInfo as the client and it seems that it is hard coded wms version 1.3 if available from the service. It seems that there is bbox issue when passing GetMap request to the service. Is there something I have to add to the mapfile to indicate the correct bbox or projection? MAP NAME "Montreal Map" SIZE 256 256 STATUS OFF UNITS METERS EXTENT -180 -90 180 90 IMAGECOLOR 155 203 231 SHAPEPATH "/home/share1/data" IMAGETYPE JPEG RESOLUTION 96 PROJECTION "init=epsg:4326" END WEB IMAGEPATH "/home/share1/data/map_images/" IMAGEURL "http:///"; METADATA "wms_onlineresource" "http://xx"; "wms_srs" "EPSG:32198 EPSG:2138 EPSG:32098 EPSG:4269 EPSG:4326 EPSG:54004" # updated by user "wms_title" "Montreal Map" # defined by user "wms_abstract" "" # defined by user "ows_sld_enabled" "false" END END OUTPUTFORMAT NAME png DRIVER "GD/PNG" MIMETYPE "image/png" IMAGEMODE RGBA EXTENSION "png" TRANSPARENT ON END OUTPUTFORMAT NAME jpeg DRIVER "GD/JPEG" MIMETYPE "image/jpeg" IMAGEMODE RGB EXTENSION "jpg" FORMATOPTION "QUALITY=80" END LAYER NAME "Imagery_1" DATA "/home/share1/www/openstream/mapfiles/xml/31_Imagery_lvl1.xml" METADATA "wms_group_abstract" "" "wms_group_title" "Imagery" "wms_title" "Imagery_1" "wms_extents" "-180 -85.05112877980659 180 85.0511287798066" END PROJECTION "init=epsg:4326" END MINSCALE 295828775 TYPE RASTER GROUP "Imagery_group" STATUS ON PROCESSING "CLOSE_CONNECTION=DEFER" PROCESSING "RESAMPLE=BILINEAR" END END ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] wms version 1.3 bbox problems
Hi, What does the GetMap request looks like, specifically the bbox coordinates and the projection? For wms 1.3.0, bbox coordinates are expected for projections such as espg:4326 to use the inverse axe order (lat/long instead of long/lat)? regards, On 05/05/2010 11:54 AM, Travis Kirstine wrote: Hi, I'm currently running ms 5.4.2 and am having difficulties with wms version 1.3. I am using MapInfo as the client and it seems that it is hard coded wms version 1.3 if available from the service. It seems that there is bbox issue when passing GetMap request to the service. Is there something I have to add to the mapfile to indicate the correct bbox or projection? MAP NAME "Montreal Map" SIZE 256 256 STATUS OFF UNITS METERS EXTENT -180 -90 180 90 IMAGECOLOR 155 203 231 SHAPEPATH "/home/share1/data" IMAGETYPE JPEG RESOLUTION 96 PROJECTION "init=epsg:4326" END WEB IMAGEPATH "/home/share1/data/map_images/" IMAGEURL "http:///"; METADATA "wms_onlineresource" "http://xx"; "wms_srs" "EPSG:32198 EPSG:2138 EPSG:32098 EPSG:4269 EPSG:4326 EPSG:54004" # updated by user "wms_title" "Montreal Map" # defined by user "wms_abstract" "" # defined by user "ows_sld_enabled" "false" END END OUTPUTFORMAT NAME png DRIVER "GD/PNG" MIMETYPE "image/png" IMAGEMODE RGBA EXTENSION "png" TRANSPARENT ON END OUTPUTFORMAT NAME jpeg DRIVER "GD/JPEG" MIMETYPE "image/jpeg" IMAGEMODE RGB EXTENSION "jpg" FORMATOPTION "QUALITY=80" END LAYER NAME "Imagery_1" DATA "/home/share1/www/openstream/mapfiles/xml/31_Imagery_lvl1.xml" METADATA "wms_group_abstract" "" "wms_group_title" "Imagery" "wms_title" "Imagery_1" "wms_extents" "-180 -85.05112877980659 180 85.0511287798066" END PROJECTION "init=epsg:4326" END MINSCALE 295828775 TYPE RASTER GROUP "Imagery_group" STATUS ON PROCESSING "CLOSE_CONNECTION=DEFER" PROCESSING "RESAMPLE=BILINEAR" END END ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users -- Assefa Yewondwossen Software Analyst Email: yass...@dmsolutions.ca http://www.dmsolutions.ca/ Phone: (613) 565-5056 (ext 14) Fax: (613) 565-0925 ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] Re: postgres fulltext search
Andy-
Thanks a ton for taking a look at this for me. In looking around some more
talking about variable substitution, I found that I can do a FILTER like you
mentioned in the layer section of the mapfile. I could do a:
FILTER "city @@ ts_vector('%mycitysearch%')"
and then in the mapserver request url, add a &mycitysearch=new york, this
will work (I tried it using FILTER "city = '%mycitysearch%'", and it worked
perfectly. I don't have the full-text set up yet on my server, but i've done
it in the past.) It's too bad I can't do it with the normal PropertyIsLike
syntax, but it seems that if I wanted to hack up the code for our own
installation, I could replace the sql building code with my own.
Thanks very much for your help, you've answered a lot of my questions!
-Matt
--
View this message in context:
http://osgeo-org.1803224.n2.nabble.com/postgres-fulltext-search-tp5009033p5009786.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
Re: [mapserver-users] wms version 1.3 bbox problems
It appears that the bbox in the reverse order for 1.3, is there a work around? wms.php?cid=27&VERSION=1.3.0&REQUEST=GetMap&LAYERS=Imagery_group&STYLES=&CRS=EPSG:4269&BBOX=-180,-90,180,90&WIDTH=636&HEIGHT=318&FORMAT=image/png&TRANSPARENT=TRUE&BGCOLOR=0xFF&EXCEPTIONS=XML HTTP/1.1" 200 166460 "-" "C:\\Program Files\\MapInfo85\\Professional\\MAPINFOW.EXE" On 5 May 2010 12:15, Yewondwossen Assefa wrote: > Hi, > > What does the GetMap request looks like, specifically the bbox coordinates > and the projection? For wms 1.3.0, bbox coordinates are expected for > projections such as espg:4326 to use the inverse axe order (lat/long instead > of long/lat)? > > regards, > On 05/05/2010 11:54 AM, Travis Kirstine wrote: >> >> Hi, >> I'm currently running ms 5.4.2 and am having difficulties with wms >> version 1.3. I am using MapInfo as the client and it seems that it is >> hard coded wms version 1.3 if available from the service. It seems >> that there is bbox issue when passing GetMap request to the service. >> Is there something I have to add to the mapfile to indicate the >> correct bbox or projection? >> >> MAP >> NAME "Montreal Map" >> SIZE 256 256 >> STATUS OFF >> UNITS METERS >> EXTENT -180 -90 180 90 >> IMAGECOLOR 155 203 231 >> SHAPEPATH "/home/share1/data" >> IMAGETYPE JPEG >> RESOLUTION 96 >> PROJECTION >> "init=epsg:4326" >> END >> WEB >> IMAGEPATH "/home/share1/data/map_images/" >> IMAGEURL "http:///"; >> METADATA >> "wms_onlineresource" >> "http://xx"; >> "wms_srs" "EPSG:32198 EPSG:2138 EPSG:32098 >> EPSG:4269 EPSG:4326 EPSG:54004" # updated by user >> "wms_title" "Montreal Map" # defined by user >> "wms_abstract" "" # defined by user >> "ows_sld_enabled" "false" >> END >> END >> OUTPUTFORMAT >> NAME png >> DRIVER "GD/PNG" >> MIMETYPE "image/png" >> IMAGEMODE RGBA >> EXTENSION "png" >> TRANSPARENT ON >> END >> OUTPUTFORMAT >> NAME jpeg >> DRIVER "GD/JPEG" >> MIMETYPE "image/jpeg" >> IMAGEMODE RGB >> EXTENSION "jpg" >> FORMATOPTION "QUALITY=80" >> END >> >> LAYER >> NAME "Imagery_1" >> DATA >> "/home/share1/www/openstream/mapfiles/xml/31_Imagery_lvl1.xml" >> METADATA >> "wms_group_abstract" "" >> "wms_group_title" "Imagery" >> "wms_title" "Imagery_1" >> "wms_extents" "-180 -85.05112877980659 180 >> 85.0511287798066" >> END >> PROJECTION >> "init=epsg:4326" >> END >> MINSCALE 295828775 >> TYPE RASTER >> GROUP "Imagery_group" >> STATUS ON >> PROCESSING "CLOSE_CONNECTION=DEFER" >> PROCESSING "RESAMPLE=BILINEAR" >> END >> END >> ___ >> mapserver-users mailing list >> mapserver-users@lists.osgeo.org >> http://lists.osgeo.org/mailman/listinfo/mapserver-users >> >> > > > -- > > Assefa Yewondwossen > Software Analyst > > Email: yass...@dmsolutions.ca > http://www.dmsolutions.ca/ > > Phone: (613) 565-5056 (ext 14) > Fax: (613) 565-0925 > > > > ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] wms version 1.3 bbox problems
You could possibly look into using mapscript wrapper for WxS services (http://mapserver.org/ogc/mapscript.html) and possibly change the version programatically or the order of the bbox. regards, On 05/05/2010 2:29 PM, Travis Kirstine wrote: It appears that the bbox in the reverse order for 1.3, is there a work around? wms.php?cid=27&VERSION=1.3.0&REQUEST=GetMap&LAYERS=Imagery_group&STYLES=&CRS=EPSG:4269&BBOX=-180,-90,180,90&WIDTH=636&HEIGHT=318&FORMAT=image/png&TRANSPARENT=TRUE&BGCOLOR=0xFF&EXCEPTIONS=XML HTTP/1.1" 200 166460 "-" "C:\\Program Files\\MapInfo85\\Professional\\MAPINFOW.EXE" On 5 May 2010 12:15, Yewondwossen Assefa wrote: Hi, What does the GetMap request looks like, specifically the bbox coordinates and the projection? For wms 1.3.0, bbox coordinates are expected for projections such as espg:4326 to use the inverse axe order (lat/long instead of long/lat)? regards, On 05/05/2010 11:54 AM, Travis Kirstine wrote: Hi, I'm currently running ms 5.4.2 and am having difficulties with wms version 1.3. I am using MapInfo as the client and it seems that it is hard coded wms version 1.3 if available from the service. It seems that there is bbox issue when passing GetMap request to the service. Is there something I have to add to the mapfile to indicate the correct bbox or projection? MAP NAME "Montreal Map" SIZE 256 256 STATUS OFF UNITS METERS EXTENT -180 -90 180 90 IMAGECOLOR 155 203 231 SHAPEPATH "/home/share1/data" IMAGETYPE JPEG RESOLUTION 96 PROJECTION "init=epsg:4326" END WEB IMAGEPATH "/home/share1/data/map_images/" IMAGEURL "http:///"; METADATA "wms_onlineresource" "http://xx"; "wms_srs" "EPSG:32198 EPSG:2138 EPSG:32098 EPSG:4269 EPSG:4326 EPSG:54004" # updated by user "wms_title" "Montreal Map" # defined by user "wms_abstract" "" # defined by user "ows_sld_enabled" "false" END END OUTPUTFORMAT NAME png DRIVER "GD/PNG" MIMETYPE "image/png" IMAGEMODE RGBA EXTENSION "png" TRANSPARENT ON END OUTPUTFORMAT NAME jpeg DRIVER "GD/JPEG" MIMETYPE "image/jpeg" IMAGEMODE RGB EXTENSION "jpg" FORMATOPTION "QUALITY=80" END LAYER NAME "Imagery_1" DATA "/home/share1/www/openstream/mapfiles/xml/31_Imagery_lvl1.xml" METADATA "wms_group_abstract" "" "wms_group_title" "Imagery" "wms_title" "Imagery_1" "wms_extents" "-180 -85.05112877980659 180 85.0511287798066" END PROJECTION "init=epsg:4326" END MINSCALE 295828775 TYPE RASTER GROUP "Imagery_group" STATUS ON PROCESSING "CLOSE_CONNECTION=DEFER" PROCESSING "RESAMPLE=BILINEAR" END END ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users -- Assefa Yewondwossen Software Analyst Email: yass...@dmsolutions.ca http://www.dmsolutions.ca/ Phone: (613) 565-5056 (ext 14) Fax: (613) 565-0925 -- Assefa Yewondwossen Software Analyst Email: yass...@dmsolutions.ca http://www.dmsolutions.ca/ Phone: (613) 565-5056 (ext 14) Fax: (613) 565-0925 ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] wms version 1.3 bbox problems
And don't forget to check that user-agent is MAPINFOW.EXE before doing that, or you would screw up requests sent by OGC specs respectful clients. If you want to change the order of coordinates, only do it for EPSG codes between 4000 and 5000... Regards, Guillaume Le 05/05/2010 21:08, Yewondwossen Assefa a écrit : You could possibly look into using mapscript wrapper for WxS services (http://mapserver.org/ogc/mapscript.html) and possibly change the version programatically or the order of the bbox. regards, On 05/05/2010 2:29 PM, Travis Kirstine wrote: It appears that the bbox in the reverse order for 1.3, is there a work around? wms.php?cid=27&VERSION=1.3.0&REQUEST=GetMap&LAYERS=Imagery_group&STYLES=&CRS=EPSG:4269&BBOX=-180,-90,180,90&WIDTH=636&HEIGHT=318&FORMAT=image/png&TRANSPARENT=TRUE&BGCOLOR=0xFF&EXCEPTIONS=XML HTTP/1.1" 200 166460 "-" "C:\\Program Files\\MapInfo85\\Professional\\MAPINFOW.EXE" On 5 May 2010 12:15, Yewondwossen Assefa wrote: Hi, What does the GetMap request looks like, specifically the bbox coordinates and the projection? For wms 1.3.0, bbox coordinates are expected for projections such as espg:4326 to use the inverse axe order (lat/long instead of long/lat)? regards, On 05/05/2010 11:54 AM, Travis Kirstine wrote: Hi, I'm currently running ms 5.4.2 and am having difficulties with wms version 1.3. I am using MapInfo as the client and it seems that it is hard coded wms version 1.3 if available from the service. It seems that there is bbox issue when passing GetMap request to the service. Is there something I have to add to the mapfile to indicate the correct bbox or projection? MAP NAME "Montreal Map" SIZE 256 256 STATUS OFF UNITS METERS EXTENT -180 -90 180 90 IMAGECOLOR 155 203 231 SHAPEPATH "/home/share1/data" IMAGETYPE JPEG RESOLUTION 96 PROJECTION "init=epsg:4326" END WEB IMAGEPATH "/home/share1/data/map_images/" IMAGEURL "http:///"; METADATA "wms_onlineresource" "http://xx"; "wms_srs" "EPSG:32198 EPSG:2138 EPSG:32098 EPSG:4269 EPSG:4326 EPSG:54004" # updated by user "wms_title" "Montreal Map" # defined by user "wms_abstract" "" # defined by user "ows_sld_enabled" "false" END END OUTPUTFORMAT NAME png DRIVER "GD/PNG" MIMETYPE "image/png" IMAGEMODE RGBA EXTENSION "png" TRANSPARENT ON END OUTPUTFORMAT NAME jpeg DRIVER "GD/JPEG" MIMETYPE "image/jpeg" IMAGEMODE RGB EXTENSION "jpg" FORMATOPTION "QUALITY=80" END LAYER NAME "Imagery_1" DATA "/home/share1/www/openstream/mapfiles/xml/31_Imagery_lvl1.xml" METADATA "wms_group_abstract" "" "wms_group_title" "Imagery" "wms_title" "Imagery_1" "wms_extents" "-180 -85.05112877980659 180 85.0511287798066" END PROJECTION "init=epsg:4326" END MINSCALE 295828775 TYPE RASTER GROUP "Imagery_group" STATUS ON PROCESSING "CLOSE_CONNECTION=DEFER" PROCESSING "RESAMPLE=BILINEAR" END END ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users -- Assefa Yewondwossen Software Analyst Email: yass...@dmsolutions.ca http://www.dmsolutions.ca/ Phone: (613) 565-5056 (ext 14) Fax: (613) 565-0925 ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] RE: How to avoid drawing overlapping point symbols?
Hi Mark: There are a couple of ways to go. Either should work. Option 1 is less of hack I so I'd start there. Option 2 is really more useful when you want to label the marker. Steve Option 1: TrueType symbol as text. LAYER NAME 'option1' DATA ... TYPE ANNOTATION CLASS COLOR 0 0 0 # may need this for things to draw, or you may not TEXT ',' # no need for a label item, this is references the symbol in your font you want to use LABEL FONT TYPE TRUETYPE FONT "nrcs-ssurgo" ANTIALIAS TRUE SIZE 10 END END END Option 2: Use a marker symbol SYMBOL NAME "ROC" TYPE TRUETYPE FONT "nrcs-ssurgo" CHARACTER "," ANTIALIAS TRUE END LAYER NAME "option2" STATUS ON TYPE ANNOTATION DATA ... CLASS STYLE SYMBOL "ROC" SIZE 12 COLOR 0 0 0 END TEXT ' ' # a blank space LABEL SIZE tiny # doesn't matter what you define END END END From: Sigda, Mark - Fort Collins, CO [mark.si...@ftc.usda.gov] Sent: Tuesday, May 04, 2010 1:51 PM To: Lime, Steve D (DNR); mapserver-users@lists.osgeo.org Subject: RE: How to avoid drawing overlapping point symbols? Thank you, Steve. I'm trying annotation, but haven't been able to get it working yet. I wasn't able to find examples of annotation layers, so I'm just hacking here. Would you please take a look at my map file? Below is basically what I'm doing (though I have many more symbols & classes). If I use the map file below, it draws nothing. If I uncomment the commented lines, it draws both the marker symbols and labels, but I don't want labels. Can you tell me how to draw just the marker symbols? Thanks, -Mark SYMBOL NAME "ROC" TYPE TRUETYPE FONT "nrcs-ssurgo" CHARACTER "," ANTIALIAS TRUE END LAYER NAME "featpoint" STATUS ON TYPE ANNOTATION CONNECTIONTYPE PLUGIN PLUGIN "msplugin_mssql2008.dll" CONNECTION "removed" DATA "ShapeGeometry from featpoint using unique featpointiid using SRID=4269" PROJECTION 'init=C:\ms4w\proj\nad\epsg:4269' END CLASSITEM "featsym" TRANSPARENCY ALPHA # LABELITEM "featsym" CLASS EXPRESSION 'ROC' STYLE SYMBOL "ROC" SIZE 12 COLOR 0 0 0 END #LABEL # ANTIALIAS true # POSITION AUTO # FONT "arial" # TYPE truetype # COLOR 0 0 0 # SIZE 8 #END END END -Original Message- From: Lime, Steve D (DNR) [mailto:steve.l...@state.mn.us] Sent: Monday, May 03, 2010 2:45 PM To: Sigda, Mark - Fort Collins, CO; mapserver-users@lists.osgeo.org Subject: RE: How to avoid drawing overlapping point symbols? Use an annotation layer, you can even use the truetype symbol as the text, collisions will be avoided in this case. Even if you have to use the truetype symbol as a marker symbol with accompanying text MapServer will still avoid overlap with the markers. Steve From: mapserver-users-boun...@lists.osgeo.org [mapserver-users-boun...@lists.osgeo.org] On Behalf Of Sigda, Mark - Fort Collins, CO [mark.si...@ftc.usda.gov] Sent: Monday, May 03, 2010 2:52 PM To: mapserver-users@lists.osgeo.org Subject: [mapserver-users] How to avoid drawing overlapping point symbols? I have a point layer I'm drawing with a truetype symbol. When points are close together, a big mess of overlapping symbols is drawn. How can I tell MapServer not do draw symbols for points that are close together? I'm looking for something like GAP on the STYLE element, but that apparently applies only to line features. Thanks, -Mark ___ 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] RE: How to avoid drawing overlapping point symbols?
Option 1 works great (just had to remove "FONT" after "LABEL). "COLOR 0 0 0" wasn't needed. Thanks Steve!! > -Original Message- > From: Lime, Steve D (DNR) [mailto:steve.l...@state.mn.us] > Sent: Wednesday, May 05, 2010 4:00 PM > To: Sigda, Mark - Fort Collins, CO; mapserver-users@lists.osgeo.org > Subject: RE: How to avoid drawing overlapping point symbols? > > Hi Mark: There are a couple of ways to go. Either should work. Option 1 > is less of hack I so I'd start there. Option 2 is really more useful > when you want to label the marker. > > Steve > > Option 1: TrueType symbol as text. > > LAYER > NAME 'option1' > DATA ... > TYPE ANNOTATION > CLASS > COLOR 0 0 0 # may need this for things to draw, or you may not > TEXT ',' # no need for a label item, this is references the symbol > in your font you want to use > LABEL > FONT > TYPE TRUETYPE > FONT "nrcs-ssurgo" > ANTIALIAS TRUE > SIZE 10 > END > END > END > > Option 2: Use a marker symbol > > SYMBOL > NAME "ROC" > TYPE TRUETYPE > FONT "nrcs-ssurgo" > CHARACTER "," > ANTIALIAS TRUE > END > > LAYER > NAME "option2" > STATUS ON > TYPE ANNOTATION > DATA ... > CLASS > STYLE > SYMBOL "ROC" > SIZE 12 > COLOR 0 0 0 > END > TEXT ' ' # a blank space > LABEL >SIZE tiny # doesn't matter what you define > END > END > END > > > > From: Sigda, Mark - Fort Collins, CO [mark.si...@ftc.usda.gov] > Sent: Tuesday, May 04, 2010 1:51 PM > To: Lime, Steve D (DNR); mapserver-users@lists.osgeo.org > Subject: RE: How to avoid drawing overlapping point symbols? > > Thank you, Steve. I'm trying annotation, but haven't been able to get > it working yet. I wasn't able to find examples of annotation layers, > so I'm just hacking here. Would you please take a look at my map file? > > Below is basically what I'm doing (though I have many more symbols & > classes). If I use the map file below, it draws nothing. If I > uncomment the commented lines, it draws both the marker symbols and > labels, but I don't want labels. > > Can you tell me how to draw just the marker symbols? > > Thanks, > > -Mark > > > SYMBOL > NAME "ROC" > TYPE TRUETYPE > FONT "nrcs-ssurgo" > CHARACTER "," > ANTIALIAS TRUE > END > > LAYER > NAME "featpoint" > STATUS ON > TYPE ANNOTATION > CONNECTIONTYPE PLUGIN > PLUGIN "msplugin_mssql2008.dll" > CONNECTION "removed" > DATA "ShapeGeometry from featpoint using unique featpointiid > using SRID=4269" > PROJECTION 'init=C:\ms4w\proj\nad\epsg:4269' END > CLASSITEM "featsym" > TRANSPARENCY ALPHA > # LABELITEM "featsym" > CLASS > EXPRESSION 'ROC' > STYLE > SYMBOL "ROC" > SIZE 12 > COLOR 0 0 0 > END > #LABEL > # ANTIALIAS true > # POSITION AUTO > # FONT "arial" > # TYPE truetype > # COLOR 0 0 0 > # SIZE 8 > #END > END > END > > -Original Message- > From: Lime, Steve D (DNR) [mailto:steve.l...@state.mn.us] > Sent: Monday, May 03, 2010 2:45 PM > To: Sigda, Mark - Fort Collins, CO; mapserver-users@lists.osgeo.org > Subject: RE: How to avoid drawing overlapping point symbols? > > Use an annotation layer, you can even use the truetype symbol as the > text, collisions will be avoided in this case. Even if you have to use > the truetype symbol as a marker symbol with accompanying text MapServer > will still avoid overlap with the markers. > > Steve > > From: mapserver-users-boun...@lists.osgeo.org [mapserver-users- > boun...@lists.osgeo.org] On Behalf Of Sigda, Mark - Fort Collins, CO > [mark.si...@ftc.usda.gov] > Sent: Monday, May 03, 2010 2:52 PM > To: mapserver-users@lists.osgeo.org > Subject: [mapserver-users] How to avoid drawing overlapping point > symbols? > > I have a point layer I'm drawing with a truetype symbol. When points > are close together, a big mess of overlapping symbols is drawn. > > How can I tell MapServer not do draw symbols for points that are close > together? I'm looking for something like GAP on the STYLE element, but > that apparently applies only to line features. > > Thanks, > > -Mark > ___ > 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] Re: postgres fulltext search
Matt,
Just picked up on the thead, sorry for the late posting. In PostgreSQL, for
full-text indexing in TSearch2 (don't know if your FTS experience is with
PG), you can also build with plainto_tsquery(), and if you want to avoid the
dictionary stemming etc., prepare the index and use the search with 'simple'
- i.e. to_tsvector('simple',my_field). This allows you to match words from
a supplied phrase, rather than the phrase itself as with @@, and use
rankings, similarity etc. to score your results.
Alternatively, preparing a btree index with a varchar_pattern_ops or
text_pattern_ops opclass (see
http://www.postgresql.org/docs/current/static/indexes-opclass.html) allows
the use of like, so long as the search is anchored at the start of the term.
Steve
On 5 May 2010 17:25, mattmendick wrote:
>
> Andy-
>
> Thanks a ton for taking a look at this for me. In looking around some more
> talking about variable substitution, I found that I can do a FILTER like
> you
> mentioned in the layer section of the mapfile. I could do a:
>
> FILTER "city @@ ts_vector('%mycitysearch%')"
>
> and then in the mapserver request url, add a &mycitysearch=new york, this
> will work (I tried it using FILTER "city = '%mycitysearch%'", and it worked
> perfectly. I don't have the full-text set up yet on my server, but i've
> done
> it in the past.) It's too bad I can't do it with the normal PropertyIsLike
> syntax, but it seems that if I wanted to hack up the code for our own
> installation, I could replace the sql building code with my own.
>
> Thanks very much for your help, you've answered a lot of my questions!
>
> -Matt
> --
> View this message in context:
> http://osgeo-org.1803224.n2.nabble.com/postgres-fulltext-search-tp5009033p5009786.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 mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] WCS/WMS/WFS version negotiation
Hello All, is there a way to configure a mapfile to only support a given version of WCS, WFS, WMS? For example, can I configure mapserver to only host WCS version 1.1 and refuse any request specifying a different version? Thanks! --john ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
