advanced field data collection - imagin...advanced field data collection arcgis collector &...

Advanced Field Data Collection

ArcGIS Collector & Survey123 Damien Finkbeiner & Kray Freestone

I. Collector

A. Technology

B. GPS Configuration

C. Feature Class Creation

D. Data Collection

II. Survey123

A. Web Form Builder

B. Survey123 Connect

C. Syncing feature service data with Survey123 form

D. Upcoming Features

Overview

Technology

● EOS Arrow 200

○ 1-3 cm Accuracy

with RTK

● Apple iPad Pro

○ Lifeproof Case

Tools

iOS Field Apps

● Esri

○ Collector

○ Collector Classic

○ Explorer

○ Survey123

● EOS Tools Pro

Applications

RTK Base Stations

MDOT Cors

GPS Setup - RTK Base Station

EOS Tools

GPS Setup - Elevation

EOS Tools

Z-Value Feature Classes

ArcGIS Pro

ArcGIS Collector Setup

Field Collection

● Sign-in Using ArcGIS Online Account

● Select Profile to Update Settings

● Add Location Provider

○ EOS Arrow

● Update Location Profile

○ GCS WGS 1984

● Optional ○ Change Accuracy Settings

○ Change Averaging Settings

Map Interface

Field Collection

Data Collection

● Add Features

○ Averaging

● Select Field to Populate

○ Field Types

● Update Point

○ Offset

● Submit

Field Collection

Edit Data

● Select Feature

● Editing Options

○ Edit

○ Copy

○ Delete

○ Directions

● Submit

Field Collection

An introduction

● Surveys, not surveying

● Quick and Simple

● Complex and Scalable

Survey123

Crowdsourced Data

Asset Management

Web Form Builder https://survey123.arcgis.com/surveys → Create New Survey → Modify

Survey123

Web Form Builder

Survey123

Web Form Builder More options available

Survey123

Complex Forms: Survey123 Connect

● Desktop application

● Access to advanced

functions

○ Calculations

○ Images/Audio Files

○ Pulling Data

○ Populate related tables

in AGOL

● Build surveys from feature

classes

Survey123

Survey123 Connect Survey123

Survey123 Connect: Calculations Built on Arcade

Survey123

Simple Addition:

${question_1} + ${question_2} + ${question_3}

Calculate Someone's Age:

int((today() - ${birth_date}) div (1000 * 24 * 60 * 60 * 365.25))

Area of a plot (given radius):

pi() * pow(${plotRadius}, 2)

Survey123 Connect: Calculations Built on Arcade

Survey123

Survey123 Connect: pulldata() function

Survey123

● Allows you to pull data from a spreadsheet

● Useful for data that stays relatively static

○ e.g. Estimated fish weight

Syntax:

pulldata(<csvfile>, <returnColumn>, <lookupColumn>, <lookupValue>)

Survey123 Connect: pulldata() function

Survey123

pulldata(<csvfile>, <returnColumn>, <lookupColumn>, <lookupValue>)

XLSForm

data.csv

Survey123 Connect

Survey123 Connect: pulldata() function

Survey123

pulldata(<csvfile>, <returnColumn>, <lookupColumn>, <lookupValue>)

XLSForm

data.csv

Survey123 Connect

Sample Case: City of Dowagiac

Purpose: to dynamically view previous entries when data is being

submitted in a form

Solution: Survey123 and Python scripting

Survey123

Dowagiac's Previous Form

Survey123

Sample Case: City of Dowagiac

New survey → Create Survey from Feature Service → Customize

Problem: how do we dynamically and automatically update our data?

Survey123

City of Dowagiac: Methodology

Survey123

Download Form Item

from AGOL

Read Attribute Table from

AGOL

Query the most recent inspection

date in table

Write the query to a CSV inside of the Form

Item's Folder

Upload new Form Item (overwrites

old Item)

# item ID of the form item on AGOL form_item = 'XXXXXXXXXXXXXXXXXXXXXX' # item ID of the feature class that contains the related table feature_item = 'XXXXXXXXXXXXXXXXXXXXXXXX' # Address of your ArcGIS portal portal_url = r'https://yourSite.maps.arcgis.com' # ArcGIS user credentials to authenticate against the portal (case sensitive) credentials = {'userName' : 'yourUsername', 'passWord' : 'yourPW'} # ArcGIS portal security type (LDAP, NTLM, OAuth, Portal, PKI) security_type = 'Portal'

From Explorer to Survey123

Survey123

From Explorer to Survey123

Set-up URL in Custom Attribute Display in ArcGIS Online

Survey123

From Explorer to Survey123

Set-up URL in Custom Attribute Display in ArcGIS Online

arcgis-

survey123://?itemID=YOUR_FORM_ID&field:FACILITYKEY={FACIL

ITYID}&field:NAME={NAME}

Survey123

What's New: JavaScript Extension

● pulldata() Javascript extensions

○ perform calculations

○ return JSON objects, parse results

○ Manipulate live data

pulldata("@javascript","yourJSFile.js","yourFunction",

"parameter1","parameter2")

Survey123

What's New: JavaScript Extension

Fahrenheit to Celsius Example: myJSFunctions.js (to be put in extensions folder)

function toCelsius(fahrenheit) {

return (5/9) * (fahrenheit-32);

}

XLSForm

pulldata("@javascript","myJSFunctions.js","toCelsius",${farenheit})

Survey123

What's New: webhooks

Survey123

What's New: webhooks

Survey123

What's New: webhooks

Survey123

What's in Beta: webhooks

Survey123

What's in Beta: webhooks

Survey123

Questions?

Kray Freestone kfreestone@gowightman.com Damien Finkbeiner dfinkbeiner@gowightman.com

The End