[GIS] Showing attribute table in form using PyQGIS

attribute-tablepyqgis

Is there any way to show the attribute table of a layer in a QTextBrowser or a QTableView on form?

I did this but, (shows attribute table in a separate dialog) I have no idea, how to show it in my form.

iface.showAttributeTable(iface.activeLayer)

Best Answer

QGIS 2.2 has a table model that you can use for a QTableView. Use it like this:

cache = QgsVectorLayerCache(layer, 10000)
model = QgsAttributeTableModel(cache)
model.loadLayer()
table = QTableView()
table.setModel(model)

Related Solutions

GDAL – How to Show Only Raster Attribute Table Using GDAL

Unless you use os/shell specific operations i.e. grep etc... there's no way that I know of to do this from the command line with gdalinfo.

A python alternative is to use the GetDefaultRAT() method and output to XML (which is what gdalinfo does):

import sys
from osgeo import gdal
import xml.etree.ElementTree as et #I much prefer the lxml library
                                   #but it's 3rd party and must be installed

def toxml(rat):
    #partial port of Serialize() from svn.osgeo.org/gdal/trunk/gdal/gcore/gdal_rat.cpp

    rattree=et.Element('GDALRasterAttributeTable')

    coltypes=[]

    #Define each column.
    icolcount=rat.GetColumnCount()
    for icol in range(icolcount):
        field=et.SubElement(rattree,'FieldDefn', {'index':str(icol)})
        fname=et.SubElement(field,'Name')
        ftype=et.SubElement(field,'Type')
        fusage=et.SubElement(field,'Usage')

        itype=rat.GetTypeOfCol(icol)

        fname.text=rat.GetNameOfCol(icol)
        ftype.text=str(rat.GetTypeOfCol(icol))
        fusage.text=str(rat.GetUsageOfCol(icol))

        if itype==gdal.GFT_Integer:
            coltypes.append(['%s', rat.GetValueAsInt])
        elif itype==gdal.GFT_Real:
            coltypes.append(['%.16g', rat.GetValueAsDouble])
        else:
            coltypes.append(['%s', rat.GetValueAsString])

    #Write out each row.
    irowcount = rat.GetRowCount()
    for irow in range(irowcount):
        row=et.SubElement(rattree,'Row', {'index':str(irow)})
        for icol in range(icolcount):
            rowcol=et.SubElement(row,'F')
            itype=rat.GetTypeOfCol(icol)
            if itype==gdal.GFT_Integer:
                rowcol.text='%s'%rat.GetValueAsInt(irow,icol)
            elif itype==gdal.GFT_Real:
                rowcol.text='%.16g'%rat.GetValueAsDouble(irow,icol)
            else:
                rowcol.text='%s'%rat.GetValueAsString(irow,icol)

    return et.tostring(rattree)

if __name__ == '__main__':
    ds=gdal.Open(sys.argv[1])
    rat=ds.GetRasterBand(1).GetDefaultRAT()
    sxml=toxml(rat)

    print sxml

    #Or if you want to pretty print
    import xml.dom.minidom as md
    print md.parseString(sxml).toprettyxml()

and here's a function to write out a CSV file.

import csv
import sys

from osgeo import gdal

def tocsv(rat, filepath):
    with open(filepath, 'w') as csvfile:
        csvwriter = csv.writer(csvfile)

        #Write out column headers
        icolcount=rat.GetColumnCount()
        cols=[]
        for icol in range(icolcount):
            cols.append(rat.GetNameOfCol(icol))
        csvwriter.writerow(cols)

        #Write out each row.
        irowcount = rat.GetRowCount()
        for irow in range(irowcount):
            cols=[]
            for icol in range(icolcount):
                itype=rat.GetTypeOfCol(icol)
                if itype==gdal.GFT_Integer:
                    value='%s'%rat.GetValueAsInt(irow,icol)
                elif itype==gdal.GFT_Real:
                    value='%.16g'%rat.GetValueAsDouble(irow,icol)
                else:
                    value='%s'%rat.GetValueAsString(irow,icol)
                cols.append(value)
            csvwriter.writerow(cols)


if __name__ == '__main__':
    ds=gdal.Open(sys.argv[1])
    rat=ds.GetRasterBand(1).GetDefaultRAT()
    tocsv(rat, '/path/to/output.csv')

Best Answer

Related Solutions

GDAL – How to Show Only Raster Attribute Table Using GDAL

Related Question