This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
arcsde [2022/05/03 13:55] – Jan Forman | arcsde [2023/07/13 14:16] – [ArcSDE + PostGIS on UBUNTU 20.04] Jan Forman | ||
---|---|---|---|
Line 1: | Line 1: | ||
+ | ====== ArcSDE + PostGIS on UBUNTU 20.04 ====== | ||
+ | |||
+ | * note <= ArcGIS Pro 2.5 and Arcmap 10.8 cant connect to Postgres 12\\ | ||
+ | < | ||
+ | wget --quiet -O - https:// | ||
+ | RELEASE=$(lsb_release -cs) | ||
+ | echo "deb http:// | ||
+ | |||
+ | sudo apt update | ||
+ | sudo apt -y install postgresql-11 | ||
+ | </ | ||
+ | |||
+ | < | ||
+ | mkdir / | ||
+ | chown postgres: | ||
+ | su postgres | ||
+ | / | ||
+ | exit | ||
+ | systemctl enable postgresql | ||
+ | systemctl start postgresql | ||
+ | </ | ||
+ | |||
+ | < | ||
+ | CREATE ROLE sde LOGIN PASSWORD ' | ||
+ | |||
+ | CREATE TABLESPACE sde OWNER sde LOCATION '/ | ||
+ | |||
+ | CREATE DATABASE company OWNER sde ENCODING ' | ||
+ | GRANT ALL ON DATABASE company TO sde; | ||
+ | |||
+ | \c company | ||
+ | CREATE EXTENSION IF NOT EXISTS postgis WITH SCHEMA public; | ||
+ | CREATE EXTENSION IF NOT EXISTS postgis_topology; | ||
+ | |||
+ | CREATE SCHEMA sde AUTHORIZATION sde; | ||
+ | GRANT ALL ON SCHEMA sde TO sde; | ||
+ | |||
+ | GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE public.geometry_columns TO sde; | ||
+ | GRANT SELECT ON TABLE public.spatial_ref_sys TO sde; | ||
+ | </ | ||
+ | |||
+ | ====== Install extensions ====== | ||
+ | < | ||
+ | st_geometry.so -> / | ||
+ | </ | ||
+ | |||
+ | ====== Deploy DB Schema in ArcGIS Pro ====== | ||
+ | Connect to server and select " | ||
+ | |||
+ | |||
+ | ====== Default PostGIS format ====== | ||
+ | Table sde_dbtune | ||
+ | | DEFAULTS | GEOMETRY_STORAGE | PG_GEOMETRY | | ||