week 1 - spatial data

Question 1

4 reasons why spatial data is different

Answer 1

1) very tied to the physical space
2) Multi-dimensional
3) Complex geometric shapes (like county)
4) New query API

Question 2

How are spatial data sets primarily referenced?

1)Through a SQL query in a relational database.
2) Through a direct or indirect reference to a location on the Earth.
3)Through a data set consisting of numbers and characters.
Skip

Answer 2

2) Through a direct or indirect reference to a location on the Earth.

Question 3

What is a Range Query (spatial data)

Answer 3

represented at shape (only returns items within the shape)

Question 4

When do applications use spatial range queries?

1) For determining numbers within a range
2) For a restaurant search within a certain area.
3) For finding the most number of views on a social post.

Answer 4

2) For a restaurant search within a certain area.

Question 5

KNN Query (spatial data)

Answer 5

Closest neighbor ( K Nearest Neighbor )

Question 6

What is the Postgres extension for spatial data

Answer 6

PostGIS - new data types (geom) CONTAINS

Question 7

How is geospatial data stored in an SQL server?

1) Data as keys for other tables.
2) As data on a coordinate system.
3) Data as a string of characters.

Answer 7

2) As data on a coordinate system.