Layers:

Layer: Sidewalk Inspection (0)

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.

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

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: 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: CodeA
Field 2: InspectionStatus
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: 2,Not Started
  Label: Vertical Separation of 1" or More: Defect Status = Not Started (Just Found)
  Description: N/A
  Symbol:
  
• Value: 2,Initiated
  Label: Vertical Separation of 1" or More: Defect Status = Initiated (Letter Sent)
  Description: N/A
  Symbol:
  
• Value: 2,Ongoing
  Label: Vertical Separation of 1" or More: Defect Status = Ongoing (Work Started)
  Description: N/A
  Symbol:
  
• Value: 2,Completed
  Label: Vertical Separation of 1" or More: Defect Status = Completed
  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: 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: CodeA

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Date_ ( type: esriFieldTypeDate, alias: Inspection Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Date_ )
• InspectionType ( type: esriFieldTypeString, alias: Inspection Type, editable: true, nullable: true, length: 30, defaultValue: null, modelName: InspectionType , Coded Values: [Sidewalk Program: Sidewalk Program] , [Accident Report: Accident Report] , [Observation: Observation] , ...6 more... )
• HouseNo ( type: esriFieldTypeSmallInteger, alias: House #, editable: true, nullable: true, defaultValue: null, modelName: HouseNo )
• StreetName ( type: esriFieldTypeString, alias: Street Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: StreetName , Coded Values: [ABACA CT: ABACA CT] , [ABBEY WOOD CT: ABBEY WOOD CT] , [ABBOTT ST: ABBOTT ST] , ...1213 more... )
• PropertyOwner ( type: esriFieldTypeString, alias: Property Owner, editable: true, nullable: true, length: 100, defaultValue: null, modelName: PropertyOwner )
• PIN ( type: esriFieldTypeString, alias: PIN, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PIN )
• City ( type: esriFieldTypeString, alias: City, editable: true, nullable: true, length: 50, defaultValue: Dubuque, modelName: City )
• State ( type: esriFieldTypeString, alias: State (xx), editable: true, nullable: true, length: 2, defaultValue: IA, modelName: State )
• CornerLot ( type: esriFieldTypeString, alias: Corner Lot?, editable: true, nullable: true, length: 7, defaultValue: null, modelName: CornerLot , Coded Values: [Yes: Yes] , [No: No] , [Unk: Unknown] , ...1 more... )
• CurbRampPresent ( type: esriFieldTypeString, alias: Curb Ramp Present?, editable: true, nullable: true, length: 7, defaultValue: null, modelName: CurbRampPresent , Coded Values: [Yes: Yes] , [No: No] , [Unk: Unknown] , ...1 more... )
• SidewalkType ( type: esriFieldTypeString, alias: Surface Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SidewalkType , Coded Values: [Asphalt: Asphalt] , [Permeable Asphalt (Pervious): Permeable Asphalt (Pervious)] , [Concrete: Concrete] , ...11 more... )
• SidewalkWidth ( type: esriFieldTypeDouble, alias: Sidewalk Width, editable: true, nullable: true, defaultValue: null, modelName: SidewalkWidth )
• ParkwayWidth ( type: esriFieldTypeDouble, alias: Parkway Width (Inches), editable: true, nullable: true, defaultValue: null, modelName: ParkwayWidth )
• CodeA ( type: esriFieldTypeString, alias: Code A Violations?, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CodeA , 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?, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CodeB , 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?, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CodeC , Coded Values: [2: No Violations Present] , [1: Yes, Spalling Greater Than 50%] )
• CodeD ( type: esriFieldTypeString, alias: Code D Violations?, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CodeD , 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?, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CodeE , 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?, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CodeF , 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, editable: true, nullable: true, defaultValue: null, modelName: SidewalkLength )
• DWDefects ( type: esriFieldTypeString, alias: Do Any Defects Occur on Drivewalk?, editable: true, nullable: true, length: 7, defaultValue: null, modelName: DWDefects , Coded Values: [Yes: Yes] , [No: No] , [Unk: Unknown] , ...1 more... )
• DWLength ( type: esriFieldTypeDouble, alias: Drivewalk Length, editable: true, nullable: true, defaultValue: null, modelName: DWLength )
• DWWidth ( type: esriFieldTypeDouble, alias: Drivewalk Width, editable: true, nullable: true, defaultValue: null, modelName: DWWidth )
• DWNotes ( type: esriFieldTypeString, alias: Drivewalk Notes, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: DWNotes )
• DADefects ( type: esriFieldTypeString, alias: Do Any Defects Occur in Drive Approach?, editable: true, nullable: true, length: 7, defaultValue: null, modelName: DADefects , Coded Values: [Yes: Yes] , [No: No] , [Unk: Unknown] , ...1 more... )
• DALength ( type: esriFieldTypeDouble, alias: Drive Approach Length, editable: true, nullable: true, defaultValue: null, modelName: DALength )
• DAWidth ( type: esriFieldTypeDouble, alias: Drive Approach Width, editable: true, nullable: true, defaultValue: null, modelName: DAWidth )
• DA_Notes ( type: esriFieldTypeString, alias: Drive Approach Notes, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: DA_Notes )
• StopBoxLocation ( type: esriFieldTypeString, alias: Water Stop Box Location, editable: true, nullable: true, length: 50, defaultValue: null, modelName: StopBoxLocation , Coded Values: [1: Parkway] , [2: Sidewalk] , [3: Behind Sidewalk] , ...5 more... )
• StopBoxCompliance ( type: esriFieldTypeString, alias: Is Water Stop Box Compliant?, editable: true, nullable: true, length: 50, defaultValue: null, modelName: StopBoxCompliance , Coded Values: [Yes: Yes] , [No: No] , [Unk: Unknown] , ...1 more... )
• GrindingLength ( type: esriFieldTypeString, alias: Grinding Length, editable: true, nullable: true, length: 36, defaultValue: null, modelName: GrindingLength )
• TreeNo ( type: esriFieldTypeSmallInteger, alias: If Yes, # of Trees, editable: true, nullable: true, defaultValue: null, modelName: TreeNo )
• TreeGrate ( type: esriFieldTypeString, alias: Does Tree Have a Grate?, editable: true, nullable: true, length: 7, defaultValue: null, modelName: TreeGrate , Coded Values: [Yes: Yes] , [No: No] , [Unk: Unknown] , ...1 more... )
• TreeMooned ( type: esriFieldTypeString, alias: Is Sidewalk Mooned to Accomodate Tree?, editable: true, nullable: true, length: 7, defaultValue: null, modelName: TreeMooned , Coded Values: [Yes: Yes] , [No: No] , [Unk: Unknown] , ...1 more... )
• TreeStump ( type: esriFieldTypeString, alias: Does Tree Stump Exist?, editable: true, nullable: true, length: 7, defaultValue: null, modelName: TreeStump , Coded Values: [Yes: Yes] , [No: No] , [Unk: Unknown] , ...1 more... )
• TreeNotes ( type: esriFieldTypeString, alias: Tree Notes, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: TreeNotes )
• CurbType ( type: esriFieldTypeString, alias: Curb Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CurbType , 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), editable: true, nullable: true, defaultValue: null, modelName: CurbHeight )
• CurbBox ( type: esriFieldTypeString, alias: Curb Box Present?, editable: true, nullable: true, length: 7, defaultValue: null, modelName: CurbBox , Coded Values: [Yes: Yes] , [No: No] , [Unk: Unknown] , ...1 more... )
• CurbNotes ( type: esriFieldTypeString, alias: Curb Notes, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: CurbNotes )
• ReplacementFitting ( type: esriFieldTypeString, alias: Replacement Fitting, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ReplacementFitting )
• CBStatus ( type: esriFieldTypeString, alias: Is Catch Basin in Conflict?, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CBStatus , Coded Values: [Yes: Yes] , [No: No] , [Unk: Unknown] , ...1 more... )
• CBCondition ( type: esriFieldTypeString, alias: Catch Basin Condition, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CBCondition , Coded Values: [Good: Good] , [Fair: Fair] , [Poor: Poor] , ...4 more... )
• Signs ( type: esriFieldTypeString, alias: Street Signs Present?, editable: true, nullable: true, length: 7, defaultValue: null, modelName: Signs , Coded Values: [Yes: Yes] , [No: No] , [Unk: Unknown] , ...1 more... )
• ParkingMeters ( type: esriFieldTypeString, alias: Are Parking Meters Present?, editable: true, nullable: true, length: 7, defaultValue: null, modelName: ParkingMeters , Coded Values: [Yes: Yes] , [No: No] , [Unk: Unknown] , ...1 more... )
• Notes ( type: esriFieldTypeString, alias: Overall Inspection Notes, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Notes )
• ID ( type: esriFieldTypeInteger, alias: Inspection ID, editable: true, nullable: true, defaultValue: null, modelName: ID )
• SidewalkID ( type: esriFieldTypeString, alias: Sidewalk ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SidewalkID )
• InspectionResults ( type: esriFieldTypeInteger, alias: Inspection Results, editable: true, nullable: true, defaultValue: null, modelName: InspectionResults , Coded Values: [1: PASS] , [2: FAIL] , [3: UNKNOWN] )
• MailingAddress ( type: esriFieldTypeString, alias: Mailing Address, editable: true, nullable: true, length: 100, defaultValue: null, modelName: MailingAddress )
• Zip ( type: esriFieldTypeDouble, alias: Zip Code, editable: true, nullable: true, defaultValue: null, modelName: Zip )
• Season ( type: esriFieldTypeString, alias: Inspection Year, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Season )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• InspectedBy ( type: esriFieldTypeString, alias: Inspected By, editable: true, nullable: true, length: 100, defaultValue: null, modelName: InspectedBy , Coded Values: [Adam Decker: Adam Decker] , [Anita Gonyier: Anita Gonyier] , [Anna Van Otterloo: Anna Van Otterloo] , ...49 more... )
• InspectionStatus ( type: esriFieldTypeString, alias: Inspection Status, editable: true, nullable: true, length: 20, defaultValue: null, modelName: InspectionStatus , Coded Values: [Not Started: Not Started] , [Initiated: Initiated] , [Completed: Completed] , ...1 more... )
• RepairDate ( type: esriFieldTypeDate, alias: Repair Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: RepairDate )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• Resolved ( type: esriFieldTypeString, alias: Issue Resolved, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Resolved , Coded Values: [Yes: Yes] , [No: No] , [Unk: Unknown] , ...1 more... )
• LetterSent ( type: esriFieldTypeString, alias: Letter Sent, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LetterSent , Coded Values: [Yes: Yes] , [No: No] , [Unk: Unknown] , ...1 more... )
• LetterDate ( type: esriFieldTypeDate, alias: Letter Sent Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LetterDate )
• Extension ( type: esriFieldTypeString, alias: Extension Requested, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Extension , Coded Values: [Yes: Yes] , [No: No] , [Unk: Unknown] , ...1 more... )
• FollowUpInspectionDate ( type: esriFieldTypeDate, alias: Follow Up Inspection Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: FollowUpInspectionDate )
• ResolvedDate ( type: esriFieldTypeDate, alias: Resolved Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ResolvedDate )
• ExtensionRequestDate ( type: esriFieldTypeDate, alias: Extension Request Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ExtensionRequestDate )
• Responsibility ( type: esriFieldTypeString, alias: Responsibility, editable: true, nullable: true, length: 15, defaultValue: null, modelName: Responsibility , Coded Values: [Public: Public] , [Private: Private] , [Unknown: Unknown] )
• Grinding ( type: esriFieldTypeString, alias: Grinding Only?, editable: true, nullable: true, length: 25, defaultValue: null, modelName: Grinding , Coded Values: [Yes: Yes] , [No: No] , [Unk: Unknown] , ...1 more... )
• PassFailInspection ( type: esriFieldTypeString, alias: Pass/Fail Inspection, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PassFailInspection , Coded Values: [PassInspection1: Pass: Initial Inspection] , [PassInspection2: Pass: 2nd Inspection] , [FailInspection1: Fail: Initial Inspection] , ...1 more... )
• GrindingLF ( type: esriFieldTypeDouble, alias: Grinding Length (Ft), editable: true, nullable: true, defaultValue: null, modelName: GrindingLF )
• VegetationTripHazard ( type: esriFieldTypeString, alias: Is vegetation a tripping hazard?, editable: true, nullable: true, length: 104, defaultValue: null, modelName: VegetationTripHazard , Coded Values: [Yes: Yes] , [No: No] , [Unk: Unknown] , ...1 more... )
Types:
ID: 2
Name: Vertical Separation of 1" or More: Defect Status = Not Started (Just Found)
Domains:
• InspectionType:
  Inherited
• StreetName:
  Inherited
• CornerLot:
  Inherited
• CurbRampPresent:
  Inherited
• SidewalkType:
  Inherited
• CodeA:
  Inherited
• CodeB:
  Inherited
• CodeC:
  Inherited
• CodeD:
  Inherited
• CodeE:
  Inherited
• CodeF:
  Inherited
• DWDefects:
  Inherited
• DADefects:
  Inherited
• StopBoxLocation:
  Inherited
• StopBoxCompliance:
  Inherited
• TreeGrate:
  Inherited
• TreeMooned:
  Inherited
• TreeStump:
  Inherited
• CurbType:
  Inherited
• CurbBox:
  Inherited
• CBStatus:
  Inherited
• CBCondition:
  Inherited
• Signs:
  Inherited
• ParkingMeters:
  Inherited
• InspectionResults:
  Inherited
• InspectedBy:
  Inherited
• InspectionStatus:
  Inherited
• Resolved:
  Inherited
• LetterSent:
  Inherited
• Extension:
  Inherited
• Responsibility:
  Inherited
• Grinding:
  Inherited
• PassFailInspection:
  Inherited
• VegetationTripHazard:
  Inherited
Templates:
• Name: Vertical Separation of 1" or More: Defect Status = Not Started (Just Found)
  Description:
  Prototype:
  InspectedBy: null
  ParkwayWidth: null
  PIN: null
  City: Dubuque
  GrindingLF: null
  Date_: null
  InspectionType: null
  HouseNo: null
  StreetName: null
  PropertyOwner: null
  State: IA
  CornerLot: null
  CurbRampPresent: null
  SidewalkType: null
  SidewalkWidth: null
  CodeA: 2
  CodeB: null
  CodeC: null
  CodeD: null
  CodeE: null
  CodeF: null
  SidewalkLength: null
  DWDefects: null
  DWLength: null
  DWWidth: null
  DWNotes: null
  DADefects: null
  DALength: null
  DAWidth: null
  DA_Notes: null
  StopBoxLocation: null
  StopBoxCompliance: null
  GrindingLength: null
  TreeNo: null
  TreeGrate: null
  TreeMooned: null
  TreeStump: null
  TreeNotes: null
  CurbType: null
  CurbHeight: null
  CurbBox: null
  CurbNotes: null
  ReplacementFitting: null
  CBStatus: null
  CBCondition: null
  Signs: null
  ParkingMeters: null
  Notes: null
  ID: null
  SidewalkID: null
  InspectionResults: null
  MailingAddress: null
  Zip: null
  Season: null
  VegetationTripHazard: null
  InspectionStatus: Not Started
  RepairDate: null
  PassFailInspection: null
  Grinding: null
  Responsibility: null
  ExtensionRequestDate: null
  Resolved: null
  LetterSent: null
  LetterDate: null
  Extension: null
  FollowUpInspectionDate: null
  ResolvedDate: null
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: Vertical Separation of 1" or More: Defect Status = Initiated (Letter Sent)
  Description:
  Prototype:
  InspectedBy: null
  ParkwayWidth: null
  PIN: null
  City: Dubuque
  GrindingLF: null
  Date_: null
  InspectionType: null
  HouseNo: null
  StreetName: null
  PropertyOwner: null
  State: IA
  CornerLot: null
  CurbRampPresent: null
  SidewalkType: null
  SidewalkWidth: null
  CodeA: 2
  CodeB: null
  CodeC: null
  CodeD: null
  CodeE: null
  CodeF: null
  SidewalkLength: null
  DWDefects: null
  DWLength: null
  DWWidth: null
  DWNotes: null
  DADefects: null
  DALength: null
  DAWidth: null
  DA_Notes: null
  StopBoxLocation: null
  StopBoxCompliance: null
  GrindingLength: null
  TreeNo: null
  TreeGrate: null
  TreeMooned: null
  TreeStump: null
  TreeNotes: null
  CurbType: null
  CurbHeight: null
  CurbBox: null
  CurbNotes: null
  ReplacementFitting: null
  CBStatus: null
  CBCondition: null
  Signs: null
  ParkingMeters: null
  Notes: null
  ID: null
  SidewalkID: null
  InspectionResults: null
  MailingAddress: null
  Zip: null
  Season: null
  VegetationTripHazard: null
  InspectionStatus: Initiated
  RepairDate: null
  PassFailInspection: null
  Grinding: null
  Responsibility: null
  ExtensionRequestDate: null
  Resolved: null
  LetterSent: null
  LetterDate: null
  Extension: null
  FollowUpInspectionDate: null
  ResolvedDate: null
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: Vertical Separation of 1" or More: Defect Status = Ongoing (Work Started)
  Description:
  Prototype:
  InspectedBy: null
  ParkwayWidth: null
  PIN: null
  City: Dubuque
  GrindingLF: null
  Date_: null
  InspectionType: null
  HouseNo: null
  StreetName: null
  PropertyOwner: null
  State: IA
  CornerLot: null
  CurbRampPresent: null
  SidewalkType: null
  SidewalkWidth: null
  CodeA: 2
  CodeB: null
  CodeC: null
  CodeD: null
  CodeE: null
  CodeF: null
  SidewalkLength: null
  DWDefects: null
  DWLength: null
  DWWidth: null
  DWNotes: null
  DADefects: null
  DALength: null
  DAWidth: null
  DA_Notes: null
  StopBoxLocation: null
  StopBoxCompliance: null
  GrindingLength: null
  TreeNo: null
  TreeGrate: null
  TreeMooned: null
  TreeStump: null
  TreeNotes: null
  CurbType: null
  CurbHeight: null
  CurbBox: null
  CurbNotes: null
  ReplacementFitting: null
  CBStatus: null
  CBCondition: null
  Signs: null
  ParkingMeters: null
  Notes: null
  ID: null
  SidewalkID: null
  InspectionResults: null
  MailingAddress: null
  Zip: null
  Season: null
  VegetationTripHazard: null
  InspectionStatus: Ongoing
  RepairDate: null
  PassFailInspection: null
  Grinding: null
  Responsibility: null
  ExtensionRequestDate: null
  Resolved: null
  LetterSent: null
  LetterDate: null
  Extension: null
  FollowUpInspectionDate: null
  ResolvedDate: null
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: Vertical Separation of 1" or More: Defect Status = Completed
  Description:
  Prototype:
  InspectedBy: null
  ParkwayWidth: null
  PIN: null
  City: Dubuque
  GrindingLF: null
  Date_: null
  InspectionType: null
  HouseNo: null
  StreetName: null
  PropertyOwner: null
  State: IA
  CornerLot: null
  CurbRampPresent: null
  SidewalkType: null
  SidewalkWidth: null
  CodeA: 2
  CodeB: null
  CodeC: null
  CodeD: null
  CodeE: null
  CodeF: null
  SidewalkLength: null
  DWDefects: null
  DWLength: null
  DWWidth: null
  DWNotes: null
  DADefects: null
  DALength: null
  DAWidth: null
  DA_Notes: null
  StopBoxLocation: null
  StopBoxCompliance: null
  GrindingLength: null
  TreeNo: null
  TreeGrate: null
  TreeMooned: null
  TreeStump: null
  TreeNotes: null
  CurbType: null
  CurbHeight: null
  CurbBox: null
  CurbNotes: null
  ReplacementFitting: null
  CBStatus: null
  CBCondition: null
  Signs: null
  ParkingMeters: null
  Notes: null
  ID: null
  SidewalkID: null
  InspectionResults: null
  MailingAddress: null
  Zip: null
  Season: null
  VegetationTripHazard: null
  InspectionStatus: Completed
  RepairDate: null
  PassFailInspection: null
  Grinding: null
  Responsibility: null
  ExtensionRequestDate: null
  Resolved: null
  LetterSent: null
  LetterDate: null
  Extension: null
  FollowUpInspectionDate: null
  ResolvedDate: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

Relationships:

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

Tables:

Table: Inspection Correspondence (1)

Name: Inspection Correspondence

Display Field: Inspector1

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:
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: 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: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Inspector1 ( type: esriFieldTypeString, alias: Inspector, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Inspector1 , Coded Values: [Adam Decker: Adam Decker] , [Anita Gonyier: Anita Gonyier] , [Anna Van Otterloo: Anna Van Otterloo] , ...49 more... )
• CorrespondenceType ( type: esriFieldTypeString, alias: Correspondence Type, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CorrespondenceType , Coded Values: [Email: Email] , [Face to Face Conversation: Face to Face Conversation] , [Telephone Conversation: Telephone Conversation] , ...4 more... )
• Date ( type: esriFieldTypeDate, alias: Date of Correspondence, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Date )
• Note ( type: esriFieldTypeString, alias: Note, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: Note )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• ID ( type: esriFieldTypeInteger, alias: Inspection ID, editable: true, nullable: true, defaultValue: null, modelName: ID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• ParentGUID ( type: esriFieldTypeGUID, alias: Parent GUID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: ParentGUID )
Templates:
• Name: Inspection Correspondence
  Description:
  Prototype:
  ParentGUID: null
  ID: null
  Inspector1: null
  CorrespondenceType: null
  Date: null
  Note: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• Summer Sidewalk Inspection (0) -- Related To: Sidewalk Inspection (0)