Name: PFAS_SDWIS_S123_PUBLIC

Display Field: PROJECTNAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description: This item is the source for the PFAS public dataset. Each month, data from the PFAS_SDWIS_S123_Mv is reviews by the PFAS and Drinking Water teams for approval to post publicly. After approve, this table should be truncated, and then appended with all data from PFAS_SDWIS_123_MV.

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -12777480.3929941
YMin: 3676567.94487968
XMax: -12143803.9346209
YMax: 4437982.63925744
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[58,127,71,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: ROW_ID

Unique ID Field:

Name : ROW_ID

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• ROW_ID (type: esriFieldTypeOID, alias: ROW_ID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• UNIQUELOCATIONID (type: esriFieldTypeString, alias: UNIQUELOCATIONID, SQL Type: sqlTypeOther, length: 72, nullable: true, editable: true)
• UNIQUESAMPLEID (type: esriFieldTypeString, alias: UNIQUESAMPLEID, SQL Type: sqlTypeOther, length: 46, nullable: true, editable: true)
• UNIQUEROWID (type: esriFieldTypeString, alias: UNIQUEROWID, SQL Type: sqlTypeOther, length: 46, nullable: true, editable: true)
• PROJECTNAME (type: esriFieldTypeString, alias: PROJECTNAME, SQL Type: sqlTypeOther, length: 17, nullable: true, editable: true)
• SITEID (type: esriFieldTypeString, alias: SITEID, SQL Type: sqlTypeOther, length: 157, nullable: true, editable: true)
• LABFULLNAME (type: esriFieldTypeString, alias: LABFULLNAME, SQL Type: sqlTypeOther, length: 120, nullable: true, editable: true)
• LABNAME (type: esriFieldTypeString, alias: LABNAME, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• REPORTINGAGENCYFULLNAME (type: esriFieldTypeString, alias: REPORTINGAGENCYFULLNAME, SQL Type: sqlTypeOther, length: 43, nullable: true, editable: true)
• REPORTINGAGENCY (type: esriFieldTypeString, alias: REPORTINGAGENCY, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• COLLECTINGAGENCYFULLNAME (type: esriFieldTypeString, alias: COLLECTINGAGENCYFULLNAME, SQL Type: sqlTypeOther, length: 43, nullable: true, editable: true)
• COLLECTINGAGENCY (type: esriFieldTypeString, alias: COLLECTINGAGENCY, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• SAMPLEID (type: esriFieldTypeString, alias: SAMPLEID, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• PURPOSETYPE (type: esriFieldTypeString, alias: PURPOSETYPE, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• PURPOSETYPEDESC (type: esriFieldTypeString, alias: PURPOSETYPEDESC, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• SAMPLETYPECODE (type: esriFieldTypeString, alias: SAMPLETYPECODE, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• SAMPLETYPEDESC (type: esriFieldTypeString, alias: SAMPLETYPEDESC, SQL Type: sqlTypeOther, length: 7, nullable: true, editable: true)
• SAMPLEDATETIME (type: esriFieldTypeDate, alias: SAMPLEDATETIME, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• EXTRACTIONDATE (type: esriFieldTypeDate, alias: EXTRACTIONDATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ANALYSISDATE (type: esriFieldTypeDate, alias: ANALYSISDATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• SAMPLEDEPTH (type: esriFieldTypeDouble, alias: SAMPLEDEPTH, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SAMPLEDEPTHUNIT (type: esriFieldTypeString, alias: SAMPLEDEPTHUNIT, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• LABREPORTINGLIMIT (type: esriFieldTypeDouble, alias: LABREPORTINGLIMIT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LABREPORTINGLIMITUNIT (type: esriFieldTypeString, alias: LABREPORTINGLIMITUNIT, SQL Type: sqlTypeOther, length: 27, nullable: true, editable: true)
• MINIMUMDETECTIONLIMIT (type: esriFieldTypeDouble, alias: MINIMUMDETECTIONLIMIT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MINIMUMDETECTIONLIMITUNIT (type: esriFieldTypeString, alias: MINIMUMDETECTIONLIMITUNIT, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• RESULTS (type: esriFieldTypeString, alias: RESULTS, SQL Type: sqlTypeOther, length: 48, nullable: true, editable: true)
• RESULTSCALCULATED (type: esriFieldTypeDouble, alias: RESULTSCALCULATED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RESULTSCONVERTEDPPT (type: esriFieldTypeString, alias: RESULTSCONVERTEDPPT, SQL Type: sqlTypeOther, length: 48, nullable: true, editable: true)
• LABNOTATIONCODE (type: esriFieldTypeString, alias: LABNOTATIONCODE, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• LABNOTATIONDESCRIPTION (type: esriFieldTypeString, alias: LABNOTATIONDESCRIPTION, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
• RESULTUNITS (type: esriFieldTypeString, alias: RESULTUNITS, SQL Type: sqlTypeOther, length: 27, nullable: true, editable: true)
• DILUTION (type: esriFieldTypeDouble, alias: DILUTION, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LABQUALIFIERS (type: esriFieldTypeString, alias: LABQUALIFIERS, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• SAMPLERNAME (type: esriFieldTypeString, alias: SAMPLERNAME, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• SAMPLECOMMENT (type: esriFieldTypeString, alias: SAMPLECOMMENT, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
• CASQUALIFIER (type: esriFieldTypeString, alias: CASQUALIFIER, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• METHOD (type: esriFieldTypeString, alias: METHOD, SQL Type: sqlTypeOther, length: 90, nullable: true, editable: true)
• SUBSTANCENAME (type: esriFieldTypeString, alias: SUBSTANCENAME, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CASNUMBER (type: esriFieldTypeString, alias: CASNUMBER, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PFASCOMPOUNDACRONYM (type: esriFieldTypeString, alias: PFASCOMPOUNDACRONYM, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SAMPLEMEDIA (type: esriFieldTypeString, alias: SAMPLEMEDIA, SQL Type: sqlTypeOther, length: 21, nullable: true, editable: true)
• SUBSTANCECATEGORY (type: esriFieldTypeString, alias: SUBSTANCECATEGORY, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• COLLECTIONMETHOD (type: esriFieldTypeString, alias: COLLECTIONMETHOD, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• DATASOURCE (type: esriFieldTypeString, alias: DATASOURCE, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• DATASOURCETYPE (type: esriFieldTypeString, alias: DATASOURCETYPE, SQL Type: sqlTypeOther, length: 21, nullable: true, editable: true)
• ADEQWELLNUMBER (type: esriFieldTypeDouble, alias: ADEQWELLNUMBER, SQL Type: sqlTypeOther, nullable: true, editable: true)
• WELL55NUMBER (type: esriFieldTypeString, alias: WELL55NUMBER, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• SDWISPWSNUMBER (type: esriFieldTypeString, alias: SDWISPWSNUMBER, SQL Type: sqlTypeOther, length: 36, nullable: true, editable: true)
• SDWISFACILITY (type: esriFieldTypeString, alias: SDWISFACILITY, SQL Type: sqlTypeOther, length: 36, nullable: true, editable: true)
• SDWISPWSNAME (type: esriFieldTypeString, alias: SDWISPWSNAME, SQL Type: sqlTypeOther, length: 120, nullable: true, editable: true)
• ADEQPLACEID (type: esriFieldTypeDouble, alias: ADEQPLACEID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• WATERBODYNAME (type: esriFieldTypeString, alias: WATERBODYNAME, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• DEPTHTOWATER_FT (type: esriFieldTypeDouble, alias: DEPTHTOWATER_FT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LATITUDEDD_WGS84 (type: esriFieldTypeDouble, alias: LATITUDEDD_WGS84, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LONGITUDEDD_WGS84 (type: esriFieldTypeDouble, alias: LONGITUDEDD_WGS84, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HORIZONTALLOCATIONMETHOD (type: esriFieldTypeString, alias: HORIZONTALLOCATIONMETHOD, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• MAKEMODEL_GPS (type: esriFieldTypeString, alias: MAKEMODEL_GPS, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• LOCATIONVERIFIED (type: esriFieldTypeString, alias: LOCATIONVERIFIED, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• LOCATIONCOMMENTS (type: esriFieldTypeString, alias: LOCATIONCOMMENTS, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
• QCDATE (type: esriFieldTypeString, alias: QCDATE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• UPLOADFILENAME (type: esriFieldTypeString, alias: UPLOADFILENAME, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• SITE_GLOBALID (type: esriFieldTypeString, alias: SITE_GLOBALID, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• SAMP_GLOBALID (type: esriFieldTypeString, alias: SAMP_GLOBALID, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• RES_GLOBALID (type: esriFieldTypeString, alias: RES_GLOBALID, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• SAMPLEDATE_CHAR (type: esriFieldTypeString, alias: SAMPLEDATE_CHAR, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• SAMPLE_FILTER (type: esriFieldTypeDouble, alias: SAMPLE_FILTER, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PFOA (type: esriFieldTypeString, alias: PFOA, SQL Type: sqlTypeOther, length: 48, nullable: true, editable: true)
• PFOS (type: esriFieldTypeString, alias: PFOS, SQL Type: sqlTypeOther, length: 48, nullable: true, editable: true)
• PFBS (type: esriFieldTypeString, alias: PFBS, SQL Type: sqlTypeOther, length: 48, nullable: true, editable: true)
• GENX (type: esriFieldTypeString, alias: GENX, SQL Type: sqlTypeOther, length: 48, nullable: true, editable: true)
• PFHXS (type: esriFieldTypeString, alias: PFHXS, SQL Type: sqlTypeOther, length: 48, nullable: true, editable: true)
• PFNA (type: esriFieldTypeString, alias: PFNA, SQL Type: sqlTypeOther, length: 48, nullable: true, editable: true)
• HAZARD_INDEX (type: esriFieldTypeString, alias: HAZARD_INDEX, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
• DETECTION_CODE (type: esriFieldTypeString, alias: DETECTION_CODE, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
• DETECTION_CAT (type: esriFieldTypeString, alias: DETECTION_CAT, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
• DRAWING_ORDER (type: esriFieldTypeDouble, alias: DRAWING_ORDER, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SE_ANNO_CAD_DATA (type: esriFieldTypeBlob, alias: SE_ANNO_CAD_DATA, SQL Type: sqlTypeOther, nullable: true, editable: true)

Templates:

Name: PFAS_SDWIS_S123_PUBLIC
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/6/2026 6:48:44 PM

Schema Last Edit Date: 7/6/2026 6:23:09 PM

Data Last Edit Date: 7/6/2026 6:48:44 PM

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