{"id":11338,"date":"2023-07-21T11:36:05","date_gmt":"2023-07-21T09:36:05","guid":{"rendered":"https:\/\/www.sigterritoires.fr\/?page_id=11338"},"modified":"2023-07-22T13:24:33","modified_gmt":"2023-07-22T11:24:33","slug":"blogen","status":"publish","type":"page","link":"https:\/\/www.sigterritoires.fr\/index.php\/en\/blogen\/","title":{"rendered":"Blog(en)"},"content":{"rendered":"<ul class=\"wp-block-latest-posts__list wp-block-latest-posts\"><li><a class=\"wp-block-latest-posts__post-title\" href=\"https:\/\/www.sigterritoires.fr\/index.php\/en\/optimize-postgis-queries\/\">[EN] Optimizing PostGIS Queries: A Practical Guide to Improving Performance<\/a><div class=\"wp-block-latest-posts__post-excerpt\">Spatial databases can contain millions of geographic objects. In some cases, a <a href=\"https:\/\/www.sigterritoires.fr\/index.php\/en\/starting-with-postgres-postgis\/\">PostGIS<\/a> query may take several seconds \u2014 or even several minutes \u2014 to execute. This problem often occurs when: In this article, we will&hellip;<\/div><\/li>\n<li><a class=\"wp-block-latest-posts__post-title\" href=\"https:\/\/www.sigterritoires.fr\/index.php\/optimiser-requetes-postgis\/\">[FR]Optimiser les requ\u00eates PostGIS : guide pratique pour am\u00e9liorer les performances<\/a><div class=\"wp-block-latest-posts__post-excerpt\">Les bases de donn\u00e9es spatiales peuvent contenir des millions d\u2019objets g\u00e9ographiques. Dans certains cas, une requ\u00eate PostGIS peut prendre plusieurs secondes, voire plusieurs minutes. Ce probl\u00e8me appara\u00eet souvent lorsque : Dans cet article, nous allons voir&hellip;<\/div><\/li>\n<li><a class=\"wp-block-latest-posts__post-title\" href=\"https:\/\/www.sigterritoires.fr\/index.php\/pt\/postgis-st-intersects-vs-st-within-3\/\">[PT]ST_Intersects vs ST_Within: entendendo as rela\u00e7\u00f5es espaciais no PostGIS<\/a><div class=\"wp-block-latest-posts__post-excerpt\">Ao trabalhar com PostGIS, entender as rela\u00e7\u00f5es espaciais entre geometrias \u00e9 essencial para construir consultas eficientes. Duas das fun\u00e7\u00f5es mais utilizadas \u2014 <a href=\"https:\/\/www.sigterritoires.fr\/index.php\/en\/postgis-st-intersects-vs-st-within\/\">ST_Intersects<\/a> e ST_Within \u2014 costumam gerar d\u00favidas, embora tenham finalidades diferentes. Neste guia, voc\u00ea&hellip;<\/div><\/li>\n<li><a class=\"wp-block-latest-posts__post-title\" href=\"https:\/\/www.sigterritoires.fr\/index.php\/es\/postgis-st-intersects-vs-st-within-2\/\">[ES]ST_Intersects vs ST_Within: entender las relaciones espaciales en PostGIS<\/a><div class=\"wp-block-latest-posts__post-excerpt\">Cuando trabajamos con PostGIS, entender las relaciones espaciales entre geometr\u00edas es clave para construir consultas eficientes. Dos de las funciones m\u00e1s utilizadas \u2014ST_Intersects y ST_Within\u2014 suelen confundirse, aunque responden a necesidades distintas. En esta gu\u00eda aprender\u00e1s&hellip;<\/div><\/li>\n<li><a class=\"wp-block-latest-posts__post-title\" href=\"https:\/\/www.sigterritoires.fr\/index.php\/en\/postgis-st-intersects-vs-st-within\/\">[EN]ST_Intersects vs ST_Within: Understanding Spatial Relationships in PostGIS<\/a><div class=\"wp-block-latest-posts__post-excerpt\">When working with PostGIS, understanding spatial relationships between geometries is essential for building efficient queries. Two of the most widely used functions\u2014ST_Intersects and ST_Within\u2014are often confused, yet they serve different purposes. In this guide, you\u2019ll learn&hellip;<\/div><\/li>\n<li><a class=\"wp-block-latest-posts__post-title\" href=\"https:\/\/www.sigterritoires.fr\/index.php\/st-intersects-vs-st-within\/\">[FR]ST_Intersects vs ST_Within : comprendre les relations spatiales dans PostGIS<\/a><div class=\"wp-block-latest-posts__post-excerpt\">Lorsque l\u2019on travaille avec PostGIS, il est fr\u00e9quent d\u2019utiliser des fonctions spatiales pour analyser la relation entre des objets g\u00e9ographiques. Deux fonctions tr\u00e8s utilis\u00e9es sont ST_Intersects et ST_Within. Ces fonctions permettent de tester la relation spatiale&hellip;<\/div><\/li>\n<li><a class=\"wp-block-latest-posts__post-title\" href=\"https:\/\/www.sigterritoires.fr\/index.php\/pt\/georreferenciar-imagem-qgis\/\">[PT]Como georreferenciar uma imagem no QGIS (passo a passo completo)<\/a><div class=\"wp-block-latest-posts__post-excerpt\">O georreferenciamento no QGIS \u00e9 uma t\u00e9cnica essencial para alinhar uma imagem com coordenadas reais usando pontos de controle. Se voc\u00ea trabalha com mapas escaneados, plantas em PDF ou imagens sem refer\u00eancia espacial, este tutorial vai&hellip;<\/div><\/li>\n<li><a class=\"wp-block-latest-posts__post-title\" href=\"https:\/\/www.sigterritoires.fr\/index.php\/es\/georreferenciar-imagen-qgis\/\">[ES]C\u00f3mo georreferenciar una imagen en QGIS (gu\u00eda paso a paso)<\/a><div class=\"wp-block-latest-posts__post-excerpt\">C\u00f3mo georreferenciar una imagen en QGIS (gu\u00eda paso a paso) La georreferenciaci\u00f3n en QGIS es una t\u00e9cnica esencial que permite alinear una imagen con coordenadas reales utilizando puntos de control. Si trabajas con mapas escaneados, planos&hellip;<\/div><\/li>\n<li><a class=\"wp-block-latest-posts__post-title\" href=\"https:\/\/www.sigterritoires.fr\/index.php\/en\/georeferencing-qgis-guide\/\">[EN]How to Georeference an Image in QGIS (Step-by-Step Guide)<\/a><div class=\"wp-block-latest-posts__post-excerpt\">Georeferencing in QGIS is an essential technique that allows you to align an image with real-world geographic coordinates using control points. Whether you&rsquo;re working with a scanned map, a PDF plan, or an image without spatial&hellip;<\/div><\/li>\n<li><a class=\"wp-block-latest-posts__post-title\" href=\"https:\/\/www.sigterritoires.fr\/index.php\/georeferencer-image-qgis\/\">[FR]G\u00e9or\u00e9f\u00e9rencer une image dans QGIS : guide simple pas \u00e0 pas<\/a><div class=\"wp-block-latest-posts__post-excerpt\">Le g\u00e9or\u00e9f\u00e9rencement dans QGIS permet d\u2019aligner une image avec des coordonn\u00e9es r\u00e9elles \u00e0 l\u2019aide de points de contr\u00f4le. En pratique, il suffit d\u2019ajouter des points de contr\u00f4le pour associer des pixels \u00e0 des coordonn\u00e9es g\u00e9ographiques. Dans&hellip;<\/div><\/li>\n<\/ul>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","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,"footnotes":""},"class_list":["post-11338","page","type-page","status-publish","hentry"],"aioseo_notices":[],"campaignId":"","jetpack_shortlink":"https:\/\/wp.me\/P6XU0A-2WS","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/pages\/11338","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/types\/page"}],"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=11338"}],"version-history":[{"count":0,"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/pages\/11338\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/media?parent=11338"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}