Hot answers tagged

3 votes

SQL select the two values that bounds an input value

In SQL, something like this might work, I assume that your geodatabase is installed on a SQL Server : SELECT TOP 1 id, date FROM date_table WHERE date < CAST('10/06/2022' as date) ORDER BY date ...
user avatar
  • 12.5k
2 votes

ArcGIS Pro Definition Query between two tables

Even though there were no nulls in the target layer, by virtue of joining tables where the join table has UniqueId populated from the target table once a feature is drawn, it starts by having nothing ...
user avatar
  • 1,445
2 votes

Convert linestringz to linestringm using alter column?

As said in the comments it would be necessary put your conversion code in a function like this: CREATE OR REPLACE FUNCTION make_multilinestringm(geometry) RETURNS geometry(multilinestringm,4326) AS $$ ...
user avatar
  • 508
1 vote
Accepted

Duplicated attributes problem while adding attributes of points to attribute table of lines in QGIS

Open the field calculator in the lines layer and calculate the fields with this expression. For the start of the line: aggregate( 'Points', -- replace Points with the points layer name/id '...
user avatar
  • 1,107
1 vote
Accepted

ST_Union in Apache Sedona

Never use Sedona myself but a quick look at the documentation shows that a function ST_Union_Aggr exists and seems to do what you need: %sql SELECT Polygon_Name ,ST_Union_Aggr(Polygon_Boundary)...
user avatar
1 vote

Trying to query by date attribute but getting incorrect error

It turns out I do need to use the 8601 format as recommended above, but also enter the word 'timestamp' in front... Without 'timestamp' I get this error:
user avatar
  • 23

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