Format of the Sign Permit Open data dataset 

permit #            	Last two digits of the calendar year plus              Format is 99 999999          
                           Sequence number generated by IBMS system               
type	      	      Permit type	First party or third party
street#			Address – street number   
street_name		      Address – street name	                               Upper case
street_type		      Address – street type	                               e.g. AVE, ST, DR, BLVD
street_direction	      Direction in which the street runs	                   e.g. E, W, N, S	    
postal			First 3 digits of postal code   
application_date	      Application date – timestamp 
                        Permit application received	                         e.g. 09/07/2010 00:00:00	   
issued_date	            Issued date – timestamp
                        Permit is approved and issued		   
completed_date	      Completed date – timestamp
                        Sign is installed and inspected		   
status	            Current status of application                          e.g. not started, permit issued, refusal notice	   
current_use	            Current use of location where sign is required         e.g. office building, restaurant, retail	   
proposed_use	      Proposed use of location where sign is required 	 e.g. office building, restaurant, retail	   
Total_#_faces	      Number of sign facets	Numeric or blank