Spatial Databases And Digital Cartography

LEARNING OUTCOMES

The course aims at:

1. Knowledge
   • Understanding, acquiring knowledge and learning all the stages of creating digital cartographic / spatial data, digital maps and Spatial Databases.
2. Skills
   • Familiarity with their applications in specific examples.
   • To acquire skills and abilities for the design, creation, creation of metadata and control of Spatial Databases, Web Mapping and in satellite mapping
3. Abilities
   • To develop skills for the application of techniques for the analysis needs and the creation of studies for the development of Spatial Databases and their integration into existing or in development spatial Information Systems in any environment or requirement and by selecting the best combinations of tools and techniques.

 

General Competences

Taking into account the general skills that the graduate must have acquired, the course aims at:

• In understanding the design, development, implementation and control of BXD. In the search, analysis and synthesis of digital spatial data and information, using the necessary technologies for the creation of digital maps and digital spatial / cartographic information on the Internet.
• To adapt to new situations that require the creation of maps in a very short time (e.g., in case of natural disasters), or the use of new types of cartographic data (e.g., very high-resolution satellite images) or the use of new techniques and equipment (e.g., unmanned aerial vehicles and vehicles).
• In making decisions regarding the correct choice of data, techniques, projections, basic graphics and aesthetic features that compose the quality of a digital map and the correct structure of a SDB.
• In autonomous work through the theoretical development and practical elaboration of issues related to cartographic concepts and practices with the aim of developing skills necessary for BXD development studies, digital maps and spatial data infrastructures.
• The ability to work in an international environment supported by learning both “standardized knowledge” of digital cartography and SDB taught in most universities around the world and by using and learning both English and French “cartography” / SDB terminology.
• In the work in an interdisciplinary environment supported by the nature of the course of SDB and digital cartography that is directly related to road construction, plumbing, environmental protection, three-dimensional representation of objects, etc.
• In the production of new research ideas that is supported and developed through a) individual and group work but also b) with the information about the research programs of the Department in relation to SDB and digital cartography and the possibilities of students’ participation in them.
• In the design and management of development projects, information and control of BXD and digital maps.
• Demonstrating social, professional and ethical responsibility in data and software copyright issues.
• In the exercise of criticism and self-criticism through the presentation day of the semester papers (individual and group).
• In the promotion of free, creative and inductive thinking.

 

SYLLABUS

Theoretical part- Lectures

Introduction. Basic concepts. Principles. Terminology and “terms”. Interconnected and overlapping scientific fields, sciences and techniques. Cartographic, Geographical, Geographical, Spatial and Geospatial Data. Digital Cartography and Visualization / Visualization of Spatio-temporal Data. Bibliographic resources – Internet resources – “Open” Courses – Free data – “Open source” software. Organizations, scientific associations and organizations related to digital cartography and its applications. Spatial Data, Geographic Information Systems, and Spatial Databases. Types & Structures of Digital Spatial & Cartographic Data – Characteristics of Spatial Data. Connection of Spatial Data with other Data – introductory concepts. SDB and virtual and augmented reality. Software & Equipment. Sources & Methods of Production of 2D and 3D Spatial Data – Volunteered Geographic Information – Crowdsourcing. Spatial Data Producers – National and International Infrastructure – INSPIRE. Georeferencing Data. Alphanumeric & Spatial Data Management Databases & Systems. SD / SDB design and implementation levels. Similarities and differences of Alphanumeric Bases and Spatial Data. Conceptual Design SDB & CASE- Tools. Spatial-temporal modeling. Topology. Logical Physics Design SDB and Models. Interconnection of SDB & SAB and SDB with other Data. Metadata and data dictionaries. Quality of Digital Spatial Data and SDB. Error detection. Quality parameters. Quality check. Compatibility of Spatial Data (data) – Software (Software) – Devices / equipment (hardware) – Standards for the exchange of Spatial Data. Compression of Digital Spatial Data. Digital Cartography and Sustainable Development. Digital Atlases and Multimedia Cartography. New technologies and devices and their Applications in Digital Cartography and SDB (smartphones, tablets, handheld GPS / GIS, UAV, etc. Dynamic Cartography (Animated Cartography) – Underground Digital Cartography – Interior Cartography. Network cartography. Cartographic Generalization in Digital Spatial Data. Analysis, Design, Implementation, Control and Information of SDB. Production of Analog
Maps with digital data. Digital Maps and Web Mapping Applications – Web Mapping Automatic Navigation Systems, Mobile Cartography, electronic navigators. Location Based Marketing (LBM), SDB and digital cartography. Location Based Services (LBS). Digital Ground Models – Buildings – Surface – Cities – City GMLstandard. Cartography & Applications Using Satellite Images – Satellite Cartography. Digital Geotags and SDB. Digital cartography and crisis and disaster management. Virtual and Augmented Reality: its use in digital cartography.

 

Laboratory Exercises

1. Project management SDB – Digital Cartography.
2. Conceptual models.
3. Election of cartographic / spatial entities.
4. Logical SDB models.
5. Import and visualize raster (vector) and vector (vector) data in GIS software.
6. Geo-reference map of G.Y.S. and satellite image.
7. Geobase creation, digitization and creation of simple and complex spatial objects.
8. Correlation of spatial and alphanumeric databases.
9. SDB topology: creation and control.
10. Digital terrain, building and surface models.
11. WEB MAPPING, creating a map on the internet
12. Dynamic Cartography Exercise.
13. Virtual and Augmented Reality: its use in digital cartography.
14. Special issues.

 

STUDENT PERFORMANCE EVALUATION

Language of assessment:
Greek or English or French (for ERASMUS students)
Evaluation methods:
• Written examination at the end of the semester: 60%
• Laboratory Exercises / Field Exercises: 20%
Personal study and presentation: 20%

 

ATTACHED BIBLIOGRAPHY

Suggested bibliography:

1. Shashi Shekhar and Sanjay Chawla, 2003, Spatial Databases: A Tour, Prentice Hall.
2. Rigaux & Scholl & Voisard, 2001, Spatial Dαtabases, Morgan Kaufmann.
3. Albert K. W. Yeung, G. Brent Hall, 2007, Spatial Database Systems: Design, Implementation and Project Management, Springer.
4. Sandra Lach Arlinghaus , Joseph J. Kerski ,2014, Spatial mathematics-Theory and practice through mapping , Taylor & Francis Group , Boca Raton, FL .
5. Raghu Ramakrishnan, Johannes Gehrke , 2003, Database management systems ,third edition , McGraw-Hill Higher Education , 1221 Avenue of the Americas, NY , US.
6. Philippe Rigaux , Michel Scholl , Agnes Voisard , 2002 , Spatial databases with applications to GIS , Elsevier , 340 Pine st. , San Francisco , CA , US .
7. Robert Laurini , Derek Thomson , 1999 , Fundamentals of spatial information systems, 7th printing , Academic Press , San Diego , CA , US
8. Albert K.W. Yeung , Brent G. Hall , 2007 , Spatial Database Systems: Design, Implementation and Project Management , Springer.
9. Ramez Elmasri , Shamkant B. Navathe , 2007, Θεμελιώδης αρχές συστημάτων βάσεων δεδομένων , έκτη έκδοση , Εκδόσεις Δίαυλος , Μαυρομιχάλη 72-74 , Αθήνα.
10. Αθανάσιος Σταυρακούδης, 2010 , Βάσεις δεσομένων και SQL – Μια πρακτική προσέγγιση , Εκδόσεις Κλειδάριθμος , Στουρνάρη 27Β , Αθήνα .

 

Related academic journals:

1. International Journal of Spatial Data Infrastructures Research – published by European Commission. ISSN: 1725-0463 http://ijsdir.jrc.ec.europa.eu/index.php/ijsdir
2. Journal of Geographic Information System- published by Scientific Research Publishing Editor-in-Chief: Francisco J. Tapiador . Editorial Board: Alia I. Abdelmoty , Tofael Ahamed , Dafer Algarni , Carlos Marcelo Di Bella , Christophe Claramunt , Weihong Cui, Fuchu Dai , Anrong Dang , Hossein Ghadiri , Shuanggen Jin , Saro Lee , Xiang Li , Hervé Martin , Mainguenaud Michel , Jordi Martí-Henneberg , Xiaosheng Qin , Shih-Lung Shaw , P. S. Sriraj , Eddy Lynn Usery , Herna Viktor , Jianhua Xu , Xiaohuan Yang , Axing Zhu , Liangfeng Zhu .ISSN Print: 2151-1950 ISSN Online: 2151-196 http://www.scirp.org/journal/jgis/
3. ISPRS International Journal of Geo-Information- published by MDPI AG Editor-in-Chief : Prof. Dr. Wolfgang Kainz, Editors : Yuanyuan Yang, Martyn Rittman, Ozgun Akcay, Christoph Aubrecht , Emmanuel Baltsavias, Norbert Bartelme , Carlos Granell Canut, Jun Chen, Tao Cheng, Mahmoud R. Delavar, Sisi Zlatanova, ISSN 2220-9964, http://www.mdpi.com/journal/ijgi

 

Useful Webpages
1. http://www.spatial.cs.umn.edu/Book/sdb-chap1.pdf
2. http://dna.fernuni-hagen.de/papers/IntroSpatialDBMS.pdf
3. http://gunet2.cs.unipi.gr/eclass/modules/document/file.php/TMD109/%CE%A3%CE%B7%CE%BC%CE%B5%CE%B9%CF%8E%CF%83%CE%B5%CE%B9%CF%82%20%CE%94%CE%B9%CE%B1%CE%BB%CE%AD%CE%BE%CE%B5%CF%89%CE%BD/3-SDBMS-logical.pdf