{"id":12832,"date":"2024-04-11T10:01:57","date_gmt":"2024-04-11T08:01:57","guid":{"rendered":"https:\/\/www.sigterritoires.fr\/?p=12832"},"modified":"2024-04-11T10:01:58","modified_gmt":"2024-04-11T08:01:58","slug":"enc-geopackage-maps-in-qgis-final-version-part-two","status":"publish","type":"post","link":"https:\/\/www.sigterritoires.fr\/index.php\/en\/enc-geopackage-maps-in-qgis-final-version-part-two\/","title":{"rendered":"ENC Geopackage maps in QGis Final version: part two"},"content":{"rendered":"\n

The project to integrate ENC maps into QGis in the form of Geopackage<\/a> is now complete. This article completes the two previously published articles on ENC symbology in the Geopackage database.<\/p>\n\n\n\n

Adding symbology to Geopackage<\/h2>\n\n\n\n
The default symbology of a geopackage’s tables is contained in a table named layer_styles, which is only created if you use the save default option of the style button.<\/p>\n\n\n\n
After cloning the tables in the ENC file, the table does not exist. So we’re going to import the table containing all ENC map symbology.<\/p>\n\n\n\n
Please note: the layer_styles table is a system table, unlike the natsurf table, which is a simple data table. Unlike data tables, system tables do not appear in the explorer panel. You need to use the QGis Database Manager (Database menu -> DB Manager) to view and manipulate system tables like layer_styles. Natsurf, on the other hand, can be viewed and manipulated like any other data layer.<\/p>\n\n\n\n
Download layer_natsurfV3.gpkg<\/a><\/p>\n\n\n\n
This geopackage contains a table, named layer_styles, with symbology definitions for 153 S57 tables, as well as a table named natsurf, which will be used to format the rendering of the \u00ab\u00a0nature of seabed\u00a0\u00bb table (SBDARE).<\/p>\n\n\n\n
To integrate these tables into your ENC file (here ENC.gpkg):<\/p>\n\n\n\n
\n
Open the database manager in QGis.<\/li>\n\n\n\n
You should already have the geopackage->ENC.gpkg connection. If not, right-click on ‘Geopackage’->new connection, then point to your ENC.gpkg file.<\/li>\n\n\n\n
Connect to the downloaded layers_natsurf.gpkg table (right-click on ‘Geopackage’->new connection, then point to the downloaded geopackage)<\/li>\n\n\n\n
Select layer_styles in layers_natsurf.gpkg, then right-click->add to canvas, and you’ll have the layer_styles table in the list of loaded layers.<\/li>\n\n\n\n
Select natsurf in layers_natsurf.gpkg, then right-click->add to canvas, and you’ll have the natsurf table in the list of loaded layers.<\/li>\n\n\n\n
Select the ENC.gpkg geopackage in the database manager.<\/li>\n\n\n\n
In the Table menu, select Import layer\/file.<\/li>\n\n\n\n
In the list of layers, select natsurf, then OK<\/li>\n\n\n\n
Repeat the operation for the layer_styles layer.<\/li>\n<\/ul>\n\n\n\n
The current version of layer_styles contains symbology layouts for 153 layers. Check regularly for updates available for download.<\/p>\n\n\n\n
This symbology uses svg symbols that you need to download to your machine. Clicking here will download a ‘nauticalV3’ <\/a>file containing all the necessary svg symbols, as well as a directory named ‘XML’ with additional symbols for QGis.<\/p>\n\n\n\n
To install the nautical directory, please refer to the article Creating a Geopackage database for ENC maps (part 2: adding symbology).<\/a><\/p>\n\n\n\n
The layer_styles table contains the symbology of 153 layers, the usual layers for ENC files. However, there can be up to 210 possible layers. If, in your case, the layer_styles table does not contain one or more layers from your project, please refer to the article Updating(2) : ENC symbology with Geopackage under QGis<\/a> for adding these missing symbologies from the .qml style files for all layers (V1, V2 and V3), which can be downloaded here.<\/a><\/p>\n\n\n\n
Symbologies that change with this new version<\/h1>\n\n\n\n
The qml files contained in the qmlV3 directory are adapted to the updated processing chain, which not only retrieves primitives and assigns POSACC and QUAPOS values to the various S57 layers, but also to certain symbologies that have been specified. If you start with the V3 processing chain, you don’t need to do anything to set up these symbologies. They are defined by default in layer_stylesV3. If you’re migrating from a Geopackage V2 base to V3, please refer to the article Update(2) : Symbologie ENC avec Geopackage sous QGis<\/a> for the addition of these missing symbologies from the .qml style files of all layers (V1, V2 and V3).<\/p>\n\n\n\n
Soundg (bathymetric probes)<\/h2>\n\n\n\n
The following table shows the V3 symbology of the SOUNDG layer and the attribute values used to format it.<\/p>\n\n\n\n\n\n\n\t\n\n\t\n\t\n\t\n\t\n\t\n\t
Symbole<\/th> QUASOU<\/th> QUAPOS<\/th> Label<\/th>\n<\/tr>\n<\/thead>\n
$\"\"$ <\/a><\/td> 1<\/td> <\/td> Sounding in true position
\nSonde dans sa position vraie<\/td>\n<\/tr>\n
$\"\"$ <\/a><\/td> 5<\/td> <\/td> No bottom found at depth shown
\nPas de fond trouv\u00e9 \u00e0 la profondeur indiqu\u00e9e <\/td>\n<\/tr>\n
$\"\"$ <\/a><\/td> 4<\/td> 4<\/td> Soundings which are unreliable or taken from smaller scale
\nsource
\nSondes qui sont nonfiables ou provenant de sources \u00e0 plus
\npetite \u00e9chelle<\/td>\n<\/tr>\n
$\"\"$ <\/a><\/td> 1 (DEPTH<0)<\/td> <\/td> Drying heights above chart datum
\nSondes d\u00e9couvrantes audessus du z\u00e9ro des cartes <\/td>\n<\/tr>\n
$\"\"$ <\/a><\/td> 3<\/td> <\/td> Sounding doubtful
\nSonde douteuse <\/td>\n<\/tr>\n
$\"\"$ <\/a><\/td> 9<\/td> 8<\/td> Reported, but not confirmed sounding or danger
\nSonde ou danger signal\u00e9 mais non confirm\u00e9<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n\n\n
Obstrn (Obstructions)<\/h2>\n\n\n\n
The following table shows the V3 symbology of the OBSTRN (points) layer and the attribute values used to format it.<\/p>\n\n\n\n\n\n\n\t\n\n\t\n\t\n\t
Symbole<\/th> QUASOU<\/th> TECSOU<\/th> Label<\/th>\n<\/tr>\n<\/thead>\n
$\"\"$ <\/a><\/td> 2<\/td> <\/td> Obstruction, depth unknown
\nObstruction de profondeur inconnue<\/td>\n<\/tr>\n
$\"\"$ <\/a><\/td> 1 or 6<\/td> <\/td> Obstruction, least depth known by sounding only
\nObstruction, profondeur moindre connue, a \u00e9t\u00e9 d\u00e9termin\u00e9
\nseulement par sondage<\/td>\n<\/tr>\n
$\"\"$ <\/a><\/td> 6<\/td> 6<\/td> Obstruction, least depth known, swept by wire drag or diver
\nObstruction, profondeur moindre connue, v\u00e9rifi\u00e9e \u00e0 la
\ndrague hydrographique ou par plongeur<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n\n\n
UWTROC (submerged \/ exposed rock)<\/h2>\n\n\n\n
The following table shows the V3 symbology of the UWTROC layer and the attribute values used to format it.<\/p>\n\n\n\n\n\n\n\t\n\n\t\n\t\n\t\n\t\n\t
Symbole<\/th> WATLEV<\/th> QUASOU<\/th> Label<\/th>\n<\/tr>\n<\/thead>\n
$\"\"$ <\/a><\/td> 4<\/td> 2<\/td> Rock which covers and uncovers, with height
\nunknown above chart datum
\nRoche qui couvre et d\u00e9couvre, avec cote audessus du z\u00e9ro
\ndes cartes inconnue <\/td>\n<\/tr>\n
$\"\"$ <\/a><\/td> 4<\/td> !=2<\/td> Rock which covers and uncovers, with height known above chart datum
\nRoche qui couvre et d\u00e9couvre, avec cote audessus du z\u00e9ro
\ndes cartes connue<\/td>\n<\/tr>\n
$\"\"$ <\/a><\/td> 5<\/td> <\/td> Rock awash at chart datum
\nRoche \u00e0 fleur d\u2019eau au z\u00e9ro des cartes<\/td>\n<\/tr>\n
$\"\"$ <\/a><\/td> 3<\/td> 2<\/td> Underwater rock of unknown depth, dangerous to surface
\nnavigation
\nRoche submerg\u00e9e de profondeur inconnue, pr\u00e9sentant un
\ndanger \u00e0 la navigation de surface<\/td>\n<\/tr>\n
$\"\"$ <\/a><\/td> 3<\/td> !=2<\/td> Underwater rock of known depth
\nRoche submerg\u00e9e, de profondeur connue <\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n\n\n
Wrecks<\/h2>\n\n\n\n
The following table shows the V3 symbology of the WRECKS layer and the attribute values used to format it.<\/p>\n\n\n\n\n\n\n\t\n\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t
Symbole<\/th> CATWRK<\/th> WATLEV<\/th> QUASOU<\/th> TECSOU<\/th> Label<\/th>\n<\/tr>\n<\/thead>\n
$\"\"$ <\/a><\/td> 5<\/td> <\/td> <\/td> <\/td> Wreck showing any portion of hull or superstructure at level
\nof chart datum
\n\u00c9pave montrant une portion de la coque ou superstructure
\nau niveau du z\u00e9ro des cartes<\/td>\n<\/tr>\n
$\"\"$ <\/a><\/td> 4<\/td> <\/td> <\/td> <\/td> Wreck of which only the mast or masts are visible at chart
\ndatum
\n\u00c9pave dont seul(s) le(s) m\u00e2t(s) est (sont) visible(s) au niveau
\ndu zero des cartes<\/td>\n<\/tr>\n
$\"\"$ <\/a><\/td> <\/td> 3<\/td> 1 or 6<\/td> <\/td> Wreck, least depth known by sounding only
\n\u00c9pave, la profondeur connue a \u00e9t\u00e9 d\u00e9termin\u00e9 seulement par
\nsondage<\/td>\n<\/tr>\n
$\"\"$ <\/a><\/td> <\/td> 3<\/td> 1 or 6<\/td> 4<\/td> Wreck, least depth known, swept by wire drag or diver
\n\u00c9pave, profondeur moindre connue v\u00e9rifi\u00e9e \u00e0 la drague
\nhydrographique ou par plongeur<\/td>\n<\/tr>\n
$\"\"$ <\/a><\/td> 2<\/td> 3<\/td> 2<\/td> <\/td> Wreck, least depth unknown, considered to be potentially
\ndangerous to some surface vessels
\n\u00c9pave de brassiage inconnu, constituant un danger
\npotentiel pour certains b\u00e2timents de surface.<\/td>\n<\/tr>\n
$\"\"$ <\/a><\/td> 1<\/td> 3<\/td> 2<\/td> <\/td> Wreck, least depth unknown
\nCaution: On many charts, this symbol is used for wrecks of
\nunknown least depth, but considered to be covered by more
\nthan 20m of water. The wrecks thus represented are then
\npotentially dangerous to vessels with a draught greater than
\n20m. Note: This symbol is also used for all wrecks in water
\nover 200m deep.
\n\u00c9pave de brassiage inconnu
\nAvertissement important : sur de nombreuses cartes, ce
\nsymbole est utilis\u00e9 pour les \u00e9paves de brassiage inconnu,
\nsuppos\u00e9es couvertes de plus de 20 m\u00e8tres d\u2019eau. Les
\n\u00e9paves ainsi repr\u00e9sent\u00e9es sont alors potentiellement
\ndangereuses pour les navires d\u2019un tirant d\u2019eau sup\u00e9rieur \u00e0
\n20 m\u00e8tres. Note : ce symbole est aussi utilis\u00e9 pour toutes
\nles \u00e9paves dans des fonds sup\u00e9rieurs \u00e0 200m<\/td>\n<\/tr>\n
$\"\"$ <\/a><\/td> <\/td> 3<\/td> 7<\/td> <\/td> Wreck, least depth unknown, but considered to have a safe
\nclearance to depth shown
\n\u00c9pave, profondeur moindre inconnue, mais avec estimation
\ndu plafond de brassiage \u00e0 la profondeur indiqu\u00e9e<\/td>\n<\/tr>\n
$\"\"$ <\/a><\/td> 3<\/td> <\/td> <\/td> <\/td> Remains of a wreck or other foul ground, non dangerous to
\nnavigation but to be avoided by vessels anchoring, trawling etc.
\nVestige d\u2019une \u00e9pave ou autre sol de fonds malsains, non dangereux
\npour la navigation mais qui constituent un danger pour le mouillage,
\nle chalutage, etc.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n\n\n
DEPCNT (Bathymetric contours)<\/h2>\n\n\n\n
$\"\"$ <\/a><\/figure>\n\n\n\n
The new version of the symbology takes into account data quality (approximate isobaths).<\/p>\n\n\n\n\n\n\n\t\n\n\t\n\t\n\t
Symbole<\/th> VALDCO<\/th> QUAPOS<\/th> Label<\/th>\n<\/tr>\n<\/thead>\n
$\"\"$ <\/a><\/td> >=0<\/td> <\/td> Isobathes
\nDepth contours<\/td>\n<\/tr>\n
$\"\"$ <\/a><\/td> <0<\/td> <\/td> Isobathe d\u00e9couvrante
\nDrying contour<\/td>\n<\/tr>\n
$\"\"$ <\/a><\/td> <\/td> 4 ou 5<\/td> Isobathes approch\u00e9es
\nApproximate depth
\ncontours<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n\n\n
COALNE (coastline)<\/h2>\n\n\n\n
$\"\"$ <\/a><\/figure>\n\n\n\n
A new category has been added: Unsurveyed when the QUAPOS attribute is 4 or 5. It is symbolized by a dashed line<\/p>\n\n\n\n
LNDELV (contour lines)<\/h2>\n\n\n\n
$\"\"$ <\/a><\/figure>\n\n\n\n
Like isobaths, contour lines are now symbolized with a dashed line when the QUAPOS value is 4 or 5.<\/p>\n\n\n\n
LNDMRK, SEAARE,UWTROC , LNDELV, OBSTRN, WRECKS(Point type)<\/h2>\n\n\n\n
The labels for the depth or elevation values of these layers take the QUAPOS value into account. They now have a PA (Approximate Position) prefix when QUAPOS has a value of 4 and a PD (Doubtful Position) prefix when QUAPOS has a value of 5.<\/p>\n\n\n\n
SBDARE (nature of seabed)<\/h2>\n\n\n\n
The new symbology requires some special work. In earlier versions, we had set up a symbology that used the natsurf table to format the labels required for background types. The whole process was managed at the level of the label generation expression. While this solution was viable for a small number of maps in the database, the calculation times required for larger numbers became prohibitive.
For this final version, we opted for the implementation of a python script that generates a \u00ab\u00a0Label\u00a0\u00bb attribute in the SBDARE table. This attribute is used as a label and enables almost instantaneous display of the layer.<\/p>\n\n\n\n
Load the pt_SBDARE layer and the natsurf table into your project.<\/p>\n\n\n\n
Create the Label attribute in the pt_SBDARE table:<\/p>\n\n\n\n
Open the attribute table -> Field calculator<\/p>\n\n\n\n
$\"\"$ <\/a><\/figure>\n\n\n\n
Name the Label field, of type Text, and enter a default value of \u00a0\u00bb.<\/p>\n\n\n\n
In the python console, load the Label_sbdare.py script, which you can download here<\/a>.<\/p>\n\n\n\n
$\"\"$ <\/a><\/figure>\n\n\n\n
Once executed, you’ll get the labels in the table’s Label attribute:<\/p>\n\n\n\n
$\"\"$ <\/a><\/figure>\n\n\n\n
LIGHTS <\/h2>\n\n\n\n
The symbology of lights has been enriched. Three types of lights are now symbolized<\/p>\n\n\n\n
$\"\"$ <\/a><\/figure>\n\n\n\n
\n
Sector lights<\/li>\n<\/ul>\n\n\n\n
$\"\"$ <\/a><\/figure>\n\n\n\n
\n
Directional lights<\/li>\n<\/ul>\n\n\n\n
$\"\"$ <\/a><\/figure>\n\n\n\n
\n
Main and secondary lights<\/li>\n<\/ul>\n\n\n\n
For this last category, two types of representation are available<\/p>\n\n\n\n
\n
ECDIS type with colored circles<\/li>\n<\/ul>\n\n\n\n
$\"\"$ <\/a><\/figure>\n\n\n\n
\n
Paper map with colored symbols<\/li>\n<\/ul>\n\n\n\n
$\"\"$ <\/a><\/figure>\n\n\n\n
The qmlV3 directory contains two symbology files for the Lights layer<\/p>\n\n\n\n
\n
pt_lightsPoint.qml<\/li>\n\n\n\n
pt_lightsMultipoint.qml<\/li>\n<\/ul>\n\n\n\n
The Lights table resulting from the V1 and V2 import process is of type Point. However, in order to retrieve primitives, modifications to the ogr2ogr command produce a Multipoint Lights layer. By default, the symbology of the layer_styles V3 table is Multipoint.<\/p>\n\n\n\n
If you are working with a base with the Points type table, you can load the corresponding symbology and save it as the default symbology in layer_styles.<\/p>\n\n\n\n
Both symbologies have been corrected by an angular deviation compared to previous versions. Working with layers in geographic coordinates means that latitudinal and longitudinal distances are not of a constant ratio. If a delta X and a delta Y have the same length on the equator, the further away you are from the equator, the more the delta X decreases in relation to the delta Y. To draw the lines of the sectors starting from the fire, we create a point at the same distance X and Y in the direction of the sector. To ensure that the resulting angle is that of the sector, apply a correction by multiplying by the tangent of the point’s latitude. The actual angles displayed in previous versions deviated by up to 10\u00b0 from the value of the SECTR1 and SECTR2 attributes. The tangent(Latitude) correction is an approximation that reduces this deviation to around 1\u00b0.<\/p>\n","protected":false},"excerpt":{"rendered":"
The project to integrate ENC maps into QGis in the form of Geopackage is now complete. This article completes the two previously published articles on ENC symbology in the Geopackage database. Adding symbology to Geopackage The…<\/p>\n","protected":false},"author":1,"featured_media":12821,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"give_campaign_id":0,"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"sfsi_plus_gutenberg_text_before_share":"","sfsi_plus_gutenberg_show_text_before_share":"","sfsi_plus_gutenberg_icon_type":"","sfsi_plus_gutenberg_icon_alignemt":"","sfsi_plus_gutenburg_max_per_row":"","_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[1377],"tags":[1386,2721,2723,2715],"class_list":["post-12832","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-qgis-en","tag-qgis-en","tag-s57-en","tag-svg-en","tag-symbology"],"aioseo_notices":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2024\/04\/article.png?fit=2878%2C1783&ssl=1","jetpack_shortlink":"https:\/\/wp.me\/p6XU0A-3kY","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/posts\/12832","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/comments?post=12832"}],"version-history":[{"count":0,"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/posts\/12832\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/media\/12821"}],"wp:attachment":[{"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/media?parent=12832"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/categories?post=12832"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/tags?post=12832"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}

LIGHTS <\/h2>\n\n\n\nThe symbology of lights has been enriched. Three types of lights are now symbolized<\/p>\n\n\n\n