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

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