Re: [Qgis-user] Hoja de Excel generada por ODK
Hello, let's review the information, thank you very much Eddison 2018-07-25 9:22 GMT-06:00 Raymond Nijssen : > Now that's service, Lene!! :+1: > > > On 25-07-18 17:17, Lene Fischer wrote: > >> Try to see this video. I open your points in QGIS >> https://www.screencast.com/t/9zhTmKx2L >> >> *Lene Fischer* >> >> Associate Professor >> >> *University of Copenhagen* >> >> Department of Geoscience and Natural Resource Management >> >> Forest and Landscape College >> >> Nødebovej 77a >> >> 3480 Fredensborg >> >> Denmark >> >> MOB +45 40115084 >> >> _...@ign.ku.dk_ <mailto:l...@ign.ku.dk> >> >> <@Lene_Fischer> >> >> *Fra:*Eddison Araya [mailto:eddisonj...@gmail.com] >> *Sendt:* 25. juli 2018 16:55 >> *Til:* Lene Fischer >> *Cc:* qgis-user >> *Emne:* Re: [Qgis-user] Hoja de Excel generada por ODK >> >> Hello, thank you very much, I am going to look for the function of >> separating the values of comma, in column. I have passed the file to csv >> format but in the same way the coordinates column remains united in a >> single field with X and Y and I can not plot it in QGIS, thanks. >> >> Eddison >> >> 2018-07-25 0:29 GMT-06:00 Lene Fischer > l...@ign.ku.dk>>: >> >> Hi Eddison, >> >> Save the data as a .txt or .CSV file >> >> Open as Delimited Text and Choose Custom Delimiters. Then choose ‘Comma’ >> >> Then you can add X and Y columns >> >> Regards >> >> *Lene Fischer* >> >> Associate Professor >> >> *University of Copenhagen* >> >> Department of Geoscience and Natural Resource Management >> >> Forest and Landscape College >> >> Nødebovej 77a <https://maps.google.com/?q=N% >> C3%B8debovej+77a+%0D%0A+3480+Fredensborg+%0D%0A+Denmark >> y=gmail=g> >> >> 3480 Fredensborg <https://maps.google.com/?q=N% >> C3%B8debovej+77a+%0D%0A+3480+Fredensborg+%0D%0A+Denmark >> y=gmail=g> >> >> Denmark <https://maps.google.com/?q=N%C3%B8debovej+77a+%0D%0A+3480+F >> redensborg+%0D%0A+Denmark=gmail=g> >> >> MOB +45 40115084 >> >> l...@ign.ku.dk <mailto:l...@ign.ku.dk> >> >> <http://@Lene_Fischer> >> >> *Fra:*Qgis-user [mailto:qgis-user-boun...@lists.osgeo.org > qgis-user-boun...@lists.osgeo.org>] *På vegne af *Eddison Araya >> *Sendt:* 25. juli 2018 06:37 >> *Til:* qgis-user >> *Emne:* [Qgis-user] Hoja de Excel generada por ODK >> >> >> Hello, I used ODK Collector connected with Google Drive to perform field >> surveys. >> >> As you can see, the X and Y coordinates are contained in the same column >> when using the ODK Collector APP, connected to the Google Drive Sheet. How >> can I take that to QGIS? I have tried to use the function Add Layer of >> Delimited Text I can not do it since the coordinates are in the same column. >> >> Thank you >> >> Eddison >> >> Gracias >> >> Eddison >> >> >> >> ___ >> Qgis-user mailing list >> Qgis-user@lists.osgeo.org >> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user >> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user >> >> > -- > Terglobo > Fahrenheitstraat 1 > 5223 BJ 's-Hertogenbosch > The Netherlands > +31 (0) 6 25 31 49 83 > ___ > Qgis-user mailing list > Qgis-user@lists.osgeo.org > List info: https://lists.osgeo.org/mailman/listinfo/qgis-user > Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Hoja de Excel generada por ODK
Now that's service, Lene!! :+1: On 25-07-18 17:17, Lene Fischer wrote: Try to see this video. I open your points in QGIS https://www.screencast.com/t/9zhTmKx2L *Lene Fischer* Associate Professor *University of Copenhagen* Department of Geoscience and Natural Resource Management Forest and Landscape College Nødebovej 77a 3480 Fredensborg Denmark MOB +45 40115084 _...@ign.ku.dk_ <mailto:l...@ign.ku.dk> <@Lene_Fischer> *Fra:*Eddison Araya [mailto:eddisonj...@gmail.com] *Sendt:* 25. juli 2018 16:55 *Til:* Lene Fischer *Cc:* qgis-user *Emne:* Re: [Qgis-user] Hoja de Excel generada por ODK Hello, thank you very much, I am going to look for the function of separating the values of comma, in column. I have passed the file to csv format but in the same way the coordinates column remains united in a single field with X and Y and I can not plot it in QGIS, thanks. Eddison 2018-07-25 0:29 GMT-06:00 Lene Fischer <mailto:l...@ign.ku.dk>>: Hi Eddison, Save the data as a .txt or .CSV file Open as Delimited Text and Choose Custom Delimiters. Then choose ‘Comma’ Then you can add X and Y columns Regards *Lene Fischer* Associate Professor *University of Copenhagen* Department of Geoscience and Natural Resource Management Forest and Landscape College Nødebovej 77a <https://maps.google.com/?q=N%C3%B8debovej+77a+%0D%0A+3480+Fredensborg+%0D%0A+Denmark=gmail=g> 3480 Fredensborg <https://maps.google.com/?q=N%C3%B8debovej+77a+%0D%0A+3480+Fredensborg+%0D%0A+Denmark=gmail=g> Denmark <https://maps.google.com/?q=N%C3%B8debovej+77a+%0D%0A+3480+Fredensborg+%0D%0A+Denmark=gmail=g> MOB +45 40115084 l...@ign.ku.dk <mailto:l...@ign.ku.dk> <http://@Lene_Fischer> *Fra:*Qgis-user [mailto:qgis-user-boun...@lists.osgeo.org <mailto:qgis-user-boun...@lists.osgeo.org>] *På vegne af *Eddison Araya *Sendt:* 25. juli 2018 06:37 *Til:* qgis-user *Emne:* [Qgis-user] Hoja de Excel generada por ODK Hello, I used ODK Collector connected with Google Drive to perform field surveys. As you can see, the X and Y coordinates are contained in the same column when using the ODK Collector APP, connected to the Google Drive Sheet. How can I take that to QGIS? I have tried to use the function Add Layer of Delimited Text I can not do it since the coordinates are in the same column. Thank you Eddison Gracias Eddison ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user -- Terglobo Fahrenheitstraat 1 5223 BJ 's-Hertogenbosch The Netherlands +31 (0) 6 25 31 49 83 ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Hoja de Excel generada por ODK
Try to see this video. I open your points in QGIS https://www.screencast.com/t/9zhTmKx2L Lene Fischer Associate Professor University of Copenhagen Department of Geoscience and Natural Resource Management Forest and Landscape College Nødebovej 77a 3480 Fredensborg Denmark MOB +45 40115084 l...@ign.ku.dk<mailto:l...@ign.ku.dk> [cid:image001.gif@01D4243B.62BA6480] [cid:image002.png@01D4243B.62BA6480]<@Lene_Fischer> Fra: Eddison Araya [mailto:eddisonj...@gmail.com] Sendt: 25. juli 2018 16:55 Til: Lene Fischer Cc: qgis-user Emne: Re: [Qgis-user] Hoja de Excel generada por ODK Hello, thank you very much, I am going to look for the function of separating the values of comma, in column. I have passed the file to csv format but in the same way the coordinates column remains united in a single field with X and Y and I can not plot it in QGIS, thanks. Eddison 2018-07-25 0:29 GMT-06:00 Lene Fischer mailto:l...@ign.ku.dk>>: Hi Eddison, Save the data as a .txt or .CSV file Open as Delimited Text and Choose Custom Delimiters. Then choose ‘Comma’ Then you can add X and Y columns Regards Lene Fischer Associate Professor University of Copenhagen Department of Geoscience and Natural Resource Management Forest and Landscape College Nødebovej 77a<https://maps.google.com/?q=N%C3%B8debovej+77a+%0D%0A+3480+Fredensborg+%0D%0A+Denmark=gmail=g> 3480 Fredensborg<https://maps.google.com/?q=N%C3%B8debovej+77a+%0D%0A+3480+Fredensborg+%0D%0A+Denmark=gmail=g> Denmark<https://maps.google.com/?q=N%C3%B8debovej+77a+%0D%0A+3480+Fredensborg+%0D%0A+Denmark=gmail=g> MOB +45 40115084 l...@ign.ku.dk<mailto:l...@ign.ku.dk> [cid:image001.gif@01D4243B.62BA6480] [cid:image002.png@01D4243B.62BA6480]<http://@Lene_Fischer> Fra: Qgis-user [mailto:qgis-user-boun...@lists.osgeo.org<mailto:qgis-user-boun...@lists.osgeo.org>] På vegne af Eddison Araya Sendt: 25. juli 2018 06:37 Til: qgis-user Emne: [Qgis-user] Hoja de Excel generada por ODK Hello, I used ODK Collector connected with Google Drive to perform field surveys. [cid:image003.png@01D4243B.62BA6480] As you can see, the X and Y coordinates are contained in the same column when using the ODK Collector APP, connected to the Google Drive Sheet. How can I take that to QGIS? I have tried to use the function Add Layer of Delimited Text I can not do it since the coordinates are in the same column. Thank you Eddison Gracias Eddison ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Hoja de Excel generada por ODK
Hello, thank you very much, I am going to look for the function of separating the values of comma, in column. I have passed the file to csv format but in the same way the coordinates column remains united in a single field with X and Y and I can not plot it in QGIS, thanks. Eddison 2018-07-25 0:29 GMT-06:00 Lene Fischer : > Hi Eddison, > > Save the data as a .txt or .CSV file > > Open as Delimited Text and Choose Custom Delimiters. Then choose ‘Comma’ > > Then you can add X and Y columns > > Regards > > > > > > *Lene Fischer* > > Associate Professor > > > > *University of Copenhagen* > > Department of Geoscience and Natural Resource Management > > Forest and Landscape College > > Nødebovej 77a > <https://maps.google.com/?q=N%C3%B8debovej+77a+%0D%0A+3480+Fredensborg+%0D%0A+Denmark=gmail=g> > > 3480 Fredensborg > <https://maps.google.com/?q=N%C3%B8debovej+77a+%0D%0A+3480+Fredensborg+%0D%0A+Denmark=gmail=g> > > Denmark > <https://maps.google.com/?q=N%C3%B8debovej+77a+%0D%0A+3480+Fredensborg+%0D%0A+Denmark=gmail=g> > > > > > > MOB +45 40115084 > > *l...@ign.ku.dk* > > > > > > > > > > <http://@Lene_Fischer> > > > > > > > > *Fra:* Qgis-user [mailto:qgis-user-boun...@lists.osgeo.org] *På vegne af > *Eddison > Araya > *Sendt:* 25. juli 2018 06:37 > *Til:* qgis-user > *Emne:* [Qgis-user] Hoja de Excel generada por ODK > > > > > Hello, I used ODK Collector connected with Google Drive to perform field > surveys. > > > > > > As you can see, the X and Y coordinates are contained in the same column > when using the ODK Collector APP, connected to the Google Drive Sheet. How > can I take that to QGIS? I have tried to use the function Add Layer of > Delimited Text I can not do it since the coordinates are in the same column. > > > > Thank you > > > > Eddison > > > > Gracias > > > > Eddison > ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Hoja de Excel generada por ODK
Hi Eddison, Save the data as a .txt or .CSV file Open as Delimited Text and Choose Custom Delimiters. Then choose ‘Comma’ Then you can add X and Y columns Regards Lene Fischer Associate Professor University of Copenhagen Department of Geoscience and Natural Resource Management Forest and Landscape College Nødebovej 77a 3480 Fredensborg Denmark MOB +45 40115084 l...@ign.ku.dk<mailto:l...@ign.ku.dk> [cid:image001.gif@01D423F1.A6638EE0] [cid:image002.png@01D423F1.A6638EE0]<@Lene_Fischer> Fra: Qgis-user [mailto:qgis-user-boun...@lists.osgeo.org] På vegne af Eddison Araya Sendt: 25. juli 2018 06:37 Til: qgis-user Emne: [Qgis-user] Hoja de Excel generada por ODK Hello, I used ODK Collector connected with Google Drive to perform field surveys. [cid:image003.png@01D423F1.A6638EE0] As you can see, the X and Y coordinates are contained in the same column when using the ODK Collector APP, connected to the Google Drive Sheet. How can I take that to QGIS? I have tried to use the function Add Layer of Delimited Text I can not do it since the coordinates are in the same column. Thank you Eddison Gracias Eddison ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Hoja de Excel generada por ODK
Hi, I don’t know Google Sheets, but in Excel you can use any of the functions available to split the coordinates at the comma “,” character and put the parts into new columns. Hth Frank Von: Qgis-user Im Auftrag von Eddison Araya Gesendet: Mittwoch, 25. Juli 2018 06:37 An: qgis-user Betreff: [Qgis-user] Hoja de Excel generada por ODK Hello, I used ODK Collector connected with Google Drive to perform field surveys. As you can see, the X and Y coordinates are contained in the same column when using the ODK Collector APP, connected to the Google Drive Sheet. How can I take that to QGIS? I have tried to use the function Add Layer of Delimited Text I can not do it since the coordinates are in the same column. Thank you Eddison Gracias Eddison smime.p7s Description: S/MIME cryptographic signature ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] Hoja de Excel generada por ODK
Hello, I used ODK Collector connected with Google Drive to perform field surveys. As you can see, the X and Y coordinates are contained in the same column when using the ODK Collector APP, connected to the Google Drive Sheet. How can I take that to QGIS? I have tried to use the function Add Layer of Delimited Text I can not do it since the coordinates are in the same column. Thank you Eddison Gracias Eddison MAPA_odk.xlsx Description: MS-Excel 2007 spreadsheet ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user