ERROR: Schema 'ST' does not exist
Closed this issue · 1 comments
ShruthiArvind commented
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!
ShruthiArvind commented
Okay I solved it! I used periods instead of underscores :)