records

records

Active filters Clear all

No active filters

Filters

Business licences 1997 to 2012

Attachments

Click to expand Click to collapse

Dataset schema

Click to expand Click to collapse
FOLDERYEAR
First two characters of the Business Licence Number, representing the year issued

No description available for this field.

Name (identifier)
folderyear
Type
text
Sample
97
LicenceRSN
Unique identifier for each business licence generated by the system

No description available for this field.

Name (identifier)
licencersn
Type
text
Sample
20268
LicenceNumber
This is a 9 character field consisting of a two digit number indicating the year issued followed by a hyphen and a six digit system-generated number.
Note: There is a small chance that a licence number can be reused more than once within a given year. LicenceRSN is an unique identifier.

No description available for this field.

Name (identifier)
licencenumber
Type
text
Sample
97-048137
LicenceRevisionNumber
A 2 digit field generated by the system that represents the licence version. Note: 00 means the original version and this number increases as new revisions  are created.

No description available for this field.

Name (identifier)
licencerevisionnumber
Type
text
Sample
00
BusinessName
The ownership of the business

No description available for this field.

Name (identifier)
businessname
Type
text
Sample
Major Land Company Ltd
BusinessTradeName
Name under which business is usually conducted

No description available for this field.

Name (identifier)
businesstradename
Type
text
Sample
                       
Status
Current status of the business licence, as follows: 
i) Cancelled: Licence is cancelled due to various reasons
ii) GOB: Gone Out of Business. A business is no longer operating 
iii) Inactive: Licence is no longer active 
iv) Issued: Licence is issued with no status change (e.g., GOB) for the displayed year or the review of a Liquor licence application is completed 
v) Pending: Licence is in an application, incomplete or under review stage for the displayed year (e.g., pending approval, renewal, payment, under review)

No description available for this field.

Name (identifier)
status
Type
text
Sample
Gone Out of Business
IssuedDate
The date when the business licence is issued and printed. 

No description available for this field.

Name (identifier)
issueddate
Type
date
Sample
                       
ExpiredDate
The date that the business licence expires. Most licences expire on December 31st.

No description available for this field.

Name (identifier)
expireddate
Type
date
Sample
1997-12-31
BusinessType
Description of the business activity, usually in accordance with the definition in the Licence By-Law No. 4450
Note: Business type names that have a notation of *Historic* at the end signify retired business licence types. These are business licence types that were once active but have since been retired. Due to privacy concern, some business types do not have address data.

No description available for this field.

Name (identifier)
businesstype
Type
text
Sample
Office
BusinessSubType
Sub-category(s) of the main business type 
Note: business sub type names that have a notation of *Historic* at the end signified retired business licence sub types. These are business licence sub types that were once active but have since been retired

No description available for this field.

Name (identifier)
businesssubtype
Type
text
Sample
Real Estate Development/Investment
Unit
Official space identifier for a building. This is an alphanumeric field.

No description available for this field.

Name (identifier)
unit
Type
text
Sample
                       
UnitType
Description of a location other than a house or building with a simple street address where the business is located. i.e., Block, Suite, Apartment (Apt.), etc.

No description available for this field.

Name (identifier)
unittype
Type
text
Sample
                       
House
The number assigned to an address where the business is located.

No description available for this field.

Name (identifier)
house
Type
text
Sample
                       
Street
The name of the street where the business is located.

No description available for this field.

Name (identifier)
street
Type
text
Sample
                       
City
Name of the municipality where the business is located

No description available for this field.

Name (identifier)
city
Type
text
Sample
                       
Province
Name of the province or state where the business is located

No description available for this field.

Name (identifier)
province
Type
text
Sample
                       
Country
A two-character field that signifies the name of the country where the business is located (CA is Canada). 

No description available for this field.

Name (identifier)
country
Type
text
Sample
                       
PostalCode
A series of letters and/or digits that is attached to the address of a business

No description available for this field.

Name (identifier)
postalcode
Type
text
Sample
                       
LocalArea
Manual selection from data custodian in source system. The City has 22 local areas (also known as local planning areas); for more details, see the Local area boundary dataset.

No description available for this field.

Name (identifier)
localarea
Type
text
Sample
Oakridge
NumberofEmployees
Number of staff employed with the business
Note: 
 0 means information received from applicant indicates the business does not have any employees.
 000 means information unknown.

No description available for this field.

Name (identifier)
numberofemployees
Type
text
Sample
000
FeePaid
Total amount of licence fee paid in Canadian dollars
Note: This field will be blank if the information is unavailable or unspecified.

No description available for this field.

Name (identifier)
feepaid
Type
integer
Sample
                       
