Postgres/PostGIS is returning data from a table that doesn't exist (I'm a newbie -- show me why I am wrong)
FROM ...
     JOIN stations AS subways
    ... 


This is called an alias. You aliased stations as subways. So for the rest of the query (ON, SELECT part) the table is called subways and you can only reference it as subways.