wiki.janforman.com

User Tools

Site Tools

You are here: start » arcsde
arcsde

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
Next revisionBoth sides next revision
arcsde [2022/05/03 11:46] – Jan Formanarcsde [2023/07/13 13:55] – [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\\
 +<code>
 +wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -
 +RELEASE=$(lsb_release -cs)
 +echo "deb http://apt.postgresql.org/pub/repos/apt/ ${RELEASE}"-pgdg main | sudo tee  /etc/apt/sources.list.d/pgdg.list
 +
 +sudo apt update
 +sudo apt -y install postgresql-11
 +</code>
 +
 +<code>
 +mkdir /var/lib/pgsql/12/data
 +chown postgres:postgres /var/lib/pgsql/12/data
 +su postgres
 +/usr/pgsql-12/bin/initdb -D /var/lib/pgsql/12/data --locale=cs_CZ.UTF8 -E UTF-8
 +exit
 +systemctl enable postgresql
 +systemctl start postgresql
 +</code>
 +
 +<code>
 +CREATE ROLE sde LOGIN PASSWORD '{PASSWORD}' superuser noinherit createdb;
 +
 +CREATE TABLESPACE sde OWNER sde LOCATION '/var/lib/postgresql/12/main/sde';
 +
 +CREATE DATABASE company OWNER sde ENCODING 'UTF8' TABLESPACE sde;
 +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;
 +</code>
 +
 +====== Install extensions ======
 +<code>
 +st_geometry.so -> /usr/lib/postgresql/12/lib
 +</code>
 +
 +====== Deploy DB Schema in ArcGIS Pro ======
 +Connect to server and select "Enable Geodatabase"
 +
 +
 +====== Default PostGIS format ======
 +Table sde_dbtune
 +| DEFAULTS | GEOMETRY_STORAGE | PG_GEOMETRY | 
  
arcsde.txt · Last modified: 2023/07/13 15:24 by Jan Forman

Page Tools