4.5 Projections

4.7

insert into
    spatial_ref_sys (srid, auth_name, auth_srid, proj4text, srtext)
values
    (
        104726,
        'ESRI',
        104726,
        '+proj=longlat +a=6378418.941 +rf=298.257222100883 +no_defs +type=crs',
        'GEOGCS["GCS_NAD_1983_HARN_Adj_MN_Hennepin",DATUM["D_NAD_1983_HARN_Adj_MN_Hennepin",SPHEROID["S_GRS_1980_Adj_MN_Hennepin",6378418.941,298.257222100883,AUTHORITY["ESRI","107726"]],AUTHORITY["ESRI","106726"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.0174532925199433,AUTHORITY["EPSG","9122"]],AUTHORITY["ESRI","104726"]]'
    );

4.8

create view mn_104726 as
select
  id,
  st_transform(geom, 104726)
from
  cb_2018_us_county_500k
where
  statefp = '27'