Well Table

- deleted indexes FIPS_MUNICIPALITY_2, ..., FIPS_MUNICIPALITY_5

- deleted row where WELL_API=/ and row where well_api was blank

- deleted LATITUDE_UNCONVENTIONAL column (all values were NULL except for one, which was 0)

- deleted LONGITUDE_UNCONVENTIONAL column (all values were NULL except for one, which was 3)

- deleted UNCONVENTIONAL_UNCONVENTIONAL column (all values were NULL except for one, which was O)

- deleted HORIZONTAL_UNCONVENTIONAL column (all values NULL)

- deleted PERMIT_STATUS column (all values NULL)

- in UNCONVENTIONAL table, changed 236 rows from 'Yes' to 'Y' and 439 rows from 'No' to 'N'. There was some type of return character on the ends of 'Yes' and 'No' making searches hard. Code example:

UPDATE well

SET UNCONVENTIONAL='Y'

WHERE UNCONVENTIONAL LIKE 'Yes%'

- changed all dates '0000-00-00' to NULL

Waste Table

- deleted row of blanks, nulls, and 0's. WELL_API was simply a blank.

Wellpad Table

- deleted row of almost all blanks

- replaced all by NULL in table

- changed all dates '0000-00-00' to NULL

Production Table

- changed all dates '0000-00-00' to NULL

Permit Table

- there were two equivalent columns : PERMIT_ISSUED_DATE and permit_issue_date. Since a search revealed that the latter was unused, it has been dropped from the table.

- removed ' Well' from the ends of entries in the configuration column, since not all entries had this appended

Compliance Table

- in INSP_CATEGORY, changed blank entries to NULL and filled out 319,409 existing erroneous entries 'Primary Fa' to 'Primary Facility'

- changed blank entries to NULL in INSP_ID, INSPECTION_TYPE, INSPECTION_RESULT_DESC, INSP_COMMENT, DB_COMMENTS