From lfilak@medinaco.org Wed Aug 4 18:15:27 2004 From: lfilak@medinaco.org (Lowell Filak) Date: Wed, 04 Aug 2004 13:15:27 -0400 Subject: Fwd: Re: [Mapserver-users] Fw: help on mygis Message-ID: <20040804171513.9ED681A65A5@mail.medinaco.org> The following message was sent by "pablo" on Wed, 4 Aug 2004 14:04:50 -0300. > EXAMPLE: > =========== > PLEASE SEND EXAMPLE THIS IN MYSQL (MYGIS) > por favor envieme un ejemplo de esto para mysql, o bien como tradusco esto a > mi MAP > yo quise hacer esto y no pude no encuentro forma de hacerlo. > > DATA "the_geom from > (select nut3.the_geom, > case when un3rt.unit > 16 then 1 > when un3rt.unit > 10 and un3rt.unit < 16 then 2 > when un3rt.unit > 5 and un3rt.unit < 10 then 3 > when un3rt.unit > 0 and un3rt.unit < 5 then 4 > else 5 > end as myclass > from nut3,un3rt > where nut3.nurgcd=un3rt.geo > ) as foo" > > > CLASSITEM myclass > CLASS > EXPRESSION 1 > COLOR 255 0 0 > END > CLASS > EXPRESSION 2 > COLOR 250 100 100 > END > CLASS > EXPRESSION 3 > COLOR 250 200 200 > END > CLASS > EXPRESSION 4 > COLOR 250 220 220 > END > CLASS > EXPRESSION 5 > COLOR 210 210 210 > END > > > ----- Original Message ----- > From: "Lowell Filak" > To: "pablo" > Sent: Monday, August 02, 2004 10:36 AM > Subject: Re: [Mapserver-users] Fw: help on mygis > > > > Unfortunately the new list server doesn't appear to be working, however > > you need to submit this to the list. I only have limited knowledge of > > what your trying to accomplish. My original suggestion was to combine > > all your attributes into a single MySQL table so you could work on the > > labelling issues without the added complexity of relating two tables in > > MySQL. > > > > HTH > > > > Lowell > > > > The following message was sent by "pablo" > > on Fri, 30 Jul 2004 18:00:33 -0300. > > > > > Hello again, > > > > > > This is a piece of my MAP FILE : > > > > > > LAYER > > > NAME "grupos2002" > > > STATUS ON > > > CONNECTIONTYPE mygis > > > CONECTION "localhost:gisusr:gis:gisdb:bin:" > > > DATA "geometry from grupos2002 feature, grupos2002_bin geometry" > > > > > > CLASS > > > NAME "Zona Geo" > > > OUTLINECOLOR 60 60 60 > > > COLOR 255 255 0 > > > SYMBOL 0 > > > END > > > END > > > > > > LAYER > > > STATUS ON > > > CONNECTIONTYPE mygis > > > CONECTION "localhost:gisusr:gis:gisdb:bin:" > > > DATA ???????????????????????????????? > > > TYPE ANNOTATION > > > LABELITEM ?????????????????????? > > > CLASS > > > ANGLE AUTO > > > SIZE 8 > > > COLOR 0 192 0 > > > TYPE TRUETYPE > > > FONT ARIAL > > > END > > > END > > > > > > I have a table zonas with the following fields: > > > 1- f_Zona ( olso located in grupos2002 ) > > > 2- Description > > > 3- Atributos > > > > > > Questions : > > > > > > - What do I have to do to link the f_zona field (Zonas Table) to f_zona > > > (Grupos2002 table)?. I need to use Description field (Zonas table) as > > label > > > of the LAYER ANNOTATION. > > > > > > - I don't know how to make the query that map server needs to link or > join > > > the data of my zona table with the data of the map. > > > > > > - How should i write this query ? > > > > > > - Could I use a custom query to get the geometric data of grupos2002, > > > grupos2002.bin? > > > DATA "geometry from grupos2002 feature, grupos2002_bin > > geometry"---- >>> > > > Is it posible to write this in ANSI query( select xxx from xxx where > > > ..etc.) ? Example please!!! > > > > > > - Do I need more extra fields in the zonas table to get this work well? > > > > > > thank you very much!!! > > > Pablo > > > > > > > > > ----- Original Message ----- > > > From: "Lowell Filak" > > > To: "pablo_schmitt_" ; > > > > > > Sent: Thursday, July 29, 2004 11:09 AM > > > Subject: Re: [Mapserver-users] Fw: help on mygis > > > > > > > > > > I don't know mygis but as a quick fix you could join all the > attributes > > > > into the first layer so there is no relate required to do the > > labelling.? > > > > > > > > Lowell > > > > > > > > The following message was sent by "pablo_schmitt_" > > > > on Thu, 29 Jul 2004 09:47:43 -0300. > > > > > > > > > > > > > > ----- Original Message ----- > > > > > From: pablo_schmitt_ > > > > > To: mapserver-users@lists.gis.umn.edu > > > > > Sent: Wednesday, July 28, 2004 6:59 PM > > > > > Subject: help on mygis > > > > > > > > > > > > > > > hello friends > > > > > i need some help from you > > > > > > > > > > this is a brief description of my problem: > > > > > > > > > > i have a grupos2002.shp file uploaded into mysql using the > > > > shp2mysql.lp, > and it is working properly > > > > > > > > > > this script generated the following tables geometry_columns, > > > > grupos2002, > grupos2002_bin, grupos2002_num > > > > > , spatial_ref_sys > > > > > > > > > > in the map file i have this definition for the connection and data: > > > > > CONNECTION "localhost:gisusr:gis:gisdb:bin:" > > > > > DATA "geometry from grupos2002 feature, grupos2002_bin geometry" > > > > > and it is working fine > > > > > > > > > > my problem is: > > > > > i have a table zonas with the following fields: > > > > > 1- f_Zona ( olso located in grupos2002 ) > > > > > 2- Description > > > > > 3- Atributos > > > > > > > > > > so, i need to use the field number 2 ( Description) as Label in the > > > > map > and i need to apply some filters using the field number > > > > > 3 (Atributos). > > > > > > > > > > THE BIG CUESTION IS: how should i contruct my DATA definition in the > > > > map > file ???? > > > > > > > > > > i hope you could understand me > > > > > > > > > > thank you very much > > > > > by > > > > > > > > > > pablo schmitt > > > > > municipalidad de malvinas argentinas > > > > > dep. informática > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > From kgeurts@gis.umn.edu Wed Aug 4 18:34:42 2004 From: kgeurts@gis.umn.edu (kgeurts) Date: Wed, 04 Aug 2004 12:34:42 CDT Subject: [Mapserver-users] RE: IMPORTANT - host site for mapserver-users HAS changed! Message-ID: <200408041734.i74HYgtb031547@challenge.software.umn.edu> Hello MS-Users, We will be shutting this mail listserv down so you will need to re-subscribe to the MapServer User list if you would like to continue to participate. Please go to (http://lists.umn.edu/archives/mapserver-users.html) and click on "Join or leave the list" to re-subscribe. Then follow the instructions. Thank you for your cooperation and we hope to see you on the new list. Kari A. Geurts Department of Forest Resources University of Minnesota 1530 Cleveland Ave N. St. Paul, MN. 55108 Phone: 612-624-3459 Fax: 612-625-5212 > > ------------- Begin Forwarded Message ------------- > > From: Thomas E Burk > To: mapserver-users@lists.gis.umn.edu > MIME-Version: 1.0 > Content-MD5: WtEekPtNpEwb5CEBOFwadg== > Content-Transfer-Encoding: 8bit > X-MIME-Autoconverted: from QUOTED-PRINTABLE to 8bit by > lists.gis.umn.edu id i6LLDuFS017760 > Subject: [Mapserver-users] IMPORTANT - host site for > mapserver-users to change > X-BeenThere: mapserver-users@lists.gis.umn.edu > X-Mailman-Version: 2.0.13 > List-Unsubscribe: > , > ribe> > List-Id: Mapserver Users Mailing List (Appropriate for general > users) > List-Post: > List-Help: > > List-Subscribe: > , > be> > List-Archive: > > Date: Wed, 21 Jul 2004 15:59:35 -0500 (CDT) > > You will soon need to resubscribe to this mailing list to > continue your participation. > > > On Saturday July 31, 2004 at midnight U.S. Central Daylight time > (GMT -5:00) we will close down the existing mapserver-users > (at lists.gis.umn.edu) e-mail list. If you wish to continue > participating on the list you will need to resubscribe. > You can do that _after July 31, 2004_ by going to > . At that > time there will be a link to 'Join or leave the list' where you > can fill out a form. > > > The new list will be run by a group which offers listserv > capability as part of their mission. It should be a > positive change. > > > One major change we are making is to restrict access to the > archives; the new archives will only be accessible to > subscribers via a login. The first time you use the archives > (search or browse) you will be asked to setup a > password. You must use the same login e-mail that you subscribed > to the list with -- only list members can view or > search the archives. The is a 'no mail' subscription option for > people who don't want e-mail sent to them (only wish > to use the archive). Initially the old (which will still be > available) and new archives WILL NOT be a single > archive. That will change. > > > The Support page on the MapServer Web site will be updated with > this new information (on August 1, 2004) as well. > > > We hope you will continue to participate in mapserver-users and > appreciate your understanding. > > > Tom > ======================= > Dr. Thomas E. Burk > University of Minnesota > 1530 Cleveland Avenue North > St. Paul, MN 55108 > 612-624-6741 > 612-625-5212 (FAX) > tburk@umn.edu > > > _______________________________________________ > Mapserver-users mailing list > Mapserver-users@lists.gis.umn.edu > http://lists.gis.umn.edu/mailman/listinfo/mapserver-users > > > ------------- End Forwarded Message ------------- > > > From colwell@geog.umn.edu Wed Aug 4 18:38:10 2004 From: colwell@geog.umn.edu (Rebecca Colwell) Date: Wed, 04 Aug 2004 12:38:10 -0500 Subject: [Mapserver-users] Legend Titles/Sub-titles Message-ID: <41111F02.2040503@geog.umn.edu> Hi all, I am working on a mapping app with multiple thematic layers viewable at one time. I'm trying to title each map layer within the legend in bold and then have the text next to each color be in plain text. My mapfile legend looks like this: # # Start of legend # LEGEND STATUS ON KEYSIZE 25 18 LABEL TYPE TRUETYPE FONT times COLOR 0 0 0 SIZE 11 ANTIALIAS TRUE END END Each layer has a metadata tag like this: METADATA "TITLE" "All Disenfranchised Felons" END And in my html code, I have the following for the legend:

