CN106126666A - A kind of development approach of ArcGIS data processing tools - Google Patents
A kind of development approach of ArcGIS data processing tools Download PDFInfo
- Publication number
- CN106126666A CN106126666A CN201610490155.7A CN201610490155A CN106126666A CN 106126666 A CN106126666 A CN 106126666A CN 201610490155 A CN201610490155 A CN 201610490155A CN 106126666 A CN106126666 A CN 106126666A
- Authority
- CN
- China
- Prior art keywords
- gdb
- data
- data processing
- object library
- arcgis
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
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/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
-
- 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/25—Integrating or interfacing systems involving database management systems
- G06F16/252—Integrating or interfacing systems involving database management systems between a Database Management System and a front-end application
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F8/00—Arrangements for software engineering
- G06F8/20—Software design
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F8/00—Arrangements for software engineering
- G06F8/30—Creation or generation of source code
- G06F8/31—Programming languages or programming paradigms
- G06F8/315—Object-oriented languages
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F9/00—Arrangements for program control, e.g. control units
- G06F9/06—Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
- G06F9/44—Arrangements for executing specific programs
- G06F9/448—Execution paradigms, e.g. implementations of programming paradigms
- G06F9/4488—Object-oriented
- G06F9/449—Object-oriented method invocation or resolution
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Software Systems (AREA)
- General Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- Computing Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses the development approach of a kind of ArcGIS data processing tools, carry out in the steps below: 1. run pre-treatment；2. in new thread, set up source database connect；3. in new thread, create theassistant base mdb；4. in new thread, create object library gdb；5. source database imports data in object library gdb；6. according to data handling requirements, the data in object library gdb are carried out graphics process and form the figure of result data；7. carrying out attribute process by needing to be in the graph data importing theassistant base mdb that attribute processes, attribute is handled well and is led back to afterwards in object library gdb；8. the run-time error produced in object library gdb and theassistant base mdb processing procedure is collected in general type array, and the process log information in processing procedure is carried out roll display in interface and journal file by trust；9. results repository outputting log file are generated.The present invention uses the mode that gdb with mdb is combined, thus increases substantially efficiency, moreover it is possible to improve Consumer's Experience sense.
Description
Technical field
The present invention relates to a kind of ArcGIS development field, the development approach of a kind of ArcGIS data processing tools.
Background technology
At present in the information work in each field, the GIS data relating to magnanimity processes, and ArcGIS is in GIS data
Process and application aspect is first place in the world, generally relate to the project of GIS data all use ArcGIS as platform.Have
If next manual process of the conventional ArcGIS platform of employing that process of a little project GIS data is unpractical, the place of some complexity
Reason is to be difficult to do by hand, and this most inevitably needs to develop some GIS data process softwares targetedly.
It is the interface calling ArcGIS that usual manner exploitation GIS data processes software, uses the com component environment that it provides
Process data.Owing to GIS data comprises graphical information, so general data amount is big especially, the software that conventional mode is developed
Efficiency is the lowest, and sometimes possible operation of calculating process conventional software of a data base all can not complete for ten several hours.This
It is accomplished by Optimal Development thinking, just can develop data processing software with practical value.
The results repository that ArcGIS data processing software generates typically uses the mode of mdb, this is because can facilitate in mdb
Execution sql statement, batch processing attribute field value.Can also do the process of figure in mdb, treatment effeciency is also good, but
It is that mdb has a maximum problem, it is simply that within data volume can only be limited in 2GB, this Ye Shi Microsoft sets Access data base
Restriction on meter.
ArcGIS has oneself exclusive library form: gdb a kind of, and data face here uses the mode of file to store,
This does not has a data quantitative limitation, and graphics process taller than in mdb of efficiency in gdb.But the problem that gdb is maximum
It is exactly to perform sql statement, in data processing software is developed, uses sql statement to process if some processes, such as belong to
Complicated calculations in property processes, and efficiency is certainly fast than what the endless form recorded one by one was come.
ArcGIS also has the database management language of oneself exclusive server version a kind of: SDE, this is disposed on
Middleware software on Oracle, SQL Server or other large-scale relevant databases.If using SDE data base as mesh
The mode in mark storehouse develops data processing software, has not both had data quantitative limitation, has not also had the restriction of sql statement, because at SDE
In the relational databases such as oracle can be utilized to perform sql statement processing attribute value.But the software that SDE mode is developed is maximum
Shortcoming be exactly that efficiency is the lowest, also slow than mdb mode many for the treatment of effeciency that SDE runs big data quantity, more there is no the effect of gdb
Rate is high.This mode is the most impracticable.
It addition, the data that ArcGIS data can also support ShapeFile form process, use this data form conduct
Object library exploitation data processing software is the most impracticable, because the data of ShapeFile form are the data form of file equally,
Sql statement can not be performed, so the process on the attribute of GIS data is the most inconvenient.
Summary of the invention
It is an object of the invention to, it is provided that the development approach of a kind of ArcGIS data processing tools.The present invention use gdb with
The mode that mdb combines, thus increase substantially efficiency, moreover it is possible to improve Consumer's Experience sense.
Technical scheme: the development approach of a kind of ArcGIS data processing tools, is carried out in the steps below:
1. pre-treatment is run；
2. in new thread, set up source database connect；
3. in new thread, create theassistant base mdb；
4. in new thread, create object library gdb；
5. source database imports data in object library gdb；
6. according to data handling requirements, the data in object library gdb are carried out graphics process and form the figure of result data；
7. carrying out attribute process by needing to be in the graph data importing theassistant base mdb that attribute processes, attribute handles it well
After lead back in object library gdb；
8. the run-time error produced in object library gdb and theassistant base mdb processing procedure is collected in general type array, and will
Process log information in processing procedure carrys out roll display in interface and journal file by trust；
9. results repository outputting log file are generated.
In the development approach of aforesaid ArcGIS data processing tools, described operation pre-treating method is to enter in the steps below
OK:
S1, opens interface and runs, it is intended that source database and object library position；
S2, the setting at record interface；
S3, the Enabled of the button button arranging operation are false；
S4, creates new thread, calls data processing method in new thread；
S5, in the starting position of data processing method, initializes daily record class object, records the time started run, initially
Change its dependent variable.
In the development approach of aforesaid ArcGIS data processing tools, the source data will specified on interface exactly in described S2
Storehouse and object library position are written in * .ini file by I/O file stream mode.
In the development approach of aforesaid ArcGIS data processing tools, described theassistant base mdb has multiple, each theassistant base
The data volume deposited in mdb is less than 2GB.
In the development approach of aforesaid ArcGIS data processing tools, the method for described establishment object library gdb is employing one
The individual file with extension name .gdb, then imports the xml plan document building library standard in gdb file, thus is formed
One empty gdb data base.
In the development approach of aforesaid ArcGIS data processing tools, use call GP instrument Append make source database to
Object library gdb imports data.
In the development approach of aforesaid ArcGIS data processing tools, described step 6. in graphics process be use GP enter
Row batch graphics process, thus ensure operational efficiency.
In the development approach of aforesaid ArcGIS data processing tools, described step 7. in attribute process be use with
The sql statement of access database matching carrys out processing attribute.
In the development approach of aforesaid ArcGIS data processing tools, in object library gdb and theassistant base mdb processing procedure
Produce interim table data collection in general type array, the interim table in end of run Posterior circle delete target storehouse gdb, retain auxiliary
Help the interim table in the mdb of storehouse, thus time-consuming.
In the development approach of aforesaid ArcGIS data processing tools, in described journal file, record has the execution of each step
Moment, finish time, total run time, results repository position and log file location.
Compared with prior art, the present invention is by the way of using gdb with mdb to be combined, and target master library uses gdb, auxiliary
Storehouse mdb, it is simply that some data needing sql to process import in mdb and process, and the process on graph data is just held in gdb
Row gp operates, and such efficiency is greatly improved, even if data volume is big again, software performs the data in a county to carry out processing typically 3
Can complete within hour；Perform to be illustrated in during data process the journal displaying region at interface by the form of daily record,
User is it is known that performing any operation and performing the time consumed, and Consumer's Experience sense is preferable.
The present invention uses the mode that master library is gdb and theassistant base is mdb, and theassistant base can be multiple, the most sharp
Not having data volume to limit with gdb, run the fireballing feature of gp, the sql operational efficiency taking full advantage of again mdb is high, can be very
The feature of batch processing attribute easily.Software can create easily during performing and call multiple mdb theassistant base, it is to avoid
The 2GB data quantitative limitation of mdb.
The present invention in the process of implementation can automatically by the mode of file iostream, by during information write expansion
Open up in the journal file of entitled * .log, if what mistake is processing procedure have, can search former by searching log file
Cause.
The present invention uses new thread to process data, and the log information of background process is shown on interface by trust
In text viewing area；The result master library generated is gdb, and theassistant base mdb, theassistant base can be multiple.GP process is used in master library
Figure, speed is fast；A large amount of sql processing attributes that use, efficiency height in mdb.Between two storehouses, data can be exchanged with each other.
Accompanying drawing explanation
Fig. 1 is the flow chart of the present invention.
Detailed description of the invention
The present invention is further illustrated with embodiment below in conjunction with the accompanying drawings, but is not intended as depending on restriction of the present invention
According to.
Embodiment.A kind of development approach of ArcGIS data processing tools, flow process is as it is shown in figure 1, carry out in the steps below:
1. pre-treatment is run；
2. in new thread, set up source database connect；Use and new thread is gone again connect, it is to avoid meeting in running below
The com mistake that database space IWorkspace calls occurs；
3. in new thread, create theassistant base mdb；Using conventional mode, the establishment of theassistant base mdb can be with newly-built one
Empty, it is also possible to by the way of file operation, replicate a mdb template do theassistant base；
4. in new thread, create object library gdb；
5. source database imports data in object library gdb；
6. according to data handling requirements the data in object library gdb are carried out graphics process (intersect between such as figure table,
Erasing etc. process) formed result data figure；
7. carrying out attribute process by needing to be in the graph data importing theassistant base mdb that attribute processes, attribute handles it well
After lead back in object library gdb；
8. by object library gdb and theassistant base mdb processing procedure produce run-time error be collected in general type array List <
String > in, can list together when end of run, conveniently check, and by the process log information in processing procedure by committee
Torr carrys out roll display in interface and journal file；
9. results repository outputting log file are generated.
Described operation pre-treating method is to carry out in the steps below:
S1, opens interface and runs, it is intended that source database and object library position；
S2, the setting at record interface；
S3, the Enabled of the button button arranging operation are false, stop user in software running process again
Click on button, cause operating entanglement；
S4, creates new thread, calls data processing method in new thread；
S5, in the starting position of data processing method, initializes daily record class object, records the time started run, initially
Change its dependent variable.
The source database specified on interface and object library position are write by described S2 exactly by I/O file stream mode
In * .ini file, when next time opens, read this * .ini file, the parameter that last time is arranged can be shown on interface.
Described theassistant base mdb has multiple, and the data volume deposited in each theassistant base mdb is less than 2GB.
The method of described establishment object library gdb is to use a file with extension name .gdb, then to gdb file
Importing the xml plan document building library standard in folder, thus form an empty gdb data base, there are the empty data of standard the inside
Table.
GP instrument Append is called in employing makes source database import data in object library gdb.
Described step 6. in graphics process be to use GP to carry out batch graphics process, thus ensure operational efficiency.
Described step 7. in attribute to process be to use to carry out processing attribute with the sql statement of access database matching.
The interim table data collection produced in object library gdb and theassistant base mdb processing procedure, in general type array, runs
Terminate the interim table in Posterior circle delete target storehouse gdb, retain the interim table in theassistant base mdb, thus time-consuming.
In described journal file record have the execution moment of each step, finish time, total run time, results repository position and
Log file location.
The present invention is embodied as can be as follows:
1, the main interface of software (permanent basic farmland instrument v1.1) is opened；
2, source database: use the template establishment of a standard, it is simply that the data collected are imported standard by user of service
In template；
3, pre-treatment is run:
Being exactly the judgement doing setting option, in basic farmland instrument, the code of exploitation is as follows:
4, in new thread, daily record class and some variablees are initialized
Code is as follows:
5, in new thread, source database is connected
Code is as follows:
6, theassistant base and object library are created
Main code is as follows:
7, to target Kuku, data are imported from storehouse, source
Main code is as follows:
8, in object library gdb, generate the graph data of each table
Main code is as follows:
9, theassistant base mdb is utilized to carry out processing attribute
Main code:
10, some table is carried out areal calculation
11, process at the end of whole processing procedure
Mistake listed, to need the middle table deleted to delete, the time that calculating runs:
12, concrete detailed process code
Code above is the outline of the main code run, for concrete Procedure Codes citing.Such as: create basic
The figure detailed process of farmland figure speckle is as follows:
13, GP calls specific code example
More particularly, the such as process of derivative evidence is called GP instrument and is carried out, and the GP of employing is Append, code
As follows:
14, the results repository of Software Create
Results repository is gdb, and theassistant base is temporary file, does not has other values.
Claims (10)
1. the development approach of an ArcGIS data processing tools, it is characterised in that: carry out in the steps below:
1. pre-treatment is run；
2. in new thread, set up source database connect；
3. in new thread, create theassistant base mdb；
4. in new thread, create object library gdb；
5. source database imports data in object library gdb；
6. according to data handling requirements, the data in object library gdb are carried out graphics process and form the figure of result data；
7. carrying out attribute process by needing to be in the graph data importing theassistant base mdb that attribute processes, attribute is handled well and is led afterwards
Return in object library gdb；
8. the run-time error produced in object library gdb and theassistant base mdb processing procedure is collected in general type array, and will process
During process log information carry out roll display in interface and journal file by trust；
9. results repository outputting log file are generated.
The development approach of ArcGIS data processing tools the most according to claim 1, it is characterised in that: locate before described operation
Reason method is to carry out in the steps below:
S1, opens interface and runs, it is intended that source database and object library position；
S2, the setting at record interface；
S3, the Enabled of the button button arranging operation are false；
S4, creates new thread, calls data processing method in new thread；
S5, in the starting position of data processing method, initializes daily record class object, the time started that record runs, initializes it
Dependent variable.
The development approach of ArcGIS data processing tools the most according to claim 2, it is characterised in that: described S2 is exactly
The source database specified on interface and object library position are written in * .ini file by I/O file stream mode.
The development approach of ArcGIS data processing tools the most according to claim 1, it is characterised in that: described theassistant base
Mdb has multiple, and the data volume deposited in each theassistant base mdb is less than 2GB.
The development approach of ArcGIS data processing tools the most according to claim 1, it is characterised in that: described establishment target
The method of storehouse gdb is to use a file with extension name .gdb, then imports in gdb file and builds library standard
Xml plan document, thus form an empty gdb data base.
The development approach of ArcGIS data processing tools the most according to claim 1, it is characterised in that: use and call GP work
Tool Append makes source database import data in object library gdb.
The development approach of ArcGIS data processing tools the most according to claim 1, it is characterised in that: described step 6. in
Graphics process be to use GP to carry out batch graphics process, thus ensure operational efficiency.
The development approach of ArcGIS data processing tools the most according to claim 1, it is characterised in that: described step 7. in
Attribute to process be to use to carry out processing attribute with the sql statement of access database matching.
The development approach of ArcGIS data processing tools the most according to claim 1, it is characterised in that: at object library gdb
With the interim table data collection produced in theassistant base mdb processing procedure in general type array, end of run Posterior circle delete target
Interim table in the gdb of storehouse, retains the interim table in theassistant base mdb, thus time-consuming.
10. according to the development approach of the ArcGIS data processing tools described in any one of claim 1-9, it is characterised in that: institute
State record in journal file and have the execution moment of each step, finish time, total run time, results repository position and journal file position
Put.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610490155.7A CN106126666A (en) | 2016-06-24 | 2016-06-24 | A kind of development approach of ArcGIS data processing tools |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610490155.7A CN106126666A (en) | 2016-06-24 | 2016-06-24 | A kind of development approach of ArcGIS data processing tools |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN106126666A true CN106126666A (en) | 2016-11-16 |
Family
ID=57285012
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201610490155.7A Pending CN106126666A (en) | 2016-06-24 | 2016-06-24 | A kind of development approach of ArcGIS data processing tools |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106126666A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108628597A (en) * | 2018-04-25 | 2018-10-09 | 赵宇 | A kind of NI Vision Builder for Automated Inspection development approach and device |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102508869A (en) * | 2011-10-11 | 2012-06-20 | 西安煤航信息产业有限公司 | Method of importing CAD (computer-aided design) graph and attribute data into GIS (Geographic information system) |
| CN103064895A (en) * | 2012-12-17 | 2013-04-24 | 福建省电力有限公司 | Communication source management system computer generating method based on Geographic Information System (GIS) |
| CN103699634A (en) * | 2013-12-20 | 2014-04-02 | 保定金迪地下管线探测工程有限公司 | Database creation method and database creation system for one-stop pipeline detection |
-
2016
- 2016-06-24 CN CN201610490155.7A patent/CN106126666A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102508869A (en) * | 2011-10-11 | 2012-06-20 | 西安煤航信息产业有限公司 | Method of importing CAD (computer-aided design) graph and attribute data into GIS (Geographic information system) |
| CN103064895A (en) * | 2012-12-17 | 2013-04-24 | 福建省电力有限公司 | Communication source management system computer generating method based on Geographic Information System (GIS) |
| CN103699634A (en) * | 2013-12-20 | 2014-04-02 | 保定金迪地下管线探测工程有限公司 | Database creation method and database creation system for one-stop pipeline detection |
Non-Patent Citations (2)
| Title |
|---|
| 袁磊: ""矿产资源规划数据库建设及应用研究-以丽江市为例"", 《中国优秀硕士学位论文全文数据库 基础科学辑》 * |
| 马黎莉: ""基于图解建模的乡级土地利用规划数据库建设探讨"", 《中国优秀硕士学位论文全文数据库 工程科技II辑》 * |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108628597A (en) * | 2018-04-25 | 2018-10-09 | 赵宇 | A kind of NI Vision Builder for Automated Inspection development approach and device |
| CN108628597B (en) * | 2018-04-25 | 2021-08-06 | 赵宇 | Machine vision system development method and device |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| EP3430529B1 (en) | Intelligent metadata management and data lineage tracing | |
| EP3513314B1 (en) | System for analysing data relationships to support query execution | |
| CN107533453B (en) | System and method for generating data visualization applications | |
| US7681185B2 (en) | Template-driven approach to extract, transform, and/or load | |
| US8881127B2 (en) | Systems and methods to automatically generate classes from API source code | |
| US11847040B2 (en) | Systems and methods for detecting data alteration from source to target | |
| CN102880709B (en) | Data warehouse management system and data warehouse management method | |
| US9323815B2 (en) | Star and snowflake schemas in extract, transform, load processes | |
| CN103383688B (en) | Memory headroom database for geocoding/geography processing | |
| WO2017186774A1 (en) | Systems and methods for querying databases | |
| US20040181440A1 (en) | Automatic generation of a dimensional model for business analytics from an object model for online transaction processing | |
| CN102426582B (en) | Data manipulation management devices and data manipulation management method | |
| EP1457878B1 (en) | Automatic generation of an object model from a dimensional model | |
| CN103186541A (en) | Generation method and device for mapping relationship | |
| CN102841889A (en) | Method and device for achieving efficient database access based on ORM (object relational mapping) architecture | |
| US9740713B1 (en) | Dynamic modeling of data in relational databases | |
| CN102054217B (en) | Entity morphing in metamodel-based tools | |
| US20110252049A1 (en) | Function execution using sql | |
| US8413109B2 (en) | Systems and methods for metamodel transformation | |
| US20090187552A1 (en) | System and Methods for Generating Data Analysis Queries from Modeling Constructs | |
| US20190147088A1 (en) | Reporting and data governance management | |
| US8832601B2 (en) | ETL tool utilizing dimension trees | |
| CN106599241A (en) | Big data visual management method for GIS software | |
| CN106126666A (en) | A kind of development approach of ArcGIS data processing tools | |
| US10318524B2 (en) | Reporting and data governance management |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20161116 |