Computing surface areas

Part
01
of fifteen
Part
01

Sunbelt Locations - Surface Areas Rows 2-46

Your spreadsheet for Sunbelt Locations - Surface Areas Rows 2-46 has been filled out using the DaftLogic tool.

Discrepancies and Challenges

Please note that row 20 batch identifier PCM1042 has Beaupre Aerial Equipment in the location and building presented in the spreadsheet. We confirmed this with a Google Maps street view, and found no regular green equipment photographed on premise.

Row 27, 28 batch identifiers pcm716 and pcm717 labeled as Van's Equipment.

Row 24 batch identifier pcm1705 has no visual of the lot built. Google maps shows an empty lot, seemingly cleared down but no equipment or building on premise. Location (Build Out) metrics for column K are filled in as n/a. We saved the entire cleared lot on the map for this one.

Row 33 batch identifier pcm746 is a suite inside a large singular building structure. We were unable to single out the suite Sunbelt inhabits. The building doesn't have google maps visuals close enough. We took our best guess for the size of this

Row 43 batch identifier pcm719 is labeled as Volvo Rents Springfield.
Part
02
of fifteen
Part
02

Sunbelt Locations - Surface Areas Rows 47-90

The requested measurements have been entered into rows 47-90 of the attached spreadsheet, and the maps have been saved on the website. There were nine locations that we were not able to measure because we were unable to find the physical location of the company or make an educated guess. These instances have been explained below.

Row 58 - There are no buildings labeled Sunbelt, or anything that indicated it was likely the correct location.

Row 63 - The coordinates are the same as row 62 and I don't see any other buildings that are labeled sunbelt or pump and power services.

Row 65 - This row has the same coordinates as row 64 and there is no way to know which part of the building is dedicated to Industrial Services.

Row 74 - This row has the same coordinates as row 73, but only one labeled building on the lot. There is a building on the neighboring lot but it is unlabeled so we cannot say if it is the pump and power services building.

Row 78 - There is a labeled pinpoint for Sunbelt Rentals, but there are no buildings or defined areas, so we cannot be sure of what to measure.

Row 79 - There is no labeled area for Sunbelt Rentals and no other indicators of an accurate location.

Row 81 - There is no labeled area for Sunbelt Rentals and no other indicators of an accurate location.

Row 85 - There is no labeled area for Sunbelt Rentals and no other indicators of an accurate location.

Row 88 - The Sunbelt Rentals pinpoint is in an empty field and there are no indicators or labels in the surrounding buildings that show where the accurate location is.

To wrap it up, the requested measurements have been entered into rows 47-90 of this spreadsheet, and each location map has been saved on the website.
Part
03
of fifteen
Part
03

Sunbelt Locations - Surface Areas Rows 91-135

Using the indicated website the surface area for each coordinate was input in to rows 91-135 of the attached spreadsheet.

METHODOLOGY

For each coordinate the surface area was calculated for the yard and building and entered into the spreadsheet in acres. After clearing all points, the building area was calculated and entered into the spreadsheet in feet squared. For each coordinate, a new area was saved and can be found on the website under the title in column B.

For rows 95, 113 and 122 the coordinates were for Lowes stores. In these cases the surface area for the whole of Lowes' yard and building were used to complete the spreadsheet.

The coordinates for row 102 did not show a pin for a Sunbelt location and therefore we were unable to provide this information. For row 128 there was a pin for Sunbelt, however the pin did not indicate a building or yard and therefore this row could also not be completed.

CONCLUSION

Rows 91-135, columns J-L were completed on the attached spreadsheet, except for rows 102 and 128 where the Sunbelt locations could not be identified.


Part
04
of fifteen
Part
04

Sunbelt Locations - Surface Areas Rows 136-180

Using the Google Map Area Tool I completed the designated rows 136-180 on the attached spreadsheet.

RESEARCH NOTES

While completing the spreadsheet I determined that the following rows shared duplicate coordinates:
row 144 and row 145 shared coordinates 40.7382723, -111.9480092
row 149 and row 150 shared coordinates 31.9845135, -102.0377546
row 150 and row 161 shared coordinates 37.9729646, -85.6976605
row 175 and row 176 shared coordinates 39.1653040, -84.5192238

For all four cases, I simply used the area calculation tool twice and saved two independent maps. Some variation did exist in the values obtained for area even though the lots and buildings were the same. This is likely due to the scale of the map at the time I used the tool.

Additionally, row 172 did not have any buildings present within the lot and therefore the value I entered in column K was 0.

There were also several occasions where I was not able to verify the coordinates via the address provided and where the pin landed just outside a lot. For these instances, I collected area information from the lot closest to the point pinned by the coordinates.

CONCLUSION

All completed details are available within the attached spreadsheet.

Part
05
of fifteen
Part
05

Sunbelt Locations - Surface Areas Rows 181-226

The requested information has been entered into rows 181-226 of the attached spreadsheet, and the maps have been saved under the names in column B on the website as instructed.

FINDINGS

Rows 188 [pcm685] - The specific building structure located on the map is shared by Lowe's Home Improvement and Sunbelt Rentals.
Rows 195 [pcm496] - There are no buildings labeled Sunbelt, or anything that indicated it was likely the correct location.

Rows 206 [pcm1007] - Location for Sunbelt Rentals was not found. Rental Company of Cella LLC occupies the specific coordinate.

Rows 209 [pcm342] - We found a location surface for Sunbelt Rentals at the specific location. However, no building structure was found.

Rows 214 [pcm464] - Sunbelt Rentals was not found at this location. Universal Hospital Service currently occupies the location.

Rows 215 [pcm612] - Sunbelt Rentals was not found at the specified coordinate. The map, however, showed Hart Industrial Products Inc occupying the current location.
Rows 218 [pcm649] - We found no structure or label for Sunbelt Rentals for the location. Lowe's' Home Improvement building structure was located at the specified coordinate.
Rows 223 [pcm609] - The building is occupied by Sunbelt Rentals and Cyclone Bolt and Gasket.

CONCLUSION

All details have been entered in the attached spreadsheet.
Part
06
of fifteen
Part
06

Sunbelt Locations - Surface Areas Rows 227-271

The requested measurements have been entered into rows 227-271 of this spreadsheet. Each map has also been saved on this website. Below you will find explanations for any measurements that we could not determine.

pcm596
United States
591 W Freeway Blvd, Rose City, TX 77662
pcm595
United States
590 W Freeway Blvd, Rose City, TX 77662
are the same location.

For location pcm228, 5350 W 161st Street, Brookpark, OH 44142, the addresses go from 5340 to 5400 with no 5350 between.


pcm254
United States
4132 Trax Dr, Birmingham, AL 35207
pcm076
United States
4132 Trax Dr, Birmingham, AL 35207-1735
are the same location.

For pcm253, 2613 2nd Ave S, Birmingham, AL 35233-2616, square footage is total of 2 buildings.


pcm231
United States
320 Richey St, Pasadena, TX 77506-1804
pcm147
United States
330 Richey St, Pasadena, TX 77506-1804
are the same location.

For Sunbelt Rentals locations located inside a Lowes, the lot and building dimensions for the Lowes is provided, since the are of the facility dedicated to Sunbelt cannot be determined from the aerial view.

Part
07
of fifteen
Part
07

Sunbelt Locations - Surface Areas Rows 272-316

The Sunbelt locations surface area calculations have been completed for rows 272-316/columns J-L of the attached spreadsheet. Each location was identified by the provided address and/or coordinates. Then, Draft Logic's Google Maps Area Calculator Tool was used to provide the requested acres and square footage. All results are provided in the spreadsheet.
Part
08
of fifteen
Part
08

Sunbelt Locations - Surface Areas Rows 317-362

As required, surface area rows 317-362 have been populated in the attached spreadsheet and the maps have been saved using the Draft Logic tool.

FINDINGS

We searched the addresses using the Draft Logic service and in some cases double-checked the same addresses on Google Maps to be sure that we had the right plot. This was especially important for the locations that did not explicitly note they were Sunbelt locations.

We did not find anything on the map that indicated that a Sunbelt is located at the coordinates for the following batch identifiers/locations:
pcm686 / 1924 Lafayette Street, New Orleans, LA 70113
pcm659 / 1924 Lafayette Street, New Orleans, LA 70113
PCM7026 / 948 Zelco Drive, Burlington, ON L7L 4Y3
pcm487 / 6110 Northbelt Parkway, Norcross, GA 30071-4639
pcm054 / 725 Ralph Mcgill Blvd, Atlanta, GA 30312
PCM1037 / 3261 East Highway 34, Newnan, GA 30265 
PCM1040 / 1902 Roanoke Road, Lagrange, GA 30240 
pcm117/ 16C Overmeyer Way, Forest Park, GA 30297
pcm605 / 16C Overmeyer Way, Forest Park, GA 30297
pcm629 / 639 Rochester Road, Pittsburgh, PA 15237
pcm669 / 5673 Old Dixie Highway, Forest Park, GA 30297
pcm725 / 720 Trumbull Drive, Pittsburgh, PA 15205

The following batch identifiers/locations are CRS Contractor's Rental Supply stores:
PCM7028 / 21 Warrington St, Hamilton, ON L8E 3L1
PCM7021 / 36 Rutherford Rd S, Brampton, ON L6W 3J5
PCM7003 / 535 Welham Road, Barrie, ON L4N 8Z6
pcm702 / 79 Ram Forest Road, Aurora, ON L4G 7C6 

Some Sunbelt Rentals are located within Lowe's stores; it is not possible to determine (from the map) the area occupied by Sunbelt Rentals within a Lowe's store. For the following Lowe's stores, the map explicitly shows that a Sunbelt Rental is located within the store:
pcm639 / 10580 Duke Dr. Ste 1, Alpharetta, GA 30009-4845
pcm640 /3582 Peachtree Pkwy, Suwanee, GA 30024
pcm700 / 4950 Peachtree Industrial Blvd, Chamblee, GA 30341-3141
pcm674 / 1615 Scenic Hwy N Ste 100, Snellville, GA 30078-2214

For the following batch/identifier locations there is more than one building on the plot:
pcm554 930 E Fort Lowell Rd, Tucson, AZ 85719-2112
PCM7003 / 535 Welham Road, Barrie, ON L4N 8Z6
pcm106 / 3412 Bienville Blvd, Ocean Springs, MS 39564-5732
pcm202 / 141 Sweeten Creek Rd, Asheville, NC 28803-1526
pcm015 / 5905 Rangeline Rd, Theodore, AL 36582-5275

Additional notes regarding the surface area findings are below.
—At 112 Venture Blvd, Houma, LA 70360 (pcm598), there is no plot or building shown on the map.
—For the store at 1924 Lafayette Street, New Orleans, LA 70113 (pcm686 and pcm659) we have assumed that the Flooring division is the larger building and the HVAC & Dehumidification building is the smaller one.
—At 2750 Losee Road, North Las Vegas, NV 89030 (pcm791,
pcm650), there is nothing (on the map) that demarcates the General Equipment & Tools and Flooring Solutions areas to be able to measure them separately. We have entered the total area of the building against each entry.
—The addresses 1540 Iris Drive Sw, Conyers, GA 30094 (pcm030, pcm1003) and 4950 Peachtree Industrial Blvd, Chamblee, GA 30341-3141 (pcm700) is are pre-existing duplicates in the list.

CONCLUSION

The attached spreadsheet contains all required information for rows (317-362).
Part
09
of fifteen
Part
09

Sunbelt Locations - Surface Areas Rows 363-406

The surface area for each coordinate has been compiled in the columns J-L, rows 363-406 of the attached spreadsheet.

First, we created the area of the yard in the given area calculator and extracted the area in acres. Second, we created the area of the building in the given area calculator and extracted the area in square feet. We also studied the shape of the area to extract the information about the shape of the yard's location and saved the area using the appropriate branch identifier. Finally, we compiled all the data into the given spreadsheet.
Part
10
of fifteen
Part
10

Sunbelt Locations - Surface Areas Rows 407-451

On the attached spreadsheet rows 407-451, I have entered the requested information into columns J, K, and L. I have noted "N/A" In cases where the requested information could not be found.

METHODOLOGY AND FINDINGS

Using the username and password provided, I logged into Daft Logic and searched each location using the coordinates provided on Column E. I also used the addresses provided on Column D to confirm the exact location of those coordinates. For each coordinate, the surface area of the yard was calculated in acres and the area of the building in square feet. Once done with those two steps, the information was saved using the corresponding branch identifier indicated on Column B of the spreadsheet.

During the research, I found out that the location referenced on row 444 was repeated on row 445. In addition, the location referenced on row 448 does not exist; and after a close examination, I noticed that the location referenced is actually on the highway and the closest premise appears to be a residential building.

CONCLUSION

On the attached spreadsheet, rows 407-451/columns J, K, and L, I have completed the requested information, except for row 448 where the referenced Sunbelt Rentals could not be identified.
Part
11
of fifteen
Part
11

Sunbelt Locations - Surface Areas Rows 452-496

The acreage of each Sunbelt lot and square footage of each building in rows 452-496 has been entered on the attached spreadsheet.

To find the acreage and square footage, I used the Google Maps Area Tool as directed. Columns J-L have been completed for rows 452-496.

In addition, the new areas I created have been saved under the names in column B on the website as instructed.
Part
12
of fifteen
Part
12

Sunbelt Locations - Surface Areas Rows 497-541

Using the Google Maps Area Calculator Tool, I was able to find the area for each Sunbelt lot and building for the addresses in rows 497-541 of the attached spreadsheet, with the following exceptions:

Row 504's address of 7630 Sandlapper Parkway North, North Charleston, SC 29420-2801 puts a pin in the middle of a street, and while it indicates it should be the location of a Sunbelt Rentals Climate Control facility, there is no lot or building associated with the address. Therefore, I have entered "N/A" in columns J and K for this row and left column L blank. I also did not save this area on the website.

Rows 519 and 520 have the same address of 3333 East 69th Street, Long Beach, CA 90805, but there are two buildings on the property. I have provided the area of one building in row 519 and the area of the second building in row 520. The area of the lot is the same for both rows.

Rows 521 and 522 have the same address of 3860 Sherman St, San Diego, CA 92110-4322, but there is only one structure on the lot. Therefore, I have included the same data for both rows and only saved one area on the website.

Rows 532 and 533 have the same address of 900-C Tryens Road, Aston, PA 19014, but there is only one structure on the lot. Therefore, I have included the same data for both rows and only saved one area on the website.

As directed, all areas have been saved on the website under the name in column B for each Sunbelt Rental location, except for the situations noted above.

All available information has been entered into columns J-L, rows 497-541 of the attached spreadsheet.
Part
13
of fifteen
Part
13

Sunbelt Locations - Surface Areas Rows 542-586

Rows 542-586 and their corresponding columns J-L have been filled to provide the area in acres for column J, area in feet squared in column K, and the shape of the yard in column L. All of our findings can be found in the attached spreadsheet. 

Part
14
of fifteen
Part
14

Sunbelt Locations - Surface Areas Rows 587-631

The requested measurements have been entered into rows 587-631 of the attached spreadsheet, and the maps have been saved on the website. There were 11 locations that we were not able to measure because we were unable to find the physical location of the company or make an educated guess. These instances have been explained below.

Row 588 - The coordinates are the same as row 587 and there is only one building, so we cannot accurately determine which part of the building is which.

Row 593 - The coordinates are the same as row 592 and there is only one building, so we cannot accurately determine which part of the building is which.

Rows 598-599 - The coordinates are the same as row 597 and there is only one building, so we cannot accurately determine which part of the building is which.

Rows 611-612 - There is no label for Sunbelt Rentals and no other indicators were present that could be used to make an educated guess. A search of the street address also brought up no results for Sunbelt Rentals.

Row 615 - There is no label for Sunbelt Rentals and no other indicators were present that could be used to make an educated guess. A search of the street address also brought up no results for Sunbelt Rentals.

Row 616 - There is no label for Sunbelt Rentals and no other indicators were present that could be used to make an educated guess. A search of the street address also brought up no results for Sunbelt Rentals.

Row 622 - There is no label for Sunbelt Rentals and no other indicators were present that could be used to make an educated guess. A search of the street address also brought up no results for Sunbelt Rentals.

Row 624 - There is no label for Sunbelt Rentals and no other indicators were present that could be used to make an educated guess. A search of the street address also brought up no results for Sunbelt Rentals.

Row 627 - There is no label for Sunbelt Rentals and no other indicators were present that could be used to make an educated guess. A search of the street address also brought up no results for Sunbelt Rentals.

To wrap it up, the requested measurements have been entered into rows 587-631 of this spreadsheet, and each location map has been saved on the website.

Part
15
of fifteen
Part
15

Sunbelt Locations - Surface Areas Rows 632-686

Sunbelt locations' yard area (in acres), building area (in sq. feet), and yard's shapes for all locations listed in Rows 632-686 was entered in columns J-L. All figures were identified using Daft Logic's Google Maps Area Calculator Tool and were verified using Google maps for few locations, i.e. 7603 Overseas Hwy, 2529 N Airport Rd, 40 Robbie Rd, and others. All areas in the assigned rows were saved using the branch identifier's name in column B and were added under the account name "wissamkahi" in the Daft Logic site.

Notes

8417 Palm River Road, Tampa, FL 33619 (Row 643) — No building found on the map, thus, I entered "0" in column H.

600 E Landstreet Rd, Orlando, FL 32824 — Aerial Work Equipment &
Scaffold Services: The two Sunbelt services used the same address, thus, I provided the same figures in Row 649 and 650.

800 Hartford Tpke Ofc, Shrewsbury, MA 01545-4107 — Pump & Power Services & General Equipment & Tools: The two Sunbelt services used the same address, thus, I provided the same figures in Row 654 and 655.

11280 Interchange Circle North, Miramar, FL 33025 (Row 679) — Flooring Solutions: The figures were estimates as Sunbelt Rentals shares the same building with other companies.

7603 Overseas Hwy, Marathon, FL 33050 (Row 686) — General Equipment & Tools: Sunbelt Rental shares the same building/yard with other companies.

CONCLUSION

Please see attached spreadsheet for complete details, rows 632-686, columns J-L.
Sources
Sources