CN114880424A - Residential building new energy automobile charging pile proportion analysis method and system - Google Patents
Residential building new energy automobile charging pile proportion analysis method and system Download PDFInfo
- Publication number
- CN114880424A CN114880424A CN202210807516.1A CN202210807516A CN114880424A CN 114880424 A CN114880424 A CN 114880424A CN 202210807516 A CN202210807516 A CN 202210807516A CN 114880424 A CN114880424 A CN 114880424A
- Authority
- CN
- China
- Prior art keywords
- charging pile
- user
- building
- data
- distribution transformer
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000004458 analytical method Methods 0.000 title claims abstract description 41
- 238000010586 diagram Methods 0.000 claims abstract description 26
- 230000005611 electricity Effects 0.000 claims description 32
- 238000000034 method Methods 0.000 claims description 14
- 238000013075 data extraction Methods 0.000 claims description 8
- 238000012216 screening Methods 0.000 claims description 8
- 238000012545 processing Methods 0.000 claims description 6
- 238000012423 maintenance Methods 0.000 abstract description 8
- 238000009434 installation Methods 0.000 abstract description 3
- 230000000694 effects Effects 0.000 description 4
- 239000000284 extract Substances 0.000 description 3
- 238000006243 chemical reaction Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000002688 persistence Effects 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
- 230000009466 transformation Effects 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/29—Geographical information databases
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
- G06F16/215—Improving data quality; Data cleansing, e.g. de-duplication, removing invalid entries or correcting typographical errors
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
- G06F16/2462—Approximate or statistical queries
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/90—Details of database functions independent of the retrieved data types
- G06F16/906—Clustering; Classification
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q50/00—Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
- G06Q50/06—Energy or water supply
-
- Y—GENERAL 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
- Y04—INFORMATION OR COMMUNICATION TECHNOLOGIES HAVING AN IMPACT ON OTHER TECHNOLOGY AREAS
- Y04S—SYSTEMS INTEGRATING TECHNOLOGIES RELATED TO POWER NETWORK OPERATION, COMMUNICATION OR INFORMATION TECHNOLOGIES FOR IMPROVING THE ELECTRICAL POWER GENERATION, TRANSMISSION, DISTRIBUTION, MANAGEMENT OR USAGE, i.e. SMART GRIDS
- Y04S30/00—Systems supporting specific end-user applications in the sector of transportation
- Y04S30/10—Systems supporting the interoperability of electric or hybrid vehicles
- Y04S30/14—Details associated with the interoperability, e.g. vehicle recognition, authentication, identification or billing
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- General Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Health & Medical Sciences (AREA)
- Economics (AREA)
- Probability & Statistics with Applications (AREA)
- General Health & Medical Sciences (AREA)
- General Business, Economics & Management (AREA)
- Human Resources & Organizations (AREA)
- Marketing (AREA)
- Primary Health Care (AREA)
- Strategic Management (AREA)
- Tourism & Hospitality (AREA)
- Water Supply & Treatment (AREA)
- Public Health (AREA)
- Fuzzy Systems (AREA)
- Mathematical Physics (AREA)
- Software Systems (AREA)
- Computational Linguistics (AREA)
- Remote Sensing (AREA)
- Quality & Reliability (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses a resident building new energy automobile charging pile proportion analysis method and system, relating to the technical field of new energy automobiles, wherein building data and charging pile user data are respectively extracted from a marketing system, GIS single line diagram data of a target area is obtained from a distribution network GIS management system, associating the building data, the GIS single line diagram data and the charging pile user data by taking the distribution transformer area user number as a key field to obtain the number of 0.4kV resident users and the number of charging pile users under each building, therefore, the charging pile occupation ratio under each floor is calculated, the accuracy and the reliability of the occupation ratio analysis result of the charging piles of the residential floors are improved, and the technical problems that the existing identification of the charging piles of the residential floors of new energy vehicles only depends on a marketing system to acquire the number of the charging piles, the installation reporting condition and the occupation ratio condition of the charging piles of the residential floors cannot be accurately analyzed, and the maintenance of distribution network lines and the safe and stable operation of distribution networks are difficult to guide are solved.
Description
Technical Field
The invention relates to the technical field of new energy automobiles, in particular to a residential building new energy automobile charging pile proportion analysis method and system.
Background
Under the condition that new forms of energy car is gradually popularized day by day, also increase gradually as supporting electric pile that fills, especially the newspaper of resident's building electric pile shows the growth of persistence. The continuous demand of the electricity utilization of the residential building charging pile for reporting the installation can affect the load and capacity margin of a public transformer of an original building and even a 10kV line, and the load characteristic of the charging pile also creates a challenge for the operation and maintenance of a distribution network line.
The existing identification of the charging pile simply depends on a marketing system to master the quantity of the charging piles, but the intelligent identification, the occupation ratio and the increment condition of the charging pile of a residential building cannot be controlled transparently, and the operation, maintenance and management of a public transformer of the residential building and the safe and stable operation of a distribution network can be influenced. Therefore, the intelligent identification and analysis of the residential building charging pile are realized, the charging pile reporting condition and the occupation ratio condition of the residential building are obtained, and the guarantee is provided for the distribution network line maintenance and the distribution network safe and stable operation, so that the technical problem to be solved by technical personnel in the field is urgently needed.
Disclosure of Invention
The invention provides a residential building new energy automobile charging pile proportion analysis method and system, which are used for solving the technical problems that the existing residential building new energy automobile charging pile identification is realized by simply obtaining the number of charging piles through a marketing system, the charging pile installation condition and proportion condition of a residential building cannot be accurately analyzed, and the maintenance of a distribution network line and the safe and stable operation of a distribution network are difficult to guide.
In view of this, the first aspect of the present invention provides a charging pile percentage analysis method for a residential building new energy vehicle, including:
acquiring resident user data from a marketing system, and constructing a 0.4kV resident user database, wherein the resident user data comprises a power utilization address;
extracting a power utilization address from a 0.4kV residential user database, classifying residential user data according to the floor information in the power utilization address to obtain floor data of each floor, wherein the floor data comprises a distribution transformer subordinate district office, a distribution transformer subordinate power supply station, a floor name, a floor address, a user number, a user name and a distribution transformer district user number;
acquiring GIS single line diagram data of a target area from a distribution network GIS management system, and constructing a distribution network GIS topological database, wherein the distribution network GIS topological database comprises distribution transformer names, distribution transformer area user numbers, distribution transformer subordinate 10kV lines, distribution transformer subordinate substations, distribution transformer subordinate power supply stations and distribution transformer subordinate area stations;
acquiring charging pile user data from a marketing system, wherein the charging pile user data comprises a subordinate district of a charging pile, a subordinate power supply station of the charging pile, a user number of the charging pile, a user name of the charging pile, a grid-connected address of the charging pile, an access transformer district name of the charging pile and a distribution transformer district user number of the charging pile;
associating the building data, the GIS single line diagram data and the charging pile user data by taking the distribution transformer area user number as a key field to obtain the number of 0.4kV resident users and the number of charging pile users under each building;
and calculating the charging pile occupation ratio under each floor according to the number of 0.4kV resident users under each floor and the number of charging pile users.
Optionally, acquiring residential user data from the marketing system, and constructing a 0.4kV residential user database, wherein the residential user data includes a power utilization address, including:
the method comprises the steps of extracting resident user data of a non-square, a non-commercial shop and a non-commercial shop with the voltage grade of 0.4kV, the electricity consumption type of residential life, the metering mode of low supply and low metering and the user category of public transformer customers from a marketing system, extracting distribution transformer subordinate district bureau, distribution transformer subordinate power supply station, electricity consumption address, user number, user name and distribution transformer district user number of a resident user, and constructing a 0.4kV resident user database.
Optionally, extracting the electricity utilization address from the 0.4kV residential customer database, classifying the residential customer data according to the floor information in the electricity utilization address, and obtaining the floor data of each floor, including:
extracting a power utilization address from a 0.4kV residential user database;
removing provincial fields, city fields and district fields in the power utilization addresses, describing the power utilization addresses with similarity of more than 60% and the number of users of more than 500 users after screening, and classifying the power utilization addresses as the same building;
extracting the name of the building from the electricity utilization address of the same building;
and matching the 0.4kV residential user database according to the building name to obtain the building data of each building.
Optionally, obtaining charging pile user data from a marketing system includes:
the charging pile user data that the access voltage class is 0.4kV, the pricing mode is large industrial power consumption, the metering mode is low supply and low metering, the user name contains the charging pile or the device operation condition is in operation, and the user name contains the charging pile are extracted from the marketing system.
Optionally, after calculating the ratio of charging piles under each floor according to the number of 0.4kV resident users and the number of charging pile users under each floor, the method further includes:
the number of charging piles and the proportion information of the charging piles of the building are represented by the dimensions of the subordinate district bureau and the subordinate power supply station of the charging piles respectively, and the charging piles are arranged in descending order according to the number dimension of the charging piles.
The second aspect of the invention also provides a residential building new energy automobile charging pile proportion analysis system, which comprises:
the resident user data extraction module is used for acquiring resident user data from the marketing system and constructing a 0.4kV resident user database, wherein the resident user data comprises a power utilization address;
the system comprises a data acquisition module, a data processing module and a data processing module, wherein the data acquisition module is used for acquiring a power utilization address from a 0.4kV residential user database, classifying residential user data according to the data of the power utilization address to obtain the data of each building, and the data of the building comprises a distribution transformer subordinate area office, a distribution transformer subordinate power supply station, a building name, a building address, a user number, a user name and a distribution transformer area user number;
the distribution network GIS topological data acquisition module is used for acquiring GIS single line diagram data of a target area from a distribution network GIS management system and constructing a distribution network GIS topological database, wherein the distribution network GIS topological database comprises a distribution transformer name, a distribution transformer area user number, a distribution transformer subordinate 10kV line, a distribution transformer subordinate transformer substation, a distribution transformer subordinate power supply station and a distribution transformer subordinate area office;
the charging pile user number acquisition module is used for acquiring charging pile user data from the marketing system, wherein the charging pile user data comprises a subordinate district office of the charging pile, a subordinate power supply station of the charging pile, a user number of the charging pile, a user name of the charging pile, a grid-connected address of the charging pile, an access district name of the charging pile and a distribution transformer district user number of the charging pile;
the data association module is used for associating the building data, the GIS single line diagram data and the charging pile user data by taking the user number of the distribution transformer area as a key field to obtain the number of 0.4kV resident users and the number of charging pile users under each building;
and the charging pile occupation ratio analysis module is used for calculating the charging pile occupation ratio under each floor according to the number of 0.4kV residential users under each floor and the number of charging pile users.
Optionally, the resident user data extracting module is specifically configured to:
the method comprises the steps of extracting resident user data of a non-square, a non-commercial shop and a non-commercial shop with the voltage grade of 0.4kV, the electricity consumption type of residential life, the metering mode of low supply and low metering and the user category of public transformer customers from a marketing system, extracting distribution transformer subordinate district bureau, distribution transformer subordinate power supply station, electricity consumption address, user number, user name and distribution transformer district user number of a resident user, and constructing a 0.4kV resident user database.
The building data extraction module is specifically used for:
extracting a power utilization address from a 0.4kV residential user database;
removing provincial fields, city fields and district fields in the power utilization addresses, describing the power utilization addresses with similarity of more than 60% and the number of users of more than 500 users after screening, and classifying the power utilization addresses as the same building;
extracting the name of the building from the electricity utilization address of the same building;
and matching the 0.4kV residential user database according to the building names to obtain the building data of each building, wherein the building data comprises distribution transformer subordinate district offices, distribution transformer subordinate power supply stations, building names, building addresses, user numbers, user names and distribution transformer station user numbers.
Optionally, fill electric pile user number acquisition module and specifically be used for:
the method comprises the steps of extracting the access voltage grade of 0.4kV from a marketing system, wherein the pricing mode is large industrial power consumption, the metering mode is low-supply low-count, the user name of the charging pile comprises charging pile user data of the charging pile or the equipment operation condition is in operation, the user name of the charging pile comprises charging pile user data of the charging pile, and the charging pile user data comprises a subordinate area of the charging pile, a subordinate power supply station of the charging pile, a user number of the charging pile, the user name of the charging pile, a grid-connected address of the charging pile, an access area name of the charging pile and a distribution transformer area user number of the charging pile.
Optionally, the method further comprises:
and the result presentation module is used for presenting the charging pile number and charging pile proportion information of the building with the subordinate district and subordinate power supply station dimension of the charging pile respectively and arranging the charging pile number and the charging pile proportion information in descending order with the charging pile number dimension.
According to the technical scheme, the resident building new energy automobile charging pile proportion analysis method and system provided by the invention have the following advantages:
the charging pile proportion analysis method for the residential building new energy automobile extracts building data and charging pile user data from a marketing system respectively, acquires GIS single line diagram data of a target area from a distribution network GIS management system, associates the building data, the GIS single line diagram data and the charging pile user data by taking a distribution transformer station area user number as a key field, and obtains the number of 0.4kV residential users and the number of charging pile users under each building, thereby calculating the charging pile proportion under each building. The technical problems of difficult guidance of the maintenance of the distribution network line and the safe and stable operation of the distribution network are solved.
The residential building new energy automobile charging pile proportion analysis system provided by the invention is used for executing the residential building new energy automobile charging pile proportion analysis method provided by the invention, and the obtained technical effect is the same as that of the residential building new energy automobile charging pile proportion analysis method provided by the invention, and the description is omitted here.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, it is obvious that the drawings in the following description are only some embodiments of the present invention, and for those skilled in the art, other related drawings can be obtained according to the drawings without creative efforts.
Fig. 1 is a schematic flow chart of a charging pile proportion analysis method for a residential building new energy automobile provided by the invention;
FIG. 2 is a logic architecture diagram of a residential building new energy vehicle charging pile percentage analysis method provided in the present invention;
fig. 3 is a charging pile proportion result presentation effect diagram of the residential building new energy automobile charging pile proportion analysis method provided by the invention;
fig. 4 is a schematic structural diagram of a charging pile proportion analysis system of a residential building new energy vehicle provided in the invention.
Detailed Description
In order to make the technical solutions of the present invention better understood, the technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
For convenience of understanding, please refer to fig. 1 and fig. 2, an embodiment of a charging pile percentage analysis method for a residential building new energy vehicle in the present invention includes:
step 101, acquiring resident user data from a marketing system, and constructing a 0.4kV resident user database, wherein the resident user data comprises a power utilization address.
It should be noted that in the embodiment of the present invention, a data interface is established with the distribution network marketing system, mass data of the marketing system is extracted, 0.4kV residential user data can be obtained, and a 0.4kV residential user database is constructed. Specifically, the rule for extracting the 0.4kV resident user data is as follows:
A. voltage class: 0.4kV (the upper-level power supply of 0.4kV is a 10kV line, and the voltage level extracted from the marketing system is 0.4kV, so that the resident users using the charging pile can be screened out);
B. the electricity utilization type: residents live;
C. the metering mode is as follows: low supply and low meter;
D. user types are as follows: a public transformer client;
E. non-square, shop, market.
And extracting the resident user data simultaneously meeting the 5 conditions as 0.4kV resident user data, and constructing a 0.4kV resident user database.
And 102, extracting the power utilization address from the 0.4kV residential user database, and classifying the residential user data according to the floor information in the power utilization address to obtain the floor data of each floor.
It should be noted that after 0.4kV resident user data is extracted, a user address is extracted from the 0.4kV resident user data, and the floors are classified according to the power utilization address, that is, the power utilization addresses belonging to the same floor are classified to obtain the floor data of each floor, and the floor data includes a distribution transformer subordinate district office, a distribution transformer subordinate power supply station, a floor name, a floor address, a user number, a user name, and a distribution transformer district user number. Specifically, after the electricity utilization address is extracted from the 0.4kV residential user database, provincial fields, city fields and district fields such as 'xx province', 'xx city' and 'xx district' in the electricity utilization address are removed. And then analyzing the electricity utilization addresses with the province field, the city field and the district field removed, classifying the electricity utilization addresses with the similarity of description of the electricity utilization addresses being more than 60% and the number of the screened users being more than 500 households into the same building, namely screening the electricity utilization addresses with the characters being more than 60% and the same after the province field, the city field and the district field are removed, and extracting the building name and the building address if the result obtained after screening indicates that the number of the users is more than 500 households (namely the electricity utilization addresses meeting the conditions after screening according to the conditions are more than 500). For example, if the power consumption address is "the site of the site.
After the building name and the building address are extracted, 0.4kV resident user data in each building are extracted by taking the building name and the building address as key fields, and then the building data of each building can be obtained: the distribution transformer slave area bureau, the distribution transformer slave power supply station, the building name, the building address, the user number, the user name and the distribution transformer station area user number. For example, a search word with the name of a building is searched in a 0.4kV residential user database, punctuation marks or blank characters are automatically removed from the search word, the intelligent search and classification of the electricity utilization address of the residential users of the affiliated power supply station are intelligently performed on the same power supply station building, and if the electricity utilization address of the residential users of the affiliated power supply station contains the name of the building, the residential users are classified as the same building. Such as: if a certain floor of the north Kau power supply station is named as the Piyu city garden, the power utilization addresses of all residential users of the north Kau power supply station are searched to contain the Piyu city garden and are classified as the same floor. The building address is used as a search word to search in a 0.4kV residential user database, punctuations or blank characters are automatically removed from the search word, the intelligent search and classification of the electricity utilization address of the residential user of the affiliated power supply station are intelligently performed on the same power supply station building address, and if the electricity utilization address of the residential user of the affiliated power supply station contains the building address, the residential user is classified as the same building. If the address of a certain floor of the power supply station of the north Kau is 'the No. 36 No. of the sky of the New City of east level', the power utilization addresses of all the residential users of the power supply station of the north Kau are searched to contain 'the No. 36 No. of the sky of the New City of east level', and the residential users are classified as the same floor.
And for the 0.4kV residential users newly increased every month, the new residential users can be placed into a new user pool, the new user pool is classified by the subordinate district and the power supply station, massive searching and matching are carried out according to the building names and the building addresses, and the 0.4kV residential users matched with the building names or the building addresses are automatically brought into the building.
103, acquiring GIS single line diagram data of a target area from a distribution network GIS management system, and constructing a distribution network GIS topological database, wherein the distribution network GIS topological database comprises distribution transformer names, distribution transformer area user numbers, distribution transformer subordinate 10kV lines, distribution transformer subordinate substations, distribution transformer subordinate power supply stations and distribution transformer subordinate area offices.
It should be noted that a data interface is established with a distribution network GIS management system, GIS single line diagram data of a target area is obtained, graph-mode conversion of the GIS single line diagram is performed, and a hierarchical structure topology of a regional office, a power supply station, a transformer substation, a 10kV line, and a distribution transformer can be obtained, so that a distribution network topology database including a distribution transformer name, a distribution transformer area user number, a distribution transformer subordinate 10kV line, a distribution transformer subordinate transformer substation, a distribution transformer subordinate power supply station, and a distribution transformer subordinate region office is constructed.
And 104, acquiring charging pile user data from the marketing system, wherein the charging pile user data comprises a subordinate district of the charging pile, a subordinate power supply station of the charging pile, a user number of the charging pile, a user name of the charging pile, a grid-connected address of the charging pile, an access district name of the charging pile and a distribution transformer district user number of the charging pile.
It should be noted that a data interface is established with the distribution network marketing system, and mass data of the marketing system is extracted, so that charging pile user data can be obtained. Specifically, the rule for extracting the charging pile user data is as follows:
a. and (3) access voltage class: 0.4kV (the upper-level power supply of 0.4kV is a 10kV line, and the charging pile can be screened out only when the voltage level extracted from the marketing system is 0.4 kV);
b. the pricing method comprises the following steps: large-scale industrial power utilization;
c. the metering mode is as follows: low supply and low meter;
d. the equipment operation condition is as follows: in operation;
e. the user name contains "charging post".
And if the data rows simultaneously satisfy a, b, c and e or simultaneously satisfy d and e in the above conditions, the data rows are defined as charging pile users. And then extracting charging pile user data which comprises a subordinate district office of the charging pile, a subordinate power supply station of the charging pile, a user number of the charging pile, a user name of the charging pile, a grid-connected address of the charging pile, an access transformer district name of the charging pile and a distribution transformer district user number of the charging pile.
And 105, associating the building data, the GIS single line diagram data and the charging pile user data by taking the distribution transformer area user number as a key field to obtain the number of 0.4kV resident users and the number of charging pile users under each building.
It should be noted that, by taking the user number of the distribution transformer area as a key field, correlation matching analysis is performed on the building data, the GIS single line diagram data and the charging pile user data, and the number of 0.4kV resident users and the number of charging pile users under each building can be obtained. Specifically, matching is performed between the distribution transformer area user number contained in the same floor and the distribution transformer area user number of the distribution network GIS topology database, for example, the name of the floor of a certain floor is "baoli weifeng garden", the address of the floor is "dong ping new city sky right road 36", the number of the distribution transformer area user numbers contained in the floor includes 4, and the numbers are respectively: 0306000057473518, 0306000057527433, 0306130001571804 and 0306130001571805, associating with the user numbers of the distribution transformer area in the distribution network GIS topology database, and if all the associations are successful, defining that the numbers of the 4 distribution transformer areas are all valid; if only 3 associations are successful, 3 station area numbers of the building are defined to be valid, invalid distribution and transformation station area numbers are removed, and the like. And after association, obtaining the topological structure of each building subordinate, including the district office, the power supply station, the transformer substation name, the 10kV line name and the distribution transformer name which are subordinate to all the distribution transformer district user numbers successfully associated. And combining the topological structure of each building slave, the building data of each building and the charging pile user data to obtain the number of 0.4kV resident users and the number of charging pile users under each building.
And 106, calculating the charging pile occupation ratio of each floor according to the number of 0.4kV resident users and the number of charging pile users of each floor.
It should be noted that, divide the electric pile number of users that fills under every building by the 0.4kV resident number of users under every building, can obtain the electric pile of filling under every building and account for the ratio, promptly:
wherein,Rthe charging pile for the building is in proportion,
the number of users of the charging pile of the building is,
the number of 0.4kV resident users in the building is shown.
The charging pile proportion analysis method for the residential building new energy automobile extracts building data and charging pile user data from a marketing system respectively, acquires GIS single line diagram data of a target area from a distribution network GIS management system, associates the building data, the GIS single line diagram data and the charging pile user data with distribution transformer station area user numbers as key fields, and obtains the number of 0.4kV residential users and the number of charging pile users under each building, so as to calculate the charging pile proportion under each building, compared with the traditional method of acquiring the number of charging piles by simply depending on the marketing system for analysis, the accuracy and reliability of proportion analysis results of the charging piles of the residential building are improved, the problem that the existing residential building new energy automobile is identified by only depending on the marketing system to acquire the number of the charging piles is solved, and the filling pile proportion condition and the proportion condition of the residential building cannot be accurately analyzed, the technical problems of difficult guidance of the maintenance of the distribution network line and the safe and stable operation of the distribution network are solved.
In one embodiment, after the charging pile occupation ratio under each floor is calculated according to the number of 0.4kV residential users and the number of charging pile users under each floor, the charging pile number and the charging pile occupation ratio information of the floors are presented by the subordinate district office and the subordinate power supply station of the charging pile respectively, and the charging pile number and the charging pile occupation ratio information are arranged in descending order according to the dimension of the charging pile number, and the presentation effect is shown in fig. 3.
For easy understanding, please refer to fig. 4, an embodiment of a charging pile percentage analysis system for a residential building new energy vehicle in the present invention includes:
the resident user data extraction module is used for acquiring resident user data from the marketing system and constructing a 0.4kV resident user database, wherein the resident user data comprises a power utilization address;
the system comprises a data acquisition module, a data processing module and a data processing module, wherein the data acquisition module is used for acquiring a power utilization address from a 0.4kV residential user database, classifying residential user data according to the data of the power utilization address to obtain the data of each building, and the data of the building comprises a distribution transformer subordinate area office, a distribution transformer subordinate power supply station, a building name, a building address, a user number, a user name and a distribution transformer area user number;
the distribution network GIS topological data acquisition module is used for acquiring GIS single line diagram data of a target area from a distribution network GIS management system and constructing a distribution network GIS topological database, wherein the distribution network GIS topological database comprises a distribution transformer name, a distribution transformer area user number, a distribution transformer subordinate 10kV line, a distribution transformer subordinate transformer substation, a distribution transformer subordinate power supply station and a distribution transformer subordinate area office;
the charging pile user number acquisition module is used for acquiring charging pile user data from the marketing system, wherein the charging pile user data comprises a subordinate district office of the charging pile, a subordinate power supply station of the charging pile, a user number of the charging pile, a user name of the charging pile, a grid-connected address of the charging pile, an access district name of the charging pile and a distribution transformer district user number of the charging pile;
the data association module is used for associating the building data, the GIS single line diagram data and the charging pile user data by taking the user number of the distribution transformer area as a key field to obtain the number of 0.4kV resident users and the number of charging pile users under each building;
and the charging pile occupation ratio analysis module is used for calculating the charging pile occupation ratio under each floor according to the number of 0.4kV residential users under each floor and the number of charging pile users.
The resident user data extraction module is specifically configured to:
the method comprises the steps of extracting resident user data of a non-square, a non-commercial shop and a non-commercial shop with the voltage grade of 0.4kV, the electricity consumption type of residential life, the metering mode of low supply and low metering and the user category of public transformer customers from a marketing system, extracting distribution transformer subordinate district bureau, distribution transformer subordinate power supply station, electricity consumption address, user number, user name and distribution transformer district user number of a resident user, and constructing a 0.4kV resident user database.
The building data extraction module is specifically used for:
extracting a power utilization address from a 0.4kV residential user database;
removing provincial fields, city fields and district fields in the power utilization addresses, describing the power utilization addresses with similarity of more than 60% and the number of users of more than 500 users after screening, and classifying the power utilization addresses as the same building;
extracting the name of the building from the electricity utilization address of the same building;
and matching the 0.4kV residential user database according to the building names to obtain the building data of each building, wherein the building data comprises distribution transformer subordinate district offices, distribution transformer subordinate power supply stations, building names, building addresses, user numbers, user names and distribution transformer station user numbers.
Fill electric pile user number acquisition module and specifically be used for:
the method comprises the steps of extracting the access voltage grade of 0.4kV from a marketing system, the pricing mode is large industrial power consumption, the metering mode is low-supply low-count, the user name comprises charging pile user data of a charging pile or the equipment operation condition is in operation, the user name comprises charging pile user data of the charging pile, and the charging pile user data comprises a subordinate district office of the charging pile, a subordinate power supply station of the charging pile, a user number of the charging pile, the user name of the charging pile, a grid-connected address of the charging pile, an access station area name of the charging pile and a distribution transformer station area user number of the charging pile.
Further comprising:
and the result presentation module is used for presenting the charging pile number and charging pile proportion information of the building with the subordinate district and subordinate power supply station dimension of the charging pile respectively and arranging the charging pile number and the charging pile proportion information in descending order with the charging pile number dimension.
The charging pile proportion analysis system of the residential building new energy automobile extracts building data and charging pile user data from a marketing system respectively, acquires GIS single line diagram data of a target area from a distribution network GIS management system, correlates the building data, the GIS single line diagram data and the charging pile user data by taking a distribution transformer area user number as a key field, and obtains the number of 0.4kV residential users and the number of charging pile users under each building, thereby calculating the charging pile proportion under each building. The technical problems of difficult guidance of the maintenance of the distribution network line and the safe and stable operation of the distribution network are solved.
The charging pile proportion analysis system for the residential building new energy automobile is used for executing the charging pile proportion analysis method for the residential building new energy automobile, the working principle and the obtained technical effect of the charging pile proportion analysis system are the same as those of the charging pile proportion analysis method for the residential building new energy automobile, and the description is omitted here.
The above-mentioned embodiments are only used for illustrating the technical solutions of the present invention, and not for limiting the same; although the present invention has been described in detail with reference to the foregoing embodiments, it will be understood by those of ordinary skill in the art that: the technical solutions described in the foregoing embodiments may still be modified, or some technical features may be equivalently replaced; and such modifications or substitutions do not depart from the spirit and scope of the corresponding technical solutions of the embodiments of the present invention.
Claims (10)
1. The utility model provides a resident building new energy automobile fills electric pile proportion analysis method which characterized in that includes:
acquiring resident user data from a marketing system, and constructing a 0.4kV resident user database, wherein the resident user data comprises a power utilization address;
extracting a power utilization address from a 0.4kV residential user database, classifying residential user data according to the floor information in the power utilization address to obtain the floor data of each floor, wherein the floor data comprises a distribution transformer subordinate district office, a distribution transformer subordinate power supply station, a floor name, a floor address, a user number, a user name and a distribution transformer district user number;
acquiring GIS single line diagram data of a target area from a distribution network GIS management system, and constructing a distribution network GIS topological database, wherein the distribution network GIS topological database comprises distribution transformer names, distribution transformer area user numbers, distribution transformer subordinate 10kV lines, distribution transformer subordinate substations, distribution transformer subordinate power supply stations and distribution transformer subordinate area stations;
acquiring charging pile user data from a marketing system, wherein the charging pile user data comprises a subordinate district of a charging pile, a subordinate power supply station of the charging pile, a user number of the charging pile, a user name of the charging pile, a grid-connected address of the charging pile, an access transformer district name of the charging pile and a distribution transformer district user number of the charging pile;
associating the building data, the GIS single line diagram data and the charging pile user data by taking the distribution transformer area user number as a key field to obtain the number of 0.4kV resident users and the number of charging pile users under each building;
and calculating the charging pile occupation ratio under each floor according to the number of 0.4kV resident users under each floor and the number of charging pile users.
2. The residential building new energy automobile charging pile proportion analysis method according to claim 1, wherein residential user data is obtained from a marketing system, a 0.4kV residential user database is constructed, wherein the residential user data comprises a power utilization address, and the method comprises the following steps:
the method comprises the steps of extracting resident user data of a non-square, a non-shop and a non-market, wherein the voltage grade is 0.4kV, the electricity utilization type is residential life, the metering mode is low supply and low metering, and the user category is public transformer customer, extracting distribution transformer subordinate district bureau, distribution transformer subordinate power supply station, electricity utilization address, user number, user name and distribution transformer district user number of a resident user, and constructing a 0.4kV resident user database.
3. The resident building new energy automobile charging pile proportion analysis method according to claim 2, wherein the step of extracting the electricity utilization address from the 0.4kV resident user database, classifying the resident user data according to the building information in the electricity utilization address to obtain the building data of each building comprises the following steps:
extracting a power utilization address from a 0.4kV residential user database;
removing provincial fields, city fields and district fields in the power utilization addresses, describing the power utilization addresses with similarity of more than 60% and the number of users of more than 500 users after screening, and classifying the power utilization addresses as the same building;
extracting the name of the building from the electricity utilization address of the same building;
and matching the 0.4kV residential user database according to the building name to obtain the building data of each building.
4. The residential building new energy automobile charging pile proportion analysis method according to claim 1, wherein the step of obtaining charging pile user data from a marketing system comprises the steps of:
the charging pile user data that the access voltage class is 0.4kV, the pricing mode is large industrial power consumption, the metering mode is low supply and low metering, the user name contains the charging pile or the device operation condition is in operation, and the user name contains the charging pile are extracted from the marketing system.
5. The residential building new energy automobile charging pile occupation ratio analysis method according to claim 1, wherein after calculating the charging pile occupation ratio under each building according to the number of 0.4kV residential users and the number of charging pile users under each building, the method further comprises the following steps:
the number of charging piles and the proportion information of the charging piles of the building are represented by the dimensions of the subordinate district bureau and the subordinate power supply station of the charging piles respectively, and the charging piles are arranged in descending order according to the number dimension of the charging piles.
6. The utility model provides a resident's building new energy automobile fills electric pile proportion analytic system, its characterized in that includes:
the resident user data extraction module is used for acquiring resident user data from the marketing system and constructing a 0.4kV resident user database, wherein the resident user data comprises a power utilization address;
the system comprises a data acquisition module, a data processing module and a data processing module, wherein the data acquisition module is used for acquiring a power utilization address from a 0.4kV residential user database, classifying residential user data according to the data of the power utilization address to obtain the data of each building, and the data of the building comprises a distribution transformer subordinate area office, a distribution transformer subordinate power supply station, a building name, a building address, a user number, a user name and a distribution transformer area user number;
the distribution network GIS topological data acquisition module is used for acquiring GIS single line diagram data of a target area from a distribution network GIS management system and constructing a distribution network GIS topological database, wherein the distribution network GIS topological database comprises a distribution transformer name, a distribution transformer area user number, a distribution transformer subordinate 10kV line, a distribution transformer subordinate transformer substation, a distribution transformer subordinate power supply station and a distribution transformer subordinate area office;
the charging pile user number acquisition module is used for acquiring charging pile user data from the marketing system, wherein the charging pile user data comprises a subordinate district office of the charging pile, a subordinate power supply station of the charging pile, a user number of the charging pile, a user name of the charging pile, a grid-connected address of the charging pile, an access district name of the charging pile and a distribution transformer district user number of the charging pile;
the data association module is used for associating the building data, the GIS single line diagram data and the charging pile user data by taking the user number of the distribution transformer area as a key field to obtain the number of 0.4kV resident users and the number of charging pile users under each building;
and the charging pile occupation ratio analysis module is used for calculating the charging pile occupation ratio under each floor according to the number of 0.4kV residential users under each floor and the number of charging pile users.
7. The residential building new energy automobile charging pile proportion analysis system according to claim 6, wherein the residential user data extraction module is specifically used for:
the method comprises the steps of extracting resident user data of a non-square, a non-commercial shop and a non-commercial shop with the voltage grade of 0.4kV, the electricity consumption type of residential life, the metering mode of low supply and low metering and the user category of public transformer customers from a marketing system, extracting distribution transformer subordinate district bureau, distribution transformer subordinate power supply station, electricity consumption address, user number, user name and distribution transformer district user number of a resident user, and constructing a 0.4kV resident user database.
8. The resident building new energy automobile charging pile proportion analysis system according to claim 7, wherein the building data extraction module is specifically configured to:
extracting a power utilization address from a 0.4kV residential user database;
removing provincial fields, city fields and district fields in the power utilization addresses, describing the power utilization addresses with similarity of more than 60% and the number of users of more than 500 users after screening, and classifying the power utilization addresses as the same building;
extracting the name of the building from the electricity utilization address of the same building;
and matching the 0.4kV residential user database according to the building names to obtain the building data of each building, wherein the building data comprises distribution transformer subordinate district offices, distribution transformer subordinate power supply stations, building names, building addresses, user numbers, user names and distribution transformer station user numbers.
9. The residential building new energy automobile charging pile proportion analysis system according to claim 6, wherein the charging pile user number acquisition module is specifically used for:
the method comprises the steps of extracting the access voltage grade of 0.4kV from a marketing system, wherein the pricing mode is large industrial power consumption, the metering mode is low-supply low-count, the user name of the charging pile comprises charging pile user data of the charging pile or the equipment operation condition is in operation, the user name of the charging pile comprises charging pile user data of the charging pile, and the charging pile user data comprises a subordinate area of the charging pile, a subordinate power supply station of the charging pile, a user number of the charging pile, the user name of the charging pile, a grid-connected address of the charging pile, an access area name of the charging pile and a distribution transformer area user number of the charging pile.
10. The resident building new energy automobile charging pile proportion analysis system according to claim 6, further comprising:
and the result presentation module is used for presenting the charging pile number and charging pile proportion information of the building with the subordinate district and subordinate power supply station dimension of the charging pile respectively and arranging the charging pile number and the charging pile proportion information in descending order with the charging pile number dimension.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210807516.1A CN114880424A (en) | 2022-07-11 | 2022-07-11 | Residential building new energy automobile charging pile proportion analysis method and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210807516.1A CN114880424A (en) | 2022-07-11 | 2022-07-11 | Residential building new energy automobile charging pile proportion analysis method and system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN114880424A true CN114880424A (en) | 2022-08-09 |
Family
ID=82683291
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202210807516.1A Pending CN114880424A (en) | 2022-07-11 | 2022-07-11 | Residential building new energy automobile charging pile proportion analysis method and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN114880424A (en) |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102708427A (en) * | 2012-06-29 | 2012-10-03 | 山东电力集团公司电力科学研究院 | System and method for analyzing and determining influence of large-scale charging pile to community distribution system |
| CN107169880A (en) * | 2017-05-16 | 2017-09-15 | 国网山东省电力公司临清市供电公司 | Platform is monitored in power grid user electricity consumption on-line |
| CN109903088A (en) * | 2019-02-18 | 2019-06-18 | 北京市天元网络技术股份有限公司 | A kind of broadband marketing strategy formulating method and system based on big data |
| CN110112828A (en) * | 2019-05-20 | 2019-08-09 | 北京恒信铭达科技有限公司 | A kind of green power utilization index number system generates and representation method and publication application system |
| CN110601240A (en) * | 2019-09-24 | 2019-12-20 | 广东电网有限责任公司 | Intelligent management and control method for power grid charging pile access |
| CN112614007A (en) * | 2020-11-30 | 2021-04-06 | 国网北京市电力公司 | Method and device for identifying charging potential cell |
-
2022
- 2022-07-11 CN CN202210807516.1A patent/CN114880424A/en active Pending
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102708427A (en) * | 2012-06-29 | 2012-10-03 | 山东电力集团公司电力科学研究院 | System and method for analyzing and determining influence of large-scale charging pile to community distribution system |
| CN107169880A (en) * | 2017-05-16 | 2017-09-15 | 国网山东省电力公司临清市供电公司 | Platform is monitored in power grid user electricity consumption on-line |
| CN109903088A (en) * | 2019-02-18 | 2019-06-18 | 北京市天元网络技术股份有限公司 | A kind of broadband marketing strategy formulating method and system based on big data |
| CN110112828A (en) * | 2019-05-20 | 2019-08-09 | 北京恒信铭达科技有限公司 | A kind of green power utilization index number system generates and representation method and publication application system |
| CN110601240A (en) * | 2019-09-24 | 2019-12-20 | 广东电网有限责任公司 | Intelligent management and control method for power grid charging pile access |
| CN112614007A (en) * | 2020-11-30 | 2021-04-06 | 国网北京市电力公司 | Method and device for identifying charging potential cell |
Non-Patent Citations (1)
| Title |
|---|
| 丁学鹏等: "新建住宅小区电动汽车充电桩配电设计", 《智能建筑电气技术》 * |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| WO2023115842A1 (en) | Data-driven offline and online integrated simulation system and method for power distribution network | |
| Schneider et al. | Modern grid initiative distribution taxonomy final report | |
| CN109286188B (en) | 10kV power distribution network theoretical line loss calculation method based on multi-source data set | |
| CN111160868A (en) | Unified distribution network frame topology construction method based on graph fusion technology | |
| CN106777150A (en) | A kind of cross-system data transfer device for merging operation of power networks environment and facility information | |
| CN109408960B (en) | Method and system for automatically generating intelligent transformer substation main wiring diagram based on SCD | |
| CN106886517A (en) | Business site selecting method, device and system | |
| CN106373032A (en) | Distribution network high-fault region identification method | |
| CN116340437A (en) | Multi-clustering method for large-scale multi-source heterogeneous data | |
| CN104881739B (en) | Data consistency verification method is matched somebody with somebody by a kind of battalion based on IEC61970/61968 CIM standards | |
| Ali et al. | Generating open-source datasets for power distribution network using openstreetmaps | |
| CN105654392A (en) | Familial defect analysis method of equipment based on clustering algorithm | |
| CN113902583A (en) | Distribution network side operation and maintenance method and system using low-voltage network equipment data | |
| CN113191409A (en) | Method for detecting abnormal electricity consumption behaviors of residents through tag data expansion and deep learning | |
| CN116841985A (en) | Method, system and device for building plant model topology | |
| CN112016174A (en) | Multi-source distribution network grid diagram-based user variable relationship checking method | |
| CN114880424A (en) | Residential building new energy automobile charging pile proportion analysis method and system | |
| CN109950974B (en) | Intelligent auxiliary device and method for planning charging pile | |
| CN116826709A (en) | Automatic matching method, device and storage medium for adjustable load resource and scheduling master station model | |
| CN116488335A (en) | Dynamic monitoring and allocation method, system and equipment for electric power consumption of urban scale | |
| Li et al. | Statistical identification of prototypical low voltage distribution feeders in Western Australia | |
| CN110601240B (en) | Intelligent management and control method for power grid charging pile access | |
| CN115392347A (en) | User phase relation identification method based on generation countermeasure network | |
| Broderick et al. | Clustering method and representative feeder selection for the California Solar Initiative | |
| Li et al. | Preliminary statistical study of low voltage distribution feeders under a representative HV network in Western Australia |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20220809 |
|
| RJ01 | Rejection of invention patent application after publication |