SpaceGroupUCL / qgisSpaceSyntaxToolkit

Space Syntax Toolkit for QGIS
GNU General Public License v3.0
119 stars 40 forks source link

Features suggestion: order of columns and short names #142

Open rtsaboya opened 7 years ago

rtsaboya commented 7 years ago

Hello, Jorge: I would like to suggest a couple of features that, hopefully, wouldn't demand more than a few lines of code:

1. Properly ordering resulting columns If we run an analysis with multiple radii, the order in which they appear is defined alphabetically, resulting in something like this:

int | intr1000m | intr10000m | intr1500m | intr500m | intr5000m

It would be a nice touch if they could be ordered by radius size instead.

2. Offering the option to generate short field names in Spatialite and PostGIS as well One of the most valuable features of the plugin is the ability to generate short field names that remain legible despite shapefiles' limitations regarding the size of column names. This greatly facilitates their handling, especially comparing to the old use case scenario of importing and converting MIF files.

It would be a nice addition if we could choose short names for Spatialite and PostGIS too, considering that they may be later exported to shapefile for sharing purposes.

Thanks for this awesome plugin!

jorgegil commented 7 years ago

Hi Renato,

Thanks for the suggestions.

The column order is the one provided with the depthmapX results. I'll have a look into this, although it's not a trivial modification because the order returned is not the same as the order of the radii provided for analysis. So the tool will need to figure out from the column names what radii they map to.

Having an option for short names in Spatialite and PostGIS is more straightforward, a simple modification that I can include in the next update. I have also faced the problem of exporting results from PostGIS into shapefile and getting the garbled column names.

Best, Jorge

rtsaboya commented 7 years ago

Jorge, thanks for the quick reply.

Now that I come to think of it, it seems kind of obvious that I should have asked for the change in column order in Depthmap's page.

Cheers.