Geo-ICT Training Center, The Netherlands
200 courses, 20 online supports,
60 moocs, 30 trainees
- Planning and Registration
This Geo-ICT course lasts 4 days and costs € 1695. This course is suitable for people who have a college or university education and who work or want to work in Geo-ICT. This course consists of 4 days and the student receives a broad introduction to GIS and Geo-ICT and thus makes a good start in the geo sector.
Day 1: FME
FME is an integrated collection of Spatial ETL (Extract, Transform, Load) tools for conversion and processing of geographic and non-geographic data. With support for all popular GIS formats and the ability to perform all imaginable GIS operations, it is an indispensable tool for the GIS professional.
After the first part, the use of transformers for processing data is discussed. The FME Workbench contains a collection of transformers that each perform a certain action on the data flowing through the transformer. By combining these transformers in a flow chart-like environment, it is possible to quickly set up complex processes. In this way, a good balance is found between theory and application. Where possible, we would like to tap into examples of the work environment for students. This in the context of teaching according to the principle of Action Learning.
More and more input from students is expected. In addition to practical exercises, this also means learning from each other.
Day 2: Geographic data / Spatial Databases
The storage, syntax and semantics of the geometric data types that Oracle Spatial supports are discussed. Participants get to know the Oracle native data types for spatial data and geometric primitives. The mechanism of spatial indexation is also discussed. During this training, the theory of spatial database is discussed, taking the widely used Oracle spatial database as an example. In this way, a direct link is made from theory to practice.
Day 3: PostGIS / SQL
The following topics are covered in the course: Introduction to working with spatial databases, Connection with ESRI software, Working with Oracle Administrator, Loading shapefiles and CSV files, Making spatial queries, Filtering, presenting and combining data, Import / export, Working with ODBC (Open DataBase Connectivity), Creating and loading a spatial database. PostGIS / SQL is the Open Source counterpart of, among others, Oracle Spatial databases. Oracle Spatial is widely used and a number of organizations are investigating the possibilities of the Open Source solution. During the course, participants gain insight into the differences between PostGIS / SQL and Oracle Spatial and the student learns the ins and outs of Spatial SQL based on Oracle Spatial. Various exercises are done in ORACLE with SQL commands, geometry, spatial relations and spatial joins, spatial indexing, linear referencing, 3D WebGIS, Nearest-Neighbor Searching, Tracking Edit History using Triggers, Tuning SQL for Spatial, SQL Security, ORACLE Schemas , SQL Backup Software Upgrades.
Day 4: QGIS Basic
With QGIS you will superimpose layers in vector format and raster format. You can set the layer at which scale the objects are visible on the map. Attention is also paid to text labels, exchange with other systems, thematic presentations and much more. After the basic course QGIS you are a professional user of QGIS. The following topics will be discussed in this first day: general use of QGIS, adding layers, presentation and plot settings, text and labels in QGIS, exchange with Office, thematic presentations, visualization of geo data, use of National Geo Register and other Catalog Services, Unlocking WMS services and using public WMS and Tiling services, searching and retrieving alphanumeric data, PDOK, Openstreet Maps.
Learning objectives of this course
- Get to know Geo-ICT
- Learning to deal with FME
- Learning to use a Spatial Database
- Learn to work with SQL
Learn to work with QGIS
You may also be interested in the following courses:
- Course Landsurveying
- Course Basic registration of large-scale topography
- Course basic registration Addresses and Buildings