Geoservers and geospatial data bases

General data

Course ID:	1900-1-SBDP-SG
Erasmus code / ISCED:	07.6 Kod klasyfikacyjny przedmiotu składa się z trzech do pięciu cyfr, przy czym trzy pierwsze oznaczają klasyfikację dziedziny wg. Listy kodów dziedzin obowiązującej w programie Socrates/Erasmus, czwarta (dotąd na ogół 0) – ewentualne uszczegółowienie informacji o dyscyplinie, piąta – stopień zaawansowania przedmiotu ustalony na podstawie roku studiów, dla którego przedmiot jest przeznaczony. / (0688) Information and Communication Technologies (ICTs), inter-disciplinary programmes The ISCED (International Standard Classification of Education) code has been designed by UNESCO.
Course title:	Geoservers and geospatial data bases
Name in Polish:	Serwery i bazy danych przestrzennych
Organizational unit:	Faculty of Geography and Regional Studies
Course groups:	(in Polish) Przedmioty obowiązkowe, dzienne studia I stopnia (ścieżka geoinformatyczna) - sem. 5
Course homepage:	https://el.wgsr.uw.edu.pl
ECTS credit allocation (and other scores):	2.00 Basic information on ECTS credits allocation principles: the annual hourly workload of the student’s work required to achieve the expected learning outcomes for a given stage is 1500-1800h, corresponding to 60 ECTS; the student’s weekly hourly workload is 45 h; 1 ECTS point corresponds to 25-30 hours of student work needed to achieve the assumed learning outcomes; weekly student workload necessary to achieve the assumed learning outcomes allows to obtain 1.5 ECTS; work required to pass the course, which has been assigned 3 ECTS, constitutes 10% of the semester student load.
Language:	Polish
Main fields of studies for MISMaP:	geography spatial development
Type of course:	elective courses
Requirements:	Fundamentals of Geoinformatics I 1900-1-PGI1 Fundamentals of Geoinformatics II 1900-1-PGI2
Prerequisites:	Cartography and topography 1900-1-KARTT Geographic Information Systems 1900-1-SIG Remote sensing 1900-6ATD
Prerequisites (description):	Appropriate application of sotware aiming the selection of relevant information representing spatial processes and spatial phenomena, selection of appropriate functions in order to achieve the intended results of numerical calculations or processing and proper preparation of elaboration of results in a descriptive form, report, supplemented by cartographic presentation, geovisualization or graphical presentation (chart).
Mode:	Classroom
Short description:	The subject of the activity is to convey knowledge about modern technology of database systems and geo-servers, taking into account practical elements: service, management and creation of spatial databases and sharing geospatial data in the Internet.
Full description:	The topics of the course cover theoretical and practical aspects of geoservers and spatial geodatabases. Theoretical part concerns basic concepts and terms, data models and main elements of modern database systems architecture, description of modern tools and database interfaces (including SQL language) used in the construction of geospatial databases. Practical part includes presentation of examples of elements and functions of database implementation in different systems and a description of functioning and available server tools and database clients, which are used by geographic information systems (GIS) and available on the Internet geoservers (geoportals). The course also includes examples of practical projects using the installed software geoservers and database clients. Practical classes also include the presentation of practical examples of handling: reporting and geovisualization of information based on spatial databases on the web using GIS software.
Bibliography:	Beynon-Davies P., 2003, Systemy baz danych, WNT, Warszawa Bielecka E., 2006, Systemy Informacji Geograficznej. Teoria i zastosowania., PJWSTK, Warszawa de Smith, Goodchild, Longley 2006-2008 Geospatial Analysis - a comprehensive guide. 2nd edition Gotlib D., Iwaniak A., Olszewski R., 2008, GIS. Obszary zastosowań, PWN, Warszawa. Krajewski M. (red) 2014, Wizualne bazy danych, Człowiek i społeczeństwo, XXXVI, 2, Wyd.Naukowe UAM, Poznań Longley P.A., Goodchild D.J, Maguire D.J., Rhind D.W., 2006, GIS Teoria i praktyka. Wydawnictwo Naukowe PWN, Warszawa Szczepanek, R., Politechnika Krakowska im. Tadeusza Kościuszki, & Wydawnictwo. (2017). Systemy informacji przestrzennej z QGIS: Podręcznik akademicki. Cz. 1 i 2 Cz. 1 i 2. Wydawnictwo PK.
Learning outcomes:	Theoretical and practical parts of the course are an essential element in shaping the profession of contemporary geographer and are a response to the real requirements of employers. Students learn the theoretical basis and practical applications of techniques and methods of information processing on the basis of databases, assuming a large variety of levels of computer knowledge and methodology, as well as different opportunities to use the skills mastered.
Assessment methods and assessment criteria:	Continuous evaluation - progress of work during the classes, active participation in discussions and implementation of practical activities according to the instructions; implementation of practical projects possible asynchronously with the use of remote learning platform
Practical placement:	-

Classes in period "Winter semester 2023/24" (past)

Time span:	2023-10-01 - 2024-01-28	Selected timetable range: weekly course term Navigate to timetable MO TU W TH FR KON
Type of class:	Seminar, 20 hours more information
Coordinators:	Piotr Werner
Group instructors:	Piotr Werner
Students list:	(inaccessible to you)
Examination:	Course - Grading Seminar - Grading

Classes in period "Winter semester 2024/25" (future)

Time span:	2024-10-01 - 2025-01-26	Selected timetable range: weekly course term Navigate to timetable
Type of class:	Seminar, 20 hours more information
Coordinators:	Piotr Werner
Group instructors:	Piotr Werner
Students list:	(inaccessible to you)
Examination:	Course - Grading Seminar - Grading

Course descriptions are protected by copyright.
Copyright by University of Warsaw.