Skip to content

Instantly share code, notes, and snippets.

@matallo

matallo/lloguer barris.sql

Created March 14, 2014 15:16
Show Gist options
  • Save matallo/9549748 to your computer and use it in GitHub Desktop.
Save matallo/9549748 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
lloguer barris.sql
WITH barris_proc as (SELECT cartodb_id, the_geom, the_geom_webmercator, nbarri FROM bcn_barri_shp)
SELECT DISTINCT ON (nbarri) nbarri as barri, barris_proc.cartodb_id , barris_proc.the_geom, barris_proc.the_geom_webmercator, maxim, minim, mitjana, preu_mitja FROM lloguer_20barri, barris_proc WHERE barri ~* barris_proc.nbarri
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment