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.
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.
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.
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.