yellowcap’s gists

yellowcap / pgraster-statistics.sh

Created September 5, 2024 10:45

Fast PostGIS based raster statistics

	# Freguesias from
	# https://dados.gov.pt/pt/datasets/freguesias-de-portugal/

	# Landcover from
	# aws s3 cp s3://esa-worldcover/v200/2021/map/ESA_WorldCover_10m_2021_v200_N39W009_Map.tif ~/Desktop/wcpt/

	# Create new database
	psql -d postgres -c "DROP DATABASE IF EXISTS wc_stats"
	psql -d postgres -c "CREATE DATABASE wc_stats"

yellowcap / s3-to-ebs.py

Last active March 7, 2024 14:30

Copy data from S3 to EBS faster

	"""
	A script to sync S3 data fast to a local folder or EBS store.

	The script calls aws s3 sync in parallel for subfolders.

	In addition to parallel sync calls, also increase the concurrent
	request for each sync call using an ~/.aws/config file

	[default]
	s3 =

yellowcap / gist:e2172e730e06e8d7121ac91fc45dabbc

Created April 10, 2023 15:48

Rio cube

Rio Cube Bern

yellowcap / main.py

Last active February 2, 2023 16:30

Sentinel-2 RGB image overlapping with GeoJSON feature served through fastapi

	import requests

	response = requests.post(
	"http://127.0.0.1:8000/rgb/?start=2022-01-01&end=2022-01-31&mode=ndvi",
	json={
	"bbox": [128.774676, -22.256217, 128.789557, -22.241022],
	"geometry": {
	"coordinates": [
	[
	[128.77626, -22.24742],

yellowcap / index.html

Last active December 18, 2018 16:15

	<!DOCTYPE html>
	<meta charset="utf-8">
	<title>spatialsankey.js - sankey diagrams on a map</title>

	<link rel="stylesheet" href="http://cdn.leafletjs.com/leaflet-0.7.3/leaflet.css" />

	<style>
	body {
	position: absolute;
	width:100%;

yellowcap / Dockerfile

Last active March 29, 2016 10:25

Django Test Build for GDAL Versions

	FROM ubuntu:14.04

	RUN apt-get update && apt-get upgrade -y
	RUN apt-get install -y \
	wget\
	libproj-dev\
	python-dev\
	build-essential\
	libffi-dev\
	git\

yellowcap / serializers.py

Last active August 29, 2015 14:08

Django-parler integrated with Django-Rest-Framework for read only applications. When using these classes to create ModelViewSet endpoints, you can select the language using query parameters. For example /api/mymodel/?language=fr

	from rest_framework import serializers

	class ParlerModelSerializer(serializers.ModelSerializer):
	"""Serializer to handle django-parler fields"""

	def __init__(self, args, *kwargs):
	# Get list of translated fields
	fields = self.Meta.model._translations_model.get_translated_fields()

	# Separate parler fields and scilent fields

yellowcap / index.html

Last active July 29, 2019 00:45

Leaflet layer propagation example

	<!DOCTYPE html>
	<html>
	<head>
	<title>Leaflet GeoJSON Example</title>
	<meta charset="utf-8" />

	<meta name="viewport" content="width=device-width, initial-scale=1.0">
	<link rel="stylesheet" href="http://cdn.leafletjs.com/leaflet-0.7.3/leaflet.css" />

	</head>

yellowcap / index.html

Last active May 10, 2023 08:27

spatialsankey.js - visualizing flows on a leaflet map

	<!DOCTYPE html>
	<meta charset="utf-8">
	<title>spatialsankey.js - sankey diagrams on a map</title>

	<link rel="stylesheet" href="https://unpkg.com/[email protected]/dist/leaflet.css" integrity="sha256-kLaT2GOSpHechhsozzB+flnD+zUyjE2LlfWPgU04xyI=" crossorigin="" />

	<style>
	body {
	position: absolute;
	width:100%;

yellowcap / linux-2014.03-psql9.3.3-postgis2.1.0-mapscript6.4.1.sh

Last active May 4, 2016 13:11

Custom AMI preparation with PostGIS enabled

	#!/bin/bash
	#
	# Script to setup a Elastic Beanstalk AMI with geospatial libraries
	# Author: Daniel Wiesmann, July 14, 2014
	#
	# sh aws_ami_prep.sh > aws_ami_prep.log 2>&1 &

	# Go to ec2-user home directory
	cd /home/ec2-user

Daniel Wiesmann yellowcap