Demographic Edit
SELECT SecLink FROM Security WHERE SecLink=54 AND UserLink=;OUTPUT NIL Saving.. $in{DNumber}=~s/\,//g; SELECT DemographicNumID from DemographicNum where DemographicLink= and StartDate=;OUTPUT NIL UPDATE DemographicNum SET AttachID=,StartDate=,Source=,DemographicLink=,DNumber=,F%d>, LMBy=,LastModified= WHERE DemographicNumID=;OUTPUT NIL INSERT INTO DemographicNum (AttachTo,AttachID,StartDate,Source,DemographicLink,DNumber,FirstBy,LMBy,LastModified) VALUES ('Container',,,,,,F%d>,,,);OUTPUT NIL SELECT DemographicNumID OPRID FROM DemographicNum WHERE AttachID= AND DemographicLink= AND StartDate < ORDER BY StartDate DESC LIMIT 1;OUTPUT NIL UPDATE DemographicNum SET EndDate= WHERE DemographicNumID=;OUTPUT NIL SELECT StartDate NSTD FROM DemographicNum WHERE AttachID= AND DemographicLink= AND StartDate > ORDER BY StartDate LIMIT 1;OUTPUT NIL UPDATE DemographicNum SET EndDate= WHERE DemographicNumID=;OUTPUT NIL SELECT DemographicID as DemographicLink FROM Demographic WHERE DemoCategory= ORDER BY DemoSubcategory,Priority DESC,DemoName;OUTPUT EachDNum Saved Changes.

SELECT DISTINCT DemoCategory FROM Demographic ORDER BY DemoCategory;OUTPUT
Select a Demographic Category
SELECT DNumber,Source FROM DemographicNum WHERE AttachID= AND DemographicLink= AND StartDate=;OUTPUT NIL SELECT DemographicID,DemoName,DemoSubcategory,Color FROM Demographic WHERE DemoCategory= ORDER BY DemoSubcategory,Priority DESC,DemoName;OUTPUT
eq ''>ADD ne ''>EDIT DEMOGRAPHIC -
Parents ne '0'>=$in{PName}>SELECT ContainerID CID,ParentLink PLk,Name PName FROM Container WHERE ContainerID=;OUTPUT CStream SELECT ContainerID CID,ParentLink PLk,Name PName FROM Container WHERE ContainerID=;OUTPUT CStream > ,Safe>
As of Date
 
Source


