Name: WWTP Sampler

Display Field: AssetType

Type: Table

Description:

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• AssetType (type: esriFieldTypeString, alias: AssetType, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Aerator: Aerator], [Air Compressor: Air Compressor], [Air Handler: Air Handler], ... 63 more ...)
• Asset (type: esriFieldTypeString, alias: Asset, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Plant (type: esriFieldTypeString, alias: Plant, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [TGB-WTP: Timothy G. Broome WTP], [CJCR-WWTP: Central Johnston County Regional WWTP])
• Process (type: esriFieldTypeString, alias: Process, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Administrative/Safety: Administrative/Safety], [Biological/Secondary Treatment: Biological/Secondary Treatment], [Chemical Treatment: Chemical Treatment], ... 7 more ...)
• Subprocess (type: esriFieldTypeString, alias: Subprocess, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Aerobic Digestion: Aerobic Digestion], [Biological Nutrient Removal: Biological Nutrient Removal], [Blower Building: Blower Building], ... 25 more ...)
• Assembly (type: esriFieldTypeString, alias: Assembly, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Aeration Basin: Aeration Basin], [Aerobic Digestor: Aerobic Digestor], [Anoxic Zone: Anoxic Zone], ... 24 more ...)
• LegacyAssetID (type: esriFieldTypeString, alias: LegacyAssetID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Manufacturer (type: esriFieldTypeString, alias: Manufacturer, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ModelType (type: esriFieldTypeString, alias: ModelType, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SerialNumber (type: esriFieldTypeString, alias: SerialNumber, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ConditionRating (type: esriFieldTypeDouble, alias: ConditionRating, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Comments (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• AssetID (type: esriFieldTypeString, alias: AssetID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• DisplayID (type: esriFieldTypeString, alias: DisplayID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Status (type: esriFieldTypeString, alias: Status, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Manual_Location (type: esriFieldTypeString, alias: Manual_Location, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Hyperlink (type: esriFieldTypeString, alias: Hyperlink, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Voltage (type: esriFieldTypeString, alias: Voltage, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Power_kW (type: esriFieldTypeDouble, alias: Power_kW, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Range_ (type: esriFieldTypeString, alias: Range, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Horsepower (type: esriFieldTypeDouble, alias: Horsepower, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Flow_gpm (type: esriFieldTypeString, alias: Flow_gpm, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Head_ft (type: esriFieldTypeString, alias: Head_ft, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• RotationalSpeed_rpm (type: esriFieldTypeString, alias: RotationalSpeed_rpm, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Power_kVA (type: esriFieldTypeDouble, alias: Power_kVA, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Size_in (type: esriFieldTypeDouble, alias: Size_in, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Pressure_psi (type: esriFieldTypeString, alias: Pressure_psi, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ParentAssetID (type: esriFieldTypeString, alias: ParentAssetID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)

Templates:

Name: WWTP Sampler
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Relationships:

• CJCR_Processes (257) -- Related To: CJCR_Processes (5)
• CJCR_Assemblies (147) -- Related To: CJCR_Assemblies (3)
• CJCR_Subprocesses (202) -- Related To: CJCR_Subprocesses (4)
• Plants (346) -- Related To: Plants (6)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 11/13/2024 9:53:53 PM

Schema Last Edit Date: 11/13/2024 9:53:53 PM

Data Last Edit Date: 11/13/2024 9:53:53 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Query Related Records   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat