I have large table in a MS database. The table alone has 57GB... holding 18 million features.
The table has a primary clustered key and a spatial index based on its 'Shape' attribute.
The spatial index was generated with the following statement
USE Contours_MSSpatial
CREATE SPATIAL INDEX SIndex_Contours_Shape
ON Contours(Shape)
USING GEOMETRY_GRID
WITH (
BOUNDING_BOX = (xmin = 440000, ymin = 6050000, xmax = 920000, ymax =6403000),
GRIDS = (LOW, LOW, MEDIUM, HIGH),
CELLS_PER_OBJECT = 32,
PAD_INDEX = ON
);
GO
The data are in EPSG:25832 and I can get the layer into the map, but there is only a fraction of the data loaded before it stops loading.
It takes a while, but in QGIS at least the data are loading. This way I was able to confirm that the data to be shown are actually correct. The spatial index might be the culprit but why does ArcGIS Pro stop reading the data in?
- We are living in the 21st century.
GIS moved on and nobody needs a format consisting out of at least three files! No, nobody needs shapefiles, not even for the sake of an exchange format. Folks, use GeoPackage to exchange data with other GIS!
