120Water Import Template Documentation

Column Header	Data Type & Restrictions
120WATER LOCATION ID	Whole Number
EXTERNAL LOCATION ID	Text field
CUSTOMER ID	Text field
ADDRESS LINE 1	Text field fewer than 100 characters long
ADDRESS LINE 2	Text field fewer than 100 characters long
CITY	Text field fewer than 60 characters long
STATE	Text field fewer than 50 characters long
ZIP	Text field A zip code in 5 or 5-4 format
COUNTY	Text field
MAILING ADDRESS LINE 1	Text field
MAILING ADDRESS LINE 2	Text field
MAILING CITY	Text field
MAILING STATE	Text field
MAILING ZIP	Text field A zip code in 5 or 5-4 format
BUILDING	Text field
NEIGHBORHOOD	Text field
LOCATION NAME	Text field
LATITUDE	Number With Decimal less than or equal to 90.0 greater than or equal to -90.0
LONGITUDE	Number With Decimal less than or equal to 180.0 greater than or equal to -180.0
GIS LOCATION ID	Text field
DWELR CODE	Text field
LCR TIER	One of: 1 Tier 1 2 Tier 2 3 Tier 3 4 Tier 4 5 Tier 5
PROPERTY CLASSIFICATION	One of: null SingleFamilyResidence Single Family Residence Commercial Industrial Public MultiFamilyResidence Multi-Family Residence ElementarySchool Elementary School SecondarySchool Secondary School ChildcareFacility Childcare Facility NonResidential Non-Residential SingleFamilyResidenceWChildcare Single Family Residence w/ Childcare MultiFamilyResidenceWChildcare Multi-Family Residence w/ Childcare HospitalOrMedicalCareFacility Hospital or Medical Care Facility NursingHome Nursing Home Other
PARCEL NUMBER	Text field
YEAR BUILT	A four digit year: yyyy
LOT SQUARE FEET	Number With Decimal
WATER MAIN MATERIAL	One of: Cast Iron PVC Lead Copper Galvanized HDPE Unknown Ductile Iron Asbestos Concrete Brass Polyethylene Reinforced Concrete Iron Pipe 0 1 2 3 4 5 6 7 8 9 10 11 12 13
WATER MAIN SIZE	Number With Decimal
WATER MAIN INSTALLED YEAR	A four digit year: yyyy
CURB STOP MATERIAL	One of: Cast Iron PVC Lead Copper Galvanized HDPE Unknown Brass 0 1 2 3 4 5 6 7 8
CURB STOP SIZE	Number With Decimal
CURB STOP INSTALLED YEAR	A four digit year: yyyy
METER MATERIAL	One of: Cast Iron PVC Lead Copper Galvanized HDPE Unknown Brass 0 1 2 3 4 5 6 7 8
METER SIZE	Number With Decimal
METER INSTALLED YEAR	A four digit year: yyyy
OTHER BUILDINGS ON PROPERTY	True or False
HAS CHILDREN UNDER 7	True or False
HAS PREGNANT WOMEN	True or False
DISADVANTAGED NEIGHBORHOOD	True or False
PROPERTY OWNED BY BUSINESS	True or False
BUSINESS NAME	Text field
ESTIMATED HOME VALUE	Number With Decimal
NOTES	Text field fewer than 100 characters long
POINT OF ENTRY OR POINT OF USE TREATMENT	One of: Yes No Unknown
BUILDING PLUMBING LEAD SOLDER	One of: Yes No Unknown
CURRENT LCR SAMPLING SITE	One of: Yes No Unknown
SENSITIVE POPULATION	One of: No Yes - School Yes - Daycare Yes - Elementary School Yes - Multifamily Yes - Secondary School Yes - Other

Locations Import Template