Skip to content

Instantly share code, notes, and snippets.

@afcotroneo

afcotroneo/omni-geojoin-basic

Created May 26, 2021 21:32
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save afcotroneo/5e940d79c555930c2b70ed6bd50976a9 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save afcotroneo/5e940d79c555930c2b70ed6bd50976a9 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
omni-geojoin-basic
SELECT
tweets.location,
tweets.follower_count as size,
zipcodes.number as color
FROM
tweets
LEFT JOIN zipcodes on ST_Contains(zipcodes.polygon, tweets.location);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment