<?xml version="1.0" encoding="UTF-8"?><rss xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:atom="http://www.w3.org/2005/Atom" version="2.0" xmlns:cc="http://cyber.law.harvard.edu/rss/creativeCommonsRssModule.html">
    <channel>
        <title><![CDATA[Stories by Aahmed Bahaa on Medium]]></title>
        <description><![CDATA[Stories by Aahmed Bahaa on Medium]]></description>
        <link>https://medium.com/@aahmed.bahaa25?source=rss-dcdddba6d507------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/0*zyQ00lbDeoyoatv4</url>
            <title>Stories by Aahmed Bahaa on Medium</title>
            <link>https://medium.com/@aahmed.bahaa25?source=rss-dcdddba6d507------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Thu, 19 Nov 2026 23:47:51 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@aahmed.bahaa25/feed" rel="self" type="application/rss+xml"/>
        <webMaster><![CDATA[yourfriends@medium.com]]></webMaster>
        <atom:link href="http://medium.superfeedr.com/" rel="hub"/>
        <item>
            <title><![CDATA[PitchGrid: Solving Fullback Overlaps & Defensive Exposure via PostGIS]]></title>
            <link>https://medium.com/@aahmed.bahaa25/pitchgrid-solving-fullback-overlaps-defensive-exposure-via-postgis-ef73ccef58ef?source=rss-dcdddba6d507------2</link>
            <guid isPermaLink="false">https://medium.com/p/ef73ccef58ef</guid>
            <category><![CDATA[sports-journalists]]></category>
            <category><![CDATA[gis]]></category>
            <category><![CDATA[football]]></category>
            <category><![CDATA[postgis]]></category>
            <category><![CDATA[spatial-football]]></category>
            <dc:creator><![CDATA[Aahmed Bahaa]]></dc:creator>
            <pubDate>Tue, 11 Aug 2026 10:01:58 GMT</pubDate>
            <atom:updated>2026-08-11T10:01:58.818Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/746/1*Igg7b9B1jA-o_kM-tdgeug.jpeg" /></figure><p>PitchGrid: Solving Fullback Overlaps &amp; Defensive Exposure via PostGIS</p><h3>Measuring the Space Created When Fullbacks Attack</h3><p>Modern football has changed the role of the fullback.</p><p>Fullbacks are no longer limited to defending the wide areas.</p><p>They are expected to overlap, create width, support attacks, and move deep into the opponent’s half.</p><p>But every attacking movement creates another tactical question:</p><p><strong>What happens to the space they leave behind?</strong></p><p>When a fullback moves forward, the team may gain an attacking option on the flank — but at the same time, it can expose a new defensive space behind the player.</p><p>This is where traditional visual analysis can become difficult.</p><p>A tactical analyst may immediately notice that a fullback has advanced.</p><p>But the more important question is:</p><blockquote><strong><em>How much defensive exposure did that movement actually create?</em></strong></blockquote><p>As a GIS Analyst, I wanted to approach this problem as a spatial problem rather than relying only on visual interpretation.</p><p>That became the next stage of <strong>PitchGrid</strong>.</p><h3>From Fullback Movement to Defensive Exposure</h3><p>Instead of looking at the fullback as an isolated player, PitchGrid treats the movement as a change in the team’s spatial structure.</p><p>The fullback’s position becomes a spatial point.</p><p>The remaining defensive structure becomes another spatial system.</p><p>The space created between these elements can then be investigated using spatial relationships and geometric measurements.</p><p>This allows us to explore questions such as:</p><ul><li>How far has the fullback moved from the defensive structure?</li><li>Where does the exposed space begin?</li><li>How large is the defensive gap?</li><li>How does the movement affect the team’s spatial balance?</li><li>Can the defensive consequences of an attacking overlap be measured?</li></ul><p>The objective is not simply to measure how far a player runs.</p><p>It is to understand <strong>what spatial consequence that movement creates for the team.</strong></p><h3>The PostGIS Approach</h3><p>This is where <strong>PostgreSQL/PostGIS</strong> becomes the analytical engine.</p><p>Player positions can be represented as spatial geometries inside the database.</p><p>From there, spatial relationships and geometric measurements can be used to investigate the relationship between the advanced fullback and the remaining defensive structure.</p><p>Instead of analysing movement only as:</p><p><strong>Player A moved from Point A → Point B</strong></p><p>we can begin analysing it as:</p><p><strong>Player A moved → defensive structure changed → exposed space emerged.</strong></p><p>That shift in perspective is important.</p><p>Because in football, movement itself is not always the problem.</p><p><strong>The spatial consequence of movement is.</strong></p><h3>Why Fullback Overlaps Matter</h3><p>A fullback overlap can provide significant attacking value.</p><p>It can:</p><ul><li>Create width</li><li>Overload the flank</li><li>Provide an additional passing option</li><li>Stretch the opposition defensive structure</li><li>Support progression into the final third</li></ul><p>But the same movement can also create defensive vulnerability.</p><p>If the ball is lost while the fullback is advanced, the opposition may immediately attack the space behind them.</p><p>This creates a tactical balance:</p><p><strong>Attacking Width ↔ Defensive Exposure</strong></p><p>The goal of spatial analysis is to make this relationship measurable.</p><p>Instead of simply saying:</p><blockquote>“The fullback is too high.”</blockquote><p>we can ask:</p><blockquote><strong><em>“How much space has been exposed, where is it located, and how does the defensive structure respond?”</em></strong></blockquote><p>That is the type of question PitchGrid is designed to explore.</p><h3>🌐 Explore the Interactive Experience</h3><p>The analysis is presented as an interactive football pitch rather than a traditional static chart.</p><p>The spatial model allows the tactical situation to be explored directly on the pitch, making the relationship between player movement and defensive exposure easier to understand.</p><p>👉 <strong>Explore the Interactive Analysis:</strong></p><p><a href="https://kunah25med.github.io/Spatial-Football-Analytics-Article-3/">https://kunah25med.github.io/Spatial-Football-Analytics-Article-3/</a></p><p>This is the <strong>third chapter of the PitchGrid series</strong>.</p><p>The progression is intentional:</p><p><strong>Chapter 1:</strong> Build the spatial football environment.</p><p><strong>Chapter 2:</strong> Measure the team’s defensive spatial structure.</p><p><strong>Chapter 3:</strong> Investigate the defensive exposure created by fullback movement.</p><p>From <strong>pitch geometry → team geometry → tactical exposure.</strong></p><h3>Building Toward a Larger Spatial Football Framework</h3><p>Fullback exposure is only one example of what can be investigated through spatial football analytics.</p><p>The broader objective of <strong>PitchGrid</strong> is to develop a framework where different tactical situations can be represented as spatial problems.</p><p>Future analyses can explore concepts such as:</p><ul><li>Cover Rotation</li><li>Rest Defence</li><li>Passing Corridors</li><li>Blind Spot Detection</li><li>Spatial Relationships</li><li>Nearest-Player Analysis</li><li>Defensive Line Dynamics</li></ul><p>Each concept can then be connected to a specific spatial model and analysed using <strong>PostGIS</strong>.</p><p>The objective is not to replace traditional football analytics.</p><p>It is to add another dimension:</p><h3>The Spatial Dimension.</h3><h3>From Player Movement to Spatial Intelligence</h3><p>Football analytics often asks:</p><p><strong>What did the player do?</strong></p><p>Spatial football analytics can take the question one step further:</p><p><strong>What happened to the space because the player did it?</strong></p><p>That distinction is at the heart of PitchGrid.</p><p>A fullback overlap is not just a movement.</p><p>It is a spatial event.</p><p>And the space left behind is part of the tactical story.</p><p><strong>PitchGrid</strong> is my attempt to explore that story using:</p><p><strong>GIS + PostGIS + Spatial Analysis + Interactive Web Mapping</strong></p><p>And this is only the beginning.</p><h3>About the Author</h3><p><strong>Ahmed Bahaa</strong> is a GIS Analyst with over six years of experience in Geographic Information Systems (GIS), spatial databases, and geospatial analysis.</p><p>He is the creator of <strong>PitchGrid</strong>, an ongoing project exploring how <strong>PostGIS, spatial analysis, and interactive web mapping</strong> can be applied to football tactical analysis.</p><h3>Connect with me</h3><p><strong>LinkedIn:</strong><br><a href="https://www.linkedin.com/in/ahmed-bahaa-abd-el-latif-43676b226">https://www.linkedin.com/in/ahmed-bahaa-abd-el-latif-43676b226</a></p><p><strong>Facebook:</strong><br><a href="https://www.facebook.com/Ahmed.bahaa256">https://www.facebook.com/Ahmed.bahaa256</a></p><p><strong>Spatial Football</strong><br><strong>GIS</strong><br><strong>PostGIS</strong><br><strong>Football Analytics</strong><br><strong>Sports Analytics</strong><br><strong>Spatial Analytics</strong></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=ef73ccef58ef" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Solving Defensive Compactness with PostGIS]]></title>
            <link>https://medium.com/@aahmed.bahaa25/solving-defensive-compactness-with-postgis-8828996396bf?source=rss-dcdddba6d507------2</link>
            <guid isPermaLink="false">https://medium.com/p/8828996396bf</guid>
            <category><![CDATA[spatial-football]]></category>
            <category><![CDATA[football-analytics]]></category>
            <category><![CDATA[football-analysis]]></category>
            <category><![CDATA[gis]]></category>
            <category><![CDATA[postgis]]></category>
            <dc:creator><![CDATA[Aahmed Bahaa]]></dc:creator>
            <pubDate>Sat, 08 Aug 2026 13:33:06 GMT</pubDate>
            <atom:updated>2026-08-08T13:33:06.049Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/904/1*3Wy_NMbJYMn3S_meJFUg5g.png" /></figure><p><strong>Solving Defensive Compactness with PostGIS</strong></p><h3>PitchGrid: Solving Defensive Compactness with PostGIS</h3><h3>PitchGrid: Measuring Defensive Space, Not Just Player Positions</h3><h3>What if we could measure how compact a football team really is?</h3><p>Modern football analysis gives us an enormous amount of information about what happens on the pitch.</p><p>We can measure passes, shots, possession, distance covered, pressing actions, and many other performance metrics.</p><p>But one of the most important tactical questions remains fundamentally spatial:</p><p><strong>How compact is a team when it defends?</strong></p><p>A team may look compact on a traditional broadcast view.</p><p>But visual perception can be misleading.</p><p>The camera angle, player positions, and constantly changing shape can make it difficult to determine whether a defensive structure is actually compact or whether hidden gaps are developing between players.</p><p>As a GIS Analyst, I started asking a different question:</p><blockquote><strong>What if defensive compactness could be represented as a measurable spatial structure inside a database?</strong></blockquote><p>That question became the next stage of <strong>PitchGrid</strong>.</p><h3>From Player Positions to Team Geometry</h3><p>Instead of analysing each player independently, PitchGrid treats the defensive unit as a <strong>spatial system</strong>.</p><p>Player positions become spatial points.</p><p>The team’s overall structure can then be represented using geometric relationships.</p><p>This allows us to explore questions such as:</p><ul><li>Where is the team’s spatial centre?</li><li>How far are defenders from that centre?</li><li>Is the defensive structure compact or stretched?</li><li>Where do spatial gaps begin to appear?</li><li>Can defensive organisation be quantified rather than judged visually?</li></ul><p>This is where <strong>PostgreSQL/PostGIS</strong> becomes more than a database.</p><p>It becomes the spatial engine behind the tactical analysis.</p><h3>The PostGIS Approach</h3><p>The analysis uses spatial functions to transform player positions into measurable tactical information.</p><p>One of the key concepts is the <strong>team centroid</strong>.</p><p>Using spatial geometry, the positions of the defensive players can be transformed into a central reference point representing the team’s spatial balance.</p><p>From there, distances between players and the defensive centroid can be measured.</p><p>This creates a simple but powerful idea:</p><p><strong>The further the defensive unit spreads from its spatial centre, the greater the potential loss of compactness.</strong></p><p>The purpose is not to claim that one universal distance defines good or bad defending.</p><p>Instead, the framework provides a measurable spatial layer that can be combined with tactical context.</p><h3>Why Spatial Compactness Matters</h3><p>Defensive compactness is not simply about players standing close together.</p><p>It influences how a team protects:</p><ul><li>Central spaces</li><li>Passing lanes</li><li>Half-spaces</li><li>Defensive corridors</li><li>Space between defensive lines</li></ul><p>A small positional change can therefore create a much larger tactical consequence.</p><p>This is where spatial analysis can provide an additional perspective.</p><p>Instead of saying:</p><blockquote><em>“The team looks stretched.”</em></blockquote><p>We can begin asking:</p><blockquote><strong><em>“How stretched is the structure, where is the distortion occurring, and how does it change over time?”</em></strong></blockquote><p>That is the type of question PitchGrid is designed to explore.</p><h3>Explore the Interactive Experience</h3><p>The analysis is presented as an interactive football pitch rather than a traditional static chart.</p><p>You can explore the spatial structure directly on the pitch and see how the geometric model represents the defensive organisation.</p><p>👉 <strong>Explore the Interactive Analysis:</strong></p><p><a href="https://kunah25med.github.io/Spatial-_-Football-Analytics-Article-2/">https://kunah25med.github.io/Spatial-_-Football-Analytics-Article-2/</a></p><p>This is the second chapter of the <strong>PitchGrid</strong> series.</p><p>The first chapter established the spatial foundation by treating the football pitch as a GIS environment.</p><p>This chapter takes the next step:</p><p><strong>From mapping the pitch → to measuring the team’s spatial structure.</strong></p><h3>Building Toward a Larger Framework</h3><p>Defensive compactness is only one part of the problem.</p><p>The long-term objective of PitchGrid is to build a broader framework for understanding football through spatial analysis.</p><p>Each chapter will introduce another spatial concept and apply it to a football tactical problem.</p><p>The objective is not to replace traditional football analytics.</p><p>It is to add another dimension:</p><p><strong>The spatial dimension.</strong></p><h3>From Statistics to Spatial Intelligence</h3><p>Football is not played on a spreadsheet.</p><p>It is played in space.</p><p>Statistics can tell us <strong>what happened</strong>.</p><p>Spatial analysis can help us investigate <strong>where it happened, how the structure changed, and what spatial relationships existed when it happened</strong>.</p><p>PitchGrid is my attempt to explore that intersection between:</p><p><strong>GIS + Spatial Databases + Football Analytics.</strong></p><p>And this is only the beginning.</p><h3>About the Author</h3><p><strong>Ahmed Bahaa</strong> is a GIS Analyst with over six years of experience in Geographic Information Systems (GIS), spatial databases, and geospatial analysis.</p><p>He is the creator of <strong>PitchGrid</strong>, an ongoing project exploring how <strong>PostGIS</strong>, spatial analysis, and interactive web mapping can be applied to football tactical analysis.</p><p>Connect with me:</p><ul><li>LinkedIn: <a href="http://www.linkedin.com/in/ahmed-bahaa-abd-el-latif-43676b226">www.linkedin.com/in/ahmed-bahaa-abd-el-latif-43676b226</a></li><li>facebook:<a href="https://www.facebook.com/Ahmed.bahaa256">https://www.facebook.com/Ahmed.bahaa256</a></li></ul><p><strong>Spatial Football</strong></p><p><strong>GIS</strong></p><p><strong>PostGIS</strong></p><p><strong>Football Analytics</strong></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=8828996396bf" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Building a FIFA-Standard Spatial Engine for Football Analytics with PostGIS]]></title>
            <link>https://medium.com/@aahmed.bahaa25/building-a-fifa-standard-spatial-engine-for-football-analytics-with-postgis-de4a6f99f013?source=rss-dcdddba6d507------2</link>
            <guid isPermaLink="false">https://medium.com/p/de4a6f99f013</guid>
            <category><![CDATA[postgis]]></category>
            <category><![CDATA[spatial-football]]></category>
            <category><![CDATA[gis]]></category>
            <category><![CDATA[football-analytics]]></category>
            <dc:creator><![CDATA[Aahmed Bahaa]]></dc:creator>
            <pubDate>Fri, 07 Aug 2026 12:20:17 GMT</pubDate>
            <atom:updated>2026-08-07T12:20:17.857Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/843/1*QY4L0sQgw2OjNSL0rOxbBA.png" /></figure><p>Building a FIFA-Standard Spatial Engine for Football Analytics with PostGIS</p><h3>PitchGrid: Measuring Space, Not Just Statistics</h3><h3>What if a football pitch could be analyzed the same way GIS analyzes cities, roads, and geographic space?</h3><p>Modern football analytics has never been more advanced.</p><p>We can measure passes, shots, possession, expected goals (xG), and countless performance metrics. Yet one of the most important elements of football still remains surprisingly difficult to measure:</p><p><strong>Space.</strong></p><p>Every tactical decision — whether it’s pressing, defending, building attacks, or creating passing lanes — depends on how players occupy and manipulate space.</p><p>As a GIS Analyst, I kept asking myself one question:</p><blockquote><strong><em>What if we treated a football pitch as a spatial database instead of just a playing field?</em></strong></blockquote><p>That question became <strong>PitchGrid</strong>.</p><p>PitchGrid is an experimental project that combines <strong>Geographic Information Systems (GIS)</strong>, <strong>PostgreSQL/PostGIS</strong>, and <strong>Leaflet.js</strong> to explore football from a completely different perspective.</p><p>Instead of asking:</p><ul><li>Who completed the most passes?</li><li>Which player covered the greatest distance?</li><li>Where were the shots taken?</li></ul><p>PitchGrid explores questions like:</p><ul><li>How compact is a team’s defensive structure?</li><li>Where does exploitable space actually emerge?</li><li>Can geometry explain tactical behaviour?</li><li>How can spatial databases support football decision-making?</li></ul><p>This isn’t a traditional article.</p><p>It’s an <strong>interactive experience</strong> built on a FIFA-standard football pitch, designed as the foundation for a new approach to spatial football analysis.</p><h3>🌐 Explore the Interactive Experience</h3><p>👉 <a href="https://kunah25med.github.io/pitchgrid-spatial-engine/">https://kunah25med.github.io/pitchgrid-spatial-engine/</a></p><p>This is the first chapter of the <strong>PitchGrid</strong> series.</p><p>Future articles will build on this spatial engine to explore topics including:</p><ul><li>Defensive Compactness</li><li>Team Centroids</li><li>Cover Rotation</li><li>Spatial Relationships</li><li>Passing Corridors</li><li>Blind Spot Detection</li><li>Rest Defence</li><li>Spatial Intelligence for Football</li></ul><p>If you’re interested in <strong>GIS</strong>, <strong>PostGIS</strong>, <strong>Spatial Analytics</strong>, or <strong>Football Analytics</strong>, I’d love to hear your thoughts.</p><p>Every great project starts with a foundation.</p><p><strong>This is mine.</strong></p><h3>About the Author</h3><p><strong>Ahmed Bahaa</strong> is a GIS Analyst with over six years of experience in Geographic Information Systems (GIS), spatial databases, and geospatial analysis.</p><p>He is the creator of <strong>PitchGrid</strong>, an ongoing project exploring how <strong>PostGIS</strong>, spatial analysis, and interactive web mapping can be applied to football tactical analysis.</p><p>Connect with me:</p><ul><li>LinkedIn: <a href="http://www.linkedin.com/in/ahmed-bahaa-abd-el-latif-43676b226">www.linkedin.com/in/ahmed-bahaa-abd-el-latif-43676b226</a></li></ul><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=de4a6f99f013" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>