Name: SolarPV

Display Field: objectid

Type: Table

Has Views: true

Source Schema Changes Allowed: true

Views

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)
• SolarPVStructureAndMountingFrame (type: esriFieldTypeString, alias: Structure & Mounting Frame, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• SolarPVStructureAndMountingFrameReason (type: esriFieldTypeString, alias: Choose Failure Reason, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SolarPVStructureAndMountingFrameNote1 (type: esriFieldTypeString, alias: Roof in poor condition Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• SolarPVStructureAndMountingFrameNote2 (type: esriFieldTypeString, alias: Frame not level or square Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• SolarPVStructureAndMountingFrameNote3 (type: esriFieldTypeString, alias: Unsuitable footing/fixing Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• SolarPVStructureAndMountingFrameNote4 (type: esriFieldTypeString, alias: Mounting structure or frame damaged Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• SolarPVStructureAndMountingFrameNote5 (type: esriFieldTypeString, alias: Not fixed according to manufacturer's instructions Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• SolarPVStructureAndMountingFrameNote6 (type: esriFieldTypeString, alias: No/poor ballast/anchor Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• SolarPVStructureAndMountingFrameNote7 (type: esriFieldTypeString, alias: Lack of roof fixings visible Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• SolarPVStructureAndMountingFrameNote8 (type: esriFieldTypeString, alias: Wrong fixings used Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• SolarPVStructureAndMountingFrameNote9 (type: esriFieldTypeString, alias: Roof integrity compromised Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• SolarPVStructureAndMountingFrameNote10 (type: esriFieldTypeString, alias: Array fitted over vents Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• SolarPVStructureAndMountingFrameNote11 (type: esriFieldTypeString, alias: Vents used for cable entries Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• SolarPVStructureAndMountingFrameNote12 (type: esriFieldTypeString, alias: Leak visible at cable entry Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• SolarPVStructureAndMountingFrameNote13 (type: esriFieldTypeString, alias: Staining on roof/ceiling around penetration Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• SolarPVStructureAndMountingFrameNote14 (type: esriFieldTypeString, alias: Mechanically protected fitting not used Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• SolarPVStructureAndMountingFrameNote15 (type: esriFieldTypeString, alias: Evidence land not cleared around ground mounting frame Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• SolarPVStructureAndMountingFrameNote16 (type: esriFieldTypeString, alias: Mounting configuration is not in accordance with Solar PV COP Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• SolarPVArray (type: esriFieldTypeString, alias: Array, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• SolarPVArrayReason (type: esriFieldTypeString, alias: Choose Failure Reason, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SolarPVArrayNote1 (type: esriFieldTypeString, alias: Optimal orientation not used Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• SolarPVArrayNote2 (type: esriFieldTypeString, alias: Shading not avoided Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• SolarPVArrayNote3 (type: esriFieldTypeString, alias: Array is not minimum 500mm from roof edge Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• SolarPVArrayNote4 (type: esriFieldTypeString, alias: Array is not 200mm below the ridge tile Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• SolarPVArrayNote5 (type: esriFieldTypeString, alias: Evidence of no rail overhang to module and clamp Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• SolarPVArrayNote6 (type: esriFieldTypeString, alias: Evidence of no end caps on mounting bar Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• SolarPVArrayNote7 (type: esriFieldTypeString, alias: Number of panels does not match the number declared in Application Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• SolarPVStringInverterPrompt (type: esriFieldTypeString, alias: Is the String Inverter to be Assessed?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• SolarPVStringInverter (type: esriFieldTypeString, alias: String Inverter, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• SolarPVStringInverterReason (type: esriFieldTypeString, alias: Choose Failure Reason, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SolarPVStringInverterNote1 (type: esriFieldTypeString, alias: No access to inverter Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• SolarPVStringInverterNote2 (type: esriFieldTypeString, alias: Data not accessible to user Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• SolarPVStringInverterNote3 (type: esriFieldTypeString, alias: Not firmly fixed Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• SolarPVStringInverterNote4 (type: esriFieldTypeString, alias: Inadequate ventilation Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• SolarPVStringInverterNote5 (type: esriFieldTypeString, alias: Poor location - not in accordance with manufacturer's instructions Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• SolarPVStringInverterNote6 (type: esriFieldTypeString, alias: Inverter not suitable for outdoor use Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• SolarPVStringInverterNote7 (type: esriFieldTypeString, alias: Inverter located in an area with unsuitable environmental conditions Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• SolarPVStringInverterNote8 (type: esriFieldTypeString, alias: String Inverter not mounted on fire resistant surface (Class O) which extends minimum 150mm beyond edge of inverter Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• SolarPVStringInverterNote9 (type: esriFieldTypeString, alias: Evidence inverter not as described in Application / NC6 Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• SolarPVStringInverterNote10 (type: esriFieldTypeString, alias: Not present Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• SolarPVStringInverterNote11 (type: esriFieldTypeString, alias: Not working or automatic isolation of the circuit does not reconnect upon reconnection of AC supply Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• SolarPVStringInverterNote12 (type: esriFieldTypeString, alias: Not within 1.5m of entry to the building or 1.5m from ground mounted array Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• SolarPVMicroInvertersPrompt (type: esriFieldTypeString, alias: Are the Micro Inverters to be Assessed?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• SolarPVMicroInverters (type: esriFieldTypeString, alias: Micro Inverters, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• SolarPVMicroInvertersReason (type: esriFieldTypeString, alias: Choose Failure Reason, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SolarPVMicroInvertersNote1 (type: esriFieldTypeString, alias: Data not accessible to user Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• SolarPVMicroInvertersNote2 (type: esriFieldTypeString, alias: Evidence that inverter not installed with manufactures requirements Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• SolarPVMicroInvertersNote3 (type: esriFieldTypeString, alias: AC isolator not fitted in accordance with manufacturer's instructions Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• SolarPVMicroInvertersNote4 (type: esriFieldTypeString, alias: AC cable and fittings not suitable Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• SolarPVMicroInvertersNote5 (type: esriFieldTypeString, alias: Not working or automatic isolation of the circuit does not reconnect upon reconnection of AC supply Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• SolarPVMicroInvertersNote6 (type: esriFieldTypeString, alias: Not within 1.5m of entry to the building or 1.5m from ground mounted array Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• SolarPVDivertersPrompt (type: esriFieldTypeString, alias: Is the Diverter to be Assessed?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• SolarPVDiverters (type: esriFieldTypeString, alias: Diverters, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• SolarPVDivertersReason (type: esriFieldTypeString, alias: Choose Failure Reason, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SolarPVDivertersNote1 (type: esriFieldTypeString, alias: Diverter not installed to manufacturer's instructions Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• SolarPVDivertersNote2 (type: esriFieldTypeString, alias: Diverter not in compliance with EN 61000 Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• SolarPVDivertersNote3 (type: esriFieldTypeString, alias: Diverter not commissioned Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• SolarPVDivertersNote4 (type: esriFieldTypeString, alias: Evidence of diverter not operating as intended Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• SolarPVACElectricalInstallationAndMetering (type: esriFieldTypeString, alias: AC Electrical Installation and Metering, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• SolarPVACElectricalInstallationAndMeteringReason (type: esriFieldTypeString, alias: Choose Failure Reason, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SolarPVACElectricalInstallationAndMeteringNote1 (type: esriFieldTypeString, alias: AC Installation not connected to dedicated circuit in compliance with ET101 Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• SolarPVACElectricalInstallationAndMeteringNote2 (type: esriFieldTypeString, alias: AC Isolator not within 2 meters of Inverter Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• SolarPVACElectricalInstallationAndMeteringNote3 (type: esriFieldTypeString, alias: Evidence of AC Cables not secure / mechanically protected Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• SolarPVACElectricalInstallationAndMeteringNote4 (type: esriFieldTypeString, alias: No check meter present on AC supply visible to Homeowner Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• SolarPVACElectricalInstallationAndMeteringNote5 (type: esriFieldTypeString, alias: Evidence from the check meter that system is not generating Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• SolarPVACElectricalInstallationAndMeteringNote6 (type: esriFieldTypeString, alias: No past meter reading available / past meter reading inconsistent Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• SolarPVDCElectricalInstallation (type: esriFieldTypeString, alias: DC Electrical Installation and Metering, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• SolarPVDCElectricalInstallationReason (type: esriFieldTypeString, alias: Choose Failure Reason, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SolarPVDCElectricalInstallationNote1 (type: esriFieldTypeString, alias: Evidence of DC Isolator not present Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• SolarPVDCElectricalInstallationNote2 (type: esriFieldTypeString, alias: Evidence of DC Cables not secure Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• SolarPVDCElectricalInstallationNote3 (type: esriFieldTypeString, alias: Evidence of DC Cables not mechanically protected at points of entry from wear and tear Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• SolarPVDCElectricalInstallationNote4 (type: esriFieldTypeString, alias: Evidence of DC Cables not in accordance with COP Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• SolarPVDocumentationAndLabelling (type: esriFieldTypeString, alias: Documentation And Labelling, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• SolarPVDocumentationAndLabellingReason (type: esriFieldTypeString, alias: Choose Failure Reason, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SolarPVDocumentationAndLabellingNote1 (type: esriFieldTypeString, alias: Datasheets for Solar PV Modules, Inverters and BESS not provided Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• SolarPVDocumentationAndLabellingNote2 (type: esriFieldTypeString, alias: Warranties for Solar PV Modules, Inverters, Mounting System not provided Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• SolarPVDocumentationAndLabellingNote3 (type: esriFieldTypeString, alias: O&M Manual not provided Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• SolarPVDocumentationAndLabellingNote4 (type: esriFieldTypeString, alias: Basic start up, shut down, safety, operation and maintenance instructions not provided Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• SolarPVDocumentationAndLabellingNote5 (type: esriFieldTypeString, alias: Estimation of system performance calculated using common tools not provided Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• SolarPVDocumentationAndLabellingNote6 (type: esriFieldTypeString, alias: All safety and information labels not in place Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• SolarPVBatteryEnergyStorageSystemPrompt (type: esriFieldTypeString, alias: Is the Battery Energy Storage System to be Assessed?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• SolarPVBatteryEnergyStorageSystem (type: esriFieldTypeString, alias: Battery Energy Storage System, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• SolarPVBatteryEnergyStorageSystemReason (type: esriFieldTypeString, alias: Choose Failure Reason, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SolarPVBatteryEnergyStorageSystemNote1 (type: esriFieldTypeString, alias: Not accessible Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• SolarPVBatteryEnergyStorageSystemNote2 (type: esriFieldTypeString, alias: Not protected Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• SolarPVBatteryEnergyStorageSystemNote3 (type: esriFieldTypeString, alias: Evidence battery is not secured in accordance with manufacturers instructions Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• SolarPVBatteryEnergyStorageSystemNote4 (type: esriFieldTypeString, alias: Battery system not mounted on a fire proof surface extending 150mm beyond the edge of the battery storage system Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• SolarPVBatteryEnergyStorageSystemNote5 (type: esriFieldTypeString, alias: Battery system is not 150mm from combustible material Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• SolarPVBatteryEnergyStorageSystemNote6 (type: esriFieldTypeString, alias: No isolation present on battery circuit in accordance with OEM Failure Details, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• SolarPVPlanningPermission (type: esriFieldTypeString, alias: Planning Permission, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• SolarPVPlanningPermissionReason (type: esriFieldTypeString, alias: Choose Failure Reason, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SolarPVPlanningPermissionNote1 (type: esriFieldTypeString, alias: Homeowner not advised of planning requirements Failure Details, SQL Type: sqlTypeOther, length: 500, 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:

• KSN___NDB_Scheme_Inspection_Form___Deep_Retrofit_SolarPV (6) -- Related To: KSN___NDB_Scheme_Inspection_Form___Deep_Retrofit (0)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 5/18/2021 3:17:17 AM

Schema Last Edit Date: 5/18/2021 3:17:17 AM

Data Last Edit Date: 5/18/2021 3:17:17 AM

Supported Operations:   Query   Query Top Features   Query Analytic   Query Bins   Query Related Records   Query Attachments   Add Features   Update Features   Delete Features   Apply Edits   Calculate   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat