PostGIS Lesson 6 - Using PostgreSQL with Jupyter Notebook

[commonguy]

BRO, YOU AREA ALIFE SAVER.I CANT THANK YOU ENOUGH FOR THIS.GLAD I WATCHED THIS.Y\RN, IM SOOOO HAPPY.IVE TRIED A LOT OF VIDEOS, ALL FAILED.YOURS TRULY HELPED THANK YOU AGAIN.

[GIS_user]

@12:00 when I am trying to connect to the postGIS DB through Jupyter, using the correct local host credentials in [3], the connection string [5] throws the error "“MetaData.__init__() got an unexpected keyword argument 'bind' when using sqlite", I've had a google, and this might be due to be a conflict of versions. Are you able to provide any more support to overcome this error?

[NegarTavasoli-thxt]

Dear Prof. thanks for this tutorials, I have an error in this line : %sql $connection_string
the error: MetaData.__init__() got an unexpected keyword argument 'bind'
Connection info needed in SQLAlchemy format, example:
or an existing connection: dict_keys([])
how can I solve it?

[sohrabrustami]

@qiushengWu same problem 'ModuleNotFoundError' and line magic function '%%sql%% not found

[oladeleoluwaseun]

Thanks so much..your video helped me resolve issues with my docker postgres container and Jupyter notebook connection.

[baulenibvumbwe]

Hello. I am unable to follow through tutorial 6 "jupyter notebook" .
I get an error message when I try to run the %load_ext sql

Cause is that there is ModulelNotFoundError?

How can I go about it

[owamimasilela]

I get SSL Error( Can't connect to HTTPS URL because the SSL module is not available)

[narayanthapa]

SIr, I got the problem to execute %load_ext sql this shows the error no module found but When I use conda sql is found activated.

[adilmajeed]

get_table_names() seems to be deprecated, whats the other alternate to find it out?

[commonguy]

CAN I ACTUALLY MAKE CHANGES IN DATABASE AND UPDATE THE ACTUAL DATABASE USING THIS?

[shaileshshrestha]

error in step: %sql $connection_string


Connection info needed in SQLAlchemy format, example:
or an existing connection: dict_keys([])
DLL load failed while importing _psycopg: The specified module could not be found.
Connection info needed in SQLAlchemy format, example:
or an existing connection: dict_keys([])

[AlexandreNeto]

Nice video. Thanks! Any suggestion for using Jupyter to run queries on PostGIS data? That is, to visualize the outputs as geometries in a map and not only as a table.

[chaiti]

Excellent content, I have a question

%%sql

SELECT * FROM countries LIMIT 10 , This returns values in the 5 row and not the results you show . All other rows are blank

[virgilioespina]

1. open anaconda prompt
2. type "conda init powershell"
3. open powershell then activate

[bananaers]

Sigh. I still can't get this dang thing to work.
%load_ext sql
ModuleNotFoundError

GRRR