20230530
18141100
1.0
FALSE
BusinessesCleaned
002
1147471.550020
1164754.620113
1950316.490143
1969301.719889
1
Projected
GCS_North_American_1983
Linear Unit: Foot_US (0.304801)
NAD_1983_StatePlane_Illinois_East_FIPS_1201_Feet
<ProjectedCoordinateSystem xsi:type='typens:ProjectedCoordinateSystem' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.2.0'><WKT>PROJCS["NAD_1983_StatePlane_Illinois_East_FIPS_1201_Feet",GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Transverse_Mercator"],PARAMETER["False_Easting",984250.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-88.33333333333333],PARAMETER["Scale_Factor",0.999975],PARAMETER["Latitude_Of_Origin",36.66666666666666],UNIT["Foot_US",0.3048006096012192],AUTHORITY["EPSG",3435]]</WKT><XOrigin>-17463800</XOrigin><YOrigin>-46132600</YOrigin><XYScale>3048.00609601219</XYScale><ZOrigin>0</ZOrigin><ZScale>1</ZScale><MOrigin>0</MOrigin><MScale>1</MScale><XYTolerance>0.00328083333333333</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>102671</WKID><LatestWKID>3435</LatestWKID></ProjectedCoordinateSystem>
20231213
09451200
20231213
09451200
Esri ArcGIS 13.2.0.49743
BusinessesCleaned
1
-87.732657
-87.668514
42.071728
42.019281
Enterprise Geodatabase Feature Class
dataset
EPSG
8.9.3(9.3.0.0)
0
Simple
FALSE
0
TRUE
FALSE
BusinessesCleaned
Feature Class
0
OBJECTID
OBJECTID
OID
4
10
0
Internal feature number.
Esri
Sequential unique whole numbers that are automatically generated.
DirectoryReady
Public directory ready
String
12
0
0
Shape
Shape
Geometry
8
0
0
Feature geometry.
Esri
Coordinates defining the features.
SurveyDate
Formstack survey date
Date
8
0
0
CurrentLicense
Currently licensed?
String
12
0
0
BusLicNum
Business license #
String
120
0
0
ExistingBusiness
Existing business?
String
12
0
0
NewBusLicNo
New business license #
String
150
0
0
LegalBusName
Legal business name
String
150
0
0
DBABusName
Doing business as
String
150
0
0
OwnershipType
Ownership type
String
50
0
0
BusType
Business type
String
100
0
0
Description
Description
String
4000
0
0
CuisineType
CuisineType
String
50
0
0
HomeBased
Home-based?
String
12
0
0
AIABE
Asian-Indian American Owned
String
12
0
0
APABE
Asian-Pacific American-Owned
String
12
0
0
BAABE
Black/African American-Owned
String
12
0
0
HLABE
Hispanic/Lantinx American-Owned
String
12
0
0
WBE
Woman-Owned
String
12
0
0
LGBTQBE
LGBTQPlus-Owned
String
12
0
0
DBE
Disadvantaged business enterprise
String
12
0
0
Notes
Notes
String
255
0
0
DataSource
Data source
String
50
0
0
LegacyBusiness
Legacy business
String
12
0
0
LBCategory
Legacy business category
String
100
0
0
LBKnownFor
Known for
String
100
0
0
YearEstablished
Year established
SmallInteger
2
5
0
Logo
Logo
String
255
0
0
LBImage
Legacy business image
String
255
0
0
LBPopup
Legacy business pop-up
String
255
0
0
LBFeatureURL
Legacy business feature URL
String
255
0
0
LBNarrative
Legacy business narrative
String
1000
0
0
Exceed15
Exceeds 15% of home?
String
12
0
0
Exceed25
Exceeds 25% of home?
String
12
0
0
NonResEmployees
Non-resident employees?
String
12
0
0
NonResEmployees2
More than 2 non-res employees?
String
12
0
0
DirectSaleProducts
Direct sale products?
String
12
0
0
Clients3
More than 3 clients?
String
12
0
0
Clients6
More than 6 clients?
String
12
0
0
Delivery1
More than 1 delivery per week?
String
12
0
0
Deliveries3
More than 3 deliveries per week?
String
12
0
0
HomeOccGuidelines
Read home-occupied guidelines?
String
12
0
0
BusRegCategory
Registration category
String
100
0
0
Address
Address
String
100
0
0
Address2
Address2
String
100
0
0
City
City
String
50
0
0
State
State
String
14
0
0
ZIP
ZIP code
String
10
0
0
Phone
Phone
String
24
0
0
Website
Website
String
255
0
0
Email
Email
String
100
0
0
NumLocations
Number of locations
SmallInteger
2
5
0
NumEvLocations
Evanston locations
SmallInteger
2
5
0
Franchise
Franchise?
String
12
0
0
ContactNameFirst
Contact first name
String
50
0
0
ContactNameLast
Contact last name
String
50
0
0
ContactPhone
Contact phone
String
24
0
0
ContactEmail
Contact email
String
60
0
0
ILTaxID
IL Business Tax ID #
String
100
0
0
FedEmployerID
Federal Employer ID #
String
50
0
0
ILFileNum
IL File #
String
50
0
0
ILBusLicense
Licensed by state?
String
12
0
0
YearCreated
Year created
String
50
0
0
YearEvOpened
Year Ev location opened
String
100
0
0
FullTimeEmployees
Full-time employees
String
100
0
0
PartTimeEmployees
Part-time employees
String
100
0
0
EvResEmployees
Evanston resident employees
SmallInteger
2
5
0
Hours
Hours of operation
String
200
0
0
Floor
Floor(s)
String
150
0
0
MWBE
MWBE?
String
12
0
0
MWBEType
MWBE type(s)
String
150
0
0
MWBECertURL
MWBE certification
String
100
0
0
DateOpen
Opening date
String
150
0
0
RenoWork
Renovation work needed?
String
100
0
0
OwnerNameFirst
Owner first name
String
50
0
0
OwnerNameLast
Owner last name
String
50
0
0
OwnerAddress
Owner address
String
100
0
0
OwnerAddress2
Owner address 2
String
50
0
0
OwnerCity
Owner city
String
50
0
0
OwnerState
Owner state
String
14
0
0
OwnerZIP
Owner ZIP code
String
10
0
0
OwnerPhone
Owner phone
String
24
0
0
OwnerEmail
Owner email
String
60
0
0
LocationOwnership
Own or lease?
String
24
0
0
LandlordNameFirst
Landlord first name
String
100
0
0
LandlordNameLast
Landlord last name
String
50
0
0
LandlordPhone
Landlord phone
String
24
0
0
LandlordAddress
Landlord address
String
100
0
0
LandlordAddress2
Landlord address 2
String
50
0
0
LandlordCity
Landlord city
String
50
0
0
LandlordState
Landlord state
String
14
0
0
LandlordZIP
Landlord ZIP code
String
10
0
0
CoEProcurement
CoE procurement interest?
String
12
0
0
BrowserOS
Browser and OS
String
100
0
0
IPAddress
IP address
String
45
0
0
FormstackID
Formstack Survey ID
Integer
4
10
0
SubmittalLocation
Submittal location
String
50
0
0
created_user
created_user
String
255
0
0
created_date
created_date
Date
8
0
0
last_edited_user
last_edited_user
String
255
0
0
ILRevAcct
IL Revenue Account #
String
9
0
0
SICCodeNum
SIC Code
Integer
4
10
0
TextCalc
Temp Text
String
255
0
0
Status
Status
String
50
0
0
last_edited_date
last_edited_date
Date
8
0
0
20231213