Place Name Database 2015 TM

Complete Place Name database for the entire USA, with city, town, and township names, place FIPS codes, county names and FIPS codes, state abbreviations and FIPS codes, and MSA. More than 200,000 records!

Download Place Name database with city, town, and township names, county, and place FIPS codes information immediately!

Description
The Place Name Database contains the names of US cities, towns, counties, military bases, airports, federal facilities, national parks, prisons, branch post offices, Indian reservations, and other "populated places" as defined by the US Census Bureau and the US Government.

For each place name the database includes the place FIPS code, the state abbreviation and FIPS code, the county name and FIPS code, and the MSA (if any). FIPS stands for Federal Information Processing Standard, a data encoding standard defined and used by the US government.

The database contains more than 200,000 place name records, and is approximately 13 MB in size (uncompressed). The ASCII file can be searched using most text editors and word processors, or can be imported into most commercial database programs, such as Paradox, dBase, or Visual FoxPro.

Because this database is available as a simple text file, it can be used on almost every type of computer, including PCs and compatibles, Macintoshes, and UNIX workstations.

The database is available in comma delimited ASCII (CSV) format. It can be used on almost every type of computer, including PCs and compatibles, Macs, and UNIX workstations.

Record Layout
Field Type Length
Place Name Variable length text 104 characters max
State Code Fixed length text 2 characters
Census code Fixed length text 5 digits
Place Type Variable length text 15 characters max
Place Class Fixed length 2 alphanumeric characters
State FIPS Code Fixed length text 2 digits
County FIPS Code Fixed length text 3 digits
County Name Variable length text 29 characters max
County Number Numeric 2 digits max
Latitude Numeric 12 digits max
Longitude Numeric 13 digits max
Feature ID Numeric 10 digits max

Note that all FIPS fields and the MSA field are treated as text fields. This prevents the loss of leading zeroes in these fields when the data is imported into a database program.

The Place Name is the actual name by which the place is locally known. We have standardized spellings to eliminate abbreviations and alternate spellings where practical.

The State code is the normal two-letter abbreviation for the state, as assigned by the US Postal Service.

The Place FIPS code is a 5-digit numeric field containing a unique numeric identification assigned to each city, town, borough, village, or census district in a given state by the US government.

The Place Type field broadly defines the place as a city, town, or other entity. This is an interpretation of the Census Bureau place class code.

The Place Class is the specific definition of the place type, accoding to Census Bureau standards. We include with the database a list of Census Bureau place class codes.

The State FIPS code is a two-digit numeric code assigned by the US Government to each of the states and territories of the USA.

The County FIPS identifies a county which contains some portion of the place. The County FIPS Code is a 3-digit field containing a unique numeric identification assigned to each county in a given state by the US government. Note: if a place lies in more than one county, the County Count field contains a number greater than 1, indicating the number of different counties which contain some portion of the place.

The County Name field is the name of the county defined by the County FIPS field. Note that for Alaska, which has no counties, this name represents a "county equivalent" defined for statistical purposes by the Census Bureau.

The MSA/PMSA field contains the Metropolitan Statistical Area code or Primary Metropolitan Statistical Area code, if any, in which the place lies. The MSA/PMSA code is assigned by the Office of Management and Budget of the US Government. Note: only places which exist within defined "metropolitan" areas have an MSA or PMSA code. Most rural places do not have an assigned MSA/PMSA code. We include with the database a list of all MSA/PMSA codes.

The County Count field indicates the number of counties in which some portion of the place lies. For most places this count is one, indicating that the place lies entirely within a single county. A County Count greater than one means that the place crosses county boundaries and lies partially within multiple counties. This also means that the place name is represented in the Place Name Database by a group of similar place name records. There is one record for each county in which the place partially lies.

The County Number field indicates the record number within a group of records belonging to a place which exists in multiple counties.

Sample Records
Place Name
Addison
Addison
Addison
Addison
Addison
Addison
ST Code
AL
AL
CT
IL
KY
MI
Census Code
00484
90027
00240
00243
00370
00380
Place Type
Pop Place
MCD
Pop Place
Pop Place
Pop Place
Pop Place
Place Class
P1
Z5
U6
P1
P1
P1
ST FIPS
01
01
09
17
21
26
County FIPS
133
133
003
043
027
091
County Name
Winston
Winston
Hartford
DuPage
Breckinridge
Lenawee
County Number
1
1
1
1
1
1
Latitude
34.2023243
34.155103
41.7184328
41.931696
37.9161709
41.9864341
Longitude
-87.1814012
-87.2055675
-72.5767558
-87.9889556
-86.5649809
-84.3471684
Feature ID
159051
161625
205046
421692
510220
619840

Click here to download a self-extracting file containing sample records in Access 97 format (about 26 KB).

Click here to download a self-extracting file containing sample records in comma-delimited ASCII format (about 19 KB).

Available File Formats
Format Compression Download Size
Comma-delimited ASCII self-extracting 2.8 MB
Comma-delimited ASCII PKZip 2.04g 2.8 MB
Comma-delimited ASCII uncompressed 12.5 MB

Licenses
We offer different Licenses for the Place Name Database

Please read our License Overview to determine which license you need.


Prices
Place Name Database
Workstation License $99.95
Enterprise License: $199.95
Duplication Addendum:
up to 100 copies
unlimited copies

$399.00
$799.00

Prices subject to change without notice.

Delivery
Internet: Download Place Name Database immediately after you place your order online via our secure server. We'll include an invoice which states what you ordered and paid.

If you place your order via phone, fax or mail we will process your order usually within 1 business day. After we process your order we will send you an email message with the download information. We'll include an invoice which states what you ordered and paid.

No shipping and handling charges for Internet delivery.


CD-ROM:

Normally we process and ship all orders within 1 business day using the shipping method you chose. The following shipping and handling charges apply:
Surface (USA, First Class) $8.00
2nd Day Air (USA except AK/HI) $13.00
(Alaska/Hawaii) $20.00
(Canada) $35.00
Overnight (USA except AK/HI) $16.00
International (Air Mail) $20.00

Payment
All orders must be prepaid. We do not accept Purchase Orders. We accept Visa, MasterCard, Discover Card and American Express for online or telephone orders.

We also accept checks and money orders in US funds drawn on a US bank. The payment must include shipping and handling charges, if applicable. Orders which do not include appropriate shipping and handling charges will be delayed. If you need an invoice to submit to your accounting department to have a check cut please contact us at 800-571-3914 or 281-292-3270 to place your order. We will prepare a pro forma invoice and send it to you via email, fax, or snail mail. However, your order will not be shipped until we receive payment in full.

Attention Texas residents: Orders for delivery to a Texas address, whether downloaded via the Internet or delivered on CDROM, must include sales tax of 8.25% on the total amount of the order, including shipping and handling, if any. A sales tax of 8.25% of the order total will automatically be added to all Texas orders processed through our online ordering system. Tax exempt organizations in Texas must fax a tax exemption certificate to us at 281-292-3608 and should contact us at 800-571-3914 to place their orders. Orders which do not include appropriate sales tax or a valid tax exemption certificate will be delayed.

30-Day Money-Back Guarantee
We back the Place Name Database with our 30-Day Money-Back Guarantee. If you are not satisfied with Place Name Database we will cheerfully refund the purchase price of the product.

What our Customers say about our Database Products and about us

Yes, I want to order the Place Name Database with state FIPS code, place FIPS code, place name, and state code


Place Name database with  with city names, town names, township names, county, and place FIPS codes information


ZIP code Products - ZIP code Product Search - About Us - Contact Us - Home


Place Name database with city names, town names, township names, county, and place FIPS codes information

Copyright © 2015 CD Light, LLC