List of Contributions

Thanks Tom, this had interesting results. If I put all three queries into a workspace using NotePad; I do get the desired result, being able to browse the final_result. However, if I resave the workspace, the third Select statement is automatically removed. Perhaps this is because it isnt using a ...

Hi Tom, here is a description of the result Im looking for. Ill use colours instead of table names: Give me the data of all blue objects, whose centroids are within Square #1, but only if they intersect yellow objects greater than 50 hectares in size.

Here is a map screenshot showing my SQL and the error. I think, perhaps, that the geographical join is not compatible with a sub-select. Ive never used joins of three tables, or even sub-selects previously.

Sometimes, well often actually, I need a sub-selection of data on a map. To avoid making a new base layer which could become obsolete; here are the options I use: Use an SQL query on a single table, adding it as a layer. Use an SQL join (data or geographical) on two tables, adding it as a layer. ...

When (*if*) a hostile foreign power, or asteroid, destroys the license server; will current activated licenses continue to operate indefinitely? Perhaps there is a backup server in Patagonia or somewhere?