All Layers and Tables (Project_Assessment

Layers:

Layer: Project_Assessment_Join (0)

Name:

Display Field:

Type:

Geometry Type:

Is View:

Is Updatable View:

Source Schema Changes Allowed:

Description:

Copyright Text:

Min. Scale:

Max. Scale:

Default Visibility:

Max Record Count:

Supported query Formats:

Use Standardized Queries:

Extent:

Drawing Info:

{"renderer":{"symbol":{"color":[0,178,255,48],"outline":{"color":[0,178,255,255],"style":"esriSLSSolid","type":"esriSLS","width":2},"style":"esriSFSSolid","type":"esriSFS"},"type":"simple","label":"BEST_ProjectForm"},"transparency":0}

HasZ:

HasM:

Has Attachments:

Has Geometry Properties:

HTML Popup Type:

Object ID Field:

Unique ID Field:

Global ID Field:

Type ID Field:

Fields:

globalid (type: esriFieldTypeGUID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
projectName (type: esriFieldTypeString, alias: Project Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
projectRef (type: esriFieldTypeString, alias: Project Reference, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
projectLocation (type: esriFieldTypeString, alias: Project Location, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Shape__Area (type: esriFieldTypeDouble, alias: Shape__Area, SQL Type: sqlTypeOther, nullable: true, editable: false)
Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeOther, nullable: true, editable: false)
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)
globalid_1602836650860 (type: esriFieldTypeGUID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
projectParentID (type: esriFieldTypeString, alias: projectParentID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
assessName_AM (type: esriFieldTypeString, alias: Assessment Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
assessRef_AM (type: esriFieldTypeString, alias: Assessment Reference, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
assessVersion_AM (type: esriFieldTypeString, alias: Assessment Version, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
amenityScreen (type: esriFieldTypeString, alias: Select Benefit, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
AM2_SG_Base_Option (type: esriFieldTypeString, alias: Baseline Option Description, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
AM2_SG_Base_Homes (type: esriFieldTypeInteger, alias: Baseline Estimated no. of residents living in green streets, SQL Type: sqlTypeOther, nullable: true, editable: true)
AM2_SG_Base_Mvalue (type: esriFieldTypeString, alias: Select appropriate monetary value description (or enter used defined) £/yr/resident household, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [21.56: Low - Small Trees (21.56)], [24.87: Central - Large Trees (24.87)], [30.82: High - Large Trees and Planting (30.82)])
AM2_SG_Base_Quantity (type: esriFieldTypeString, alias: Baseline Quantity, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [0.25: 0.25], [0.5: 0.5], [0.75: 0.75], ... 1 more ...)
AM2_SG_Base_Valuation (type: esriFieldTypeString, alias: Baseline Valuation, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [0.25: 0.25], [0.5: 0.5], [0.75: 0.75], ... 1 more ...)
AM2_SG_Base_BaseYear (type: esriFieldTypeInteger, alias: Base Assessment Year, SQL Type: sqlTypeOther, nullable: true, editable: true)
AM2_SG_Base_FutureYear (type: esriFieldTypeInteger, alias: Future Assessment Year, SQL Type: sqlTypeOther, nullable: true, editable: true)
AM2_SG_Base_lowerDiscount (type: esriFieldTypeString, alias: AM2_SG_Base_lowerDiscount, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
AM2_SG_Base_upperDiscount (type: esriFieldTypeString, alias: AM2_SG_Base_upperDiscount, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
AM2_SG_Base_NPV_nocon_calc (type: esriFieldTypeDouble, alias: AM2_SG_Base_NPV_nocon_calc, SQL Type: sqlTypeOther, nullable: true, editable: true)
AM2_SG_Base_NPV_nocon (type: esriFieldTypeInteger, alias: AM2 Street Greening Baseline Present value (PV) before confidence applied (£), SQL Type: sqlTypeOther, nullable: true, editable: true)
AM2_SG_Base_NPV_con_calc (type: esriFieldTypeString, alias: AM2_SG_Base_NPV_con_calc, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
AM2_SG_Base_NPV_con (type: esriFieldTypeInteger, alias: AM2 Street Greening Baseline Present value (PV) after confidence applied (£), SQL Type: sqlTypeOther, nullable: true, editable: true)
AM2_SG_Proposed_Option (type: esriFieldTypeString, alias: Proposed Option Description, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
AM2_SG_Proposed_Homes (type: esriFieldTypeInteger, alias: Proposed Estimated no. of residents living in green streets, SQL Type: sqlTypeOther, nullable: true, editable: true)
AM2_SG_Proposed_Mvalue (type: esriFieldTypeString, alias: Select appropriate monetary value description (or enter used defined) £/yr/resident household, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [21.56: Low - Small Trees (21.56)], [24.87: Central - Large Trees (24.87)], [30.82: High - Large Trees and Planting (30.82)])
AM2_SG_Proposed_Quantity (type: esriFieldTypeString, alias: Proposed Quantity, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [0.25: 0.25], [0.5: 0.5], [0.75: 0.75], ... 1 more ...)
AM2_SG_Proposed_Valuation (type: esriFieldTypeString, alias: Proposed Valuation, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [0.25: 0.25], [0.5: 0.5], [0.75: 0.75], ... 1 more ...)
AM2_SG_Proposed_BaseYear (type: esriFieldTypeInteger, alias: Base Assessment Year, SQL Type: sqlTypeOther, nullable: true, editable: true)
AM2_SG_Proposed_FutureYear (type: esriFieldTypeInteger, alias: Future Assessment Year, SQL Type: sqlTypeOther, nullable: true, editable: true)
AM2_SG_Proposed_lowerDiscount (type: esriFieldTypeString, alias: AM2_SG_Proposed_lowerDiscount, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
AM2_SG_Proposed_upperDiscount (type: esriFieldTypeString, alias: AM2_SG_Proposed_upperDiscount, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
AM2_SG_Proposed_NPV_nocon_calc (type: esriFieldTypeDouble, alias: AM2_SG_Proposed_NPV_nocon_calc, SQL Type: sqlTypeOther, nullable: true, editable: true)
AM2_SG_Proposed_NPV_nocon (type: esriFieldTypeInteger, alias: AM2 Street Greening Proposed Present value (PV) before confidence applied (£), SQL Type: sqlTypeOther, nullable: true, editable: true)
AM2_SG_Proposed_NPV_con_calc (type: esriFieldTypeString, alias: AM2_SG_Proposed_NPV_con_calc, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
AM2_SG_Proposed_NPV_con (type: esriFieldTypeInteger, alias: AM2 Street Greening Proposed Present value (PV) after confidence applied (£), SQL Type: sqlTypeOther, nullable: true, editable: true)
AM2_SG_Difference_nocon_calc (type: esriFieldTypeString, alias: AM2_SG_Difference_nocon_calc, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
AM2_SG_Difference_nocon (type: esriFieldTypeInteger, alias: AM2 Street Greening Proposed PV - Base PV (no confidence values applied) (£), SQL Type: sqlTypeOther, nullable: true, editable: true)
AM2_SG_Difference_con_calc (type: esriFieldTypeString, alias: AM2_SG_Difference_con_calc, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
AM2_SG_Difference_con (type: esriFieldTypeInteger, alias: AM2 Street Greening Proposed PV - Base PV (confidence values applied) (£), SQL Type: sqlTypeOther, nullable: true, editable: true)
AM2_BW_Base_Option (type: esriFieldTypeString, alias: Baseline Option Description, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
AM2_BW_Base_Homes (type: esriFieldTypeInteger, alias: Baseline Estimated no. of homes overlooking ponds, SQL Type: sqlTypeOther, nullable: true, editable: true)
AM2_BW_Base_Mvalue (type: esriFieldTypeString, alias: Select appropriate monetary value description (or enter used defined) £/yr/resident household, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [74.35: Low (74.35)], [144.85: Central (144.85)], [247.51: High (247.51)])
AM2_BW_Base_Quantity (type: esriFieldTypeString, alias: Baseline Quantity, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [0.25: 0.25], [0.5: 0.5], [0.75: 0.75], ... 1 more ...)
AM2_BW_Base_Valuation (type: esriFieldTypeString, alias: Baseline Valuation, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [0.25: 0.25], [0.5: 0.5], [0.75: 0.75], ... 1 more ...)
AM2_BW_Base_BaseYear (type: esriFieldTypeInteger, alias: Base Assessment Year, SQL Type: sqlTypeOther, nullable: true, editable: true)
AM2_BW_Base_FutureYear (type: esriFieldTypeInteger, alias: Future Assessment Year, SQL Type: sqlTypeOther, nullable: true, editable: true)
AM2_BW_Base_lowerDiscount (type: esriFieldTypeString, alias: AM2_BW_Base_lowerDiscount, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
AM2_BW_Base_upperDiscount (type: esriFieldTypeString, alias: AM2_BW_Base_upperDiscount, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
AM2_BW_Base_NPV_nocon_calc (type: esriFieldTypeDouble, alias: AM2_BW_Base_NPV_nocon_calc, SQL Type: sqlTypeOther, nullable: true, editable: true)
AM2_BW_Base_NPV_nocon (type: esriFieldTypeInteger, alias: AM2 - Permanent Body of Water Baseline Present value (PV) before confidence applied (£), SQL Type: sqlTypeOther, nullable: true, editable: true)
AM2_BW_Base_NPV_con_calc (type: esriFieldTypeString, alias: AM2_BW_Base_NPV_con_calc, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
AM2_BW_Base_NPV_con (type: esriFieldTypeInteger, alias: AM2 - Permanent Body of Water Baseline Present value (PV) after confidence applied (£), SQL Type: sqlTypeOther, nullable: true, editable: true)
AM2_BW_Proposed_Option (type: esriFieldTypeString, alias: Proposed Option Description, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
AM2_BW_Proposed_Homes (type: esriFieldTypeInteger, alias: Proposed Estimated no. of homes overlooking ponds, SQL Type: sqlTypeOther, nullable: true, editable: true)
AM2_BW_Proposed_Mvalue (type: esriFieldTypeString, alias: Select appropriate monetary value description (or enter used defined) £/yr/resident household, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [74.35: Low (74.35)], [144.85: Central (144.85)], [247.51: High (247.51)])
AM2_BW_Proposed_Quantity (type: esriFieldTypeString, alias: Proposed Quantity, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [0.25: 0.25], [0.5: 0.5], [0.75: 0.75], ... 1 more ...)
AM2_BW_Proposed_Valuation (type: esriFieldTypeString, alias: Proposed Valuation, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [0.25: 0.25], [0.5: 0.5], [0.75: 0.75], ... 1 more ...)
AM2_BW_Proposed_BaseYear (type: esriFieldTypeInteger, alias: Base Assessment Year, SQL Type: sqlTypeOther, nullable: true, editable: true)
AM2_BW_Proposed_FutureYear (type: esriFieldTypeInteger, alias: Future Assessment Year, SQL Type: sqlTypeOther, nullable: true, editable: true)
AM2_BW_Proposed_lowerDiscount (type: esriFieldTypeString, alias: AM2_BW_Proposed_lowerDiscount, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
AM2_BW_Proposed_upperDiscount (type: esriFieldTypeString, alias: AM2_BW_Proposed_upperDiscount, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
AM2_BW_Proposed_NPV_nocon_calc (type: esriFieldTypeDouble, alias: AM2_BW_Proposed_NPV_nocon_calc, SQL Type: sqlTypeOther, nullable: true, editable: true)
AM2_BW_Proposed_NPV_nocon (type: esriFieldTypeInteger, alias: AM2 Permanent Body of Water Proposed Present value (PV) before confidence applied (£), SQL Type: sqlTypeOther, nullable: true, editable: true)
AM2_BW_Proposed_NPV_con_calc (type: esriFieldTypeString, alias: AM2_BW_Proposed_NPV_con_calc, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
AM2_BW_Proposed_NPV_con (type: esriFieldTypeInteger, alias: AM2 Permanent Body of Water Proposed Present value (PV) after confidence applied (£), SQL Type: sqlTypeOther, nullable: true, editable: true)
AM2_BW_Difference_nocon_calc (type: esriFieldTypeString, alias: AM2_BW_Difference_nocon_calc, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
AM2_BW_Difference_nocon (type: esriFieldTypeInteger, alias: AM2 Body of Water Proposed - Base PV (no confidence values applied) (£), SQL Type: sqlTypeOther, nullable: true, editable: true)
AM2_BW_Difference_con_calc (type: esriFieldTypeString, alias: AM2_BW_Difference_con_calc, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
AM2_BW_Difference_con (type: esriFieldTypeInteger, alias: AM2 Body of Water Proposed PV - Base PV (confidence values applied) (£), SQL Type: sqlTypeOther, nullable: true, editable: true)
amentiyNPV_nocon (type: esriFieldTypeInteger, alias: amentiyNPV_nocon, SQL Type: sqlTypeOther, nullable: true, editable: true)
amenityNPV_con (type: esriFieldTypeInteger, alias: amenityNPV_con, SQL Type: sqlTypeOther, nullable: true, editable: true)
waterTotal_NPV_con (type: esriFieldTypeInteger, alias: Water Quality NPV (con), SQL Type: sqlTypeOther, nullable: true, editable: true)
waterTotal_NPV_nocon (type: esriFieldTypeInteger, alias: Water Quality NPV (no con), SQL Type: sqlTypeOther, nullable: true, editable: true)
airQualityNPV_nocon (type: esriFieldTypeInteger, alias: airQualityNPV_nocon, SQL Type: sqlTypeOther, nullable: true, editable: true)
airQualityNPV_con (type: esriFieldTypeInteger, alias: airQualityNPV_con, SQL Type: sqlTypeOther, nullable: true, editable: true)
assetNPV_nocon (type: esriFieldTypeInteger, alias: assetNPV_nocon, SQL Type: sqlTypeOther, nullable: true, editable: true)
assetNPV_con (type: esriFieldTypeInteger, alias: assetNPV_con, SQL Type: sqlTypeOther, nullable: true, editable: true)
bioecoNPV_nocon (type: esriFieldTypeInteger, alias: bioecoNPV_nocon, SQL Type: sqlTypeOther, nullable: true, editable: true)
bioecoNPV_con (type: esriFieldTypeInteger, alias: bioecoNPV_con, SQL Type: sqlTypeOther, nullable: true, editable: true)
buildingTemp_nocon (type: esriFieldTypeInteger, alias: buildingTemp_nocon, SQL Type: sqlTypeOther, nullable: true, editable: true)
buildingTemp_con (type: esriFieldTypeInteger, alias: buildingTemp_con, SQL Type: sqlTypeOther, nullable: true, editable: true)
carbonNPV_nocon (type: esriFieldTypeInteger, alias: carbonNPV_nocon, SQL Type: sqlTypeOther, nullable: true, editable: true)
carbonNPV_con (type: esriFieldTypeInteger, alias: carbonNPV_con, SQL Type: sqlTypeOther, nullable: true, editable: true)
crimeNPV_nocon (type: esriFieldTypeInteger, alias: crimeNPV_nocon, SQL Type: sqlTypeOther, nullable: true, editable: true)
crimeNPV_con (type: esriFieldTypeInteger, alias: crimeNPV_con, SQL Type: sqlTypeOther, nullable: true, editable: true)
economicNPV_nocon (type: esriFieldTypeInteger, alias: economicNPV_nocon, SQL Type: sqlTypeOther, nullable: true, editable: true)
economicNPV_con (type: esriFieldTypeInteger, alias: economicNPV_con, SQL Type: sqlTypeOther, nullable: true, editable: true)
educationNPV_nocon (type: esriFieldTypeInteger, alias: educationNPV_nocon, SQL Type: sqlTypeOther, nullable: true, editable: true)
educationNPV_con (type: esriFieldTypeInteger, alias: educationNPV_con, SQL Type: sqlTypeOther, nullable: true, editable: true)
enablingDevNPV_nocon (type: esriFieldTypeInteger, alias: enablingDevNPV_nocon, SQL Type: sqlTypeOther, nullable: true, editable: true)
enablingDevNPV_con (type: esriFieldTypeInteger, alias: enablingDevNPV_con, SQL Type: sqlTypeOther, nullable: true, editable: true)
floodingNPV_nocon (type: esriFieldTypeInteger, alias: floodingNPV_nocon, SQL Type: sqlTypeOther, nullable: true, editable: true)
floodingNPV_con (type: esriFieldTypeInteger, alias: floodingNPV_con, SQL Type: sqlTypeOther, nullable: true, editable: true)
healthNPV_nocon (type: esriFieldTypeInteger, alias: healthNPV_nocon, SQL Type: sqlTypeOther, nullable: true, editable: true)
healthNPV_con (type: esriFieldTypeInteger, alias: healthNPV_con, SQL Type: sqlTypeOther, nullable: true, editable: true)
noiseNPV_nocon (type: esriFieldTypeInteger, alias: noiseNPV_nocon, SQL Type: sqlTypeOther, nullable: true, editable: true)
noiseNPV_con (type: esriFieldTypeInteger, alias: noiseNPV_con, SQL Type: sqlTypeOther, nullable: true, editable: true)
recreationNPV_nocon (type: esriFieldTypeInteger, alias: recreationNPV_nocon, SQL Type: sqlTypeOther, nullable: true, editable: true)
recreationNPV_con (type: esriFieldTypeInteger, alias: recreationNPV_con, SQL Type: sqlTypeOther, nullable: true, editable: true)
tourismNPV_nocon (type: esriFieldTypeInteger, alias: tourismNPV_nocon, SQL Type: sqlTypeOther, nullable: true, editable: true)
tourismNPV_con (type: esriFieldTypeInteger, alias: tourismNPV_con, SQL Type: sqlTypeOther, nullable: true, editable: true)
trafficCalmNPV_nocon (type: esriFieldTypeInteger, alias: trafficCalmNPV_nocon, SQL Type: sqlTypeOther, nullable: true, editable: true)
trafficCalmNPV_con (type: esriFieldTypeInteger, alias: trafficCalmNPV_con, SQL Type: sqlTypeOther, nullable: true, editable: true)
waterqualityNPV_nocon (type: esriFieldTypeInteger, alias: waterqualityNPV_nocon, SQL Type: sqlTypeOther, nullable: true, editable: true)
waterqualityNPV_con (type: esriFieldTypeInteger, alias: waterqualityNPV_con, SQL Type: sqlTypeOther, nullable: true, editable: true)
waterquantityNPV_nocon (type: esriFieldTypeInteger, alias: waterquantityNPV_nocon, SQL Type: sqlTypeOther, nullable: true, editable: true)
waterquantityNPV_con (type: esriFieldTypeInteger, alias: waterquantityNPV_con, SQL Type: sqlTypeOther, nullable: true, editable: true)
Shape__Area_1602836650860 (type: esriFieldTypeDouble, alias: Shape__Area, SQL Type: sqlTypeOther, nullable: true, editable: false)
Shape__Length_1602836650860 (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeOther, nullable: true, editable: false)
CreationDate_1602836650860 (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
Creator_1602836650860 (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
EditDate_1602836650860 (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
Editor_1602836650860 (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
ObjectId (type: esriFieldTypeOID, alias: ObjectId, SQL Type: sqlTypeOther, length: 8, nullable: false, editable: false)

Templates:

Is Data Versioned:

Has Contingent Values:

Supports Rollback On Failure Parameter:

Last Edit Date:

Schema Last Edit Date:

Data Last Edit Date:

All Layers and Tables (Project_Assessment_Join)

Layers:

Layer: Project_Assessment_Join (0)