Name: TST SIM relate

Display Field: SITE_ID

Type: Table

Geometry Type: N/A

Description:

Service Item Id: cd5c339c5e064ed5afa90731dc33de7f

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• SITE_ID ( type: esriFieldTypeString, alias: Site ID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: SITE_ID )
• TABLE_ ( type: esriFieldTypeString, alias: Table, editable: true, nullable: true, length: 255, defaultValue: null, modelName: TABLE_ )
• PUBLIC_ ( type: esriFieldTypeInteger, alias: Public, editable: true, nullable: true, defaultValue: null, modelName: PUBLIC_ )
• TST_ONLY ( type: esriFieldTypeInteger, alias: TST only, editable: true, nullable: true, defaultValue: null, modelName: TST_ONLY )
• COMMS_TYPE ( type: esriFieldTypeString, alias: Comms type, editable: true, nullable: true, length: 255, defaultValue: null, modelName: COMMS_TYPE )
• COMMS_SERVICE ( type: esriFieldTypeString, alias: Comms service, editable: true, nullable: true, length: 255, defaultValue: null, modelName: COMMS_SERVICE )
• COMMS_NETWORK ( type: esriFieldTypeString, alias: Comms network, editable: true, nullable: true, length: 255, defaultValue: null, modelName: COMMS_NETWORK )
• TELEPHONE_NO ( type: esriFieldTypeString, alias: Telephone number, editable: true, nullable: true, length: 255, defaultValue: null, modelName: TELEPHONE_NO )
• SIM_NUMBER ( type: esriFieldTypeString, alias: SIM number, editable: true, nullable: true, length: 255, defaultValue: null, modelName: SIM_NUMBER )
• COMMS_PROVIDER ( type: esriFieldTypeString, alias: Comms provider, editable: true, nullable: true, length: 255, defaultValue: null, modelName: COMMS_PROVIDER )
• APN ( type: esriFieldTypeString, alias: APN, editable: true, nullable: true, length: 255, defaultValue: null, modelName: APN )
• USER_ ( type: esriFieldTypeString, alias: User, editable: true, nullable: true, length: 255, defaultValue: null, modelName: USER_ )
• PASS ( type: esriFieldTypeString, alias: Pass, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PASS )
• SIM_ACTIVE ( type: esriFieldTypeDate, alias: SIM active, editable: true, nullable: true, length: 8, defaultValue: null, modelName: SIM_ACTIVE )
• INSTALLED ( type: esriFieldTypeDate, alias: Installed, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALLED )
• DATA_RESTRICT_MONTH ( type: esriFieldTypeString, alias: Data restrict month, editable: true, nullable: true, length: 255, defaultValue: null, modelName: DATA_RESTRICT_MONTH )
• DATA_POOL ( type: esriFieldTypeString, alias: Data pool, editable: true, nullable: true, length: 255, defaultValue: null, modelName: DATA_POOL )
• CONTRACT_MONTHS ( type: esriFieldTypeInteger, alias: Contract months, editable: true, nullable: true, defaultValue: null, modelName: CONTRACT_MONTHS )
• START ( type: esriFieldTypeDate, alias: Start date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: START )
• END_ ( type: esriFieldTypeDate, alias: End date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: END_ )
• CHARGE_1 ( type: esriFieldTypeDouble, alias: Charge 1, editable: true, nullable: true, defaultValue: null, modelName: CHARGE_1 )
• CHARGE_2 ( type: esriFieldTypeString, alias: Charge 2, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CHARGE_2 )
• CHARGE_3 ( type: esriFieldTypeString, alias: Charge 3, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CHARGE_3 )
• NON_DATA_CHARGES ( type: esriFieldTypeString, alias: Non data charges, editable: true, nullable: true, length: 255, defaultValue: null, modelName: NON_DATA_CHARGES )
• COMMENT_1 ( type: esriFieldTypeString, alias: Comment 1, editable: true, nullable: true, length: 255, defaultValue: null, modelName: COMMENT_1 )
• COMMENT_2 ( type: esriFieldTypeString, alias: Comment 2, editable: true, nullable: true, length: 255, defaultValue: null, modelName: COMMENT_2 )
• COMMENT_3 ( type: esriFieldTypeString, alias: Comment 3, editable: true, nullable: true, length: 255, defaultValue: null, modelName: COMMENT_3 )
• ParentGuid_TrafficCounters ( type: esriFieldTypeGUID, alias: ParentGuid_TrafficCounters, editable: true, nullable: true, length: 38, defaultValue: null, modelName: ParentGuid_TrafficCounters )
• ParentGuid_RealTimeInfo ( type: esriFieldTypeGUID, alias: ParentGuid_RealTimeInfo, editable: true, nullable: true, length: 38, defaultValue: null, modelName: ParentGuid_RealTimeInfo )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )

Templates:

• Name: TST SIM relate
  Description:
  Prototype:
  ParentGuid_RealTimeInfo: null
  ParentGuid_TrafficCounters: null
  SITE_ID: null
  TABLE_: null
  PUBLIC_: null
  TST_ONLY: null
  COMMS_TYPE: null
  COMMS_SERVICE: null
  COMMS_NETWORK: null
  TELEPHONE_NO: null
  SIM_NUMBER: null
  COMMS_PROVIDER: null
  APN: null
  USER_: null
  PASS: null
  SIM_ACTIVE: null
  INSTALLED: null
  DATA_RESTRICT_MONTH: null
  DATA_POOL: null
  CONTRACT_MONTHS: null
  START: null
  END_: null
  CHARGE_1: null
  CHARGE_2: null
  CHARGE_3: null
  NON_DATA_CHARGES: null
  COMMENT_1: null
  COMMENT_2: null
  COMMENT_3: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• Network_WigWagSignals (2) -- Related To: School Crossing Patrol Signals (3)
• Network_CCTV_sites (5) -- Related To: CCTV (6)
• Network_TrafficSignalAssets (0) -- Related To: Traffic Signals (0)
• Network_RealTimeInformation (3) -- Related To: Real Time Information (4)
• Network_VehicleActuatedSigns (6) -- Related To: Vehicle Activated Signs (7)
• Network_TrafficCounters (4) -- Related To: Traffic Counter (5)
• Network_WAP (7) -- Related To: Wireless AP Data Set (9)
• Network_VMS (1) -- Related To: VMS (2)
• Network_BelishaBeacons (8) -- Related To: Belisha Beacons (11)

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

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

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