Home ]

                                           

Up

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