NAVTEQ Points of Interests
The tables in this category contain data for locations all over the world.
Contents
Account Access
The
mqap.ntpois, mqap.internationalpois and mqap.uspostalcodes are free for both Community accounts and Enterprise accounts.
Table Schema
mqap.ntpois
NAVTEQ POI locations for the U.S. and Canada.
| Field Name | Field Type | Description |
|---|---|---|
| id | String | Unique record ID of the location |
| name | String | Name of the location |
| address | String | Address of the location |
| city | String | City of the location |
| state | String | State of the location |
| postal_code | String | Zip/Postal Code of the location |
| country | String | Country of the location |
| phone | String | Phone number of the location |
| lat | Double | Latitude of the location |
| lng | Double | Longitude of the location |
| disp_lat | Double | Display latitude of the location |
| disp_lng | Double | Display longitude of the location |
| side_of_street | String | Side of street of the location (L: left, R: right, N: none) |
| group_sic_code | String | SIC code for the location. For SIC code values, see below. |
| group_sic_code_name | String | Classification name of the SIC code for the location |
mqap.internationalpois
NAVTEQ POI locations outside the U.S. and Canada.
| Field Name | Field Type | Description |
|---|---|---|
| id | String | Unique record ID of the location |
| name | String | Name of the location |
| address | String | Address of the location |
| city | String | City of the location |
| state | String | State of the location |
| postal_code | String | Zip/Postal Code of the location |
| country | String | Country of the location |
| phone | String | Phone number of the location |
| lat | Double | Latitude of the location |
| lng | Double | Longitude of the location |
| disp_lat | Double | Display latitude of the location |
| disp_lng | Double | Display longitude of the location |
| side_of_street | String | Side of street of the location (L: left, R: right, N: none) |
| navsics | String | SIC code for the location. For SIC code values, see below. |
| cats | String | Classification name of the SIC code for the location |
mqap.uspostalcodes
Zip/Postal Code information for the U.S.
| Field Name | Field Type | Description |
|---|---|---|
| POSTCODE | Integer | Zip/Postal Code of the location |
| PC_NAME | String | Zip/Postal Code name of the location |
| PC_TYPE | String | Type of Zip/Postal Code |
| PA_NAME | String | Postal Area name of the location |
| COUNTY | String | County of the location |
| STATE | String | State of the location |
| ADMIN4 | String | Administrative Area Level 4 of the location (city) |
| ADMIN3 | String | Administrative Area Level 3 of the location (county) |
| ADMIN2 | String | Administrative Area Level 2 of the location (state) |
| ADMIN1 | String | Administrative Area Level 1 of the location (country) |
| PA_FIPS | String | Postal Area FIPS code of the location |
| CTYFIPS | String | County FIPS code of the location |
| STFIPS | String | State FIPS code of the location |
| ISO_CTRY | String | ISO Country Code of the location |
SIC Code values
Values for the SIC codes found in the mqap.ntpois and mqap.internationalpois datasets.
| group_sic_code / navsics | group_sic_code_name / cats |
|---|---|
| 208401 | Wineries |
| 602103 | Automated Teller Machines |
| 401190 | Train Stations |
| 411990 | Commuter Rail Stations |
| 413190 | Bus Stations |
| 904001 | Other |
| 448290 | Ferry Terminals |
| 449306 | Marinas |
| 458106 | Airports |
| 999990 | Major Businesses |
| 541105 | Grocery Stores |
| 551102 | (all) Auto Dealers |
| 551103 | Auto Dealers-Used |
| 554101 | Gas Stations |
| 557106 | Motorcycle Dealers |
| 581208 | (all) Restaurants |
| 581304 | Night Clubs |
| 799940 | Historical Places |
| 602101 | Banks |
| 651201 | Shopping Centers & Malls |
| 701101 | Hotels & Motels |
| 701110 | Skiing Centers & Resorts |
| 701117 | Accommodations |
| 472401 | Tourist Information |
| 751401 | Auto Rental |
| 752101 | Parking Attendant Service |
| 752102 | Parking Garages |
| 752190 | Park & Ride |
| 753801 | Auto Repair |
| 783201 | Movie Theatres |
| 703390 | Rest Areas |
| 792207 | Theatres-Live |
| 793301 | Bowling Centers |
| 794104 | Stadiums Arenas & Athletic Fields |
| 799951 | Parks |
| 799302 | Casinos |
| 738931 | Convention & Meeting Facilities & SVC |
| 799290 | Golf Courses-Public or Private |
| 799935 | Halls & Auditoriums |
| 799604 | Amusement Parks |
| 799901 | Skating Rinks |
| 799972 | Tourist Attractions |
| 806202 | Hospitals |
| 822101 | Colleges & Universities |
| 821103 | Schools (k-12) |
| 823106 | Libraries |
| 841201 | Museums |
| 869912 | Automobile Clubs |
| 912112 | City Hall |
| 921190 | Court Houses |
| 922190 | Police Stations |
| 703301 | Campgrounds |
| 431101 | Post Offices |
| 541103 | Convenience Stores |
| 565101 | Clothing-Retail |
| 531102 | Department Stores |
| 521168 | Home Specialty Store |
| 591205 | Pharmacies |
| 531104 | Specialty Store |
| 594113 | Sporting Goods |
| 411914 | Transportation Services |
| 4 | Cargo Center |
| 971109 | Military Base |
| 525104 | Hardware Stores |
| 573105 | Stereos & Electronics |
| 594301 | Office Supplies |
| 866107 | Places of Worship |
| 594201 | Book Stores |
| 581228 | Coffee Shops |
| 478590 | Border Crossings |
