V
vjp2.at
I want to count the number of times the smallest unit matches so as to limit
it to those over a certain threshold.
SELECT DISTINCT count(newed) as thresh,qvot12.ad AS newad, qvot12.ed AS newed,
qvot11.ad AS oldad, qvot11.ed AS olded,
qvot12.sd as newsd, qvotcd as newcd
FROM qvot12, [;database=c:\qvot11.mdb].qvot11
WHERE thres > 5;
qvot11 is under the old redistricting, qvot12 is under the new.
Each has a million voters.
I have a third database from 2011 whih I want to redistrict.
Problem is when I did a mapping matrix, I got extra precincts
because it did not just count people who were redistricted but also
people who moved. I am assuming I can limit the moves to say five.
But I am not sure what kind of handle I have to keep the count to each ED
(precint). (AD is the larger districts - for assembly, and SD for Senate).
- = -
Vasos Panagiotopoulos, Columbia'81+, Reagan, Mozart, Pindus, BioStrategist
http://www.panix.com/~vjp2/vasos.htm
---{Nothing herein constitutes advice. Everything fully disclaimed.}---
[Homeland Security means private firearms not lazy obstructive guards]
[Urb sprawl confounds terror] [Phooey on GUI: Windows for subprime Bimbos]
it to those over a certain threshold.
SELECT DISTINCT count(newed) as thresh,qvot12.ad AS newad, qvot12.ed AS newed,
qvot11.ad AS oldad, qvot11.ed AS olded,
qvot12.sd as newsd, qvotcd as newcd
FROM qvot12, [;database=c:\qvot11.mdb].qvot11
WHERE thres > 5;
qvot11 is under the old redistricting, qvot12 is under the new.
Each has a million voters.
I have a third database from 2011 whih I want to redistrict.
Problem is when I did a mapping matrix, I got extra precincts
because it did not just count people who were redistricted but also
people who moved. I am assuming I can limit the moves to say five.
But I am not sure what kind of handle I have to keep the count to each ED
(precint). (AD is the larger districts - for assembly, and SD for Senate).
- = -
Vasos Panagiotopoulos, Columbia'81+, Reagan, Mozart, Pindus, BioStrategist
http://www.panix.com/~vjp2/vasos.htm
---{Nothing herein constitutes advice. Everything fully disclaimed.}---
[Homeland Security means private firearms not lazy obstructive guards]
[Urb sprawl confounds terror] [Phooey on GUI: Windows for subprime Bimbos]