pablo lopez plablo09

## main.md

      
              1 file
            
          
              2 forks
            
          
              5 comments
            
          
              29 stars
            
          
                4rzael
                / main.md
            
            
              Last active
              April 25, 2024 04:41
            
              
                GIS with pySpark.
              
          
    NOTE : Take a look at the comments below !

GIS with pySpark : A not-so-easy journey

Why would you do that ?

Today, many datas are geolocalised (meaning that they have a position in space). They're named GIS datas.
It's not rare that we need to do operations on those, such as aggregations, and there are many optimisations existing to do that.

  
## mandelbrot.sql
WITH RECURSIVE
    x(i) AS ( VALUES (0)
              UNION ALL SELECT i + 1
                        FROM x
                        WHERE i < 101),
    Z(Ix, Iy, Cx, Cy, X, Y, I) AS (
    SELECT
      Ix,
      Iy,
      X :: FLOAT,
	WITH RECURSIVE
	x(i) AS ( VALUES (0)
	UNION ALL SELECT i + 1
	FROM x
	WHERE i < 101),
	Z(Ix, Iy, Cx, Cy, X, Y, I) AS (
	SELECT
	Ix,
	Iy,
	X :: FLOAT,