work in progress
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
 
 
 
 
 
 
treeadvisor/default.nix

46 lines
1.9 KiB

{ pkgs ? import <nixpkgs> {} }:
rec {
geojsons = {
# https://opendata.dresden.de/informationsportal/#app/mainpage//Stadtb%C3%A4ume
trees = "https://kommisdd.dresden.de/net4/public/ogcapi/collections/L1261/items?limit=10000000";
# Natürliche Funktionen des Bodens: https://kommisdd.dresden.de/net4/public/ogcapi/collections/L859
boden_fkt = "https://kommisdd.dresden.de/net4/public/ogcapi/collections/L859/items?limit=10000000";
# Gebietstypen des natürlichen Wasserhaushaltes: https://kommisdd.dresden.de/net4/public/ogcapi/collections/L1106
wasserhaushalt = "https://kommisdd.dresden.de/net4/public/ogcapi/collections/L1106/items?limit=10000000";
# Wasserspeichervermögen: https://kommisdd.dresden.de/net4/public/ogcapi/collections/L849
wasserspeicher = "https://kommisdd.dresden.de/net4/public/ogcapi/collections/L849/items?limit=10000000";
};
# TODO:
# im Grundwasser
# UmweltWasser
# Gebietstypen des natürlichen Wasserhaushaltes
# UmweltWasser
# Grundwasser - aktuelle Messwerte
# Plants For A Future
pfaf_sql = pkgs.requireFile {
name = "PlantsForAFuture.sql";
sha256 = "1wya1yb3hyybr71znmag7kq0jdc1cwazaqfp375jbfmaql3r92mq";
message = "PlantsForAFuture.sql, compatible with PostgreSQL";
};
init-database = with pkgs; writeShellScript "populate-database" ''
set -e
${lib.concatMapStrings (name: ''
F=${name}.geojson
[ -e $F ] || ${wget}/bin/wget -O $F "${geojsons.${name}}"
ls -l $F
# ${gdal}/bin/ogr2ogr -f "PostgreSQL" PG:"dbname=treeadvisor user=treeadvisor" -nln ${name} $F
'') (builtins.attrNames geojsons)}
${postgresql}/bin/psql -f ${./db.sql} treeadvisor
${deno}/bin/deno run --allow-read --allow-net ${./import_geojson.ts} GEOENV boden_fkt.geojson wasserhaushalt.geojson wasserspeicher.geojson
${deno}/bin/deno run --allow-read --allow-net ${./import_geojson.ts} TREES trees.geojson
${postgresql}/bin/psql -f ${pfaf_sql} treeadvisor
'';
}