Name: MRB_Survey_V4_CopyFeatures

Display Field: what_is_the_estate_name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -1.38019385999996
YMin: 52.5395963600002
XMax: -1.38019385999996
YMax: 52.5395963600002
Spatial Reference: 4326 (4326)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriPMS","url":"60e7b36d015d0c1629c5d2cf759f702b","imageData":"iVBORw0KGgoAAAANSUhEUgAAAA4AAAATCAYAAACgADyUAAAACXBIWXMAAA7EAAAOxAGVKw4bAAACqUlEQVQ4jZ2TUWiTVxTHf9/NlzRp0mhCa43C8GVTKEhRKoxRmK6gCL6kdWxMZPPFvgki+iIakb2VvshGaUcnYw+Co5tC7YPSivVBcfiw0oEddiUdGtomLU3SfPm+757rQ7JQuz7twOXC/5zfOecezrX5n2ZvFbq//T0VsK1zCjlqDPioSUfp0ReXj+S2BTsys6FEsPxje9uOdFMoFLYshQFE5DOn6l4N3Hz+a1HHvpnNdLgNcF9mKtxsb/ycaG1Lu5ayNhwDaAxgBJQKRZKtbV86S/ngvszU2YXMUccGiPnhk5F4vDcaCtAet1kq+rxd9zEGPtrVREDBzBttRaMtp5189Q4wZgMYZfdXCfDph1HOf5Jk+nWZK/dzBCy41Zei7Ao9382jlA12qL8BVoVOqhpfBICDe8O4WjjTlaDJtii54Pi19j2hs/FGT+tmtKBrHK+XXXo743x1eCfLJR9lgSeCGIOnpbkB+sgiIgdq44B7s2tcP57C04Yn8yUO7Y3giyAGxJLFBmi0Ny5GDoiplZz6q8iNEylGnq2wuyWIAbSR2pS1N94AXV8NByvFi4Y2C2BhzeXzn+b5M+dw/XgKAG0MUikZ31fDDXBlsHuu9dLkqYGH83cGH+diWBZP/y4BcOG3RYwIxquUtHa+WBk8Nvfe5qwMHHuQ6B/72I4nf1FN8f1YVs1hDNpZf6WLhb7VofTs1pULAJHVoXQhlPwg3fL16CMVS6YApFx4W7x9Lu0WsmtAFKgA2t6UoB3Y7RaykcrMxEi4q+8agDMzMeIWsnuABJAD/tkMamC9Xjnmvrw7HeroyQO4L+9OAwWgVI/Rm1v1gXzdEfTz2WZTXPoBwM9n/wA2AK9+5L3h1IUq4AJlFbC+r+vL9dtsiv3vR/43YHX4bHYbX8PeAe7sOQL3GxS5AAAAAElFTkSuQmCC","contentType":"image/png","width":10,"height":14,"angle":0,"xoffset":0,"yoffset":9},"label":"MRB Survey V4","description":"Survey Data Locations"},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: true

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field: globalid

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: ObjectID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• Functional_Location (type: esriFieldTypeString, alias: Functional Location ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• OS_TOPO_TOID (type: esriFieldTypeString, alias: OS Topo Toid, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• what_is_the_estate_name (type: esriFieldTypeString, alias: Estate name (if applicable), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Address_line_1 (type: esriFieldTypeString, alias: Address line 1, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Address_line_2 (type: esriFieldTypeString, alias: Address line 2, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• TownCity (type: esriFieldTypeString, alias: Town/City, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Postcode (type: esriFieldTypeString, alias: Postcode, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• LDZ (type: esriFieldTypeString, alias: LDZ, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• Building_owner_contact_details (type: esriFieldTypeString, alias: Building owner contact details, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Building_owner_description (type: esriFieldTypeString, alias: Description of building owner, SQL Type: sqlTypeOther, length: 17, nullable: true, editable: true)
• Building_CustomerCategory (type: esriFieldTypeString, alias: Type of Building Use, SQL Type: sqlTypeOther, length: 11, nullable: true, editable: true)
• Year_of_construction (type: esriFieldTypeInteger, alias: Estimated year of construction, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Number_of_storeys (type: esriFieldTypeInteger, alias: Number of storeys, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Number_of_flats_per_storey (type: esriFieldTypeInteger, alias: Number of flats per storey, SQL Type: sqlTypeOther, nullable: true, editable: true)
• number_of_flats_in_the_building (type: esriFieldTypeInteger, alias: Total number of flats in the building, SQL Type: sqlTypeOther, nullable: true, editable: true)
• building_height (type: esriFieldTypeString, alias: Building height (m), SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• survey_reason (type: esriFieldTypeString, alias: Reason for survey, SQL Type: sqlTypeOther, length: 9, nullable: true, editable: true)
• asbestos_report (type: esriFieldTypeString, alias: Has an asbestos report been made available?, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• est_num_flats_gas_supply (type: esriFieldTypeInteger, alias: Number of flats in building with gas supply, SQL Type: sqlTypeOther, nullable: true, editable: true)
• susceptible_disprop_collapse (type: esriFieldTypeString, alias: Is building susceptible to disproportional collapse?, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• Num_of_Pri_Vcs (type: esriFieldTypeInteger, alias: Approximate number of Priority or Vulnerable customers, SQL Type: sqlTypeOther, nullable: true, editable: true)
• area_crime (type: esriFieldTypeString, alias: Is the area known for high crime or vandalism?, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• pressure_test (type: esriFieldTypeDate, alias: Date of last pressure test, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• soundness_test (type: esriFieldTypeDate, alias: Date of last soundness test, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• corrosion_records (type: esriFieldTypeString, alias: Have previous corrosion records been identified?, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• Date_of_survey (type: esriFieldTypeDate, alias: Start date of survey, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Name_of_Surveyor (type: esriFieldTypeString, alias: Name of Surveyor, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• eusr_number (type: esriFieldTypeString, alias: Payroll Number / EUSR number of surveyor, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• reason_for_not_doing_survey (type: esriFieldTypeString, alias: If survey not done reason for not undertaking survey:, SQL Type: sqlTypeOther, length: 24, nullable: true, editable: true)
• Meter_Location (type: esriFieldTypeString, alias: Location of Meter, SQL Type: sqlTypeOther, length: 28, nullable: true, editable: true)
• Type_of_entry (type: esriFieldTypeString, alias: Type of entry, SQL Type: sqlTypeOther, length: 11, nullable: true, editable: true)
• Condition_of_entry (type: esriFieldTypeString, alias: Condition of entry (where visible check inside and out), SQL Type: sqlTypeOther, length: 18, nullable: true, editable: true)
• Condition_of_Pipe_entry_to_ECV (type: esriFieldTypeString, alias: Condition of pipe from entry to ECV, SQL Type: sqlTypeOther, length: 18, nullable: true, editable: true)
• Is_ECV_accessible (type: esriFieldTypeString, alias: Is ECV accessible?, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• ECV_secured_against_operation (type: esriFieldTypeString, alias: Is ECV secured against unauthorised operation, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• Does_ECV_appear_operable (type: esriFieldTypeString, alias: Does ECV appear operable (no functional test required), SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• Is_there_a_PIV (type: esriFieldTypeString, alias: Is there a PIV, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• check_gas_escape (type: esriFieldTypeString, alias: Has the check for a network gas escape inside and outside the building been completed, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• Was_an_escape_detected (type: esriFieldTypeString, alias: Was an escape detected, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• Location_of_Escapes (type: esriFieldTypeString, alias: Record location of escape(s) detected if any, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• IGTDetail (type: esriFieldTypeString, alias: Name of IGT (also provide picture of building), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• MidRiseBuilding (type: esriFieldTypeInteger, alias: Number of above ground habitable floors containing riser pipes (also provide picture of building), SQL Type: sqlTypeOther, nullable: true, editable: true)
• Name_of_enterprise (type: esriFieldTypeString, alias: Name of enterprise / organisation (also provide picture of building), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ConfirmNoGas (type: esriFieldTypeString, alias: I confirm that there is no gas supply within the building, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• BuildingDemolished (type: esriFieldTypeString, alias: I confirm that the building has been demolished (also provide picture), SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• ExtraInformation (type: esriFieldTypeString, alias: Extra Information, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• OOSNote (type: esriFieldTypeString, alias: Note: *CHECK FOR AN ESCAPE OF GAS USING INTRINSICALLY SAFE DEVICE ONLY INSIDE PREMISES *GAS ESCAPE CHECKS SHOULD TAKE PLACE OUTSIDE THE BUILDING ALONG LINE OF PIPE TO BUILDING UP TO THE ENTRY AND INSIDE UP TO AND INCLUDING THE METER POSITION *CHECK METER FOR EVIDENCE OF POTENTIAL THEFT OF GAS *ALL ESCAPES AND OTHER EMERGENCIES THAT ARE DETECTED SHOULD BE ACTIONED IMMEDIATELY, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Building_construction_type (type: esriFieldTypeString, alias: Building construction type, SQL Type: sqlTypeOther, length: 18, nullable: true, editable: true)
• Cellar_Basement_Underground_Gar (type: esriFieldTypeString, alias: Is there a Cellar Basement or Underground Garage?, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• asbestos_acm_check (type: esriFieldTypeString, alias: Does the Asbestos report indicate the presence of Asbestos or ACM in the building?, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• Dia_current_riser_net_available (type: esriFieldTypeString, alias: Diagram displaying current riser network available?, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• Meter_pos_and_config (type: esriFieldTypeString, alias: Meter positions and configurations, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Gas_load (type: esriFieldTypeString, alias: Gas load, SQL Type: sqlTypeOther, length: 29, nullable: true, editable: true)
• building_mods_pipework_Safety (type: esriFieldTypeString, alias: Is there evidence of any external building modifications that could affect the safety of the network pipework?, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• evi_unauth_con_tamp_vand (type: esriFieldTypeString, alias: For the aspects of the building surveyed, is there any evidence of unauthorised connections/tampering?, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• Building_mods_Detail (type: esriFieldTypeString, alias: Details of unauthorised connections/tampering, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Grp_SurveyDetails_Validation (type: esriFieldTypeString, alias: Grp_SurveyDetails_Validation, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Operating_Pressure (type: esriFieldTypeString, alias: Operating Pressure, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• mrps_risk_score (type: esriFieldTypeInteger, alias: MRPS Risk Score, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ext_leak_survey_undertaken (type: esriFieldTypeString, alias: Has an external leakage survey been undertaken?, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• Number_of_external_leaks_found (type: esriFieldTypeInteger, alias: Number of external leaks found, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Pipe_leak_location (type: esriFieldTypeString, alias: Please indicate the leak locations, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• gas_leaks_been_fixed (type: esriFieldTypeString, alias: Have all identified gas leaks been repaired?, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• Ground_Coverage_Type (type: esriFieldTypeString, alias: Ground Coverage Type, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• Grp_SupplyPipes_Validation (type: esriFieldTypeString, alias: Grp_SupplyPipes_Validation, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Number_of_Risers (type: esriFieldTypeInteger, alias: Number of Risers, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Grp_Risers_Validation (type: esriFieldTypeString, alias: Grp_Risers_Validation, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Length_Laterals (type: esriFieldTypeDouble, alias: Length of Laterals (m), SQL Type: sqlTypeOther, nullable: true, editable: true)
• Num_LateralGrps (type: esriFieldTypeInteger, alias: Number of lateral groups, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Lat_ST_horizontal_pipe_supports (type: esriFieldTypeString, alias: Do all steel horizontal Lateral pipes have supports at least once every 3m? , SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• int_dist_pipe_made_of_steel (type: esriFieldTypeString, alias: All internal distribution pipework steel, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• int_lats_len_g2m (type: esriFieldTypeString, alias: Have any internal lateral lengths greater than 2m been found?, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• Lat_jointsNotWelded (type: esriFieldTypeString, alias: Any internal lateral greater than 2m with joints other then welded?, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• flex_con_used_on_lat (type: esriFieldTypeString, alias: Are flexible connections used within the lateral to accommodate thermal expansion movement of the riser?, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• liv_fitted (type: esriFieldTypeString, alias: Is a LIV fitted to each internal lateral surveyed serving individual dwellings?, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• LIV_Pic_desc (type: esriFieldTypeString, alias: LIV Picture Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• liv_identification (type: esriFieldTypeString, alias: Are the LIVs surveyed clearly identified as a gas valve?, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• liv_prevent_unauthorised_op (type: esriFieldTypeString, alias: Do the LIVs surveyed prevent unauthorised operation?, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• liv_accessible (type: esriFieldTypeString, alias: Are LIVs accessible for operation and maintenance?, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• ECV_installed (type: esriFieldTypeString, alias: For dwellings accessed has an ECV been installed on the inlet to each individual meter installation?, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• ECV_accessible (type: esriFieldTypeString, alias: Are the ECVs surveyed accessible?, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ECV_key_securely_attached (type: esriFieldTypeString, alias: Is the ECV key or lever securely attached to the operating spindle?, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• Fire_Stopping_precence_of_TCOs (type: esriFieldTypeString, alias: Are there any Thermal Cut Off valves (TCOs) connected to the lateral surveyed?, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• percentage_lateral_surveyed (type: esriFieldTypeDouble, alias: Percentage of lateral group surveyed, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Grp_Laterals1_Validation (type: esriFieldTypeString, alias: Grp_Laterals1_Validation, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Length_Laterals_C (type: esriFieldTypeString, alias: Val: Length of Laterals (m), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Num_LateralGrps_C (type: esriFieldTypeString, alias: Val: Number of lateral groups, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Lat_ST_horiz_pipe_supports_C (type: esriFieldTypeString, alias: Val: Do all steel horizontal Lateral pipes have supports at least once every 3m?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• int_dist_pipe_made_of_steel_C (type: esriFieldTypeString, alias: Val: All internal distribution pipework steel, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• int_lats_len_g2m_C (type: esriFieldTypeString, alias: Val: Have any internal lateral lengths greater than 2m been found?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Lat_jointsNotWelded_C (type: esriFieldTypeString, alias: Val: Any internal lateral greater than 2m with joints other then welded?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• flex_con_used_on_lat_C (type: esriFieldTypeString, alias: Val: Are flexible connections used within the lateral to accommodate thermal expansion movement of the riser?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• liv_fitted_C (type: esriFieldTypeString, alias: Val: Is a LIV fitted to each internal lateral surveyed serving individual dwellings?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ECV_installed_C (type: esriFieldTypeString, alias: Val: For dwellings accessed has an ECV been installed on the inlet to each individual meter installation?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ECV_accessible_C (type: esriFieldTypeString, alias: Val: Are the ECVs surveyed accessible?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ECV_key_securely_attached_C (type: esriFieldTypeString, alias: Val: Is the ECV key or lever securely attached to the operating spindle?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Fire_Stop_precence_of_TCOs_C (type: esriFieldTypeString, alias: Val: Are there any Thermal Cut Off valves (TCOs) connected to the lateral surveyed?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• buildingFeatures_damage (type: esriFieldTypeString, alias: Is there any evidence of internal building features causing damage to the gas asset?, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• evac_pipework_escapeRoute (type: esriFieldTypeString, alias: Evacuation; Any gas pipework located on an escape route?, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• mtrs_in_sole_of_esc_ind_dwell (type: esriFieldTypeString, alias: Evac; Are any meters installed in a sole means of escape of an individual dwelling? If yes are they fitted with TCOs?, SQL Type: sqlTypeOther, length: 9, nullable: true, editable: true)
• com_means_esc_free_gas_meters (type: esriFieldTypeString, alias: Evac; Are common means of escape free of gas meters? (including any meter cupboard opening onto the common means of escape), SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• min_1100mm_acc_all_FF_stairs (type: esriFieldTypeString, alias: Evac; Does any network pipework compromise a minimum of 1100mm access within all firefighting staircases? Where there is only one staircase in the building this by default will be the firefighting staircase, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• wheelchair_refuge (type: esriFieldTypeString, alias: Evac; Where a wheelchair refuge is present in an escape way have any of Cadent's assets reduced it to less than 900mm x 1400mm?, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• pass_through_dwelling (type: esriFieldTypeString, alias: Does any network pipework pass through dwelling except for supply?, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• aban_pipework_decomm (type: esriFieldTypeString, alias: Is any pipework identified as abandoned fully decommissioned?, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• steel_joint_compliance (type: esriFieldTypeString, alias: On surveyed pipework have any risks been identified with the jointing method utilised?, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• screwed_valve (type: esriFieldTypeString, alias: For surveyed pipework has a screwed valve been introduced into to a welded system?, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• copper_susceptible_stolen (type: esriFieldTypeString, alias: Is there any copper gas pipework upstream of the ECV susceptible to theft or damage?, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• vertical_copper_20m (type: esriFieldTypeString, alias: For surveyed pipework is there any vertical copper present upstream of an ECV >20m in length?, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• exposed_pe (type: esriFieldTypeString, alias: PE; Any exposed PE observed?, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• exposed_pe_sunlight (type: esriFieldTypeString, alias: PE; Is any exposed PE observed protected from sunlight?, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• pe_fireResSteel (type: esriFieldTypeString, alias: PE; Is any PE present in a fire resistant steel system?, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• all_network_pipework_ventilated (type: esriFieldTypeString, alias: Venting & Ducting; Is all network pipework ventilated?, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• vent_at_high_and_low_level (type: esriFieldTypeString, alias: Venting & Ducting; Are any sections of network pipework surveyed within ducts containing other services?, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• ducts_containing_other_services (type: esriFieldTypeString, alias: Venting & Ducting; Are any sections of network pipework in ducts containing other services, SQL Type: sqlTypeOther, length: 18, nullable: true, editable: true)
• panels_maint_fire_res_of_duct (type: esriFieldTypeString, alias: Venting & Ducting; Are access panels fitted to network pipework ducts?, SQL Type: sqlTypeOther, length: 17, nullable: true, editable: true)
• Presence_of_decorative_ducting (type: esriFieldTypeString, alias: Venting & Ducting; Presence of decorative ducting (e.g. not installed by Cadent to hide pipe), SQL Type: sqlTypeOther, length: 19, nullable: true, editable: true)
• within_a_gastight_sleeve (type: esriFieldTypeString, alias: Venting & Ducting; Where network pipework is in an unventilated void is it contained within a gas tight sleeve?, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• firestop_lat_ducting (type: esriFieldTypeString, alias: Fire Stopping; Where a Lateral is situated within ducting is the ducting of fire resisting construction?, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• firestop_lat_standard (type: esriFieldTypeString, alias: Fire Stopping; Does the fire stopping maintain the fire-stopping standard for the fire-separating element? i.e. 30 mins 120 mins etc.?, SQL Type: sqlTypeOther, length: 11, nullable: true, editable: true)
• firestop_lat_ducting_Mat (type: esriFieldTypeString, alias: What materials have been used for the construction of the ducting?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• firestop_lat_painted (type: esriFieldTypeString, alias: Has any ducting been painted?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Grp_compliance_Validation (type: esriFieldTypeString, alias: Grp_compliance_Validation, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• survey_status (type: esriFieldTypeString, alias: Status, SQL Type: sqlTypeOther, length: 11, nullable: true, editable: true)
• completion_date (type: esriFieldTypeDate, alias: Completion Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• CompDate_C (type: esriFieldTypeString, alias: CompDate_C, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• approval_status (type: esriFieldTypeString, alias: Approved?, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• approver_name (type: esriFieldTypeString, alias: Name of approver, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• relatedwork_comment (type: esriFieldTypeString, alias: Further Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• BatchLog (type: esriFieldTypeString, alias: BatchLog, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• BatchProcessed (type: esriFieldTypeString, alias: BatchProcessed, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SupplyFilterC (type: esriFieldTypeString, alias: SupplyFilterC, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• RiserFilterC (type: esriFieldTypeString, alias: RiserFilterC, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• RiserExternalS (type: esriFieldTypeString, alias: RiserExternalS, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• RiserShaftS (type: esriFieldTypeString, alias: RiserShaftS, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• FormVersion (type: esriFieldTypeString, alias: FormVersion, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SurveyInError (type: esriFieldTypeString, alias: Survey Created in Error, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• SurveyInErrorComment (type: esriFieldTypeString, alias: Survey Created in Reason, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: true)
• EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: true)
• Building_owner_description_C (type: esriFieldTypeString, alias: Val: Description of building owner, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Number_of_flats_per_storey_C (type: esriFieldTypeString, alias: Val: Number of flats per storey, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• number_of_flats_in_the_buildi_1 (type: esriFieldTypeString, alias: Val: Number of flats in the building, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• reason_for_not_doing_survey_C (type: esriFieldTypeString, alias: Val: Reason for not doing survey, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• the_level_of_corrosion_C (type: esriFieldTypeString, alias: VAL: Whats is the level of corrosion?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• TotalSPRiskScore (type: esriFieldTypeDouble, alias: Total Supply Risk Score, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TotalRiserRiskScore (type: esriFieldTypeDouble, alias: Total Riser Risk Score, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TotalLateralRiskScore (type: esriFieldTypeDouble, alias: Total Lateral Risk Score, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RiskScore (type: esriFieldTypeDouble, alias: RiskScore, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CollectorNote (type: esriFieldTypeString, alias: Use Collector App to complete the Survey, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• further_reasons_OOS (type: esriFieldTypeString, alias: Have you identified any other out of scope reasons?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• corrosion_identified_OutOfScope (type: esriFieldTypeString, alias: Any corrosion identified on Out of Scope Building?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Sketch_Pipework_Undertaken (type: esriFieldTypeString, alias: Sketch of Pipework Undertaken, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• above_ground_pipework_labelled (type: esriFieldTypeString, alias: Are all above ground network pipelines labelled?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Meter_position (type: esriFieldTypeString, alias: Meter Positions, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• MeterPosition_ExplainOther (type: esriFieldTypeString, alias: Explain Other, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• meterbank_declaration (type: esriFieldTypeString, alias: Meter bank Declaration, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• meterbank_labelled (type: esriFieldTypeString, alias: Meter bank appropriately labelled within sight of the meters and ECVs, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• General_FollowOnWork_Count (type: esriFieldTypeString, alias: General_FollowOnWork_Count, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Val_Building_Construction_Type (type: esriFieldTypeString, alias: Val: Building Construction Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Val_Cellar_Basement_UG_Gar (type: esriFieldTypeString, alias: Val: Cellar Basement Underground Garage, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Val_Dia_current_riser_net_avail (type: esriFieldTypeString, alias: Val: Diagram displaying current riser network available on-site?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Val_Number_External_leaks_found (type: esriFieldTypeString, alias: Val: Number of external leaks found, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ECV_labelled (type: esriFieldTypeString, alias: ECVs seen appropriately labelled?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ECV_key_attachment_rectified (type: esriFieldTypeString, alias: Has this been rectified during the survey?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ECV_key_Not_attached_location (type: esriFieldTypeString, alias: Please provide location details, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Val_ECV_key_attachmeent_rectifi (type: esriFieldTypeString, alias: Val: ECV - Has this been rectified during the survey?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• LateralGroup_FollowOnWork_Count (type: esriFieldTypeString, alias: LateralGroup_FollowOnWork_Count, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• missing_labels_rectified (type: esriFieldTypeString, alias: Have all missing labels been rectified during survey?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• reason_not_rectified (type: esriFieldTypeString, alias: Please provide details, including location (Label type, internal/external/communal area/flat number etc), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• pipework_close_proximity_to_uti (type: esriFieldTypeString, alias: Is any pipework too close in proximity (within 150mm for electric) or being impacted by other utilities?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• details_proximity_to_utilities (type: esriFieldTypeString, alias: Please provide detail, including locations, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• identified_open_ended_pipe (type: esriFieldTypeString, alias: Have you identified any open ended decomissioned pipes?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• rectified_open_ended_pipes (type: esriFieldTypeString, alias: Have these been capped during the survey?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• escalation_to_supervisor (type: esriFieldTypeString, alias: Have any issues been escalated to your supervisor / MOB lead?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• escalation_reason (type: esriFieldTypeString, alias: Briefly explain what has been escalated., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• exposed_pe_internal_external (type: esriFieldTypeString, alias: PE; Is exposed PE internal or external?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Pipe_encased_in_ducting (type: esriFieldTypeString, alias: Is the pipe encased in ducting?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• where_not_ventilated (type: esriFieldTypeString, alias: Please provide details including location, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Compliance_FollowOnWork_Count (type: esriFieldTypeString, alias: Compliance_FollowOnWork_Count, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Val_rectified_open_ended_pipes (type: esriFieldTypeString, alias: Val: Have these been capped during the survey, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Val_missing_labels_rectified (type: esriFieldTypeString, alias: Val: Have all missing labels been rectified during survey?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Val_Pipe_encased_in_ducting (type: esriFieldTypeString, alias: Val: Is the pipe encased in ducting?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Val_all_network_pipework_ventil (type: esriFieldTypeString, alias: Val: Venting & Ducting; Is all network pipework ventilated where required?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Val_ducts_containing_other_serv (type: esriFieldTypeString, alias: Val: Venting & Ducting; Are any sections of network pipework in ducts containing other services, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Val_panels_maint_fire_res_of_du (type: esriFieldTypeString, alias: Val: Venting & Ducting; Are access panels fitted to network pipework ducts?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Val_Presence_of_decorative_duct (type: esriFieldTypeString, alias: Val: Venting & Ducting; Presence of decorative boxing (e.g. not installed by Cadent to hide pipe), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Val_within_a_gastight_sleeve (type: esriFieldTypeString, alias: Val: Venting & Ducting; Where network pipework is in an unventilated void is it contained within a gas tight sleeve?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Val_pipework_close_proximity_to (type: esriFieldTypeString, alias: Val: Is any pipework too close in proximity (within 150mm for electric) or being impacted by other utilities?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Val_exposed_pe_internal_externa (type: esriFieldTypeString, alias: Val: PE; Is exposed PE internal or external?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• letterbox_declaration (type: esriFieldTypeString, alias: Letter Box Check Declaration, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Val_letterbox_declaration (type: esriFieldTypeString, alias: Val: Letter Box Check Declaration, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Val_Flat_contains_BaseOfRiser (type: esriFieldTypeString, alias: Val: Flat contains base of riser, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• RiserInternalS (type: esriFieldTypeString, alias: RiserInternalS, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Sum_SupplyPipe_FOW (type: esriFieldTypeInteger, alias: Sum_SupplyPipe_FOW, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Sum_PIV_FOW (type: esriFieldTypeInteger, alias: Sum_PIV_FOW, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Sum_IIV_FOW (type: esriFieldTypeInteger, alias: Sum_IIV_FOW, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Sum_RiserDetail_FOW (type: esriFieldTypeInteger, alias: Sum_RiserDetail_FOW, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Sum_LateralDetail_FOW (type: esriFieldTypeInteger, alias: Sum_LateralDetail_FOW, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FollowOnWork_Count (type: esriFieldTypeString, alias: FollowOnWork_Count, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Number_return_Assurance_Queries (type: esriFieldTypeInteger, alias: Number of returns to Assurance Queries, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Assurance_Query (type: esriFieldTypeString, alias: Assurance Query, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Assurance_Resolution (type: esriFieldTypeString, alias: Assurance Query Resolution, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Grp_SupplyPipe_PIV_Count_Valida (type: esriFieldTypeString, alias: Grp_SupplyPipe_PIV_Count_Validation, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• FOW_WO_Raised (type: esriFieldTypeInteger, alias: Number of FOW Work orders raised, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Risers_feed_external_supply (type: esriFieldTypeString, alias: Are any of the risers feed by more than one external supply pipe, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Riser_linkage (type: esriFieldTypeString, alias: Provide details on riser linkage, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• val_risers_feed_external_supply (type: esriFieldTypeString, alias: Val: Risers feed by more than one external supply pipe, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• val_riser_linkage (type: esriFieldTypeString, alias: Val: Riser linkage details, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• building_change_impact_network (type: esriFieldTypeString, alias: Has the building been changed so that it impacts on the gas network pipework ?, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Val_building_change_impact_netw (type: esriFieldTypeString, alias: Val:  Building changed so that it impacts gas network pipework, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)

Templates:

Name: MRB_Survey_V4_CopyFeatures
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 2/10/2022 9:01:38 AM

Schema Last Edit Date: 2/10/2022 9:01:38 AM

Data Last Edit Date: 2/10/2022 9:01:38 AM

Supported Operations:   Query   Query Top Features   Query Analytic   Query Bins   Query Attachments   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat