Custom cursor in QGIS plugin

Custom cursor showing bearing

Last january I developed QGIS plugin called Transectizer. Fortunately it was catalogued and sent to the box (or, who knows if a coffin) of the expermiental plugins.

Custom cursor showing bearing

A custom, chatty QGIS plugin cursor showing the bearing of the rubberband being drawn.

Yes, I said fortunately, because that prompted me towards changing some features of the plugin. One of these features is the ability of the plugin of give some feedback to the user about the bearing of a line drawn in the canvas, to make possible to interactively choose a certain parameter that is needed for the plugin to work.

In the first version of the plugin (the second is upcoming, see below), it just updates the text of a LineEdit widget inside the QGIS plugin dialog. This is a relatively simple task, Continue reading

Crosstabs in PostgreSQL: PivotMyTable

Crosstabs in PostgreSQL: PivotMyTable

PivotMyTable is a PL/Python function for use in PostgreSQL servers. Its aim is to get crosstab  tables in PostgreSQL in a more friendly way that PostgreSQL module tablefunc does with its crosstab series functions and in fact it behaves ,at last, as a proxy for tablefunc functions.

PivotMyTable makes possible to create crosstabs in PostgreSQL in the same way that other available solutions, automating the creation of the queries that the tablefunc crosstab functions need to work.

Continue reading