Skip to main content
100%

Gist e049813cea7c84ccf54d681eb78088b5

✓ Published0🌍 Public
Aankuagar
Last edited Mar 9, 2017
Created on Mar 9, 2017

The visualization displays a set of SQL query results from a weather and bike-share database, showing data such as the hottest day by zip code, trip counts by station, shortest trip duration, and average trip duration by end station. It uses Python with SQLite queries to extract the data, then renders the results in a web-based chart. The code references the `sqlite3` library for database access and likely employs a JavaScript charting library like D3.js to plot the aggregated values, though the specific rendering API is not fully visible in the provided snippet.

AI-generated description

Similar vizzes

Loading thumbnail…

Gist 4063106

This example visualizes the density distribution of bicycle data from the `table_2007_2009_bicy` dataset, dividing points into five quantile-based buckets. It shows how the maximum point count and density vary across these buckets, revealing spatial clustering patterns. The SQL code uses CartoDB functions such as `st_snaptogrid` and `CDB_XYZ_Resolution` to aggregate points into grid cells at a given zoom level, then calculates density per cell and assigns quartiles via `ntile(5)`. The final output summarizes each bucket’s maximum values, providing a statistical overview of the underlying geographic data.

Aandrewxhill
67% match
Loading thumbnail…

BA Data - Bicicletas - 2024

The visualization explores Buenos Aires bike-share system usage in 2024, showing the spatial distribution and volume of trips across the city’s stations. It combines an interactive map of station locations with a bar chart of trip counts, using D3.js for rendering and transitions. The code loads and queries parquet files via DuckDB, then visualizes the aggregated data with d3.forceSimulation for layout and d3.geoPath for geographic context, revealing station popularity and trip density patterns.

Aaaizemberg
66% match
Loading thumbnail…

Gist 89811213f98645c51fa8

Using CartoDB’s SQL API and PostGIS functions, this notebook explores Gilt purchase data aggregated by zip code. It shows a series of interactive maps, including a bubble map of average session time and choropleths of purchase rates, built from geocoded postal points and polygon tables. The workflow demonstrates nested SQL subqueries to join transaction aggregates with geometries, spatial filtering with `ST_Intersects` and `ST_Buffer` around New York City, and on-the-fly centroid generation via `st_centroid` for a target audience map. Geocoding and tile rendering rely on CartoDB’s default web-mercator projection.

Aandrewxhill
65% match
Loading thumbnail…

Gist 798b9a5ccb654ceebb5b29ce680c5707

This visualization presents a week of daily weather data for a single location, using a circular timeline to encode conditions such as temperature, humidity, wind, and cloud cover. Each day is a concentric ring, with hourly metrics plotted as colored arcs or bars. The code relies on D3.js for layout and rendering, specifically using `d3.forceSimulation` to position labels and `d3.scaleTime` for temporal axes. Data comes from a local JSON file containing Dark Sky API-style forecast fields, rendered in an SVG canvas.

MMbrownshoes
65% match
Loading thumbnail…

Gist 4395fae1abd542d8a27d

This example visualizes the contents of a SQLite database named `hireable.sqlite`, configured through Django’s database settings. The code defines a single default database connection using the `django.db.backends.sqlite3` engine, enabling auto-commit and atomic requests. It shows how to set up a persistent, file-based data store for a Django application. The visualization likely queries this database to render data, though the specific chart or graph type is not visible in the provided snippet. The rendering approach relies on Django’s ORM and database API to access the stored information.

Aandybak
65% match
Loading thumbnail…

Gist a29c3afbe264353eb469b9d71b706bb3

The visualization maps venue availability across a weekly schedule by querying a MongoDB database with the `db.find` API, filtering records where the current day’s `open_hour.from` and `open_hour.to` fields contain a given time. It renders this data using an interactive layout, likely with D3’s `d3.forceSimulation` to position nodes representing venues, while time and day filters drive the query. The display emphasizes which locations are open at a selected moment, updating dynamically as the user adjusts the time or day. The concrete code shows only the database query logic, so the visual output is inferred from the surrounding application structure.

Aamazingandyyy
64% match
Loading thumbnail…

Gist 8393666

This visualization plots bicycle shops in Glasgow using GeoJSON data from OpenStreetMap, with point and polygon features representing shop locations and building footprints. It shows the geographic distribution of bike retailers across the city, from central shops like Billy Bilsland to suburban outlets such as Clarkston Cycle Centre. The example uses D3.js with `d3.geoPath` to render the map shapes and likely employs a geographic projection to convert latitude-longitude coordinates into screen positions. The code processes the FeatureCollection to draw each shop as a distinct visual element, highlighting the spatial clustering of cycling-related businesses.

Aadkatrit
63% match
Loading thumbnail…

Gist 6114786

This example implements a private torque-style time-series visualization for geospatial data using PostgreSQL and PostGIS. It defines custom SQL functions that aggregate point features into web-Mercator grid cells, grouping counts by time steps and returning arrays of values and dates for rendering. The code uses `ST_SnapToGrid`, `CDB_XYZ_Resolution`, and `CDB_XYZ_Extent` to tile data at a given zoom level, with two variants: a standard response for instantaneous counts and a cumulative response that includes expiration dates for each cell. A metadata function returns the spatial bounds and time range from the source table, supporting both timestamped and numeric columns.

Aandrewxhill
63% match