<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Mosaic's grid_boundary method returns inconsistent geometries in Get Started Discussions</title>
    <link>https://community.databricks.com/t5/get-started-discussions/mosaic-s-grid-boundary-method-returns-inconsistent-geometries/m-p/37098#M5437</link>
    <description>&lt;P&gt;I am applying mosaic's `grid_boundary` method on a spark DataFrame containing a set of `h3_hex_ids`. The geometries returned are not consistent. i.e they could be either `lat, long` or `long, lat`.&lt;/P&gt;&lt;P&gt;&lt;BR /&gt;Here's a sample data&lt;/P&gt;&lt;P&gt;```&lt;BR /&gt;import pyspark.sql.functions as F&lt;BR /&gt;import h3&lt;/P&gt;&lt;P&gt;# Create a Spark DataFrame with a h3_hex_id column&lt;BR /&gt;df = spark.createDataFrame([&lt;BR /&gt;("point1", 612232698081050623),&lt;BR /&gt;("point2", 611987238200279039),&lt;BR /&gt;("point3", 612252103481491455)),&lt;BR /&gt;], ["name", "h3_hex_id"])&lt;/P&gt;&lt;P&gt;&lt;BR /&gt;# Get Polygon geometries&lt;BR /&gt;df1 = df.withColumn("geometry", grid_boundary(col("h3_hex_id"), format_name=F.lit("WKT")))&lt;BR /&gt;df1.show()&lt;/P&gt;&lt;P&gt;+--------------------+------+----------------+----------------+&lt;BR /&gt;| name | h3_hex_id | | geometry |&lt;BR /&gt;+--------------------+------+----------------+----------------+&lt;BR /&gt;| point1 | 612232698081050623 | POLYGON ((42.1261...&lt;BR /&gt;| point2 | 611987238200279039 | POLYGON ((-145.83...&lt;BR /&gt;| point3 | 612252103481491455 | POLYGON ((-138.08...&lt;BR /&gt;+--------------------+------+----------------+----------------+&lt;/P&gt;&lt;P&gt;```&lt;/P&gt;&lt;P&gt;This is causing a few issues with downstream tasks like spatial joins. Why are the geometries returned by `grid_boundary` method not consistent?&lt;/P&gt;</description>
    <pubDate>Thu, 06 Jul 2023 21:37:15 GMT</pubDate>
    <dc:creator>kll</dc:creator>
    <dc:date>2023-07-06T21:37:15Z</dc:date>
    <item>
      <title>Mosaic's grid_boundary method returns inconsistent geometries</title>
      <link>https://community.databricks.com/t5/get-started-discussions/mosaic-s-grid-boundary-method-returns-inconsistent-geometries/m-p/37098#M5437</link>
      <description>&lt;P&gt;I am applying mosaic's `grid_boundary` method on a spark DataFrame containing a set of `h3_hex_ids`. The geometries returned are not consistent. i.e they could be either `lat, long` or `long, lat`.&lt;/P&gt;&lt;P&gt;&lt;BR /&gt;Here's a sample data&lt;/P&gt;&lt;P&gt;```&lt;BR /&gt;import pyspark.sql.functions as F&lt;BR /&gt;import h3&lt;/P&gt;&lt;P&gt;# Create a Spark DataFrame with a h3_hex_id column&lt;BR /&gt;df = spark.createDataFrame([&lt;BR /&gt;("point1", 612232698081050623),&lt;BR /&gt;("point2", 611987238200279039),&lt;BR /&gt;("point3", 612252103481491455)),&lt;BR /&gt;], ["name", "h3_hex_id"])&lt;/P&gt;&lt;P&gt;&lt;BR /&gt;# Get Polygon geometries&lt;BR /&gt;df1 = df.withColumn("geometry", grid_boundary(col("h3_hex_id"), format_name=F.lit("WKT")))&lt;BR /&gt;df1.show()&lt;/P&gt;&lt;P&gt;+--------------------+------+----------------+----------------+&lt;BR /&gt;| name | h3_hex_id | | geometry |&lt;BR /&gt;+--------------------+------+----------------+----------------+&lt;BR /&gt;| point1 | 612232698081050623 | POLYGON ((42.1261...&lt;BR /&gt;| point2 | 611987238200279039 | POLYGON ((-145.83...&lt;BR /&gt;| point3 | 612252103481491455 | POLYGON ((-138.08...&lt;BR /&gt;+--------------------+------+----------------+----------------+&lt;/P&gt;&lt;P&gt;```&lt;/P&gt;&lt;P&gt;This is causing a few issues with downstream tasks like spatial joins. Why are the geometries returned by `grid_boundary` method not consistent?&lt;/P&gt;</description>
      <pubDate>Thu, 06 Jul 2023 21:37:15 GMT</pubDate>
      <guid>https://community.databricks.com/t5/get-started-discussions/mosaic-s-grid-boundary-method-returns-inconsistent-geometries/m-p/37098#M5437</guid>
      <dc:creator>kll</dc:creator>
      <dc:date>2023-07-06T21:37:15Z</dc:date>
    </item>
  </channel>
</rss>

