{ "currentVersion": 10.91, "id": 1, "name": "Electric.GIS.TransformerInspections", "type": "Table", "description": null, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "PCB", "type": "esriFieldTypeString", "alias": "PCB", "length": 5, "domain": { "type": "codedValue", "name": "YesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PAINT", "type": "esriFieldTypeString", "alias": "Paint", "length": 10, "domain": { "type": "codedValue", "name": "Paint", "description": "", "codedValues": [ { "name": "Good", "code": "Good" }, { "name": "Faded", "code": "Faded" }, { "name": "Bad", "code": "Bad" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PAINTYEAR", "type": "esriFieldTypeString", "alias": "Re-paint (year)", "length": 5, "domain": null }, { "name": "RUST", "type": "esriFieldTypeString", "alias": "Rust", "length": 20, "domain": { "type": "codedValue", "name": "Rust", "description": "", "codedValues": [ { "name": "None", "code": "None" }, { "name": "Surface Rust", "code": "Surface Rust" }, { "name": "Bad", "code": "Bad" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "HOLES", "type": "esriFieldTypeString", "alias": "Holes", "length": 15, "domain": { "type": "codedValue", "name": "Holes", "description": "", "codedValues": [ { "name": "None", "code": "None" }, { "name": "Pin Holes", "code": "Pin Holes" }, { "name": "Large Holes", "code": "Large Holes" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PAD", "type": "esriFieldTypeString", "alias": "Transforemer pad", "length": 20, "domain": { "type": "codedValue", "name": "Transformer", "description": "", "codedValues": [ { "name": "Good", "code": "Good" }, { "name": "Needs Replacing", "code": "Needs Replacing" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LEVEL_", "type": "esriFieldTypeString", "alias": "Level", "length": 15, "domain": { "type": "codedValue", "name": "Level", "description": "", "codedValues": [ { "name": "Level", "code": "Level" }, { "name": "Needs Leveling", "code": "Needs Leveling" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ANTS", "type": "esriFieldTypeString", "alias": "Ants", "length": 15, "domain": { "type": "codedValue", "name": "Ants", "description": "", "codedValues": [ { "name": "None", "code": "None" }, { "name": "Small Mound", "code": "Small Mound" }, { "name": "Large Mound", "code": "Large Mound" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ANTTREAT", "type": "esriFieldTypeString", "alias": "Ant treatment", "length": 5, "domain": { "type": "codedValue", "name": "YesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DTANTTREAT", "type": "esriFieldTypeString", "alias": "Date Ant treatment (year)", "length": 5, "domain": null }, { "name": "DTINSPECTION", "type": "esriFieldTypeDate", "alias": "Inspection Date", "length": 8, "domain": null }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "Name tag picture", "length": 5, "domain": { "type": "codedValue", "name": "YesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CURRTRANS", "type": "esriFieldTypeString", "alias": "Current Transformers", "length": 5, "domain": { "type": "codedValue", "name": "YesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CTSIZE", "type": "esriFieldTypeString", "alias": "CT's size", "length": 10, "domain": { "type": "codedValue", "name": "CT", "description": "", "codedValues": [ { "name": "100/5", "code": "100/5" }, { "name": "200/5", "code": "200/5" }, { "name": "300/5", "code": "300/5" }, { "name": "400/5", "code": "400/5" }, { "name": "500/5", "code": "500/5" }, { "name": "600/5", "code": "600/5" }, { "name": "800/5", "code": "800/5" }, { "name": "1000/5", "code": "1000/5" }, { "name": "1200/5", "code": "1200/5" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "POTTRANS", "type": "esriFieldTypeString", "alias": "Potential Transformer", "length": 5, "domain": { "type": "codedValue", "name": "YesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PTRATIO", "type": "esriFieldTypeString", "alias": "PT ratio", "length": 5, "domain": { "type": "codedValue", "name": "PT", "description": "", "codedValues": [ { "name": "2:4", "code": "2:4" }, { "name": "2:5", "code": "2:5" }, { "name": "20:1", "code": "20:1" }, { "name": "60:1", "code": "60:1" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ELBOW", "type": "esriFieldTypeString", "alias": "Elbow's", "length": 15, "domain": { "type": "codedValue", "name": "Attention", "description": "", "codedValues": [ { "name": "Good", "code": "Good" }, { "name": "Needs Attention", "code": "Needs Attention" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SECONDARY", "type": "esriFieldTypeString", "alias": "Secondary", "length": 15, "domain": { "type": "codedValue", "name": "Attention", "description": "", "codedValues": [ { "name": "Good", "code": "Good" }, { "name": "Needs Attention", "code": "Needs Attention" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LEAKINGOIL", "type": "esriFieldTypeString", "alias": "Leaking Oil", "length": 5, "domain": { "type": "codedValue", "name": "YesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ARNDTRANS", "type": "esriFieldTypeString", "alias": "Around Transformer", "length": 20, "domain": { "type": "codedValue", "name": "Trim", "description": "", "codedValues": [ { "name": "Clean", "code": "Clean" }, { "name": "Trimming Needed", "code": "Trimming Needed" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "COMMENTS", "type": "esriFieldTypeString", "alias": "Comments", "length": 500, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "FacilityKey", "type": "esriFieldTypeString", "alias": "FacilityKey", "length": 50, "domain": null } ], "indexes": [ { "name": "R491_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_491", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GDB_2099_Facilit", "fields": "FacilityKey", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_491", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "Electric.GIS.TransformerBank", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "FacilityKey", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null }