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