{
 "currentVersion": 10.91,
 "cimVersion": "2.9.0",
 "id": 50,
 "name": "ProdGDB_CW.DBO.sanLSPump",
 "type": "Table",
 "description": "",
 "copyrightText": "",
 "editFieldsInfo": {
  "creationDateField": "created_date",
  "creatorField": "created_user",
  "editDateField": "last_edited_date",
  "editorField": "last_edited_user",
  "dateFieldsTimeReference": {
   "timeZone": "UTC",
   "respectsDaylightSaving": false
  }
 },
 "ownershipBasedAccessControlForFeatures": null,
 "syncCanReturnChanges": true,
 "relationships": [
  {
   "id": 3,
   "name": "sanLiftStation",
   "relatedTableId": 17,
   "cardinality": "esriRelCardinalityOneToMany",
   "role": "esriRelRoleDestination",
   "keyField": "PARENTASSETNUMBER",
   "composite": false
  }
 ],
 "isDataVersioned": true,
 "isDataArchived": false,
 "isDataBranchVersioned": false,
 "isDataReplicaTracked": false,
 "isCoGoEnabled": false,
 "supportsRollbackOnFailureParameter": false,
 "archivingInfo": {
  "supportsQueryWithHistoricMoment": false,
  "startArchivingMoment": -1
 },
 "supportsStatistics": true,
 "supportsExceedsLimitStatistics": true,
 "supportsAdvancedQueries": true,
 "supportsValidateSQL": true,
 "supportsCoordinatesQuantization": false,
 "supportsCalculate": true,
 "supportsASyncCalculate": true,
 "advancedQueryCapabilities": {
  "supportsPagination": true,
  "supportsTrueCurve": true,
  "supportsQueryWithDistance": true,
  "supportsReturningQueryExtent": true,
  "supportsStatistics": true,
  "supportsPercentileStatistics": true,
  "supportsHavingClause": true,
  "supportsOrderBy": true,
  "supportsDistinct": true,
  "supportsCountDistinct": true,
  "supportsQueryWithResultType": true,
  "supportsReturningGeometryCentroid": false,
  "supportsSqlExpression": true,
  "supportsLod": false,
  "supportsQueryWithLodSR": false,
  "supportsQueryAnalytic": true
 },
 "advancedQueryAnalyticCapabilities": {
  "supportsLinearRegression": true,
  "supportsAsync": false,
  "supportsPercentileAnalytic": true
 },
 "advancedEditingCapabilities": {
  "supportedSqlFormatsInCalculate": [
   "standard"
  ],
  "supportsAsyncApplyEdits": true
 },
 "hasMetadata": true,
 "hasAttachments": false,
 "supportsApplyEditsWithGlobalIds": false,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "objectIdField": "OBJECTID",
 "globalIdField": "GlobalID",
 "displayField": "ASSETNUMBER",
 "typeIdField": "",
 "subtypeField": "",
 "fields": [
  {
   "name": "OBJECTID",
   "type": "esriFieldTypeOID",
   "alias": "OBJECTID",
   "domain": null,
   "editable": false,
   "nullable": false,
   "defaultValue": null,
   "modelName": "System-maintained ObjectID"
  },
  {
   "name": "ASSETNUMBER",
   "type": "esriFieldTypeString",
   "alias": "ASSETNUMBER",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 20,
   "defaultValue": null,
   "modelName": "ASSETNUMBER"
  },
  {
   "name": "PARENTASSETNUMBER",
   "type": "esriFieldTypeString",
   "alias": "PARENTASSETNUMBER",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 20,
   "defaultValue": null,
   "modelName": "PARENTASSETNUMBER"
  },
  {
   "name": "STATION",
   "type": "esriFieldTypeString",
   "alias": "STATION",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 10,
   "defaultValue": null,
   "modelName": "STATION"
  },
  {
   "name": "LOCATIONDESCRIPTION",
   "type": "esriFieldTypeString",
   "alias": "LOCATIONDESSCRIPTION",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "LOCATIONDESCRIPTION"
  },
  {
   "name": "LIFECYCLESTATUS",
   "type": "esriFieldTypeString",
   "alias": "LIFECYCLESTATUS",
   "domain": {
    "type": "codedValue",
    "name": "comDomainLifecycleStatus",
    "description": "",
    "codedValues": [
     {
      "name": "ACTIVE",
      "code": "ACT"
     },
     {
      "name": "ABANDONED",
      "code": "ABN"
     },
     {
      "name": "REMOVED",
      "code": "REM"
     },
     {
      "name": "EXISTING",
      "code": "EXT"
     },
     {
      "name": "ANNEXED",
      "code": "ANX"
     },
     {
      "name": "CORRECTED",
      "code": "COR"
     },
     {
      "name": "PROPOSED",
      "code": "PRO"
     },
     {
      "name": "RETIRED",
      "code": "RET"
     },
     {
      "name": "REPLACED",
      "code": "REP"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   },
   "editable": true,
   "nullable": true,
   "length": 10,
   "defaultValue": null,
   "modelName": "LIFECYCLESTATUS"
  },
  {
   "name": "LIFECYCLEDATE",
   "type": "esriFieldTypeDate",
   "alias": "LIFECYCLEDATE",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 8,
   "defaultValue": null,
   "modelName": "LIFECYCLEDATE"
  },
  {
   "name": "INSTALLDATE",
   "type": "esriFieldTypeDate",
   "alias": "INSTALLDATE",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 8,
   "defaultValue": null,
   "modelName": "INSTALLDATE"
  },
  {
   "name": "GlobalID",
   "type": "esriFieldTypeGlobalID",
   "alias": "GlobalID",
   "domain": null,
   "editable": false,
   "nullable": false,
   "length": 38,
   "defaultValue": null,
   "modelName": "GlobalID"
  },
  {
   "name": "PUMPTYPE",
   "type": "esriFieldTypeString",
   "alias": "PUMPTYPE",
   "domain": {
    "type": "codedValue",
    "name": "sanDomainPumpType",
    "description": "",
    "codedValues": [
     {
      "name": "HOSE / PERISTALTIC",
      "code": "HP"
     },
     {
      "name": "CLOSE COUPLED CENTRIFUGAL",
      "code": "CCC"
     },
     {
      "name": "PROGRESSIVE CAVITY DIAPHRAGM",
      "code": "PCD"
     },
     {
      "name": "PROGRESSIVE CAVITY PISTON",
      "code": "PCP"
     },
     {
      "name": "SELF PRIMING CENTRIFUGAL",
      "code": "SPC"
     },
     {
      "name": "SPLIT CASE",
      "code": "SC"
     },
     {
      "name": "SUBMERSIBLE",
      "code": "SUB"
     },
     {
      "name": "VACUUM ASSISTED CENTRIFUGAL",
      "code": "VAC"
     },
     {
      "name": "VERTICAL TURBINE",
      "code": "VT"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   },
   "editable": true,
   "nullable": true,
   "length": 25,
   "defaultValue": null,
   "modelName": "PUMPTYPE"
  },
  {
   "name": "INLETDIAMETER",
   "type": "esriFieldTypeDouble",
   "alias": "INLETDIAMETER",
   "domain": {
    "type": "codedValue",
    "name": "comDomainPMainDiameter",
    "description": "",
    "codedValues": [
     {
      "name": "Unknown",
      "code": 0
     },
     {
      "name": "1 inch",
      "code": 1
     },
     {
      "name": "2 inch",
      "code": 2
     },
     {
      "name": "3 inch",
      "code": 3
     },
     {
      "name": "4 inch",
      "code": 4
     },
     {
      "name": "6 inch",
      "code": 6
     },
     {
      "name": "8 inch",
      "code": 8
     },
     {
      "name": "10 inch",
      "code": 10
     },
     {
      "name": "12 inch",
      "code": 12
     },
     {
      "name": "14 inch",
      "code": 14
     },
     {
      "name": "16 inch",
      "code": 16
     },
     {
      "name": "18 inch",
      "code": 18
     },
     {
      "name": "20 inch",
      "code": 20
     },
     {
      "name": "24 inch",
      "code": 24
     },
     {
      "name": "30 inch",
      "code": 30
     },
     {
      "name": "1/2 inch",
      "code": 0.5
     },
     {
      "name": "3/4 inch",
      "code": 0.75
     },
     {
      "name": "1 1/2 inch",
      "code": 1.5
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "INLETDIAMETER"
  },
  {
   "name": "DISCHARGEDIAMETER",
   "type": "esriFieldTypeDouble",
   "alias": "DISCHARGEDIAMETER",
   "domain": {
    "type": "codedValue",
    "name": "comDomainPMainDiameter",
    "description": "",
    "codedValues": [
     {
      "name": "Unknown",
      "code": 0
     },
     {
      "name": "1 inch",
      "code": 1
     },
     {
      "name": "2 inch",
      "code": 2
     },
     {
      "name": "3 inch",
      "code": 3
     },
     {
      "name": "4 inch",
      "code": 4
     },
     {
      "name": "6 inch",
      "code": 6
     },
     {
      "name": "8 inch",
      "code": 8
     },
     {
      "name": "10 inch",
      "code": 10
     },
     {
      "name": "12 inch",
      "code": 12
     },
     {
      "name": "14 inch",
      "code": 14
     },
     {
      "name": "16 inch",
      "code": 16
     },
     {
      "name": "18 inch",
      "code": 18
     },
     {
      "name": "20 inch",
      "code": 20
     },
     {
      "name": "24 inch",
      "code": 24
     },
     {
      "name": "30 inch",
      "code": 30
     },
     {
      "name": "1/2 inch",
      "code": 0.5
     },
     {
      "name": "3/4 inch",
      "code": 0.75
     },
     {
      "name": "1 1/2 inch",
      "code": 1.5
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "DISCHARGEDIAMETER"
  },
  {
   "name": "RATEDFLOW",
   "type": "esriFieldTypeString",
   "alias": "RATEDFLOW",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 20,
   "defaultValue": null,
   "modelName": "RATEDFLOW"
  },
  {
   "name": "RATEDPRESSURE",
   "type": "esriFieldTypeString",
   "alias": "RATEDPRESSURE",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 20,
   "defaultValue": null,
   "modelName": "RATEDPRESSURE"
  },
  {
   "name": "PMAXQ",
   "type": "esriFieldTypeString",
   "alias": "PMAXQ",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 20,
   "defaultValue": null,
   "modelName": "PMAXQ"
  },
  {
   "name": "DESIGNEFLOW",
   "type": "esriFieldTypeString",
   "alias": "DESIGNFLOW",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 25,
   "defaultValue": null,
   "modelName": "DESIGNEFLOW"
  },
  {
   "name": "DESIGNHEAD",
   "type": "esriFieldTypeString",
   "alias": "DESIGNHEAD",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 25,
   "defaultValue": null,
   "modelName": "DESIGNHEAD"
  },
  {
   "name": "PUMPID",
   "type": "esriFieldTypeString",
   "alias": "PUMPID",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 10,
   "defaultValue": null,
   "modelName": "PUMPID"
  },
  {
   "name": "MANUFACTURER",
   "type": "esriFieldTypeString",
   "alias": "MANUFACTURER",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 20,
   "defaultValue": null,
   "modelName": "MANUFACTURER"
  },
  {
   "name": "SERIALNUMBER",
   "type": "esriFieldTypeString",
   "alias": "SERIALNUMBER",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 20,
   "defaultValue": null,
   "modelName": "SERIALNUMBER"
  },
  {
   "name": "MOTORMANUFACTURER",
   "type": "esriFieldTypeString",
   "alias": "MOTORMANUFACTURER",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 20,
   "defaultValue": null,
   "modelName": "MOTORMANUFACTURER"
  },
  {
   "name": "MOTORHORSEPOWER",
   "type": "esriFieldTypeDouble",
   "alias": "MOTORHORSEPOWER",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "MOTORHORSEPOWER"
  },
  {
   "name": "MOTORPHASE",
   "type": "esriFieldTypeSmallInteger",
   "alias": "MOTORPHASE",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "MOTORPHASE"
  },
  {
   "name": "MOTORRPM",
   "type": "esriFieldTypeInteger",
   "alias": "MOTORRPM",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "MOTORRPM"
  },
  {
   "name": "IMPELLER",
   "type": "esriFieldTypeDouble",
   "alias": "IMPELLER",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "IMPELLER"
  },
  {
   "name": "STARTERMANUFACTURER",
   "type": "esriFieldTypeString",
   "alias": "STARTERMANUFACTURER",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 20,
   "defaultValue": null,
   "modelName": "STARTERMANUFACTURER"
  },
  {
   "name": "STARTERMODEL",
   "type": "esriFieldTypeString",
   "alias": "STARTERMODEL",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 20,
   "defaultValue": null,
   "modelName": "STARTERMODEL"
  },
  {
   "name": "HEATERMANUFACTURER",
   "type": "esriFieldTypeString",
   "alias": "HEATERMANUFACTURER",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 20,
   "defaultValue": null,
   "modelName": "HEATERMANUFACTURER"
  },
  {
   "name": "HEATERMODEL",
   "type": "esriFieldTypeString",
   "alias": "HEATERMODEL",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 20,
   "defaultValue": null,
   "modelName": "HEATERMODEL"
  },
  {
   "name": "ALTERNATORMANUFACTURER",
   "type": "esriFieldTypeString",
   "alias": "ALTERNATORMANUFACTURER",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 20,
   "defaultValue": null,
   "modelName": "ALTERNATORMANUFACTURER"
  },
  {
   "name": "ALTERNATORMODEL",
   "type": "esriFieldTypeString",
   "alias": "ALTERNATORMODEL",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 20,
   "defaultValue": null,
   "modelName": "ALTERNATORMODEL"
  },
  {
   "name": "BREAKERAMPS",
   "type": "esriFieldTypeInteger",
   "alias": "BREAKERAMPS",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "BREAKERAMPS"
  },
  {
   "name": "MODELNUMBER",
   "type": "esriFieldTypeString",
   "alias": "MODELNUMBER",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "MODELNUMBER"
  },
  {
   "name": "MOTORAMPERAGE",
   "type": "esriFieldTypeDouble",
   "alias": "MOTORAMPERAGE",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "MOTORAMPERAGE"
  },
  {
   "name": "MOTORVOLTAGE",
   "type": "esriFieldTypeString",
   "alias": "MOTORVOLTAGE",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 20,
   "defaultValue": null,
   "modelName": "MOTORVOLTAGE"
  },
  {
   "name": "created_user",
   "type": "esriFieldTypeString",
   "alias": "created_user",
   "domain": null,
   "editable": false,
   "nullable": true,
   "length": 255,
   "defaultValue": null,
   "modelName": "created_user"
  },
  {
   "name": "created_date",
   "type": "esriFieldTypeDate",
   "alias": "created_date",
   "domain": null,
   "editable": false,
   "nullable": true,
   "length": 8,
   "defaultValue": null,
   "modelName": "created_date"
  },
  {
   "name": "last_edited_user",
   "type": "esriFieldTypeString",
   "alias": "last_edited_user",
   "domain": null,
   "editable": false,
   "nullable": true,
   "length": 255,
   "defaultValue": null,
   "modelName": "last_edited_user"
  },
  {
   "name": "last_edited_date",
   "type": "esriFieldTypeDate",
   "alias": "last_edited_date",
   "domain": null,
   "editable": false,
   "nullable": true,
   "length": 8,
   "defaultValue": null,
   "modelName": "last_edited_date"
  }
 ],
 "indexes": [
  {
   "name": "R10_SDE_ROWID_UK",
   "fields": "OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  },
  {
   "name": "UUID_10",
   "fields": "GlobalID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "G90PARENTASSETNU",
   "fields": "PARENTASSETNUMBER",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "UUID_OID_10",
   "fields": "GlobalID,OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  }
 ],
 "datesInUnknownTimezone": false,
 "dateFieldsTimeReference": {
  "timeZone": "Eastern Standard Time",
  "respectsDaylightSaving": false
 },
 "preferredTimeReference": null,
 "types": [],
 "templates": [
  {
   "name": "ProdGDB_CW.DBO.sanLSPump",
   "description": "",
   "prototype": {
    "attributes": {
     "MOTORAMPERAGE": null,
     "MOTORVOLTAGE": null,
     "ASSETNUMBER": null,
     "PARENTASSETNUMBER": null,
     "STATION": null,
     "LOCATIONDESCRIPTION": null,
     "LIFECYCLESTATUS": null,
     "LIFECYCLEDATE": null,
     "INSTALLDATE": null,
     "MODELNUMBER": null,
     "PUMPTYPE": null,
     "INLETDIAMETER": null,
     "DISCHARGEDIAMETER": null,
     "RATEDFLOW": null,
     "RATEDPRESSURE": null,
     "PMAXQ": null,
     "DESIGNEFLOW": null,
     "DESIGNHEAD": null,
     "PUMPID": null,
     "MANUFACTURER": null,
     "SERIALNUMBER": null,
     "MOTORMANUFACTURER": null,
     "MOTORHORSEPOWER": null,
     "MOTORPHASE": null,
     "MOTORRPM": null,
     "IMPELLER": null,
     "STARTERMANUFACTURER": null,
     "STARTERMODEL": null,
     "HEATERMANUFACTURER": null,
     "HEATERMODEL": null,
     "ALTERNATORMANUFACTURER": null,
     "ALTERNATORMODEL": null,
     "BREAKERAMPS": null
    }
   },
   "drawingTool": "esriFeatureEditToolNone"
  }
 ],
 "maxRecordCount": 2000,
 "supportedQueryFormats": "JSON, geoJSON, PBF",
 "supportedExportFormats": "sqlite,filegdb",
 "capabilities": "Query,Create,Update,Delete,Uploads,Editing",
 "useStandardizedQueries": true,
 "standardMaxRecordCount": 32000,
 "tileMaxRecordCount": 2000,
 "maxRecordCountFactor": 1,
 "serviceItemId": "7f56dcfbf3614e96af716a86bfcb560d"
}