{ "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 26, "name": "Sign Post Maintenance", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": {"creatorField": "UserID2"}, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 1, "name": "PWSDE.PUBWORKS.Sign_Posts_NEW_Staging", "relatedTableId": 21, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "PostGUID", "composite": false } ], "isDataVersioned": true, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "RoadName", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "MaintDateDate", "type": "esriFieldTypeDate", "alias": "Maintenance Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "MaintDateDate" }, { "name": "PostMaintenanceActivityCode2", "type": "esriFieldTypeString", "alias": "Maintenance Activity", "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" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "PostMaintenanceActivityCode2" }, { "name": "MaintenanceReasonCode2", "type": "esriFieldTypeString", "alias": "Maintenance Reason", "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" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MaintenanceReasonCode2" }, { "name": "PostTypeCode2", "type": "esriFieldTypeString", "alias": "Post Type", "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" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "PostTypeCode2" }, { "name": "RoadName", "type": "esriFieldTypeString", "alias": "Road Name", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "RoadName" }, { "name": "RoadNumText", "type": "esriFieldTypeString", "alias": "Road Number", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "RoadNumText" }, { "name": "MilePostsDouble", "type": "esriFieldTypeDouble", "alias": "Milepost", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MilePostsDouble" }, { "name": "NumPostLong", "type": "esriFieldTypeInteger", "alias": "Number of Posts", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "NumPostLong" }, { "name": "SideOfRoad2", "type": "esriFieldTypeString", "alias": "Side of Road", "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" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SideOfRoad2" }, { "name": "PostTreatmentCode2", "type": "esriFieldTypeString", "alias": "Post Treatment", "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" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "PostTreatmentCode2" }, { "name": "Comment2", "type": "esriFieldTypeString", "alias": "Comment", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Comment2" }, { "name": "UserID2", "type": "esriFieldTypeString", "alias": "User ID", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "UserID2" }, { "name": "DateInstalled", "type": "esriFieldTypeString", "alias": "Date Installed", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "DateInstalled" }, { "name": "DateRemoved", "type": "esriFieldTypeString", "alias": "Date Removed", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "DateRemoved" }, { "name": "PostGUID", "type": "esriFieldTypeGUID", "alias": "Post ID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "PostGUID" }, { "name": "RoadNumber", "type": "esriFieldTypeInteger", "alias": "RoadNumber", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "RoadNumber" }, { "name": "Milepost", "type": "esriFieldTypeString", "alias": "Milepost", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "Milepost" }, { "name": "InitialInstallYear", "type": "esriFieldTypeString", "alias": "InitialInstallYear", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "InitialInstallYear" }, { "name": "Latitude", "type": "esriFieldTypeString", "alias": "Latitude", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "Latitude" }, { "name": "Longitude", "type": "esriFieldTypeString", "alias": "Longitude", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "Longitude" }, { "name": "NumberOfPosts", "type": "esriFieldTypeString", "alias": "NumberOfPosts", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "NumberOfPosts" }, { "name": "TransactionAppliedToGISInventor", "type": "esriFieldTypeInteger", "alias": "TransactionAppliedToGISInventory", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TransactionAppliedToGISInventor" }, { "name": "PostGlobalID", "type": "esriFieldTypeGUID", "alias": "PostGlobalID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "PostGlobalID" }, { "name": "PostMaintenanceTransactionsID", "type": "esriFieldTypeInteger", "alias": "PostMaintenanceTransactionsID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PostMaintenanceTransactionsID" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "SignPostGlobalID", "type": "esriFieldTypeString", "alias": "SignPostGlobalID", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "SignPostGlobalID" }, { "name": "MaintDate", "type": "esriFieldTypeString", "alias": "MaintDate", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "MaintDate" }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "PostMaintenanceActivityCode", "type": "esriFieldTypeString", "alias": "Maintenance Activity OLD", "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" }, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "PostMaintenanceActivityCode" }, { "name": "MaintenanceActivityReasonCode", "type": "esriFieldTypeString", "alias": "Maintenance Reason OLD", "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" }, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "MaintenanceActivityReasonCode" }, { "name": "PostTypeCode", "type": "esriFieldTypeString", "alias": "Post Type OLD", "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" }, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "PostTypeCode" }, { "name": "SideOfRoad", "type": "esriFieldTypeString", "alias": "Side of Road OLD", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "SideOfRoad" }, { "name": "PostTreatmentCode", "type": "esriFieldTypeString", "alias": "Post Treatment OLD", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "PostTreatmentCode" }, { "name": "ActivityComment", "type": "esriFieldTypeString", "alias": "Comment OLD", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "ActivityComment" }, { "name": "UserID", "type": "esriFieldTypeString", "alias": "User ID OLD", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "UserID" } ], "indexes": [ { "name": "R4585_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_4585", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_OID_4585", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "RoadNum", "fields": "RoadNumText", "isAscending": true, "isUnique": false, "description": "" }, { "name": "Milepost", "fields": "MilePostsDouble", "isAscending": true, "isUnique": false, "description": "" }, { "name": "MaintDate", "fields": "MaintDateDate", "isAscending": true, "isUnique": false, "description": "" }, { "name": "RoadName", "fields": "RoadName", "isAscending": true, "isUnique": false, "description": "" }, { "name": "MaintenanceActiv", "fields": "PostMaintenanceActivityCode2", "isAscending": true, "isUnique": false, "description": "" }, { "name": "RecordCreator", "fields": "UserID2", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GDB_259852_PostG", "fields": "PostGUID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Sign Post Maintenance", "description": "", "prototype": { "attributes": { "ActivityComment": null, "MaintDateDate": null, "PostMaintenanceActivityCode2": null, "MaintenanceReasonCode2": null, "PostTypeCode2": null, "RoadName": null, "RoadNumText": null, "MilePostsDouble": null, "NumPostLong": null, "SideOfRoad2": null, "PostTreatmentCode2": null, "Comment2": null, "PostTreatmentCode": null, "DateInstalled": null, "DateRemoved": null, "PostGUID": null, "RoadNumber": null, "Milepost": null, "InitialInstallYear": null, "Latitude": null, "Longitude": null, "NumberOfPosts": null, "TransactionAppliedToGISInventor": null, "PostGlobalID": null, "PostMaintenanceTransactionsID": null, "UserID": null, "SignPostGlobalID": null, "MaintDate": null, "PostMaintenanceActivityCode": null, "MaintenanceActivityReasonCode": null, "PostTypeCode": null, "SideOfRoad": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Create,Update,Delete,Uploads,Editing,Sync,Extract", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }