| const fs = require('fs') | |
| const Promise = require('bluebird'); | |
| const moment = require('moment'); | |
| const { simpleParser } = require('mailparser'); | |
| const run = async (params) => { | |
| const { inputFolder, outputFolder } = params; | |
| // make a list of e-mails (.eml files) | |
| const files = fs.readdirSync(inputFolder); |
| curl --request GET 'https://api.fulcrumapp.com/api/v2/forms.json' \ | |
| --header 'Accept: application/json' \ | |
| --header 'X-ApiToken: yer_token' | jq '.forms[] | {name, id}' |
| #!/usr/bin/env bash | |
| # USAGE: bash record-history.sh -r <record_id> -t <api_token> -d <some_folder> | |
| fulcrum_id='' | |
| token='' | |
| folder='./' | |
| while getopts 'r:t:d:' flag; do | |
| case "${flag}" in |
| ogr2ogr -t_srs EPSG:4326 \ | |
| -f "PostgreSQL" \ | |
| PG:"host=localhost user=postgres dbname=mydb password=mypassword" \ | |
| "myfgdb.gdb" "myfeatureclass" \ | |
| -where "somefield" <> 'some_value' |
Original dataset (comma separated values, CSV) was downloaded from https://safetydata.fra.dot.gov/officeofsafety/publicsite/downloaddbf.aspx
The following ogr2ogr script converts the CSV file to GeoJSON, keeping several attributes that we wished to use for styling:
ogr2ogr -f "geojson" \
crossings-5.geojson \
CI_Crossings.csv -oo X_POSSIBLE_NAMES=Longitude -oo Y_POSSIBLE_NAMES=Latitude \
| =(((((B4/1000)/60)/60))/24)+DATE(1970,1,1) |
| ogr2ogr -f PostgreSQL PG:"dbname='mydb' host='localhost' port='5432' user='postgres' password='ilovedonuts'" \ | |
| ~/Desktop/mygpkg.gpkg gpkg_layer_name -nln pg_schema_name.pg_layer_name |
| for file in $(ls *.jpg); do magick ${file} -resize 640x640 ./out/${file}; done |
| var exec = require('child_process').exec; | |
| var fs = require('fs'); | |
| fs | |
| .readdirSync(__dirname) | |
| .filter(function (file) { | |
| return file.indexOf('.') > -1 && file != 'index.js'; | |
| }) | |
| .forEach(function(file) { | |
| exec('magick ' + file + ' -resize 640x640 ./out/' + file) |