I have a cities shapefile and a counties shapefile. I have the counties shapefile imported to a PostgreSQL table. I haven't transferred my cities to PostgreSQL yet, but the issue I really want to figure out is how do I create a third table.
Since cities and townships often overlap several counties, I ultimately want a
cities table, a
counties table, and a
city_county pivot table (ID, CITY_ID, COUNTY_ID) so it will play fair with my web application (Laravel Eloquent ORM).
I've been looking through QGIS and can't seem to figure it out, but even if I can accomplish this with SQL in PostgreSQL/PostGIS, that'd be great.