I have two layers:
- One with geographical coordinates containing every address in the county and a unique identifier.
- The second contains a list of incidents with the unique identifier from the address layer.
I could join the incidents layer to the address layer and then query only those addresses that have an incident. However there could be multiple incidents at on address, so I need to join the address layer to the incidents table. This gives me a record for each incident and the X Y coordinates from the address layer.
How do I specify that this layer now contains points without writing an intermediate file and re importing?
The two original layers will change with time and I don't want to save intermediate files.