< !doctype html /> 2015 Neurisa Day - Everything is Awesome
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

Application != Application

flickr.com/oakleyoriginals

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
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

Talk Data to Me

  • SELECT FROM
  • WHERE
  • GROUP BY
  • ORDER BY
  • LEFT OUTER JOIN
  • INNER JOIN
  • INSERT INTO
  • functions and flavors

SQL Training Resources

w3schools

Codecademy

Microsoft MSDN

PostgreSQL

PYTHON

XKCD

flickr.com/jeepersmedia

Python Training Resources

Learn Python The Hard Way

Codecademy

ArcGIS Resources

flickr.com/crschmidt

Geospatial SQL Resources

PostGIS

Microsoft SQL Server Spatial

Spatialite

Geospatial Python Resources

Fiona

Mapnik

Shapely

SQL Python Resources

psycopg2

pyodbc

sqlite3

Everything Is Awesome

Python + GeoSpatial + SQL

NEURISA Day - Sept 14, 2015


Guido Stein - Applied Geographics, Inc. / @guidos

http://guidos.github.io