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
{"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