{ "currentVersion": 10.71, "cimVersion": "2.4.0", "id": 113, "name": "Pole Testing Contract", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "InspectYear", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID" }, { "name": "LocateID", "type": "esriFieldTypeString", "alias": "LocateID", "length": 255 }, { "name": "Class", "type": "esriFieldTypeInteger", "alias": "Class" }, { "name": "InspectYear", "type": "esriFieldTypeInteger", "alias": "InspectYear" }, { "name": "Height", "type": "esriFieldTypeInteger", "alias": "Height" }, { "name": "Species", "type": "esriFieldTypeString", "alias": "Species", "length": 24 }, { "name": "StructType", "type": "esriFieldTypeString", "alias": "StructType", "length": 24 }, { "name": "StructMtrl", "type": "esriFieldTypeString", "alias": "StructMtrl", "length": 255 }, { "name": "Mfg", "type": "esriFieldTypeString", "alias": "Mfg", "length": 24 }, { "name": "OrigCircumference", "type": "esriFieldTypeInteger", "alias": "OrigCircumference" }, { "name": "EffectiveCircumference", "type": "esriFieldTypeInteger", "alias": "EffectiveCircumference" }, { "name": "PoleStatus", "type": "esriFieldTypeString", "alias": "PoleStatus", "length": 12 }, { "name": "OrigTreatment", "type": "esriFieldTypeString", "alias": "OrigTreatment", "length": 24 }, { "name": "Treat", "type": "esriFieldTypeString", "alias": "Treat", "length": 50 }, { "name": "Decay", "type": "esriFieldTypeString", "alias": "Decay", "length": 36 }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 255 }, { "name": "Inspector", "type": "esriFieldTypeString", "alias": "Inspector", "length": 36 }, { "name": "InspectDate", "type": "esriFieldTypeDate", "alias": "InspectDate", "length": 8 }, { "name": "Lat", "type": "esriFieldTypeDouble", "alias": "Lat" }, { "name": "Long_", "type": "esriFieldTypeDouble", "alias": "Long_" }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 50 }, { "name": "Catv", "type": "esriFieldTypeString", "alias": "Catv", "length": 12 }, { "name": "Fiber", "type": "esriFieldTypeString", "alias": "Fiber", "length": 12 }, { "name": "Telco", "type": "esriFieldTypeString", "alias": "Telco", "length": 12 }, { "name": "InspectionType", "type": "esriFieldTypeString", "alias": "InspectionType", "length": 24 }, { "name": "Inspected", "type": "esriFieldTypeString", "alias": "Inspected", "length": 3 }, { "name": "ExternalTreat", "type": "esriFieldTypeString", "alias": "ExternalTreat", "length": 3 }, { "name": "InternalTreat", "type": "esriFieldTypeString", "alias": "InternalTreat", "length": 3 }, { "name": "FumigantHoles", "type": "esriFieldTypeInteger", "alias": "FumigantHoles" }, { "name": "Completed", "type": "esriFieldTypeString", "alias": "Completed", "length": 3 }, { "name": "TreatmentDate", "type": "esriFieldTypeDate", "alias": "TreatmentDate", "length": 8 }, { "name": "Administration", "type": "esriFieldTypeString", "alias": "Administration", "length": 24 }, { "name": "CompanyName", "type": "esriFieldTypeString", "alias": "CompanyName", "length": 50 }, { "name": "PoleTag", "type": "esriFieldTypeString", "alias": "PoleTag", "length": 4 }, { "name": "PoleClass", "type": "esriFieldTypeInteger", "alias": "PoleClass" }, { "name": "PoleInstallDate", "type": "esriFieldTypeString", "alias": "PoleInstallDate", "length": 10 } ], "indexes": [ { "name": "R835_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G2321LocateID", "fields": "LocateID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 11, "name": "Pole", "relatedTableId": 3, "role": "esriRelRoleDestination", "keyField": "LocateID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }