Data Types for importing the GeoNetMap into MS SQL.

[ Home ]

Data Types for importing the GeoNetMap into MS SQL.

Countries.txt

Field Name	Suggested Data Type	Size

CountryId	int	4

Country	varchar	128

FIPS104	varchar	2

ISO2	varchar	2

ISO3	varchar	3

ISON	varchar	3

Internet	varchar	2

Capital	varchar	25

MapReference	varchar	50

NationalitySingular	varchar	35

NationalityPlural	varchar	35

Currency	varchar	30

CurrencyCode	varchar	3

Population	BigInt	8

Title	varchar	50

Comment	varchar	2048

Regions.txt

Field Name	Suggested Data Type	Size

RegionId	int	4

CountryId	int	4

Region	varchar	128

Code	varchar	2

ADM1Code	varchar	4

Cities.txt

Field Name	Suggested Data Type	Size

CityId	int	4

CountryId	int	4

RegionId	int	4

DmaId	int	4

City	varchar	128

Longitude	float	8

Latitude	float	8

TimeZone	varchar	32

Code	varchar	4

Dmas.txt

Field Name	Suggested Data Type	Size

DmaId	int	4

CountryId	int	4

Dma	varchar	3

Market	varchar	128

Subnets.txt

Field Name	Suggested Data Type	Size

SubNetAddress	varchar	11

Certainty	int	4

CityId	int	4

RegionId	int	4

CountryId	int	4

DmaId	int	4

Nbc.txt

Field Name	Suggested Data Type	Size

CityId	int	4

PrimaryCityId	int	4

Distance	int	4

ProxyNetworks.txt

Field Name	Suggested Data Type	Size