RE: MI Bug in Table > Update Column?
I think this bug was also in v5.5 as I have come across it before - but didn't have time to look closer - in my case it was data in a 'linked' excel spreadsheet. Martin -Original Message- From: Karl Kliparchuk [mailto:[EMAIL PROTECTED]] Sent: Friday, 30 June 2000 12:22 To: [EMAIL PROTECTED] Subject: MI Bug in Table > Update Column? I was showing some clients this function of MapInfo Pro v6.0. I have a table with 4 polygons in it representing catchments. I also have a temporary table that I had created from an SQL Select. I used some of the data aggregation functions to produce some statistics on population per catchment area. I wanted to use the Table > Update Column to transfer data from the SQL select table into the polygon table. I had an ID column in both tables, with numbers 1-4. When I tried to transfer the AVG pop value from the SQL table to the polygon table, the pop values were not put into the correct record. For example, polygon 1 should have an average of 44.8. Instead of getting that, I had a value of say 222.4. The data values are all there, but they are not in the proper order. polygon 1 has the pop data for polygon 3. I have never seen this happen before. I can send anyone that is interested the two files and the SQL query used for the data aggregation. I look forward to hearing from you. Karl -- Karl Kliparchuk, M.Sc. McElhanney Consulting Services Ltd. L100 - 780 Beatty Street Vancouver, BC Canada Tel (604) 683-8521 Email: [EMAIL PROTECTED] -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED] -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
MI: rotated ellipses and moving nodes of polygons
I am trying to find solutions for two MI problems: 1) drawing ellipses under an angle (that is, how to create rotated elliptical buffers). Apparently, MI can only create horizontal or vertical ellipses. 2) an algorithm/code for moving nodes of adjacent polygons (that is, I want to change the shape of adjacent polygons by offsetting their common nodes). I will summarise responses that arrive to me directly Thanks a lot to everybody who tries to help Regards Zoran ** Commonwealth Bank of Australia (ACN 123 123 124) ** -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
RE: MI Automatic Line Drawing
Phil, Try "Connect the dots" which should be under the Tools section on the http://www.directionsmag.com site Cheers Chris -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Saturday, 24 June 2000 6:52 To: Goodwin, Phil Cc: [EMAIL PROTECTED] Subject: Re: MI Automatic Line Drawing >I would like to create a file with from-to latitude/longitude points and >then have MapInfo draw lines between the dots. Is there a simple way to do >this? I have MapBasic but have little experience with it. Update your_table Set Obj = CreateLine(from_lon, from_lat, to_lon, to_lat) -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED] ** This message and any files transmitted with it are intended only for the addressee. This message may contain confidential or privileged information. If you are not the addressee of this message you must not read, copy, distribute this information or take an action in reliance on it. If you have received this message in error you are requested to immediately contact the sender or Parks Victoria at [EMAIL PROTECTED] and delete the original and any copies of this message and any files transmitted with it. The views expressed in this message are those of the individual sender, except where the sender has the authority and specifically states them to be the views of Parks Victoria. Parks Victoria accepts no liability for any damage caused in the transmission, receipt or opening of this message and any files transmitted with it. ** -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
RE: MI dispersion
Antoine This might not be the full solution your are looking for but it might be a work around. With VM use the "region to grid function" and set the "grid cell size" to correspond to a pre selected thematic range value (this is the logical part). Once the grid is created within the region you can convert the grid back to points. Obviously each required polygon will have to be selected, gridded and converted back to points. You will also have to do some testing to determine the required range values. I believe Vertical Mapper has a SDK kit. Regards Jacques Gélinas Cartographer GéosphèreGéomatique__http://www3.sympatico.ca/geosphere265 Chemin FreemanHull (Québec)J8Z 2B1819-773-4239 --- Does anybody know where i can find some code fragment (or algorithm) doing a logical dot dispersion in a polygon
MI Bug in Table > Update Column?
I was showing some clients this function of MapInfo Pro v6.0. I have a table with 4 polygons in it representing catchments. I also have a temporary table that I had created from an SQL Select. I used some of the data aggregation functions to produce some statistics on population per catchment area. I wanted to use the Table > Update Column to transfer data from the SQL select table into the polygon table. I had an ID column in both tables, with numbers 1-4. When I tried to transfer the AVG pop value from the SQL table to the polygon table, the pop values were not put into the correct record. For example, polygon 1 should have an average of 44.8. Instead of getting that, I had a value of say 222.4. The data values are all there, but they are not in the proper order. polygon 1 has the pop data for polygon 3. I have never seen this happen before. I can send anyone that is interested the two files and the SQL query used for the data aggregation. I look forward to hearing from you. Karl -- Karl Kliparchuk, M.Sc. McElhanney Consulting Services Ltd. L100 - 780 Beatty Street Vancouver, BC Canada Tel (604) 683-8521 Email: [EMAIL PROTECTED] -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
MI Raster quality is poor
Hi all, I am using BMP, TIF and JPG files as aerial backdrops to my maps. When I print these however using mapinfo the photo gets blotchy in a regular way. Very much inferior to the bit map being printed in another package such as the paint, corel or other. Why is it so? And what can I do to improve this as it is not good enough to publish. Gabor Vasarhelyi Environmental Resources Management Australia (ERM) Pty Ltd Ph. 9906 1666 Fax 9906 5375 While ERM has systems in place to encourage a virus free software environment, unfortunately the same cannot be said of the large number of organisations from which we receive electronically issued products. We therefore recommend that files be checked prior to use. While you can expect us to be careful, in view of the above factors, we cannot be liable for any loss or damage, corruption or distortion of electronically transmitted information, or for any changes made to this information during transferral or after receipt. -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
MI Layout Text and Frame Changes
I'm trying to create a little MapBASIC script in the MB window that will fetch the next record of a mappable file, zoom to the coord of the currently selected record and then modifies a layout so that the currently selected map window, text labels (the window title is a text variable that contains the name of the currently selected polygon)and browsers are updated. I'm having an awful time with updating objects in a layout window. I can create a whole new layout window and it will include the current data, but I can't seem to modify the current one to update the contents. I don't want to spawn a hundred layouts if I can help it. I'm working with Create Text and Create Frame statements that follow a Layout command. What I'd like to do is have the layout window active so that subsequent create text and create frame functions operate on current (and only) layout window, not create others. I've tried operating on the current layout window by getting the window handle of the layout window and specifying that as the "into Window" parameter of the Create Text statement to change the text, but that doesn't work. Ditto the Create Frame. Doesn't work: nothing appears at the right place in the layout window. I've tried other stuff, too, but no dice. Here's the code from the MB window I've been using. Create Text into window LayoutHandleID (variable for window handle) layoutmaptitle (string variable) (3.5,0.2764) (6.3972,0.5813) Font ("Arial",0,24,0) Anyone know how to make these changes to the titles and what not can be handled through a script that doesn't have to create a new layout window to create new text and frames? PS: I've got MapBASIC but haven't installed it, but could if that's the solution. Thanks, Tim Rood -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
RE: MI Labelling with concentration
Hi David, I can think of three and a half solutions for you which I think you'll like with varying degrees of happiness. First is to perform a SQL selection that will result in the aggregate column Count. Be sure to group them by the postcode and add a column count. This will result in a browser with the count of responses/records per postcode and the postcode, but no map. You'll need to save this query as a new table and then geocode that new table. It can then be labeled with the count column as needed or shaded or whatever you'd like. From my experience, if you've had problems with printing a large number of overlapping points, this will also handle the situation. Option 2 is to thematically shade the boundary with the count of the objects within the boundary. This is a range thematic map. In it you'll create a range thematic of the boundary table you want shaded (for instance the postcode boundary). In the field section of the Create Thematic Map 2 of 2 window, select join as the field. This will result in the update column for join window. Select the table with your points as the get value from table section, joining where appropriate. Then in the calculate box, calculate the count. This will shade your postal codes with the count of the objects in each code with a range. Option 2b is to complete the thematic map in option 2 and then select to label the boundary with the temporary column that the data is shaded with. This temp column will be shown as a selection in the label with drop down box of the label options window after you make the thematic map. Option 4 will let you see the spread of the points. For this try the MBX tool Disperse points. This will take the points at a particular location and randomly spread them out around their original location. Make sure you make a copy of the original table first though as should you not like what you see, you can't undo the work without making the table un-mappable and then regeocoding it. It works very nicely though to show a broader spread within the boundary. I've tried to think of a way to label it with the number of objects at a location with your table as is, but can't seem to come up with a solution other than these 3.5. I hope that one of them suits your needs and good luck! Jennifer Duncan MBS, Inc./Memorial Business Systems Inc. www.mbs-intl.com 615-373-0110 / 800-844-4447 fax 615-370-4901 -Original Message- From: David Eagle [SMTP:[EMAIL PROTECTED]] Sent: Thursday, June 29, 2000 12:38 PM To: [EMAIL PROTECTED] Subject:MI Labelling with concentration Mappers, I have geocoded a number of responses to a survey by their postcodes (it would have been nice to use OS ADDRESSPOINT data but the addresses collected are too much of a mess to get any decent hit rate). As a result of this I now have in most cases one visible point on the map which actually represents between 5 and 25 respondents living under that postcode. Is it possible to label each point visible with an 'expression' that will show the concentration of respondents at each point. Sorry if this isn't very clear but its difficult to explain... Thanks, Dave _ David A. Eagle WS Atkins Consultants - East Anglia Wellbrook Court, Girton Road, Cambridge, CB3 0NA. Direct Dial Tel: (01223) 814090, Fax: (01223) 277529 E-Mail: [EMAIL PROTECTED] -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED] -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
MI Volume in MapInfo?
Hi. I am a new MapInfo user. We are using MapInfo to portray information about airspace characteristics, (flights/week, time in sector, etc). It appears to me that MapInfo is limited to two-dimensional display even the terrain mappers are just presenting the surface of the objects... a folded two-dimensional surface...you cannot represent data that lives "inside" a mountain. It would be nice if we could represent all three dimensions of space, to show flight tracks with altitude, as well as lat/long. Can anyone offer any advice of pointers to software that would help with this? Tnx in advance, Gerald begin:vcard n:Shapiro;Gerald tel;fax:(703) 883-1911 tel;work:(703) 883-5256 x-mozilla-html:FALSE org:MITRE/CAASD;Airspace Design version:2.1 email;internet:[EMAIL PROTECTED] title:Mult-Disc Sys Dev Eng, Lead adr;quoted-printable:;;MS W196=0D=0A1820 Dolley Madison Blvd.;McLean;VA;22102; fn:Gerald Shapiro end:vcard
MI Multiple Versions
Hello all, Does anyone know whether there would be any problems having both 4.52 and 5.5 installed on the same harddrive? Is there a WAY TO ENSURE SAVED USER SETUPS ARE THE SAME ON BOTH VERSIONS? application/ms-tnef
Re: Re: MI Change in Select Statement
Dima says: > Another SQL processor allows this. I have just made the query in Access: > > SELECT Count(sub_category_subscriber.sub_category_id) > AS CountOfsub_category_id > FROM sub_category_subscriber > GROUP BY sub_category_subscriber.subscriber_id; > > As you see, records are grouped by subscriber_id, but it does not > present in the list of selected columns. > > This is another question if such SQL makes sense, but it is allowed. And Daniel says: > I just tried this in Microsoft Visual FoxPro ver. 6 > > select sum(hw_dist), lastname, firstname from peopletable into cursor > cc order by id group by zipcd > > It worked just fine. The table is a native DBF file, but it would do > the same thing with a local view of an SQL table. To which our engineer responds: I misspoke on this one. You can GROUP BY columns not in the projection list. What you can't do now is this: when you have both a GROUP BY and an ORDER BY, you cannot ORDER BY things not in the projection list. I know Access and Oracle don't allow this; I doubt that FoxPro does, either. -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
Vedr: MI Carriage returns, extra!
Hi David try this update in the mapbasic window (it has to be on one line). It will remove one carriage return evrye time you run it. Update Mytab set MyTxtColm = Left$(MyTxtColm, Instr(1, MyTxtColm, Chr$(10)) - 1 ) & Right$(MyTxtColm, len(MyTxtColm) - Instr(1, MyTxtColm, Chr$(10)) ) Peter "David Eagle" <[EMAIL PROTECTED]> - 2000 06 29 17:06:38 Til:"Dany Bouchard" <[EMAIL PROTECTED]> cc: [EMAIL PROTECTED] (bcc: Peter Laulund/MI/KMS) Vedrørende:MI Carriage returns, extra! I have a related question...Sorry to intrude Dany, I have a table full of data, one column of which is full of carriage returns, represented by a square symbol. Does anyone know how to delete them, either in MI or in Excel. They are more than an annoyance... Cheers, Dave On 29 Jun 00, at 10:20, Dany Bouchard wrote: This has to be simple ! I am just trying to figure out if a text object textstring (returned by ObjectInfo(obj, OBJ_INFO_TEXTSTRING) has carriage returns. Is there an easy way aside from looping through all characters and checking for carriage returns by converting each character using ASC() ? Thanks in advance ! Salutations. Dany Bouchard DBx Geomatics 38 de l'Orbite Hull, Québec Canada J9A 3C7 Téléphone/Telephone: 819.743.3870 Télécopieur/Fax: 819.775.3264 Courrier électronique/Email: [EMAIL PROTECTED] Page Web/Web site: http://www.dbxgeomatics.com/home.asp Vitrine technologique SVG / SVG Technology Preview: http://www.dbxgeomatics.com/svg.asp -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED] -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
Re: MI MapInfo Fonts -- A Savage Journey into Pointless Pointsizes - REVISITED
Bill, I already took a look at it ! This is quite something ! Holy cow it requires a lot to control text renrering ! I am not sure that I can see from your program how I can read existing MapInfo Text objects and get the size of rotated text with your WIN API functions. How would you do it ? Read the MBR of the text object and then create a text object with WINAPI and check it's size ? I guess the approach to take is to try to "clone" the MapInfo text object with your WinAPI calls. Again I am not sure of the way to accomplish this. And then would that be working OK for most fonts, projections, etc. ? Thanks ! That goose is a tough one ! A semi-frustrated hunter, Dany - Original Message - From: "Bill Thoen" <[EMAIL PROTECTED]> To: "Dany Bouchard" <[EMAIL PROTECTED]> Sent: Thursday, June 29, 2000 12:22 PM Subject: Re: MI MapInfo Fonts -- A Savage Journey into Pointless Pointsizes - REVISITED > You might try looking at my TextDemo.zip shareware at > http://www.directionsmag.com/tools/default.asp?a=file&id=240. It > journeys deep into the Windows API calls to winkle out the font > info. > > - Bill Thoen > > > > Dany Bouchard wrote: > > > > Hello all. > > > > I am (too !) trying to read the size of text objects in a > > MapInfo mapper window with difficulties. > > > > Following Bill Thoen's approach here's what I am doing: > > > > First I callObjectGeography () to retrieve the minimum bounding > > rectangle (MBR) of the text object. > > I then take the vertical distance between the min-Y and max-Y > > using the distance () function in > > inches, and divide by the map scale found in MapperInfo > > (FrontWindow(), MAPPER_INFO_SCALE) (after setting distance > > units to > > inches). > > I get some sort of approximate text size in inches which I then > > multiply by 72 to get points. > > Actually, this is not working two badly, since I am more > > looking for consistency over exact sizes. > > > > As expected, trouble begins when you try reading text with an > > Angle<>0. > > Has anyone come-up with a method that would give an > > approximation of the text size provided you have the MBR and > > angle (and text string lenght if needed) ? I have tryed quickly > > with Trig functions but could not figure it out. > > > > Thanks in advance for anybody helping chasing that goose ! > > I will sum. > > > > Dany Bouchard > > DBx Geomatics > > 38 de l'Orbite > > Hull, Québec > > Canada > > J9A 3C7 > > Téléphone/Telephone: 819.743.3870 > > Télécopieur/Fax: 819.775.3264 > > Courrier électronique/Email: [EMAIL PROTECTED] > > Page Web/Web site: http://www.dbxgeomatics.com/home.asp > > Vitrine technologique SVG / SVG Technology Preview: > > http://www.dbxgeomatics.com/svg.asp > -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
RE: MI Mapbasic - Reading if text object has carriage returns
this is more ellegant, and it don't use the GoTo command Declare Function NumLine(byval s as string) as smallint Function NumLine(byval s as string) as smallint dim i, pos as smallint pos = Instr(1,s, chr$(10)) do until pos = 0 i = i + 1 pos = Instr(pos + 1, s, chr$(10)) loop numLine = i + 1 end Function Peter "Jacques Paris" <[EMAIL PROTECTED]> - 2000 06 29 17:08:53 Til:"Dany Bouchard" <[EMAIL PROTECTED]>, [EMAIL PROTECTED] cc: (bcc: Peter Laulund/MI/KMS) Vedrørende:RE: MI Mapbasic - Reading if text object has carriage returns That one was easy and I was already for it. Numlin returns the number of lines (carriage returns +1) in the a string Jacques Paris [EMAIL PROTECTED] Paris PC Consult (mainly MapInfo app.) www.total.net/~rparis/gisproducts.htm declare function numlin(byval a as string) as smallint function numlin(byval a as string) as smallint dim pos, pos1, k as smallint numlin=1 k=1 pos=1 boucle: pos1=instr(pos,a,chr$(10)) if pos1=0 then exit function end if k=k+1 numlin=k pos=pos1+1 goto boucle end function -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Dany Bouchard Sent: June 29, 2000 10:21 AM To: [EMAIL PROTECTED] Subject: MI Mapbasic - Reading if text object has carriage returns This has to be simple ! I am just trying to figure out if a text object textstring (returned by ObjectInfo(obj, OBJ_INFO_TEXTSTRING) has carriage returns. Is there an easy way aside from looping through all characters and checking for carriage returns by converting each character using ASC() ? Thanks in advance ! Salutations. Dany Bouchard DBx Geomatics 38 de l'Orbite Hull, Québec Canada J9A 3C7 Téléphone/Telephone: 819.743.3870 Télécopieur/Fax: 819.775.3264 Courrier électronique/Email: [EMAIL PROTECTED] Page Web/Web site: http://www.dbxgeomatics.com/home.asp Vitrine technologique SVG / SVG Technology Preview: http://www.dbxgeomatics.com/svg.asp That one was easy and I was already for it. Numlin returns the number of lines (carriage returns +1) in the a string Jacques Paris [EMAIL PROTECTED] Paris PC Consult (mainly MapInfo app.) www.total.net/~rparis/gisproducts.htm declare function numlin(byval a as string) as smallint function numlin(byval a as string) as smallint dim pos, pos1, k as smallint numlin=1 k=1 pos=1 boucle: pos1=instr(pos,a,chr$(10)) if pos1=0 then exit function end if k=k+1 numlin=k pos=pos1+1 goto boucle end function -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Dany BouchardSent: June 29, 2000 10:21 AMTo: [EMAIL PROTECTED]Subject: MI Mapbasic - Reading if text object has carriage returns This has to be simple ! I am just trying to figure out if a text object textstring (returned by ObjectInfo(obj, OBJ_INFO_TEXTSTRING) has carriage returns. Is there an easy way aside from looping through all characters and checking for carriage returns by converting each character using ASC() ? Thanks in advance ! Salutations. Dany BouchardDBx Geomatics38 de l'OrbiteHull, QuébecCanadaJ9A 3C7Téléphone/Telephone: 819.743.3870Télécopieur/Fax: 819.775.3264Courrier électronique/Email: [EMAIL PROTECTED]Page Web/Web site: http://www.dbxgeomatics.com/home.aspVitrine technologique SVG / SVG Technology Preview: http://www.dbxgeomatics.com/svg.asp
MI Refreshing Queries with ODBC tables
Hello Everyone, I have a client who asked a question about MapInfo and ODBC tables. He has a connected ODBC table that does queries with. His problem is that when he changes something in the table, the numbers/objects in the query do not refresh. The tables refresh but he wants the queries to refresh also. He said the only way he could get this to work is if he closed down the workspace and restarted it. He was wondering if there was a way to refresh the querieshe also told me Microsoft Access can do this so he figures MapInfo can do this. Is it possible to get an automatic refresh with the ODBC tables and the queries? (I hope I explained this good enough!) Any help would be appreciated!!! Jeff HutzulApplications TechnologistKanotech Information SystemsPh: 306-721-2362
MI Carriage returns, extra!
I have a related question...Sorry to intrude Dany, I have a table full of data, one column of which is full of carriage returns, represented by a square symbol. Does anyone know how to delete them, either in MI or in Excel. They are more than an annoyance... Cheers, Dave On 29 Jun 00, at 10:20, Dany Bouchard wrote: This has to be simple ! I am just trying to figure out if a text object textstring (returned by ObjectInfo(obj, OBJ_INFO_TEXTSTRING) has carriage returns. Is there an easy way aside from looping through all characters and checking for carriage returns by converting each character using ASC() ? Thanks in advance ! Salutations. Dany Bouchard DBx Geomatics 38 de l'Orbite Hull, Québec Canada J9A 3C7 Téléphone/Telephone: 819.743.3870 Télécopieur/Fax: 819.775.3264 Courrier électronique/Email: [EMAIL PROTECTED] Page Web/Web site: http://www.dbxgeomatics.com/home.asp Vitrine technologique SVG / SVG Technology Preview: http://www.dbxgeomatics.com/svg.asp -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
Re: MI Radius Question
The answer depends on the form in which your data are assembled. I'll assume these are selections from the same table; the first, TWOMILE, is all the people within 2 miles of some location, and the second, FIVEMILE, is everyone within 5 miles of that location. In this case FIVEMILE also contains all those in TWOMILE. You will also need to have a unique identifying field in both, and let's call it something original, like 'Id'. Then the SQL select statement is: select * from FIVEMILE where Id not in (select Id from TWOMILE) into THREEMILE The result, THREEMILE, contains all those within 5 and beyond 2 miles of your site. The unique identifying field can be a number or a string; the only requirement is that no two records in your data have the same value for it. - Bill Thoen Erin OHara wrote: > > I have a radius of 2 miles and all the volunteers within that radius. I > also have a radius of 5 miles and all the volunteers within that 5 mile > radius. What I want is a list of the volunteers that live in the 3 miles > between. In other words those people that are in the 5 mile group minus the > people in the 2 mile group. > > Ideas? Anyone? Would be very greatful and might even write in complete > sentences if I get the answer. -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
RE: MI Mapbasic - Reading if text object has carriage returns
That one was easy and I was already for it. Numlin returns the number of lines (carriage returns +1) in the a string Jacques Paris [EMAIL PROTECTED] Paris PC Consult (mainly MapInfo app.) www.total.net/~rparis/gisproducts.htm declare function numlin(byval a as string) as smallint function numlin(byval a as string) as smallint dim pos, pos1, k as smallint numlin=1 k=1 pos=1 boucle: pos1=instr(pos,a,chr$(10)) if pos1=0 then exit function end if k=k+1 numlin=k pos=pos1+1 goto boucle end function -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Dany BouchardSent: June 29, 2000 10:21 AMTo: [EMAIL PROTECTED]Subject: MI Mapbasic - Reading if text object has carriage returns This has to be simple ! I am just trying to figure out if a text object textstring (returned by ObjectInfo(obj, OBJ_INFO_TEXTSTRING) has carriage returns. Is there an easy way aside from looping through all characters and checking for carriage returns by converting each character using ASC() ? Thanks in advance ! Salutations. Dany BouchardDBx Geomatics38 de l'OrbiteHull, QuébecCanadaJ9A 3C7Téléphone/Telephone: 819.743.3870Télécopieur/Fax: 819.775.3264Courrier électronique/Email: [EMAIL PROTECTED]Page Web/Web site: http://www.dbxgeomatics.com/home.aspVitrine technologique SVG / SVG Technology Preview: http://www.dbxgeomatics.com/svg.asp
Re: MI MapInfo Fonts -- A Savage Journey into Pointless Pointsizes - REVISITED
This is a good idea ! I just try it but damn it, when I change the angle of the text using Alter Object Geography, I discovered that the MBR of the text does not change ! Stuck again. Thanks again but we need to think more about this one ! Dany - Original Message - From: [EMAIL PROTECTED] To: Dany Bouchard Sent: Thursday, June 29, 2000 11:03 AM Subject: Vedr: MI MapInfo Fonts -- A Savage Journey into Pointless Pointsizes - REVISITED Hi Danyhave you tryed to Alter the angle off the text to 0 before you get the MBRAlter Object MyTextVar Geography, obj_geo_textangle, 0Peter LaulundNational Survey and cadastre, DenmarkNB remember that the height of the text normaly is just 60% of the MBRheight"Dany Bouchard" <[EMAIL PROTECTED]> - 2000 06 29 15:14:13Til: [EMAIL PROTECTED]cc: (bcc: Peter Laulund/MI/KMS)Vedrørende: MI MapInfo Fonts -- A Savage Journey into Pointless Pointsizes - REVISITEDHello all.I am (too !) trying to read the size of text objects in a MapInfo mapperwindow with difficulties.Following Bill Thoen's approach here's what I am doing:First I callObjectGeography () to retrieve the minimum boundingrectangle (MBR) of the text object.I then take the vertical distance between the min-Y and max-Y using thedistance () function ininches, and divide by the map scale found in MapperInfo(FrontWindow(), MAPPER_INFO_SCALE) (after setting distance units toinches).I get some sort of approximate text size in inches which I then multiply by72 to get points.Actually, this is not working two badly, since I am more looking forconsistency over exact sizes.As expected, trouble begins when you try reading text with an Angle<>0.Has anyone come-up with a method that would give an approximation of thetext size provided you have the MBR and angle (and text string lenght ifneeded) ? I have tryed quickly with Trig functions but could not figure itout.Thanks in advance for anybody helping chasing that goose !I will sum.Dany BouchardDBx Geomatics38 de l'OrbiteHull, QuébecCanadaJ9A 3C7Téléphone/Telephone: 819.743.3870Télécopieur/Fax: 819.775.3264Courrier électronique/Email: [EMAIL PROTECTED]Page Web/Web site: http://www.dbxgeomatics.com/home.aspVitrine technologique SVG / SVG Technology Preview:http://www.dbxgeomatics.com/svg.asp
MI Labelling with concentration
Mappers, I have geocoded a number of responses to a survey by their postcodes (it would have been nice to use OS ADDRESSPOINT data but the addresses collected are too much of a mess to get any decent hit rate). As a result of this I now have in most cases one visible point on the map which actually represents between 5 and 25 respondents living under that postcode. Is it possible to label each point visible with an 'expression' that will show the concentration of respondents at each point. Sorry if this isn't very clear but its difficult to explain... Thanks, Dave _ David A. Eagle WS Atkins Consultants - East Anglia Wellbrook Court, Girton Road, Cambridge, CB3 0NA. Direct Dial Tel: (01223) 814090, Fax: (01223) 277529 E-Mail: [EMAIL PROTECTED] -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
MI dispersion
Does anybody know where i can find some code fragment (or algorithm) doing a logical dot dispersion in a polygon ? ___ ||//Antoine Gilbert|| // [EMAIL PROTECTED]|| // #ICQ 9737371|| \\|| \\Le Groupe KOREM Inc.||\\ http://www.korem.com___
Vedr: MI Mapbasic - Reading if text object has carriage returns
Hi Dany Try using the Instr() function if instr(1,myString,Chr$(10)) > 0 then you have a Carriage return Peter Laulund National Survey and Cadastre, Denmark "Dany Bouchard" <[EMAIL PROTECTED]> - 2000 06 29 15:20:46 Til:[EMAIL PROTECTED] cc: (bcc: Peter Laulund/MI/KMS) Vedrørende:MI Mapbasic - Reading if text object has carriage returns This has to be simple ! I am just trying to figure out if a text object textstring (returned by ObjectInfo(obj, OBJ_INFO_TEXTSTRING) has carriage returns. Is there an easy way aside from looping through all characters and checking for carriage returns by converting each character using ASC() ? Thanks in advance ! Salutations. Dany Bouchard DBx Geomatics 38 de l'Orbite Hull, Québec Canada J9A 3C7 Téléphone/Telephone: 819.743.3870 Télécopieur/Fax: 819.775.3264 Courrier électronique/Email: [EMAIL PROTECTED] Page Web/Web site: http://www.dbxgeomatics.com/home.asp Vitrine technologique SVG / SVG Technology Preview: http://www.dbxgeomatics.com/svg.asp This has to be simple ! I am just trying to figure out if a text object textstring (returned by ObjectInfo(obj, OBJ_INFO_TEXTSTRING) has carriage returns. Is there an easy way aside from looping through all characters and checking for carriage returns by converting each character using ASC() ? Thanks in advance ! Salutations. Dany BouchardDBx Geomatics38 de l'OrbiteHull, QuébecCanadaJ9A 3C7Téléphone/Telephone: 819.743.3870Télécopieur/Fax: 819.775.3264Courrier électronique/Email: [EMAIL PROTECTED]Page Web/Web site: http://www.dbxgeomatics.com/home.aspVitrine technologique SVG / SVG Technology Preview: http://www.dbxgeomatics.com/svg.asp
MI Mapbasic - Reading if text object has carriage returns
This has to be simple ! I am just trying to figure out if a text object textstring (returned by ObjectInfo(obj, OBJ_INFO_TEXTSTRING) has carriage returns. Is there an easy way aside from looping through all characters and checking for carriage returns by converting each character using ASC() ? Thanks in advance ! Salutations. Dany BouchardDBx Geomatics38 de l'OrbiteHull, QuébecCanadaJ9A 3C7Téléphone/Telephone: 819.743.3870Télécopieur/Fax: 819.775.3264Courrier électronique/Email: [EMAIL PROTECTED]Page Web/Web site: http://www.dbxgeomatics.com/home.aspVitrine technologique SVG / SVG Technology Preview: http://www.dbxgeomatics.com/svg.asp
MI MapInfo Fonts -- A Savage Journey into Pointless Pointsizes - REVISITED
Hello all. I am (too !) trying to read the size of text objects in a MapInfo mapper window with difficulties. Following Bill Thoen's approach here's what I am doing: First I callObjectGeography () to retrieve the minimum boundingrectangle (MBR) of the text object. I then take the vertical distance between the min-Y and max-Y using the distance () function ininches, and divide by the map scale found in MapperInfo(FrontWindow(), MAPPER_INFO_SCALE) (after setting distance units toinches). I get some sort of approximate text size in inches which I then multiply by 72 to get points. Actually, this is not working two badly, since I am more looking for consistency over exact sizes. As expected, trouble begins when you try reading text with an Angle<>0. Has anyone come-up with a method that would give an approximation of the text size provided you have the MBR and angle (and text string lenght if needed) ? I have tryed quickly with Trig functions but could not figure it out. Thanks in advance for anybody helping chasing that goose ! I will sum. Dany BouchardDBx Geomatics38 de l'OrbiteHull, QuébecCanadaJ9A 3C7Téléphone/Telephone: 819.743.3870Télécopieur/Fax: 819.775.3264Courrier électronique/Email: [EMAIL PROTECTED]Page Web/Web site: http://www.dbxgeomatics.com/home.aspVitrine technologique SVG / SVG Technology Preview: http://www.dbxgeomatics.com/svg.asp
MI unsubscribe
Title: unsubscribe unsubscribe
RE: MI Radius Question
Hi Erin, You can make your 5 mile circle into a donut and use that ring to select the set of points you need. Make the table with the 5mi circle editable, then select that object and do Object>Set Target. Then select the 2 mile circle and do Object>Erase. Now you have the 2-5 mile donut you need and can do a point-in-poly tool selection. That operation is a permanent edit assuming you don't need the full 5mi circle anymore on its own. Alternatively you could select points within the 5mi and NOT within the 2mi via SQL. Will Mitchell Mitchell Geographics, Inc. 496 Congress Street Portland, Maine 04101 Ph 207.879.7769 Fx 207.253.5756 www.mitchellgeo.com -Original Message- From: Erin OHara [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, June 28, 2000 5:41 PM To: C Subject:MI Radius Question I have a radius of 2 miles and all the volunteers within that radius. I also have a radius of 5 miles and all the volunteers within that 5 mile radius. What I want is a list of the volunteers that live in the 3 miles between. In other words those people that are in the 5 mile group minus the people in the 2 mile group. Ideas? Anyone? Would be very greatful and might even write in complete sentences if I get the answer. -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED] -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
MI INCREASE BUSINESS SALES!
HELLO: THIS IS AN ADVERTISEMENT FOR 50 MILLION E-MAIL ADDRESSES ON CD-ROM. IF YOU HAVE NO INTEREST IN THIS INFORMATION, PLEASE CLICK DELETE. THANK YOU. Dear Consumer, Increase your business sales! How?? By targeting millions of buyers via e-mail !! We are offering over 50 million FRESH, DELIVERABLE, e-mail addresses on CD-ROM. The cd-rom includes targeted addresses, such as business opportuinty seekers, sports buffs, mlm, impulsive buyers and investors. The cd-rom also includes general internet, United States, United kingdom, mixed domains, International, Canadian, earthlink, aol, compuserve, misc and much more. The list's are divided into groups and are compressed. This will allow you to uses the names right off the cd. ORDER IN THE NEXT 7 DAYS AND RECEIVE AN ADDITIONAL CD-ROM WITH MILLIONS OF DELIVERABLE E-MAIL ADDRESSES FREE !! The bonus alone is worth ACTING NOW! The cd-rom contains such address as general internet, msn, aol, compuserve, delphi and much more. ACT NOW AND RECEIVE ALL THIS FOR AN UNBELIEVEABLE LOW, LOW PRICE OF ONLY $35.95 ! SIMPLY SEND $35.95, check or money order, PAYABLE TO: R GOODWIN SHIP TO: MARKETING AND MORE PO BOX 1862, SANTA ROSA BEACH, FL 32459 If we have reached you in error, and you would like to be removed [EMAIL PROTECTED] -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
MI Simple Query solved.
Thanks to Jose Luis, Russell, Keith, Ahmet and Jo for solving my simple problem. Simply 1. Make sure you have a column to store the information. You may need to add a column (using table maintenance) on the Coded Table to do this, make sure it has enough characters to hold the descriptions you're using. 2. Table > Update Column Table: Table you want to add the description to. Column: where you want the info. (This often defaults back to "temporary new column", so double check it) Get Value From: Table with the Description Join - Where coded table.column(comF7) = lookup table.column(comF7) Calculate: Value Of: Description(swimming pool) DOUBLE CHECK THE COLUMN... 3. Save the table. Thanks again Matt -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
RE: MI Routing Application Servers?
Dear John, You may be interested to know of a reference site using RouteXNetServer. Access www.madaboutbikes.com then go to "toolbox" to register your details, continue and click on "TravelMate" then "next". This is a UK based site so only UK routes apply. I'll keep you posted of any further reference sites as they become available. Best Regards, Kirsten Burrows Channel Manager MapCentric Ltd www.mapcentric.co.uk -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Millennium Maps Sent: 27 June 2000 16:25 To: [EMAIL PROTECTED] Subject: MI Routing Application Servers? I'm looking for a routing component (server) to be used in conjunction with MapXreme NT to deliver detailed journey directions over the internet (like MapQuest/MapBlast). Does anyone know of any server software (must be multi-user/multi-threaded) that is currently available? I know of RouteXNetServer from MapCentric and Routing J Server from MapInfo but are there any others? Does anyone have any views/experience on integrating these software packages with MapXtreme? Regards, John Miller Jnr. Millennium Mappings Inc. -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED] -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
RE: MI Nearest Neighbor Analysis
Hi Chiu If you're looking for Voronoi ... here some feedback: we compared TRIANGULATOR as suggested by Roeland van der Spek and VM as suggested by James Harvie on a dataset with over 200'000 points with the result that to my surprise TRIANGULATOR did the job perfectly and incredibly fast and VM 2.1 and 2.5 didn't do the job at all (cryptic error message) ... We went down to 50'000, tried, in VM, even to aggregate the points beforehand, with the same result ... I hope that VM 2.6 will have solved this and other problems, as it is basically a well designed and powerful product I really like ... *** REPLY SEPARATOR *** On 28.06.2000 at 15:18 James Harvie wrote: >Chiu, > >Vertical Mapper has a natural neighbour analysis tool which generates a >voronoi diagram (theissen polygons) from which density can be measured. The >measure of density is based upon the area of each point's polygon where a >small area indicates high density and a large area indicates lower density. > >James Harvie >Vertical Mapper Product Manager >Northwood Technologies Inc. >43 Auriga Drive, K2E 7Y8 >Nepean, Ontario, Canada >613-224-2020 > > >-Original Message- >From: [EMAIL PROTECTED] >[mailto:[EMAIL PROTECTED]]On Behalf Of Chiu Luk >Sent: Tuesday, June 27, 2000 3:52 PM >To: [EMAIL PROTECTED] >Subject: MI Nearest Neighbor Analysis > > >Hi everybody: > >Does anyone has ever written (or know who has written) a MapInfo routine on >Nearest Neighbor Analysis to measure the extent of point clustering? Any >hint to help me locate such resources is much appreciated. Thanks. > > >Chiu LUK >Policy & Research Section >Urban Development Services >City of Toronto > >Correspondence: >Chiu Luk >Urban Development Services >East District Office, City of Toronto >150 Borough Drive >Scarborough Civic Centre >Toronto, ON M1P 4N7 > >Phone: (416) 396-7031 >Fax: (416) 396-4265 >E-mail: [EMAIL PROTECTED] > > >-- >To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put >"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED] > > >-- >To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put >"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED] !!! See our new Mapping Server under http://www.mapserver.ch - Mit freundlichen Gruessen / Kind Regards Flavio Hendry- mailto:[EMAIL PROTECTED] TYDAC AG - http://www.tydac.ch Geographic Information Solutions Buristrasse 23 -- CH-3006 Bern Tel +41 (0)31 368 0180 - Fax +41 (0)31 368 1860 - MAPINFO Strategic Partner - PCI Reseller - FME Distributor - -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]