{ "currentVersion": 10.61, "id": 48, "name": "LeakRepair", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": { "allowOthersToDelete": false, "allowOthersToUpdate": true, "allowOthersToQuery": true }, "syncCanReturnChanges": true, "relationships": [ { "id": 2, "name": "Leak", "relatedTableId": 4, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "RelatedGuid", "composite": false } ], "isDataVersioned": true, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": false, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true }, "hasAttachments": true, "supportsAttachmentsByUploadId": true, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "RepairedDate", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false }, { "name": "LeakCause", "type": "esriFieldTypeString", "alias": "Leak Cause", "domain": { "type": "codedValue", "name": "LeakCause", "description": "Leak Cause", "codedValues": [ { "name": "Corrosion", "code": "CORR" }, { "name": "Natural Forces", "code": "NATFOR" }, { "name": "Excavation", "code": "EX" }, { "name": "Other Outside Force", "code": "OTHOUTFOR" }, { "name": "Material Or Welds", "code": "MATORWELD" }, { "name": "Equipment", "code": "EQUIP" }, { "name": "Operations", "code": "OPER" }, { "name": "Other", "code": "OTH" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 30 }, { "name": "Component", "type": "esriFieldTypeString", "alias": "Component", "domain": { "type": "codedValue", "name": "Leak Component", "description": "", "codedValues": [ { "name": "Pipe", "code": "Pipe" }, { "name": "Valve", "code": "Valve" }, { "name": "Fitting", "code": "Fitting" }, { "name": "Drip", "code": "Drip" }, { "name": "Regulator", "code": "Regulator" }, { "name": "Tap Connection", "code": "Tap" }, { "name": "Other", "code": "OTH" }, { "name": "Unknown", "code": "UNK" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 30 }, { "name": "ConditionOfPipe", "type": "esriFieldTypeString", "alias": "Condition Of Adjoining Pipe", "domain": { "type": "codedValue", "name": "Condition", "description": "", "codedValues": [ { "name": "Needs to be Replaced", "code": "NR" }, { "name": "Not Applicable", "code": "NA" }, { "name": "Okay", "code": "OK" }, { "name": "Other", "code": "OTH" }, { "name": "Unknown", "code": "UNK" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 30 }, { "name": "PartOfSystem", "type": "esriFieldTypeString", "alias": "Part Of System", "domain": { "type": "codedValue", "name": "Leak Source", "description": "", "codedValues": [ { "name": "Main", "code": "MAIN" }, { "name": "Service", "code": "SERV" }, { "name": "Service Tap", "code": "SERVTAP" }, { "name": "Valve", "code": "VALVE" }, { "name": "Meter", "code": "METSET" }, { "name": "Regulator", "code": "REG" }, { "name": "Fitting", "code": "FITTING" }, { "name": "Other", "code": "OTH" }, { "name": "Unknown", "code": "UNK" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 30 }, { "name": "PipeSize", "type": "esriFieldTypeString", "alias": "Pipe Size", "domain": { "type": "codedValue", "name": "PipeSizeTxt", "description": "Pipe Sizes in Text", "codedValues": [ { "name": "5/8\"", "code": ".62" }, { "name": "3/4\"", "code": ".75" }, { "name": "1\"", "code": "1" }, { "name": "1-1/4\"", "code": "1.25" }, { "name": "1-1/2\"", "code": "1.5" }, { "name": "1-3/4\"", "code": "1.75" }, { "name": "2\"", "code": "2" }, { "name": "2-1/2\"", "code": "2.5" }, { "name": "3\"", "code": "3" }, { "name": "4\"", "code": "4" }, { "name": "6\"", "code": "6" }, { "name": "8\"", "code": "8" }, { "name": "10\"", "code": "10" }, { "name": "1/2\"", "code": "0.5" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 30 }, { "name": "PipeMaterial", "type": "esriFieldTypeString", "alias": "Pipe Material", "domain": { "type": "codedValue", "name": "LEAK PIPE MATERIAL", "description": "LEAK PIPE MATERIAL", "codedValues": [ { "name": "BARE STEEL", "code": "BARE STEEL" }, { "name": "COATED STEEL", "code": "COATED STEEL" }, { "name": "DUCTILE IRON", "code": "DUCTILE IRON" }, { "name": "OTHER", "code": "OTH" }, { "name": "UNKNOWN", "code": "UNK" }, { "name": "POLYETHYLENE", "code": "PLASTIC" }, { "name": "PE INSERTED", "code": "PLASTIC INSERTED" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 30 }, { "name": "NumberLeaks", "type": "esriFieldTypeInteger", "alias": "Number of Leaks", "domain": null, "editable": true, "nullable": true }, { "name": "RepairsMade", "type": "esriFieldTypeString", "alias": "Repairs Made", "domain": null, "editable": true, "nullable": true, "length": 255 }, { "name": "RepairedBy", "type": "esriFieldTypeString", "alias": "Repaired By", "domain": null, "editable": true, "nullable": true, "length": 50 }, { "name": "RepairedDate", "type": "esriFieldTypeDate", "alias": "Repaired Date", "domain": null, "editable": true, "nullable": true, "length": 8 }, { "name": "GasOff", "type": "esriFieldTypeString", "alias": "Gas Off", "domain": { "type": "codedValue", "name": "YES/NO", "description": "YES OR NO VALUES", "codedValues": [ { "name": "YES", "code": "YES" }, { "name": "NO", "code": "NO" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 10 }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "domain": null, "editable": true, "nullable": true, "length": 255 }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "domain": null, "editable": true, "nullable": true, "length": 255 }, { "name": "WorkOrderNumber", "type": "esriFieldTypeString", "alias": "Work Order Number", "domain": null, "editable": true, "nullable": true, "length": 25 }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "Leak Number", "domain": null, "editable": false, "nullable": false, "length": 38 }, { "name": "RelatedGuid", "type": "esriFieldTypeGUID", "alias": "RelatedGuid", "domain": null, "editable": true, "nullable": true, "length": 38 }, { "name": "AtmoCorrosion", "type": "esriFieldTypeString", "alias": "Atmospheric Corrosion", "domain": { "type": "codedValue", "name": "Yes/No Indicator", "description": "", "codedValues": [ { "name": "Other", "code": "OTH" }, { "name": "Unknown", "code": "UNK" }, { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" }, { "name": "Yes", "code": "Yes" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 50 }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255 }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8 }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255 }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8 } ], "indexes": [ { "name": "R45_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_45", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G150RelatedGuid", "fields": "RelatedGuid", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_45", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "LeakRepair", "description": "", "prototype": { "attributes": { "RelatedGuid": null, "WorkOrderNumber": null, "LeakCause": null, "Component": null, "ConditionOfPipe": null, "PartOfSystem": null, "PipeSize": null, "PipeMaterial": null, "NumberLeaks": null, "RepairsMade": null, "RepairedBy": null, "RepairedDate": null, "GasOff": null, "Location": null, "Comments": null, "AtmoCorrosion": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, AMF, geoJSON", "capabilities": "Create,Query,Update,Sync,Delete,Extract,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 1000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1 }