OSGeo Planet

The 4th gvSIG Festival will start in a few hours, where there will be presentations in English, Spanish and Portuguese about different projects related to gvSIG.

Registration can be done independently for each presentation.

The links for the registration are (Note: Registration for the webinars is available by clicking on their title, and they are in Spanish time, you can click on the time of every webinar to check it in your city):

Wednesday, March 27th

10:00-11:00

Soluciones gvSIG para Agricultura en la Generalitat Valenciana (Spanish) [Raquel Borjabad, D.G. de Tecnologías de la Información y las Comunicaciones. Generalitat Valenciana]

11:00-12:00

Los SIG como herramienta ​​​​​​​de realización de la justicia social (Spanish) [Alexandra Aragão, Faculdade de Direito – Universidade de Coimbra]

12:00-13:00

gvSIG como herramienta de apoyo en la cartografía y estudio de deslizamientos y caída de bloques (Spanish) [Gloria Galindo, Geoscan]

14:00-15:00

Utilização do gvSIG para identificação de áreas adequadas ​​​​​​​para instalação de usinas fotovoltaicas (Portuguese-BR) [Graciele Rediske, Universidade Federal de Santa Maria – UFSM]

16:00-17:00

gvSIG Mobile para el levantamiento de mobiliario en parques urbanos ​​​​​​​de Toluca (México) (Spanish) [Ing. en C. Sandra Lucía Hernández Zetina, Facultad de Geografía. Universidad Autónoma del Estado de México; Mtra. Alejandra González, Facultad de Geografía. Universidad Autónoma del Estado de México]

17:00-18:00

Geochicas o el empoderamiento de mujeres ​​​​​​​en el mundo Geo latinoamericano (Spanish) [Céline Jacquin, Geochicas; Selene Yang, Geochicas; Miriam González, Geochicas]

Jueves 28 de marzo

10:00-11:00

Programa Copernicus y servicio territorio ​​​​​​​de Copernicus en España (Spanish) [Ana Rita Serna Martínez, D.G Instituto Geográfico Nacional. Ministerio de Fomento]

12:00-13:00

Observatorio Ambiental Nacional, software libre para difundir datos abiertos ​​​​​​​del ambiente en Uruguay (Spanish) [Virginia Fernández, Facultad de Ciencias. Universidad de la República. Uruguay]

13:00-14:00

Geopaparazzi: state of the art of the ​​​​​​​digital field mapping application (English) [Silvia Franceschi, HydroloGIS]

14:00-15:00

Analysis of extreme events ​​​​​​​with the HortonMachine tools (English) [Silvia Franceschi, HydroloGIS]

16:00-17:00

Diez años de Enseñanza Universitaria ​​​​​​​(2009-2019) con gvSIG (Spanish) [Josefina García León, Escuela Técnica Superior de Arquitectura y Edificación. Universidad Politécnica de Cartagena]

17:00-18:00

How can I get a diverse team? (English) [María Arias de Reyna, OSGeo President]

18:00-19:00

¿Cómo puedo conseguir un equipo diverso? (Spanish) [María Arias de Reyna, Presidenta de OSGeo]

Don’t wait for the registration!

El 4º gvSIG Festival dará comienzo en unas horas, con ponencias a través de internet en inglés, español y portugués sobre diversos proyectos relacionados con gvSIG.

La inscripción es gratuita y se realiza de forma independiente para cada ponencia.

Los enlaces para las inscripciones son los siguientes (Nota: Las horas son de España peninsular, pinchando sobre la hora de cada webinar puedes comprobar la hora en tu ciudad. La inscripción se debe realizar pinchando sobre el título de cada webinar):

Miércoles 27 de marzo

10:00-11:00

Soluciones gvSIG para Agricultura en la Generalitat Valenciana (Español) [Raquel Borjabad, D.G. de Tecnologías de la Información y las Comunicaciones. Generalitat Valenciana]

11:00-12:00

