CN112052407B - Service area query method, device, computer equipment and readable storage medium - Google Patents
Service area query method, device, computer equipment and readable storage medium Download PDFInfo
- Publication number
- CN112052407B CN112052407B CN202010886338.7A CN202010886338A CN112052407B CN 112052407 B CN112052407 B CN 112052407B CN 202010886338 A CN202010886338 A CN 202010886338A CN 112052407 B CN112052407 B CN 112052407B
- Authority
- CN
- China
- Prior art keywords
- building
- service area
- repaired
- street
- data
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
- 238000000034 method Methods 0.000 title claims abstract description 44
- 238000004590 computer program Methods 0.000 claims description 14
- 238000005034 decoration Methods 0.000 claims description 4
- 230000006870 function Effects 0.000 description 5
- 238000007726 management method Methods 0.000 description 3
- 238000012986 modification Methods 0.000 description 3
- 230000004048 modification Effects 0.000 description 3
- 238000004891 communication Methods 0.000 description 2
- 238000010586 diagram Methods 0.000 description 2
- 230000001360 synchronised effect Effects 0.000 description 2
- 238000007792 addition Methods 0.000 description 1
- 238000012217 deletion Methods 0.000 description 1
- 230000037430 deletion Effects 0.000 description 1
- 238000013507 mapping Methods 0.000 description 1
- 230000003068 static effect Effects 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
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/90—Details of database functions independent of the retrieved data types
- G06F16/95—Retrieval from the web
- G06F16/953—Querying, e.g. by the use of web search engines
- G06F16/9537—Spatial or temporal dependent retrieval, e.g. spatiotemporal queries
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/29—Geographical information databases
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q50/00—Systems or methods specially adapted for specific business sectors, e.g. utilities or tourism
- G06Q50/08—Construction
Abstract
The invention relates to the technical field of enterprise operation, and particularly discloses a query method, a query device, computer equipment and a readable storage medium for a service area; the query method of the service area comprises the following steps: acquiring a building tray to be installed and repaired of a user; determining whether the building to be repaired exists in a building database according to the building to be repaired; if the existence of the building to be repaired is determined, obtaining the building ID of the building to be repaired; and acquiring the associated service area ID according to the building ID so as to inquire the associated service area according to the service area ID. The query method can obtain the building ID according to the building to be repaired, so that the corresponding service area ID is obtained according to the building ID, and further the associated service area is obtained according to the service area ID, and therefore the customer service can send orders to the enterprise business according to the service area, and the working efficiency of the customer service is improved.
Description
Technical Field
The present invention relates to the field of enterprise operations, and in particular, to a service area query method, a device, a computer device, and a readable storage medium.
Background
The business area used by the current enterprise management platform is greatly different from the administrative division of the national standard, and the administrative area of the national standard is subdivided into different business areas in the enterprise management platform, so that the business area can serve the user according to the requirements of the user, or the proper business-filling merchant can be selected according to the business area to serve the user.
In one application scenario, for example: the customer service obtains the information of the building to be repaired according to the communication with the user, confirms that the region of the building to be repaired is a national standard region, such as a project in the Shanghai XXX region, and needs to perform map query according to the building information of the user, and then searches the specific position of the building according to the query, and further searches the database for the service region corresponding to the specific position of the building to belong to a service several region, so that the office efficiency of the customer service is low; therefore, how to improve the working efficiency of the customer service query service area needs to be solved.
Disclosure of Invention
The invention aims to solve the technical problem that in the prior art, the working efficiency of customer service query service areas is low, and provides a service area query method, a service area query device, computer equipment and a readable storage medium, which are used for improving the office efficiency of the customer service query service areas.
The first aspect of the present invention provides a service area query method, which includes:
Acquiring a building tray to be installed and repaired of a user;
determining whether the building to be repaired exists in a building database according to the building to be repaired;
If the existence of the building to be repaired is determined, obtaining the building ID of the building to be repaired;
and acquiring an associated service area ID according to the floor ID so as to inquire the associated service area according to the service area ID.
Optionally, the building database includes national standard area data and service area data, and the method further includes:
if the fact that the building to be repaired does not exist is determined, acquiring POI (point of interest) data of the building to be repaired through a third-party map API tool;
Acquiring street information of the building to be repaired according to the POI data;
Acquiring a street ID from the national standard area data according to the street information;
And acquiring the associated service area ID from the service area data according to the street ID so as to inquire the associated service area according to the service area ID.
Optionally, the obtaining the street information of the building to be repaired according to the POI data includes:
Determining longitude and latitude information of the building to be repaired according to the POI data;
Based on the longitude and latitude information of the building to be repaired, acquiring a street code corresponding to the longitude and latitude information of the building to be repaired according to the inverse geographic code;
And acquiring the street information according to the street code.
Optionally, the method further comprises:
Taking the non-existing building to be repaired as an uninformed building, and taking the street information as the information to be formed by the uninformed building;
Creating a street ID of the non-entered building according to the to-be-entered information in the building database;
and creates a service area ID associated with the street ID of the unintermitted floor.
Optionally, the method further comprises:
acquiring updated data of the national standard area data in a preset time period;
And modifying, adding, deleting or merging the service area data according to the updating data.
Optionally, after the querying the associated service area according to the service area ID, the method further includes:
acquiring the user requirements of the building to be repaired;
Determining the enterprise-filling merchant in the service area;
And distributing the user requirements for the enterprise, wherein the business requirements comprise decoration requirements.
A second aspect of the present invention provides a service area query apparatus, where the apparatus includes:
The first acquisition module is used for acquiring a building to be repaired of a user;
The determining module is used for determining whether the building to be repaired exists in a building database according to the building to be repaired;
the second acquisition module is used for acquiring the building ID of the building to be repaired if the building to be repaired is determined to exist;
and the inquiring module is used for acquiring the associated service area ID according to the building ID so as to inquire the associated service area according to the service area ID.
Optionally, the building database includes national standard area data and service area data, and the query device further includes:
The third acquisition module is used for acquiring POI data of the building to be repaired through a third-party map API tool if the building to be repaired is determined not to exist;
a fourth obtaining module, configured to obtain street information of the building to be repaired according to the POI data;
a fifth obtaining module, configured to obtain a street ID from the national standard area data according to the street information;
And a sixth acquisition module, configured to acquire an associated service area ID from the service area data according to the street ID, so as to query the associated service area according to the service area ID.
A third aspect of the present invention provides a computer device comprising a memory, a processor and a computer program stored in said memory and executable on said processor, said processor implementing a method of querying a service area according to the first aspect of the present invention when executing said computer program.
A fourth aspect of the present invention provides a computer readable storage medium storing a computer program which, when executed by a processor, implements a method of querying a service area according to the first aspect of the present invention.
The invention provides a query method, a query device, computer equipment and a readable storage medium for a service area; the query method comprises the following steps: acquiring a building tray to be installed and repaired of a user; determining whether the building to be repaired exists in a building database according to the building to be repaired; if the existence of the building to be repaired is determined, obtaining the building ID of the building to be repaired; and acquiring the associated service area ID according to the building ID so as to inquire the associated service area according to the service area ID. The query method can realize that the building ID is obtained according to the determined building to be repaired, so that the corresponding service area ID is obtained according to the building ID, and further the associated service area is obtained, thereby realizing that customer service can serve the requirements of users according to the service area, and further improving the working efficiency of the customer service.
Drawings
In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the drawings that are needed in the description of the embodiments of the present invention will be briefly described below, it being obvious that the drawings in the following description are only some embodiments of the present invention, and that other drawings may be obtained according to these drawings without inventive effort for a person skilled in the art.
FIG. 1 is a flow chart of a query method according to an embodiment of the invention;
FIG. 2 is a flow chart of a query method according to an embodiment of the invention;
FIG. 3 is a schematic diagram of a query device according to an embodiment of the present invention;
FIG. 4 is a schematic diagram of a computer device in accordance with an embodiment of the invention.
Detailed Description
The following description of the embodiments of the present invention will be made clearly and fully with reference to the accompanying drawings, in which it is evident that the embodiments described are some, but not all embodiments of the invention. All other embodiments, which can be made by those skilled in the art based on the embodiments of the invention without making any inventive effort, are intended to be within the scope of the invention.
The embodiment of the invention provides a service area query method, in an application scene, an enterprise customer service establishes communication with a user, the customer service receives a service request of the user, wherein the service request can include but is not limited to, for example, decoration request, and the like, specifically, after the customer service receives the service request of the user, the customer service inquires specific building information of a building to be currently installed by the user, and the building can include but is not limited to, for example, residential housing, residential building, office space, and the like. The building database described in the following embodiments is a pre-created database, and may include, but is not limited to, data such as provinces, cities, towns, villages, and streets. Specifically, national standard area data integrating provinces, cities, towns, villages, streets and the like can be established in a building database, corresponding service areas are divided on the national standard areas according to actual service requirements, and association relations between the national standard areas and the service areas are established. In one embodiment, specifically, as shown in fig. 1, the query method may include:
s10: and obtaining the building tray to be repaired by the user.
In one embodiment, the customer service may obtain the trays to be repaired in the user service request, and specifically, the customer service may input the tray to be repaired information in the system.
S20: and determining whether the building to be repaired exists in a building database according to the building to be repaired.
In one embodiment, after customer service inputs customer service information for a customer to repair, the customer service information may be received and a determination made in a floor database as to whether a customer to repair is present. Illustratively, the floor to be repaired is, for example, an A floor, then the A floor may be retrieved from the floor database to determine whether the A floor exists in the current floor database.
S30: if the existence of the building to be repaired is determined, the building ID of the building to be repaired is obtained.
If the building to be repaired is searched to be existing, the building ID corresponding to the building to be repaired can be acquired, so that the related service area ID is acquired according to the building ID.
S40: and acquiring the associated service area ID according to the building ID so as to inquire the associated service area according to the service area ID.
After the associated service area ID is acquired, specifically, the associated service area ID may be acquired according to the floor ID, so that the associated service area is queried according to the service area ID.
In the above embodiment, through steps S10-S40, it may be achieved that the building ID is obtained according to the determined building to be repaired, so that the corresponding service area ID is obtained according to the building ID, and then the associated service area is obtained, so that the customer service may obtain the corresponding service area by inputting the building to be repaired into the system, so that the customer service may service the user according to the service area, and thus the working efficiency of the customer service may be improved.
In one embodiment, in particular, the floor database may include national standard area data and business area data; the national standard region data and the service region data are mapped and associated. Specifically, the national standard region data may include provinces, cities, towns, villages, streets and other data of national standard planning, the service region data may be region data divided on the basis of the national standard region according to service requirements, and exemplary service region data may be XX first region, XX second region and the like, where the national standard region data and the service region data may be mapped and associated, and it may be understood that the mapping and association in this embodiment may be specifically that the national standard region is subdivided into service regions corresponding to streets, and exemplary that the national standard region includes YY streets, then the associated service regions may be established on the basis of the YY streets, so that the streets according to the national standard region may obtain the corresponding service regions, thereby improving the working efficiency of the regional operation.
It should be noted that, in the above embodiment, after the building to be repaired is obtained, the related service area ID may also be obtained in the building database through the street ID of the building to be repaired, so that the related service area is queried according to the service ID, which is not limited herein, and in order to avoid redundancy, description is omitted herein.
In one embodiment, specifically, as shown in fig. 2, the method may further include:
s50: and if the building to be decorated is determined to not exist, acquiring POI data of the building to be decorated through a third-party map API tool.
In one embodiment, if there is no customer's inventory in the inventory database, it is indicated that the current inventory database has not established information about the inventory the customer is in. In particular, the point of interest POI (Point of Interest) of the building to be decorated may be obtained by a third party map API (Application Programming Interface: application program interface) tool at this time, and it may be understood that the point of interest POI data may specifically represent the building, or a shop, etc. in the expression of the map, based on a third party map API tool, such as a hundred degree map API, or a Tencer map API, or a Goldmap API, etc. In this embodiment, the function of searching for a building, a shop, a restaurant, or the like can be accomplished through a third party map API tool. Specifically, the POI data may include, but is not limited to, for example, address name, address information, latitude and longitude information, or the like.
S60: and acquiring street information of the building to be repaired according to the POI data.
In one embodiment, the POI data may include address information, and specific street information may be obtained according to the address information, so that a street ID is obtained according to the street information. Specifically, after the address information is acquired, street information may be acquired in the address information, and a pre-established street ID may be acquired in the building database based on the street information.
S70: and acquiring the street ID from the national standard area data according to the street information.
In this step, it may be understood that the street is the smallest unit in the national standard area data, the street information belongs to a part of the national standard area data, specifically, the street ID may be created in advance in the national standard area data, and an association relationship between the street ID and the street information is established, and after the street information of the building to be repaired is obtained, the street ID may be obtained according to the street information.
S80: and acquiring the associated service area ID from the service area data according to the street ID so as to inquire the associated service area according to the service area ID.
In one embodiment, after the street information is obtained, an associated business area ID may be obtained from the street ID, such that the associated business area may be queried based on the business area ID.
In the above embodiment, through steps S50-S80, address information of a building which is not entered is obtained by using a map API tool of a third party, so that the problem of incomplete data in the building database can be solved, and thus, the working efficiency can be improved.
In one embodiment, in step S60, that is, the street information of the building to be repaired is obtained according to the POI data, specifically, the method may further include:
s601: and determining longitude and latitude information of the building to be repaired according to the POI data.
In one embodiment, the POI data may include latitude and longitude information, that is, latitude and longitude information of the building to be refurbished may be determined through the POI data.
S602: and acquiring street codes corresponding to the longitude and latitude information of the building to be decorated according to the inverse geocode based on the longitude and latitude information of the building to be decorated.
In one embodiment, based on the latitude and longitude information of the building to be decorated, the street code corresponding to the latitude and longitude information of the building to be decorated can be obtained according to the inverse geocode, it is understood that the latitude and longitude information can be converted into a certain street code through the inverse geocode, and illustratively, the latitude and longitude information is obtained, for example, as follows: 116.480881, 39.989410, the latitude and longitude information is converted to a street code, which may be, for example, 110114001000, so that corresponding street information is obtained from the building database according to the street code.
S603: and obtaining street information according to the street codes.
In one embodiment, after the street code is obtained, street information may be obtained from the street code in the building database, such that an associated business area is obtained from the street information.
In the above embodiment, when the corresponding building to be repaired is not obtained in the building database, specific street information of the building to be repaired is obtained through the steps S601-S603, and the associated service area is obtained according to the street information.
In one embodiment, if it is determined that the building to be repaired does not exist, the query method may further include:
S51: and taking the non-existing building to be repaired as an uninformed building, and taking street information as the information to be formed by uninformed building.
In one embodiment, if it is determined that the to-be-repaired floor is not present, the absent to-be-repaired floor may be used as the non-entered floor, and the street information may be used as the to-be-entered information of the non-entered floor
S52: in the building database, street IDs are created for non-entered building based on the information to be entered.
In one embodiment, the street ID of the non-entered building may be created in the building database based on the obtaining of the non-entered building's to-be-entered information, and it should be noted that the building ID or other information may be included, for example, without limitation.
S53: a service area ID associated with a street ID of a non-entered building is created such that a corresponding service area is obtained from the service area ID.
In one embodiment, a business area ID associated with a street ID of a non-entered floor is created, and in particular a business area ID associated with a floor ID of a non-entered floor may also be created such that the associated business area ID is obtained from the floor ID.
In the above embodiment, through steps S51 to S53, the data of the non-entered building can be established in the building database in time, and the information of the non-entered building can be further perfected, so as to improve the management efficiency of the enterprise operation.
In one embodiment, the query method may further include:
S90: and acquiring updated data of the national standard area data in a preset time period.
In an application scenario, for a standard area of country planning, updating of the national standard area due to policy adjustment may occur within a certain period of time, and specifically, update data of national standard area data in a preset period of time may be obtained, where the preset period of time may be a quarter, or a half year, or a year, and the invention is not limited thereto. Exemplary, the updating of the national standard area may include, but is not limited to, for example, a county setting area, a county setting city, an area merging, a county setting area, a county removing area, and the like, and then data such as the county setting area, the county setting city, the area merging, the county setting area, the county removing area, and the county removing area may be acquired, so that the business area data is modified, added, deleted, merged, or the like according to the updated data.
S100: and modifying, adding, deleting or merging the service area data according to the updated data.
In one embodiment, when a city county setting of a national standard region is acquired, the business region in the business region data may be correspondingly modified, where the modification may include, but is not limited to, modification, addition, deletion, merging, or the like, and is not limited herein.
In the above embodiment, through steps S90-S100, update data of national standard area data in a preset time period is obtained, and service area data is modified, added, deleted or combined according to the update data, so that timely update of the service area data can be realized, thereby improving operation efficiency of the service area.
In one embodiment, after querying the associated service area according to the service area ID, the method further comprises:
S41: and obtaining the user requirements of the building to be repaired.
In one scenario, after the service area of the building to be repaired is acquired, the customer service may acquire a corresponding business company in the service area according to specific service requirements.
S42: and determining the enterprise-filling merchant in the service area.
In this embodiment, the customer service may obtain the corresponding enterprise business in the service area according to the service requirement.
S43: user requirements are assigned to the installing merchant, wherein the business requirements include finishing requirements.
In one embodiment, customer service may order the business merchants within the business area according to business requirements, which may include, but are not limited to, e.g., finishing requirements, quantity room requirements, etc. In an application scenario, after a service area is queried, the user requirement of a building to be repaired can be acquired, and a proper business-filling merchant is selected in the service area according to the user requirement.
In one embodiment, attribute type expansion may also be performed on the building database based on consideration of search diversity, and specifically, the national standard area data may include different attribute types, where the different attribute type data may include coding type data and information type data. Specifically, the code class data may include, but is not limited to, for example, standard area ID (e.g., city ID), national standard city code (e.g., beijing standard code 110000000000), street code, postal code, latitude and longitude, and the like; the information class data may include, for example, but is not limited to, standard area names, standard area pinyin, street information, initials, abbreviations, acronyms, and aggregate names, etc.; the service area data may include, but is not limited to, for example, a service area name and a service area ID, etc.
In the above embodiment, by performing attribute type expansion on the building database, the diversity of data may be increased, so as to implement personalized query (for example, the initial of pinyin may be input to query the corresponding national standard area) and improve the query efficiency.
It should be understood that the sequence number of each step in the foregoing embodiment does not mean that the execution sequence of each process should be determined by the function and the internal logic, and should not limit the implementation process of the embodiment of the present invention.
In one embodiment, a query device for a service area is provided, and in particular, as shown in fig. 3, the query device may include a first acquisition module 10, a determination module 20, a second acquisition module 30, and a query module 40. Wherein, each functional module is described in detail as follows:
a first obtaining module 10, configured to obtain a building to be repaired of a user;
A first determining module 20, configured to determine whether a building to be repaired exists in the building database according to the building to be repaired;
A second obtaining module 30, configured to obtain a building ID of the building to be decorated if it is determined that the building to be repaired exists;
and a query module 40, configured to obtain the associated service area ID according to the floor ID, so as to query the associated service area according to the service area ID.
In one embodiment, specifically, the querying device may further include a third acquisition module 50, a fourth acquisition module 60, a fifth acquisition module 70, and a sixth acquisition module 80, wherein:
And a third obtaining module 50, configured to obtain POI data of interest points of the building to be decorated through a third party map API tool if it is determined that the building to be decorated does not exist.
And a fourth obtaining module 60, configured to obtain street information of the building to be repaired according to the POI data.
The fifth obtaining module 70 is configured to obtain a street ID from the national standard area data according to the street information.
A sixth obtaining module 80, configured to obtain the associated service area ID from the service area data according to the street ID, so as to query the associated service area according to the service area ID.
In one embodiment, the fourth acquisition module 60 is further configured to:
Determining longitude and latitude information of a building to be repaired according to POI data;
Based on longitude and latitude information of the building to be decorated, acquiring a street code corresponding to the longitude and latitude information of the building to be decorated according to the inverse geocode;
And obtaining street information according to the street codes.
In one embodiment, the query device may further include a valuation module, a first creation module, and a second creation module, wherein:
and the assignment module is used for taking the non-existing building to be repaired as an uninformed building and taking street information as the uninformed building to be formed.
The first creation module is used for creating street IDs of the building which are not entered according to the information to be entered in the building database.
And the second creation module is used for creating a service area ID associated with the street ID of the uninterruptable building.
In one embodiment, the query device may further include a seventh obtaining module, a second determining module, and an allocating module, where:
And the seventh acquisition module is used for acquiring the user requirements of the building to be repaired.
And the second determining module is used for determining the business enterprises in the service area.
And the distribution module is used for distributing user requirements for the enterprise, wherein the business requirements comprise decoration requirements.
For specific limitations of the service area query device, reference may be made to the above limitation of the service area query method, which is not repeated herein. The above-described respective modules in the service area dividing apparatus may be implemented in whole or in part by software, hardware, and a combination thereof. The above modules may be embedded in hardware or may be independent of a processor in the computer device, or may be stored in software in a memory in the computer device, so that the processor may call and execute operations corresponding to the above modules.
In one embodiment, as shown in fig. 4, a computer device 6 is provided, which includes a memory 62, a processor 61, and a computer program 63 stored in the memory 62 and capable of running on the processor 61, where the processor executes the computer program 63 to implement the steps in the method for querying service areas in the foregoing embodiment, and for avoiding repetition, a description is omitted herein. Or the processor 61 implements the functions of each module of the query device in the above embodiment when executing the computer program 63, and for avoiding repetition, the description is omitted here.
In one embodiment, a readable storage medium is provided, where the readable storage medium stores a computer program 63, where the computer program 63 when executed by the processor 61 implements the steps in the service area query method of the foregoing embodiment, and in order to avoid repetition, a description is omitted herein. Or the processor 61 implements the functions of each module of the query device in the above embodiment when executing the computer program 63, and for avoiding repetition, the description is omitted here.
Those skilled in the art will appreciate that implementing all or part of the above described methods may be accomplished by way of a computer program stored on a non-transitory computer readable storage medium, which when executed, may comprise the steps of the embodiments of the methods described above. Any reference to memory, storage, database, or other medium used in embodiments provided herein may include non-volatile and/or volatile memory. The nonvolatile memory can include Read Only Memory (ROM), programmable ROM (PROM), electrically Programmable ROM (EPROM), electrically Erasable Programmable ROM (EEPROM), or flash memory. Volatile memory can include Random Access Memory (RAM) or external cache memory. By way of illustration and not limitation, RAM is available in a variety of forms such as Static RAM (SRAM), dynamic RAM (DRAM), synchronous DRAM (SDRAM), double Data Rate SDRAM (DDRSDRAM), enhanced SDRAM (ESDRAM), synchronous link (SYNCHLINK) DRAM (SLDRAM), memory bus (Rambus) direct RAM (RDRAM), direct memory bus dynamic RAM (DRDRAM), and memory bus dynamic RAM (RDRAM), among others.
It will be apparent to those skilled in the art that the foregoing functional units and modules are merely illustrated for convenience and brevity of description, and that in practical applications, the foregoing functional allocations may be performed by different functional modules, sub-modules and units, i.e. the internal structure of the apparatus is divided into different functional units or modules, to perform all or part of the functions described above.
The above embodiments are only for illustrating the technical solution of the present invention, and not for limiting the same; although the invention has been described in detail with reference to the foregoing embodiments, it will be understood by those of ordinary skill in the art that: the technical scheme described in the foregoing embodiments can be modified or some technical features thereof can be replaced by equivalents; such modifications and substitutions do not depart from the spirit and scope of the technical solutions of the embodiments of the present invention, and are intended to be included in the scope of the present invention.
Claims (8)
1. A method for querying a service area, the method comprising:
Acquiring a building tray to be installed and repaired of a user;
determining whether the building to be repaired exists in a building database according to the building to be repaired, wherein the building database comprises national standard area data and business area data;
If the existence of the building to be repaired is determined, obtaining the building ID of the building to be repaired;
acquiring an associated service area ID according to the building ID so as to inquire the associated service area according to the service area ID;
if the fact that the building to be repaired does not exist is determined, acquiring POI (point of interest) data of the building to be repaired through a third-party map API tool;
Acquiring street information of the building to be repaired according to the POI data;
Acquiring a street ID from the national standard area data according to the street information;
And acquiring the associated service area ID from the service area data according to the street ID so as to inquire the associated service area according to the service area ID.
2. The query method as claimed in claim 1, wherein said obtaining street information of the building to be repaired from the POI data comprises:
Determining longitude and latitude information of the building to be repaired according to the POI data;
Based on the longitude and latitude information of the building to be repaired, acquiring a street code corresponding to the longitude and latitude information of the building to be repaired according to the inverse geographic code;
And acquiring the street information according to the street code.
3. The query method of claim 1 or 2, wherein the method further comprises:
Taking the non-existing building to be repaired as an uninformed building, and taking the street information as the information to be formed by the uninformed building;
Creating a street ID of the non-entered building according to the to-be-entered information in the building database;
and creates a service area ID associated with the street ID of the unintermitted floor.
4. The query method of claim 3, wherein the method further comprises:
acquiring updated data of the national standard area data in a preset time period;
And modifying, adding, deleting or merging the service area data according to the updating data.
5. The query method of claim 3, wherein after said querying the associated service area based on the service area ID, the method further comprises:
acquiring the user requirements of the building to be repaired;
Determining the enterprise-filling merchant in the service area;
And distributing the user requirements to the enterprise, wherein the user requirements comprise decoration requirements.
6. A service area query device, wherein the query device comprises:
The first acquisition module is used for acquiring a building to be repaired of a user;
The determining module is used for determining whether the building to be repaired exists in a building database according to the building to be repaired;
the second acquisition module is used for acquiring the building ID of the building to be repaired if the building to be repaired is determined to exist;
The inquiry module is used for acquiring the related service area ID according to the building ID so as to inquire the related service area according to the service area ID;
wherein, the building database includes national standard area data and service area data, the inquiry unit still includes:
The third acquisition module is used for acquiring POI data of the building to be repaired through a third-party map API tool if the building to be repaired is determined not to exist;
a fourth obtaining module, configured to obtain street information of the building to be repaired according to the POI data;
a fifth obtaining module, configured to obtain a street ID from the national standard area data according to the street information;
And a sixth acquisition module, configured to acquire an associated service area ID from the service area data according to the street ID, so as to query the associated service area according to the service area ID.
7. A computer device comprising a memory, a processor and a computer program stored in the memory and executable on the processor, characterized in that the processor implements the service area query method according to any of claims 1-5 when executing the computer program.
8. A computer readable storage medium storing a computer program, wherein the computer program when executed by a processor implements the service area query method of any of claims 1-5.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010886338.7A CN112052407B (en) | 2020-08-28 | 2020-08-28 | Service area query method, device, computer equipment and readable storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010886338.7A CN112052407B (en) | 2020-08-28 | 2020-08-28 | Service area query method, device, computer equipment and readable storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN112052407A CN112052407A (en) | 2020-12-08 |
| CN112052407B true CN112052407B (en) | 2024-05-03 |
Family
ID=73607026
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010886338.7A Active CN112052407B (en) | 2020-08-28 | 2020-08-28 | Service area query method, device, computer equipment and readable storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112052407B (en) |
Citations (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7376636B1 (en) * | 2002-06-07 | 2008-05-20 | Oracle International Corporation | Geocoding using a relational database |
| WO2010063189A1 (en) * | 2008-11-19 | 2010-06-10 | 华为技术有限公司 | Method, client and server for providing position information |
| CN101882163A (en) * | 2010-06-30 | 2010-11-10 | 中国科学院地理科学与资源研究所 | Fuzzy Chinese address geographic evaluation method based on matching rule |
| CN108763345A (en) * | 2018-05-14 | 2018-11-06 | 平安好房（上海）电子商务有限公司 | Method of calibration, user equipment, storage medium and the device of cell longitude and latitude |
| CN108961266A (en) * | 2018-05-25 | 2018-12-07 | 深圳市中电数通智慧安全科技股份有限公司 | A kind of region partitioning method and device |
| CN109246607A (en) * | 2018-10-23 | 2019-01-18 | 青岛禧泰房地产数据有限公司 | A kind of real estate application method showing drop point site based on geographic area mode |
| KR20190041439A (en) * | 2019-03-19 | 2019-04-22 | 주식회사 공감랩 | System of building big data for estimating house price using space information having function of data error correction |
| CN109800360A (en) * | 2018-12-24 | 2019-05-24 | 北京城市网邻信息技术有限公司 | Cell queries method, apparatus, electronic equipment and storage medium |
| CN109857947A (en) * | 2019-01-28 | 2019-06-07 | 科大国创软件股份有限公司 | A kind of broadband installation site selecting method and system based on GIS map |
| CN110134716A (en) * | 2019-04-12 | 2019-08-16 | 平安城市建设科技(深圳)有限公司 | Information query method, information inquiry platform, equipment and readable storage medium storing program for executing |
Family Cites Families (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20070218900A1 (en) * | 2006-03-17 | 2007-09-20 | Raj Vasant Abhyanker | Map based neighborhood search and community contribution |
| KR102202231B1 (en) * | 2012-12-14 | 2021-01-13 | 한국전자통신연구원 | Apparatus for Analyzing Geographic Information and Method thereof |
-
2020
- 2020-08-28 CN CN202010886338.7A patent/CN112052407B/en active Active
Patent Citations (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7376636B1 (en) * | 2002-06-07 | 2008-05-20 | Oracle International Corporation | Geocoding using a relational database |
| WO2010063189A1 (en) * | 2008-11-19 | 2010-06-10 | 华为技术有限公司 | Method, client and server for providing position information |
| CN101882163A (en) * | 2010-06-30 | 2010-11-10 | 中国科学院地理科学与资源研究所 | Fuzzy Chinese address geographic evaluation method based on matching rule |
| CN108763345A (en) * | 2018-05-14 | 2018-11-06 | 平安好房（上海）电子商务有限公司 | Method of calibration, user equipment, storage medium and the device of cell longitude and latitude |
| CN108961266A (en) * | 2018-05-25 | 2018-12-07 | 深圳市中电数通智慧安全科技股份有限公司 | A kind of region partitioning method and device |
| CN109246607A (en) * | 2018-10-23 | 2019-01-18 | 青岛禧泰房地产数据有限公司 | A kind of real estate application method showing drop point site based on geographic area mode |
| CN109800360A (en) * | 2018-12-24 | 2019-05-24 | 北京城市网邻信息技术有限公司 | Cell queries method, apparatus, electronic equipment and storage medium |
| CN109857947A (en) * | 2019-01-28 | 2019-06-07 | 科大国创软件股份有限公司 | A kind of broadband installation site selecting method and system based on GIS map |
| KR20190041439A (en) * | 2019-03-19 | 2019-04-22 | 주식회사 공감랩 | System of building big data for estimating house price using space information having function of data error correction |
| CN110134716A (en) * | 2019-04-12 | 2019-08-16 | 平安城市建设科技(深圳)有限公司 | Information query method, information inquiry platform, equipment and readable storage medium storing program for executing |
Non-Patent Citations (10)
| Title |
|---|
| Study on the construction of historical toponymic information management system for Essence of the Geographical Content of the History Books;Longyu Liu 等;Annals of GIS;20170918(第4期);281-291 * |
| 信息挖掘及数据分析――石家庄广电有线电视用户数据辅助分析系统;高丽娟;李绅;;有线电视技术(第09期) * |
| 地理网格的政务信息资源整合技术研究;何望君 等;测绘科学;20191220(第12期);153-157 * |
| 基于GIS的房产导购信息系统研究与设计;李红娟;图书情报工作(第22期);第89-93页 * |
| 将建设重心转向基层图书馆――杭州市城区图书馆服务体系建设思路探讨;叶艳萍;;新世纪图书馆;20120620(06);130-131 * |
| 岭南模式：崛起的广东公共图书馆事业;程焕文;;中国图书馆学报;20070515(03);15-25 * |
| 房产基础数据一体化平台建设;吴东林;;信息与电脑(理论版);20170523(第10期);63-67 * |
| 李红娟.基于GIS的房产导购信息系统研究与设计.图书情报工作.2009,(第22期),第89-93页. * |
| 税务GIS系统的设计;罗东山 等;黑龙江科技信息;20090115(02);32 * |
| 面向空间信息服务的数字社区管理系统;吴长彬;闾国年;孙在宏;;测绘通报(第10期) * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN112052407A (en) | 2020-12-08 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| KR101721339B1 (en) | Method and device for determining an address for a new point of interest | |
| JP5914349B2 (en) | Method and apparatus for cross-referencing and deduplicating objects in multiple map building blocks | |
| US20070067098A1 (en) | Method and system for identification of geographic location | |
| US9305019B2 (en) | Method of associating user related data with spatial hierarchy identifiers for efficient location-based processing | |
| US10817810B2 (en) | System and method for efficient travel time and route computation | |
| RU2597511C2 (en) | Creating maps of private spaces using sensors of mobile computing devices | |
| US20090292464A1 (en) | System and method for providing geographic markers on electronic objects and real-world objects | |
| WO2021103626A1 (en) | Method and apparatus for generating user geographical portrait, computer device, and storage medium | |
| JP5536898B2 (en) | Location data cache duration optimization for network-based location services | |
| CN101270992A (en) | Search device and search method of geographical coordinates | |
| WO2018201980A1 (en) | Insurance policy service task allocation method, apparatus, computer device and storage device | |
| KR20140097805A (en) | Coordinates (x, y) position value using a systematic block code generated and the address matching service using methods | |
| CN108268614B (en) | Distributed management method for forest resource spatial data | |
| CN109800360B (en) | Cell query method, cell query device, electronic equipment and storage medium | |
| CN104573083B (en) | A kind of cache map services automatic update method | |
| KR102184048B1 (en) | System and method for checking of information about estate development plan based on geographic information system | |
| CN111241350A (en) | Graph data query method and device, computer equipment and storage medium | |
| CN112052407B (en) | Service area query method, device, computer equipment and readable storage medium | |
| CN102523273A (en) | System for providing location-based service | |
| CN110889048B (en) | Map data query method, system, terminal and server | |
| KR101618775B1 (en) | Metadata input supporting system for laws and regulation, and method for processing of the same | |
| CN115455042A (en) | Data processing method, apparatus and computer readable storage medium | |
| US20140214791A1 (en) | Geotiles for finding relevant results from a geographically distributed set | |
| CN112052406A (en) | Method, device and equipment for acquiring service area and readable storage medium | |
| CN112835897A (en) | Geographic region division management method, data conversion method and related equipment |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant |