Introduction

The iShare SDW V2.0 (Spatial Data Warehouse) enables the sharing of spatial data at multiple levels across an enterprise and beyond. This may range from high level ‘super users’ of professional GIS to users across an intranet using a browser based GIS, to citizens at home using a web map portal to search for information. Astun offer a fully fledged Open Source solution that delivers considerable savings in licenses, maintenance and support. 

Users & Roles

The GIS staff will act as the administrator of the SDW; they will be assigned a role called 'sdw_admin'.

All staff members will assigned a role called 'sdw_staff'.

Staff members can create data in the schema called 'staging'. Consider it a scribble-pad area. By default users can only see their own data in this area. Once data is ready for corporate consumption SDW admin staff will move data tables from 'staging' to another schema. Schemas can be set up for projects or departments. 

Schemas are the key to the security model. All tables and views within a schema are owned by the schema_owner role. Editing rights to tables are owned by the schema_editor role and read access is controlled by the schema_viewer role. If the schema has been created with corporate access (think public) in mind then read access is also permitted by the sdw_staff role by giving them schema_viewer role.

Software Familiarisation

It is important that the admin staff members are familiar with Astun's iShare Studio and pgAdmin3 - the client interface for PostgreSQL databases. They should be able to create Workflow Connections and Workflow Tasks in Studio.