Advertisement
Guest User

Untitled

a guest
Nov 25th, 2015
71
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.58 KB | None | 0 0
  1. Intended to be displayed as epsg:2163 (National Atlas Equal Area)
  2. (if displayed as epsg:4326 or epsg:3857, PR will be tilted)
  3.  
  4. ```
  5. SELECT
  6. (CASE statefp
  7. WHEN '02' THEN
  8. ST_TransScale(ST_Rotate(ST_Transform(the_geom, 2163),0.51),-600000,-6400000,0.35,0.35)
  9. WHEN '15' THEN
  10. ST_TransScale(ST_Rotate(ST_Transform(the_geom, 2163),0.51),4000000,1850000,1.2,1.2)
  11. WHEN '72' THEN
  12. ST_TransScale(ST_Rotate(ST_Transform(the_geom, 2163),-0.37),-1350000,2750000,2,2)
  13. ELSE
  14. ST_Transform(the_geom, 2163)
  15. END) AS the_geom,
  16. name,
  17. geoid,
  18. statefp,
  19. countyfp
  20. FROM cb_2014_us_county_20m
  21. ```
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement