Web-based Commercial Street Analysis System Based on Spatial and Demographic Data.

Abstract

The invention quantifies the commercial potential of all streets across Türkiye in terms of spatial and demographic data. The results are evaluated using various methods and presented through a web-based Geographic Information System for retail, banking, It involves identifying and presenting users with the most promising areas within the automotive, fuel, telecommunications, and advertising sectors.

Description

1 TARIFF Web-based Commercial Street Analysis System Based on Spatial and Demographic Data. Technical Area The invention relates to spatial geometric data (1B.I.) of commercial streets obtained from various sources. Spatial analysis of demographic data (1B.I.), business data (1C.I.) and commercial data (1D.I.) 5 The results are evaluated by the processes (2) and the results are presented through the web-based geographic information system. Geomatics, which is the function of providing spatial geometric data to users (5), Photogrammetry, remote sensing, and cadastral disciplines; data in a usable form. Information and communication technology disciplines are related to the transmission and storage of data. Depending on how meaningful interim results are obtained, the disciplines of statistics and urban planning... 10 and these interim results are in the position of user (5) within decision support systems It is related to the retail, banking, automotive, and fuel sectors. State of the Art Our platform is a spatial decision support system application. Decision support systems Ranking, selection among alternatives to support any decision-making activity 15 These are systems, often used for computer-assisted decision-making, that employ methods such as this. Theoretical organizational decision made at Carnegie Institute of Technology in the 1950s-1960s research and development efforts were carried out at the Massachusetts Institute of Technology in the 1960s. They emerged as a result of technical work in interactive computer systems in the 1970s. Decision support systems have become a field of study in their own right for businesses over the years. Its importance is increasing day by day, and many sources recommend that companies use DSS (Document Management System). Recommendations are being published. On our platform, data visualization will be used as a function for the decision support system. This methods using tools like graphs for data readability and interpretation It is a visualization. This method was first used in the world by the Scottish engineer William Playfair, in 25 It was used to make debts readable. Business owners are looking for potential openings for new businesses and new branches of existing businesses. It requires spatial, socioeconomic, and sociocultural data about the locations. In non-data-driven processes, site selection decisions are based on personal experiences related to the area. While traditional data-driven methods are shaped accordingly, data mostly consists of 30 2 by people competent in the field of systems used for questioning and analysis This is done using spatial data analysis software and is done individually for each business that requests it. It is reported. As seen in invention no. 2018 / 04737, which is another current method. A system similar to our invention is currently in use, but spatially detailed down to the street level. Data can be presented, but a more detailed output cannot be produced. 5 With our retail street application, we cover all retail streets in Türkiye within a 300-meter radius. By measuring the two-way popularity of a street at different distances, companies can make better use of their location choices. Our aim is to obtain accurate results. There is no study in our country that goes into this level of detail. It is not available. Purpose of the Invention 10 One aim of the invention is to divide all commercial streets across Türkiye into 300-meter sections. commercial potential of the street areas (6) defined separately by both sides of the transportation Its location is relative to its connections; surrounding socio-cultural facilities, public service areas, their locations relative to places of worship, green spaces, and business centers; the impact of street areas Demographic characteristics of the community living in the area; each 15 on the street area The demographic appeal of different brands in the sector and different commercial sectors within the same sector Spatial analysis based on factors of the positive or negative commercial impact of the units on each other. (2) is the calculation by operations. The other purpose of the invention is to divide the street area into 300-meter sections (6) and to determine its commercial potential. The 20 units of the streets calculated in segments, in relation to each other and their surroundings. their proportional impact on the commercial potential of an entire street, depending on their location After determining these impact rates, the commercial potential of the streets can be assessed accordingly. It is a holistic calculation. Another purpose of the invention is to calculate the street areas (6) of the streets and the scale of the whole street. their commercial potential is in the retail, merchandising, banking, automotive, and fuel sectors. Determining the location of investments such as new branches, ATMs, sales offices, communication offices, and warehouses. Evaluation of the efficiency of existing investments through spatial analysis processes (2) Map representation (4A) for inclusion in spatial decision support systems in processes. It is presented as a graphic (4B) representation and a report (4C) output. 3 Another purpose of the invention is to provide similar services using GIS technologies in the targeted sectors. existing services of this nature are presented individually through traditional printed or digital documents. The limitations arising from its presentation are overcome by a user-friendly, dynamic service provided through monthly / annual subscriptions. and to overcome it quickly and repeatably with a map-based web interface. Figure Description 5 Figure 1: System Architecture diagram. Figure 2: Plan view showing the 300m street areas. Explanation of References in Figures 1: Data Sets: Data used in the system to calculate the commercial potential of street areas. They are sets. 10 1A. TUİK: Turkish Statistical Institute 1A.I. Demographic Data: Demographic data at the provincial, district, and neighborhood levels obtained from the Turkish Statistical Institute (TUİK). data 1B. Here: HERE, a Netherlands-based company providing mapping and location information to individuals and businesses. It is a technology company that offers related services. 15 1B.I. Spatial Geometric Data: City, district, and neighborhood boundaries provided by Here company, attractions, transportation networks 1C. Company websites: Websites containing corporate and branch information of companies. 1C.I. Business Data: Company signboard names, addresses, and contact information. 1D. Chambers of Commerce: 20 organizations established by business owners to advocate on behalf of the business sector. They are communities. There are web archives where data about businesses is shared. 1D.I. Commercial Data: Sectoral data of businesses, trade names and ownership structure. data regarding 2: Spatial Analysis Processes: Anonymizing spatial data and using this data These are the processes of performing spatial geo-statistical and topological analyses. The other 25 clients... Personal or company-specific data uploaded to the system for integration with other data. After anonymizing the data by masking its attributes, the address text or administrative region 4 Geocoding of data acquired at this scale, followed by proximity, intersection, clustering, and regression. Their situations are examined. 3: Cloud Computing Operations: Processing data and spatial analysis obtained from various sources. The outputs are stored in cloud storage units and the software is installed on the web server. Spatial and attribute data queries are performed on the components, and the query results are 5. These are the processes of displaying images. 3A. Docker: Docker is an operating system-level application that utilizes what is also known as "containerization". a computer program that provides virtualization and is called a "container" It is used to run software packages. 3B. PostGIS: PostGIS is a 10-bit system that adds support for geographic objects to object-relational databases. It is a software program. 3C. PostgreSQL: PostgreSQL securely stores complex data workloads and It is a powerful, object-relational database system that scales quickly. 3D. Django: Django is a complex programmer developed for the Python programming language. and to facilitate the implementation of web applications that use a database 15 It is a web framework that is used. 3E. Python: Python is an object-oriented, interpreted, modular, and interactive programming language. It is a programming language. 3F. Node.sj: Node.js is a server-side tool for network-connected applications. It is an improved operating environment. 20 3G. Nginx: Nginx offers high concurrent operation capability, high performance, and low speed. It is a web server designed with memory usage in mind. 3H. React: React is an open, web application framework for building user interfaces. 4. System Outputs: This refers to how the user benefits from the system. 4A. Map display: This is the instantaneous display of queries on the system. 25 4B. Graph: The data obtained from the query result is presented as bar, pie, and line graphs. It is the demonstration. 4C. Report: This allows users to print out data displayed on the system as a report. 5. User: Retail businesses using data-driven spatial decision support systems. Banking, automotive, and fuel sectors are among the users. 6. Street Area: All commercial streets throughout Türkiye are divided into 300-meter sections on both the right and left sides. They are statistical units consisting of divided buffer spaces. 5 Description of the Invention The invention relates to spatial geometric data (1A.I), demographic data (1B.I), and business data of commercial streets. data (1C.I) and commercial data (1D.I) are evaluated through spatial analysis processes (2) in the context of results for users in the retail, banking, automotive, and fuel sectors (5) Determining the location of investments such as new branches, ATMs, sales offices, communication offices and warehouses is done in 10 and evaluating the efficiency of existing investments in terms of spatial factors a map-based web interface to be included in spatial decision support systems in processes It is presented with map representation (4A), graphic representation (4B), and report (4C) outputs. In the system, all commercial streets throughout Türkiye are divided into 300-meter street areas (6) 15 in polygon geometry, vector data type encompassing commercial units along the street, divided into sections. Buffer zones have been created. Both sides of the streets are designated as "streets" at 300-meter intervals. In the system where street areas are defined as "area" (6), the commercial potentials of street areas are spatially analyzed. The calculations are made using (2). The calculation is obtained by weighting the values ​​of various factors. The factors included in the weighted scoring are listed below: 20 Transportation Score: all commercial units within street area (6) have access to buses and minibuses. Its distance from bus stops, metro and tram stations, and ferry terminals is the opposite of what it is. calculated proportionally Attraction Score refers to the central and local proximity of all commercial units within the street area. to administrative units; schools, hospitals, religious facilities, socio-cultural facilities areas and green 25 The calculation is inversely proportional to the distance to areas such as business centers and shopping malls. Demographic Score: 10 minutes from all commercial units within the street area, 15 minutes residing within the area located a 20-minute walk away 6 population, education level, socioeconomic status, population size, household income, It is calculated based on household spending figures. Segmentation Score: For each brand located within the street area; distribution their policies (availability rate), target audiences, and sectoral importance Segmentation scores were calculated accordingly. In this way, the brands that reach the most consumers are listed as 5. The areas have been identified and their scores are calculated. Cannibalism Score: This refers to the cannibalism of all brands within a street area, and the same brands' cannibalism of all brands. negative impact due to its proximity to other commercial units in the area The proximity of different commercial units of the same brand to each other is inversely proportional to its determination. It is calculated as 10 Competitive Score: This refers to the comparison of commercial units belonging to different brands in the same sectors in the surrounding area. all the areas within the street area depending on their distance from each other It is the calculation of competition in sectors. Calculations made for each street area (6) unit determine the commercial potential of the entire street. 15 It is calculated using the weight values ​​that are involved. The street stored in PostgresSQL (3C) with PostGIS (3D) support, along with the calculation results. spatial geometric data (1A.I) and demographic data related to areas (6) and streets (1B.I), business data (1C.I) and commercial data (1D.I) Docker’s (3A) container technology 20 Node.js (3F) runtime environment on Nginx (3G) web server installed on its infrastructure Software as a Software as a Web platform with Django (3D) and a map-based interface built with React (3H). It is offered as a Service (SaaS) for use in various sectors. The user of the system... The sectors, along with their intended uses, are listed below: Retail store management: Determining delivery areas, selecting store locations, store design. Segmentation and product profiling, dealer region optimization, revenue forecasting 25 Banking: Branch and ATM location selection, branch and ATM customer segmentation, bank micromarketing. determination, ATM transaction count estimation Automotive: Dealer location selection, commercial space analysis, location-based sales analysis, sales region assignment. customer segmentation and potential customer analysis 7 Fuel: Station market reports and change tracking, station location selection, station network. optimization, station visit planning Telekom: Dealer and store location selection, sales area assignment, field and turnover forecasting. Advertising: For outdoor advertising; target audience analysis, brand analysis, commercial value analysis, segmentation study 5 Industry users will then proceed according to the preferences of the sector and the company during the preliminary preparation process. You can specify data sets to access through the system, for use in calculating street areas. which parameters will be used and their weights, company sales They can optimize the data by performing regression and correlation analyses. Users can access predefined datasets through the system by street area (6) and street basis 10 can query the query result shown on the map (4A), graphic representation (4B). can view; can get a report (4C) as output from the system.

