Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Intended to be displayed as epsg:2163 (National Atlas Equal Area)
- (if displayed as epsg:4326 or epsg:3857, PR will be tilted)
- ```
- SELECT
- (CASE statefp
- WHEN '02' THEN
- ST_TransScale(ST_Rotate(ST_Transform(the_geom, 2163),0.51),-600000,-6400000,0.35,0.35)
- WHEN '15' THEN
- ST_TransScale(ST_Rotate(ST_Transform(the_geom, 2163),0.51),4000000,1850000,1.2,1.2)
- WHEN '72' THEN
- ST_TransScale(ST_Rotate(ST_Transform(the_geom, 2163),-0.37),-1350000,2750000,2,2)
- ELSE
- ST_Transform(the_geom, 2163)
- END) AS the_geom,
- name,
- geoid,
- statefp,
- countyfp
- FROM cb_2014_us_county_20m
- ```
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement