postgis / postgis-workshops Goto Github PK

The recent update from the 2018 to the 2020 data bundle in the instructions points to a data bundle that doesn't have the data.

@pramsey might be interested in this.

I tried http://postgis.net and https://postgis.net but the only response I get is connect reset by peer. What is happening and is there any mirror of the site ?

The KNN section still thinks we're limited to bounding boxes. It also doesn't mention geography. Time for an update. http://postgis.net/workshops/postgis-intro/knn.html

22.1.3 has some discussion of the equality operator that is no longer correct for newer versions of PostGIS:

To allow for speedier comparison, the equal bounds operator, =, is provided. This operates only on the bounding box (rectangle), ensuring that the geometries occupy the same two dimensional extent, but not necessarily the same space.

The docs refer to screenshots/clustering5.jpg, but I only see a screenshots/clustering5.png

Not sure which should be updated.

Hello,

I am new to postgres and am trying to walk through your postGIS tutorial. On the 5. Loading Spatial Data page I got lost on 5.2 with the instruction to be in the 2000 sub-directory within the shell. I am familiar with the concept here, but not where to actually find the shell within PGAdmin4. This could just be an issue for me because I am not familiar enough with postgres or PGAdmin to complete this tutorial, but I can't confirm that because I don't see a statement of necessary background information at the beginning of the tutorial.

Best,

Matt

We had done this for postgis manual, but haven't checked how to do this with sphinx. My efforts at generating PDFs currently fail with these languages, so I think I'm missing install of some package.

Botht he postgis pdf and sphinx pdfs are generated by debbie, so it must be some additional package specific to sphinx needed.

I've connected QGIS to Postgis, but the layers are not recognised.

Is there a step missing?

https://postgis.net/workshops/postgis-intro/loading_data.html

5. Loading spatial data

This section is outdated?
Running postgresql 10 and pgadmin4 I dont have an Import shapefiles link nor a PostGIS section

It seems opengeo suite was bought by someone else so I was unable to use it and the packages that it installed werent available.

make html is failing to run

The installation part of the workshop (postgis-intro/sources/en/installation.rst (https://postgis.net/workshops/postgis-intro/installation.html)) is a guide on how to install the OpenGeo Suite which contain PostGIS. However OpenGeo doesn't exist anymore.

I don't know if there is any other software suite which could be used as a drop in replacement for this workshop (I haven't finished it yet :)). Do you have any suggestion on approach?

I thought postgis-workshops being a user facing piece should really have translations.
I'm working thru this https://www.sphinx-doc.org/en/master/usage/advanced/intl.html to see if I can fit it in.

The plan is to allow users who prefer git to make changes directly in git and other users to use weblate which I have installed here https://weblate.osgeo.org

For authentication with weblate, I will start with osgeo LDAP first, but then plan to open it up to github/gitlab users once I've done some more testing to make sure I can support multiple auth channels.

Eventually I'd like to switch postgis translations from transifex to weblate, but don't want to mess with that until I've thoroughly tested it out with a virgin project like postgis-workshops.

https://postgis.net/workshops/postgis-intro/geometries_exercises.html****
To properly solve the third exercise, the student needs to use the ST_NumInteriorRings function; which has not yet been presented to them.
I presume that the intended course of action is that the student fails that particular question, so they later understand the importance of ST_NumInteriorRings. But proposing an exercise that the student cannot yet solve, is kind-of dishonest from the instructor. More so if the exercise is proposed with no warning about that circumstance.

Hello,

In section 5.1, Loading the Backup file: https://postgis.net/workshops/postgis-intro/loading_data.html#loading-the-backup-file

The tutorial says to restore from nyc_data.backup. This file does not seem to be in the data bundle link https://postgis.net/workshops/postgis-intro/index.html on the front page, nor does it seem like this file was generated in previous tutorials.