[dba-SQLServer] Odds and evens

Hi Arthur:

Built such a program many years ago and it was designed to assign a riding and poll code to every address record given a file with the legal description. It was a fairly slow process but computers and programs have improved dramatically since the early eighties. ;-) The program was good in that it could spit out a sorted poll list given the initial voters' lists. After an evening of canvassing the data could be easily updated and new unregistered constituents would automatically inserted. 

Maybe we should collaborate as 2015 promises to be an exciting year?

Jim  

----- Original Message -----
From: "Arthur Fuller" <fuller.artful at gmail.com>
To: "Discussion concerning MS SQL Server" <dba-sqlserver at databaseadvisors.com>
Sent: Tuesday, November 25, 2014 8:23:28 AM
Subject: Re: [dba-SQLServer] Odds and evens

Good point, Gustav. At most, I think there would be only about 1000 numbers
on any given street. I didn't mention it, but this is for an app to be used
by canvassers for a political party. (In case you're unfamiliar with that
term, a canvasser goes door to door and invites the occupant to vote for
their candidate; if they are supporters, would they like a sign for their
lawn or window, etc.) Typically, a pair of canvassers will work together,
each on one side of the street. Hence the need for two lists per street.
The electoral units are called (in Canada) ridings; each riding will
ultimately elect one candidate, and that candidate will end up with a seat
in Parliament.

Ridings have completely arbitrary definitions. A street may easily span
several ridings; hence the need for an upper and lower street number for
each street within a given riding. But yes, as you guessed there may well
be only a few hundred rows per street, so there's really no need to index
the street numbers. The query itself will easily handle that many records.

Arthur
​
_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com