Skip to main content
Pinpoint - Smarty's free user conference - October 22nd and 23rdRegister now (opens in new tab)
Smarty's free user conferenceRegister now (opens in new tab)
Smarty

Canada Parcel Boundary Data attributes

The following attributes are included in Canada Parcel Boundary Data.

IDs & metadata attribute list

Shapefile field identifierField identifierField nameDefinitionData type

dvsn_code

census_division_code

Census division code

A 4-digit number corresponding to a census division boundary from the Canadian Census.

varchar

par_num_fm

parcel_number_formatted

Parcel number formatted

The parcel ID or parcel number.

varchar

parcel_num

parcel_number

Parcel number

The parcel ID or parcel number with all non-A-Z and 0-9 characters removed.

varchar

alt_parc_1

parcel_number_alternate_1

Parcel number alternate 1

A parcel ID number provided by the government that isn't considered to be the primary parcel ID number used by the government. These could be previously used parcel numbers or alternate ID numbers.

varchar

alt_parc_2

parcel_number_alternate_2

Parcel number alternate 2

A parcel ID number provided by the government that isn't considered to be the primary parcel ID number used by the government. These could be previously used parcel numbers or alternate ID numbers.

varchar

alt_parc_3

parcel_number_alternate_3

Parcel number alternate 3

A parcel ID number provided by the government that isn't considered to be the primary parcel ID number used by the government. These could be previously used parcel numbers or alternate ID numbers.

varchar

last_refsh

date_of_last_refresh

Date of last refresh

The date the source data was most recently refreshed.

date

time_updte

time_of_last_update

Time of last update

The timestamp of the most recent change of any kind to this row in the table (internal record changes and/or county updates). "date_of_last_refresh" should be used for the parcel data's date.

timestamp

Address & location attribute list

Shapefile field identifierField identifierField nameDefinitionData type

dlv_line_1

delivery_line_1

Delivery line 1

The physical street address for the parcel - the address of the parcel itself. Not every parcel has a street address, especially in agricultural areas or for larger parcels. Also called the "situs address" or "site address". Contains the first delivery line (usually the street address). This can include any of the following: primary number, street predirection, street name, street suffix, street postdirection, secondary.

varchar

dlv_line_2

delivery_line_2

Delivery line 2

The second delivery line of the parcel address (if needed). It's common for this field to remain empty.

varchar

orig_addr

original_address

Original address

The parcel address fields, as originally provided by the government, encoded in JSON format prior to any cleaning.

varchar

prim_num

primary_number

Primary number

The house, PO Box, or building number of the parcel address.

varchar

pre_dir

street_predirection

Street predirection

Directional information before a parcel address street name (N, SW, etc.).

varchar

saddstr

street_name

Street name

The name of the street of the parcel address.

varchar

str_sfx

street_suffix

Street suffix

Abbreviated value describing the parcel address street (St, Ave, Blvd, etc.).

varchar

post_dir

street_postdirection

Street postdirection

Directional information after a parcel address street name (N, SW, etc.).

varchar

secondary

secondary

Secondary

Describes location within a complex/building (Ste, Apt, etc.) and its correlated unit number and/or letter (if any) of the parcel address.

varchar

city_name

city_name

City name

The parcel address city name.

varchar

postcode

postcode

Postcode

The parcel address postcode.

varchar

cntry_code

country_code

Country code

The parcel address country code.

varchar

lev_1_div

1st_level_division

1st level division

The parcel address 1st division (territory, province, etc.).

varchar

lev_2_div

2nd_level_division

2nd level division

The parcel address 2nd division (county, department, division, etc.).

varchar

lev_3_div

3rd_level_division

3rd level division

The parcel address 3rd division (city, rural, municipality, etc.). In Canada, these overlap with the 2nd-division bounds.

varchar

Land details attribute list

Shapefile field identifierField identifierField nameDefinitionData type

reserve

first_nations_reserve_or_federal_land

First Nations reserve or federal land

The name of the First Nations reserve or federal land on which the parcel is located.

varchar

row_parcel

right_of_way

Right-of-way

Indicates a right-of-way parcel or similar function parcel.

varchar

sqm_calc

sqm_calculated

Sqm calculated

The parcel square meters as calculated from supplied parcel geometry.

float

parcel

Parcel

The geometry of the parcel boundary.

wkt, wkb, embedded

This chat is powered by Help Scout. Chats are recorded. Privacy Policy