Importing and finding coordinates in a map from geospatial data.

gistfile1.txt

- download qgis from https://qgis.org/en/site/
- C:\Program Files\QGIS 3.22.6\bin> ogr2ogr -progress -f "MSSQLSpatial" "MSSQL:server=DESKTOP-HE9GCV7;database=Sandbox;uid=sa;pwd=admin" "C:\Users\theUser\Downloads\NepalLocalUnits0_2022_April_29_10_05_55\NepalLocalUnits0\NepalLocalUnits0.shp" -a_srs "EPSG:4326" -lco PRECISION=NO
- in sql server
SELECT *
FROM nepallocalunits0
WHERE ogr_geometry.STContains(
  geometry::STGeomFromText('POINT(87.9909718 26.6401384)', 4326)
) = 1;