,
-Tsering
From: postgis-users on behalf of Regina
Obe
Sent: Tuesday, April 28, 2020 1:03 PM
To: 'PostGIS Users Discussion'
Subject: Re: [postgis-users] Postgis spatial join display error
Oh one more thing – don’t put a ; after your query.
Sorry
-users [mailto:postgis-users-boun...@lists.osgeo.org] On Behalf Of
Alexandre Neto
Sent: Tuesday, April 28, 2020 12:59 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] Postgis spatial join display error
Hi,
Yes, QGIS dislike columns with the same name, so you need to use alias to
s and I don’t think
> QGIS likes duplicated columns
>
>
> *From:* postgis-users [mailto:postgis-users-boun...@lists.osgeo.org
> ] *On Behalf Of *Tsering W. Shawa
> *Sent:* Tuesday, April 28, 2020 12:32 PM
> *To:* postgis-users@lists.osgeo.org
> *Subject:* [postgis-users] Postg
gis-users@lists.osgeo.org
> Subject: [postgis-users] Postgis spatial join display error
>
> I am new to PostGIS and trying to learn how everything works. I am using
> Introduction to PostGIS site data to test different GIS function including
> spatial join. The spatial join SQL st
users-boun...@lists.osgeo.org] On Behalf
Of Tsering W. Shawa
Sent: Tuesday, April 28, 2020 12:32 PM
To: postgis-users@lists.osgeo.org
Subject: [postgis-users] Postgis spatial join display error
I am new to PostGIS and trying to learn how everything works. I am using
Introduction to PostGIS site da
I am new to PostGIS and trying to learn how everything works. I am using
Introduction to PostGIS site data to test different GIS function including
spatial join. The spatial join SQL statement seems to work [SELECT * FROM
nyc_neighborhoods AS n JOIN nyc_subway_stations AS s ON ST_Contains(n.geom
