Mastering PostGIS Workshop: Implementing Web Mapping Services and Spatial Databases

1. Workshop plans Ulanbek turdukulov ITC

2. Schedule

3. Introduction • Schedule + practical issues • Client/server architecture of web mapping service • PostgreSQL/PostGIS • Installing • Basic SQL training Intro to PostGIS objects and queries 18/10

4. Maintaining Spatial DB • Referencing • Inheritance • Rules • Triggers • Views • Privileges Assignment: Creating a sample PostGIS DB • Implementing partitioning • Implementing user checks 19/10

5. Assignment presentations Mastering PostGIS PostGIS with MapServer OpenLayers Examples of combinations Assignment: Creating a web interface • For implementing SQL queries • For point and polygon insert into PostGIS DB 20/10

6. Assignment presentations Review of what was not clear Assignment: • Creating a complete DB structure for one of the departments of NEA • Creating a complete web interface (authorization /insert/ update /view) for one of the departments of NEA 21/10

7. Assignment presentations and discussion Review of the workshop and project planning Meeting users? 22/10