Applying queries on large shape files

Dec 23, 2014 at 2:26 PM
Hello All,

Whenever I try to apply exclude queries on a large shape files (i.e., shape files with more than 50,000 features I get a OutOfMemoryException. I tried the same thing with DemoMap.exe and I got the same error.

All I do is, using the layer properties window, I exclude some of the features from the quantitative categorization. I think running the query causes the out of memory exception.

I don't know how to solve this.
Not sure if it helps, I copied part of the error message.

I would appreciate any suggestion.

ER


************** Exception Text **************
System.OutOfMemoryException: Array dimensions exceeded supported range.
at System.Collections.Generic.List1.set_Capacity(Int32 value)
at System.Collections.Generic.List
1.Add(T item)
at DotSpatial.Symbology.FeatureScheme.GetValues(DataTable table) in d:\Copyright\System Curve Generator\Vector Display\dotspatial-75229\Trunk\DotSpatial.Symbology\FeatureScheme.cs:line 504
at DotSpatial.Symbology.FeatureScheme.CreateCategories(DataTable table) in d:\Copyright\System Curve Generator\Vector Display\dotspatial-75229\Trunk\DotSpatial.Symbology\FeatureScheme.cs:line 279
at DotSpatial.Symbology.Forms.FeatureCategoryControl.RefreshValues() in d:\Copyright\System Curve Generator\Vector Display\dotspatial-75229\Trunk\DotSpatial.Symbology.Forms\FeatureCategoryControl.cs:line 713
at DotSpatial.Symbology.Forms.FeatureCategoryControl.ApplyExcludeExpression(String expression) in d:\Copyright\System Curve Generator\Vector Display\dotspatial-75229\Trunk\DotSpatial.Symbology.Forms\FeatureCategoryControl.cs:line 1653
at DotSpatial.Symbology.Forms.FeatureCategoryControl.ExpressionDialogChangesApplied(Object sender, EventArgs e) in d:\Copyright\System Curve Generator\Vector Display\dotspatial-75229\Trunk\DotSpatial.Symbology.Forms\FeatureCategoryControl.cs:line 1644
at DotSpatial.Symbology.Forms.SQLExpressionDialog.OnApplyChanges() in d:\Copyright\System Curve Generator\Vector Display\dotspatial-75229\Trunk\DotSpatial.Symbology.Forms\SQLExpressionDialog.cs:line 198
at DotSpatial.Symbology.Forms.SQLExpressionDialog.btnApply_Click(Object sender, EventArgs e) in d:\Copyright\System Curve Generator\Vector Display\dotspatial-75229\Trunk\DotSpatial.Symbology.Forms\SQLExpressionDialog.cs:line 175
at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ButtonBase.WndProc(Message& m)
at System.Windows.Forms.Button.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


************** Loaded Assemblies **************
mscorlib
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.18444 built by: FX451RTMGDR

CodeBase: file:///C:/Windows/Microsoft.NET/Framework64/v4.0.30319/mscorlib.dll

DemoMap
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0

CodeBase: file:///D:/Copyright/System%20Curve%20Generator/Vector%20Display/dotspatial-75229/Trunk/bin/Debug/DemoMap.exe

System.Windows.Forms
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.18408 built by: FX451RTMGREL

CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms/v4.0_4.0.0.0__b77a5c561934e089/System.Windows.Forms.dll

System.Drawing
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.18408 built by: FX451RTMGREL

CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Drawing/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll

System
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.34238 built by: FX452RTMGDR

CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll

DotSpatial.Controls
Assembly Version: 1.7.0.0
Win32 Version: 1.7.0.0

CodeBase: file:///D:/Copyright/System%20Curve%20Generator/Vector%20Display/dotspatial-75229/Trunk/bin/Debug/DotSpatial.Controls.DLL

System.Configuration
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.18408 built by: FX451RTMGREL

CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Configuration/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll

System.Xml
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.34234 built by: FX452RTMGDR

CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll

DotSpatial.Symbology
Assembly Version: 1.7.0.0
Win32 Version: 1.7.0.0

CodeBase: file:///D:/Copyright/System%20Curve%20Generator/Vector%20Display/dotspatial-75229/Trunk/bin/Debug/DotSpatial.Symbology.DLL

DotSpatial.Data
Assembly Version: 1.7.0.0
Win32 Version: 1.7.0.0

CodeBase: file:///D:/Copyright/System%20Curve%20Generator/Vector%20Display/dotspatial-75229/Trunk/bin/Debug/DotSpatial.Data.DLL

DotSpatial.Extensions
Assembly Version: 1.7.0.0
Win32 Version: 1.7.0.0

CodeBase: file:///D:/Copyright/System%20Curve%20Generator/Vector%20Display/dotspatial-75229/Trunk/bin/Debug/DotSpatial.Extensions.DLL

System.Core
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.18408 built by: FX451RTMGREL

CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Core/v4.0_4.0.0.0__b77a5c561934e089/System.Core.dll

DotSpatial.Topology
Assembly Version: 1.7.0.0
Win32 Version: 1.7.0.0

CodeBase: file:///D:/Copyright/System%20Curve%20Generator/Vector%20Display/dotspatial-75229/Trunk/bin/Debug/DotSpatial.Topology.DLL

Microsoft.GeneratedCode
Assembly Version: 1.0.0.0
Win32 Version: 4.0.30319.34234 built by: FX452RTMGDR

CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll

System.ComponentModel.Composition
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.18408

CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.ComponentModel.Composition/v4.0_4.0.0.0__b77a5c561934e089/System.ComponentModel.Composition.dll

DotSpatial.Mono
Assembly Version: 1.7.0.0
Win32 Version: 1.7.0.0

CodeBase: file:///D:/Copyright/System%20Curve%20Generator/Vector%20Display/dotspatial-75229/Trunk/bin/Debug/DotSpatial.Mono.DLL

Anonymously Hosted DynamicMethods Assembly
Assembly Version: 0.0.0.0
Win32 Version: 4.0.30319.18444 built by: FX451RTMGDR

CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_64/mscorlib/v4.0_4.0.0.0__b77a5c561934e089/mscorlib.dll

DotSpatial.Plugins.About
Assembly Version: 1.0.1185.0
Win32 Version: 1.0.1185

CodeBase: file:///D:/COPYRIGHT/SYSTEM%20CURVE%20GENERATOR/VECTOR%20DISPLAY/DOTSPATIAL-75229/TRUNK/BIN/DEBUG/PLUGINS/DOTSPATIAL.PLUGINS.ABOUT/DOTSPATIAL.PLUGINS.ABOUT.DLL

DotSpatial.Plugins.Contourer
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0

CodeBase: file:///D:/COPYRIGHT/SYSTEM%20CURVE%20GENERATOR/VECTOR%20DISPLAY/DOTSPATIAL-75229/TRUNK/BIN/DEBUG/PLUGINS/DOTSPATIAL.PLUGINS.CONTOURER/DOTSPATIAL.PLUGINS.CONTOURER.DLL

GeoAPI
Assembly Version: 1.7.1.0
Win32 Version: 1.7.1.0

CodeBase: file:///D:/COPYRIGHT/SYSTEM%20CURVE%20GENERATOR/VECTOR%20DISPLAY/DOTSPATIAL-75229/TRUNK/BIN/DEBUG/PLUGINS/DOTSPATIAL.PLUGINS.CONTOURER/GEOAPI.DLL

NetTopologySuite
Assembly Version: 1.13.1.0
Win32 Version: 1.13.1

CodeBase: file:///D:/COPYRIGHT/SYSTEM%20CURVE%20GENERATOR/VECTOR%20DISPLAY/DOTSPATIAL-75229/TRUNK/BIN/DEBUG/PLUGINS/DOTSPATIAL.PLUGINS.CONTOURER/NETTOPOLOGYSUITE.DLL

PowerCollections
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0

CodeBase: file:///D:/COPYRIGHT/SYSTEM%20CURVE%20GENERATOR/VECTOR%20DISPLAY/DOTSPATIAL-75229/TRUNK/BIN/DEBUG/PLUGINS/DOTSPATIAL.PLUGINS.CONTOURER/POWERCOLLECTIONS.DLL

TomControls
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0

CodeBase: file:///D:/COPYRIGHT/SYSTEM%20CURVE%20GENERATOR/VECTOR%20DISPLAY/DOTSPATIAL-75229/TRUNK/BIN/DEBUG/PLUGINS/DOTSPATIAL.PLUGINS.CONTOURER/TOMCONTROLS.DLL

DotSpatial.Plugins.FindFeature
Assembly Version: 1.0.1185.0
Win32 Version: 1.0.1185

CodeBase: file:///D:/COPYRIGHT/SYSTEM%20CURVE%20GENERATOR/VECTOR%20DISPLAY/DOTSPATIAL-75229/TRUNK/BIN/DEBUG/PLUGINS/DOTSPATIAL.PLUGINS.FINDFEATURE/DOTSPATIAL.PLUGINS.FINDFEATURE.DLL

DotSpatial.Plugins.Help
Assembly Version: 1.0.1185.0
Win32 Version: 1.0.1185

CodeBase: file:///D:/COPYRIGHT/SYSTEM%20CURVE%20GENERATOR/VECTOR%20DISPLAY/DOTSPATIAL-75229/TRUNK/BIN/DEBUG/PLUGINS/DOTSPATIAL.PLUGINS.HELP/DOTSPATIAL.PLUGINS.HELP.DLL

DotSpatial.Plugins.Measure
Assembly Version: 1.0.1185.0
Win32 Version: 1.0.1185
CodeBase: file:///D:/COPYRIGHT/SYSTEM%20CURVE%20GENERATOR/VECTOR%20DISPLAY/DOTSPATIAL-75229/TRUNK/BIN/DEBUG/PLUGINS/DOTSPATIAL.PLUGINS.MEASURE/DOTSPATIAL.PLUGINS.MEASURE.DLL
Dec 23, 2014 at 2:40 PM
Just want to add that the same query work to select from attribute table!