MarkdownTest.md

1. Get the outlines of the circles (ran very fast)

create table circle_outlines as 
SELECT distinct ST_ExteriorRing(the_circle) AS the_geom FROM circle_list;
create index idx_geom_circle_outlines  on circle_outlines  using gist (the_geom);
select distinct geometrytype(the_geom) from circle_outlines ; -- LINESTRING

2. Combine the lines

3A. Check out the geom type created, if interested (should be GEOMETRYCOLLECTION)

3B. Polygonize from the merged borders (ST_Dump((ST_Polygonize(the_geom)))

4. Add points inside using ST_PointOnSurface(polygonized_geoms)

5. Calculate num_overlaps

---

1. This is a normal ordered list.
2. This is a normal ordered list.
3. This is a normal ordered list.
4. This is a normal ordered list.

https://docs.google.com/document/d/1l1FqBW7bGeOAsn0QoDUjjYEMQ7wK8nupJevG1jI0eMA/edit?usp=sharing&pli=1

1. Get the outlines of the circles (ran very fast)

create table circle_outlines as 
SELECT distinct ST_ExteriorRing(the_circle) AS the_geom FROM circle_list;
create index idx_geom_circle_outlines  on circle_outlines  using gist (the_geom);
select distinct geometrytype(the_geom) from circle_outlines ; -- LINESTRING

1. Combine the lines

3A. Check out the geom type created, if interested (should be GEOMETRYCOLLECTION)

3B. Polygonize from the merged borders (ST_Dump((ST_Polygonize(the_geom)))

1. Add points inside using ST_PointOnSurface(polygonized_geoms)

2. Calculate num_overlaps

---

1. This is a normal ordered list.
2. This is a normal ordered list.
3. This is a normal ordered list.
4. This is a normal ordered list.