Creating a GeoJSON file with a square 100x100 in Power Query

100%

Creating a GeoJSON file with a square 100x100 in Power Query

✓ Published0🌍 Public

Last edited Apr 13, 2017

Created on Apr 13, 2017

This example generates a GeoJSON FeatureCollection containing a 100x100 grid of square polygons entirely within Power Query. It demonstrates constructing polygon coordinates for each cell using nested list functions and the `List.Accumulate` API to iterate over rows and columns. Each feature carries an `ID` property and a `Polygon` geometry with a closed ring of five coordinate pairs. The final `Json.FromValue` call serializes the entire nested list structure into valid GeoJSON, producing a downloadable file without external GIS tools. The code visibly uses Power Query’s `let` and `in` syntax, list literals, and the `Json` functions.

AI-generated description

Similar vizzes

Loading thumbnail…

Exporting GeoJSON file to MyJson API in Power Query

This example demonstrates how to export a dynamically generated GeoJSON FeatureCollection to the MyJson API for persistent hosting. The visualization builds a 10-by-100 grid of polygon features using nested `List.Accumulate` loops, with each polygon’s coordinates computed by the `sq` function. It sends the data as a JSON payload via `Web.Contents` with a `Content-Type` header, then returns the generated API endpoint URI from the response. The code relies on Power Query’s M language functions like `Json.FromValue` and `Json.Document` to serialize and parse the JSON, showcasing a programmatic pipeline for publishing tiled geospatial data.

HHugoberry

84% match

Loading thumbnail…

JSON to Table in Power Query M

This example demonstrates a Power Query M function that converts arbitrary JSON data into a structured table. It shows the step-by-step process of detecting expandable record and list columns, then iteratively expanding them until all nested objects are flattened. The code uses core M APIs such as `Table.ExpandRecordColumn`, `Table.ExpandListColumn`, `List.Accumulate`, and `List.Generate` to handle consistent and inconsistent column types. The source is a JSON object or list, which is transformed into a final normalized table through a loop that checks column types and applies the appropriate expansion method.

HHugoberry

67% match

Loading thumbnail…

JSON expansion in Power Query M

This example demonstrates how to flatten or expand nested JSON structures using Power Query’s M language, specifically through the `List.Generate` function. It shows the step-by-step traversal of a record hierarchy, where each iteration checks whether the current value is a record, tracks the nesting level, and builds an output record that appends the field names discovered at each depth. The code relies on core M functions like `Record.FieldNames`, `Record.FieldValues`, and `Record.AddField`, along with list concatenation, to construct the expanded output. The visualization highlights a programmatic approach to transforming hierarchical JSON into a flat, tabular-friendly format, without external libraries.

HHugoberry

66% match

Loading thumbnail…

Topo.JSON grid that can be used as pixel art on a map or a charting solution

This grid-based TopoJSON file defines 100×100-pixel cells that can be assembled into a larger raster-like map. The geometry uses a repeating pattern of square arcs, each with an identical side length, which lets developers render the data as pixel art on a map or as a discrete grid in a charting library. The author, Hugoberry, published this as a Gist, likely as a lightweight, code-driven way to experiment with topojson without needing external shapefiles.

HHugoberry

62% match

Loading thumbnail…

Gist fad134c9dcebee3dc1c56a9cb22de435

This example demonstrates a Power Query M function that serializes a table into a JSON object and then passes that JSON to a SQL Server stored procedure, `usp_InsertDemoJSON`, which unwraps it as a recordset and performs an INSERT operation. The code uses `Text.FromBinary` and `Json.FromValue` to convert the table, then `Value.NativeQuery` to execute the stored procedure with the JSON payload. It shows a data pipeline from a Power BI or Excel data source into a SQL database, relying on the M language’s native JSON handling and SQL Server’s JSON support.

HHugoberry

61% match

Loading thumbnail…

Generating Mandelbrot set in Power Query

This example renders the Mandelbrot set entirely within Power Query by generating a 1080-point sequence with `List.Generate`, mapping each point to the complex plane, and iterating the classic Mandelbrot formula to compute escape values. It visualizes the resulting 2D grid of iteration counts as a static bitmap, relying on Power Query’s built-in table and chart capabilities rather than external libraries. The code exposes a compact, functional approach to fractal generation, directly showing how iteration-based math translates into a visual image without specialized graphics APIs.

HHugoberry

61% match

Loading thumbnail…

Power Query embedded in an excel odc connection file

This example shows how a Power Query formula is embedded inside an Excel ODBC connection file, specifically within a Mashup.xml document. It demonstrates the structure of a single query item that generates a simple list of numbers from 1 to 20 using the `let` and `in` syntax. The code, written in Power Query’s M language, defines a source as a list range and then outputs that list. The file includes metadata such as client type (EXCEL), version, and culture settings, and the query is stored as a CDATA block within the XML, allowing for direct execution by Excel’s data mashup engine.

HHugoberry

61% match

Loading thumbnail…

via:geojson.io

This example displays a single GeoJSON polygon—a rectangular region over the Pacific Northwest—on an interactive Mapbox map. The code loads the GeoJSON file via jQuery’s `$.getJSON`, then uses `L.geoJson` to add the polygon layer and automatically fits the map’s bounds to the feature. For each layer, it extracts the feature’s `properties` object and generates an HTML table, which is then bound as a popup using `bindPopup`. The visualization relies on Mapbox.js and Leaflet’s tile layer for rendering, with popups that reveal any associated attribute data.

CCaged

60% match