View source for PostGIS & ArcSDE

__FORCETOC__
==Basic setup==
:user = postgres
:passwd = 615cbe
:port = 5432
:spatial db = ufl

==Install process==
# Install ArcSDE for PostgreSQL from the ESRI media.
## Process first installs PostgreSQL.
## Install ArcSDE.
# Install PostGIS
## Initializes a PostGIS database (call it '''ufl''').
##: Should be able to verify in PgAdmin that the schema ''public'' has all the PostGIS functions
# Run the ArcSDE post-installer to add SDE functions to the database
#: Should be able to verify in PgAdmin that the schema ''sde'' has all the ArcSDE functions

==Details==
# Licensing: first get a license from Luke Rogers
#: <tt>sdesetup  -o update_key -d POSTGRESQL -l "C:\Program Files\ESRI\License\sysgen\keycodes" -D ufl</tt>
# Schema:
#: in order for a user to add a layer it is necessary to add a schema for that user. e.g., 
#:: <tt>CREATE SCHEMA AUTHORIZATION postgres;</tt>
# It may be necessary to change specify a different database than the default:
#:: <tt>sdeservice -o modify -r ADMIN_DATABASE -v ufl -d POSTGRESQL</tt>
# And then start the service:
#:: <tt>sdemon -o start</tt>
# Adding data:
#: To create a data set using the PostGIS geometry, this example creates a layer from the KC hydro bigwater
#:: <tt>shp2sde -o create -l bigwater1,shape -f P:\gisdata\king_county\bigwater -a all -e a -u postgres -D ufl -p 615cbe -k PG_GEOMETRY</tt>
#: Data can also be added through ArcCatalog; use the keyword PG_GEOMETRY to make sure the geometry data are stored in PostGIS format.
#: To make the data accessible for specific users grant select privelege, e.g.,
#:: <tt>grant select on bigwater to ufl;</tt>
# Access:
#: We want a read-only access user. In that case add a user
#:: <tt>create user ufl nocreatedb nocreateuser password 'ufl';</tt>
#: That user also needs access to the schemae:
#:: <tt>grant usage on schema sde to ufl;</tt> (contains the SDE stuff, I think)
#:: <tt>grant usage on schema postgres to ufl;</tt> (schema governing the data, I think)

==Connecting==
# In ArcCatalog, select '''Database Connections > Add Spatial Database Connection'''
#: Server: '''gis.caup.washington.edu'''
#: Service: '''5151'''
#: {Database, Username, Password}: '''ufl'''