Name: Sidewalk Inspection

Display Field: StreetName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: This feature class was created to identify the locations and infractions (or not) of sidewalks and their inspections in the City of Dubuque.

Service Item Id: 8740cf9aef2b4cfa95771c02033f9b15

Copyright Text: City of Dubuque Engineering and City of Dubuque GIS

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 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: 5651374.970314354
YMin: 3638524.4890406877
XMax: 5700665.6604466885
YMax: 3675106.100260526
Spatial Reference: 102675  (3417)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: InspectionResults
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: 2
  Label: FAIL
  Description: N/A
  Symbol:
  
• Value: 1
  Label: PASS
  Description: N/A
  Symbol:
  
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: 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 )
• Date_ ( type: esriFieldTypeDate, alias: Inspection Date, length: 8 )
• InspectionType ( type: esriFieldTypeString, alias: Inspection Type, length: 30 , Coded Values: [Sidewalk Program: Sidewalk Program] , [Accident Report: Accident Report] , [Observation: Observation] , ...6 more... )
• HouseNo ( type: esriFieldTypeSmallInteger, alias: House # )
• StreetName ( type: esriFieldTypeString, alias: Street Name, length: 50 , Coded Values: [ABACA CT: ABACA CT] , [ABBEY WOOD CT: ABBEY WOOD CT] , [ABBOTT ST: ABBOTT ST] , ...1213 more... )
• PropertyOwner ( type: esriFieldTypeString, alias: Property Owner, length: 100 )
• PIN ( type: esriFieldTypeString, alias: PIN, length: 50 )
• City ( type: esriFieldTypeString, alias: City, length: 50 )
• State ( type: esriFieldTypeString, alias: State (xx), length: 2 )
• CornerLot ( type: esriFieldTypeString, alias: Corner Lot?, length: 7 , Coded Values: [Yes: Yes] , [No: No] , [Unk: Unknown] , ...1 more... )
• CurbRampPresent ( type: esriFieldTypeString, alias: Curb Ramp Present?, length: 7 , Coded Values: [Yes: Yes] , [No: No] , [Unk: Unknown] , ...1 more... )
• SidewalkType ( type: esriFieldTypeString, alias: Surface Type, length: 50 , Coded Values: [Asphalt: Asphalt] , [Permeable Asphalt (Pervious): Permeable Asphalt (Pervious)] , [Concrete: Concrete] , ...11 more... )
• SidewalkWidth ( type: esriFieldTypeDouble, alias: Sidewalk Width )
• ParkwayWidth ( type: esriFieldTypeDouble, alias: Parkway Width (Inches) )
• CodeA ( type: esriFieldTypeString, alias: Code A Violations?, length: 50 , Coded Values: [1: Yes, Horizontal Separation Only] , [2: Yes, Vertical Separation Only] , [3: Yes, Horizontal and Vertical Separation] , ...1 more... )
• CodeB ( type: esriFieldTypeString, alias: Code B Violations?, length: 50 , Coded Values: [1: Yes, Single Holes Larger Than 3/4"] , [2: Yes, Single Holes Smaller Than 3/4" That are Sequential] , [3: No Violation Present] )
• CodeC ( type: esriFieldTypeString, alias: Code C Violations?, length: 50 , Coded Values: [2: No Violations Present] , [1: Yes, Spalling Greater Than 50%] )
• CodeD ( type: esriFieldTypeString, alias: Code D Violations?, length: 50 , Coded Values: [3: No Violations Present] , [1: Yes, Single Section Cracked More Than 3 Times] , [2: Yes, Single Square Cracked Less Than 3 Times But Connected To Other Defects] )
• CodeE ( type: esriFieldTypeString, alias: Code E Violations?, length: 50 , Coded Values: [1: Yes, Raised More Than 2" in 8'-10'] , [2: Yes, Raised More Than 2" in 8'-10' Caused by Tree] , [3: No Violations Present] )
• CodeF ( type: esriFieldTypeString, alias: Code F Violations?, length: 50 , Coded Values: [1: Yes, Stop Box Lid Missing/Cracked] , [2: Yes, Stop Box Lid Raised 3/4" or More] , [3: Yes, Stop Box Lid Broken] , ...1 more... )
• SidewalkLength ( type: esriFieldTypeDouble, alias: Sidewalk Length )
• DWDefects ( type: esriFieldTypeString, alias: Do Any Defects Occur on Drivewalk?, length: 7 , Coded Values: [Yes: Yes] , [No: No] , [Unk: Unknown] , ...1 more... )
• DWLength ( type: esriFieldTypeDouble, alias: Drivewalk Length )
• DWWidth ( type: esriFieldTypeDouble, alias: Drivewalk Width )
• DWNotes ( type: esriFieldTypeString, alias: Drivewalk Notes, length: 1073741822 )
• DADefects ( type: esriFieldTypeString, alias: Do Any Defects Occur in Drive Approach?, length: 7 , Coded Values: [Yes: Yes] , [No: No] , [Unk: Unknown] , ...1 more... )
• DALength ( type: esriFieldTypeDouble, alias: Drive Approach Length )
• DAWidth ( type: esriFieldTypeDouble, alias: Drive Approach Width )
• DA_Notes ( type: esriFieldTypeString, alias: Drive Approach Notes, length: 1073741822 )
• StopBoxLocation ( type: esriFieldTypeString, alias: Water Stop Box Location, length: 50 , Coded Values: [1: Parkway] , [2: Sidewalk] , [3: Behind Sidewalk] , ...5 more... )
• StopBoxCompliance ( type: esriFieldTypeString, alias: Is Water Stop Box Compliant?, length: 50 , Coded Values: [Yes: Yes] , [No: No] , [Unk: Unknown] , ...1 more... )
• GrindingLength ( type: esriFieldTypeString, alias: Grinding Length, length: 36 )
• TreeNo ( type: esriFieldTypeSmallInteger, alias: If Yes, # of Trees )
• TreeGrate ( type: esriFieldTypeString, alias: Does Tree Have a Grate?, length: 7 , Coded Values: [Yes: Yes] , [No: No] , [Unk: Unknown] , ...1 more... )
• TreeMooned ( type: esriFieldTypeString, alias: Is Sidewalk Mooned to Accomodate Tree?, length: 7 , Coded Values: [Yes: Yes] , [No: No] , [Unk: Unknown] , ...1 more... )
• TreeStump ( type: esriFieldTypeString, alias: Does Tree Stump Exist?, length: 7 , Coded Values: [Yes: Yes] , [No: No] , [Unk: Unknown] , ...1 more... )
• TreeNotes ( type: esriFieldTypeString, alias: Tree Notes, length: 1073741822 )
• CurbType ( type: esriFieldTypeString, alias: Curb Type, length: 50 , Coded Values: [Standard Curb & Gutter: Standard Curb & Gutter] , [Wall Curb: Wall Curb] , [Limestone Curb: Limestone Curb] , ...4 more... )
• CurbHeight ( type: esriFieldTypeDouble, alias: Curb Height (Inches) )
• CurbBox ( type: esriFieldTypeString, alias: Curb Box Present?, length: 7 , Coded Values: [Yes: Yes] , [No: No] , [Unk: Unknown] , ...1 more... )
• CurbNotes ( type: esriFieldTypeString, alias: Curb Notes, length: 1073741822 )
• ReplacementFitting ( type: esriFieldTypeString, alias: Replacement Fitting, length: 50 )
• CBStatus ( type: esriFieldTypeString, alias: Is Catch Basin in Conflict?, length: 50 , Coded Values: [Yes: Yes] , [No: No] , [Unk: Unknown] , ...1 more... )
• CBCondition ( type: esriFieldTypeString, alias: Catch Basin Condition, length: 50 , Coded Values: [Good: Good] , [Fair: Fair] , [Poor: Poor] , ...4 more... )
• Signs ( type: esriFieldTypeString, alias: Street Signs Present?, length: 7 , Coded Values: [Yes: Yes] , [No: No] , [Unk: Unknown] , ...1 more... )
• ParkingMeters ( type: esriFieldTypeString, alias: Are Parking Meters Present?, length: 7 , Coded Values: [Yes: Yes] , [No: No] , [Unk: Unknown] , ...1 more... )
• Notes ( type: esriFieldTypeString, alias: Overall Inspection Notes, length: 1073741822 )
• ID ( type: esriFieldTypeInteger, alias: Inspection ID )
• SidewalkID ( type: esriFieldTypeString, alias: Sidewalk ID, length: 50 )
• InspectionResults ( type: esriFieldTypeInteger, alias: Inspection Results , Coded Values: [1: PASS] , [2: FAIL] , [3: UNKNOWN] )
• MailingAddress ( type: esriFieldTypeString, alias: Mailing Address, length: 100 )
• Zip ( type: esriFieldTypeDouble, alias: Zip Code )
• Season ( type: esriFieldTypeString, alias: Inspection Year, length: 20 )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• InspectedBy ( type: esriFieldTypeString, alias: Inspected By, length: 100 , Coded Values: [Adam Decker: Adam Decker] , [Anita Gonyier: Anita Gonyier] , [Anna Van Otterloo: Anna Van Otterloo] , ...49 more... )
• InspectionStatus ( type: esriFieldTypeString, alias: Inspection Status, length: 20 , Coded Values: [Not Started: Not Started] , [Initiated: Initiated] , [Completed: Completed] , ...1 more... )
• RepairDate ( type: esriFieldTypeDate, alias: Repair Date, length: 8 )
• 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 )
• Resolved ( type: esriFieldTypeString, alias: Issue Resolved, length: 255 , Coded Values: [Yes: Yes] , [No: No] , [Unk: Unknown] , ...1 more... )
• LetterSent ( type: esriFieldTypeString, alias: Letter Sent, length: 255 , Coded Values: [Yes: Yes] , [No: No] , [Unk: Unknown] , ...1 more... )
• LetterDate ( type: esriFieldTypeDate, alias: Letter Sent Date, length: 8 )
• Extension ( type: esriFieldTypeString, alias: Extension Requested, length: 255 , Coded Values: [Yes: Yes] , [No: No] , [Unk: Unknown] , ...1 more... )
• FollowUpInspectionDate ( type: esriFieldTypeDate, alias: Follow Up Inspection Date, length: 8 )
• ResolvedDate ( type: esriFieldTypeDate, alias: Resolved Date, length: 8 )
• ExtensionRequestDate ( type: esriFieldTypeDate, alias: Extension Request Date, length: 8 )
• Responsibility ( type: esriFieldTypeString, alias: Responsibility, length: 15 , Coded Values: [Public: Public] , [Private: Private] , [Unknown: Unknown] )
• Grinding ( type: esriFieldTypeString, alias: Grinding Only?, length: 25 , Coded Values: [Yes: Yes] , [No: No] , [Unk: Unknown] , ...1 more... )
• PassFailInspection ( type: esriFieldTypeString, alias: Pass/Fail Inspection, length: 50 , Coded Values: [PassInspection1: Pass: Initial Inspection] , [PassInspection2: Pass: 2nd Inspection] , [FailInspection1: Fail: Initial Inspection] , ...1 more... )
• GrindingLF ( type: esriFieldTypeDouble, alias: Grinding Length (Ft) )
• VegetationTripHazard ( type: esriFieldTypeString, alias: Is vegetation a tripping hazard?, length: 104 , Coded Values: [Yes: Yes] , [No: No] , [Unk: Unknown] , ...1 more... )

Relationships:

• Correspondence (0) -- Related To: Inspection Correspondence (2)

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

  Iteminfo   Thumbnail   Metadata