List of Contributions

James Nolet

MapInfo Pro 17 Beta

Contact Details

My Content

1 to 20 of 50+ total

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

RE: ERROR IN CONDITION WITHIN A DIALOGUE BOX

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

RE: Returning multiple spatial results for single row of a table

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

RE: Returning multiple spatial results for single row of a table

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

RE: Statistic Calculation in MapInfo

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

RE: Minimum bounding circle

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

RE: SQL: Calculate count of object within each subdistrict based on object's category

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

RE: Table not found error

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

RE: Thinning overlapping polygons

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

RE: Variables in a Run Command String (Queries not saving to workspaces)

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

RE: Variables in a Run Command String (Queries not saving to workspaces)

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

RE: Variables in a Run Command String (Queries not saving to workspaces)

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

RE: rotated rectangle drawing between 2 points

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

RE: Smaller polygons within polygon

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

RE: Square ended buffer of line?

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

RE: Square ended buffer of line?

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

RE: Providing Spectrum map layers to external applications via API

Posted By James Nolet 09-10-2022 00:25
Found In Egroup: Spectrum Spatial (SSA/LIM) \ view thread
Hi Russell, Applinking can be set up in v2020.1.  We have had it going in earlier versions.  I don't know if an upgrade to the tool has occurred since 2020.1, but if so then I'm sure that can be sorted out with Precisely.  There are also alternatives to the Applinking tool (based on the same logic) ...

RE: Providing Spectrum map layers to external applications via API

Posted By James Nolet 07-27-2022 02:10
Found In Egroup: Spectrum Spatial (SSA/LIM) \ view thread
I might have had the wrong idea, but was thinking more on the lines of interacting with the SSA front end directly - that is, dynamic linking - via the Precisely Applinking tool or similar (which we at DMM managed to make use of in our GISLink product, hence why I was keen to espouse my knowledge of ...