{ "preferredTimeReference": null, "useStandardizedQueries": true, "maxRecordCount": 2000, "description": null, "datesInUnknownTimezone": false, "type": "Table", "subtypes": [], "relationships": [ { "keyField": "CompanyCode", "role": "esriRelRoleDestination", "catalogID": "{DB82738E-7C25-49ED-A00F-E387EB8D7609}", "composite": false, "name": "Facility", "relatedTableId": 14, "id": 59, "cardinality": "esriRelCardinalityOneToOne" }, { "keyField": "CompanyCode", "role": "esriRelRoleDestination", "catalogID": "{DB82738E-7C25-49ED-A00F-E387EB8D7609}", "composite": false, "name": "Facility", "relatedTableId": 16, "id": 66, "cardinality": "esriRelCardinalityOneToOne" }, { "keyField": "CompanyCode", "role": "esriRelRoleDestination", "catalogID": "{DE22BC30-FF2E-4639-B191-5520CF4F476B}", "composite": false, "name": "Facility", "relatedTableId": 14, "id": 56, "cardinality": "esriRelCardinalityOneToOne" }, { "keyField": "CompanyCode", "role": "esriRelRoleDestination", "catalogID": "{DE22BC30-FF2E-4639-B191-5520CF4F476B}", "composite": false, "name": "Facility", "relatedTableId": 16, "id": 64, "cardinality": "esriRelCardinalityOneToOne" }, { "keyField": "CompanyCode", "role": "esriRelRoleDestination", "catalogID": "{BD9348C8-CDA9-4D54-9F1F-F65938B165D5}", "composite": false, "name": "Well Surface", "relatedTableId": 2, "id": 5, "cardinality": "esriRelCardinalityOneToOne" }, { "keyField": "CompanyCode", "role": "esriRelRoleDestination", "catalogID": "{BD9348C8-CDA9-4D54-9F1F-F65938B165D5}", "composite": false, "name": "Well Surface", "relatedTableId": 3, "id": 11, "cardinality": "esriRelCardinalityOneToOne" }, { "keyField": "CompanyCode", "role": "esriRelRoleDestination", "catalogID": "{BD9348C8-CDA9-4D54-9F1F-F65938B165D5}", "composite": false, "name": "Well Surface", "relatedTableId": 4, "id": 17, "cardinality": "esriRelCardinalityOneToOne" }, { "keyField": "CompanyCode", "role": "esriRelRoleDestination", "catalogID": "{BD9348C8-CDA9-4D54-9F1F-F65938B165D5}", "composite": false, "name": "Well Surface", "relatedTableId": 5, "id": 23, "cardinality": "esriRelCardinalityOneToOne" }, { "keyField": "CompanyCode", "role": "esriRelRoleDestination", "catalogID": "{BD9348C8-CDA9-4D54-9F1F-F65938B165D5}", "composite": false, "name": "Well Surface", "relatedTableId": 6, "id": 29, "cardinality": "esriRelCardinalityOneToOne" }, { "keyField": "CompanyCode", "role": "esriRelRoleDestination", "catalogID": "{BD9348C8-CDA9-4D54-9F1F-F65938B165D5}", "composite": false, "name": "Well Surface", "relatedTableId": 7, "id": 35, "cardinality": "esriRelCardinalityOneToOne" }, { "keyField": "CompanyCode", "role": "esriRelRoleDestination", "catalogID": "{BD9348C8-CDA9-4D54-9F1F-F65938B165D5}", "composite": false, "name": "Well Surface", "relatedTableId": 8, "id": 41, "cardinality": "esriRelCardinalityOneToOne" }, { "keyField": "CompanyCode", "role": "esriRelRoleDestination", "catalogID": "{BD9348C8-CDA9-4D54-9F1F-F65938B165D5}", "composite": false, "name": "Well Surface", "relatedTableId": 11, "id": 47, "cardinality": "esriRelCardinalityOneToOne" }, { "keyField": "CompanyCode", "role": "esriRelRoleDestination", "catalogID": "{BD9348C8-CDA9-4D54-9F1F-F65938B165D5}", "composite": false, "name": "Well Surface", "relatedTableId": 12, "id": 53, "cardinality": "esriRelCardinalityOneToOne" }, { "keyField": "companycode", "role": "esriRelRoleDestination", "catalogID": "{C7C95131-72B1-45FA-BBC9-53F22C383668}", "composite": false, "name": "Well Surface", "relatedTableId": 12, "id": 116, "cardinality": "esriRelCardinalityOneToOne" }, { "keyField": "CompanyCode", "role": "esriRelRoleDestination", "catalogID": "{DD533B0E-4002-4939-9680-577554EFF61C}", "composite": false, "name": "High Pressure Pipline", "relatedTableId": 18, "id": 69, "cardinality": "esriRelCardinalityOneToOne" }, { "keyField": "companycode", "role": "esriRelRoleDestination", "catalogID": "{86EB0B5F-A62F-493E-8FFB-CE3058472570}", "composite": false, "name": "Well Surface", "relatedTableId": 12, "id": 115, "cardinality": "esriRelCardinalityOneToOne" } ], "indexes": [ { "name": "i26companycode", "isUnique": false, "description": "", "fields": "companycode", "isAscending": true }, { "name": "r23_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_23", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true } ], "htmlPopupType": "esriServerHTMLPopupTypeNone", "cimVersion": "3.7.0", "isDataArchived": false, "id": 21, "archivingInfo": { "startArchivingMoment": -1, "supportsQueryWithHistoricMoment": false }, "hasAttachments": false, "advancedQueryCapabilities": { "supportsStatistics": true, "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsTrueCurve": false, "supportsOrderBy": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "useStandardizedQueries": true, "supportsResultPaginationToken": false, "supportsQueryWithDistance": true, "supportsQueryWithCacheHint": false, "supportsCountDistinct": true, "supportsCurrentUserQueries": true, "supportsAdvancedQueryRelated": true, "supportsReturningQueryExtent": true, "supportsPagination": true, "supportsMaxRecordCountFactor": false, "supportsDistinct": true, "supportsTimeRelation": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "subtypeField": null, "subtypeFieldName": null, "supportsStatistics": true, "serviceItemId": "c26761a7c65a4fb0ae73d6ad805ea6e6", "capabilities": "Query,Map,Data", "hasLastEditTime": false, "supportsExceedsLimitStatistics": true, "standardMaxRecordCount": 32000, "isDataVersioned": false, "supportsAdvancedQueries": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": false, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "tileMaxRecordCount": 2000, "currentVersion": 12.1, "typeIdField": null, "defaultSubtypeCode": null, "supportedQueryFormats": "JSON, PBF", "name": "Companies", "displayField": "companyname", "copyrightText": null, "fields": [ { "nullable": false, "domain": null, "name": "objectid", "alias": "OBJECTID", "type": "esriFieldTypeOID" }, { "nullable": true, "domain": null, "name": "companycode", "length": 10, "alias": "Company Code", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "companyname", "length": 255, "alias": "Company Name", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "address", "length": 255, "alias": "Address", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "phonenumber", "length": 255, "alias": "Phone Number", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "status", "length": 255, "alias": "Status", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "statusdate", "alias": "Status Date", "type": "esriFieldTypeDateOnly" }, { "nullable": false, "domain": null, "name": "globalid", "length": 38, "alias": "globalid", "type": "esriFieldTypeGlobalID" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": null }