field_staff_manager['und'])>0 && isset($node->field_staff_manager['und'])) { foreach ($node->field_staff_manager['und'] as $man) { $m = node_load($man['nid']); if ($m && $m->type=='staff_manager'){ $finded_stafs++; $managers .= ''; $managers .= '
'; $managers .= '
' .(($m->field_staff_prefix['und'][0]['value']!='')?(' '.$m->field_staff_prefix['und'][0]['value']):('')) .(($m->field_lead_first_name['und'][0]['value']!='')?(' '.$m->field_lead_first_name['und'][0]['value']):('')) .(($m->field_last_name['und'][0]['value']!='')?(' '.$m->field_last_name['und'][0]['value']):('')) .(($m->field_lead_sufix['und'][0]['value']!='')?(' '.$m->field_lead_sufix['und'][0]['value']):('')) .(($m->field_professional_designation['und'][0]['value']!='' || $m->field_lead_organization['und'][0]['value']!='' || $m->field_lead_job_title['und'][0]['value']!='')?(' ('):('')) .(($m->field_professional_designation['und'][0]['value']!='')?(''.$m->field_professional_designation['und'][0]['value']):('')) .(($m->field_lead_organization['und'][0]['value']!='')?((($m->field_professional_designation['und'][0]['value']!='')?(', '):('')).$m->field_lead_organization['und'][0]['value']):('')) .(($m->field_lead_job_title['und'][0]['value']!='')?((($m->field_professional_designation['und'][0]['value']!='' || $m->field_professional_designation['und'][0]['value']!='')?(', '):('')).$m->field_lead_job_title['und'][0]['value']):('')) .(($m->field_professional_designation['und'][0]['value']!='' || $m->field_lead_organization['und'][0]['value']!='' || $m->field_lead_job_title['und'][0]['value']!='')?(')'):('')) .'
'; $managers .= (($m->field_lead_website_url['und'][0]['value']!='')?('
'.$m->field_lead_website_url['und'][0]['value'].'
'):('')) .(($m->field_lead_email_address['und'][0]['email']!='')?('
'.$m->field_lead_email_address['und'][0]['email'].'
'):('')) .(($m->field_lead_phone_number['und'][0]['value']!='')?('
'.$m->field_lead_phone_number['und'][0]['value'].'
'):('')) .(($m->field_lead_cell_phone_number['und'][0]['value']!='')?('
'.$m->field_lead_cell_phone_number['und'][0]['value'].'
'):('')) .(($m->field_lead_fax_number['und'][0]['value']!='')?('
'.$m->field_lead_fax_number['und'][0]['value'].'
'):('')); $managers .= '
'; } } } if ($finded_stafs==0) { $type = 'staff_manager'; $row = db_query('SELECT nid FROM {node} WHERE type = :type', array(':type' => $type))->fetchAll(); foreach($row as $r) { $m = node_load($r->nid); if ($m->field_is_main['und'][0]['value']==1) { $managers .= ''; $managers .= '
'; $managers .= '
' .(($m->field_staff_prefix['und'][0]['value']!='')?(' '.$m->field_staff_prefix['und'][0]['value']):('')) .(($m->field_lead_first_name['und'][0]['value']!='')?(' '.$m->field_lead_first_name['und'][0]['value']):('')) .(($m->field_last_name['und'][0]['value']!='')?(' '.$m->field_last_name['und'][0]['value']):('')) .(($m->field_lead_sufix['und'][0]['value']!='')?(' '.$m->field_lead_sufix['und'][0]['value']):('')) .(($m->field_professional_designation['und'][0]['value']!='' || $m->field_lead_organization['und'][0]['value']!='' || $m->field_lead_job_title['und'][0]['value']!='')?(' ('):('')) .(($m->field_professional_designation['und'][0]['value']!='')?(''.$m->field_professional_designation['und'][0]['value']):('')) .(($m->field_lead_organization['und'][0]['value']!='')?((($m->field_professional_designation['und'][0]['value']!='')?(', '):('')).$m->field_lead_organization['und'][0]['value']):('')) .(($m->field_lead_job_title['und'][0]['value']!='')?((($m->field_professional_designation['und'][0]['value']!='' || $m->field_professional_designation['und'][0]['value']!='')?(', '):('')).$m->field_lead_job_title['und'][0]['value']):('')) .(($m->field_professional_designation['und'][0]['value']!='' || $m->field_lead_organization['und'][0]['value']!='' || $m->field_lead_job_title['und'][0]['value']!='')?(')'):('')) .'
'; $managers .= (($m->field_lead_website_url['und'][0]['value']!='')?('
'.$m->field_lead_website_url['und'][0]['value'].'
'):('')) .(($m->field_lead_email_address['und'][0]['email']!='')?('
'.$m->field_lead_email_address['und'][0]['email'].'
'):('')) .(($m->field_lead_phone_number['und'][0]['value']!='')?('
'.$m->field_lead_phone_number['und'][0]['value'].'
'):('')) .(($m->field_lead_cell_phone_number['und'][0]['value']!='')?('
'.$m->field_lead_cell_phone_number['und'][0]['value'].'
'):('')) .(($m->field_lead_fax_number['und'][0]['value']!='')?('
'.$m->field_lead_fax_number['und'][0]['value'].'
'):('')); $managers .= '
'; } } } ?>
$type))->fetchAll(); $managers = ''; foreach($row as $r) { $m = node_load($r->nid); if ($m->field_is_main['und'][0]['value']==1) { $managers .= ''; $managers .= ''; $managers .= ''; $managers .= ''; $managers .= ''; $managers .= ''; $managers .= (($m->field_lead_cell_phone_number['und'][0]['value']!='')?(''):('')); $managers .= (($m->field_lead_fax_number['und'][0]['value']!='')?(''):('')); $managers .='
' .(($m->field_staff_prefix['und'][0]['value']!='')?(' '.$m->field_staff_prefix['und'][0]['value']):('')) .(($m->field_lead_first_name['und'][0]['value']!='')?(' '.$m->field_lead_first_name['und'][0]['value']):('')) .(($m->field_last_name['und'][0]['value']!='')?(' '.$m->field_last_name['und'][0]['value']):('')) .(($m->field_lead_sufix['und'][0]['value']!='')?(' '.$m->field_lead_sufix['und'][0]['value']):('')) .(($m->field_professional_designation['und'][0]['value']!='')?(', '.$m->field_professional_designation['und'][0]['value']):('')) .(($m->field_lead_organization['und'][0]['value']!='')?(', '.$m->field_lead_organization['und'][0]['value']):('')) .(($m->field_lead_job_title['und'][0]['value']!='')?(', '.$m->field_lead_job_title['und'][0]['value']):('')) .'
'.@$m->field_lead_address['und'][0]['street'].' '.@$m->field_lead_address['und'][0]['additional'].'
'.@$m->field_lead_address['und'][0]['city'].', '. @$m->field_lead_address['und'][0]['province_name'].' '. @$m->field_lead_address['und'][0]['postal_code'].'
'.$m->field_lead_website_url['und'][0]['value'].'
'.$m->field_lead_email_address['und'][0]['email'].'
Phone Number: '.$m->field_lead_phone_number['und'][0]['value'].'
Cell Phone Number: '.$m->field_lead_cell_phone_number['und'][0]['value'].'
Fax Number: '.$m->field_lead_fax_number['und'][0]['value'].'
'; } } print ''.$managers.'
'; } ?> type!='proposal') {?>
Home > Tools > Zoning & Sign Code

Zoning & Sign Code

The Zoning & Sign Code serves as a tool to assist with residential, mixed use, commercial and business park developments.

Zoning & Sign Code

Questions on specific projects should be addressed to the City Planning Department by calling 712-279-6103 or via email to jeffhanson@sioux-city.org .