CN107766415A - The poorly efficient industrial land method for quickly identifying in cities and towns based on electricity consumption data - Google Patents

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

Info

Publication number
CN107766415A
CN107766415A CN201710803361.3A CN201710803361A CN107766415A CN 107766415 A CN107766415 A CN 107766415A CN 201710803361 A CN201710803361 A CN 201710803361A CN 107766415 A CN107766415 A CN 107766415A
Authority
CN
China
Prior art keywords
cities
towns
land
data
patch
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.)
Granted
Application number
CN201710803361.3A
Other languages
Chinese (zh)
Other versions
CN107766415B (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)
  • Databases & Information Systems (AREA)
  • General Physics & Mathematics (AREA)
  • Human Resources & Organizations (AREA)
  • Data Mining & Analysis (AREA)
  • General Engineering & Computer Science (AREA)
  • Development Economics (AREA)
  • Educational Administration (AREA)
  • Strategic Management (AREA)
  • Economics (AREA)
  • Tourism & Hospitality (AREA)
  • Quality & Reliability (AREA)
  • Marketing (AREA)
  • Entrepreneurship & Innovation (AREA)
  • General Business, Economics & Management (AREA)
  • Computational Linguistics (AREA)
  • Probability & Statistics with Applications (AREA)
  • Mathematical Physics (AREA)
  • General Health & Medical Sciences (AREA)
  • Primary Health Care (AREA)
  • Software Systems (AREA)
  • Health & Medical Sciences (AREA)
  • Remote Sensing (AREA)
  • Fuzzy Systems (AREA)
  • Game Theory and Decision Science (AREA)
  • Operations Research (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)

Abstract

The invention discloses a kind of poorly efficient industrial land method for quickly identifying in cities and towns based on electricity consumption data, including:The Traffic Net of cities and towns industrial land patch, land used, enterprise, power supply taiwan area, monthly electricity consumption data are collected;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 average;Each factor data is matched by high definition satellite mapping, geographical coordinate;Each factor data is checked by topological relation, address;Power consumption is identified less than the patch of state's household electric standard to the moon, the poorly efficient industrial land identification distribution map in generation cities and towns.Whether the present invention is made full use of based on the commercial power data identification poorly efficient industrial land in cities and towns in this, as evaluation present situation cities and towns industrial land patch, if is had transformation and the basis of redevelopment potentiality, is realized that cities and towns industrial land patch High-efficiency Sustainable utilizes.

Description