ExtractDate
Date when data was extracted from source data system.

No description available for this field.

Name (identifier)
extractdate
Type
datetime
Sample
2019-07-21T13:47:54+00:00
Geom
Spatial representation of feature

No description available for this field.

Name (identifier)
geom
Type
geo shape
Sample
                       

JSON Schema

The following JSON object is a standardized description of your dataset's schema. More about JSON schema.

{
  • "title":"business-licences-1997-to-2012",
  • "type":"object",
  • "oneOf":
    [
    • {
      • "$ref":"#/definitions/business-licences-1997-to-2012"
      }
    ]
    ,
  • "definitions":
    {
    • "business-licences-1997-to-2012":
      {
      • "properties":
        {
        • "records":
          {
          • "type":"array",
          • "items":
            {
            • "$ref":"#/definitions/business-licences-1997-to-2012_records"
            }
          }
        }
      }
      ,
    • "geoJSON":
      {
      • "title":"Geo JSON object",
      • "description":"Schema for a Geo JSON object",
      • "type":"object",
      • "required":
        [
        • "type"
        ]
        ,
      • "properties":
        {
        • "crs":
          {
          • "$ref":"#/definitions/crs"
          }
          ,
        • "bbox":
          {
          • "$ref":"#/definitions/bbox"
          }
        }
        ,
      • "oneOf":
        [
        • {
          • "$ref":"#/definitions/geometry"
          }
          ,
        • {
          • "$ref":"#/definitions/geometryCollection"
          }
          ,
        • {
          • "$ref":"#/definitions/feature"
          }
          ,
        • {
          • "$ref":"#/definitions/featureCollection"
          }
        ]
      }
      ,
    • "bbox":
      {
      • "description":"A bounding box as defined by GeoJSON",
      • "type":"array",
      • "items":
        {
        • "type":"number"
        }
      }
      ,
    • "crs":
      {
      • "title":"crs",
      • "description":"a Coordinate Reference System object",
      • "type":
        [
        • "object",
        • "null"
        ]
        ,
      • "required":
        [
        • "type",
        • "properties"
        ]
        ,
      • "properties":
        {
        • "type":
          {
          • "type":"string"
          }
          ,
        • "properties":
          {
          • "type":"object"
          }
        }
        ,
      • "additionalProperties":false,
      • "oneOf":
        [
        • {
          • "$ref":"#/definitions/namedCrs"
          }
          ,
        • {
          • "$ref":"#/definitions/linkedCrs"
          }
        ]
      }
      ,
    • "namedCrs":
      {
      • "properties":
        {
        • "type":
          {
          • "enum":
            [
            • "name"
            ]
          }
          ,
        • "properties":
          {
          • "required":
            [
            • "name"
            ]
            ,
          • "additionalProperties":false,
          • "properties":
            {
            • "name":
              {
              • "type":"string"
              }
            }
          }
        }
      }
      ,
    • "linkedObject":
      {
      • "type":"object",
      • "required":
        [
        • "href"
        ]
        ,
      • "properties":
        {
        • "href":
          {
          • "type":"string",
          • "format":"uri"
          }
          ,
        • "type":
          {
          • "type":"string",
          • "description":"Suggested values: proj4, ogjwkt, esriwkt"
          }
        }
      }
      ,
    • "linkedCrs":
      {
      • "properties":
        {
        • "type":
          {
          • "enum":
            [
            • "link"
            ]
          }
          ,
        • "properties":
          {
          • "$ref":"#/definitions/linkedObject"
          }
        }
      }
      ,
    • "geometryCollection":
      {
      • "title":"GeometryCollection",
      • "description":"A collection of geometry objects",
      • "required":
        [
        • "geometries"
        ]
        ,
      • "properties":
        {
        • "type":
          {
          • "enum":
            [
            • "GeometryCollection"
            ]
          }
          ,
        • "geometries":
          {
          • "type":"array",
          • "items":
            {
            • "$ref":"http://json-schema.org/geojson/geometry.json#"
            }
          }
        }
      }
      ,
    • "feature":
      {
      • "title":"Feature",
      • "description":"A Geo JSON feature object",
      • "required":
        [
        • "geometry",
        • "properties"
        ]
        ,
      • "properties":
        {
        • "type":
          {
          • "enum":
            [
            • "Feature"
            ]
          }
          ,
        • "geometry":
          {
          • "oneOf":
            [
            • {
              • "type":"null"
              }
              ,
            • {
              • "$ref":"#/definitions/geometry"
              }
            ]
          }
          ,
        • "properties":
          {
          • "type":
            [
            • "object",
            • "null"
            ]
          }
          ,
        • "id":
          {
            }
          }
        }
        ,
      • "featureCollection":
        {
        • "title":"FeatureCollection",
        • "description":"A Geo JSON feature collection",
        • "required":
          [
          • "features"
          ]
          ,
        • "properties":
          {
          • "type":
            {
            • "enum":
              [
              • "FeatureCollection"
              ]
            }
            ,
          • "features":
            {
            • "type":"array",
            • "items":
              {
              • "$ref":"#/definitions/feature"
              }
            }
          }
        }
        ,
      • "geometry":
        {
        • "title":"geometry",
        • "description":"One geometry as defined by GeoJSON",
        • "type":"object",
        • "required":
          [
          • "type",
          • "coordinates"
          ]
          ,
        • "oneOf":
          [
          • {
            • "title":"Point",
            • "properties":
              {
              • "type":
                {
                • "enum":
                  [
                  • "Point"
                  ]
                }
                ,
              • "coordinates":
                {
                • "$ref":"#/definitions/position"
                }
              }
            }
            ,
          • {
            • "title":"MultiPoint",
            • "properties":
              {
              • "type":
                {
                • "enum":
                  [
                  • "MultiPoint"
                  ]
                }
                ,
              • "coordinates":
                {
                • "$ref":"#/definitions/positionArray"
                }
              }
            }
            ,
          • {
            • "title":"LineString",
            • "properties":
              {
              • "type":
                {
                • "enum":
                  [
                  • "LineString"
                  ]
                }
                ,
              • "coordinates":
                {
                • "$ref":"#/definitions/lineString"
                }
              }
            }
            ,
          • {
            • "title":"MultiLineString",
            • "properties":
              {
              • "type":
                {
                • "enum":
                  [
                  • "MultiLineString"
                  ]
                }
                ,
              • "coordinates":
                {
                • "type":"array",
                • "items":
                  {
                  • "$ref":"#/definitions/lineString"
                  }
                }
              }
            }
            ,
          • {
            • "title":"Polygon",
            • "properties":
              {
              • "type":
                {
                • "enum":
                  [
                  • "Polygon"
                  ]
                }
                ,
              • "coordinates":
                {
                • "$ref":"#/definitions/polygon"
                }
              }
            }
            ,
          • {
            • "title":"MultiPolygon",
            • "properties":
              {
              • "type":
                {
                • "enum":
                  [
                  • "MultiPolygon"
                  ]
                }
                ,
              • "coordinates":
                {
                • "type":"array",
                • "items":
                  {
                  • "$ref":"#/definitions/polygon"
                  }
                }
              }
            }
          ]
          ,
        • "position":
          {
          • "description":"A single position",
          • "type":"array",
          • "minItems":2,
          • "items":
            [
            • {
              • "type":"number"
              }
              ,
            • {
              • "type":"number"
              }
            ]
            ,
          • "additionalItems":false
          }
          ,
        • "positionArray":
          {
          • "description":"An array of positions",
          • "type":"array",
          • "items":
            {
            • "$ref":"#/definitions/position"
            }
          }
          ,
        • "lineString":
          {
          • "description":"An array of two or more positions",
          • "allOf":
            [
            • {
              • "$ref":"#/definitions/positionArray"
              }
              ,
            • {
              • "minItems":2
              }
            ]
          }
          ,
        • "linearRing":
          {
          • "description":"An array of four positions where the first equals the last",
          • "allOf":
            [
            • {
              • "$ref":"#/definitions/positionArray"
              }
              ,
            • {
              • "minItems":4
              }
            ]
          }
          ,
        • "polygon":
          {
          • "description":"An array of linear rings",
          • "type":"array",
          • "items":
            {
            • "$ref":"#/definitions/linearRing"
            }
          }
        }
        ,
      • "business-licences-1997-to-2012_records":
        {
        • "properties":
          {
          • "fields":
            {
            • "type":"object",
            • "properties":
              {
              • "folderyear":
                {
                • "type":"string",
                • "title":"FOLDERYEAR",
                • "description":"First two characters of the Business Licence Number, representing the year issued"
                }
                ,
              • "licencersn":
                {
                • "type":"string",
                • "title":"LicenceRSN",
                • "description":"Unique identifier for each business licence generated by the system"
                }
                ,
              • "licencenumber":
                {
                • "type":"string",
                • "title":"LicenceNumber",
                • "description":"This is a 9 character field consisting of a two digit number indicating the year issued followed by a hyphen and a six digit system-generated number. Note: There is a small chance that a licence number can be reused more than once within a given year. LicenceRSN is an unique identifier."
                }
                ,
              • "licencerevisionnumber":
                {
                • "type":"string",
                • "title":"LicenceRevisionNumber",
                • "description":"A 2 digit field generated by the system that represents the licence version. Note: 00 means the original version and this number increases as new revisions are created."
                }
                ,
              • "businessname":
                {
                • "type":"string",
                • "title":"BusinessName",
                • "description":"The ownership of the business"
                }
                ,
              • "businesstradename":
                {
                • "type":"string",
                • "title":"BusinessTradeName",
                • "description":"Name under which business is usually conducted"
                }
                ,
              • "status":
                {
                • "type":"string",
                • "title":"Status",
                • "description":"Current status of the business licence, as follows: i) Cancelled: Licence is cancelled due to various reasons ii) GOB: Gone Out of Business. A business is no longer operating iii) Inactive: Licence is no longer active iv) Issued: Licence is issued with no status change (e.g., GOB) for the displayed year or the review of a Liquor licence application is completed v) Pending: Licence is in an application, incomplete or under review stage for the displayed year (e.g., pending approval, renewal, payment, under review)"
                }
                ,
              • "issueddate":
                {
                • "type":"string",
                • "format":"date",
                • "title":"IssuedDate",
                • "description":"The date when the business licence is issued and printed. "
                }
                ,
              • "expireddate":
                {
                • "type":"string",
                • "format":"date",
                • "title":"ExpiredDate",
                • "description":"The date that the business licence expires. Most licences expire on December 31st."
                }
                ,
              • "businesstype":
                {
                • "type":"string",
                • "title":"BusinessType",
                • "description":"Description of the business activity, usually in accordance with the definition in the Licence By-Law No. 4450 Note: Business type names that have a notation of *Historic* at the end signify retired business licence types. These are business licence types that were once active but have since been retired. Due to privacy concern, some business types do not have address data."
                }
                ,
              • "businesssubtype":
                {
                • "type":"string",
                • "title":"BusinessSubType",
                • "description":"Sub-category(s) of the main business type Note: business sub type names that have a notation of *Historic* at the end signified retired business licence sub types. These are business licence sub types that were once active but have since been retired"
                }
                ,
              • "unit":
                {
                • "type":"string",
                • "title":"Unit",
                • "description":"Official space identifier for a building. This is an alphanumeric field."
                }
                ,
              • "unittype":
                {
                • "type":"string",
                • "title":"UnitType",
                • "description":"Description of a location other than a house or building with a simple street address where the business is located. i.e., Block, Suite, Apartment (Apt.), etc."
                }
                ,
              • "house":
                {
                • "type":"string",
                • "title":"House",
                • "description":"The number assigned to an address where the business is located."
                }
                ,
              • "street":
                {
                • "type":"string",
                • "title":"Street",
                • "description":"The name of the street where the business is located."
                }
                ,
              • "city":
                {
                • "type":"string",
                • "title":"City",
                • "description":"Name of the municipality where the business is located"
                }
                ,
              • "province":
                {
                • "type":"string",
                • "title":"Province",
                • "description":"Name of the province or state where the business is located"
                }
                ,
              • "country":
                {
                • "type":"string",
                • "title":"Country",
                • "description":"A two-character field that signifies the name of the country where the business is located (CA is Canada). "
                }
                ,
              • "postalcode":
                {
                • "type":"string",
                • "title":"PostalCode",
                • "description":"A series of letters and/or digits that is attached to the address of a business"
                }
                ,
              • "localarea":
                {
                • "type":"string",
                • "title":"LocalArea",
                • "description":"Manual selection from data custodian in source system. The City has 22 local areas (also known as local planning areas); for more details, see the Local area boundary dataset."
                }
                ,
              • "numberofemployees":
                {
                • "type":"string",
                • "title":"NumberofEmployees",
                • "description":"Number of staff employed with the business Note: 0 means information received from applicant indicates the business does not have any employees. 000 means information unknown."
                }
                ,
              • "feepaid":
                {
                • "type":"integer",
                • "title":"FeePaid",
                • "description":"Total amount of licence fee paid in Canadian dollars Note: This field will be blank if the information is unavailable or unspecified."
                }
                ,
              • "extractdate":
                {
                • "type":"string",
                • "format":"date-time",
                • "title":"ExtractDate",
                • "description":"Date when data was extracted from source data system."
                }
                ,
              • "geom":
                {
                • "type":"object",
                • "oneOf":
                  [
                  • {
                    • "$ref":"#/definitions/geometry"
                    }
                  ]
                  ,
                • "title":"Geom",
                • "description":"Spatial representation of feature"
                }
              }
            }
          }
        }
      }
    }

    Similar datasets