Name: Super Structure

Display Field: assetname

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 1b5871ab16ca44f4968b04e4fcc8d95c

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

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: false
Supports Returning Query Extent: false
Supports Query With Distance: false
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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• objectid ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: OBJECTID, alias: OBJECTID )
• assetid ( modelName: ASSETID_, nullable: true, editable: true, defaultValue: null, length: 100, alias: Asset ID , type: esriFieldTypeString )
• assetname ( modelName: ASSETNAME_, nullable: true, editable: true, defaultValue: null, length: 255, alias: Asset Name , type: esriFieldTypeString )
• assettype ( modelName: ASSETTYPE_, nullable: true, editable: true, defaultValue: null, length: 50, alias: Asset Type , type: esriFieldTypeString )
• assetowner ( modelName: ASSETOWNER_, nullable: true, editable: true, defaultValue: null, length: 50, alias: Asset Owner , type: esriFieldTypeString , Coded Values: [Airports: Airports] , [HHSA: HHSA] , [Parks: Parks] , ...3 more... )
• legacyid ( modelName: LEGACYID_, nullable: true, editable: true, defaultValue: null, length: 50, alias: Legacy ID , type: esriFieldTypeString )
• tagnumber ( modelName: TAGNUMBER_, nullable: true, editable: true, defaultValue: null, length: 50, alias: Tag Number , type: esriFieldTypeString )
• status ( modelName: STATUS_, nullable: true, editable: true, defaultValue: null, length: 30, alias: Status , type: esriFieldTypeString , Coded Values: [In Service: In Service] , [Out of Service: Out of Service] , [Spare: Spare] )
• parentid ( modelName: PARENTID_, nullable: true, editable: true, defaultValue: null, length: 100, alias: Parent ID , type: esriFieldTypeString )
• startupdate ( modelName: STARTUPDATE_, nullable: true, editable: true, defaultValue: null, length: 29, alias: Startup Date , type: esriFieldTypeDate )
• warrantydate ( modelName: WARRANTYDATE_, nullable: true, editable: true, defaultValue: null, length: 29, alias: Warranty Date , type: esriFieldTypeDate )
• conditionscore ( modelName: CONDITIONSCORE_, nullable: true, editable: true, defaultValue: null, alias: Condition Score , type: esriFieldTypeSmallInteger )
• conditiondate ( modelName: CONDITIONDATE_, nullable: true, editable: true, defaultValue: null, length: 29, alias: Condition Date , type: esriFieldTypeDate )
• address ( modelName: ADDRESS_, nullable: true, editable: true, defaultValue: null, length: 255, alias: Address , type: esriFieldTypeString )
• location ( modelName: LOCATION_, nullable: true, editable: true, defaultValue: null, length: 255, alias: Location , type: esriFieldTypeString )
• site ( modelName: SITE_, nullable: true, editable: true, defaultValue: null, length: 30, alias: Site, type: esriFieldTypeString , Coded Values: [JUWWTP0019: Heise Park WWTP] , [PVWWTP0007: Pine Valley WWTP] , [SVWWPS0010: Rancho San Diego PS] , ...39 more... )
• manufacturer ( modelName: MANUFACTURER_, nullable: true, editable: true, defaultValue: null, length: 30, alias: Manufacturer , type: esriFieldTypeString )
• manphone ( modelName: MANPHONE_, nullable: true, editable: true, defaultValue: null, length: 16, alias: Manufacturer Phone # , type: esriFieldTypeString )
• manwebsite ( modelName: MANWEBSITE_, nullable: true, editable: true, defaultValue: null, length: 30, alias: Manufacturer Website , type: esriFieldTypeString )
• model ( modelName: MODEL_, nullable: true, editable: true, defaultValue: null, length: 30, alias: Model , type: esriFieldTypeString )
• serialno ( modelName: SERIALNO_, nullable: true, editable: true, defaultValue: null, length: 30, alias: Serial Number , type: esriFieldTypeString )
• vendor ( modelName: VENDOR_, nullable: true, editable: true, defaultValue: null, length: 30, alias: Vendor , type: esriFieldTypeString )
• speclink ( modelName: SPECLINK_, nullable: true, editable: true, defaultValue: null, length: 64, alias: Spec Link , type: esriFieldTypeString )
• omlink ( modelName: OMLINK_, nullable: true, editable: true, defaultValue: null, length: 64, alias: O&M Link , type: esriFieldTypeString )
• system ( modelName: SYSTEM_, nullable: true, editable: true, defaultValue: null, length: 40, alias: System Designator , type: esriFieldTypeString , Coded Values: [Conveyance: Conveyance] , [Screening: Screening] , [Grit Removal: Grit Removal] , ...10 more... )
• lof ( modelName: LOF_, nullable: true, editable: true, defaultValue: null, alias: LoF Score , type: esriFieldTypeSmallInteger )
• cof ( modelName: COF_, nullable: true, editable: true, defaultValue: null, alias: CoF Score , type: esriFieldTypeSmallInteger )
• risk ( modelName: RISK_, nullable: true, editable: true, defaultValue: null, alias: Risk Score , type: esriFieldTypeSmallInteger )
• criticality ( modelName: CRITICALITY_, nullable: true, editable: true, defaultValue: null, length: 16, alias: Criticality , type: esriFieldTypeString , Coded Values: [High: High] , [Medium: Medium] , [Low: Low] )
• replacevalue ( modelName: REPLACEVALUE_, nullable: true, editable: true, defaultValue: null, alias: Replacement Value , type: esriFieldTypeDouble )
• valuedate ( modelName: VALUEDATE_, nullable: true, editable: true, defaultValue: null, length: 29, alias: Valuation Date , type: esriFieldTypeDate )
• notes ( modelName: NOTES_, nullable: true, editable: true, defaultValue: null, length: 255, alias: Notes, type: esriFieldTypeString )
• creator ( modelName: CREATOR_, nullable: true, editable: true, defaultValue: null, length: 30, alias: Creator , type: esriFieldTypeString )
• createdate ( modelName: CREATEDATE_, nullable: true, editable: true, defaultValue: null, length: 29, alias: Created , type: esriFieldTypeDate )
• editor ( modelName: EDITOR_, nullable: true, editable: true, defaultValue: null, length: 30, alias: Editor , type: esriFieldTypeString )
• editdate ( modelName: EDITDATE_, nullable: true, editable: true, defaultValue: null, length: 29, alias: Edited , type: esriFieldTypeDate )
• supstrytype ( modelName: SUPSTRYTYPE, nullable: true, editable: true, defaultValue: null, length: 20, alias: Type, type: esriFieldTypeString , Coded Values: [Arm: Arm] , [Catwalk: Catwalk] , [Handrail: Handrail] , ...10 more... )
• servicelife ( modelName: SERVICELIFE_, nullable: true, editable: true, defaultValue: null, alias: Service Life , type: esriFieldTypeSmallInteger )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, type: esriFieldTypeGlobalID, modelName: globalid, alias: globalid )

Templates:

• Name: Super Structure
  Description:
  Prototype:
  lof: null
  notes: null
  omlink: null
  criticality: null
  createdate: null
  assetname: null
  replacevalue: null
  parentid: null
  manufacturer: null
  serialno: null
  speclink: null
  vendor: null
  assetowner: null
  warrantydate: null
  model: null
  assettype: null
  conditionscore: null
  conditiondate: null
  startupdate: null
  editor: null
  creator: null
  address: null
  servicelife: null
  tagnumber: null
  supstrytype: null
  manwebsite: null
  site: null
  system: null
  assetid: null
  manphone: null
  legacyid: null
  location: null
  risk: null
  cof: null
  valuedate: null
  editdate: null
  status: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• Process Structure (272) -- Related To: Process Structure (43)

Capabilities: Create,Editing,Uploads,Query,Update,Delete,Sync,Extract

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

Supports ApplyEdits By Upload Id: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Query Related Records   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Metadata