SQL for spreading overlapping geo locations (cartodb)
- or -
Post a project like this2761
$30
- Posted:
- Proposals: 2
- Remote
- #1271744
- PRE-FUNDED
- Awarded
Description
Experience Level: Expert
General information for the business: Maps
Database management system (DBMS): PostgreSQL
Description of requirements/functionality: I'm working on a map with the birth place of all nobel laureates. As I only have the birth place on city level, there are a lot of overlapping points that I'm trying to find a way to spread instead of the way it is now (hidden behind a marker that spiderfies).
http://s3.mapfact.com/society/all-nobel-prize-laureates/
Can anybody help with some database work so I get a file where the overlapping markers are distributed instead of having the exact same lat/lon?
It's something like: Identify rows with the same lat/lng in the_geom column and add a few points to the values so the markers are not 100% overlapping.
It can be done this way, but it's far too advanced for me: http://bl.ocks.org/andrewxhill/raw/8695515/#
Extra notes:
Database management system (DBMS): PostgreSQL
Description of requirements/functionality: I'm working on a map with the birth place of all nobel laureates. As I only have the birth place on city level, there are a lot of overlapping points that I'm trying to find a way to spread instead of the way it is now (hidden behind a marker that spiderfies).
http://s3.mapfact.com/society/all-nobel-prize-laureates/
Can anybody help with some database work so I get a file where the overlapping markers are distributed instead of having the exact same lat/lon?
It's something like: Identify rows with the same lat/lng in the_geom column and add a few points to the values so the markers are not 100% overlapping.
It can be done this way, but it's far too advanced for me: http://bl.ocks.org/andrewxhill/raw/8695515/#
Extra notes:
Jesper N.
100% (2)Projects Completed
7
Freelancers worked with
6
Projects awarded
56%
Last project
30 May 2017
Germany
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hello Jesper,
I was able to finish this task but I can't send proposal is this offer still valid.
JK
135543
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies