View In:   ArcGIS Online Map Viewer

Name: esri_sde.DBO.Street_Sign

Display Field: SIGN_IDENTIFIER

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 7d4b0519898842a186553cab773b88d3

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

XMin: 1369450.3414955586
YMin: 445980.5160994828
XMax: 1398609.3740566373
YMax: 493498.1566283107
Spatial Reference: 2893  (2893)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: SIGN_COLOR
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Default Label: <all other values>
UniqueValueInfos:
• Value: Black
  Label: Black
  Description: N/A
  Symbol:
  
• Value: Blue
  Label: Blue
  Description: N/A
  Symbol:
  
• Value: Brown
  Label: Brown
  Description: N/A
  Symbol:
  
• Value: Green
  Label: Green
  Description: N/A
  Symbol:
  
• Value: Lime Green
  Label: Lime Green
  Description: N/A
  Symbol:
  
• Value: Other_Specify
  Label: Other_Specify
  Description: N/A
  Symbol:
  
• Value: Red
  Label: Red
  Description: N/A
  Symbol:
  
• Value: White
  Label: White
  Description: N/A
  Symbol:
  
• Value: Yellow
  Label: Yellow
  Description: N/A
  Symbol:
  
Transparency: 0
Labeling Info:

Feature Draw Order:

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: 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: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: SIGN_COLOR

Fields:

• OBJECTID ( modelName: OBJECTID, nullable: false, editable: false, defaultValue: N/A, alias: OBJECTID, type: esriFieldTypeOID )
• SIGN_IDENTIFIER ( modelName: SIGN_IDENTIFIER, nullable: true, editable: true, defaultValue: N/A, length: 20, alias: SIGN_IDENTIFIER, type: esriFieldTypeString )
• ATTACHED_POLE_ID ( modelName: ATTACHED_POLE_ID, nullable: true, editable: true, defaultValue: N/A, length: 20, alias: ATTACHED_POLE_ID, type: esriFieldTypeString )
• MOUNTING_TYPE ( modelName: MOUNTING_TYPE, nullable: true, editable: true, defaultValue: N/A, length: 50, alias: MOUNTING_TYPE, type: esriFieldTypeString )
• SIGN_POSITION ( modelName: SIGN_POSITION, nullable: true, editable: true, defaultValue: N/A, length: 15, alias: SIGN_POSITION, type: esriFieldTypeString , Coded Values: [First: First] , [Second: Second] , [Third: Third] , ...3 more... )
• SIGN_COND ( modelName: SIGN_COND, nullable: true, editable: true, defaultValue: N/A, length: 35, alias: SIGN_COND, type: esriFieldTypeString , Coded Values: [Excellent: Excellent] , [Good: Good] , [Fair: Fair] , ...3 more... )
• SIGN_COLOR ( modelName: SIGN_COLOR, nullable: true, editable: true, defaultValue: N/A, length: 50, alias: SIGN_COLOR, type: esriFieldTypeString , Coded Values: [Red: Red] , [Green: Green] , [Blue: Blue] , ...6 more... )
• SIGN_TYPE ( modelName: SIGN_TYPE, nullable: true, editable: true, defaultValue: N/A, length: 20, alias: SIGN_TYPE_CLASSIFICATION, type: esriFieldTypeString , Coded Values: [Regulatory: Regulatory] , [School: School] , [Warning: Warning] , ...3 more... )
• SIGN_CODE ( modelName: SIGN_CODE, nullable: true, editable: true, defaultValue: N/A, length: 50, alias: SIGN_CODE, type: esriFieldTypeString , Coded Values: [R1-3: 4 Way] , [W4-3: Added Lane] , [W16-6p: Advance Arrow (Plaque)] , ...121 more... )
• SIGN_TEXT ( modelName: SIGN_TEXT, nullable: true, editable: true, defaultValue: N/A, length: 80, alias: SIGN_TEXT, type: esriFieldTypeString )
• LENGTH ( modelName: LENGTH, nullable: true, editable: true, defaultValue: N/A, alias: LENGTH, type: esriFieldTypeSmallInteger )
• HEIGHT ( modelName: HEIGHT, nullable: true, editable: true, defaultValue: N/A, alias: HEIGHT, type: esriFieldTypeSmallInteger )
• NOTES ( modelName: NOTES, nullable: true, editable: true, defaultValue: N/A, length: 100, alias: NOTES, type: esriFieldTypeString )
• FACING_DIRECTION ( modelName: FACING_DIRECTION, nullable: true, editable: true, defaultValue: N/A, length: 20, alias: FACING_DIRECTION, type: esriFieldTypeString )
• REFLECTIVITY ( modelName: REFLECTIVITY, nullable: true, editable: true, defaultValue: N/A, length: 30, alias: REFLECTIVITY, type: esriFieldTypeString )
• REFLECTIVE_SHEET_TYPE ( modelName: REFLECTIVE_SHEET_TYPE, nullable: true, editable: true, defaultValue: N/A, length: 50, alias: REFLECTIVE_SHEET_TYPE, type: esriFieldTypeString )
• INSTALL_DATE ( modelName: INSTALL_DATE, nullable: true, editable: true, defaultValue: N/A, length: 8, alias: INSTALL_DATE, type: esriFieldTypeDate )
• INSPECTION_DATE ( modelName: INSPECTION_DATE, nullable: true, editable: true, defaultValue: N/A, length: 8, alias: INSPECTION_DATE, type: esriFieldTypeDate )
• INSPECTOR ( modelName: INSPECTOR, nullable: true, editable: true, defaultValue: N/A, length: 30, alias: INSPECTOR, type: esriFieldTypeString )
• OWNED_BY ( modelName: OWNED_BY, nullable: true, editable: true, defaultValue: N/A, length: 20, alias: OWNED_BY, type: esriFieldTypeString , Coded Values: [State: State] , [County: County] , [City: City] , ...1 more... )
• MAINTAINED_BY ( modelName: MAINTAINED_BY, nullable: true, editable: true, defaultValue: N/A, length: 20, alias: MAINTAINED_BY, type: esriFieldTypeString )
• created_user ( modelName: created_user, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: created_user, type: esriFieldTypeString )
• created_date ( modelName: created_date, nullable: true, editable: true, defaultValue: N/A, length: 8, alias: created_date, type: esriFieldTypeDate )
• last_edited_user ( modelName: last_edited_user, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: last_edited_user, type: esriFieldTypeString )
• last_edited_date ( modelName: last_edited_date, nullable: true, editable: true, defaultValue: N/A, length: 8, alias: last_edited_date, type: esriFieldTypeDate )
• LOCATION ( modelName: LOCATION, nullable: true, editable: true, defaultValue: N/A, length: 50, alias: LOCATION, type: esriFieldTypeString )
• LONG_X ( modelName: LONG_X, nullable: true, editable: true, defaultValue: N/A, alias: LONG_X, type: esriFieldTypeDouble )
• LAT_Y ( modelName: LAT_Y, nullable: true, editable: true, defaultValue: N/A, alias: LAT_Y, type: esriFieldTypeDouble )
• GlobalID ( modelName: GlobalID, nullable: false, editable: false, defaultValue: N/A, length: 38, alias: GlobalID, type: esriFieldTypeGlobalID )
• COB_Maintained ( modelName: COB_Maintained, nullable: true, editable: true, defaultValue: N/A, length: 3, alias: COB Maintained, type: esriFieldTypeString )

Types:

ID: Black
Name: Black
Domains:
• SIGN_COND:
  Inherited
• SIGN_TYPE:
  Inherited
• OWNED_BY:
  Inherited
• SIGN_POSITION:
  Inherited
• SIGN_CODE:
  Inherited
• SIGN_COLOR:
  Inherited
Templates:
• Name: Black
  Description:
  Prototype:
  SIGN_TYPE: null
  LOCATION: null
  SIGN_IDENTIFIER: null
  LENGTH: null
  SIGN_COND: null
  OWNED_BY: null
  NOTES: null
  SIGN_TEXT: null
  LAT_Y: null
  INSTALL_DATE: null
  ATTACHED_POLE_ID: null
  last_edited_date: null
  SIGN_CODE: null
  SIGN_COLOR: Black
  REFLECTIVITY: null
  INSPECTOR: null
  SIGN_POSITION: null
  created_user: null
  MAINTAINED_BY: null
  HEIGHT: null
  last_edited_user: null
  FACING_DIRECTION: null
  INSPECTION_DATE: null
  MOUNTING_TYPE: null
  created_date: null
  LONG_X: null
  COB_Maintained: null
  REFLECTIVE_SHEET_TYPE: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Blue
Name: Blue
Domains:
• SIGN_COND:
  Inherited
• SIGN_TYPE:
  Inherited
• OWNED_BY:
  Inherited
• SIGN_POSITION:
  Inherited
• SIGN_CODE:
  Inherited
• SIGN_COLOR:
  Inherited
Templates:
• Name: Blue
  Description:
  Prototype:
  SIGN_TYPE: null
  LOCATION: null
  SIGN_IDENTIFIER: null
  LENGTH: null
  SIGN_COND: null
  OWNED_BY: null
  NOTES: null
  SIGN_TEXT: null
  LAT_Y: null
  INSTALL_DATE: null
  ATTACHED_POLE_ID: null
  last_edited_date: null
  SIGN_CODE: null
  SIGN_COLOR: Blue
  REFLECTIVITY: null
  INSPECTOR: null
  SIGN_POSITION: null
  created_user: null
  MAINTAINED_BY: null
  HEIGHT: null
  last_edited_user: null
  FACING_DIRECTION: null
  INSPECTION_DATE: null
  MOUNTING_TYPE: null
  created_date: null
  LONG_X: null
  COB_Maintained: null
  REFLECTIVE_SHEET_TYPE: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Brown
Name: Brown
Domains:
• SIGN_COND:
  Inherited
• SIGN_TYPE:
  Inherited
• OWNED_BY:
  Inherited
• SIGN_POSITION:
  Inherited
• SIGN_CODE:
  Inherited
• SIGN_COLOR:
  Inherited
Templates:
• Name: Brown
  Description:
  Prototype:
  SIGN_TYPE: null
  LOCATION: null
  SIGN_IDENTIFIER: null
  LENGTH: null
  SIGN_COND: null
  OWNED_BY: null
  NOTES: null
  SIGN_TEXT: null
  LAT_Y: null
  INSTALL_DATE: null
  ATTACHED_POLE_ID: null
  last_edited_date: null
  SIGN_CODE: null
  SIGN_COLOR: Brown
  REFLECTIVITY: null
  INSPECTOR: null
  SIGN_POSITION: null
  created_user: null
  MAINTAINED_BY: null
  HEIGHT: null
  last_edited_user: null
  FACING_DIRECTION: null
  INSPECTION_DATE: null
  MOUNTING_TYPE: null
  created_date: null
  LONG_X: null
  COB_Maintained: null
  REFLECTIVE_SHEET_TYPE: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Green
Name: Green
Domains:
• SIGN_COND:
  Inherited
• SIGN_TYPE:
  Inherited
• OWNED_BY:
  Inherited
• SIGN_POSITION:
  Inherited
• SIGN_CODE:
  Inherited
• SIGN_COLOR:
  Inherited
Templates:
• Name: Green
  Description:
  Prototype:
  SIGN_TYPE: null
  LOCATION: null
  SIGN_IDENTIFIER: null
  LENGTH: null
  SIGN_COND: null
  OWNED_BY: null
  NOTES: null
  SIGN_TEXT: null
  LAT_Y: null
  INSTALL_DATE: null
  ATTACHED_POLE_ID: null
  last_edited_date: null
  SIGN_CODE: null
  SIGN_COLOR: Green
  REFLECTIVITY: null
  INSPECTOR: null
  SIGN_POSITION: null
  created_user: null
  MAINTAINED_BY: null
  HEIGHT: null
  last_edited_user: null
  FACING_DIRECTION: null
  INSPECTION_DATE: null
  MOUNTING_TYPE: null
  created_date: null
  LONG_X: null
  COB_Maintained: null
  REFLECTIVE_SHEET_TYPE: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Lime Green
Name: Lime Green
Domains:
• SIGN_COND:
  Inherited
• SIGN_TYPE:
  Inherited
• OWNED_BY:
  Inherited
• SIGN_POSITION:
  Inherited
• SIGN_CODE:
  Inherited
• SIGN_COLOR:
  Inherited
Templates:
• Name: Lime Green
  Description:
  Prototype:
  SIGN_TYPE: null
  LOCATION: null
  SIGN_IDENTIFIER: null
  LENGTH: null
  SIGN_COND: null
  OWNED_BY: null
  NOTES: null
  SIGN_TEXT: null
  LAT_Y: null
  INSTALL_DATE: null
  ATTACHED_POLE_ID: null
  last_edited_date: null
  SIGN_CODE: null
  SIGN_COLOR: Lime Green
  REFLECTIVITY: null
  INSPECTOR: null
  SIGN_POSITION: null
  created_user: null
  MAINTAINED_BY: null
  HEIGHT: null
  last_edited_user: null
  FACING_DIRECTION: null
  INSPECTION_DATE: null
  MOUNTING_TYPE: null
  created_date: null
  LONG_X: null
  COB_Maintained: null
  REFLECTIVE_SHEET_TYPE: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Other_Specify
Name: Other_Specify
Domains:
• SIGN_COND:
  Inherited
• SIGN_TYPE:
  Inherited
• OWNED_BY:
  Inherited
• SIGN_POSITION:
  Inherited
• SIGN_CODE:
  Inherited
• SIGN_COLOR:
  Inherited
Templates:
• Name: Other_Specify
  Description:
  Prototype:
  SIGN_TYPE: null
  LOCATION: null
  SIGN_IDENTIFIER: null
  LENGTH: null
  SIGN_COND: null
  OWNED_BY: null
  NOTES: null
  SIGN_TEXT: null
  LAT_Y: null
  INSTALL_DATE: null
  ATTACHED_POLE_ID: null
  last_edited_date: null
  SIGN_CODE: null
  SIGN_COLOR: Other_Specify
  REFLECTIVITY: null
  INSPECTOR: null
  SIGN_POSITION: null
  created_user: null
  MAINTAINED_BY: null
  HEIGHT: null
  last_edited_user: null
  FACING_DIRECTION: null
  INSPECTION_DATE: null
  MOUNTING_TYPE: null
  created_date: null
  LONG_X: null
  COB_Maintained: null
  REFLECTIVE_SHEET_TYPE: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Red
Name: Red
Domains:
• SIGN_COND:
  Inherited
• SIGN_TYPE:
  Inherited
• OWNED_BY:
  Inherited
• SIGN_POSITION:
  Inherited
• SIGN_CODE:
  Inherited
• SIGN_COLOR:
  Inherited
Templates:
• Name: Red
  Description:
  Prototype:
  SIGN_TYPE: null
  LOCATION: null
  SIGN_IDENTIFIER: null
  LENGTH: null
  SIGN_COND: null
  OWNED_BY: null
  NOTES: null
  SIGN_TEXT: null
  LAT_Y: null
  INSTALL_DATE: null
  ATTACHED_POLE_ID: null
  last_edited_date: null
  SIGN_CODE: null
  SIGN_COLOR: Red
  REFLECTIVITY: null
  INSPECTOR: null
  SIGN_POSITION: null
  created_user: null
  MAINTAINED_BY: null
  HEIGHT: null
  last_edited_user: null
  FACING_DIRECTION: null
  INSPECTION_DATE: null
  MOUNTING_TYPE: null
  created_date: null
  LONG_X: null
  COB_Maintained: null
  REFLECTIVE_SHEET_TYPE: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: White
Name: White
Domains:
• SIGN_COND:
  Inherited
• SIGN_TYPE:
  Inherited
• OWNED_BY:
  Inherited
• SIGN_POSITION:
  Inherited
• SIGN_CODE:
  Inherited
• SIGN_COLOR:
  Inherited
Templates:
• Name: White
  Description:
  Prototype:
  SIGN_TYPE: null
  LOCATION: null
  SIGN_IDENTIFIER: null
  LENGTH: null
  SIGN_COND: null
  OWNED_BY: null
  NOTES: null
  SIGN_TEXT: null
  LAT_Y: null
  INSTALL_DATE: null
  ATTACHED_POLE_ID: null
  last_edited_date: null
  SIGN_CODE: null
  SIGN_COLOR: White
  REFLECTIVITY: null
  INSPECTOR: null
  SIGN_POSITION: null
  created_user: null
  MAINTAINED_BY: null
  HEIGHT: null
  last_edited_user: null
  FACING_DIRECTION: null
  INSPECTION_DATE: null
  MOUNTING_TYPE: null
  created_date: null
  LONG_X: null
  COB_Maintained: null
  REFLECTIVE_SHEET_TYPE: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Yellow
Name: Yellow
Domains:
• SIGN_COND:
  Inherited
• SIGN_TYPE:
  Inherited
• OWNED_BY:
  Inherited
• SIGN_POSITION:
  Inherited
• SIGN_CODE:
  Inherited
• SIGN_COLOR:
  Inherited
Templates:
• Name: Yellow
  Description:
  Prototype:
  SIGN_TYPE: null
  LOCATION: null
  SIGN_IDENTIFIER: null
  LENGTH: null
  SIGN_COND: null
  OWNED_BY: null
  NOTES: null
  SIGN_TEXT: null
  LAT_Y: null
  INSTALL_DATE: null
  ATTACHED_POLE_ID: null
  last_edited_date: null
  SIGN_CODE: null
  SIGN_COLOR: Yellow
  REFLECTIVITY: null
  INSPECTOR: null
  SIGN_POSITION: null
  created_user: null
  MAINTAINED_BY: null
  HEIGHT: null
  last_edited_user: null
  FACING_DIRECTION: null
  INSPECTION_DATE: null
  MOUNTING_TYPE: null
  created_date: null
  LONG_X: null
  COB_Maintained: null
  REFLECTIVE_SHEET_TYPE: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

Relationships:

• Street_Sign_Maintenance (0) -- Related To: Sign Maintenance (3)
• Related Pole (1) -- Related To: Poles For Street Sign (1)

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 Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:

Supported Operations:   Query   Query Analytic   Query Related Records   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Append   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata