flickr.com/ssoosay

Everything Is Awesome

Python + GeoSpatial + SQL

NEURISA Day - Sept 14, 2015

Guido Stein - Applied Geographics, Inc. / @guidos

http://guidos.github.io

introduction

Guido Stein > like burrito

GIS Anlayst @ Applied Geographics
AvidGeo Meetup Group Founder
Model Builder, Python, FME, PostGIS, SDE, & CartoDB

FOSS4G 2017 Boston Bid Organizer

Overview

It's An Overview
Everything
SQL & Databases
Python

Location
Live Data Integration
Live Analysis
Data Portal

flickr.com/gsfc

special snowflake
universe of options
everything

Application != Application

technology
tool
solutions

flickr.com/oakleyoriginals

when you are a hammer
needs
solutions

Property Database Integration

Keep parcel data current with real property data

sql
- Query data from multiple tables from CAMA database
python
- Join query data into a feature class
geospatial
- Display parcel data with joined CAMA database data

School District Boundary Change Analysis

Determine number of residents affected by district boundary changes

geospatial
- Determine new district assignments to address points
sql
- Aggregate counts of residents and percent change by district id
python
- Repeat process across multiple scenarios and report output

Data Portal

Distribute collected data with interested parties and allow for feedback

sql
- Store feature classes, data statistics, and website configuration information
geospatial
- Search for spatial relationships within database
python
- Serve out dynamic web pages with information within database

flickr.com/aigle_dore

store
share
collaborate

Tool Type Flavor Microsoft SQL Server Server Proprietary Oracle Server Proprietary PostgreSQL Server Open Source MySQL Server Open Source Microsoft Access File Proprietary SQLite File Open Source