Who am I

• Casual Mapper since 2007
• OSM/HOT advocate
• OSGeo Foundation
• CARTO Solutions Engineer

Our offering

• Allow users to
  • Create beautiful visualizations
  • Perform better analysis

• Expose all Postgres power
  • but not only

• Open Source and Open Data
  • http://github.com/CartoDB

CARTO and LBS previously

• Our users demand LBS
• CARTO basemaps and integration
  with many others (XYZ, WMS,...)
• Simple own geocoding: country, place names, etc
• Street level geocoding with HERE

Geocoding on the Editor

Focus on the platform

• Moving logic from the editor
  to the platform
• New HTTP API?

Data Services API

>>

Traditional LBS providers

https://mapzen.com/blog/cartodb-partnership/

https://carto.com/blog/location-data-services/

Services wrapped

Geocoding · Routing · Isolines

Geocoding

INSERT INTO {tablename} (the_geom)
SELECT
    cdb_geocode_street_point(
        '651 Lombard Street',
        'San Francisco',
        'California',
        'United States'
    )

Routing

INSERT INTO {tablename} (duration, length, the_geom)
SELECT duration, length, shape
FROM
    cdb_route_point_to_point(
        'POINT(-3.70237112 40.41706163)'::geometry,
        'POINT(-3.69909883 40.41236875)'::geometry,
        'car'
    )

Isolines

INSERT INTO {tablename} (the_geom) SELECT the_geom
FROM cdb_isodistance(
        'POINT(-3.70568 40.42028)'::geometry,
        'walk',
        ARRAY[500, 1000, 1500]::integer[]
    )

INSERT INTO {tablename} (the_geom) SELECT the_geom
FROM cdb_isochrone(
        'POINT(-3.70568 40.42028)'::geometry,
        'car',
        ARRAY[300, 600, 900]::integer[]
    )

CARTO Builder: geocoding

CARTO Builder: isochrones

Use cases for
Data Services API

• Triggers (adding coords, routes, validations)
• In line analysis with the Builder
• Parametrized routes rendering (cab ride)

DS API + Named Maps API

https://your_account.carto.com/api/v1/map/named/routingtest/750/400.png?
config={"postcode1":"'postcode_1'","postcode2":"'postcode_2'"}

Wrap up

• CARTO wants to democratize
  geospatial analysis
• This includes LBS, and being open is a must
• Mapzen services exposed as SQL functions
  fits perfectly with CARTO proposal

Thanks!!

SQL all the things

Jorge Sanz · jorge@carto.com

23rd of September 2016 · SoTM · Brussels

http://bit.ly/160923-dataservices