planetfederal / workshops

Workshop materials relating to open source projects that we participate in or products we support.

Boundless Workshops Repository

This repository is for all free (Creative Commons) workshop materials created and/or hosted by Boundless. These workshops can be found in built form on Boundless Connect.

Directory structure

workshops

• The actual workshops.
• Do not create copies of workshops in this repo.
• Clone the git repository, do your work, merge back any updates to the master workshop.

themes

• Sphinx themes, referenced in conf.py:
  • html_theme_path should relatively reference this directory
  • html_theme selects which theme to use

Resources

A workshop may depend on external data and/or software:

• SOFTWARE
  • Your workshop should note the versions required
  • Your workshop should include a URL to download the software
  • Don't check software into the repository
• DATA
  • Your workshop should include a URL to download a zip file of the data
  • Workshop data should be stored and linked to.
  • You should name your zip file with a date or version number to allow old versions of the workshop to have a longer lifespan

workshops's Issues

Suite 4.7 GeoServer Advanced Workshop

This workbook no longer functions directly against Suite 4.7 - this issue is used as a checklist as we prepare:

• data folder is cited in documentation, but is empty.

  BUILD FAILED
  adv/data does not exist.
  

• Rest API links are broken (for example http://docs.geoserver.org/stable/en/user/rest/api.html)

• Workbook assumes the default postgis database.
  This was formally setup with some sample data as part of Suite Install. Documentation indicates the following was expected.

  dem
  parks
  rails
  roads
  urban
  

  On the bright side the style files are still here.

• be sure to recommend firefox for use of demo request builder (so displayed XML results can be read)

Help with Sphinx for updating the PostGIS tutorial for he UNOSGEO Challenge

Hello,

I'm currently working on updating the postgis intro for the UNOSGEO Challenge where I will include the respective attribution. Currently I had to change pc and environment and now I can't get the build script to find the conf sphinx file for the workshop. Here's the repo I'm working on https://github.com/unosgeo/challenge1_2019. Hopefully you could hint me in the right direction.

The error I get when running the perl script:
Updating the git repository: /home/may/Documents/unosgeo/challenge1_2019/
git pull origin master
From https://github.com/unosgeo/challenge1_2019

• branch master -> FETCH_HEAD
  Already up to date.
  Building project 'postgis-intro'
  Searching for conf.py...
  ERROR: Unable to find conf.py in project 'postgis-intro'

Any help is appreciated.

Thanks,
Mayra

creatdb path

We need to have createdb's path explicitly stated in the GeoGig workshop for Windows users.

Suite 4.7 Feedback on PostGIS Workshop

TLDR: A few things to fix up, and a few things are hard to find.

Workshop materials:

• we link http://files.boundlessgeo.com/workshopmaterials/postgis-workshop-201401.zip - but I cannot find all the files that make up this zip in version control?

  Example where is sql workbook in version control?

• I am not sure where the slides that go with this presentation are stored

• sql examples out of sync for geometry exercise (last three examples).

Workshop corrections:

• correction: DROP INDEX nyc_census_blocks_geom_idx;
• QGIS strongly recommended for a visual sanity check on what is going on :)

Feedback and questions:

• Q: How to manage which grid-shift to use for NAD (US vs Canada)

  FAQ: http://proj.maptools.org/faq.html

• Q: How to fix table SRID when not specified in import?

  http://postgis.net/docs/UpdateGeometrySRID.html

  SELECT UpdateGeometrySRID('geometries','geom',4326);
  

  That is a lot easier than with PostGIS 1.x

Change workshop license

Update our workshops template to change the licensing from CC-BY-SA to CC-BY-SA-NC.

issue with use of round in a few examples

demonstrated in the join-and-summarize example but this appears elsewhere, too. Specifically, the column computation::

Round(100.0 * Sum(popn_white) / Sum(popn_total), 1)

The error is::

No function matches the given name and argument types. You might need to add explicit type casts.

I fixed this using::

Round( (100.0 * Sum(census.popn_white) / Sum(census.popn_total))::numeric, 2)

I suppose there could be another way...

Move Victor's QGIS blog post into a workshop

http://boundlessgeo.com/2014/05/citibike-analysis-automated-workflows-qgis/

postgis workshop - remove pgShapeLoader and focus on qgis

from a recent attendee (paraphrased):

"The tool is kinda clunky and very-specific. Would be nice to have the same functionality in QGIS. Would also be nice to have QGIS more involved in querying and visualization of results."

GeoGig prerequisites

There's a line in the Prerequisites section that has a problem:

PostgreSQL, PostGIS, and QGIS can be acquired as part of an OpenGeo Suite installation. GeoGig can be , but thi

Suite 4.7 Feedback from GeoServer workshop

Consistent GeoServer/Suite 4.7 issues:

• When importing meterors.zip the incorrect store was selected by default (we would like it to defaul to create new when importing a shapefile).

  Importer: imported "store" is consistently wrong - want it to default to "create new" and it is defaulting to the last used store (on Chrome at least).

  This issue was encountered multiple times and may be a GeoServer regression.

• When importing the cites.sld the default name was generated as "C:\styles\cities.sld" on one machine producing wicket error (another case where we need better name checking).

Documentation glitches:

• Documentation mistake: setting up shapefile store - field is called "Shapefile location" (not URL as documented)

• Documentation assumes opengeo suite ships with "medford" postgresql database - but that has not been true for a long time. We can either reword this section to be general, make the example uses "nyc" (from the postgresql workshop), or provide instructions for loading medford.

• Layergroup page incorrectly shows city names in the screen capture, no style has been defined yet so text labels are not yet generated.

• Importing styles, countries already existed (it is a default dataset).

  We will need to choose a new name (countries2.sld) and update subsequent steps? Or add logic to GeoServer prevent duplicate name.

  This issue was encountered by several individual, each managed to wreck the default countries.sld style, and break their existing opengeo:countries layer in the process.

Recommendations:

• Importing styles, we should take a moment to mention legend preview (new features).
• Remove GeoExplorer section (not sure if if it can be replaced with a simple SDK app, or just removed)
• Update KML section to use google maps or cesium or similar (google earth is dead)

Introduction to OpenGeoSuite workshop - Update GeoWebCache Screenshots

Update for Suite 4.5.

Currently for GeoWebCache, authentication is required. The user is geowebcache and password is secured.

http://workshops.boundlessgeo.com/suiteintro/

boundless_training theme fixes for FOSS4G

The boundless_training theme is great - and answers @pramsey request for a theme that "works" in a classroom setting.

Before using it at FOSS4G:

• CCbyA needs to be restored in the footer (this may be done in config.py - not sure)
• request: spoiler annotation so we can communicate the answers traditionally shown in the instructor notes

Example from point.rst:

   #. **Challenge:** Use this approach to rewrite the *Dynamic Styling* example.

      .. only:: instructor

         .. admonition:: Instructor Notes 

            Example available here :download:`point_example.css </files/point_example2.css>`

GeoGig serve in workshop

Suggested replacement for local filesystem clone:

geogig serve repo

In new terminal:

geogig clone http://localhost:8182 new_repo

You can now push to/pull from repo while in new_repo.

Also add a note that you can try running GeoGig on two different computers and push/pull between them.

boundless_doc theme

Request for boundless_doc theme copied from boundless_web theme.

a) copy from boundless_web
b) allow search of the local doc
c) remove large footer
d) cut down on header

• remove download button
• remove ask button

See discussion on #4

Introduce shapefile into GeoGig workshop

Perhaps we can introduce exporting to a shapefile from the cloned repo in the GeoGig workshop so that we avoid the confusion over "sharing" a single PostGIS table between the original and the cloned repository.

This also gives us a chance to demonstrate an extra capability of GeoGig.