peterdesmet

Contributing to our_package

First of all, thanks for considering contributing to our_package! 👍 It's people like you that make it rewarding for us - the project maintainers - to work on our_package. 😊

our_package is an open source project, maintained by people who care. We are not directly funded to do so.

peterdesmet

@prefix schema: <http://schema.org/> .
@prefix dct: <http://purl.org/dc/terms/> .
@prefix adms: <http://www.w3.org/ns/adms#> .
@prefix xsd: <http://www.w3.org/2001/XMLSchema#> .
@prefix skos: <http://www.w3.org/2004/02/skos/core#> .
@prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> .
@prefix vcard: <http://www.w3.org/2006/vcard/ns#> .
@prefix dcat: <http://www.w3.org/ns/dcat#> .
@prefix locn: <http://www.w3.org/ns/locn#> .
@prefix foaf: <http://xmlns.com/foaf/0.1/> .

peterdesmet

Our specifications

occurrenceID

Every record should have an occurrenceID.

basisOfRecord

Accepted values:

peterdesmet

peterdesmet

peterdesmet

# -*- coding: utf-8 -*-
import requests
import json
import csv
import sys

def get_datasets(offset, limit):
    sys.stderr.write('Requesting batch {}\n'.format(offset)) # Use stderr to not contaminate stdout, which is used for the results
    request = requests.get('http://api.gbif.org/v1/dataset/', params={'limit': limit, 'offset': offset})
    results = request.json()['results']

peterdesmet

• Title: Let your data shine... with OpenRefine
• Author: Dimitri Brosens (& Peter Desmet)
• Author photo: http://2016.openbelgium.be/storage/app/uploads/public/566/060/c1d/566060c1d641a953718404.jpg
• Cover photo: http://i.imgur.com/fap1ghT.png
• Cover photo license: https://creativecommons.org/publicdomain/zero/1.0/
• Blog post license: https://creativecommons.org/licenses/by/4.0/

Let your data shine... with OpenRefine

“Google refine is awesome. Never before have I been home this early.” - @salesient

peterdesmet

Nocturnal bird migration forward trajectory classified by airspeed into songbirds and waterbirds - Night of April 7-8, 2013

https://inbo.cartodb.com/u/lifewatch/viz/88c30be4-1063-11e5-a9ae-0e853d047bba/public_map

SQL

SELECT *,
	CASE
		WHEN airspeed = 0 THEN 0

peterdesmet

-- SetSRID defines the datum. Use 31370, not 31300 for Belgian Lambert 72

SELECT
    *,
    ST_Transform(ST_SetSRID(ST_MakePoint(x,y),31370),4326) as geom_from_lambert,
    ST_Y(ST_Transform(ST_SetSRID(ST_MakePoint(x,y),31370),4326)) as latitude_from_lambert,
    ST_X(ST_Transform(ST_SetSRID(ST_MakePoint(x,y),31370),4326)) as longitude_from_lambert
FROM table_name

peterdesmet

ALTER TABLE rbins_radar_occurrences
RENAME COLUMN expr1000 to date;

ALTER TABLE rbins_radar_occurrences
ALTER COLUMN area SET data type integer USING area::integer;
ALTER TABLE rbins_radar_occurrences
ALTER COLUMN av_reflectivity SET data type integer USING av_reflectivity::integer;
ALTER TABLE rbins_radar_occurrences
ALTER COLUMN date SET data type timestamp with time zone USING date::timestamp with time zone;
ALTER TABLE rbins_radar_occurrences