Hello Trey, The min/max I was referring to, I'm not clear if it's the same as Pierre intended though, was to place the min/max respectivly into individual point objects which represent intersections or cross streets. If I understood him correctly, he only wanted a label to appear at each end of the street.
As far as showing the high and low or min/max, I once used the same expression that you suggest as well, till I relized it doesn't account for a street which has a 0 value for one side or the other: Fromleft=0 toleft=0 Fromright=2 toright=10 The min/max expression will label the range as 0-10, whereas the range is 2-10 The only way I could get around this was first, I added a "High" and "Low" column to my streets table (as found in a Telco MSAG) export to mif, changing the .mid to .csv I used Excel to run a minimum greater than zero - maximum update on the high/low column, then brought backinto Mapinfo. But this is done better with a Mapinfo Expression further down. For Microsoft Excel: Assuming: A2=Street B2=FromLeft C2=ToLeft D2=FromRight E2=ToRight =IF(B2=0,D2,(IF(D2=0,B2,(MIN(B2,D2))))) Explanation: If B2 equals 0, return D2 if not 0 return the following formula result: If D2 equals 0, return B2, if not, return the minimum of the two numbers B2 and D2 Simon O'Keefe also provided an expression for Mapinfo SQL which would be far more convienent: update [street table set LOW = left$(str$(minimum(FROMLEFT,FROMRIGHT)),99*int(FROMLEFT<>0 and FROMRIGHT<>0)) + left$(str$(maximum(FROMLEFT,FROMRIGHT)),99*int(FROMLEFT=0 or FROMRIGHT=0)) Dave -----Original Message----- From: Trey Pattillo [mailto:[EMAIL PROTECTED] Sent: Saturday, December 11, 2004 5:53 PM To: [EMAIL PROTECTED] Subject: Re: MI-L Labelling streets with house numbers getting the min/max is easy here's a nice label I do 1) set label for dead center of the line 2) use "expression label" 3) minimum(fromleft,fromright)+"-"+maximum(toleft,toright)+chr$(10)+street David Reid wrote: > Not sure what you're after here. > > David Haycraft of Information Analysis Associates > http://members.iinet.net.au/~haycraft/iaa/ has a very useful utility for > placing 'house numbers' as text object, adjacent to a street line and based > on the From To fields. > > Or are you referring to labelling the address of "cross streets" or > intersections? That is to say, if the low address range is 100, that label > woould be placed on that end of the street, if the ending address of the > range is 199, that label would be placed on that end or intersection? > > I only know two ways of doing that, one being manually (no fun in that) the > other would be to create points for all your intersections, setting the > object attribute as "N" and labelling those. Getting the low and high number > of the address range can be tricky and agrevating though. > > David Reid > > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Saturday, December 11, 2004 3:45 PM > To: [EMAIL PROTECTED] > Subject: MI-L Labelling streets with house numbers > > > > I would like to show house numbers next to streets, that is 4 numbers: the > representation would be near the left end of each street (2, one up and one > down) and the near the right end. > Standard labeling in MapInfo is not adequate: only one field can be used and > > placement is near the street middlepoint. > Any hint before I generate 4 sets of (invisibl) points with labels ? > Pierre > > --- > Incoming mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.804 / Virus Database: 546 - Release Date: 11/30/2004 > > > --- > Outgoing mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.804 / Virus Database: 546 - Release Date: 11/30/2004 > > > > --------------------------------------------------------------------- > List hosting provided by Directions Magazine | www.directionsmag.com | > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > Message number: 14503 > > > > -- Trey Pattillo [EMAIL PROTECTED] www.wap3.com N27.799013 W-97.665322 | If you receive an email that says something like | 'Send this to everyone you know,' | pretend you don't know me. --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 14504 --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.804 / Virus Database: 546 - Release Date: 11/30/2004 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.804 / Virus Database: 546 - Release Date: 11/30/2004 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 14505
