Skip to content

Instantly share code, notes, and snippets.

@jatorre

jatorre/gist:3709197

Created September 12, 2012 19:11
Show Gist options
  • Save jatorre/3709197 to your computer and use it in GitHub Desktop.
Save jatorre/3709197 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.sql
-- Moving Hawaii and Alaska closer to mainland
--Hawaii
UPDATE map_guardian_gop SET the_geom = ST_Transform(ST_Translate(the_geom_webmercator,5500000,800000),4326) WHERE state_fips='15'
--Alaska, move and rotate
UPDATE map_guardian_gop SET the_geom = ST_Transform(ST_Scale(ST_Translate(the_geom_webmercator,-11000000,-3500000),0.5,0.5),4326) WHERE state_fips='02'
UPDATE map_guardian_gop SET the_geom = ST_Transform(ST_Rotate(the_geom_webmercator,pi()/8,-16500000,2800000),4326) WHERE state_fips='02'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment