Layers:

Layer: All_Active_Controllers (0)

Name: All_Active_Controllers

Display Field: ASSETRP_NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 745a357ef9ba474d96cf99fbb332ba5d

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:
XMin: 738432.7510427982
YMin: 266110.43043905497
XMax: 880208.6275954694
YMax: 398542.9132769704
Spatial Reference: 102736  (2274)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:
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: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• ASSETID ( type: esriFieldTypeInteger, alias: AssetID, editable: true, nullable: true, defaultValue: null, modelName: ASSETID )
• ASSET_STATUS ( type: esriFieldTypeString, alias: Asset Status, editable: true, nullable: true, length: 10, defaultValue: null, modelName: ASSET_STATUS )
• ASSET_TYPE ( type: esriFieldTypeInteger, alias: Asset Type, editable: true, nullable: true, defaultValue: 1, modelName: ASSET_TYPE )
• ASSET_DESC ( type: esriFieldTypeString, alias: Asset Description, editable: true, nullable: true, length: 200, defaultValue: null, modelName: ASSET_DESC )
• ASSET_NOTES ( type: esriFieldTypeString, alias: Asset Notes, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: ASSET_NOTES )
• ASSET_CREATIONDATE ( type: esriFieldTypeDate, alias: Creation Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ASSET_CREATIONDATE )
• LASTMODIFIEDDATE ( type: esriFieldTypeDate, alias: Last Modified Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LASTMODIFIEDDATE )
• JURISDICTION ( type: esriFieldTypeString, alias: Jurisdiction, editable: true, nullable: true, length: 30, defaultValue: null, modelName: JURISDICTION )
• INTERSECTION ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 50, defaultValue: null, modelName: INTERSECTION )
• STREET ( type: esriFieldTypeString, alias: Street, editable: true, nullable: true, length: 20, defaultValue: null, modelName: STREET )
• Flash_1 ( type: esriFieldTypeString, alias: Flasher 1, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Flash_1 )
• CROSS_STREET ( type: esriFieldTypeString, alias: Cross Street, editable: true, nullable: true, length: 20, defaultValue: null, modelName: CROSS_STREET )
• Flash_2 ( type: esriFieldTypeString, alias: Flasher 2, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Flash_2 )
• N_or_S ( type: esriFieldTypeString, alias: N or S, editable: true, nullable: true, length: 7, defaultValue: null, modelName: N_or_S )
• PARCEL_ADDRESS ( type: esriFieldTypeString, alias: Nearest Parcel Address, editable: true, nullable: true, length: 240, defaultValue: null, modelName: PARCEL_ADDRESS )
• MLGW_ADDRESS ( type: esriFieldTypeString, alias: Nearest MLGW Address, editable: true, nullable: true, length: 240, defaultValue: null, modelName: MLGW_ADDRESS )
• ASSET_CITY ( type: esriFieldTypeString, alias: City, editable: true, nullable: true, length: 60, defaultValue: null, modelName: ASSET_CITY )
• ASSET_STATE ( type: esriFieldTypeString, alias: State, editable: true, nullable: true, length: 60, defaultValue: null, modelName: ASSET_STATE )
• ZIP_CODE ( type: esriFieldTypeString, alias: Postal Code, editable: true, nullable: true, length: 60, defaultValue: null, modelName: ZIP_CODE )
• PARCELID ( type: esriFieldTypeString, alias: Parcel ID, editable: true, nullable: true, length: 240, defaultValue: null, modelName: PARCELID )
• MAP_PAGE ( type: esriFieldTypeString, alias: Map Page, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MAP_PAGE )
• MAP_BLOCK ( type: esriFieldTypeString, alias: Map Block, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MAP_BLOCK )
• X_LONG ( type: esriFieldTypeDouble, alias: X_LONG, editable: true, nullable: true, defaultValue: null, modelName: X_LONG )
• Y_LAT ( type: esriFieldTypeDouble, alias: Y_LAT, editable: true, nullable: true, defaultValue: null, modelName: Y_LAT )
• FILTER ( type: esriFieldTypeInteger, alias: Filter, editable: true, nullable: true, defaultValue: null, modelName: FILTER )
• W116 ( type: esriFieldTypeInteger, alias: W116, editable: true, nullable: true, defaultValue: null, modelName: W116 )
• W60 ( type: esriFieldTypeInteger, alias: W60, editable: true, nullable: true, defaultValue: null, modelName: W60 )
• W150 ( type: esriFieldTypeInteger, alias: W150, editable: true, nullable: true, defaultValue: null, modelName: W150 )
• W42 ( type: esriFieldTypeInteger, alias: W42, editable: true, nullable: true, defaultValue: null, modelName: W42 )
• W5LED8R ( type: esriFieldTypeInteger, alias: W5LED8R, editable: true, nullable: true, defaultValue: null, modelName: W5LED8R )
• W7LED8G ( type: esriFieldTypeInteger, alias: W7LED8G, editable: true, nullable: true, defaultValue: null, modelName: W7LED8G )
• W7LED12PED ( type: esriFieldTypeInteger, alias: W7LED12PED, editable: true, nullable: true, defaultValue: null, modelName: W7LED12PED )
• W7LED18PED ( type: esriFieldTypeInteger, alias: W7LED18PED, editable: true, nullable: true, defaultValue: null, modelName: W7LED18PED )
• W10LED12YL ( type: esriFieldTypeInteger, alias: W10LED12YL, editable: true, nullable: true, defaultValue: null, modelName: W10LED12YL )
• W10LED12GL ( type: esriFieldTypeInteger, alias: W10LED12GL, editable: true, nullable: true, defaultValue: null, modelName: W10LED12GL )
• W11LED12R ( type: esriFieldTypeInteger, alias: W11LED12R, editable: true, nullable: true, defaultValue: null, modelName: W11LED12R )
• W20LED12G ( type: esriFieldTypeInteger, alias: W20LED12G, editable: true, nullable: true, defaultValue: null, modelName: W20LED12G )
• LED12Ydc ( type: esriFieldTypeInteger, alias: LED12Ydc, editable: true, nullable: true, defaultValue: null, modelName: LED12Ydc )
• LEDSig ( type: esriFieldTypeInteger, alias: LEDSig, editable: true, nullable: true, defaultValue: null, modelName: LEDSig )
• W9LED ( type: esriFieldTypeInteger, alias: W9LED, editable: true, nullable: true, defaultValue: null, modelName: W9LED )
• Marc ( type: esriFieldTypeString, alias: Marc, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Marc )
• Preemption ( type: esriFieldTypeString, alias: Preemption, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Preemption )
• Time_Clock ( type: esriFieldTypeInteger, alias: Time Clock, editable: true, nullable: true, defaultValue: null, modelName: Time_Clock )
• Auto_DST ( type: esriFieldTypeInteger, alias: Auto DST, editable: true, nullable: true, defaultValue: null, modelName: Auto_DST )
• ASP ( type: esriFieldTypeInteger, alias: ASP, editable: true, nullable: true, defaultValue: null, modelName: ASP )
• ESP ( type: esriFieldTypeInteger, alias: ESP, editable: true, nullable: true, defaultValue: null, modelName: ESP )
• Painted ( type: esriFieldTypeInteger, alias: Painted, editable: true, nullable: true, defaultValue: null, modelName: Painted )
• Wood ( type: esriFieldTypeInteger, alias: Wood, editable: true, nullable: true, defaultValue: null, modelName: Wood )
• Concrete ( type: esriFieldTypeInteger, alias: Concrete, editable: true, nullable: true, defaultValue: null, modelName: Concrete )
• Insp_Book ( type: esriFieldTypeInteger, alias: Insp. Book, editable: true, nullable: true, defaultValue: null, modelName: Insp_Book )
• Circuit_Nu ( type: esriFieldTypeInteger, alias: Circuit Number, editable: true, nullable: true, defaultValue: null, modelName: Circuit_Nu )
• Address_nu ( type: esriFieldTypeInteger, alias: Address number, editable: true, nullable: true, defaultValue: null, modelName: Address_nu )
• EB ( type: esriFieldTypeInteger, alias: EB, editable: true, nullable: true, defaultValue: null, modelName: EB )
• WB ( type: esriFieldTypeInteger, alias: WB, editable: true, nullable: true, defaultValue: null, modelName: WB )
• NB ( type: esriFieldTypeInteger, alias: NB, editable: true, nullable: true, defaultValue: null, modelName: NB )
• SB ( type: esriFieldTypeInteger, alias: SB, editable: true, nullable: true, defaultValue: null, modelName: SB )
• LOOP ( type: esriFieldTypeInteger, alias: Loop, editable: true, nullable: true, defaultValue: null, modelName: LOOP )
• CONTR_DESC ( type: esriFieldTypeString, alias: Controller, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CONTR_DESC )
• CONTR_ID ( type: esriFieldTypeInteger, alias: Controller ID, editable: true, nullable: true, defaultValue: null, modelName: CONTR_ID )
• CONTR_MFG ( type: esriFieldTypeString, alias: Controller Manufacturer, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CONTR_MFG )
• CONTR_MODELNO ( type: esriFieldTypeString, alias: Controller Model number, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CONTR_MODELNO )
• CONTR_MFG_SERIAL ( type: esriFieldTypeString, alias: Controller Mfg Serial, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CONTR_MFG_SERIAL )
• CONTR_Sftwr_Vers ( type: esriFieldTypeString, alias: Controller Sftwr Version, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CONTR_Sftwr_Vers )
• CONTR_MonitorNo ( type: esriFieldTypeInteger, alias: Controller Monitor Number, editable: true, nullable: true, defaultValue: null, modelName: CONTR_MonitorNo )
• CONTR_MFG2 ( type: esriFieldTypeString, alias: Controller Manufacturer 1, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CONTR_MFG2 )
• CONTR_ModelType ( type: esriFieldTypeString, alias: Controller Model Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CONTR_ModelType )
• CONTR_Unit_Serial ( type: esriFieldTypeString, alias: Controller Unit Serial, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CONTR_Unit_Serial )
• Bluetoad_n ( type: esriFieldTypeInteger, alias: Controller Bluetoad N, editable: true, nullable: true, defaultValue: null, modelName: Bluetoad_n )
• Bluetoad_s ( type: esriFieldTypeString, alias: Controller Bluetoad S, editable: true, nullable: true, length: 254, defaultValue: null, modelName: Bluetoad_s )
• Bluetoad_t ( type: esriFieldTypeString, alias: Controller Bluetoad T, editable: true, nullable: true, length: 254, defaultValue: null, modelName: Bluetoad_t )
• CONTR_STATUS ( type: esriFieldTypeString, alias: Controller Status, editable: true, nullable: true, length: 30, defaultValue: null, modelName: CONTR_STATUS )
• CONTR_NOTES ( type: esriFieldTypeString, alias: Controller REMARKS, editable: true, nullable: true, length: 500, defaultValue: null, modelName: CONTR_NOTES )
• ASSETRP_NAME ( type: esriFieldTypeString, alias: Responsible Party Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ASSETRP_NAME )
• ASSETRP_ADDRESS ( type: esriFieldTypeString, alias: Responsible Party Address, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ASSETRP_ADDRESS )
• ASSETRP_CITY ( type: esriFieldTypeString, alias: Responsible Party City, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ASSETRP_CITY )
• ASSETRP_PHONE ( type: esriFieldTypeString, alias: Responsible Party Phone, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ASSETRP_PHONE )
• ASSETRP_STATE ( type: esriFieldTypeString, alias: Responsible Party State, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ASSETRP_STATE )
• ASSETRP_ZIP ( type: esriFieldTypeString, alias: Responsible Party Zip, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ASSETRP_ZIP )
• 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 )
• Notification_By ( type: esriFieldTypeString, alias: Notification_By, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Notification_By )
• ASSET_INSTALLDATE ( type: esriFieldTypeDate, alias: Installation Year, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ASSET_INSTALLDATE )
• SIGNAL_TYPE ( type: esriFieldTypeString, alias: Signal Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SIGNAL_TYPE )
• ASSET_AGE ( type: esriFieldTypeInteger, alias: InfrastructureAge, editable: true, nullable: true, defaultValue: null, modelName: ASSET_AGE )
• Modernization_Status ( type: esriFieldTypeString, alias: Modernization Status, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Modernization_Status )
• PROJECT ( type: esriFieldTypeString, alias: Project, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PROJECT )
• PRIORITY ( type: esriFieldTypeString, alias: Priority, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PRIORITY )
• X ( type: esriFieldTypeDouble, alias: X, editable: true, nullable: true, defaultValue: null, modelName: X )
• Y ( type: esriFieldTypeDouble, alias: Y, editable: true, nullable: true, defaultValue: null, modelName: Y )
• DAYSOLD ( type: esriFieldTypeInteger, alias: DAYSOLD, editable: true, nullable: true, defaultValue: null, modelName: DAYSOLD )
• EMAILSENT ( type: esriFieldTypeString, alias: EMAILSENT, editable: true, nullable: true, length: 5, defaultValue: null, modelName: EMAILSENT )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
Templates:
• Name: All_Active_Controllers
  Description:
  Prototype:
  EMAILSENT: null
  DAYSOLD: null
  ASSETID: null
  ASSET_STATUS: null
  ASSET_TYPE: 1
  ASSET_DESC: null
  ASSET_NOTES: null
  ASSET_CREATIONDATE: null
  LASTMODIFIEDDATE: null
  JURISDICTION: null
  INTERSECTION: null
  STREET: null
  Flash_1: null
  CROSS_STREET: null
  Flash_2: null
  N_or_S: null
  PARCEL_ADDRESS: null
  MLGW_ADDRESS: null
  ASSET_CITY: null
  ASSET_STATE: null
  ZIP_CODE: null
  PARCELID: null
  MAP_PAGE: null
  MAP_BLOCK: null
  X_LONG: null
  Y_LAT: null
  FILTER: null
  W116: null
  W60: null
  W150: null
  W42: null
  W5LED8R: null
  W7LED8G: null
  W7LED12PED: null
  W7LED18PED: null
  W10LED12YL: null
  W10LED12GL: null
  W11LED12R: null
  W20LED12G: null
  LED12Ydc: null
  LEDSig: null
  W9LED: null
  Marc: null
  Preemption: null
  Time_Clock: null
  Auto_DST: null
  ASP: null
  ESP: null
  Painted: null
  Wood: null
  Concrete: null
  Insp_Book: null
  Circuit_Nu: null
  Address_nu: null
  EB: null
  WB: null
  NB: null
  SB: null
  LOOP: null
  CONTR_DESC: null
  CONTR_ID: null
  CONTR_MFG: null
  CONTR_MODELNO: null
  CONTR_MFG_SERIAL: null
  CONTR_Sftwr_Vers: null
  CONTR_MonitorNo: null
  CONTR_MFG2: null
  CONTR_ModelType: null
  CONTR_Unit_Serial: null
  Bluetoad_n: null
  Bluetoad_s: null
  Bluetoad_t: null
  CONTR_STATUS: null
  CONTR_NOTES: null
  ASSETRP_NAME: null
  ASSETRP_ADDRESS: null
  ASSETRP_CITY: null
  ASSETRP_PHONE: null
  ASSETRP_STATE: null
  ASSETRP_ZIP: null
  Y: null
  X: null
  PRIORITY: null
  PROJECT: null
  Notification_By: null
  ASSET_INSTALLDATE: null
  SIGNAL_TYPE: null
  ASSET_AGE: null
  Modernization_Status: null
  
  Drawing Tool: esriFeatureEditToolPoint

Relationships:

• GISADMIN.ENG_TrafficSignals_Controller_Inspections (0) -- Related To: Controller_Inspections (2)

Layer: Controllers_To_Inspect (1)

Name: Controllers_To_Inspect

Display Field: ASSETRP_NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 745a357ef9ba474d96cf99fbb332ba5d

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:
XMin: 738432.7510427982
YMin: 266110.43043905497
XMax: 880208.6275954694
YMax: 398542.9132769704
Spatial Reference: 102736  (2274)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:
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: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• ASSETID ( type: esriFieldTypeInteger, alias: AssetID, editable: true, nullable: true, defaultValue: null, modelName: ASSETID )
• ASSET_STATUS ( type: esriFieldTypeString, alias: Asset Status, editable: true, nullable: true, length: 10, defaultValue: null, modelName: ASSET_STATUS )
• ASSET_TYPE ( type: esriFieldTypeInteger, alias: Asset Type, editable: true, nullable: true, defaultValue: 1, modelName: ASSET_TYPE )
• ASSET_DESC ( type: esriFieldTypeString, alias: Asset Description, editable: true, nullable: true, length: 200, defaultValue: null, modelName: ASSET_DESC )
• ASSET_NOTES ( type: esriFieldTypeString, alias: Asset Notes, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: ASSET_NOTES )
• ASSET_CREATIONDATE ( type: esriFieldTypeDate, alias: Creation Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ASSET_CREATIONDATE )
• LASTMODIFIEDDATE ( type: esriFieldTypeDate, alias: Last Modified Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LASTMODIFIEDDATE )
• JURISDICTION ( type: esriFieldTypeString, alias: Jurisdiction, editable: true, nullable: true, length: 30, defaultValue: null, modelName: JURISDICTION )
• INTERSECTION ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 50, defaultValue: null, modelName: INTERSECTION )
• STREET ( type: esriFieldTypeString, alias: Street, editable: true, nullable: true, length: 20, defaultValue: null, modelName: STREET )
• Flash_1 ( type: esriFieldTypeString, alias: Flasher 1, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Flash_1 )
• CROSS_STREET ( type: esriFieldTypeString, alias: Cross Street, editable: true, nullable: true, length: 20, defaultValue: null, modelName: CROSS_STREET )
• Flash_2 ( type: esriFieldTypeString, alias: Flasher 2, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Flash_2 )
• N_or_S ( type: esriFieldTypeString, alias: N or S, editable: true, nullable: true, length: 7, defaultValue: null, modelName: N_or_S )
• PARCEL_ADDRESS ( type: esriFieldTypeString, alias: Nearest Parcel Address, editable: true, nullable: true, length: 240, defaultValue: null, modelName: PARCEL_ADDRESS )
• MLGW_ADDRESS ( type: esriFieldTypeString, alias: Nearest MLGW Address, editable: true, nullable: true, length: 240, defaultValue: null, modelName: MLGW_ADDRESS )
• ASSET_CITY ( type: esriFieldTypeString, alias: City, editable: true, nullable: true, length: 60, defaultValue: null, modelName: ASSET_CITY )
• ASSET_STATE ( type: esriFieldTypeString, alias: State, editable: true, nullable: true, length: 60, defaultValue: null, modelName: ASSET_STATE )
• ZIP_CODE ( type: esriFieldTypeString, alias: Postal Code, editable: true, nullable: true, length: 60, defaultValue: null, modelName: ZIP_CODE )
• PARCELID ( type: esriFieldTypeString, alias: Parcel ID, editable: true, nullable: true, length: 240, defaultValue: null, modelName: PARCELID )
• MAP_PAGE ( type: esriFieldTypeString, alias: Map Page, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MAP_PAGE )
• MAP_BLOCK ( type: esriFieldTypeString, alias: Map Block, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MAP_BLOCK )
• X_LONG ( type: esriFieldTypeDouble, alias: X_LONG, editable: true, nullable: true, defaultValue: null, modelName: X_LONG )
• Y_LAT ( type: esriFieldTypeDouble, alias: Y_LAT, editable: true, nullable: true, defaultValue: null, modelName: Y_LAT )
• FILTER ( type: esriFieldTypeInteger, alias: Filter, editable: true, nullable: true, defaultValue: null, modelName: FILTER )
• W116 ( type: esriFieldTypeInteger, alias: W116, editable: true, nullable: true, defaultValue: null, modelName: W116 )
• W60 ( type: esriFieldTypeInteger, alias: W60, editable: true, nullable: true, defaultValue: null, modelName: W60 )
• W150 ( type: esriFieldTypeInteger, alias: W150, editable: true, nullable: true, defaultValue: null, modelName: W150 )
• W42 ( type: esriFieldTypeInteger, alias: W42, editable: true, nullable: true, defaultValue: null, modelName: W42 )
• W5LED8R ( type: esriFieldTypeInteger, alias: W5LED8R, editable: true, nullable: true, defaultValue: null, modelName: W5LED8R )
• W7LED8G ( type: esriFieldTypeInteger, alias: W7LED8G, editable: true, nullable: true, defaultValue: null, modelName: W7LED8G )
• W7LED12PED ( type: esriFieldTypeInteger, alias: W7LED12PED, editable: true, nullable: true, defaultValue: null, modelName: W7LED12PED )
• W7LED18PED ( type: esriFieldTypeInteger, alias: W7LED18PED, editable: true, nullable: true, defaultValue: null, modelName: W7LED18PED )
• W10LED12YL ( type: esriFieldTypeInteger, alias: W10LED12YL, editable: true, nullable: true, defaultValue: null, modelName: W10LED12YL )
• W10LED12GL ( type: esriFieldTypeInteger, alias: W10LED12GL, editable: true, nullable: true, defaultValue: null, modelName: W10LED12GL )
• W11LED12R ( type: esriFieldTypeInteger, alias: W11LED12R, editable: true, nullable: true, defaultValue: null, modelName: W11LED12R )
• W20LED12G ( type: esriFieldTypeInteger, alias: W20LED12G, editable: true, nullable: true, defaultValue: null, modelName: W20LED12G )
• LED12Ydc ( type: esriFieldTypeInteger, alias: LED12Ydc, editable: true, nullable: true, defaultValue: null, modelName: LED12Ydc )
• LEDSig ( type: esriFieldTypeInteger, alias: LEDSig, editable: true, nullable: true, defaultValue: null, modelName: LEDSig )
• W9LED ( type: esriFieldTypeInteger, alias: W9LED, editable: true, nullable: true, defaultValue: null, modelName: W9LED )
• Marc ( type: esriFieldTypeString, alias: Marc, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Marc )
• Preemption ( type: esriFieldTypeString, alias: Preemption, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Preemption )
• Time_Clock ( type: esriFieldTypeInteger, alias: Time Clock, editable: true, nullable: true, defaultValue: null, modelName: Time_Clock )
• Auto_DST ( type: esriFieldTypeInteger, alias: Auto DST, editable: true, nullable: true, defaultValue: null, modelName: Auto_DST )
• ASP ( type: esriFieldTypeInteger, alias: ASP, editable: true, nullable: true, defaultValue: null, modelName: ASP )
• ESP ( type: esriFieldTypeInteger, alias: ESP, editable: true, nullable: true, defaultValue: null, modelName: ESP )
• Painted ( type: esriFieldTypeInteger, alias: Painted, editable: true, nullable: true, defaultValue: null, modelName: Painted )
• Wood ( type: esriFieldTypeInteger, alias: Wood, editable: true, nullable: true, defaultValue: null, modelName: Wood )
• Concrete ( type: esriFieldTypeInteger, alias: Concrete, editable: true, nullable: true, defaultValue: null, modelName: Concrete )
• Insp_Book ( type: esriFieldTypeInteger, alias: Insp. Book, editable: true, nullable: true, defaultValue: null, modelName: Insp_Book )
• Circuit_Nu ( type: esriFieldTypeInteger, alias: Circuit Number, editable: true, nullable: true, defaultValue: null, modelName: Circuit_Nu )
• Address_nu ( type: esriFieldTypeInteger, alias: Address number, editable: true, nullable: true, defaultValue: null, modelName: Address_nu )
• EB ( type: esriFieldTypeInteger, alias: EB, editable: true, nullable: true, defaultValue: null, modelName: EB )
• WB ( type: esriFieldTypeInteger, alias: WB, editable: true, nullable: true, defaultValue: null, modelName: WB )
• NB ( type: esriFieldTypeInteger, alias: NB, editable: true, nullable: true, defaultValue: null, modelName: NB )
• SB ( type: esriFieldTypeInteger, alias: SB, editable: true, nullable: true, defaultValue: null, modelName: SB )
• LOOP ( type: esriFieldTypeInteger, alias: Loop, editable: true, nullable: true, defaultValue: null, modelName: LOOP )
• CONTR_DESC ( type: esriFieldTypeString, alias: Controller, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CONTR_DESC )
• CONTR_ID ( type: esriFieldTypeInteger, alias: Controller ID, editable: true, nullable: true, defaultValue: null, modelName: CONTR_ID )
• CONTR_MFG ( type: esriFieldTypeString, alias: Controller Manufacturer, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CONTR_MFG )
• CONTR_MODELNO ( type: esriFieldTypeString, alias: Controller Model number, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CONTR_MODELNO )
• CONTR_MFG_SERIAL ( type: esriFieldTypeString, alias: Controller Mfg Serial, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CONTR_MFG_SERIAL )
• CONTR_Sftwr_Vers ( type: esriFieldTypeString, alias: Controller Sftwr Version, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CONTR_Sftwr_Vers )
• CONTR_MonitorNo ( type: esriFieldTypeInteger, alias: Controller Monitor Number, editable: true, nullable: true, defaultValue: null, modelName: CONTR_MonitorNo )
• CONTR_MFG2 ( type: esriFieldTypeString, alias: Controller Manufacturer 1, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CONTR_MFG2 )
• CONTR_ModelType ( type: esriFieldTypeString, alias: Controller Model Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CONTR_ModelType )
• CONTR_Unit_Serial ( type: esriFieldTypeString, alias: Controller Unit Serial, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CONTR_Unit_Serial )
• Bluetoad_n ( type: esriFieldTypeInteger, alias: Controller Bluetoad N, editable: true, nullable: true, defaultValue: null, modelName: Bluetoad_n )
• Bluetoad_s ( type: esriFieldTypeString, alias: Controller Bluetoad S, editable: true, nullable: true, length: 254, defaultValue: null, modelName: Bluetoad_s )
• Bluetoad_t ( type: esriFieldTypeString, alias: Controller Bluetoad T, editable: true, nullable: true, length: 254, defaultValue: null, modelName: Bluetoad_t )
• CONTR_STATUS ( type: esriFieldTypeString, alias: Controller Status, editable: true, nullable: true, length: 30, defaultValue: null, modelName: CONTR_STATUS )
• CONTR_NOTES ( type: esriFieldTypeString, alias: Controller REMARKS, editable: true, nullable: true, length: 500, defaultValue: null, modelName: CONTR_NOTES )
• ASSETRP_NAME ( type: esriFieldTypeString, alias: Responsible Party Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ASSETRP_NAME )
• ASSETRP_ADDRESS ( type: esriFieldTypeString, alias: Responsible Party Address, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ASSETRP_ADDRESS )
• ASSETRP_CITY ( type: esriFieldTypeString, alias: Responsible Party City, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ASSETRP_CITY )
• ASSETRP_PHONE ( type: esriFieldTypeString, alias: Responsible Party Phone, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ASSETRP_PHONE )
• ASSETRP_STATE ( type: esriFieldTypeString, alias: Responsible Party State, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ASSETRP_STATE )
• ASSETRP_ZIP ( type: esriFieldTypeString, alias: Responsible Party Zip, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ASSETRP_ZIP )
• 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 )
• Notification_By ( type: esriFieldTypeString, alias: Notification_By, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Notification_By )
• ASSET_INSTALLDATE ( type: esriFieldTypeDate, alias: Installation Year, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ASSET_INSTALLDATE )
• SIGNAL_TYPE ( type: esriFieldTypeString, alias: Signal Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SIGNAL_TYPE )
• ASSET_AGE ( type: esriFieldTypeInteger, alias: InfrastructureAge, editable: true, nullable: true, defaultValue: null, modelName: ASSET_AGE )
• Modernization_Status ( type: esriFieldTypeString, alias: Modernization Status, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Modernization_Status )
• PROJECT ( type: esriFieldTypeString, alias: Project, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PROJECT )
• PRIORITY ( type: esriFieldTypeString, alias: Priority, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PRIORITY )
• X ( type: esriFieldTypeDouble, alias: X, editable: true, nullable: true, defaultValue: null, modelName: X )
• Y ( type: esriFieldTypeDouble, alias: Y, editable: true, nullable: true, defaultValue: null, modelName: Y )
• DAYSOLD ( type: esriFieldTypeInteger, alias: DAYSOLD, editable: true, nullable: true, defaultValue: null, modelName: DAYSOLD )
• EMAILSENT ( type: esriFieldTypeString, alias: EMAILSENT, editable: true, nullable: true, length: 5, defaultValue: null, modelName: EMAILSENT )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
Templates:
• Name: Controllers_To_Inspect
  Description:
  Prototype:
  EMAILSENT: null
  DAYSOLD: null
  ASSETID: null
  ASSET_STATUS: null
  ASSET_TYPE: 1
  ASSET_DESC: null
  ASSET_NOTES: null
  ASSET_CREATIONDATE: null
  LASTMODIFIEDDATE: null
  JURISDICTION: null
  INTERSECTION: null
  STREET: null
  Flash_1: null
  CROSS_STREET: null
  Flash_2: null
  N_or_S: null
  PARCEL_ADDRESS: null
  MLGW_ADDRESS: null
  ASSET_CITY: null
  ASSET_STATE: null
  ZIP_CODE: null
  PARCELID: null
  MAP_PAGE: null
  MAP_BLOCK: null
  X_LONG: null
  Y_LAT: null
  FILTER: null
  W116: null
  W60: null
  W150: null
  W42: null
  W5LED8R: null
  W7LED8G: null
  W7LED12PED: null
  W7LED18PED: null
  W10LED12YL: null
  W10LED12GL: null
  W11LED12R: null
  W20LED12G: null
  LED12Ydc: null
  LEDSig: null
  W9LED: null
  Marc: null
  Preemption: null
  Time_Clock: null
  Auto_DST: null
  ASP: null
  ESP: null
  Painted: null
  Wood: null
  Concrete: null
  Insp_Book: null
  Circuit_Nu: null
  Address_nu: null
  EB: null
  WB: null
  NB: null
  SB: null
  LOOP: null
  CONTR_DESC: null
  CONTR_ID: null
  CONTR_MFG: null
  CONTR_MODELNO: null
  CONTR_MFG_SERIAL: null
  CONTR_Sftwr_Vers: null
  CONTR_MonitorNo: null
  CONTR_MFG2: null
  CONTR_ModelType: null
  CONTR_Unit_Serial: null
  Bluetoad_n: null
  Bluetoad_s: null
  Bluetoad_t: null
  CONTR_STATUS: null
  CONTR_NOTES: null
  ASSETRP_NAME: null
  ASSETRP_ADDRESS: null
  ASSETRP_CITY: null
  ASSETRP_PHONE: null
  ASSETRP_STATE: null
  ASSETRP_ZIP: null
  Y: null
  X: null
  PRIORITY: null
  PROJECT: null
  Notification_By: null
  ASSET_INSTALLDATE: null
  SIGNAL_TYPE: null
  ASSET_AGE: null
  Modernization_Status: null
  
  Drawing Tool: esriFeatureEditToolPoint

Relationships:

• GISADMIN.ENG_TrafficSignals_Controller_Inspections (1) -- Related To: Controller_Inspections (2)

Tables:

Table: Controller_Inspections (2)

Name: Controller_Inspections

Display Field: InspectedBy

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 745a357ef9ba474d96cf99fbb332ba5d

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

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• InspectionID ( type: esriFieldTypeInteger, alias: InspectionID, editable: true, nullable: true, defaultValue: null, modelName: InspectionID )
• ControllerGUID ( type: esriFieldTypeGUID, alias: ControllerGUID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: ControllerGUID )
• GlobalID ( type: esriFieldTypeGUID, alias: GlobalID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: GlobalID )
• InspectionDate ( type: esriFieldTypeDate, alias: InspectionDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InspectionDate )
• InspectedBy ( type: esriFieldTypeString, alias: InspectedBy, editable: true, nullable: true, length: 255, defaultValue: null, modelName: InspectedBy )
• Status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Status )
• Notes ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Notes )
• GlobalID_1 ( type: esriFieldTypeGlobalID, alias: GlobalID_1, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID_1 )
• 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 )
Templates:
• Name: Controller_Inspections
  Description:
  Prototype:
  Notes: null
  Status: null
  InspectionID: null
  ControllerGUID: null
  GlobalID: null
  InspectionDate: null
  InspectedBy: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• GISADMIN.Eng_TrafficSignals_ControllerLocations (0) -- Related To: All_Active_Controllers (0)
• GISADMIN.Eng_TrafficSignals_ControllerLocations (1) -- Related To: Controllers_To_Inspect (1)