Home › Groups › SFPUG PgDay Talk Submission Moderation

Using PostGIS to add some spatial flavor to your applications

scitronpousty's picture
Posted June 12th, 2008 by scitronpousty

With the advent of neogeography everyone wants to do something spatial with their applications. In this session I will give an introduction to PostGIS (a spatial blade for PostreSQL) and then show you how to get some cool mapping magic going. We make sure your PostGIS install is working, download some data from the internet, load it into PostGIS, and then start asking some interesting spatial questions of the data. We will look at queries calculate distance and area, calculate centroids, test distance or containment, and we will clip features to a bounding box. Demos and code will be shown for using these functions in desktop applications and in custom applications.

(NOT THE ABSTRACT) If you do not receive a workshop submission we can do this as more hands on and have some more fun with it. I am willing to do this if you receive nothing else but right now prefer to only commit to an hour but can do more. If so then people should sign up for accounts on the deCarta devZone http://developer.decarta.com so we can do some live coding.

Speaker Biography: 
Steve is the technology evangelist for deCarta. He has been using Postgresql for over 6 years with more than 2 years experience in PostGIS. He has 7 years of programming expertise ranging from data processing and statistical analysis to ORM and web applications. He began doing geospatial work 16 years ago and has done geospatial programnming work on multiple platforms using JavaScript, .NET, and Java. He has spoken at numerous conferences including JavaOne, AjaxWorld, ESRI User Conference, and SAP TechEd. Before deCarta Steve also held a number of applied GIS and spatial technology research positions at Yale University, University of New Haven, and University of Connecticut. Steve holds a B.A. from Vassar College, an M.S. from University of Georgia and a Ph. D. in Ecology from University of Connecticut. He likes building interesting applications and helping developers create great solutions. </p>
Talk Type: 
Talk (1 hour)

Back to top