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

1. Get wikitext (by using Edit source)
2. use regex101 to extract url= ;regex string: [^-]url=https?:\/\/.+?\/
3. use regex101 to extract root ;regex string: https?:\/\/(?:.*\.)*(.+\..+?)\/
4. count root occurence and sort high to low
5. 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