Overly complicated way of "pick a postcode that is a) inside the (multi-)polygon and b) far away from edges"

100%

Overly complicated way of "pick a postcode that is a) inside the (multi-)polygon and b) far away from edges"

✓ Published0🌍 Public

Last edited Jan 8, 2021

Created on Jan 8, 2021

A static map highlights postcodes within a chosen administrative boundary by rendering the polygon's internal buffer and displaying point locations that fall inside it. The SQL query first simplifies the largest polygon part, then computes a buffer distance based on the average bounding box dimensions. It uses PostGIS functions like `st_buffer`, `st_simplify`, and `st_within` to filter UK postcode points from the `uk_geo_utils_onspd` dataset, returning a single matching postcode and its geometry. The result shows only the buffered region and the selected point, not the original boundary.

AI-generated description

Similar vizzes

Loading thumbnail…

Map

This example visualizes an isochrone map, showing a blue, semi-transparent polygon that represents the area within a 5,000-meter radius of a central point in East Grinstead, UK. The polygon is generated by creating a grid of candidate points and filtering them based on distance. The code uses the Turf.js library for distance calculations and convex hull generation, and renders the result with D3’s `d3.geoMercator` projection and `d3.geoPath`.

Fferneyhoughedward@gmail.com

57% match

Loading thumbnail…

Gist 1e418bc5c048fed5ef2604a1902eb735

This example demonstrates a spatial correction of a U.S. District Court jurisdiction boundary using PostGIS. It shows how an erroneous polygon (fid 57) is split into two parts, with one part merged into a neighboring jurisdiction (fid 58) and the other retained in place. The SQL uses `st_dump` to extract the polygon components, then `st_union` and `st_multi` to recompute the merged and retained geometries. The `UPDATE` statement with a `CASE` expression applies the corrected shapes back to the table, relying on PostGIS geometry functions for the operation.

CCaged

57% match

Loading thumbnail…

just a bookmark of random psql queries.

This example visualizes spatial relationships between neighborhoods, city blocks, and demographic data in Portland and Laurelhurst through a series of SQL queries. The code shows how geographic joins and intersections are performed using PostGIS functions like `ST_Intersects`, combining building footprints, block polygons, and census block-group data. The queries calculate race-based percentages, such as percent white and percent black, from census fields like `h7x002` and `h7x003`, while filtering for specific places and positive population counts. The gist demonstrates iterative query building for choropleth-style analysis, revealing how raw geographic and tabular data are merged to support subsequent mapping or charting in a visualization tool.

CCaged

57% match

Loading thumbnail…

Gist 186528

This example shows a geospatial search for golf courses near a specific postcode in New South Wales, Australia. The visualization maps the query’s results by displaying course locations as points, with the postcode’s coordinates as a central reference. It uses the GeoKit Rails plugin, invoked via `Postcode.find_by_postcode` and `Course.find(:all, :origin => [postcode.lat, postcode.lng], :within => 20)`, to filter courses within a 20-mile radius. The data comes from a database of course records, each with latitude, longitude, and review metrics, rendered as a simple point-based map. The code does not use d3 or Three.js; it relies on ActiveRecord and GeoKit for spatial queries.

DDylanFM

56% match

Loading thumbnail…

Naive dispersal of overlapping points in PostGIS

This example shows how to disperse overlapping point markers that share identical coordinates in a PostGIS database. It first groups points that occupy the same location and counts their multiplicity, then creates buffer polygons whose sizes scale with the number of overlapping points. Using a custom `RandomPoint` function, it randomly relocates each original point within its corresponding buffer, effectively separating coincident markers so all inspections become visible. The visualization relies on PostGIS spatial SQL queries—including `st_equals`, `st_buffer`, and `st_contains`—to generate the dispersal, with the random-point logic implemented in PL/pgSQL and executed directly in the database.

CCaged

56% match

Loading thumbnail…

Gist 652595e55960a8e04a29

This example visualizes the spatial relationships between metropolitan statistical areas and their constituent counties, townships, and other administrative geometries. The code first builds a combined geometry table using SQL, merging overlapping regions across multiple spatial layers while excluding special cases like Boston. It then renders these shapes using D3.js, likely leveraging `d3.geoPath` for projection and canvas or SVG drawing. The query explicitly handles hierarchical and overlapping geographies, prioritizing township-level detail where available and falling back to county unions for other areas. The final visualization shows how different government boundaries interlock within U.S. metropolitan regions, with the SQL preprocessing ensuring no duplicated or missing polygons.

CCaged

55% match

Loading thumbnail…

Gist d8085662349426513b73

This map visualizes a geospatial polygon from a GeoJSON file, outlining a specific land parcel or boundary area with high coordinate precision. The shape is rendered as a MultiPolygon, with vertices tracing a detailed, irregular perimeter typical of cadastral or survey data. The minimal, line-only representation emphasizes the geometry’s raw form, highlighting the boundary’s complexity and the spatial distribution of the region without additional contextual layers. The visualization focuses on the raw geographic footprint, making the coordinate data the primary visual element.

DDylanFM

55% match

Loading thumbnail…

Tilemill PostGIS layer subquery showing layer clipping via polygon intersection.

This example demonstrates how to clip building footprint data to a specific neighborhood boundary using a spatial intersection query in Tilemill. The visualization shows only the buildings that fall within the LAURELHURST neighborhood, with their geometries trimmed to the neighborhood polygon’s edge. The underlying SQL query joins the `buildings` and `neighborhoods` tables via PostGIS’s `ST_Intersects` function, selecting the boundary polygon as `bounding_area`. The map renders the resulting clipped layer, effectively masking out any building portions that extend beyond the neighborhood’s borders. This technique is useful for isolating features within a defined administrative or custom area.

CCaged

54% match