My goal is to take a folder of unculled and uncaptioned photos as input and pair it with the culled and captioned photos as output. Next, using the captioned photos (and the output of the previous report, generate a description of the progress since last month) I believe it should happen with three models:
1: Photo culling 2: Photo captioning the culled photos 3: Description generation. Instead of season, I would use the term monthly. Here is a list of answers to your questions and the folder structure. I will attach some example data as well (OK,it looks like it wont let me pist csv files). I am at the stage of cleaning and preparing data, do you think I should have separate excel files for each model’s input and output? Or should I keep all data in one csv but with different sheets? I also would love your input on how to approach training these models once the data is cleaned and organized.
Folder structure:
root_folder
│
└───project18001 (rept01 has been processed)
│ └───Rept01 (01/01/2023)
│ │ └───culled_and_captioned.pdf (for outputs)
│ │ └───photos_folder_to_be_culled (as input)
│ │ │ └─── img[i].jpg (to be culled)
│ │ └───output (processed folder)
│ │ │ └─── img[x].jpg culled
│ │ │ └─── captions.csv (Project Number, Report Number, Image Caption, Name Hash)
│ │ │ └─── to_be_culled.csv (Project Name, Rept Number, Image Path, Name Hash)
│ │ │ └─── captions.csv (Project Name, Rept Number, Culled Count, To Be Culled Count, Previous Report)
|
│ └───Rept02 (02/01/2023) – not processed
│ │ └───culled_and_captioned.pdf
│ │ └───photos_folder_to_be_culled
│ │ │ └─── img[i].jpg
│
└───project18002 (not processed)
└───Rept01 (10/01/2022)
│ │ └───culled_and_captioned.pdf
│ │ └───photos_folder_to_be_culled
│ │ │ └─── img[i].jpg
└───Rept02 (11/01/2022)
│ │ └───culled_and_captioned.pdf
│ │ └───photos_folder_to_be_culled
│ │ │ └─── img[i].jpg
A1. By default, there are no other inputs besides a batch of photos every month. However, I am going to create an additional input of the previous report, if there is one. So for example. Project 18001 Report 2 can have the output of the previous report as an example of what was selected correctly. However, rept 01 will not have that. This could pose a problem since there will be more captioned photos for later stages of the project (rept 8) but I hope to simply use it as context and that it will learn from the thousands of other projects that it will be trained on.
A2. A human would make these selections based on some things that are dynamic from project to project or even report to report. Phase of construction, capturing one photo of every type of room or of every floor… I don’t see any way of creating an algorithm to capture everything, its too dynamic. The importance and contents change every report/month.
A3. The results should contain a description of the construction progress that occurred since the previous month. It should be generated given the context of the captioned photos. Here is an example for Rept 01 associated with the attached excel sample data files:
SITEWORK:
• Earthwork: Rough grading around building pads is complete.
• Roads & Walks: Work has not yet commenced.
• Amenities & Site Improvements: Work has not yet commenced.
• Landscaping: Work has not yet commenced.
SITE UTILITIES:
• Electrical: Mobilization and some underground work is in progress.
• Domestic Water: Work has not yet commenced.
• Fire Protection: Work has not yet commenced.
• Sanitary Sewer: Underground piping is in progress.
• Storm Sewer: Storm sewer structure installation is in progress.
• Natural Gas: Work has not yet commenced.
• VERTICAL CONSTRUCTION:
• Masonry: Masonry skin as part of the precast panels is in progress.
• Concrete: Concrete slab‐on‐grade foundations are complete. Building B precast walls
panels have been erected. Forming of Building A panels is in progress.
• Structural Steel: Work has not yet commenced.
• Envelope: Work has not yet commenced.
• Carpentry: Work has not yet commenced.
• Plumbing: Work has not yet commenced.
• Electrical: Work has not yet commenced.
• Mechanical: Work has not yet commenced.
• Fire Protection: Work has not yet commenced.
• Drywall: Work has not yet commenced.
• Flooring: Work has not yet commenced.
Here is an example of the culled and captioned photos as output:
Project Number |
Report Number |
Image |
Caption |
Name Hash |
18109 - Redacted project name |
1 |
C:\Users\Redacted\sample data\complete\18109 - Redacted Project Name\09 - Inspection Reports\Rept01 10-29-18 PA01\output\Redacted_project_name_01_img1.png |
main photo |
97a816874eb84a4284967cd609026e3b |
18109 - Redacted project name |
1 |
C:\Users\Redacted\sample data\complete\18109 - Redacted Project Name\09 - Inspection Reports\Rept01 10-29-18 PA01\output\Redacted_project_name_01_img2.png |
Site - Storm sewer structures stored on site |
9f0ce7e0c50b60b8c0d307771a7a4421 |
18109 - Redacted project name |
1 |
C:\Users\Redacted\sample data\complete\18109 - Redacted Project Name\09 - Inspection Reports\Rept01 10-29-18 PA01\output\Redacted_project_name_01_img3.png |
Site - Rough grading in progress |
dcae1672af6aa56d9401235458f531a8 |
18109 - Redacted project name |
1 |
C:\Users\Redacted\sample data\complete\18109 - Redacted Project Name\09 - Inspection Reports\Rept01 10-29-18 PA01\output\Redacted_project_name_01_img4.png |
Site - Rough grading in progress |
eca83bcca38a0cb9154773cdab0ccb0f |
18109 - Redacted project name |
1 |
C:\Users\Redacted\sample data\complete\18109 - Redacted Project Name\09 - Inspection Reports\Rept01 10-29-18 PA01\output\Redacted_project_name_01_img5.png |
Site - Steel components and rebar stored on site |
db29ce0fb40827d77fc118cbff0999f6 |
18109 - Redacted project name |
1 |
C:\Users\Redacted\sample data\complete\18109 - Redacted Project Name\09 - Inspection Reports\Rept01 10-29-18 PA01\output\Redacted_project_name_01_img6.png |
Site - Sanitary sewer system in progress |
5ff8e86aafcb28090e6afbb70694259a |
18109 - Redacted project name |
1 |
C:\Users\Redacted\sample data\complete\18109 - Redacted Project Name\09 - Inspection Reports\Rept01 10-29-18 PA01\output\Redacted_project_name_01_img7.png |
Site - Storm sewer structures stored on site |
85bba9ad3467b4455f358966506f6247 |
18109 - Redacted project name |
1 |
C:\Users\Redacted\sample data\complete\18109 - Redacted Project Name\09 - Inspection Reports\Rept01 10-29-18 PA01\output\Redacted_project_name_01 |
|
|