{ "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 7, "name": "Mainline_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": "Orig_Scope_Work_Activity", "type": "esriFieldTypeString", "alias": "Orig_Scope_Work_Activity", "domain": { "type": "codedValue", "name": "dMainline_Work_Activity", "description": "", "codedValues": [ { "name": "Clean / Inspect", "code": "Clean / Inspect" }, { "name": "Inspect/CCTV Only", "code": "Inspect/CCTV Only" }, { "name": "CIPP Lining", "code": "CIPP Lining" }, { "name": "Excavated Point Repair", "code": "Excavated Point Repair" }, { "name": "Same Diameter Pipe Replacement", "code": "Same Diameter Pipe Replacement" }, { "name": "New Pipe (Carrier)", "code": "New Pipe (Carrier)" }, { "name": "New Pipe (Casing)", "code": "New Pipe (Casing)" }, { "name": "Done by others", "code": "Done by others" }, { "name": "Abandoned", "code": "Abandoned" }, { "name": "Does not exist", "code": "Does not exist" }, { "name": "CIPP Spot Repair", "code": "CIPP Spot Repair" }, { "name": "New Pipe", "code": "New Pipe" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 35, "defaultValue": null, "modelName": "Orig_Scope_Rehab" }, { "name": "Material", "type": "esriFieldTypeString", "alias": "Material", "domain": { "type": "codedValue", "name": "WW_VVT_Pipe_Material", "description": "", "codedValues": [ { "name": "Brick and Concrete", "code": "BCO" }, { "name": "Brick", "code": "BRK" }, { "name": "Brick and Stone", "code": "BST" }, { "name": "Cast Iron", "code": "CIP" }, { "name": "Ductile Iron", "code": "DIP" }, { "name": "Extra Strength Clay Pipe", "code": "ESC" }, { "name": "Concrete and Stone", "code": "CST" }, { "name": "Concrete", "code": "CON" }, { "name": "Unknown", "code": "UNK" }, { "name": "Polyvinyl Chloride", "code": "PVC" }, { "name": "Reinforced Concrete Culvert", "code": "RCC" }, { "name": "High Density Polyethylene", "code": "HDE" }, { "name": "Fiberglass Reinforced Pipe", "code": "FGR" }, { "name": "Polycrete", "code": "PRC" }, { "name": "Prestressed Concrete Cylinder", "code": "PCC" }, { "name": "Vitrified Clay Tile", "code": "VCT" }, { "name": "Tile Concrete", "code": "TCO" }, { "name": "Vitrified Clay", "code": "VC" }, { "name": "Terra Cotta", "code": "TC" }, { "name": "Vitrified Clay Block", "code": "VCB" }, { "name": "Reinforced Concrete Pipe", "code": "RCP" }, { "name": "Reinforced Extra Strength Concrete Pipe", "code": "RCX" }, { "name": "Reinforced Polyester Pipe", "code": "RPP" }, { "name": "Centrifugally Cast Fiberglass Reinforced Polymer Mortar", "code": "CCF" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "Material" }, { "name": "Pipe_Size", "type": "esriFieldTypeSmallInteger", "alias": "Pipe_Size", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Pipe_Size" }, { "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": "Pipe_Work_Activity", "type": "esriFieldTypeString", "alias": "Pipe_Work_Activity", "domain": { "type": "codedValue", "name": "dMainline_Work_Activity", "description": "", "codedValues": [ { "name": "Clean / Inspect", "code": "Clean / Inspect" }, { "name": "Inspect/CCTV Only", "code": "Inspect/CCTV Only" }, { "name": "CIPP Lining", "code": "CIPP Lining" }, { "name": "Excavated Point Repair", "code": "Excavated Point Repair" }, { "name": "Same Diameter Pipe Replacement", "code": "Same Diameter Pipe Replacement" }, { "name": "New Pipe (Carrier)", "code": "New Pipe (Carrier)" }, { "name": "New Pipe (Casing)", "code": "New Pipe (Casing)" }, { "name": "Done by others", "code": "Done by others" }, { "name": "Abandoned", "code": "Abandoned" }, { "name": "Does not exist", "code": "Does not exist" }, { "name": "CIPP Spot Repair", "code": "CIPP Spot Repair" }, { "name": "New Pipe", "code": "New Pipe" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "Pipe_Rehab" }, { "name": "Material_Same", "type": "esriFieldTypeString", "alias": "Material_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": "Material_Same" }, { "name": "Pipe_Material", "type": "esriFieldTypeString", "alias": "Pipe_Material", "domain": { "type": "codedValue", "name": "WW_VVT_Pipe_Material", "description": "", "codedValues": [ { "name": "Brick and Concrete", "code": "BCO" }, { "name": "Brick", "code": "BRK" }, { "name": "Brick and Stone", "code": "BST" }, { "name": "Cast Iron", "code": "CIP" }, { "name": "Ductile Iron", "code": "DIP" }, { "name": "Extra Strength Clay Pipe", "code": "ESC" }, { "name": "Concrete and Stone", "code": "CST" }, { "name": "Concrete", "code": "CON" }, { "name": "Unknown", "code": "UNK" }, { "name": "Polyvinyl Chloride", "code": "PVC" }, { "name": "Reinforced Concrete Culvert", "code": "RCC" }, { "name": "High Density Polyethylene", "code": "HDE" }, { "name": "Fiberglass Reinforced Pipe", "code": "FGR" }, { "name": "Polycrete", "code": "PRC" }, { "name": "Prestressed Concrete Cylinder", "code": "PCC" }, { "name": "Vitrified Clay Tile", "code": "VCT" }, { "name": "Tile Concrete", "code": "TCO" }, { "name": "Vitrified Clay", "code": "VC" }, { "name": "Terra Cotta", "code": "TC" }, { "name": "Vitrified Clay Block", "code": "VCB" }, { "name": "Reinforced Concrete Pipe", "code": "RCP" }, { "name": "Reinforced Extra Strength Concrete Pipe", "code": "RCX" }, { "name": "Reinforced Polyester Pipe", "code": "RPP" }, { "name": "Centrifugally Cast Fiberglass Reinforced Polymer Mortar", "code": "CCF" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "Pipe_Material" }, { "name": "Final_Pipe_Size", "type": "esriFieldTypeSmallInteger", "alias": "Final_Pipe_Size", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Final_Pipe_Size" }, { "name": "Pipe_Length_Same", "type": "esriFieldTypeString", "alias": "Pipe_Length_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": "Pipe_Length_Same" }, { "name": "Final_Pipe_Length_FT", "type": "esriFieldTypeInteger", "alias": "Final_Pipe_Length_FT", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Final_Pipe_Length_FT" }, { "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": "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": "Pipe_Size_Same", "type": "esriFieldTypeString", "alias": "Pipe_Size_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": "Pipe_Size_Same" }, { "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": "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": "In_Progress_Comment", "type": "esriFieldTypeString", "alias": "In_Progress_Comment", "domain": null, "editable": true, "nullable": true, "length": 256, "defaultValue": null, "modelName": "In_Progress_Comment" }, { "name": "SEWER_ID", "type": "esriFieldTypeString", "alias": "SEWER_ID", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "SEWER_ID" }, { "name": "Guid_Core", "type": "esriFieldTypeGUID", "alias": "Guid_Core", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "Guid_Core" } ], "indexes": [ { "name": "R57_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "Mainline_Work_Activity_Report", "description": "", "prototype": { "attributes": { "SEWER_ID": null, "Guid_Core": null, "Project_Number": null, "Inspected_By": null, "Inspection_Date": null, "Orig_Scope_Work_Activity": null, "Material": null, "Pipe_Size": null, "Final_Work_Activity_Same": null, "Pipe_Work_Activity": null, "Material_Same": null, "Pipe_Material": null, "Final_Pipe_Size": null, "Pipe_Length_Same": null, "Final_Pipe_Length_FT": null, "Discrepancies": null, "Discrepancy_type": null, "Comments": null, "RelObjectID": null, "Work_Activity_Status": null, "Pipe_Size_Same": null, "In_Service": null, "Full_Scope_Complete": null, "Guid": null, "GlobalID": "{00000000-0000-0000-0000-000000000000}", "CreationDate": null, "Creator": null, "EditDate": null, "Editor": null, "Contractor": null, "In_Progress_Comment": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000000, "supportedQueryFormats": "JSON, geoJSON, PBF", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000000, "maxRecordCountFactor": 1 }