Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It only takes a minute to sign up.
Sign up to join this community
I have two layers, one (A) has point features and the other (B) has polygons.
How do I produce a new table with some (the ID) or all the fields from the A table and some (the area code) or all from the B table where the B polygon contains the A point?
I am using QGIS.
It's possible to do a join on location ("where the B polygon contains the A point") using "Join attributes by location" from "Vector" menu. The resulting layer will contain all attributes from both layers.
A faster alternative is SAGA > Vector point tools > Add polygon attributes to points which is available through the Processing toolbox in QGIS.
Through SQL
You will need access to the data and access to a SQL db, you can derive the information via a simple SQL query. This example was written for SQL Server in TSQL.
The query will list the Hydrant (Layer A) and Fire District (Layer B) IDs along with common identifiers and the geometry definition of each. Because it has the geometry defined, if you were to insert these results into a table you can then review them in your map.
SELECT WHYDRANT.OBJECTID AS HYDID,
WFIREDISTRICT.OBJECTID AS FDID, WHYDRANT.UNID AS UNID,
WFIREDISTRICT.UNID AS FDUNID, WHYDRANT.SHAPE
FROM WFIREDISTRICT
INNER JOIN WHYDRANT ON
WFIREDISTRICT.SHAPE.STContains(WHYDRANT.SHAPE()) = 1
