Name: ARCGIS.SDE.Signs
Display Field: StreetName
Type: Table
Geometry Type: N/A
Description: null
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:
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
)
-
Pole_ID
(
type: esriFieldTypeString, alias: Pole_ID, length: 10
)
-
SignType
(
type: esriFieldTypeString, alias: SignType, length: 10
, Coded Values:
[Regulatory: Regulatory]
, [Warning: Warning]
, [Guide: Guide]
, ...3 more...
)
-
SignStyle
(
type: esriFieldTypeString, alias: SignStyle, length: 130
, Coded Values:
[R2-1: SPEED LIMIT]
, [R1-1: STOP]
, [R1-4: MULTIWAY STOP (FOR R 1-1) (ALLWAY)]
, ...118 more...
)
-
StreetName
(
type: esriFieldTypeString, alias: Street Name, length: 50
, Coded Values:
[AARON: AARON]
, [ADAMS: ADAMS]
, [ADOBE: ADOBE]
, ...390 more...
)
-
StreetType
(
type: esriFieldTypeString, alias: Street Type, length: 5
, Coded Values:
[AVE: AVENUE]
, [BLVD: BOULEVARD]
, [CIR: CIRCLE]
, ...13 more...
)
-
BlockNum
(
type: esriFieldTypeInteger, alias: Block Num
)
-
SignText
(
type: esriFieldTypeString, alias: SignText, length: 100
)
-
Facing
(
type: esriFieldTypeString, alias: Facing, length: 30
, Coded Values:
[N: North]
, [S: South]
, [E: East]
, ...9 more...
)
-
WidthHeight
(
type: esriFieldTypeString, alias: Width x Height, length: 8
, Coded Values:
[42x12: 42x12]
, [36x12: 36x12]
, [36x36: 36x36]
, ...17 more...
)
-
Height
(
type: esriFieldTypeDouble, alias: Vertical Clearance
)
-
HorizClear
(
type: esriFieldTypeString, alias: Horiz Clearance, length: 15
)
-
HorizFrom
(
type: esriFieldTypeString, alias: Horiz From, length: 12
, Coded Values:
[Curb: Curb]
, [Ground: Ground]
, [Street: Street]
)
-
VertFrom
(
type: esriFieldTypeString, alias: Vert From, length: 12
, Coded Values:
[Curb: Curb]
, [Ground: Ground]
, [Street: Street]
)
-
Angle
(
type: esriFieldTypeSmallInteger, alias: Angle
)
-
Sheeting
(
type: esriFieldTypeString, alias: Sheeting, length: 50
, Coded Values:
[DG3: DG3]
, [Type I (Engineer Grade): Type I (Engineer Grade)]
, [Type II (Super Engineer Grade): Type II (Super Engineer Grade)]
, ...9 more...
)
-
InstallDate
(
type: esriFieldTypeDate, alias: Install Date, length: 8
)
-
InspectionDate
(
type: esriFieldTypeDate, alias: Inspection Date, length: 8
)
-
Condition
(
type: esriFieldTypeString, alias: Condition, length: 10
, Coded Values:
[Excellent: Excellent]
, [Very Good: Very Good]
, [Good: Good]
, ...4 more...
)
-
OwnedBy
(
type: esriFieldTypeString, alias: Owned By, length: 7
, Coded Values:
[CITY: CITY]
, [PRIVATE: PRIVATE]
, [OTHER: OTHER]
)
-
ManagedBy
(
type: esriFieldTypeString, alias: Managed By, length: 7
, Coded Values:
[CITY: CITY]
, [PRIVATE: PRIVATE]
, [OTHER: OTHER]
)
-
Notes
(
type: esriFieldTypeString, alias: Notes, length: 150
)
-
LastUpdate
(
type: esriFieldTypeDate, alias: LastUpdate, length: 8
)
-
LastEditor
(
type: esriFieldTypeString, alias: LastEditor, length: 2
, Coded Values:
[AD: Annette Dinkel]
, [RR: Roger Reese]
, [JS: Jennifer Switzer]
)
-
GlobalID
(
type: esriFieldTypeGlobalID, alias: GlobalID, length: 38
)
-
GUID
(
type: esriFieldTypeGUID, alias: GUID, length: 38
)
Supported Operations:
Query
Query Attachments
Generate Renderer
Return Updates
Iteminfo
Thumbnail
Metadata