View In:   ArcGIS Online Map Viewer

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: 4787dc0f8d474861be0bbbe88fdcb957

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

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: 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: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
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: false
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: RequiredRepair

Fields:

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

Types:

ID: F
Name: Fill
Domains:
• RequiredRepair:
  Inherited
• RepairPriority:
  Inherited
• TreeAdjacent:
  Inherited
• HighTrafficArea:
  Inherited
• GrindBy:
  Inherited
• ColdPatchBy:
  Inherited
• ReplacementBy:
  Inherited
• Activity:
  Inherited
• FillBy:
  Inherited
• CG:
  Inherited
• DrivewayApproach:
  Inherited
• LiftHeight1:
  Inherited
• LiftHeight2:
  Inherited
• CrossLift:
  Inherited
• NonStreetInspector:
  Inherited
• Quadrant:
  Inherited
• Complete:
  Inherited
• ReplacementType:
  Inherited
• Rebar_Dowel:
  Inherited
• ManagedBy:
  Inherited
• AutoStreetCalc:
  Inherited
Templates:
• Name: Fill
  Description:
  Prototype:
  ManagedBy: null
  RequiredRepair: F
  RepairPriority: null
  RepairLength: null
  RepairWidth: null
  TreeAdjacent: null
  HighTrafficArea: null
  DefectID: null
  CreatedBy: null
  CreatedDate: null
  GrindBy: null
  GrindDate: null
  ColdPatchBy: null
  ColdPatchDate: null
  ReplacementBy: null
  ReplacementDate: null
  Activity: null
  FillBy: null
  FillDate: null
  CG: null
  CGLength: null
  RepairArea: null
  DrivewayApproach: null
  SidewalkAddrRange: null
  AddNearestParcel: null
  ParcelStreet: null
  ParcelNumber: null
  WONum: null
  LocationDesc: null
  ComputerName: null
  ActivityDate: null
  AutoStreetCalc: Yes
  RepairWidthDecimal: null
  DrivewayApproachLength: null
  DrivewayApproachWidth: null
  LiftHeight1: null
  LiftHeight2: null
  LiftLength: null
  InchFeet: null
  CrossLift: null
  NonStreetInspector: No
  Quadrant: null
  EvaluationDate: null
  Complete: No
  ReplacementType: null
  Rebar_Dowel: null
  Comment: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: G
Name: Grind
Domains:
• RequiredRepair:
  Inherited
• RepairPriority:
  Inherited
• TreeAdjacent:
  Inherited
• HighTrafficArea:
  Inherited
• GrindBy:
  Inherited
• ColdPatchBy:
  Inherited
• ReplacementBy:
  Inherited
• Activity:
  Inherited
• FillBy:
  Inherited
• CG:
  Inherited
• DrivewayApproach:
  Inherited
• LiftHeight1:
  Inherited
• LiftHeight2:
  Inherited
• CrossLift:
  Inherited
• NonStreetInspector:
  Inherited
• Quadrant:
  Inherited
• Complete:
  Inherited
• ReplacementType:
  Inherited
• Rebar_Dowel:
  Inherited
• ManagedBy:
  Inherited
• AutoStreetCalc:
  Inherited
Templates:
• Name: Grind
  Description:
  Prototype:
  ManagedBy: null
  RequiredRepair: G
  RepairPriority: null
  RepairLength: null
  RepairWidth: null
  TreeAdjacent: null
  HighTrafficArea: null
  DefectID: null
  CreatedBy: null
  CreatedDate: null
  GrindBy: null
  GrindDate: null
  ColdPatchBy: null
  ColdPatchDate: null
  ReplacementBy: null
  ReplacementDate: null
  Activity: null
  FillBy: null
  FillDate: null
  CG: null
  CGLength: null
  RepairArea: null
  DrivewayApproach: null
  SidewalkAddrRange: null
  AddNearestParcel: null
  ParcelStreet: null
  ParcelNumber: null
  WONum: null
  LocationDesc: null
  ComputerName: null
  ActivityDate: null
  AutoStreetCalc: Yes
  RepairWidthDecimal: null
  DrivewayApproachLength: null
  DrivewayApproachWidth: null
  LiftHeight1: null
  LiftHeight2: null
  LiftLength: null
  InchFeet: null
  CrossLift: null
  NonStreetInspector: No
  Quadrant: null
  EvaluationDate: null
  Complete: No
  ReplacementType: null
  Rebar_Dowel: null
  Comment: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: R
Name: Replacement
Domains:
• RequiredRepair:
  Inherited
• RepairPriority:
  Inherited
• TreeAdjacent:
  Inherited
• HighTrafficArea:
  Inherited
• GrindBy:
  Inherited
• ColdPatchBy:
  Inherited
• ReplacementBy:
  Inherited
• Activity:
  Inherited
• FillBy:
  Inherited
• CG:
  Inherited
• DrivewayApproach:
  Inherited
• LiftHeight1:
  Inherited
• LiftHeight2:
  Inherited
• CrossLift:
  Inherited
• NonStreetInspector:
  Inherited
• Quadrant:
  Inherited
• Complete:
  Inherited
• ReplacementType:
  Inherited
• Rebar_Dowel:
  Inherited
• ManagedBy:
  Inherited
• AutoStreetCalc:
  Inherited
Templates:
• Name: Replacement
  Description:
  Prototype:
  ManagedBy: null
  RequiredRepair: R
  RepairPriority: null
  RepairLength: null
  RepairWidth: null
  TreeAdjacent: null
  HighTrafficArea: null
  DefectID: null
  CreatedBy: null
  CreatedDate: null
  GrindBy: null
  GrindDate: null
  ColdPatchBy: null
  ColdPatchDate: null
  ReplacementBy: null
  ReplacementDate: null
  Activity: null
  FillBy: null
  FillDate: null
  CG: null
  CGLength: null
  RepairArea: null
  DrivewayApproach: null
  SidewalkAddrRange: null
  AddNearestParcel: null
  ParcelStreet: null
  ParcelNumber: null
  WONum: null
  LocationDesc: null
  ComputerName: null
  ActivityDate: null
  AutoStreetCalc: Yes
  RepairWidthDecimal: null
  DrivewayApproachLength: null
  DrivewayApproachWidth: null
  LiftHeight1: null
  LiftHeight2: null
  LiftLength: null
  InchFeet: null
  CrossLift: null
  NonStreetInspector: No
  Quadrant: null
  EvaluationDate: null
  Complete: No
  ReplacementType: null
  Rebar_Dowel: null
  Comment: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

Capabilities: Query

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: true

Supports ApplyEdits By Upload Id: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:

Supported Operations:   Query   Query Attachments   Query Analytic   Append   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata