Hands On Workshops
The City of Mesa offers a 2-day ArcGIS 10 course. At the 2013 AGIC Symposium Instructor Randy Booze provided a half-day version of this course to attendees. To learn more about this course, download the course overview document by clicking the download button below.
The City of Mesa 2-Day class provides an introduction to GIS concepts and the ESRI ArcGIS 10 software with a great deal of hands on experience with the ArcGIS 10 software. Participants in the class will learn how to use the ESRI ArcMap™ and ArcCatalog™ applications as well as the geoprocessing tools within the ArcToolbox™ while applying the technology in various applications. The Instructor also discusses real world applications of the technology based on student interests and requested areas of focus as well as a review of some of the advanced features that are available in GIS technology. The topics covered in the 2-Day class include:
- GIS Concepts and Data
- Working with GIS Maps and Data Displaying GIS Data
- Getting Information about GIS Features
- Analyzing GIS Feature Relationships
- Creating and Editing GIS Data
- Presenting GIS Data
- Creating Geoprocessing Models
- Legal Issues in GIS Use
In the mid 1990s, several RDBMS vendors began offering spatial data types as object-relational technologies advanced. Microsoft entered the game with its SQL Server 2008 release. These were significant developments; it meant that GIS professionals could do many important GIS tasks at the database level more efficiently through SQL scripting!
This workshop will cover:
1) Advantages of the database approach to GIS
2) SQL Server Management Studio
3) Building spatial layers (tables and indexes) in MS SQL Server
4) Spatial data loading
5) Spatial data QC
6) Spatial data analysis
7) Spatial data publishing
8) Consuming and presenting spatial data stored in SQL Server using ArcGIS
Basic knowledge of GIS and RDBMS;
Basic SQL skills are not required but would be helpful.
In this workshop we will walk you through the basics of Census data and show you how to query the data in MS Access and then import it into your ArcMap project.
This workshop covers the following:
- Basic overview of Census data and Census Geography
- Difference between Census 2010 data and ACS data
- ACS data limitations
- Geographic Summary levels and how to determine appropriate one for a project
- Determining what Census data table and file you need
- Understanding the table structure
- Understanding the data “universe”
- Querying the data in Access
- Formatting the fields as needed
- Exporting the data for ArcGIS
- Adding the data into ArcMap
- Joining the table to Census shapefile
- Creating maps, spatial queries, etc.
Prerequisites: Attendees should have basic knowledge of MS Access and MS Excel. Basic instructions will be provided, however to get the most out of this 90 minute workshop attendees should know how to perform basic queries in Access and know how to search, filter, and sort in Excel.
File Contents: The zipfile includes the presentation, hands on exercise, student worksheet, and all data files needed to complete the hands on exercise. The data are an extract of Census data only, not the full dataset.