Name: CRM DwellingInspection_Table

Display Field: ComplexName

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

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

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• ComplexName ( type: esriFieldTypeString, alias: ComplexName, length: 50 )
• Date ( type: esriFieldTypeDate, alias: Date, length: 8 )
• NumberRooms ( type: esriFieldTypeSmallInteger, alias: NumberRooms )
• NumberBedrooms ( type: esriFieldTypeSmallInteger, alias: NumberBedrooms )
• SquareFeet ( type: esriFieldTypeSmallInteger, alias: SquareFeet )
• W_WorkmanshipRepairs ( type: esriFieldTypeString, alias: 102.5, length: 50 , Coded Values: [Meets Code: Meets Code] , [Does Not Meet Code: Does Not Meet Code] )
• ES_StairsPorches ( type: esriFieldTypeString, alias: ES_StairsPorches, length: 50 , Coded Values: [Meets Code: Meets Code] , [Does Not Meet Code: Does Not Meet Code] )
• ES_HandrailsGuardrails ( type: esriFieldTypeString, alias: ES_HandrailsGuardrails, length: 50 , Coded Values: [Meets Code: Meets Code] , [Does Not Meet Code: Does Not Meet Code] )
• ES_WindowsDoorframes ( type: esriFieldTypeString, alias: ES_WindowsDoorframes, length: 50 , Coded Values: [Meets Code: Meets Code] , [Does Not Meet Code: Does Not Meet Code] )
• ES_Glazing ( type: esriFieldTypeString, alias: ES_Glazing, length: 50 , Coded Values: [Meets Code: Meets Code] , [Does Not Meet Code: Does Not Meet Code] )
• ES_OpenableWindow ( type: esriFieldTypeString, alias: ES_OpenableWindow, length: 50 , Coded Values: [Meets Code: Meets Code] , [Does Not Meet Code: Does Not Meet Code] )
• ES_InsectScreens ( type: esriFieldTypeString, alias: ES_InsectScreens, length: 50 , Coded Values: [Meets Code: Meets Code] , [Does Not Meet Code: Does Not Meet Code] )
• ES_DoorHardware ( type: esriFieldTypeString, alias: ES_DoorHardware, length: 50 , Coded Values: [Meets Code: Meets Code] , [Does Not Meet Code: Does Not Meet Code] )
• ES_BasemantHatchways ( type: esriFieldTypeString, alias: ES_BasemantHatchways, length: 50 , Coded Values: [Meets Code: Meets Code] , [Does Not Meet Code: Does Not Meet Code] )
• IS_SupportingStrMembers ( type: esriFieldTypeString, alias: IS_SupportingStrMembers, length: 50 , Coded Values: [Meets Code: Meets Code] , [Does Not Meet Code: Does Not Meet Code] )
• IS_SanitaryIntrSurface ( type: esriFieldTypeString, alias: IS_SanitaryIntrSurface, length: 50 , Coded Values: [Meets Code: Meets Code] , [Does Not Meet Code: Does Not Meet Code] )
• IS_NoAccumulation ( type: esriFieldTypeString, alias: IS_NoAccumulation, length: 50 , Coded Values: [Meets Code: Meets Code] , [Does Not Meet Code: Does Not Meet Code] )
• IS_NoInsectRatHarborage ( type: esriFieldTypeString, alias: IS_NoInsectRatHarborage, length: 50 , Coded Values: [Meets Code: Meets Code] , [Does Not Meet Code: Does Not Meet Code] )
• IS_Handrails ( type: esriFieldTypeString, alias: IS_Handrails, length: 50 , Coded Values: [Meets Code: Meets Code] , [Does Not Meet Code: Does Not Meet Code] )
• SC_RubbishDisposal ( type: esriFieldTypeString, alias: SC_RubbishDisposal, length: 50 , Coded Values: [Meets Code: Meets Code] , [Does Not Meet Code: Does Not Meet Code] )
• SC_GarbageDisposal ( type: esriFieldTypeString, alias: SC_DisposalGarbage, length: 50 )
• SC_RubbishGarbageContainers ( type: esriFieldTypeString, alias: SC_RubbishGarbageContainers, length: 50 )
• L_Window8Floor ( type: esriFieldTypeString, alias: L_Window8Gloor, length: 50 , Coded Values: [Meets Code: Meets Code] , [Does Not Meet Code: Does Not Meet Code] )
• L_Common60W200Sqft ( type: esriFieldTypeString, alias: L_Common60W200Sqft, length: 50 , Coded Values: [Meets Code: Meets Code] , [Does Not Meet Code: Does Not Meet Code] )
• V_Ventilation45Window ( type: esriFieldTypeString, alias: V_Ventilation45Window, length: 50 , Coded Values: [Meets Code: Meets Code] , [Does Not Meet Code: Does Not Meet Code] )
• V_ToiletRoom ( type: esriFieldTypeString, alias: V_ToiletRoom, length: 50 , Coded Values: [Meets Code: Meets Code] , [Does Not Meet Code: Does Not Meet Code] )
• OL_SleepingRmAccess ( type: esriFieldTypeString, alias: OL_SleepingRmAccess, length: 50 , Coded Values: [Meets Code: Meets Code] , [Does Not Meet Code: Does Not Meet Code] )
• OL_SleepingAreaRatio ( type: esriFieldTypeString, alias: OL_SleepingAreaRatio, length: 50 , Coded Values: [Meets Code: Meets Code] , [Does Not Meet Code: Does Not Meet Code] )
• OL_WaterClosetAccess ( type: esriFieldTypeString, alias: OL_WaterClosetAccess, length: 50 , Coded Values: [Meets Code: Meets Code] , [Does Not Meet Code: Does Not Meet Code] )
• OL_Overcrowding ( type: esriFieldTypeString, alias: OL_Overcrowding, length: 50 , Coded Values: [Meets Code: Meets Code] , [Does Not Meet Code: Does Not Meet Code] )
• OL_NonhabitSleepSpaces ( type: esriFieldTypeString, alias: OL, length: 50 , Coded Values: [Meets Code: Meets Code] , [Does Not Meet Code: Does Not Meet Code] )
• OL_FoodPrepSanitary ( type: esriFieldTypeString, alias: OL_FoodPrepSanitary, length: 50 , Coded Values: [Meets Code: Meets Code] , [Does Not Meet Code: Does Not Meet Code] )
• RF_RequiredFacilities ( type: esriFieldTypeString, alias: RF_RequiredFacilities, length: 50 , Coded Values: [Meets Code: Meets Code] , [Does Not Meet Code: Does Not Meet Code] )
• PF_ProperWaterConnections ( type: esriFieldTypeString, alias: PF_ProperWaterConnections, length: 50 , Coded Values: [Meets Code: Meets Code] , [Does Not Meet Code: Does Not Meet Code] )
• WS_HotColdWater ( type: esriFieldTypeString, alias: WS_HotColdWater, length: 50 , Coded Values: [Meets Code: Meets Code] , [Does Not Meet Code: Does Not Meet Code] )
• WS_ContFixturesProtected ( type: esriFieldTypeString, alias: WS_ContFixturesProtected, length: 50 , Coded Values: [Meets Code: Meets Code] , [Does Not Meet Code: Does Not Meet Code] )
• WS_WaterSupplyRequirements ( type: esriFieldTypeString, alias: WS_WaterSupplyRequirements, length: 50 , Coded Values: [Meets Code: Meets Code] , [Does Not Meet Code: Does Not Meet Code] )
• WS_WaterHeatingTemp ( type: esriFieldTypeString, alias: WS_WaterHeatingTemp, length: 50 , Coded Values: [Meets Code: Meets Code] , [Does Not Meet Code: Does Not Meet Code] )
• WS_TempPressReliefValve ( type: esriFieldTypeString, alias: WS_TempPressReliefValve, length: 50 , Coded Values: [Meets Code: Meets Code] , [Does Not Meet Code: Does Not Meet Code] )
• SDS_MaintenanceSewerSys ( type: esriFieldTypeString, alias: SDS_MaintenanceSewerSys, length: 50 , Coded Values: [Meets Code: Meets Code] , [Does Not Meet Code: Does Not Meet Code] )
• HF_HeatingFacilities ( type: esriFieldTypeString, alias: HF_HeatingFacilities, length: 50 , Coded Values: [Meets Code: Meets Code] , [Does Not Meet Code: Does Not Meet Code] )
• HF_HeatSupply ( type: esriFieldTypeString, alias: HF_HeatSupply, length: 50 , Coded Values: [Meets Code: Meets Code] , [Does Not Meet Code: Does Not Meet Code] )
• HF_InstallationMechEquip ( type: esriFieldTypeString, alias: HF_InstallationMechEquip, length: 50 , Coded Values: [Meets Code: Meets Code] , [Does Not Meet Code: Does Not Meet Code] )
• HF_FlueVentClearances ( type: esriFieldTypeString, alias: HF_FlueVentClearances, length: 50 , Coded Values: [Meets Code: Meets Code] , [Does Not Meet Code: Does Not Meet Code] )
• EF_ElectricalReceptacle ( type: esriFieldTypeString, alias: EF_ElectricalReceptacle, length: 50 , Coded Values: [Meets Code: Meets Code] , [Does Not Meet Code: Does Not Meet Code] )
• EF_LightFixtures ( type: esriFieldTypeString, alias: EF_LightFixtures, length: 50 , Coded Values: [Meets Code: Meets Code] , [Does Not Meet Code: Does Not Meet Code] )
• EF_Service ( type: esriFieldTypeString, alias: EF_service, length: 50 , Coded Values: [Meets Code: Meets Code] , [Does Not Meet Code: Does Not Meet Code] )
• ME_DirectExit ( type: esriFieldTypeString, alias: ME_DirectExit, length: 50 , Coded Values: [Meets Code: Meets Code] , [Does Not Meet Code: Does Not Meet Code] )
• ME_ExitSigns ( type: esriFieldTypeString, alias: ME_ExitSigns, length: 50 , Coded Values: [Meets Code: Meets Code] , [Does Not Meet Code: Does Not Meet Code] )
• ME_FireProtectionSystem ( type: esriFieldTypeString, alias: ME_FireProtectionSystem, length: 50 , Coded Values: [Meets Code: Meets Code] , [Does Not Meet Code: Does Not Meet Code] )
• ME_EmergencyEscapeOpenings ( type: esriFieldTypeString, alias: ME_EmergencyEscapeOpenings, length: 50 , Coded Values: [Meets Code: Meets Code] , [Does Not Meet Code: Does Not Meet Code] )
• FRR_FireResistRating ( type: esriFieldTypeString, alias: FRR_FireResistRating, length: 50 , Coded Values: [Meets Code: Meets Code] , [Does Not Meet Code: Does Not Meet Code] )
• E_OwnerRespExtermination ( type: esriFieldTypeString, alias: E_OwnerRespExtermination, length: 50 , Coded Values: [Meets Code: Meets Code] , [Does Not Meet Code: Does Not Meet Code] )
• SOURCETYPE ( type: esriFieldTypeString, alias: SOURCETYPE, length: 20 )
• FEATUREID ( type: esriFieldTypeString, alias: FEATUREID, length: 15 )
• REPLICAFILTER ( type: esriFieldTypeString, alias: REPLICAFILTER, length: 255 )
• DATECREATED ( type: esriFieldTypeDate, alias: DATECREATED, length: 8 )
• SOURCE ( type: esriFieldTypeString, alias: SOURCE, length: 20 )
• GEODBID ( type: esriFieldTypeString, alias: GEODBID, length: 3 )
• PRODUCTIONNOTES ( type: esriFieldTypeString, alias: PRODUCTIONNOTES, length: 100 )
• DATEMODIFIED ( type: esriFieldTypeDate, alias: DATEMODIFIED, length: 8 )
• CREATEDBY ( type: esriFieldTypeString, alias: CREATEDBY, length: 255 )
• MODIFIEDBY ( type: esriFieldTypeString, alias: MODIFIEDBY, length: 255 )
• GID_INSPECTION_POINT ( type: esriFieldTypeGUID, alias: GID_INSPECTION_POINT, length: 38 )
• PHONE ( type: esriFieldTypeInteger, alias: Phone )
• NAME ( type: esriFieldTypeString, alias: Name, length: 100 )
• NOTES ( type: esriFieldTypeString, alias: Notes, length: 255 )

Relationships:

• EnerGov_Inspection_POINT (2) -- Related To: CRM Code_Inspection_POINT (28)

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

  Iteminfo   Thumbnail   Metadata