There are two Streets layers available in StreetPro Canada, the standard Streets layers (streets.tab), and Classic street layers, now renamed geocoder.tab.
Both contain brown polylines representing Canadian streets, together with the associated street names. All alternate names are also included. The street names are indexed so that you can use Query > Find to locate an object.
The differences between the two layers are:
- streets.tab is available in all flavors of StreetPro Canada and is for use in a map window to give your data a geographic reference.
- The Classic layer displays streets in the same way as streets.tab, but it also includes additional rendering, and also incorporates the associated address ranges so that you can use it to geocode your data.
| Field Name | Data Type (Length) | Index | Description |
|---|---|---|---|
| NAME | CHAR (100) | Yes | Name of feature |
| NAME_LNG | CHAR (3) | No | 3-character ISO language code |
| NAME_TYPE | CHAR (3) | No | Street name type (Bit Mask): 0 - No name1 - Official name 2 - Alternate name4 - Route name 8 - Brunnel name16 - Street name 17 - Street name (16) and Official name (1) (i.e. a value of '17' represents a NAME_TYPE which is a Street name (16) as well as an Official name (1)) 32 - Locality name64 - Postal street name |
| ROUTE_NUM | CHAR (10) | No | Route number |
| ROUTE_DIR | CHAR (2) | No | Route directional; N,S,E,W |
| ROAD_CLASS | SMALLINT | No | Functional road class: 6 - Local road7 - Local road of minor importance 8 - Other road |
| SHIELD_CODE | INTEGER | No | Unique code for shield icon. |
| MICODE | INTEGER | No | MapInfo feature code |
| ID | CHAR (36) | No | Universally unique feature identifier |
| LONGITUDE | FLOAT | No | Feature centroid longitude |
| LATITUDE | FLOAT | No | Feature centroid latitude |
| A2_CODE | CHAR (5) | No | Combination of the province and census divisions codes |