Name: Vector Tile Site Address Labels

Display Field: Street_Name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: Relevant SQL snippet below:SET ANSI_NULLS ON;SET ANSI_PADDING ON;SET ANSI_WARNINGS ON;SET ARITHABORT ON;SET CONCAT_NULL_YIELDS_NULL ON;SET QUOTED_IDENTIFIER ON;use [Assessor]GO-- two steps - initial set up: drop the table and repopulate with appropriate schema -- continuing steps: once schema is established - truncate table and use insert into to populate dataIF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[MSVL_NG911_Publish]') AND type in (N'U'))TRUNCATE TABLE [dbo].[MSVL_NG911_Publish]GOINSERT INTO [dbo].[MSVL_NG911_Publish]SELECT [OBJECTID] ,[Shape] ,CONVERT(varbinary(MAX),[GDB_GEOMATTR_DATA],1) AS [GDB_GEOMATTR_DATA] ,[Add_Number] as 'Address_Number' ,[St_PreDir] as 'Street_Prefix_Direction' ,[St_PreTyp] as 'Street_Prefix_Type' ,[St_Name] as 'Street_Name' ,[St_PosTyp] as 'Street_Suffix_Type' ,[St_PosDir] as 'Street_Suffix_Direction' ,TRIM(CONCAT_WS(' ',[St_PreDir],[St_PreTyp],[St_Name],[St_PosTyp],[St_PosDir])) as 'Full_Street_Name' ,[UNITNUM] as 'Unit_Number' ,[Unit] ,[Post_Code] as 'Zip_Code' ,[FULL_ADDR] as 'Full_Address' ,[Inc_Muni] as 'City' ,[County] ,[State]FROM[Assessor].[dbo].[SNOCO_NG911_EXTRACT]GO

Copyright Text:

Min. Scale: 4513.988705

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -13612836.9473269
YMin: 6109913.60908472
XMax: -13593281.6451664
YMax: 6136721.79484672
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[230,0,0,0],"size":10,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,0],"width":0.6}}},"scaleSymbols":true,"transparency":0,"labelingInfo":[{"labelExpressionInfo":{"expression":"var address = TRIM(UPPER(CONCATENATE([$feature.Address_Number, $feature.Full_Street_Name], ' ')))\nvar abDict = {\n 'NE':'NORTHEAST',\n 'NW':'NORTHWEST',\n 'SE':'SOUTHEAST',\n 'SW':'SOUTHWEST',\n 'RD':'ROAD',\n 'PL':'PLACE',\n 'AVE':'AVENUE',\n 'ST':'STREET',\n 'DR':'DRIVE',\n 'BLVD':'BOULEVARD',\n 'LN':'LANE',\n 'SR':'STATE ROUTE'\n}\n\nfor (var key in abDict){\n var value = abDict[key]\n if (Find(value, address) >= 0){\n address = TRIM(Replace(address, value, key))\n }\n}\n\nvar unit = $feature.Unit_Number\n\n// Check if the unit is not empty, not null, and not a blank string\nif (!IsEmpty(unit) && Text(unit) != '') {\n var unitString = \"\" + 'UNIT ' + unit + \"\"\n address = address + '\\n' + unitString\n}\n\nreturn address","title":"Custom"},"labelPlacement":"esriServerPointLabelPlacementAboveRight","deconflictionStrategy":"dynamic","allowOverlapOfFeatureInterior":"avoid","stackLabel":true,"stackAlignment":"dynamic","removeDuplicates":"none","stackRowLength":24,"where":"Unit NOT IN (' ')","useCodedValues":true,"maxScale":283,"minScale":564.248588,"name":"Full Address Units 1:564","priority":-1,"symbol":{"type":"esriTS","color":[0,0,0,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":0.75,"font":{"family":"Bahnschrift","size":9,"style":"normal","weight":"normal","decoration":"none"}}},{"labelExpression":"[Address_Number]","labelPlacement":"esriServerPointLabelPlacementCenterCenter","deconflictionStrategy":"static","stackLabel":true,"stackAlignment":"dynamic","removeDuplicates":"none","stackRowLength":24,"where":"Unit_Number IS NULL Or Unit = ''","useCodedValues":true,"maxScale":1129,"minScale":4513.988705,"name":"Address Number Only","priority":-1,"symbol":{"type":"esriTS","color":[0,0,0,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,"font":{"family":"Bahnschrift","size":8.5,"style":"normal","weight":"normal","decoration":"none"}}},{"labelExpressionInfo":{"expression":"var address = TRIM(UPPER(CONCATENATE([$feature.Address_Number,$feature.Full_Street_Name],' ')))\r\nconsole('first address: '+ address)\r\nvar abDict = {\r\n 'NE':'NORTHEAST',\r\n 'NW':'NORTHWEST',\r\n 'SE':'SOUTHEAST',\r\n 'SW':'SOUTHWEST',\r\n 'RD':'ROAD',\r\n 'PL':'PLACE',\r\n 'AVE':'AVENUE',\r\n 'ST':'STREET',\r\n 'DR':'DRIVE',\r\n 'BLVD':'BOULEVARD',\r\n 'LN':'LANE',\r\n 'SR':'STATE ROUTE'\r\n}\r\nfor (var i in abDict){\r\n var key = i\r\n var value = abDict[i]\r\n Console('i key: ' + key) //key 'st'\r\n Console('[i] value: ' + value) // value 'street'\r\n if (find(value,address)>0){\r\n address = TRIM(Replace(address, abDict[i],i)) // replace street with st\r\n console('adjusted address: ' + address)\r\n }\r\n}\r\n\r\nreturn address","title":"Custom"},"labelPlacement":"esriServerPointLabelPlacementCenterCenter","deconflictionStrategy":"static","stackLabel":true,"stackAlignment":"dynamic","removeDuplicates":"none","stackRowLength":24,"where":"Unit_Number IS NULL Or Unit = ''","useCodedValues":true,"maxScale":563,"minScale":1128.497176,"name":"Full Address No Units 1:1128","priority":-1,"symbol":{"type":"esriTS","color":[0,0,0,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,"font":{"family":"Bahnschrift","size":10,"style":"normal","weight":"normal","decoration":"none"}}},{"labelExpressionInfo":{"expression":"var address = TRIM(UPPER(CONCATENATE([$feature.Address_Number, $feature.Full_Street_Name], ' ')))\nvar abDict = {\n 'NE':'NORTHEAST',\n 'NW':'NORTHWEST',\n 'SE':'SOUTHEAST',\n 'SW':'SOUTHWEST',\n 'RD':'ROAD',\n 'PL':'PLACE',\n 'AVE':'AVENUE',\n 'ST':'STREET',\n 'DR':'DRIVE',\n 'BLVD':'BOULEVARD',\n 'LN':'LANE',\n 'SR':'STATE ROUTE'\n}\n\nfor (var key in abDict){\n var value = abDict[key]\n if (Find(value, address) >= 0){\n address = TRIM(Replace(address, value, key))\n }\n}\n\nvar unit = $feature.Unit_Number\n\n// Check if the unit is not empty, not null, and not a blank string\nif (!IsEmpty(unit) && Text(unit) != '') {\n var unitString = \"\" + 'UNIT ' + unit + \"\"\n address = address + '\\n' + unitString\n}\n\nreturn address","title":"Custom"},"labelPlacement":"esriServerPointLabelPlacementCenterCenter","deconflictionStrategy":"static","stackLabel":true,"stackAlignment":"dynamic","removeDuplicates":"none","stackRowLength":24,"useCodedValues":true,"maxScale":0,"minScale":282.124294,"name":"Full Address 1:282","priority":-1,"symbol":{"type":"esriTS","color":[0,0,0,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,"font":{"family":"Bahnschrift","size":11,"style":"normal","weight":"normal","decoration":"none"}}}]}

HasZ: true

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

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)
• Address_Number (type: esriFieldTypeString, alias: Address_Number, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
• Full_Street_Name (type: esriFieldTypeString, alias: Full_Street_Name, SQL Type: sqlTypeOther, length: 122, nullable: true, editable: true)
• Street_Prefix_Direction (type: esriFieldTypeString, alias: Street_Prefix_Direction, SQL Type: sqlTypeOther, length: 9, nullable: true, editable: true)
• Street_Prefix_Type (type: esriFieldTypeString, alias: Street_Prefix_Type, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• Street_Name (type: esriFieldTypeString, alias: Street_Name, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• Street_Suffix_Type (type: esriFieldTypeString, alias: Street_Suffix_Type, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• Street_Suffix_Direction (type: esriFieldTypeString, alias: Street_Suffix_Direction, SQL Type: sqlTypeOther, length: 9, nullable: true, editable: true)
• Unit_Number (type: esriFieldTypeString, alias: Unit_Number, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
• Unit (type: esriFieldTypeString, alias: Unit, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
• Zip_Code (type: esriFieldTypeString, alias: Zip_Code, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• Full_Address (type: esriFieldTypeString, alias: Full_Address, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• City (type: esriFieldTypeString, alias: City, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• County (type: esriFieldTypeString, alias: County, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• State (type: esriFieldTypeString, alias: State, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• Short_Address (type: esriFieldTypeString, alias: Short_Address, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• Parcel_ID (type: esriFieldTypeString, alias: Parcel_ID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)

Templates:

Name: Vector Tile Site Address Labels
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 8/18/2026 10:26:40 PM

Schema Last Edit Date: 8/18/2026 10:26:40 PM

Data Last Edit Date: 8/18/2026 10:26:40 PM

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