Name: All Service Requests/ Work Orders

Display Field: GROUP_NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: bf8a6f0d33da40e1a88a7302e52a7616

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 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: -90.05865402519703
YMin: -89.99352385103703
XMax: 3.4969241878198385E7
YMax: 2204554.130643651
Spatial Reference: 102736  (2274)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: INCIDENT_TYPE_ID
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Style: esriSMSCircle
Color: [130, 0, 153, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 1
Default Label:
UniqueValueInfos:
• Value: 16747
  Label: EN-Maintain Markings
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [158, 26, 0, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: 10370
  Label: EN-Maintain Signs
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [0, 171, 131, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: 10368
  Label: EN-New Markings
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [129, 0, 143, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: 10367
  Label: EN-New Signs
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [0, 166, 39, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: 10194
  Label: EN-Traffic Sign Obstruction
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [0, 163, 103, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
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: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: INCIDENT_TYPE_ID

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• REC_EDIT_MODE ( type: esriFieldTypeString, alias: Live Link: Change to MANUAL, length: 50 , Coded Values: [AUTOMATIC: AUTOMATIC] , [MANUAL: MANUAL] , [PROCESSED: PROCESSED] , ...1 more... )
• REC_EDIT_MODE_COMMENTS ( type: esriFieldTypeString, alias: REC_EDIT_MODE_COMMENTS, length: 255 )
• X ( type: esriFieldTypeDouble, alias: X )
• Y ( type: esriFieldTypeDouble, alias: Y )
• DIVISION ( type: esriFieldTypeString, alias: Division, length: 150 )
• DEPARTMENT ( type: esriFieldTypeString, alias: Department, length: 150 )
• CATEGORY ( type: esriFieldTypeString, alias: Category, length: 50 )
• INCIDENT_ID ( type: esriFieldTypeInteger, alias: Oracle ID )
• INCIDENT_NUMBER ( type: esriFieldTypeString, alias: Service Request Number, length: 15 )
• INCIDENT_TYPE_ID ( type: esriFieldTypeInteger, alias: Service Request Type ID )
• REQUEST_TYPE ( type: esriFieldTypeString, alias: Service Request Type, length: 50 )
• REQUEST_STATUS ( type: esriFieldTypeString, alias: Service Request Status, length: 20 , Coded Values: [Open: Open] , [Closed: Completed] , [In Progress: In Progress] , ...1 more... )
• REQUEST_PRIORITY ( type: esriFieldTypeString, alias: Service Request Priority, length: 15 , Coded Values: [High: High] , [Medium: Medium] , [Low: Low] )
• REPORTED_DATE ( type: esriFieldTypeDate, alias: Reported Date, length: 8 )
• REQUEST_SUMMARY ( type: esriFieldTypeString, alias: Service Request Summary, length: 2000 )
• SR_CREATION_CHANNEL ( type: esriFieldTypeString, alias: SR_CREATION_CHANNEL, length: 50 )
• CREATED_BY_USER ( type: esriFieldTypeString, alias: Created By, length: 255 )
• DAYS_OLD ( type: esriFieldTypeSmallInteger, alias: Days Old )
• CREATION_DATE ( type: esriFieldTypeDate, alias: Creation Date, length: 8 )
• CREATED_BY ( type: esriFieldTypeInteger, alias: CREATED_BY )
• LAST_UPDATE_DATE ( type: esriFieldTypeDate, alias: Last Updated Date, length: 8 )
• UPDATED_BY_USER ( type: esriFieldTypeString, alias: Updated By, length: 50 )
• LAST_UPDATED_BY ( type: esriFieldTypeInteger, alias: LAST_UPDATED_BY )
• LAST_UPDATE_LOGIN ( type: esriFieldTypeInteger, alias: LAST_UPDATE_LOGIN )
• LAST_MODIFIED_DATE ( type: esriFieldTypeDate, alias: LAST_MODIFIED_DATE, length: 8 )
• FOLLOWUP_DATE ( type: esriFieldTypeDate, alias: Follow Up Date, length: 8 )
• NEXT_OPEN_TASK_DATE ( type: esriFieldTypeDate, alias: NEXT_OPEN_TASK_DATE, length: 8 )
• JOB_NOTES ( type: esriFieldTypeString, alias: Job Notes, length: 255 )
• REQUEST_NOTES ( type: esriFieldTypeString, alias: Consolidated Notes, length: 2000 )
• ASSIGNED_TO ( type: esriFieldTypeString, alias: Assigned To, length: 50 )
• ASSIGNED_DATE ( type: esriFieldTypeDate, alias: Assigned Date, length: 8 )
• SUPERVISOR ( type: esriFieldTypeString, alias: Supervisor, length: 50 )
• NOTIFICATION ( type: esriFieldTypeString, alias: Notification To, length: 50 , Coded Values: [1: SHOP] , [2: RADIO] , [3: ROUTINE MAINTENANCE] , ...5 more... )
• QAQC_YESNO ( type: esriFieldTypeString, alias: QA/QC, length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• QAQC_RATING ( type: esriFieldTypeInteger, alias: QA/QC Rating , Coded Values: [1: Good - 1] , [2: Fair - 2] , [3: Fair - 3] , ...2 more... )
• SUPERVISOR_APPROVAL ( type: esriFieldTypeString, alias: Supervisor Approval, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• SUPERVISOR_NOTES ( type: esriFieldTypeString, alias: Supervisor Notes, length: 255 )
• RESOLVED_DATE ( type: esriFieldTypeDate, alias: Resolved Date, length: 8 )
• CLOSE_DATE ( type: esriFieldTypeDate, alias: Closed Date, length: 8 )
• RESOLUTION_CODE ( type: esriFieldTypeString, alias: Resolution Code, length: 100 )
• RESOLUTION_CODE_MEANING ( type: esriFieldTypeString, alias: RESOLUTION_CODE_MEANING, length: 255 )
• RESOLUTION_SUMMARY ( type: esriFieldTypeString, alias: Resolution Summary, length: 2000 )
• GROUP_NAME ( type: esriFieldTypeString, alias: GROUP_NAME, length: 50 )
• OWNER_NAME ( type: esriFieldTypeString, alias: OWNER_NAME, length: 50 )
• STREET_NAME ( type: esriFieldTypeString, alias: STREET_NAME, length: 100 )
• ADDRESS1 ( type: esriFieldTypeString, alias: Location, length: 255 )
• ADDRESS2 ( type: esriFieldTypeString, alias: ADDRESS2, length: 100 )
• ADDRESS3 ( type: esriFieldTypeString, alias: ADDRESS3, length: 100 )
• CITY ( type: esriFieldTypeString, alias: City, length: 100 )
• STATE ( type: esriFieldTypeString, alias: State, length: 50 )
• POSTAL_CODE ( type: esriFieldTypeString, alias: Postal Code, length: 20 )
• PARCEL_ID ( type: esriFieldTypeString, alias: Parcel ID, length: 20 )
• ASSET_ID ( type: esriFieldTypeString, alias: Asset ID, length: 20 )
• P_LOCATION_ID ( type: esriFieldTypeInteger, alias: P_LOCATION_ID )
• P_PARTY_ID ( type: esriFieldTypeInteger, alias: P_PARTY_ID )
• CONTACT_NAME_FIRST ( type: esriFieldTypeString, alias: Parcel Owner, length: 255 )
• CONTACT_NAME_LAST ( type: esriFieldTypeString, alias: Parcel Owner, length: 255 )
• PERSON_ADDRESS1 ( type: esriFieldTypeString, alias: Owner Address1, length: 255 )
• PERSON_ADDRESS2 ( type: esriFieldTypeString, alias: Owner Address2, length: 255 )
• PERSON_ADDRESS3 ( type: esriFieldTypeString, alias: Owner Address3, length: 255 )
• PERSON_STATE ( type: esriFieldTypeString, alias: Owner State, length: 50 )
• PERSON_CITY ( type: esriFieldTypeString, alias: Owner City, length: 100 )
• PERSON_ZIP_CODE ( type: esriFieldTypeString, alias: Owner Zip Code, length: 50 )
• MAP_PG ( type: esriFieldTypeString, alias: Map Page, length: 50 , Coded Values: [118: 118] , [119: 119] , [120: 120] , ...122 more... )
• MAP_BLK ( type: esriFieldTypeString, alias: Map Block, length: 50 , Coded Values: [A: A] , [B: B] , [C: C] , ...14 more... )
• GRID_NO ( type: esriFieldTypeSmallInteger, alias: Grid Number , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...7 more... )
• CODE_SUBDISTRICT ( type: esriFieldTypeString, alias: Code Sub-District, length: 50 , Coded Values: [1-1: 1-1] , [1-2: 1-2] , [1-3: 1-3] , ...35 more... )
• TARGET_BLOCK ( type: esriFieldTypeString, alias: Target Block, length: 50 , Coded Values: [1: 1] , [10: 10] , [100: 100] , ...235 more... )
• DRAIN_ZONE ( type: esriFieldTypeString, alias: Drain Zone, length: 50 )
• DRAIN_GRID ( type: esriFieldTypeString, alias: Drain Grid, length: 50 )
• STREET_ZONE ( type: esriFieldTypeString, alias: Street Zone, length: 50 )
• STREET_GRID ( type: esriFieldTypeString, alias: Street Grid, length: 50 )
• TRAFFIC_ZONE ( type: esriFieldTypeString, alias: Traffic Zone, length: 50 )
• SWM_AREA ( type: esriFieldTypeString, alias: SWM Area, length: 10 , Coded Values: [A: A] , [B: B] , [C: C] , ...9 more... )
• SWM_ZONE ( type: esriFieldTypeString, alias: SWM Zone, length: 10 , Coded Values: [A1: A1] , [A2: A2] , [A3: A3] , ...15 more... )
• COLLECTION_DAY ( type: esriFieldTypeString, alias: Collection Day, length: 20 , Coded Values: [1: Monday] , [2: Tuesday] , [3: Wednesday] , ...2 more... )
• SWM_ROUTE ( type: esriFieldTypeString, alias: SWM Route, length: 10 )
• PREM_CODE ( type: esriFieldTypeInteger, alias: Premise Code )
• CUST_CODE ( type: esriFieldTypeInteger, alias: Customer Code )
• MLGW_ON ( type: esriFieldTypeString, alias: MLGW Est Date, length: 25 )
• MLGW_STATUS ( type: esriFieldTypeString, alias: MLGW Acct. Status, length: 25 , Coded Values: [A: Active] , [F: Final] , [I: Inactive] , ...1 more... )
• SWF_RATE ( type: esriFieldTypeString, alias: SWM Fee Rate, length: 10 , Coded Values: [C1: Special Class] , [C10: Single Family] , [C10A: Single Family Plus One Cart] , ...77 more... )
• SWF_STATUS ( type: esriFieldTypeString, alias: SWM Fee Status, length: 10 , Coded Values: [A: Active] , [F: Final] , [I: Inactive] , ...1 more... )
• MLGW_CUSTOMER ( type: esriFieldTypeString, alias: MLGW Customer, length: 255 )
• MLGW_CONTACT1 ( type: esriFieldTypeString, alias: MLGW Contact 1, length: 25 )
• MLGW_CONTACT2 ( type: esriFieldTypeString, alias: MLGW Contact 2, length: 25 )
• MLGW_EMAIL ( type: esriFieldTypeString, alias: MLGW Contact Email, length: 100 )
• NUMBER_OF_TASKS ( type: esriFieldTypeInteger, alias: NUMBER_OF_TASKS )
• LINKED_SR ( type: esriFieldTypeString, alias: Linked SR, length: 50 )
• RELATION ( type: esriFieldTypeString, alias: Relation with SR, length: 50 )
• cd_name ( type: esriFieldTypeInteger, alias: Council District No )
• cd_desc ( type: esriFieldTypeString, alias: Council District, length: 100 )
• sccd_name ( type: esriFieldTypeInteger, alias: Shelby Co. Council No )
• sccd_desc ( type: esriFieldTypeString, alias: Shelby Co. Council District, length: 100 )
• scd_name ( type: esriFieldTypeInteger, alias: Super District No )
• scd_desc ( type: esriFieldTypeString, alias: Super Council District, length: 100 )
• neigh_name ( type: esriFieldTypeString, alias: neigh_name, length: 100 )
• neigh_desc ( type: esriFieldTypeString, alias: Neighborhood Name, length: 100 )
• tract_name ( type: esriFieldTypeInteger, alias: Tract Number )
• tract_desc ( type: esriFieldTypeString, alias: Tract, length: 100 )
• voting_name ( type: esriFieldTypeString, alias: voting_name, length: 100 )
• voting_desc ( type: esriFieldTypeString, alias: Voting, length: 100 )
• zip_name ( type: esriFieldTypeInteger, alias: Zip Code No )
• zip_desc ( type: esriFieldTypeString, alias: Zip Code, length: 100 )
• ce_name ( type: esriFieldTypeString, alias: ce_name, length: 100 )
• ce_desc ( type: esriFieldTypeString, alias: ce_desc, length: 100 )
• cityzone ( type: esriFieldTypeString, alias: City Zone, length: 100 )
• CONTACT_NAME ( type: esriFieldTypeString, alias: SCF Name, length: 100 )
• CONTACT_EMAIL ( type: esriFieldTypeString, alias: SCF Email, length: 100 )
• CONTACT_PHONE ( type: esriFieldTypeString, alias: SCF Phone, length: 50 )
• SCF_URL ( type: esriFieldTypeString, alias: SeeClickFix URL, length: 1000 )
• SCF_Description ( type: esriFieldTypeString, alias: SeeClickFix Description, length: 2000 )
• EX_ATTRIBUTE12 ( type: esriFieldTypeString, alias: EX_ATTRIBUTE12, length: 100 )
• X_COORD ( type: esriFieldTypeDouble, alias: X_COORD )
• Y_COORD ( type: esriFieldTypeDouble, alias: Y_COORD )
• SIGN_TYPE ( type: esriFieldTypeSmallInteger, alias: Sign Type , Coded Values: [1: Street Signs] , [2: Directional] , [3: Guide Signs] , ...12 more... )
• SIGN_STATUS ( type: esriFieldTypeString, alias: Sign Status, length: 10 )
• SIGNCONDITION ( type: esriFieldTypeString, alias: SIGN CONDITION, length: 15 , Coded Values: [1: MISSING] , [2: DOWN] , [3: FADED] , ...3 more... )
• SIGN_OWNER ( type: esriFieldTypeString, alias: Sign Owner, length: 50 , Coded Values: [City: City of Memphis] , [MATA: Memphis Area Transit Authority] , [TDOT: Tennesse Department of Transport] , ...1 more... )
• REGULATORYTYPE ( type: esriFieldTypeString, alias: Regulatory Type, length: 50 , Coded Values: [R: R] , [N: N] )
• SIGN_DESC ( type: esriFieldTypeString, alias: Sign Description, length: 200 )
• MUTCD_CD ( type: esriFieldTypeString, alias: MUTCD Code, length: 20 , Coded Values: [D3-1: D3-1] , [D3-2: D3-2] , [D3-2(alt): D3-2(alt)] , ...2 more... )
• TRAFFIC_DIRECTION ( type: esriFieldTypeString, alias: Traffic Direction, length: 50 , Coded Values: [1: North] , [2: East] , [3: West] , ...5 more... )
• SIDEOFSTREET ( type: esriFieldTypeString, alias: Side of Street, length: 50 , Coded Values: [1: North] , [2: East] , [3: West] , ...5 more... )
• STREETCLASS ( type: esriFieldTypeString, alias: Streetclass, length: 50 , Coded Values: [1: Single Lane] , [2: Multi-lane] , [3: Expressway] , ...3 more... )
• DEAD_END ( type: esriFieldTypeString, alias: Dead End, length: 5 , Coded Values: [DED: Dead End both streets] , [DE1: Dead End Street1] , [DE2: Dead End Street2] )
• APPROX_DISTANCE_FROM ( type: esriFieldTypeString, alias: Approx Distance To, length: 50 , Coded Values: [1: North] , [2: East] , [3: West] , ...5 more... )
• PROPOSED_BY ( type: esriFieldTypeString, alias: Proposed By, length: 50 , Coded Values: [Adam Cole: Adam Cole] , [Cecilia Yii-McAnally: Cecilia Yii-McAnally] , [Justin Carter: Justin Carter] , ...8 more... )
• PROPOSAL_DATE ( type: esriFieldTypeDate, alias: Proposal Date, length: 8 )
• PROP_REMARKS ( type: esriFieldTypeString, alias: Proposal Remarks, length: 300 )
• APPROVED ( type: esriFieldTypeString, alias: Approved, length: 10 , Coded Values: [Yes: Yes] , [No: No] , [Rejected: Rejected] )
• APPROVED_BY ( type: esriFieldTypeString, alias: Approved By, length: 100 , Coded Values: [Randall Tatum: Randall Tatum] )
• APPROVED_DATE ( type: esriFieldTypeDate, alias: Approved Date, length: 8 )
• MAINT_AREA ( type: esriFieldTypeString, alias: AREA OF MAINTENANCE, length: 50 , Coded Values: [1: 1] , [2: 2] , [3: 3] )
• MAINT_DATE ( type: esriFieldTypeDate, alias: DATE OF MAINTENANCE, length: 8 )
• MAINT_ACTION ( type: esriFieldTypeString, alias: Maintenance Action, length: 20 , Coded Values: [A: INSTALLED] , [B: REPLACED] , [C: REMOVED] , ...4 more... )
• MAINT_REASON ( type: esriFieldTypeString, alias: Maintenance Reason, length: 2000 , Coded Values: [1: Leaning] , [2: Defaced] , [3: Non_reflective] , ...5 more... )
• MAINT_CREW_1 ( type: esriFieldTypeString, alias: MAINTENANCE CREW NAME, length: 50 , Coded Values: [Barringer, Tim: Barringer, Tim] , [Benton, Earnest: Benton, Earnest] , [Brooks, Kevin: Brooks, Kevin] , ...19 more... )
• MAINT_CREW_2 ( type: esriFieldTypeString, alias: 2ND MAINT CREW NAME, length: 50 , Coded Values: [Barringer, Tim: Barringer, Tim] , [Benton, Earnest: Benton, Earnest] , [Brooks, Kevin: Brooks, Kevin] , ...19 more... )
• MAINT_ACTION_FIELD ( type: esriFieldTypeString, alias: Field Maintenance Action, length: 20 , Coded Values: [B: REPLACED] , [D: STRAIGHTENED] , [E: TRIMMED LIMBS] , ...1 more... )
• STANCHIONAGE ( type: esriFieldTypeString, alias: Structure, length: 20 , Coded Values: [Cantilever: Cantilever] , [Lt Pole (C): Concrete Light Pole] , [Lt Pole (M): Metal Light Pole] , ...13 more... )
• STANCHIONSUSED ( type: esriFieldTypeInteger, alias: No. of Structure used , Coded Values: [0: Min value] , [20: Max value] )
• NO_SIGNS ( type: esriFieldTypeSmallInteger, alias: NO_SIGNS )
• NO_SIGNS2 ( type: esriFieldTypeSmallInteger, alias: NO_SIGNS2 , Coded Values: [0: Min value] , [6: Max value] )
• NO_SIGNS3 ( type: esriFieldTypeSmallInteger, alias: NO_SIGNS3 , Coded Values: [0: Min value] , [6: Max value] )
• SIGN_USED ( type: esriFieldTypeString, alias: SIGN_USED, length: 10 , Coded Values: [NEW: NEW] , [SAME: SAME] )
• SIGN_USED2 ( type: esriFieldTypeString, alias: SIGN_USED2, length: 10 , Coded Values: [NEW: NEW] , [SAME: SAME] )
• SIGN_USED3 ( type: esriFieldTypeString, alias: SIGN_USED3, length: 10 , Coded Values: [NEW: NEW] , [SAME: SAME] )
• CODE_DISTRICT ( type: esriFieldTypeSmallInteger, alias: Code District , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...4 more... )
• 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 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• ASSET_GUID ( type: esriFieldTypeGUID, alias: ASSET_GUID, length: 38 )
• Cross_Street ( type: esriFieldTypeString, alias: Cross_Street, length: 50 )
• STRUCTYPE ( type: esriFieldTypeString, alias: STRUCTYPE, length: 255 , Coded Values: [2lb Stanchion: 2lb Stanchion] , [3lb Stanchion: 3lb Stanchion] , [Cantilever: Cantilever] , ...9 more... )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )
• OLD_OBJECTID ( type: esriFieldTypeInteger, alias: OLD_OBJECTID )
• APPROX_DISTANCE ( type: esriFieldTypeString, alias: APPROX_DISTANCE, length: 20 )
• Transfer ( type: esriFieldTypeString, alias: Is Transferring, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• Transfer_Dept ( type: esriFieldTypeString, alias: Transferring To, length: 150 , Coded Values: [311: 311] , [Animal Shelter: Animal Shelter] , [CE Commercial: CE Commercial] , ...23 more... )
• Transfer_Notes ( type: esriFieldTypeString, alias: Transfer Justification, length: 2000 )
• Number_Closing_Pics_Taken ( type: esriFieldTypeSmallInteger, alias: Number Closing Pics Taken , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...2 more... )

Types:

ID: 16747
Name: EN-Maintain Markings
Domains:
• REC_EDIT_MODE:
  Inherited
• REQUEST_STATUS:
  Inherited
• REQUEST_PRIORITY:
  Inherited
• NOTIFICATION:
  Inherited
• QAQC_YESNO:
  Inherited
• QAQC_RATING:
  Inherited
• SUPERVISOR_APPROVAL:
  Inherited
• RESOLUTION_CODE:
  Coded Values: [ENMISC: Issue has been resolved.] , [ENSM2REP2: Markings will be replaced] , [ENSM2REP1: Markings have been replaced.] , ...3 more...
• MAP_PG:
  Inherited
• MAP_BLK:
  Inherited
• GRID_NO:
  Inherited
• CODE_SUBDISTRICT:
  Inherited
• TARGET_BLOCK:
  Inherited
• SWM_AREA:
  Inherited
• SWM_ZONE:
  Inherited
• COLLECTION_DAY:
  Inherited
• MLGW_STATUS:
  Inherited
• SWF_RATE:
  Inherited
• SWF_STATUS:
  Inherited
• SIGN_TYPE:
  Inherited
• SIGN_STATUS:
  Coded Values: [1: Active] , [2: Deleted] , [3: Proposed]
• SIGNCONDITION:
  Inherited
• SIGN_OWNER:
  Inherited
• REGULATORYTYPE:
  Inherited
• TRAFFIC_DIRECTION:
  Inherited
• SIDEOFSTREET:
  Inherited
• STREETCLASS:
  Inherited
• DEAD_END:
  Inherited
• APPROX_DISTANCE_FROM:
  Inherited
• PROPOSED_BY:
  Inherited
• APPROVED:
  Inherited
• APPROVED_BY:
  Inherited
• MAINT_AREA:
  Inherited
• MAINT_ACTION:
  Inherited
• MAINT_REASON:
  Inherited
• MAINT_CREW_1:
  Inherited
• MAINT_CREW_2:
  Inherited
• MAINT_ACTION_FIELD:
  Inherited
• STANCHIONAGE:
  Inherited
• STANCHIONSUSED:
  Inherited
• NO_SIGNS:
  Coded Values: [0: Min value] , [6: Max value]
• NO_SIGNS2:
  Inherited
• NO_SIGNS3:
  Inherited
• SIGN_USED:
  Inherited
• SIGN_USED2:
  Inherited
• SIGN_USED3:
  Inherited
• CODE_DISTRICT:
  Inherited
• Transfer_Dept:
  Inherited

---

ID: 10370
Name: EN-Maintain Signs
Domains:
• REC_EDIT_MODE:
  Inherited
• REQUEST_STATUS:
  Inherited
• REQUEST_PRIORITY:
  Inherited
• NOTIFICATION:
  Inherited
• QAQC_YESNO:
  Inherited
• QAQC_RATING:
  Inherited
• SUPERVISOR_APPROVAL:
  Inherited
• RESOLUTION_CODE:
  Coded Values: [ENROW2: Please See Resolution Summary] , [ENMISC: Issue has been resolved.] , [OTHER: Please see Resolution Summary] , ...1 more...
• MAP_PG:
  Inherited
• MAP_BLK:
  Inherited
• GRID_NO:
  Inherited
• CODE_SUBDISTRICT:
  Inherited
• TARGET_BLOCK:
  Inherited
• SWM_AREA:
  Inherited
• SWM_ZONE:
  Inherited
• COLLECTION_DAY:
  Inherited
• MLGW_STATUS:
  Inherited
• SWF_RATE:
  Inherited
• SWF_STATUS:
  Inherited
• SIGN_TYPE:
  Inherited
• SIGN_STATUS:
  Coded Values: [1: Active] , [2: Deleted] , [3: Proposed]
• SIGNCONDITION:
  Inherited
• SIGN_OWNER:
  Inherited
• REGULATORYTYPE:
  Inherited
• TRAFFIC_DIRECTION:
  Inherited
• SIDEOFSTREET:
  Inherited
• STREETCLASS:
  Inherited
• DEAD_END:
  Inherited
• APPROX_DISTANCE_FROM:
  Inherited
• PROPOSED_BY:
  Inherited
• APPROVED:
  Inherited
• APPROVED_BY:
  Inherited
• MAINT_AREA:
  Inherited
• MAINT_ACTION:
  Inherited
• MAINT_REASON:
  Inherited
• MAINT_CREW_1:
  Inherited
• MAINT_CREW_2:
  Inherited
• MAINT_ACTION_FIELD:
  Inherited
• STANCHIONAGE:
  Inherited
• STANCHIONSUSED:
  Inherited
• NO_SIGNS:
  Coded Values: [0: Min value] , [6: Max value]
• NO_SIGNS2:
  Inherited
• NO_SIGNS3:
  Inherited
• SIGN_USED:
  Inherited
• SIGN_USED2:
  Inherited
• SIGN_USED3:
  Inherited
• CODE_DISTRICT:
  Inherited
• Transfer_Dept:
  Inherited

---

ID: 10368
Name: EN-New Markings
Domains:
• REC_EDIT_MODE:
  Inherited
• REQUEST_STATUS:
  Inherited
• REQUEST_PRIORITY:
  Inherited
• NOTIFICATION:
  Inherited
• QAQC_YESNO:
  Inherited
• QAQC_RATING:
  Inherited
• SUPERVISOR_APPROVAL:
  Inherited
• RESOLUTION_CODE:
  Coded Values: [OTHER: Please see Resolution Summary] , [ENMISC: Issue has been resolved.] , [TDOT - ROUTE: This street is maintained by the state through TDOT. We will pass this issue along to the local TDOT maintenance staff. To report directly to TDOT, call 901-684.5467.] , ...1 more...
• MAP_PG:
  Inherited
• MAP_BLK:
  Inherited
• GRID_NO:
  Inherited
• CODE_SUBDISTRICT:
  Inherited
• TARGET_BLOCK:
  Inherited
• SWM_AREA:
  Inherited
• SWM_ZONE:
  Inherited
• COLLECTION_DAY:
  Inherited
• MLGW_STATUS:
  Inherited
• SWF_RATE:
  Inherited
• SWF_STATUS:
  Inherited
• SIGN_TYPE:
  Inherited
• SIGN_STATUS:
  Coded Values: [1: Active] , [2: Deleted] , [3: Proposed]
• SIGNCONDITION:
  Inherited
• SIGN_OWNER:
  Inherited
• REGULATORYTYPE:
  Inherited
• TRAFFIC_DIRECTION:
  Inherited
• SIDEOFSTREET:
  Inherited
• STREETCLASS:
  Inherited
• DEAD_END:
  Inherited
• APPROX_DISTANCE_FROM:
  Inherited
• PROPOSED_BY:
  Inherited
• APPROVED:
  Inherited
• APPROVED_BY:
  Inherited
• MAINT_AREA:
  Inherited
• MAINT_ACTION:
  Inherited
• MAINT_REASON:
  Inherited
• MAINT_CREW_1:
  Inherited
• MAINT_CREW_2:
  Inherited
• MAINT_ACTION_FIELD:
  Inherited
• STANCHIONAGE:
  Inherited
• STANCHIONSUSED:
  Inherited
• NO_SIGNS:
  Coded Values: [0: Min value] , [6: Max value]
• NO_SIGNS2:
  Inherited
• NO_SIGNS3:
  Inherited
• SIGN_USED:
  Inherited
• SIGN_USED2:
  Inherited
• SIGN_USED3:
  Inherited
• CODE_DISTRICT:
  Inherited
• Transfer_Dept:
  Inherited

---

ID: 10367
Name: EN-New Signs
Domains:
• REC_EDIT_MODE:
  Inherited
• REQUEST_STATUS:
  Inherited
• REQUEST_PRIORITY:
  Inherited
• NOTIFICATION:
  Inherited
• QAQC_YESNO:
  Inherited
• QAQC_RATING:
  Inherited
• SUPERVISOR_APPROVAL:
  Inherited
• RESOLUTION_CODE:
  Coded Values: [ENROW2: Please See Resolution Summary] , [OTHER: Please see Resolution Summary] , [ENMISC: Issue has been resolved.]
• MAP_PG:
  Inherited
• MAP_BLK:
  Inherited
• GRID_NO:
  Inherited
• CODE_SUBDISTRICT:
  Inherited
• TARGET_BLOCK:
  Inherited
• SWM_AREA:
  Inherited
• SWM_ZONE:
  Inherited
• COLLECTION_DAY:
  Inherited
• MLGW_STATUS:
  Inherited
• SWF_RATE:
  Inherited
• SWF_STATUS:
  Inherited
• SIGN_TYPE:
  Inherited
• SIGN_STATUS:
  Coded Values: [1: Active] , [2: Deleted] , [3: Proposed]
• SIGNCONDITION:
  Inherited
• SIGN_OWNER:
  Inherited
• REGULATORYTYPE:
  Inherited
• TRAFFIC_DIRECTION:
  Inherited
• SIDEOFSTREET:
  Inherited
• STREETCLASS:
  Inherited
• DEAD_END:
  Inherited
• APPROX_DISTANCE_FROM:
  Inherited
• PROPOSED_BY:
  Inherited
• APPROVED:
  Inherited
• APPROVED_BY:
  Inherited
• MAINT_AREA:
  Inherited
• MAINT_ACTION:
  Inherited
• MAINT_REASON:
  Inherited
• MAINT_CREW_1:
  Inherited
• MAINT_CREW_2:
  Inherited
• MAINT_ACTION_FIELD:
  Inherited
• STANCHIONAGE:
  Inherited
• STANCHIONSUSED:
  Inherited
• NO_SIGNS:
  Coded Values: [0: Min value] , [6: Max value]
• NO_SIGNS2:
  Inherited
• NO_SIGNS3:
  Inherited
• SIGN_USED:
  Inherited
• SIGN_USED2:
  Inherited
• SIGN_USED3:
  Inherited
• CODE_DISTRICT:
  Inherited
• Transfer_Dept:
  Inherited

---

ID: 10194
Name: EN-Traffic Sign Obstruction
Domains:
• REC_EDIT_MODE:
  Inherited
• REQUEST_STATUS:
  Inherited
• REQUEST_PRIORITY:
  Inherited
• NOTIFICATION:
  Inherited
• QAQC_YESNO:
  Inherited
• QAQC_RATING:
  Inherited
• SUPERVISOR_APPROVAL:
  Inherited
• RESOLUTION_CODE:
  Coded Values: [ENROW2: Please See Resolution Summary] , [OTHER: Please see Resolution Summary] , [ENMISC: Issue has been resolved.]
• MAP_PG:
  Inherited
• MAP_BLK:
  Inherited
• GRID_NO:
  Inherited
• CODE_SUBDISTRICT:
  Inherited
• TARGET_BLOCK:
  Inherited
• SWM_AREA:
  Inherited
• SWM_ZONE:
  Inherited
• COLLECTION_DAY:
  Inherited
• MLGW_STATUS:
  Inherited
• SWF_RATE:
  Inherited
• SWF_STATUS:
  Inherited
• SIGN_TYPE:
  Inherited
• SIGN_STATUS:
  Coded Values: [1: Active] , [2: Deleted] , [3: Proposed]
• SIGNCONDITION:
  Inherited
• SIGN_OWNER:
  Inherited
• REGULATORYTYPE:
  Inherited
• TRAFFIC_DIRECTION:
  Inherited
• SIDEOFSTREET:
  Inherited
• STREETCLASS:
  Inherited
• DEAD_END:
  Inherited
• APPROX_DISTANCE_FROM:
  Inherited
• PROPOSED_BY:
  Inherited
• APPROVED:
  Inherited
• APPROVED_BY:
  Inherited
• MAINT_AREA:
  Inherited
• MAINT_ACTION:
  Inherited
• MAINT_REASON:
  Inherited
• MAINT_CREW_1:
  Inherited
• MAINT_CREW_2:
  Inherited
• MAINT_ACTION_FIELD:
  Inherited
• STANCHIONAGE:
  Inherited
• STANCHIONSUSED:
  Inherited
• NO_SIGNS:
  Coded Values: [0: Min value] , [6: Max value]
• NO_SIGNS2:
  Inherited
• NO_SIGNS3:
  Inherited
• SIGN_USED:
  Inherited
• SIGN_USED2:
  Inherited
• SIGN_USED3:
  Inherited
• CODE_DISTRICT:
  Inherited
• Transfer_Dept:
  Inherited

---

Relationships:

• SR to Asset (7) -- Related To: Service Life Expiring (0)
• SR to Asset (23) -- Related To: All Traffic Signs (9)
• SR to Asset (24) -- Related To: Removed Signs (14)

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

  Iteminfo   Thumbnail   Metadata