{ "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 21, "name": "PWSDE.PUBWORKS.SignPosts", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 2926, "latestWkid": 2926, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -117104300, "falseY": -99539600, "xyUnits": 3048.0060960121928, "falseZ": -100000, "zUnits": 10000, "falseM": 0, "mUnits": 1 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 50000, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "uniqueValue", "field1": "SignPostType", "uniqueValueInfos": [ { "symbol": { "type": "esriPMS", "url": "03257db3f52fcbe13e024cc090929d56", "imageData": "iVBORw0KGgoAAAANSUhEUgAAAAoAAAAsCAYAAABcxymWAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAAdklEQVQ4jWNhIBKwjFiFxlCMD2xhYWBgkGJgYJhpLMjAIMWJKnv2PQPDs+8MDAwMDH5wqxu0GRh8JNGMec7A4HuEDDeOKhxVOKpwmCpsuMrAMOseqiS0OIErPMvAwJB+9j2krMEBzrIwMDA8Y2BgmEV9Nw4HhQCMYxYrwnfANgAAAABJRU5ErkJggg==", "contentType": "image/png", "width": 7, "height": 33, "angle": 0, "xoffset": 0, "yoffset": 0 }, "value": "BP", "label": "Beacon Pole" }, { "symbol": { "type": "esriPMS", "url": "c023c52a5f0332846d2acccc774864c6", "imageData": "iVBORw0KGgoAAAANSUhEUgAAAAoAAAAsCAYAAABcxymWAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAAfklEQVQ4je3UsQnCUBAG4K94I1hlAQdI6QrqEhZuYJ01DDiEkBUsb4C3QCqHsAmBJygKVvEdXHUf/111yYeV/ha2U7+rIaHBea210hTTLNyNsJ9XH3Q2tgW8GZzsvr+xwgorXCi86Fz1xXB6JzMMHLOQxavASBh5ivrJjUuAD0UJFXlxHhYFAAAAAElFTkSuQmCC", "contentType": "image/png", "width": 7, "height": 33, "angle": 0, "xoffset": 0, "yoffset": 0 }, "value": "OT", "label": "Other" }, { "symbol": { "type": "esriPMS", "url": "85699b6c2dc0db4211bd79bf7e3aad11", "imageData": "iVBORw0KGgoAAAANSUhEUgAAAAoAAAAsCAYAAABcxymWAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAAeElEQVQ4je3UsQ2AIBCF4b9gBCo3oLZmBcfAmnFkCCo3oKa+DawYwoaQ0BhNrJRLrrovd686xc1Sv4Vz7avaFTABmzEGrXU3FRFKKQBLO+2cw1rbwZQS3vvnGQcccMCPwhACMcZuWN9JgxlYReRqYVbAAYT3M34Bni5+GvP3J79zAAAAAElFTkSuQmCC", "contentType": "image/png", "width": 7, "height": 33, "angle": 0, "xoffset": 0, "yoffset": 0 }, "value": "SC", "label": "Steel Channel" }, { "symbol": { "type": "esriPMS", "url": "1d36fb433bc63034ffcaad86e1293ea0", "imageData": "iVBORw0KGgoAAAANSUhEUgAAAAoAAAAsCAYAAABcxymWAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAAd0lEQVQ4je3UoQ2AMBCF4V/UIJGwArJrAGuwRtegc3QE7EksEiQSi6AhqSghyNKXnLovuVNP8TLqt1D7eYpTQA2MpYaiDre7wLEC0N+nGwNVG8LNwdR9+DHDDDNMFM4GFhsufZ3cUIBhl6trIhEFrICNks8/pgBPjXMWKwpjAyIAAAAASUVORK5CYII=", "contentType": "image/png", "width": 7, "height": 33, "angle": 0, "xoffset": 0, "yoffset": 0 }, "value": "SMA", "label": "Signal Mast Arm" }, { "symbol": { "type": "esriPMS", "url": "af6cd52d0e8b0bb0d232917a938c83be", "imageData": "iVBORw0KGgoAAAANSUhEUgAAAAoAAAAsCAYAAABcxymWAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAAeUlEQVQ4jWNhIBKwjFiFxlCMD2xhYWBgkGJgYJipJMbAIMCDKnv/JQPD+68MDAwMDH5wq0MsGBiMlFAVnrvHwNC1iQw3jiocVTiqcJgqXHOCgWHPFVTJD19QFZ5lYGBIv/eKgYHhFU4Dz7IwMDA8Y2BgmEV9Nw4HhQArohWv60iwYwAAAABJRU5ErkJggg==", "contentType": "image/png", "width": 7, "height": 33, "angle": 0, "xoffset": 0, "yoffset": 0 }, "value": "WO", "label": "Wood" } ], "fieldDelimiter": ",", "authoringInfo": { "colorRamp": { "type": "multipart", "colorRamps": [ { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 197, 213, 252, 255 ], "toColor": [ 197, 213, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 182, 252, 185, 255 ], "toColor": [ 182, 252, 185, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 221, 189, 255 ], "toColor": [ 252, 221, 189, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 182, 251, 255 ], "toColor": [ 252, 182, 251, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 210, 252, 243, 255 ], "toColor": [ 210, 252, 243, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 187, 205, 255 ], "toColor": [ 252, 187, 205, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 250, 252, 184, 255 ], "toColor": [ 250, 252, 184, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 194, 182, 252, 255 ], "toColor": [ 194, 182, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 247, 215, 252, 255 ], "toColor": [ 247, 215, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 184, 233, 252, 255 ], "toColor": [ 184, 233, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 189, 252, 218, 255 ], "toColor": [ 189, 252, 218, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 236, 252, 215, 255 ], "toColor": [ 236, 252, 215, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 226, 192, 252, 255 ], "toColor": [ 226, 192, 252, 255 ] } ] } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 2380654.356056884, "ymin": 110730.57754914463, "xmax": 2581380.7495508045, "ymax": 402658.22072680295, "spatialReference": { "wkid": 2926, "latestWkid": 2926, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -117104300, "falseY": -99539600, "xyUnits": 3048.0060960121928, "falseZ": -100000, "zUnits": 10000, "falseM": 0, "mUnits": 1 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "RoadName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "SignPostTreatment", "type": "esriFieldTypeString", "alias": "Post Treatment", "length": 50, "domain": { "type": "codedValue", "name": "SignMaintenancePostTreatment", "description": "Sign Post Treatment for Sign Maintenance in Field Mps", "codedValues": [ { "name": "Paint", "code": "PA" }, { "name": "Galvanizing", "code": "GA" }, { "name": "Other", "code": "OT" }, { "name": "None", "code": "NO" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "RoadNumber", "type": "esriFieldTypeString", "alias": "Road Number", "length": 5, "domain": null }, { "name": "RoadName", "type": "esriFieldTypeString", "alias": "Road Name", "length": 50, "domain": null }, { "name": "LastInspection", "type": "esriFieldTypeDate", "alias": "Last Inspection", "length": 8, "domain": null }, { "name": "PostGUID", "type": "esriFieldTypeGUID", "alias": "PostGUID", "length": 38, "domain": null }, { "name": "LastEditor", "type": "esriFieldTypeString", "alias": "Last Editor", "length": 255, "domain": null }, { "name": "LastEditor2", "type": "esriFieldTypeString", "alias": "Last Editor 2", "length": 255, "domain": null }, { "name": "NewestMaintenance2", "type": "esriFieldTypeString", "alias": "Newest Maintenance", "length": 255, "domain": { "type": "codedValue", "name": "PostMaintenanceActivityCode", "description": "Post Maintenance Activity Code", "codedValues": [ { "name": "Inspect Post", "code": "INSPPOST" }, { "name": "Clear Sight Distance", "code": "CLSIGHTD" }, { "name": "Inventory Correction - Add Post", "code": "ADDPOST" }, { "name": "Inventory Correction - Delete Post", "code": "DELPOST" }, { "name": "Inventory Correction - Update Post", "code": "UPDPOST" }, { "name": "New Post Installation", "code": "NEWPOST" }, { "name": "Relocate Post", "code": "RELOPOST" }, { "name": "Remove Post", "code": "REMVPOST" }, { "name": "Replace Post", "code": "REPLPOST" }, { "name": "Reset Post", "code": "RESEPOST" }, { "name": "Straighten Post", "code": "STRAPOST" }, { "name": "Inventory Correction - Recover Post", "code": "RCVRPOST" }, { "name": "null", "code": "NULL" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "NewestMaintenanceReason2", "type": "esriFieldTypeString", "alias": "Newest Maintenance Reason", "length": 255, "domain": { "type": "codedValue", "name": "MaintenanceReasonCode", "description": "Maintenance Reason Code", "codedValues": [ { "name": "Ball Bank", "code": "BALLBANK" }, { "name": "Construction Project", "code": "CNSTPROJ" }, { "name": "County Code", "code": "CNTYCODE" }, { "name": "CRP 3199 -- Horizontal Curves", "code": "CRP3199" }, { "name": "CRP 3274 -- Stop Sign Safety", "code": "CRP3274" }, { "name": "CRP 3290 -- Horizontal Curves", "code": "CRP3290" }, { "name": "Log", "code": "LOG" }, { "name": "Missing or Stolen", "code": "MISSSTOL" }, { "name": "New Establishment", "code": "NEWEST" }, { "name": "Office Request", "code": "OFFREQ" }, { "name": "Reflection", "code": "REFLECT" }, { "name": "Routine Maintenance", "code": "ROUTINE" }, { "name": "School Bus Sign Review", "code": "SCHOOLB" }, { "name": "Sign Code Revision", "code": "SIGNCODE" }, { "name": "SV \u2013 0326 -- COS Reflective Sign Project", "code": "SV-0326" }, { "name": "Vandalism", "code": "VANDAL" }, { "name": "Weather", "code": "WEATHER" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SignPostType", "type": "esriFieldTypeString", "alias": "Post Type", "length": 50, "domain": { "type": "codedValue", "name": "SignMaintenancePostType", "description": "Sign Post Type for Sign Maintenance in Field Maps", "codedValues": [ { "name": "Steel Channel", "code": "SC" }, { "name": "Signal Mast Arm", "code": "SMA" }, { "name": "Beacon Pole", "code": "BP" }, { "name": "Wood", "code": "WO" }, { "name": "Other", "code": "OT" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MP", "type": "esriFieldTypeDouble", "alias": "Milepost", "domain": null }, { "name": "NumberOfPosts", "type": "esriFieldTypeInteger", "alias": "Number of Posts", "domain": null }, { "name": "SideOfRoad", "type": "esriFieldTypeString", "alias": "Side of Road", "length": 25, "domain": { "type": "codedValue", "name": "SideOfRoad", "description": "Side Of Road", "codedValues": [ { "name": "NULL", "code": "NULL" }, { "name": "A", "code": "A" }, { "name": "B", "code": "B" }, { "name": "C", "code": "C" }, { "name": "E", "code": "E" }, { "name": "ENE", "code": "ENE" }, { "name": "L", "code": "L" }, { "name": "LA", "code": "LA" }, { "name": "LC", "code": "LC" }, { "name": "LT", "code": "LT" }, { "name": "N", "code": "N" }, { "name": "NE", "code": "NE" }, { "name": "NW", "code": "NW" }, { "name": "O", "code": "O" }, { "name": "R", "code": "R" }, { "name": "RC", "code": "RC" }, { "name": "RT", "code": "RT" }, { "name": "S", "code": "S" }, { "name": "SE", "code": "SE" }, { "name": "SW", "code": "SW" }, { "name": "W", "code": "W" }, { "name": "WSW", "code": "WSW" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Comment", "type": "esriFieldTypeString", "alias": "Comment", "length": 255, "domain": null }, { "name": "DateInstalled", "type": "esriFieldTypeDate", "alias": "Date Installed", "length": 8, "domain": null }, { "name": "DateRemoved", "type": "esriFieldTypeDate", "alias": "Date Removed", "length": 8, "domain": null }, { "name": "CountyCode", "type": "esriFieldTypeString", "alias": "County Code", "length": 2, "domain": null }, { "name": "StateLRS", "type": "esriFieldTypeString", "alias": "State LRS", "length": 7, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "Global Post ID", "length": 38, "domain": null }, { "name": "Offset", "type": "esriFieldTypeDouble", "alias": "Offset", "domain": null }, { "name": "PostLength", "type": "esriFieldTypeDouble", "alias": "Post Length", "domain": null }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "PostCondition", "type": "esriFieldTypeInteger", "alias": "PostCondition", "domain": null }, { "name": "InspectionInterval", "type": "esriFieldTypeInteger", "alias": "InspectionInterval", "domain": null }, { "name": "OwnerID", "type": "esriFieldTypeString", "alias": "OwnerID", "length": 50, "domain": null }, { "name": "PostID", "type": "esriFieldTypeInteger", "alias": "OLDPostID", "domain": null }, { "name": "InstallYear", "type": "esriFieldTypeInteger", "alias": "InstallYear", "domain": null }, { "name": "ObjectIDSave", "type": "esriFieldTypeInteger", "alias": "ObjectIDSave", "domain": null }, { "name": "RoadNumNum", "type": "esriFieldTypeInteger", "alias": "RoadNumNum", "domain": null }, { "name": "VALIDATIONSTATUS", "type": "esriFieldTypeSmallInteger", "alias": "VALIDATIONSTATUS", "domain": { "type": "codedValue", "name": "Validation Status", "description": "The current record's validation status.", "codedValues": [ { "name": "No calculation required, no validation required, no error", "code": 0 }, { "name": "No calculation required, no validation required, has error(s)", "code": 1 }, { "name": "No calculation required, validation required, no error", "code": 2 }, { "name": "No calculation required, validation required, has error(s)", "code": 3 }, { "name": "Calculation required, no validation required, no error", "code": 4 }, { "name": "Calculation required, no validation required, has error(s)", "code": 5 }, { "name": "Calculation required, validation required, no error", "code": 6 }, { "name": "Calculation required, validation required, has error(s)", "code": 7 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "R4586_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_4586", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_OID_4586", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "RoadNum", "fields": "RoadNumber", "isAscending": true, "isUnique": false, "description": "" }, { "name": "Milepost", "fields": "MP", "isAscending": true, "isUnique": false, "description": "" }, { "name": "RoadName", "fields": "RoadName", "isAscending": true, "isUnique": false, "description": "" }, { "name": "PostGUID_ID", "fields": "PostGUID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S4425_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 1, "name": "PWSDE.PUBWORKS.Posts_Plates_Work", "relatedTableId": 29, "role": "esriRelRoleOrigin", "keyField": "PostGUID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 2, "name": "PWSDE.PUBWORKS.Sign_Orders", "relatedTableId": 28, "role": "esriRelRoleOrigin", "keyField": "PostGUID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 0, "name": "post_to_plates", "relatedTableId": 22, "role": "esriRelRoleOrigin", "keyField": "PostGUID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "hasZ": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": true, "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, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true }