https://dges.carleton.ca/CUOSGwiki/index.php?action=history&feed=atom&title=Talk%3ASpatial_data_management_using_PostGIS 2026-06-04T01:20:42Z Revision history for this page on the wiki MediaWiki 1.34.2 https://dges.carleton.ca/CUOSGwiki/index.php?title=Talk:Spatial_data_management_using_PostGIS&diff=21077&oldid=prev 2024-11-21T13:42:58Z

<p><span dir="auto"><span class="autocomment">2024 additions</span></span></p> <table class="diff diff-contentalign-left" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="en-CA"> <td colspan="2" style="background-color: #fff; color: #222; text-align: center;">← Older revision</td> <td colspan="2" style="background-color: #fff; color: #222; text-align: center;">Revision as of 13:42, 21 November 2024</td> </tr><tr> <td colspan="2" class="diff-lineno">Line 20:</td> <td colspan="2" class="diff-lineno">Line 20:</td> </tr> <tr> <td class="diff-marker"></td> <td class="diff-context diff-side-deleted"><br /></td> <td class="diff-marker"></td> <td class="diff-context diff-side-added"><br /></td> </tr> <tr> <td class="diff-marker"></td> <td class="diff-context diff-side-deleted"><div>Very nice to have an update to this tutorial, and using Windows diversifies it. Would be nice for a further revision to bring the Linux portion up to date, since it is now quite old and those software versions aren't likely in wide use or easy to get working. A macOS version might also be nice, as we have discussed. If anyone takes that on, please try to have comparable examples across platforms, and ideally the same data, and make sure it's done with open data.</div></td> <td class="diff-marker"></td> <td class="diff-context diff-side-added"><div>Very nice to have an update to this tutorial, and using Windows diversifies it. Would be nice for a further revision to bring the Linux portion up to date, since it is now quite old and those software versions aren't likely in wide use or easy to get working. A macOS version might also be nice, as we have discussed. If anyone takes that on, please try to have comparable examples across platforms, and ideally the same data, and make sure it's done with open data.</div></td> </tr> <tr> <td colspan="2" class="diff-empty diff-side-deleted"></td> <td class="diff-marker" data-marker="+"></td> <td class="diff-addedline diff-side-added"><br /></td> </tr> <tr> <td colspan="2" class="diff-empty diff-side-deleted"></td> <td class="diff-marker" data-marker="+"></td> <td class="diff-addedline diff-side-added"><div>I see that the network port being used switches from the default 5432 to 5433 at one point, with no explanation. That should be fixed, it will cause confusion.</div></td> </tr> <!-- diff cache key foss4gwiki2-osg_:diff:wikidiff2:1.12:old-21074:rev-21077:1.14.1 --> </table>

Smitch https://dges.carleton.ca/CUOSGwiki/index.php?title=Talk:Spatial_data_management_using_PostGIS&diff=21074&oldid=prev 2024-11-21T13:33:07Z

<p></p> <table class="diff diff-contentalign-left" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="en-CA"> <td colspan="2" style="background-color: #fff; color: #222; text-align: center;">← Older revision</td> <td colspan="2" style="background-color: #fff; color: #222; text-align: center;">Revision as of 13:33, 21 November 2024</td> </tr><tr> <td colspan="2" class="diff-lineno">Line 16:</td> <td colspan="2" class="diff-lineno">Line 16:</td> </tr> <tr> <td class="diff-marker"></td> <td class="diff-context diff-side-deleted"><div>* I have tried updating the system, but it seems that 1.4 is the current default postgis version for this version of ubuntu... ? Ah-ha, I see later on you say that you installed the unstable-2.0 version... that must be the difference. So the tutorial has a glitch as a result, as currently written.</div></td> <td class="diff-marker"></td> <td class="diff-context diff-side-added"><div>* I have tried updating the system, but it seems that 1.4 is the current default postgis version for this version of ubuntu... ? Ah-ha, I see later on you say that you installed the unstable-2.0 version... that must be the difference. So the tutorial has a glitch as a result, as currently written.</div></td> </tr> <tr> <td class="diff-marker"></td> <td class="diff-context diff-side-deleted"><div>* as a result, the geography_columns relation does not exist, so I gave up following along at that step.</div></td> <td class="diff-marker"></td> <td class="diff-context diff-side-added"><div>* as a result, the geography_columns relation does not exist, so I gave up following along at that step.</div></td> </tr> <tr> <td colspan="2" class="diff-empty diff-side-deleted"></td> <td class="diff-marker" data-marker="+"></td> <td class="diff-addedline diff-side-added"><br /></td> </tr> <tr> <td colspan="2" class="diff-empty diff-side-deleted"></td> <td class="diff-marker" data-marker="+"></td> <td class="diff-addedline diff-side-added"><div>== 2024 additions == </div></td> </tr> <tr> <td colspan="2" class="diff-empty diff-side-deleted"></td> <td class="diff-marker" data-marker="+"></td> <td class="diff-addedline diff-side-added"><br /></td> </tr> <tr> <td colspan="2" class="diff-empty diff-side-deleted"></td> <td class="diff-marker" data-marker="+"></td> <td class="diff-addedline diff-side-added"><div>Very nice to have an update to this tutorial, and using Windows diversifies it. Would be nice for a further revision to bring the Linux portion up to date, since it is now quite old and those software versions aren't likely in wide use or easy to get working. A macOS version might also be nice, as we have discussed. If anyone takes that on, please try to have comparable examples across platforms, and ideally the same data, and make sure it's done with open data.</div></td> </tr> <!-- diff cache key foss4gwiki2-osg_:diff:wikidiff2:1.12:old-920:rev-21074:1.14.1 --> </table>

