DataBase Research

## DataBase Research:

option 1:

Loading GeoJSON data into SQL server - using OPENJSON function allows converting JSON data to rows and columns in SQL Server (2016) and Azure SQL Database.

Example for how to use it, and what are the benefits with GeoJSON can be found here.

option 2:

PostGis - open source extension for PostgreSQL, gives support for geographic objects and allowing location queries to be run in SQL. More information and documentation about PostGis can be found in: http://postgis.net/