• If you are citizen of an European Union member nation, you may not use this service unless you are at least 16 years old.

  • Stop wasting time looking for files and revisions. Connect your Gmail, DriveDropbox, and Slack accounts and in less than 2 minutes, Dokkio will automatically organize all your file attachments. Learn more and claim your free account.


CartoDB example

Page history last edited by elton 8 years, 8 months ago

Attempting to perform a rudimentary spatial join of 2 data sources, via CSV, to cloud db storage....


Spatial query against lgpn extract


Query creates a JSON return of all data from where the location intersects with a 10 degree buffer of 25.81, 36.81


https://kcl-ddh.cartodb.com/api/v1/sql?q=SELECT * from lgpn where st_intersects(the_geom,st_setsrid(ST_Buffer(ST_makepoint(25.81,36.81),1),4326))



Spatial query of 2 datasets:


Queries lgpn as above and UNIONS that result with a slightly larger buffer for the coins data....


http://kcl-ddh.cartodb.com/api/v1/sql?q=SELECT 'lgpn',name_uc from lgpn
where st_intersects(the_geom,st_setsrid(ST_Buffer(ST_makepoint(25.81,36.81),1),4326))
union all
select 'coins',field_1 from coins where st_intersects(the_geom,st_setsrid(ST_Buffer(ST_makepoint(25.81,36.81),5),4326))




A Spatial query of the lgpn subset where date between 230 and 250 AD:


http://kcl-ddh.cartodb.com/api/v1/sql?q=SELECT * FROM lgpn where notafter::integer < 250 and notbefore::integer > (230)



Also available as TMS (Tile Service) for easy incorporation into OpenLayers, Google Maps etc...


http://kcl-ddh.cartodb.com/tiles/lgpn /{zoom}/{x}/{y}.png?sql=SELECT * from table_name etc etc



Comments (0)

You don't have permission to comment on this page.