KR20130011179A

KR20130011179A - Identifying the population with zoning on smartphone

Info

Publication number: KR20130011179A
Application number: KR1020110072150A
Authority: KR
Inventors: 장우정; 김순연; 원영진; 제영호; 김남규; 문정록
Original assignee: (주)헤르메시스
Priority date: 2011-07-20
Filing date: 2011-07-20
Publication date: 2013-01-30

Abstract

Technology that can identify population of customized area on smartphone

Description

Identifying the population with zoning on smartphone

Mobile web-related spatial database analysis technology

Spatial database technology and web technology

Identifying the population behind it is essential for business analysis and location selection. Unlike offices with all large data and analysis tools (SWs), only a limited amount of data is available in the field. Through the present invention, it is possible to grasp and present a population for an area designated by a user with a smart phone in the field rather than an office. In addition, as a countermeasure against loss of smartphones, the building and population DB will try to solve this problem in a situation where it is not loaded on a smartphone.

In the present invention, the background map for the area drawing is not specified. Both OpenLayers, a typical open source GIS client, and general Open API Maps (Naver Map, Google Map, etc.) can be applied. The OGC Contain Spatial Analysis API is used to search for buildings in the area, and data transmission between smartphone and server uses REST technology, which is a lightweight HTTP-based transmission / reception technology.

After a visual inspection at the site, the uncomfortable procedure of returning to the office to construct the area and to identify the population of the area is solved on site. Smart work environment is more improved.

1, 2, 3, and 4 are examples of screen designs that can be expected when the present invention is applied.

Since the DB of the server is for population counting, not MAP for display, only the population DB layer is constructed. Population figures are usually constructed as property fields of residential buildings such as apartments. For fast response speed, create a spatial index for the residential building table.

An open API portal map (Naver, Google, etc.) may be used as the background map for the area drawing on the smartphone. (See FIG. 1).

The first method is n vertex input method. POLYGON ((198900 454800, 199200 454800,199200 454500,198900 454800)) (if it is a three-point triangle, the first and last coordinates must be entered in a matching closed form) if it follows the OGC WKT standard have.

The second method is to automatically generate a circle around a specified point and use it as an area. Points can be specified by the user on the map or the current position of the smartphone can be utilized. If you check the population while moving on the road in this way, you get a screen result as shown in FIG.

The third method is to use the map area viewed on the screen as the analysis area. Internally it consists of a rectangular polygon with four edges.

The fourth method is for the user to select the administrative boundary name as a combo GUI for each step such as zip code search. The data sent to the server is the administrative boundary distinguished name and the acquisition of polygons is performed at the server. To do this, the server stores the administrative boundary layer in the spatial DBMS.

When the user selects the demographic button (icon), the constructed area is sent to the server using REST technology.

The sum of the population within the region is calculated using the OGC standard contain operation and the Sum Aggregate function of ANSI standard SQL. You can query from Spatial DBMS such as Oracle, IBM DB2, MS SQL Server 2008, and MS SQL Server 2008 can use the following query.

DECLARE @ Zone geometry ;

SET @ Zone = geometry :: STGeomFromText (' POLYGON ((198900 454800, 199200 454800,199200 454500,198900 454800)) ', 0);

SELECT SUM ( Population ) FROM Residential building where @ Zone . STContains (Residential building. geom ) = 1

At this time, in the case of using the center point and the 1km radius area, the lower part is changed from the above.

SET @ Zone = geometry :: STGeomFromText (' POINT (198900 454800) ', 0). STBuffer (1000)

If the administrative boundary name method is used, the area security code is as follows.

SET @ Zone = Select geom from Administrative border where name = 'Seocho-dong'

The calculated scalar value is sent to the smartphone as a response to a REST call. The smart phone expresses the received numerical value to the user.

110: Start demographic function button. Press this button to start plotting areas on the map.

Claims

In identifying the population of the region of interest on a map in a smartphone, constructing a polygon region on a background map in a smartphone; Sending the constructed area to the server by REST technology; Extracting only the building inside the area by OGC contain operation from the area information received from the server; Summing population by ANSI SQL SUM operation in the extracted building; Responding to the aggregated population with REST technology; Representing the population value received from the smartphone on the screen,
In smartphones, building, population DB lookup method on the map, characterized in that this feature provides the function without saving the DB.

The method of claim 1,
How to Specify Zoning by Center Point and Radius

The method of claim 1,
How to use the map screen area that is being queried for area designation

The method of claim 1,
How to use administrative boundary graphic without drawing zoning.