Los SIG como herramienta ​​​​​​​de realización de la justicia social (Español) [Alexandra Aragão, Faculdade de Direito – Universidade de Coimbra]

12:00-13:00

gvSIG como herramienta de apoyo en la cartografía y estudio de deslizamientos y caída de bloques (Español) [Gloria Galindo, Geoscan]

14:00-15:00

Utilização do gvSIG para identificação de áreas adequadas ​​​​​​​para instalação de usinas fotovoltaicas (Portugués-BR) [Graciele Rediske, Universidade Federal de Santa Maria – UFSM]

16:00-17:00

gvSIG Mobile para el levantamiento de mobiliario en parques urbanos ​​​​​​​de Toluca (México) (Español) [Ing. en C. Sandra Lucía Hernández Zetina, Facultad de Geografía. Universidad Autónoma del Estado de México; Mtra. Alejandra González, Facultad de Geografía. Universidad Autónoma del Estado de México]

17:00-18:00

Geochicas o el empoderamiento de mujeres ​​​​​​​en el mundo Geo latinoamericano (Español) [Céline Jacquin, Geochicas; Selene Yang, Geochicas; Miriam González, Geochicas]

Jueves 28 de marzo

10:00-11:00

Programa Copernicus y servicio territorio ​​​​​​​de Copernicus en España (Español) [Ana Rita Serna Martínez, D.G Instituto Geográfico Nacional. Ministerio de Fomento]

11:00-12:00

12:00-13:00

Observatorio Ambiental Nacional, software libre para difundir datos abiertos ​​​​​​​del ambiente en Uruguay(Español) [Virginia Fernández, Facultad de Ciencias. Universidad de la República. Uruguay]

13:00-14:00

Geopaparazzi: state of the art of the ​​​​​​​digital field mapping application (Inglés) [Silvia Franceschi, HydroloGIS]

14:00-15:00

Analysis of extreme events ​​​​​​​with the HortonMachine tools (Inglés) [Silvia Franceschi, HydroloGIS]

16:00-17:00

Diez años de Enseñanza Universitaria ​​​​​​​(2009-2019) con gvSIG (Español) [Josefina García León, Escuela Técnica Superior de Arquitectura y Edificación. Universidad Politécnica de Cartagena]

17:00-18:00

How can I get a diverse team? (Inglés) [María Arias de Reyna, OSGeo President]

18:00-19:00

¿Cómo puedo conseguir un equipo diverso? (Español) [María Arias de Reyna, Presidenta de OSGeo]

¡No esperes al final para inscribirte!

TL;DR: There are some changes in PostgresSQL 12 that FDW authors might be surprised by! Super technical, not suitable for ordinary humans.

OK, so I decided to update my two favourite extension projects (pgsql-http and pgsql-ogr-fdw) yesterday to support PostgreSQL 12 (which is the version currently under development likely to be released in the fall).

Fixing up pgsql-http was pretty easy, involving just one internal function signature change.

Fixing up pgsql-ogr-fdw involved some time in the debugger wondering what had changed.

Your Slot is Empty

When processing an FDW insert/update/delete, your code is expected to take a TupleTableSlot as input and use the data in that slot to apply the insert/update/delete operation to your backend data store, whatever that may be (OGR in my case). The data lived in the tts_values array, and the null flags in tts_isnull.

In PostgreSQL 12, the slot arrives at your ExecInsert/ExecUpdate/ExecDelete callback function empty! The tts_values array is populated with Datum values of 0, yet the tts_isnull array is full of true values. There’s no data to pass back to the FDW source.

What gives?!?

Andres Freund has been slowly laying the groundwork for pluggable storage in PostgreSQL, and one of the things that work has affected is TupleTableSlot. Now when you get a slot, it might not have been fully populated yet, and that is what is happening in the FDW code.

The short-term fix is just to force the slot to populate by calling slot_getallattrs, and then go on with your usual work. That’s what I did. A more future-proof way would be to use slot_getattr and only retrieve the attributes you need (assuming you don’t just need them all).

Your VarLena might have a Short Header

Varlena types are the variable size types, like text, bytea, and varchar. Varlena types store their length and some extra information in a header. The header is potentially either 4 bytes or 1 byte long. Practically it is almost always a 4 byte header. If you call the standard VARSIZE and VARDATA macros on a varlena, the macros assume a 4 byte header.

The assumption has always held (for me), but not any more!

I found that as of PostgreSQL 12, I’m getting back varchar data with a 1-byte header! Surprise!

The fix is to stop assuming a 4-byte header. If you want the size of the varlena data area, less the header, use VARSIZE_ANY_EXHDR instead of VARSIZE() - VARHDRSZ. If you want a pointer into the data area, use VARDATA_ANY instead of VARDATA. The “any” macros first test the header type, and then apply the appropriate macro.

I have no idea what commit caused short varlena headers to make a comeback, but it was fun figuring out what the heck was going on.

My perspicacious colleague Paul Ramsey says "Postgres is having its Linux moment". There is certainly a buzz around PostgreSQL, evidenced by datapoints such as:

• DB-Engines DBMS Of The Year, for the second year running  
• Stack Overflow's second Most-Loved DBMS (behind Redis, so really the top RDBMS - more on that here)
• Hacker News trends shows it pulling way ahead of MySQL
• Matt Asay on how Postgres is hip again and why this might be (TLDR: cost and features)
• An analysis of why the time has finally come for Postgres

Reasons for this include:

• the shift from proprietary to open source as the software model of choice
• the rise of cloud-based DB platforms, where the flexibility, power and cost (free!) of Postgres makes it an obvious choice.  All the major players now have Postgres cloud offerings, including Amazon, Microsoft and Google.

And happily riding along is PostGIS, bundled with most if not all major PostgreSQL distros.  (Note how the Google blog post announcing cloud Postgres highlights a geospatial use case).  So it's an exciting time to be able to work on PostGIS at Crunchy Data.

Read on for highlights of new features, functionalities, and resources shipped with the latest release of CARTO VL.

Last Thursday around half past six in the evening. Striking many Geo-scientist found the way to the Spitalgasse in Bern. The reason was the 26th GeoBeer event taking place at ImpactHub.
GeoBeer is a quarterly meeting of people interested in geography, GIS, cartography and the latest technologies. It’s hosted every time by someone else. This time by us, OPENGIS.ch.

Right after the arriving, the organizers of GeoBeer Switzerland showed us some funny statistics about the GeoBeer participants since the very first GeoBeer event six years ago.
Marco Bernasocchi then welcomed everyone and introduced our company. We had three speakers this time. Marcus Hudritsch of the Berner Fachhochschule started by presenting the implementation of the visualization of historical buildings, that do not exist anymore in reality. But still, do in virtual reality… No sorry, it’s augmented reality. Marcus Hundritsch explained to us clearly the difference between AR and VR and presented some projects they made. Pascal Bourquin changed perspective completely by telling us about his project (La Vie en Jaune) to cover all the hiking trails of Switzerland – he logs every trail done on a map with photographs. The final speaker was Daniele Viganò from the Global Earthquake Model Foundation talking about their challenges of calculating a global model of earthquake hazard, risk and exposure.

• Marcus Hundritsch
• Daniele Viganò
• Pascale Bourquin

After such interesting talks, everybody’s tummy started roaring and the yummy apéro richestarted and of course: The drinking, talking, socializing, networking.

Bottles of the SpatiAle brewed by the OPENGIS.ch-team itself were offered as well as three more kinds of craft-beer brewed by their brewing-coach Thurtalbräu. There were a lot of interesting and funny chats, nice meet-agains and get-to-know-each-others.

Thanks for coming, everyone, and see you on the next GeoBeer!

• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 

