LUPMIS - GIS User Manual for Land Use Planning

A13.3 Training Content


For GIS Staff (GIS Technical Specialists)

A separate report ‘ICT / GIS Training at LUPMP’ is available upon request.

A) Introduction to ICT:

• Introduction

- Concept and use of computers
- Hardware vs software
- Advantages
- Main components
- Management
- Constraints

• Typing

- Keyboard skills
- Kiran typing tutor

• Windows

- Operating system: Layer between hardware and software
- Windows explorer
- File handling
- Copy
- Rename
- Search
- Folder structure
- Different versions: XP and Vista
- File extensions
- Backup
- Safety
- User account
- Administrator
- Utilities for zip, pdf
- Basics of network
- Virus threat

• Word

- Different versions: 2003 and 2007
- File handling
- Select
- Copy/paste
- Move
- Select
- Fonts
- Paragraph formats
- Setup
- Print
- Find / replace
- Special characters
- Views
- Insert tables
- Insert graphics
- Page break
- Footer
- Draw in graphics
- Table properties
- Graphic properties
- Page number
- Spelling
- Thesaurus
- Text box
- Paper size and margins
- Formats to save: doc, docx, txt, rtf

• Text editor

- WordPad, Editor, Notepad,
- Advantages of txt files

• Excel

- Different versions: 2003 and 2007
- File handling
- Copy/paste
- Structure of rows/columns
- Formats
- Calculations / formulas
- Graphs
- Print
- Special copy
- Insert graphics
- Multiple sheets
- Formats to save: xls, xlsx, txt, csv

• Graphics: Paint Shop

- File handling
- Copy/paste
- Move
- Brush
- Replace
- Colors
- Selection tools
- Definition of colors
- Graphic formats: jpg, gif, bmp, tif etc
- Zoom
- Fill
- Layers
- Vectors
- Text
- Layers
- Palettes
- Animation
- Charts
- Symbols

• Internet

- Browsing, availability of online information
- URL
- Email
- Netiquette
- Search engines: Google etc
- References

• Hardware (can be done in separate training)

- Components
- Harddisk
- Screen
- Resolution
- Installation of software
- UPS
- Installation of printer

• Introduction to database (can be done in separate training)

- Basics of MS Access
- Difference to spreadsheets
- File formats: dbf, mdb


Advanced ICT:

• Advanced graphics: Visio

- Difference to Paint Shop
- File handling
- Templates
- Diagrams

• Presentation: PowerPoint

- Layout
- Add text
- Fonts
- Color
- Insert graphics
- Insert picture
- Insert shape
- Slide show
- Print
- Animation
- Templates
- Formats to save: ppt, pptx

• File conversions

o Graphic file formats

• Advanced internet

- Concept
- Technology
- Connection
- Browsers
- URL
- Search engines
- HTML
- PHP
- CMS
- Web 2.0

• Hardware

- Concept
- All components
- Mass storage types
- Cards
- Faults
- Screen
- Resolution
- Drivers
- Installation of software
- UPS

• Hardware setup

- Setup of all project hardware components
- Cabling, interfacing
- Hardware maintenance
- Printer installation
- Drivers

• Introduction to network administration

- LAN
- WLAN
- Protocols
- Security
- Backup
- Trouble shooting
- Password
- DNS
- Cabling
- Resource sharing
- Internet access
- Hardware installation
- Formatting
- Backend-frontend
- Virus protection
- Firewall

• Virus treatment

- Virus scanner
- Software
- Quarantine
- Danger due to online exposure

• QC / Data accuracy assessment

- QC procedures
- QA, control
- Content of QC
- Reporting
- Intervals,
- Accepted data accuracy
- Data tolerance
- Internal / external control
- Automatic data QC processes


Introduction to GIS / Map Maker:

The best curricula outline of this section is the GIS Manual, produced by the Project.

• Theoretical introduction to GIS: Concepts and aspects of:

- Computerized mapping
- Data layers nad overlays
- Raster vs vector data
- Cartography
- Thematic mapping
- Modeling
- Scales

• GIS Software: Map Maker

- Installation and configuration of Map Maker
- Start with small scale, existing maps
- Menu system, project manager
- Layers
- Polygon / line / point features
- Load layers
- Zoom
- Pan
- Views
- Grid
- Hide layer
- Measure distances, areas
- Query
- Linked data table (attribute table)
- Display of vectors vs rasters
- Live layer
- Simple print
- Coordinate display
- Insert and import xy coordinates
- Style sets
- GIS file formats: dra, dbf, shp etc, tif, jpg, ecw, world files
- Advantages to (and comparison with) ArcView, ArcGIS

