Gist 0c701eddfaa4b93ee172

100%

Gist 0c701eddfaa4b93ee172

✓ Published0🌍 Public

Last edited Oct 10, 2014

Created on Oct 10, 2014

Two terminal sessions show failed attempts to import OpenStreetMap data into a PostgreSQL database using Osmosis, a Java command-line tool. The visualization captures log output from sequential runs of the `osmosis` command, displaying errors from Java's `java.net.ConnectException` when the database connection is refused. The first attempt fails because the `--truncate-pgsql` task receives an unexpected `port` argument, while the second fails because PostgreSQL is not running. The display highlights the pipeline's reliance on database configuration and connection handling, rendered as plain terminal text.

AI-generated description

Similar vizzes

Loading thumbnail…

Gist 619560

This visualization loads a map using Polymaps and merges it with a local fork via a shell script. The code demonstrates a version-control workflow rather than a graphical output, as it logs git commands piping the `mbostock/master` branch into the local tree. The primary rendering relies on Polymaps’ tile-based mapping, while the surrounding repository management shows how to integrate external contributions. The example pairs a geographic data display with a practical Git merge, highlighting maintenance of a live mapping project through `git remote`, `fetch`, and `merge` operations.

Mmbostock

58% match

Loading thumbnail…

Gist 877801

This example demonstrates a debugging session for a geospatial query on a Portland crime database using MongoDB. The visualization is not a traditional chart but rather a log of command-line interactions in the MongoDB shell, revealing a critical bug in the `geoNear` command with spherical geometry. The author, Caged, queries crime records at a specific latitude/longitude coordinate and discovers that `$centerSphere` queries return no results due to a "spherical distance would require wrapping" error, while a `geoNear` command returns records at a distance of 1.803 even for the exact same location. The gist highlights the inconsistency and potential bug in MongoDB's spherical distance calculations, where identical coordinates yield non-zero distances. The visualization would likely plot these crime locations on a map, with a note or highlight on the unexpected distance value, illustrating the importance of accurate geospatial querying and the quirks of early MongoDB versions.

CCaged

57% match

Loading thumbnail…

Stack level too deep

This visualization shows a terminal session where a Ruby on Rails test suite fails with a "stack level too deep" SystemStackError, rendering the command output as a plain-text log. The example captures the raw terminal text from a `rake spec:models --trace` run, displaying the rspec test failures and the backtrace pointing to the mongomapper `keys.rb` library. The code uses the standard Ruby runtime and rspec-core, with the output presented literally as the session’s text, reflecting the error’s recursive nature through repeated stack overflow messages. The data source is the command’s stderr and stdout, shown without additional styling or abstraction.

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

56% match

Loading thumbnail…

PostgreSQL installation tutorial

This example presents a step-by-step guide for installing PostgreSQL across macOS, Linux, and Windows. It shows the terminal command `psql -U postgres` as the target for verifying a successful setup, then details OS-specific actions, such as using the Postgres.app on macOS, compiling from source via `wget` on Linux, and using the EnterpriseDB installer on Windows. The tutorial also covers checking the `$PATH` variable and verifying the server port with `lsof`.

115Dkatz

56% match

Loading thumbnail…

Shell script to import data into Postgres from https://www.nhgis.org. If you use this, you'll need to edit line 14 to include the census data you're importing.

This script sets up a Postgres database to hold U.S. Census block-group data, combining demographic race counts with spatial geometries. It first imports CSV race data into a table, then converts shapefiles to a uniform projection (EPSG:4326) using `ogr2ogr` and appends them via `shp2pgsql`. The code uses PostGIS for geometry support and creates a spatial index on the `geom` column. It relies on command-line tools like `dropdb`, `createdb`, and `psql`, processing files from the NHGIS source archive. The final output enables querying joined attribute and spatial data.

CCaged

55% match

Loading thumbnail…

Gist d5cec79ff33300cf0aeb9d8070465707

The visualization shows a terminal error message sequence for resolving a locked dpkg package manager lock in Ubuntu Linux, displayed as styled text output. It presents the error, the commands `sudo fuser -vki /var/lib/dpkg/lock`, `sudo rm -f /var/lib/dpkg/lock`, `sudo dpkg --configure -a`, and `sudo apt-get autoremove` as a troubleshooting flow. The rendering uses d3.js to bind the error and command strings to DOM elements, with d3 transitions animating the appearance of each line sequentially. The data is static text embedded directly in the code, with no external data source.

MMistyBlunch

54% match

Loading thumbnail…

Gist 182075

This visualization uses a network graph to show a chronological sequence of error messages from a Phusion Passenger application server log. It demonstrates how a single failing dependency—a missing Ruby interpreter path—triggers cascading system events. The rendering relies on a custom force-directed layout, likely built with D3.js’s `d3.forceSimulation`, where each node represents a distinct log entry and edges encode the propagation of errors across time and process IDs. The color scale maps error severity, while the spatial arrangement clusters related failures, making the cascade pattern visually explicit. Data comes directly from the pasted Gist text file, parsed for timestamps, PIDs, and stack-trace lines to drive the layout.

DDylanFM

54% match