LandTech Engineering Blog

An Intro To Geospatial Data With PostGIS

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

SQL Window Functions

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

Postgres SQL Distinct On

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

Day In The Life Of The Data Team

We as a data team wanted to let you know who we are and give you an insight into what we do. Look out for some more treats from us! Hi I’m…

Component Libraries

In the last post I discussed the three main CSS techniques: Classical CSS, Utility-First CSS and CSS-in-JS. Now I want to take a look at…

Styling Techniques

Now that we’re making the transition from Vue.js to React it’s time to review how we manage styling. Although at first this seems like a…

Moving to React

Pause & Reflect As we continue to expand we’ve taken time stop and review in depth at what we want to achieve over the next couple of years…

One year at LandTech. What Happened?

Summary? I’ll hook you up. I’ve been at LandTech for a year now and working with the engineering team has been sensational so far (despite…

We're changing. Work...anywhere!

The COVID-19 pandemic has changed the world and life as we once knew it and is continuing to challenge the way many of us live and work…

Who needs distributed systems anyway?

TLDR; monoliths can (a) be flexible, and (b) possibly handle big-ish data. As a software engineer you are in the business of solving…

Our Engineering Principles

These are our Engineering Principles, defined in June 2020, to compliment our values (which are currently Creativity, Excellence, Confidence…

Dependabot… a critical DevOps tool

Acquired by GitHub in 2019, Dependabot is a free bot application that checks for dependency updates, creates pull requests and can even…

Getting Started with Kubernetes

As a follow up to my Docker post I’ll go over my notes from some recent Kubernetes training. I’ll cover the key concepts and a few useful…

Understanding Docker

Why Docker? Let’s say you’ve just finished prototyping a new web app and you want to pass it onto the team to have a play around with. You…

Embracing the Power of Data Loaders

We use Facebook’s implementation of Data Loaders in our GraphQL API, but the concept is very generic and could be of wider interest…

Engineering Enlightenment

Close your eyes… imagine a world where code is a joy to write, bugs are caught in development and everything runs like a well-oiled bicycle…

What Have I Learnt???

It has been 9 months since I started my apprenticeship in software engineering and I’m learning far more than just how to code. I have the…

Building an SSH Jumpbox with Docker

As part of our never-ending pursuit of staying secure, we have recently built an SSH jumpbox as a central, secure way to access our…

Building our First Mobile App with React Native

React native is a cross platform app development framework, primarily used for building apps for iOS and Android, almost entirely using…

How Sinful is UK Property?

Here, at LandInsight, we have a ton of data on UK property. In particular we know who owns what and can perform searches on this data. This…

How we Scaled our Mapping Tool with Mapbox & Google

At the heart of the LandInsight product is a map showing a variety of datasets. Users can switch between map layers and filter features…