{ "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 3, "name": "WWFBUILDING", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "ASSETNAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ASSETID", "type": "esriFieldTypeString", "alias": "Asset ID\n\n", "length": 100, "domain": null }, { "name": "ASSETNAME", "type": "esriFieldTypeString", "alias": "Asset Name\n\n", "length": 255, "domain": null }, { "name": "ASSETTYPE", "type": "esriFieldTypeString", "alias": "Asset Type\n\n", "length": 50, "domain": null }, { "name": "ASSETOWNER", "type": "esriFieldTypeString", "alias": "Asset Owner\n", "length": 50, "domain": null }, { "name": "LEGACYID", "type": "esriFieldTypeString", "alias": "Legacy ID\n", "length": 50, "domain": null }, { "name": "TAGNUMBER", "type": "esriFieldTypeString", "alias": "Tag Number\n", "length": 50, "domain": null }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "Status\n\n", "length": 30, "domain": null }, { "name": "PARENTID", "type": "esriFieldTypeString", "alias": "Parent ID\n", "length": 100, "domain": null }, { "name": "STARTUPDATE", "type": "esriFieldTypeDate", "alias": "Startup Date\n", "length": 8, "domain": null }, { "name": "WARRANTYDATE", "type": "esriFieldTypeDate", "alias": "Warranty Date\n\n", "length": 8, "domain": null }, { "name": "CONDITIONSCORE", "type": "esriFieldTypeSmallInteger", "alias": "Condition Score\n\n", "domain": null }, { "name": "CONDITIONDATE", "type": "esriFieldTypeDate", "alias": "Condition Date\n\n", "length": 8, "domain": null }, { "name": "ADDRESS", "type": "esriFieldTypeString", "alias": "Address\n\n", "length": 255, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "Location\n\n", "length": 255, "domain": null }, { "name": "SITE", "type": "esriFieldTypeString", "alias": "Site", "length": 30, "domain": null }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "Manufacturer\n\n", "length": 30, "domain": null }, { "name": "MANPHONE", "type": "esriFieldTypeString", "alias": "Manufacturer Phone #\n", "length": 16, "domain": null }, { "name": "MANWEBSITE", "type": "esriFieldTypeString", "alias": "Manufacturer Website\n\n", "length": 30, "domain": null }, { "name": "MODEL", "type": "esriFieldTypeString", "alias": "Model\n\n", "length": 30, "domain": null }, { "name": "SERIALNO", "type": "esriFieldTypeString", "alias": "Serial Number\n\n", "length": 30, "domain": null }, { "name": "VENDOR", "type": "esriFieldTypeString", "alias": "Vendor\n\n", "length": 30, "domain": null }, { "name": "SPECLINK", "type": "esriFieldTypeString", "alias": "Spec Link\n\n", "length": 64, "domain": null }, { "name": "OMLINK", "type": "esriFieldTypeString", "alias": "O&M Link\n\n", "length": 64, "domain": null }, { "name": "SYSTEM", "type": "esriFieldTypeString", "alias": "System Designator\n\n", "length": 40, "domain": null }, { "name": "LOF", "type": "esriFieldTypeSmallInteger", "alias": "LoF Score\n\n", "domain": null }, { "name": "COF", "type": "esriFieldTypeSmallInteger", "alias": "CoF Score\n\n", "domain": null }, { "name": "RISK", "type": "esriFieldTypeSmallInteger", "alias": "Risk Score\n", "domain": null }, { "name": "CRITICALITY", "type": "esriFieldTypeString", "alias": "Criticality\n", "length": 16, "domain": null }, { "name": "REPLACEVALUE", "type": "esriFieldTypeDouble", "alias": "Replacement Value\n\n", "domain": null }, { "name": "VALUEDATE", "type": "esriFieldTypeDate", "alias": "Valuation Date\n\n", "length": 8, "domain": null }, { "name": "NOTES", "type": "esriFieldTypeString", "alias": "Notes", "length": 255, "domain": null }, { "name": "CREATOR", "type": "esriFieldTypeString", "alias": "Creator\n", "length": 30, "domain": null }, { "name": "CREATEDATE", "type": "esriFieldTypeDate", "alias": "Created\n", "length": 8, "domain": null }, { "name": "EDITOR", "type": "esriFieldTypeString", "alias": "Editor\n", "length": 30, "domain": null }, { "name": "EDITDATE", "type": "esriFieldTypeDate", "alias": "Edited", "length": 8, "domain": null }, { "name": "BLDGTYPE", "type": "esriFieldTypeString", "alias": "Type", "length": 20, "domain": null }, { "name": "SERVICELIFE", "type": "esriFieldTypeDouble", "alias": "SERVICELIFE", "domain": null } ], "indexes": [ { "name": "R9496_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_18848_PARENT", "fields": "PARENTID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GDB_18848_ASSETI", "fields": "ASSETID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 1, "name": "Compressor", "relatedTableId": 4, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 0, "name": "SDEP2.SANGIS.WWFSITE", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "a830fede087c4510909b9c91fd7d88ef" }