jsanz

Loading geospatial data into Elasticsearch

Resources:

• Elasticsearch OGR Driver
• Ingest geospatial data into Elasticsearch with GDAL
• Dec 6th, 2020: [EN] Uploading data from OSM into Elasticsearch

Note

Asumes a recent Elastic stack (Elasticsearch at least) running on

jsanz

This CSV serves as a look up table to relate GRIDCODE field with the corresponding Köppen-Geiger classification and the color used on the paper.

I used this table to create this map

More info:

• Köppen-Geiger source
• Köppen-Geiger paper

jsanz

Quizz and assignments links

Links collected over the quizzes and the course book of the Coursera «The Age of Sustainable Development» course by Dr. Jeffrey D. Sachks.

Week 1: What is Sustainable Development?

• World Bank Indicator: http://data.worldbank.org/indicator
• GapMinder: http://www.gapminder.org/world
• Rule of 70: http://en.wikipedia.org/wiki/Rule_of_72

jsanz

This simple scripts scraps the FOSS4G Community Review pages to convert the abstracts into a JSON file that will contain for each abstract:

• Page number
• Title
• Abstract in HTML
• Your score if it exists

Requirements: Python 3, [BeautifulSoup][bs], and [Requests][req]

It expects a FOSS4G_ID environment variable that is the variable part of the URL that you get when you sign in for the community review: https://talks.osgeo.org/foss4g-2022/p/voting/talks/{FOSS4G_ID}?.

jsanz

#!/usr/bin/env python
# coding: utf-8

# In[ ]:


get_ipython().system('pip3 install -U InstagramApi')


# In[37]:

jsanz

"""
Small script to fix geometries of the first file argument
using the native QGIS processing algorithm. You may need
to adjust the path to you installation.
"""

import sys
sys.path.append('/usr/share/qgis/python/plugins')

from processing.core.Processing import Processing

jsanz

# Minimal Docker Compose cluster for ElasticSearch and Kibana 7.4
# Put this file any folder creating "logs" and "esdata" folders
# to persist the cluster indices and kibana state

version: "3"
services:
  elasticsearch:
    image: docker.elastic.co/elasticsearch/elasticsearch:7.4.0
    container_name: elasticsearch
    ports:

jsanz

This example loads a CartoDB layer using a crazy SQL from a small variation of this awesome Stack Overflow response. Note the use of CSS style tags for the CartoCSS to allow easy editing.

The uncompressed (and not perfect!) version of the SQL to draw the Voronoi diagram is:

WITH 
    Sample AS (
      SELECT st_setsrid(st_union(the_geom),0) as geom 
      FROM registro_centros_nz WHERE spanish = 1
    ),

jsanz

Building a cartographic web application with pg_tileserv and pg_featureserv

• Workshop materials.
• Reused the postgis Docker Compose template from previous workshop
• Reused also the osgeo/gdal container to use ogr2ogr on the downloaded shapefiles.
• Added pg_featureserv and pg_tileserv Docker images passing the .toml configurations as part of the command setting.
• Added an nginx service to the compose file for the HTML files.
• Played with different HTML pages that load tiles from pg_tileserv and displays them using OpenLayers.
• Created a view that returns random points.

jsanz

workshop
.env