[Mapserver-users] OT: ArcInfo Field Types

[Lowell Filak]

*** INFO Item Types:

Item type 	Internal width  	Description 	
B(Binary) 	1-4 bytes 	Number stored as binary integer. No decimal
positions are allowed. 	
C(Character)  	1-4,096 bytes 	Fixed-length character string. 	
D(Date) 	8 bytes 	Date item stored internally as YYYYMMDD. Input and
output formats can be user defined. The default format is MDY/. See the
DFMT command for information about date formats. 	
F(Floating) 	4-8 bytes 	Number stored in floating-point format. 	
I*(Integer) 	1-16 bytes (digits) 	Integer item. No decimal positions are
allowed. INFO stores integer items as character strings and can hold
values up to 16 digits long ranging from a maximum of
9,999,999,999,999,998 to a minimum of -999,999,999,999,999.Precision is
maintained within INFO up to 14 significant digits.Note: ARC stores
integer items as 1 byte per digit. The range is -2,147,483,648 to
2,147,483,647. 	
L*(Lead-fill Number) 	1-16 bytes (digits plus decimal point) 	Number
that will be left-padded on output with the current LCHAR characters,
including the decimal point. 	
N*(Number) 	1-16 bytes (digits plus decimal point) 	Number with decimal
places. Can have up to 16 characters, including the decimal point. 	
O*(Overpunch on Output) 	1-16 bytes (digits) 	Number that will be
overpunched over the last digit on output. Can have up to 16 decimal
positions with a decimal point implied. 	
P*(Packed) 	1-8 bytes (packed digits) 	Number stored in packed decimal
format with trailing sign. Byte 1 holds one digit. Each subsequent byte
holds up to two additional digits. Can have up to 15 decimal positions
with the decimal point implied. 	
T*(Trailing Sign, Zero Fill) 	1-16 bytes (digits plus sign) 	Number
stored in external decimal format with trailing sign. Zero-filled on
output. Can have up to 14 decimal positions with n implied decimal point. 	
V*(Zero Fill) 	1-16 bytes (digits) 	Unsigned number stored in external
decimal format, zero-filled to the left. Can have up to 14 decimal
positions with an implied decimal point. 	

*  INFO maintains precision to 14 significant positions.


*** Default INFODBASE Data Type ConversionARC/INFO data types 	DBASE
data types 	

Type 	Width	Output	Dec 	 	 	
C 	n 	- 	- 	Character 	<expC> (n) 	
D  	- 	- 	- 	Date 	<expD> 	
B 	2 	- 	- 	Numeric 	<expN> (6,0) 	
B 	4 	- 	- 	Numeric 	<expN> (11,0) 	
I 	n 	- 	- 	Numeric 	<expN> (n,0) 	
N 	n 	- 	m 	Numeric 	<expN> (n,m) 	
F 	- 	n 	m 	Numeric 	<expN> (n,m) 	

When converting to an N type item, the total width will be at least two
digits greater than the number of decimal places, as required by dBASE.
 For example, an item defined as 1,1,I will become 2,N in the output
.dbf file.  DEFINE will not override this.

The following message was sent by aborruso at spaziogis.it on Fri, 25 Jul
2003 15:25:06 +0200.

> Dear user,
> where could I find a description of all types of table fields of ArcInfo 
> Info files?
> 
> Thank you,
> 
> Andrea
> 
>