Chapter 14: Analyzing Spatial Data no geom column about practical-sql HOT 12 CLOSED

@Pelil-tepes I had this issue come up once before with another reader. The cause was that they had moved only the file with the .shp extension into the folder they were importing from. Do you have all the associated files in the same folder?

from practical-sql.

They appear to be, I unzipped to the same location.

from practical-sql.

I did notice one possible issue. I am unable to import the data unless I select the "Load only attribute (dbf) data". Could this possibly strip the geom?

from practical-sql.

Yes, I believe that would indeed be the cause of no geom column because it's not reading the geometry from the file with the .shp extension. What kind of error do you get when you do not check that box? (edit)

I can fire up my Windows machine and try to replicate the issue.

from practical-sql.

from practical-sql.

@Pelil-tepes Please confirm you ran CREATE EXTENSION postgis; on your database. You can check if PostGIS is installed by running the query SELECT postgis_full_version();

from practical-sql.

from practical-sql.

If you added screengrabs, they're not displaying. Please upload them to this ticket so I can see the error.

from practical-sql.

from practical-sql.

OK, I'm going to assume this is an artifact of running in a Docker container. In the book, I specify install steps, and I am confident that if PostgreSQL and pgAdmin are installed according to the book that all will work. I unfortunately can't support alternate installations.

Is it possible for you to install PostgreSQL/PostGIS as instructed in the book?

from practical-sql.

from practical-sql.

I have made modifications to my docker file and confirmed it is working. I did install shp2sql to my windows PC and connect to the server using the IP and port for the SQL server. Hopefully, this information will be useful to others. I appreciate the assistance.

`version: '3.9'
services:
db:
container_name: PostgreSQL
image: postgis/postgis
mem_limit: 256m
cpu_shares: 768

healthcheck:
  test: ["CMD", "pg_isready", "-q", "-d", "bmmt_DB", "-U", "root"]
environment:
  POSTGRES_USER: root
  POSTGRES_PASSWORD: password
  POSTGRES_DB: my_DB
volumes:
  - /volume1/docker/postgresql:/var/lib/postgresql/data:rw
ports:
  - 2665:5432
restart: on-failure:5

`

from practical-sql.