Some Prerequisite Knowledge About Spatial Data

Image for post
Image for post

Spatial Data Types:

Two kinds of spatial data types:

  • geography: uses the same methods but the data type reflects the fact the we live on a curved 2D surface.

SRID:

Both geometry and geography data types have two parts, the coordinates of the object and the SRID number

Geography::Point(Latitude,Longitude,SRID);

An example:

Here is a link of my Github of stored procedure, which aims to get the nearest suburb for each public transport stop:

SET @geo1=geography::Point(@stationlat,@stationlong,4326);

Written by

A current Data Analyst in a subsidiary under Webjet, with experience in applying data science techniques to business.

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store