Name: CPSS Field Data

Display Field: FacilityID

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 1c57b11c6b8a44448da1a8b6bca6cff1

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: 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: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• FacilityID ( type: esriFieldTypeString, alias: Facility ID (CP Testing Station), editable: true, nullable: true, length: 255, defaultValue: null, modelName: FacilityID )
• Date ( type: esriFieldTypeDate, alias: Date, editable: true, nullable: false, length: 8, defaultValue: null, modelName: Date )
• Temperature ( type: esriFieldTypeDouble, alias: Temperature, editable: true, nullable: false, defaultValue: null, modelName: Temperature )
• Weather ( type: esriFieldTypeString, alias: Weather, editable: true, nullable: false, length: 255, defaultValue: null, modelName: Weather , Coded Values: [Sunny: Sunny] , [Partly Cloudy: Partly Cloudy] , [Cloudy: Cloudy] , ...1 more... )
• Stationing ( type: esriFieldTypeString, alias: Stationing, editable: true, nullable: false, length: 255, defaultValue: null, modelName: Stationing )
• TS_Style ( type: esriFieldTypeString, alias: TS Style, editable: true, nullable: false, length: 255, defaultValue: null, modelName: TS_Style , Coded Values: [Flush: Flush] , [Post: Post] )
• TS_Status ( type: esriFieldTypeString, alias: TS Status, editable: true, nullable: false, length: 255, defaultValue: null, modelName: TS_Status , Coded Values: [Complete: Complete] , [Broken: Broken] , [Unable to Locate: Unable to Locate] )
• TC_Required ( type: esriFieldTypeString, alias: Traffic Control Req'd, editable: true, nullable: false, length: 255, defaultValue: null, modelName: TC_Required , Coded Values: [Y: Yes] , [N: No] )
• Access_Required ( type: esriFieldTypeString, alias: Access Required, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Access_Required , Coded Values: [Y: Yes] , [N: No] )
• ConnectionWire_AWG_1 ( type: esriFieldTypeSmallInteger, alias: Connection/Wire: AWG - 1, editable: true, nullable: true, defaultValue: null, modelName: ConnectionWire_AWG_1 )
• ConnectionWire_Color_1 ( type: esriFieldTypeString, alias: Connection/Wire: Color - 1, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ConnectionWire_Color_1 )
• Structure_1 ( type: esriFieldTypeString, alias: Structure - 1, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Structure_1 )
• PipelineNative_1 ( type: esriFieldTypeSmallInteger, alias: Pipeline Native (mV) - 1, editable: true, nullable: true, defaultValue: null, modelName: PipelineNative_1 )
• CouponNative_1 ( type: esriFieldTypeSmallInteger, alias: Coupon Native (mV) - 1, editable: true, nullable: true, defaultValue: null, modelName: CouponNative_1 )
• PortRef_On_1 ( type: esriFieldTypeSmallInteger, alias: Portable Reference (mV): On - 1, editable: true, nullable: true, defaultValue: null, modelName: PortRef_On_1 )
• PortRef_InstantOff_1 ( type: esriFieldTypeSmallInteger, alias: Portable Reference (mV): Instant Off - 1, editable: true, nullable: true, defaultValue: null, modelName: PortRef_InstantOff_1 )
• PortRef_CouponOn_1 ( type: esriFieldTypeSmallInteger, alias: Portable Reference (mV): Coupon On - 1, editable: true, nullable: true, defaultValue: null, modelName: PortRef_CouponOn_1 )
• PortRef_CouponInstantOff_1 ( type: esriFieldTypeSmallInteger, alias: Portable Reference (mV): Coupon Instant Off - 1, editable: true, nullable: true, defaultValue: null, modelName: PortRef_CouponInstantOff_1 )
• PortRef_Polarization_1 ( type: esriFieldTypeSmallInteger, alias: Portable Reference (mV): Polarization - 1, editable: true, nullable: true, defaultValue: null, modelName: PortRef_Polarization_1 )
• PermRef_On_1 ( type: esriFieldTypeSmallInteger, alias: Permenant Reference (mV): On - 1, editable: true, nullable: true, defaultValue: null, modelName: PermRef_On_1 )
• PermRef_InstantOff_1 ( type: esriFieldTypeSmallInteger, alias: Permenant Reference (mV): Instant Off - 1, editable: true, nullable: true, defaultValue: null, modelName: PermRef_InstantOff_1 )
• PermRef_CouponOn_1 ( type: esriFieldTypeSmallInteger, alias: Permenant Reference (mV): Coupon On - 1, editable: true, nullable: true, defaultValue: null, modelName: PermRef_CouponOn_1 )
• PermRef_CouponInstantOff_1 ( type: esriFieldTypeSmallInteger, alias: Permenant Reference (mV): Coupon Instant Off - 1, editable: true, nullable: true, defaultValue: null, modelName: PermRef_CouponInstantOff_1 )
• PermRef_Polarization_1 ( type: esriFieldTypeSmallInteger, alias: Permenant Reference (mV): Polarization - 1, editable: true, nullable: true, defaultValue: null, modelName: PermRef_Polarization_1 )
• AnodeOCP_1 ( type: esriFieldTypeSmallInteger, alias: Anode OCP (mV) - 1, editable: true, nullable: true, defaultValue: null, modelName: AnodeOCP_1 )
• AnodeCurrent_1 ( type: esriFieldTypeSmallInteger, alias: Anode Current (mA) - 1, editable: true, nullable: true, defaultValue: null, modelName: AnodeCurrent_1 )
• ConnectionWire_AWG_2 ( type: esriFieldTypeSmallInteger, alias: Connection/Wire: AWG - 2, editable: true, nullable: true, defaultValue: null, modelName: ConnectionWire_AWG_2 )
• ConnectionWire_Color_2 ( type: esriFieldTypeString, alias: Connection/Wire: Color - 2, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ConnectionWire_Color_2 )
• Structure_2 ( type: esriFieldTypeString, alias: Structure - 2, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Structure_2 )
• PipelineNative_2 ( type: esriFieldTypeSmallInteger, alias: Pipeline Native (mV) - 2, editable: true, nullable: true, defaultValue: null, modelName: PipelineNative_2 )
• CouponNative_2 ( type: esriFieldTypeSmallInteger, alias: Coupon Native (mV) - 2, editable: true, nullable: true, defaultValue: null, modelName: CouponNative_2 )
• PortRef_On_2 ( type: esriFieldTypeSmallInteger, alias: Portable Reference (mV): On - 2, editable: true, nullable: true, defaultValue: null, modelName: PortRef_On_2 )
• PortRef_InstantOff_2 ( type: esriFieldTypeSmallInteger, alias: Portable Reference (mV): Instant Off - 2, editable: true, nullable: true, defaultValue: null, modelName: PortRef_InstantOff_2 )
• PortRef_CouponOn_2 ( type: esriFieldTypeSmallInteger, alias: Portable Reference (mV): Coupon On - 2, editable: true, nullable: true, defaultValue: null, modelName: PortRef_CouponOn_2 )
• PortRef_CouponInstantOff_2 ( type: esriFieldTypeSmallInteger, alias: Portable Reference (mV): Coupon Instant Off - 2, editable: true, nullable: true, defaultValue: null, modelName: PortRef_CouponInstantOff_2 )
• PortRef_Polarization_2 ( type: esriFieldTypeSmallInteger, alias: Portable Reference (mV): Polarization - 2, editable: true, nullable: true, defaultValue: null, modelName: PortRef_Polarization_2 )
• PermRef_On_2 ( type: esriFieldTypeSmallInteger, alias: Permenant Reference (mV): On - 2, editable: true, nullable: true, defaultValue: null, modelName: PermRef_On_2 )
• PermRef_InstantOff_2 ( type: esriFieldTypeSmallInteger, alias: Permenant Reference (mV): Instant Off - 2, editable: true, nullable: true, defaultValue: null, modelName: PermRef_InstantOff_2 )
• PermRef_CouponOn_2 ( type: esriFieldTypeSmallInteger, alias: Permenant Reference (mV): Coupon On - 2, editable: true, nullable: true, defaultValue: null, modelName: PermRef_CouponOn_2 )
• PermRef_CouponInstantOff_2 ( type: esriFieldTypeSmallInteger, alias: Permenant Reference (mV): Coupon Instant Off - 2, editable: true, nullable: true, defaultValue: null, modelName: PermRef_CouponInstantOff_2 )
• PermRef_Polarization_2 ( type: esriFieldTypeSmallInteger, alias: Permenant Reference (mV): Polarization - 2, editable: true, nullable: true, defaultValue: null, modelName: PermRef_Polarization_2 )
• AnodeOCP_2 ( type: esriFieldTypeSmallInteger, alias: Anode OCP (mV) - 2, editable: true, nullable: true, defaultValue: null, modelName: AnodeOCP_2 )
• AnodeCurrent_2 ( type: esriFieldTypeSmallInteger, alias: Anode Current (mA) - 2, editable: true, nullable: true, defaultValue: null, modelName: AnodeCurrent_2 )
• Damage ( type: esriFieldTypeString, alias: Damage Description, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Damage )
• Notes ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 500, defaultValue: null, modelName: Notes )
• 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 )
• Shunt1 ( type: esriFieldTypeDouble, alias: Shunt (mV) - 1, editable: true, nullable: true, defaultValue: null, modelName: Shunt1 )
• Shunt2 ( type: esriFieldTypeDouble, alias: Shunt (mV) - 2, editable: true, nullable: true, defaultValue: null, modelName: Shunt2 )
• ShuntRating1 ( type: esriFieldTypeDouble, alias: Shunt Rating - 1, editable: true, nullable: true, defaultValue: null, modelName: ShuntRating1 )
• ShuntRating2 ( type: esriFieldTypeDouble, alias: Shunt Rating - 2, editable: true, nullable: true, defaultValue: null, modelName: ShuntRating2 )
• ACPotential1 ( type: esriFieldTypeDouble, alias: AC Potential (VAC) - 1, editable: true, nullable: true, defaultValue: null, modelName: ACPotential1 )
• ACPotential2 ( type: esriFieldTypeDouble, alias: AC Potential (VAC) - 2, editable: true, nullable: true, defaultValue: null, modelName: ACPotential2 )

