Visualization of floor plans or geographic information systems (GIS) in real estate

Earlier on Habré we published an article “From the smart home to smart corporations” , in which the Module for visualization of floor plans (MUPP) was mentioned, which we implemented as part of the creation of the Automated Real Estate Management System. With the help of the MVPP, opened on the tablet , we could remotely monitor the readings of various sensors installed on the Smart Home layout, get a video stream from surveillance cameras, as well as control the lighting and operation of the fountain. Now, I would like to highlight in more detail the main features of this module and briefly describe the possibilities of connecting the geographic information system with the enterprise management system.


')
MUPP is a basis that allows implementing rather extensive functionality on its base. Any object with a set of its characteristics has a spatial reference inside the building. Any number or “quantity of something” can be tied to a building, floor or room, and subsequently, based on these data, build visual analytical reports.
When implementing integration with other enterprise information systems, for example, with ERP, MUPP allows you to display the relevant information:

• workplace in the room where Ivan Ivanov Ivanov is located (with his photo, information about his position, department and telephone);
• the room where the air conditioner with serial number SN777 is located;
• premises that violate the standards of placement of employees (by any criterion, whether it is the norm of space, ventilation, etc.);
• premises in which timely testing or replacement of fire extinguishing equipment was not carried out;
• a workplace in the room where it is necessary to replace a broken telephone set - especially important in Open Space;
• the profitability of an enterprise department in relation to the space it occupies - suppose that taking into account the operating costs incurred and so on, “department A”, loaded 100% and occupying 1/3 of the floor space, makes the company more profit than “department C” loaded at 50% and occupying 2/3 of the floor space.

By laying down certain algorithms in the MISP GIS, you can perform various modeling tasks, for example, automatic selection of free areas / jobs or placement of employees in accordance with the “compatibility matrix”. An example of a simulated task: the staff of “department A” should be placed closer to “department B”, but it is absolutely not recommended to be placed in the same room along with “department C”.
The floor plan visualization can be the entry point for submitting an application to ServiceDesk. Thus, any user, having previously passed authorization in the system (thus, identifying himself and his location), simply writes “Air conditioner has broken - I am hot” in a special field and all the information needed to initiate an incident is transferred to ServiceDesk data, place of incident, text of the application.

MUPP Automated Property Management System is designed for a wide range of tasks, including:

• Visualization and editing of the floor plan geometry;
• Visualization and editing of workplaces;
• Display of attribute information (by buildings, floors, rooms, workplaces and technological places) stored in SAP;
• Editing attribute information and saving it in SAP;
• Construction of various analytical reports;
• Planning redevelopment of premises and staff placement.

The MVPP is implemented using Java / JavaScript technologies and published on the Apache Tomcat web server, the server side of the visualization module uses ESRI's ArcGIS for Server, and the Oracle database with an extension for working with spatial data is used as a DBMS. In addition, several plug-in modules (Add-In) were developed for ArcGIS for Desktop, which are responsible for authorizing the user in accordance with the role model, and performing editing of floor-plan geometry.

At the initial stage, the spatial database contained the following set of layers:

• Bearing walls;
• Carrier pillars;
• Not bearing walls;
• Partitions;
• Doors;
• Stairs;
• Window;
• Elevators;
• Furniture;
• Engineering systems;
• Workplaces;
• Bathrooms;
• Office space;
• Other rooms.

However, due to the emergence of new tasks that will be solved with the use of MEPP, the data structure will also expand.
The MUPP has implemented a library of typical workplaces, consisting of ~ 20 different configurations (of course in the same series with the floor plan). Adding a workplace to the floor plan is done by simply dragging it from the library to the right room. At the same time, on the basis of spatial analysis, the MEPP determines which workspace is installed in which room, what account it is, and records all necessary attribute information for the workplace (building identifiers, floors, rooms, its number, etc.) in the spatial database. . Later, if necessary, the workplace on the floor plan can be moved, rotated, its attributes changed or deleted.



In the property management module of the SAP system, the premises have, among others, the following attributes (indicators) - the actual number of working and technological places. In the current implementation, when new workplaces are added to the premises or removed, the values ​​of the corresponding indicators in SAP change automatically — that is, There is no need to calculate the total number of workplaces of each type in the premises and then change the values ​​in the corresponding indicators in SAP manually.
SAP has implemented several developments (functional modules), which are responsible for processing the request received from the MEPP, forming and transmitting the requested information to the MCPP. To ensure the integration of MFPP with SAP, the functional modules are designed as web services (based on SAP ESA) and two-way exchange of information is carried out by XML - packages using the safe SAP SSO protocol. To enable the launch of functional web services, users of MITP need to be authorized in the SAP system through a technical web service with an additional security loop and authorization check.

The main tasks of the developed functional modules are the following:

• authorization of the user and determination of his authority in the FPA according to the role model maintained in SAP;
• selection of attribute information in SAP with a list of real estate objects, and its transfer to the MEPP;
• selection of attribute information in SAP on the selected floor of the real estate object (including information on the employees placed at workplaces) and its transfer to the MEPP;
• Automatic changes to the SAP database on the results of editing facilities through the MFPP (including the creation / deletion of premises and workplaces).

Since I would like to focus on the implementation of two-way communication between GIS and SAP, I will dwell on the last point in more detail. Below is a diagram of the process “Modification of the floor plan based on the results of redevelopment”. A special case of redevelopment is the union of two or more rooms into one (or the division of one room into several).



As a result of this process performed by means of the IMP, automatic alignment of information on the changed objects in SAP occurs. However, it should be understood that when executing the “Delete” operation, nothing is deleted in SAP or GIS — an object is locked in SAP (setting master data lock statuses, etc.) on a specific date, a similar restriction of “deleted” objects A specific date also occurs in the GIS spatial database. This allows us to keep a history of changes and, if necessary, to display in the MEPP both the floor plan that is relevant for a certain date, and information about employees placed at workplaces at any time in the past. The process of planning future redevelopments and staff placement, i.e. Having taken the IMPP as a basis for any floor plan, you can plan its future planning. Subsequently (either after the approval procedure, or according to the actual re-planning, or on another event), the planned planning can be transferred to the actual status. At the same time, all the necessary changes in SAP (removal of premises, creation of new premises with filling in attribute information on them, etc.) will be automatically performed by means of implemented development based on information about changes in the floor plan made in MFRP. In the particular case, in a similar way, an automatic relocation of employees in reconstructed premises occurs in SAP.

MUPP includes two interfaces - an overview application in which real estate objects are displayed on a map with their brief characteristic, and an interface for working with floor plans , in which various objects are displayed on a floor plan with their detailed characteristics. I repeat that with each request, all attribute information is transferred from SAP, and not stored in the spatial database.

In the overview application you can perform the following functions:

• select the region of interest;
• find the property on the map by name or address;
• filter out real estate by type of ownership (rent, property, etc.);
• filter the real estate objects on the basis of "<" or ">" number of jobs and / or area of ​​the object;
• display detailed information on the selected (s) property (s) of real estate (the number of vacant / occupied jobs, the area of ​​the selected objects, etc.).

In the property found, the user can select the floor of interest, with the result that a new window opens with a floor plan. The following functions are available in this interface:

• view the location of jobs in the room;
• viewing information about the employee occupying the workplace (name, position, department, date of placement, etc.);
• editing jobs (adding new RMs, deleting or moving free RMs);
• color differentiation of premises for various purposes (working, bathrooms, stairs, etc.);
• viewing information on a room or a group of selected rooms (number, area, design capacity, actual number of vacant and occupied places, etc.);
• editing attribute information for the premises (all changes are transferred and saved to SAP);
• color and symbolic identification of workplaces based on:
• belonging to an organizational-structural unit (three-level org. structure)
• employment (free - busy)
• type of use (working - technological)
• color differentiation of walls by type (capital, partitions, etc.);
• measurement of distances and areas;
• creation of planned versions of layouts and placement of jobs;
• print floor plan with the withdrawal of information about the number in accordance with the signs of occupation.

In conclusion, I would like to say that such an unusual, at first glance, a cartographer, the use of a geographic information system, is in fact not something out of the ordinary. GIS allows you to navigate in space - and what our buildings, floors and rooms are not spaces ?!
GIS allows you to display objects on the map - we place various types of workplaces and other technological objects with many attributes in the premises, the premises themselves on the floors. In varying degrees, on the floor plans we use elements of spatial analysis, search or geo-processing - everything is just like in a large GIS, except, as long as we do not have the function of calculating routes inside buildings .... UNTIL.