CN103927362A - Urban pipe line detection data fast mapping method and system based on GIS platform - Google Patents
Urban pipe line detection data fast mapping method and system based on GIS platform Download PDFInfo
- Publication number
- CN103927362A CN103927362A CN201410158680.XA CN201410158680A CN103927362A CN 103927362 A CN103927362 A CN 103927362A CN 201410158680 A CN201410158680 A CN 201410158680A CN 103927362 A CN103927362 A CN 103927362A
- Authority
- CN
- China
- Prior art keywords
- pipeline
- point
- pipe
- pipe point
- module
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/29—Geographical information databases
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Remote Sensing (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
- Processing Or Creating Images (AREA)
Abstract
The invention discloses an urban pipe line detection data fast mapping method and system based on a GIS platform. The method includes the steps that pipe line starting point and ending point coordinate fields are added, and value assignment is carried out on pipe line starting point and ending point coordinates; starting point and ending point coordinate information of pipe lines is directly read during pipe line mapping by carrying out value assignment on all endpoint spatial positions needed by the pipe lines so that the repeated operation of reading the pipe point coordinate information through the relation between the pipe lines and pipe points during mapping can be avoided; pipe line list mapping is carried out, wherein a pipe line list is read and traversed, the pipe lines are drawn, and pipe line attributes are read and assigned to pipe line elements; pipe point list mapping is carried out, wherein a pipe point list is read and traversed, pipe points are drawn according to point coordinate information, and pipe point attributes are read and assigned to pipe point elements; mapping is finished. According to the method, more work is completed before pipe line mapping on the basis that the pipe line mapping principle is understood, so that frequent database reading operation is simplified in the mapping process, especially for mapping with a large data volume.
Description
Technical field
The present invention relates to a kind of Detecting and surveying underground pipelines and cables in city data quick mapping method and system based on GIS platform.
Background technology
When carrying out pipeline one-tenth figure by detection data (tentation data is through checking, and modification is correct), traditional drawing methods comprises several as follows substantially, and overall operation efficiency is basically identical.Aggregate analysis is as follows:
Tradition becomes figure mode one: as shown in Figure 1, first will manage some telogenesis figure: by traversal, manage some tables of data, read pipe point coordinate information and draw pipe point, give pipe point attribute information simultaneously; Then pipeline telogenesis figure: temporarily build table according to pipeline and the statement of the Attribute Association of pipe point, and obtain the coordinate of the initial sum terminating point of pipeline, then according to the coordinate information of pipeline starting point and ending point (being two end points of line segment), carry out rendering pipeline, give pipeline attribute information simultaneously.
Tradition becomes figure mode two: as shown in Figure 2, and pipeline telogenesis figure first: build table according to pipeline and the statement of the Attribute Association of pipe point temporarily, and obtain the coordinate of the initial sum terminating point of pipeline; Then manage some telogenesis figure: according to the coordinate information of pipeline starting point and ending point (being two end points of line segment), carry out rendering pipeline, and give pipeline attribute information.Then read pipe point table, traversal pipe point tables of data, reads pipe point coordinate information and draws pipe point, gives pipe point attribute information simultaneously.
Above two kinds of traditional pipeline detection data drawing methods, though difference to some extent, execution efficiency is low.
Tradition becomes figure mode three: as shown in Figure 3, first in pipeline telogenesis figure, sentence builder temporary table according to pipeline with the Attribute Association of pipe point, and obtain the coordinate of the initial sum terminating point of pipeline, then according to the coordinate information of pipeline starting point and ending point (being two end points of line segment), carry out rendering pipeline, and give pipeline attribute information.Meanwhile, when pipe point table is read in association, pipe is put into figure.But because adjacent lines (as the i.e. pipe points of three pipeline Share interlinkages of threeway) is shared the cause of same connecting pipe point, for avoiding repeating put into figure, need to do a pipe and cushion, judge whether one-tenth figure of this pipe point.This optimization method, has improved the number of times that data read, but has increased condition judgment number of times.
Above three kinds of tradition become figure mode, the operation that all exists a large amount of incidence relations that passes through pipeline and pipe point to read pipe point coordinate, and this operation expends time in very much, affects execution efficiency.
Suppose that pipe point table is N bar, pipeline table is M bar.So, the number of times that database reads is:
1) pipe is put into figure and is traveled through once, reads N time;
2) pipeline becomes figure traversal once, reads M time, and each pipeline packet is containing two points simultaneously, need to be from pipe point table correlation inquiry read the coordinate informations of these two pipes; Correlation inquiry at least M time; Database reads M+M*N*2 time;
Amount to: M+M*N*2+N secondary data storehouse read operation at least; Correlation inquiry operates at least M time.Database attended operation is disregarded.
To sum up analyze, find traditional pipeline become the bottleneck of figure be more by time waste on the correlation inquiry and database read extract operation of database.
Summary of the invention
Object of the present invention is exactly in order to address the above problem, a kind of Detecting and surveying underground pipelines and cables in city data quick mapping method and system based on GIS platform are provided, it has overcome technology prejudice, for whole mapping process, become on the basis of figure principle understanding pipeline, break the immotile prejudice of raw data, to more be operated in before pipeline becomes figure and complete, thereby be reduced in mapping process, the read operation of database, especially becomes figure for big data quantity frequently.
To achieve these goals, the present invention adopts following technical scheme:
Detecting and surveying underground pipelines and cables in city data quick mapping method based on GIS platform, comprises the steps:
First, loading city pipeline detection data, described Detecting and surveying underground pipelines and cables in city data comprise pipeline table and pipe point table; In pipeline table, increase pipeline terminal coordinate fields, for pipeline terminal coordinate shifts to an earlier date assignment, described assignment refers to gives the end points spatial positional information that pipeline needs, and when pipeline becomes figure, directly reads the pipeline terminal coordinate information shifting to an earlier date after assignment;
Then, at the enterprising line pipe line of GIS platform telogenesis figure: read pipeline table, traversal pipeline table, according to terminal coordinate information rendering pipeline, reads pipeline attribute and give pipeline key element;
The 3rd, at the enterprising line pipe point telogenesis of GIS platform figure: read pipe point table, traversal pipe point table, draws pipe point according to point coordinate information; Read pipe point attribute and give pipe point key element;
Finally, preserve into figure result, become figure to finish.
Detecting and surveying underground pipelines and cables in city data quick mapping method based on GIS platform, comprises the steps:
First, loading city pipeline detection data, described Detecting and surveying underground pipelines and cables in city data comprise pipeline table and pipe point table; In pipeline table, increase pipeline terminal coordinate fields, for pipeline terminal coordinate shifts to an earlier date assignment, described assignment refers to gives the end points spatial positional information that pipeline needs, and when pipeline becomes figure, directly reads the pipeline terminal coordinate information shifting to an earlier date after assignment;
Then, at the enterprising line pipe point telogenesis of GIS platform figure: read pipe point table, traversal pipe point table, draws pipe point according to point coordinate information; Read pipe point attribute and give pipe point key element;
The 3rd, at the enterprising line pipe line of GIS platform telogenesis figure: read pipeline table, traversal pipeline table, according to terminal coordinate information rendering pipeline, reads pipeline attribute and give pipeline key element;
Finally, preserve into figure result, become figure to finish.
Described is according to the incidence relation of pipeline table in Detecting and surveying underground pipelines and cables in city data and pipe point table for pipeline terminal coordinate shifts to an earlier date assignment, in pipeline table, is the pipeline terminal coordinate fields assignment increasing.
Described on GIS platform the concrete steps of pipeline telogenesis figure be:
Step (1a-1): read pipeline table in pipeline detection data, in geographical data bank, create pipeline factor kind by GIS platform, and the field information of pipeline factor kind is set according to the pipeline table structure of pipeline detection data.
Step (1a-2): read detection data pipeline table, traversal pipeline table, according to terminal coordinate information rendering pipeline key element in pipeline factor kind;
Step (1a-3): read detection data pipeline attribute, and give in attribute field value corresponding to pipeline key element;
Circulation step (1a-2)-(1a-3), until each record in pipeline table is all generated in pipeline factor kind, and preserve.
Described concrete steps of managing some telogenesis figure on GIS platform are:
Step (1b-1): read pipe point table, in geographical data bank, create pipe point factor kind, and the field information of pipe point factor kind is set according to the pipe point list structure of pipeline detection data;
Step (1b-2): read detection data pipe point table, traversal point table, draws pipe point key element according to point coordinate information;
Step (1b-3): read pipe point attribute and give pipe point key element;
Complete and create after pipe point geometry object, read the attribute information in pipe point detection table, and assignment is in corresponding pipe point factor kind database;
Circulation step (1b-2)-(1b-3), until each record in pipe point table is all generated to pipe space of points database, and preserve.
In pipeline table, increase pipeline terminal coordinate fields and refer to increase " starting point X coordinate ", " starting point Y coordinate ", " terminating point X coordinate ", " terminating point Y coordinate " totally four fields.
According to the incidence relation of pipeline table in Detecting and surveying underground pipelines and cables in city data and pipe point table, in pipeline table, be newly-increased four field assignment of " starting point X coordinate ", " starting point Y coordinate ", " terminating point X coordinate ", " terminating point Y coordinate ".
Described incidence relation is the period of storage tube line endpoints in pipeline table and relation corresponding to pipe point numbering in pipe point table.
The described pipeline table that reads, traversal pipeline table, rendering pipeline, the step that reads pipeline attribute and give pipeline key element is:
Read pipeline table, by traversal pipeline tables of data record, obtain the terminal coordinate of this pipeline, by calling the api interface of GIS platform, according to volume coordinate information, create geometric object, rendering pipeline geometric figure, and pipeline attribute information is given in attribute information corresponding to pipeline key element.
Read pipe point table, traversal pipe point table, draws pipe point according to point coordinate information; The step that reads pipe point attribute and give pipe point key element is:
Read pipe point table, by traversal, manage some data table records, obtain the point coordinate information of this pipe point, by calling the api interface of GIS platform, according to volume coordinate information, create geometric object, draw pipe point geometry figure, and pipe point attribute information is given in attribute information corresponding to pipe point key element.
Detecting and surveying underground pipelines and cables in city data quick mapping system based on GIS platform, comprising:
The module of loading city pipeline detection data, described Detecting and surveying underground pipelines and cables in city data comprise pipeline table and pipe point table; In pipeline table, increase the module of pipeline terminal coordinate fields, for pipeline terminal coordinate shifts to an earlier date the module of assignment, described assignment refers to gives the end points spatial positional information that pipeline needs, and for when pipeline becomes figure, directly reads the pipeline terminal coordinate information shifting to an earlier date after assignment;
The module of pipeline telogenesis figure on GIS platform: read pipeline table, traversal pipeline table, rendering pipeline, reads pipeline attribute and gives the module of pipeline key element;
The module of pipe point telogenesis figure on GIS platform: read pipe point table, traversal pipe point table, draws pipe point according to point coordinate information; Read pipe point attribute and give the module of managing some key element;
Preserve into the module of figure result.
Detecting and surveying underground pipelines and cables in city data quick mapping system based on GIS platform, comprising:
The module of loading city pipeline detection data, described Detecting and surveying underground pipelines and cables in city data comprise pipeline table and pipe point table; In pipeline table, increase the module of pipeline terminal coordinate fields, for pipeline terminal coordinate shifts to an earlier date the module of assignment, described assignment refers to gives the end points spatial positional information that pipeline needs, and for when pipeline becomes figure, directly reads the pipeline terminal coordinate information shifting to an earlier date after assignment;
The module of pipe point telogenesis figure on GIS platform: read pipe point table, traversal pipe point table, the module of drawing pipe point according to point coordinate information; Read pipe point attribute and give the module of managing some key element;
The module of pipeline telogenesis figure on GIS platform: read pipeline table, traversal pipeline table, the module of rendering pipeline, reads pipeline attribute and gives the module of pipeline key element;
Preserve into the module of figure result.
The described module that shifts to an earlier date assignment for pipeline terminal coordinate is according to an incidence relation for pipeline table in Detecting and surveying underground pipelines and cables in city data and pipe point table, in pipeline table, is the pipeline terminal coordinate fields assignment increasing.
Described on GIS platform the module of pipeline telogenesis figure, comprising:
Read the module of pipeline table in pipeline detection data, by GIS platform, in geographical data bank, create pipeline factor kind, and the module of the field information of pipeline factor kind is set according to the pipeline table structure of pipeline detection data.
Read the module of detection data pipeline table, traversal pipeline table, the module of rendering pipeline key element in pipeline factor kind;
Read the module of detection data pipeline attribute, and give the module in attribute field value corresponding to pipeline key element;
Circulation step (1a-2)-(1a-3), until each record in pipeline table is all generated in pipeline factor kind, and the module of preserving.
Described module of managing some telogenesis figure on GIS platform, comprising:
Read the module of pipe point table, in geographical data bank, create pipe point factor kind, and the module of the field information of pipe point factor kind is set according to the pipe point list structure of pipeline detection data;
Read detection data pipe point table, traversal point table, draws the module of managing some key element according to point coordinate information;
Read pipe point attribute and give the module of managing some key element;
Complete and create after pipe point geometry object, read the attribute information in pipe point detection table, and assignment is to the module in corresponding pipe point factor kind database;
Circulation step (1b-2)-(1b-3), until each record in pipe point table is all generated to pipe space of points database, and the module of preserving.
The module that increases pipeline terminal coordinate fields in pipeline table refers to increase " starting point X coordinate ", " starting point Y coordinate ", " terminating point X coordinate ", " the terminating point Y coordinate " module of totally four fields.
According to the incidence relation of pipeline table in Detecting and surveying underground pipelines and cables in city data and pipe point table, in pipeline table, be newly-increased four field assignment of " starting point X coordinate ", " starting point Y coordinate ", " terminating point X coordinate ", " terminating point Y coordinate ".
Described incidence relation is the period of storage tube line endpoints in pipeline table and relation corresponding to pipe point numbering in pipe point table.
The described pipeline table that reads, traversal pipeline table, rendering pipeline, the module that reads pipeline attribute and give pipeline key element comprises:
Read the module of pipeline table, by traversal pipeline tables of data record, obtain the module of the terminal coordinate of this pipeline, by calling the api interface of GIS platform, according to volume coordinate information, create geometric object, the geometric module of rendering pipeline, and the module of pipeline attribute being given to pipeline key element.
The described pipe point table that reads, traversal pipe point table, draws pipe point according to point coordinate information; The module that reads pipe point attribute and give pipe point key element comprises:
Read the module of pipe point table, by traversal, manage some data table records, obtain the module of the point coordinate information of this pipe point, by calling the api interface of GIS platform, according to volume coordinate information, create geometric object, draw the module of pipe point geometry figure, and the module of pipe point attribute being given to pipe point key element.
Beneficial effect of the present invention:
The present invention proposes a kind of drawing methods of pipeline more fast, broken traditional mode of thinking, before being more operated in real one-tenth figure, complete, thereby simplify mapping process, reduce database read extract operation frequently.Main manifestations is as follows:
In original Detecting and surveying underground pipelines and cables in city database, what in line table, only store is the attribute information of pipeline and the incidence relation of putting with pipe, according to common one-tenth figure operation flow, when pipeline becomes figure, first the incidence relation by pipeline and pipe point (be the initial period in pipeline database table and stop period and the pipe point of pipe point in showing numbered corresponding), pass through correlation inquiry, obtain the coordinate information (i.e. " starting point X coordinate " of the pipe point being connected with this pipeline, " starting point Y coordinate ", " terminating point X coordinate ", " terminating point Y coordinate "), then by the api interface of GIS platform, create pipeline geometric object, and by the attribute assignment of pipeline detection data to pipeline geometric object.In this course, find pipeline of every one-tenth figure, just need the once correlation inquiry of two tables, in the situation that Detecting and surveying underground pipelines and cables in city quantity database level is higher, company's table inquiry of two large orders of magnitude, it is consuming time is very huge, adds that pipeline data volume own is large simultaneously, will certainly become the efficiency of figure greatly to reduce to whole pipeline.
And the present invention has fully dissected the essence that Detecting and surveying underground pipelines and cables in city data become figure, become figure elapsed time the best part to be fully reduced to zero pipeline, accelerated greatly the one-tenth figure efficiency of Detecting and surveying underground pipelines and cables in city data.Make a concrete analysis of as follows: since whole Detecting and surveying underground pipelines and cables in city data become the core of figure effectiveness affects, be the correlation inquiry of pipeline table and pipe point table two table, and the object of correlation inquiry is in order to obtain the locus coordinate of pipeline end points, so, from this target, leave for and dissect whole mapping process, list main target as follows:
1. reduce or remove the number of times of correlation inquiry.
2. obtain the locus coordinate of pipeline end points.
Based on above-mentioned two targets, in original Detecting and surveying underground pipelines and cables in city database, increase by four fields " starting point X coordinate ", " starting point Y coordinate ", " terminating point X coordinate ", " terminating point Y coordinate ", for the locus of depositing pipeline end points, and by an associated assignment statement, the disposable end points spatial positional information assignment that all pipelines are needed.When pipeline becomes figure, just can directly read the terminal coordinate information of pipeline, thereby avoid correlation inquiry frequent and consuming time like this.From having solved in essence above-mentioned target.
Accompanying drawing explanation
Fig. 1 is conventional line detection data drawing methods one;
Fig. 2 is conventional line detection data drawing methods two;
Fig. 3 is conventional line detection data drawing methods three;
Fig. 4: original pipeline detection data structure (other detection datas omit);
Fig. 5: increase the data structure (other detection datas omit) after pipeline terminal coordinate fields;
Fig. 6: pipeline detection data quick mapping flow process (managing a little after first pipeline);
Fig. 7: pipeline detection data quick mapping flow process (first pipe point rear line).
Embodiment
Below in conjunction with accompanying drawing and embodiment, the invention will be further described.
The present invention is based on ArcGIS platform, utilizes ArcGIS secondary exploitation technology, realizes Detecting and surveying underground pipelines and cables in city data one-tenth figure.Detecting and surveying underground pipelines and cables in city data layout be take Access database as example.
1. in the pipeline table of pipeline detection data, increase pipeline terminal coordinate fields.
As shown in Figure 4 and Figure 5, increasing field detection data field front and that increase after field changes: increased " starting point X coordinate ", " starting point Y coordinate ", " terminating point X coordinate ", " terminating point Y coordinate " these four fields.
2. according to the annexation of pipeline and pipe point, be pipeline terminal coordinate assignment.
By being pipeline terminal coordinate assignment in advance, avoid when pipeline detection data one-tenth figure, the incidence relation by pipeline and pipe point reads the operation of pipe point coordinate information frequently, thereby has promoted greatly the efficiency of one-tenth figure.
This step is committed step of the present invention, although realize simply, its thought is thoroughly understood marrow and the essence that pipeline becomes figure, breaks the immotile barrier of raw data.
3. read a table | [line table], traversal point table | [line table], draw pipe point | [pipeline].
4. assignment pipe point | [pipeline] attribute.
5. read line table | [some table], traversal line table | [some table], rendering pipeline | [pipe point].
6. assignment pipeline | [pipe point] attribute.
7. become figure to finish.
As shown in Figure 6, a kind of Detecting and surveying underground pipelines and cables in city data quick mapping method based on GIS platform, comprises the steps:
Step (1): loading city pipeline detection data;
Step (2): increase pipeline terminal coordinate fields;
In the pipeline table of Detecting and surveying underground pipelines and cables in city data, increase " starting point X coordinate ", " starting point Y coordinate ", " terminating point X coordinate ", " terminating point Y coordinate " totally four fields, field name is not limited to this, can clear statement implication.
Step (3): be pipeline terminal coordinate assignment;
According to the incidence relation (period of storage tube line endpoints in pipeline table of pipeline table in Detecting and surveying underground pipelines and cables in city data and pipe point table, conventionally be initial period and stop period, corresponding with the pipe point numbering in pipe point table), in pipeline table, be newly-increased four field assignment of " starting point X coordinate ", " starting point Y coordinate ", " terminating point X coordinate ", " terminating point Y coordinate ".
Take the starting point X coordinate of assignment pipeline and the statement of Y coordinate is example:
UPDATE line table, some table SET line table. initial period X=[point table]! [X coordinate], line table. initial period Y=[point table]! [Y coordinate] WHERE (([some table]! [pipe point numbering]=[a line table]! [initial period]));
Step (4): read pipeline table in pipeline detection data, in geographical data bank, create pipeline factor kind, and the field information of pipeline factor kind is set according to the pipeline table structure of pipeline detection data.
Step (5): read pipeline table, traversal pipeline table, rendering pipeline key element;
Read pipeline table, by traversal pipeline tables of data record, obtain the terminal coordinate of this pipeline, i.e. " starting point X coordinate " in step (3), " starting point Y coordinate ", " terminating point X coordinate ", " terminating point Y coordinate ".By calling the api interface of GIS platform, according to volume coordinate information, create geometric object, rendering pipeline geometric figure.
Step (6): read pipeline attribute and give pipeline key element;
Complete and create after pipeline geometric object, read the attribute information in pipeline detection table, and assignment is in corresponding pipeline key element.
Circulation step (5)-(6), until each record in pipeline table is all generated to pipeline spatial database, and preserve.
Step (7): read pipe point table, create pipe point factor kind according to pipe point list data structure;
Step (8): read a table, traversal point table, draws pipe point according to point coordinate information;
Read pipe point table, by traversal, manage some data table records, obtain the point coordinate information of this pipe point, i.e. " X coordinate ", " Y coordinate ".By calling the api interface of GIS platform, according to volume coordinate information, create geometric object, draw pipe point geometry figure.
Step (9): read pipe point attribute and give pipe point key element;
Complete and create after pipe point geometry object, read the attribute information in pipe point detection table, and assignment is in corresponding pipe space of points database.
Circulation step (9)-(10), until each record in pipeline table is all generated to pipeline spatial database, and preserve.
Step (10): preserve into figure result, become figure to finish.
As shown in Figure 7, a Detecting and surveying underground pipelines and cables in city data quick mapping method based on GIS platform, comprises the steps:
Step (1): loading city pipeline detection data;
Step (2): increase pipeline terminal coordinate fields;
In the pipeline table of Detecting and surveying underground pipelines and cables in city data, increase " starting point X coordinate ", " starting point Y coordinate ", " terminating point X coordinate ", " terminating point Y coordinate " totally four fields, field name is not limited to this, can clear statement implication.
Step (3): be pipeline terminal coordinate assignment;
According to the incidence relation (period of storage tube line endpoints in pipeline table of pipeline table in Detecting and surveying underground pipelines and cables in city data and pipe point table, conventionally be initial period and stop period, corresponding with the pipe point numbering in pipe point table), in pipeline table, be newly-increased four field assignment of " starting point X coordinate ", " starting point Y coordinate ", " terminating point X coordinate ", " terminating point Y coordinate ".
Take the starting point X coordinate of assignment pipeline and the statement of Y coordinate is example:
UPDATE line table, some table SET line table. initial period X=[point table]! [X coordinate], line table. initial period Y=[point table]! [Y coordinate] WHERE (([some table]! [pipe point numbering]=[a line table]! [initial period]));
Step (4): read pipe point table, create pipe space of points database table structure according to pipe point list data structure; Read pipe point table data list structure, call the api interface of GIS platform, create pipe space of points database table structure.
Step (5): read a table, traversal point table, draws pipe point according to point coordinate information;
Read pipe point table, by traversal, manage some data table records, obtain the point coordinate information of this pipe point, i.e. " X coordinate ", " Y coordinate ".By calling the api interface of GIS platform, according to volume coordinate information, create geometric object, draw pipe point geometry figure.
Step (6): read pipe point attribute and give pipe point key element;
Complete and create after pipe point geometry object, read the attribute information in pipe point detection table, and assignment is in corresponding pipe point key element.
Step (7): read pipeline table, create pipeline spatial data database table structure according to pipeline table data structure;
Read pipeline table data list structure, call the api interface of GIS platform, create pipeline spatial data database table structure.
Step (8): read pipeline table, traversal pipeline table, rendering pipeline;
Read pipeline table, by traversal pipeline tables of data record, obtain the terminal coordinate of this pipeline, i.e. " starting point X coordinate " in step (3), " starting point Y coordinate ", " terminating point X coordinate ", " terminating point Y coordinate ".By calling the api interface of GIS platform, according to volume coordinate information, create geometric object, rendering pipeline geometric figure.
Step (9): read pipeline attribute and give pipeline key element;
Complete and create after pipeline geometric object, read the attribute information in pipeline detection table, and assignment is in corresponding pipeline key element.
Circulation step (5)-(6), until each record in pipeline table is all generated to pipeline spatial database, and preserve.
Step (10): preserve into figure result, become figure to finish.
Patent of the present invention is applicable to all urban pipelines (eight large class pipelines, electric power, telecommunications, feedwater, draining, combustion gas, heating power, industry, pipe gallery) detection data become figure, but be not limited to this, as long as meet the data of certain rule, all can become figure according to the inventive method.
This rule shows as a table and line table exists certain topological relation, and as shared this point with a several line that are connected, the locus of the point that the locus of the end points of line is attached thereto is consistent, shows also consistent on attribute information.At above-mentioned pipeline, become in figure, the end points of pipeline is initial period and stops period corresponding with the pipe point numbering in pipe point table, and attribute information is consistent; The position of the endpoint location of pipeline and pipe point is corresponding, and locus is consistent.
Expand in other business scopes, as city bus routes data, as each station is a little, between standing and standing, be line, between point and line, have annexation.All website attribute informations are become to a some table with volume coordinate finish message, by the bus routes finish message between website and website, it is line table, just can use the method for patent of the present invention to become figure, make it to be converted into space, geographic position by simple attribute information and show.
In the present invention:
Detecting and surveying underground pipelines and cables in city data: i.e. pipeline generaI investigation company by field operation generally investigate, the means such as interior industry processing, the final achievement data of submitting to, are usually expressed as that pipe point is shown and pipeline table totally two tables of data, leave in a database file.Common detection data library format is EXCEL or ACCESS etc.
Pipeline and pipe point incidence relation: in pipeline detection data, the period of storage tube line endpoints in pipeline table, is conventionally initial period and stops period (being not limited to this), and the pipe point numbering in pipe point table is corresponding.As shown in Figure 3.
Become figure: by the simple attribute list data (also claiming relational data) of relational data library storage, by GIS technology, be converted into geographical graphic and show.
Pipeline and pipe point: a kind of geographical graphic that comprises attribute information and space geometry information, its geometric properties is line segment, i.e. 2 formation line segments that are connected.The end points of line segment is pipe point, and the line of line segment is pipeline.
Factor kind (Feature Class): the set of similar Space Elements.Pipeline factor kind is the set of pipeline Space Elements.Pipe point factor kind manages the set of space of points key element.
Although above-mentioned, by reference to the accompanying drawings the specific embodiment of the present invention is described; but be not limiting the scope of the invention; one of ordinary skill in the art should be understood that; on the basis of technical scheme of the present invention, those skilled in the art do not need to pay various modifications that creative work can make or distortion still in protection scope of the present invention.
Claims (20)
1. the Detecting and surveying underground pipelines and cables in city data quick mapping method based on GIS platform, is characterized in that, comprises the steps:
First, loading city pipeline detection data, described Detecting and surveying underground pipelines and cables in city data comprise pipeline table and pipe point table; In pipeline table, increase pipeline terminal coordinate fields, for pipeline terminal coordinate shifts to an earlier date assignment, described assignment refers to gives the end points spatial positional information that pipeline needs, and when pipeline becomes figure, directly reads the pipeline terminal coordinate information shifting to an earlier date after assignment;
Then, at the enterprising line pipe line of GIS platform telogenesis figure: read pipeline table, traversal pipeline table, according to terminal coordinate information rendering pipeline, reads pipeline attribute and give pipeline key element;
The 3rd, at the enterprising line pipe point telogenesis of GIS platform figure: read pipe point table, traversal pipe point table, draws pipe point according to point coordinate information; Read pipe point attribute and give pipe point key element;
Finally, preserve into figure result, become figure to finish.
2. the Detecting and surveying underground pipelines and cables in city data quick mapping method based on GIS platform, is characterized in that, comprises the steps:
First, loading city pipeline detection data, described Detecting and surveying underground pipelines and cables in city data comprise pipeline table and pipe point table; In pipeline table, increase pipeline terminal coordinate fields, for pipeline terminal coordinate shifts to an earlier date assignment, described assignment refers to gives the end points spatial positional information that pipeline needs, and when pipeline becomes figure, directly reads the pipeline terminal coordinate information shifting to an earlier date after assignment;
Then, at the enterprising line pipe point telogenesis of GIS platform figure: read pipe point table, traversal pipe point table, draws pipe point according to point coordinate information; Read pipe point attribute and give pipe point key element;
The 3rd, at the enterprising line pipe line of GIS platform telogenesis figure: read pipeline table, traversal pipeline table, according to terminal coordinate information rendering pipeline, reads pipeline attribute and give pipeline key element;
Finally, preserve into figure result, become figure to finish.
3. the Detecting and surveying underground pipelines and cables in city data quick mapping method based on GIS platform as claimed in claim 1 or 2, is characterized in that, comprises the steps:
Described is according to the incidence relation of pipeline table in Detecting and surveying underground pipelines and cables in city data and pipe point table for pipeline terminal coordinate shifts to an earlier date assignment, in pipeline table, is the pipeline terminal coordinate fields assignment increasing.
4. the Detecting and surveying underground pipelines and cables in city data quick mapping method based on GIS platform as claimed in claim 1 or 2, is characterized in that, the described concrete steps at the enterprising line pipe line of GIS platform telogenesis figure are:
Step (1a-1): read pipeline table in pipeline detection data, in geographical data bank, create pipeline factor kind by GIS platform, and the field information of pipeline factor kind is set according to the pipeline table structure of pipeline detection data;
Step (1a-2): read detection data pipeline table, traversal pipeline table, according to terminal coordinate information rendering pipeline key element in pipeline factor kind;
Step (1a-3): read detection data pipeline attribute, and give in attribute field value corresponding to pipeline key element;
Circulation step (1a-2)-(1a-3), until each record in pipeline table is all generated in pipeline factor kind, and preserve.
5. the Detecting and surveying underground pipelines and cables in city data quick mapping method based on GIS platform as claimed in claim 1 or 2, is characterized in that, the described concrete steps at the enterprising line pipe point telogenesis of GIS platform figure are:
Step (1b-1): read pipe point table, in geographical data bank, create pipe point factor kind, and the field information of pipe point factor kind is set according to the pipe point list structure of pipeline detection data;
Step (1b-2): read detection data pipe point table, traversal point table, draws pipe point key element according to point coordinate information;
Step (1b-3): read pipe point attribute and give pipe point key element;
Complete and create after pipe point geometry object, read the attribute information in pipe point detection table, and assignment is in corresponding pipe point factor kind database;
Circulation step (1b-2)-(1b-3), until each record in pipe point table is all generated to pipe space of points database, and preserve.
6. method as claimed in claim 1 or 2, is characterized in that, increases pipeline terminal coordinate fields and refer to increase " starting point X coordinate ", " starting point Y coordinate ", " terminating point X coordinate ", " terminating point Y coordinate " totally four fields in pipeline table.
7. method as claimed in claim 3, it is characterized in that, according to the incidence relation of pipeline table in Detecting and surveying underground pipelines and cables in city data and pipe point table, in pipeline table, be newly-increased four field assignment of " starting point X coordinate ", " starting point Y coordinate ", " terminating point X coordinate ", " terminating point Y coordinate ".
8. method as claimed in claim 3, is characterized in that, described incidence relation is the period of storage tube line endpoints in pipeline table and relation corresponding to pipe point numbering in pipe point table.
9. method as claimed in claim 1 or 2, is characterized in that, described in read pipeline table, traversal pipeline table, rendering pipeline, the step that reads pipeline attribute and give pipeline key element is:
Read pipeline table, by traversal pipeline tables of data record, obtain the terminal coordinate of this pipeline, by calling the api interface of GIS platform, according to volume coordinate information, create geometric object, rendering pipeline geometric figure, and pipeline attribute information is given in attribute information corresponding to pipeline key element.
10. method as claimed in claim 1 or 2, is characterized in that, reads pipe point table, and traversal pipe point table, draws pipe point according to point coordinate information; The step that reads pipe point attribute and give pipe point key element is:
Read pipe point table, by traversal, manage some data table records, obtain the point coordinate information of this pipe point, by calling the api interface of GIS platform, according to volume coordinate information, create geometric object, draw pipe point geometry figure, and pipe point attribute information is given in attribute information corresponding to pipe point key element.
11. Detecting and surveying underground pipelines and cables in city data quick mapping systems based on GIS platform, is characterized in that, comprising:
The module of loading city pipeline detection data, described Detecting and surveying underground pipelines and cables in city data comprise pipeline table and pipe point table; In pipeline table, increase the module of pipeline terminal coordinate fields, for pipeline terminal coordinate shifts to an earlier date the module of assignment, described assignment refers to gives the end points spatial positional information that pipeline needs, and for when pipeline becomes figure, directly reads the pipeline terminal coordinate information shifting to an earlier date after assignment;
The module of pipeline telogenesis figure on GIS platform: read pipeline table, traversal pipeline table, rendering pipeline, reads pipeline attribute and gives the module of pipeline key element;
The module of pipe point telogenesis figure on GIS platform: read pipe point table, traversal pipe point table, draws pipe point according to point coordinate information; Read pipe point attribute and give the module of managing some key element;
Preserve into the module of figure result.
12. Detecting and surveying underground pipelines and cables in city data quick mapping systems based on GIS platform, is characterized in that, comprising:
The module of loading city pipeline detection data, described Detecting and surveying underground pipelines and cables in city data comprise pipeline table and pipe point table; In pipeline table, increase the module of pipeline terminal coordinate fields, for pipeline terminal coordinate shifts to an earlier date the module of assignment, described assignment refers to gives the end points spatial positional information that pipeline needs, and for when pipeline becomes figure, directly reads the pipeline terminal coordinate information shifting to an earlier date after assignment;
The module of pipe point telogenesis figure on GIS platform: read pipe point table, traversal pipe point table, the module of drawing pipe point according to point coordinate information; Read pipe point attribute and give the module of managing some key element;
The module of pipeline telogenesis figure on GIS platform: read pipeline table, traversal pipeline table, the module of rendering pipeline, reads pipeline attribute and gives the module of pipeline key element;
Preserve into the module of figure result.
13. Detecting and surveying underground pipelines and cables in city data quick mapping systems based on GIS platform as described in claim 11 or 12, is characterized in that, comprising:
The described module that shifts to an earlier date assignment for pipeline terminal coordinate is according to an incidence relation for pipeline table in Detecting and surveying underground pipelines and cables in city data and pipe point table, in pipeline table, is the pipeline terminal coordinate fields assignment increasing.
14. Detecting and surveying underground pipelines and cables in city data quick mapping systems based on GIS platform as described in claim 11 or 12, is characterized in that, described on GIS platform the module of pipeline telogenesis figure, comprising:
Read the module of pipeline table in pipeline detection data, by GIS platform, in geographical data bank, create pipeline factor kind, and the module of the field information of pipeline factor kind is set according to the pipeline table structure of pipeline detection data.
Read the module of detection data pipeline table, traversal pipeline table, the module of rendering pipeline key element in pipeline factor kind;
Read the module of detection data pipeline attribute, and give the module in attribute field value corresponding to pipeline key element;
Circulation step (1a-2)-(1a-3), until each record in pipeline table is all generated in pipeline factor kind, and the module of preserving.
15. Detecting and surveying underground pipelines and cables in city data quick mapping systems based on GIS platform as described in claim 11 or 12, is characterized in that, described on GIS platform a module of pipe point telogenesis figure, comprising:
Read the module of pipe point table, in geographical data bank, create pipe point factor kind, and the module of the field information of pipe point factor kind is set according to the pipe point list structure of pipeline detection data;
Read detection data pipe point table, traversal point table, draws the module of managing some key element according to point coordinate information;
Read pipe point attribute and give the module of managing some key element;
Complete and create after pipe point geometry object, read the attribute information in pipe point detection table, and assignment is to the module in corresponding pipe point factor kind database;
Circulation step (1b-2)-(1b-3), until each record in pipe point table is all generated to pipe space of points database, and the module of preserving.
16. systems as described in claim 11 or 12, it is characterized in that, the module that increases pipeline terminal coordinate fields in pipeline table refers to increase " starting point X coordinate ", " starting point Y coordinate ", " terminating point X coordinate ", " the terminating point Y coordinate " module of totally four fields.
17. systems as claimed in claim 13, it is characterized in that, according to the incidence relation of pipeline table in Detecting and surveying underground pipelines and cables in city data and pipe point table, in pipeline table, be newly-increased four field assignment of " starting point X coordinate ", " starting point Y coordinate ", " terminating point X coordinate ", " terminating point Y coordinate ".
18. systems as claimed in claim 13, is characterized in that, described incidence relation is the period of storage tube line endpoints in pipeline table and relation corresponding to pipe point numbering in pipe point table.
19. systems as described in claim 11 or 12, is characterized in that, described in read pipeline table, traversal pipeline table, rendering pipeline, the module that reads pipeline attribute and give pipeline key element comprises:
Read the module of pipeline table, by traversal pipeline tables of data record, obtain the module of the terminal coordinate of this pipeline, by calling the api interface of GIS platform, according to volume coordinate information, create geometric object, the geometric module of rendering pipeline, reads pipeline attribute and gives the module of pipeline key element.
20. systems as described in claim 11 or 12, is characterized in that, described in read pipe point table, traversal pipe point table, draws pipe point according to point coordinate information; The module that reads pipe point attribute and give pipe point key element comprises:
Read the module of pipe point table, by traversal, manage some data table records, obtain the module of the point coordinate information of this pipe point, by calling the api interface of GIS platform, according to volume coordinate information, create geometric object, draw the module of pipe point geometry figure, read the module of managing some attribute and giving pipe point key element.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410158680.XA CN103927362B (en) | 2014-04-18 | 2014-04-18 | Detecting and surveying underground pipelines and cables in city data quick mapping method and system based on GIS platform |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410158680.XA CN103927362B (en) | 2014-04-18 | 2014-04-18 | Detecting and surveying underground pipelines and cables in city data quick mapping method and system based on GIS platform |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN103927362A true CN103927362A (en) | 2014-07-16 |
| CN103927362B CN103927362B (en) | 2017-07-11 |
Family
ID=51145583
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410158680.XA Active CN103927362B (en) | 2014-04-18 | 2014-04-18 | Detecting and surveying underground pipelines and cables in city data quick mapping method and system based on GIS platform |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103927362B (en) |
Cited By (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107871209A (en) * | 2017-10-26 | 2018-04-03 | 泰华智慧产业集团股份有限公司 | A kind of method of the underground utilities auxiliary programming examination ＆ approval based on GIS |
| CN108073775A (en) * | 2017-12-29 | 2018-05-25 | 武汉智博创享科技股份有限公司 | A kind of method and drawing apparatus for drawing elbow and pipe network connectivity device |
| CN112364116A (en) * | 2020-11-25 | 2021-02-12 | 北京京航计算通讯研究所 | Method and system for establishing association between three-dimensional model of underground pipeline and target GIS (geographic information System) |
| CN112800288A (en) * | 2019-11-14 | 2021-05-14 | 北京大学 | Method for processing image flow data |
| CN113177285A (en) * | 2021-05-20 | 2021-07-27 | 上海市城市建设设计研究总院（集团）有限公司 | Urban drainage system topological relation problem identification and correction method based on drainage model |
| CN113963120A (en) * | 2021-12-22 | 2022-01-21 | 武汉智联时空科技有限公司 | Automatic parameterization three-dimensional pipeline modeling method and system based on GIS system |
| CN116340305A (en) * | 2023-04-24 | 2023-06-27 | 上海叁零肆零科技有限公司 | Method and system for repairing uniqueness of meter line table in topology of gas pipe network |
| CN117079182A (en) * | 2023-07-31 | 2023-11-17 | 上海启呈信息科技有限公司 | Pipe network management method and system based on big data analysis |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101634398A (en) * | 2009-07-30 | 2010-01-27 | 苏州市数字城市工程研究中心有限公司 | Method for analyzing cartridge igniter of city integrated pipe network in three-dimensional visual environment |
| CN103699634A (en) * | 2013-12-20 | 2014-04-02 | 保定金迪地下管线探测工程有限公司 | Database creation method and database creation system for one-stop pipeline detection |
-
2014
- 2014-04-18 CN CN201410158680.XA patent/CN103927362B/en active Active
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101634398A (en) * | 2009-07-30 | 2010-01-27 | 苏州市数字城市工程研究中心有限公司 | Method for analyzing cartridge igniter of city integrated pipe network in three-dimensional visual environment |
| CN103699634A (en) * | 2013-12-20 | 2014-04-02 | 保定金迪地下管线探测工程有限公司 | Database creation method and database creation system for one-stop pipeline detection |
Non-Patent Citations (1)
| Title |
|---|
| 黄丙湖等: ""管线信息管理系统的设计与实现"", 《山东科技大学学报》 * |
Cited By (14)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107871209A (en) * | 2017-10-26 | 2018-04-03 | 泰华智慧产业集团股份有限公司 | A kind of method of the underground utilities auxiliary programming examination ＆ approval based on GIS |
| CN108073775A (en) * | 2017-12-29 | 2018-05-25 | 武汉智博创享科技股份有限公司 | A kind of method and drawing apparatus for drawing elbow and pipe network connectivity device |
| CN108073775B (en) * | 2017-12-29 | 2021-05-25 | 武汉智博创享科技股份有限公司 | Method for drawing elbow and pipe network communication equipment and drawing device |
| CN112800288A (en) * | 2019-11-14 | 2021-05-14 | 北京大学 | Method for processing image flow data |
| CN112800288B (en) * | 2019-11-14 | 2024-08-09 | 北京大学 | Method for processing picture flow data |
| CN112364116A (en) * | 2020-11-25 | 2021-02-12 | 北京京航计算通讯研究所 | Method and system for establishing association between three-dimensional model of underground pipeline and target GIS (geographic information System) |
| CN113177285B (en) * | 2021-05-20 | 2022-07-29 | 上海市城市建设设计研究总院（集团）有限公司 | Urban drainage system topological relation problem identification and correction method based on drainage model |
| CN113177285A (en) * | 2021-05-20 | 2021-07-27 | 上海市城市建设设计研究总院（集团）有限公司 | Urban drainage system topological relation problem identification and correction method based on drainage model |
| CN113963120A (en) * | 2021-12-22 | 2022-01-21 | 武汉智联时空科技有限公司 | Automatic parameterization three-dimensional pipeline modeling method and system based on GIS system |
| CN113963120B (en) * | 2021-12-22 | 2022-05-13 | 武汉智联时空科技有限公司 | Automatic parameterization three-dimensional pipeline modeling method and system based on GIS (geographic information System) |
| CN116340305A (en) * | 2023-04-24 | 2023-06-27 | 上海叁零肆零科技有限公司 | Method and system for repairing uniqueness of meter line table in topology of gas pipe network |
| CN116340305B (en) * | 2023-04-24 | 2023-10-20 | 上海叁零肆零科技有限公司 | Method and system for repairing uniqueness of meter line table in topology of gas pipe network |
| CN117079182A (en) * | 2023-07-31 | 2023-11-17 | 上海启呈信息科技有限公司 | Pipe network management method and system based on big data analysis |
| CN117079182B (en) * | 2023-07-31 | 2024-02-23 | 上海启呈信息科技有限公司 | Pipe network management method and system based on big data analysis |
Also Published As
| Publication number | Publication date |
|---|---|
| CN103927362B (en) | 2017-07-11 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103927362A (en) | Urban pipe line detection data fast mapping method and system based on GIS platform | |
| CN101477694B (en) | Handwriting erasing method and apparatus | |
| CN103761405B (en) | There is the three-dimensional underground pipe line automatic creation system of wrong self-checking function | |
| CN103927419A (en) | Data processing method and system for CAD urban pipeline as-built drawing based on ArcGIS platform | |
| CN106407540A (en) | Underground pipeline auxiliary planning verification method based on three-dimensional GIS technology | |
| CN105046328A (en) | Three-dimensional visual bridge disease information collection management system and three-dimensional visual bridge disease information collection management method | |
| CN107103640B (en) | Three-dimensional modeling method and system for urban underground pipeline | |
| CN111814289B (en) | Water supply pipe network pipe burst analysis method and analysis system based on schema theory | |
| CN105808609A (en) | Discrimination method and equipment of point-of-information data redundancy | |
| CN105022748A (en) | Waybill address classified method and apparatus | |
| CN104657364A (en) | Log-structured database system query processing method and device | |
| CN103853769A (en) | Method and device for processing map query request | |
| CN107203526A (en) | A kind of query string semantic requirement analysis method and device | |
| CN102750393B (en) | Composite index structure and searching method based on same | |
| CN110990933A (en) | Modeling method for shield tunnel | |
| CN107391516A (en) | Bus station polymerization and device | |
| CN110189391A (en) | A kind of Electromagnetic Survey of Underground Pipelines drawing formation system | |
| CN102436504A (en) | System and method for processing road data based on dynamic segmentation technology | |
| CN103106254A (en) | Parallel splicing method of polygonal vector data files | |
| CN103218701A (en) | Logistics cargo allocation information interactive method | |
| CN105760626A (en) | Pipeline routing map generating system and method for newly-built subway station | |
| CN105550249A (en) | Pipeline data processing system | |
| CN114138925A (en) | Location point belonging area retrieval method, device, electronic equipment, medium and product | |
| CN110619134B (en) | Integrated detection and repair method for solving problem of flying spot and spot density of road network data | |
| CN107545074B (en) | Method for deleting part of non-connected nodes in directed road network graph |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| CB02 | Change of applicant information |
Address after: 250101 Shandong city of Ji'nan province high tech Zone (Lixia District) Xinluo Avenue No. 2008 silver bearing building 4-901 Applicant after: TAIHUA WISDOM INDUSTRY GROUP CO., LTD. Address before: 250101 Shandong city of Ji'nan province high tech Zone (Lixia District) Xinluo Avenue No. 2008 silver bearing building 4-901 Applicant before: TelChina (Shandong) Corporation Limited |
|
| COR | Change of bibliographic data | ||
| CB03 | Change of inventor or designer information | ||
| CB03 | Change of inventor or designer information |
Inventor after: Liu Yugang Inventor after: Ma Shujie Inventor after: Zhang Liguo Inventor after: Su Jun Inventor after: Hao Jingquan Inventor before: Liu Yugang Inventor before: Zhang Liguo Inventor before: Su Jun |
|
| GR01 | Patent grant | ||
| GR01 | Patent grant |