spacer image spacer image spacer image spacer image
The ITIS Logo The banner for the ITIS Data Access pages spacer image
The ITIS Navigation Section spacer image
Graduated Blue Bar spacer image

A version of the full ITIS database is available for downloading via HTTP.

We create database dump files once a month as new data are added to ITIS. The updated files are posted near the end of each month at:
  http://www.itis.gov/downloads.

Note: You must have your own database server installed and running to use these files.

The basic steps to access and use the files are:

  1. Select the appropriate file for your database (Informix, MySql, or MS SQL Server).
  2. Download and extract the file on the system you will use to load the database.
  3. Use the instructions contained in the download's readme file to create and load the database on your system.
  4. You should now be able to access the data via your local database system.

Notes:

  • For Informix, a Linux tar command
    "tar cfz itisInformix.tar.gz itis.mmddyy"
    was used to create a compressed tar file with all the ISO Latin 1 (ISO 8859-1) files associated with the database, where mmddyy is the month, day and year the file was created.
  • For MS Sql Server, a zip command
    "zip itisMSSql.zip itisMS.mmddyy"
    was used to create a tar file with all the ISO Latin 1 (ISO 8859-1) files associated with the database.
  • The MySql bulk load SQL script (ITIS.sql) was created with the mysqldump command. The zip file was then created with a zip command
    "zip itisMySQLBulk.zip itisMySQLmmddyy"
    Data in this file uses the ISO Latin 1 (ISO 8859-1) representation.
  • The MySql load by tables file was created with a Linux tar command
    "tar cfz itisMySQLTables.tar.gz itisMySQLmmddyy"
    was used to create a compressed tar file with all the ISO Latin 1 (ISO 8859-1) files associated with the database
  • For the Informix and MySql files, the end-of-line character on all these files is the new line (LF) or (\n) character.
  • For the MS Sql Server zip file, the end-of-line characters on all files is the carriage return and newline (CR LF) or (\r\n) characters.
  • About Diacritical Characters: All diacritical characters in ITIS have been modified to reflect their ISO Latin 1 (ISO 8859-1) representation.
spacer image
spacer image
A gray bar
Last Updated: Thursday, 25-Aug-2011 14:36:50 MDT
http://www.itis.gov/ftp_download.html  
Link to the ITIS What's New Page Link to more information about the ITIS Project Query the ITIS database; produce reports Information about submitting data to ITIS Link to a menu of ITIS-related tools Bee Checklist NBII Links Link to ITIS Web Services Send Your Comments Return to the ITIS Home Page