Saltar apartados

Course - Geodatabase design, creation and management with PostGIS

Spatial databases are essential for the creation of mapping services on the Internet. Geodatabases are used in the storage, management and analysis of geographic information and provide powerful solutions that we do not find in the desktop GIS. In this course we will use PosgreSQL/PostGIS using structured query language (SQL), using spatial functions and other advanced concepts. It is an eminently practical course in which the presented theory applies to a major project, composed of several specific exercises.

The course is face-to-face, with a duration of 20 hours and will take place on 5 March 2015 to 18 March 2015. 2 ECTS credits have been requested.

From is page you can access any type of news and information about the conclusion of the course.

Download registration form


  • Administration and registration


    Mª Carmen Fuentes García

    Building colleges

    Interuniversity Institute of geography
    University of Alicante
    Apartado de Correos 99
    03080 alicante

    Phone: 96 590 3426



    Students University of Alicante €90

    Students from other universities and unemployed people €110

    Rest of personal €140


  • Directed to

    The course is aimed at all those who seeking to create or deploy GIS advanced functionality in their projects or business, either study to migrate their applications to a more rational, open, collaborative model that affects all aspects of GIS: the Organization, data, applications, services, and clients

    • Graduates, engineers or graduates who work in GIS environments:
      • as a simple user or project managers
      • with responsibility for the business management and consulting services.
      • Students in disciplines related to GIS such as geography, computer science, geology, economic, architectural, etc.
    • Teachers from SIG bet by a training model based on software free GIS
    • To all those interested in the "open source" movement, and ultimately to those who want to bet on an economically sustainable, profitable and open model
  • Program

    First session (05/03/2015)
    16:00-16:30 - presentation
    16:30-18:00 - introduction and approach to a practical problem which will take place during the remainder of the sessions
    18:00-18:30 - coffee break
    18:30-19:30 - modeling and implementation of the problem using an entity-relationship model
    19:30-20:30 - bulk import of data into the database of the project.

    Second session (10/03/2015)
    16:00-18:00 - introduction to the language of structured query (SQL)
    18:00-18:30 - coffee break
    18:30-20:30 - advanced concepts.

    Third session (12/03/2015)
    16:00-16:30 - PostGIS geometry and management functions
    16:30-18:00 - creation, reading and editing of geometries
    18:00-18:30 - coffee break
    18:30-20:30 - export of geometries.

    Fourth session (17/03/2015)
    16:00-17:00 - operators and spatial indexes
    17:00-18:00 - measurements and geoprocessing
    18:00-18:30 - coffee break
    18:30-20:30 - linear interpolation

    Fifth session (18/03/2015)
    16:00-17:00 - practice free (I), with the support of the faculty.
    17:00-18:00 - practice free (II), with the support of the faculty.
    18:00-18:30 - coffee break
    18:30-20:30 - practice free (III), with the support of the faculty.

  • Place and dates


    March 5, 2015 March 18, 2015


    Aula Informatica ED/INF5 of the new Faculty of education



  • Faculty

    Personnel attached to the geomatics laboratory of the University of Alicante - Interuniversity Institute of geography

    Personnel attached to the Department of Regional geographical analysis and physical geography of the University of Alicante.


Geomatics lab - Interuniversity Institute of Geography

Laboratorio de Geomática - Instituto Interuniversitario de Geografía
Universidad de Alicante
Apartado de Correos, 99
03080 Alicante (Spain)

Tel: (+34) 96 590 3945

Fax: (+34) 96 590 9485


For further information:, and for enquiries on this web server:

Carretera San Vicente del Raspeig s/n - 03690 San Vicente del Raspeig - Alicante - Tel. 96 590 3400 - Fax 96 590 3464