CARTO Contributors
·
Apr 8, 2015
and
CARTO Contributor
·
Apr 8, 2015
,
and
·
Apr 8, 2015

Magical PostGIS in three brief movements & CartoDBeers

4
mins read

Summary

This post may describe functionality for an old version of CARTO. Find out about the latest and cloud-native version here.
Magical PostGIS in three brief movements & CartoDBeers


##_NOT_FOUND_IMAGE_## https://41.media.tumblr.com/a316e6aaf367bb492e6d8be17a45e466/tumblr_neb2hrKNVT1raf61oo1_1280.jpg ##_NOT_FOUND_IMAGE_##

Next Wednesday April 15th we're hosting a new edition of CartoDBeers - the informal gathering where we talk about maps tech and latest news. This time we are proud to welcome our very own Paul Ramsey who will be presenting 'Magical PostGIS in three brief movements.'

Everyone knows you can query a bounding box or even spatially join tables in PostGIS but what about more advanced magic? This short PostGIS session will look at using advanced features of PostGIS and PostgreSQL to accomplish surprising results.

Paul will be sharing his knowledge and experiences followed by a Q&A session. Following the event stick around for a nice chat over beers. If you're in Madrid please join us next Wednesday from 7pm! Confirm your attendance here.

CartoDBeers will be at: Calle Eloy Gonzalo 27 3 28010 Madrid

See you there & Happy Mapping!

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

No items found.