[Qgis-user] refactoring tables defaults to maximum sizes

[Robert Sweeny]

Jorge (and fellow Qgisers)

I am trying to create a single file that includes a point for each of 
51k households in the 1901 census of Montreal. I have linked these 
households to the 18k lots where they resided, as this suggests in many 
cases more than household lived on a lot. I imported from Excel file as 
a csv table all of the first households on the lot, then the second, 
then the third, etc. Using the point centroid feature of Qgis I created 
household1.shp, household2.shp, etc, after joining each csv file to a 
shape file of the polygons representing the occupied lots in the city. I 
then moved the points for the second households (and each of the other 
ones) over so they would not be hidden by the point for the first 
household. Then I tried to create from these point shape files a single 
file and that is where the problems started. I created generic fields 
for each field that existed in the original csv file and then copied its 
contents from the joined shape file into these new fields before 
deleting the join. This is a cumbersome method I know, but it seemed to 
work save for the problem that the new fields defaulted to maximum sizes 
(10 for integers and 264 for string fields). This makes a humongous 
file! I tried resizing the fields with the refactor table utility, but 
that did not work either. Any ideas on what I should try now?

Thank you so much for advice you can give.

Robert Sweeny



On 03/09/2017 4:30 PM, qgis-user-request at lists.osgeo.org wrote:
> Send Qgis-user mailing list submissions to
> 	qgis-user at lists.osgeo.org
>
> To subscribe or unsubscribe via the World Wide Web, visit
> 	https://lists.osgeo.org/mailman/listinfo/qgis-user
> or, via email, send a message with subject or body 'help' to
> 	qgis-user-request at lists.osgeo.org
>
> You can reach the person managing the list at
> 	qgis-user-owner at lists.osgeo.org
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of Qgis-user digest..."
>
>
> Today's Topics:
>
>     1. Re: refactoring tables defaults to maximum sizes
>        (Jorge Gustavo Rocha)
>     2. orfeo-toolbox (linux) (Daniel Torres)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Sat, 2 Sep 2017 22:04:16 +0100
> From: Jorge Gustavo Rocha <jgr at di.uminho.pt>
> To: <qgis-user at lists.osgeo.org>
> Subject: Re: [Qgis-user] refactoring tables defaults to maximum sizes
> Message-ID: <ad4179a9-584c-91b6-0632-894228ab5967 at di.uminho.pt>
> Content-Type: text/plain; charset="utf-8"
>
> Hi Robert,
>
> Which kind of tables (provider) are you using?
>
> Regards,
>
> Jorge Gustavo
>
> On 02-09-2017 18:26, Robert Sweeny wrote:
>> Hi people
>>
>> I am trying to combine a number of point files together but when I
>> create new fields the length I specify is ignored and the size defaults
>> to the maximum (ie 254 for string fields). When I tried editing the
>> table using refactor tables the same thing happened. How can I edit the
>> length of a field in an existing table from within Qgis?
>>
>> thanks
>>
>> Robert Sweeny
>>
>> _______________________________________________
>> Qgis-user mailing list
>> Qgis-user at lists.osgeo.org
>> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
>> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
> J. Gustavo