<html><head></head><body><div style="font-family: Verdana;font-size: 12.0px;"><div>
<div>
<div>Hi, thx for answering.</div>
<div> </div>
<div>If I follow your suggestion, I get an error. see below.</div>
<div> </div>
<div>
<pre class="GNKRCKGCGSB" id="rstudio_console_output" style="font-family: 'Lucida Console'; font-size: 10pt !important; outline: none; border: none; word-break: break-all; margin: 0px; -webkit-user-select: text; white-space: pre-wrap !important; line-height: 15px; color: rgb(0, 0, 0); font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: -webkit-left; text-indent: 0px; text-transform: none; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255);" tabindex="0"><span><span class="GNKRCKGCMSB ace_keyword" style="color: blue; white-space: pre; -webkit-user-select: text;">> </span><span class="GNKRCKGCMRB ace_keyword" style="color: blue;">xx = st_read(connz, query = "SELECT * FROM vakantie LIMIT 3;")
</span><span class="GNKRCKGCASB ace_constant" style="color: rgb(197, 6, 11);">Error in CPL_hex_to_raw(vapply(x, skip0x, USE.NAMES = FALSE, "")) :
char2int: false character in hex string</span></span></pre>
</div>
<div> </div>
<div>Any other ideas?</div>
<div> </div>
<div>Thanks Jan Willem</div>
<div> </div>
<div> </div>
<div name="quote" style="margin:10px 5px 5px 10px; padding: 10px 0 10px 10px; border-left:2px solid #C3D9E5; word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;">
<div style="margin:0 0 10px 0;"><b>Sent:</b> Tuesday, June 12, 2018 at 2:29 PM<br/>
<b>From:</b> "Michael DELORME" <michael.delorme@agriculture.gouv.fr><br/>
<b>To:</b> r-sig-geo@r-project.org<br/>
<b>Subject:</b> Re: [R-sig-Geo] Sf st_read postgis</div>
<div name="quoted-content">Hi<br/>
<br/>
If you use a query you don't have to set a table name, so<br/>
<br/>
xx <- st_read(connz, query="SELECT * FROM vakantie LIMIT 3;")<br/>
<br/>
should work...<br/>
<br/>
<br/>
Le 12/06/2018 12:12, Jan Willem van der Lichte a �crit :<br/>
> Hi list,<br/>
><br/>
> Can someone help me with a basic sf question.<br/>
><br/>
> I try to use the sf::st_read function to get some data out of postgis.<br/>
><br/>
> I set up a connection (connz) to postgis.<br/>
> I checked if the connection was working with<br/>
><br/>
> dbListTables(connz)<br/>
><br/>
> The result was ok, I saw all the tables in the database.<br/>
><br/>
> Next I tried to get some data with the st_read() function, from the sf package.<br/>
><br/>
> I tried to follow the example in the help.<br/>
><br/>
> xx<- st_read(connz, "vakantie", query="SELECT * FROM vakantie LIMIT 3;")<br/>
><br/>
> So i replaced the table meuse with vakantie.<br/>
><br/>
> When I execute this statement, I get a warning<br/>
><br/>
> Warning message: In st_read.DBIObject(...) : Ignoring query argument, only using table.<br/>
><br/>
> So what's happening, am I doing something wrong? Which is possible, cause I'm new to R. :-)<br/>
><br/>
> Thanks<br/>
> Jan Willem<br/>
><br/>
><br/>
><br/>
><br/>
><br/>
><br/>
><br/>
><br/>
><br/>
><br/>
><br/>
><br/>
><br/>
><br/>
> Sent with my iPad<br/>
><br/>
> _______________________________________________<br/>
> R-sig-Geo mailing list<br/>
> R-sig-Geo@r-project.org<br/>
> <a href="https://stat.ethz.ch/mailman/listinfo/r-sig-geo" target="_blank">https://stat.ethz.ch/mailman/listinfo/r-sig-geo</a><br/>
><br/>
><br/>
<br/>
--<br/>
*Micha�l DELORME*<br/>
Administrateur de donn�es, charg� de projet en g�omatique<br/>
Service r�gional de l'information statistique, �conomique et territoriale<br/>
Direction r�gionale de l'alimentation, de l'agriculture et de la for�t<br/>
Auvergne-Rh�ne-Alpes<br/>
Site de Lyon<br/>
165 rue Garibaldi � BP 3202 � 69401 LYON cedex 03<br/>
04 78 63 34 21<br/>
<br/>
Pour �crire au service :<br/>
DRAAF Auvergne-Rh�ne-Alpes � SRISET<br/>
16B rue Aim� Rudel � BP 45 � 63370 LEMPDES<br/>
<br/>
<a href="http://www.draaf.auvergne-rhone-alpes.agriculture.gouv.fr/" target="_blank">http://www.draaf.auvergne-rhone-alpes.agriculture.gouv.fr/</a><br/>
<br/>
[[alternative HTML version deleted]]<br/>
<br/>
_______________________________________________<br/>
R-sig-Geo mailing list<br/>
R-sig-Geo@r-project.org<br/>
<a href="https://stat.ethz.ch/mailman/listinfo/r-sig-geo" target="_blank">https://stat.ethz.ch/mailman/listinfo/r-sig-geo</a></div>
</div>
</div>
</div></div></body></html>