We are pleased to announce the release of QGIS 3.6 ‘Noosa’! Noosa was the location of a local Australian developer meeting in autumn 2017.

Installers for all supported operating systems are already out. QGIS 3.6 comes with tons of new features, as you can see in our visual changelog.

We would like to thank the developers, documenters, testers and all the many folks out there who volunteer their time and effort (or fund people to do so). From the QGIS community we hope you enjoy this release! If you wish to donate time, money or otherwise get involved in making QGIS more awesome, please wander along to qgis.org and lend a hand!

QGIS is supported by donors and sustaining members. A current list of donors who have made financial contributions large and small to the project can be seen on our donors list. If you would like to become a sustaining member, please visit our page for sustaining members for details. Your support helps us fund our six monthly developer meetings, maintain project infrastructure and fund bug fixing efforts.

QGIS is Free software and you are under no obligation to pay anything to use it – in fact we want to encourage people far and wide to use it regardless of what your financial or social status is – we believe empowering people with spatial decision making tools will result in a better society for all of humanity.

We are pleased to announce the GRASS GIS 7.6.1 release

We are happy to announce the release of GeoServer 2.14.3. Downloads are provided (zip|war|exe) along with docs (html|pdf) and extensions.

This is a maintenance release of the GeoServer 2.14 series and is recommended for all production systems. Users of prior releases of GeoServer are encouraged to upgrade.

This release is made in conjunction with GeoTools 20.3 and GeoWebCache 1.14.3. Thanks to all who contributed to this release.

For more information please see our release notes (2.14.3 | 2.14.2 | 2.14.1|2.14.0|2.14-RC).

Improvements and Fixes

This release includes a number of new features and improvements, including:

• Fix user creation failing on REST API
• OpenLayers 3 preview did not work on projected data when using version 1.3 of the WMS protocol
• Fixed style editor HTML issues when going back from full screen editor mode, and fixed moving styles referring to local icons from global to workspace
• NetCDF extension packaging fix, allows it to run without also having the NetCDF out plugin installed
• Assorted fixes in WMTS workspace specific capabilities document generation

About GeoServer 2.14 Series

Additional information on the GeoServer 2.14 series:

• New MongoDB extension added
• Style editor improvements including side by side editing
• Nearest match support for WMS dimension handling
• Upgrade notes documenting REST API feature type definition change
• State of GeoServer 2.14 (SlideShare)
• GeoServer Ecosystem (SlideShare)
• GeoServer Developers Workshop (SlideShare)

The GeoTools team is happy to announce the release of GeoTools 20.3: geotools-20.3-bin.zip geotools-20.3-doc.zip geotools-20.3-project.zip geotools-20.3-userguide.zip maven repository This release is a stable release and is recommend for new development and production systems. This release is made in conjunction with GeoServer 2.14.3. Improvements SimpleFeatureIO doesn't allow to encode big

Today we announce the latest release of our Reveal solution, an application for Retailers and Real Estate firms to drive smarter location decisions for their site footprint...

Os mostramos otra novedad de la nueva versión de gvSIG Desktop que facilitará y agilizará las tareas de edición mediante al acceso rápido a la configuración del Snapping o referencia a objetos de una capa.

La ventana que permite configurar el tipo de snapping (punto final, punto medio, punto cercano…), y la tolerancia en píxeles, en versiones anteriores se encontraba dentro de la ventana de “Configuración”. Por otro lado, para activar o desactivar el snapping debíamos usar una tecla rápida o bien utilizar la orden del menú “Editar”.

Gracias al plugin de “Quick access to Snapping Tool” podremos acceder en cualquier momento y de forma muy rápida a las opciones de snapping, pudiendo dejar la ventana flotante mientras editamos y de este modo cambiar en cualquier momento las opciones disponibles.

En el siguiente vídeo mostramos cómo funcionaba el snapping hasta ahora, la instalación del plugin mediante el administrador de complementos y el nuevo funcionamiento.

Every now and then at CARTO we see incredible maps that tell important stories about cities, organizations, our world and people. We spotted this one from one of our users ...

In 6 months time, FOSS4G2019 Bucharest will unfold. A lot of developments have been done and we made announcements for every single one with joy and excitement, whether we were opening the registration or the call for contributions or we were enjoying our wonderful ambassadors tweets and posts.

Hhhhmmmm, maybe I should register for a geospatial conference this year

Hoje vamos adicionar alguns mapas base e alguns controles ao nosso mapa. Até agora temos usado o OpenStreetMap como o nosso basemap. Iremos adicionar 2 novas camadas base e também adicionaremos uma atribuição ao mapa para que possamos dar crédito, além de uma barra de escala.

1. Adicionando Basemaps

Os mapas base e seus URLs que queremos adicionar são:

Mapa Nacional topo: https://basemap.nationalmap.gov/arcgis/rest/services/USGSTopo/MapServer/WMTS/tile/1.0.0/USGSTopo/default/default028mm/{z}/{y}/{x}.png

Open Topop Map: https://tile.opentopomap.org/{z}/{x}/{y}.png

Primeiro criamos as duas camadas de blocos:

var basetopo = L.tileLayer('https://basemap.nationalmap.gov/arcgis/rest/services/USGSTopo/MapServer/WMTS/tile/1.0.0/USGSTopo/default/default028mm/{z}/{y}/{x}.png', {}); var baserelief = L.tileLayer('https://tile.opentopomap.org/{z}/{x}/{y}.png', {});

Poderíamos adicioná-los ao mapa como estão, mas queremos controlar a visibilidade de cada um, permitindo que o usuário escolha qual deles é exibido. Para fazer isso, crie um objeto para manter a descrição e a camada:

var baselayers = { 'Shaded Relief': baserelief, 'National Map topo': basetopo };

2. Adicionando Controle de Camada

O controle de camada nos permite escolher o que é exibido no mapa. Para criá-lo, passamos o mapa base e as camadas de sobreposição. Isso exige que criemos um objeto para manter a(s) sobreposições e, em seguida, podemos criar o controle:

var overlays = { 'The Trail': thetrail }; L.control.layers(baselayers, overlays).addTo(map);

Adicionamos apenas um dos mapas base ao mapa antes de criar o controle. O mapa agora tem um controle de camada com um mapa base ativo e outro disponível no controle:

Nós vamos adicionar sobreposições adicionais em posts futuros.

3. O Scalebar

Adicionar uma barra de escala é fácil:

var scale = L.control.scale() scale.addTo(map)

4. Adicionando Atribuição

Para dar crédito às fontes de dados, adicione a atribuição:

map.attributionControl.addAttribution('National Map Topo'); map.attributionControl.addAttribution('OpenTopoMap');

Isso acrescenta atribuição a qualquer existente, que no início é apenas “Leaflet”.

Isso completa nosso mapa para hoje. Podemos alternar entre camadas base usando o controle e ter a atribuição adequada e uma barra de escala.

5. Código Javascript

var map = L.map(document.getElementById('mapDIV'), { center: [62.7, -144.0], zoom: 6 }); // Base maps var basetopo = L.tileLayer('https://basemap.nationalmap.gov/arcgis/rest/services/USGSTopo/MapServer/WMTS/tile/1.0.0/USGSTopo/default/default028mm/{z}/{y}/{x}.png', {}); var baserelief = L.tileLayer('https://tile.opentopomap.org/{z}/{x}/{y}.png', {}); basetopo.addTo(map); // The trail var thetrail = L.geoJSON(trail, { color: '#800000', weight: 3, dashArray: '12 8 12', }); thetrail.bindTooltip('The Valdez-Eagle Trail') thetrail.addTo(map); var baselayers = { 'Shaded Relief': baserelief, 'National Map topo': basetopo }; var overlays = { 'The Trail': thetrail }; L.control.layers(baselayers, overlays).addTo(map); // Add scalebar var scale = L.control.scale() scale.addTo(map) // Add attribution map.attributionControl.addAttribution('National Map Topo'); map.attributionControl.addAttribution('OpenTopoMap');

CARTO’s Support and Solutions teams often create CARTO.js and CARTO VL examples for our clients, so we’re in the same situation as many of you: we need to build apps effici...

Free registration period for the 4th gvSIG Festival is now open. The gvSIG Festival is an online conference about gvSIG that will be held in March 27th and 28th.

This year we made a special appeal to the group of women who are part of the gvSIG Community, and it has been reflected at the program, where almost all the presentations will be given by women. You can check the full program of the gvSIG Festival on the event website, where there will be presentations in Spanish, English and Portuguese.

The webinar platform allows to connect to the webinars from any operating system, and in case you can’t see some of the webinars, you will be able to watch them at the gvSIG Youtube channel later like in the previous year.

Registration for each webinar can be done from the program page of the gvSIG Festival website.

Don’t miss it!

Ya están abiertas las inscripciones gratuitas para el 4º gvSIG Festival, las  jornadas virtuales de gvSIG que se celebrarán los días 27 y 28 de marzo.

Este año hemos hecho un llamamiento especial al colectivo de mujeres que forman parte de la Comunidad gvSIG, y cuenta de ello es que prácticamente todas las ponencias van a ser impartidas por mujeres. Podéis consultar el programa completo del gvSIG Festival en la página web del evento, en el que habrá ponencias en Inglés, Español y Portugués.

La plataforma de webinar permite conectarse desde cualquier sistema operativo, y en caso de no poder seguirlos en directo podréis verlos a posteriori, ya que se publicarán en el canal de Youtube del proyecto al igual que en años anteriores.

La inscripción a cada uno de los webinars puede realizarse desde el propio programa en la web del evento.

A kind user alerted me to the fact that my Map Preview extension for Visual Studio Code was using APIs that have long been deprecated and could be removed any moment in a future release, breaking this extension in the process.

Although I haven't touched this code in a while (not intentional btw. One person can only tend to so many different open source projects), getting back into VSCode extension development was a very comfortable affair:

• Update a few packages here and there. 
• Update TypeScript. 
• Read up on the new Webview API, which is what our extension should be using now.
• Replace usages of vscode.previewHtml with the new Webview API.
• Verify the extension still works
• Get re-acquainted with how to publish VSCode extensions

And ... voila! A new version of the Map Preview extension is available for your VSCode installation to auto-update to.

In terms of changes, beyond some updates to OpenLayers and a small bug fix or two, there isn't really much to write home about, it should still be the same extension as before. This release was driven primarily by the need to move away from their old vscode.previewHtml API over to their new Webview API.

Once things have settled down on my other projects, I'd like to give this project some more attention. There's still some cool ideas I want to explore with this extension. I don't know if I still want to go down the Cesium route as previously hinted as there have been many more data viz players that have arrived on the scene since then and I also sort of do not want to detract from the original goal and purpose of this extension: An easy way to preview on a Map textual content that you are already editing or viewing in VSCode.

Sometimes we need to visualize GPX files obtained with GPS devices. These files can be used to describe waypoints, tracks and routes.

Both with gvSIG Desktop (on Windows, Linux and Mac) and with gvSIG Mobile (on Android) you can load this type of files, and overlap them with another type of cartography, both raster and vector layers, with local files and layers available through remote services.

In gvSIG Desktop we can load the GPX files from the “OGC” tab of the “Add layer” window. Once the file is selected by entering the “…” button, we must press “Open”, and then the information to be loaded has to be selected (“tracks”, “track_points” …). The layer will be reprojected to the reference system of the View.

In gvSIG Mobile we can load the GPX files from the “Import” menu available at the main menu.

In these videos you can see how it works in a better way:

gvSIG Desktop:

gvSIG Mobile: