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
- Tier1
- 2
- Tier 2
- Tier2
- 3
- Tier 3
- Tier3
- 4
- Tier 4
- Tier4
- 5
- Tier 5
- Tier5
|
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:
|
BUILDING PLUMBING LEAD SOLDER |
One of:
|
CURRENT LCR SAMPLING SITE |
One of:
|
SENSITIVE POPULATION |
One of:
- No
- Yes - School
- Yes - Daycare
- Yes - Elementary School
- Yes - Multifamily
- Yes - Secondary School
- Yes - Other
|