Re: [Qgis-user] How do I georeference an xls file opened in QGIS 2.0
Starting from MS Office 2003 Exel You can not use Exel to save DBF files. Best regards, Karlis Basques, Bob (CI-StPaul) wrote: Well, you can do this with DBF files, which Excel can open and save (part of a SHP).. ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] How do I georeference an xls file opened in QGIS 2.0
If source file is not in current working directory or the path is not absolute path, "relativeToVRT" is necessary. points.xls Cheers, Minoru 2013/11/6 Minoru Akagi : > Hi Brent, Giovanni and Richard, > > I can open an excel sheet as a point layer with a VRT file. > An example of vrt file: > --- > > > points.xls > Sheet1 > wkbPoint > WGS84 > > > > --- > > XLS driver is read-only, but newly supported ODS [1] and XLSX [2] > drivers can also write. So we can edit spreadsheet directly in QGIS. > An tip to correctly add points into spreadsheet layer is including at > least one decimal in each x and y column in advance. Making x field > and y field uneditable in the properties dialog may lead to > comfortable editing. > > [1] http://www.gdal.org/ogr/drv_ods.html > [2] http://www.gdal.org/ogr/drv_xlsx.html > > Minoru ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] How do I georeference an xls file opened in QGIS 2.0
Hi Brent, Giovanni and Richard, I can open an excel sheet as a point layer with a VRT file. An example of vrt file: --- points.xls Sheet1 wkbPoint WGS84 --- XLS driver is read-only, but newly supported ODS [1] and XLSX [2] drivers can also write. So we can edit spreadsheet directly in QGIS. An tip to correctly add points into spreadsheet layer is including at least one decimal in each x and y column in advance. Making x field and y field uneditable in the properties dialog may lead to comfortable editing. [1] http://www.gdal.org/ogr/drv_ods.html [2] http://www.gdal.org/ogr/drv_xlsx.html Minoru ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] How do I georeference an xls file opened in QGIS 2.0
David, Is there any chance your GDAL/OGR lacks Excel support? According to OGR Formats page [1], it isn't compiled by default. Try `ogrinfo file>` from the command line. I can confirm that it is working for me (QGIS 2.0.1, GDAL 1.10.0, Linux Mint 13) via the Add Vector Layer dialog (as described by Brent) and via drag and drop from the file system, as you describe in your original post. (Even without Richard's excellent XYTools plugin.) Best, --Lee [1] http://www.gdal.org/ogr/ogr_formats.html On 11/05/2013 03:38 PM, Richard Duivenvoorde wrote: On 05-11-13 20:41, Brent Wood wrote: Cheers... I don't want to create shapefiles or csv's, etc, from spreadsheets, I just want to plot *.xls files which contain x/y columns on the map. I sort of figured that if a GIS tool can open an xls file this would be pretty basic functionality... perhaps optimistically :-) The use case I'm envisaging is a live Excel spreadsheet used to store data. New rows (records) are added as appropriate. A QGIS project includes the spreadsheet as a current layer - so a QGIS user can open the spreadsheet, as well as other map layers, & save the project. Reopening the project would automatically plot all the rows in the spreadsheet on the map. The only ways I can see to achieve this functionality involve recreating another copy of the spreadsheet in another format before I can view the points on the map. Which is an annoying extra few steps every time I want to view the spreadsheet. Is this worth filing a ticket for? Perhaps add some extra functionality in the vector layer dialogue: if the file type opened is an xls, allow the user to (optionally) specify the column identifiers for the X & Y coords & the SRID to apply? Hi, my xytools plugin does parts of your question: - it can load an xls file (xlr module needed), will ask you for a crs and the x and y column, and then will create features and place those in a memory layer (!). Which you could save to ... whatever But as this is a memorylayer the link to your excelfile is not memorized, so loading excel file in a project file is not working. Second option: as OGR can load excel files, QGIS can load them as tables (just via 'add vector layer'). Maybe (!, haven't tried this) you can use the vrt-magic from ogr for this. See http://www.gdal.org/ogr/drv_vrt.html This would mean that your excel file would be accompanied by this xml file which defines the columns and geometrytype. And OGR (and by this hopefully QGIS) will then see it as a 'virtual' geometry containing file. Please try (and report back ;-) ) Third option: instead of real excell files, use csv files (combined with vrt?) See http://www.gdal.org/ogr/drv_csv.html The Delimited Text File layer is also pretty sophisticated nowadays! Hope this helps. Regards, Richard Duivenvoorde ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user -- Lee Hachadoorian Assistant Professor in Geography, Dartmouth College http://freecity.commons.gc.cuny.edu ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] How do I georeference an xls file opened in QGIS 2.0
On 05-11-13 20:41, Brent Wood wrote: > Cheers... > > I don't want to create shapefiles or csv's, etc, from spreadsheets, I > just want to plot *.xls files which contain x/y columns on the map. > > I sort of figured that if a GIS tool can open an xls file this would be > pretty basic functionality... perhaps optimistically :-) > > The use case I'm envisaging is a live Excel spreadsheet used to store > data. New rows (records) are added as appropriate. A QGIS project > includes the spreadsheet as a current layer - so a QGIS user can open > the spreadsheet, as well as other map layers, & save the project. > Reopening the project would automatically plot all the rows in the > spreadsheet on the map. > > The only ways I can see to achieve this functionality involve recreating > another copy of the spreadsheet in another format before I can view the > points on the map. Which is an annoying extra few steps every time I > want to view the spreadsheet. > > Is this worth filing a ticket for? Perhaps add some extra functionality > in the vector layer dialogue: if the file type opened is an xls, allow > the user to (optionally) specify the column identifiers for the X & Y > coords & the SRID to apply? Hi, my xytools plugin does parts of your question: - it can load an xls file (xlr module needed), will ask you for a crs and the x and y column, and then will create features and place those in a memory layer (!). Which you could save to ... whatever But as this is a memorylayer the link to your excelfile is not memorized, so loading excel file in a project file is not working. Second option: as OGR can load excel files, QGIS can load them as tables (just via 'add vector layer'). Maybe (!, haven't tried this) you can use the vrt-magic from ogr for this. See http://www.gdal.org/ogr/drv_vrt.html This would mean that your excel file would be accompanied by this xml file which defines the columns and geometrytype. And OGR (and by this hopefully QGIS) will then see it as a 'virtual' geometry containing file. Please try (and report back ;-) ) Third option: instead of real excell files, use csv files (combined with vrt?) See http://www.gdal.org/ogr/drv_csv.html The Delimited Text File layer is also pretty sophisticated nowadays! Hope this helps. Regards, Richard Duivenvoorde ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] How do I georeference an xls file opened in QGIS 2.0
Sorry, the right link: http://www.gdal.org/ogr/drv_vrt.html Il 05/nov/2013 21:34 "G. Allegri" ha scritto: > I understand your need and maybe it is worth a ticket, and maybe a > sponsorship :) > > To keep a "live connection" with your spreadsheet you could create an OGR > virtual layer, using the OGR Virtual Format [1]. Yet an extra step but this > way your updates to the spreadsheet are automatically seen in your QGIS > project. > > Giovanni > > [1] http://www.gdal.org/ogr/drv_xls.html > Il 05/nov/2013 20:41 "Brent Wood" ha scritto: > >> Cheers... >> >> I don't want to create shapefiles or csv's, etc, from spreadsheets, I >> just want to plot *.xls files which contain x/y columns on the map. >> >> I sort of figured that if a GIS tool can open an xls file this would be >> pretty basic functionality... perhaps optimistically :-) >> >> The use case I'm envisaging is a live Excel spreadsheet used to store >> data. New rows (records) are added as appropriate. A QGIS project includes >> the spreadsheet as a current layer - so a QGIS user can open the >> spreadsheet, as well as other map layers, & save the project. Reopening the >> project would automatically plot all the rows in the spreadsheet on the map. >> >> The only ways I can see to achieve this functionality involve recreating >> another copy of the spreadsheet in another format before I can view the >> points on the map. Which is an annoying extra few steps every time I want >> to view the spreadsheet. >> >> Is this worth filing a ticket for? Perhaps add some extra functionality >> in the vector layer dialogue: if the file type opened is an xls, allow the >> user to (optionally) specify the column identifiers for the X & Y coords & >> the SRID to apply? >> >> Brent Wood >> >> -- >> *From:* G. Allegri >> *To:* Brent Wood >> *Cc:* "qgis-user@lists.osgeo.org" >> *Sent:* Wednesday, November 6, 2013 8:15 AM >> *Subject:* Re: [Qgis-user] How do I georeference an xls file opened in >> QGIS 2.0 >> >> I don't know if there's a plugin for that. >> Otherwise you could use Processing. Under QGIS geoalgorithms -> Vector >> creation tools you find Points layer from file. If you right click on it >> and choose Execute as batch process, you could generate all the shapefiles >> in one shot. >> >> giovanni >> >> >> 2013/11/5 Brent Wood >> >> >> I can open an XLS file OK, using vector dialogue, change file type to >> all, choose an xls file (created by Open Office) & I can open it & view the >> attribute table fine. >> >> What I'm unable to do is tell QGIS which columns to use for the lat/lon >> columns (each row represents a point). I can do this if I save the xls as a >> csv & open the delimited text file, but is there any way to do this >> natively with the xls file? I don't want to store a QGIS csv version of >> every spreadsheet >> >> Brent Wood >> >> >> >> ___ >> Qgis-user mailing list >> Qgis-user@lists.osgeo.org >> http://lists.osgeo.org/mailman/listinfo/qgis-user >> >> >> >> >> -- >> Giovanni Allegri >> http://about.me/giovanniallegri >> blog: http://blog.spaziogis.it >> GEO+ geomatica in Italia http://bit.ly/GEOplus >> >> >> ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] How do I georeference an xls file opened in QGIS 2.0
I understand your need and maybe it is worth a ticket, and maybe a sponsorship :) To keep a "live connection" with your spreadsheet you could create an OGR virtual layer, using the OGR Virtual Format [1]. Yet an extra step but this way your updates to the spreadsheet are automatically seen in your QGIS project. Giovanni [1] http://www.gdal.org/ogr/drv_xls.html Il 05/nov/2013 20:41 "Brent Wood" ha scritto: > Cheers... > > I don't want to create shapefiles or csv's, etc, from spreadsheets, I > just want to plot *.xls files which contain x/y columns on the map. > > I sort of figured that if a GIS tool can open an xls file this would be > pretty basic functionality... perhaps optimistically :-) > > The use case I'm envisaging is a live Excel spreadsheet used to store > data. New rows (records) are added as appropriate. A QGIS project includes > the spreadsheet as a current layer - so a QGIS user can open the > spreadsheet, as well as other map layers, & save the project. Reopening the > project would automatically plot all the rows in the spreadsheet on the map. > > The only ways I can see to achieve this functionality involve recreating > another copy of the spreadsheet in another format before I can view the > points on the map. Which is an annoying extra few steps every time I want > to view the spreadsheet. > > Is this worth filing a ticket for? Perhaps add some extra functionality in > the vector layer dialogue: if the file type opened is an xls, allow the > user to (optionally) specify the column identifiers for the X & Y coords & > the SRID to apply? > > Brent Wood > > -- > *From:* G. Allegri > *To:* Brent Wood > *Cc:* "qgis-user@lists.osgeo.org" > *Sent:* Wednesday, November 6, 2013 8:15 AM > *Subject:* Re: [Qgis-user] How do I georeference an xls file opened in > QGIS 2.0 > > I don't know if there's a plugin for that. > Otherwise you could use Processing. Under QGIS geoalgorithms -> Vector > creation tools you find Points layer from file. If you right click on it > and choose Execute as batch process, you could generate all the shapefiles > in one shot. > > giovanni > > > 2013/11/5 Brent Wood > > > I can open an XLS file OK, using vector dialogue, change file type to all, > choose an xls file (created by Open Office) & I can open it & view the > attribute table fine. > > What I'm unable to do is tell QGIS which columns to use for the lat/lon > columns (each row represents a point). I can do this if I save the xls as a > csv & open the delimited text file, but is there any way to do this > natively with the xls file? I don't want to store a QGIS csv version of > every spreadsheet > > Brent Wood > > > > ___ > Qgis-user mailing list > Qgis-user@lists.osgeo.org > http://lists.osgeo.org/mailman/listinfo/qgis-user > > > > > -- > Giovanni Allegri > http://about.me/giovanniallegri > blog: http://blog.spaziogis.it > GEO+ geomatica in Italia http://bit.ly/GEOplus > > > ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] How do I georeference an xls file opened in QGIS 2.0
Well, you can do this with DBF files, which Excel can open and save (part of a SHP). Or are you trying to save the spatial aspects in a tabular manner? Bobb From: qgis-user-boun...@lists.osgeo.org [mailto:qgis-user-boun...@lists.osgeo.org] On Behalf Of Brent Wood Sent: Tuesday, November 05, 2013 1:41 PM To: G. Allegri Cc: qgis-user@lists.osgeo.org Subject: Re: [Qgis-user] How do I georeference an xls file opened in QGIS 2.0 Cheers... I don't want to create shapefiles or csv's, etc, from spreadsheets, I just want to plot *.xls files which contain x/y columns on the map. I sort of figured that if a GIS tool can open an xls file this would be pretty basic functionality... perhaps optimistically :-) The use case I'm envisaging is a live Excel spreadsheet used to store data. New rows (records) are added as appropriate. A QGIS project includes the spreadsheet as a current layer - so a QGIS user can open the spreadsheet, as well as other map layers, & save the project. Reopening the project would automatically plot all the rows in the spreadsheet on the map. The only ways I can see to achieve this functionality involve recreating another copy of the spreadsheet in another format before I can view the points on the map. Which is an annoying extra few steps every time I want to view the spreadsheet. Is this worth filing a ticket for? Perhaps add some extra functionality in the vector layer dialogue: if the file type opened is an xls, allow the user to (optionally) specify the column identifiers for the X & Y coords & the SRID to apply? Brent Wood From: G. Allegri mailto:gioha...@gmail.com>> To: Brent Wood mailto:pcr...@pcreso.com>> Cc: "qgis-user@lists.osgeo.org<mailto:qgis-user@lists.osgeo.org>" mailto:qgis-user@lists.osgeo.org>> Sent: Wednesday, November 6, 2013 8:15 AM Subject: Re: [Qgis-user] How do I georeference an xls file opened in QGIS 2.0 I don't know if there's a plugin for that. Otherwise you could use Processing. Under QGIS geoalgorithms -> Vector creation tools you find Points layer from file. If you right click on it and choose Execute as batch process, you could generate all the shapefiles in one shot. giovanni 2013/11/5 Brent Wood mailto:pcr...@pcreso.com>> I can open an XLS file OK, using vector dialogue, change file type to all, choose an xls file (created by Open Office) & I can open it & view the attribute table fine. What I'm unable to do is tell QGIS which columns to use for the lat/lon columns (each row represents a point). I can do this if I save the xls as a csv & open the delimited text file, but is there any way to do this natively with the xls file? I don't want to store a QGIS csv version of every spreadsheet Brent Wood ___ Qgis-user mailing list Qgis-user@lists.osgeo.org<mailto:Qgis-user@lists.osgeo.org> http://lists.osgeo.org/mailman/listinfo/qgis-user -- Giovanni Allegri http://about.me/giovanniallegri blog: http://blog.spaziogis.it<http://blog.spaziogis.it/> GEO+ geomatica in Italia http://bit.ly/GEOplus ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] How do I georeference an xls file opened in QGIS 2.0
Cheers... I don't want to create shapefiles or csv's, etc, from spreadsheets, I just want to plot *.xls files which contain x/y columns on the map. I sort of figured that if a GIS tool can open an xls file this would be pretty basic functionality... perhaps optimistically :-) The use case I'm envisaging is a live Excel spreadsheet used to store data. New rows (records) are added as appropriate. A QGIS project includes the spreadsheet as a current layer - so a QGIS user can open the spreadsheet, as well as other map layers, & save the project. Reopening the project would automatically plot all the rows in the spreadsheet on the map. The only ways I can see to achieve this functionality involve recreating another copy of the spreadsheet in another format before I can view the points on the map. Which is an annoying extra few steps every time I want to view the spreadsheet. Is this worth filing a ticket for? Perhaps add some extra functionality in the vector layer dialogue: if the file type opened is an xls, allow the user to (optionally) specify the column identifiers for the X & Y coords & the SRID to apply? Brent Wood From: G. Allegri To: Brent Wood Cc: "qgis-user@lists.osgeo.org" Sent: Wednesday, November 6, 2013 8:15 AM Subject: Re: [Qgis-user] How do I georeference an xls file opened in QGIS 2.0 I don't know if there's a plugin for that. Otherwise you could use Processing. Under QGIS geoalgorithms -> Vector creation tools you find Points layer from file. If you right click on it and choose Execute as batch process, you could generate all the shapefiles in one shot. giovanni 2013/11/5 Brent Wood > >I can open an XLS file OK, using vector dialogue, change file type to all, >choose an xls file (created by Open Office) & I can open it & view the >attribute table fine. > > >What I'm unable to do is tell QGIS which columns to use for the lat/lon >columns (each row represents a point). I can do this if I save the xls as a >csv & open the delimited text file, but is there any way to do this natively >with the xls file? I don't want to store a QGIS csv version of every >spreadsheet > > >Brent Wood > > > >___ >Qgis-user mailing list >Qgis-user@lists.osgeo.org >http://lists.osgeo.org/mailman/listinfo/qgis-user > -- Giovanni Allegri http://about.me/giovanniallegri blog: http://blog.spaziogis.it GEO+ geomatica in Italia http://bit.ly/GEOplus ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] How do I georeference an xls file opened in QGIS 2.0
I don't know if there's a plugin for that. Otherwise you could use Processing. Under QGIS geoalgorithms -> Vector creation tools you find Points layer from file. If you right click on it and choose Execute as batch process, you could generate all the shapefiles in one shot. giovanni 2013/11/5 Brent Wood > > I can open an XLS file OK, using vector dialogue, change file type to all, > choose an xls file (created by Open Office) & I can open it & view the > attribute table fine. > > What I'm unable to do is tell QGIS which columns to use for the lat/lon > columns (each row represents a point). I can do this if I save the xls as a > csv & open the delimited text file, but is there any way to do this > natively with the xls file? I don't want to store a QGIS csv version of > every spreadsheet > > Brent Wood > > > > ___ > Qgis-user mailing list > Qgis-user@lists.osgeo.org > http://lists.osgeo.org/mailman/listinfo/qgis-user > -- Giovanni Allegri http://about.me/giovanniallegri blog: http://blog.spaziogis.it GEO+ geomatica in Italia http://bit.ly/GEOplus ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] How do I georeference an xls file opened in QGIS 2.0
I can open an XLS file OK, using vector dialogue, change file type to all, choose an xls file (created by Open Office) & I can open it & view the attribute table fine. What I'm unable to do is tell QGIS which columns to use for the lat/lon columns (each row represents a point). I can do this if I save the xls as a csv & open the delimited text file, but is there any way to do this natively with the xls file? I don't want to store a QGIS csv version of every spreadsheet Brent Wood___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
