Skip to content

Latest commit

 

History

History
24 lines (18 loc) · 1.75 KB

README.md

File metadata and controls

24 lines (18 loc) · 1.75 KB

Lifecycle:Experimental

Spatial Data POC

This mini project is a POC that shows how to perform different tasks to manipulate or act on spatial geometry using the NetTopologySuite in-memory operations, PostgreSQL + PostGIS EF database operations.

Libraries Used

  • NetTopologySuite : This library is used in this project to perform GIS functions that are absent from SQL Server in-memory.
  • ProjNet : This library is used to perform Coordinate System Transformations (Reprojections).
  • NPGSQL : Consistes of 2 libraries that are used to perform EF database operations on a PostgreSQL DB with PostGIS. Full documenation on the library, it's usage and supported PostGIS functions can be found here

External Documentation/References

Getting Started

Assumes you have Visual Studio & Docker installed.

  • Fork & Clone the Repo
  • Execute the docker-compose in ./docker/postgis
  • Execute the scripts in ./ddl to create the required schema/table(s).
  • Open the solution and ensure the required libraries are installed.
  • You can rebuild the EF Context/Models with the following command Scaffold-DbContext -Connection "host=localhost;port=5432;database=gis;user id=docker;password=docker" -Provider Npgsql.EntityFrameworkCore.PostgreSQL -o Models -ContextDir Context -Context ScaffoldDbContext -Schemas gis_test -Force