Name: Signs

Display Field: SIGNTEXT

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 5000

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 )
• SIGNTEXT ( type: esriFieldTypeString, alias: SIGNTEXT, length: 255 )
• MUTCD ( type: esriFieldTypeString, alias: MUTCD, length: 255 , Coded Values: [d-ns-001: D-NS-001: EVACUATION ROUTE] , [d-ns-002: D-NS-002: STREET NAME WITH D.C. FLAG AND BLOCK #] , [d-ns-004: D-NS-004: DC LAW WORK ZONES] , ...1834 more... )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: Sign ID, length: 38 )
• SIGNNUMBER ( type: esriFieldTypeInteger, alias: SIGNNUMBER )
• SIGNARROWDIRECTION ( type: esriFieldTypeInteger, alias: SignArrowDirection , Coded Values: [1: Left] , [2: Right] , [3: Bi-directional] , ...6 more... )
• ORIGIN_ID ( type: esriFieldTypeString, alias: ORIGIN_ID, length: 500 )
• MANUAL_SEGID ( type: esriFieldTypeString, alias: MANUAL_SEGID, length: 50 )
• SIGNORDER ( type: esriFieldTypeInteger, alias: SIGNORDER )
• SIGNSTATUS ( type: esriFieldTypeInteger, alias: SIGNSTATUS , Coded Values: [1: Active] , [2: Prospective] , [3: Temporarily Out of Service] , ...6 more... )
• ZONE_ID ( type: esriFieldTypeString, alias: ZONE_ID, length: 500 )
• SUPPORTID ( type: esriFieldTypeGUID, alias: SUPPORTID, 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 )
• SIGNFACING ( type: esriFieldTypeString, alias: SIGNFACING, length: 10 , Coded Values: [N: N] , [S: S] , [E: E] , ...5 more... )
• SIGNCODE ( type: esriFieldTypeString, alias: SIGNCODE, length: 255 )
• SIGNWORKS_CREATED_BY ( type: esriFieldTypeString, alias: SIGNWORKS_CREATED_BY, length: 100 )
• SIGNWORKS_LAST_EDITED_BY ( type: esriFieldTypeString, alias: SIGNWORKS_LAST_EDITED_BY, length: 100 )
• SIGNSIZE ( type: esriFieldTypeString, alias: SIGNSIZE, length: 150 )
• STREETNAME ( type: esriFieldTypeString, alias: STREETNAME, length: 255 )
• COMMENTS ( type: esriFieldTypeString, alias: COMMENTS, length: 500 )
• ROUTEID_ALT ( type: esriFieldTypeString, alias: ROUTEID_ALT, length: 50 )
• MEASURE_ALT ( type: esriFieldTypeDouble, alias: MEASURE_ALT )
• SIDE_ALT ( type: esriFieldTypeSmallInteger, alias: SIDE_ALT )
• BLOCKID_ALT ( type: esriFieldTypeString, alias: BLOCKID_ALT, length: 500 )
• BLOCKKEY_ALT ( type: esriFieldTypeString, alias: BLOCKKEY_ALT, length: 500 )
• BLOCKFACEKEY_ALT ( type: esriFieldTypeString, alias: BLOCKFACEKEY_ALT, length: 500 )
• SUBBLOCKID_ALT ( type: esriFieldTypeString, alias: SUBBLOCKID_ALT, length: 500 )
• SUBBLOCKKEY_ALT ( type: esriFieldTypeString, alias: SUBBLOCKKEY_ALT, length: 500 )
• PARKMOBILENUMBER ( type: esriFieldTypeString, alias: PARKMOBILENUMBER, length: 10 )
• RDPP ( type: esriFieldTypeString, alias: RDPP, length: 10 )
• VAL_USER ( type: esriFieldTypeString, alias: VAL_USER, length: 255 )
• VAL_DATE ( type: esriFieldTypeDate, alias: VAL_DATE, length: 8 )
• VAL_CODE ( type: esriFieldTypeSmallInteger, alias: VAL_CODE )

Relationships:

• TimeBands (2) -- Related To: TimeBands (7)
• SignSupports (0) -- Related To: SignSupports (0)

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

  Iteminfo   Thumbnail   Metadata