Project

General

Profile

Feature #1432

latitude and longtitude based

Added by Tab Tu about 6 years ago. Updated about 6 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Tab Tu
Start date:
2019-08-22
Due date:
2019-09-29
% Done:

100%

Estimated time:
(Total: 0.00 h)
Spent time:
(Total: 225.00 h)

Description

Calculate Latitude and Longtitude which is in the range.
Only can be used for square and circle searching.
Algorithm based on Latitude and Longtitude

Subtasks

Task #44: get the minium and maxium GEO(lantitude and longtitude), and select rows in this rangeClosedTab Tu2019-08-222019-09-29

Actions
Issue #83: only can search circle or rectangular shapes. can not search rotating rectangular.ClosedTab Tu2019-09-082019-09-13

Actions
Issue #84: search algorithm is too slow, 1500+ ms per task in 300,000 rows in average. Solved by adding index to lantitude and longtitude.ClosedTab Tu2019-08-272019-09-01

Actions
Issue #85: use 4 points to define a rectangular, unnessessary and ambiguous. Solve by use southwest and northeast points(2 points) instead of 4.ClosedTab Tu2019-09-112019-09-21

Actions
Issue #86: area shape is limited. will optimize on next statge. ClosedTab Tu2019-09-222019-09-29

Actions

Also available in: Atom PDF