PostGIS: A Gentle Introduction
Have you heard that PostgreSQL is the best database for geospatial data? In a market with several proprietary commercial alternatives, users around the world choose PostgreSQL for their geospatial needs, including many state and local governments. That is thanks to PostGIS, the geospatial extension to the PostgreSQL database. If you use PostgreSQL, you probably have heard of PostGIS, but may never have used it.
In this talk, Justin Walgran covers the following PostGIS topics:
- What PostGIS adds to PostgreSQL
- How to bootstrap a PostGIS setup
Justin will do this by showing some examples of how PostGIS allows you build applications that can answer questions which are difficult or impossible to answer without spatial data.
About Justin Walgran
Justin is a member of the Civic Applications team at Azavea and does primarily JavaScript and C# .NET development on custom GIS web applications. He graduated from Penn State with a BS in Computer Science and right out of school Justin worked for 10 years at a small consulting company where he was the architect, lead developer and project manager of the company’s first commercial application which expanded the company’s customer base from a small circle in Pennsylvania to all of North America.
Outside the office you will usually find him attached to a laptop keeping up with software and design blogs, working on his own personal web projects and attending local developer meet-ups. He is a member of the newly formed PhillyJS meetup and is working on a commercial personal publishing application in Ruby on Rails.
About Azavea
We provide our clients access to advanced geospatial technologies through highly-crafted and easy-to-use web software, and personalized geospatial analysis services. Our goal is to combine our experience solving geospatial problems, strong customer service, and the profound motivation to “do well by doing good” in order to help our clients create more dynamic, vibrant communities.
We are committed to enabling our clients to answer complex questions in a wide variety of domains: natural resource planning, neighborhood revitalization, sustainable growth and economic development, crime analysis, real estate property analysis, redistricting, political advocacy, and cultural resources management to name a few.
Thanks for coming, everyone. All the materials from the talk are available on GitHub https://github.com/jwalgran/post...![]()
January 18
Will this talk help with learning PostgreSQL? Or, will "Handling Postgres in a High Traffic Environment" be a better source?
January 17
Join or login to comment.