David, Grant *did* mention locations, so there is a spatial component. :-)
Grant, what is the feature and what are its attributes? The simplest
model I could think of is each booth+candidate is a feature. WFS filter
query to select.
What are the schemas of your tables? A view of an inner join should do
the trick.
Kind regards,
Ben.
On 11/07/16 10:56, David Crisp wrote:
Hi Grant,
This probably isnt the correct mailing list to ask for SQL join
questions.
Your question appesr to be asking how to join tabular data sets together so
you can analyse them and does not appear ot have a spatial data component.
Sorry, (Trying to not be THAT guy)
David
On Sun, Jul 10, 2016 at 2:15 PM, Grant Boxer <[email protected]> wrote:
I am putting together election results for our recent election and I have
a located file of polling booths and a table of results. The problem I am
having is joining the 4 or 5 results per booth to the polling place
locations. My aim is to have a pie plot of percentage votes per
candidate/party by polling booth. I have tried joining tables but cannot
get the multiple results per booth for some reason. Any assistance
appreciated as I am probably doing it wrong!
Cheers Grant
Grant Boxer
Perth, Western Australia
_______________________________________________
Aust-NZ mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/aust-nz
_______________________________________________
Aust-NZ mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/aust-nz
--
Ben Caradoc-Davies <[email protected]>
Director
Transient Software Limited <http://transient.nz/>
New Zealand
_______________________________________________
Aust-NZ mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/aust-nz
