Botswana Geocode Database v.1.0.0

1,428 Database Records

---

• VIEW SAMPLE DATA RECORDS
• FIELD STATISTICS & DATABASE SCHEMA
• RECORD INFORMATION & STATISTICS
• ABOUT This Database
• UNDERSTANDING LICENSE TYPES
• DATA LISTS FAQ
• ABOUT COUNTS
• ABOUT FILE TYPES

License Database Purchase Options

	USAGE RIGHTS $20.00	PUBLICATION RIGHTS $80.00	MASTER RIGHTS $160.00
Data Tracking Seeds
Data Modification
Importing
Exporting
Merge
Web Usage
Multiple PC's or Websites
Mobile Development
Updates Available
All Data File Formats
Custom File Formats
Distribution
Copyright Endorsement
	BUY NOW	BUY NOW	BUY NOW

This Geocode database for Botswana contains the geographic features of Botswana. Dataset Includes the Latitude and Longitude of Each Geographic Feature. This dataset is Perfect for Geocoding Applications. Database also contains all Feature Classification for Administrative regions, Populated places, Vegetation, Locality or area, Undersea, Streets, highways, roads, or railroad, Hypsographic, Hydrographic and Spot feature locations.

---

The Republic of Botswana is a landlocked nation in Southern Africa. Formerly the British protectorate of Bechuanaland, Botswana adopted its new name after becoming independent within the Commonwealth on September 30, 1966. It is bordered by South Africa to the south, Namibia to the west, Zambia to the north, and Zimbabwe to the northeast. The economy, closely tied to South Africa's, is predominated by mining, especially diamonds; cattle; and tourism. The country is named after its largest ethnic group, the Tswana.

Table Schema Database Field Statistics

• Region Code
• Unique Feature Identifier
• Unique Name Identifier
• Unique Geospatial Reference Coordinate (GRC) Identifier
• Latitude
• Longitude
• Universal Transverse Mercator
• Joint Operations Graphic
• Feature Classification
• Feature Designation Code
• Populated Place Classification
• Primary Country Code
• First Order Division
• Full Name
• Short Name
• Description
• Type. See Record Information Below for full field descriptions.

Sample Data 1,428 Total Records

An Excel Speadsheet has been created with some sample data from this database. You can download this sample spreadsheet here: Botswana Geocode Database

Records Information

Field Name	Field Description	Field Type	Maximum Field Length
RC	Region Code.  A code that determines the character mapping used in the Full_Name field: 1 = Western Europe/Americas; 2 = Eastern Europe; 3 = Africa/Middle East; 4 = Central Asia; 5 = Asia/Pacific; 6 = Vietnam.	number	1 Digit
UFI	Unique Feature Identifier.  A number which uniquely identifies the feature.	number	± 10 Digits
UNI	Unique Name Identifier.  A number which uniquely identifies a name.	number	± 10 Digits
UGI	Unique Geospatial Reference Coordinate (GRC) Identifier.  A number which uniquely identifies a GRC.  A GRC is a set of multiple coordinates identifying a feature (in most cases the feature would be linear in nature).  This field is not normally selected by default.	number	± 10 Digits
LAT	Latitude of the feature in ± decimal degree (WGS84): no sign (+) = North; negative sign (-) = South.	number	± 2.15 Digits
LONG	Longitude of the feature in ± decimal degree (WGS84): no sign (+) = East; negative sign (-) = West.	number	± 3.14 Digits
DMS_LAT	Latitude of the feature in ± degree, minuets, and seconds (WGS84): no sign (+) = North; negative sign (-) = South.	number	± 6 Digits
DMS_LONG	Longitude of the feature in ± degree, minuets, and seconds (WGS84): no sign (+) = East; negative sign (-) = West.	number	± 7 Digits
UTM	Universal Transverse Mercator coordinate grid reference.	character	4 Characters
JOG	Joint Operations Graphic reference.	character	7 Characters
FC	Feature Classification: A = Administrative region; P = Populated place; V = Vegetation; L = Locality or area; U = Undersea; R = Streets, highways, roads, or railroad; T = Hypsographic; H = Hydrographic; S = Spot feature.	character	1 Character
DSG	Feature Designation Code.  A two to five-character code used to identify the type of feature a name is applied to.	character	5 Characters
PC	Populated Place Classification.  A graduated numerical scale denoting the relative importance of a populated place.  The scale ranges from 1,  relatively high, to 5, relatively low.  The scale could also include NULL (no value) as a value for populated places with unknown or undetermined classification.	number	1 Digit
CC1	Primary Country Code.  A two alphabetic character code uniquely identifying a geopolitical entity (countries, dependencies, and areas of special sovereignty).	character	2 Characters
ADM1	First-order administrative division.  A two alphanumeric character code uniquely identifying a primary administrative division of a country, such as a state in the United States.	character	2 Characters
ADM2	Second-order administrative division.  The name of a subdivision of a first-order administrative division, such as a county in the United States.	variable character	200 Characters
POP	Population Figures.	number	10 Digits
ELEV	Elevations (in meters, decimal values accepted).	number	± 22 Digits - floating decimal point
CC2	Secondary Country Code.  A two alphabetic character code uniquely identifying the country code of a particular name if different than that of the feature.	character	2 Characters
GCC	Geospatial Reference Coordinate (GRC) Country Code. A two alphabetic character code uniquely identifying the country code of a particular name of a GRC.  This field is not normally selected by default.	character	2 Characters
NT	Name Type: C = Conventional; D = Not verified; N = Native; V = Variant or alternate.	character	1 Character
LC	Language Code.  A two alphabetic character code uniquely identifying a language of  a country if multiple official languages are used.	character	2 Characters
SHORT_FORM	A specific part of the name that could substitute for the full name.	variable character	128 Characters
GENERIC	The descriptive part of the full name (does not apply to populated place names).	variable character	128 Characters
SORT_NAME	A form of the full name which allows for easy sorting of the name into alpha-numeric sequence.  It is comprised of the specific name, generic name, and any articles or prepositions. This field is all upper case with spaces, diacritics, and hyphens removed and numbers are substituted with lower case alphabetic characters.	variable character	200 Characters
FULL_NAME	The full name is a complete name which identifies the named feature.  It is comprised of  the specific name, generic name, and any articles or prepositions.	variable character	200 Characters
FULL_NAME_ND	Same as the full name but the diacritics and special characters are substituted with Roman characters ND = No Diacritics / Stripped Diacritics.	variable character	200 Characters
MOD_DATE	The date a new feature was added or any part of an existing feature was modified (YYYY-MM-DD).  This field is not normally selected by default.	date-time	10 Characters