Smitch https://dges.carleton.ca/CUOSGwiki/index.php?title=Talk:Spatial_data_management_using_PostGIS&diff=920&oldid=prev 2010-12-15T19:35:43Z

<p><span dir="auto"><span class="autocomment">PostGIS version problem</span></span></p> <table class="diff diff-contentalign-left" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="en-CA"> <td colspan="2" style="background-color: #fff; color: #222; text-align: center;">← Older revision</td> <td colspan="2" style="background-color: #fff; color: #222; text-align: center;">Revision as of 19:35, 15 December 2010</td> </tr><tr> <td colspan="2" class="diff-lineno">Line 14:</td> <td colspan="2" class="diff-lineno">Line 14:</td> </tr> <tr> <td class="diff-marker"></td> <td class="diff-context diff-side-deleted"><div>* I do have the contrib directory</div></td> <td class="diff-marker"></td> <td class="diff-context diff-side-added"><div>* I do have the contrib directory</div></td> </tr> <tr> <td class="diff-marker"></td> <td class="diff-context diff-side-deleted"><div>* the SQL file names you refer to are in the contrib directory, but it appears they belong to postgis-1.4</div></td> <td class="diff-marker"></td> <td class="diff-context diff-side-added"><div>* the SQL file names you refer to are in the contrib directory, but it appears they belong to postgis-1.4</div></td> </tr> <tr> <td class="diff-marker" data-marker="−"></td> <td class="diff-deletedline diff-side-deleted"><div>* I have tried updating the system, but it seems that 1.4 is the current default postgis version for this version of ubuntu... ?</div></td> <td class="diff-marker" data-marker="+"></td> <td class="diff-addedline diff-side-added"><div>* I have tried updating the system, but it seems that 1.4 is the current default postgis version for this version of ubuntu... ?<ins class="diffchange diffchange-inline"> Ah-ha, I see later on you say that you installed the unstable-2.0 version... that must be the difference. So the tutorial has a glitch as a result, as currently written.</ins></div></td> </tr> <tr> <td class="diff-marker"></td> <td class="diff-context diff-side-deleted"><div>* as a result, the geography_columns relation does not exist, so I gave up following along at that step.</div></td> <td class="diff-marker"></td> <td class="diff-context diff-side-added"><div>* as a result, the geography_columns relation does not exist, so I gave up following along at that step.</div></td> </tr> <!-- diff cache key foss4gwiki2-osg_:diff:wikidiff2:1.12:old-919:rev-920:1.14.1 --> </table>

Smitch https://dges.carleton.ca/CUOSGwiki/index.php?title=Talk:Spatial_data_management_using_PostGIS&diff=919&oldid=prev 2010-12-15T19:33:55Z

<p><span dir="auto"><span class="autocomment">PostGIS version problem</span></span></p> <table class="diff diff-contentalign-left" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="en-CA"> <td colspan="2" style="background-color: #fff; color: #222; text-align: center;">← Older revision</td> <td colspan="2" style="background-color: #fff; color: #222; text-align: center;">Revision as of 19:33, 15 December 2010</td> </tr><tr> <td colspan="2" class="diff-lineno">Line 11:</td> <td colspan="2" class="diff-lineno">Line 11:</td> </tr> <tr> <td class="diff-marker"></td> <td class="diff-context diff-side-deleted"><div>== PostGIS version problem ==</div></td> <td class="diff-marker"></td> <td class="diff-context diff-side-added"><div>== PostGIS version problem ==</div></td> </tr> <tr> <td class="diff-marker"></td> <td class="diff-context diff-side-deleted"><br /></td> <td class="diff-marker"></td> <td class="diff-context diff-side-added"><br /></td> </tr> <tr> <td class="diff-marker" data-marker="−"></td> <td class="diff-deletedline diff-side-deleted"><div>I tried to follow along your tutorial on an Ubunto 10.0.04 system that has been just minimally configured. I ran into troubles trying to execute the SQL <del class="diffchange diffchange-inline">files</del> you reference</div></td> <td class="diff-marker" data-marker="+"></td> <td class="diff-addedline diff-side-added"><div>I tried to follow along your tutorial on an Ubunto 10.0.04 system that has been just minimally configured. I ran into troubles trying to execute the SQL <ins class="diffchange diffchange-inline">GRANT steps</ins> you reference<ins class="diffchange diffchange-inline"> in section 4.2. I found that I do not have a directory .../contrib/postgis-1.5 </ins></div></td> </tr> <tr> <td colspan="2" class="diff-empty diff-side-deleted"></td> <td class="diff-marker" data-marker="+"></td> <td class="diff-addedline diff-side-added"><div>* I do have the contrib directory</div></td> </tr> <tr> <td colspan="2" class="diff-empty diff-side-deleted"></td> <td class="diff-marker" data-marker="+"></td> <td class="diff-addedline diff-side-added"><div>* the SQL file names you refer to are in the contrib directory, but it appears they belong to postgis-1.4</div></td> </tr> <tr> <td colspan="2" class="diff-empty diff-side-deleted"></td> <td class="diff-marker" data-marker="+"></td> <td class="diff-addedline diff-side-added"><div>* I have tried updating the system, but it seems that 1.4 is the current default postgis version for this version of ubuntu... ?</div></td> </tr> <tr> <td colspan="2" class="diff-empty diff-side-deleted"></td> <td class="diff-marker" data-marker="+"></td> <td class="diff-addedline diff-side-added"><div>* as a result, the geography_columns relation does not exist, so I gave up following along at that step.</div></td> </tr> <!-- diff cache key foss4gwiki2-osg_:diff:wikidiff2:1.12:old-918:rev-919:1.14.1 --> </table>

Smitch https://dges.carleton.ca/CUOSGwiki/index.php?title=Talk:Spatial_data_management_using_PostGIS&diff=918&oldid=prev 2010-12-15T19:30:53Z

<p><span dir="auto"><span class="autocomment">PostGIS version problem: </span> new section</span></p> <table class="diff diff-contentalign-left" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="en-CA"> <td colspan="2" style="background-color: #fff; color: #222; text-align: center;">← Older revision</td> <td colspan="2" style="background-color: #fff; color: #222; text-align: center;">Revision as of 19:30, 15 December 2010</td> </tr><tr> <td colspan="2" class="diff-lineno">Line 8:</td> <td colspan="2" class="diff-lineno">Line 8:</td> </tr> <tr> <td class="diff-marker"></td> <td class="diff-context diff-side-deleted"><br /></td> <td class="diff-marker"></td> <td class="diff-context diff-side-added"><br /></td> </tr> <tr> <td class="diff-marker"></td> <td class="diff-context diff-side-deleted"><div>I edited the wording (see history) to more accurately describe what's happening with these commands.</div></td> <td class="diff-marker"></td> <td class="diff-context diff-side-added"><div>I edited the wording (see history) to more accurately describe what's happening with these commands.</div></td> </tr> <tr> <td colspan="2" class="diff-empty diff-side-deleted"></td> <td class="diff-marker" data-marker="+"></td> <td class="diff-addedline diff-side-added"><br /></td> </tr> <tr> <td colspan="2" class="diff-empty diff-side-deleted"></td> <td class="diff-marker" data-marker="+"></td> <td class="diff-addedline diff-side-added"><div>== PostGIS version problem ==</div></td> </tr> <tr> <td colspan="2" class="diff-empty diff-side-deleted"></td> <td class="diff-marker" data-marker="+"></td> <td class="diff-addedline diff-side-added"><br /></td> </tr> <tr> <td colspan="2" class="diff-empty diff-side-deleted"></td> <td class="diff-marker" data-marker="+"></td> <td class="diff-addedline diff-side-added"><div>I tried to follow along your tutorial on an Ubunto 10.0.04 system that has been just minimally configured. I ran into troubles trying to execute the SQL files you reference</div></td> </tr> <!-- diff cache key foss4gwiki2-osg_:diff:wikidiff2:1.12:old-916:rev-918:1.14.1 --> </table>

Smitch https://dges.carleton.ca/CUOSGwiki/index.php?title=Talk:Spatial_data_management_using_PostGIS&diff=916&oldid=prev 2010-12-15T19:22:12Z

<p><span dir="auto"><span class="autocomment">Postgresql installation and initialization of superuser in the database: </span> new section</span></p> <table class="diff diff-contentalign-left" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="en-CA"> <td colspan="2" style="background-color: #fff; color: #222; text-align: center;">← Older revision</td> <td colspan="2" style="background-color: #fff; color: #222; text-align: center;">Revision as of 19:22, 15 December 2010</td> </tr><tr> <td colspan="2" class="diff-lineno">Line 4:</td> <td colspan="2" class="diff-lineno">Line 4:</td> </tr> <tr> <td class="diff-marker"></td> <td class="diff-context diff-side-deleted"><br /></td> <td class="diff-marker"></td> <td class="diff-context diff-side-added"><br /></td> </tr> <tr> <td class="diff-marker"></td> <td class="diff-context diff-side-deleted"><div>In other words, when the tutorial says that it is using the "command line version" of synaptic, that isn't quite true. But close enough that I'm leaving it alone for now.</div></td> <td class="diff-marker"></td> <td class="diff-context diff-side-added"><div>In other words, when the tutorial says that it is using the "command line version" of synaptic, that isn't quite true. But close enough that I'm leaving it alone for now.</div></td> </tr> <tr> <td colspan="2" class="diff-empty diff-side-deleted"></td> <td class="diff-marker" data-marker="+"></td> <td class="diff-addedline diff-side-added"><br /></td> </tr> <tr> <td colspan="2" class="diff-empty diff-side-deleted"></td> <td class="diff-marker" data-marker="+"></td> <td class="diff-addedline diff-side-added"><div>== Postgresql installation and initialization of superuser in the database ==</div></td> </tr> <tr> <td colspan="2" class="diff-empty diff-side-deleted"></td> <td class="diff-marker" data-marker="+"></td> <td class="diff-addedline diff-side-added"><br /></td> </tr> <tr> <td colspan="2" class="diff-empty diff-side-deleted"></td> <td class="diff-marker" data-marker="+"></td> <td class="diff-addedline diff-side-added"><div>I edited the wording (see history) to more accurately describe what's happening with these commands.</div></td> </tr> <!-- diff cache key foss4gwiki2-osg_:diff:wikidiff2:1.12:old-913:rev-916:1.14.1 --> </table>

Smitch https://dges.carleton.ca/CUOSGwiki/index.php?title=Talk:Spatial_data_management_using_PostGIS&diff=913&oldid=prev 2010-12-15T19:14:18Z

<p><span dir="auto"><span class="autocomment">Re: the &quot;synaptic package manager&quot;</span></span></p> <table class="diff diff-contentalign-left" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="en-CA"> <td colspan="2" style="background-color: #fff; color: #222; text-align: center;">← Older revision</td> <td colspan="2" style="background-color: #fff; color: #222; text-align: center;">Revision as of 19:14, 15 December 2010</td> </tr><tr> <td colspan="2" class="diff-lineno">Line 2:</td> <td colspan="2" class="diff-lineno">Line 2:</td> </tr> <tr> <td class="diff-marker"></td> <td class="diff-context diff-side-deleted"><br /></td> <td class="diff-marker"></td> <td class="diff-context diff-side-added"><br /></td> </tr> <tr> <td class="diff-marker"></td> <td class="diff-context diff-side-deleted"><div>Actually, when you use the apt-get program on the command line, technically I believe you are using the "Debian packaging system", which created the apt-__ commands. This predates the synaptic software, which I'm pretty sure is the GUI that went on top of the pre-existing packaging system.</div></td> <td class="diff-marker"></td> <td class="diff-context diff-side-added"><div>Actually, when you use the apt-get program on the command line, technically I believe you are using the "Debian packaging system", which created the apt-__ commands. This predates the synaptic software, which I'm pretty sure is the GUI that went on top of the pre-existing packaging system.</div></td> </tr> <tr> <td colspan="2" class="diff-empty diff-side-deleted"></td> <td class="diff-marker" data-marker="+"></td> <td class="diff-addedline diff-side-added"><br /></td> </tr> <tr> <td colspan="2" class="diff-empty diff-side-deleted"></td> <td class="diff-marker" data-marker="+"></td> <td class="diff-addedline diff-side-added"><div>In other words, when the tutorial says that it is using the "command line version" of synaptic, that isn't quite true. But close enough that I'm leaving it alone for now.</div></td> </tr> <!-- diff cache key foss4gwiki2-osg_:diff:wikidiff2:1.12:old-912:rev-913:1.14.1 --> </table>

Smitch https://dges.carleton.ca/CUOSGwiki/index.php?title=Talk:Spatial_data_management_using_PostGIS&diff=912&oldid=prev 2010-12-15T19:13:32Z

<p>Re: the &quot;synaptic package manager&quot;</p> <p><b>New page</b></p><div>== Re: the &quot;synaptic package manager&quot; ==<br /> <br /> Actually, when you use the apt-get program on the command line, technically I believe you are using the &quot;Debian packaging system&quot;, which created the apt-__ commands. This predates the synaptic software, which I&#039;m pretty sure is the GUI that went on top of the pre-existing packaging system.</div>

Smitch