Build a line-level lot map
Assign one stable reference to every reel or continuous piece and repeat it in the inventory, photo filenames and supporting documents. A multi-reel lot can still be presented together, but it needs a traceable path from each row to the physical item. Do not use one warehouse photo or one aggregate footage number to stand in for unlike reels.
A good starting row contains the reference, manufacturer or part number, designation, conductor material, size or rating, reel count and per-reel length. If any field is unknown, identify the missing field on that row rather than borrowing it from a neighboring reel.
- One line/reel reference per item
- Photo and document reference using the same identifier
- Manufacturer or part number and designation
- Material, size/rating and per-reel length
Keep specifications and conditions from collapsing together
Group matching products for a summary only after each underlying reel is identified. Separate unused, removed and recovery-only conditions, and do not treat an estimated length as the same as a documented one. A grand total masks the individual decision points that determine what information is still needed.
The likely mistake is combining different reels and sites into one total and treating gross loaded-reel weight as cable weight. The resolution is one row per physical item, an explicit quantity basis and a weight label that says gross, cable-only/net, estimated with basis or unknown.
- Per-reel footage plus measured/documented/estimated basis
- Condition: unused, removed, recovery-only or unknown
- Gross/net/cable-only weight basis
- Separate line for construction or condition differences
Separate sites, release contacts and loading facts
Group the inventory by actual storage site and include the ZIP or location, release contact or pending status, dimensions, available dock or forklift information, access restrictions and seller timetable. Two reels with matching cable markings can still need distinct site records if they are stored at different locations.
This page does not promise a collection method or freight allocation. The purpose of the access field is simply to stop a multi-site inventory record from implying that all reels have the same handling conditions.
- Storage site or ZIP per line
- Release contact or stated pending status
- Reel dimensions and available loading resource
- Access restriction and seller timetable
Use local public-work context proportionately
Alhambra Public Works maintains streets, alleys, sidewalks, parking lots, streetlights, traffic signals and signage, and reviews or inspects projects affecting the public right-of-way. That is limited context for noting right-of-way or staging constraints when they actually affect the seller's stored material. It does not show that the city owns the lot, that any project has cable available, or that a particular transport arrangement applies.
When a location is uncertain, list the item under an unknown-site group rather than assigning it to a nearby warehouse. A location limitation should remain visible until the seller can attach the correct site and release contact.
- Project context never replaces reel identity
- Right-of-way constraints listed only if applicable
- Unknown site shown as unknown
- No inferred ownership or transport method
Illustrative multi-site lot record
Illustrative fictional record—not a purchased lot: ALH-BL-01; matching product; one reel, 500 ft documented; Site A. ALH-BL-02; same product; one reel, 90 ft estimated; Site B. Gross loaded-reel weight recorded; cable-only weight unknown; dock availability to be confirmed.
The two rows may belong in one submission, but their length basis, site and access fields remain separate. That preserves the useful differences without suggesting either reel is released or that a transport plan has been agreed.
- ALH-BL-01: 500 ft documented; Site A
- ALH-BL-02: 90 ft estimated; Site B
- Weight: gross loaded-reel; cable-only unknown
- Access: dock availability to be confirmed
