PinnedSimon WrigleyinThe StartupFinding the most remote buildings in Britain.A geospatial big-data challenge using PostGIS, QGIS and open-source data.Nov 19, 20193Nov 19, 20193
Simon WrigleyFinding which cities share the same Latitude & LongitudeUsing QGIS Geometry GeneratorsOct 15Oct 15
Simon WrigleySpatial SQL 101: Should you ever GROUP BY geometry/geography?TLDR: Probably not, unless you are sure of what you are doing!Feb 2Feb 2
Simon WrigleyDoppelgänger GeographyFinding duplicate place names across Great Britain using BigQuery & CARTO.Jun 12, 2023Jun 12, 2023
Simon WrigleyOpen Street Map FootprintsA look into the edit footprints of some of the worlds largest corporations on Open Street Map using CARTO & BigQuery.Jun 12, 2023Jun 12, 2023
Simon WrigleyAdvanced Spatial SQL: Window FunctionsHere we will use the NOAA Global Hurricane Tracks dataset, freely available as a BigQuery public dataset. It is a point dataset containing…Dec 15, 2022Dec 15, 2022
Simon WrigleyinThe StartupThe Coastline ParadoxStatistical Self-Similarity and Fractal Dimensions.Jan 8, 2020Jan 8, 2020