CN106227926B - Water meter based on water supply network model foundation tool ArcGIS quick and precisely adding method - Google Patents
Water meter based on water supply network model foundation tool ArcGIS quick and precisely adding method Download PDFInfo
- Publication number
- CN106227926B CN106227926B CN201610563278.9A CN201610563278A CN106227926B CN 106227926 B CN106227926 B CN 106227926B CN 201610563278 A CN201610563278 A CN 201610563278A CN 106227926 B CN106227926 B CN 106227926B
- Authority
- CN
- China
- Prior art keywords
- water meter
- water
- user
- arcgis
- station address
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F30/00—Computer-aided design [CAD]
- G06F30/10—Geometric CAD
- G06F30/13—Architectural design, e.g. computer-aided architectural design [CAAD] related to design of buildings, bridges, landscapes, production plants or roads
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F2111/00—Details relating to CAD techniques
- G06F2111/20—Configuration CAD, e.g. designing by assembling or positioning modules selected from libraries of predesigned modules
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F2113/00—Details relating to the application field
- G06F2113/14—Pipes
Abstract
Quick and precisely adding method belongs to municipal works pipe network information technical field to water meter based on water supply network model foundation tool ArcGIS.The present invention is not complete for water meter number information correspondence in Customs Assigned Number information and ArcGIS, the case where can not completely connecting, it include: Customs Assigned Number, corresponding water consumption per month, water meter name in an account book and station address according to the water meter information that Running-water Company's marketing charging system provides, by searching for water meter information in ArcGIS, quick and precisely to navigate to the position of water meter, then the permanent numbered entry by the editting function of ArcGIS system in the water meter attribute menu inputs corresponding permanent number, that is, completes the addition of this water meter.According to the information of target water meter water meter is accurately positioned, and be quickly added in ArcGIS database in this method.It is imported convenient for the batch of water meter water amount information, then carries out water and reasonably distribute.This method strong operability simultaneously, writes without carrying out complicated process.
Description
Technical field
The present invention relates to one kind based on building city water-supply pipe network model requirements, and user's water meter is added in ArcGIS tool
Quick and precisely method, belong to municipal works pipe network information technical field.
Background technique
With the rapid development of China's economic and the continuous improvement of people's living standard, the scale of Urbanization Construction is continuous
Expand, urban life daily water consumption is continuously increased.Water supply network is the important infrastructure in city, is responsible for that pressure and water will be met
The tap water that matter requires is delivered to each user, meets life and industrial water demand.And to reach cities and towns and guarantee both quality and quantity to supply water
Target, need to pipe network from be designed into construction controlled again to the whole life cycle of operation, with guarantee needed for water,
Hydraulic pressure and water quality.Therefore, there is an urgent need to a kind of tools for water supply network operating management department, can analyze the operating status of pipe network,
To carry out science decision.
Water supply network hydraulic model is one kind using computer software as technology platform, carrys out mould with the network that dotted line forms
Intend true pipe network system, the hydraulic parameter of each component part of pipe network is determined by solving pipe network Basic equation group, it can
It helps operational management personnel to understand the operating status of pipe network in varied situations in detail, can allow water supply network operating management department
Personnel manage the routine work of water supply network by model.With it is traditional main with artificial field observation, measurement, experience management
It compares, substantially increases the management level and service quality of water undertaking.
During hydraulic pipeline model foundation, the distribution of user's water is important work step and decision model
An important factor for accuracy.For larger hydraulic pipeline model, the association of the progress water in ArcGIS can be passed through
Distribution method.The water meter water amount information provided according to tap water group marketing charging system, passes through the water meter of ArcGIS software
The permanent number of water meter is carried out being correspondingly connected with one by one, then corresponding water by the associated tool of the water meter attribute list in figure layer
Also just it is associated with the water meter figure layer into ArcGIS.Then prototype software is imported by ArcGIS and the corresponding port of prototype software to carry out
The distribution of water, this method are capable of the operation of batch, and it is convenient to have, fast, accurate characteristic.
It is found during operation, the association of certain customers' water is not into ArcGIS water meter figure layer, the reason is that part is sought
User's water meter that pin system provides is not present in the water meter figure layer of ArcGIS, this part water can not just carry out leading for water
Enter.In response to this, it is necessary to which the location information of the user's water meter provided according to marketing is added to this part water meter
The water meter figure layer of ArcGIS forms the water meter figure layer of complete ArcGIS, be later hydraulic pipeline model modification when, water it is complete
Whole batch updating is laid a good foundation.This patent is related to one kind during water supply network model foundation, in modeling tool ArcGIS
The quick and precisely method of middle addition user's water meter.
Summary of the invention
Present invention aims at the marketing water meters generally occurred in the process for solution model water operation in ArcGIS water meter
Excalation in figure layer affects the efficiency that user's water data are automatically imported model, provides a kind of according to marketing system
The attribute information for user's water meter that system provides, the method for addition missing user's water meter in modeling tool ArcGIS.
Technical scheme is as follows:
1. quick and precisely adding method, feature exist a kind of water meter based on water supply network model foundation tool ArcGIS
In: during water supply network model foundation, according to the main users water meter information of Running-water Company's marketing charging system offer
It include: parent table number, corresponding water consumption per month, water meter name in an account book and station address；The position of water meter is navigated in generalized information system,
Then water meter is added at this by the water meter editting function of generalized information system, is inputted in the permanent numbered entry of the water meter attribute menu
Corresponding permanent number completes the positioning and addition of this water meter.
2. according to the quick and precisely side of addition of the water meter based on water supply network model foundation tool ArcGIS of claim 1
Method, specific step is as follows for the method:
(1) target water meter is filtered out；
User's water data information that marketing charging system provides is arranged first, is formed with parent table number, user
Title, station address, class of subscriber and user's water are the tables of data of main attribute information；ArcGIS tool software water meter figure
All water meters and attribute list in layer export as ' xls ' formatted data table of Excel；Then in Excel software, reference is common
' VLOOKUP ' function in function, cell to be retrieved are respectively set to the permanent number (LONGNO) of parent table number and water meter,
Then it is retrieved；The parent table number being not present in ArcGIS software water meter figure layer is filtered out by the method, as addition
Target water meter to ArcGIS software water meter figure layer is permanently numbered；
(2) target water meter is navigated to ArcGIS water meter figure layer；
Permanent number according to the parent table number screened as addition water meter, the water data attribute information filtered out
It further include numbering corresponding user's name, station address and user's water with parent table；For water meter determining in GIS water meter figure layer
Water meter, will be navigated to GIS pipe network system according to station address, user's name and parent table number information, to obtain water meter by position
Position；
(2.1) water meter is positioned by water meter station address first, the lookup tool frame of generalized information system is opened, the water meter
Station address is input to the lookup system of GIS, and seeking scope menu properties are arranged to ' geographical name lettering ' or ' road annotation ',
Then it is searched；After finding, clicking objective result in result information frame will be somebody's turn to do in the map of GIS pipe network system
The corresponding station address position of user's water meter；
(2.2) if the positioning of water meter is not implemented according to station address in step (2.1), need according to user's name into
The lookup system of user's name input GIS is searched in the positioning of row water meter, and seeking scope menu properties are arranged to ' place name
Annotation ', it is then searched, after finding, clicks objective result, navigate in the map of GIS pipe network system, and with combining user
Location carries out water meter positioning, finds the corresponding user location of user's water meter；
(2.3) if in above-mentioned steps (2.1) and (2.2) do not complete water meter positioning, need using it is existing
Line map tool is searched and located, and the search box that station address or user's name are input to existing Online Map is looked into
It looks for, after position determines, in conjunction with station address, then finds the corresponding position in GIS pipe network system map, that is, complete determining for water meter
Position；
(2.4) it if the accurate positionin of water meter is not implemented through the above steps, is carried out being numbered according to the parent table of user
Fuzzy query；There are certain relationships with water meter position for permanent number between the water meter figure layer of GIS, water meter；According to search
The adjacent water meter number of the water meter search the position of water meter, and station address and user's name is combined to carry out user's water meter
Positioning；Water meter number is made of 10 bit digitals, fuzzy query is carried out according to first 9 or preceding 8 bit digital, to determine corresponding water meter
Accurate location；First 9 of parent table number or the lookup systematic search frame of preceding 8 bit digital input GIS are searched, model is searched
It encloses and is arranged to ' permanent number ', searched；In lookup result, clicks and numbered with the most similar water meter of target water meter, clicked
It navigates in GIS pipe network system map, and combination station address and user's name carry out the positioning of user's water meter；
(3) by aforesaid operations step, if there is also the water meters that cannot be positioned on a small quantity, it is necessary to organization work people
Member carries out site inspection and determination according to user's water meter attribute information that marketing system provides；According to user's water meter of return
Location information, then pass through step (2.1), the final position for determining water meter；
(4) water meter is added to ArcGIS water meter figure layer
User's water meter is added to ArcGIS water meter figure layer after positioning is completed in user's water meter position by above-mentioned steps；Water
The positioning of table only has found corresponding station address position, according to model to the needs of water operation, finally by water standard
When being really assigned on corresponding pipeline, therefore adding water meter, it should be added to and be connect on nearest pipeline with user's water meter or pipeline
Near；For a user, water quantity balance is family pipe, tap line, main line pipeline are connected to water factory, correct in order to guarantee
Connection relationship, water meter should be added in the nearest tap line being connected with user；Pipe is accurately found according to above-mentioned requirements
After line, water meter is added in looked for position；In GIS tool, water meter is added by water meter editting function, opens the water meter
Attribute menu ' is editing permanent volume of the parent table number of input user as water meter in input frame behind permanent number ' menu bar
Number, that is, complete the addition of the water meter；
(5) pass through aforesaid operations step, the target water meter screened is compiled according to station address, user's name and parent table
It number is accurately positioned and is added in GIS pipe network system water meter figure layer, realize the water meter in ArcGIS and quick and precisely add.
Water meter figure layer completely corresponding with user's water data is formed in ArcGIS, in order to subsequent, user
Water is completely imported in prototype software by ArcGIS tool.
Quick and precisely adding method has for water meter of the present invention based on water supply network model foundation tool ArcGIS
Beneficial effect is mainly reflected in:
Using method of the present invention, the quick and precisely method of user's water meter, energy are added in modeling tool ArcGIS
The enough main users water meter information provided according to marketing system realizes that user's water meter fast and accurately positions and adds in ArcGIS
Add, is associated with corresponding water convenient for subsequent number according to water meter, imports water accurately in prototype software.This method is entire pipe
The water mass distributed of net provides condition, finally improves the efficiency of establishing of entire pipe net leakage rate, more subsequent entire pipe network
The update of model data is provided convenience condition.Meanwhile the method for the invention has operability, it only need to be by Excel work
Each step can be completed in tool and GIS platform, easy to accomplish, and ensure that this method can real-time.
Detailed description of the invention
Fig. 1 is a kind of water meter based on water supply network model foundation tool ArcGIS system of the present invention quick and precisely side of addition
The flow diagram of method.
Specific embodiment
A kind of water meter based on water supply network model foundation tool ArcGIS system of the invention quick and precisely adding method,
It is as shown in Figure 1 that process is embodied, the specific steps are as follows:
1. user's water data information that marketing charging system provides is arranged first, is formed with parent table number, used
Name in an account book, station address, class of subscriber and user's water are referred to as the tables of data of main attribute information.Then, pass through Excel software
' VLOOKUP ' function filters out the parent table number being not present in ArcGIS software water meter figure layer.
2. permanently being numbered according to the water meter that marketing charging system provides, user's name and station address navigate to water meter
Water meter is added to pipe network GIS system by the water meter editing machine function of GIS by GIS pipe network system.
3. positioning water meter by water meter station address, the lookup tool frame of generalized information system is opened, the station address of the water meter
It is input to the lookup system of GIS, and seeking scope menu properties are arranged to ' geographical name lettering ' or ' road annotation ', then carry out
It searches.After finding, target position will be occurred in the map of GIS pipe network system by clicking objective result in result information frame.
4. if user's name is needed to input looking into for GIS the positioning of water meter is not implemented according to station address in step 3
System is looked for be searched, seeking scope menu properties are arranged to ' geographical name lettering ', are then searched, position user's water meter.
If 5. in above-mentioned steps 3 and 4 do not complete water meter positioning, need using existing Online Map tool into
Row searchs and locates, and the search box that station address is input to existing Online Map is searched, and after position determines, then finds
Corresponding position in GIS pipe network system map completes the positioning of water meter.
6. if will be obscured according to the parent table of user number the accurate positionin of water meter is not implemented through the above steps
Inquiry.Water meter number is made of 10 bit digitals, fuzzy query can be carried out according to first 9 or preceding 8 bit digital, to determine corresponding water meter
Accurate location.First 9 of parent table number or the lookup systematic search frame of preceding 8 bit digital input GIS are searched, model is searched
It encloses and is arranged to ' permanent number ', searched, position user's water meter.
7. through the above steps, if there is also the water meters that cannot be positioned on a small quantity, it is necessary to which organization work personnel carry out
Site inspection and determination.According to the information of return, then pass through aforesaid operations step, the final position for determining water meter.
8. passing through above-mentioned steps, after positioning is completed in user's water meter position, user's water meter will be added to ArcGIS water meter figure
Layer.The positioning of water meter only has found corresponding station address position, according to model to the needs of water operation, finally by water
When being accurately assigned on corresponding pipeline, therefore adding water meter, it should be added to and connect on nearest pipeline or manage with user's water meter
Near line.After accurately finding pipeline according to above-mentioned requirements, water meter is added in target position.In GIS tool, pass through water meter
Editting function adds water meter, and opens the attribute menu of the water meter, ' is editing in input frame behind permanent number ' menu bar defeated
The parent table of access customer numbers the permanent number as water meter, that is, completes the addition of the water meter.
By aforesaid operations, fast and accurately addition of the target water meter in ArcGIS is completed, complete water meter figure is formed
Layer.
Claims (1)
1. a kind of water meter based on water supply network model foundation tool ArcGIS quick and precisely adding method, it is characterised in that:
During water supply network model foundation, include: according to the main users water meter information that Running-water Company's marketing charging system provides
Parent table number, corresponding water consumption per month, water meter name in an account book and station address；The position that water meter is navigated in generalized information system, then leads to
The water meter editting function for crossing generalized information system adds water meter at this, corresponding in the permanent numbered entry input of the water meter attribute menu
Permanent number, that is, complete the positioning and addition of this water meter；
Specific step is as follows:
(1) target water meter is filtered out；
First marketing charging system provide user's water data information arrange, formed with parent table number, user's name,
Station address, class of subscriber and user's water are the tables of data of main attribute information；In ArcGIS tool software water meter figure layer
All water meters and attribute list export as ' xls ' formatted data table of Excel；Then in Excel software, common mathematical function is quoted
In ' VLOOKUP ' function, cell to be retrieved be respectively set to parent table number and water meter permanent number, then examined
Rope；The parent table number being not present in ArcGIS software water meter figure layer is filtered out by the method, it is soft as ArcGIS is added to
The target water meter of part water meter figure layer is permanently numbered；
(2) target water meter is navigated to ArcGIS water meter figure layer；
Permanent number according to the parent table number screened as addition water meter, the water data attribute information filtered out also wrap
It includes and numbers corresponding user's name, station address and user's water with parent table；For water meter GIS water meter figure layer positioning,
Water meter is navigated to GIS pipe network system according to station address, user's name and parent table number information, to obtain the position of water meter
It sets；
(2.1) water meter is positioned by water meter station address first, the lookup tool frame of generalized information system is opened, the user of the water meter
Address is input to the lookup system of GIS, and seeking scope menu properties are arranged to ' geographical name lettering ' or ' road annotation ', then
It is searched；After finding, the user will be occurred in the map of GIS pipe network system by clicking objective result in result information frame
The corresponding station address position of water meter；
(2.2) it if the positioning of water meter is not implemented according to station address in step (2.1), needs to carry out water according to user's name
The lookup system of user's name input GIS is searched in the positioning of table, and seeking scope menu properties are arranged to ' place name note
Note ', it is then searched, after finding, clicks objective result, navigate in the map of GIS pipe network system, and combine station address
Water meter positioning is carried out, the corresponding user location of user's water meter is found；
(2.3) if in above-mentioned steps (2.1) and (2.2) do not complete water meter positioning, need using it is existing online
Figure tool is searched and located, and the search box that station address or user's name are input to existing Online Map is searched,
After position determines, in conjunction with station address, then the corresponding position in GIS pipe network system map is found, that is, completes the positioning of water meter；
(2.4) it if the accurate positionin of water meter is not implemented through the above steps, will be obscured according to the parent table of user number
Inquiry；There are certain relationships with water meter position for permanent number between the water meter figure layer of GIS, water meter；According to the search water
The adjacent water meter number of table search the position of water meter, and station address and user's name is combined to carry out determining for user's water meter
Position；Water meter number is made of 10 bit digitals, fuzzy query is carried out according to first 9 or preceding 8 bit digital, to determine the standard of corresponding water meter
True position；First 9 of parent table number or the lookup systematic search frame of preceding 8 bit digital input GIS are searched, seeking scope is set
It is set to ' permanent number ', is searched；In lookup result, clicks and numbered with the most similar water meter of target water meter, click positioning
Into GIS pipe network system map, and combination station address and user's name carry out the positioning of user's water meter；
(3) through the above steps, if there is also the water meters that cannot be positioned on a small quantity, it is necessary to organization work personnel, according to battalion
User's water meter attribute information that pin system provides carries out site inspection and determination；According to the location information of user's water meter of return,
Pass through step (2.1), the final position for determining water meter again；
(4) water meter is added to ArcGIS water meter figure layer
User's water meter is added to ArcGIS water meter figure layer after positioning is completed in user's water meter position by above-mentioned steps；Water meter
Positioning only has found corresponding station address position and finally accurately divides water according to model to the needs of water operation
When being fitted on corresponding pipeline, therefore adding water meter, it should be added to and be connect on nearest pipeline or near pipeline with user's water meter；
For a user, water quantity balance is family pipe, tap line, main line pipeline are connected to water factory, in order to guarantee correctly to connect
Relationship is connect, water meter should be added in the nearest tap line being connected with user；After accurately finding pipeline according to above-mentioned requirements,
Water meter is added in looked for position；In GIS tool, water meter is added by water meter editting function, opens the attribute of the water meter
Menu, ' parent table of editor's input user numbers the permanent number as water meter in input frame behind permanent number ' menu bar,
Complete the addition of the water meter；
(5) pass through aforesaid operations step, the target water meter screened is numbered standard according to station address, user's name and parent table
It determines position and is added in GIS pipe network system water meter figure layer, realize the water meter in ArcGIS and quick and precisely add.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610563278.9A CN106227926B (en) | 2016-07-16 | 2016-07-16 | Water meter based on water supply network model foundation tool ArcGIS quick and precisely adding method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610563278.9A CN106227926B (en) | 2016-07-16 | 2016-07-16 | Water meter based on water supply network model foundation tool ArcGIS quick and precisely adding method |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN106227926A CN106227926A (en) | 2016-12-14 |
| CN106227926B true CN106227926B (en) | 2019-07-12 |
Family
ID=57519865
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201610563278.9A Active CN106227926B (en) | 2016-07-16 | 2016-07-16 | Water meter based on water supply network model foundation tool ArcGIS quick and precisely adding method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106227926B (en) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112434393B (en) * | 2020-11-25 | 2024-01-05 | 北京工业大学 | Marketing water meter positioning method using hundred-degree map API and ArcGIS |
Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105243509A (en) * | 2015-10-30 | 2016-01-13 | 成都兴联宜科技有限公司 | Intelligent water affair system for smart city |
-
2016
- 2016-07-16 CN CN201610563278.9A patent/CN106227926B/en active Active
Patent Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105243509A (en) * | 2015-10-30 | 2016-01-13 | 成都兴联宜科技有限公司 | Intelligent water affair system for smart city |
Non-Patent Citations (3)
| Title |
|---|
| 佛山市供水管网水力模型升级实践;吴迪;《城镇供水》;20130622;正文第2-3节 |
| 基于GIS的城市供水管网信息系统的研究与应用;胡晓磬;《中国优秀硕士学位论文全文数据库 工程科技Ⅱ辑》;20130315;第4.4节，图4-4 |
| 给水管网建模信息采集与数据处理;包涵等;《中国给水排水》;20111130;第27卷(第22期);第11-14页 |
Also Published As
| Publication number | Publication date |
|---|---|
| CN106227926A (en) | 2016-12-14 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN105022769B (en) | A kind of City Underground Pipeline interactive system and its method | |
| CN105117573B (en) | Auto hydraulic model building method based on CAD drainage pipeline networks drawing informations | |
| CN111382484B (en) | Building pipeline arrangement optimization system based on BIM | |
| CN106407540B (en) | A kind of underground utilities auxiliary programming checking method based on three-dimension GIS technology | |
| CN109784746A (en) | Urban-rural water supply network waterpower simulation of water quality platform | |
| CN107194621A (en) | A kind of Water supply network system and method | |
| CN106874532A (en) | A kind of grid method for analyzing cartridge igniter | |
| CN112258159B (en) | BIM + GIS-based hydraulic structure management system and method | |
| CN112132327A (en) | Multi-source data fusion-oriented intelligent planning system for power distribution network | |
| CN102147830A (en) | Method and system for optimally designing water supply pipe network | |
| CN106294572A (en) | A kind of elevation map rapid generation based on AutoCAD data source and ArcGIS instrument | |
| CN113204329A (en) | Control method for driving business application by unified data model and application system thereof | |
| CN106202762B (en) | A kind of user's water data based on ArcGIS tool are automatically imported modeling software method | |
| CN109886506A (en) | A kind of water supply network booster risk analysis method | |
| CN105574675A (en) | Rule bank-based method and system for planning and supervising constructional engineering | |
| CN115685787A (en) | Modeling simulation method, modeling simulation system and medium for urban gas pipe network | |
| CN112050092A (en) | Water supply pipe network leakage information management system, building method and application | |
| CN110378620B (en) | Low-impact development design and evaluation method and system | |
| Dou et al. | Tracking the research on ten emerging digital technologies in the AECO industry | |
| CN106227926B (en) | Water meter based on water supply network model foundation tool ArcGIS quick and precisely adding method | |
| Liao et al. | River environmental decision support system development for Suzhou Creek in Shanghai | |
| CN116011157A (en) | Automatic desk CAD and Revit secondary development-based pipeline rapid extraction modeling method | |
| CN115964875A (en) | Digital twin water network tetrahedral model construction method | |
| CN115641407A (en) | Three-dimensional pipe network incremental updating modeling method and device, storage medium and electronic equipment | |
| Gu et al. | Designing a water resources management decision support system: an application of the WSR approach |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | 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 |