refactoring tables defaults to maximum sizes

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

refactoring tables defaults to maximum sizes

Robert Sweeny
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
[hidden email]
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
Reply | Threaded
Open this post in threaded view
|

Re: refactoring tables defaults to maximum sizes

Jorge Gustavo Rocha
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
> [hidden email]
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

J. Gustavo
--
Jorge Gustavo Rocha
Departamento de Informática
Universidade do Minho
4710-057 Braga
Tel: +351 253604480
Fax: +351 253604471
Móvel: +351 910333888
skype: nabocudnosor
_______________________________________________
Qgis-user mailing list
[hidden email]
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
Reply | Threaded
Open this post in threaded view
|

Re: refactoring tables defaults to maximum sizes

Robert Sweeny
In reply to this post by 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, [hidden email] wrote:

> Send Qgis-user mailing list submissions to
> [hidden email]
>
> 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
> [hidden email]
>
> You can reach the person managing the list at
> [hidden email]
>
> 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 <[hidden email]>
> To: <[hidden email]>
> Subject: Re: [Qgis-user] refactoring tables defaults to maximum sizes
> Message-ID: <[hidden email]>
> 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
>> [hidden email]
>> 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
[hidden email]
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
Reply | Threaded
Open this post in threaded view
|

Re: 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 <[hidden email]>:

> 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, [hidden email] wrote:
>>
>> Send Qgis-user mailing list submissions to
>>         [hidden email]
>>
>> 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
>>         [hidden email]
>>
>> You can reach the person managing the list at
>>         [hidden email]
>>
>> 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 <[hidden email]>
>> To: <[hidden email]>
>> Subject: Re: [Qgis-user] refactoring tables defaults to maximum sizes
>> Message-ID: <[hidden email]>
>> 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
>>> [hidden email]
>>> 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
> [hidden email]
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
_______________________________________________
Qgis-user mailing list
[hidden email]
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user