{ "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 2, "name": "MH_Work_Activity_Report", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "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 }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ] }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "Project_Number", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "Project_Number", "type": "esriFieldTypeString", "alias": "Project_Number", "domain": { "type": "codedValue", "name": "dProject", "description": "", "codedValues": [ { "name": "SC940", "code": "940" }, { "name": "SC941", "code": "941" }, { "name": "SC1021", "code": "1021" }, { "name": "SC1019", "code": "1019" }, { "name": "SC1020R", "code": "1020R" }, { "name": "SC1022", "code": "1022" }, { "name": "SC966", "code": "966" }, { "name": "SC978", "code": "978" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Project_Number" }, { "name": "Inspected_By", "type": "esriFieldTypeString", "alias": "Inspected_By", "domain": { "type": "codedValue", "name": "dInspector_1", "description": "", "codedValues": [ { "name": "Chris Peake", "code": "Chris Peake" }, { "name": "Indranil Goswami", "code": "Indranil Goswami" }, { "name": "Mike Griffith", "code": "Mike Griffith" }, { "name": "John Haugh", "code": "John Haugh" }, { "name": "Leon Foy", "code": "Leon Foy" }, { "name": "Zia Obaidi", "code": "Zia Obaidi" }, { "name": "Jose Rose", "code": "Jose Rose" }, { "name": "William Hill", "code": "William Hill" }, { "name": "Daniel Yilma", "code": "Daniel Yilma" }, { "name": "Babalola Gbenga Joshua", "code": "Babalola Gbenga Joshua" }, { "name": "Tracey Blue", "code": "Tracey Blue" }, { "name": "Calvin Stancill", "code": "Calvin Stancill" }, { "name": "Dustin Shearer", "code": "Dustin Shearer" }, { "name": "Paul Burgee", "code": "Paul Burgee" }, { "name": "Divyang Baldota", "code": "Divyang Baldota" }, { "name": "Jason Barnes", "code": "Jason Barnes" }, { "name": "Jeff Schmidbauer", "code": "Jeff Schmidbauer" }, { "name": "Bruce Williams", "code": "Bruce Williams" }, { "name": "Shiela Smith", "code": "Shiela Smith" }, { "name": "John Palardy", "code": "John Palardy" }, { "name": "Matt Ferguson", "code": "Matt Ferguson" }, { "name": "Gary Howard", "code": "Gary Howard" }, { "name": "Zach Jankiewicz", "code": "Zach Jankiewicz" }, { "name": "Russell Begley", "code": "Russell Begley" }, { "name": "Michael Sedler", "code": "Michael Sedler" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Inspected_By" }, { "name": "Inspection_Date", "type": "esriFieldTypeDate", "alias": "Inspection_Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "Inspection_Date" }, { "name": "Final_Work_Activity_Same", "type": "esriFieldTypeString", "alias": "Final_Work_Activity_Same", "domain": { "type": "codedValue", "name": "dYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "Final_Rehab_Same" }, { "name": "MH_Work_Activity", "type": "esriFieldTypeString", "alias": "MH_Work_Activity", "domain": { "type": "codedValue", "name": "dMH_Work_Activity", "description": "", "codedValues": [ { "name": "Replace Existing Manhole", "code": "A" }, { "name": "Install New Manhole", "code": "B" }, { "name": "Install Doghouse MH", "code": "C" }, { "name": "Install Drop Connection", "code": "E" }, { "name": "Remove Lamphole & Install MH", "code": "D" }, { "name": "Replace Ex. MH Frame & Cover with Standard Frame & Cover", "code": "F" }, { "name": "Replace Ex. MH Frame & Cover with Watertight Frame & Cover", "code": "G" }, { "name": "Replace Ex. MH Frame & Cover with Locking Frame & Cover", "code": "H" }, { "name": "Replace MH Cover Only", "code": "I" }, { "name": "Reset MH Frame & Cover", "code": "J" }, { "name": "Install External Frame Seal", "code": "K" }, { "name": "Install Internal Frame Seal", "code": "L" }, { "name": "Replace Adjusting Rings", "code": "M" }, { "name": "Replace MH Steps", "code": "N" }, { "name": "Grout and Seal MH Wall", "code": "O" }, { "name": "Apply Interior Coating - Cementitious", "code": "P" }, { "name": "Apply Interior Coating - Epoxy / Resin", "code": "Q" }, { "name": "Repair Bench and / or Invert", "code": "R" }, { "name": "Repair Pipe Seal", "code": "S" }, { "name": "Conduct MH Inspection", "code": "T" }, { "name": "Open MH", "code": "U" }, { "name": "Locate, Raise MH to Grade", "code": "V" }, { "name": "Raise MH To Grade", "code": "W" }, { "name": "Remove Existing Water Valve", "code": "X" }, { "name": "Cleaning", "code": "Y" }, { "name": "Replace Loose & Missing Bricks / Rebuild Wall", "code": "Z" }, { "name": "Heavy Cleaning & Chemical Root Treatment", "code": "AAA" }, { "name": "Inflow Insert", "code": "AA" }, { "name": "MH Seal", "code": "BB" }, { "name": "Abandon Manhole / Lamphole in Place", "code": "CC" }, { "name": "Does not Exist", "code": "DD" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "MH_Rehab" }, { "name": "New_MH_Depth", "type": "esriFieldTypeDouble", "alias": "New_MH_Depth", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "New_MH_Depth" }, { "name": "New_MH_Dia", "type": "esriFieldTypeDouble", "alias": "New_MH_Dia", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "New_MH_Dia" }, { "name": "MH_Install_Date", "type": "esriFieldTypeDate", "alias": "MH_Install_Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "MH_Install_Date" }, { "name": "MH_Work_Activity_Date", "type": "esriFieldTypeDate", "alias": "MH_Work_Activity_Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "MH_Rehab_Date" }, { "name": "Comment", "type": "esriFieldTypeString", "alias": "Comment", "domain": null, "editable": true, "nullable": true, "length": 256, "defaultValue": null, "modelName": "Comment" }, { "name": "Discrepancies", "type": "esriFieldTypeString", "alias": "Discrepancies", "domain": { "type": "codedValue", "name": "dYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "Discrepancies" }, { "name": "Discrepancy_type", "type": "esriFieldTypeString", "alias": "Discrepancy_type", "domain": { "type": "codedValue", "name": "dDiscrepancy", "description": "", "codedValues": [ { "name": "Alignment", "code": "Alignment" }, { "name": "Slope", "code": "Slope" }, { "name": "Invert Elevation", "code": "Invert Elevation" }, { "name": "Output Elevation", "code": "Output Elevation" }, { "name": "Other (see comments)", "code": "Other (see comments)" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "Discrepancy_type" }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "domain": null, "editable": true, "nullable": true, "length": 256, "defaultValue": null, "modelName": "Comments" }, { "name": "RelObjectID", "type": "esriFieldTypeInteger", "alias": "RelObjectID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "RelObjectID" }, { "name": "Orig_Scope_Work_Activity", "type": "esriFieldTypeString", "alias": "Orig_Scope_Work_Activity", "domain": { "type": "codedValue", "name": "dMH_Work_Activity", "description": "", "codedValues": [ { "name": "Replace Existing Manhole", "code": "A" }, { "name": "Install New Manhole", "code": "B" }, { "name": "Install Doghouse MH", "code": "C" }, { "name": "Install Drop Connection", "code": "E" }, { "name": "Remove Lamphole & Install MH", "code": "D" }, { "name": "Replace Ex. MH Frame & Cover with Standard Frame & Cover", "code": "F" }, { "name": "Replace Ex. MH Frame & Cover with Watertight Frame & Cover", "code": "G" }, { "name": "Replace Ex. MH Frame & Cover with Locking Frame & Cover", "code": "H" }, { "name": "Replace MH Cover Only", "code": "I" }, { "name": "Reset MH Frame & Cover", "code": "J" }, { "name": "Install External Frame Seal", "code": "K" }, { "name": "Install Internal Frame Seal", "code": "L" }, { "name": "Replace Adjusting Rings", "code": "M" }, { "name": "Replace MH Steps", "code": "N" }, { "name": "Grout and Seal MH Wall", "code": "O" }, { "name": "Apply Interior Coating - Cementitious", "code": "P" }, { "name": "Apply Interior Coating - Epoxy / Resin", "code": "Q" }, { "name": "Repair Bench and / or Invert", "code": "R" }, { "name": "Repair Pipe Seal", "code": "S" }, { "name": "Conduct MH Inspection", "code": "T" }, { "name": "Open MH", "code": "U" }, { "name": "Locate, Raise MH to Grade", "code": "V" }, { "name": "Raise MH To Grade", "code": "W" }, { "name": "Remove Existing Water Valve", "code": "X" }, { "name": "Cleaning", "code": "Y" }, { "name": "Replace Loose & Missing Bricks / Rebuild Wall", "code": "Z" }, { "name": "Heavy Cleaning & Chemical Root Treatment", "code": "AAA" }, { "name": "Inflow Insert", "code": "AA" }, { "name": "MH Seal", "code": "BB" }, { "name": "Abandon Manhole / Lamphole in Place", "code": "CC" }, { "name": "Does not Exist", "code": "DD" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "Orig_Scope_Rehab" }, { "name": "Work_Activity_Status", "type": "esriFieldTypeString", "alias": "Work_Activity_Status", "domain": { "type": "codedValue", "name": "dWork_Activity_Status", "description": "", "codedValues": [ { "name": "Not Complete/Removed from Scope", "code": "Not Complete" }, { "name": "In Progress", "code": "In Progress" }, { "name": "Current Work Activity Complete", "code": "Current Complete" }, { "name": "All Work Activities Complete", "code": "All Complete" }, { "name": "All Work Activities Complete and Asset in Service", "code": "All Complete+Service" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "Rehab_Status" }, { "name": "In_Service", "type": "esriFieldTypeString", "alias": "In_Service", "domain": { "type": "codedValue", "name": "dYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "In_Service" }, { "name": "Full_Scope_Complete", "type": "esriFieldTypeString", "alias": "Full_Scope_Complete", "domain": { "type": "codedValue", "name": "dYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "Full_Scope_Complete" }, { "name": "Guid", "type": "esriFieldTypeGUID", "alias": "Guid", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "Guid" }, { "name": "GlobalID", "type": "esriFieldTypeGUID", "alias": "GlobalID", "domain": null, "editable": true, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "CreationDate", "type": "esriFieldTypeDate", "alias": "CreationDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "CreationDate" }, { "name": "Creator", "type": "esriFieldTypeString", "alias": "Creator", "domain": null, "editable": true, "nullable": true, "length": 128, "defaultValue": null, "modelName": "Creator" }, { "name": "EditDate", "type": "esriFieldTypeDate", "alias": "EditDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "EditDate" }, { "name": "Editor", "type": "esriFieldTypeString", "alias": "Editor", "domain": null, "editable": true, "nullable": true, "length": 128, "defaultValue": null, "modelName": "Editor" }, { "name": "In_Prog_Comment", "type": "esriFieldTypeString", "alias": "In_Prog_Comment", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "In_Prog_Comment" }, { "name": "Contractor", "type": "esriFieldTypeString", "alias": "Contractor", "domain": { "type": "codedValue", "name": "dFirm", "description": "", "codedValues": [ { "name": "Northeast Remsco Const., Inc", "code": "Northeast Remsco Const., Inc" }, { "name": "Anchor Const., Corp.", "code": "Anchor Const., Corp." }, { "name": "REI", "code": "REI" }, { "name": "Spiniello Companies", "code": "Spiniello Companies" }, { "name": "MDVP", "code": "MDVP" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "Contractor" }, { "name": "MANHOLE_ID", "type": "esriFieldTypeString", "alias": "MANHOLE_ID", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "MANHOLE_ID" }, { "name": "Guid_Core", "type": "esriFieldTypeGUID", "alias": "Guid_Core", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "Guid_Core" } ], "indexes": [ { "name": "R58_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "MH_Work_Activity_Report", "description": "", "prototype": { "attributes": { "MANHOLE_ID": null, "Guid_Core": null, "Project_Number": null, "Inspected_By": null, "Inspection_Date": null, "Final_Work_Activity_Same": null, "MH_Work_Activity": null, "New_MH_Depth": null, "New_MH_Dia": null, "MH_Install_Date": null, "MH_Work_Activity_Date": null, "Comment": null, "Discrepancies": null, "Discrepancy_type": null, "Comments": null, "RelObjectID": null, "Orig_Scope_Work_Activity": null, "Work_Activity_Status": null, "In_Service": null, "Full_Scope_Complete": null, "Guid": null, "GlobalID": "{00000000-0000-0000-0000-000000000000}", "CreationDate": null, "Creator": null, "EditDate": null, "Editor": null, "In_Prog_Comment": null, "Contractor": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 100000, "supportedQueryFormats": "JSON, geoJSON, PBF", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "standardMaxRecordCount": 32000, "tileMaxRecordCount": 100000, "maxRecordCountFactor": 1 }