OSGeo Planet

gvSIG Team: Geographic Information Systems applied to Municipality Management: List of topics and 1st module, ‘Differences between GIS and CAD’

OSGeo Planet - Mon, 2017-12-04 19:13

We launch the first module of an ambitious free course to acquire the necessary training to apply Geographic Information Systems to the municipality management. This course is based on the use of the gvSIG Suite products, a catalog of open source software solutions for working with the ‘Geo’ component, consisting of desktop, mobile and web solutions. It is important to note that at the end of the course you can obtain an official certificate issued by the gvSIG Association.

We hope that the effort and time that we have devoted from the gvSIG Association to its elaboration is interesting for you, and we also ask you for help to spread it as much as possible. We are going to try to introduce the maximum number of people in the Geographic Information Systems together with open source software.

About the course

The course is based on video-tutorials and practical exercises with municipality data, with some and necessary theoretical introductions to some concepts. Once done we do not doubt that you will become experts in the management of Geographic Information Systems and your work in municipality management will be consequently optimized.

The course is destined for municipal technicians mainly, either architects, draughtsmen, surveyors, computer scientists, foresters, environmentalists, … because almost in any area of a municipality people work in one way or another with geolocated information. The really important thing is that despite being a very complete and advanced course, it starts from scratch … so it is not necessary any previous knowledge to do it.

The list of topics of the course is:

  • Introduction to GIS: Differences between GIS and CAD
  • Introduction to Reference Systems
  • Views, layers, symbology, labeling
  • Attribute tables (alphanumeric information)
  • Attribute tables (joining tables)
  • Introduction to Spatial Data Infrastructures
  • Loading web services from gvSIG Desktop (OGC services)
  • Loading web services from gvSIG Desktop (other services)
  • Add-ons manager
  • Editing: new layers, graphical and alphanumerical editing
  • Editing: derived geometries
  • Geocoding
  • Event layer
  • Hyperlink
  • How to convert cartography from CAD to GIS
  • Reprojection of vector layers
  • Geoprocessing
  • Layout
  • Image georeferencing
  • gvSIG 3D
  • gvSIG Online: Publishing of cartography
  • gvSIG Online: Editing, hyperlink, …
  • gvSIG Mobile: Taking data in the field

The first 2 video-tutorials are theoretical and from module 3 they become eminently practical. In each post (module) we will indicate the link to the cartography necessary to perform the different exercises.

To make the location of all the video-tutorials of the course easy they will be stored in a Playlist.

For any type of doubt or problem that you have, in addition, you can always use the gvSIG Users mailing list. In this post you can find more information on how to register and use the Mailing List: https://blog.gvsig.org/2015/06/17/what-to-do-when-we-get-an-error-in-gvsig/

There will be a final exercise for all those who complete the course and want to obtain an official user certificate in gvSIG. About the certification and final exercise we will give the information with the last modules of the course.

Frequent questions

– How to register?

It is not necessary to make any registration. It is enough to follow the different modules that we will publish in the gvSIG blog. Each post will include a video-tutorial. The first two videos are theoretical ones and from the third one they will include practical exercises.

– Is the whole course online?

Yes, the course is 100% online.

– Can I participate if I am from any country?

Of course, the course is open to anyone, regardless of the country.

– Where can I download the software?

During the course, gvSIG Desktop and gvSIG Mobile will be used.

From the third module, in which the practical part begins, instructions will be given to download and use the software and data necessary to perform the exercises.

– How often will the modules be published?

During December 2017 a module will be published per week (on Monday). The last week of the year any module will be published. From 2018, two modules will be published per week, every Monday and Thursday until the end of the course.

– When does the course end?

At the indicated publishing rate, the course will end in March. Regardless of the end date, the course will be always available, so you can start and end the course -including the certification- freely and at any time.

– Do we have to deliver exercises/practices?

No, the exercises corresponding to each module can be done at your own pace and nothing should be delivered. At the end of the course, and only for those who want to apply for the Certificate, it will be when we will ask for the evaluation exercise.

– Can I receive alerts in my email about new published posts?

Yes, in the lower right part of the blog you will see a section titled “gvSIG blog on your mail”, where it says “Write your email address to subscribe to this blog, and receive notifications on new messages by mail.”

There you can register indicating your email and you will receive an email for each new published post (not only those of the course).

– What will have to be done to get the certificate and how much will it be?

The complete information will be given together with the last modules of the course. It will be necessary to carry out a specific and complete exercise that validates the knowledge acquired during the course, that will be evaluated by a tutor. The cost of the certification will be the minimum to cover the expenses related to the evaluation and certification and it will be € 30. In this way we hope that it is accessible to as many people as possible.

The certificate will be issued by the gvSIG Association and it will include all the information related to the training content acquired.

– Where can I make queries about the course or send problems that I have with the software?

You can do it through the users mailing list. It is a list of gvSIG users, not only students of the course, so it has a high volume of queries per day. Each registered person can ask questions and answer them, being a collaborative and community support.

You can sign up to the users mailing list from this link:


It is recommendable to read this post with the instructions for both registration to the mailing list (including how to configure the registration to avoid receiving all the messages from the list) and for reporting problems:


Module 1: Differences between GIS and CAD

In this first module we introduce the Geographic Information Systems, dedicating a part of it to identify the differences between GIS and CAD. There are many municipalities where technicians are working with CAD, but a few who have implemented a GIS … let’s see the advantages of taking this step.

Filed under: CAD, english, gvSIG Desktop, gvSIG Suite, training Tagged: CAD, city council, gis, municipality management
Categories: OSGeo Planet

QGIS Blog: Documentation for QGIS 3.0 – call for contributions!

OSGeo Planet - Mon, 2017-12-04 17:48

Dear QGIS users, enthusiasts and fine people out there. QGIS 3.0 is coming very soon….we are in a ‘soft freeze’ state at the moment while we wait for some critical last pieces of code to get finalised. Then we go into hard freeze and prepare to roll out our next major release. Those of you that have been playing with the ‘2.99’ builds will surely have noticed that QGIS 3.0 is going to feature a huge number of improvements and new features – both in the user interface and in the API and code internals.

Screen Shot 2017-12-03 at 23.05.34

But we have a BIG problem:
we need your help to document and describe all those fine new features!

Yes fine reader now is the time to break out of the ‘passive user of QGIS’ mould you might find yourself in and lend a hand. We have an issue tracker with an issue for each of the new features that has landed in QGIS 3.0. Even if you do not know how to use our Sphinx based documentation system, you can help tremendously by preparing the prose that should be used to describe new features and attaching it to the issue list linked to above. If you do that, the documentation team can do more editorial work and less  ‘writing from scratch’ work.

Writing documentation is a brilliant way to enhance your own knowledge of QGIS and learn the new features that are coming in the next release. For those starting out with documentation there are issue reports that are tagged “easy” to lower the barrier for beginners. If you are an existing documentation team member it would be great if you could review the list and check whether there are more issues that can be tagged as “easy”.

The issue list is automatically created whenever a developer commits a change to QGIS with the word ‘FEATURE’ in their change notes. In some cases the change may not be something that an end user will be able to see – so it will be great for volunteers to also review the automatically added issues and close off any that are not relevant for documentation.

Other features are quite complex and in some cases could benefit from interaction with the original developer to make sure that the nuances of the new features are properly described. We need documentation writers to follow these thread and present the new functionality in a clear and concise way.

There are some very helpful resources for people just getting started with QGIS documentation. You can read the documentation for contributors. You can also contact the team via the community mailing list for specific help if the contributor docs don’t provide the information you need.

If you want to see the QGIS Documentation up-to-date for the version 3.0 release, please do get involved and help Yves Jacolin and the documentation team!

Lastly if you are not able to directly contribute to the documentation, consider funding QGIS – we have a budget for documentation improvements.

We look forward to your support and contributions!


Tim Sutton (QGIS Project Chairman)





Categories: OSGeo Planet

gvSIG Team: Jornada gvSIG en la Universidad Miguel Hernández de Elche, con entrega de premios de la Cátedra gvSIG (13/12/2017)

OSGeo Planet - Mon, 2017-12-04 16:57

El próximo miércoles 13 de diciembre de 2017 tendrá lugar una jornada gvSIG en la Universidad Miguel Hernández (UMH) de Elche, englobada dentro del marco de la Cátedra gvSIG que organiza la misma Universidad.

La Cátedra gvSIG nació hace unos años con el objetivo de fomentar el uso de la geomática libre en el mundo universitario, y en esta jornada se hará entrega de los premios a los proyectos ganadores del concurso de este año 2017.

El programa de la jornada, que será totalmente gratuita, habrá una presentación sobre los distintos productos de la Suite gvSIG, y también se realizarán dos talleres, uno sobre introducción a gvSIG, en el que se mostrarán las funcionalidades básicas de la herramienta, y otro sobre geoestadística con gvSIG, en el que se verá cómo manejar datos estadísticos en la aplicación.

La inscripción deberá realizarse a través del formulario habilitado a tal efecto en la página web del evento.

Filed under: community, events, gvSIG Desktop, spanish, training
Categories: OSGeo Planet

gvSIG Team: SIG aplicado a Gestión Municipal: Módulo 16.1 ‘gvSIG Online (Publicar cartografía, edición avanzada…)’

OSGeo Planet - Mon, 2017-12-04 15:13

Ya está disponible el primer vídeo del módulo 16 del curso de SIG para Gestión Municipal, donde veremos cómo trabajar con gvSIG Online.

gvSIG Online es una solución integral en software libre para la gestión de la información espacial de una organización siguiendo el paradigma de las Infraestructuras de Datos Espaciales (IDE).

Con gvSIG Online un ayuntamiento puede organizar de la forma más eficiente su información geográfica y disponer de una potente herramienta, tanto para generar de forma muy sencilla visores de mapas o geoportales como para administrar la base de datos espacial de la entidad, apostando además por tecnologías libres que garanticen su independencia tecnológica (además de un considerable ahorro de costes de implantación).

Una IDE permitirá tener organizada toda la información geográfica, facilitará su localización y acceso en tiempo real, evitará la duplicidad de información, solucionará el problema de acceder a la información actualizada y permitirá la interoperabilidad con información geográfica tanto interna como de otras organizaciones.

De forma general, los usuarios de gvSIG Online dispondrán de aplicaciones web o aplicaciones móviles (opcionalmente también de escritorio) para acceder e interactuar con la información geográfica de la organización, haciendo uso capas de servicios estándar como pueden ser el servicio de mapas (WMS) y mapas teselados (WMTS), el servicio de objetos geográficos (WFS) y objetos geográficos transaccional (WFS-T) y el servicio de geoprocesamiento (WPS). Finalmente, toda la información se centralizará en una base de datos espacial.

En este módulo no podréis realizar directamente el ejercicio, ya que es necesaria una implementación de la plataforma, pero sí que podréis ver todo lo que se puede realizar con gvSIG Online.

Si estáis interesados en implementar gvSIG Online en vuestro ayuntamiento, o en cualquier otra organización, podéis escribirnos directamente a info@gvsig.com, donde os informaremos sobre ello.

El vídeo de este módulo es el siguiente:

Post relacionados:

Filed under: geoportal, gvSIG Desktop, gvSIG Online, gvSIG Suite, IDE, spanish, training Tagged: ayuntamientos, geoportal, gestión municipal, gvSIG Online, IDE, Visor
Categories: OSGeo Planet

From GIS to Remote Sensing: Developing the SCP 6: Clustering with K-means and ISODATA algorithms

OSGeo Planet - Mon, 2017-12-04 10:11
I am continuing to update the Semi-Automatic Classification Plugin (SCP) to version 6 (codename Greenbelt).
In the previous posts I have presented the main changes to the SCP dock, the Main interface, the new interface for downloading free products such as Landsat, Sentinel-2, ASTER, MODIS, Sentinel-3, and the new tools for cloud masking and band set mosaic.

Several users in the Facebook group and the Google+ Community asked for the ability to perform unsupervised classification with SCP. In SCP 6 I have added a new tool which allows for the clustering using K-means or ISODATA algorithms.

Clustering tab
Categories: OSGeo Planet

Marco Bernasocchi: Interlis translation

OSGeo Planet - Fri, 2017-12-01 07:18
Lately, I have been confronted with the need of translating Interlis files (from French to German) to use queries originally developed for German data. I decided to create an automated convertor for Interlis (version 1) Transfer Format files (.ITF) based… See more ›
Categories: OSGeo Planet

gvSIG Team: SIG aplicado a Gestión Municipal: Módulo 15 ‘gvSIG 3D’

OSGeo Planet - Thu, 2017-11-30 08:28

Ya está disponible el módulo nº 15 del curso de SIG para Gestión Municipal, donde veremos las principales funcionalidades de la parte 3D de gvSIG, basadas en la aplicación WorldWind de la NASA.

En este módulo aprenderemos a crear una Vista 3D a partir de una Vista 2D. Las vistas que podemos crear son vistas planas, cuando trabajamos en zonas más locales, y las vistas esféricas, cuando queremos verlas con la forma del globo terráqueo.

En las Vistas 3D podremos visualizar los modelos digitales de terreno, a los que podemos superponer cualquier otra capa, como por ejemplo una ortofoto.

Por otro lado, si disponemos de una capa vectorial de edificios, con un campo en el que tenemos el número de pisos o la altura del edificio, podemos crear extrusión, de forma que vemos los polígonos en vertical como si fuese el propio edificio, y nos sirve para visualizar de una forma fácil la estructura de la población.

Finalmente, otra funcionalidad disponible en la parte 3D es la de crear animaciones. Esto se realiza mediante capturas de pantalla en ciertos encuadres, y después se crea un vídeo, interpolando automáticamente entre los diferentes encuadres. Esto nos puede ir bien para una presentación, cuando queremos mostrar las diferentes zonas de nuestra población pero con más detalle.

La cartografía a utilizar en este vídeo la podéis descargar desde el siguiente enlace.

El vídeo de este módulo es el siguiente:

Post relacionados:

Filed under: gvSIG Desktop
Categories: OSGeo Planet

deegree: test-nov-17

OSGeo Planet - Thu, 2017-11-30 07:22


Categories: OSGeo Planet

deegree: test-2

OSGeo Planet - Thu, 2017-11-30 07:18


Categories: OSGeo Planet

Jo Cook: Portable GIS accepted as OSGeo Community Project

OSGeo Planet - Wed, 2017-11-29 09:22
I’m delighted to announce that Portable GIS has been accepted as an official OSGeo Community Project! From a technical perspective, this is the culmination of several months work behind the scenes getting the proper code repository set up here, creating the website, improving the documentation, and formalising the open source license. As a colleague said recently, Portable GIS has moved from being (effectively) freeware, to proper open source. So, there are now official guidelines on how to contribute to Portable GIS development, and on the license terms under which you can use and contribute.
Categories: OSGeo Planet

gvSIG Team: A tenor de las ciudades sostenibles, una reflexión desde #ConamaLocalVLC

OSGeo Planet - Tue, 2017-11-28 14:48

Estos días se celebra en Valencia un evento organizado por CONAMA y cuyo objetivo es ser un foro de debate y de trabajo entre profesionales y administraciones locales. Unas jornadas que están siendo muy enriquecedoras, quizá en gran parte al compromiso que a priori tienen todos los asistentes por hacer más sostenibles nuestras ciudades.

Cuando se habla de sostenibilidad se hace referencia constante a los temas centrales de las jornadas: cambio climático, desarrollo sostenible, transformación de valores, buenas prácticas y modelos innovadores, colaboración entre sectores, instituciones y sociedad, nueva economía y, también, sinergias con la tecnología. Se habla de garantizar una transición justa que permita que los cambios que se activen sean una oportunidad para todos y no sólo para unos pocos o donde haya sectores que salgan perjudicados.

De lo general vayamos a lo particular. En el taller denominado ‘City Makers’ se definieron 8 temas principales. Entre ellos estuvo la ‘Soberanía Tecnológica’.

Interesante el papel de la tecnología en un evento de medio ambiente. Siglo XXI. Empezamos a estar concienciados de su importancia.

Parece una obviedad, pero repitamos que no habrá ciudades sostenibles si la sostenibilidad no se aplica a la tecnología, que no habrá colaboración si no se apuesta por el único tipo de software que lo permite, que esa nueva economía o nuevo modelo productivo…nunca llegará al sector tecnológico si las ciudades no hacen una clara apuesta por el software libre. Siglo XXI. No minimicemos su importancia capital.

En estos días casi no hay presentación en la que no hayan Sistemas de Información Geográfica detrás, se ven mapas y más mapas representando y analizando la información municipal en ese camino hacia la sostenibilidad. La gestión de la información geográfica se ha normalizado. Tenemos software libre para ello, y son cada vez más municipios los que trabajan con la Suite gvSIG con soluciones de escritorio, móviles y web (geoportales, Infraestructuras de Datos Espaciales).

Hay que invertir en sostenibilidad, también tecnológica.

Ciudades sostenibles serán aquellas que también sean ciudades soberanas tecnológicamente, o dicho de otro modo, tecnológicamente sostenibles.

Filed under: gvSIG Suite, opinion, spanish Tagged: cambio climático, ciudades sostenibles, CONAMA
Categories: OSGeo Planet

Paul Ramsey: Nested Loop Join with FDW

OSGeo Planet - Mon, 2017-11-27 16:00

Update: See below, but I didn’t test the full pushdown case, and the result is pretty awesome.

