20200501
17401100
1.0
FGDC CSDGM Metadata
FALSE
CalculateField COVID19_Cases_042920_poly CASES_POP ( [Confirmed]/ [pop18])*100000 VB #
CalculateField COVID19_Cases_042920_poly Categories "0" VB #
CalculateField COVID19_Cases_042920_poly Categories "1-50" VB #
CalculateField COVID19_Cases_042920_poly Categories "51-100" VB #
CalculateField COVID19_Cases_042920_poly Categories "101-250" VB #
CalculateField COVID19_Cases_042920_poly Categories "251-500" VB #
CalculateField COVID19_Cases_042920_poly Categories "501-750" VB #
CalculateField COVID19_Cases_042920_poly Categories "751-1000" VB #
CalculateField COVID19_Cases_042920_poly Categories "751-1000" VB #
CalculateField COVID19_Cases_042920_poly Categories "1001-2000" VB #
CalculateField COVID19_Cases_042920_poly Categories ">2000" VB #
UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' 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/2.4.0'><WorkspaceConnectionString>DATABASE=C:\BTS_Projects\SV_Projects\DOTEmployees\DOTEmployees</WorkspaceConnectionString><WorkspaceFactory>Shapefile</WorkspaceFactory><Dataset>COVID19_Cases_042920_poly.shp</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>CatDate</field_name><field_type>TEXT</field_type><field_length>25</field_length><field_is_nullable>False</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>
CalculateField COVID19_Cases_042920_poly CatDate ConcatenateFields(!Categories!, "04/29") "Python 3" "# Joins two or more fields into a single string value
# More calculator examples at esriurl.com/CalculatorExamples
def ConcatenateFields(*args):
sep = "-"
return sep.join([i for i in args if i])"
CalculateField COVID19_Cases_042920_poly CatDate ConcatenateFields(!Categories!, "04/29") "Python 3" "# Joins two or more fields into a single string value
# More calculator examples at esriurl.com/CalculatorExamples
def ConcatenateFields(*args):
sep = ";"
return sep.join([i for i in args if i])"
CalculateField COVID19_Cases_042920_poly CatDate ConcatenateFields("04/29",!Categories!) "Python 3" "# Joins two or more fields into a single string value
# More calculator examples at esriurl.com/CalculatorExamples
def ConcatenateFields(*args):
sep = "; "
return sep.join([i for i in args if i])"
UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' 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/2.4.0'><WorkspaceConnectionString>DATABASE=C:\BTS_Projects\SV_Projects\DOTEmployees\DOTEmployees</WorkspaceConnectionString><WorkspaceFactory>Shapefile</WorkspaceFactory><Dataset>COVID19_Cases_042920_poly.shp</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>Sort</field_name><field_type>SHORT</field_type><field_length>15</field_length><field_is_nullable>False</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>Field</field_name><field_type>LONG</field_type><field_is_nullable>False</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>
UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' 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/2.4.0'><WorkspaceConnectionString>DATABASE=C:\BTS_Projects\SV_Projects\DOTEmployees\DOTEmployees</WorkspaceConnectionString><WorkspaceFactory>Shapefile</WorkspaceFactory><Dataset>COVID19_Cases_042920_poly.shp</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><DeleteField><field_name>Field</field_name></DeleteField></workflow></operationSequence>
CalculateField COVID19_Cases_042920_poly Sort Reclass(!Categories!) "Python 3" "# Reclassify values to another value
# More calculator examples at esriurl.com/CalculatorExamples
def Reclass(p):
if p is 0:
return 1
elif p == 1-50:
return 2
elif p == 51-100:
return 3
elif p == 101-250:
return 4
elif p == 251-500:
return 5
elif p == 501-750:
return 6
elif p == 751-1000:
return 7
elif p == 1001-2000:
return 8
elif p == '>2000':
return 9
return 10"
CalculateField COVID19_Cases_042920_poly Sort Reclass(!Categories!) "Python 3" "# Reclassify values to another value
# More calculator examples at esriurl.com/CalculatorExamples
def Reclass(p):
if p is 0:
return 1
elif p == '1-50':
return 2
elif p == '51-100':
return 3
elif p == '101-250':
return 4
elif p == '251-500':
return 5
elif p == '501-750':
return 6
elif p == '751-1000':
return 7
elif p == '1001-2000':
return 8
elif p == '>2000':
return 9
return 10"
CalculateField COVID19_Cases_042920_poly Sort Reclass(!Categories!) "Python 3" "# Reclassify values to another value
# More calculator examples at esriurl.com/CalculatorExamples
def Reclass(p):
if p is '0':
return 1
elif p == '1-50':
return 2
elif p == '51-100':
return 3
elif p == '101-250':
return 4
elif p == '251-500':
return 5
elif p == '501-750':
return 6
elif p == '751-1000':
return 7
elif p == '1001-2000':
return 8
elif p == '>2000':
return 9
return 10"
FeatureClassToFeatureClass COVID19_Cases_042920_poly C:\BTS_Projects\Maps\DOTemployee\DOTemployee.gdb COVID19_Cases_joined042930 # "STATEFP "STATEFP" true true false 2 Text 0 0,First,#,COVID19_Cases_042920_poly,STATEFP,0,2;COUNTYFP "COUNTYFP" true true false 3 Text 0 0,First,#,COVID19_Cases_042920_poly,COUNTYFP,0,3;COUNTYNS "COUNTYNS" true true false 8 Text 0 0,First,#,COVID19_Cases_042920_poly,COUNTYNS,0,8;AFFGEOID "AFFGEOID" true true false 14 Text 0 0,First,#,COVID19_Cases_042920_poly,AFFGEOID,0,14;GEOID "GEOID" true true false 5 Text 0 0,First,#,COVID19_Cases_042920_poly,GEOID,0,5;NAME "NAME" true true false 100 Text 0 0,First,#,COVID19_Cases_042920_poly,NAME,0,100;LSAD "LSAD" true true false 2 Text 0 0,First,#,COVID19_Cases_042920_poly,LSAD,0,2;ALAND "ALAND" true true false 19 Double 0 0,First,#,COVID19_Cases_042920_poly,ALAND,-1,-1;AWATER "AWATER" true true false 19 Double 0 0,First,#,COVID19_Cases_042920_poly,AWATER,-1,-1;Geography "Geography" true true false 254 Text 0 0,First,#,COVID19_Cases_042920_poly,Geography,0,254;FIPS "FIPS" true true false 254 Text 0 0,First,#,COVID19_Cases_042920_poly,FIPS,0,254;pop10 "pop10" true true false 19 Double 0 0,First,#,COVID19_Cases_042920_poly,pop10,-1,-1;pop11 "pop11" true true false 19 Double 0 0,First,#,COVID19_Cases_042920_poly,pop11,-1,-1;pop12 "pop12" true true false 19 Double 0 0,First,#,COVID19_Cases_042920_poly,pop12,-1,-1;pop13 "pop13" true true false 19 Double 0 0,First,#,COVID19_Cases_042920_poly,pop13,-1,-1;pop14 "pop14" true true false 19 Double 0 0,First,#,COVID19_Cases_042920_poly,pop14,-1,-1;pop15 "pop15" true true false 19 Double 0 0,First,#,COVID19_Cases_042920_poly,pop15,-1,-1;pop16 "pop16" true true false 19 Double 0 0,First,#,COVID19_Cases_042920_poly,pop16,-1,-1;pop17 "pop17" true true false 19 Double 0 0,First,#,COVID19_Cases_042920_poly,pop17,-1,-1;pop18 "pop18" true true false 19 Double 0 0,First,#,COVID19_Cases_042920_poly,pop18,-1,-1;pchng1018 "pchng1018" true true false 19 Double 0 0,First,#,COVID19_Cases_042920_poly,pchng1018,-1,-1;SUM_DOT_Em "SUM_DOT_Em" true true false 19 Double 0 0,First,#,COVID19_Cases_042920_poly,SUM_DOT_Em,-1,-1;Shape_Leng "Shape_Leng" true true false 19 Double 0 0,First,#,COVID19_Cases_042920_poly,Shape_Leng,-1,-1;Shape_Area "Shape_Area" true true false 19 Double 0 0,First,#,COVID19_Cases_042920_poly,Shape_Area,-1,-1;FID_1 "FID_1" true true false 9 Long 0 9,First,#,COVID19_Cases_042920_poly,FID_1,-1,-1;OBJECTID "OBJECTID" true true false 4 Short 0 4,First,#,COVID19_Cases_042920_poly,OBJECTID,-1,-1;Province_S "Province_S" true true false 20 Text 0 0,First,#,COVID19_Cases_042920_poly,Province_S,0,20;Country_Re "Country_Re" true true false 2 Text 0 0,First,#,COVID19_Cases_042920_poly,Country_Re,0,2;Last_Updat "Last_Updat" true true false 13 Double 0 13,First,#,COVID19_Cases_042920_poly,Last_Updat,-1,-1;Lat "Lat" true true false 19 Double 15 18,First,#,COVID19_Cases_042920_poly,Lat,-1,-1;Long_ "Long_" true true false 19 Double 15 18,First,#,COVID19_Cases_042920_poly,Long_,-1,-1;Confirmed "Confirmed" true true false 6 Long 0 6,First,#,COVID19_Cases_042920_poly,Confirmed,-1,-1;Recovered "Recovered" true true false 1 Short 0 1,First,#,COVID19_Cases_042920_poly,Recovered,-1,-1;Deaths "Deaths" true true false 5 Long 0 5,First,#,COVID19_Cases_042920_poly,Deaths,-1,-1;Active "Active" true true false 6 Long 0 6,First,#,COVID19_Cases_042920_poly,Active,-1,-1;Admin2 "Admin2" true true false 41 Text 0 0,First,#,COVID19_Cases_042920_poly,Admin2,0,41;FIPS_1 "FIPS_1" true true false 5 Text 0 0,First,#,COVID19_Cases_042920_poly,FIPS_1,0,5;Combined_K "Combined_K" true true false 55 Text 0 0,First,#,COVID19_Cases_042920_poly,Combined_K,0,55;Incident_R "Incident_R" true true false 19 Double 15 18,First,#,COVID19_Cases_042920_poly,Incident_R,-1,-1;People_Tes "People_Tes" true true false 1 Text 0 0,First,#,COVID19_Cases_042920_poly,People_Tes,0,1;People_Hos "People_Hos" true true false 1 Text 0 0,First,#,COVID19_Cases_042920_poly,People_Hos,0,1;UID "UID" true true false 8 Long 0 8,First,#,COVID19_Cases_042920_poly,UID,-1,-1;ISO3 "ISO3" true true false 3 Text 0 0,First,#,COVID19_Cases_042920_poly,ISO3,0,3;CASES_POP "CASES_POP" true true false 19 Double 0 0,First,#,COVID19_Cases_042920_poly,CASES_POP,-1,-1;Categories "Categories" true true false 15 Text 0 0,First,#,COVID19_Cases_042920_poly,Categories,0,15;CatDate "CatDate" true true false 25 Text 0 0,First,#,COVID19_Cases_042920_poly,CatDate,0,25;Sort "Sort" true true false 5 Long 0 5,First,#,COVID19_Cases_042920_poly,Sort,-1,-1" #
JoinField COVID19_Cases_joined042930 Categories COVID19_Cases_043020_poly Category CASES_POP;CatDate;Category;SUM_DOT_Em
file://\\RITSLHQE-83003\C$\BTS_Projects\Maps\DOTemployee\DOTemployee.gdb
Local Area Network
COVID19_Cases_joined042930
002
Geographic
GCS_North_American_1983
Angular Unit: Degree (0.017453)
<GeographicCoordinateSystem xsi:type='typens:GeographicCoordinateSystem' 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/2.4.0'><WKT>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],AUTHORITY["EPSG",4269]]</WKT><XOrigin>-400</XOrigin><YOrigin>-400</YOrigin><XYScale>1111948722.2222221</XYScale><ZOrigin>-100000</ZOrigin><ZScale>10000</ZScale><MOrigin>-100000</MOrigin><MScale>10000</MScale><XYTolerance>8.9831528411952133e-09</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><LeftLongitude>-180</LeftLongitude><WKID>4269</WKID><LatestWKID>4269</LatestWKID></GeographicCoordinateSystem>
20200508
16392000
20200508
16392000
Microsoft Windows 10 Version 10.0 (Build 17763) ; Esri ArcGIS 12.4.2.19948
COVID19_Cases_joined042930
Coronavirus
DOT
DOT Employees
Comparison 04292020 and 04302020 DOT employees by COVID 19 rate.
File Geodatabase Feature Class
dataset
EPSG
6.12(3.0.1)
0
Simple
FALSE
0
TRUE
FALSE
COVID19_Cases_joined042930
Feature Class
0
OBJECTID_1
OBJECTID_1
OID
4
0
0
Internal feature number.
Esri
Sequential unique whole numbers that are automatically generated.
Shape
Shape
Geometry
0
0
0
Feature geometry.
Esri
Coordinates defining the features.
STATEFP
STATEFP
String
2
0
0
COUNTYFP
COUNTYFP
String
3
0
0
COUNTYNS
COUNTYNS
String
8
0
0
AFFGEOID
AFFGEOID
String
14
0
0
GEOID
GEOID
String
5
0
0
NAME
NAME
String
100
0
0
LSAD
LSAD
String
2
0
0
ALAND
ALAND
Double
8
0
0
AWATER
AWATER
Double
8
0
0
Geography
Geography
String
254
0
0
FIPS
FIPS
String
254
0
0
pop10
pop10
Double
8
0
0
pop11
pop11
Double
8
0
0
pop12
pop12
Double
8
0
0
pop13
pop13
Double
8
0
0
pop14
pop14
Double
8
0
0
pop15
pop15
Double
8
0
0
pop16
pop16
Double
8
0
0
pop17
pop17
Double
8
0
0
pop18
pop18
Double
8
0
0
pchng1018
pchng1018
Double
8
0
0
SUM_DOT_Em
SUM_DOT_Em
Double
8
0
0
Shape_Leng
Shape_Leng
Double
8
0
0
FID_1
FID_1
Integer
4
0
0
OBJECTID
OBJECTID
SmallInteger
2
0
0
Province_S
Province_S
String
20
0
0
Country_Re
Country_Re
String
2
0
0
Last_Updat
Last_Updat
Double
8
0
0
Lat
Lat
Double
8
0
0
Long_
Long_
Double
8
0
0
Confirmed
Confirmed
Integer
4
0
0
Recovered
Recovered
SmallInteger
2
0
0
Deaths
Deaths
Integer
4
0
0
Active
Active
Integer
4
0
0
Admin2
Admin2
String
41
0
0
FIPS_1
FIPS_1
String
5
0
0
Combined_K
Combined_K
String
55
0
0
Incident_R
Incident_R
Double
8
0
0
People_Tes
People_Tes
String
1
0
0
People_Hos
People_Hos
String
1
0
0
UID
UID
Integer
4
0
0
ISO3
ISO3
String
3
0
0
CASES_POP
CASES_POP
Double
8
0
0
Categories
Categories
String
15
0
0
CatDate
CatDate
String
25
0
0
Sort
Sort
Integer
4
0
0
Shape_Length
Shape_Length
Double
8
0
0
Length of feature in internal units.
Esri
Positive real numbers that are automatically generated.
Shape_Area
Shape_Area
Double
8
0
0
Area of feature in internal units squared.
Esri
Positive real numbers that are automatically generated.
20200508