Name: Traffic Signs
Display Field: AssetID
Type: Table
Geometry Type: N/A
Description:
Service Item Id: e6324241cb974aa89b2507ef4eb903ce
Copyright Text:
Default Visibility: false
MaxRecordCount: 2000
Supported Query Formats: JSON, geoJSON, PBF
Supports Advanced Queries: true
Supports Statistics: true
Use Standardized Queries: true
Supports ValidateSQL: true
Supports Calculate: true
Extent:
Drawing 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: true
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: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true
HasZ: false
HasM: false
Has Attachments: true
HTML Popup Type: esriServerHTMLPopupTypeNone
Type ID Field: SignType
Fields:
-
OBJECTID
(
type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID
)
-
AssetID
(
type: esriFieldTypeString, alias: AssetID, editable: true, nullable: true, length: 30, defaultValue: null, modelName: AssetID
)
-
Pole_AssetID
(
type: esriFieldTypeString, alias: Pole AssetID, editable: true, nullable: true, length: 30, defaultValue: null, modelName: Pole_AssetID
)
-
InstallDate
(
type: esriFieldTypeDate, alias: Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InstallDate
)
-
SignType
(
type: esriFieldTypeSmallInteger, alias: Sign Type, editable: true, nullable: true, defaultValue: 1, modelName: SignType
, Coded Values:
[1: Regulatory]
, [2: Warning]
, [3: Service]
, ...7 more...
)
-
SignCode
(
type: esriFieldTypeString, alias: Sign Code, editable: true, nullable: true, length: 75, defaultValue: null, modelName: SignCode
, Coded Values:
[NTSRA: No Turn on Steady Red Arrow (NTSRA)]
, [R1-1: Stop (R1-1)]
, [R1-2: Yield (R1-2)]
, ...88 more...
)
-
SignSize
(
type: esriFieldTypeString, alias: Sign Size, editable: true, nullable: true, length: 15, defaultValue: null, modelName: SignSize
, Coded Values:
[12" x 12": 12" x 12"]
, [12" x 18": 12" x 18"]
, [12" x 24": 12" x 24"]
, ...49 more...
)
-
FacingDirection
(
type: esriFieldTypeString, alias: Facing Direction, editable: true, nullable: true, length: 10, defaultValue: null, modelName: FacingDirection
, Coded Values:
[East: East]
, [North: North]
, [South: South]
, ...5 more...
)
-
SheetingType
(
type: esriFieldTypeString, alias: Sheeting Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SheetingType
, Coded Values:
[Type I: Type I (Engineer Grade)]
, [Type II: Type II (Super Engineer Grade)]
, [Type IV: Type IV (H.I.P.)]
, ...3 more...
)
-
SpeedLimit
(
type: esriFieldTypeSmallInteger, alias: SpeedLimit, editable: true, nullable: true, defaultValue: null, modelName: SpeedLimit
, Coded Values:
[15: 15]
, [20: 20]
, [25: 25]
, ...7 more...
)
-
Comments
(
type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 150, defaultValue: null, modelName: Comments
)
-
LastUpdate
(
type: esriFieldTypeDate, alias: LastUpdate, editable: false, nullable: true, length: 8, defaultValue: null, modelName: LastUpdate
)
-
LastEditor
(
type: esriFieldTypeString, alias: LastEditor, editable: false, nullable: true, length: 50, defaultValue: null, modelName: LastEditor
)
-
Reloc_Reinst
(
type: esriFieldTypeDate, alias: Relocation/Reinstallation Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Reloc_Reinst
)
-
OwnedBy
(
type: esriFieldTypeSmallInteger, alias: Owned By, editable: true, nullable: true, defaultValue: null, modelName: OwnedBy
, Coded Values:
[1: Tyler]
, [2: Smith County]
, [3: TxDot]
, ...3 more...
)
-
ManagedBy
(
type: esriFieldTypeSmallInteger, alias: Managed By, editable: true, nullable: true, defaultValue: null, modelName: ManagedBy
, Coded Values:
[1: Our Agency]
, [-1: Private]
, [-2: Other]
, ...6 more...
)
-
GlobalID
(
type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID
)
-
Illumination_Type
(
type: esriFieldTypeString, alias: Illumination_Type, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Illumination_Type
, Coded Values:
[None: None]
, [LED: LED]
, [Flourescent: Flourescent]
)
Types:
ID: 1
Name: Regulatory
Domains:
-
SignCode:
Inherited
-
SignSize:
Inherited
-
FacingDirection:
Coded Values:
[East: East]
, [North: North]
, [South: South]
, ...5 more...
-
SheetingType:
Inherited
-
SpeedLimit:
Inherited
Templates:
-
Name: Regulatory
Description:
Prototype:
InstallDate: null
Illumination_Type: null
AssetID: null
Pole_AssetID: null
SignType: 1
SignCode: null
SignSize: null
FacingDirection: null
SheetingType: null
SpeedLimit: null
Comments: null
ManagedBy: null
OwnedBy: null
Reloc_Reinst: null
Drawing Tool: esriFeatureEditToolNone
ID: 2
Name: Warning
Domains:
-
SignCode:
Coded Values:
[Motorcycle: Motorcycle (N/A)]
, [SDWR: Slow Down on Wet Road (N/A)]
, [TexPav: Textured Pavement (N/A)
Textured Pavement (N/A)]
, ...78 more...
-
SignSize:
Inherited
-
FacingDirection:
Coded Values:
[East: East]
, [North: North]
, [South: South]
, ...5 more...
-
SheetingType:
Inherited
-
SpeedLimit:
Inherited
Templates:
-
Name: Warning
Description:
Prototype:
InstallDate: null
Illumination_Type: null
AssetID: null
Pole_AssetID: null
SignType: 2
SignCode: null
SignSize: null
FacingDirection: null
SheetingType: null
SpeedLimit: null
Comments: null
ManagedBy: null
OwnedBy: null
Reloc_Reinst: null
Drawing Tool: esriFeatureEditToolNone
ID: 3
Name: Service
Domains:
-
SignCode:
Coded Values:
[AAP: Adopt-A-Park (N/A)]
, [AASp: Adopt-A-Spot (N/A)]
, [AASt: Adopt-A-Street (N/A)]
, ...19 more...
-
SignSize:
Inherited
-
FacingDirection:
Coded Values:
[East: East]
, [North: North]
, [South: South]
, ...5 more...
-
SheetingType:
Inherited
-
SpeedLimit:
Inherited
Templates:
-
Name: Service
Description:
Prototype:
InstallDate: null
Illumination_Type: null
AssetID: null
Pole_AssetID: null
SignType: 3
SignCode: null
SignSize: null
FacingDirection: null
SheetingType: null
SpeedLimit: null
Comments: null
ManagedBy: null
OwnedBy: null
Reloc_Reinst: null
Drawing Tool: esriFeatureEditToolNone
ID: 4
Name: Tourist
Domains:
-
SignCode:
Coded Values:
[AAP: Adopt-A-Park (N/A)]
, [AASp: Adopt-A-Spot (N/A)]
, [AASt: Adopt-A-Street (N/A)]
, ...19 more...
-
SignSize:
Inherited
-
FacingDirection:
Coded Values:
[East: East]
, [North: North]
, [South: South]
, ...5 more...
-
SheetingType:
Inherited
-
SpeedLimit:
Inherited
Templates:
-
Name: Tourist
Description:
Prototype:
InstallDate: null
Illumination_Type: null
AssetID: null
Pole_AssetID: null
SignType: 4
SignCode: null
SignSize: null
FacingDirection: null
SheetingType: null
SpeedLimit: null
Comments: null
ManagedBy: null
OwnedBy: null
Reloc_Reinst: null
Drawing Tool: esriFeatureEditToolNone
ID: 5
Name: Guide
Domains:
-
SignCode:
Coded Values:
[AAP: Adopt-A-Park (N/A)]
, [AASp: Adopt-A-Spot (N/A)]
, [AASt: Adopt-A-Street (N/A)]
, ...19 more...
-
SignSize:
Inherited
-
FacingDirection:
Coded Values:
[East: East]
, [North: North]
, [South: South]
, ...5 more...
-
SheetingType:
Inherited
-
SpeedLimit:
Inherited
Templates:
-
Name: Guide
Description:
Prototype:
InstallDate: null
Illumination_Type: null
AssetID: null
Pole_AssetID: null
SignType: 5
SignCode: null
SignSize: null
FacingDirection: null
SheetingType: null
SpeedLimit: null
Comments: null
ManagedBy: null
OwnedBy: null
Reloc_Reinst: null
Drawing Tool: esriFeatureEditToolNone
ID: 6
Name: Recreational
Domains:
-
SignCode:
Coded Values:
[Azalea: Azalea]
, [Brick Streets: Brick Streets]
, [BSV: Brick Street Village]
, ...10 more...
-
SignSize:
Inherited
-
FacingDirection:
Coded Values:
[East: East]
, [North: North]
, [South: South]
, ...5 more...
-
SheetingType:
Inherited
-
SpeedLimit:
Inherited
Templates:
-
Name: Recreational
Description:
Prototype:
InstallDate: null
Illumination_Type: null
AssetID: null
Pole_AssetID: null
SignType: 6
SignCode: null
SignSize: null
FacingDirection: null
SheetingType: null
SpeedLimit: null
Comments: null
ManagedBy: null
OwnedBy: null
Reloc_Reinst: null
Drawing Tool: esriFeatureEditToolNone
ID: 7
Name: Cultural
Domains:
-
SignCode:
Coded Values:
[Azalea: Azalea]
, [Brick Streets: Brick Streets]
, [BSV: Brick Street Village]
, ...10 more...
-
SignSize:
Inherited
-
FacingDirection:
Coded Values:
[East: East]
, [North: North]
, [South: South]
, ...5 more...
-
SheetingType:
Inherited
-
SpeedLimit:
Inherited
Templates:
-
Name: Cultural
Description:
Prototype:
InstallDate: null
Illumination_Type: null
AssetID: null
Pole_AssetID: null
SignType: 7
SignCode: null
SignSize: null
FacingDirection: null
SheetingType: null
SpeedLimit: null
Comments: null
ManagedBy: null
OwnedBy: null
Reloc_Reinst: null
Drawing Tool: esriFeatureEditToolNone
ID: 8
Name: Historical
Domains:
-
SignCode:
Coded Values:
[Azalea: Azalea]
, [Brick Streets: Brick Streets]
, [BSV: Brick Street Village]
, ...10 more...
-
SignSize:
Inherited
-
FacingDirection:
Coded Values:
[East: East]
, [North: North]
, [South: South]
, ...5 more...
-
SheetingType:
Inherited
-
SpeedLimit:
Inherited
Templates:
-
Name: Historical
Description:
Prototype:
InstallDate: null
Illumination_Type: null
AssetID: null
Pole_AssetID: null
SignType: 8
SignCode: null
SignSize: null
FacingDirection: null
SheetingType: null
SpeedLimit: null
Comments: null
ManagedBy: null
OwnedBy: null
Reloc_Reinst: null
Drawing Tool: esriFeatureEditToolNone
ID: 9
Name: School
Domains:
-
SignCode:
Coded Values:
[S1-1: School Crossing (S1-1)]
, [S3-1: School Bus Stop Ahead (S3-1)]
, [S4-3P: School (plaque) (S4-3P)]
, ...5 more...
-
SignSize:
Inherited
-
FacingDirection:
Coded Values:
[East: East]
, [North: North]
, [South: South]
, ...5 more...
-
SheetingType:
Inherited
-
SpeedLimit:
Inherited
Templates:
-
Name: School
Description:
Prototype:
InstallDate: null
Illumination_Type: null
AssetID: null
Pole_AssetID: null
SignType: 9
SignCode: null
SignSize: null
FacingDirection: null
SheetingType: null
SpeedLimit: null
Comments: null
ManagedBy: null
OwnedBy: null
Reloc_Reinst: null
Drawing Tool: esriFeatureEditToolNone
ID: 10
Name: Object Markers
Domains:
-
SignCode:
Coded Values:
[OM3-C: Type 3 Center (OM3-C)]
, [OM3-L: Type 3 Left (OM3-L)]
, [OM3-R: Type 3 Right (OM3-R)]
, ...2 more...
-
SignSize:
Inherited
-
FacingDirection:
Coded Values:
[East: East]
, [North: North]
, [South: South]
, ...5 more...
-
SheetingType:
Inherited
-
SpeedLimit:
Inherited
Templates:
-
Name: Object Markers
Description:
Prototype:
InstallDate: null
Illumination_Type: null
AssetID: null
Pole_AssetID: null
SignType: 10
SignCode: null
SignSize: null
FacingDirection: null
SheetingType: null
SpeedLimit: null
Comments: null
ManagedBy: null
OwnedBy: null
Reloc_Reinst: null
Drawing Tool: esriFeatureEditToolNone
Relationships:
Capabilities: Query,Create,Update,Delete,Uploads,Editing
Sync Can Return Changes: true
Is Data Versioned: true
Supports Rollback On Failure: false
Supports ApplyEdits With Global Ids: false
Supports ApplyEdits By Upload Id: true
Edit Fields Info:
- Creation Date Field:
- Creator Field:
- Edit Date Field: LastUpdate
- Editor Field: LastEditor
Supports Query With Historic Moment: false
Supports Coordinates Quantization: false
Child Resources:
Field Groups
  
Contingent Values
Supported Operations:
Query
Query Attachments
Query Analytic
Query Related Records
Apply Edits
Add Features
Update Features
Delete Features
Calculate
Validate SQL
Generate Renderer
Return Updates
Iteminfo
Thumbnail
Metadata
Update Metadata