class AccChem(BaseRMPModel): id = CopyFromIntegerField( primary_key=True, source_column='accchem_id', verbose_name='Accident Chemical Record ID', help_text='A unique ID for each accident chemical record.', ) accident = CopyFromForeignKey( 'Accident', on_delete=models.PROTECT, help_text='The unique ID for each accident record', ) chemical = CopyFromForeignKey( 'ChemCd', on_delete=models.PROTECT, help_text='The identifying ID for a particular chemical released in an ' 'accident.', ) quantity_lbs = CopyFromIntegerField( null=True, verbose_name='Amount Released (lbs)', help_text='The amount of the substance released in the accident, in ' 'pounds, to two significant digits.', ) percent_weight = CopyFromDecimalField( decimal_places=2, null=True, max_digits=5, verbose_name='Percent Weight (Within Mixture)', help_text='The percent weight of a chemical within a mixture released ' 'in an accident.', ) num_acc_flam = CopyFromIntegerField( null=True, verbose_name='Number of Flammable Components', help_text='The number of listed flammable component chemicals for this' ' chemical record.', ) cas = CopyFromCharField( max_length=9, verbose_name='CAS number', help_text='The identifying CAS number for a chemical.', ) CHEMICAL_TYPE_CHOICES = ( ('T', 'toxic'), ('F', 'flammable'), ) chemical_type = CopyFromCharField( max_length=1, choices=CHEMICAL_TYPE_CHOICES, help_text='"The type of chemical.', ) source_file = 'rmp_acc_chem'
class tblS9EmergencyResponses(BaseRMPModel): FacilityID = CopyFromOneToOneField( 'tblS1Facilities', db_column='FacilityID', on_delete=models.PROTECT, primary_key=True, ) ER_CommunityPlan = CopyFromBooleanField( ) ER_FacilityPlan = CopyFromBooleanField( ) ER_ResponseActions = CopyFromBooleanField( ) ER_PublicInfoProcedures = CopyFromBooleanField( ) ER_EmergencyHealthCare = CopyFromBooleanField( ) ER_ReviewDate = CopyFromCharField( blank=True, max_length=17, ) ERTrainingDate = CopyFromCharField( blank=True, max_length=17, ) CoordinatingAgencyName = CopyFromCharField( max_length=250, blank=True, ) CoordinatingAgencyPhone = CopyFromCharField( source_column='CoordinatingAgencyPhone', max_length=10, blank=True, ) FR_OSHA1910_38 = CopyFromBooleanField( ) FR_OSHA1910_120 = CopyFromBooleanField( ) FR_SPCC = CopyFromBooleanField( ) FR_RCRA = CopyFromBooleanField( ) FR_OPA90 = CopyFromBooleanField( ) FR_EPCRA = CopyFromBooleanField( ) FR_OtherRegulation = CopyFromCharField( max_length=200, blank=True, ) class Meta: verbose_name = 'Emergency Response Plan' verbose_name_plural = 'Emergency Response Plans'
class tlkpDeregistrationReason(BaseRMPModel): LookupCode = CopyFromCharField( primary_key=True, max_length=2, help_text='System generated Unique Primary key.', ) Description = CopyFromCharField( max_length=62, help_text='Deregulation Reason descriptions.' ) class Meta: verbose_name='Lookup: Deregistration Reason'
class tlkpTopographyCode(BaseRMPModel): LookupCode = CopyFromCharField( primary_key=True, max_length=1, help_text='System generated Unique Primary key.', ) Description = CopyFromCharField( max_length=5, help_text='A code representing whether the local topography is urban or rural.', ) class Meta: verbose_name='Lookup: Topography Code'
class tlkpWindSpeedUnitCodes(BaseRMPModel): LookupCode = CopyFromCharField( primary_key=True, max_length=1, help_text='System generated Unique Primary key.', ) Description = CopyFromCharField( max_length=13, help_text='Wind Speed Unit Descriptions.', ) class Meta: verbose_name='Lookup: Wind Speed Unit Codes'
class tlkpSubmissionReasonCodes(BaseRMPModel): LookupCode = CopyFromCharField( primary_key=True, max_length=3, help_text='System generated Unique Primary key.', ) Description = CopyFromCharField( max_length=101, help_text='Submission Reason descriptions.', ) class Meta: verbose_name='Lookup: Submission Reason Code'
class tlkpRejectReason(BaseRMPModel): LookupCode = CopyFromCharField( primary_key=True, max_length=1, help_text='System generated Unique Primary key.', ) Description = CopyFromCharField( max_length=59, help_text='Rejection Reason descriptions.', ) class Meta: verbose_name='Lookup: Reject Reason'
class tlkpDocType(BaseRMPModel): LookupCode = CopyFromCharField( primary_key=True, max_length=1, help_text='Unique identifier of the document type.' ) Description = CopyFromCharField( max_length=30, help_text='Full description of the document type.' ) class Meta: verbose_name='Lookup: Doc Type'
class tlkpS6InitiatingEvents(BaseRMPModel): LookupCode = CopyFromCharField( primary_key=True, max_length=1, help_text='System generated Unique Primary key.', ) Description = CopyFromCharField( max_length=40, help_text='Pick-list text.', ) class Meta: verbose_name='Lookup: Initiating Events'
class tlkpDocHandle(BaseRMPModel): LookupCode = CopyFromCharField( primary_key=True, max_length=1, help_text='Primary Key.', ) Description = CopyFromCharField( max_length=1, help_text='A description of how the document was handled', ) class Meta: verbose_name='Lookup: Deregistration Reason'
class LlmethCd(BaseRMPModel): llmeth = CopyFromCharField( primary_key=True, source_column='Method_Code', max_length=2, ) llmeth_tr = CopyFromCharField(source_column='Method_Desc', max_length=83) @classmethod def get_transform_queryset(self): m = raw_models.tlkpLatLongMethods return m.objects.get_default_transform_queryset()
class tlkpPhysicalStateCodes(BaseRMPModel): LookupCode = CopyFromCharField( primary_key=True, max_length=1, help_text='Physical State description.', ) Description = CopyFromCharField( max_length=30, help_text='System generated Unique Primary key.', ) class Meta: verbose_name='Lookup: Physical State Code'
class tlkpS2ScenarioCodes(BaseRMPModel): LookupCode = CopyFromCharField( primary_key=True, max_length=1, help_text='System generated Unique Primary key.', ) Description = CopyFromCharField( max_length=27, help_text='Pick-list text.', ) class Meta: verbose_name='Lookup: Toxics Scenario Code'
class tlkpLatLongMethods(BaseRMPModel): Primary_Key = CopyFromIntegerField( primary_key=True, ) Method_Code = CopyFromCharField( max_length=2, unique=True, ) Method_Desc = CopyFromCharField( max_length=83 ) class Meta: verbose_name='Lookup: Lat/Long Method'
class tlkpLatLongDescriptions(BaseRMPModel): Feat_Code = CopyFromCharField( primary_key=True, max_length=2, help_text='Unique identifier for each Latitude and longitude ' 'description.', ) Feat_Desc = CopyFromCharField( max_length=36, help_text='Latitude and longitude description.', ) class Meta: verbose_name='Lookup: Lat/Long Description'
class FlammablesWorstCase(BaseRMPModel): id = CopyFromIntegerField( primary_key=True, source_column='flammable_id', ) procchem = CopyFromForeignKey( 'ProcChem', on_delete=models.CASCADE ) analytical_basis = CopyFromCharField(max_length=255, blank=True) # quantity_lbs = CopyFromDecimalField(max_digits=6, decimal_places=2, blank=True) # endpoint_distance = CopyFromDecimalField(max_digits=5, decimal_places=1) quantity_lbs = CopyFromCharField(max_length=20, blank=True) endpoint_distance = CopyFromCharField(max_length=20, blank=True) population = CopyFromCharField(max_length=9, blank=True) pr_schools = CopyFromBooleanField() pr_residences = CopyFromBooleanField() pr_hospitals = CopyFromBooleanField() pr_prisons = CopyFromBooleanField() pr_public_rec = CopyFromBooleanField() pr_comm_ind = CopyFromBooleanField() pr_othertype = CopyFromCharField(max_length=200, blank=True) er_natlstateparks = CopyFromBooleanField() er_wildlife_sanct = CopyFromBooleanField() er_fedwilderness = CopyFromBooleanField() er_othertype = CopyFromCharField(max_length=200, blank=True) pm_blastwalls = CopyFromBooleanField() pm_othertype = CopyFromCharField(max_length=200, blank=True) ptrgraphic = CopyFromCharField(max_length=12, blank=True) cbi_flag = CopyFromBooleanField() source_file = 'rmp_worst_flam'
class tlkpNAICS(BaseRMPModel): NAICS_CODE = CopyFromCharField( primary_key=True, max_length=6, verbose_name='NAICS Code', help_text='The 5- or 6- digit NAICS code.', ) NAICS_DESCRIPTION = CopyFromCharField( max_length=118, verbose_name='NAICS Description', help_text='Description text for the NAICS code.', ) class Meta: verbose_name = 'Lookup: NAICS codes'
class tlkpDocType(BaseRMPModel): lookupcode = CopyFromCharField( source_column='LookupCode', primary_key=True, max_length=1, help_text='Unique identifier of the document type.') description = CopyFromCharField( max_length=30, source_column='Description', help_text='Full description of the document type.') source_file = 'tlkpDocType' class Meta: verbose_name = 'Lookup: Doc Type'
class tlkpDeregistrationReason(BaseRMPModel): lookupcode = CopyFromCharField( primary_key=True, max_length=2, source_column='LookupCode', help_text='System generated Unique Primary key.', ) dereg_tr = CopyFromCharField(max_length=62, source_column='Description', help_text='Deregulation Reason descriptions.') source_file = 'tlkpDeregistrationReason' class Meta: verbose_name = 'Lookup: Deregistration Reason'
class DochanCd(BaseRMPModel): dochan = CopyFromCharField( source_column='LookupCode', primary_key=True, max_length=1, ) dochan_tr = CopyFromCharField( source_column='Description', max_length=1, ) @classmethod def get_transform_queryset(self): m = raw_models.tlkpDocHandle return m.objects.get_default_transform_queryset()
class Process(BaseRMPModel): id = CopyFromIntegerField( primary_key=True, source_column='process_id', ) process_desc = CopyFromCharField(max_length=25, blank=True) rmp_id = CopyFromIntegerField() program_level = CopyFromIntegerField() cbi_flag = CopyFromBooleanField() # TODO AGGREGATE num_proc_chem = CopyFromIntegerField() num_proc_naics = CopyFromIntegerField() num_chem_real = CopyFromIntegerField() num_chem_fake = CopyFromIntegerField() num_worst_tox = CopyFromIntegerField() num_worst_flam = CopyFromIntegerField() num_alt_tox = CopyFromIntegerField() num_alt_flam = CopyFromIntegerField() num_prev_2 = CopyFromIntegerField() num_prev_3 = CopyFromIntegerField() toxic_tot = CopyFromBigIntegerField() flam_tot = CopyFromBigIntegerField() quantity_tot = CopyFromBigIntegerField() # while these fields are listed in rmp_fields.csv, they do not appear in # rmp_process.tsv ¯\_(ツ)_/¯ # chem_tox_yn = CopyFromBooleanField() # chem_flam_yn = CopyFromBooleanField() source_file = 'rmp_process'
class ProcChem(BaseRMPModel): procchem_id = CopyFromBigIntegerField( primary_key=True, source_column='procchem_id', ) process = CopyFromForeignKey( 'Process', on_delete=models.CASCADE ) chemical = CopyFromForeignKey( 'ChemCd', on_delete=models.CASCADE ) quantity_lbs = CopyFromBigIntegerField() cbi_flag = CopyFromBooleanField() num_alt_flam = CopyFromBigIntegerField() num_alt_tox = CopyFromBigIntegerField() num_prevent_2_chem = CopyFromBigIntegerField() num_prevent_3_chem = CopyFromBigIntegerField() num_proc_flam = CopyFromBigIntegerField() num_worst_flam = CopyFromBigIntegerField() num_worst_tox = CopyFromBigIntegerField() cas = CopyFromBigIntegerField() chemical_type = CopyFromCharField(max_length=1) source_file = 'rmp_proc_chem'
class LldescCd(BaseRMPModel): lldesc = CopyFromCharField( source_column='Feat_Code', primary_key=True, max_length=2, ) lldesc_tr = CopyFromCharField( source_column='Feat_Desc', max_length=36, ) @classmethod def get_transform_queryset(self): m = raw_models.tlkpLatLongDescriptions return m.objects.get_default_transform_queryset()
class tblS7PreventionProgram3Description_ChangeHistory(BaseRMPModel): preventionprogram3descchangehistoryid = CopyFromIntegerField( primary_key=True, source_column='PreventionProgram3DescChangeHistoryID', ) facilitychangehistoryid = CopyFromIntegerField( source_column='FacilityChangeHistoryID', ) cdxcorrectioncode = CopyFromCharField( max_length=1, source_column='CDXCorrectionCode', ) preventionprogram3id = CopyFromForeignKey( 'tblS7PreventionProgram3', on_delete=models.PROTECT, source_column='PreventionProgram3ID', ) description = CopyFromTextField( source_column='Description', blank=True, ) olddescription = CopyFromTextField( source_column='OldDescription', blank=True, ) seqnum = CopyFromIntegerField(source_column='SeqNum', )
class tlkpLatLongMethods(BaseRMPModel): primary_key = CopyFromIntegerField( primary_key=True, source_column='Primary_Key', ) method_code = CopyFromCharField( source_column='Method_Code', max_length=2, unique=True, ) method_desc = CopyFromCharField(source_column='Method_Desc', max_length=83) source_file = 'tlkpLatLongMethods' class Meta: verbose_name = 'Lookup: Lat/Long Method'
class ScenCd(BaseRMPModel): """ Accident(?) scenario. """ scen = CopyFromCharField(source_column='LookupCode', primary_key=True, max_length=1, help_text='Unique identifier of the scenario.') scen_tr = CopyFromCharField(source_column='Description', max_length=27, help_text='Full description of the scenario.') @classmethod def get_transform_queryset(self): m = raw_models.tlkpS2ScenarioCodes return m.objects.get_default_transform_queryset()
class tlkpS6InitiatingEvents(BaseRMPModel): lookupcode = CopyFromCharField( primary_key=True, source_column='LookupCode', max_length=1, help_text='System generated Unique Primary key.', ) description = CopyFromCharField( source_column='Description', max_length=40, help_text='Pick-list text.', ) source_file = 'tlkpS6InitiatingEvents' class Meta: verbose_name = 'Lookup: Initiating Events'
class ChemCd(BaseRMPModel): id = CopyFromIntegerField( source_column='ChemicalID', primary_key=True, help_text="RMP's unique identifier of a chemical substance.", ) chemical_name = CopyFromCharField( max_length=92, help_text="Chemical substance name.", ) cas2 = CopyFromCharField( source_column='CASNumber', max_length=10, blank=True, help_text="Chemical Abstracts Service (CAS) registry number " "(is 2 meaningful?)", ) threshold = CopyFromDecimalField( source_column='threshold', null=True, decimal_places=1, max_digits=8, help_text='Threshold above which the chemical is regulated???') chemical_type = CopyFromCharField( source_column='ChemType', max_length=1, choices=CHEMICAL_TYPES, blank=True, help_text='"The type of chemical (T=toxic, F=Flammable).', ) cbi_flag = CopyFromBooleanField( source_column='flgCBI', help_text='Indicates whether this record contained Confidential ' 'Business Information (CBI) which has been erased by EPA ' 'from the public version of the data.') chemical_owner = CopyFromCharField( source_column='ChemOwner', max_length=3, blank=True, ) @classmethod def get_transform_queryset(self): m = raw_models.tlkpChemicals return m.objects.get_default_transform_queryset()
class tlkpWindSpeedUnitCodes(BaseRMPModel): lookupcode = CopyFromCharField( primary_key=True, source_column='LookupCode', max_length=1, help_text='System generated Unique Primary key.', ) description = CopyFromCharField( source_column='Description', max_length=13, help_text='Wind Speed Unit Descriptions.', ) source_file = 'tlkpWindSpeedUnitCodes' class Meta: verbose_name = 'Lookup: Wind Speed Unit Codes'
class tlkpRejectReason(BaseRMPModel): lookupcode = CopyFromCharField( primary_key=True, source_column='LookupCode', max_length=1, help_text='System generated Unique Primary key.', ) description = CopyFromCharField( source_column='Description', max_length=59, help_text='Rejection Reason descriptions.', ) source_file = 'tlkpRejectReason' class Meta: verbose_name = 'Lookup: Reject Reason'