Layers:

Layer: esri_sde.DBO.Street_Sign (0)

Name: esri_sde.DBO.Street_Sign

Display Field: SIGN_IDENTIFIER

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 609a232484a14f9fa1d312348c365570

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

MaxSelectionCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

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: true
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: true
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: N/A

Fields:
• OBJECTID ( nullable: false, alias: OBJECTID, type: esriFieldTypeOID )
• SIGN_IDENTIFIER ( nullable: true, length: 20, alias: SIGN_IDENTIFIER, type: esriFieldTypeString )
• ATTACHED_POLE_ID ( nullable: true, length: 20, alias: ATTACHED_POLE_ID, type: esriFieldTypeString )
• MOUNTING_TYPE ( nullable: true, length: 50, alias: MOUNTING_TYPE, type: esriFieldTypeString )
• SIGN_POSITION ( nullable: true, length: 15, alias: SIGN_POSITION, type: esriFieldTypeString , Coded Values: [First: First] , [Second: Second] , [Third: Third] , ...3 more... )
• SIGN_COND ( nullable: true, length: 35, alias: SIGN_COND, type: esriFieldTypeString , Coded Values: [Excellent: Excellent] , [Good: Good] , [Fair: Fair] , ...3 more... )
• SIGN_COLOR ( nullable: true, length: 50, alias: SIGN_COLOR, type: esriFieldTypeString , Coded Values: [Red: Red] , [Green: Green] , [Blue: Blue] , ...6 more... )
• SIGN_TYPE ( nullable: true, length: 20, alias: SIGN_TYPE_CLASSIFICATION, type: esriFieldTypeString , Coded Values: [Regulatory: Regulatory] , [School: School] , [Warning: Warning] , ...3 more... )
• SIGN_CODE ( nullable: true, 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 ( nullable: true, length: 80, alias: SIGN_TEXT, type: esriFieldTypeString )
• LENGTH ( nullable: true, alias: LENGTH, type: esriFieldTypeSmallInteger )
• HEIGHT ( nullable: true, alias: HEIGHT, type: esriFieldTypeSmallInteger )
• NOTES ( nullable: true, length: 100, alias: NOTES, type: esriFieldTypeString )
• FACING_DIRECTION ( nullable: true, length: 20, alias: FACING_DIRECTION, type: esriFieldTypeString )
• REFLECTIVITY ( nullable: true, length: 30, alias: REFLECTIVITY, type: esriFieldTypeString )
• REFLECTIVE_SHEET_TYPE ( nullable: true, length: 50, alias: REFLECTIVE_SHEET_TYPE, type: esriFieldTypeString )
• INSTALL_DATE ( nullable: true, length: 8, alias: INSTALL_DATE, type: esriFieldTypeDate )
• INSPECTION_DATE ( nullable: true, length: 8, alias: INSPECTION_DATE, type: esriFieldTypeDate )
• INSPECTOR ( nullable: true, length: 30, alias: INSPECTOR, type: esriFieldTypeString )
• OWNED_BY ( nullable: true, length: 20, alias: OWNED_BY, type: esriFieldTypeString , Coded Values: [State: State] , [County: County] , [City: City] , ...1 more... )
• MAINTAINED_BY ( nullable: true, length: 20, alias: MAINTAINED_BY, type: esriFieldTypeString )
• created_user ( nullable: true, length: 255, alias: created_user, type: esriFieldTypeString )
• created_date ( nullable: true, length: 8, alias: created_date, type: esriFieldTypeDate )
• last_edited_user ( nullable: true, length: 255, alias: last_edited_user, type: esriFieldTypeString )
• last_edited_date ( nullable: true, length: 8, alias: last_edited_date, type: esriFieldTypeDate )
• LOCATION ( nullable: true, length: 50, alias: LOCATION, type: esriFieldTypeString )
• LONG_X ( nullable: true, alias: LONG_X, type: esriFieldTypeDouble )
• LAT_Y ( nullable: true, alias: LAT_Y, type: esriFieldTypeDouble )
• Shape ( nullable: true, alias: Shape, type: esriFieldTypeGeometry )
• GlobalID ( nullable: false, length: 38, alias: GlobalID, type: esriFieldTypeGlobalID )
• COB_Maintained ( nullable: true, length: 3, alias: COB Maintained, type: esriFieldTypeString )

Relationships:

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

Layer: Poles For Street Sign (1)

Name: Poles For Street Sign

Display Field: POLE_IDENTIFIER

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 609a232484a14f9fa1d312348c365570

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

MaxSelectionCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 10000.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Supports Datum Transformation: true

Extent:
XMin: 1369450.3414955586
YMin: 445984.5964718908
XMax: 1436730.3362003863
YMax: 493498.1566283107
Spatial Reference: 2893  (2893)



Drawing Info:
Renderer:
Unique Value Renderer:
Field 1: POLE_CONDITION
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: Fair
  Label: Fair
  Description: N/A
  Symbol:
  
• Value: Good
  Label: Good
  Description: N/A
  Symbol:
  
• Value: Poor
  Label: Poor
  Description: N/A
  Symbol:
  
• Value: Replace
  Label: Replace
  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: true
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: true
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: N/A

Fields:
• OBJECTID ( nullable: false, alias: OBJECTID, type: esriFieldTypeOID )
• POLE_IDENTIFIER ( nullable: true, length: 20, alias: POLE_IDENTIFIER, type: esriFieldTypeString )
• STREETLIGHT_IDENTIFIER ( nullable: true, length: 20, alias: STREETLIGHT_IDENTIFIER, type: esriFieldTypeString )
• LOCATION ( nullable: true, length: 50, alias: LOCATION, type: esriFieldTypeString )
• POLE_TYPE ( nullable: true, length: 30, alias: POLE_TYPE, type: esriFieldTypeString , Coded Values: [Streetlight Pole: Streetlight Pole] , [Other: Other] , [Wood: Wood] , ...6 more... )
• POLE_CONDITION ( nullable: true, length: 10, alias: POLE_CONDITION, type: esriFieldTypeString , Coded Values: [Good: Good] , [Fair: Fair] , [Poor: Poor] , ...1 more... )
• VANDAL_TEE ( nullable: true, length: 5, alias: VANDAL_TEE, type: esriFieldTypeString , Coded Values: [Yes: Yes] , [No: No] )
• NOTES ( nullable: true, length: 100, alias: NOTES, type: esriFieldTypeString )
• INSTALL_DATE ( nullable: true, length: 8, alias: INSTALL_DATE, type: esriFieldTypeDate )
• INSPECTION_DATE ( nullable: true, length: 8, alias: INSPECTION_DATE, type: esriFieldTypeDate )
• INSPECTOR ( nullable: true, length: 20, alias: INSPECTOR, type: esriFieldTypeString )
• MANAGED_BY ( nullable: true, length: 20, alias: MANAGED_BY, type: esriFieldTypeString , Coded Values: [State: State] , [County: County] , [City: City] , ...1 more... )
• OWNED_BY ( nullable: true, length: 20, alias: OWNED_BY, type: esriFieldTypeString , Coded Values: [State: State] , [County: County] , [City: City] , ...1 more... )
• PRIMARY_USE ( nullable: true, length: 20, alias: PRIMARY_USE, type: esriFieldTypeString , Coded Values: [Sign: Sign] , [Streetlight: Streetlight] , [Traffic: Traffic] , ...1 more... )
• created_user ( nullable: true, length: 255, alias: created_user, type: esriFieldTypeString )
• created_date ( nullable: true, length: 8, alias: created_date, type: esriFieldTypeDate )
• last_edited_user ( nullable: true, length: 255, alias: last_edited_user, type: esriFieldTypeString )
• last_edited_date ( nullable: true, length: 8, alias: last_edited_date, type: esriFieldTypeDate )
• Shape ( nullable: true, alias: Shape, type: esriFieldTypeGeometry )
• GlobalID ( nullable: false, length: 38, alias: GlobalID, type: esriFieldTypeGlobalID )

Relationships:

• Street_Sign_Pole_Maintenance (2) -- Related To: Pole Maintenance (2)
• Related Signs (1) -- Related To: esri_sde.DBO.Street_Sign (0)

Tables:

Table: Pole Maintenance (2)

Name: Pole Maintenance

Display Field: POLE_IDENTIFIER

Type: Table

Geometry Type: N/A

Description: N/A

Service Item Id: 609a232484a14f9fa1d312348c365570

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

MaxSelectionCount: 0

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Extent:

Drawing Info:
N/A
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: 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: true
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: N/A

Fields:
• OBJECTID ( nullable: false, alias: OBJECTID, type: esriFieldTypeOID )
• POLE_IDENTIFIER ( nullable: true, length: 20, alias: POLE_ID, type: esriFieldTypeString )
• MAINTENANCE_TYPE ( nullable: true, length: 20, alias: MAINTENANCE TYPE, type: esriFieldTypeString , Coded Values: [Repair: Repair] , [Replace: Replace] )
• DATE ( nullable: true, length: 8, alias: DATE, type: esriFieldTypeDate )

Relationships:

• Street_Sign_Poles (2) -- Related To: Poles For Street Sign (1)

Table: Sign Maintenance (3)

Name: Sign Maintenance

Display Field: SIGN_IDENTIFIER

Type: Table

Geometry Type: N/A

Description: N/A

Service Item Id: 609a232484a14f9fa1d312348c365570

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

MaxSelectionCount: 0

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Extent:

Drawing Info:
N/A
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: 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: true
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: N/A

Fields:
• OBJECTID ( nullable: false, alias: OBJECTID, type: esriFieldTypeOID )
• SIGN_IDENTIFIER ( nullable: true, length: 20, alias: SIGN_IDENTIFIER, type: esriFieldTypeString )
• MAINTENANCE_TYPE ( nullable: true, length: 20, alias: MAINTENANCE_TYPE, type: esriFieldTypeString , Coded Values: [Repair: Repair] , [Replace: Replace] )
• DATE ( nullable: true, length: 8, alias: DATE, type: esriFieldTypeDate )
• GlobalID ( nullable: false, length: 38, alias: GlobalID, type: esriFieldTypeGlobalID )

Relationships:

• Street_Sign (0) -- Related To: esri_sde.DBO.Street_Sign (0)