Land Technologies
< all posts

Posts tagged "postgres" (3)

An Intro To Geospatial Data With PostGIS

July 02, 2021 · 5 min read datasqlpostgrespostgis

In this tutorial, we will explore how to use PostGIS for storing and querying geospatial data. It will be a fairly pragmatic tutorial, and…

/advanced-sql/postgis/beginners-guide/

SQL Window Functions

June 29, 2021 · 4 min read datasqlpostgres

The data team often faces situations where standard aggregation functions, GROUP BY or DISTINCT ON won’t give us the results we need. To…

/advanced-sql/window-functions/

Postgres SQL Distinct On

June 29, 2021 · 4 min read datasqlpostgres

The data team at LandTech were recently looking at the Postgres DISTINCT ON function for a particular data transformation in our pipelines…

/advanced-sql/distinct-on/
© 2021, Built with Gatsby
LAND TECHNOLOGIES LTD, m: WeWork c/o LandTech, 10 Devonshire Square, London, EC2M 4PL t: 0203 086 7855
© 2016 Land Technologies Ltd. Registered Company Number 08845300.