A kind of Immovable Property Registration data extraction method based on GISTechnical field
The invention belongs to information management system technical fields, and in particular to a kind of Immovable Property Registration data based on GIS mentionTake method.
Background technique
Many local constructions complete Immovable Property Registration information platform project at present, including Immovable Property Registration information platform,The work such as data conversion, archives scan；The construction for unifying register information platform by real estate, by " internet+" technology roadLine, further upgrading, and carry out data on stock integration, to reach associated documents requirement and real estate to be made to issue licence work moreThe efficient and convenient service common people.
As computer technology and the mankind continue to develop the demand of geography information, every technology of web is all continuousGround is perfect, and people are also required to more easily get a local geography information.By the convenient characteristic easily obtained of web,It allows it to carry and shows generalized information system data, geography information can be understood with more convenient people and handled and planned.
GIS-Geographic Information System (Geographic Information System or Geo-Information system,GIS) sometimes referred to as it is " GeoscienceInformation System ".It is a kind of specific highly important space information system.It is to calculateUnder machine hardware and software system is supported, the related geographic distribution data in earth surface layer space all or in part is acquired, is stored upThe technological system depositing, manage, operation, analyzing, be shown and described.Position and geography information are both the core and LBS of LBSBasis.One simple latitude and longitude coordinates is only placed in specific geography information, after being represented as some place, mark, orientation,It can be just appreciated and understood by user.User is after getting location information by the relevant technologies, it is also necessary to understand locating groundEnvironment, inquiry and analysis environmental information are managed, to provide Informational support and service for User Activity.
Existing society people are further strong for the application demand of geography information, whether to the need of navigation in individual lifeAsk or other to oneself local environment understand demand or various geology companies, field soil planning department, urban construction or cityRoading department of city requires that we can more quickly get the data of GIS, and can be according to our practical meshMark supplies us and analyzes and bring one to get information about more intuitively to show GIS data.
Summary of the invention
The purpose of the present invention is being directed to existing issue, a kind of Immovable Property Registration data extraction method based on GIS is provided.
The present invention is achieved by the following technical solutions: a kind of Immovable Property Registration data extraction method based on GIS, packetIt includes GIS data and obtains system, the GIS data obtains system and includes user log-in block and inquire GIS data module, described to look intoAsking GIS data module includes the web page display Foreground Data module shown for front end and the statistical data life for generating documentAt document module；
The user log-in block realizes the legitimacy of automatic verifying login user identity, and GIS data system is entered after logining successfullySystem main interface；
The web page display Foreground Data module includes searching for geo information module and shows geography information module, searches for geographical letterModule is ceased for realizing in GIS data system main interface input ancestor number, is clicked search and is obtained corresponding DBF the file information；ExhibitionShow that geography information module shows GIS informational function by the way of ajax Asynchronous Request, specifically includes the following steps:
S21 obtains user's input；
S22 transmits user's input；
S23 inputs to form hql and sql sentence according to user；
S24 is inquired according to sql sentence, and invocation framenort DAO realizes inquiry data；
The encapsulation of S25 query information returns to foreground, and the data of json format are returned by ajax；
S26 returns to foreground according to foreground message and is shown；
The statistical data generates document module and includes printing document functional module and read shp file function module, described to beatPrinted text shelves functional module generates newly-built for realizing every terms of information is obtained according to operation after selection printing according to java code attributeDetailed data are filled into required new document by document, locally downloading；Shp file function module is read to realizeDatabase is imported after shp file is converted to sql file, specifically includes the following steps:
S31 obtains the operation that user selects printing；
S32 obtains user in the operation of GIS data system main interface input specific information；
S33 inputs the action queries GIS data of specific information according to user；
S34 is inserted into the designated position in new document by the information that database returns；
S35 is according to the new document of java code building specified format to designated position；
S36 carries out information feedback to web page；
When inquiring GIS data in the S33-35, realized with sql hql sentence to data by link example documentScreening, extracts required data content, then carries out the data content of extraction in the designated position of already present example documentInsertion or replacement；New document is generated after the completion, and the new document of generation is stored in specific bit with preset naming methodIt sets.
As further improvement of these options, software structure design uses the multilayered structure under B/S architecture mode, oftenOne layer all by being mutually related class or other assemblies are constituted, some function is completed in mutually collaboration；Exist between layers and relies onRelationship, the class or other assemblies on upper layer rely on the interface of lower layer；Every layer only discloses API to upper layer, so when a certain layer occursIts API, which does not change, when change would not influence other layers of realization.
As further improvement of these options, the legitimacy for verifying its identity automatically includes page ajax verifyingIt is verified with log-on message, specific following steps:
Page ajax verifying includes verifying user name by page ajax whether there is；
Log-on message is verified
Whether S11 verifies user name correct；
Whether S12 verifying username and password is unified；
S13 obtains user information.
As further improvement of these options, the frame DAO is mapped to database by hibernate, then leads toIt crosses my eclipse and realizes mapping；The hibernate is by the mapping file of XML the table pair in POJO and databaseIt should get up, in XML file, configure the mapping relations of the table in Object and database, be then added to mappingIn hibernate.cfg.xml；Table in the data is the table that data are stored in legacy data library.
As further improvement of these options, configuration needs the field filtered in the web.xml of the web page,In the note of the place addition upper filter of filter class, blocker is configured in web.xml, will not needed to call request and all be blockedIt cuts outside, such as the request beyond the user right all intercepts.
As further improvement of these options, the new document of the generation is excel document.
As further improvement of these options, the specific information is for ancestor number；Required data content is example textIn shelves except ancestor number in addition to default need content；The preset naming method is with ancestor number name.
B/S refers to the tactic pattern of browser and server.He be for C/S development mode a kind of improvement in other wordsA kind of variation.Under the mode, what user was realized by browser access server.Main the affair logic is in server-side realityIt is existing.Such structure can reduce the pressure of client computer, can make full use of the high performance feature of server.More reduce systemMaintenance and the cost for carrying out secondary development.
In software structure design, layered structure is very common, is also very important structure.It is general to be divided into threeLayer, is from top to bottom presentation layer respectively, Business Logic, and data access layer (is also persistent layer).
Make MySql database in this system, persistent layer uses the Hibernate technology that spring is integrated, service logicLayer realizes that (struts is used to be C layers statement layer, spring with the MVC design mode based on struts with common javabeanRealize decoupling of the V layers of decoupling and C with C layers layer with M layers)；
It is developed using explaining, explains the benefit of exploitation and developed relative to non-notes and be primarily due to that it is more convenient, use noteSolution does not need to be gone to generate xml document according to each entity class, easily facilitates the entity class of modification javabean, opens for subsequentSituations such as hair may add field to database can save a large amount of workload using note, and then use ssh frameWhen configuration process in using explain can make configuration size of code reduce.It is more flexible finally to explain exploitation, is creatingIt can mark when building the entity class of non-database table as without spending configuration file.
The present invention has the advantage that compared with prior art
(1) multilayered structure under B/S architecture mode has been used, user accesses server by browser and realizes, can reduce clientThe pressure of machine makes full use of the high performance feature of server, can reduce the cost of system maintenance and secondary development；
(2) using exploitation is explained, it is more convenient to develop relative to non-note, may add word to database for subsequent developmentSituations such as section, can save a large amount of workload using note, be reduced using the size of code that can make configuration is explained；It is more cleverIt is living, it can mark when creating the entity class of non-database table as without spending configuration file；
(3) invocation framenort DAO realizes inquiry data, carries out database manipulation using DAO, can be realized by my eclipseMapping avoids the atypia generated manually from making mistakes；
(4) GIS informational function is shown by the way of ajax Asynchronous Request, has borrowed the convenience of jq and the asynchronous of ajax is askedCompletion this operation is asked, and makes response caused by this operation avoids when search is shown because of acquisition mass data fastSpend slow situation；
(5) shp file is converted to and imports database after sql file again and can be avoided processing when reading shp fileThe more troublesome problem of method facilitates raising software performance by database.
Method obtains the data files such as shp in GIS data automatically in the present invention, is integrated into database, then basisSpecific call format, data required for obtaining from database automatically, is exported with specified format document and is saved in specifiedIt compares convenient for printing filing management and manually extracts information from generalized information system disparate modules now, work can be effectively improved in positionMake efficiency and accuracy rate.
Detailed description of the invention
Fig. 1 is that GIS data obtains system schematic；
Fig. 2 is DAO class design diagram；
Fig. 3 is Immovable Property Registration application content；
Fig. 4 is Immovable Property Registration approval form content；
Fig. 5 is the jar content that mimeograph documents import.
Specific embodiment
The following further describes the present invention with reference to the drawings.
As shown in fig. 1, a kind of Immovable Property Registration data extraction method based on GIS, including GIS data obtain system,It includes user log-in block and inquiry GIS data module that the GIS data, which obtains system, and the inquiry GIS data module includesThe web page display Foreground Data module shown for front end and the statistical data for generating document generate document module；
The user log-in block realizes the legitimacy of automatic verifying login user identity, and GIS data system is entered after logining successfullyIt unites main interface, the legitimacy for verifying its identity automatically includes page ajax verifying and log-on message verifying, specific following stepIt is rapid:
Page ajax verifying includes verifying user name by page ajax whether there is；
Log-on message is verified
Whether S11 verifies user name correct；
Whether S12 verifying username and password is unified；
S13 obtains user information；
The web page display Foreground Data module includes searching for geo information module and shows geography information module, searches for geographical letterModule is ceased for realizing in GIS data system main interface input ancestor number, is clicked search and is obtained corresponding DBF the file information；ExhibitionShow that geography information module shows GIS informational function by the way of ajax Asynchronous Request, specifically includes the following steps:
S21 obtains user's input；
S22 transmits user's input；
S23 inputs to form hql and sql sentence according to user；
S24 is inquired according to sql sentence, and invocation framenort DAO(is as shown in Figure 2) realize inquiry data；
The encapsulation of S25 query information returns to foreground, and the data of json format are returned by ajax；
S26 returns to foreground according to foreground message and is shown；
The statistical data generates document module and includes printing document functional module and read shp file function module, described to beatPrinted text shelves functional module generates newly-built for realizing every terms of information is obtained according to operation after selection printing according to java code attributeDetailed data are filled into required new document by document, locally downloading；Shp file function module is read to realizeDatabase is imported after shp file is converted to sql file, specifically includes the following steps:
S31 obtains the operation that user selects printing；
S32 obtains user in the operation of GIS data system main interface input specific information；
S33 inputs the action queries GIS data of specific information according to user；
S34 is inserted into the designated position in new document by the information that database returns；
S35 is according to the new document of java code building specified format to designated position；
S36 carries out information feedback to web page；
When inquiring GIS data in the S33-35, realized with sql hql sentence to data by link example documentScreening, extracts required data content, then carries out the data content of extraction in the designated position of already present example documentInsertion or replacement；New document is generated after the completion, and the new document of generation is stored in specific bit with preset naming methodIt sets.
Specifically, Fig. 3 and Fig. 4 are example document, user obtains system by GIS data, according to S21-S26 andAfter S31-S36 step operation, the new document for filling up information based on example text is obtained, is printed or is examined as neededBatch.
Wherein, software structure design is using the multilayered structure under B/S architecture mode, each layer all by be mutually related class orPerson's other assemblies are constituted, some function is completed in mutually collaboration；There are dependence, the class on upper layer or other groups between layersThe interface of part dependence lower layer；Every layer only discloses API to upper layer, so its API does not change when a certain layer changesIt would not influence other layers of realization.
Wherein, the frame DAO is mapped to database by hibernate, then realizes mapping by my eclipse；InstituteHibernate is stated to be mapped the table in POJO and database by the mapping file of XML, in XML file, configurationMapping, is then added in hibernate.cfg.xml by the mapping relations of the table in good Object and database；It is describedTable in data is the table that data are stored in legacy data library.
Wherein, configuration needs the field filtered in the web.xml of the web page, in the place addition of filter classThe note of filter, configures blocker in web.xml, and will not need to call request all intercepts outside, such as beyond the userThe request of permission all intercepts；Because being to develop for address company management person in this system, there is no interceptUser, but intercept any non-user.
Wherein, the new document of the generation is excel document.
Wherein, the data content needed in the tables of data include ancestor number, legal person, area of issuing licence, affiliated administrative village, powerSharp people, phone, mailbox；The specific data be extracted from database according to preset to respective field it is corresponding inHold.
B/S refers to the tactic pattern of browser and server.He be for C/S development mode a kind of improvement in other wordsA kind of variation.Under the mode, what user was realized by browser access server.Main the affair logic is in server-side realityIt is existing.Such structure can reduce the pressure of client computer, can make full use of the high performance feature of server.More reduce systemMaintenance and the cost for carrying out secondary development.
In software structure design, layered structure is very common, is also very important structure.It is general to be divided into threeLayer, is from top to bottom presentation layer respectively, Business Logic, and data access layer (is also persistent layer).
Make MySql database in this system, persistent layer uses the Hibernate technology that spring is integrated, service logicLayer realizes that (struts is used to be C layers statement layer, spring with the MVC design mode based on struts with common javabeanRealize decoupling of the V layers of decoupling and C with C layers layer with M layers)；
It is developed using explaining, explains the benefit of exploitation and developed relative to non-notes and be primarily due to that it is more convenient, use noteSolution does not need to be gone to generate xml document according to each entity class, easily facilitates the entity class of modification javabean, opens for subsequentSituations such as hair may add field to database can save a large amount of workload using note, and then use ssh frameWhen configuration process in using explain can make configuration size of code reduce.It is more flexible finally to explain exploitation, is creatingIt can mark when building the entity class of non-database table as without spending configuration file.
Main modular and design are further illustrated
A, user log-in block
It inputs user name password and clicks Button Login, system can verify the legitimacy of its identity automatically.
Non- note development mode is used with ssh frame, javabean class automatic mapping needs a form list,In action attribute write and need specified method ,@Action remarks are added in specified method directly to be jumpedTo this method.
B, document functional module is printed
It needs to go to obtain every terms of information for the operation after selection printing, then by it according to the side of java code attributeFormula goes to generate document, mainly has invoked the jar packet that content in Fig. 5 is used to write excel or word.
It is locally downloading and among document required for the detailed filling by data.
C, shp file function module is read
Processing method when reading shp file is more troublesome, by importing again after shp file is converted to sql fileDatabase will appear the problem in some processing among this, repair in being also to export again after handling sql file againIt just can be used after changing, it is final to realize the data for using this document in the database, to facilitate raising soft by databasePart performance.
Wherein, the design of database includes the design of tables of data, and GIS attribute list is used to save GIS information point attribute information,It is as shown in table 1:
Table 1
| Column name | Type | Length | Attribute |
| id | int | 11 | not null |
| Zongdihao | VARchar | 20 | not null |
| FaRen | VARchar | 20 | not null |
| Fazhengmianji | VARchar | 20 | not null |
| Suoshuxingzhengcun | VARchar | 20 | not null |
| quanliren | VARchar | 20 | not null |
| cellphone | VARchar | 20 | not null |
| Email | VARchar | 20 | not null |
Method obtains the data files such as shp in GIS data automatically in the present invention, is integrated into database, then basisSpecific call format, obtains data from database automatically, is exported with specified format document and is saved in specified position, justIn printing filing management, compare and manually extract information from generalized information system disparate modules now, can effectively improve working efficiency withAccuracy rate；
Specifically when in use, user obtains system by logging into GIS data, with inputting ancestor can be from database after number informationMiddle other relevant informations of acquisition can be downloaded or be printed as needed and fill out then by selection Fig. 3, Fig. 4 or other example documentsThere is the new document of complete information；Applicant's (application form in Fig. 3) or approving person's (approval form in Fig. 4) can be saved from dataThe step of information or oneself filling are searched in library；Wherein the ancestor of user's input number with real estate unit number pair in table 3 or table 4It answers, while the specific data information that can also store other general titles for expressing the meaning and certain ground number can correspond toMultiple and different adopted names can need to set the corresponding common name of corresponding data information according to client to reduce volumes of searchesClaim.
The foregoing is merely illustrative of the preferred embodiments of the present invention, and wherein Fig. 3, Fig. 4 are also partial example table, notTo limit the present invention, any modifications, equivalent substitutions and improvements made within the spirit and principles of the present invention should allIt is included within protection scope of the present invention.