20231212
12334500
1.0
FALSE
CreateFeatureclass "X:\Jessica\TLC TAP Updates\TLC_Updates.gdb" TLC_AllProj Point GPLYR_{A2A95450-B6B2-4076-8637-AD5E4FE1574B} No No "GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]];-400 -400 1000000000;-100000 10000;-100000 10000;8.98315284119521E-09;0.001;0.001;IsHighPrecision" # 0 0 0 #
XYTableToPoint TLC_AllProjects$ "X:\Jessica\TLC TAP Updates\TLC_Updates.gdb\TLC_AllProj" POINT_X POINT_Y # "GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]];-400 -400 1000000000;-100000 10000;-100000 10000;8.98315284119521E-09;0.001;0.001;IsHighPrecision"
Dissolve TLC_AllProj "X:\Jessica\TLC TAP Updates\TLC_Updates.gdb\TLC_AllProj_Dissolve" TLC_ID # MULTI_PART DISSOLVE_LINES #
ExportFeatures TLC_AllProj_Dissolve "X:\Jessica\TLC TAP Updates\TLC_Updates.gdb\TLC_AllProjects_updated" # NOT_USE_ALIAS "TLC_ID "TLC_ID" true true false 8 Double 0 0,First,#,TLC_AllProj_Dissolve,TLC_AllProj_Dissolve.TLC_ID,-1,-1;Year "Year" true true false 8 Double 0 0,First,#,TLC_AllProj_Dissolve,TLC_AllProj.Year,-1,-1;Fiscal_Year "Fiscal_Year" true true false 8 Double 0 0,First,#,TLC_AllProj_Dissolve,TLC_AllProj.Fiscal_Year,-1,-1;Project_Name "Project_Name" true true false 255 Text 0 0,First,#,TLC_AllProj_Dissolve,TLC_AllProj.Project_Name,0,255;Program "Program" true true false 255 Text 0 0,First,#,TLC_AllProj_Dissolve,TLC_AllProj.Program,0,255;State "State" true true false 255 Text 0 0,First,#,TLC_AllProj_Dissolve,TLC_AllProj.State,0,255;State_FIPS "State_FIPS" true true false 8 Double 0 0,First,#,TLC_AllProj_Dissolve,TLC_AllProj.State_FIPS,-1,-1;Jurisdiction "Jurisdiction" true true false 255 Text 0 0,First,#,TLC_AllProj_Dissolve,TLC_AllProj.Jurisdiction,0,255;Agency "Agency" true true false 255 Text 0 0,First,#,TLC_AllProj_Dissolve,TLC_AllProj.Agency,0,255;Project_Description "Project_Description" true true false 32767 Text 0 0,First,#,TLC_AllProj_Dissolve,TLC_AllProj.Project_Description,0,32767;Funding_Awarded "Funding_Awarded" true true false 8 Double 0 0,First,#,TLC_AllProj_Dissolve,TLC_AllProj.Funding_Awarded,-1,-1;Consultant "Consultant" true true false 255 Text 0 0,First,#,TLC_AllProj_Dissolve,TLC_AllProj.Consultant,0,255;Links "Links" true true false 255 Text 0 0,First,#,TLC_AllProj_Dissolve,TLC_AllProj.Links,0,255;Type "Type" true true false 255 Text 0 0,First,#,TLC_AllProj_Dissolve,TLC_AllProj.Type,0,255;Jurisdiction_Wide "Jurisdiction_Wide" true true false 8 Double 0 0,First,#,TLC_AllProj_Dissolve,TLC_AllProj.Jurisdiction_Wide,-1,-1;Year_txt "Year_txt" true true false 8 Double 0 0,First,#,TLC_AllProj_Dissolve,TLC_AllProj.Year_txt,-1,-1;Feature "Feature" true true false 255 Text 0 0,First,#,TLC_AllProj_Dissolve,TLC_AllProj.Feature,0,255" #
DeleteIdentical TLC_AllProjects_updated Shape;TLC_ID;Year;Fiscal_Year;Project_Name;Program;State;State_FIPS;Jurisdiction;Agency;Project_Description;Funding_Awarded;Consultant;Links;Type;Jurisdiction_Wide;Year_txt;Feature # 0
Rename "X:\Jessica\TLC TAP Updates\TLC_Updates.gdb\TLC_AllProjects_updated" "X:\Jessica\TLC TAP Updates\TLC_Updates.gdb\TLC_AllProjects" FeatureClass
Rename "X:\Jessica\TLC TAP Updates\TLC_Updates.gdb\TLC_AllProjects" "X:\Jessica\TLC TAP Updates\TLC_Updates.gdb\AllProjects" FeatureClass
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/3.1.0'><WorkspaceConnectionString>DATABASE=X:\Jessica\TLC TAP Updates\TLC_Updates.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>AllProjects</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AlterField><field_name>TLC_ID</field_name><new_field_name>PROG_ID</new_field_name><field_is_nullable>True</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField></workflow></operationSequence>
ExportFeatures AllProjects "X:\Jessica\TLC TAP Updates\TLC_Updates.gdb\AllTAP_Projects" "Program = 'TA Set-Aside'" NOT_USE_ALIAS "PROG_ID "TLC_ID" true true false 8 Double 0 0,First,#,AllProjects,PROG_ID,-1,-1;Year "Year" true true false 8 Double 0 0,First,#,AllProjects,Year,-1,-1;Fiscal_Year "Fiscal_Year" true true false 8 Double 0 0,First,#,AllProjects,Fiscal_Year,-1,-1;Project_Name "Project_Name" true true false 255 Text 0 0,First,#,AllProjects,Project_Name,0,255;Program "Program" true true false 255 Text 0 0,First,#,AllProjects,Program,0,255;State "State" true true false 255 Text 0 0,First,#,AllProjects,State,0,255;State_FIPS "State_FIPS" true true false 8 Double 0 0,First,#,AllProjects,State_FIPS,-1,-1;Jurisdiction "Jurisdiction" true true false 255 Text 0 0,First,#,AllProjects,Jurisdiction,0,255;Agency "Agency" true true false 255 Text 0 0,First,#,AllProjects,Agency,0,255;Project_Description "Project_Description" true true false 32767 Text 0 0,First,#,AllProjects,Project_Description,0,32767;Funding_Awarded "Funding_Awarded" true true false 8 Double 0 0,First,#,AllProjects,Funding_Awarded,-1,-1;Consultant "Consultant" true true false 255 Text 0 0,First,#,AllProjects,Consultant,0,255;Links "Links" true true false 255 Text 0 0,First,#,AllProjects,Links,0,255;Type "Type" true true false 255 Text 0 0,First,#,AllProjects,Type,0,255;Jurisdiction_Wide "Jurisdiction_Wide" true true false 8 Double 0 0,First,#,AllProjects,Jurisdiction_Wide,-1,-1;Year_txt "Year_txt" true true false 8 Double 0 0,First,#,AllProjects,Year_txt,-1,-1;Feature "Feature" true true false 255 Text 0 0,First,#,AllProjects,Feature,0,255" #
CalculateField "All TA Set-Aside Projects" Type fix(!Type!) "Python 3" "def fix(old):
if old == "Accessibility ":
return "Accessibility"
else:
return old" Text NO_ENFORCE_DOMAINS
ExportFeatures "X:\Jessica\TLC TAP Updates\TLC_Updates.gdb\AllTAP_Projects" "X:\Jessica\TLC TAP Updates\TLC_Updates.gdb\AllTAP_Projects_fix" # NOT_USE_ALIAS "PROG_ID "TLC_ID" true true false 8 Long 0 0,First,#,X:\Jessica\TLC TAP Updates\TLC_Updates.gdb\AllTAP_Projects,PROG_ID,-1,-1;Year "Year" true true false 8 Long 0 0,First,#,X:\Jessica\TLC TAP Updates\TLC_Updates.gdb\AllTAP_Projects,Year,-1,-1;Fiscal_Year "Fiscal Year" true true false 8 Long 0 0,First,#,X:\Jessica\TLC TAP Updates\TLC_Updates.gdb\AllTAP_Projects,Fiscal_Year,-1,-1;Project_Name "Project Name" true true false 255 Text 0 0,First,#,X:\Jessica\TLC TAP Updates\TLC_Updates.gdb\AllTAP_Projects,Project_Name,0,255;Program "Program" true true false 255 Text 0 0,First,#,X:\Jessica\TLC TAP Updates\TLC_Updates.gdb\AllTAP_Projects,Program,0,255;State "State" true true false 255 Text 0 0,First,#,X:\Jessica\TLC TAP Updates\TLC_Updates.gdb\AllTAP_Projects,State,0,255;State_FIPS "State FIPS" true true false 8 Long 0 0,First,#,X:\Jessica\TLC TAP Updates\TLC_Updates.gdb\AllTAP_Projects,State_FIPS,-1,-1;Jurisdiction "Jurisdiction" true true false 255 Text 0 0,First,#,X:\Jessica\TLC TAP Updates\TLC_Updates.gdb\AllTAP_Projects,Jurisdiction,0,255;Agency "Agency" true true false 255 Text 0 0,First,#,X:\Jessica\TLC TAP Updates\TLC_Updates.gdb\AllTAP_Projects,Agency,0,255;Project_Description "Project Description" true true false 32767 Text 0 0,First,#,X:\Jessica\TLC TAP Updates\TLC_Updates.gdb\AllTAP_Projects,Project_Description,0,32767;Funding_Awarded "Funding Awarded" true true false 8 Long 0 0,First,#,X:\Jessica\TLC TAP Updates\TLC_Updates.gdb\AllTAP_Projects,Funding_Awarded,-1,-1;Consultant "Consultant" true true false 255 Text 0 0,First,#,X:\Jessica\TLC TAP Updates\TLC_Updates.gdb\AllTAP_Projects,Consultant,0,255;Links "Links" true true false 255 Text 0 0,First,#,X:\Jessica\TLC TAP Updates\TLC_Updates.gdb\AllTAP_Projects,Links,0,255;Type "Type" true true false 255 Text 0 0,First,#,X:\Jessica\TLC TAP Updates\TLC_Updates.gdb\AllTAP_Projects,Type,0,255;Jurisdiction_Wide "Jurisdiction Wide" true true false 8 Short 0 0,First,#,X:\Jessica\TLC TAP Updates\TLC_Updates.gdb\AllTAP_Projects,Jurisdiction_Wide,-1,-1;Year_txt "Year_txt" true true false 8 Long 0 0,First,#,X:\Jessica\TLC TAP Updates\TLC_Updates.gdb\AllTAP_Projects,Year_txt,-1,-1;Feature "Feature" true true false 255 Text 0 0,First,#,X:\Jessica\TLC TAP Updates\TLC_Updates.gdb\AllTAP_Projects,Feature,0,255" #
Rename "X:\Jessica\TLC TAP Updates\TLC_Updates.gdb\AllTAP_Projects_fix" "X:\Jessica\TLC TAP Updates\TLC_Updates.gdb\AllTAP_Projects" FeatureClass
AllTAP_Projects_fix
002
file://\\coggis\user\Jessica\TLC TAP Updates\TLC_Updates.gdb
Local Area Network
Geographic
GCS_WGS_1984
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/3.1.0'><WKT>GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433],AUTHORITY["EPSG",4326]]</WKT><XOrigin>-400</XOrigin><YOrigin>-400</YOrigin><XYScale>999999999.99999988</XYScale><ZOrigin>-100000</ZOrigin><ZScale>10000</ZScale><MOrigin>-100000</MOrigin><MScale>10000</MScale><XYTolerance>8.98315284119521e-09</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><LeftLongitude>-180</LeftLongitude><WKID>4326</WKID><LatestWKID>4326</LatestWKID></GeographicCoordinateSystem>
20240306
12111300
20240306
12111300
Microsoft Windows 10 Version 10.0 (Build 19044) ; Esri ArcGIS 13.1.3.41833
Transportation Alternatives Set-Aside Programs
TAP
File Geodatabase Feature Class
dataset
EPSG
6.2(3.0.1)
0
Simple
FALSE
0
TRUE
FALSE
AllTAP_Projects_fix
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.
PROG_ID
TLC_ID
Integer
4
0
0
Year
Year
Integer
4
0
0
Fiscal_Year
Fiscal Year
Integer
4
0
0
Project_Name
Project Name
String
255
0
0
Program
Program
String
255
0
0
State
State
String
255
0
0
State_FIPS
State FIPS
Integer
4
0
0
Jurisdiction
Jurisdiction
String
255
0
0
Agency
Agency
String
255
0
0
Project_Description
Project Description
String
32767
0
0
Funding_Awarded
Funding Awarded
Integer
4
0
0
Consultant
Consultant
String
255
0
0
Links
Links
String
255
0
0
Type
Type
String
255
0
0
Jurisdiction_Wide
Jurisdiction Wide
SmallInteger
2
0
0
Year_txt
Year_txt
Integer
4
0
0
Feature
Feature
String
255
0
0
20240306
/9j/4AAQSkZJRgABAQEAAQABAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0a
HBwgJC4nICIsIxwcKDcpLDAxNDQ0Hyc5PTgyPC4zNDL/2wBDAQkJCQwLDBgNDRgyIRwhMjIyMjIy
MjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/wAARCADIASwDASIA
AhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQA
AAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3
ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWm
p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEA
AwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSEx
BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElK
U1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3
uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD3+iii
gAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKA
CiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAK
KKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAoo
ooAKKKKACiiigAooqKRBIhQlgGGCVJB/AjpQARSxyqWjdXAOCVOealqGGGO3iWKJQqDoP89amoEr
21CiiigYUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUU
AFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQA
UUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFV0u4JJTEkqF8kbc85HWrFAlJPYqG7IvBb+WWy
u4sGHy/UdfyzUseXO8h1yMbCenvTIpDJJJuhKFG2gn+IeoqzUuKbTFFtq7CiiiqKCiiigAooooAK
KKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiimru2D
djdjnHTNAEQgiWTzBEgc5O4KM/nU9FFAkktgooooGRqrBmLNkE8DHSpKKKSVgCiiimAUUUUAFFFF
ABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFAFfy2+0+Z5r7
duNnbPrTYLcxSyyNIX3n5Qf4R6VaoqOSN7i5UQQXEdwjNGThWKnIxyKhFxKt0YpIiEY/u3XkYA53
elWJvM8l/JCmTHyhumfeql+zCzC+a8UjsF3RqWOfb/Gqa6mc20r9jQoqpanMSkROgZdx3nnPvVul
GTa1NU7q4UyQ4Q4YKexPSn1HJGksbI6hlYYIIqgDzFMhjDAuAGK55AOcH9D+VND7IQ8xRCBljngH
vyaS3gW3hWJSzBRjLHJ/Oi4EbQsJV3oRyu0tn8BSW2otbeZMDkZFLTQAAAOAOMVXivIJ5njicOyf
ex0H40OSW4XWxaooopjCiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooo
oAKKKKAK17FcTWcsdrcfZ52XCSlA+0+uD1qZAwQBjuYDk4xk0+igAqJZo5HeNWBZOGA7VLTAiglg
oBPUgdaBO/QJI1lQo4yp61mGbVFuJkFrEYlx5bh8bhnp9cVrUgII4+lQ4Ju/UGr9RrMFUsxAAGST
2psUsc6b43V1PdTkVm6pd7B5MDM0oIZ1Tkhffg8VLBbSx2cQhkjjYnc5EWN2fbsen5URqJycUZe0
fPZK6LkzpHE7yHCKpLfSudFxJIs1vBdxw2pYQ25biQuRkgEnn1//AFVeli1KOZnhWGWV4iokbKqD
nIyuT29Kyrzw1fX8ET3d7GblJxMioDtB7gEn0oqRk4Np6duvyHaUk5q2mlurLuk2d5YTvHcu+JMi
PY2+Mnrk5AIb9Pc1oaXai2hdDCEfcQzYA8zHRsDpXIpaapFfRXE15dRSxQyQpaeZuWXcMDCjng85
9uoxXS6Ta6tb24N1eRtkqRE8W4xqByu4Nyffn8aIxikkla39bkQhFctlsbdVZDdfbIgixm2KnzGJ
O4HtimZuoUXO2diwBKjYFX1xk5q7Vb6HQpBRRRTAKKKKACiiigAooooAKKKKACiiigAooooAKKKK
ACiiigAooooAKKKKACiio33+WfL27u27pSbsrgSUUnOPelpgUrOK7jkuPtMyyIz5iwOVX0NXCcY4
zS0hGRSSstBJWVhapxX8M2oT2a7/ADoFVnyhC4bpg9DVhE2IFyTjuTk1JRF3WoyHyYxKZQihyMFu
5FMdIry2279yNzuRuuD6ipTIgbZuG7GduecfSmRBPs4EACLg7QFwB+FT7vw9yWr6dBkjSmWOONTs
Od0gwduO2PelvIHntZI4pjDKykJKFDFDjqAadbQrb28cS9FGM+p7n8etQ311LbG3EdnLcebMsbGP
H7oH+M57CnGNm2NJsdbQvHGPN2vKAFaXABcAdT/hVuiimlYZBBN50QfY6Z4w4wanoooSaWoltqFF
FFMYUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAV5o
nk8srK0e1skD+IehpYrdImkZM5dtxzzzU9FTyq9xcqvczbiFHuQ8luCfKK+cGwQTxtH1z1q3bQpb
W6Qpu2oMDccmkNvGbjz8tv27cZ4xnPSrFKMUm2TGNm2FFFFWWFFRySpDG0kjKiKMlmOAKcrBlDDo
RkUAOooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKK
KKACiiigAooooAKKKKACiiigCN4klADqrAEMARnkdDUlFFABRRRQAUUUUAFFFFABRRRQAUUUUAFF
FFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUU
UAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQ
AUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFAH/9k=