Welcome to Planet OSGeo

December 14, 2017

gvSIG Team

SIG aplicado a Gestión Municipal: Certificación y enlaces al curso completo

Ya está disponible la certificación del curso de Sistemas de Información Geográfica aplicado a gestión municipal.

Esta certificación se abre tras la publicación de los últimos módulos del curso, pero seguirá abierta de forma continua, por lo que cualquier usuario podrá obtenerla en el momento en que finalice los distintos módulos.

Para poder obtener dicha certificación se deberá completar un completo ejercicio, que incluye algunos de los contenidos impartidos durante el curso. Así mismo, se deberá tener correctamente al menos 7 de las 10 actividades existentes en dicho ejercicio.

El ejercicio validará los conocimientos adquiridos durante el curso y será evaluado por un tutor.

Aparte de la entrega y aprobación del ejercicio, la certificación llevará un coste mínimo, necesario para cubrir los gastos relativos a la evaluación y certificación. Este coste será de 30.

La certificación será emitida por la Asociación gvSIG, y estará compuesta por dos certificados:

Certificado de aprovechamiento del curso, que incluirá toda la información relativa a los contenidos formativos adquiridos.

Certificado oficial gvSIG Usuario, al haber completado los 90 créditos necesarios para ello, y que da derecho a poder obtener el certificado de gvSIG Usuario Experto, realizando y aprobando los créditos necesarios para su convalidación, a través de los cursos ofrecidos por la Asociación gvSIG.

El tiempo de dedicación del curso se ha estimado en 90 horas.

El ejercicio a completar y la cartografía a utilizar en el mismo pueden descargarse desde el siguiente enlace.

En el primer apartado del ejercicio práctico se explica con detalle los pasos a seguir para enviar la práctica, así como para la realización del pago para poder obtener los dos certificados.

Si aún no has realizado el curso puedes seguir los distintos módulos desde los siguientes enlaces:


Filed under: CAD, geoportal, gvSIG Desktop, gvSIG Mobile, gvSIG Online, gvSIG Suite, gvSIG technologies, IDE, software libre, spanish, training Tagged: ayuntamientos, Certificación, curso, gestión municipal

by Mario at December 14, 2017 11:50 AM

gvSIG Team

Premios III edición Concurso Cátedra gvSIG

Ayer se realizó la entrega de Premios de la Cátedra gvSIG por parte de Federico Botella, Vicerrector de Tecnologías de la Información de la Universidad Miguel Hernández de Elche. La jornada fue inaugurada por Xavi Barber, Vicerrector Adjunto de Investigación e Innovación para la Investigación.

Este año se han recibido un número considerablemente superior de propuestas respecto a años anteriores, lo que sin duda da todavía más valor a estos galardones. Enhorabuena a los premiados y un agradecimiento especial a todos los participantes.

Los premiados en la edición de 2017 han sido:

Premio Bachillerato

Vichadero Limpio, Vichadero Lindo” Equipo de estudiantes y docentes del Liceo de Vichadero – Departamento de Rivera (Uruguay).

Premio Fin titulación universitaria

“Disponibilidad de materia orgánica procedente de lodos de depuradora en la Comarca del Bajo Vinalopó, georreferenciación y optimización del uso agrícola” Juan Manuel Javaloyes Tomé (España)

Premio Tesis / Trabajo de investigación

“Propuesta metodológica para la caracterización del comportamiento energético pasivo del parque edificatorio residencial existente considerando su contexto urbano” Marta Braulio Gonzalo (España)

Desde la Cátedra gvSIG se pondrán en breve en contacto con los premiados para hacerles llegar el premio económico otorgado.

Aquí tenéis el enlace a la entrega de los premios en la que previamente se hizo una presentación de la Suite gvSIG:

https://youtu.be/RdSLYFGCwY0?t=45m38s

Presentación de la Suite gvSIG:

https://youtu.be/RdSLYFGCwY0


Filed under: premios, spanish Tagged: Cátedra

by Alvaro at December 14, 2017 11:08 AM

gvSIG Team

SIG aplicado a Gestión Municipal: Módulo 17 ‘gvSIG Mobile (conexión con gvSIG Desktop)’

Ya está disponible el vídeo del módulo 17 del curso de SIG para Gestión Municipal, con el que finaliza dicho curso, y en el que veremos la integración de gvSIG Mobile con gvSIG Desktop.

A partir de ahora se puede obtener el certificado del curso, siguiendo las instrucciones indicadas en el siguiente post.

Como vimos en el módulo anterior, gvSIG Mobile juega un papel importante en la gestión de un ayuntamiento, ya que nos permite realizar censos, inspecciones, gestión de inventario…

Con gvSIG Mobile se puede realizar el inventario de un municipio (papeleras, farolas, paques infantiles…), y gracias a eso, si hay una incidencia en alguno de los elementos, no será necesario describir a los técnicos qué elemento es. Directamente podrían ir con su móvil, y localizar de una forma fácil la farola o papelera a arreglar en su mapa.

En este vídeo explicaremos cómo crear una capa vacía en gvSIG Desktop, con los campos que deseemos, y cómo exportarla a gvSIG Mobile. Ya con la aplicación móvil la editaremos, creando nuevos elementos (podemos crear una capa de puntos, de líneas o de polígonos), con o sin el uso de GPS, y editando su información alfanumérica. Finalmente la exportaremos a gvSIG Desktop para poder realizar análisis más completo.

Como comentamos en el módulo anterior, gvSIG Mobile está disponible para Android, para descargar de forma gratuita desde la Play Store.

Para poder intercambiar ficheros entre ambas aplicaciones utilizaremos las bases de datos Spatialite, funcionalidad que estará disponible a partir de la versión final de gvSIG Desktop 2.4.

Dicha versión incluirá también un plugin que permitirá exportar e importar proyectos completos (con notas, fotografías…) entre gvSIG Mobile y gvSIG Desktop, así como exportar desde gvSIG Desktop una capa de teselas (una ortofoto o fichero vectorial) a gvSIG Mobile para poder insertarla de fondo.

En unas semanas se realizará un taller completo sobre el uso de estas funcionalidades, que se anunciará en las redes sociales del proyecto gvSIG (Facebook, Twitter…) y en el blog.

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

 

Post relacionados:


Filed under: gvSIG Desktop, gvSIG Mobile, spanish, training Tagged: ayuntamientos, Censos, gestión municipal, gvSIG Desktop, gvSIG Mobile, Inspecciones, inventario, SpatiaLite

by Mario at December 14, 2017 10:01 AM

December 11, 2017

gvSIG Team

GIS applied to Municipality Management: Module 2 ‘Introduction to reference systems’

At this second module, the last theoretical one before starting with the practical part,  we will speak about reference systems and how we can apply them in a GIS to represent our geographic information correctly.

It is very important to know about this issue because if we load two layers that are in different reference systems, in a same view, we can have them without being overlapped correctly. We will have to manage their reference systems to solve this problem.

Reference systems can be managed in different ways, and one of the most used options is through EPSG codes, where each different reference system is corresponding to a different code.

At this link you can see the list of EPSG codes of the different reference systems, that will help you to work with your cartography in gvSIG: http://downloads.gvsig.org/download/geodata/EPSG_codes/Projected_Coordinate_Reference_Systems.pdf

And here you have the video of this second module:

Related post:

Module 1: Differences between GIS and CAD


Filed under: english, training Tagged: city council, Coordinate system, CRS, municipality management, Reference systems, SRS

by Mario at December 11, 2017 11:30 AM

gvSIG Team

SIG aplicado a Gestión Municipal: Módulo 16.3 ‘gvSIG Online (conexión con gvSIG Mobile y creación de enumeraciones)’

Ya está disponible el tercer vídeo del módulo 16 del curso de SIG para Gestión Municipal, donde veremos la integración de gvSIG Online con gvSIG Mobile, y cómo crear enumeraciones en gvSIG Online.

Aparte de las funcionalidades disponibles en gvSIG Online tenemos también la posibilidad de conectarlo con gvSIG Mobile, la aplicación de gvSIG para dispositivos móviles con Android.

Con gvSIG Online podíamos hacer una edición básica desde nuestro dispositivo, utilizando incluso el GPS, como vimos en los módulos anteriores, ya que trabaja sobre un navegador. Pero aparte podemos también trabajar con gvSIG Mobile desde nuestro Smartphone, pudiendo crear nuevas geometrías y editar su parte alfanumérica.

Si tenemos la integración entre ambas aplicaciones, una de las principales ventajas de trabajar en campo con gvSIG Mobile es que no necesitamos conexión a internet para editar nuestras capas.

Con gvSIG Mobile podemos conectar a nuestro servidor de gvSIG Online, y descargar la capa queremos editar en nuestro dispositivo. De esta forma podemos editarla sin necesidad de tener conexión a internet, un problema común cuando estamos trabajando por ejemplo trabajando en zona de campo o montaña donde no hay cobertura móvil. Nosotros editaríamos nuestra capa, pudiendo utilizar el GPS, y al final guardaríamos los cambios. Finalmente, cuando tuviésemos conexión a internet, subiríamos los cambios al servidor.

Una vez subidos los cambios, si la capa estaba publicada en alguno de los proyectos, al refrescar aparecería con las modificaciones realizadas.

En este módulo veremos también cómo crear enumeraciones en gvSIG Online. Esto nos permitirá configurar un campo con ciertos valores posibles, de forma que facilitará el trabajo de campo cuando estemos trabajando con gvSIG Online. Podremos configurar unos valores para un campo concreto, y en el momento de editar los datos alfanuméricos, en ese campo tendremos un desplegable con los posibles valores, de forma que no nos equivocaremos al escribir.

Al igual que el módulo anterior, no podréis realizar directamente este ejercicio, ya que es necesaria una implementación de la plataforma gvSIG Online, pero sí que podréis ver todo lo que se puede realizar con ella. En el próximo módulo sí que veremos la conexión entre gvSIG Mobile y gvSIG Desktop, que sí que podréis realizar, ya que ambas aplicaciones están disponibles para descargar de forma gratuita.

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 Mobile, gvSIG Online, gvSIG Suite, IDE, spanish, training Tagged: ayuntamientos, Enumeraciones, gestión municipal, gvSIG Mobile, gvSIG Online, IDE

by Mario at December 11, 2017 09:37 AM

December 07, 2017

gvSIG Team

Camino a gvSIG 2.4: Herramienta de Información Rápida

Una herramienta desarrollada para los Talleres de las Jornadas de gvSIG donde se explicó su desarrollo paso a paso, se ha convertido en una herramienta totalmente funcional para los usuarios de la próxima versión de gvSIG 2.4.

El objetivo de la herramienta es el de mostrar información de las entidades vectoriales en forma de etiqueta cuando pasemos el ratón por encima.

Para ello debemos de instalar la aplicación desde el Administrador de Complementos desde gvSIG 2.4. Seleccionamos Instalación desde URL como en la imagen:

Buscaremos en el Filtro la herramienta Quick Info y seleccionaremos su instalación. En caso de tenerla ya instalada este botón aparecerá en verde:

Para activar su uso, debemos de tener una capa vectorial abierta, en este caso tenemos un shapefile abierto. Si presionamos sobre él en la Tabla de Contenidos podremos ir a las propiedades de la aplicación de Información Rápida:

Seleccionamos la opción “Usar un campo” y el campo que queramos de la capa vectorial. Ahora para comenzar su visualización ya podremos activar la aplicación en la Vista después de clickar sobre el botón de la herramienta:

Y al pasar el ratón por encima de las entidades aparecerá un tooltip mostrando la información relativa a ese campo sobre la entidad:

También tenemos la opción de generar etiquetas más complejas. Por ejemplo, queremos que aparezca el nombre de Referencia, delante de la información del campo ‘reference’ de la capa vectorial. Estableceriamos el siguiente formato:

"Reference: %s" % refman

Y se visualizaría así:

Podemos realizar operaciones matemáticas:

pob_0_14 + pob_15_65

Visualizaciones más complejas con múltiples campos:

"0-14: %s, 15-65: %s, >66: %s" 
% (pob_0_14 ,pob_15_65 ,pob_66_mas)

Usando formato HTML para mejorar la visualización:

"<html><b>0-14:</b> %s
<br><b>15-65:</b> %s</br>
<br><b>>66:</b> %s</br>
<html>" 
% (pob_0_14 ,pob_15_65 ,pob_66_mas)

O una mezcla de ambos ejemplos anteriores:

"<html><b>Poblation 0-65:</b>
<br>%s</br>
</html>"
% (pob_0_14 + pob_15_65)

Es una herramienta en desarrollo así que cualquier comentario por vuestra parte o localización de errores será bien recibido. Puedes ponerte en contacto con nosotros directamente en las Listas de Usuario.

También puedes encontrar el código a vuestra disposición en Github: gvsig-desktop-scripting-quickinfo

 

 


Filed under: development, gvSIG Desktop, gvSIG development, scripting, spanish

by Óscar Martínez at December 07, 2017 10:53 AM

gvSIG Team

SIG aplicado a Gestión Municipal: Módulo 16.2 ‘gvSIG Online (Edición básica, hiperenlace…)’

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

Como comentamos en el módulo anterior, 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).

En el primer vídeo vimos cómo conectar con gvSIG Desktop, pudiendo hacer una edición avanzada directamente en la aplicación de escritorio y publicando en gvSIG Online.

En este segundo vídeo veremos la edición disponible en gvSIG Online, una edición más básica pero que nos permite trabajar en campo con nuestro dispositivo móvil, al poder editar directamente en web.

También veremos cómo crear hiperenlaces en gvSIG Online, una funcionalidad muy útil que nos permitirá por ejemplo poder enlazar los documentos relacionados con las normativas urbanísticas de un ayuntamiento. Esto facilitara su obtención por parte del ciudadano sin tener que desplazarse al ayuntamiento. Sobre el proyecto de gvSIG Online el ciudadano buscaría su parcela, y con la herramienta de información obtendría por ejemplo el fichero PDF con toda la información.

Al igual que el módulo anterior, no podréis realizar directamente este 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 Online, IDE, spanish, training Tagged: ayuntamientos, edición, geoportal, gestión municipal, Visor cartográfico

by Mario at December 07, 2017 09:47 AM

December 06, 2017

OSGeo.nl

Verslag: OSGeo.nl Dag 2017

De zesde OSGeo.nl Dag 2017 vond plaats op 22 November 2017 op de GeoBuzz in Den Bosch. Onder het motto “Samenwerking Versnelt” haakten wij in bij het GeoBuzz-thema: “Geo Versnelt”.

Hieronder een kort verslag, voor de TLDR; lezer: hier staan alle presentaties.
Eng.: this is a report with slides (in Dutch) of the yearly “OSGeo.nl Day” organized by OSGeo.nl“.

Dank aan allen die hieraan meegewerkt hebben, in bijzonder Winifred Broeder (programma, logo’s, promotie materiaal, foto’s) , Ynte de Wolf (programma), Steven Ottens (techniek) en uiteraard alle sprekers die zich merkbaar degelijk hadden voorbereid!

Hieronder ons programma en tijdlijn op GeoBuzz website of klik op plaatje of Download Programma als PDF.

De Presentaties

Just van den Broecke (voorzitter OSGeo.nl) – Opening – SLIDES

Inleiding in het programma en thema, en vooral ook Gert-Jan van der Weijden werd in zonnetje gezet voor vier jaar uitmuntend voorzitterschap van OSGeo.nl.

Raymond Nijssen (TerGlobo)  –  “Achter de schermen bij QGIS” – SLIDES

Hoe is QGIS ontstaan? Door wie wordt het gemaakt? Waarom gaan de ontwikkelingen steeds sneller? En hoe organiseer je een dergelijk proces?

Erik Meerburg (Geo Academie)  –  “Certificatieprogramma QGIS trainingen” SLIDES

De volgende stap in het ‘maturity model’ van QGIS is dat gebruikerscertificatie op gang komt. Die stap wordt nu door de internationale QGIS-community gezet. Binnen Nederland dragen het IHE en de Geo Academie bij aan deze ontwikkeling, onder andere door het daadwerkelijk uitreiken van QGIS trainingscertificaten aan de deelnemers van hun trainingen. In deze sessie praat Erik je bij over de stand van zaken en de toekomst van de certificering. En naar verwachting gaat hij ook lelijke dingen zeggen over de in zijn ogen brakke manier waarop we in de Nederlandse geowereld omgaan met permanente educatie.


Erik’s “Striptease”:  showing his various T-shirts, thus “Open Source hats” he is wearing in his busy life….

Het leuke aan de certificering is dat je dit alleen samen kan doen: zonder community die hier waarde aan hecht is certificering zinloos. Dat geldt voor Nederland, maar het optuigen van een internationaal certificeringsprogramma zorgt ook voor een bijzonder stukje samenwerking wereldwijd: het team dat hieraan werkt wordt gehost vanuit Zuid-Afrika, met deelname vanuit Denemarken, de VS en Nederland. En met Nederland als eerste land ter wereld waar QGIS certificaten zijn uitgedeeld mogen we ook best een beetje trots zijn.

Richard Duivenvoorde (Zuidt) –  “Koele en  Nieuwe Zaken, 3D!, in QGIS” SLIDES

Demo van de allernieuwste “features” in QGIS versie3.

Michiel Bootsma  (Wetterskip Fryslân)  –  “Opensource Geoprocessing – Waardevolle gereedschapskist voor vakspecialisten” SLIDES

Binnen organisaties is het GIS-aanbod veelal afgestemd op ondersteuning van de primaire processen. Voor specifieke GIS-analyses kan opensource geoprocessing uitkomst bieden.

Jacco Wanders (Stantec) – “OpenSource opent deuren voor landelijke BodemRisicoKaart en GebiedsInformatieManagement portalen” SLIDES

Onderwerpen: Uitvoeren complexe landelijke ruimtelijke analyses (bodemrisicokaart);

– Landelijke Bodemrisicokaart (Postgres/Postgis, Geoserver en GRASS)
– Web-api
– routekaart om tot een landelijke risicokaart te komen.

GebiedsInformatieManagement portalen (GIM)

– GIM Vliegkamp Valkenburg (Flamingo-geocms en Geo-network)
– GIM HEMbrug  (Flamingo-geocms en Geo-network)

Samenwerken op maat: Hoe zetten we ons netwerk in voor project specifieke vraagstukken  (sparsessie ect.)

Victor Mensing (Nationale Databank Flora en Fauna) – “OSGEO bij de Nationale Databank Flora en Fauna (NDFF)” SLIDES

De Nationale Databank Flora en Fauna  bundelt, uniformeert en valideert natuurgegevens in Nederland.  De gegevens brengen in beeld wat in een bepaald gebied bekend is over het voorkomen van planten- en diersoorten. Er zijn ruim 115 miljoen waarnemingen in de NDFF opgeslagen en dit aantal groeit dagelijks.

Bij de NDFF wordt op alle fronten gebruik gemaakt van Open Source Software en uiteraard OSGEO-software, zoals Postgresql/postgis, Mapserver en QGis en diverse OS software waarop we kunnen leunen.

Wat doen we dan bijvoorbeeld? Waarnemers faciliteren met invoerportalen en (mobiele) invoertools,  abonnementhouders en dataservice-afnemers ondersteunen met portalen en dataservices, en de interne organisatie stroomlijnen.

In deze presentatie wordt een overzicht gegeven van de inzet van OSGIS binnen de gehele organisatie en vooral wat het belang van OSGEO-software binnen de wereld van natuurwaarnemingen in de afgelopen 13 jaar. Een wereld zonder OSGEO is voor ons ondenkbaar en onmogelijk geworden.

Mark Verlaat (presenter) en Leon van der Meulen (RUG) – “Stemwegwijzer.nl” SLIDES

Op Stemwegwijzer.nl kun je het dichtstbijzijnde stembureau vinden bij jou in de buurt. Bij de Geodienst van de Rijksuniversiteit Groningen maakten we afgelopen voorjaar deze applicatie voor de Tweede Kamer verkiezingen met daarin álle locaties van stembureaus in Nederland. Een uitgebreide database met al deze locaties bleek er niet te zijn, dus zijn we alle gegevens gaan verzamelen als open data.

Alle gemeentelijke websites werden bekeken en kaartjes en adressen verzameld. Als de gegevens ontbraken, werden gemeenten gebeld en werd “analoog” doorgegeven op welke locaties er stembureaus zijn. En soms zijn we in de Staatscourant gaan zoeken. Gedurende het proces zijn verschillende FOSS4G producten gebruikt (o.a. QGIS, Leaflet en OSRM). Tijdens deze presentatie neem ik je mee in het proces van het ontstaan van het idee tot de lancering van de applicatie én een doorkijkje naar de toekomst.

Barend Köbben (presenter) en Rob Lemmens   (ITC)  – “ILWIS: een oude (on)bekende” SLIDES

Al in 1988 werd op het ITC begonnen met versie 1.0 van het Integrated Land and Water Information System (ILWIS). Tegenwoordig is het een veelzijdig Open Source GIS, vooral sterk in Remote Sensing Image Processing en het modelleren van natuurlijke processen.  Momenteel werkt de ILWIS community aan ILWIS NG, een geheel nieuwe modulaire opzet.

Dit opent allerlei mogelijkheden tot samenwerking met andere software: bijvoorbeeld om ILWIS in de QGIS Processing Toolbox gebruiken en met Python te automatiseren.

Thijs Brentjens (voorzitter OpenGeoGroep) – “OpenGeoGroep: Spil in Open Source Samenwerking” SLIDES

De OpenGeoGroep (OGG) is een coöperatie van Open Source geo-specialisten in Nederland. Als geen ander staat de OGG centraal in meerdere vormen van Open Source samenwerking:

  • Voor klanten verzorgt zij advies, ontwikkeling en beheer van vaak complete Open Source infrastructuren
  • Vele OGG-leden participeren aktief, vaak als “committers”, in Open Source projecten en communites als NLExtract, Flamingo, QGIS en OSGeo.nl.
  • Omdat de OGG geen winstoogmerk kent, doneert zij een deel van de winsten aan Open Source projecten zoals QGIS, Wikipedia en Mozilla.

Cor Melse (RIVM) en Paul van Genuchten (GeoCat) duo-presentatie – “GeoNetwork Gebruikersgroep” – – SLIDES (Cor) and  SLIDES (Paul)

Metadata publiceer je liefst in een Catalogus voor het Web. Geonetwork is zo’n catalogus die je wel kent als het Nationaal Georegister. RIVM, RWS en Kadaster zijn actieve gebruikers van Geonetwork, zij gebruiken  Geonetwork als hun dataregistratie omgeving waarin de datasets en services zijn  beschreven conform de in Nederland gebruikte OGC standaarden.

Elke organisatie kent zo de eigen behoeften die ze graag op Geonetwork ingevuld willen zien, bv ter bevordering van het gebruiksgemak van de metadata editor. De genoemde 3 organisaties zagen een meerwaarde in het oprichten van een Nederlandse gebruikersgroep waarin we deze wensen kunnen bundelen en wellicht ook gezamenlijk kunnen financieren.

Het idee er achter is te komen tot een Geonetwork NL versie die dicht op de internationale variant aansluit.Door met een plugin methodiek te werken/ontwikkelen kunnen we gezamenlijk komen tot een betere en nog gebruikersvriendelijker product dat naar wens door alle organisaties in Nederland ingezet kan worden.

Kadaster (NGR), RWS en RIVM willen zo, samen met jullie, komen tot een gedragen oplossing voor de publicatie van (geo)metadata voor heel GeoNederland.

by Just van den Broecke at December 06, 2017 10:17 PM

Free and Open Source GIS Ramblings

Data exploration with Data Plotly for QGIS3

Data Plotly is a new plugin by Matteo Ghetta for QGIS3 which makes it possible to draw D3 graphs of vector layer attribute values. This is a huge step towards making QGIS a one stop shop for data exploration!

Data Plotly adds a new panel where graphs can be configured and viewed. Currently, there are nine different plot types:

The following examples use tree cadastre data from the city of Linz, Austria.

Scatter plots with both two and three variables are supported. After picking the attributes you want to visualize, press “Create plot”.

If you change some settings and press “Create plot” again, by default, the new graph will be plotted on top of the old one. If you don’t want that to happen, press “Clean plot canvas” before creating a new plot.

The plots are interactive and display more information on mouse over, for example, the values of a box plot:

Even aggregate expressions are supported! Here’s the mean height of trees by type (deciduous L or coniferous N):

For more examples, I strongly recommend to have a look at the plugin home page.


by underdark at December 06, 2017 09:57 PM

QGIS Polska

blog:podrecznik_do_qgis

W repozytorium Politechniki Krakowskiej zostało udostępnione elektroniczne wydanie podręcznika „Systemy informacji przestrzennej z QGIS, część I i II”, który ukazał się w roku 2017. W tym wydaniu dodano m.in. tematy związane z przetwarzaniem zdjęć satelitarnych oraz pracę z bazami danych przestrzennych.

by robert at December 06, 2017 06:21 PM

Paul Ramsey

PostGIS "Fund Me" Milestone

On the twitter this morning, there was a good question:

TL;DR: If you find a feature in “Fund Me” and want to fund it, join the postgis-devel mailing list and make yourself known.

If you go to the PostGIS ticket report and scroll through the pages you’ll first see some milestones tied to released versions. These are usually bug reports, both big and small, valid and invalid, and will eventually be closed.

We unfortunately carry a lot of tickets in the current development milestone (2.5 right now) which are, at best, speculative. They should probably be closed (we really will never do them and don’t much care) or moved to the “Fund Me” category (they are valid, but we have no personal/professional impetus to address them).

The “Fund Me” category used to be called “Future”. This was a bad name, as it implied that sometime in the “Future” the ticket might actually be addressed, and all you needed was sufficient patience to wait. The reality is that the way a ticket got into the “Future” category was that it was ignored for long enough that we couldn’t stand to see it in the current milestone anymore.

The PostGIS development community includes all kinds of developers, who make livings in all kinds of ways, and there are folks who will work on tasks for money. The “Fund Me” milestone is a way of pointing up that there are tasks that can be done, if only someone is willing to pay a developer to do them.

That’s the good news!

The bad news is that the tickets all look the same, but they are wildly variable in terms of level of effort and even feasibility.

  • #220 “Implement ST_Numcurves and ST_CurveN” would probably take a couple hours at the outside, and almost any C developer could do it, even oen with zero experience in the PostGIS/PostgreSQL/GEOS ecosystem.
  • #2597 “[raster] St_Grayscale” would require some knowledge of the PostGIS raster implementation and image processing routines or at least the GDAL library.
  • #2910 “Implement function to output Mapbox Vector Tiles” actually happened in 2.4, but the (duplicate) ticket remained open, as a reminder that we’re terrible at ticket management.

And then there’s the “big kahunas”, tasks that live quietly in one ticket but actually encompass massive research and development projects spanning months or years.

  • #1629 “Tolerance and Precision strategy” is a super idea, that would allow functions like ST_Intersects() or ST_Equals() to return true if a condition was met within a tolerance. However, it would require substantial enhancement to GEOS, to allow predicate evaluation within a tolerance context, as well as a changes to non-GEOS backed distance functions, and new signatures for every geometry relationship function. Given the depth of the GEOS problem, I’d estimate multiple months of effort, and a potential for zero deliverables at all if things went pear-shaped.
  • #472 “Missing ST_IsValid for Geography Types” is even worse than the tolerance problem, since it should really be implemented as a complete rewrite of GEOS to understand non-linear edge types, either through a cheater’s strategy to turn do local projections of geographic edges, or as a full understanding of geographic edges. On the upside, doing that would allow many of the other GEOS functions to support geography which would vastly expand geography functionality in one stroke. On the downside, it is again in the category of a year-long effort with a potential failure at the end of it if for unexpected reasons it turns out to be impossible within that timeframe.

These kind of core features basically never get funded, because the marginal benefit they provide is generally much lower than the development cost for any one organization. This is a common open source weakness: aggregating funding is something everyone agrees is a great idea in principle but rarely happens in practice.

Occasionally, lightning does strike and a major funded feature happens. PostGIS topology was funded by a handful of European governments, and my work on the geography type was funded entirely by Palantir. However, usually funders show up with a few thousand dollars in hand and are dismayed when they learn of the distance between their funds and their desires.

December 06, 2017 04:00 PM

GIS for Thought

Finland 100 with 90 years of Finnish hockey

Finland is 100 years old today.

It has been a rich history. It is a young country, with myself being alive for almost a third of it.

In honour of #Finland100. Here is 90 years of Finnish hockey champions:

100 years of Finnish Hockey

Starting with the 1927-1928 season with six teams the Finnish championship started with the SM-Sarja.
“S” for Suomen meaning Finnish.
“M” for Mestaruus meaning Championship
“Sarja” meaning series

The first year consisted of the following teams:
Viipurin Reipas – Viipuri Swift
HIFK – Sporting Society Comrades, Helsinki – Future 7 time champions
HJK – Helsinki Football Club – Future 3 time champions
KIF – Kruununhaka Sports Club (Helsinki) – Future 3 time champions
Tapa – Tampere Ballers – Future champions
HPS – Helsinki Ball Club

With ice hockey still being a very new sport in 1927 the victory went to Viipurin Reipas, primarily a football and bandy club. Located in Viipuri, a city which was lost to Russia after the Winter War.

At this stage ice hockey was purely an amateur sport, with sports clubs taking part in ice hockey as part of a larger program. Most often football in the summer and ice hockey in the winter, but also combined with other sports.

After Viipuri the championship went to Helsinki, with their football club. While no longer active in ice hockey they are still active in the highest level of Finnish football.

The Helsinki – Tampere fight for hockey championship was established early, with 1930-1930 seeing a standing of:
Helsinki 1
Tampere 1
Viipuri 1

The next few years also saw the Helsinki Figure Skating Club (HSK) win the championship, three times in total.

1939 to 1945 were crucial years for Finnish history. The war with Russia was one for the survival of Finland as a whole.
Some sacrifices had to be made.

The 1939-1940 season was completely called of for the Winter War. During which the captain of Tampere Ilves (3 time champions at the time, and 16 time champions all time) Jussi Tiitola was killed, among others.

The 1940–1941 season was played in between hostilities as an 8 team series.

1941–1942 was cancelled for the Continuation War.

1942–1943 was played as an 8 team series. With KIF winning their third championship in a row, discluding pauses for war.

The 1943–1944 season was started but a mass bombing of the Helsinki Kaisaniemi stadium called the season short. It was agreed that if Tampere Ilves (who had 0 losses at the time) could beat Tarmo and KIF they would be awarded the championship. They beat Tarmo, but unfortunately the transport connections between Tampere and Helsinki were bombed the day before the Ilves – KIF match. Thus the championship was never awarded.

The after war period saw a domination from the Tampere. With 18 championships in 24 years. With Ilves winning 11 and TBJ/Tappara winning 6 and KOO-VEE 1.

But notably champions from other cities aside from Helsinki and Tampere emerged.

Like TPS from Turku first champions in 1956, but future 11 time champions.

Tarmo (no longer active) from Hämeenlinna winning two in a row.

Lukko from Rauma winning their only championship so far in 1963, coming close in the future; with silver: 1961, 1966, 1988, and bronze: 1965, 1969, 1994, 1996, 2011, 2014.

And Pori, with RU-38 in 1967, Porin Karhut in 1965, and together as Porin Ässät (Pori Aces) in 1971.

While the SM-Series was mainly amateur it changed into the SM-Liiga in 1975, bringing with it a move to a professional sport.

This also introduced the playoffs to determine the overall champions. Also a relegation system was introduced, with teams coming last in the SM-Liiga facing relegation to a lower division and giving lower teams and opportunity for promotion.

The first championship outside of Southern Finland went to Oulu in 1981.

1985 was the latest championship for Ilves, their 16th in total.

Kärpät won again in 2004, and 2005 with back to back championships. With two more back to back championships to come.

With JYP from Jyväskylä winning in 2008 the total of cities with victories comes to 9.

The Ilves crown of 16 championships was met by Tappara (formerly TBK) in 2016, and beat in 2017 with back-to-back victories.

Here’s to another 100 years and more of hockey in Finland.

by Heikki Vesanto at December 06, 2017 03:16 AM

December 05, 2017

gvSIG Team

Material del Taller de Desarrollo Avanzado con Scripting de las 13as Jornadas gvSIG

 

Con motivo de las 13as Jornadas Internacionales gvSIG se impartió un taller de “Desarrollo avanzado en gvSIG con Scripting”. Hemos subido al catalogo de scripts de gvSIG el ejercicio terminado junto con la documentación que preparamos para la realización del taller.

Podéis encontrarlo en:

http://downloads.gvsig.org/download/web/scriptcatalog/build/html/packages/quickinfo.html

Desde ahí podéis descargarlo y seguir el taller siguiendo el documento:

– docs/quickinfo.pdf

También podéis descargarlo directamente en la versión gvSIG 2.4 desde el Administrador de Complementos, accediendo a la descarga en línea:

 

Así mismo también tenéis en la carpeta “approachs” el script en los distintos
pasos que se comentan en la documentación para que podáis repasar que es lo que
se acaba obteniendo en cada uno de ellos.

En la aplicación vemos cómo iniciar su uso desde un botón:

Y cómo configurar sus propiedades desde el menú de Propiedades de la capa:

Esta extensión es completamente utilizable por cualquier usuario de gvSIG. Próximamente realizaremos un post sobre su uso.

Puedes ver la documentación del Taller de Iniciación a Scripting en el siguiente enlace.

Cualquier duda sobre el taller o el módulo de Scripting podéis hacerlas en las Listas de Correo.


Filed under: development, gvSIG Desktop, scripting, spanish

by Óscar Martínez at December 05, 2017 02:44 PM

December 04, 2017

gvSIG Team

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

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:

https://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional

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:

https://blog.gvsig.org/2015/06/17/what-to-do-when-we-get-an-error-in-gvsig/

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

by Mario at December 04, 2017 07:13 PM

QGIS Blog

Documentation for QGIS 3.0 – call for contributions!

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)

 

 

 

 


by Tim Sutton at December 04, 2017 05:48 PM

gvSIG Team

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

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

by Mario at December 04, 2017 04:57 PM

gvSIG Team

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

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

by Mario at December 04, 2017 03:13 PM

From GIS to Remote Sensing

Developing the SCP 6: Clustering with K-means and ISODATA algorithms

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

by Luca Congedo (noreply@blogger.com) at December 04, 2017 10:11 AM

December 01, 2017

Marco Bernasocchi

Interlis translation

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 ›

by Mario Baranzini at December 01, 2017 07:18 AM

November 30, 2017

gvSIG Team

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

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

by Mario at November 30, 2017 08:28 AM

deegree

test-nov-17

test-nov-17

by Arie Kraak (arie.kraak@idgis.nl) at November 30, 2017 07:22 AM

deegree

test-2

test-2

by Arie Kraak (arie.kraak@idgis.nl) at November 30, 2017 07:18 AM

November 29, 2017

Jo Cook

Portable GIS accepted as OSGeo Community Project

I&rsquo;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.

November 29, 2017 09:22 AM

November 28, 2017

gvSIG Team

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

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

by Alvaro at November 28, 2017 02:48 PM

November 27, 2017

Paul Ramsey

Nested Loop Join with FDW

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
CREATE SERVER test
FOREIGN DATA WRAPPER postgres_fdw
OPTIONS (
host '127.0.0.1',
dbname 'test',
extensions 'postgis'
);

CREATE USER MAPPING FOR pramsey
SERVER test
OPTIONS (user 'pramsey', password '');

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

