| description:
|
<DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN>Description: All current, active business licenses</SPAN></P><P><SPAN>Process: Data is queried from TRMS, processed to clean up common addressing issues (change "FT LOWELL" to "FORT LOWELL" - street name "1" become "1ST", funny "ÿ" characters are removed etc) and geocoded. Geocoding is a 3 step process: </SPAN></P><P><SPAN>1 - whole table is geocoded to adparcel with a 9.3.1 geocoder (scores of 69 and higher become seperate layer)</SPAN></P><P><SPAN>2 - anything with a score of 68 or below is joined to adparcel based on street #, street direction and street name - those that have a match have their address recalculated based on the full address in adparcel and are geocoded again with the 9.3.1 geocoder (become seperate layer)</SPAN></P><P><SPAN>3 - those from step 2 that do not have a match in adparcel are goecoded to stnetall and everything with a score of 80 or above are exported out as a seperate layer</SPAN></P><P><SPAN>Layers from steps 2 and 3 are appended into layer in step 1 and the original buslic FC has records deleted and the new data appended.</SPAN></P><P><SPAN>Attributes: </SPAN></P><P><SPAN>ACC_NUM: account number</SPAN></P><P><SPAN>ACC_NAME: account name</SPAN></P><P><SPAN>OWN_CODE: ownership code</SPAN></P><P><SPAN>OWN_DESC: ownership description</SPAN></P><P><SPAN>TYPE_CODE: business type code (RRP is RENTAL REAL PROPERTY is a license for renting a building)</SPAN></P><P><SPAN>TYPE_DESC: business type description</SPAN></P><P><SPAN>NAIC_CODE: NORTH AMERICAN INDUSTRY CLASSIFICATION SYSTEM number codes</SPAN></P><P><SPAN>NAIC_DESC: NAICS description</SPAN></P><P><SPAN>LIC_TYPE: SVL (Service License - professional and service businesses, may collect use tax) or PLL (Privilige License</SPAN></P><P><SPAN>License, businesses that collect sales tax)</SPAN></P><P><SPAN>DT_START: start date of business</SPAN></P><P><SPAN>DT_ISSUED: issued date of current business license </SPAN></P><P><SPAN>CITY: Tucson or several astericks with numbers in between indicates multiple addresses</SPAN></P><P><SPAN>STATE: AZ</SPAN></P><P><SPAN>ZIP_CODE: zipcode from TRMS</SPAN></P><P><SPAN>ADD_ORIG: original address from TRMS, including suite/unit number</SPAN></P><P><SPAN>ADD_MATCH: address account matched to (this will not necessary match the ADD_ORIG field)</SPAN></P><P><SPAN>MT: match type, number indicates which geocoding step was used (1 = highest quality match, 3 = lowest quality match)</SPAN></P><P><SPAN>---------------------------------------------------------------------------------------------------------------------------------------------------------------</SPAN></P><P><SPAN>Who: Original TRMS (TAX MANTRA) data query and geoprocessing done by Johanna Kraus - March 2011</SPAN></P><P><SPAN>Maintinance/Update Schedule: Data and geoprocessing are a batch job done weekly.</SPAN></P><P><SPAN>-----------------------------------------------------------------------------------------------------------------------------------------------------------------</SPAN></P><P><SPAN>Known Errors:</SPAN></P><P><SPAN>All locations are approximate. Most data is mapped to existing address points (which are not precise locations),</SPAN></P><P><SPAN>those records that don't have an equivilant address match are approximated along the address range of street. See</SPAN></P><P><SPAN>MT field for more details.</SPAN></P><P><SPAN>Fields for NAICS codes, business types and owner types may be missing data or incorrect.</SPAN></P><P><SPAN>Data layer should not be considered a complete listing of all active businesses in Tucson. </SPAN></P><P><SPAN>Please send spatial errors to GIS_IT@tucsonaz.gov</SPAN></P><P><SPAN>Please send data errors to Tax-License@tucsonaz.gov</SPAN></P></DIV></DIV></DIV> |