TRAC-Facts-Figures-DatašŸ”“

@MarcoDavoli I would like to have access to the sheet. I track my numbers through the emails I got regarding sent roads and approved roads.
Maybe those numbers are helpful for this exercise.

A good question @tony_b since I don’t participate in TRAC and don’t do many road edits, but all kind of edits occasionally, I don’t know how useful my approach might be for the TRAC project.

My main objective is to understand which of my edits are still pending or got rejected. Besides that, it gives me a static list of all my edits, their status (pending, accepted, rejected) and for some of them also the number of views, while avoiding to enter date and type of edit manually.

As a side effect, I also notice name changes, which is specially interesting, if a listing turns into an ā€œunknown placeā€. This doesn’t really matter for edits, but very likely I also posted photos and/or a review for the same place.

For places, we added and some other types of edits, we also see the number of views. Interesting that those numbers can be up to ten times more than the banner photo.

But as I said above, it is not a ready-to-use solution. It works for me and probably everybody else needs some effort to get it working.

Alright on it

Congratulations on that 60%@khmansour1. I’ve been as low as 3% in recent months, but it has been rising in the last week approximately, reaching 16% and then dipping again to 13%.

What’s your secret? Where are you drawing roads mostly?

Hey, @SholaIB could you please tell me why my approved roads are shown as 0 here??

Hello @MasumKazi

Please get in touch with @MarcoDavoli .

Thanks

Hi,

My secret is short edits. specialy when I face shadow, trees, changing in the color. and about two hours daily. in addition I use java scripts tools developed by one of the members.

I use keyboards shortcuts for example when in press 1 ā€œadd new roadā€ when I press 2 ā€œlocal road will be selectedā€ when I press 3 I submit the edit and the page open again automatically in edit mode so I add another road. I submit daily about 150 edits!

Regards,

You miss my name @SholaIB but it is ok.Thanks for informing details.

@Supriyadevkar

Thank you for letting me know. Next time, I’ll try to include yours.

Happy guiding

Cheers

Hi @WilfriedB
Hi @tony_b ,

In addition its the era of AI and computer science. Its makes our live easier. I found happiness dealing with AI and I learning new things specialty python and JavaScript.

Life and dealing with roads edit force me to learn and deal with AI. Can you believe that @MarcoDavoli developed a website for gathering our data and building statistics and charts with zero knowledge in programming! WAW MaShaAllah.:clap::tada::heart:

P.S
I am working on a new script but current AI mislead me ā€œall AIā€ and according to an advise I will use deepseek for programming tasks.

Regards

Hi @WilfriedB, @tony_b, and @MarcoDavoli,

I wanted to share some exciting results using DeepSeek to analyze my contribution data. By feeding the AI my contribution HTML (copied via Chrome Developer Tools), it generated a CSV file that allowed me to create this pivot table in Excel:

Count of Date Column Labels
Row Labels Accepted (1) Not accepted (1) Pending (1) Grand Total
Mar-29 156 156
Mar-28 96 14 22 132
Mar-27 91 9 57 157
Grand Total 187 23 235 445

I will share the Python script I used for this extraction below. To run it, you will need to have Python installed along with the libraries mentioned in the import statements (pyperclip, beautifulsoup4, and lxml) using pip command.

Best Wishes.
Khalid.

Hi,

Date Accepted Not accepted Pending Grand Total
3-17 62 7 16 85
3-18 35 16 35 86
3-19 58 9 19 86
3-20 19 10 29 58
3-21 66 9 20 95
3-22 44 8 22 74
3-23 86 15 18 119
3-24 57 11 13 81
3-25 116 20 31 167
3-26 76 10 24 110
3-27 91 9 57 157
3-28 96 14 22 132
Total 806 138 306 1250

Regards,

@SholaIB thanks for mentioning me. This is a great initiative to better understand road draw and approval rates by tracking data. I am interested and would like to be a part of it.

Hello @MarcoDavoli

Please kindly grant @AbdusSattar access to the sheet for tracking roads.

Thank you

Cheers

It’s ok but now my name is active in the list of TRAC so I am waiting for next list highlights and definitely my name is their :grinning_face_with_smiling_eyes: @SholaIB

I am still far behind everyone. I am still struggling to get a road approved. I need some training, @SholaIB.

Hi everyone specially @MarcoDavoli :heart:

I’ve developed a Python script to help extract our contributions from Google Maps. You can find the code and details in this GitHub Gist:

Quick Setup & Usage:

  1. Prerequisites: Ensure Python is installed, then install the required libraries via pip.

  2. Scroll: Scroll through your contributions on Google Maps to load them (or use an auto-scroll 1. tool).

  3. Inspect: Press F12 to open Developer Tools and use the Inspect tool to locate the main contributions area.

  4. Copy: Right-click the <div element and select Copy → Copy outerHTML.

  5. Run: Execute the script, and it will generate a CSV file with your data.

I understand these steps might be a bit technical for some and this is the video explain the steps.

Best regards,

Thank you for sharing @khmansour1.

I added some notes as a comment in the GitHub-Gist.

CC @MarcoDavoli

Hello @SoniaK

That’s ok. We all started that way. Don’t worry we will have to chat in private. Thank you for speaking up.

Cheers

Is there any update on this initiative @SholaIB @MarcoDavoli ?
Despite the many complaints, I note that the spreadsheet has only 13 names, of which 10 have entered significant data, and only 5 are up to date. It would need a lot more than this to present a compelling case to Google.