LibreOffice contributors on a map

Hi,

We at the de-discuss list thought it would be a good idea to have everyone contributing to LibO on one map, filterable by skills etc.

=> Do you like the idea?

I do not want any discussion about Open Source vs Closed source or NSA vs German Server or, which is likely more important, Google Maps vs OSM....
Nevertheless I will refer to the solutions created by Robert G. and myself as OSM and GMaps....

OSM: http://robert.familiegrosskopf.de/map/map.html
GMaps: http://florei-libo.115.at/DE/map/ [The ads are, because it is a free web server]

As my solution is the GMaps solution I will point out the positive things of this solution and the negative things of OSM:
== GMaps ==
+Easy to use API
+Looks clean
+Good look and feel on tablets
+Can use name and city as location ("Hamburg, Deutschland") [Also local names as you see here]
== OSM ==
-No gestures on tablets
-Need to search for the coordinates somewhere
[Cannot tell about the API, as I did the other]

=> Please comment here for other advantages or disadvantages, please make sure to have a llook at it on a tablet as this is the big downsiode of OSM IMHO

=> Please comment which skills we should list
=> Should we list the different languages

There are three use-cases:
1) Display the UI for the user
2) Add data to MySQL table
3) Make sure data is up-to-date

If we do GMaps, I will do the best for the UI part, but I need help to set up a JS-array from a MySQL-table... If we do OSM, I likely won't do it, but feel free to choose OSM

=> Anyone helping with use-cases?

=> Any further comments?

[Heading to football game now]

Hello Florian, Robert,

I like the idea. I suppose it is not difficult to register oneself? It is a good marketing tool if properly used.

Cheers,

Charles.

Hi Florian, Robert,

Hi,

We at the de-discuss list thought it would be a good idea to have
everyone contributing to LibO on one map, filterable by skills etc.

=> Do you like the idea?

Thanks for posting here and as you know I like it very much :slight_smile:

I do not want any discussion about Open Source vs Closed source or NSA
vs German Server or, which is likely more important, Google Maps vs OSM....
Nevertheless I will refer to the solutions created by Robert G. and
myself as OSM and GMaps....

OSM: http://robert.familiegrosskopf.de/map/map.html
GMaps: http://florei-libo.115.at/DE/map/ [The ads are, because it is a
free web server]

As my solution is the GMaps solution I will point out the positive
things of this solution and the negative things of OSM:
== GMaps ==
+Easy to use API
+Looks clean
+Good look and feel on tablets
+Can use name and city as location ("Hamburg, Deutschland") [Also local
names as you see here]
== OSM ==
-No gestures on tablets
-Need to search for the coordinates somewhere
[Cannot tell about the API, as I did the other]

=> Please comment here for other advantages or disadvantages, please
make sure to have a llook at it on a tablet as this is the big downsiode
of OSM IMHO

=> Please comment which skills we should list

all the skills represented in the projects Dev, QA, l10n, Infra,
Website, Doc, Marketing, Support and whatever I forget

=> Should we list the different languages

no, as we are showing countries, we should avoid pointing languages.

There are three use-cases:
1) Display the UI for the user
2) Add data to MySQL table
3) Make sure data is up-to-date

If we do GMaps, I will do the best for the UI part, but I need help to
set up a JS-array from a MySQL-table... If we do OSM, I likely won't do
it, but feel free to choose OSM

=> Anyone helping with use-cases?

=> Any further comments?

May be later. Again, thanks a lot to both of you :slight_smile:

Cheers
Sophie

Hi,

As you see in the bottom of my initial mail managing and keeping the database up to date (use case 2,3) and getting the data into a JS variable (part of 1) I am lacking skills....

So help appriciated... (No JS reqired, just MySQL, PHP and HTML)
And the biggest question in my opinion is: How to update stuff? Do you need a password or shall we work with a submit form and do editing manually.... Should be review the submit form etc....

So for the database work I would need some help, I do not know how the database design should work, but finding some people which help here might be good ^^

@all: OSM or GMaps? Anyone with a helping hand?

Liebe Grüße, / Yours,
Florian Reisinger

Hi,

As you see in the bottom of my initial mail managing and keeping the database up to date (use case 2,3) and getting the data into a JS variable (part of 1) I am lacking skills....

So help appriciated... (No JS reqired, just MySQL, PHP and HTML)
And the biggest question in my opinion is: How to update stuff? Do you need a password or shall we work with a submit form and do editing manually.... Should be review the submit form etc....

Let's see... so we have some geo-information about the US/Canada people here:
https://wiki.documentfoundation.org/Marketing/US/Members

That page uses a pretty consistent format that could be scraped and
translated into lat/long coords. We could expand into as many other
countries as you like.

I would suggest that people not add their full personal addresses to a
public resource, or even to a private db that pumps out precise GPS
coords, just for privacy considerations. For the US list we have City
(or region) and State, and I think that's probably going to give us
accurate-enough points to place on a map.

So for the database work I would need some help, I do not know how the database design should work, but finding some people which help here might be good ^^

@all: OSM or GMaps? Anyone with a helping hand?

If a lightweight solution like TDF Wiki + scraper + OSM overlay sounds
good, I might know a couple of people who could help out with that.

Cheers,
--R