Data To Concatenate

100%

Data To Concatenate

✓ Published0🌍 Public

Last edited Apr 7, 2020

Created on Apr 7, 2020

This visualization demonstrates the process of reconciling two versions of a spatial dataset, showing how duplicate headwords with shared geographic coordinates are merged into a single canonical record. It displays a side-by-side comparison of the original data file, which contains separate entries for “Acre” and “Akko,” against a new file that concatenates them into one row with a joint headword. The visualization uses the processing library to read and parse both CSV files, comparing rows based on the Syriaca URI field to identify matches, then rendering the results in a tabular layout. It relies on core Java file I/O and string manipulation methods to handle the data transformation, with no external charting libraries involved.

AI-generated description

Similar vizzes

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

56% match

Loading thumbnail…

Gist c2315899ad3a0cad09304146add83d04

This visualization compares village codes from a JSON dataset against a Shapefile, showing which villages appear in one but not the other. It displays the mismatched codes in a text list, summarizing the total unique counts for each source (7,851 in JSON, 8,017 in Shapefile). The example uses a straightforward text rendering approach rather than graphical mapping, relying on file parsing and set operations to identify discrepancies. The data comes from GeoWill’s gist, with the output formatted as plain text lists for easy inspection.

GGeoWill

55% match

Loading thumbnail…

Convert Messy Spreadsheet of Berlin Street Names to GeoJSON

This visualization converts a messy CSV file of Berlin street names into a GeoJSON FeatureCollection. The XQuery script uses `csv:parse` and `map:merge` to clean the data, expanding abbreviations like "dr" to "doctor" and normalizing gender fields. It then calls the Mapbox Geocoding API via `http:send-request` to retrieve geometry for each street address, bounded to Berlin’s coordinates. The resulting features are assembled with `array` and output as JSON, ready for mapping.

CCliffordAnderson

55% match

Loading thumbnail…

csv concatenation

This example demonstrates the simple concatenation of multiple CSV files into a single output file, combining rows from all input files without any transformation or filtering. The script uses the `csv.reader` and `csv.writer` APIs from Python’s standard library to parse and write each row, while the `glob` module collects every `.csv` filename in a specified directory, and `os.chdir` changes the working directory to that folder. All rows are appended into a flat list, then written to a designated output path. The visualization shows the raw data-merging process, not a graphical chart, and relies solely on file I/O and CSV handling.

IIanHopkinson

54% match

Loading thumbnail…

County Business Practices

This visualization compares data from the U.S. Census Bureau’s County Business Patterns for 2020 against a separate dataset of scores. Using a D3.js-based web application, it loads two CSV files from GitHub Gists and displays their parsed contents as JSON in two separate `<pre>` elements. The code leverages d3’s `csvParse` and `select` APIs within a state-driven render loop, fetching and updating data asynchronously to showcase raw data from the Combined Statistical Areas. It offers a minimal, text-based view of the structured datasets.

Hhmkyriacou

54% match

Loading thumbnail…

Useful functions

This example demonstrates a reusable JavaScript function for joining two datasets, enabling efficient data combination in visualization workflows. It builds an index from a lookup table and then maps rows from a main table through that index, selecting only the desired columns. The code shows a raw implementation of a lookup-table join, similar to SQL-style joins, with a commented usage example that merges brand and article data. The example relies on plain JavaScript arrays and objects, with no external libraries, making it a lightweight utility for preprocessing data before visualization.

RRodolfo Viana

53% match

Loading thumbnail…

files

This example displays a dense scatter of geographic coordinates, plotting the sets of longitude and latitude points from a CSV file as small dots. An SVG canvas renders the points, with the visualization’s intended purpose being to reveal the underlying shape or pattern of the data—likely a coast or border—as the points are ordered sequentially. The code uses d3.select to append the SVG and relies on the D3 v4 library for basic rendering, though it does not yet map the data to visual elements. The default text label remains, awaiting replacement by the user’s implementation.

HHakkahi

53% match

Loading thumbnail…

Data wrangling for ArcGIS to Cypher

This example shows how raw tabular GIS data is wrangled into a node-and-edge format suitable for importing into a graph database like Neo4j via Cypher. It extracts distinct pairs of connected points from an ArcGIS feature table by computing start and stop coordinates from X/Y fields and their offsets, then filters out self-loops where start equals stop. The code uses the XQuery language with the `fn:distinct-values`, `fn:data`, and `string-join` functions to build a comma-separated list of connected node IDs and edge lengths. It explicitly demonstrates the data-cleaning step—removing duplicate or invalid connections—before the result is ready for Cypher’s `LOAD CSV` or `MERGE` commands.

CCliffordAnderson

53% match