SELECT SecLink FROM Security WHERE SecLink=51 AND UserLink=;OUTPUT NIL
SELECT SecLink FROM Security WHERE SecLink=52 AND UserLink=;OUTPUT NIL
eq '')>
eq '')>
$in{LLPolyCoords}=~s/\ /\,/g;
$in{LngMin}=99999; $in{LatMin}=99999; $in{LngMax}=-99999; $in{LatMax}=-99999;
foreach $pyl (split "\n",$in{LLPolyCoords}) {
if (length($pyl) > 10) {
if (substr($pyl,0,1) eq 'X') { $pyl=substr($pyl,1); }
($lon,$lat)=split(",",$pyl);
$lon=$lon+0; $lat=$lat+0;
if ($in{LngMin} > $lon) { $in{LngMin}=$lon; }
if ($in{LngMax} < $lon) { $in{LngMax}=$lon; }
if ($in{LatMin} > $lat) { $in{LatMin}=$lat; }
if ($in{LatMax} < $lat) { $in{LatMax}=$lat; }
}
}
INSERT INTO VotingDistrict (ParentLink) VALUES ();FINISH
UPDATE VotingDistrict SET ParentLink=,StartDate=,EndDate=,Name=,VTD=,VTDID=,GEOID=,LatMin=,LngMin=,LatMax=,LngMax=,LLPolyCoords= WHERE VotingDistrictID=;
FINISHMap Location Changes Saved.
HasCompare
UPDATE VotingDistrict SET EndDate= WHERE VotingDistrictID=;FINISH
SELECT * FROM VotingDistrict WHERE VotingDistrictID=;OUTPUT NIL
|
| | - | |
SELECT c.Name as CName,l.MapLocationID,substr(l.StartDate,1,10) as MapStartDate,substr(l.EndDate,1,10) as MapEndDate FROM MapLocationVTD as a JOIN MapLocation as l ON a.VotingDistrictLink= AND l.MapLocationID=a.MapLocationLink JOIN Container as c ON ContainerID=l.ContainerLink;OUTPUT
|
SELECT StartDate,EndDate,ParentLink FROM VotingDistrict ORDER BY VotingDistrictID DESC LIMIT 1;OUTPUT NIL
SELECT * FROM VotingDistrict WHERE VotingDistrictID=;OUTPUT NIL
[Compare District Poly]
[Search Voting Districts]
[Add New Voting District]
|
|