20240529
10551300
1.0
FALSE
CIO_GIS.CIO.FireStations
002
0.000
Server=gissqlcatag1.stone.ne.gov; Service=sde:sqlserver:gissqlcatag1.stone.ne.gov; Database=CIO_GIS; User=cio; Version=sde.DEFAULT
ArcSDE Connection
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.2.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]],VERTCS["WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PARAMETER["Vertical_Shift",0.0],PARAMETER["Direction",1.0],UNIT["Meter",1.0],AUTHORITY["Esri",115700]]</WKT><XOrigin>-400</XOrigin><YOrigin>-400</YOrigin><XYScale>1111948722.2222221</XYScale><ZOrigin>-193.74182350000001</ZOrigin><ZScale>10000</ZScale><MOrigin>-100000</MOrigin><MScale>10000</MScale><XYTolerance>8.983152841195215e-09</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><LeftLongitude>-180</LeftLongitude><WKID>4326</WKID><LatestWKID>4326</LatestWKID><VCSWKID>115700</VCSWKID><LatestVCSWKID>115700</LatestVCSWKID></GeographicCoordinateSystem>
CopyFeatures in_memory/table_merged_intermediate C:\Users\Joseph.Stevenson\Downloads\NEFireStations_CSVconvert.shp # # # #
AddSpatialIndex C:\Users\Joseph.Stevenson\Downloads\NEFireStations_CSVconvert.shp 0 0 0
XYTableToPoint C:\Users\Joseph.Stevenson\Downloads\ne-fire-stations.csv C:\Users\Joseph.Stevenson\Downloads\NEFireStations_CSVconvert.shp long lat elev "GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],VERTCS["WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PARAMETER["Vertical_Shift",0.0],PARAMETER["Direction",1.0],UNIT["Meter",1.0]];-400 -400 1000000000;-100000 10000;-100000 10000;8.98315284119521E-09;0.001;0.001;IsHighPrecision"
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.2.0'><WorkspaceConnectionString>DATABASE=C:\Users\Joseph.Stevenson\Downloads</WorkspaceConnectionString><WorkspaceFactory>Shapefile</WorkspaceFactory><Dataset>NEFireStations_CSVconvert</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>Address</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_is_nullable>False</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>Address_2</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_is_nullable>False</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>City</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_is_nullable>False</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>State</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_is_nullable>False</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>ZipCode</field_name><field_type>LONG</field_type><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/3.2.0'><WorkspaceConnectionString>DATABASE=C:\Users\Joseph.Stevenson\Downloads</WorkspaceConnectionString><WorkspaceFactory>Shapefile</WorkspaceFactory><Dataset>NEFireStations_CSVconvert</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>County</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_is_nullable>False</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>FDPhone</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_is_nullable>False</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>FDEmail</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_is_nullable>False</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>Chief</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_is_nullable>False</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>ChiefEmail</field_name><field_type>TEXT</field_type><field_length>255</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/3.2.0'><WorkspaceConnectionString>DATABASE=C:\Users\Joseph.Stevenson\Downloads</WorkspaceConnectionString><WorkspaceFactory>Shapefile</WorkspaceFactory><Dataset>NEFireStations_CSVconvert</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>Zip</field_name><field_type>TEXT</field_type><field_length>255</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/3.2.0'><WorkspaceConnectionString>DATABASE=C:\Users\Joseph.Stevenson\Downloads</WorkspaceConnectionString><WorkspaceFactory>Shapefile</WorkspaceFactory><Dataset>NEFireStations_CSVconvert</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><DeleteField><field_name>ZipCode</field_name></DeleteField></workflow></operationSequence>
CalculateGeometryAttributes NEFireStations_CSVconvert "lat POINT_Y;long POINT_X" # # # "Same as input"
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.2.0'><WorkspaceConnectionString>DATABASE=C:\Users\Joseph.Stevenson\Downloads</WorkspaceConnectionString><WorkspaceFactory>Shapefile</WorkspaceFactory><Dataset>NEFireStations_CSVconvert</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>Field</field_name><field_type>LONG</field_type><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/3.2.0'><WorkspaceConnectionString>DATABASE=C:\Users\Joseph.Stevenson\Downloads</WorkspaceConnectionString><WorkspaceFactory>Shapefile</WorkspaceFactory><Dataset>NEFireStations_CSVconvert</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>OptStatus</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_is_nullable>False</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>
CalculateField FireStations OptStatus "IN" VBScript # Text NO_ENFORCE_DOMAINS
CalculateField FireStations OptStatus "IN" VBScript # Text NO_ENFORCE_DOMAINS
CalculateField FireStations County UCase([County]) VBScript # Text NO_ENFORCE_DOMAINS
CalculateField FireStations City UCase([City]) VBScript # Text NO_ENFORCE_DOMAINS
CalculateField FireStations Address UCase([Address]) VBScript # Text NO_ENFORCE_DOMAINS
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.2.0'><WorkspaceConnectionString>DATABASE=C:\Users\Joseph.Stevenson\Downloads</WorkspaceConnectionString><WorkspaceFactory>Shapefile</WorkspaceFactory><Dataset>NEFireStations_CSVconvert</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>IS_247</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_is_nullable>False</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>
CalculateField FireStations IS_247 "NO" VBScript # Text NO_ENFORCE_DOMAINS
CopyFeatures FireStations \\stngisnas01.stone.ne.gov\GIS_NESDI\cio\DailyArcGISProSQLConnectionCheck\SQLServer-gissqlcatag1-CIO_GIS(cio).sde\CIO_GIS.CIO.FireStations # # # #
20240611
13335400
20240611
13335400
Microsoft Windows 10 Version 10.0 (Build 19045) ; Esri ArcGIS 13.2.2.49743
Nebraska Fire Stations
Fire
Fire Stations
Statewide
Nebraska
Statewide fire station locations with Safe Haven opt status.
Enterprise Geodatabase Feature Class
0.000
dataset
EPSG
6.2(3.0.1)
0
Simple
FALSE
0
TRUE
TRUE
CIO_GIS.CIO.FireStations
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.
Address
Address
String
254
0
0
Address_2
Address_2
String
254
0
0
City
City
String
254
0
0
State
State
String
254
0
0
County
County
String
254
0
0
FDPhone
FD Phone
String
254
0
0
FDEmail
FD Email
String
254
0
0
Zip
Zip
String
254
0
0
OptStatus
Safe Haven Opt Status
String
254
0
0
IS_247
IS_247
String
254
0
0
name
Name
String
254
0
0
20240611