{ "layers" : [ { "currentVersion" : 12, "id" : 15, "name" : "ClosureAtoC", "type" : "Feature Layer", "serviceItemId" : "d1c641e02bff4f9da4c8fd24eb6570da", "cacheMaxAge" : 30, "displayField" : "Pharmacy_Legal_Name", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1714512927997, "schemaLastEditDate" : 1714512927997, "dataLastEditDate" : 1713293149346 }, "relationships" : [], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "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, "supportsReturningQueryGeometry" : true, "enableNullGeometry" : false, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsOutDistance" : true, "supportsReturningQueryExtent" : true, "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" : false, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsDisjointSpatialRel" : 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" : [ "extent", "count" ], "useStandardizedQueries" : true, "geometryType" : "esriGeometryPoint", "minScale" : 0, "maxScale" : 0, "extent" : { "xmin" : -17649724.376158424, "ymin" : 3538144.8046504566, "xmax" : -7997812.6497557024, "ymax" : 9570521.5489763729, "spatialReference" : { "wkid" : 102100, "latestWkid" : 3857 } }, "drawingInfo":{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[255,255,255,255],"size":3,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}, "timeInfo" : { "startTimeField" : "Close_Date", "endTimeField" : "", "trackIdField" : "", "timeExtent" : [ 1388534400000, 1709251200000 ], "timeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "timeInterval" : 10, "timeIntervalUnits" : "esriTimeUnitsUnknown", "exportOptions" : { "useTime" : true, "timeDataCumulative" : false, "TimeOffset" : 0, "timeOffsetUnits" : "esriTimeUnitsCenturies" }, "hasLiveData" : false }, "allowGeometryUpdates" : true, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeAsHTMLText", "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" : "ObjectID", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "OID", "type" : "esriFieldTypeDouble", "alias" : "OID", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "SN", "type" : "esriFieldTypeDouble", "alias" : "SN", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Pharmacy_NCPDP_No", "type" : "esriFieldTypeString", "alias" : "Pharmacy NCPDP No", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Store_Number", "type" : "esriFieldTypeString", "alias" : "Store Number", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Pharmacy_Legal_Name", "type" : "esriFieldTypeString", "alias" : "Pharmacy Legal Name", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Pharmacy_DBA_Name", "type" : "esriFieldTypeString", "alias" : "Pharmacy DBA Name", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Doctor_Name", "type" : "esriFieldTypeString", "alias" : "Doctor Name", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "NPI_Number", "type" : "esriFieldTypeString", "alias" : "NPI Number", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DEA_Number", "type" : "esriFieldTypeString", "alias" : "DEA Number", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Federal_License_Exp__Date", "type" : "esriFieldTypeString", "alias" : "Federal License Exp# Date", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "State_License_No", "type" : "esriFieldTypeString", "alias" : "State License No", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "State_License__Exp__Date", "type" : "esriFieldTypeString", "alias" : "State License Exp# Date", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "License_State", "type" : "esriFieldTypeString", "alias" : "License State", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Dispenser_Class_Code", "type" : "esriFieldTypeString", "alias" : "Dispenser Class_Code", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Dispenser_Type_Code", "type" : "esriFieldTypeString", "alias" : "Dispenser Type Code", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Address1___Physical", "type" : "esriFieldTypeString", "alias" : "Address1 - Physical", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Address2___Physical_", "type" : "esriFieldTypeString", "alias" : "Address2 - Physical_", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "City_Physical", "type" : "esriFieldTypeString", "alias" : "City Physical", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "State_Physical", "type" : "esriFieldTypeString", "alias" : "State Physical", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Zip_Code__as_reported", "type" : "esriFieldTypeString", "alias" : "Zip Code _as reported", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Main_Phone", "type" : "esriFieldTypeString", "alias" : "Main Phone", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Phone_Ext", "type" : "esriFieldTypeString", "alias" : "Phone Ext", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "County_Code", "type" : "esriFieldTypeString", "alias" : "County Code", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "MSA_Code", "type" : "esriFieldTypeString", "alias" : "MSA Code", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PMSA_Code", "type" : "esriFieldTypeString", "alias" : "PMSA Code", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Congressional_District", "type" : "esriFieldTypeString", "alias" : "Congressional District", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Pharmacy_Relationship_Id__name_", "type" : "esriFieldTypeString", "alias" : "Pharmacy Relationship Id (name)", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Group_Key", "type" : "esriFieldTypeString", "alias" : "Group Key", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Group__Start_Date", "type" : "esriFieldTypeString", "alias" : "Group Start Date", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Group_Deleted_Date", "type" : "esriFieldTypeString", "alias" : "Group Deleted Date", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relation_Type", "type" : "esriFieldTypeString", "alias" : "Relation Type", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relation_Type_Code", "type" : "esriFieldTypeString", "alias" : "Relation Type Code", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relation_Address1", "type" : "esriFieldTypeString", "alias" : "Relation Address1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relation_Address2", "type" : "esriFieldTypeString", "alias" : "Relation Address2", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relation_City_", "type" : "esriFieldTypeString", "alias" : "Relation City_", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relation_State", "type" : "esriFieldTypeString", "alias" : "Relation State", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relation_Zip", "type" : "esriFieldTypeString", "alias" : "Relation Zip", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relation_Phone", "type" : "esriFieldTypeString", "alias" : "Relation Phone", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relation_Phone_Ext", "type" : "esriFieldTypeString", "alias" : "Relation Phone Ext", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relation_Fax", "type" : "esriFieldTypeString", "alias" : "Relation Fax", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relationship_Start_Date", "type" : "esriFieldTypeString", "alias" : "Relationship Start Date", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relationship_End_Date", "type" : "esriFieldTypeString", "alias" : "Relationship End Date", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Is_Primary__Y_N", "type" : "esriFieldTypeString", "alias" : "Is Primary?=Y/N", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AO_First_Name", "type" : "esriFieldTypeString", "alias" : "AO First Name", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AO_Middle_Name", "type" : "esriFieldTypeString", "alias" : "AO Middle Name", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AO_Last_Name", "type" : "esriFieldTypeString", "alias" : "AO Last Name", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AO_Contact_Title", "type" : "esriFieldTypeString", "alias" : "AO Contact Title", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AO_Contact_Email", "type" : "esriFieldTypeString", "alias" : "AO Contact Email", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AO_Contact_Phone", "type" : "esriFieldTypeString", "alias" : "AO Contact Phone", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AO_Contact_Phone_Ext", "type" : "esriFieldTypeString", "alias" : "AO Contact Phone Ext", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AO_Contact_Fax", "type" : "esriFieldTypeString", "alias" : "AO Contact Fax", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Store_Open_Date", "type" : "esriFieldTypeString", "alias" : "Store Open Date", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Store_Close_Date", "type" : "esriFieldTypeString", "alias" : "Store Close Date", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Sunday_24_Hours", "type" : "esriFieldTypeString", "alias" : "Sunday 24 Hours", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Monday_24__Hours", "type" : "esriFieldTypeString", "alias" : "Monday 24 _Hours", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Tuesday_24__Hours", "type" : "esriFieldTypeString", "alias" : "Tuesday 24 _Hours", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Wednesday_24__Hours", "type" : "esriFieldTypeString", "alias" : "Wednesday 24 _Hours", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Thursday_24__Hours", "type" : "esriFieldTypeString", "alias" : "Thursday 24 _Hours", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Friday_24_Hours", "type" : "esriFieldTypeString", "alias" : "Friday 24 Hours", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Saturday_24__Hours", "type" : "esriFieldTypeString", "alias" : "Saturday 24 _Hours", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Lat", "type" : "esriFieldTypeDouble", "alias" : "Lat", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Lon", "type" : "esriFieldTypeDouble", "alias" : "Lon", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Close_Date", "type" : "esriFieldTypeDate", "alias" : "Close_Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 } ], "indexes" : [ { "name" : "PK__CLOSURE___F4B70D85BC01416D", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "user_16849.CLOSURE_MAP_WFL1_CLOSUREATOC_Shape_sidx", "fields" : "Shape", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Spatial" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "ClosureAtoC", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "Lon" : null, "Close_Date" : null, "OID" : null, "SN" : null, "Pharmacy_NCPDP_No" : null, "Store_Number" : null, "Pharmacy_Legal_Name" : null, "Pharmacy_DBA_Name" : null, "Doctor_Name" : null, "NPI_Number" : null, "DEA_Number" : null, "Federal_License_Exp__Date" : null, "State_License_No" : null, "State_License__Exp__Date" : null, "License_State" : null, "Dispenser_Class_Code" : null, "Dispenser_Type_Code" : null, "Address1___Physical" : null, "Address2___Physical_" : null, "City_Physical" : null, "State_Physical" : null, "Zip_Code__as_reported" : null, "Main_Phone" : null, "Phone_Ext" : null, "County_Code" : null, "MSA_Code" : null, "PMSA_Code" : null, "Congressional_District" : null, "Pharmacy_Relationship_Id__name_" : null, "Group_Key" : null, "Group__Start_Date" : null, "Group_Deleted_Date" : null, "Relation_Type" : null, "Relation_Type_Code" : null, "Relation_Address1" : null, "Relation_Address2" : null, "Relation_City_" : null, "Relation_State" : null, "Relation_Zip" : null, "Relation_Phone" : null, "Relation_Phone_Ext" : null, "Relation_Fax" : null, "Relationship_Start_Date" : null, "Relationship_End_Date" : null, "Is_Primary__Y_N" : null, "AO_First_Name" : null, "AO_Middle_Name" : null, "AO_Last_Name" : null, "AO_Contact_Title" : null, "AO_Contact_Email" : null, "AO_Contact_Phone" : null, "AO_Contact_Phone_Ext" : null, "AO_Contact_Fax" : null, "Store_Open_Date" : null, "Store_Close_Date" : null, "Sunday_24_Hours" : null, "Monday_24__Hours" : null, "Tuesday_24__Hours" : null, "Wednesday_24__Hours" : null, "Thursday_24__Hours" : null, "Friday_24_Hours" : null, "Saturday_24__Hours" : null, "Lat" : 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", "supportedSpatialRelationships" : [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelDisjoint", "esriSpatialRelRelation" ], "guidFormat" : "", "supportsContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : true, "maxRecordCount" : 2000, "standardMaxRecordCount" : 16000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Query" }, { "currentVersion" : 12, "id" : 16, "name" : "ClosureDtoL", "type" : "Feature Layer", "serviceItemId" : "d1c641e02bff4f9da4c8fd24eb6570da", "cacheMaxAge" : 30, "displayField" : "Pharmacy_Legal_Name", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1714512927997, "schemaLastEditDate" : 1714512927997, "dataLastEditDate" : 1713293154221 }, "relationships" : [], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "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, "supportsReturningQueryGeometry" : true, "enableNullGeometry" : false, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsOutDistance" : true, "supportsReturningQueryExtent" : true, "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" : false, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsDisjointSpatialRel" : 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" : [ "extent", "count" ], "useStandardizedQueries" : true, "geometryType" : "esriGeometryPoint", "minScale" : 0, "maxScale" : 0, "extent" : { "xmin" : -17773966.370448206, "ymin" : 2212014.3509629061, "xmax" : -8355400.4575985195, "ymax" : 6220938.4504895983, "spatialReference" : { "wkid" : 102100, "latestWkid" : 3857 } }, "drawingInfo":{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[255,255,255,255],"size":3,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}, "timeInfo" : { "startTimeField" : "Close_Date", "endTimeField" : "", "trackIdField" : "", "timeExtent" : [ 1388534400000, 1709251200000 ], "timeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "timeInterval" : 10, "timeIntervalUnits" : "esriTimeUnitsUnknown", "exportOptions" : { "useTime" : true, "timeDataCumulative" : false, "TimeOffset" : 0, "timeOffsetUnits" : "esriTimeUnitsCenturies" }, "hasLiveData" : false }, "allowGeometryUpdates" : true, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeAsHTMLText", "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" : "ObjectID", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "OID", "type" : "esriFieldTypeDouble", "alias" : "OID", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "SN", "type" : "esriFieldTypeDouble", "alias" : "SN", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Pharmacy_NCPDP_No", "type" : "esriFieldTypeString", "alias" : "Pharmacy NCPDP No", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Store_Number", "type" : "esriFieldTypeString", "alias" : "Store Number", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Pharmacy_Legal_Name", "type" : "esriFieldTypeString", "alias" : "Pharmacy Legal Name", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Pharmacy_DBA_Name", "type" : "esriFieldTypeString", "alias" : "Pharmacy DBA Name", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Doctor_Name", "type" : "esriFieldTypeString", "alias" : "Doctor Name", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "NPI_Number", "type" : "esriFieldTypeString", "alias" : "NPI Number", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DEA_Number", "type" : "esriFieldTypeString", "alias" : "DEA Number", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Federal_License_Exp__Date", "type" : "esriFieldTypeString", "alias" : "Federal License Exp# Date", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "State_License_No", "type" : "esriFieldTypeString", "alias" : "State License No", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "State_License__Exp__Date", "type" : "esriFieldTypeString", "alias" : "State License Exp# Date", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "License_State", "type" : "esriFieldTypeString", "alias" : "License State", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Dispenser_Class_Code", "type" : "esriFieldTypeString", "alias" : "Dispenser Class_Code", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Dispenser_Type_Code", "type" : "esriFieldTypeString", "alias" : "Dispenser Type Code", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Address1___Physical", "type" : "esriFieldTypeString", "alias" : "Address1 - Physical", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Address2___Physical_", "type" : "esriFieldTypeString", "alias" : "Address2 - Physical_", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "City_Physical", "type" : "esriFieldTypeString", "alias" : "City Physical", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "State_Physical", "type" : "esriFieldTypeString", "alias" : "State Physical", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Zip_Code__as_reported", "type" : "esriFieldTypeString", "alias" : "Zip Code _as reported", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Main_Phone", "type" : "esriFieldTypeString", "alias" : "Main Phone", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Phone_Ext", "type" : "esriFieldTypeString", "alias" : "Phone Ext", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "County_Code", "type" : "esriFieldTypeString", "alias" : "County Code", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "MSA_Code", "type" : "esriFieldTypeString", "alias" : "MSA Code", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PMSA_Code", "type" : "esriFieldTypeString", "alias" : "PMSA Code", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Congressional_District", "type" : "esriFieldTypeString", "alias" : "Congressional District", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Pharmacy_Relationship_Id__name_", "type" : "esriFieldTypeString", "alias" : "Pharmacy Relationship Id (name)", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Group_Key", "type" : "esriFieldTypeString", "alias" : "Group Key", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Group__Start_Date", "type" : "esriFieldTypeString", "alias" : "Group Start Date", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Group_Deleted_Date", "type" : "esriFieldTypeString", "alias" : "Group Deleted Date", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relation_Type", "type" : "esriFieldTypeString", "alias" : "Relation Type", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relation_Type_Code", "type" : "esriFieldTypeString", "alias" : "Relation Type Code", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relation_Address1", "type" : "esriFieldTypeString", "alias" : "Relation Address1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relation_Address2", "type" : "esriFieldTypeString", "alias" : "Relation Address2", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relation_City_", "type" : "esriFieldTypeString", "alias" : "Relation City_", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relation_State", "type" : "esriFieldTypeString", "alias" : "Relation State", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relation_Zip", "type" : "esriFieldTypeString", "alias" : "Relation Zip", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relation_Phone", "type" : "esriFieldTypeString", "alias" : "Relation Phone", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relation_Phone_Ext", "type" : "esriFieldTypeString", "alias" : "Relation Phone Ext", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relation_Fax", "type" : "esriFieldTypeString", "alias" : "Relation Fax", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relationship_Start_Date", "type" : "esriFieldTypeString", "alias" : "Relationship Start Date", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relationship_End_Date", "type" : "esriFieldTypeString", "alias" : "Relationship End Date", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Is_Primary__Y_N", "type" : "esriFieldTypeString", "alias" : "Is Primary?=Y/N", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AO_First_Name", "type" : "esriFieldTypeString", "alias" : "AO First Name", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AO_Middle_Name", "type" : "esriFieldTypeString", "alias" : "AO Middle Name", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AO_Last_Name", "type" : "esriFieldTypeString", "alias" : "AO Last Name", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AO_Contact_Title", "type" : "esriFieldTypeString", "alias" : "AO Contact Title", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AO_Contact_Email", "type" : "esriFieldTypeString", "alias" : "AO Contact Email", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AO_Contact_Phone", "type" : "esriFieldTypeString", "alias" : "AO Contact Phone", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AO_Contact_Phone_Ext", "type" : "esriFieldTypeString", "alias" : "AO Contact Phone Ext", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AO_Contact_Fax", "type" : "esriFieldTypeString", "alias" : "AO Contact Fax", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Store_Open_Date", "type" : "esriFieldTypeString", "alias" : "Store Open Date", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Store_Close_Date", "type" : "esriFieldTypeString", "alias" : "Store Close Date", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Sunday_24_Hours", "type" : "esriFieldTypeString", "alias" : "Sunday 24 Hours", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Monday_24__Hours", "type" : "esriFieldTypeString", "alias" : "Monday 24 _Hours", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Tuesday_24__Hours", "type" : "esriFieldTypeString", "alias" : "Tuesday 24 _Hours", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Wednesday_24__Hours", "type" : "esriFieldTypeString", "alias" : "Wednesday 24 _Hours", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Thursday_24__Hours", "type" : "esriFieldTypeString", "alias" : "Thursday 24 _Hours", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Friday_24_Hours", "type" : "esriFieldTypeString", "alias" : "Friday 24 Hours", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Saturday_24__Hours", "type" : "esriFieldTypeString", "alias" : "Saturday 24 _Hours", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Lat", "type" : "esriFieldTypeDouble", "alias" : "Lat", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Lon", "type" : "esriFieldTypeDouble", "alias" : "Lon", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Close_Date", "type" : "esriFieldTypeDate", "alias" : "Close_Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 } ], "indexes" : [ { "name" : "PK__CLOSURE___F4B70D855F054E16", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "user_16849.CLOSURE_MAP_WFL1_CLOSUREDTOL_Shape_sidx", "fields" : "Shape", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Spatial" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "ClosureDtoL", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "Lon" : null, "Close_Date" : null, "OID" : null, "SN" : null, "Pharmacy_NCPDP_No" : null, "Store_Number" : null, "Pharmacy_Legal_Name" : null, "Pharmacy_DBA_Name" : null, "Doctor_Name" : null, "NPI_Number" : null, "DEA_Number" : null, "Federal_License_Exp__Date" : null, "State_License_No" : null, "State_License__Exp__Date" : null, "License_State" : null, "Dispenser_Class_Code" : null, "Dispenser_Type_Code" : null, "Address1___Physical" : null, "Address2___Physical_" : null, "City_Physical" : null, "State_Physical" : null, "Zip_Code__as_reported" : null, "Main_Phone" : null, "Phone_Ext" : null, "County_Code" : null, "MSA_Code" : null, "PMSA_Code" : null, "Congressional_District" : null, "Pharmacy_Relationship_Id__name_" : null, "Group_Key" : null, "Group__Start_Date" : null, "Group_Deleted_Date" : null, "Relation_Type" : null, "Relation_Type_Code" : null, "Relation_Address1" : null, "Relation_Address2" : null, "Relation_City_" : null, "Relation_State" : null, "Relation_Zip" : null, "Relation_Phone" : null, "Relation_Phone_Ext" : null, "Relation_Fax" : null, "Relationship_Start_Date" : null, "Relationship_End_Date" : null, "Is_Primary__Y_N" : null, "AO_First_Name" : null, "AO_Middle_Name" : null, "AO_Last_Name" : null, "AO_Contact_Title" : null, "AO_Contact_Email" : null, "AO_Contact_Phone" : null, "AO_Contact_Phone_Ext" : null, "AO_Contact_Fax" : null, "Store_Open_Date" : null, "Store_Close_Date" : null, "Sunday_24_Hours" : null, "Monday_24__Hours" : null, "Tuesday_24__Hours" : null, "Wednesday_24__Hours" : null, "Thursday_24__Hours" : null, "Friday_24_Hours" : null, "Saturday_24__Hours" : null, "Lat" : 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", "supportedSpatialRelationships" : [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelDisjoint", "esriSpatialRelRelation" ], "guidFormat" : "", "supportsContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : true, "maxRecordCount" : 2000, "standardMaxRecordCount" : 16000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Query" }, { "currentVersion" : 12, "id" : 2, "name" : "ClosureM", "type" : "Feature Layer", "serviceItemId" : "d1c641e02bff4f9da4c8fd24eb6570da", "cacheMaxAge" : 30, "displayField" : "Pharmacy_Legal_Name", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1714512927997, "schemaLastEditDate" : 1714512927997, "dataLastEditDate" : 1713293156939 }, "relationships" : [], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "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, "supportsReturningQueryGeometry" : true, "enableNullGeometry" : false, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsOutDistance" : true, "supportsReturningQueryExtent" : true, "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" : false, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsDisjointSpatialRel" : 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" : [ "extent", "count" ], "useStandardizedQueries" : true, "geometryType" : "esriGeometryPoint", "minScale" : 0, "maxScale" : 0, "extent" : { "xmin" : -12863342.726853294, "ymin" : 3542210.6142241186, "xmax" : -7489525.180788123, "ymax" : 6249118.3804656807, "spatialReference" : { "wkid" : 102100, "latestWkid" : 3857 } }, "drawingInfo":{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[255,255,255,255],"size":3,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}, "timeInfo" : { "startTimeField" : "Close_Date", "endTimeField" : "", "trackIdField" : "", "timeExtent" : [ 1388534400000, 1709251200000 ], "timeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "timeInterval" : 10, "timeIntervalUnits" : "esriTimeUnitsUnknown", "exportOptions" : { "useTime" : true, "timeDataCumulative" : false, "TimeOffset" : 0, "timeOffsetUnits" : "esriTimeUnitsCenturies" }, "hasLiveData" : false }, "allowGeometryUpdates" : true, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeAsHTMLText", "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" : "ObjectID", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "OID", "type" : "esriFieldTypeDouble", "alias" : "OID", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "SN", "type" : "esriFieldTypeDouble", "alias" : "SN", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Pharmacy_NCPDP_No", "type" : "esriFieldTypeString", "alias" : "Pharmacy NCPDP No", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Store_Number", "type" : "esriFieldTypeString", "alias" : "Store Number", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Pharmacy_Legal_Name", "type" : "esriFieldTypeString", "alias" : "Pharmacy Legal Name", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Pharmacy_DBA_Name", "type" : "esriFieldTypeString", "alias" : "Pharmacy DBA Name", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Doctor_Name", "type" : "esriFieldTypeString", "alias" : "Doctor Name", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "NPI_Number", "type" : "esriFieldTypeString", "alias" : "NPI Number", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DEA_Number", "type" : "esriFieldTypeString", "alias" : "DEA Number", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Federal_License_Exp__Date", "type" : "esriFieldTypeString", "alias" : "Federal License Exp# Date", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "State_License_No", "type" : "esriFieldTypeString", "alias" : "State License No", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "State_License__Exp__Date", "type" : "esriFieldTypeString", "alias" : "State License Exp# Date", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "License_State", "type" : "esriFieldTypeString", "alias" : "License State", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Dispenser_Class_Code", "type" : "esriFieldTypeString", "alias" : "Dispenser Class_Code", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Dispenser_Type_Code", "type" : "esriFieldTypeString", "alias" : "Dispenser Type Code", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Address1___Physical", "type" : "esriFieldTypeString", "alias" : "Address1 - Physical", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Address2___Physical_", "type" : "esriFieldTypeString", "alias" : "Address2 - Physical_", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "City_Physical", "type" : "esriFieldTypeString", "alias" : "City Physical", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "State_Physical", "type" : "esriFieldTypeString", "alias" : "State Physical", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Zip_Code__as_reported", "type" : "esriFieldTypeString", "alias" : "Zip Code _as reported", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Main_Phone", "type" : "esriFieldTypeString", "alias" : "Main Phone", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Phone_Ext", "type" : "esriFieldTypeString", "alias" : "Phone Ext", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "County_Code", "type" : "esriFieldTypeString", "alias" : "County Code", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "MSA_Code", "type" : "esriFieldTypeString", "alias" : "MSA Code", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PMSA_Code", "type" : "esriFieldTypeString", "alias" : "PMSA Code", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Congressional_District", "type" : "esriFieldTypeString", "alias" : "Congressional District", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Pharmacy_Relationship_Id__name_", "type" : "esriFieldTypeString", "alias" : "Pharmacy Relationship Id (name)", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Group_Key", "type" : "esriFieldTypeString", "alias" : "Group Key", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Group__Start_Date", "type" : "esriFieldTypeString", "alias" : "Group Start Date", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Group_Deleted_Date", "type" : "esriFieldTypeString", "alias" : "Group Deleted Date", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relation_Type", "type" : "esriFieldTypeString", "alias" : "Relation Type", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relation_Type_Code", "type" : "esriFieldTypeString", "alias" : "Relation Type Code", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relation_Address1", "type" : "esriFieldTypeString", "alias" : "Relation Address1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relation_Address2", "type" : "esriFieldTypeString", "alias" : "Relation Address2", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relation_City_", "type" : "esriFieldTypeString", "alias" : "Relation City_", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relation_State", "type" : "esriFieldTypeString", "alias" : "Relation State", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relation_Zip", "type" : "esriFieldTypeString", "alias" : "Relation Zip", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relation_Phone", "type" : "esriFieldTypeString", "alias" : "Relation Phone", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relation_Phone_Ext", "type" : "esriFieldTypeString", "alias" : "Relation Phone Ext", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relation_Fax", "type" : "esriFieldTypeString", "alias" : "Relation Fax", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relationship_Start_Date", "type" : "esriFieldTypeString", "alias" : "Relationship Start Date", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relationship_End_Date", "type" : "esriFieldTypeString", "alias" : "Relationship End Date", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Is_Primary__Y_N", "type" : "esriFieldTypeString", "alias" : "Is Primary?=Y/N", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AO_First_Name", "type" : "esriFieldTypeString", "alias" : "AO First Name", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AO_Middle_Name", "type" : "esriFieldTypeString", "alias" : "AO Middle Name", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AO_Last_Name", "type" : "esriFieldTypeString", "alias" : "AO Last Name", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AO_Contact_Title", "type" : "esriFieldTypeString", "alias" : "AO Contact Title", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AO_Contact_Email", "type" : "esriFieldTypeString", "alias" : "AO Contact Email", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AO_Contact_Phone", "type" : "esriFieldTypeString", "alias" : "AO Contact Phone", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AO_Contact_Phone_Ext", "type" : "esriFieldTypeString", "alias" : "AO Contact Phone Ext", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AO_Contact_Fax", "type" : "esriFieldTypeString", "alias" : "AO Contact Fax", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Store_Open_Date", "type" : "esriFieldTypeString", "alias" : "Store Open Date", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Store_Close_Date", "type" : "esriFieldTypeString", "alias" : "Store Close Date", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Sunday_24_Hours", "type" : "esriFieldTypeString", "alias" : "Sunday 24 Hours", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Monday_24__Hours", "type" : "esriFieldTypeString", "alias" : "Monday 24 _Hours", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Tuesday_24__Hours", "type" : "esriFieldTypeString", "alias" : "Tuesday 24 _Hours", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Wednesday_24__Hours", "type" : "esriFieldTypeString", "alias" : "Wednesday 24 _Hours", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Thursday_24__Hours", "type" : "esriFieldTypeString", "alias" : "Thursday 24 _Hours", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Friday_24_Hours", "type" : "esriFieldTypeString", "alias" : "Friday 24 Hours", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Saturday_24__Hours", "type" : "esriFieldTypeString", "alias" : "Saturday 24 _Hours", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Lat", "type" : "esriFieldTypeDouble", "alias" : "Lat", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Lon", "type" : "esriFieldTypeDouble", "alias" : "Lon", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Close_Date", "type" : "esriFieldTypeDate", "alias" : "Close_Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 } ], "indexes" : [ { "name" : "PK__CLOSURE___F4B70D85A43AE0B2", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "user_16849.CLOSURE_MAP_WFL1_CLOSUREM_Shape_sidx", "fields" : "Shape", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Spatial" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "ClosureM", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "Lon" : null, "Close_Date" : null, "OID" : null, "SN" : null, "Pharmacy_NCPDP_No" : null, "Store_Number" : null, "Pharmacy_Legal_Name" : null, "Pharmacy_DBA_Name" : null, "Doctor_Name" : null, "NPI_Number" : null, "DEA_Number" : null, "Federal_License_Exp__Date" : null, "State_License_No" : null, "State_License__Exp__Date" : null, "License_State" : null, "Dispenser_Class_Code" : null, "Dispenser_Type_Code" : null, "Address1___Physical" : null, "Address2___Physical_" : null, "City_Physical" : null, "State_Physical" : null, "Zip_Code__as_reported" : null, "Main_Phone" : null, "Phone_Ext" : null, "County_Code" : null, "MSA_Code" : null, "PMSA_Code" : null, "Congressional_District" : null, "Pharmacy_Relationship_Id__name_" : null, "Group_Key" : null, "Group__Start_Date" : null, "Group_Deleted_Date" : null, "Relation_Type" : null, "Relation_Type_Code" : null, "Relation_Address1" : null, "Relation_Address2" : null, "Relation_City_" : null, "Relation_State" : null, "Relation_Zip" : null, "Relation_Phone" : null, "Relation_Phone_Ext" : null, "Relation_Fax" : null, "Relationship_Start_Date" : null, "Relationship_End_Date" : null, "Is_Primary__Y_N" : null, "AO_First_Name" : null, "AO_Middle_Name" : null, "AO_Last_Name" : null, "AO_Contact_Title" : null, "AO_Contact_Email" : null, "AO_Contact_Phone" : null, "AO_Contact_Phone_Ext" : null, "AO_Contact_Fax" : null, "Store_Open_Date" : null, "Store_Close_Date" : null, "Sunday_24_Hours" : null, "Monday_24__Hours" : null, "Tuesday_24__Hours" : null, "Wednesday_24__Hours" : null, "Thursday_24__Hours" : null, "Friday_24_Hours" : null, "Saturday_24__Hours" : null, "Lat" : 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", "supportedSpatialRelationships" : [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelDisjoint", "esriSpatialRelRelation" ], "guidFormat" : "", "supportsContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : true, "maxRecordCount" : 2000, "standardMaxRecordCount" : 16000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Query" }, { "currentVersion" : 12, "id" : 3, "name" : "Closure States N", "type" : "Feature Layer", "serviceItemId" : "d1c641e02bff4f9da4c8fd24eb6570da", "cacheMaxAge" : 30, "displayField" : "Pharmacy_Legal_Name", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1714512927997, "schemaLastEditDate" : 1714512927997, "dataLastEditDate" : 1713293160830 }, "relationships" : [], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "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, "supportsReturningQueryGeometry" : true, "enableNullGeometry" : false, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsOutDistance" : true, "supportsReturningQueryExtent" : true, "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" : false, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsDisjointSpatialRel" : 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" : [ "extent", "count" ], "useStandardizedQueries" : true, "geometryType" : "esriGeometryPoint", "minScale" : 0, "maxScale" : 0, "extent" : { "xmin" : -13353179.121801523, "ymin" : 3441370.2328530126, "xmax" : -7876395.2201202884, "ymax" : 6260101.03145334, "spatialReference" : { "wkid" : 102100, "latestWkid" : 3857 } }, "drawingInfo":{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[255,255,255,255],"size":3,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}, "timeInfo" : { "startTimeField" : "Close_Date", "endTimeField" : "", "trackIdField" : "", "timeExtent" : [ 1388534400000, 1709251200000 ], "timeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "timeInterval" : 10, "timeIntervalUnits" : "esriTimeUnitsUnknown", "exportOptions" : { "useTime" : true, "timeDataCumulative" : false, "TimeOffset" : 0, "timeOffsetUnits" : "esriTimeUnitsCenturies" }, "hasLiveData" : false }, "allowGeometryUpdates" : true, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeAsHTMLText", "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" : "ObjectID", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "OID", "type" : "esriFieldTypeDouble", "alias" : "OID", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "SN", "type" : "esriFieldTypeDouble", "alias" : "SN", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Pharmacy_NCPDP_No", "type" : "esriFieldTypeString", "alias" : "Pharmacy NCPDP No", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Store_Number", "type" : "esriFieldTypeString", "alias" : "Store Number", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Pharmacy_Legal_Name", "type" : "esriFieldTypeString", "alias" : "Pharmacy Legal Name", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Pharmacy_DBA_Name", "type" : "esriFieldTypeString", "alias" : "Pharmacy DBA Name", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Doctor_Name", "type" : "esriFieldTypeString", "alias" : "Doctor Name", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "NPI_Number", "type" : "esriFieldTypeString", "alias" : "NPI Number", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DEA_Number", "type" : "esriFieldTypeString", "alias" : "DEA Number", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Federal_License_Exp__Date", "type" : "esriFieldTypeString", "alias" : "Federal License Exp# Date", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "State_License_No", "type" : "esriFieldTypeString", "alias" : "State License No", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "State_License__Exp__Date", "type" : "esriFieldTypeString", "alias" : "State License Exp# Date", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "License_State", "type" : "esriFieldTypeString", "alias" : "License State", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Dispenser_Class_Code", "type" : "esriFieldTypeString", "alias" : "Dispenser Class_Code", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Dispenser_Type_Code", "type" : "esriFieldTypeString", "alias" : "Dispenser Type Code", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Address1___Physical", "type" : "esriFieldTypeString", "alias" : "Address1 - Physical", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Address2___Physical_", "type" : "esriFieldTypeString", "alias" : "Address2 - Physical_", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "City_Physical", "type" : "esriFieldTypeString", "alias" : "City Physical", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "State_Physical", "type" : "esriFieldTypeString", "alias" : "State Physical", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Zip_Code__as_reported", "type" : "esriFieldTypeString", "alias" : "Zip Code _as reported", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Main_Phone", "type" : "esriFieldTypeString", "alias" : "Main Phone", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Phone_Ext", "type" : "esriFieldTypeString", "alias" : "Phone Ext", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "County_Code", "type" : "esriFieldTypeString", "alias" : "County Code", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "MSA_Code", "type" : "esriFieldTypeString", "alias" : "MSA Code", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PMSA_Code", "type" : "esriFieldTypeString", "alias" : "PMSA Code", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Congressional_District", "type" : "esriFieldTypeString", "alias" : "Congressional District", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Pharmacy_Relationship_Id__name_", "type" : "esriFieldTypeString", "alias" : "Pharmacy Relationship Id (name)", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Group_Key", "type" : "esriFieldTypeString", "alias" : "Group Key", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Group__Start_Date", "type" : "esriFieldTypeString", "alias" : "Group Start Date", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Group_Deleted_Date", "type" : "esriFieldTypeString", "alias" : "Group Deleted Date", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relation_Type", "type" : "esriFieldTypeString", "alias" : "Relation Type", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relation_Type_Code", "type" : "esriFieldTypeString", "alias" : "Relation Type Code", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relation_Address1", "type" : "esriFieldTypeString", "alias" : "Relation Address1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relation_Address2", "type" : "esriFieldTypeString", "alias" : "Relation Address2", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relation_City_", "type" : "esriFieldTypeString", "alias" : "Relation City_", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relation_State", "type" : "esriFieldTypeString", "alias" : "Relation State", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relation_Zip", "type" : "esriFieldTypeString", "alias" : "Relation Zip", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relation_Phone", "type" : "esriFieldTypeString", "alias" : "Relation Phone", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relation_Phone_Ext", "type" : "esriFieldTypeString", "alias" : "Relation Phone Ext", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relation_Fax", "type" : "esriFieldTypeString", "alias" : "Relation Fax", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relationship_Start_Date", "type" : "esriFieldTypeString", "alias" : "Relationship Start Date", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relationship_End_Date", "type" : "esriFieldTypeString", "alias" : "Relationship End Date", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Is_Primary__Y_N", "type" : "esriFieldTypeString", "alias" : "Is Primary?=Y/N", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AO_First_Name", "type" : "esriFieldTypeString", "alias" : "AO First Name", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AO_Middle_Name", "type" : "esriFieldTypeString", "alias" : "AO Middle Name", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AO_Last_Name", "type" : "esriFieldTypeString", "alias" : "AO Last Name", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AO_Contact_Title", "type" : "esriFieldTypeString", "alias" : "AO Contact Title", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AO_Contact_Email", "type" : "esriFieldTypeString", "alias" : "AO Contact Email", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AO_Contact_Phone", "type" : "esriFieldTypeString", "alias" : "AO Contact Phone", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AO_Contact_Phone_Ext", "type" : "esriFieldTypeString", "alias" : "AO Contact Phone Ext", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AO_Contact_Fax", "type" : "esriFieldTypeString", "alias" : "AO Contact Fax", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Store_Open_Date", "type" : "esriFieldTypeString", "alias" : "Store Open Date", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Store_Close_Date", "type" : "esriFieldTypeString", "alias" : "Store Close Date", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Sunday_24_Hours", "type" : "esriFieldTypeString", "alias" : "Sunday 24 Hours", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Monday_24__Hours", "type" : "esriFieldTypeString", "alias" : "Monday 24 _Hours", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Tuesday_24__Hours", "type" : "esriFieldTypeString", "alias" : "Tuesday 24 _Hours", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Wednesday_24__Hours", "type" : "esriFieldTypeString", "alias" : "Wednesday 24 _Hours", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Thursday_24__Hours", "type" : "esriFieldTypeString", "alias" : "Thursday 24 _Hours", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Friday_24_Hours", "type" : "esriFieldTypeString", "alias" : "Friday 24 Hours", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Saturday_24__Hours", "type" : "esriFieldTypeString", "alias" : "Saturday 24 _Hours", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Lat", "type" : "esriFieldTypeDouble", "alias" : "Lat", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Lon", "type" : "esriFieldTypeDouble", "alias" : "Lon", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Close_Date", "type" : "esriFieldTypeDate", "alias" : "Close_Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 } ], "indexes" : [ { "name" : "PK__CLOSURE___F4B70D858B3FC24E", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "user_16849.CLOSURE_MAP_WFL1_CLOSURE_STATES_N_Shape_sidx", "fields" : "Shape", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Spatial" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "Closure States N", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "Lon" : null, "Close_Date" : null, "OID" : null, "SN" : null, "Pharmacy_NCPDP_No" : null, "Store_Number" : null, "Pharmacy_Legal_Name" : null, "Pharmacy_DBA_Name" : null, "Doctor_Name" : null, "NPI_Number" : null, "DEA_Number" : null, "Federal_License_Exp__Date" : null, "State_License_No" : null, "State_License__Exp__Date" : null, "License_State" : null, "Dispenser_Class_Code" : null, "Dispenser_Type_Code" : null, "Address1___Physical" : null, "Address2___Physical_" : null, "City_Physical" : null, "State_Physical" : null, "Zip_Code__as_reported" : null, "Main_Phone" : null, "Phone_Ext" : null, "County_Code" : null, "MSA_Code" : null, "PMSA_Code" : null, "Congressional_District" : null, "Pharmacy_Relationship_Id__name_" : null, "Group_Key" : null, "Group__Start_Date" : null, "Group_Deleted_Date" : null, "Relation_Type" : null, "Relation_Type_Code" : null, "Relation_Address1" : null, "Relation_Address2" : null, "Relation_City_" : null, "Relation_State" : null, "Relation_Zip" : null, "Relation_Phone" : null, "Relation_Phone_Ext" : null, "Relation_Fax" : null, "Relationship_Start_Date" : null, "Relationship_End_Date" : null, "Is_Primary__Y_N" : null, "AO_First_Name" : null, "AO_Middle_Name" : null, "AO_Last_Name" : null, "AO_Contact_Title" : null, "AO_Contact_Email" : null, "AO_Contact_Phone" : null, "AO_Contact_Phone_Ext" : null, "AO_Contact_Fax" : null, "Store_Open_Date" : null, "Store_Close_Date" : null, "Sunday_24_Hours" : null, "Monday_24__Hours" : null, "Tuesday_24__Hours" : null, "Wednesday_24__Hours" : null, "Thursday_24__Hours" : null, "Friday_24_Hours" : null, "Saturday_24__Hours" : null, "Lat" : 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", "supportedSpatialRelationships" : [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelDisjoint", "esriSpatialRelRelation" ], "guidFormat" : "", "supportsContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : true, "maxRecordCount" : 2000, "standardMaxRecordCount" : 16000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Query" }, { "currentVersion" : 12, "id" : 4, "name" : "Closure States O to S", "type" : "Feature Layer", "serviceItemId" : "d1c641e02bff4f9da4c8fd24eb6570da", "cacheMaxAge" : 30, "displayField" : "Pharmacy_Legal_Name", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1714512927997, "schemaLastEditDate" : 1714512927997, "dataLastEditDate" : 1713293163299 }, "relationships" : [], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "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, "supportsReturningQueryGeometry" : true, "enableNullGeometry" : false, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsOutDistance" : true, "supportsReturningQueryExtent" : true, "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" : false, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsDisjointSpatialRel" : 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" : [ "extent", "count" ], "useStandardizedQueries" : true, "geometryType" : "esriGeometryPoint", "minScale" : 0, "maxScale" : 0, "extent" : { "xmin" : -13850437.892743869, "ymin" : 3791141.1154121775, "xmax" : -7925420.1152529186, "ymax" : 5806369.1631428516, "spatialReference" : { "wkid" : 102100, "latestWkid" : 3857 } }, "drawingInfo":{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[255,255,255,255],"size":3,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}, "timeInfo" : { "startTimeField" : "Close_Date", "endTimeField" : "", "trackIdField" : "", "timeExtent" : [ 1388534400000, 1709251200000 ], "timeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "timeInterval" : 10, "timeIntervalUnits" : "esriTimeUnitsUnknown", "exportOptions" : { "useTime" : true, "timeDataCumulative" : false, "TimeOffset" : 0, "timeOffsetUnits" : "esriTimeUnitsCenturies" }, "hasLiveData" : false }, "allowGeometryUpdates" : true, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeAsHTMLText", "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" : "ObjectID", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "OID", "type" : "esriFieldTypeDouble", "alias" : "OID", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "SN", "type" : "esriFieldTypeDouble", "alias" : "SN", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Pharmacy_NCPDP_No", "type" : "esriFieldTypeString", "alias" : "Pharmacy NCPDP No", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Store_Number", "type" : "esriFieldTypeString", "alias" : "Store Number", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Pharmacy_Legal_Name", "type" : "esriFieldTypeString", "alias" : "Pharmacy Legal Name", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Pharmacy_DBA_Name", "type" : "esriFieldTypeString", "alias" : "Pharmacy DBA Name", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Doctor_Name", "type" : "esriFieldTypeString", "alias" : "Doctor Name", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "NPI_Number", "type" : "esriFieldTypeString", "alias" : "NPI Number", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DEA_Number", "type" : "esriFieldTypeString", "alias" : "DEA Number", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Federal_License_Exp__Date", "type" : "esriFieldTypeString", "alias" : "Federal License Exp# Date", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "State_License_No", "type" : "esriFieldTypeString", "alias" : "State License No", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "State_License__Exp__Date", "type" : "esriFieldTypeString", "alias" : "State License Exp# Date", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "License_State", "type" : "esriFieldTypeString", "alias" : "License State", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Dispenser_Class_Code", "type" : "esriFieldTypeString", "alias" : "Dispenser Class_Code", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Dispenser_Type_Code", "type" : "esriFieldTypeString", "alias" : "Dispenser Type Code", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Address1___Physical", "type" : "esriFieldTypeString", "alias" : "Address1 - Physical", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Address2___Physical_", "type" : "esriFieldTypeString", "alias" : "Address2 - Physical_", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "City_Physical", "type" : "esriFieldTypeString", "alias" : "City Physical", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "State_Physical", "type" : "esriFieldTypeString", "alias" : "State Physical", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Zip_Code__as_reported", "type" : "esriFieldTypeString", "alias" : "Zip Code _as reported", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Main_Phone", "type" : "esriFieldTypeString", "alias" : "Main Phone", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Phone_Ext", "type" : "esriFieldTypeString", "alias" : "Phone Ext", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "County_Code", "type" : "esriFieldTypeString", "alias" : "County Code", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "MSA_Code", "type" : "esriFieldTypeString", "alias" : "MSA Code", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PMSA_Code", "type" : "esriFieldTypeString", "alias" : "PMSA Code", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Congressional_District", "type" : "esriFieldTypeString", "alias" : "Congressional District", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Pharmacy_Relationship_Id__name_", "type" : "esriFieldTypeString", "alias" : "Pharmacy Relationship Id (name)", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Group_Key", "type" : "esriFieldTypeString", "alias" : "Group Key", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Group__Start_Date", "type" : "esriFieldTypeString", "alias" : "Group Start Date", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Group_Deleted_Date", "type" : "esriFieldTypeString", "alias" : "Group Deleted Date", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relation_Type", "type" : "esriFieldTypeString", "alias" : "Relation Type", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relation_Type_Code", "type" : "esriFieldTypeString", "alias" : "Relation Type Code", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relation_Address1", "type" : "esriFieldTypeString", "alias" : "Relation Address1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relation_Address2", "type" : "esriFieldTypeString", "alias" : "Relation Address2", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relation_City_", "type" : "esriFieldTypeString", "alias" : "Relation City_", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relation_State", "type" : "esriFieldTypeString", "alias" : "Relation State", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relation_Zip", "type" : "esriFieldTypeString", "alias" : "Relation Zip", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relation_Phone", "type" : "esriFieldTypeString", "alias" : "Relation Phone", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relation_Phone_Ext", "type" : "esriFieldTypeString", "alias" : "Relation Phone Ext", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relation_Fax", "type" : "esriFieldTypeString", "alias" : "Relation Fax", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relationship_Start_Date", "type" : "esriFieldTypeString", "alias" : "Relationship Start Date", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relationship_End_Date", "type" : "esriFieldTypeString", "alias" : "Relationship End Date", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Is_Primary__Y_N", "type" : "esriFieldTypeString", "alias" : "Is Primary?=Y/N", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AO_First_Name", "type" : "esriFieldTypeString", "alias" : "AO First Name", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AO_Middle_Name", "type" : "esriFieldTypeString", "alias" : "AO Middle Name", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AO_Last_Name", "type" : "esriFieldTypeString", "alias" : "AO Last Name", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AO_Contact_Title", "type" : "esriFieldTypeString", "alias" : "AO Contact Title", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AO_Contact_Email", "type" : "esriFieldTypeString", "alias" : "AO Contact Email", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AO_Contact_Phone", "type" : "esriFieldTypeString", "alias" : "AO Contact Phone", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AO_Contact_Phone_Ext", "type" : "esriFieldTypeString", "alias" : "AO Contact Phone Ext", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AO_Contact_Fax", "type" : "esriFieldTypeString", "alias" : "AO Contact Fax", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Store_Open_Date", "type" : "esriFieldTypeString", "alias" : "Store Open Date", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Store_Close_Date", "type" : "esriFieldTypeString", "alias" : "Store Close Date", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Sunday_24_Hours", "type" : "esriFieldTypeString", "alias" : "Sunday 24 Hours", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Monday_24__Hours", "type" : "esriFieldTypeString", "alias" : "Monday 24 _Hours", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Tuesday_24__Hours", "type" : "esriFieldTypeString", "alias" : "Tuesday 24 _Hours", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Wednesday_24__Hours", "type" : "esriFieldTypeString", "alias" : "Wednesday 24 _Hours", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Thursday_24__Hours", "type" : "esriFieldTypeString", "alias" : "Thursday 24 _Hours", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Friday_24_Hours", "type" : "esriFieldTypeString", "alias" : "Friday 24 Hours", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Saturday_24__Hours", "type" : "esriFieldTypeString", "alias" : "Saturday 24 _Hours", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Lat", "type" : "esriFieldTypeDouble", "alias" : "Lat", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Lon", "type" : "esriFieldTypeDouble", "alias" : "Lon", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Close_Date", "type" : "esriFieldTypeDate", "alias" : "Close_Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 } ], "indexes" : [ { "name" : "PK__CLOSURE___F4B70D850B4E96E4", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "user_16849.CLOSURE_MAP_WFL1_CLOSURE_STATES_O_TO_S_Shape_sidx", "fields" : "Shape", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Spatial" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "Closure States O to S", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "Lon" : null, "Close_Date" : null, "OID" : null, "SN" : null, "Pharmacy_NCPDP_No" : null, "Store_Number" : null, "Pharmacy_Legal_Name" : null, "Pharmacy_DBA_Name" : null, "Doctor_Name" : null, "NPI_Number" : null, "DEA_Number" : null, "Federal_License_Exp__Date" : null, "State_License_No" : null, "State_License__Exp__Date" : null, "License_State" : null, "Dispenser_Class_Code" : null, "Dispenser_Type_Code" : null, "Address1___Physical" : null, "Address2___Physical_" : null, "City_Physical" : null, "State_Physical" : null, "Zip_Code__as_reported" : null, "Main_Phone" : null, "Phone_Ext" : null, "County_Code" : null, "MSA_Code" : null, "PMSA_Code" : null, "Congressional_District" : null, "Pharmacy_Relationship_Id__name_" : null, "Group_Key" : null, "Group__Start_Date" : null, "Group_Deleted_Date" : null, "Relation_Type" : null, "Relation_Type_Code" : null, "Relation_Address1" : null, "Relation_Address2" : null, "Relation_City_" : null, "Relation_State" : null, "Relation_Zip" : null, "Relation_Phone" : null, "Relation_Phone_Ext" : null, "Relation_Fax" : null, "Relationship_Start_Date" : null, "Relationship_End_Date" : null, "Is_Primary__Y_N" : null, "AO_First_Name" : null, "AO_Middle_Name" : null, "AO_Last_Name" : null, "AO_Contact_Title" : null, "AO_Contact_Email" : null, "AO_Contact_Phone" : null, "AO_Contact_Phone_Ext" : null, "AO_Contact_Fax" : null, "Store_Open_Date" : null, "Store_Close_Date" : null, "Sunday_24_Hours" : null, "Monday_24__Hours" : null, "Tuesday_24__Hours" : null, "Wednesday_24__Hours" : null, "Thursday_24__Hours" : null, "Friday_24_Hours" : null, "Saturday_24__Hours" : null, "Lat" : 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", "supportedSpatialRelationships" : [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelDisjoint", "esriSpatialRelRelation" ], "guidFormat" : "", "supportsContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : true, "maxRecordCount" : 2000, "standardMaxRecordCount" : 16000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Query" }, { "currentVersion" : 12, "id" : 10, "name" : "Closure States T to W", "type" : "Feature Layer", "serviceItemId" : "d1c641e02bff4f9da4c8fd24eb6570da", "cacheMaxAge" : 30, "displayField" : "Pharmacy_Legal_Name", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1714512927997, "schemaLastEditDate" : 1714512927997, "dataLastEditDate" : 1713293167018 }, "relationships" : [], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "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, "supportsReturningQueryGeometry" : true, "enableNullGeometry" : false, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsOutDistance" : true, "supportsReturningQueryExtent" : true, "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" : false, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsDisjointSpatialRel" : 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" : [ "extent", "count" ], "useStandardizedQueries" : true, "geometryType" : "esriGeometryPoint", "minScale" : 0, "maxScale" : 0, "extent" : { "xmin" : -13788772.109049346, "ymin" : 2985398.4998677317, "xmax" : -8001796.9593441887, "ymax" : 6261307.9675779259, "spatialReference" : { "wkid" : 102100, "latestWkid" : 3857 } }, "drawingInfo":{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[255,255,255,255],"size":3,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}, "timeInfo" : { "startTimeField" : "Close_Date", "endTimeField" : "", "trackIdField" : "", "timeExtent" : [ 1388534400000, 1709251200000 ], "timeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "timeInterval" : 10, "timeIntervalUnits" : "esriTimeUnitsUnknown", "exportOptions" : { "useTime" : true, "timeDataCumulative" : false, "TimeOffset" : 0, "timeOffsetUnits" : "esriTimeUnitsCenturies" }, "hasLiveData" : false }, "allowGeometryUpdates" : true, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeAsHTMLText", "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" : "ObjectID", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "OID", "type" : "esriFieldTypeDouble", "alias" : "OID", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "SN", "type" : "esriFieldTypeDouble", "alias" : "SN", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Pharmacy_NCPDP_No", "type" : "esriFieldTypeString", "alias" : "Pharmacy NCPDP No", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Store_Number", "type" : "esriFieldTypeString", "alias" : "Store Number", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Pharmacy_Legal_Name", "type" : "esriFieldTypeString", "alias" : "Pharmacy Legal Name", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Pharmacy_DBA_Name", "type" : "esriFieldTypeString", "alias" : "Pharmacy DBA Name", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Doctor_Name", "type" : "esriFieldTypeString", "alias" : "Doctor Name", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "NPI_Number", "type" : "esriFieldTypeString", "alias" : "NPI Number", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DEA_Number", "type" : "esriFieldTypeString", "alias" : "DEA Number", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Federal_License_Exp__Date", "type" : "esriFieldTypeString", "alias" : "Federal License Exp# Date", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "State_License_No", "type" : "esriFieldTypeString", "alias" : "State License No", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "State_License__Exp__Date", "type" : "esriFieldTypeString", "alias" : "State License Exp# Date", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "License_State", "type" : "esriFieldTypeString", "alias" : "License State", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Dispenser_Class_Code", "type" : "esriFieldTypeString", "alias" : "Dispenser Class_Code", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Dispenser_Type_Code", "type" : "esriFieldTypeString", "alias" : "Dispenser Type Code", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Address1___Physical", "type" : "esriFieldTypeString", "alias" : "Address1 - Physical", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Address2___Physical_", "type" : "esriFieldTypeString", "alias" : "Address2 - Physical_", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "City_Physical", "type" : "esriFieldTypeString", "alias" : "City Physical", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "State_Physical", "type" : "esriFieldTypeString", "alias" : "State Physical", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Zip_Code__as_reported", "type" : "esriFieldTypeString", "alias" : "Zip Code _as reported", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Main_Phone", "type" : "esriFieldTypeString", "alias" : "Main Phone", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Phone_Ext", "type" : "esriFieldTypeString", "alias" : "Phone Ext", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "County_Code", "type" : "esriFieldTypeString", "alias" : "County Code", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "MSA_Code", "type" : "esriFieldTypeString", "alias" : "MSA Code", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PMSA_Code", "type" : "esriFieldTypeString", "alias" : "PMSA Code", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Congressional_District", "type" : "esriFieldTypeString", "alias" : "Congressional District", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Pharmacy_Relationship_Id__name_", "type" : "esriFieldTypeString", "alias" : "Pharmacy Relationship Id (name)", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Group_Key", "type" : "esriFieldTypeString", "alias" : "Group Key", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Group__Start_Date", "type" : "esriFieldTypeString", "alias" : "Group Start Date", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Group_Deleted_Date", "type" : "esriFieldTypeString", "alias" : "Group Deleted Date", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relation_Type", "type" : "esriFieldTypeString", "alias" : "Relation Type", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relation_Type_Code", "type" : "esriFieldTypeString", "alias" : "Relation Type Code", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relation_Address1", "type" : "esriFieldTypeString", "alias" : "Relation Address1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relation_Address2", "type" : "esriFieldTypeString", "alias" : "Relation Address2", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relation_City_", "type" : "esriFieldTypeString", "alias" : "Relation City_", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relation_State", "type" : "esriFieldTypeString", "alias" : "Relation State", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relation_Zip", "type" : "esriFieldTypeString", "alias" : "Relation Zip", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relation_Phone", "type" : "esriFieldTypeString", "alias" : "Relation Phone", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relation_Phone_Ext", "type" : "esriFieldTypeString", "alias" : "Relation Phone Ext", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relation_Fax", "type" : "esriFieldTypeString", "alias" : "Relation Fax", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relationship_Start_Date", "type" : "esriFieldTypeString", "alias" : "Relationship Start Date", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relationship_End_Date", "type" : "esriFieldTypeString", "alias" : "Relationship End Date", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Is_Primary__Y_N", "type" : "esriFieldTypeString", "alias" : "Is Primary?=Y/N", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AO_First_Name", "type" : "esriFieldTypeString", "alias" : "AO First Name", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AO_Middle_Name", "type" : "esriFieldTypeString", "alias" : "AO Middle Name", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AO_Last_Name", "type" : "esriFieldTypeString", "alias" : "AO Last Name", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AO_Contact_Title", "type" : "esriFieldTypeString", "alias" : "AO Contact Title", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AO_Contact_Email", "type" : "esriFieldTypeString", "alias" : "AO Contact Email", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AO_Contact_Phone", "type" : "esriFieldTypeString", "alias" : "AO Contact Phone", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AO_Contact_Phone_Ext", "type" : "esriFieldTypeString", "alias" : "AO Contact Phone Ext", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AO_Contact_Fax", "type" : "esriFieldTypeString", "alias" : "AO Contact Fax", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Store_Open_Date", "type" : "esriFieldTypeString", "alias" : "Store Open Date", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Store_Close_Date", "type" : "esriFieldTypeString", "alias" : "Store Close Date", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Sunday_24_Hours", "type" : "esriFieldTypeString", "alias" : "Sunday 24 Hours", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Monday_24__Hours", "type" : "esriFieldTypeString", "alias" : "Monday 24 _Hours", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Tuesday_24__Hours", "type" : "esriFieldTypeString", "alias" : "Tuesday 24 _Hours", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Wednesday_24__Hours", "type" : "esriFieldTypeString", "alias" : "Wednesday 24 _Hours", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Thursday_24__Hours", "type" : "esriFieldTypeString", "alias" : "Thursday 24 _Hours", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Friday_24_Hours", "type" : "esriFieldTypeString", "alias" : "Friday 24 Hours", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Saturday_24__Hours", "type" : "esriFieldTypeString", "alias" : "Saturday 24 _Hours", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Lat", "type" : "esriFieldTypeDouble", "alias" : "Lat", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Lon", "type" : "esriFieldTypeDouble", "alias" : "Lon", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Close_Date", "type" : "esriFieldTypeDate", "alias" : "Close_Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 } ], "indexes" : [ { "name" : "PK__CLOSURE___F4B70D859809FE92", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "user_16849.CLOSURE_MAP_WFL1_CLOSURE_STATES_T_TO_W_Shape_sidx", "fields" : "Shape", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Spatial" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "Closure States T to W", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "Lon" : null, "Close_Date" : null, "OID" : null, "SN" : null, "Pharmacy_NCPDP_No" : null, "Store_Number" : null, "Pharmacy_Legal_Name" : null, "Pharmacy_DBA_Name" : null, "Doctor_Name" : null, "NPI_Number" : null, "DEA_Number" : null, "Federal_License_Exp__Date" : null, "State_License_No" : null, "State_License__Exp__Date" : null, "License_State" : null, "Dispenser_Class_Code" : null, "Dispenser_Type_Code" : null, "Address1___Physical" : null, "Address2___Physical_" : null, "City_Physical" : null, "State_Physical" : null, "Zip_Code__as_reported" : null, "Main_Phone" : null, "Phone_Ext" : null, "County_Code" : null, "MSA_Code" : null, "PMSA_Code" : null, "Congressional_District" : null, "Pharmacy_Relationship_Id__name_" : null, "Group_Key" : null, "Group__Start_Date" : null, "Group_Deleted_Date" : null, "Relation_Type" : null, "Relation_Type_Code" : null, "Relation_Address1" : null, "Relation_Address2" : null, "Relation_City_" : null, "Relation_State" : null, "Relation_Zip" : null, "Relation_Phone" : null, "Relation_Phone_Ext" : null, "Relation_Fax" : null, "Relationship_Start_Date" : null, "Relationship_End_Date" : null, "Is_Primary__Y_N" : null, "AO_First_Name" : null, "AO_Middle_Name" : null, "AO_Last_Name" : null, "AO_Contact_Title" : null, "AO_Contact_Email" : null, "AO_Contact_Phone" : null, "AO_Contact_Phone_Ext" : null, "AO_Contact_Fax" : null, "Store_Open_Date" : null, "Store_Close_Date" : null, "Sunday_24_Hours" : null, "Monday_24__Hours" : null, "Tuesday_24__Hours" : null, "Wednesday_24__Hours" : null, "Thursday_24__Hours" : null, "Friday_24_Hours" : null, "Saturday_24__Hours" : null, "Lat" : 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", "supportedSpatialRelationships" : [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelDisjoint", "esriSpatialRelRelation" ], "guidFormat" : "", "supportsContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : true, "maxRecordCount" : 2000, "standardMaxRecordCount" : 16000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Query" }, { "currentVersion" : 12, "id" : 6, "name" : "US States", "type" : "Feature Layer", "serviceItemId" : "d1c641e02bff4f9da4c8fd24eb6570da", "cacheMaxAge" : 30, "displayField" : "NAME", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1714512927997, "schemaLastEditDate" : 1714512927997, "dataLastEditDate" : 1713293167440 }, "relationships" : [], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "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, "supportsMultiScaleGeometry" : true, "supportsReturningQueryGeometry" : true, "enableNullGeometry" : false, "hasGeometryProperties" : true, "geometryProperties" : { "shapeAreaFieldName" : "Shape__Area", "shapeLengthFieldName" : "Shape__Length" }, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsOutDistance" : true, "supportsReturningQueryExtent" : true, "supportsStatistics" : true, "supportsOrderBy" : true, "supportsDistinct" : true, "supportsQueryWithResultType" : true, "supportsSqlExpression" : true, "supportsTimeRelation" : true, "supportsAdvancedQueryRelated" : true, "supportsCountDistinct" : true, "supportsPercentileStatistics" : true, "supportsApproxPercentileStatistics" : true, "supportsSpatialAggregationStatistics" : true, "supportsTrueCurve" : true, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : true, "supportsReturningGeometryEnvelope" : true, "supportsReturningGeometryProperties" : true, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsDisjointSpatialRel" : 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" : [ "extent", "count" ], "useStandardizedQueries" : true, "geometryType" : "esriGeometryPolygon", "minScale" : 0, "maxScale" : 0, "extent" : { "xmin" : -19942593.909852218, "ymin" : -1637687.2815975128, "xmax" : 20012846.363988128, "ymax" : 11523916.32477694, "spatialReference" : { "wkid" : 102100, "latestWkid" : 3857 } }, "drawingInfo":{"renderer":{"type":"simple","symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[222,252,207,0],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[225,225,225,255],"width":0.5}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}, "allowGeometryUpdates" : true, "trueCurveSupportMode" : "OGC", "supportedCurveTypes" : [ "esriGeometryCircularArc" ], "supportedTrueCurvePbfFeatureEncodings" : [ "esriCompressedShapeBuffer", "esriDefault" ], "allowTrueCurvesUpdates" : true, "onlyAllowTrueCurveUpdatesByTrueCurveClients" : false, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeAsHTMLText", "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" : "OBJECTID", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "STATEFP", "type" : "esriFieldTypeString", "alias" : "STATEFP", "sqlType" : "sqlTypeOther", "length" : 2, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "STATENS", "type" : "esriFieldTypeString", "alias" : "STATENS", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AFFGEOID", "type" : "esriFieldTypeString", "alias" : "AFFGEOID", "sqlType" : "sqlTypeOther", "length" : 11, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "GEOID", "type" : "esriFieldTypeString", "alias" : "GEOID", "sqlType" : "sqlTypeOther", "length" : 2, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "STUSPS", "type" : "esriFieldTypeString", "alias" : "STUSPS", "sqlType" : "sqlTypeOther", "length" : 2, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "NAME", "type" : "esriFieldTypeString", "alias" : "NAME", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LSAD", "type" : "esriFieldTypeString", "alias" : "LSAD", "sqlType" : "sqlTypeOther", "length" : 2, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ALAND", "type" : "esriFieldTypeDouble", "alias" : "ALAND", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AWATER", "type" : "esriFieldTypeDouble", "alias" : "AWATER", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Shape__Area", "type" : "esriFieldTypeDouble", "alias" : "Shape__Area", "sqlType" : "sqlTypeDouble", "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "Shape__Length", "type" : "esriFieldTypeDouble", "alias" : "Shape__Length", "sqlType" : "sqlTypeDouble", "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__CLOSURE___F4B70D857CEDE8A7", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "user_16849.CLOSURE_MAP_WFL1_US_STATES_Shape_sidx", "fields" : "Shape", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Spatial" }, { "name" : "Shape__Area_Index", "fields" : "Shape__Area", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "Shape__Length_Index", "fields" : "Shape__Length", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "US States", "description" : "", "drawingTool" : "esriFeatureEditToolPolygon", "prototype" : { "attributes" : { "ALAND" : null, "AWATER" : null, "STATEFP" : null, "STATENS" : null, "AFFGEOID" : null, "GEOID" : null, "STUSPS" : null, "NAME" : null, "LSAD" : 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", "supportedSpatialRelationships" : [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelDisjoint", "esriSpatialRelRelation" ], "guidFormat" : "", "supportsContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : true, "maxRecordCount" : 2000, "standardMaxRecordCount" : 2000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 4000, "maxRecordCountFactor" : 1, "capabilities" : "Query" } ], "tables" : [ { "currentVersion" : 12, "id" : 12, "name" : "Closure_AC", "type" : "Table", "serviceItemId" : "d1c641e02bff4f9da4c8fd24eb6570da", "cacheMaxAge" : 30, "displayField" : "Pharmacy_Legal_Name", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1714512927997, "schemaLastEditDate" : 1714512927997, "dataLastEditDate" : 1713293169846 }, "relationships" : [], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "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" : "ObjectID", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "OID", "type" : "esriFieldTypeDouble", "alias" : "OID", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "SN", "type" : "esriFieldTypeDouble", "alias" : "SN", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Pharmacy_NCPDP_No", "type" : "esriFieldTypeString", "alias" : "Pharmacy NCPDP No", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Store_Number", "type" : "esriFieldTypeString", "alias" : "Store Number", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Pharmacy_Legal_Name", "type" : "esriFieldTypeString", "alias" : "Pharmacy Legal Name", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Pharmacy_DBA_Name", "type" : "esriFieldTypeString", "alias" : "Pharmacy DBA Name", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Doctor_Name", "type" : "esriFieldTypeString", "alias" : "Doctor Name", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "NPI_Number", "type" : "esriFieldTypeString", "alias" : "NPI Number", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DEA_Number", "type" : "esriFieldTypeString", "alias" : "DEA Number", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Federal_License_Exp__Date", "type" : "esriFieldTypeString", "alias" : "Federal License Exp# Date", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "State_License_No", "type" : "esriFieldTypeString", "alias" : "State License No", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "State_License__Exp__Date", "type" : "esriFieldTypeString", "alias" : "State License Exp# Date", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "License_State", "type" : "esriFieldTypeString", "alias" : "License State", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Dispenser_Class_Code", "type" : "esriFieldTypeString", "alias" : "Dispenser Class_Code", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Dispenser_Type_Code", "type" : "esriFieldTypeString", "alias" : "Dispenser Type Code", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Address1___Physical", "type" : "esriFieldTypeString", "alias" : "Address1 - Physical", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Address2___Physical_", "type" : "esriFieldTypeString", "alias" : "Address2 - Physical_", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "City_Physical", "type" : "esriFieldTypeString", "alias" : "City Physical", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "State_Physical", "type" : "esriFieldTypeString", "alias" : "State Physical", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Zip_Code__as_reported", "type" : "esriFieldTypeString", "alias" : "Zip Code _as reported", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Main_Phone", "type" : "esriFieldTypeString", "alias" : "Main Phone", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Phone_Ext", "type" : "esriFieldTypeString", "alias" : "Phone Ext", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "County_Code", "type" : "esriFieldTypeString", "alias" : "County Code", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "MSA_Code", "type" : "esriFieldTypeString", "alias" : "MSA Code", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PMSA_Code", "type" : "esriFieldTypeString", "alias" : "PMSA Code", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Congressional_District", "type" : "esriFieldTypeString", "alias" : "Congressional District", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Pharmacy_Relationship_Id__name_", "type" : "esriFieldTypeString", "alias" : "Pharmacy Relationship Id (name)", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Group_Key", "type" : "esriFieldTypeString", "alias" : "Group Key", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Group__Start_Date", "type" : "esriFieldTypeString", "alias" : "Group Start Date", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Group_Deleted_Date", "type" : "esriFieldTypeString", "alias" : "Group Deleted Date", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relation_Type", "type" : "esriFieldTypeString", "alias" : "Relation Type", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relation_Type_Code", "type" : "esriFieldTypeString", "alias" : "Relation Type Code", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relation_Address1", "type" : "esriFieldTypeString", "alias" : "Relation Address1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relation_Address2", "type" : "esriFieldTypeString", "alias" : "Relation Address2", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relation_City_", "type" : "esriFieldTypeString", "alias" : "Relation City_", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relation_State", "type" : "esriFieldTypeString", "alias" : "Relation State", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relation_Zip", "type" : "esriFieldTypeString", "alias" : "Relation Zip", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relation_Phone", "type" : "esriFieldTypeString", "alias" : "Relation Phone", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relation_Phone_Ext", "type" : "esriFieldTypeString", "alias" : "Relation Phone Ext", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relation_Fax", "type" : "esriFieldTypeString", "alias" : "Relation Fax", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relationship_Start_Date", "type" : "esriFieldTypeString", "alias" : "Relationship Start Date", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relationship_End_Date", "type" : "esriFieldTypeString", "alias" : "Relationship End Date", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Is_Primary__Y_N", "type" : "esriFieldTypeString", "alias" : "Is Primary?=Y/N", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AO_First_Name", "type" : "esriFieldTypeString", "alias" : "AO First Name", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AO_Middle_Name", "type" : "esriFieldTypeString", "alias" : "AO Middle Name", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AO_Last_Name", "type" : "esriFieldTypeString", "alias" : "AO Last Name", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AO_Contact_Title", "type" : "esriFieldTypeString", "alias" : "AO Contact Title", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AO_Contact_Email", "type" : "esriFieldTypeString", "alias" : "AO Contact Email", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AO_Contact_Phone", "type" : "esriFieldTypeString", "alias" : "AO Contact Phone", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AO_Contact_Phone_Ext", "type" : "esriFieldTypeString", "alias" : "AO Contact Phone Ext", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AO_Contact_Fax", "type" : "esriFieldTypeString", "alias" : "AO Contact Fax", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Store_Open_Date", "type" : "esriFieldTypeString", "alias" : "Store Open Date", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Store_Close_Date", "type" : "esriFieldTypeString", "alias" : "Store Close Date", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Sunday_24_Hours", "type" : "esriFieldTypeString", "alias" : "Sunday 24 Hours", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Monday_24__Hours", "type" : "esriFieldTypeString", "alias" : "Monday 24 _Hours", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Tuesday_24__Hours", "type" : "esriFieldTypeString", "alias" : "Tuesday 24 _Hours", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Wednesday_24__Hours", "type" : "esriFieldTypeString", "alias" : "Wednesday 24 _Hours", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Thursday_24__Hours", "type" : "esriFieldTypeString", "alias" : "Thursday 24 _Hours", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Friday_24_Hours", "type" : "esriFieldTypeString", "alias" : "Friday 24 Hours", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Saturday_24__Hours", "type" : "esriFieldTypeString", "alias" : "Saturday 24 _Hours", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Lat", "type" : "esriFieldTypeDouble", "alias" : "Lat", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Lon", "type" : "esriFieldTypeDouble", "alias" : "Lon", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__CLOSURE___F4B70D8542A2F8BD", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "Closure_AC", "description" : "", "drawingTool" : "esriFeatureEditToolNone", "prototype" : { "attributes" : { "Lat" : null, "Lon" : null, "OID" : null, "SN" : null, "Pharmacy_NCPDP_No" : null, "Store_Number" : null, "Pharmacy_Legal_Name" : null, "Pharmacy_DBA_Name" : null, "Doctor_Name" : null, "NPI_Number" : null, "DEA_Number" : null, "Federal_License_Exp__Date" : null, "State_License_No" : null, "State_License__Exp__Date" : null, "License_State" : null, "Dispenser_Class_Code" : null, "Dispenser_Type_Code" : null, "Address1___Physical" : null, "Address2___Physical_" : null, "City_Physical" : null, "State_Physical" : null, "Zip_Code__as_reported" : null, "Main_Phone" : null, "Phone_Ext" : null, "County_Code" : null, "MSA_Code" : null, "PMSA_Code" : null, "Congressional_District" : null, "Pharmacy_Relationship_Id__name_" : null, "Group_Key" : null, "Group__Start_Date" : null, "Group_Deleted_Date" : null, "Relation_Type" : null, "Relation_Type_Code" : null, "Relation_Address1" : null, "Relation_Address2" : null, "Relation_City_" : null, "Relation_State" : null, "Relation_Zip" : null, "Relation_Phone" : null, "Relation_Phone_Ext" : null, "Relation_Fax" : null, "Relationship_Start_Date" : null, "Relationship_End_Date" : null, "Is_Primary__Y_N" : null, "AO_First_Name" : null, "AO_Middle_Name" : null, "AO_Last_Name" : null, "AO_Contact_Title" : null, "AO_Contact_Email" : null, "AO_Contact_Phone" : null, "AO_Contact_Phone_Ext" : null, "AO_Contact_Fax" : null, "Store_Open_Date" : null, "Store_Close_Date" : null, "Sunday_24_Hours" : null, "Monday_24__Hours" : null, "Tuesday_24__Hours" : null, "Wednesday_24__Hours" : null, "Thursday_24__Hours" : null, "Friday_24_Hours" : null, "Saturday_24__Hours" : 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" : true, "maxRecordCount" : 2000, "standardMaxRecordCount" : 32000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Query" }, { "currentVersion" : 12, "id" : 13, "name" : "Closure_DL", "type" : "Table", "serviceItemId" : "d1c641e02bff4f9da4c8fd24eb6570da", "cacheMaxAge" : 30, "displayField" : "Pharmacy_Legal_Name", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1714512927997, "schemaLastEditDate" : 1714512927997, "dataLastEditDate" : 1713293173440 }, "relationships" : [], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "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" : "ObjectID", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "OID", "type" : "esriFieldTypeDouble", "alias" : "OID", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "SN", "type" : "esriFieldTypeDouble", "alias" : "SN", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Pharmacy_NCPDP_No", "type" : "esriFieldTypeString", "alias" : "Pharmacy NCPDP No", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Store_Number", "type" : "esriFieldTypeString", "alias" : "Store Number", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Pharmacy_Legal_Name", "type" : "esriFieldTypeString", "alias" : "Pharmacy Legal Name", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Pharmacy_DBA_Name", "type" : "esriFieldTypeString", "alias" : "Pharmacy DBA Name", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Doctor_Name", "type" : "esriFieldTypeString", "alias" : "Doctor Name", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "NPI_Number", "type" : "esriFieldTypeString", "alias" : "NPI Number", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DEA_Number", "type" : "esriFieldTypeString", "alias" : "DEA Number", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Federal_License_Exp__Date", "type" : "esriFieldTypeString", "alias" : "Federal License Exp# Date", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "State_License_No", "type" : "esriFieldTypeString", "alias" : "State License No", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "State_License__Exp__Date", "type" : "esriFieldTypeString", "alias" : "State License Exp# Date", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "License_State", "type" : "esriFieldTypeString", "alias" : "License State", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Dispenser_Class_Code", "type" : "esriFieldTypeString", "alias" : "Dispenser Class_Code", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Dispenser_Type_Code", "type" : "esriFieldTypeString", "alias" : "Dispenser Type Code", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Address1___Physical", "type" : "esriFieldTypeString", "alias" : "Address1 - Physical", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Address2___Physical_", "type" : "esriFieldTypeString", "alias" : "Address2 - Physical_", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "City_Physical", "type" : "esriFieldTypeString", "alias" : "City Physical", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "State_Physical", "type" : "esriFieldTypeString", "alias" : "State Physical", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Zip_Code__as_reported", "type" : "esriFieldTypeString", "alias" : "Zip Code _as reported", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Main_Phone", "type" : "esriFieldTypeString", "alias" : "Main Phone", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Phone_Ext", "type" : "esriFieldTypeString", "alias" : "Phone Ext", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "County_Code", "type" : "esriFieldTypeString", "alias" : "County Code", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "MSA_Code", "type" : "esriFieldTypeString", "alias" : "MSA Code", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PMSA_Code", "type" : "esriFieldTypeString", "alias" : "PMSA Code", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Congressional_District", "type" : "esriFieldTypeString", "alias" : "Congressional District", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Pharmacy_Relationship_Id__name_", "type" : "esriFieldTypeString", "alias" : "Pharmacy Relationship Id (name)", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Group_Key", "type" : "esriFieldTypeString", "alias" : "Group Key", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Group__Start_Date", "type" : "esriFieldTypeString", "alias" : "Group Start Date", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Group_Deleted_Date", "type" : "esriFieldTypeString", "alias" : "Group Deleted Date", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relation_Type", "type" : "esriFieldTypeString", "alias" : "Relation Type", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relation_Type_Code", "type" : "esriFieldTypeString", "alias" : "Relation Type Code", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relation_Address1", "type" : "esriFieldTypeString", "alias" : "Relation Address1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relation_Address2", "type" : "esriFieldTypeString", "alias" : "Relation Address2", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relation_City_", "type" : "esriFieldTypeString", "alias" : "Relation City_", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relation_State", "type" : "esriFieldTypeString", "alias" : "Relation State", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relation_Zip", "type" : "esriFieldTypeString", "alias" : "Relation Zip", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relation_Phone", "type" : "esriFieldTypeString", "alias" : "Relation Phone", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relation_Phone_Ext", "type" : "esriFieldTypeString", "alias" : "Relation Phone Ext", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relation_Fax", "type" : "esriFieldTypeString", "alias" : "Relation Fax", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relationship_Start_Date", "type" : "esriFieldTypeString", "alias" : "Relationship Start Date", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relationship_End_Date", "type" : "esriFieldTypeString", "alias" : "Relationship End Date", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Is_Primary__Y_N", "type" : "esriFieldTypeString", "alias" : "Is Primary?=Y/N", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AO_First_Name", "type" : "esriFieldTypeString", "alias" : "AO First Name", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AO_Middle_Name", "type" : "esriFieldTypeString", "alias" : "AO Middle Name", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AO_Last_Name", "type" : "esriFieldTypeString", "alias" : "AO Last Name", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AO_Contact_Title", "type" : "esriFieldTypeString", "alias" : "AO Contact Title", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AO_Contact_Email", "type" : "esriFieldTypeString", "alias" : "AO Contact Email", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AO_Contact_Phone", "type" : "esriFieldTypeString", "alias" : "AO Contact Phone", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AO_Contact_Phone_Ext", "type" : "esriFieldTypeString", "alias" : "AO Contact Phone Ext", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AO_Contact_Fax", "type" : "esriFieldTypeString", "alias" : "AO Contact Fax", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Store_Open_Date", "type" : "esriFieldTypeString", "alias" : "Store Open Date", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Store_Close_Date", "type" : "esriFieldTypeString", "alias" : "Store Close Date", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Sunday_24_Hours", "type" : "esriFieldTypeString", "alias" : "Sunday 24 Hours", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Monday_24__Hours", "type" : "esriFieldTypeString", "alias" : "Monday 24 _Hours", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Tuesday_24__Hours", "type" : "esriFieldTypeString", "alias" : "Tuesday 24 _Hours", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Wednesday_24__Hours", "type" : "esriFieldTypeString", "alias" : "Wednesday 24 _Hours", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Thursday_24__Hours", "type" : "esriFieldTypeString", "alias" : "Thursday 24 _Hours", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Friday_24_Hours", "type" : "esriFieldTypeString", "alias" : "Friday 24 Hours", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Saturday_24__Hours", "type" : "esriFieldTypeString", "alias" : "Saturday 24 _Hours", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Lat", "type" : "esriFieldTypeDouble", "alias" : "Lat", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Lon", "type" : "esriFieldTypeDouble", "alias" : "Lon", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__CLOSURE___F4B70D85F9721F75", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "Closure_DL", "description" : "", "drawingTool" : "esriFeatureEditToolNone", "prototype" : { "attributes" : { "Lat" : null, "Lon" : null, "OID" : null, "SN" : null, "Pharmacy_NCPDP_No" : null, "Store_Number" : null, "Pharmacy_Legal_Name" : null, "Pharmacy_DBA_Name" : null, "Doctor_Name" : null, "NPI_Number" : null, "DEA_Number" : null, "Federal_License_Exp__Date" : null, "State_License_No" : null, "State_License__Exp__Date" : null, "License_State" : null, "Dispenser_Class_Code" : null, "Dispenser_Type_Code" : null, "Address1___Physical" : null, "Address2___Physical_" : null, "City_Physical" : null, "State_Physical" : null, "Zip_Code__as_reported" : null, "Main_Phone" : null, "Phone_Ext" : null, "County_Code" : null, "MSA_Code" : null, "PMSA_Code" : null, "Congressional_District" : null, "Pharmacy_Relationship_Id__name_" : null, "Group_Key" : null, "Group__Start_Date" : null, "Group_Deleted_Date" : null, "Relation_Type" : null, "Relation_Type_Code" : null, "Relation_Address1" : null, "Relation_Address2" : null, "Relation_City_" : null, "Relation_State" : null, "Relation_Zip" : null, "Relation_Phone" : null, "Relation_Phone_Ext" : null, "Relation_Fax" : null, "Relationship_Start_Date" : null, "Relationship_End_Date" : null, "Is_Primary__Y_N" : null, "AO_First_Name" : null, "AO_Middle_Name" : null, "AO_Last_Name" : null, "AO_Contact_Title" : null, "AO_Contact_Email" : null, "AO_Contact_Phone" : null, "AO_Contact_Phone_Ext" : null, "AO_Contact_Fax" : null, "Store_Open_Date" : null, "Store_Close_Date" : null, "Sunday_24_Hours" : null, "Monday_24__Hours" : null, "Tuesday_24__Hours" : null, "Wednesday_24__Hours" : null, "Thursday_24__Hours" : null, "Friday_24_Hours" : null, "Saturday_24__Hours" : 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" : true, "maxRecordCount" : 2000, "standardMaxRecordCount" : 32000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Query" }, { "currentVersion" : 12, "id" : 14, "name" : "Closure_M", "type" : "Table", "serviceItemId" : "d1c641e02bff4f9da4c8fd24eb6570da", "cacheMaxAge" : 30, "displayField" : "Pharmacy_Legal_Name", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1714512927997, "schemaLastEditDate" : 1714512927997, "dataLastEditDate" : 1713293175471 }, "relationships" : [], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "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" : "ObjectID", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "OID", "type" : "esriFieldTypeDouble", "alias" : "OID", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "SN", "type" : "esriFieldTypeDouble", "alias" : "SN", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Pharmacy_NCPDP_No", "type" : "esriFieldTypeString", "alias" : "Pharmacy NCPDP No", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Store_Number", "type" : "esriFieldTypeString", "alias" : "Store Number", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Pharmacy_Legal_Name", "type" : "esriFieldTypeString", "alias" : "Pharmacy Legal Name", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Pharmacy_DBA_Name", "type" : "esriFieldTypeString", "alias" : "Pharmacy DBA Name", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Doctor_Name", "type" : "esriFieldTypeString", "alias" : "Doctor Name", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "NPI_Number", "type" : "esriFieldTypeString", "alias" : "NPI Number", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DEA_Number", "type" : "esriFieldTypeString", "alias" : "DEA Number", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Federal_License_Exp__Date", "type" : "esriFieldTypeString", "alias" : "Federal License Exp# Date", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "State_License_No", "type" : "esriFieldTypeString", "alias" : "State License No", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "State_License__Exp__Date", "type" : "esriFieldTypeString", "alias" : "State License Exp# Date", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "License_State", "type" : "esriFieldTypeString", "alias" : "License State", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Dispenser_Class_Code", "type" : "esriFieldTypeString", "alias" : "Dispenser Class_Code", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Dispenser_Type_Code", "type" : "esriFieldTypeString", "alias" : "Dispenser Type Code", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Address1___Physical", "type" : "esriFieldTypeString", "alias" : "Address1 - Physical", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Address2___Physical_", "type" : "esriFieldTypeString", "alias" : "Address2 - Physical_", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "City_Physical", "type" : "esriFieldTypeString", "alias" : "City Physical", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "State_Physical", "type" : "esriFieldTypeString", "alias" : "State Physical", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Zip_Code__as_reported", "type" : "esriFieldTypeString", "alias" : "Zip Code _as reported", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Main_Phone", "type" : "esriFieldTypeString", "alias" : "Main Phone", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Phone_Ext", "type" : "esriFieldTypeString", "alias" : "Phone Ext", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "County_Code", "type" : "esriFieldTypeString", "alias" : "County Code", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "MSA_Code", "type" : "esriFieldTypeString", "alias" : "MSA Code", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PMSA_Code", "type" : "esriFieldTypeString", "alias" : "PMSA Code", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Congressional_District", "type" : "esriFieldTypeString", "alias" : "Congressional District", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Pharmacy_Relationship_Id__name_", "type" : "esriFieldTypeString", "alias" : "Pharmacy Relationship Id (name)", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Group_Key", "type" : "esriFieldTypeString", "alias" : "Group Key", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Group__Start_Date", "type" : "esriFieldTypeString", "alias" : "Group Start Date", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Group_Deleted_Date", "type" : "esriFieldTypeString", "alias" : "Group Deleted Date", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relation_Type", "type" : "esriFieldTypeString", "alias" : "Relation Type", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relation_Type_Code", "type" : "esriFieldTypeString", "alias" : "Relation Type Code", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relation_Address1", "type" : "esriFieldTypeString", "alias" : "Relation Address1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relation_Address2", "type" : "esriFieldTypeString", "alias" : "Relation Address2", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relation_City_", "type" : "esriFieldTypeString", "alias" : "Relation City_", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relation_State", "type" : "esriFieldTypeString", "alias" : "Relation State", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relation_Zip", "type" : "esriFieldTypeString", "alias" : "Relation Zip", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relation_Phone", "type" : "esriFieldTypeString", "alias" : "Relation Phone", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relation_Phone_Ext", "type" : "esriFieldTypeString", "alias" : "Relation Phone Ext", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relation_Fax", "type" : "esriFieldTypeString", "alias" : "Relation Fax", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relationship_Start_Date", "type" : "esriFieldTypeString", "alias" : "Relationship Start Date", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Relationship_End_Date", "type" : "esriFieldTypeString", "alias" : "Relationship End Date", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Is_Primary__Y_N", "type" : "esriFieldTypeString", "alias" : "Is Primary?=Y/N", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AO_First_Name", "type" : "esriFieldTypeString", "alias" : "AO First Name", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AO_Middle_Name", "type" : "esriFieldTypeString", "alias" : "AO Middle Name", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AO_Last_Name", "type" : "esriFieldTypeString", "alias" : "AO Last Name", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AO_Contact_Title", "type" : "esriFieldTypeString", "alias" : "AO Contact Title", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AO_Contact_Email", "type" : "esriFieldTypeString", "alias" : "AO Contact Email", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AO_Contact_Phone", "type" : "esriFieldTypeString", "alias" : "AO Contact Phone", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AO_Contact_Phone_Ext", "type" : "esriFieldTypeString", "alias" : "AO Contact Phone Ext", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AO_Contact_Fax", "type" : "esriFieldTypeString", "alias" : "AO Contact Fax", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Store_Open_Date", "type" : "esriFieldTypeString", "alias" : "Store Open Date", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Store_Close_Date", "type" : "esriFieldTypeString", "alias" : "Store Close Date", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Sunday_24_Hours", "type" : "esriFieldTypeString", "alias" : "Sunday 24 Hours", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Monday_24__Hours", "type" : "esriFieldTypeString", "alias" : "Monday 24 _Hours", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Tuesday_24__Hours", "type" : "esriFieldTypeString", "alias" : "Tuesday 24 _Hours", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Wednesday_24__Hours", "type" : "esriFieldTypeString", "alias" : "Wednesday 24 _Hours", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Thursday_24__Hours", "type" : "esriFieldTypeString", "alias" : "Thursday 24 _Hours", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Friday_24_Hours", "type" : "esriFieldTypeString", "alias" : "Friday 24 Hours", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Saturday_24__Hours", "type" : "esriFieldTypeString", "alias" : "Saturday 24 _Hours", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Lat", "type" : "esriFieldTypeDouble", "alias" : "Lat", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Lon", "type" : "esriFieldTypeDouble", "alias" : "Lon", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__CLOSURE___F4B70D851AE139FE", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "Closure_M", "description" : "", "drawingTool" : "esriFeatureEditToolNone", "prototype" : { "attributes" : { "Lat" : null, "Lon" : null, "OID" : null, "SN" : null, "Pharmacy_NCPDP_No" : null, "Store_Number" : null, "Pharmacy_Legal_Name" : null, "Pharmacy_DBA_Name" : null, "Doctor_Name" : null, "NPI_Number" : null, "DEA_Number" : null, "Federal_License_Exp__Date" : null, "State_License_No" : null, "State_License__Exp__Date" : null, "License_State" : null, "Dispenser_Class_Code" : null, "Dispenser_Type_Code" : null, "Address1___Physical" : null, "Address2___Physical_" : null, "City_Physical" : null, "State_Physical" : null, "Zip_Code__as_reported" : null, "Main_Phone" : null, "Phone_Ext" : null, "County_Code" : null, "MSA_Code" : null, "PMSA_Code" : null, "Congressional_District" : null, "Pharmacy_Relationship_Id__name_" : null, "Group_Key" : null, "Group__Start_Date" : null, "Group_Deleted_Date" : null, "Relation_Type" : null, "Relation_Type_Code" : null, "Relation_Address1" : null, "Relation_Address2" : null, "Relation_City_" : null, "Relation_State" : null, "Relation_Zip" : null, "Relation_Phone" : null, "Relation_Phone_Ext" : null, "Relation_Fax" : null, "Relationship_Start_Date" : null, "Relationship_End_Date" : null, "Is_Primary__Y_N" : null, "AO_First_Name" : null, "AO_Middle_Name" : null, "AO_Last_Name" : null, "AO_Contact_Title" : null, "AO_Contact_Email" : null, "AO_Contact_Phone" : null, "AO_Contact_Phone_Ext" : null, "AO_Contact_Fax" : null, "Store_Open_Date" : null, "Store_Close_Date" : null, "Sunday_24_Hours" : null, "Monday_24__Hours" : null, "Tuesday_24__Hours" : null, "Wednesday_24__Hours" : null, "Thursday_24__Hours" : null, "Friday_24_Hours" : null, "Saturday_24__Hours" : 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" : true, "maxRecordCount" : 2000, "standardMaxRecordCount" : 32000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Query" } ] }