Layers:

Layer: All_Active_Controllers (0)

Name: All_Active_Controllers

Display Field: ASSETRP_NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

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

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: 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: 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: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

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

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:

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

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: 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: 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: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

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

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

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

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• InspectionID ( type: esriFieldTypeInteger, alias: InspectionID )
• ControllerGUID ( type: esriFieldTypeGUID, alias: ControllerGUID, length: 38 )
• GlobalID ( type: esriFieldTypeGUID, alias: GlobalID, length: 38 )
• InspectionDate ( type: esriFieldTypeDate, alias: InspectionDate, length: 8 )
• InspectedBy ( type: esriFieldTypeString, alias: InspectedBy, length: 255 )
• Status ( type: esriFieldTypeString, alias: Status, length: 255 )
• Notes ( type: esriFieldTypeString, alias: Notes, length: 255 )
• GlobalID_1 ( type: esriFieldTypeGlobalID, alias: GlobalID_1, 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 )

Relationships:

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