SQuan.Helpers.SQLite.Spatial
10.0.10
dotnet add package SQuan.Helpers.SQLite.Spatial --version 10.0.10
NuGet\Install-Package SQuan.Helpers.SQLite.Spatial -Version 10.0.10
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package.
<PackageReference Include="SQuan.Helpers.SQLite.Spatial" Version="10.0.10" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
<PackageVersion Include="SQuan.Helpers.SQLite.Spatial" Version="10.0.10" />
<PackageReference Include="SQuan.Helpers.SQLite.Spatial" />
For projects that support Central Package Management (CPM), copy this XML node into the solution Directory.Packages.props file to version the package.
paket add SQuan.Helpers.SQLite.Spatial --version 10.0.10
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: SQuan.Helpers.SQLite.Spatial, 10.0.10"
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package.
#:package SQuan.Helpers.SQLite.Spatial@10.0.10
#:package directive can be used in C# file-based apps starting in .NET 10 preview 4. Copy this into a .cs file before any lines of code to reference the package.
#addin nuget:?package=SQuan.Helpers.SQLite.Spatial&version=10.0.10
#tool nuget:?package=SQuan.Helpers.SQLite.Spatial&version=10.0.10
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
SQuan.Helpers.SQLite.Spatial
The SQuan.Helpers.SQLite.Spatial brings together sqlite-net-pcl and NetTopologySuite to enable spatial capabilities in SQLite for .NET applications. It uses WKT (Well-Known Text) as the geometry format, allowing spatial data to store in text columns. Its spatial functions are loosely inspired by those in PostGIS.
Namespace
using SQuan.Helpers.SQLite.Spatial;
Example
// Create an in-memory SQLite database with spatial support.
SQLiteSpatialConnection db = new(":memory:");
// Example spatial queries
double area_50_units = db.ExecuteScalar<double>("SELECT ST_Area('POLYGON((10 10,20 10,20 20,10 10))')");
string? centroid_at_5_5 = db.ExecuteScalar<string>("SELECT ST_Centroid('POLYGON ((0 0, 0 10, 10 10, 10 0, 0 0))')");
string? circle_buffer = db.ExecuteScalar<string>("SELECT ST_Buffer('POINT(10 10)', 5)");
double? distance_5_units = db.ExecuteScalar<double?>("SELECT ST_Distance('POINT(0 0)', 'POINT(3 4)')");
double? area_100_units = db.ExecuteScalar<double?>("SELECT ST_Area(ST_Envelope(ST_Buffer('POINT(10 10)', 5)))");
// Retrieve cities in order of distance, starting with those nearest to Los Angeles.
var results = db.Query<SpatialData>("SELECT * FROM UsaCities ORDER BY ST_Distance(Geometry, 'POINT(-118.243683 34.052235)')");
foreach (var result in results)
{
System.Diagnostics.Trace.WriteLine("City: " + result.Name);
}
Further information
For more information please visit:
- Documentation: https://github.com/stephenquan/SQuan.Helpers/wiki/SQLite.Spatial
- GitHub repository: https://github.com/stephenquan/SQuan.Helpers
| Product | Versions Compatible and additional computed target framework versions. |
|---|---|
| .NET | net5.0 was computed. net5.0-windows was computed. net6.0 was computed. net6.0-android was computed. net6.0-ios was computed. net6.0-maccatalyst was computed. net6.0-macos was computed. net6.0-tvos was computed. net6.0-windows was computed. net7.0 was computed. net7.0-android was computed. net7.0-ios was computed. net7.0-maccatalyst was computed. net7.0-macos was computed. net7.0-tvos was computed. net7.0-windows was computed. net8.0 was computed. net8.0-android was computed. net8.0-browser was computed. net8.0-ios was computed. net8.0-maccatalyst was computed. net8.0-macos was computed. net8.0-tvos was computed. net8.0-windows was computed. net9.0 was computed. net9.0-android was computed. net9.0-browser was computed. net9.0-ios was computed. net9.0-maccatalyst was computed. net9.0-macos was computed. net9.0-tvos was computed. net9.0-windows was computed. net10.0 was computed. net10.0-android was computed. net10.0-browser was computed. net10.0-ios was computed. net10.0-maccatalyst was computed. net10.0-macos was computed. net10.0-tvos was computed. net10.0-windows was computed. |
| .NET Core | netcoreapp2.0 was computed. netcoreapp2.1 was computed. netcoreapp2.2 was computed. netcoreapp3.0 was computed. netcoreapp3.1 was computed. |
| .NET Standard | netstandard2.0 is compatible. netstandard2.1 was computed. |
| .NET Framework | net461 was computed. net462 was computed. net463 was computed. net47 was computed. net471 was computed. net472 was computed. net48 was computed. net481 was computed. |
| MonoAndroid | monoandroid was computed. |
| MonoMac | monomac was computed. |
| MonoTouch | monotouch was computed. |
| Tizen | tizen40 was computed. tizen60 was computed. |
| Xamarin.iOS | xamarinios was computed. |
| Xamarin.Mac | xamarinmac was computed. |
| Xamarin.TVOS | xamarintvos was computed. |
| Xamarin.WatchOS | xamarinwatchos was computed. |
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.
-
.NETStandard 2.0
- NetTopologySuite (>= 2.6.0)
- ProjNET (>= 2.1.0)
- sqlite-net-pcl (>= 1.9.172)
- System.Runtime.Caching (>= 9.0.10)
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.