I have been wondering for a while if Postgres would correctly plan a spatial join over FDW, in which one table was local and one was remote. The specific use case would be “keeping a large pile of data on one side of the link, and joining to it”.

Because spatial joins always plan out to a “nested loop” execution, where one table is chosen to drive the loop, and the other to be filtered on the rows from the driver, there’s nothing to prevent the kind of remote execution I was looking for.

I set up my favourite spatial join test: BC voting areas against BC electoral districts, with local and remote versions of both tables.

CREATE EXTENSION postgres_fdw;

-- Loopback foreign server connects back to
-- this same database
host '',
dbname 'test',
extensions 'postgis'

OPTIONS (user 'pramsey', password '');

-- Foreign versions of the local tables
gid integer,
edname text,
edabbr text,
geom geometry(MultiPolygon,4326)
) SERVER test
table_name 'ed_2013',
use_remote_estimate 'true');

gid integer OPTIONS (column_name 'gid'),
id text OPTIONS (column_name 'id'),
vaabbr text OPTIONS (column_name 'vaabbr'),
edabbr text OPTIONS (column_name 'edabbr'),
geom geometry(MultiPolygon,4326) OPTIONS (column_name 'geom')
) SERVER test
table_name 'va_2013',
use_remote_estimate 'true');

The key option here is use_remote_estimate set to true. This tells postgres_fdw to query the remote server for an estimate of the remote table selectivity, which is then fed into the planner. Without use_remote_estimate, PostgreSQL will generate a terrible plan that pulls the contents of the `va_2013_fdw table local before joining.

With use_remote_estimate in place, the plan is just right:

SELECT count(*), e.edabbr
FROM ed_2013 e
JOIN va_2013_fdw v
ON ST_Intersects(e.geom, v.geom)
WHERE e.edabbr in ('VTB', 'VTS')
GROUP BY e.edabbr; GroupAggregate (cost=241.14..241.21 rows=2 width=12) Output: count(*), e.edabbr Group Key: e.edabbr -> Sort (cost=241.14..241.16 rows=6 width=4) Output: e.edabbr Sort Key: e.edabbr -> Nested Loop (cost=100.17..241.06 rows=6 width=4) Output: e.edabbr -> Seq Scan on public.ed_2013 e (cost=0.00..22.06 rows=2 width=158496) Output: e.gid, e.edname, e.edabbr, e.geom Filter: ((e.edabbr)::text = ANY ('{VTB,VTS}'::text[])) -> Foreign Scan on public.va_2013_fdw v (cost=100.17..109.49 rows=1 width=4236) Output: v.gid, v.id, v.vaabbr, v.edabbr, v.geom Remote SQL: SELECT geom FROM public.va_2013 WHERE (($1::public.geometry(MultiPolygon,4326) OPERATOR(public.&&) geom)) AND (public._st_intersects($1::public.geometry(MultiPolygon,4326), geom))

For FDW drivers other than postgres_fdw this means there’s a benefit to going to the trouble to support the FDW estimation callbacks, though the lack of exposed estimation functions in a lot of back-ends may mean the support will be ugly hacks and hard-coded nonsense. PostgreSQL is pretty unique in exposing fine-grained information about table statistics.


One “bad” thing about the join pushdown plan above is that it still pulls all the resultant records back to the source before aggregating them, so there’s a missed opportunity there. However, if both the tables in the join condition are remote, the system will correctly plan the query as a remote join and aggregation.

SELECT count(*), e.edabbr
FROM ed_2013_fdw e
JOIN va_2013_fdw v
ON ST_Intersects(e.geom, v.geom)
WHERE e.edabbr in ('VTB', 'VTS')
GROUP BY e.edabbr; Foreign Scan (cost=157.20..157.26 rows=1 width=40) (actual time=32.750..32.752 rows=2 loops=1) Output: (count(*)), e.edabbr Relations: Aggregate on ((public.ed_2013_fdw e) INNER JOIN (public.va_2013_fdw v)) Remote SQL: SELECT count(*), r1.edabbr FROM (public.ed_2013 r1 INNER JOIN public.va_2013 r2 ON (((r1.geom OPERATOR(public.&&) r2.geom)) AND (public._st_intersects(r1.geom, r2.geom)) AND ((r1.edabbr = ANY ('{VTB,VTS}'::text[]))))) GROUP BY r1.edabbr Planning time: 12.752 ms Execution time: 33.145 ms
Categories: OSGeo Planet
Syndicate content