Templates:

• Name: CPSS Field Data
  Description:
  Prototype:
  ACPotential1: null
  ShuntRating2: null
  FacilityID: null
  Date: -2209161600000
  Temperature: 0
  Weather:
  Stationing:
  TS_Style:
  TS_Status:
  TC_Required:
  Access_Required: null
  ConnectionWire_AWG_1: null
  ConnectionWire_Color_1: null
  Structure_1: null
  PipelineNative_1: null
  CouponNative_1: null
  PortRef_On_1: null
  PortRef_InstantOff_1: null
  PortRef_CouponOn_1: null
  PortRef_CouponInstantOff_1: null
  PortRef_Polarization_1: null
  PermRef_On_1: null
  PermRef_InstantOff_1: null
  PermRef_CouponOn_1: null
  PermRef_CouponInstantOff_1: null
  PermRef_Polarization_1: null
  AnodeOCP_1: null
  AnodeCurrent_1: null
  ConnectionWire_AWG_2: null
  ConnectionWire_Color_2: null
  Structure_2: null
  PipelineNative_2: null
  CouponNative_2: null
  PortRef_On_2: null
  PortRef_InstantOff_2: null
  PortRef_CouponOn_2: null
  PortRef_CouponInstantOff_2: null
  PortRef_Polarization_2: null
  PermRef_On_2: null
  PermRef_InstantOff_2: null
  PermRef_CouponOn_2: null
  PermRef_CouponInstantOff_2: null
  PermRef_Polarization_2: null
  AnodeOCP_2: null
  AnodeCurrent_2: null
  Damage: null
  Notes: null
  ACPotential2: null
  ShuntRating1: null
  Shunt2: null
  Shunt1: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• GISTESTUSER.CP_Testing_Station (0) -- Related To: Testing Stations (0)

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

Sync Can Return Changes: true

Is Data Versioned: true

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: false

Child Resources:   Field Groups   Contingent Values

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