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.


That is not possible out of the box.

I don't know how you are currently storing your address and incident data. I'd recommend to use a database where you can define a VIEW that joins incidents and addresses.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.