The poorly efficient 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 poorly efficient 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, belongs to town planning technical field.
Background technology
According to prediction industrial research institute《Chinese soil exploitation industry market prediction 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 of 1981 Times, average growth rate per annum is average annual to increase by 1265 square kilometres of area, the obvious expansion situation of presentation up to 6.27%.In addition, data are shown Chinese city in 2014 builds area as 129.57 square metres per capita, well beyond 85.1 to 105.0 square metres of national standard/ People, 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, corpse enterprise is cleared up and has drawn Lead regulation and control city size, Optimizing City space structure etc. turns into the important content of current economic structural adjustment[1].Therefore, change Poorly efficient land used Land use systems, poorly efficient industrial land is vitalized, carry out intensive utilization, it is to carry that the redevelopment of poorly efficient industrial land, which is utilized, High land resources utilization efficiency, alleviate an important channel of urban land demand pressure[2]
Supply side structural reform since " 13 ", industry objectively is proposed with land use to industrial development and moved back Two enter three, and industry makes the transition to innovative industrial upgrading, and for land use from extensive to the new demands such as transition that become more meticulous, these are to alleviate Contradiction between town site demand and upgrading industry, raising land utilization efficiency, it is poorly efficient industrial to vitalize city storage The important channel on ground.Storage redevelopment in recent years, " three is old " transformation, city is double repair etc. policy explore poorly efficient construction land, It is constantly trying to and promotes on the road of poorly efficient industrial conversion, passes through the adjustment and transformation to similar industrial and land used, fully profit With the poorly efficient industrial land in city, city size is controlled, Optimizing City space structure, it is supporting to improve city, improves urban disease, reaches Alleviate the purpose of contradiction between town site demand and the requirement of national Transformation Development.The poorly efficient industrial land identification in city is city The prerequisite of city's industrial land transformation and upgrade, therefore, identification and evaluation for the poorly efficient 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 poorly efficient industrial land in cities and towns and appraisement system The problems such as basis of characterization objectivity is insufficient, recognition methods is complicated, recognition result practicality deficiency often be present, it is poorly efficient for cities and towns The identification of industrial land lacks a kind of method finely calculated always with evaluation.
After the industrial revolution, electric power brings deep change for economic and society, and people are generally using power consumption as weighing apparatus The important indicator of the economic quality of amount.2010, the famous political economy magazine of Britain《Economist》Release for assessing China's GDP growth The index " gram strong index " of amount:Industrial electricity increases newly, 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.
At present, the domestic research for utilizing electricity consumption data that poorly efficient industrial land, poorly efficient construction land is identified is seldom.Closely Nian Lai, mainly it is summarised as poorly efficient industrial land, the identification of poorly efficient construction land and correlative study method of redeveloping following several Class:
1) collection of summary method contrasted 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, predictably ticket supply potentiality, and the method collected by department calculates ground ticket demand[3]; Liu Xinping (2015) is summarized the experience by literature research, comparative study, practice innovation, is analyzed the poorly efficient construction land in cities and towns and is opened again The main reason for the lacking of capital of hair, predicament 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 poorly efficient key factor utilized of land used[5]
2) by correlation between data, data model (pattern) is built to evaluate, verify, prediction data:Chen Zhu Peace (2011) by build assessment indicator system, standardize assessment indicator system, establish evaluation model, division opinion rating to agriculture Village residential area redevelopment potentiality are calculated[6];Liu Hui (2014) etc. is repaiied by vector auto regression (V AR) model, vector error Just (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 is tested to interactive relationship[7];Gu Shoubai (2015) with Exemplified by the land control of Shanghai, propose to come effectively to alleviate the fund problem in land control with ppp patterns, and have studied ppp patterns Specific implementation path[8]
3) studied by the poorly efficient land current situation of assay, improve research method:Li Jing (2012) from perspective in research, research Method, finishing mode etc. analyze the poorly efficient land used regulation Potential Evaluation in China rural area and need to 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 poorly efficient land used province domain break up, Distribution, the situation and feature of region utilization rate, analyze land used leave unused poorly efficient government, market, in terms of enterprise the reason for, and carry The planning mechanism of control for leaving unused poorly efficient in prevention soil, examination rewards and punishments mechanism, dynamic monitoring mechanism, the length of 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 The main reason for extracting Guangzhou Baiyun District industrial land information, and poorly efficient industrial land formation analyzed by survey[11]
It is low with Reconstruc-tion policy or structure that most of key factor for stressing the poorly efficient land used formation of research influence is studied above Potential Evaluation of redeveloping to effectiveness system, this early-stage Study redeveloped for poorly efficient land used and later stage practice have important guiding Meaning.But one side traditional data is collected and check and correction has small data volume, collection difficulty, data objectivity deficiency, check and correction work Work amount is big, proofreads the defects of precision deficiency, causes the poorly efficient industrial land identification in cities and towns to lack with evaluation a kind of more accurate, fast Fast, workable data quantization methods.On the other hand, it is poorly efficient industrial for the poorly efficient construction land in cities and towns especially cities and towns , it is incomplete according to objectivity deficiency, identification and evaluation object to there is identification and evaluation in the data quantization system deficiency of identification with the evaluation on ground The defects of face, identification and evaluation result reliability deficiency.In addition, research industrial land is typically classified to middle class above, it is not refined to The group of specific industry.In addition, some scholars carry out poorly efficient research using industrial GDP to a kind of, two classes or the industry of certain class, still The industry to different industries classification does not carry out inefficient system research.
The bibliography that 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 poorly efficient land used transformation in the great cities and towns of Lai Wen Ground, 2016, (09):4-7.
[2] soar, Cai Minting, Ding Yu, Yuan Ting, the firm poorly efficient construction lands in cities of Wu Zhi are stored up cost-benefit measuring and calculating and ground Study carefully --- [J] the Guangdong 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 poorly efficient land used redevelopment in Liu Xinping, Yan Jinming, Wang Qing day China cities and towns and rational choice [J] China Land Sciences, 2015, (01):48-54.
[5] Zheng Wolin, the poorly efficient analysis of Influential Factors utilized of field light rural technique markets --- with reported in Tianhe district of Guangzhou With [J] area studies exemplified by Baiyun District with sending out, 2016, (06):104-108.
[6] Chen Zhuan, Zhang Liting, once order 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] Liu Hui " gram strong index " and dynamic relationship research-real example based on VAR and VEC models point of economic growth Analyse [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 measuring and calculating multi element research [J] Anhui Agricultural sciences, 2012, (08):4890-4892.
[10] Ma Ansheng, thunder margin are adjacent, Yuan Guohua, and Sun Ying three provinces in the northeast of China leave unused poorly efficient 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 poorly efficient industrial land target identifications of and secondary development strategy study [J] states Soil is studied with natural resources, and 2014, (04):20-24..
The content of the invention
The invention aims to solve the defects of above-mentioned prior art, there is provided a kind of cities and towns based on electricity consumption data Poorly efficient industrial land method for quickly identifying, this method are based on the commercial power data identification poorly efficient 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 and 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 poorly efficient 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, power supply platform Area, monthly electricity consumption data are collected;Wherein, the land used data include area, property, border, title and development status, institute Stating 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, 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, electricity consumption data examine again and amendment to the moon of cities and towns industrial land patch;
S7, power consumption is identified less than the patch of construction land load index to the cities and towns industrial land moon, enters one The poorly efficient industrial land identification distribution map in step generation cities and towns.
Preferably, it is described to the Traffic Net of cities and towns industrial land patch, land used, enterprise, power supply platform in step S1 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, in GIS software, cities and towns industrial land patch land used data are counted and numbered;
S12, based on Baidu map open data platform using Python write web crawlers obtain cities and towns industrial land spot Business data in block;
S13, according to power department record research range in cities and towns industrial land patch power supply taiwan area data, monthly use Electric data, the moon electricity consumption data of cities and towns industrial land patch in the research range of at least 1 year is counted, and according to radio area Electricity consumption data is collected location.
Preferably, it is 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, Baidu's open platform data acquisition interface is filled in as requested, input data obtains required parameter, obtains API Key;
S122, related URL request parameter is set;
S123, with Python parse URL request, to obtain business data, and save as csv file.
Preferably, in step S2, development status according to cities and towns industrial land patch, with radio area address, enterprise Title and enterprise address, screen to the land used of cities and towns industrial land patch, electricity consumption and business data, specifically include:
S21, after statistics is collected to cities and towns industrial land patch land used data, will wherein development status be " building " Cities and towns industrial land patch rejected;
S22, the power supply taiwan area data to cities and towns industrial land patch land used data and cities and towns industrial land patch, the moon After degree electricity consumption data is collected statistics, in Excel softwares, collected 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 Cleaned.
Preferably, it is described that default and abnormal electricity consumption, business data are modified in step S3, specifically include:
If S31, there are the power consumption data of cities and towns industrial land patch default, according to the scale of cities and towns industrial land patch Power consumption enters to the cities and towns industrial land patch for lacking electricity consumption data with the average moon of similar industrial land in research range 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 power consumption lack of balance situation, it is abnormal to monthly power consumption according to the scale of cities and towns industrial land patch and monthly power consumption Cities and towns industrial land patches carry out data correction;
S33, according to working base map geographic coordinate system, coordinate is carried out to the longitude and latitude of each company information in Python softwares 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 absolute value of data discrete degree, international standard represent the coefficient of variation with the ratio of standard deviation and average, are designated as cv, variation lines Several sizes, while influenceed by two statistics of average and standard deviation, the calculation formula of the coefficient of variation is as follows:
Cv=σi/|μi|
Wherein, σiThe standard deviation of equal electricity consumption data, μ for the patch mooniFor patch the moon electricity consumption data average value;
In step S32, the monthly power consumption lack of balance that each cities and towns industrial land patch is calculated using VC Method Situation, specifically include:
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 power consumption data average value, N is grinds Study carefully the time shaft for the monthly electricity consumption data observed, N >=12.
Preferably, it is 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 using radio area latitude and longitude coordinates to electricity consumption data carry out data dropping place;
S43, using GIS software load screening and revised business data csv file, pass 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 It is qualified that data match 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, the program that is matched using the address keyword of while, if sentence builder radio area address, enterprise address with patch address, If address matching rate reaches more than 80%, it is considered as electricity consumption data and qualified, the meter of the name-matches rate is matched with business data It is as follows to calculate formula:
M=D '/D
Wherein, M is address matching rate, and D ' is to be matched always with patch address with radio area and patch address, or enterprise address 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 Amendment, is specifically included:
S61, after being modified to cities and towns each key element of industrial land patch, match, check, in GIS software, according to repairing Monthly electricity consumption data after just with the calculating each patch moon equal coefficient of variation of power consumption, generates industrial land power consumption lack of balance feelings Condition distribution map;
S62, the power consumption lack of balance situation distribution map according to cities and towns industrial land patch, if electricity consumption data is abnormal, lead to The data for crossing GIS symbol display systems exclude to filter out abnormal cities and towns industrial land patch, again return 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, the power consumption less than construction land load index to the cities and towns industrial land moon Patch is identified, and further generates the poorly efficient industrial land identification distribution map in cities and towns, specifically includes:
S71, predicted according to urban power load in power consumption and load turn calculation method, by construction land load index Unit industrial land load index be converted into index on power consumption, as the basis of characterization of the poorly efficient industrial land in cities and towns, identify The poorly efficient industrial land in cities and towns, power consumption and load turn calculation algorithm are as follows:
Ec=P/ (δ × ε × θ × 8760)
Wherein, Ec is year power 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, equal power consumption, in GIS software, power consumption is less than ground with filtering out the moon according to the industrial land patch moon The industrial land patch of square power consumption index;
S73, predicted according to urban power load in power consumption and load turn calculation method, by 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 average, Pyatyi division is carried out according to averaging method, as the poorly efficient industry grading in cities and towns Foundation, and with reference to grading according to poorly efficient industrial grading;
S75, after being graded to the poorly efficient industrial land in cities and towns, in GIS software, intersected using GIS geographical combining for processing Function, the poorly efficient industrial land spatial information in all cities and towns is incorporated on a figure, all properties information integration on a table, Generate the poorly efficient industrial land identification distribution map in cities and towns.
The present invention has following beneficial effect relative to prior art:
1st, 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 for combining cities and towns industrial land is opened again for the transformation of the poorly efficient industrial land in cities and towns The advantage of hair, data screening, amendment, matching, check, inspection are carried out based on GIS-Geographic Information System (GIS) platform, realization will be poorly efficient All spatial informations of industrial land are incorporated on a figure, and all properties information integration is on a table;Then, used with reference to construction Unit industrial land load index in ground load index identifies poorly efficient industrial land, finally proposes the poorly efficient industry in effective cities and towns Land used recognition methods, realize the efficient and sustainable recycling of the poorly efficient industrial land in cities and towns.
2nd, the present invention utilizes the electricity consumption data of cities and towns industrial land, can make poorly efficient industrial land identification System forming one Effectively, fine Quantitative System, its abundant data accumulation and accurate data message help to lift poorly efficient industrial land Quantitative study, it is aided with the confidence level that traditional planning survey data improve poorly efficient industrial land identification, and to a certain extent Improve the efficiency of poorly efficient industrial land identification.
3rd, the present invention crawls poorly efficient industrial enterprise name, address, longitude and latitude using Python data minings, analysis method Degrees of data, the screening monthly electricity consumption data abnormal with analytical variance coefficient, can make effect industrial land identify System forming one Accurately, objective Quantitative System, accurately data mining ability and efficiently objective data analysis help to lift poorly efficient work for it The quantitative study of industry land used, is aided with the objectivity that traditional planning survey data improve the identification of poorly efficient industrial land, and from one Determine to improve the efficiency that poorly efficient industrial land identifies in degree.
4th, the poorly efficient industrial land in cities and towns is identified depth therefrom class essence by the present invention on the basis of traditional planning investigation method Specific industry is refine to, specifically includes the manufacture of general and special equipment, electric, electronic equipment manufacturing, clothes, shoes and hats manufacture, text Has manufacture, plastic products, rubber, metallic article, weaving, paper industry, chemical industry, ferrous metal smelting and processing.
5th, the present invention breaks through the limitation that the poorly efficient industrial land of certain class can only be typically differentiated using industrial GDP or enterprise tax, Realize and identify all kinds of poorly efficient industrial lands simultaneously.
6th, the present invention from data supporting and technical method for poorly efficient industrial land transformation provide a kind of new thinking and Direction, along with the fast development of information age, the multi-source data such as mobile phone signaling data, network opening data will be low Imitate industrial land redevelopment and poorly efficient industrial upgrades transition provides more prcgramming ideas and method.
Brief description of the drawings
Fig. 1 is the flow chart of the poorly efficient 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 power 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 power consumption Abnormality Analysis figure of cities and towns industrial land patch of the embodiment of the present invention 2.
Fig. 5 is the monthly power consumption abnormal conditions correction map of cities and towns industrial land of the embodiment of the present invention 2.
Fig. 6 is that the poorly efficient industrial land in cities and towns of the embodiment of the present invention 2 identifies distribution map.
Embodiment
With reference to embodiment and accompanying drawing, the present invention is described in further detail, but embodiments of the present invention are unlimited In this.
Embodiment 1:
As shown in figure 1, present embodiments provide a kind of poorly efficient 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 to carry out working base map first processing and Check.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., should be in generalized information system by each generic attribute of industrial land patch because 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 poorly efficient industrial land in cities and towns.
Because certain information imperfection, industrial land electricity consumption data, enterprise be present in the industrial land address in GIS database Industry address date Statistical Criteria is also not quite identical.So on the basis of industrial land address is checked, 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, with reference to monthly the equal electricity consumption data of cities and towns industrial land patch, with certain Analysis method and technological means, realize the identification to poorly efficient 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, border, 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, it is the important evidence for differentiating group industrial land property, and specific industry land used The important references of border 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 power consumption, the suggestion of general data timing statisticses scope are 1-2, the moon in the range of power consumption can differentiate mesh The industrial liveness in preceding cities and towns and the utilization of capacity of factory, the moon power consumption be also to identify that cities and towns are poorly efficient industrial important Reference index.
Traffic Net in traditional planning survey data, it 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 according to each specific industrial land patch generation, main reflection in GIS database 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 class works Industry, all kinds of cities and towns industrial land power consumption indexs are the important references of the poorly efficient 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, and it is that one kind, the industry of two classes, three classes are carried out Further segment 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, it is one of electricity consumption data, the important references of business data verification;Development status refer to that cities and towns are industrial Ground belongs to " building " or " built " during moon electricity consumption is counted, and it has influence on 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, using cities and towns industrial land patch as the space cell researched and analysed, to its area, property, border, title, exploitation shape State and Traffic Net carry out statistics collection.It should be noted that because the industrial land address in GIS database is present Certain information imperfection, the electricity consumption data of cities and towns industrial land, enterprise's address data statistics bore are also not quite identical.Institute So that on the basis of cities and towns industrial land address is checked, industrial land patch and GIS government affairs map, high definition satellite mapping should be entered Row spatial match, improve the accuracy of industrial land information.
After matching, in GIS software, the topological relation of industrial land is established, according to cities and towns industrial land patch Tu Yu roads 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 It is qualified to be matched for land used data with GIS working maps, and 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
Power supply taiwan area data, the monthly electricity consumption data of cities and towns industrial land in the research range recorded according to power department, The moon electricity consumption data of cities and towns industrial land patch in the statistics research range of at least 1 year, and according to radio area address to data Collected;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 The program that keyword matches with cities and towns industrial land patch address, if address matching rate reaches more than 80%, it is considered as electricity consumption number Qualified according to being matched with business data, the calculation formula of the name-matches rate is as follows:
M=D '/D (3)
Wherein, M is address matching rate, and D ' is to be matched always with patch address with radio area and patch address, or enterprise address Number, D are patch sum.
Significantly, since certain deviation be present with radio area longitude and latitude and working base map geographic coordinate system on a small quantity, It is possible that a small amount of electricity consumption data is on the border 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, it is inclined to existing according to electricity consumption data address The electricity consumption data of difference is modified.
Specified otherwise is needed herein, because the first amendment of default or abnormal electricity consumption data is known in Python Not with analysis, counted and corrected in Excel, although result is objective and accurate, result is numeral before and after amendment Contrast, fail to carry out visualization inspection with reference to land used, therefore, after Data Matching, utilize GIS data processing and analysis Function, visualization presentation is carried out to the correcting the front and rear cities and towns industrial land moon electricity consumption coefficient of variation, and differentiate correction result Whether perfect electricity consumption data.
Wherein, the monthly power consumption lack of balance situation of 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 power consumption carry out data to the cities and towns industrial land patch of monthly power consumption exception Amendment.
The coefficient of variation is to weigh a statistic of each observation degree of variation in data information, reflects data discrete degree Absolute value, international standard represents the coefficient of variation with the ratio of standard deviation and average, is designated as cv (Coefficient of Variance), the size of the coefficient of variation, while influenceed by two statistics of average and standard deviation, the calculating of the coefficient of variation Formula is as follows:
Cv=σi/|μi| (4)
Wherein, σiThe standard deviation of equal electricity consumption data, μ for the patch mooniFor patch the moon electricity consumption data average value;
The monthly power consumption lack of balance situation of 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 power consumption data average value, N is grinds 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 Company information in land used patch, including enterprise name, address, longitude and latitude etc., secondly write industrial classification journey using Python Sequence, determine the industrial classification of enterprise, afterwards using comprehensively utilize Excel, Python, GIS (ArcGIS) to business data carry out 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 result is crawled, 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, write enterprise's longitude and latitude in web crawlers acquisition Baidu map in the industrial land patch of cities and towns using Python Degree, because 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 border or on road network, therefore, should increase enterprise's number after being matched to electricity consumption data According to check and correction step, the business data that deviation be present is proofreaded and corrected according to business data title, address.
1.3) electricity consumption data examine and correct again to the cities and towns industrial land patch moon
After being modified to cities and towns each key element of industrial land patch, match, check, in GIS software, after amendment Monthly electricity consumption data with the calculating each patch moon equal coefficient of variation of power consumption, generation industrial land power consumption lack of balance situation point Butut;
According to the power consumption lack of balance situation distribution map of cities and towns industrial land patch, if electricity consumption data is abnormal, pass through GIS The data of symbol display system are excluded to filter out abnormal cities and towns industrial land patch, and data correction is carried out to abnormal electricity consumption data.
2) identification of the poorly efficient industrial land in cities and towns
According to the area of the cities and towns industrial land patch of collection, property, border, title, development status and cities and towns industry Enterprise name, address in land used patch, longitude and latitude, power supply taiwan area data, monthly power consumption data, with reference to local unit's construction Unit industrial land load index in land used load index, cities and towns industrial land power consumption low value patch is identified.
2.1) turn calculation of electricity consumption data
According to《Municipal engineering systems organization》Power consumption in the prediction of (second edition) urban power load turns calculation side with load Method, the unit industrial land load index in local unit's construction land load index is converted into index on power consumption, as city The discrimination standard of the poorly efficient industrial land in town, the poorly efficient industrial land in cities and towns is identified, power consumption and load turn calculation algorithm are as follows:
Ec=P/ (δ × ε × θ × 8760) (7)
Wherein, Ec is year power 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 poorly efficient industrial land identification in cities and towns
Equal power consumption, with the overlay analysis method of GIS data processing platform, is identified according to the industrial land patch moon The equal power consumption in moon ground is less than the industrial land patch of local power consumption index.
3) the poorly efficient industrial land grading in cities and towns
After identifying the poorly efficient industrial land in cities and towns, born with reference to the unit industrial land in state-owned unit's construction land load index Lotus index is graded to poorly efficient industrial land, and further generates cities and towns effect industrial land identification distribution map.
3.1) turn calculation of electricity consumption data
According to《Municipal engineering systems organization》Power 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) poorly efficient 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, to carrying out 5 grades of evaluation divisions below all kinds of cities and towns industrial land index on power consumption averages, opened again as the poorly efficient industry in cities and towns Send out Potential Evaluation foundation.Then, poorly efficient industrial land transformation potentiality rank is differentiated with reference to Appreciation gist.
3.3) cities and towns effect industrial land identification distribution map
After being graded to the poorly efficient industrial land in cities and towns, in GIS software, the joint using the geographical processing of GIS intersects work( Can, all poorly efficient industrial land spatial informations are incorporated on a figure, all properties information integration generates city on a table Town effect industrial land identification distribution map.
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, border, title, development status and enterprise name in industrial land patch, address, longitude and latitude Degree, power supply taiwan area data, monthly power consumption data, integrated use GIS, Python, CAD, Excel data processing and data point Analysis method completes 102 pieces of poorly efficient industrial land identifications, and proposes that poorly efficient industrial land patch transformation potentiality grading judges.Research master To include basic data collection to comment with check, the identification of the poorly efficient industrial land in cities and towns, the poorly efficient industrial land redevelopment potentiality in cities and towns Three parts of level.
1) basic data is collected and checked
First, data are collected.Cities and towns industrial land patch using land planning department GIS land used databases is grinds The space cell of analysis is studied carefully, to Traffic Net in research range, the area of cities and towns industrial land patch, property, border, name Claim, development status and enterprise name in industrial land patch, address, longitude and latitude, power supply taiwan area data, monthly power 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;Collected according to radio area address, other land used electricity consumption datas therein are entered Row is rejected;The business data wherein repeated is cleaned according to enterprise name, enterprise address.Effective industrial plot is obtained 102 pieces, effective electricity consumption data 1109, effective business data 183.
Afterwards, default and abnormal data is modified.The cities and towns default or abnormal to monthly power consumption data are industrial Ground patch, power consumption is to lacking according to the average moon of similar industrial land in the scale and research range of industrial land patch The industrial land patch of electricity consumption data carries out data correction, the equal power consumption present situation figure such as Fig. 3 institutes in cities and towns industrial land patch moon ground Show, industrial land patch monthly power consumption abnormal conditions in cities and towns are as shown in figure 4, after abnormal conditions amendment as shown in Figure 5;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.Circular reference formula (4)~(6), default electricity consumption data data 91 are corrected 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, line number is entered to electricity consumption data by using radio area latitude and longitude coordinates According to dropping place;Business data is matched by business data longitude and latitude, determines the land character of industrial land patch;Utilize The joint of the geographical processing of GIS software 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 Bar.
In addition, data are checked.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 that if sentence builders radio area address, the address keyword of enterprise address match with land used patch 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 For 88.52%.
Finally, electricity consumption data is carried out examining and correcting again.In GIS software, the variation of power consumption according to the moon Coefficient, generate industrial land power consumption lack of balance situation distribution map;If electricity consumption data is abnormal, pass through GIS symbol display systems Data exclude to filter out abnormal industrial land patch, then data correction is carried out to abnormal electricity consumption data;If this time assay It is qualified, then do not occur abnormal data.
2) identification of the poorly efficient 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- Power consumption in survey turns calculation method with load, by the unit industrial land load index in local unit's construction land load index Index on power consumption is converted into, the basis of characterization as the poorly efficient industrial land in cities and towns.Circular reference formula (7).
Then, poorly efficient industrial land is identified, in GIS software, power consumption is less than place use with identifying the moon The industrial land patch of electric index.Not poorly efficient 30 pieces of the industrial land of common recognition, as shown in Figure 6.
3) the poorly efficient 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- Power consumption in survey and load turn calculation method, 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, the poorly efficient industrial land in cities and towns is carried out transforming potentiality grading.To all types of industries land used index on power consumption average Following codomain, 5 grades of divisions are carried out according to averaging method, the foundation as the poorly efficient industrial conversion potentiality grading in cities and towns.
Afterwards, graded with reference to the grading of transformation potentiality according to transformation potentiality are carried out to poorly efficient industrial land.According to transformation potentiality Grading is according to carrying out descending arrangement to rating result, wherein poorly efficient industrial 3 pieces of the plot of one-level, poorly efficient industrial 13 pieces of the plot of two level, Poorly efficient industrial 6 pieces of the plot of three-level, poorly efficient industrial 2 pieces of the plot of level Four, poorly efficient industrial 6 pieces of the plot of Pyatyi.
Finally, cities and towns effect industrial land identification distribution map is generated.In GIS software, the joint work(of the geographical processing of GIS is utilized Can, all poorly efficient industrial land spatial informations are incorporated on a figure, all properties information integration generates city on a table Town effect industrial land identification distribution map.
In summary, it is of the invention on the basis of traditional planning investigation method, the land used of collection cities and towns industrial land patch, Enterprise, power supply taiwan area and monthly electricity consumption data, and the electricity consumption data of cities and towns industrial land is combined for the poorly efficient 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 poorly efficient 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 poorly efficient industrial land, finally proposes effective cities and towns Poorly efficient industrial land recognition methods, realize the efficient and sustainable recycling of the poorly efficient industrial land in cities and towns.
It will be understood by those skilled in the art that the inventive method applies also for the poorly efficient industry land such as logistics, storage, office Quick identification;It is also applied for the quick identification of the poorly efficient 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 poorly efficient construction land.
It is described 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 scope 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 poorly efficient industrial land method for quickly identifying in cities and towns based on electricity consumption data, it is characterised in that:Methods described includes following Step:
S1, in some research range, to the Traffic Net of cities and towns industrial land patch, land used, enterprise, power supply taiwan area, Monthly electricity consumption data is collected;Wherein, the land used data include area, property, border, 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, electricity consumption data examine again and amendment to the moon of cities and towns industrial land patch;
S7, power consumption is identified less than the patch of construction land load index to the cities and towns industrial land moon, further raw Into the poorly efficient industrial land identification distribution map in cities and towns.
2. the poorly efficient industrial land method for quickly identifying in the cities and towns according to claim 1 based on electricity consumption data, its feature exist In:It is described to the Traffic Net of cities and towns industrial land patch, land used, enterprise, power supply taiwan area, monthly electricity consumption in step S1 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 numbered;
S12, based on Baidu map open data platform using Python write web crawlers obtain cities and towns industrial land patch in Business data;
The power supply taiwan area data of cities and towns industrial land patch, monthly electricity consumption number in S13, the research range recorded according to power department According to, the moon electricity consumption data of cities and towns industrial land patch in the statistics research range of at least 1 year, and according to radio area address pair Electricity consumption data is collected.
3. the poorly efficient industrial land method for quickly identifying in the cities and towns according to claim 2 based on electricity consumption data, its 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, is specifically included:
S121, Baidu's open platform data acquisition interface is filled in as requested, input data obtains required parameter, obtains API Key;
S122, related URL request parameter is set;
S123, with Python parse URL request, to obtain business data, and save as csv file.
4. the poorly efficient industrial land method for quickly identifying in the cities and towns according to claim 1 based on electricity consumption data, its feature exist In:In step S2, development status according to cities and towns industrial land patch, with radio area address, enterprise name and industrially Location, the land used of cities and towns industrial land patch, electricity consumption and business data are screened, specifically included:
S21, after statistics is collected to cities and towns industrial land patch land used data, will development status be wherein city " building " Town industrial land patch is rejected;
S22, in power supply taiwan area data, the monthly use to cities and towns industrial land patch land used data and cities and towns industrial land patch After electric data are collected statistics, in Excel softwares, collected 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, it is determined that 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 poorly efficient industrial land method for quickly identifying in the cities and towns according to claim 1 based on electricity consumption data, its feature exist In:It is described that default and abnormal electricity consumption, business data are modified in step S3, specifically include:
If S31, having that the power consumption data of cities and towns industrial land patch are default, according to the scale of cities and towns industrial land patch and grind Power consumption enters line number to similar industrial land in the range of studying carefully to the cities and towns industrial land patch for lacking electricity consumption data with being averaged the moon According to amendment;
S32, after being modified to default electricity consumption data, utilize VC Method to calculate the moon of each cities and towns industrial land patch Power consumption lack of balance situation is spent, according to the scale of cities and towns industrial land patch and monthly power consumption to the abnormal city of monthly power consumption Town industrial land patch carries out data correction;
S33, according to working base map geographic coordinate system, in Python softwares carrying out coordinate to the longitude and latitude of each company information entangles Partially, unified business data and working base map geographic coordinate system.
6. the poorly efficient industrial land method for quickly identifying in the cities and towns according to claim 5 based on electricity consumption data, its 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, international standard represents the coefficient of variation with the ratio of standard deviation and average, is designated as cv, the size of the coefficient of variation is simultaneously Influenceed by two statistics of average and standard deviation, the calculation formula of the coefficient of variation is as follows:
Cv=σi/|μi|
Wherein, σiThe standard deviation of equal electricity consumption data, μ for the patch mooniFor patch the moon electricity consumption data average value;
In step S32, the monthly power consumption lack of balance situation that each cities and towns industrial land patch is calculated using VC Method, Specifically include:
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:
<mrow> <msub> <mi>&amp;sigma;</mi> <mi>i</mi> </msub> <mo>=</mo> <msqrt> <mrow> <mfrac> <mn>1</mn> <mi>N</mi> </mfrac> <munderover> <mo>&amp;Sigma;</mo> <mrow> <mi>i</mi> <mo>=</mo> <mn>1</mn> </mrow> <mi>n</mi> </munderover> <msup> <mrow> <mo>(</mo> <msub> <mi>x</mi> <mi>i</mi> </msub> <mo>-</mo> <msub> <mi>&amp;mu;</mi> <mi>i</mi> </msub> <mo>)</mo> </mrow> <mn>2</mn> </msup> </mrow> </msqrt> </mrow>
Wherein, xiFor the monthly electricity consumption data of i patches, μiFor i patches the moon equal power consumption data average value, N is research institute The time shaft of the monthly electricity consumption data of observation, N >=12.
7. the poorly efficient industrial land method for quickly identifying in the cities and towns according to claim 1 based on electricity consumption data, its 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, specifically include:
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 using radio area latitude and longitude coordinates to electricity consumption data carry out data dropping place;
S43, using GIS software load screening and revised business data csv file, 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, using GIS software geography at 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 poorly efficient industrial land method for quickly identifying in the cities and towns according to claim 1 based on electricity consumption data, its 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 It is qualified to be matched 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 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 The program matched with the address keyword of while, if sentence builder radio area address, enterprise address with patch address, if ground Location matching rate reaches more than 80%, then is considered as electricity consumption data and qualified, the calculating public affairs of the name-matches rate are matched with business data Formula is as follows:
<mrow> <mi>D</mi> <mo>=</mo> <munderover> <mo>&amp;Sigma;</mo> <mi>n</mi> <mn>1</mn> </munderover> <mrow> <mo>(</mo> <msub> <mi>D</mi> <mn>1</mn> </msub> <mo>,</mo> <msub> <mi>D</mi> <mn>2</mn> </msub> <mo>,</mo> <msub> <mi>D</mi> <mn>3</mn> </msub> <mo>,</mo> <mo>...</mo> <mo>...</mo> <mo>,</mo> <msub> <mi>D</mi> <mi>n</mi> </msub> <mo>)</mo> </mrow> </mrow>
M=D '/D
Wherein, M is address matching rate, and D ' is to match sum, D with patch address with radio area and patch address, or enterprise address For patch sum.
9. the poorly efficient industrial land method for quickly identifying in the cities and towns according to claim 1 based on electricity consumption data, its feature exist In:In step S6, the moon to cities and towns industrial land patch electricity consumption data examine again and amendment, specific bag Include:
S61, after being modified to cities and towns each key element of industrial land patch, match, check, in GIS software, after amendment Monthly electricity consumption data with the calculating each patch moon equal coefficient of variation of power consumption, generation industrial land power consumption lack of balance situation point Butut;
S62, the power consumption lack of balance situation distribution map according to cities and towns industrial land patch, if electricity consumption data is abnormal, pass through GIS The data of symbol display system exclude to filter out abnormal cities and towns industrial land patch, again return to step S3, and according to step S3 In abnormal conditions to abnormal electricity consumption data carry out data correction.
10. the poorly efficient industrial land method for quickly identifying in the cities and towns according to claim 1 based on electricity consumption data, its feature exist In:In step S7, described power consumption is identified less than the patch of construction land load index to the cities and towns industrial land moon, The poorly efficient industrial land identification distribution map in cities and towns is further generated, is specifically included:
S71, predicted according to urban power load in power 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 poorly efficient industrial land in cities and towns, identifies cities and towns Poorly efficient industrial land, power consumption and load turn calculation algorithm are as follows:
Ec=P/ (δ × ε × θ × 8760)
Wherein, Ec is year power 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, equal power consumption, in GIS software, power consumption is less than place use with filtering out the moon according to the industrial land patch moon The industrial land patch of electric index;
S73, predicted according to urban power load in power 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 average, according to averaging method carry out Pyatyi division, as cities and towns it is poorly efficient industry grading according to According to, and with reference to grading according to poorly efficient industrial grading;
S75, after being graded to the poorly efficient industrial land in cities and towns, in GIS software, the joint using the geographical processing of GIS intersects function, The poorly efficient industrial land spatial information in all cities and towns is incorporated on a figure, all properties information integration is on a table, generation The poorly efficient industrial land identification distribution map in cities and towns.
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 true CN107766415A (en) 2018-03-06
CN107766415B 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)

