List of Contributions

James Nolet

MapInfo Pro 17 Beta

Contact Details

My Content

1 to 20 of 50+ total

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

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