CARTO Contributors
·
Oct 7, 2011
and
CARTO Contributor
·
Oct 7, 2011
,
and
·
Oct 7, 2011

Indexed nearest neighbour search coming to CartoDB

Spatial Data Science
4
mins read

Summary

Learn how to execute bulk "nearest neighbor" queries using CartoDB for geographical analysis. Create maps depicting parcel distances from fire hydrants efficiently.

This post may describe functionality for an old version of CARTO. Find out about the latest and cloud-native version here.
Indexed nearest neighbour search coming to CartoDB

Take a sneak peek at some upcoming functionality to CartoDB: Indexed nearest neighbour search. Thanks to CartoDB investment in PostGIS 2.0  you can now find the nearest N things to anywhere on the planet at ultra fast speed!

This new functionality lets you run classic user friendly queries like "where are the 10 nearest sushi restaurants to me?"  or  "how close are the nearest 10 sightings of Puma Concolor to me?" ;)

In this demo  you can see how simple interacting with this new functionality though CartoDB is  and get a feel for the sorts user friendly queries you can run against your own data. This functionality will be rolling out to all our users over the next few weeks - so stay tuned!

Finally  we're really proud to invest in the PostGIS project. Thanks go out especially to Paul  Oleg and Teodor for helping implement this new functionality!

What divides the U.S.? The 2016 Presidential Election Visualized
Data Through Design Opening Reception: Kicking-Off NYC Open Data Week 2018 in Style
80 Data Visualization Examples Using Location Data and Maps
How our solutions team engineered WaterHack 2018
Who is who at CARTO’s Design Team
CARTO 2018: Our Year In Review
Using Location Data to Identify Communities in Williamsburg, NY
Patching Plain PostgreSQL for Parallel PostGIS Plans
Mapping the Impact of Madrid's Line 5 Shutdown
What We Learned About Open-Source Geospatial Technology at FOSS4G
4 Ways Data Enrichment Can Improve Your Raw Business Data
COPY'ing with the Python SDK
How to use CARTO.js with React
Location Intelligence conferences to attend this spring
Global Partnership: Democratizing Data & Location Intelligence for Development
Why spatial analysis is key to ending pharmacy deserts and the opioid epidemic
Using Spatial Interaction Models to Predict Behaviors
4 solutions to common problems when making location data maps
3 Internet of Things (IoT) Location Trends in 2018
Survivalists & Selectionists: How CPGs Understand Demographic Divides Through Location
CARTO's Use of Foreign Data Wrappers
5 Popular Thematic Map Types and Techniques for Spatial Data
Predicting Collisions in NYC with New Data Streams and Spatial Analysis
Design Principles for Making Maps on the Web
40 Brilliant Open Data Projects Preparing Smart Cities for 2018
Three Ways Retailers Increase Revenue with Location Intelligence
How Location Data is Helping Solve Water Insecurity
Mapping City Data Shows Link Between Redlining and Foreclosures
Celebrate Earth Day with Resource Watch
Bulk CARTO Import Using COPY
The Dreamforce 2017 Sessions We're Most Excited About
Airship: A New Front-End Library for Location Intelligence Apps
Drive Omnichannel Retail Success with Location Intelligence and New Data Streams
Working with CARTO VL
The 4 Types of Analytics Shaping Location Data Today
Discover Location Intelligence with CARTO at MWC 2018
4 Simple Steps Enigma Took to Turn Public Data into Insight
Introducing CARTO SalesQuest: Location-Based Sales Analytics
3 Ways Maps Can Transform Your Digital Marketing Campaigns
An update on MVT encoders
The Best Conferences for Location Intelligence in 2017
7 Maps Deriving New Insight From Mobile Data
Map of the Month: City Health Dashboard
How to Use Location Intelligence for Civic and Social Good
3 Spatial Data Science Trends to Watch in 2018
Designer’s table. How a lunch became the Design team’s signature
Creative Maps Made with the New CARTO.js 4.0
Real-time updated map of addresses inside LA wildfires perimeter
Build A Clicks-to-Bricks Strategy Using Spatial Data Science
Harness the Power of Vector with CARTO VL
A Better Approach to Sales Territory Management Using Spatial Clustering
How Vodafone & CARTO are providing Location Insights at MTV Music Week Bizkaia
Mark your calendars for CARTO’s Spatial Data Science Conference 2018
How to Use Spatial Analysis In Your Site Planning Process
A Map of Where People Went After the NYC Pride Parade
6 industry leaders on the state of Location Intelligence today
12 Maps That Tell the Story of 2017
Mobile Data 101: 15 Questions to Answer Using Mobile Data
Sneak Preview: CARTO Locations Madrid
Q&A: A Look at NYC's Open Data Approach with Mayor's Senior Project Manager
Get Smarter About Retail Site Monitoring
Data Viz Hacks We Learned While Mapping Drought Data
Happy PostGIS day!
Opportunity Zones in the Wake of Amazon HQ2
What Online Retailers Can Learn by Mapping Sales Data
A Really Good Guide on Location Intelligence Implementation
Our Game of Thrones Basemap is here to unite the Seven Kingdoms
The Future of Location Intelligence
Map of the Month: Pi Project - Connecting the World Through Art
Introducing CARTOframes: A Python Interface for CARTO
This map shows the communities most vulnerable to Hurricane Irma
Using Mapbox Vector Tiles in CARTO for Maps & Location Apps
Lessons Learned from Analyzing Over a Million Points of GPS Data
California Wildfire Maps: How fires and smoke are spreading
Driving down distribution costs with Location Intelligence
Meet the growing demand for senior care facilities with a modern site planning approach
CARTO in QGIS using OGR
Map of the Month: Where Are All The New Houses
From clicks to bricks: the ecommerce companies who reverse engineered Site Selection
How Insurance Uses Location Data to Prepare for Natural Disasters
3 Retailers Proving Brick and Mortar Isn't Dead
Compete on Convenience: Profitable Retail Delivery
Building A Real Estate Investment Strategy With Location Intelligence
CARTO brings geospatial data and analytics to Salesforce Einstein Analytics
Of The Most Clicked Location Intelligence Stories of 2018
What We Learned At NACIS 2017
Visualizing the Olympics: Top Maps and Data Visualizations from Pyeongchang
4 Powerful Historical Maps Every Data Analyst Should Know
A new look for Positron and Dark Matter basemaps
The Biggest Data Trends for Outdoor Advertising in 2017
Map of the Month: World Refugee Day
The Quantified City: A Closer Look at Chicago's Array of Things
What You May Have Missed at CARTO Locations Madrid
Map of the Month: Seattle Poetic Grid
Map of the Month: Landmine Removal in Nagorno-Karabakh
MVT generation: Mapnik vs PostGIS
Modernizing Catchment Areas With Human Mobility Data
How Entrepreneurs are Using Open Data to Start Businesses
A SQL approach to graph coloring applied to maps
5 Skills Every Data Scientist Will Need For Their Job in 2018

