andy-esch

TechChange: Technology for Data Visualization

Basics

• Use the CARTO Builder for easy visualization of data
  • Put your data on the map
  • Build dashboards to interact with data
  • Dynamically updating maps (sync'd from realtime data)
• We have free accounts: https://carto.com/signup

andy-esch

Explore Time and Space with SQL and PostGIS

Get this doc here: http://bit.ly/sql-postgis-time-space

Get a free CARTO account

We're going to use CARTO's builder. Signup for free accounts here: https://carto.com/signup

We're going to explore the space (through PostGIS) and time (native PostgreSQL) in today's workshops using two datasets that have lat/long and timestamps.

andy-esch

Intro to CARTO

Nov 2, 2016

Us

• Andy Eschbacher, Map Scientist, [email protected], @MrEPhysics
• Jeff Ferzoco, NYC BizDev Manager, [email protected], @zingbot

Find this doc here: http://bit.ly/carto-mit-webmaps

andy-esch

CARTO

Oct 14, 2016

Andy Eschbacher, [email protected], @MrEPhysics

This link is here: http://bit.ly/carto-data-sci-oct14

What is CARTO?

andy-esch

Step 1: Importing a Dataset and Creating a Map

Import the files subwaystations and starbucks_locations into your Carto account by drag and dropping them into the Dataset Dashboard, or pasting the URL into the Import dialogue

show little boxes for links to the files

• Show how easy is to import files into CARTO! Explain the viewer the wide diversity of geodata supported in CARTO during the importing.

andy-esch

Hacks/Hackers Demo Day

Sept 6, 2016

Data Observatory

Eviction

Data sent from Erin at Anti-eviction Mapping Project:

andy-esch

Intro to the CARTO Builder

Andy Eschbacher, [email protected], @MrEPhysics

Aug 18, 2016

Goal: all users will be able to effectively navigate the CARTO Builder user interface for basic map and analysis creation which can then be shared out.

Getting Setup

andy-esch

Data From Nothing

Gathering data from nothing

1. Get boundaries, insert into appropriate table

INSERT INTO baltimore_webinar_demo(the_geom, name)
SELECT *
FROM OBS_GetBoundariesByPointAndRadius(

andy-esch

Get district boundaries

INSERT INTO us_congressional_districts(the_geom, geoid)
SELECT the_geom, geom_refs
  FROM cdb_observatory.OBS_GetBoundariesByGeometry(
         ST_MakeEnvelope(-179.5, 13.4, -42.4, 74.4, 4326),
         'us.census.tiger.congressional_district')

andy-esch

Baltimore Data through the Data Observatory

See map

Step 1

Create an empty table, rename it to baltimore_economic_data

Get Boundaries, filter by Baltimore's FIPS (24510)