20200218
13492500
1.0
FALSE
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.3.0'><WorkspaceConnectionString>DATABASE=C:\Users\kelsey.taylor.ctr\Documents\Data\Misc Projects\Opportunity zones</WorkspaceConnectionString><WorkspaceFactory>Shapefile</WorkspaceFactory><Dataset>8764OpportunityZones</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>CTFIPS</field_name><field_type>TEXT</field_type><field_length>9</field_length><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.3.0'><WorkspaceConnectionString>DATABASE=C:\Users\kelsey.taylor.ctr\Documents\Data\Misc Projects\Opportunity zones</WorkspaceConnectionString><WorkspaceFactory>Shapefile</WorkspaceFactory><Dataset>8764OpportunityZones</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>STUSPS</field_name><field_type>TEXT</field_type><field_length>2</field_length><field_is_nullable>False</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>STNAME</field_name><field_type>TEXT</field_type><field_length>20</field_length><field_is_nullable>False</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>CTNAME</field_name><field_type>TEXT</field_type><field_length>30</field_length><field_is_nullable>False</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>TRACTNAME</field_name><field_type>TEXT</field_type><field_length>30</field_length><field_is_nullable>False</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>
CopyFeatures "Opportunity Zones" "C:\Users\kelsey.taylor.ctr\Documents\Data\Misc Projects\Opportunity zones\Opportunity Zones shps\Opportunity Zones detailed.shp" # # # #
FeatureClassToFeatureClass "Opportunity Zones" C:\BTS_Projects\Maps\StatsInOpportunityZones\StatsInOpportunityZones.gdb OpportunityZones_COPY # "GEOID10 "GEOID10" true true false 11 Text 0 0,First,#,Opportunity Zones,GEOID10,0,11;CTFIPS "CTFIPS" true true false 9 Text 0 0,First,#,Opportunity Zones,CTFIPS,0,9;STUSPS "STUSPS" true true false 2 Text 0 0,First,#,Opportunity Zones,STUSPS,0,2;STNAME "STNAME" true true false 20 Text 0 0,First,#,Opportunity Zones,STNAME,0,20;CTNAME "CTNAME" true true false 30 Text 0 0,First,#,Opportunity Zones,CTNAME,0,30;TRACTNAME "TRACTNAME" true true false 30 Text 0 0,First,#,Opportunity Zones,TRACTNAME,0,30" #
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\Maps\StatsInOpportunityZones\StatsInOpportunityZones.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>OpportunityZones_COPY</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>RandomNum</field_name><field_type>DOUBLE</field_type><field_alias>RandomNum</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>
CalculateField OpportunityZones_COPY RandomNum randnum() "Python 3" "import random
def randnum():
return random.random()"
Near Subset-Albany\OpportunityZones_COPY_Albany1 Nationwide\Airports_Nationwide;Nationwide\Amtrak_Nationwide "100 Miles" NO_LOCATION NO_ANGLE Planar
Near Subset-Albany\OpportunityZones_COPY_Albany1 Nationwide\Airports_Nationwide "100 Miles" NO_LOCATION NO_ANGLE Planar
Near Subset-Albany\OpportunityZones_COPY_Albany1 Nationwide\Airports_Nationwide "100 Miles" NO_LOCATION NO_ANGLE Geodesic
Near Subset-Albany\OpportunityZones_COPY_Albany1 Nationwide\Airports_Nationwide "100 Miles" LOCATION NO_ANGLE Geodesic
Near Subset-Albany\OpportunityZones_COPY_Albany1 Nationwide\Airports_Nationwide "100 Miles" LOCATION NO_ANGLE Geodesic
Project OpportunityZones_COPY C:\BTS_Projects\Maps\StatsInOpportunityZones\StatsInOpportunityZones.gdb\OpportunityZones_COPY_projections1 PROJCS['WGS_1984_Web_Mercator_Auxiliary_Sphere',GEOGCS['GCS_WGS_1984',DATUM['D_WGS_1984',SPHEROID['WGS_1984',6378137.0,298.257223563]],PRIMEM['Greenwich',0.0],UNIT['Degree',0.0174532925199433]],PROJECTION['Mercator_Auxiliary_Sphere'],PARAMETER['False_Easting',0.0],PARAMETER['False_Northing',0.0],PARAMETER['Central_Meridian',0.0],PARAMETER['Standard_Parallel_1',0.0],PARAMETER['Auxiliary_Sphere_Type',0.0],UNIT['Meter',1.0]] WGS_1984_(ITRF00)_To_NAD_1983 PROJCS['USA_Contiguous_Albers_Equal_Area_Conic',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['Albers'],PARAMETER['False_Easting',0.0],PARAMETER['False_Northing',0.0],PARAMETER['Central_Meridian',-96.0],PARAMETER['Standard_Parallel_1',29.5],PARAMETER['Standard_Parallel_2',45.5],PARAMETER['Latitude_Of_Origin',37.5],UNIT['Meter',1.0]] NO_PRESERVE_SHAPE # NO_VERTICAL
Near "OpportunityZones_COPY_projections1_Albany selection" Nationwide\AirportsNationwide_Projections "100 Miles" NO_LOCATION NO_ANGLE Planar
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\Maps\StatsInOpportunityZones\StatsInOpportunityZones.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>OpportunityZones_COPY_projections1</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>Near_Dist_Miles</field_name><field_type>DOUBLE</field_type><field_alias>Near_Dist_Miles</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>
CalculateField "OpportunityZones_COPY_projections1_Albany selection" Near_Dist_Miles "!NEAR_DIST! * 0.000621371" "Python 3" #
DeleteField Nationwide\OpportunityZones_COPY_projections1 NEAR_FID;NEAR_DIST;NEAR_FC;NEAR_X;NEAR_Y;Near_Dist_Miles
Near Nationwide\OpportunityZones_COPY_projections1 Nationwide\CommercialAirports_CopyFeatures_Projecttions "100 Miles" NO_LOCATION NO_ANGLE Geodesic
AddFields Nationwide\OpportunityZones_COPY_projections1 "CommAirport_FID LONG CommAirport_FID # # #;CommAirport_Miles DOUBLE CommAirport_Miles # # #"
CalculateFields Nationwide\OpportunityZones_COPY_projections1 "Python 3" "CommAirport_FID !NEAR_FID!;CommAirport_Miles !NEAR_DIST!*0.000621371" #
Near OpportunityZones_COPY_projections1 Amtrak_Nationwide_CopyFeatures_Projections "100 Miles" NO_LOCATION NO_ANGLE Geodesic
AddFields OpportunityZones_COPY_projections1 "Near_Amtrak_FID LONG Near_Amtrak_FID # # #;Near_Amtrak_Miles DOUBLE Near_Amtrak_Miles # # #"
CalculateFields OpportunityZones_COPY_projections1 PYTHON3 "Near_Amtrak_FID !NEAR_FID!;Near_Amtrak_Miles !NEAR_DIST!*0.000621371" #
Near OpportunityZones_COPY_projections1 Nationwide\Major_Ports_Nationwide_Projections "100 Miles" NO_LOCATION NO_ANGLE Geodesic
AddFields OpportunityZones_COPY_projections1 "Near_MajorPorts_FID LONG Near_MajorPorts_FID # # #;Near_MajorPorts_Miles DOUBLE Near_MajorPorts_Miles # # #"
CalculateFields OpportunityZones_COPY_projections1 PYTHON3 "Near_MajorPorts_FID !NEAR_FID!;Near_MajorPorts_Miles !NEAR_DIST!*0.000621371" #
FeatureClassToFeatureClass "OpportunityZones_Transportation Assets" C:\BTS_Projects\Maps\StatsInOpportunityZones OZ_Transp_Assets.shp # "GEOID10 "GEOID10" true true false 11 Text 0 0,First,#,OpportunityZones_Transportation Assets,GEOID10,0,11;CTFIPS "CTFIPS" true true false 9 Text 0 0,First,#,OpportunityZones_Transportation Assets,CTFIPS,0,9;STUSPS "STUSPS" true true false 2 Text 0 0,First,#,OpportunityZones_Transportation Assets,STUSPS,0,2;STNAME "STNAME" true true false 20 Text 0 0,First,#,OpportunityZones_Transportation Assets,STNAME,0,20;CTNAME "CTNAME" true true false 30 Text 0 0,First,#,OpportunityZones_Transportation Assets,CTNAME,0,30;TRACTNAME "TRACTNAME" true true false 30 Text 0 0,First,#,OpportunityZones_Transportation Assets,TRACTNAME,0,30;RandomNum "RandomNum" true true false 8 Double 0 0,First,#,OpportunityZones_Transportation Assets,RandomNum,-1,-1;Shape_Leng "Shape_Length" false true true 8 Double 0 0,First,#,OpportunityZones_Transportation Assets,Shape_Length,-1,-1;Shape_Area "Shape_Area" false true true 8 Double 0 0,First,#,OpportunityZones_Transportation Assets,Shape_Area,-1,-1;NEAR_FID "NEAR_FID" true true false 4 Long 0 0,First,#,OpportunityZones_Transportation Assets,NEAR_FID,-1,-1;NEAR_DIST "NEAR_DIST" true true false 8 Double 0 0,First,#,OpportunityZones_Transportation Assets,NEAR_DIST,-1,-1;CommAirpor "CommAirport_FID" true true false 4 Long 0 0,First,#,OpportunityZones_Transportation Assets,CommAirport_FID,-1,-1;CommAirp_1 "CommAirport_Miles" true true false 8 Double 0 0,First,#,OpportunityZones_Transportation Assets,CommAirport_Miles,-1,-1;Near_Amtra "Near_Amtrak_FID" true true false 4 Long 0 0,First,#,OpportunityZones_Transportation Assets,Near_Amtrak_FID,-1,-1;Near_Amt_1 "Near_Amtrak_Miles" true true false 8 Double 0 0,First,#,OpportunityZones_Transportation Assets,Near_Amtrak_Miles,-1,-1;Near_Major "Near_MajorPorts_FID" true true false 4 Long 0 0,First,#,OpportunityZones_Transportation Assets,Near_MajorPorts_FID,-1,-1;Near_Maj_1 "Near_MajorPorts_Miles" true true false 8 Double 0 0,First,#,OpportunityZones_Transportation Assets,Near_MajorPorts_Miles,-1,-1" #
OZ_Transp_Assets
002
0.000
file://\\RITSLHQE-83003\C$\BTS_Projects\Maps\StatsInOpportunityZones\OZ_Transp_Assets.shp
Local Area Network
Projected
GCS_WGS_1984
Linear Unit: Meter (1.000000)
WGS_1984_Web_Mercator_Auxiliary_Sphere
<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/2.4.0'><WKT>PROJCS["WGS_1984_Web_Mercator_Auxiliary_Sphere",GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Mercator_Auxiliary_Sphere"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",0.0],PARAMETER["Standard_Parallel_1",0.0],PARAMETER["Auxiliary_Sphere_Type",0.0],UNIT["Meter",1.0],AUTHORITY["EPSG",3857]]</WKT><XOrigin>-20037700</XOrigin><YOrigin>-30241100</YOrigin><XYScale>148923141.92838538</XYScale><ZOrigin>-100000</ZOrigin><ZScale>10000</ZScale><MOrigin>-100000</MOrigin><MScale>10000</MScale><XYTolerance>0.001</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>102100</WKID><LatestWKID>3857</LatestWKID></ProjectedCoordinateSystem>
20200223
13150500
20200223
13150500
Microsoft Windows 10 Version 10.0 (Build 17763) ; Esri ArcGIS 12.4.2.19948
OZ_Transp_Assets
Opportunity Zones
Transportation
Opportunity Zones with Transportation Assets
Shapefile
0.000
dataset
EPSG
8.8(9.3.1.2)
0
Simple
FALSE
0
FALSE
FALSE
OZ_Transp_Assets
Feature Class
0
FID
FID
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.
GEOID10
GEOID10
String
11
0
0
CTFIPS
CTFIPS
String
9
0
0
STUSPS
STUSPS
String
2
0
0
STNAME
STNAME
String
20
0
0
CTNAME
CTNAME
String
30
0
0
TRACTNAME
TRACTNAME
String
30
0
0
RandomNum
RandomNum
Double
19
0
0
Shape_Leng
Shape_Leng
Double
19
0
0
Shape_Area
Shape_Area
Double
19
0
0
Area of feature in internal units squared.
Esri
Positive real numbers that are automatically generated.
NEAR_FID
NEAR_FID
Integer
10
10
0
NEAR_DIST
NEAR_DIST
Double
19
0
0
CommAirpor
CommAirpor
Integer
10
10
0
CommAirp_1
CommAirp_1
Double
19
0
0
Near_Amtra
Near_Amtra
Integer
10
10
0
Near_Amt_1
Near_Amt_1
Double
19
0
0
Near_Major
Near_Major
Integer
10
10
0
Near_Maj_1
Near_Maj_1
Double
19
0
0
20200223