def make(state_name, spatial_reference):
dest_env_folder = 'E:/Richard/FileGBs/'
dest_env_db = "{}_Cobbler_{}.gdb".format(state_name, datetime.datetime.now().strftime("%m%d"))
dest_env = dest_env_folder + dest_env_db
fcs = [
('GPS_GasMain_Line_Delivered', 'GPS Gas Main Line Delivered'),
('GPS_ServiceLine_G_Line_Delivered', 'GPS Gas Service Line Delivered'),
('GPS_GasMain_Line_Approved', 'GPS Gas Main Line Approved'),
('GPS_ServiceLine_G_Line_Approved', 'GPS Gas Service Line Approved')
]
arcpy.CreateFileGDB_management(dest_env_folder, dest_env_db)
arcpy.env.workspace = dest_env
# create feature class
for fc_pair in fcs:
fc = fc_pair[0]
safe_add_feature_class(dest_env, fc, 'POLYLINE', None, 'DISABLED', 'ENABLED', spatial_reference)
arcpy.AlterAliasName(fc, fc_pair[1])
# add global id
arcpy.AddGlobalIDs_management(fc)
# add fields
field_names = [f.name for f in arcpy.ListFields(fc)]
safe_add_field(fc, "FOOTAGE3D", "DOUBLE", 32, 2, "", "3D Footage", None, None, None, field_names)
safe_add_field(fc, "GPS_POINTCOLLECTIONDATE", "DATE", "", "", "", "GPS Point Collection Date", None, None, None,
field_names)
safe_add_field(fc, "COLLECTIONTYPE", "LONG", 10, 0, "", "Collection Type Category", None, None,
'GPS_Collection_Type',
field_names)
safe_add_field(fc, "FACILITYTYPE", "TEXT", "", "", 50, "Facility Type", None, None, None,
field_names)
safe_add_field(fc, "GPS_OPERATORCOMPANY", "TEXT", "", "", 30, "GPS Collector Company", None, None, None,
field_names)
safe_add_field(fc, "GPS_OPERATORNAME", "TEXT", "", "", 20, "GPS Operator Name", None, None, None, field_names)
safe_add_field(fc, "GPS_JOBORDERNUMBER", "TEXT", "", "", 9, "GPS Job Order Number", None, None, None,
field_names)
safe_add_field(fc, "JOB_FILENAME", "TEXT", "", "", 50, "Job File Name", None, None, None, field_names)
safe_add_field(fc, "REPORT_DATE", "DATE", "", "", "", "Date Used for Reporting", None, None, None, field_names)
safe_add_field(fc, "CREATIONUSER", "TEXT", "", "", 20, "Creation User", None, None, None, field_names)
safe_add_field(fc, "DATECREATED", "DATE", "", "", "", "Date Created", None, None, None, field_names)
safe_add_field(fc, "DATEMODIFIED", "DATE", "", "", "", "Date Modified", None, None, None, field_names)
safe_add_field(fc, "LASTUSER", "TEXT", "", "", 20, "Last User", None, None, None, field_names)
safe_add_field(fc, "ALGORITHM_VERSION", "TEXT", "", "", 15, "Algorithm Version", None, None, None, field_names)
safe_add_field(fc, "GISID", "LONG", 10, 0, "", "GISID", None, None, None, field_names)
safe_add_field(fc, "EQUIPMENT", "TEXT", "", "", 20, "Equipment", None, None, None, field_names)
safe_add_field(fc, "ABANDON_INDICATOR", "TEXT", "", "", 5, "Abandoned Indicator", None, None,
'Yes_No Indicator_G',
field_names)
safe_add_field(fc, "MXASSETUID", "DOUBLE", 12, 0, "", "Maximo Asset Unique ID", None, None, None, field_names)
safe_add_field(fc, "MXASSETNUM", "TEXT", "", "", 20, "Maximo Asset Number", None, None, None, field_names)
safe_add_field(fc, "MXCREATIONSTATE", "SHORT", 5, 0, "", "Maximo Creation State", None, None, None, field_names)
safe_add_field(fc, "WORKREQUESTID", "TEXT", "", "", 20, "Work Request ID", None, None, None, field_names)
safe_add_field(fc, "DESIGNID", "TEXT", "", "", 20, "Design ID", None, None, None, field_names)
safe_add_field(fc, "WORKLOCATIONID", "TEXT", "", "", 20, "Work Location ID", None, None, None, field_names)
safe_add_field(fc, "WORKFLOWSTATUS", "SHORT", 10, 0, "", "Work Flow Status", None, None, 'MM Work Flow Status',
field_names)
safe_add_field(fc, "WORKFUNCTION", "SHORT", 10, 0, "", "Work Function", None, None, None, field_names)
cobb_common.add_index(fc, ["JOB_FILENAME"])
arcpy.EnableEditorTracking_management(fc, "CREATIONUSER", "DATECREATED", "LASTUSER", "DATEMODIFIED",
"ADD_FIELDS",
"UTC")
