Is there a maximum number of features that QGIS can save into a shapefile?
Clash Royale CLAN TAG#URR8PPP
I have a very large .gdb that I want to reduce to my study area. Unfortunately, the study area is still quite big. I could select features that intersected my study area but when I tried Export > Save Selected Feature As...it crashed and only saved some of the features (4GB). Ideally, I would create another .gdb but it seems that QGIS does not support .gdb creation (read-only) or delete the features I don't need directly in the .gdb but as far as I know it is not possible to modify a layer in a .gdb.
qgis qgis-3 features save
asked Feb 15 at 15:13
user3386170user3386170
631422
add a comment |
I have a very large .gdb that I want to reduce to my study area. Unfortunately, the study area is still quite big. I could select features that intersected my study area but when I tried Export > Save Selected Feature As...it crashed and only saved some of the features (4GB). Ideally, I would create another .gdb but it seems that QGIS does not support .gdb creation (read-only) or delete the features I don't need directly in the .gdb but as far as I know it is not possible to modify a layer in a .gdb.
qgis qgis-3 features save
asked Feb 15 at 15:13
user3386170user3386170
631422
Could you create and save subselections of the data based on thematic or spatial criteria?
– Erik
Feb 15 at 15:15
1
Why not try the geopackage format?
– Gabriel C.
Feb 15 at 15:18
@GabrielC. I don't understand the geopackage format even though I have looked into it. Doesn't it create layers that are not fully compatible with shapefiles?
– user3386170
Feb 15 at 15:38
@Erik I have created subselections when I ran into the problem but it is not ideal. I would rather find another solution (if possible).
– user3386170
Feb 15 at 15:39
2
What makes you think that GeoPackage is not compatible with shapefiles? It does lack many limitations of shapefiles, but all that you can save as shapefiles can also be stored into GeoPackage.
– user30184
Feb 15 at 15:43
add a comment |
I have a very large .gdb that I want to reduce to my study area. Unfortunately, the study area is still quite big. I could select features that intersected my study area but when I tried Export > Save Selected Feature As...it crashed and only saved some of the features (4GB). Ideally, I would create another .gdb but it seems that QGIS does not support .gdb creation (read-only) or delete the features I don't need directly in the .gdb but as far as I know it is not possible to modify a layer in a .gdb.
qgis qgis-3 features save
asked Feb 15 at 15:13
user3386170user3386170
631422
I have a very large .gdb that I want to reduce to my study area. Unfortunately, the study area is still quite big. I could select features that intersected my study area but when I tried Export > Save Selected Feature As...it crashed and only saved some of the features (4GB). Ideally, I would create another .gdb but it seems that QGIS does not support .gdb creation (read-only) or delete the features I don't need directly in the .gdb but as far as I know it is not possible to modify a layer in a .gdb.
qgis qgis-3 features save
qgis qgis-3 features save
asked Feb 15 at 15:13
user3386170user3386170
631422
asked Feb 15 at 15:13
user3386170user3386170
631422
asked Feb 15 at 15:13
user3386170user3386170
631422
asked Feb 15 at 15:13
user3386170user3386170
631422
asked Feb 15 at 15:13
user3386170user3386170
631422
631422
Could you create and save subselections of the data based on thematic or spatial criteria?
– Erik
Feb 15 at 15:15
1
Why not try the geopackage format?
– Gabriel C.
Feb 15 at 15:18
@GabrielC. I don't understand the geopackage format even though I have looked into it. Doesn't it create layers that are not fully compatible with shapefiles?
– user3386170
Feb 15 at 15:38
@Erik I have created subselections when I ran into the problem but it is not ideal. I would rather find another solution (if possible).
– user3386170
Feb 15 at 15:39
2
What makes you think that GeoPackage is not compatible with shapefiles? It does lack many limitations of shapefiles, but all that you can save as shapefiles can also be stored into GeoPackage.
– user30184
Feb 15 at 15:43
add a comment |
Could you create and save subselections of the data based on thematic or spatial criteria?
– Erik
Feb 15 at 15:15
1
Why not try the geopackage format?
– Gabriel C.
Feb 15 at 15:18
@GabrielC. I don't understand the geopackage format even though I have looked into it. Doesn't it create layers that are not fully compatible with shapefiles?
– user3386170
Feb 15 at 15:38
@Erik I have created subselections when I ran into the problem but it is not ideal. I would rather find another solution (if possible).
– user3386170
Feb 15 at 15:39
2
What makes you think that GeoPackage is not compatible with shapefiles? It does lack many limitations of shapefiles, but all that you can save as shapefiles can also be stored into GeoPackage.
– user30184
Feb 15 at 15:43
Could you create and save subselections of the data based on thematic or spatial criteria?
– Erik
Feb 15 at 15:15
Could you create and save subselections of the data based on thematic or spatial criteria?
– Erik
Feb 15 at 15:15
1
1
Why not try the geopackage format?
– Gabriel C.
Feb 15 at 15:18
Why not try the geopackage format?
– Gabriel C.
Feb 15 at 15:18
@GabrielC. I don't understand the geopackage format even though I have looked into it. Doesn't it create layers that are not fully compatible with shapefiles?
– user3386170
Feb 15 at 15:38
@GabrielC. I don't understand the geopackage format even though I have looked into it. Doesn't it create layers that are not fully compatible with shapefiles?
– user3386170
Feb 15 at 15:38
@Erik I have created subselections when I ran into the problem but it is not ideal. I would rather find another solution (if possible).
– user3386170
Feb 15 at 15:39
@Erik I have created subselections when I ran into the problem but it is not ideal. I would rather find another solution (if possible).
– user3386170
Feb 15 at 15:39
2
2
What makes you think that GeoPackage is not compatible with shapefiles? It does lack many limitations of shapefiles, but all that you can save as shapefiles can also be stored into GeoPackage.
– user30184
Feb 15 at 15:43
What makes you think that GeoPackage is not compatible with shapefiles? It does lack many limitations of shapefiles, but all that you can save as shapefiles can also be stored into GeoPackage.
– user30184
Feb 15 at 15:43
add a comment |
2 Answers
2
active
oldest
votes
Officially, .shp and .dbf files are limited to 2GB. Using GDAL Shapefile driver this can be exceeded, but as stated on this site, this is not recommended due to compatibility issues (See point #Size Issues).
As @Gabriel C. already mentioned, geopackage is a good alternative. You could also use a SpatialLite or SQLite database.
answered Feb 15 at 15:39
MrXsquaredMrXsquared
1,7591618
add a comment |
You may have a look at this from ESRI : geoprocessing-considerations-for-shapefile-output.htm
specificaly the part on Geometry limitations:
There is a 2 GB size limit for any shapefile component file, which
translates to a maximum of roughly 70 million point features. The
actual number of line or polygon features you can store in a shapefile
depends on the number of vertices in each line or polygon (a vertex is
equivalent to a point).
Shapefile have many other limitations (short field name, no datetime format, 255 character field length limit, problem with null value....) that should motivate you to use other format. You could for exemple use geopackage or spatialite database (both are single file format that are comparable to ESRI file geodatabse, geopackage being a simplified spatialite base)
answered Feb 15 at 16:04
J.RJ.R
3,387222
add a comment |
Your Answer
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "79"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f312391%2fis-there-a-maximum-number-of-features-that-qgis-can-save-into-a-shapefile%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
Officially, .shp and .dbf files are limited to 2GB. Using GDAL Shapefile driver this can be exceeded, but as stated on this site, this is not recommended due to compatibility issues (See point #Size Issues).
As @Gabriel C. already mentioned, geopackage is a good alternative. You could also use a SpatialLite or SQLite database.
answered Feb 15 at 15:39
MrXsquaredMrXsquared
1,7591618
add a comment |
Officially, .shp and .dbf files are limited to 2GB. Using GDAL Shapefile driver this can be exceeded, but as stated on this site, this is not recommended due to compatibility issues (See point #Size Issues).
As @Gabriel C. already mentioned, geopackage is a good alternative. You could also use a SpatialLite or SQLite database.
answered Feb 15 at 15:39
MrXsquaredMrXsquared
1,7591618
add a comment |
Officially, .shp and .dbf files are limited to 2GB. Using GDAL Shapefile driver this can be exceeded, but as stated on this site, this is not recommended due to compatibility issues (See point #Size Issues).
As @Gabriel C. already mentioned, geopackage is a good alternative. You could also use a SpatialLite or SQLite database.
answered Feb 15 at 15:39
MrXsquaredMrXsquared
1,7591618
Officially, .shp and .dbf files are limited to 2GB. Using GDAL Shapefile driver this can be exceeded, but as stated on this site, this is not recommended due to compatibility issues (See point #Size Issues).
As @Gabriel C. already mentioned, geopackage is a good alternative. You could also use a SpatialLite or SQLite database.
answered Feb 15 at 15:39
MrXsquaredMrXsquared
1,7591618
answered Feb 15 at 15:39
MrXsquaredMrXsquared
1,7591618
answered Feb 15 at 15:39
MrXsquaredMrXsquared
1,7591618
answered Feb 15 at 15:39
MrXsquaredMrXsquared
1,7591618
1,7591618
add a comment |
add a comment |
You may have a look at this from ESRI : geoprocessing-considerations-for-shapefile-output.htm
specificaly the part on Geometry limitations:
There is a 2 GB size limit for any shapefile component file, which
translates to a maximum of roughly 70 million point features. The
actual number of line or polygon features you can store in a shapefile
depends on the number of vertices in each line or polygon (a vertex is
equivalent to a point).
Shapefile have many other limitations (short field name, no datetime format, 255 character field length limit, problem with null value....) that should motivate you to use other format. You could for exemple use geopackage or spatialite database (both are single file format that are comparable to ESRI file geodatabse, geopackage being a simplified spatialite base)
answered Feb 15 at 16:04
J.RJ.R
3,387222
add a comment |
You may have a look at this from ESRI : geoprocessing-considerations-for-shapefile-output.htm
specificaly the part on Geometry limitations:
There is a 2 GB size limit for any shapefile component file, which
translates to a maximum of roughly 70 million point features. The
actual number of line or polygon features you can store in a shapefile
depends on the number of vertices in each line or polygon (a vertex is
equivalent to a point).
Shapefile have many other limitations (short field name, no datetime format, 255 character field length limit, problem with null value....) that should motivate you to use other format. You could for exemple use geopackage or spatialite database (both are single file format that are comparable to ESRI file geodatabse, geopackage being a simplified spatialite base)
answered Feb 15 at 16:04
J.RJ.R
3,387222
add a comment |
You may have a look at this from ESRI : geoprocessing-considerations-for-shapefile-output.htm
specificaly the part on Geometry limitations:
There is a 2 GB size limit for any shapefile component file, which
translates to a maximum of roughly 70 million point features. The
actual number of line or polygon features you can store in a shapefile
depends on the number of vertices in each line or polygon (a vertex is
equivalent to a point).
Shapefile have many other limitations (short field name, no datetime format, 255 character field length limit, problem with null value....) that should motivate you to use other format. You could for exemple use geopackage or spatialite database (both are single file format that are comparable to ESRI file geodatabse, geopackage being a simplified spatialite base)
answered Feb 15 at 16:04
J.RJ.R
3,387222
You may have a look at this from ESRI : geoprocessing-considerations-for-shapefile-output.htm
specificaly the part on Geometry limitations:
There is a 2 GB size limit for any shapefile component file, which
translates to a maximum of roughly 70 million point features. The
actual number of line or polygon features you can store in a shapefile
depends on the number of vertices in each line or polygon (a vertex is
equivalent to a point).
Shapefile have many other limitations (short field name, no datetime format, 255 character field length limit, problem with null value....) that should motivate you to use other format. You could for exemple use geopackage or spatialite database (both are single file format that are comparable to ESRI file geodatabse, geopackage being a simplified spatialite base)
answered Feb 15 at 16:04
J.RJ.R
3,387222
answered Feb 15 at 16:04
J.RJ.R
3,387222
answered Feb 15 at 16:04
J.RJ.R
3,387222
answered Feb 15 at 16:04
J.RJ.R
3,387222
3,387222
add a comment |
add a comment |
Thanks for contributing an answer to Geographic Information Systems Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f312391%2fis-there-a-maximum-number-of-features-that-qgis-can-save-into-a-shapefile%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Could you create and save subselections of the data based on thematic or spatial criteria?
– Erik
Feb 15 at 15:15
1
Why not try the geopackage format?
– Gabriel C.
Feb 15 at 15:18
@GabrielC. I don't understand the geopackage format even though I have looked into it. Doesn't it create layers that are not fully compatible with shapefiles?
– user3386170
Feb 15 at 15:38
@Erik I have created subselections when I ran into the problem but it is not ideal. I would rather find another solution (if possible).
– user3386170
Feb 15 at 15:39
2
What makes you think that GeoPackage is not compatible with shapefiles? It does lack many limitations of shapefiles, but all that you can save as shapefiles can also be stored into GeoPackage.
– user30184
Feb 15 at 15:43