Description: Data is provided daily to an ftp server, downloaded and imported into Excel, cleaned up and geocoded. Data included Business Type, SIC Code, Start and End Dates and Status of Business and License. 1/13/20254: approximately 14,500 records converted includes about 99% match significantly improved from last month's extract. Geocoding 2x, once to Primary Address left about 300 records, matched by street, about 30 records unmatched. AddressGIS did NOT include unit numbers so many stacked positions. Stored in local projection: WKID 6420, Cal. Zone 3 NAD83 (2011), US Feet, participates in replica with GISWeb: 'BusinessLicenseData'
Feature Type: Point
Type: FeatureLayer
Display Field: BusinessName
Primary Key Field: OBJECTID
Show Map Tips: True
Searchable: False
Identifiable: True
Queryable: True
Can Copy Feature: True
Snappable: True
Snapping Enabled: False
Has Attachments: False
Feature Label: <strong>2025 Business Data: {BusinessName}<strong>
OBJECTID (Type: Int32, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
ID (Type: Double, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
BusinessName [Business Name] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
CorporateName [Corporate Name] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
BusinessAddress [Business Address] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
AddressGIS [Address GIS] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
AddressNumber [Address Number] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
StreetPreDir [Street Prefix Dir] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
StreetName [Street Name] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
StreetSuffix [Street Suffix] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
StreetPostDir [Street Post Dir] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
StreetUnit [Street Unit] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
City (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
State (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
Zip (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
BusinessPhone [Business Phone] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
TypeofOwnership [Type of Ownership] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
BusinessStart [Business Start] (Type: DateTime, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
BusinessEndDate [Business End Date] (Type: DateTime, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
BusinessStatus [Business Status] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
LicenseStatus [License Status] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
LicenseExpirationDate [Lic. Expiration Date] (Type: DateTime, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
DescriptionBusiness [Description Business] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
BusinessType [Business Type] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
SICCode [SIC Code] (Type: Double, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
NumberEmployees [Number of Employees] (Type: Double, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
Email (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
ContactType [Contact Type] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
OwnerName [Owner Name] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
OwnerAddress [Owner Address] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
OwnerAddressNumber (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
OwnerStreetPreDir [Owner Street Prefix Dir] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
OwnerStreetName [Owner Street Name] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
OwnerStreetSuffix [Owner Street Suffix] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
OwnerStreetPostDir [Owner Street Post Dir] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
OwnerUnit [Owner Unit] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
OwnerCity [Owner City] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
OwnerState [Owner State] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
OwnerZip [Owner Zip] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
OwnerPhone [Owner Phone] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
OwnerEmail [Owner Email] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
GeoAddrtype [Address Type] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
GeoMatchtype [Match Type] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
GeoStatus [Status] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
GeoMatchAddr [Match Address] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
GeoMatchScore [Score] (Type: Double, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
CreatedBy (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
CreateDate (Type: DateTime, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
RevBy (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
RevDate (Type: DateTime, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
GlobalID (Type: Guid, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
Shape [SHAPE] (Type: Object, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)