Related Posts

What space-time analysis tells us about the Paris Olympics
Diego Vicente
Diego Vicente
·
Sep 19, 2024
Diego VicenteHelen McKenzie
Diego Vicente
and
Helen McKenzie
·
Sep 19, 2024
Diego VicenteHelen McKenzie
Diego Vicente
,
Helen McKenzie
and
·
Sep 19, 2024

What space-time analysis tells us about the Paris Olympics

Explore space-time analytics through the 2024 Paris Olympics! Discover insights from human mobility data & learn how to leverage spatial analysis tools.

Spatial Data Science
Create a Spatial Priority Score to Improve Network Access
Estefania Puente
Estefania Puente
·
Feb 26, 2024
Estefania PuenteGiulia Carella
Estefania Puente
and
Giulia Carella
·
Feb 26, 2024
Estefania PuenteGiulia Carella
Estefania Puente
,
Giulia Carella
and
·
Feb 26, 2024

Create a Spatial Priority Score to Improve Network Access

Learn how to create a spatial priority score to improve network access for senior citizens. Explore data integration, regression models, and AI insights.

Spatial Data Science
Analyzing Mobility Hotspots with MovingPandas & CARTO
Argyrios Kyrgiazos
Argyrios Kyrgiazos
·
Nov 22, 2023
Argyrios KyrgiazosAnita Graser
Argyrios Kyrgiazos
and
Anita Graser
·
Nov 22, 2023
Argyrios KyrgiazosAnita GraserHelen McKenzie
Argyrios Kyrgiazos
,
Anita Graser
and
Helen McKenzie
·
Nov 22, 2023

Analyzing Mobility Hotspots with MovingPandas & CARTO

Explore mobility hotspots with MovingPandas and CARTO. Tutorial on transforming trajectory data into space-time hotspots for intelligent decision-making.

Spatial Data Science