[Qgis-user] refactoring tables defaults to maximum sizes

[Goyo]

That is a limit of the shapefile format. Spatialite or geopackage
might be suitable alternatives.

2017-09-03 22:27 GMT+02:00 Robert Sweeny <rsweeny at mun.ca>:
> 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
>
>
> _______________________________________________
> 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