Bryan McBride bmcbride

Data exported out of the Fulcrum OpenTrails Trailhead App requires some post processing in order to generate the proper files, per the OpenTrails trailheads.geojson specification. Simply export as Shapefile and execute the following GDAL/OGR commands:

ogr2ogr -f "SQLite" opentrails-trailheads.sqlite -nln "trailheads" -a_srs "EPSG:4326" opentrails_trailheads.shp

ogr2ogr -update -f "SQLite" opentrails-trailheads.sqlite -nln "osm_tags" opentrails_trailheads_osm_tags.dbf

	{
	"classification_set": {
	"name": "Agricultural Products",
	"description": "A list of common agricultural products",
	"items": [
	{
	"label": "cereals",
	"value": "cereals",
	"child_classifications": [
	{

	function doPost(e){
	return handleResponse(e);
	}

	function handleResponse(e) {
	var email = e.parameter.email;
	var form = e.parameter.form;
	var jsonString = e.postData.getDataAsString();
	var payload = JSON.parse(jsonString);
	var subject = "Fulcrum Webhook Payload";

	<?php

	$form_id = 'your-fulcrum-form-id-goes-here';
	$email = '[email protected]';
	$input = file_get_contents('php://input'); # POST data from webhook
	//$input = file_get_contents('payload.json'); # local file for testing
	$webhook = json_decode($input, true);

	# Webhook data
	$webhookID = $webhook['id'];

	#!/bin/bash

	echo "File type (kmz or kml):"
	read TYPE
	echo "Enter the filename (without the .kmz or .kml extension) to process:"
	read FILENAME

	# Unzip KMZ file
	if [[ $TYPE = "kmz" ]]; then
	Unzip "$FILENAME.kmz"

	<html lang="en">
	<head>
	<meta charset="utf-8">
	<meta http-equiv="X-UA-Compatible" content="IE=edge">
	<meta name="viewport" content="initial-scale=1,user-scalable=no,maximum-scale=1,width=device-width">
	<meta name="mobile-web-app-capable" content="yes">
	<meta name="apple-mobile-web-app-capable" content="yes">
	<title>Leaflet Fullscreen Iframe</title>
	</head>
	<body>

	// Special Apps Script function to process HTTP POST request
	function doPost(e){
	return handleResponse(e);
	}

	function handleResponse(e) {
	// Parse JSON webhook payload
	var jsonString = e.postData.getDataAsString();
	var payload = JSON.parse(jsonString);

	function deleteFromImgur() {
	$.ajax({
	url: "https://api.imgur.com/3/image/{id}",
	type: "DELETE",
	headers: {
	"Authorization": "Client-ID YOUR-CLIEND-ID-GOES-HERE"
	},
	success: function(response) {
	//console.log(response);
	}

	// Create or open an existing Sheet and click Tools > Script editor and enter the code below
	// 1. Enter sheet name where data is to be written below
	var SHEET_NAME = "Sheet1";
	// 2. Run > setup
	// 3. Publish > Deploy as web app
	// - enter Project Version name and click 'Save New Version'
	// - set security level and enable service (most likely execute as 'me' and access 'anyone, even anonymously)
	// 4. Copy the 'Current web app URL' and post this in your form/script action
	// 5. Insert column names on your destination sheet matching the parameter names of the data you are passing in (exactly matching case)