Wikipedia:WikiProject Andhra Pradesh/Notes/Arjunaraoc/Revising Guntur city article

I am familiar with Guntur and wanted to improve the article, based on my experience with state(Andhra Pradesh) article, few district articles of Andhra Pradesh earlier. I took about a week of focussed work of 4-5 hours per day to improve the article starting from 2024-03-10 (article on start date, 99121 bytes) and ending on 2024-03-18 (article after revision, 87,426 bytes) I have made 254 total edits with 201 minor edits(79.1%) adding 18,067 bytes. There were 178 individual references before the revision, compared to 133 (113 unnamed, 17 named) after the revision. The article has 500+ page views daily.

Authorship

As on 2024-03-18

Authorship attribution, measured by character count, excluding spaces
Ranks, Username, Links, Characters, Percentage
1 	Vin09 	Top Edits · Edit Counter 	22,270 	27.5%
2 	Arjunaraoc 	Top Edits · Edit Counter 	20,707 	25.6%
3 	DaxServer 	Top Edits · Edit Counter 	14,694 	18.2%
4 	Gnt 	Top Edits · Edit Counter 	11,846 	14.6%
5 	InternetArchiveBot 	Top Edits · Edit Counter 	1,554 	1.9%
6 	Monkbot 	Top Edits · Edit Counter 	941 	1.2%
7 	PrimeBOT 	Top Edits · Edit Counter 	771 	1%
8 	RWILDONLINE 	Top Edits · Edit Counter 	760 	0.9%
9 	Utcursch 	Top Edits · Edit Counter 	704 	0.9%
10 	Altruism 	Top Edits · Edit Counter 	585 	0.7%
	142 others 		6,083 	7.5%

Citation analysis

Root for 80% of citations (total analysed citations: 127)

Extraction steps

Get wikitext (by using Edit source)
use regex101 to extract url= ;regex string: [^-]url=https?:\/\/.+?\/
use regex101 to extract root ;regex string: https?:\/\/(?:.*\.)*(.+\..+?)\/
count root occurence and sort high to low
pick top 80% of usages

usage data

url-root	count	cumulative count	percentage
thehindu.com	38	38	29.92%
newindianexpress.com	17	55	43.31%
thehansindia.com	13	68	53.54%
gov.in	12	80	62.99%
deccanchronicle.com	6	86	67.72%
indiatimes.com	6	92	72.44%
nic.in	6	98	77.17%
gunturcorporation.org	3	101	79.53%
rediff.com	2	103	81.10%

Revision observations

Here are my observations that can be helpful for future work on similar articles.

The article evolved from the district article. There were attempts in the past to cleanup the article to focus on GMC.
Though the article was medium sized article, it did not have coherence. There was inconsistent population data and repetition of information.
The dating of Nagalipi inscription stones was wrong.
Some of the citations were duplicated in full instead of referring to the single citation multiple times
There were spam links( PIN codes website, Book release function news) which are not needed or were never discussed in the article.
Citations were not present for some information.
After detailed browsing of all the references, I could locate one book titled GMC Situation analysis report in the references, which can be a valuable resource for most of the article. If that book was cited as part of Bibliography, the article revision could have taken less time.
Most of the references are to newspaper articles. Some times just the citation was found without presenting the information. At other times, the citation was found to be irrelevant.
The photo montage was not appealing, as it contained several poor quality photos. Single image which highlights Guntur is better. Even the Google knowledge panel showed a picture of temple in Mangalagiri taken from a UN report.
There were copyright protected photos from newspapers in use.
The identification of GMC borders for depicting the ring road was a challenge till I found the GMC situation analysis report.
The ring road continues to evolve for 20+years and is still incomplete and even a search of internet does not reveal its extents, status of construction.
I found the Guntur location specification with respect to Bay of Bengal, which does not have unique identifiable coordinate rather than to state capital.
Few urls with guntur municipal corporation were usurped. Used archive.org to update the citation