JP2004062248A - Administrative operation support system - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To easily grasp information residents and a household by using the relation of an address to a geometrical position. <P>SOLUTION: A resident information providing server 10 reads out a map of a kind specified by a user of a client terminal 12 among a plurality of kinds of mutually different maps registered on a map database server 7, arranges household icons at coordinates, corresponding to addresses of respective households read out of a resident database server 5, on the read map, and displays them on the client terminal 12. Further, when the user specifies a household icon on the map displayed on the client terminal 12, the resident information providing server 10 reads information on the household of the specified household icon out of a resident's card database 2, a household database 3, etc., and displays it on the client terminal 12. <P>COPYRIGHT: (C)2004,JPO

Description

[0001]
TECHNICAL FIELD OF THE INVENTION
The present invention relates to an administrative work support system that assists in collecting and grasping information on inhabitants and households in relation to geographical attributes of addresses, which is necessary for performing administrative work.
[0002]
[Prior art]
2. Description of the Related Art In recent years, with the progress and spread of information electronic technology, various administrative work support systems that support administrative work using information electronic technology have been introduced to local governments and the like.
Usually, the management of the resident information in these administrative work support systems is often performed using a database in which the items entered in the basic register of each resident follow the management of the traditional resident register. In other words, in the conventional administrative work support system, the items registered in the basic ledger of each resident are made into a database as data, and using this database, it is possible to search for database registration data using each data registered in the database as a key. I have. For example, according to such an administrative work support system, by searching a database using an address as a key, the names and addresses of a plurality of residents having an address at a specific street in a specific town are searched and output. be able to.
[0003]
[Problems to be solved by the invention]
Here, in administrative work, there is a case where it is desired to collect or grasp information on residents and households in relation to the geographical position of the addresses of residents and households. For example, when considering the establishment of a new children's park at a certain point, in order to explore the necessity of setting up a children's park at that point, how many children are within a predetermined distance from the point of the children's park For example, if you want to check if you live. Since the geographical range in such a case does not match the administratively determined range of address division, it is not possible to directly collect information on the intended inhabitants from the aforementioned database.
[0004]
In other words, according to the conventional administrative work support system, a great deal of labor is required to collect and grasp information on residents and households in relation to the geographical location of the addresses of residents and households. There was a problem that there is.
Therefore, an object of the present invention is to provide an administrative work support system capable of supporting collection and understanding of information on residents and households in relation to the geographical location of the addresses of residents and households.
[0005]
[Means for Solving the Problems]
In order to achieve the above object, the present invention provides an administrative work support system for supporting acquisition of information on a resident or a household in an administrative body, a map storing map data representing a map within a geographical area controlled by the administrative body. A database, a resident database storing attribute information including at least an address of the inhabitants or the household, and indicating correspondence between an address in a geographical range controlled by the administrative body and a geographical position to which the address is assigned. An address database storing address geographical location information, map image generating means for generating a map image represented by map data stored in the map database, and each resident obtained by referring to the resident database and the address database Alternatively, a predetermined mark may be drawn at a position on the map image corresponding to a geographical position corresponding to a household address. A mark display the map image generation unit for generating a click display map image, in which a display means for displaying the mark display map image.
[0006]
According to such an administrative work support system, an address database storing address geographical position information indicating a correspondence between an address within a geographical area under the jurisdiction of the administrative body and a geographical position to which the address is assigned is provided. By providing this, the attribute information of the residents or households stored in the residents database is integrated with the map represented by the map data stored in the map database, and presented as a mark display map image showing the residents or households on the map with marks. can do. Therefore, the user can directly grasp the inhabitants and the household in relation to the geographical position of the address from the mark display map image. In addition, the method of associating an address with a geographical location using such an address database is different from the method of associating a geographical location directly with a resident or a household. This is an efficient method that can easily respond to new residence of residents at an address that does not exist.
[0007]
Here, in such an administrative work support system, the map database stores a plurality of different types of map data that represent maps within a geographical area under the jurisdiction of the administrative body. A plurality of types of map data stored in the map database; and a map selection receiving unit for receiving selection of at least one type, wherein the map image generating unit stores the map selection stored in the map database. It is preferable to generate a map image represented by the type of map data received by the receiving unit.
[0008]
By doing so, the user can grasp the inhabitants and households from a geographical point of view on a map of a type suitable for his / her own purpose. In addition, by performing the work while switching the map type, it is possible to grasp the inhabitants and households from various viewpoints.
[0009]
Further, in these administrative work support systems, a mark designation receiving unit that receives designation of the mark on the mark display map image displayed by the display unit, and the resident corresponding to the mark received by the mark designation receiving unit. Alternatively, it is desirable to provide a resident information presenting means for searching attribute information of the household from the resident database and displaying the searched attribute information.
[0010]
By doing so, the user can immediately access the attribute information of the inhabitants and the household focused on in relation to the geographical position in the mark display map image directly from the mark display map image.
Further, further provided is a search condition specification receiving means for receiving a specification of a search condition of the attribute information from a user, wherein the mark display map image generating means is obtained by referring to the resident database. A predetermined mark is drawn only on the inhabitants or households having attribute information that matches the search condition for which the specification has been accepted, at the position on the map image corresponding to the geographical position corresponding to the address of each inhabitant or household. It is also preferable to generate a mark display map image.
[0011]
By doing so, the user can extract the desired inhabitants or households from a desired viewpoint, and grasp the geographical distribution of the extracted inhabitants or households on a map.
Further, these administrative work support systems include an area designation receiving means for accepting designation of an area on the mark display map image displayed by the display means, and an area on the map image accepted by the area designation accepting means. Calculate the geographical area corresponding to the, referring to the address database and the inhabitants database, the statistics of the inhabitants or households having as attribute information the address corresponding to the calculated geographical location in the geographical area, Statistical display means for calculating and displaying based on attribute information of residents or households may be provided.
[0012]
By doing so, the user can obtain the statistics of the residents or households in the area only by selecting the area on the map.
In addition, these administrative work support systems include a statistical object designation receiving unit that receives a selection of a value to be a statistical object from a plurality of values obtained from the attribute information, and divides the map image into a plurality. For each of the regions, a geographical region corresponding to the region is calculated, the address database and the inhabitant database are referred to, and a resident or a household having an address corresponding to a geographical position in the calculated geographical region as attribute information. Statistical value calculating means for calculating the statistical value of the value selected by the statistical object designation receiving means based on the attribute information of the inhabitants or the household; and the statistical value for each area obtained by dividing the map image into a plurality. A statistical map displaying means for generating and displaying a statistical map representing the geographical distribution of the statistical values calculated by the calculating means may be provided.
[0013]
This makes it possible to obtain the geographical distribution of statistical values in the form of a statistical map for desired values obtained from attribute information of residents or households.
[0014]
BEST MODE FOR CARRYING OUT THE INVENTION
Hereinafter, embodiments of the present invention will be described.
FIG. 1 shows a configuration of the administrative work support system according to the present embodiment.
Here, the administrative work support system in the present embodiment is a system that supports administrative work of a local government. As shown in the figure, the administrative work support system includes a resident database server 5 having a resident card database 2, a household database 3, and a service management database 4, a map database server 7 having a map database 6, and a print server. 8 and a resident information providing server 10 having an address coordinate conversion table 9, and these servers are connected by a backbone LAN 11. The resident information providing server 10 and a client terminal 12 such as a personal computer used by a user are connected by a user LAN 13.
[0015]
Note that the resident database server 5, the map database server 7, the print server 8, and the resident information providing server 10 are actually an external storage device such as a CPU, a main memory and a hard disk device, an input device such as a keyboard and a pointing device, and a display. It may be a computer having a general configuration provided with a device and a network interface. In this case, the functions and components of each server described below are such that the CPU executes a program loaded from the external storage device to the main memory. When executed, it is realized as a process embodied on an electronic computer. In this case, the above program may be provided to a computer from a portable storage medium such as a CD-ROM or a communication medium and stored in an external storage device or the like. Further, the above-mentioned resident database server 5, map database server 7, print server 8, and resident information providing server 10 may be constructed on a single computer.
[0016]
Next, the data stored in each of the above databases and the address coordinate conversion table 9 will be described.
First, as shown in FIG. 2A, the resident card database 2 has a resident card record 201 provided for each resident of the local government, and each record includes a resident ID used for identification of the resident in the administrative work support system, Information such as the resident's card code, name, date of birth, gender, identification of head of household, family register, date of transfer, address, and voting rights, etc., which are the items described in the resident card of the relevant resident are described. I have.
[0017]
Next, as shown in FIG. 2B, the household database 3 has a household record 202 provided for each household of the local government, and each household record 202 has a household ID and a household ID used for identification of the household in the administrative work support system. In addition, a householder resident ID, which is a resident ID of a resident of the householder of the household, and a resident ID of a resident other than the householder of the household are described.
[0018]
As shown in FIG. 2C, the service management database 4 has a service management record 203 provided for each service provided by the local government to the residents, and each service management record 203 has a service ID which is the ID of the service. The ID, the name of the service, the address of the service providing base, and the resident ID of the resident who receives the service are described. For example, in the administrative work support system, when managing the services of ** kindergartens operated by a local government, ** a service management record 203 having a service name of kindergarten is provided, and an appropriate service ID is assigned to this service management record 203. And the address of the ** kindergarten and the resident ID of the resident who is a child of the ** kindergarten.
[0019]
As shown in FIG. 2D, the address coordinate conversion table 9 has a coordinate record 204 provided for each address in the local government. The coordinate record 204 includes the address and the center point of the area corresponding to the address. Geographical latitude and longitude coordinates are described. However, instead of the center point of the area corresponding to the address, the coordinate record 204 may describe geographical longitude and latitude coordinate information indicating the shape and geographical position of the area itself corresponding to the address.
[0020]
Finally, as shown in FIG. 2E, the map database 6 is a database that stores various map data of the local government. The map data stored in the map database 6 includes topographic map data representing a topographic map, local government data, and the like. House map data representing a residential map, disaster prevention map data representing a municipal disaster prevention map, city planning map data representing a municipal city planning map, road map data representing a municipal road map, and sewage representing a municipal sewage map There are map data, etc.
[0021]
Next, FIG. 3 shows the internal configuration of the resident information providing server 10.
As shown, the resident information providing server 10 includes a GUI control unit 111 that provides a GUI to the user of the client terminal 12, a main control unit 112 that controls the entire resident information providing server 10, and a print server 8. A print client unit 113 for requesting printing, a database client unit 114 for requesting the map database server 7 or the resident database server 5 to search and supply database storage data, a map drawing unit for drawing a map image and generating a map layer 115, an icon object generation unit 116 that draws icons representing residents, households, and service bases on a map to generate an icon layer, a synthesis processing unit 117 that generates an icon display map image obtained by synthesizing the icon layer on the map layer, , With an object table 118
[0022]
Here, in the object table 118, as shown in FIG. 4, for each icon drawn by the icon object generation unit 116, an icon indicating a service base, whether the icon is an icon indicating a household or an icon indicating a household, is displayed. Icon type indicating the identity of the icon, the longitude and latitude coordinates of the address of the resident or household or service base corresponding to the icon, the display coordinates which are the coordinates on the icon layer on which the icon is drawn, the resident ID or household of the icon corresponding to the icon. The household ID or the service ID of the service base is stored.
[0023]
Hereinafter, the operation of such an administrative work support system will be described.
FIG. 5 shows a procedure of processing performed by the main control unit 112 of the resident information providing server 10. First, when the user logs in to the resident information providing server 10 using the client terminal 12, the main control unit 112, which has received the login via the GUI control unit 111, performs a predetermined authentication with the user of the client terminal 12. The process is performed (step 501). If the authentication is successful, the GUI control unit 111 causes the client terminal 12 to transmit a map designation reception screen (step 502), and causes the client terminal 12 to display the screen. Then, on the map designation reception screen, selection of a map type and a map display area is received (step 503). Also, the household and service are set as target objects (step 504).
Here, FIG. 6 shows a map designation reception screen transmitted from the resident information providing server 10 and displayed on the client terminal 12.
[0024]
As shown in the figure, on the map designation reception screen, selection of a map type and a map display area is received from a user using the client terminal 12 using pop-up menus 601 and 602. As the map type, selection of one of the map types stored in the map database 6 is accepted. In addition, as the display area, a selection of one area from several areas set in advance based on administrative divisions or the like is received by selecting a name representing the area.
[0025]
When the user selects a map type and a display area and operates an OK button 603, the client terminal 12 transmits information on the selected map type and display area to the resident information providing server 10. The main control unit 112, which has received the selected map type and display area via the GUI control unit 111 (step 503), outputs the selected map type to the map database server 7 via the database client unit 114. By requesting the map data in the selected display area, the map data in the display area of the type of map is obtained from the map database 6 (step 505).
[0026]
Next, the main control unit 112 refers to the address coordinate conversion table 9 to find an address having latitude and longitude coordinates in the area corresponding to the selected display area, and, through the database client unit 114, obtains each address. (Step 506). That is, at the time of the first execution of this step, since the household and the service are set as the target objects, a search of the household ID of the household having the obtained address from the household database 3 and each obtained address is set as the service base address. By requesting the inhabitants database server 5 to search for the service ID from the service management database 4, the household ID of a household living in the area corresponding to the selected display area and the area corresponding to the selected display area To obtain the service ID of the service whose service base is located within. Then, the correspondence between the obtained ID of the target object, the icon type indicating the type of the target object, and the longitude and latitude coordinates of the address of the corresponding object is stored in the object table 118 (step 507). That is, at the time of the first execution of this step, the household ID and the service ID are obtained. Therefore, for each of the obtained household IDs, the correspondence between the icon type representing the household, the latitude and longitude coordinates of the address of the corresponding household, and the household ID is used. Is stored in the object table 118, and for each of the obtained service IDs, the correspondence between the icon type representing the service, the longitude and latitude coordinates of the address of the corresponding service base, and the service ID is registered.
[0027]
Then, the map drawing unit 115 generates a map layer in which a map image of the map represented by the obtained map data is drawn (step 508), and the icon object generation unit 116 stores information on the geographical coordinate range of the map image drawn. Then, an icon layer in which icons corresponding to the respective entries of the object table 118 are drawn is generated (step 509). That is, the icon object generation unit 116 refers to the geographical coordinate range of the map image, and, for each entry registered in the object table 118, when the icon type of the entry is household, the history described in the entry. A household icon of a predetermined shape representing a household is drawn at coordinates on the icon layer corresponding to coordinates on the map image of the map layer corresponding to the degree coordinates. If the icon type of the entry is service, the icon is described in the entry. If a service base icon of a predetermined shape representing a service base is drawn at coordinates on the icon layer corresponding to the coordinates on the map image of the map layer corresponding to the longitude and latitude coordinates, and the icon type of the entry is a resident, An icon that matches the coordinates on the map image of the map layer corresponding to the latitude and longitude coordinates described in the entry The coordinates on the tire to draw the resident icon of a predetermined shape representing residents. In each entry, the coordinates on the icon layer where the icon corresponding to the entry is drawn are registered as the display coordinates.
At the time of the first execution of this step, since only the entries of the household and service icon types exist in the object table 118, an icon layer in which the household icon and the service base icon are drawn is generated. .
[0028]
Then, the main control unit 112 causes the combination processing unit 117 to combine the map layer and the icon layer generated in this manner (step 510), and causes the icon display map image to be generated.
Here, FIG. 7 schematically shows how such an icon display map image is generated.
As shown in the figure, the icon display map image c is displayed on a map layer b of a map image represented by map data arbitrarily selected by the user from a plurality of types of map data stored in the map database 6. An icon representing a base is generated by synthesizing an icon layer a drawn on a map so as to be located at a position corresponding to the address. As described above, in the present embodiment, the user selects an appropriate type of map according to the purpose, and the icon display map image in which the icons of the residents, households, and service bases are arranged on the selected type of map. Can be generated.
[0029]
Next, the main control unit 112 causes the GUI control unit 111 to transmit a map display screen including the generated icon display map image to the client terminal 12 (step 511), and causes the client terminal 12 to display the map display screen.
FIG. 8 shows a map display screen displayed on the client terminal 12 in this manner.
As shown, the map display screen includes a map display area 801 for displaying an icon display map image, and an operation receiving area 802 for receiving a user operation.
Further, in the icon display map image when the household and the service are set as the target objects, such as the icon display map image displayed first, the icon display map image is selected based on the type of the map selected by the user. On the map of the area corresponding to the displayed display area, a household icon (star mark in the figure) indicating the position of the household and a service base icon (hexagonal mark in the figure) indicating the service base are displayed. It has become.
[0030]
On the other hand, the operation reception area 802 is provided with a direction button 852 for changing the display area of the icon display map image without changing the scale, and a scale change pull-down menu 853 for changing the map scale of the icon display map image. Have been.
In the operation reception area 802, a tool box 854 including a plurality of tool buttons 861 to 866 for receiving an information provision instruction from the user on the icon display map image, an add button 855, a list print button 856, A clear button 857, an end button 858, and a map change button 870 are provided.
[0031]
When the direction button 852 or the scale change pull-down menu 853 is operated by the user, the main control unit 112 that has received the operation via the client terminal 12 and the GUI control unit 111 (step 512) displays the display area according to the content of the operation. Is changed, and the above-described processes of steps 505 to 511 are performed to update the icon display map image displayed on the map display screen so that the scale and the display area are changed according to the operation.
[0032]
On the other hand, when the tool buttons 861 to 866 of the tool box 854 are operated (step 513), processing corresponding to the operated tool button is performed (step 519). When the add button 855 is operated (step 514), for example, the household ID or the resident ID registered in the object table 118 corresponding to the icon selected at that time is added to the output target ID. Processing is performed (step 520). When the print list button 856 is operated (step 515), the database client unit 114 outputs predetermined types of information, such as household and resident addresses and names corresponding to the output target ID, to the resident database server 5. And prints the obtained information from the print server 8 via the print client unit 113 (step 521).
[0033]
When the clear button 857 is operated (step 516), the process returns to step 504 to perform the above processing. When the map change button 870 is operated (step 517), selection of one of the map types stored in the map database 6 is accepted, and the selected type is selected from the map database 6. By retrieving map data within the currently displayed map range and returning to the processing of step 508, the type of map to be displayed on the map display screen is changed (step 522). Then, when the end button 858 has been operated (step 518), the processing ends.
[0034]
Hereinafter, the processing performed in step 519 for each tool button of the tool box 854 will be described.
In the tool box 854, a square tool 861, a circular tool 862, a polygon tool 863, a distribution map tool 864, a selection tool 865, and a search tool 866 are prepared as tool buttons.
First, a process performed when the selection tool 865 is operated will be described.
As illustrated in FIG. 8, when the selection tool 865 is selected by the cursor 810 (a), the GUI control unit 111 uses the cursor 810 to operate the household icon, the resident icon, or the service base icon according to the operation of the client terminal 12 by the user. Is received (b), and the selected icon 800 is received.
Is updated to the form indicating the selected state, and the household ID, the resident ID, or the service ID registered in the object table 118 corresponding to the received icon is transferred to the main control unit 112. More specifically, the GUI control unit 111 compares the coordinates of the cursor 810 at the time of clicking with the display coordinates registered in the object table 118, and has display coordinates that are closer to the coordinates of the cursor 810 by a predetermined level or more. If the entry exists, the household ID, the resident ID, or the service ID registered in the entry is transferred to the main control unit 112.
[0035]
When the household ID is delivered, the main control unit 112 uses the household database 3 and the resident card database 2 to the resident database server 5 via the database client unit 114, and uses the household database 3 and the resident card database 2 to obtain information on the household of the delivered household ID. Requesting a search for information on the residents belonging to the household and the information on the address of the household corresponding to the household icon clicked by the user, information on the names of the members of the household, etc. Is displayed in the form of a household information display window 811 on the client terminal 12 via the GUI control unit 111. When the selection of the name of the household member by the cursor 810 is accepted on the household information display window 811 (c), the resident card database 2 and the service management are transmitted to the resident database server 5 via the database client unit 114. By requesting the database 4 to search for information such as the gender, date of birth, and service name of the service being received corresponding to the received household member's resident ID, the selected household configuration The information of the resident who is a member is obtained, and the obtained information of the resident is displayed in the form of a resident information display window 812 on the client terminal 12 via the GUI control unit 111.
[0036]
In addition, as described later, in this embodiment, an image in which a resident icon which is an icon representing a resident as shown in FIG. 10 is displayed on the map image as the icon display map image may be generated. In this case, When the user selects the resident icon 804 with the cursor 810 (d), the main control unit 112 to which the resident icon has been passed from the GUI control unit 111 transmits the resident icon to the resident database server 5 via the database client unit 114. By requesting the user to search for information such as the gender, date of birth, and service name of the service received corresponding to the transferred resident ID using the resident card database 2 and the service management database 4, Information of the resident corresponding to the resident icon selected by the The information, via the GUI control unit 111, to the client terminal 12, display in the form of resident information display window 812.
[0037]
By the way, when the add button 855 is operated by the user in the state where the household icon or the resident icon is selected by the user in this way, the main control unit 112 responds to the household icon selected at that time. The household ID or the resident ID is added to the output target ID.
[0038]
In the state where the household icon and the resident icon are selected by the user in this way, the main control unit 112 selects another tool button by the user, or selects another household icon or the resident icon by the selection tool 865. Is selected, the household information display window 811 and the resident information display window 812 are deleted. In addition, the GUI control unit 111 restores the display mode of the household icon and the resident icon that have been selected and displayed in the mode indicating the selected state.
[0039]
Now, as shown in FIG. 9, the operation of the main control unit 112 when the service base icon 803 is selected by the cursor 810 by the selection tool 865 (a) and the service ID is delivered is as follows.
First, the main control unit 112 acquires the service name corresponding to the delivered service ID from the service management database 4 via the resident database server 5. Then, a search window 813 is displayed to select whether to search for a resident of a recipient of the service corresponding to the delivered service ID or to search for a household to which the recipient of the service corresponding to the delivered service ID belongs. Is received from the user via the GUI control unit 111 and the client terminal 12.
[0040]
When the search for a household is selected by the cursor 810 (b), the entry of the household ID and the resident ID registered in the object table 118 is deleted, and the target object is replaced with the service ID of the delivered service ID. The address set in the service receiver's household and the service, and the address having the longitude and latitude coordinates in the area corresponding to the display area are obtained by referring to the address coordinate conversion table 9, and each of the obtained addresses is obtained via the database client unit 114. Obtain the ID of the target object having. In this case, since the target household and the service household of the service with the delivered service ID are set as the target objects, each of the obtained addresses using the service management database 4 and the household database 3 is held as an address, and is delivered. A search for a household ID in which the residents who have received the service of the service ID obtained as a household member and a search for the service ID having each obtained address as a service base address from the service management database 4 are performed by the resident database server 5. To obtain a household ID and a service ID corresponding to the target object. For each of the obtained household IDs, the correspondence between the icon type representing the household, the latitude and longitude coordinates of the address of the corresponding household, and the household ID is stored in the object table 118, and the service is obtained for each of the obtained service IDs. The correspondence between the icon type to be represented, the longitude and latitude coordinates of the address of the corresponding service base, and the service ID is stored in the object table 118.
[0041]
Then, the icon object generating unit 116 draws an icon according to the object table 118, generates an icon layer, and displays, in an entry of the object table 118, a display coordinate of a coordinate on the icon layer in which an icon corresponding to the entry is drawn. Registration. Further, the main control unit 112 controls the combination processing unit 117 and the GUI control unit 111, and replaces the icon display map image displayed on the map display screen in the client terminal 12 with the icon layer used so far. Update to the one using the newly generated icon layer.
[0042]
As a result, as shown in the map display area 801 of FIG. 9, the icon display map image displayed on the map display screen includes the service base icon and the recipient of the service provided by the service base 803 selected by the user. It is updated to the one where the household icon of only existing households is displayed.
[0043]
On the other hand, if the search window 813 selects to search for a resident by the cursor 810, the entry of the household ID and the resident ID registered in the object table 118 is deleted, and the target object is replaced with the delivered service. The service is set for the recipient of the ID service and the service, and the address having the longitude and latitude coordinates in the area corresponding to the display area is obtained by referring to the address coordinate conversion table 9, and is obtained via the database client unit 114. The ID of the target object having each address is obtained. Here, as the target object, the recipient's resident and the service of the service of the delivered service ID are set, and therefore, each of the obtained addresses using the service management database 4 and the resident's card database 2 is held as the address, and is delivered. By requesting the resident database server 5 to search for the resident ID of the resident receiving the service of the obtained service ID and to search the service management database 4 for the service ID having each obtained address as the service base address, Obtain the household ID and service ID corresponding to the target object. For each of the acquired resident IDs, the correspondence between the icon type representing the resident, the longitude and latitude coordinates of the address of the corresponding resident, and the resident ID is stored in the object table 118, and for each of the acquired service IDs, the service is described. The correspondence between the icon type to be represented, the longitude and latitude coordinates of the address of the corresponding service base, and the service ID is stored in the object table 118.
[0044]
Then, the icon object generation unit 116 draws an icon according to the object table 118, generates an icon layer, and displays, in an entry of the object table 118, a coordinate on the icon layer in which an icon corresponding to the entry is drawn. Registration. Here, the icon object generating unit 116 draws a resident icon that is a predetermined icon representing the resident (for example, a heart-shaped icon shown in FIG. 10) for the entry of the resident of the icon type. Here, when there are a plurality of entries of the same longitude and latitude coordinates, the resident icons corresponding to these entries are drawn with their positions slightly shifted so as not to overlap each other. Alternatively, when there are a plurality of entries of the longitude and latitude coordinates, the display color of these resident icons (or the resident icon drawn at the top of these resident icons) is different from that of other resident icons. By using colors, it is possible for the user to visually recognize that a plurality of resident icons are overlapping.
[0045]
Further, the main control unit 112 controls the combination processing unit 117 and the GUI control unit 111, and replaces the icon display map image displayed on the map display screen in the client terminal 12 with the icon layer used so far. Update to the one using the newly generated icon layer.
[0046]
As a result, the icon display map image displayed on the map display screen is updated to an image in which only the service base icon and the icon of the resident who is the recipient of the service provided by the service base selected by the user are displayed. You.
Here, when the add button 855 is operated by the user in a state where the resident icon of the specific service recipient or the household icon of the specific service recipient is displayed, the main control unit 112 displays the object table. All the resident IDs or household IDs registered in 118 are added to the output target ID. In this manner, even when the resident icon of the specific service recipient or the household icon of the specific service recipient is displayed, the information of the household and the resident is displayed according to the icon selection by the selection tool 865 as described above. And the addition of the household ID or resident ID corresponding to the icon selected by the selection tool 865 to the output target ID in response to the addition button operation.
[0047]
Next, a case where the search tool 866 of the tool box 854 is operated will be described.
When the search tool 866 is selected by the cursor 810 as shown in FIG. 10 (a), the main control unit 112 displays a condition search window 814 on the client terminal 12 via the GUI control unit 111. Then, on the condition search window 814, designation of what kind of condition the household or inhabitant is searched for is accepted by the cursor operation (b, c). The condition accepted here may be any condition associated with a household or a resident by the resident card database 2, the household database 3, or the service management database 4. For example, it may be a resident of a certain service, a resident of a woman, a resident of the elderly, a resident of an elector, a household to which any of these resident belongs. Note that the detail button on the condition search window 814 is a button for accepting setting of more complicated conditions using a logical operation or the like. When this detail button is operated, for example, a female elderly person is displayed. A search condition is received by displaying an appropriate detailed condition setting window based on more complicated conditions such as residents who are receiving the daily service and are children and residents of the same household.
[0048]
When the main control unit 112 receives the search condition in the condition search window 814, the main control unit 112 deletes the entry of the household ID and the resident ID registered in the object table 118, and sets the target object to satisfy the received condition. As a resident or a household, or a resident and a household that satisfies the received condition, an address having a longitude and latitude coordinate in the area corresponding to the display area is obtained by referring to the address coordinate conversion table 9, and The ID of the target object having each obtained address is obtained. For example, if the search condition is a female inhabitant, since the female inhabitant is set as the target object, each of the obtained addresses using the resident card database 2 is used as the address and the gender is female. By requesting the resident database server 5 to search for a certain resident ID, the resident ID corresponding to the target object is obtained.
[0049]
For the obtained household ID, the icon type representing the household ID, the latitude and longitude coordinates of the address of the corresponding household, and the correspondence with the household ID are stored in the object table 118. The correspondence between the icon type to be represented, the latitude and longitude coordinates of the address of the corresponding household, and the household ID is stored in the object table 118.
[0050]
Then, the icon object generation unit 116 draws an icon according to the object table 118, generates an icon layer, and displays, in an entry of the object table 118, a coordinate on the icon layer in which an icon corresponding to the entry is drawn. Registration. Further, the main control unit 112 controls the combination processing unit 117 and the GUI control unit 111, and replaces the icon display map image displayed on the map display screen in the client terminal 12 with the icon layer used so far. Update to the one using the newly generated icon layer.
[0051]
As a result, the icon display map image displayed on the map display screen is updated to an image displaying a resident or a household that satisfies the condition specified by the user in the condition search window 814, or an icon showing only the resident and the household.
FIG. 10 shows an icon display map image in the case of searching for a female resident. For each female resident, a heart-shaped image representing the resident is provided at a position on the map corresponding to the address of the relevant resident. The icon is displayed.
When the user operates the add button 855 in this state, the main control unit 112 adds all the resident IDs or household IDs registered in the object table 118 to the output target ID. In addition, as described above, according to the selection of the icon by the selection tool 865, the display of the information of the household and the inhabitants and the output in response to the operation of the button for adding the household ID or the inhabitant ID corresponding to the icon selected by the selection tool 865 are performed. Add to the target ID. FIG. 10 shows a state in which the resident icon 804 is selected by the cursor 810 when the selection tool 865 is selected (d), and the resident information represented by the resident icon 804 is displayed by the resident information display window 812. ing.
[0052]
Next, an operation when the square tool 861 of the tool box 854 is operated will be described.
As shown in FIG. 11, when the square tool 861 is selected by a cursor operation (a), the main control unit 112 performs the following operations via the GUI control unit 111 and the client terminal 12. That is, the designation of the rectangular area 816 of the icon display map image is accepted in accordance with the drag and click of the cursor 810, and the outline of the accepted rectangular area is drawn on the icon display map image.
[0053]
Then, a geographical latitude and longitude coordinate range corresponding to the region on the received icon display map image is calculated, and the addresses included in the calculated latitude and longitude coordinate range are extracted from the address coordinate conversion table 9. Then, a request is made to the inhabitants database server 5 via the database client unit 114 for a search for the household record 202 having the extracted address and the inhabitant record having the extracted address. Obtain household database 3 and resident card database record information. Then, based on the obtained record information, statistical information such as the number of households, the number of residents, the number of men, the number of women, and the number of members having an address within the geographical coordinate range corresponding to the area on the received icon display map image is obtained. The statistical information is generated and displayed on the client terminal 12 via the GUI control unit 111 in the form of a statistical information display window 815.
[0054]
Here, the case where the circle tool 862 and the polygon tool 863 are selected is the same as the case where the square tool 861 is selected. However, in these tools, a circular region 817 and an arbitrary Is different in that the designation of the polygonal area 818 is accepted.
[0055]
As a result, the user can specify an arbitrary area on the map using the square tool 861, the circle tool 862, and the polygon tool 863, and obtain statistical information of households and residents having addresses in the area. Become like
Next, an operation when the distribution map tool 864 of the tool box 854 is operated will be described.
As shown in FIG. 12, when the distribution map tool 864 is selected by the cursor operation (a), the main control unit 112 displays the distribution map attribute setting window 819 on the client terminal 12 via the GUI control unit 111. The designation of the division of the distribution map and the designation of the target for creating the distribution map are accepted by the cursor operation (b, c). As the division of the distribution map, for example, a division by a rectangular mesh, a division by an administrative area, a division by an altitude included in the information of map data, a division by a risk level included in the information of disaster prevention map data, and the like are accepted. . In addition, for example, the density of the household, the density of the inhabitants, and the like are received as the distribution map creation targets. Here, when the detail button of the distribution map attribute setting window 819 is operated by the user, the main control unit 112 displays an appropriate detail setting window, and accepts the setting of the area division and the distribution map target in more detail. For example, in the detailed setting window, the size of the rectangular mesh used as a division, and whether the administrative area used as a division is in the neighborhood association or in the unit of the chore, etc. are accepted. Accept the density of households to which residents of a specific age range belong.
[0056]
When the designation of distribution map division and the designation of the distribution map creation target are received in this way, the main control unit 112 first displays the icon display map image in accordance with the designated division designation. Divide the geographical coordinate range that Then, for each of the divided geographical coordinate ranges, an address included in the geographical coordinate range is obtained by referring to the address coordinate conversion table 9, and a specified distribution map such as the number of households and the number of inhabitants having the obtained address is created. The information required to determine the target value of the target is obtained from the resident database server 5 via the database client unit 114, and the target value of the designated distribution map creation is determined from the obtained information. For example, if the specified distribution map creation target is the household density, for each divided geographical coordinate range, an address within each geographical coordinate range is obtained by referring to the address coordinate conversion table 9, and the obtained address is obtained. The number of household records 202 on the household database 3 is obtained by inquiring of the inhabitants database server 5, the obtained number of household records is divided by the size of the geographical coordinate range, and the household density of the geographical coordinate range is obtained. Ask.
[0057]
Then, the display colors of the respective areas on the icon display map image corresponding to the respective geographic coordinate ranges are determined in accordance with the distribution map creation target values obtained for the respective geographic coordinate ranges, and the icons are determined using the determined display colors. The icon display map image displayed on the client terminal 12 is updated so that each area on the display map image is displayed. This update is performed, for example, by causing the combining processing unit 117 to combine a translucent layer for adding a display color to each area on the icon display map image on the map image layer and the icon layer, and to perform the map with the combined image. This is performed by updating the icon display map image on the display screen.
[0058]
Here, FIG. 12 shows a map display screen in the case where a rectangular mesh is specified as the division of the distribution map and the household density is specified as the distribution map creation target. The area is divided, and a display color (represented by a dot pattern in the drawing) according to the household density of the area is added to each area.
[0059]
Now, when the map change button 870 is operated in a state where the icon display map images of FIGS. 8 to 12 are displayed, each window or icon is displayed in the icon display map image at that time. Only the type of the map that is the background of the display color of the distribution map or the distribution map is changed. Therefore, the user can collect and grasp information on residents and households from various or complex viewpoints while switching the type of map using the map change button 870.
[0060]
As above, the administrative work support system according to the embodiment of the present invention has been described.
In the above embodiment, one type of map data is selected from a plurality of types of map data stored in the map database 6 in accordance with the user's specification, and the map represented by the selected map data is displayed on the map. This is displayed on the display screen. This is because a plurality of types of map data is selected from a plurality of types of map data stored in the map database 6 in accordance with a user's designation or the like, and the selected plurality of map data is displayed. May be displayed on the map display screen in which different types of maps represented by are combined.
[0061]
【The invention's effect】
As described above, according to the present invention, it is possible to provide an administrative work support system that can support collection and understanding of information on residents and households in relation to the geographical location of the addresses of residents and households. .
[Brief description of the drawings]
FIG. 1 is a block diagram showing a configuration of an administrative work support system according to an embodiment of the present invention.
FIG. 2 is a diagram showing contents of various databases according to the embodiment of the present invention.
FIG. 3 is a block diagram illustrating a configuration of a resident information providing server according to the embodiment of the present invention.
FIG. 4 is a diagram showing contents of an object table 118 used in the embodiment of the present invention.
FIG. 5 is a flowchart illustrating a processing procedure of a resident information providing server according to the embodiment of the present invention.
FIG. 6 is a diagram showing a map designation reception screen displayed in the embodiment of the present invention.
FIG. 7 is a diagram schematically showing a procedure for generating an icon display map image to be displayed in the embodiment of the present invention.
FIG. 8 is a diagram showing a map display screen displayed in the embodiment of the present invention.
FIG. 9 is a diagram showing a map display screen displayed in the embodiment of the present invention.
FIG. 10 is a diagram showing a map display screen displayed in the embodiment of the present invention.
FIG. 11 is a diagram showing a map display screen displayed in the embodiment of the present invention.
FIG. 12 is a diagram showing a map display screen displayed in the embodiment of the present invention.
[Explanation of symbols]
2: Resident certificate database, 3: Household database, 4: Service management database, 5: Resident database server, 6: Map database, 7: Map database server, 8: Print server, 9: Address coordinate conversion table, 10: Resident information Providing server, 11: trunk LAN, 12: client terminal, 13: user LAN, 111: GUI control unit, 112: main control unit, 113: print client unit, 114: database client unit, 115: map drawing unit, 116: icon object generation unit, 117: composition processing unit, 118: object table.

Claims (8)

An administrative work support system that supports the acquisition of information on residents or households by an administrative body,
A map database storing map data representing a map within a geographical area under the jurisdiction of the administrative body;
A resident database storing attribute information including at least an address of the resident or the household,
An address database storing address geographical position information indicating a correspondence between an address within a geographical range under the jurisdiction of the administrative body and a geographical position to which the address is assigned,
Map image generating means for generating a map image represented by map data stored in the map database;
A mark display map image is generated by drawing a predetermined mark at a position on the map image corresponding to the geographical position corresponding to the address of each resident or household, obtained by referring to the resident database and the address database. Mark display map image generating means,
Display means for displaying the mark display map image. The administrative work support system according to claim 1,
The map database stores a plurality of different types of map data that represent maps within a geographical area under the jurisdiction of the administrative body,
The administrative work support system has a map selection receiving unit that receives a selection of at least one type from a plurality of types of map data stored in the map database from a user,
The administrative work support system, wherein the map image generating means generates a map image represented by map data of the type received by the map selection receiving means, stored in the map database. The administrative work support system according to claim 1 or 2,
Mark designation receiving means for accepting designation of the mark on the mark display map image displayed by the display means,
A resident information presentation unit for searching the resident database for attribute information of the resident or the household corresponding to the mark received by the mark designation receiving unit, and displaying the searched attribute information. . The administrative work support system according to claim 1, 2 or 3,
A search condition specification receiving unit that receives specification of a search condition of the attribute information from a user;
The mark display map image generating means, for only the inhabitants or households having attribute information which is obtained by referring to the inhabitants database and which matches the search condition accepted by the search condition designation accepting means, of each inhabitant or household An administrative work support system characterized by generating a mark display map image in which a predetermined mark is drawn at a position on the map image corresponding to a geographical position corresponding to an address. The administrative work support system according to claim 1, 2, 3, or 4,
Area designation receiving means for receiving designation of an area on the mark display map image displayed by the display means;
An address corresponding to a geographical position in the calculated geographical area is calculated by referring to the address database and the inhabitants database by calculating a geographical area corresponding to the area on the map image for which the area specification receiving means has received the specification. And a statistical display means for calculating and displaying, based on the attribute information of the inhabitant or the household, a statistical value of the inhabitant or the household having the attribute information of the inhabitant or the household. The administrative work support system according to claim 1, 2, 3, 4, or 5,
From the user, from among a plurality of values obtained from the attribute information, a statistical target designation receiving means for receiving a selection of a value to be statistical,
For each region obtained by dividing the map image into a plurality, a geographical region corresponding to the region is calculated, and the address corresponding to the geographical position in the calculated geographical region is calculated by referring to the address database and the inhabitants database. Statistical value calculating means for calculating a statistical value of a value accepted by the statistical object designation receiving means for the inhabitants or the household having attribute information based on the attribute information of the inhabitants or the household,
A statistical map display unit for generating and displaying a statistical map representing a geographical distribution of statistical values calculated by the statistical value calculating unit for each of the regions obtained by dividing the map image into a plurality of areas; system. A map database storing map data representing a map within a geographical area under the jurisdiction of the administrative body, a inhabitant database storing attribute information including at least addresses of the inhabitants or the household, and a geographical area under the jurisdiction of the administrative body Using a computer system equipped with an address database that stores address geographical location information indicating the correspondence between the address of the country and the geographical location to which the address is assigned, assists the administrative body in acquiring information on residents or households Administrative business support method,
In the computer system, generating a map image represented by map data stored in the map database;
In the computer system, a predetermined mark is drawn at a position on the map image corresponding to a geographical position corresponding to the address of each resident or household, obtained by referring to the resident database and the address database. Generating a display map image;
Displaying the mark display map image in the computer system. A computer program read and executed by a computer system,
The computer program, the computer system,
Map image generating means for generating a map image represented by map data stored in a map database storing map data representing a map within a geographical area under the jurisdiction of an administrative body; and attribute information including at least an address of a resident or a household With reference to an address database storing address geographical location information indicating the correspondence between addresses within the geographical area under the jurisdiction of the administrative body and the geographical location to which the address is assigned. Mark display map image generating means for generating a mark display map image, drawing a predetermined mark at a position on the map image corresponding to a geographical position corresponding to the address of each inhabitant or household,
A computer program functioning as display means for displaying the mark display map image.

Images