RE: [MI-L] Feature Wish List
How about a more Excel like browser window - sort the values simpky by clicking in the header. - move around with the arrow keys - select mulitple cells across rows and records - ... More or less what some of us already have seen in the Grande Project. Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tim Rideout Sent: Wednesday, October 25, 2006 12:36 PM To: 'Mapinfo-L' Subject: RE: [MI-L] Feature Wish List I think the text labelling and the layouts require upgrading. Neither has been touched for years and they have slipped behind. For example you always seem to have to have a bit of a fight with the frames to get the map at the correct display scale, and the legends often don't display correctly. On the label front some more intelligence about fitting the names in (see MAPublisher Version 7 for example which now has the option to fit the label within the polygon or onto the base line by adjusting the font and letter spacing), and proper curved text. Regards Tim Dr Tim Rideout Director Visit XYZ at the Frankfurt Book Fair, Oct 4 - 8th 2006, Intergeo Munich Oct 10-13th 2006 or IMTA World in Singapore, Nov 2006. The XYZ Digital Map Company Unit 9 Phase 2 Hardengreen Business Park Dalhousie Road Dalkeith Scotland EH22 3NX Tel +44 131 454 0426 Fax +44 131 454 0443 Mobile + 44 7766 825937 E-mail [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Reid Sent: 25 October 2006 07:49 To: 'Mapinfo-L' Subject: Re: [MI-L] Feature Wish List I've been watching the Feature... thread and don't recall this one little item... That is to add the [IF] functionality to SQL capabilities of the Query and Label builders Ex: IF (FEATURE LIKE Mapinfo adds IF and other functionality and fixes), Print(Happy Mapinfo Customer +chr$(10)+ Happily Upgrades more often) Else Print(Continue to just make do with the old version you're running) Dave ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] MI: Style Override Bug
Hi Lars, You are right that this might be considered a WAD, sounds better than a BUG anyway ;-) But saving not used settings is exactly what the workspace does, also when it can give the user problems. An example is the label settings for at layer where auto label is turned off. If the user chooses to rename the first text column of a table, the workspace will crash because the unused setting for labels is stored in the workspace. And you are right, it should be pretty easy to save this setting to the workspace ... Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Lars I. Nielsen (GisPro) Sent: Saturday, October 21, 2006 11:29 AM To: mapinfo-l@lists.directionsmag.com Subject: Re: [MI-L] MI: Style Override Bug Well, it's debatable whether it's a bug or a wad. A workspace is a macro to rebuild a specific setup. Are unused settings part of such a setup ? Yes and no, imho, it's unclear where the dividing line is. But it would be nice to have a workspace remember style override settings, even if unused, especially since it wouldn't change the end result one bit, and would be extremely simple to implement (just output them!). Well, with MIPro.COM apparently again in the front seat, maybe a feature wish list is relevant once again ? Best regards / Med venlig hilsen Lars I. Nielsen GisPro Jacques Paris wrote: It was for sure part of version 7.0 Jacques Paris -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Peter Horsbøll Møller Sent: 20 octobre 2006 05:42 To: Jaromir Svasta; mapinfo-l@lists.directionsmag.com Subject: RE: [MI-L] MI: Style Override Bug Jaromir, I know for sure that this bug has already been reported and registered. I reported it last week - and also some years ago... Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct+45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail[EMAIL PROTECTED] http://www.cowi.dk/gis -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jaromir Svasta Sent: Friday, October 20, 2006 10:43 AM To: mapinfo-l@lists.directionsmag.com Subject: [MI-L] MI: Style Override Bug Hi listers, I would like to report a bug in MI (v7.8): The checking of the style override for a map layer is not preserved in workspaces for layers made temporarily invisible. To reproduce this behaviour, check the style override checkbox for a map layer, then make the layer invisible by switching the visibility checkbox off, save the workspace, close all and reopen the workspace. After switching the visibility of the layer on again, look at the style override checkbox in the display options - you will find it unchecked. The problem may seem petty, but in my work I often come into situations that requires me to switch this checkbox back on hundred times a day. Quite painful! -- Jaromir SVASTA Hydrogeologist Geological Survey of Slovak Republic Mlynska dolina 1 817 04 Bratislava Slovak Republic Tel:+421 2 59375326 Mobile: +421 908783589 Fax:+421 2 54771940 ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] SV: Distance calc mbx
Which version of MapInfo are you using ? The Distance Calculator was improved in version 8.0 when the Nearest statement was added. Calculating the distance between 45 airport and the nearest coast line in Denmark tool close to 1 minute. Do remember that the distance is between the point and the closest part of the coast line. Calculating the distance between 21000 addresses and 45 airports took 30 seconds Calculating the distance between 45 airports and 21000 addresses took 30 seconds, too. Calculating the distance between 21000 addresses and 500 railroad stations took 2 minutes and 30 seconds. So it doesn't have to be that slow Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Evan MacDougall Sent: Thursday, October 12, 2006 6:03 PM To: mapinfo-l@lists.directionsmag.com Subject: RE: [MI-L] SV: Distance calc mbx I have the same sluggishness problems with the Distance Calculator. Just running 20 or 50 or even 100 records takes way too long, IMO. Why should it take 10-20 minutes to do 100-200 records? Seems like it should work a lot quicker. -Evan MacDougall GIS Supervisor Gentlemen, we may not make history tomorrow, but we shall certainly change the geography. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Watertech - Jacob K. Jørgensen Sent: Wednesday, October 11, 2006 11:34 PM To: Hankins, Michael D.; mapinfo-l@lists.directionsmag.com Subject: [MI-L] SV: Distance calc mbx Hi Mike, You could insert a Commit statement for every 1.000 - 10.000 points in order to reduce the size of the temporary tables. You could also run the command with RamDisk (www.cenatek.com) as temporary drive to reduce the disk activity. And finally you could save the results in an array and only save on disk for every 1.000-10.000 points - also to reduce the disk activity. Best regards Jacob K. Jørgensen Engineer, M.SC. in GeoInformatics __ Watertech Soendergade 53 DK-8000 Aarhus C Phone: +45 8732 2020 Direct phone: +45 8732 2078 Fax: +45 8732 2021 [EMAIL PROTECTED] www.watertech.dk -Oprindelig meddelelse- Fra: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] På vegne af Hankins, Michael D. Sendt: 11. oktober 2006 16:11 Til: mapinfo-l@lists.directionsmag.com Emne: Distance calc mbx Is there a way to speed up the distance calculator mbx. Have 225,000 points to calculate distance. Been running 20 hours and only 30% completed. I have a good computer and no other programs running. Suggestions??? Mike Hankins COUNTRY Insurance Financial Services ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] Find closest region using buffer
Hi,
If you are using MapInfo/MapBasic 8.0 or 8.5 there is a statement that
will help you a lot.
Nearest [ N | All ]From { Table fromtable | Variable fromvar }To totable Into intotable[ Type { Spherical | Cartesian }][ Ignore [ Contains ] [ Min
min_value ] [ Max max_value ]Units unitname ] [ Data clause
]
It can be used in this way:
...
sAsset_ID = ... 'should be
assigned some value
'**Creating a temp table to store the results of the Nearest
statement
Create Table "OUTPUT___TEMP"
(LCC_MAP_REF Char(100)) 'the size
should fit the size of the column LCC_MAP_REF
Create Map
For OUTPUT___TEMP
CoordSys Table tblWaterLinesTemp
'**Finding the Water line
Select *
>From tblWaterLinesTemp
WhereASSET_ID =sAsset_ID
Into TBL__TEMP NoSelect
'**Making sure a waterline was
selected
If TableInfo(TBL__TEMP,
TAB_INFO_NROWS) 0 Then
'**Fetching
the object from the water line
Fetch First
>From TBL__TEMP
oTemp =
TBL__TEMP.OBJ
'**Finding
the nearest Map Reference to the water
line
Nearest 1
From Variable oTemp
To TBLMAPREF
Into OUTPUT___TEMP
Type Cartesian
DataLCC_MAP_REF =
LCC_MAP_REF
'**Reading the Map Reference ID from the nearest Map
Reference
Fetch First From TBLTEMP
sMapReference =
TBLTEMP.LCC_MAP_REF
Else
Note "No water line with the asset ID "
aAsset_ID " found!"
End if
If you don't have
MapInfo 8.0/8.5 I think you need to insert some Fetch statement in your current
code, like this:
...
'**Fetching the record from
TBLWATERLINESTEMP and assigning the ID to a variable
Fetch First From
TBLWATERLINESTEMP
sAsset_ID =
TBLWATERLINESTEMP.ASSET_ID 'should be assigned some
value
'**Note: NoSelect speeds thing up and doesn't highlight the
selection
Select *
From
tblWaterLinesTemp
WhereASSET_ID = sAsset_ID
IntoTBL__TEMP NoSelect
'**Note let's make sure we
found one
If TableInfo(TBL__TEMP,
TAB_INFO_NROWS) 0 Then
'**Note: Fetching the object
from the water line
Fetch
First From TBL__TEMP
oTemp =
TBL__TEMP.OBJ
'Find map reference
str_Map_Reference = ""
For
y = 1 to 5 Step 1
o_buff = Buffer(oTemp, 20, y,
"m")
Select * from tblMapRef
'**Note: Here you were comparing the tblTemp.OBj to the oBuff, not the
tblMapRef.Obj !!
Where Obj intersects o_buff
into tblMapRefTemp
NoSelect
If
(TableInfo(tblMapRefTemp, TAB_INFO_NROWS) 0)
Then
'This will be the closest Map Reference Grid object closest to the
geometry
str_Map_Reference =
tblMapRefTemp.LCC_Map_Ref
Exit For
End
If
Close
Table tblMapRefTemp
Next
Else
Note "No water line with the asset ID "
aAsset_ID " found!"
End
if
HTH,
Peter Horsbøll Møller GIS Developer, MTM
Geographical Information IT COWI A/S Odensevej 95 DK-5260
Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Hayden
FisherSent: Thursday, October 12, 2006 4:07 AMTo:
MapInfo-L@lists.directionsmag.comSubject: [MI-L] Find closest region
using buffer
Hi All,
A little help in this area would be
greatly appreciated. I am trying to find the closest region to a line or point,
the line or point may lie within or outside the region. I have used the buffer
function to search out from the line or point. Have done this code for lines,
however doesnt seem to pick anything up.
Run Command("Select * From
tblWaterLinesTemp Where Asset_ID = " + Chr$(34) + tblWaterLinesTemp.Asset_ID +
Chr$(34) + " Into tblTemp")
'Find map
reference
str_Map_Reference =
""
For y = 1 to 5 Step
1
o_buff = Buffer(tblTemp.obj,20,y,"m")
Select * from tblMapRef Where tblTemp.Obj intersects o_buff into
tblMapRefTemp
If (TableInfo(tblMapRefTemp, TAB_INFO_NROWS) 0)
Then
'This will be the closest Map Reference Grid object closest to the
geometry
str_Map_Reference = tblMapRefTemp.LCC_Map_Ref
Exit For
End If
Close Table tblMapRefTemp
Next
Regards,
Hayden
Fisher
[EMAIL PROTECTED]
___
MapInfo-L mailing list
MapInfo-L@lists.directionsmag.com
http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] SV: Distance calc mbx
or just use this statement: Set Table MYTABLE FastEdit On Undo Off Then MapInfo writes the changes directly to the files. Speeds things up dramatically, but you loose the Rollback posibility ;-) BTW, these suggestions require MapBasic and access to the source code behing DistanceCalcualtor Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Watertech - Jacob K. Jørgensen Sent: Thursday, October 12, 2006 8:34 AM To: Hankins, Michael D.; mapinfo-l@lists.directionsmag.com Subject: [MI-L] SV: Distance calc mbx Hi Mike, You could insert a Commit statement for every 1.000 - 10.000 points in order to reduce the size of the temporary tables. You could also run the command with RamDisk (www.cenatek.com) as temporary drive to reduce the disk activity. And finally you could save the results in an array and only save on disk for every 1.000-10.000 points - also to reduce the disk activity. Best regards Jacob K. Jørgensen Engineer, M.SC. in GeoInformatics __ Watertech Soendergade 53 DK-8000 Aarhus C Phone: +45 8732 2020 Direct phone: +45 8732 2078 Fax: +45 8732 2021 [EMAIL PROTECTED] www.watertech.dk -Oprindelig meddelelse- Fra: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] På vegne af Hankins, Michael D. Sendt: 11. oktober 2006 16:11 Til: mapinfo-l@lists.directionsmag.com Emne: Distance calc mbx Is there a way to speed up the distance calculator mbx. Have 225,000 points to calculate distance. Been running 20 hours and only 30% completed. I have a good computer and no other programs running. Suggestions??? Mike Hankins COUNTRY Insurance Financial Services ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] RE: MapInfo on Laptop
Title: RE: MapInfo on Laptop You should just use the Arrow keys to pan the map. If you use the Arrow keys in combination with Shift and Ctrl you will move the selected object from the editable layer. This is for MapInfo 8.5. It might have changed in some earlier version Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Steven EvansSent: Tuesday, October 10, 2006 12:53 AMTo: Mapinfo-L@lists.directionsmag.comSubject: [MI-L] RE: MapInfo on Laptop Try using CTRL and the arrow keys to navigate up or down and left or right Steven Evans GIS Officer Parkes Shire Council Ph: 6861 2332 Fax: 6862 3946 Visit Parkes on the web at www.parkes.nsw.gov.au. Attention: This e-mail is privileged and confidential. If you are not the intended recipient please delete the message and notify the sender. Any views or opinions presented are solely those of the author. ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] Simple MI question. Any help appreciated
Title: Simple MI question. Any help appreciated Stuart, The problem might be the declaration of you function. Function CreateRect( ByVal oLine as Object ,ByVal fWidth as Float , ByVal fOffset As Float , ByVal sSide As String) as Object I would recomment that you add the ByVal keyword to the variables. In this way you can actually send a column name to your function and so let MapInfo do the looping thru an Update statement Update sOutputBands Set OBJ = CreateRect(OBJ, sWidthCol, sOffSetCol, sSideCol) This will of course update you existing table. So if you would rather use the Loop to control where to store the result in can be done like this. Note that you'll have to use the Alias variable to point to the table.column. Dim aObj, aWidth, aOffset, aSide As Alias, sWidthCol, sOffSetCol, sSideCol As String, sResultTable, sOutputBands As String oLine, oRectAs Object, fWidth, fOffSet As Float, sSide As String sResultTable = ... sOutputBands = ... sWidthCol = ... 'set them to the name of the column sOffSetCol = ... 'set them to the name of the column sSideCol = ... 'set them to the name of the column aObj= sOutputBands ".OBJ" aWidth = sOutputBands "." sWidthCol aOffset = sOutputBands "." sOffsetCol aSide = sOutputBands "." sSideCol FETCH First From sOutputBands Do While NOT EOT(sOutputBands) oLine = aObj fWidth= aWidth'could also be a value not from the table fOffset= aOffset'could also be a value not from the table sSide = aSide 'could also be a value not from the table oRect = CreateRect(oLine,fWidth, fOffset, sSide) Insert Into sResultTable (OBJ) Values (oRect) FETCH Next From sOutputBands Loop Or a third method is to insert the new rectangles directly into the new table, like this: Insert Into sResultTable (OBJ) Select CreateRect(OBJ, sWidthCol, sOffSetCol, sSideCol) From sOutputBands I hope this gave you some inspiration Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Gibb, StuartSent: Monday, October 09, 2006 5:18 PMTo: mapinfo-l@lists.directionsmag.comSubject: [MI-L] Simple MI question. Any help appreciated Dear all, I have a very simple question that is driving me crazy. I'm trying to create a process that converts a table full of links (lines) into regions (simple rectangles) depending on their values. I have managed to produce a function that calculates the corner points and the bearing of the line. I'm just have trouble call the function and passing variable correctly. sOutputBands is my link table bLine is my link object oBand is my newly mapped region Set ProgressBars Off Set Map Redraw Off FETCH First >From sOutputBands Do While NOT EOT(sOutputBands) ??? FETCH Next From sOutputBands Loop Set Map Redraw On Set ProgressBars On My function, CreateRect, works by passing the link object, the width of the band, the offset from the original link the region is to mapped and the side of the line to plot the region... Function CreateRect(bLine as Object, bWidth as Float, bOffset As Float, bSide As String) as Object Can anyone please advise me on how to call my function properly and correctly pass variable. I think I've done the hard work calculating the region corners and bearing of the line. For some reason I'm struggling with the easy bit i.e the ???'s in my above do loop. Many thanks, Stuart Visit our website at http://www.halcrow.com The contents of this email are confidential, for the sole useof the intended recipient at the email address to which it hasbeen addressed and do not give rise to any binding legalobligation upon Halcrow companies unless subsequently confirmedon headed business notepaper sent by fax, letter or as an emailattachment. Whilst reasonable care has been taken to avoid virustransmission, no responsibility for viruses is taken and it isyour responsibility to carry out such checks as you feelappropriate. Emails supplied are as found and there's noguarantee that the messages contained within the body of theemail have not been edited after receipt. If you receive thisemail in error, please contact the sender immediately and deletethe message from your system.Thank you.- ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] Extracting Table information.
I guess you could use Google Desktop to find these workspaces as well, if you trust Google ;-) Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Reid Sent: Monday, October 09, 2006 8:52 AM To: 'Mathew Linnane'; mapinfo-l@lists.directionsmag.com Subject: RE: [MI-L] Extracting Table information. A couple of solutions come to mind, but one requires you have a particular application installed. 1) The easiest, most workable method comes with a big IF... IF you happen to be an Ultra Edit text editor user, you can search within files specifing only to search inside of *.WOR files and to search for just the table you're looking for. Set the output to an editable window and you will have a real working list you could copy, paste. The useful results can allow a mulitude of possibilites. 2) You could use the Windows search mechanism, or at least you once could. By searching for all instances of *.tab within the files of a specific directory. I don't think you could just search within specific files. 3) I seem to recall, there may be some function you could right into the Mapbasic Window within Mapinfo, one that would list all the workspaces where your table is found. HTH David Reid From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mathew Linnane Sent: Monday, October 09, 2006 1:18 AM To: mapinfo-l@lists.directionsmag.com Subject: [MI-L] Extracting Table information. Is it possible to determine the use of a table within a workspace? Problem: I have a mapinfo table and I want to know what workspace/s contain/s this table. Note: There may be many workspaces. Regards, Mathew Linnane GIS/LIS Assets Officer. Queanbeyan City Council. 257 Crawford Street Queanbeyan NSW 2620. Bus: (02) 6298 0205 Fax: (02) 6297 4044 Mob: 0412 565 552 Email: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] + This message is intended for the addressee named and may contain confidential information. If you are not the intended recipient, please delete it and notify the sender. Views expressed in this message are those of the individual sender, and are not necessarily the views of Queanbeyan City Council, unless otherwise stated. For the purposes of the Copyright Act, the permission of the holder of copyright in this communication may be taken to have been granted, unless stated otherwise, for the copying or forwarding of this message, as long as both the content of this communication and the purpose for which it is copied or forwarded are work related. + ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] Dynamic expressions in select clauses
Or you could use the Alias variable to hold the table and column names DimaCol As Alias, selColumnId as integer, selColumnName as String selColumnId= number retrieved from dialog selColumnName= ColumnInfo(MyTable,"col"+selColumnId,COL_INFO_NAME) aCol = "MyTable." selColumnName selectaCol from MyTable HTH, Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Spencer SimpsonSent: Thursday, October 05, 2006 4:56 PMTo: 'Francois Blanc'; mapinfo-l@lists.directionsmag.comSubject: RE: [MI-L] Dynamic expressions in select clauses Run Command "Select"+selColumnName+" from "+MyTable or Run Command "Select"+selColumnName+" from MyTable" depending on whether MyTable is a variable or not. HTH Spencer From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Francois BlancSent: Thursday, October 05, 2006 10:23 AMTo: mapinfo-l@lists.directionsmag.comSubject: [MI-L] Dynamic expressions in select clauses Hi, I have been trying unsuccessfully to pass a dynamic _expression_ into a select clause in MapBasic. I thought it would be straitforward but somehow it is trickier than I expected. Here is what I did First Iretrieved column number n in MyTablefrom a list in a dialogbox (works fine). I would then like toselect that column from the table. I wrote the following code: Dim selColumnId as integer Dim selColumnName as String selColumnId = number retrieved from dialog selColumnName = ColumnInfo(MyTable,"col"+selColumnId,COL_INFO_NAME) select selColumnName from MyTable This gives me a single column filled with the String columnName. Any idea how I should proceed instead? Thanks, Francois Blanc ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] Layout grid label
James, How about this solution: In you layout you have two frames on top of each other. One just a bit bigger than the other. In the big frame you insert a map window that only contains the coordinate grid. Also make sure that the big fram is beneath the small frame. You now just have to cut the coordinate grid with the "map area" of the small map window. When you do this you force MapInfo to put the label on the end of the grid lines in stead of on the mid of these lines where they aren't visible in the layout. It can be a bit complicated to get to work, so I guess a MapBasic application would be the best solution Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of James M. KellySent: Thursday, October 05, 2006 3:04 AMTo: mapinfo-l@lists.directionsmag.comSubject: [MI-L] Layout grid label Hi all I was wondering if there was a way to add a coordinate grid around the edge of a map frame within a layout. I know I can add the coordinate grid within the map and label it within there, but it would suit me far better if I was able to produce the numbering around the outside of the map window frame. Cheers James Kelly Spatial Information Officer Midway Pty Ltd 150 Corio Quay Road North Shore Victoria 3215 Tel. +61 3 5277 9255 Fax +61 3 5277 0667 Mob +61 4 3834 5760 (0438 345 760) Message protected by MailGuard: e-mail anti-virus, anti-spam and content filtering.http://www.mailguard.com.au/tt ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: SV: [Spam] Re: [MI-L] DLL function name limit
Rakesh, I'm not sure that the problem is that you have a long function name. The error indicates that the function already has been declared some where else in your application. Make sure that you not by mistake have declared the function twice, or that you have a function with a similar name. This other function might even be ocated in a different module, if you have more than one MapBasic module (.mb). Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Rakesh Rao Sent: Tuesday, September 26, 2006 2:38 PM To: mapinfo-l@lists.directionsmag.com Subject: Re: SV: [Spam] Re: [MI-L] DLL function name limit Thank you fro the tip, Bo, but it did not work.Any other ideas? Is there a limit for the DLL also that the function names must be a maximum of 31 characters like other MapInfo symbol names? Regards Rakesh On 26 Sep 2006 at 14:04, Thomsen, Bo Victor wrote: Hi Rakesh - Try to change the place of the function name and the alias: Instead of this: Declare Function IClientObject_ShowImageServicesDialog Lib ISClientC.dll Alias ShowServices (ByVal object as Integer, showImageServicesXml as String) as String try this: Declare Function ShowServices Lib ISClientC.dll Alias IClientObject_ShowImageServicesDialog (ByVal object as Integer, showImageServicesXml as String) as String call the function like this: sArg2 = space$ (255) sVal = ShowServices (nArg1, sArg2) Regards Bo Thomsen GeoConsult I/S Denmark -Oprindelig meddelelse- Fra: [EMAIL PROTECTED] [mailto:mapinfo-l- [EMAIL PROTECTED] På vegne af Rakesh Rao Sendt: 26. september 2006 13:03 Til: mapinfo-l@lists.directionsmag.com Emne: [Spam] Re: [MI-L] DLL function name limit Hi Bill, Thank you for your reply. No, the Alias clause did not help either. -- - // Below function name compiled correctly but does not link, gives a run-time error saying that the function does not exist in DLL IClientObject_ShowImageServicesDialog // Below function does not compile at all, gives an error saying that function is already defined. It appears to be taking only the furst 32 signifiant characters in the function name. IClientPropertiesDialog_ShowPropertyPage ' Declaration in header file Declare Function IClientObject_ShowImageServicesDialog Lib ISClientC.dll Alias ShowServices (ByVal object as Integer, showImageServicesXml as String) as String Declare Function IClientPropertiesDialog_ShowPropertyPage Lib ISClientC.dll ( ByVal object as Integer, ByVal pageId as Integer, ByVal parentHandle as Integer ) as Logical Is there a way to get around this, other than having to recompile the DLL and make changes at source? Regards Rakesh - Rakesh Rao [ rakesh.rao (at)4d-technologies.com ] - Four Dimension Technologies [www.4d-technologies.com] - Get GeoTools, Work smarter: www.4d-technologies.com/geotools - Free Lisp downloads @ TechCenter: www.4d-technologies.com/techcenter - View GDF files in AutoCAD, Get GDFViewer with GeoTools ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l - Rakesh Rao [ rakesh.rao (at)4d-technologies.com ] - Four Dimension Technologies [www.4d-technologies.com] - Get GeoTools, Work smarter: www.4d-technologies.com/geotools - Free Lisp downloads @ TechCenter: www.4d-technologies.com/techcenter ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] testing attribute of directory
Title: RE: [MI-L] testing attribute of directory Martin, You can use this function to question a file Attribute to see if it is a directory Define MAX_PATH 260 Define FILE_ATTRIBUTE_DIRECTORY H10 '16 The file is a directory. Type WIN32_FIND_DATA dwFileAttributes As Integer ftCreationTime As FILETIME ftLastAccessTime As FILETIME ftLastWriteTime As FILETIME nFileSizeHigh As Integer nFileSizeLow As Integer dwReserved0 As Integer dwReserved1 As Integer cFileName As String * MAX_PATH cAlternate As String * 14 End Type '**'' 'Determinating whether a file is a directory by it fileattributes '**'' Function APIFileAttributeIsDirectory(ByVal nFileAttributes As Integer) As Logical OnError GoTo ErrorOccured APIFileAttributeIsDirectory = FALSE If (nFileAttributes / 2 ^ FILE_ATTRIBUTE_DIRECTORY_BIT) Mod 2 Then APIFileAttributeIsDirectory = TRUE End If Exit Function '- ErrorOccured: Note ERR_ERRORMSG lf Error$() End Function You would use this in the loop where you have access to the WIN32_FIND_DATA structure. The loop could look like this: Dim f As WIN32_FIND_DATA ... hFindFile = FindFirstFile (sPath + sFilespec, f) If hFindFile INVALID_HANDLE_VALUE Then Do ' Print Found file: f.cFilename , f.dwFileAttributes If APIFileAttributeIsDirectory(f.dwFileAttributes) Then 'This is a directory Else 'This is not a directory End if nStatus = FindNextFile (hFindFile, f) Loop While nStatus = 1 End If HTH, Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis For enden af regnbuen... - hvordan kommer man dertil og er det overhovedet muligt? Læs mere om årets MapInfo konference på www.cowi.dk/mapinfokonference -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Martin Hodder Sent: Thursday, September 21, 2006 9:13 PM To: Mapinfo-L@lists.directionsmag.com Subject: [MI-L] testing attribute of directory Hi, I was wondering if anyone can help me before I delve into the windows API. I have the API call to get a list of files from a folder. I now need to scan these files and see if any of then are actually folders and not files. Does anyone know hoe to do this? Thanks Martin ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] Creating polylines from Access Database
How about the "famous" Connect The Dots ? http://www.directionsmag.com/files/index.php/view/180 Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis "For enden af regnbuen..." - hvordan kommer man dertil og er det overhovedet muligt?Læs mere om årets MapInfo konference på www.cowi.dk/mapinfokonference From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Lee MorrisSent: Monday, September 18, 2006 1:30 PMTo: mapinfo-l@lists.directionsmag.comSubject: [MI-L] Creating polylines from Access Database Does anyone have or know of any MI tools that will create polylines from columns in an Access database? The data will import into MapInfo ok.PLEASE PLEASE PLEASE HELP!!!Thanks in anticipationLee Morris[EMAIL PROTECTED] The information in this e-mail is confidential and intended to be solely for the use of the addressee(s) and may contain copyright and/or legally privileged information. If you are not the addressee (or responsible for delivery of the message to the addressee) please e-mail us at [EMAIL PROTECTED] and delete the message from your computer; copying, distribution, use or disclosure of its contents is strictly prohibited. As Internet communications are capable of data corruption no responsibility is accepted for changes made to this message after it was sent. For this reason it may be inappropriate to rely on advice contained in any e-mail without obtaining written confirmation of it. In addition, no liability or responsibility is accepted for viruses and it is your responsibility to scan attachments (if any). Please note that for business purposes, outgoing and incoming emails from and to the company may be monitored and recorded. Mouchel Parkman Services Ltd, Registered in England at West Hall, Parvis Road, West Byfleet, Surrey UK KT14 6EZ Registered No : 1686040 ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] SQL Querying
Andrew, This should do it: Select TABLE1.NAME , CartesianArea(Overlap( TABLE1.OBJ, TABLE2.OBJ), sq m) AREA_SQM FromTABLE1, TABLE2 Where TABLE1.OBJ Intersects TABLE2.OBJ Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis For enden af regnbuen... - hvordan kommer man dertil og er det overhovedet muligt? Læs mere om årets MapInfo konference på www.cowi.dk/mapinfokonference -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Tracey Sent: Monday, September 18, 2006 5:17 PM To: MapInfo-L@lists.directionsmag.com Subject: [MI-L] SQL Querying I have two tables - 1 consisting of 70 polygons and 1 consisting of 20 polygons. Both tables cover the same area, what I want to do is work out what area or percentage of each of the polygons that is within another. Does anyone know the syntax to do this? Thanks Andrew Tracey Information Support Officer (GIS) Information Team Chief Executive Office South Tyneside Council Westoe Road South Shields NE33 2RL Tel: 0191 4247561 E-Mail : [EMAIL PROTECTED] Please do not print this e-mail if you can help it - and help protect the environment. This email and any files transmitted with it are confidential and intended solely for the named recipient. If you have received this e-mail in error, please immediately notify the sender by e-mail and delete from your system, you are not permitted to disseminate, store, disclose or copy. E-mail transmission cannot be guaranteed to be secure or error-free as they could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses and therefore the Council accept no liability for any such errors or omissions. Views or opinions expressed in this email are solely those of the author and do not necessarily represent those of the Council.South Tyneside Council, Town Hall Civic Offices, Westoe Road, South Shields, Tyne Wear, NE33 2RL, Tel: 0191 427 1717, Website: www.southtyneside.info The Council's web site address is www.southtyneside.info ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] Iconnumbering (was Seting default MBX folder location)
Title: RE: [MI-L] Iconnumbering (was Seting default MBX folder location) Hi, In the DLL you'll have to use the numbers. And remember that the odd numbers are the small icons and the big icons are the small icon + 1. You can create a .def file to go with the dll. In this .def file you can create a set of defines that you can use to give the icon numbers a more readable name like this: '*** ' DBIcons.def '*** Define FILE_DLL_DB_ACTIONS DBIcons.dll Define ICON_NO_DB_DELETE 1 Define ICON_NO_DB_ADD 3 Define ICON_NO_DB_UPDATE 5 In this way it will be easy to read the syntax of the buttonpad. Include DBIcons.def Sub Main Create ButtonPad DBActions As PushButton Icon ICON_NO_DB_DELETE File FILE_DLL_DB_ACTIONS ... PushButton Icon ICON_NO_DB_ADD File FILE_DLL_DB_ACTIONS ... ... End Sub HTH, Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis For enden af regnbuen... - hvordan kommer man dertil og er det overhovedet muligt? Læs mere om årets MapInfo konference på www.cowi.dk/mapinfokonference -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Rakesh Rao Sent: Friday, September 15, 2006 7:20 AM To: mapinfo-l@lists.directionsmag.com Subject: [MI-L] Seting default MBX folder location Hello, I am new to MapInfo MapBasic programming and am trying to create a toolbar DLL. Is it mandatory to give the icon ID's as numbers like 101, 102 etc as shown in the MapInfo knowledge-base sample or can we have meaningful names like ADD , DELETE etc. If this is possible, how do we differentiate or tell MapInfo which is the small icon and which is the big icon for each button. Any help is appreciated. - Rakesh Rao [ rakesh.rao (at)4d-technologies.com ] - Four Dimension Technologies [www.4d-technologies.com] - Get GeoTools, Work smarter: www.4d-technologies.com/geotools - Free Lisp downloads @ TechCenter: www.4d-technologies.com/techcenter ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] multline labels
David, I'm curious. If the low address range is 0, wouldn't that actual indicate that there only is a single address on this road ? And what if the low as well as the high address range is 0 ? Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis For enden af regnbuen... - hvordan kommer man dertil og er det overhovedet muligt? Læs mere om årets MapInfo konference på www.cowi.dk/mapinfokonference -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Reid Sent: Thursday, September 14, 2006 6:55 AM To: [EMAIL PROTECTED]; mapinfo-l@lists.directionsmag.com Cc: 'Kenneth Hickey' Subject: RE: [MI-L] multline labels Ahhh, but what if the low address range has a 0 on one side or the other and you want to show the true low/high range? In other words, you actually desire the minimum greater than zero Thanks to Simon O'Keefe for help with this... left$(str$(minimum(FROMLEFT,FROMRIGHT)),99*int(FROMLEFT0 and FROMRIGHT0)) + left$(str$(maximum(FROMLEFT,FROMRIGHT)),99*int(FROMLEFT=0 or FROMRIGHT=0)) So, if: FROMLEFT = 1 TOLEFT = 99 FROMRIGHT = 0 TORIGHT = 100 The above syntax will give you (1 - 100) instead as opposed to (0-100) when using minimum alone. Of course, the best thing here if you're gonna label with low and high range very much (which I do on all my work as well). The best thing to do is add a LOW and HIGH field in your table then label from that. Then occasionally, use the above syntax to update your LOW column after doing much addressing maintenance (if you do much of that). Just my .2¢ worth :)) David Reid -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Trey Pattillo Sent: Wednesday, September 13, 2006 8:56 PM To: mapinfo-l@lists.directionsmag.com Cc: Kenneth Hickey Subject: Re: [MI-L] multline labels here's one I use all the time be sure to set the position for center of the object under the field to use select expression and copy/paste the below and set the style to be boxed I like a light yellow background with red/blue/black letters minimum(fromleft,toleft) + - + maximum(fromleft,toleft) + chr$(10) + Street + chr$(10) + minimum(fromright,toright) + - + + maximum(fromright,toright) this produces a look the below where --- street--- is the line [- is line] 100 - 198 -E MAIN ST --- 101 - 199 another is minimum(fromleft,fromright) + - + Street + - + maximum(toleft,toright) which looks like with = being the the actual street line == 100 - E MAIN ST - 199 On Wed 13 Sep 2006 19:15, Kenneth Hickey wrote: Hey Can anyone tell me how to make labels with multiple lines each with data from different fields? Thanks Ken -- Trey Pattillo Failure is not an option It comes standard with all Microsoft products. ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.405 / Virus Database: 268.12.3/446 - Release Date: 9/12/2006 ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] Spatialware Drop RTREE
Robert, I have mingling with SpatialWare as well. This idea is more SQL Server than SpatialWare based. I designed a number of stored procedures and user defined functions and kept these in a simple text file, so that it was easy for me to recreate the entire database from scratch. When you do this you have the same kind of probem: the stored might and might not exist. So before creating a stored procedure - or what ever - I check to see if it exists: if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[spDAV_VRR_INS]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)drop procedure [dbo].[spDAV_VRR_INS]GO CREATE PROCEDURE [dbo].[spDAV_VRR_INS]@nVME_ID int,@nRNR_ID intAS ... I sure you can use the same check to see if the rtree has been created. or you could use this stored procedure (I just found it in the documentation for SpW 4.8): Verifying Your Table has an R-Tree Index You can check if a table has an R-tree index by using the R-Tree Is Created procedure (sp_sw_rtree_is_created). The syntax for this procedure is: exec sp_sw_rtree_is_created 'owner', 'table_name', 'spatial_column', 'key_column', @truth = truth_parameter output HTH, Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis "For enden af regnbuen..." - hvordan kommer man dertil og er det overhovedet muligt?Læs mere om årets MapInfo konference på www.cowi.dk/mapinfokonference From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Robert CrossleySent: Saturday, September 02, 2006 11:58 PMTo: mapinfo-l@lists.directionsmag.comSubject: [MI-L] Spatialware Drop RTREE Hi any spatialware gurus, When things go right, spatialware has been working well. However, when I get something go wrong, it can trigger a whole sequence of issues, eg. if one of the stored procedures fails midway, I may have dropped the rtree index in a stored procedure and not recreated it at the end. Then the next time I run the stored proc, I get an error saying that I cannot run the stored procedure as I get the error. [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot drop the function 'dbo.T_GPS_LOCS#p#SW_GEOMETRY#p#SW_MEMBER', because it does not exist in the system catalog. Then worse, I get the following error because SQL server has stopped. Connection Error was: [Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not exist or access denied. I have seen a number of stored procs in the database like sp_sw_predrop_rtree, sp_sw_rtree_is_precreated, and thought that perhaps these could be used to check before I run the drop rtree procedure. I am not sure how to though. It would be better if these sort of checks were simply included in the create rtree stored proc .. Any suggestions? TIA. R ---Robert CrossleyAgtrix P/L AustraliaFar Southern Queensland Office:Unit 6/ 2 Bonanza DrivePO Box 63 New Brighton 2483P: 61 2 6680 1309F: 61 2 6680 5214E: [EMAIL PROTECTED]W: www.agtrix.comBrisbane Office:109 Milsom StCooparoo 4151QueenslandP: 61 7 3843 3363 ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] Altering Point Object Symbol
Don,
The problem is that you update statement updates the entire table instead
of just the record you have fetched.
This should fix the problem:
miApp.do "DimnRowID As
Integer"...
Do while
miApp.Eval("EOT(selection)") = "F"
miApp.do
"bfpobj = selection.objnRowidID = selection.ROWID Alter
Object bfpobj Info 2, bfpsymbol Update selection Set obj = bfpobjWhere ROWID =
nRowID Fetch Next From
selection"Loop
Peter Horsbøll Møller GIS Developer, MTM Geographical
Information IT COWI A/S Odensevej
95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis
"For enden af
regnbuen..." - hvordan kommer man dertil og er
det overhovedet muligt?Læs mere om årets MapInfo konference på
www.cowi.dk/mapinfokonference
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Hughes,
Colleen / Don MitchellSent: Thursday, September 14, 2006 9:36
PMTo: mapinfo-l@lists.directionsmag.comSubject: [MI-L]
Altering Point Object Symbol
Hi
All,
Me
again. I've found a way to do the looping in MapInfo without MapBasic,
calling the MapBasic commands from VB and doing the rest in
VB.
However, I have a new problem. When I execute the
code to change the symbol of a selection set, It changes the symbol style
fine.But it alsochanges the location of the points to the
samelocation as the first object in the table. It's as if the Alter
Object statement has a Geography clause along with the Info clause I'm
using. I've included the code below. I have the MapBasic Reference
Guide which has a description of the MapBasic.def which is where I get the value
for the OBJECT_INFO_SYMBOL code.
Any
ideas what I'm missing.
Code-
'this creates the object for the MapInfo
Application already running
Dim
miApp
Set
miApp = GetObject( , "MapInfo.Application")
Dim
miStr
miStr
= "select * from OverDue where Due_Tested = ""NO BFP"" "
'miApp.do passes the commands and strings to
MapInfo
miApp.do miStr
miApp.do "Dim bfpobj As Object"miApp.do "Dim
bfpsymbol As Symbol"
'this makes the symbol to pass to the Alter Object
statement.
miApp.do "bfpsymbol = MakeSymbol(34,0,6)"miApp.do
"Fetch First From selection"
'MapInfo returns F ifit hasn't reached the
endof theselection table, so this Do While loop continues
untilthere are no more records in the
selection.Do while miApp.Eval("EOT(selection)") =
"F"
miApp.do
"bfpobj = selection.obj Alter Object bfpobj Info 2, bfpsymbol Update selection
Set obj = bfpobj Fetch Next From selection"Loop
Any
help is appreciated.
_
Don
Mitchell
GIS Technician
(IMS)
City of
St.Thomas
___
MapInfo-L mailing list
MapInfo-L@lists.directionsmag.com
http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] Combining Tables
Karl, The thing you are looking for here, is called a Seamless table: One table linking to a number of other tables. In the Tool Manager you can find a tool called Seamless manager that can help you create such a table. - Start MapInfo or close all - Open the tables to be combined/linked into the seamless table in a new map window - Load Seamless Table Manager - Go to Tools Seamless Manager New seamless table ... - name the new table and place it in the same folder as the other tables Now you have created a seamles table that can be used to open the other tables. Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis For enden af regnbuen... - hvordan kommer man dertil og er det overhovedet muligt? Læs mere om årets MapInfo konference på www.cowi.dk/mapinfokonference -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Karl Zimmer Sent: Monday, September 11, 2006 12:29 AM To: mapinfo-l@lists.directionsmag.com Subject: [MI-L] Combining Tables Hello, I have recently registered numerous airphotos with MapInfo professional. They work fine and fit together nicely when all the air photo .tab files are opened together in mapinfo. However it is a pain loading the numerous .tab files for each photo whenever I want to use the mosiac of photos for the project. So I was wondering if it is possilbe to comine all the airphoto .tab files into 1 single tab file that would show all the air photos at once simply by opening the that .tab file. Thanks, Karl Zimmer __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] SUM - NVIDIA video card - MapInfo hangs
Stephen, Have you tried clearing your Windows Temp folder ? Maybe it is full ! Start Programs Accessories System Tools Disc Cleanup can do the job. Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis For enden af regnbuen... - hvordan kommer man dertil og er det overhovedet muligt? Læs mere om årets MapInfo konference på www.cowi.dk/mapinfokonference -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Stephen R Baig Sent: Monday, September 11, 2006 6:30 PM To: mapinfo-l@lists.directionsmag.com Subject: RE: [MI-L] SUM - NVIDIA video card - MapInfo hangs All, My versions of MI 7.0 and 8.0 started to hang, as described, sometime Friday last (or before). Could create tables but SQL's from the tables just spun and spun, never finished. Same for copy-and-paste from other maps created years ago. Both procedures work OK on another install off-site. MI on the Dell 670 with Invidia Quadro FX 1400 graphics chip (@ 1024 x 768, ) had been OK for the previous year. I tried closing the Invidia menu as suggested. No luck. We are subject to enterprise-wide Microsoft and McAfee upgrades. Any further suggestions gratefully accepted. Stephen Baig oceanographer TPC/National Hurricane Center Miami, FL ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] Copy - Paste in MapBasic
Tom, To me it is unclearif you insert the rows in the new table into the new table or if you update an existing record in the old table with values from the new table. But I would think that you are updating an existing record. And the link between the old and the new is the telephone number. If this is so, you don't have to manually deal with one record at a time. You can make a small MapBasic application that will run thru the records in the new table and update the old table with the changes simply by comparing the telephone number. This can be achieved by using the Add Column statement for each column that needs to be updated. This link is the telephone number. You could actually do a Update Column in MapInfo Pro with the MapBAsic window open. This will give you the syntax to use. Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis "For enden af regnbuen..." - hvordan kommer man dertil og er det overhovedet muligt?Læs mere om årets MapInfo konference på www.cowi.dk/mapinfokonference From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tom HalbrookSent: Tuesday, August 29, 2006 3:01 PMTo: MapInfo-L@lists.directionsmag.comSubject: [MI-L] Copy - Paste in MapBasic I am still learning Map Basic and trying to write a program to copy a record in a row in one table and paste it into a row in another table. Heres my scenario. Each week I update changes in a telephone customer database. I get a file from my Service Center that has all the moves, disconnects, and adds that have occurred in the previous week. I convert the file into a MapInfo table and update my MapInfo Customer Locator program. Example: On a number change I presently select the telephone in the new table, hit ctrl C, and then select the telephone number field in the old table and hit ctrl V. (A lot of repetitive key strokes) The procedure I am striving for would be; 1. Select the record in the first table, click on a pushbutton (to copy the selection) Then 2. Select the record in the second table, click on another pushbutton (to paste the copied record into the second table) I can build the program to create the button pads etc. But I cant seem to find any MapBasic command that is equivalent to Copy Paste Can anyone give me the Map Basic Commands or Statements that would be equivalent to Copy and Paste action in MapInfo? Thanks, Tom Halbrook ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] Raster Image
Title: Raster Image Bill, You can do this with MapInfo 8.5 thru the Save Window As. This function has been improved to also save a georeferenced tab file with the raster image. Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis "For enden af regnbuen..." - hvordan kommer man dertil og er det overhovedet muligt?Læs mere om årets MapInfo konference på www.cowi.dk/mapinfokonference From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Williams, Bill (DPS)Sent: Wednesday, August 30, 2006 6:48 AMTo: mapinfo-l@lists.directionsmag.comSubject: [MI-L] Raster Image Listers Does anyone know of a device which can be used inside MapInfo to cut a piece out of a raster image while retaining its geographic attributes ? Bill Williams GIS Specialist, Statistics Mapping Section Parliamentary Library Department of Parliamentary Services Parliament House PO Box 6000 CANBERRA ACT 2600 Telephone : 02 62772513 Email: [EMAIL PROTECTED] ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] Help with commandinfo(CMD_INFO_ROWID) after a dialog iscalled please
Nicki,
If you read the Help file closely, you'll see that
CommandInfo(CMD_INFO_ROWID) is supposed to be used within the
SelChangedHandler.
So I guess MapInfo expects a change in the selection just to have
happened. Showing a dialog or in any other waymingling withthe user
interface might move the change in the selection away from focus and so MapInfo
is no longer able to "use" the CMD_INFO_ROWID attribute.
The question is why do you need the rowid from the base table
?
You have the selection and can easily update the object thru this
table:
Fetch First From Selection
Do Until EOT(Selection)
oPolygon = Selection.OBJ
nRowID =
Selection.ROWID
'...do what needs to be done
Update Selection
Set
OBJ=
oPolygon
Where ROWID
= nRowID
Fetch Next From Selection
Loop
Peter Horsbøll Møller GIS Developer, MTM Geographical
Information IT COWI A/S Odensevej
95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis
"For enden af
regnbuen..." - hvordan kommer man dertil og er
det overhovedet muligt?Læs mere om årets MapInfo konference på
www.cowi.dk/mapinfokonference
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Nicki
CozensSent: Wednesday, August 30, 2006 4:21 PMTo:
mapinfo-l@lists.directionsmag.comSubject: [MI-L] Help with
commandinfo(CMD_INFO_ROWID) after a dialog iscalled please
Dear Listers
I have a number of procedures that are called from a
menu bar. One of the menu items allows the user to change the snapping
tolerance of the node snapping tool I have created. If the user selects a
polygon and then runs the main node snapping tool it works ok (if a little slow
see previous postings!), however, if the user previously selects a polygon,
then chooses to change the snapping tolerance via the menu, an error occurs back
in the main node snapping routine when a CommandInfo is issued to find out the
row id of the selected polygon.
Can anyone shed any light on what is happening please
I think it is something to do with the OKbutton on the dialog changing the
selection?
Is there an easy way how I can get the CommandInfo(cmd_info_rowid) to find the row id of the
selected polygon after the ok button has been
clicked?
Here are the main snippits of code:
###
Sub snaptolerance
runs when user selects change tol. from menu
Dialog
Title "Snapping
Tolerance"
Control StaticText
Title "Please enter new tolerance (in m)"
'Position 10, 10
Control
EditText
Value 0.25
Into gf_snaptolerance
Control
OKbutton
Control
CancelButton
End Sub
###
Sub SnapNodes
runs when user chooses snap from menu
... the variable declarations go in here
and some initializing
If SelectionInfo(SEL_INFO_NROWS) 0
Then
aSelName =
SelectionInfo(SEL_INFO_SELNAME)
'eg "Query1"
gs_theselTable =
SelectionInfo(SEL_INFO_TABLENAME)
Note
(gs_theseltable) just to check this is showing table
name
Else
Note("The
selection is now
0")
'just to check
This is not showing so there are rows selected
End If
gi_myrowid =
commandInfo(cmd_info_rowid) This is where the error
occurs
###
The error that is returned
is:-
CommandInfo: argument 2 out of range,
corresponding to the last line shown above
Many thanks
Nicki Cozens
Nicki Cozens Data
Management Officer Highways Development ControlLeicestershire County
CouncilCounty HallGlenfieldLeicesterLE3 8RA
___
Leicestershire County
Council - rated a 'four-star' council by the Audit Commission
___
This e-mail and any files
transmitted with it are confidential. If you are not the intended recipient, any
reading, printing, storage, disclosure, copying or any other action taken in
respect of this e-mail is prohibited and may be unlawful. If you are not the
intended recipient, please notify the sender immediately by using the reply
function and then permanently delete what you have received.
Incoming and outgoing
e-mail messages are routinely monitored for compliance with Leicestershire
County Council's policy on the use of electronic communications. The contents of
e-mails may have to be disclosed to a request under the Data Protection Act 1998
and the Freedom of Information Act 2000.
The views expressed by
the author may not necessarily reflect the views or policies of the
Leicestershire County Council.
Attachments to e-mail
messages may contain viruses that may damage your system. Whilst Leicestershire
County Council has taken every reasonable precaution to minimise this risk, we
cannot accep
RE: [MI-L] Change pen style on selected objects through MapBasic orWOR-file
Title: Meddelelse Jacob, I would recommend using a function to alter the style of the object in stead of looping yourself. If you use a function, you can use the Update statement and let MapInfo do the looping. Sub Main Update Selection Set OBJ = AlterLineStyle(OBJ, P_Penstyle) End Sub Function AlterLineStyle(ByVal oLine As Object, ByVal pNew As Pen) As Object Alter ObjectoLine Info OBJ_INFO_PEN,pNew AlterLineStyle = oLine End Function But do make sure that the selection: - only contains records with an object (could be done with a select statement prior to doing the update) - the objects support the line style (could be done with a select statement prior to doing the update or in the function) Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis "For enden af regnbuen..." - hvordan kommer man dertil og er det overhovedet muligt?Læs mere om årets MapInfo konference på www.cowi.dk/mapinfokonference From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Watertech - Jacob K. JørgensenSent: Monday, August 28, 2006 1:55 PMTo: mapinfo-l@lists.directionsmag.comSubject: [MI-L] Change pen style on selected objects through MapBasic orWOR-file Hi all, I would like to change the line style which is invoked in MapInfo by selecting all relevant objects in a map window from an editable layer and then choosing the icon "Line Style" in the drawing buttonpad. Alas, I cannot find the MapBasic command for calling this button, so I cannot write a simple WOR file to do the job for me or a simple MapBasic program. I have to loop through all the relevant records and change the object attribute by the command Alter ObjectMyCurrentObj Info: Dim P_Penstyle AsPen Dim MyCurrentObj As Obj P_Penstyle = MakePen (1, 2, 16711680) For i = 1 To nRecords'in current selection Fetch rec i From Selection MyCurrentObj = Selection.obj Alter Object MyCurrentObj Info OBJ_INFO_PEN, P_Penstyle Update Selection Set obj = MyCurrentObj where RowID = i Next This way is rather slow when there are many records in the selection, so do any of you GISmo's out there have a better solution? Thanks in advance Jacob K. JørgensenEngineer, M.SC. in GeoInformatics__WatertechSoendergade 53DK-8000 Aarhus CPhone: +45 8732 2020Direct phone:+45 8732 2078Fax: +45 8732 2021[EMAIL PROTECTED]www.watertech.dk ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] Set Focus on PopupMenu Control in a Dialog
If you read the MapBasic Help file: The Active keyword applies only to EditText controls You'll notice that the Active keyword only works for EditText controls. I have spent quite a few hours wondering why my dialog wasn't working as designed. You might wonder why the Active keyword doesn't work on other controls. Any ideas ? Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis "For enden af regnbuen..." - hvordan kommer man dertil og er det overhovedet muligt?Læs mere om årets MapInfo konference på www.cowi.dk/mapinfokonference From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Greg GoodallSent: Monday, August 21, 2006 10:21 PMTo: 'Jacques Paris'; mapinfo-l@lists.directionsmag.comSubject: RE: [MI-L] Set Focus on PopupMenu Control in a Dialog Theres all sorts of hidden rules in MapBasic and more importantly the MapBasic documentation. I added another EditText control to the dialog BEFORE my PopupMenu but made it hidden. Control EditText Hide As it turns out, that hidden control received the focus. Go Figure. In essence the dialog displays and it appears that No control at all has the focus. However, when I hit the tab key the focus goes to the next control which is my PopupMenu. This is a better scenario, but not completely what I want. From: Jacques Paris [mailto:[EMAIL PROTECTED] Sent: Monday, August 21, 2006 3:42 PMTo: 'Greg Goodall'; mapinfo-l@lists.directionsmag.comSubject: RE: [MI-L] Set Focus on PopupMenu Control in a Dialog There seems to be some hidden rules in that control focus setting. Popup menu does not seem to able to be set as default control, the one that should be active at dialog opening. But it is not the only case I have met; I have been unable to set the OkButton or any button as default focus. What could be that hidden rule? Jacques Paris -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Greg GoodallSent: 21 août 2006 13:31To: mapinfo-l@lists.directionsmag.comSubject: [MI-L] Set Focus on PopupMenu Control in a Dialog I have a Dialog that contains several types of controls (StaticText, PopupMenu, EditText, RadioGroup and Buttons) and I would like to specify which control has the initial focus when the Dialog displays. Currently when the Dialog displays, the focus is placed on the first EditText control. I want the focus to be placed on a PopupMenu control instead. The Controls are defined in the following order StaticText PopupMenu EditText So I would think that the PopupMenu would be get the initial focus according to the Help information below. Greg Goodall Data Management Marketing Project Manager / Senior Systems Analyst 321-725-8081 [EMAIL PROTECTED] ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] RE: Issues with printing PDFs.
Title: RE: Issues with printing PDFs. Hi, I also think it can be connected to regions with mulitple sections. Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis "For enden af regnbuen..." - hvordan kommer man dertil og er det overhovedet muligt?Læs mere om årets MapInfo konference på www.cowi.dk/mapinfokonference From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ian TidySent: Thursday, August 10, 2006 2:47 AMTo: MapInfo-LSubject: RE: [MI-L] RE: Issues with printing PDFs. This Problem has been around for years. I thought it was more to do with the way the region is shaded/filled in the postscript language. MapInfo is not the only application that this happens with. Cheers Ian __Ian TidyGIS AdministratorWorks Asset DepartmentNapier City CouncilHastings St, Private Bag 6010, Napier, New ZealandPhone +64-6-835-7579 Ext. 8115Fax +64-6-835-7574mailto:[EMAIL PROTECTED]http://www.napier.govt.nz From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brorsen, GertSent: Thursday, 10 August 2006 11:42 a.m.To: 'mapinfo-l@lists.directionsmag.com'Subject: [MI-L] RE: Issues with printing PDFs. This is a bug that has been around for at least 8 years.that's when I took over the mapping hat at my company, using MI4.5, and it is a bug that shows its ugly face on this list regularly. If memory serves me correctly, there is no fix in terms of how you print the file, as the artefacts are due to how MI processes complex region boundaries, i.e.. the higher the node count in your region boundary, the more printing artefacts you will get. rantSometimes it get frustrating that MI concentrates so heavily on putting bling, smoke and mirrors in their new releases, to chase potential new markets, rather that fixing persistent old bugs./rant Gert Brorsen GIS Technician Visionstream Pty Ltd ___ 236 East Boundary Road, 2 North Drive Virginia Park, Bentleigh East VIC 3165 Long: E 145.0618° Lat: S 37.9100° T 613 9283 4951 F 613 9563 8749 E [EMAIL PROTECTED] www.visionstream.com.au Date: Wed, 9 Aug 2006 17:14:43 +1000 From: "Spatial Decisions" [EMAIL PROTECTED] Subject: [MI-L] Issues with printing PDFs. To: MapInfo-L@lists.directionsmag.com Message-ID: [EMAIL PROTECTED] Content-Type: text/plain; charset="iso-8859-1" Hi MI-Listers Just wondering if anybody has experienced the following behaviour (and importantly - overcome it). When printing from the Layout window (using either MI Pro 8.0 or 8.5) to PDF, small fine lines are appearing horizontally and vertically (like a grid) on small areas of the output. These lines appear on the map in the PDF reader, but of more concern, they appear on the hard-copy printed from the PDF. Have tried using Adobe Acrobat Professional (V6), PDF995 and the GeoWriter PDF that ships with MI Pro 8.5 and all have produced the same lines in the same spots. Another interesting problem is that the lines don't appear on every PDF created and when they do appear they are not in the same spot on different outputs. However, if the same output is printed using the various PDF printers mentioned, the lines do appear in the same spot for each printer used. This is proving frustrating as PDF is a valuable form of output delivery to clients. Operating system is XP Pro. Any thoughts/ideas welcomed. Thanks in advance. Tony Maber - Certified MapInfo Professional Business Services Manager SPATIAL DECISIONS PTY LTD (A MapInfo Partner Company) www.spatialdecisions.com.au Ph: 61 2 9528-2822 Fax: 61 2 9528-2833 Mob: 61 404-861-858 ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** This e-mail message has been scanned and cleared by MailMarshalwww.marshalsoftware.com ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] MapBasic - How to tell if a ButtonPad is Showing
Title: RE: [MI-L] MapBasic - How to tell if a ButtonPad is Showing Hi, Here is a small function that will toggle the appearance of a named buttonpad. You can use this as inspiration ;-) - ButtonPadInfo(name_of_buttonpad, BTNPAD_INFO_WINID) will return the WindowID of the buttonpad - WindowInfo(nWID, WIN_INFO_OPEN) will, when used on a buttonpad, tell you if the buttonpad is shown (=true) or hidden (=false) ' Sub PADShowHide(ByVal sPadName As String ) Dim nWID As Integer OnError GoTo ErrorOccured nWID = ButtonPadInfo(sPadName, BTNPAD_INFO_WINID) If WindowInfo(nWID, WIN_INFO_OPEN) Then Alter ButtonPad sPadName Hide Else Alter ButtonPad sPadName Show End If '--- ErrorOccured: End Sub ' Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis For enden af regnbuen... - hvordan kommer man dertil og er det overhovedet muligt? Læs mere om årets MapInfo konference på www.cowi.dk/mapinfokonference -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Nicki Cozens Sent: Wednesday, August 02, 2006 10:23 AM To: mapinfo-l@lists.directionsmag.com Subject: [MI-L] MapBasic - How to tell if a ButtonPad is Showing Re the posting on 07-21-2006 and reply by Lars I. Nielsen: Do you have an example of how WindowInfo is used to find the Show/Hide status of a floating button bar? I'm struggling with showing and hiding a button pad. I create the button bar and make sure that it has show as one of the attributes. I then issue the command buttonpad_id = FrontWindow() to obtain the window id. I tried to then issue the Set Window buttonpad_id Hide but it said I couldn't do that to that kind of window, so I tried Close Window buttonpad_id instead and it would appear that when I used the FrontWindow() command it was picking up the map window instead of the button pad I had just created as the map window closes and not the button pad. Any suggestions as to what I am doing wrong? Here is the code: Create ButtonPad Accept As PushButton Icon 185 HelpMsg Click to accept when happy Calling Accept_changes PushButton Icon 195 HelpMsg Click to reject Calling reject_changes Width 3 Position (2,2) Show Float buttonpad_id = FrontWindow() 'The following would not work with the window in question 'Set Window buttonpad_id ' Hide Close Window buttonpad_id'this closed the map window Many thanks Nicki ___ Leicestershire County Council - rated a 'four-star' council by the Audit Commission ___ This e-mail and any files transmitted with it are confidential. If you are not the intended recipient, any reading, printing, storage, disclosure, copying or any other action taken in respect of this e-mail is prohibited and may be unlawful. If you are not the intended recipient, please notify the sender immediately by using the reply function and then permanently delete what you have received. Incoming and outgoing e-mail messages are routinely monitored for compliance with Leicestershire County Council's policy on the use of electronic communications. The contents of e-mails may have to be disclosed to a request under the Data Protection Act 1998 and the Freedom of Information Act 2000. The views expressed by the author may not necessarily reflect the views or policies of the Leicestershire County Council. Attachments to e-mail messages may contain viruses that may damage your system. Whilst Leicestershire County Council has taken every reasonable precaution to minimise this risk, we cannot accept any liability for any damage which you sustain as a result of these factors. You are advised to carry out your own virus checks before opening any attachment. ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] RowID question [SEC=UNCLASSIFIED]
Percy, Unfortunately you can't select the ROWID "column".You have to update a column with the ROWID value and then use this static column instead. You can however use the ROWID to select certain records, by adding the condition to the where clause Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis "For enden af regnbuen..." - hvordan kommer man dertil og er det overhovedet muligt?Læs mere om årets MapInfo konference på www.cowi.dk/mapinfokonference From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bell, PercySent: Wednesday, August 02, 2006 4:49 AMTo: mapinfo-l@lists.directionsmag.comSubject: [MI-L] RowID question [SEC=UNCLASSIFIED] Guys, I may be showing my ignorance but I cant seem to include RowID in an SQL query. EG: Select Col1, Col2, Col3, ROWID RowIdentifier from I dug up an old post: [MI-L] Returning RowID in the Select Statement (SQ Author:Ben A Greenberg(207.250.113.---)Date:03-25-2006 08:17I am querying a large dataset and would like the select query to return the RowID as a temporary column. Can this be done. When i run the following query: But couldnt find and answer. Can anybody help? Cheers Percy Percy Bell Research Statistics and Technology Branch Phone: (02) 6271 1463 Mob: (0415) 260 805Fax: (02) 6271 1144Department of Communications, Information Technology and the Arts GPO Box 2154, Canberra ACT 2601 AustraliaURL:http://www.dcita.gov.auEmail: [EMAIL PROTECTED] ___Theinformationtransmittedisfortheuseoftheintendedrecipientonlyandmaycontainconfidentialand/orlegallyprivilegedmaterial.Anyreview,re-transmission,disclosure,disseminationorotheruseof,ortakingofanyactioninrelianceupon,thisinformationbypersonsorentitiesotherthantheintendedrecipientisprohibitedandmayresultinseverepenalties.Ifyouhavereceivedthise-mailinerrorpleasenotifytheSecurityAdvisoroftheDepartmentofCommunications,InformationTechnologyandtheArts,telephone(02)6271-1880anddeleteallcopiesofthistransmissiontogetherwithanyattachments.Forallotherenquiriespleasering(02)6271-1000.___ ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] Symbol identification
Mike, There is an unlimited number of symbols availeble in MapInfo. Just consider the combination possibilities between the 32 different symbols in MapInfo 3.0 Symbols, a number of million colours and sizes between 3 and 72. And this is just one set of symbols. When you look in the Symbol dialog, you can see maybe 30 different symbol fonts containing any number of symbols. But in the MapInfo Professional User Guide 8can be found on the MapInfo installation cd and for MapInfo 8.5 in the document folder in the installation folder) you can in Appendix E MapInfo Map Interchange Format - MapInfo 8.5 - find a list of symbols available in the MapInfo 3.0 Symbols. You could also create you own list in this way. 1. Create a new mappable table containing one column called NAME 2. Insert points into this table with the symbols that you like and need and add a description in the NAME column 3. With this SQL Select statement, you can get a list of NAMES and SYMBOLS from this table. You can copy the statement and execute it from the MapBasic window or just use the bold text and insert these into the SQL Select Dialog Select NAME, Str$(ObjectInfo(OBJ, 2) "SYMBOL" From SYMBOLTABLE Order By NAME Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis "For enden af regnbuen..." - hvordan kommer man dertil og er det overhovedet muligt?Læs mere om årets MapInfo konference på www.cowi.dk/mapinfokonference From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mike GibsonSent: Wednesday, August 02, 2006 7:16 AMTo: MapInfo-L@lists.directionsmag.comSubject: [MI-L] Symbol identification Hello all Can anyone point me towards how I can printa full list of available symbolsfor reference purposes - image and meta info i.e. Symbol (48,255,8,""MapInfo Cartographic"",0,0). Below is atxt export of browser which is used to define symbology within and asset program. I'd like to be able to add and re define entries from a known reference sheet. Thanks Micheal FEATURE_TYPE Symbol Unknown Symbol (32, 16711680, 15)Blank CapSymbol (48,255,8,""MapInfo Cartographic"",0,0)Fire Hydrant Symbol (32, 16776960, 8)"Fountain Symbol (94,255,12,""Wingdings"",0,0)Meter Symbol (77,255,8,""Symbol"",1,0)Dummy Node Symbol (33, 0, 8)Pump StationSymbol (35,255,16,""MapInfo Real Estate"",0,0)Reservoir Symbol (40, 255, 15) and so on "Tap""Symbol (44,255,8,""MapInfo Cartographic"",0,0)""Valve""Symbol (101,255,8,""MapInfo Cartographic"",0,0)""Treatment Plant""Symbol (40,255,16,""MapInfo Real Estate"",0,0)""Manhole""""Bore Site""Symbol (40, 255, 15)""Valve Pit with Pig""""Valve Pit""""Cross Connection""""Marker Post""Symbol (54, 16776960, 12)""HeadWall""""Pit"""__ DISCLAIMER This email and any attachment is solely for the named addressee and may be confidential. If you have received this email in error, please notify the sender immediately and then destroy any copy of this message. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of Rous Water. Before opening any attachments the recipient should check for the presence of viruses or defects. Rous Water accepts no liability for any damage caused by any virus transmitted by this email. Rous Water 218-232 Molesworth Street, Lismore NSW 2480 Australia www.rouswater.nsw.gov.au __ ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] Sorting records by val of a character formatted column
Title: RE: [MI-L] Sorting records by val of a character formatted column Dave, I think you have found the right method, but you might not be able to sort by an _expression_ directly, so you would need to add the _expression_ to the list of columns to select and then order by this new column. Select LOTNBR, Val(LOTNBR) LOTNBR_VAL From LOTS Order By LOTNBR_VAL Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis For enden af regnbuen... - hvordan kommer man dertil og er det overhovedet muligt? Læs mere om årets MapInfo konference på www.cowi.dk/mapinfokonference -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of David Reid Sent: Friday, July 28, 2006 5:45 AM To: MapInfo-L@lists.directionsmag.com Subject: [MI-L] Sorting records by val of a character formatted column Greetings List, I have a parcel table with the field [LOTNBR] formatted as Character Naturally when sorted you get: 1 10 11 12 2 20 21 etc etc I've tried using in the sort field val(LOTNBR) but to no avail to achieve: 1 2 3 4 etc Anyone know the syntax to do this? Thanks, Dave -- Outgoing mail is certified Virus Free Checked by AVG Free Edition. Version: 7.1.394 / Virus Database: 268.10.4/401 - Release Date: 07/26/2006 ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] MAPBASIC Object or not Object?
That's right. And for that you can test the object itself (which is actually an alias). But once you put an object into a variable you need another way to indicate whether its valid or not. I agree, Bill. It could be very usefull, if there was a function in MapBasic that actual could test whether an object was legal or not/exists or was null, or what ever you want to call this state. This is especially usefull when you have a function, that expects to get an object and also returns an object. How would you handle this situation ? What you make sure that you don't call the function with a not existing object, or could in some way handle the problem inside the function in a smart manner without corupting the table ? I tend to check before calling the funtion, but would love to hear about a solution to the second if possible. Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis For enden af regnbuen... - hvordan kommer man dertil og er det overhovedet muligt? Læs mere om årets MapInfo konference på www.cowi.dk/mapinfokonference -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill Thoen Sent: Friday, July 28, 2006 5:39 PM To: Spencer Simpson Cc: mapinfo-l@lists.directionsmag.com Subject: Re: [MI-L] MAPBASIC Object or not Object? Spencer Simpson wrote: No, I've found that aliases (especially objects) can act strangely if you try to extract their values more than once between two successive fetches. Maybe newer versions of MapInfo are more robust, but it conditioned me to always fetch aliases into variables back in the 1990s. I'd have to say, Prove it. IMHO, that's a superstition that you develpoed as you were learning and now it's just a habit. It's similar to the superstition that using defined constants is not safe. Using degenerate objects to simulate null objects is useful, but it doesn't help fetching them from a table, because you can't guarantee that a row didn't have its object deleted. That's right. And for that you can test the object itself (which is actually an alias). But once you put an object into a variable you need another way to indicate whether its valid or not. ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] TextPad as editor for MapBasic
Hi, I learned this little trick from Bill Thoen some years ago and it has proven very helpful. I also started opening the err file manually, but you don't have the go to on doubleclick when you just open the file. I'm not using TextPad but UltraEdit, but I guess the problem is the same. Using this method the text from the .err file is put into the output window of UltraEdit. I have a bat file, that I call from UltraEdit to compile a source file (and link a project file). At the end the bat file types the err file, if it exists: bat file start @Echo Off C:\MapBasic\MapBasic 8.0\Mapbasic.Exe -NOSPLASH -D %1.mb if exist %1.err type %1.err bat file end %1 is the name and path of the source file to compile. Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis For enden af regnbuen... - hvordan kommer man dertil og er det overhovedet muligt? Læs mere om årets MapInfo konference på www.cowi.dk/mapinfokonference -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Spencer Simpson Sent: Wednesday, July 26, 2006 4:13 PM To: mapinfo-l@lists.directionsmag.com Subject: RE: [MI-L] TextPad as editor for MapBasic TextPad has a way of capturing output from a command-line tool, and parsing it to locate where the compiler said the error occurred. Unfortunately, MapBasic thwarts this capability, because the compiler always writes compilation errors to a file with an extension of .err, even when MapBasic is run from the command line. If there are no errors, there is no .err file. If the MapBasic compiler had a way to send errors to standard output instead of the .err file, you could capture the output in TextPad. But it doesn't, and MapInfo is unlikely to add this functionality. The best you can do is to open the .err file in TextPad after compilation is finished. Unfortunately, there doesn't appear to be a way to make a TextPad tool perform two actions. TextPad's macro functionality appears to be limited to editing. So you'll have to make a DOS batch file like the following: @echo off if %1 == %2 goto link mapbasic -Nosplash -D %1 goto ckerr :link mapbasic -Nosplash -L %1 :ckerr if exist %3 C:\Program Files\TextPad 4\textpad %3 Save this in a file named MBTextPad.bat in the same directory as Mapbasic.exe. Then add a tool to TextPad (Configure-Preferences... Select tools on the right-hand side, then Add-Program...) that runs MBTextPad.bat. The parameters should be $FileName $BaseName.mbp $BaseName.err including all of the quotes. Make sure you have allow multiple instances unchecked in Configure-Preferences General or it will open the .err file in a separate instance. This method will even work for MapBasic source files whose names have spaces in them (TextPad is a little too helpful putting quotes around parameter values with spaces in them). Perhaps someone is willing to write a VBScript to make this a bit less clunky. HTH Spencer -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Richard Greenwood Sent: Wednesday, July 26, 2006 8:59 AM To: Manson, Tom, VF UK - Technology (TS) Cc: mapinfo-l@lists.directionsmag.com Subject: Re: [MI-L] TextPad as editor for MapBasic On 7/26/06, Manson, Tom, VF UK - Technology (TS) [EMAIL PROTECTED] wrote: Keen MapBasic folk, We are investigating the use of TextPad as our editor for MapBasic. Does anyone have experience of this? I know that there is an add-on (on TextPad's website) containing all the key words etc, but does someone have a new version of this? Also, how can we get the error messages to appear, as they would in MapBasic? Thanks in advance, Tom I use Textpad all the time for MapBasic and numerous other languages. It's an excellent editor. I have not figured out how to get the error messages back. It has a mechanism for doing it with Java compilers, so it should be do-able. -- Richard Greenwood [EMAIL PROTECTED] www.greenwoodmap.com ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] Workspace Error In Proviewer
Leith, I guess this section must be stored some where and it keps getting loaded whenever you start up MapInfo, or it has been written to so many workspaces that you'll get it whenever you open one of these. You should actual be able to just delete the section, open the workspace and try to save it again. If it is gone, it comes from the workspaces. If it is still there, I guess it can be located in MapInfow.wor or Startup.wor that MapInfo loads on startup. You could try searching you file system for these files, and see if they contain this section. Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis "For enden af regnbuen..." - hvordan kommer man dertil og er det overhovedet muligt?Læs mere om årets MapInfo konference på www.cowi.dk/mapinfokonference From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]Sent: Thursday, July 27, 2006 10:23 PMTo: MapInfo-L@lists.directionsmag.comSubject: [MI-L] Workspace Error In Proviewer Fellow users, I am having a problem with workspaces that I have created on a particular PC using MapInfo Professional 8.0 when trying to open them with ProViewer 8.0 or 8.5. I get a Unrecognized command:Button error, and the another on saying the workspace has not fully opened. Not a major problem but rather an annoyance. Below is the code that gets written into the workspace. I do not know why it get written and this only seems to be happening on this machine that has Professional 8.0 loaded. It has to be a setting somewhere. Does anybody know how to stop this code from being written. Also as far as I know the machine has never had a digitizer attached to it. Set Digitizer (2069790.05,726234.152) (15216,7349) Label "Pt 1", (2069543.7,725895.055) (13973,5681) Label "Pt 2", (2069489.070001,725699.348) (13690,4707) Label "Pt 3" CoordSys Earth Projection 3, 62, "survey ft", -79, 33.75, 34.33, 36.17, 200, 0 Units "survey ft" Width 36000 Height 24000 Resolution 1000, 1000 Button 1, 2 Mode Off Thanks for any help! Leith C. BrittTown of CaryTechnology ServicesGIS/Database Analystphone: 919-469-4383fax: 919-319-4597web: townofcary.org ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] Workspace not opening
Title: Workspace not opening Christine, Didn't it open anything ? Can't you make a map or browse a table ? You could try to add some Print statements to the workspace. In this way you can see if MapInfo stops loading the workspace at a certain point. I would recommend that you add a Print statement before the "Open Table ..." commands and before every "Map From ..." and "Set Map ..." command It could look like this in the workspace: !Workspace !Version 450 !CharSet WindowsLatin1 Print "Opening tables ..." Open Table Open Table Open Table Open Table Open Table Print "Done opening tables..." Print "Creating first map ..." Map From Print "1 Setting upfirst map..." Set Map ... Print "2 Setting upfirst map..." Set Map ... ... Note "Done loading workspace!" HTH, Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis "For enden af regnbuen..." - hvordan kommer man dertil og er det overhovedet muligt?Læs mere om årets MapInfo konference på www.cowi.dk/mapinfokonference From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ronning, ChristineSent: Thursday, July 27, 2006 8:58 PMTo: MapInfo-L@lists.directionsmag.comSubject: [MI-L] Workspace not opening Hi all, I'm trying to open a workspace that hasn't been opened in about 6 months. Some of my file paths have changed, but I've sourced the files when requested by the prompts when opening the workspace. This all goes fine and then the little timer symbol comes up like the workspace is about to open. However once the timer goes away the screen is blank just like I didn't try to open anything! I've tried opening other workspaces and they are coming up fine. Does anyone have any thoughts? Thanks! Christine ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] Dialog box variables not populating
Title: RE: [MI-L] Dialog box variables not populating Dave, This is the typical mistake when working with dialogs and reading values in a handler. The values on the controls are not written to the variables assigned to the controls until the dialog has been dismissed. And the dialog has not been dismissed when you are within a handle of the same dialog. To read values from a running dialog, you should use the ReadControlValue() function: SUB Mission0EllipseOKButtonCalling Print Ok button pressed from Ellipse dialog s_EllipseCentreLat = ReadControlValue( Edit1ID) 'where Edit1ID is the ID of the control to read the value from Print Time(24) s_EllipseCentreLat END SUB HTH, Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis For enden af regnbuen... - hvordan kommer man dertil og er det overhovedet muligt? Læs mere om årets MapInfo konference på www.cowi.dk/mapinfokonference -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of [EMAIL PROTECTED] Sent: Wednesday, July 26, 2006 8:29 AM To: MapInfo-L@lists.directionsmag.com Subject: [MI-L] Dialog box variables not populating I have a very strange problem: First I have a global definition: Global s_EllipseCentreLat AS STRING I have a menu option which calls a dialog box. The dialog box has this code: DIALOG POSITION 491, 359 WIDTH 165 HEIGHT 153 TITLE Create Ellipse CONTROL EditText POSITION 73, 27 WIDTH 80 HEIGHT 12 ID Edit1ID Value 0.001 INTO s_EllipseCentreLat CONTROL OKButton POSITION 47, 130 WIDTH 38 HEIGHT 14 'ID OK1ID TITLE OK CALLING Mission0EllipseOKButtonCalling So, it's basically edit test box an OK button. The handler looks like this: SUB Mission0EllipseOKButtonCalling Print Ok button pressed from Ellipse dialog Print Time(24) s_EllipseCentreLat END SUB The really strange thing is that when I run the dialog press Ok, I get the correct time printed out, with no variable value. When I run the dialog the second time press Ok, I get the correct time followed by 0.001 which was the original value! It seems the variable is not populated when the Ok button is pressed, but at some stage after that. If I change the value of the variable I don't see that new value after pressing the Ok button, but instead see it the NEXT time I press the Ok button - it seems to be lagging behind. Anyone know why this happens? I've never had any trouble like this before and am mystified as to what is causing it. (MapInfo 8.0 MapBasic 8.0) Thanks, Dave ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] tool to get bounds in MapInfo Pro
Title: Message Fred, There is such a function. You just need to know where to look ;-) Here is a update statement, that you can use from the MapBasic window - just remember to select all five lines before you hit the Enter key Update MYTABLE Set MINX = ObjectGeography(OBJ, 1), MINY= ObjectGeography(OBJ, 2), MAXX= ObjectGeography(OBJ, 3), MAXY= ObjectGeography(OBJ, 4) HTH, Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis "For enden af regnbuen..." - hvordan kommer man dertil og er det overhovedet muligt?Læs mere om årets MapInfo konference på www.cowi.dk/mapinfokonference From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Fred WilliamsSent: Wednesday, July 26, 2006 9:36 PMTo: MapInfo-L@lists.directionsmag.comSubject: [MI-L] tool to get bounds in MapInfo Pro Hello, I am looking for a tool that will look at the region objects in an open table and create or update columns with the bounds of that region object. I am surprised that there doesn't seem to be a built in function like the centroid function that I can just run as an update query. Thanks Fred Williams Offroute, Inc. ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] SerachInfo, SearchRect and SearchPoint or .....something else ?
Title: Message Chris, You can always create a polygon from your circle and use this to select the objects with. This can be done thru SQL: oCircle = Buffer(CreatePoint(X,Y), 24, fRadius, "m") Select * From MYTABLE Where OBJ Within oCircle Into Selection You can of course use Entirely Within or Intersects in stead of Within - depending on your requirements. As far as I remember you can also thru MapX (and MapXtreme2004 ?) do a dynamic selection with a circle, where the selection changes when you make the circle smaller og bigger Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis "For enden af regnbuen..." - hvordan kommer man dertil og er det overhovedet muligt?Læs mere om årets MapInfo konference på www.cowi.dk/mapinfokonference From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Christophe BrabantSent: Tuesday, July 25, 2006 4:32 PMTo: mapinfo-l@lists.directionsmag.comSubject: [MI-L] SerachInfo,SearchRect and SearchPoint or .something else ? Hi There are at least 4 selection modes on a map : - by clicking a point (SearchPoint(x,y)) - by selecting a rectangle (SearchRectangle(x1,y1,x2,y2) - by selecting all the objects included into a closed polygon - by selecting a circle witha variableradius : in this case, how to query (by program) the objects included into the circle ? Not with SearchPoint, not with SearchRect, Thank you Chris ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] combine close-together lines
Ash, You can use the Snap/Thin function. This will allow you to snapnodes close together, and when you later combine these, they will become one node and so one object Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis "For enden af regnbuen..." - hvordan kommer man dertil og er det overhovedet muligt?Læs mere om årets MapInfo konference på www.cowi.dk/mapinfokonference From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Simmonds, Ashley (DTEI)Sent: Tuesday, July 25, 2006 6:10 AMTo: mapinfo-l@lists.directionsmag.comSubject: [MI-L] combine close-together lines hello, i have a few hundred bus route layers that i'm trying to get a rough distance figure on. now most of these routes travel along the same arterial trunks for some portion of their journey, i'd like to combine any routes that do this so that portion is only counted once in the distance aggregate. problem is most of these lines don't overlap cleanly, they are often a metre or so apart... enough so that when i combine the objects, they are still separate lines. how can i combine lines that are close together and parallel? ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] Thematic legends getting truncated
Robin, Yes, you are right. This is a known issue. But I think the problem is only on the screen, so when you print the layout window, the legend should be complete. Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis "For enden af regnbuen..." - hvordan kommer man dertil og er det overhovedet muligt?Læs mere om årets MapInfo konference på www.cowi.dk/mapinfokonference From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Robin SmithSent: Friday, July 21, 2006 1:16 PMTo: mapinfo-l@lists.directionsmag.comSubject: [MI-L] Thematic legends getting truncated Hi All, Has anyone else experienced difficulties in editing thematic legend windows? Occasionally, when I insert a thematic map legend in a layout window, the bottom and right parts of the legend are truncated, resulting in missing text and symbols. I've tried a few things to overcome this, including altering the frame dimensions and also going into the legend properties to alter the swatch. Neither of these seem to help. I understand that this is a known problem, but is there any way of overcoming this? I'm using Pro version 8. I've been advised to just create a standard map legend of just the thematic layer, but this seems to be an inconvenient way of doing things, especially if MapInfo creates a legend anyway for thematic maps. Thanks for any response Robin Smith GIS Assistant GIS team, ICT South Gloucestershire Council 01454 863407 ** This email and any files transmitted with it from South Gloucestershire Council are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the South Gloucestershire Council Postmaster at the address below. This footnote also confirms that this email message has been swept for the presence of computer viruses. [EMAIL PROTECTED] ** ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] layer grouping
Hi, One way to achieve this, would be using Seamless tables. I know mostly seamless tables are used for raster files, but they can also be used for vector files. This does require that the tables have the same table structure (same columns and same order of these) So you could make a seamless table containing your utilities. When the user pens this table, the user will actually open up all 4 tables. MapInfos next generation Desktop GIS will support the concept of grouped layers, but that doesn't help you at the moment. Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis For enden af regnbuen... - hvordan kommer man dertil og er det overhovedet muligt? Læs mere om årets MapInfo konference på www.cowi.dk/mapinfokonference -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill Thoen Sent: Friday, July 21, 2006 3:45 PM To: greg Cc: mapinfo-l@lists.directionsmag.com Subject: Re: [MI-L] layer grouping On Fri, Jul 21, 2006 at 09:45:34PM +1200, greg wrote: does anyone know if i can (MI 8.5) group layers for layer management. eg lets say 1 want to display utilities. utilities may comprise of 4 layers (say water, waste water, stormwater etc). i want users not to have to click to turn on each layer, but just click to turn on utilities - then easily switch to say zoning (which again may comprise many layers) MapInfo doesn't support this concept, but it sure would be a nice feature. But it's not a straight-forward problem if you also want to manage layer position control (e.g. do the Utilities power lines display above the Hydrology group's rivers and the Transportation group's roads?) However, building a higher-level layer control that allowed the user to work with layer groups to the extent of turning their display on and off, either as a group or individually, would be do-able and would be useful. I've seen one application where this was done using a Visual Basic tree control connected to MapInfo via DDE, which worked quite well. But it was rather hard-coded for the application and wouldn't work for general use. This is a tool that still needs to be built. (So if anyone's bored some day and is looking for a small project they could sharpen their MapBasic skills on, this might be just the thing! - Bill Thoen ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] DBMS problems; making tables mappable.
Hi, Is the name of the column "X Coord" or "X_Coord" or "XCoord" ? If the first is the name of you column, I will suggest that you rename it, so that the space is removed Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis "For enden af regnbuen..." - hvordan kommer man dertil og er det overhovedet muligt?Læs mere om årets MapInfo konference på www.cowi.dk/mapinfokonference From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Robin SmithSent: Wednesday, July 19, 2006 10:52 AMTo: mapinfo-l@lists.directionsmag.comSubject: [MI-L] DBMS problems; making tables mappable. Hi All, I'm having trouble mapping data from an Access 2000 database in MapInfo version 8. I havecreated the MapCatalogue for the DBMS connection, using the Microsoft Access .mdb machine data source and MapInfo tells me that the Catalogue item has been created successfully. Then, using the Make DBMS Table Mappabletool, I've selected the table from Access that I would like to create points from and have told MapInfo which columns I would like to use forX andY coordinates. The columns in the Access table are set up as number; double, yet MapInfo tells me that the column 'X Coord' doesn't exist in the Access table and therefore ends the process of making the table mappable. I don't know why this happens; I've tried (in MS Access) changing theX Coord column to integer and long integer and get the same errors. The table isn't linked or anything; it was imported from an Excel spread sheet, but is now independent from it. I would be grateful for any advice on this. Best regards, Robin Smith GIS Assistant GIS team, ICT South Gloucestershire Council 01454 863407 ** This email and any files transmitted with it from South Gloucestershire Council are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the South Gloucestershire Council Postmaster at the address below. This footnote also confirms that this email message has been swept for the presence of computer viruses. [EMAIL PROTECTED] ** ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] Refreshing a map after deleting objects
David, Make sure that you haven't turned off the Map Redraw and forget to turn it on again. This is done with the Set Map Redraw Off command. If you have used this remember to turn it on again with Set Map Redraw On You could also try changing your Update Window WindowID(WIN_MAPPER) to Update Window frontWindow(). I assume that the front window is the map window in question here I have seen this behaviour myselv a few times, and have also in some cases been desperate enough to do a change of zoom thru MapBasic to update the map. Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis For enden af regnbuen... - hvordan kommer man dertil og er det overhovedet muligt? Læs mere om årets MapInfo konference på www.cowi.dk/mapinfokonference -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Baker Sent: Tuesday, July 18, 2006 2:12 PM To: MapInfo-L@lists.directionsmag.com Subject: [MI-L] Refreshing a map after deleting objects I am drawing some polylines in a layer called Predictions. When I toggle a button I want all the polylines to disappear. In fact I'm happy to kill the whole table. I am using the following code where I have 4 lines of code that I thought would have wiped the polylines off my map. However, even with all these different methods, the polylines still stay in view on the map. For cownt = 1 to NumTables() If TableInfo(cownt, TAB_INFO_NAME) = Predictions Then Remove Map Layer Predictions ' should remove the layer from the map Drop Map Predictions ' should get rid of the map layer completely Drop Table Predictions ' should delete the table/layer completely Update Window WindowID(WIN_MAPPER) ' should refresh the map window Exit For End If Next If I zoom in or out, or even open the Layer Control box press OK, the polylines from the Predictions layer on the map disappear, so the code above is actually working, but none of the methods will get rid of the polylines. Does anyone know any more methods that will work? I'm almost desperate enough to force a zoom at the same scale as the map window is already, but only as a last resort. I am using MI 8.0 MB 8.0, but would prefer a solution that will work with MI 4.5 if possible. Thanks, Dave ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] List of open files [SEC=UNOFFICIAL]
Percy, You wonder how many of the most common used functions in MapBasic you actually have to write yourself ;-) This is one of those, but it is quite simple to write. Function GetListOfOpenTables(arrTabs() As String) As Integer Dim nTab As Integer GetListOfOpenTables = 0 Redim arrTabs(NumTables()) For nTab = 1 To NumTables() '**Here you could laos add conditions, only base tables,not semaless tables, only mappable ... arrTabs(nTab) = TableInfo(nTab, TAB_INFO_NAME) Next GetListOfOpenTables = Ubound(arrTabs) End Function HTH, Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis "For enden af regnbuen..." - hvordan kommer man dertil og er det overhovedet muligt?Læs mere om årets MapInfo konference på www.cowi.dk/mapinfokonference From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bell, PercySent: Monday, July 17, 2006 7:41 AMTo: MapInfo-L@lists.directionsmag.comSubject: [MI-L] List of open files [SEC=UNOFFICIAL] Guys, I am trying to adapt a packager program for our own archiving. But I have been tearing my hair out trying to find a command in Mapbasic to return a list of open tables and queries. Can anybody help? Cheers Percy Percy Bell Research Statistics and Technology Branch Phone: (02) 6271 1463 Mob: (0415) 260 805Fax: (02) 6271 1144Department of Communications, Information Technology and the Arts GPO Box 2154, Canberra ACT 2601 AustraliaURL:http://www.dcita.gov.auEmail: [EMAIL PROTECTED] ___Theinformationtransmittedisfortheuseoftheintendedrecipientonlyandmaycontainconfidentialand/orlegallyprivilegedmaterial.Anyreview,re-transmission,disclosure,disseminationorotheruseof,ortakingofanyactioninrelianceupon,thisinformationbypersonsorentitiesotherthantheintendedrecipientisprohibitedandmayresultinseverepenalties.Ifyouhavereceivedthise-mailinerrorpleasenotifytheSecurityAdvisoroftheDepartmentofCommunications,InformationTechnologyandtheArts,telephone(02)6271-1880anddeleteallcopiesofthistransmissiontogetherwithanyattachments.Forallotherenquiriespleasering(02)6271-1000.___ ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] Combining Intersecting regions in mapbasic
Title: RE: [MI-L] Combining Intersecting regions in mapbasic Boyd, Could the problem be that you forget to delete the selected records ? When you find more than one record that intersects with your new polygon, you need to delete all these but one, which is the one, that will hold the new object that is the combination of the other objects. Something in this way: '**Select records intersecting into INTERSECTING__RECORDS Fetch First >From INTERSECTING__RECORDS Do Until EOT(INTERSECTING__RECORDS) nRowID = INTERSECTING__RECORDS.ROWID oIntersect = INTERSECTING__RECORDS.OBJ oCombined = Combine(oCombined, oIntersect) If nFirstRowID = 0 Then nFirstRowID = nRowID Else Delete From INTERSECTING__RECORDS Where ROWID = nRowID End If Fetch Next From INTERSECTING__RECORDS Loop Update INTERSECTING__RECORDS Set OBJ = oCombined Where ROWID = nFirstRowID I think that should do it and it should also work only a single record intersects the newly drawn polygon Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis For enden af regnbuen... - hvordan kommer man dertil og er det overhovedet muligt? Læs mere om årets MapInfo konference på www.cowi.dk/mapinfokonference -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Boyd Townsend Sent: Sunday, July 16, 2006 2:13 PM To: mapinfo-l@lists.directionsmag.com Subject: [MI-L] Combining Intersecting regions in mapbasic I have a problem which is bugging me to death. I can get this about 80% of the way but it is just not quite right. Having had two previous great pieces of help from this forum, I am sure someone will point me in the right direction. - Please I attempting, in map basic, to automaticaly have a newly drawn Region combine with an existing region without intervention on the part of the user when the two intersect. I am having no trouble with this using a combine statement along with intersect when the newly drawn region crosses over only one existing region, although I have problems when it crosses two or more existing regions. (Both existing regions comine with the newly drawn one, but the existing regions combined with the new one stay separate). I want all the intersecting regions to automatically combine. In other words, we have a region which shows some burnt land, we then add an additonaly region of burnt land and the two combine together automatically. If there is two existing separate regions of burnt land and the user draws a new area which intersects both I want them to all to become one, this is where I have a problem. Any sugestions on overcoming this Cheers, Boyd Townsend CSO NSW Rural Fire Service This email message is intended only for the addressee(s) and contains information which may be confidential. If you are not the intended recipient, please notify the sender and delete this email and any copies or links to this email completely and immediately from your system. Views expressed in this message are those of the individual sender, and are not necessarily the views of the NSW Rural Fire Service. ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] MapBasic - Expanding Munged filenames on the MapInfoRecentFiles menu
Title: Re: [MI-L] MapBasic - Expanding Munged filenames on the MapInfoRecentFiles menu I see two possible places to store that information: 1. The MapInfow.prf where MapInfo normally stores the preferences 2. The Registry Unfortunately I'm at the moment sitting at a computer with no MapInfo installed (!!!), so I can't test it Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 5260 Odense S. Denmark Tel + 456311 4900 Dir+45 6311 4908 Mob+45 5156 1045 Fax + 45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk From: [EMAIL PROTECTED] on behalf of Uffe KousgaardSent: Fri 14-Jul-06 08:45To: Mapinfo-LSubject: Re: [MI-L] MapBasic - Expanding Munged filenames on the MapInfoRecentFiles menu From: "Bill Thoen" [EMAIL PROTECTED] Or does MI keep a full copy of the filename hidden behind the menu and just display the munged version?That is almost 100% certain.RegardsUffe___MapInfo-L mailing listMapInfo-L@lists.directionsmag.comhttp://www.directionsmag.com/mailman/listinfo/mapinfo-l ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] Make a whole in a region object
Title: RE: [MI-L] Make a whole in a region object Well, if you need to do this 100 times a day, I can see a need for a tool that makes this process easier. 1. Draw hole with special tool - 1a. The hole searches for objects in a certain layer, could be the editable layer - 1b. For each found object, it erases the part of the object, that is within the hole 1 step is a lot easier than7 ;-) And I can even give you some part of the code, bear with me as I don't have MapBasic Help or my normal editor here to help me check the spelling and the defines and functions used: Sub ToolEraser '**This is the procedure called by your toolbutton, '**that should have a POLYGON draw_mode Dim oEraser, oToBeErasedAs Object, nMID, nRowIDAs Integer, sLayer As String oEraser = CommandInfo(CMD_INFO_COSTUM_OBJ) nMID = FrontWindow() '**Check that the frontwindow exists and is a mapper sLayer = MapperInfo(nMID, MAPPER_INFO_EDITABLE_LAYER) Select * from sLayer Where OBJ Intersects oEraser Into OBJS__TO__ERASE NoSelect Fetch First From OBJS__TO__ERASE Do Until EOT(OBJS__TO__ERASE) nRowID = OBJS__TO__ERASE.ROWID oToBeErased = OBJS__TO__ERASE.OBJ oToBeErased = Erase(oToBeErased, oEraser) Update OBJS__TO__ERASE Set OBJ = oToBeErased Where ROWID = nRowID Fetch Next From OBJS__TO__ERASE Loop End Sub This is pretty much what you need. I you want to store the Eraser object, you just need to insert that into a layer at the end of the procedure HTH, Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 5260 Odense S. Denmark Tel + 456311 4900 Dir+45 6311 4908 Mob+45 5156 1045 Fax + 45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk From: [EMAIL PROTECTED] on behalf of Warren Vick, Europa Technologies Ltd.Sent: Fri 14-Jul-06 10:33To: 'Mapinfo-L'Subject: RE: [MI-L] Make a whole in a region object and don't' forget to:7) Delete "hole"I can't remember how many times I've left an "eraser" object in a layer byaccident.Regards,Warren VickEuropa Technologies Ltd.http://www.europa-tech.com-Original Message-From: [EMAIL PROTECTED][mailto:[EMAIL PROTECTED]] On Behalf Of UffeKousgaardSent: 14 July 2006 07:54To: Mapinfo-LSubject: Re: [MI-L] Make a whole in a region objectThis is already possible with a few steps in MapInfo. I don't think you canmake it much simpler by writing a tool.1) Make layer editable2) Select the region3) Objects Set Target (ctrl T)4) Draw "hole"5) Select "hole"6) Objects EraseDone.Kind regardsUffe Kousgaardwww.routeware.dk- Original Message -From: "Boyd Townsend" [EMAIL PROTECTED]To: mapinfo-l@lists.directionsmag.comSent: Friday, July 14, 2006 8:03 AMSubject: [MI-L] Make a whole in a region object Can anyone assist. I am wanting to develop a simple tool for a user which will essentialy make a hole in a region object. For example. We have a region object which depicts an area of land burnt by fire. Within that region there are small pockets which were not burnt. We would like to be able to draw in those unburnt portions into the existing region. Essentially the user would draw a small area within the existing region which would then be erased from that region making a hole in it. (If this makes Sense). Can anyone make a suggestion on what road I would best take to acheive this??? In anticipation - Thanks Boyd Townsend CSO - Northern Rivers NSW Rural Fire Service This email message is intended only for the addressee(s) and contains information which may be confidential. If you are not the intended recipient, please notify the sender and delete this email and any copies or links to this email completely and immediately from your system. Views expressed in this message are those of the individual sender, and are not necessarily the views of the NSW Rural Fire Service. ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l___MapInfo-L mailing listMapInfo-L@lists.directionsmag.comhttp://www.directionsmag.com/mailman/listinfo/mapinfo-l___MapInfo-L mailing listMapInfo-L@lists.directionsmag.comhttp://www.directionsmag.com/mailman/listinfo/mapinfo-l ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] Zoom Layering
Title: Zoom Layering Stu, I guess you'll have to ask the MapperWindow for the current zoom and then compare that with the zoom of the layer: Set Distance Units "m" 'or "mi" or "km" or whatever you want fZoom = MapperInfo(sMapWinID, MAPPER_INFO_ZOOM) fZoomMin = LayerInfo(sMapWinID, sLayerNumber, LAYER_INFO_ZOOM_MIN) fZoomMax = LayerInfo(sMapWinID, sLayerNumber, LAYER_INFO_ZOOM_MAX) If fZoom Between fZoomIn and fZoomMax Then '**Yes, the layer is now visible in the map Else '**No, the layer is not visible in the map End if HTH, Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis "For enden af regnbuen..." - hvordan kommer man dertil og er det overhovedet muligt?Læs mere om årets MapInfo konference på www.cowi.dk/mapinfokonference From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Gibb, StuartSent: Wednesday, July 12, 2006 3:31 PMTo: mapinfo-l@lists.directionsmag.comSubject: [MI-L] Zoom Layering Hi guys, I have a layer and Zoom layering is enabled sLayerZoom = LayerInfo(sMapWinID, sLayerNumber, LAYER_INFO_ZOOM_LAYERED) sLayerZoom = T Any idea how I determine if I am within the zoom range ? i.e. at a distance from earth so that I can see the layer ? LAYER_INFO_DISPLAY doesnt do it for me Thanks in advance Stu Visit our website at http://www.halcrow.com The contents of this email are confidential, for the sole useof the intended recipient at the email address to which it hasbeen addressed and do not give rise to any binding legalobligation upon Halcrow companies unless subsequently confirmedon headed business notepaper sent by fax, letter or as an emailattachment. Whilst reasonable care has been taken to avoid virustransmission, no responsibility for viruses is taken and it isyour responsibility to carry out such checks as you feelappropriate. Emails supplied are as found and there's noguarantee that the messages contained within the body of theemail have not been edited after receipt. If you receive thisemail in error, please contact the sender immediately and deletethe message from your system.Thank you.- ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] Points to Regions
Title: RE: [MI-L] Points to Regions Brendan, I see two ways of doing this in MapInfo without writting any MapBasic code. 1. Convex Hull will put a rubberband around your points and convert this rubberband into a region. The resulting region object(s) are based on the nodes from the input object. The Convex Hull operation can be thought of as an operator that places a rubber band around all of the points. It consists of a minimal set of points such that all other points lie on or inside the polygon. Since the polygon is convex, no interior angles are greater than 180 degrees. from the MapInfo User Guide 2. Voronoi will convert each point to an area that will cover the area closer to this point than any other point. The Voronoi polygon is a partition of space into cells. Voronoi takes points and produces regions (cells) as output where each cell contains exactly one point. Each cell is an area in which the contained points are closer to the enclosed site than to any others. Use Voronoi to generate these polygons from a designated set of points. It is useful for dividing areas of responsibilities for field offices or possibly postal zones. It ultimately gives you the areas that are closest to your point of interest. from the MapInfo User Guide If you use the second, you will afterwards have to combine the objects with the same common attribute into one region. Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Brendan Tagg Sent: Thursday, July 06, 2006 7:38 AM To: mapinfo-l@lists.directionsmag.com Subject: [MI-L] Points to Regions Hi list, I have bunches of points that need to be grouped together by an common attribute and then each group converted into seperate region. Does anybody know of a way to convert the foot print or a set of points make into a polygon / region. I have tried to query for one type and then buffer the objects (with the create single object option) but this creates a too course an object with excessive overlap because a circle shape is used. EG for 1 particular group of points 'x' the output should be From x x x /x-- x- x\ x / x\_ xx xxx Should become |xx xxx| x xxx x xxx \x xxx x xxx-/ x x x x \-x---x-x-x/ I am happy to write something in Mapbasic if I could figure out the algorithm (but a ready made tool would be better) Hope this makes sense - any and all help is appreciated. Brendan Tagg Coles Myer Ltd. This email and any attachments may contain privileged and confidential information and are intended for the named addressee only. If you have received this e-mail in error, please notify the sender and delete this e-mail immediately. Any confidentiality, privilege or copyright is not waived or lost because this e-mail has been sent to you in error. It is your responsibility to check this e-mail and any attachments for viruses. No warranty is made that this material is free from computer virus or any other defect or error. Any loss/damage incurred by using this material is not the sender's responsibility. The sender's entire liability will be limited to resupplying the material. ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] Auditing edits made to mapinfo tables.
Rich, I agree with you on this point. MapInfo hasn't been very good at giving feedback to the person entering the problem. I think this is simply because they didn't track that information. They didn't know who send in the bug or feature request. But I also think this is changing. They have implemented a new system for - at least feature requests - where the request is connected to a name and a email address. This should give them the possibility to contact the person who send in the request and even ask for more detail. I must admit that I still need to see that part work ;-) But they seem to be heading in the right direction. When you get a bug reported, you should get a bug number. This can be used to track the bug, not interactively on a web site, but fore instance via email. But you are right. It is a serious problem for MapInfo, if their costumers don't feel that they are heard. Especially as MapInfo keep saying that they want to listen to the costumers. Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis -Original Message- From: Richard Greenwood [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 05, 2006 11:55 PM To: Peter Horsbøll Møller Cc: mapinfo-l@lists.directionsmag.com Subject: Re: [MI-L] Auditing edits made to mapinfo tables. On 7/5/06, Peter Horsbøll Møller [EMAIL PROTECTED] wrote: Rich, I have to disagree here. Many of the improvemnets that has been made during the last versions of MapInfo Pro have been made because users have asked for them. The best way to make MapInfo aware of you wish is to send the wish to your MapInfo contact person. This may be a MapInfo Partner or a person at MapInfo Corp. For MapInfo Pro wishes I would recommend either Moshe Binyamin for the US region and Tom Probert in the EMEA region. Peter, Thanks for your comments, your positive attitude, and your many help posts to the list. I have used MapInfo Pro since version 3.0 and consider it to be a very good product. Over the years I have run into various bugs and communicated them thru my MI Business Partner, and directly to Moshe B. on a couple occasions. Personally, I have been disapointed with the ressponse I received. I can remember only one occasion in which a bug was fixed mid-release (and this was a bug that I had reported in the previous release). Many projects use Bugzilla which allows users to track the progress of bug fixes, place feature requests, and receive notification upon resolution. It is a far more satisfying experience when a user fells that their input is tracked and respected, rather than having to plead with a reseller (Business Partner) who may or may not fully comprehend your problem, or get a direct dialog with a senior engineer. My point, which may have come off with an overly cynical tone, was that MapInfo has done little encourage my participation in the improvement of their product. Lest I start a flame war, I will leave it at that. Rich -- Richard Greenwood [EMAIL PROTECTED] www.greenwoodmap.com ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] Auditing edits made to mapinfo tables.
Rich, I have to disagree here. Many of the improvemnets that has been made during the last versions of MapInfo Pro have been made because users have asked for them. The best way to make MapInfo aware of you wish is to send the wish to your MapInfo contact person. This may be a MapInfo Partner or a person at MapInfo Corp. For MapInfo Pro wishes I would recommend either Moshe Binyamin for the US region and Tom Probert in the EMEA region. Just to mention a few improvement that could have been a result of questionlately on the list: - Move a layer from one map to another - Combine two maps into one - Improved printing engine. The 28000 pixel limit is gone - Larger number of points in buffer (from 100 to 500) - Preference for area and distance units - Copy text from message and statistic window - GeoPrinter included on installation cd - Server Refresh button works on Live tables as well as Linked These might look as huge improvements, but for the daily user, they are very helpfull. So, remember to let MapInfo know what you need. Tracking is a different story. I can see why they don't want to publish their problems and list of new ideas to the public. And of course do MapInfo like to have your money. Otherwise they wouldn't exist anymore. Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Richard Greenwood Sent: Wednesday, July 05, 2006 3:08 AM To: [EMAIL PROTECTED] Cc: mapinfo-l@lists.directionsmag.com Subject: Re: [MI-L] Auditing edits made to mapinfo tables. On 7/4/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Once submitted, do suggestions have a tracking number? Can we track their progress? They don't even let us users track bugs, let alone feature requests! It really discourages user participation. All MI wants from us is our credit card number. Rich -- Richard Greenwood [EMAIL PROTECTED] www.greenwoodmap.com ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] Auditing edits made to mapinfo tables.
Title: Auditing edits made to mapinfo tables. Mathew, MapInfo isn't that good at these kind of things, not when working in the native tab format. You would need to write your own tools for doing all the operations - that would be quite a job. I would recommend using a Spatial Database in stead. You can then make the database system keep track of all the changes, even tore them in a separate table, so that you have access to the previous version of every record. MapInfo 8.0 introduced support for Oracle Workspaces. This is actual exactly what you are looking for. You can setup a table to keep track of every change, and this can be done from within MapInfo. The changes at stored in a separate table that with a small amount of work can be opened and viewed in the map as well. Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mathew LinnaneSent: Tuesday, July 04, 2006 1:10 AMTo: mapinfo-l@lists.directionsmag.comSubject: [MI-L] Auditing edits made to mapinfo tables. I need to create an audit trail of all edits made to a certain mapinfo table. The Audit trail must include user ID, Date, Time etc. Can mapinfo facilitate any form of auditing? All ideas would help. Regards, Mathew Linnane GIS/LIS AssetsOfficer. Queanbeyan City Council. 257 Crawford Street Queanbeyan NSW 2620. Bus: (02) 6298 0205 Fax: (02) 6297 4044 Mob: 0412 565 552 Email: [EMAIL PROTECTED] + "This message is intended for the addressee named and may contain confidential information. If you are not the intended recipient, please delete it and notify the sender. Views expressed in this message are those of the individual sender, and are not necessarily the views of Queanbeyan City Council, unless otherwise stated. For the purposes of the Copyright Act, the permission of the holder of copyright in this communication may be taken to have been granted, unless stated otherwise, for the copying or forwarding of this message, as long as both the content of this communication and the purpose for which it is copied or forwarded are work related." + ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] Create buffers
Hi, You can do this very easily with the Table Buffer function. You can even create a new table from within this procedure. Alternatively just remember that when using Objects Buffer, the buffers are inserted into the editable layer. Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Lee MorrisSent: Tuesday, July 04, 2006 11:56 AMTo: mapinfo-l@lists.directionsmag.comSubject: [MI-L] Create buffers Can anybody help? How can I create buffers around points on a map, and save the buffers created into a separate table? Please help!! Lee Morris Mouchel Parkman Services Ltd Cunard Building Water Street Liverpool L3 1ES mailto: [EMAIL PROTECTED] Tel 0151 242 x.358 Fax 0151 242 7704 The information in this e-mail is confidential and intended to be solely for the use of the addressee(s) and may contain copyright and/or legally privileged information. If you are not the addressee (or responsible for delivery of the message to the addressee) please e-mail us at [EMAIL PROTECTED] and delete the message from your computer; copying, distribution, use or disclosure of its contents is strictly prohibited. As Internet communications are capable of data corruption no responsibility is accepted for changes made to this message after it was sent. For this reason it may be inappropriate to rely on advice contained in any e-mail without obtaining written confirmation of it. In addition, no liability or responsibility is accepted for viruses and it is your responsibility to scan attachments (if any). Please note that for business purposes, outgoing and incoming emails from and to the company may be monitored and recorded. Mouchel Parkman Services Ltd, Registered in England at West Hall, Parvis Road, West Byfleet, Surrey UK KT14 6EZ Registered No : 1686040 ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] Auditing edits made to mapinfo tables.
Title: Auditing edits made to mapinfo tables. Lars, You are absolutely right. MapInfo certainly known the changes. The problem is - as you write yourself - that these information aren't made availeble in any way. The idea of a log-file is great. I would like to add another request, a RowEditedHandler that could be "caught" within your MapBasic application. This should be seen as a sort of trigger, so maybe we actual need as well a before as an after trigger. Within these it should be possible to detect which column was updated. So what we actual are asking for is a full support for "triggers" thru the MapBasic interface ?! Andyou are right Oracle is just one of the possibilities. But for now, if you are using MapInfo, I can only see a few. Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis From: Lars I. Nielsen (GisPro) [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 04, 2006 2:49 PMTo: mapinfo-l@lists.directionsmag.comCc: Peter Horsbøll Møller; Mathew LinnaneSubject: Re: [MI-L] Auditing edits made to mapinfo tables. I beg to differ.MapInfo Pro knows exactly what records and fields and graphical objects have been edited at any time. The only thing MapInfo Pro's not good at, is making this information available to everyone else.The illusive "transaction files" (TDA, TIN and TMA) contains the information of what edits have been made. Only problem: they're locked when they exist, and deleted when closed. Otherwise I think it would be perfectly feasiable to utilize these to generate an audit trail of some kind.I'll make a simple feature suggestion for MI Pro 9.0 : have Pro add some log of all edits to a table name.log whenever edits are committed. The log file should be in a known, dense, maybe binary, format that could be utilized programmatically. Maybe just rowid+field+timestamp. And add an option to turn this feature on.That said, I too think a more server based approach would be a smarter option for a number of reasons, although I'm sure Oracle isn't the only egg in that basket.Best regards / Med venlig hilsen Lars I. Nielsen GisPro Peter Horsbøll Møller wrote: Mathew, MapInfo isn't that good at these kind of things, not when working in the native tab format. You would need to write your own tools for doing all the operations - that would be quite a job. I would recommend using a Spatial Database in stead. You can then make the database system keep track of all the changes, even tore them in a separate table, so that you have access to the previous version of every record. MapInfo 8.0 introduced support for Oracle Workspaces. This is actual exactly what you are looking for. You can setup a table to keep track of every change, and this can be done from within MapInfo. The changes at stored in a separate table that with a small amount of work can be opened and viewed in the map as well. Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Mathew LinnaneSent: Tuesday, July 04, 2006 1:10 AMTo: mapinfo-l@lists.directionsmag.comSubject: [MI-L] Auditing edits made to mapinfo tables. I need to create an audit trail of all edits made to a certain mapinfo table. The Audit trail must include user ID, Date, Time etc. Can mapinfo facilitate any form of auditing? All ideas would help. Regards, Mathew Linnane GIS/LIS AssetsOfficer. Queanbeyan City Council. 257 Crawford Street Queanbeyan NSW 2620. Bus: (02) 6298 0205 Fax: (02) 6297 4044 Mob: 0412 565 552 Email: [EMAIL PROTECTED] + "This message is intended for the addressee named and may contain confidential information. If you are not the intended recipient, please delete it and notify the sender. Views expressed in this message are those of the individual sender, and are not necessarily the views of Queanbeyan City Council, unless otherwise stated. For the purposes of the Copyright Act, the permission of the holder of copyright in this communication may be taken to have been granted, unless stated otherwise, for the copying or forwarding of this message, as long as both the content of this communication and the purpose for which it is copied or forwarded are work related." + __
RE: [MI-L] Update table crashes for no apparent reason
Mats, I have seen this as well on WinXP. I also do a Pack Table before using the Add Column statement. So it might not just be connected to the OS ... Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mats ElfströmSent: Thursday, June 29, 2006 6:40 PMTo: MapInfo-L@lists.directionsmag.comSubject: [MI-L] Update table crashes for no apparent reason Hi All! I have just come across (and solved) a very strange error in MapInfo Pro 8. I wanted to make a join update, that is add some value from another table for posts where an index field was equal. The code, as used in my program, or displayed in the MapBasic window is like this (tablename and column names altered) Add Column "EditTable" (IN_COLUMN) From SourceTable Set To SOURCE_COLUMN Where COL10 = COL1 For some reason, this line failed on the customers workstation while it had no problem whatsoever on my workstation. The error message was simply "Cannot update table EditTable". No reason was given. I tried to add the string to the MapBasic window with the same result. I tried the GUI, Update Table (which produces the code above). That did not work either. Then I copied the exact table from their computer to mine, and the everything was OK. In short, I was never able to reproduce the error but it occurred every time at the customers office. A a last resort I ran a compress table at the customer, and then the problem went away! Apparently deleted records was the cause, but why not on my computer? Difference: I am running Windows XP, and they are using Windows 2000. Otherwise same MapInfo version, patches and all. I was wondering if anyone has seen this, that a join update fails if the tables has deleted records? Or that MapInfo behaves differently in Win2k and WinXP environments? Hälsning / Best regards Mats.EFB Engineering ABSödra Förstadsgatan 26211 43 MalmöTel: 040-660 25 50Mobil: 0705-27 60 27Fax: 040-660 25 99[EMAIL PROTECTED]www.fbe.se ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] MapBasic
Matt, If you have a "newer" version of MapInfo Pro, you can on the installation cd find a folder called PDF_DOCS. In this folder there is a copy of a number of usefull manuals. You can here find as well the MapInfo User Guide as well as the MapBasic User Guide and MapBasic Reference Guide HTH, Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Matthew DolanSent: Tuesday, June 27, 2006 3:13 PMTo: mapinfo-l@lists.directionsmag.comSubject: [MI-L] MapBasic Hi all: I was wondering if there is a site or book, etc.. that introduces users to MapBasic functionality and commands. I am a heavy user of MapInfo 6.5, but have no programming background. I am thinking that using the MB control would open up a whole new world to me and take my skills to another level. Two main issues I have currently: 1)Labels getting scrambled when I refresh a database. 2)Creating transparent polygons. Thanks and I hope this makes sense to the experts out there. Matt DolanDirector of Market Analytics GISColliers Arnold4350 West Cypress St, Suite 300 Tampa, FL 33607-4175 813.221.2290 813.224.9403 (Fax) www.colliersarnold.com [EMAIL PROTECTED] Colliers Arnold - Tampa / Clearwater / Orlando / Ft. Myers Colliers International - 241 offices in54 countries on six continents This e-mail and attachments (if any) is intended only for the addressee(s) and is subject to copyright. This e-mail contains information which may be confidential or privileged. If you are not the intended recipient please advise the sender by return e-mail, do not use or disclose the contents and delete the message and any attachments from your system. Unless specifically stated, this e-mail does not constitute formal advice or commitment by the sender or Colliers Arnold or any of its subsidiaries. ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] Selecting object types
Title: Selecting object types Christine, There is a few ways of doing this: Select * From MYTABLE Where 1. Str$(OBJ) = "Point" 2. Str$(ObjectInfo(OBJ, 1) = "5" 3. Area(OBJ, "sq m") = 0 And ObjectLen(OBJ, "m") = 0 I would recommend using the second. If you need to find other object type, the values to be used are these (copied from the MapBasic.def): Define OBJ_TYPE_ARC 1Define OBJ_TYPE_ELLIPSE 2Define OBJ_TYPE_LINE 3Define OBJ_TYPE_PLINE 4Define OBJ_TYPE_POINT 5Define OBJ_TYPE_FRAME 6Define OBJ_TYPE_REGION 7Define OBJ_TYPE_RECT 8Define OBJ_TYPE_ROUNDRECT 9Define OBJ_TYPE_TEXT 10Define OBJ_TYPE_MPOINT 11Define OBJ_TYPE_COLLECTION 12 By the way, a different approach would be to export the table to Shape using Universal Translator. This would result in a number of tables named by the object types. Remember that Shape can notcontain different objecttypes in the same file. Then you just need to reimport - or open - the generated Shape files. HTH, Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ronning, ChristineSent: Tuesday, June 27, 2006 7:32 PMTo: David Reid; Bill ThoenCc: mapinfo-l@lists.directionsmag.comSubject: [MI-L] Selecting object types Hi all,Can anyone tell me how to select object types within a table? For example I have a table with points and regions but would like to seperate them out. How would I select just the points? ThanksChristine-Original Message-From: [EMAIL PROTECTED] on behalf of David ReidSent: Tue 6/27/2006 7:50 AMTo: 'Bill Thoen'Cc: mapinfo-l@lists.directionsmag.comSubject: RE: [MI-L] Strange "Find" results geocoding in MI ProViewerI should have added that within the Workspace being used, I have "Insetaddress" from end of street set to zero as these are mainly rural streetsset to 0.001 mile addressing format.Find Using Streets(COL1) Refine Using Communities(COL1) Options Abbrs OffClosestAddr Off OtherBdy Off SymbolInset "0" Distance Units "ft" Offset "15" Distance Units "ft"When I plot the two addresses (that have come to our attention) in Mapinfo,they geocode right where their supposed to. Thus far, all other addressesthat have been searched appear where their supposed to.Additionally, the tables being used are maintained in MI 6.5, but theProviewer we're using is 6.0. I would think that would be an issue though.Strange indeedDave-Original Message-From: Bill Thoen [mailto:[EMAIL PROTECTED]]Sent: Tuesday, June 27, 2006 9:08 AMTo: David ReidCc: mapinfo-l@lists.directionsmag.comSubject: Re: [MI-L] Strange "Find" results geocoding in MI ProViewerOn Tue, Jun 27, 2006 at 08:42:57AM -0500, David Reid wrote: Yesterday, on various addresses entered to the "Find" dialog, it started geocoding some of these addresses as much as 1/2 mile from where theaddress is known to accurately geocode otherwise. Has anyone seen this before and found what causes this problem?Are these addreses supposed to be near the start or end of a long ruralroad? MapInfo's algorithm moves addresses near a road intersection back upthe road about 10% of the length of the segment. This keeps the locationsfrom "bunching up" on intersections in the cities, but it's not helpful inthe country. I think there's a preference setting for this somewhere.--Outgoing mail is certified Virus FreeChecked by AVG Free Edition.Version: 7.1.394 / Virus Database: 268.9.5/376 - Release Date: 06/26/2006___MapInfo-L mailing listMapInfo-L@lists.directionsmag.comhttp://www.directionsmag.com/mailman/listinfo/mapinfo-l ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] Templates for Thematic Mapping Missing After 8.5 Installed
Hi, If you go to Options Preferences Folders, you can see where your Themes Templates are located. They are mostly found here: c:\Documents and Settings\PEM\Application Data\MapInfo\MapInfo\Professional\850\ThmTmplt\ where PEM is your Windows username and 850 is the version of your MapInfo Pro HTH, Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]Sent: Tuesday, June 27, 2006 8:31 PMTo: mapinfo-l@lists.directionsmag.comSubject: [MI-L] Templates for Thematic Mapping Missing After 8.5 Installed Greetings All! Does anyone know how to retrieve templates for thematic maps? After we installed MiPro 8.5 I can't seem to find my templates!!! Yet, when I try to save a new one (saved under the same name as a previous one) it claims that I already have a template by that name! I am sooo confused...someone please help me! :) Akua ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] Creating a line from a series of points
If you know for sure that the points that should be connected, you could connect every point to all the other points, and afterwards delete the records that not are 1 km long. Like this: 1. Add an ID and a JOIN column to your table. Both Integer 2. Update the ID column with ROWID 3. Update the JOIN column with 1 4. Make a copy of your table and open this copy as well. 5. Create a join of the two tables: Select ID, CentroidX(TABLE1.OBJ) "X1", CentroidY(TABLE1.OBJ) "Y1", CentroidX(TABLE2.OBJ) "X2", CentroidY(TABLE2.OBJ) "Y2" From TABLE1, TABLE2 Where TABLE1.JOIN = TABLE2.JOIN And TABLE1.ID TABLE2.ID And Distance(CentroidX(TABLE1.OBJ), CentroidY(TABLE1.OBJ), CentroidX(TABLE2.OBJ), CentroidY(TABLE2.OBJ), "k") between 900 and 1100 6. Save the result as a base table and open it 7. Update the OBJ of the result with CreateLine(X1, Y1, X2, Y2) Note that I have said the distance between the points should be between 900 and 100 meters. You can of course make this smaller, like 990 and 1010 You could do most of it using the MapBasic window. wite these lines and hit Enter at the end of each, except the SQL where you need to write all lines, mark them and hit Enter Alter Table TABLE1 (Add ID Integer, Join Integer) Update TABLE1 Set ID = ROWID, JOIN = 1 'Manualle make a copy and open it Select ID, CentroidX(TABLE1.OBJ) "X1", CentroidY(TABLE1.OBJ) "Y1", CentroidX(TABLE2.OBJ) "X2", CentroidY(TABLE2.OBJ) "Y2" From TABLE1, TABLE2 Where TABLE1.JOIN = TABLE2.JOIN And TABLE1.ID TABLE2.ID And Distance(CentroidX(TABLE1.OBJ), CentroidY(TABLE1.OBJ), CentroidX(TABLE2.OBJ), CentroidY(TABLE2.OBJ), "k") between 900 and 1100 Into RESULT NoSelect 'Manuallesave the table RESULT to diskand open it Update RESULT Set OBJ = CreateLine(X1, Y1, X2, Y2) HTH, Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Uffe KousgaardSent: Thursday, June 22, 2006 7:40 AMTo: Mapinfo-LSubject: Re: [MI-L] Creating a line from a series of points Hi Alan, If your points are completely unordered and you don't know the order, it sounds as if you need to apply a travelling salesman algorithm to determine the best order. Kind regards Uffe Kousgaardwww.routeware.dk - Original Message - From: Alan Silvester To: mapinfo-l@lists.directionsmag.com Sent: Wednesday, June 21, 2006 5:30 PM Subject: [MI-L] Creating a line from a series of points Dear All, Does anybody know how to automatically create a line from a series of points, i.e. rather than drawing a line from point to point, I want to be able to make a line that automatically joins up the points. The problem is, is that the next point to join up with the line may not be the next record in the table?! The points are however all 1km apart. Does anyone have any ideas? Regards, Alan Alan Silvester ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] Wrong Subject on last one: Spatial Query
Title: Wrong Subject on last one: Spatial Query Christine, I'm sure there are a number of ways to do this. Here is mine 1. Make sure that your table contains a column with a unique ID. You could use ROWID to update a numerical column. 2. Use Table Buffer to create a new table of buffers around your points 3. Add a column to hold the number of points, let us call it NUMPOINTS4. Using Table Update Column you can now update you table of buffers with the number of points that fall within each buffer. Update Table "Buffer" Column "NUMPOINTS" Get Values From Table "Points" Where OBJ in Buffer Table "Contains" OBJ in Points Table Calculate Value "Count(*)" 4. Now do a SQL Select: Select "*" From "Points" Where "ID In (Select ID from Buffers Where NUMPOINTS 10" I'm not sure if you want to select the points where there are 10 or more points within .5 km including the point or excl the point. But that should just be a question of comparingNUMPOINTS to10 or 11. HTH, Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ronning, ChristineSent: Wednesday, June 21, 2006 10:53 PMTo: MapInfo-L@lists.directionsmag.comSubject: [MI-L] Wrong Subject on last one: Spatial Query Hi all,I have mapped a points layer.I would like to select those records where there is more than 10 points within a radius of .5km.I'm having trouble even starting on this one! Can anyone provide some guidance/thoughts?ThanksChristine-Original Message-From: [EMAIL PROTECTED] on behalf of Spencer SimpsonSent: Wed 6/21/2006 11:34 AMTo: 'Alan Silvester'; mapinfo-l@lists.directionsmag.comSubject: RE: [MI-L] Creating a line from a series of pointsI think we need to know a little more about the table, such as:1. Are there columns specifying X and Y, or formulas, or a point objectyou can derive X and Y Coordinates from?2. Is there a column specifying the order that a point appears in thepolyline?3. Is there more than one polyline? If so, is there a column specifyingwhich polyline a row belongs to?If so, then it's possible to write a MapBasic application to chain thepoints together. Some of the other listers may have even written suchapplications.A. Sort by (select statement with order by clause) polyline specifierand order specifierB. Iterate through the result table. For each record:if the line specifier changed, finish the current polyline (insert) andstart a new one with the coordinates from current rec (Create Pline).If not, add the coordinates from the current rec to the end of the currentline. (Alter Object Add Node)C. At the end, finish the current polyline.Hope this helpsSpencer _From: [EMAIL PROTECTED][mailto:[EMAIL PROTECTED]] On Behalf Of AlanSilvesterSent: Wednesday, June 21, 2006 11:30 AMTo: mapinfo-l@lists.directionsmag.comSubject: [MI-L] Creating a line from a series of pointsDear All,Does anybody know how to automatically create a line from a series ofpoints, i.e. rather than drawing a line from point to point, I want to beable to make a line that automatically joins up the points. The problem is,is that the next point to join up with the line may not be the next recordin the table?! The points are however all 1km apart.Does anyone have any ideas?Regards,AlanAlan SilvesterGIS ManagerGroundSure LimitedUnit E, Level 7New England HouseBrightonBN1 4GHTel: +44 (0)1273 819500 (Switchboard) +44 (0)1273 647811 (Direct dial)Email: [EMAIL PROTECTED]This e-mail is private and confidential. Access by or disclosure toanyone other than the intended recipient for any reason other than thebusiness purpose for which the message is intended, is unauthorised. Ifyou are not the intended recipient, you must not act or omit to take anyaction based on this message. This e-mail and any views or opinionscontained in it are subject to any terms and conditions agreed betweenGroundSure Limited and the recipient.All reasonable precautions have been taken to ensure no viruses arepresent in this e-mail. As GroundSure Limited cannot acceptresponsibility for loss or damage arising from the use of this e-mail orattachments we recommend that you subject these to your virus checkingprocedures prior to use.Copyright in documents created by or on behalf of this company remainsvested in the company and we assert our moral rights, unless termsprovide otherwise. ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] Selection being shown in map window
Title: Selection being shown in map window David, I think I can recall this behaviour. As far as I remember it was connected to havingone or morequeries shown in the map as well. You can also use Ctrl + D to refresh the map, but it doesn't fix the problem. Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Llewellyn, DavidSent: Tuesday, June 20, 2006 9:06 AMTo: MapInfo-L@lists.directionsmag.comSubject: [MI-L] Selection being shown in map window Dear list, Has anyone else had the problem occur that an object selected in the map window does not show up in the selected object style? Zooming in or out will actually result in the object being shown selected, but it is annoying to have to do that to confirm the selection. Conversely, sometimes a selected object will remain shown as selected in the map window when deselected. Once again zooming will fix the display. Has anyone experiencing this problem found a way to stop it occuring? I am using MapInfo V8 build 21. Best regards, David Llewellyn If this email has been received in error, please delete all copies and inform the National Native Title Tribunal by return email or telephone 1800 640 501. The Tribunal does not warrant that its email is virus free. All emails sent to the Tribunal are filtered for viruses and inappropriate content. Thus your email may not reach the person to whom it is addressed. Seek confirmation of receipt of your email if you consider the email important. ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] Seamless layers and spatial filter/index [HOW-TO - Long]
Tim, Going the other way is pretty easy. Just change \IsSeamless = TRUE to \IsSeamless = FALSE in the TAB-file Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tim Smith Sent: Tuesday, June 20, 2006 11:21 AM To: Michel Wurtz Cc: MapInfo List Subject: RE: [MI-L] Seamless layers and spatial filter/index [HOW-TO - Long] That worked perfectly! Thanks Michel! I should be able to create a tool now to automatically generate the mid/mif files. Now I know how to construct the seamless layer, I just need to know how to go the other way - i.e. create mid/mif from the seamless tab. Thanks very much for your help. Tim -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Michel Wurtz Sent: 20 June 2006 08:56 Cc: MapInfo List Subject: Re: [MI-L] Seamless layers and spatial filter/index [HOW-TO - Long] Hi Tim, As fas as I know, Seamless tables reference tabs as rectangles. It's then very easy to create a Seamless table by hand. I have used unix shell to do that, but you can use other tools, especialy if you have only Windows (like Msys/Mingw to have unix shell and utilities, or perl, which can be used alone on either Unix/Linux or Windows) . The general idea is to : 1- create the table in mif/mid format 2- use tab2tab (or MapInfo, but tab2tab can be used in batch script) to transform the mif/mid file in .tab file 3- add the metadata information to transform your rectangle table in seamless table Hints : 1- The most complicated, because you should figure the extension of each tab file you want to put in. You must create 2 files. - the .mid file contains two strings per line, separated by a comma the first string is the path to the file (relative in the example) the second cone is the MapInfo internal name for the layer (I just used the name of the file). Here is an example : N_SCAN25_DALLES\SC25_0780_2110_L2E.tab,SC25_0780_2110_L2E N_SCAN25_DALLES\SC25_0780_2120_L2E.tab,SC25_0780_2120_L2E N_SCAN25_DALLES\SC25_0780_2130_L2E.tab,SC25_0780_2130_L2E N_SCAN25_DALLES\SC25_0780_2140_L2E.tab,SC25_0780_2140_L2E - The second file is the .mif. The header is allways the same (I don't remember if the blank line after this header is mandatory). You have to complete the Coordsys line by the one that fits your rasters (I just use the Coordys line of the first table I want to put in. they should anyways be the same for each table !) : Version 450 Charset WindowsLatin1 Delimiter , CoordSys Earth Projection Columns 2 Table Char(100) Description Char(25) Data You must now create the rectangles. Generaly (but you have to verify this), you can find the extent of each raster in its .tab file, like the Coordsys infos. Region 1 means you have a polygon 5 means 5 points (it's a closed rectangle, with the same coordinates for the first and the last point). Then you have the points (in the order for drawing a rectangle !), and the aspect (pen, brush), which is not important (you don't draw them). Example (you can use this as a template, just changing the 5 coordiantes lines) : Region 1 5 779950 2099950 779950 2110050 790050 2110050 790050 2099950 779950 2099950 Pen (1,2,0) Brush (2,16777215,16777215) In conclusion, you must have one region record and one line in the .mid file for each image you want in your seamless layer. 2- Straithforward... (tab2tab xxx.mif xxx.tab) 3- Simply add the following lines at the end of the .tab file ReadOnly begin_metadata \IsSeamless = TRUE \IsReadOnly = FALSE end_metadata - You should now see your raster data if you open the table. I hope this can help you and other users to create seamless table. I should have some example for doing this, but they are limited to the kind af raster I have (french scanned Maps and orthophotographies). I developped this because we wanted to convert images form tiff to ecw then made a seamless layer. You can launch the command on a large amount of files (say 6000), and directories and let your computer doing the painfull job while you sleep or enjoy the week-end... Tim Smith a écrit : Thanks Bill. I'm unsure how mapinfo references the other tabs in the seamless table. I open the seamless table in MapInfo, but can't query it or open a new browser window. How can see what tabs it references? Do you have any ideas how I could create my own
RE: [MI-L] hot link question
Eric, You can add the table twice to the map and then set the Hotlink setting to match the first column on the first layer and the second column on the second layer. But you can't save these settings to the tables metadata, only in a workspace. Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Eric Gagnon Sent: Monday, June 19, 2006 8:57 PM To: MapInfo List Subject: [MI-L] hot link question Hi, everyone my question is very simple I got my hot link working in MI 8.0. in my browser I have 2 columns zoning_pdf and by_law_pdf I got the address for the pdf documents and it's working.. BUT.. Only one column.. How can I open the 2 pdf documents in one click I tried column1 + column 2 in the expression window.. but it's not working. Any help would be greatly appreciated. Eric -- Eric Gagnon,B.Sc., GIS Specialist [EMAIL PROTECTED] 47°02'57N 67°44'11W ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] RE: Labels
Title: RE: [MI-L] RE: Labels Arlene, I'm not sure, what is causing your problem and if it is the same problem. The problem I have encountered was that the labels were moved approx. 300 meters. This matched exactly the difference between coordinates in two often used coordinatesystems in Denmark. The problem was that when the workspace was written the coordinates were written using the first coordinatesystem. But when the workspace was reloaded, the coordinates were interpretered using the second coordinatesystem. If you look at a workspace in a text editor, you'll see that when MapInfo creates a map, it involved a number of statements: 1. Create the Map with the layers. Map From list_of_layers ... 2. Set coordinatesystem, center and zoom Set Map CoordSys ... 3. Setup the layers Set Map Layer 1 ... Layer 2 Layer ... If you add a print statement, that prints the current coordinatesystem of the map after the first Set Map and after the second Set Map, you can see if MapInfo is using different coordinateystems. The print statement is this: Print MapperInfo(FrontWindow(), 18) Here is a short sample: ** ... Set Map CoordSys Earth Projection 8, 28, m, 9, 0, 0.9996, 50, 0 Center (537837.6939,6152324.979) Zoom 27.81736419 Units km Preserve Zoom Display Zoom Distance Units km Area Units sq km XY Units m Distance Type Cartesian Print MapperInfo(FrontWindow(), 18) Set Map Layer 1 Display Global Global Symbol (34,16711680,12) Line (2,2,16711680) Font (Tahoma,257,9,0,16777215) Label Line Arrow Position Above Font (Arial,0,9,0) Pen (1,2,0) With VEJNAVN Parallel On Auto Off Overlap Off Duplicates Off Offset 2 Visibility On Layer 2 Display Graphic Global Symbol (34,16711680,12) Line (2,2,255) Font (Tahoma,257,9,0,16777215) Label Line Arrow Position Above Font (Arial,0,9,0) Pen (1,2,0) With VEJNAVN Parallel On Auto Off Overlap Off Duplicates Off Offset 2 Visibility On Print MapperInfo(FrontWindow(), 18) Set Window FrontWindow() Printer Name \\BDCODKX\ODKX13 Orientation Portrait Copies 1 Papersize 9 ... ** Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Arlene Baker Sent: Monday, June 19, 2006 7:44 PM To: mapinfo-l@lists.directionsmag.com Subject: [MI-L] RE: Labels Hi, I've also had this problem and it wasn't caused by packing -- the arrows from the labels point to the correct points (correct label with correct point) and I haven't packed the table. Not sure if it is caused by coordsys difference. The labels aren't really in the wrong place -- the lines/arrows pointing from the label to the point are hundreds of miles long (I've had one go almost to South America when the point was in Central Florida). For example, I have a map layer with an extent of 20 miles and have a few labels pulled off some points, maybe 1/2 a mile from the point -- just enough so it is readable in my layout window. I re-open the saved workspace and those labels are now hundreds of miles away from their points. If it was a coordsys problem, should I expect the difference to be the distance between a point in one coordsys and the same point in another system? Or is the coordsys difference just causing the labels lines to fly all over the place? Arlene Arlene Baker The Shopping Center Group 2170 W. State Road 434 Suite 180 Longwood, FL 32779 Phone: 407-788-8818 Fax: 407-788-0971 www.theshoppingcentergroup.com Confidentiality Note: The information contained in this email and document(s) attached are for the exclusive use of the addressee and may contain confidential, privileged and non-disclosable information. If the recipient of this email is not the addressee, such recipient is strictly prohibited from reading, photocopying, distributing or other wise using this email or its contents in any way and must immediately delete this email. -- Message: 1 Date: Sat, 17 Jun 2006 22:50:05 +0200 From: Peter Horsb?ll M?ller [EMAIL PROTECTED] Subject: RE: [MI-L] Labels To: David Hilpipre [EMAIL PROTECTED], Anthony Hicke [EMAIL PROTECTED], Mapinfo-L mapinfo-l@lists.directionsmag.com Message-ID: [EMAIL PROTECTED] Content-Type: text/plain; charset=iso-8859-1 Hi, Just wanted to share some insight on this issue. This problem is not only related to packed tables. I can slo be related to raster layers ... Imagine this: 1. You have a map with a bunch of layers and a raster layer. Thie raster layer
RE: [MI-L] Zoom to Extents of Selection - MapBasic Code
Morgan, Your idea with zooming to the layer is correct. The problem is that MapInfo can't find the layer in the map, so you need to add the layer to the map before zooming to the extent of this layer/selection. Something like this: '**selecting all objects into a named temp table Select * From ObjectsToMap Where OBJ Into TO__PRINT NoSelect Fetch first From TO__PRINT Do Until EOT(TO__PRINT) nRow = TO__PRINT.OBJ 'remember to Dim this integer variable '*Selecting the current record into a temp table Select * From TO__PRINT Where ROWID = nRow Into CUR__OBJECT Noselect Fetch First From CUR__OBJECT Set Map Center (CentroidX(CUR__OBJECT.obj), CentroidY(CUR__OBJECT.obj)) 'center map on selected object '**Adding the layer to be able to zoom to its extent Add Map Layer CUR__OBJECT Set Map Zoom Entire LayerCUR__OBJECT '**Removing the layer from the map again Remove Map Layer CUR__OBJECT Run Menu Command 112 'Print Command FetchNext from TO__PRINT Loop HTH, Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ellingham MorganSent: Friday, June 16, 2006 9:06 AMTo: mapinfo-l@lists.directionsmag.comSubject: [MI-L] Zoom to Extents of Selection - MapBasic Code Hi all, Am trying to create a batch to print off a series of maps automatically, I need it to cycle through aseries of mapped objects, print, then move to the next object. I can get it to center at each object but the zoom extent stays the same. Trying below code; Select * From ObjectsToMap Fetch first From ObjectsToMap Do Until EOT(ObjectsToMap) Set Map Center (CentroidX(Selection.obj), CentroidY(Selection.obj)) 'center map on selected object Set Map Window WindowID(1) Zoom Entire Layer SelectionInfo(SEL_INFO_SELNAME) 'THIS IS WHERE THE ERROR IS "INVALID VIEW LAYER" TRIED Layer Selection et al Run Menu Command 112 'Print Command Fetch next from ObjectsToMap Loop Any ideas? Regards... Morgan Ellingham Citywide Service Solutions GIS Technician Level 1, 150 Jolimont Rd, East Melbourne Ph: (03) 9261 5065 Mob: 0419 145 666 Email: [EMAIL PROTECTED] ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] printwin file save as dialog box
Hi, What I have done is creating a printer port with the name of my output file. So I now exactly which file my printer prints to. When MapInfo has printed, I do a File Rename of the printed file, and next time MapInfo prints there is no file to overwrite as I have renamed it. Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ben A Greenberg Sent: Thursday, June 15, 2006 7:45 PM To: [EMAIL PROTECTED]; mapinfo-l@lists.directionsmag.com Subject: RE: [MI-L] printwin file save as dialog box I believe all that can be done in the Adobe print driver settings. You can enable/disable the prompting of file name, and under the ports setting, you can specify the default directory where you would like the pdf created. This should remove the interactivity from your PDF creation. Just be aware that the default PDF name will be the window (in this case the layout) title. So unless the title is unique, you will wind up saving each new PDF over the old ones. Ben Greenberg GIS Coordinator NAI MLG Commercial 262-797-9400 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Thursday, June 15, 2006 10:53 AM To: mapinfo-l@lists.directionsmag.com Subject: [MI-L] printwin file save as dialog box Hello all, I have written a bulk mapping application that creates a standard map, imbedes this map into a standard Layout and then prints out the layout as pdf file using adobe pdf writer version 4.05 . By using the printwin function I am able to by pass the printer dialog box but I still have to save each file once it is created. Is there way within adobe or mapbasic to determine the specific directory i want these maps to printed so I can by pass the save pdf as dialog box. any help is appreciated thanks Scott ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] PDF maps from MAP-INFO - Help!!!
Henry, As I remember, this problem was fixed with the latest patch for MapInfo Pro 8.0. You can access this patch thru MapInfo Pro, Help Find Updates which should bring you straith to the MapInfo Pro Update Site. Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Henry ArmijosSent: Tuesday, June 13, 2006 4:44 PMTo: mapinfo-l@lists.directionsmag.comSubject: [MI-L] PDF maps from MAP-INFO - Help!!! Hi guys, Sorry to bother you, but I need the expertise advice from you. Our business uses the MapInfo Professional Version 8.0 software to build maps. Most of the time these maps have to be generated in PDF format to send to our clients. To do that Adobe Acrobat Professional Version 7.0 is utilized. Keeping in mind that both packages are licensed, when we try to get the PDF files from MapInfo we get the following message error: %%[ ProductName: Distiller ]%% %%[ Error: Map-Symbols cannot be embedded because of licensing restrictions. ]%% %%[ Font vendor (Alts) does not permit this font to be embedded in PDF. ]%% [Warning] The font Map-Symbols could not be embedded because of licensing restrictions. Text may display incorrectly on platforms that do not have this font installed. %%[ Error: invalidfont; OffendingCommand: show; ErrorInfo: CharOffsets Please can you give any idea where this error comes from. Just one additional fact, we had installed Adobe Professional ver 6.0 before, and we never had issues getting PDF files from Map-Info. Thanks for your time and future consideration Regards, Henry Armijos Client Services Manager Eucan Urban Equipment of Canada Inc. 4162593200 ext 229 ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] Updating the Info tool window
Title: Updating the Info tool window Greg, You can use the Set Window statement to do this. Set Window WIN_INFO Table NAME_OF_TABLE Rec NUMBER_OF_REC_TO_SHOW HTH, Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Driver, Greg 9434Sent: Monday, June 12, 2006 3:16 PMTo: MapInfo-L (MapInfo Gurus)Subject: [MI-L] Updating the Info tool window Listers, Is there a way of updating the info tool window so that a particular record is displayed? I have a tool that allows the user to click in the map window and any objects that are found at this point are listed in a dialog window. What I'd like to do is to update the info tool window with the attributes of the object that is currently selected in the dialog window. So as the use selected different objects from the list the info tool window is updated with the associated attributes. Is this possible or do I have to resort to using the message window? Cheers Greg Driver System Administrator Applications Support ICT Surrey Police Tel: 01483 48 2292 Fax: 01483 48 2374 Email: [EMAIL PROTECTED] NOT PROTECTIVELY MARKED Internet communications are not secure and therefore Surrey Police does not accept legal responsibility for the contents of this message. This email and any attachments may be confidential. They may contain privileged information and are intended for the named addressee (s) only. They must not be distributed without our consent. If you are not the intended recipient, please notify us immediately and delete the message and any attachments from your computer, do not disclose, distribute, or retain this email or any part of it. Unless expressly stated, opinions in this email are those of the individual sender, and not of Surrey Police. We believe but do not warrant that this e-mail and any attachments are virus free. You must therefore take full responsibility for virus checking. Surrey Police reserves the right to monitor all email communications through their networks. ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] Raster images in different coordinate systems
Hi Caroline, There a few things that MapInfo takes into consideration when deciding which raster gets the lead. 1. The raster layer covering the largest part of the map This is mostly the case, at least until the later versions where Ii think they shifted to 2 2. The upper raster layer The problem could be that you had to rasters in the map, but only the upper was visible. In this case the upper controls the coordinate system. I'm not quite sure exatly when this changed. With MapInfo 8.5 these problems are gone. MapInfo 8.5 supports the reprojection of raster. Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Caroline Hilton Sent: Monday, June 12, 2006 6:12 PM To: MapInfo-L@lists.directionsmag.com Subject: [MI-L] Raster images in different coordinate systems Hello I am currently working in an area which straddles the border of 2 UTM coordinate systems. Working with raster images registered in these systems, they don't quite meet, with offsets, gaps, overlaps and even different sizes where they should match up. Does anyone know how MapInfo displays the images in the same window? i.e. how one raster would be warped compared to the other one in the map window? Or how MapInfo deals with the second raster to be placed in the window when it's a different coordinate system? I know the map window projection can't be changed once a raster appears, and that it takes the projection of the initial raster, but what does it do with the second one? Cheers Caroline -- Dr Caroline Hilton Pelican GeoGraphics Ltd www.pelicangeographics.co.uk .. Encom Discover 3D is out now. For a true 3D environment within MapInfo, contact us now for an evaluation. ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] DBMS Mapped Table - Dissapearing columns
Another solution is to create a view in the database that has your coordinate columns twice (with different names). When you make this view mappable, MapInfo will only hide the columns used to create the point Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Spencer Simpson Sent: Friday, June 09, 2006 7:05 AM To: 'Michele Tuomi'; mapinfo-l@lists.directionsmag.com Subject: RE: [MI-L] DBMS Mapped Table - Dissapearing columns The X and Y columns are still there; MapInfo has simply hidden them since it's using them for the coordinates of your points. MapInfo did this by design; it can be annoying but you have to live with it. If you want to get X and Y coordinates out of the mappable table you can still use the functions CentroidX() and CentroidY(). If you want to see coordinates in the browser, use Pick Fields... to add columns based on CentroidX(obj) and CentroidY(obj). Hope this helps Spencer -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Michele Tuomi Sent: Thursday, June 08, 2006 4:40 PM To: mapinfo-l@lists.directionsmag.com Subject: [MI-L] DBMS Mapped Table - Dissapearing columns Hello everyone; I have an access database. There's a table in this database that I wanted to be brought into MapInfo (7.5). I've done this via the dbms connection, and created a linked table. I also wanted to make this table mappable, and have gone through the steps to do this. This table became mappable, but in the process, the table has dropped the two columns which identified the x and y coordinates. When I go into browser view to look at my table, the x and y columns aren't there. They used to be there, when the table was non-mappable. Why did this happen? How do I get my x and y columns back? Any help would be appreciated. Regards, Michele ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] Expert Mode SQL on Spatialware table
Title: RE: [MI-L] Expert Mode SQL on Spatialware table What if you use this statement: Select * From databasename.dbo.spatialwaretable where ((Nr1='200') or (Nr2='200')) and (M1M2) Pay attention to the extra () around the two first expressions and that I have removed the )( around When combining AND and OR in a statement, I always recommend grouping the expressions with () otherwise you might not get the result you expect Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Possberg, Hendrik Sent: Tuesday, May 23, 2006 12:29 PM To: Mapinfo-List (E-Mail) Subject: [MI-L] Expert Mode SQL on Spatialware table Dear List, I am trying to download Data from a spatialware table via Expert Mode. When using Mapinfo i can use this statement: Select * from Spatialwaretable where NR1=200 or NR2=200 and M1M2 into Table2 But what is the right code in Expert mode worjking with a spatialware table? Using: Select * From databasename.dbo.spatialwaretable where (Nr1='200') or (Nr2='200') and (M1)(M2) gave the same result as: Select * From databasename.dbo.spatialwaretable where (Nr1='200') or (Nr2='200') How can I achieve the reduction of objects with the attrib M1M2 Any help would be appreciated. Mit freundlichen Grüßen Hendrik Poßberg Manager Geodaten Tel. +49 (0)2131 109-751 Fax +49 (0)2131 109-777 mailto:[EMAIL PROTECTED] microm Micromarketing-Systeme und Consult GmbH Hellersbergstraße 14 41460 Neuss www.microm-online.de Abonnieren Sie kostenlos das aktuelle microMagazin. In jedem Quartal erhalten Sie aktuelle Informationen über die neuesten Entwicklungen bei microm, unseren Partnern und Kunden. Einfach online bestellen unter www.microm-online.de! _ Diese Nachricht wurde elektronisch versandt und ist daher auch ohne Unterschrift rechtsgültig. Der Inhalt dieser E-Mail enthält vertrauliche Informationen. Das Kopieren und die Weitergabe an Dritte ist nicht gestattet. Sollten Sie diese E-Mail irrtümlich von uns erhalten haben, bitten wir Sie, diese zu vernichten und uns darüber zu informieren. Im Voraus vielen Dank. _ ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] Using ObjectInfo to find plines with SMOOTH attribute turnedon
Dave, You have actual provided your solution yourself ;-) The keyword is OBJ_INFO_SMOOTH in an MapBasic application, and 4 when used in MapInfo. This will select all the records where the object has smooth turned on Select * From MYTABLE Where Str$(ObjectInfo(OBJ, 4)) = T Also note that smooth only refers to polyline objects. Other objects will return an error. For Frame and Text objects, 4 will refer to some other attribute of the object. Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Reid Sent: Monday, May 22, 2006 7:54 PM To: MapInfo-L Subject: [MI-L] Using ObjectInfo to find plines with SMOOTH attribute turnedon Greetings List, I have a map table giving me problems on another application and I suspect it could be that Smooth may be turned on, on one or some polylines. Is there an Objectinfo() I query I could use to select any such polylines? ie ObjectInfo(Obj,2) would return line style, is there one to identify if Smooth is turned on? Thanks, Dave -- Outgoing mail is certified Virus Free Checked by AVG Free Edition. Version: 7.1.392 / Virus Database: 268.7.0/345 - Release Date: 05/22/2006 ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] Voronoi
Hi, Just a short comment: remember that the Voronoi function in MapInfo actual can use a closed object, set as target, as clipping/extension area. So if you manually or thru code, start by making a layer editable, selects an closed object from this layer, and then selects the points to use for voronoi creating, MapInfo will make sure that the inside of the target area is filled with the voronoi objects. This is a neat and often overlooked feature, that also is well describes in the manual ;-) Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Nabors, Steve Sent: Wednesday, May 17, 2006 3:47 PM To: Uffe Kousgaard Cc: MapInfo-L@lists.directionsmag.com Subject: RE: [MI-L] Voronoi I agree with Uffe, Looking at the points, you have an idea, but you never really know how big and what rotation the voronoi MBR will be. So if the voronoi MBR is clipping areas that you want included then you simply need include more existing points beyond the area of interest. If you don't have any more points outside the are of interest, simply put some new points well outside your area of interest and include them in your selection. So the rule of thumb is, always include points well ouside of the area of interest or create dummy/dataless records to allow you to do the same. A classic example would be land based points near the ocean and part of the coast line gets clipped because there are no points out in the ocean to increase the vornoi MBR. Voronoi creates grains of growth or polygons that are the result of a bisection or half the distance from any one point, to another. In the ocean problem, simply put some dataless points out in the ocean, so that at least half the distance between any ocean points and land points is still out over the water. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Uffe Kousgaard Sent: Wednesday, May 17, 2006 4:52 AM To: Mapinfo-L Subject: Re: [MI-L] Voronoi Just add some additional points far away from your own points and then clip the resulting polygons with whatever you had in mind for additional distance. Kind regards Uffe Kousgaard www.routeware.dk - Original Message - From: Jaromir Svasta [EMAIL PROTECTED] To: mapinfo-l@lists.directionsmag.com Sent: Wednesday, May 17, 2006 10:51 AM Subject: [MI-L] Voronoi Hi listers, Does anyone of you have some nice code (MB or VB) for creating voronoi polygons from points? Create Object As Voronoi stetement in MapBasic is not sufficient for my purpose, because it limits the outer boundary of polygons to the point's MBR, I need to extend it some distance. -- Jaromir SVASTA Hydrogeologist Geological Survey of Slovak Republic Mlynska dolina 1 817 04 Bratislava Slovak Republic Tel:+421 2 59375326 Mobile: +421 908783589 Fax:+421 2 54771940 ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l __ This e-mail has been scanned by Verizon/MessageLabs Managed Email Service. __ This e-mail has been scanned by Verizon/MessageLabs Managed Email Service. ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] MapInfo v8.5
Hi Greg, A few things: - Access to MapInfo Envinsa Online services, allowing you to find address, geocode and create driving isocrones by using a web service (must be a Envinsa or MapMarker web service). This means that you don't need address and street data locally. - reproject raster on the fly - Save thematics to tables metadata and reopening table using this thematics - Merging one map into another - adding a layer from one map into a another layer with settings (zoom layering, labels, etc) - storing a tables browser view as meta data - Copying values from the Message window and Statistic window - New Printing engine (support for large prints) - Larger dialogs, more buttons - more ... Many of these things were shown at the MapWorld in Phoenix 2 weeks ago. I really think there are some nice features in this release Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Greg Gainey Sent: Tuesday, May 16, 2006 12:21 PM To: mapinfo-l@lists.directionsmag.com Subject: [MI-L] MapInfo v8.5 Hi Listers I have been invited to a forum where the much mentioned MapInfo v8.5 will be unveiled. Can anyone give me a background on what new and exciting features will be revealed? Thanks Greg ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] RE: MapInfo v8.5 (Greg Gainey)
Mid June ... 2006 ;-) That is the American/English version. As always the localised versions will follow during the months after. Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jonathan Roberts Sent: Tuesday, May 16, 2006 4:07 PM To: mapinfo-l@lists.directionsmag.com Subject: [MI-L] RE: MapInfo v8.5 (Greg Gainey) Has MapInfo said when this version will be released? Jonathan -Original Message- Message: 1 Date: Tue, 16 May 2006 20:20:59 +1000 From: Greg Gainey [EMAIL PROTECTED] Subject: [MI-L] MapInfo v8.5 To: mapinfo-l@lists.directionsmag.com Message-ID: [EMAIL PROTECTED] Content-Type: text/plain; charset=us-ascii Hi Listers I have been invited to a forum where the much mentioned MapInfo v8.5 will be unveiled. Can anyone give me a background on what new and exciting features will be revealed? Thanks Greg ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] MapBasic and MapXtreme
Title: MapBasic and MapXtreme Christine, No need for apologize on this list. The only stupid question here, are those that not has been asked. In short: Yes, your intranet application would be written completely in .NET using MapXtreme and VB.NET, C# or other .NET languages. Yes, your VB.NET application could technically access a MapBasic application running on MapInfo Pro, but licensing forbids this. The longer version: You need to distinguise between what is technical possible and what is allowed under the software license. Youcan technical control a MapInfo Pro/MapBasic application thru VB.NET or any other .NET language (even "oldfashioned" programming languages like VB). This is also allowed by the software license, as long as each user of your application has a license for MapInfo Pro. As soon as you start looking for a web application things get a bit more complicated. You can access and control a MapInfo Pro using a web application. I have seems some examples of this. But the license for MapInfo Pro doesn't allow you doing this. So for web applications, you need to buy a "web license" for MapXtreme2005 and use this only. MapXtreme2005 can also be used for developing desktop applications. If so, you need to buy single user seats for each user of you application. I hope this did answer your question. If not let me know Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ronning, ChristineSent: Thursday, May 11, 2006 7:03 PMTo: mapinfo-l@lists.directionsmag.comSubject: [MI-L] MapBasic and MapXtreme Hi all, Excuse my ignorance in this, but hoping to understand a little bit more about the relationship between MapInfo capability with web software (MapXtreme). After a little research I see that you can use .NET languages which brings me to my question. If for example I wanted to created a intranet application that allowed employees through a site, to enter a desired location with a few options of what they wanted on their map and see an output, would this programming be done all with a .NET language or would some of it be done using MapBasic? So if I were to write a program in MapBasic that ran some spatial queries could this then be called from a VB.Net program that is run from the MapXtreme application? I apologize if this doesn't make sense, but hopefully someone understands my question! Thanks Christine Christine Ronning GIS Analyst, Strategic Information 740 Carmi Avenue Penticton, BC V2A 8P9 250-770-3408/250-870-4677 [EMAIL PROTECTED] ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] new app Project Grande?
Hi, At MapWorld last week they showed a version of Grande that was able to open a workspace (.WOR), that contains MapBasic commands. So they have already started implementing some sort of MapBasic support into the Grande Project, which will be the next generation desktop GIS from MapInfo. At the moment MapInfo Corp. says that MapInfo Pro will continue to be extended with new functionality over the next couple of years. at the same time the Grande Project will get more and more of the same functionality as you can find in MapInfo Pro now. The first version of Grande will not have all the features of MapInfo Pro, but over time it will. Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill Thoen Sent: Friday, May 12, 2006 3:50 AM To: MapInfo-L@lists.directionsmag.com Subject: Re: [MI-L] new app Project Grande? On Thu, May 11, 2006 at 06:26:39PM -0600, Neil Havermale wrote: Possibly others can share their insights of this grand project? My bet is that MapBasic will be with us and current for at least a couple more years. MapXtreme will be where .NET gets tested and develpoed instead. But that's just a guess. - Bill Thoen ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] Rotate map window when raster images are visible
Hi, The upcoming new release of MapInfo Pro (version 8.5) will be able to do this. This is one of the new features that has been added to MapInfo as we could see at MapWorld this week. It should be released in June Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Gamiz Ribelles, Sergi (Regsa) Sent: Thursday, May 04, 2006 8:09 PM To: Mapinfo-list (E-mail) Subject: [MI-L] Rotate map window when raster images are visible Hi List, is there any tool to rotate map window when raster images are visible? thank you. Sergi Gàmiz Ribelles (627481954) REGS DE CATALUNYA S.A. (www.regsa.es) Unitat de Promoció de Regadius i Concentració Parcel·lària c/General Brito, 6, 5è 25007 Lleida tel. 973222838 fax 973222627 [EMAIL PROTECTED] ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] MI Networking Problems
Make sure that the share not has been setup to only allow one user to connect to it at a time Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Nabors, SteveSent: Thursday, May 04, 2006 10:49 PMTo: [EMAIL PROTECTED]Cc: MapInfo-L@lists.directionsmag.comSubject: RE: [MI-L] MI Networking Problems We started on MapInfo on version 7.0. I know we could have multiple users connecting to the same tableson a shared drive. Wehad no problem with this. We have since moved through v7.5, 7.8, and are presently on 8.0. Try the following while remaining out of MapInfo: See if all of your users can connect to the share and see the files through file manager. If sothen your users have at least Read rights and there is no NTFS, Share or machine level access issue. Try the following while inside of MapInfo as just one user: See if one of those users can open and edit a table in MapInfo and save it. If so, your users have full access to modify the tables from a security standpoint(NTFS, Share or machine level access). If you have gotten this far then, the problem is perhaps in MapInfo. Thisleads me to believe that perhapsyou are having some sort of multiversion MapInfo table access issue. Perhaps one version(v7) sees the tables being "held" by another application(in this case just another version(v6) of MI)and will not let it open the tables even though you may not be editing in v6. In MapInfo,try having "like versions" open the tables and see what your results are. Preferably the latest version(7.0 and up)you have multiples of. Also in MapInfo, try opening the tables in MapInfo's Read Only mode and seeif multiple users can open tables. Again, preferably the latest version you have multiples of. From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Doug WassmerSent: Thursday, May 04, 2006 1:23 PMTo: MapInfo-L@lists.directionsmag.comSubject: [MI-L] MI Networking Problems -- Hi List: I am having trouble sharing MapInfo files over a local area network. The tab files reside in 3 separate folders on a RAID server which is part of a domain. Users log onto the domain at startup, and then open MapInfo v 6, 7, or 7.5. The properties of three folders and their contents are set so that everyone has full control for both sharing and security. Most who log on to the LAN are not in the administrators group, but are in the power users group. However, the users have full administrative privileges when logged on the local machine instead of on the LAN. It appears that only one user at a time can access the files on the server. Is this to be expected? It there a work around so that many can use the files simultaneously but only one at a time can modify a file? Users are unable to print the map window via the print commands. This may be a serious problem because the printed outputs of map windows are important to operations. If anyone has any suggestions on networking and sharing tab files, I would appreciate a response. Thanks Doug Wassmer [EMAIL PROTECTED] __This e-mail has been scanned by Verizon/MessageLabs Managed Email Service.__This e-mail has been scanned by Verizon/MessageLabs Managed Email Service. ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] Software solutions to deal with stretch, skew, scaling
MapInfo has a built in tool called Vector Registration ( I think that is the name) This tool will allow you to fit one table (maybe even more) to another using three orientation points. For simple reorientation of tables it is usefull, but if you want high precision 3 points isn't enough Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Flavio Hendry Sent: Friday, May 05, 2006 7:52 AM To: David Reid; '[EMAIL PROTECTED]' Subject: Re: [MI-L] Software solutions to deal with stretch, skew, scaling Hi David you could try out FME, there is: - rotate - scale - affine - helmert - reproject - rubber sheeting (you'd need displacement vectors for that) there is a demo version: www.safe.com Mit freundlichem Gruss / Best Regards Flavio Hendry TYDAC NEWS http://www.tydac.ch/german/index.php?menu=News_actual Mit freundlichen Gruessen / Kind Regards mailto:[EMAIL PROTECTED] TYDAC AG - http://www.tydac.ch Geographic Information Solutions Luternauweg 12 -- CH-3006 Bern Tel +41 (0)31 368 0180 - Fax +41 (0)31 368 1860 -Original Message- From: David Reid [EMAIL PROTECTED] To: '[EMAIL PROTECTED]' mapinfo-l@lists.directionsmag.com Date: Thu, 4 May 2006 13:58:29 -0500 Subject: [MI-L] Software solutions to deal with stretch, skew, scaling Greetings List, What solutions have you folks found out there to deal with translating non-earth vector data such as found when converting a surveyor's CAD file (dwg etc) into one's common use projection of say, State Plane. Something that will deal with any skew, rotation, scaling etc, on small areas of less than a few sq km, such as a residiential subdivision. Demo version is a real plus. Thanks, David Reid -- Outgoing mail is certified Virus Free Checked by AVG Free Edition. Version: 7.1.392 / Virus Database: 268.5.3/331 - Release Date: 05/03/2006 ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] Summing up areas of several layers, exclusive of overlap
Nathan, I think you should go in a different direction. Way not combining all the records in your tables into one table. Then you can select all records and combine them into one single object (Unless the number of nodes gets to big ...) And finally you can do an areacalculation of this single object. You could also insert one layer at a time into the new table and for each new layer you want to insert, you first select everything from the new table, set this as target, then you select everything from the layer to insert and do an erase. Now every part of the objects in the new layer tha overlap any part of the objects in the layer to insert will be deleted. Finally you insert the records from the layer into the new layer. Again you finish by doing an area calcualtion, this time by Selecting Sum(CartesianArea(OBJ, sq m) or Sum(Area(OBJ, sq m), depending on your coordsys HTH, Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Nathan Carr Sent: Wednesday, May 03, 2006 12:51 PM To: mapinfo-l@lists.directionsmag.com Subject: [MI-L] Summing up areas of several layers, exclusive of overlap Hiya, I've got a nice task of adding up the areas of several layers excluding multiple counts of those polygons that overlap. In other words... I need to get the cumulative sum of all the areas of features in several layers, but not counting twice those layers that overlap. I imagine that I can do it with a combination of the SQL functions of CASE and SUM and AREA and the MapInfo/Spatialware commands of INTERSECTS and ENTIRELY WITHIN... But, I thought I'd see if anyone has any other ideas or anything I can base things on. One problem I can initially see is that how do you seperate into two areas the two parts of a polygon that lie inside and outside of another. And the CASE conditional must be repeated in a quite a complex way when dealing with about six layers. Thanks for any pointers, Nathan ---(\./)--- Nathan Carr GIS Developer LLPG/LSG Custodian ALO Swale Borough Council Email : [EMAIL PROTECTED] Phone : 01795 417 337 Mobile : 07957 461 685 This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager at [EMAIL PROTECTED] This message has been scanned for viruses by BlackSpider MailControl - www.blackspider.com I.T. Services Swale Borough Council Visit http://www.swale.gov.uk ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] logical to numeric
Jacques, I would recommend using the Int() function to convert your logical _expression_ to a number. The number returned by Int() will either be 1 (TRUE) or 0 (FALSE). I have used this a lot for labeling Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jacques ParisSent: Monday, May 01, 2006 9:04 PMTo: MapInfo-L@lists.directionsmag.comSubject: [MI-L] logical to numeric I have not seen much written on the subject but I was faced with it: how to use logical variables in operations without using if statements. I was not able to pinpoint such a function and may be I am on an entirely wrong track but to solve my problem I have devised a possible conversion and I would like to know if it is acceptable or how could it be improved. Here it is, with its justification num_logic = ASC(STR$(logic))\73 STR$() will return F or T, their ascii codes (ASC) are 70 and 84. The integer division by any value from 71 to 83 will return 0 or 1. This conversion to numeric finds its place in conditional operations (ex. inclusion in a summation when a condition must be respected sum(numeric(i)*num_logic(i)) ) or condition summaries (ex1: how many true conditions apply to the case sum(num_logic(i)) ex2. if one condition is false all is false num_logic(1)*num_logic(2)* I would appreciate any comment on that issue and proposed solution. TIA Jacques Paris ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] Updating column with number of objects nearest apolyline...
Paul, I would recommend that you use the Distance Calculator tool. With this tool you can find the nearest object in one table to each object in another table. You would need MapInfo 8.0 to be able to do this though. If you don't have MapInfo 8.0, I have nmade a tool called NearestObject that can be found on Directionsmag.com under Tools. Both tools will give you a result table containing an id from both table and a line showing the distance. The Distance Calculator also updates a column with the distance. HTH, Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Spencer Simpson Sent: Friday, April 28, 2006 2:51 PM To: [EMAIL PROTECTED]; 'Paul Donnelly' Cc: mapinfo-l@lists.directionsmag.com Subject: RE: [MI-L] Updating column with number of objects nearest apolyline... Line-based Voronoi polygons would be nice, wouldn't they? There's a way to approximate them by generating intermediate points but I'm not sure the cure isn't worse than the disease... Spencer From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Lars I. Nielsen (GisPro) Sent: Thursday, April 27, 2006 4:48 PM To: Paul Donnelly Cc: mapinfo-l@lists.directionsmag.com Subject: Re: [MI-L] Updating column with number of objects nearest apolyline... Hi Poul, Would a feasible way not be to explode your polylines to node point objects, and generate voronoi polygons around these points ? Preserving some sort of polyline ID for each polygon. That way you could find the points closest to any node, and sum the counts using the polyline ID as aggregator. Unless your polyline are really weird, it ought to give you a reasonable result, or at least one that only counts single incident points once. Best regards / Med venlig hilsen Lars I. Nielsen GisPro Paul Donnelly wrote: Hello all! Was wondering if anyone can help me out with a little problem I need help in solving? Basically, I have two MapInfo tables - One table containing polylines representing road networks, and a second table containing point objects representing the locations of road accidents. I need a method of calculating the sum of accidents per road link. Previously I had buffered the polylines and then simply used the 'update column' function to sum up the number of objects within the buffer. The problem with this though was that where two polylines meet at a junction there was an overlap with the buffers and so when an accident point falls in this overlap it is double counted within both overlapping buffers. With small sections of road networks I simply edited the buffers to remove the overlap and then used the update column method. The problem now is that I have a lot of road newtork data and if I were to go round and remove each overlap for each individual section I'd still be here this time next year! So, ideally I need a method of assigning accident points to a single road link which is nearest. Then I need to update a column within the link table to count the number of accidents assigned to each particular road section. Any help solving this problem would much appreciated! Thanks in advance, Paul Donnelly Email: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] ** This message contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender and then delete the email and destroy any copies of it. Thank you. Hyder cannot guarantee that this message or any attachment is virus-free or has not been intercepted or changed. Any opinions or other information in this message that do not relate to the official business of the Company are neither given nor endorsed by it. ** ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] Hypothetical Question regarding web access to MI
Ben, Will the users have MapInfo Pro on their local computer ? If yes, you could also consider using a Spatial Database as backend, and using ODBC - I now it isn't the fastest thing in the world - access the data over the internet. This will allow people to use their daily GIS Tool to edit data. When they are done, they simply refresh and the changes are sent back into the database. When accessing data over the internet, I would suggest that you use linked and not live access ;-) And you don't have to access the entire table, you could specify a single or a few records to download. Spatial databases could be Oracle or MS SQL Server with MapInfo SpatialWare. I have heard that some have had success using the free version of Oracle even with spatial data, even though Oracle claims that that version doesn't support neither the Spatial nor Locator extension. Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ben Crane Sent: Wednesday, April 26, 2006 10:56 AM To: MAPINFO-L@lists.directionsmag.com Subject: [MI-L] Hypothetical Question regarding web access to MI Hi all, Thanx for the prompt and useful responses. I had completely forgotten about using Terminal Services Client. Licensing issues aside we have been looking at setting up a complete environement allowing users to load, edit and save map data via the web. We've gone through Geoserver, MapBuilder, Mapserver, PostGIS, etc but the documentation is frankly awful except for Mapserver but that is only a WMS, and I need a WFS-T (transactional - for data edits). Maybe that will change over time..but right now lack of suitable documentation hinders progress. We had thought of converting all my GIS data into XML, then using AJAX and SVG to control the entire interface, problem is, we really need to stay with TAB file format-so converting to and fro isn't ideal since we'd have to use MITAB libraries in PHP or Perl to handle the conversion. Citrix was a thought, but our operation is very small at the moment, so we need to be conscious of outlays. Ideally, using MapInfo on a server and allow remote access to a MapBasic utility will give us all the functionality we could possibly hope for-which is why we aimed for it. The real issue is ease of maintenance and long term development. The industry is changing and our website needs will change as well, short term options aren't really viable since in a year or two so much could have changed and being able to upgrade easily is very important, especially since there aren't many of us! :-) So many choices!! :) Ben __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] Hypothetical question regarding MapInfo on Web
Hi, I'm pretty sure that MapInfo 8.5 will not be the version that moves MapInfo to the .NET platform. This move to .NET is based on the project known as Grande. As far using MapInfo Pro on the Net, I'm sure that this could be done. But you would need to combine the internet development tool with MapInfo using MapBasic or integrated mapping. So I don't think that you'll actual get the MapInfo Pro user interface presented in your browser. You will more likely use MapInfo Pro as a backend service to create pictures to show in the browser. A different approach would be to use MapInfo Pro in a Citrix enviroment. This enviroment can be accessed thru a browser, that will present the user with a desktop like user interface. Quite a very usefull solution, but this will often require some extra thick client to be installed on the client computer. Both these approached will of course be pretty limited when you read thru the license of use. This strictly forbid the use of MapInfo Pro on a web server (not sure these are the exact words, but definitely the meaning). I'm going to the conference this year. Looking foreward to meeting some of you over there, Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Neil Havermale Sent: Tuesday, April 25, 2006 8:07 PM To: Ben Crane; MAPINFO-L@lists.directionsmag.com Subject: RE: [MI-L] Hypothetical question regarding MapInfo on Web A very interesting question and one that is timely. In a few days MapInfo will host its annual User/Developers Conference in Phoenix. If you follow the issues of MapInfo technology evolution you may already be aware that MapXtream is the critical technology core for all future MapInfo technology and desktop products via its .NET design. We do not have this yet in Pro 8.0 other than some serious progression in design coordination in the workspace between MapXtream and Pro designs. There is other stuff as well but the workspace seems to me the critical step of progression - getting the common man ready for a rather large shift IMHO. The re-engining of MapInfo Pro with MapXtream.NET is rumored to be included in Pro 8.5. This technology shift to .NET from .COM and MapBasic, and that is what it is, will be disruptive. Those that developed on MapX and MapXtream Windows (legacy and preambles to MapXtream.NET 5.0) will not fare as neatly tough. Importantly MapInfo has made some limited promises that they will do their very best to not only release the developer and the Pro platform from the limitations of old design Microsoft methods for new .NET opportunity but they intend to allow an elegant extension of the MapBasic legacy code sets into the new design - backward compatibility. This is rather neat and if they pull this off, well they will have avoided a huge depreciation of partner and client MapBasic investments. So I guess the answer is it looks like MapInfo Pro's future connection to the internet is just around the corner? Any takers on extending insight and rumorology of the likely Pro future? Oh and buy the way, I have had some really great results of merging my map-analysis and workspaces on to Google Earth. MidNight Mapper aka neil -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ben Crane Sent: Tuesday, April 25, 2006 11:38 PM To: MAPINFO-L@lists.directionsmag.com Subject: [MI-L] Hypothetical question regarding MapInfo on Web Hi all, This is a hypothetical question I've just thought of. Removing licensing and copyright issues from the equation. Is is possible and practical to install MapInfo on a web server and allow a set number of restricted users to access the application (a MapBasic app to be more specific)? I understand MapInfo isn't a particularly appropriate application for web-based access but if you wanted several users to access and run a mapbasic utility (with all the bells and whistles) via the web-is it doable? Regards Ben __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] MapInfo 8.0.1
David, If you have the Build 33, you are good. There is no never version until version 8.5 will be released. If you look back at the later versions of MapInfo, you'll discover that it has been a while since MapInfo actual had a x.01 version. The later versions are kept as x.00 and then just letting the build version change. This also means that you can't check if the user has upgraded with MapInfo as the SystemInfo(SYS_INFO_VERSION) only returns the first two decimals: 8.0.0.0018 - 800 8.0.0.0033 - 800 Could have been useful in some cases to be able to verify if the running MapInfo is the latest version or at least a certain version Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Baker Sent: Saturday, April 22, 2006 6:41 AM To: MapInfo-L@lists.directionsmag.com Subject: [MI-L] MapInfo 8.0.1 I was following the thread on Beginners MapInfo Questions and saw the link on MapInfo documentation at http://extranet.mapinfo.com/support/documentation/manuals.cfm#mi_pro Just thought I would have a look, and saw that there is a document called MapInfo Professional 8.0.1 Release Notes This was new to me, and my MapInfo Help/About says MapInfo 8.0 release 33, so I tried the MapInfo menu option Help/Check for Update. That tells me There are no patches or updates currently available for your version, platform and language of software. Is this a bug in MapInfo? If there is a newer version, why doesn't the Check For Updates tell me about it? Looking at the Mapinfo.exe file properties, I see the actual version number is 8.0.0.0033 - surely 8.0.1 should be higher/newer than that? The confusing part is that the 8.0.1 manual says Use the maintenance release file to update MapInfo Professional version 8.0 builds 18 and 21. Dave ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] Enclose function.
Robert, The main problem when using Enclose is that you might have places where you line work hasn't been snapped correctly. The Enclose funktion will then ignore this region as it doesn't support any tolerance setting. To improve the result I would recommen that you do one of two things: 1. Use the Objects Snap statement to snap node points together. Objects Snap From tablename[Tolerance [Node node_distance] [Vector vector_distance] [Units unit_string] [Thin [Bend bend_distance] [Distance spacing_distance] [Units unit_string] ][Cull Area cull_area [Units unit_string] ] ] 2. Extend every line with a few inches/cms at the start and end section. This might make the chance of snapping better. Of course this solution might also result in a number of small regions in certain places. Also remember that when using the Enclose thru MapBasic you can specify which table to put the result into: Objects Enclose Into Table MYTABLE This can also be done thru the interface as MapInfo will insert the regions into the editable layer. Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Data DirectionsSent: Wednesday, April 19, 2006 2:36 AMTo: Robert Crossley; mapinfo-l@lists.directionsmag.comSubject: Re: [MI-L] Enclose function. Robert, One "gotcha" is that the Enclose function will create polygons from your polylines BUT the polylines remain in the table. You then have to select all polylines, delete them and pack your table. Also note that if your line work is not 100% clean and snapped to nodes, that polyline may be overlooked and you end up with a larger polygon. I actually go through the following (labourious) processes to create polygons from polylines: 1) Digitise all polylines 2) I use Discover's "Auto-Polygonise" function to clean the line work - identify misclosures that I manually correct. 3) I then save a copy of my polylines to a new table "Polyline Backup" 4) I run the Enclose function to create polygons as no fill, single black border. At this stageI DO NOT save the table. 5) Then I select all polylines from the table and press delete. 6) I open my polyline backup table and position it BELOW the polygon table in Layer Control. I set the display override for the polyline table to red line, double thickness. 7) I then carefully examine the Mapper Window and note any areas where a polygon may not have been created. 8) If some polygons have been missed, I REVERT the polygon table, make changes and repeat steps 4 - 7 9) Once satisfied with the outcome, I PACK the polygon table. It is probably quite a round-about way of doing things, but I've found this gives me the best result. Regards, Bill === - Original Message - From: Robert Crossley To: mapinfo-l@lists.directionsmag.com Sent: Wednesday, April 19, 2006 8:08 AM Subject: [MI-L] Enclose function. Hi all, Ive just discovered the enclose command to create polygons from a network of lines. Its actually a very neat polygon building tool. I intend to implement it into a mapbasic program instead of a tool that I developed that splits a polygon with an intersecting line (the tool that does that in MapBasic doesnt work very well). So, Has anyone any gotchas for this command before I go down that way? The enclose command will create polygons from concentric circles, which the other tool wont so that is an advantage for me anyway. I remember that I had to put a 200 millisecond wait into the split function to stop it crashing in Mapbasic when selecting the resultant objects to delete. BTW, is the accuracy of an object variable determined by the current coordinate system? R --- Robert Crossley Agtrix P/L Australia Far Southern Queensland Office: 9 Short Street PO Box 63 New Brighton 2483 P: 61 2 6680 1309 F: 61 2 6680 5214 E: [EMAIL PROTECTED] W: www.agtrix.com Brisbane Office: 109 Milsom St Cooparoo 4151 Queensland P: 61 7 3843 3363 ___MapInfo-L mailing listMapInfo-L@lists.directionsmag.comhttp://www.directionsmag.com/mailman/listinfo/mapinfo-l ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] Speed up opening tables
Philip, The interesting question is what actual is taking the time. Is it opening the tables, showing these in a mapper or setting the layer settings for the layers ? I would recommend, that you add some MapBasic code to a copy of your workspace to make some speed testing. At the top of the workspace you write this (written in bold): ** !Workspace !Version 400 !CharSet WindowsLatin1 Dim nTime As Integer nTime = Timer() ** Now whenever you want to see how much tiime has been used, you can write some thing like this: ** ... Open Table "C:\HereAreMyTable\MyTable.Tab" As MyTable Print "Tables opened: " + (Timer() - nTime) + " secs" ... ** And at the bottom of the workspace, you write: ** ... Undim nTime ** I have used this method to track down speed issues before. I mostly put the timing before the Map >From and Set Map statements. One thing that might be time consuming is the default view of the tablee first put into the map. This table will decide how thee map, should appear and how large a zoom will be used. This has been a problem is previous versions of MapInfo, but it should have been fixed with the latest patch for MapInfo 8.0 HTH, Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Lesnik, Philip S.Sent: Thursday, April 13, 2006 5:20 PMTo: MAPINFO Discusion GroupSubject: [MI-L] Speed up opening tables Group. I was wondering if there is a way to speed up the process of opening up tables when starting a workspace. Last year we bought Terrain Data for the whole US which is over 900 tables. We have all 900 tables set up in our main .WOR templates that we use. It takes about 45 seconds to open the workspace because of the 900 additional tab files. Is there a way to speed up the process? I messed around with merging some tables but it didn't work, so I gave up. Any ideas? Thanks Philip Lesnik Research Systems Analyst Market Research Dept. General Growth Properties www.generalgrowth.com NYSE: GGP 110 N. Wacker Drive Chicago, IL 60606 Phone:312-960-2998 BSC - 3N13G +++Notice: This e-mail including attachments) is covered by theElectronic Communications Privacy Act, 18 U.S.C. §§ 2510-2521, isconfidential and may be legally privileged. If you are not theintended recipient, you are hereby notified that any retention,dissemination, distribution, or copying of this communication isstrictly prohibited. Please reply to the sender that you havereceived the message in error, then delete it. Thank you.+++ ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] MapInfo Pro - Oracle Spatial
I guess you are adding a new record to the table ? If so the problem is that you need to enter a unique value into the column MI_PRINX. The best solution would of course be to add a trigger in the Oracle database, that using a Sequence will update this column for you. This is one of the few things that should be fixed to make the interoperability between MapInfo and Oracle better. Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Monday, April 17, 2006 3:15 AM To: mapinfo-l@lists.directionsmag.com Subject: [MI-L] MapInfo Pro - Oracle Spatial Dear Everyone, I have tried to store spatial data into Oracle Spatial database and it worked. But when I try to open it from MapInfo Professional and make editing and draw some new object into the layer then I save it, the error occur explain that the MI_PRINX value is not unique. Could anybody help me please, how to solve this problem. Thank you. Regards, Alit ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] break polyline feature
Hi, MapInfo 8.0 has a function called 'Break Polyline at node' (translated from danish, so bear with me). This lets you break a selected polyline at a selected node. If you don't have MapInfo 8.0, you can here find a tool called Splitter.mbx that will allow you to split a selected polyline in an existing node: ftp://ftp.kampsax-gis.dk/pub/tools/ I'm not sure if this freeware version also supports splitting a polyline where there is no node, but you can try it. HTH, Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Llewellyn, DavidSent: Wednesday, April 12, 2006 2:43 AMTo: gregCc: MapInfo-L@lists.directionsmag.comSubject: RE: [MI-L] break polyline feature Hi Greg, Another approach might be to use Objects/Overlay Nodes rather than polyline split. Then you can add nodes to the polyline(s) at the required intersection points. This will mean that the original polyline remains as a single feature, but you will be able to snap to that polyline wherever there is a node (you can make the nodes visible using the Display Options for the layer in the Layer Control dialog). You can also then use Polyline Split at Node to break the original polyline into separate features at the nodes you have added, if that is what you need. Actually, Ive often thought that MapInfo should include a Parcelise function such as is found in some other systems that allows you to take a linear network and split it into separate connecting line segments wherever there are intersections. Perhaps others know of some such tool for MapInfo? Cheers David -Original Message-From: greg [mailto:[EMAIL PROTECTED] Sent: Wednesday, 12 April 2006 4:21 AMTo: mapinfo-l@lists.directionsmag.comSubject: [MI-L] break polyline feature HI i have a MI user who needs to break a poly line feature to add new connections to that feature. currently they make the poly line the target, then draw a line in the cosmetic layer intersecting the polyline, select the new line then use object polyline split. this however draws a block around the new line and breaks the poly line in more than one place - the user then has to combine all the bits of the poly line is there a better way to do this? thanks greg ***This Email, together with any attachments is intended for the addressee only. If you have received this Email in error please inform the sender immediately by return Email. Alternatively you can ring the National Native Title Tribunal on the toll free number 1800 640 501 and report the error. Please delete the Email and any copies from your computer and/or computer network. The Tribunal does not warrant that this email is virus free. The Tribunal has also implemented content filtering of Emails to restrict inappropriate and spam emails being received. Other emails which may contain viruses may also be blocked. In either case, and in any case the email may not reach its intended recipient. If the email is important you may wish to see confirmation of its receipt by placing that request in the text of the email. Please resend the email if you haven't received that confirmation as requested. *** ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] Menus - swapping in and out
Terry, A few suggestions, but none completely safe ... 1. Restoring the standard MapInfo Pro menu bar: Create Menu Bar As Default This has the sideeffect that any 3rd part tools embedded in the menus, are gone/lost. I think what actually happens is, that MapInfo reloads the MapInfow.mnu. You could then consider running the MapBasic applications again ... 2. Hiding/removing your own menu: Alter Menu BarRemove "TerrysMenu" This will remove your menu from the Menu Bar, but not restore the default MapInfo Pro menu structure. When you remove the menu, you don't destoy it, so you can easily add the menu again with: Alter Menu BarAdd "TerrysMenu" If you have embedded your own menus in other menus, you could use this syntax: Alter MenuID1 Remove"TerrysMenu" Unfortunately, you can't toggle between two menu bars ... Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Terry McDonnellSent: Wednesday, April 05, 2006 2:02 PMTo: [EMAIL PROTECTED]Subject: [MI-L] Menus - swapping in and out Hi Listers I have my own menu bar items set up but, for testing purposes, I've allowed the standard MI menus to stay up (so I can make GOOD use of them). Now I want to: Replace the std MI menu with my own When the user closes my app's window I want my menus to disappear and the std. MI menu to replace it. This is because my users use native MI too and want to be able to simply revert to this. Now I know all about usng the WinClosedHandler() to bring this about - at the moment I just disappear all my windows. What I'd like is to know a simple and efficient way of achieving the above. The Menu Bar Hide command doesn't specify WHICH menu to hide/show. Is there some way of swapping menus in and out? 'ppreciate it Terry McDonnell ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] MI-L Tool for Batch Opening Large Amount of Tab Files
John, I think there is an upper limit to how many tables you can open at a time. It might be 255, but I'm not sure. I can see two solutions: 1. Make a seamless table that opens a number or all the tables. You do of course have to open the tables once to create the seamless table and the tables need to have the same table structure. 2.Write a Mapbasic application that opens all tables in a folder Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John NottSent: Tuesday, April 04, 2006 10:04 AMTo: MapInfo-L@lists.directionsmag.comSubject: [MI-L] MI-L Tool for Batch Opening Large Amount of Tab Files Hello Listers, I have a massive amount of tab files (from a landline dataset). Which I would like to open to create a base map. However when I highlight all the files to open on the current map, MapInfo does nothing. If I select say 100 of the files to open, then they will open fine but as there are thousands it would take along time to open them this way. Has anyone come across this problem before? Are there any tools that will systematically open a folder full of tab files until they are all open? Any help would as always be very much appreciated. Thanks a million! - John ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] FW: Dialog controls apparently not doing as they're billed
Title: RE: [MI-L] FW: Dialog controls apparently not doing as they're billed Terry, I guess your problem is located in the If statement in your handler. If gcAnalFolder then note yes. gcAnalFolder = + gcAnalFolder ' Alter Button ID GET_AA_FILE_BUTTON_ID enable Alter Button GET_ANAL_FILE_DIALOG enable Else Note There is no folder specified for this type of Accessiblity Analysis File. Alter Button ID GET_AA_FILE_BUTTON_ID disable End If End Sub The command for enabling a button is Alter Control id_num Enable Alter Button ID GET_AA_FILE_BUTTON_ID enable is used for buttons on buttonpads not controls on dialogs HTH, Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Terry McDonnell Sent: Wednesday, March 29, 2006 7:02 PM To: [EMAIL PROTECTED] Subject: [MI-L] FW: Dialog controls apparently not doing as they're billed Update. Maybe indeed a case of being rusty indeed. I included a ReadControlValue() in the handler and it now gets the correct value from the combo/popup menu. However, the button still isn't being enabled. So half solved Terry -Original Message- From: Terry McDonnell Sent: 29 March 2006 17:02 To: [EMAIL PROTECTED] Subject: Dialog controls apparently not doing as they're billed Hi Listers I have a dialog that's not behaving as expected. Perhaps it's cos I'm rusty at the moment but I can't see anything wrong with the code. It has 2 combos. The 2nd is supposed to enable a button on the same dialog, if it finds a value in an array. But no matter what I select from the combo: A) it keeps returning the same index B) even though a value is got from the array the button doesn't get enabled. Code is below. The vars: gnAAStage gnSelAAID are both declared globally and initiated to 1. I originally had a value clause on the popup menus but commented them out in case they were resetting the vars to 1 The Sub GET_ANAL_FILES_FOLDER seems to correctly get gcAnalFolder from the array. My Note trace at the end of GET_ANAL_FILES_FOLDER sub reacts positively anyway (as value 1 is legal) but still the button isn't enabled. Note that I originally tried to enable it via its ID, but I've had problems with this in the past and had no joy, so I changed it to enable the handler instead. Neither works. I've put in a dummy dialog stub for now but it doesn't get invoked. Anybody see the problem? 'ppreciate it Terry McDonnell ' Sub PLOT_OP_FILE_DIALOG ' _ Dim lnSelID as SmallInt If not glGotAAs then Note Sorry. System cannot find Analysis Areas Table. Else DIALOG Title Select Accessiblity Output File to plot Width 240 ... Control PopUpMenu Position 10, 20 Width 220 Title from Variable gaAAreas Into gnSelAAID ... Control PopUpMenu Position 10, 50 Width 130 Calling GET_ANAL_FILES_FOLDER Title from Variable gaAccAnalTypes() Into gnAAStage Control Button Position 10, 70 Title Get Output File ... ID GET_AA_FILE_BUTTON_ID Calling GET_ANAL_FILE_DIALOG Disable Control OKButton Control CancelButton If CommandInfo( CMD_INFO_DLG_OK) Then ... End If End If End Sub ' Sub GET_ANAL_FILES_FOLDER '___ gcAnalFolder = note gnAAStage = + str$(gnAAStage) Do CASE gnAAStage Case 1 gcAnalFolder = MISysOptions.Stage1Fold Case 2 gcAnalFolder = MISysOptions.Stage2Fold Case 3 gcAnalFolder = MISysOptions.Stage3Fold Case 4 gcAnalFolder = MISysOptions.Stage4Fold Case 5 gcAnalFolder = MISysOptions.Stage5Fold End CASE If gcAnalFolder then note yes. gcAnalFolder = + gcAnalFolder ' Alter Button ID GET_AA_FILE_BUTTON_ID enable Alter Button GET_ANAL_FILE_DIALOG enable Else Note There is no folder specified for this type of Accessiblity Analysis File. Alter Button ID GET_AA_FILE_BUTTON_ID disable End If End Sub ' Sub GET_ANAL_FILE_DIALOG '___ DIALOG Control OKButton Control CancelButton End Sub ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] MAPINFO TEMP FILES
Title: MAPINFO TEMP FILES You'll find them here: c:\Documents and Settings\PEM\Local Settings\Temp\ replace PEM with your username/goin Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Peter HattonSent: Thursday, March 30, 2006 8:23 AMTo: mapinfo-l@lists.directionsmag.comSubject: [MI-L] MAPINFO TEMP FILES Hi all, I'm having some strange behaviour with Mapinfo and have seen on this site before suggestions of cleaning out the Mapinfo temp files can someone please indicate where to find these files as I'd like to try this before I uninstall then re-install Mapinfo . Many thanks in advance .. Regards Peter Peter HATTON GIS Officer Greater Taree City Council 2 Pulteney Street TAREE 2430 phone 02 6592 5227 e-mail [EMAIL PROTECTED] gov.au This e-mail has been scanned for viruses by MCI's Internet Managed Scanning Services - powered by MessageLabs. For further information visit http://www.mci.comThis email and any files transmitted with it are intended solely for the use of the individual or entity to whom they are addressed. Greater Taree City Council is a government organisation and is subject to Freedom of Information legislation. You must assume that any material sent to Greater Taree City Council may be accessible by persons other than the intended recipient. The contents of this message may express views and opinions not necessarily shared by Greater Taree City Council. ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] Unable to Make DBMS Table Mappable
Alan, I think the problem is that the table MapInfo_MapCatalog hasn't been created in the database. You can easily create this table using the DBMS Catalog tool that you'll find in the Tool Manager. HTH, Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Alan Hale Sent: Monday, March 27, 2006 3:30 PM To: MapInfo-L Subject: [MI-L] Unable to Make DBMS Table Mappable I have an ODBC data source to a SQL Server DB and am able to open a connection and a table successfully in MapInfo via DBMS. But when I try to make the table mappable (using Lat/Long fields and index type XYCoordinates) I get an error back from the ODBC driver Invalid Object name 'MAPINFO.MAPINFO_MAPCATALOG, followed by The table you have chosen cannot be made mappable. To be made mappable the table must contain a spatial column or at least 2 numeric columns. Any help please? ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] Unable to Make DBMS Table Mappable
You need to close the table and reopen it from the database. If you have opened the table and it wasn't mappable, MapInfo will not check to see if it has been mappable until you reopne the table from the database. It's not enough to close the table and reopen the table using the tab file. Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis -Original Message- From: Alan Hale [mailto:[EMAIL PROTECTED] Sent: Monday, March 27, 2006 7:03 PM To: Peter Horsbøll Møller; MapInfo-L Subject: RE: [MI-L] Unable to Make DBMS Table Mappable Peter Many thanks for this, it does away with the error message. However, I am still puzzled. I can't open a map window on the table, and Create Points is greyed out? What do I do after making the table mapapple? Regards Alan Peter Horsbøll Møller [EMAIL PROTECTED] 27 March 2006 Alan, I think the problem is that the table MapInfo_MapCatalog hasn't been created in the database. You can easily create this table using the DBMS Catalog tool that you'll find in the Tool Manager. HTH, Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Alan Hale Sent: Monday, March 27, 2006 3:30 PM To: MapInfo-L Subject: [MI-L] Unable to Make DBMS Table Mappable I have an ODBC data source to a SQL Server DB and am able to open a connection and a table successfully in MapInfo via DBMS. But when I try to make the table mappable (using Lat/Long fields and index type XYCoordinates) I get an error back from the ODBC driver Invalid Object name 'MAPINFO.MAPINFO_MAPCATALOG, followed by The table you have chosen cannot be made mappable. To be made mappable the table must contain a spatial column or at least 2 numeric columns. Any help please? ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] RE: MapWorld 2006 (Phoenix)
Hi Warren, I guess some people last year didn't pay the bill from their minibar, so MapInfo is trying to get the money for these in some way. A good thing that they only ask people who went last year to pay a part of that bill ;-) Good idea with the stickers. Let me know if you don't make it this year. I'll se if I can arrange for some stickers. Maybe I just need a handful of stickers ;-) Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Warren Vick, Europa Technologies Ltd. Sent: Monday, March 27, 2006 7:42 PM To: 'Bagwell, Ross'; mapinfo-l@lists.directionsmag.com Subject: RE: [MI-L] RE: MapWorld 2006 (Phoenix) Hello Ross, I didn't see any response to you query on the list re. MapWorld! I usually go but am unsure about this year, particularly as the early bird pricing has now passed. I usually make some I'm on MapInfo-L stickers for the conference badges and I think there were about 10 listers attending last year (excluding MapInfo staff). Did anyone else notice some of the odd pricing for the event? For example, when the very early bird prices were available (finished back in November I believe), the cost of going to the event was $795 but $895 if you attended last year (MapWorld Miami Alumni). There are some other inconsistencies too. Regards, Warren Vick Europa Technologies Ltd. http://www.europa-tech.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bagwell, Ross Sent: 17 March 2006 15:03 To: mapinfo-l@lists.directionsmag.com Subject: [MI-L] RE: MapWorld 2006 (Phoenix) Speaking of MapWorld, I'm wondering if we could make a list of those of us on MI-L that will be in attendance. That way, we could have a mini-meeting of sorts. It would be nice to know the faces behind the names. ? Ross E. Bagwell GIS Manager, Business Intelligence Vanco USA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Bill Thoen Sent: Friday, March 17, 2006 8:07 AM To: mapinfo-l@lists.directionsmag.com Subject: [MI-L] New Moderator for MapInfo-L Since starting MapInfo-L with John McCombs in 1994 I've been doing the list maintenance ever since, but it occurred to me that if I ever get struck by lightning or win the lottery, there'd be no one else ready and able to keep things going. So last week I was talking to Peter Horsbøll Møller and asked if he would like to take on the job as co-moderator so that I could take a break once in a while. He agreed, so now when you send questions or requests to [EMAIL PROTECTED] you'll be talking to both of us (or whoever is driving at the time.) Those who are well-aquainted with the list have seen Peter's many helpful postings over the last few years, and I think he's got the knowledge and energy to do a great job. If you want to find out a bit more, you can read his bio on the MapInfo-L Wiki or go to http://www.horsboll-moller.dk/peter_eng.html. Also, he told me he'll be at MapWorld this year, so if you're going, you can meet him in person. That's all the new for now! - Bill Thoen ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ** Any opinions expressed in the email are those of the individual and not necessarily the company. This email and any files transmitted with it are confidential and solely for the use of the intended recipient. If you are not the intended recipient or the person responsible for delivering it to the intended recipient, be advised that you have received this email in error and that any dissemination, distribution, copying or use is strictly prohibited. If you have received this email in error, or if you are concerned with the content of this email please e-mail to: [EMAIL PROTECTED] The contents of an attachment to this e-mail may contain software viruses which could damage your own computer system. While the sender has taken every reasonable precaution to minimise this risk, we cannot accept liability for any damage which you sustain as a result of software viruses. You should carry out your own virus checks before opening any attachments to this e-mail
RE: [MI-L] Overlap analysis - Oracle tables
Title: Overlap analysis - Oracle tables David, How big is the difference if you use the CartesianArea() function in MapInfo ? Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis From: Llewellyn, David [mailto:[EMAIL PROTECTED] Sent: Friday, March 24, 2006 3:29 AMTo: Peter Horsbøll MøllerCc: MapInfo-L@lists.directionsmag.comSubject: RE: [MI-L] Overlap analysis - Oracle tables Peter, In the version of Oracle Spatial we are running (9.2.0.6.0) the querytype parameter must be included. I have tried querytype=JOIN But the results are still the same. See the actual query and output below: 1 SELECT A.TRI_NUM, SDO_GEOM.SDO_AREA(SDO_GEOM.SDO_INTERSECTION(A.GEOLOC, B.GEOLOC, 0.005), 0.005, 'unit=SQ_KM') "OLAP" 2 FROM NTDA_REG_QLD A, NTDA_SCH_QLD B 3 WHERE B.TRI_NUM = 'QQ99/9' 4* AND SDO_RELATE(A.GEOLOC, B.GEOLOC, 'mask = ANYINTERACT querytype=JOIN') = 'TRUE' TRI_NUM OLAP -- -- QC99/xx .055406902 QC97/yy 21061.2942 QC02/zz .539097535 QC99/pp 1278.13187 The areas above differ from the areas output by MapInfo (using the Area function) by a factor of about 0.9974. Best regards, David Llewellyn. -Original Message-From: Peter Horsbøll Møller [mailto:[EMAIL PROTECTED] Sent: Thursday, 23 March 2006 8:00 PMTo: Llewellyn, DavidSubject: RE: [MI-L] Overlap analysis - Oracle tables Hi David, Try without the querytype=WINDOW Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis From: Llewellyn, David [mailto:[EMAIL PROTECTED] Sent: Thursday, March 23, 2006 2:06 AMTo: Peter Horsbøll MøllerSubject: RE: [MI-L] Overlap analysis - Oracle tables Thanks for the suggestion Peter, A useful one. The results however, are the same. Still, would be interested to know if you come up with anything that might be useful from your course. From my initial reading, I think the problem might have something to do with the SRID number in the USER_SDO_GEOM_METADATA view (see below). Unfortunately, my knowledge of Oracel Spatial is still pretty scant, so actually how to update that number is so far a mystery. Best regards, David Llewellyn ***This Email, together with any attachments is intended for the addressee only. If you have received this Email in error please inform the sender immediately by return Email. Alternatively you can ring the National Native Title Tribunal on the toll free number 1800 640 501 and report the error. Please delete the Email and any copies from your computer and/or computer network. The Tribunal does not warrant that this email is virus free. The Tribunal has also implemented content filtering of Emails to restrict inappropriate and spam emails being received. Other emails which may contain viruses may also be blocked. In either case, and in any case the email may not reach its intended recipient. If the email is important you may wish to see confirmation of its receipt by placing that request in the text of the email. Please resend the email if you haven't received that confirmation as requested. *** ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] polygon overlay(calculating area share from differentpolygons)
Title: RE: [MI-L] polygon overlay(calculating area share from differentpolygons) Hi, This should do the trick: Select TABLE_A.ID, TABLE_B.ID, CartesianArea(Overlap(TABLE_A.OBJ, TABLE_B.OBJ), sq m) AREA_SQ_M From TABLE_A, TABLE_B Where TABLE_A.OBJ Intersects TABLE_B.OBJ You might also want to add this condition to remove all the cases where an OBJ in TABLE_A only intersects an OBj in TABLE_B And CartesianArea(Overlap(TABLE_A.OBJ, TABLE_B.OBJ), sq m) 0 You can run the entire SQL Statement from the MapBasic window or use the SQL Select dialog: Select Columns: TABLE_A.ID, TABLE_B.ID, CartesianArea(Overlap(TABLE_A.OBJ, TABLE_B.OBJ), sq m) AREA_SQ_M From Table(s): TABLE_A, TABLE_B WhereTABLE_A.OBJ Intersects TABLE_B.OBJ And CartesianArea(Overlap(TABLE_A.OBJ, TABLE_B.OBJ), sq m) 0 HTH, Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of shamas Sent: Sunday, March 19, 2006 2:11 PM To: mapinfo-l@lists.directionsmag.com Subject: [MI-L] polygon overlay(calculating area share from differentpolygons) Greetings all I am a beginner user of MapInfo. The problem looks to be simple but I am stuck with it. I have two maps with polygons say table A and B. I want to calculate which polygons from table B overlay each polygon in table A and what is the share of area from corresponding polygons in Table B. I have tried to use update column and join the table using the polygon from Table A intersects Polygon from Table B but it just returns one polygon from the Table B intersecting with polygon from table A while others are not. I would much appreciate if someone can help me with this problem. Regards Shamas ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] Query for determining Entirely Within/Outside of Buffer
Akua, The problem is that MapInfo can't join on these condition. MapInfo can only join on a compare statement either with = or using one of the spatial operators. I'm pretty sure that you can't negate these statements. So you can only find a solution using the sub select: Select * From CT2000 Where not obj Partly Within Any (Select objFrom BranchesBuffer) or you can choose a different method where you join your two columns on two new temporary column, could be Integer or Char(1) and add a condition to the join afterwards. You can do that like this: 1. Add a new Integer column to CT2000, let's call it ID_INT 2. Add a new Integer column to BranchesBuffer, let's call it ID_INT 3. DO NOT update this column with any value. It is suppose to hold the value 0 (zero) for all records 4. Do this SQL Statement: Select * From CT2000, BranchesBuffer Where CT2000.ID_INT = BranchesBuffer.ID_INT And Not CT2000.obj Partly Within BranchesBuffer.obj What is going on here, you might ask ??!! I think Lars Nielsen explained this method earlier. The first condition (CT2000.ID_INT = BranchesBuffer.ID_INT) makes sure that every records in CT2000 is joined with every record in BRANCHESBUFFER because every record in both table has the same value in these columns, which is 0 (zero). This is known as the Cross Join or Cartesian Product. The resultset will contain as many reocrds as the number of records in table CT2000 times the number of records in table BRANCHESBUFFER. The second condition adds a condition to the resultset telling MapInfo only to return the records where not the object from CT2000 is partly within the object of BRANCHESBUFFER. It should work. One thing that I can garanti you, is that it is going to take a while ;-) Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Terry McDonnellSent: Monday, March 20, 2006 10:44 AMTo: [EMAIL PROTECTED]; [EMAIL PROTECTED]Subject: RE: [MI-L] Query for determining Entirely Within/Outside of Buffer Akua Perhaps you could try: Where not(CT2000.objintersects BranchesBuffer.obj) Iy might be useful if you include the FULL SQL select you used as, given what you supplied, I can't immediately see any fault with it that would cause the error. Terry From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]Sent: 17 March 2006 22:01To: Terry McDonnellSubject: RE: [MI-L] Query for determining Entirely Within/Outside of Buffer Thank you s much Peter and Terry! I tried it out and have no problems with getting the tracts that are entirely within or partly within, but when I get to querying objects "Not Partly Within" (Entirely Outside) I keep getting the error message: "No Join Specified between tables, Invalid Join Condition in Where Clause" and I cannot figure out what the problem is. The tables I have are called: CT2000 and BranchesBuffer This is what I enter: 1) Where not CT2000.obj Partly Within Any BranchesBuffer.obj and after this didn't work I tried 2) Not (CT2000.obj Partly Within BranchesBuffer.obj) and I still got an error message. Any suggestions? Thanks! Akua ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] Run Application
Simon, Some time ago I hade the same request and a friendly person (I think it was Bo Thomsen)on MapInfo-L supplied me with a Delphi DLL, that could do the trick. The trick is to use a Windows API function that can wait for the called application to finish, before returning to the caller. Let me know if you are interested and I'll send you the snippet that was given to me. As it contains files, I can't send them thru MapInfo-L Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 5260 Odense S. Denmark Tel + 456311 4900 Dir+45 6311 4908 Mob+45 5156 1045 Fax + 45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk From: [EMAIL PROTECTED] on behalf of Terry McDonnellSent: Fri 17-Mar-06 12:08To: Simon Allen; [EMAIL PROTECTED]Subject: RE: [MI-L] Run Application Simon Not sure that the 1st will have finished before the 2nd begins? Don't know myself. The first could set like a semaphore flag, in a table, and the second could wait for this flag to have been set before running. e.g. Dim llGoAhead as logical llGoAhead = FALSE Run application "App1" ' When this app finishes it sets flag SemaTable.LSEMFLAG Do while not llGoAhead Select LSEMFLAG from SemaTable into csrTemp llGoAhead = csrTemp.LSEMFLAG Loop Run application "App2" This might not be necessary if the apps run discretely but HTH Terry From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Simon AllenSent: 17 March 2006 10:46To: Terry McDonnellSubject: [MI-L] Run Application Hi I have a script which issues two Run Application commands. How can I ensure that the first application has finished running before issuing the second command? Ta Simon Allen Senior GIS Officer [EMAIL PROTECTED] South Gloucestershire Council 01454 863655 (direct) 01454 863855 (fax) http://www.southglos.gov.uk ** This email and any files transmitted with it from South Gloucestershire Council are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the South Gloucestershire Council Postmaster at the address below. This footnote also confirms that this email message has been swept for the presence of computer viruses. [EMAIL PROTECTED] ** ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
