View In:   ArcGIS Online Map Viewer

Name: Pavement Segments

Display Field: FACILITYTID

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.

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Min Scale: 100000

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: false

Supports Datum Transformation: true

Extent:

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

Drawing Info:

Renderer:
Class Breaks Renderer:
Field: Current_PCI
Min. Value: 0.0
ClassBreakInfos:
• Class Maximum Value: 26
  Label: 0 - 25
  Description:
  Symbol:
  Style: esriSLSSolid
  Color: [230, 0, 0, 255]
  Width: 2
• Class Maximum Value: 50
  Label: 26 - 50
  Description:
  Symbol:
  Style: esriSLSSolid
  Color: [255, 170, 0, 255]
  Width: 2
• Class Maximum Value: 70
  Label: 51 - 69
  Description:
  Symbol:
  Style: esriSLSSolid
  Color: [255, 255, 0, 255]
  Width: 2
• Class Maximum Value: 100
  Label: 70 - 100
  Description:
  Symbol:
  Style: esriSLSSolid
  Color: [76, 230, 0, 255]
  Width: 2
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: true
Supports Returning Geometry Centroid: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: System-maintained ObjectID )
• FACILITYTID ( type: esriFieldTypeString, alias: FACILITYID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SEGMENTID )
• ENABLED ( type: esriFieldTypeSmallInteger, alias: Paved by Napa, editable: true, nullable: true, defaultValue: 1, modelName: ENABLED , Coded Values: [0: False] , [1: True] )
• STREET ( type: esriFieldTypeString, alias: ROADNAME, editable: true, nullable: true, length: 255, defaultValue: null, modelName: FULLNAME , Coded Values: [A ST: A ST] , [ABBEY CT: ABBEY CT] , [ABRUZZINI CT: ABRUZZINI CT] , ...1415 more... )
• BEGINLOC ( type: esriFieldTypeString, alias: BEGINLOC, editable: true, nullable: true, length: 100, defaultValue: null, modelName: BEGINLOC )
• PCI_DATE ( type: esriFieldTypeDate, alias: PCI_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: PCI_DATE )
• Current_PCI ( type: esriFieldTypeSmallInteger, alias: CURRENT_PCI, editable: true, nullable: true, defaultValue: null, modelName: Current_PCI )
• ENDLOC ( type: esriFieldTypeString, alias: ENDLOC, editable: true, nullable: true, length: 100, defaultValue: null, modelName: ENDLOC )
• SECLENGTH ( type: esriFieldTypeDouble, alias: SECLENGTH, editable: true, nullable: true, defaultValue: null, modelName: SECLENGTH )
• RECLENGTH ( type: esriFieldTypeDouble, alias: Record Length, editable: true, nullable: true, defaultValue: null, modelName: RECLENGTH )
• SECWIDTH ( type: esriFieldTypeDouble, alias: SECWIDTH, editable: true, nullable: true, defaultValue: null, modelName: SECWIDTH )
• SECAREA ( type: esriFieldTypeDouble, alias: SECAREA, editable: true, nullable: true, defaultValue: null, modelName: SECAREA )
• FUNCLASS ( type: esriFieldTypeString, alias: FUNCLASS, editable: true, nullable: true, length: 50, defaultValue: null, modelName: FUNCLASS )
• FUNDSOURCE ( type: esriFieldTypeString, alias: FUNDSOURCE, editable: true, nullable: true, length: 50, defaultValue: null, modelName: FUNDSOURCE )
• SURFACETYPE ( type: esriFieldTypeString, alias: Surface, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SURFACETYPE )
• LANES ( type: esriFieldTypeSmallInteger, alias: LANES, editable: true, nullable: true, defaultValue: null, modelName: LANES )
• PAVEAREA ( type: esriFieldTypeString, alias: PAVEAREA, editable: true, nullable: true, length: 30, defaultValue: null, modelName: PAVEAREA )
• FullStreetID ( type: esriFieldTypeString, alias: FullStreetID, editable: true, nullable: true, length: 100, defaultValue: null, modelName: FullStreetID )
• PAVEDATE ( type: esriFieldTypeDate, alias: PAVE DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: PAVEDATE )
• EST_TONS ( type: esriFieldTypeDouble, alias: EST_TONS, editable: true, nullable: true, defaultValue: null, modelName: EST_TONS )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• PCI_DATE_PREVIOUS ( type: esriFieldTypeDate, alias: PCI_DATE_PREVIOUS, editable: true, nullable: true, length: 8, defaultValue: null, modelName: PCI_DATE_PREVIOUS )
• PREVIOUS_PCI ( type: esriFieldTypeSmallInteger, alias: PREVIOUS_PCI, editable: true, nullable: true, defaultValue: null, modelName: PREVIOUS_PCI )
• ProposedTreatmentYear ( type: esriFieldTypeSmallInteger, alias: Proposed Treatment Year, editable: true, nullable: true, defaultValue: null, modelName: ProposedTreatmentYear )
• ProposedTreatmentFiscalYear ( type: esriFieldTypeString, alias: Proposed Treatment Fiscal Year, editable: true, nullable: true, length: 12, defaultValue: null, modelName: ProposedTreatmentFiscalYear , Coded Values: [FY '28-'29: FY '28-'29] , [FY '27-'28: FY '27-'28] , [FY '26-'27: FY '26-'27] , ...6 more... )
• Status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Status , Coded Values: [TBA: TBA] , [Pending: Pending] , [Complete: Complete] )
• Area_Name ( type: esriFieldTypeString, alias: Area Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Area_Name )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )

Templates:

• Name: Pavement Segments
  Description:
  Prototype:
  FACILITYTID: null
  Area_Name: null
  ENABLED: 1
  STREET: null
  BEGINLOC: null
  PCI_DATE: null
  Current_PCI: null
  ENDLOC: null
  SECLENGTH: null
  RECLENGTH: null
  SECWIDTH: null
  SECAREA: null
  FUNCLASS: null
  FUNDSOURCE: null
  SURFACETYPE: null
  LANES: null
  PAVEAREA: null
  FullStreetID: null
  PAVEDATE: null
  EST_TONS: null
  Status: null
  ProposedTreatmentFiscalYear: null
  PCI_DATE_PREVIOUS: null
  PREVIOUS_PCI: null
  ProposedTreatmentYear: null
  
  Drawing Tool: esriFeatureEditToolLine

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

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: true

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Apply Edits   Add Features   Update Features   Delete Features   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata