Exporting an ArcGIS attribute table to a MySQL database

THIS SCRIPT IS CURRENTLY BROKEN (9-28-2007)

Abstract

This is a python script that was written as part of the Spring 2006 Urban Simulation graduate seminar. The script will take the attribute table of the user's choice (shapefile table, feature class, or a standalone .dbf or comma/tab delimited) and copy it to a new table in a specified MySQL database. This script depends on both the ArcGIS geoprocessing framework and Opus classes, therefore Opus must be installed and working properly. For instructions on obtaining, installing, and configuring Opus, see the Opus/UrbanSim documentation. This script is designed to be used as a tool within ArcToolbox.

Author: Jesse Ayers, Center for Urban Simulation and Policy Analysis, University of Washington, www.urbansim.org
First submitted on: July 26, 2006
Last modified on: July 27, 2006
Transferred to trac wiki July 22, 2007

Download

Instructions (as included in .zip file)

To use this script:

  1. Make sure both the .tbx and .py files are in the same directory; it does not matter where.
  2. In ArcToolbox, right-click>Add Toolbox... then browse to the .tbx file, then click "open."

See the help for the script (double-click script in ArcToolbox, then click "show help") for some help on how to use it. The code itself is also fairly well documented.

The script's user interface looks like this:

Attachments