Name: Sidewalk Defects For Work Orders

Display Field: ComputerName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: This feature class contains point features that represent the defects on sidewalks throughout the city. Data for each defect point feature can be accessed in the attribute table.*Metadata Author Note: The data looks to be specific to the Department of Public Works of the City of Thousand Oaks.

Service Item Id: b5d1018691c54a2d97a759f68151e994

Copyright Text: Development Division of the Department of Public Works, City of Thousand Oaks. For inquiries on the data, please contact: Mary Anne Van Zuyle, GIS Specialist Phone: (805) 449-2395 E-mail: mvanzuyle@toaks.org.

Default Visibility: true

MaxRecordCount: 2000

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: 6261281.551249996
YMin: 1873502.8518750072
XMax: 6423684.724999994
YMax: 1911545.6768749952
Spatial Reference: 102645  (2229)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: RequiredRepair
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: F
  Label: Fill
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [255, 0, 197, 255]
  Size: 10.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 0] Width: 0
• Value: G
  Label: Grind
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [255, 170, 0, 255]
  Size: 10.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [255, 170, 0, 0] Width: 0
• Value: R
  Label: Replacement
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [255, 0, 0, 255]
  Size: 10.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 0] Width: 0
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: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• RequiredRepair ( type: esriFieldTypeString, alias: Required Repair Type, length: 15 , Coded Values: [G: Grind] , [R: Replacement] , [F: Fill] , ...1 more... )
• RepairPriority ( type: esriFieldTypeString, alias: RepairPriority, length: 50 , Coded Values: [1: 1] , [2: 2] , [3: 3] )
• RepairLength ( type: esriFieldTypeSmallInteger, alias: Length of Sidewalk to Repair )
• RepairWidth ( type: esriFieldTypeSmallInteger, alias: Width of Sidewalk to Repair )
• TreeAdjacent ( type: esriFieldTypeString, alias: TreeAdjacent, length: 3 , Coded Values: [Y: Yes] , [N: No] )
• HighTrafficArea ( type: esriFieldTypeString, alias: HighTrafficArea, length: 3 , Coded Values: [Y: Yes] , [N: No] )
• DefectID ( type: esriFieldTypeString, alias: DefectID, length: 20 )
• CreatedBy ( type: esriFieldTypeString, alias: CreatedBy, length: 255 )
• CreatedDate ( type: esriFieldTypeDate, alias: CreatedDate, length: 8 )
• GrindBy ( type: esriFieldTypeString, alias: GrindBy, length: 50 , Coded Values: [MSC Staff: MSC Staff] , [Contractor: Contractor] , [Crew1: Crew1] , ...3 more... )
• GrindDate ( type: esriFieldTypeDate, alias: GrindDate, length: 8 )
• ColdPatchBy ( type: esriFieldTypeString, alias: ColdPatchBy, length: 50 , Coded Values: [MSC Staff: MSC Staff] , [Contractor: Contractor] , [Crew1: Crew1] , ...3 more... )
• ColdPatchDate ( type: esriFieldTypeDate, alias: ColdPatchDate, length: 8 )
• ReplacementBy ( type: esriFieldTypeString, alias: ReplacementBy, length: 50 , Coded Values: [MSC Staff: MSC Staff] , [Contractor: Contractor] , [Crew1: Crew1] , ...3 more... )
• ReplacementDate ( type: esriFieldTypeDate, alias: ReplacementDate, length: 8 )
• Activity ( type: esriFieldTypeString, alias: Activity, length: 4 , Coded Values: [C: Record Defect] , [G: Grind] , [R: Replace] , ...2 more... )
• FillBy ( type: esriFieldTypeString, alias: FillBy, length: 50 , Coded Values: [MSC Staff: MSC Staff] , [Contractor: Contractor] , [Crew1: Crew1] , ...3 more... )
• FillDate ( type: esriFieldTypeDate, alias: FillDate, length: 8 )
• CG ( type: esriFieldTypeString, alias: CurbAndGutterRepair, length: 3 , Coded Values: [Yes: Yes] , [No: No] )
• CGLength ( type: esriFieldTypeDouble, alias: CurbAndGutterRepairLength )
• RepairArea ( type: esriFieldTypeSmallInteger, alias: Repair Square Feet )
• DrivewayApproach ( type: esriFieldTypeString, alias: Driveway Approach, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• SidewalkAddrRange ( type: esriFieldTypeString, alias: SidewalkAddrRange, length: 75 )
• AddNearestParcel ( type: esriFieldTypeString, alias: AddNearestParcel, length: 75 )
• ParcelStreet ( type: esriFieldTypeString, alias: ParcelStreet, length: 50 )
• ParcelNumber ( type: esriFieldTypeString, alias: ParcelNumber, length: 50 )
• WONum ( type: esriFieldTypeString, alias: WONum, length: 50 )
• LocationDesc ( type: esriFieldTypeString, alias: Location Description, length: 30 )
• ComputerName ( type: esriFieldTypeString, alias: ComputerName, length: 30 )
• ActivityDate ( type: esriFieldTypeDate, alias: ActivityDate, length: 8 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• RepairWidthDecimal ( type: esriFieldTypeSingle, alias: RepairWidthDecimal )
• DrivewayApproachLength ( type: esriFieldTypeSmallInteger, alias: DrivewayApproachLength )
• DrivewayApproachWidth ( type: esriFieldTypeSingle, alias: DrivewayApproachWidth )
• LiftHeight1 ( type: esriFieldTypeDouble, alias: LiftHeight1 Inches , Coded Values: [0.25: 0.25] , [0.5: 0.50] , [0.75: 0.75] , ...13 more... )
• LiftHeight2 ( type: esriFieldTypeDouble, alias: LiftHeight2 Inches , Coded Values: [0.25: 0.25] , [0.5: 0.50] , [0.75: 0.75] , ...13 more... )
• LiftLength ( type: esriFieldTypeDouble, alias: LiftLength Feet )
• InchFeet ( type: esriFieldTypeDouble, alias: InchFeet )
• CrossLift ( type: esriFieldTypeString, alias: Cross Lift Y/N, length: 3 , Coded Values: [Yes: Yes] , [No: No] )
• NonStreetInspector ( type: esriFieldTypeString, alias: Non-Street Inspector, length: 20 , Coded Values: [Yes: Yes] , [No: No] )
• Quadrant ( type: esriFieldTypeString, alias: Quadrant, length: 2 , Coded Values: [1A: 1A] , [1B: 1B] , [2A: 2A] , ...5 more... )
• EvaluationDate ( type: esriFieldTypeDate, alias: Evaluation Date, length: 8 )
• Complete ( type: esriFieldTypeString, alias: Complete, length: 3 , Coded Values: [Yes: Yes] , [No: No] )
• ReplacementType ( type: esriFieldTypeString, alias: ReplacementType, length: 30 , Coded Values: [Sidewalk Repair: Sidewalk Repair] , [Curb and Gutter: Curb and Gutter] , [Driveway Approach: Driveway Approach] , ...2 more... )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )
• Rebar_Dowel ( type: esriFieldTypeString, alias: Rebar_Dowel, length: 3 , Coded Values: [Yes: Yes] , [No: No] )
• Comment ( type: esriFieldTypeString, alias: Comment, length: 255 )
• ManagedBy ( type: esriFieldTypeString, alias: ManagedBy, length: 255 , Coded Values: [City: City] , [Contractor: Contractor] )
• AutoStreetCalc ( type: esriFieldTypeString, alias: AutoStreetCalc, length: 3 , Coded Values: [Yes: Yes] , [No: No] )

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

  Iteminfo   Thumbnail   Metadata