Build the line map before totaling the lot
Assign a stable line or reel ID to every reel or continuous piece. Use that ID in the inventory, photo filename, and matching documents. On the same line, record manufacturer, part number, full designation, conductor metal, size, count or rating, and continuous footage with a measured, documented, estimated, or unknown basis.
A group may be used only for truly matching products with matching condition and location facts. A grand total cannot replace those fields, because it hides which reel has a different construction, short length, damaged jacket, or unresolved release status.
- Line or reel ID.
- Product specification fields.
- Continuous footage and quantity basis.
- Photo filename and document reference.
Keep sites, conditions, and release facts separate
A multi-site lot needs a location field on every line. Record the site address or ZIP, storage history, condition, unused or previously in-service status, release status, and any mixed or unknown note. Do not let an undamaged reel at one location represent the condition of an unidentified reel at another.
Add the owner or release authority, loading resources, access restrictions, dimensions or weight basis, and requested timetable for the applicable line or clearly defined site group. These practical facts help describe the lot without determining price, acceptance, payment, or transport arrangements.
- Site address or ZIP.
- Condition and storage history.
- Release status and authority.
- Loading resources, access restrictions, and stated weight basis.
Map photos and documents to the physical lot
Use the line ID in each photo filename. A strong record maps a tag image, jacket-marking image, overview image, and condition image to the reel they describe. When a product document applies to only one reel, record that limitation. A clear photograph of one item is not evidence for another item with a different specification or history.
For an unknown reel, keep a line with the visible facts and the missing fields marked unknown. It remains part of the inventory without being merged into a confirmed product group. This approach prevents an inventory from becoming less accurate simply because it is large.
- Photo mapping tied to the same line ID.
- Document reference tied to the same reel.
- Condition differences shown rather than averaged.
- Unknown items retained in their own lines.
Use local corridor context carefully
The city says Livonia's industry is concentrated in a 6-square-mile corridor with CSX Railway mainline tracks and access to I-96 and I-275.
That fact is useful only as broad location context for a seller describing where individual reels are stored. It does not establish a bulk lot, a local facility, site access, or a transport arrangement. The actionable record still needs the actual site reference, release authority, dimensions or weight basis, and access limitations for each line.
- Actual storage site, not a generalized corridor claim.
- Specific access limitations and known loading resources.
- One release status per line or defined group.
Work a fictional two-line inventory example
The fictional example below shows why one combined footage number is not enough. Two matching products may have different sites, quantity bases, photographs, or release facts. Keeping those distinctions visible lets a reviewer trace what is known and see which fields remain unresolved. It is not a purchased lot or a promise to buy either line.
When records are incomplete, add a mixed or unknown note and preserve the line ID. Do not delete an inconvenient reel from the list or use a strong record for another item as a substitute for missing information.
- Illustrative only: BL-LIV-01; matching product; 500 ft documented; Site A.
- Illustrative only: BL-LIV-02; same product; 90 ft estimated; Site B.
- Photo mapping: BL-LIV-01_tag.jpg and BL-LIV-02_tag.jpg.
- Release: fictional authority and timetable remain unknown.
