Skip to main content
Removed signature as per help instructions
Source Link
PolyGeo
  • 65.4k
  • 29
  • 114
  • 345

I am new to geodatabase queries and cartodb. I am trying to write a SELECT query that will do the following.

I have two tables.

Table 1 contains congressional district polygons and info about representatives.

Table 2 contains service territory polygons and info about providers.

There is no common key between the tables.

For each polygon in Table 1, I need to find all of the intersecting polygons from Table 2, and return all of the calculated polygon intersections.

Help?

Thank you,

Tom

I am new to geodatabase queries and cartodb. I am trying to write a SELECT query that will do the following.

I have two tables.

Table 1 contains congressional district polygons and info about representatives.

Table 2 contains service territory polygons and info about providers.

There is no common key between the tables.

For each polygon in Table 1, I need to find all of the intersecting polygons from Table 2, and return all of the calculated polygon intersections.

Help?

Thank you,

Tom

I am new to geodatabase queries and cartodb. I am trying to write a SELECT query that will do the following.

I have two tables.

Table 1 contains congressional district polygons and info about representatives.

Table 2 contains service territory polygons and info about providers.

There is no common key between the tables.

For each polygon in Table 1, I need to find all of the intersecting polygons from Table 2, and return all of the calculated polygon intersections.

Help?

Source Link
Tom
  • 21
  • 1
  • 2

Select Polygon Intersections Between Two Tables With No Common Key

I am new to geodatabase queries and cartodb. I am trying to write a SELECT query that will do the following.

I have two tables.

Table 1 contains congressional district polygons and info about representatives.

Table 2 contains service territory polygons and info about providers.

There is no common key between the tables.

For each polygon in Table 1, I need to find all of the intersecting polygons from Table 2, and return all of the calculated polygon intersections.

Help?

Thank you,

Tom