Data extraction from a public website

进行中 已发布的 Feb 11, 2013 货到付款
进行中

This job will consist of searching through a database of information, reviewing the records, and recording a select amount of information into a spreadsheet. There are hundreds of thousands of records, but you will use the information below to search and filter the results to record the information we are needing.

Website for search: [url removed, login to view] (select "Oil and Gas Well Records"

Filters: "District" value will be 08, 8A, 7C (each entry into "District" will give an independent set of search results)

Display: 100 Records per page

Upon clicking submit you will see a grid of information in the "Results" frame.

The column to the far left will contain text with a link that will say "WELL LOG", "SUSPENSE", or "POTENTIAL". We want to only review the "POTENTIAL" documents. Furthermore, any of the "POTENTIAL" documents that say "FILM YR" below them we do not want to review these.

Open the link on "POTENTIAL" and review the information in the pdf. (See "[url removed, login to view]" attached image to show where to look for the date.) The date should be 2011 or later for the documents we are interested in.

Scroll through the documents and look for the Company name that the permit is for as well as the surveying company. This is usually found on the survey plat that is in the documents. (See "[url removed, login to view]" that is attached)

Using this information we will create a spreadsheet which I will share that contains:

1) Oil & Gas Company Name

2) Surveying Company Name

3) Latest Date of Permit

We are not interested in every single record, only unique records for each oil and gas company / survey company combination. The list might look something like this:

Oil & Gas Company Name Surveying Company Name Latest Date of Permit

Chesapeake Energy Landmark Surveying 2012

Petrohawk Landmark Surveying 2011

Chesapeake Energy Percheron 2011

Nexus Energy K&B Surveying 2013

Please private message me with any questions you might have. Good luck bidding!

*EDIT TO INFORMATION*

The example grid is better displayed as follows:

Oil & Gas Company Name, Surveying Company Name, Latest Date of Permit

Chesapeake Energy, Landmark Surveying, 2012
Petrohawk, Landmark Surveying, 2011
Chesapeake Energy, Percheron, 2011
Nexus Energy, K&B Surveying, 2013

数据处理

项目ID: #4235371

关于项目

7个方案 远程项目 活跃的Feb 12, 2013

授予:

try2t

Dear sooter8, I have a small team at my disposal, ready to start. I have gone through the project and understand the task fully. Please see pm, portfolio

$4 USD / 小时
(0条评论)
0.0

有7名威客正在参与此工作的竞标,均价$4/小时

SigmaVisual

I can help in your project, please check PMB and our ratings/reviews to get idea of our experience. Please let me know if you have any queries.

$8 USD / 小时
(14条评论)
5.2
katepesic

Hi, I can do this job, please contact me

$2 USD / 小时
(9条评论)
2.9
afua23

I can get this done for you. I have read the entire description, gone to site and looked at the attachment and i am convinced i am the right person for the job.

$5 USD / 小时
(7条评论)
2.4
allin121

hello sir plz check pmb thanks!!

$5 USD / 小时
(2条评论)
1.2
eSupport4u

Hi! I have gone through your details and I can start this job immediately. The "Potential" is also clear for me.

$2 USD / 小时
(0条评论)
0.0
Krugen

Hi. I have went through the site and I am willing to embark on the assignment. I have time on my hands and my browsing skills are impeccable. Thank you.

$2 USD / 小时
(0条评论)
0.0