20190424
11445500
1.0
FALSE
CopyFeatures Airports C:\Users\kelsey.taylor.ctr\Downloads\airports_join.shp # # # #
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.2.0'><WorkspaceConnectionString>DATABASE=C:\Users\kelsey.taylor.ctr\Downloads</WorkspaceConnectionString><WorkspaceFactory>Shapefile</WorkspaceFactory><Dataset>airports_join</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><DeleteField><field_name>Airports_O</field_name><field_name>Airports_S</field_name><field_name>Airports_F</field_name><field_name>Airports_E</field_name><field_name>Airports_R</field_name><field_name>Airports_D</field_name><field_name>Airports_2</field_name><field_name>Airports_3</field_name></DeleteField></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.2.0'><WorkspaceConnectionString>DATABASE=C:\Users\kelsey.taylor.ctr\Downloads</WorkspaceConnectionString><WorkspaceFactory>Shapefile</WorkspaceFactory><Dataset>airports_join</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><DeleteField><field_name>Airports_6</field_name><field_name>Airports_7</field_name><field_name>Airports_8</field_name><field_name>Airports_9</field_name><field_name>Airport_10</field_name><field_name>Airports_M</field_name><field_name>Airport_11</field_name><field_name>Airport_12</field_name><field_name>Airports_T</field_name><field_name>Airports_A</field_name><field_name>Airport_13</field_name><field_name>Airport_14</field_name><field_name>Airport_15</field_name><field_name>Airport_16</field_name><field_name>Airport_17</field_name><field_name>Airport_18</field_name><field_name>Airport_19</field_name><field_name>Airport_20</field_name><field_name>Airport_21</field_name><field_name>Airport_22</field_name><field_name>Airports_h</field_name><field_name>Airport_23</field_name><field_name>Airport_24</field_name><field_name>Airport_25</field_name><field_name>Airport_26</field_name><field_name>Airport_27</field_name><field_name>Airport_28</field_name><field_name>Airport_29</field_name><field_name>Airports_i</field_name><field_name>Airport_30</field_name><field_name>Airport_31</field_name><field_name>Airport_32</field_name><field_name>Airport_33</field_name><field_name>Airport_34</field_name><field_name>Airport_35</field_name><field_name>Airport_36</field_name><field_name>Airport_37</field_name><field_name>Airport_38</field_name><field_name>Airports_B</field_name><field_name>Airport_39</field_name><field_name>Airport_40</field_name><field_name>Airport_41</field_name><field_name>Airport_42</field_name><field_name>Airports_U</field_name><field_name>Airport_43</field_name><field_name>Airport_44</field_name><field_name>Airport_45</field_name><field_name>Airport_46</field_name><field_name>Airport_47</field_name><field_name>Airport_48</field_name><field_name>Airport_49</field_name><field_name>Airports_J</field_name><field_name>Airport_50</field_name><field_name>Airports_G</field_name><field_name>Airport_51</field_name><field_name>Airport_52</field_name><field_name>Airport_53</field_name><field_name>Airport_54</field_name><field_name>Airport_55</field_name><field_name>Airport_56</field_name><field_name>Airport_57</field_name><field_name>Airport_58</field_name><field_name>Airport_59</field_name><field_name>Airports_P</field_name><field_name>Airport_60</field_name><field_name>Airport_61</field_name><field_name>Airport_62</field_name><field_name>Airport_63</field_name><field_name>Airport_64</field_name><field_name>Airport_65</field_name><field_name>Airports_W</field_name><field_name>Airport_66</field_name><field_name>Airport_67</field_name><field_name>Airport_68</field_name><field_name>Airport_69</field_name><field_name>Airport_70</field_name><field_name>Airport_71</field_name><field_name>Airport_72</field_name><field_name>Airport_73</field_name><field_name>Airport_74</field_name><field_name>npais_list</field_name><field_name>npais_li_1</field_name><field_name>npais_li_2</field_name><field_name>npais_li_3</field_name><field_name>npais_li_4</field_name><field_name>npais_li_5</field_name><field_name>npais_li_6</field_name><field_name>npais_li_8</field_name><field_name>npais_li_9</field_name><field_name>npais_l_10</field_name></DeleteField></workflow></operationSequence>
CopyFeatures airports_join "C:\Users\kelsey.taylor.ctr\Documents\Data\General\Transportation layers\Transportation layers.gdb\airports_npais_2018" # # # #
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\General\Transportation layers\Transportation layers.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>airports_npais_2018</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>LAT</field_name><field_type>FLOAT</field_type><field_alias>LAT</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>LONG</field_name><field_type>FLOAT</field_type><field_alias>LONG</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>
CalculateGeometryAttributes airports_npais_2018 "LAT POINT_Y;LONG POINT_X" # # #
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\General\Transportation layers\Transportation layers.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>airports_npais_2018</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>OZ</field_name><field_type>LONG</field_type><field_length>1</field_length><field_alias>OZ</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>
CalculateField airports_npais_2018 OZ 1 "Python 3" #
CalculateField airports_npais_2018 OZ 0 "Python 3" #
CopyFeatures airports_npais_2018 "C:\Users\kelsey.taylor.ctr\Documents\Data\Misc Projects\Opportunity zones\OpportunityZones.gdb\AllAirports" # # # #
FeatureClassToFeatureClass AllAirports "C:\Users\kyle.titlow.ctr\Documents\Projects\Opportunity Zones\OZ.gdb\oz_infrastructure" oz_airports_all # "Airports_L "LOCID" true true false 80 Text 0 0,First,#,AllAirports,Airports_L,0,80;Airports_1 "STUSPS" true true false 80 Text 0 0,First,#,AllAirports,Airports_1,0,80;Airports_C "COUNTY" true true false 80 Text 0 0,First,#,AllAirports,Airports_C,0,80;Airports_4 "CITY" true true false 80 Text 0 0,First,#,AllAirports,Airports_4,0,80;Airports_5 "NAME" true true false 80 Text 0 0,First,#,AllAirports,Airports_5,0,80;Airport_75 "ENP_2017" true true false 4 Long 0 0,First,#,AllAirports,Airport_75,-1,-1;Airport_76 "PASS_2017" true true false 4 Long 0 0,First,#,AllAirports,Airport_76,-1,-1;Airport_77 "ARR_2017" true true false 4 Long 0 0,First,#,AllAirports,Airport_77,-1,-1;Airport_78 "DEP_2017" true true false 4 Long 0 0,First,#,AllAirports,Airport_78,-1,-1;Airport_79 "LBS_2017" true true false 4 Long 0 0,First,#,AllAirports,Airport_79,-1,-1;Airport_80 "MAIL_2017" true true false 4 Long 0 0,First,#,AllAirports,Airport_80,-1,-1;npais_li_7 "HUB" true true false 254 Text 0 0,First,#,AllAirports,npais_li_7,0,254;LAT "LAT" true true false 4 Float 0 0,First,#,AllAirports,LAT,-1,-1;LONG "LONG" true true false 4 Float 0 0,First,#,AllAirports,LONG,-1,-1;OZ "OZ" true true false 4 Long 0 0,First,#,AllAirports,OZ,-1,-1" #
oz_airports_all
002
file://\\RITSLHQE-83004\C$\Users\kyle.titlow.ctr\Documents\Projects\Opportunity Zones\OZ.gdb
Local Area Network
-171.732778
145.729984
-14.331660
71.284861
1
Projected
GCS_North_American_1983
Linear Unit: Meter (1.000000)
<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["North_America_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",20.0],PARAMETER["Standard_Parallel_2",60.0],PARAMETER["Latitude_Of_Origin",40.0],UNIT["Meter",1.0],AUTHORITY["Esri",102008]]</WKT><XOrigin>-16688100</XOrigin><YOrigin>-9068200</YOrigin><XYScale>10000</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>102008</WKID><LatestWKID>102008</LatestWKID></ProjectedCoordinateSystem>
North_America_Albers_Equal_Area_Conic
20200810
16144600
20200810
16144600
Microsoft Windows 10 Version 10.0 (Build 17763) ; Esri ArcGIS 12.4.2.19948
OZ Airports All
1
-171.732778
145.729984
71.284861
-14.331660
Airports
Opportunity Zones
Airports in or near Opportunity Zones in the United States
File Geodatabase Feature Class
dataset
Esri
4.0.0
0
Simple
FALSE
0
TRUE
FALSE
oz_airports_all
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.
Airports_L
LOCID
String
80
0
0
Airports_1
STUSPS
String
80
0
0
Airports_C
COUNTY
String
80
0
0
Airports_4
CITY
String
80
0
0
Airports_5
NAME
String
80
0
0
Airport_75
ENP_2017
Integer
4
0
0
Airport_76
PASS_2017
Integer
4
0
0
Airport_77
ARR_2017
Integer
4
0
0
Airport_78
DEP_2017
Integer
4
0
0
Airport_79
LBS_2017
Integer
4
0
0
Airport_80
MAIL_2017
Integer
4
0
0
npais_li_7
HUB
String
254
0
0
LAT
LAT
Single
4
0
0
LONG
LONG
Single
4
0
0
OZ
OZ
Integer
4
0
0
20200810