Split overlapping points.

100%

Split overlapping points.

✓ Published0🌍 Public

Last edited Jan 29, 2014

Created on Jan 29, 2014

Two side-by-side maps show how to split overlapping point markers using a SQL query. The left map displays original, overlapping points from the Mark Twain dataset around New Orleans. The right map applies a generic SQL script that spatially distributes duplicate points in a circular pattern, making each individual marker visible. The maps are synchronized, and the technique uses PostGIS functions to offset each overlapping point based on its position in the group, creating a clear visual separation without altering the underlying data.

AI-generated description

Similar vizzes

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

68% match

Loading thumbnail…

CartoDB Point Clustering

This example displays point clustering on an interactive map centered on New Orleans, using CartoDB and Leaflet. It shows a sublayer of Twain dataset points filtered by city name, rendered as large blue markers. Clicking a marker queries overlapping points via CartoDB’s SQL API, revealing their count and source values in a side panel. The map uses Stamen toner tiles, while hover interactions change the cursor through CartoDB’s `featureOver` and `featureOut` events.

Aandrewxhill

65% match

Loading thumbnail…

PlpgSQL to cross dateline when drawing two points

This example demonstrates a PostGIS/PLpgSQL function that corrects lines crossing the 180-degree antimeridian when drawn on a web Mercator map. It takes two point geometries and constructs a MultiLineString that breaks the crossing segment at the map’s edge, inserting a vertical line at ±20037508.34 to create a continuous visual path. The code uses ST_Transform, ST_MakeLine, and ST_Collect to handle the geometry, and defines a custom aggregate (axh_crossdateline) to process ordered point sequences. The function expects SRID 3857 inputs and returns the adjusted line for seamless rendering.

Aandrewxhill

62% match

Loading thumbnail…

SQL for building a dynamic topo

This example builds a dynamic topographic map from traffic data by buffering and dissolving point geometries into nested contour layers. It first generates a series of buffer rings around each data point, scales the car counts across nine distance levels, and then unions those buffers into isolines representing traffic intensity. The SQL query uses PostGIS functions like `ST_Transform`, `ST_Buffer`, and `ST_Union`, while a second pass outputs the original points. The result combines colored topo bands and overlaid points, with the visualization likely rendered using a web-mapping library that consumes the `the_geom_webmercator` geometries.

Aandrewxhill

60% match

Loading thumbnail…

Link two datasets into lines between nearest points

The visualization connects two point datasets by drawing a line between each point in one set and its nearest neighbor in the other. A nested SQL query computes the closest geometry for every row using the `<->` distance operator and `ST_MakeLine` to construct the connecting lines. The map renders the resulting `the_geom_webmercator` lines in CartoDB, pairing Citibike stations with points from a second dataset. The approach highlights spatial proximity relationships through direct, nearest-neighbor linkages.

Aandrewxhill

60% match

Loading thumbnail…

Postgres/PostGIS query for buffer and spatial 'shifted' point

This example shows how PostGIS builds a composite set of geographic buffers and a projected point for use in a Tableau dashboard. It first creates a donut-shaped buffer by taking the difference between two concentric buffer polygons around a point defined by longitude and latitude. It then projects a new point three times the buffer distance away, rotates it 90 degrees, and buffers it into a small circle. The code uses `ST_MakePoint`, `ST_Buffer`, `ST_Difference`, `ST_Project`, and `st_collect` to assemble the result as a geography MultiPolygon.

Aantichaos

59% match

Loading thumbnail…

CartoDB Point Clustering

This example demonstrates point clustering on a map using CartoDB.js, Google Maps, and a custom SQL template. It visualizes tornado data, grouping nearby points into hexagonal clusters of varying sizes based on a user-adjustable "cluster size" slider. The clustering algorithm runs through a SQL query that creates three levels of hexagon grids (large, medium, small) to aggregate points, with each cluster's size and opacity reflecting the number of points it contains. Clicking a cluster reveals details about the original points it represents. The side panel includes a range input to dynamically adjust the cluster radius, which updates the visualization via CartoDB's SQL and CartoCSS templating.

Aandrewxhill

58% match

Loading thumbnail…

CartoDB Point Clustering

This example demonstrates point clustering on a map using CartoDB, showing how thousands of tornado records can be aggregated into hierarchical groups of different sizes. The visualization uses an SQL query with ST_SnapToGrid to cluster points at multiple scales, dynamically adjusting the cluster radius based on zoom level and a slider control. CartoCSS styles differentiate the cluster sizes, and clicking a point reveals the individual records it contains. The map is embedded with Google Maps and uses CartoDB.js, with an interactive side panel for cluster-size adjustments.

Aandrewxhill

58% match