{"id":72768,"date":"2021-09-09T16:00:06","date_gmt":"2021-09-09T13:00:06","guid":{"rendered":"https:\/\/azbuki.bg\/?p=72768"},"modified":"2021-09-09T16:00:06","modified_gmt":"2021-09-09T13:00:06","slug":"s-101-charts-database-tables-for-s-101-charts-autonomous-vessel","status":"publish","type":"post","link":"https:\/\/vocedu.azbuki.bg\/en\/uncategorized\/s-101-charts-database-tables-for-s-101-charts-autonomous-vessel\/","title":{"rendered":"S-101 Charts, Database Tables  For S-101 Charts, Autonomous Vessel"},"content":{"rendered":"<p><strong>Vladimir Brozovi\u0107, Danko Kezi\u0107, Rino Bo\u0161njak, Filip Boji\u0107<\/strong><br \/>\n<em>University of Split (Croatia)<\/em><\/p>\n<p><a href=\"https:\/\/doi.org\/10.53656\/ped21-7s.02s101\" target=\"_blank\" rel=\"noopener noreferrer\">https:\/\/doi.org\/10.53656\/ped21-7s.02s101<\/a><\/p>\n<p><strong>Abstract.<\/strong> This article shows a way to store the data of many S-101 charts into a single Postgres database. The data model of the database with all tables is shown and explained. The concatenation of the indices from the different database tables is explained. This concatenation allows for a faster search of points\/curves with certain properties. This fulfills one of the basic requirements for the purpose of navigating an autonomous vessel \u2013 that several charts can be interpreted simultaneously by a machine. Mechanisms for up-dating the database with new charts not yet present in the database are shown. Also the mechanisms for updating the charts already present in the database are explained. System limitations are briefly presented to show that in practical use there are in fact none. Memory requirements for such a type of chart storage in the database is compared with memory requirements for ISO8211 files normally used for storage of S-101 charts. With small examples it is finally shown how the stored chart information can be searched specifically.<br \/>\n<em>Keywords:<\/em> S-101 charts; charts database; autonomous vessel<\/p>\n<p><a href=\"https:\/\/azbuki.bg\/wp-content\/uploads\/2021\/09\/Pedagogy_7s_21_Vladimir-Brozovic.pdf\" target=\"_blank\" rel=\"noopener noreferrer\">Open the full text<\/a><\/p>","protected":false},"excerpt":{"rendered":"<p>Vladimir Brozovi\u0107, Danko Kezi\u0107, Rino Bo\u0161njak, Filip Boji\u0107 University of Split (Croatia) https:\/\/doi.org\/10.53656\/ped21-7s.02s101 Abstract. This article shows a way to store the data of many S-101 charts into a single Postgres database. The data model of the database with all tables is shown and explained. The concatenation of the indices from the different database tables [&hellip;]<\/p>","protected":false},"author":124332423426818,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jnews-multi-image_gallery":[],"jnews_single_post":{"subtitle":"","format":"standard","video":"","gallery":"","source_name":"","source_url":"","via_name":"","via_url":"","override_template":"0","override":[{"single_blog_custom":"","parallax":"0","fullscreen":"0","sidebar":"","second_sidebar":"","sticky_sidebar":"0","share_position":"","share_float_style":"","show_share_counter":"0","show_view_counter":"0","show_featured":"0","show_post_meta":"0","show_post_author":"0","show_post_author_image":"0","show_post_date":"0","post_date_format":"","post_date_format_custom":"","show_post_category":"0","show_post_reading_time":"0","post_reading_time_wpm":"","show_post_tag":"0","show_prev_next_post":"0","show_popup_post":"0","number_popup_post":"1","show_author_box":"0","show_post_related":"0","show_inline_post_related":"0"}],"override_image_size":"0","image_override":[{"single_post_thumbnail_size":"","single_post_gallery_size":""}],"trending_post":"0","trending_post_position":"","trending_post_label":""},"jnews_primary_category":{"id":""}},"categories":[1],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.7 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>S-101 Charts, Database Tables For S-101 Charts, Autonomous Vessel - \u0410\u0437-\u0431\u0443\u043a\u0438<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/azbuki.bg\/uncategorized\/s-101-charts-database-tables-for-s-101-charts-autonomous-vessel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"S-101 Charts, Database Tables For S-101 Charts, Autonomous Vessel - \u0410\u0437-\u0431\u0443\u043a\u0438\" \/>\n<meta property=\"og:description\" content=\"Vladimir Brozovi\u0107, Danko Kezi\u0107, Rino Bo\u0161njak, Filip Boji\u0107 University of Split (Croatia) https:\/\/doi.org\/10.53656\/ped21-7s.02s101 Abstract. This article shows a way to store the data of many S-101 charts into a single Postgres database. The data model of the database with all tables is shown and explained. The concatenation of the indices from the different database tables [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/azbuki.bg\/uncategorized\/s-101-charts-database-tables-for-s-101-charts-autonomous-vessel\/\" \/>\n<meta property=\"og:site_name\" content=\"\u0410\u0437-\u0431\u0443\u043a\u0438\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/Azbuki55\/\" \/>\n<meta property=\"article:published_time\" content=\"2021-09-09T13:00:06+00:00\" \/>\n<meta name=\"author\" content=\"v.genkov@azbuki.bg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"v.genkov@azbuki.bg\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/azbuki.bg\/uncategorized\/s-101-charts-database-tables-for-s-101-charts-autonomous-vessel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/azbuki.bg\/uncategorized\/s-101-charts-database-tables-for-s-101-charts-autonomous-vessel\/\"},\"author\":{\"name\":\"v.genkov@azbuki.bg\",\"@id\":\"https:\/\/azbuki.bg\/#\/schema\/person\/92cc38d6a11fb032bf6299efd22a71c5\"},\"headline\":\"S-101 Charts, Database Tables For S-101 Charts, Autonomous Vessel\",\"datePublished\":\"2021-09-09T13:00:06+00:00\",\"dateModified\":\"2021-09-09T13:00:06+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/azbuki.bg\/uncategorized\/s-101-charts-database-tables-for-s-101-charts-autonomous-vessel\/\"},\"wordCount\":213,\"publisher\":{\"@id\":\"https:\/\/azbuki.bg\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/azbuki.bg\/uncategorized\/s-101-charts-database-tables-for-s-101-charts-autonomous-vessel\/\",\"url\":\"https:\/\/azbuki.bg\/uncategorized\/s-101-charts-database-tables-for-s-101-charts-autonomous-vessel\/\",\"name\":\"S-101 Charts, Database Tables For S-101 Charts, Autonomous Vessel - \u0410\u0437-\u0431\u0443\u043a\u0438\",\"isPartOf\":{\"@id\":\"https:\/\/azbuki.bg\/#website\"},\"datePublished\":\"2021-09-09T13:00:06+00:00\",\"dateModified\":\"2021-09-09T13:00:06+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/azbuki.bg\/uncategorized\/s-101-charts-database-tables-for-s-101-charts-autonomous-vessel\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/azbuki.bg\/uncategorized\/s-101-charts-database-tables-for-s-101-charts-autonomous-vessel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/azbuki.bg\/uncategorized\/s-101-charts-database-tables-for-s-101-charts-autonomous-vessel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/mathinfo.azbuki.bg\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"S-101 Charts, Database Tables For S-101 Charts, Autonomous Vessel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/azbuki.bg\/#website\",\"url\":\"https:\/\/azbuki.bg\/\",\"name\":\"\u0410\u0437-\u0431\u0443\u043a\u0438\",\"description\":\"\u041d\u0430\u0446\u0438\u043e\u043d\u0430\u043b\u043d\u043e \u0438\u0437\u0434\u0430\u0442\u0435\u043b\u0441\u0442\u0432\u043e \u0437\u0430 \u043e\u0431\u0440\u0430\u0437\u043e\u0432\u0430\u043d\u0438\u0435 \u0438 \u043d\u0430\u0443\u043a\u0430\",\"publisher\":{\"@id\":\"https:\/\/azbuki.bg\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/azbuki.bg\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/azbuki.bg\/#organization\",\"name\":\"\u0410\u0437-\u0431\u0443\u043a\u0438\",\"url\":\"https:\/\/azbuki.bg\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/azbuki.bg\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/azbuki.bg\/wp-content\/uploads\/2019\/04\/logo-azbuki-e1580374651845.png\",\"contentUrl\":\"https:\/\/azbuki.bg\/wp-content\/uploads\/2019\/04\/logo-azbuki-e1580374651845.png\",\"width\":250,\"height\":70,\"caption\":\"\u0410\u0437-\u0431\u0443\u043a\u0438\"},\"image\":{\"@id\":\"https:\/\/azbuki.bg\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/Azbuki55\/\",\"https:\/\/www.instagram.com\/nion_azbuki\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/azbuki.bg\/#\/schema\/person\/92cc38d6a11fb032bf6299efd22a71c5\",\"name\":\"v.genkov@azbuki.bg\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/azbuki.bg\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/3615ec69795d828958c71f5ecd30c623?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/3615ec69795d828958c71f5ecd30c623?s=96&d=mm&r=g\",\"caption\":\"v.genkov@azbuki.bg\"},\"url\":\"https:\/\/vocedu.azbuki.bg\/en\/author\/v-genkovazbuki-bg\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"S-101 Charts, Database Tables For S-101 Charts, Autonomous Vessel - \u0410\u0437-\u0431\u0443\u043a\u0438","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/azbuki.bg\/uncategorized\/s-101-charts-database-tables-for-s-101-charts-autonomous-vessel\/","og_locale":"en_US","og_type":"article","og_title":"S-101 Charts, Database Tables For S-101 Charts, Autonomous Vessel - \u0410\u0437-\u0431\u0443\u043a\u0438","og_description":"Vladimir Brozovi\u0107, Danko Kezi\u0107, Rino Bo\u0161njak, Filip Boji\u0107 University of Split (Croatia) https:\/\/doi.org\/10.53656\/ped21-7s.02s101 Abstract. This article shows a way to store the data of many S-101 charts into a single Postgres database. The data model of the database with all tables is shown and explained. The concatenation of the indices from the different database tables [&hellip;]","og_url":"https:\/\/azbuki.bg\/uncategorized\/s-101-charts-database-tables-for-s-101-charts-autonomous-vessel\/","og_site_name":"\u0410\u0437-\u0431\u0443\u043a\u0438","article_publisher":"https:\/\/www.facebook.com\/Azbuki55\/","article_published_time":"2021-09-09T13:00:06+00:00","author":"v.genkov@azbuki.bg","twitter_card":"summary_large_image","twitter_misc":{"Written by":"v.genkov@azbuki.bg","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/azbuki.bg\/uncategorized\/s-101-charts-database-tables-for-s-101-charts-autonomous-vessel\/#article","isPartOf":{"@id":"https:\/\/azbuki.bg\/uncategorized\/s-101-charts-database-tables-for-s-101-charts-autonomous-vessel\/"},"author":{"name":"v.genkov@azbuki.bg","@id":"https:\/\/azbuki.bg\/#\/schema\/person\/92cc38d6a11fb032bf6299efd22a71c5"},"headline":"S-101 Charts, Database Tables For S-101 Charts, Autonomous Vessel","datePublished":"2021-09-09T13:00:06+00:00","dateModified":"2021-09-09T13:00:06+00:00","mainEntityOfPage":{"@id":"https:\/\/azbuki.bg\/uncategorized\/s-101-charts-database-tables-for-s-101-charts-autonomous-vessel\/"},"wordCount":213,"publisher":{"@id":"https:\/\/azbuki.bg\/#organization"},"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/azbuki.bg\/uncategorized\/s-101-charts-database-tables-for-s-101-charts-autonomous-vessel\/","url":"https:\/\/azbuki.bg\/uncategorized\/s-101-charts-database-tables-for-s-101-charts-autonomous-vessel\/","name":"S-101 Charts, Database Tables For S-101 Charts, Autonomous Vessel - \u0410\u0437-\u0431\u0443\u043a\u0438","isPartOf":{"@id":"https:\/\/azbuki.bg\/#website"},"datePublished":"2021-09-09T13:00:06+00:00","dateModified":"2021-09-09T13:00:06+00:00","breadcrumb":{"@id":"https:\/\/azbuki.bg\/uncategorized\/s-101-charts-database-tables-for-s-101-charts-autonomous-vessel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/azbuki.bg\/uncategorized\/s-101-charts-database-tables-for-s-101-charts-autonomous-vessel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/azbuki.bg\/uncategorized\/s-101-charts-database-tables-for-s-101-charts-autonomous-vessel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/mathinfo.azbuki.bg\/en\/"},{"@type":"ListItem","position":2,"name":"S-101 Charts, Database Tables For S-101 Charts, Autonomous Vessel"}]},{"@type":"WebSite","@id":"https:\/\/azbuki.bg\/#website","url":"https:\/\/azbuki.bg\/","name":"\u0410\u0437-\u0431\u0443\u043a\u0438","description":"\u041d\u0430\u0446\u0438\u043e\u043d\u0430\u043b\u043d\u043e \u0438\u0437\u0434\u0430\u0442\u0435\u043b\u0441\u0442\u0432\u043e \u0437\u0430 \u043e\u0431\u0440\u0430\u0437\u043e\u0432\u0430\u043d\u0438\u0435 \u0438 \u043d\u0430\u0443\u043a\u0430","publisher":{"@id":"https:\/\/azbuki.bg\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/azbuki.bg\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/azbuki.bg\/#organization","name":"\u0410\u0437-\u0431\u0443\u043a\u0438","url":"https:\/\/azbuki.bg\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/azbuki.bg\/#\/schema\/logo\/image\/","url":"https:\/\/azbuki.bg\/wp-content\/uploads\/2019\/04\/logo-azbuki-e1580374651845.png","contentUrl":"https:\/\/azbuki.bg\/wp-content\/uploads\/2019\/04\/logo-azbuki-e1580374651845.png","width":250,"height":70,"caption":"\u0410\u0437-\u0431\u0443\u043a\u0438"},"image":{"@id":"https:\/\/azbuki.bg\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/Azbuki55\/","https:\/\/www.instagram.com\/nion_azbuki\/"]},{"@type":"Person","@id":"https:\/\/azbuki.bg\/#\/schema\/person\/92cc38d6a11fb032bf6299efd22a71c5","name":"v.genkov@azbuki.bg","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/azbuki.bg\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/3615ec69795d828958c71f5ecd30c623?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/3615ec69795d828958c71f5ecd30c623?s=96&d=mm&r=g","caption":"v.genkov@azbuki.bg"},"url":"https:\/\/vocedu.azbuki.bg\/en\/author\/v-genkovazbuki-bg\/"}]}},"_links":{"self":[{"href":"https:\/\/vocedu.azbuki.bg\/en\/wp-json\/wp\/v2\/posts\/72768"}],"collection":[{"href":"https:\/\/vocedu.azbuki.bg\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/vocedu.azbuki.bg\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/vocedu.azbuki.bg\/en\/wp-json\/wp\/v2\/users\/124332423426818"}],"replies":[{"embeddable":true,"href":"https:\/\/vocedu.azbuki.bg\/en\/wp-json\/wp\/v2\/comments?post=72768"}],"version-history":[{"count":1,"href":"https:\/\/vocedu.azbuki.bg\/en\/wp-json\/wp\/v2\/posts\/72768\/revisions"}],"predecessor-version":[{"id":72770,"href":"https:\/\/vocedu.azbuki.bg\/en\/wp-json\/wp\/v2\/posts\/72768\/revisions\/72770"}],"wp:attachment":[{"href":"https:\/\/vocedu.azbuki.bg\/en\/wp-json\/wp\/v2\/media?parent=72768"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/vocedu.azbuki.bg\/en\/wp-json\/wp\/v2\/categories?post=72768"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/vocedu.azbuki.bg\/en\/wp-json\/wp\/v2\/tags?post=72768"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}