jiayuasu opened a new pull request, #3160:
URL: https://github.com/apache/sedona/pull/3160

   ## What
   
   A new blog post introducing the **OSM PBF reader** (`osmpbf` format): 
reading raw OpenStreetMap `.osm.pbf` extracts into a Sedona DataFrame with no 
conversion step.
   
   - One-line read of a `.osm.pbf` extract; the raw OSM element model (nodes / 
ways / relations) as a single table
   - Nodes → points via `ST_Point` (POI examples)
   - The part people struggle with: **assembling way LineStrings from ordered 
node refs** — `posexplode` + join + ordered rebuild, with a figure explaining 
the pattern
   - Road stats over the reconstructed lines (`ST_LengthSpheroid` per highway 
class)
   - Map freshness/churn analysis via the `timestamp`/`version` metadata 
fields, with an honest note that public Geofabrik extracts strip 
`user`/`uid`/`changeset`
   - Two self-contained SVG figures (cover, way-assembly explainer)
   
   All queries were executed against the bundled Monaco extract 
(`spark/common/src/test/resources/osmpbf/monaco-latest.osm.pbf`); the console 
output in the post is real, so readers can reproduce it verbatim.
   
   ## Notes
   
   - Opening as a **draft** for review.
   - Fills a docs gap: the OSM PBF reader currently has no dedicated 
tutorial/blog page.
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]

Reply via email to