Freelancer or equivalent freelance coder experience anyone?

[jon-nyc]

I have a one-time, very self-contained coding project that I need to have done for the foundation.

I had vaguely heard of task rabbit but that is for household handyman type stuff. 5 seconds of googling for a coding-equivalent landed me on freelance.com.

Does anyone have any experience with this or a similar site?

[jon-nyc]

Hmmm... An alternative question:

This project would probably take the right person 15-20m to complete. Maybe less with chatGPT.

Any coders wish to donate some time to the Alpha-1 Foundation? I can describe what we're looking for. It's a simple python script that interacts with a google or bing maps API and produces a CSV file as output.

[LuFins Dad]

@jon-nyc said in Freelancer or equivalent experience anyone?:

I have a one-time, very self-contained coding project that I need to have done for the foundation.

I had vaguely heard of task rabbit but that is for household handyman type stuff. 5 seconds of googling for a coding-equivalent landed me on freelance.com.

Does anyone have any experience with this or a similar site?

I’ll do it for whatever Copper charges me to do it plus Luke’s outstanding tuition..

[Mik]

Can you describe the project in more detail, like platform, language, end goal? It would probably not be me, but I know some folks. I’d bet Klaus does too.

[Copper]

I might have had a brief look at Python 10 or more years ago.
I have worked with Bing Maps, but with C# not connected with Google.

Here is a screen print I just took of a C# Bing Maps App I built many long years ago.

I think Klaus is your guy, a class project maybe.

[Horace]

I guess learning the API would be the majority of the work.

[jon-nyc]

Sure, a script that would take as input a list of cities/towns. It would create a grid (well, CSV file) that would contain the driving distance between each unique pairing of cities.

e.g. input of:
"New York, NY, Chicago, IL, Los Angeles CA"

Would produce the following table:
0, 789, 2794
789, 0, 2020
2794,2020,0

But in practice there would be ~5-600 inputs.

[jon-nyc]

@Horace said in Freelancer or equivalent experience anyone?:

I guess learning the API would be the majority of the work.

True, but that's where chatGPT might accelerate things.

[Horace]

Jon I bet you can do this yourself.

[jon-nyc]

You might be curious why this is useful to the foundation.

We maintain a network of certified care centers, physicians known to us who are knowledgable in our rare disease. Historically, we've expanded the program passively, we've waited for physicians to apply for inclusion in our program.

THis, as you might image, has led to huge geographic disparities in the availability of care. You can look at a map and see where our gaps are, but to really see the impact of gaps, you need a population weighting.

The US census defines Metropolitan and Micropolitan Statistical Areas that, combined, account for about 96% of the US population. They track of the population in each of these areas.

With the grid I described above, using the 5-600 areas defined, we could start measuring the percentage of the country that lives within X miles of a care center. That information would allow us to proactively expand our network by recruiting physicians, in the most impactful way possible. Also, having this grid as a CSV file would allow me to import it into an excel sheet, so that when we do add a new center it would automatically compute the distances from that center to every other statistical area, and we could automatically re-calculate the percentage of the population living within X miles from a center. In other words, getting this in Excel allows existing foundation staff to maintain this in an ingoing fashion.

It's also part of an initiative we've kicked off trying to measure the impact of our various programs. It's easy to say "We have 85 care centers" but that measures inputs not impact. If we can say, for example, "65% of the country lives within 100 miles of a care center and 80% live within 200" that tells us the impact the program is having. It would also allow us to figure out where to recruit to get that number as high as possible.

[jon-nyc]

@Horace said in Freelancer or equivalent experience anyone?:

Jon I bet you can do this yourself.

I could and I considered it. I played with python 6-8 years ago. But I finally decided I'd rather have it more quickly than that, and that there's other things I could do for the foundation with that time that would be more impactful.

I also thought there are people who could do this in minutes. It would take me days. (though I admit it would be a fun learning process)

[Copper]

a couple examples, fun stuff

https://towardsdatascience.com/driving-distance-between-two-or-more-places-in-python-89779d691def

https://webapps.stackexchange.com/questions/16757/function-to-find-distance-between-cities

[Axtremus]

"Google Maps API developer" may be the right keywords to search for. Good luck.

[kluurs]

I may have someone. Let me check if he's free.

[89th]

@jon-nyc

I played with python 6-8 years ago.

Umm more recently based on my zoom in of your Napoli room.

[89th]

I recall this care-distance/map topic a few months ago btw.