musa-620-spring-2017 / musa-620-week-6 Goto Github PK

Hi!
When I ran my code for the 3rd step, I got the error "syntax error at or near "FROM""!
See my code below.
Is anyone else having an issue?
Sincerely,
Laura

SELECT accidents_philadelphia_street_id.street_id, accidents_philadelphia_street_id.distance, SUM(accidents_philadelphia_street_id.* ) as num_accidents, ???
FROM accidents_philadelphia_street_id, streets
LEFT JOIN accidents_philadelphia_street_id ON streets.id = accidents_philadelphia_street_id.street_id
GROUP BY streets.id

I'm running the second query and it's up to 45 minutes. How long is it taking for everyone else?

When I try to run the second query with ST.Distance in my SELECT DISTINCT ON statement, I get an error saying schema ST does not exist. This is the code that I am trying to run -

SELECT DISTINCT ON (philly_accidents.id) philly_accidents.latitude, philly_accidents.longitud, streets.id, ST.Distance(philly_accidents.geom, streets.geom) as distance

FROM philly_accidents, streets

ORDER BY philly_accidents.id, ST.Distance (philly_accidents.geom, streets.geom)

Thanks for the help!

@MUSA-620-Fall-2017/musa-620 In preparation for next class, you should have two items installed.

1. Postgres / PostGIS. Most of you should already have this set up from last class.

2. Qgis (an open source alternative to ArcGIS). We will be using Qgis to import the data into our database. You can download it here: http://www.qgis.org/en/site/

The next required assignment is posted here: https://github.com/MUSA-620-Fall-2017/MUSA-620-Week-6

It is not due until the first class after break (March 15th), but it is a challenging one, so I recommend not waiting until the last minute to get started.

Max

@galkamax I recently reopened my qgis project and can no longer open the querying features in DB manager. PgAdmin is open and connected, and I wasn't having this issue before. Any idea as to why this is happening?

** RESOLVED**
Apparently I manually turned off the querying feature. If this happens to anyone else, in the database window, click "database", and then click "SQL window"