gannebamm

# GeoNetwork
#
# Access via "http://localhost:8080/geonetwork" (or "http://$(docker-machine ip):8080/geonetwork" if using docker-machine)
#
# Default user: admin
# Default password: admin

version: '3.1'
services:

gannebamm

SETUP

followed http://docs.ckan.org/en/2.8/maintaining/installing/install-from-package.html

install nginx/apache wsgi git

sudo apt-get update
sudo apt-get upgrade
sudo apt-get install -y nginx apache2 libapache2-mod-wsgi libpq5 redis-server git-core 

nginx will fail to start since the apache webserver is using port 80. Install nano and change the apache port:

gannebamm

production.ini

# ckan harvester
ckan.harvest.mq.type = redis
ckan.spatial.validator.profiles = iso19139

paster harvester sources

(default) administrator@GDIT01-BS:/usr/lib/ckan/default/src/ckanext-harvest$ paster --plugin=ckanext-harvest harvester sources --config=/etc/ckan/default/production.ini
2018-09-06 14:54:28,651 DEBUG [ckanext.spatial.plugin] Setting up the spatial model
2018-09-06 14:54:28,674 DEBUG [ckanext.spatial.model.package_extent] Spatial tables defined in memory
2018-09-06 14:54:28,681 DEBUG [ckanext.spatial.model.package_extent] Spatial tables already exist

gannebamm

# read the csv file
df <- read.csv(file = "locResults_small_mNoise5_mSigRnd8.csv")

# use ggplot for plotting
require(ggplot2)

# show histogramms
ggplot(df, aes(x=error_m)) +
  geom_histogram(bins=20,
                 colour="dark gray", fill="black") +

gannebamm

select SUM(red.n), black.*
	from red, black
	where st_crosses(red.geometry, black.geometry)
	group by black.ID

gannebamm

CREATE TABLE samplelines
(
    id serial,
    name character varying(50) COLLATE pg_catalog."default",
    CONSTRAINT samplelines_pkey PRIMARY KEY (id)
)
-- add 3dims enabled geometry column
SELECT AddGeometryColumn('public', 'samplelines', 'geom', 25832, 'LINESTRING', 3);

-- pick the samplepoints and create lines

gannebamm

SELECT ST_MAKELINE(
	(SELECT geom
		FROM samplepoints_xyz
		WHERE name = 'al_01'),
	(SELECT geom
		FROM samplepoints_xyz
		WHERE name = 'sound_01')), 's1' AS sample

gannebamm

--
-- PostgreSQL database dump
--

-- Dumped from database version 9.6.2
-- Dumped by pg_dump version 10.0

-- Started on 2018-01-03 18:49:42

SET statement_timeout = 0;

gannebamm

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Passive Audio Monitoring Trilateration\n",
    "\n",
    "## The Issue\n",
    "One example of a trilateration algorithm is the GPS based localization. The algorithm uses the runtimes of three or more signals to determine the position of the sensor on earth. In this algorithm the _absolute_ runtimes for each signal are known due to the GPS timestamps send by the satellites.\n",

gannebamm

### configuration file for assos_listen
# upload
upload = False

# config for this sensor
sensorID = "al_03"

# sampling rate & chunk size
chunkSize = 1024
samplingRate = 44100 #44100 # 44100 needed for Aves sampling