Glossary
zip-prefix geolocation
Zip-prefix geolocation is the release of customer locations only at zip-code prefix level instead of exact coordinates - the anonymization choice in the Olist Brazilian e-commerce order dump. It still supports regional delivery-distance and freight analyses, including for Brazilian furniture orders in the marketplace's furniture_decor segment.
What is zip-prefix geolocation?
Zip-prefix geolocation means customer locations are released only down to the zip-code prefix rather than as exact coordinates or full addresses. It is the anonymization choice in the Brazilian E-Commerce Public Dataset by Olist, whose coverage note reads "Brazil - nationwide marketplace orders with customer zip-code level geolocation" and whose customer location is described as being "at zip-code prefix level".
The practical effect: geography survives, precision does not. Regional patterns, state-level aggregation and approximate delivery-distance work remain feasible - the dataset's own framing highlights regional delivery-distance and freight analyses, including for furniture orders in the furniture_decor segment. Door-level routing, catchment mapping and precise last-mile costing do not survive the truncation, and no transformation of the published fields recovers them.
Why does zip-prefix geolocation matter when choosing a dataset?
Granularity promises are cheap to make and expensive to discover.
- Route-level products fail quietly. A vendor implying address-level precision on Olist-derived data is overstating; the documented ceiling is the zip-code prefix.
- Distance math degrades, it does not disappear. Freight and delivery-distance analyses work at prefix level, but treat results as regional approximations rather than meter-accurate logistics inputs.
- Joining other geo sources is constrained. Prefix-level keys limit enrichment against coordinate-based geodata - settle the join keys before committing to a stack.
For retail teams in apparel, consumer electronics and home furnishings, the trade buys privacy compliance at the cost of spatial resolution.
How do you evaluate zip-prefix geolocation in a data source?
- Read the granularity line first. "Customer location at zip-code prefix level" is the documented ceiling - anything finer in a sales deck is embellishment.
- Validate the coverage claim. Nationwide Brazilian marketplace orders with zip-code-level geolocation is the stated footprint.
- Pilot the distance analysis. Run one delivery-distance or freight calculation end-to-end and judge whether prefix resolution answers the business question.
- Check for relational structure. Order-level tables paired with this field - the relational order dump pattern - make geographic joins far cleaner.
Related terms
The table structure this field usually arrives in is covered here:
relational order dump belongs to the same data family as this entry. Browse curated sources in apparel-retail data. Browse curated sources in consumer-electronics data.
Frequently asked questions
Does the Olist dataset include customer coordinates?
No. Customer locations are provided at zip-code prefix level as an anonymization measure - nationwide across Brazil, but not to coordinate precision.
What analyses still work with zip-prefix locations?
Regional aggregations and approximate delivery-distance and freight analyses, including for furniture_decor orders. Door-level routing and precise last-mile costing do not.
Why is the location truncated?
Privacy. Releasing prefixes instead of exact coordinates anonymizes customers while keeping regional analytic value intact.
Datasets containing this field
Datasets containing zip-prefix geolocation
6 datasets carry zip-prefix geolocation in the catalog. Open one, count the fields, judge for yourself.
eCommerce Behavior Data from Multi-Category Store (Apparel Segment)
view · cart · remove_from_cart …+1 more
UCI Online Retail
UCI Online Retail II
UK ONS Retail Sales Index - Retail Industry
US Census Monthly Retail Trade Survey (MRTS)
Every listing shows the field dictionary, sample rows, and coverage before you commit. API, files, or your warehouse. Daily, weekly, or hourly.
Get sample rows