<div dir="ltr">Thanks Even for the quick response. Is it ok to escape : (with %3A) and the comma (with %2C) in the vrt?<br><br><div>even with the prefix , I received another error:</div><div>OGR error. Failed to open datasource `/vsicurl/http://<my server>:8080/solr-geo2/collection2/select?q=*%3A*&fl=PHOTO_LATITUDE%2CPHOTO_LONGITUDE%2CID&wt=csv'<br></div><div><br></div><div>cheers,</div><div><br></div><div>MartinO</div></div><br><div class="gmail_quote">On Tue, Mar 24, 2015 at 5:21 PM Even Rouault <<a href="mailto:even.rouault@spatialys.com">even.rouault@spatialys.com</a>> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Le mardi 24 mars 2015 22:16:30, Martin Ouellet a écrit :<br>
> Hi all,<br>
><br>
> I have a solr service which provide a valid csv response like this:<br>
><br>
> PHOTO_LATITUDE,PHOTO_<u></u>LONGITUDE,ID<br>
> 49.482333,-82.580556,A21524-<u></u>047-1970-0<br>
> 49.485278,-82.640444,A21524-<u></u>048-1970-0<br>
> 49.487583,-82.701194,A21524-<u></u>049-1970-0<br>
> 49.490444,-82.761111,A21524-<u></u>050-1970-0<br>
> 49.490333,-82.824333,A21524-<u></u>051-1970-0<br>
><br>
> my vrt is:<br>
><br>
> <OGRVRTDataSource><br>
> <OGRVRTLayer name="coord"><br>
> <SrcDataSource><a href="http://solr/select?q=*%3A*&fl=PHOTO_LATITUDE%2CPHOTO_LONGITU" target="_blank">http://solr/<u></u>select?q=*%3A*&fl=PHOTO_<u></u>LATITUDE%2CPHOTO_LONGITU</a><br>
> DE%2CID&wt=csv</SrcDataSource> <SrcLayer>coord</SrcLayer><br>
> <GeometryType>wkbPoint</<u></u>GeometryType><br>
> <LayerSRS>WGS84</LayerSRS><br>
> <GeometryField encoding="PointFromColumns" x="PHOTO_LONGITUDE"<br>
> y="PHOTO_LATITUDE"/><br>
> </OGRVRTLayer><br>
> </OGRVRTDataSource><br>
><br>
> I've try to escape the & with & in the url like the suggestions<br>
> here<br>
> <<a href="http://osgeo-org.1560.x6.nabble.com/Define-Virtual-Format-for-a-remote-Ge" target="_blank">http://osgeo-org.1560.x6.<u></u>nabble.com/Define-Virtual-<u></u>Format-for-a-remote-Ge</a><br>
> oJSON-file-td5173766.html>but in all cases, I still receive this error:<br>
><br>
> msOGRFileNextShape(): OGR error. Failed to read GeoJSON data<br>
<br>
You need to do XML escaping indeed (& --> &) and also prefix the URL by<br>
/vsicurl/ (the GeoJSON driver is the exception in that it tries to interpret<br>
any string by http:// as a potential source for it)<br>
<br>
><br>
> any ideas?<br>
><br>
> MartinO<br>
<br>
--<br>
Spatialys - Geospatial professional services<br>
<a href="http://www.spatialys.com" target="_blank">http://www.spatialys.com</a><br>
</blockquote></div>