Georef Database

[Bráulio Bhavamitra]

In sniffer a simple SQL query was used to calculate distance:
https://github.com/ESCAMBO/noosfero-ecosol/blob/master/plugins/sniffer/lib/ext/product.rb#L14

In the solr plugin, the solr's own engine is used to calculate distance and
order them.

In profile's location setting, Google's api is used to get the correponding
lat/lng from the address typed or the map position. There is a kind of a
javascript API for this. As daniel said, this is for now much better than
the solution proposed by aurium.

regards,
bráulio




On Mon, Jan 27, 2014 at 2:14 PM, daniel tygel <dtygel at eita.org.br> wrote:

> I talked about this some years ago: unfortunately, the goenames database
> is much poorer than the google maps geocoding, which is also a free API
> open for consultation.
>
> The "sniffer" in fbes.org.br was built using the geocoder, and it worked
> quite well. The solution we made (as EITA) for localization, which is
> already available, checks this API and gives far better results for lat/lng
> than geonames. The user don't need to write the whole address. If he/she
> gives only the city of zip code, the icon will be close enough to the
> target.
>
> So I think it would be better to make the actual localization better than
> to use the geonames server. I studied it a lot, and it was really bad for
> Brazil (it only worked 100% for USA, and fairly well for Europe, but was
> terrible for latin america).
>
> I don't know if our localization solution is already integrated in
> noosfero. Maybe Braulio can tell us here. In Cirandas, it's already
> working, and the user doesn't need to do anything besides writing freely
> his/her address.
>
> daniel
>
> Em 27-01-2014 14:20, "Aurélio A. Heckert" escreveu:
>
>  Hi all,
>>
>> We have a great interest in georef, and that is a lot more important to
>> EcoSol enterprises, but we still not using it very well.
>>
>> We rely so much on user to set its own lat/lng on the map, but that does
>> not happens. We can think on UI to make that better, but we must not expect
>> 100%. In the other hand, it is easy to fill city and country.
>>
>> For some geo search/filtering we don't need the exact location, so giving
>> the city lat/lng to the profile will help us to do a nice job.
>>
>> So, i found this:
>> http://www.geonames.org/export/
>> This is a cool CSV database of cities with name variation (helping the
>> search) country, georef and more, in CC-by.
>>
>> We can write a rake command to download the last allCountries.zip file
>> and fill or update the region related models, extended with the extra
>> useful data from this CSV.
>>
>> Please, write spec ideas here:
>> http://noosfero.org/Development/ActionItem2970
>> Also visit this pag to see more data. ;-)
>>
>> Hasta!
>> Aurium
>> _______________________________________________
>> Noosfero-dev mailing list
>> Noosfero-dev at listas.softwarelivre.org
>> http://listas.softwarelivre.org/cgi-bin/mailman/listinfo/noosfero-dev
>>
>>
> --
> (_.-~*´¨¯¨`*·~-.,-( •_•)-,.-~*´¨¯¨`*·~-._)
>           .
>     ,-. . |- ,-.          Educação,
>     |-' | |  ,-|          Informação e
>     `-' ' `' `-^          Tecnologia para
>  http://eita.org.br       Autogestão
>
> (_.-~*´¨¯¨`*·~-.,-( •_•)-,.-~*´¨¯¨`*·~-._)
>
>
> _______________________________________________
> Noosfero-dev mailing list
> Noosfero-dev at listas.softwarelivre.org
> http://listas.softwarelivre.org/cgi-bin/mailman/listinfo/noosfero-dev
>



-- 
"Lute pela sua ideologia. Seja um com sua ideologia. Viva pela sua
ideologia. Morra por sua ideologia" P.R. Sarkar

EITA - Educação, Informação e Tecnologias para Autogestão
http://cirandas.net/brauliobo
http://eita.org.br

"Paramapurusha é meu pai e Parama Prakriti é minha mãe. O universo é meu
lar e todos nós somos cidadãos deste cosmo. Este universo é a imaginação da
Mente Macrocósmica, e todas as entidades estão sendo criadas, preservadas e
destruídas nas fases de extroversão e introversão do fluxo imaginativo
cósmico. No âmbito pessoal, quando uma pessoa imagina algo em sua mente,
naquele momento, essa pessoa é a única proprietária daquilo que ela
imagina, e ninguém mais. Quando um ser humano criado mentalmente caminha
por um milharal também imaginado, a pessoa imaginada não é a propriedade
desse milharal, pois ele pertence ao indivíduo que o está imaginando. Este
universo foi criado na imaginação de Brahma, a Entidade Suprema, por isso
a propriedade deste universo é de Brahma, e não dos microcosmos que também
foram criados pela imaginação de Brahma. Nenhuma propriedade deste mundo,
mutável ou imutável, pertence a um indivíduo em particular; tudo é o
patrimônio comum de todos."
Restante do texto em
http://cirandas.net/brauliobo/blog/a-problematica-de-hoje-em-dia
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listas.softwarelivre.org/pipermail/noosfero-dev/attachments/20140131/4db7fdbf/attachment-0001.html>