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 <[email protected]>: > 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 _______________________________________________ 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
