CPA Systems has a long experience in conception and development of software moduls. The requirement specifications of the applications define the complexity of software moduls in each case. The range varies from the realization of simple capture and information systems to the development of programm systems with high complexity level including the integration of databases and rules to check the consistency of the whole application. Consideration of the customers existing software moduls and the integration of existing data infrastructure is part of our customized application portofolio, too.
SupportGISJ - City Hall
SupportGIS/JAVA City Hall (SGJ-City Hall) is a software application of the company CPA Systems coded in Java. Based on the outline concept of 2D/3D-geospatial data management the implements the standards of ISO and OGC SGJ-City Hall uses a database model and thus allows detailed description of object-oriented geographic data as well as mapping these data on the data scheme.
Attributes of geospatial data management:
- Support of object orientated paradigms in data scheme modelling. These are: inheritance, aggregation, composition, relations, abstract classes, etc.
- Maintenance of the generic application scheme. That means strict separation of application scheme and database scheme and avoidance of static stuctures to maximum extend.
- Support of popular object-relational databases. The access on data is carried out by use of the standards of WFS and JDBC. Spatial structures are designed considering the simple feature for SQL specifications of the OGC and mapped on the geo-structures of the database (for example: SDO_Geometry). The information of attributive character are handled with standard-SQL.
- Consideration of norms and standards in the description, inquiry and output of geospatial data (XML, GML, SQL, WFS, etc.).
- The scope of operators of the query language and analysis facilities is defined by wfs:filter-encoding. This allows a combination of numerical operators (PropertyIsEqualTo, PropertyIsGreaterThan, etc.), spatial-geometric operators (Touches, Intersects, Crosses, Bbox, etc.) and logical operators (AND, OR, NOT) in arbitrary complexity.
- The core instances for the data model are platform independent.
City Outline Map
SGJ-City hall allows simple and confortable processing of a city outline map. The scheme of database is a municipal extension ALKIS scheme (GeoInfoDok Version 5.1.1) that will be used by the real estate cadastre in future. Accordingly the technique of updating the data is oriented on this new standard. The communication between capturing workstation and database management system is done using the NAS-interface. For simpification and acceleration of work the specifing of capture rules is possible. Thus attributes are automatically preallocated with standard values and presentational objects are calculated and placed automatically. These automatical generated information can be changed manuelly by user if necessary. This capture supports the automatical generation of area features on basis of geometry of the real estate cadastres area features. These can be integrated from ALK or using a web service (WFS) for example.
Figure 1: City Outline Map
SGJ-City Hall is using a trimble interface. This way objects surveyed in trimble format can be processed and lists of coordinates (SGK and ALK) as basis for staking out positions can be put out in trimble format. The visualization of the data as a thematic depiction can be configured individually by SLD.
Integration of ALK and ALB
Data of the real estate cadastre (ALB/ALK) can be integrated used profitably in SGJ-City Hall. Data record can be searched by different criteria, for example field sector number, street and street number or real owner. Using the identified field sector official proof from ALB can be printed out; e.g. field sector proof and real owner proof.
Figure 2: Integrate Real Estate Data Set
As SGJ-City Hall is based on the data structures of ALKIS, the trouble-free integration of ALKIS data is also possible as soon as the real estate cadastre is processed in ALKIS.
SGJ-City Hall can deal with simple graphs for case applications that require some kind of routing. The graph is handled as a model of nodes and edges and SGJ-City Hall provides tools for its capture and update as well as search functions.
Figure 3: Node-/Edge Model
Calculation of Way to School
An example of a case application, that is based on the structure of a node-/edge model, is the calculation of shortest ways to school. Using the street number, postions from ALK and adress lists of students and schools, it is possible to generate automatically the shortest way to school for each student. Finally the ways to school can be printed out in PDF-format.
Figure 4: Way to School
Automatic routing can be carried out in batch mode, so that the outputs for all students can be generated fully automatically. Furthermore an individual routing by using more data, e.g. city outline map or web services (WMS/WFS), is possible.
Green Space Cadastre
SGJ-City Hall supports a simple and confortable handling of object of green space. The database scheme is a municipal extension of the ALKIS-scheme version GeoInfoDok (5.1.1) that will be used by the real estate cadastre in future. The technique of updating is oriented on this new standard and the communication between capturing workstation and database management system is done using the NAS-interface. The capturing of data can be done on the basis of ALK-data and city outline maps. For this purpose a copy function is provided. To make the capturing more convenient, attribute values can be calculated automatically in part, e.g. district name out of ALK-data. Furthermore convenient copy and selection functions are existing. For the objects of green space an outprint with a legend depending on topic and a balance of objects can be generated.
Figure 5: Objects of Green Space
Furthermore trigger mechanisms for automatical updating of the tree cadastres are available.
Another case application of SGJ-City Hall is tree cadastre. Here the database scheme is implemented as a municipal extension of the ALKIS-scheme in version GeoInfoDok (5.1.1), too. The technique of updating is oriented on this new standard and the communication between capturing workstation and database management system is done using the NAS-interface, too. Trigger mechanisms allow reading and updating of a swap table. This swap table can be accessed by other case applications using ODBC. Thus automatic updating of data from the green space cadastre data is possible.
Figure 6: Tree cadastre
The depiction can be flexible configured by SLD-control files.
SGJ-City Hall is appropriate to handle sealing cadastre, too. The programm is using an adapted user interface for capturing and analysing of data of sealed areas. A web portal allows the owners to communicate aphanumerical and geometrical indications of the sealing situation of their areas.
Figure 7: Sealing Cadastre
Furthermore an interface to department of finance for the transmission of the data relevant for billing exists.
By combination of data from ALK/ALB-data and data of the sealing cadastre as well as further data from other case applications, a rainwater treatment concept can be provided by SGJ-City Hall. Here the depiction can be flexible configured by SLD-control files, too.
Figure 8: Rainwater
Local Ground Management
SGJ-City Hall has functionality for the local ground management, too. This starts with the data of real estate cadastre. A fully automatic intersection of the areas with ALK is supported, as well as an automatic area alignment with the ALB. During this procedure subareas are labeld automatically. Supplementary the owners of these areas can be investigated automatically and a derivation of an area statistic is possible.
Figure 9: Local Ground Management