20231204
07195600
1.0
FALSE
GISC.DBO.wsServiceInventory_POINT
002
-17463800.000000
5119647.941250
-46132600.000000
3092368.900500
1
Projected
GCS_North_American_1983
Linear Unit: Foot_US (0.304801)
NAD_1983_StatePlane_Illinois_East_FIPS_1201_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/10.8'><WKT>PROJCS["NAD_1983_StatePlane_Illinois_East_FIPS_1201_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["Transverse_Mercator"],PARAMETER["False_Easting",984250.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-88.33333333333333],PARAMETER["Scale_Factor",0.999975],PARAMETER["Latitude_Of_Origin",36.66666666666666],UNIT["Foot_US",0.3048006096012192],AUTHORITY["EPSG",3435]]</WKT><XOrigin>-17463800</XOrigin><YOrigin>-46132600</YOrigin><XYScale>4000</XYScale><ZOrigin>0</ZOrigin><ZScale>1</ZScale><MOrigin>0</MOrigin><MScale>1</MScale><XYTolerance>0.002</XYTolerance><ZTolerance>2.0000000000000002e-05</ZTolerance><MTolerance>2.0000000000000002e-05</MTolerance><HighPrecision>true</HighPrecision><WKID>102671</WKID><LatestWKID>3435</LatestWKID></ProjectedCoordinateSystem>
20230728
07273500
20230728
07273500
ISO19139
150000000
5000
Version 6.2 (Build 9200) ; Esri ArcGIS 10.8.1.14362
GISC.DBO.wsServiceInventory_POINT
1
-133.333329
-53.333346
45.154360
-89.999991
This feature class is a point feature class used to identify the materials (particularly lead) of the public and private water service line connections.
<DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN>The IEPA is requiring all municipalities to track, report, and remove lead material in their water systems. Recognizing this need and understanding that municipalities may not be able to prioritize the creation of water lateral line features, this point feature class has been created as a simplified way to track the line material for all water connection points. It is expected that this feature class will be removed in the future once all lead lines have been removed and regulations change.</SPAN></P><P><SPAN>This feature class may be reference by the public, community development officials, plumbing inspectors, water system maintenance operators, and public works officials.</SPAN></P></DIV></DIV></DIV>
water
service
lateral
lead
Feature Class
dataset
EPSG
8.9.3(9.3.0.0)
250248
Simple
FALSE
250248
TRUE
FALSE
GISC.DBO.wsServiceInventory_POINT
Feature Class
250248
OBJECTID
OBJECTID
OID
4
10
0
Internal feature number.
Esri
Sequential unique whole numbers that are automatically generated.
GEODBID
GEODBID
String
3
0
0
FEATUREID
FEATUREID
String
15
0
0
DATECREATED
DATECREATED
Date
8
0
0
DATEMODIFIED
DATEMODIFIED
Date
8
0
0
SOURCE
SOURCE
String
20
0
0
SOURCETYPE
SOURCETYPE
String
20
0
0
PRODUCTIONNOTES
PRODUCTIONNOTES
String
100
0
0
REPLICAFILTER
REPLICAFILTER
String
255
0
0
GlobalID
GlobalID
GlobalID
38
0
0
CREATEDBY
CREATEDBY
String
100
0
0
MODIFIEDBY
MODIFIEDBY
String
100
0
0
WEBLINK
WEBLINK
String
255
0
0
DESCRIPTION
DESCRIPTION
String
255
0
0
Open text field to describe additional details
PUBLICSOURCE
PUBLICSOURCE
String
50
0
0
The source of the “public” service information
PUBLICMATERIAL
PUBLICMATERIAL
String
50
0
0
Material of the “public” service
PUBLICDIAMETER
PUBLICDIAMETER
Double
8
38
8
Size of the “public” service
PUBLICDATEVERIFIED
PUBLICDATEVERIFIED
Date
8
0
0
Date the “public” service was field verified
PUBLICDATEINSTALLED
PUBLICDATEINSTALLED
Date
8
0
0
Date the “public” service was installed
PUBLICDATEABANDONED
PUBLICDATEABANDONED
Date
8
0
0
Date the old “public” service was abandoned
PUBLICMATERIALABANDONED
SUPPLIERMATERIALABANDONED
String
50
0
0
The material of the abandoned “public” service
PRIVATESOURCE
PRIVATESOURCE
String
50
0
0
The source of the private service information
PRIVATEMATERIAL
PRIVATEMATERIAL
String
50
0
0
Material of the private service
PRIVATEDIAMETER
PRIVATEDIAMETER
Double
8
38
8
Size of the private service
PRIVATEDATEVERIFIED
PRIVATEDATEVERIFIED
Date
8
0
0
Date the private service was field verified
PRIVATEDATEINSTALLED
PRIVATEDATEINSTALLED
Date
8
0
0
Date the private service was installed
PRIVATEDATEABANDONED
PRIVATEDATEABANDONED
Date
8
0
0
Date the old private service was abandoned
PRIVATEMATERIALABANDONED
CUSTOMERMATERIALABANDONED
String
50
0
0
The material of the abandoned private servic
FITTINGMATERIAL1
FITTINGMATERIAL1
String
50
0
0
The material of the connecting fitting (e.g., riser on a meter)
FITTINGMATERIAL2
FITTINGMATERIAL2
String
50
0
0
The material of the connecting fitting (e.g., riser on a meter)
SHAPE
SHAPE
Geometry
4
0
0
Feature geometry.
Esri
Coordinates defining the features.
GROUNDWIRE
GROUNDWIRE
String
10
0
0
ENTRYDIRECTION
ENTRYDIRECTION
String
50
0
0
ENTRYPOINT
ENTRYPOINT
String
50
0
0
SERVICEADDRESS
SERVICEADDRESS
String
100
0
0
Service address
BUILDINGFOUNDATION
BUILDINGFOUNDATION
String
50
0
0
CUSTOMERMATERIAL
CUSTOMERMATERIAL
String
50
0
0
SUPPLIERMATERIAL
SUPPLIERMATERIAL
String
50
0
0
LEADLETTERSENT
LEADLETTERSENT
String
20
0
0
Indicates when a lead service line is discovered if the community has sent a letter to the customer.
DATELASTFILTERDEPLOYED
DATELASTFILTERDEPLOYED
Date
8
0
0
Date a water filter was last deployed to a customer with a lead service; required when a customer is impacted by a water main break.
DATELASTWATERTEST
DATELASTWATERTEST
Date
8
0
0
Date the water was last tested for a customer with a lead service; required when customer impacted by a water main break.
WAIVERLINK
WAIVERLINK
String
255
0
0
URL to waiver document; used when HASWAIVER is YES
PHOTOATTACHMENTLINK
PHOTOATTACHMENTLINK
String
255
0
0
URL to inspection photo
IEPATESTINGPARTICIPANT
IEPATESTINGPARTICIPANT
String
20
0
0
This field indicates if an address is part of the IEPA testing process (ie, if it should be tested or not)
HASWAIVER
HASWAIVER
String
20
0
0
Indicates if property owner completed a waiver that they will not replace their lead line
DATEFIRSTLETTERSENT
DATEFIRSTLETTERSENT
Date
8
0
0
Indicates when a lead service line is discovered the date the community sent the second letter to the customer.
DATESECONDLETTERSENT
DATESECONDLETTERSENT
Date
8
0
0
Indicates when a lead service line is discovered the date the community sent the second letter to the customer.
HIGHRISKAREA
HIGHRISKAREA
String
10
0
0
Boolean field to indicate if the sevice line serves a high risk facility or location (see EPA resources for details)
HASGOOSENECKPIGTAIL
HASGOOSENECKPIGTAIL
String
10
0
0
Boolean field to indicate if service line is connected to main with a goose neck or pigtail
GOOSENECKPIGTAILMATERIAL
GOOSENECKPIGTAILMATERIAL
String
50
0
0
The material when a goose neck or pigtail is used to connect service line to main
LEADLETTERSENTDATE
LEADLETTERSENTDATE
Date
8
0
0
The date a customer was notified of a lead line
DATEWAIVERRECEIVED
DATEWAIVERRECEIVED
Date
8
0
0
The data a waiver was received indicating customer does not want to replace service line
20230728