Claims

8 REQUESTS 1. The invention relates to the spatial analysis processes of the commercial potential of streets in Türkiye (2) The results are evaluated and presented to users via a web-based Geographic Information System. Its feature is that it presents the commercial potential of all streets throughout Türkiye. Location relative to transportation links; distance to surrounding socio-cultural facilities; 5 Location relative to public service areas, places of worship, green spaces, and business centers; Demographic characteristics of the community living in the impact zone of street areas (6); street the competitive situation of different brands in each sector within area (6) and the same The sector and different commercial units within the same brand have positive or negative commercial interactions with each other. It should include values ​​calculated based on influencing factors, and these values ​​should be 10. new branches and ATMs in the retail, merchandising, banking, automotive, and fuel sectors. Determining the location of investments such as sales offices, communication offices, and warehouses, or in evaluating the efficiency of existing investments in terms of spatial factors for use as a map representation (4A), graphic (4B) or report. (4C) It enables the printing of output. 15 2. The street area conforming to Claim 1 is (6), and its characteristic is that all streets in Türkiye have 300 each. with meter-long divisions, each side of which is separately defined as a sub-unit. It is the fact that.

3. Web - Geographic Information System compliant with Claim 1 and Claim 2, with the feature; PostGIS (3D) The street space score stored in supported PostgresSQL (3A) is 20 that is associated with streets. spatial geometric data (1B.I), demographic data (1A.I), business data (1C.I) and commercial data (1D.I) built on Docker’s (3A) container technology infrastructure Django (3D) web in Node.js (3F) runtime environment on Nginx (3G) web server with a map-based interface and layer architecture built with React (3H). It is offered as Software as a Service (SaaS). 25