CN107766415B - The inefficient industrial land method for quickly identifying in cities and towns based on electricity consumption data - Google Patents

The inefficient industrial land method for quickly identifying in cities and towns based on electricity consumption data Download PDF

Info

Publication number
CN107766415B
CN107766415B CN201710803361.3A CN201710803361A CN107766415B CN 107766415 B CN107766415 B CN 107766415B CN 201710803361 A CN201710803361 A CN 201710803361A CN 107766415 B CN107766415 B CN 107766415B
Authority
CN
China
Prior art keywords
cities
towns
electricity consumption
land
data
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.)
Active
Application number
CN201710803361.3A
Other languages
Chinese (zh)
Other versions
CN107766415A (en
Inventor
邓小兵
赵渺希
何元权
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
South China University of Technology SCUT
Original Assignee
South China University of Technology SCUT
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by South China University of Technology SCUT filed Critical South China University of Technology SCUT
Priority to CN201710803361.3A priority Critical patent/CN107766415B/en
Publication of CN107766415A publication Critical patent/CN107766415A/en
Application granted granted Critical
Publication of CN107766415B publication Critical patent/CN107766415B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/21Design, administration or maintenance of databases
    • G06F16/215Improving data quality; Data cleansing, e.g. de-duplication, removing invalid entries or correcting typographical errors
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/245Query processing
    • G06F16/2458Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
    • G06F16/2462Approximate or statistical queries
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/248Presentation of query results
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/29Geographical information databases
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION 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/00Administration; Management
    • G06Q10/06Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
    • G06Q10/063Operations research, analysis or management
    • G06Q10/0639Performance analysis of employees; Performance analysis of enterprise or organisation operations
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION 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
    • G06Q50/00Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
    • G06Q50/10Services
    • G06Q50/26Government or public services
    • YGENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y02TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
    • Y02DCLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
    • Y02D10/00Energy efficient computing, e.g. low power processors, power management or thermal management

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Business, Economics & Management (AREA)
  • Physics & Mathematics (AREA)
  • General Physics & Mathematics (AREA)
  • Databases & Information Systems (AREA)
  • Human Resources & Organizations (AREA)
  • General Engineering & Computer Science (AREA)
  • Data Mining & Analysis (AREA)
  • Educational Administration (AREA)
  • Tourism & Hospitality (AREA)
  • Strategic Management (AREA)
  • Economics (AREA)
  • Development Economics (AREA)
  • Marketing (AREA)
  • Computational Linguistics (AREA)
  • Quality & Reliability (AREA)
  • Entrepreneurship & Innovation (AREA)
  • General Business, Economics & Management (AREA)
  • Probability & Statistics with Applications (AREA)
  • General Health & Medical Sciences (AREA)
  • Primary Health Care (AREA)
  • Software Systems (AREA)
  • Fuzzy Systems (AREA)
  • Mathematical Physics (AREA)
  • Game Theory and Decision Science (AREA)
  • Operations Research (AREA)
  • Health & Medical Sciences (AREA)
  • Remote Sensing (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)

Abstract

The invention discloses a kind of inefficient industrial land method for quickly identifying in cities and towns based on electricity consumption data, including:To the Traffic Net of cities and towns industrial land patch, land used, enterprise, it is collected for radio area, monthly electricity consumption data;Each factor data is screened by development status, address;Default and abnormal factor data is modified by VC Method, land area, monthly ground electricity consumption mean value;Each factor data is matched by high definition satellite mapping, geographical coordinate;Each factor data is checked by topological relation, address;To the moon electricity consumption is identified less than the patch of state's household electric standard, generates the inefficient industrial land in cities and towns and identifies distribution map.Whether the present invention is based on commercial power data to identify the inefficient industrial land in cities and towns, made full use of in this, as evaluation present situation cities and towns industrial land patch, if has transformation with the basis of redevelopment potentiality, realizes that cities and towns industrial land patch High-efficiency Sustainable utilizes.

Description

The inefficient industrial land method for quickly identifying in cities and towns based on electricity consumption data
Technical field
The present invention relates to a kind of inefficient industrial land method for quickly identifying in cities and towns, the cities and towns for being based especially on electricity consumption data are low Industrial land method for quickly identifying is imitated, town planning technical field is belonged to.
Background technology
According to prediction industrial research institute《Chinese soil is developed industry market prediction and is reported with investment strategy planning application》, I State's construction land area increased 6.44 from 6720 square kilometres of be expanded to 2014 4.99 ten thousand square kilometres in 1981 Times, average growth rate per annum is average annual to increase by 1265 square kilometres of area, the apparent expansion situation of presentation up to 6.27%.In addition, data are shown It is 129.57 square metres that Chinese city in 2014 builds area per capita, well beyond 85.1 to 105.0 square metres of national standard/ People is also apparently higher than developed country's 84.4 square metres and other developing countries 83.3 square metres of level per capita per capita.It is another Aspect, since " 13 ", under the requirement of supply side structural reform, adjustment industrial structure is cleared up corpse enterprise and is drawn Lead the important content that regulation and control city size, Optimizing City space structure etc. have become current economic structural adjustment[1].Therefore, change Inefficient land used Land use systems vitalize inefficient industrial land, carry out intensive utilization, and it is to carry that the redevelopment of inefficient industrial land, which is utilized, High land resources utilization efficiency alleviates an important channel of urban land demand pressure[2]
Supply side structural reform since " 13 " objectively proposes industry with land use to industrial development and moves back Two into three, industry makes the transition to innovative industrial upgrading, and for land use from extensive to new demands such as fining transition, these are to alleviate Contradiction between town site demand and upgrading industry, raising land utilization efficiency, it is inefficient industrial to vitalize city storage The important channel on ground.Storage redevelopment in recent years, " three is old " transformation, city is double repair etc. policies explore inefficient construction land, It is constantly trying to and promotes on the road of inefficient industrial conversion, pass through the adjustment and transformation to similar industrial and land used, fully profit With the inefficient industrial land in city, city size is controlled, Optimizing City space structure, it is mating to improve city, improves urban disease, reaches Alleviate contradictory purpose between town site demand and national Transformation Development requirement.The inefficient industrial land identification in city is city The prerequisite of city's industrial land transformation and upgrade, therefore, identification and evaluation for the inefficient industrial land in cities and towns just seem especially It is basic and important.Past is due to the limitation of valid data and technological means, the identification of the inefficient industrial land in cities and towns and appraisement system Often there is the problems such as basis of characterization objectivity is insufficient, recognition methods is complicated, recognition result practicability is insufficient, it is inefficient for cities and towns The identification of industrial land lacks always a kind of method finely calculated with evaluation.
After the industrial revolution, electric power is economical and society brings deep change, and people are usually using electricity consumption as weighing apparatus The important indicator of the economic quality of amount.2010, the famous political economy magazine of Britain《Economist》It releases and increases for assessing China's GDP The index " gram strong index " of amount:Industrial electricity is newly-increased, and volume of rail freigh is newly-increased and bank's medium-term and long-term credit increases three indexs newly Combination, suit China's economic characteristics.The number of " power consumption ", can relatively accurately reflect industrial liveness and The utilization of capacity of factory.
Currently, the domestic research that inefficient industrial land, inefficient construction land are identified using electricity consumption data is seldom.Closely Nian Lai is mainly summarised as identification and the redevelopment correlative study method of inefficient industrial land, inefficient construction land following several Class:
1) collection of summary method compared by conventional survey interview, document, prove data:Feng Yingbin (2012), which is proposed, to be passed through The Innovation Exploring for increasing and decreasing hook between outer suburbs Land Use of Rural Residential Area and Urban Construction Land_use is realized in ground ticket transaction, and by agriculture Village takes in residential area idle sample investigation, and predictably ticket supplies potentiality, and ground ticket demand is calculated by the method that department summarizes[3]; Liu Xinping (2015) is summarized the experience by literature research, comparative study, practice innovation, is analyzed the inefficient construction land in cities and towns and is opened again The main reason for the lacking of capital of hair, predicaments such as property right complexity, is restriction and the missing of rule, and proposes and improve collective construction The solutions such as the rules such as land-use management, illegal land processing, land transfers and power of enforcement operation[4];Zheng irrigates woods (2016) utilization Data are collected in on-site inspection and interview, and build ordered probit model, and research influences Tianhe district of Guangzhou and built with Baiyun District rural area If the inefficient key factor utilized of land used[5]
2) by correlation between data, structure data model (pattern) come evaluate, verify, prediction data:Chen Zhu Peace (2011) by build assessment indicator system, standardize assessment indicator system, establish evaluation model, divide opinion rating to agriculture Village residential area redevelopment potentiality are calculated[6];Liu Hui (2014) etc. is repaiied by vector auto regression (V A R) model, vector error Positive (V E C) model, " gram strong index " interactive relationship between three indexs and economic growth is studied, and passes through Johansen The econometrics method such as co integration test and Granger Causality Tests tests to interactive relationship[7];Gu Shoubai (2015) with For the land control of Shanghai, propose to be effectively relieved the fund problem in land control with ppp patterns, and have studied ppp patterns Specific implementation path[8]
3) it is studied by the inefficient land current situation of assay, improves research method:Li Jing (2012) from perspective in research, research Method, finishing mode etc. analyze the inefficient land used regulation Potential Evaluation in China rural area and need to be closed with Land Use of Rural Residential Area area change Connection degree, social factor, which combine, does specific research[9];Ma Ansheng (2015) by the Three Eastern Provinces leave unused inefficient land used the differentiation of province domain, The case where distribution, region utilization rate and feature, analyze land used leave unused inefficient government, market, in terms of enterprise the reason of, and carry The planning mechanism of control for preventing soil and leaving unused inefficient, examination rewards and punishments mechanism, the length of dynamic monitoring mechanism, innovative technology mechanism are gone out Effect mechanism[10]
4) data are collected by high definition striograph:Zheng Rongbao (2014) utilizes the high-resolution remote sensing images such as QuickBird Guangzhou Baiyun District industrial land information is extracted, and the main reason for inefficient industrial land is formed is analyzed by questionnaire survey[11]
It is low with Reconstruc-tion policy or structure that the above research largely stresses the key factor that the inefficient land used of research influence is formed Potential Evaluation of redeveloping to effectiveness system, this early-stage study redeveloped for inefficient land used and later stage practice have important guiding Meaning.But one side traditional data collect and check and correction that there are data volumes is small, it is difficult to collect, data objectivity is insufficient, check and correction work Work amount is big, proofreads the defects of precision is insufficient, causes the inefficient industrial land identification in cities and towns to lack with evaluation a kind of more accurate, fast The strong data quantization methods of speed, operability.On the other hand, inefficient industrial for the inefficient construction land in cities and towns especially cities and towns Identifying for ground is insufficient with the data quantization system of evaluation, and it is incomplete according to objectivity deficiency, identification and evaluation object that there are identification and evaluations Face, the defects of identification and evaluation result reliability is insufficient.In addition, research industrial land is generally classified to middle class above, it is not refined to The group of specific industry.In addition, some scholars carry out inefficient research using industry GDP to a kind of, two classes or certain class industry, still Inefficient system research is not carried out to the industry of different industries classification.
The bibliography that the above content is mentioned is as follows:
[1] practice and thinking --- the territory in [J] by taking the area of Pearl River Delta as an example of the inefficient land used transformation in the great cities and towns Lai Wen Ground, 2016, (09):4-7.
[2] it soars, Cai Minting, Ding Yu, Yuan Ting, the rigid inefficient construction lands in the cities of Wu Zhi are stored up cost-benefit measuring and calculating and ground Study carefully --- the Guangdong [J] the soil science by taking Wenzhou City as an example, 2016, (01):9-15.
[3] Feng answers refined lands used for urban and rural construction projects with distributing under visual angle Chongqing City rationally ticket supply potentiality and equilibrium of supply and demand research [A] Geographical Society of China, Geographical Society of China of Science and Technology in Henan association Annual Conference abstract of papers collection in 2012 [C] Geographical Society of China, Science and Technology in Henan association:, 2012:2.
[4] Realistic Dilemma of the inefficient land used redevelopment of Liu Xinping, Yan Jinming, Wang Qing days Chinese cities and towns and rational choice [J] China Land Sciences, 2015, (01):48-54.
[5] Zheng Wolin, the inefficient analysis of Influential Factors utilized of field light rural technique markets --- with reported in Tianhe district of Guangzhou With [J] area studies for Baiyun District with hair, 2016, (06):104-108.
[6] Chen Zhuan, Zhang Liting once enabled power rural residential area Evaluation of land intensive use and Consolidation Potential measuring and calculating --- [J] guangdong agricultural sciences by taking the typical case village of Dongxiang County as an example, 2011, (14):146-147+160.
[7] the dynamic relationship research-of Liu Hui " gram strong index " and economic growth is based on the proof analysis of VAR and VEC models [J] commercial ages, 2014, (01):11-13.
[8] utilization [J] the Chinese soils of Gu Shoubai, Liu Wei, Xia Jing .PPP patterns in the land control of Shanghai, 2015, (09):43-46.
[9] Li Jing, Zhang Liting, Zeng Lingquan, Sun Xu pellet Rural Residential Land Consolidation Potentialities calculate the Anhui multi element research [J] Agricultural sciences, 2012, (08):4890-4892.
[10] Ma Ansheng, thunder margin is adjacent, Yuan Guohua, and the three provinces in the northeast of China Sun Ying leave unused inefficient land used genetic analysis and countermeasure and suggestion [J] Chinese population resource and environments, 2015, (S1):102-103.
[11] Zheng Rongbao, Zhang Chunhui, Chen Mei recruit the inefficient industrial land target identifications of and secondary development strategy study [J] states Soil is studied with natural resources, and 2014, (04):20-24..
Invention content
The purpose of the present invention is to solve the defects of the above-mentioned prior art, provide a kind of cities and towns based on electricity consumption data Inefficient industrial land method for quickly identifying, this method are based on commercial power data and identify the inefficient industrial land in cities and towns, in this, as Whether the cities and towns industrial land patch of evaluation present situation makes full use of, if has transformation with the basis of redevelopment potentiality, realizes city Town industrial land patch High-efficiency Sustainable utilizes.
The purpose of the present invention can be reached by adopting the following technical scheme that:
The inefficient industrial land method for quickly identifying in cities and towns based on electricity consumption data, the described method comprises the following steps:
S1, in some research range, to the Traffic Net of cities and towns industrial land patch, land used, enterprise, for radio station Area, monthly electricity consumption data are collected;Wherein, the land used data include area, property, boundary, title and development status, institute It includes enterprise name, address and longitude and latitude to state business data;
S2, according to the development status of cities and towns industrial land patch, with radio area address, enterprise name and enterprise address, it is right Land used, electricity consumption and the business data of cities and towns industrial land patch are screened;
S3, default and abnormal electricity consumption, business data are modified;
S4, the land used to cities and towns industrial land patch, electricity consumption and business data match;
S5, according to Traffic Net, with radio area address and enterprise address to the land used of cities and towns industrial land patch, use Electricity and business data are checked;
S6, to the moon of cities and towns industrial land patch electricity consumption data examine and correct again;
S7, to the cities and towns industrial land moon electricity consumption is identified less than the patch of construction land load index, into one Step generates the inefficient industrial land in cities and towns and identifies distribution map.
Preferably, in step S1, it is described to the Traffic Net of cities and towns industrial land patch, land used, enterprise, for radio station Area, monthly electricity consumption data are collected, and are specifically included:
S11, Traffic Net is collected, and according to planning department Urban Land figure, the basis of land departments GIS database Data are counted and are numbered to cities and towns industrial land patch land used data in GIS software;
S12, web crawlers acquisition cities and towns industrial land spot is write using Python based on Baidu map opening data platform Business data in block;
S13, according in the research range of power department record cities and towns industrial land patch for radio area data, monthly Electric data count the moon electricity consumption data of industrial land patch in cities and towns in the research range of at least a year, and according to radio area Electricity consumption data is summarized location.
Preferably, described data platform is opened based on Baidu map to write web crawlers using Python and obtain in step S12 The business data in the industrial land patch of cities and towns is taken, is specifically included:
S121, according to requiring to fill in Baidu's open platform data acquisition interface, input data obtain needed for parameter, obtain API Key;
S122, the relevant URL request parameter of setting;
S123, URL request is parsed with Python, to obtain business data, and saves as csv file.
Preferably, in step S2, the development status according to cities and towns industrial land patch, with radio area address, enterprise Title and enterprise address, screen the land used of cities and towns industrial land patch, electricity consumption and business data, specifically include:
S21, after being collected statistics to cities and towns industrial land patch land used data, will wherein development status be " building " Cities and towns industrial land patch rejected;
S22, to cities and towns industrial land patch land used data and cities and towns industrial land patch for radio area data, the moon After degree electricity consumption data is collected statistics, in Excel softwares, summarized according to radio area address, by cities and towns, other are built If the electricity consumption data of land used is rejected;
After S23, the business data in acquisition cities and towns industrial land patch, industrial classification program is write using Python, The industrial classification of enterprise is determined, and in Excel softwares, according to enterprise name, enterprise address to business data wherein repeatedly It is cleaned.
Preferably, described that default and abnormal electricity consumption, business data are modified in step S3, it specifically includes:
If S31, having the electricity consumption data of cities and towns industrial land patch default, according to the scale of cities and towns industrial land patch With the similar industrial land in research range with being averaged the moon electricity consumption to lack the cities and towns industrial land patch of electricity consumption data into Row data correction;
S32, after being modified to default electricity consumption data, utilize VC Method to calculate each cities and towns industrial land patch Monthly electricity consumption lack of balance situation, according to the scale of cities and towns industrial land patch and monthly electricity consumption to monthly electricity consumption exception Cities and towns industrial land patches carry out data correction;
S33, according to working base map geographic coordinate system, in Python softwares to the longitude and latitude of each company information carry out coordinate Correction, unified business data and working base map geographic coordinate system.
Preferably, the coefficient of variation is to weigh a statistic of each observation degree of variation in data information, reflection The ratio of the absolute value of data discrete degree, international standard standard deviation and average indicates the coefficient of variation, is denoted as cv, variation lines Several sizes, while being influenced by two statistics of average and standard deviation, the calculation formula of the coefficient of variation is as follows:
Cv=σi/|μi|
Wherein, σiFor the patch moon the standard deviation of equal electricity consumption data, μiFor patch the moon electricity consumption data average value;
In step S32, the monthly electricity consumption lack of balance that each cities and towns industrial land patch is calculated using VC Method Situation specifically includes:
S321, count i patches the moon electricity consumption data average value mui, calculation formula is:
μi=(∑ xi)/Si
Wherein, xiFor the monthly electricity consumption data of i patches, SiFor the area of i patches;
S322, count i patches the moon electricity consumption data standard deviation sigmai, calculation formula is:
Wherein, xiFor the monthly electricity consumption data of i patches, μiFor i patches the moon equal electricity consumption data average value, N is to grind Study carefully the time shaft for the monthly electricity consumption data observed, N >=12.
Preferably, described that cities and towns industrial land patch land used, electricity consumption and business data are matched in step S4, tool Body includes:
S41, in GIS software, it is industrial to cities and towns according to cities and towns industrial land patch figure, government affairs figure, high definition satellite mapping Ground patch carries out Data Matching;
S42, in GIS software, by carrying out data dropping place to electricity consumption data with radio area latitude and longitude coordinates;
S43, screening and revised business data csv file are loaded using GIS software, passes through business data longitude and latitude pair Business data is matched, and determines the land character of cities and towns industrial land patch;
S44, after being matched to the land used data of cities and towns industrial land patch and electricity consumption data, using GIS software The joint of reason processing intersects function, all spatial informations of cities and towns industrial land patch is incorporated on a figure, all properties Information integration is on a table.
Preferably, in step S5, according to Traffic Net, with radio area address and enterprise address to cities and towns industrial land Land used, electricity consumption and the business data of patch are checked, and are specifically included:
S51, in GIS software, establish the topological relation of industrial land, handed over according to cities and towns industrial land patch figure and road Open network carries out topological inspection to land used patch, if Traffic Net is capped rate and reaches 90% or more, is considered as land used Data match qualification with GIS working maps, and the calculation formula that the Traffic Net is capped rate is as follows:
C=1-b '/b
Wherein, C is that Traffic Net is capped rate, and b ' is uncovered Traffic Net total length, and b is road The total length of transportation network;
S52, after being checked to the land used data of cities and towns industrial land patch and electricity consumption data, in Python softwares In, using the program of the address keyword and patch address matching of while, if sentence builder radio area address, enterprise address, If address matching rate reaches 80% or more, it is considered as electricity consumption data and matches qualification, the meter of described address matching rate with business data It is as follows to calculate formula:
M=D '/D
Wherein, M is address matching rate, and D ' is total with radio area and patch address or enterprise address and patch address matching Number, D are patch sum.
Preferably, in step S6, the moon to cities and towns industrial land patch electricity consumption data carry out again examine with It corrects, specifically includes:
S61, after being modified, matching to cities and towns each element of industrial land patch, check, in GIS software, according to repairing Monthly electricity consumption data after just with calculating each patch moon electricity consumption the coefficient of variation, generate industrial land electricity consumption lack of balance feelings Condition distribution map;
S62, led to if electricity consumption data is abnormal according to the electricity consumption lack of balance situation distribution map of cities and towns industrial land patch The data exclusion for crossing GIS symbol display systems filters out abnormal cities and towns industrial land patch, again returns to step S3, and according to step Abnormal conditions in rapid S3 carry out data correction to abnormal electricity consumption data.
Preferably, in step S7, to the cities and towns industrial land moon the electricity consumption is less than construction land load index Patch is identified, and further generates the inefficient industrial land in cities and towns and identifies distribution map, specifically includes:
S71, predicted according to urban power load in electricity consumption and load turn calculation method, will be in construction land load index Unit industrial land load index be converted into index on power consumption, as the basis of characterization of the inefficient industrial land in cities and towns, identify The inefficient industrial land in cities and towns, electricity consumption and load turn calculation algorithm are as follows:
Ec=P/ (δ × ε × θ × 8760)
Wherein, Ec is year electricity consumption kwh, and P is electric load kw, and δ is average daily load rate, and ε is moon uncompensated load Rate, θ are seasonal unbalanced load rate;
S72, according to the industrial land patch moon equal electricity consumption, in GIS software, electricity consumption is less than ground with filtering out the moon The industrial land patch of square power consumption index;
S73, predicted according to urban power load in electricity consumption and load turn calculation method, will be in national land used load index Unit industrial land load index be converted into index on power consumption;
S74, after the unit industrial land load index in national land used load index is converted into index on power consumption, to each The following codomain of class industrial land index on power consumption mean value carries out Pyatyi division according to averaging method, as the inefficient industry grading in cities and towns Foundation, and with reference to grading according to inefficient industrial grading;
S75, to the inefficient industrial land in cities and towns grade after, in GIS software, utilize GIS geography processing joint intersection The inefficient industrial land spatial information in all cities and towns is incorporated on a figure by function, all properties information integration on a table, It generates the inefficient industrial land in cities and towns and identifies distribution map.
The present invention has following advantageous effect compared with the existing technology:
1, the present invention is on the basis of traditional planning investigation method, the land used of collection cities and towns industrial land patch, enterprise, confession Radio area and monthly electricity consumption data, and the electricity consumption data of cities and towns industrial land is combined to open the transformation of the inefficient industrial land in cities and towns again The advantage of hair carries out data screening, amendment, matching, check, inspection based on GIS-Geographic Information System (GIS) platform, and realization will be inefficient All spatial informations of industrial land are incorporated on a figure, and all properties information integration is on a table;Then, it is used with reference to construction Unit industrial land load index in ground load index identifies inefficient industrial land, finally proposes the inefficient industry in effective cities and towns The efficient and sustainable recycling of the inefficient industrial land in cities and towns is realized in land used recognition methods.
2, the present invention utilizes the electricity consumption data of cities and towns industrial land, can make inefficient industrial land identification System forming one Effectively, fine Quantitative System, abundant data accumulation and accurate data information help to promote inefficient industrial land Quantitative study is aided with the confidence level that traditional planning survey data improve inefficient industrial land identification, and to a certain extent Improve the efficiency of inefficient industrial land identification.
3, the present invention crawls the enterprise name of inefficient industry, address, longitude and latitude using Python data minings, analysis method Degrees of data, the monthly electricity consumption data of screening and analytical variance coefficient exception can make effect industrial land identify System forming one Accurately, objective Quantitative System, accurately data mining ability and efficiently objective data analysis help to promote inefficient work The quantitative study of industry land used, is aided with the objectivity that traditional planning survey data improve the identification of inefficient industrial land, and from one Determine to improve the efficiency that inefficient industrial land identifies in degree.
4, for the present invention on the basis of traditional planning investigation method, by the inefficient industrial land identification depth in cities and towns, therefrom class is smart It is refine to specific industry, specifically includes the manufacture of general and special equipment, electrical, electronic equipment manufacturing, clothes, shoes and hats manufacture, text Has manufacture, plastic products, rubber, metal product, weaving, paper industry, chemical industry, ferrous metal smelting and processing.
5, the present invention breaks through the limitation that the inefficient industrial land of certain class can only be generally differentiated using industrial GDP or enterprise tax, It realizes while identifying all kinds of inefficient industrial lands.
6, the present invention from data supporting and technical method for the transformation of inefficient industrial land provide a kind of new thinking and Direction, along with the fast development of information age, the multi-source datas such as mobile phone signaling data, network opening data will be low It imitates industrial land redevelopment and inefficient industrial upgrades transition provides more prcgramming ideas and method.
Description of the drawings
Fig. 1 is the flow chart of the inefficient industrial land method for quickly identifying in cities and towns of the embodiment of the present invention 1.
Fig. 2 is the excavation of Pyrhon business data and the analysis chart of the embodiment of the present invention 1.
Fig. 3 is the equal electricity consumption present situation figure in the cities and towns industrial land patch moon of the embodiment of the present invention 2 ground.
Fig. 4 is the monthly electricity consumption Abnormality Analysis figure of cities and towns industrial land patch of the embodiment of the present invention 2.
Fig. 5 is the monthly electricity consumption abnormal conditions correction map of cities and towns industrial land of the embodiment of the present invention 2.
Fig. 6 is that the inefficient industrial land in cities and towns of the embodiment of the present invention 2 identifies distribution map.
Specific implementation mode
Present invention will now be described in further detail with reference to the embodiments and the accompanying drawings, but embodiments of the present invention are unlimited In this.
Embodiment 1:
As shown in Figure 1, present embodiments provide a kind of inefficient industrial land method for quickly identifying in cities and towns, this method include with Lower step:
1) basic data is collected
1.1) collection and check of working base map
The present embodiment is with land planning department GIS (GeographicInformation System, GIS-Geographic Information System) The Urban Construction Land_use patch of land used database as the space cell researched and analysed, need first to working base map carry out processing and It checks.In the processing of working base map, non-industrial land attribute patch should be deleted, retain the spot of cities and towns industrial land attribute Block.It, should be in generalized information system by each generic attribute of industrial land patch since cities and towns industrial land patch attribute information is compared with horn of plenty Information integration, for ease of being identified with carrying out the inefficient industrial land in cities and towns.
Since the industrial land address in GIS database is there are certain information is not perfect, industrial land electricity consumption data, enterprise Industry address date Statistical Criteria is also not quite identical.So on the basis of checking industrial land address, it should be by industrial land spot Block carries out spatial match with government affairs map, high definition satellite mapping, improves the accuracy of industrial land information.
1.2) collection and processing of data
The present embodiment is based on traditional planning survey data, including industrial land patch road in cities and towns in research range Transportation network, land used, electricity consumption, business data, in conjunction with monthly the equal electricity consumption data of cities and towns industrial land patch, with certain Analysis method and technological means realize the identification to inefficient industrial land.
Wherein, the land used data of cities and towns industrial land patch refer to specific cities and towns industrial land patch face in research range Product, property, boundary, title, development status.
Wherein, the business data in cities and towns industrial land patch refers to specific cities and towns industrial land patch in research range Interior enterprise name, address, longitude and latitude are to differentiate the important evidence of group industrial land property, and specific industry land used The important references of boundary check and correction.
Wherein, the electricity consumption data of cities and towns industrial land patch refers to specific cities and towns industrial land patch in research range Monthly electricity consumption, general data timing statistics range suggestion are 1-2, and according to the moon in range electricity consumption can differentiate mesh The utilization of capacity of the industrial liveness in preceding cities and towns and factory, the moon electricity consumption be also identify the inefficient industry in cities and towns important Reference index.
Traffic Net in traditional planning survey data is the main ginseng that space check and correction is carried out to cities and towns industrial land One of examine;The area of cities and towns industrial land is mainly generated according to each specific industrial land patch in GIS database, main to reflect The scale situation of all kinds of cities and towns industrial lands;The property of cities and towns industrial land is primarily referred to as a kind of industry, the industry of two classes, three classes work Industry, all kinds of cities and towns industrial land power consumption indexes are the important references of the inefficient industrial land of principium identification;The side of cities and towns industrial land Boundary is primarily referred to as the Boundary of Property Rights of the subdivision industrial land specific to industrial class, is carried out to one kind, two classes, three classes industry It further segments to the critical boundaries foundation of specific industrial class;The address of cities and towns industrial land is primarily referred to as specific cities and towns industry The patch address of land used is electricity consumption data, one of the important references of business data verification;Development status refers to that cities and towns are industrial Ground belongs to during counting moon electricity consumption " building " or " built ", influences the integrality of electricity consumption data, is cities and towns industry The important indicator that land used data screening is rejected.
1.2.1) the collection and arrangement of traditional planning survey data
The cities and towns industrial land patch of land planning department GIS land used databases is the master that traditional planning survey data is collected Will foundation, be the space cell researched and analysed with cities and towns industrial land patch, to its area, property, boundary, title, exploitation shape State and Traffic Net carry out statistical collection.It should be noted that since the industrial land address in GIS database exists Certain information is not perfect, and the electricity consumption data of cities and towns industrial land, enterprise's address data statistics bore are also not quite identical.Institute With, on the basis of checking cities and towns industrial land address, should by industrial land patch and GIS government affairs map, high definition satellite mapping into Row spatial match improves the accuracy of industrial land information.
After matching, in GIS software, the topological relation of industrial land is established, according to the cities and towns roads industrial land patch Tu Yu Road communication chart road network carries out topological inspection to land used patch, if Traffic Net is capped rate and reaches 90% or more, depending on Qualification is matched with GIS working maps for land used data, the calculation formula that the Traffic Net is capped rate is as follows:
C=1-b '/b (1)
Wherein, C is that Traffic Net is capped rate, and b ' is uncovered Traffic Net total length, and b is road The total length of transportation network.
1.2.2) the collection and arrangement of cities and towns industrial land electricity consumption data
According in the research range of power department record cities and towns industrial land for radio area data, monthly electricity consumption data, Count at least a year research range in cities and towns industrial land patch moon electricity consumption data, and according to radio area address to data Summarized;Due to this research mainly for cities and towns industrial land, so first should according to radio area address by cities and towns its The electricity consumption data of his construction land carries out screening rejecting;Then default or abnormal electricity consumption data is modified;It is finally right Electricity consumption data is matched.
After matching, in Python softwares, while, if sentence builder radio area address, the address of enterprise address are utilized Keyword and the program of cities and towns industrial land patch address matching are considered as electricity consumption number if address matching rate reaches 80% or more According to qualification is matched with business data, the calculation formula of described address matching rate is as follows:
M=D '/D (3)
Wherein, M is address matching rate, and D ' is total with radio area and patch address or enterprise address and patch address matching Number, D are patch sum.
Significantly, since on a small quantity with radio area longitude and latitude and working base map geographic coordinate system there are certain deviation, It is possible that a small amount of electricity consumption data is on the boundary of cities and towns industrial land or road network in electricity consumption data matching process On network, therefore, electricity consumption data check and correction step should be increased after being matched to electricity consumption data, according to electricity consumption data address to there are inclined The electricity consumption data of difference is modified.
Specified otherwise is needed herein, since the first amendment of default or abnormal electricity consumption data is known in Python Not and analysis, statistics and modified is carried out in Excel, although result is objective and accurate, is corrected front and back the result is that number Comparison, fail to carry out visualization inspection in conjunction with land used, therefore, after Data Matching, utilize the data processing and analysis of GIS Function carries out visualization presentation to the correcting the front and back cities and towns industrial land moon electricity consumption coefficient of variation, and differentiates correction result Whether perfect electricity consumption data.
Wherein, the monthly electricity consumption lack of balance situation that each cities and towns industrial land patch is calculated using VC Method, according to The scale of cities and towns industrial land patch and monthly electricity consumption carry out data to the cities and towns industrial land patch of monthly electricity consumption exception It corrects.
The coefficient of variation is to weigh a statistic of each observation degree of variation in data information, reflects data discrete degree Absolute value, the ratio of international standard standard deviation and average indicates the coefficient of variation, is denoted as cv (Coefficient of Variance), the size of the coefficient of variation, while being influenced by two statistics of average and standard deviation, the calculating of the coefficient of variation Formula is as follows:
Cv=σi/|μi| (4)
Wherein, σiFor the patch moon the standard deviation of equal electricity consumption data, μiFor patch the moon electricity consumption data average value;
The monthly electricity consumption lack of balance situation that each cities and towns industrial land patch is calculated using VC Method, is specifically included:
With counting the moon of the i patches average value mu of equal electricity consumption datai, calculation formula is:
μi=(∑ xi)/Si (5)
Wherein, xiFor the monthly electricity consumption data of i patches, SiFor the area of i patches;
With counting the moon of the i patches standard deviation sigma of equal electricity consumption datai, calculation formula is:
Wherein, xiFor the monthly electricity consumption data of i patches, μiFor i patches the moon equal electricity consumption data average value, N is to grind Study carefully the time shaft for the monthly electricity consumption data observed, N >=12.
1.2.3) in the industrial land of cities and towns business data collection and arrangement
Cities and towns industry is obtained as shown in Fig. 2, opening data platform based on Baidu map and writing web crawlers using Python Secondly company information in land used patch, including enterprise name, address, longitude and latitude etc. write industrial classification journey using Python Sequence determines the industrial classification of enterprise, is carried out later to business data using comprehensive utilization Excel, Python, GIS (ArcGIS) Screening and amendment, then carry out spatial match by company information and working base map, determine the industry point of cities and towns industrial land patch Class, it is last that business data is proofreaded according to enterprise address.
It is worth noting that, the business data in web crawlers acquisition cities and towns industrial land patch is write using Python, There may be the business data repeated in crawling result, therefore, data screening step should be increased after collecting business data, Then in Excel softwares, the business data wherein repeated is cleaned according to enterprise name, enterprise address.
In addition, writing enterprise's longitude and latitude in web crawlers acquisition Baidu map in the industrial land patch of cities and towns using Python Degree, since the geographic coordinate system of Baidu map and working base map is inconsistent, should increase data correction step, foundation after garbled data Working base map geographic coordinate system carries out coordinate correction in Python to the longitude and latitude of each company information, unified business data with Working base map geographic coordinate system.
At this it should be strongly noted that due in a small amount of business data and working base map matching process it is possible that enterprise Industry data are on industrial land boundary or on road network, therefore, should increase enterprise's number after being matched to electricity consumption data According to check and correction step, according to business data title, address to being proofreaded and being corrected there are the business data of deviation.
1.3) to the cities and towns industrial land patch moon electricity consumption data examine and correct again
After being modified, matching to cities and towns each element of industrial land patch, check, in GIS software, after amendment Monthly electricity consumption data with the calculating each patch moon equal coefficient of variation of electricity consumption, generate industrial land electricity consumption lack of balance situation point Butut;
Pass through GIS if electricity consumption data is abnormal according to the electricity consumption lack of balance situation distribution map of cities and towns industrial land patch The data exclusion of symbol display system filters out abnormal cities and towns industrial land patch, and data correction is carried out to abnormal electricity consumption data.
2) identification of the inefficient industrial land in cities and towns
According to the area of the cities and towns industrial land patch of collection, property, boundary, title, development status and cities and towns industry Enterprise name, address in land used patch, longitude and latitude, for radio area data, monthly electricity consumption data, with reference to local unit's construction Cities and towns industrial land electricity consumption low value patch is identified in unit industrial land load index in land used load index.
2.1) turn calculation of electricity consumption data
According to《Municipal engineering systems organization》Electricity consumption in the prediction of (second edition) urban power load turns calculation side with load Unit industrial land load index in local unit's construction land load index is converted into index on power consumption, as city by method The discrimination standard of the inefficient industrial land in town identifies that the inefficient industrial land in cities and towns, electricity consumption and load turn calculation algorithm are as follows:
Ec=P/ (δ × ε × θ × 8760) (7)
Wherein, Ec is year electricity consumption kwh, and P is electric load kw, and δ is average daily load rate, and ε is moon uncompensated load Rate, θ are seasonal unbalanced load rate.
2.2) the inefficient industrial land identification in cities and towns
According to the industrial land patch moon equal electricity consumption is identified with the overlay analysis method of GIS data processing platform The equal electricity consumption in moon ground is less than the industrial land patch of local power consumption index.
3) the inefficient industrial land grading in cities and towns
It is negative in conjunction with the unit industrial land in state-owned unit's construction land load index after identifying the inefficient industrial land in cities and towns Lotus index grades to inefficient industrial land, and further generates cities and towns effect industrial land and identify distribution map.
3.1) turn calculation of electricity consumption data
According to《Municipal engineering systems organization》Electricity consumption in the prediction of (second edition) urban power load turns calculation side with load Method, the unit industrial land load index in state-owned unit's construction land load index are converted into index on power consumption, specific to calculate Method refers to calculation formula (7).
3.2) inefficient industrial land grading
After unit industrial land load index in state-owned unit's construction land load index is converted into index on power consumption, First, it divides to carrying out 5 grades of evaluations below all kinds of cities and towns industrial land index on power consumption mean values, is opened again as the inefficient industry in cities and towns Send out Potential Evaluation foundation.Then, differentiate that potentiality rank is transformed in inefficient industrial land with reference to Appreciation gist.
3.3) effect industrial land in cities and towns identifies distribution map
After grading to the inefficient industrial land in cities and towns, in GIS software, intersect work(using the joint that GIS geography is handled Can, all inefficient industrial land spatial informations are incorporated on a figure, all properties information integration generates city on a table It imitates industrial land and identifies distribution map in town.
Embodiment 2:
The present embodiment is an application example, using Jiangxi Province Wuning County as operation object, based on the industry of Wuning County cities and towns The area of land used patch, property, boundary, title, development status and the enterprise name in industrial land patch, address, longitude and latitude Degree, for radio area data, monthly electricity consumption data, the data processing of integrated use GIS, Python, CAD, Excel and data point Analysis method completes 102 pieces of inefficient industrial land identifications, and proposes inefficient industrial land patch transformation potentiality grading judgement.Research master To include that basic data collection is commented with check, the identification of the inefficient industrial land in cities and towns, the inefficient industrial land redevelopment potentiality in cities and towns Three parts of grade.
1) basic data is collected and is checked
First, data are collected.It is to grind with the cities and towns industrial land patch of land planning department GIS land used databases The space cell for studying carefully analysis, to Traffic Net in research range, the area of cities and towns industrial land patch, property, boundary, name Title, development status and the enterprise name in industrial land patch, address, longitude and latitude, for radio area data, monthly electricity consumption number According to being collected.
Secondly, data are screened.In Excel softwares, according to the attribute of development status, will wherein development status be The land used patch of " building " is rejected;Summarized according to radio area address, by other land used electricity consumption datas therein into Row is rejected;The business data wherein repeated is cleaned according to enterprise name, enterprise address.Effectively industrial plot is obtained 102 pieces, effective electricity consumption data 1109, effective business data 183.
Later, default and abnormal data is modified.It is industrial to the cities and towns that monthly electricity consumption data are default or abnormal Ground patch, according to the similar industrial land in the scale and research range of industrial land patch be averaged the moon equal electricity consumption to lacking The industrial land patch of electricity consumption data carries out data correction, the equal electricity consumption present situation figure such as Fig. 3 institutes in cities and towns industrial land patch moon ground Show, industrial land patch monthly electricity consumption abnormal conditions in cities and towns are as shown in figure 4, abnormal conditions are as shown in Figure 5 after correcting;According to work Make base map geographic coordinate system, coordinate correction, unified business data are carried out to the longitude and latitude of each company information in Python softwares With working base map geographic coordinate system.Default electricity consumption data data 91 are corrected in circular reference formula (4)~(6) altogether, Abnormal electricity consumption data 68, business data 183 of rectifying a deviation.
Then, data are matched.In GIS software, according to the industrial map in cities and towns, government affairs figure, high definition satellite mapping Data Matching is carried out to industrial land patch;In gis softwares, by with radio area latitude and longitude coordinates to electricity consumption data into line number According to dropping place;Business data is matched by business data longitude and latitude, determines the land character of industrial land patch;It utilizes The joint of GIS software geography processing intersects function, all spatial informations of land used patch is incorporated on a figure, all properties Information integration matches effective 102 pieces of industrial land plate data, electricity consumption data 1224, business data 102 altogether on a table Item.
In addition, being checked to data.In gis softwares, the topological relation of industrial land is initially set up, then according to city The industrial map in town carries out topological inspection with road traffic map road network to land used patch;In Python softwares, using while, The program of the address keyword and land used patch address matching of if sentence builders radio area address, enterprise address.It is specific to calculate Method reference formula (1)~(3), wherein industrial land patch matching 92.16%, electricity consumption data longitude and latitude matching rate 91.17%, Electricity consumption data address matching rate is 87.25%, and business data longitude and latitude matching rate is 91.80%, business data address matching rate It is 88.52%.
Finally, electricity consumption data examine and correct again.In GIS software, according to the moon the variation of electricity consumption Coefficient generates industrial land electricity consumption lack of balance situation distribution map;If electricity consumption data is abnormal, pass through GIS symbol display systems Data exclusion filter out abnormal industrial land patch, then data correction is carried out to abnormal electricity consumption data;If this time inspection result Qualification does not occur abnormal data then.
2) identification of the inefficient industrial land in cities and towns
First, electricity consumption data is carried out turning to calculate.According to《Municipal engineering systems organization》(second edition) urban power load is pre- Electricity consumption in survey turns calculation method with load, by the unit industrial land load index in local unit's construction land load index It is converted into index on power consumption, the basis of characterization as the inefficient industrial land in cities and towns.Circular reference formula (7).
Then, inefficient industrial land is identified, in GIS software, electricity consumption is less than place use with identifying the moon The industrial land patch of electric index.Not inefficient 30 pieces of the industrial land of common recognition, as shown in Figure 6.
3) the inefficient industrial land grading in cities and towns
First, electricity consumption data is carried out turning to calculate.According to《Municipal engineering systems organization》(second edition) urban power load is pre- Electricity consumption in survey turns calculation method with load, and the unit industrial land load index in state-owned unit's construction land load index changes It is counted as index on power consumption.Circular reference formula (7).
Then, potentiality grading is transformed to the inefficient industrial land in cities and towns.To all types of industries land used index on power consumption mean value Following codomain carries out 5 grades of divisions according to averaging method, the foundation as the inefficient industrial conversion potentiality grading in cities and towns.
Later, with reference to the grading of transformation potentiality potentiality grading is transformed according to inefficient industrial land.According to transformation potentiality Grading carries out descending arrangement, wherein inefficient industrial 3 pieces of the plot of level-one according to rating result, inefficient industrial 13 pieces of the plot of two level, Inefficient industrial 6 pieces of the plot of three-level, inefficient industrial 2 pieces of the plot of level Four, inefficient industrial 6 pieces of the plot of Pyatyi.
Finally, it generates cities and towns effect industrial land and identifies distribution map.In GIS software, the joint work(of GIS geography processing is utilized Can, all inefficient industrial land spatial informations are incorporated on a figure, all properties information integration generates city on a table It imitates industrial land and identifies distribution map in town.
In conclusion the present invention is on the basis of traditional planning investigation method, collect cities and towns industrial land patch land used, Enterprise, for radio area and monthly electricity consumption data, and combine the electricity consumption data of cities and towns industrial land for the inefficient industrial land in cities and towns The advantage of redevelopment is transformed, data screening, amendment, matching, check, inspection are carried out based on GIS-Geographic Information System (GIS) platform, it is real Now all spatial informations of inefficient industrial land are incorporated on a figure, all properties information integration is on a table;Then, join The unit industrial land load index examined in construction land load index identifies inefficient industrial land, finally proposes effective cities and towns The efficient and sustainable recycling of the inefficient industrial land in cities and towns is realized in inefficient industrial land recognition methods.
It will be understood by those skilled in the art that the method for the present invention applies also for the inefficient industry land such as logistics, storage, office Quick identification;It is also applied for the quick identification of the inefficient non-industry lands such as business, inhabitation;Apply also for it is similar using school, The density of the public service facilities such as hospital, park identifies corresponding inefficient construction land.
The above, patent preferred embodiment only of the present invention, but the protection domain of patent of the present invention is not limited to This, any one skilled in the art is in the range disclosed in patent of the present invention, according to the skill of patent of the present invention Art scheme and its patent of invention design are subject to equivalent substitution or change, belong to the protection domain of patent of the present invention.

Claims (10)

1. the inefficient industrial land method for quickly identifying in cities and towns based on electricity consumption data, it is characterised in that:The method includes following Step:
S1, in some research range, to the Traffic Net of cities and towns industrial land patch, land used, enterprise, for radio area, Monthly electricity consumption data is collected;Wherein, the land used data include area, property, boundary, title and development status, described Business data includes enterprise name, address and longitude and latitude;
S2, according to the development status of cities and towns industrial land patch, with radio area address, enterprise name and enterprise address, to cities and towns Land used, electricity consumption and the business data of industrial land patch are screened;
S3, default and abnormal electricity consumption, business data are modified;
S4, the land used to cities and towns industrial land patch, electricity consumption and business data match;
S5, according to Traffic Net, with radio area address and enterprise address to the land used of cities and towns industrial land patch, electricity consumption and Business data is checked;
S6, to the moon of cities and towns industrial land patch electricity consumption data examine and correct again;
S7, to the cities and towns industrial land moon electricity consumption is identified less than the patch of construction land load index, further raw Distribution map is identified at the inefficient industrial land in cities and towns.
2. the inefficient industrial land method for quickly identifying in the cities and towns according to claim 1 based on electricity consumption data, feature exist In:In step S1, it is described to the Traffic Net of cities and towns industrial land patch, land used, enterprise, for radio area, monthly electricity consumption Data are collected, and are specifically included:
S11, Traffic Net is collected, and according to planning department Urban Land figure, the basic number of land departments GIS database According in GIS software, cities and towns industrial land patch land used data being counted and are numbered;
S12, it is write in web crawlers acquisition cities and towns industrial land patch using Python based on Baidu map opening data platform Business data;
S13, according to power department record research range in cities and towns industrial land patch for radio area data, monthly electricity consumption number According to counting the moon electricity consumption data of industrial land patch in cities and towns in the research range of at least a year, and according to radio area address pair Electricity consumption data is summarized.
3. the inefficient industrial land method for quickly identifying in the cities and towns according to claim 2 based on electricity consumption data, feature exist In:In step S12, it is described based on Baidu map open data platform using Python write web crawlers obtain cities and towns it is industrial Business data in ground patch, specifically includes:
S121, according to requiring to fill in Baidu's open platform data acquisition interface, input data obtain needed for parameter, obtain API Key;
S122, the relevant URL request parameter of setting;
S123, URL request is parsed with Python, to obtain business data, and saves as csv file.
4. the inefficient industrial land method for quickly identifying in the cities and towns according to claim 1 based on electricity consumption data, feature exist In:In step S2, the development status according to cities and towns industrial land patch, with radio area address, enterprise name and industrially Location is screened the land used of cities and towns industrial land patch, electricity consumption and business data, is specifically included:
S21, after being collected statistics to cities and towns industrial land patch land used data, will wherein development status be " building " city Town industrial land patch is rejected;
S22, to cities and towns industrial land patch land used data and cities and towns industrial land patch for radio area data, monthly After electric data are collected statistics, in Excel softwares, summarized according to radio area address, by cities and towns, other, which are built, uses The electricity consumption data on ground is rejected;
After S23, the business data in acquisition cities and towns industrial land patch, industrial classification program is write using Python, is determined The industrial classification of enterprise, and in Excel softwares, the business data wherein repeated is carried out according to enterprise name, enterprise address Cleaning.
5. the inefficient industrial land method for quickly identifying in the cities and towns according to claim 1 based on electricity consumption data, feature exist In:It is described that default and abnormal electricity consumption, business data are modified in step S3, it specifically includes:
If S31, there are the electricity consumption data of cities and towns industrial land patch default, according to the scale of cities and towns industrial land patch and grind Study carefully the similar industrial land in range with being averaged the moon electricity consumption to lacking the cities and towns industrial land patch of electricity consumption data into line number According to amendment;
S32, after being modified to default electricity consumption data, the moon of each cities and towns industrial land patch is calculated using VC Method Electricity consumption lack of balance situation is spent, according to the scale of cities and towns industrial land patch and monthly electricity consumption to the city of monthly electricity consumption exception Town industrial land patch carries out data correction;
S33, according to working base map geographic coordinate system, in Python softwares to the longitude and latitude of each company information carry out coordinate entangle Partially, unified business data and working base map geographic coordinate system.
6. the inefficient industrial land method for quickly identifying in the cities and towns according to claim 5 based on electricity consumption data, feature exist In:The coefficient of variation is to weigh a statistic of each observation degree of variation in data information, reflects data discrete degree Absolute value, the ratio of international standard standard deviation and average indicates the coefficient of variation, is denoted as cv, the size of the coefficient of variation is simultaneously It is influenced by two statistics of average and standard deviation, the calculation formula of the coefficient of variation is as follows:
Cv=σi/|μi|
Wherein, σiFor the patch moon the standard deviation of equal electricity consumption data, μiFor patch the moon electricity consumption data average value;
In step S32, the monthly electricity consumption lack of balance situation that each cities and towns industrial land patch is calculated using VC Method, It specifically includes:
S321, count i patches the moon electricity consumption data average value mui, calculation formula is:
μi=(∑ xi)/Si
Wherein, xiFor the monthly electricity consumption data of i patches, SiFor the area of i patches;
S322, count i patches the moon electricity consumption data standard deviation sigmai, calculation formula is:
Wherein, xiFor the monthly electricity consumption data of i patches, μiFor i patches the moon equal electricity consumption data average value, N is research institute The time shaft of the monthly electricity consumption data of observation, N >=12.
7. the inefficient industrial land method for quickly identifying in the cities and towns according to claim 1 based on electricity consumption data, feature exist In:It is described that cities and towns industrial land patch land used, electricity consumption and business data are matched in step S4, it specifically includes:
S41, in GIS software, according to cities and towns industrial land patch figure, government affairs figure, high definition satellite mapping to cities and towns industrial land spot Block carries out Data Matching;
S42, in GIS software, by carrying out data dropping place to electricity consumption data with radio area latitude and longitude coordinates;
S43, screening and revised business data csv file are loaded using GIS software, by business data longitude and latitude to enterprise Data are matched, and determine the land character of cities and towns industrial land patch;
S44, after being matched to the land used data of cities and towns industrial land patch and electricity consumption data, at GIS software geography The joint of reason intersects function, all spatial informations of cities and towns industrial land patch is incorporated on a figure, all properties information It is incorporated on a table.
8. the inefficient industrial land method for quickly identifying in the cities and towns according to claim 1 based on electricity consumption data, feature exist In:In step S5, according to Traffic Net, with radio area address and enterprise address to the land used of cities and towns industrial land patch, Electricity consumption and business data are checked, and are specifically included:
S51, in GIS software, the topological relation of industrial land is established, according to cities and towns industrial land patch figure and road traffic net Network carries out topological inspection to land used patch, if Traffic Net is capped rate and reaches 90% or more, is considered as land used data Qualification is matched with GIS working maps, the calculation formula that the Traffic Net is capped rate is as follows:
C=1-b '/b
Wherein, C is that Traffic Net is capped rate, and b ' is uncovered Traffic Net total length, and b is road traffic The total length of network;
S52, after being checked to the land used data of cities and towns industrial land patch and electricity consumption data, in Python softwares, profit With the program of the address keyword and patch address matching of while, if sentence builder radio area address, enterprise address, if ground Location matching rate reaches 80% or more, then is considered as electricity consumption data and matches qualification with business data, the calculating of described address matching rate is public Formula is as follows:
M=D '/D
Wherein, M is address matching rate, and D ' is with radio area and patch address or enterprise address and patch address matching sum, D For patch sum.
9. the inefficient industrial land method for quickly identifying in the cities and towns according to claim 1 based on electricity consumption data, feature exist In:In step S6, the moon to cities and towns industrial land patch electricity consumption data examine and correct again, it is specific to wrap It includes:
S61, after being modified, matching to cities and towns each element of industrial land patch, check, in GIS software, after amendment Monthly electricity consumption data with the calculating each patch moon equal coefficient of variation of electricity consumption, generate industrial land electricity consumption lack of balance situation point Butut;
S62, GIS is passed through if electricity consumption data is abnormal according to the electricity consumption lack of balance situation distribution map of cities and towns industrial land patch The data exclusion of symbol display system filters out abnormal cities and towns industrial land patch, again returns to step S3, and according to step S3 In abnormal conditions to abnormal electricity consumption data carry out data correction.
10. the inefficient industrial land method for quickly identifying in the cities and towns according to claim 1 based on electricity consumption data, feature exist In:In step S7, described to the cities and towns industrial land moon electricity consumption is identified less than the patch of construction land load index, It further generates the inefficient industrial land in cities and towns and identifies distribution map, specifically include:
S71, predicted according to urban power load in electricity consumption and load turn calculation method, by the list in construction land load index Position industrial land load index is converted into index on power consumption, as the basis of characterization of the inefficient industrial land in cities and towns, identifies cities and towns Inefficient industrial land, electricity consumption and load turn calculation algorithm are as follows:
Ec=P/ (δ × ε × θ × 8760)
Wherein, Ec is year electricity consumption kwh, and P is electric load kw, and δ is average daily load rate, and ε is monthly unbalanced load rate, θ For seasonal unbalanced load rate;
S72, according to the industrial land patch moon equal electricity consumption, in GIS software, electricity consumption is less than place use with filtering out the moon The industrial land patch of electric index;
S73, predicted according to urban power load in electricity consumption and load turn calculation method, by the list in national land used load index Position industrial land load index is converted into index on power consumption;
S74, after the unit industrial land load index in national land used load index is converted into index on power consumption, to all kinds of works The following codomain of industry land used index on power consumption mean value, according to averaging method carry out Pyatyi division, as cities and towns it is inefficient industry grading according to According to, and with reference to grading according to inefficient industrial grading;
S75, to the inefficient industrial land in cities and towns grade after, in GIS software, using GIS geography handle joint intersect function, The inefficient industrial land spatial information in all cities and towns is incorporated on a figure, all properties information integration generates on a table The inefficient industrial land in cities and towns identifies distribution map.
CN201710803361.3A 2017-09-08 2017-09-08 The inefficient industrial land method for quickly identifying in cities and towns based on electricity consumption data Active CN107766415B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201710803361.3A CN107766415B (en) 2017-09-08 2017-09-08 The inefficient industrial land method for quickly identifying in cities and towns based on electricity consumption data

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201710803361.3A CN107766415B (en) 2017-09-08 2017-09-08 The inefficient industrial land method for quickly identifying in cities and towns based on electricity consumption data

Publications (2)

Publication Number Publication Date
CN107766415A CN107766415A (en) 2018-03-06
CN107766415B true CN107766415B (en) 2018-09-14

Family

ID=61265366

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201710803361.3A Active CN107766415B (en) 2017-09-08 2017-09-08 The inefficient industrial land method for quickly identifying in cities and towns based on electricity consumption data

Country Status (1)

Country Link
CN (1) CN107766415B (en)

Families Citing this family (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN109116072B (en) * 2018-06-29 2021-04-16 广东电网有限责任公司 Electricity stealing analysis method and device and server
CN112419124B (en) * 2020-11-19 2022-04-01 广州市城市规划勘测设计研究院 Method and device for quickly identifying low-efficiency industrial land and storage medium thereof
CN116029461B (en) * 2023-03-24 2023-06-20 北京易能中网技术有限公司 Method for realizing user load prediction based on autoregressive algorithm
CN116911630A (en) * 2023-07-06 2023-10-20 北京华一众合科技有限公司 Low-utility land intelligent identification method, system, storage medium and electronic equipment
CN117251770B (en) * 2023-11-17 2024-02-13 北京新兴科遥信息技术有限公司 Method for identifying low-utility land

Family Cites Families (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US7774184B2 (en) * 2006-10-17 2010-08-10 Schlumberger Technology Corporation Brownfield workflow and production forecast tool
US20130159202A1 (en) * 2011-12-14 2013-06-20 Ii Thomas Francis Darden Systems & methods for automated assessment for remediation and/or redevelopment of brownfield real estate
CN104750799B (en) * 2015-03-23 2018-04-13 华南理工大学 A kind of construction land type method for quickly identifying based on address resolution data
CN105809350A (en) * 2016-03-10 2016-07-27 广东省城乡规划设计研究院 Natural village hollowing degree and type recognition method for construction land renovation

Also Published As

Publication number Publication date
CN107766415A (en) 2018-03-06

Similar Documents

Publication Publication Date Title
CN107766415B (en) The inefficient industrial land method for quickly identifying in cities and towns based on electricity consumption data
Roddis et al. The role of community acceptance in planning outcomes for onshore wind and solar farms: An energy justice analysis
Li et al. What drives urban growth in China? A multi-scale comparative analysis
Jiao et al. Spatiotemporal dynamic simulation of land-use and landscape-pattern in the Pearl River Delta, China
Zhou et al. Spatial characteristics and risk factor identification for land use spatial conflicts in a rapid urbanization region in China
Huang et al. A systematic review of empirical methods for modelling sectoral carbon emissions in China
CN105809350A (en) Natural village hollowing degree and type recognition method for construction land renovation
Omar et al. Markov-CA model using analytical hierarchy process and multiregression technique
Chen et al. A hybrid decision model and case study for comprehensive evaluation of green mine construction level
De Marco et al. Risk factors influencing the debt leverage of project financing initiatives in the energy industry
Song et al. Region division of China's carbon market based on the provincial/municipal carbon intensity
CN112948748B (en) Multi-benefit-subject-based major infrastructure site selection optimization method and system
Radermacher Indicators, green accounting and environment statistics—information requirements for sustainable development
Cai et al. Fine Resolution Carbon Dioxide Emission Gridded Data and Their Application for China.
McDowall et al. Mapping regional vulnerability in Europe’s energy transition: development and application of an indicator to assess declining employment in four carbon-intensive industries
Li et al. How industrial landscape affects the regional industrial economy: A spatial heterogeneity framework
Wang et al. Can energy efficiency progress reduce PM2. 5 concentration in China’s cities? Evidence from 105 key environmental protection cities in China, 2004–2015
Zhang et al. Identification of priority areas for ecological restoration based on ecological security and landscape elements
Feng et al. Spatio-temporal evolution and trend prediction of urban ecosystem service value based on CLUE-S and GM (1, 1) compound model
Yan et al. Evolution and coupled matching of ecosystem service supply and demand at different spatial scales in the Shandong Peninsula urban agglomeration, China
Xia et al. Spatial distribution of rural housing abandonment and influencing factors at the village level: a case study of the Loess Plateau of China
Choi et al. Retrofit building energy performance evaluation using an energy signature-based symbolic hierarchical clustering method
Liu et al. Spatiotemporal evolution and trend prediction of regional water–energy–food–ecology system vulnerability: a case study of the Yangtze River Economic Belt, China
Halsing et al. A cost-benefit analysis of The National Map
Huang et al. Spatio-temporal evolution and distribution of cultural heritage sites along the Suzhou canal of China

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
GR01 Patent grant
GR01 Patent grant