Name: SuffolkGIS.DBO.TrSigns

Display Field: STREETNAME

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 961d18db3fd94eafbebc77dd866f6d40

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON

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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• ASSETID ( type: esriFieldTypeString, alias: ASSETID, length: 20 )
• PWZONE ( type: esriFieldTypeString, alias: PWZONE, length: 60 )
• LOCATION ( type: esriFieldTypeString, alias: LOCATION, length: 60 )
• INSTALLDATE ( type: esriFieldTypeDate, alias: INSTALLDATE, length: 8 )
• MUTCD ( type: esriFieldTypeString, alias: MUTCD, length: 20 , Coded Values: [R1-1: Stop] , [R1-2: Yield] , [R1-3: 4-Way] , ...282 more... )
• SIGNTEXT ( type: esriFieldTypeString, alias: SIGNTEXT, length: 50 )
• SIGNCOLOR ( type: esriFieldTypeString, alias: SIGNCOLOR, length: 20 , Coded Values: [BLK: Black] , [BLU: Blue] , [BRN: Brown] , ...6 more... )
• LEGENDCOLOR ( type: esriFieldTypeString, alias: LEGENDCOLOR, length: 60 , Coded Values: [BLK: Black] , [BLU: Blue] , [BRN: Brown] , ...6 more... )
• FACEDIRECTION ( type: esriFieldTypeString, alias: FACEDIRECTION, length: 20 , Coded Values: [N: North] , [S: South] , [E: East] , ...5 more... )
• HIEGHT ( type: esriFieldTypeInteger, alias: HIEGHT )
• WIDTH ( type: esriFieldTypeInteger, alias: WIDTH )
• POLEID ( type: esriFieldTypeString, alias: POLEID, length: 30 )
• MOUNTTYPE ( type: esriFieldTypeString, alias: MountType, length: 20 , Coded Values: [BRIDGE: Bridge/Overpass] , [BUILDING: Building/Structure] , [OVERHEAD: Overhead] , ...2 more... )
• CONDITION ( type: esriFieldTypeString, alias: Condition, length: 20 , Coded Values: [G: Good] , [F: Fair] , [P: Poor] )
• NORTHING ( type: esriFieldTypeDouble, alias: NORTHING )
• EASTING ( type: esriFieldTypeDouble, alias: EASTING )
• BREAKAWAY ( type: esriFieldTypeSmallInteger, alias: Breakaway , Coded Values: [1: True] , [0: False] )
• FACILITYID ( type: esriFieldTypeString, alias: FACILITYID, length: 40 )
• SESSIONID ( type: esriFieldTypeString, alias: SESSIONID, length: 50 )
• LRID ( type: esriFieldTypeString, alias: LRID, length: 50 )
• STREETNAME ( type: esriFieldTypeString, alias: STREETNAME, length: 255 )
• TRAFFICDIR ( type: esriFieldTypeString, alias: TRAFFICDIR, length: 50 )
• SIDE ( type: esriFieldTypeString, alias: SIDE, length: 50 )
• CAPMETHOD ( type: esriFieldTypeSmallInteger, alias: CAPMETHOD )
• MODIFYDATE ( type: esriFieldTypeDate, alias: MODIFYDATE, length: 8 )
• FROMMILE ( type: esriFieldTypeDouble, alias: FROMMILE )
• IMAGESEQ ( type: esriFieldTypeInteger, alias: IMAGESEQ )
• LATITUDE ( type: esriFieldTypeDouble, alias: LATITUDE )
• LONGITUDE ( type: esriFieldTypeDouble, alias: LONGITUDE )
• X ( type: esriFieldTypeDouble, alias: X )
• Y ( type: esriFieldTypeDouble, alias: Y )
• OFFSET ( type: esriFieldTypeDouble, alias: OFFSET )
• IMGNAME ( type: esriFieldTypeString, alias: IMGNAME, length: 255 )
• CAMINDEX ( type: esriFieldTypeInteger, alias: CAMINDEX )
• FACEDIR ( type: esriFieldTypeDouble, alias: FACEDIR )
• HEADING ( type: esriFieldTypeDouble, alias: HEADING )

Supported Operations:   Query   Query Attachments   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata