Skip to main content
Solved

How can I read in these building footprints from Google?


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.

View original
Did this help you find an answer to your question?

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
  • Author
  • Best Answer
  • January 6, 2022

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


mark2atsafe
Safer
Forum|alt.badge.img+44
  • 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.


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings