Name: Civic Address

Display Field: ADDR_FULL

Type: Feature Layer

Geometry Type: esriGeometryPoint

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description: Updated regularly by the Infrastructure Services Department, Building Services, who assigns addresses to new developments, makes amendments and modifications, and responds to address inquiries.Key Attributes: Location/Coordinates, Street Number, Unit, Street Name, ARN, QC/StatusTopology: In Building Footprint, In Parcel.Dependencies: All, Fire, Web, SLSN segment address range.Manualupdate

Copyright Text: The Corporation of the Town of Halton Hills, Building Services Section of the Transportation & Public Works Department.

Min. Scale: 44431

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 559532.3431
YMin: 4807820.7007
XMax: 602720.088600001
YMax: 4856615.0533
Spatial Reference: 26917 (26917)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[255,255,255,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":1}},"label":"Civic Address"},"scaleSymbols":true,"transparency":0,"labelingInfo":[{"labelExpression":"[STR_NUM] CONCAT \"_{\" CONCAT \"(\" CONCAT [STR_UNIT] CONCAT \")\" CONCAT \"}\"","labelPlacement":"esriServerPointLabelPlacementAboveRight","deconflictionStrategy":"dynamic","allowOverlapOfFeatureInterior":"avoid","stackLabel":true,"stackRowLength":24,"stackAlignment":"dynamic","stackSeparators":[],"removeDuplicates":"none","where":"STR_NUM > 0 AND (STR_UNIT IS NOT NULL AND STR_UNIT <> '' AND STR_UNIT <> ' ' )","useCodedValues":true,"maxScale":0,"minScale":5000,"name":"StrNUMBERunit","priority":23,"symbol":{"type":"esriTS","color":[52,52,52,255],"backgroundColor":null,"borderLineColor":null,"borderLineSize":null,"verticalAlignment":"bottom","horizontalAlignment":"left","rightToLeft":false,"angle":0,"xoffset":0,"yoffset":0,"kerning":true,"haloColor":[255,255,255,255],"haloSize":1.1,"font":{"family":"Arial","size":9,"style":"normal","weight":"bold","decoration":"none"}}},{"labelExpression":"[STR_NUM]","labelPlacement":"esriServerPointLabelPlacementAboveRight","deconflictionStrategy":"dynamic","allowOverlapOfFeatureInterior":"avoid","stackLabel":true,"stackRowLength":24,"stackAlignment":"dynamic","stackSeparators":[],"removeDuplicates":"none","where":"STR_NUM > 0 AND (STR_UNIT IS NULL OR STR_UNIT = '' OR STR_UNIT = ' ' )","useCodedValues":true,"maxScale":0,"minScale":5000,"name":"StrNUMB","priority":19,"symbol":{"type":"esriTS","color":[52,52,52,255],"backgroundColor":null,"borderLineColor":null,"borderLineSize":null,"verticalAlignment":"bottom","horizontalAlignment":"center","rightToLeft":false,"angle":0,"xoffset":0,"yoffset":0,"kerning":true,"haloColor":[255,255,255,255],"haloSize":1.4,"font":{"family":"Arial","size":9,"style":"normal","weight":"bold","decoration":"none"}}}]}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field: GlobalID

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• ADDR_ID (type: esriFieldTypeString, alias: Address ID, SQL Type: sqlTypeOther, length: 19, nullable: true, editable: true)
• ADDR_FULL (type: esriFieldTypeString, alias: Address, Full, SQL Type: sqlTypeOther, length: 70, nullable: true, editable: true)
• ADDR_COMM (type: esriFieldTypeString, alias: Community, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [401-407: 401-407], [Acton: Acton], [Esquesing: Esquesing], ... 8 more ...)
• STR_FULL (type: esriFieldTypeString, alias: Street, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• STR_NUM (type: esriFieldTypeInteger, alias: Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
• STR_UNIT (type: esriFieldTypeString, alias: Unit, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• STR_PREF (type: esriFieldTypeString, alias: Prefix, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• STR_NAME (type: esriFieldTypeString, alias: Name, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• STR_SUFF (type: esriFieldTypeString, alias: Suffix, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [Avenue: Avenue], [Boulevard: Boulevard], [Circle: Circle], ... 22 more ...)
• STR_DIR (type: esriFieldTypeString, alias: Direction, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [North: North], [South: South], [East: East], ... 1 more ...)
• ADDR_TYPE (type: esriFieldTypeString, alias: Type, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Farmland: Farmland], [Historic: Historic], [Parkland: Parkland], ... 3 more ...)
• ADDR_STAT (type: esriFieldTypeString, alias: Status, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [QC ARN: QC ARN], [Retired: Retired], [QC Corner: QC Corner], ... 3 more ...)
• TOHH (type: esriFieldTypeString, alias: TOHH, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Yes: Yes], [No, Null: No], [No: No])
• ADDRE (type: esriFieldTypeDouble, alias: Easting, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ADDRN (type: esriFieldTypeDouble, alias: Northing, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Latitude (type: esriFieldTypeDouble, alias: Latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Longitude (type: esriFieldTypeDouble, alias: Longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• created_date (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• last_edited_date (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)

Templates:

Name: GISDATA.GISADMIN.HH_ADDR_FIN
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 11/28/2025 9:02:49 PM

Schema Last Edit Date: 11/28/2025 9:02:49 PM

Data Last Edit Date: 11/28/2025 9:02:49 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat