Name: Public Water System Facilities

Display Field: PWS_NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: US EPA/Office of Water/Office of Ground Water and Drinking water has provided a dataset of the Drinking Water Sources. This data includes information about the Public Water Systems. This data includes only the data that were provided to US EPA with a latitude and longitude. More data is available in the data warehouse than is provided here. Please contact US EPA, Office of Ground Water and Drinking Water to obtain additional information. This data is provide to US EPA from the primacy agencies on a quarterly basis but is maintained by each primacy agency in their own data systems. The locations of the drinking water sources are considered sensitive and all users should follow the HSIP securtiy policy for this data.Original data was projected to NAD83. Data has been re-projected to WGS84 for inclusion in HSIP. Updated latitude and longitude coordinates are reflected in the PROJECTION_WGS84_LAT and PROJECTION_WGS84_LON fields located at the end of the attribute table.

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: false

Max Record Count: 1500

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -10202086.2407821
YMin: 4280313.55028471
XMax: -9932181.0034047
YMax: 4684079.15061562
Spatial Reference: 3395 (3395)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriPMS","url":"d41a0cf034bd87f09ab213c8d296e5b9","imageData":"iVBORw0KGgoAAAANSUhEUgAAAAgAAAAICAYAAADED76LAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAMNJREFUGJVjYYAAFiHbWfFfuRT0GBh+f2d4c3Hnz7NV+xkYGBhYGBgYeBjcdy15J6Ltz8DACFEuqJXBzi/f9XNfdBsLu+v6hp8iOv4MyICZnf+niFUlu0H/GRYGHikvBmyAlZ3np6ROIMvPf0x8WBUwMDAIMbDysbD/+X7rJwODNKb0f4avf97cYPn55mE9A4ewOQOHIBeK/Ic7F3/uPtvBwnAy9jAD2yp/diHp9p8snHoMDP+/Mfx4u4fhxfNsBob23wB+YDsfs2V6BQAAAABJRU5ErkJggg==","contentType":"image/png","width":6,"height":6,"angle":0,"xoffset":0,"yoffset":0},"label":"","description":""},"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field: GlobalID

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• SUBMISSIONYEARQUARTER (type: esriFieldTypeString, alias: SUBMISSIONYEARQUARTER, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• PWSID (type: esriFieldTypeString, alias: PWSID, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• PWS_NAME (type: esriFieldTypeString, alias: PWS_NAME, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• EPA_REGION (type: esriFieldTypeString, alias: EPA_REGION, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• PRIMACY_AGENCY_CODE (type: esriFieldTypeString, alias: PRIMACY_AGENCY_CODE, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• PWS_TYPE_CODE (type: esriFieldTypeString, alias: PWS_TYPE_CODE, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• SEASON_BEGIN_DATE (type: esriFieldTypeString, alias: SEASON_BEGIN_DATE, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• SEASON_END_DATE (type: esriFieldTypeString, alias: SEASON_END_DATE, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• OWNER_TYPE_DESCRIPTION (type: esriFieldTypeString, alias: OWNER_TYPE_DESCRIPTION, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• POPULATION_SERVED_COUNT (type: esriFieldTypeString, alias: POPULATION_SERVED_COUNT, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• PRIMACY_TYPE (type: esriFieldTypeString, alias: PRIMACY_TYPE, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• PRIMARY_SOURCE_CODE (type: esriFieldTypeString, alias: PRIMARY_SOURCE_CODE, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• SERVICE_CONNECTIONS_COUNT (type: esriFieldTypeString, alias: SERVICE_CONNECTIONS_COUNT, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• FACILITY_ID (type: esriFieldTypeString, alias: FACILITY_ID, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• FACILITY_NAME (type: esriFieldTypeString, alias: FACILITY_NAME, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• PWS_ACTIVITY_CODE (type: esriFieldTypeString, alias: PWS_ACTIVITY_CODE, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• FACILITY_ACTIVITY_CODE (type: esriFieldTypeString, alias: FACILITY_ACTIVITY_CODE, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• STATE_FACILITY_ID (type: esriFieldTypeString, alias: STATE_FACILITY_ID, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• FACILITY_TYPE_DESCRIPTION (type: esriFieldTypeString, alias: FACILITY_TYPE_DESCRIPTION, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• SUBMISSION_STATUS_CODE (type: esriFieldTypeString, alias: SUBMISSION_STATUS_CODE, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• IS_SOURCE_IND (type: esriFieldTypeString, alias: IS_SOURCE_IND, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• WATER_TYPE_CODE (type: esriFieldTypeString, alias: WATER_TYPE_CODE, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• AVAILABILITY_DESCRIPTION (type: esriFieldTypeString, alias: AVAILABILITY_DESCRIPTION, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• IS_SOURCE_TREATED_IND (type: esriFieldTypeString, alias: IS_SOURCE_TREATED_IND, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• PROJECTION_NAD83_LAT (type: esriFieldTypeDouble, alias: PROJECTION_NAD83_LAT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PROJECTION_NAD83_LON (type: esriFieldTypeDouble, alias: PROJECTION_NAD83_LON, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ORIGINAL_LATITUDE (type: esriFieldTypeDouble, alias: ORIGINAL_LATITUDE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ORIGINAL_LONGITUDE (type: esriFieldTypeDouble, alias: ORIGINAL_LONGITUDE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HORIZ_REF_DATUM_DESCRIPTION (type: esriFieldTypeString, alias: HORIZ_REF_DATUM_DESCRIPTION, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• HORIZ_ACCURACY_MEASURE_NAD83 (type: esriFieldTypeString, alias: HORIZ_ACCURACY_MEASURE_NAD83, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• VERT_ACCURACY_MEASURE_NAD83 (type: esriFieldTypeString, alias: VERT_ACCURACY_MEASURE_NAD83, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• VERT_MEASURE (type: esriFieldTypeString, alias: VERT_MEASURE, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• COLLECTION_DATE (type: esriFieldTypeString, alias: COLLECTION_DATE, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• COMMENTS_TEXT (type: esriFieldTypeString, alias: COMMENTS_TEXT, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• VERT_COLL_METHOD_DESCRIPTION (type: esriFieldTypeString, alias: VERT_COLL_METHOD_DESCRIPTION, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• REFERENCE_POINT_DESCRIPTION (type: esriFieldTypeString, alias: REFERENCE_POINT_DESCRIPTION, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• VERT_REF_DATUM_DESCRIPTION (type: esriFieldTypeString, alias: VERT_REF_DATUM_DESCRIPTION, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• GEOMETRY_TYPE_DESCRIPTION (type: esriFieldTypeString, alias: GEOMETRY_TYPE_DESCRIPTION, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• COORDINATE_SOURCE_DESCRIPTION (type: esriFieldTypeString, alias: COORDINATE_SOURCE_DESCRIPTION, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• VERIFICATION_METHOD (type: esriFieldTypeString, alias: VERIFICATION_METHOD, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• SOURCE_MAP_SCALE_DESCRIPTION (type: esriFieldTypeString, alias: SOURCE_MAP_SCALE_DESCRIPTION, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• HORIZ_COLL_METHOD_DESCRIPTION (type: esriFieldTypeString, alias: HORIZ_COLL_METHOD_DESCRIPTION, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• ORG_NAME (type: esriFieldTypeString, alias: ORG_NAME, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• ADMIN_NAME (type: esriFieldTypeString, alias: ADMIN_NAME, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• EMAIL_ADDR (type: esriFieldTypeString, alias: EMAIL_ADDR, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• PHONE_NUMBER (type: esriFieldTypeString, alias: PHONE_NUMBER, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• PHONE_EXT_NUMBER (type: esriFieldTypeString, alias: PHONE_EXT_NUMBER, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• FAX_NUMBER (type: esriFieldTypeString, alias: FAX_NUMBER, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• ALT_PHONE_NUMBER (type: esriFieldTypeString, alias: ALT_PHONE_NUMBER, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• ADDRESS_LINE1 (type: esriFieldTypeString, alias: ADDRESS_LINE1, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• ADDRESS_LINE2 (type: esriFieldTypeString, alias: ADDRESS_LINE2, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• CITY_NAME (type: esriFieldTypeString, alias: CITY_NAME, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• STATE_CODE (type: esriFieldTypeString, alias: STATE_CODE, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• ZIP_CODE (type: esriFieldTypeString, alias: ZIP_CODE, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• COUNTRY_CODE (type: esriFieldTypeString, alias: COUNTRY_CODE, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• SOURCE_MAP_SACLE_DESCRIPTION (type: esriFieldTypeString, alias: SOURCE_MAP_SACLE_DESCRIPTION, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• PROJECTION_WGS84_LAT (type: esriFieldTypeDouble, alias: PROJECTION_WGS84_LAT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PROJECTION_WGS84_LON (type: esriFieldTypeDouble, alias: PROJECTION_WGS84_LON, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)

Templates:

Name: Public Water System Facilities
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 11/30/2022 4:36:08 PM

Schema Last Edit Date: 11/30/2022 4:36:08 PM

Data Last Edit Date: 11/29/2022 6:31:52 PM

Supported Operations:   Query   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat