Name: wastEquipment

Display Field: NAME

Type: Table

Geometry Type: N/A

Description:

Service Item Id: ac96d47704f94db0b89dff1b6483136e

Copyright Text:

Default Visibility: false

MaxRecordCount: 7000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: ObjectID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• FEATURE_DESCRIPTION ( type: esriFieldTypeString, alias: FEATURE_DESCRIPTION, editable: true, nullable: true, length: 255, defaultValue: null, modelName: FEATURE_DESCRIPTION )
• FEATURE_CLASS ( type: esriFieldTypeString, alias: FEATURE_CLASS, editable: true, nullable: true, length: 255, defaultValue: null, modelName: FEATURE_CLASS )
• NAME ( type: esriFieldTypeString, alias: NAME, editable: true, nullable: true, length: 255, defaultValue: null, modelName: NAME )
• MANUFACTURER ( type: esriFieldTypeString, alias: MANUFACTURER, editable: true, nullable: true, length: 255, defaultValue: null, modelName: MANUFACTURER )
• MODEL_NUMBER ( type: esriFieldTypeString, alias: MODEL_NUMBER, editable: true, nullable: true, length: 255, defaultValue: null, modelName: MODEL_NUMBER )
• SERIAL_NUMBER ( type: esriFieldTypeString, alias: SERIAL_NUMBER, editable: true, nullable: true, length: 255, defaultValue: null, modelName: SERIAL_NUMBER )
• UNIQUE_ID ( type: esriFieldTypeString, alias: UNIQUE_ID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: UNIQUE_ID )
• FACILITY_NAME ( type: esriFieldTypeString, alias: FACILITY_NAME, editable: true, nullable: true, length: 255, defaultValue: null, modelName: FACILITY_NAME )
• BUILDING_NAME ( type: esriFieldTypeString, alias: BUILDING_NAME, editable: true, nullable: true, length: 255, defaultValue: null, modelName: BUILDING_NAME )
• INSTALL_DATE ( type: esriFieldTypeDouble, alias: INSTALL_DATE, editable: true, nullable: true, defaultValue: null, modelName: INSTALL_DATE )
• ORIGINAL_COST ( type: esriFieldTypeDouble, alias: ORIGINAL_COST, editable: true, nullable: true, defaultValue: null, modelName: ORIGINAL_COST )
• CONDITION_RATING ( type: esriFieldTypeDouble, alias: CONDITION_RATING, editable: true, nullable: true, defaultValue: null, modelName: CONDITION_RATING )
• EFFECT_LIFE_ADJUST_FACTOR ( type: esriFieldTypeDouble, alias: EFFECT_LIFE_ADJUST_FACTOR, editable: true, nullable: true, defaultValue: null, modelName: EFFECT_LIFE_ADJUST_FACTOR )
• BACKUP_REDUCTION ( type: esriFieldTypeDouble, alias: BACKUP_REDUCTION, editable: true, nullable: true, defaultValue: null, modelName: BACKUP_REDUCTION )
• CONSEQUENCE_OF_FAILURE ( type: esriFieldTypeDouble, alias: CONSEQUENCE_OF_FAILURE, editable: true, nullable: true, defaultValue: null, modelName: CONSEQUENCE_OF_FAILURE )
• RENEWAL_STRATEGY ( type: esriFieldTypeDouble, alias: RENEWAL_STRATEGY, editable: true, nullable: true, defaultValue: null, modelName: RENEWAL_STRATEGY )
• COST_OF_RENEWAL_OPTION ( type: esriFieldTypeDouble, alias: COST_OF_RENEWAL_OPTION, editable: true, nullable: true, defaultValue: null, modelName: COST_OF_RENEWAL_OPTION )
• F_KEY ( type: esriFieldTypeString, alias: F_KEY, editable: true, nullable: true, length: 255, defaultValue: null, modelName: F_KEY )
• LIFECYCLE ( type: esriFieldTypeString, alias: Lifecycle, editable: true, nullable: true, length: 20, defaultValue: null, modelName: LIFECYCLE , Coded Values: [Active: Active] , [Proposed: Proposed] , [Abandoned: Abandoned] )
• LOCATION ( type: esriFieldTypeString, alias: Asset Location Description, editable: true, nullable: true, length: 75, defaultValue: null, modelName: LOCATION )
• ASSET_ID ( type: esriFieldTypeString, alias: Asset ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ASSET_ID )

Templates:

• Name: wastEquipment
  Description:
  Prototype:
  LOCATION: null
  ASSET_ID: null
  FEATURE_DESCRIPTION: null
  FEATURE_CLASS: null
  NAME: null
  MANUFACTURER: null
  MODEL_NUMBER: null
  SERIAL_NUMBER: null
  UNIQUE_ID: null
  FACILITY_NAME: null
  BUILDING_NAME: null
  INSTALL_DATE: null
  ORIGINAL_COST: null
  CONDITION_RATING: null
  EFFECT_LIFE_ADJUST_FACTOR: null
  BACKUP_REDUCTION: null
  CONSEQUENCE_OF_FAILURE: null
  RENEWAL_STRATEGY: null
  COST_OF_RENEWAL_OPTION: null
  F_KEY: null
  LIFECYCLE: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• waWaterStorage (5) -- Related To: Water Storage (10)
• waPumpStations (0) -- Related To: Pump Stations (9)

Capabilities: Query

Sync Can Return Changes: false

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Analytic   Query Related Records   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata