Layers:

Layer: Residential Exceptions Inspection (0)

Name: Residential Exceptions Inspection

Display Field: CaseNo

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 4bc502c96e714b8f903ed6c02727b710

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

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: 2132262.4855000004
YMin: 1239324.5825000033
XMax: 2224404.877750002
YMax: 1327619.5914999992
Spatial Reference: 102630  (102630)



Drawing Info:
Renderer:
Unique Value Renderer:
Field 1: Inspection_Status
Field 2: null
Field 3: null
Field Delimiter: ,
Default Symbol:
N/A
Default Label: null
UniqueValueInfos:
• Value: 10
  Label: No Inspection
  Description:
  Symbol:
  
• Value: 80
  Label: Emergency - Pending Inspection
  Description:
  Symbol:
  
• Value: 20
  Label: Pending Inspection
  Description:
  Symbol:
  
• Value: 90
  Label: Emergency - Inspection Complete
  Description:
  Symbol:
  
• Value: 30
  Label: Inspection Complete
  Description:
  Symbol:
  
• Value: 100
  Label: Emergency - Sent to Contractor
  Description:
  Symbol:
  
• Value: 40
  Label: Sent to Contractor
  Description:
  Symbol:
  
• Value: 50
  Label: Structure Down
  Description:
  Symbol:
  
• Value: 60
  Label: Lot Cleaned Up
  Description:
  Symbol:
  
