List of Contributions

James Nolet

MapInfo Pro 17 Beta

Contact Details

My Content

1 to 20 of 50+ total
Posted By James Nolet 05-05-2024 23:54
Found In Egroup: Spectrum Spatial (SSA/LIM)
\ view thread
Hi Duri, As the documentation says, GDA2020 is supported in 18.2. I assumed this meant it would be supported as a base layer, but that is not the case (as far as I can tell). In 12.1 or 12.2, to ensure that the map is rendered as GDA94 Zone 55 we had to have a base map in this projection. I recall ...
Posted By James Nolet 05-01-2024 04:04
Found In Egroup: Spectrum Spatial (SSA/LIM)
\ view thread
Hi Duri, Thanks for giving this a go - I greatly appreciate it and the feedback. This pretty much confirms my conclusion. It would have been good if this information was available in official Precisely documentation but I guess we don't want things to be too easy - or we'd be out of a job! (Sorry ...
Posted By James Nolet 03-26-2024 02:23
Found In Egroup: Spectrum Spatial (SSA/LIM)
\ view thread
Hi, I haven't been able to find a specific answer as to whether EPSG 7855 is supported as a base layer in SSA. My experience in SSA v2018.1 is as follows: Business layers are in EPSG 7855 and display with no problem. Within Project Settings, I add a EPSG 7855 tile layer (created in Spatial Manager) ...
Posted By James Nolet 01-31-2024 08:14
Found In Egroup: MapInfo Pro
\ view thread
No problem; I'm glad it worked and I was able to help! ------------------------------ James Nolet GIS Manager Caf Consulting Mentone office, VIC, Australia ------------------------------
Posted By James Nolet 01-31-2024 07:37
Found In Egroup: MapInfo Pro
\ view thread
Hi Mayca, It is not clear in your sample code how exactly you are implementing this, but it looks like you are populating the ListBox using a string variable. Perhaps it is this that has the limitation. If you use the array gblCONDUCCIONES_ARRAY directly you might have more luck. That is, the ListBox ...
Posted By James Nolet 01-30-2024 17:39
Found In Egroup: MapInfo Pro
\ view thread
Hi Mayca, You cannot use an "If" condition within your "Dialog" statement. You need to set up the variables beforehand instead. To do this, I would use variables to position the buttons off-screen (that is, outside the boundary of the Dialog) if they are not to be displayed. Therefore, before calling ...
Posted By James Nolet 12-03-2023 19:12
Found In Egroup: MapInfo Pro
\ view thread
Hi Peter, Yes, it is not possible to join the tables and carry out the required update in a single Update statement. The join needs to be done separately. For anyone using pre-v17 MapInfo, the leading comma can be removed as follows (going back to the table and column names used in my example): ...
Posted By James Nolet 12-01-2023 08:06
Found In Egroup: MapInfo Pro
\ view thread
Hi Chris, First, join your two tables together: Select * from pupils, School_Catchment where pupils.Obj Within School_Catchment.Obj into JoinTable Then perform the update using the below expression. In the following, 'Catchments' is the name of the new column you have created in the pupil table, ...
Posted By James Nolet 11-30-2023 22:02
Found In Egroup: MapInfo Pro
\ view thread
Hi Wahida, I came up with the following SELECT statements for doing this. Perhaps there is a way of combining these, but I had trouble due to restrictions on how RowID can be used. Anyway, this should get you the result you need. In the below, I have used a table called "Scores" and I am finding the ...
Posted By James Nolet 11-02-2023 04:23
Found In Egroup: MapInfo Pro
\ view thread
Hi Duncan, I came up with the following but it will only give the MBC of the MBR of the polygon: First, issue the following in the MapBasic Window: Set Distance Units "m" (ensure the units string matches that used by your table's coordinate system) Then execute the following Select statement ...
Posted By James Nolet 11-02-2023 03:47
Found In Egroup: MapInfo Pro
\ view thread
Hi Wahida, Try listing the names of the columns you are grouping on in the "Group By Columns" text box, separated by commas. In your first query, that would be: Population_by_MUKIM.MUKIM and in your second: Population_by_MUKIM.MUKIM, POI.DESCRIPTION ------------------------------ James Nolet ...
Posted By James Nolet 07-19-2023 03:04
Found In Egroup: Spectrum Spatial (SSA/LIM)
\ view thread
Hi Caleb, This somehow reminds me of an issue I had with a trailing space in the name of a SQL Server table. This is just a guess, but it might be worth checking for trailing spaces in the name of the tables for which you are having issues. ------------------------------ James Nolet Dooley Mitchell ...
Posted By James Nolet 05-15-2023 13:00
Found In Egroup: MapInfo Pro
\ view thread
Hi Sebastian, I have a couple of methods you might like to try. These are manual solutions but you could use the logic to develop a MapBasic program if needing to automate for large datasets or if you want to repeat the process on a number of datasets. I am not sure if the first method will always succeed ...
Posted By James Nolet 01-26-2023 06:07
Found In Egroup: MapInfo Pro
\ view thread
I might try to explain the triple quotes.  Your expression without using variables would be: Select * From table1 where field1 = "Area1" Into _YOURAREA When assigning the expression to a string, the string itself uses quote characters to encapsulate the string.  First, let's say "Area1" is assigned ...
Posted By James Nolet 01-25-2023 19:04
Found In Egroup: MapInfo Pro
\ view thread
Hi Ryan, In that case, check the contents of tName (e.g. via a Print statement).  Is it blank? In fact, if you assign the whole expression to a string variable: Dim sStr As String sStr = "Select * From " + tAreas + " where " + tName + " = """ + tYourArea + """ Into _YOURAREA" Then print it ...
Posted By James Nolet 01-25-2023 08:51
Found In Egroup: MapInfo Pro
\ view thread
Hi Ryan, I understand your frustration!  For Mapbasic-executed queries to be ignored when saving the workspace seems quite strange.  Furthermore, any subsequent queries or windows created from the original query are also ignored. Anyway, in your example query above, try the following: Run Command ...
Posted By James Nolet 10-17-2022 07:51
Found In Egroup: MapInfo Pro
\ view thread
Hi Alban, I'm not sure I understand, but can't you just draw straight lines connecting the points then create a 50m buffer around each one? ------------------------------ James Nolet Dooley Mitchell & Morrison Pty Ltd Mentone, VIC, Australia ------------------------------ ---------------- ...
Posted By James Nolet 09-30-2022 04:18
Found In Egroup: MapInfo Pro
\ view thread
Hi Fanny and Peter, If they are "empty", perhaps they can be selected by attribute? However, they look like text object to me.  In that case, they can be selected via the following SQL (using the MapBasic or SQL Window): Select * From Polygons Where str$(obj)="text" Into Selection Then ...
Posted By James Nolet 09-13-2022 03:25
Found In Egroup: MapInfo Pro
\ view thread
Hi Nick, Yes, Create Parallel comes with the MapCAD tool.  I forgot about that, as I always have it loaded and end up taking its functionality for granted. Checking MapBasic Help I can see that you can call the MapCAD functions.  For example, if you select a single line and execute the following ...
Posted By James Nolet 09-12-2022 19:57
Found In Egroup: MapInfo Pro
\ view thread
Hi Nick, Try Create Parallel from the Buffer drop-down in the Spatial menu.  It seems to do the trick.  You can create parallel lines on either side of your existing lines, close them off and even create them as regions. ------------------------------ James Nolet Dooley Mitchell & Morrison Pty ...