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: 064d9cddcc6c4389bcf7fd0edcdf3a40

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

Use Standardized Queries: true

Supports Datum Transformation: true

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



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

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

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: 064d9cddcc6c4389bcf7fd0edcdf3a40

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

Use Standardized Queries: true

Supports Datum Transformation: true

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



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

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

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

Service Item Id: 064d9cddcc6c4389bcf7fd0edcdf3a40

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

MaxSelectionCount: 0

Supported Query Formats: JSON, PBF

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


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

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

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

Service Item Id: 064d9cddcc6c4389bcf7fd0edcdf3a40

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

MaxSelectionCount: 0

Supported Query Formats: JSON, PBF

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


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

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

Relationships:

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