3 - Setting up

3.4 Installing docker-postgis

3.1

select
    *
from
    cb_2018_us_county_500k
where
    statefp = '55'

3.2

select
    id,
    st_centroid(geom) as geom
from
    cb_2018_us_county_500k
where
    statefp = '55'

3.3

create
or relace view wi_centroids AS
select
    id,
    st_centroid(geom) as geom
from
    cb_2018_us_county_500k
where
    statefp = '55'