Name: Project_Assessment_Join

Display Field:

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Is View: true

Is Updatable View: false

Source Schema Changes Allowed: false

Sources

Description: AttributeJoin

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:

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

HasM: false

Has Attachments: false

Has Geometry Properties: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: ObjectId

Unique ID Field:

Name : ObjectId

IsSystemMaintained : True

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:

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

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 3/11/2021 2:31:38 PM

Schema Last Edit Date: 3/11/2021 2:31:38 PM

Data Last Edit Date: 3/11/2021 2:31:38 PM

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