Supercharge your GIS reporting skills with SQL Reporting Services and Reportlab, a python plug‐in

Site Archive
You are viewing a static copy of the 2013 Sunriver Conference website archived on December 11, 2013. To view current Northwest GIS User Group events and news visit nwgis.org.

This presentation will be an overview of two reporting tools available that may be unfamiliar: SQL Server Reporting Services (SSRS) and ReportLab. Summary reporting and feature listing/filtering will be demonstrated with SSRS examples. SSRS allows for direct SQL querying capabilities on a feature class in a report form. These reports can be generated without an ArcGIS license through a web interface. Once established, users can run reports looking at live data on their own without taking up your valuable time. Additionally, on-the-fly report generation will be demonstrated with a third party plug-in for Python, called ReportLab, which creates formatted reports with the final output being a PDF. Simple examples will be covered showing how reports are generated from the City of Bellingham’s web mapping application as a geoprocessing service running on ArcServer. The reports gather information related to survey monuments from several databases including lengthy history information, many photos, and all scanned related documents in one PDF generated in under 6 seconds. The presentation will provide information on how to get started using the tools along with some tips, tricks and issues to be aware of. PLEASE NOTE We will need 45 min - 60 min for this presentation.

Presenter(s): 
Ann Stark, GISP and Don Burdick, GISP, City of Bellingham, WA
Biography: 

Ann is a GIS Analyst at the City of Bellingham. She received her M.S. in Geography at Oregon State University and has 20 years of experience in natural resource and government applications of GIS. Her interests include automating GIS tasks with Python and cartography. She was a technical editor of the recently published "Programming ArcGIS 10.1 with Python Cookbook" and blogs about python related things at GISStudio.wordpress.com. Ann is also an active member of the GIS community, coordinating local user group meetings and is the current President of the WAURISA. You can find her on twitter at @StarkAnn. Don is an accomplished GIS project manager with extensive experience coordinating GIS activities, integrating workflow and business systems with GIS in local government and managing computer infrastructure and business systems within municipal government/public works. Don has over 25 years in the GIS/Engineering and survey fields.

Room: 
Homestead 3
When: 
October 17, 2013 - 4:00pm - 5:00pm
4.3
Your rating: None Average: 4.3 (10 votes)