20190813
15574500
1.0
FALSE
Horizon.DBO.TrafficCameras
002
Server=GISdb; Service=sde:sqlserver:GISdb; Database=Horizon; User=gisowner; Version=dbo.DEFAULT
ArcSDE Connection
3104853.466655
3169104.747601
13758726.817690
13776266.452230
1
Projected
GCS_North_American_1983
Linear Unit: Foot_US (0.304801)
NAD_1983_StatePlane_Texas_South_Central_FIPS_4204_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/2.6.0'><WKT>PROJCS["NAD_1983_StatePlane_Texas_South_Central_FIPS_4204_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",1968500.0],PARAMETER["False_Northing",13123333.33333333],PARAMETER["Central_Meridian",-99.0],PARAMETER["Standard_Parallel_1",28.38333333333333],PARAMETER["Standard_Parallel_2",30.28333333333333],PARAMETER["Latitude_Of_Origin",27.83333333333333],UNIT["Foot_US",0.3048006096012192],AUTHORITY["EPSG",2278]]</WKT><XOrigin>-126725700</XOrigin><YOrigin>-77828800</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>102740</WKID><LatestWKID>2278</LatestWKID></ProjectedCoordinateSystem>
FeatureClassToFeatureClass TrafficCameras "\\gisapp\Workspace\GIS Staff Workspace\MMasters\test\Default.gdb" hopethisworks # "Street "Street" true true false 50 Text 0 0,First,#,TrafficCameras,Street,0,50;CrossStreet "CrossStreet" true true false 50 Text 0 0,First,#,TrafficCameras,CrossStreet,0,50;Corner "Corner" true true false 50 Text 0 0,First,#,TrafficCameras,Corner,0,50;GlobalID "GlobalID" false false false 38 GlobalID 0 0,First,#,TrafficCameras,GlobalID,-1,-1;CameraLink "CameraLink" true true false 500 Text 0 0,First,#,TrafficCameras,CameraLink,0,500" #
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=\\gisapp\Workspace\GIS Staff Workspace\MMasters\test\Default.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>hopethisworks</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>CameraLink2</field_name><field_type>TEXT</field_type><field_length>500</field_length><field_alias>CameraLink2</field_alias><field_is_nullable>True</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=\\gisapp\Workspace\GIS Staff Workspace\MMasters\test\Default.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>hopethisworks</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>Status</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_alias>Status</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>Status</field_domain></AddField></workflow></operationSequence>
CalculateField "Traffic Cameras" Status "Active" "Python 3" #
CalculateField "Traffic Cameras" Status "Inactive" "Python 3" #
AddXY "Traffic Cameras"
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=\\gisapp\Workspace\GIS Staff Workspace\MMasters\test\Default.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>hopethisworks</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>Latitude</field_name><field_type>DOUBLE</field_type><field_alias>Latitude</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>Longitude</field_name><field_type>DOUBLE</field_type><field_alias>Longitude</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>
CalculateGeometryAttributes "Traffic Cameras" "Latitude POINT_Y;Longitude POINT_X" # # PROJCS['NAD_1983_StatePlane_Texas_South_Central_FIPS_4204_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',1968500.0],PARAMETER['False_Northing',13123333.33333333],PARAMETER['Central_Meridian',-99.0],PARAMETER['Standard_Parallel_1',28.38333333333333],PARAMETER['Standard_Parallel_2',30.28333333333333],PARAMETER['Latitude_Of_Origin',27.83333333333333],UNIT['Foot_US',0.3048006096012192]]
CalculateGeometryAttributes "Traffic Cameras" "Latitude POINT_Y;Longitude POINT_X" # # 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]]
CalculateField hopethisworks Latitude 1 VB #
CalculateField hopethisworks Longitude 1 VB #
CalculateGeometryAttributes "Traffic Cameras" "Latitude POINT_Y;Longitude POINT_X" # # 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]] "Same as input"
CalculateGeometryAttributes "Traffic Cameras" "Latitude POINT_Y;Longitude 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]] "Same as input"
CalculateGeometryAttributes "Traffic Cameras" "Latitude POINT_Y;Longitude POINT_X" # # # "Decimal Degrees"
CalculateGeometryAttributes "Traffic Cameras" "Latitude POINT_Y;Longitude POINT_X" # # # "Decimal Degrees"
FeatureClassToFeatureClass "Traffic Cameras" "\\gisapp\Workspace\GIS Staff Workspace\JAlexander\Projects\Default\JAOwner@horizon.sde\Horizon.DBO.Transportation" TrafficCameras # "Street "Street" true true false 50 Text 0 0,First,#,Traffic Cameras,Street,0,50;CrossStreet "CrossStreet" true true false 50 Text 0 0,First,#,Traffic Cameras,CrossStreet,0,50;Corner "Corner" true true false 50 Text 0 0,First,#,Traffic Cameras,Corner,0,50;GlobalID "GlobalID" false false false 38 GlobalID 0 0,First,#,Traffic Cameras,GlobalID,-1,-1;CameraLink "CameraLink" true true false 500 Text 0 0,First,#,Traffic Cameras,CameraLink,0,500;CameraLink2 "CameraLink2" true true false 500 Text 0 0,First,#,Traffic Cameras,CameraLink2,0,500;Status "Status" true true false 255 Text 0 0,First,#,Traffic Cameras,Status,0,255;Latitude "Latitude" true true false 8 Double 0 0,First,#,Traffic Cameras,Latitude,-1,-1;Longitude "Longitude" true true false 8 Double 0 0,First,#,Traffic Cameras,Longitude,-1,-1" #
CalculateGeometryAttributes "Traffic Cameras" "Latitude POINT_X;Longitude POINT_Y" # # # "Same as input"
CalculateGeometryAttributes "Traffic Cameras" "Latitude POINT_X;Longitude POINT_Y" # # 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]] "Same as input"
CalculateGeometryAttributes "Traffic Cameras" "Latitude POINT_X;Longitude POINT_Y" # # # "Decimal Degrees"
CalculateGeometryAttributes "Traffic Cameras" "Latitude POINT_Y;Longitude POINT_X" # # # "Decimal Degrees"
CalculateGeometryAttributes "Traffic Cameras" "Latitude POINT_Y;Longitude POINT_X" # # # "Decimal Degrees"
CalculateGeometryAttributes "Traffic Cameras" "Longitude POINT_X;Latitude POINT_Y" # # # "Decimal Degrees"
CalculateGeometryAttributes "Traffic Cameras" "Latitude POINT_X;Longitude POINT_Y" # # # "Decimal Degrees"
CalculateGeometryAttributes "Traffic Cameras" "Latitude POINT_Y;Longitude POINT_X" # # # "Decimal Degrees"
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>Horizon.DBO.Transportation</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e68364868672f6b4434444f556e6c7476736974597574413d3d2a00;SERVER=GISdb;INSTANCE=sde:sqlserver:GISdb;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GISdb;DATABASE=Horizon;USER=gisowner;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>Horizon.DBO.TrafficCameras</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AddField><field_name>CameraLink3</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>255</field_length><field_alias>CameraLink3</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>
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>Horizon.DBO.Transportation</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e68364868672f6b4434444f556e6c7476736974597574413d3d2a00;SERVER=GISdb;INSTANCE=sde:sqlserver:GISdb;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GISdb;DATABASE=Horizon;USER=gisowner;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>Horizon.DBO.TrafficCameras</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AddField><field_name>CameraLink3</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>255</field_length><field_alias>CameraLink3</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>
20201015
11082800
20201015
11082800
Microsoft Windows 10 Version 10.0 (Build 18363) ; Esri ArcGIS 12.6.2.24783
Traffic Cameras
1
-95.425839
-95.222106
29.581278
29.527512
Traffic
Camera
Traffic Camera
Live
Live Traffic Cameras
Enterprise Geodatabase Feature Class
dataset
EPSG
6.11(9.0.0)
0
Simple
FALSE
0
TRUE
FALSE
Horizon.DBO.TrafficCameras
Feature Class
0
OBJECTID
OBJECTID
OID
4
10
0
Internal feature number.
Esri
Sequential unique whole numbers that are automatically generated.
Shape
Shape
Geometry
8
0
0
Feature geometry.
Esri
Coordinates defining the features.
Street
Street
String
50
0
0
CrossStreet
CrossStreet
String
50
0
0
Corner
Corner
String
50
0
0
GlobalID
GlobalID
GlobalID
38
0
0
CameraLink2
CameraLink2
String
500
0
0
Status
Status
String
255
0
0
Latitude
Latitude
Double
8
38
8
Longitude
Longitude
Double
8
38
8
CameraLink
CameraLink
String
500
0
0
20201015
/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
ooAKKKKACiiigAooooAKKKKACiiigAoorP1XVYdJgWaYMVJxwKANCio4ZVmhSRejDIqSgAooooAK
KKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAoo
ooAKKKKACsrXjdixzZWyTy5+6/StWigCC1MhtYzKgSTb8yjtU9FFABRRRQAUUUUAFFFFABRRRQAU
UUUAFFFFABRRRQAUUUUAFFFFADWOFJAyQKxLHWZ3jvZb+2a3igYhWP8AEOea3ajkijljaN1BVuo9
aBENhfwajarcW7boz0NVY9Zgnv57GLJniUnFX4LeK2iEcKBEHYUi28KTNKsaiRurY5NAGfo1xqNw
Lj+0LcQlXxHjuOaLe21NdZlmlnU2ZHyp3BrWop3CwUUUUhhRRRQAUUUUAFFFFABRRRQAVHLNHBGZ
JWCoOpNSVma/BJc6NcRRxCV2XhCcZoAvxSxzxiSNgynoRT6yfDyPBpEEU8axSAfcBzWtQCFooooA
KKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKAEorD1LxLbabfNavHIzqm/5R
mk0bxGmsCcx28qeUM/MuM07CujepK5KPxhcytKq6VPlBxletWodd1Ca8ihGmuqPHuLEdDjpRZhzI
6OlrlbK01rUNTjvLyQ2qRMR5K8hxXTsu9Cp6EYoBO4xbiF22rKhb0DDNTVy1t4MtrXWF1FLy6Lhi
2wyNt6+ma6mhgr9StLfW0E6QyzIsj/dUnk0Xl9b2EBnuZVjjBxuY4qvd6NZ3t9DeTITNF90g1Nfa
dbalb+RdRiSPOcGgNRr6pZRtCrXCAzcpz96rZYBS3YDNUZNFsJXgZ4ATAMR+1X8DGO1IDlb/AMZW
vmyWViHe9yVUFTjNbFoL280bbd/ubl1IJXtVhdNskm81bWESZzu2DNWqYJPqcrH4b1CCWOddTkd4
lOFJOGPNQN4mvNBjjj1mB5GY8yRKSAP1rsqhmt4bhCk0SOp7MoNF+4W7FXTdXstWhMtpMrhcbhnp
9a0Kwbjw3DHp89vpj/Y3mbczoO9S3l3PomkQny3u5BhTgcn3o9Av3NmiobaUz20cpUqWUHae1TUh
hRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFAEL20Mj73iRmxjJFOSGKLOxFXPoKk
ooAYIowchFH4U7aB2H5UtFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABTSoYYYAj3qhrF7cWFl5t
vAZnzjaKt2sjzW0cjpsZhkr6UATUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAU
UUUAFFFFABRRRQAUUUUAFFFFAENxcw2qB55FRScZJqRWV1DKcg8g1U1HTLfU4BFcAlQc8GrMMSww
pGn3VGBQBXvtRtdPRWupRGGOBn1qyjrIgdTlSMg1BeWFtfqq3EQcKcjNWEUIgVRgDgCgClqeq22k
24nuWIQnHApl9rFvYael5IGMbgEbRzzV2a3iuE2TIrr6EUNBE8YjaNSg6AjimLULeZbiBJkztcZG
alpqqFUBRgDsKdSGJjPWloooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKK
KACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAoooo
AKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigA
ooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACi
iigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKK
KACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAoooo
AKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigA
ooooAKKKKACiiigAooooAKKKKAP/2Q==