. "Spatial database management"@en . . "2" . "The aim of the study course is to provide knowledge in the theoretical and practical aspects of spatial database management. The goals of course are to introduce students to the storage of spatial data in databases, the specifics of the creation of spatial databases, geospatial analysis; to familiarize with data integrity and database performance issues; to gain an insight into linear referencing systems and routing methods; to consolidate the acquired theoretical knowledge by solving practical geospatial problems with the aid of PostGIS and SpatiaLite database management systems. Course languages: English, Latvian\r\nCourse responsible lecturer\tZaiga Krišjāne\r\nResults\tKnowledge 1. knows the most popular spatial database management systems; 2. is familiar with the representation of geographical objects in databases; 3. knows the methods of analysis of geographical object spatial relations, DE9IM; 4. describes tools for ensuring the quality of geospatial data; 5. explains potential causes of performance problems of geospatial data analysis queries and proposes possible solutions; 6. is familiar with the principles of linear referencing systems; 7. describes methods of solving routing problems. Skills 8. constructs object geometries in OGC WKT format; 9. works with PostGIS and SpatiaLite databases in QGIS program; 10. imports and exports data to PostGIS using command line or graphical tools; 11. analyses object geometry spatial relationships with PostGIS queries; 12. performs routing tasks with PostGIS tools; 13. analyses causes of geospatial SQL query performance problems. Competence 14. provides justified geospatial data integration into a database structure; 15. recommends solutions to improve performance of geospatial data analysis queries; 16. justifies the chosen solution for storage and analysis of geospatial data." . . "Presential"@en . "FALSE" . . "Geospatial Data Architecture And Management"@en . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . "Bachelor in Geoinformatics"@en . . "https://www.lu.lv/en/studies/study-process/courses/programme-search/?tx_lustudycatalogue_pi1%5Baction%5D=detail&tx_lustudycatalogue_pi1%5Bcontroller%5D=Course&tx_lustudycatalogue_pi1%5Bprogram%5D=21126&cHash=6f3dcba1688f6f3c1f0a12bd4f0d0313" . "243"^^ . "no data"@en . "KNOWLEDGE\r\n1. Understand the most important concepts and regularities in the field of natural sciences (natural and human geography, remote sensing, geodesy and cartography) and geoinformatics;\r\n2. Demonstrate typical basic and specialized knowledge in geoinformatics-related work fields, know geospatial data, standards and legal issues in the field of geoinformatics.\r\n\r\nSKILLS\r\n3. Perform professional activities in geoinformatics, independently obtain, formulate and analytically describe information, problems and solutions in geoinformatics, explain them and offer reasoned opinion in the discussion with both specialists and non-specialists;\r\n4. Critically analyse geoinformatic technologies, theories and problems;\r\n5. Demonstrate a scientific approach to problem solving, take responsibility and initiative in individual or team work, make decisions and find creative solutions in changing or uncertain circumstances.\r\n\r\nCOMPETENCE\r\n6. Independently obtain, select and analyse information and use it, make decisions and solve problems in geoinformatics, explain them and discuss them with specialists and non-specialists; develops solutions for the practical application of technology;\r\n7. Understand the problems and requirements of professional ethics in the field, assess the impact of their professional activity on the environment and society and participate in the development of the relevant professional field."@en . . "4"@en . "FALSE" . . . "Bachelor"@en . "Thesis" . "2800.00" . "Euro"@en . "3100" . "None" . "highly qualified geoinformatics specialists who are competitive in both the local and international labor market."@en . "no data" . "TRUE" . "Downstream"@en . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .