Name: BUSLIC

Display Field: ACC_NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

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>

Copyright Text: Published by City of Tucson Information Technology Department, GIS Services

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: 822550.9530839883
YMin: 320143.80872703344
XMax: 1088004.9963910766
YMax: 685648.4596456662
Spatial Reference: 2868  (2868)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [51, 165, 154, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:

• ACC_NUM ( type: esriFieldTypeString, alias: ACC_NUM, length: 50 )
• ACC_NAME ( type: esriFieldTypeString, alias: ACC_NAME, length: 255 )
• NAIC_CODE ( type: esriFieldTypeString, alias: NAIC_CODE, length: 255 )
• NAIC_DESC ( type: esriFieldTypeString, alias: NAIC_DESC, length: 255 )
• LIC_TYPE ( type: esriFieldTypeString, alias: LIC_TYPE, length: 50 )
• DT_START ( type: esriFieldTypeDate, alias: DT_START, length: 8 )
• STREETNUM ( type: esriFieldTypeString, alias: STREETNUM, length: 255 )
• STREETDIR ( type: esriFieldTypeString, alias: STREETDIR, length: 255 )
• STREETNAM ( type: esriFieldTypeString, alias: STREETNAM, length: 255 )
• STREETSUF ( type: esriFieldTypeString, alias: STREETSUF, length: 255 )
• APT ( type: esriFieldTypeString, alias: APT, length: 255 )
• CITY ( type: esriFieldTypeString, alias: CITY, length: 30 )
• STATE ( type: esriFieldTypeString, alias: STATE, length: 30 )
• ZIP_CODE ( type: esriFieldTypeString, alias: ZIP_CODE, length: 11 )
• DATASOURCE ( type: esriFieldTypeString, alias: DATASOURCE, length: 50 )
• LIC_STATUS ( type: esriFieldTypeString, alias: LIC_STATUS, length: 50 )
• FULLADDRESS ( type: esriFieldTypeString, alias: FULLADDRESS, length: 255 )
• ADDRESS ( type: esriFieldTypeString, alias: ADDRESS, length: 150 )
• HOME_OCCUPATION ( type: esriFieldTypeString, alias: HOME_OCCUPATION, length: 10 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• OBJECTID ( type: esriFieldTypeOID, alias: ObjectID )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )
• ServiceStatus ( type: esriFieldTypeString, alias: ServiceStatus, length: 50 )
• ServiceType ( type: esriFieldTypeString, alias: ServiceType, length: 50 )
• OWN_TYPE ( type: esriFieldTypeString, alias: OWN_TYPE, length: 150 )

Supported Operations:   Query   Query Attachments   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata