Name: HMMS_TrafficSignals_Flat

Display Field: MAJ_NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description: HMMS_TrafficSignals

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -83.126124392
YMin: 36.5462000000001
XMax: -75.36148
YMax: 39.31978795
Spatial Reference: 4326 (4326)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"angle":0,"xoffset":0,"yoffset":0,"type":"esriPMS","imageData":"iVBORw0KGgoAAAANSUhEUgAAABgAAAAXCAYAAAARIY8tAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAABDJJREFUSIm1lVFIlFkUx393mklUDGdldT5DYhUSpAfXKRHbESGrB0fbKSyKic11m4HYXiJStLKZpRTqoSRCZhUSFPZlC3bsoRWMCsLCoXkblKneHIYot4wddZzv7IP64afbLrvtnqf7cc79/84957vnWvmfzfpPgtPpdDGAzWab+c8Buq43KaV+ARCRnUqpyCcDdF2/BGhAQinlnpiYAKCmpmZS1/XQalwmkwl87FQfBYhI+P379+7FxUVycnJQSpFMJgFIpVLouu5LpVJkZWWRl5fnA9RfAkTEKSI+pZRzJStnf38/d+7c4cyZMxw5csS08e7duwQCAU6dOkVbWxsiMikiEWA0k8lEVk9kBaN54devX2vv3r1jdnaWV69e0d7eDkBpaSmu8nL6T5xgUYSvr12jqqqKaDSKz+fD4XCgaZrTbrc78/PzfQUFBQmg2ABYrVYN0Lq6uhgYGNhwzMLCQkZaWynp6ADg154eo1wAzc3NxjoYDHLhwgXNVCKlVEREIpcvX3ZWV1dz69YtotGosSmRSFC+tGR8bwF+EzEl4XK5aGtrW4WNbuiBUmqniIRPnjzpdrvdeL1exsfHAcjJyeHHeJzvu7rIWK3cmJyk9eBBQ9zj8TA4OIjdbk+ISHhpaSmwAbDyS7oBHA4HN2/epKKiAoDNmzdz7vZtpr/bz4cPv/PTz485evGiAejr6yM/Px9AU0o1Wa3WEGBuslKq+/r168RiMR4+fMjU1JQhkE6nefCgm/r6EUQKaGk5ZypPSUkJlZWV1NbWUlNTox0/fjzM2ibbbLYZEWHHjh10dHSwsLBgEpifn6eqygLEUSpOXd0BXr6cN8VEo1GSySRer5fV7E0lAnY2NDRMvnnzhrGxMTwej+Gw2WxMTW1i167PgM95/jxFebnDBBgbG2P37t1kZ2dHRGRjD0SkWCkVyc3NdTY3N3Pv3j0aGxsBsNvtbNt2nkDgGKnUAr29P/DsWZMh/ujRI1wuF0BCREYtFkvYBFjtQSwWc87OzvL27Vvi8bghkEwmafnmGJu++IotwP4D8xQVFRn+WCzG3NwcdrtdKyws7NZ1XbNYLH4DsHLRnMPDw1y5coX1VlRUxJd7XHROLw+7Hk8jL168MPx+v99Y9/X1cfr0aV86nQ7YbLaZtRdttLOz011fX8/Q0BAjIyPGpunpadSae6WArVu3mpLw+/0cPnyY2tpaRCRkmkUrkCYR8e3du/dSdXW1lpubSyi0PJHLyso4H+ym91svktEZ6LnBnuFdhvjZs2cJBoNkZ2dHgJBSyhjlpnG94giJyMzVq1e1Q4cOATA3N8fTx094+viJEZuXl8f9+/cBqKurIysrK6SU8rPO/vQ9UEoV67retG/fPg1oApwioq0LG92+ffuMUqoYCK/N+m8BAGt+tRAsvxfrkvj0J/PfCK63PwD/OqzOLqICmAAAAABJRU5ErkJggg==","width":15.502500000000001,"height":14.8565625}},"transparency":0}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field: GLOBALID

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• GLOBALID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• ASSET_ID (type: esriFieldTypeInteger, alias: Asset ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• REG_SIGNAL_ID (type: esriFieldTypeString, alias: Region Signal ID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• ASSET_NUM (type: esriFieldTypeString, alias: Asset Number, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• ASSET_SUBTYPE (type: esriFieldTypeString, alias: Asset SubType, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Traffic Signal: Traffic Signal], [Intersection Flasher: Intersection Flasher], [Pedestrian Hybrid Beacon: Pedestrian Hybrid Beacon])
• ASSET_GROUP (type: esriFieldTypeString, alias: Asset Group, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• STATUS (type: esriFieldTypeString, alias: Asset Status, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Proposed: 1-Proposed], [Under Construction: 2-Under Construction], [Active: 3-Active], ... 2 more ...)
• DISTRICT (type: esriFieldTypeString, alias: District, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Bristol: Bristol], [Salem: Salem], [Lynchburg: Lynchburg], ... 6 more ...)
• MAINT_JURISDICTION (type: esriFieldTypeString, alias: Maintenance Jurisdiction, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [000: Arlington County], [001: Accomack County], [002: Albemarle County], ... 326 more ...)
• MAJ_NAME (type: esriFieldTypeString, alias: Major Route Name, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• MAJ_NUM (type: esriFieldTypeString, alias: Major Route Number, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• ROUTE_TYPE (type: esriFieldTypeString, alias: Route Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Interstate: Interstate], [Primary: Primary], [Secondary: Secondary])
• MINOR_NAME (type: esriFieldTypeString, alias: Minor Route Name, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• MINOR_NUM (type: esriFieldTypeString, alias: Minor Route Number, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• INSTALL_DATE (type: esriFieldTypeDate, alias: Latest Install/Modification Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• MAINT_RESP (type: esriFieldTypeString, alias: Maintenance Responsibility, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Bristol: Bristol], [Salem: Salem], [Lynchburg: Lynchburg], ... 6 more ...)
• COORDINATION (type: esriFieldTypeString, alias: Isolated versus Coordinated, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Isolated: Isolated], [Coordinated: Coordinated])
• SIGNAL_MODE (type: esriFieldTypeString, alias: Advanced Signal Mode Present, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• UPS (type: esriFieldTypeString, alias: UPS Present?, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• PREEMPTION (type: esriFieldTypeString, alias: Pre-emption Present?, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• PEDSIGNAL (type: esriFieldTypeString, alias: Pedestrian Signals?, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• DETECTION (type: esriFieldTypeString, alias: Detection?, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• COMMENTS (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• CREATED_USER (type: esriFieldTypeString, alias: CREATED_USER, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CREATED_DATE (type: esriFieldTypeDate, alias: CREATED_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• LAST_EDITED_USER (type: esriFieldTypeString, alias: LAST_EDITED_USER, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• LAST_EDITED_DATE (type: esriFieldTypeDate, alias: LAST_EDITED_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• FYA (type: esriFieldTypeString, alias: Flashing Yellow Arrow (FYA)?, SQL Type: sqlTypeOther, length: 70, nullable: true, editable: true, Coded Values: [Installed on all appropriate approaches: Installed on all appropriate approaches], [Installed on some but not all appropriate approaches: Installed on some but not all appropriate approaches], [Planned and Funded: Planned and Funded], ... 3 more ...)
• HVSB (type: esriFieldTypeString, alias: High Visibility Signal Backplate(HVSB)?, SQL Type: sqlTypeOther, length: 70, nullable: true, editable: true, Coded Values: [HVSB Installed: HVSB Installed], [HVSB Planned and Funded: HVSB Planned and Funded], [HVSB Not Funded: HVSB Not Funded])
• APS (type: esriFieldTypeString, alias: Access Pedestrian Signal (APS)?, SQL Type: sqlTypeOther, length: 70, nullable: true, editable: true, Coded Values: [Installed on all appropriate approaches: Installed on all appropriate approaches], [Installed on some but not all appropriate approaches: Installed on some but not all appropriate approaches], [Planned and Funded: Planned and Funded], ... 3 more ...)
• PROJECTUPC (type: esriFieldTypeString, alias: Project UPC, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• ATSPM (type: esriFieldTypeString, alias: Automated Traffic Signal Performance Metrics?, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])

Templates:

Name: HMMS_TrafficSignals_Flat
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• STATUS: Active

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 9/5/2024 3:17:09 PM

Schema Last Edit Date: 9/5/2024 3:17:09 PM

Data Last Edit Date: 9/5/2024 3:17:09 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat