Google Drive, GIS & Appsheet

Maps

Forms

Images

Mobile GIS & Data Collection

Why Appsheet?

Simple (Google Drive Add-on)
Freemium
Advanced Capabilities

Google Drive as a Database?

No Servers to Manage
Synced to Desktop
Relies on Google API (Known to change)
Also Supports Box, Dropbox
Office365 & Smartsheet

Setup Spreadsheet

Unique ID Field is Helpful
- Will use Row ID which will change if sorted
Location Field
- Lat/Long or Address (Appsheet will Geocode)
Image Field (public url to .jpg)
URL Field for External Link

Appsheet Examples

Google Sheet: Hydrants

Appsheet: City Guide

Appsheet: Realtor

Appsheet: Project Plan

Hydrant Inspections

Google Sheet: Hydrants

Google Sheet: Inspections

Questions?

More Information

Appsheet

By GIS OVRDC

Appsheet

OVRDC GIS User Group Presentation on Appsheet and Google Drive 2015-05-12

3,580

GIS OVRDC