No Map In System
$in{plc}.="mpoly[".$in{MapLocationID}."]=new Array;\n";
$in{LLPolyCoords}=~s/\r\n/\n/g; $in{LLPolyCoords}=~s/\r/\n/g;
$nmap++; $np=0; $npc=0; $bgc=0; $npg=1; $in{mnlo}=99999; $in{mnlt}=99999; $in{mxlo}=-99999; $in{mxlt}=-99999; $llon=9999999; $llat=9999999; $tptmp='';
foreach $pyl (split "\n",$in{LLPolyCoords}) {
if (length($pyl) > 10) {
($lon,$lat)=split(" ",$pyl);
$lon=$lon+0; $lat=$lat+0;
if ($bgc==0) {
$in{plc}.="mpoly[".$in{MapLocationID}."][".$npc."]=["; $bgc=1;
} else {
if ($np > 0) { $in{plc}.=","; }
$in{plc}.= '['.$lat.','.$lon.']';
if ($in{mnlo} > $lon) { $in{mnlo}=$lon; }
if ($in{mxlo} < $lon) { $in{mxlo}=$lon; }
if ($in{mnlt} > $lat) { $in{mnlt}=$lat; }
if ($in{mxlt} < $lat) { $in{mxlt}=$lat; }
$np++;
}
} elsif ($bgc != 0) {
if ($bgc == 1) {
$in{plc}.="];\n";
$npc++;
}
$bgc=0; $np=0;
}
}
if ($bgc != 0) { $in{plc}.="];\n"; }
$in{plc}.="mnlo[".$in{MapLocationID}."]=".$in{mnlo}.";\n";
$in{plc}.="mxlo[".$in{MapLocationID}."]=".$in{mxlo}.";\n";
$in{plc}.="mnlt[".$in{MapLocationID}."]=".$in{mnlt}.";\n";
$in{plc}.="mxlt[".$in{MapLocationID}."]=".$in{mxlt}.";\n";
$in{plc}.="mpidd[".$nmap."]=".$in{MapLocationID}.";\n";
Redistricting: Light Green=Added Territory, Red=Removed Territory,
Dark Green=Kept Territory
SELECT * FROM MapImage WHERE MapImageID=;OUTPUT NIL
|
| Date |
Type |
Results |
>
| ,Safe> , |
|
SELECT CandidateID,FirstName,LastName,FinalVoteTotal,Incumbent,WriteIn,Color,Won,Photo FROM RaceMember,Candidate,Party WHERE RaceLink= AND DropoutDate='0000-00-00' AND CandidateID=CandidateLink AND PartyID=RaceMember.PartyLink ORDER BY Won DESC,FinalVoteTotal DESC;OUTPUT Results
|
SELECT RaceID,PollEnd,FileDeadline,Type,AllVotes,MapLocationID,LLPolyCoords,FillCoords,MapImageLink FROM Race
LEFT JOIN MapLocation as cm ON cm.ContainerLink= AND TO_DAYS(cm.StartDate) <= TO_DAYS(TakeOffice) AND (TO_DAYS(cm.EndDate) > TO_DAYS(TakeOffice) OR cm.EndDate='0000-00-00 00:00:00')
AND MapImageLink NOT IN (101,102,167,159)
WHERE ParentContainer= AND Type!='Primary Election' AND Type!='Convention' AND Type!='Endorsement' AND Type!='Straw Poll' ORDER BY PollEnd Desc;OUTPUT
|
