records
Issued operating permits – water systems
Dataset schema
Click to expand Click to collapse
JSON Schema
The following JSON object is a standardized description of your dataset's schema. More about JSON schema.
{
- "title":"issued-operating-permits-water-systems-",
- "type":"object",
- "oneOf":,[
- {
- "$ref":"#/definitions/issued-operating-permits-water-systems-"
}
] - "definitions":{
- "issued-operating-permits-water-systems-":,{
- "properties":{
- "records":{
- "type":"array",
- "items":{
- "$ref":"#/definitions/issued-operating-permits-water-systems-_records"
}
}
} - "records":
} - "properties":
- "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"
}
} - "crs":
- "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"
}
} - "type":
- "additionalProperties":false,
- "oneOf":[
- ,{
- "$ref":"#/definitions/namedCrs"
} - {
- "$ref":"#/definitions/linkedCrs"
}
]
} - "namedCrs":,{
- "properties":{
- "type":,{
- "enum":[
- "name"
]
} - "enum":
- "properties":{
- "required":,[
- "name"
] - "additionalProperties":false,
- "properties":{
- "name":{
- "type":"string"
}
} - "name":
} - "required":
} - "type":
} - "properties":
- "linkedObject":,{
- "type":"object",
- "required":,[
- "href"
] - "properties":{
- "href":,{
- "type":"string",
- "format":"uri"
} - "type":{
- "type":"string",
- "description":"Suggested values: proj4, ogjwkt, esriwkt"
}
} - "href":
} - "linkedCrs":,{
- "properties":{
- "type":,{
- "enum":[
- "link"
]
} - "enum":
- "properties":{
- "$ref":"#/definitions/linkedObject"
}
} - "type":
} - "properties":
- "geometryCollection":,{
- "title":"GeometryCollection",
- "description":"A collection of geometry objects",
- "required":,[
- "geometries"
] - "properties":{
- "type":,{
- "enum":[
- "GeometryCollection"
]
} - "enum":
- "geometries":{
- "type":"array",
- "items":{
- "$ref":"http://json-schema.org/geojson/geometry.json#"
}
}
} - "type":
} - "feature":,{
- "title":"Feature",
- "description":"A Geo JSON feature object",
- "required":,[
- "geometry",
- "properties"
] - "properties":{
- "type":,{
- "enum":[
- "Feature"
]
} - "enum":
- "geometry":,{
- "oneOf":[
- ,{
- "type":"null"
} - {
- "$ref":"#/definitions/geometry"
}
]
} - "oneOf":
- "properties":,{
- "type":[
- "object",
- "null"
]
} - "type":
- "id":{}
} - "type":
} - "featureCollection":,{
- "title":"FeatureCollection",
- "description":"A Geo JSON feature collection",
- "required":,[
- "features"
] - "properties":{
- "type":,{
- "enum":[
- "FeatureCollection"
]
} - "enum":
- "features":{
- "type":"array",
- "items":{
- "$ref":"#/definitions/feature"
}
}
} - "type":
} - "geometry":,{
- "title":"geometry",
- "description":"One geometry as defined by GeoJSON",
- "type":"object",
- "required":,[
- "type",
- "coordinates"
] - "oneOf":,[
- ,{
- "title":"Point",
- "properties":{
- "type":,{
- "enum":[
- "Point"
]
} - "enum":
- "coordinates":{
- "$ref":"#/definitions/position"
}
} - "type":
} - ,{
- "title":"MultiPoint",
- "properties":{
- "type":,{
- "enum":[
- "MultiPoint"
]
} - "enum":
- "coordinates":{
- "$ref":"#/definitions/positionArray"
}
} - "type":
} - ,{
- "title":"LineString",
- "properties":{
- "type":,{
- "enum":[
- "LineString"
]
} - "enum":
- "coordinates":{
- "$ref":"#/definitions/lineString"
}
} - "type":
} - ,{
- "title":"MultiLineString",
- "properties":{
- "type":,{
- "enum":[
- "MultiLineString"
]
} - "enum":
- "coordinates":{
- "type":"array",
- "items":{
- "$ref":"#/definitions/lineString"
}
}
} - "type":
} - ,{
- "title":"Polygon",
- "properties":{
- "type":,{
- "enum":[
- "Polygon"
]
} - "enum":
- "coordinates":{
- "$ref":"#/definitions/polygon"
}
} - "type":
} - {
- "title":"MultiPolygon",
- "properties":{
- "type":,{
- "enum":[
- "MultiPolygon"
]
} - "enum":
- "coordinates":{
- "type":"array",
- "items":{
- "$ref":"#/definitions/polygon"
}
}
} - "type":
}
] - "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"
}
}
} - "issued-operating-permits-water-systems-_records":{
- "properties":{
- "fields":{
- "type":"object",
- "properties":{
- "operating_permit_number":,{
- "type":"string",
- "title":"Operating permit number",
- "description":"Unique permit number generated when application submitted. The format is OP-YYYY-#####, where OP means “Operating Permit” and YYYY is the year the permit application was submitted."
} - "address":,{
- "type":"string",
- "title":"Address",
- "description":"Address corresponding to the location of the mechanical system."
} - "mechanical_system_type":,{
- "type":"string",
- "title":"Mechanical system type",
- "description":"Operating Permits are required for cooling towers, decorative water features, building water treatment systems and rainwater harvesting/non-potable water systems."
} - "current_system_status":,{
- "type":"string",
- "title":"Current system status",
- "description":"Certain systems may be operated seasonally or year-round. Permit holders are required to report when their system is ACTIVE or INACTIVE. When a system is operating or on stand-by, it is ACTIVE. When it is drained and not operating, it is INACTIVE."
} - "permit_renewal_date":,{
- "type":"string",
- "format":"date",
- "title":"Permit renewal date",
- "description":"Operating permits must be renewed annually. The permit renewal date is the date by which an Operating Permit must be renewed."
} - "voluntary_participant":,{
- "type":"string",
- "title":"Voluntary participant",
- "description":"Certain systems within the City of Vancouver are owned by other levels of government, First Nations, Crown corporations, or authorities not subject to the Operating Permit program. Nevertheless, some of these entities have chosen to voluntarily participate. Y means that the owner of the mechanical system is not subject to the Operating Permit program but is voluntarily participating. N means that the owner is legally required to participate in the Operating Permit program."
} - "date_of_most_recent_report":,{
- "type":"string",
- "format":"date",
- "title":"Date of most recent report",
- "description":"The water sample collection date, or the date the system became ACTIVE or INACTIVE. Permit holders for cooling towers, decorative water features, and rainwater harvesting/non-potable water systems are required to report water quality data at regular intervals. They are also required to report when the system changes to an INACTIVE or ACTIVE status. Water quality samples are not required while a system is INACTIVE Refer to the accompanying dataset "Operating permits - water systems - water quality reports" for a complete history of water quality reports. Refer to the Operating Permit webpage for required sampling frequencies. "
} - "legionella_pneumophila":,{
- "type":"string",
- "title":"Legionella pneumophila",
- "description":"The Legionella pneumophila result (total / all serogroups) as determined by an accredited laboratory using the culture method, in units of CFU per mL (Colony Forming Units per millilitre). Applicable to cooling towers, decorative water features and rainwater harvesting/non-potable water systems. If a Legionella pneumophila result was entered by the permit holder in their most recent system report, the result is listed here. Refer to the accompanying dataset "Operating permits - water systems - water quality reports" for a complete history of water quality reports. Refer to the Operating Permit webpage for the Legionella pneumophila standard."
} - "marker_colour":,{
- "type":"string",
- "title":"Marker colour",
- "description":"Each marker signifies a distinct, issued Operating Permit, and has one of three possible colours: yellow, blue or grey. A yellow marker means that the latest submitted water quality report has a Legionella pneumophila result greater than 1,000 CFU/mL. A grey marker means that the Operating Permit is held by a voluntary participant. The marker colour does not change for a voluntary participant. A blue marker is used for all other Operating Permits."
} - "escherichia_coli":,{
- "type":"string",
- "title":"Escherichia coli",
- "description":"The Escherichia coli (E. coli) result as measured by an accredited laboratory, in units of CFU per 100 mL or MPN per 100 mL. (Colony Forming Units or Most Probable Number per 100 millilitres). Applicable only to rainwater harvesting/non-potable water systems. If an E. coli result was entered by the permit holder in their most recent system report, the result is listed here. Refer to the accompanying dataset "Operating permits - water systems - water quality reports" for a complete history of water quality reports. Refer to the Operating Permit webpage for the E. coli standard."
} - "turbidity":,{
- "type":"number",
- "title":"Turbidity",
- "description":"The turbidity of the water sample as measured by an accredited laboratory, in units of NTU (nephelometric turbidity units). Applicable only to rainwater harvesting/non-potable water systems. If a turbidity result was entered by the permit holder in their most recent system report, the result is listed here. Refer to the accompanying dataset "Operating permits - water systems - water quality reports" for a complete history of water quality reports. Refer to the Operating Permit webpage for the turbidity standard."
} - "temperature":,{
- "type":"number",
- "title":"Temperature",
- "description":"The temperature of the water sample as measured by the operator, in units of degrees Celsius. Applicable only to rainwater harvesting/non-potable water systems. If a temperature result was entered by the permit holder in their most recent system report, the result is listed here. Refer to the accompanying dataset "Operating permits - water systems - water quality reports" for a complete history of water quality reports. Refer to the Operating Permit webpage for the temperature standard."
} - "total_suspended_solids":,{
- "type":"string",
- "title":"Total Suspended Solids",
- "description":"The concentration of total suspended solids as measured by a laboratory, in units of milligrams per litre. Applicable to certain rainwater harvesting/non-potable water systems, such as those collecting rainwater from surfaces with vehicles. Refer to the accompanying dataset "Operating permits - water systems - water quality reports" for a complete history of water quality reports. Refer to the Operating Permit webpage for the total suspended solids standard."
} - "benzene":,{
- "type":"string",
- "title":"Benzene",
- "description":"The concentration of benzene as measured by a laboratory, in units of milligrams per litre. Applicable to certain rainwater harvesting/non-potable water systems, such as those collecting rainwater from surfaces with vehicles. Refer to the accompanying dataset "Operating permits - water systems - water quality reports" for a complete history of water quality reports. Refer to the Operating Permit webpage for the benzene standard."
} - "toluene":,{
- "type":"string",
- "title":"Toluene",
- "description":"The concentration of toluene as measured by a laboratory, in units of milligrams per litre. Applicable to certain rainwater harvesting/non-potable water systems, such as those collecting rainwater from surfaces with vehicles. Refer to the accompanying dataset "Operating permits - water systems - water quality reports" for a complete history of water quality reports. Refer to the Operating Permit webpage for the toluene standard."
} - "ethylbenzene":,{
- "type":"string",
- "title":"Ethylbenzene",
- "description":"The concentration of ethylbenzene as measured by a laboratory, in units of milligrams per litre. Applicable to certain rainwater harvesting/non-potable water systems, such as those collecting rainwater from surfaces with vehicles. Refer to the accompanying dataset "Operating permits - water systems - water quality reports" for a complete history of water quality reports. Refer to the Operating Permit webpage for the ethylbenzene standard."
} - "xylenes_total":,{
- "type":"string",
- "title":"Xylenes Total",
- "description":"The concentration of xylenes (total) as measured by a laboratory, in units of milligrams per litre. Applicable to certain rainwater harvesting/non-potable water systems, such as those collecting rainwater from surfaces with vehicles. Refer to the accompanying dataset "Operating permits - water systems - water quality reports" for a complete history of water quality reports. Refer to the Operating Permit webpage for the xylenes (total) standard."
} - "eocp_certification_number":,{
- "type":"string",
- "title":"EOCP certification number",
- "description":"Operating Permits are required to be associated with someone holding a certification from the Environmental Operators Certification Program (EOCP), most commonly the Building Water System Operator certification. (For certain rainwater harvesting/non-potable water systems, a more advanced EOCP certification may be required.) The certification can be held by a staff person or a contracted professional. This field is the EOCP certification number for that individual."
} - "geom":,{
- "type":"object",
- "oneOf":,[
- {
- "$ref":"#/definitions/geometry"
}
] - "title":"Geom",
- "description":"These are mapping coordinates for the building corresponding to an Operating Permit. Data from the Address attribute are processed by the BC Address Geocoder API. An unmatched address returns null coordinates and will not display on the Map. The Operating Permit will still be listed in the Table"
} - "geo_local_area":,{
- "type":"string",
- "title":"Geo Local Area",
- "description":"The local area where the building with the Operating Permit is found, derived from the building's coordinates or address. The City of Vancouver has 22 local areas (also known as local planning areas). For more details, please see the Local Area Boundary data set."
} - "water_quality_reports_link":,{
- "type":"string",
- "title":"Water quality reports link",
- "description":""
} - "geo_point_2d":{
- "type":"array",
- "minItems":2,
- "maxItems":2,
- "items":,{
- "type":"number"
} - "title":"geo_point_2d",
- "description":""
}
} - "operating_permit_number":
}
} - "fields":
} - "properties":
} - "issued-operating-permits-water-systems-":
}