TDR Home page Help Pages for Searching, Finding and Using Data Web-Accessible Data Owned and Maintained Locally Licence Agreements - Restrictions on Use of Locally Owned Data Send Questions and/or Comments to TDR Staff

IMPORTING FILES INTO GEOGRAPHIC INFORMATION SYSTEMS (GIS)

Definition of GIS - Arc/Info Export Format - Arc/Info - ArcView - MapInfo - Atlas GIS - Idrisi - Spans

All descriptions of importing procedures are based on intial testing of this system. Users with extensive knowledge of GIS systems are welcome to contact the DRC with suggestions during this initial phase of development.

Definition:
A GIS is a computer system for capturing, storing, checking, integrating, manipulating, analysing and displaying data related to positions on the Earth's surface. Typically, a Geographical Information System (or Spatial Information System) is used for handling maps of one kind or another. These might be represented as several different layers where each layer holds data about a particular kind of feature. Each feature is linked to a position on the graphical image of a map.
 

 
Layers of data are organised to be studied and to perform statistical analysis. Uses are primarily government related; town planning, local authority and public utility management, environmental, resource management, engineering, business,marketing, and distribution. (Source of Text and Graphic:by http://www.geo.ed.ac.uk/agidexe/ )

Go Back to Top

Arc/Info Export Format

ArcInfo export format is an uncompressed ASCII file which is a de facto standard today. Most GIS programs can read this type of file. It contains the spatial topology and linked tables with attribute information. A part of the census file for Guelph is shown below as an example:

EXP 0 GEO2:[GEOBASE91.LATLONG.CT91]CA550_CT91.E00
ARC 2
1 -1 1 2 1 2 38
-8.0276131E+01 4.3643623E+01-8.0276733E+01 4.3644089E+01
-8.0281616E+01 4.3647766E+01-8.0292519E+01 4.3655270E+01
-8.0292839E+01 4.3655499E+01-8.0294373E+01 4.3656525E+01
-8.0295166E+01 4.3657124E+01-8.0310562E+01 4.3668373E+01
-8.0323265E+01 4.3677536E+01-8.0335762E+01 4.3686817E+01
-8.0335526E+01 4.3687027E+01-8.0331879E+01 4.3690258E+01
-8.0326622E+01 4.3694923E+01-8.0315193E+01 4.3704861E+01
.........
CA550_CT91.BND XX 4 4 16 1
XMIN 4-1 14-1 12 3 60-1 -1 -1-1 1-
YMIN 4-1 54-1 12 3 60-1 -1 -1-1 2-
XMAX 4-1 94-1 12 3 60-1 -1 -1-1 3-
YMAX 4-1 134-1 12 3 60-1 -1 -1-1 4-
-8.0373825E+01 4.3468117E+01-8.0085770E+01 4.3751911E+01
CA550_CT91.PAT XX 7 8 27 22
AREA 4-1 14-1 12 3 60-1 -1 -1-1 1-
PERIMETER 4-1 54-1 12 3 60-1 -1 -1-1 2-
CA550_CT91# 4-1 94-1 5 0 50-1 -1 -1-1 3-
CA550_CT91-ID 4-1 134-1 5 0 50-1 -1 -1-1 4-
CA 3-1 174-1 3-1 20-1 -1 -1-1 5-
CT_NAME 6-1 202-1 6-1 20-1 -1 -1-1 6-
PROV 2-1 264-1 2-1 30-1 -1 -1-1 7-
CA_CTNAME 9-1 170-1 9-1 20-1 -1 -1-1 -1-
Type of Attribute File ( Polygon Attribute Table) or AAT, number of attributes (8), the number of attributes actually present(7) and the number of attribute records(22)

The first column is the field identifier e.g. AREA, PERIMETER

Column 4 sometimes specify the field width

The next column specifies the data type of the field by a two - digit integer.

 

-4.2145599E-02 1.0379447E+00 1 0 0
2.1104667E-02 6.4333373E-01 2 2842550100.0035
9.5332535E-03 4.5012802E-01 3 2843550014.0035
2.8064002E-03 2.2712950E-01 4 2844550004.0035
6.1631063E-04 1.0554227E-01 5 2845550013.0235
..................
This is part of the CT E00 file of Guelph.

Go Back to Top


ArcInfo

To Import ArcExport Files (.E00) into ArcInfo:

  1. Execute the EXE - file to obtain the E00 file on a Dos/Windows machine
  2. Import this file into ArcInfo using the command IMPORT. <<IMPORT input.E00 cover>>
  3. Note: If you work with a UNIX system you need to convert the LF/CR signs into a Unix - format. Therefore use the program DOS2UNIX at the DOS- level. Download it from http://www.math.uiowa.edu/ftp/dos/ <<DOS2UNIX import.E00 output.E00>>
  4. Notice: You can do this step also on the UNIX- system with the command on
    • HP --- dos2ux
    • IBM -- dosread
    • SGI -- to_unix
    • SUN -- dos2unix

    or if the command is not there, with the following combination:

    cat dos_file | tr -d "\015\032" > new_file

Go Back to Top


ArcView

To Import ArcExport Files (.E00) into ArcView:

  1. Execute the EXE - file to obtain the E00 file
  2. Import this file into ArcView using the program IMPORT. ( it should be in the program group Arcview) << IMPORT import.E00 cover_name>>
  3. Note: The IMPORT command works only properly, if the E00 file and the import program files are in the same directory. (ArcView Version 2.0)

Go Back to Top


MapInfo

To Import ArcExport Files (.E00) into MapInfo:

  1. Execute the EXE - file to obtain the E00 file
  2. -this section is under testing - more information to follow

Go Back to Top


Atlas GIS

To Import ArcExport Files (.E00) into Atlas GIS:

  1. Execute the EXE - file to obtain the E00 file
  2. Convert this file into ATLAS format (*.agf etc.) using the program IE (Import Export). Atlas IE will handle double and single precision files. Based on the fact that E00 files can contain more than one feature, for example arcs and polygons, several imports may need to be done. IE can handle only one feature type (point, line, region) at a time.Note: files can be merged later in Atlas. IE creates a unique ID for each feature by combining the base portion of the ArcInfo filename with an R (region), L(line) or P(point) and a sequential number. The other internal attributes are assigned after the following schemata: internal ID (covname# ) is placed in the _NAME field, the user-ID in the _NAME2 field. Area and Length are calculated by Atlas. If desired other values can be placed in _NAME etc. through a field translation file.
  3. Several options are available for the import program:

    IE00 specifies that Import file is ArcInfo Export file
    TYPE sss sss is the type of feature(polygons, arc,points) which is imported
    COORD sss sss is the name of the coordinate system - default is latitude/longitude
    LAYER sss sss is the name of the layer transmission file - specifying the atlas layer name for the imported features
    ATT sss sss is the name of the atlas attribute file that is automatically created to contain external attributes
    FIELD sss sss is the name of the field translation file that allows to direct ArcInfo fields to the desired Atlas fields

  4. The format of the command is the following: <<ie import.E00 output_cover /att extra_tab /field translation_file >>
Field Translation File (FTF): allows control over which ARC attribute is imported to which Atlas internal or external attribute. It is a simple ASCII file. It is possible to override the default settings: specify field for _NAME, _NAME2; specify field characteristics (decimal places etc. and ignored fields. Format of a FTF is the following:
Source Field Target Field Type Size # of Dec. Long Description
  • source field - name of E00 field
  • target field - name of atlas attribute field
  • type of data in E00 : c - character, n - numeric, d - date, l - logical
  • size - specify the number of characters allowed for the field - by date 8, by logical 1, max for numerical fields is 19, character field max is 254.
  • # of Decimals - number of spaces after the decimals by numerical data, otherwise place a zero or asterisk
  • Long description - a more detailed description of the field.
Layer Transmission File(LTF): allows user to specify the name of a created layer rather than a default name. It is a simple ASCII file, which contains 2 columns. In the left column the ArcInfo layer name and in the right column the Atlas layer name. If a LTF is not specified, the IE program names the layer the same as in the ArcInfo file.
(Source: Atlas Import /Export,1993)

Go Back to Top


Idrisi

To Import ArcExport Files (.E00) into IDRISI:

  1. Execute the EXE - file to obtain the E00 file
  2. Direct ArcInfo to IDRISI conversion for vector files only works with the UNGEN Procedure in ArcInfo, thereby Polygon Data (DLG Format), Line Data with Attributes and Line and Point Data without Attributes can be exported. As a result, the E00 files would have to be imported into ArcInfo and then exported with the UNGEN command.
  3. Import this file into Idrisi using the program module import >software specific formats > ARCIDRIS.
  4. ARCIDRIS requires that you indicate whether the conversion will be from Arc/Info to IDRISI for Windows or vice versa. If the conversion is going from Arc/Info to IDRISI for Windows, specify the feature type of the UNGEN file, either points (label) or lines (arc). The default is set to points. Then input the names of the Arc/Info UNGEN file and the IDRISI for Windows output vector file involved. Specify a reference system and reference units. Click on the down arrows next to the input boxes for a list to choose from or type your choices in manually. Finally, specify a unit distance. The default settings are plane, meters, and 1 respectively.
  5. Note: For further description about this procedure refer to the Idrisi Help manual.
  6. Note:An easier way may be the following workaround: Import the files you need into Atlas GIS and then export the files from there as BNA files.Then import these into IDRISI using ATLIDRIS.

Go Back to Top


Spans

To Import ArcExport Files (.E00) into SPANS GIS:

  1. Execute the EXE - file to obtain the E00 file
  2. Use the VECTOR INTERFACE MODULE(VIM) to import ArcInfo export file into SPANS GIS vector (.VEH/.VEC) and attribute files (.TBA). The program can use the following ArcInfo features: ARC (arcs), PAL(areas),LAB(label points), TXT(text points), CNT(centroids), AAT(arc attributes) and PAT(area attributes).
  3. Start the VIM and select the E00 file. The following options are available:
    record length - end of line sequence - Enter a value that is larger than the maximum line length including EOL,CR or LF. In most cases 82 should be enough.
    record length - fixed length - each record has fixed length and is not terminated by EOL. Enter record length.
    arc attributes Highlight the attributes to be imported, or Select All
    areas attributes Highlight the attributes to be imported, or Select All
    new Spans vector file Enter the name for SPANS vector file (include arcs,areas and points
    new arc attribute file Enter the name for Spans arc attribute table (AAT to TBA). Selected features will be transformed.
    new areas attribute file Enter the name for Spans area attribute table (PAT to TBL). Selected features will be transformed.
    new label point table file Enter the name for Spans label point table file (LAT to TBP). Selected features will be transformed.
    new text point table Enter the name for Spans text point table file (TXT to TBT). Selected features will be transformed.
    new centroid table file Enter the name for Spans centroid table file (CNT to TBC). Selected features will be transformed.
Note: * By Default SPANS will always use the ArcExport filename. * The data file PAT.INP must be present in SPANS system directory !

5) Be sure that your file is decompressed, before using the VIP. Use IMPORT / ArcExport / Decompress to decompress FULL(Format 1) and PARTIAL(Format 2) compressed E00 files. The resulting file extension will be *.EXP. For Format 3 use IMPORT / ArcExport / Decompress (II).

 

 

Home Help TDR Data Contact Us Site Map Licences