Skip to main content
100%

Gist 066cc1deef3173351f9d6b358b93d78b

✓ Published0🌍 Public
Aandrewbt
Last edited Sep 19, 2017
Created on Sep 19, 2017

This visualization generates synthetic timestamp data from year strings using a SQL function that randomly selects a point between January 1 and December 31 of the given year. The example demonstrates how to create randomized temporal values for testing or simulation purposes, with the function `random_time_from_year_string` accepting a year as text and returning a timestamp. The code leverages PostgreSQL's SQL language features, including type casting and arithmetic on timestamp intervals, while using the `random()` function to produce the uniform distribution across the year. The rendering approach is not specified, as the example focuses solely on the data generation logic within the SQL query.

AI-generated description

Similar vizzes

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
67% match
Loading thumbnail…

Gist 74cb28602595c2a18d8c9de77ebabe78

This visualization shows a time-series dataset from `timedata.json`, where each entry pairs a Unix timestamp in milliseconds with a numeric value, here displaying two points: 1483228800000 mapping to 2 and 1483228820000 mapping to 4. The example renders these as a simple line or scatter plot, likely using D3.js with `d3.scaleTime` for the x-axis and `d3.scaleLinear` for the y-axis. The code constructs an SVG container, binds the data, and draws circles or a path to represent the values, while axes are generated via `d3.axisBottom` and `d3.axisLeft`. The visualization focuses on demonstrating a minimal, direct mapping of raw timestamped data to visual marks without additional transformations.

VVioletVivirand
60% match
Loading thumbnail…

This is the result of JODA not being serializable in scala, resorting to utter bullshit, assumes year is 2016.

This visualization charts time-series data using a custom timestamp conversion workaround. The chart maps dates and times to Unix epoch integers through a Scala function that hardcodes the year as 2016, manually calculating day-of-year offsets and time-of-day seconds. The function parses month abbreviations via string indexing, converts day strings to integers, and splits time strings into hours, minutes, and seconds. This approach bypasses JODA datetime serialization limitations, producing numeric x-axis values for plotting. The rendered graphic likely uses a standard plotting library, though the code excerpt only shows the formatter.

BBBischof
59% match
Loading thumbnail…

Gist 4cd8f6cf6b2c29372f82424c1363d08a

This visualization demonstrates a minimal time-series dataset containing two data points, each with a Unix timestamp and a numeric value. It uses D3.js to render the data as a simple line or area chart on an SVG canvas, likely plotting time on the x-axis and value on the y-axis. The code initializes a D3 scale and axis to map the input coordinates, then draws a path connecting the two points. The sparse dataset highlights how the visualization handles gaps or immediate transitions between values, with the second point dropping to zero shortly after the first.

VVioletVivirand
58% match
Loading thumbnail…

Gist 1353003

This example demonstrates a spatial SQL query that computes raster statistics for a custom polygon region. It uses PostGIS functions to sum pixel values, count pixels, and calculate the average value across a 10x10 grid of sub-pixels within each raster tile. The query filters raster tiles intersecting the target polygon and then intersects translated grid cells against the same polygon. The code relies on `ST_Value`, `ST_Intersects`, `ST_Translate`, `ST_MakeEnvelope`, and `generate_series` to perform the analysis, extracting data from the `carbon_query_test_s` table.

Aandrewxhill
58% match
Loading thumbnail…

Gist 6b851197754b1a378f905e75b82697b0

This example demonstrates how to engineer and transform date, time, categorical, and numerical features for predictive modeling. The R script defines date-based variables such as day of week, week of year, and quarter, alongside time bins for 24-hour periods, and incorporates open calendar data like national holidays and seasons. It applies categorical encodings via hashing with FeatureHashing's `hashed.model.matrix` using a 14-bit hash, one-hot, target, orthogonal polynomial, and deviation methods. Numerical transformations include Box-Cox and binning, while general manipulations support column-wise or combinatorial diff, sum, prod, and custom formula operations across data frames.

Aaakansh9
57% match
Loading thumbnail…

Gist 42c5413995001df2d448d010b837dc33

This example visualizes daily user activity by counting how many user records reference each date. It shows a timeline of update frequencies derived from a hardcoded JavaScript object mapping user IDs to date-keyed booleans. The code builds a string of user IDs and their associated dates, then uses `String.split(date)` on that concatenated string to count occurrences of each date in the `updates` object. It relies on the Moment.js library to generate the last ten dates via `moment().subtract()` and formats them as `DD-MM-YYYY`. The rendering itself is absent—the example focuses solely on data aggregation logic, with no charting or DOM output.

AA6Brgeuka
56% match
Loading thumbnail…

Gist ddc6d50c313ebe6edb45519f43358c6c

The visualization displays monthly and seasonal global temperature anomalies from 1880 onward, using data from the `temperatures.csv` file. It builds a compact heatmap-style or sparkline-based grid, with each row representing a year and each cell showing the temperature deviation. The implementation uses D3.js to parse the CSV data and render the graphic, leveraging SVG or canvas primitives to represent the numeric values across the various time columns. The code processes the tabular data directly, mapping the values to visual elements through D3’s data-binding and layout functions.

Mmbostock
56% match