{ "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 2, "name": "Sign Installation", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 4326, "latestWkid": 4326, "xyTolerance": 8.983152841195215E-9, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -400, "falseY": -400, "xyUnits": 9.999999999999999E8, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "spatialReference": { "wkid": 102723, "latestWkid": 3735, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -119670700, "falseY": -95612900, "xyUnits": 3048.0060960121928, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "uniqueValue", "valueExpression": "var age = DateDiff( Now(), $feature['SDE.Sign_Sub.InstallDate'], 'years')\n\nIf (age < 3)\n {\n return \"Installed 0 to 2 years ago\"\n }\nElse If (age > 2 && age < 6) \n {\n return \"Installed 3 to 5 years ago\"\n }\nElse If (age > 5 && age < 11) \n {\n return \"Installed 6 to 10 years ago\"\n }\nElse If (age > 10) \n {\n return \"Installed more than 10 years ago\"\n }\nElse\n {\n return \"Bad Installed Year\"\n }", "valueExpressionTitle": "Custom", "defaultSymbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 130, 130, 130, 255 ], "size": 4, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 } }, "defaultLabel": "", "uniqueValueGroups": [ { "heading": "Custom", "classes": [ { "label": "Bad Installed Year", "description": "Bad Installed Year", "symbol": { "type": "esriSMS", "style": "esriSMSSquare", "color": [ 197, 0, 255, 255 ], "size": 7, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 } }, "values": [ [ "Bad Installed Year" ] ] }, { "label": "Installed 0 to 2 years ago", "description": "Installed 0 to 2 years ago", "symbol": { "type": "esriSMS", "style": "esriSMSSquare", "color": [ 56, 168, 0, 255 ], "size": 7, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 } }, "values": [ [ "Installed 0 to 2 years ago" ] ] }, { "label": "Installed 3 to 5 years ago", "description": "Installed 3 to 5 years ago", "symbol": { "type": "esriSMS", "style": "esriSMSSquare", "color": [ 255, 255, 0, 255 ], "size": 7, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 } }, "values": [ [ "Installed 3 to 5 years ago" ] ] }, { "label": "Installed 6 to 10 years ago", "description": "Installed 6 to 10 years ago", "symbol": { "type": "esriSMS", "style": "esriSMSSquare", "color": [ 255, 170, 0, 255 ], "size": 7, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 } }, "values": [ [ "Installed 6 to 10 years ago" ] ] }, { "label": "Installed more than 10 years ago", "description": "Installed more than 10 years ago", "symbol": { "type": "esriSMS", "style": "esriSMSSquare", "color": [ 255, 0, 0, 255 ], "size": 7, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 } }, "values": [ [ "Installed more than 10 years ago" ] ] } ] } ], "uniqueValueInfos": [ { "symbol": { "type": "esriSMS", "style": "esriSMSSquare", "color": [ 197, 0, 255, 255 ], "size": 7, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 } }, "value": "Bad Installed Year", "label": "Bad Installed Year" }, { "symbol": { "type": "esriSMS", "style": "esriSMSSquare", "color": [ 56, 168, 0, 255 ], "size": 7, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 } }, "value": "Installed 0 to 2 years ago", "label": "Installed 0 to 2 years ago" }, { "symbol": { "type": "esriSMS", "style": "esriSMSSquare", "color": [ 255, 255, 0, 255 ], "size": 7, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 } }, "value": "Installed 3 to 5 years ago", "label": "Installed 3 to 5 years ago" }, { "symbol": { "type": "esriSMS", "style": "esriSMSSquare", "color": [ 255, 170, 0, 255 ], "size": 7, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 } }, "value": "Installed 6 to 10 years ago", "label": "Installed 6 to 10 years ago" }, { "symbol": { "type": "esriSMS", "style": "esriSMSSquare", "color": [ 255, 0, 0, 255 ], "size": 7, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 } }, "value": "Installed more than 10 years ago", "label": "Installed more than 10 years ago" } ], "fieldDelimiter": ",", "authoringInfo": { "colorRamp": { "type": "multipart", "colorRamps": [ { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 228, 202, 255 ], "toColor": [ 252, 228, 202, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 199, 179, 252, 255 ], "toColor": [ 199, 179, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 179, 252, 182, 255 ], "toColor": [ 179, 252, 182, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 182, 249, 252, 255 ], "toColor": [ 182, 249, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 182, 215, 255 ], "toColor": [ 252, 182, 215, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 216, 215, 252, 255 ], "toColor": [ 216, 215, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 242, 252, 184, 255 ], "toColor": [ 242, 252, 184, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 210, 252, 220, 255 ], "toColor": [ 210, 252, 220, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 251, 182, 252, 255 ], "toColor": [ 251, 182, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 202, 204, 255 ], "toColor": [ 252, 202, 204, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 210, 250, 255 ], "toColor": [ 252, 210, 250, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 179, 222, 252, 255 ], "toColor": [ 179, 222, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 249, 252, 212, 255 ], "toColor": [ 249, 252, 212, 255 ] } ] } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": false, "extent": { "xmin": 1495112.31362093, "ymin": 372317.4671877927, "xmax": 1730540.7942616437, "ymax": 625039.662752113, "spatialReference": { "wkid": 102723, "latestWkid": 3735, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -119670700, "falseY": -95612900, "xyUnits": 3048.0060960121928, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": true, "attachmentProperties": [ { "name": "id", "fieldName": "ATTACHMENTID", "isEnabled": true }, { "name": "globalid", "fieldName": "GLOBALID", "isEnabled": true }, { "name": "keywords", "fieldName": "KEYWORDS", "isEnabled": false }, { "name": "name", "fieldName": "ATT_NAME", "isEnabled": true }, { "name": "contentType", "fieldName": "CONTENT_TYPE", "isEnabled": true }, { "name": "size", "fieldName": "DATA_SIZE", "isEnabled": true }, { "name": "exifInfo", "fieldName": "EXIFINFO", "isEnabled": false } ], "attachmentFields": [ { "name": "ATTACHMENTID", "type": "esriFieldTypeOID", "alias": "ATTACHMENTID", "editable": false, "nullable": false, "length": 4, "domain": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "editable": false, "nullable": false, "length": 38, "domain": null }, { "name": "ATT_NAME", "type": "esriFieldTypeString", "alias": "ATT_NAME", "editable": true, "nullable": false, "length": 250, "domain": null }, { "name": "CONTENT_TYPE", "type": "esriFieldTypeString", "alias": "CONTENT_TYPE", "editable": true, "nullable": false, "length": 150, "domain": null }, { "name": "DATA_SIZE", "type": "esriFieldTypeInteger", "alias": "DATA_SIZE", "editable": true, "nullable": false, "length": 4, "domain": null } ], "supportsAttachmentsResizing": true, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "SDE.Sign_Main.RouteName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "SDE.Sign_Main.OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "SDE.Sign_Main.Quardrant", "type": "esriFieldTypeSmallInteger", "alias": "Quardrant", "domain": { "type": "codedValue", "name": "D_SIGN_QUARDRANT", "description": "Quardrant of the county.", "codedValues": [ { "name": "North-West", "code": 1 }, { "name": "North-East", "code": 2 }, { "name": "South-West", "code": 3 }, { "name": "South-East", "code": 4 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SDE.Sign_Sub.MUTCD", "type": "esriFieldTypeString", "alias": "MUTCD Code", "length": 50, "domain": null }, { "name": "SDE.Sign_Sub.RotSym", "type": "esriFieldTypeDouble", "alias": "Symbol Rotation", "domain": null }, { "name": "SDE.Sign_Sub.InstallDate", "type": "esriFieldTypeDate", "alias": "Installed Date", "length": 8, "domain": null }, { "name": "SDE.Sign_Main.CMT_Latitude", "type": "esriFieldTypeDouble", "alias": "Latitude", "domain": null }, { "name": "SDE.Sign_Main.CMT_Longitude", "type": "esriFieldTypeDouble", "alias": "Longitude", "domain": null }, { "name": "SDE.Sign_Main.CMT_Map_Label", "type": "esriFieldTypeString", "alias": "CMT Map Label", "length": 255, "domain": null }, { "name": "SDE.Sign_Main.CMT_Map_Style1", "type": "esriFieldTypeString", "alias": "CMT Map Style 1", "length": 255, "domain": null }, { "name": "SDE.Sign_Main.CMT_Map_Style2", "type": "esriFieldTypeString", "alias": "CMT Map Style 2", "length": 255, "domain": null }, { "name": "SDE.Sign_Main.CMT_Map_Style3", "type": "esriFieldTypeString", "alias": "CMT Map Style 3", "length": 255, "domain": null }, { "name": "SDE.Sign_Main.CMT_Data_Key", "type": "esriFieldTypeString", "alias": "CMT Data Key", "length": 255, "domain": null }, { "name": "SDE.Sign_Main.CMT_Job_Number", "type": "esriFieldTypeInteger", "alias": "Job Number", "domain": null }, { "name": "SDE.Sign_Main.isActive", "type": "esriFieldTypeSmallInteger", "alias": "CMT Is Active", "domain": null }, { "name": "SDE.Sign_Main.created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "SDE.Sign_Main.created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "SDE.Sign_Main.last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "SDE.Sign_Main.last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "SDE.Sign_Main.reviewNeededInd", "type": "esriFieldTypeSmallInteger", "alias": "reviewNeededInd", "domain": { "type": "codedValue", "name": "D_BOL_TRUEFALSE", "description": "True or false choice.", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 }, { "name": "Not Checked", "code": 3 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SDE.Sign_Sub.CMT_Latitude", "type": "esriFieldTypeDouble", "alias": "Latitude", "domain": null }, { "name": "SDE.Sign_Sub.CMT_Longitude", "type": "esriFieldTypeDouble", "alias": "Longitude", "domain": null }, { "name": "SDE.Sign_Sub.CMT_Map_Label", "type": "esriFieldTypeString", "alias": "CMT Map Label", "length": 255, "domain": null }, { "name": "SDE.Sign_Sub.CMT_Map_Style1", "type": "esriFieldTypeString", "alias": "CMT Map Style 1", "length": 255, "domain": null }, { "name": "SDE.Sign_Sub.CMT_Map_Style2", "type": "esriFieldTypeString", "alias": "CMT Map Style 2", "length": 255, "domain": null }, { "name": "SDE.Sign_Sub.CMT_Map_Style3", "type": "esriFieldTypeString", "alias": "CMT Map Style 3", "length": 255, "domain": null }, { "name": "SDE.Sign_Sub.CMT_Data_Key", "type": "esriFieldTypeString", "alias": "CMT Data Key", "length": 255, "domain": null }, { "name": "SDE.Sign_Sub.CMT_Job_Number", "type": "esriFieldTypeInteger", "alias": "Job Number", "domain": null }, { "name": "SDE.Sign_Sub.isActive", "type": "esriFieldTypeSmallInteger", "alias": "CMT Is Active", "domain": null }, { "name": "SDE.Sign_Sub.created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "SDE.Sign_Sub.created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "SDE.Sign_Sub.last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "SDE.Sign_Sub.last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "SDE.Sign_Sub.SIGN_CATEGORY", "type": "esriFieldTypeSmallInteger", "alias": "SIGN_CATEGORY", "domain": { "type": "codedValue", "name": "D_SIGNS_CATEGORY", "description": "Choices of sign category.", "codedValues": [ { "name": "Regulatory", "code": 1 }, { "name": "Warning", "code": 2 }, { "name": "Directional", "code": 3 }, { "name": "Information", "code": 4 }, { "name": "Logos", "code": 5 }, { "name": "Markers", "code": 6 }, { "name": "Miscellaneous (Guide)", "code": 7 }, { "name": "Recreational & Cultural", "code": 8 }, { "name": "TODS", "code": 9 }, { "name": "Emergency Management", "code": 10 }, { "name": "Object / End-of-Roadway Markers", "code": 11 }, { "name": "School", "code": 12 }, { "name": "Temporary Traffic Control", "code": 13 }, { "name": "Other", "code": 99 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "geometryField": {}, "indexes": null, "subtypes": [], "relationships": [ { "id": 1, "name": "Sign_Sub", "relatedTableId": 3, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{337BAFA5-D972-4619-930A-771968AEAE0D}" } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 4000, "maxSelectionCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": false, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAttachments": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "f18c8b2f9013471eabe4e539e50fd37e" }