Name: CPSS Field Data

Display Field: FacilityID

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 9725cbaef52049bbaa04230f87c7cc58

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: 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: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
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: true
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: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• FacilityID ( type: esriFieldTypeString, alias: Facility ID (CP Testing Station), length: 255 )
• Date ( type: esriFieldTypeDate, alias: Date, length: 8 )
• Temperature ( type: esriFieldTypeDouble, alias: Temperature )
• Weather ( type: esriFieldTypeString, alias: Weather, length: 255 , Coded Values: [Sunny: Sunny] , [Partly Cloudy: Partly Cloudy] , [Cloudy: Cloudy] , ...1 more... )
• Stationing ( type: esriFieldTypeString, alias: Stationing, length: 255 )
• TS_Style ( type: esriFieldTypeString, alias: TS Style, length: 255 , Coded Values: [Flush: Flush] , [Post: Post] )
• TS_Status ( type: esriFieldTypeString, alias: TS Status, length: 255 , Coded Values: [Complete: Complete] , [Broken: Broken] , [Unable to Locate: Unable to Locate] )
• TC_Required ( type: esriFieldTypeString, alias: Traffic Control Req'd, length: 255 , Coded Values: [Y: Yes] , [N: No] )
• Access_Required ( type: esriFieldTypeString, alias: Access Required, length: 255 , Coded Values: [Y: Yes] , [N: No] )
• ConnectionWire_AWG_1 ( type: esriFieldTypeSmallInteger, alias: Connection/Wire: AWG - 1 )
• ConnectionWire_Color_1 ( type: esriFieldTypeString, alias: Connection/Wire: Color - 1, length: 255 )
• Structure_1 ( type: esriFieldTypeString, alias: Structure - 1, length: 255 )
• PipelineNative_1 ( type: esriFieldTypeSmallInteger, alias: Pipeline Native (mV) - 1 )
• CouponNative_1 ( type: esriFieldTypeSmallInteger, alias: Coupon Native (mV) - 1 )
• PortRef_On_1 ( type: esriFieldTypeSmallInteger, alias: Portable Reference (mV): On - 1 )
• PortRef_InstantOff_1 ( type: esriFieldTypeSmallInteger, alias: Portable Reference (mV): Instant Off - 1 )
• PortRef_CouponOn_1 ( type: esriFieldTypeSmallInteger, alias: Portable Reference (mV): Coupon On - 1 )
• PortRef_CouponInstantOff_1 ( type: esriFieldTypeSmallInteger, alias: Portable Reference (mV): Coupon Instant Off - 1 )
• PortRef_Polarization_1 ( type: esriFieldTypeSmallInteger, alias: Portable Reference (mV): Polarization - 1 )
• PermRef_On_1 ( type: esriFieldTypeSmallInteger, alias: Permenant Reference (mV): On - 1 )
• PermRef_InstantOff_1 ( type: esriFieldTypeSmallInteger, alias: Permenant Reference (mV): Instant Off - 1 )
• PermRef_CouponOn_1 ( type: esriFieldTypeSmallInteger, alias: Permenant Reference (mV): Coupon On - 1 )
• PermRef_CouponInstantOff_1 ( type: esriFieldTypeSmallInteger, alias: Permenant Reference (mV): Coupon Instant Off - 1 )
• PermRef_Polarization_1 ( type: esriFieldTypeSmallInteger, alias: Permenant Reference (mV): Polarization - 1 )
• AnodeOCP_1 ( type: esriFieldTypeSmallInteger, alias: Anode OCP (mV) - 1 )
• AnodeCurrent_1 ( type: esriFieldTypeSmallInteger, alias: Anode Current (mA) - 1 )
• ConnectionWire_AWG_2 ( type: esriFieldTypeSmallInteger, alias: Connection/Wire: AWG - 2 )
• ConnectionWire_Color_2 ( type: esriFieldTypeString, alias: Connection/Wire: Color - 2, length: 255 )
• Structure_2 ( type: esriFieldTypeString, alias: Structure - 2, length: 255 )
• PipelineNative_2 ( type: esriFieldTypeSmallInteger, alias: Pipeline Native (mV) - 2 )
• CouponNative_2 ( type: esriFieldTypeSmallInteger, alias: Coupon Native (mV) - 2 )
• PortRef_On_2 ( type: esriFieldTypeSmallInteger, alias: Portable Reference (mV): On - 2 )
• PortRef_InstantOff_2 ( type: esriFieldTypeSmallInteger, alias: Portable Reference (mV): Instant Off - 2 )
• PortRef_CouponOn_2 ( type: esriFieldTypeSmallInteger, alias: Portable Reference (mV): Coupon On - 2 )
• PortRef_CouponInstantOff_2 ( type: esriFieldTypeSmallInteger, alias: Portable Reference (mV): Coupon Instant Off - 2 )
• PortRef_Polarization_2 ( type: esriFieldTypeSmallInteger, alias: Portable Reference (mV): Polarization - 2 )
• PermRef_On_2 ( type: esriFieldTypeSmallInteger, alias: Permenant Reference (mV): On - 2 )
• PermRef_InstantOff_2 ( type: esriFieldTypeSmallInteger, alias: Permenant Reference (mV): Instant Off - 2 )
• PermRef_CouponOn_2 ( type: esriFieldTypeSmallInteger, alias: Permenant Reference (mV): Coupon On - 2 )
• PermRef_CouponInstantOff_2 ( type: esriFieldTypeSmallInteger, alias: Permenant Reference (mV): Coupon Instant Off - 2 )
• PermRef_Polarization_2 ( type: esriFieldTypeSmallInteger, alias: Permenant Reference (mV): Polarization - 2 )
• AnodeOCP_2 ( type: esriFieldTypeSmallInteger, alias: Anode OCP (mV) - 2 )
• AnodeCurrent_2 ( type: esriFieldTypeSmallInteger, alias: Anode Current (mA) - 2 )
• ConnectionWire_AWG_3 ( type: esriFieldTypeSmallInteger, alias: Connection/Wire: AWG - 3 )
• ConnectionWire_Color_3 ( type: esriFieldTypeString, alias: Connection/Wire: Color - 3, length: 255 )
• Structure_3 ( type: esriFieldTypeString, alias: Structure - 3, length: 255 )
• PipelineNative_3 ( type: esriFieldTypeSmallInteger, alias: Pipeline Native (mV) - 3 )
• CouponNative_3 ( type: esriFieldTypeSmallInteger, alias: Coupon Native (mV) - 3 )
• PortRef_On_3 ( type: esriFieldTypeSmallInteger, alias: Portable Reference (mV): On - 3 )
• PortRef_InstantOff_3 ( type: esriFieldTypeSmallInteger, alias: Portable Reference (mV): Instant Off - 3 )
• PortRef_CouponOn_3 ( type: esriFieldTypeSmallInteger, alias: Portable Reference (mV): Coupon On - 3 )
• PortRef_CouponInstantOff_3 ( type: esriFieldTypeSmallInteger, alias: Portable Reference (mV): Coupon Instant Off - 3 )
• PortRef_Polarization_3 ( type: esriFieldTypeSmallInteger, alias: Portable Reference (mV): Polarization - 3 )
• PermRef_On_3 ( type: esriFieldTypeSmallInteger, alias: Permenant Reference (mV): On - 3 )
• PermRef_InstantOff_3 ( type: esriFieldTypeSmallInteger, alias: Permenant Reference (mV): Instant Off - 3 )
• PermRef_CouponOn_3 ( type: esriFieldTypeSmallInteger, alias: Permenant Reference (mV): Coupon On - 3 )
• PermRef_CouponInstantOff_3 ( type: esriFieldTypeSmallInteger, alias: Permenant Reference (mV): Coupon Instant Off - 3 )
• PermRef_Polarization_3 ( type: esriFieldTypeSmallInteger, alias: Permenant Reference (mV): Polarization - 3 )
• AnodeOCP_3 ( type: esriFieldTypeSmallInteger, alias: Anode OCP (mV) - 3 )
• AnodeCurrent_3 ( type: esriFieldTypeSmallInteger, alias: Anode Current (mA) - 3 )
• ConnectionWire_AWG_4 ( type: esriFieldTypeSmallInteger, alias: Connection/Wire: AWG - 4 )
• ConnectionWire_Color_4 ( type: esriFieldTypeString, alias: Connection/Wire: Color - 4, length: 255 )
• Structure_4 ( type: esriFieldTypeString, alias: Structure - 4, length: 255 )
• PipelineNative_4 ( type: esriFieldTypeSmallInteger, alias: Pipeline Native (mV) - 4 )
• CouponNative_4 ( type: esriFieldTypeSmallInteger, alias: Coupon Native (mV) - 4 )
• PortRef_On_4 ( type: esriFieldTypeSmallInteger, alias: Portable Reference (mV): On - 4 )
• PortRef_InstantOff_4 ( type: esriFieldTypeSmallInteger, alias: Portable Reference (mV): Instant Off - 4 )
• PortRef_CouponOn_4 ( type: esriFieldTypeSmallInteger, alias: Portable Reference (mV): Coupon On - 4 )
• PortRef_CouponInstantOff_4 ( type: esriFieldTypeSmallInteger, alias: Portable Reference (mV): Coupon Instant Off - 4 )
• PortRef_Polarization_4 ( type: esriFieldTypeSmallInteger, alias: Portable Reference (mV): Polarization - 4 )
• PermRef_On_4 ( type: esriFieldTypeSmallInteger, alias: Permenant Reference (mV): On - 4 )
• PermRef_InstantOff_4 ( type: esriFieldTypeSmallInteger, alias: Permenant Reference (mV): Instant Off - 4 )
• PermRef_CouponOn_4 ( type: esriFieldTypeSmallInteger, alias: Permenant Reference (mV): Coupon On - 4 )
• PermRef_CouponInstantOff_4 ( type: esriFieldTypeSmallInteger, alias: Permenant Reference (mV): Coupon Instant Off - 4 )
• PermRef_Polarization_4 ( type: esriFieldTypeSmallInteger, alias: Permenant Reference (mV): Polarization - 4 )
• AnodeOCP_4 ( type: esriFieldTypeSmallInteger, alias: Anode OCP (mV) - 4 )
• AnodeCurrent_4 ( type: esriFieldTypeSmallInteger, alias: Anode Current (mA) - 4 )
• ConnectionWire_AWG_5 ( type: esriFieldTypeSmallInteger, alias: Connection/Wire: AWG - 5 )
• ConnectionWire_Color_5 ( type: esriFieldTypeString, alias: Connection/Wire: Color - 5, length: 255 )
• Structure_5 ( type: esriFieldTypeString, alias: Structure - 5, length: 255 )
• PipelineNative_5 ( type: esriFieldTypeSmallInteger, alias: Pipeline Native (mV) - 5 )
• CouponNative_5 ( type: esriFieldTypeSmallInteger, alias: Coupon Native (mV) - 5 )
• PortRef_On_5 ( type: esriFieldTypeSmallInteger, alias: Portable Reference (mV): On - 5 )
• PortRef_InstantOff_5 ( type: esriFieldTypeSmallInteger, alias: Portable Reference (mV): Instant Off - 5 )
• PortRef_CouponOn_5 ( type: esriFieldTypeSmallInteger, alias: Portable Reference (mV): Coupon On - 5 )
• PortRef_CouponInstantOff_5 ( type: esriFieldTypeSmallInteger, alias: Portable Reference (mV): Coupon Instant Off - 5 )
• PortRef_Polarization_5 ( type: esriFieldTypeSmallInteger, alias: Portable Reference (mV): Polarization - 5 )
• PermRef_On_5 ( type: esriFieldTypeSmallInteger, alias: Permenant Reference (mV): On - 5 )
• PermRef_InstantOff_5 ( type: esriFieldTypeSmallInteger, alias: Permenant Reference (mV): Instant Off - 5 )
• PermRef_CouponOn_5 ( type: esriFieldTypeSmallInteger, alias: Permenant Reference (mV): Coupon On - 5 )
• PermRef_CouponInstantOff_5 ( type: esriFieldTypeSmallInteger, alias: Permenant Reference (mV): Coupon Instant Off - 5 )
• PermRef_Polarization_5 ( type: esriFieldTypeSmallInteger, alias: Permenant Reference (mV): Polarization - 5 )
• AnodeOCP_5 ( type: esriFieldTypeSmallInteger, alias: Anode OCP (mV) - 5 )
• AnodeCurrent_5 ( type: esriFieldTypeSmallInteger, alias: Anode Current (mA) - 5 )
• ConnectionWire_AWG_6 ( type: esriFieldTypeSmallInteger, alias: Connection/Wire: AWG - 6 )
• ConnectionWire_Color_6 ( type: esriFieldTypeString, alias: Connection/Wire: Color - 6, length: 255 )
• Structure_6 ( type: esriFieldTypeString, alias: Structure - 6, length: 255 )
• PipelineNative_6 ( type: esriFieldTypeSmallInteger, alias: Pipeline Native (mV) - 6 )
• CouponNative_6 ( type: esriFieldTypeSmallInteger, alias: Coupon Native (mV) - 6 )
• PortRef_On_6 ( type: esriFieldTypeSmallInteger, alias: Portable Reference (mV): On - 6 )
• PortRef_InstantOff_6 ( type: esriFieldTypeSmallInteger, alias: Portable Reference (mV): Instant Off - 6 )
• PortRef_CouponOn_6 ( type: esriFieldTypeSmallInteger, alias: Portable Reference (mV): Coupon On - 6 )
• PortRef_CouponInstantOff_6 ( type: esriFieldTypeSmallInteger, alias: Portable Reference (mV): Coupon Instant Off - 6 )
• PortRef_Polarization_6 ( type: esriFieldTypeSmallInteger, alias: Portable Reference (mV): Polarization - 6 )
• PermRef_On_6 ( type: esriFieldTypeSmallInteger, alias: Permenant Reference (mV): On - 6 )
• PermRef_InstantOff_6 ( type: esriFieldTypeSmallInteger, alias: Permenant Reference (mV): Instant Off - 6 )
• PermRef_CouponOn_6 ( type: esriFieldTypeSmallInteger, alias: Permenant Reference (mV): Coupon On - 6 )
• PermRef_CouponInstantOff_6 ( type: esriFieldTypeSmallInteger, alias: Permenant Reference (mV): Coupon Instant Off - 6 )
• PermRef_Polarization_6 ( type: esriFieldTypeSmallInteger, alias: Permenant Reference (mV): Polarization - 6 )
• AnodeOCP_6 ( type: esriFieldTypeSmallInteger, alias: Anode OCP (mV) - 6 )
• AnodeCurrent_6 ( type: esriFieldTypeSmallInteger, alias: Anode Current (mA) - 6 )
• Damage ( type: esriFieldTypeString, alias: Damage Description, length: 255 )
• Notes ( type: esriFieldTypeString, alias: Notes, length: 500 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• Shunt1 ( type: esriFieldTypeDouble, alias: Shunt (mV) - 1 )
• Shunt2 ( type: esriFieldTypeDouble, alias: Shunt (mV) - 2 )
• Shunt3 ( type: esriFieldTypeDouble, alias: Shunt (mV) - 3 )
• Shunt4 ( type: esriFieldTypeDouble, alias: Shunt (mV) - 4 )
• Shunt5 ( type: esriFieldTypeDouble, alias: Shunt (mV) - 5 )
• Shunt6 ( type: esriFieldTypeDouble, alias: Shunt (mV) - 6 )
• ShuntRating1 ( type: esriFieldTypeDouble, alias: Shunt Rating - 1 )
• ShuntRating2 ( type: esriFieldTypeDouble, alias: Shunt Rating - 2 )
• ShuntRating3 ( type: esriFieldTypeDouble, alias: Shunt Rating - 3 )
• ShuntRating4 ( type: esriFieldTypeDouble, alias: Shunt Rating - 4 )
• ShuntRating5 ( type: esriFieldTypeDouble, alias: Shunt Rating - 5 )
• ShuntRating6 ( type: esriFieldTypeDouble, alias: Shunt Rating - 6 )
• ACPotential1 ( type: esriFieldTypeDouble, alias: AC Potential (VAC) - 1 )
• ACPotential2 ( type: esriFieldTypeDouble, alias: AC Potential (VAC) - 2 )
• ACPotential3 ( type: esriFieldTypeDouble, alias: AC Potential (VAC) - 3 )
• ACPotential4 ( type: esriFieldTypeDouble, alias: AC Potential (VAC) - 4 )
• ACPotential5 ( type: esriFieldTypeDouble, alias: AC Potential (VAC) - 5 )
• ACPotential6 ( type: esriFieldTypeDouble, alias: AC Potential (VAC) - 6 )

Relationships:

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

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata