ArcGIS Desktop

  • ArcGIS Pro
  • ArcMap

  • My Profile
  • Help
  • Sign Out
ArcGIS Desktop

ArcGIS Online

The mapping platform for your organization

ArcGIS Desktop

A complete professional GIS

ArcGIS Enterprise

GIS in your enterprise

ArcGIS Developers

Tools to build location-aware apps

ArcGIS Solutions

Free template maps and apps for your industry

ArcGIS Marketplace

Get apps and data for your organization

  • Documentation
  • Support
Esri
  • Sign In
user
  • My Profile
  • Sign Out

ArcMap

  • Home
  • Get Started
  • Map
  • Analyze
  • Manage Data
  • Tools
  • Extensions

How data converts when importing

  • Importing ArcGIS Desktop Advanced coverages
  • Importing Esri shapefiles
  • Importing CAD data
  • Importing existing data into the geodatabase

When you import data that is in a format not used by the geodatabase, ArcGIS automatically converts it into data types used by the geodatabase. The following describes how different formats are converted during the importing process.

Importing ArcGIS Desktop Advanced coverages

When you import coverages and INFO tables into the geodatabase, ArcGIS automatically converts the coverage geometry and fields to types used by the geodatabase. This section describes how coverages are converted into geodatabase content.

All feature class types within ArcGIS Desktop Advanced coverages convert to one of four fundamental geometry types in the geodatabase (points, lines, polygons, or annotation). Each coverage feature class becomes a new geodatabase feature class. For example, point feature classes, tic feature classes, and node feature classes all convert to separate point feature classes in the geodatabase. The following table illustrates how feature class types convert to geodatabase geometry types.

Coverage feature class

Geodatabase geometry

Point

Point

Arc

Line (polyline)

Polygon

Polygon

Node

Point

Tic

Point

Region

Polygon

Route

Line (polyline) with measures

Annotation

Annotation

This table illustrates how feature class types convert to geodatabase geometry types.

All attribute types in coverages and INFO tables convert to field types in the geodatabase. Coverage and INFO table items convert based on a combination of their type and width. For example, you can map an item type to a short integer, long integer, or double, depending on its width. The following table summarizes how items convert.

INFO item type

INFO item width

Geodatabase field type

B

4

Long integer

C

1–320

Text

D

8

Date

F

4

Float

F

8

Double

I

1–4

Short integer

I

5–9

Long integer

I

10–16

Double

N

1–9

Float

N

10–16

Double

This table summarizes how items convert.

Coverages contain several fields that are relevant to the coverage data model only and are not maintained by the geodatabase; therefore, you should determine if you want to import them.

The following is recommended in most cases:

  • When importing polygon or point coverages, don't import <cover#>, AREA, or PERIMETER.
  • When importing line coverages, don't import <cover#>, RPOLY#, LPOLY#, FNODE, TNODE, or LENGTH.
  • If the coverage you're importing doesn't use the <cover-ID> field to relate to another table, don't import this field.

Importing Esri shapefiles

When you import shapefiles and dBASE tables into the geodatabase, ArcGIS automatically converts the shapefile geometry and fields to types used by the geodatabase. This section describes how shapefiles are converted into geodatabase content.

The geometry types for points, lines, and polygons in Esri shapefiles are similar to the corresponding geodatabase feature class types. Therefore, importing shapefile datasets into geodatabases is relatively straightforward.

All feature types in shapefiles convert to geometry types in the geodatabase as denoted in the following table.

Shapefile feature class

Geodatabase geometry

Point

Point

Point M

Point with measures

Point Z

Point with z-values

Polyline

Line (polyline)

Polyline M

Line (polyline) with measures

Polyline Z

Line (polyline) with z-values

Polygon

Polygon

Polygon M

Polygon with measures

Polygon Z

Polygon with z-values

Multipoint

Multipoint

Multipoint M

Multipoint with measures

Multipoint Z

Multipoint with z-values

Multipath

Multipath

This table shows how shapefile feature classes are converted to geodatabase geometry.

Each shapefile and dBASE field type converts to a single geodatabase field type, except for the Number type field. The following table summarizes how shapefile and dBASE field types convert.

Field type

Field width

Geodatabase field type

Date

NA

Date

String

1–255

Text

Boolean

NA

Short integer

Number

1–4 (decimals=0)

Short integer

Number

5–9 (decimals=0)

Long integer

Number

10–19 (decimals=0)

Double

Float

1–13

Float

Float

14–19

Double

Number

1–8 (decimals>0)

Float

Number

9–19 (decimals>0)

Double

This table summarizes how shapefile and dBASE field types convert.

Importing CAD data

When you import computer-aided drafting (CAD) data files into the geodatabase, ArcGIS automatically converts the CAD geometry and fields to types used by the geodatabase. See Import from CAD (conversion) to read how CAD elements are converted into geodatabase content.

Importing existing data into the geodatabase

If you have been a longtime user, you may have legacy datasets that need to be imported into the geodatabase. For example, you may have previously loaded data into an enterprise database using a command such as shp2sde.

Or perhaps you have written a C program to load data that uses the C application programming interface (API).

The process used to add these existing datasets to the geodatabase is straightforward. It is not so much a process to import the existing dataset as it is one where you register the dataset with the geodatabase.

Registering existing data in ArcCatalog or the Catalog window

  1. In the Catalog tree, right-click the table or feature class you want to register with the geodatabase.
  2. Click Register with Geodatabase.

Registering a layer or table adds an ObjectID field to the table. This field name is OID for tables and FID for feature classes. If an OID or FID field already exists in the table or layer, then another name is automatically added to the registered table.

Importing data to a personal geodatabase

When you import a feature class from an enterprise geodatabase into a personal geodatabase, any text fields that contain more than 255 characters are created as memo fields in Microsoft Access. Personal geodatabases interpret this memo field as a BLOB and set the field length in ArcGIS to 2,147,483,647 characters. This could have implications if you later attempt to copy this feature class from the personal geodatabase to another enterprise geodatabase. Most database management systems do not support text fields of this length.

ArcGIS Desktop

  • Home
  • Documentation
  • Support

ArcGIS

  • ArcGIS Online
  • ArcGIS Desktop
  • ArcGIS Enterprise
  • ArcGIS
  • ArcGIS Developer
  • ArcGIS Solutions
  • ArcGIS Marketplace

About Esri

  • About Us
  • Careers
  • Esri Blog
  • User Conference
  • Developer Summit
Esri
Tell us what you think.
Copyright © 2021 Esri. | Privacy | Legal