MCCCD Program Description

Introduction to ArcPy Scripting

Course: GIS220

First Term: 2017 Fall

Lecture 3 Credit(s) 3 Period(s) 3 Load
Subject Type: Academic
Load Formula: S- Standard

Description: Students will learn how to automate geoprocessing tasks and apply scripting fundamentals using the ArcGIS Python-based scripting language ArcPy. The course emphasizes problem solving using geoprocessing analysis, identifying system integration and data management tasks, determining programming tools and order based upon workflow analysis.

MCCCD Official Course Competencies
1. Identify the Python development environments. (I) 2. Describe the relationship among ModelBuilder, ArcGIS, and Python. (I) 3. Identify Python syntax and ArcGIS error codes and messages. (I) 4. Apply fundamental Python syntax. (I) 5. Import Modules into the Python shell. (I) 6. Create try and except blocks. (I) 7. Create and apply fundamental data types. (I) 8. Create pseudo-code to outline geoprocessing tasks. (I) 9. Define parameters using variables. (I) 10. Add and modify geoprocessing functions. (I) 11. Apply basic query syntax. (II) 12. Create a feature layer and table views. (II) 13. Program the SelectLayerByAttribute routine. (II) 14. Program the SelectLayerByLocation routine. (II) 15. Count the number of records in a selection set. (II) 16. Implement cursor types. (II) 17. Identify attribute indexes. (II) 18. Describe and list data programmatically. (II) 19. Implement the Mapping Module Class properties, methods, and functions. (II) 20. Associate a Python script to a custom toolbox. (III) 21. Customize and execute a script tool. (III) 22. Create and schedule a batch file. (III)
MCCCD Official Course Competencies must be coordinated with the content outline so that each major point in the outline serves one or more competencies. MCCCD faculty retains authority in determining the pedagogical approach, methodology, content sequencing, and assessment metrics for student work. Please see individual course syllabi for additional information, including specific course requirements.

MCCCD Official Course Outline
I. The Fundamentals: Python, ArcGIS, and ArcPy A. Python within ArcGIS B. Python development environments C. ModelBuilder D. Python shell E. Scripts and geoprocessing tools F. Help G. Errors H. Handling errors I. Python constructs II. Writing Python scripts for common geoprocessing tasks A. Querying and selecting data B. Creating and using cursors and table joins C. Describing data and operating on lists D. Custom error handling and creating log files E. Mapping module III. Integrating and automating Python scripts for ArcGIS A. Custom ArcGIS tools and Python scripts B. Automating geoprocessing scripts

MCCCD Governing Board Approval Date: February 28, 2017

All information published is subject to change without notice. Every effort has been made to ensure the accuracy of information presented, but based on the dynamic nature of the curricular process, course and program information is subject to change in order to reflect the most current information available.