scores/batch
1
0
Fork 0
Code Issues Pull Requests Releases Wiki Activity
1.1
batch/old/genereEpl.php
Michael RICOIS 086542e0d6 Add old batch before reintegrate
2012-07-28 12:21:05 +00:00

4199 lines
148 KiB
PHP
Raw Permalink Blame History

#!/usr/bin/php -c/var/www/batch/config/php_batch_sd.ini
<?php
include_once(FWK_PATH.'common/chiffres.php');
include_once(FWK_PATH.'common/dates.php');
include_once(FWK_PATH.'common/ftp.php');
include_once(INCLUDE_PATH.'insee/classMInsee.php');
include_once(INCLUDE_PATH.'partenaires/classMMap.php');
include_once(FWK_PATH.'mail/sendMail.php');
/*
$points=array('48.5161400 -4.0806451',
'47.9696045 -4.0953622',
'50 -10',
);
/*** Example ***
$pointLocation = new pointLocation();
//$polygon = array("10 0", "20 0", "30 10", "30 20", "20 30", "10 30", "0 20", "0 10", "10 0");
//$points = array("30 19", "0 0", "10 0", "30 20", "11 0", "0 11", "0 10", "30 22", "20 20");
$polygon = array('1232225.0 6105799.0','1232179.0 6105410.0','1232847.0 6101584.0','1232209.0 6098935.0','1232602.0 6097833.0','1232524.0 6096331.0','1233412.0 6095741.0','1233631.0 6090471.0','1233422.0 6090150.0','1233693.0 6089870.0','1233479.0 6087563.0','1231910.0 6086528.0','1231446.0 6085476.0','1232428.0 6084407.0','1232651.0 6082903.0','1232492.0 6082509.0','1231382.0 6080985.0','1230697.0 6081287.0','1229953.0 6081137.0','1229646.0 6080438.0','1230295.0 6079087.0','1230086.0 6078803.0','1227813.0 6078525.0','1226928.0 6079281.0','1226917.0 6079669.0','1226247.0 6079304.0','1226342.0 6078162.0','1224878.0 6076954.0','1224725.0 6075797.0','1225048.0 6075097.0','1225712.0 6074680.0','1226064.0 6074845.0','1227674.0 6076986.0','1228819.0 6076867.0','1229687.0 6076106.0','1230794.0 6076338.0','1231177.0 6076374.0','1231748.0 6076111.0','1230521.0 6074193.0','1230359.0 6072706.0','1229454.0 6072103.0','1229073.0 6072142.0','1226423.0 6069921.0','1225571.0 6068664.0','1224531.0 6068244.0','1225359.0 6067033.0','1224531.0 6065318.0','1225013.0 6064736.0','1225648.0 6065172.0','1225828.0 6064846.0','1226005.0 6063417.0','1225700.0 6062688.0','1224847.0 6061911.0','1224862.0 6061200.0','1224155.0 6060892.0','1222637.0 6059117.0','1221241.0 6058429.0','1221221.0 6057339.0','1221534.0 6056646.0','1221356.0 6055500.0','1220673.0 6055210.0','1220759.0 6054854.0','1220941.0 6054483.0','1221311.0 6054384.0','1224142.0 6056970.0','1224518.0 6056890.0','1224536.0 6056504.0','1224202.0 6055397.0','1223612.0 6054906.0','1223173.0 6053848.0','1222874.0 6053597.0','1221577.0 6051239.0','1221373.0 6050116.0','1218311.0 6049647.0','1217070.0 6051487.0','1215580.0 6051689.0','1215843.0 6051984.0','1214519.0 6052048.0','1213250.0 6052765.0','1211100.0 6052083.0','1210391.0 6052840.0','1210452.0 6053222.0','1210757.0 6054340.0','1211492.0 6055188.0','1211432.0 6055948.0','1212329.0 6057192.0','1211820.0 6057586.0','1210676.0 6057697.0','1210292.0 6058348.0','1209127.0 6057424.0','1208403.0 6057615.0','1207933.0 6058197.0','1207912.0 6059680.0','1208603.0 6061011.0','1208749.0 6061359.0','1208016.0 6061134.0','1206855.0 6059594.0','1206196.0 6059208.0','1205815.0 6059178.0','1205084.0 6059998.0','1204017.0 6059742.0','1203396.0 6060664.0','1202277.0 6060746.0','1201964.0 6060972.0','1201778.0 6061509.0','1201570.0 6061708.0','1200677.0 6060503.0','1199925.0 6061337.0','1199196.0 6061519.0','1198797.0 6062113.0','1197381.0 6061872.0','1196997.0 6061870.0','1196662.0 6062067.0','1195631.0 6061905.0','1194606.0 6063487.0','1192306.0 6063513.0','1192142.0 6064621.0','1191527.0 6065084.0','1189708.0 6064528.0','1188920.0 6064401.0','1188514.0 6064936.0','1189267.0 6066322.0','1189143.0 6067104.0','1188180.0 6067421.0','1186599.0 6067374.0','1185746.0 6068152.0','1185425.0 6068362.0','1184275.0 6068339.0','1183638.0 6068714.0','1183759.0 6069384.0','1184527.0 6070215.0','1183676.0 6071481.0','1182956.0 6071722.0','1182706.0 6072017.0','1183427.0 6073748.0','1183519.0 6076395.0','1184100.0 6076858.0','1184426.0 6077505.0','1185601.0 6076764.0','1188332.0 6078757.0','1189451.0 6078943.0','1189779.0 6078751.0','1190290.0 6079308.0','1190717.0 6081549.0','1193040.0 6082737.0','1193338.0 6082978.0','1192970.0 6084000.0','1191068.0 6083708.0','1190090.0 6084254.0','1187080.0 6084303.0','1185902.0 6085281.0','1185588.0 6085507.0','1184502.0 6085890.0','1182363.0 6084598.0','1181188.0 6086000.0','1181953.0 6087751.0','1181931.0 6088137.0','1181370.0 6088653.0','1180619.0 6088635.0','1176254.0 6086294.0','1175871.0 6086236.0','1175498.0 6086347.0','1175480.0 6087484.0','1175117.0 6088117.0','1172413.0 6088267.0','1171675.0 6088022.0','1171482.0 6088367.0','1171752.0 6089066.0','1172477.0 6089348.0','1173547.0 6088924.0','1175469.0 6090178.0','1175751.0 6090447.0','1177119.0 6092735.0','1176488.0 6093692.0','1175544.0 6094353.0','1175464.0 6095020.0','1177308.0 6094798.0','1178813.0 6096431.0','1179112.0 6096188.0','1180256.0 6096485.0','1180794.0 6098958.0','1178726.0 6100191.0','1181265.0 6100879.0','1181435.0 6101239.0','1181500.0 6101583.0','1181223.0 6102923.0','1180653.0 6103403.0','1180439.0 6104427.0','1182016.0 6105365.0','1182151.0 6106087.0','1181837.0 6106757.0','1181678.0 6107096.0','1179960.0 6109184.0','1179196.0 6109284.0','1178497.0 6108977.0','1177700.0 6109832.0','1177309.0 6109858.0','1176781.0 6109337.0','1176746.0 6108173.0','1175180.0 6107043.0','1171373.0 6106336.0','1168658.0 6106609.0','1168316.0 6106418.0','1166129.0 6104880.0','1166379.0 6105603.0','1166145.0 6106719.0','1166824.0 6108511.0','1166848.0 6109639.0','1166543.0 6109875.0','1165796.0 6109794.0','1164320.0 6112337.0','1166289.0 6113312.0','1166665.0 6113276.0','1168474.0 6113122.0','1169930.0 6114210.0','1170346.0 6114840.0','1170377.0 6115133.0','1170333.0 6115737.0','1170175.0 6116047.0','1169487.0 6115941.0','1169050.0 6116879.0','1169189.0 6117198.0','1169278.0 6117935.0','1171658.0 6119906.0','1173174.0 6120136.0','1174214.0 6120711.0','1174585.0 6121775.0','1176028.0 6122052.0','1176242.0 6122788.0','1175994.0 6123525.0','1175975.0 6123875.0','1175676.0 6124106.0','1175080.0 6124469.0','1174001.0 6124257.0','1173619.0 6125705.0','1173246.0 6126350.0','1172617.0 6126683.0','1172809.0 6127781.0','1172029.0 6128988.0','1172025.0 6129361.0','1171002.0 6129584.0','1170297.0 6128744.0','1168900.0 6128315.0','1167827.0 6129706.0','1167249.0 6130135.0','1166531.0 6129958.0','1166306.0 6130270.0','1165542.0 6130300.0','1164406.0 6131292.0','1162190.0 6130824.0','1162776.0 6132211.0','1162128.0 6133081.0','1161378.0 6133223.0','1160405.0 6132607.0','1160098.0 6132376.0','1160269.0 6133082.0','1161609.0 6133798.0','1162532.0 6134987.0','1161881.0 6135312.0','1160389.0 6135124.0','1160254.0 6135788.0','1161720.0 6136182.0','1161987.0 6136459.0','1161846.0 6136616.0','1161637.0 6136660.0','1161251.0 6137711.0','1161319.0 6138835.0','1160432.0 6139424.0','1160671.0 6140142.0','1160357.0 6140819.0','1160495.0 6141543.0','1160247.0 6141834.0','1159486.0 6141851.0','1158822.0 6141462.0','1158205.0 6141913.0','1158124.0 6142587.0','1159640.0 6142603.0','1163130.0 6144237.0','1163265.0 6144601.0','1165501.0 6144707.0','1166094.0 6145197.0','1169414.0 6146097.0','1169790.0 6146188.0','1169961.0 6146498.0','1169833.0 6147470.0','1169849.0 6147765.0','1169499.0 6148237.0','1169127.0 6148211.0','1168505.0 6148473.0','1168182.0 6149510.0','1167164.0 6149964.0','1167135.0 6150336.0','1165420.0 6150071.0','1165177.0 6150337.0','1164366.0 6151076.0','1162886.0 6150664.0','1162263.0 6151011.0','1162034.0 6151751.0','1163861.0 6153156.0','1164049.0 6153919.0','1163088.0 6155079.0','1161992.0 6155446.0','1161624.0 6155579.0','1160896.0 6155374.0','1159077.0 6153410.0','1158348.0 6153366.0','1157755.0 6156645.0','1157414.0 6156826.0','1157055.0 6156934.0','1157148.0 6157670.0','1157459.0 6157855.0','1158058.0 6157407.0','1159158.0 6157461.0','1159704.0 6157969.0','1159342.0 6158599.0','1159725.0 6158532.0','1161710.0 6157509.0','1162763.0 6157999.0','1164650.0 6158020.0','1166520.0 6156734.0','1168417.0 6156658.0','1168665.0 6155542.0','1169022.0 6155656.0','1171211.0 6155773.0','1172110.0 6155138.0','1172440.0 6154939.0','1174734.0 6154913.0','1176067.0 6153556.0','1176455.0 6153558.0','1177601.0 6153700.0','1180176.0 6152933.0','1183102.0 6154697.0','1183466.0 6154574.0','1183659.0 6151187.0','1185050.0 6150600.0','1185786.0 6149756.0','1185677.0 6148652.0','1185633.0 6148270.0','1187375.0 6146699.0','1187662.0 6146433.0','1188038.0 6146534.0','1189160.0 6146851.0','1189461.0 6146604.0','1189675.0 6146292.0','1190259.0 6145840.0','1190715.0 6144804.0','1191361.0 6144461.0','1193550.0 6144486.0','1193878.0 6143876.0','1194098.0 6143584.0','1194442.0 6143680.0','1195393.0 6142623.0','1196358.0 6142407.0','1196429.0 6142057.0','1196814.0 6142048.0','1197855.0 6141592.0','1199675.0 6142195.0','1199960.0 6140897.0','1200068.0 6140581.0','1200187.0 6138992.0','1200144.0 6138657.0','1200538.0 6138014.0','1201626.0 6137674.0','1202797.0 6134446.0','1202508.0 6133738.0','1203511.0 6133231.0','1204279.0 6132393.0','1205395.0 6132361.0','1206983.0 6131338.0','1207405.0 6130293.0','1207941.0 6129755.0','1207930.0 6126543.0','1208200.0 6126297.0','1208110.0 6125562.0','1209866.0 6124147.0','1210451.0 6123160.0','1210639.0 6122825.0','1212780.0 6123446.0','1215334.0 6123324.0','1215715.0 6123337.0','1215715.0 6122970.0','1215548.0 6119678.0','1215978.0 6119117.0','1215903.0 6118751.0','1216256.0 6117341.0','1216611.0 6117223.0','1216531.0 6114677.0','1216123.0 6113658.0','1216980.0 6112968.0','1217339.0 6112861.0','1216288.0 6111338.0','1216033.0 6111064.0','1216322.0 6110806.0','1217834.0 6110931.0','1219123.0 6110104.0','1219269.0 6108979.0','1218327.0 6107285.0','1218294.0 6106550.0','1217918.0 6104644.0','1217754.0 6104291.0','1218062.0 6104056.0','1218535.0 6103479.0','1219288.0 6103651.0','1221460.0 6102907.0','1222518.0 6103385.0','1224047.0 6103433.0','1224631.0 6102972.0','1224732.0 6102228.0','1226190.0 6102754.0','1229737.0 6106275.0','1230866.0 6106547.0','1231850.0 6105915.0','1232225.0 6105799.0');
// The last point's coordinates must be the same as the first one's, to "close the loop"
foreach($points as $key => $pointWGS84) {
/*$xy=explode(' ', $pointWGS84);
$lambert=geos2lambert93($xy[0],$xy[1]);
$x93=round($lambert['x_93']);
$y93=round($lambert['y_93']);
$point="$x93 $y93";*
$point=$pointWGS84;
echo "$key ($pointWGS84 => $point) is " . $pointLocation->pointInPolygon($point, $polygon) . EOL;
}
die();*/
$strInfoScript='Usage : '.basename($argv[0]). " <option>
Chargement du/des flux quotidiens en provenance de Insee.
Options :
-v Mode debug (Verbosit<69> au maximum)
-d=20080430 R<>appliquer les <20>v<EFBFBD>nements depuis cette date
-f=20091230 R<>appliquer les <20>v<EFBFBD>nements jusqu'<27> cette date
-m Lecture des MI*
-t Post traitement des MID/MIF
";
$iDb=new WDB('insee');
$iDb2=new WDB('tmp');
$iInsee=new MInsee();
$imap=new MMap();
/*
$tabLatLon=array( array('lat'=>45.6069412,'lon'=>4.0829248), // M7045670 11
array('lat'=>45.4347916,'lon'=>4.3896523), // L0126300 11
array('lat'=>45.4406204,'lon'=>4.3889494), // L0126300 12
array('lat'=>45.4349098,'lon'=>4.3896928), // L0126300 14
array('lat'=>45.4363327,'lon'=>4.3892827), // L0126300 15
array('lat'=>45.8241541,'lon'=>0.4845907)); // M3516650 15
print_r($imap->getAltitude($tabLatLon));
print_r($imap->getAltitude(45.6069412,4.0829248));
die();
*/
$nbSiretInvalides=$nbErreurs=$nbInsert=$nbUpdate=
$nbLignes=$nbEnCache=$nbDistant=0;
$modeDebug=$dateReprise=$lectureMI=$traitementMI=false;
//Initialistation des variables
$argv=$_SERVER['argv'];
//if ($_SERVER['argc']==1) die("Non g<>r<EFBFBD> pour l'instant : chargera les derniers fichiers EVEN non charg<72>s !".EOL);
for ($i=1,$j=0; isset($argv[$i]); $i++) {
if (substr($argv[$i],0,1)=='-') {
switch (substr($argv[$i],1,1)) {
case 'v': $modeDebug=true; break;
case 'd': $dateReprise=substr($argv[$i],3,8); break;
case 'f': $dateFin =substr($argv[$i],3,8); break;
case 'm': $lectureMI =true; break;
case 't': $traitementMI=true; break;
case '-':
case '?': die($strInfoScript); break;
default: die('Option '. $argv[$i] . " inconnue !\n");
}
} else $tabFichier[]=$argv[$i];
}
if ($traitementMI) {
$strDept='';
if (@count($tabFichier)>0) $strDept=" AND codeCommune LIKE '".$tabFichier[0]."%' ";
$nbPoints=0;
$nbLoaded=$iDb->select('tmp.epl_eau2', 'id,code,lat,lon,x_93, y_93', "x_93 BETWEEN 280343 AND 830707 AND y_93 BETWEEN 6376956 AND 6857117", false, MYSQL_ASSOC, true);
echo date ('Y/m/d - H:i:s')." - Il y a $nbLoaded points...".EOL;
$nbPointsTot=0;
while($adr=$iDb->fetch(MYSQL_ASSOC)) {
$nbPointsTot++;
//if ($nbPointsTot%2==0)
$tabAdr[$adr['id']]=array( 'cod'=>$adr['code'],
//'cod2'=>substr($adr['code'],0,4),
'x93'=>round($adr['x_93']),
'y93'=>round($adr['y_93']));
}
echo date ('Y/m/d - H:i:s')." - Tableau des points g<>n<EFBFBD>r<EFBFBD> : $nbPointsTot points".EOL;
//alt IS NULL
$nbAdresses=$iDb->select('tmp.epl2', "siren, nic, lat, lon, alt, x_93, y_93, codeCommune, count(*) AS nbAdr",
//"dist IS NULL AND x_93 BETWEEN 280343 AND 830707 AND y_93 BETWEEN 6376956 AND 6857117 /*$strDept AND eff_etab=0*/ GROUP BY x_93, y_93 ORDER BY nbAdr DESC", false, MYSQL_ASSOC, true);
"alt IS NULL GROUP BY x_93, y_93 ORDER BY nbAdr DESC", false, MYSQL_ASSOC, true);
//echo mysql_error().EOL;
echo date ('Y/m/d - H:i:s')." - Il y a $nbAdresses adresses <20> mettre <20> jour...".EOL;
$distArea=20000;
while($adr=$iDb->fetch(MYSQL_ASSOC)) {
$nbLignes++;
$siren=$adr['siren'];
$nic=$adr['nic'];
$x93=round($adr['x_93']);
$y93=round($adr['y_93']);
$alt=$adr['alt'];
$nb=$adr['nbAdr'];
$comInsee=substr($adr['codeCommune'],0,1);
$distMin=9999999999999;
$codMin='ZZZZZZZZ';
$nbInclu=$nbExclu=0;
/*
foreach($tabAdr as $id=>$tabAd) {
if ($x93>$tabAd['x93']-$distArea && $x93<$tabAd['x93']+$distArea && $y93>$tabAd['y93']-$distArea && $y93<$tabAd['y93']+$distArea) {
//$dist=round($imap->distance($tabAd['lat'], $tabAd['lon'], $lat, $lon)*1000);
$dist=round($imap->distanceLambert($tabAd['x93'],$tabAd['y93'],$x93,$y93));
if ($dist<$distMin) {
$distMin=$dist;
$codMin=$tabAd['cod'];
}
$nbInclu++;
} else $nbExclu++;
}*/
if($alt==NULL) {
$alt=$imap->getAltitude($adr['lat'],$adr['lon']);
$alt=$alt['alt'];
/*if ($alt==NULL || $alt==false) {
echo date ('Y/m/d - H:i:s')." - $nbLignes/$nbAdresses - $siren $nic ($x93,$y93=$nb adresses) PAUSE".EOL;
sleep(10);
continue;
}*/
}
$iDb2->update('epl2', array(/*'dist'=>$distMin, 'codeRiviere'=>$codMin, */'alt'=>$alt), "x_93='$x93' AND y_93='$y93'");
echo date ('Y/m/d - H:i:s')." - $nbLignes/$nbAdresses - $siren $nic ($x93,$y93=$nb adresses, $nbInclu coord. test<73>es et $nbExclu exclues) : $distMin m<>tres de $codMin (h=$alt m.)".EOL;
}
die();
}
if ($lectureMI) {
echo date ('Y/m/d - H:i:s') . " - Lecture du MID... ";
$fp1=fopen('/var/www/html/mif/COURS_D_EAU.MID','r');
$numligne1=0;
// while (!feof($fp1)) {
// $line = fread($fp1, 8192);
while (($data = fgetcsv($fp1, 4096, "\t")) !== FALSE) {
$tabInfos=array();
//$tabInfos['id']=$numligne1;
$tabInfos['cod']=$data[0]; // Code_Hydrographique
$tabInfos['nom']=$data[1]; // Nom
$numligne1++;
//EP Loire K, L, M, N
// $codeRegion=substr($tabInfos['cod'],0,1);
// if ($codeRegion=='K' || $codeRegion=='L' || $codeRegion=='M' || $codeRegion=='N') {
$tabMID[$numligne1]=$tabInfos;
// }
// $tabMIDtot[$numligne1]=$tabInfos;
//$tabInfos['nno']=$data[2];
//$tabInfos['typ']=$data[3];
/* 1 : tout cours d<>eau d<>une longueur sup<75>rieure <20> 100 km ou tout cours d<>eau se jetant dans une <20> embouchure logique <20>1 et d<>une longueur sup<75>rieure <20> 25 km.
2 : tout cours d<>eau d<>une longueur comprise entre 50 et 100 km ou tout cours d<>eau se jetant dans une <20> embouchure logique <20> et d<>une longueur sup<75>rieure <20> 10 km.
3 : tout cours d<>eau d<>une longueur comprise entre 25 et 50 km.
4 : tout cours d<>eau d<>une longueur comprise entre 10 et 25 km.
5 : tout cours d<>eau d<>une longueur comprise entre 5 et 10 km.
6 : tous les autres cours d<>eau hormis ceux issus de la densification du r<>seau.
7 : cours d<>eau issus de la densification du r<>seau.
*/
}
$nbCours=count($tabMID);
fclose($fp1);
echo "on conserve $nbCours / $numligne1 cours d'eau".EOL;
//print_r($tabMID);
//die();
echo date ('Y/m/d - H:i:s') . " - Lecture du MIF... ";
$tabXY=$tabMIF=array();
$fp1=fopen('/var/www/html/mif/COURS_D_EAU.MIF','rb');
$numligne=0; // Nb lignes du fichier
$numligne1=0; // Nb lignes cours d'eau
$plineLu=0; // Lignes X Y lues en cours dans le cours d'eau
$nbPoints=0; // Nombre de points lus
$nbCoursIgnore=0;
$data=false;
while (!feof($fp1)) {
$numligne++;
$line = strtoupper(trim(fgets($fp1, 4096)));
//fread($fp1, 1024)));
//echo "$numligne:'$line'".EOL;
switch($line) {
case 'DATA':
$data=true;
break;
case 'PLINE':
if (!$data) continue;
$numligne1++;
$pline=true;
$plineLu=0;
break;
default:
if (!$data || substr($line,0,3)=='PEN') continue;
//echo "$numligne\t$numligne1\t$pline\t$plineLu:".EOL;
if ($line*1>0 && $pline && !strpos($line,' ')) $pline=$line*1; // Nombre de coordonn<6E>es <20> lire
else/*if ($plineLu<=$pline)*/ {
if (substr($line,0,3)<>'PEN') {
$t=explode(' ', $line);
$x=$t[0];
$y=$t[1];
$tabXY[]="$x $y";
$codeRegion=substr($tabMID[$numligne1]['cod'],0,1);
//if ($codeRegion=='K' || $codeRegion=='L' || $codeRegion=='M' || $codeRegion=='N') {
$xy=Lambert2WGS84($x,$y,'L93');
$lon=$xy['long'];
$lat=$xy['lat'];
$cod=$tabMID[$numligne1]['cod'];
if ($cod<>$codPre) $dist='';
else $dist=round($imap->distance($latPre, $lonPre, $lat, $lon)*1000);
echo $cod."\t".
$tabMID[$numligne1]['nom']."\t$x\t$y\t$lat\t$lon\t$dist".EOL;
$latPre=$lat;
$lonPre=$lon;
$codPre=$cod;
//}
$nbPoints++;
$plineLu++;
} elseif (substr($line,0,3)=='PEN') {
$tabXY=array();
$plineLu=0;
continue;
}
//echo "$numligne\t$numligne1\t$pline\t$plineLu\t'$x\t$y'".EOL;
if (count($tabXY)==$pline) {
$id=$numligne1;
/*echo "id=$id".EOL;
echo "tabXY=".count($tabXY).EOL;
echo "pline=$pline".EOL;
echo "line=".substr($line,0,3).EOL;
echo 'tabMID'.EOL;
print_r($tabMIDtot[$id]);
echo 'tabXY'.EOL;
print_r($tabXY);
die();*/
/*if (isset($tabMID[$id])) {
$tabMIF[$tabMID[$id]['cod']]=array( 'nom'=>$tabMID[$id]['nom'],
'points'=>$tabXY);
} else $nbCoursIgnore++;*/
$codeRegion=substr($tabMID[$id]['cod'],0,1);
if ($codeRegion=='K' || $codeRegion=='L' || $codeRegion=='M' || $codeRegion=='N') {
//echo $id.EOL;
$tabMIF[]=array( 'cod'=>$tabMID[$id]['cod'],
'nom'=>$tabMID[$id]['nom'],
'points'=>$tabXY);
} else $nbCoursIgnore++;
$tabXY=array();
$plineLu=0;
}
}
break;
}
}
$nbCours=count($tabMIF);
fclose($fp1);
echo "on conserve $nbCours cours d'eau et on ignore $nbCoursIgnore pour une total de $numligne1 cours d'eau et $nbPoints points".EOL;
print_r($tabMIF);
echo date ('Y/m/d - H:i:s') . " - Fin des MID/MIF";
/**
COURS_D_EAU.MIF COURS_D_EAU.SHX msshr_line.mif POINT_EAU_ISOLE.MIF trails.kml
COURS_D_EAU.MID COURS_D_EAU.SHP loadMif2Raster.php POINT_EAU_ISOLE.MID test.csv/
[root@srv_sd01 send]# ls /var/www/html/mif/
D<>coupage des six bassins hydrographiques :
*/
die();
}
echo date ('Y/m/d - H:i:s') . " - D<>but du traitement de g<>ocodage des adresses INSEE".EOL;
$db_table='insee_even';
$ret=$iDb->select($db_table, 'MAX(idFlux) as idFlux', "1");
$idFluxFin=$ret[0]['idFlux'];
echo date ('Y/m/d - H:i:s')." - Le dernier flux INSEE g<>ocod<6F> est le flux $idFluxFin !".EOL;
if (!$dateReprise) {
$idFlux=$idFluxFin;
$idFlux3=(substr($idFlux,0,4)*1)-3;
$idFlux3=''.$idFlux3.substr($idFlux,4,6);
}
else {
$idFlux=WDate::dateT('Ymd', 'Y-m-d', $dateReprise);
$idFluxFin=WDate::dateT('Ymd', 'Y-m-d', $dateFin);
echo date ('Y/m/d - H:i:s')." - On r<>applique le g<>ocodage du flux $idFlux au $idFluxFin !".EOL;
}
/*
$nbLoaded=$iDb->select('tmp.epl_eau2', 'id,code,lat,lon,x_93, y_93', "x_93 BETWEEN 280343 AND 830707 AND y_93 BETWEEN 6376956 AND 6857117", false, MYSQL_ASSOC, true);
echo date ('Y/m/d - H:i:s')." - Il y a $nbLoaded points...".EOL;
$nbPointsTot=0;
while($adr=$iDb->fetch(MYSQL_ASSOC)) {
$nbPointsTot++;
//if ($nbPointsTot%2==0)
$tabAdr[$adr['id']]=array( 'cod'=>$adr['code'],
'x93'=>round($adr['x_93']),
'y93'=>round($adr['y_93']));
}
echo date ('Y/m/d - H:i:s')." - Tableau des points g<>n<EFBFBD>r<EFBFBD> : $nbPointsTot points".EOL;
*/
//$nbLoaded=$iDb->select($db_table, 'insL4_VOIE, insNUMVOIE, insINDREP, insTYPVOIE, insLIBVOIE, insCODPOS, insLIBCOM, insDEPCOM, insCODEVOIE, insL7_ETRG, idFlux', "idFlux BETWEEN '$idFlux' AND '$idFluxFin'", false, MYSQL_ASSOC, true);
//$nbLoaded=$iDb->select('jo.etablissements_act', "'' AS insL4_VOIE, adr_num AS insNUMVOIE, adr_btq AS insINDREP, adr_typeVoie AS insTYPVOIE, adr_libVoie AS insLIBVOIE, adr_cp AS insCODPOS, adr_ville AS insLIBCOM, CONCAT(adr_dep*1,adr_com) AS insDEPCOM, rivoli AS insCODEVOIE, '' AS insL7_ETRG, '2012-02-13' AS idFlux, concat(source,source_id) AS id, siren, nic, siege, raisonSociale, enseigne, sigle, adr_comp, adr_dep, adr_com, tel, cj, ape_etab, ape_entrep, eff_etab", "adr_dep IN ('18','018') AND adr_com IN($strCom) AND adr_libVoie<>''", false, MYSQL_ASSOC, true);
$nbLoaded=$iDb->select('jo.etablissements_act', "'' AS insL4_VOIE, adr_num AS insNUMVOIE, adr_btq AS insINDREP, adr_typeVoie AS insTYPVOIE, adr_libVoie AS insLIBVOIE, adr_cp AS insCODPOS, adr_ville AS insLIBCOM, CONCAT(adr_dep*1,adr_com) AS insDEPCOM, rivoli AS insCODEVOIE, '' AS insL7_ETRG, '2012-02-13' AS idFlux, concat(source,source_id) AS id, siren, nic, siege, raisonSociale, enseigne, sigle, adr_comp, adr_dep, adr_com, tel, cj, ape_etab, ape_entrep, eff_etab", "( (adr_dep=41 AND adr_com=001) OR
(adr_dep=41 AND adr_com=002) OR
(adr_dep=41 AND adr_com=003) OR
(adr_dep=41 AND adr_com=004) OR
(adr_dep=41 AND adr_com=005) OR
(adr_dep=41 AND adr_com=006) OR
(adr_dep=41 AND adr_com=007) OR
(adr_dep=41 AND adr_com=008) OR
(adr_dep=41 AND adr_com=009) OR
(adr_dep=41 AND adr_com=010) OR
(adr_dep=41 AND adr_com=011) OR
(adr_dep=41 AND adr_com=012) OR
(adr_dep=41 AND adr_com=013) OR
(adr_dep=41 AND adr_com=014) OR
(adr_dep=41 AND adr_com=015) OR
(adr_dep=41 AND adr_com=016) OR
(adr_dep=41 AND adr_com=017) OR
(adr_dep=41 AND adr_com=018) OR
(adr_dep=41 AND adr_com=019) OR
(adr_dep=41 AND adr_com=020) OR
(adr_dep=41 AND adr_com=022) OR
(adr_dep=41 AND adr_com=023) OR
(adr_dep=41 AND adr_com=024) OR
(adr_dep=41 AND adr_com=025) OR
(adr_dep=41 AND adr_com=026) OR
(adr_dep=41 AND adr_com=027) OR
(adr_dep=41 AND adr_com=028) OR
(adr_dep=41 AND adr_com=029) OR
(adr_dep=41 AND adr_com=030) OR
(adr_dep=41 AND adr_com=031) OR
(adr_dep=41 AND adr_com=032) OR
(adr_dep=41 AND adr_com=033) OR
(adr_dep=41 AND adr_com=034) OR
(adr_dep=41 AND adr_com=035) OR
(adr_dep=41 AND adr_com=036) OR
(adr_dep=41 AND adr_com=037) OR
(adr_dep=41 AND adr_com=038) OR
(adr_dep=41 AND adr_com=039) OR
(adr_dep=41 AND adr_com=040) OR
(adr_dep=41 AND adr_com=041) OR
(adr_dep=41 AND adr_com=042) OR
(adr_dep=41 AND adr_com=043) OR
(adr_dep=41 AND adr_com=044) OR
(adr_dep=41 AND adr_com=045) OR
(adr_dep=41 AND adr_com=046) OR
(adr_dep=41 AND adr_com=047) OR
(adr_dep=41 AND adr_com=048) OR
(adr_dep=41 AND adr_com=049) OR
(adr_dep=41 AND adr_com=050) OR
(adr_dep=41 AND adr_com=051) OR
(adr_dep=41 AND adr_com=052) OR
(adr_dep=41 AND adr_com=053) OR
(adr_dep=41 AND adr_com=054) OR
(adr_dep=41 AND adr_com=055) OR
(adr_dep=41 AND adr_com=056) OR
(adr_dep=41 AND adr_com=057) OR
(adr_dep=41 AND adr_com=058) OR
(adr_dep=41 AND adr_com=059) OR
(adr_dep=41 AND adr_com=060) OR
(adr_dep=41 AND adr_com=061) OR
(adr_dep=41 AND adr_com=062) OR
(adr_dep=41 AND adr_com=063) OR
(adr_dep=41 AND adr_com=064) OR
(adr_dep=41 AND adr_com=065) OR
(adr_dep=41 AND adr_com=066) OR
(adr_dep=41 AND adr_com=067) OR
(adr_dep=41 AND adr_com=068) OR
(adr_dep=41 AND adr_com=069) OR
(adr_dep=41 AND adr_com=070) OR
(adr_dep=41 AND adr_com=071) OR
(adr_dep=41 AND adr_com=072) OR
(adr_dep=41 AND adr_com=073) OR
(adr_dep=41 AND adr_com=074) OR
(adr_dep=41 AND adr_com=075) OR
(adr_dep=41 AND adr_com=077) OR
(adr_dep=41 AND adr_com=078) OR
(adr_dep=41 AND adr_com=079) OR
(adr_dep=41 AND adr_com=080) OR
(adr_dep=41 AND adr_com=081) OR
(adr_dep=41 AND adr_com=082) OR
(adr_dep=41 AND adr_com=083) OR
(adr_dep=41 AND adr_com=084) OR
(adr_dep=41 AND adr_com=085) OR
(adr_dep=41 AND adr_com=086) OR
(adr_dep=41 AND adr_com=087) OR
(adr_dep=41 AND adr_com=088) OR
(adr_dep=41 AND adr_com=089) OR
(adr_dep=41 AND adr_com=090) OR
(adr_dep=41 AND adr_com=091) OR
(adr_dep=41 AND adr_com=092) OR
(adr_dep=41 AND adr_com=093) OR
(adr_dep=41 AND adr_com=094) OR
(adr_dep=41 AND adr_com=095) OR
(adr_dep=41 AND adr_com=096) OR
(adr_dep=41 AND adr_com=097) OR
(adr_dep=41 AND adr_com=098) OR
(adr_dep=41 AND adr_com=099) OR
(adr_dep=41 AND adr_com=100) OR
(adr_dep=41 AND adr_com=101) OR
(adr_dep=41 AND adr_com=102) OR
(adr_dep=41 AND adr_com=103) OR
(adr_dep=41 AND adr_com=104) OR
(adr_dep=41 AND adr_com=105) OR
(adr_dep=41 AND adr_com=106) OR
(adr_dep=41 AND adr_com=107) OR
(adr_dep=41 AND adr_com=108) OR
(adr_dep=41 AND adr_com=109) OR
(adr_dep=41 AND adr_com=110) OR
(adr_dep=41 AND adr_com=112) OR
(adr_dep=41 AND adr_com=113) OR
(adr_dep=41 AND adr_com=114) OR
(adr_dep=41 AND adr_com=115) OR
(adr_dep=41 AND adr_com=116) OR
(adr_dep=41 AND adr_com=118) OR
(adr_dep=41 AND adr_com=119) OR
(adr_dep=41 AND adr_com=120) OR
(adr_dep=41 AND adr_com=121) OR
(adr_dep=41 AND adr_com=122) OR
(adr_dep=41 AND adr_com=123) OR
(adr_dep=41 AND adr_com=124) OR
(adr_dep=41 AND adr_com=125) OR
(adr_dep=41 AND adr_com=126) OR
(adr_dep=41 AND adr_com=127) OR
(adr_dep=41 AND adr_com=128) OR
(adr_dep=41 AND adr_com=129) OR
(adr_dep=41 AND adr_com=130) OR
(adr_dep=41 AND adr_com=131) OR
(adr_dep=41 AND adr_com=132) OR
(adr_dep=41 AND adr_com=133) OR
(adr_dep=41 AND adr_com=134) OR
(adr_dep=41 AND adr_com=135) OR
(adr_dep=41 AND adr_com=136) OR
(adr_dep=41 AND adr_com=137) OR
(adr_dep=41 AND adr_com=138) OR
(adr_dep=41 AND adr_com=139) OR
(adr_dep=41 AND adr_com=140) OR
(adr_dep=41 AND adr_com=141) OR
(adr_dep=41 AND adr_com=142) OR
(adr_dep=41 AND adr_com=143) OR
(adr_dep=41 AND adr_com=144) OR
(adr_dep=41 AND adr_com=145) OR
(adr_dep=41 AND adr_com=146) OR
(adr_dep=41 AND adr_com=147) OR
(adr_dep=41 AND adr_com=148) OR
(adr_dep=41 AND adr_com=149) OR
(adr_dep=41 AND adr_com=150) OR
(adr_dep=41 AND adr_com=151) OR
(adr_dep=41 AND adr_com=152) OR
(adr_dep=41 AND adr_com=153) OR
(adr_dep=41 AND adr_com=154) OR
(adr_dep=41 AND adr_com=155) OR
(adr_dep=41 AND adr_com=156) OR
(adr_dep=41 AND adr_com=157) OR
(adr_dep=41 AND adr_com=158) OR
(adr_dep=41 AND adr_com=159) OR
(adr_dep=41 AND adr_com=160) OR
(adr_dep=41 AND adr_com=161) OR
(adr_dep=41 AND adr_com=163) OR
(adr_dep=41 AND adr_com=164) OR
(adr_dep=41 AND adr_com=165) OR
(adr_dep=41 AND adr_com=166) OR
(adr_dep=41 AND adr_com=167) OR
(adr_dep=41 AND adr_com=168) OR
(adr_dep=41 AND adr_com=169) OR
(adr_dep=41 AND adr_com=170) OR
(adr_dep=41 AND adr_com=171) OR
(adr_dep=41 AND adr_com=172) OR
(adr_dep=41 AND adr_com=173) OR
(adr_dep=41 AND adr_com=174) OR
(adr_dep=41 AND adr_com=175) OR
(adr_dep=41 AND adr_com=176) OR
(adr_dep=41 AND adr_com=177) OR
(adr_dep=41 AND adr_com=178) OR
(adr_dep=41 AND adr_com=179) OR
(adr_dep=41 AND adr_com=180) OR
(adr_dep=41 AND adr_com=181) OR
(adr_dep=41 AND adr_com=182) OR
(adr_dep=41 AND adr_com=183) OR
(adr_dep=41 AND adr_com=184) OR
(adr_dep=41 AND adr_com=185) OR
(adr_dep=41 AND adr_com=186) OR
(adr_dep=41 AND adr_com=187) OR
(adr_dep=41 AND adr_com=188) OR
(adr_dep=41 AND adr_com=189) OR
(adr_dep=41 AND adr_com=190) OR
(adr_dep=41 AND adr_com=191) OR
(adr_dep=41 AND adr_com=192) OR
(adr_dep=41 AND adr_com=193) OR
(adr_dep=41 AND adr_com=194) OR
(adr_dep=41 AND adr_com=195) OR
(adr_dep=41 AND adr_com=196) OR
(adr_dep=41 AND adr_com=197) OR
(adr_dep=41 AND adr_com=198) OR
(adr_dep=41 AND adr_com=199) OR
(adr_dep=41 AND adr_com=200) OR
(adr_dep=41 AND adr_com=201) OR
(adr_dep=41 AND adr_com=202) OR
(adr_dep=41 AND adr_com=203) OR
(adr_dep=41 AND adr_com=204) OR
(adr_dep=41 AND adr_com=205) OR
(adr_dep=41 AND adr_com=206) OR
(adr_dep=41 AND adr_com=207) OR
(adr_dep=41 AND adr_com=208) OR
(adr_dep=41 AND adr_com=209) OR
(adr_dep=41 AND adr_com=210) OR
(adr_dep=41 AND adr_com=211) OR
(adr_dep=41 AND adr_com=212) OR
(adr_dep=41 AND adr_com=213) OR
(adr_dep=41 AND adr_com=214) OR
(adr_dep=41 AND adr_com=215) OR
(adr_dep=41 AND adr_com=216) OR
(adr_dep=41 AND adr_com=217) OR
(adr_dep=41 AND adr_com=218) OR
(adr_dep=41 AND adr_com=219) OR
(adr_dep=41 AND adr_com=220) OR
(adr_dep=41 AND adr_com=221) OR
(adr_dep=41 AND adr_com=222) OR
(adr_dep=41 AND adr_com=223) OR
(adr_dep=41 AND adr_com=224) OR
(adr_dep=41 AND adr_com=225) OR
(adr_dep=41 AND adr_com=226) OR
(adr_dep=41 AND adr_com=228) OR
(adr_dep=41 AND adr_com=229) OR
(adr_dep=41 AND adr_com=230) OR
(adr_dep=41 AND adr_com=231) OR
(adr_dep=41 AND adr_com=232) OR
(adr_dep=41 AND adr_com=233) OR
(adr_dep=41 AND adr_com=234) OR
(adr_dep=41 AND adr_com=235) OR
(adr_dep=41 AND adr_com=236) OR
(adr_dep=41 AND adr_com=237) OR
(adr_dep=41 AND adr_com=238) OR
(adr_dep=41 AND adr_com=239) OR
(adr_dep=41 AND adr_com=240) OR
(adr_dep=41 AND adr_com=241) OR
(adr_dep=41 AND adr_com=242) OR
(adr_dep=41 AND adr_com=243) OR
(adr_dep=41 AND adr_com=244) OR
(adr_dep=41 AND adr_com=245) OR
(adr_dep=41 AND adr_com=246) OR
(adr_dep=41 AND adr_com=247) OR
(adr_dep=41 AND adr_com=248) OR
(adr_dep=41 AND adr_com=249) OR
(adr_dep=41 AND adr_com=250) OR
(adr_dep=41 AND adr_com=251) OR
(adr_dep=41 AND adr_com=252) OR
(adr_dep=41 AND adr_com=253) OR
(adr_dep=41 AND adr_com=254) OR
(adr_dep=41 AND adr_com=255) OR
(adr_dep=41 AND adr_com=256) OR
(adr_dep=41 AND adr_com=257) OR
(adr_dep=41 AND adr_com=258) OR
(adr_dep=41 AND adr_com=259) OR
(adr_dep=41 AND adr_com=260) OR
(adr_dep=41 AND adr_com=261) OR
(adr_dep=41 AND adr_com=262) OR
(adr_dep=41 AND adr_com=263) OR
(adr_dep=41 AND adr_com=264) OR
(adr_dep=41 AND adr_com=265) OR
(adr_dep=41 AND adr_com=266) OR
(adr_dep=41 AND adr_com=267) OR
(adr_dep=41 AND adr_com=268) OR
(adr_dep=41 AND adr_com=269) OR
(adr_dep=41 AND adr_com=270) OR
(adr_dep=41 AND adr_com=271) OR
(adr_dep=41 AND adr_com=272) OR
(adr_dep=41 AND adr_com=273) OR
(adr_dep=41 AND adr_com=274) OR
(adr_dep=41 AND adr_com=275) OR
(adr_dep=41 AND adr_com=276) OR
(adr_dep=41 AND adr_com=277) OR
(adr_dep=41 AND adr_com=278) OR
(adr_dep=41 AND adr_com=279) OR
(adr_dep=41 AND adr_com=280) OR
(adr_dep=41 AND adr_com=281) OR
(adr_dep=41 AND adr_com=282) OR
(adr_dep=41 AND adr_com=283) OR
(adr_dep=41 AND adr_com=284) OR
(adr_dep=41 AND adr_com=285) OR
(adr_dep=41 AND adr_com=286) OR
(adr_dep=41 AND adr_com=287) OR
(adr_dep=41 AND adr_com=288) OR
(adr_dep=41 AND adr_com=289) OR
(adr_dep=41 AND adr_com=290) OR
(adr_dep=41 AND adr_com=291) OR
(adr_dep=41 AND adr_com=292) OR
(adr_dep=41 AND adr_com=293) OR
(adr_dep=41 AND adr_com=294) OR
(adr_dep=41 AND adr_com=295) OR
(adr_dep=41 AND adr_com=296) OR
(adr_dep=41 AND adr_com=297) OR
(adr_dep=42 AND adr_com=001) OR
(adr_dep=42 AND adr_com=002) OR
(adr_dep=42 AND adr_com=003) OR
(adr_dep=42 AND adr_com=004) OR
(adr_dep=42 AND adr_com=005) OR
(adr_dep=42 AND adr_com=006) OR
(adr_dep=42 AND adr_com=007) OR
(adr_dep=42 AND adr_com=008) OR
(adr_dep=42 AND adr_com=009) OR
(adr_dep=42 AND adr_com=010) OR
(adr_dep=42 AND adr_com=011) OR
(adr_dep=42 AND adr_com=012) OR
(adr_dep=42 AND adr_com=013) OR
(adr_dep=42 AND adr_com=015) OR
(adr_dep=42 AND adr_com=016) OR
(adr_dep=42 AND adr_com=019) OR
(adr_dep=42 AND adr_com=020) OR
(adr_dep=42 AND adr_com=021) OR
(adr_dep=42 AND adr_com=022) OR
(adr_dep=42 AND adr_com=025) OR
(adr_dep=42 AND adr_com=026) OR
(adr_dep=42 AND adr_com=027) OR
(adr_dep=42 AND adr_com=029) OR
(adr_dep=42 AND adr_com=030) OR
(adr_dep=42 AND adr_com=031) OR
(adr_dep=42 AND adr_com=033) OR
(adr_dep=42 AND adr_com=034) OR
(adr_dep=42 AND adr_com=035) OR
(adr_dep=42 AND adr_com=037) OR
(adr_dep=42 AND adr_com=038) OR
(adr_dep=42 AND adr_com=039) OR
(adr_dep=42 AND adr_com=040) OR
(adr_dep=42 AND adr_com=041) OR
(adr_dep=42 AND adr_com=042) OR
(adr_dep=42 AND adr_com=043) OR
(adr_dep=42 AND adr_com=044) OR
(adr_dep=42 AND adr_com=045) OR
(adr_dep=42 AND adr_com=046) OR
(adr_dep=42 AND adr_com=047) OR
(adr_dep=42 AND adr_com=048) OR
(adr_dep=42 AND adr_com=049) OR
(adr_dep=42 AND adr_com=050) OR
(adr_dep=42 AND adr_com=052) OR
(adr_dep=42 AND adr_com=054) OR
(adr_dep=42 AND adr_com=055) OR
(adr_dep=42 AND adr_com=058) OR
(adr_dep=42 AND adr_com=060) OR
(adr_dep=42 AND adr_com=061) OR
(adr_dep=42 AND adr_com=062) OR
(adr_dep=42 AND adr_com=063) OR
(adr_dep=42 AND adr_com=065) OR
(adr_dep=42 AND adr_com=066) OR
(adr_dep=42 AND adr_com=068) OR
(adr_dep=42 AND adr_com=069) OR
(adr_dep=42 AND adr_com=070) OR
(adr_dep=42 AND adr_com=071) OR
(adr_dep=42 AND adr_com=072) OR
(adr_dep=42 AND adr_com=073) OR
(adr_dep=42 AND adr_com=074) OR
(adr_dep=42 AND adr_com=075) OR
(adr_dep=42 AND adr_com=076) OR
(adr_dep=42 AND adr_com=077) OR
(adr_dep=42 AND adr_com=078) OR
(adr_dep=42 AND adr_com=079) OR
(adr_dep=42 AND adr_com=081) OR
(adr_dep=42 AND adr_com=082) OR
(adr_dep=42 AND adr_com=084) OR
(adr_dep=42 AND adr_com=086) OR
(adr_dep=42 AND adr_com=087) OR
(adr_dep=42 AND adr_com=088) OR
(adr_dep=42 AND adr_com=089) OR
(adr_dep=42 AND adr_com=090) OR
(adr_dep=42 AND adr_com=091) OR
(adr_dep=42 AND adr_com=092) OR
(adr_dep=42 AND adr_com=094) OR
(adr_dep=42 AND adr_com=095) OR
(adr_dep=42 AND adr_com=096) OR
(adr_dep=42 AND adr_com=097) OR
(adr_dep=42 AND adr_com=098) OR
(adr_dep=42 AND adr_com=099) OR
(adr_dep=42 AND adr_com=100) OR
(adr_dep=42 AND adr_com=102) OR
(adr_dep=42 AND adr_com=104) OR
(adr_dep=42 AND adr_com=105) OR
(adr_dep=42 AND adr_com=106) OR
(adr_dep=42 AND adr_com=107) OR
(adr_dep=42 AND adr_com=108) OR
(adr_dep=42 AND adr_com=109) OR
(adr_dep=42 AND adr_com=112) OR
(adr_dep=42 AND adr_com=113) OR
(adr_dep=42 AND adr_com=114) OR
(adr_dep=42 AND adr_com=115) OR
(adr_dep=42 AND adr_com=116) OR
(adr_dep=42 AND adr_com=117) OR
(adr_dep=42 AND adr_com=118) OR
(adr_dep=42 AND adr_com=119) OR
(adr_dep=42 AND adr_com=120) OR
(adr_dep=42 AND adr_com=121) OR
(adr_dep=42 AND adr_com=122) OR
(adr_dep=42 AND adr_com=125) OR
(adr_dep=42 AND adr_com=126) OR
(adr_dep=42 AND adr_com=127) OR
(adr_dep=42 AND adr_com=130) OR
(adr_dep=42 AND adr_com=131) OR
(adr_dep=42 AND adr_com=134) OR
(adr_dep=42 AND adr_com=135) OR
(adr_dep=42 AND adr_com=136) OR
(adr_dep=42 AND adr_com=137) OR
(adr_dep=42 AND adr_com=139) OR
(adr_dep=42 AND adr_com=140) OR
(adr_dep=42 AND adr_com=141) OR
(adr_dep=42 AND adr_com=142) OR
(adr_dep=42 AND adr_com=143) OR
(adr_dep=42 AND adr_com=145) OR
(adr_dep=42 AND adr_com=146) OR
(adr_dep=42 AND adr_com=147) OR
(adr_dep=42 AND adr_com=148) OR
(adr_dep=42 AND adr_com=149) OR
(adr_dep=42 AND adr_com=150) OR
(adr_dep=42 AND adr_com=151) OR
(adr_dep=42 AND adr_com=152) OR
(adr_dep=42 AND adr_com=153) OR
(adr_dep=42 AND adr_com=154) OR
(adr_dep=42 AND adr_com=155) OR
(adr_dep=42 AND adr_com=156) OR
(adr_dep=42 AND adr_com=157) OR
(adr_dep=42 AND adr_com=158) OR
(adr_dep=42 AND adr_com=159) OR
(adr_dep=42 AND adr_com=160) OR
(adr_dep=42 AND adr_com=161) OR
(adr_dep=42 AND adr_com=162) OR
(adr_dep=42 AND adr_com=163) OR
(adr_dep=42 AND adr_com=164) OR
(adr_dep=42 AND adr_com=165) OR
(adr_dep=42 AND adr_com=166) OR
(adr_dep=42 AND adr_com=169) OR
(adr_dep=42 AND adr_com=170) OR
(adr_dep=42 AND adr_com=171) OR
(adr_dep=42 AND adr_com=172) OR
(adr_dep=42 AND adr_com=173) OR
(adr_dep=42 AND adr_com=174) OR
(adr_dep=42 AND adr_com=175) OR
(adr_dep=42 AND adr_com=176) OR
(adr_dep=42 AND adr_com=177) OR
(adr_dep=42 AND adr_com=178) OR
(adr_dep=42 AND adr_com=179) OR
(adr_dep=42 AND adr_com=180) OR
(adr_dep=42 AND adr_com=181) OR
(adr_dep=42 AND adr_com=182) OR
(adr_dep=42 AND adr_com=183) OR
(adr_dep=42 AND adr_com=184) OR
(adr_dep=42 AND adr_com=185) OR
(adr_dep=42 AND adr_com=187) OR
(adr_dep=42 AND adr_com=188) OR
(adr_dep=42 AND adr_com=189) OR
(adr_dep=42 AND adr_com=192) OR
(adr_dep=42 AND adr_com=193) OR
(adr_dep=42 AND adr_com=194) OR
(adr_dep=42 AND adr_com=195) OR
(adr_dep=42 AND adr_com=196) OR
(adr_dep=42 AND adr_com=197) OR
(adr_dep=42 AND adr_com=198) OR
(adr_dep=42 AND adr_com=199) OR
(adr_dep=42 AND adr_com=200) OR
(adr_dep=42 AND adr_com=202) OR
(adr_dep=42 AND adr_com=203) OR
(adr_dep=42 AND adr_com=204) OR
(adr_dep=42 AND adr_com=205) OR
(adr_dep=42 AND adr_com=206) OR
(adr_dep=42 AND adr_com=209) OR
(adr_dep=42 AND adr_com=211) OR
(adr_dep=42 AND adr_com=212) OR
(adr_dep=42 AND adr_com=214) OR
(adr_dep=42 AND adr_com=215) OR
(adr_dep=42 AND adr_com=216) OR
(adr_dep=42 AND adr_com=217) OR
(adr_dep=42 AND adr_com=219) OR
(adr_dep=42 AND adr_com=220) OR
(adr_dep=42 AND adr_com=221) OR
(adr_dep=42 AND adr_com=222) OR
(adr_dep=42 AND adr_com=223) OR
(adr_dep=42 AND adr_com=226) OR
(adr_dep=42 AND adr_com=227) OR
(adr_dep=42 AND adr_com=228) OR
(adr_dep=42 AND adr_com=229) OR
(adr_dep=42 AND adr_com=230) OR
(adr_dep=42 AND adr_com=231) OR
(adr_dep=42 AND adr_com=232) OR
(adr_dep=42 AND adr_com=233) OR
(adr_dep=42 AND adr_com=234) OR
(adr_dep=42 AND adr_com=235) OR
(adr_dep=42 AND adr_com=236) OR
(adr_dep=42 AND adr_com=238) OR
(adr_dep=42 AND adr_com=239) OR
(adr_dep=42 AND adr_com=240) OR
(adr_dep=42 AND adr_com=241) OR
(adr_dep=42 AND adr_com=243) OR
(adr_dep=42 AND adr_com=245) OR
(adr_dep=42 AND adr_com=247) OR
(adr_dep=42 AND adr_com=248) OR
(adr_dep=42 AND adr_com=249) OR
(adr_dep=42 AND adr_com=251) OR
(adr_dep=42 AND adr_com=252) OR
(adr_dep=42 AND adr_com=253) OR
(adr_dep=42 AND adr_com=254) OR
(adr_dep=42 AND adr_com=255) OR
(adr_dep=42 AND adr_com=256) OR
(adr_dep=42 AND adr_com=257) OR
(adr_dep=42 AND adr_com=260) OR
(adr_dep=42 AND adr_com=261) OR
(adr_dep=42 AND adr_com=262) OR
(adr_dep=42 AND adr_com=264) OR
(adr_dep=42 AND adr_com=266) OR
(adr_dep=42 AND adr_com=267) OR
(adr_dep=42 AND adr_com=268) OR
(adr_dep=42 AND adr_com=269) OR
(adr_dep=42 AND adr_com=270) OR
(adr_dep=42 AND adr_com=273) OR
(adr_dep=42 AND adr_com=274) OR
(adr_dep=42 AND adr_com=275) OR
(adr_dep=42 AND adr_com=276) OR
(adr_dep=42 AND adr_com=277) OR
(adr_dep=42 AND adr_com=278) OR
(adr_dep=42 AND adr_com=279) OR
(adr_dep=42 AND adr_com=281) OR
(adr_dep=42 AND adr_com=282) OR
(adr_dep=42 AND adr_com=284) OR
(adr_dep=42 AND adr_com=285) OR
(adr_dep=42 AND adr_com=286) OR
(adr_dep=42 AND adr_com=288) OR
(adr_dep=42 AND adr_com=289) OR
(adr_dep=42 AND adr_com=290) OR
(adr_dep=42 AND adr_com=291) OR
(adr_dep=42 AND adr_com=293) OR
(adr_dep=42 AND adr_com=294) OR
(adr_dep=42 AND adr_com=295) OR
(adr_dep=42 AND adr_com=296) OR
(adr_dep=42 AND adr_com=297) OR
(adr_dep=42 AND adr_com=298) OR
(adr_dep=42 AND adr_com=299) OR
(adr_dep=42 AND adr_com=300) OR
(adr_dep=42 AND adr_com=301) OR
(adr_dep=42 AND adr_com=303) OR
(adr_dep=42 AND adr_com=304) OR
(adr_dep=42 AND adr_com=305) OR
(adr_dep=42 AND adr_com=311) OR
(adr_dep=42 AND adr_com=312) OR
(adr_dep=42 AND adr_com=313) OR
(adr_dep=42 AND adr_com=314) OR
(adr_dep=42 AND adr_com=315) OR
(adr_dep=42 AND adr_com=316) OR
(adr_dep=42 AND adr_com=317) OR
(adr_dep=42 AND adr_com=318) OR
(adr_dep=42 AND adr_com=319) OR
(adr_dep=42 AND adr_com=321) OR
(adr_dep=42 AND adr_com=323) OR
(adr_dep=42 AND adr_com=324) OR
(adr_dep=42 AND adr_com=325) OR
(adr_dep=42 AND adr_com=328) OR
(adr_dep=42 AND adr_com=330) OR
(adr_dep=42 AND adr_com=331) OR
(adr_dep=42 AND adr_com=332) OR
(adr_dep=42 AND adr_com=333) OR
(adr_dep=42 AND adr_com=337) OR
(adr_dep=42 AND adr_com=338) OR
(adr_dep=42 AND adr_com=339) OR
(adr_dep=42 AND adr_com=014) OR
(adr_dep=42 AND adr_com=017) OR
(adr_dep=42 AND adr_com=059) OR
(adr_dep=42 AND adr_com=128) OR
(adr_dep=42 AND adr_com=133) OR
(adr_dep=42 AND adr_com=138) OR
(adr_dep=42 AND adr_com=208) OR
(adr_dep=42 AND adr_com=213) OR
(adr_dep=42 AND adr_com=218) OR
(adr_dep=42 AND adr_com=224) OR
(adr_dep=42 AND adr_com=237) OR
(adr_dep=42 AND adr_com=280) OR
(adr_dep=42 AND adr_com=283) OR
(adr_dep=42 AND adr_com=302) OR
(adr_dep=42 AND adr_com=306) OR
(adr_dep=42 AND adr_com=334) OR
(adr_dep=42 AND adr_com=335) OR
(adr_dep=42 AND adr_com=336) OR
(adr_dep=43 AND adr_com=001) OR
(adr_dep=43 AND adr_com=002) OR
(adr_dep=43 AND adr_com=003) OR
(adr_dep=43 AND adr_com=004) OR
(adr_dep=43 AND adr_com=005) OR
(adr_dep=43 AND adr_com=006) OR
(adr_dep=43 AND adr_com=007) OR
(adr_dep=43 AND adr_com=008) OR
(adr_dep=43 AND adr_com=009) OR
(adr_dep=43 AND adr_com=010) OR
(adr_dep=43 AND adr_com=011) OR
(adr_dep=43 AND adr_com=012) OR
(adr_dep=43 AND adr_com=013) OR
(adr_dep=43 AND adr_com=014) OR
(adr_dep=43 AND adr_com=015) OR
(adr_dep=43 AND adr_com=016) OR
(adr_dep=43 AND adr_com=017) OR
(adr_dep=43 AND adr_com=018) OR
(adr_dep=43 AND adr_com=019) OR
(adr_dep=43 AND adr_com=020) OR
(adr_dep=43 AND adr_com=021) OR
(adr_dep=43 AND adr_com=022) OR
(adr_dep=43 AND adr_com=023) OR
(adr_dep=43 AND adr_com=024) OR
(adr_dep=43 AND adr_com=025) OR
(adr_dep=43 AND adr_com=026) OR
(adr_dep=43 AND adr_com=027) OR
(adr_dep=43 AND adr_com=028) OR
(adr_dep=43 AND adr_com=029) OR
(adr_dep=43 AND adr_com=030) OR
(adr_dep=43 AND adr_com=031) OR
(adr_dep=43 AND adr_com=032) OR
(adr_dep=43 AND adr_com=033) OR
(adr_dep=43 AND adr_com=034) OR
(adr_dep=43 AND adr_com=035) OR
(adr_dep=43 AND adr_com=036) OR
(adr_dep=43 AND adr_com=037) OR
(adr_dep=43 AND adr_com=038) OR
(adr_dep=43 AND adr_com=039) OR
(adr_dep=43 AND adr_com=040) OR
(adr_dep=43 AND adr_com=041) OR
(adr_dep=43 AND adr_com=042) OR
(adr_dep=43 AND adr_com=043) OR
(adr_dep=43 AND adr_com=044) OR
(adr_dep=43 AND adr_com=045) OR
(adr_dep=43 AND adr_com=046) OR
(adr_dep=43 AND adr_com=047) OR
(adr_dep=43 AND adr_com=048) OR
(adr_dep=43 AND adr_com=049) OR
(adr_dep=43 AND adr_com=050) OR
(adr_dep=43 AND adr_com=052) OR
(adr_dep=43 AND adr_com=053) OR
(adr_dep=43 AND adr_com=055) OR
(adr_dep=43 AND adr_com=056) OR
(adr_dep=43 AND adr_com=057) OR
(adr_dep=43 AND adr_com=058) OR
(adr_dep=43 AND adr_com=059) OR
(adr_dep=43 AND adr_com=060) OR
(adr_dep=43 AND adr_com=061) OR
(adr_dep=43 AND adr_com=062) OR
(adr_dep=43 AND adr_com=063) OR
(adr_dep=43 AND adr_com=064) OR
(adr_dep=43 AND adr_com=065) OR
(adr_dep=43 AND adr_com=067) OR
(adr_dep=43 AND adr_com=068) OR
(adr_dep=43 AND adr_com=069) OR
(adr_dep=43 AND adr_com=070) OR
(adr_dep=43 AND adr_com=071) OR
(adr_dep=43 AND adr_com=072) OR
(adr_dep=43 AND adr_com=073) OR
(adr_dep=43 AND adr_com=074) OR
(adr_dep=43 AND adr_com=075) OR
(adr_dep=43 AND adr_com=076) OR
(adr_dep=43 AND adr_com=077) OR
(adr_dep=43 AND adr_com=078) OR
(adr_dep=43 AND adr_com=079) OR
(adr_dep=43 AND adr_com=080) OR
(adr_dep=43 AND adr_com=081) OR
(adr_dep=43 AND adr_com=082) OR
(adr_dep=43 AND adr_com=083) OR
(adr_dep=43 AND adr_com=084) OR
(adr_dep=43 AND adr_com=085) OR
(adr_dep=43 AND adr_com=086) OR
(adr_dep=43 AND adr_com=087) OR
(adr_dep=43 AND adr_com=088) OR
(adr_dep=43 AND adr_com=089) OR
(adr_dep=43 AND adr_com=090) OR
(adr_dep=43 AND adr_com=092) OR
(adr_dep=43 AND adr_com=093) OR
(adr_dep=43 AND adr_com=094) OR
(adr_dep=43 AND adr_com=095) OR
(adr_dep=43 AND adr_com=096) OR
(adr_dep=43 AND adr_com=097) OR
(adr_dep=43 AND adr_com=098) OR
(adr_dep=43 AND adr_com=099) OR
(adr_dep=43 AND adr_com=100) OR
(adr_dep=43 AND adr_com=101) OR
(adr_dep=43 AND adr_com=102) OR
(adr_dep=43 AND adr_com=103) OR
(adr_dep=43 AND adr_com=105) OR
(adr_dep=43 AND adr_com=106) OR
(adr_dep=43 AND adr_com=107) OR
(adr_dep=43 AND adr_com=108) OR
(adr_dep=43 AND adr_com=109) OR
(adr_dep=43 AND adr_com=110) OR
(adr_dep=43 AND adr_com=111) OR
(adr_dep=43 AND adr_com=112) OR
(adr_dep=43 AND adr_com=113) OR
(adr_dep=43 AND adr_com=114) OR
(adr_dep=43 AND adr_com=115) OR
(adr_dep=43 AND adr_com=116) OR
(adr_dep=43 AND adr_com=117) OR
(adr_dep=43 AND adr_com=118) OR
(adr_dep=43 AND adr_com=119) OR
(adr_dep=43 AND adr_com=120) OR
(adr_dep=43 AND adr_com=121) OR
(adr_dep=43 AND adr_com=122) OR
(adr_dep=43 AND adr_com=123) OR
(adr_dep=43 AND adr_com=124) OR
(adr_dep=43 AND adr_com=125) OR
(adr_dep=43 AND adr_com=126) OR
(adr_dep=43 AND adr_com=127) OR
(adr_dep=43 AND adr_com=128) OR
(adr_dep=43 AND adr_com=130) OR
(adr_dep=43 AND adr_com=131) OR
(adr_dep=43 AND adr_com=132) OR
(adr_dep=43 AND adr_com=133) OR
(adr_dep=43 AND adr_com=134) OR
(adr_dep=43 AND adr_com=135) OR
(adr_dep=43 AND adr_com=136) OR
(adr_dep=43 AND adr_com=137) OR
(adr_dep=43 AND adr_com=138) OR
(adr_dep=43 AND adr_com=139) OR
(adr_dep=43 AND adr_com=140) OR
(adr_dep=43 AND adr_com=141) OR
(adr_dep=43 AND adr_com=142) OR
(adr_dep=43 AND adr_com=143) OR
(adr_dep=43 AND adr_com=144) OR
(adr_dep=43 AND adr_com=145) OR
(adr_dep=43 AND adr_com=147) OR
(adr_dep=43 AND adr_com=148) OR
(adr_dep=43 AND adr_com=149) OR
(adr_dep=43 AND adr_com=150) OR
(adr_dep=43 AND adr_com=151) OR
(adr_dep=43 AND adr_com=152) OR
(adr_dep=43 AND adr_com=153) OR
(adr_dep=43 AND adr_com=154) OR
(adr_dep=43 AND adr_com=155) OR
(adr_dep=43 AND adr_com=156) OR
(adr_dep=43 AND adr_com=157) OR
(adr_dep=43 AND adr_com=158) OR
(adr_dep=43 AND adr_com=159) OR
(adr_dep=43 AND adr_com=160) OR
(adr_dep=43 AND adr_com=162) OR
(adr_dep=43 AND adr_com=164) OR
(adr_dep=43 AND adr_com=165) OR
(adr_dep=43 AND adr_com=166) OR
(adr_dep=43 AND adr_com=167) OR
(adr_dep=43 AND adr_com=168) OR
(adr_dep=43 AND adr_com=169) OR
(adr_dep=43 AND adr_com=170) OR
(adr_dep=43 AND adr_com=171) OR
(adr_dep=43 AND adr_com=173) OR
(adr_dep=43 AND adr_com=174) OR
(adr_dep=43 AND adr_com=175) OR
(adr_dep=43 AND adr_com=176) OR
(adr_dep=43 AND adr_com=177) OR
(adr_dep=43 AND adr_com=178) OR
(adr_dep=43 AND adr_com=180) OR
(adr_dep=43 AND adr_com=181) OR
(adr_dep=43 AND adr_com=182) OR
(adr_dep=43 AND adr_com=183) OR
(adr_dep=43 AND adr_com=184) OR
(adr_dep=43 AND adr_com=185) OR
(adr_dep=43 AND adr_com=186) OR
(adr_dep=43 AND adr_com=187) OR
(adr_dep=43 AND adr_com=188) OR
(adr_dep=43 AND adr_com=189) OR
(adr_dep=43 AND adr_com=190) OR
(adr_dep=43 AND adr_com=191) OR
(adr_dep=43 AND adr_com=192) OR
(adr_dep=43 AND adr_com=193) OR
(adr_dep=43 AND adr_com=194) OR
(adr_dep=43 AND adr_com=195) OR
(adr_dep=43 AND adr_com=196) OR
(adr_dep=43 AND adr_com=197) OR
(adr_dep=43 AND adr_com=198) OR
(adr_dep=43 AND adr_com=199) OR
(adr_dep=43 AND adr_com=200) OR
(adr_dep=43 AND adr_com=201) OR
(adr_dep=43 AND adr_com=202) OR
(adr_dep=43 AND adr_com=203) OR
(adr_dep=43 AND adr_com=205) OR
(adr_dep=43 AND adr_com=206) OR
(adr_dep=43 AND adr_com=207) OR
(adr_dep=43 AND adr_com=208) OR
(adr_dep=43 AND adr_com=210) OR
(adr_dep=43 AND adr_com=211) OR
(adr_dep=43 AND adr_com=212) OR
(adr_dep=43 AND adr_com=213) OR
(adr_dep=43 AND adr_com=214) OR
(adr_dep=43 AND adr_com=215) OR
(adr_dep=43 AND adr_com=216) OR
(adr_dep=43 AND adr_com=217) OR
(adr_dep=43 AND adr_com=218) OR
(adr_dep=43 AND adr_com=219) OR
(adr_dep=43 AND adr_com=220) OR
(adr_dep=43 AND adr_com=221) OR
(adr_dep=43 AND adr_com=222) OR
(adr_dep=43 AND adr_com=223) OR
(adr_dep=43 AND adr_com=224) OR
(adr_dep=43 AND adr_com=225) OR
(adr_dep=43 AND adr_com=226) OR
(adr_dep=43 AND adr_com=227) OR
(adr_dep=43 AND adr_com=228) OR
(adr_dep=43 AND adr_com=229) OR
(adr_dep=43 AND adr_com=230) OR
(adr_dep=43 AND adr_com=231) OR
(adr_dep=43 AND adr_com=232) OR
(adr_dep=43 AND adr_com=233) OR
(adr_dep=43 AND adr_com=234) OR
(adr_dep=43 AND adr_com=236) OR
(adr_dep=43 AND adr_com=237) OR
(adr_dep=43 AND adr_com=238) OR
(adr_dep=43 AND adr_com=239) OR
(adr_dep=43 AND adr_com=240) OR
(adr_dep=43 AND adr_com=241) OR
(adr_dep=43 AND adr_com=242) OR
(adr_dep=43 AND adr_com=244) OR
(adr_dep=43 AND adr_com=245) OR
(adr_dep=43 AND adr_com=246) OR
(adr_dep=43 AND adr_com=247) OR
(adr_dep=43 AND adr_com=249) OR
(adr_dep=43 AND adr_com=250) OR
(adr_dep=43 AND adr_com=251) OR
(adr_dep=43 AND adr_com=252) OR
(adr_dep=43 AND adr_com=254) OR
(adr_dep=43 AND adr_com=255) OR
(adr_dep=43 AND adr_com=256) OR
(adr_dep=43 AND adr_com=257) OR
(adr_dep=43 AND adr_com=258) OR
(adr_dep=43 AND adr_com=259) OR
(adr_dep=43 AND adr_com=260) OR
(adr_dep=43 AND adr_com=261) OR
(adr_dep=43 AND adr_com=262) OR
(adr_dep=43 AND adr_com=263) OR
(adr_dep=43 AND adr_com=264) OR
(adr_dep=43 AND adr_com=265) OR
(adr_dep=43 AND adr_com=267) OR
(adr_dep=43 AND adr_com=268) OR
(adr_dep=43 AND adr_com=051) OR
(adr_dep=43 AND adr_com=054) OR
(adr_dep=43 AND adr_com=066) OR
(adr_dep=43 AND adr_com=091) OR
(adr_dep=43 AND adr_com=104) OR
(adr_dep=43 AND adr_com=129) OR
(adr_dep=43 AND adr_com=163) OR
(adr_dep=43 AND adr_com=172) OR
(adr_dep=43 AND adr_com=204) OR
(adr_dep=43 AND adr_com=253) OR
(adr_dep=44 AND adr_com=002) OR
(adr_dep=44 AND adr_com=003) OR
(adr_dep=44 AND adr_com=004) OR
(adr_dep=44 AND adr_com=008) OR
(adr_dep=44 AND adr_com=009) OR
(adr_dep=44 AND adr_com=011) OR
(adr_dep=44 AND adr_com=013) OR
(adr_dep=44 AND adr_com=014) OR
(adr_dep=44 AND adr_com=016) OR
(adr_dep=44 AND adr_com=017) OR
(adr_dep=44 AND adr_com=018) OR
(adr_dep=44 AND adr_com=019) OR
(adr_dep=44 AND adr_com=020) OR
(adr_dep=44 AND adr_com=022) OR
(adr_dep=44 AND adr_com=024) OR
(adr_dep=44 AND adr_com=025) OR
(adr_dep=44 AND adr_com=026) OR
(adr_dep=44 AND adr_com=027) OR
(adr_dep=44 AND adr_com=028) OR
(adr_dep=44 AND adr_com=029) OR
(adr_dep=44 AND adr_com=030) OR
(adr_dep=44 AND adr_com=032) OR
(adr_dep=44 AND adr_com=033) OR
(adr_dep=44 AND adr_com=034) OR
(adr_dep=44 AND adr_com=035) OR
(adr_dep=44 AND adr_com=037) OR
(adr_dep=44 AND adr_com=039) OR
(adr_dep=44 AND adr_com=041) OR
(adr_dep=44 AND adr_com=043) OR
(adr_dep=44 AND adr_com=045) OR
(adr_dep=44 AND adr_com=047) OR
(adr_dep=44 AND adr_com=048) OR
(adr_dep=44 AND adr_com=050) OR
(adr_dep=44 AND adr_com=052) OR
(adr_dep=44 AND adr_com=053) OR
(adr_dep=44 AND adr_com=060) OR
(adr_dep=44 AND adr_com=063) OR
(adr_dep=44 AND adr_com=064) OR
(adr_dep=44 AND adr_com=070) OR
(adr_dep=44 AND adr_com=071) OR
(adr_dep=44 AND adr_com=074) OR
(adr_dep=44 AND adr_com=079) OR
(adr_dep=44 AND adr_com=080) OR
(adr_dep=44 AND adr_com=082) OR
(adr_dep=44 AND adr_com=083) OR
(adr_dep=44 AND adr_com=084) OR
(adr_dep=44 AND adr_com=088) OR
(adr_dep=44 AND adr_com=090) OR
(adr_dep=44 AND adr_com=093) OR
(adr_dep=44 AND adr_com=094) OR
(adr_dep=44 AND adr_com=096) OR
(adr_dep=44 AND adr_com=100) OR
(adr_dep=44 AND adr_com=101) OR
(adr_dep=44 AND adr_com=102) OR
(adr_dep=44 AND adr_com=103) OR
(adr_dep=44 AND adr_com=104) OR
(adr_dep=44 AND adr_com=107) OR
(adr_dep=44 AND adr_com=108) OR
(adr_dep=44 AND adr_com=109) OR
(adr_dep=44 AND adr_com=114) OR
(adr_dep=44 AND adr_com=115) OR
(adr_dep=44 AND adr_com=116) OR
(adr_dep=44 AND adr_com=117) OR
(adr_dep=44 AND adr_com=118) OR
(adr_dep=44 AND adr_com=120) OR
(adr_dep=44 AND adr_com=122) OR
(adr_dep=44 AND adr_com=127) OR
(adr_dep=44 AND adr_com=129) OR
(adr_dep=44 AND adr_com=130) OR
(adr_dep=44 AND adr_com=133) OR
(adr_dep=44 AND adr_com=134) OR
(adr_dep=44 AND adr_com=137) OR
(adr_dep=44 AND adr_com=140) OR
(adr_dep=44 AND adr_com=141) OR
(adr_dep=44 AND adr_com=142) OR
(adr_dep=44 AND adr_com=143) OR
(adr_dep=44 AND adr_com=145) OR
(adr_dep=44 AND adr_com=147) OR
(adr_dep=44 AND adr_com=150) OR
(adr_dep=44 AND adr_com=151) OR
(adr_dep=44 AND adr_com=152) OR
(adr_dep=44 AND adr_com=155) OR
(adr_dep=44 AND adr_com=156) OR
(adr_dep=44 AND adr_com=158) OR
(adr_dep=44 AND adr_com=159) OR
(adr_dep=44 AND adr_com=160) OR
(adr_dep=44 AND adr_com=162) OR
(adr_dep=44 AND adr_com=163) OR
(adr_dep=44 AND adr_com=165) OR
(adr_dep=44 AND adr_com=166) OR
(adr_dep=44 AND adr_com=168) OR
(adr_dep=44 AND adr_com=169) OR
(adr_dep=44 AND adr_com=171) OR
(adr_dep=44 AND adr_com=172) OR
(adr_dep=44 AND adr_com=173) OR
(adr_dep=44 AND adr_com=174) OR
(adr_dep=44 AND adr_com=176) OR
(adr_dep=44 AND adr_com=178) OR
(adr_dep=44 AND adr_com=179) OR
(adr_dep=44 AND adr_com=180) OR
(adr_dep=44 AND adr_com=186) OR
(adr_dep=44 AND adr_com=188) OR
(adr_dep=44 AND adr_com=189) OR
(adr_dep=44 AND adr_com=190) OR
(adr_dep=44 AND adr_com=194) OR
(adr_dep=44 AND adr_com=198) OR
(adr_dep=44 AND adr_com=201) OR
(adr_dep=44 AND adr_com=202) OR
(adr_dep=44 AND adr_com=204) OR
(adr_dep=44 AND adr_com=205) OR
(adr_dep=44 AND adr_com=207) OR
(adr_dep=44 AND adr_com=212) OR
(adr_dep=44 AND adr_com=213) OR
(adr_dep=44 AND adr_com=215) OR
(adr_dep=44 AND adr_com=216) OR
(adr_dep=44 AND adr_com=220) OR
(adr_dep=44 AND adr_com=222) OR
(adr_dep=44 AND adr_com=223) OR
(adr_dep=44 AND adr_com=001) OR
(adr_dep=44 AND adr_com=005) OR
(adr_dep=44 AND adr_com=015) OR
(adr_dep=44 AND adr_com=021) OR
(adr_dep=44 AND adr_com=023) OR
(adr_dep=44 AND adr_com=031) OR
(adr_dep=44 AND adr_com=038) OR
(adr_dep=44 AND adr_com=040) OR
(adr_dep=44 AND adr_com=046) OR
(adr_dep=44 AND adr_com=055) OR
(adr_dep=44 AND adr_com=056) OR
(adr_dep=44 AND adr_com=059) OR
(adr_dep=44 AND adr_com=061) OR
(adr_dep=44 AND adr_com=065) OR
(adr_dep=44 AND adr_com=066) OR
(adr_dep=44 AND adr_com=068) OR
(adr_dep=44 AND adr_com=069) OR
(adr_dep=44 AND adr_com=072) OR
(adr_dep=44 AND adr_com=073) OR
(adr_dep=44 AND adr_com=077) OR
(adr_dep=44 AND adr_com=078) OR
(adr_dep=44 AND adr_com=081) OR
(adr_dep=44 AND adr_com=087) OR
(adr_dep=44 AND adr_com=089) OR
(adr_dep=44 AND adr_com=095) OR
(adr_dep=44 AND adr_com=098) OR
(adr_dep=44 AND adr_com=110) OR
(adr_dep=44 AND adr_com=111) OR
(adr_dep=44 AND adr_com=112) OR
(adr_dep=44 AND adr_com=119) OR
(adr_dep=44 AND adr_com=121) OR
(adr_dep=44 AND adr_com=124) OR
(adr_dep=44 AND adr_com=132) OR
(adr_dep=44 AND adr_com=139) OR
(adr_dep=44 AND adr_com=144) OR
(adr_dep=44 AND adr_com=149) OR
(adr_dep=44 AND adr_com=154) OR
(adr_dep=44 AND adr_com=157) OR
(adr_dep=44 AND adr_com=161) OR
(adr_dep=44 AND adr_com=164) OR
(adr_dep=44 AND adr_com=175) OR
(adr_dep=44 AND adr_com=181) OR
(adr_dep=44 AND adr_com=184) OR
(adr_dep=44 AND adr_com=187) OR
(adr_dep=44 AND adr_com=191) OR
(adr_dep=44 AND adr_com=192) OR
(adr_dep=44 AND adr_com=195) OR
(adr_dep=44 AND adr_com=196) OR
(adr_dep=44 AND adr_com=199) OR
(adr_dep=44 AND adr_com=203) OR
(adr_dep=44 AND adr_com=206) OR
(adr_dep=44 AND adr_com=209) OR
(adr_dep=44 AND adr_com=210) OR
(adr_dep=44 AND adr_com=217) OR
(adr_dep=44 AND adr_com=218) OR
(adr_dep=44 AND adr_com=219) OR
(adr_dep=49 AND adr_com=056) OR
(adr_dep=49 AND adr_com=061) OR
(adr_dep=49 AND adr_com=088) OR
(adr_dep=49 AND adr_com=248) OR
(adr_dep=49 AND adr_com=309) OR
(adr_dep=49 AND adr_com=001) OR
(adr_dep=49 AND adr_com=002) OR
(adr_dep=49 AND adr_com=003) OR
(adr_dep=49 AND adr_com=004) OR
(adr_dep=49 AND adr_com=005) OR
(adr_dep=49 AND adr_com=006) OR
(adr_dep=49 AND adr_com=007) OR
(adr_dep=49 AND adr_com=008) OR
(adr_dep=49 AND adr_com=009) OR
(adr_dep=49 AND adr_com=010) OR
(adr_dep=49 AND adr_com=011) OR
(adr_dep=49 AND adr_com=012) OR
(adr_dep=49 AND adr_com=013) OR
(adr_dep=49 AND adr_com=014) OR
(adr_dep=49 AND adr_com=015) OR
(adr_dep=49 AND adr_com=017) OR
(adr_dep=49 AND adr_com=018) OR
(adr_dep=49 AND adr_com=019) OR
(adr_dep=49 AND adr_com=020) OR
(adr_dep=49 AND adr_com=021) OR
(adr_dep=49 AND adr_com=022) OR
(adr_dep=49 AND adr_com=023) OR
(adr_dep=49 AND adr_com=024) OR
(adr_dep=49 AND adr_com=025) OR
(adr_dep=49 AND adr_com=026) OR
(adr_dep=49 AND adr_com=027) OR
(adr_dep=49 AND adr_com=028) OR
(adr_dep=49 AND adr_com=029) OR
(adr_dep=49 AND adr_com=030) OR
(adr_dep=49 AND adr_com=031) OR
(adr_dep=49 AND adr_com=032) OR
(adr_dep=49 AND adr_com=033) OR
(adr_dep=49 AND adr_com=034) OR
(adr_dep=49 AND adr_com=035) OR
(adr_dep=49 AND adr_com=036) OR
(adr_dep=49 AND adr_com=037) OR
(adr_dep=49 AND adr_com=038) OR
(adr_dep=49 AND adr_com=039) OR
(adr_dep=49 AND adr_com=040) OR
(adr_dep=49 AND adr_com=041) OR
(adr_dep=49 AND adr_com=042) OR
(adr_dep=49 AND adr_com=043) OR
(adr_dep=49 AND adr_com=044) OR
(adr_dep=49 AND adr_com=045) OR
(adr_dep=49 AND adr_com=046) OR
(adr_dep=49 AND adr_com=047) OR
(adr_dep=49 AND adr_com=048) OR
(adr_dep=49 AND adr_com=049) OR
(adr_dep=49 AND adr_com=050) OR
(adr_dep=49 AND adr_com=051) OR
(adr_dep=49 AND adr_com=052) OR
(adr_dep=49 AND adr_com=053) OR
(adr_dep=49 AND adr_com=054) OR
(adr_dep=49 AND adr_com=055) OR
(adr_dep=49 AND adr_com=057) OR
(adr_dep=49 AND adr_com=058) OR
(adr_dep=49 AND adr_com=059) OR
(adr_dep=49 AND adr_com=060) OR
(adr_dep=49 AND adr_com=062) OR
(adr_dep=49 AND adr_com=063) OR
(adr_dep=49 AND adr_com=064) OR
(adr_dep=49 AND adr_com=065) OR
(adr_dep=49 AND adr_com=066) OR
(adr_dep=49 AND adr_com=067) OR
(adr_dep=49 AND adr_com=068) OR
(adr_dep=49 AND adr_com=069) OR
(adr_dep=49 AND adr_com=070) OR
(adr_dep=49 AND adr_com=071) OR
(adr_dep=49 AND adr_com=072) OR
(adr_dep=49 AND adr_com=073) OR
(adr_dep=49 AND adr_com=074) OR
(adr_dep=49 AND adr_com=075) OR
(adr_dep=49 AND adr_com=076) OR
(adr_dep=49 AND adr_com=077) OR
(adr_dep=49 AND adr_com=078) OR
(adr_dep=49 AND adr_com=079) OR
(adr_dep=49 AND adr_com=080) OR
(adr_dep=49 AND adr_com=081) OR
(adr_dep=49 AND adr_com=082) OR
(adr_dep=49 AND adr_com=083) OR
(adr_dep=49 AND adr_com=084) OR
(adr_dep=49 AND adr_com=085) OR
(adr_dep=49 AND adr_com=086) OR
(adr_dep=49 AND adr_com=087) OR
(adr_dep=49 AND adr_com=089) OR
(adr_dep=49 AND adr_com=090) OR
(adr_dep=49 AND adr_com=091) OR
(adr_dep=49 AND adr_com=092) OR
(adr_dep=49 AND adr_com=093) OR
(adr_dep=49 AND adr_com=094) OR
(adr_dep=49 AND adr_com=095) OR
(adr_dep=49 AND adr_com=096) OR
(adr_dep=49 AND adr_com=097) OR
(adr_dep=49 AND adr_com=098) OR
(adr_dep=49 AND adr_com=099) OR
(adr_dep=49 AND adr_com=100) OR
(adr_dep=49 AND adr_com=101) OR
(adr_dep=49 AND adr_com=102) OR
(adr_dep=49 AND adr_com=103) OR
(adr_dep=49 AND adr_com=104) OR
(adr_dep=49 AND adr_com=105) OR
(adr_dep=49 AND adr_com=106) OR
(adr_dep=49 AND adr_com=107) OR
(adr_dep=49 AND adr_com=108) OR
(adr_dep=49 AND adr_com=109) OR
(adr_dep=49 AND adr_com=110) OR
(adr_dep=49 AND adr_com=111) OR
(adr_dep=49 AND adr_com=112) OR
(adr_dep=49 AND adr_com=113) OR
(adr_dep=49 AND adr_com=114) OR
(adr_dep=49 AND adr_com=115) OR
(adr_dep=49 AND adr_com=116) OR
(adr_dep=49 AND adr_com=117) OR
(adr_dep=49 AND adr_com=119) OR
(adr_dep=49 AND adr_com=120) OR
(adr_dep=49 AND adr_com=121) OR
(adr_dep=49 AND adr_com=122) OR
(adr_dep=49 AND adr_com=123) OR
(adr_dep=49 AND adr_com=125) OR
(adr_dep=49 AND adr_com=126) OR
(adr_dep=49 AND adr_com=127) OR
(adr_dep=49 AND adr_com=128) OR
(adr_dep=49 AND adr_com=129) OR
(adr_dep=49 AND adr_com=130) OR
(adr_dep=49 AND adr_com=131) OR
(adr_dep=49 AND adr_com=132) OR
(adr_dep=49 AND adr_com=133) OR
(adr_dep=49 AND adr_com=134) OR
(adr_dep=49 AND adr_com=135) OR
(adr_dep=49 AND adr_com=136) OR
(adr_dep=49 AND adr_com=137) OR
(adr_dep=49 AND adr_com=138) OR
(adr_dep=49 AND adr_com=139) OR
(adr_dep=49 AND adr_com=140) OR
(adr_dep=49 AND adr_com=141) OR
(adr_dep=49 AND adr_com=142) OR
(adr_dep=49 AND adr_com=143) OR
(adr_dep=49 AND adr_com=144) OR
(adr_dep=49 AND adr_com=145) OR
(adr_dep=49 AND adr_com=147) OR
(adr_dep=49 AND adr_com=148) OR
(adr_dep=49 AND adr_com=149) OR
(adr_dep=49 AND adr_com=150) OR
(adr_dep=49 AND adr_com=151) OR
(adr_dep=49 AND adr_com=153) OR
(adr_dep=49 AND adr_com=154) OR
(adr_dep=49 AND adr_com=155) OR
(adr_dep=49 AND adr_com=156) OR
(adr_dep=49 AND adr_com=157) OR
(adr_dep=49 AND adr_com=158) OR
(adr_dep=49 AND adr_com=159) OR
(adr_dep=49 AND adr_com=160) OR
(adr_dep=49 AND adr_com=161) OR
(adr_dep=49 AND adr_com=162) OR
(adr_dep=49 AND adr_com=163) OR
(adr_dep=49 AND adr_com=165) OR
(adr_dep=49 AND adr_com=167) OR
(adr_dep=49 AND adr_com=169) OR
(adr_dep=49 AND adr_com=170) OR
(adr_dep=49 AND adr_com=171) OR
(adr_dep=49 AND adr_com=172) OR
(adr_dep=49 AND adr_com=173) OR
(adr_dep=49 AND adr_com=174) OR
(adr_dep=49 AND adr_com=175) OR
(adr_dep=49 AND adr_com=176) OR
(adr_dep=49 AND adr_com=177) OR
(adr_dep=49 AND adr_com=178) OR
(adr_dep=49 AND adr_com=179) OR
(adr_dep=49 AND adr_com=180) OR
(adr_dep=49 AND adr_com=181) OR
(adr_dep=49 AND adr_com=182) OR
(adr_dep=49 AND adr_com=183) OR
(adr_dep=49 AND adr_com=184) OR
(adr_dep=49 AND adr_com=185) OR
(adr_dep=49 AND adr_com=186) OR
(adr_dep=49 AND adr_com=187) OR
(adr_dep=49 AND adr_com=188) OR
(adr_dep=49 AND adr_com=189) OR
(adr_dep=49 AND adr_com=190) OR
(adr_dep=49 AND adr_com=191) OR
(adr_dep=49 AND adr_com=192) OR
(adr_dep=49 AND adr_com=193) OR
(adr_dep=49 AND adr_com=194) OR
(adr_dep=49 AND adr_com=195) OR
(adr_dep=49 AND adr_com=196) OR
(adr_dep=49 AND adr_com=197) OR
(adr_dep=49 AND adr_com=198) OR
(adr_dep=49 AND adr_com=199) OR
(adr_dep=49 AND adr_com=200) OR
(adr_dep=49 AND adr_com=201) OR
(adr_dep=49 AND adr_com=202) OR
(adr_dep=49 AND adr_com=204) OR
(adr_dep=49 AND adr_com=205) OR
(adr_dep=49 AND adr_com=206) OR
(adr_dep=49 AND adr_com=207) OR
(adr_dep=49 AND adr_com=208) OR
(adr_dep=49 AND adr_com=209) OR
(adr_dep=49 AND adr_com=211) OR
(adr_dep=49 AND adr_com=212) OR
(adr_dep=49 AND adr_com=213) OR
(adr_dep=49 AND adr_com=214) OR
(adr_dep=49 AND adr_com=215) OR
(adr_dep=49 AND adr_com=216) OR
(adr_dep=49 AND adr_com=217) OR
(adr_dep=49 AND adr_com=218) OR
(adr_dep=49 AND adr_com=219) OR
(adr_dep=49 AND adr_com=220) OR
(adr_dep=49 AND adr_com=221) OR
(adr_dep=49 AND adr_com=222) OR
(adr_dep=49 AND adr_com=223) OR
(adr_dep=49 AND adr_com=224) OR
(adr_dep=49 AND adr_com=225) OR
(adr_dep=49 AND adr_com=226) OR
(adr_dep=49 AND adr_com=227) OR
(adr_dep=49 AND adr_com=228) OR
(adr_dep=49 AND adr_com=229) OR
(adr_dep=49 AND adr_com=230) OR
(adr_dep=49 AND adr_com=231) OR
(adr_dep=49 AND adr_com=232) OR
(adr_dep=49 AND adr_com=233) OR
(adr_dep=49 AND adr_com=234) OR
(adr_dep=49 AND adr_com=235) OR
(adr_dep=49 AND adr_com=236) OR
(adr_dep=49 AND adr_com=237) OR
(adr_dep=49 AND adr_com=238) OR
(adr_dep=49 AND adr_com=239) OR
(adr_dep=49 AND adr_com=240) OR
(adr_dep=49 AND adr_com=241) OR
(adr_dep=49 AND adr_com=242) OR
(adr_dep=49 AND adr_com=243) OR
(adr_dep=49 AND adr_com=244) OR
(adr_dep=49 AND adr_com=245) OR
(adr_dep=49 AND adr_com=246) OR
(adr_dep=49 AND adr_com=247) OR
(adr_dep=49 AND adr_com=249) OR
(adr_dep=49 AND adr_com=250) OR
(adr_dep=49 AND adr_com=251) OR
(adr_dep=49 AND adr_com=252) OR
(adr_dep=49 AND adr_com=253) OR
(adr_dep=49 AND adr_com=254) OR
(adr_dep=49 AND adr_com=256) OR
(adr_dep=49 AND adr_com=257) OR
(adr_dep=49 AND adr_com=258) OR
(adr_dep=49 AND adr_com=259) OR
(adr_dep=49 AND adr_com=260) OR
(adr_dep=49 AND adr_com=261) OR
(adr_dep=49 AND adr_com=262) OR
(adr_dep=49 AND adr_com=263) OR
(adr_dep=49 AND adr_com=264) OR
(adr_dep=49 AND adr_com=265) OR
(adr_dep=49 AND adr_com=266) OR
(adr_dep=49 AND adr_com=267) OR
(adr_dep=49 AND adr_com=268) OR
(adr_dep=49 AND adr_com=269) OR
(adr_dep=49 AND adr_com=270) OR
(adr_dep=49 AND adr_com=271) OR
(adr_dep=49 AND adr_com=272) OR
(adr_dep=49 AND adr_com=273) OR
(adr_dep=49 AND adr_com=274) OR
(adr_dep=49 AND adr_com=276) OR
(adr_dep=49 AND adr_com=277) OR
(adr_dep=49 AND adr_com=278) OR
(adr_dep=49 AND adr_com=279) OR
(adr_dep=49 AND adr_com=280) OR
(adr_dep=49 AND adr_com=281) OR
(adr_dep=49 AND adr_com=282) OR
(adr_dep=49 AND adr_com=283) OR
(adr_dep=49 AND adr_com=284) OR
(adr_dep=49 AND adr_com=285) OR
(adr_dep=49 AND adr_com=288) OR
(adr_dep=49 AND adr_com=289) OR
(adr_dep=49 AND adr_com=290) OR
(adr_dep=49 AND adr_com=291) OR
(adr_dep=49 AND adr_com=292) OR
(adr_dep=49 AND adr_com=294) OR
(adr_dep=49 AND adr_com=295) OR
(adr_dep=49 AND adr_com=296) OR
(adr_dep=49 AND adr_com=297) OR
(adr_dep=49 AND adr_com=298) OR
(adr_dep=49 AND adr_com=299) OR
(adr_dep=49 AND adr_com=300) OR
(adr_dep=49 AND adr_com=301) OR
(adr_dep=49 AND adr_com=302) OR
(adr_dep=49 AND adr_com=303) OR
(adr_dep=49 AND adr_com=304) OR
(adr_dep=49 AND adr_com=305) OR
(adr_dep=49 AND adr_com=306) OR
(adr_dep=49 AND adr_com=307) OR
(adr_dep=49 AND adr_com=308) OR
(adr_dep=49 AND adr_com=310) OR
(adr_dep=49 AND adr_com=311) OR
(adr_dep=49 AND adr_com=312) OR
(adr_dep=49 AND adr_com=313) OR
(adr_dep=49 AND adr_com=314) OR
(adr_dep=49 AND adr_com=315) OR
(adr_dep=49 AND adr_com=316) OR
(adr_dep=49 AND adr_com=317) OR
(adr_dep=49 AND adr_com=318) OR
(adr_dep=49 AND adr_com=319) OR
(adr_dep=49 AND adr_com=320) OR
(adr_dep=49 AND adr_com=321) OR
(adr_dep=49 AND adr_com=322) OR
(adr_dep=49 AND adr_com=323) OR
(adr_dep=49 AND adr_com=324) OR
(adr_dep=49 AND adr_com=325) OR
(adr_dep=49 AND adr_com=326) OR
(adr_dep=49 AND adr_com=327) OR
(adr_dep=49 AND adr_com=328) OR
(adr_dep=49 AND adr_com=329) OR
(adr_dep=49 AND adr_com=330) OR
(adr_dep=49 AND adr_com=331) OR
(adr_dep=49 AND adr_com=332) OR
(adr_dep=49 AND adr_com=333) OR
(adr_dep=49 AND adr_com=334) OR
(adr_dep=49 AND adr_com=335) OR
(adr_dep=49 AND adr_com=336) OR
(adr_dep=49 AND adr_com=337) OR
(adr_dep=49 AND adr_com=338) OR
(adr_dep=49 AND adr_com=339) OR
(adr_dep=49 AND adr_com=341) OR
(adr_dep=49 AND adr_com=342) OR
(adr_dep=49 AND adr_com=343) OR
(adr_dep=49 AND adr_com=344) OR
(adr_dep=49 AND adr_com=345) OR
(adr_dep=49 AND adr_com=346) OR
(adr_dep=49 AND adr_com=347) OR
(adr_dep=49 AND adr_com=348) OR
(adr_dep=49 AND adr_com=349) OR
(adr_dep=49 AND adr_com=350) OR
(adr_dep=49 AND adr_com=351) OR
(adr_dep=49 AND adr_com=352) OR
(adr_dep=49 AND adr_com=353) OR
(adr_dep=49 AND adr_com=354) OR
(adr_dep=49 AND adr_com=355) OR
(adr_dep=49 AND adr_com=356) OR
(adr_dep=49 AND adr_com=358) OR
(adr_dep=49 AND adr_com=359) OR
(adr_dep=49 AND adr_com=360) OR
(adr_dep=49 AND adr_com=361) OR
(adr_dep=49 AND adr_com=362) OR
(adr_dep=49 AND adr_com=363) OR
(adr_dep=49 AND adr_com=364) OR
(adr_dep=49 AND adr_com=365) OR
(adr_dep=49 AND adr_com=366) OR
(adr_dep=49 AND adr_com=367) OR
(adr_dep=49 AND adr_com=368) OR
(adr_dep=49 AND adr_com=369) OR
(adr_dep=49 AND adr_com=370) OR
(adr_dep=49 AND adr_com=371) OR
(adr_dep=49 AND adr_com=372) OR
(adr_dep=49 AND adr_com=373) OR
(adr_dep=49 AND adr_com=374) OR
(adr_dep=49 AND adr_com=375) OR
(adr_dep=49 AND adr_com=376) OR
(adr_dep=49 AND adr_com=377) OR
(adr_dep=49 AND adr_com=378) OR
(adr_dep=49 AND adr_com=380) OR
(adr_dep=49 AND adr_com=381) OR
(adr_dep=53 AND adr_com=001) OR
(adr_dep=53 AND adr_com=002) OR
(adr_dep=53 AND adr_com=003) OR
(adr_dep=53 AND adr_com=004) OR
(adr_dep=53 AND adr_com=005) OR
(adr_dep=53 AND adr_com=006) OR
(adr_dep=53 AND adr_com=007) OR
(adr_dep=53 AND adr_com=008) OR
(adr_dep=53 AND adr_com=009) OR
(adr_dep=53 AND adr_com=010) OR
(adr_dep=53 AND adr_com=011) OR
(adr_dep=53 AND adr_com=012) OR
(adr_dep=53 AND adr_com=013) OR
(adr_dep=53 AND adr_com=014) OR
(adr_dep=53 AND adr_com=015) OR
(adr_dep=53 AND adr_com=016) OR
(adr_dep=53 AND adr_com=017) OR
(adr_dep=53 AND adr_com=018) OR
(adr_dep=53 AND adr_com=019) OR
(adr_dep=53 AND adr_com=021) OR
(adr_dep=53 AND adr_com=022) OR
(adr_dep=53 AND adr_com=023) OR
(adr_dep=53 AND adr_com=025) OR
(adr_dep=53 AND adr_com=027) OR
(adr_dep=53 AND adr_com=028) OR
(adr_dep=53 AND adr_com=029) OR
(adr_dep=53 AND adr_com=030) OR
(adr_dep=53 AND adr_com=031) OR
(adr_dep=53 AND adr_com=032) OR
(adr_dep=53 AND adr_com=033) OR
(adr_dep=53 AND adr_com=034) OR
(adr_dep=53 AND adr_com=035) OR
(adr_dep=53 AND adr_com=036) OR
(adr_dep=53 AND adr_com=037) OR
(adr_dep=53 AND adr_com=038) OR
(adr_dep=53 AND adr_com=041) OR
(adr_dep=53 AND adr_com=042) OR
(adr_dep=53 AND adr_com=043) OR
(adr_dep=53 AND adr_com=045) OR
(adr_dep=53 AND adr_com=046) OR
(adr_dep=53 AND adr_com=047) OR
(adr_dep=53 AND adr_com=048) OR
(adr_dep=53 AND adr_com=049) OR
(adr_dep=53 AND adr_com=050) OR
(adr_dep=53 AND adr_com=051) OR
(adr_dep=53 AND adr_com=052) OR
(adr_dep=53 AND adr_com=053) OR
(adr_dep=53 AND adr_com=054) OR
(adr_dep=53 AND adr_com=055) OR
(adr_dep=53 AND adr_com=056) OR
(adr_dep=53 AND adr_com=057) OR
(adr_dep=53 AND adr_com=058) OR
(adr_dep=53 AND adr_com=059) OR
(adr_dep=53 AND adr_com=061) OR
(adr_dep=53 AND adr_com=062) OR
(adr_dep=53 AND adr_com=063) OR
(adr_dep=53 AND adr_com=064) OR
(adr_dep=53 AND adr_com=065) OR
(adr_dep=53 AND adr_com=066) OR
(adr_dep=53 AND adr_com=067) OR
(adr_dep=53 AND adr_com=068) OR
(adr_dep=53 AND adr_com=069) OR
(adr_dep=53 AND adr_com=071) OR
(adr_dep=53 AND adr_com=072) OR
(adr_dep=53 AND adr_com=074) OR
(adr_dep=53 AND adr_com=075) OR
(adr_dep=53 AND adr_com=076) OR
(adr_dep=53 AND adr_com=077) OR
(adr_dep=53 AND adr_com=078) OR
(adr_dep=53 AND adr_com=079) OR
(adr_dep=53 AND adr_com=080) OR
(adr_dep=53 AND adr_com=082) OR
(adr_dep=53 AND adr_com=083) OR
(adr_dep=53 AND adr_com=084) OR
(adr_dep=53 AND adr_com=085) OR
(adr_dep=53 AND adr_com=087) OR
(adr_dep=53 AND adr_com=089) OR
(adr_dep=53 AND adr_com=090) OR
(adr_dep=53 AND adr_com=091) OR
(adr_dep=53 AND adr_com=092) OR
(adr_dep=53 AND adr_com=094) OR
(adr_dep=53 AND adr_com=095) OR
(adr_dep=53 AND adr_com=096) OR
(adr_dep=53 AND adr_com=097) OR
(adr_dep=53 AND adr_com=099) OR
(adr_dep=53 AND adr_com=101) OR
(adr_dep=53 AND adr_com=103) OR
(adr_dep=53 AND adr_com=104) OR
(adr_dep=53 AND adr_com=105) OR
(adr_dep=53 AND adr_com=106) OR
(adr_dep=53 AND adr_com=107) OR
(adr_dep=53 AND adr_com=109) OR
(adr_dep=53 AND adr_com=110) OR
(adr_dep=53 AND adr_com=111) OR
(adr_dep=53 AND adr_com=112) OR
(adr_dep=53 AND adr_com=113) OR
(adr_dep=53 AND adr_com=114) OR
(adr_dep=53 AND adr_com=115) OR
(adr_dep=53 AND adr_com=116) OR
(adr_dep=53 AND adr_com=117) OR
(adr_dep=53 AND adr_com=118) OR
(adr_dep=53 AND adr_com=119) OR
(adr_dep=53 AND adr_com=120) OR
(adr_dep=53 AND adr_com=121) OR
(adr_dep=53 AND adr_com=122) OR
(adr_dep=53 AND adr_com=124) OR
(adr_dep=53 AND adr_com=127) OR
(adr_dep=53 AND adr_com=128) OR
(adr_dep=53 AND adr_com=130) OR
(adr_dep=53 AND adr_com=131) OR
(adr_dep=53 AND adr_com=134) OR
(adr_dep=53 AND adr_com=135) OR
(adr_dep=53 AND adr_com=136) OR
(adr_dep=53 AND adr_com=137) OR
(adr_dep=53 AND adr_com=138) OR
(adr_dep=53 AND adr_com=139) OR
(adr_dep=53 AND adr_com=140) OR
(adr_dep=53 AND adr_com=141) OR
(adr_dep=53 AND adr_com=142) OR
(adr_dep=53 AND adr_com=143) OR
(adr_dep=53 AND adr_com=144) OR
(adr_dep=53 AND adr_com=145) OR
(adr_dep=53 AND adr_com=146) OR
(adr_dep=53 AND adr_com=147) OR
(adr_dep=53 AND adr_com=148) OR
(adr_dep=53 AND adr_com=150) OR
(adr_dep=53 AND adr_com=152) OR
(adr_dep=53 AND adr_com=153) OR
(adr_dep=53 AND adr_com=155) OR
(adr_dep=53 AND adr_com=156) OR
(adr_dep=53 AND adr_com=157) OR
(adr_dep=53 AND adr_com=158) OR
(adr_dep=53 AND adr_com=159) OR
(adr_dep=53 AND adr_com=160) OR
(adr_dep=53 AND adr_com=161) OR
(adr_dep=53 AND adr_com=162) OR
(adr_dep=53 AND adr_com=163) OR
(adr_dep=53 AND adr_com=164) OR
(adr_dep=53 AND adr_com=165) OR
(adr_dep=53 AND adr_com=168) OR
(adr_dep=53 AND adr_com=169) OR
(adr_dep=53 AND adr_com=170) OR
(adr_dep=53 AND adr_com=172) OR
(adr_dep=53 AND adr_com=173) OR
(adr_dep=53 AND adr_com=174) OR
(adr_dep=53 AND adr_com=175) OR
(adr_dep=53 AND adr_com=176) OR
(adr_dep=53 AND adr_com=178) OR
(adr_dep=53 AND adr_com=179) OR
(adr_dep=53 AND adr_com=180) OR
(adr_dep=53 AND adr_com=182) OR
(adr_dep=53 AND adr_com=184) OR
(adr_dep=53 AND adr_com=185) OR
(adr_dep=53 AND adr_com=186) OR
(adr_dep=53 AND adr_com=187) OR
(adr_dep=53 AND adr_com=188) OR
(adr_dep=53 AND adr_com=189) OR
(adr_dep=53 AND adr_com=190) OR
(adr_dep=53 AND adr_com=191) OR
(adr_dep=53 AND adr_com=193) OR
(adr_dep=53 AND adr_com=194) OR
(adr_dep=53 AND adr_com=195) OR
(adr_dep=53 AND adr_com=196) OR
(adr_dep=53 AND adr_com=198) OR
(adr_dep=53 AND adr_com=199) OR
(adr_dep=53 AND adr_com=200) OR
(adr_dep=53 AND adr_com=201) OR
(adr_dep=53 AND adr_com=203) OR
(adr_dep=53 AND adr_com=204) OR
(adr_dep=53 AND adr_com=205) OR
(adr_dep=53 AND adr_com=206) OR
(adr_dep=53 AND adr_com=207) OR
(adr_dep=53 AND adr_com=208) OR
(adr_dep=53 AND adr_com=210) OR
(adr_dep=53 AND adr_com=211) OR
(adr_dep=53 AND adr_com=212) OR
(adr_dep=53 AND adr_com=215) OR
(adr_dep=53 AND adr_com=216) OR
(adr_dep=53 AND adr_com=218) OR
(adr_dep=53 AND adr_com=219) OR
(adr_dep=53 AND adr_com=220) OR
(adr_dep=53 AND adr_com=221) OR
(adr_dep=53 AND adr_com=222) OR
(adr_dep=53 AND adr_com=223) OR
(adr_dep=53 AND adr_com=224) OR
(adr_dep=53 AND adr_com=225) OR
(adr_dep=53 AND adr_com=228) OR
(adr_dep=53 AND adr_com=229) OR
(adr_dep=53 AND adr_com=230) OR
(adr_dep=53 AND adr_com=231) OR
(adr_dep=53 AND adr_com=232) OR
(adr_dep=53 AND adr_com=233) OR
(adr_dep=53 AND adr_com=234) OR
(adr_dep=53 AND adr_com=235) OR
(adr_dep=53 AND adr_com=236) OR
(adr_dep=53 AND adr_com=237) OR
(adr_dep=53 AND adr_com=239) OR
(adr_dep=53 AND adr_com=240) OR
(adr_dep=53 AND adr_com=241) OR
(adr_dep=53 AND adr_com=242) OR
(adr_dep=53 AND adr_com=243) OR
(adr_dep=53 AND adr_com=244) OR
(adr_dep=53 AND adr_com=246) OR
(adr_dep=53 AND adr_com=248) OR
(adr_dep=53 AND adr_com=249) OR
(adr_dep=53 AND adr_com=251) OR
(adr_dep=53 AND adr_com=252) OR
(adr_dep=53 AND adr_com=253) OR
(adr_dep=53 AND adr_com=254) OR
(adr_dep=53 AND adr_com=255) OR
(adr_dep=53 AND adr_com=256) OR
(adr_dep=53 AND adr_com=257) OR
(adr_dep=53 AND adr_com=258) OR
(adr_dep=53 AND adr_com=260) OR
(adr_dep=53 AND adr_com=261) OR
(adr_dep=53 AND adr_com=262) OR
(adr_dep=53 AND adr_com=263) OR
(adr_dep=53 AND adr_com=264) OR
(adr_dep=53 AND adr_com=265) OR
(adr_dep=53 AND adr_com=266) OR
(adr_dep=53 AND adr_com=267) OR
(adr_dep=53 AND adr_com=269) OR
(adr_dep=53 AND adr_com=270) OR
(adr_dep=53 AND adr_com=271) OR
(adr_dep=53 AND adr_com=272) OR
(adr_dep=53 AND adr_com=273) OR
(adr_dep=53 AND adr_com=274) OR
(adr_dep=53 AND adr_com=276) OR
(adr_dep=53 AND adr_com=026) OR
(adr_dep=53 AND adr_com=039) OR
(adr_dep=53 AND adr_com=040) OR
(adr_dep=53 AND adr_com=073) OR
(adr_dep=53 AND adr_com=086) OR
(adr_dep=53 AND adr_com=088) OR
(adr_dep=53 AND adr_com=093) OR
(adr_dep=53 AND adr_com=098) OR
(adr_dep=53 AND adr_com=100) OR
(adr_dep=53 AND adr_com=102) OR
(adr_dep=53 AND adr_com=108) OR
(adr_dep=53 AND adr_com=123) OR
(adr_dep=53 AND adr_com=126) OR
(adr_dep=53 AND adr_com=129) OR
(adr_dep=53 AND adr_com=132) OR
(adr_dep=53 AND adr_com=133) OR
(adr_dep=53 AND adr_com=151) OR
(adr_dep=53 AND adr_com=154) OR
(adr_dep=53 AND adr_com=177) OR
(adr_dep=53 AND adr_com=192) OR
(adr_dep=53 AND adr_com=197) OR
(adr_dep=53 AND adr_com=202) OR
(adr_dep=53 AND adr_com=209) OR
(adr_dep=53 AND adr_com=214) OR
(adr_dep=53 AND adr_com=226) OR
(adr_dep=53 AND adr_com=245) OR
(adr_dep=53 AND adr_com=247) OR
(adr_dep=53 AND adr_com=250) OR
(adr_dep=53 AND adr_com=259) OR
(adr_dep=58 AND adr_com=001) OR
(adr_dep=58 AND adr_com=003) OR
(adr_dep=58 AND adr_com=010) OR
(adr_dep=58 AND adr_com=013) OR
(adr_dep=58 AND adr_com=017) OR
(adr_dep=58 AND adr_com=018) OR
(adr_dep=58 AND adr_com=024) OR
(adr_dep=58 AND adr_com=032) OR
(adr_dep=58 AND adr_com=034) OR
(adr_dep=58 AND adr_com=053) OR
(adr_dep=58 AND adr_com=058) OR
(adr_dep=58 AND adr_com=062) OR
(adr_dep=58 AND adr_com=063) OR
(adr_dep=58 AND adr_com=066) OR
(adr_dep=58 AND adr_com=070) OR
(adr_dep=58 AND adr_com=080) OR
(adr_dep=58 AND adr_com=082) OR
(adr_dep=58 AND adr_com=084) OR
(adr_dep=58 AND adr_com=085) OR
(adr_dep=58 AND adr_com=109) OR
(adr_dep=58 AND adr_com=110) OR
(adr_dep=58 AND adr_com=111) OR
(adr_dep=58 AND adr_com=125) OR
(adr_dep=58 AND adr_com=128) OR
(adr_dep=58 AND adr_com=132) OR
(adr_dep=58 AND adr_com=156) OR
(adr_dep=58 AND adr_com=162) OR
(adr_dep=58 AND adr_com=163) OR
(adr_dep=58 AND adr_com=174) OR
(adr_dep=58 AND adr_com=179) OR
(adr_dep=58 AND adr_com=184) OR
(adr_dep=58 AND adr_com=185) OR
(adr_dep=58 AND adr_com=201) OR
(adr_dep=58 AND adr_com=208) OR
(adr_dep=58 AND adr_com=227) OR
(adr_dep=58 AND adr_com=244) OR
(adr_dep=58 AND adr_com=249) OR
(adr_dep=58 AND adr_com=266) OR
(adr_dep=58 AND adr_com=304) OR
(adr_dep=58 AND adr_com=309) OR
(adr_dep=58 AND adr_com=313) OR
(adr_dep=58 AND adr_com=002) OR
(adr_dep=58 AND adr_com=004) OR
(adr_dep=58 AND adr_com=006) OR
(adr_dep=58 AND adr_com=007) OR
(adr_dep=58 AND adr_com=009) OR
(adr_dep=58 AND adr_com=012) OR
(adr_dep=58 AND adr_com=014) OR
(adr_dep=58 AND adr_com=019) OR
(adr_dep=58 AND adr_com=020) OR
(adr_dep=58 AND adr_com=021) OR
(adr_dep=58 AND adr_com=022) OR
(adr_dep=58 AND adr_com=025) OR
(adr_dep=58 AND adr_com=027) OR
(adr_dep=58 AND adr_com=028) OR
(adr_dep=58 AND adr_com=030) OR
(adr_dep=58 AND adr_com=031) OR
(adr_dep=58 AND adr_com=033) OR
(adr_dep=58 AND adr_com=035) OR
(adr_dep=58 AND adr_com=036) OR
(adr_dep=58 AND adr_com=040) OR
(adr_dep=58 AND adr_com=042) OR
(adr_dep=58 AND adr_com=044) OR
(adr_dep=58 AND adr_com=045) OR
(adr_dep=58 AND adr_com=046) OR
(adr_dep=58 AND adr_com=048) OR
(adr_dep=58 AND adr_com=051) OR
(adr_dep=58 AND adr_com=055) OR
(adr_dep=58 AND adr_com=056) OR
(adr_dep=58 AND adr_com=057) OR
(adr_dep=58 AND adr_com=059) OR
(adr_dep=58 AND adr_com=060) OR
(adr_dep=58 AND adr_com=061) OR
(adr_dep=58 AND adr_com=064) OR
(adr_dep=58 AND adr_com=065) OR
(adr_dep=58 AND adr_com=067) OR
(adr_dep=58 AND adr_com=072) OR
(adr_dep=58 AND adr_com=074) OR
(adr_dep=58 AND adr_com=076) OR
(adr_dep=58 AND adr_com=077) OR
(adr_dep=58 AND adr_com=078) OR
(adr_dep=58 AND adr_com=081) OR
(adr_dep=58 AND adr_com=086) OR
(adr_dep=58 AND adr_com=087) OR
(adr_dep=58 AND adr_com=088) OR
(adr_dep=58 AND adr_com=089) OR
(adr_dep=58 AND adr_com=092) OR
(adr_dep=58 AND adr_com=094) OR
(adr_dep=58 AND adr_com=095) OR
(adr_dep=58 AND adr_com=096) OR
(adr_dep=58 AND adr_com=097) OR
(adr_dep=58 AND adr_com=099) OR
(adr_dep=58 AND adr_com=101) OR
(adr_dep=58 AND adr_com=102) OR
(adr_dep=58 AND adr_com=104) OR
(adr_dep=58 AND adr_com=105) OR
(adr_dep=58 AND adr_com=107) OR
(adr_dep=58 AND adr_com=112) OR
(adr_dep=58 AND adr_com=113) OR
(adr_dep=58 AND adr_com=114) OR
(adr_dep=58 AND adr_com=115) OR
(adr_dep=58 AND adr_com=117) OR
(adr_dep=58 AND adr_com=118) OR
(adr_dep=58 AND adr_com=119) OR
(adr_dep=58 AND adr_com=121) OR
(adr_dep=58 AND adr_com=122) OR
(adr_dep=58 AND adr_com=124) OR
(adr_dep=58 AND adr_com=126) OR
(adr_dep=58 AND adr_com=127) OR
(adr_dep=58 AND adr_com=131) OR
(adr_dep=58 AND adr_com=134) OR
(adr_dep=58 AND adr_com=135) OR
(adr_dep=58 AND adr_com=136) OR
(adr_dep=58 AND adr_com=137) OR
(adr_dep=58 AND adr_com=138) OR
(adr_dep=58 AND adr_com=139) OR
(adr_dep=58 AND adr_com=140) OR
(adr_dep=58 AND adr_com=142) OR
(adr_dep=58 AND adr_com=143) OR
(adr_dep=58 AND adr_com=144) OR
(adr_dep=58 AND adr_com=146) OR
(adr_dep=58 AND adr_com=147) OR
(adr_dep=58 AND adr_com=148) OR
(adr_dep=58 AND adr_com=149) OR
(adr_dep=58 AND adr_com=151) OR
(adr_dep=58 AND adr_com=152) OR
(adr_dep=58 AND adr_com=155) OR
(adr_dep=58 AND adr_com=158) OR
(adr_dep=58 AND adr_com=160) OR
(adr_dep=58 AND adr_com=161) OR
(adr_dep=58 AND adr_com=164) OR
(adr_dep=58 AND adr_com=168) OR
(adr_dep=58 AND adr_com=171) OR
(adr_dep=58 AND adr_com=172) OR
(adr_dep=58 AND adr_com=173) OR
(adr_dep=58 AND adr_com=175) OR
(adr_dep=58 AND adr_com=176) OR
(adr_dep=58 AND adr_com=178) OR
(adr_dep=58 AND adr_com=182) OR
(adr_dep=58 AND adr_com=186) OR
(adr_dep=58 AND adr_com=187) OR
(adr_dep=58 AND adr_com=188) OR
(adr_dep=58 AND adr_com=189) OR
(adr_dep=58 AND adr_com=192) OR
(adr_dep=58 AND adr_com=193) OR
(adr_dep=58 AND adr_com=194) OR
(adr_dep=58 AND adr_com=195) OR
(adr_dep=58 AND adr_com=196) OR
(adr_dep=58 AND adr_com=199) OR
(adr_dep=58 AND adr_com=202) OR
(adr_dep=58 AND adr_com=203) OR
(adr_dep=58 AND adr_com=204) OR
(adr_dep=58 AND adr_com=207) OR
(adr_dep=58 AND adr_com=209) OR
(adr_dep=58 AND adr_com=211) OR
(adr_dep=58 AND adr_com=212) OR
(adr_dep=58 AND adr_com=213) OR
(adr_dep=58 AND adr_com=214) OR
(adr_dep=58 AND adr_com=215) OR
(adr_dep=58 AND adr_com=218) OR
(adr_dep=58 AND adr_com=219) OR
(adr_dep=58 AND adr_com=220) OR
(adr_dep=58 AND adr_com=221) OR
(adr_dep=58 AND adr_com=223) OR
(adr_dep=58 AND adr_com=225) OR
(adr_dep=58 AND adr_com=228) OR
(adr_dep=58 AND adr_com=231) OR
(adr_dep=58 AND adr_com=232) OR
(adr_dep=58 AND adr_com=233) OR
(adr_dep=58 AND adr_com=234) OR
(adr_dep=58 AND adr_com=236) OR
(adr_dep=58 AND adr_com=238) OR
(adr_dep=58 AND adr_com=239) OR
(adr_dep=58 AND adr_com=240) OR
(adr_dep=58 AND adr_com=241) OR
(adr_dep=58 AND adr_com=243) OR
(adr_dep=58 AND adr_com=245) OR
(adr_dep=58 AND adr_com=246) OR
(adr_dep=58 AND adr_com=247) OR
(adr_dep=58 AND adr_com=248) OR
(adr_dep=58 AND adr_com=250) OR
(adr_dep=58 AND adr_com=251) OR
(adr_dep=58 AND adr_com=252) OR
(adr_dep=58 AND adr_com=253) OR
(adr_dep=58 AND adr_com=254) OR
(adr_dep=58 AND adr_com=256) OR
(adr_dep=58 AND adr_com=257) OR
(adr_dep=58 AND adr_com=258) OR
(adr_dep=58 AND adr_com=259) OR
(adr_dep=58 AND adr_com=260) OR
(adr_dep=58 AND adr_com=261) OR
(adr_dep=58 AND adr_com=262) OR
(adr_dep=58 AND adr_com=264) OR
(adr_dep=58 AND adr_com=265) OR
(adr_dep=58 AND adr_com=267) OR
(adr_dep=58 AND adr_com=268) OR
(adr_dep=58 AND adr_com=269) OR
(adr_dep=58 AND adr_com=270) OR
(adr_dep=58 AND adr_com=273) OR
(adr_dep=58 AND adr_com=274) OR
(adr_dep=58 AND adr_com=275) OR
(adr_dep=58 AND adr_com=276) OR
(adr_dep=58 AND adr_com=277) OR
(adr_dep=58 AND adr_com=278) OR
(adr_dep=58 AND adr_com=279) OR
(adr_dep=58 AND adr_com=280) OR
(adr_dep=58 AND adr_com=281) OR
(adr_dep=58 AND adr_com=285) OR
(adr_dep=58 AND adr_com=287) OR
(adr_dep=58 AND adr_com=289) OR
(adr_dep=58 AND adr_com=290) OR
(adr_dep=58 AND adr_com=291) OR
(adr_dep=58 AND adr_com=292) OR
(adr_dep=58 AND adr_com=293) OR
(adr_dep=58 AND adr_com=294) OR
(adr_dep=58 AND adr_com=295) OR
(adr_dep=58 AND adr_com=296) OR
(adr_dep=58 AND adr_com=297) OR
(adr_dep=58 AND adr_com=298) OR
(adr_dep=58 AND adr_com=300) OR
(adr_dep=58 AND adr_com=301) OR
(adr_dep=58 AND adr_com=302) OR
(adr_dep=58 AND adr_com=303) OR
(adr_dep=58 AND adr_com=306) OR
(adr_dep=58 AND adr_com=307) OR
(adr_dep=58 AND adr_com=311) OR
(adr_dep=61 AND adr_com=001) OR
(adr_dep=61 AND adr_com=004) OR
(adr_dep=61 AND adr_com=005) OR
(adr_dep=61 AND adr_com=013) OR
(adr_dep=61 AND adr_com=016) OR
(adr_dep=61 AND adr_com=021) OR
(adr_dep=61 AND adr_com=483) OR
(adr_dep=61 AND adr_com=024) OR
(adr_dep=61 AND adr_com=025) OR
(adr_dep=61 AND adr_com=026) OR
(adr_dep=61 AND adr_com=029) OR
(adr_dep=61 AND adr_com=031) OR
(adr_dep=61 AND adr_com=033) OR
(adr_dep=61 AND adr_com=037) OR
(adr_dep=61 AND adr_com=038) OR
(adr_dep=61 AND adr_com=041) OR
(adr_dep=61 AND adr_com=042) OR
(adr_dep=61 AND adr_com=043) OR
(adr_dep=61 AND adr_com=045) OR
(adr_dep=61 AND adr_com=046) OR
(adr_dep=61 AND adr_com=048) OR
(adr_dep=61 AND adr_com=050) OR
(adr_dep=61 AND adr_com=051) OR
(adr_dep=61 AND adr_com=066) OR
(adr_dep=61 AND adr_com=067) OR
(adr_dep=61 AND adr_com=068) OR
(adr_dep=61 AND adr_com=075) OR
(adr_dep=61 AND adr_com=077) OR
(adr_dep=61 AND adr_com=079) OR
(adr_dep=61 AND adr_com=082) OR
(adr_dep=61 AND adr_com=087) OR
(adr_dep=61 AND adr_com=090) OR
(adr_dep=61 AND adr_com=091) OR
(adr_dep=61 AND adr_com=096) OR
(adr_dep=61 AND adr_com=097) OR
(adr_dep=61 AND adr_com=099) OR
(adr_dep=61 AND adr_com=102) OR
(adr_dep=61 AND adr_com=105) OR
(adr_dep=61 AND adr_com=107) OR
(adr_dep=61 AND adr_com=111) OR
(adr_dep=61 AND adr_com=112) OR
(adr_dep=61 AND adr_com=113) OR
(adr_dep=61 AND adr_com=115) OR
(adr_dep=61 AND adr_com=116) OR
(adr_dep=61 AND adr_com=117) OR
(adr_dep=61 AND adr_com=118) OR
(adr_dep=61 AND adr_com=121) OR
(adr_dep=61 AND adr_com=125) OR
(adr_dep=61 AND adr_com=126) OR
(adr_dep=61 AND adr_com=128) OR
(adr_dep=61 AND adr_com=129) OR
(adr_dep=61 AND adr_com=130) OR
(adr_dep=61 AND adr_com=135) OR
(adr_dep=61 AND adr_com=141) OR
(adr_dep=61 AND adr_com=142) OR
(adr_dep=61 AND adr_com=143) OR
(adr_dep=61 AND adr_com=144) OR
(adr_dep=61 AND adr_com=145) OR
(adr_dep=61 AND adr_com=146) OR
(adr_dep=61 AND adr_com=147) OR
(adr_dep=61 AND adr_com=154) OR
(adr_dep=61 AND adr_com=155) OR
(adr_dep=61 AND adr_com=156) OR
(adr_dep=61 AND adr_com=160) OR
(adr_dep=61 AND adr_com=165) OR
(adr_dep=61 AND adr_com=175) OR
(adr_dep=61 AND adr_com=182) OR
(adr_dep=61 AND adr_com=185) OR
(adr_dep=61 AND adr_com=186) OR
(adr_dep=61 AND adr_com=196) OR
(adr_dep=61 AND adr_com=200) OR
(adr_dep=61 AND adr_com=201) OR
(adr_dep=61 AND adr_com=202) OR
(adr_dep=61 AND adr_com=203) OR
(adr_dep=61 AND adr_com=207) OR
(adr_dep=61 AND adr_com=211) OR
(adr_dep=61 AND adr_com=213) OR
(adr_dep=61 AND adr_com=215) OR
(adr_dep=61 AND adr_com=223) OR
(adr_dep=61 AND adr_com=224) OR
(adr_dep=61 AND adr_com=228) OR
(adr_dep=61 AND adr_com=229) OR
(adr_dep=61 AND adr_com=231) OR
(adr_dep=61 AND adr_com=232) OR
(adr_dep=61 AND adr_com=234) OR
(adr_dep=61 AND adr_com=235) OR
(adr_dep=61 AND adr_com=239) OR
(adr_dep=61 AND adr_com=241) OR
(adr_dep=61 AND adr_com=245) OR
(adr_dep=61 AND adr_com=246) OR
(adr_dep=61 AND adr_com=247) OR
(adr_dep=61 AND adr_com=248) OR
(adr_dep=61 AND adr_com=251) OR
(adr_dep=61 AND adr_com=255) OR
(adr_dep=61 AND adr_com=257) OR
(adr_dep=61 AND adr_com=258) OR
(adr_dep=61 AND adr_com=261) OR
(adr_dep=61 AND adr_com=263) OR
(adr_dep=61 AND adr_com=266) OR
(adr_dep=61 AND adr_com=277) OR
(adr_dep=61 AND adr_com=279) OR
(adr_dep=61 AND adr_com=280) OR
(adr_dep=61 AND adr_com=284) OR
(adr_dep=61 AND adr_com=286) OR
(adr_dep=61 AND adr_com=293) OR
(adr_dep=61 AND adr_com=295) OR
(adr_dep=61 AND adr_com=304) OR
(adr_dep=61 AND adr_com=309) OR
(adr_dep=61 AND adr_com=318) OR
(adr_dep=61 AND adr_com=319) OR
(adr_dep=61 AND adr_com=321) OR
(adr_dep=61 AND adr_com=322) OR
(adr_dep=61 AND adr_com=324) OR
(adr_dep=61 AND adr_com=325) OR
(adr_dep=61 AND adr_com=327) OR
(adr_dep=61 AND adr_com=329) OR
(adr_dep=61 AND adr_com=331) OR
(adr_dep=61 AND adr_com=336) OR
(adr_dep=61 AND adr_com=337) OR
(adr_dep=61 AND adr_com=341) OR
(adr_dep=61 AND adr_com=345) OR
(adr_dep=61 AND adr_com=348) OR
(adr_dep=61 AND adr_com=350) OR
(adr_dep=61 AND adr_com=355) OR
(adr_dep=61 AND adr_com=356) OR
(adr_dep=61 AND adr_com=359) OR
(adr_dep=61 AND adr_com=360) OR
(adr_dep=61 AND adr_com=362) OR
(adr_dep=61 AND adr_com=365) OR
(adr_dep=61 AND adr_com=367) OR
(adr_dep=61 AND adr_com=368) OR
(adr_dep=61 AND adr_com=369) OR
(adr_dep=61 AND adr_com=370) OR
(adr_dep=61 AND adr_com=372) OR
(adr_dep=61 AND adr_com=379) OR
(adr_dep=61 AND adr_com=380) OR
(adr_dep=61 AND adr_com=381) OR
(adr_dep=61 AND adr_com=382) OR
(adr_dep=61 AND adr_com=387) OR
(adr_dep=61 AND adr_com=388) OR
(adr_dep=61 AND adr_com=394) OR
(adr_dep=61 AND adr_com=395) OR
(adr_dep=61 AND adr_com=396) OR
(adr_dep=61 AND adr_com=397) OR
(adr_dep=61 AND adr_com=400) OR
(adr_dep=61 AND adr_com=401) OR
(adr_dep=61 AND adr_com=404) OR
(adr_dep=61 AND adr_com=405) OR
(adr_dep=61 AND adr_com=409) OR
(adr_dep=61 AND adr_com=411) OR
(adr_dep=61 AND adr_com=412) OR
(adr_dep=61 AND adr_com=414) OR
(adr_dep=61 AND adr_com=415) OR
(adr_dep=61 AND adr_com=418) OR
(adr_dep=61 AND adr_com=425) OR
(adr_dep=61 AND adr_com=426) OR
(adr_dep=61 AND adr_com=430) OR
(adr_dep=61 AND adr_com=431) OR
(adr_dep=61 AND adr_com=433) OR
(adr_dep=61 AND adr_com=438) OR
(adr_dep=61 AND adr_com=439) OR
(adr_dep=61 AND adr_com=442) OR
(adr_dep=61 AND adr_com=448) OR
(adr_dep=61 AND adr_com=450) OR
(adr_dep=61 AND adr_com=454) OR
(adr_dep=61 AND adr_com=455) OR
(adr_dep=61 AND adr_com=458) OR
(adr_dep=61 AND adr_com=467) OR
(adr_dep=61 AND adr_com=469) OR
(adr_dep=61 AND adr_com=471) OR
(adr_dep=61 AND adr_com=476) OR
(adr_dep=61 AND adr_com=481) OR
(adr_dep=61 AND adr_com=482) OR
(adr_dep=61 AND adr_com=484) OR
(adr_dep=61 AND adr_com=487) OR
(adr_dep=61 AND adr_com=497) OR
(adr_dep=61 AND adr_com=498) OR
(adr_dep=61 AND adr_com=499) OR
(adr_dep=61 AND adr_com=501) OR
(adr_dep=61 AND adr_com=502) OR
(adr_dep=61 AND adr_com=507) OR
(adr_dep=61 AND adr_com=509) OR
(adr_dep=61 AND adr_com=015) OR
(adr_dep=61 AND adr_com=035) OR
(adr_dep=61 AND adr_com=040) OR
(adr_dep=61 AND adr_com=053) OR
(adr_dep=61 AND adr_com=056) OR
(adr_dep=61 AND adr_com=061) OR
(adr_dep=61 AND adr_com=064) OR
(adr_dep=61 AND adr_com=065) OR
(adr_dep=61 AND adr_com=074) OR
(adr_dep=61 AND adr_com=080) OR
(adr_dep=61 AND adr_com=093) OR
(adr_dep=61 AND adr_com=094) OR
(adr_dep=61 AND adr_com=095) OR
(adr_dep=61 AND adr_com=098) OR
(adr_dep=61 AND adr_com=104) OR
(adr_dep=61 AND adr_com=124) OR
(adr_dep=61 AND adr_com=133) OR
(adr_dep=61 AND adr_com=149) OR
(adr_dep=61 AND adr_com=159) OR
(adr_dep=61 AND adr_com=162) OR
(adr_dep=61 AND adr_com=163) OR
(adr_dep=61 AND adr_com=164) OR
(adr_dep=61 AND adr_com=166) OR
(adr_dep=61 AND adr_com=168) OR
(adr_dep=61 AND adr_com=169) OR
(adr_dep=61 AND adr_com=172) OR
(adr_dep=61 AND adr_com=183) OR
(adr_dep=61 AND adr_com=206) OR
(adr_dep=61 AND adr_com=209) OR
(adr_dep=61 AND adr_com=216) OR
(adr_dep=61 AND adr_com=221) OR
(adr_dep=61 AND adr_com=226) OR
(adr_dep=61 AND adr_com=230) OR
(adr_dep=61 AND adr_com=233) OR
(adr_dep=61 AND adr_com=242) OR
(adr_dep=61 AND adr_com=243) OR
(adr_dep=61 AND adr_com=244) OR
(adr_dep=61 AND adr_com=250) OR
(adr_dep=61 AND adr_com=260) OR
(adr_dep=61 AND adr_com=262) OR
(adr_dep=61 AND adr_com=278) OR
(adr_dep=61 AND adr_com=296) OR
(adr_dep=61 AND adr_com=297) OR
(adr_dep=61 AND adr_com=299) OR
(adr_dep=61 AND adr_com=300) OR
(adr_dep=61 AND adr_com=301) OR
(adr_dep=61 AND adr_com=323) OR
(adr_dep=61 AND adr_com=338) OR
(adr_dep=61 AND adr_com=344) OR
(adr_dep=61 AND adr_com=357) OR
(adr_dep=61 AND adr_com=363) OR
(adr_dep=61 AND adr_com=373) OR
(adr_dep=61 AND adr_com=374) OR
(adr_dep=61 AND adr_com=376) OR
(adr_dep=61 AND adr_com=377) OR
(adr_dep=61 AND adr_com=383) OR
(adr_dep=61 AND adr_com=384) OR
(adr_dep=61 AND adr_com=390) OR
(adr_dep=61 AND adr_com=398) OR
(adr_dep=61 AND adr_com=410) OR
(adr_dep=61 AND adr_com=421) OR
(adr_dep=61 AND adr_com=424) OR
(adr_dep=61 AND adr_com=428) OR
(adr_dep=61 AND adr_com=452) OR
(adr_dep=61 AND adr_com=459) OR
(adr_dep=61 AND adr_com=463) OR
(adr_dep=61 AND adr_com=464) OR
(adr_dep=61 AND adr_com=466) OR
(adr_dep=61 AND adr_com=475) OR
(adr_dep=61 AND adr_com=491) OR
(adr_dep=61 AND adr_com=492) OR
(adr_dep=61 AND adr_com=500) OR
(adr_dep=61 AND adr_com=513) OR
(adr_dep=63 AND adr_com=001) OR
(adr_dep=63 AND adr_com=002) OR
(adr_dep=63 AND adr_com=003) OR
(adr_dep=63 AND adr_com=004) OR
(adr_dep=63 AND adr_com=005) OR
(adr_dep=63 AND adr_com=007) OR
(adr_dep=63 AND adr_com=008) OR
(adr_dep=63 AND adr_com=009) OR
(adr_dep=63 AND adr_com=010) OR
(adr_dep=63 AND adr_com=011) OR
(adr_dep=63 AND adr_com=012) OR
(adr_dep=63 AND adr_com=013) OR
(adr_dep=63 AND adr_com=014) OR
(adr_dep=63 AND adr_com=015) OR
(adr_dep=63 AND adr_com=016) OR
(adr_dep=63 AND adr_com=017) OR
(adr_dep=63 AND adr_com=018) OR
(adr_dep=63 AND adr_com=019) OR
(adr_dep=63 AND adr_com=020) OR
(adr_dep=63 AND adr_com=021) OR
(adr_dep=63 AND adr_com=022) OR
(adr_dep=63 AND adr_com=023) OR
(adr_dep=63 AND adr_com=025) OR
(adr_dep=63 AND adr_com=026) OR
(adr_dep=63 AND adr_com=027) OR
(adr_dep=63 AND adr_com=029) OR
(adr_dep=63 AND adr_com=030) OR
(adr_dep=63 AND adr_com=031) OR
(adr_dep=63 AND adr_com=032) OR
(adr_dep=63 AND adr_com=033) OR
(adr_dep=63 AND adr_com=034) OR
(adr_dep=63 AND adr_com=035) OR
(adr_dep=63 AND adr_com=036) OR
(adr_dep=63 AND adr_com=037) OR
(adr_dep=63 AND adr_com=039) OR
(adr_dep=63 AND adr_com=040) OR
(adr_dep=63 AND adr_com=041) OR
(adr_dep=63 AND adr_com=042) OR
(adr_dep=63 AND adr_com=043) OR
(adr_dep=63 AND adr_com=044) OR
(adr_dep=63 AND adr_com=045) OR
(adr_dep=63 AND adr_com=046) OR
(adr_dep=63 AND adr_com=049) OR
(adr_dep=63 AND adr_com=050) OR
(adr_dep=63 AND adr_com=051) OR
(adr_dep=63 AND adr_com=052) OR
(adr_dep=63 AND adr_com=054) OR
(adr_dep=63 AND adr_com=055) OR
(adr_dep=63 AND adr_com=056) OR
(adr_dep=63 AND adr_com=057) OR
(adr_dep=63 AND adr_com=058) OR
(adr_dep=63 AND adr_com=059) OR
(adr_dep=63 AND adr_com=060) OR
(adr_dep=63 AND adr_com=061) OR
(adr_dep=63 AND adr_com=062) OR
(adr_dep=63 AND adr_com=063) OR
(adr_dep=63 AND adr_com=064) OR
(adr_dep=63 AND adr_com=065) OR
(adr_dep=63 AND adr_com=066) OR
(adr_dep=63 AND adr_com=067) OR
(adr_dep=63 AND adr_com=068) OR
(adr_dep=63 AND adr_com=069) OR
(adr_dep=63 AND adr_com=070) OR
(adr_dep=63 AND adr_com=071) OR
(adr_dep=63 AND adr_com=072) OR
(adr_dep=63 AND adr_com=073) OR
(adr_dep=63 AND adr_com=074) OR
(adr_dep=63 AND adr_com=075) OR
(adr_dep=63 AND adr_com=076) OR
(adr_dep=63 AND adr_com=078) OR
(adr_dep=63 AND adr_com=079) OR
(adr_dep=63 AND adr_com=080) OR
(adr_dep=63 AND adr_com=081) OR
(adr_dep=63 AND adr_com=082) OR
(adr_dep=63 AND adr_com=083) OR
(adr_dep=63 AND adr_com=084) OR
(adr_dep=63 AND adr_com=085) OR
(adr_dep=63 AND adr_com=086) OR
(adr_dep=63 AND adr_com=087) OR
(adr_dep=63 AND adr_com=088) OR
(adr_dep=63 AND adr_com=089) OR
(adr_dep=63 AND adr_com=090) OR
(adr_dep=63 AND adr_com=091) OR
(adr_dep=63 AND adr_com=092) OR
(adr_dep=63 AND adr_com=093) OR
(adr_dep=63 AND adr_com=094) OR
(adr_dep=63 AND adr_com=095) OR
(adr_dep=63 AND adr_com=096) OR
(adr_dep=63 AND adr_com=097) OR
(adr_dep=63 AND adr_com=099) OR
(adr_dep=63 AND adr_com=100) OR
(adr_dep=63 AND adr_com=101) OR
(adr_dep=63 AND adr_com=102) OR
(adr_dep=63 AND adr_com=103) OR
(adr_dep=63 AND adr_com=104) OR
(adr_dep=63 AND adr_com=105) OR
(adr_dep=63 AND adr_com=106) OR
(adr_dep=63 AND adr_com=107) OR
(adr_dep=63 AND adr_com=108) OR
(adr_dep=63 AND adr_com=109) OR
(adr_dep=63 AND adr_com=110) OR
(adr_dep=63 AND adr_com=111) OR
(adr_dep=63 AND adr_com=112) OR
(adr_dep=63 AND adr_com=113) OR
(adr_dep=63 AND adr_com=114) OR
(adr_dep=63 AND adr_com=115) OR
(adr_dep=63 AND adr_com=116) OR
(adr_dep=63 AND adr_com=118) OR
(adr_dep=63 AND adr_com=119) OR
(adr_dep=63 AND adr_com=120) OR
(adr_dep=63 AND adr_com=121) OR
(adr_dep=63 AND adr_com=122) OR
(adr_dep=63 AND adr_com=123) OR
(adr_dep=63 AND adr_com=124) OR
(adr_dep=63 AND adr_com=125) OR
(adr_dep=63 AND adr_com=126) OR
(adr_dep=63 AND adr_com=127) OR
(adr_dep=63 AND adr_com=128) OR
(adr_dep=63 AND adr_com=130) OR
(adr_dep=63 AND adr_com=131) OR
(adr_dep=63 AND adr_com=132) OR
(adr_dep=63 AND adr_com=133) OR
(adr_dep=63 AND adr_com=134) OR
(adr_dep=63 AND adr_com=135) OR
(adr_dep=63 AND adr_com=136) OR
(adr_dep=63 AND adr_com=137) OR
(adr_dep=63 AND adr_com=138) OR
(adr_dep=63 AND adr_com=139) OR
(adr_dep=63 AND adr_com=140) OR
(adr_dep=63 AND adr_com=141) OR
(adr_dep=63 AND adr_com=142) OR
(adr_dep=63 AND adr_com=143) OR
(adr_dep=63 AND adr_com=145) OR
(adr_dep=63 AND adr_com=146) OR
(adr_dep=63 AND adr_com=147) OR
(adr_dep=63 AND adr_com=148) OR
(adr_dep=63 AND adr_com=149) OR
(adr_dep=63 AND adr_com=150) OR
(adr_dep=63 AND adr_com=151) OR
(adr_dep=63 AND adr_com=152) OR
(adr_dep=63 AND adr_com=154) OR
(adr_dep=63 AND adr_com=155) OR
(adr_dep=63 AND adr_com=156) OR
(adr_dep=63 AND adr_com=157) OR
(adr_dep=63 AND adr_com=158) OR
(adr_dep=63 AND adr_com=160) OR
(adr_dep=63 AND adr_com=161) OR
(adr_dep=63 AND adr_com=162) OR
(adr_dep=63 AND adr_com=163) OR
(adr_dep=63 AND adr_com=164) OR
(adr_dep=63 AND adr_com=166) OR
(adr_dep=63 AND adr_com=167) OR
(adr_dep=63 AND adr_com=168) OR
(adr_dep=63 AND adr_com=170) OR
(adr_dep=63 AND adr_com=171) OR
(adr_dep=63 AND adr_com=172) OR
(adr_dep=63 AND adr_com=173) OR
(adr_dep=63 AND adr_com=174) OR
(adr_dep=63 AND adr_com=175) OR
(adr_dep=63 AND adr_com=177) OR
(adr_dep=63 AND adr_com=178) OR
(adr_dep=63 AND adr_com=179) OR
(adr_dep=63 AND adr_com=180) OR
(adr_dep=63 AND adr_com=181) OR
(adr_dep=63 AND adr_com=182) OR
(adr_dep=63 AND adr_com=184) OR
(adr_dep=63 AND adr_com=185) OR
(adr_dep=63 AND adr_com=186) OR
(adr_dep=63 AND adr_com=187) OR
(adr_dep=63 AND adr_com=188) OR
(adr_dep=63 AND adr_com=193) OR
(adr_dep=63 AND adr_com=194) OR
(adr_dep=63 AND adr_com=195) OR
(adr_dep=63 AND adr_com=196) OR
(adr_dep=63 AND adr_com=197) OR
(adr_dep=63 AND adr_com=198) OR
(adr_dep=63 AND adr_com=199) OR
(adr_dep=63 AND adr_com=200) OR
(adr_dep=63 AND adr_com=201) OR
(adr_dep=63 AND adr_com=202) OR
(adr_dep=63 AND adr_com=203) OR
(adr_dep=63 AND adr_com=204) OR
(adr_dep=63 AND adr_com=205) OR
(adr_dep=63 AND adr_com=206) OR
(adr_dep=63 AND adr_com=207) OR
(adr_dep=63 AND adr_com=208) OR
(adr_dep=63 AND adr_com=209) OR
(adr_dep=63 AND adr_com=210) OR
(adr_dep=63 AND adr_com=211) OR
(adr_dep=63 AND adr_com=212) OR
(adr_dep=63 AND adr_com=213) OR
(adr_dep=63 AND adr_com=214) OR
(adr_dep=63 AND adr_com=215) OR
(adr_dep=63 AND adr_com=216) OR
(adr_dep=63 AND adr_com=218) OR
(adr_dep=63 AND adr_com=219) OR
(adr_dep=63 AND adr_com=220) OR
(adr_dep=63 AND adr_com=221) OR
(adr_dep=63 AND adr_com=222) OR
(adr_dep=63 AND adr_com=223) OR
(adr_dep=63 AND adr_com=224) OR
(adr_dep=63 AND adr_com=226) OR
(adr_dep=63 AND adr_com=227) OR
(adr_dep=63 AND adr_com=228) OR
(adr_dep=63 AND adr_com=229) OR
(adr_dep=63 AND adr_com=230) OR
(adr_dep=63 AND adr_com=231) OR
(adr_dep=63 AND adr_com=232) OR
(adr_dep=63 AND adr_com=233) OR
(adr_dep=63 AND adr_com=234) OR
(adr_dep=63 AND adr_com=235) OR
(adr_dep=63 AND adr_com=237) OR
(adr_dep=63 AND adr_com=238) OR
(adr_dep=63 AND adr_com=239) OR
(adr_dep=63 AND adr_com=240) OR
(adr_dep=63 AND adr_com=241) OR
(adr_dep=63 AND adr_com=242) OR
(adr_dep=63 AND adr_com=243) OR
(adr_dep=63 AND adr_com=244) OR
(adr_dep=63 AND adr_com=245) OR
(adr_dep=63 AND adr_com=248) OR
(adr_dep=63 AND adr_com=249) OR
(adr_dep=63 AND adr_com=250) OR
(adr_dep=63 AND adr_com=251) OR
(adr_dep=63 AND adr_com=252) OR
(adr_dep=63 AND adr_com=253) OR
(adr_dep=63 AND adr_com=254) OR
(adr_dep=63 AND adr_com=255) OR
(adr_dep=63 AND adr_com=256) OR
(adr_dep=63 AND adr_com=257) OR
(adr_dep=63 AND adr_com=258) OR
(adr_dep=63 AND adr_com=259) OR
(adr_dep=63 AND adr_com=260) OR
(adr_dep=63 AND adr_com=261) OR
(adr_dep=63 AND adr_com=262) OR
(adr_dep=63 AND adr_com=263) OR
(adr_dep=63 AND adr_com=265) OR
(adr_dep=63 AND adr_com=266) OR
(adr_dep=63 AND adr_com=267) OR
(adr_dep=63 AND adr_com=268) OR
(adr_dep=63 AND adr_com=269) OR
(adr_dep=63 AND adr_com=270) OR
(adr_dep=63 AND adr_com=271) OR
(adr_dep=63 AND adr_com=272) OR
(adr_dep=63 AND adr_com=273) OR
(adr_dep=63 AND adr_com=275) OR
(adr_dep=63 AND adr_com=276) OR
(adr_dep=63 AND adr_com=277) OR
(adr_dep=63 AND adr_com=278) OR
(adr_dep=63 AND adr_com=280) OR
(adr_dep=63 AND adr_com=281) OR
(adr_dep=63 AND adr_com=282) OR
(adr_dep=63 AND adr_com=283) OR
(adr_dep=63 AND adr_com=284) OR
(adr_dep=63 AND adr_com=285) OR
(adr_dep=63 AND adr_com=286) OR
(adr_dep=63 AND adr_com=287) OR
(adr_dep=63 AND adr_com=288) OR
(adr_dep=63 AND adr_com=289) OR
(adr_dep=63 AND adr_com=290) OR
(adr_dep=63 AND adr_com=291) OR
(adr_dep=63 AND adr_com=292) OR
(adr_dep=63 AND adr_com=293) OR
(adr_dep=63 AND adr_com=294) OR
(adr_dep=63 AND adr_com=295) OR
(adr_dep=63 AND adr_com=296) OR
(adr_dep=63 AND adr_com=297) OR
(adr_dep=63 AND adr_com=298) OR
(adr_dep=63 AND adr_com=299) OR
(adr_dep=63 AND adr_com=300) OR
(adr_dep=63 AND adr_com=301) OR
(adr_dep=63 AND adr_com=302) OR
(adr_dep=63 AND adr_com=303) OR
(adr_dep=63 AND adr_com=304) OR
(adr_dep=63 AND adr_com=305) OR
(adr_dep=63 AND adr_com=306) OR
(adr_dep=63 AND adr_com=307) OR
(adr_dep=63 AND adr_com=308) OR
(adr_dep=63 AND adr_com=309) OR
(adr_dep=63 AND adr_com=310) OR
(adr_dep=63 AND adr_com=311) OR
(adr_dep=63 AND adr_com=312) OR
(adr_dep=63 AND adr_com=314) OR
(adr_dep=63 AND adr_com=315) OR
(adr_dep=63 AND adr_com=317) OR
(adr_dep=63 AND adr_com=318) OR
(adr_dep=63 AND adr_com=319) OR
(adr_dep=63 AND adr_com=320) OR
(adr_dep=63 AND adr_com=321) OR
(adr_dep=63 AND adr_com=322) OR
(adr_dep=63 AND adr_com=323) OR
(adr_dep=63 AND adr_com=324) OR
(adr_dep=63 AND adr_com=325) OR
(adr_dep=63 AND adr_com=326) OR
(adr_dep=63 AND adr_com=327) OR
(adr_dep=63 AND adr_com=328) OR
(adr_dep=63 AND adr_com=329) OR
(adr_dep=63 AND adr_com=330) OR
(adr_dep=63 AND adr_com=331) OR
(adr_dep=63 AND adr_com=332) OR
(adr_dep=63 AND adr_com=333) OR
(adr_dep=63 AND adr_com=334) OR
(adr_dep=63 AND adr_com=335) OR
(adr_dep=63 AND adr_com=337) OR
(adr_dep=63 AND adr_com=338) OR
(adr_dep=63 AND adr_com=339) OR
(adr_dep=63 AND adr_com=340) OR
(adr_dep=63 AND adr_com=341) OR
(adr_dep=63 AND adr_com=342) OR
(adr_dep=63 AND adr_com=343) OR
(adr_dep=63 AND adr_com=344) OR
(adr_dep=63 AND adr_com=345) OR
(adr_dep=63 AND adr_com=347) OR
(adr_dep=63 AND adr_com=348) OR
(adr_dep=63 AND adr_com=349) OR
(adr_dep=63 AND adr_com=350) OR
(adr_dep=63 AND adr_com=352) OR
(adr_dep=63 AND adr_com=353) OR
(adr_dep=63 AND adr_com=354) OR
(adr_dep=63 AND adr_com=355) OR
(adr_dep=63 AND adr_com=356) OR
(adr_dep=63 AND adr_com=357) OR
(adr_dep=63 AND adr_com=358) OR
(adr_dep=63 AND adr_com=359) OR
(adr_dep=63 AND adr_com=360) OR
(adr_dep=63 AND adr_com=362) OR
(adr_dep=63 AND adr_com=363) OR
(adr_dep=63 AND adr_com=364) OR
(adr_dep=63 AND adr_com=365) OR
(adr_dep=63 AND adr_com=366) OR
(adr_dep=63 AND adr_com=367) OR
(adr_dep=63 AND adr_com=368) OR
(adr_dep=63 AND adr_com=369) OR
(adr_dep=63 AND adr_com=371) OR
(adr_dep=63 AND adr_com=372) OR
(adr_dep=63 AND adr_com=373) OR
(adr_dep=63 AND adr_com=374) OR
(adr_dep=63 AND adr_com=375) OR
(adr_dep=63 AND adr_com=376) OR
(adr_dep=63 AND adr_com=377) OR
(adr_dep=63 AND adr_com=378) OR
(adr_dep=63 AND adr_com=379) OR
(adr_dep=63 AND adr_com=380) OR
(adr_dep=63 AND adr_com=381) OR
(adr_dep=63 AND adr_com=382) OR
(adr_dep=63 AND adr_com=383) OR
(adr_dep=63 AND adr_com=384) OR
(adr_dep=63 AND adr_com=385) OR
(adr_dep=63 AND adr_com=386) OR
(adr_dep=63 AND adr_com=387) OR
(adr_dep=63 AND adr_com=388) OR
(adr_dep=63 AND adr_com=389) OR
(adr_dep=63 AND adr_com=390) OR
(adr_dep=63 AND adr_com=391) OR
(adr_dep=63 AND adr_com=392) OR
(adr_dep=63 AND adr_com=393) OR
(adr_dep=63 AND adr_com=394) OR
(adr_dep=63 AND adr_com=395) OR
(adr_dep=63 AND adr_com=396) OR
(adr_dep=63 AND adr_com=398) OR
(adr_dep=63 AND adr_com=400) OR
(adr_dep=63 AND adr_com=401) OR
(adr_dep=63 AND adr_com=402) OR
(adr_dep=63 AND adr_com=403) OR
(adr_dep=63 AND adr_com=404) OR
(adr_dep=63 AND adr_com=405) OR
(adr_dep=63 AND adr_com=406) OR
(adr_dep=63 AND adr_com=408) OR
(adr_dep=63 AND adr_com=409) OR
(adr_dep=63 AND adr_com=410) OR
(adr_dep=63 AND adr_com=411) OR
(adr_dep=63 AND adr_com=412) OR
(adr_dep=63 AND adr_com=413) OR
(adr_dep=63 AND adr_com=414) OR
(adr_dep=63 AND adr_com=415) OR
(adr_dep=63 AND adr_com=417) OR
(adr_dep=63 AND adr_com=418) OR
(adr_dep=63 AND adr_com=419) OR
(adr_dep=63 AND adr_com=420) OR
(adr_dep=63 AND adr_com=422) OR
(adr_dep=63 AND adr_com=423) OR
(adr_dep=63 AND adr_com=424) OR
(adr_dep=63 AND adr_com=425) OR
(adr_dep=63 AND adr_com=427) OR
(adr_dep=63 AND adr_com=428) OR
(adr_dep=63 AND adr_com=429) OR
(adr_dep=63 AND adr_com=430) OR
(adr_dep=63 AND adr_com=431) OR
(adr_dep=63 AND adr_com=432) OR
(adr_dep=63 AND adr_com=434) OR
(adr_dep=63 AND adr_com=435) OR
(adr_dep=63 AND adr_com=436) OR
(adr_dep=63 AND adr_com=438) OR
(adr_dep=63 AND adr_com=439) OR
(adr_dep=63 AND adr_com=440) OR
(adr_dep=63 AND adr_com=441) OR
(adr_dep=63 AND adr_com=442) OR
(adr_dep=63 AND adr_com=443) OR
(adr_dep=63 AND adr_com=444) OR
(adr_dep=63 AND adr_com=445) OR
(adr_dep=63 AND adr_com=446) OR
(adr_dep=63 AND adr_com=447) OR
(adr_dep=63 AND adr_com=448) OR
(adr_dep=63 AND adr_com=449) OR
(adr_dep=63 AND adr_com=451) OR
(adr_dep=63 AND adr_com=452) OR
(adr_dep=63 AND adr_com=453) OR
(adr_dep=63 AND adr_com=454) OR
(adr_dep=63 AND adr_com=455) OR
(adr_dep=63 AND adr_com=456) OR
(adr_dep=63 AND adr_com=457) OR
(adr_dep=63 AND adr_com=458) OR
(adr_dep=63 AND adr_com=459) OR
(adr_dep=63 AND adr_com=460) OR
(adr_dep=63 AND adr_com=461) OR
(adr_dep=63 AND adr_com=462) OR
(adr_dep=63 AND adr_com=463) OR
(adr_dep=63 AND adr_com=464) OR
(adr_dep=63 AND adr_com=465) OR
(adr_dep=63 AND adr_com=466) OR
(adr_dep=63 AND adr_com=467) OR
(adr_dep=63 AND adr_com=468) OR
(adr_dep=63 AND adr_com=469) OR
(adr_dep=63 AND adr_com=470) OR
(adr_dep=63 AND adr_com=471) OR
(adr_dep=63 AND adr_com=472) OR
(adr_dep=63 AND adr_com=473) OR
(adr_dep=63 AND adr_com=006) OR
(adr_dep=63 AND adr_com=038) OR
(adr_dep=63 AND adr_com=053) OR
(adr_dep=63 AND adr_com=077) OR
(adr_dep=63 AND adr_com=117) OR
(adr_dep=63 AND adr_com=159) OR
(adr_dep=63 AND adr_com=165) OR
(adr_dep=63 AND adr_com=169) OR
(adr_dep=63 AND adr_com=176) OR
(adr_dep=63 AND adr_com=189) OR
(adr_dep=63 AND adr_com=191) OR
(adr_dep=63 AND adr_com=247) OR
(adr_dep=63 AND adr_com=264) OR
(adr_dep=63 AND adr_com=274) OR
(adr_dep=63 AND adr_com=313) OR
(adr_dep=63 AND adr_com=351) OR
(adr_dep=63 AND adr_com=370) OR
(adr_dep=63 AND adr_com=397) OR
(adr_dep=63 AND adr_com=407) OR
(adr_dep=63 AND adr_com=433) OR
(adr_dep=63 AND adr_com=450) OR
(adr_dep=71 AND adr_com=006) OR
(adr_dep=71 AND adr_com=008) OR
(adr_dep=71 AND adr_com=010) OR
(adr_dep=71 AND adr_com=011) OR
(adr_dep=71 AND adr_com=012) OR
(adr_dep=71 AND adr_com=014) OR
(adr_dep=71 AND adr_com=015) OR
(adr_dep=71 AND adr_com=017) OR
(adr_dep=71 AND adr_com=020) OR
(adr_dep=71 AND adr_com=021) OR
(adr_dep=71 AND adr_com=022) OR
(adr_dep=71 AND adr_com=024) OR
(adr_dep=71 AND adr_com=025) OR
(adr_dep=71 AND adr_com=038) OR
(adr_dep=71 AND adr_com=040) OR
(adr_dep=71 AND adr_com=041) OR
(adr_dep=71 AND adr_com=046) OR
(adr_dep=71 AND adr_com=047) OR
(adr_dep=71 AND adr_com=048) OR
(adr_dep=71 AND adr_com=060) OR
(adr_dep=71 AND adr_com=062) OR
(adr_dep=71 AND adr_com=063) OR
(adr_dep=71 AND adr_com=071) OR
(adr_dep=71 AND adr_com=075) OR
(adr_dep=71 AND adr_com=077) OR
(adr_dep=71 AND adr_com=082) OR
(adr_dep=71 AND adr_com=086) OR
(adr_dep=71 AND adr_com=088) OR
(adr_dep=71 AND adr_com=095) OR
(adr_dep=71 AND adr_com=096) OR
(adr_dep=71 AND adr_com=098) OR
(adr_dep=71 AND adr_com=103) OR
(adr_dep=71 AND adr_com=106) OR
(adr_dep=71 AND adr_com=110) OR
(adr_dep=71 AND adr_com=111) OR
(adr_dep=71 AND adr_com=113) OR
(adr_dep=71 AND adr_com=116) OR
(adr_dep=71 AND adr_com=120) OR
(adr_dep=71 AND adr_com=123) OR
(adr_dep=71 AND adr_com=129) OR
(adr_dep=71 AND adr_com=132) OR
(adr_dep=71 AND adr_com=133) OR
(adr_dep=71 AND adr_com=136) OR
(adr_dep=71 AND adr_com=140) OR
(adr_dep=71 AND adr_com=141) OR
(adr_dep=71 AND adr_com=142) OR
(adr_dep=71 AND adr_com=144) OR
(adr_dep=71 AND adr_com=148) OR
(adr_dep=71 AND adr_com=152) OR
(adr_dep=71 AND adr_com=153) OR
(adr_dep=71 AND adr_com=155) OR
(adr_dep=71 AND adr_com=160) OR
(adr_dep=71 AND adr_com=161) OR
(adr_dep=71 AND adr_com=162) OR
(adr_dep=71 AND adr_com=166) OR
(adr_dep=71 AND adr_com=172) OR
(adr_dep=71 AND adr_com=176) OR
(adr_dep=71 AND adr_com=179) OR
(adr_dep=71 AND adr_com=184) OR
(adr_dep=71 AND adr_com=185) OR
(adr_dep=71 AND adr_com=190) OR
(adr_dep=71 AND adr_com=192) OR
(adr_dep=71 AND adr_com=200) OR
(adr_dep=71 AND adr_com=203) OR
(adr_dep=71 AND adr_com=212) OR
(adr_dep=71 AND adr_com=218) OR
(adr_dep=71 AND adr_com=220) OR
(adr_dep=71 AND adr_com=222) OR
(adr_dep=71 AND adr_com=223) OR
(adr_dep=71 AND adr_com=224) OR
(adr_dep=71 AND adr_com=227) OR
(adr_dep=71 AND adr_com=229) OR
(adr_dep=71 AND adr_com=230) OR
(adr_dep=71 AND adr_com=232) OR
(adr_dep=71 AND adr_com=233) OR
(adr_dep=71 AND adr_com=237) OR
(adr_dep=71 AND adr_com=238) OR
(adr_dep=71 AND adr_com=239) OR
(adr_dep=71 AND adr_com=251) OR
(adr_dep=71 AND adr_com=255) OR
(adr_dep=71 AND adr_com=259) OR
(adr_dep=71 AND adr_com=266) OR
(adr_dep=71 AND adr_com=268) OR
(adr_dep=71 AND adr_com=271) OR
(adr_dep=71 AND adr_com=273) OR
(adr_dep=71 AND adr_com=275) OR
(adr_dep=71 AND adr_com=276) OR
(adr_dep=71 AND adr_com=279) OR
(adr_dep=71 AND adr_com=280) OR
(adr_dep=71 AND adr_com=281) OR
(adr_dep=71 AND adr_com=282) OR
(adr_dep=71 AND adr_com=285) OR
(adr_dep=71 AND adr_com=291) OR
(adr_dep=71 AND adr_com=297) OR
(adr_dep=71 AND adr_com=301) OR
(adr_dep=71 AND adr_com=306) OR
(adr_dep=71 AND adr_com=307) OR
(adr_dep=71 AND adr_com=309) OR
(adr_dep=71 AND adr_com=313) OR
(adr_dep=71 AND adr_com=317) OR
(adr_dep=71 AND adr_com=322) OR
(adr_dep=71 AND adr_com=323) OR
(adr_dep=71 AND adr_com=325) OR
(adr_dep=71 AND adr_com=327) OR
(adr_dep=71 AND adr_com=330) OR
(adr_dep=71 AND adr_com=331) OR
(adr_dep=71 AND adr_com=334) OR
(adr_dep=71 AND adr_com=335) OR
(adr_dep=71 AND adr_com=337) OR
(adr_dep=71 AND adr_com=339) OR
(adr_dep=71 AND adr_com=340) OR
(adr_dep=71 AND adr_com=342) OR
(adr_dep=71 AND adr_com=346) OR
(adr_dep=71 AND adr_com=348) OR
(adr_dep=71 AND adr_com=349) OR
(adr_dep=71 AND adr_com=354) OR
(adr_dep=71 AND adr_com=356) OR
(adr_dep=71 AND adr_com=361) OR
(adr_dep=71 AND adr_com=368) OR
(adr_dep=71 AND adr_com=370) OR
(adr_dep=71 AND adr_com=382) OR
(adr_dep=71 AND adr_com=388) OR
(adr_dep=71 AND adr_com=389) OR
(adr_dep=71 AND adr_com=390) OR
(adr_dep=71 AND adr_com=393) OR
(adr_dep=71 AND adr_com=395) OR
(adr_dep=71 AND adr_com=399) OR
(adr_dep=71 AND adr_com=406) OR
(adr_dep=71 AND adr_com=407) OR
(adr_dep=71 AND adr_com=408) OR
(adr_dep=71 AND adr_com=409) OR
(adr_dep=71 AND adr_com=411) OR
(adr_dep=71 AND adr_com=412) OR
(adr_dep=71 AND adr_com=414) OR
(adr_dep=71 AND adr_com=415) OR
(adr_dep=71 AND adr_com=421) OR
(adr_dep=71 AND adr_com=428) OR
(adr_dep=71 AND adr_com=433) OR
(adr_dep=71 AND adr_com=434) OR
(adr_dep=71 AND adr_com=437) OR
(adr_dep=71 AND adr_com=438) OR
(adr_dep=71 AND adr_com=439) OR
(adr_dep=71 AND adr_com=440) OR
(adr_dep=71 AND adr_com=451) OR
(adr_dep=71 AND adr_com=453) OR
(adr_dep=71 AND adr_com=463) OR
(adr_dep=71 AND adr_com=466) OR
(adr_dep=71 AND adr_com=473) OR
(adr_dep=71 AND adr_com=474) OR
(adr_dep=71 AND adr_com=477) OR
(adr_dep=71 AND adr_com=478) OR
(adr_dep=71 AND adr_com=479) OR
(adr_dep=71 AND adr_com=482) OR
(adr_dep=71 AND adr_com=483) OR
(adr_dep=71 AND adr_com=486) OR
(adr_dep=71 AND adr_com=490) OR
(adr_dep=71 AND adr_com=491) OR
(adr_dep=71 AND adr_com=499) OR
(adr_dep=71 AND adr_com=500) OR
(adr_dep=71 AND adr_com=509) OR
(adr_dep=71 AND adr_com=510) OR
(adr_dep=71 AND adr_com=527) OR
(adr_dep=71 AND adr_com=530) OR
(adr_dep=71 AND adr_com=531) OR
(adr_dep=71 AND adr_com=533) OR
(adr_dep=71 AND adr_com=535) OR
(adr_dep=71 AND adr_com=537) OR
(adr_dep=71 AND adr_com=539) OR
(adr_dep=71 AND adr_com=542) OR
(adr_dep=71 AND adr_com=551) OR
(adr_dep=71 AND adr_com=552) OR
(adr_dep=71 AND adr_com=553) OR
(adr_dep=71 AND adr_com=554) OR
(adr_dep=71 AND adr_com=557) OR
(adr_dep=71 AND adr_com=559) OR
(adr_dep=71 AND adr_com=561) OR
(adr_dep=71 AND adr_com=562) OR
(adr_dep=71 AND adr_com=564) OR
(adr_dep=71 AND adr_com=565) OR
(adr_dep=71 AND adr_com=573) OR
(adr_dep=71 AND adr_com=581) OR
(adr_dep=71 AND adr_com=586) OR
(adr_dep=71 AND adr_com=588) OR
(adr_dep=71 AND adr_com=589) OR
(adr_dep=71 AND adr_com=590) OR
(adr_dep=71 AND adr_com=009) OR
(adr_dep=71 AND adr_com=059) OR
(adr_dep=71 AND adr_com=149) OR
(adr_dep=71 AND adr_com=165) OR
(adr_dep=71 AND adr_com=178) OR
(adr_dep=71 AND adr_com=183) OR
(adr_dep=71 AND adr_com=187) OR
(adr_dep=71 AND adr_com=231) OR
(adr_dep=71 AND adr_com=278) OR
(adr_dep=71 AND adr_com=286) OR
(adr_dep=71 AND adr_com=289) OR
(adr_dep=71 AND adr_com=310) OR
(adr_dep=71 AND adr_com=316) OR
(adr_dep=71 AND adr_com=320) OR
(adr_dep=71 AND adr_com=375) OR
(adr_dep=71 AND adr_com=376) OR
(adr_dep=71 AND adr_com=394) OR
(adr_dep=71 AND adr_com=413) OR
(adr_dep=71 AND adr_com=424) OR
(adr_dep=71 AND adr_com=436) OR
(adr_dep=71 AND adr_com=450) OR
(adr_dep=71 AND adr_com=465) OR
(adr_dep=71 AND adr_com=468) OR
(adr_dep=71 AND adr_com=472) OR
(adr_dep=71 AND adr_com=493) OR
(adr_dep=71 AND adr_com=524) OR
(adr_dep=71 AND adr_com=529) OR
(adr_dep=71 AND adr_com=540) OR
(adr_dep=71 AND adr_com=571) OR
(adr_dep=72 AND adr_com=001) OR
(adr_dep=72 AND adr_com=002) OR
(adr_dep=72 AND adr_com=003) OR
(adr_dep=72 AND adr_com=004) OR
(adr_dep=72 AND adr_com=005) OR
(adr_dep=72 AND adr_com=006) OR
(adr_dep=72 AND adr_com=007) OR
(adr_dep=72 AND adr_com=008) OR
(adr_dep=72 AND adr_com=009) OR
(adr_dep=72 AND adr_com=010) OR
(adr_dep=72 AND adr_com=011) OR
(adr_dep=72 AND adr_com=012) OR
(adr_dep=72 AND adr_com=013) OR
(adr_dep=72 AND adr_com=015) OR
(adr_dep=72 AND adr_com=016) OR
(adr_dep=72 AND adr_com=017) OR
(adr_dep=72 AND adr_com=018) OR
(adr_dep=72 AND adr_com=019) OR
(adr_dep=72 AND adr_com=020) OR
(adr_dep=72 AND adr_com=021) OR
(adr_dep=72 AND adr_com=022) OR
(adr_dep=72 AND adr_com=023) OR
(adr_dep=72 AND adr_com=024) OR
(adr_dep=72 AND adr_com=025) OR
(adr_dep=72 AND adr_com=026) OR
(adr_dep=72 AND adr_com=027) OR
(adr_dep=72 AND adr_com=028) OR
(adr_dep=72 AND adr_com=029) OR
(adr_dep=72 AND adr_com=031) OR
(adr_dep=72 AND adr_com=032) OR
(adr_dep=72 AND adr_com=033) OR
(adr_dep=72 AND adr_com=034) OR
(adr_dep=72 AND adr_com=035) OR
(adr_dep=72 AND adr_com=036) OR
(adr_dep=72 AND adr_com=037) OR
(adr_dep=72 AND adr_com=038) OR
(adr_dep=72 AND adr_com=039) OR
(adr_dep=72 AND adr_com=040) OR
(adr_dep=72 AND adr_com=041) OR
(adr_dep=72 AND adr_com=042) OR
(adr_dep=72 AND adr_com=043) OR
(adr_dep=72 AND adr_com=044) OR
(adr_dep=72 AND adr_com=045) OR
(adr_dep=72 AND adr_com=046) OR
(adr_dep=72 AND adr_com=047) OR
(adr_dep=72 AND adr_com=048) OR
(adr_dep=72 AND adr_com=049) OR
(adr_dep=72 AND adr_com=050) OR
(adr_dep=72 AND adr_com=051) OR
(adr_dep=72 AND adr_com=052) OR
(adr_dep=72 AND adr_com=053) OR
(adr_dep=72 AND adr_com=054) OR
(adr_dep=72 AND adr_com=056) OR
(adr_dep=72 AND adr_com=057) OR
(adr_dep=72 AND adr_com=058) OR
(adr_dep=72 AND adr_com=059) OR
(adr_dep=72 AND adr_com=060) OR
(adr_dep=72 AND adr_com=061) OR
(adr_dep=72 AND adr_com=062) OR
(adr_dep=72 AND adr_com=063) OR
(adr_dep=72 AND adr_com=064) OR
(adr_dep=72 AND adr_com=065) OR
(adr_dep=72 AND adr_com=066) OR
(adr_dep=72 AND adr_com=067) OR
(adr_dep=72 AND adr_com=068) OR
(adr_dep=72 AND adr_com=069) OR
(adr_dep=72 AND adr_com=070) OR
(adr_dep=72 AND adr_com=071) OR
(adr_dep=72 AND adr_com=072) OR
(adr_dep=72 AND adr_com=073) OR
(adr_dep=72 AND adr_com=074) OR
(adr_dep=72 AND adr_com=075) OR
(adr_dep=72 AND adr_com=076) OR
(adr_dep=72 AND adr_com=077) OR
(adr_dep=72 AND adr_com=078) OR
(adr_dep=72 AND adr_com=079) OR
(adr_dep=72 AND adr_com=080) OR
(adr_dep=72 AND adr_com=081) OR
(adr_dep=72 AND adr_com=082) OR
(adr_dep=72 AND adr_com=083) OR
(adr_dep=72 AND adr_com=084) OR
(adr_dep=72 AND adr_com=085) OR
(adr_dep=72 AND adr_com=086) OR
(adr_dep=72 AND adr_com=087) OR
(adr_dep=72 AND adr_com=088) OR
(adr_dep=72 AND adr_com=089) OR
(adr_dep=72 AND adr_com=090) OR
(adr_dep=72 AND adr_com=091) OR
(adr_dep=72 AND adr_com=093) OR
(adr_dep=72 AND adr_com=094) OR
(adr_dep=72 AND adr_com=095) OR
(adr_dep=72 AND adr_com=096) OR
(adr_dep=72 AND adr_com=097) OR
(adr_dep=72 AND adr_com=098) OR
(adr_dep=72 AND adr_com=099) OR
(adr_dep=72 AND adr_com=100) OR
(adr_dep=72 AND adr_com=101) OR
(adr_dep=72 AND adr_com=102) OR
(adr_dep=72 AND adr_com=103) OR
(adr_dep=72 AND adr_com=104) OR
(adr_dep=72 AND adr_com=105) OR
(adr_dep=72 AND adr_com=106) OR
(adr_dep=72 AND adr_com=107) OR
(adr_dep=72 AND adr_com=108) OR
(adr_dep=72 AND adr_com=109) OR
(adr_dep=72 AND adr_com=110) OR
(adr_dep=72 AND adr_com=111) OR
(adr_dep=72 AND adr_com=112) OR
(adr_dep=72 AND adr_com=113) OR
(adr_dep=72 AND adr_com=114) OR
(adr_dep=72 AND adr_com=115) OR
(adr_dep=72 AND adr_com=116) OR
(adr_dep=72 AND adr_com=117) OR
(adr_dep=72 AND adr_com=118) OR
(adr_dep=72 AND adr_com=119) OR
(adr_dep=72 AND adr_com=120) OR
(adr_dep=72 AND adr_com=121) OR
(adr_dep=72 AND adr_com=122) OR
(adr_dep=72 AND adr_com=123) OR
(adr_dep=72 AND adr_com=124) OR
(adr_dep=72 AND adr_com=125) OR
(adr_dep=72 AND adr_com=126) OR
(adr_dep=72 AND adr_com=127) OR
(adr_dep=72 AND adr_com=128) OR
(adr_dep=72 AND adr_com=129) OR
(adr_dep=72 AND adr_com=130) OR
(adr_dep=72 AND adr_com=131) OR
(adr_dep=72 AND adr_com=132) OR
(adr_dep=72 AND adr_com=133) OR
(adr_dep=72 AND adr_com=134) OR
(adr_dep=72 AND adr_com=135) OR
(adr_dep=72 AND adr_com=136) OR
(adr_dep=72 AND adr_com=137) OR
(adr_dep=72 AND adr_com=138) OR
(adr_dep=72 AND adr_com=139) OR
(adr_dep=72 AND adr_com=141) OR
(adr_dep=72 AND adr_com=142) OR
(adr_dep=72 AND adr_com=143) OR
(adr_dep=72 AND adr_com=144) OR
(adr_dep=72 AND adr_com=145) OR
(adr_dep=72 AND adr_com=146) OR
(adr_dep=72 AND adr_com=147) OR
(adr_dep=72 AND adr_com=148) OR
(adr_dep=72 AND adr_com=149) OR
(adr_dep=72 AND adr_com=150) OR
(adr_dep=72 AND adr_com=151) OR
(adr_dep=72 AND adr_com=152) OR
(adr_dep=72 AND adr_com=153) OR
(adr_dep=72 AND adr_com=154) OR
(adr_dep=72 AND adr_com=155) OR
(adr_dep=72 AND adr_com=156) OR
(adr_dep=72 AND adr_com=157) OR
(adr_dep=72 AND adr_com=158) OR
(adr_dep=72 AND adr_com=159) OR
(adr_dep=72 AND adr_com=160) OR
(adr_dep=72 AND adr_com=161) OR
(adr_dep=72 AND adr_com=162) OR
(adr_dep=72 AND adr_com=163) OR
(adr_dep=72 AND adr_com=164) OR
(adr_dep=72 AND adr_com=165) OR
(adr_dep=72 AND adr_com=166) OR
(adr_dep=72 AND adr_com=167) OR
(adr_dep=72 AND adr_com=168) OR
(adr_dep=72 AND adr_com=169) OR
(adr_dep=72 AND adr_com=170) OR
(adr_dep=72 AND adr_com=171) OR
(adr_dep=72 AND adr_com=172) OR
(adr_dep=72 AND adr_com=173) OR
(adr_dep=72 AND adr_com=174) OR
(adr_dep=72 AND adr_com=175) OR
(adr_dep=72 AND adr_com=176) OR
(adr_dep=72 AND adr_com=177) OR
(adr_dep=72 AND adr_com=178) OR
(adr_dep=72 AND adr_com=179) OR
(adr_dep=72 AND adr_com=180) OR
(adr_dep=72 AND adr_com=181) OR
(adr_dep=72 AND adr_com=182) OR
(adr_dep=72 AND adr_com=183) OR
(adr_dep=72 AND adr_com=184) OR
(adr_dep=72 AND adr_com=185) OR
(adr_dep=72 AND adr_com=186) OR
(adr_dep=72 AND adr_com=187) OR
(adr_dep=72 AND adr_com=188) OR
(adr_dep=72 AND adr_com=189) OR
(adr_dep=72 AND adr_com=190) OR
(adr_dep=72 AND adr_com=191) OR
(adr_dep=72 AND adr_com=192) OR
(adr_dep=72 AND adr_com=193) OR
(adr_dep=72 AND adr_com=194) OR
(adr_dep=72 AND adr_com=195) OR
(adr_dep=72 AND adr_com=196) OR
(adr_dep=72 AND adr_com=197) OR
(adr_dep=72 AND adr_com=198) OR
(adr_dep=72 AND adr_com=199) OR
(adr_dep=72 AND adr_com=200) OR
(adr_dep=72 AND adr_com=201) OR
(adr_dep=72 AND adr_com=202) OR
(adr_dep=72 AND adr_com=203) OR
(adr_dep=72 AND adr_com=204) OR
(adr_dep=72 AND adr_com=205) OR
(adr_dep=72 AND adr_com=207) OR
(adr_dep=72 AND adr_com=208) OR
(adr_dep=72 AND adr_com=209) OR
(adr_dep=72 AND adr_com=210) OR
(adr_dep=72 AND adr_com=211) OR
(adr_dep=72 AND adr_com=212) OR
(adr_dep=72 AND adr_com=213) OR
(adr_dep=72 AND adr_com=214) OR
(adr_dep=72 AND adr_com=215) OR
(adr_dep=72 AND adr_com=216) OR
(adr_dep=72 AND adr_com=217) OR
(adr_dep=72 AND adr_com=218) OR
(adr_dep=72 AND adr_com=219) OR
(adr_dep=72 AND adr_com=220) OR
(adr_dep=72 AND adr_com=221) OR
(adr_dep=72 AND adr_com=222) OR
(adr_dep=72 AND adr_com=223) OR
(adr_dep=72 AND adr_com=224) OR
(adr_dep=72 AND adr_com=225) OR
(adr_dep=72 AND adr_com=226) OR
(adr_dep=72 AND adr_com=227) OR
(adr_dep=72 AND adr_com=228) OR
(adr_dep=72 AND adr_com=229) OR
(adr_dep=72 AND adr_com=230) OR
(adr_dep=72 AND adr_com=231) OR
(adr_dep=72 AND adr_com=232) OR
(adr_dep=72 AND adr_com=233) OR
(adr_dep=72 AND adr_com=234) OR
(adr_dep=72 AND adr_com=235) OR
(adr_dep=72 AND adr_com=236) OR
(adr_dep=72 AND adr_com=237) OR
(adr_dep=72 AND adr_com=238) OR
(adr_dep=72 AND adr_com=239) OR
(adr_dep=72 AND adr_com=240) OR
(adr_dep=72 AND adr_com=241) OR
(adr_dep=72 AND adr_com=243) OR
(adr_dep=72 AND adr_com=244) OR
(adr_dep=72 AND adr_com=245) OR
(adr_dep=72 AND adr_com=246) OR
(adr_dep=72 AND adr_com=247) OR
(adr_dep=72 AND adr_com=248) OR
(adr_dep=72 AND adr_com=249) OR
(adr_dep=72 AND adr_com=250) OR
(adr_dep=72 AND adr_com=251) OR
(adr_dep=72 AND adr_com=252) OR
(adr_dep=72 AND adr_com=253) OR
(adr_dep=72 AND adr_com=254) OR
(adr_dep=72 AND adr_com=255) OR
(adr_dep=72 AND adr_com=256) OR
(adr_dep=72 AND adr_com=257) OR
(adr_dep=72 AND adr_com=258) OR
(adr_dep=72 AND adr_com=259) OR
(adr_dep=72 AND adr_com=260) OR
(adr_dep=72 AND adr_com=261) OR
(adr_dep=72 AND adr_com=262) OR
(adr_dep=72 AND adr_com=264) OR
(adr_dep=72 AND adr_com=265) OR
(adr_dep=72 AND adr_com=266) OR
(adr_dep=72 AND adr_com=267) OR
(adr_dep=72 AND adr_com=268) OR
(adr_dep=72 AND adr_com=269) OR
(adr_dep=72 AND adr_com=270) OR
(adr_dep=72 AND adr_com=271) OR
(adr_dep=72 AND adr_com=272) OR
(adr_dep=72 AND adr_com=273) OR
(adr_dep=72 AND adr_com=274) OR
(adr_dep=72 AND adr_com=275) OR
(adr_dep=72 AND adr_com=276) OR
(adr_dep=72 AND adr_com=277) OR
(adr_dep=72 AND adr_com=278) OR
(adr_dep=72 AND adr_com=279) OR
(adr_dep=72 AND adr_com=280) OR
(adr_dep=72 AND adr_com=281) OR
(adr_dep=72 AND adr_com=282) OR
(adr_dep=72 AND adr_com=283) OR
(adr_dep=72 AND adr_com=284) OR
(adr_dep=72 AND adr_com=286) OR
(adr_dep=72 AND adr_com=287) OR
(adr_dep=72 AND adr_com=288) OR
(adr_dep=72 AND adr_com=289) OR
(adr_dep=72 AND adr_com=290) OR
(adr_dep=72 AND adr_com=291) OR
(adr_dep=72 AND adr_com=292) OR
(adr_dep=72 AND adr_com=293) OR
(adr_dep=72 AND adr_com=294) OR
(adr_dep=72 AND adr_com=295) OR
(adr_dep=72 AND adr_com=296) OR
(adr_dep=72 AND adr_com=297) OR
(adr_dep=72 AND adr_com=298) OR
(adr_dep=72 AND adr_com=299) OR
(adr_dep=72 AND adr_com=300) OR
(adr_dep=72 AND adr_com=301) OR
(adr_dep=72 AND adr_com=302) OR
(adr_dep=72 AND adr_com=303) OR
(adr_dep=72 AND adr_com=304) OR
(adr_dep=72 AND adr_com=305) OR
(adr_dep=72 AND adr_com=306) OR
(adr_dep=72 AND adr_com=307) OR
(adr_dep=72 AND adr_com=308) OR
(adr_dep=72 AND adr_com=309) OR
(adr_dep=72 AND adr_com=310) OR
(adr_dep=72 AND adr_com=311) OR
(adr_dep=72 AND adr_com=312) OR
(adr_dep=72 AND adr_com=313) OR
(adr_dep=72 AND adr_com=314) OR
(adr_dep=72 AND adr_com=315) OR
(adr_dep=72 AND adr_com=316) OR
(adr_dep=72 AND adr_com=317) OR
(adr_dep=72 AND adr_com=318) OR
(adr_dep=72 AND adr_com=319) OR
(adr_dep=72 AND adr_com=320) OR
(adr_dep=72 AND adr_com=321) OR
(adr_dep=72 AND adr_com=322) OR
(adr_dep=72 AND adr_com=323) OR
(adr_dep=72 AND adr_com=324) OR
(adr_dep=72 AND adr_com=325) OR
(adr_dep=72 AND adr_com=326) OR
(adr_dep=72 AND adr_com=327) OR
(adr_dep=72 AND adr_com=328) OR
(adr_dep=72 AND adr_com=329) OR
(adr_dep=72 AND adr_com=330) OR
(adr_dep=72 AND adr_com=331) OR
(adr_dep=72 AND adr_com=332) OR
(adr_dep=72 AND adr_com=333) OR
(adr_dep=72 AND adr_com=334) OR
(adr_dep=72 AND adr_com=335) OR
(adr_dep=72 AND adr_com=336) OR
(adr_dep=72 AND adr_com=337) OR
(adr_dep=72 AND adr_com=338) OR
(adr_dep=72 AND adr_com=339) OR
(adr_dep=72 AND adr_com=340) OR
(adr_dep=72 AND adr_com=341) OR
(adr_dep=72 AND adr_com=342) OR
(adr_dep=72 AND adr_com=343) OR
(adr_dep=72 AND adr_com=344) OR
(adr_dep=72 AND adr_com=345) OR
(adr_dep=72 AND adr_com=346) OR
(adr_dep=72 AND adr_com=347) OR
(adr_dep=72 AND adr_com=348) OR
(adr_dep=72 AND adr_com=349) OR
(adr_dep=72 AND adr_com=350) OR
(adr_dep=72 AND adr_com=351) OR
(adr_dep=72 AND adr_com=352) OR
(adr_dep=72 AND adr_com=353) OR
(adr_dep=72 AND adr_com=354) OR
(adr_dep=72 AND adr_com=355) OR
(adr_dep=72 AND adr_com=356) OR
(adr_dep=72 AND adr_com=357) OR
(adr_dep=72 AND adr_com=358) OR
(adr_dep=72 AND adr_com=359) OR
(adr_dep=72 AND adr_com=360) OR
(adr_dep=72 AND adr_com=361) OR
(adr_dep=72 AND adr_com=362) OR
(adr_dep=72 AND adr_com=363) OR
(adr_dep=72 AND adr_com=364) OR
(adr_dep=72 AND adr_com=366) OR
(adr_dep=72 AND adr_com=367) OR
(adr_dep=72 AND adr_com=368) OR
(adr_dep=72 AND adr_com=369) OR
(adr_dep=72 AND adr_com=370) OR
(adr_dep=72 AND adr_com=372) OR
(adr_dep=72 AND adr_com=373) OR
(adr_dep=72 AND adr_com=374) OR
(adr_dep=72 AND adr_com=375) OR
(adr_dep=72 AND adr_com=376) OR
(adr_dep=72 AND adr_com=377) OR
(adr_dep=72 AND adr_com=378) OR
(adr_dep=72 AND adr_com=379) OR
(adr_dep=72 AND adr_com=380) OR
(adr_dep=72 AND adr_com=381) OR
(adr_dep=72 AND adr_com=382) OR
(adr_dep=72 AND adr_com=383) OR
(adr_dep=72 AND adr_com=384) OR
(adr_dep=72 AND adr_com=385) OR
(adr_dep=72 AND adr_com=386) OR
(adr_dep=79 AND adr_com=002) OR
(adr_dep=79 AND adr_com=005) OR
(adr_dep=79 AND adr_com=008) OR
(adr_dep=79 AND adr_com=013) OR
(adr_dep=79 AND adr_com=014) OR
(adr_dep=79 AND adr_com=016) OR
(adr_dep=79 AND adr_com=019) OR
(adr_dep=79 AND adr_com=022) OR
(adr_dep=79 AND adr_com=025) OR
(adr_dep=79 AND adr_com=029) OR
(adr_dep=79 AND adr_com=037) OR
(adr_dep=79 AND adr_com=038) OR
(adr_dep=79 AND adr_com=043) OR
(adr_dep=79 AND adr_com=044) OR
(adr_dep=79 AND adr_com=047) OR
(adr_dep=79 AND adr_com=049) OR
(adr_dep=79 AND adr_com=050) OR
(adr_dep=79 AND adr_com=051) OR
(adr_dep=79 AND adr_com=053) OR
(adr_dep=79 AND adr_com=054) OR
(adr_dep=79 AND adr_com=056) OR
(adr_dep=79 AND adr_com=060) OR
(adr_dep=79 AND adr_com=062) OR
(adr_dep=79 AND adr_com=063) OR
(adr_dep=79 AND adr_com=068) OR
(adr_dep=79 AND adr_com=069) OR
(adr_dep=79 AND adr_com=071) OR
(adr_dep=79 AND adr_com=072) OR
(adr_dep=79 AND adr_com=076) OR
(adr_dep=79 AND adr_com=079) OR
(adr_dep=79 AND adr_com=080) OR
(adr_dep=79 AND adr_com=088) OR
(adr_dep=79 AND adr_com=089) OR
(adr_dep=79 AND adr_com=091) OR
(adr_dep=79 AND adr_com=094) OR
(adr_dep=79 AND adr_com=095) OR
(adr_dep=79 AND adr_com=096) OR
(adr_dep=79 AND adr_com=099) OR
(adr_dep=79 AND adr_com=102) OR
(adr_dep=79 AND adr_com=103) OR
(adr_dep=79 AND adr_com=105) OR
(adr_dep=79 AND adr_com=108) OR
(adr_dep=79 AND adr_com=113) OR
(adr_dep=79 AND adr_com=116) OR
(adr_dep=79 AND adr_com=118) OR
(adr_dep=79 AND adr_com=120) OR
(adr_dep=79 AND adr_com=123) OR
(adr_dep=79 AND adr_com=124) OR
(adr_dep=79 AND adr_com=131) OR
(adr_dep=79 AND adr_com=132) OR
(adr_dep=79 AND adr_com=134) OR
(adr_dep=79 AND adr_com=135) OR
(adr_dep=79 AND adr_com=141) OR
(adr_dep=79 AND adr_com=145) OR
(adr_dep=79 AND adr_com=147) OR
(adr_dep=79 AND adr_com=149) OR
(adr_dep=79 AND adr_com=156) OR
(adr_dep=79 AND adr_com=157) OR
(adr_dep=79 AND adr_com=159) OR
(adr_dep=79 AND adr_com=161) OR
(adr_dep=79 AND adr_com=165) OR
(adr_dep=79 AND adr_com=167) OR
(adr_dep=79 AND adr_com=168) OR
(adr_dep=79 AND adr_com=171) OR
(adr_dep=79 AND adr_com=176) OR
(adr_dep=79 AND adr_com=177) OR
(adr_dep=79 AND adr_com=178) OR
(adr_dep=79 AND adr_com=179) OR
(adr_dep=79 AND adr_com=183) OR
(adr_dep=79 AND adr_com=187) OR
(adr_dep=79 AND adr_com=190) OR
(adr_dep=79 AND adr_com=195) OR
(adr_dep=79 AND adr_com=196) OR
(adr_dep=79 AND adr_com=197) OR
(adr_dep=79 AND adr_com=202) OR
(adr_dep=79 AND adr_com=203) OR
(adr_dep=79 AND adr_com=205) OR
(adr_dep=79 AND adr_com=207) OR
(adr_dep=79 AND adr_com=208) OR
(adr_dep=79 AND adr_com=209) OR
(adr_dep=79 AND adr_com=210) OR
(adr_dep=79 AND adr_com=213) OR
(adr_dep=79 AND adr_com=215) OR
(adr_dep=79 AND adr_com=218) OR
(adr_dep=79 AND adr_com=222) OR
(adr_dep=79 AND adr_com=230) OR
(adr_dep=79 AND adr_com=236) OR
(adr_dep=79 AND adr_com=238) OR
(adr_dep=79 AND adr_com=239) OR
(adr_dep=79 AND adr_com=242) OR
(adr_dep=79 AND adr_com=243) OR
(adr_dep=79 AND adr_com=244) OR
(adr_dep=79 AND adr_com=250) OR
(adr_dep=79 AND adr_com=252) OR
(adr_dep=79 AND adr_com=255) OR
(adr_dep=79 AND adr_com=256) OR
(adr_dep=79 AND adr_com=258) OR
(adr_dep=79 AND adr_com=259) OR
(adr_dep=79 AND adr_com=260) OR
(adr_dep=79 AND adr_com=261) OR
(adr_dep=79 AND adr_com=265) OR
(adr_dep=79 AND adr_com=268) OR
(adr_dep=79 AND adr_com=274) OR
(adr_dep=79 AND adr_com=277) OR
(adr_dep=79 AND adr_com=278) OR
(adr_dep=79 AND adr_com=280) OR
(adr_dep=79 AND adr_com=289) OR
(adr_dep=79 AND adr_com=292) OR
(adr_dep=79 AND adr_com=297) OR
(adr_dep=79 AND adr_com=299) OR
(adr_dep=79 AND adr_com=300) OR
(adr_dep=79 AND adr_com=305) OR
(adr_dep=79 AND adr_com=306) OR
(adr_dep=79 AND adr_com=318) OR
(adr_dep=79 AND adr_com=321) OR
(adr_dep=79 AND adr_com=322) OR
(adr_dep=79 AND adr_com=325) OR
(adr_dep=79 AND adr_com=326) OR
(adr_dep=79 AND adr_com=329) OR
(adr_dep=79 AND adr_com=331) OR
(adr_dep=79 AND adr_com=332) OR
(adr_dep=79 AND adr_com=333) OR
(adr_dep=79 AND adr_com=336) OR
(adr_dep=79 AND adr_com=338) OR
(adr_dep=79 AND adr_com=339) OR
(adr_dep=79 AND adr_com=340) OR
(adr_dep=79 AND adr_com=341) OR
(adr_dep=79 AND adr_com=347) OR
(adr_dep=79 AND adr_com=356) OR
(adr_dep=79 AND adr_com=235) OR
(adr_dep=79 AND adr_com=001) OR
(adr_dep=79 AND adr_com=007) OR
(adr_dep=79 AND adr_com=023) OR
(adr_dep=79 AND adr_com=035) OR
(adr_dep=79 AND adr_com=040) OR
(adr_dep=79 AND adr_com=074) OR
(adr_dep=79 AND adr_com=075) OR
(adr_dep=79 AND adr_com=084) OR
(adr_dep=79 AND adr_com=087) OR
(adr_dep=79 AND adr_com=092) OR
(adr_dep=79 AND adr_com=114) OR
(adr_dep=79 AND adr_com=121) OR
(adr_dep=79 AND adr_com=148) OR
(adr_dep=79 AND adr_com=163) OR
(adr_dep=79 AND adr_com=172) OR
(adr_dep=79 AND adr_com=175) OR
(adr_dep=79 AND adr_com=188) OR
(adr_dep=79 AND adr_com=201) OR
(adr_dep=79 AND adr_com=212) OR
(adr_dep=79 AND adr_com=225) OR
(adr_dep=79 AND adr_com=226) OR
(adr_dep=79 AND adr_com=264) OR
(adr_dep=79 AND adr_com=267) OR
(adr_dep=79 AND adr_com=285) OR
(adr_dep=79 AND adr_com=286) OR
(adr_dep=79 AND adr_com=301) OR
(adr_dep=79 AND adr_com=307) OR
(adr_dep=79 AND adr_com=311) OR
(adr_dep=79 AND adr_com=313) OR
(adr_dep=79 AND adr_com=316) OR
(adr_dep=79 AND adr_com=342) OR
(adr_dep=79 AND adr_com=345) OR
(adr_dep=79 AND adr_com=354) OR
(adr_dep=86 AND adr_com=001) OR
(adr_dep=86 AND adr_com=002) OR
(adr_dep=86 AND adr_com=003) OR
(adr_dep=86 AND adr_com=004) OR
(adr_dep=86 AND adr_com=005) OR
(adr_dep=86 AND adr_com=006) OR
(adr_dep=86 AND adr_com=007) OR
(adr_dep=86 AND adr_com=008) OR
(adr_dep=86 AND adr_com=009) OR
(adr_dep=86 AND adr_com=010) OR
(adr_dep=86 AND adr_com=011) OR
(adr_dep=86 AND adr_com=013) OR
(adr_dep=86 AND adr_com=014) OR
(adr_dep=86 AND adr_com=015) OR
(adr_dep=86 AND adr_com=016) OR
(adr_dep=86 AND adr_com=017) OR
(adr_dep=86 AND adr_com=018) OR
(adr_dep=86 AND adr_com=019) OR
(adr_dep=86 AND adr_com=020) OR
(adr_dep=86 AND adr_com=021) OR
(adr_dep=86 AND adr_com=022) OR
(adr_dep=86 AND adr_com=023) OR
(adr_dep=86 AND adr_com=024) OR
(adr_dep=86 AND adr_com=025) OR
(adr_dep=86 AND adr_com=026) OR
(adr_dep=86 AND adr_com=027) OR
(adr_dep=86 AND adr_com=028) OR
(adr_dep=86 AND adr_com=030) OR
(adr_dep=86 AND adr_com=031) OR
(adr_dep=86 AND adr_com=032) OR
(adr_dep=86 AND adr_com=034) OR
(adr_dep=86 AND adr_com=035) OR
(adr_dep=86 AND adr_com=036) OR
(adr_dep=86 AND adr_com=037) OR
(adr_dep=86 AND adr_com=038) OR
(adr_dep=86 AND adr_com=040) OR
(adr_dep=86 AND adr_com=041) OR
(adr_dep=86 AND adr_com=042) OR
(adr_dep=86 AND adr_com=043) OR
(adr_dep=86 AND adr_com=044) OR
(adr_dep=86 AND adr_com=045) OR
(adr_dep=86 AND adr_com=046) OR
(adr_dep=86 AND adr_com=047) OR
(adr_dep=86 AND adr_com=048) OR
(adr_dep=86 AND adr_com=049) OR
(adr_dep=86 AND adr_com=050) OR
(adr_dep=86 AND adr_com=052) OR
(adr_dep=86 AND adr_com=053) OR
(adr_dep=86 AND adr_com=056) OR
(adr_dep=86 AND adr_com=058) OR
(adr_dep=86 AND adr_com=059) OR
(adr_dep=86 AND adr_com=060) OR
(adr_dep=86 AND adr_com=062) OR
(adr_dep=86 AND adr_com=064) OR
(adr_dep=86 AND adr_com=065) OR
(adr_dep=86 AND adr_com=066) OR
(adr_dep=86 AND adr_com=067) OR
(adr_dep=86 AND adr_com=069) OR
(adr_dep=86 AND adr_com=070) OR
(adr_dep=86 AND adr_com=071) OR
(adr_dep=86 AND adr_com=072) OR
(adr_dep=86 AND adr_com=073) OR
(adr_dep=86 AND adr_com=074) OR
(adr_dep=86 AND adr_com=075) OR
(adr_dep=86 AND adr_com=076) OR
(adr_dep=86 AND adr_com=077) OR
(adr_dep=86 AND adr_com=079) OR
(adr_dep=86 AND adr_com=080) OR
(adr_dep=86 AND adr_com=081) OR
(adr_dep=86 AND adr_com=082) OR
(adr_dep=86 AND adr_com=083) OR
(adr_dep=86 AND adr_com=084) OR
(adr_dep=86 AND adr_com=085) OR
(adr_dep=86 AND adr_com=086) OR
(adr_dep=86 AND adr_com=087) OR
(adr_dep=86 AND adr_com=088) OR
(adr_dep=86 AND adr_com=089) OR
(adr_dep=86 AND adr_com=090) OR
(adr_dep=86 AND adr_com=091) OR
(adr_dep=86 AND adr_com=092) OR
(adr_dep=86 AND adr_com=093) OR
(adr_dep=86 AND adr_com=094) OR
(adr_dep=86 AND adr_com=095) OR
(adr_dep=86 AND adr_com=096) OR
(adr_dep=86 AND adr_com=097) OR
(adr_dep=86 AND adr_com=098) OR
(adr_dep=86 AND adr_com=099) OR
(adr_dep=86 AND adr_com=100) OR
(adr_dep=86 AND adr_com=102) OR
(adr_dep=86 AND adr_com=103) OR
(adr_dep=86 AND adr_com=105) OR
(adr_dep=86 AND adr_com=106) OR
(adr_dep=86 AND adr_com=107) OR
(adr_dep=86 AND adr_com=108) OR
(adr_dep=86 AND adr_com=109) OR
(adr_dep=86 AND adr_com=110) OR
(adr_dep=86 AND adr_com=111) OR
(adr_dep=86 AND adr_com=112) OR
(adr_dep=86 AND adr_com=113) OR
(adr_dep=86 AND adr_com=114) OR
(adr_dep=86 AND adr_com=115) OR
(adr_dep=86 AND adr_com=116) OR
(adr_dep=86 AND adr_com=117) OR
(adr_dep=86 AND adr_com=118) OR
(adr_dep=86 AND adr_com=119) OR
(adr_dep=86 AND adr_com=120) OR
(adr_dep=86 AND adr_com=121) OR
(adr_dep=86 AND adr_com=122) OR
(adr_dep=86 AND adr_com=123) OR
(adr_dep=86 AND adr_com=124) OR
(adr_dep=86 AND adr_com=125) OR
(adr_dep=86 AND adr_com=126) OR
(adr_dep=86 AND adr_com=127) OR
(adr_dep=86 AND adr_com=128) OR
(adr_dep=86 AND adr_com=129) OR
(adr_dep=86 AND adr_com=130) OR
(adr_dep=86 AND adr_com=131) OR
(adr_dep=86 AND adr_com=132) OR
(adr_dep=86 AND adr_com=133) OR
(adr_dep=86 AND adr_com=135) OR
(adr_dep=86 AND adr_com=137) OR
(adr_dep=86 AND adr_com=138) OR
(adr_dep=86 AND adr_com=139) OR
(adr_dep=86 AND adr_com=140) OR
(adr_dep=86 AND adr_com=141) OR
(adr_dep=86 AND adr_com=142) OR
(adr_dep=86 AND adr_com=143) OR
(adr_dep=86 AND adr_com=144) OR
(adr_dep=86 AND adr_com=145) OR
(adr_dep=86 AND adr_com=146) OR
(adr_dep=86 AND adr_com=147) OR
(adr_dep=86 AND adr_com=148) OR
(adr_dep=86 AND adr_com=149) OR
(adr_dep=86 AND adr_com=150) OR
(adr_dep=86 AND adr_com=151) OR
(adr_dep=86 AND adr_com=152) OR
(adr_dep=86 AND adr_com=153) OR
(adr_dep=86 AND adr_com=154) OR
(adr_dep=86 AND adr_com=156) OR
(adr_dep=86 AND adr_com=157) OR
(adr_dep=86 AND adr_com=158) OR
(adr_dep=86 AND adr_com=159) OR
(adr_dep=86 AND adr_com=160) OR
(adr_dep=86 AND adr_com=161) OR
(adr_dep=86 AND adr_com=162) OR
(adr_dep=86 AND adr_com=163) OR
(adr_dep=86 AND adr_com=164) OR
(adr_dep=86 AND adr_com=165) OR
(adr_dep=86 AND adr_com=166) OR
(adr_dep=86 AND adr_com=167) OR
(adr_dep=86 AND adr_com=169) OR
(adr_dep=86 AND adr_com=170) OR
(adr_dep=86 AND adr_com=171) OR
(adr_dep=86 AND adr_com=172) OR
(adr_dep=86 AND adr_com=173) OR
(adr_dep=86 AND adr_com=174) OR
(adr_dep=86 AND adr_com=175) OR
(adr_dep=86 AND adr_com=176) OR
(adr_dep=86 AND adr_com=177) OR
(adr_dep=86 AND adr_com=178) OR
(adr_dep=86 AND adr_com=180) OR
(adr_dep=86 AND adr_com=181) OR
(adr_dep=86 AND adr_com=182) OR
(adr_dep=86 AND adr_com=183) OR
(adr_dep=86 AND adr_com=184) OR
(adr_dep=86 AND adr_com=186) OR
(adr_dep=86 AND adr_com=187) OR
(adr_dep=86 AND adr_com=188) OR
(adr_dep=86 AND adr_com=189) OR
(adr_dep=86 AND adr_com=190) OR
(adr_dep=86 AND adr_com=191) OR
(adr_dep=86 AND adr_com=192) OR
(adr_dep=86 AND adr_com=193) OR
(adr_dep=86 AND adr_com=194) OR
(adr_dep=86 AND adr_com=195) OR
(adr_dep=86 AND adr_com=196) OR
(adr_dep=86 AND adr_com=197) OR
(adr_dep=86 AND adr_com=198) OR
(adr_dep=86 AND adr_com=200) OR
(adr_dep=86 AND adr_com=201) OR
(adr_dep=86 AND adr_com=202) OR
(adr_dep=86 AND adr_com=203) OR
(adr_dep=86 AND adr_com=204) OR
(adr_dep=86 AND adr_com=205) OR
(adr_dep=86 AND adr_com=206) OR
(adr_dep=86 AND adr_com=207) OR
(adr_dep=86 AND adr_com=208) OR
(adr_dep=86 AND adr_com=209) OR
(adr_dep=86 AND adr_com=210) OR
(adr_dep=86 AND adr_com=214) OR
(adr_dep=86 AND adr_com=217) OR
(adr_dep=86 AND adr_com=219) OR
(adr_dep=86 AND adr_com=221) OR
(adr_dep=86 AND adr_com=222) OR
(adr_dep=86 AND adr_com=223) OR
(adr_dep=86 AND adr_com=224) OR
(adr_dep=86 AND adr_com=225) OR
(adr_dep=86 AND adr_com=226) OR
(adr_dep=86 AND adr_com=227) OR
(adr_dep=86 AND adr_com=228) OR
(adr_dep=86 AND adr_com=229) OR
(adr_dep=86 AND adr_com=230) OR
(adr_dep=86 AND adr_com=233) OR
(adr_dep=86 AND adr_com=234) OR
(adr_dep=86 AND adr_com=235) OR
(adr_dep=86 AND adr_com=236) OR
(adr_dep=86 AND adr_com=239) OR
(adr_dep=86 AND adr_com=241) OR
(adr_dep=86 AND adr_com=242) OR
(adr_dep=86 AND adr_com=245) OR
(adr_dep=86 AND adr_com=246) OR
(adr_dep=86 AND adr_com=248) OR
(adr_dep=86 AND adr_com=249) OR
(adr_dep=86 AND adr_com=250) OR
(adr_dep=86 AND adr_com=252) OR
(adr_dep=86 AND adr_com=253) OR
(adr_dep=86 AND adr_com=254) OR
(adr_dep=86 AND adr_com=256) OR
(adr_dep=86 AND adr_com=257) OR
(adr_dep=86 AND adr_com=258) OR
(adr_dep=86 AND adr_com=259) OR
(adr_dep=86 AND adr_com=260) OR
(adr_dep=86 AND adr_com=261) OR
(adr_dep=86 AND adr_com=262) OR
(adr_dep=86 AND adr_com=263) OR
(adr_dep=86 AND adr_com=264) OR
(adr_dep=86 AND adr_com=265) OR
(adr_dep=86 AND adr_com=268) OR
(adr_dep=86 AND adr_com=269) OR
(adr_dep=86 AND adr_com=270) OR
(adr_dep=86 AND adr_com=271) OR
(adr_dep=86 AND adr_com=272) OR
(adr_dep=86 AND adr_com=273) OR
(adr_dep=86 AND adr_com=274) OR
(adr_dep=86 AND adr_com=275) OR
(adr_dep=86 AND adr_com=276) OR
(adr_dep=86 AND adr_com=277) OR
(adr_dep=86 AND adr_com=278) OR
(adr_dep=86 AND adr_com=279) OR
(adr_dep=86 AND adr_com=280) OR
(adr_dep=86 AND adr_com=281) OR
(adr_dep=86 AND adr_com=284) OR
(adr_dep=86 AND adr_com=285) OR
(adr_dep=86 AND adr_com=286) OR
(adr_dep=86 AND adr_com=287) OR
(adr_dep=86 AND adr_com=288) OR
(adr_dep=86 AND adr_com=289) OR
(adr_dep=86 AND adr_com=290) OR
(adr_dep=86 AND adr_com=291) OR
(adr_dep=86 AND adr_com=292) OR
(adr_dep=86 AND adr_com=293) OR
(adr_dep=86 AND adr_com=294) OR
(adr_dep=86 AND adr_com=296) OR
(adr_dep=86 AND adr_com=297) OR
(adr_dep=86 AND adr_com=298) OR
(adr_dep=86 AND adr_com=299) OR
(adr_dep=86 AND adr_com=300) OR
(adr_dep=86 AND adr_com=218) OR
(adr_dep=86 AND adr_com=029) OR
(adr_dep=86 AND adr_com=039) OR
(adr_dep=86 AND adr_com=054) OR
(adr_dep=86 AND adr_com=055) OR
(adr_dep=86 AND adr_com=061) OR
(adr_dep=86 AND adr_com=068) OR
(adr_dep=86 AND adr_com=211) OR
(adr_dep=86 AND adr_com=213) OR
(adr_dep=86 AND adr_com=244) OR
(adr_dep=86 AND adr_com=255) OR
(adr_dep=87 AND adr_com=027) OR
(adr_dep=87 AND adr_com=029) OR
(adr_dep=87 AND adr_com=032) OR
(adr_dep=87 AND adr_com=034) OR
(adr_dep=87 AND adr_com=036) OR
(adr_dep=87 AND adr_com=039) OR
(adr_dep=87 AND adr_com=044) OR
(adr_dep=87 AND adr_com=051) OR
(adr_dep=87 AND adr_com=077) OR
(adr_dep=87 AND adr_com=088) OR
(adr_dep=87 AND adr_com=106) OR
(adr_dep=87 AND adr_com=111) OR
(adr_dep=87 AND adr_com=112) OR
(adr_dep=87 AND adr_com=120) OR
(adr_dep=87 AND adr_com=124) OR
(adr_dep=87 AND adr_com=127) OR
(adr_dep=87 AND adr_com=137) OR
(adr_dep=87 AND adr_com=146) OR
(adr_dep=87 AND adr_com=150) OR
(adr_dep=87 AND adr_com=176) OR
(adr_dep=87 AND adr_com=193) OR
(adr_dep=87 AND adr_com=199) OR
(adr_dep=87 AND adr_com=204) OR
(adr_dep=87 AND adr_com=001) OR
(adr_dep=87 AND adr_com=002) OR
(adr_dep=87 AND adr_com=003) OR
(adr_dep=87 AND adr_com=004) OR
(adr_dep=87 AND adr_com=005) OR
(adr_dep=87 AND adr_com=006) OR
(adr_dep=87 AND adr_com=007) OR
(adr_dep=87 AND adr_com=008) OR
(adr_dep=87 AND adr_com=009) OR
(adr_dep=87 AND adr_com=011) OR
(adr_dep=87 AND adr_com=012) OR
(adr_dep=87 AND adr_com=013) OR
(adr_dep=87 AND adr_com=014) OR
(adr_dep=87 AND adr_com=015) OR
(adr_dep=87 AND adr_com=016) OR
(adr_dep=87 AND adr_com=017) OR
(adr_dep=87 AND adr_com=018) OR
(adr_dep=87 AND adr_com=019) OR
(adr_dep=87 AND adr_com=020) OR
(adr_dep=87 AND adr_com=021) OR
(adr_dep=87 AND adr_com=022) OR
(adr_dep=87 AND adr_com=023) OR
(adr_dep=87 AND adr_com=024) OR
(adr_dep=87 AND adr_com=025) OR
(adr_dep=87 AND adr_com=026) OR
(adr_dep=87 AND adr_com=028) OR
(adr_dep=87 AND adr_com=030) OR
(adr_dep=87 AND adr_com=033) OR
(adr_dep=87 AND adr_com=035) OR
(adr_dep=87 AND adr_com=038) OR
(adr_dep=87 AND adr_com=040) OR
(adr_dep=87 AND adr_com=041) OR
(adr_dep=87 AND adr_com=042) OR
(adr_dep=87 AND adr_com=043) OR
(adr_dep=87 AND adr_com=045) OR
(adr_dep=87 AND adr_com=046) OR
(adr_dep=87 AND adr_com=047) OR
(adr_dep=87 AND adr_com=048) OR
(adr_dep=87 AND adr_com=050) OR
(adr_dep=87 AND adr_com=052) OR
(adr_dep=87 AND adr_com=053) OR
(adr_dep=87 AND adr_com=055) OR
(adr_dep=87 AND adr_com=056) OR
(adr_dep=87 AND adr_com=057) OR
(adr_dep=87 AND adr_com=058) OR
(adr_dep=87 AND adr_com=059) OR
(adr_dep=87 AND adr_com=061) OR
(adr_dep=87 AND adr_com=062) OR
(adr_dep=87 AND adr_com=063) OR
(adr_dep=87 AND adr_com=064) OR
(adr_dep=87 AND adr_com=065) OR
(adr_dep=87 AND adr_com=066) OR
(adr_dep=87 AND adr_com=067) OR
(adr_dep=87 AND adr_com=068) OR
(adr_dep=87 AND adr_com=069) OR
(adr_dep=87 AND adr_com=070) OR
(adr_dep=87 AND adr_com=072) OR
(adr_dep=87 AND adr_com=073) OR
(adr_dep=87 AND adr_com=074) OR
(adr_dep=87 AND adr_com=075) OR
(adr_dep=87 AND adr_com=076) OR
(adr_dep=87 AND adr_com=078) OR
(adr_dep=87 AND adr_com=079) OR
(adr_dep=87 AND adr_com=080) OR
(adr_dep=87 AND adr_com=081) OR
(adr_dep=87 AND adr_com=083) OR
(adr_dep=87 AND adr_com=084) OR
(adr_dep=87 AND adr_com=085) OR
(adr_dep=87 AND adr_com=086) OR
(adr_dep=87 AND adr_com=087) OR
(adr_dep=87 AND adr_com=089) OR
(adr_dep=87 AND adr_com=090) OR
(adr_dep=87 AND adr_com=093) OR
(adr_dep=87 AND adr_com=094) OR
(adr_dep=87 AND adr_com=097) OR
(adr_dep=87 AND adr_com=099) OR
(adr_dep=87 AND adr_com=100) OR
(adr_dep=87 AND adr_com=101) OR
(adr_dep=87 AND adr_com=103) OR
(adr_dep=87 AND adr_com=104) OR
(adr_dep=87 AND adr_com=105) OR
(adr_dep=87 AND adr_com=107) OR
(adr_dep=87 AND adr_com=108) OR
(adr_dep=87 AND adr_com=109) OR
(adr_dep=87 AND adr_com=110) OR
(adr_dep=87 AND adr_com=113) OR
(adr_dep=87 AND adr_com=114) OR
(adr_dep=87 AND adr_com=116) OR
(adr_dep=87 AND adr_com=117) OR
(adr_dep=87 AND adr_com=118) OR
(adr_dep=87 AND adr_com=119) OR
(adr_dep=87 AND adr_com=121) OR
(adr_dep=87 AND adr_com=122) OR
(adr_dep=87 AND adr_com=123) OR
(adr_dep=87 AND adr_com=125) OR
(adr_dep=87 AND adr_com=126) OR
(adr_dep=87 AND adr_com=128) OR
(adr_dep=87 AND adr_com=129) OR
(adr_dep=87 AND adr_com=130) OR
(adr_dep=87 AND adr_com=131) OR
(adr_dep=87 AND adr_com=132) OR
(adr_dep=87 AND adr_com=133) OR
(adr_dep=87 AND adr_com=134) OR
(adr_dep=87 AND adr_com=135) OR
(adr_dep=87 AND adr_com=136) OR
(adr_dep=87 AND adr_com=138) OR
(adr_dep=87 AND adr_com=139) OR
(adr_dep=87 AND adr_com=140) OR
(adr_dep=87 AND adr_com=141) OR
(adr_dep=87 AND adr_com=142) OR
(adr_dep=87 AND adr_com=143) OR
(adr_dep=87 AND adr_com=144) OR
(adr_dep=87 AND adr_com=145) OR
(adr_dep=87 AND adr_com=147) OR
(adr_dep=87 AND adr_com=148) OR
(adr_dep=87 AND adr_com=149) OR
(adr_dep=87 AND adr_com=151) OR
(adr_dep=87 AND adr_com=152) OR
(adr_dep=87 AND adr_com=153) OR
(adr_dep=87 AND adr_com=154) OR
(adr_dep=87 AND adr_com=155) OR
(adr_dep=87 AND adr_com=156) OR
(adr_dep=87 AND adr_com=157) OR
(adr_dep=87 AND adr_com=158) OR
(adr_dep=87 AND adr_com=159) OR
(adr_dep=87 AND adr_com=160) OR
(adr_dep=87 AND adr_com=161) OR
(adr_dep=87 AND adr_com=162) OR
(adr_dep=87 AND adr_com=163) OR
(adr_dep=87 AND adr_com=164) OR
(adr_dep=87 AND adr_com=165) OR
(adr_dep=87 AND adr_com=166) OR
(adr_dep=87 AND adr_com=167) OR
(adr_dep=87 AND adr_com=169) OR
(adr_dep=87 AND adr_com=170) OR
(adr_dep=87 AND adr_com=172) OR
(adr_dep=87 AND adr_com=173) OR
(adr_dep=87 AND adr_com=174) OR
(adr_dep=87 AND adr_com=177) OR
(adr_dep=87 AND adr_com=178) OR
(adr_dep=87 AND adr_com=179) OR
(adr_dep=87 AND adr_com=180) OR
(adr_dep=87 AND adr_com=181) OR
(adr_dep=87 AND adr_com=182) OR
(adr_dep=87 AND adr_com=183) OR
(adr_dep=87 AND adr_com=184) OR
(adr_dep=87 AND adr_com=185) OR
(adr_dep=87 AND adr_com=186) OR
(adr_dep=87 AND adr_com=188) OR
(adr_dep=87 AND adr_com=190) OR
(adr_dep=87 AND adr_com=191) OR
(adr_dep=87 AND adr_com=192) OR
(adr_dep=87 AND adr_com=194) OR
(adr_dep=87 AND adr_com=195) OR
(adr_dep=87 AND adr_com=196) OR
(adr_dep=87 AND adr_com=197) OR
(adr_dep=87 AND adr_com=198) OR
(adr_dep=87 AND adr_com=200) OR
(adr_dep=87 AND adr_com=201) OR
(adr_dep=87 AND adr_com=202) OR
(adr_dep=87 AND adr_com=203) OR
(adr_dep=87 AND adr_com=205) OR
(adr_dep=87 AND adr_com=206) ) AND adr_libVoie<>''", false, MYSQL_ASSOC, true);
// $nbLoaded=$iDb->select('tmp.epl2', "siren, nic, x_93, y_93", "lat='' ORDER BY siren DESC", false, MYSQL_ASSOC, true);
echo date ('Y/m/d - H:i:s')." - Il y a $nbLoaded adresses <20> mettre <20> jour...".EOL;
// $fp=fopen('./etablissements_epl.csv', 'w');
// die(mysql_error().EOL);
// $str="siren\tnic\tsiege\traisonSociale\tenseigne\tsigle\tnumVoie\tindRep\ttypeVoie\tlibVoie\tadrComp\tcodePostal\tVille\tcodeComInsee\ttel\tfj\tape_etab\tape_entrep\teff_etab\tprecis\tx_93\ty_93\tdistance".EOL;//\tdist".EOL;
// fwrite($fp, $str);
while($adr=$iDb->fetch(MYSQL_ASSOC)) {
$nbLignes++;
if (trim($adr['insL7_ETRG'])=='') $pays='France';
else $pays=trim($adr['insL7_ETRG']);
$codeRivoli=$adr['insDEPCOM'].$adr['insCODEVOIE'];
$geo=$imap->geoCodeAdresse($adr['insNUMVOIE'], $adr['insINDREP'], $adr['insTYPVOIE'], $adr['insTYPVOIE'], $adr['insLIBVOIE'], $adr['insCODPOS'], $adr['insLIBCOM'], $pays, $codeRivoli);
echo "$nbLignes/$nbLoaded:".$adr['idFlux'].','.$imap->enCache.':'.$imap->latitudeDec.','.$imap->longitudeDec.' ('.$imap->precision.")\t";
echo $adr['insL4_VOIE'].', '.$adr['insCODPOS'].' '.$adr['insLIBCOM'].', '.$pays. ' => ';
echo $imap->adresseValidee.' ('.$imap->geocodeur.')';
if ($imap->enCache==true) $nbEnCache++;
else {
$nbDistant++;
usleep(100);
}
$precis=$imap->precision;
if ($precis<6) { echo "IMPRECIS".EOL; continue; }
//die($adr['siren'].$adr['nic'].' '.$imap->distance($imap->latitudeDec,$imap->longitudeDec, 48.8880539, 2.3067865)); // 118 RUE DE TOCQUEVILLE
/** @todo Calculer la distance entre chaque ligne de la base de donn<6E>es
* Prendre la + courte
**/
$latitude=$imap->latitudeDec;
$longitude=$imap->longitudeDec;
$lambert=geos2lambert93($latitude,$longitude);
$x93=round($lambert['x_93']);
$y93=round($lambert['y_93']);
if ($x93<280343 || $x93>830707 || $y93<6376956 || $y93>6857117) { echo "HORS ZONE".EOL;continue;}
echo EOL;
/*
$distMin=9999999999999;
$codMin='ZZZZZZZZ';
foreach($tabAdr as $id=>$tabAd) {
$dist=round($imap->distanceLambert($tabAd['x93'],$tabAd['y93'],$x93,$y93));
if ($dist<$distMin) {
$distMin=$dist;
$codMin=$tabAd['cod'];
}
}
/*$str=//$adr['id']."\t".
$adr['siren']."\t".
$adr['nic']."\t".
$adr['siege']."\t".
$adr['raisonSociale']."\t".
$adr['enseigne']."\t".
$adr['sigle']."\t".
$adr['insNUMVOIE']."\t".
$adr['insINDREP']."\t".
$adr['insTYPVOIE']."\t".
$adr['insLIBVOIE']."\t".
$adr['adr_comp']."\t".
$adr['insCODPOS']."\t".
$adr['insLIBCOM']."\t".
$adr['codeCommune']."\t".
$adr['tel']."\t".
$adr['cj']."\t".
$adr['ape_etab']."\t".
$adr['ape_entrep']."\t".
$adr['eff_etab']."\t$precis\t$x93\t$y93".EOL;//\tNULL".EOL;*/
$siren=$adr['siren'];
$nic=$adr['nic'];
$tabInsert=array( 'siren' => $siren,
'nic' => $nic,
'siege' => $adr['siege'],
'raisonSociale'=> $adr['raisonSociale'],
'enseigne' => $adr['enseigne'],
'sigle' => $adr['sigle'],
'numVoie' => $adr['insNUMVOIE'],
'indRep' => $adr['insINDREP'],
'typeVoie' => $adr['insTYPVOIE'],
'libVoie' => $adr['insLIBVOIE'],
'adrComp' => $adr['adr_comp'],
'codePostal'=> $adr['insCODPOS'],
'Ville' => $adr['insLIBCOM'],
'codeCommune'=>$adr['adr_dep'].$adr['adr_com'],
'tel' => $adr['tel'],
'fj' => $adr['cj'],
'ape_etab' => $adr['ape_etab'],
'ape_entrep'=> $adr['ape_entrep'],
'eff_etab' => $adr['eff_etab'],
'precis' => $precis,
'x_93' => $x93,
'y_93' => $y93,
'lat' => $latitude,
'lon' => $longitude,/*
'dist' => $distMin,
'codeRiviere'=>$codMin*/);
$iDb2->insert('epl2', $tabInsert);
/*echo mysql_error().EOL;
print_r($tabInsert);*/
echo "$nbLignes/$nbLoaded - $siren $nic : $x93,$y93 ($precis)".EOL;// $distMin m de $codMin".EOL;
//die();
// Codes Lambert 93 Coordonn<6E>es X et Y du Lambert 93
//fwrite($fp, $str);
}
$pct=round($nbEnCache/$nbLignes,3)*100;
$message='Le '.date('d/m/Y H:i:s')." : $nbLoaded lignes <20> g<>ocoder".EOL;
$message.='Le '.date('d/m/Y H:i:s')." : $nbLignes adresses g<>ocod<6F>es du $idFlux au $idFluxFin dont $nbDistant par acc<63>s partenaire ($nbEnCache adresses en cache soit $pct %)".EOL;
sendMail('webmaster@scores-decisions.com', 'ylenaour@scores-decisions.com', "Fin du traitement de g<>ocodage ($idFlux)", $message);
die();
?>
Reference in New Issue View Git Blame Copy Permalink