{
"layers" : [
{
"currentVersion" : 12,
"id" : 57,
"name" : "Vector Tile Site Address Labels",
"type" : "Feature Layer",
"serviceItemId" : "9d2b1a9985c84996ab36250298322b14",
"cacheMaxAge" : 30,
"displayField" : "Street_Name",
"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",
"copyrightText" : "",
"defaultVisibility" : true,
"editingInfo" : {
"lastEditDate" : 1787092000217,
"schemaLastEditDate" : 1787092000217,
"dataLastEditDate" : 1787092000217
},
"relationships" : [],
"isDataVersioned" : false,
"hasContingentValuesDefinition" : false,
"supportsAppend" : true,
"supportsCalculate" : true,
"supportsASyncCalculate" : true,
"supportsTruncate" : false,
"supportsAttachmentsByUploadId" : true,
"supportsAttachmentsResizing" : true,
"supportsRollbackOnFailureParameter" : true,
"supportsStatistics" : true,
"supportsExceedsLimitStatistics" : true,
"supportsAdvancedQueries" : true,
"supportsValidateSql" : true,
"supportsCoordinatesQuantization" : true,
"supportsLayerOverrides" : true,
"supportsTilesAndBasicQueriesMode" : true,
"supportsFieldDescriptionProperty" : true,
"supportsQuantizationEditMode" : true,
"supportsColumnStoreIndex" : true,
"supportsApplyEditsWithGlobalIds" : true,
"supportsReturningQueryGeometry" : true,
"enableNullGeometry" : false,
"advancedQueryCapabilities" : {
"supportsPagination" : true,
"supportsPaginationOnAggregatedQueries" : true,
"supportsQueryRelatedPagination" : true,
"supportsQueryWithDistance" : true,
"supportsOutDistance" : true,
"supportsReturningQueryExtent" : true,
"supportsStatistics" : true,
"supportsOrderBy" : true,
"supportsDistinct" : true,
"supportsQueryWithResultType" : true,
"supportsSqlExpression" : true,
"supportsTimeRelation" : true,
"supportsAdvancedQueryRelated" : true,
"supportsCountDistinct" : true,
"supportsPercentileStatistics" : true,
"supportsApproxPercentileStatistics" : true,
"supportsSpatialAggregationStatistics" : true,
"supportedSpatialAggregationStatistics" : [
"EnvelopeAggregate",
"CentroidAggregate",
"ConvexHullAggregate"
],
"supportsLod" : true,
"supportsQueryWithLodSR" : false,
"supportedLodTypes" : [
"geohash"
],
"supportsReturningGeometryCentroid" : false,
"supportsReturningGeometryEnvelope" : false,
"supportsQueryWithDatumTransformation" : true,
"supportsCurrentUserQueries" : true,
"supportsHavingClause" : true,
"supportsOutFieldSQLExpression" : true,
"supportsMaxRecordCountFactor" : true,
"supportsTopFeaturesQuery" : true,
"supportsDisjointSpatialRel" : true,
"supportsQueryWithCacheHint" : true,
"supportedOperationsWithCacheHint" : [
"query",
"queryTopFilter",
"queryAnalytics",
"queryAttachments",
"queryRelated",
"queryBins",
"queryPivot"
],
"supportsQueryAnalytic" : true,
"supportsQueryPivot" : true,
"supportsQueryBins" : true,
"supportsDefaultSR" : true,
"supportsTranslations" : false,
"supportsAggIds" : true,
"supportsQueryWithCollation" : true,
"supportsISODOW" : true,
"supportsISOWeek" : true,
"supportsFullTextSearch" : true,
"fullTextSearchCapabilities" : {
"supportsAccentSensitivity" : true,
"supportsStopWords" : true,
"supportsSearchOperator" : true,
"supportsOperator" : true
}
},
"advancedQueryAnalyticCapabilities" : {
"supportsLinearRegression" : true,
"supportsTrendlineRegression" : true,
"supportsAsync" : true,
"supportsPercentileAnalytic" : true
},
"queryBinsCapabilities" : {
"supportsAsync" : true,
"supportsAutoIntervalBin" : true,
"supportsFixedIntervalBin" : true,
"supportsFixedBoundariesBin" : true,
"supportsDateBin" : true,
"supportsClassificationBin" : true,
"supportsStackBy" : true,
"supportsSplitBy" : true,
"supportsFirstDayOfWeek" : true,
"supportsSnapToData" : true,
"supportsReturnFullIntervalBin" : true,
"supportsReturnStackValueRange" : true,
"supportsNormalization" : true,
"supportedStatisticTypes" : [
"COUNT",
"SUM",
"AVG",
"VAR",
"STDDEV",
"MIN",
"MAX",
"PERCENTILE_CONT",
"PERCENTILE_DISC",
"APPROX_PERCENTILE_CONT",
"APPROX_PERCENTILE_DISC",
"CentroidAggregate",
"EnvelopeAggregate",
"ConvexHullAggregate"
],
"supportedNormalizationTypes" : [
"boxCox",
"field",
"inverse",
"log",
"naturalLog",
"percentOfTotal",
"squareRoot"
]
},
"supportedOperationsWithCollation" : "query,addField,updateField",
"advancedEditingCapabilities" : {
"supportedSqlFormatsInCalculate" : [
"standard"
],
"supportsAsyncApplyEdits" : true,
"supportsReturnEditResults" : true,
"supportsApplyEditsbyUploadID" : true,
"supportedApplyEditsUploadIDFormats" : "JSON,PBF",
"supportsTranslation" : false,
"supportsMaxTranslations" : 10
},
"infoInEstimates" : [
"extent",
"count"
],
"useStandardizedQueries" : true,
"geometryType" : "esriGeometryPoint",
"minScale" : 4513.988705,
"maxScale" : 0,
"extent" : {
"xmin" : -13612836.947326917,
"ymin" : 6109913.6090847217,
"xmax" : -13593281.64516641,
"ymax" : 6136721.7948467173,
"spatialReference" : {
"wkid" : 102100,
"latestWkid" : 3857
}
},
"drawingInfo":{"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"}}}]},
"allowGeometryUpdates" : true,
"hasAttachments" : false,
"htmlPopupType" : "esriServerHTMLPopupTypeAsHTMLText",
"hasMetadata" : true,
"hasM" : false,
"hasZ" : true,
"enableZDefaults" : true,
"zDefault" : 0,
"objectIdField" : "OBJECTID",
"uniqueIdField" :
{
"name" : "OBJECTID",
"isSystemMaintained" : true
},
"globalIdField" : "GlobalID",
"typeIdField" : "",
"collation" : {
"locale" : "neutral",
"caseSensitive" : false,
"accentSensitive" : true
},
"fields" : [
{
"name" : "OBJECTID",
"type" : "esriFieldTypeOID",
"alias" : "OBJECTID",
"sqlType" : "sqlTypeOther",
"nullable" : false,
"editable" : false,
"domain" : null,
"defaultValue" : null
},
{
"name" : "Address_Number",
"type" : "esriFieldTypeString",
"alias" : "Address_Number",
"sqlType" : "sqlTypeOther",
"length" : 6,
"nullable" : true,
"editable" : true,
"domain" : null,
"defaultValue" : null
},
{
"name" : "Full_Street_Name",
"type" : "esriFieldTypeString",
"alias" : "Full_Street_Name",
"sqlType" : "sqlTypeOther",
"length" : 122,
"nullable" : true,
"editable" : true,
"domain" : null,
"defaultValue" : null
},
{
"name" : "Street_Prefix_Direction",
"type" : "esriFieldTypeString",
"alias" : "Street_Prefix_Direction",
"sqlType" : "sqlTypeOther",
"length" : 9,
"nullable" : true,
"editable" : true,
"domain" : null,
"defaultValue" : null
},
{
"name" : "Street_Prefix_Type",
"type" : "esriFieldTypeString",
"alias" : "Street_Prefix_Type",
"sqlType" : "sqlTypeOther",
"length" : 25,
"nullable" : true,
"editable" : true,
"domain" : null,
"defaultValue" : null
},
{
"name" : "Street_Name",
"type" : "esriFieldTypeString",
"alias" : "Street_Name",
"sqlType" : "sqlTypeOther",
"length" : 60,
"nullable" : true,
"editable" : true,
"domain" : null,
"defaultValue" : null
},
{
"name" : "Street_Suffix_Type",
"type" : "esriFieldTypeString",
"alias" : "Street_Suffix_Type",
"sqlType" : "sqlTypeOther",
"length" : 15,
"nullable" : true,
"editable" : true,
"domain" : null,
"defaultValue" : null
},
{
"name" : "Street_Suffix_Direction",
"type" : "esriFieldTypeString",
"alias" : "Street_Suffix_Direction",
"sqlType" : "sqlTypeOther",
"length" : 9,
"nullable" : true,
"editable" : true,
"domain" : null,
"defaultValue" : null
},
{
"name" : "Unit_Number",
"type" : "esriFieldTypeString",
"alias" : "Unit_Number",
"sqlType" : "sqlTypeOther",
"length" : 75,
"nullable" : true,
"editable" : true,
"domain" : null,
"defaultValue" : null
},
{
"name" : "Unit",
"type" : "esriFieldTypeString",
"alias" : "Unit",
"sqlType" : "sqlTypeOther",
"length" : 75,
"nullable" : true,
"editable" : true,
"domain" : null,
"defaultValue" : null
},
{
"name" : "Zip_Code",
"type" : "esriFieldTypeString",
"alias" : "Zip_Code",
"sqlType" : "sqlTypeOther",
"length" : 5,
"nullable" : true,
"editable" : true,
"domain" : null,
"defaultValue" : null
},
{
"name" : "Full_Address",
"type" : "esriFieldTypeString",
"alias" : "Full_Address",
"sqlType" : "sqlTypeOther",
"length" : 150,
"nullable" : true,
"editable" : true,
"domain" : null,
"defaultValue" : null
},
{
"name" : "City",
"type" : "esriFieldTypeString",
"alias" : "City",
"sqlType" : "sqlTypeOther",
"length" : 100,
"nullable" : true,
"editable" : true,
"domain" : null,
"defaultValue" : null
},
{
"name" : "County",
"type" : "esriFieldTypeString",
"alias" : "County",
"sqlType" : "sqlTypeOther",
"length" : 40,
"nullable" : true,
"editable" : true,
"domain" : null,
"defaultValue" : null
},
{
"name" : "State",
"type" : "esriFieldTypeString",
"alias" : "State",
"sqlType" : "sqlTypeOther",
"length" : 2,
"nullable" : true,
"editable" : true,
"domain" : null,
"defaultValue" : null
},
{
"name" : "GlobalID",
"type" : "esriFieldTypeGlobalID",
"alias" : "GlobalID",
"sqlType" : "sqlTypeOther",
"length" : 38,
"nullable" : false,
"editable" : false,
"domain" : null,
"defaultValue" : null
},
{
"name" : "Short_Address",
"type" : "esriFieldTypeString",
"alias" : "Short_Address",
"sqlType" : "sqlTypeOther",
"length" : 150,
"nullable" : true,
"editable" : true,
"domain" : null,
"defaultValue" : null
},
{
"name" : "Parcel_ID",
"type" : "esriFieldTypeString",
"alias" : "Parcel_ID",
"sqlType" : "sqlTypeOther",
"length" : 50,
"nullable" : true,
"editable" : true,
"domain" : null,
"defaultValue" : null
}
],
"indexes" : [
{
"name" : "PK__VECTOR_T__F4B70D851624D92D",
"fields" : "OBJECTID",
"isAscending" : true,
"isUnique" : true,
"description" : "",
"indexType" : "Attribute"
},
{
"name" : "user_17710.VECTOR_TILE_SITE_ADDRESS_LABELS_VECTOR_TILE_SITE_ADDRESS_LABELS2_Shape_sidx",
"fields" : "Shape",
"isAscending" : true,
"isUnique" : false,
"description" : "",
"indexType" : "Spatial"
},
{
"name" : "FDO_GlobalID",
"fields" : "GlobalID",
"isAscending" : true,
"isUnique" : true,
"description" : "",
"indexType" : "Attribute"
}
],
"dateFieldsTimeReference" : {
"timeZone" : "UTC",
"timeZoneIANA" : "Etc/UTC",
"respectsDaylightSaving" : false
},
"preferredTimeReference" : null,
"types" : [],
"templates" : [
{
"name" : "Vector Tile Site Address Labels",
"description" : "",
"drawingTool" : "esriFeatureEditToolPoint",
"prototype" : {
"attributes" : {
"Short_Address" : null,
"Address_Number" : null,
"Full_Street_Name" : null,
"Street_Prefix_Direction" : null,
"Street_Prefix_Type" : null,
"Street_Name" : null,
"Street_Suffix_Type" : null,
"Street_Suffix_Direction" : null,
"Unit_Number" : null,
"Unit" : null,
"Zip_Code" : null,
"Full_Address" : null,
"City" : null,
"County" : null,
"State" : null,
"Parcel_ID" : null
}
}
}
],
"supportedQueryFormats" : "JSON, geoJSON, PBF",
"supportedAppendFormats" : "sqlite,geoPackage,shapefile,filegdb,featureCollection,geojson,csv,excel,jsonl,featureService,pbf",
"supportedAppendSourceFilterFormats" : "sqlite,geoPackage,shapefile,filegdb,featureService",
"supportedExportFormats" : "csv,shapefile,sqlite,geoPackage,filegdb,featureCollection,geojson,kml,excel,parquet",
"supportedConvertFileFormats" : "JSON,PBF,Parquet",
"supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection",
"supportedSpatialRelationships" : [
"esriSpatialRelIntersects",
"esriSpatialRelContains",
"esriSpatialRelCrosses",
"esriSpatialRelEnvelopeIntersects",
"esriSpatialRelIndexIntersects",
"esriSpatialRelOverlaps",
"esriSpatialRelTouches",
"esriSpatialRelWithin",
"esriSpatialRelDisjoint",
"esriSpatialRelRelation"
],
"guidFormat" : "",
"supportsContingentValues" : true,
"supportsEditingContingentValues" : true,
"supportedContingentValuesFormats" : "JSON, PBF",
"supportsFieldGroups" : true,
"supportedSyncDataOptions" : 260,
"hasStaticData" : false,
"maxRecordCount" : 2000,
"standardMaxRecordCount" : 16000,
"maxIdsCount" : 1000000,
"standardMaxRecordCountNoGeometry" : 32000,
"tileMaxRecordCount" : 8000,
"maxRecordCountFactor" : 1,
"capabilities" : "Query"
}
],
"tables" : []
}