Paragraph Edit... 4/5

Data Scraping:
Problem: Over million rows of data per year for the span of two decades was required for water contamination analysis by an environmental consulting firm in Santa Monica, CA. The state of Louisiana was expecting the consulting to retrieve the required data from their website at (sample data for one location) for their work.
Solution: After a brief data analysis, I did the followings:
- Developed the required relational table structure in SQL Server 2012 to maintain the downloaded data.
- Developed Data Scraping module in ASP.net/C# using xpath to collect drinking water data.
- The downloaded data cleaned up and then uploaded in the tables.
This module was able to be utilized easily to handle the same process for downloads in the remaining 49 states.
LVL 34
Mike EghtebasDatabase and Application DeveloperAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

JohnBusiness Consultant (Owner)Commented:
Some thoughts for your consideration:
==============================

Data Scraping:

 Problem: Over million rows of data per year for the span of two decades was required for water contamination analysis to be done by an environmental consulting firm in Santa Monica, CA. The state of Louisiana was expecting the consulting work to retrieve the required data from their website at (sample data for one location) for their work.

 Solution: After a brief data analysis, I did the following:

 - Developed the required relational table structure in SQL Server 2012 to maintain the downloaded data.
 - Developed the Data Scraping module in ASP.net/C# using xpath to collect drinking water data.
 - The downloaded data was then cleaned up and uploaded into the tables.

 This module was then able to be utilized to easily handle the same process for data download in the remaining 49 states.

===========================
I think it reads smoothly now. I only added line spaces to help me.  Please see what you think.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Brendt HessSenior DBACommented:
I am assuming that this paragraph will not be targeted solely at IT professionals. I have edited the text using that assumption

Some grammar cleanup and word choice changes are necessary in my opinion.  Edits are bold, deletions are underlined and italicized

Data Scraping:
Problem: Over one million rows of data per year were collected for the span of two decades was required for water contamination analysis by an environmental consulting firm in Santa Monica, CA. The state of Louisiana was expecting the consulting me (as their consultant) to retrieve the required data from their the firm's website at (sample data for one location) for their the state's work.

Solution: After a brief data analysis of the data, I did the followings:
- Developed the required needed relational table structure in SQL Server 2012 to maintain the downloaded data.
- Developed a Data Scraping module in ASP.net/ and C#, using xpath to collect the drinking water data from the firm's website.
- Cleaned up the downloaded scraped data cleaned up and then uploaded in the tables.
- Loaded the cleaned data into the relational tables.

This module Once developed, this solution was able to be utilized easily to handle the same process for downloads retrieving and loading the data in the remaining 49 states.

----------------------------------------------
The final, edited paragraph:
----------------------------------------------

Data Scraping:
Problem: Over one million rows of data per year were collected for the span of two decades for water contamination analysis by an environmental consulting firm in Santa Monica, CA. The state of Louisiana was expecting me (as their consultant) to retrieve the required data from the firm's website at (sample data for one location) for the state's work.

Solution: After a brief analysis of the data, I did the following:
- Developed the relational table structure needed in SQL Server 2012 to maintain the data.
- Developed a Data Scraping module in ASP.net and C# using xpath to collect the drinking water data from the firm's website.
- Cleaned up the scraped data.
- Loaded the cleaned data into the relational tables

Once developed, this solution was able to be utilized easily to handle the same process for retrieving and loading the data in the remaining 49 states.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Proofreading

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.