Create CartoDB dataset of US states with inset Alaska and Hawaii (epsg:4326)

US48_inset_AK_HI.md

SELECT
cartodb_id,
the_geom,
abbrev, name, postal
FROM ne_50m_admin_1_states
WHERE postal NOT IN ('AK', 'HI')

UNION

SELECT
cartodb_id,
ST_Transform(ST_Scale(ST_Translate(the_geom_webmercator,-48000000,6500000),0.2,0.2),4326)
AS the_geom,
abbrev, name, postal
FROM ne_50m_admin_1_states
WHERE postal = 'AK'

UNION

SELECT
cartodb_id,
ST_Multi(ST_Transform(ST_Scale(ST_Translate(the_geom_webmercator,9000000,-120000), 1.4, 1.4),4326))
AS the_geom,
abbrev, name, postal
FROM ne_50m_admin_1_states
WHERE postal = 'HI'

I did this one a while back: https://github.com/CartoDB/cartodb-postgresql/blob/albers-proj/scripts-available/CDB_Albers.sql

And PostGIS has ST_TransScale which I keep meaning to use to reduce complexity of my code: http://postgis.net/docs/ST_TransScale.html