{
 "currentVersion": 10.22,
 "id": 55,
 "name": "fpfgis.SDE.BankCondition",
 "type": "Table",
 "description": null,
 "hasAttachments": true,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "displayField": "SITE_NAME",
 "typeIdField": null,
 "fields": [
  {
   "name": "OBJECTID",
   "type": "esriFieldTypeOID",
   "alias": "OBJECTID",
   "domain": null
  },
  {
   "name": "SITE_NAME",
   "type": "esriFieldTypeString",
   "alias": "SITE_NAME",
   "length": 50,
   "domain": null
  },
  {
   "name": "BankSide",
   "type": "esriFieldTypeString",
   "alias": "Bank Side",
   "length": 50,
   "domain": null
  },
  {
   "name": "BankType1",
   "type": "esriFieldTypeString",
   "alias": "Bank Type 1",
   "length": 50,
   "domain": null
  },
  {
   "name": "BankCondition1",
   "type": "esriFieldTypeString",
   "alias": "Bank Condition 1",
   "length": 50,
   "domain": null
  },
  {
   "name": "BankLength1",
   "type": "esriFieldTypeDouble",
   "alias": "Bank Length 1",
   "domain": null
  },
  {
   "name": "BankType2",
   "type": "esriFieldTypeString",
   "alias": "Bank Type 2",
   "length": 50,
   "domain": null
  },
  {
   "name": "BankCondition2",
   "type": "esriFieldTypeString",
   "alias": "Bank Condition 2",
   "length": 50,
   "domain": null
  },
  {
   "name": "BankLength2",
   "type": "esriFieldTypeDouble",
   "alias": "Bank Length 2",
   "domain": null
  },
  {
   "name": "BankType3",
   "type": "esriFieldTypeString",
   "alias": "Bank Type 3",
   "length": 50,
   "domain": null
  },
  {
   "name": "BankCondition3",
   "type": "esriFieldTypeString",
   "alias": "Bank Condition 3",
   "length": 50,
   "domain": null
  },
  {
   "name": "BankLength3",
   "type": "esriFieldTypeDouble",
   "alias": "Bank Length 3",
   "domain": null
  },
  {
   "name": "TotalLength",
   "type": "esriFieldTypeDouble",
   "alias": "Total Length",
   "domain": null
  },
  {
   "name": "BankScore",
   "type": "esriFieldTypeDouble",
   "alias": "Bank Score - Condition (5 excellent, 1 failed, 5-1) x Length",
   "domain": null
  },
  {
   "name": "BankRating",
   "type": "esriFieldTypeDouble",
   "alias": "Bank Rating (SUM Bank score/Total Length)",
   "domain": null
  }
 ],
 "relationships": [
  {
   "id": 203,
   "name": "Waterway_new",
   "relatedTableId": 21,
   "role": "esriRelRoleDestination",
   "keyField": "SITE_NAME",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": true
  }
 ],
 "capabilities": "Map,Query,Data",
 "maxRecordCount": 1000,
 "supportsStatistics": true,
 "supportsAdvancedQueries": true,
 "supportedQueryFormats": "JSON, AMF",
 "useStandardizedQueries": true
}