Skip to main content
Best Answer

How can I read in these building footprints from Google?

  • January 6, 2022
  • 3 replies
  • 60 views
dmatranga_byr
Forum|alt.badge.img+1

Looking to use these building footprints from Google, and they're in a format I haven't heard of before, a 'spatially sharded CSV'. Has anyone ever worked with this dataset or know how I could read in the spatial data?

 

Here's more info from the page at Google Research:

 

Building polygons

Building polygons are stored in spatially sharded CSVs with one CSV per S2 cell level 4. Each row in the CSV represents one building polygon and has the following columns:

  • latitude: latitude of the building polygon centroid,
  • longitude: longitude of the building polygon centroid,
  • area_in_meters: area in square meters of the polygon,
  • confidence: confidence score [0.5;1.0] assigned by the model,
  • geometry: the building polygon in the WKT format (POLYGON or MULTIPOLYGON),
  • full_plus_code: the full Plus Code at the building polygon centroid,

 

Best answer by dmatranga_byr

Google's terminology had me confused, but a simple GeometryReplacer works great.

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

3 replies

dmatranga_byr
Forum|alt.badge.img+1

FME recognizes the latitude and longitude and thinks it's a point. Any idea how I might be able to use the WKT geometry column to make polygons?

dmatranga_byr
Forum|alt.badge.img+1
  • dmatranga_byr
  • Author
  • Best Answer
  • January 6, 2022

Google's terminology had me confused, but a simple GeometryReplacer works great.

mark2atsafe
Safer
Forum|alt.badge.img+59
  • mark2atsafeSafer
  • Safer
  • January 7, 2022

Thanks for your great question. I made it one of two Questions of the Week! That means you get a special badge on the community, but more importantly, I cover the content in a video. Although you solved the problem already, you might find this interesting.

You can find a demonstration of the solution to your problem here: https://www.youtube.com/watch?v=mblkuhjv6gw&t=139s

I hope this is useful and thanks again for posting your question to the community.

FME Evangelist to the Rich and Famous!!

Community Stats

32,194
Posts
122,225
Replies
39,876
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.