a little of postgis

What I am going to show you is how from a geographical table (postgis) of segments of streets we are going to put together a table with the intersections of those streets. Surely they are already asking the same question that I asked Fernando, what for? That is, to insert redundancy in the system, and the answer is very simple, performance. While I do not think anyone has this problem on time is a good example of how to play with postgis. Continue reading