{"version":"1.0","provider_name":"Inicio","provider_url":"https:\/\/www.go-inicio.com\/en","author_name":"Hugo Cisneros","author_url":"https:\/\/www.go-inicio.com\/en\/author\/cisnerosgo-inicio-com","title":"Optimizing Geospatial Workflows: Practical PostGIS Tricks - Inicio","type":"rich","width":600,"height":338,"html":"<blockquote class=\"wp-embedded-content\" data-secret=\"yqOFWlqYks\"><a href=\"https:\/\/www.go-inicio.com\/en\/optimizing-geospatial-workflows-practical-postgis-tricks\">Optimizing Geospatial Workflows: Practical PostGIS Tricks<\/a><\/blockquote><iframe sandbox=\"allow-scripts\" security=\"restricted\" src=\"https:\/\/www.go-inicio.com\/en\/optimizing-geospatial-workflows-practical-postgis-tricks\/embed#?secret=yqOFWlqYks\" width=\"600\" height=\"338\" title=\"&#8220;Optimizing Geospatial Workflows: Practical PostGIS Tricks&#8221; &#8212; Inicio\" data-secret=\"yqOFWlqYks\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\" class=\"wp-embedded-content\"><\/iframe><script>\n\/*! This file is auto-generated *\/\n!function(d,l){\"use strict\";l.querySelector&&d.addEventListener&&\"undefined\"!=typeof URL&&(d.wp=d.wp||{},d.wp.receiveEmbedMessage||(d.wp.receiveEmbedMessage=function(e){var t=e.data;if((t||t.secret||t.message||t.value)&&!\/[^a-zA-Z0-9]\/.test(t.secret)){for(var s,r,n,a=l.querySelectorAll('iframe[data-secret=\"'+t.secret+'\"]'),o=l.querySelectorAll('blockquote[data-secret=\"'+t.secret+'\"]'),c=new RegExp(\"^https?:$\",\"i\"),i=0;i<o.length;i++)o[i].style.display=\"none\";for(i=0;i<a.length;i++)s=a[i],e.source===s.contentWindow&&(s.removeAttribute(\"style\"),\"height\"===t.message?(1e3<(r=parseInt(t.value,10))?r=1e3:~~r<200&&(r=200),s.height=r):\"link\"===t.message&&(r=new URL(s.getAttribute(\"src\")),n=new URL(t.value),c.test(n.protocol))&&n.host===r.host&&l.activeElement===s&&(d.top.location.href=t.value))}},d.addEventListener(\"message\",d.wp.receiveEmbedMessage,!1),l.addEventListener(\"DOMContentLoaded\",function(){for(var e,t,s=l.querySelectorAll(\"iframe.wp-embedded-content\"),r=0;r<s.length;r++)(t=(e=s[r]).getAttribute(\"data-secret\"))||(t=Math.random().toString(36).substring(2,12),e.src+=\"#?secret=\"+t,e.setAttribute(\"data-secret\",t)),e.contentWindow.postMessage({message:\"ready\",secret:t},\"*\")},!1)))}(window,document);\n<\/script>\n","thumbnail_url":"https:\/\/www.go-inicio.com\/wp-content\/uploads\/2025\/03\/polys-1.png","thumbnail_width":976,"thumbnail_height":775,"description":"At Inicio, we manipulate terabytes of geographical data, utilizing both worldwide datasets and detailed regional ones. We process, store, and analyze this data to identify the best possible solar project locations in Europe. Most of the heavy lifting is handled by a PostGIS database\u2014an industry-standard, battle-tested solution for geospatial data manipulation. When I started working [&hellip;]"}