List of Contributions

James Nolet

MapInfo Pro 17 Beta

Contact Details

My Content

1 to 20 of 50+ total

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 ...

RE: Support for GDA2020 MGA55 (EPSG 7855) as a base layer

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 ...

RE: Support for GDA2020 MGA55 (EPSG 7855) as a base layer

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 ...

Support for GDA2020 MGA55 (EPSG 7855) as a base layer

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) ...

RE: LISTBOX does not load all records

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 ------------------------------

RE: LISTBOX does not load all records

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 ...