Determinación de zonas de franquicia funcionales a partir de la georreferenciación de estaciones de servicio por medio de una herramienta SIG, y el diseño de una app móvil para su consulta

Abstract

The business group Insepet as part of the methodology for the new sales force used for the operation of the commercial branch of the company, adopts the franchise model to cover the territory in a greater extent and with a stronger presence and thus, present a commercial strategy that reinforces certain areas of the country that generated portfolio erosion. The project in question proposes a georeferencing model of points of interest for a design by means of interpolation algorithms of functional operation zones which fulfill certain characteristics required by the company. The georeferencing model is supported by the SICOM database and a process of organizing, classifying and correcting the information is carried out in order to work with the best and most complete information possible in order to decrease as little as possible the margin of error. On the same SICOM database (Obtained from the Open Data Portal of the ICT Ministry), the unassisted georeferencing process is carried out using the Google Earth Pro software; the stations are located with the address and coordinates are fixed to said point, later a geographic database administered in PostSQL is consolidated and with the help of the geographical extension - PostGIS, the database is created with the respective Latitude / Longitude and they connect to the QGIS software to design the GIS and thus obtain the zones by interpolation. The mobile application is considered as the solution to consult the information of the Geographical Information System once in the field; it is done on the android studio IDE on JAVA and XML and provides, through a NavigationDrawer, the possibility of navigating geo-referenced stations in the field with Internet access only. The linking of technologies provides a completeness in the process of information and the treatment of it.