{ "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 6, "name": "Storm CB Eval", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 0, "name": "GIS_CityUtilities.DBO.storm_manhole", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "ASSETWORKS_ID", "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, "supportsQueryAttachments": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ] }, "hasMetadata": true, "hasAttachments": true, "supportsAttachmentsByUploadId": true, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "ASSETWORKS_ID", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "ASSETWORKS_ID", "type": "esriFieldTypeString", "alias": "Assetworks ID", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ASSETWORKS_ID" }, { "name": "MaintenanceType", "type": "esriFieldTypeString", "alias": "Maintenance Type", "domain": { "type": "codedValue", "name": "MaintenanceType", "description": "Maintenance types", "codedValues": [ { "name": "Storm CB Eval", "code": "Storm CB Eval" }, { "name": "Repair/Replace", "code": "Repair/Replace" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MaintenanceType" }, { "name": "DatePerformed", "type": "esriFieldTypeDate", "alias": "Date Performed", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DatePerformed" }, { "name": "CurbBoxCondition", "type": "esriFieldTypeString", "alias": "Curb Box Condition", "domain": { "type": "codedValue", "name": "CurbBoxCond", "description": "Curb box conditions", "codedValues": [ { "name": "Good", "code": "Good" }, { "name": "Replace", "code": "Replace" }, { "name": "None", "code": "None" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": "Good", "modelName": "CurbBoxCondition" }, { "name": "GrateCondition", "type": "esriFieldTypeString", "alias": "Grate Condition", "domain": { "type": "codedValue", "name": "GrateFrameCondition", "description": "Grate and Frame Conditions", "codedValues": [ { "name": "Good", "code": "Good" }, { "name": "Replace", "code": "Replace" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": "Good", "modelName": "GrateCondition" }, { "name": "FrameCondition", "type": "esriFieldTypeString", "alias": "Frame Condition", "domain": { "type": "codedValue", "name": "GrateFrameCondition", "description": "Grate and Frame Conditions", "codedValues": [ { "name": "Good", "code": "Good" }, { "name": "Replace", "code": "Replace" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": "Good", "modelName": "FrameCondition" }, { "name": "ChimneyCondition", "type": "esriFieldTypeString", "alias": "Chimney Condition", "domain": { "type": "codedValue", "name": "ChimneyCondition", "description": "Chimney conditions", "codedValues": [ { "name": "Good", "code": "Good" }, { "name": "Repair", "code": "Repair" }, { "name": "Replace (>6)", "code": "Replace (>6)" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": "Good", "modelName": "ChimneyCondition" }, { "name": "ConeCondition", "type": "esriFieldTypeString", "alias": "Cone Condition", "domain": { "type": "codedValue", "name": "ConeCondition", "description": "Cone conditions", "codedValues": [ { "name": "Good", "code": "Good" }, { "name": "Repair (Tuck Point)", "code": "Repair (Tuck Point)" }, { "name": "Replace", "code": "Replace" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": "Good", "modelName": "ConeCondition" }, { "name": "BarrelCondition", "type": "esriFieldTypeString", "alias": "Barrel Condition", "domain": { "type": "codedValue", "name": "BarrelCondition", "description": "Barrel conditions", "codedValues": [ { "name": "Good", "code": "Good" }, { "name": "Repair (Lead)", "code": "Repair (Lead)" }, { "name": "Replace (Barrel Shot)", "code": "Replace-Barrel Shot" }, { "name": "Replace (Bottom Shot)", "code": "Replace (Bottom Shot)" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": "Good", "modelName": "BarrelCondition" }, { "name": "PriorityRating", "type": "esriFieldTypeString", "alias": "Priority Rating", "domain": { "type": "codedValue", "name": "PriorityRating", "description": "Priority ratings", "codedValues": [ { "name": "Within 3 yrs", "code": "Within 3 yrs" }, { "name": "Within 1 yr", "code": "Within 1 yr" }, { "name": "Emergency", "code": "Emergency" }, { "name": "ReEval Next Cycle", "code": "ReEval Next Cycle" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "PriorityRating" }, { "name": "EvaluationStatus", "type": "esriFieldTypeString", "alias": "Evaluation Status", "domain": { "type": "codedValue", "name": "EvalStatus", "description": "Evaluation status", "codedValues": [ { "name": "Complete", "code": "Complete" }, { "name": "Fabric", "code": "Fabric" }, { "name": "Evaluation Unfinished", "code": "Evaluation Unfinished" }, { "name": "Cleaning Unfinished", "code": "Cleaning Unfinished" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "EvaluationStatus" }, { "name": "CIP", "type": "esriFieldTypeString", "alias": "CIP", "domain": { "type": "codedValue", "name": "Yes or No", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "CIP" }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "domain": null, "editable": true, "nullable": true, "length": 500, "defaultValue": null, "modelName": "Comments" }, { "name": "ContractNum", "type": "esriFieldTypeString", "alias": "Cotnract Number", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ContractNum" }, { "name": "HotlineClearDate", "type": "esriFieldTypeDate", "alias": "Hotline Clear Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "HotlineClearDate" }, { "name": "WorkZoneTPC", "type": "esriFieldTypeString", "alias": "Work Zone TPC", "domain": { "type": "codedValue", "name": "WorkZoneSiteTPC", "description": "Work zone TPC values", "codedValues": [ { "name": "N/A", "code": "N/A" }, { "name": "Needed", "code": "Needed" }, { "name": "Staged/placed", "code": "Staged/placed" }, { "name": "Ready to pick up", "code": "Ready to pick up" }, { "name": "Picked up", "code": "Picked up" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "WorkZoneTPC" }, { "name": "SiteBarricades", "type": "esriFieldTypeString", "alias": "Site Barricades", "domain": { "type": "codedValue", "name": "WorkZoneSiteTPC", "description": "Work zone TPC values", "codedValues": [ { "name": "N/A", "code": "N/A" }, { "name": "Needed", "code": "Needed" }, { "name": "Staged/placed", "code": "Staged/placed" }, { "name": "Ready to pick up", "code": "Ready to pick up" }, { "name": "Picked up", "code": "Picked up" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SiteBarricades" }, { "name": "WorkStartDate", "type": "esriFieldTypeDate", "alias": "Work Start Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WorkStartDate" }, { "name": "WorkType", "type": "esriFieldTypeString", "alias": "Work Type", "domain": { "type": "codedValue", "name": "WorkType", "description": "Work types", "codedValues": [ { "name": "Chimney", "code": "Chimney" }, { "name": "Cone", "code": "Cone" }, { "name": "Chimney and Cone", "code": "Chimney and Cone" }, { "name": "Lead", "code": "Lead" }, { "name": "Structure", "code": "Structure" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "WorkType" }, { "name": "ChimneyRepair", "type": "esriFieldTypeString", "alias": "Chimney Repair", "domain": { "type": "codedValue", "name": "ChimneyRepair", "description": "Chimney repair", "codedValues": [ { "name": "None", "code": "None" }, { "name": "Tuck Point", "code": "Tuck Point" }, { "name": "BrickWork", "code": "BrickWork" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": "None", "modelName": "ChimneyRepair" }, { "name": "ConeRepair", "type": "esriFieldTypeString", "alias": "Cone Repair", "domain": { "type": "codedValue", "name": "ConeRepair", "description": "Cone repair", "codedValues": [ { "name": "None", "code": "None" }, { "name": "Tuck Point", "code": "Tuck Point" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": "None", "modelName": "ConeRepair" }, { "name": "BarrelRepair", "type": "esriFieldTypeString", "alias": "Barrel Repair", "domain": { "type": "codedValue", "name": "BarrelRepair", "description": "Barrel Repair", "codedValues": [ { "name": "None", "code": "None" }, { "name": "Lead repaired", "code": "Lead repaired" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": "None", "modelName": "BarrelRepair" }, { "name": "ReplacedCurbBox", "type": "esriFieldTypeString", "alias": "Replaced Curb Box", "domain": { "type": "codedValue", "name": "Yes or No", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ReplacedCurbBox" }, { "name": "ReplacedGrate", "type": "esriFieldTypeString", "alias": "Replaced Grate", "domain": { "type": "codedValue", "name": "Yes or No", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ReplacedGrate" }, { "name": "ReplacedFrame", "type": "esriFieldTypeString", "alias": "Replaced Frame", "domain": { "type": "codedValue", "name": "Yes or No", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ReplacedFrame" }, { "name": "Drystacked", "type": "esriFieldTypeString", "alias": "Drystacked", "domain": { "type": "codedValue", "name": "Yes or No", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Drystacked" }, { "name": "GradedDrilled", "type": "esriFieldTypeString", "alias": "Graded & Drilled", "domain": { "type": "codedValue", "name": "Yes or No", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "GradedDrilled" }, { "name": "MEAS_CONCRETE", "type": "esriFieldTypeInteger", "alias": "Measurement Concrete (Cubic Yard)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MEAS_CONCRETE" }, { "name": "MEAS_ASPHALT", "type": "esriFieldTypeInteger", "alias": "Measurement Asphalt (Ton)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MEAS_ASPHALT" }, { "name": "ReadyForConcrete", "type": "esriFieldTypeString", "alias": "Ready for Concrete", "domain": { "type": "codedValue", "name": "Yes or No", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ReadyForConcrete" }, { "name": "StrippedBackfilled", "type": "esriFieldTypeString", "alias": "Stripped & Backfilled", "domain": { "type": "codedValue", "name": "Yes or No", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "StrippedBackfilled" }, { "name": "WorkComments", "type": "esriFieldTypeString", "alias": "Work Comments", "domain": null, "editable": true, "nullable": true, "length": 500, "defaultValue": null, "modelName": "WorkComments" }, { "name": "WorkCompleteDate", "type": "esriFieldTypeDate", "alias": "Work Complete Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WorkCompleteDate" }, { "name": "DateRequested", "type": "esriFieldTypeDate", "alias": "Date Requested", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DateRequested" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" } ], "indexes": [ { "name": "R317_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_12887_ASSETW", "fields": "ASSETWORKS_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_317", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_OID_317", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "Central Standard Time", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "Storm CB Eval", "description": "", "prototype": { "attributes": { "last_edited_user": null, "created_date": null, "ASSETWORKS_ID": null, "MaintenanceType": null, "DatePerformed": null, "CurbBoxCondition": "Good", "GrateCondition": "Good", "FrameCondition": "Good", "ChimneyCondition": "Good", "ConeCondition": "Good", "BarrelCondition": "Good", "PriorityRating": null, "EvaluationStatus": null, "CIP": null, "Comments": null, "ContractNum": null, "HotlineClearDate": null, "WorkZoneTPC": null, "SiteBarricades": null, "WorkStartDate": null, "WorkType": null, "ChimneyRepair": "None", "ConeRepair": "None", "BarrelRepair": "None", "ReplacedCurbBox": null, "ReplacedGrate": null, "ReplacedFrame": null, "Drystacked": null, "GradedDrilled": null, "MEAS_CONCRETE": null, "MEAS_ASPHALT": null, "ReadyForConcrete": null, "StrippedBackfilled": null, "WorkComments": null, "WorkCompleteDate": null, "DateRequested": null, "last_edited_date": null, "created_user": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "attachmentProperties": [ { "name": "id", "fieldName": "ATTACHMENTID", "isEnabled": true }, { "name": "globalId", "fieldName": "GLOBALID", "isEnabled": false }, { "name": "name", "fieldName": "ATT_NAME", "isEnabled": true }, { "name": "size", "fieldName": "DATA_SIZE", "isEnabled": true }, { "name": "contentType", "fieldName": "CONTENT_TYPE", "isEnabled": true }, { "name": "keywords", "fieldName": "KEYWORDS", "isEnabled": false }, { "name": "exifInfo", "fieldName": "EXIFINFO", "isEnabled": false } ], "attachmentFields": [ { "name": "ATTACHMENTID", "type": "esriFieldTypeOID", "alias": "ATTACHMENTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null }, { "name": "ATT_NAME", "type": "esriFieldTypeString", "alias": "ATT_NAME", "domain": null, "editable": true, "nullable": false, "length": 250, "defaultValue": null }, { "name": "DATA_SIZE", "type": "esriFieldTypeInteger", "alias": "DATA_SIZE", "domain": null, "editable": true, "nullable": false, "defaultValue": null }, { "name": "CONTENT_TYPE", "type": "esriFieldTypeString", "alias": "CONTENT_TYPE", "domain": null, "editable": true, "nullable": false, "length": 150, "defaultValue": null } ], "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "3d0a825842f64e4f8270bd36a7a8c01f" }