Tutorial on how to load data in CartAGen

Description of the sample dataset

The test data can be found in the cartagen-appli project resources, alpe_huez_test_data.backup, it is an old extract of IGN (the French National Mapping Agency) data around the skying resort of l’Alpe d’Huez.

This dataset was used in the EuroSDR generalisation software benchmark.

Restoring the sample dataset into PostGIS

alpe_huez_test_data.backup is a postGreSQL backup, the file has be restored in a postGreSQL database with the postGIS extension. Once restoration is carried, the database contains the following tables:

Filling the mapping XML file

The CartAGen librairies use a centralized data schema in order to avoid dependencies to specific data schemas in algorithms. So the first step load some new dataset in CartAGen is to map the data schema to this centralized schema: that’s what the XML mapping file is for. You can see in the tutorial on the centralized schema that the schema can have several implementations, and the first part of the mapping file describes the implementation you want to use. Here, the default implementation is chosen (and should be in most cases).

<mapping>
    <gene-obj-implementation>
    	<name>default</name>
    	<factory>fr.ign.cogit.cartagen.core.defaultschema.DefaultCreationFactory</factory>
    	<root-package-name>fr.ign.cogit.cartagen.core.defaultschema</root-package-name>
    	<root-class>fr.ign.cogit.cartagen.core.defaultschema.GeneObjDefault</root-class>
</gene-obj-implementation>

Then, the mapping file is composed of a list of <matching> elements that describe how a table of the postGIS database can be loaded as one of the Java classes of the centralized schema.

    <matching>
        <postgisLayer>ign_minor_road</postgisLayer>
        <creationMethod>createRoadLine</creationMethod>
        <scaleRef>15000</scaleRef>
        <theme>road</theme>
        <attributes>
            <attribute>
                <postgisAttr>importance</postgisAttr>
                <javaAttr>importance</javaAttr>
            </attribute>
        </attributes>
</matching>

The above matching example matches the table “ign_minor_road” to the creation method of the IRoadLine, that can be found here. So, the loader will create IRoadLine instances with the lines in the ign_minor_road table. The <scaleRef> element gives the reference scale of the loaded data. The <theme> element refers to an ontology concept that matches this type of feature, here, “road”. Such ontological concepts were used for instance in the ScaleMaster 2.0. For now, this ontology reference is not used in CartAGen, but has been added for further interoperability issues. The <attribute> elements describe mappings between postGIS attributes and the Java fields of the centralized schema. In this example, both datasets have an “importance” attribute that gives the importance of the road in the classification of roads.

The file “mapping_test_data.xml” available in the resources of cartagen-appli module already contains a complete mapping of the tutorial data, but can be used as a template for future imports with different dataset.

Loading the dataset in the application

To import the dataset into CartAGen, you have to launch CartAGen by running the class CartAGenApplicationAgent or CartAGenApplicationNoAgent depending if you want to use agent-based generalization or not. Go into the “Dataset” menu, then the “Import dataset” submenu, and then click on “Import from PostGIS”.

where to click to import PostGIS data

Clicking on the menu button opens a window where information on the data to import must be given. The first step is to connect to PostGIS by filling the text fields at the top of the window (see figure below). The database name is the one you used when restoring the tutorial database into PostGIS. The id, password, port and host information has to be changed of course, to match to your PostGIS installation. When all the above fields are filled, you can click on the “Connection” button to actually connect CartAGen to PostGIS.

Connection to a PostGIS database

Once the connection is established with PostGIS, a list of tables existing in the selected database is displayed in the left list panel. You have to select the ones you want to import and click on the “Add” button in the middle (see figure below). Tables that have been added can be removed by selecting them in the right panel and by clicking on the “Remove” button that is enabled once a table is selected in the right panel. Multiple selection are possible in both panels.

Adding layers to import from the table list

Once the tables we want to import have been selected, the mapping file can be selected using the “browse” button. By default, the default mapping file used in this tutorial is selected, so there no need to browse for another one.

Choosing a mapping file

Data rendering, as most of the GUI, is based on open source platform GeOxygene, also developed by IGN France. To specify the style of the displayed layers, GeOxygene, and CartAGen, use the SLD/SE standard. See documentations on the GeOxygene website to learn more on SLD. By default, i.e. if the field to specify a SLD file is left empty, the loaded data is rendered using a default SLD, that can be found here, that uses a classical topographic mapping style (see figure below).

Caption of the imported dataset

The dataset can also be imported by code, using the same code as the loading window, that can be found here.

Importing shapefiles

The tutorial above only allows the import of geographical datasets stored in a PostGIS database. But shapefiles can also be imported in CartAGen, in a slightly different way. When loading shapefiles as a new CartAGen dataset, the first step is to create a new CartAGen Document (see at the end of the tutorial for more details). This step is done automatically when loading a PostGIS database. To create a new Document, click on ‘New CartAGen Document’ in the ‘Dataset’ menu (see image below).

Menu to create a new Document

Then, go into the “Dataset” menu, then the “Import dataset” submenu, and then click on “Import from Shapefiles”. A window appears (see image below).

Menu to load shapefiles

The name of the zone is just metadata on the dataset (see image below). Then, the text field and the button help choosing the mapping file between the shapefiles structure and the CartAGen data schema. The XML structure is exactly the same as the PostGIS mapping file. In the running example of the tutorial, as the shapefiles are named similarly to the PostGIS tables, the “mapping_test_data.xml” file can also be used to map the shapefiles, no need to create a new one.

Menu to load shapefiles

Then, choose a name for the loaded dataset. The name of a dataset is useful when several datasets are loaded at the same time in CartAGen, or when the document is saved (the name of the dataset is used as a name for the file created to enable document saves). The scale to give is the symbolisation scale of the loaded data, i.e. the target scale of generalization. This scale value can be changed later in the CartAGen GUI. Finally, the last text field of the window (at the bottom) is for the path of the folder that contains all shapefiles to load (the shapefiles have to be located in the same folder).

If necessary, extra shapefiles can be loaded as new layers afterwards, using the menu “Dataset” menu, then the “Add layer to current dataset” submenu, and then click on “Add Shapefile as new layer”.

Importing .osm files

It is also possible to load extract from OpenStreetMap with .osm formatted files. The matching between OSM tags and CartAGen feature types is automatic (encoded in the OSM loader). To load OSM files, you have to use the ‘OpenStreetMap’ menu (see image below)

Menu to load an OSM file

Clicking on the menu item opens a window (see image below) where the .osm file to load can be specified, as well as the map projection to use. As CartAGen uses parameters in map millimeters, it does not work properly if the data is loaded with geographic coordinates: the dataset has to be projected into a given map projection. Only a very small extract of the existing map projections is available in this window, so additional map projections will have to be added in the code of the window to be able to use them. CartAGen uses Geotools library for projections, which gives a large variety of map projection that can be used. It is also possible to filter the loaded features by specifying a tag filter: the loader will only consider the features that have the specific tag (with no regard to the value of the tag). To only load roads, you have to put “highway” in the text field.

Loading Frame for OSM data

In order to test this importing method, a .osm file was extracted from OpenStreetMap on Sept. 26th 2017, on the Alpe d’Huez area.

The ‘Import recent files’ menu gives a shortcut access to the last five files that were loaded in CartAGen.

Saving and loading CartAGen Documents

See Also