Layers:

Layer: RAAC_Survey (2)


Name: RAAC_Survey

Display Field: objectid

Type: Feature Layer

Geometry Type: esriGeometryPoint

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -180
YMin: -90
XMax: 180
YMax: 90
Spatial Reference: 4326 (4326)


Drawing Info:

{"labelingInfo":null,"renderer":{"description":"Survey Data Locations","label":"RAAC Survey v1","symbol":{"angle":0,"color":[255,0,0,255],"outline":{"color":[255,255,0,255],"width":1},"size":8,"style":"esriSMSCircle","type":"esriSMS","xoffset":0,"yoffset":0},"type":"simple"},"transparency":0}

HasZ: false

HasM: false

Has Attachments: false

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: sqlTypeGUID, length: 38, nullable: false, editable: false)
• bldg_name (type: esriFieldTypeString, alias: Building, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Aldershot Justice Centre: Aldershot Justice Centre], [Amersham Law Courts: Amersham Law Courts], [Barkingside Magistrates Court: Barkingside Magistrates Court], ... 111 more ...)
• cal_bldg_ref (type: esriFieldTypeString, alias: cal_bldg_ref, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• cal_bldg_add1 (type: esriFieldTypeString, alias: cal_bldg_add1, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• bldg_add1 (type: esriFieldTypeString, alias: bldg_add1, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• cal_bldg_add2 (type: esriFieldTypeString, alias: cal_bldg_add2, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• bldg_add2 (type: esriFieldTypeString, alias: bldg_add2, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• cal_bldg_add3 (type: esriFieldTypeString, alias: cal_bldg_add3, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• bldg_add3 (type: esriFieldTypeString, alias: bldg_add3, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• cal_bldg_postcode (type: esriFieldTypeString, alias: cal_bldg_postcode, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• cal_bldg_contact (type: esriFieldTypeString, alias: cal_bldg_contact, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• cal_bldg_tele (type: esriFieldTypeString, alias: cal_bldg_tele, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• cal_bldg_email (type: esriFieldTypeString, alias: cal_bldg_email, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)

Templates:

Name: New Feature
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:


Relationships:
• RAAC_Survey_rpt_roof_survey (1) -- Related To: rpt_roof_survey (0)
Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 11/4/2020 9:37:17 AM

Schema Last Edit Date: 11/4/2020 9:37:17 AM

Data Last Edit Date: 11/4/2020 9:37:17 AM

Tables:

rpt_roof_survey (0)


Name: rpt_roof_survey

Display Field: objectid

Type: Table

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Description:

Copyright Text:

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: true

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

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: sqlTypeGUID, length: 38, nullable: false, editable: false)
• parent_bldg_ref1 (type: esriFieldTypeString, alias: parent_bldg_ref1, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• roof_name (type: esriFieldTypeString, alias: Roof Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• bldg_const_element (type: esriFieldTypeString, alias: Construction Element (Roof Slab), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Limited/No access - unable to assess/ascertain: Limited/No access - unable to assess/ascertain])
• bldg_roof_area (type: esriFieldTypeInteger, alias: Roof Area (m2), SQL Type: sqlTypeOther, nullable: true, editable: true)
• survey_weather (type: esriFieldTypeString, alias: Weather, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• cal_const_date (type: esriFieldTypeString, alias: cal_const_date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• bldg_roof_span (type: esriFieldTypeDouble, alias: Span (m), SQL Type: sqlTypeOther, nullable: true, editable: true)
• survey_date (type: esriFieldTypeDate, alias: Date of Survey, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• bldg_records (type: esriFieldTypeString, alias: Record Drawings Available, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• bldg_roof_depth (type: esriFieldTypeInteger, alias: Depth (mm), SQL Type: sqlTypeOther, nullable: true, editable: true)
• cal_depth_ratio (type: esriFieldTypeString, alias: cal_depth_ratio, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• bldg_constrcut_note (type: esriFieldTypeString, alias: Building Construction, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• bldg_schmidt_read1 (type: esriFieldTypeDouble, alias: Schmidt Hammer Reading 1, SQL Type: sqlTypeOther, nullable: true, editable: true)
• bldg_schmidt_read2 (type: esriFieldTypeDouble, alias: Schmidt Hammer Reading 2, SQL Type: sqlTypeOther, nullable: true, editable: true)
• bldg_schmidt_read3 (type: esriFieldTypeDouble, alias: Schmidt Hammer Reading 3, SQL Type: sqlTypeOther, nullable: true, editable: true)
• bldg_schmidt_read4 (type: esriFieldTypeDouble, alias: Schmidt Hammer Reading 4, SQL Type: sqlTypeOther, nullable: true, editable: true)
• bldg_schmidt_read5 (type: esriFieldTypeDouble, alias: Schmidt Hammer Reading 5, SQL Type: sqlTypeOther, nullable: true, editable: true)
• bldg_schmidt_read6 (type: esriFieldTypeDouble, alias: Schmidt Hammer Reading 6, SQL Type: sqlTypeOther, nullable: true, editable: true)
• cal_schmidt_hammer (type: esriFieldTypeString, alias: cal_schmidt_hammer, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• bldg_ext_fin (type: esriFieldTypeString, alias: External Surface Finishes (Type), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Felt: Felt], [Single Ply Membrane: Single Ply Membrane], [Asphalt: Asphalt], ... 5 more ...)
• bldg_int_fin (type: esriFieldTypeString, alias: Internal Ceiling Finishes (Type), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Plaster: Plaster], [Cement Render: Cement Render], [Unfinished/Exposed: Unfinished/Exposed], ... 3 more ...)
• bldg_surface_drainage (type: esriFieldTypeString, alias: Surface Water Drainage, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [External: External], [Internal: Internal], [Combination: Combination], ... 2 more ...)
• bldg_deflection (type: esriFieldTypeString, alias: Structural Deflection, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• bldg_ponding (type: esriFieldTypeString, alias: Ponding Water, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• bldg_cracking (type: esriFieldTypeString, alias: Cracking to Slab Soffit, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Limited/No access - unable to assess/ascertain: Limited/No access - unable to assess/ascertain])
• bldg_water_penetrate (type: esriFieldTypeString, alias: Evidence of Water Penetration, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Limited/No access - unable to assess/ascertain: Limited/No access - unable to assess/ascertain])
• bldg_reinforce_stain (type: esriFieldTypeString, alias: Reinforcement Staining, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Limited/No access - unable to assess/ascertain: Limited/No access - unable to assess/ascertain])
• bldg_crack_config (type: esriFieldTypeString, alias: Cracking Configuration, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Longitudinal: Longitudinal], [Transverse: Transverse], [Combination: Combination], ... 2 more ...)
• bldg_crack_location (type: esriFieldTypeString, alias: Location of Cracking, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Bearing: Bearing], [Mid: Mid], [Both: Both], ... 2 more ...)
• bldg_ext_fin_colour (type: esriFieldTypeString, alias: External Type Finshes (Colour), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Black: Black], [Dark: Dark], [Light: Light], ... 1 more ...)
• bldg_bearing_width (type: esriFieldTypeInteger, alias: Bearing Widths (mm), SQL Type: sqlTypeOther, nullable: true, editable: true)
• bldg_reinforce_cor (type: esriFieldTypeString, alias: Reinforecment Corrosion, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Limited/No access - unable to assess/ascertain: Limited/No access - unable to assess/ascertain])
• bldg_last_inspect (type: esriFieldTypeString, alias: Date of Last Inspection, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• invest_required (type: esriFieldTypeString, alias: Further Investigation Required, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• parentglobalid (type: esriFieldTypeGUID, alias: ParentGlobalID, SQL Type: sqlTypeGUID, length: 38, nullable: true, editable: true)
• CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)

Relationships:
• RAAC_Survey_rpt_roof_survey (1) -- Related To: RAAC_Survey (2)
• rpt_roof_survey_rpt_invest (2) -- Related To: rpt_invest (1)
Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 11/4/2020 9:05:30 AM

Schema Last Edit Date: 11/4/2020 9:05:30 AM

Data Last Edit Date: 11/4/2020 9:05:30 AM

rpt_invest (1)


Name: rpt_invest

Display Field: objectid

Type: Table

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Description:

Copyright Text:

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

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: sqlTypeGUID, length: 38, nullable: false, editable: false)
• parent_bldg_ref2 (type: esriFieldTypeString, alias: parent_bldg_ref2, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• parent_roof_name (type: esriFieldTypeString, alias: parent_roof_name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• invest_desc (type: esriFieldTypeString, alias: Description of Work Costed, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true, Coded Values: [Internal propping to be installed below heavily deflecting roof/deck planks.: Internal propping to be installed below heavily deflecting roof/deck planks.], [Carry out a topographic level survey on roof/deck to assess/confirm fluctuations / deflection in construction and keep records of deflections of RAAC planks.: Carry out a topographic level survey on roof/deck to assess/confirm fluctuations / deflection in construction and keep records of deflections of RAAC planks.], [Inspect the construction on an annual basis as a minimum checking for visual signs of cracks; deflection to soffits; and water penetration and ponding to roofs.: Inspect the construction on an annual basis as a minimum checking for visual signs of cracks; deflection to soffits; and water penetration and ponding to roofs.], ... 8 more ...)
• invest_desc_other (type: esriFieldTypeString, alias: Description of Work Costed, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• invest_desc_answer (type: esriFieldTypeString, alias: invest_desc_answer, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• invest_priority (type: esriFieldTypeString, alias: Priority, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true, Coded Values: [A: A], [B: B], [C: C], ... 1 more ...)
• invest_cost (type: esriFieldTypeDouble, alias: Est. Cost £, SQL Type: sqlTypeOther, nullable: true, editable: true)
• parentglobalid (type: esriFieldTypeGUID, alias: ParentGlobalID, SQL Type: sqlTypeGUID, length: 38, nullable: true, editable: true)
• CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)

Relationships:
• rpt_roof_survey_rpt_invest (2) -- Related To: rpt_roof_survey (0)
Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 11/4/2020 9:37:17 AM

Schema Last Edit Date: 11/4/2020 9:37:17 AM

Data Last Edit Date: 11/4/2020 9:37:17 AM