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

SubNetAddress	varchar	11

Network	varchar	50

PrivateAddresses.txt

Field Name	Suggested Data Type	Size

AddressPrefix	varchar	11

Geobytes Home Page

The Basics
	Using GeoSelect
	Find a Location Code
	Tag & Header Info


How To
	GeoSelect How-To


Code Examples
Geo Tag Examples


Sponsored Projects
Coming Soon!


FAQ's
	Technical FAQ's
	General Product FAQ's


Support
	Version Updates
	Geobytes Support Page
	Contact Support Team

Modified:09/19/05
© 2000 - 2002
geobytes, inc.
ARBN 091 652 961

Send mail to info@geobytes.com