JP2003295760A - Device for supporting cable television business in radio wave trouble area - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide a device for supporting cable television business in radio wave trouble area capable of automatically generating a list of radio wave trouble areas. <P>SOLUTION: A person in charge of business displays on a display device 15 a map of areas in the neighborhood of a radio wave trouble area, then specifies the radio wave trouble area on the map. When specified like this, a CPU 11 detects houses in the specified area using a housing DB 18. Next, the CPU 11 checks whether or not a house, among the detected houses, on which the data indicating 'inquiring', 'under construction', or 'construction completed' is written already exists in a subscriber DB 20. When such a house exists, the house is deleted, and the rest of the houses are listed and printed by a printer 16. <P>COPYRIGHT: (C)2004,JPO

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a cable television radio interference business support device for supporting a cable television subscriber acquisition business.

[0002]

2. Description of the Related Art When a high-rise building is newly constructed, there is a region (radio wave obstruction region) where the radio waves of television broadcasting do not fully reach because of the shadow of the building. Therefore, the construction company of the high-rise building requests the cable television station to wire the cable television in the radio interference region to compensate for the radio interference.

Conventionally, a cable television station requested to lay a cable television based on this radio interference first writes a line surrounding a radio interference region on a paper map, and then writes out the address and name of the house within the line. To create a list. Next, we will visit each house on the list one by one, hand over the permission request for the cable TV construction, and get a reply.

[0004]

By the way, there is a problem that the above list creation is very troublesome and that the list created only from the map includes the people who have already subscribed to the cable TV. . The present invention has been made in view of such circumstances, and an object thereof is to provide a cable television radio wave interference business support apparatus capable of automatically creating a list of radio wave interference areas.
Another object of the present invention is to provide a cable television radio disturbance business support device capable of automatically creating a list excluding houses that have already subscribed to cable television.

[0005]

The present invention has been made to solve the above-mentioned problems, and the invention according to claim 1 is a display means for displaying a map in the vicinity of the radio interference region.
The input means for inputting the radio interference area on the map displayed on the display means, the first database in which the address and owner name of each house and the latitude and longitude of the location are stored, and the input means Detecting means for detecting a house within the radio interference region based on the input radio interference region and the latitude and longitude of the house stored in the first database, and a list of homes detected by the detecting means And a printing means for printing the above.

The invention described in claim 2 is the same as claim 1
In the cable television radio disturbance business support device described in (1), the input means is a position coordinate input means for inputting a vertex position of a polygon indicating a radio interference area.

The invention described in claim 3 is the same as claim 1
Alternatively, in the cable television radio wave disturbance business support device according to claim 2, the detection means further includes a second database in which a house inquired of a cable TV, a house under construction, and a house already constructed are stored. The homes already registered in the second database are deleted from the homes detected based on the first database, and the result is output to the printing means.

[0008]

BEST MODE FOR CARRYING OUT THE INVENTION An embodiment of the present invention will be described below with reference to the drawings. FIG. 1 is a block diagram showing a configuration of a cable television radio disturbance business support device according to the embodiment, and FIG. 2 is a block diagram showing a schematic configuration of a cable television station 1 and a subscriber's home 2. In the subscriber's home 2 shown in FIG. 2, 3 is a television receiver and 4 is an HT.
(Home terminal). The HT 4 is composed of a tuner section, a video signal demodulation section, an audio demodulation section, a control section, etc., and outputs a video signal supplied from the cable television station 1 via the trunk line 5 and the drop line 6 to the television receiver 3. Further, an identification number is set in the internal memory, a channel selection signal transmitted together with the identification number is received from the cable television station 1, and the internal control unit automatically sets the receivable channel and the unreceivable channel. An STB (Set Top Box) may be used instead of the HT4.

Next, in the cable television station 1, reference numeral 7 denotes a head end facility, which is a set of devices between the receiving antenna 8 and the main cable 5. Specifically, demodulators, amplifiers, frequency converters, modulators, scramblers, upstream signal receivers, bidirectional modulators / demodulators, E / O / O
A / E converter, a power supply device, and the like. Reference numeral 9 is a viewing control device, which is an HT of each subscriber's home 2 via the head-end equipment 7.
4 to control the channel selection signal described above. A digital viewing control device may be used instead of the viewing control device 9. Reference numeral 10 is a cable television radio wave disturbance business support apparatus according to an embodiment of the present invention, the details of which will be described with reference to FIG.

