Excuse me. I forgot. I'm reading an manual, what about GRASS to load this data? Thanks.
>----Messaggio originale---- >Da: [email protected] >Data: 12/11/2013 19.00 >A: <[email protected]>, <[email protected]> >Ogg: R: Re: R: Re: [Qgis-user] Add table excel and categorize > > >Hi, >thanks a lot. >I've solved the problem. >CSV is indeed recognized as a string but I downloaded Quantum 2.0 and with >some tricks, the system allows to graduate values . >When I import CSV use " Custom delimiters " in this way successfully it loads >the file. >Thank you very much! > >>----Messaggio originale---- >>Da: [email protected] >>Data: 12/11/2013 16.35 >>A: "[email protected]"<[email protected]>, <qgis- user@lists. >osgeo.org> >>Ogg: Re: R: Re: [Qgis-user] Add table excel and categorize >> >>Am 12.11.2013 16:01, schrieb [email protected]: >>> Hi, >>> yes the file is a csv (which has numeric values). >>Check the csv properties within QGIS -> Fields Tab: See if your fields >>are really interpreted as integer/real values and NOT string! >>Cause when this is string, the values can't show up for classification. >> >>When you use 2.0 (at least), you might have better luck importing the >>csv through Layers -> Add delimited text file instead of drag-and-drop >>into the ToC. >>There QGIS tries to guess the field type. >> >>This might fail as well, cause your original excel sheet might have >>wrong data. A very popular bug are spaces in front or behind your numbers. >>You should search and delete them there. >> >>There is also the possibility to create an affiliated csvt-file (see >>http://anitagraser.com/2011/03/07/how-to-specify-data-types-of-csv-columns- >for-use-in-qgis/), >>in which you define the field type for the csv. But this is a very >>tiresome work when you have lots of fields. >> >> >>So, lots of speculations from my side. But we'll see ... >> >>Cheers >>Bernd >> >> >> >>> The layer to add this csv is a shapefile (its table of attributes contains >>> cod, name, lenghts of municipalities). >>> I joined them and infact the table of attributes shows the name of >>> municipalities, lenghts...and corresponding values. >>> I saved it (ESRI Shapefile) and when I select the "Style" to graduate the >>> values, the column shows only the cod. of municipalities, shape leng and >area. >>> Can you help me? >>> Thanks a lot >>> >>>> ----Messaggio originale---- >>>> Da: [email protected] >>>> Data: 11/11/2013 21.45 >>>> A: <[email protected]>, "[email protected]" >>> <[email protected]> >>>> Ogg: Re: [Qgis-user] Add table excel and categorize >>>> >>>> Hi, >>>> >>>> 1. >>>> adding a csv is not the same like loading a shape. So you can't edit it. >>>> Loading as dbf should give you write permissions (OpenOffice/Libre Office >>>> still offer dbf support, while new Excel versions don't) >>>> >>>> 2. >>>> I assume you joined the csv to an existing layer? In QGIS 2.0, the joined >>>> columns are presented for classification, in 1.8 you will (i think) have >>>> to make the join permanent by saving the joined layer to a new one. Then, >>>> all attributes are editable as well. >>>> >>>> Hope I answered your questions >>>> >>>> Bernd >>>> >>>> Am 11.11.2013, 19:53 Uhr, schrieb [email protected] >>>> <[email protected]>: >>>> >>>>> Dear all members of list, >>>>> I have to add a table in excel that contains indices calculated for each >>>>> municipality. >>>>> >>>>> I turned the sheet from excel to csv and added to the table of >>>>> attributes as usual, but I have two problems: >>>>> >>>>> 1. >>>>> Some data (indexes) when combined (the table with common code and other >>>>> attributes) >>>>> appear with the word >>>>> "null", I can add them manually? When I try to add them by editing the >>>>> appropriate line, but the program does not save the changes. >>>>> >>>>> 2. >>>>> When I want to customize the style, >>>>> ie I want to categorize the classified data (they are many) and I do not >>>>> know how to reduce or customize intervals. When I try the option >>>>> graduated the values joined (indices) to the table (municipalities) do >>>>> not appear in the column.Thanks. >>>>> >>>>> >>>>> >>>> >>>> -- >>>> Bernd Vogelgesang * Siedlerstrasse 2 * 91083 Baiersdorf * +49-9133-825374 >>>> >>> >> >> > > _______________________________________________ Qgis-user mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/qgis-user