Legend:
[TotalDisRate_TITLE][AfrAmerDisRate_TITLE] [StateVotingRights_TITLE]

Right now, the layers and titles appear in the legend, but all the titles appear one after the other, and are then followed by all the titleless layers. Does anyone know how I could modify the legend to have a title/layer/title/layer appearance as opposed to a title/title/layer/layer appearance? Thanks! ~Becky From bfraser@geoanalytic.com Wed Aug 4 19:20:53 2004 From: bfraser@geoanalytic.com (Brent Fraser) Date: Wed, 4 Aug 2004 12:20:53 -0600 Subject: [Mapserver-users] RE: IMPORTANT - host site for mapserver-users HAS changed! References: <200408041734.i74HYgtb031547@challenge.software.umn.edu> Message-ID: <133b01c47a4f$c78eb500$020002c0@SHARK> Kari, I'm confused (although that's not new). Has the developer's list changed too? The Mapserver Support page lists the new users list but not a new developer list. Brent Fraser ----- Original Message ----- From: "kgeurts" To: Cc: "steve lime" Sent: Wednesday, August 04, 2004 11:34 AM Subject: [Mapserver-users] RE: IMPORTANT - host site for mapserver-users HAS changed! > Hello MS-Users, > > We will be shutting this mail listserv down so you will need to > re-subscribe to the MapServer User list if you would like to continue to > participate. > > Please go to (http://lists.umn.edu/archives/mapserver-users.html) and click > on "Join or leave the list" to re-subscribe. Then follow the instructions. > > Thank you for your cooperation and we hope to see you on the new list. > > Kari A. Geurts > > Department of Forest Resources > University of Minnesota > 1530 Cleveland Ave N. > St. Paul, MN. 55108 > Phone: 612-624-3459 > Fax: 612-625-5212 > > > > > ------------- Begin Forwarded Message ------------- > > > > From: Thomas E Burk > > To: mapserver-users@lists.gis.umn.edu > > MIME-Version: 1.0 > > Content-MD5: WtEekPtNpEwb5CEBOFwadg== > > Content-Transfer-Encoding: 8bit > > X-MIME-Autoconverted: from QUOTED-PRINTABLE to 8bit by > > lists.gis.umn.edu id i6LLDuFS017760 > > Subject: [Mapserver-users] IMPORTANT - host site for > > mapserver-users to change > > X-BeenThere: mapserver-users@lists.gis.umn.edu > > X-Mailman-Version: 2.0.13 > > List-Unsubscribe: > > , > > > ribe> > > List-Id: Mapserver Users Mailing List (Appropriate for general > > users) > > List-Post: > > List-Help: > > > > List-Subscribe: > > , > > > be> > > List-Archive: > > > > Date: Wed, 21 Jul 2004 15:59:35 -0500 (CDT) > > > > You will soon need to resubscribe to this mailing list to > > continue your participation. > > > > > > On Saturday July 31, 2004 at midnight U.S. Central Daylight time > > (GMT -5:00) we will close down the existing mapserver-users > > (at lists.gis.umn.edu) e-mail list. If you wish to continue > > participating on the list you will need to resubscribe. > > You can do that _after July 31, 2004_ by going to > > . At that > > time there will be a link to 'Join or leave the list' where you > > can fill out a form. > > > > > > The new list will be run by a group which offers listserv > > capability as part of their mission. It should be a > > positive change. > > > > > > One major change we are making is to restrict access to the > > archives; the new archives will only be accessible to > > subscribers via a login. The first time you use the archives > > (search or browse) you will be asked to setup a > > password. You must use the same login e-mail that you subscribed > > to the list with -- only list members can view or > > search the archives. The is a 'no mail' subscription option for > > people who don't want e-mail sent to them (only wish > > to use the archive). Initially the old (which will still be > > available) and new archives WILL NOT be a single > > archive. That will change. > > > > > > The Support page on the MapServer Web site will be updated with > > this new information (on August 1, 2004) as well. > > > > > > We hope you will continue to participate in mapserver-users and > > appreciate your understanding. > > > > > > Tom > > ======================= > > Dr. Thomas E. Burk > > University of Minnesota > > 1530 Cleveland Avenue North > > St. Paul, MN 55108 > > 612-624-6741 > > 612-625-5212 (FAX) > > tburk@umn.edu > > > > > > _______________________________________________ > > Mapserver-users mailing list > > Mapserver-users@lists.gis.umn.edu > > http://lists.gis.umn.edu/mailman/listinfo/mapserver-users > > > > > > ------------- End Forwarded Message ------------- > > > > > > > > > _______________________________________________ > Mapserver-users mailing list > Mapserver-users@lists.gis.umn.edu > http://lists.gis.umn.edu/mailman/listinfo/mapserver-users From mmcgrath@umd.edu Wed Aug 4 19:31:55 2004 From: mmcgrath@umd.edu (Michael McGrath) Date: Wed, 04 Aug 2004 14:31:55 -0400 Subject: [Mapserver-users] confused about QueryByPoint Message-ID: <1091644315.b6d555a0mmcgrath@umd.edu> Hi, I'm new to Mapserver and PHP/Mapscript, and I'm currently in the process of figuring out how to perform queries. I have a simple map file with 3 layers and a small php script for zooming/panning and performing queries. Zooming and panning works fine, but when I perform queries I get strange results. If I set the query mode to MS_MULTIPLE, the function always returns every feature in the layer. If I change it to MS_SINGLE, I always get a feature that is nowhere near the feature I clicked on. Changing the UNITS attribute for the MAP results in no features being returned at all, and changing the TOLERANCEUNITS to anything besides miles also results in no features being returned. Here is my mapfile: MAP STATUS ON IMAGETYPE PNG EXTENT -79.487152 37.911423 -75.045898 39.724014 SIZE 800 600 SHAPEPATH "maps" IMAGECOLOR 255 255 255 SYMBOLSET '/var/www/htmldocs/mapfiles/etc/symbols/symbols.sym' #UNITS meters WEB IMAGEPATH "/var/www/htmldocs/mapfiles/tmp/" IMAGEURL "/mapfiles/tmp/" END #PROJECTION # "proj=utm" # "ellps=GRS80" # "zone=18x" # "north" # "no defs" #END LAYER NAME "counties" METADATA "DESCRIPTION" "CNAME" "RESULT_FIELDS" "COUNTY" END DATA "counties" STATUS ON TYPE POLYGON CLASS COLOR 168 214 138 OUTLINECOLOR 56 32 11 TEMPLATE 'dummy' END TOLERANCE 3 TOLERANCEUNITS miles #PROJECTION # "proj=utm" # "ellps=GRS80" # "zone=15" # "north" # "no defs" #END END LAYER NAME "interstate" DATA "interstate" STATUS ON TYPE LINE CLASS COLOR 0 0 0 SIZE 2 END TOLERANCE 10 END LAYER NAME "detectors" METADATA "DESCRIPTION" "Lat" "RESULT_FIELDS" 'Latitude' END DATA "detectors" STATUS ON TYPE POINT CLASS COLOR 255 0 0 SYMBOL 'circle' SYMBOL 'circle' SIZE 3 TEMPLATE "dummy" END TOLERANCE 3 TOLERANCEUNITS miles END OUTPUTFORMAT NAME png DRIVER "GD/png" MIMETYPE "image/png" IMAGEMODE PC256 EXTENSION "png" END END And here is the php code responsible for performing the query: $detLayer = $map->getLayerByName("counties"); $detLayer->queryByPoint($my_point, MS_SINGLE, -1); $count_results = $detLayer->getNumResults(); echo $count_results . '
'; if ($count_results > 0) { $detLayer->open(); $selFields = explode(" ", $detLayer->getMetaData("CNAME")); $oRes = $detLayer->getResult(0); $oShape = $detLayer->getShape($oRes->tileindex,$oRes->shapeindex); $aResBoundBox = array($oShape->bounds->minx, $oShape->bounds->miny, $oShape->bounds->maxx, $oShape->bounds->maxy); $ID = $oShape->values['COUNTY']; echo $ID; $oShape->free(); } else { echo "nothing found
"; } The version of mapserver we are using here was compiled without proj4 support, which is why all the projection sections in the mapfile are commented out. Could that be my problem? Any light you could shed on this problem would be greatly appreciated Thanks, Mike McGrath mmcgrath AT umd DOT edu From kgeurts@gis.umn.edu Wed Aug 4 20:25:43 2004 From: kgeurts@gis.umn.edu (kgeurts) Date: Wed, 04 Aug 2004 14:25:43 CDT Subject: [Mapserver-users] We weren't kidding - this list is being shut down!! Message-ID: <200408041925.i74JPijS009264@challenge.software.umn.edu> We sent out messages to this list on July 21, 25, 30 warning people that this list would be shutdown and if you wished to continue participating you'd need to subscribe to a new list. See the forwarded message below. This is another (final) reminder. There should be no other traffic on mapserver-users@lists.gis.umn.edu . The new list is mapserver-users@lists.umn.edu . If you have difficulty subscribing to or using the new list, please e-mail me (kgeurts@gis.umn.edu) directly. Kari > > > > > ------------- Begin Forwarded Message ------------- > > > > > > From: Thomas E Burk > > > To: mapserver-users@lists.gis.umn.edu > > > MIME-Version: 1.0 > > > Content-MD5: WtEekPtNpEwb5CEBOFwadg== > > > Content-Transfer-Encoding: 8bit > > > X-MIME-Autoconverted: from QUOTED-PRINTABLE to 8bit by > > > lists.gis.umn.edu id i6LLDuFS017760 > > > Subject: [Mapserver-users] IMPORTANT - host site for > > > mapserver-users to change > > > X-BeenThere: mapserver-users@lists.gis.umn.edu > > > X-Mailman-Version: 2.0.13 > > > List-Unsubscribe: > > > , > > > > > ribe> > > > List-Id: Mapserver Users Mailing List (Appropriate for general > > > users) > > > List-Post: > > > List-Help: > > > > > > List-Subscribe: > > > , > > > > > be> > > > List-Archive: > > > > > > Date: Wed, 21 Jul 2004 15:59:35 -0500 (CDT) > > > > > > You will soon need to resubscribe to this mailing list to > > > continue your participation. > > > > > > > > > On Saturday July 31, 2004 at midnight U.S. Central Daylight time > > > (GMT -5:00) we will close down the existing mapserver-users > > > (at lists.gis.umn.edu) e-mail list. If you wish to continue > > > participating on the list you will need to resubscribe. > > > You can do that _after July 31, 2004_ by going to > > > . At that > > > time there will be a link to 'Join or leave the list' where you > > > can fill out a form. > > > > > > > > > The new list will be run by a group which offers listserv > > > capability as part of their mission. It should be a > > > positive change. > > > > > > > > > One major change we are making is to restrict access to the > > > archives; the new archives will only be accessible to > > > subscribers via a login. The first time you use the archives > > > (search or browse) you will be asked to setup a > > > password. You must use the same login e-mail that you subscribed > > > to the list with -- only list members can view or > > > search the archives. The is a 'no mail' subscription option for > > > people who don't want e-mail sent to them (only wish > > > to use the archive). Initially the old (which will still be > > > available) and new archives WILL NOT be a single > > > archive. That will change. > > > > > > > > > The Support page on the MapServer Web site will be updated with > > > this new information (on August 1, 2004) as well. > > > > > > > > > We hope you will continue to participate in mapserver-users and > > > appreciate your understanding. > > > > > > > > > Tom > > > ======================= > > > Dr. Thomas E. Burk > > > University of Minnesota > > > 1530 Cleveland Avenue North > > > St. Paul, MN 55108 > > > 612-624-6741 > > > 612-625-5212 (FAX) > > > tburk@umn.edu > > > > > > > > > _______________________________________________ > > > Mapserver-users mailing list > > > Mapserver-users@lists.gis.umn.edu > > > http://lists.gis.umn.edu/mailman/listinfo/mapserver-users > > > > > > > > > ------------- End Forwarded Message ------------- > > > From Jwiebe@linnet.ca Wed Aug 4 21:10:27 2004 From: Jwiebe@linnet.ca (Jeremy Wiebe) Date: Wed, 4 Aug 2004 15:10:27 -0500 Subject: [Mapserver-users] Highlighting items in map Message-ID: <3CA510AEAB8DD411B66B0090273FA099041B107C@LINNET_SRV_10> Hi there, I posted to this list a while ago about a problem I was having using SLD to style some items in a layer and leave the rest as their default style. The problem I was having was that the SLD was growing to be quite big and slowing down the mapserver response time. I'm wondering if this is the best way to accomplish this. Does anyone have suggestions for other ways to accomplish selective highlighting of items within a layer. I want all items in the layer to still be drawn onto the map, but the items that match the users search to be styled differently. Tom Kralidis suggested using a FilterExpression with a SQL 'IN' clause, but I have come up empty searching the mapserver-users archives as well as Google. Any help would be _greatly_ appreciated. P.S. The layer data is stored in a SQL Server database and is accessed using an OGR .ovf file. Jeremy Wiebe Application Developer Linnet - The Land Systems Company 1600-444 St. Mary Avenue, Winnipeg, Manitoba, Canada, R3C 3T1 Tel: 1-204-957-6452 Fax: 1-204-957-7568 email: jwiebe@linnet.ca http://www.linnet.ca