[Add New] Importing.. $in{FILE_DATA}=~s/\r\n/\n/g; $in{FILE_DATA}=~s/\r/\n/g; foreach $sptl (split("\n",$in{FILE_DATA})) { ($n1,$n2,$n3,$geoname,$p08,$p07,$p06,$p05,$p04,$p03,$p02,$p01,$p00,$e00,$c00,$rt,$rw,$rb,$ri,$ra,$rh,$r2,$amt,$am0,$am5,$am10,$am15,$am20,$am25,$am30,$am35,$am40,$am45,$am50,$am60,$am65,$am70,$am75,$am80,$am85,$aft,$af0,$af5,$af10,$af15,$af20,$af25,$af30,$af35,$af40,$af45,$af50,$af60,$af65,$af70,$af75,$af80,$af85)=split(/\|/,$sptl); ($ctyf,$state)=split(', ',$geoname); $cty=substr($ctyf,0,rindex($ctyf," ")); &SQLCmd(q!SELECT ContainerID StateID FROM Container WHERE ParentLink=1 AND Category='State' AND Name=!.&SQLEncode($state).q!;!); &SQLOutput(); $in{ImpErrs}.=$in{SQL_ERROR}; if ($in{SQL_NUMFOUND} ne '0E0') { &SQLCmd(q!SELECT ContainerID CListID FROM Container WHERE ParentLink=!.$in{StateID}.q! AND Category='County List';!); &SQLOutput(); $in{ImpErrs}.=$in{SQL_ERROR}; &SQLCmd(q!SELECT ContainerID CountyID FROM Container WHERE ParentLink=!.$in{CListID}.q! AND Category='County' AND Name=!.&SQLEncode($cty).q!;!); &SQLOutput(); $in{ImpErrs}.=$in{SQL_ERROR}; $in{NumCMatch}=$in{SQL_NUMFOUND}; if ($in{SQL_NUMFOUND} ne '0E0') { &SQLCmd(q!SELECT DemographicNumID FROM DemographicNum WHERE AttachTo='Container' AND AttachID=!.$in{CountyID}.q! AND YEAR(StartDate)=2008;!); &SQLOutput(); $in{ImpErrs}.=$in{SQL_ERROR}; if ($in{SQL_NUMFOUND} ne '0E0') { print $cty." ".$state." already Has 2008 Population - ".$in{NumCMatch}; } else { $p08=~s/\,//g; $in{NTSD}='0000-00-00'; &SQLCmd("SELECT StartDate NSTD FROM DemographicNum WHERE AttachID=".$in{CountyID}." AND DemographicLink=1 AND StartDate > '2008-07-01' ORDER BY StartDate LIMIT 1;"); &SQLOutput(); &SQLCmd("INSERT INTO DemographicNum (AttachTo,AttachID,StartDate,EndDate,Source,DemographicLink,DNumber,FirstBy,LMBy,LastModified) VALUES ('Container',".$in{CountyID}.",'2008-07-01','".$in{NSTD}."','US Census',1,".$p08.",1,1,Now());"); &SQLFinish(); $in{ImpErrs}.=$in{SQL_ERROR}; if ($in{SQL_INSERTID} > 0) { &SQLCmd("SELECT DemographicNumID OPRID FROM DemographicNum WHERE AttachID=".$in{CountyID}." AND DemographicLink=1 AND StartDate < '2008-07-01' ORDER BY StartDate DESC LIMIT 1;"); &SQLOutput(); if ($in{SQL_NUMFOUND} ne '0E0') { &SQLCmd("UPDATE DemographicNum SET EndDate='2008-07-01' WHERE DemographicNumID=".$in{OPRID}.";"); &SQLFinish(); } } } &SQLCmd(q!SELECT DemographicNumID FROM DemographicNum WHERE AttachTo='Container' AND AttachID=!.$in{CountyID}.q! AND YEAR(StartDate)=2000;!); &SQLOutput(); $in{ImpErrs}.=$in{SQL_ERROR}; if ($in{SQL_NUMFOUND} ne '0E0') { print $cty." ".$state." already Has 2000 Population - ".$in{NumCMatch}; } else { $c00=~s/\,//g; $in{NTSD}='0000-00-00'; &SQLCmd("SELECT StartDate NSTD FROM DemographicNum WHERE AttachID=".$in{CountyID}." AND DemographicLink=1 AND StartDate > '2000-07-01' ORDER BY StartDate LIMIT 1;"); &SQLOutput(); &SQLCmd("INSERT INTO DemographicNum (AttachTo,AttachID,StartDate,EndDate,Source,DemographicLink,DNumber,FirstBy,LMBy,LastModified) VALUES ('Container',".$in{CountyID}.",'2000-07-01','".$in{NSTD}."','US Census',1,".$c00.",1,1,Now());"); &SQLFinish(); $in{ImpErrs}.=$in{SQL_ERROR}; if ($in{SQL_INSERTID} > 0) { &SQLCmd("SELECT DemographicNumID OPRID FROM DemographicNum WHERE AttachID=".$in{CountyID}." AND DemographicLink=1 AND StartDate < '2000-07-01' ORDER BY StartDate DESC LIMIT 1;"); &SQLOutput(); if ($in{SQL_NUMFOUND} ne '0E0') { &SQLCmd("UPDATE DemographicNum SET EndDate='2000-07-01' WHERE DemographicNumID=".$in{OPRID}.";"); &SQLFinish(); } } } } else { print "No County ".$cty; } } else { print "No State ".$state; } print ". ".$in{NumCMatch}; } Importing.. SELECT ContainerID StateID FROM Container WHERE ParentLink=1 AND Category='State' AND Name=;OUTPUT NIL SELECT ContainerID CListID FROM Container WHERE ParentLink= AND Category='County List';OUTPUT NIL c SELECT ContainerID CountyID FROM Container WHERE ParentLink= AND Category='County';OUTPUT EachCounty $in{ImpErrs}.='Hi!
'; $in{FILE_DATA}=~s/\r\n/\n/g; $in{FILE_DATA}=~s/\r/\n/g; foreach $sptl (split("\n",$in{FILE_DATA})) { if (substr($sptl,0,1) eq '.') { ($geoname,$p08,$p07,$p06,$p05,$p04,$p03,$p02,$p01,$p00,$e00,$c00)=split(/\t/,$sptl); $geoname=substr($geoname,1); $city=substr($geoname,0,rindex($geoname," ")); &SQLCmd(q!SELECT ContainerID CityID FROM Container WHERE Name=!.&SQLEncode($city).q! AND ParentLink IN (!.$in{ctyl}.q!);!); &SQLOutput(); $in{ImpErrs}.=$in{SQL_ERROR}; $in{NumCMatch}=$in{SQL_NUMFOUND}; if ($in{SQL_NUMFOUND} ne '0E0') { &SQLCmd(q!SELECT DemographicNumID FROM DemographicNum WHERE AttachTo='Container' AND AttachID=!.$in{CityID}.q! AND DemographicLink=1 AND YEAR(StartDate)=2008;!); &SQLOutput(); $in{ImpErrs}.=$in{SQL_ERROR}; if ($in{SQL_NUMFOUND} ne '0E0') { $in{ImpErrs}.= $city." ".$state." already Has 2008 Population - ".$in{NumCMatch}."
"; $p08=~s/\,//g; $p08=~s/\"//g; &SQLCmd("UPDATE DemographicNum SET DNumber=".$p08.",LastModified=Now(),Source='US Census Estimate' WHERE DemographicNumID=".$in{DemographicNumID}.";"); &SQLFinish(); $in{ImpErrs}.=$in{SQL_ERROR}; } else { $p08=~s/\,//g; $p08=~s/\"//g; $in{NTSD}='0000-00-00'; &SQLCmd("SELECT StartDate NSTD FROM DemographicNum WHERE AttachID=".$in{CityID}." AND DemographicLink=1 AND StartDate > '2008-07-01' ORDER BY StartDate LIMIT 1;"); &SQLOutput(); &SQLCmd("INSERT INTO DemographicNum (AttachTo,AttachID,StartDate,EndDate,Source,DemographicLink,DNumber,FirstBy,LMBy,LastModified) VALUES ('Container',".$in{CityID}.",'2008-07-01','".$in{NSTD}."','US Census',1,".$p08.",1,1,Now());"); &SQLFinish(); $in{ImpErrs}.=$in{SQL_ERROR}; if ($in{SQL_INSERTID} > 0) { &SQLCmd("SELECT DemographicNumID OPRID FROM DemographicNum WHERE AttachID=".$in{CityID}." AND DemographicLink=1 AND StartDate < '2008-07-01' ORDER BY StartDate DESC LIMIT 1;"); &SQLOutput(); if ($in{SQL_NUMFOUND} ne '0E0') { &SQLCmd("UPDATE DemographicNum SET EndDate='2008-07-01' WHERE DemographicNumID=".$in{OPRID}.";"); &SQLFinish(); } } } &SQLCmd(q!SELECT DemographicNumID FROM DemographicNum WHERE AttachTo='Container' AND AttachID=!.$in{CityID}.q! AND DemographicLink=1 AND YEAR(StartDate)=2000;!); &SQLOutput(); $in{ImpErrs}.=$in{SQL_ERROR}; if ($in{SQL_NUMFOUND} ne '0E0') { $in{ImpErrs}.= $city." ".$state." already Has 2000 Population - ".$in{NumCMatch}."
"; $c00=~s/\,//g; $c00=~s/\"//g; $c00=$c00+0; &SQLCmd("UPDATE DemographicNum SET DNumber=".$c00.",LastModified=Now(),Source='US Census' WHERE DemographicNumID=".$in{DemographicNumID}.";"); &SQLFinish(); $in{ImpErrs}.=$in{SQL_ERROR}; } else { $c00=~s/\,//g; $c00=~s/\"//g; $in{NTSD}='0000-00-00'; &SQLCmd("SELECT StartDate NSTD FROM DemographicNum WHERE AttachID=".$in{CityID}." AND DemographicLink=1 AND StartDate > '2000-07-01' ORDER BY StartDate LIMIT 1;"); &SQLOutput(); &SQLCmd("INSERT INTO DemographicNum (AttachTo,AttachID,StartDate,EndDate,Source,DemographicLink,DNumber,FirstBy,LMBy,LastModified) VALUES ('Container',".$in{CityID}.",'2000-07-01','".$in{NSTD}."','US Census',1,".$c00.",1,1,Now());"); &SQLFinish(); $in{ImpErrs}.=$in{SQL_ERROR}; if ($in{SQL_INSERTID} > 0) { &SQLCmd("SELECT DemographicNumID OPRID FROM DemographicNum WHERE AttachID=".$in{CityID}." AND DemographicLink=1 AND StartDate < '2000-07-01' ORDER BY StartDate DESC LIMIT 1;"); &SQLOutput(); if ($in{SQL_NUMFOUND} ne '0E0') { &SQLCmd("UPDATE DemographicNum SET EndDate='2000-07-01' WHERE DemographicNumID=".$in{OPRID}.";"); &SQLFinish(); } } } } else { $in{ImpErrs}.= "No City ".$city.'
'; } $in{ImpErrs}.= ". ".$in{NumCMatch}; } } UPDATE DemographicNum SET EndDate='0000-00-00' where StartDate='2008-07-01' and EndDate='2008-07-01';FINISH Importing.. $in{ImpErrs}.='Hi!
'; $in{FILE_DATA}=~s/\r\n/\n/g; $in{FILE_DATA}=~s/\r/\n/g; foreach $sptl (split("\n",$in{FILE_DATA})) { ($geoname,$tpop,$urban,$rural,$black,$aindian,$asian,$hawaii,$other,$twomore,$hispanic,$white)=split(/\t/,$sptl); $geoname=~s/\"//g; $geoname=substr($geoname,23); $dist=substr($geoname,0,index($geoname," ")); $state=substr($geoname,rindex($geoname,",")+2); if ($dist eq '(at' || $dist eq 'arge)') { $dist=1; } if ($state eq 'Hawaii') { $state="Hawai'i"; } &SQLCmd(q!SELECT ContainerID StateID FROM Container WHERE Category='State' AND Name=!.&SQLEncode($state).q! AND ParentLink=1;!); &SQLOutput(); $in{ImpErrs}.=$in{SQL_ERROR}; $in{NumSMatch}=$in{SQL_NUMFOUND}; if ($in{NumSMatch} ne '0E0') { &SQLCmd(q!SELECT ContainerID DistrictID FROM Container WHERE Category='House of Representatives' AND RefNum=!.&SQLEncode($dist).q! AND ParentLink=!.$in{StateID}.';'); &SQLOutput(); $in{ImpErrs}.=$in{SQL_ERROR}; $in{NumDMatch}=$in{SQL_NUMFOUND}; if ($in{NumDMatch} ne '0E0') { &SQLCmd(q!SELECT DemographicNumID FROM DemographicNum WHERE AttachTo='Container' AND AttachID=!.$in{DistrictID}.q! AND DemographicLink=1 AND YEAR(StartDate)=2000;!); &SQLOutput(); $in{ImpErrs}.=$in{SQL_ERROR}; if ($in{SQL_NUMFOUND} ne '0E0') { $in{ImpErrs}.= $state." ".$dist." already Has 2000 Population - ".$in{NumCMatch}."
"; &SQLCmd("UPDATE DemographicNum SET DNumber=".$tpop.",LastModified=Now(),Source='US Census' WHERE DemographicNumID=".$in{DemographicNumID}.";"); &SQLFinish(); $in{ImpErrs}.=$in{SQL_ERROR}; } else { $in{NTSD}='0000-00-00'; &SQLCmd("SELECT StartDate NSTD FROM DemographicNum WHERE AttachID=".$in{DistrictID}." AND DemographicLink=1 AND StartDate > '2000-07-01' ORDER BY StartDate LIMIT 1;"); &SQLOutput(); &SQLCmd("INSERT INTO DemographicNum (AttachTo,AttachID,StartDate,EndDate,Source,DemographicLink,DNumber,FirstBy,LMBy,LastModified) VALUES ('Container',".$in{DistrictID}.",'2000-07-01','".$in{NSTD}."','US Census',1,".$tpop.",1,1,Now());"); &SQLFinish(); $in{ImpErrs}.=$in{SQL_ERROR}; if ($in{SQL_INSERTID} > 0) { &SQLCmd("SELECT DemographicNumID OPRID FROM DemographicNum WHERE AttachID=".$in{DistrictID}." AND DemographicLink=1 AND StartDate < '2000-07-01' ORDER BY StartDate DESC LIMIT 1;"); &SQLOutput(); if ($in{SQL_NUMFOUND} ne '0E0') { &SQLCmd("UPDATE DemographicNum SET EndDate='2000-07-01' WHERE DemographicNumID=".$in{OPRID}.";"); &SQLFinish(); } } } &SQLCmd(q!SELECT DemographicNumID FROM DemographicNum WHERE AttachTo='Container' AND AttachID=!.$in{DistrictID}.q! AND DemographicLink=104 AND YEAR(StartDate)=2000;!); &SQLOutput(); $in{ImpErrs}.=$in{SQL_ERROR}; if ($in{SQL_NUMFOUND} ne '0E0') { $in{ImpErrs}.= $state." ".$dist." already Has 2000 Urban - ".$in{NumCMatch}."
"; &SQLCmd("UPDATE DemographicNum SET DNumber=".$urban.",LastModified=Now(),Source='US Census' WHERE DemographicNumID=".$in{DemographicNumID}.";"); &SQLFinish(); $in{ImpErrs}.=$in{SQL_ERROR}; } else { $in{NTSD}='0000-00-00'; &SQLCmd("SELECT StartDate NSTD FROM DemographicNum WHERE AttachID=".$in{DistrictID}." AND DemographicLink=104 AND StartDate > '2000-07-01' ORDER BY StartDate LIMIT 1;"); &SQLOutput(); &SQLCmd("INSERT INTO DemographicNum (AttachTo,AttachID,StartDate,EndDate,Source,DemographicLink,DNumber,FirstBy,LMBy,LastModified) VALUES ('Container',".$in{DistrictID}.",'2000-07-01','".$in{NSTD}."','US Census',104,".$urban.",1,1,Now());"); &SQLFinish(); $in{ImpErrs}.=$in{SQL_ERROR}; if ($in{SQL_INSERTID} > 0) { &SQLCmd("SELECT DemographicNumID OPRID FROM DemographicNum WHERE AttachID=".$in{DistrictID}." AND DemographicLink=104 AND StartDate < '2000-07-01' ORDER BY StartDate DESC LIMIT 1;"); &SQLOutput(); if ($in{SQL_NUMFOUND} ne '0E0') { &SQLCmd("UPDATE DemographicNum SET EndDate='2000-07-01' WHERE DemographicNumID=".$in{OPRID}.";"); &SQLFinish(); } } } &SQLCmd(q!SELECT DemographicNumID FROM DemographicNum WHERE AttachTo='Container' AND AttachID=!.$in{DistrictID}.q! AND DemographicLink=105 AND YEAR(StartDate)=2000;!); &SQLOutput(); $in{ImpErrs}.=$in{SQL_ERROR}; if ($in{SQL_NUMFOUND} ne '0E0') { $in{ImpErrs}.= $state." ".$dist." already Has 2000 Rural - ".$in{NumCMatch}."
"; &SQLCmd("UPDATE DemographicNum SET DNumber=".$rural.",LastModified=Now(),Source='US Census' WHERE DemographicNumID=".$in{DemographicNumID}.";"); &SQLFinish(); $in{ImpErrs}.=$in{SQL_ERROR}; } else { $in{NTSD}='0000-00-00'; &SQLCmd("SELECT StartDate NSTD FROM DemographicNum WHERE AttachID=".$in{DistrictID}." AND DemographicLink=105 AND StartDate > '2000-07-01' ORDER BY StartDate LIMIT 1;"); &SQLOutput(); &SQLCmd("INSERT INTO DemographicNum (AttachTo,AttachID,StartDate,EndDate,Source,DemographicLink,DNumber,FirstBy,LMBy,LastModified) VALUES ('Container',".$in{DistrictID}.",'2000-07-01','".$in{NSTD}."','US Census',105,".$rural.",1,1,Now());"); &SQLFinish(); $in{ImpErrs}.=$in{SQL_ERROR}; if ($in{SQL_INSERTID} > 0) { &SQLCmd("SELECT DemographicNumID OPRID FROM DemographicNum WHERE AttachID=".$in{DistrictID}." AND DemographicLink=105 AND StartDate < '2000-07-01' ORDER BY StartDate DESC LIMIT 1;"); &SQLOutput(); if ($in{SQL_NUMFOUND} ne '0E0') { &SQLCmd("UPDATE DemographicNum SET EndDate='2000-07-01' WHERE DemographicNumID=".$in{OPRID}.";"); &SQLFinish(); } } } &SQLCmd(q!SELECT DemographicNumID FROM DemographicNum WHERE AttachTo='Container' AND AttachID=!.$in{DistrictID}.q! AND DemographicLink=3 AND YEAR(StartDate)=2000;!); &SQLOutput(); $in{ImpErrs}.=$in{SQL_ERROR}; if ($in{SQL_NUMFOUND} ne '0E0') { $in{ImpErrs}.= $state." ".$dist." already Has 2000 white - ".$in{NumCMatch}."
"; &SQLCmd("UPDATE DemographicNum SET DNumber=".$white.",LastModified=Now(),Source='US Census' WHERE DemographicNumID=".$in{DemographicNumID}.";"); &SQLFinish(); $in{ImpErrs}.=$in{SQL_ERROR}; } else { $in{NTSD}='0000-00-00'; &SQLCmd("SELECT StartDate NSTD FROM DemographicNum WHERE AttachID=".$in{DistrictID}." AND DemographicLink=3 AND StartDate > '2000-07-01' ORDER BY StartDate LIMIT 1;"); &SQLOutput(); &SQLCmd("INSERT INTO DemographicNum (AttachTo,AttachID,StartDate,EndDate,Source,DemographicLink,DNumber,FirstBy,LMBy,LastModified) VALUES ('Container',".$in{DistrictID}.",'2000-07-01','".$in{NSTD}."','US Census',3,".$white.",1,1,Now());"); &SQLFinish(); $in{ImpErrs}.=$in{SQL_ERROR}; if ($in{SQL_INSERTID} > 0) { &SQLCmd("SELECT DemographicNumID OPRID FROM DemographicNum WHERE AttachID=".$in{DistrictID}." AND DemographicLink=3 AND StartDate < '2000-07-01' ORDER BY StartDate DESC LIMIT 1;"); &SQLOutput(); if ($in{SQL_NUMFOUND} ne '0E0') { &SQLCmd("UPDATE DemographicNum SET EndDate='2000-07-01' WHERE DemographicNumID=".$in{OPRID}.";"); &SQLFinish(); } } } &SQLCmd(q!SELECT DemographicNumID FROM DemographicNum WHERE AttachTo='Container' AND AttachID=!.$in{DistrictID}.q! AND DemographicLink=100 AND YEAR(StartDate)=2000;!); &SQLOutput(); $in{ImpErrs}.=$in{SQL_ERROR}; if ($in{SQL_NUMFOUND} ne '0E0') { $in{ImpErrs}.= $state." ".$dist." already Has 2000 hispanic - ".$in{NumCMatch}."
"; &SQLCmd("UPDATE DemographicNum SET DNumber=".$hispanic.",LastModified=Now(),Source='US Census' WHERE DemographicNumID=".$in{DemographicNumID}.";"); &SQLFinish(); $in{ImpErrs}.=$in{SQL_ERROR}; } else { $in{NTSD}='0000-00-00'; &SQLCmd("SELECT StartDate NSTD FROM DemographicNum WHERE AttachID=".$in{DistrictID}." AND DemographicLink=100 AND StartDate > '2000-07-01' ORDER BY StartDate LIMIT 1;"); &SQLOutput(); &SQLCmd("INSERT INTO DemographicNum (AttachTo,AttachID,StartDate,EndDate,Source,DemographicLink,DNumber,FirstBy,LMBy,LastModified) VALUES ('Container',".$in{DistrictID}.",'2000-07-01','".$in{NSTD}."','US Census',100,".$hispanic.",1,1,Now());"); &SQLFinish(); $in{ImpErrs}.=$in{SQL_ERROR}; if ($in{SQL_INSERTID} > 0) { &SQLCmd("SELECT DemographicNumID OPRID FROM DemographicNum WHERE AttachID=".$in{DistrictID}." AND DemographicLink=100 AND StartDate < '2000-07-01' ORDER BY StartDate DESC LIMIT 1;"); &SQLOutput(); if ($in{SQL_NUMFOUND} ne '0E0') { &SQLCmd("UPDATE DemographicNum SET EndDate='2000-07-01' WHERE DemographicNumID=".$in{OPRID}.";"); &SQLFinish(); } } } &SQLCmd(q!SELECT DemographicNumID FROM DemographicNum WHERE AttachTo='Container' AND AttachID=!.$in{DistrictID}.q! AND DemographicLink=29 AND YEAR(StartDate)=2000;!); &SQLOutput(); $in{ImpErrs}.=$in{SQL_ERROR}; if ($in{SQL_NUMFOUND} ne '0E0') { $in{ImpErrs}.= $state." ".$dist." already Has 2000 black - ".$in{NumCMatch}."
"; &SQLCmd("UPDATE DemographicNum SET DNumber=".$black.",LastModified=Now(),Source='US Census' WHERE DemographicNumID=".$in{DemographicNumID}.";"); &SQLFinish(); $in{ImpErrs}.=$in{SQL_ERROR}; } else { $in{NTSD}='0000-00-00'; &SQLCmd("SELECT StartDate NSTD FROM DemographicNum WHERE AttachID=".$in{DistrictID}." AND DemographicLink=29 AND StartDate > '2000-07-01' ORDER BY StartDate LIMIT 1;"); &SQLOutput(); &SQLCmd("INSERT INTO DemographicNum (AttachTo,AttachID,StartDate,EndDate,Source,DemographicLink,DNumber,FirstBy,LMBy,LastModified) VALUES ('Container',".$in{DistrictID}.",'2000-07-01','".$in{NSTD}."','US Census',29,".$black.",1,1,Now());"); &SQLFinish(); $in{ImpErrs}.=$in{SQL_ERROR}; if ($in{SQL_INSERTID} > 0) { &SQLCmd("SELECT DemographicNumID OPRID FROM DemographicNum WHERE AttachID=".$in{DistrictID}." AND DemographicLink=29 AND StartDate < '2000-07-01' ORDER BY StartDate DESC LIMIT 1;"); &SQLOutput(); if ($in{SQL_NUMFOUND} ne '0E0') { &SQLCmd("UPDATE DemographicNum SET EndDate='2000-07-01' WHERE DemographicNumID=".$in{OPRID}.";"); &SQLFinish(); } } } &SQLCmd(q!SELECT DemographicNumID FROM DemographicNum WHERE AttachTo='Container' AND AttachID=!.$in{DistrictID}.q! AND DemographicLink=30 AND YEAR(StartDate)=2000;!); &SQLOutput(); $in{ImpErrs}.=$in{SQL_ERROR}; if ($in{SQL_NUMFOUND} ne '0E0') { $in{ImpErrs}.= $state." ".$dist." already Has 2000 aindian - ".$in{NumCMatch}."
"; &SQLCmd("UPDATE DemographicNum SET DNumber=".$aindian.",LastModified=Now(),Source='US Census' WHERE DemographicNumID=".$in{DemographicNumID}.";"); &SQLFinish(); $in{ImpErrs}.=$in{SQL_ERROR}; } else { $in{NTSD}='0000-00-00'; &SQLCmd("SELECT StartDate NSTD FROM DemographicNum WHERE AttachID=".$in{DistrictID}." AND DemographicLink=30 AND StartDate > '2000-07-01' ORDER BY StartDate LIMIT 1;"); &SQLOutput(); &SQLCmd("INSERT INTO DemographicNum (AttachTo,AttachID,StartDate,EndDate,Source,DemographicLink,DNumber,FirstBy,LMBy,LastModified) VALUES ('Container',".$in{DistrictID}.",'2000-07-01','".$in{NSTD}."','US Census',30,".$aindian.",1,1,Now());"); &SQLFinish(); $in{ImpErrs}.=$in{SQL_ERROR}; if ($in{SQL_INSERTID} > 0) { &SQLCmd("SELECT DemographicNumID OPRID FROM DemographicNum WHERE AttachID=".$in{DistrictID}." AND DemographicLink=30 AND StartDate < '2000-07-01' ORDER BY StartDate DESC LIMIT 1;"); &SQLOutput(); if ($in{SQL_NUMFOUND} ne '0E0') { &SQLCmd("UPDATE DemographicNum SET EndDate='2000-07-01' WHERE DemographicNumID=".$in{OPRID}.";"); &SQLFinish(); } } } &SQLCmd(q!SELECT DemographicNumID FROM DemographicNum WHERE AttachTo='Container' AND AttachID=!.$in{DistrictID}.q! AND DemographicLink=103 AND YEAR(StartDate)=2000;!); &SQLOutput(); $in{ImpErrs}.=$in{SQL_ERROR}; if ($in{SQL_NUMFOUND} ne '0E0') { $in{ImpErrs}.= $state." ".$dist." already Has 2000 asian - ".$in{NumCMatch}."
"; &SQLCmd("UPDATE DemographicNum SET DNumber=".$asian.",LastModified=Now(),Source='US Census' WHERE DemographicNumID=".$in{DemographicNumID}.";"); &SQLFinish(); $in{ImpErrs}.=$in{SQL_ERROR}; } else { $in{NTSD}='0000-00-00'; &SQLCmd("SELECT StartDate NSTD FROM DemographicNum WHERE AttachID=".$in{DistrictID}." AND DemographicLink=103 AND StartDate > '2000-07-01' ORDER BY StartDate LIMIT 1;"); &SQLOutput(); &SQLCmd("INSERT INTO DemographicNum (AttachTo,AttachID,StartDate,EndDate,Source,DemographicLink,DNumber,FirstBy,LMBy,LastModified) VALUES ('Container',".$in{DistrictID}.",'2000-07-01','".$in{NSTD}."','US Census',103,".$asian.",1,1,Now());"); &SQLFinish(); $in{ImpErrs}.=$in{SQL_ERROR}; if ($in{SQL_INSERTID} > 0) { &SQLCmd("SELECT DemographicNumID OPRID FROM DemographicNum WHERE AttachID=".$in{DistrictID}." AND DemographicLink=103 AND StartDate < '2000-07-01' ORDER BY StartDate DESC LIMIT 1;"); &SQLOutput(); if ($in{SQL_NUMFOUND} ne '0E0') { &SQLCmd("UPDATE DemographicNum SET EndDate='2000-07-01' WHERE DemographicNumID=".$in{OPRID}.";"); &SQLFinish(); } } } &SQLCmd(q!SELECT DemographicNumID FROM DemographicNum WHERE AttachTo='Container' AND AttachID=!.$in{DistrictID}.q! AND DemographicLink=102 AND YEAR(StartDate)=2000;!); &SQLOutput(); $in{ImpErrs}.=$in{SQL_ERROR}; if ($in{SQL_NUMFOUND} ne '0E0') { $in{ImpErrs}.= $state." ".$dist." already Has 2000 hawaii - ".$in{NumCMatch}."
"; &SQLCmd("UPDATE DemographicNum SET DNumber=".$hawaii.",LastModified=Now(),Source='US Census' WHERE DemographicNumID=".$in{DemographicNumID}.";"); &SQLFinish(); $in{ImpErrs}.=$in{SQL_ERROR}; } else { $in{NTSD}='0000-00-00'; &SQLCmd("SELECT StartDate NSTD FROM DemographicNum WHERE AttachID=".$in{DistrictID}." AND DemographicLink=102 AND StartDate > '2000-07-01' ORDER BY StartDate LIMIT 1;"); &SQLOutput(); &SQLCmd("INSERT INTO DemographicNum (AttachTo,AttachID,StartDate,EndDate,Source,DemographicLink,DNumber,FirstBy,LMBy,LastModified) VALUES ('Container',".$in{DistrictID}.",'2000-07-01','".$in{NSTD}."','US Census',102,".$hawaii.",1,1,Now());"); &SQLFinish(); $in{ImpErrs}.=$in{SQL_ERROR}; if ($in{SQL_INSERTID} > 0) { &SQLCmd("SELECT DemographicNumID OPRID FROM DemographicNum WHERE AttachID=".$in{DistrictID}." AND DemographicLink=102 AND StartDate < '2000-07-01' ORDER BY StartDate DESC LIMIT 1;"); &SQLOutput(); if ($in{SQL_NUMFOUND} ne '0E0') { &SQLCmd("UPDATE DemographicNum SET EndDate='2000-07-01' WHERE DemographicNumID=".$in{OPRID}.";"); &SQLFinish(); } } } &SQLCmd(q!SELECT DemographicNumID FROM DemographicNum WHERE AttachTo='Container' AND AttachID=!.$in{DistrictID}.q! AND DemographicLink=42 AND YEAR(StartDate)=2000;!); &SQLOutput(); $in{ImpErrs}.=$in{SQL_ERROR}; if ($in{SQL_NUMFOUND} ne '0E0') { $in{ImpErrs}.= $state." ".$dist." already Has 2000 other - ".$in{NumCMatch}."
"; &SQLCmd("UPDATE DemographicNum SET DNumber=".$other.",LastModified=Now(),Source='US Census' WHERE DemographicNumID=".$in{DemographicNumID}.";"); &SQLFinish(); $in{ImpErrs}.=$in{SQL_ERROR}; } else { $in{NTSD}='0000-00-00'; &SQLCmd("SELECT StartDate NSTD FROM DemographicNum WHERE AttachID=".$in{DistrictID}." AND DemographicLink=42 AND StartDate > '2000-07-01' ORDER BY StartDate LIMIT 1;"); &SQLOutput(); &SQLCmd("INSERT INTO DemographicNum (AttachTo,AttachID,StartDate,EndDate,Source,DemographicLink,DNumber,FirstBy,LMBy,LastModified) VALUES ('Container',".$in{DistrictID}.",'2000-07-01','".$in{NSTD}."','US Census',42,".$other.",1,1,Now());"); &SQLFinish(); $in{ImpErrs}.=$in{SQL_ERROR}; if ($in{SQL_INSERTID} > 0) { &SQLCmd("SELECT DemographicNumID OPRID FROM DemographicNum WHERE AttachID=".$in{DistrictID}." AND DemographicLink=42 AND StartDate < '2000-07-01' ORDER BY StartDate DESC LIMIT 1;"); &SQLOutput(); if ($in{SQL_NUMFOUND} ne '0E0') { &SQLCmd("UPDATE DemographicNum SET EndDate='2000-07-01' WHERE DemographicNumID=".$in{OPRID}.";"); &SQLFinish(); } } } &SQLCmd(q!SELECT DemographicNumID FROM DemographicNum WHERE AttachTo='Container' AND AttachID=!.$in{DistrictID}.q! AND DemographicLink=43 AND YEAR(StartDate)=2000;!); &SQLOutput(); $in{ImpErrs}.=$in{SQL_ERROR}; if ($in{SQL_NUMFOUND} ne '0E0') { $in{ImpErrs}.= $state." ".$dist." already Has 2000 twomore - ".$in{NumCMatch}."
"; &SQLCmd("UPDATE DemographicNum SET DNumber=".$twomore.",LastModified=Now(),Source='US Census' WHERE DemographicNumID=".$in{DemographicNumID}.";"); &SQLFinish(); $in{ImpErrs}.=$in{SQL_ERROR}; } else { $in{NTSD}='0000-00-00'; &SQLCmd("SELECT StartDate NSTD FROM DemographicNum WHERE AttachID=".$in{DistrictID}." AND DemographicLink=43 AND StartDate > '2000-07-01' ORDER BY StartDate LIMIT 1;"); &SQLOutput(); &SQLCmd("INSERT INTO DemographicNum (AttachTo,AttachID,StartDate,EndDate,Source,DemographicLink,DNumber,FirstBy,LMBy,LastModified) VALUES ('Container',".$in{DistrictID}.",'2000-07-01','".$in{NSTD}."','US Census',43,".$twomore.",1,1,Now());"); &SQLFinish(); $in{ImpErrs}.=$in{SQL_ERROR}; if ($in{SQL_INSERTID} > 0) { &SQLCmd("SELECT DemographicNumID OPRID FROM DemographicNum WHERE AttachID=".$in{DistrictID}." AND DemographicLink=43 AND StartDate < '2000-07-01' ORDER BY StartDate DESC LIMIT 1;"); &SQLOutput(); if ($in{SQL_NUMFOUND} ne '0E0') { &SQLCmd("UPDATE DemographicNum SET EndDate='2000-07-01' WHERE DemographicNumID=".$in{OPRID}.";"); &SQLFinish(); } } } } else { $in{ImpErrs}.= "No District |".$state.$dist.'|
'; } } else { $in{ImpErrs}.= "No State |".$state.'|
'; } $in{ImpErrs}.= ". ".$in{NumSMatch}; } Importing.. $in{ImpErrs}.='Hi!
'; $in{FILE_DATA}=~s/\r\n/\n/g; $in{FILE_DATA}=~s/\r/\n/g; foreach $sptl (split("\n",$in{FILE_DATA})) { ($geoname,$male,$ml5,$m5t9,$m10t14,$m15t17,$m18t19,$m20,$m21,$m22t24,$m25t29,$m30t34,$m35t39,$m40t44,$m45t49,$m50t54,$m55t59,$m60t61,$m62t64,$m65t66,$m67t69,$m70t74,$m75t79,$m80t84,$m85p,$fem,$fl5,$f5t9,$f10t14,$f15t17,$f18t19,$f20,$f21,$f22t24,$f25t29,$f30t34,$f35t39,$f40t44,$f45t49,$f50t54,$f55t59,$f60t61,$f62t64,$f65t66,$f67t69,$f70t74,$f75t79,$f80t84,$f85p)=split(/\t/,$sptl); $geoname=~s/\"//g; $geoname=substr($geoname,23); $dist=substr($geoname,0,index($geoname," ")); $state=substr($geoname,rindex($geoname,",")+2); if ($dist eq '(at' || $dist eq 'arge)') { $dist=1; } if ($state eq 'Hawaii') { $state="Hawai'i"; } &SQLCmd(q!SELECT ContainerID StateID FROM Container WHERE Category='State' AND Name=!.&SQLEncode($state).q! AND ParentLink=1;!); &SQLOutput(); $in{ImpErrs}.=$in{SQL_ERROR}; $in{NumSMatch}=$in{SQL_NUMFOUND}; if ($in{NumSMatch} ne '0E0') { &SQLCmd(q!SELECT ContainerID DistrictID FROM Container WHERE Category='House of Representatives' AND RefNum=!.&SQLEncode($dist).q! AND ParentLink=!.$in{StateID}.';'); &SQLOutput(); $in{ImpErrs}.=$in{SQL_ERROR}; $in{NumDMatch}=$in{SQL_NUMFOUND}; if ($in{NumDMatch} ne '0E0') { &SQLCmd(q!SELECT DemographicNumID FROM DemographicNum WHERE AttachTo='Container' AND AttachID=!.$in{DistrictID}.q! AND DemographicLink=5 AND YEAR(StartDate)=2000;!); &SQLOutput(); $in{ImpErrs}.=$in{SQL_ERROR}; if ($in{SQL_NUMFOUND} ne '0E0') { $in{ImpErrs}.= $state." ".$dist." already Has 2000 male - ".$in{NumCMatch}."
"; &SQLCmd("UPDATE DemographicNum SET DNumber=".$male.",LastModified=Now(),Source='US Census' WHERE DemographicNumID=".$in{DemographicNumID}.";"); &SQLFinish(); $in{ImpErrs}.=$in{SQL_ERROR}; } else { $in{NTSD}='0000-00-00'; &SQLCmd("SELECT StartDate NSTD FROM DemographicNum WHERE AttachID=".$in{DistrictID}." AND DemographicLink=5 AND StartDate > '2000-07-01' ORDER BY StartDate LIMIT 1;"); &SQLOutput(); &SQLCmd("INSERT INTO DemographicNum (AttachTo,AttachID,StartDate,EndDate,Source,DemographicLink,DNumber,FirstBy,LMBy,LastModified) VALUES ('Container',".$in{DistrictID}.",'2000-07-01','".$in{NSTD}."','US Census',5,".$male.",1,1,Now());"); &SQLFinish(); $in{ImpErrs}.=$in{SQL_ERROR}; if ($in{SQL_INSERTID} > 0) { &SQLCmd("SELECT DemographicNumID OPRID FROM DemographicNum WHERE AttachID=".$in{DistrictID}." AND DemographicLink=5 AND StartDate < '2000-07-01' ORDER BY StartDate DESC LIMIT 1;"); &SQLOutput(); if ($in{SQL_NUMFOUND} ne '0E0') { &SQLCmd("UPDATE DemographicNum SET EndDate='2000-07-01' WHERE DemographicNumID=".$in{OPRID}.";"); &SQLFinish(); } } } &SQLCmd(q!SELECT DemographicNumID FROM DemographicNum WHERE AttachTo='Container' AND AttachID=!.$in{DistrictID}.q! AND DemographicLink=6 AND YEAR(StartDate)=2000;!); &SQLOutput(); $in{ImpErrs}.=$in{SQL_ERROR}; if ($in{SQL_NUMFOUND} ne '0E0') { $in{ImpErrs}.= $state." ".$dist." already Has 2000 female - ".$in{NumCMatch}."
"; &SQLCmd("UPDATE DemographicNum SET DNumber=".$fem.",LastModified=Now(),Source='US Census' WHERE DemographicNumID=".$in{DemographicNumID}.";"); &SQLFinish(); $in{ImpErrs}.=$in{SQL_ERROR}; } else { $in{NTSD}='0000-00-00'; &SQLCmd("SELECT StartDate NSTD FROM DemographicNum WHERE AttachID=".$in{DistrictID}." AND DemographicLink=6 AND StartDate > '2000-07-01' ORDER BY StartDate LIMIT 1;"); &SQLOutput(); &SQLCmd("INSERT INTO DemographicNum (AttachTo,AttachID,StartDate,EndDate,Source,DemographicLink,DNumber,FirstBy,LMBy,LastModified) VALUES ('Container',".$in{DistrictID}.",'2000-07-01','".$in{NSTD}."','US Census',6,".$fem.",1,1,Now());"); &SQLFinish(); $in{ImpErrs}.=$in{SQL_ERROR}; if ($in{SQL_INSERTID} > 0) { &SQLCmd("SELECT DemographicNumID OPRID FROM DemographicNum WHERE AttachID=".$in{DistrictID}." AND DemographicLink=6 AND StartDate < '2000-07-01' ORDER BY StartDate DESC LIMIT 1;"); &SQLOutput(); if ($in{SQL_NUMFOUND} ne '0E0') { &SQLCmd("UPDATE DemographicNum SET EndDate='2000-07-01' WHERE DemographicNumID=".$in{OPRID}.";"); &SQLFinish(); } } } &SQLCmd(q!SELECT DemographicNumID FROM DemographicNum WHERE AttachTo='Container' AND AttachID=!.$in{DistrictID}.q! AND DemographicLink=4 AND YEAR(StartDate)=2000;!); &SQLOutput(); $in{ImpErrs}.=$in{SQL_ERROR}; if ($in{SQL_NUMFOUND} ne '0E0') { $in{ImpErrs}.= $state." ".$dist." already Has 2000 less than 5 - ".$in{NumCMatch}."
"; &SQLCmd("UPDATE DemographicNum SET DNumber=".($ml5+$fl5).",LastModified=Now(),Source='US Census' WHERE DemographicNumID=".$in{DemographicNumID}.";"); &SQLFinish(); $in{ImpErrs}.=$in{SQL_ERROR}; } else { $in{NTSD}='0000-00-00'; &SQLCmd("SELECT StartDate NSTD FROM DemographicNum WHERE AttachID=".$in{DistrictID}." AND DemographicLink=4 AND StartDate > '2000-07-01' ORDER BY StartDate LIMIT 1;"); &SQLOutput(); &SQLCmd("INSERT INTO DemographicNum (AttachTo,AttachID,StartDate,EndDate,Source,DemographicLink,DNumber,FirstBy,LMBy,LastModified) VALUES ('Container',".$in{DistrictID}.",'2000-07-01','".$in{NSTD}."','US Census',4,".($ml5+$fl5).",1,1,Now());"); &SQLFinish(); $in{ImpErrs}.=$in{SQL_ERROR}; if ($in{SQL_INSERTID} > 0) { &SQLCmd("SELECT DemographicNumID OPRID FROM DemographicNum WHERE AttachID=".$in{DistrictID}." AND DemographicLink=4 AND StartDate < '2000-07-01' ORDER BY StartDate DESC LIMIT 1;"); &SQLOutput(); if ($in{SQL_NUMFOUND} ne '0E0') { &SQLCmd("UPDATE DemographicNum SET EndDate='2000-07-01' WHERE DemographicNumID=".$in{OPRID}.";"); &SQLFinish(); } } } &SQLCmd(q!SELECT DemographicNumID FROM DemographicNum WHERE AttachTo='Container' AND AttachID=!.$in{DistrictID}.q! AND DemographicLink=7 AND YEAR(StartDate)=2000;!); &SQLOutput(); $in{ImpErrs}.=$in{SQL_ERROR}; if ($in{SQL_NUMFOUND} ne '0E0') { $in{ImpErrs}.= $state." ".$dist." already Has 2000 5-9 - ".$in{NumCMatch}."
"; &SQLCmd("UPDATE DemographicNum SET DNumber=".($m5t9+$f5t9).",LastModified=Now(),Source='US Census' WHERE DemographicNumID=".$in{DemographicNumID}.";"); &SQLFinish(); $in{ImpErrs}.=$in{SQL_ERROR}; } else { $in{NTSD}='0000-00-00'; &SQLCmd("SELECT StartDate NSTD FROM DemographicNum WHERE AttachID=".$in{DistrictID}." AND DemographicLink=7 AND StartDate > '2000-07-01' ORDER BY StartDate LIMIT 1;"); &SQLOutput(); &SQLCmd("INSERT INTO DemographicNum (AttachTo,AttachID,StartDate,EndDate,Source,DemographicLink,DNumber,FirstBy,LMBy,LastModified) VALUES ('Container',".$in{DistrictID}.",'2000-07-01','".$in{NSTD}."','US Census',7,".($m5t9+$f5t9).",1,1,Now());"); &SQLFinish(); $in{ImpErrs}.=$in{SQL_ERROR}; if ($in{SQL_INSERTID} > 0) { &SQLCmd("SELECT DemographicNumID OPRID FROM DemographicNum WHERE AttachID=".$in{DistrictID}." AND DemographicLink=7 AND StartDate < '2000-07-01' ORDER BY StartDate DESC LIMIT 1;"); &SQLOutput(); if ($in{SQL_NUMFOUND} ne '0E0') { &SQLCmd("UPDATE DemographicNum SET EndDate='2000-07-01' WHERE DemographicNumID=".$in{OPRID}.";"); &SQLFinish(); } } } &SQLCmd(q!SELECT DemographicNumID FROM DemographicNum WHERE AttachTo='Container' AND AttachID=!.$in{DistrictID}.q! AND DemographicLink=8 AND YEAR(StartDate)=2000;!); &SQLOutput(); $in{ImpErrs}.=$in{SQL_ERROR}; if ($in{SQL_NUMFOUND} ne '0E0') { $in{ImpErrs}.= $state." ".$dist." already Has 2000 10-14 - ".$in{NumCMatch}."
"; &SQLCmd("UPDATE DemographicNum SET DNumber=".($m10t14+$f10t14).",LastModified=Now(),Source='US Census' WHERE DemographicNumID=".$in{DemographicNumID}.";"); &SQLFinish(); $in{ImpErrs}.=$in{SQL_ERROR}; } else { $in{NTSD}='0000-00-00'; &SQLCmd("SELECT StartDate NSTD FROM DemographicNum WHERE AttachID=".$in{DistrictID}." AND DemographicLink=8 AND StartDate > '2000-07-01' ORDER BY StartDate LIMIT 1;"); &SQLOutput(); &SQLCmd("INSERT INTO DemographicNum (AttachTo,AttachID,StartDate,EndDate,Source,DemographicLink,DNumber,FirstBy,LMBy,LastModified) VALUES ('Container',".$in{DistrictID}.",'2000-07-01','".$in{NSTD}."','US Census',8,".($m10t14+$f10t14).",1,1,Now());"); &SQLFinish(); $in{ImpErrs}.=$in{SQL_ERROR}; if ($in{SQL_INSERTID} > 0) { &SQLCmd("SELECT DemographicNumID OPRID FROM DemographicNum WHERE AttachID=".$in{DistrictID}." AND DemographicLink=8 AND StartDate < '2000-07-01' ORDER BY StartDate DESC LIMIT 1;"); &SQLOutput(); if ($in{SQL_NUMFOUND} ne '0E0') { &SQLCmd("UPDATE DemographicNum SET EndDate='2000-07-01' WHERE DemographicNumID=".$in{OPRID}.";"); &SQLFinish(); } } } &SQLCmd(q!SELECT DemographicNumID FROM DemographicNum WHERE AttachTo='Container' AND AttachID=!.$in{DistrictID}.q! AND DemographicLink=9 AND YEAR(StartDate)=2000;!); &SQLOutput(); $in{ImpErrs}.=$in{SQL_ERROR}; if ($in{SQL_NUMFOUND} ne '0E0') { $in{ImpErrs}.= $state." ".$dist." already Has 2000 15-19 - ".$in{NumCMatch}."
"; &SQLCmd("UPDATE DemographicNum SET DNumber=".($m15t17+$m18t19+$f15t17+$f18t19).",LastModified=Now(),Source='US Census' WHERE DemographicNumID=".$in{DemographicNumID}.";"); &SQLFinish(); $in{ImpErrs}.=$in{SQL_ERROR}; } else { $in{NTSD}='0000-00-00'; &SQLCmd("SELECT StartDate NSTD FROM DemographicNum WHERE AttachID=".$in{DistrictID}." AND DemographicLink=9 AND StartDate > '2000-07-01' ORDER BY StartDate LIMIT 1;"); &SQLOutput(); &SQLCmd("INSERT INTO DemographicNum (AttachTo,AttachID,StartDate,EndDate,Source,DemographicLink,DNumber,FirstBy,LMBy,LastModified) VALUES ('Container',".$in{DistrictID}.",'2000-07-01','".$in{NSTD}."','US Census',9,".($m15t17+$m18t19+$f15t17+$f18t19).",1,1,Now());"); &SQLFinish(); $in{ImpErrs}.=$in{SQL_ERROR}; if ($in{SQL_INSERTID} > 0) { &SQLCmd("SELECT DemographicNumID OPRID FROM DemographicNum WHERE AttachID=".$in{DistrictID}." AND DemographicLink=9 AND StartDate < '2000-07-01' ORDER BY StartDate DESC LIMIT 1;"); &SQLOutput(); if ($in{SQL_NUMFOUND} ne '0E0') { &SQLCmd("UPDATE DemographicNum SET EndDate='2000-07-01' WHERE DemographicNumID=".$in{OPRID}.";"); &SQLFinish(); } } } &SQLCmd(q!SELECT DemographicNumID FROM DemographicNum WHERE AttachTo='Container' AND AttachID=!.$in{DistrictID}.q! AND DemographicLink=10 AND YEAR(StartDate)=2000;!); &SQLOutput(); $in{ImpErrs}.=$in{SQL_ERROR}; if ($in{SQL_NUMFOUND} ne '0E0') { $in{ImpErrs}.= $state." ".$dist." already Has 2000 20-24 - ".$in{NumCMatch}."
"; &SQLCmd("UPDATE DemographicNum SET DNumber=".($m20+$m21+$m22t24+$f20+$f21+$f22t24).",LastModified=Now(),Source='US Census' WHERE DemographicNumID=".$in{DemographicNumID}.";"); &SQLFinish(); $in{ImpErrs}.=$in{SQL_ERROR}; } else { $in{NTSD}='0000-00-00'; &SQLCmd("SELECT StartDate NSTD FROM DemographicNum WHERE AttachID=".$in{DistrictID}." AND DemographicLink=10 AND StartDate > '2000-07-01' ORDER BY StartDate LIMIT 1;"); &SQLOutput(); &SQLCmd("INSERT INTO DemographicNum (AttachTo,AttachID,StartDate,EndDate,Source,DemographicLink,DNumber,FirstBy,LMBy,LastModified) VALUES ('Container',".$in{DistrictID}.",'2000-07-01','".$in{NSTD}."','US Census',10,".($m20+$m21+$m22t24+$f20+$f21+$f22t24).",1,1,Now());"); &SQLFinish(); $in{ImpErrs}.=$in{SQL_ERROR}; if ($in{SQL_INSERTID} > 0) { &SQLCmd("SELECT DemographicNumID OPRID FROM DemographicNum WHERE AttachID=".$in{DistrictID}." AND DemographicLink=10 AND StartDate < '2000-07-01' ORDER BY StartDate DESC LIMIT 1;"); &SQLOutput(); if ($in{SQL_NUMFOUND} ne '0E0') { &SQLCmd("UPDATE DemographicNum SET EndDate='2000-07-01' WHERE DemographicNumID=".$in{OPRID}.";"); &SQLFinish(); } } } &SQLCmd(q!SELECT DemographicNumID FROM DemographicNum WHERE AttachTo='Container' AND AttachID=!.$in{DistrictID}.q! AND DemographicLink=11 AND YEAR(StartDate)=2000;!); &SQLOutput(); $in{ImpErrs}.=$in{SQL_ERROR}; if ($in{SQL_NUMFOUND} ne '0E0') { $in{ImpErrs}.= $state." ".$dist." already Has 2000 25-34 - ".$in{NumCMatch}."
"; &SQLCmd("UPDATE DemographicNum SET DNumber=".($m25t29+$m30t34+$f25t29+$f30t34).",LastModified=Now(),Source='US Census' WHERE DemographicNumID=".$in{DemographicNumID}.";"); &SQLFinish(); $in{ImpErrs}.=$in{SQL_ERROR}; } else { $in{NTSD}='0000-00-00'; &SQLCmd("SELECT StartDate NSTD FROM DemographicNum WHERE AttachID=".$in{DistrictID}." AND DemographicLink=11 AND StartDate > '2000-07-01' ORDER BY StartDate LIMIT 1;"); &SQLOutput(); &SQLCmd("INSERT INTO DemographicNum (AttachTo,AttachID,StartDate,EndDate,Source,DemographicLink,DNumber,FirstBy,LMBy,LastModified) VALUES ('Container',".$in{DistrictID}.",'2000-07-01','".$in{NSTD}."','US Census',11,".($m25t29+$m30t34+$f25t29+$f30t34).",1,1,Now());"); &SQLFinish(); $in{ImpErrs}.=$in{SQL_ERROR}; if ($in{SQL_INSERTID} > 0) { &SQLCmd("SELECT DemographicNumID OPRID FROM DemographicNum WHERE AttachID=".$in{DistrictID}." AND DemographicLink=11 AND StartDate < '2000-07-01' ORDER BY StartDate DESC LIMIT 1;"); &SQLOutput(); if ($in{SQL_NUMFOUND} ne '0E0') { &SQLCmd("UPDATE DemographicNum SET EndDate='2000-07-01' WHERE DemographicNumID=".$in{OPRID}.";"); &SQLFinish(); } } } &SQLCmd(q!SELECT DemographicNumID FROM DemographicNum WHERE AttachTo='Container' AND AttachID=!.$in{DistrictID}.q! AND DemographicLink=12 AND YEAR(StartDate)=2000;!); &SQLOutput(); $in{ImpErrs}.=$in{SQL_ERROR}; if ($in{SQL_NUMFOUND} ne '0E0') { $in{ImpErrs}.= $state." ".$dist." already Has 2000 35-44 - ".$in{NumCMatch}."
"; &SQLCmd("UPDATE DemographicNum SET DNumber=".($m35t39+$m40t44+$f35t39+$f40t44).",LastModified=Now(),Source='US Census' WHERE DemographicNumID=".$in{DemographicNumID}.";"); &SQLFinish(); $in{ImpErrs}.=$in{SQL_ERROR}; } else { $in{NTSD}='0000-00-00'; &SQLCmd("SELECT StartDate NSTD FROM DemographicNum WHERE AttachID=".$in{DistrictID}." AND DemographicLink=12 AND StartDate > '2000-07-01' ORDER BY StartDate LIMIT 1;"); &SQLOutput(); &SQLCmd("INSERT INTO DemographicNum (AttachTo,AttachID,StartDate,EndDate,Source,DemographicLink,DNumber,FirstBy,LMBy,LastModified) VALUES ('Container',".$in{DistrictID}.",'2000-07-01','".$in{NSTD}."','US Census',12,".($m35t39+$m40t44+$f35t39+$f40t44).",1,1,Now());"); &SQLFinish(); $in{ImpErrs}.=$in{SQL_ERROR}; if ($in{SQL_INSERTID} > 0) { &SQLCmd("SELECT DemographicNumID OPRID FROM DemographicNum WHERE AttachID=".$in{DistrictID}." AND DemographicLink=12 AND StartDate < '2000-07-01' ORDER BY StartDate DESC LIMIT 1;"); &SQLOutput(); if ($in{SQL_NUMFOUND} ne '0E0') { &SQLCmd("UPDATE DemographicNum SET EndDate='2000-07-01' WHERE DemographicNumID=".$in{OPRID}.";"); &SQLFinish(); } } } &SQLCmd(q!SELECT DemographicNumID FROM DemographicNum WHERE AttachTo='Container' AND AttachID=!.$in{DistrictID}.q! AND DemographicLink=13 AND YEAR(StartDate)=2000;!); &SQLOutput(); $in{ImpErrs}.=$in{SQL_ERROR}; if ($in{SQL_NUMFOUND} ne '0E0') { $in{ImpErrs}.= $state." ".$dist." already Has 2000 45-54 - ".$in{NumCMatch}."
"; &SQLCmd("UPDATE DemographicNum SET DNumber=".($m45t49+$m50t54+$f45t49+$f50t54).",LastModified=Now(),Source='US Census' WHERE DemographicNumID=".$in{DemographicNumID}.";"); &SQLFinish(); $in{ImpErrs}.=$in{SQL_ERROR}; } else { $in{NTSD}='0000-00-00'; &SQLCmd("SELECT StartDate NSTD FROM DemographicNum WHERE AttachID=".$in{DistrictID}." AND DemographicLink=13 AND StartDate > '2000-07-01' ORDER BY StartDate LIMIT 1;"); &SQLOutput(); &SQLCmd("INSERT INTO DemographicNum (AttachTo,AttachID,StartDate,EndDate,Source,DemographicLink,DNumber,FirstBy,LMBy,LastModified) VALUES ('Container',".$in{DistrictID}.",'2000-07-01','".$in{NSTD}."','US Census',13,".($m45t49+$m50t54+$f45t49+$f50t54).",1,1,Now());"); &SQLFinish(); $in{ImpErrs}.=$in{SQL_ERROR}; if ($in{SQL_INSERTID} > 0) { &SQLCmd("SELECT DemographicNumID OPRID FROM DemographicNum WHERE AttachID=".$in{DistrictID}." AND DemographicLink=13 AND StartDate < '2000-07-01' ORDER BY StartDate DESC LIMIT 1;"); &SQLOutput(); if ($in{SQL_NUMFOUND} ne '0E0') { &SQLCmd("UPDATE DemographicNum SET EndDate='2000-07-01' WHERE DemographicNumID=".$in{OPRID}.";"); &SQLFinish(); } } } &SQLCmd(q!SELECT DemographicNumID FROM DemographicNum WHERE AttachTo='Container' AND AttachID=!.$in{DistrictID}.q! AND DemographicLink=14 AND YEAR(StartDate)=2000;!); &SQLOutput(); $in{ImpErrs}.=$in{SQL_ERROR}; if ($in{SQL_NUMFOUND} ne '0E0') { $in{ImpErrs}.= $state." ".$dist." already Has 2000 55-59 - ".$in{NumCMatch}."
"; &SQLCmd("UPDATE DemographicNum SET DNumber=".($m55t59+$f55t59).",LastModified=Now(),Source='US Census' WHERE DemographicNumID=".$in{DemographicNumID}.";"); &SQLFinish(); $in{ImpErrs}.=$in{SQL_ERROR}; } else { $in{NTSD}='0000-00-00'; &SQLCmd("SELECT StartDate NSTD FROM DemographicNum WHERE AttachID=".$in{DistrictID}." AND DemographicLink=14 AND StartDate > '2000-07-01' ORDER BY StartDate LIMIT 1;"); &SQLOutput(); &SQLCmd("INSERT INTO DemographicNum (AttachTo,AttachID,StartDate,EndDate,Source,DemographicLink,DNumber,FirstBy,LMBy,LastModified) VALUES ('Container',".$in{DistrictID}.",'2000-07-01','".$in{NSTD}."','US Census',14,".($m55t59+$f55t59).",1,1,Now());"); &SQLFinish(); $in{ImpErrs}.=$in{SQL_ERROR}; if ($in{SQL_INSERTID} > 0) { &SQLCmd("SELECT DemographicNumID OPRID FROM DemographicNum WHERE AttachID=".$in{DistrictID}." AND DemographicLink=14 AND StartDate < '2000-07-01' ORDER BY StartDate DESC LIMIT 1;"); &SQLOutput(); if ($in{SQL_NUMFOUND} ne '0E0') { &SQLCmd("UPDATE DemographicNum SET EndDate='2000-07-01' WHERE DemographicNumID=".$in{OPRID}.";"); &SQLFinish(); } } } &SQLCmd(q!SELECT DemographicNumID FROM DemographicNum WHERE AttachTo='Container' AND AttachID=!.$in{DistrictID}.q! AND DemographicLink=15 AND YEAR(StartDate)=2000;!); &SQLOutput(); $in{ImpErrs}.=$in{SQL_ERROR}; if ($in{SQL_NUMFOUND} ne '0E0') { $in{ImpErrs}.= $state." ".$dist." already Has 2000 60-64 - ".$in{NumCMatch}."
"; &SQLCmd("UPDATE DemographicNum SET DNumber=".($m60t61+$m62t64+$f60t61+$f62t64).",LastModified=Now(),Source='US Census' WHERE DemographicNumID=".$in{DemographicNumID}.";"); &SQLFinish(); $in{ImpErrs}.=$in{SQL_ERROR}; } else { $in{NTSD}='0000-00-00'; &SQLCmd("SELECT StartDate NSTD FROM DemographicNum WHERE AttachID=".$in{DistrictID}." AND DemographicLink=15 AND StartDate > '2000-07-01' ORDER BY StartDate LIMIT 1;"); &SQLOutput(); &SQLCmd("INSERT INTO DemographicNum (AttachTo,AttachID,StartDate,EndDate,Source,DemographicLink,DNumber,FirstBy,LMBy,LastModified) VALUES ('Container',".$in{DistrictID}.",'2000-07-01','".$in{NSTD}."','US Census',15,".($m60t61+$m62t64+$f60t61+$f62t64).",1,1,Now());"); &SQLFinish(); $in{ImpErrs}.=$in{SQL_ERROR}; if ($in{SQL_INSERTID} > 0) { &SQLCmd("SELECT DemographicNumID OPRID FROM DemographicNum WHERE AttachID=".$in{DistrictID}." AND DemographicLink=15 AND StartDate < '2000-07-01' ORDER BY StartDate DESC LIMIT 1;"); &SQLOutput(); if ($in{SQL_NUMFOUND} ne '0E0') { &SQLCmd("UPDATE DemographicNum SET EndDate='2000-07-01' WHERE DemographicNumID=".$in{OPRID}.";"); &SQLFinish(); } } } &SQLCmd(q!SELECT DemographicNumID FROM DemographicNum WHERE AttachTo='Container' AND AttachID=!.$in{DistrictID}.q! AND DemographicLink=16 AND YEAR(StartDate)=2000;!); &SQLOutput(); $in{ImpErrs}.=$in{SQL_ERROR}; if ($in{SQL_NUMFOUND} ne '0E0') { $in{ImpErrs}.= $state." ".$dist." already Has 2000 65-74 - ".$in{NumCMatch}."
"; &SQLCmd("UPDATE DemographicNum SET DNumber=".($m65t66+$m67t69+$m70t74+$f65t66+$f67t69+$f70t74).",LastModified=Now(),Source='US Census' WHERE DemographicNumID=".$in{DemographicNumID}.";"); &SQLFinish(); $in{ImpErrs}.=$in{SQL_ERROR}; } else { $in{NTSD}='0000-00-00'; &SQLCmd("SELECT StartDate NSTD FROM DemographicNum WHERE AttachID=".$in{DistrictID}." AND DemographicLink=16 AND StartDate > '2000-07-01' ORDER BY StartDate LIMIT 1;"); &SQLOutput(); &SQLCmd("INSERT INTO DemographicNum (AttachTo,AttachID,StartDate,EndDate,Source,DemographicLink,DNumber,FirstBy,LMBy,LastModified) VALUES ('Container',".$in{DistrictID}.",'2000-07-01','".$in{NSTD}."','US Census',16,".($m65t66+$m67t69+$m70t74+$f65t66+$f67t69+$f70t74).",1,1,Now());"); &SQLFinish(); $in{ImpErrs}.=$in{SQL_ERROR}; if ($in{SQL_INSERTID} > 0) { &SQLCmd("SELECT DemographicNumID OPRID FROM DemographicNum WHERE AttachID=".$in{DistrictID}." AND DemographicLink=16 AND StartDate < '2000-07-01' ORDER BY StartDate DESC LIMIT 1;"); &SQLOutput(); if ($in{SQL_NUMFOUND} ne '0E0') { &SQLCmd("UPDATE DemographicNum SET EndDate='2000-07-01' WHERE DemographicNumID=".$in{OPRID}.";"); &SQLFinish(); } } } &SQLCmd(q!SELECT DemographicNumID FROM DemographicNum WHERE AttachTo='Container' AND AttachID=!.$in{DistrictID}.q! AND DemographicLink=17 AND YEAR(StartDate)=2000;!); &SQLOutput(); $in{ImpErrs}.=$in{SQL_ERROR}; if ($in{SQL_NUMFOUND} ne '0E0') { $in{ImpErrs}.= $state." ".$dist." already Has 2000 75-84 - ".$in{NumCMatch}."
"; &SQLCmd("UPDATE DemographicNum SET DNumber=".($m75t79+$m80t84+$f75t79+$f80t84).",LastModified=Now(),Source='US Census' WHERE DemographicNumID=".$in{DemographicNumID}.";"); &SQLFinish(); $in{ImpErrs}.=$in{SQL_ERROR}; } else { $in{NTSD}='0000-00-00'; &SQLCmd("SELECT StartDate NSTD FROM DemographicNum WHERE AttachID=".$in{DistrictID}." AND DemographicLink=17 AND StartDate > '2000-07-01' ORDER BY StartDate LIMIT 1;"); &SQLOutput(); &SQLCmd("INSERT INTO DemographicNum (AttachTo,AttachID,StartDate,EndDate,Source,DemographicLink,DNumber,FirstBy,LMBy,LastModified) VALUES ('Container',".$in{DistrictID}.",'2000-07-01','".$in{NSTD}."','US Census',17,".($m75t79+$m80t84+$f75t79+$f80t84).",1,1,Now());"); &SQLFinish(); $in{ImpErrs}.=$in{SQL_ERROR}; if ($in{SQL_INSERTID} > 0) { &SQLCmd("SELECT DemographicNumID OPRID FROM DemographicNum WHERE AttachID=".$in{DistrictID}." AND DemographicLink=17 AND StartDate < '2000-07-01' ORDER BY StartDate DESC LIMIT 1;"); &SQLOutput(); if ($in{SQL_NUMFOUND} ne '0E0') { &SQLCmd("UPDATE DemographicNum SET EndDate='2000-07-01' WHERE DemographicNumID=".$in{OPRID}.";"); &SQLFinish(); } } } &SQLCmd(q!SELECT DemographicNumID FROM DemographicNum WHERE AttachTo='Container' AND AttachID=!.$in{DistrictID}.q! AND DemographicLink=18 AND YEAR(StartDate)=2000;!); &SQLOutput(); $in{ImpErrs}.=$in{SQL_ERROR}; if ($in{SQL_NUMFOUND} ne '0E0') { $in{ImpErrs}.= $state." ".$dist." already Has 2000 85+ - ".$in{NumCMatch}."
"; &SQLCmd("UPDATE DemographicNum SET DNumber=".($m85p+$f85p).",LastModified=Now(),Source='US Census' WHERE DemographicNumID=".$in{DemographicNumID}.";"); &SQLFinish(); $in{ImpErrs}.=$in{SQL_ERROR}; } else { $in{NTSD}='0000-00-00'; &SQLCmd("SELECT StartDate NSTD FROM DemographicNum WHERE AttachID=".$in{DistrictID}." AND DemographicLink=18 AND StartDate > '2000-07-01' ORDER BY StartDate LIMIT 1;"); &SQLOutput(); &SQLCmd("INSERT INTO DemographicNum (AttachTo,AttachID,StartDate,EndDate,Source,DemographicLink,DNumber,FirstBy,LMBy,LastModified) VALUES ('Container',".$in{DistrictID}.",'2000-07-01','".$in{NSTD}."','US Census',18,".($m85p+$f85p).",1,1,Now());"); &SQLFinish(); $in{ImpErrs}.=$in{SQL_ERROR}; if ($in{SQL_INSERTID} > 0) { &SQLCmd("SELECT DemographicNumID OPRID FROM DemographicNum WHERE AttachID=".$in{DistrictID}." AND DemographicLink=18 AND StartDate < '2000-07-01' ORDER BY StartDate DESC LIMIT 1;"); &SQLOutput(); if ($in{SQL_NUMFOUND} ne '0E0') { &SQLCmd("UPDATE DemographicNum SET EndDate='2000-07-01' WHERE DemographicNumID=".$in{OPRID}.";"); &SQLFinish(); } } } } else { $in{ImpErrs}.= "No District |".$state.$dist.'|
'; } } else { $in{ImpErrs}.= "No State |".$state.'|
'; } $in{ImpErrs}.= ". ".$in{NumSMatch}; }


Import Census Data
Date (if necessary)
State (If necessary)
File



Import Census GEO File
Import Census DATA 1 File
Import Census DATA 2 File
Existing Demographic Dates
SELECT DISTINCT StartDate XSD from Demographic,DemographicNum where DemoCategory= AND DemographicLink=DemographicID AND AttachTo='Container' and AttachID= ORDER BY XSD;

OUTPUT