Hot answers tagged

2

Your current SQL expression does not return anything from the current selection because (SELECT MIN( DIRECTIONALITY) FROM TableName) always evaluates to 1, which is indeed the minimum value for the whole table. You need to take the minimum value from just the rows that meet the condition WORKINGSPACE = 'Jeffery' and you can do this in one selection instead ...


2

late to the party but not enforcing any spatial agg should be way quicker: select min(ST_XMin(geom)) as l, min(ST_YMin(geom)) as b, max(ST_XMax(geom)) as r, max(ST_YMax(geom)) as t from x


1

CREATE TABLE schema.polytable AS SELECT column1, column2, ST_AsText(ST_CONVEXHULL(ST_COLLECT(geomcolumn))) AS newgeomcolumn FROM schema.sourcetable GROUP BY column1, column2 As suggested by someone else, this works in this scenario.


1

These eight-digit values are in a column in MapInfo, correct? If you also have them in one column in NotePad, you can join the two tables where the NotePad values have matches in the MapInfo table; then delete the resulting join/selection from MapInfo.


1

The a and b are aliases for the nodesData table, you use the alias to refer to the table in the rest of the query. The two queries below are the same except the second uses aliases for the table names. SELECT Customers.name, Customers.address, Customers.email, tableY.OrderNum, tableY.OrderDate FROM Customers JOIN Orders ON Customers.CustomerID = tableY....


Only top voted, non community-wiki answers of a minimum length are eligible