Name: Street_Pavement_Inspections_Table

Display Field: Street_Name

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 6d4844c43ae54462825f67fdb3b30a4e

Copyright Text: null

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: 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: 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 )
• Seg_ID ( type: esriFieldTypeString, alias: Segment ID, length: 255 )
• Street_Name ( type: esriFieldTypeString, alias: Street Name, length: 255 )
• Seg_Start ( type: esriFieldTypeString, alias: Street Segment Start, length: 255 )
• Seg_End ( type: esriFieldTypeString, alias: Street Segment End Limit, length: 255 )
• Funct_Class ( type: esriFieldTypeString, alias: Functional Class, length: 255 , Coded Values: [Art: Arterial] , [Col: Collector] , [Loc: Local] , ...1 more... )
• Ownship ( type: esriFieldTypeString, alias: Street Ownership, length: 255 , Coded Values: [Cty: City] , [Cnty: County] , [State: State] , ...1 more... )
• Width_FT ( type: esriFieldTypeInteger, alias: Segment Width (Ft) )
• Length_FT ( type: esriFieldTypeInteger, alias: Segment Length (Ft) )
• Area_SqFt ( type: esriFieldTypeInteger, alias: Area (Square Feet) )
• Lane_Num ( type: esriFieldTypeSmallInteger, alias: Number of Lanes , Coded Values: [2: 2 Lanes] , [4: 4 Lanes] , [6: 6 Lanes] )
• Pave_Type ( type: esriFieldTypeString, alias: Pavement Type, length: 255 , Coded Values: [Asp: Asphalt] , [Con: Concrete] , [Brk: Brick] , ...1 more... )
• PCI_Score ( type: esriFieldTypeInteger, alias: PCI Score )
• Last_Inspect ( type: esriFieldTypeDate, alias: Last Inspection Date, length: 8 )
• Distress_Type ( type: esriFieldTypeString, alias: Distress Type, length: 255 , Coded Values: [AC: Alligator Cracking] , [Rtt: Rutting] , [Ph: Potholes] , ...1 more... )
• Rough_Index ( type: esriFieldTypeInteger, alias: Roughness Index )
• Last_Treat ( type: esriFieldTypeString, alias: Last Treatment Type, length: 255 , Coded Values: [SS: Slurry Seal] , [MO: Mill and Overlay] , [FR: Full Reconstruction] )
• Treat_Date ( type: esriFieldTypeDate, alias: Last Treatment Date, length: 8 )
• Est_Serv_Life ( type: esriFieldTypeString, alias: Remaining Service Life (ERSL), length: 255 , Coded Values: [1: 1 Year] , [2: 2 Years] , [3: 3 Years] , ...2 more... )

Relationships:

• PUBLICWORKS.GISADMIN.Sunrise_Streets_Ownership (0) -- Related To: Streets_Centerline_Pavement_Inspections (1)

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

  Iteminfo   Thumbnail   Metadata