News/Articles

Practical QGIS – Live Online Class May 26 through 28th, 2020

Learn QGIS

On May 26 through 28th Terra GIS is offering a 3 day online class on QGIS Desktop GIS ( taught live out of, Seattle, Washington). The class will focus on practical exercises in a workshop style setting. The class will enable ArcGIS users to easily transition to using QGIS and its comprehensive tool kit (or to use it in addition to their existing GIS software). Participants can choose to attend the full three days of the class or optionally attend only one or two of the days. Details about the class can to be found here.

CCRP “Open Source GIS and Tools” Workshop in Nairobi

GIS Workshop Photo AICAD 2017

The latest CCRP “Open Source GIS and Tools” Workshop took place from March 20-24th at the African Institute for Capacity Development (AICAD) in Juja town, about 33 km NE of Nairobi. The group of 19 participants included the Kenya GIS team, representatives of the CCRP GIS support teams from Uganda and Ethiopia, and University partners from 4 Kenyan Universities and their attached students. The CCRP GIS support team consisting of Karsten Vennemann and Matt Stevenson had prepared a week long schedule covering a variety of topics with the goal of capacity building within the East African regional GIS support teams. The workshop included lectures and hands on exercises enabling the participants to publish their own interactive web maps, covered QGIS Cartography about ‘how to make better maps’, introduced tools that enable a wealth of spatial functionality using the desktop program QGIS, and finally introduced templates for creating simple maps and graphs by using the statistical software R. One day of the workshop week was dedicated to group work on creating a guide for CCRP researchers on “how to use GIS, spatial tools and analysis” in support of their scientific work and hypothesis. The resulting guide will be refined in collaboration with the research methods team and will be shared with researchers throughout CCRP. The goal of this guide along with the increased GIS support capacity in the region is to enable CCRP researchers to include spatial knowledge and analysis in their research approaches in order to create better results efficiently.

Practical QGIS – Class in Seattle January 23rd/24th, 2017

QGISLogo
In June Terra GIS is offering a 2 day class on QGIS Desktop GIS at the Impact HUB, Seattle, Washington. The class will focus on practical exercises in a workshop style setting. The class will enable ArcGIS users to easily transition to using QGIS and its comprehensive tool kit (or to use it in addition to their existing GIS software). Participants can choose to attend the full two day class or optionally attend only one of the two days. Details about the class can to be found here. On Wednesday January 25rd, 2017 an additional one day advanced QGIS class will be offered (more information on the advanced class will become available in the next few weeks).

Pre-conference workshop at NWGIS 2016 Conference

Northwest GIS User Group Conference 2016Terra GIS is offering a 2 day hands-on pre-conference workshop “Interoperable Web GIS Solutions with Free & Open Source Geospatial Software” at the NWGIS 2016 Conference – Bridging the Gap. The conference this year will be held at the Salem Convention Center, Salem, Oregon. The pre-conference workshop will be held on Monday October 17th and Tuesday October 18th, 2016, the main conference program will continue until Friday of the same week. Details about the workshop are here and the official conference workshop and registration page is here.

Practical QGIS – Class in Seattle June 20th/21st, 2016

QGISLogo
In June Terra GIS is offering a 2 day class on QGIS Desktop GIS at the Impact HUB, Seattle, Washington. The class will focus on practical exercises in a workshop style setting. The class will enable ArcGIS users to easily transition to using QGIS and its comprehensive tool kit (or to use it in addition to their existing GIS software). Participants can choose to attend the full two day class or optionally attend only one of the two days. Details about the class can to be found here. On Wednesday June 23rd, 2016 an additional one day advanced QGIS class will be offered (more information on the advanced class will become available in the next few weeks).

Pre-conference workshop at URISA GIS-Pro & NWGIS 2015 Conference

nwgisuserTerra GIS is offering a 2 day hands-on pre-conference workshop at the URISA GIS-Pro & NWGIS 2015 Conference – Geography at the Nexus of Collaboration. The conference this year will be held at the Davenport Grand Hotel, 333 W Spokane Falls Blvd, Spokane, Washington. The pre-conference workshop will be held on Sunday October 18th and Monday October 19th, 2015, the main conference program will continue until Thursday of the same week. Details about the workshop are here and the official conference workshop page is here.

Practical QGIS – Class in Seattle May 28/29, 2015

QGISLogo
At the end of May Terra GIS is offering a 2 day class on QGIS Desktop GIS at the Impact HUB, Seattle, Washington. The class will focus on practical exercises in a workshop style setting. The class will enable ArcGIS users to easily transition to using QGIS and its comprehensive tool kit (or to use it in addition to their existing GIS software). Participants can choose to attend the full two day class or optionally attend only one of the two days. Details about the class can to be found here.

Pre-conference workshop at 2014 NWGIS Conference

nwgisuserTerra GIS is offering a 2 day hands-on pre-conference workshop at the 28th annual Northwest GIS Users Conference – WORKING ACROSS BORDERS. The conference this year will be held at the Lynnwood Convention Center, about 15 miles north of downtown Seattle, Washington.  The pre-conference workshop will be held on Monday October 13th and Tuesday October 14th, 2014, the main conference program will continue until Friday of the same week. Details about the workshop are here and the official conference workshop pages/registration are here.

Talk at WAURISA 2014 in Tacoma

waurisa2014
Today I gave a pretty general talk Cartography and composition of interactive Maps at the WAURISA GIS 2014 conference in Tacoma. The talk is strongly based on Ian Muehlenhaus’s excellent book “Web Cartography. Map design for Interactive and Mobile devices(2014). This years conference had a strong theme about communication which worked out really well and my presentation fit right in. The presentation slides are here.
nwgisuser

Dynamic Web map of gvSIG CE downloads

Web map of gvSIG CE downloadsFor some time I had been wishing to create an interactive web map showing downloads of gvSIG CE over time. This could provide a nice opportunity to learn more about using the Leaflet JS viewer, and dynamically outputting results as GeoJSON, while at the same time providing more detailed insight into the download dynamics of the gvSIG CE project over time. The idea was to create a map that provides for custom styling and has query capability of the download statistics by country and time intervals.
The software downloads of gvSIG CE are hosted on Sourceforge. Sourceforge also supplies an API for retrieving download statistics for any of their hosted projects – see . The technical steps taken to create the new gvSIG CE download map are as follows: On a server that already had a complete software stack of OS GIS web mapping components installed I created a new PostGIS data base. A simplified Countries (of the world) GIS layer was imported and additional tables to hold the gvSIG download data and summaries created.
Next a way to load the gvSIG CE download statistics into the PostGIS was needed. This was implemented via a custom Python script that can retrieve the data from the Sourceforge API ( automated via a server cron job ) on a daily basis. To obtain all existing data for each day the script had to run separate API calls for each day from the initial start of downloads on August 30 2011 up to today. The Python script then creates a temporary SQL file on the server file system that includes the SQL insert commands for creating the download records in the PostGIS table. Executing the SQL commands in the SQL file in the data base a separate record will be created in that table including the number of downloads for each country and day. For example if on a specific day there where one or multiple downloads from 4 countries then there would be 4 new records added having the countries names, and respective number of downloads along with the download date. Next the web page for the web map was created using a Leaflet based GIS viewer (a Java Script library). The simple Country layer in GeoJSON format was added to Leaflet and some nice, third party base map tiles (in gray scale from www.toolserver.org/tiles/bw-mapnik/ ) added to the map view. In PostGIS the download data was then summarized and joined to the Country geometries in a data base view. The contents of this data base view where exported as GeoJSON and saved as a static java script file and included as a layer in the Leaflet map.
The map at this stage showed the (static) total number of downloads for each Country from the start of downloads to today, however this did not include any query capability. To implement query capability some additional steps are needed: in the GUI two data selection HTML fields for start and end date where added along with a query button. When a user clicks the query button a PHP on the server will be called with the query dates. The query logic is a moderately complex SQL query that summarizes the download data for the selected time period, joins the results to the Country PostGIS layer geometries and then outputs the results as GeoJSON dynamically. Consequently for each query those countries that have had no downloads for the queried time period will not appear in colors in the GeoJSON result layer. In essence the dynamic query replaces the static java script file with the country geometries and total download statistics we added initially.
The draft map that resulted from this work can be found at http://gvsigce.terragis.net. At first glance the most interesting thing is that the top three countries are Spain followed by China and Germany in number of total downloads.