{ "currentVersion" : 12, "id" : 3, "name" : "FRS_INTEREST_CONTACT", "type" : "Table", "serviceItemId" : "cdff193a3e3743a5bc770e2743f215b3", "cacheMaxAge" : 3600, "displayField" : "FULL_NAME", "description" : "<p>This directory provides detailed contact information for individuals associated with various environmental programs and facilities. It consolidates data on responsible personnel, including their full names, phone numbers, and mailing addresses, linked to specific program systems and IDs.</p><p>The directory is essential for environmental agencies, facility managers, and stakeholders who require direct communication channels for compliance, reporting, and program management purposes. The information supports regulatory processes by identifying roles and responsibilities connected to environmental permits, site management, and operational units.</p><p>Key details such as program system acronyms and unique program system IDs help to correlate contacts with specific environmental programs, facilitating organized and efficient data retrieval and communication.</p>", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1779669843591, "schemaLastEditDate" : 1779669843591, "dataLastEditDate" : 1779669843591 }, "relationships" : [], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : true, "supportsAttachmentsByUploadId" : true, "supportsAttachmentsResizing" : true, "supportsRollbackOnFailureParameter" : true, "supportsStatistics" : true, "supportsExceedsLimitStatistics" : true, "supportsAdvancedQueries" : true, "supportsValidateSql" : true, "supportsCoordinatesQuantization" : true, "supportsLayerOverrides" : true, "supportsTilesAndBasicQueriesMode" : true, "supportsFieldDescriptionProperty" : true, "supportsQuantizationEditMode" : true, "supportsColumnStoreIndex" : true, "supportsApplyEditsWithGlobalIds" : false, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsReturningQueryExtent" : false, "supportsStatistics" : true, "supportsOrderBy" : true, "supportsDistinct" : true, "supportsQueryWithResultType" : true, "supportsSqlExpression" : true, "supportsTimeRelation" : true, "supportsAdvancedQueryRelated" : true, "supportsCountDistinct" : true, "supportsPercentileStatistics" : true, "supportsApproxPercentileStatistics" : true, "supportsSpatialAggregationStatistics" : true, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : false, "supportsReturningGeometryEnvelope" : true, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsQueryWithCacheHint" : true, "supportedOperationsWithCacheHint" : [ "query", "queryTopFilter", "queryAnalytics", "queryAttachments", "queryRelated", "queryBins", "queryPivot" ], "supportsQueryAnalytic" : true, "supportsQueryPivot" : true, "supportsQueryBins" : true, "supportsDefaultSR" : true, "supportsTranslations" : false, "supportsAggIds" : true, "supportsQueryWithCollation" : true, "supportsISODOW" : true, "supportsISOWeek" : true, "supportsFullTextSearch" : true, "fullTextSearchCapabilities" : { "supportsAccentSensitivity" : true, "supportsStopWords" : true, "supportsSearchOperator" : true, "supportsOperator" : true } }, "advancedQueryAnalyticCapabilities" : { "supportsLinearRegression" : true, "supportsTrendlineRegression" : true, "supportsAsync" : true, "supportsPercentileAnalytic" : true }, "queryBinsCapabilities" : { "supportsAsync" : true, "supportsAutoIntervalBin" : true, "supportsFixedIntervalBin" : true, "supportsFixedBoundariesBin" : true, "supportsDateBin" : true, "supportsClassificationBin" : true, "supportsStackBy" : true, "supportsSplitBy" : true, "supportsFirstDayOfWeek" : true, "supportsSnapToData" : true, "supportsReturnFullIntervalBin" : true, "supportsReturnStackValueRange" : true, "supportsNormalization" : true, "supportedStatisticTypes" : [ "COUNT", "SUM", "AVG", "VAR", "STDDEV", "MIN", "MAX", "PERCENTILE_CONT", "PERCENTILE_DISC", "APPROX_PERCENTILE_CONT", "APPROX_PERCENTILE_DISC", "CentroidAggregate", "EnvelopeAggregate", "ConvexHullAggregate" ], "supportedNormalizationTypes" : [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ] }, "supportedOperationsWithCollation" : "query,addField,updateField", "advancedEditingCapabilities" : { "supportedSqlFormatsInCalculate" : [ "standard" ], "supportsAsyncApplyEdits" : true, "supportsReturnEditResults" : true, "supportsApplyEditsbyUploadID" : true, "supportedApplyEditsUploadIDFormats" : "JSON,PBF", "supportsTranslation" : false, "supportsMaxTranslations" : 10 }, "infoInEstimates" : [ "count" ], "useStandardizedQueries" : true, "allowGeometryUpdates" : true, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeNone", "hasMetadata" : true, "hasM" : false, "hasZ" : false, "objectIdField" : "OBJECTID", "uniqueIdField" : { "name" : "OBJECTID", "isSystemMaintained" : true }, "globalIdField" : "", "typeIdField" : "", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "OBJECTID", "type" : "esriFieldTypeOID", "alias" : "Object ID", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"Unique identifier for each feature in the dataset.\",\"fieldValueType\":\"uniqueIdentifier\"}" }, { "name" : "PGM_SYS_ACRNM", "type" : "esriFieldTypeString", "alias" : "Program System Acronym", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : false, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The abbreviated name that represents the name of an information management system for an environmental program.\\n\",\"fieldValueType\":\"typeOrCategory\"}" }, { "name" : "PGM_SYS_ID", "type" : "esriFieldTypeString", "alias" : "Program System ID", "sqlType" : "sqlTypeOther", "length" : 30, "nullable" : false, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The identification number, such as the permit number, assigned by an information management system that represents a facility site, waste site, operable unit, or other feature tracked by that Environmental Information System\",\"fieldValueType\":\"uniqueIdentifier\"}" }, { "name" : "FULL_NAME", "type" : "esriFieldTypeString", "alias" : "Full Name", "sqlType" : "sqlTypeOther", "length" : 70, "nullable" : false, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The complete name of a person who has some responsibility or role at the facility site, potentially including first name, middle name or initial, and surname.\",\"fieldValueType\":\"nameOrTitle\"}" }, { "name" : "PHONE_NUMBER", "type" : "esriFieldTypeString", "alias" : "Phone Number", "sqlType" : "sqlTypeOther", "length" : 30, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"Phone number of the contact person or facility; may include formatted or unformatted numbers.\",\"fieldValueType\":\"phoneNumber\"}" }, { "name" : "MAILING_ADDRESS", "type" : "esriFieldTypeString", "alias" : "Mailing Address", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"Primary mailing address associated with the facility or contact person.\",\"fieldValueType\":\"locationOrPlaceName\"}" }, { "name" : "SUPPLEMENTAL_ADDRESS", "type" : "esriFieldTypeString", "alias" : "Supplemental Address", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"Additional or secondary address information to complement the primary mailing address.\",\"fieldValueType\":\"locationOrPlaceName\"}" }, { "name" : "CITY_NAME", "type" : "esriFieldTypeString", "alias" : "City Name", "sqlType" : "sqlTypeOther", "length" : 30, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"Name of the city where the facility or contact address is located.\",\"fieldValueType\":\"locationOrPlaceName\"}" }, { "name" : "STATE_CODE", "type" : "esriFieldTypeString", "alias" : "State Code", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"Two-letter state code representing the state where the facility or contact is located.\",\"fieldValueType\":\"locationOrPlaceName\"}" }, { "name" : "POSTAL_CODE", "type" : "esriFieldTypeString", "alias" : "Postal Code", "sqlType" : "sqlTypeOther", "length" : 14, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"Postal or ZIP code for the mailing address of the facility or contact point.\",\"fieldValueType\":\"locationOrPlaceName\"}" }, { "name" : "KEY_FIELD", "type" : "esriFieldTypeString", "alias" : "Key Field", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"Composite key combining program system acronym and system ID to uniquely identify records.\",\"fieldValueType\":\"uniqueIdentifier\"}" } ], "indexes" : [ { "name" : "PK__FRS_INTE__F4B70D85B945B546", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "I4KEY_FIELD", "fields" : "KEY_FIELD", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "FRS_INTEREST_CONTACT", "description" : "", "drawingTool" : "esriFeatureEditToolNone", "prototype" : { "attributes" : { "POSTAL_CODE" : null, "PGM_SYS_ACRNM" : " ", "PGM_SYS_ID" : " ", "FULL_NAME" : " ", "PHONE_NUMBER" : null, "MAILING_ADDRESS" : null, "SUPPLEMENTAL_ADDRESS" : null, "CITY_NAME" : null, "STATE_CODE" : null, "KEY_FIELD" : null } } } ], "supportedQueryFormats" : "JSON, geoJSON, PBF", "supportedAppendFormats" : "sqlite,geoPackage,shapefile,filegdb,featureCollection,geojson,csv,excel,jsonl,featureService,pbf", "supportedAppendSourceFilterFormats" : "sqlite,geoPackage,shapefile,filegdb,featureService", "supportedExportFormats" : "csv,shapefile,sqlite,geoPackage,filegdb,featureCollection,geojson,kml,excel", "supportedConvertFileFormats" : "JSON,PBF", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "guidFormat" : "", "supportsContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 2000, "standardMaxRecordCount" : 32000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Query,Extract" }