[R-sig-Geo] Sf st_read postgis

[Michael DELORME]

Hi

If you use a query you don't have to set a table name, so

xx <- st_read(connz, query="SELECT * FROM vakantie LIMIT 3;")

should work...


Le 12/06/2018 12:12, Jan Willem van der Lichte a �crit :
> Hi list,
>
> Can someone help me with a basic sf question.
>
> I try to use the sf::st_read function to get some data out of postgis.
>
> I set up a connection (connz) to postgis. 
> I checked if the connection was working with
>
> dbListTables(connz)
>
> The result was ok, I saw all the tables in the database.
>
> Next I tried to get some data with the st_read() function, from the sf package.
>
> I tried to follow the example in the help.
>
> xx<- st_read(connz, "vakantie", query="SELECT * FROM vakantie LIMIT 3;")
>
> So i replaced the table meuse with vakantie.
>
> When I execute this statement, I get a warning
>
> Warning message: In st_read.DBIObject(...) : Ignoring query argument, only using table.
>
> So what's happening, am I doing something wrong? Which is possible, cause I'm new to R. :-)
>
> Thanks
> Jan Willem
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> Sent with my iPad
>
> _______________________________________________
> R-sig-Geo mailing list
> R-sig-Geo using r-project.org
> https://stat.ethz.ch/mailman/listinfo/r-sig-geo
>
>

-- 
*Micha�l DELORME*
Administrateur de donn�es, charg� de projet en g�omatique
Service r�gional de l'information statistique, �conomique et territoriale
Direction r�gionale de l'alimentation, de l'agriculture et de la for�t
Auvergne-Rh�ne-Alpes
Site de Lyon
165 rue Garibaldi � BP 3202 � 69401 LYON cedex 03
04 78 63 34 21

Pour �crire au service :
DRAAF Auvergne-Rh�ne-Alpes � SRISET
16B rue Aim� Rudel � BP 45 � 63370 LEMPDES

http://www.draaf.auvergne-rhone-alpes.agriculture.gouv.fr/

	[[alternative HTML version deleted]]