{ "tables": [ { "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 1000, "attachmentProperties": [ { "fieldName": "attachmentid", "isEnabled": true, "name": "id" }, { "fieldName": "globalid", "isEnabled": true, "name": "globalId" }, { "fieldName": "att_name", "isEnabled": true, "name": "name" }, { "fieldName": "data_size", "isEnabled": true, "name": "size" }, { "fieldName": "content_type", "isEnabled": true, "name": "contentType" }, { "fieldName": "keywords", "isEnabled": true, "name": "keywords" }, { "fieldName": "exifinfo", "isEnabled": true, "name": "exifInfo" } ], "attachmentFields": [ { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "attachmentid", "alias": "attachmentid", "type": "esriFieldTypeOID" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "length": 38, "name": "globalid", "alias": "globalid", "type": "esriFieldTypeGlobalID" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "length": 250, "name": "att_name", "alias": "att_name", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "data_size", "alias": "data_size", "type": "esriFieldTypeInteger" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "length": 150, "name": "content_type", "alias": "content_type", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "length": 2048, "name": "keywords", "alias": "keywords", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "length": 1073741822, "name": "exifinfo", "alias": "exifinfo", "type": "esriFieldTypeString" } ], "datesInUnknownTimezone": false, "type": "Table", "supportsAttachmentsByUploadId": true, "syncEnabled": false, "editingInfo": {"lastEditDate": 1770833184082}, "relationships": [ { "keyField": "assetguid", "role": "esriRelRoleDestination", "composite": false, "name": "", "relatedTableId": 0, "id": 1, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "cimVersion": "3.5.0", "isDataArchived": false, "id": 1, "supportsSubtypeEditing": true, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "Notifications", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "custresponsedate": null, "notes": null, "address": null, "assetguid": null, "notifdate": null, "nonresponsive": null, "notifmethod": null, "custresponse": null, "notifreason": null } } } ], "supportsAdvancedQueries": true, "currentVersion": 11.5, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "hasContingentValuesDefinition": false, "viewSourceHasAttachments": true, "name": "Notifications", "displayField": "notes", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "objectid", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 2000, "type": "esriFieldTypeString", "modelName": "notes", "domain": null, "name": "notes", "alias": "Notes" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 38, "type": "esriFieldTypeGUID", "modelName": "assetguid", "domain": null, "name": "assetguid", "alias": "Asset Guid" }, { "nullable": true, "editable": false, "defaultValue": null, "precision": 1, "length": 29, "type": "esriFieldTypeDate", "modelName": "creationdate", "domain": null, "name": "creationdate", "alias": "CreationDate" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 128, "type": "esriFieldTypeString", "modelName": "creator", "domain": null, "name": "creator", "alias": "Creator" }, { "nullable": true, "editable": false, "defaultValue": null, "precision": 1, "length": 29, "type": "esriFieldTypeDate", "modelName": "editdate", "domain": null, "name": "editdate", "alias": "EditDate" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 128, "type": "esriFieldTypeString", "modelName": "editor", "domain": null, "name": "editor", "alias": "Editor" }, { "nullable": false, "editable": false, "defaultValue": null, "length": 38, "type": "esriFieldTypeGlobalID", "modelName": "globalid", "domain": null, "name": "globalid", "alias": "GlobalID" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 256, "type": "esriFieldTypeString", "modelName": "notifreason", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Notifications_notifreason", "description": "", "type": "codedValue", "codedValues": [ { "code": "Material Requires Notification", "name": "Material Requires Notification" }, { "code": "Service Line Replacement", "name": "Service Line Replacement" }, { "code": "Service Line Disturbance", "name": "Service Line Disturbance" }, { "code": "Action Level Exceedance", "name": "Action Level Exceedance" }, { "code": "Other", "name": "Other" }, { "code": "Tap Sampling", "name": "Tap Sampling" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "notifreason", "alias": "Reason for Notification" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 256, "type": "esriFieldTypeString", "modelName": "notifmethod", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Notifications_notifmethod", "description": "", "type": "codedValue", "codedValues": [ { "code": "Phone", "name": "Phone" }, { "code": "Mail", "name": "Mail" }, { "code": "Email", "name": "Email" }, { "code": "Site Visit", "name": "Site Visit" }, { "code": "Door Hanger", "name": "Door Hanger" }, { "code": "Other", "name": "Other" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "notifmethod", "alias": "Notification Method" }, { "nullable": true, "editable": true, "defaultValue": null, "precision": 1, "length": 29, "type": "esriFieldTypeDate", "modelName": "notifdate", "domain": null, "name": "notifdate", "alias": "Notification Date" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 256, "type": "esriFieldTypeString", "modelName": "custresponse", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Notifications_custresponse", "description": "", "type": "codedValue", "codedValues": [ { "code": "Approved Replacement", "name": "Approved Replacement" }, { "code": "Denied Replacement", "name": "Denied Replacement" }, { "code": "Approved Sampling", "name": "Approved Sampling" }, { "code": "Denied Sampling", "name": "Denied Sampling" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "custresponse", "alias": "Customer Response to Notification" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 256, "type": "esriFieldTypeString", "modelName": "nonresponsive", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Notifications_nonresponsive", "description": "", "type": "codedValue", "codedValues": [ { "code": "Yes", "name": "Yes" }, { "code": "Not Yet", "name": "Not Yet" }, { "code": "Customer Responded", "name": "Customer Responded" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "nonresponsive", "alias": "Non-Responsive for 30 Days" }, { "nullable": true, "editable": true, "defaultValue": null, "precision": 1, "length": 29, "type": "esriFieldTypeDate", "modelName": "custresponsedate", "domain": null, "name": "custresponsedate", "alias": "Customer Response Date" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 256, "type": "esriFieldTypeString", "modelName": "address", "domain": null, "name": "address", "alias": "Address" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": true, "isView": true, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "isUpdatableView": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "supportsTruncate": false, "indexes": [ { "name": "g132assetguid", "isUnique": false, "description": "", "fields": "assetguid", "isAscending": true }, { "name": "i132creationdate", "isUnique": false, "description": "", "fields": "creationdate", "isAscending": true }, { "name": "i132creator", "isUnique": false, "description": "", "fields": "creator", "isAscending": true }, { "name": "i132editdate", "isUnique": false, "description": "", "fields": "editdate", "isAscending": true }, { "name": "i132editor", "isUnique": false, "description": "", "fields": "editor", "isAscending": true }, { "name": "r73_sde_rowid_uk", "isUnique": false, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_73", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": { "editDateField": "editdate", "editorField": "editor", "creationDateField": "creationdate", "creatorField": "creator" }, "htmlPopupType": "esriServerHTMLPopupTypeNone", "GUIDFormat": "O", "hasAttachments": true, "queryBinsCapabilities": { "supportsFirstDayOfWeek": false, "supportedNormalizationTypes": [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ], "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsNormalization": true, "supportsSnapToData": true, "supportsFixedIntervalBin": true, "supportsStackBy": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true, "supportsSplitBy": true, "supportsReturnFullIntervalBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "fullTextSearchCapabilities": { "supportsOperator": true, "supportsSearchOperator": true }, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": false, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "fullTextSearchableFields": [], "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": true, "supportsLod": false, "supportsSpatialAggregationStatistics": false, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsCountOnly": true, "supportsReturningQueryExtent": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "subtypeField": "", "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "10d4385e791748bcb6bf243bc5cdc894", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "sourceSchemaChangesAllowed": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "csv,excel,featureCollection,featureService,geojson,imageCollection,jsonl,pbf,shapefile", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.4.0", "copyrightText": "", "zDefault": 0, "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 1000, "attachmentProperties": [ { "fieldName": "attachmentid", "isEnabled": true, "name": "id" }, { "fieldName": "globalid", "isEnabled": true, "name": "globalId" }, { "fieldName": "att_name", "isEnabled": true, "name": "name" }, { "fieldName": "data_size", "isEnabled": true, "name": "size" }, { "fieldName": "content_type", "isEnabled": true, "name": "contentType" }, { "fieldName": "keywords", "isEnabled": true, "name": "keywords" }, { "fieldName": "exifinfo", "isEnabled": true, "name": "exifInfo" } ], "attachmentFields": [ { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "attachmentid", "alias": "attachmentid", "type": "esriFieldTypeOID" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "length": 38, "name": "globalid", "alias": "globalid", "type": "esriFieldTypeGlobalID" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "length": 250, "name": "att_name", "alias": "att_name", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "data_size", "alias": "data_size", "type": "esriFieldTypeInteger" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "length": 150, "name": "content_type", "alias": "content_type", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "length": 2048, "name": "keywords", "alias": "keywords", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "length": 1073741822, "name": "exifinfo", "alias": "exifinfo", "type": "esriFieldTypeString" } ], "datesInUnknownTimezone": false, "type": "Table", "supportsAttachmentsByUploadId": true, "syncEnabled": false, "editingInfo": {"lastEditDate": 1770833185878}, "relationships": [ { "keyField": "assetguid", "role": "esriRelRoleDestination", "composite": false, "name": "", "relatedTableId": 0, "id": 0, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "cimVersion": "3.5.0", "isDataArchived": false, "id": 3, "supportsSubtypeEditing": true, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "Sampling", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "samplingsite": null, "notes": null, "address": null, "resultnotifieddate": null, "samplingperiod": null, "samplingreason": null, "labsampleidfirst": null, "sampledby": null, "leadfifthliter": null, "leadfirstliter": null, "tier": null, "sampledeliverdate": null, "postreplacementsampling": null, "highresultlead": null, "assetguid": null, "sampledate": null, "replacestatus": null, "resultdate": null, "copperfirstliter": null, "labsampleidfifth": null } } } ], "supportsAdvancedQueries": true, "currentVersion": 11.5, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "hasContingentValuesDefinition": false, "viewSourceHasAttachments": true, "name": "Sampling", "displayField": "labsampleidfirst", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "objectid", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeDouble", "modelName": "leadfirstliter", "domain": null, "name": "leadfirstliter", "alias": "Lead - 1st Liter (mg/L)" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeDouble", "modelName": "leadfifthliter", "domain": null, "name": "leadfifthliter", "alias": "Lead - 5th Liter (mg/L)" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeDouble", "modelName": "copperfirstliter", "domain": null, "name": "copperfirstliter", "alias": "Copper - 1st Liter (mg/L)" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 50, "type": "esriFieldTypeString", "modelName": "labsampleidfirst", "domain": null, "name": "labsampleidfirst", "alias": "Lab Sample ID - 1st Liter" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "labsampleidfifth", "domain": null, "name": "labsampleidfifth", "alias": "Lab Sample ID - 5th Liter" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 2000, "type": "esriFieldTypeString", "modelName": "notes", "domain": null, "name": "notes", "alias": "Notes" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 38, "type": "esriFieldTypeGUID", "modelName": "assetguid", "domain": null, "name": "assetguid", "alias": "Asset Guid" }, { "nullable": false, "editable": false, "defaultValue": null, "length": 38, "type": "esriFieldTypeGlobalID", "modelName": "globalid", "domain": null, "name": "globalid", "alias": "GlobalID" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "created_user", "domain": null, "name": "created_user", "alias": "created_user" }, { "nullable": true, "editable": false, "defaultValue": null, "precision": 1, "length": 29, "type": "esriFieldTypeDate", "modelName": "created_date", "domain": null, "name": "created_date", "alias": "created_date" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "last_edited_user", "domain": null, "name": "last_edited_user", "alias": "last_edited_user" }, { "nullable": true, "editable": false, "defaultValue": null, "precision": 1, "length": 29, "type": "esriFieldTypeDate", "modelName": "last_edited_date", "domain": null, "name": "last_edited_date", "alias": "last_edited_date" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeDouble", "modelName": "highresultlead", "domain": null, "name": "highresultlead", "alias": "Lead - Higher Result" }, { "nullable": true, "editable": true, "defaultValue": null, "precision": 1, "length": 29, "type": "esriFieldTypeDate", "modelName": "resultdate", "domain": null, "name": "resultdate", "alias": "Result Received Date" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 256, "type": "esriFieldTypeString", "modelName": "samplingreason", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Sampling_samplingreason", "description": "", "type": "codedValue", "codedValues": [ { "code": "Compliance for 90th Percentile", "name": "Compliance for 90th Percentile" }, { "code": "Voluntary", "name": "Voluntary" }, { "code": "Post Replacement", "name": "Post Replacement" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "samplingreason", "alias": "Reason for Sampling" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 256, "type": "esriFieldTypeString", "modelName": "sampledby", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Sampling_sampledby", "description": "", "type": "codedValue", "codedValues": [ { "code": "Homeowner", "name": "Homeowner" }, { "code": "Utility", "name": "Utility" }, { "code": "Other", "name": "Other" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "sampledby", "alias": "Sampled By" }, { "nullable": true, "editable": true, "defaultValue": null, "precision": 1, "length": 29, "type": "esriFieldTypeDate", "modelName": "sampledate", "domain": null, "name": "sampledate", "alias": "Sampling Date" }, { "nullable": true, "editable": true, "defaultValue": null, "precision": 1, "length": 29, "type": "esriFieldTypeDate", "modelName": "resultnotifieddate", "domain": null, "name": "resultnotifieddate", "alias": "Sample Result Notification Date" }, { "nullable": true, "editable": true, "defaultValue": null, "precision": 1, "length": 29, "type": "esriFieldTypeDate", "modelName": "sampledeliverdate", "domain": null, "name": "sampledeliverdate", "alias": "Sample Kit Delivered Date" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 256, "type": "esriFieldTypeString", "modelName": "address", "domain": null, "name": "address", "alias": "Address" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 256, "type": "esriFieldTypeString", "modelName": "replacestatus", "domain": null, "name": "replacestatus", "alias": "Full Line Replacement Status" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 256, "type": "esriFieldTypeString", "modelName": "tier", "domain": null, "name": "tier", "alias": "Tier" }, { "nullable": true, "editable": true, "defaultValue": null, "precision": 1, "length": 29, "type": "esriFieldTypeDate", "modelName": "postreplacementsampling", "domain": null, "name": "postreplacementsampling", "alias": "Date to Start Post Replacement Sampling Activities" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 256, "type": "esriFieldTypeString", "modelName": "samplingsite", "domain": null, "name": "samplingsite", "alias": "Compliance Sampling Site" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 256, "type": "esriFieldTypeString", "modelName": "samplingperiod", "domain": null, "name": "samplingperiod", "alias": "Sampling Period Year" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": true, "isView": true, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "isUpdatableView": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "supportsTruncate": false, "indexes": [ { "name": "g134assetguid", "isUnique": false, "description": "", "fields": "assetguid", "isAscending": true }, { "name": "i134created_date", "isUnique": false, "description": "", "fields": "created_date", "isAscending": true }, { "name": "i134created_user", "isUnique": false, "description": "", "fields": "created_user", "isAscending": true }, { "name": "i134last_edited_", "isUnique": false, "description": "", "fields": "last_edited_date", "isAscending": true }, { "name": "i134last_edited__1", "isUnique": false, "description": "", "fields": "last_edited_user", "isAscending": true }, { "name": "r75_sde_rowid_uk", "isUnique": false, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_75", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": { "editDateField": "last_edited_date", "editorField": "last_edited_user", "creationDateField": "created_date", "creatorField": "created_user" }, "htmlPopupType": "esriServerHTMLPopupTypeNone", "GUIDFormat": "O", "hasAttachments": true, "queryBinsCapabilities": { "supportsFirstDayOfWeek": false, "supportedNormalizationTypes": [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ], "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsNormalization": true, "supportsSnapToData": true, "supportsFixedIntervalBin": true, "supportsStackBy": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true, "supportsSplitBy": true, "supportsReturnFullIntervalBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "fullTextSearchCapabilities": { "supportsOperator": true, "supportsSearchOperator": true }, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": false, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "fullTextSearchableFields": [], "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": true, "supportsLod": false, "supportsSpatialAggregationStatistics": false, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsCountOnly": true, "supportsReturningQueryExtent": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "subtypeField": "", "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "10d4385e791748bcb6bf243bc5cdc894", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "sourceSchemaChangesAllowed": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "csv,excel,featureCollection,featureService,geojson,imageCollection,jsonl,pbf,shapefile", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.4.0", "copyrightText": "", "zDefault": 0, "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 1000, "attachmentProperties": [ { "fieldName": "attachmentid", "isEnabled": true, "name": "id" }, { "fieldName": "globalid", "isEnabled": true, "name": "globalId" }, { "fieldName": "att_name", "isEnabled": true, "name": "name" }, { "fieldName": "data_size", "isEnabled": true, "name": "size" }, { "fieldName": "content_type", "isEnabled": true, "name": "contentType" }, { "fieldName": "keywords", "isEnabled": true, "name": "keywords" }, { "fieldName": "exifinfo", "isEnabled": true, "name": "exifInfo" } ], "attachmentFields": [ { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "attachmentid", "alias": "attachmentid", "type": "esriFieldTypeOID" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "length": 38, "name": "globalid", "alias": "globalid", "type": "esriFieldTypeGlobalID" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "length": 250, "name": "att_name", "alias": "att_name", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "data_size", "alias": "data_size", "type": "esriFieldTypeInteger" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "length": 150, "name": "content_type", "alias": "content_type", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "length": 2048, "name": "keywords", "alias": "keywords", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "length": 1073741822, "name": "exifinfo", "alias": "exifinfo", "type": "esriFieldTypeString" } ], "datesInUnknownTimezone": false, "type": "Table", "supportsAttachmentsByUploadId": true, "syncEnabled": false, "editingInfo": {"lastEditDate": 1770833188634}, "relationships": [ { "keyField": "assetguid", "role": "esriRelRoleDestination", "composite": false, "name": "", "relatedTableId": 0, "id": 2, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "cimVersion": "3.5.0", "isDataArchived": false, "id": 5, "supportsSubtypeEditing": true, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "School_Childcare_Sampling", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "notes": null, "labidcc1": null, "sampledby": null, "labidcc2": null, "scheduledate": null, "leadssite1": null, "leadssite2": null, "ccsite1": null, "leadssite3": null, "ccsite2": null, "leadssite4": null, "sampledate": null, "leadssite5": null, "assetguid": null, "leadccsite2": null, "leadccsite1": null, "ccpriorityrank": null, "address": null, "resultnotifieddate": null, "schoolpriorityrank": null, "labids4": null, "ssite1": null, "sampledeliverdate": null, "labids3": null, "labids5": null, "ssite5": null, "ssite4": null, "resultdate": null, "labids2": null, "ssite3": null, "location": null, "facilitytype": null, "labids1": null, "ssite2": null, "waiver": null } } } ], "supportsAdvancedQueries": true, "currentVersion": 11.5, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "hasContingentValuesDefinition": false, "viewSourceHasAttachments": true, "name": "School_Childcare_Sampling", "displayField": "facilitytype", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "objectid", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "facilitytype", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "SchoolChildcareSampling_facilitytype", "description": "", "type": "codedValue", "codedValues": [ { "code": "School", "name": "School" }, { "code": "Childcare", "name": "Childcare" }, { "code": "Both School and Childcare", "name": "Both School and Childcare" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "facilitytype", "alias": "Facility Type" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "sampledby", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "SchoolChildcareSampling_sampledby", "description": "", "type": "codedValue", "codedValues": [ { "code": "School Childcare Staff", "name": "School Childcare Staff" }, { "code": "Utility", "name": "Utility" }, { "code": "Other", "name": "Other" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "sampledby", "alias": "Sampled By" }, { "nullable": true, "editable": true, "defaultValue": null, "precision": 1, "length": 29, "type": "esriFieldTypeDate", "modelName": "sampledate", "domain": null, "name": "sampledate", "alias": "Sampling Date" }, { "nullable": true, "editable": true, "defaultValue": null, "precision": 1, "length": 29, "type": "esriFieldTypeDate", "modelName": "resultdate", "domain": null, "name": "resultdate", "alias": "Result Received Date" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeDouble", "modelName": "leadssite1", "domain": null, "name": "leadssite1", "alias": "Lead - School Site 1 (mg/L)" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeDouble", "modelName": "leadssite2", "domain": null, "name": "leadssite2", "alias": "Lead - School Site 2 (mg/L)" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeDouble", "modelName": "leadssite3", "domain": null, "name": "leadssite3", "alias": "Lead - School Site 3 (mg/L)" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeDouble", "modelName": "leadssite4", "domain": null, "name": "leadssite4", "alias": "Lead - School Site 4 (mg/L)" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeDouble", "modelName": "leadssite5", "domain": null, "name": "leadssite5", "alias": "Lead - School Site 5 (mg/L)" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "labids1", "domain": null, "name": "labids1", "alias": "Lab Sample ID - School Site 1" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "labids2", "domain": null, "name": "labids2", "alias": "Lab Sample ID - School Site 2" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "labids3", "domain": null, "name": "labids3", "alias": "Lab Sample ID - School Site 3" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "labids4", "domain": null, "name": "labids4", "alias": "Lab Sample ID - School Site 4" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "labids5", "domain": null, "name": "labids5", "alias": "Lab Sample ID - School Site 5" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "ssite1", "domain": null, "name": "ssite1", "alias": "School Site 1 Description" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "ssite2", "domain": null, "name": "ssite2", "alias": "School Site 2 Description" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "ssite3", "domain": null, "name": "ssite3", "alias": "School Site 3 Description" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "ssite4", "domain": null, "name": "ssite4", "alias": "School Site 4 Description" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "ssite5", "domain": null, "name": "ssite5", "alias": "School Site 5 Description" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeDouble", "modelName": "leadccsite1", "domain": null, "name": "leadccsite1", "alias": "Lead - CC Site 1 (mg/L)" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeDouble", "modelName": "leadccsite2", "domain": null, "name": "leadccsite2", "alias": "Lead - CC Site 2 (mg/L)" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "labidcc1", "domain": null, "name": "labidcc1", "alias": "Lab Sample ID - CC Site 1" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "labidcc2", "domain": null, "name": "labidcc2", "alias": "Lab Sample ID - CC Site 2" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "ccsite1", "domain": null, "name": "ccsite1", "alias": "CC Site 1 Description" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "ccsite2", "domain": null, "name": "ccsite2", "alias": "CC Site 2 Description" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "notes", "domain": null, "name": "notes", "alias": "Notes" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 38, "type": "esriFieldTypeGUID", "modelName": "assetguid", "domain": null, "name": "assetguid", "alias": "Asset Guid" }, { "nullable": false, "editable": false, "defaultValue": null, "length": 38, "type": "esriFieldTypeGlobalID", "modelName": "globalid", "domain": null, "name": "globalid", "alias": "GlobalID" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "created_user", "domain": null, "name": "created_user", "alias": "created_user" }, { "nullable": true, "editable": false, "defaultValue": null, "precision": 1, "length": 29, "type": "esriFieldTypeDate", "modelName": "created_date", "domain": null, "name": "created_date", "alias": "created_date" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "last_edited_user", "domain": null, "name": "last_edited_user", "alias": "last_edited_user" }, { "nullable": true, "editable": false, "defaultValue": null, "precision": 1, "length": 29, "type": "esriFieldTypeDate", "modelName": "last_edited_date", "domain": null, "name": "last_edited_date", "alias": "last_edited_date" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "waiver", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "School_Childcare_Sampling_waiver", "description": "", "type": "codedValue", "codedValues": [ { "code": "Yes", "name": "Yes" }, { "code": "No", "name": "No" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "waiver", "alias": "Waiver Granted for Previous Sampling" }, { "nullable": true, "editable": true, "defaultValue": null, "precision": 1, "length": 29, "type": "esriFieldTypeDate", "modelName": "resultnotifieddate", "domain": null, "name": "resultnotifieddate", "alias": "Sample Result Notification Date" }, { "nullable": true, "editable": true, "defaultValue": null, "precision": 1, "length": 29, "type": "esriFieldTypeDate", "modelName": "sampledeliverdate", "domain": null, "name": "sampledeliverdate", "alias": "Sample Kit Delivered Date" }, { "nullable": true, "editable": true, "defaultValue": null, "precision": 1, "length": 29, "type": "esriFieldTypeDate", "modelName": "scheduledate", "domain": null, "name": "scheduledate", "alias": "Sample Schedule Date" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 256, "type": "esriFieldTypeString", "modelName": "address", "domain": null, "name": "address", "alias": "Address" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeInteger", "modelName": "schoolpriorityrank", "domain": null, "name": "schoolpriorityrank", "alias": "School Priority Rank" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeInteger", "modelName": "ccpriorityrank", "domain": null, "name": "ccpriorityrank", "alias": "Childcare Priority Rank" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 256, "type": "esriFieldTypeString", "modelName": "location", "domain": null, "name": "location", "alias": "Other Location Identifier" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": true, "isView": true, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "isUpdatableView": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "supportsTruncate": false, "indexes": [ { "name": "g137assetguid", "isUnique": false, "description": "", "fields": "assetguid", "isAscending": true }, { "name": "i137created_date", "isUnique": false, "description": "", "fields": "created_date", "isAscending": true }, { "name": "i137created_user", "isUnique": false, "description": "", "fields": "created_user", "isAscending": true }, { "name": "i137last_edited_", "isUnique": false, "description": "", "fields": "last_edited_date", "isAscending": true }, { "name": "i137last_edited__1", "isUnique": false, "description": "", "fields": "last_edited_user", "isAscending": true }, { "name": "r78_sde_rowid_uk", "isUnique": false, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_78", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": { "editDateField": "last_edited_date", "editorField": "last_edited_user", "creationDateField": "created_date", "creatorField": "created_user" }, "htmlPopupType": "esriServerHTMLPopupTypeNone", "GUIDFormat": "O", "hasAttachments": true, "queryBinsCapabilities": { "supportsFirstDayOfWeek": false, "supportedNormalizationTypes": [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ], "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsNormalization": true, "supportsSnapToData": true, "supportsFixedIntervalBin": true, "supportsStackBy": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true, "supportsSplitBy": true, "supportsReturnFullIntervalBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "fullTextSearchCapabilities": { "supportsOperator": true, "supportsSearchOperator": true }, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": false, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "fullTextSearchableFields": [], "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": true, "supportsLod": false, "supportsSpatialAggregationStatistics": false, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsCountOnly": true, "supportsReturningQueryExtent": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "subtypeField": "", "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "10d4385e791748bcb6bf243bc5cdc894", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "sourceSchemaChangesAllowed": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "csv,excel,featureCollection,featureService,geojson,imageCollection,jsonl,pbf,shapefile", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.4.0", "copyrightText": "", "zDefault": 0, "supportsLayerOverrides": true } ], "layers": [ { "isCoGoEnabled": false, "extent": { "ymin": 4288808.952800006, "zmin": 0, "xmin": -8916520.562899996, "ymax": 4312856.3445999995, "zmax": 0, "xmax": -8895448.929, "mmax": -9.999E35, "mmin": -9.999E35, "spatialReference": { "falseM": -100000, "xyTolerance": 0.001, "mUnits": 10000, "zUnits": 10000, "latestWkid": 3857, "zTolerance": 0.001, "wkid": 102100, "xyUnits": 1.4892314192838538E8, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "falseZ": -100000 } }, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 1000, "attachmentProperties": [ { "fieldName": "attachmentid", "isEnabled": true, "name": "id" }, { "fieldName": "globalid", "isEnabled": true, "name": "globalId" }, { "fieldName": "att_name", "isEnabled": true, "name": "name" }, { "fieldName": "data_size", "isEnabled": true, "name": "size" }, { "fieldName": "content_type", "isEnabled": true, "name": "contentType" }, { "fieldName": "keywords", "isEnabled": true, "name": "keywords" }, { "fieldName": "exifinfo", "isEnabled": true, "name": "exifInfo" } ], "attachmentFields": [ { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "attachmentid", "alias": "attachmentid", "type": "esriFieldTypeOID" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "length": 38, "name": "globalid", "alias": "globalid", "type": "esriFieldTypeGlobalID" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "length": 250, "name": "att_name", "alias": "att_name", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "data_size", "alias": "data_size", "type": "esriFieldTypeInteger" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "length": 150, "name": "content_type", "alias": "content_type", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "length": 2048, "name": "keywords", "alias": "keywords", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "length": 1073741822, "name": "exifinfo", "alias": "exifinfo", "type": "esriFieldTypeString" } ], "datesInUnknownTimezone": false, "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "supportsAttachmentsByUploadId": true, "syncEnabled": false, "editingInfo": {"lastEditDate": 1775145125635}, "relationships": [ { "keyField": "globalid", "role": "esriRelRoleOrigin", "composite": false, "name": "", "relatedTableId": 3, "id": 0, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "globalid", "role": "esriRelRoleOrigin", "composite": false, "name": "", "relatedTableId": 1, "id": 1, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "globalid", "role": "esriRelRoleOrigin", "composite": false, "name": "", "relatedTableId": 5, "id": 2, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "cimVersion": "3.5.0", "isDataArchived": false, "id": 0, "spatialReference": { "falseM": -100000, "xyTolerance": 0.001, "mUnits": 10000, "zUnits": 10000, "latestWkid": 3857, "zTolerance": 0.001, "wkid": 102100, "xyUnits": 1.4892314192838538E8, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "falseZ": -100000 }, "supportsSubtypeEditing": true, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "ServiceLine", "description": "", "drawingTool": "esriFeatureEditToolPoint", "prototype": { "attributes": { "samplingsite": null, "serviceuse": null, "utilreplacedate": null, "utilpredmat": null, "disadvantaged": null, "utilmaterial": null, "replpriorityrank": null, "servicestatus": null, "utilreplacestatus": null, "accountid": null, "filterscheddate": null, "utilpredprob": null, "utilassetid": null, "custreplacedate": null, "utilmaterialoriginal": null, "custbasisclass": null, "leadsolder": null, "bothsidesstatus": null, "custpredprob": null, "state": null, "custassetid": null, "zip": null, "custpredmat": null, "utilverified": null, "sensitivepop": null, "utilstatus": null, "utilscheddate": null, "utilverifmethod": null, "custscheddate": null, "everlead": null, "custdiameter": null, "otherfittings": null, "custresponsetotal": null, "schoolpriorityrank": null, "utilnotes": null, "replacestatus": null, "custreplacestatus": null, "filterprovidedate": null, "connectorstatus": null, "custverified": null, "city": null, "utilinstalldate": null, "lastmodeldate": null, "custinstalldate": null, "connectorscheddate": null, "newcustomerdate": null, "custnotes": null, "tier": null, "utilmaterialreplaced": null, "ccpriorityrank": null, "custverifmethod": null, "address": null, "utilbasisclass": null, "utildiameter": null, "utilverifdate": null, "connectorreplacedate": null, "buildingtype": null, "custstatus": null, "filter": null, "custmaterialreplaced": null, "custmaterial": null, "custmaterialoriginal": null, "location": null, "custverifdate": null, "pointofentry": null, "copperwithlead": null } } } ], "supportsAdvancedQueries": true, "parentLayer": null, "currentVersion": 11.5, "canScaleSymbols": false, "hasZ": true, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "hasContingentValuesDefinition": false, "viewSourceHasAttachments": true, "name": "ServiceLine", "allowTrueCurvesUpdates": false, "displayField": "accountid", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "objectid", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "accountid", "domain": null, "name": "accountid", "alias": "EPA ID" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "address", "domain": null, "name": "address", "alias": "Address" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "location", "domain": null, "name": "location", "alias": "Other Location Identifier" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 15, "type": "esriFieldTypeString", "modelName": "sensitivepop", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "ServiceLine_sensitivepopulation", "description": "", "type": "codedValue", "codedValues": [ { "code": "Yes - School", "name": "Yes - School" }, { "code": "Yes - Day Care", "name": "Yes - Day Care" }, { "code": "Yes - MF Home", "name": "Yes - Multifamily Home" }, { "code": "Yes - Other", "name": "Yes - Other" }, { "code": "No", "name": "No" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "sensitivepop", "alias": "Sensitive Population" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 15, "type": "esriFieldTypeString", "modelName": "disadvantaged", "domain": { "splitPolicy": "esriSPTDuplicate", "name": "ServiceLine_yesno", "description": "", "type": "codedValue", "codedValues": [ { "code": "Yes", "name": "Yes" }, { "code": "No", "name": "No" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "disadvantaged", "alias": "Disadvantaged Neighborhood" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "utilassetid", "domain": null, "name": "utilassetid", "alias": "Utility Asset ID" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "utilmaterial", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "ServiceLine_utilmaterial", "description": "", "type": "codedValue", "codedValues": [ { "code": "Lead", "name": "Lead" }, { "code": "Lead-lined galvanized", "name": "Lead-lined galvanized" }, { "code": "Galvanized", "name": "Galvanized" }, { "code": "Non-Lead - Copper", "name": "Non-Lead - Copper" }, { "code": "Non-Lead - Plastic", "name": "Non-Lead - Plastic" }, { "code": "Non-Lead - Other", "name": "Non-Lead - Other" }, { "code": "Unknown - Material Unknown", "name": "Unknown - Material Unknown" }, { "code": "Unknown - Likely Lead", "name": "Unknown - Likely Lead" }, { "code": "Unknown - Unlikely Lead", "name": "Unknown - Unlikely Lead" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "utilmaterial", "alias": "Utility Material" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 15, "type": "esriFieldTypeString", "modelName": "everlead", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "ServiceLine_everlead", "description": "", "type": "codedValue", "codedValues": [ { "code": "Yes", "name": "Yes" }, { "code": "No", "name": "No" }, { "code": "Don't know", "name": "Don't know" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "everlead", "alias": "Ever Lead?" }, { "nullable": true, "editable": true, "defaultValue": null, "precision": 1, "length": 29, "type": "esriFieldTypeDate", "modelName": "utilinstalldate", "domain": null, "name": "utilinstalldate", "alias": "Utility Install Date" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeDouble", "modelName": "utildiameter", "domain": { "splitPolicy": "esriSPTDuplicate", "name": "ServiceLine_diameter", "description": "", "type": "codedValue", "codedValues": [ { "code": -1, "name": "Unknown" }, { "code": 0.25, "name": "1/4\"" }, { "code": 0.5, "name": "1/2\"" }, { "code": 0.625, "name": "5/8\"" }, { "code": 0.75, "name": "3/4\"" }, { "code": 1, "name": "1\"" }, { "code": 1.25, "name": "1 1/4\"" }, { "code": 1.5, "name": "1 1/2\"" }, { "code": 1.75, "name": "1 3/4\"" }, { "code": 2, "name": "2\"" }, { "code": 2.25, "name": "2 1/4\"" }, { "code": 2.5, "name": "2 1/2\"" }, { "code": 3, "name": "3\"" }, { "code": 4, "name": "4\"" }, { "code": 4.5, "name": "4 1/2\"" }, { "code": 5.25, "name": "5 1/4\"" }, { "code": 6, "name": "6\"" }, { "code": 8, "name": "8\"" }, { "code": 10, "name": "10\"" }, { "code": 998, "name": "Known less than 2\"" }, { "code": 999, "name": "Known greater than 2\"" }, { "code": 3.25, "name": "3 1/4\"" }, { "code": 3.5, "name": "3 1/2\"" }, { "code": 3.75, "name": "3 3/4\"" }, { "code": 4.25, "name": "4 1/4\"" }, { "code": 4.75, "name": "4 3/4\"" }, { "code": 5, "name": "5\"" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "utildiameter", "alias": "Utility Diameter" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "utilverified", "domain": { "splitPolicy": "esriSPTDuplicate", "name": "ServiceLine_yesno", "description": "", "type": "codedValue", "codedValues": [ { "code": "Yes", "name": "Yes" }, { "code": "No", "name": "No" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "utilverified", "alias": "Utility Side Verified" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 100, "type": "esriFieldTypeString", "modelName": "utilverifmethod", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "ServiceLine_utilverifmethod", "description": "", "type": "codedValue", "codedValues": [ { "code": "Visual inspection at the meter pit", "name": "Visual inspection at the meter pit" }, { "code": "CCTV investigation at curb stop - internal", "name": "CCTV investigation at curb stop - internal" }, { "code": "CCTV investigation at curb stop - external", "name": "CCTV investigation at curb stop - external" }, { "code": "Water quality sampling", "name": "Water quality sampling" }, { "code": "Mechanical excavation at one location", "name": "Mechanical excavation at one location" }, { "code": "Mechanical excavation at multiple locations", "name": "Mechanical excavation at multiple locations" }, { "code": "Other", "name": "Other" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "utilverifmethod", "alias": "Utility Verification Method" }, { "nullable": true, "editable": true, "defaultValue": null, "precision": 1, "length": 29, "type": "esriFieldTypeDate", "modelName": "utilverifdate", "domain": null, "name": "utilverifdate", "alias": "Utility Verification Date" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "utilstatus", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "ServiceLine_utilstatus", "description": "", "type": "codedValue", "codedValues": [ { "code": "Lead", "name": "Lead" }, { "code": "Non-Lead", "name": "Non-Lead" }, { "code": "Unknown", "name": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "utilstatus", "alias": "Utility Service Line Lead Classification" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 2000, "type": "esriFieldTypeString", "modelName": "utilnotes", "domain": null, "name": "utilnotes", "alias": "Utility Side Notes" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "custassetid", "domain": null, "name": "custassetid", "alias": "Customer Asset ID" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "custmaterial", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "ServiceLine_material", "description": "", "type": "codedValue", "codedValues": [ { "code": "Lead", "name": "Lead" }, { "code": "Lead-lined galvanized", "name": "Lead-lined galvanized" }, { "code": "Galvanized", "name": "Galvanized" }, { "code": "Non-Lead - Copper", "name": "Non-Lead - Copper" }, { "code": "Non-Lead - Plastic", "name": "Non-Lead - Plastic" }, { "code": "Non-Lead - Other", "name": "Non-Lead - Other" }, { "code": "Unknown - Material Unknown", "name": "Unknown - Material Unknown" }, { "code": "Unknown - Likely Lead", "name": "Unknown - Likely Lead" }, { "code": "Unknown - Unlikely Lead", "name": "Unknown - Unlikely Lead" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "custmaterial", "alias": "Customer Material" }, { "nullable": true, "editable": true, "defaultValue": null, "precision": 1, "length": 29, "type": "esriFieldTypeDate", "modelName": "custinstalldate", "domain": null, "name": "custinstalldate", "alias": "Customer Install Date" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeDouble", "modelName": "custdiameter", "domain": { "splitPolicy": "esriSPTDuplicate", "name": "ServiceLine_diameter", "description": "", "type": "codedValue", "codedValues": [ { "code": -1, "name": "Unknown" }, { "code": 0.25, "name": "1/4\"" }, { "code": 0.5, "name": "1/2\"" }, { "code": 0.625, "name": "5/8\"" }, { "code": 0.75, "name": "3/4\"" }, { "code": 1, "name": "1\"" }, { "code": 1.25, "name": "1 1/4\"" }, { "code": 1.5, "name": "1 1/2\"" }, { "code": 1.75, "name": "1 3/4\"" }, { "code": 2, "name": "2\"" }, { "code": 2.25, "name": "2 1/4\"" }, { "code": 2.5, "name": "2 1/2\"" }, { "code": 3, "name": "3\"" }, { "code": 4, "name": "4\"" }, { "code": 4.5, "name": "4 1/2\"" }, { "code": 5.25, "name": "5 1/4\"" }, { "code": 6, "name": "6\"" }, { "code": 8, "name": "8\"" }, { "code": 10, "name": "10\"" }, { "code": 998, "name": "Known less than 2\"" }, { "code": 999, "name": "Known greater than 2\"" }, { "code": 3.25, "name": "3 1/4\"" }, { "code": 3.5, "name": "3 1/2\"" }, { "code": 3.75, "name": "3 3/4\"" }, { "code": 4.25, "name": "4 1/4\"" }, { "code": 4.75, "name": "4 3/4\"" }, { "code": 5, "name": "5\"" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "custdiameter", "alias": "Customer Diameter" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "custverified", "domain": { "splitPolicy": "esriSPTDuplicate", "name": "ServiceLine_yesno", "description": "", "type": "codedValue", "codedValues": [ { "code": "Yes", "name": "Yes" }, { "code": "No", "name": "No" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "custverified", "alias": "Customer Side Verified" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 100, "type": "esriFieldTypeString", "modelName": "custverifmethod", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "ServiceLine_verificationmethod", "description": "", "type": "codedValue", "codedValues": [ { "code": "Visual inspection at the meter pit", "name": "Visual inspection at the meter pit" }, { "code": "Customer self-identification", "name": "Customer self-identification" }, { "code": "CCTV investigation at curb stop - internal", "name": "CCTV investigation at curb stop - internal" }, { "code": "CCTV investigation at curb stop - external", "name": "CCTV investigation at curb stop - external" }, { "code": "Water quality sampling", "name": "Water quality sampling" }, { "code": "Mechanical excavation at one location", "name": "Mechanical excavation at one location" }, { "code": "Mechanical excavation at multiple locations", "name": "Mechanical excavation at multiple locations" }, { "code": "Other", "name": "Other" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "custverifmethod", "alias": "Customer Verification Method" }, { "nullable": true, "editable": true, "defaultValue": null, "precision": 1, "length": 29, "type": "esriFieldTypeDate", "modelName": "custverifdate", "domain": null, "name": "custverifdate", "alias": "Customer Verification Date" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "custstatus", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "ServiceLine_custstatus", "description": "", "type": "codedValue", "codedValues": [ { "code": "Unknown", "name": "Unknown" }, { "code": "Lead", "name": "Lead" }, { "code": "Non-Lead", "name": "Non-Lead" }, { "code": "Galvanized Requiring Replacement", "name": "Galvanized Requiring Replacement" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "custstatus", "alias": "Customer Service Line Lead Classification" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 2000, "type": "esriFieldTypeString", "modelName": "custnotes", "domain": null, "name": "custnotes", "alias": "Customer Side Notes" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "bothsidesstatus", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "ServiceLine_bothsidesstatus", "description": "", "type": "codedValue", "codedValues": [ { "code": "Lead", "name": "Lead" }, { "code": "Non-Lead", "name": "Non-Lead" }, { "code": "Galvanized Requiring Replacement", "name": "Galvanized Requiring Replacement" }, { "code": "Unknown", "name": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "bothsidesstatus", "alias": "Full Service Line Lead Classification" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 15, "type": "esriFieldTypeString", "modelName": "leadsolder", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "ServiceLine_leadsolder", "description": "", "type": "codedValue", "codedValues": [ { "code": "Yes", "name": "Yes" }, { "code": "No", "name": "No" }, { "code": "Don't Know", "name": "Don't Know" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "leadsolder", "alias": "Lead Solder in Service Line" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 100, "type": "esriFieldTypeString", "modelName": "otherfittings", "domain": null, "name": "otherfittings", "alias": "Premise Other Fittings Containing Lead" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 50, "type": "esriFieldTypeString", "modelName": "buildingtype", "domain": { "splitPolicy": "esriSPTDuplicate", "name": "ServiceLine_buildingtype", "description": "", "type": "codedValue", "codedValues": [ { "code": "Single Family Residence", "name": "Single Family Residence" }, { "code": "Multiple Family Residence", "name": "Multiple Family Residence" }, { "code": "Building", "name": "Building" }, { "code": "Other", "name": "Other" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "buildingtype", "alias": "Building Type" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 15, "type": "esriFieldTypeString", "modelName": "pointofentry", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "ServiceLine_pointofentry", "description": "", "type": "codedValue", "codedValues": [ { "code": "Yes", "name": "Yes" }, { "code": "No", "name": "No" }, { "code": "Unknown", "name": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "pointofentry", "alias": "Premise Point-of-Entry or Point-of-Use" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 15, "type": "esriFieldTypeString", "modelName": "copperwithlead", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "ServiceLine_copperwithlead", "description": "", "type": "codedValue", "codedValues": [ { "code": "Yes", "name": "Yes" }, { "code": "No", "name": "No" }, { "code": "Unknown", "name": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "copperwithlead", "alias": "Premise Copper Pipes with Lead Solder Before Lead Ban" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 15, "type": "esriFieldTypeString", "modelName": "samplingsite", "domain": { "splitPolicy": "esriSPTDuplicate", "name": "ServiceLine_yesno", "description": "", "type": "codedValue", "codedValues": [ { "code": "Yes", "name": "Yes" }, { "code": "No", "name": "No" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "samplingsite", "alias": "Compliance Sampling Site" }, { "nullable": true, "editable": true, "defaultValue": null, "precision": 1, "length": 29, "type": "esriFieldTypeDate", "modelName": "utilscheddate", "domain": null, "name": "utilscheddate", "alias": "Utility Side Scheduled Replacement Date" }, { "nullable": true, "editable": true, "defaultValue": null, "precision": 1, "length": 29, "type": "esriFieldTypeDate", "modelName": "utilreplacedate", "domain": null, "name": "utilreplacedate", "alias": "Utility Side Replacement Date" }, { "nullable": true, "editable": true, "defaultValue": null, "precision": 1, "length": 29, "type": "esriFieldTypeDate", "modelName": "custscheddate", "domain": null, "name": "custscheddate", "alias": "Customer Side Scheduled Replacement Date" }, { "nullable": true, "editable": true, "defaultValue": null, "precision": 1, "length": 29, "type": "esriFieldTypeDate", "modelName": "custreplacedate", "domain": null, "name": "custreplacedate", "alias": "Customer Side Replacement Date" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 15, "type": "esriFieldTypeString", "modelName": "filter", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "ServiceLine_filter", "description": "", "type": "codedValue", "codedValues": [ { "code": "Never Required", "name": "Never Required" }, { "code": "Needs Filter", "name": "Needed After Replacement or Disturbance" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "filter", "alias": "Water Pitcher Filter" }, { "nullable": false, "editable": false, "defaultValue": null, "length": 38, "type": "esriFieldTypeGlobalID", "modelName": "globalid", "domain": null, "name": "globalid", "alias": "GlobalID" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "created_user", "domain": null, "name": "created_user", "alias": "created_user" }, { "nullable": true, "editable": false, "defaultValue": null, "precision": 1, "length": 29, "type": "esriFieldTypeDate", "modelName": "created_date", "domain": null, "name": "created_date", "alias": "created_date" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "last_edited_user", "domain": null, "name": "last_edited_user", "alias": "last_edited_user" }, { "nullable": true, "editable": false, "defaultValue": null, "precision": 1, "length": 29, "type": "esriFieldTypeDate", "modelName": "last_edited_date", "domain": null, "name": "last_edited_date", "alias": "last_edited_date" }, { "nullable": true, "editable": true, "defaultValue": null, "precision": 1, "length": 29, "type": "esriFieldTypeDate", "modelName": "filterscheddate", "domain": null, "name": "filterscheddate", "alias": "Water Pitcher Filter Date Scheduled" }, { "nullable": true, "editable": true, "defaultValue": null, "precision": 1, "length": 29, "type": "esriFieldTypeDate", "modelName": "filterprovidedate", "domain": null, "name": "filterprovidedate", "alias": "Water Pitcher Filter Date Provided" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 256, "type": "esriFieldTypeString", "modelName": "serviceuse", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "ServiceLine_serviceuse", "description": "", "type": "codedValue", "codedValues": [ { "code": "Irrigation", "name": "Irrigation" }, { "code": "Fire", "name": "Fire" }, { "code": "Potable", "name": "Potable" }, { "code": "Other", "name": "Other" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "serviceuse", "alias": "Service Line Use" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 256, "type": "esriFieldTypeString", "modelName": "utilpredmat", "domain": null, "name": "utilpredmat", "alias": "Utility Predicted Material" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeDouble", "modelName": "utilpredprob", "domain": null, "name": "utilpredprob", "alias": "Utility Predicted Material Probability" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 256, "type": "esriFieldTypeString", "modelName": "custpredmat", "domain": null, "name": "custpredmat", "alias": "Customer Predicted Material" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeDouble", "modelName": "custpredprob", "domain": null, "name": "custpredprob", "alias": "Customer Predicted Material Probability" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 256, "type": "esriFieldTypeString", "modelName": "servicestatus", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "ServiceLine_servicestatus", "description": "", "type": "codedValue", "codedValues": [ { "code": "In Service", "name": "In Service" }, { "code": "Out of Service", "name": "Out of Service" }, { "code": "Abandoned/Disconnected", "name": "Abandoned/Disconnected" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "servicestatus", "alias": "Service Line Working Status " }, { "nullable": true, "editable": true, "defaultValue": null, "precision": 1, "length": 29, "type": "esriFieldTypeDate", "modelName": "lastmodeldate", "domain": null, "name": "lastmodeldate", "alias": "Predictive Model Last Run Date" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 256, "type": "esriFieldTypeString", "modelName": "city", "domain": null, "name": "city", "alias": "City" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 256, "type": "esriFieldTypeString", "modelName": "state", "domain": null, "name": "state", "alias": "State" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 256, "type": "esriFieldTypeString", "modelName": "zip", "domain": null, "name": "zip", "alias": "Zip" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 256, "type": "esriFieldTypeString", "modelName": "connectorstatus", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "ServiceLine_connectorstatus", "description": "", "type": "codedValue", "codedValues": [ { "code": "Lead", "name": "Lead" }, { "code": "Non-Lead", "name": "Non-Lead" }, { "code": "Unknown", "name": "Unknown" }, { "code": "No connector present", "name": "No connector present" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "connectorstatus", "alias": "Connector Classification" }, { "nullable": true, "editable": true, "defaultValue": null, "precision": 1, "length": 29, "type": "esriFieldTypeDate", "modelName": "connectorscheddate", "domain": null, "name": "connectorscheddate", "alias": "Connector Scheduled Replacement Date" }, { "nullable": true, "editable": true, "defaultValue": null, "precision": 1, "length": 29, "type": "esriFieldTypeDate", "modelName": "connectorreplacedate", "domain": null, "name": "connectorreplacedate", "alias": "Connector Replacement Date" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 256, "type": "esriFieldTypeString", "modelName": "utilreplacestatus", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "ServiceLine_utilreplacestatus", "description": "", "type": "codedValue", "codedValues": [ { "code": "Doesn't Need Replacement", "name": "Doesn't Need Replacement" }, { "code": "Needs Replacement", "name": "Needs Replacement" }, { "code": "Scheduled Replacement", "name": "Scheduled Replacement" }, { "code": "Replaced", "name": "Replaced" }, { "code": "Customer Denied Replacement", "name": "Customer Denied Replacement" }, { "code": "Non-Responsive Customer", "name": "Non-Responsive Customer" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "utilreplacestatus", "alias": "Utility Side Replacement Status" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 256, "type": "esriFieldTypeString", "modelName": "custreplacestatus", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "ServiceLine_custreplacestatus", "description": "", "type": "codedValue", "codedValues": [ { "code": "Doesn't Need Replacement", "name": "Doesn't Need Replacement" }, { "code": "Needs Replacement", "name": "Needs Replacement" }, { "code": "Scheduled Replacement", "name": "Scheduled Replacement" }, { "code": "Replaced", "name": "Replaced" }, { "code": "Non-Responsive Customer 4 Times", "name": "Non-Responsive Customer 4 Times" }, { "code": "Customer Denied Replacement", "name": "Customer Denied Replacement" }, { "code": "Customer Approved - Needs Scheduled", "name": "Customer Approved - Needs Scheduled" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "custreplacestatus", "alias": "Customer Side Replacement Status" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 256, "type": "esriFieldTypeString", "modelName": "custresponsetotal", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "ServiceLine_custresponsetotal", "description": "", "type": "codedValue", "codedValues": [ { "code": "Approved Replacement", "name": "Approved Replacement" }, { "code": "Denied Replacement", "name": "Denied Replacement" }, { "code": "Doesn't Need Replacement", "name": "Doesn't Need Replacement" }, { "code": "Non-Responsive After 1 of 4 Attempts", "name": "Non-Responsive After 1 of 4 Attempts" }, { "code": "Non-Responsive After 2 of 4 Attempts", "name": "Non-Responsive After 2 of 4 Attempts" }, { "code": "Non-Responsive After 3 of 4 Attempts", "name": "Non-Responsive After 3 of 4 Attempts" }, { "code": "Non-Responsive After 4 Attempts", "name": "Non-Responsive After 4 Attempts" }, { "code": "Awaiting Response", "name": "Awaiting Response" }, { "code": "Coordination Complete", "name": "Coordination Complete" }, { "code": "Need to Notify Customer", "name": "Need to Notify Customer" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "custresponsetotal", "alias": "Customer Response to Replacement Requests" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 256, "type": "esriFieldTypeString", "modelName": "custmaterialoriginal", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "ServiceLine_custmaterialoriginal", "description": "", "type": "codedValue", "codedValues": [ { "code": "Lead", "name": "Lead" }, { "code": "Lead-lined galvanized", "name": "Lead-lined galvanized" }, { "code": "Galvanized", "name": "Galvanized" }, { "code": "Non-Lead - Copper", "name": "Non-Lead - Copper" }, { "code": "Non-Lead - Plastic", "name": "Non-Lead - Plastic" }, { "code": "Non-Lead - Other", "name": "Non-Lead - Other" }, { "code": "Unknown - Material Unknown", "name": "Unknown - Material Unknown" }, { "code": "Unknown - Likely Lead", "name": "Unknown - Likely Lead" }, { "code": "Unknown - Unlikely Lead", "name": "Unknown - Unlikely Lead" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "custmaterialoriginal", "alias": "Customer Material Original" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 256, "type": "esriFieldTypeString", "modelName": "utilmaterialoriginal", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "ServiceLine_utilmaterialoriginal", "description": "", "type": "codedValue", "codedValues": [ { "code": "Lead", "name": "Lead" }, { "code": "Lead-lined galvanized", "name": "Lead-lined galvanized" }, { "code": "Galvanized", "name": "Galvanized" }, { "code": "Non-Lead - Copper", "name": "Non-Lead - Copper" }, { "code": "Non-Lead - Plastic", "name": "Non-Lead - Plastic" }, { "code": "Non-Lead - Other", "name": "Non-Lead - Other" }, { "code": "Unknown - Material Unknown", "name": "Unknown - Material Unknown" }, { "code": "Unknown - Likely Lead", "name": "Unknown - Likely Lead" }, { "code": "Unknown - Unlikely Lead", "name": "Unknown - Unlikely Lead" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "utilmaterialoriginal", "alias": "Utility Material Original" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 256, "type": "esriFieldTypeString", "modelName": "tier", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "ServiceLine_tier", "description": "", "type": "codedValue", "codedValues": [ { "code": "Tier 1", "name": "Tier 1" }, { "code": "Tier 2", "name": "Tier 2" }, { "code": "Tier 3", "name": "Tier 3" }, { "code": "Tier 4", "name": "Tier 4" }, { "code": "Tier 5", "name": "Tier 5" }, { "code": "Need Building Type", "name": "Need Building Type" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "tier", "alias": "Tier" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 256, "type": "esriFieldTypeString", "modelName": "utilmaterialreplaced", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "ServiceLine_utilmaterialreplaced", "description": "", "type": "codedValue", "codedValues": [ { "code": "Non-Lead - Copper", "name": "Non-Lead - Copper" }, { "code": "Non-Lead - Plastic", "name": "Non-Lead - Plastic" }, { "code": "Non-Lead - Other", "name": "Non-Lead - Other" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "utilmaterialreplaced", "alias": "Utility Side Replaced Material" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 256, "type": "esriFieldTypeString", "modelName": "custmaterialreplaced", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "ServiceLine_custmaterialreplaced", "description": "", "type": "codedValue", "codedValues": [ { "code": "Non-Lead - Copper", "name": "Non-Lead - Copper" }, { "code": "Non-Lead - Plastic", "name": "Non-Lead - Plastic" }, { "code": "Non-Lead - Other", "name": "Non-Lead - Other" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "custmaterialreplaced", "alias": "Customer Side Replaced Material" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 256, "type": "esriFieldTypeString", "modelName": "replacestatus", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "ServiceLine_replacestatus", "description": "", "type": "codedValue", "codedValues": [ { "code": "Doesn't Need Replacement", "name": "Doesn't Need Replacement" }, { "code": "Both Sides Need Replaced", "name": "Both Sides Need Replaced" }, { "code": "Utility Side Needs Replaced", "name": "Utility Side Needs Replaced" }, { "code": "Customer Side Needs Replaced", "name": "Customer Side Needs Replaced" }, { "code": "Customer-Initiated Replacement Scheduled", "name": "Customer-Initiated Replacement Scheduled" }, { "code": "Customer-Initiated Replacement", "name": "Customer-Initiated Replacement" }, { "code": "Scheduled Replacement", "name": "Scheduled Replacement" }, { "code": "Replaced", "name": "Replaced" }, { "code": "Non-Responsive Customer", "name": "Non-Responsive Customer" }, { "code": "Customer Denied Replacement", "name": "Customer Denied Replacement" }, { "code": "Scheduled Partial Replacement on Utility Side", "name": "Scheduled Partial Replacement on Utility Side" }, { "code": "Partial Replacement on Utility Side", "name": "Partial Replacement on Utility Side" }, { "code": "Customer Approved - Needs Scheduled", "name": "Customer Approved - Needs Scheduled" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "replacestatus", "alias": "Full Line Replacement Status" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 256, "type": "esriFieldTypeString", "modelName": "custbasisclass", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "ServiceLine_basisclass", "description": "", "type": "codedValue", "codedValues": [ { "code": "Installation record (e.g., tap card)", "name": "Installation record (e.g., tap card)" }, { "code": "Water sampling only with no records", "name": "Water sampling only with no records" }, { "code": "Field inspection only with no records", "name": "Field inspection only with no records" }, { "code": "Predictive model", "name": "Predictive model" }, { "code": "Previous Materials Evaluation", "name": "Previous Materials Evaluation" }, { "code": "Installation date after lead ban", "name": "Installation date after lead ban" }, { "code": "Service line repair or replacement record", "name": "Service line repair or replacement record" }, { "code": "Service line diameter is > 2 inches", "name": "Service line diameter is > 2 inches" }, { "code": "Other", "name": "Other" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "custbasisclass", "alias": "Customer Basis of Material Classification" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 256, "type": "esriFieldTypeString", "modelName": "utilbasisclass", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "ServiceLine_basisclass", "description": "", "type": "codedValue", "codedValues": [ { "code": "Installation record (e.g., tap card)", "name": "Installation record (e.g., tap card)" }, { "code": "Water sampling only with no records", "name": "Water sampling only with no records" }, { "code": "Field inspection only with no records", "name": "Field inspection only with no records" }, { "code": "Predictive model", "name": "Predictive model" }, { "code": "Previous Materials Evaluation", "name": "Previous Materials Evaluation" }, { "code": "Installation date after lead ban", "name": "Installation date after lead ban" }, { "code": "Service line repair or replacement record", "name": "Service line repair or replacement record" }, { "code": "Service line diameter is > 2 inches", "name": "Service line diameter is > 2 inches" }, { "code": "Other", "name": "Other" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "utilbasisclass", "alias": "Utility Basis of Material Classification" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeInteger", "modelName": "replpriorityrank", "domain": null, "name": "replpriorityrank", "alias": "Replacement Priority Rank" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeInteger", "modelName": "schoolpriorityrank", "domain": null, "name": "schoolpriorityrank", "alias": "School Priority Rank" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeInteger", "modelName": "ccpriorityrank", "domain": null, "name": "ccpriorityrank", "alias": "Childcare Priority Rank" }, { "nullable": true, "editable": true, "defaultValue": null, "precision": 1, "length": 29, "type": "esriFieldTypeDate", "modelName": "newcustomerdate", "domain": null, "name": "newcustomerdate", "alias": "newcustomerdate" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": true, "allowGeometryUpdates": true, "isView": true, "useStandardizedQueries": true, "globalIdField": "globalid", "sourceSpatialReference": { "wkt": "PROJCS[\"WGS_1984_Web_Mercator_Auxiliary_Sphere\",GEOGCS[\"GCS_WGS_1984\",DATUM[\"D_WGS_1984\",SPHEROID[\"WGS_1984\",6378137.0,298.257223563]],PRIMEM[\"Greenwich\",0.0],UNIT[\"Degree\",0.0174532925199433]],PROJECTION[\"Mercator_Auxiliary_Sphere\"],PARAMETER[\"False_Easting\",0.0],PARAMETER[\"False_Northing\",0.0],PARAMETER[\"Central_Meridian\",0.0],PARAMETER[\"Standard_Parallel_1\",0.0],PARAMETER[\"Auxiliary_Sphere_Type\",0.0],UNIT[\"Meter\",1.0]]", "falseM": -100000, "mUnits": 10000, "zUnits": 10000, "zTolerance": 0.001, "wkid": 3857, "xyUnits": 1.4892314192838538E8, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "falseZ": -100000 }, "description": "ServiceLine", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "isUpdatableView": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "standardMaxRecordCountNoGeometry": 16000, "supportsTruncate": false, "indexes": [ { "name": "i131accountid", "isUnique": false, "description": "", "fields": "accountid", "isAscending": true }, { "name": "i131address", "isUnique": false, "description": "", "fields": "address", "isAscending": true }, { "name": "i131bothsidessta", "isUnique": false, "description": "", "fields": "bothsidesstatus", "isAscending": true }, { "name": "i131created_date", "isUnique": false, "description": "", "fields": "created_date", "isAscending": true }, { "name": "i131created_user", "isUnique": false, "description": "", "fields": "created_user", "isAscending": true }, { "name": "i131custassetid", "isUnique": false, "description": "", "fields": "custassetid", "isAscending": true }, { "name": "i131last_edited_", "isUnique": false, "description": "", "fields": "last_edited_date", "isAscending": true }, { "name": "i131last_edited__1", "isUnique": false, "description": "", "fields": "last_edited_user", "isAscending": true }, { "name": "i131replacestatu", "isUnique": false, "description": "", "fields": "replacestatus", "isAscending": true }, { "name": "i131samplingsite", "isUnique": false, "description": "", "fields": "samplingsite", "isAscending": true }, { "name": "i131state", "isUnique": false, "description": "", "fields": "state", "isAscending": true }, { "name": "i131tier", "isUnique": false, "description": "", "fields": "tier", "isAscending": true }, { "name": "i131utilassetid", "isUnique": false, "description": "", "fields": "utilassetid", "isAscending": true }, { "name": "r72_sde_rowid_uk", "isUnique": false, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_72", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true }, { "name": "a49_ix1", "isUnique": false, "description": "", "fields": "shape", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": { "editDateField": "last_edited_date", "editorField": "last_edited_user", "creationDateField": "created_date", "creatorField": "created_user" }, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "GUIDFormat": "O", "minScale": 577791, "hasAttachments": true, "queryBinsCapabilities": { "supportsFirstDayOfWeek": false, "supportedNormalizationTypes": [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ], "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsNormalization": true, "supportsSnapToData": true, "supportsFixedIntervalBin": true, "supportsStackBy": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true, "supportsSplitBy": true, "supportsReturnFullIntervalBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "fullTextSearchCapabilities": { "supportsOperator": true, "supportsSearchOperator": true }, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "fullTextSearchableFields": [], "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": true, "supportsQueryWithDistance": true, "supportsLod": true, "supportsSpatialAggregationStatistics": false, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsReturningGeometryEnvelope": false, "supportsDistinct": true, "supportsReturningGeometryCentroid": false, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "subtypeField": "", "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "10d4385e791748bcb6bf243bc5cdc894", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "sourceSchemaChangesAllowed": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "csv,excel,featureCollection,featureService,geojson,imageCollection,jsonl,pbf,shapefile", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportsVCSProjection": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.4.0", "drawingInfo": { "renderer": { "symbol": { "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 }, "color": [ 58, 63, 130, 255 ], "size": 4, "yoffset": 0, "xoffset": 0, "angle": 0, "style": "esriSMSCircle", "type": "esriSMS" }, "type": "simple" }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "geometryField": { "sqlType": "sqlTypeDistinct", "nullable": true, "editable": true, "name": "shape", "typeName": "st_point", "length": 2147483647, "type": "esriFieldTypeGeometry" }, "copyrightText": "", "zDefault": 0, "geometryType": "esriGeometryPoint", "supportsLayerOverrides": true } ] }