CN109905452A - A kind of grid advertisement intelligent supplying system based on geographical location - Google Patents

A kind of grid advertisement intelligent supplying system based on geographical location Download PDF

Info

Publication number
CN109905452A
CN109905452A CN201711313134.9A CN201711313134A CN109905452A CN 109905452 A CN109905452 A CN 109905452A CN 201711313134 A CN201711313134 A CN 201711313134A CN 109905452 A CN109905452 A CN 109905452A
Authority
CN
China
Prior art keywords
advertisement
data
latitude
longitude
coordinate
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Granted
Application number
CN201711313134.9A
Other languages
Chinese (zh)
Other versions
CN109905452B (en
Inventor
李坤键
肖家雍
李德智
童成科
吴美乐
曾诚
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Changsha Jutong Electronic Technology Co Ltd
Original Assignee
Changsha Jutong Electronic Technology Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Changsha Jutong Electronic Technology Co Ltd filed Critical Changsha Jutong Electronic Technology Co Ltd
Priority to CN201711313134.9A priority Critical patent/CN109905452B/en
Publication of CN109905452A publication Critical patent/CN109905452A/en
Application granted granted Critical
Publication of CN109905452B publication Critical patent/CN109905452B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Landscapes

  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)

Abstract

The present invention provides a kind of grid advertisement intelligent supplying system based on geographical location, including advertisement display, advertisement acquiring unit, advertising information data maintenance system and advertisement geo-spatial data generate system, the advertising information data maintenance system safeguards the advertisement position data based on grid, advertisement position data are the geographic position datas based on honeycomb structure, honeycomb structure is the round hexgonal structure of a class, effective 20 meters of radius of circle, it is that 20 meters of six sides are constituted by side length, the distance between central point of each adjacent structure is 40 meters, multiple honeycomb mesh structures constitute the data basis that can launch advertisement position, it chooses effective advertisement position and carries out advertisement dispensing;Businessman can observe the effect of dispensing in real time by releasing advertisements, and the suitable period is selected to launch advertisement;Businessman can also bid the advertisement position of high-quality period, realize and precisely launch, promote advertising results.

Description

A kind of grid advertisement intelligent supplying system based on geographical location
Technical field
The present invention relates to information technology fields, particularly, are related to a kind of grid advertisement intelligent push based on geographical location System.
Background technique
Current various mobile terminals have become the too busy to get away equipment of people's daily life, and in each of running of mobile terminal In kind APP, system is broadcast in the advertisement throwing for being all embedded in variform, and Main Morphology has integral wall, table plague, banner, push, letter Breath stream etc. forms, in addition there are also it is newest there is rice to intercut, have a meter electric business wall, mother's Ali application wall, ten thousand general advertising walls, The spreading its tail of more alliances, the new edition table plague of 91 bucket gold, the screen advertisement in hundred million roads Dong Zhi etc., probably there is twenty or thirty kind advertisement form.
The common form of App advertisement
1、Banner
Banner advertisement is called banner, banner advertisements, advertisement bar.
Normal appearance position: top, bottom.
Advantage: displaying is more intuitive, can quickly attract the user's attention.
Disadvantage: influence user experience, to content viewing cause it is certain block, easily cause user to dislike.
Charging mode: CPC.
2, it announces
This mode often appears on electric business class app, transmits relevant information to user by way of message is broadcasted.
Normal appearance position: homepage
Advantage: intuitionistic and concise, be not take up content pages.
Disadvantage: intuitively cannot induce user to click, and most cases can only play suggesting effect.
Charging mode: CPC.
3, table plague
Table plague advertisement appears in pop-up when user clicks some page function for the first time under normal circumstances, and display needs to prompt Particular content.
Normal appearance position: homepage, the page function not clicked on.
Advantage: visual impact is strong, more accurate positioning, significant effect
Disadvantage: user's operation behavior can be temporarily interrupted, user experience is influenced.
Charging mode: CPC
4, startup page advertising
Startup page advertising is also known as full frame advertisement (Full Screen Ads), can almost see on common app, can In the form of picture, the forms load such as video, Flash.When user first enters app, it will starting page occur, after app When platform operation is again introduced into, starting page there will not be.
Normal appearance position: homepage starts page
Advantage: 1. rationally utilize resource, presentation content when waiting app load
2. when user has just been on page, direct presentation ad content preferably can stimulate user to remember.
Disadvantage: part Flash installation kit is added in slowly, influences user experience.
5, information flow advertisement
Information flow advertisement (Feeds Ads), this advertisement occurs along with information, and user can be without when browsing information Advertisement is browsed between meaning.
Normal appearance position: in the contents list based on TimeLine information.
Advantage: user's operation behavior is not influenced.
Disadvantage: content positioning can precisely not allow user to generate aversion.
6, advertisement is integrated
This advertisement form mainly passes through downloading registration and gets partial integration or preferential, certainly in a manner of flow water conservancy diversion A part of customer flow target goal app of body realizes that flow is cashed.
Normal appearance position: the app such as the game of partial movement end, application shop.
Advantage: win-win progress is realized by way of integral.
Disadvantage: in the case that brand credit worthiness is not strong, being easy the safety for allowing user to suspect target app, under serious conditions It will affect brand image.
7, video ads
The user group that video ads are directed to is divided into VIP user and ordinary user, VIP user's energy after buying VIP business Enough directly to skip advertisement, ordinary user, which then needs first to finish watching advertisement, can just see subsequent content.So this advertising is received Enter channel and be divided into two kinds: one is member's business, another kind is video ads.
Normal appearance position: broadcast message class app content beginning.
Advantage: with embedded form product placement, additional content plate is not increased.
Disadvantage: ordinary user (payment purchase VIP business of being unwilling) viewing for a long time will affect user experience.
8, bid ranking
The basic characteristics of bid ranking are to pay per click, and promotion message appears in the result of search (forward), if It is not clicked by user, does not then collect development expenses.
Normal appearance position: search result.
Advantage: quick, keyword endless number system, keyword are regardless of complexity.
Disadvantage: search result is that occur result as a means of troy weight amount inevitably and will cause user intention mismatch, influence user's body It tests.
9, drop-down refreshes
When list content needs to refresh, general app can be using the form refresh list of drop-down refreshing.Advertisement will Fill in the blanks page, reaches the effect of publicity.
Normal appearance position: drop-down refreshes column.
Advantage: being hidden under content pages panel, and user, which refreshes, just will appear, and saves space cost, does not influence user experience.
Disadvantage: advertisement time of occurrence is too short, it is not easy to user be caused to pay attention to.
10, personal letter notifies
Merchandise news is sent to user in the form of personal letter, user can be by checking that personal letter understands commodity details.
Normal appearance position: message function.
Advantage: having accuracy, sends particular commodity by the way that background analysis user is washed.
Disadvantage: usually ignoring user demand, increases user's screening cost.
In addition also there are various television spot advertisements on onboard system (bus, taxi, subway), but these advertisements Form is not the advertisement that trade company is propagated in a manner of based entirely on exact position.
The advertisement form of other mobile terminal devices
1, car-mounted terminal advertisement
The free WIFI being mounted in the public transports such as taxi, bus, coach, tourist bus, subway Hot spot periodically pushes various advertisements by the mode of free wireless networking on mobile terminals.
2, vehicle-mounted ceiling light advertisement
The LED screen being generally referred to as mounted in taxi or vehicle-carried mobile equipment, the text issued by receiving backstage Word message, using horse race lamp mode carousel merchant advertisements.
3, video wall advertisement
The LCD screen for being mounted on the public domains walls such as subway exit, railway station exit, office building lift port is wide Announcement system shows the advertisement of trade company by way of backstage push or artificial replacement ad content.
Existing movement or fixed broadcasting ad system major part, which also all have, plays advertisement based on position, but only Only accomplish to launch advertisement according to IP address or place urban area, but this mode is not very accurate;In addition most of vehicles Carrying equipment is the mode releasing advertisements freely shared based on WIFI, and this mode rate are high, and ad content is easy manual by client Shielding;And some hardware based ad systems are unable to real-time update ad content, and fixation is only played by the way of recorded broadcast Ad content, cannot accomplish in time convey client advertisement;Having some advertisement players only is merely hardware-level supplier, There is no powerful daemon software system, cannot establish one's own system, advertisement dispensing can not be carried out based on accurately system of geographic location.
Summary of the invention
It is an object of that present invention to provide a kind of grid advertisement intelligent supplying system based on geographical location, mobile terminal device In moving process (can also be using fixed position as long as providing coordinate), periphery businessman can be played either in preferred coordinates The merchant advertisement launched in point (specific region), to solve the problems, such as that it is not accurate that advertisement is launched.
To achieve the above object, the present invention provides a kind of grid advertisement intelligent supplying system based on geographical location, packet Include advertisement display, advertisement acquiring unit and advertising information data maintenance system, the advertising information data maintenance system dimension The advertisement position data based on grid are protected, advertisement position data are the geographic position datas based on honeycomb structure, and honeycomb structure is one The round hexgonal structure of class, 20 meters of effective radius of circle are that 20 meters of six sides are constituted by side length, the central point of each adjacent structure The distance between be 40 meters, multiple honeycomb mesh structures constitute the data basis that can launch advertisement position, choose effective advertisement Position carries out advertisement dispensing;
The generation step of advertisement position data are as follows:
A, the longitude and latitude of 4 points is taken on plane map, which is four vertex of a rectangle, required gridding Region in the rectangular area that four points are formed, the longitude and latitude of the central point of rectangle is gone out according to the calculation of longitude & latitude of 4 points Degree evidence;
B, another point is calculated according to central point longitude and latitude, earth radius, terrestrial equator radius, azimuth, spacing distance Latitude and longitude coordinates calculate all coordinates met the requirements in X-axis using the center point coordinate of rectangle as the origin of reference axis Point calculates all coordinate points of the longitudinal axis according to the longitude and latitude and angle of all the points of X-axis, and resulting coordinate set is rectangle Interior criss-cross latitude and longitude coordinates collection, find after tested the coordinate set be rectangle in embedded parallelogram, northwest corner with Southeast corner has loss of data, carries out supplementary angle calculating;
C, northwest angular data supplementary angle deviates 30 ° according to current X-axis centre coordinate point and calculates other coordinate points upwards, when every A coordinate points the last one mend central points until boundary to 270 ° of directions again;
D, southeast angular data supplementary angle deviates 210 ° according to current X-axis centre coordinate point and calculates other coordinate points downwards, when every A coordinate calculates to the half entirely gathered and mends central point until boundary to 90 ° of directions again;
E, after the coordinate points for calculating all full rectangles of covering, screening rejecting is carried out for extra data, passes through ground The boundary latitude and longitude coordinates of the administrative region that figure API is generated about administrative division are judged, if calculated longitude and latitude Degree then retains in the administrative region, is not at, rejects, obtains all valid data in the administrative region, seen by map It surveys, the last calculated regular covering of longitude and latitude data is in the area.
Preferably, the advertisement presentation unit is based on Android4.4.0 or more operating system, and core chips uses four cores Industrial level processor, dominant frequency 1.2GHz;The memory space of built-in 16GB;External support 128GB;Built in the advertisement presentation unit Bimodulus locating module, 4G the whole network lead to the wireless transport modules such as module, bluetooth, WIFI, it can be achieved that position, navigate, calling by cable, conversing, It swipes the card, evaluate, the functions such as reverse image, automobile data recorder;The single double ingot integral structures of advertisement presentation unit use, 7.1 Very little or 9 cun of high-definition display screens, resolution ratio 1024*600;It realizes touch key-press operation, is convenient for driver's passenger operation;The advertisement Display unit is additionally provided with the Peripheral Interfaces such as IO, CVBS, convenient for extension external equipment access.
Preferably, the advertisement presentation unit is house ads display screen, intelligent terminal APP, smart phone APP, CBD quotient Industry area display screen, house advertising display screen are any.
Preferably, the advertisement acquiring unit constantly moves in physical space, and longitude and latitude is sat where obtaining itself in real time Mark, and the network interface for submitting this system to provide is inquired, back office interface receives inquiry request, is used by API The advertisement that georadius method finds target position specific range periphery in cache farm server immediately is launched Coordinate points and advertisement id information, then the effective period of time for launching advertisement is inquired in database table, if this advertisement belongs to effective throwing It puts the period, then returns to advertisement presentation unit, after advertisement presentation unit obtains the information, by identifying advertisement type, play Advertising information.
The invention has the following advantages:
The present invention realizes an advertisement dispensing based on precise geographical coordinates, play system, including hardware, software portion Point, integrated level is high, and the function of each part has been accomplished best.Businessman can be according to the coordinate of physical world, specified Ad content of the period publication by audit, graph-text content is abundant, is precisely launched based on neighbouring businessman or region, Neng Gouji Big promotion advertisement dissemination.The effect of advertisement dispensing can be observed in real time in businessman, and the suitable period is selected to launch advertisement; Businessman can also bid the advertisement position of high-quality period, realize and precisely launch, promote advertising results.
Other than objects, features and advantages described above, there are also other objects, features and advantages by the present invention. Below with reference to figure, the present invention is described in further detail.
Detailed description of the invention
The attached drawing constituted part of this application is used to provide further understanding of the present invention, schematic reality of the invention It applies example and its explanation is used to explain the present invention, do not constitute improper limitations of the present invention.In the accompanying drawings:
Fig. 1 is system structure of the invention figure;
Fig. 2 is that advertisement of the present invention obtains timing diagram.
Specific embodiment
The embodiment of the present invention is described in detail below in conjunction with attached drawing, but the present invention can be limited according to claim Fixed and covering multitude of different ways is implemented.
A kind of grid advertisement intelligent supplying system based on geographical location, including advertisement display, advertisement acquiring unit With advertising information data maintenance system, the advertising information data maintenance system safeguards the advertisement position data based on grid, advertisement Position data are the geographic position datas based on honeycomb structure, and honeycomb structure is the round hexgonal structure of a class, effectively circle half 20 meters of diameter, be that 20 meters of six sides are constituted by side length, the distance between central point of each adjacent structure is 40 meters, multiple honeycombs Network constitutes the data basis that can launch advertisement position, chooses effective advertisement position and carries out advertisement dispensing, the number of position data Measure it is substantially stationary, for using data storage and query node pressure it is fully controllable, improve search efficiency;Advertisement is launched single Member is supplied to businessman or backstage personnel launch through the ad content after audit;It further include generating fundamental geological number for automating According to system and geo-spatial data create-rule.
The generation step of advertisement position data are as follows:
A, the longitude and latitude of 4 points is taken on plane map, which is four vertex of a rectangle, required gridding Region in the rectangular area that four points are formed, the longitude and latitude of the central point of rectangle is gone out according to the calculation of longitude & latitude of 4 points Degree evidence;
B, another point is calculated according to central point longitude and latitude, earth radius, terrestrial equator radius, azimuth, spacing distance Latitude and longitude coordinates calculate all coordinates met the requirements in X-axis using the center point coordinate of rectangle as the origin of reference axis Point calculates all coordinate points of the longitudinal axis according to the longitude and latitude and angle of all the points of X-axis, and resulting coordinate set is rectangle Interior criss-cross latitude and longitude coordinates collection, find after tested the coordinate set be rectangle in embedded parallelogram, northwest corner with Southeast corner has loss of data, carries out supplementary angle calculating;
C, northwest angular data supplementary angle deviates 30 ° according to current X-axis centre coordinate point and calculates other coordinate points upwards, when every A coordinate points the last one mend central points until boundary to 270 ° of directions again;
D, southeast angular data supplementary angle deviates 210 ° according to current X-axis centre coordinate point and calculates other coordinate points downwards, when every A coordinate calculates to the half entirely gathered and mends central point until boundary to 90 ° of directions again;
E, after the coordinate points for calculating all full rectangles of covering, screening rejecting is carried out for extra data, passes through ground The boundary latitude and longitude coordinates of the administrative region that figure API is generated about administrative division are judged, if calculated longitude and latitude Degree then retains in the administrative region, is not at, rejects, obtains all valid data in the administrative region, seen by map It surveys, it is possible to find the last calculated regular covering of longitude and latitude data is in the area.
The advertisement presentation unit is based on Android4.4.0 or more operating system, and core chips is using at four nuclear industry grades Manage device, dominant frequency 1.2GHz;The memory space of built-in 16GB;External support 128GB;Bimodulus built in the advertisement presentation unit positions Module, 4G the whole network lead to the wireless transport modules such as module, bluetooth, WIFI, it can be achieved that positioning, navigating, call by cable, converse, swipe the card, commenting The functions such as valence, reverse image, automobile data recorder;The single double ingot integral structures of advertisement presentation unit use, 7.1 cun or 9 cun High-definition display screen, resolution ratio 1024*600;It realizes touch key-press operation, is convenient for driver's passenger operation;The advertisement display is single Member is additionally provided with the Peripheral Interfaces such as IO, CVBS, convenient for extension external equipment access.
The advertisement presentation unit is house ads display screen, intelligent terminal APP, smart phone APP, CBD shopping centre exhibition It is any in display screen, house advertising display screen.
The advertisement acquiring unit constantly moves in physical space, obtains latitude and longitude coordinates where itself in real time, and mention The network interface for handing over this system to provide is inquired, and back office interface receives inquiry request, uses georadius method by API The advertisement for finding target position specific range (distance can be changed) periphery in cache farm server immediately is thrown Coordinate points and advertisement id information are put, then inquire the effective period of time for launching advertisement in database table, if this advertisement belongs to effectively Release time section, then return to advertisement presentation unit, after advertisement presentation unit obtains the information, by identifying advertisement type, This advertising information is played in situation appropriate.
Advertisement presentation unit is the complete display system that one or more screens are constituted, and is a set of with advertisement acquiring unit Complete system, advertisement display system belong to hardware components, and advertisement acquiring unit belongs to software section, and advertisement presentation unit uses Android or IOS operating system, the APP for being fitted to terminal completes the work that advertisement plays, by multimedia means abundant, The ad content of trade company is passed into user.
Businessman can carry out advertisement dispensing according to the period for launching place and selection advertisement broadcasting in this system, upload Ad content includes: the content vectors such as video, audio, text (being played by synthesis voice);Advertisement presentation unit provides position Data upload, the network interface that inquiry this system provides, that is, can return to and belong to current location and effective advertisement and play the wide of period Content is accused, advertisement presentation unit, which is selected a good opportunity, plays corresponding advertisement content.
Advertisement acquiring unit is the software APP program operated in this display unit equipment, be can control in equipment Other hardware such as camera, advertisement screen, ceiling light, meter and alarm can connect server log backstage, can call wide It accuses system background interface and obtains ad data.
(1) terminal user logs in
The logging in of terminal user can input service number in interface input box and log in, and can also use NFC with NFC induction zone Card, which is swiped the card, to be logged in.
(2) terminal user's homepage
After terminal user logs in successfully, the homepage of terminal user can be directly entered if the order not being carrying out, The relevant information of the service certification of current end user is shown on the left of home interface, map is used on the right side of home interface The current position of vehicle is shown, and every 5 seconds reporting positions by equipment to server, so as to whenever necessary for relevant departments Check vehicle driving trace.
Click " income " button on the left of home interface, it can be seen that operation number and total income, point on the day of terminal user " handing over to the next shift " button on the left of homepage is hit, log-in interface can be withdrawn into, terminal user completes to hand over to the next shift, and next time inputs service number or brush Nfc card can log in again.
(3) terminal user's advertisement broadcast interface
In terminal user's use process, the longitude and latitude of prelocalization is worked as according to driver end, was inquired every 4 seconds to server One time whether current location has advertisement, has, and is successively shown according to the mode of the type of advertisement pop-up box.Advertisement type is divided into Picture, text, audio and video, wherein whether picture, audio and video first determine whether file in driver end sheet before display Ground exists, and if so, do not need to download, if there is no then downloading and be saved according to the file address that server returns It is local, it then reads local file and shows and play.It is then to play to text-to-speech to multiply for copy Visitor listens.
Advertising information data maintenance system is made of four big practical function points, is that (backstage logs in data monitoring respectively Homepage), advertising management, businessman management, advertisement position maintenance etc. functions constitute.
(1) data monitoring
Data monitoring function includes the functions such as advertisement real-time data analysis, ad data chart, data on the 7th are newly-increased;
Advertisement real-time data analysis provides summarizing for the various information of whole system, including advertisement impressions, advertiser City numbers are opened in family's quantity, the quantity of advertisement position, advertisement trade gold specified number and advertisement, distinguish these with different colors Item of information allows background user to have the understanding of a totality to the increment of ad data.The user for logging in backstage also can choose Nearest one week, nearest January, the periods such as half a year retrieve the increments of nearest data, this data is in daily data summarization On the basis of unifiedly calculate and come out, combined data library inquiry sentence counts and is aggregated into different database tables, improves search efficiency.
Ad data chart area is that advertisement impressions to different cities, advertisement businessman are indicated by color histogram Number, advertisement bit quantity, the collect statistics of advertisement transaction amount, user can also according to nearest one week, nearest January, half a year etc. no The growth pattern of same period inquiry ad data, has one to get information about back-end data.
Data on the 7th are newly-increased can be by colored line chart come the advertisement impressions in 7 days to show different regions, advertisement Businessman's number, advertisement bit quantity, the growth pattern of advertisement transaction amount, background user can switch different cities and check data, These data are very big to the meaning of backstage operation.
(2) advertisement position is safeguarded: advertisement position maintenance is the function of an accurate honeycomb geodata of maintenance, and user uses This function can safeguard effective advertisement position, include 2 functions: newly-increased advertisement position deletes advertisement position.Effective advertisement position is just The geographic position data for being available to trade company's dispensing advertisement realizes layouting for advertisement on the basis of advertisement position.
2.1) advertisement position is increased newly:
Newly-increased advertisement position button is clicked, the line chart of square can be shown on map, it can be pulled, amplify contracting It is small.After user selectes advertisement position region, save button is clicked, the advertisement position in the region that user selects can be saved in database In, these advertisement positions become for available advertisement position.Specific implementation logic is broadly divided into three steps, step 1: by map side The longitude and latitude of four points in boundary goes database to look into basic information table and inquires all geo-spatial datas as parameter.Second Step: using the contains method of map object judge these basic data points either with or without in polygon line chart, if The point is saved in array object.The central point for being saved in array object is submitted to backstage, is saved in database table by third step In.
It clicks after saving, being saved in the available advertisement position of database can be shown on map, six sides drawn on map The drawing object of shape, invocation map API generates,
2.2) advertisement position is deleted
It clicks and deletes advertisement position button, the folding shape figure of square can be shown on map, background user can drag it It drags, zoom.After user selectes advertisement position region, save button is clicked, system is just by the advertisement position of user-selected area It is deleted from database table.Specific implementation logic is broadly divided into three steps, step 1: by the longitude and latitude of four points on map boundary line Spend the basic data advertisement site for going data base querying all as parameter.Step 2: utilizing the side contains of map object Method judges these basic data points either with or without in polygon line chart, if the point is saved in array object.Third step, The central point for being saved in array object is submitted to system background, is deleted from database table.
Clicking the available ad slots after saving on map will disappear.
2.3) switch city
Selection region combobox is clicked, the city to be switched is directly selected, it can be by the city of Map Switch to selection.Tool Body is embodied as the setCity method of invocation map API, and map can jump to the current city municipal government of selection after switching.
2.4) location finding
The lookup of position for the convenience of the user, increases location finding function, and user inputs the position to be searched in the search box It postpones, drop-down prompting frame can show that specific location, the desired place of user's selection, map can automatic jump to the position of user's selection It sets.The AMap.PlaceSearch object for being implemented as invocation map API scans for.
(3) businessman manages
Businessman management displayed page, the information of displaying include the number of businessman, Merchant name, business license, contract shine, Main business, merchant location etc. can intuitively be shown on the page, and user is facilitated to operate these data, Business Information default is successively sorted by creation time.Specific implementation is that inquiry number has been completed on backstage when page load According to operation, simultaneously being shown on the page in real time from the data found out in database when page display.
The query function of businessman's management: carrying out fuzzy matching inquiry to businessman's name, and text is inputted in text box and is clicked Inquiry can carry out key search to the text information inputted in text box, and show the number that keyword query goes out in lists According to, empty, empty retrieval column information.Specific implementation process is exactly that the field on column will be retrieved by inquiring the click event of button Backstage is passed to retrieve qualified item in the database as the matching condition of dimmed inquiry and show back to the page.
Businessman management newly-increased businessman: click the newly-increased businessman of menu bar, the series of data for filling in businessman such as: businessman Title, main business, contact method etc., and the business license and contract photograph of businessman are uploaded, and choose businessman on the map of right side Position can submit Business Information, and submitting successfully can see the businessman's data just submitted on the page that businessman manages.
The deletion of businessman's management: choosing corresponding businessman to click delete button, and determination is clicked in the dialog box of pop-up and is Business Information can be deleted.Here be the businessman that will be chosen id by click event pass to backstage, and as delete data information Condition, click confirmation when simultaneously delete the corresponding information of database, this information on the corresponding page is equally not It can show again.
Businessman's management correcting: clicking corresponding businessman and modify button, corresponding Business Information is modified in the page of pop-up, The Business Information modified can successfully be shown in merchant page by submitting, and be mentioned here and when submitting by Business Information It is sent to backstage, is shown after the complete data of database update in the page.
Businessman manages newly-increased advertisement: clicking newly-increased advertisement, advertising information, including advertised name, a surname can be added for businessman When passing language, advertisement type (picture, video, audio, text), the region for launching advertisement, advertising rates, period of coming into force, discount coupon The information such as section.Selection submits i.e. corresponding advertising information to be submitted to backstage and preservation in the database after having filled in, I.e. it can be seen that newly-increased advertising information in the advertising management page.
(4) advertising management
What the click advertising management page was shown is the advertising information of all publications, is arranged according to time inverted order, passes through page Face can be expressly understood that all information of advertisement, and can carry out corresponding operation to every advertisement.All advertising informations are all It is the data extracted from background data base when page load, all data have all carried out paging activity, on foreground It can choose the advertisement number of every page of display when page presentation, the advertising information etc. of lower one page is checked in page turning.
Clicking undercarriage can be this advertisement undercarriage, i.e. the corresponding advertisement position of undercarriage in the database, while using zrem Function deletes corresponding advertisement ID from cache farm server;The advertisement position that can also restore undercarriage in the database is real Existing advertisement position restocking again, while advertisement point longitude and latitude, the advertisement ID that will increase newly using geoadd function are added to cache In cluster server.All advertisement positions have entry-into-force time section, can automatic undercarriage more than the advertisement of effective period of time.
Corresponding advertising information can be modified in the advertising information page of pop-up by clicking modification advertisement, and clicking submission will phase The data answered be submitted to backstage and be saved in database, after can be in advertising information page real-time update advertising information. Former advertising information is deleted from cache farm server using zrem function, then by new advertisement latitude and longitude coordinates with And advertisement ID is inserted into cache farm server with geoadd function.
(5) geo-spatial data create-rule
Whole map grid data implementation method is as follows:
Pass through one rectangle covering of polygon editing machine editor on map, it is desirable that the rectangle, which is completely covered, to be needed to realize The region of map grid passes through the latitude and longitude coordinates on 4 vertex of the available rectangle of getBounds () of map API Then array passes through map API's by the southwestern coordinate (southWest) of the rectangle and northeast coordinate (northEast) SetBounds (new AMap.Bounds (southWest:LngLat, northEast:LngLat)) mode obtains in rectangle The heart point getCenter () coordinate.
The origin that the coordinate of obtained rectangular centre point is regarded as to a reference axis is parallel to the rectangle by this origin Two straight lines respectively as this reference axis X-axis (weft) Y-axis (warp).By the latitude and longitude coordinates of origin and known The angle of the central point distance 20m and X-axis of each grid and direct north calculates the center point coordinate of another grid.
Since it is known the latitude and longitude coordinates on four vertex of rectangle, the center point coordinate of rectangle, it can be deduced that central point arrives The latitude and longitude coordinates of two endpoints of the latitude and longitude coordinates on rectangle both sides, i.e. X-axis and Y-axis, by above-mentioned calculation, by origin All grid element center point coordinates met the requirements in X-axis can be calculated with 90 ° and 270 ° of angle of X-axis and Y-axis due north, arrive X Two endpoints calculating of axis terminates, and can get all grid element centers every 20m on the straight line of rectangle and origin Point latitude and longitude coordinates.
It obtains all latitude and longitude coordinates met the requirements in X-axis and passes through the similarly side of calculating on the basis of these coordinates Method changes the latitude and longitude coordinates that angle obtains other points.Here we are in order to be laid in grid on entire map, the angle taken It is to take 30 ° to go out all longitudes and latitudes for meeting condition with a 210 ° i.e. slope line calculations respectively for 0 ° of angle with the positive Beijiao of Y-axis to sit Mark, the same side to rectangle stop calculating, the available latitude and longitude coordinates in entire rectangular area.
After above-mentioned calculating is completed, if calculated all coordinate points are not paved with entire rectangle, but one is formed Parallelogram, the northwest corner of rectangle and southeast corner have partial data because of the reason of taking angle loss.Can get this parallel four Two bevel edges of side shape continue calculating to both sides respectively as benchmark and stop to obtain to the side of rectangle being paved with entire square The latitude and longitude coordinates of shape.
The administrative region boundary latitude and longitude coordinates that city province and region can be inquired by map API are sentenced by circulation Whether within this region, the point not in region excludes the point to break in all rectangles, just saving in region.It can be with It obtains us and wants all coordinate points in the region of gridding, all coordinate points every 20m, be by 6 angles (0 °, 60 ° to 360 °) point can be converted into regular hexagonal cell, finally calculated result rendering be can be realized ground on map Graph region the whole network is formatted, and using these data deposit database table as the basic data of available ad slots.
(6) advertisement geographical basis data generation system
All administrative information regions are obtained by way of the automatic invocation map interface in the backstage java, using txt text Mode stores the information of all administrative regions.By recycling each city administration at county level under different provincial region acquisitions provincial region The related data that map API obtains each administrative region is transferred using java process asynchronous operation these city's County Level Regionals in region, Store txt text file.By the boundary coordinate array of the available administrative region of the return value of interface, by traversing the seat Mark array obtains maximum longitude and latitude and minimum longitude and latitude in this array.
By the available 4 latitude and longitude coordinates point of combination, entire administrative region is just included.By can be calculated The centre coordinate point of this 4 latitude and longitude coordinates points out, that is, arrive the same coordinate points of the distance of this 4 points.Then it is automatic calculate and The geo-spatial data coordinate in this region is generated, and stores and arrives database.
(7) advertisement obtains query interface
This interface need to complete query task in conjunction with advertisement presentation unit and advertisement acquiring unit, and the upload of advertisement acquiring unit is worked as Preceding geographical coordinate namely longitude and latitude data, back office interface is further according to current latitude and longitude coordinates in cache farm server In by all advertisement ID data in 50 meters of (configurable) ranges of georadius functional query radius, according to advertisement ID and work as The preceding time goes data base querying to go out qualified advertising information, starts to obtain advertising resource after advertisement presentation unit parsing, obtain It takes into and starts to show that advertisement is then converted into voice and starts to play if it is text advertisements later.Backstage by call zrem and Geoadd function realizes deletion and newly-increased, the warp of advertisement position in the two-dimensional array of the longitude and latitude data of cache server cluster Latitude data is updated, and is realized the dispensing of advertisement position and is removed function.
Advertisement obtains timing diagram
1. registration logs in, 2. are logined successfully, 3. acquisition current geographic coordinates, 4. return coordinates, 5. submission coordinates, after calling Platform interface, 6. call api interface to search advertisement point coordinate, and 7. have found coordinate points, return to lookup result, 8. inquiry advertising times Section condition, 9. return it is matched as a result, 10. parsing query results, according to unified format return data, 11. analysis data types, Play advertisement;
(7) system architecture diagram
Different advertising terminal devices can be by data network connection to internet gateway, after logging on to ad system Platform cluster server, the ad data of longitude and latitude where obtaining.
This programme also may be implemented in various types of database programs based on geo index, and difference is only to inquire phase Like the speed of neighbour's coordinate and the convenience of maintenance coordinate points.Inquiry close on coordinate speed it is faster, more suitable fixation, movement or The terminal device of person's high-speed cruising is by submitting longitude and latitude data to return to ad spot information.The implementation that the present invention uses be Balance is reached in use cost and inquiry velocity, hardware-software configures most reasonable system.
(such as house ads display screen, intelligent terminal APP, the shopping centre smart phone APP, CBD are shown various terminal device Screen, house advertising display screen etc.) can be used as advertisement launch unit access this system, the present invention is not limited to the current institutes of this system The terminal device of use, as long as carrying GPS/ Beidou device or minimum requirements is capable of providing physical world coordinates and (is based on The coordinate of WGS-84 or GCJ-02 standard), internet can be accessed by 3G/4G/5G communication module, there is display screen device Movement or fixed terminal equipment all can access this system, complete advertisement coordinate point data pull and advertisement broadcasting function.
The above description is only an embodiment of the present invention, is not intended to limit the scope of the invention, all to utilize this hair Equivalent structure or equivalent flow shift made by bright specification and accompanying drawing content is applied directly or indirectly in other relevant skills Art field, is included within the scope of the present invention.

Claims (4)

1. a kind of grid advertisement intelligent supplying system based on geographical location, including advertisement display, advertisement acquiring unit and Advertising information data maintenance system, which is characterized in that the advertising information data maintenance system safeguards the advertisement position based on grid Data, advertisement position data are the geographic position datas based on honeycomb structure, and honeycomb structure is the round hexgonal structure of a class, Effective 20 meters of radius of circle is that 20 meters of six sides are constituted by side length, and the distance between central point of each adjacent structure is 40 meters, more A honeycomb mesh structure constitutes the data basis that can launch advertisement position, chooses effective advertisement position and carries out advertisement dispensing;
The generation step of advertisement position data are as follows:
A, the longitude and latitude of 4 points is taken on plane map, which is four vertex of a rectangle, the area of required gridding Domain goes out the longitude and latitude degree of the central point of rectangle according to the calculation of longitude & latitude of 4 points in the rectangular area that four points are formed According to;
B, another point longitude and latitude is calculated according to central point longitude and latitude, earth radius, terrestrial equator radius, azimuth, spacing distance Coordinate is spent, using the center point coordinate of rectangle as the origin of reference axis, calculates all coordinate points met the requirements in X-axis, root According to the longitude and latitude and angle of all the points of X-axis, calculate all coordinate points of the longitudinal axis, resulting coordinate set be in rectangle in length and breadth Staggered latitude and longitude coordinates collection finds that the coordinate set is the embedded parallelogram in rectangle, northwest corner and southeast corner after tested There is loss of data, carries out supplementary angle calculating;
C, northwest angular data supplementary angle deviates 30 ° according to current X-axis centre coordinate point and calculates other coordinate points upwards, when each seat Punctuate the last one mend central points until boundary to 270 ° of directions again;
D, southeast angular data supplementary angle deviates 210 ° according to current X-axis centre coordinate point and calculates other coordinate points downwards, when each seat Mark calculates to the half entirely gathered and mends central point until boundary to 90 ° of directions again;
E, after the coordinate points for calculating all full rectangles of covering, screening rejecting is carried out for extra data, passes through map API The boundary latitude and longitude coordinates of the administrative region generated about administrative division are judged, if calculated longitude and latitude is in Then retain in the administrative region, be not at, reject, obtains all valid data in the administrative region, observed by map, finally The calculated regular covering of longitude and latitude data is in the area.
2. the grid advertisement intelligent supplying system according to claim 1 based on geographical location, which is characterized in that described wide It accuses display unit and is based on Android4.4.0 or more operating system, core chips uses four nuclear industry level processors, dominant frequency 1.2GHz;The memory space of built-in 16GB;External support 128GB;Bimodulus locating module, 4G are complete built in the advertisement presentation unit The wireless transport modules such as Netcom's module, bluetooth, WIFI are, it can be achieved that positioning, navigating, calling by cable, conversing, swiping the card, evaluating, shadow of moving backward The functions such as picture, automobile data recorder;The advertisement presentation unit uses single double ingot integral structures, and 7.1 cun or 9 cun of high definitions are shown Screen, resolution ratio 1024*600;It realizes touch key-press operation, is convenient for driver's passenger operation;The advertisement presentation unit is additionally provided with The Peripheral Interfaces such as IO, CVBS, convenient for extension external equipment access.
3. the grid advertisement intelligent supplying system according to claim 1 based on geographical location, which is characterized in that described wide Announcement display unit is house ads display screen, intelligent terminal APP, the shopping centre smart phone APP, CBD display screen, house advertisement exhibition Display screen is any.
4. the grid advertisement intelligent supplying system according to claim 1 to 3 based on geographical location, which is characterized in that The advertisement acquiring unit constantly moves in physical space, obtains latitude and longitude coordinates where itself in real time, and submit this system The network interface of offer is inquired, and back office interface receives inquiry request, by API using georadius method immediately in height Coordinate points and advertisement id information are launched in the advertisement that target position specific range periphery is found in fast cache cluster server, then The effective period of time for launching advertisement is inquired in database table, if this advertisement belongs to effective release time section, returns to advertisement Display unit after advertisement presentation unit obtains the information, by identifying advertisement type, plays advertising information.
CN201711313134.9A 2017-12-09 2017-12-09 Grid advertisement intelligent pushing system based on geographic position Active CN109905452B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201711313134.9A CN109905452B (en) 2017-12-09 2017-12-09 Grid advertisement intelligent pushing system based on geographic position

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201711313134.9A CN109905452B (en) 2017-12-09 2017-12-09 Grid advertisement intelligent pushing system based on geographic position

Publications (2)

Publication Number Publication Date
CN109905452A true CN109905452A (en) 2019-06-18
CN109905452B CN109905452B (en) 2021-07-16

Family

ID=66942795

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201711313134.9A Active CN109905452B (en) 2017-12-09 2017-12-09 Grid advertisement intelligent pushing system based on geographic position

Country Status (1)

Country Link
CN (1) CN109905452B (en)

Cited By (7)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN110473006A (en) * 2019-07-26 2019-11-19 深圳市易售科技有限公司 A method of quickly generating advertising pictures
CN110553668A (en) * 2019-09-30 2019-12-10 重庆元韩汽车技术设计研究院有限公司 Error correction system and method for inertial navigation of intelligent driving
WO2020186698A1 (en) * 2019-03-15 2020-09-24 上海碧虎网络科技有限公司 Multimedia mobile following system based on vehicle positioning, and method
CN112579917A (en) * 2019-09-30 2021-03-30 百度在线网络技术(北京)有限公司 Information delivery method, device, equipment and medium
CN113298563A (en) * 2021-05-24 2021-08-24 杨军辉 Advertisement recommendation system based on boundary lamp
CN114254856A (en) * 2021-11-08 2022-03-29 武汉小安科技有限公司 Shared single-vehicle operation and maintenance scheduling method and system based on honeycomb map
CN114254856B (en) * 2021-11-08 2024-05-31 武汉小安科技有限公司 Shared single-vehicle operation and maintenance scheduling method and system based on honeycomb diagram

Families Citing this family (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
TWI813339B (en) * 2022-06-15 2023-08-21 中光電智能雲服股份有限公司 System and method for estimating the position of advertisement position based on telecommunication data

Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20050084329A1 (en) * 2002-02-20 2005-04-21 Caleb Myers Method of placing visible advertising
CN105046512A (en) * 2015-06-19 2015-11-11 长沙待霁电子科技有限公司 Intelligent positioning advertisement method
CN106097021A (en) * 2016-06-24 2016-11-09 上海碧虎网络科技有限公司 A kind of advertisement placement method based on hotspot map and system
CN106296274A (en) * 2016-08-03 2017-01-04 李立峰 A kind of method according to geographical location information positioning and directing advertisement putting
CN106600308A (en) * 2016-11-02 2017-04-26 深圳市智慧交通有限公司 Geographic location-based advertisement pushing method and system

Patent Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20050084329A1 (en) * 2002-02-20 2005-04-21 Caleb Myers Method of placing visible advertising
CN105046512A (en) * 2015-06-19 2015-11-11 长沙待霁电子科技有限公司 Intelligent positioning advertisement method
CN106097021A (en) * 2016-06-24 2016-11-09 上海碧虎网络科技有限公司 A kind of advertisement placement method based on hotspot map and system
CN106296274A (en) * 2016-08-03 2017-01-04 李立峰 A kind of method according to geographical location information positioning and directing advertisement putting
CN106600308A (en) * 2016-11-02 2017-04-26 深圳市智慧交通有限公司 Geographic location-based advertisement pushing method and system

Cited By (10)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
WO2020186698A1 (en) * 2019-03-15 2020-09-24 上海碧虎网络科技有限公司 Multimedia mobile following system based on vehicle positioning, and method
US11956491B2 (en) 2019-03-15 2024-04-09 Shanghai Bihu Network Technology Co., Ltd Multimedia mobile following system based on vehicle positioning, and method
CN110473006A (en) * 2019-07-26 2019-11-19 深圳市易售科技有限公司 A method of quickly generating advertising pictures
CN110553668A (en) * 2019-09-30 2019-12-10 重庆元韩汽车技术设计研究院有限公司 Error correction system and method for inertial navigation of intelligent driving
CN112579917A (en) * 2019-09-30 2021-03-30 百度在线网络技术(北京)有限公司 Information delivery method, device, equipment and medium
CN112579917B (en) * 2019-09-30 2023-10-17 百度在线网络技术(北京)有限公司 Information delivery method, device, equipment and medium
CN113298563A (en) * 2021-05-24 2021-08-24 杨军辉 Advertisement recommendation system based on boundary lamp
CN113298563B (en) * 2021-05-24 2024-05-03 杨军辉 Advertisement recommendation system based on border light
CN114254856A (en) * 2021-11-08 2022-03-29 武汉小安科技有限公司 Shared single-vehicle operation and maintenance scheduling method and system based on honeycomb map
CN114254856B (en) * 2021-11-08 2024-05-31 武汉小安科技有限公司 Shared single-vehicle operation and maintenance scheduling method and system based on honeycomb diagram

Also Published As

Publication number Publication date
CN109905452B (en) 2021-07-16

Similar Documents

Publication Publication Date Title
CN109905452A (en) A kind of grid advertisement intelligent supplying system based on geographical location
Spinney et al. Are you being shared? Mobility, data and social relations in Shanghai’s Public Bike Sharing 2.0 sector
Zhang et al. Exploring the impact of built environment factors on the use of public bikes at bike stations: Case study in Zhongshan, China
CN101763607B (en) Online exhibition platform system constructed by using panoramic electronic map and construction method thereof
DE60028088T2 (en) SYSTEM AND METHOD FOR MANAGING ADVERTISING AND INFORMATION DISPLAYS BASED ON AN E-COMMERCE WEBSITE ON VEHICLES
RU2544986C2 (en) Cell assignment in location selection based information supply systems
CN104767830B (en) The management method and device of information publication
US20060200311A1 (en) Enhanced imagery, such as for lead generation for service providers who provide services associated with real estate
CN103198385A (en) Interactive tourism information management system
CN102282556A (en) Providing digital content based on expected user behavior
CN105574712A (en) Interactive advisory system
CN106599137A (en) Novel scene content pushing system and device
CN103997505A (en) Method and device for recommending information of self-picking-up sites of business object
JP2007199921A (en) Advertising right bid management system
CN111832777A (en) Internet of things shopping system based on big data and using method
CN106097021A (en) A kind of advertisement placement method based on hotspot map and system
CN101639526A (en) Golf course gps navigation and management system
CN108182593B (en) Method and device for customizing bus body advertisement delivery route based on map data
CN108074114A (en) The method and device of virtual resource object is provided
CN102291421A (en) Vehicle-mounted mobile internet device (MID) precise advertisement interaction system
CN108305152A (en) A kind of remote control and the instrument of surveying and mapping management of leasing platform for collecting distant control function
CN110827724A (en) Intelligent signboard system
Madleňák et al. Digital advertising system in urban transport system of Žilina town
CN101639919A (en) Golf course advertisement operating system and operating method thereof
WO2012018174A2 (en) System for providing performance-viewing service using wireless mobile terminal and operation method thereof

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
GR01 Patent grant