20240929
15155400
1.0
FALSE
LSLR_Inspections_Active
002
Projected
GCS_North_American_1983
Linear Unit: Foot_US (0.304801)
NAD_1983_StatePlane_Pennsylvania_South_FIPS_3702_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.1.0'><WKT>PROJCS["NAD_1983_StatePlane_Pennsylvania_South_FIPS_3702_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",1968500.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-77.75],PARAMETER["Standard_Parallel_1",39.93333333333333],PARAMETER["Standard_Parallel_2",40.96666666666667],PARAMETER["Latitude_Of_Origin",39.33333333333334],UNIT["Foot_US",0.3048006096012192],AUTHORITY["EPSG",2272]]</WKT><XOrigin>-119214200</XOrigin><YOrigin>-96198500</YOrigin><XYScale>3048.0060960121928</XYScale><ZOrigin>-100000</ZOrigin><ZScale>10000</ZScale><MOrigin>0</MOrigin><MScale>1</MScale><XYTolerance>0.0032808333333333331</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>102729</WKID><LatestWKID>2272</LatestWKID></ProjectedCoordinateSystem>
20240930
09513600
20240930
09513600
Esri ArcGIS 13.1.0.41833
LSLR_Inspections_Active
Enterprise Geodatabase Feature Class
dataset
EPSG
6.12(9.0.0)
0
Simple
FALSE
0
TRUE
FALSE
LSLR_Inspections_Active
Feature Class
0
OBJECTID
OBJECTID
OID
4
10
0
Internal feature number.
Esri
Sequential unique whole numbers that are automatically generated.
LocationID
Location ID
Integer
4
10
0
SiteID
Site ID
String
100
0
0
HouseNumber
House Number
String
12
0
0
StreetName
Street Name
String
75
0
0
WorkOrderPublic
Work Order Public
String
25
0
0
WorkOrderPrivate
Work Order Private
String
25
0
0
WorkOrder
Work Order
String
25
0
0
CouncilDistrict
Council District
SmallInteger
2
5
0
CBIMaterialPublic
CBI Material Public
String
25
0
0
CBIMaterialPrivate
CBI Material Private
String
25
0
0
RecordMaterialPublic
Record Material Public
String
25
0
0
RecordMaterialPrivate
Record Material Private
String
25
0
0
AssumedMaterialPublic
Assumed Material Public
String
25
0
0
AssumedMaterialPrivate
Assumed Material Private
String
25
0
0
PWSA_OptOutNote
PWSA OptOut Note
String
255
0
0
LSLRAction
Site Action Required
String
50
0
0
AgrmtStatus
Agreement Status
String
25
0
0
AgrmtDtSign
Agreement Date Signed
Date
8
0
0
AgrmtDtRec
Agreement Date Received
Date
8
0
0
CustomerType
Customer Type
String
50
0
0
TerminationNotice
Termination Notice
Date
8
0
0
TerminationNoticeNote
Termination Notice Note
String
255
0
0
WaterOff
Water Shut Off
Date
8
0
0
ContractorCoordinationStart
Contractor Coordination Date
Date
8
0
0
CoordinationCompleteDate
Coordination Complete Date
Date
8
0
0
LiaisonNote
Field Liaison Note
String
600
0
0
AgrmtOwner
Agreement Owner
String
150
0
0
AgrmtOwnerAddress
Agreement Owner Address
String
150
0
0
AgrmtPhone1
Agreement Phone 1
String
15
0
0
AgrmtPhone2
Agreement Phone 2
String
15
0
0
AgrmtOwnerEmail
Agreement Owner Email
String
255
0
0
AgrmtRepName
Agreement Representative Name
String
150
0
0
AgrmtRepPhone
Agreement Representative Phone
String
15
0
0
AgrmtRepEmail
Agreement Representative Email
String
255
0
0
AgrmtNote
Agreement Notes
String
600
0
0
Agrmt_QA
Agreement QA
String
5
0
0
DtMaterialVerification
Date of Material Verification
Date
8
0
0
SiteVerificationPublic
Site Verification Public
String
25
0
0
SiteVerificationPrivate
Site Verification Private
String
25
0
0
ReplacedMaterialPublic
Replaced Material Public
String
25
0
0
ReplacedDiameterPublic
Replaced Diameter Public
Double
8
38
8
ReplaceMethodPublic
Public-Side Replacement Method
String
50
0
0
PublicRepCompDt
Public Replacement Completion Date
Date
8
0
0
ReplacedMaterialPrivate
Replaced Material Private
String
25
0
0
ReplacedDiameterPrivate
Replaced Diameter Private
Double
8
38
8
ReplaceMethodPrivate
Private-Side Replacement Method
String
50
0
0
PrivateRepCompDt
Private Replacement Completion Date
Date
8
0
0
ExistingFerruleStatus
Existing Ferrule Status
String
25
0
0
CurbStopOperable
Curb Stop Operable
String
5
0
0
CurbStopOpDtComp
Curb Stop Operable Date Completed
Date
8
0
0
InstalledExpansionTank
Expansion Tank Installed
String
5
0
0
InstalledBackflowPrev
Backflow Prevention Installed
String
5
0
0
InstalledPressureReg
Pressure Regulator Installed
String
5
0
0
InstalledMeter
New Meter Installed
String
5
0
0
BottleFilterDeliveryLoc
Bottle Filter Delivery Location
String
50
0
0
FilterCount
Number of Filters
SmallInteger
2
5
0
WaterPitcherCount
Number of Water Pitchers
SmallInteger
2
5
0
ACHDPermitNumber
ACHD Permit Number
String
25
0
0
ACHDInspectionDate
ACHD Inspection Date
Date
8
0
0
PlumberCompany
Plumber Company
String
255
0
0
FieldNote
Field Notes
String
600
0
0
VerifyRep_QA
Verification/Replacement QA
String
600
0
0
RestorationStatus
Restoration Status
String
255
0
0
CurbSWRest
Curb/Sidewalk Restoration
String
25
0
0
CurbSWDateComplete
Curb/Sidewalk Date Completed
Date
8
0
0
StreetRest
Final Street Restoration
String
25
0
0
StreetRestDateComplete
Final Street Restoration Date Completed
Date
8
0
0
LandScRest
Landscaping Restoration
String
25
0
0
LandScRestDateComplete
Landscaping Restoration Date Completed
Date
8
0
0
PreRoadSubbaseMat
Preexisting Road Sub Base Material
String
255
0
0
PreRoadSurfaceMat
Preexisting Road Surface Material
String
255
0
0
RestorationNote
Restoration Note
String
600
0
0
DOMIPermitNumber
DOMI Permit Number
String
255
0
0
DOMIPermitStartDt
DOMI Permit Start Date
Date
8
0
0
DOMIPermitFinishDt
DOMI Permit Finish Date
Date
8
0
0
Restoration_QA
Restoration QA
String
600
0
0
ContactComment
Comments or Special Request at Time of Inspection
String
600
0
0
TermNoticeStart
37 Day Start
Date
8
0
0
Hanger3Day
3 Day Notice Door Hanger Date
Date
8
0
0
HangerA
Date of Posting 48-Hour Notice (A)
Date
8
0
0
HangerB
Notice: Service Line Work (B)
Date
8
0
0
HangerC
Notice: Coordination Required (C)
Date
8
0
0
HangerD
Sorry We Missed You (D)
Date
8
0
0
HangerF
Notice: Service Line Replacement Work (F)
Date
8
0
0
HangerG
Important Health Notice: Partial Lead Line Replacement (G)
Date
8
0
0
Doorhanger_QA
Doorhanger Notes
String
600
0
0
ContractType
Contract Type
String
50
0
0
ContractorCoordinationEnd
Contractor Coordination Range End
Date
8
0
0
StreetAddress
Street Address
String
100
0
0
GISNote
GIS Note
String
300
0
0
ContractorCoordinationStartTi
Contractor Coordination Start Time
String
10
0
0
ContractorCoordinationEndTi
Contractor Coordination End Time
String
10
0
0
SvcLineAdj
Service Line Adjustment
String
5
0
0
SymbolTest
Symbol Test
String
50
0
0
HangerPhoto1
Hanger Photo 1
String
255
0
0
HangerPhoto2
Hanger Photo 2
String
255
0
0
HangerPhoto3
Hanger Photo 3
String
255
0
0
HangerPhoto4
Hanger Photo 4
String
255
0
0
HangerPhoto5
Hanger Photo 5
String
255
0
0
HangerPhoto6
Hanger Photo 6
String
255
0
0
HangerPhoto7
Hanger Photo 7
String
255
0
0
HangerPhoto8
Hanger Photo 8
String
255
0
0
VerificationPhoto1
Verification Photo 1
String
255
0
0
VerificationPhoto2
Verification Photo 2
String
255
0
0
VerificationPhoto3
Verification Photo 3
String
255
0
0
VerificationPhoto4
Verification Photo 4
String
255
0
0
VerificationPhoto5
Verification Photo 5
String
255
0
0
VerificationPhoto6
Verification Photo 6
String
255
0
0
VerificationPhoto7
Verification Photo 7
String
255
0
0
VerificationPhoto8
Verification Photo 8
String
255
0
0
RestorationPhoto1
Restoration Photo 1
String
255
0
0
RestorationPhoto2
Restoration Photo 2
String
255
0
0
RestorationPhoto3
Restoration Photo 3
String
255
0
0
RestorationPhoto4
Restoration Photo 4
String
255
0
0
RestorationPhoto5
Restoration Photo 5
String
255
0
0
RestorationPhoto6
Restoration Photo 6
String
255
0
0
RestorationPhoto7
Restoration Photo 7
String
255
0
0
RestorationPhoto8
Restoration Photo 8
String
255
0
0
AdditionalPhoto1
Additional Photo 1
String
255
0
0
AdditionalPhoto2
Additional Photo 2
String
255
0
0
AdditionalPhoto3
Additional Photo 3
String
255
0
0
AdditionalPhoto4
Additional Photo 4
String
255
0
0
AdditionalPhoto5
Additional Photo 5
String
255
0
0
AdditionalPhoto6
Additional Photo 6
String
255
0
0
AdditionalPhoto7
Additional Photo 7
String
255
0
0
AdditionalPhoto8
Additional Photo 8
String
255
0
0
GlobalID
GlobalID
GlobalID
38
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
RoadBaseRest
Road base Restoration
String
25
0
0
RoadBaseRestDateComplete
Road base Restoration Completion Date
Date
8
0
0
IntSerLineMat
Interior Service Line Material
String
255
0
0
ExistPubLead
Existing Public Lead Status
String
20
0
0
ExistPriLead
Existing Private Lead Status
String
20
0
0
AddPrivVerify
Additional Private Verification
String
25
0
0
CaulkSWDateComplete
Sidewalk Caulking Date Completed
Date
8
0
0
Shape
Shape
Geometry
8
0
0
Feature geometry.
Esri
Coordinates defining the features.
20240930