Skip to content
The Map Den
The Map Den

Mapping the latest interests in the GIS, Mapping, geography and anything in between.

Primary Navigation Menu

Menu
  • The Map Den
  • Tags
    • maps
    • gis
    • tips
  • Map of the Day
  • Music Map
  • About
  • Contact

sql

Aggregating points: JSON on SQL and loops on infowindows

2017-02-20
By: TheMole19
On: February 20, 2017
In: gis, maps, tips, Uncategorized
Tagged: carto, gis, json, maps, sql, web development
With: 0 Comments

Fantastic bit of code and tutorial about aggregating point data for JSON objects using SQL. geomaticblog NOTE: I’ll use CARTO but you can apply all this to any webmapping technology backed by a modern database. Get all the data So we start with the typical use case where we have a one to many relationship like this: Easy peasy, we have a map with many stacked points. From here you can jump to this excellent post by James Milner about dense point maps. My example is not about having thousands of scattered points that at certain zoom levels overlap. Mine is a small set ofRead More →

Share this:

  • Click to share on Twitter (Opens in new window)
  • Click to share on Facebook (Opens in new window)
  • Click to share on Google+ (Opens in new window)

Site Menu

  • The Map Den
  • Tags
    • maps
    • gis
    • tips
  • Map of the Day
  • Music Map
  • About
  • Contact

Social

  • View @TheAgermeister’s profile on Twitter
  • View david-ager-16a9b685’s profile on LinkedIn

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Follow me on Twitter

My Tweets

Translate

Recent Posts

  • Chocolate Maps? Sweet! – Geography of Chocolate
  • Holding Fire – Mapping USA’s relationship with Guns
  • Providing Depth – Mapping and Marine Wildlife Threats
  • Music, Geography and Independence – Independent Venue Week 2018
  • Where is Santa Claus From?

Tags

africa anthropology arcgis canada cars carto cartography china climate colours culture data databases data visualisation democracy economics england environment europe excel football geography geospatial gis greenland history map mapbox mapping maps Motd music netherlands old maps OriginalContent politics Population satellite sport travel UK usa Wales web development world

RSS

  • RSS - Posts
  • RSS - Comments

RSS Geoawesomeness

  • Meet AVUXI – the startup that is creating “the map of human interest in locations” and changing the online travel and accommodation sector #TheNextGeo
  • Google will add our metal maps as a layer to Google Maps
  • If you thought physical maps are dead, think again! Meet the startup that is designing all-weather, wearable maps #TheNextGeo
  • Introducing “The Next Geo” – Geoawesomeness’s Latest Series
  • 7 stunning satellite pictures that show Earth like never before

RSS ArcGIS Blog

  • What’s New in Basemaps (March 2018)

RSS GIS Lounge

  • Using Machine Learning to Speed Up Electrical Grid Mapping
  • GIS and Cartography Quotes
  • Where to Find GIS Data for Historical Country Boundaries
  • Viz Palette Helps You Pick Colors for Data Visualizations
  • Over 2000 Sentinel-1 Satellite Images Were Used to Create a Map of Land Deformation in the United Kingdom

Social

  • View @TheAgermeister’s profile on Twitter
  • View david-ager-16a9b685’s profile on LinkedIn
Privacy & Cookies: This site uses cookies.
To find out more, as well as how to remove or block these, see here: Our Cookie Policy

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Designed using Dispatch WordPress Theme. Powered by WordPress.