CREATE FOREIGN TABLE va_2013_fdw
(
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
OPTIONS (
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.

Update

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

November 27, 2017 04:00 PM

OSGeo News

Call for Volunteers for Geodata Committee

by jsanz at November 27, 2017 03:38 PM

gvSIG Team

SIG aplicado a Gestión Municipal: Módulo 14 ‘Georreferenciación de imágenes’

Ya está disponible el módulo nº 14 del curso de SIG para Gestión Municipal, donde veremos cómo georreferenciar una imagen.

En ocasiones se puede disponer en un ayuntamiento de una imagen que no esté georrefenciada. También se puede tener un plano antiguo en papel, cuyos datos necesitamos para poder, por ejemplo, realizar algún análisis sobre nuestra aplicación de escritorio, como puede ser delimitar con detalle el término municipal. Ese plano en papel se podría escanear de forma que tendríamos una imagen en nuestro disco duro.

Dichas imágenes no tienen coordenadas, por lo que si las insertásemos en una Vista estarían en las coordenadas ‘0,0’, y no se superpondrían con nuestra cartografía georreferenciada.


Para georreferenciar dicha imagen necesitaremos cartografía de referencia que esté georreferenciada, de forma que indiquemos los puntos de apoyo en dicha cartografía, y su correspondiente en la imagen a georreferenciar. También se podría realizar si tenemos una tabla de coordenadas de los puntos de apoyo georreferenciados.

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, spanish, training Tagged: ayuntamientos, georreferenciación, gestión municipal, imágenes

by Mario at November 27, 2017 08:34 AM

November 25, 2017

Cameron Shorter

Tackling the Open Source dilemma




Here is the dilemma that you and your boss are faced with when considering Open Source:
Looked at through the lens of traditional management, Open Source collaboration is time consuming, imprecise, unreliable, hard to manage, rarely addresses short term objectives, and hard to quantify in a business case. And yet, in a digital economy, collaborative communities regularly out-innovate and out-compete closed or centrally controlled initiatives.
So how do we justify following a more effective, sustainable, open and equitable strategy?



This is what we will be covering today:
  • The digital economy,
  • Complexity,
  • Trust,
  • Innovation and Obsolescence,
  • and what leads to Success or Failure.


The first thing to recognise is that the Digital Economy has fundamentally changed the rules of business. Ignore this at your own peril.
Zero Duplication Costs and the Connectivity of the Internet has led to Wicked Complexity, Rapid Innovation, and on the flip side, Rapid Obsolescence.

Let’s start by talking about Complexity.
Software systems have become huge, interdependent and complex.
It is no longer possible for one person to understand all of a system’s intricacies.
So decision makers need to assume, deduce and trust information provided by others.
It means that sourcing trustworthy advice has become a key criteria for success in the digital economy.
So what how do we assess trustworthiness?

It turns out we all make use of a variant of this trustworthiness equation.

  • We trust people who are credible and who have have track record of providing reliable advice in the past.
  • We trust people who are open and transparent.
  • We trust ourselves, our family, our friends, because they look out for us, and we look out for them.
  • We are suspicious of people who stand to gain from advice they give us.

We also trust processes.
  • We trust that the democratic process leads to fair governance and management of resources.
  • We trust that the scientific method leads to reliable research that we should act upon. I believe that climate change is happening and that we need to do something about it, despite the weather seeming pretty similar to me over the last 40 years.
  • We trust that the “survival of the fittest” competition of market economies leads to better products.

But we also know that all processes can be gamed.
And the more complex a system, the easier it is to bamboozle people and game the system.

Part of the reason Open Source has been so successful is that it’s characteristics lead to trustworthiness.
These characteristics include:
  • Freedom,
  • Altruism,
  • Openness,
  • Meritocracy,
  • and Do-ocracy.
Let’s break these down one by one.

Open source, by definition, provides the receivers of the software with the four freedoms:
  1. Freedom to use the software unencumbered; 
  2. Freedom to study the source code and find out how it works; 
  3. Freedom to modify, retask, and improve the code;
  4. Freedom to copy and share with others.
Providing such a valuable gift, which provides significantly more value to the receiver than to the giver, increases the trustworthiness of the giver.

Additionally, openness and transparency is almost universally applied to all Open Source development practices and communication.
  • Conversations are public; Everyone has the opportunity to join and contribute; 
  • Decisions are made openly; 
  • Issues and limitations are published and shared.
Being transparent and open to public critique reduces the potential for hidden agendas and creates trustworthiness.

In a meritocracy, the best ideas win, no matter who suggests them. It is the sign of an egalitarian community rather than a hierarchical or dysfunctional one.


With a do-ocracy the person motivated to do the work decides what gets done. In complex systems, the person closest to the problem will usually be best qualified to make the technical decisions.



A key strategy for managing complexity is to divide large systems into modular subsystems.
Using modular architectures, connected by open standards:
  • Reduces system complexity,
  • Enables interoperability,
  • Which reduces technical risk,
  • And facilitates sustained innovation.
It means you can improve one module, without impacting the rest of your system. This helps with maintenance, innovation, and keeping up with latest technologies.

Collaboration is a key focus of both Open Source and Open Standards narratives. Hence, successful Open Source applications usually provide exemplary support for standards.

By comparison, from the perspective of dominant proprietary companies, it makes business sense to apply vendor lock-in tactics, making cross-vendor integration difficult. Adoption of Open Standards threatens vendor lock-in tactics, and consequently dominant vendors are often reluctant and half-hearted in their support of Open Standards.

In the digital economy there are two dominant business models which work well.
Either:
  • You solve a generic problem by supplying an awesome "category killer" application which you distribute to the world; 
  • Or you provide personalised, specialised or localised services, typically using category killer applications.
There is a natural symbiotic relationship between the two.
If you are solving a generic problem, by yourself, you will be out-innovated!
There are simply more developers in the rest of the world than you can ever muster within your team.

Because software is so time consuming to create and so easy to copy, it is excessively prone to monopolies.
This holds true for both proprietary and open source products. A product that becomes a little better than its competitors will attracts users, developers and sponsors, which in turn allows that product to grow and improve quickly, allowing it to attract more users.
This highly sensitive, positive feedback leads to successful software projects becoming “category killers”.

This means that most of the software you own will be out-innovated within a year or two.
Your software is not an asset, it is a liability needing to be updated, maintained, and integrated with other systems. It is technical debt, and you should try to own as little of it as possible.
The question is: should you select Proprietary or Open Source as the alternative?


Openness democratises wealth and power, which is a good thing for all of us, even those with wealth and power.
Open Source and Proprietary business models differ in how their realised value is shared.
Open source licenses are structured such that multiple companies can use and support the same open source product, so the market self corrects any tendencies toward price-fixing.
Effectively, Open Licenses democratise information.
It enables everyone to share in the value created by technology.
As software markets mature, and components become generic commodity items, the collaborative practices of Open Source moves to becoming the most effective means for creating and managing functionality.
Collaboration trumps Competition for commodity items!

By comparison, the ruthless competition between proprietary companies results in “winner takes all” scenarios. Many of the richest people in the world are self made software entrepreneurs.
Jeff Bezos who started Amazon has recently been ranked as the richest man in the world, stealing the spot from Bill Gates who started Microsoft. Mark Zuckerberg who started Facebook comes in at number 5. Jack Dangermond from ESRI is down at #603, with a mere $3.2 billion dollars to his name.

Lets explain this another way, following the money trail. Proprietary business model favours multi-nationals who establish themselves in big markets such as in the US or Europe.
From our Australian software spend, a small commission is provided to the local sales guy and systems integrator, and the rest is funnelled into the multinational who often farms development into cheap development centres.


Open Source on the other hand favours local business. The software is free, so the majority of money spent is on support and integration type services, which is typically applied locally, keeping money and expertise local.



Let’s look into the characteristics which make projects successful or not.
Open Source projects are highly susceptible to being Loved to Death. This happens when a project attracts an engaging user base without attracting matching contributions. Volunteer become overwhelmed leaving insufficient capacity to cover essential business-as-usual tasks.
Don’t to overload the community you depend upon. It is both bad karma and bad business.
Successful projects have worked out how to either:
  • Politely say NO to “gifts” of unsupported extra code and excessive requests for help;
  • Or how to help uses become contributors, either in kind, or financially.
If your organisation isn’t ready to act as a good community citizen, actively caring about the community’s long term sustainability, then you will probably have a disappointing Open Source experience. You will make self-centred, short term decisions, and you won’t get the support you need when you most need it. You will likely be better off with proprietary software. (And the community would be better off without you.)
The success criteria for Open Source projects was researched by Professor Charlie Schweik who studied thousands of projects. As you can see from this graph, most projects are abandoned. Of the remainder, most projects don’t attract more than one or two staff, and very few attract a large community.
Viewed another way, you can see that:
  • 4/5 projects are abandoned.
  • 1 in 7 remain with just 1 or 2 developers.
  • Only 1 in 100 manage to attract 10 core contributors.
On this graph we’ve drawn in the success rate for projects, and you can see that as you attract developers, your chance of long term success increases dramatically.
This is showing ruthless Darwinian evolution at work. Only projects of exceptional quality attract sustained growth and large communities. They fit in the “magic unicorn” category.



So how do you find these magic unicorn projects?
Charlie’s team distilled further insights from their research. They found that successful projects typically possess:
  • A clearly defined vision;
  • Clear utility;
  • And leaders who lead by doing.
Then projects which manage to attract a medium to large team tend to:
  • Provide fine scaled task granularity, making it easier for people to contribute;
  • And often have attracted financial backing.


To get insights into project health, you can look at Open Hub metrics.  This slide is from the OSGeo-Live project and shows the status of leading Desktop GIS applications.
And for QGIS you can see that it has a very healthy community with over 100 active contributors. 
Another strong indicator of a project’s success is whether it has completed an Open Source Foundation’s incubation process.
  • Quality
  • Openness
  • Community Health
  • Maturity
  • Sustainability


Bringing this all together into a concise elevator pitch for your boss:
  • The Digital Economy leads to High Complexity, Rapid Innovation and Rapid Obsolescence. Get with the program, or become obsolete.
  • Increased complexity requires us to trust more. So increase the value you place on trustworthiness, openness and transparency. 
  • Software is technical debt. It needs significant maintenance to remain current. Own as little of it as possible.
  • Collaboration and openness fast tracks innovation.
  • For the long term play, Collaboration trumps Competition. If you are solving a generic problem, by yourself, you will be out innovated! Value, recognise, select and apply collaborative practices.
  • Don’t be naive, most Open Source projects fail. Learn how to pick winners.
  • Openness and Collaboration leads to the democratisation of wealth and power. Learn how to be part of the community - it makes good business sense.



  • Questions and comments are welcomed.
  • Slide deck is available online.
  • An earlier version of these slides was presented at QGIS Conference in Sydney, Australia, November 2017.
  • The text behind these slides, by Cameron Shorter, is licensed under a Creative Commons Attribution 4.0 International License
  • For those of you who already know me, I should point out that I’ve changed jobs. I now have a new enigmatic title of “Technology Demystifier” in the Information Experience team at Learnosity. And while it’s a shift away from my Open Source Geospatial roots, I plan to continue to be actively involved in Open Source.
  • If this presentation was of interest to you, then please let me know (use comments below or email address on the slide above). I enjoy hearing from people who share similar interests, or are facing similar challenges, and ideas people have on related topics. 
Related presentations:


by Cameron Shorter (noreply@blogger.com) at November 25, 2017 10:55 PM

Free and Open Source GIS Ramblings

Intro to QGIS3 3D view with Viennese building data

In this post, I want to show how to visualize building block data published by the city of Vienna in 3D using QGIS. This data is interesting due to its level of detail. For example, here you can see the Albertina landmark in the center of Vienna:

an this is the corresponding 3D visualization, including flying roof:

To enable 3D view in QGIS 2.99 (soon to be released as QGIS 3), go to View | New 3D Map View.

Viennese building data (https://www.data.gv.at/katalog/dataset/76c2e577-268f-4a93-bccd-7d5b43b14efd) is provided as Shapefiles. (Saber Razmjooei recently published a similar post using data from New York City in ESRI Multipatch format.) You can download a copy of the Shapefile and a DEM for the same area from my dropbox.  The Shapefile contains the following relevant attributes for 3D visualization

  • O_KOTE: absolute building height measured to the roof gutter(?) (“absolute Gebäudehöhe der Dachtraufe”)
  • U_KOTE: absolute height of the lower edge of the building block if floating above ground (“absolute Überbauungshöhe unten”)
  • HOEHE_DGM: absolute height of the terrain (“absolute Geländehöhe”)
  • T_KOTE: lowest point of the terrain for the given building block (“tiefster Punkt des Geländes auf den Kanten der Gebäudeteilfläche”)

To style the 3D view in QGIS 3, I set height to “U_KOTE” and extrusion to

O_KOTE-coalesce(U_KOTE,0)

both with a default value of 0 which is used if the field or expression is NULL:

The altitude clamping setting defines how height values are interpreted. Absolute clamping is perfect for the Viennese data since all height values are provided as absolute measures from 0. Other options are “relative” and “terrain” which add given elevation values to the underlying terrain elevation. According to the source of qgs3dutils:

  AltClampAbsolute,   //!< Z_final = z_geometry
  AltClampRelative,   //!< Z_final = z_terrain + z_geometry
  AltClampTerrain,    //!< Z_final = z_terrain

The gray colored polygon style shown in the map view on the top creates the illusion of shadows in the 3D view:

 

Beyond that, this example also features elevation model data which can be configured in the 3D View panel. I found it helpful to increase the terrain tile resolution (for example to 256 px) in order to get more detailed terrain renderings:

Overall, the results look pretty good. There are just a few small glitches in the rendering, as well as in the data. For example, the kiosik in front of Albertina which you can also see in the StreetView image, is lacking height information and therefore we can only see it’s “shadow” in the 3D rendering.

So far, I found 3D rendering performance very good. It works great on my PC with Nvidia graphics card. On my notebook with Intel Iris graphics, I’m unfortunately still experiencing crashes which I hope will be resolved in the future.


by underdark at November 25, 2017 12:56 PM

November 24, 2017

gvSIG Team

Días universitarios de gvSIG en 2018

Empezamos este año 2017 celebrando eventos de un día en diversas universidades. En 2018 queremos extender esta práctica y dar a conocer gvSIG cada vez más en el mundo académico.

Este tipo de jornadas consisten en una serie de actividades a celebrar en 1 día (o medio día, según el caso). Ponencias introductorias a la suite gvSIG y exposición de casos de uso que puedan interesar a la audiencia, complementados con talleres para usuarios y desarrolladores, tanto de uso general como aplicados a distintas temáticas (geoestadística, urbanismo, criminología,…). En algunos casos el público asistente ha sido meramente universitario y en otros se ha abierto la opción de asistencia de público en general. Las opciones son muchas y se adaptan a cada uno de estos ‘Días universitarios gvSIG’.

Ya tenemos confirmadas algunas universidades que nos han comunicado que quieren su día gvSIG en 2018 (por supuesto iremos publicitando estos eventos para darlos a conocer al máximo posible).

Si te gustaría que tu universidad tuviera su día gvSIG…ponte en contacto con nosotros: info@gvsig.com


Filed under: spanish Tagged: universidades

by Alvaro at November 24, 2017 10:39 AM

November 23, 2017

GIScussions

Dr Jekyll and Mr Hyde consider a new Geospatial Commission

Dr Jekyll & Mr Hyde 1931 via Wikimedia

It’s November, it’s budget time, it’s that moment when geo-geeks and OpenData enthusiasts scour the hundreds of pages of budget pronouncements searching for phrases like “Ordnance Survey”, “Land Registry” and “Open Data”. It’s amazing how often we have got a mention in the budget or spending review publications over the past decade, you’d think that with all of the challenges that the country has faced since the crash of 2008 that the Chancellor would have more important things on his mind than geospatial data (don’t get me started on my list of omissions from the budget).

Yesterday, the Chancellor gave his “make or break” budget speech and within minutes of the budget report being published twitter was humming with discussion about geospatial open data, to be honest humming might be a bit of an exaggeration but  quite a few geo-geeks were onto this announcement:

“4.14 Geospatial data – The UK has some of the best geospatial data in the world, and much of it is held by public bodies. The potential economic value of this data is huge. To maximise the growth of the digital economy and consolidate the UK’s position as the best place to start and grow a digital business, the government will establish a new Geospatial Commission to provide strategic oversight to the various public bodies who hold this data. To further boost the digital economy, the government will work with the Ordnance Survey (OS) and the new Commission, by May 2018, to establish how to open up freely the OS MasterMap data to UK-based small businesses in particular, under an Open Government Licence or through an alternative mechanism, while maintaining the OS’s strategic strengths. The Budget provides £40 million a year over the next two years to support this work.”

Wow, the buzz words are rushing at you at 100mph! I’ve highlighted a few in red above. Well this is fantastic news, or is it? I find myself with very mixed views on this announcement (as usual with budget announcements there is very little detail so we are left to guess what is actually intended) hence the Jekyll and Hyde analogy – this could be great but on the other hand …

Some Mr Hyde-ish pedantry

9 years after the Free Our Data campaign successfully made the case for OpenData leading to Gordon Brown’s Damascene moment when he met Sir Tim Berners-Lee we are about to be able to access MasterMap as OpenData (or are we? more on that in a minute). So what’s not to like about opening up MasterMap? If that is the outcome, and MasterMap becomes some form of OpenData (inevitably there will be conditions that will preclude certain usage and activities) then that has to be a good step forward. However, the devil is in the detail and when I read that budget statement I cannot avoid reading between the lines and wondering what they really mean or whether anyone in government really understands what they are buying into. Call me a pedant if you wish.

“the best geospatial data in the world”

A little bit of exaggeration or evidence of the persuasive powers of OS marketing and the influence of their leadership? I think it is fair to claim that we have some of the most detailed and up to date large scale mapping compared to any other country but does that make it the “best in the world”? For many, data that provides global coverage may be more useful/desirable than highly detailed data for one country (of course the two are not mutually exclusive).

“maximise the growth of the digital economy and consolidate the UK’s position as the best place to start and grow a digital business”

I’d suggest that for many, if not most, digital businesses success is dependent on being able to scale globally, a dependence on a highly detailed geospatial dataset that cannot be replicated across multiple geographies may be a hindrance rather than an advantage. I know of at least one ‘hot’ startup that started out thinking it would use MasterMap as a key data resource in its service and has now reconsidered as it prioritised geographic expansion over greater detail.

Call me an obsessive Remainer if you wish, but I reckon that access to talented staff from across Europe and further afield will be a bigger factor in making the UK the best place to start and grow a digital business than access to our national map data.

“The potential economic value of this data is huge”

Gosh we have heard this one so many times in the past but somehow it always remains “potential”. The evidence base remains limited (see this from 5 years ago and this from earlier this year), the same few companies in transport and health are repeatedly cited as case studies although they don’t seem to be generating much growth in revenues or employment let alone profits that can be shared with wider society through taxes. A year or so after the first release of OS OpenData in 2010, the OS commissioned a study of the benefits, that study was never published, since then there has been an NAO report and a study by the ODI.

Maybe the evidence does exist but it just needs publishing, maybe there is reason to believe that it will exist in the future and we just need to understand the assumptions and modelling but surely after nearly 8 years it is time to move on from an act of faith in the economic benefits of Open Data to stimulate innovation.

Of course there are other immensley important benefits arising from Open Data e.g. transparency, accountability and societal well being which may be more important than the financial benefits. But we are being told that government are about to invest £80m over 2 years “to support this work” that amount of money represents a 10% increase to the funding of 150 primary schools or … I think it is reasonable to expect some transparency from government on the basis that it is choosing to invest taxpayers money in geospatial data in preference to education, health, care or welfare budgets.

“establish how to open up freely the OS MasterMap data to UK-based small businesses in particular”

Well this will be fun, I guess a group of consultants and OS management could spend a fair chunk of that £40m working out how to define a small business, how to restrict the benefit to UK based companies, what to do when a small business grows, what to do when a small UK business gets acquired by an larger non UK business, how to prevent a non UK business setting up a UK subsidiary to gain access to the “hugely valuable” “best geospatial data in the world”.

The phrase “under an Open Government Licence or through an alternative mechanism” suggests that this may not be fully Open Data and that there will be constraints on what users can do with the data which will prompt a not unjustified howl from Open Data purists who aspire that data should be free to use, re-use and combine with other data. Maybe, but I doubt that would be sustainable while larger users are expected to pay millions for annual licenses for MasterMap.

Over to Dr Jekyll

Enough of my Mr Hyde-ish doubts, let’s pause to look at some of the early comment on the announcement, perhaps others have a better informed and more positive outlook.

A good place to start would be the former CTO of the OS, my friend Ed Parsons (now Geospatial Technologist at Google)

Charles Arthur the founder of of the Guardian’s Free Our Data campaign and a long term advocate of Open Data celebrated with

Michael Cross, the other founder of Free Our Data wrote

While Ed Dowding said

And finally this from Civil Service World

Inevitably addresses had to spoil the party a little bit, Bob Barr, who has advocated an open address register for more than a decade, poured some cold water on the jubiliation

The Big 40

By this stage you may think that I should pay more attention to Dr Jekyll, if all these people think that the announcement is good news why am I still hesitant? I’m baffled by the talk of £80m over 2 years, that’s an enormous amount of money and based on any reading of OS accounts significantly more than the value of MasterMap sales to small businesses. So what is the rest of the money for?

My skepticism is fuelled by the knowledge that when OS negotiated £20m p.a. for the initial OpenData release they bundled in a number of products whose sales were relatively minor and in several cases were in decline. It is highly debatable that government got a good deal and the lack of evidence of usage only adds to that doubt. Rumour has it that the £20m was substantially reduced during a subsequent review.

Perhaps there is a big demand for MasterMap that will be satisfied by some form of OGL availability, I hope there is more evidence for the demand than there has been for the initial data releases from the OS. In the recent OS Annual Report and Accounts they report an average of 290 downloads per day (some products are chunked so that you need to download several chunks to get national cover). The risk for government is that smaller commercial users of MasterMap will be delighted with the price reduction or elimination that they receive but that the latest colossal estimate of £11bn of benefit will not be realised, but hey when you can throw out numbers like £11bn a cost £40m sounds like a tiny price to pay.

The Geospatial Commission

“Get thee gone Mr Hyde!” I say.

Maybe there is more to this new Geospatial Commission than just funding OS to make MasterMap open/free to small businesses for 2 years. The clue might be buried in the announcement “a new Geospatial Commission to provide strategic oversight to the various public bodies who hold this data” and a bit more info came out with this press release from the Cabinet Office and the Treasury 

“The new Geospatial Commission, supported by £40 million of new funding in each of the next two years, will drive the move to use this data more productively – unlocking up to £11 billion of extra value for the economy every year.

The new Commission will draw together HM Land Registry, the Ordnance Survey, the British Geological Survey, the Valuation Office Agency, the UK Hydrographic Office and the Coal Authority with a view to:

  • improving the access to, links between, and quality of their data
  • looking at making more geospatial data available for free and without restriction
  • setting regulation and policy in relation to geospatial data created by the public sector
  • holding individual bodies to account for delivery against the geospatial strategy
  • providing strategic oversight and direction across Whitehall and public bodies who operate in this area”

Perhaps the Geospatial Commission heralds a merger of the Land Registry and Ordnance Survey into a body similar to the cadastral bodies in several other European countries, this opens up the potential for a complete release of geospatial Open Data funded by a tiny levy on property transactions which is what Bob Barr has been suggesting for ages.

“That would be a fantastic outcome for Open Data advocates, transparency campaigners, innovative businesses and the public sector purse” says Dr Jekyll to a sulking Mr Hyde.

Groundhog Day

This really does feel like a Groundhog Day, we keep having discussions about Ordnance Survey business models, open data, sustainability and innovation. 2 years ago I wrote to the then Chancellor of the Exchequer, George Osborne, suggesting that plans to “develop options to bring private capital into the Ordnance Survey before 2020” might not be a great idea. If you can bear it you might want to re-read what I said at the time because it feels equally applicable today as advice to Mr Hammond and his new Geospatial Commission.

“Why not just fund this team to carry on surveying etc? You currently pay the OS £80m for them to do this through a series of agreements with government, that should be more than enough to cover the costs of surveying, data management etc. You could probably save at least £10m or £20m or even more once they stopped doing things that weren’t really essential. You could make the raw data available to government and the private sector for free and without restriction potentially unlocking a chunk of the billions that people think will come from OpenData”

Removing sales, marketing, licensing, legal, other commercial staff, consultants, cartographic functions, printed map production and sales would probably result in operational costs lower than government’s current £88m expenditure with OS. We could have free and open geospatial data and potentially even reduce the tax payers spend on that data! Perfect for people (or governments) who like having cake and who like eating cake. If there really is £11bn of extra value to be released for the economy from open geospatial data then most of it should still be there without the commercial paraphernalia.

2 years on from George Osborne’s spending review we have heard little more about introducing private capital into OS and the proposed privatisation of Land Registry has been canned.

Putting on my Mr Hyde hat, I wonder what if anything the Geospatial Commission will achieve over the next 2 years. But switching to my Dr Jekyll hat, if the Geospatial Commission used its £80m of funding to merge OS with LR we could end up with free open geospatial data, reduced costs to taxpayers and we might find out whether there really is this huge potential to be unleashed.

Since the budget, I have been chatting with someone who has had close operational links with OS, who remarked:

“Basically the OS operates as if it was a competing private company but it’s like Network Rail, the Met Office & the Hydrographic Office, it’s a tax payer funded monopoly … 80% or more of its income is from the taxpayer STILL. So after 20 years, the growth model has failed. Time to Reboot for the 21st Century

I’m not sure about the 80% but otherwise I think this sums up where we are and why we need a rethink.

A touch of irony

Regular readers of this blog will know that there is usually an image at the beginning of each post. Sometimes the connection between the content and the image is quite tenuous to say the least but on this occasion I thought I would try to find a nice MasterMap image to start the post. It isn’t easy to find Creative Commons images of MasterMap so I thought I would tweet the OS team to ask for one. Ed Parsons pointed out the irony of that!

Unfortunately a day later I hadn’t received a reply from anyone on the OS social media team so I went looking for an image idea to start the post and along came Dr Jekyll and Mr Hyde who represent my split personality on this topic – Dr Jekyll loves the idea of more open data, Mr Hyde wonders whether we are wasting a lot of taxpayers money

 

by Steven at November 23, 2017 10:34 PM

gvSIG Team

SIG aplicado a Gestión Municipal: Módulo 13 ‘Mapas’

Ya está disponible el módulo nº 13 del curso de SIG para Gestión Municipal, donde mostraremos cómo crear mapas con la cartografía que tenemos en nuestras vistas.

El mapa será el documento que nosotros podremos imprimir, o exportar a PDF o a PostScript, y en el que insertaremos las Vistas que hemos creado en nuestro proyecto.

En él podremos insertar todo tipo de elementos, como textos, norte, escala, leyenda, imágenes o logos, cajetines, gráficas, rectángulos, líneas…

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, spanish, training Tagged: ayuntamientos, gestión municipal, layout, mapa, pdf, Salida gráfica

by Mario at November 23, 2017 04:29 PM

November 22, 2017

OSGeo News

A new gvSIG Mobile is already available. The open source mobile GIS of the Suite gvSIG.

by jsanz at November 22, 2017 03:48 PM

Jackie Ng

FDO road test: SQL Server 2017 on Linux

You can consider this post as the 2017 edition of this post.

So for some background. There's been several annoyances I've been personally experiencing with the SQL Server FDO provider that have given me sufficient motivation to fix the problem right at the source (code). However, before I can go down that road, I needed to set up a local dev installation of SQL Server as my dev environment is more geared towards MapGuide than individual FDO providers.

But just like my previous adventure with the King Oracle FDO provider, I didn't want to have to actually find/download a SQL Server installer and proceed to pollute my dev environment with a whole assortment of junk and bloat. We now live in the era of docker containers! Spinning up a SQL Server environment should be a docker pull away and when I no longer need the environment, I can cleanly blow it away without leaving lots of junk behind.

And it just so happens that with the latest release of SQL Server 2017, not only is running it inside a docker container a first-class user story, it is also the first release of SQL Server that natively runs on Linux.

So through the exercise of spinning up a SQL Server 2017 linux container we can kill multiple birds with one stone:

  • We'll know if MapGuide/FDO in its current form can work with SQL Server 2017
  • We'll also know how well it works with the Linux version of SQL Server (given its feature set is not at parity with the equivalent Windows version)
  • If MapGuide/FDO works, we'd then have a SQL Server environment ready to go which can be spun up and torn down on demand to then start fixing various problems with the FDO provider.

Spinning up the SQL Server 2017 linux docker container

This was easy because Microsoft provides an official docker image. So it was a case of just pulling down the docker image and adjusting some environment parameters to use a custom SQL Server sa login when we go to docker run the container and also define port mappings so we can connect to this container from the docker host OS.

The FDO Toolbox bootstrapping test

This was an easy way to determine if the SQL Server FDO provider works with SQL Server 2017. FDO Toolbox has the ability to:
  1. Create a SQL Server data store
  2. Bulk Copy spatial data into it
  3. Query/Preview data from it
If we can do all 3 things above in FDO Toolbox against the freshly spun up SQL Server 2017 linux container, that's a very good sign that everything works.

Creating the FDO data store

FDO Toolbox has a specialized UI for creating SQL Server data stores that is accessible by right-clicking the FDO Data Sources node and choosing Create Data Store - Create SQL Server


This gives us the UI to set up a new SQL Server data store


The first real test is to see if the FDO provider can connect to our SQL Server container, which is a case of filling in all the required connection properties and clicking the Test button, which gives us:


So far so good. Now that we know the FDO provider can connect to the container, we can fill out the data store parameters and click OK to create the data store, which gave us another good sign:


Now just to be sure that the FDO provider did actually create the database, I connected to this SQL Server instance through alternative tools (such as the new SQL Operations Studio) and we can see that the database is indeed there.


So now we can bulk copy some spatial data into it, which will be a nice solid verification that the feature and schema manipulation functionality of the FDO provider work in SQL Server 2017.

So I set up a bulk copy using a whole bunch of test SHP files. A few moments later, we got another positive sign:


Again, for verification we can look at this database in a different tool and can see that the FDO provider correctly created the database tables.


And that data was actually being copied in


Just as an aside: SQL Operations Studio doesn't do spatial data previews like its big brother SQL Server Management Studio.

A shame really. Oh well, at least we can do that in FDO Toolbox :)


Which is also confirmation that FDO is getting the geometry data out of our SQL Server 2017 linux container without any problems.

So based on all these findings, I feel comfortable in saying that FDO (and applications using it like MapGuide) works just fine with SQL Server 2017, especially its Linux version.

Now to deal with these actual annoyances in the FDO provider itself ...

by Jackie Ng (noreply@blogger.com) at November 22, 2017 03:16 PM

Jackie Ng

An introduction to MgTileSeeder

I previously said I'd cover this tool in a future post, and that future is now.

MgTileSeeder (introduced as a standalone companion release to MapGuide Maestro 6.0m8) is a new command-line tile seeding application that is the successor to the current MgCooker tile seeder.

This tool is the offspring of an original thought experiment about how one could possibly build a multi-threaded tile seeder using 2017-era .net libraries and tools. It turns out the actual implementation didn't differ that much from my hypothetical code sample from the original post!

But besides being a ground-up rewrite, MgTileSeeder has the following unique features over MgCooker:

  • If your MapGuide Server is 2.6 or newer, we will use CREATERUNTIMEMAP to automatically infer the required meters-per-unit value that is critical in determining how many tiles we need to actually seed.
  • MgTileSeeder is a cross-platform and self-contained .net core application taking advantage of the newly netstandard-ized Maestro API.
  • More importantly, MgTileSeeder finally supports seeding of XYZ tilesets. In fact, the way this support has been designed, you can use MgTileSeeder as a generic tile cache seeder for any XYZ tileset, not just ones served by MapGuide itself.
Seeding standard tiled maps

The minimal command to start seeding a tiled map is simply:

MgTileSeeder mapguide -m --map

Here's an example MgTileSeeder invocation to seed a tile set

MgTileSeeder mapguide -m http://localhost/mapguide/mapagent/mapagent.fcgi --map Library://Samples/Sheboygan/TileSets/Sheboygan.TileSetDefinition

This will use CREATERUNTIMEMAP to auto-infer the required meters-per-unit (for tile sets, we make a temporary Map Definition that links to the tile set and run CREATERUNTIMEMAP against that) and then proceeds to display a running progress that updates every second:


There are other options available, such as:
  • Restricting tile seeding to a specific extent
  • Restricting tile seeding to specific base layer groups
  • Manually passing in the meters-per-unit value

Seeding XYZ tile sets

Seeding XYZ tile sets uses a completely different set of parameters. The minimal command to seed an XYZ tile set is:

MgTileSeeder xyz --url --minx --miny --maxx --maxy

An example of tiling a XYZ tile set (eg. Library://Samples/Sheboygan/TileSets/SheboyganXYZ.TileSetDefinition) in MapGuide would look like this:

MgTileSeeder xyz --url "http://localhost/mapguide/mapagent/mapagent.fcgi?OPERATION=GETTILEIMAGE&VERSION=1.2.0&CLIENTAGENT=OpenLayers&USERNAME=Anonymous&MAPDEFINITION=Library://Samples/Sheboygan/TileSets/SheboyganXYZ.TileSetDefinition&BASEMAPLAYERGROUPNAME=Base+Layer+Group&TILECOL={y}&TILEROW={x}&SCALEINDEX={z}" --minx -87.7978 --miny 43.6868 --maxx -87.6645 --maxy 43.8037

Unlike the standard tiling mode you are required to define the bounds (in lat/long) of the area you wish to seed. Also you can see here that the XYZ tiling mode accepts any arbitrary URL that has {x}, {y} and {z} placeholders. This means you can use MgTileSeeder for tiling any XYZ tile set (eg. Your own custom OpenStreetMap tile set), not just ones served by MapGuide. You just need to make sure your URL provides the required XYZ placeholders.



And that concludes our introduction to the MgTileSeeder tool.

Happy tiling!


by Jackie Ng (noreply@blogger.com) at November 22, 2017 03:13 PM

Free and Open Source GIS Ramblings

Movement data in GIS #11: FOSS4G2017 talk recordings

Many of the topics I’ve covered in recent “Movement data in GIS” posts, have also been discussed at this year’s FOSS4G. Here’s a list of videos for you to learn more about the OGC Moving Features standard, modelling AIS data with FOSS, and more:

1. Introduction to the OGC Moving Features standard presented by Kyoung-Sook Kim from the Artificial Intelligence Research Center, Japan:

Another Perspective View of Cesium for OGC Moving Features from FOSS4G Boston 2017 on Vimeo.

2. Modeling AIS data using GDAL & PostGIS presented by Morten Aronsen from the Norwegian Defence Research Establishment:

Density mapping of ship traffic using FOSS4G in C# .NET from FOSS4G Boston 2017 on Vimeo.

3. 3D visualization of movement data from videos presented by Anna Petrasova from the Center for Geospatial Analysis, North Carolina State University:

Visualization and analysis of active transportation patterns derived from public webcams from FOSS4G Boston 2017 on Vimeo.

There are also a ton of Docker presentations on the FOSS4G2017 Vimeo channel, if you liked “Docker basics with Geodocker GeoServer”.


Read more:


by underdark at November 22, 2017 12:08 PM

gvSIG Team

The new gvSIG Mobile is already available. The open source mobile GIS of the gvSIG Suite

Excellent news for all those who need GIS applications for field data gathering. You have the new gvSIG Mobile available already, for Android devices, that you can install from Google Play’.

gvSIG Mobile is open source software, like all gvSIG Suite solutions. It’s licensed under the GNU/GPLv3 license.

The new gvSIG Mobile is based on Geopaparazzi, with more than obvious similarities, but with a different approach that will be reflected in its evolution. gvSIG Mobile was born with the aim of having a mobile GIS application for professionals and, it has different tools that facilitate its integration with the rest of the gvSIG Suite. For example, it has a data importer and exporter from/to gvSIG Online, functionality that is already used by many of the organizations that are betting on implementing their Spatial Data Infrastructures (SDI) with this platform. They are able to carry out census or inventories, update or audit information and all of that integrated with the SDI. In the same way the next version of gvSIG Desktop brings among its (numerous) improvements a plugin that will allow data dumping between both applications. And this is just the beginning …

Of course, gvSIG Mobile can be used independently of the rest of the gvSIG Suite components. In an individual level, it is a fantastic application for field data gathering. It includes a lot of functionalities, but it is very easy of use. You can gather field data, edit existing data, attach images, notes or bookmarks to geolocated elements, etc. Without forgetting the ability to have forms that make gathering easier.

In the coming months we will be complementing the application information currently available with user manuals in several languages, video-tutorials, etc. In addition, for this first version, until we have the specific gvSIG Mobile documentation available, you can also consult all the material available about Geopaparazzi, totally applicable to the use of gvSIG Mobile. And, of course, you can use the user mailing lists to ask about any doubt or problem that you have with the mobile GIS that is going to become your favorite one.

For those interested in the development part, the project can be found here: https://github.com/gvSIGAssociation/gvsig-mobile

Finally, from the gvSIG Association we want to thank two of our companies, HydroloGIS and Scolab, for the work done so that today all of us have the possibility to use gvSIG Mobile freely.

What are you waiting for to download it?

 


Filed under: development, english, gvSIG Mobile, testing Tagged: Android

by Mario at November 22, 2017 09:20 AM

gvSIG Team

El nuevo gvSIG Mobile ya disponible. El SIG móvil en software libre de la Suite gvSIG.

Una excelente noticia para todos aquellos que necesitan de aplicaciones SIG para toma de datos en campo. Ya tenéis disponible el nuevo gvSIG Mobile, disponible para dispositivos Android y que podéis instalar desde ‘Google Play’.

gvSIG Mobile es software libre, como todas las soluciones de la Suite gvSIG. Su licencia es la GNU/GPLv3.

El nuevo gvSIG Mobile está basado en Geopaparazzi, con similitudes más que evidentes, pero con un enfoque distinto que se verá reflejado en su evolución. gvSIG Mobile nace con el objetivo de disponer de una aplicación SIG móvil para profesionales y, como tal, dispone de herramientas que facilitan su integración con el resto de la Suite gvSIG. Así, por ejemplo, en gvSIG Mobile tenemos importador y exportador de datos a gvSIG Online, funcionalidad que ya utilizan las cada vez más numerosas organizaciones que están apostando por implantar sus Infraestructuras de Datos Espaciales (IDE) con esta plataforma. Poder realizar censos o inventarios, actualizar o auditar información y todo ello integrado con la IDE. Del mismo modo la próxima versión de gvSIG Desktop trae entre sus (numerosísimas) mejoras un plugin que permitirá el volcado de datos entre ambas aplicaciones. Y esto sólo es el comienzo…

Por supuesto se puede utilizar gvSIG Mobile de forma independiente al resto de componentes de la Suite gvSIG. A nivel individual es una aplicación fantástica para toma de datos en campo. Sus funcionalidades son numerosas, sin que esto reste a su facilidad de uso. Se puede realizar toma de datos en campo, editar existentes, asociar imágenes, notas, croquis a elementos geoposicionados, etc. Sin olvidar la capacidad para disponer de formularios que nos faciliten la toma de datos.

En los próximos meses iremos complementando la información actualmente disponible de la aplicación con manuales de usuario en varios idiomas, vídeo-tutoriales, etc. Para esta primera versión, además y hasta que tengamos la documentación especifica de gvSIG Mobile disponible, podéis también consultar todo el material disponible de Geopaparazzi y totalmente aplicable al uso de gvSIG Mobile. Y, por supuesto, utilizar las listas de usuarios para consultar cualquier duda o problema que tengáis con el que va a convertirse en vuestro SIG móvil favorito.

Para los interesados en la parte de desarrollo, el proyecto lo podéis encontrar aquí: https://github.com/gvSIGAssociation/gvsig-mobile

Por último, desde la Asociación gvSIG queremos agradecer a dos de nuestras empresas, HydroloGIS y Scolab, el trabajo realizado para que hoy todos tengamos la posibilidad de usar libremente gvSIG Mobile.

¿Qué estáis esperando para descargarlo?


Filed under: gvSIG Mobile, spanish Tagged: Android

by Alvaro at November 22, 2017 08:02 AM

November 21, 2017

GeoServer Team

GeoServer 2.12.1 Released

We are happy to announce the release of GeoServer 2.12.1. Downloads are available (zipwardmg and exe) along with docs and extensions.

This is a stable release recommended for production use. This release is made in conjunction with GeoTools 18.1.

Highlights of this release are featured below, for more information please see the release notes (2.12.12.12.0 | 2.12-RC1 | 2.12-beta).

New Features and Improvements

  • Moved Users/Groups/Roles REST from geofence-server (extension) to restconfig (core)

Bug Fixes

  • Copy style needs to copy content and format
  • REST API CORS support
  • YSLD ColorMap incorrectly recording a String (as shown in SLD conversion)
  • MapPreviewPage search displays wrong results on first try
  • GWC Seed Form returns blank page when seeding a layer.
  • Monitor REST API won’t return xml/json representation for request
  • Failed to resolve workspace for style messages during startup

About GeoServer 2.12 Series

Additional information on the 2.12 series:

by tbarsballe at November 21, 2017 11:43 PM

GeoTools Team

GeoTools 18.1 Release

Tuesday, November 21, 2017


GeoTools 18.1 Released

The GeoTools team is pleased to announce the release of GeoTools 18.1:
This release is also available from our Maven repository.

Thanks to everyone who took part in the monthly bug stomp, or directly making the release. This release is made in conjunction with GeoServer 2.12.1. 

This release is the current stable release and as such users and downstream projects should consider moving from older releases to this one.

Highlights from our issue tracker release-notes:
  • Add support for latest MySQL DB enhancements in jdbc-mysql module
  • Fixed [GEOT-5840] - WMTS getCapabilities fails parsing WellKnownScaleSet
For more information see this and past release notes (18.1 | 18.0 | 18-RC1).

Thanks to Boundless for allowing David Vick to make this release.

by David Vick (noreply@blogger.com) at November 21, 2017 05:41 PM