• Value: 70
  Label: Hold
  Description:
  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


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• CaseNo ( type: esriFieldTypeString, alias: CaseNo, length: 14 )
• ParcelID ( type: esriFieldTypeString, alias: ParcelID, length: 30 )
• Address ( type: esriFieldTypeString, alias: Address, length: 92 )
• Address_Verified ( type: esriFieldTypeInteger, alias: Address Verified , Coded Values: [10: YES] , [20: NO] )
• Address_Notes ( type: esriFieldTypeString, alias: Address Notes, length: 255 )
• Building_Length ( type: esriFieldTypeSmallInteger, alias: Building_Length )
• Building_Width ( type: esriFieldTypeSmallInteger, alias: Building_Width )
• No_of_Stories ( type: esriFieldTypeSmallInteger, alias: No of Stories )
• BuildingSqFt ( type: esriFieldTypeSmallInteger, alias: BuildingSqFt )
• AsbestosStatus ( type: esriFieldTypeInteger, alias: AsbestosStatus , Coded Values: [10: Present] , [20: Abated] , [30: Not Found] )
• Property_Type ( type: esriFieldTypeInteger, alias: Property_Type , Coded Values: [10: RESIDENDTIAL] , [20: NONRESIDENTIAL] , [30: OTHER] )
• Water ( type: esriFieldTypeInteger, alias: Water , Coded Values: [10: YES] , [20: NO] )
• Gas ( type: esriFieldTypeInteger, alias: Gas , Coded Values: [10: YES] , [20: NO] )
• Sewer ( type: esriFieldTypeInteger, alias: Sewer , Coded Values: [10: YES] , [20: NO] )
• Power ( type: esriFieldTypeInteger, alias: Power , Coded Values: [10: YES] , [20: NO] )
• ACM ( type: esriFieldTypeInteger, alias: ACM , Coded Values: [10: YES] , [20: NO] )
• Burned_Percentage ( type: esriFieldTypeSmallInteger, alias: Burned_Percentage )
• Driveway_Length ( type: esriFieldTypeSmallInteger, alias: Driveway_Length )
• Driveway_Width ( type: esriFieldTypeSmallInteger, alias: Driveway_Width )
• Concrete_Slab_Length ( type: esriFieldTypeSmallInteger, alias: Concrete_Slab_Length )
• Concrete_Slab_Width ( type: esriFieldTypeSmallInteger, alias: Concrete_Slab_Width )
• Garage_Length ( type: esriFieldTypeSmallInteger, alias: Garage_Length )
• Garage_Width ( type: esriFieldTypeSmallInteger, alias: Garage_Width )
• Large_Tree_Count ( type: esriFieldTypeSmallInteger, alias: Large_Tree_Count )
• Small_Tree_Count ( type: esriFieldTypeSmallInteger, alias: Small_Tree_Count )
• Aux_Bld_1_Length ( type: esriFieldTypeSmallInteger, alias: Aux_Bld_1_Length )
• Aux_Bld_1_Width ( type: esriFieldTypeSmallInteger, alias: Aux_Bld_1_Width )
• Aux_Bld_2_Length ( type: esriFieldTypeSmallInteger, alias: Aux_Bld_2_Length )
• Aux_Bld_2_Width ( type: esriFieldTypeSmallInteger, alias: Aux_Bld_2_Width )
• Aux_Bld_3_Length ( type: esriFieldTypeSmallInteger, alias: Aux_Bld_3_Lenght )
• Aux_Bld_3_Width ( type: esriFieldTypeSmallInteger, alias: Aux_Bld_3_Width )
• Driveway_2_Length ( type: esriFieldTypeSmallInteger, alias: Driveway_2_Length )
• Driveway_2_Width ( type: esriFieldTypeSmallInteger, alias: Driveway_2_Width )
• Slab_2_Length ( type: esriFieldTypeSmallInteger, alias: Slab_2_Length )
• Slab_2_Width ( type: esriFieldTypeSmallInteger, alias: Slab_2_Width )
• Quadrant ( type: esriFieldTypeString, alias: Quadrant, length: 2 )
• CaseStatus ( type: esriFieldTypeString, alias: CaseStatus, length: 255 )
• Inspection_Status ( type: esriFieldTypeInteger, alias: Insp Status , Coded Values: [10: No Inspection] , [20: Pending Inspection] , [30: Inspection Complete] , ...8 more... )
• Inspection_Notes ( type: esriFieldTypeString, alias: Inspection Notes, length: 255 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• 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 )
• Contractor ( type: esriFieldTypeString, alias: Contractor, length: 50 , Coded Values: [BOSTIC: Bostic Trucking & Excavating] , [BRITT: Britt Demolition & Recycling] , [CORINTH01: Corinth Company - Quad 1] , ...18 more... )
• Score ( type: esriFieldTypeInteger, alias: Score )
• Re_Use ( type: esriFieldTypeString, alias: Re-Use, length: 50 , Coded Values: [Residential: Residential] , [Commercial: Commercial] , [Mixed Use: Mixed Use] , ...2 more... )
• TitleDisposition ( type: esriFieldTypeString, alias: TitleDisposition, length: 25 , Coded Values: [Red: Red] , [Red - LBE: Red - LBE] , [Yellow: Yellow] , ...3 more... )
• RedevelopmentScore ( type: esriFieldTypeInteger, alias: RedevelopmentScore )
• Zoning ( type: esriFieldTypeString, alias: Zoning, length: 30 , Coded Values: [A-1: A-1] , [AG: AG] , [B1: B1] , ...43 more... )
• ReUseConceptualPlan ( type: esriFieldTypeString, alias: ReUseConceptualPlan, length: 20 , Coded Values: [Not Started: Not Started] , [In Progress: In Progress] , [Completed: Completed] )
• TitleCurrativeWork ( type: esriFieldTypeString, alias: TitleCurrativeWork, length: 20 , Coded Values: [Not Started: Not Started] , [In Progress: In Progress] , [Completed: Completed] )
• RevitalizationOptions ( type: esriFieldTypeString, alias: RevitalizationOptions, length: 30 , Coded Values: [Owner Rehab: Owner Rehab] , [Owner Sell: Owner Sell] , [City Acquire: City Acquire] , ...3 more... )
• ShortTermReUse ( type: esriFieldTypeString, alias: ShortTermReUse, length: 30 , Coded Values: [Property Upkeep: Property Upkeep] , [Temporary Reuse: Temporary Reuse] )
• LongTermReUse ( type: esriFieldTypeString, alias: LongTermReUse, length: 30 , Coded Values: [Structure Rehab: Structure Rehab] , [Infill Development: Infill Development] )

Relationships:

• exception_insps_table (0) -- Related To: sde.SDE.exception_insps_table (1)

Tables:

Table: sde.SDE.exception_insps_table (1)

Name: sde.SDE.exception_insps_table

Display Field: InspectionType

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 4bc502c96e714b8f903ed6c02727b710

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

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


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• InspectionDate ( type: esriFieldTypeDate, alias: InspectionDate, length: 8 )
• InspectionType ( type: esriFieldTypeString, alias: InspectionType, length: 30 , Coded Values: [Initial Inspection: Initial Inspection] , [Exception Inspection: Exception Inspection] , [Lot CleanUp Inspection: Lot CleanUp Inspection] , ...7 more... )
• InspectionNotes ( type: esriFieldTypeString, alias: InspectionNotes, length: 250 )
• LinkID ( type: esriFieldTypeInteger, alias: LinkID )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )

Relationships:

• exception_insps_point (0) -- Related To: Residential Exceptions Inspection (0)