Name: Pavement Segments

Display Field: Area_Name

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: The centerline representation of the streets that are maintained by the City of Napa. This data is downloated from the City of Napa Streetsaver database at the beginning of each calendar year.The PCI Rating and the PCI Date columns in te The Pavement Segments in SDE are updated with data from streetsaver by joining on the SectionKey Column. Street saver is an outside contractorthat takes an inventory of thee steets's condition and PCI ratng once a year.

Service Item Id: 53751838ec174309bdae73b5a9b76ebb

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 100000

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: true

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: 6460661.210201137
YMin: 1851124.6200394556
XMax: 6488481.468700927
YMax: 1889754.0321997702
Spatial Reference: 102642  (2226)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: ProposedTreatmentFiscalYear
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Style: esriSLSSolid
Color: [170, 170, 170, 255]
Width: 1
Default Label: Other Year / No Data
UniqueValueInfos:
• Value: FY '28-'29
  Label: FY '28-'29
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [183, 129, 74, 255]
  Width: 2
• Value: FY '27-'28
  Label: FY '27-'28
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [61, 81, 255, 255]
  Width: 3
• Value: FY '26-'27
  Label: FY '26-'27
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [136, 227, 98, 255]
  Width: 3
• Value: FY '25-'26
  Label: FY '25-'26
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [220, 130, 255, 255]
  Width: 2
• Value: FY '23-'24
  Label: FY '23-'24
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [242, 51, 121, 255]
  Width: 2
• Value: FY '24-'25
  Label: FY '24-'25
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [38, 209, 178, 255]
  Width: 3
• Value: FY '22-'23
  Label: FY '22-'23
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 106, 0, 255]
  Width: 2
• Value: Complete
  Label: Complete
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [92, 89, 85, 255]
  Width: 3
• Value: TBA
  Label: TBA
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [239, 247, 143, 214]
  Width: 1
Transparency: 0
Labeling Info:
Label Placement: esriServerLinePlacementCenterAlong
Label Expression: N/A
Use Coded Values: true
Symbol:
Color: [0, 0, 0, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: baseline
Horizontal Alignment: center
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 10
Font Family: Arial
Font Style: normal
Font Weight: bold
Font Decoration: none

Min. Scale: 6498.392531
Max. Scale: 0.0

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 )
• FACILITYTID ( type: esriFieldTypeString, alias: FACILITYID, length: 50 )
• ENABLED ( type: esriFieldTypeSmallInteger, alias: Paved by Napa , Coded Values: [0: False] , [1: True] )
• RECLENGTH ( type: esriFieldTypeDouble, alias: Record Length )
• OWNEDBY ( type: esriFieldTypeSmallInteger, alias: Owned By , Coded Values: [-1: Private] , [1: City of Napa] , [-2: County of Napa] , ...1 more... )
• MAINTBY ( type: esriFieldTypeSmallInteger, alias: Managed By , Coded Values: [-1: Private] , [1: City of Napa] , [-2: County of Napa] , ...1 more... )
• LASTUPDATE ( type: esriFieldTypeDate, alias: Last Update Date, length: 8 )
• LASTEDITOR ( type: esriFieldTypeString, alias: Last Editor, length: 50 )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )
• SECLENGTH ( type: esriFieldTypeDouble, alias: SECLENGTH )
• SECWIDTH ( type: esriFieldTypeDouble, alias: SECWIDTH )
• SECAREA ( type: esriFieldTypeDouble, alias: SECAREA )
• FUNDSOURCE ( type: esriFieldTypeString, alias: FUNDSOURCE, length: 50 )
• YEAROFINSTALL ( type: esriFieldTypeSmallInteger, alias: Year of Install )
• LANES ( type: esriFieldTypeSmallInteger, alias: LANES )
• COMMENTS ( type: esriFieldTypeString, alias: COMMENTS, length: 100 )
• PAVEAREA ( type: esriFieldTypeString, alias: PAVEAREA, length: 30 )
• FullStreetID ( type: esriFieldTypeString, alias: FullStreetID, length: 100 )
• PAVEDATE ( type: esriFieldTypeDate, alias: PAVE DATE, length: 8 )
• EST_TONS ( type: esriFieldTypeDouble, alias: EST_TONS )
• 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 )
• PAVEYRSTART ( type: esriFieldTypeSmallInteger, alias: PAVE YR START )
• PAVEYRFINISH ( type: esriFieldTypeSmallInteger, alias: PAVE YR FINISH )
• LucMaintZone ( type: esriFieldTypeSmallInteger, alias: Maintenance Zone , Coded Values: [1: PW-1] , [2: PW-2] , [3: PW-3] , ...37 more... )
• LucAltZone ( type: esriFieldTypeSmallInteger, alias: Alternate Zone )
• SECTION_KEY ( type: esriFieldTypeString, alias: SECTION_KEY, length: 10 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• PCI_DATE ( type: esriFieldTypeDate, alias: PCI_DATE_CURRENT, length: 8 )
• Current_PCI ( type: esriFieldTypeSmallInteger, alias: PCI_CURRENT )
• BEGINLOC_930629 ( type: esriFieldTypeString, alias: BEGINLOC, length: 100 )
• PCI_DATE_PREVIOUS ( type: esriFieldTypeDate, alias: PCI_DATE_PREVIOUS, length: 8 )
• PREVIOUS_PCI ( type: esriFieldTypeSmallInteger, alias: PCI_PREVIOUS )
• ProposedTreatmentYear ( type: esriFieldTypeSmallInteger, alias: Proposed Treatment Year )
• Status ( type: esriFieldTypeString, alias: Status, length: 20 , Coded Values: [TBA: TBA] , [Pending: Pending] , [Complete: Complete] )
• Area_Name ( type: esriFieldTypeString, alias: Area Name, length: 50 )
• ADT ( type: esriFieldTypeInteger, alias: Average Daily Traffic )
• SHAPE.STLength() ( type: esriFieldTypeDouble, alias: SHAPE.STLength() )
• STREET ( type: esriFieldTypeString, alias: ROADNAME, length: 255 , Coded Values: [A ST: A ST] , [ABBEY CT: ABBEY CT] , [ABRUZZINI CT: ABRUZZINI CT] , ...1418 more... )
• BEGINLOC ( type: esriFieldTypeString, alias: BEGINLOC, length: 100 )
• ENDLOC ( type: esriFieldTypeString, alias: ENDLOC, length: 100 )
• FUNCLASS ( type: esriFieldTypeString, alias: FUNCLASS, length: 50 )
• SURFACETYPE ( type: esriFieldTypeString, alias: Surface, length: 50 )
• ProposedTreatmentFiscalYear ( type: esriFieldTypeString, alias: Proposed Treatment Fiscal Year, length: 12 , Coded Values: [FY '28-'29: FY '28-'29] , [FY '27-'28: FY '27-'28] , [FY '26-'27: FY '26-'27] , ...6 more... )

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata