20231201
10123100
1.0
FALSE
fptDPWwaterLeadServiceLineInventory
002
Projected
GCS_North_American_1983
Linear Unit: Foot_US (0.304801)
NAD_1983_StatePlane_Massachusetts_Mainland_FIPS_2001_Feet
<ProjectedCoordinateSystem xsi:type='typens:ProjectedCoordinateSystem' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.4.0'><WKT>PROJCS["NAD_1983_StatePlane_Massachusetts_Mainland_FIPS_2001_Feet",GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Lambert_Conformal_Conic"],PARAMETER["False_Easting",656166.6666666665],PARAMETER["False_Northing",2460625.0],PARAMETER["Central_Meridian",-71.5],PARAMETER["Standard_Parallel_1",41.71666666666667],PARAMETER["Standard_Parallel_2",42.68333333333333],PARAMETER["Latitude_Of_Origin",41.0],UNIT["Foot_US",0.3048006096012192],AUTHORITY["EPSG",2249]]</WKT><XOrigin>-119851500</XOrigin><YOrigin>-94498200</YOrigin><XYScale>3048.0060960121928</XYScale><ZOrigin>0</ZOrigin><ZScale>1</ZScale><MOrigin>0</MOrigin><MScale>1</MScale><XYTolerance>0.0032808333333333331</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>102686</WKID><LatestWKID>2249</LatestWKID></ProjectedCoordinateSystem>
20251218
11112100
20251218
11112100
Esri ArcGIS 13.4.0.55405
fptDPWwaterLeadServiceLineInventory
Enterprise Geodatabase Feature Class
dataset
EPSG
5.3(9.0.0)
0
Simple
FALSE
0
TRUE
FALSE
fptDPWwaterLeadServiceLineInventory
Feature Class
0
OBJECTID
OBJECTID
OID
4
10
0
Internal feature number.
Esri
Sequential unique whole numbers that are automatically generated.
SHAPE
Shape
Geometry
8
0
0
Feature geometry.
Esri
Coordinates defining the features.
SiteID
SITE ID
String
255
0
0
LocationalIdentifer
LOCATIONAL IDENTIFIER
String
255
0
0
LCRLocation
LCR SAMPLING LOCATION?
String
255
0
0
ConnectorPresent
CONNECTOR (GOOSENECK / PIGTAIL) CURRENTLY PRESENT?
String
255
0
0
CONNECTORMATERIAL
CONNECTOR (GOOSENECK /PIGTAIL) MATERIAL
String
255
0
0
CurrentPublicSLMaterial
CURRENT PUBLIC SERVICE LINE MATERIAL
String
255
0
0
PublicSLPrevLead
WAS PUBLIC SERVICE LINE MATERIAL EVER PREVIOUSLY LEAD?
String
255
0
0
PublicSLSize
PUBLIC SERVICE LINE SIZE
(inches)
String
255
0
0
Public_SLInstallDate
PUBLIC SERVICE LINE INSTALL DATE
(YYYY)
String
255
0
0
CurrentPrivateSLMaterial
CURRENT PRIVATE SERVICE LINE MATERIAL
String
255
0
0
PrivateSLSize
PRIVATE SERVICE LINE SIZE
(inches)
String
255
0
0
Private_SLInstallDate
PRIVATE SERVICE LINE INSTALL DATE
(YYYY)
String
255
0
0
EntireServiceLine
ENTIRE SERVICE LINE CLASSIFICATION
String
255
0
0
VerificationMethod
VERIFICATION
METHOD
String
255
0
0
OtherMassDEPMethod
OTHER MASSDEP APPROVED VERIFICATION METHOD
String
255
0
0
BuildingType
BUILDING TYPE
String
255
0
0
POEPOUTreatment
POINT-OF-ENTRY OR POINT-OF-USE TREATMENT PRESENT?
String
255
0
0
BuildingPlumbingMaterial1
BUILDING PLUMBING MATERIAL 1
String
255
0
0
BuildingPlumbingMaterial2
BUILDING PLUMBING MATERIAL 2
String
255
0
0
BuildingPlumbingInstallDate
BUILDING PLUMBING MATERIAL INSTALL DATE
(YYYY)
String
255
0
0
SamplingPlanLocation
SAMPLING PLAN LOCATION
String
255
0
0
tier
SAMPLING SITE TIER
String
255
0
0
ReplacedSL
REPLACED LSL PUBLIC OR PRIVATE SIDE? (DURING OR AFTER 2024)
String
255
0
0
ReplacedMaterial
NEW REPLACED SERVICE LINE MATERIAL
String
255
0
0
LSLReplacementDate
LSL REPLACEMENT DATE
(MM/DD/YYYY)
String
255
0
0
COMMENTS
COMMENTS
String
255
0
0
GlobalID
GlobalID
GlobalID
38
0
0
XCoordinate
X Coordinate
Double
8
38
8
YCoordinate
Y Coordinate
Double
8
38
8
CAMAYearBuilt
CAMA Year Built
SmallInteger
2
5
0
CAMALUCode
CAMA Land Use Code
String
50
0
0
Public_Verification
Public_Verification
String
255
0
0
Private_Verification
Private_Verification
String
255
0
0
Main_YearInstalled
Main_YearInstalled
String
255
0
0
Main_Material
Main_Material
String
255
0
0
Main_New_Replaced
Main_New_Replaced
String
255
0
0
Main_PublicService_Installed
Main_PublicServices_Installed
String
255
0
0
Main_PublicServiceMaterial
Main_PublicServiceMaterial
String
255
0
0
Main_PrivateService_Installed
Main_PrivateServices_Installe
String
255
0
0
Main_PrivateServicesMaterial
Main_PrivateServicesMaterial
String
255
0
0
TIECardFileName
TIE Card File Name
String
255
0
0
TIECardFilePath
TIE Card File Path
String
500
0
0
Active_Inactive
Active or Inactive?
String
15
0
0
PublicRandom
PublicRandom
Double
8
38
8
PrivateRandom
PrivateRandom
Double
8
38
8
Public_InspectionTarget
Public_InspectionTarget
SmallInteger
2
5
0
Private_InspectionTarget
Private_InspectionTaeget
SmallInteger
2
5
0
CreationDate
CreationDate
Date
8
1
0
Creator
Creator
String
128
0
0
EditDate
EditDate
Date
8
1
0
Editor
Editor
String
128
0
0
LUDesc
LU Description
String
1000
0
0
OwnerName
OwnerName
String
255
0
0
MailingCity
MailingCity
String
255
0
0
MailingState
MailingState
String
255
0
0
MailingZipCode
MailingZipCode
String
255
0
0
MailingAddress
MailingAddress
String
255
0
0
PrivateVerificationDescriptio
PrivateVerificationDescriptio
String
255
0
0
PublicVerificationDescription
PublicVerificationDescription
String
255
0
0
FacilityID_FromPublic
FacilityID_FromPublic
String
255
0
0
FacilityID_FromPrivate
FacilityID_FromPrivate
String
255
0
0
MultipleLaterals
MultipleLaterals
String
255
0
0
FacilityID_FromUNKOwner
FacilityID_FromUNKOwner
String
255
0
0
ESL_RandomNumber
ESL_RandomNumber
Double
8
38
8
ValidationPoolPrivateRandomNumb
Validation Pool Private Random Number
Double
8
38
8
ValidationPoolPublicRandomNumbe
Validation Pool Public Random Number
Double
8
38
8
ESL_InspectionSelection
ESL_InspectionSelection
Double
8
38
8
ValidationInspectionPool
Validation Inspection Pool
Integer
4
10
0
ValidationPoolInspectionStatus
Validation Pool Inspection Status
String
256
0
0
ValidationPoolClassification
Validation Pool Classification
String
256
0
0
created_user
created_user
String
255
0
0
created_date
created_date
Date
8
0
0
last_edited_user
last_edited_user
String
255
0
0
last_edited_date
last_edited_date
Date
8
0
0
20251218