View In:   ArcGIS Online Map Viewer

Name: Tank

Display Field: SITE_NAME

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description:

Service Item Id: 6aa3f52844c748d88820036a76e0ab74

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Min Scale: 5000

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

XMin: 6296158.523044825
YMin: 1982929.1361598969
XMax: 6306121.105153754
YMax: 1999216.3972204775
Spatial Reference: 102646  (2230)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSFSSolid
Color: [255, 127, 127, 255]
Outline:
Style: esriSLSSolid
Color: [110, 110, 110, 255]
Width: 0
Label:
Description:
Transparency: 0
Labeling Info:

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

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• FACILITYID ( type: esriFieldTypeString, alias: Facility ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: FACILITYID )
• LEGACY_ID ( type: esriFieldTypeString, alias: Legacy ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LEGACY_ID )
• CITY_ASSET_ID ( type: esriFieldTypeString, alias: City Asset ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CITY_ASSET_ID )
• LOCATION ( type: esriFieldTypeString, alias: Location Description, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LOCATION )
• PROJECT_NUMBER ( type: esriFieldTypeString, alias: Project Number, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PROJECT_NUMBER )
• MANUFACTURER ( type: esriFieldTypeString, alias: Manufacturer, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MANUFACTURER )
• MODEL ( type: esriFieldTypeString, alias: Model, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MODEL )
• SERIAL_NUMBER ( type: esriFieldTypeString, alias: Serial Number, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SERIAL_NUMBER )
• PURCHASE_DATE ( type: esriFieldTypeDate, alias: Purchase Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: PURCHASE_DATE )
• INITIAL_COST ( type: esriFieldTypeInteger, alias: Initial Cost, editable: true, nullable: true, defaultValue: null, modelName: INITIAL_COST )
• INSTALLATION_DATE ( type: esriFieldTypeDate, alias: Installation Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALLATION_DATE )
• WARRANTYDATE ( type: esriFieldTypeDate, alias: Warranty Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: WARRANTYDATE )
• REPLACEMENT_COST ( type: esriFieldTypeInteger, alias: Replacement Cost, editable: true, nullable: true, defaultValue: null, modelName: REPLACEMENT_COST )
• REMAINING_VALUE ( type: esriFieldTypeInteger, alias: Remaining Value, editable: true, nullable: true, defaultValue: null, modelName: REMAINING_VALUE )
• OWNED_BY ( type: esriFieldTypeString, alias: Owned By, editable: true, nullable: true, length: 50, defaultValue: null, modelName: OWNED_BY , Coded Values: [MyCodedValue: MyCodeName] , [HARRF_OPS: HARRF Operations] , [HARRF_PST: HARRF Plant Systems Technician] , ...7 more... )
• MAINTAINED_BY ( type: esriFieldTypeString, alias: Maintained By, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MAINTAINED_BY , Coded Values: [MyCodedValue: MyCodeName] , [HARRF_OPS: HARRF Operations] , [HARRF_PST: HARRF Plant Systems Technician] , ...7 more... )
• LIFECYCLE_STATUS ( type: esriFieldTypeString, alias: Lifecycle Status, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LIFECYCLE_STATUS , Coded Values: [INSTALLED: Installed] , [UNINSTALLED: Uninstalled] , [ABANDONEDINPLACE: Abandoned-In-Place] , ...3 more... )
• CRITICAL ( type: esriFieldTypeString, alias: Critical?, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CRITICAL , Coded Values: [YES: Yes] , [NO: No] , [NA: Not Applicable] )
• CONDITION ( type: esriFieldTypeSmallInteger, alias: Condition, editable: true, nullable: true, defaultValue: null, modelName: CONDITION )
• CONDITIONDATE ( type: esriFieldTypeDate, alias: Condition Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CONDITIONDATE )
• YR_EXPECTED_END_PHYSICAL_LIFE ( type: esriFieldTypeSmallInteger, alias: Expected End of Physical Life, editable: true, nullable: true, defaultValue: null, modelName: YR_EXPECTED_END_PHYSICAL_LIFE )
• TYPICAL_YRS_FULLY_DEPRECIATE ( type: esriFieldTypeSmallInteger, alias: Typical Years to Fully Depreciate, editable: true, nullable: true, defaultValue: null, modelName: TYPICAL_YRS_FULLY_DEPRECIATE )
• DEPRECIATION_DETAILS ( type: esriFieldTypeString, alias: Depreciation Details, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DEPRECIATION_DETAILS )
• CONSEQUENCE_OF_FAILURE ( type: esriFieldTypeDouble, alias: Consequence of Failure (COF), editable: true, nullable: true, defaultValue: null, modelName: CONSEQUENCE_OF_FAILURE )
• PROBABILITY_OF_FAILURE ( type: esriFieldTypeDouble, alias: Probability of Failure (POF), editable: true, nullable: true, defaultValue: null, modelName: PROBABILITY_OF_FAILURE )
• BUSINESS_RISK_EXPOSURE ( type: esriFieldTypeDouble, alias: Business Risk Exposure (BRE), editable: true, nullable: true, defaultValue: null, modelName: BUSINESS_RISK_EXPOSURE )
• DATE_CALCULATED ( type: esriFieldTypeDate, alias: COF, POF, and BRE Calculation, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATE_CALCULATED )
• MAINTENANCE_DATE ( type: esriFieldTypeDate, alias: Maintenance Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: MAINTENANCE_DATE )
• MAINTENANCE_COMMENTS ( type: esriFieldTypeString, alias: Maintenance Comments, editable: true, nullable: true, length: 255, defaultValue: null, modelName: MAINTENANCE_COMMENTS )
• IMAGE_URL ( type: esriFieldTypeString, alias: Image URL, editable: true, nullable: true, length: 255, defaultValue: null, modelName: IMAGE_URL )
• COMMENTS ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 255, defaultValue: null, modelName: COMMENTS )
• SITE_NAME ( type: esriFieldTypeString, alias: Site Name, editable: true, nullable: true, length: 255, defaultValue: null, modelName: SITE_NAME )
• PROCESS_NAME ( type: esriFieldTypeString, alias: System Name, editable: true, nullable: true, length: 100, defaultValue: null, modelName: PROCESS_NAME , Coded Values: [PRETREAT: Preliminary Treatment] , [PRIMTREAT: Primary Treatment] , [SECTREAT: Secondary Treatment] , ...13 more... )
• SUBPROCESS_NAME ( type: esriFieldTypeString, alias: Subsystem Name, editable: true, nullable: true, length: 100, defaultValue: null, modelName: SUBPROCESS_NAME , Coded Values: [SCREENING: Screening] , [PUMPING: Pumping] , [GRITREMOVAL: Grit Removal] , ...48 more... )
• TANK_CONTENTS ( type: esriFieldTypeString, alias: Tank Contents, editable: true, nullable: true, length: 50, defaultValue: null, modelName: TANK_CONTENTS , Coded Values: [ALUMINUMSULFATE: Aluminum Sulfate] , [AMMONIUMSULPHATE: Ammonium Sulphate] , [SODIUMHYPOCHLORITE: Sodium Hypochlorite] , ...41 more... )
• TANK_FUNCTION ( type: esriFieldTypeString, alias: Tank Function, editable: true, nullable: true, length: 50, defaultValue: null, modelName: TANK_FUNCTION , Coded Values: [HOLDING: Holding] , [REJECT: Reject] , [EQUALIZATION: Equalization] , ...7 more... )
• TANK_SHAPE ( type: esriFieldTypeString, alias: Tank Shape, editable: true, nullable: true, length: 50, defaultValue: null, modelName: TANK_SHAPE )
• TANK_DIMENSION ( type: esriFieldTypeString, alias: Tank Dimensions (Ft), editable: true, nullable: true, length: 50, defaultValue: null, modelName: TANK_DIMENSION )
• TANK_DIAMETER ( type: esriFieldTypeDouble, alias: Tank Diameter (Ft), editable: true, nullable: true, defaultValue: null, modelName: TANK_DIAMETER )
• TANK_DEPTH ( type: esriFieldTypeDouble, alias: Tank Depth (Ft), editable: true, nullable: true, defaultValue: null, modelName: TANK_DEPTH )
• TANK_ORIENTATION ( type: esriFieldTypeString, alias: Tank Orientation, editable: true, nullable: true, length: 50, defaultValue: null, modelName: TANK_ORIENTATION , Coded Values: [HORIZONTAL: Horizontal] , [VERTICAL: Vertical] )
• GENERATOR_BASE ( type: esriFieldTypeString, alias: Generator Base?, editable: true, nullable: true, length: 3, defaultValue: null, modelName: GENERATOR_BASE , Coded Values: [YES: Yes] , [NO: No] , [NA: Not Applicable] )
• CAPACITY ( type: esriFieldTypeDouble, alias: Tank Capacity, editable: true, nullable: true, defaultValue: null, modelName: CAPACITY )
• TANK_CAPACITY_UOM ( type: esriFieldTypeString, alias: Capacity Units of Measure, editable: true, nullable: true, length: 50, defaultValue: null, modelName: TANK_CAPACITY_UOM , Coded Values: [POUNDS: Pounds] , [TONS: Tons] , [GALLONS: Gallons] , ...1 more... )
• TANK_MATERIAL_TYPE ( type: esriFieldTypeString, alias: Tank Material Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: TANK_MATERIAL_TYPE , Coded Values: [CONCRETE: Concrete] , [STEEL: Steel] , [STAINLESSSTEEL: Stainless Steel] , ...6 more... )
• CONFINED_SPACE ( type: esriFieldTypeString, alias: Confined Space Entry?, editable: true, nullable: true, length: 3, defaultValue: null, modelName: CONFINED_SPACE , Coded Values: [YES: Yes] , [NO: No] , [NA: Not Applicable] )
• TANK_BOTTOM_ELEVATION ( type: esriFieldTypeDouble, alias: Tank Bottom Elevation (Ft), editable: true, nullable: true, defaultValue: null, modelName: TANK_BOTTOM_ELEVATION )
• BELOW_GROUND ( type: esriFieldTypeString, alias: Below Ground?, editable: true, nullable: true, length: 3, defaultValue: null, modelName: BELOW_GROUND , Coded Values: [YES: Yes] , [NO: No] , [NA: Not Applicable] )
• MOBILE ( type: esriFieldTypeString, alias: Mobile?, editable: true, nullable: true, length: 3, defaultValue: null, modelName: MOBILE , Coded Values: [YES: Yes] , [NO: No] , [NA: Not Applicable] )
• LINING_MATERIAL ( type: esriFieldTypeString, alias: Lining Material, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LINING_MATERIAL , Coded Values: [EPOXY: Epoxy] , [PVC: PVC] , [FABRIC: Fabric] , ...2 more... )
• REGULATORY_ID ( type: esriFieldTypeString, alias: Regulatory ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: REGULATORY_ID )
• SPCC ( type: esriFieldTypeString, alias: SPCC?, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SPCC , Coded Values: [YES: Yes] , [NO: No] , [NA: Not Applicable] )
• REGULATORY_BODY ( type: esriFieldTypeString, alias: Regulatory Body, editable: true, nullable: true, length: 50, defaultValue: null, modelName: REGULATORY_BODY )
• TANK_EXTERIOR_COLOR ( type: esriFieldTypeString, alias: Tank Exterior Color, editable: true, nullable: true, length: 50, defaultValue: null, modelName: TANK_EXTERIOR_COLOR )
• TANK_EXTERIOR_COATING ( type: esriFieldTypeString, alias: Tank Exterior Coating, editable: true, nullable: true, length: 50, defaultValue: null, modelName: TANK_EXTERIOR_COATING , Coded Values: [PAINT: Paint] , [INSULATION: Insulation] , [EPOXY: Epoxy] , ...1 more... )
• TANK_CONTAINMENT_TYPE ( type: esriFieldTypeString, alias: Tank Containment Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: TANK_CONTAINMENT_TYPE , Coded Values: [DOUBLEWALL: Double Wall] , [EXTERIOR: Exterior] , [NONE: None] )
• TANK_CONTAINMENT_STRUCTURE ( type: esriFieldTypeString, alias: Tank Containment Structure, editable: true, nullable: true, length: 50, defaultValue: null, modelName: TANK_CONTAINMENT_STRUCTURE , Coded Values: [DIKE: Dike] , [BERM: Berm] , [RETAINWALL: Retaining Wall] , ...13 more... )
• SUBPROCESS_ID ( type: esriFieldTypeString, alias: Subprocess ID (Relate), editable: true, nullable: true, length: 50, defaultValue: null, modelName: SUBPROCESS_ID )
• UNIT_ID ( type: esriFieldTypeString, alias: Room ID (Relate), editable: true, nullable: true, length: 50, defaultValue: null, modelName: UNIT_ID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• LASTEDITOR ( type: esriFieldTypeString, alias: LASTEDITOR, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LASTEDITOR )
• LASTUPDATE ( type: esriFieldTypeDate, alias: LASTUPDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LASTUPDATE )
• ASSETSTATUS ( type: esriFieldTypeString, alias: ASSETSTATUS, editable: true, nullable: true, length: 1, defaultValue: C, modelName: ASSETSTATUS , Coded Values: [C: Current] , [R: Retired] , [A: Abandoned] , ...5 more... )
• SCADA_INITIATED ( type: esriFieldTypeDouble, alias: SCADA_INITIATED, editable: true, nullable: true, defaultValue: 0, modelName: SCADA_INITIATED )

Templates:

• Name: Tank
  Description:
  Prototype:
  LASTUPDATE: null
  ASSETSTATUS: C
  LASTEDITOR: null
  FACILITYID: null
  LEGACY_ID: null
  CITY_ASSET_ID: null
  LOCATION: null
  PROJECT_NUMBER: null
  MANUFACTURER: null
  MODEL: null
  SERIAL_NUMBER: null
  PURCHASE_DATE: null
  INITIAL_COST: null
  INSTALLATION_DATE: null
  WARRANTYDATE: null
  REPLACEMENT_COST: null
  REMAINING_VALUE: null
  OWNED_BY: null
  MAINTAINED_BY: null
  LIFECYCLE_STATUS: null
  CRITICAL: null
  CONDITION: null
  CONDITIONDATE: null
  YR_EXPECTED_END_PHYSICAL_LIFE: null
  TYPICAL_YRS_FULLY_DEPRECIATE: null
  DEPRECIATION_DETAILS: null
  CONSEQUENCE_OF_FAILURE: null
  PROBABILITY_OF_FAILURE: null
  BUSINESS_RISK_EXPOSURE: null
  DATE_CALCULATED: null
  MAINTENANCE_DATE: null
  MAINTENANCE_COMMENTS: null
  IMAGE_URL: null
  COMMENTS: null
  SITE_NAME: null
  PROCESS_NAME: null
  SUBPROCESS_NAME: null
  TANK_CONTENTS: null
  TANK_FUNCTION: null
  TANK_SHAPE: null
  TANK_DIMENSION: null
  TANK_DIAMETER: null
  TANK_DEPTH: null
  TANK_ORIENTATION: null
  GENERATOR_BASE: null
  CAPACITY: null
  TANK_CAPACITY_UOM: null
  TANK_MATERIAL_TYPE: null
  CONFINED_SPACE: null
  TANK_BOTTOM_ELEVATION: null
  BELOW_GROUND: null
  MOBILE: null
  LINING_MATERIAL: null
  REGULATORY_ID: null
  SPCC: null
  REGULATORY_BODY: null
  TANK_EXTERIOR_COLOR: null
  TANK_EXTERIOR_COATING: null
  TANK_CONTAINMENT_TYPE: null
  TANK_CONTAINMENT_STRUCTURE: null
  SUBPROCESS_ID: null
  UNIT_ID: null
  SCADA_INITIATED: 0
  
  Drawing Tool: esriFeatureEditToolPolygon

Relationships:

• tp_Units (75) -- Related To: Room (128)
• tp_Subprocess (79) -- Related To: tp_Subprocess (229)

Capabilities: Query

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Query Related Records   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata