{ "currentVersion": 10.91, "id": 44, "name": "LMS", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "STPCD", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "IGISLMSID", "type": "esriFieldTypeOID", "alias": "IGISLMSID", "domain": null }, { "name": "STPCD", "type": "esriFieldTypeString", "alias": "STPCD", "length": 6, "domain": null }, { "name": "LICENSESTD", "type": "esriFieldTypeString", "alias": "LICENSESTD", "length": 1, "domain": null }, { "name": "STPCATEGORY", "type": "esriFieldTypeInteger", "alias": "STPCATEGORY", "domain": null }, { "name": "STPTYPCD", "type": "esriFieldTypeString", "alias": "STPTYPCD", "length": 6, "domain": null }, { "name": "PLANTTYPE", "type": "esriFieldTypeString", "alias": "PLANTTYPE", "length": 1, "domain": null }, { "name": "AVGBODT", "type": "esriFieldTypeDouble", "alias": "AVGBODT", "domain": null }, { "name": "AVGPHS", "type": "esriFieldTypeDouble", "alias": "AVGPHS", "domain": null }, { "name": "AVGSOG", "type": "esriFieldTypeDouble", "alias": "AVGSOG", "domain": null }, { "name": "AVGSS", "type": "esriFieldTypeDouble", "alias": "AVGSS", "domain": null }, { "name": "AVGCODT", "type": "esriFieldTypeDouble", "alias": "AVGCODT", "domain": null }, { "name": "COMPLIANCE", "type": "esriFieldTypeString", "alias": "COMPLIANCE", "length": 10, "domain": null }, { "name": "NEWCOMPLIANCE", "type": "esriFieldTypeString", "alias": "NEWCOMPLIANCE", "length": 10, "domain": null }, { "name": "REPORTPERIOD", "type": "esriFieldTypeString", "alias": "REPORTPERIOD", "length": 10, "domain": null }, { "name": "AVGNAMM", "type": "esriFieldTypeDouble", "alias": "AVGNAMM", "domain": null }, { "name": "AVGNATE", "type": "esriFieldTypeDouble", "alias": "AVGNATE", "domain": null }, { "name": "AVGTEMP", "type": "esriFieldTypeDouble", "alias": "AVGTEMP", "domain": null }, { "name": "AVGCOMPLIANCE", "type": "esriFieldTypeString", "alias": "AVGCOMPLIANCE", "length": 1, "domain": null } ], "indexes": null, "subtypes": [], "relationships": [ { "id": 3, "name": "PUBLIC_STP_OM_STP_SPREADSHEET", "relatedTableId": 3, "role": "esriRelRoleDestination", "keyField": "STPCD", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 7, "name": "IGISPROD.SDE.PUBLIC_STP", "relatedTableId": 29, "role": "esriRelRoleDestination", "keyField": "IGISLMSID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 9, "name": "IGISPROD.SDE.PUBLIC_STP", "relatedTableId": 30, "role": "esriRelRoleDestination", "keyField": "STPCD", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": false, "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 }