• Use of GIS manual

- Hardcopy
- On-line
- Exercise

• Vector data handling

- Digitize polygon / line / point
- Vertex points
- Edit polygon / line / point
- Label points: Check, edit
- Treatment of island polygons
- Database: Entry, modification
- Tools: Cutter, join, snap
- Selection manager
- Edit tools

• Raster data handling

- Resolution
- Georeferencing

• Cartography with GIS (requires earlier introduction to cartography, see below)

- Mapping
- Coordinates
- Accuracy
- Topographic vs thematic maps
- Scale
- Projection
- Datum
- Map layout
- Legend
- Orientation

• Print and presentation

- Map furniture
- Layout
- Print templates
- Transfer to graphics programs

• GPS

- Technology
- Coordinates
- Projection
- Datum
- Accuracy
- Error
- Tracking
- GPS data formats
- Transfer to PC and GIS

• Land use mapping

- Purpose of land use mapping
- Land use classification
- Scale of mapping
- Level of detail
- Concept of minimum mapping unit
- Field work
- Data to be collected in the field

• GIS for land use planning: Introduction

- Modeling
- Buffer


Introduction to DBMS

• DBMS: MS Access

- Concept
- Theory
- Tables
- Data types
- Design
- Relations
- Queries
- Reports
- Links
- Forms
- Menu development

• MS SQL Server: Introduction

Cartography

• Basics of cartography

- Presentation of spatial features on map,
- Latitude / longitude on earth
- Existence of difference coordinate systems,
- Need for projection
- Meter vs feet, awareness of units
- Conversion degrees to meter
- Discussion of map and features displayed on maps
- Different scales


GIS for land use planning with LUPMP

This is a preliminary syllabus, which will be adjusted after block 2 training has been completed, experiences collected accordingly, and land use planning models are defined.

The best curricula outline of this section is the GIS Manual, produced by the Project.

• Advanced GIS: Map Maker

- Style libraries, with colors for LUPMP land use plan maps
- Projection conversion, including War Office
- Change attribute table / reference to database, with land use data tables
- Import from and export to other formats, including to/from Survey Dept
- Check of data, QC
- GIS utilities for data conversion

• Vector data handling

- Vector utilities
- Generate cells (UTM 30 etc)
- Buffer creation with values of LUPMP (distance, function)
- Digitization and reproduction of sector layout maps

• Raster data handling

- Import
- Raster utilities
- Georeferencing of acquired satellite images
- Error assessment of ground truthing
- Combination of satellite imagery and aerial photographs
- Raster data index

• Data table handling

- Link data tables
- Merge data tables
- Database utilities
- Import census data, compile census distribution maps

• Land use planning by the Project

- Concept of GIS at TCPD
- Awareness of difference between GIS for cartography and for modeling
- Concept of decision support tool
- Land use planning models as defined by planners (structure maps, sector maps etc)
- Work with LUPMP scales (2,500, 25,000): Conversion and considerations
- Standards and terminology at LUPMP
- Creation of UPN
- Limitations of modeling and of digital planning tools
- Site analyses

• Land use mapping for land use planning by the Project

- Applied scales
- Land use classes applied
- Generalization levels, carried out by District staff

• Presentation

- Design of layout of LUPMP maps
- Marginalia
- Incorporation of layout into all maps produced
- Creation of standardized TCPD maps
- Addressing District Assemblies and stakeholders

• Participatory GIS approach

- PGIS: Concept
- Data collection and presentation under PGIS

• GPS handling in the Project

- Garmin-type handheld GPS
- PDA GPS

• Land use planning

- Communication with land use planners
- Coordination by planners

• GIS on internet

- Maps API
- Google Earth
- Web for dissemination
- Other means of land use plan dissemination

• SQL: MS SQL Server: Introduction

- SQL codes
- Functions, possibly also VB,
- Compiler
- Debugging
- Link to other databases, GIS

• Permit database

- Concept of permit database
- Link to GIS
- Installation
- Development
- Application: Entry, processing and retrieval of applications
- Link to LIS
- Link to UPN

• GIS data situation in Ghana

- Acquisition
- Office networks
- Public GIS sources
- Private GIS enterprises
- Internet sources
- Accuracy