fastest query for admin content

100%

fastest query for admin content

✓ Published0🌍 Public

Last edited Feb 3, 2012

Created on Feb 3, 2012

This example maps administrative regions in Indonesia, showing the total incremental value per region as a ranked bar chart ordered from highest to lowest. It first computes each region’s centroid and bounding box from the `admin1_attributes_live` table using PostGIS functions like `ST_Centroid`, `ST_Envelope`, and `ST_AsGeoJSON`. It then joins these geometries with the `global_4x_grid` table on matching region IDs, summing `total_incr` for each province. The final output pairs each region’s name and ID with its aggregated total, ready for geographic or tabular visualization.

AI-generated description

Similar vizzes

Loading thumbnail…

IDN Topojson

This visualization renders the administrative boundaries of Indonesia using a TopoJSON file (IDN_adm.json) sourced from a gist by antogg. The map is constructed from topological arc data, where each arc is defined as a series of coordinate pairs. The example demonstrates how to load and display geographic regions encoded in TopoJSON format, projecting the topology onto a two-dimensional canvas to reveal the country's administrative divisions.

Aantogg

56% match

Loading thumbnail…

data exported by overpass turbo: all admin_level:2 features from northeast Africa to southwest Asia

This visualization displays all admin_level:2 features—national borders—from northeast Africa to southwest Asia, sourced from OpenStreetMap via the Overpass Turbo API. The map renders the GeoJSON data as a dark, minimalist geographic overview, using the D3.js library to project and draw country boundaries. Each feature’s properties, such as ISO country codes and localized names, are embedded in the dataset. The visualization emphasizes the administrative divisions in the region, showing Turkey and its neighboring countries as vector polygons.

AAlan McConchie

55% match

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

54% 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

54% match

Loading thumbnail…

Regional breakdowns by month (CartoDB + D3)

This visualization displays monthly unemployment data for multiple regions as a grid of small pie charts, with each slice colored by its unemployment value and the region name centered beneath. It uses CartoDB’s SQL API to fetch monthly values from a table named `unemploy_annual`, then renders each region as an SVG donut via D3’s `d3.svg.arc` and `d3.layout.pie`. A linear color scale maps unemployment rates from 0 to 0.25 to a purple-to-red gradient, and a legend shows the scale. Hovering a slice changes its stroke to its fill color, with a tooltip revealing the month and value.

Aandrewxhill

54% match

Loading thumbnail…

Gist c5464c81f3437808eb7f9c296e71b51a

This visualization displays the administrative boundaries of US states and Canadian provinces from a GeoJSON dataset. Using D3.js, the map renders the geographic polygons as an interactive choropleth, with each state or province colored distinctly. The visualization leverages the GeoJSON FeatureCollection to draw boundaries, highlighting the administrative regions of North America.

AAlan McConchie

54% match

Loading thumbnail…

Prasanth ICE - 8 - Map

This map visualization displays the administrative regions of India, with each state filled using a categorical color scale and labeled with its name. The geographic data is loaded as a TopoJSON file from a GitHub gist, and the map is rendered using D3 v5’s `geoPath` with a `geoMercator` projection. The code builds SVG paths from the TopoJSON features using `topojson.feature`, applies colors via `scaleOrdinal` and `schemeCategory10`, and places text labels at each state’s centroid. The visualization highlights how D3’s geo and selection APIs combine to create a choropleth-style administrative map.

PPrasanth

54% match

Loading thumbnail…

Fork of Fork of India Map: ICE-8

This visualization displays a map of Indian administrative regions, colored with a categorical palette from D3’s `schemeCategory10` and labeled with each state’s name at its centroid. The code uses `geoMercator` with custom translation and scale for projection, `geoPath` to generate SVG paths, and TopoJSON’s `feature` to extract geometries from a remote Argentine COVID-19 dataset mislabeled as Indian regions. It loads data asynchronously via `d3.json`, then renders the map and text labels into an SVG. The styling sets black state borders with a semi-transparent stroke.

Tttummala17

54% match