From: | Robert Bernier <robert7390(at)comcast(dot)net> |
---|---|
To: | "seapug(at)postgresql(dot)org" <seapug(at)postgresql(dot)org> |
Subject: | submitted a talk to GIS conference in Lynwood |
Date: | 2013-02-12 14:13:10 |
Message-ID: | 1686551.LP6kuYLdA1@wolf |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | seapug |
FYI:
Robert
============================================================
URL submittion link: http://www.waurisa.org/conferences/Abstract_submissions/Abstracts_submit.php
============================================================
Presenter: Robert Bernier
email: robert7390(at)comcast(dot)net
phone: 206-407-9298
job title: PostgreSQL Business Intelligence Analyst
Agency: Medio Systems Inc./Operations Dept
Biography:
Introduced to computers in the 1960s, he programmed in FORTRAN on a mainframe with 4MB RAM. In the 80s, he helped introduce IT into his undergraduate program. In 1995, Robert took up Linux and was part of the rush leveraging the Internet, eventually focusing his open source activities on Postgres. Robert has presented at conferences, written dozens of articles, contributed to books and consulted and trained defense contractors, Fortune 100 companies, research centers and universities. Currently, he volunteers at Earth Economics, http://www.eartheconomics.org. His day job is Medio Systems specializing in big data and predictive analytics in the mobile industry.
Length of presentation: 60 minutes
User level: New, Intermediate, Advanced
Presentation Title: The Path Not Taken; A primer to PostGIS.
Abstract:
People have often thought that leveraging GIS technology implied learning how to work a menu driven, proprietary, industry standard, and often expensive, application. While the ability of rendering data into the desired graphical representation is obvious, equally important is the ability to understand alternate means of expressing GIS relations thus allowing us to ponder edge cases that would not otherwise be easily expressed, let alone resolved.
There is another way to explore and understand GIS issues: these last few years have not only seen an explosion of capacity and features on the frontend applications but backend, i.e. the database, as well.
This talk introduces you to the spatially enabled, opensource and free database, PostGIS.
The following concepts will be covered and demonstrated:
- Installation of PostgreSQL
- Enabling GIS
- Understanding the GIS functions used in PostgreSQL
- Getting results by executing SQL
- Loading shapefiles
- Examples
Working with a database can be no more difficult than using a graphically based application. However, it does require a different way of looking at your data. The only real challenge is shifting your viewpoint from one way of look at GIS to another.
From | Date | Subject | |
---|---|---|---|
Next Message | Robert Bernier | 2013-02-12 14:18:28 | SEAPUG website |
Previous Message | Paul English | 2013-02-11 03:56:17 | Registration open for Cascadia IT Conference 2013 |