Cited By (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN109116072A (en) * 2018-06-29 2019-01-01 广东电网有限责任公司 Electricity stealing analysis method and device and server
CN112419124A (en) * 2020-11-19 2021-02-26 广州市城市规划勘测设计研究院 Method and device for quickly identifying low-efficiency industrial land and storage medium thereof
CN116029461A (en) * 2023-03-24 2023-04-28 北京易能中网技术有限公司 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
CN117251770A (en) * 2023-11-17 2023-12-19 北京新兴科遥信息技术有限公司 Method for identifying low-utility land

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20080091283A1 (en) * 2006-10-17 2008-04-17 Bulent Balci 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
CN104750799A (en) * 2015-03-23 2015-07-01 华南理工大学 Method for recognizing construction land type rapidly 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

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20080091283A1 (en) * 2006-10-17 2008-04-17 Bulent Balci 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
CN104750799A (en) * 2015-03-23 2015-07-01 华南理工大学 Method for recognizing construction land type rapidly 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

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
陈基伟: "低效工业用地再开发政策研究", 《科学发展》 *

Cited By (8)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN109116072A (en) * 2018-06-29 2019-01-01 广东电网有限责任公司 Electricity stealing analysis method and device and server
CN112419124A (en) * 2020-11-19 2021-02-26 广州市城市规划勘测设计研究院 Method and device for quickly identifying low-efficiency industrial land and storage medium thereof
CN112419124B (en) * 2020-11-19 2022-04-01 广州市城市规划勘测设计研究院 Method and device for quickly identifying low-efficiency industrial land and storage medium thereof
CN116029461A (en) * 2023-03-24 2023-04-28 北京易能中网技术有限公司 Method for realizing user load prediction based on autoregressive algorithm
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
CN117251770A (en) * 2023-11-17 2023-12-19 北京新兴科遥信息技术有限公司 Method for identifying low-utility land
CN117251770B (en) * 2023-11-17 2024-02-13 北京新兴科遥信息技术有限公司 Method for identifying low-utility land

Also Published As

Publication number Publication date
CN107766415B (en) 2018-09-14

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
Li et al. Research trend of the application of information technologies in construction and demolition waste management
Roddis et al. The role of community acceptance in planning outcomes for onshore wind and solar farms: An energy justice analysis
Wang et al. Characterizing urban building metabolism with a 4D-GIS model: A case study in China
Gao et al. The impact of green finance on industrial reasonability in China: Empirical research based on the spatial panel Durbin model
Huang et al. A systematic review of empirical methods for modelling sectoral carbon emissions in China
Xie et al. Does misallocation of land resources reduce urban green total factor productivity? An analysis of city-level panel data in China
Pitman Overview of water resource assessment in South Africa: Current state and future challenges
Wang et al. Economic perspective-based analysis on urban infrastructures carrying capacity—A China study
CN105809350A (en) Natural village hollowing degree and type recognition method for construction land renovation
Wan et al. A study of regional sustainable development based on GIS/RS and SD model—Case of Hadaqi industrial corridor
Song et al. Region division of China's carbon market based on the provincial/municipal carbon intensity
Salata Land use change analysis in the urban region of Milan
Derrible et al. Urban metabolism
Radermacher Indicators, green accounting and environment statistics—information requirements for sustainable development
Liu et al. Comprehensive quantitative evaluation of the water resource carrying capacity in Wuhan City based on the “human–water–city” framework: Past, present and future
Cai et al. Fine Resolution Carbon Dioxide Emission Gridded Data and Their Application for China.
Liu et al. Changing trends and influencing factors of energy productivity growth: A case study in the Pearl River Delta Metropolitan Region
Alariqi et al. Modelling dynamic links among energy transition, technological level and economic development from the perspective of economic globalisation: Evidence from MENA economies
Raza et al. Future outlook and influencing factors analysis of natural gas consumption in Bangladesh: an economic and policy perspectives
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
CN112184495B (en) Stock low-efficiency land monitoring system and analysis platform using same
Li et al. How industrial landscape affects the regional industrial economy: A spatial heterogeneity framework
Wen et al. Externality impacts of “Not in My Backyard” facilities on property values: Evidence from the Hangzhou waste sorting and reduction complex projects
Choi et al. Retrofit building energy performance evaluation using an energy signature-based symbolic hierarchical clustering method

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