Courses: Use of SQL for processing of spatial data, March 28 and 29

Use of SQL for processing and analysis of geographic information  in databases
held on 28 and 29 March at the University of Iceland

Course on the use of the SQL query in the processing of spatial data

In recent years, the LÍSU organization has held specialized courses in the use of the SQL query in work with spatial data directly in databases. These courses were well attended and we now offer them again. There can be a lot of advantage in being able to work directly with the data in databases and they are then accessible in GIS systems.
A limited number of people find that giving a good time for practical teaching. Participants will receive course material for courses to prepare themselves better.

In preparation, a graduate course will be held  next year, if there is interest. Those who are interested are asked to let them know and what it is that they want to be addressed in the course.

Exercise on the
relational database course  is common for storing geographic information, but in most cases, GIS software is used to insert the data, modify it, and perform geographic analysis. Most of the larger database vendors offer an addition to the databases so that landscaping with SQL queries can be processed. Using SQL gives the possibility to work the data directly without using a special GIS system, but the data is still available for processing in GIS systems.

The SQL query is comparable to all the larger databases, although there may be differences in specific queries in SQL for spatial data, although the methodology is the same. The course will teach on PostgreSQL database with PostGIS supplement. PostgreSQL is open and free software and students are expected to attend a laptop on the course with the installed PostgreSQL / PostGIS database.

Previous day

The first day will cover the basics of SQL for processing of spatial data in PostgreSQL.
Building a local database in PostgreSQL / PostGIS. Structure of Geometry Data Tag for Local Data and what’s in the tag (dots, lines, polygons, arches, etc.), inserting data elements, coordinates, coordinates, coordinates, spatial join, simple geographical queries (next neighbor, what’s up within ?, what is outside?), a spatial index. Add data to a shape file or to another data format. Connection of GIS systems to PostgreSQL / PostGIS.

Second day

The second day will be the data processing and processing of data. Use drop to create and manipulate data such as create a cache, calculate a center of gravity, combine, for example, polygons, use polygons to crop data, etc. PostGIS functions (functions) together with conventional SQL commands and functions are used to create new data from existing data.

Spell check in “geometry column” and comparison between “geometry” columns, whether they are identical or not. Verification of documentation. View for localized and / or traditional relations data. Use of “triggerum” where the proxy is used to update data.

For the preparation of the course, it is necessary to obtain information about the knowledge of prospective participants on database science and geographic information processing. Participants are expected to have knowledge of the main commands in SQL and be familiar with the spatial data processing.

Time and place

The course will be held March 28 and 29 at the University of Iceland. 9:00 am to 5:00 pm both days.

 Supervisor is Tryggvi Hjörvar, a database specialist at the Icelandic Meteorological Office.

The minimum number of participants is 9 persons and a maximum of 13 people. Those who are interested in attending the course are kindly requested to report their participation as soon as possible.

Entry fee:

LÍSU members : ISK 82,000 for both days


Please forward your ad to others who might be interested

A PostgreSQL database is taught with PostGIS plugin. PostgreSQL is open and free software.