DNV Meter Data Notes

Original Data Format

The original data format as received from DNV was in a CSV with the following columns and a few sample rows:

Row	ACCOUNT	ROUTE_CATEGORY	BILLING_CYCLE	REG_SERIAL	READING_YEAR	READING_PERIOD	CONSUMPTION
1	10001	METERED - MONTHLY	METERED - MONTHLY	70093784A	2014	12	1112500
2	10001	METERED - MONTHLY	METERED - MONTHLY	70093784A	2014	11	925500
3	10001	METERED - MONTHLY	METERED - MONTHLY	70093784A	2014	10	1067500

From the email in which the data was provided on 9/29/2025 from amirabbas.mottahedin01@universitadipavia.it:

Hi Sudhir,

Please find attached the shapefile of meters and the csv file of consumptions. The join key between the two is the Meterserial in the shapefile and the Reg_serial in the data. Not all meters are monthly, so I have also kept the yearly and quarterly recording meters in the data in case they are needed. The unit of consumption is cubic feet.

Bests, Amir

Shapefile Data

FID,Asset_ID,AM_Owner,AM_Dept,AM_Date,AM_TYPE,AM_Size,AM_Estimat,Address,Location,MeterType,MeterSeria,SizeCommen,HF_Size,LF_Size,HF_RadioID,LF_RadioID,HF_Reading,LF_Reading,BypassClos,BypassReq,Comments,Inspector,Met_Gather,Met_Format,Met_Donor,Met_Input,Met_Tech,Met_Method,MET_Ovr_By,MET_Ovr_Ty,created_us,created_da,last_edite,last_edi_1,GlobalID,ContactNam,ContactNum,POINT_X,POINT_Y
0,WTRMTR00001,DNV,UTILS_DEPT,,1,2, ,1583 GARDEN AVE,In Manhole At Curb In Backlane,T10,51846999A, ,0,0,1540560424, , ,27396,N/A,No, ,Jordie, , , , , , , , , ,,water9@dnv.org,2024-04-03 0:00:00,{D0EA84C8-6B2A-4AB2-9311-09BA7F0DB646}, , ,491330.969,5463416.862
1,WTRMTR00002,DNV,UTILS_DEPT,,1,0, ,3300 MT SEYMOUR PKWY, , ,70252856C, ,0,0, , , , , , , , , , , , , , , , , ,,SDE_STORMK,2022-05-05 0:00:00,{E0843392-EAE8-4BA0-A223-BC8457717739}, , ,501484.2334,5462583.638
2,WTRMTR00003,DNV,UTILS_DEPT,,1,0, , , , , , ,0,0, , , , , , , , , , , , , , , , , ,,SDE_STORMK,2022-05-05 0:00:00,{A33DE2E1-C1B6-4D5A-9B5A-E3C4A0AA8B43}, , ,501875.6,5462593.442