List of Contributions

James Nolet

MapInfo Pro 17 Beta

Contact Details

My Content

1 to 20 of 50+ total

RE: Cannot Run Summary Query on Pen Style

Posted By James Nolet 05-21-2025 21:47
Found In Egroup: MapInfo Pro \ view thread
Hi Steve, If you are selecting a column that is not listed as a group by column, you need to use an aggregate function e.g. Max(). These are available from the Aggregates drop-down in the SQL Select Dialogue. However, using an aggregate on ObjectInfo(obj,2), which returns a Pen Style, is not realistic ...

RE: Registering SQL Server Spatial DB View with MAPCATALOG

Posted By James Nolet 04-21-2025 20:23
Found In Egroup: MapInfo Pro \ view thread
Hi Dhan, Did you include geometry and ID fields (e.g. SP_Geometry, MI_Prinx) in your view? ------------------------------ James Nolet GIS Manager Caf Consulting Mentone office, VIC, Australia ------------------------------

RE: Registering SQL Server Spatial DB View with MAPCATALOG

Posted By James Nolet 04-17-2025 02:02
Found In Egroup: MapInfo Pro \ view thread
Hi Dhan, I use the below SQL to update, where the coordinate system is for MGA 2020 Zone 55 the spatial type is one of the following: 17 - point 17.1 - line 17.2 - region 17.3 - multiple spatial types The "DB_" prefixed fields are the coordinate system bounds RENDITIONCOLUMN contains ...

RE: Update column expression to make the first letter of every word capital (Title Case)

Posted By James Nolet 03-25-2025 07:20
Found In Egroup: MapInfo Pro \ view thread
Hi Dhan, I use the help available via MapBasic, which can be downloaded here: https://support.precisely.com/product-downloads/ You can also bring up the MapBasic Reference within MapInfo, such as by selecting "MapBasic Reference" from the Help dropdown in the SQL window: ------------------------------ ...

RE: Update column expression to make the first letter of every word capital (Title Case)

Posted By James Nolet 03-25-2025 01:22
Found In Egroup: MapInfo Pro \ view thread
Hi Dhan, You might be after Proper Case. In that "case", you can use the Proper$ function. ------------------------------ James Nolet GIS Manager Caf Consulting Mentone office, VIC, Australia ------------------------------

RE: Erro loading polygon in MapInfo Pro

Posted By James Nolet 01-21-2025 19:57
Found In Egroup: MapInfo Pro \ view thread
Hi Dhan, To find polygons that SQL Server considers invalid, execute the following in SQL Server: SELECT * FROM WHERE .STIsValid() = 0 Where is the problem table and is the name of the geometry column within that table. You can make them valid (according to SQL Server rules) by executing ...

RE: Reprojecting existing Mapinfo objects in the database (SQL Server)

Posted By James Nolet 01-06-2025 01:41
Found In Egroup: MapInfo Pro \ view thread
Hi Dhan, You shouldn't need to download then upload. If your version of FME does not support the SQL Serve spatial writer you could use Open Source software ogr2ogr, which is what we have used for some of our clients. After the transformation you might also need to update the MapInfo_MapCatalog table ...

RE: Missing Map Window

Posted By James Nolet 11-26-2024 21:29
Found In Egroup: MapInfo Pro \ view thread
Hi Mark, You could try to "Recover Offscreen Windows" - from the "Home" tab, select this from the "New Document Windows" drop-down, under "Window Commands": If this works, you can perhaps then re-save your workspace so this doesn't happen again for this workspace. ------------------------------ ...

RE: Queries - Finding Multiple text

Posted By James Nolet 11-14-2024 01:41
Found In Egroup: MapInfo Pro \ view thread
Hi Alex, I'm glad it worked after the restart. There's no way to combine the two unfortunately. ------------------------------ James Nolet GIS Manager Caf Consulting Mentone office, VIC, Australia ------------------------------

RE: Queries - Finding Multiple text

Posted By James Nolet 11-13-2024 19:40
Found In Egroup: MapInfo Pro \ view thread
Hi Alexis, You can use the following expression in the Where clause: hydroname in ("ALEXANDER", "ANVIL") Another option is to use the following: hydroname = "ALEXANDER" Or hydroname = "ANVIL" (Note that the following is invalid: hydroname = "ALEXANDER" Or "ANVIL") Wildcards are also possible, ...

