Removing 14 digit API entries from wikiManagerPages: delete from wikiManagerPages where page_name regexp binary '31-[0-9]{3}-[0-9]{5}-[0-9]{4}'

These entries were also exported to a text file such that they could be mass deleted: cd /var/lib/mediawiki/maintenance/ php deleteBatch.php ~/garbagePagesNY.txt

Well

An additional 228 wells were added to the database.

Town->Municipality Surface coordinates used for longitude/latitude

LOAD DATA INFILE 'well.csv' IGNORE

INTO TABLE well FIELDS TERMINATED BY ','

ENCLOSED BY '"'

LINES TERMINATED BY '\n' IGNORE 1 ROWS (WELL_API, WELL_API_COUNTY_ID, OPERATOR_NAME, OPERATOR_ID, @FIRST_PERMIT_ISSUED_DATE_TMP, @SPUD_DATE_TMP, WELL_MUNICIPALITY, WELL_COUNTY, LONGITUDE_DECIMAL, LATITUDE_DECIMAL)

SET SPUD_DATE = STR_TO_DATE(@SPUD_DATE_TMP, '%m/%d/%Y'), FIRST_PERMIT_ISSUED_DATE = STR_TO_DATE(@FIRST_PERMIT_ISSUED_DATE_TMP, '%m/%d/%Y'), WELL_STATE_CODE='NY', WELL_COUNTRY='United States', FIPS_STATE='36';

Well_Events

LOAD DATA INFILE 'events.csv' IGNORE

INTO TABLE well_events FIELDS TERMINATED BY ','

ENCLOSED BY '"'

LINES TERMINATED BY '\n' IGNORE 1 ROWS (well_api, sidetrack, event_sequence)

Production

All production data was deleted and re-added in order to obtain the extra 570 entries without duplication. It only contains data for 2013. It contains the operator name, reporting period (year), oil BBLs, Gas MCF, water BBLs, months in production, and the well type.

Waste

There is no waste information reported by the New York Department of Environmental Conservation.

Inspection

There is no waste information reported by the New York Department of Environmental Conservation.

SPUD

There is no waste information reported by the New York Department of Environmental Conservation, asides from SPUD dates.

Permit

Permit data for the last 90 days is available from the NY DEC, however, this time span does not cover every permit since our last update. However, using the well data from ftp://ftp.dec.state.ny.us/dmn/zip/wellDOS.zip all relevant portions have been added to the well table, and thus will appear on the wiki correctly. The Permit CSVs contain information on the well API, county, municipality, permit issue date, operator name, and well name. Well names are untracked, and all other fields are accounted for using the data outlined above.