Talk:Main Page
From Wikiteer
(Difference between revisions)
Line 1: | Line 1: | ||
Regarding "Proprietary stuff", GMap looks to be GPL, not proprietary. | Regarding "Proprietary stuff", GMap looks to be GPL, not proprietary. | ||
+ | |||
+ | select rte.name, count(*) as c from rte, rtept as a, rtept as b where rte.id=a.parent and a.parent=b.parent and b.seq=a.seq+1 and ((a.lat<=@lat and b.lat>=@lat) or (a.lat>=@lat and b.lat<=@lat)) and (a.lon<@lon or b.lon<@lon) group by rte.name having mod(c,2); |
Revision as of 19:57, 19 November 2006
Regarding "Proprietary stuff", GMap looks to be GPL, not proprietary.
select rte.name, count(*) as c from rte, rtept as a, rtept as b where rte.id=a.parent and a.parent=b.parent and b.seq=a.seq+1 and ((a.lat<=@lat and b.lat>=@lat) or (a.lat>=@lat and b.lat<=@lat)) and (a.lon<@lon or b.lon<@lon) group by rte.name having mod(c,2);