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"
Merge COVID19_Cases_042920_poly;COVID19_Cases_043020_poly C:\BTS_Projects\Maps\DOTemployee\DOTemployee.gdb\COVID19_Cases_04290430 "GEOID "GEOID" true true false 5 Text 0 0,First,#,COVID19_Cases_042920_poly,GEOID,0,5,COVID19_Cases_043020_poly,GEOID,0,5;NAME "NAME" true true false 100 Text 0 0,First,#,COVID19_Cases_042920_poly,NAME,0,100,COVID19_Cases_043020_poly,NAME,0,100;Geography "Geography" true true false 254 Text 0 0,First,#,COVID19_Cases_042920_poly,Geography,0,254,COVID19_Cases_043020_poly,Geography,0,254;FIPS "FIPS" true true false 254 Text 0 0,First,#,COVID19_Cases_042920_poly,FIPS,0,254,COVID19_Cases_043020_poly,FIPS,0,254;pop18 "pop18" true true false 19 Double 0 0,First,#,COVID19_Cases_042920_poly,pop18,-1,-1,COVID19_Cases_043020_poly,pop18,-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,COVID19_Cases_043020_poly,SUM_DOT_Em,-1,-1;Lat "Lat" true true false 19 Double 15 18,First,#,COVID19_Cases_042920_poly,Lat,-1,-1,COVID19_Cases_043020_poly,Lat,-1,-1;Long_ "Long_" true true false 19 Double 15 18,First,#,COVID19_Cases_042920_poly,Long_,-1,-1,COVID19_Cases_043020_poly,Long_,-1,-1;CASES_POP "CASES_POP" true true false 19 Double 0 0,First,#,COVID19_Cases_042920_poly,CASES_POP,-1,-1,COVID19_Cases_043020_poly,CASES_POP,-1,-1;CatDate "CatDate" true true false 25 Text 0 0,First,#,COVID19_Cases_042920_poly,CatDate,0,25,COVID19_Cases_043020_poly,CatDate,0,25;Sort "Sort" true true false 5 Long 0 5,First,#,COVID19_Cases_042920_poly,Sort,-1,-1,COVID19_Cases_043020_poly,Sort,-1,-1" NO_SOURCE_INFO
file://\\RITSLHQE-83003\C$\BTS_Projects\Maps\DOTemployee\DOTemployee.gdb
Local Area Network
COVID19_Cases_04290430
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>
20200505
22311000
20200505
22311000
Microsoft Windows 10 Version 10.0 (Build 17763) ; Esri ArcGIS 12.4.2.19948
COVID19_Cases_04290430
DOT Employees
DOT
COVID 19
Used for Chart indicator
File Geodatabase Feature Class
dataset
EPSG
6.12(3.0.1)
0
Simple
FALSE
0
TRUE
FALSE
COVID19_Cases_04290430
Feature Class
0
OBJECTID
OBJECTID
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.
GEOID
GEOID
String
5
0
0
NAME
NAME
String
100
0
0
Geography
Geography
String
254
0
0
FIPS
FIPS
String
254
0
0
pop18
pop18
Double
8
0
0
SUM_DOT_Em
SUM_DOT_Em
Double
8
0
0
Lat
Lat
Double
8
0
0
Long_
Long_
Double
8
0
0
CASES_POP
CASES_POP
Double
8
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.
20200505