In FIG. 1, reference numeral 11 is a CPU (central processing unit), 12 is a ROM (read only memory) in which a program used in the CPU is stored, 13 is a RAM (read only memory) for temporarily storing data, and 14
Is an operation unit such as a keyboard and a mouse, and 15 is a CRT
A (cathode ray tube) display unit or the like, and a printer 16 are provided. Reference numeral 17 denotes an interface, which mediates signal transmission / reception between the cable television radio wave disturbance business support device 10 and the viewing control device 9.

Reference numeral 18 is a housing DB (database),
The owner names and addresses of all houses within the broadcastable range of the cable television station 1 and the latitude and longitude of the houses are stored. Reference numeral 19 denotes a map DB, which is a map within the broadcastable range described above, and stores a map in which the main line arrangement, telephone pole positions, and amplifier positions are written. 20 is a subscriber DB
The following data are described for those who are inquiring about cable television subscription, those who have completed subscription work, and those who have completed electromagnetic interference countermeasure work. Name Address identification number Inquiry / subscribed construction completed / Data indicating radio wave interference construction completed

Next, the operation of the above-mentioned cable television radio wave disturbance sales support apparatus 10 will be described with reference to the flow chart shown in FIG. First, if there is an inquiry to join the cable TV, the cable TV radio interference business support device 1
An operator (or a sales person) of 0 inputs the address, name, and inquiring data of the person inquired through the operation unit 14 (step S1). When these data are input, the CPU 11 writes each input data in the subscriber DB 20, and newly determines and writes the identification number (step S2). Next, the CPU 11 determines that the house D
In B18, a record having the same address and name is searched, and the latitude and longitude of the record obtained as a search result are acquired (step S3).

Next, the CPU 11 reads out the map centered on the acquired latitude and longitude from the map DB 19 and displays it on the display unit 15 (step S4). FIG. 4 is a diagram showing an example of a map displayed on the display unit 15. In this figure, 30 is a house, 31 is a road, 32 is a cable trunk, and 33 is a utility pole. The house 30a of the cable television subscriber is displayed in the center of the screen. Although not shown in this figure, the position of the amplifier is also shown in the map DB19.
Is written in. Next, the CPU 11 causes the house 30
A yellow color indicating that a is being inquired is applied to a (step S5).
Here, the sales staff member looks at the map displayed on the display unit 15 and determines whether or not it is easy to lay an indoor service wire in the residence 30a of the applicant.

When the sales person determines that the above-mentioned indoor service line can be laid, the contract negotiation is proceeded thereafter.
Then, when the contract to subscribe to the cable TV is established, the construction is arranged, and when the construction arrangement is completed, the input of the construction arranged is made on the operation unit 14 (step S).
6). When this input is made, the CPU 11 makes the subscriber DB
Write data indicating that construction is in progress in step 20 (step S
7).

Next, when the construction is completed and the cable television can be received, the operator (or the sales person) inputs the construction completion (step S8). When this construction completion input is performed, the CPU 11 outputs the identification number of the owner of the construction completed house to the viewing control device 9 (step S9). The viewing control device 9 receives this identification number and sets the channel of the HT 4 of the house 2 for which construction has been completed. Next, the CPU 11 writes the data indicating that the construction is completed in the subscriber DB 20 and colors the house 30a in red indicating that the construction is completed (step S10). If the completed work was a cable TV work to prevent radio interference, it will be colored blue.

As described above, in the above-described embodiment, the houses on the map are colored in different colors depending on the status during the inquiry, the subscribing work, and the radio wave interference countermeasure work. Therefore, when the sales person displays the map, it is possible to know at a glance which house is being inquired and which house has been constructed, which is extremely useful in sales activities. Next, the operation of creating a list of radio-blocking houses during the construction of a high-rise building will be described with reference to the flowchart shown in FIG.

In this case, the sales person firstly operates the operation unit 1.
Input the address of the area where the radio wave is disturbed from 4, and then perform the key operation to instruct the map display. When this key operation is performed, the CPU 11 displays a map near the input address on the display unit 15 (step Sa1). FIG. 6 is an example of a map displayed on the display unit 15. In this figure, 40 indicates a house and 41 indicates a high-rise building. Now, assuming that the inside of the broken line L in this map is the radio interference region, the sales person successively positions the cursor on the vertices P1 to P8 of the polygon by the broken line L with the mouse and clicks, and doubles the final vertex P8. Click (Step Sa
2).

When the vertex position is input by the mouse, the CPU 11 converts the input vertices P1 to P8 into latitude and longitude by the house DB 18 (step Sa3). Next, the house within the range designated by the broken line L is detected (step Sa4). There are various detection methods, and for example, the detection is performed as follows. That is, in FIG. 7, first, the straight lines K1, K4,
A house in the area surrounded by I1 and I4 is detected.
This detection is performed with longitudes between K1 and K4 and latitudes I1 and I4.
This is done by searching the house DB 18 for houses between 4 and 4. Next, from the houses detected by the above, the houses whose longitude is between K1 and K2 and whose latitude is between I2 and I4 are removed, and then the house whose longitude is between K2 and K3 and whose latitude is I3.
Eliminate the housing between I4 and I4.

Next, the CPU 11 executes the above-mentioned step S.
In the housing obtained by a4, the subscriber DB 20
It is checked whether or not there is a house in which the data indicating that it is being inquired, under construction or under construction is written, and if there is, the house is deleted (step Sa5). Next, CPU
11 newly registers the houses remaining as a result of the processing in step Sa5 in the subscriber DB 20 (step Sa6), and then colors those houses in the map DB 19 in yellow indicating that they are in the process of being inquired (step Sa7). Next, step Sa
4. The printer 16 prints a list in which the address, owner name, identification number, etc. of each house, which are obtained by the processing of Sa5, are written together (step Sa8).

The sales staff visits the houses in the list one by one, hands over the permission request for the cable TV construction, and receives a reply. Then, for the houses that received the response form, we will make arrangements for construction in sequence.

[0021]

According to the first aspect of the present invention, it is possible to automatically create a list of radio interference regions. According to the third aspect of the invention, it is possible to automatically create a list excluding houses that have already subscribed to cable television, houses that are in the process of subscription, and houses that are under subscription work.

[Brief description of drawings]

FIG. 1 is a block diagram showing a configuration of a cable television radio interference business support device according to an embodiment of the present invention.

FIG. 2 is a block diagram showing a cable television station and a subscriber's house using the same cable television radio disturbance business support device.

FIG. 3 is a flowchart showing an operation of the same cable television radio disturbance business support device.

FIG. 4 is a diagram showing an example of a map display in the same flowchart.

FIG. 5 is a flow chart showing an operation of creating a list of radio interference regions in the same cable television radio interference sales support device.

FIG. 6 is a diagram for explaining the radio interference region.

FIG. 7 is a diagram for explaining a process of detecting a house in the radio interference region.

[Explanation of symbols]

1 ... Cable TV station 2 ... Subscriber's house 4 ... HT (Home Terminal) 5 ... Main line 7 ... Headend equipment 9 ... Viewing control device 10 ... Cable TV radio wave interference sales support device 11 ... CPU 12 ... ROM 18 ... Housing DB (database) 19 ... Map DB 20 ... Subscriber DB

Claims (3)

[Claims] 1. A display unit for displaying a map in the vicinity of the radio interference region, an input unit for inputting the radio interference region on the map displayed on the display unit, an address of each house, an owner's name and a location. Within the radio interference region based on a first database in which the latitude and longitude of the house are stored, and the radio interference region input by the input means and the latitude and longitude of the house stored in the first database. 2. A cable television radio wave obstruction sales support apparatus comprising: a detection unit that detects the house of claim 1; and a printing unit that prints a list of the houses detected by the detection unit. 2. The cable television radio wave interference business support apparatus according to claim 1, wherein the input means is position coordinate input means for inputting apexes of a polygon indicating a radio interference area. 3. A second database in which a house under inquiry for a cable television, a house under construction, and a house under construction is further stored, and the detection means detects based on the first database. 3. The cable television radio wave obstruction business support apparatus according to claim 1 or 2, wherein the house already registered in the second database is deleted from the house and the result is output to the printing unit. .