CN110111019A - A kind of ornamental plant landscape performance comprehensive evaluation model and construction method - Google Patents
A kind of ornamental plant landscape performance comprehensive evaluation model and construction method Download PDFInfo
- Publication number
- CN110111019A CN110111019A CN201910407314.6A CN201910407314A CN110111019A CN 110111019 A CN110111019 A CN 110111019A CN 201910407314 A CN201910407314 A CN 201910407314A CN 110111019 A CN110111019 A CN 110111019A
- Authority
- CN
- China
- Prior art keywords
- index
- evaluation
- landscape
- excel
- plant
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/248—Presentation of query results
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/04—Forecasting or optimisation specially adapted for administrative or management purposes, e.g. linear programming or "cutting stock problem"
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
- G06Q10/063—Operations research, analysis or management
- G06Q10/0639—Performance analysis of employees; Performance analysis of enterprise or organisation operations
- G06Q10/06393—Score-carding, benchmarking or key performance indicator [KPI] analysis
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
- G06Q10/067—Enterprise or organisation modelling
Landscapes
- Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Human Resources & Organizations (AREA)
- Strategic Management (AREA)
- Theoretical Computer Science (AREA)
- Economics (AREA)
- General Physics & Mathematics (AREA)
- Physics & Mathematics (AREA)
- Entrepreneurship & Innovation (AREA)
- Development Economics (AREA)
- Operations Research (AREA)
- Quality & Reliability (AREA)
- Tourism & Hospitality (AREA)
- Marketing (AREA)
- General Business, Economics & Management (AREA)
- Educational Administration (AREA)
- Game Theory and Decision Science (AREA)
- Computational Linguistics (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a kind of ornamental plant landscape performance comprehensive evaluation model and construction methods, evaluation model includes that Excel database information calling module is formed a team, Excel hierarchical model building module forms a team and model is presented immediately with Excel, construction method includes the following steps: to construct Performance Evaluation System using analytic hierarchy process (AHP);Formulate evaluation criterion detailed rules and regulations;Data information is called according to Performance Evaluation System;Data are handled according to evaluation criterion detailed rules and regulations, obtain the value of each floristics index factors at different levels;Calculate the weight of the phytometer factors at different levels;Place demand is judged according to evaluation criterion detailed rules and regulations, obtains the score value of index factors at different levels;Founding mathematical models generate evaluation result and accumulate histogram;It is proposed targeted design optimisation strategy.This method is easy to operate, and data are accurately objective, realizes quantitatively evaluating, and evaluation result is intuitive as it can be seen that being of great significance to the science for improving Landscape Design with reasonability.
Description
Technical field
The present invention relates to the ornamental plant landscape performance appraisal technical fields of Landscape Design, belong to ornamental plant landscape
Performance overall merit and model building method, specially a kind of ornamental plant landscape performance comprehensive evaluation model and construction method.
Background technique
Landscape performance, concept are defined as " the Landscape reality of sustainable development by U.S. Landscape foundation (LAF)
It tramples in the measurement for completing target and aspect its efficiency and benefit that contributes ".
Landscape performance appraisal, the method for focusing on quantifying by the sustainability feature after building up project calculate
Its comprehensive benefit improves the performance of landscape project.It emphasizes based on measurable as a result, environment, society and economy to landscape are equivalent
Benefit carries out overall merit.
The Planting Design of Conventional wisdom brings underperformance plants landscape.With the deep development of Ecological landscape, garden
The a part of woods plant as economic-natural complex ecosystem of society-, the Ecosystem Service having and ornamental function
Increasingly play an important role.Contemporary Planting Design has the integrated use of the characteristics such as form, the ecology of plant higher
Requirement.The analysis of traditional plant strengths and weaknesses and ecological evaluation method mainly carry out weight by expert estimation and by experience
Setting, it is higher to specialized capability level requirement including having certain subjective assessment sexual factor.Traditional Planting Design often mostly according to
Rely the experience of designer, often due to experience is insufficient or different construction demands causes Landscaping plant design to occur blindly drawing
Kind, the problems such as species are single, early investment is big, maintenance cost is high.
The continuous development of landscape performance correlative study.Landscape performance be a quantification, it is scientific, research landscape quality,
The New Research Method of sustainability efficiency has obtained multi-party scholar, group both at home and abroad although being currently in the initial development stage
Concern and participation.The country has had more about landscape environment ecological benefits and phytomorph benefit type at present, also obtains
Certain achievement, but corresponding research not yet forms comprehensive appraisement system.
Summary of the invention
To solve the above problems, the invention discloses a kind of ornamental plant landscape performance comprehensive evaluation model and building sides
Method, the ornamental plant landscape performance overall merit and model building method are easy to operate, and evaluation model operation is convenient, and data are accurate
And it is objective, quantitatively evaluating is realized, evaluation result is intuitive as it can be seen that reference value is high.
In order to reach the goals above, the invention provides the following technical scheme:
A kind of ornamental plant landscape performance comprehensive evaluation model is disclosed, evaluation model includes Excel database information tune
It is formed a team with module, Excel hierarchical model building module forms a team and model is presented immediately with Excel.
A kind of construction method of ornamental plant landscape performance comprehensive evaluation model is also disclosed, evaluation model includes Excel
Database information calling module is formed a team, Excel hierarchical model building module forms a team and model, construction method are presented immediately with Excel
The following steps are included:
(1) analytic hierarchy process (AHP) is used, the comprehensive evaluation index of ornamental plant landscape performance is determined and is successively parsed, structure
Build the ornamental plant landscape Performance Evaluation System of multi-level multielement;
(2) evaluation criterion detailed rules and regulations are formulated according to the ornamental plant landscape Performance Evaluation System and plant characteristics information;
(3) being associated with according to the ornamental plant landscape Performance Evaluation System and ornamental plant characteristic information, by being relied on
Multivariate data plant information library carry out data call;
(4) according to the evaluation criterion detailed rules and regulations to the ornamental plant characteristic information called by Plant Records Database into
Row quantification treatment obtains the value of index factors at different levels, and is stored in Excel database information calling module and forms a team;
(5) it forms a team in Excel hierarchical model building module and establishes weight judgment matrix, according to the index factors at different levels
Value compares two-by-two establishes matrix, calculates the weighted value of index factors at different levels;
(6) design site condition and design requirement are judged according to the evaluation criterion detailed rules and regulations, obtains indexs at different levels
The score value of the factor;
(7) founding mathematical models, set each floristics ornamental plant landscape performance comprehensive evaluation index as Mj, institute
The weight for stating index factors at different levels is mi=(m1, m2, m3 ...), the score values of the index factors at different levels be vi=(v1, v2,
V3 ...), the calculation formula of the comprehensive evaluation index is thus obtained,
(8) according to each floristics ornamental plant landscape performance comprehensive evaluation index Mj=(M1,M2,M3... ...),
The landscape performance overall merit score value of Landscape Design scheme is set as P, it is Nj that the number of applications of plant is called by nursery stock table
=(N1,N2,N3... ...), the calculation formula of the Landscape Design scheme landscape performance overall merit score value is thus obtained,
(9) module is presented immediately in Excel to form a team, calculates data evaluation as a result, simultaneously giving birth to immediately according to mathematical formulae is calculated
At ornamental plant landscape performance appraisal stacked column graph;
(10) according to calculated result and ornamental plant landscape performance appraisal stacked column graph, Landscape Design scheme is mentioned
Specific aim optimisation strategy out.
Preferably, the specific operation process in step (1) are as follows:
Level-one evaluation index and two-level appraisement index be decomposed into the ornamental plant landscape performance evaluating index, described one
Grade evaluation index includes form ornamental value, ecology influence, economic input amount at present, and the two-level appraisement index is to comment level-one
The further refinement of valence index.With going deep into for research, level-one evaluation index can be expanded further, also may include ornamental plant its
In terms of his relative influence, for example, social influencing, cultural influence etc..
Preferably, the specific thinning process of the two-level appraisement index are as follows:
The form ornamental value is resolved to aspect leaf color, developmental rhythm, limb ornamental value, fruit ornamental value, fruit to see
Reward phase, flower ornamental value, florescence, fragrance, single plant canopy density, branch point height, spatial distribution level;By the ecology influence point
Solution be impoverishment tolerant, cold resistance, illumination habit, shade tolerance, drought-resistant, resistance to water-wet, soil property adaptability, soil acid-base adaptability,
Saline alkali tolerance, wind resistance, root system depth, pollutant absorption characteristic, carbon sequestration put oxygen ability, noise reduction capability, regulation of absorbing dust capability, biology peace
Quan Xing;By the economic input amount resolve to buying complexity, buying cost, the speed of growth, life cycle, resistance to trimming property,
Fertilizer requirement.With going deep into for research, two-level appraisement index can be expanded further.
Preferably, evaluation criterion detailed rules and regulations formulation process in step (2) are as follows:
Standard is parsed with plant characteristics information to the two-level appraisement index and Plant Design requirement description is associated, and
The evaluation criterion detailed rules and regulations are formulated according to the association.
Preferably, multivariate data plant information library carries out data call process in step (3) are as follows:
According to being associated with for the two-level appraisement index and ornamental plant characteristic information, work is established using Excel function
Table and book, window module are formed a team being associated between entry, are formed a team to multivariate data library plant information memory module
Corresponding informance is called, and recalls information is stored in Excel database information calling module and is formed a team.
Preferably, quantification treatment process in step (4) are as follows:
Using the evaluation criterion detailed rules and regulations as assignment condition, defined using the VBA programming technique of Excel multiple according to condition
Assignment it is macro, after information calls storage, execute the macro quantization to carry out text information.
Preferably, specific assignment method of the evaluation criterion detailed rules and regulations as assignment condition are as follows:
Index factor comment is divided into three layers or two layers of comment according to evaluation criterion detailed rules and regulations, uses for reference nine rank assignment methods, application
Assignment, such as " 1,3,9 " and " 1,9 " are carried out at the odd number ordered series of numbers of integral multiple each other.
Preferably, in step (5) weight matrix it is specific foundation and calculation method are as follows:
After carrying out information calling for floristics and quantify, index factor at different levels described in each floristics is obtained
Value, the value of the index factors at different levels is compared two-by-two, relatively important value is obtained, analytic hierarchy process (AHP) is established in Excel
Weight matrix, set the normalized weight of index factor as wi=(w1, w2, w3 ... ...), weight matrix includes that data number is
N=(1,2,3 ...), thus obtains the calculation formula of the normalized weightCalculate each floristics fingers at different levels
Mark the weight of the factor.
Preferably, the specific operation process in step (7) are as follows:
It is substituted into according to mathematical model and data, weight, the level-one for obtaining each floristic index factors at different levels are commented
The score value of valence index and two-level appraisement index calculates each floristic landscape performance comprehensive evaluation index.
Preferably, the specific operation process in step (9) are as follows:
For each floristic landscape performance comprehensive evaluation index and Landscape Design scheme landscape performance
Overall merit score value generates chart using the tables of data of Excel, and subtype selects stacked column graph, can be according to analysis demand
It is arranged chart data " series " (i.e. legend item), and " series " shown by chart can be adjusted flexibly, for ornamental plant landscape
Performance carries out the specific aim analysis of various aspects.
Preferably, the stacked column graph is also divided into:
Floristics overall merit chart, floristics subitem judgement schematics, plant schemes synthesis judgement schematics, plant side
Case subitem judgement schematics, plant scheme layering subitem judgement schematics etc..
Preferably, the specific operation process in step (10) are as follows:
For each floristics ornamental plant landscape performance comprehensive evaluation index total score, level-one evaluation index point
Value, two-level appraisement index score value and the Landscape Design scheme ornamental plant landscape performance overall merit total score, level-one
Evaluation index score value, two-level appraisement index score value propose that targetedly design optimization strategy, strategy include mainly to plants landscape
Floristic application selection proposes targetedly design and optimisation strategy, to each in Landscape Design scheme in design scheme
Floristic number of applications selection proposes targetedly design and optimisation strategy.Thus scheme optimization is carried out for the later period, realize
Plant Design scheme is landed the whole of landscape performance and is promoted, and foundation and data supporting are provided.
The invention has the following beneficial effects:
1, multi-level ornamental plant landscape performance overall evaluation system reference value is higher and makes appraisement system more
Rationally, it relative to language discourse single in Traditional Landscape Performance Evaluation System, can be obtained by mathematical model and data call
To quantitative evaluation result, and can be with more intuitive understanding to each floristic landscape performance by stacked column graph;
It is called by the information to multivariate data platform, data are more objective reliable, and evaluation result reference value is high;According to calculated result
Targeted design scheme optimization strategy is proposed with chart, it thus can be according to the plant for quantifying visual evaluation result progress next step
Landscape design scheme optimization is promoted, and adjusts corresponding floristics and quantity selection, operates convenient and has science.
2, level-one evaluation index includes form ornamental value, ecology influence and economic input amount, and can further be expanded,
Enrich the science of traditional ornamental plant landscape performance appraisal;Two-level appraisement index is the further thin of team and evaluation index
Change, so that appraisement system reference value is higher and makes appraisement system more reasonable.
3, the calling of data information is by being associated with progress between Excel worksheet and book, module and entry information
It calls directly, initial information is all from the objective characteristic information of plant itself, enhances the science of appraisement system.
4, each floristics ornamental plant landscape performance comprehensive evaluation index calculation formula,It is based on
Above-mentioned calculation formula can add up index factors at different levels with the product of corresponding weight, see to obtain each floristics
Appreciate plants landscape performance comprehensive evaluation index Mj.
5, the calculation formula of Landscape Design scheme landscape performance overall merit score value,Based on upper
Stating calculation formula can be by each floristics ornamental plant landscape performance comprehensive evaluation index of Landscape Design scheme and nursery stock
The product of the number of applications of the corresponding each plant of table adds up, and comments to obtain Landscape Design scheme landscape performance synthesis
Valence score value P.
6, on the basis of quantitative calculating ornamental plant landscape performance overall merit score, it joined ornamental plant landscape achievement
The drafting of effect judgement schematics and visual data representation, landscape achievement that is more intuitive, clearly showing Landscape Design scheme
Effect evaluation.
7, for each floristics ornamental plant landscape performance comprehensive evaluation index total score, level-one evaluation index point
Value, two-level appraisement index score value and the Landscape Design scheme ornamental plant landscape performance overall merit total score, level-one
Evaluation index score value, two-level appraisement index score value propose that targetedly design optimization strategy, strategy include mainly to plants landscape
Floristic application selection proposes targetedly design and optimisation strategy, to each in Landscape Design scheme in design scheme
Floristic number of applications selection proposes targetedly design and optimisation strategy.Thus scheme optimization is carried out for the later period, realize
Plant Design scheme is landed the whole of landscape performance and is promoted, and foundation and data supporting are provided.
Detailed description of the invention
Fig. 1 is the method flow diagram of ornamental plant of embodiment of the present invention landscape performance integrated evaluating method;
Fig. 2 is that the embodiment of the present invention 1 forms 242 provincial highway Hei Lin charge station Office Area practical application of Jiangsu Province Lianyungang
Ornamental plant form Performance Rating figure;
Fig. 3 is that the embodiment of the present invention 1 forms 242 provincial highway Hei Lin charge station Office Area practical application of Jiangsu Province Lianyungang
Ornamental plant ecology Performance Rating figure;
Fig. 4 is that the embodiment of the present invention 1 forms 242 provincial highway Hei Lin charge station Office Area practical application of Jiangsu Province Lianyungang
Ornamental plant economic achievement score figure;
Fig. 5 is that the embodiment of the present invention 1 forms 242 provincial highway Hei Lin charge station Office Area practical application of Jiangsu Province Lianyungang
One comprehensive score figure of plant scheme;
Fig. 6 is that the embodiment of the present invention 1 forms 242 provincial highway Hei Lin charge station Office Area practical application of Jiangsu Province Lianyungang
Plant scheme subitem scoring figure;
Fig. 7 is that the embodiment of the present invention 1 forms 242 provincial highway Hei Lin charge station Office Area practical application of Jiangsu Province Lianyungang
Ornamental plant type comprehensive score figure;
Fig. 8 is that the embodiment of the present invention 1 forms 242 provincial highway Hei Lin charge station Office Area practical application of Jiangsu Province Lianyungang
Plant scheme subitem scoring arbor scoring figure;
Fig. 9 is that the embodiment of the present invention 1 forms 242 provincial highway Hei Lin charge station Office Area practical application of Jiangsu Province Lianyungang
Plant scheme subitem scoring shrub scoring figure;
Figure 10 is the embodiment of the present invention 1 to 242 provincial highway Hei Lin charge station Office Area practical application shape of Jiangsu Province Lianyungang
At plant scheme subitem scoring draft be scored figure;
Figure 11 is the embodiment of the present invention 2 to 242 provincial highway Hei Lin charge station Office Area practical application shape of Jiangsu Province Lianyungang
At evaluation index result.
Specific embodiment
With reference to the accompanying drawings and detailed description, the present invention is furture elucidated, it should be understood that following specific embodiments are only
For illustrating the present invention rather than limiting the scope of the invention.
Embodiment 1
As shown in Figure 1 to 11, a kind of construction method of ornamental plant landscape performance comprehensive evaluation model, evaluation model packet
Include that Excel database information calling module is formed a team, Excel hierarchical model building module forms a team model, structure are presented immediately with Excel
Construction method the following steps are included:
(1) analytic hierarchy process (AHP) is used, ornamental plant landscape performance comprehensive evaluation index is determined and successively parses, construction multilayer
The ornamental plant landscape performance overall evaluation system of secondary multielement, multi-level ornamental plant landscape performance overall evaluation system ginseng
It examines and is worth higher and makes appraisement system more reasonable;
(2) evaluation criterion detailed rules and regulations are formulated according to the ornamental plant landscape Performance Evaluation System and plant characteristics information;
(3) according to ornamental plant landscape performance overall evaluation system and the ornamental plant landscape Performance Evaluation System
With being associated with for ornamental plant characteristic information, data call is carried out by the plant information multivariate data library relied on, obtains Lianyun Harbour
The index of correlation data of 242 provincial highway Hei Lin charge station Office Area Landscape Design scheme of city, data are objective reliable, reference value
It is high;
(4) according to the evaluation criterion detailed rules and regulations to the ornamental plant characteristic information called by Plant Records Database into
Row quantification treatment obtains the value of index factors at different levels, and is stored in Excel database information calling module and forms a team;
(5) it forms a team in Excel hierarchical model building module and establishes weight judgment matrix, according to the index factors at different levels
Value compares two-by-two establishes matrix, calculates the weighted value of index factors at different levels;
(6) design site condition and design requirement are judged according to the evaluation criterion detailed rules and regulations, obtains indexs at different levels
The score value of the factor;
(7) founding mathematical models set 242 Office Area Landscape Design scheme institute, provincial highway Hei Lin charge station of Lianyungang
It is Mj using each floristic ornamental plant landscape performance comprehensive evaluation index, the weight of the index factors at different levels is mi=
The score value of (m1, m2, m3 ...), the index factors at different levels are vi=(v1, v2, v3 ...), thus obtain the synthesis and comment
The calculation formula of valence index,It can be by the corresponding power of index factors at different levels based on above-mentioned calculation formula
Weight product adds up, to obtain each floristic ornamental plant landscape performance comprehensive evaluation index Mj;
(8) each floristics ornamental plant landscape performance comprehensive evaluation index Mj is applied according to Landscape Design scheme
=(M1,M2,M3... ...), set the landscape achievement of 242 provincial highway Hei Lin charge station Office Area Landscape Design scheme of Lianyungang
Effect overall merit score value is P, and it is Nj=(N that the number of applications of plant is called by design scheme nursery stock table1,N2,N3... ...), thus
The calculation formula of the Landscape Design scheme landscape performance overall merit score value is obtained,Based on upper
The product of the corresponding comprehensive evaluation index of each floristics can be added up by stating calculation formula, to obtain plants landscape
The landscape performance overall merit score value P of design scheme;
(9) module is presented immediately in Excel to form a team, calculates data evaluation as a result, simultaneously giving birth to immediately according to mathematical formulae is calculated
At ornamental plant landscape performance appraisal stacked column graph, planted in quantitative 242 provincial highway Hei Lin charge station Office Area of calculating Lianyungang
On the basis of object view sees design scheme landscape performance comprehensive evaluation result, drawing for ornamental plant landscape performance appraisal chart joined
System and visual data representation, more intuitive, clearly displaying Landscape Design scheme landscape performance appraisal is as a result, simultaneously
It can be with the strengths and weaknesses of more intuitive understanding to each ornamental plant type landscape performance in all fields;
(10) according to calculated result and ornamental plant landscape performance appraisal stacked column graph, Landscape Design scheme is mentioned
Specific aim optimisation strategy out.
Based on above technical scheme, multi-level ornamental plant landscape performance overall evaluation system reference value is higher and makes
It is more reasonable to obtain appraisement system, it, can by mathematical model and data call relative to the language description in traditional appraisement system
Quantitative evaluation result is obtained, and can be answered with more intuitive understanding into Landscape Design scheme by stacked column graph
The landscape performance strengths and weaknesses of each floristics in all respects;By calling directly acquisition data information by multivariate data library,
Opposite to be given a mark with existing evaluation method using the description of expert or technical staff, data are relatively reliable and objective, evaluation result ginseng
It is high to examine value;It is proposed that specific aim optimizes Promotion Strategy according to calculated result and stacked column graph, thus can be visual according to quantization
Evaluation result carries out the Plant Design scheme optimization of next step, formulates corresponding strategy, easy to operate and have science.
In the present embodiment, the specific operation process of step (1) is to divide the ornamental plant landscape performance evaluating index
Solution be level-one evaluation index and two-level appraisement index, the level-one evaluation index include at present form ornamental value, ecology influence,
Economic input amount, further enrich and traditional ornamental plant landscape performance appraisal it is comprehensive and scientific, the second level is commented
Valence index is the further refinement to level-one evaluation index, so that appraisement system reference value is higher and makes appraisement system
More rationally.The specific thinning process of further two-level appraisement index are as follows: the form ornamental value is resolved into aspect leaf color,
Developmental rhythm, limb ornamental value, fruit ornamental value, fruit viewing period, flower ornamental value, florescence, fragrance, single plant canopy density, branch
Point height, spatial distribution level;The ecology influence is decomposed into impoverishment tolerant, cold resistance, illumination habit, shade tolerance is resistance to
Arid, resistance to water-wet, soil property adaptability, soil acid-base adaptability, Saline alkali tolerance, wind resistance, root system depth, pollutant absorb special
Property, carbon sequestration put oxygen ability, noise reduction capability, regulation of absorbing dust capability, biological safety;The economic input amount is resolved into buying difficulty or ease journey
Degree, buying cost, the speed of growth, life cycle, resistance to trimming, fertilizer requirement.
Specifically, in step (2) evaluation criterion detailed rules and regulations formulation process are as follows: use for reference Landscape Design requirement description and institute
Rely on the parsing standard of plant characteristics information in plant information multivariate data library, the ornamental plant targeted to two-level appraisement index
Characteristic is described, and the content of description is appointed as evaluation criterion detailed rules and regulations.Corresponding evaluation criterion detailed rules and regulations are as above-mentioned plant
The carrier of landscape design scheme Correlation method for data processing, 242 Office Area Landscape Design side, provincial highway Hei Lin charge station of Lianyungang
The index of correlation data of case carry out assignment calculating by evaluation criterion detailed rules and regulations, and each floristics index factors at different levels can be obtained
Value.
Specifically, in step (3) 242 provincial highway Hei Lin charge station Office Area Landscape Design scheme of Lianyungang correlation
Achievement data, it is polynary by the plant information relied on according to being associated with for the two-level appraisement index and ornamental plant characteristic information
Database carries out data call composition.
Specifically, quantifying in step (4) to the ornamental plant characteristic information called by Plant Records Database
Processing, it is pointed out that according to the evaluation criterion detailed rules and regulations carry out VBA write condition assignment statement, and carry out it is macro fixed
Justice, index of correlation data information calling after, executed in Excel it is macro, carry out data information assignment calculate, obtain Lianyun Harbour
The value of each floristics index factors at different levels in 242 provincial highway Hei Lin charge station Office Area Landscape Design scheme of city.
In the present embodiment, step (5) in the weight calculation of index factors at different levels, construct mould in Excel hierarchical model
Block, which is formed a team, establishes multiple weight judgment matrix modules, including a rule layer weight judgment matrix module and multiple solution layer weights
Judgment matrix module is compared two-by-two according to the value of the index factors at different levels, obtains relatively important value, build in Excel
The weight matrix of vertical analytic hierarchy process (AHP), the power of index factors at different levels is calculated using the calculation formula of the normalized weight of weight matrix
Weight values.
Specifically, according to the evaluation criterion detailed rules and regulations as above-mentioned Landscape Design scheme related data in step (6)
The carrier of processing judges the site condition and design requirement of 242 provincial highway Hei Lin charge station Office Area of Lianyungang, to phase
It closes achievement data and carries out assignment calculating by evaluation criterion detailed rules and regulations, the score value of index factors at different levels can be obtained.
In the present embodiment, the specific operation process in step (7) are as follows: substituted into, connected according to mathematical model and data
Each floristic ornamental plant scape applied in 242 provincial highway Hei Lin charge station Office Area Landscape Design scheme of cloud harbor city
See the score value of performance comprehensive evaluation index total score and every level-one evaluation index, two-level appraisement index.
In the present embodiment, the specific operation process in step (8) are as follows: substituted into, connected according to mathematical model and data
The ornamental plant landscape performance comprehensive evaluation index of 242 provincial highway Hei Lin charge station Office Area Landscape Design scheme of cloud harbor city is total
The score value of score value and every level-one evaluation index, two-level appraisement index.
In the present embodiment, the specific operation process of step (9) are as follows: according to each floristic ornamental plant obtained above
Object view sees performance comprehensive evaluation index total score and every level-one evaluation index, the score value of two-level appraisement index and plants landscape are set
Point of the ornamental plant landscape performance comprehensive evaluation index total score of meter scheme and every level-one evaluation index, two-level appraisement index
Value, generates stacked column graph in Excel respectively: floristics overall merit chart, floristics subitem judgement schematics and plant
Object space case overall merit chart, plant scheme subitem judgement schematics, plant scheme layering subitem judgement schematics.
Specifically, the specific operation process in step (10) are as follows: comprehensive for each floristic ornamental plant landscape performance
Close evaluation number total score and every level-one evaluation index, the score value of two-level appraisement index and watching for Landscape Design scheme
The score value of plants landscape performance comprehensive evaluation index total score and every level-one evaluation index, two-level appraisement index, proposes to be directed to
Property design optimization strategy, strategy mainly include to application floristic in Landscape Design scheme select propose specific aim
Design and optimisation strategy, floristic number of applications selection each in Landscape Design scheme is proposed targetedly to design
And optimisation strategy.Thus scheme optimization carried out for the later period, realize that Plant Design scheme is landed the whole of landscape performance and promoted, provide
Foundation and data supporting.
In conclusion using the ornamental plant landscape performance integrated evaluating method and evaluation model of the embodiment of the present invention, it is more
The ornamental plant landscape performance overall evaluation system reference value of level is higher and makes appraisement system more reasonable, relative to biography
Single language discourse, quantitative evaluation knot can be obtained by mathematical model and data call in landscape Performance Evaluation System of uniting
Fruit, and can be with more intuitive understanding to each floristic landscape performance by stacked column graph;By to multivariate data
The information of platform is called, and data are more objective reliable, and evaluation result reference value is high;It is directed to according to calculated result and chart proposition
Property design scheme optimisation strategy, thus can according to quantify visual evaluation result carry out next step Landscape Design scheme it is excellent
Change and promoted, adjust corresponding floristics and quantity selection, operates convenient and there is science.
The above is only the present invention to the preliminary foundation of ornamental plant landscape performance comprehensive evaluation model and to ornamental plant
Object view sees the preliminary formulation of performance System of Comprehensive Evaluation, can also make several improvement and replacement, these are improved and replacement
Also it should be regarded as protection scope of the present invention.
The technical means disclosed in the embodiments of the present invention is not limited only to technological means disclosed in above embodiment, further includes
Technical solution consisting of any combination of the above technical features.It should be pointed out that for those skilled in the art
For, various improvements and modifications may be made without departing from the principle of the present invention, these improvements and modifications are also considered as
Protection scope of the present invention.
Claims (10)
1. a kind of construction method of ornamental plant landscape performance comprehensive evaluation model, it is characterised in that:
Evaluation model includes that Excel database information calling module is formed a team, Excel hierarchical model building module is formed a team and Excel
Immediately model is presented, the construction method of evaluation model includes the following steps:
(1) analytic hierarchy process (AHP) is used, the comprehensive evaluation index of ornamental plant landscape performance is determined and successively parses, building is multi-level
The ornamental plant landscape Performance Evaluation System of multielement.
(2) evaluation criterion detailed rules and regulations are formulated according to the ornamental plant landscape Performance Evaluation System and plant characteristics information;
(3) being associated with according to the ornamental plant landscape Performance Evaluation System and ornamental plant characteristic information, it is more by what is relied on
Metadata plant information library carries out data call;
(4) according to the evaluation criterion detailed rules and regulations to the ornamental plant characteristic information amount of progress called by Plant Records Database
Change processing, obtains the value of index factors at different levels, and be stored in Excel database information calling module and form a team;
(5) it forms a team in Excel hierarchical model building module and establishes weight judgment matrix, according to the value two of the index factors at different levels
Two compare and establish matrix, calculate the weighted value of index factors at different levels;
(6) design site condition and design requirement are judged according to the evaluation criterion detailed rules and regulations, obtains index factors at different levels
Score value;
(7) founding mathematical models, set each floristics ornamental plant landscape performance comprehensive evaluation index as Mj, described each
The weight of grade index factor is mi=(m1, m2, m3 ...), the score values of the index factors at different levels be vi=(v1, v2,
V3 ...), the calculation formula of the comprehensive evaluation index is thus obtained,
(8) it according to the ornamental plant landscape performance comprehensive evaluation index Mj=(M1, M2, M3 ... ...), sets plants landscape and sets
The landscape performance overall merit score value of meter scheme be P, by nursery stock table call plant number of applications be Nj=(N1, N2,
N3 ... ...), the calculation formula of the Landscape Design scheme landscape performance overall merit score value is thus obtained,
(9) module is presented immediately in Excel to form a team, calculates data evaluation as a result, simultaneously in-time generatin is seen according to mathematical formulae is calculated
Appreciate plants landscape performance appraisal stacked column graph;
(10) according to calculated result and ornamental plant landscape performance appraisal stacked column graph, needle is proposed to Landscape Design scheme
To property optimisation strategy.
2. the method as described in claim 1, it is characterised in that: specific operation process in step (1) are as follows: to the ornamental plant
Landscape performance evaluating index is decomposed into level-one evaluation index and two-level appraisement index, and the level-one evaluation index includes that form is ornamental
Property, ecology influence, economic input amount, the two-level appraisement index is refinement to level-one evaluation index.
3. method according to claim 2, it is characterised in that: the specific thinning process of the two-level appraisement index are as follows: by institute
It states form ornamental value and resolves to aspect leaf color, developmental rhythm, limb ornamental value, fruit ornamental value, fruit viewing period, Hua Guanshang
Property, florescence, fragrance, single plant canopy density, branch point height, spatial distribution level;The ecology influence is decomposed into impoverishment tolerant
Property, it is cold resistance, illumination habit, shade tolerance, drought-resistant, resistance to water-wet, soil property adaptability, soil acid-base adaptability, Saline alkali tolerance, anti-
Wind, root system depth, pollutant absorption characteristic, carbon sequestration put oxygen ability, noise reduction capability, regulation of absorbing dust capability, biological safety;It will be described
Economic input amount resolves to buying complexity, buying cost, the speed of growth, life cycle, resistance to trimming property, fertilizer requirement.
4. the method as described in claim 1, it is characterised in that: multivariate data plant information library carries out data tune in step (3)
With process are as follows: according to being associated with for the two-level appraisement index and ornamental plant characteristic information, establish work using Excel function
Table and book, window module are formed a team being associated between entry, are formed a team to multivariate data library plant information memory module
Corresponding informance is called, and recalls information is stored in Excel database information calling module and is formed a team.
5. the method as described in claim 1, it is characterised in that: quantification treatment process in step (4) are as follows: with the evaluation criterion
Detailed rules and regulations are defined multiple according to the macro of condition assignment as assignment condition using the VBA programming technique of Excel, are deposited in information calling
Chu Hou executes the macro quantization to carry out text information.
6. method as claimed in claim 6, it is characterised in that: specific tax of the evaluation criterion detailed rules and regulations as assignment condition
Value method are as follows: index factor comment is divided into three layers or two layers of comment according to evaluation criterion detailed rules and regulations, using nine rank assignment methods, application
Assignment is carried out at the odd number ordered series of numbers of integral multiple each other.
7. the method as described in claim 1, it is characterised in that: the specific foundation and calculation method of weight matrix in step (5)
Are as follows: after carrying out information calling for floristics and quantify, the value of index factor at different levels described in each floristics is obtained, by institute
The value for stating index factors at different levels is compared two-by-two, obtains relatively important value, and the weight square of analytic hierarchy process (AHP) is established in Excel
Battle array, sets the normalized weight of index factor as wi=(w1, w2, w3 ... ...), weight matrix include data number for n=(1,2,
3 ...) calculation formula of the normalized weight, is thus obtainedCalculate the power of each floristics index factors at different levels
Weight.
8. the method as described in claim 1, it is characterised in that: the specific operation process in step (7) are as follows: according to mathematical model
It is substituted into data, obtains the weight, the level-one evaluation index and two-level appraisement index of each floristic index factors at different levels
Score value, calculate each floristic landscape performance comprehensive evaluation index.
9. the method as described in claim 1, it is characterised in that: the specific operation process in step (9) are as follows: be directed to each plant
The landscape performance comprehensive evaluation index and Landscape Design scheme landscape performance overall merit score value of species utilize
The tables of data of Excel generates chart, and subtype selects stacked column graph, according to analysis demand setting chart data series, is
Column are legend item, and series shown by chart can be adjusted flexibly.
10. a kind of ornamental plant landscape performance comprehensive evaluation model, it is characterised in that: evaluation model includes Excel database letter
Breath calling module is formed a team, Excel hierarchical model building module forms a team and model is presented immediately with Excel.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201910407314.6A CN110111019A (en) | 2019-05-16 | 2019-05-16 | A kind of ornamental plant landscape performance comprehensive evaluation model and construction method |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201910407314.6A CN110111019A (en) | 2019-05-16 | 2019-05-16 | A kind of ornamental plant landscape performance comprehensive evaluation model and construction method |
Publications (1)
Publication Number | Publication Date |
---|---|
CN110111019A true CN110111019A (en) | 2019-08-09 |
Family
ID=67490463
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201910407314.6A Pending CN110111019A (en) | 2019-05-16 | 2019-05-16 | A kind of ornamental plant landscape performance comprehensive evaluation model and construction method |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN110111019A (en) |
Cited By (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN111582690A (en) * | 2020-04-28 | 2020-08-25 | 深圳文科园林股份有限公司 | Ground cover plant evaluation method, terminal and computer readable storage medium |
CN111738553A (en) * | 2020-05-25 | 2020-10-02 | 杭州易大景观设计有限公司 | Computer software for configuring color seasonal diversity based on plants |
CN111887085A (en) * | 2020-07-22 | 2020-11-06 | 广州市雅玥园林工程有限公司 | Plant cluster modularized culture technology |
CN111914339A (en) * | 2020-09-21 | 2020-11-10 | 北京林业大学 | Landscape performance evaluation-based landscape and garden landscape design method and system |
CN114971345A (en) * | 2022-06-08 | 2022-08-30 | 东南大学 | Quality measuring method, equipment and storage medium for built environment |
Citations (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN105740613A (en) * | 2016-01-28 | 2016-07-06 | 西安建筑科技大学 | AHP based artificial landscape water health comprehensive evaluation method |
CN107909306A (en) * | 2017-12-23 | 2018-04-13 | 广州市城市规划勘测设计研究院 | A kind of urban landscape style and features evaluation method |
-
2019
- 2019-05-16 CN CN201910407314.6A patent/CN110111019A/en active Pending
Patent Citations (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN105740613A (en) * | 2016-01-28 | 2016-07-06 | 西安建筑科技大学 | AHP based artificial landscape water health comprehensive evaluation method |
CN107909306A (en) * | 2017-12-23 | 2018-04-13 | 广州市城市规划勘测设计研究院 | A kind of urban landscape style and features evaluation method |
Non-Patent Citations (1)
Title |
---|
马文倩等: "《数字景观-中国第三届数字景观国际论坛》", 31 October 2017 * |
Cited By (7)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN111582690A (en) * | 2020-04-28 | 2020-08-25 | 深圳文科园林股份有限公司 | Ground cover plant evaluation method, terminal and computer readable storage medium |
CN111738553A (en) * | 2020-05-25 | 2020-10-02 | 杭州易大景观设计有限公司 | Computer software for configuring color seasonal diversity based on plants |
CN111887085A (en) * | 2020-07-22 | 2020-11-06 | 广州市雅玥园林工程有限公司 | Plant cluster modularized culture technology |
CN111914339A (en) * | 2020-09-21 | 2020-11-10 | 北京林业大学 | Landscape performance evaluation-based landscape and garden landscape design method and system |
CN111914339B (en) * | 2020-09-21 | 2023-06-09 | 北京林业大学 | Landscape architecture design method and system based on landscape performance evaluation |
CN114971345A (en) * | 2022-06-08 | 2022-08-30 | 东南大学 | Quality measuring method, equipment and storage medium for built environment |
CN114971345B (en) * | 2022-06-08 | 2023-04-18 | 东南大学 | Quality measuring method, equipment and storage medium for built environment |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN110111019A (en) | A kind of ornamental plant landscape performance comprehensive evaluation model and construction method | |
Hájek et al. | Current state and future directions of bioeconomy in the Czech Republic | |
Hairiah et al. | Carbon stocks of tropical land use systems as part of the global C balance | |
Zhou | Ecological civilization in China: Challenges and strategies | |
Kang et al. | Evaluating management tradeoffs between economic fiber production and other ecosystem services in a Chinese-fir dominated forest plantation in Fujian Province | |
Eriksen et al. | The dynamic context of southern African savannas: investigating emerging threats and opportunities to sustainability | |
Taherkhani et al. | Sustainable cities through the right selection of vegetation types for green roofs | |
Giampietro et al. | Sustainable development: scientific and ethical assessments | |
Raintree et al. | Appropriate R&D support for forestry extension | |
Tian | Analysis of the artistic effect of garden plant landscaping in urban greening | |
Hu et al. | Ecological civilization construction and green development | |
Wei et al. | The sustainable development of a low-carbon system using a system dynamics model: A case study of China | |
Johnson et al. | Exploring the Waterenergy-food Nexus in Rwanda's Akagara Basin | |
Grajales et al. | A proposed model for the adoption of green roofs in horizontal property | |
Lijie et al. | Evaluating the Impacts of Rice Technological Innovation on the Social Economy | |
Trinugraha | Water for “Food” or Water for “Drink”? Political Ecology of Water Conflict in Rural Java Indonesia | |
FAN et al. | Policy approaches to increase carbon sequestration capacity by optimizing layouts of ecological construction | |
Yousaf et al. | Islamabad, Pakistan | |
Li et al. | Spatial-temporal evolution of the coupling state of agricultural socio-ecologo-economic system in North China Plain | |
Zhou et al. | Evaluation of Leisure Agriculture Efficiency and Development Path Innovation under the Supply Side Horizon: Survey Data from Huangpi District | |
Nabongho | The role of urban forestry to the socio-economic welfare of the urban dwellers in Bugweri town council, Bugweri district | |
De et al. | Sustainability Management Issues–Social, Cultural and Economic Perspectives | |
Fogelqvist et al. | Urban gardening & sustainable consumption | |
Wang | Coordination and Deepening of Agricultural Development in Yangtze River Economic Belt | |
Garcia-Holguera | Ecomimetics: an ecosystem-based biomimetic design method for innovative built environments |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
PB01 | Publication | ||
PB01 | Publication | ||
SE01 | Entry into force of request for substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
RJ01 | Rejection of invention patent application after publication | ||
RJ01 | Rejection of invention patent application after publication |
Application publication date: 20190809 |