20210521
12205200
1.0
FALSE
CalculateField Handrails HYPERLINK ""Handrail_Images/" + [IMAGE]" VB #
CopyFeatures Y:\TNR-GIS-RoadMaint\Travis_County_Assets\Travis_County.gdb\Assets\Handrails C:\Users\DilberS\AppData\Roaming\Esri\ArcGISPro\Favorites\TC_User_Public_Works.sde\PublicWorks.TC_USER.Assets\PublicWorks.TC_USER.Handrails # # # #
UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' 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.7.0'><FeatureDataset>PublicWorks.TC_USER.Assets</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e686669526168626c4f572f583552627a465555667744664a67552f6c7543365345416153634a3852795154773d2a00;SERVER=TNR-GISSQL19-P;INSTANCE=sde:sqlserver:TNR-GISSQL19-P;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=TNR-GISSQL19-P;DATABASE=PublicWorks;USER=TC_User;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>PublicWorks.TC_USER.Handrails</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AssignDomainToField><field_name>CONDITION</field_name><domain_name>Condition</domain_name></AssignDomainToField></workflow></operationSequence>
CalculateField "ASSETS - Public Works -PROD\PublicWorks.TC_USER.Handrails" ASSET_ID ""RM-HND-"& [OBJECTID]" VB #
CalculateField PublicWorks.TC_USER.Handrails ASSET_ID ""RM-HND-"+str (!OBJECTID!).zfill(6)" PYTHON_9.3 #
FeatureClassToFeatureClass Handrails Y:\VIEWERS\Public_Works\Public_Work_Services\Public_Work_Services.gdb Handrails_reordered # "ASSET_ID "ASSET_ID" true true true 50 Text 0 0,First,#,Handrails,ASSET_ID,0,50;GISID "GISID" true true false 25 Text 0 0,First,#,Handrails,GISID,0,25;STREET "STREET" true true false 250 Text 0 0,First,#,Handrails,STREET,0,250;CONDITION "CONDITION" true true false 150 Text 0 0,First,#,Handrails,CONDITION,0,150;COMMENTS "COMMENTS" true true false 250 Text 0 0,First,#,Handrails,COMMENTS,0,250;HYPERLINK "HYPERLINK" true true false 150 Text 0 0,First,#,Handrails,HYPERLINK,0,150;IMAGE "IMAGE" true true false 150 Text 0 0,First,#,Handrails,IMAGE,0,150;GlobalID "GlobalID" false false true 38 GlobalID 0 0,First,#,Handrails,GlobalID,-1,-1;created_user "created_user" false true false 255 Text 0 0,First,#,Handrails,created_user,0,255;created_date "created_date" false true false 8 Date 0 0,First,#,Handrails,created_date,-1,-1;last_edited_user "last_edited_user" false true false 255 Text 0 0,First,#,Handrails,last_edited_user,0,255;last_edited_date "last_edited_date" false true false 8 Date 0 0,First,#,Handrails,last_edited_date,-1,-1" #
CopyFeatures Y:\VIEWERS\Public_Works\Public_Work_Services\Public_Work_Services.gdb\Handrails_reordered C:\Users\DilberS\AppData\Roaming\Esri\ArcGISPro\Favorites\TC_User_Public_Works.sde\PublicWorks.TC_USER.Assets\PublicWorks.TC_USER.Handrails_reordered # # # #
Rename C:\Users\DilberS\AppData\Roaming\Esri\ArcGISPro\Favorites\TC_User_Public_Works.sde\PublicWorks.TC_USER.Assets\PublicWorks.TC_USER.Handrails_reordered C:\Users\DilberS\AppData\Roaming\Esri\ArcGISPro\Favorites\TC_User_Public_Works.sde\PublicWorks.TC_USER.Assets\PublicWorks.TC_USER.Handrails FeatureClass
PublicWorks.TC_USER.Handrails_1
002
Server=TNR-GISSQL19-P; Service=sde:sqlserver:TNR-GISSQL19-P; Database=PublicWorks; User=TC_User; Version=sde.DEFAULT
ArcSDE Connection
2992395.708815
3212185.676387
10009798.516053
10179366.991548
1
Projected
GCS_North_American_1983
Linear Unit: Foot_US (0.304801)
NAD_1983_StatePlane_Texas_Central_FIPS_4203_Feet
<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/10.8'><WKT>PROJCS["NAD_1983_StatePlane_Texas_Central_FIPS_4203_Feet",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["Lambert_Conformal_Conic"],PARAMETER["False_Easting",2296583.333333333],PARAMETER["False_Northing",9842500.0],PARAMETER["Central_Meridian",-100.3333333333333],PARAMETER["Standard_Parallel_1",30.11666666666667],PARAMETER["Standard_Parallel_2",31.88333333333333],PARAMETER["Latitude_Of_Origin",29.66666666666667],UNIT["Foot_US",0.3048006096012192],AUTHORITY["EPSG",2277]]</WKT><XOrigin>-124805500</XOrigin><YOrigin>-81923100</YOrigin><XYScale>3048.0060960121928</XYScale><ZOrigin>0</ZOrigin><ZScale>1</ZScale><MOrigin>0</MOrigin><MScale>1</MScale><XYTolerance>0.0032808333333333331</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>102739</WKID><LatestWKID>2277</LatestWKID></ProjectedCoordinateSystem>
20230412
17335500
20230412
17335500
150000000
5000
ItemDescription
Version 6.2 (Build 9200) ; Esri ArcGIS 10.8.1.14362
Travis_County_Road_Handrails
TNR handrail inventory. Original features gathered by Data Transfer Solutions, LLC in 2021.
travis county
public works
road
maintenance
handrail
This product is for informational purposes and may not have been prepared for or be suitable for legal, engineering, or surveying purposes. It does not represent an on-the-ground survey and represents only the approximate relative location of property boundaries. Travis County has produced this product for reference purposes only and offers no warranties for the product’s accuracy or completeness.
1
-98.132740
-97.423882
30.573877
30.093882
Data Transfer Solutions, LLC; Travis County Transportation & Natural Resources
SDE Feature Class
dataset
EPSG
5.3(9.0.0)
0
Simple
FALSE
0
TRUE
FALSE
PublicWorks.TC_USER.Handrails_1
Feature Class
0
OBJECTID
OBJECTID
OID
4
10
0
Internal feature number.
Esri
Sequential unique whole numbers that are automatically generated.
IMAGE
IMAGE
String
150
0
0
ASSET_ID
ASSET_ID
String
50
0
0
STREET
STREET
String
250
0
0
CONDITION
CONDITION
String
150
0
0
GISID
GISID
String
25
0
0
COMMENTS
COMMENTS
String
250
0
0
HYPERLINK
HYPERLINK
String
150
0
0
SHAPE
Shape
Geometry
4
0
0
Feature geometry.
Esri
Coordinates defining the features.
created_user
created_user
String
255
0
0
created_date
created_date
Date
8
0
0
last_edited_user
last_edited_user
String
255
0
0
last_edited_date
last_edited_date
Date
8
0
0
Shape.STLength()
Shape.STLength()
Double
0
0
0
20230412
/9j/4AAQSkZJRgABAQEAAQABAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0a
HBwgJC4nICIsIxwcKDcpLDAxNDQ0Hyc5PTgyPC4zNDL/2wBDAQkJCQwLDBgNDRgyIRwhMjIyMjIy
MjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/wAARCACFAMgDASIA
AhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQA
AAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3
ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWm
p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEA
AwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSEx
BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElK
U1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3
uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD3+iii
gAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKA
CiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAK
KKKACiiigAooooAKKKKACiim45J9fegB1FFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAU
UUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRR
RQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQBHGXMamRQrkcqDkA/WpKKKACiiigAooooAKKKKACii
igAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKK
ACiiigAooooAKKQ9Dxn2paACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiig
AooooAKKKKACiiigAooooAKaowAOePU5p1FABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUU
UUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAf/9k=