RE: Any issues when upgrading to MapInfo Pro v2023 from older versions

Posted By James Nolet 10-31-2024 16:57
Found In Egroup: MapInfo Pro \ view thread
Hi Finlay, I'm still running 32-bit office with the 64-bit MapInfo v2023 and have no issues. Issues with this only arose early on when the MapInfo installation forced the 64-bit MS Office engine to be installed, which wasn't good if you wanted to retain your 32-bit office applications. But the 2023 ...

RE: Visual Studio Code Language Extension For MapBasic

Posted By James Nolet 10-31-2024 00:41
Found In Egroup: MapInfo Pro Developers User Group \ view thread
Hi Jeremy, Thanks very much for doing this and making it available. I have installed this and will hopefully get a chance to give it a go - when I am not so busy (it might happen one day!) ------------------------------ James Nolet GIS Manager Caf Consulting Mentone office, VIC, Australia ------ ...

RE: Using a variable with layer filter

Posted By James Nolet 10-20-2024 18:19
Found In Egroup: MapInfo Pro \ view thread
Hi Ryan, You probably have to use Set Command: Dim sCmd As String sCmd = "Set Map Window 3297 Layer REGIONS Filter where Name = """ + Reg + """" Run Command sCmd ------------------------------ James Nolet GIS Manager Caf Consulting Mentone office, VIC, Australia ------------------------- ...

RE: Line in the middle of Polygon

Posted By James Nolet 07-31-2024 22:23
Found In Egroup: MapInfo Pro \ view thread
Hi Saqib, How about the following steps - this will create approximate centrelines. That is, they won't be perfectly placed an equidistance from each side of the road or footpath. You will need to ensure you are running the "MapCad" MapBasic Tool Add In, which will provide the required tools under ...

RE: Is SSA 2024 due soon?

Posted By James Nolet 07-30-2024 22:19
Found In Egroup: Spectrum Spatial (SSA/LIM) \ view thread
Great list Duri! Tim (or anyone else), whilst PBLinks/PLinks provides great functionality (once set up), we have a method for bypassing PLinks if you're interested. ------------------------------ James Nolet GIS Manager Caf Consulting Mentone office, VIC, Australia ------------------------------

RE: What Projection is an object variable?

Posted By James Nolet 07-02-2024 06:35
Found In Egroup: MapInfo Pro \ view thread
I don't believe that saving to Long/Lat helps. It might appear that your objects are placed correctly for your comparison, but you can't produce greater accuracy out of thin air. The nodes of your region may shift, but will not be more accurate. If your regions table is accurate in the first place then ...

RE: What Projection is an object variable?

Posted By James Nolet 07-02-2024 05:40
Found In Egroup: MapInfo Pro \ view thread
Hi Ryan, Something I always keep in mind when working with projected coordinates is to ensure that the coordinate system of the table I am working with (projected GDA94 or GDA2020 for me, usually) includes a bounds clause. The accuracy (that is, the number of decimal points) of the coordinate values ...

RE: Where expression for Delete statements

Posted By James Nolet 06-25-2024 20:27
Found In Egroup: MapInfo Pro \ view thread
I also forgot to mention that Peter will have a better solution! Thanks Peter - I'll make sure I give the AggregateCombine function a go myself. ------------------------------ James Nolet GIS Manager Caf Consulting Mentone office, VIC, Australia ------------------------------

RE: Where expression for Delete statements

Posted By James Nolet 06-24-2024 11:16
Found In Egroup: MapInfo Pro \ view thread
In addition to the above, I forgot to mention that the sub-select method: Select * From City_STREETS Where obj within any (Select obj From Cities Where Cities.City like "City ,County") can be a lot slower to execute where you have a lot of data. The alternative join/update method that I provided ...

RE: Where expression for Delete statements

Posted By James Nolet 06-23-2024 20:58
Found In Egroup: MapInfo Pro \ view thread
Hi Derrick, First, I think you have a typo in your post for the first Delete statement: the correct syntax is "Delete from selection". However, that won't work in your case because your select statement will produce a view of two joined tables. Changing your select statement to the following might ...